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_SETUP_PACKAGE dependencies on CLN_DEBUG_PUB

Line 64: cln_debug_pub.Add('----- ENTERING add_or_update_tp_detail API ------', 2);

60:
61: BEGIN
62:
63: IF (l_Debug_Level <= 2) THEN
64: cln_debug_pub.Add('----- ENTERING add_or_update_tp_detail API ------', 2);
65: END IF;
66:
67: IF (l_Debug_Level <= 1) THEN
68: cln_debug_pub.Add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++' );

Line 68: cln_debug_pub.Add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++' );

64: cln_debug_pub.Add('----- ENTERING add_or_update_tp_detail API ------', 2);
65: END IF;
66:
67: IF (l_Debug_Level <= 1) THEN
68: cln_debug_pub.Add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++' );
69: cln_debug_pub.Add('' );
70: cln_debug_pub.Add('Parameters :' );
71: cln_debug_pub.Add('p_txn_subtype ' || p_txn_subtype );
72: cln_debug_pub.Add('p_direction ' || p_direction );

Line 69: cln_debug_pub.Add('' );

65: END IF;
66:
67: IF (l_Debug_Level <= 1) THEN
68: cln_debug_pub.Add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++' );
69: cln_debug_pub.Add('' );
70: cln_debug_pub.Add('Parameters :' );
71: cln_debug_pub.Add('p_txn_subtype ' || p_txn_subtype );
72: cln_debug_pub.Add('p_direction ' || p_direction );
73: cln_debug_pub.Add('p_map ' || p_map );

Line 70: cln_debug_pub.Add('Parameters :' );

66:
67: IF (l_Debug_Level <= 1) THEN
68: cln_debug_pub.Add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++' );
69: cln_debug_pub.Add('' );
70: cln_debug_pub.Add('Parameters :' );
71: cln_debug_pub.Add('p_txn_subtype ' || p_txn_subtype );
72: cln_debug_pub.Add('p_direction ' || p_direction );
73: cln_debug_pub.Add('p_map ' || p_map );
74: cln_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id );

Line 71: cln_debug_pub.Add('p_txn_subtype ' || p_txn_subtype );

67: IF (l_Debug_Level <= 1) THEN
68: cln_debug_pub.Add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++' );
69: cln_debug_pub.Add('' );
70: cln_debug_pub.Add('Parameters :' );
71: cln_debug_pub.Add('p_txn_subtype ' || p_txn_subtype );
72: cln_debug_pub.Add('p_direction ' || p_direction );
73: cln_debug_pub.Add('p_map ' || p_map );
74: cln_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id );
75: cln_debug_pub.Add('------------------------------' );

Line 72: cln_debug_pub.Add('p_direction ' || p_direction );

68: cln_debug_pub.Add('++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++' );
69: cln_debug_pub.Add('' );
70: cln_debug_pub.Add('Parameters :' );
71: cln_debug_pub.Add('p_txn_subtype ' || p_txn_subtype );
72: cln_debug_pub.Add('p_direction ' || p_direction );
73: cln_debug_pub.Add('p_map ' || p_map );
74: cln_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id );
75: cln_debug_pub.Add('------------------------------' );
76: END IF;

Line 73: cln_debug_pub.Add('p_map ' || p_map );

69: cln_debug_pub.Add('' );
70: cln_debug_pub.Add('Parameters :' );
71: cln_debug_pub.Add('p_txn_subtype ' || p_txn_subtype );
72: cln_debug_pub.Add('p_direction ' || p_direction );
73: cln_debug_pub.Add('p_map ' || p_map );
74: cln_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id );
75: cln_debug_pub.Add('------------------------------' );
76: END IF;
77:

Line 74: cln_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id );

70: cln_debug_pub.Add('Parameters :' );
71: cln_debug_pub.Add('p_txn_subtype ' || p_txn_subtype );
72: cln_debug_pub.Add('p_direction ' || p_direction );
73: cln_debug_pub.Add('p_map ' || p_map );
74: cln_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id );
75: cln_debug_pub.Add('------------------------------' );
76: END IF;
77:
78: IF (l_Debug_Level <= 1) THEN

Line 75: cln_debug_pub.Add('------------------------------' );

71: cln_debug_pub.Add('p_txn_subtype ' || p_txn_subtype );
72: cln_debug_pub.Add('p_direction ' || p_direction );
73: cln_debug_pub.Add('p_map ' || p_map );
74: cln_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id );
75: cln_debug_pub.Add('------------------------------' );
76: END IF;
77:
78: IF (l_Debug_Level <= 1) THEN
79: cln_debug_pub.Add('- Defaulting the local variables - ', 1);

Line 79: cln_debug_pub.Add('- Defaulting the local variables - ', 1);

75: cln_debug_pub.Add('------------------------------' );
76: END IF;
77:
78: IF (l_Debug_Level <= 1) THEN
79: cln_debug_pub.Add('- Defaulting the local variables - ', 1);
80: END IF;
81:
82: l_ext_type := 'M4U';
83: l_standard_code := 'UCCNET';

Line 104: cln_debug_pub.Add('-----------------------------------' );

100: l_passwd := 'welcome';
101: END IF;
102:
103: IF (l_Debug_Level <= 1) THEN
104: cln_debug_pub.Add('-----------------------------------' );
105: cln_debug_pub.Add('l_ext_type :=M4U',1);
106: cln_debug_pub.Add('l_standard_code :=UCCNET',1);
107: cln_debug_pub.Add('l_transaction_type :=M4U',1);
108: cln_debug_pub.Add('l_party_type :=I',1);

Line 105: cln_debug_pub.Add('l_ext_type :=M4U',1);

101: END IF;
102:
103: IF (l_Debug_Level <= 1) THEN
104: cln_debug_pub.Add('-----------------------------------' );
105: cln_debug_pub.Add('l_ext_type :=M4U',1);
106: cln_debug_pub.Add('l_standard_code :=UCCNET',1);
107: cln_debug_pub.Add('l_transaction_type :=M4U',1);
108: cln_debug_pub.Add('l_party_type :=I',1);
109: cln_debug_pub.Add('l_doc_conf :=2',1);

Line 106: cln_debug_pub.Add('l_standard_code :=UCCNET',1);

102:
103: IF (l_Debug_Level <= 1) THEN
104: cln_debug_pub.Add('-----------------------------------' );
105: cln_debug_pub.Add('l_ext_type :=M4U',1);
106: cln_debug_pub.Add('l_standard_code :=UCCNET',1);
107: cln_debug_pub.Add('l_transaction_type :=M4U',1);
108: cln_debug_pub.Add('l_party_type :=I',1);
109: cln_debug_pub.Add('l_doc_conf :=2',1);
110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);

Line 107: cln_debug_pub.Add('l_transaction_type :=M4U',1);

103: IF (l_Debug_Level <= 1) THEN
104: cln_debug_pub.Add('-----------------------------------' );
105: cln_debug_pub.Add('l_ext_type :=M4U',1);
106: cln_debug_pub.Add('l_standard_code :=UCCNET',1);
107: cln_debug_pub.Add('l_transaction_type :=M4U',1);
108: cln_debug_pub.Add('l_party_type :=I',1);
109: cln_debug_pub.Add('l_doc_conf :=2',1);
110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);
111: cln_debug_pub.Add('l_hub_user_id :=null',1);

