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_NP_CONC_API_CALL dependencies on ECX_CLN_DEBUG_PUB

Line 56: --l_debug_mode := ecx_cln_debug_pub.Set_Debug_Mode('FILE');

52: l_notification_code VARCHAR2(250);
53: l_notification_desc VARCHAR2(250);
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:

Line 58: ecx_cln_debug_pub.Add('ENTERING CLN_NP_CONC_API_CALL.CALL_API', 2);

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);

Line 62: ecx_cln_debug_pub.Add('With the following parameters:', 1);

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);
63: ecx_cln_debug_pub.Add('p_itemtype:' || p_itemtype, 1);
64: ecx_cln_debug_pub.Add('p_itemkey:' || p_itemkey, 1);
65: ecx_cln_debug_pub.Add('p_actid:' || p_actid, 1);
66: ecx_cln_debug_pub.Add('p_funcmode:' || p_funcmode, 1);

Line 63: ecx_cln_debug_pub.Add('p_itemtype:' || p_itemtype, 1);

59: END IF;
60:
61: IF (l_Debug_Level <= 1) THEN
62: ecx_cln_debug_pub.Add('With the following parameters:', 1);
63: ecx_cln_debug_pub.Add('p_itemtype:' || p_itemtype, 1);
64: ecx_cln_debug_pub.Add('p_itemkey:' || p_itemkey, 1);
65: ecx_cln_debug_pub.Add('p_actid:' || p_actid, 1);
66: ecx_cln_debug_pub.Add('p_funcmode:' || p_funcmode, 1);
67: END IF;

Line 64: ecx_cln_debug_pub.Add('p_itemkey:' || p_itemkey, 1);

60:
61: IF (l_Debug_Level <= 1) THEN
62: ecx_cln_debug_pub.Add('With the following parameters:', 1);
63: ecx_cln_debug_pub.Add('p_itemtype:' || p_itemtype, 1);
64: ecx_cln_debug_pub.Add('p_itemkey:' || p_itemkey, 1);
65: ecx_cln_debug_pub.Add('p_actid:' || p_actid, 1);
66: ecx_cln_debug_pub.Add('p_funcmode:' || p_funcmode, 1);
67: END IF;
68:

Line 65: ecx_cln_debug_pub.Add('p_actid:' || p_actid, 1);

61: IF (l_Debug_Level <= 1) THEN
62: ecx_cln_debug_pub.Add('With the following parameters:', 1);
63: ecx_cln_debug_pub.Add('p_itemtype:' || p_itemtype, 1);
64: ecx_cln_debug_pub.Add('p_itemkey:' || p_itemkey, 1);
65: ecx_cln_debug_pub.Add('p_actid:' || p_actid, 1);
66: ecx_cln_debug_pub.Add('p_funcmode:' || p_funcmode, 1);
67: END IF;
68:
69:

Line 66: ecx_cln_debug_pub.Add('p_funcmode:' || p_funcmode, 1);

62: ecx_cln_debug_pub.Add('With the following parameters:', 1);
63: ecx_cln_debug_pub.Add('p_itemtype:' || p_itemtype, 1);
64: ecx_cln_debug_pub.Add('p_itemkey:' || p_itemkey, 1);
65: ecx_cln_debug_pub.Add('p_actid:' || p_actid, 1);
66: ecx_cln_debug_pub.Add('p_funcmode:' || p_funcmode, 1);
67: END IF;
68:
69:
70: l_procedure_name := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'PROCEDURE_NAME');

Line 72: ecx_cln_debug_pub.Add('l_procedure_name - ' || l_procedure_name, 2);

68:
69:
70: l_procedure_name := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'PROCEDURE_NAME');
71: IF (l_Debug_Level <= 1) THEN
72: ecx_cln_debug_pub.Add('l_procedure_name - ' || l_procedure_name, 2);
73: END IF;
74:
75:
76: l_application_id := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'APPLICATION_ID');

Line 87: ecx_cln_debug_pub.Add('l_application_id - ' || l_application_id, 1);

83: l_notification_code := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_CODE');
84: l_notification_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_DESC');
85:
86: IF (l_Debug_Level <= 1) THEN
87: ecx_cln_debug_pub.Add('l_application_id - ' || l_application_id, 1);
88: ecx_cln_debug_pub.Add('l_collaboration_id - ' || l_collaboration_id, 1);
89: ecx_cln_debug_pub.Add('l_collaboration_type - ' || l_collaboration_type, 1);
90: ecx_cln_debug_pub.Add('l_reference_id - ' || l_reference_id, 1);
91: ecx_cln_debug_pub.Add('l_trading_partner_id - ' || l_trading_partner_id, 1);

