1: PACKAGE BODY CLN_NP_CONC_API_CALL as
2: /* $Header: ECXNPCRB.pls 120.0 2005/08/25 04:47:04 nparihar noship $ */
3: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
4:
5:
2: /* $Header: ECXNPCRB.pls 120.0 2005/08/25 04:47:04 nparihar noship $ */
3: l_debug_level NUMBER := to_number(nvl(fnd_profile.value('CLN_DEBUG_LEVEL'), '5'));
4:
5:
6: -- Package: CLN_NP_CONC_API_CALL
7: --
8: -- Purpose: To run user defined PL/SQL function in concurrent mode
9: --
10: -- History
54: BEGIN
55: -- Sets the debug mode to be FILE
56: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');
57: IF (l_Debug_Level <= 2) THEN
58: ecx_cln_debug_pub.Add('ENTERING CLN_NP_CONC_API_CALL.CALL_API', 2);
59: END IF;
60:
61: IF (l_Debug_Level <= 1) THEN
62: ecx_cln_debug_pub.Add('With the following parameters:', 1);
116: END IF;
117:
118: x_resultout := 'Yes';
119: IF (l_Debug_Level <= 2) THEN
120: ecx_cln_debug_pub.Add('EXITING CLN_NP_CONC_API_CALL.CALL_API', 2);
121: END IF;
122:
123: EXCEPTION
124: WHEN OTHERS THEN
131: RETURN;
132: END CALL_API;
133:
134:
135: END CLN_NP_CONC_API_CALL;