DBA Data[Home] [Help]

APPS.M4U_RESP_PROCESS dependencies on M4U_RESP_PROCESS

Line 1: PACKAGE BODY m4u_resp_process AS

1: PACKAGE BODY m4u_resp_process AS
2: /* $Header: m4urespb.pls 120.2 2006/05/11 03:29:27 bsaratna noship $ */
3:
4:
5: g_debug_level NUMBER ;

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'm4u_resp_process';

2: /* $Header: m4urespb.pls 120.2 2006/05/11 03:29:27 bsaratna noship $ */
3:
4:
5: g_debug_level NUMBER ;
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'm4u_resp_process';
7:
8:
9: -- Name
10: -- add_error_to_cln_hist

Line 47: cln_debug_pub.Add('Entering m4u_resp_process.add_error_to_cln_hist', 2);

43: l_event_name := 'oracle.apps.cln.ch.collaboration.addmessage';
44:
45: IF (g_debug_Level <= 2) THEN
46: cln_debug_pub.Add('===============================================', 2);
47: cln_debug_pub.Add('Entering m4u_resp_process.add_error_to_cln_hist', 2);
48: END IF;
49:
50: IF (g_debug_Level <= 1) THEN
51: cln_debug_pub.Add('-- Received parameters -- ', 1);

Line 100: cln_debug_pub.Add('Exiting m4u_resp_process.add_error_to_cln_hist - normal',2);

96: x_msg_data := l_event_name || ' raised';
97:
98:
99: IF (g_debug_Level <= 2) THEN
100: cln_debug_pub.Add('Exiting m4u_resp_process.add_error_to_cln_hist - normal',2);
101: cln_debug_pub.Add('=======================================================',2);
102: END IF;
103:
104: EXCEPTION

Line 111: x_msg_data := ' - Unexpected error in m4u_resp_process.add_error_to_cln_hist - ' || l_error_code || ':' || l_error_msg;

107: -- log exception and exit.
108: l_error_code := SQLCODE;
109: l_error_msg := SQLERRM;
110: x_return_status := 'F';
111: x_msg_data := ' - Unexpected error in m4u_resp_process.add_error_to_cln_hist - ' || l_error_code || ':' || l_error_msg;
112:
113: IF (g_debug_Level <= 5) THEN
114: cln_debug_pub.Add(l_error_code || ':' || l_error_msg, 4);
115: END IF;

Line 118: cln_debug_pub.Add('Exiting m4u_resp_process.add_error_to_cln_hist - exception',2);

114: cln_debug_pub.Add(l_error_code || ':' || l_error_msg, 4);
115: END IF;
116:
117: IF (g_debug_Level <= 2) THEN
118: cln_debug_pub.Add('Exiting m4u_resp_process.add_error_to_cln_hist - exception',2);
119: cln_debug_pub.Add('==========================================================',2);
120: END IF;
121:
122: END add_error_to_cln_hist;

Line 182: cln_debug_pub.Add('-- Entering m4u_resp_process.process_cic_notification -- ', 2);

178: l_event_params wf_parameter_list_t;
179: BEGIN
180: l_event_name := 'oracle.apps.cln.np.processnotification';
181: IF (g_debug_Level <= 2) THEN
182: cln_debug_pub.Add('-- Entering m4u_resp_process.process_cic_notification -- ', 2);
183: END IF;
184:
185: IF (g_debug_Level <= 1) THEN
186: cln_debug_pub.Add('-- with paramters -- ', 1);

Line 355: cln_debug_pub.add('Exiting m4u_resp_process.process_cic_notification - normal',2);

351: p_parameters => l_event_params
352: );
353:
354: IF (g_debug_Level <= 2) THEN
355: cln_debug_pub.add('Exiting m4u_resp_process.process_cic_notification - normal',2);
356: cln_debug_pub.add('==========================================================',2);
357: END IF;
358: EXCEPTION
359: WHEN OTHERS THEN

Line 372: cln_debug_pub.add('Exiting m4u_resp_process.process_cic_notification - exception',2);

368: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 5);
369: END IF;
370:
371: IF (g_debug_Level <= 2) THEN
372: cln_debug_pub.add('Exiting m4u_resp_process.process_cic_notification - exception',2);
373: cln_debug_pub.add('=============================================================',2);
374: END IF;
375:
376: END process_cic_notification;