Line 108: cln_debug_pub.Add('l_party_type :=I',1);

104: cln_debug_pub.Add('-----------------------------------' );
105: cln_debug_pub.Add('l_ext_type :=M4U',1);
106: cln_debug_pub.Add('l_standard_code :=UCCNET',1);
107: cln_debug_pub.Add('l_transaction_type :=M4U',1);
108: cln_debug_pub.Add('l_party_type :=I',1);
109: cln_debug_pub.Add('l_doc_conf :=2',1);
110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);
111: cln_debug_pub.Add('l_hub_user_id :=null',1);
112: cln_debug_pub.Add('l_routing_id :=null',1);

Line 109: cln_debug_pub.Add('l_doc_conf :=2',1);

105: cln_debug_pub.Add('l_ext_type :=M4U',1);
106: cln_debug_pub.Add('l_standard_code :=UCCNET',1);
107: cln_debug_pub.Add('l_transaction_type :=M4U',1);
108: cln_debug_pub.Add('l_party_type :=I',1);
109: cln_debug_pub.Add('l_doc_conf :=2',1);
110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);
111: cln_debug_pub.Add('l_hub_user_id :=null',1);
112: cln_debug_pub.Add('l_routing_id :=null',1);
113: cln_debug_pub.Add('l_ext_loc :=null',1);

Line 110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);

106: cln_debug_pub.Add('l_standard_code :=UCCNET',1);
107: cln_debug_pub.Add('l_transaction_type :=M4U',1);
108: cln_debug_pub.Add('l_party_type :=I',1);
109: cln_debug_pub.Add('l_doc_conf :=2',1);
110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);
111: cln_debug_pub.Add('l_hub_user_id :=null',1);
112: cln_debug_pub.Add('l_routing_id :=null',1);
113: cln_debug_pub.Add('l_ext_loc :=null',1);
114: cln_debug_pub.Add('l_ext_subtype :='||l_ext_subtype,1);

Line 111: cln_debug_pub.Add('l_hub_user_id :=null',1);

107: cln_debug_pub.Add('l_transaction_type :=M4U',1);
108: cln_debug_pub.Add('l_party_type :=I',1);
109: cln_debug_pub.Add('l_doc_conf :=2',1);
110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);
111: cln_debug_pub.Add('l_hub_user_id :=null',1);
112: cln_debug_pub.Add('l_routing_id :=null',1);
113: cln_debug_pub.Add('l_ext_loc :=null',1);
114: cln_debug_pub.Add('l_ext_subtype :='||l_ext_subtype,1);
115: cln_debug_pub.Add('l_transaction_subtype :='||l_ext_subtype,1);

Line 112: cln_debug_pub.Add('l_routing_id :=null',1);

108: cln_debug_pub.Add('l_party_type :=I',1);
109: cln_debug_pub.Add('l_doc_conf :=2',1);
110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);
111: cln_debug_pub.Add('l_hub_user_id :=null',1);
112: cln_debug_pub.Add('l_routing_id :=null',1);
113: cln_debug_pub.Add('l_ext_loc :=null',1);
114: cln_debug_pub.Add('l_ext_subtype :='||l_ext_subtype,1);
115: cln_debug_pub.Add('l_transaction_subtype :='||l_ext_subtype,1);
116: cln_debug_pub.Add('l_tp_header_id :='||l_tp_hdr_id,1);

Line 113: cln_debug_pub.Add('l_ext_loc :=null',1);

109: cln_debug_pub.Add('l_doc_conf :=2',1);
110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);
111: cln_debug_pub.Add('l_hub_user_id :=null',1);
112: cln_debug_pub.Add('l_routing_id :=null',1);
113: cln_debug_pub.Add('l_ext_loc :=null',1);
114: cln_debug_pub.Add('l_ext_subtype :='||l_ext_subtype,1);
115: cln_debug_pub.Add('l_transaction_subtype :='||l_ext_subtype,1);
116: cln_debug_pub.Add('l_tp_header_id :='||l_tp_hdr_id,1);
117: cln_debug_pub.Add('l_map :='||l_map,1);

Line 114: cln_debug_pub.Add('l_ext_subtype :='||l_ext_subtype,1);

110: cln_debug_pub.Add('l_src_loc :=UCCNET_HUB',1);
111: cln_debug_pub.Add('l_hub_user_id :=null',1);
112: cln_debug_pub.Add('l_routing_id :=null',1);
113: cln_debug_pub.Add('l_ext_loc :=null',1);
114: cln_debug_pub.Add('l_ext_subtype :='||l_ext_subtype,1);
115: cln_debug_pub.Add('l_transaction_subtype :='||l_ext_subtype,1);
116: cln_debug_pub.Add('l_tp_header_id :='||l_tp_hdr_id,1);
117: cln_debug_pub.Add('l_map :='||l_map,1);
118: cln_debug_pub.Add('l_direction :='||l_direction,1);

Line 115: cln_debug_pub.Add('l_transaction_subtype :='||l_ext_subtype,1);

111: cln_debug_pub.Add('l_hub_user_id :=null',1);
112: cln_debug_pub.Add('l_routing_id :=null',1);
113: cln_debug_pub.Add('l_ext_loc :=null',1);
114: cln_debug_pub.Add('l_ext_subtype :='||l_ext_subtype,1);
115: cln_debug_pub.Add('l_transaction_subtype :='||l_ext_subtype,1);
116: cln_debug_pub.Add('l_tp_header_id :='||l_tp_hdr_id,1);
117: cln_debug_pub.Add('l_map :='||l_map,1);
118: cln_debug_pub.Add('l_direction :='||l_direction,1);
119: cln_debug_pub.Add('------------------------------' );

Line 116: cln_debug_pub.Add('l_tp_header_id :='||l_tp_hdr_id,1);

112: cln_debug_pub.Add('l_routing_id :=null',1);
113: cln_debug_pub.Add('l_ext_loc :=null',1);
114: cln_debug_pub.Add('l_ext_subtype :='||l_ext_subtype,1);
115: cln_debug_pub.Add('l_transaction_subtype :='||l_ext_subtype,1);
116: cln_debug_pub.Add('l_tp_header_id :='||l_tp_hdr_id,1);
117: cln_debug_pub.Add('l_map :='||l_map,1);
118: cln_debug_pub.Add('l_direction :='||l_direction,1);
119: cln_debug_pub.Add('------------------------------' );
120: END IF;

Line 117: cln_debug_pub.Add('l_map :='||l_map,1);

113: cln_debug_pub.Add('l_ext_loc :=null',1);
114: cln_debug_pub.Add('l_ext_subtype :='||l_ext_subtype,1);
115: cln_debug_pub.Add('l_transaction_subtype :='||l_ext_subtype,1);
116: cln_debug_pub.Add('l_tp_header_id :='||l_tp_hdr_id,1);
117: cln_debug_pub.Add('l_map :='||l_map,1);
118: cln_debug_pub.Add('l_direction :='||l_direction,1);
119: cln_debug_pub.Add('------------------------------' );
120: END IF;
121:

Line 118: cln_debug_pub.Add('l_direction :='||l_direction,1);

