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.M4U_XML_GENPROCESS_OUT dependencies on M4U_XML_GENPROCESS_OUT

Line 1: PACKAGE BODY m4u_xml_genprocess_out AS

1: PACKAGE BODY m4u_xml_genprocess_out AS
2: /* $Header: M4UOUTWB.pls 120.3 2006/05/11 21:39:56 bsaratna noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'm4u_xml_genprocess_out';
5: l_debug_level NUMBER;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'm4u_xml_genprocess_out';

1: PACKAGE BODY m4u_xml_genprocess_out AS
2: /* $Header: M4UOUTWB.pls 120.3 2006/05/11 21:39:56 bsaratna noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'm4u_xml_genprocess_out';
5: l_debug_level NUMBER;
6:
7:
8: -- Name

Line 463: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.create_collab_setattr - Normal : resultout-' || resultout,2);

459: cln_debug_pub.Add('ECX_PARAMETER1 set to collaboration id value :- ' || l_coll_id,1);
460: END IF;
461:
462: IF (l_Debug_Level <= 2) THEN
463: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.create_collab_setattr - Normal : resultout-' || resultout,2);
464: END IF;
465:
466: RETURN;
467:

Line 493: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.create_collab_setattr - Exception =========== ',2);

489: cln_debug_pub.Add('Unexpected Error -'||l_error_code||' : '||l_error_msg,5);
490: END IF;
491:
492: IF (l_Debug_Level <= 2) THEN
493: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.create_collab_setattr - Exception =========== ',2);
494: END IF;
495:
496: wf_Core.context('m4u_xml_genprocess_out','create_collab_setattr', itemtype, itemkey, to_char(actid), funcmode);
497: RAISE;

Line 496: wf_Core.context('m4u_xml_genprocess_out','create_collab_setattr', itemtype, itemkey, to_char(actid), funcmode);

492: IF (l_Debug_Level <= 2) THEN
493: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.create_collab_setattr - Exception =========== ',2);
494: END IF;
495:
496: wf_Core.context('m4u_xml_genprocess_out','create_collab_setattr', itemtype, itemkey, to_char(actid), funcmode);
497: RAISE;
498: END;
499:
500:

Line 928: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_cln_collaborations - Normal : resultout-' || resultout,2);

924: cln_debug_pub.Add(' l_msg_count - '|| l_msg_count, 1);
925: END IF;
926:
927: IF (l_Debug_Level <= 2) THEN
928: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_cln_collaborations - Normal : resultout-' || resultout,2);
929: END IF;
930: RETURN; -- Something wrong, simply notify admin and bailout, ...
931: END IF;
932: END IF;

Line 1039: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_collab_setattr - Normal : resultout-' || resultout,2);

1035:
1036: resultout := wf_engine.eng_completed;
1037:
1038: IF (l_Debug_Level <= 2) THEN
1039: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_collab_setattr - Normal : resultout-' || resultout,2);
1040: END IF;
1041:
1042: RETURN;
1043: -- Exception Handling

Line 1068: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.update_collab_setattr - Exception =========== ',2);

1064: cln_debug_pub.Add('Unexpected Error -'||l_error_code||' : '||l_error_msg,5);
1065: END IF;
1066:
1067: IF (l_Debug_Level <= 2) THEN
1068: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.update_collab_setattr - Exception =========== ',2);
1069: END IF;
1070:
1071: wf_Core.context('m4u_xml_genprocess_out','update_collab_setattr',
1072: itemtype, itemkey, to_char(actid), funcmode);

Line 1071: wf_Core.context('m4u_xml_genprocess_out','update_collab_setattr',

1067: IF (l_Debug_Level <= 2) THEN
1068: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.update_collab_setattr - Exception =========== ',2);
1069: END IF;
1070:
1071: wf_Core.context('m4u_xml_genprocess_out','update_collab_setattr',
1072: itemtype, itemkey, to_char(actid), funcmode);
1073: RAISE;
1074: END;
1075:

Line 1418: cln_debug_pub.Add('EXITING m4u_xml_genprocess_out.create_cln_collaborations FAILURE',2);

1414: || ', Error message - '
1415: || x_msg_data);
1416:
1417: IF (l_Debug_Level <= 2) THEN
1418: cln_debug_pub.Add('EXITING m4u_xml_genprocess_out.create_cln_collaborations FAILURE',2);
1419: END IF;
1420: RETURN;
1421: END IF;
1422:

Line 1451: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.create_cln_collaborations - Exception =========== ',2);

1447: cln_debug_pub.Add('Error : ' || SQLCODE || ':' || SQLERRM, 5);
1448: cln_debug_pub.Add('x_msg_data : ' || x_msg_data,5);
1449: END IF;
1450: IF (l_Debug_Level <= 2) THEN
1451: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.create_cln_collaborations - Exception =========== ',2);
1452: END IF;
1453:
1454: Wf_Core.Context('m4u_xml_genprocess_out','create_cln_collaborations',
1455: itemtype, itemkey, to_char(actid), funcmode);

Line 1454: Wf_Core.Context('m4u_xml_genprocess_out','create_cln_collaborations',

1450: IF (l_Debug_Level <= 2) THEN
1451: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.create_cln_collaborations - Exception =========== ',2);
1452: END IF;
1453:
1454: Wf_Core.Context('m4u_xml_genprocess_out','create_cln_collaborations',
1455: itemtype, itemkey, to_char(actid), funcmode);
1456: RAISE;
1457: END;
1458:

Line 1543: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_cln_collaborations - Normal : resultout-' || resultout,2);

1539: -- if funcmode is not null then exit
1540: IF (funcmode <> wf_engine.eng_run) THEN
1541: resultout := wf_engine.eng_null;
1542: IF (l_Debug_Level <= 2) THEN
1543: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_cln_collaborations - Normal : resultout-' || resultout,2);
1544: END IF;
1545: RETURN;
1546: END IF;
1547:

Line 1733: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_cln_collaborations - Normal : resultout-' || resultout,2);

1729: cln_debug_pub.Add(' x_msg_count - '|| x_msg_count, 1);
1730: END IF;
1731:
1732: IF (l_Debug_Level <= 2) THEN
1733: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_cln_collaborations - Normal : resultout-' || resultout,2);
1734: END IF;
1735: RETURN; -- Something wrong, simply notify admin and bailout, ...
1736: END IF;
1737:

Line 1824: cln_debug_pub.Add('======EXITING m4u_xml_genprocess_out.update_cln_collaborations exception', 2);

1820: cln_debug_pub.Add('Error '|| l_error_code || ':' || l_error_msg, 5);
1821: END IF;
1822:
1823: IF (l_Debug_Level <= 2) THEN
1824: cln_debug_pub.Add('======EXITING m4u_xml_genprocess_out.update_cln_collaborations exception', 2);
1825: END IF;
1826:
1827: wf_Core.context('m4u_wlq_generate','wlq_update_cln_collab',
1828: itemtype, itemkey, to_char(actid), funcmode);

Line 1871: cln_debug_pub.Add('=========== Entering m4u_xml_genprocess_out.set_aq_correlation =========== ',2);

1867: l_as2_correlation_id := 'UCC:AS2';
1868: l_error_correlation_id := 'UCC:ERROR';
1869:
1870: IF (l_Debug_Level <= 2) THEN
1871: cln_debug_pub.Add('=========== Entering m4u_xml_genprocess_out.set_aq_correlation =========== ',2);
1872: END IF;
1873:
1874: IF (l_Debug_Level <= 1) THEN
1875: cln_debug_pub.Add('Paramters received are' , 2);

Line 1893: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.set_aq_correlation - Normal : resultout-' || resultout,2);

1889: END IF;
1890:
1891: resultout := wf_engine.eng_null;
1892: IF (l_Debug_Level <= 2) THEN
1893: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.set_aq_correlation - Normal : resultout-' || resultout,2);
1894: END IF;
1895: RETURN;
1896: END IF;
1897:

Line 1965: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.set_aq_correlation =========== ',2);

1961: /* Y or N value if Y use the UCCnet adapter */
1962: resultout := wf_engine.eng_completed;
1963:
1964: IF (l_Debug_Level <= 2) THEN
1965: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.set_aq_correlation =========== ',2);
1966: END IF;
1967:
1968:
1969: EXCEPTION

