eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CLN_SYNC_ITEM_PKG dependencies on WF_PARAMETER_LIST_T

Line 179: l_cln_ch_parameters wf_parameter_list_t;

175: x_set_process_id OUT NOCOPY NUMBER,
176: x_cost_group_id OUT NOCOPY NUMBER)
177:
178: IS
179: l_cln_ch_parameters wf_parameter_list_t;
180: l_event_key NUMBER;
181: l_error_code NUMBER;
182: l_party_id NUMBER;
183: l_party_site_id NUMBER;

Line 301: l_cln_ch_parameters := wf_parameter_list_t();

297:
298: -- get a unique key for raising update collaboration event.
299: SELECT cln_generic_s.nextval INTO l_event_key FROM dual;
300:
301: l_cln_ch_parameters := wf_parameter_list_t();
302: /* Bug: 3479100
303: Desc : Document Number shuld be trading partner number.Running sequence Number
304:
305: l_document_number := l_supplier_name||':'||l_buyer_organization||':'||to_char(sysdate,'YYYYMMDDHH:MM:SS');

Line 402: l_cln_ch_parameters wf_parameter_list_t;

398: x_hazardous_id OUT NOCOPY NUMBER,
399: x_notification_code OUT NOCOPY VARCHAR2,
400: x_inventory_item_id OUT NOCOPY NUMBER )
401: IS
402: l_cln_ch_parameters wf_parameter_list_t;
403: l_event_key NUMBER;
404: l_error_code NUMBER;
405: l_inventory_item_id NUMBER;
406: l_count NUMBER;

Line 482: l_cln_ch_parameters := wf_parameter_list_t();

478: FND_MESSAGE.SET_TOKEN('SUPNAME',p_supplier_name);
479: FND_MESSAGE.SET_TOKEN('ITEMNO',p_item_number);
480: x_msg_data := FND_MESSAGE.GET;
481:
482: l_cln_ch_parameters := wf_parameter_list_t();
483:
484: IF (l_Debug_Level <= 1) THEN
485: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS FOR INCORRECT SYNC IND---------', 1);
486: END IF;

Line 605: l_cln_ch_parameters := wf_parameter_list_t();

601: -- do we need to reject the whole lot for this simple validation failure ??
602: END;
603: END IF;
604:
605: l_cln_ch_parameters := wf_parameter_list_t();
606:
607: IF (l_Debug_Level <= 1) THEN
608: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
609: END IF;

Line 737: l_cln_ch_parameters wf_parameter_list_t;

733: x_return_status_tp OUT NOCOPY VARCHAR2,
734: x_return_desc_tp OUT NOCOPY VARCHAR2 )
735:
736: IS
737: l_cln_ch_parameters wf_parameter_list_t;
738: l_event_key NUMBER;
739: l_error_code NUMBER;
740: l_error_msg VARCHAR2(2000);
741: l_msg_data VARCHAR2(255);

Line 792: l_cln_ch_parameters := wf_parameter_list_t();

788: cln_debug_pub.Add('-------------------------------------',1);
789: cln_debug_pub.Add('------Calling RAISE_UPDATE_EVENT with ERROR status------',1);
790: END IF;
791:
792: l_cln_ch_parameters := wf_parameter_list_t();
793:
794: IF (l_Debug_Level <= 1) THEN
795: cln_debug_pub.Add('---- SETTING EVENT PARAMETERS FOR UPDATE COLLABORATION ----', 1);
796: END IF;

Line 1126: l_cln_ch_parameters wf_parameter_list_t;

1122: l_update_coll_msg VARCHAR2(2000);
1123: l_msg_data VARCHAR2(2000);
1124: l_error_msg VARCHAR2(2000);
1125:
1126: l_cln_ch_parameters wf_parameter_list_t;
1127:
1128: TYPE c_sys_interface_error IS REF CURSOR;
1129: c_cursor_error c_sys_interface_error;
1130:

Line 1303: l_cln_ch_parameters := wf_parameter_list_t();

1299: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);
1300: END IF;
1301:
1302:
1303: l_cln_ch_parameters := wf_parameter_list_t();
1304: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
1305: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1306: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
1307: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

Line 1523: l_cln_ch_parameters wf_parameter_list_t;

1519: sql_statement_1 VARCHAR2(2000);
1520: l_error_msg VARCHAR2(2000);
1521: l_msg_data VARCHAR2(2000);
1522:
1523: l_cln_ch_parameters wf_parameter_list_t;
1524: TYPE c_sys_items_interface IS REF CURSOR;
1525: c_cursor c_sys_items_interface;
1526:
1527: BEGIN

Line 1634: l_cln_ch_parameters := wf_parameter_list_t();

1630: cln_debug_pub.Add('Message for update collaboration = '||l_msg_data, 1);
1631: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);
1632: END IF;
1633:
1634: l_cln_ch_parameters := wf_parameter_list_t();
1635: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
1636: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
1637: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
1638: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

Line 1921: l_cln_ch_parameters wf_parameter_list_t;

1917: l_error_msg VARCHAR2(2000);
1918: l_msg_data VARCHAR2(2000);
1919: l_update_coll_msg VARCHAR2(2000);
1920: sql_statement_error_msg VARCHAR2(2000);
1921: l_cln_ch_parameters wf_parameter_list_t;
1922:
1923: TYPE c_cst_items_interface IS REF CURSOR;
1924: c_cursor_error c_cst_items_interface;
1925:

Line 2138: l_cln_ch_parameters := wf_parameter_list_t();

2134: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);
2135: END IF;
2136:
2137: -- set the parameter list for the workflow
2138: l_cln_ch_parameters := wf_parameter_list_t();
2139: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2140: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2141: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2142: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

Line 2291: l_cln_ch_parameters := wf_parameter_list_t();

2287: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);
2288: cln_debug_pub.Add('Message for the trading partner = '||l_return_desc_tp, 1);
2289: END IF;
2290:
2291: l_cln_ch_parameters := wf_parameter_list_t();
2292: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', 'ERROR', l_cln_ch_parameters);
2293: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2294: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_return_desc_tp, l_cln_ch_parameters);
2295: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

Line 2456: l_cln_ch_parameters wf_parameter_list_t;

2452: l_return_desc_tp VARCHAR2(2000);
2453: l_error_msg VARCHAR2(2000);
2454: l_msg_data VARCHAR2(2000);
2455: l_update_coll_msg VARCHAR2(2000);
2456: l_cln_ch_parameters wf_parameter_list_t;
2457:
2458: BEGIN
2459:
2460: IF (l_Debug_Level <= 2) THEN

Line 2562: l_cln_ch_parameters := wf_parameter_list_t();

2558: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);
2559: END IF;
2560:
2561:
2562: l_cln_ch_parameters := wf_parameter_list_t();
2563: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2564: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2565: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2566: WF_EVENT.AddParameterToList('ROSETTANET_CHECK_REQUIRED','TRUE',l_cln_ch_parameters);

Line 2702: l_cln_ch_parameters wf_parameter_list_t;

2698:
2699: l_error_msg VARCHAR2(2000);
2700: l_msg_data VARCHAR2(2000);
2701: l_update_coll_msg VARCHAR2(2000);
2702: l_cln_ch_parameters wf_parameter_list_t;
2703:
2704: BEGIN
2705:
2706: IF (l_Debug_Level <= 2) THEN

Line 2756: l_cln_ch_parameters := wf_parameter_list_t();

2752: cln_debug_pub.Add('Message for update collaboration = '||l_update_coll_msg, 1);
2753: cln_debug_pub.Add('Event Key for update collaboration = '||l_event_key, 1);
2754: END IF;
2755:
2756: l_cln_ch_parameters := wf_parameter_list_t();
2757: WF_EVENT.AddParameterToList('DOCUMENT_STATUS', l_doc_status, l_cln_ch_parameters);
2758: WF_EVENT.AddParameterToList('ORIGINATOR_REFERENCE', l_master_organization_id, l_cln_ch_parameters);
2759: WF_EVENT.AddParameterToList('MESSAGE_TEXT', l_update_coll_msg, l_cln_ch_parameters);
2760: WF_EVENT.AddParameterToList('XMLG_INTERNAL_CONTROL_NUMBER',l_internal_control_number,l_cln_ch_parameters);

Line 2819: l_cln_ch_parameters wf_parameter_list_t;

2815: p_new_deletion_flag IN OUT NOCOPY VARCHAR2,
2816: p_internal_control_number IN NUMBER,
2817: x_notification_code OUT NOCOPY VARCHAR2 )
2818: IS
2819: l_cln_ch_parameters wf_parameter_list_t;
2820: l_event_key NUMBER;
2821: l_error_code NUMBER;
2822: l_inventory_item_id NUMBER;
2823: l_count NUMBER;

Line 2894: l_cln_ch_parameters := wf_parameter_list_t();

2890: cln_debug_pub.Add('---------------------------------------------------',1);
2891: END IF;
2892:
2893:
2894: l_cln_ch_parameters := wf_parameter_list_t();
2895:
2896: IF (l_Debug_Level <= 1) THEN
2897: cln_debug_pub.Add('---------- SETTING WORKFLOW PARAMETERS---------', 1);
2898: END IF;