114: cln_debug_pub.Add('l_ext_subtype :='||l_ext_subtype,1);
115: cln_debug_pub.Add('l_transaction_subtype :='||l_ext_subtype,1);
116: cln_debug_pub.Add('l_tp_header_id :='||l_tp_hdr_id,1);
117: cln_debug_pub.Add('l_map :='||l_map,1);
118: cln_debug_pub.Add('l_direction :='||l_direction,1);
119: cln_debug_pub.Add('------------------------------' );
120: END IF;
121:
122:

Line 119: cln_debug_pub.Add('------------------------------' );

115: cln_debug_pub.Add('l_transaction_subtype :='||l_ext_subtype,1);
116: cln_debug_pub.Add('l_tp_header_id :='||l_tp_hdr_id,1);
117: cln_debug_pub.Add('l_map :='||l_map,1);
118: cln_debug_pub.Add('l_direction :='||l_direction,1);
119: cln_debug_pub.Add('------------------------------' );
120: END IF;
121:
122:
123: -- query ecx_tp_detail_id to get ecx_tp_detail_id for given location code

Line 128: cln_debug_pub.Add('- Get TP Detail ID - ', 1);

124: -- if record does not exists create a new detail record
125: -- else update the detail record
126: BEGIN
127: IF (l_Debug_Level <= 1) THEN
128: cln_debug_pub.Add('- Get TP Detail ID - ', 1);
129: END IF;
130:
131: SELECT tp_detail_id
132: INTO l_tp_dtl_id

Line 155: cln_debug_pub.Add('---- Got ECX TP Detail ID Value ----', 1);

151:
152: l_record_found := TRUE;
153:
154: IF (l_Debug_Level <= 1) THEN
155: cln_debug_pub.Add('---- Got ECX TP Detail ID Value ----', 1);
156: cln_debug_pub.Add('TP Detail Id -'||l_tp_dtl_id, 1);
157: END IF;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN

Line 156: cln_debug_pub.Add('TP Detail Id -'||l_tp_dtl_id, 1);

152: l_record_found := TRUE;
153:
154: IF (l_Debug_Level <= 1) THEN
155: cln_debug_pub.Add('---- Got ECX TP Detail ID Value ----', 1);
156: cln_debug_pub.Add('TP Detail Id -'||l_tp_dtl_id, 1);
157: END IF;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: --FND_MESSAGE.SET_NAME('CLN','M4U_TP_DTL_SETUP_NEW');

Line 165: cln_debug_pub.Add('-- TP Detail Setup for M4U does not exist --',1);

161: --l_msg_data := FND_MESSAGE.GET;
162: l_record_found := FALSE;
163:
164: IF (l_Debug_Level <= 1) THEN
165: cln_debug_pub.Add('-- TP Detail Setup for M4U does not exist --',1);
166: END IF;
167:
168: WHEN OTHERS THEN
169: FND_MESSAGE.SET_NAME('CLN','M4U_TP_DTL_SETUP_ISSUE');

Line 180: cln_debug_pub.Add('- Get Ext Process ID - ', 1);

176: END;
177:
178: BEGIN
179: IF (l_Debug_Level <= 1) THEN
180: cln_debug_pub.Add('- Get Ext Process ID - ', 1);
181: END IF;
182:
183: SELECT extp.ext_process_id
184: INTO l_ext_process_id

Line 200: cln_debug_pub.Add('---- Got Ext Process ID Value ----', 1);

196: AND txn.transaction_type = l_transaction_type
197: AND txn.transaction_subtype = l_transaction_subtype;
198:
199: IF (l_Debug_Level <= 1) THEN
200: cln_debug_pub.Add('---- Got Ext Process ID Value ----', 1);
201: cln_debug_pub.Add('Ext Process Id -'||l_ext_process_id, 1);
202: END IF;
203:
204: EXCEPTION

Line 201: cln_debug_pub.Add('Ext Process Id -'||l_ext_process_id, 1);

197: AND txn.transaction_subtype = l_transaction_subtype;
198:
199: IF (l_Debug_Level <= 1) THEN
200: cln_debug_pub.Add('---- Got Ext Process ID Value ----', 1);
201: cln_debug_pub.Add('Ext Process Id -'||l_ext_process_id, 1);
202: END IF;
203:
204: EXCEPTION
205: WHEN NO_DATA_FOUND THEN

Line 207: cln_debug_pub.Add('-- Ext Process ID does not exist --',1);

203:
204: EXCEPTION
205: WHEN NO_DATA_FOUND THEN
206: IF (l_Debug_Level <= 1) THEN
207: cln_debug_pub.Add('-- Ext Process ID does not exist --',1);
208: END IF;
209:
210: WHEN TOO_MANY_ROWS THEN
211: FND_MESSAGE.SET_NAME('CLN','M4U_EXT_PROCESS_SETUP_EXISTS');

Line 219: cln_debug_pub.Add('-- Two Many Ext Process ID for M4U exists --',1);

215: FND_MESSAGE.SET_TOKEN('PARAM4',l_standard_code);
216: l_msg_data := FND_MESSAGE.GET;
217:
218: IF (l_Debug_Level <= 1) THEN
219: cln_debug_pub.Add('-- Two Many Ext Process ID for M4U exists --',1);
220: END IF;
221: RAISE FND_API.G_EXC_ERROR;
222:
223: WHEN OTHERS THEN

Line 226: cln_debug_pub.Add('ERROR -'||l_msg_data,1);

222:
223: WHEN OTHERS THEN
224: l_msg_data := SQLCODE ||'-'||SQLERRM;
225: IF (l_Debug_Level <= 1) THEN
226: cln_debug_pub.Add('ERROR -'||l_msg_data,1);
227: cln_debug_pub.Add('-- Error in Finding the External Process ID --',1);
228: END IF;
229: RAISE FND_API.G_EXC_ERROR;
230: END;

Line 227: cln_debug_pub.Add('-- Error in Finding the External Process ID --',1);

223: WHEN OTHERS THEN
224: l_msg_data := SQLCODE ||'-'||SQLERRM;
225: IF (l_Debug_Level <= 1) THEN
226: cln_debug_pub.Add('ERROR -'||l_msg_data,1);
227: cln_debug_pub.Add('-- Error in Finding the External Process ID --',1);
228: END IF;
229: RAISE FND_API.G_EXC_ERROR;
230: END;
231:

Line 235: cln_debug_pub.Add('---- Setup ECX TP Detail Values in DB ----', 1);

231:
232:
233: IF NOT l_record_found THEN
234: IF (l_Debug_Level <= 1) THEN
235: cln_debug_pub.Add('---- Setup ECX TP Detail Values in DB ----', 1);
236: cln_debug_pub.Add('---- Call ecx_tp_api.create_tp_detail ----', 1);
237: END IF;
238:
239: ecx_tp_api.create_tp_detail(

Line 236: cln_debug_pub.Add('---- Call ecx_tp_api.create_tp_detail ----', 1);

232:
233: IF NOT l_record_found THEN
234: IF (l_Debug_Level <= 1) THEN
235: cln_debug_pub.Add('---- Setup ECX TP Detail Values in DB ----', 1);
236: cln_debug_pub.Add('---- Call ecx_tp_api.create_tp_detail ----', 1);
237: END IF;
238:
239: ecx_tp_api.create_tp_detail(
240: x_return_status => l_retcode,

Line 266: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);

262: RAISE FND_API.G_EXC_ERROR;
263: END IF;
264:
265: IF (l_Debug_Level <= 1) THEN
266: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);
267: END IF;
268: ELSE
269:
270: IF (l_Debug_Level <= 1) THEN