Line 407: cln_debug_pub.Add('-- Entering m4u_resp_process.process_cic_additional_info -- ', 2);

403: --l_add_cic_info EGO_UCCNET_EVENTS_PVT.ADD_CIC_INFO_TYPE;
404:
405: BEGIN
406: IF (g_debug_Level <= 2) THEN
407: cln_debug_pub.Add('-- Entering m4u_resp_process.process_cic_additional_info -- ', 2);
408: END IF;
409:
410: IF (g_debug_Level <= 1) THEN
411: cln_debug_pub.Add('-- with paramters -- ', 1);

Line 490: cln_debug_pub.add('Exiting m4u_resp_process.process_cic_additional_info - normal',2);

486: x_msg_data := 'Failure occured while processing CIC message in Query Worklist response - ' || x_msg_data;
487: END IF;
488:
489: IF (g_debug_Level <= 2) THEN
490: cln_debug_pub.add('Exiting m4u_resp_process.process_cic_additional_info - normal',2);
491: cln_debug_pub.add('==========================================================',2);
492: END IF;
493: EXCEPTION
494: WHEN OTHERS THEN

Line 507: cln_debug_pub.add('Exiting m4u_resp_process.process_cic_additional_info - exception',2);

503: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 5);
504: END IF;
505:
506: IF (g_debug_Level <= 2) THEN
507: cln_debug_pub.add('Exiting m4u_resp_process.process_cic_additional_info - exception',2);
508: cln_debug_pub.add('=============================================================',2);
509: END IF;
510:
511: END process_cic_additional_info;

Line 557: cln_debug_pub.Add('Entering - m4u_resp_process.process_cic_trade_item', 2);

553:
554:
555: IF (g_debug_Level <= 2) THEN
556: cln_debug_pub.Add('==================================================', 2);
557: cln_debug_pub.Add('Entering - m4u_resp_process.process_cic_trade_item', 2);
558: END IF;
559:
560:
561:

Line 597: cln_debug_pub.add('Exiting m4u_resp_process.process_cic_trade_item - exception',2);

593: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
594: END IF;
595:
596: IF (g_debug_Level <= 2) THEN
597: cln_debug_pub.add('Exiting m4u_resp_process.process_cic_trade_item - exception',2);
598: cln_debug_pub.add('===========================================================',2);
599: END IF;
600:
601: END process_cic_trade_item;

Line 781: cln_debug_pub.Add('Exiting m4u_resp_process.process_rcir_notification - normal',2);

777: x_msg_data := 'Failure occured while processing RCIR Batch Notification in Query Worklist Response - ' || x_msg_data;
778: END IF;
779:
780: IF (g_debug_Level <= 2) THEN
781: cln_debug_pub.Add('Exiting m4u_resp_process.process_rcir_notification - normal',2);
782: cln_debug_pub.Add('===========================================================',2);
783: END IF;
784:
785: EXCEPTION

Line 799: cln_debug_pub.Add('Exiting m4u_resp_process.process_rcir_notification - exception',2);

795: cln_debug_pub.Add(l_error_code || ':' || l_error_msg, 4);
796: END IF;
797:
798: IF (g_debug_Level <= 2) THEN
799: cln_debug_pub.Add('Exiting m4u_resp_process.process_rcir_notification - exception',2);
800: cln_debug_pub.Add('==============================================================',2);
801: END IF;
802:
803: END process_rcir_notification;

Line 848: cln_debug_pub.Add('Entering m4u_resp_process.process_rcir_batch_list', 2);

844: l_event_name := 'oracle.apps.cln.np.processnotification';
845:
846: IF (g_debug_Level <= 2) THEN
847: cln_debug_pub.Add('=================================================', 2);
848: cln_debug_pub.Add('Entering m4u_resp_process.process_rcir_batch_list', 2);
849: END IF;
850:
851: IF (g_debug_Level <= 1) THEN
852: cln_debug_pub.Add('-- with paramerters --', 1);

Line 976: cln_debug_pub.Add('Exiting m4u_resp_process.process_rcir_batch_list - normal',2);

972: x_return_status := 'S';
973: x_msg_data := 'RCIR Batch-list succesfully processed';
974:
975: IF (g_debug_Level <= 2) THEN
976: cln_debug_pub.Add('Exiting m4u_resp_process.process_rcir_batch_list - normal',2);
977: cln_debug_pub.Add('=========================================================',2);
978: END IF;
979:
980: EXCEPTION