Line 88: ecx_cln_debug_pub.Add('l_collaboration_id - ' || l_collaboration_id, 1);

84: l_notification_desc := wf_engine.GetActivityAttrText(p_itemtype,p_itemkey,p_actid, 'NOTIFICATION_DESC');
85:
86: IF (l_Debug_Level <= 1) THEN
87: ecx_cln_debug_pub.Add('l_application_id - ' || l_application_id, 1);
88: ecx_cln_debug_pub.Add('l_collaboration_id - ' || l_collaboration_id, 1);
89: ecx_cln_debug_pub.Add('l_collaboration_type - ' || l_collaboration_type, 1);
90: ecx_cln_debug_pub.Add('l_reference_id - ' || l_reference_id, 1);
91: ecx_cln_debug_pub.Add('l_trading_partner_id - ' || l_trading_partner_id, 1);
92: ecx_cln_debug_pub.Add('l_status - ' || l_status, 1);

Line 89: ecx_cln_debug_pub.Add('l_collaboration_type - ' || l_collaboration_type, 1);

85:
86: IF (l_Debug_Level <= 1) THEN
87: ecx_cln_debug_pub.Add('l_application_id - ' || l_application_id, 1);
88: ecx_cln_debug_pub.Add('l_collaboration_id - ' || l_collaboration_id, 1);
89: ecx_cln_debug_pub.Add('l_collaboration_type - ' || l_collaboration_type, 1);
90: ecx_cln_debug_pub.Add('l_reference_id - ' || l_reference_id, 1);
91: ecx_cln_debug_pub.Add('l_trading_partner_id - ' || l_trading_partner_id, 1);
92: ecx_cln_debug_pub.Add('l_status - ' || l_status, 1);
93: ecx_cln_debug_pub.Add('l_header_desc - ' || l_header_desc, 1);

Line 90: ecx_cln_debug_pub.Add('l_reference_id - ' || l_reference_id, 1);

86: IF (l_Debug_Level <= 1) THEN
87: ecx_cln_debug_pub.Add('l_application_id - ' || l_application_id, 1);
88: ecx_cln_debug_pub.Add('l_collaboration_id - ' || l_collaboration_id, 1);
89: ecx_cln_debug_pub.Add('l_collaboration_type - ' || l_collaboration_type, 1);
90: ecx_cln_debug_pub.Add('l_reference_id - ' || l_reference_id, 1);
91: ecx_cln_debug_pub.Add('l_trading_partner_id - ' || l_trading_partner_id, 1);
92: ecx_cln_debug_pub.Add('l_status - ' || l_status, 1);
93: ecx_cln_debug_pub.Add('l_header_desc - ' || l_header_desc, 1);
94: ecx_cln_debug_pub.Add('l_notification_code - ' || l_notification_code, 1);

Line 91: ecx_cln_debug_pub.Add('l_trading_partner_id - ' || l_trading_partner_id, 1);

87: ecx_cln_debug_pub.Add('l_application_id - ' || l_application_id, 1);
88: ecx_cln_debug_pub.Add('l_collaboration_id - ' || l_collaboration_id, 1);
89: ecx_cln_debug_pub.Add('l_collaboration_type - ' || l_collaboration_type, 1);
90: ecx_cln_debug_pub.Add('l_reference_id - ' || l_reference_id, 1);
91: ecx_cln_debug_pub.Add('l_trading_partner_id - ' || l_trading_partner_id, 1);
92: ecx_cln_debug_pub.Add('l_status - ' || l_status, 1);
93: ecx_cln_debug_pub.Add('l_header_desc - ' || l_header_desc, 1);
94: ecx_cln_debug_pub.Add('l_notification_code - ' || l_notification_code, 1);
95: ecx_cln_debug_pub.Add('l_notification_desc - ' || l_notification_desc, 1);

Line 92: ecx_cln_debug_pub.Add('l_status - ' || l_status, 1);

88: ecx_cln_debug_pub.Add('l_collaboration_id - ' || l_collaboration_id, 1);
89: ecx_cln_debug_pub.Add('l_collaboration_type - ' || l_collaboration_type, 1);
90: ecx_cln_debug_pub.Add('l_reference_id - ' || l_reference_id, 1);
91: ecx_cln_debug_pub.Add('l_trading_partner_id - ' || l_trading_partner_id, 1);
92: ecx_cln_debug_pub.Add('l_status - ' || l_status, 1);
93: ecx_cln_debug_pub.Add('l_header_desc - ' || l_header_desc, 1);
94: ecx_cln_debug_pub.Add('l_notification_code - ' || l_notification_code, 1);
95: ecx_cln_debug_pub.Add('l_notification_desc - ' || l_notification_desc, 1);
96: END IF;