Line 271: cln_debug_pub.Add('---- Setup ECX TP Detail Values in DB ----', 1);

267: END IF;
268: ELSE
269:
270: IF (l_Debug_Level <= 1) THEN
271: cln_debug_pub.Add('---- Setup ECX TP Detail Values in DB ----', 1);
272: cln_debug_pub.Add('---- Call ecx_tp_api.update_tp_detail ----', 1);
273: END IF;
274: ecx_tp_api.update_tp_detail(
275: x_return_status => l_retcode,

Line 272: cln_debug_pub.Add('---- Call ecx_tp_api.update_tp_detail ----', 1);

268: ELSE
269:
270: IF (l_Debug_Level <= 1) THEN
271: cln_debug_pub.Add('---- Setup ECX TP Detail Values in DB ----', 1);
272: cln_debug_pub.Add('---- Call ecx_tp_api.update_tp_detail ----', 1);
273: END IF;
274: ecx_tp_api.update_tp_detail(
275: x_return_status => l_retcode,
276: x_msg => l_retmesg,

Line 301: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);

297: RAISE FND_API.G_EXC_ERROR;
298: END IF;
299:
300: IF (l_Debug_Level <= 1) THEN
301: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);
302: END IF;
303: END IF;
304:
305: IF l_retcode = 0 THEN

Line 310: cln_debug_pub.Add('Exiting add_or_update_tp_detail normally');

306: x_retcode := FND_API.G_RET_STS_SUCCESS;
307: x_errbuf := 'Successful';
308: END IF;
309:
310: cln_debug_pub.Add('Exiting add_or_update_tp_detail normally');
311:
312: -- Exception Handling
313: EXCEPTION
314: WHEN FND_API.G_EXC_ERROR THEN

Line 319: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);

315: x_retcode := 2;
316: x_errbuf := l_msg_data;
317:
318: IF (l_Debug_Level <= 2) THEN
319: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);
320: cln_debug_pub.Add('==========ERROR :EXTING add_or_update_tp_detail API ===========', 2);
321: END IF;
322:
323: WHEN OTHERS THEN

Line 320: cln_debug_pub.Add('==========ERROR :EXTING add_or_update_tp_detail API ===========', 2);

316: x_errbuf := l_msg_data;
317:
318: IF (l_Debug_Level <= 2) THEN
319: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);
320: cln_debug_pub.Add('==========ERROR :EXTING add_or_update_tp_detail API ===========', 2);
321: END IF;
322:
323: WHEN OTHERS THEN
324: x_retcode := 2;

Line 329: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);

325: -- Setup Failed
326: x_errbuf := SQLCODE||' - '||SQLERRM;
327:
328: IF (l_Debug_Level <= 2) THEN
329: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);
330: cln_debug_pub.Add('==========ERROR :EXTING add_or_update_tp_detail API ===========', 2);
331: END IF;
332: END;
333:

Line 330: cln_debug_pub.Add('==========ERROR :EXTING add_or_update_tp_detail API ===========', 2);

326: x_errbuf := SQLCODE||' - '||SQLERRM;
327:
328: IF (l_Debug_Level <= 2) THEN
329: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);
330: cln_debug_pub.Add('==========ERROR :EXTING add_or_update_tp_detail API ===========', 2);
331: END IF;
332: END;
333:
334:

Line 380: cln_debug_pub.Add('==========ENTERING SETUP API ===========', 2);

376:
377: BEGIN
378:
379: IF (l_Debug_Level <= 2) THEN
380: cln_debug_pub.Add('==========ENTERING SETUP API ===========', 2);
381: END IF;
382:
383: IF (l_Debug_Level <= 1) THEN
384: cln_debug_pub.Add('---- Defaulting the HR Location Values ----', 1);

Line 384: cln_debug_pub.Add('---- Defaulting the HR Location Values ----', 1);

380: cln_debug_pub.Add('==========ENTERING SETUP API ===========', 2);
381: END IF;
382:
383: IF (l_Debug_Level <= 1) THEN
384: cln_debug_pub.Add('---- Defaulting the HR Location Values ----', 1);
385: END IF;
386:
387: l_location_code := 'UCCnet';
388: l_description := 'UCCnet Data hub';

Line 394: cln_debug_pub.Add('Location code -'||l_location_code, 1);

390: l_style := 'US_GLB';
391: l_country := 'US';
392:
393: IF (l_Debug_Level <= 1) THEN
394: cln_debug_pub.Add('Location code -'||l_location_code, 1);
395: cln_debug_pub.Add('Description -'||l_description, 1);
396: cln_debug_pub.Add('Address Line 1 -'||l_addr_line_1, 1);
397: cln_debug_pub.Add('Address Style -'||l_style, 1);
398: cln_debug_pub.Add('Country -'||l_country, 1);

Line 395: cln_debug_pub.Add('Description -'||l_description, 1);

391: l_country := 'US';
392:
393: IF (l_Debug_Level <= 1) THEN
394: cln_debug_pub.Add('Location code -'||l_location_code, 1);
395: cln_debug_pub.Add('Description -'||l_description, 1);
396: cln_debug_pub.Add('Address Line 1 -'||l_addr_line_1, 1);
397: cln_debug_pub.Add('Address Style -'||l_style, 1);
398: cln_debug_pub.Add('Country -'||l_country, 1);
399: END IF;

Line 396: cln_debug_pub.Add('Address Line 1 -'||l_addr_line_1, 1);

392:
393: IF (l_Debug_Level <= 1) THEN
394: cln_debug_pub.Add('Location code -'||l_location_code, 1);
395: cln_debug_pub.Add('Description -'||l_description, 1);
396: cln_debug_pub.Add('Address Line 1 -'||l_addr_line_1, 1);
397: cln_debug_pub.Add('Address Style -'||l_style, 1);
398: cln_debug_pub.Add('Country -'||l_country, 1);
399: END IF;
400:

Line 397: cln_debug_pub.Add('Address Style -'||l_style, 1);

393: IF (l_Debug_Level <= 1) THEN
394: cln_debug_pub.Add('Location code -'||l_location_code, 1);
395: cln_debug_pub.Add('Description -'||l_description, 1);
396: cln_debug_pub.Add('Address Line 1 -'||l_addr_line_1, 1);
397: cln_debug_pub.Add('Address Style -'||l_style, 1);
398: cln_debug_pub.Add('Country -'||l_country, 1);
399: END IF;
400:
401: IF (l_Debug_Level <= 1) THEN

Line 398: cln_debug_pub.Add('Country -'||l_country, 1);