Line 995: cln_debug_pub.Add('Exiting m4u_resp_process.process_rcir_batch_list - exception',2);

991: cln_debug_pub.Add(l_error_code || ':' || l_error_msg, 4);
992: END IF;
993:
994: IF (g_debug_Level <= 2) THEN
995: cln_debug_pub.Add('Exiting m4u_resp_process.process_rcir_batch_list - exception',2);
996: cln_debug_pub.Add('============================================================',2);
997: END IF;
998:
999: END process_rcir_batch_list;

Line 1043: cln_debug_pub.Add('-- Entering m4u_resp_process.process_wlq_response -- ', 2);

1039: l_doc_type VARCHAR2(50);
1040: BEGIN
1041: IF (g_debug_Level <= 2) THEN
1042: cln_debug_pub.Add('=====================================================', 2);
1043: cln_debug_pub.Add('-- Entering m4u_resp_process.process_wlq_response -- ', 2);
1044: END IF;
1045:
1046: IF (g_debug_Level <= 1) THEN
1047: cln_debug_pub.Add('-- with paramters -- ', 1);

Line 1130: cln_debug_pub.add('Exiting m4u_resp_process.process_wlq_response - normal',2);

1126: x_msg_data := 'Failure occured while processing collaboration history on Query Response - ' || x_msg_data;
1127: END IF;
1128:
1129: IF (g_debug_Level <= 2) THEN
1130: cln_debug_pub.add('Exiting m4u_resp_process.process_wlq_response - normal',2);
1131: cln_debug_pub.add('======================================================',2);
1132: END IF;
1133: EXCEPTION
1134: WHEN OTHERS THEN

Line 1148: cln_debug_pub.add('Exiting m4u_resp_process.process_wlq_response - exception',2);

1144: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
1145: END IF;
1146:
1147: IF (g_debug_Level <= 2) THEN
1148: cln_debug_pub.add('Exiting m4u_resp_process.process_wlq_response - exception',2);
1149: cln_debug_pub.add('=========================================================',2);
1150: END IF;
1151:
1152: END process_wlq_response;

Line 1206: cln_debug_pub.Add('-- Entering m4u_resp_process.process_rcir_ack -- ', 2);

1202: l_event_name := 'oracle.apps.cln.np.processnotification';
1203:
1204: IF (g_debug_Level <= 2) THEN
1205: cln_debug_pub.Add('==================================================', 2);
1206: cln_debug_pub.Add('-- Entering m4u_resp_process.process_rcir_ack -- ', 2);
1207: END IF;
1208:
1209: IF (g_debug_Level <= 1) THEN
1210: cln_debug_pub.Add('-- with paramters -- ', 1);

Line 1401: cln_debug_pub.add('Exiting m4u_resp_process.process_rcir_ack - normal',2);

1397: END IF;
1398:
1399:
1400: IF (g_debug_Level <= 2) THEN
1401: cln_debug_pub.add('Exiting m4u_resp_process.process_rcir_ack - normal',2);
1402: cln_debug_pub.add('==================================================',2);
1403: END IF;
1404: EXCEPTION
1405: WHEN OTHERS THEN

Line 1419: cln_debug_pub.add('Exiting m4u_resp_process.process_rcir_ack - exception',2);

1415: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
1416: END IF;
1417:
1418: IF (g_debug_Level <= 2) THEN
1419: cln_debug_pub.add('Exiting m4u_resp_process.process_rcir_ack - exception',2);
1420: cln_debug_pub.add('=====================================================',2);
1421: END IF;
1422:
1423: END process_rcir_ack;

Line 1485: cln_debug_pub.Add('-- Entering m4u_resp_process.process_rcir_batch_ack -- ', 2);

1481: l_event_name := 'oracle.apps.cln.np.processnotification';
1482:
1483: IF (g_debug_Level <= 2) THEN
1484: cln_debug_pub.Add('=======================================================', 2);
1485: cln_debug_pub.Add('-- Entering m4u_resp_process.process_rcir_batch_ack -- ', 2);
1486: END IF;
1487:
1488: IF (g_debug_Level <= 1) THEN
1489: cln_debug_pub.Add('-- with parameters -- ', 1);