Line 93: ecx_cln_debug_pub.Add('l_header_desc - ' || l_header_desc, 1);

89: ecx_cln_debug_pub.Add('l_collaboration_type - ' || l_collaboration_type, 1);
90: ecx_cln_debug_pub.Add('l_reference_id - ' || l_reference_id, 1);
91: ecx_cln_debug_pub.Add('l_trading_partner_id - ' || l_trading_partner_id, 1);
92: ecx_cln_debug_pub.Add('l_status - ' || l_status, 1);
93: ecx_cln_debug_pub.Add('l_header_desc - ' || l_header_desc, 1);
94: ecx_cln_debug_pub.Add('l_notification_code - ' || l_notification_code, 1);
95: ecx_cln_debug_pub.Add('l_notification_desc - ' || l_notification_desc, 1);
96: END IF;
97:

Line 94: ecx_cln_debug_pub.Add('l_notification_code - ' || l_notification_code, 1);

90: ecx_cln_debug_pub.Add('l_reference_id - ' || l_reference_id, 1);
91: ecx_cln_debug_pub.Add('l_trading_partner_id - ' || l_trading_partner_id, 1);
92: ecx_cln_debug_pub.Add('l_status - ' || l_status, 1);
93: ecx_cln_debug_pub.Add('l_header_desc - ' || l_header_desc, 1);
94: ecx_cln_debug_pub.Add('l_notification_code - ' || l_notification_code, 1);
95: ecx_cln_debug_pub.Add('l_notification_desc - ' || l_notification_desc, 1);
96: END IF;
97:
98:

Line 95: ecx_cln_debug_pub.Add('l_notification_desc - ' || l_notification_desc, 1);

91: ecx_cln_debug_pub.Add('l_trading_partner_id - ' || l_trading_partner_id, 1);
92: ecx_cln_debug_pub.Add('l_status - ' || l_status, 1);
93: ecx_cln_debug_pub.Add('l_header_desc - ' || l_header_desc, 1);
94: ecx_cln_debug_pub.Add('l_notification_code - ' || l_notification_code, 1);
95: ecx_cln_debug_pub.Add('l_notification_desc - ' || l_notification_desc, 1);
96: END IF;
97:
98:
99: WF_EVENT.AddParameterToList('ApplicationId',l_application_id,l_cln_not_parameters);

Line 110: ecx_cln_debug_pub.Add('INVOKING PROCEDURE - ' || l_procedure_call_statement, 2);

106: WF_EVENT.AddParameterToList('NotificationCode',l_notification_code,l_cln_not_parameters);
107: WF_EVENT.AddParameterToList('Status',l_status,l_cln_not_parameters);
108: l_procedure_call_statement := 'begin ' || l_procedure_name || '(:l_cln_not_parameters); end;';
109: IF (l_Debug_Level <= 2) THEN
110: ecx_cln_debug_pub.Add('INVOKING PROCEDURE - ' || l_procedure_call_statement, 2);
111: END IF;
112:
113: execute immediate l_procedure_call_statement using l_cln_not_parameters;
114: IF (l_Debug_Level <= 2) THEN

Line 115: ecx_cln_debug_pub.Add('COMPLETED PROCEDURE - ' || l_procedure_call_statement, 2);

111: END IF;
112:
113: execute immediate l_procedure_call_statement using l_cln_not_parameters;
114: IF (l_Debug_Level <= 2) THEN
115: ecx_cln_debug_pub.Add('COMPLETED PROCEDURE - ' || l_procedure_call_statement, 2);
116: END IF;
117:
118: x_resultout := 'Yes';
119: IF (l_Debug_Level <= 2) THEN

Line 120: ecx_cln_debug_pub.Add('EXITING CLN_NP_CONC_API_CALL.CALL_API', 2);

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

Line 127: ecx_cln_debug_pub.Add('Unexpected Exception', 2);

123: EXCEPTION
124: WHEN OTHERS THEN
125: -- Unexpected Exception
126: IF (l_Debug_Level <= 2) THEN
127: ecx_cln_debug_pub.Add('Unexpected Exception', 2);
128: END IF;
129:
130: x_resultout :='Unexpected Exception';
131: RETURN;