394: cln_debug_pub.Add('Location code -'||l_location_code, 1);
395: cln_debug_pub.Add('Description -'||l_description, 1);
396: cln_debug_pub.Add('Address Line 1 -'||l_addr_line_1, 1);
397: cln_debug_pub.Add('Address Style -'||l_style, 1);
398: cln_debug_pub.Add('Country -'||l_country, 1);
399: END IF;
400:
401: IF (l_Debug_Level <= 1) THEN
402: cln_debug_pub.Add('+++++++++ Check HR Location Values in DB +++++++++', 1);

Line 402: cln_debug_pub.Add('+++++++++ Check HR Location Values in DB +++++++++', 1);

398: cln_debug_pub.Add('Country -'||l_country, 1);
399: END IF;
400:
401: IF (l_Debug_Level <= 1) THEN
402: cln_debug_pub.Add('+++++++++ Check HR Location Values in DB +++++++++', 1);
403: END IF;
404:
405: -- Setup HR Locations
406: -- Check if record exists. Create Locations if it does not else Update Location value

Line 416: cln_debug_pub.Add('---- Got HR Location Values ----', 1);

412:
413: l_record_found := TRUE;
414:
415: IF (l_Debug_Level <= 1) THEN
416: cln_debug_pub.Add('---- Got HR Location Values ----', 1);
417: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
418: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
419: END IF;
420: EXCEPTION

Line 417: cln_debug_pub.Add('Location Id -'||l_location_id, 1);

413: l_record_found := TRUE;
414:
415: IF (l_Debug_Level <= 1) THEN
416: cln_debug_pub.Add('---- Got HR Location Values ----', 1);
417: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
418: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
419: END IF;
420: EXCEPTION
421: WHEN NO_DATA_FOUND THEN

Line 418: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);

414:
415: IF (l_Debug_Level <= 1) THEN
416: cln_debug_pub.Add('---- Got HR Location Values ----', 1);
417: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
418: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
419: END IF;
420: EXCEPTION
421: WHEN NO_DATA_FOUND THEN
422: l_record_found := FALSE;

Line 425: cln_debug_pub.Add('-- HR Setup for M4U does not exist --',1);

421: WHEN NO_DATA_FOUND THEN
422: l_record_found := FALSE;
423:
424: IF (l_Debug_Level <= 1) THEN
425: cln_debug_pub.Add('-- HR Setup for M4U does not exist --',1);
426: END IF;
427:
428: WHEN TOO_MANY_ROWS THEN
429: IF (l_Debug_Level <= 1) THEN

Line 430: cln_debug_pub.Add('-- HR Setup for M4U already exists with two many rows--',1);

426: END IF;
427:
428: WHEN TOO_MANY_ROWS THEN
429: IF (l_Debug_Level <= 1) THEN
430: cln_debug_pub.Add('-- HR Setup for M4U already exists with two many rows--',1);
431: cln_debug_pub.Add('-- Updating one of the records arbitrarily --',1);
432: END IF;
433:
434: SELECT location_id, object_version_number

Line 431: cln_debug_pub.Add('-- Updating one of the records arbitrarily --',1);

427:
428: WHEN TOO_MANY_ROWS THEN
429: IF (l_Debug_Level <= 1) THEN
430: cln_debug_pub.Add('-- HR Setup for M4U already exists with two many rows--',1);
431: cln_debug_pub.Add('-- Updating one of the records arbitrarily --',1);
432: END IF;
433:
434: SELECT location_id, object_version_number
435: INTO l_location_id, l_obj_ver_num

Line 443: cln_debug_pub.Add('---- Got HR Location Values limiting rownum ----', 1);

439:
440: l_record_found := TRUE;
441:
442: IF (l_Debug_Level <= 1) THEN
443: cln_debug_pub.Add('---- Got HR Location Values limiting rownum ----', 1);
444: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
445: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
446: END IF;
447:

Line 444: cln_debug_pub.Add('Location Id -'||l_location_id, 1);

440: l_record_found := TRUE;
441:
442: IF (l_Debug_Level <= 1) THEN
443: cln_debug_pub.Add('---- Got HR Location Values limiting rownum ----', 1);
444: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
445: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
446: END IF;
447:
448: WHEN OTHERS THEN

Line 445: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);

441:
442: IF (l_Debug_Level <= 1) THEN
443: cln_debug_pub.Add('---- Got HR Location Values limiting rownum ----', 1);
444: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
445: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
446: END IF;
447:
448: WHEN OTHERS THEN
449: FND_MESSAGE.SET_NAME('CLN','M4U_HR_API_ISSUE');

Line 456: cln_debug_pub.Add('---- Setup HR Location Values in DB ----', 1);

452: END;
453:
454: IF NOT l_record_found THEN
455: IF (l_Debug_Level <= 1) THEN
456: cln_debug_pub.Add('---- Setup HR Location Values in DB ----', 1);
457: cln_debug_pub.Add('---- Call HR_LOCATION_API.create_location ----', 1);
458: END IF;
459:
460: FND_MESSAGE.SET_NAME('CLN','M4U_HR_API_FAILED');

Line 457: cln_debug_pub.Add('---- Call HR_LOCATION_API.create_location ----', 1);

453:
454: IF NOT l_record_found THEN
455: IF (l_Debug_Level <= 1) THEN
456: cln_debug_pub.Add('---- Setup HR Location Values in DB ----', 1);
457: cln_debug_pub.Add('---- Call HR_LOCATION_API.create_location ----', 1);
458: END IF;
459:
460: FND_MESSAGE.SET_NAME('CLN','M4U_HR_API_FAILED');
461: FND_MESSAGE.SET_TOKEN('PARAM','Create');

Line 478: cln_debug_pub.Add('---- HR_LOCATION_API.create_location returns Normal----', 1);

474:
475: l_msg_data := 'HR Location created with success';
476:
477: IF (l_Debug_Level <= 1) THEN
478: cln_debug_pub.Add('---- HR_LOCATION_API.create_location returns Normal----', 1);
479: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
480: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
481: END IF;
482: ELSE

Line 479: cln_debug_pub.Add('Location Id -'||l_location_id, 1);

475: l_msg_data := 'HR Location created with success';
476:
477: IF (l_Debug_Level <= 1) THEN
478: cln_debug_pub.Add('---- HR_LOCATION_API.create_location returns Normal----', 1);
479: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
480: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
481: END IF;
482: ELSE
483: IF (l_Debug_Level <= 1) THEN

Line 480: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);

476:
477: IF (l_Debug_Level <= 1) THEN
478: cln_debug_pub.Add('---- HR_LOCATION_API.create_location returns Normal----', 1);
479: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
480: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
481: END IF;
482: ELSE
483: IF (l_Debug_Level <= 1) THEN
484: cln_debug_pub.Add('---- Update HR Location Values in DB ----', 1);

Line 484: cln_debug_pub.Add('---- Update HR Location Values in DB ----', 1);

480: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
481: END IF;
482: ELSE
483: IF (l_Debug_Level <= 1) THEN
484: cln_debug_pub.Add('---- Update HR Location Values in DB ----', 1);
485: cln_debug_pub.Add('---- Call HR_LOCATION_API.update_location ----', 1);
486: END IF;
487:
488: FND_MESSAGE.SET_NAME('CLN','M4U_HR_API_FAILED');

Line 485: cln_debug_pub.Add('---- Call HR_LOCATION_API.update_location ----', 1);