Line 1978: || ' in m4u_xml_genprocess_out.Set_AQ_Correlation , Error code - '

1974: FND_MESSAGE.SET_NAME('CLN','M4U_UNEXPECTED_ERROR');
1975: l_fnd_msg := FND_MESSAGE.GET;
1976:
1977: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_fnd_msg
1978: || ' in m4u_xml_genprocess_out.Set_AQ_Correlation , Error code - '
1979: || l_error_code
1980: || ', Error message - '
1981: || l_error_msg);
1982:

Line 1988: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.set_aq_correlation - Exception =========== ',2);

1984: IF (l_Debug_Level <= 5) THEN
1985: cln_debug_pub.Add('Error : ' || l_error_code || ':' || l_error_msg, 5);
1986: END IF;
1987: IF (l_Debug_Level <= 2) THEN
1988: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.set_aq_correlation - Exception =========== ',2);
1989: END IF;
1990:
1991: Wf_Core.Context('m4u_xml_genprocess_out','set_aq_correlation',
1992: itemtype, itemkey, to_char(actid), funcmode);

Line 1991: Wf_Core.Context('m4u_xml_genprocess_out','set_aq_correlation',

1987: IF (l_Debug_Level <= 2) THEN
1988: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.set_aq_correlation - Exception =========== ',2);
1989: END IF;
1990:
1991: Wf_Core.Context('m4u_xml_genprocess_out','set_aq_correlation',
1992: itemtype, itemkey, to_char(actid), funcmode);
1993: RAISE;
1994: END;
1995:

Line 2022: cln_debug_pub.Add('=========== Entering m4u_xml_genprocess_out.check_send_method =========== ',2);

2018: l_error_msg VARCHAR2(255);
2019: l_fnd_msg VARCHAR2(255);
2020: BEGIN
2021: IF (l_Debug_Level <= 2) THEN
2022: cln_debug_pub.Add('=========== Entering m4u_xml_genprocess_out.check_send_method =========== ',2);
2023: END IF;
2024:
2025: IF (l_Debug_Level <= 1) THEN
2026: cln_debug_pub.Add('Paramters received are' , 2);

Line 2037: cln_debug_pub.Add('==========Exiting m4u_xml_genprocess_out.check_send_method ======', 2);

2033: -- Do nothing in cancel or timeout mode
2034: IF (funcmode <> wf_engine.eng_run) THEN
2035: resultout := wf_engine.eng_null;
2036: IF (l_Debug_Level <= 2) THEN
2037: cln_debug_pub.Add('==========Exiting m4u_xml_genprocess_out.check_send_method ======', 2);
2038: END IF;
2039: RETURN;
2040: END IF;
2041:

Line 2059: || ' in m4u_xml_genprocess_out.check_send_method , Error code - '

2055: FND_MESSAGE.SET_NAME('CLN','M4U_UNEXPECTED_ERROR');
2056: l_fnd_msg := FND_MESSAGE.GET;
2057:
2058: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_fnd_msg
2059: || ' in m4u_xml_genprocess_out.check_send_method , Error code - '
2060: || l_error_code
2061: || ', Error message - '
2062: || l_error_msg);
2063:

