Concurrent programm request error [message #204148] |
Sat, 18 November 2006 03:56 |
sauami
Messages: 54 Registered: October 2005 Location: india
|
Member |
|
|
Dear Sir,
While executing below mentioned concurrent programm i got below mention error., kindly let me know how to resolve the bug.
Thanks,
Saurabh
Procedure is:
CREATE OR REPLACE PROCEDURE EEX_RELEASE_CUSTOM_WAIT_PRC
(retcode OUT VARCHAR2,
errbuf OUT VARCHAR2)
AS
CURSOR cur_item_key IS
SELECT oel.Global_attribute5
FROM wsh_delivery_details wdd,
oe_order_lines_all oel,
wsh_new_deliveries wnd,
wsh_delivery_assignments wda,
wsh_delivery_legs wdl
WHERE wda.delivery_detail_id=wdd.delivery_detail_id
and wda.delivery_id=wnd.delivery_id
and wnd.delivery_id=wdl.delivery_id
AND oel.line_id = wdd.source_line_id
AND oel.Global_attribute5 IS NOT NULL
AND wdd.inv_interfaced_flag = 'Y'
AND wdd.oe_interfaced_flag = 'Y'
AND wdl.booking_number is not null
AND oel.line_id=nvl(null,oel.line_id)
AND oel.Global_attribute5 <> 'RELEASED';
Lv_activity_name VARCHAR2(100);
Ln_activity_id NUMBER;
lc_activity_status VARCHAR2(100);
Ln_line_id NUMBER;
BEGIN
--Loop for all records
FOR cur_item_key_rec IN cur_item_key
LOOP
Lv_activity_name := 'WAIT_FOR_INV_INTERFACE';
Ln_activity_id := WF_ENGINE.GetItemAttrNumber
(Itemtype => 'OEOL',
Itemkey => TO_CHAR (cur_item_key_rec.Global_attribute5),
Aname => Lv_activity_name);
BEGIN
SELECT activity_status
INTO lc_activity_status
FROM wf_item_activity_statuses wias
WHERE wias.item_type = 'OEOL'
AND wias.item_key = TO_CHAR (cur_item_key_rec.Global_attribute5)
AND wias.process_activity = Ln_activity_id;
EXCEPTION
WHEN NO_DATA_FOUND THEN
lc_activity_status := NULL;
WHEN OTHERS THEN
lc_activity_status := NULL;
END;
IF (lc_activity_status != 'NOT_REACHED'
OR lc_activity_status != 'COMPLETE'
OR lc_activity_status != 'ERROR'
OR lc_activity_status IS NOT NULL)
THEN
WF_ENGINE.COMPLETEACTIVITY(
itemtype=>'OEOL',
itemkey=> cur_item_key_rec.Global_attribute5,
activity=>'EEX_WAIT_INV_INTERFACE_PRC',
result=>'COMPLETE');
END IF;
--Update attribute5 of oe_order_lines_all to ¿RELEASED¿
UPDATE oe_order_lines_all
SET Global_attribute5 = 'RELEASED'
WHERE line_id = TO_CHAR (cur_item_key_rec.Global_attribute5) ;
COMMIT;
END LOOP ;
END;
/
-------------------
Error Log:
--------------
ORACLE error 20002 in FDPSTP
Cause: FDPSTP failed due to ORA-20002: 3133: Activity instance 'EEX_WAIT_INV_INTERFACE_PRC' is not a notified activity for item 'OEOL/7136093'.
ORA-06512: at "APPS.WF_ENGINE", line 5267
ORA-06512: at "APPS.EEX
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
Executing request completion options...
Finished executing request completion options.
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 18-NOV-2006 15:13:07
+---------------------------------------------------------------------------+
|
|
|