481: END IF;
482: ELSE
483: IF (l_Debug_Level <= 1) THEN
484: cln_debug_pub.Add('---- Update HR Location Values in DB ----', 1);
485: cln_debug_pub.Add('---- Call HR_LOCATION_API.update_location ----', 1);
486: END IF;
487:
488: FND_MESSAGE.SET_NAME('CLN','M4U_HR_API_FAILED');
489: FND_MESSAGE.SET_TOKEN('PARAM','Update');

Line 506: cln_debug_pub.Add('---- HR_LOCATION_API.update_location returns Normal----', 1);

502:
503: l_msg_data := 'HR Location updated with success';
504:
505: IF (l_Debug_Level <= 1) THEN
506: cln_debug_pub.Add('---- HR_LOCATION_API.update_location returns Normal----', 1);
507: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
508: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
509: END IF;
510: END IF;

Line 507: cln_debug_pub.Add('Location Id -'||l_location_id, 1);

503: l_msg_data := 'HR Location updated with success';
504:
505: IF (l_Debug_Level <= 1) THEN
506: cln_debug_pub.Add('---- HR_LOCATION_API.update_location returns Normal----', 1);
507: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
508: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
509: END IF;
510: END IF;
511:

Line 508: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);

504:
505: IF (l_Debug_Level <= 1) THEN
506: cln_debug_pub.Add('---- HR_LOCATION_API.update_location returns Normal----', 1);
507: cln_debug_pub.Add('Location Id -'||l_location_id, 1);
508: cln_debug_pub.Add('Object Version No -'||l_obj_ver_num, 1);
509: END IF;
510: END IF;
511:
512:

Line 514: cln_debug_pub.Add('+++++++++ Setup ECX TP Header Values +++++++++', 1);

510: END IF;
511:
512:
513: IF (l_Debug_Level <= 1) THEN
514: cln_debug_pub.Add('+++++++++ Setup ECX TP Header Values +++++++++', 1);
515: END IF;
516:
517: -- reset the value for next phase
518: l_record_found := FALSE;

Line 534: cln_debug_pub.Add('---- Got ECX TP Header Values ----', 1);

530:
531: l_record_found := TRUE;
532:
533: IF (l_Debug_Level <= 1) THEN
534: cln_debug_pub.Add('---- Got ECX TP Header Values ----', 1);
535: cln_debug_pub.Add('TP Header Id -'||l_tp_hdr_id, 1);
536: END IF;
537:
538: EXCEPTION

Line 535: cln_debug_pub.Add('TP Header Id -'||l_tp_hdr_id, 1);

531: l_record_found := TRUE;
532:
533: IF (l_Debug_Level <= 1) THEN
534: cln_debug_pub.Add('---- Got ECX TP Header Values ----', 1);
535: cln_debug_pub.Add('TP Header Id -'||l_tp_hdr_id, 1);
536: END IF;
537:
538: EXCEPTION
539: WHEN NO_DATA_FOUND THEN

Line 543: cln_debug_pub.Add('-- TP Header Setup for M4U does not exist --',1);

539: WHEN NO_DATA_FOUND THEN
540: l_record_found := FALSE;
541:
542: IF (l_Debug_Level <= 1) THEN
543: cln_debug_pub.Add('-- TP Header Setup for M4U does not exist --',1);
544: END IF;
545:
546: WHEN OTHERS THEN
547: FND_MESSAGE.SET_NAME('CLN','M4U_TP_HDR_SETUP_ISSUE');

Line 554: cln_debug_pub.Add('---- Setup ECX TP Header Values in DB ----', 1);

550: END;
551:
552: IF NOT l_record_found THEN
553: IF (l_Debug_Level <= 1) THEN
554: cln_debug_pub.Add('---- Setup ECX TP Header Values in DB ----', 1);
555: cln_debug_pub.Add('---- Call ecx_tp_api.create_trading_partner ----', 1);
556: END IF;
557:
558: ecx_tp_api.create_trading_partner(

Line 555: cln_debug_pub.Add('---- Call ecx_tp_api.create_trading_partner ----', 1);

551:
552: IF NOT l_record_found THEN
553: IF (l_Debug_Level <= 1) THEN
554: cln_debug_pub.Add('---- Setup ECX TP Header Values in DB ----', 1);
555: cln_debug_pub.Add('---- Call ecx_tp_api.create_trading_partner ----', 1);
556: END IF;
557:
558: ecx_tp_api.create_trading_partner(
559: x_return_status => l_retcode,

Line 569: cln_debug_pub.Add('---- Return Values From API ----', 1);

565: p_company_admin_email => '[email protected]'
566: );
567:
568: IF (l_Debug_Level <= 1) THEN
569: cln_debug_pub.Add('---- Return Values From API ----', 1);
570: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
571: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
572: END IF;
573:

Line 570: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

566: );
567:
568: IF (l_Debug_Level <= 1) THEN
569: cln_debug_pub.Add('---- Return Values From API ----', 1);
570: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
571: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
572: END IF;
573:
574: IF l_retcode <> 0 THEN

Line 571: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

567:
568: IF (l_Debug_Level <= 1) THEN
569: cln_debug_pub.Add('---- Return Values From API ----', 1);
570: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
571: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
572: END IF;
573:
574: IF l_retcode <> 0 THEN
575: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPHDR_API_FAILED');

Line 582: cln_debug_pub.Add('---- ecx_tp_api.create_trading_partner returns Normal----', 1);

578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:
581: IF (l_Debug_Level <= 1) THEN
582: cln_debug_pub.Add('---- ecx_tp_api.create_trading_partner returns Normal----', 1);
583: END IF;
584: ELSE
585: IF (l_Debug_Level <= 1) THEN
586: cln_debug_pub.Add('---- Update ECX TP Header Values in DB ----', 1);

Line 586: cln_debug_pub.Add('---- Update ECX TP Header Values in DB ----', 1);

582: cln_debug_pub.Add('---- ecx_tp_api.create_trading_partner returns Normal----', 1);
583: END IF;
584: ELSE
585: IF (l_Debug_Level <= 1) THEN
586: cln_debug_pub.Add('---- Update ECX TP Header Values in DB ----', 1);
587: cln_debug_pub.Add('---- Call ecx_tp_api.update_trading_partner ----', 1);
588: END IF;
589:
590: ecx_tp_api.update_trading_partner(

Line 587: cln_debug_pub.Add('---- Call ecx_tp_api.update_trading_partner ----', 1);

583: END IF;
584: ELSE
585: IF (l_Debug_Level <= 1) THEN
586: cln_debug_pub.Add('---- Update ECX TP Header Values in DB ----', 1);
587: cln_debug_pub.Add('---- Call ecx_tp_api.update_trading_partner ----', 1);
588: END IF;
589:
590: ecx_tp_api.update_trading_partner(
591: x_return_status => l_retcode,

Line 598: cln_debug_pub.Add('---- Return Values From API ----', 1);

594: p_company_admin_email => '[email protected]'
595: );
596:
597: IF (l_Debug_Level <= 1) THEN
598: cln_debug_pub.Add('---- Return Values From API ----', 1);
599: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
600: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
601: END IF;
602:

Line 599: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

595: );
596:
597: IF (l_Debug_Level <= 1) THEN
598: cln_debug_pub.Add('---- Return Values From API ----', 1);
599: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
600: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
601: END IF;
602:
603: IF l_retcode <> 0 THEN