Line 2069: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.CHECK_SEND_METHOD =========== ',2);

2065: IF (l_Debug_Level <= 5) THEN
2066: cln_debug_pub.Add('Error :' || SQLCODE || ':' || SQLERRM, 5);
2067: END IF;
2068: IF (l_Debug_Level <= 2) THEN
2069: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.CHECK_SEND_METHOD =========== ',2);
2070: END IF;
2071:
2072: Wf_Core.Context('m4u_xml_genprocess_out','check_send_method',
2073: itemtype, itemkey, to_char(actid), funcmode);

Line 2072: Wf_Core.Context('m4u_xml_genprocess_out','check_send_method',

2068: IF (l_Debug_Level <= 2) THEN
2069: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.CHECK_SEND_METHOD =========== ',2);
2070: END IF;
2071:
2072: Wf_Core.Context('m4u_xml_genprocess_out','check_send_method',
2073: itemtype, itemkey, to_char(actid), funcmode);
2074: RAISE;
2075: END;
2076:

Line 2120: cln_debug_pub.Add('=========== Entering m4u_xml_genprocess_out.dequeue_ucc_message =========== ',2);

2116: 'M4U_SEND_MODE',
2117: TRUE);
2118:
2119: IF (l_Debug_Level <= 2) THEN
2120: cln_debug_pub.Add('=========== Entering m4u_xml_genprocess_out.dequeue_ucc_message =========== ',2);
2121: END IF;
2122:
2123: IF (l_Debug_Level <= 1) THEN
2124: cln_debug_pub.Add('Paramters received are' , 2);

Line 2134: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message =========== ',2);

2130:
2131: IF (funcmode <> wf_engine.eng_run) THEN
2132: resultout := wf_engine.eng_null;
2133: IF (l_Debug_Level <= 2) THEN
2134: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message =========== ',2);
2135: END IF;
2136: RETURN;
2137: END IF;
2138:

Line 2148: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message, null event =========== ',2);

2144: END;
2145:
2146: IF l_event IS NULL THEN
2147: IF (l_Debug_Level <= 2) THEN
2148: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message, null event =========== ',2);
2149: END IF;
2150: END IF;
2151:
2152: l_agent := l_event.getFromAgent;

Line 2157: cln_debug_pub.Add('=========== m4u_xml_genprocess_out.dequeue_ucc_message, null agent =========== ',2);

2153:
2154:
2155: IF l_agent IS NULL THEN
2156: IF (l_Debug_Level <= 2) THEN
2157: cln_debug_pub.Add('=========== m4u_xml_genprocess_out.dequeue_ucc_message, null agent =========== ',2);
2158: END IF;
2159: ELSE
2160: l_queue_name := l_agent.getName;
2161: END IF;