Line 1699: cln_debug_pub.add('Exiting m4u_resp_process.process_rcir_batch_ack - normal',2);

1695: x_msg_data := 'Successfully updated all RCIR-Batch collaborations on RCIR Batch response';
1696: END IF;
1697:
1698: IF (g_debug_Level <= 2) THEN
1699: cln_debug_pub.add('Exiting m4u_resp_process.process_rcir_batch_ack - normal',2);
1700: cln_debug_pub.add('========================================================',2);
1701: END IF;
1702: EXCEPTION
1703: WHEN OTHERS THEN

Line 1716: cln_debug_pub.add('Exiting m4u_resp_process.process_rcir_batch_ack - exception',2);

1712: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
1713: END IF;
1714:
1715: IF (g_debug_Level <= 2) THEN
1716: cln_debug_pub.add('Exiting m4u_resp_process.process_rcir_batch_ack - exception',2);
1717: cln_debug_pub.add('===========================================================',2);
1718: END IF;
1719:
1720: END process_rcir_batch_ack;

Line 1771: cln_debug_pub.Add('-- Entering m4u_resp_process.process_cin_ack -- ', 2);

1767: l_event_name := 'oracle.apps.cln.np.processnotification';
1768:
1769: IF (g_debug_Level <= 2) THEN
1770: cln_debug_pub.Add('================================================', 2);
1771: cln_debug_pub.Add('-- Entering m4u_resp_process.process_cin_ack -- ', 2);
1772: END IF;
1773:
1774: IF (g_debug_Level <= 1) THEN
1775: cln_debug_pub.Add('-- with paramters -- ', 1);

Line 1925: cln_debug_pub.add('Exiting m4u_resp_process.process_cin_ack - normal',2);

1921: p_parameters => l_event_params
1922: );
1923:
1924: IF (g_debug_Level <= 2) THEN
1925: cln_debug_pub.add('Exiting m4u_resp_process.process_cin_ack - normal',2);
1926: cln_debug_pub.add('=================================================',2);
1927: END IF;
1928: EXCEPTION
1929: WHEN OTHERS THEN

Line 1942: cln_debug_pub.add('Exiting m4u_resp_process.process_cin_ack - exception',2);

1938: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);
1939: END IF;
1940:
1941: IF (g_debug_Level <= 2) THEN
1942: cln_debug_pub.add('Exiting m4u_resp_process.process_cin_ack - exception',2);
1943: cln_debug_pub.add('====================================================',2);
1944: END IF;
1945: END process_cin_ack;
1946:

Line 2008: cln_debug_pub.Add('-- Entering m4u_resp_process.process_rfcin_notification -- ', 2);

2004:
2005: l_event_name := 'oracle.apps.cln.np.processnotification';
2006:
2007: IF (g_debug_Level <= 2) THEN
2008: cln_debug_pub.Add('-- Entering m4u_resp_process.process_rfcin_notification -- ', 2);
2009: END IF;
2010:
2011: IF (g_debug_Level <= 1) THEN
2012: cln_debug_pub.Add('-- with paramters -- ', 1);

Line 2143: cln_debug_pub.Add('-- Exiting m4u_resp_process.process_rfcin_notification success-- ', 2);

2139: p_parameters => l_event_params
2140: );
2141:
2142: IF (g_debug_Level <= 2) THEN
2143: cln_debug_pub.Add('-- Exiting m4u_resp_process.process_rfcin_notification success-- ', 2);
2144: END IF;
2145:
2146:
2147:

Line 2156: x_msg_data := ' - Unexpected error in m4u_resp_process.process_rfcin_notification' || l_error_code || ':' || l_error_msg;

2152: -- log exception and exit.
2153: l_error_code := SQLCODE;
2154: l_error_msg := SQLERRM;
2155: x_return_status := 'F';
2156: x_msg_data := ' - Unexpected error in m4u_resp_process.process_rfcin_notification' || l_error_code || ':' || l_error_msg;
2157:
2158:
2159: IF (g_debug_Level <= 5) THEN
2160: cln_debug_pub.add(l_error_code || ':' || l_error_msg, 4);

Line 2172: END m4u_resp_process;

2168:
2169:
2170: BEGIN
2171: g_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
2172: END m4u_resp_process;