Line 600: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

596:
597: IF (l_Debug_Level <= 1) THEN
598: cln_debug_pub.Add('---- Return Values From API ----', 1);
599: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
600: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
601: END IF;
602:
603: IF l_retcode <> 0 THEN
604: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPHDR_API_FAILED');

Line 611: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);

607: RAISE FND_API.G_EXC_ERROR;
608: END IF;
609:
610: IF (l_Debug_Level <= 1) THEN
611: cln_debug_pub.Add('---- ecx_tp_api.update_trading_partner returns Normal----', 1);
612: END IF;
613: END IF;
614:
615: IF (l_Debug_Level <= 1) THEN

Line 616: cln_debug_pub.Add('+++++++++ Setup ECX TP Details Values ++++++++', 1);

612: END IF;
613: END IF;
614:
615: IF (l_Debug_Level <= 1) THEN
616: cln_debug_pub.Add('+++++++++ Setup ECX TP Details Values ++++++++', 1);
617: END IF;
618:
619: -- setup ECX TP details
620: --1

Line 623: cln_debug_pub.Add('---- Return Values From API ----', 1);

619: -- setup ECX TP details
620: --1
621: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'CIN','m4u_230_cin_out','OUT',l_tp_hdr_id);
622: IF (l_Debug_Level <= 1) THEN
623: cln_debug_pub.Add('---- Return Values From API ----', 1);
624: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
625: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
626: END IF;
627:

Line 624: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

620: --1
621: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'CIN','m4u_230_cin_out','OUT',l_tp_hdr_id);
622: IF (l_Debug_Level <= 1) THEN
623: cln_debug_pub.Add('---- Return Values From API ----', 1);
624: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
625: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
626: END IF;
627:
628: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 625: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

621: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'CIN','m4u_230_cin_out','OUT',l_tp_hdr_id);
622: IF (l_Debug_Level <= 1) THEN
623: cln_debug_pub.Add('---- Return Values From API ----', 1);
624: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
625: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
626: END IF;
627:
628: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
629: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 637: cln_debug_pub.Add('---- Return Values From API ----', 1);

633:
634: --2
635: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'GBREGQRY','m4u_230_gbreg_qry_out','OUT',l_tp_hdr_id);
636: IF (l_Debug_Level <= 1) THEN
637: cln_debug_pub.Add('---- Return Values From API ----', 1);
638: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
639: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
640: END IF;
641:

Line 638: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

634: --2
635: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'GBREGQRY','m4u_230_gbreg_qry_out','OUT',l_tp_hdr_id);
636: IF (l_Debug_Level <= 1) THEN
637: cln_debug_pub.Add('---- Return Values From API ----', 1);
638: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
639: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
640: END IF;
641:
642: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 639: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

635: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'GBREGQRY','m4u_230_gbreg_qry_out','OUT',l_tp_hdr_id);
636: IF (l_Debug_Level <= 1) THEN
637: cln_debug_pub.Add('---- Return Values From API ----', 1);
638: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
639: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
640: END IF;
641:
642: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
643: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 652: cln_debug_pub.Add('---- Return Values From API ----', 1);

648:
649: --3
650: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'PARTYQRY','m4u_230_party_qry_out','OUT',l_tp_hdr_id);
651: IF (l_Debug_Level <= 1) THEN
652: cln_debug_pub.Add('---- Return Values From API ----', 1);
653: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
654: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
655: END IF;
656:

Line 653: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

649: --3
650: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'PARTYQRY','m4u_230_party_qry_out','OUT',l_tp_hdr_id);
651: IF (l_Debug_Level <= 1) THEN
652: cln_debug_pub.Add('---- Return Values From API ----', 1);
653: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
654: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
655: END IF;
656:
657: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 654: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

650: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'PARTYQRY','m4u_230_party_qry_out','OUT',l_tp_hdr_id);
651: IF (l_Debug_Level <= 1) THEN
652: cln_debug_pub.Add('---- Return Values From API ----', 1);
653: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
654: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
655: END IF;
656:
657: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
658: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 667: cln_debug_pub.Add('---- Return Values From API ----', 1);

663:
664: --4
665: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RCIR','m4u_230_rcir_out','OUT',l_tp_hdr_id);
666: IF (l_Debug_Level <= 1) THEN
667: cln_debug_pub.Add('---- Return Values From API ----', 1);
668: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
669: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
670: END IF;
671:

Line 668: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

664: --4
665: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RCIR','m4u_230_rcir_out','OUT',l_tp_hdr_id);
666: IF (l_Debug_Level <= 1) THEN
667: cln_debug_pub.Add('---- Return Values From API ----', 1);
668: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
669: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
670: END IF;
671:
672: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 669: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

665: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RCIR','m4u_230_rcir_out','OUT',l_tp_hdr_id);
666: IF (l_Debug_Level <= 1) THEN
667: cln_debug_pub.Add('---- Return Values From API ----', 1);
668: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
669: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
670: END IF;
671:
672: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
673: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 681: cln_debug_pub.Add('---- Return Values From API ----', 1);

677:
678: --5
679: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'WLQ','m4u_230_wlq_out','OUT',l_tp_hdr_id);
680: IF (l_Debug_Level <= 1) THEN
681: cln_debug_pub.Add('---- Return Values From API ----', 1);
682: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
683: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
684: END IF;
685:

Line 682: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

678: --5
679: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'WLQ','m4u_230_wlq_out','OUT',l_tp_hdr_id);
680: IF (l_Debug_Level <= 1) THEN
681: cln_debug_pub.Add('---- Return Values From API ----', 1);
682: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
683: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
684: END IF;
685:
686: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 683: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

679: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'WLQ','m4u_230_wlq_out','OUT',l_tp_hdr_id);
680: IF (l_Debug_Level <= 1) THEN
681: cln_debug_pub.Add('---- Return Values From API ----', 1);
682: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
683: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
684: END IF;
685:
686: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
687: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 695: cln_debug_pub.Add('---- Return Values From API ----', 1);

691:
692: --6
693: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_ACK','m4u_230_resp_ack_in','IN',l_tp_hdr_id);
694: IF (l_Debug_Level <= 1) THEN
695: cln_debug_pub.Add('---- Return Values From API ----', 1);
696: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
697: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
698: END IF;
699:

Line 696: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

692: --6
693: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_ACK','m4u_230_resp_ack_in','IN',l_tp_hdr_id);
694: IF (l_Debug_Level <= 1) THEN
695: cln_debug_pub.Add('---- Return Values From API ----', 1);
696: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
697: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
698: END IF;
699:
700: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 697: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

693: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_ACK','m4u_230_resp_ack_in','IN',l_tp_hdr_id);
694: IF (l_Debug_Level <= 1) THEN
695: cln_debug_pub.Add('---- Return Values From API ----', 1);
696: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
697: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
698: END IF;
699:
700: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
701: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 709: cln_debug_pub.Add('---- Return Values From API ----', 1);