Line 2174: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message normal =========== ',2);

2170: msgid => l_msgid);
2171:
2172: -- not raising an exception when message is NULL
2173: IF (l_Debug_Level <= 2) THEN
2174: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message normal =========== ',2);
2175: END IF;
2176:
2177: resultout := wf_engine.eng_completed;
2178:

Line 2188: || ' in m4u_xml_genprocess_out.dequeue_ucc_message , Error code - '

2184: FND_MESSAGE.SET_NAME('CLN','M4U_UNEXPECTED_ERROR');
2185: l_fnd_msg := FND_MESSAGE.GET;
2186:
2187: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_fnd_msg
2188: || ' in m4u_xml_genprocess_out.dequeue_ucc_message , Error code - '
2189: || l_error_code
2190: || ', Error message - '
2191: || l_error_msg);
2192:

Line 2198: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message exception =========== ',2);

2194: IF (l_Debug_Level <= 5) THEN
2195: cln_debug_pub.Add('Error :' || SQLCODE || ':' || SQLERRM, 5);
2196: END IF;
2197: IF (l_Debug_Level <= 2) THEN
2198: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message exception =========== ',2);
2199: END IF;
2200:
2201: resultout := wf_engine.eng_completed;
2202: Wf_Core.Context('m4u_xml_genprocess_out','dequeue_ucc_message ',

Line 2202: Wf_Core.Context('m4u_xml_genprocess_out','dequeue_ucc_message ',

2198: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message exception =========== ',2);
2199: END IF;
2200:
2201: resultout := wf_engine.eng_completed;
2202: Wf_Core.Context('m4u_xml_genprocess_out','dequeue_ucc_message ',
2203: itemtype, itemkey, to_char(actid), funcmode);
2204:
2205: END;
2206:

Line 2243: cln_debug_pub.Add('========= Entering m4u_xml_genprocess_out.raise_payload_event == ',2);

2239: l_data_event := null;
2240: l_clob_xml_payload := null;
2241:
2242: IF (l_debug_Level <= 2) THEN
2243: cln_debug_pub.Add('========= Entering m4u_xml_genprocess_out.raise_payload_event == ',2);
2244: END IF;
2245:
2246: -- Parameters received
2247: IF (l_Debug_Level <= 1) THEN

Line 2346: cln_debug_pub.Add('====== exiting m4u_xml_genprocess_out.raise_payload_event - normal : resultout-' || resultout,2);

2342:
2343: resultout := wf_engine.eng_completed || ':SUCCESS';
2344:
2345: IF (l_Debug_Level <= 2) THEN
2346: cln_debug_pub.Add('====== exiting m4u_xml_genprocess_out.raise_payload_event - normal : resultout-' || resultout,2);
2347: END IF;
2348:
2349: -- Exception Handling
2350: EXCEPTION

Line 2359: || ' in m4u_xml_genprocess_out.raise_payload_event , Error code - '

2355: FND_MESSAGE.SET_NAME('CLN','M4U_UNEXPECTED_ERROR');
2356: l_fnd_msg := FND_MESSAGE.GET;
2357:
2358: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_fnd_msg
2359: || ' in m4u_xml_genprocess_out.raise_payload_event , Error code - '
2360: || l_error_code
2361: || ', Error message - '
2362: || l_error_msg);
2363:

Line 2369: cln_debug_pub.Add('=========== ERROR :Exiting m4u_xml_genprocess_out.raise_payload_event =========== ',2);

2365: IF (l_Debug_Level <= 5) THEN
2366: cln_debug_pub.Add('Error :' || SQLCODE || ':' || SQLERRM, 5);
2367: END IF;
2368: IF (l_Debug_Level <= 2) THEN
2369: cln_debug_pub.Add('=========== ERROR :Exiting m4u_xml_genprocess_out.raise_payload_event =========== ',2);
2370: END IF;
2371:
2372: Wf_Core.Context('m4u_xml_genprocess_out','raise_payload_event',
2373: itemtype, itemkey, to_char(actid), funcmode);

Line 2372: Wf_Core.Context('m4u_xml_genprocess_out','raise_payload_event',

2368: IF (l_Debug_Level <= 2) THEN
2369: cln_debug_pub.Add('=========== ERROR :Exiting m4u_xml_genprocess_out.raise_payload_event =========== ',2);
2370: END IF;
2371:
2372: Wf_Core.Context('m4u_xml_genprocess_out','raise_payload_event',
2373: itemtype, itemkey, to_char(actid), funcmode);
2374: RAISE;
2375: END;
2376:

Line 2380: END m4u_xml_genprocess_out;

2376:
2377:
2378: BEGIN
2379: l_debug_level := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
2380: END m4u_xml_genprocess_out;