705:
706: --7
707: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_BATCH','m4u_230_resp_batch_in','IN',l_tp_hdr_id);
708: IF (l_Debug_Level <= 1) THEN
709: cln_debug_pub.Add('---- Return Values From API ----', 1);
710: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
711: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
712: END IF;
713:

Line 710: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

706: --7
707: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_BATCH','m4u_230_resp_batch_in','IN',l_tp_hdr_id);
708: IF (l_Debug_Level <= 1) THEN
709: cln_debug_pub.Add('---- Return Values From API ----', 1);
710: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
711: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
712: END IF;
713:
714: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 711: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

707: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_BATCH','m4u_230_resp_batch_in','IN',l_tp_hdr_id);
708: IF (l_Debug_Level <= 1) THEN
709: cln_debug_pub.Add('---- Return Values From API ----', 1);
710: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
711: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
712: END IF;
713:
714: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
715: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 723: cln_debug_pub.Add('---- Return Values From API ----', 1);

719:
720: --8
721: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_CIC','m4u_230_resp_cic_in','IN',l_tp_hdr_id);
722: IF (l_Debug_Level <= 1) THEN
723: cln_debug_pub.Add('---- Return Values From API ----', 1);
724: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
725: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
726: END IF;
727:

Line 724: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

720: --8
721: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_CIC','m4u_230_resp_cic_in','IN',l_tp_hdr_id);
722: IF (l_Debug_Level <= 1) THEN
723: cln_debug_pub.Add('---- Return Values From API ----', 1);
724: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
725: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
726: END IF;
727:
728: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 725: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

721: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_CIC','m4u_230_resp_cic_in','IN',l_tp_hdr_id);
722: IF (l_Debug_Level <= 1) THEN
723: cln_debug_pub.Add('---- Return Values From API ----', 1);
724: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
725: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
726: END IF;
727:
728: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
729: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 737: cln_debug_pub.Add('---- Return Values From API ----', 1);

733:
734: --9
735: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_GTIN','m4u_230_resp_gbregqry_in','IN',l_tp_hdr_id);
736: IF (l_Debug_Level <= 1) THEN
737: cln_debug_pub.Add('---- Return Values From API ----', 1);
738: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
739: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
740: END IF;
741:

Line 738: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

734: --9
735: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_GTIN','m4u_230_resp_gbregqry_in','IN',l_tp_hdr_id);
736: IF (l_Debug_Level <= 1) THEN
737: cln_debug_pub.Add('---- Return Values From API ----', 1);
738: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
739: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
740: END IF;
741:
742: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 739: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

735: M4U_SETUP_PACKAGE.add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_GTIN','m4u_230_resp_gbregqry_in','IN',l_tp_hdr_id);
736: IF (l_Debug_Level <= 1) THEN
737: cln_debug_pub.Add('---- Return Values From API ----', 1);
738: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
739: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
740: END IF;
741:
742: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
743: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 751: cln_debug_pub.Add('---- Return Values From API ----', 1);

747:
748: --10
749: add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_PARTY','m4u_230_resp_partyqry_in','IN',l_tp_hdr_id);
750: IF (l_Debug_Level <= 1) THEN
751: cln_debug_pub.Add('---- Return Values From API ----', 1);
752: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
753: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
754: END IF;
755:

Line 752: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

748: --10
749: add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_PARTY','m4u_230_resp_partyqry_in','IN',l_tp_hdr_id);
750: IF (l_Debug_Level <= 1) THEN
751: cln_debug_pub.Add('---- Return Values From API ----', 1);
752: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
753: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
754: END IF;
755:
756: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 753: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

749: add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_PARTY','m4u_230_resp_partyqry_in','IN',l_tp_hdr_id);
750: IF (l_Debug_Level <= 1) THEN
751: cln_debug_pub.Add('---- Return Values From API ----', 1);
752: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
753: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
754: END IF;
755:
756: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
757: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 765: cln_debug_pub.Add('---- Return Values From API ----', 1);

761:
762: --11
763: add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_RFCIN','m4u_230_resp_rfcin_in','IN',l_tp_hdr_id);
764: IF (l_Debug_Level <= 1) THEN
765: cln_debug_pub.Add('---- Return Values From API ----', 1);
766: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
767: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
768: END IF;
769:

Line 766: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);

762: --11
763: add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_RFCIN','m4u_230_resp_rfcin_in','IN',l_tp_hdr_id);
764: IF (l_Debug_Level <= 1) THEN
765: cln_debug_pub.Add('---- Return Values From API ----', 1);
766: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
767: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
768: END IF;
769:
770: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 767: cln_debug_pub.Add('Return Code - '||l_retcode, 1);

763: add_or_update_tp_detail(l_retmesg,l_retcode,'RESP_RFCIN','m4u_230_resp_rfcin_in','IN',l_tp_hdr_id);
764: IF (l_Debug_Level <= 1) THEN
765: cln_debug_pub.Add('---- Return Values From API ----', 1);
766: cln_debug_pub.Add('Return Message - '||l_retmesg, 1);
767: cln_debug_pub.Add('Return Code - '||l_retcode, 1);
768: END IF;
769:
770: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
771: FND_MESSAGE.SET_NAME('CLN','M4U_ECXTPDTL_FAILURE');

Line 781: cln_debug_pub.Add('==========EXTING SETUP API :NORMALLY===========', 2);

777: x_errbuf := 'SUCCESS';
778:
779:
780: IF (l_Debug_Level <= 2) THEN
781: cln_debug_pub.Add('==========EXTING SETUP API :NORMALLY===========', 2);
782: END IF;
783:
784: EXCEPTION
785: WHEN FND_API.G_EXC_ERROR THEN

Line 790: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);

786: x_retcode := 2;
787: x_errbuf := l_msg_data;
788:
789: IF (l_Debug_Level <= 2) THEN
790: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);
791: cln_debug_pub.Add('==========ERROR :EXTING SETUP API ===========', 2);
792: END IF;
793:
794: WHEN OTHERS THEN

Line 791: cln_debug_pub.Add('==========ERROR :EXTING SETUP API ===========', 2);

787: x_errbuf := l_msg_data;
788:
789: IF (l_Debug_Level <= 2) THEN
790: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);
791: cln_debug_pub.Add('==========ERROR :EXTING SETUP API ===========', 2);
792: END IF;
793:
794: WHEN OTHERS THEN
795: x_retcode := 2;

Line 801: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);

797: -- Setup Failed
798: x_errbuf := FND_MESSAGE.GET || ' - ' ||SQLCODE||' - '||SQLERRM;
799:
800: IF (l_Debug_Level <= 2) THEN
801: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);
802: cln_debug_pub.Add('==========ERROR :EXTING SETUP API ===========', 2);
803: END IF;
804: END SETUP;
805:

Line 802: cln_debug_pub.Add('==========ERROR :EXTING SETUP API ===========', 2);

798: x_errbuf := FND_MESSAGE.GET || ' - ' ||SQLCODE||' - '||SQLERRM;
799:
800: IF (l_Debug_Level <= 2) THEN
801: cln_debug_pub.Add('ERROR : '||x_errbuf, 2);
802: cln_debug_pub.Add('==========ERROR :EXTING SETUP API ===========', 2);
803: END IF;
804: END SETUP;
805:
806: END M4U_SETUP_PACKAGE;