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.ITG_SETUP dependencies on ITG_DEBUG_PUB

Line 50: itg_debug_pub.Add('ENTERING setup' ,1);

46: BEGIN
47: G_EXEC_PROC_NAME := 'setup';
48:
49: IF (l_Debug_Level <= 2) THEN
50: itg_debug_pub.Add('ENTERING setup' ,1);
51: END IF;
52:
53: l_location_code := 'OIPC Default TP';
54: l_description := 'Default XMLG TP for ITG';

Line 61: itg_debug_pub.Add('------------------------------' ,1);

57: l_style := 'US_GLB';
58:
59:
60: IF (l_Debug_Level <= 1) THEN
61: itg_debug_pub.Add('------------------------------' ,1);
62: itg_debug_pub.Add('Procedure executed with params' ,1);
63: itg_debug_pub.Add('l_location_code'|| l_location_code,1);
64: itg_debug_pub.Add('l_description ' || l_description ,1);
65: itg_debug_pub.Add('l_addr_line_1 ' || l_addr_line_1 ,1);

Line 62: itg_debug_pub.Add('Procedure executed with params' ,1);

58:
59:
60: IF (l_Debug_Level <= 1) THEN
61: itg_debug_pub.Add('------------------------------' ,1);
62: itg_debug_pub.Add('Procedure executed with params' ,1);
63: itg_debug_pub.Add('l_location_code'|| l_location_code,1);
64: itg_debug_pub.Add('l_description ' || l_description ,1);
65: itg_debug_pub.Add('l_addr_line_1 ' || l_addr_line_1 ,1);
66: itg_debug_pub.Add('l_country ' || l_country ,1);

Line 63: itg_debug_pub.Add('l_location_code'|| l_location_code,1);

59:
60: IF (l_Debug_Level <= 1) THEN
61: itg_debug_pub.Add('------------------------------' ,1);
62: itg_debug_pub.Add('Procedure executed with params' ,1);
63: itg_debug_pub.Add('l_location_code'|| l_location_code,1);
64: itg_debug_pub.Add('l_description ' || l_description ,1);
65: itg_debug_pub.Add('l_addr_line_1 ' || l_addr_line_1 ,1);
66: itg_debug_pub.Add('l_country ' || l_country ,1);
67: itg_debug_pub.Add('l_style ' || l_style ,1);

Line 64: itg_debug_pub.Add('l_description ' || l_description ,1);

60: IF (l_Debug_Level <= 1) THEN
61: itg_debug_pub.Add('------------------------------' ,1);
62: itg_debug_pub.Add('Procedure executed with params' ,1);
63: itg_debug_pub.Add('l_location_code'|| l_location_code,1);
64: itg_debug_pub.Add('l_description ' || l_description ,1);
65: itg_debug_pub.Add('l_addr_line_1 ' || l_addr_line_1 ,1);
66: itg_debug_pub.Add('l_country ' || l_country ,1);
67: itg_debug_pub.Add('l_style ' || l_style ,1);
68: itg_debug_pub.Add('------------------------------' ,1);

Line 65: itg_debug_pub.Add('l_addr_line_1 ' || l_addr_line_1 ,1);

61: itg_debug_pub.Add('------------------------------' ,1);
62: itg_debug_pub.Add('Procedure executed with params' ,1);
63: itg_debug_pub.Add('l_location_code'|| l_location_code,1);
64: itg_debug_pub.Add('l_description ' || l_description ,1);
65: itg_debug_pub.Add('l_addr_line_1 ' || l_addr_line_1 ,1);
66: itg_debug_pub.Add('l_country ' || l_country ,1);
67: itg_debug_pub.Add('l_style ' || l_style ,1);
68: itg_debug_pub.Add('------------------------------' ,1);
69: END IF;

Line 66: itg_debug_pub.Add('l_country ' || l_country ,1);

62: itg_debug_pub.Add('Procedure executed with params' ,1);
63: itg_debug_pub.Add('l_location_code'|| l_location_code,1);
64: itg_debug_pub.Add('l_description ' || l_description ,1);
65: itg_debug_pub.Add('l_addr_line_1 ' || l_addr_line_1 ,1);
66: itg_debug_pub.Add('l_country ' || l_country ,1);
67: itg_debug_pub.Add('l_style ' || l_style ,1);
68: itg_debug_pub.Add('------------------------------' ,1);
69: END IF;
70:

Line 67: itg_debug_pub.Add('l_style ' || l_style ,1);

63: itg_debug_pub.Add('l_location_code'|| l_location_code,1);
64: itg_debug_pub.Add('l_description ' || l_description ,1);
65: itg_debug_pub.Add('l_addr_line_1 ' || l_addr_line_1 ,1);
66: itg_debug_pub.Add('l_country ' || l_country ,1);
67: itg_debug_pub.Add('l_style ' || l_style ,1);
68: itg_debug_pub.Add('------------------------------' ,1);
69: END IF;
70:
71: setup_hr_loc(l_retmesg,l_retcode,l_location_code,l_description,

Line 68: itg_debug_pub.Add('------------------------------' ,1);

64: itg_debug_pub.Add('l_description ' || l_description ,1);
65: itg_debug_pub.Add('l_addr_line_1 ' || l_addr_line_1 ,1);
66: itg_debug_pub.Add('l_country ' || l_country ,1);
67: itg_debug_pub.Add('l_style ' || l_style ,1);
68: itg_debug_pub.Add('------------------------------' ,1);
69: END IF;
70:
71: setup_hr_loc(l_retmesg,l_retcode,l_location_code,l_description,
72: l_addr_line_1,l_country,l_style);

Line 75: itg_debug_pub.Add('setup_hr_loc_data - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);

71: setup_hr_loc(l_retmesg,l_retcode,l_location_code,l_description,
72: l_addr_line_1,l_country,l_style);
73:
74: IF (l_Debug_Level <= 5) THEN
75: itg_debug_pub.Add('setup_hr_loc_data - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);
76: END IF;
77:
78: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
79: x_retcode := 2;

Line 87: itg_debug_pub.Add('setup_ecx_tp_header - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);

83:
84: setup_ecx_tp_header(l_retmesg,l_retcode,l_tp_hdr_id,l_location_code,'[email protected]');
85:
86: IF (l_Debug_Level <= 5) THEN
87: itg_debug_pub.Add('setup_ecx_tp_header - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);
88: itg_debug_pub.Add('setup_ecx_tp_header returns - tp_header_id - ' || l_tp_hdr_id, 5);
89: END IF;
90:
91: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN

Line 88: itg_debug_pub.Add('setup_ecx_tp_header returns - tp_header_id - ' || l_tp_hdr_id, 5);

84: setup_ecx_tp_header(l_retmesg,l_retcode,l_tp_hdr_id,l_location_code,'[email protected]');
85:
86: IF (l_Debug_Level <= 5) THEN
87: itg_debug_pub.Add('setup_ecx_tp_header - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);
88: itg_debug_pub.Add('setup_ecx_tp_header returns - tp_header_id - ' || l_tp_hdr_id, 5);
89: END IF;
90:
91: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
92: x_retcode := 2;

Line 100: itg_debug_pub.Add('setup_tp_details - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);

96:
97: setup_tp_details(l_retmesg,l_retcode,l_tp_hdr_id);
98:
99: IF (l_Debug_Level <= 5) THEN
100: itg_debug_pub.Add('setup_tp_details - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);
101: END IF;
102:
103: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
104: x_retcode := 2;

Line 112: itg_debug_pub.Add('trigger_control(true) - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);

108:
109: trigger_control(l_retmesg,l_retcode,true);
110:
111: IF (l_Debug_Level <= 5) THEN
112: itg_debug_pub.Add('trigger_control(true) - ' || l_retcode || ' - ' || substr(l_retmesg,1,200), 5);
113: END IF;
114:
115: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
116: x_retcode := 2;

Line 125: itg_debug_pub.Add('EXITING itg_setup.setup successful', 2);

121: x_retcode := 0;
122: x_errbuf := 'Successful';
123:
124: IF (l_Debug_Level <= 2) THEN
125: itg_debug_pub.Add('EXITING itg_setup.setup successful', 2);
126: END IF;
127:
128: -- Exception Handling
129: EXCEPTION

Line 136: itg_debug_pub.Add(x_errbuf, 6);

132: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
133: x_errbuf := 'ITG Setup failed : ' || x_errbuf;
134:
135: IF (l_Debug_Level <= 6) THEN
136: itg_debug_pub.Add(x_errbuf, 6);
137: itg_debug_pub.Add('EXITING itg_setup.setup fails,returns on exception', 6);
138: END IF;
139:
140: END;

Line 137: itg_debug_pub.Add('EXITING itg_setup.setup fails,returns on exception', 6);

133: x_errbuf := 'ITG Setup failed : ' || x_errbuf;
134:
135: IF (l_Debug_Level <= 6) THEN
136: itg_debug_pub.Add(x_errbuf, 6);
137: itg_debug_pub.Add('EXITING itg_setup.setup fails,returns on exception', 6);
138: END IF;
139:
140: END;
141:

Line 183: itg_debug_pub.Add('ENTERING setup_hr_loc' ,1);

179: BEGIN
180: G_EXEC_PROC_NAME := 'setup_hr_loc';
181:
182: IF (l_Debug_Level <= 2 ) THEN
183: itg_debug_pub.Add('ENTERING setup_hr_loc' ,1);
184: END IF;
185:
186: IF (l_Debug_Level <= 1 ) THEN
187: itg_debug_pub.Add('------------------------------' ,1);

Line 187: itg_debug_pub.Add('------------------------------' ,1);

183: itg_debug_pub.Add('ENTERING setup_hr_loc' ,1);
184: END IF;
185:
186: IF (l_Debug_Level <= 1 ) THEN
187: itg_debug_pub.Add('------------------------------' ,1);
188: itg_debug_pub.Add('Procedure setup_hr_loc executed with params' ,1 );
189: itg_debug_pub.Add('p_location_code'|| p_location_code,1);
190: itg_debug_pub.Add('p_description ' || p_description ,1);
191: itg_debug_pub.Add('p_addr_line_1 ' || p_addr_line_1 ,1);

Line 188: itg_debug_pub.Add('Procedure setup_hr_loc executed with params' ,1 );

184: END IF;
185:
186: IF (l_Debug_Level <= 1 ) THEN
187: itg_debug_pub.Add('------------------------------' ,1);
188: itg_debug_pub.Add('Procedure setup_hr_loc executed with params' ,1 );
189: itg_debug_pub.Add('p_location_code'|| p_location_code,1);
190: itg_debug_pub.Add('p_description ' || p_description ,1);
191: itg_debug_pub.Add('p_addr_line_1 ' || p_addr_line_1 ,1);
192: itg_debug_pub.Add('p_country ' || p_country ,1);

Line 189: itg_debug_pub.Add('p_location_code'|| p_location_code,1);

185:
186: IF (l_Debug_Level <= 1 ) THEN
187: itg_debug_pub.Add('------------------------------' ,1);
188: itg_debug_pub.Add('Procedure setup_hr_loc executed with params' ,1 );
189: itg_debug_pub.Add('p_location_code'|| p_location_code,1);
190: itg_debug_pub.Add('p_description ' || p_description ,1);
191: itg_debug_pub.Add('p_addr_line_1 ' || p_addr_line_1 ,1);
192: itg_debug_pub.Add('p_country ' || p_country ,1);
193: itg_debug_pub.Add('p_style ' || p_style ,1);

Line 190: itg_debug_pub.Add('p_description ' || p_description ,1);

186: IF (l_Debug_Level <= 1 ) THEN
187: itg_debug_pub.Add('------------------------------' ,1);
188: itg_debug_pub.Add('Procedure setup_hr_loc executed with params' ,1 );
189: itg_debug_pub.Add('p_location_code'|| p_location_code,1);
190: itg_debug_pub.Add('p_description ' || p_description ,1);
191: itg_debug_pub.Add('p_addr_line_1 ' || p_addr_line_1 ,1);
192: itg_debug_pub.Add('p_country ' || p_country ,1);
193: itg_debug_pub.Add('p_style ' || p_style ,1);
194: itg_debug_pub.Add('------------------------------' ,1);

Line 191: itg_debug_pub.Add('p_addr_line_1 ' || p_addr_line_1 ,1);

187: itg_debug_pub.Add('------------------------------' ,1);
188: itg_debug_pub.Add('Procedure setup_hr_loc executed with params' ,1 );
189: itg_debug_pub.Add('p_location_code'|| p_location_code,1);
190: itg_debug_pub.Add('p_description ' || p_description ,1);
191: itg_debug_pub.Add('p_addr_line_1 ' || p_addr_line_1 ,1);
192: itg_debug_pub.Add('p_country ' || p_country ,1);
193: itg_debug_pub.Add('p_style ' || p_style ,1);
194: itg_debug_pub.Add('------------------------------' ,1);
195: END IF;

Line 192: itg_debug_pub.Add('p_country ' || p_country ,1);

188: itg_debug_pub.Add('Procedure setup_hr_loc executed with params' ,1 );
189: itg_debug_pub.Add('p_location_code'|| p_location_code,1);
190: itg_debug_pub.Add('p_description ' || p_description ,1);
191: itg_debug_pub.Add('p_addr_line_1 ' || p_addr_line_1 ,1);
192: itg_debug_pub.Add('p_country ' || p_country ,1);
193: itg_debug_pub.Add('p_style ' || p_style ,1);
194: itg_debug_pub.Add('------------------------------' ,1);
195: END IF;
196:

Line 193: itg_debug_pub.Add('p_style ' || p_style ,1);

189: itg_debug_pub.Add('p_location_code'|| p_location_code,1);
190: itg_debug_pub.Add('p_description ' || p_description ,1);
191: itg_debug_pub.Add('p_addr_line_1 ' || p_addr_line_1 ,1);
192: itg_debug_pub.Add('p_country ' || p_country ,1);
193: itg_debug_pub.Add('p_style ' || p_style ,1);
194: itg_debug_pub.Add('------------------------------' ,1);
195: END IF;
196:
197: -- validate params check for non-null

Line 194: itg_debug_pub.Add('------------------------------' ,1);

190: itg_debug_pub.Add('p_description ' || p_description ,1);
191: itg_debug_pub.Add('p_addr_line_1 ' || p_addr_line_1 ,1);
192: itg_debug_pub.Add('p_country ' || p_country ,1);
193: itg_debug_pub.Add('p_style ' || p_style ,1);
194: itg_debug_pub.Add('------------------------------' ,1);
195: END IF;
196:
197: -- validate params check for non-null
198: -- if validation fails return error message and bailout.

Line 211: itg_debug_pub.Add('Missing mandatory parameter for itg_setup.setup_hr_loc',6);

207: -- the Concurrent Request submit form itself will validate that input parameters
208: -- are entered by the user.
209: x_errbuf := 'Missing mandatory parameter for itg_setup.setup_hr_loc';
210: IF (l_Debug_Level <= 6 ) THEN
211: itg_debug_pub.Add('Missing mandatory parameter for itg_setup.setup_hr_loc',6);
212: END IF;
213:
214: RETURN;
215: END IF;

Line 227: itg_debug_pub.Add('---------------------------------',1);

223: FETCH check_hrloc_data INTO l_location_id, l_obj_ver_num;
224: l_record_found := check_hrloc_data%FOUND;
225:
226: IF (l_Debug_Level <= 1 ) THEN
227: itg_debug_pub.Add('---------------------------------',1);
228: itg_debug_pub.Add('Cursor check_hrloc_data ',1);
229: END IF;
230:
231: IF l_record_found THEN

Line 228: itg_debug_pub.Add('Cursor check_hrloc_data ',1);

224: l_record_found := check_hrloc_data%FOUND;
225:
226: IF (l_Debug_Level <= 1 ) THEN
227: itg_debug_pub.Add('---------------------------------',1);
228: itg_debug_pub.Add('Cursor check_hrloc_data ',1);
229: END IF;
230:
231: IF l_record_found THEN
232: IF (l_Debug_Level <= 1 ) THEN

Line 233: itg_debug_pub.Add('l_record_found - true ' ,1);

229: END IF;
230:
231: IF l_record_found THEN
232: IF (l_Debug_Level <= 1 ) THEN
233: itg_debug_pub.Add('l_record_found - true ' ,1);
234: END IF;
235: ELSE
236: IF (l_Debug_Level <= 1 ) THEN
237: itg_debug_pub.Add('l_record_found - false' ,1);

Line 237: itg_debug_pub.Add('l_record_found - false' ,1);

233: itg_debug_pub.Add('l_record_found - true ' ,1);
234: END IF;
235: ELSE
236: IF (l_Debug_Level <= 1 ) THEN
237: itg_debug_pub.Add('l_record_found - false' ,1);
238: END IF;
239: END IF;
240:
241: IF (l_Debug_Level <= 1 ) THEN

Line 242: itg_debug_pub.Add('l_location_id ' || l_location_id ,1);

238: END IF;
239: END IF;
240:
241: IF (l_Debug_Level <= 1 ) THEN
242: itg_debug_pub.Add('l_location_id ' || l_location_id ,1);
243: itg_debug_pub.Add('l_obj_ver_num ' || l_obj_ver_num ,1);
244: itg_debug_pub.Add('---------------------------------',1);
245: END IF;
246:

Line 243: itg_debug_pub.Add('l_obj_ver_num ' || l_obj_ver_num ,1);

239: END IF;
240:
241: IF (l_Debug_Level <= 1 ) THEN
242: itg_debug_pub.Add('l_location_id ' || l_location_id ,1);
243: itg_debug_pub.Add('l_obj_ver_num ' || l_obj_ver_num ,1);
244: itg_debug_pub.Add('---------------------------------',1);
245: END IF;
246:
247: CLOSE check_hrloc_data;

Line 244: itg_debug_pub.Add('---------------------------------',1);

240:
241: IF (l_Debug_Level <= 1 ) THEN
242: itg_debug_pub.Add('l_location_id ' || l_location_id ,1);
243: itg_debug_pub.Add('l_obj_ver_num ' || l_obj_ver_num ,1);
244: itg_debug_pub.Add('---------------------------------',1);
245: END IF;
246:
247: CLOSE check_hrloc_data;
248:

Line 262: itg_debug_pub.Add('---------------------------------' ,1);

258: p_location_id => l_location_id,
259: p_object_version_number => l_obj_ver_num );
260:
261: IF (l_Debug_Level <= 1 ) THEN
262: itg_debug_pub.Add('---------------------------------' ,1);
263: itg_debug_pub.Add('HR_LOCATION_API.create_location returns normal',1);
264: itg_debug_pub.Add('l_location_id ' || l_location_id ,1);
265: itg_debug_pub.Add('l_obj_ver_num ' || l_obj_ver_num ,1);
266: itg_debug_pub.Add('---------------------------------',1);

Line 263: itg_debug_pub.Add('HR_LOCATION_API.create_location returns normal',1);

259: p_object_version_number => l_obj_ver_num );
260:
261: IF (l_Debug_Level <= 1 ) THEN
262: itg_debug_pub.Add('---------------------------------' ,1);
263: itg_debug_pub.Add('HR_LOCATION_API.create_location returns normal',1);
264: itg_debug_pub.Add('l_location_id ' || l_location_id ,1);
265: itg_debug_pub.Add('l_obj_ver_num ' || l_obj_ver_num ,1);
266: itg_debug_pub.Add('---------------------------------',1);
267: END IF;

Line 264: itg_debug_pub.Add('l_location_id ' || l_location_id ,1);

260:
261: IF (l_Debug_Level <= 1 ) THEN
262: itg_debug_pub.Add('---------------------------------' ,1);
263: itg_debug_pub.Add('HR_LOCATION_API.create_location returns normal',1);
264: itg_debug_pub.Add('l_location_id ' || l_location_id ,1);
265: itg_debug_pub.Add('l_obj_ver_num ' || l_obj_ver_num ,1);
266: itg_debug_pub.Add('---------------------------------',1);
267: END IF;
268: ELSE

Line 265: itg_debug_pub.Add('l_obj_ver_num ' || l_obj_ver_num ,1);

261: IF (l_Debug_Level <= 1 ) THEN
262: itg_debug_pub.Add('---------------------------------' ,1);
263: itg_debug_pub.Add('HR_LOCATION_API.create_location returns normal',1);
264: itg_debug_pub.Add('l_location_id ' || l_location_id ,1);
265: itg_debug_pub.Add('l_obj_ver_num ' || l_obj_ver_num ,1);
266: itg_debug_pub.Add('---------------------------------',1);
267: END IF;
268: ELSE
269: HR_LOCATION_API.update_location(

Line 266: itg_debug_pub.Add('---------------------------------',1);

262: itg_debug_pub.Add('---------------------------------' ,1);
263: itg_debug_pub.Add('HR_LOCATION_API.create_location returns normal',1);
264: itg_debug_pub.Add('l_location_id ' || l_location_id ,1);
265: itg_debug_pub.Add('l_obj_ver_num ' || l_obj_ver_num ,1);
266: itg_debug_pub.Add('---------------------------------',1);
267: END IF;
268: ELSE
269: HR_LOCATION_API.update_location(
270: p_effective_date => sysdate,

Line 284: itg_debug_pub.Add('HR_LOCATION_API.update_location returns normal' ,1);

280: p_location_id => l_location_id,
281: p_object_version_number => l_obj_ver_num );
282:
283: IF (l_Debug_Level <= 1 ) THEN
284: itg_debug_pub.Add('HR_LOCATION_API.update_location returns normal' ,1);
285: END IF;
286: END IF;
287:
288: x_retcode := FND_API.G_RET_STS_SUCCESS;

Line 292: itg_debug_pub.Add('EXITING itg_setup.setup_hr_loc returns normal' ,2);

288: x_retcode := FND_API.G_RET_STS_SUCCESS;
289: x_errbuf := 'Successful';
290:
291: IF (l_Debug_Level <= 2 ) THEN
292: itg_debug_pub.Add('EXITING itg_setup.setup_hr_loc returns normal' ,2);
293: END IF;
294:
295: -- Exception Handling
296: EXCEPTION

Line 302: itg_debug_pub.Add(x_errbuf,6);

298: x_retcode := FND_API.G_RET_STS_ERROR;
299: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
300:
301: IF (l_Debug_Level <= 6 ) THEN
302: itg_debug_pub.Add(x_errbuf,6);
303: itg_debug_pub.Add('EXITING itg_setup.setup_hr_loc fails,returns on exception',6);
304: END IF;
305: END;
306:

Line 303: itg_debug_pub.Add('EXITING itg_setup.setup_hr_loc fails,returns on exception',6);

299: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
300:
301: IF (l_Debug_Level <= 6 ) THEN
302: itg_debug_pub.Add(x_errbuf,6);
303: itg_debug_pub.Add('EXITING itg_setup.setup_hr_loc fails,returns on exception',6);
304: END IF;
305: END;
306:
307: -- Name

Line 347: itg_debug_pub.Add('ENTERING trigger_control ' ,2);

343: BEGIN
344: G_EXEC_PROC_NAME := 'trigger_control';
345:
346: IF (l_Debug_Level <= 2 ) THEN
347: itg_debug_pub.Add('ENTERING trigger_control ' ,2);
348: END IF;
349:
350: IF p_enable THEN
351: l_action := 'ENABLE';

Line 358: itg_debug_pub.Add(l_action || ' - ' || trigger_list(i));

354: END IF;
355: FOR i IN trigger_list.first .. trigger_list.last LOOP
356: BEGIN
357: EXECUTE IMMEDIATE 'ALTER TRIGGER '||trigger_list(i)||' '||l_action;
358: itg_debug_pub.Add(l_action || ' - ' || trigger_list(i));
359: EXCEPTION
360: WHEN OTHERS THEN
361: IF (l_Debug_Level <= 5 ) THEN
362: itg_debug_pub.Add('itg_setup.trigger_control(true) - ' || SQLCODE || ' - ' || SQLERRM, 5);

Line 362: itg_debug_pub.Add('itg_setup.trigger_control(true) - ' || SQLCODE || ' - ' || SQLERRM, 5);

358: itg_debug_pub.Add(l_action || ' - ' || trigger_list(i));
359: EXCEPTION
360: WHEN OTHERS THEN
361: IF (l_Debug_Level <= 5 ) THEN
362: itg_debug_pub.Add('itg_setup.trigger_control(true) - ' || SQLCODE || ' - ' || SQLERRM, 5);
363: END IF;
364: END;
365: END LOOP;
366:

Line 371: itg_debug_pub.Add('EXITING itg_setup.trigger_control(true) returns normal' ,2);

367: x_retcode := FND_API.G_RET_STS_SUCCESS;
368: x_errbuf := 'Successful';
369:
370: IF (l_Debug_Level <= 2 ) THEN
371: itg_debug_pub.Add('EXITING itg_setup.trigger_control(true) returns normal' ,2);
372: END IF;
373: EXCEPTION
374: WHEN OTHERS THEN
375: x_retcode := FND_API.G_RET_STS_ERROR;

Line 379: itg_debug_pub.Add(x_errbuf ,6);

375: x_retcode := FND_API.G_RET_STS_ERROR;
376: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
377:
378: IF (l_Debug_Level <= 6 ) THEN
379: itg_debug_pub.Add(x_errbuf ,6);
380: itg_debug_pub.Add('EXITING itg_setup.trigger_control(true) fails,returns on exception', 6);
381: END IF;
382: END;
383:

Line 380: itg_debug_pub.Add('EXITING itg_setup.trigger_control(true) fails,returns on exception', 6);

376: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
377:
378: IF (l_Debug_Level <= 6 ) THEN
379: itg_debug_pub.Add(x_errbuf ,6);
380: itg_debug_pub.Add('EXITING itg_setup.trigger_control(true) fails,returns on exception', 6);
381: END IF;
382: END;
383:
384: -- Name

Line 422: itg_debug_pub.Add('ENTERING setup_ecx_tp_header' ,2);

418: BEGIN
419: G_EXEC_PROC_NAME := 'setup_ecx_tp_header';
420:
421: IF (l_Debug_Level <= 2 ) THEN
422: itg_debug_pub.Add('ENTERING setup_ecx_tp_header' ,2);
423: END IF;
424:
425: IF (l_Debug_Level <= 1 ) THEN
426: itg_debug_pub.Add('------------------------------' ,1);

Line 426: itg_debug_pub.Add('------------------------------' ,1);

422: itg_debug_pub.Add('ENTERING setup_ecx_tp_header' ,2);
423: END IF;
424:
425: IF (l_Debug_Level <= 1 ) THEN
426: itg_debug_pub.Add('------------------------------' ,1);
427: itg_debug_pub.Add('Procedure setup_ecx_tp_header executed with params' ,1 );
428: itg_debug_pub.Add('p_location_code'|| p_location_code ,1);
429: itg_debug_pub.Add('------------------------------' ,1);
430: END IF;

Line 427: itg_debug_pub.Add('Procedure setup_ecx_tp_header executed with params' ,1 );

423: END IF;
424:
425: IF (l_Debug_Level <= 1 ) THEN
426: itg_debug_pub.Add('------------------------------' ,1);
427: itg_debug_pub.Add('Procedure setup_ecx_tp_header executed with params' ,1 );
428: itg_debug_pub.Add('p_location_code'|| p_location_code ,1);
429: itg_debug_pub.Add('------------------------------' ,1);
430: END IF;
431:

Line 428: itg_debug_pub.Add('p_location_code'|| p_location_code ,1);

424:
425: IF (l_Debug_Level <= 1 ) THEN
426: itg_debug_pub.Add('------------------------------' ,1);
427: itg_debug_pub.Add('Procedure setup_ecx_tp_header executed with params' ,1 );
428: itg_debug_pub.Add('p_location_code'|| p_location_code ,1);
429: itg_debug_pub.Add('------------------------------' ,1);
430: END IF;
431:
432: SELECT location_id

Line 429: itg_debug_pub.Add('------------------------------' ,1);

425: IF (l_Debug_Level <= 1 ) THEN
426: itg_debug_pub.Add('------------------------------' ,1);
427: itg_debug_pub.Add('Procedure setup_ecx_tp_header executed with params' ,1 );
428: itg_debug_pub.Add('p_location_code'|| p_location_code ,1);
429: itg_debug_pub.Add('------------------------------' ,1);
430: END IF;
431:
432: SELECT location_id
433: INTO l_loc_id

Line 438: itg_debug_pub.Add('Obtained location id - ' || l_loc_id,1);

434: FROM hr_locations_all
435: WHERE location_code = p_location_code;
436:
437: IF (l_Debug_Level <= 1 ) THEN
438: itg_debug_pub.Add('Obtained location id - ' || l_loc_id,1);
439: END IF;
440: -- query ecx_tp_headers to get tp_header_id for a given trading partner setup
441: -- If no record is found create a tp header block else update it
442:

Line 448: itg_debug_pub.Add('---------------------------------',1);

444: FETCH check_ecx_tp_hdr INTO l_tp_hdr_id;
445: l_found := check_ecx_tp_hdr%FOUND;
446:
447: IF (l_Debug_Level <= 1 ) THEN
448: itg_debug_pub.Add('---------------------------------',1);
449: itg_debug_pub.Add('Cursor check_ecx_tp_hdr ',1);
450: END IF;
451:
452: IF l_found THEN

Line 449: itg_debug_pub.Add('Cursor check_ecx_tp_hdr ',1);

445: l_found := check_ecx_tp_hdr%FOUND;
446:
447: IF (l_Debug_Level <= 1 ) THEN
448: itg_debug_pub.Add('---------------------------------',1);
449: itg_debug_pub.Add('Cursor check_ecx_tp_hdr ',1);
450: END IF;
451:
452: IF l_found THEN
453: IF (l_Debug_Level <= 1 ) THEN

Line 454: itg_debug_pub.Add('check_ecx_tp_hdr%FOUND - true ' ,1);

450: END IF;
451:
452: IF l_found THEN
453: IF (l_Debug_Level <= 1 ) THEN
454: itg_debug_pub.Add('check_ecx_tp_hdr%FOUND - true ' ,1);
455: END IF;
456: ELSE
457: IF (l_Debug_Level <= 1 ) THEN
458: itg_debug_pub.Add('check_ecx_tp_hdr%FOUND - false',1);

Line 458: itg_debug_pub.Add('check_ecx_tp_hdr%FOUND - false',1);

454: itg_debug_pub.Add('check_ecx_tp_hdr%FOUND - true ' ,1);
455: END IF;
456: ELSE
457: IF (l_Debug_Level <= 1 ) THEN
458: itg_debug_pub.Add('check_ecx_tp_hdr%FOUND - false',1);
459: END IF;
460: END IF;
461:
462: IF (l_Debug_Level <= 1 ) THEN

Line 463: itg_debug_pub.Add('l_tp_hdr_id ' || l_tp_hdr_id ,1);

459: END IF;
460: END IF;
461:
462: IF (l_Debug_Level <= 1 ) THEN
463: itg_debug_pub.Add('l_tp_hdr_id ' || l_tp_hdr_id ,1);
464: itg_debug_pub.Add('---------------------------------',1);
465: END IF;
466:
467: CLOSE check_ecx_tp_hdr;

Line 464: itg_debug_pub.Add('---------------------------------',1);

460: END IF;
461:
462: IF (l_Debug_Level <= 1 ) THEN
463: itg_debug_pub.Add('l_tp_hdr_id ' || l_tp_hdr_id ,1);
464: itg_debug_pub.Add('---------------------------------',1);
465: END IF;
466:
467: CLOSE check_ecx_tp_hdr;
468:

Line 480: itg_debug_pub.Add('---------------------------------',1);

476: p_party_site_id => l_loc_id ,
477: p_company_admin_email => p_email_id
478: );
479: IF (l_Debug_Level <= 1 ) THEN
480: itg_debug_pub.Add('---------------------------------',1);
481: itg_debug_pub.Add('ecx_tp_api.create_trading_partner returns normal',1);
482: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
483: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
484: itg_debug_pub.Add('x_tp_header_id ' || l_tp_hdr_id ,1);

Line 481: itg_debug_pub.Add('ecx_tp_api.create_trading_partner returns normal',1);

477: p_company_admin_email => p_email_id
478: );
479: IF (l_Debug_Level <= 1 ) THEN
480: itg_debug_pub.Add('---------------------------------',1);
481: itg_debug_pub.Add('ecx_tp_api.create_trading_partner returns normal',1);
482: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
483: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
484: itg_debug_pub.Add('x_tp_header_id ' || l_tp_hdr_id ,1);
485: itg_debug_pub.Add('---------------------------------',1);

Line 482: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);

478: );
479: IF (l_Debug_Level <= 1 ) THEN
480: itg_debug_pub.Add('---------------------------------',1);
481: itg_debug_pub.Add('ecx_tp_api.create_trading_partner returns normal',1);
482: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
483: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
484: itg_debug_pub.Add('x_tp_header_id ' || l_tp_hdr_id ,1);
485: itg_debug_pub.Add('---------------------------------',1);
486: END IF;

Line 483: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);

479: IF (l_Debug_Level <= 1 ) THEN
480: itg_debug_pub.Add('---------------------------------',1);
481: itg_debug_pub.Add('ecx_tp_api.create_trading_partner returns normal',1);
482: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
483: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
484: itg_debug_pub.Add('x_tp_header_id ' || l_tp_hdr_id ,1);
485: itg_debug_pub.Add('---------------------------------',1);
486: END IF;
487: ELSE

Line 484: itg_debug_pub.Add('x_tp_header_id ' || l_tp_hdr_id ,1);

480: itg_debug_pub.Add('---------------------------------',1);
481: itg_debug_pub.Add('ecx_tp_api.create_trading_partner returns normal',1);
482: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
483: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
484: itg_debug_pub.Add('x_tp_header_id ' || l_tp_hdr_id ,1);
485: itg_debug_pub.Add('---------------------------------',1);
486: END IF;
487: ELSE
488: -- this is an overkill for ITG

Line 485: itg_debug_pub.Add('---------------------------------',1);

481: itg_debug_pub.Add('ecx_tp_api.create_trading_partner returns normal',1);
482: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
483: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
484: itg_debug_pub.Add('x_tp_header_id ' || l_tp_hdr_id ,1);
485: itg_debug_pub.Add('---------------------------------',1);
486: END IF;
487: ELSE
488: -- this is an overkill for ITG
489: -- the email id will not be used for anything

Line 498: itg_debug_pub.Add('---------------------------------',1);

494: p_company_admin_email => p_email_id
495: );
496:
497: IF (l_Debug_Level <= 1 ) THEN
498: itg_debug_pub.Add('---------------------------------',1);
499: itg_debug_pub.Add('ecx_tp_api.update_trading_partner returns normal',1);
500: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
501: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
502: itg_debug_pub.Add('---------------------------------' ,1);

Line 499: itg_debug_pub.Add('ecx_tp_api.update_trading_partner returns normal',1);

495: );
496:
497: IF (l_Debug_Level <= 1 ) THEN
498: itg_debug_pub.Add('---------------------------------',1);
499: itg_debug_pub.Add('ecx_tp_api.update_trading_partner returns normal',1);
500: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
501: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
502: itg_debug_pub.Add('---------------------------------' ,1);
503: END IF;

Line 500: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);

496:
497: IF (l_Debug_Level <= 1 ) THEN
498: itg_debug_pub.Add('---------------------------------',1);
499: itg_debug_pub.Add('ecx_tp_api.update_trading_partner returns normal',1);
500: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
501: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
502: itg_debug_pub.Add('---------------------------------' ,1);
503: END IF;
504: END IF;

Line 501: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);

497: IF (l_Debug_Level <= 1 ) THEN
498: itg_debug_pub.Add('---------------------------------',1);
499: itg_debug_pub.Add('ecx_tp_api.update_trading_partner returns normal',1);
500: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
501: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
502: itg_debug_pub.Add('---------------------------------' ,1);
503: END IF;
504: END IF;
505:

Line 502: itg_debug_pub.Add('---------------------------------' ,1);

498: itg_debug_pub.Add('---------------------------------',1);
499: itg_debug_pub.Add('ecx_tp_api.update_trading_partner returns normal',1);
500: itg_debug_pub.Add('x_return_status ' || l_retcode ,1);
501: itg_debug_pub.Add('x_msg ' || l_retmesg ,1);
502: itg_debug_pub.Add('---------------------------------' ,1);
503: END IF;
504: END IF;
505:
506: IF l_retcode <> 0 THEN

Line 517: itg_debug_pub.Add('EXITING itg_setup.setup_ecx_tp_header returns normal' ,1);

513: x_tp_hdr_id := l_tp_hdr_id;
514: END IF;
515:
516: IF (l_Debug_Level <= 1 ) THEN
517: itg_debug_pub.Add('EXITING itg_setup.setup_ecx_tp_header returns normal' ,1);
518: itg_debug_pub.Add('x_errbuf - ' || x_errbuf ,1);
519: itg_debug_pub.Add('x_retcode - ' || x_retcode ,1);
520: itg_debug_pub.Add('x_tp_hdr_id - ' || x_tp_hdr_id ,1);
521: itg_debug_pub.Add('---------------------------------' ,1);

Line 518: itg_debug_pub.Add('x_errbuf - ' || x_errbuf ,1);

514: END IF;
515:
516: IF (l_Debug_Level <= 1 ) THEN
517: itg_debug_pub.Add('EXITING itg_setup.setup_ecx_tp_header returns normal' ,1);
518: itg_debug_pub.Add('x_errbuf - ' || x_errbuf ,1);
519: itg_debug_pub.Add('x_retcode - ' || x_retcode ,1);
520: itg_debug_pub.Add('x_tp_hdr_id - ' || x_tp_hdr_id ,1);
521: itg_debug_pub.Add('---------------------------------' ,1);
522: END IF;

Line 519: itg_debug_pub.Add('x_retcode - ' || x_retcode ,1);

515:
516: IF (l_Debug_Level <= 1 ) THEN
517: itg_debug_pub.Add('EXITING itg_setup.setup_ecx_tp_header returns normal' ,1);
518: itg_debug_pub.Add('x_errbuf - ' || x_errbuf ,1);
519: itg_debug_pub.Add('x_retcode - ' || x_retcode ,1);
520: itg_debug_pub.Add('x_tp_hdr_id - ' || x_tp_hdr_id ,1);
521: itg_debug_pub.Add('---------------------------------' ,1);
522: END IF;
523: -- Exception Handling

Line 520: itg_debug_pub.Add('x_tp_hdr_id - ' || x_tp_hdr_id ,1);

516: IF (l_Debug_Level <= 1 ) THEN
517: itg_debug_pub.Add('EXITING itg_setup.setup_ecx_tp_header returns normal' ,1);
518: itg_debug_pub.Add('x_errbuf - ' || x_errbuf ,1);
519: itg_debug_pub.Add('x_retcode - ' || x_retcode ,1);
520: itg_debug_pub.Add('x_tp_hdr_id - ' || x_tp_hdr_id ,1);
521: itg_debug_pub.Add('---------------------------------' ,1);
522: END IF;
523: -- Exception Handling
524: EXCEPTION

Line 521: itg_debug_pub.Add('---------------------------------' ,1);

517: itg_debug_pub.Add('EXITING itg_setup.setup_ecx_tp_header returns normal' ,1);
518: itg_debug_pub.Add('x_errbuf - ' || x_errbuf ,1);
519: itg_debug_pub.Add('x_retcode - ' || x_retcode ,1);
520: itg_debug_pub.Add('x_tp_hdr_id - ' || x_tp_hdr_id ,1);
521: itg_debug_pub.Add('---------------------------------' ,1);
522: END IF;
523: -- Exception Handling
524: EXCEPTION
525: WHEN OTHERS THEN

Line 531: itg_debug_pub.Add(x_errbuf ,6);

527: x_tp_hdr_id := NULL;
528: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
529:
530: IF (l_Debug_Level <= 6 )THEN
531: itg_debug_pub.Add(x_errbuf ,6);
532: itg_debug_pub.Add('EXITING itg_setup.setup_ecx_tp_header fails,returns on exception',6);
533: END IF;
534: END;
535:

Line 532: itg_debug_pub.Add('EXITING itg_setup.setup_ecx_tp_header fails,returns on exception',6);

528: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
529:
530: IF (l_Debug_Level <= 6 )THEN
531: itg_debug_pub.Add(x_errbuf ,6);
532: itg_debug_pub.Add('EXITING itg_setup.setup_ecx_tp_header fails,returns on exception',6);
533: END IF;
534: END;
535:
536:

Line 551: itg_debug_pub.Add('ENTERING setup_tp_details API' ,2);

547: BEGIN
548: G_EXEC_PROC_NAME := 'setup_tp_details';
549:
550: IF (l_Debug_Level <= 2 )THEN
551: itg_debug_pub.Add('ENTERING setup_tp_details API' ,2);
552: END IF;
553:
554:
555: add_or_update_tp_detail(l_retmesg,l_retcode,l_tp_dtl_id,

Line 560: itg_debug_pub.Add('SYNC_PO_RELEASE - ' || l_retcode || l_retmesg, 1);

556: 'ITG','SYNC_PO_RELEASE','OAG','ITG','SYNC_PO_RELEASE','OUT',
557: 'itg_sync_po_release_007_out','DIRECT',null,'ITG03','129.0.0.1',
558: 'itg','welcome',null,'ITG03',null,2,p_tp_hdr_id,'I');
559: IF (l_Debug_Level <= 1 )THEN
560: itg_debug_pub.Add('SYNC_PO_RELEASE - ' || l_retcode || l_retmesg, 1);
561: END IF;
562:
563: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
564: x_retcode := FND_API.G_RET_STS_ERROR;

Line 574: itg_debug_pub.Add('CANCEL_PO_RELEASE - ' || l_retcode || l_retmesg, 1);

570: 'ITG','CANCEL_PO_RELEASE','OAG','ITG','CANCEL_PO_RELEASE','OUT',
571: 'itg_cancel_po_release_006_out','DIRECT',null,'ITG03','129.0.0.1',
572: 'itg','welcome',null,'ITG03',null,2,p_tp_hdr_id,'I');
573: IF (l_Debug_Level <= 1 )THEN
574: itg_debug_pub.Add('CANCEL_PO_RELEASE - ' || l_retcode || l_retmesg, 1);
575: END IF;
576:
577: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
578: x_retcode := FND_API.G_RET_STS_ERROR;

Line 588: itg_debug_pub.Add('CANCEL_PO - ' || l_retcode || l_retmesg ,1);

584: 'ITG','CANCEL_PO','OAG','ITG','CANCEL_PO','OUT',
585: 'itg_cancel_po_006_out','DIRECT',null,'ITG03','129.0.0.1',
586: 'itg','welcome',null,'ITG03',null,2,p_tp_hdr_id,'I');
587: IF (l_Debug_Level <= 1 )THEN
588: itg_debug_pub.Add('CANCEL_PO - ' || l_retcode || l_retmesg ,1);
589: END IF;
590:
591: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
592: x_retcode := FND_API.G_RET_STS_ERROR;

Line 602: itg_debug_pub.Add('ADD_REQUISITN - ' || l_retcode || l_retmesg, 1);

598: 'ITG','ADD_REQUISITN','OAG','ITG','ADD_REQUISITN','OUT',
599: 'itg_add_requisitn_005_out','DIRECT',null,'ITG03','129.0.0.1',
600: 'itg','welcome',null,'ITG03',null,2,p_tp_hdr_id,'I');
601: IF (l_Debug_Level <= 1 )THEN
602: itg_debug_pub.Add('ADD_REQUISITN - ' || l_retcode || l_retmesg, 1);
603: END IF;
604:
605: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
606: x_retcode := FND_API.G_RET_STS_ERROR;

Line 616: itg_debug_pub.Add('CHANGE_REQUISITN - ' || l_retcode || l_retmesg, 1);

612: 'ITG','CHANGE_REQUISITN','OAG','ITG','CHANGE_REQUISITN','OUT',
613: 'itg_change_requisitn_005_out','DIRECT',null,'ITG03','129.0.0.1',
614: 'itg','welcome',null,'ITG03',null,2,p_tp_hdr_id,'I');
615: IF (l_Debug_Level <= 1 )THEN
616: itg_debug_pub.Add('CHANGE_REQUISITN - ' || l_retcode || l_retmesg, 1);
617: END IF;
618:
619: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
620: x_retcode := FND_API.G_RET_STS_ERROR;

Line 630: itg_debug_pub.Add('CANCEL_REQUISITN - ' || l_retcode || l_retmesg, 1);

626: 'ITG','CANCEL_REQUISITN','OAG','ITG','CANCEL_REQUISITN','OUT',
627: 'itg_cancel_requisitn_005','DIRECT',null,'ITG03','129.0.0.1',
628: 'itg','welcome',null,'ITG03',null,2,p_tp_hdr_id,'I');
629: IF (l_Debug_Level <= 1 )THEN
630: itg_debug_pub.Add('CANCEL_REQUISITN - ' || l_retcode || l_retmesg, 1);
631: END IF;
632:
633: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
634: x_retcode := FND_API.G_RET_STS_ERROR;

Line 644: itg_debug_pub.Add('SYNC_PO - ' || l_retcode || l_retmesg , 1);

640: 'ITG','SYNC_PO','OAG','ITG','SYNC_PO','OUT',
641: 'itg_sync_po_007_out','DIRECT',null,'ITG03','129.0.0.1',
642: 'itg','welcome',null,'ITG03',null,2,p_tp_hdr_id,'I');
643: IF (l_Debug_Level <= 1 )THEN
644: itg_debug_pub.Add('SYNC_PO - ' || l_retcode || l_retmesg , 1);
645: END IF;
646:
647: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
648: x_retcode := FND_API.G_RET_STS_ERROR;

Line 658: itg_debug_pub.Add('UPDATE_DELIVERY - ' || l_retcode || l_retmesg, 1);

654: 'ITG','UPDATE_DELIVERY','OAG','ITG','UPDATE_DELIVERY','OUT',
655: 'itg_update_delivery_005','DIRECT',null,'ITG03','129.0.0.1',
656: 'itg','welcome',null,'ITG03',null,2,p_tp_hdr_id,'I');
657: IF (l_Debug_Level <= 1 )THEN
658: itg_debug_pub.Add('UPDATE_DELIVERY - ' || l_retcode || l_retmesg, 1);
659: END IF;
660:
661: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
662: x_retcode := FND_API.G_RET_STS_ERROR;

Line 673: itg_debug_pub.Add('UPDATE_DELIVERY - ' || l_retcode || l_retmesg, 1);

669: 'itg_load_plinvoice_004','DIRECT',null,'ITG03','129.0.0.1',
670: 'itg','welcome',null,'ITG03',null,2,p_tp_hdr_id,'I');
671:
672: IF (l_Debug_Level <= 1 )THEN
673: itg_debug_pub.Add('UPDATE_DELIVERY - ' || l_retcode || l_retmesg, 1);
674: END IF;
675:
676: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
677: x_retcode := FND_API.G_RET_STS_ERROR;

Line 687: itg_debug_pub.Add('CBODO - ' || l_retcode || l_retmesg , 1);

683: 'ECX','CBODO','OAG','BOD','CONFIRM','OUT',
684: 'ECX_CBODO_OAG72_OUT_CONFIRM','DIRECT',null,'ITG03','129.0.0.1',
685: 'itg','welcome',null,'ITG03',null,2,p_tp_hdr_id,'I');
686: IF (l_Debug_Level <= 1 )THEN
687: itg_debug_pub.Add('CBODO - ' || l_retcode || l_retmesg , 1);
688: END IF;
689:
690: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
691: x_retcode := FND_API.G_RET_STS_ERROR;

Line 701: itg_debug_pub.Add('SYNC_FIELD_004 IN- ' || l_retcode || l_retmesg, 1);

697: 'ITG','SYNC_FIELD_004','OAG','ITG','SYNC_FIELD_004','IN',
698: 'itg_sync_field_004_in',null,null,null,null,
699: null,null,null,'ITG03',null,0,p_tp_hdr_id,'I');
700: IF (l_Debug_Level <= 1 )THEN
701: itg_debug_pub.Add('SYNC_FIELD_004 IN- ' || l_retcode || l_retmesg, 1);
702: END IF;
703:
704: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
705: x_retcode := FND_API.G_RET_STS_ERROR;

Line 716: itg_debug_pub.Add('SYNC_UOMGROUP_003 IN- ' || l_retcode || l_retmesg, 1);

712: 'itg_sync_uomgroup_003_in',null,null,null,null,
713: null,null,null,'ITG03',null,2,p_tp_hdr_id,'I');
714:
715: IF (l_Debug_Level <= 1 )THEN
716: itg_debug_pub.Add('SYNC_UOMGROUP_003 IN- ' || l_retcode || l_retmesg, 1);
717: END IF;
718:
719: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
720: x_retcode := FND_API.G_RET_STS_ERROR;

Line 730: itg_debug_pub.Add('SYNC_SUPPLIER_005 IN- ' || l_retcode || l_retmesg ,1);

726: 'ITG','SYNC_SUPPLIER_005','OAG','ITG','SYNC_SUPPLIER_005','IN',
727: 'itg_sync_supplier_005_in',null,null,null,null,
728: null,null,null,'ITG03',null,2,p_tp_hdr_id,'I');
729: IF (l_Debug_Level <= 1 )THEN
730: itg_debug_pub.Add('SYNC_SUPPLIER_005 IN- ' || l_retcode || l_retmesg ,1);
731: END IF;
732:
733: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
734: x_retcode := FND_API.G_RET_STS_ERROR;

Line 744: itg_debug_pub.Add('SSYNC_EXCHNGRATE_003 IN- ' || l_retcode || l_retmesg, 1);

740: 'ITG','SYNC_EXCHNGRATE_003','OAG','ITG','SYNC_EXCHNGRATE_003','IN',
741: 'itg_sync_exchngrate_003_in',null,null,null,null,
742: null,null,null,'ITG03',null,2,p_tp_hdr_id,'I');
743: IF (l_Debug_Level <= 1 )THEN
744: itg_debug_pub.Add('SSYNC_EXCHNGRATE_003 IN- ' || l_retcode || l_retmesg, 1);
745: END IF;
746:
747: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
748: x_retcode := FND_API.G_RET_STS_ERROR;

Line 758: itg_debug_pub.Add('SYNC_ITEM_006 IN- ' || l_retcode || l_retmesg, 1);

754: 'ITG','SYNC_ITEM_006','OAG','ITG','SYNC_ITEM_006','IN',
755: 'itg_Sync_Item_006_in',null,null,null,null,
756: null,null,null,'ITG03',null,2,p_tp_hdr_id,'I');
757: IF (l_Debug_Level <= 1 )THEN
758: itg_debug_pub.Add('SYNC_ITEM_006 IN- ' || l_retcode || l_retmesg, 1);
759: END IF;
760:
761: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
762: x_retcode := FND_API.G_RET_STS_ERROR;

Line 772: itg_debug_pub.Add('SYNC_COA_003 IN- ' || l_retcode || l_retmesg ,1);

768: 'ITG','SYNC_COA_003','OAG','ITG','SYNC_COA_003','IN',
769: 'itg_sync_coa_003_in',null,null,null,null,
770: null,null,null,'ITG03',null,2,p_tp_hdr_id,'I');
771: IF (l_Debug_Level <= 1 )THEN
772: itg_debug_pub.Add('SYNC_COA_003 IN- ' || l_retcode || l_retmesg ,1);
773: END IF;
774:
775: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
776: x_retcode := FND_API.G_RET_STS_ERROR;

Line 787: itg_debug_pub.Add('SYNC_PO IN- ' || l_retcode || l_retmesg, 1);

783: 'ITG_sync_po_007_in',null,null,null,null,
784: null,null,null,'ITG03',null,2,p_tp_hdr_id,'I');
785:
786: IF (l_Debug_Level <= 1 )THEN
787: itg_debug_pub.Add('SYNC_PO IN- ' || l_retcode || l_retmesg, 1);
788: END IF;
789:
790: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
791: x_retcode := FND_API.G_RET_STS_ERROR;

Line 801: itg_debug_pub.Add('NBOD IN- ' || l_retcode || l_retmesg, 1);

797: 'CLN','NBOD','OAG','CLN','NBOD','IN',
798: 'CLN_NBODI_OAG72_IN_CONFIRM',null,null,null,null,
799: null,null,null,'ITG03',null,0,p_tp_hdr_id,'I');
800: IF (l_Debug_Level <= 1 )THEN
801: itg_debug_pub.Add('NBOD IN- ' || l_retcode || l_retmesg, 1);
802: END IF;
803:
804: IF l_retcode <> FND_API.G_RET_STS_SUCCESS THEN
805: x_retcode := FND_API.G_RET_STS_ERROR;

Line 815: itg_debug_pub.Add(' EXITING itg_setup.setup_tp_details normal', 2);

811: x_errbuf := 'Successful';
812:
813:
814: IF (l_Debug_Level <= 2 )THEN
815: itg_debug_pub.Add(' EXITING itg_setup.setup_tp_details normal', 2);
816: END IF;
817: EXCEPTION
818: WHEN OTHERS THEN
819: x_retcode := FND_API.G_RET_STS_ERROR;

Line 823: itg_debug_pub.Add(x_errbuf, 6);

819: x_retcode := FND_API.G_RET_STS_ERROR;
820: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
821:
822: IF (l_Debug_Level <= 6 )THEN
823: itg_debug_pub.Add(x_errbuf, 6);
824: itg_debug_pub.Add('EXITING itg_setup.setup_tp_details fails,returns on exception',6);
825: END IF;
826: END;
827:

Line 824: itg_debug_pub.Add('EXITING itg_setup.setup_tp_details fails,returns on exception',6);

820: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
821:
822: IF (l_Debug_Level <= 6 )THEN
823: itg_debug_pub.Add(x_errbuf, 6);
824: itg_debug_pub.Add('EXITING itg_setup.setup_tp_details fails,returns on exception',6);
825: END IF;
826: END;
827:
828: -- Name

Line 906: itg_debug_pub.Add('ENTERING add_or_update_tp_detail API' ,2);

902:
903: G_EXEC_PROC_NAME := 'add_or_update_tp_detail';
904:
905: IF (l_Debug_Level <= 2 )THEN
906: itg_debug_pub.Add('ENTERING add_or_update_tp_detail API' ,2);
907: END IF;
908:
909: IF (l_Debug_Level <= 1) THEN
910: itg_debug_pub.Add('------------------------------' ,1);

Line 910: itg_debug_pub.Add('------------------------------' ,1);

906: itg_debug_pub.Add('ENTERING add_or_update_tp_detail API' ,2);
907: END IF;
908:
909: IF (l_Debug_Level <= 1) THEN
910: itg_debug_pub.Add('------------------------------' ,1);
911: itg_debug_pub.Add('Procedure add_or_update_tp_detail with params' ,1 );
912: itg_debug_pub.Add('p_txn_type ' || p_txn_type ,1);
913: itg_debug_pub.Add('p_txn_subtype ' || p_txn_subtype ,1);
914: itg_debug_pub.Add('p_std_code ' || p_std_code ,1);

Line 911: itg_debug_pub.Add('Procedure add_or_update_tp_detail with params' ,1 );

907: END IF;
908:
909: IF (l_Debug_Level <= 1) THEN
910: itg_debug_pub.Add('------------------------------' ,1);
911: itg_debug_pub.Add('Procedure add_or_update_tp_detail with params' ,1 );
912: itg_debug_pub.Add('p_txn_type ' || p_txn_type ,1);
913: itg_debug_pub.Add('p_txn_subtype ' || p_txn_subtype ,1);
914: itg_debug_pub.Add('p_std_code ' || p_std_code ,1);
915: itg_debug_pub.Add('p_ext_type ' || p_ext_type ,1);

Line 912: itg_debug_pub.Add('p_txn_type ' || p_txn_type ,1);

908:
909: IF (l_Debug_Level <= 1) THEN
910: itg_debug_pub.Add('------------------------------' ,1);
911: itg_debug_pub.Add('Procedure add_or_update_tp_detail with params' ,1 );
912: itg_debug_pub.Add('p_txn_type ' || p_txn_type ,1);
913: itg_debug_pub.Add('p_txn_subtype ' || p_txn_subtype ,1);
914: itg_debug_pub.Add('p_std_code ' || p_std_code ,1);
915: itg_debug_pub.Add('p_ext_type ' || p_ext_type ,1);
916: itg_debug_pub.Add('p_ext_subtype ' || p_ext_subtype ,1);

Line 913: itg_debug_pub.Add('p_txn_subtype ' || p_txn_subtype ,1);

909: IF (l_Debug_Level <= 1) THEN
910: itg_debug_pub.Add('------------------------------' ,1);
911: itg_debug_pub.Add('Procedure add_or_update_tp_detail with params' ,1 );
912: itg_debug_pub.Add('p_txn_type ' || p_txn_type ,1);
913: itg_debug_pub.Add('p_txn_subtype ' || p_txn_subtype ,1);
914: itg_debug_pub.Add('p_std_code ' || p_std_code ,1);
915: itg_debug_pub.Add('p_ext_type ' || p_ext_type ,1);
916: itg_debug_pub.Add('p_ext_subtype ' || p_ext_subtype ,1);
917: itg_debug_pub.Add('p_direction ' || p_direction ,1);

Line 914: itg_debug_pub.Add('p_std_code ' || p_std_code ,1);

910: itg_debug_pub.Add('------------------------------' ,1);
911: itg_debug_pub.Add('Procedure add_or_update_tp_detail with params' ,1 );
912: itg_debug_pub.Add('p_txn_type ' || p_txn_type ,1);
913: itg_debug_pub.Add('p_txn_subtype ' || p_txn_subtype ,1);
914: itg_debug_pub.Add('p_std_code ' || p_std_code ,1);
915: itg_debug_pub.Add('p_ext_type ' || p_ext_type ,1);
916: itg_debug_pub.Add('p_ext_subtype ' || p_ext_subtype ,1);
917: itg_debug_pub.Add('p_direction ' || p_direction ,1);
918: itg_debug_pub.Add('p_map ' || p_map ,1);

Line 915: itg_debug_pub.Add('p_ext_type ' || p_ext_type ,1);

911: itg_debug_pub.Add('Procedure add_or_update_tp_detail with params' ,1 );
912: itg_debug_pub.Add('p_txn_type ' || p_txn_type ,1);
913: itg_debug_pub.Add('p_txn_subtype ' || p_txn_subtype ,1);
914: itg_debug_pub.Add('p_std_code ' || p_std_code ,1);
915: itg_debug_pub.Add('p_ext_type ' || p_ext_type ,1);
916: itg_debug_pub.Add('p_ext_subtype ' || p_ext_subtype ,1);
917: itg_debug_pub.Add('p_direction ' || p_direction ,1);
918: itg_debug_pub.Add('p_map ' || p_map ,1);
919: itg_debug_pub.Add('p_conn_type ' || p_conn_type ,1);

Line 916: itg_debug_pub.Add('p_ext_subtype ' || p_ext_subtype ,1);

912: itg_debug_pub.Add('p_txn_type ' || p_txn_type ,1);
913: itg_debug_pub.Add('p_txn_subtype ' || p_txn_subtype ,1);
914: itg_debug_pub.Add('p_std_code ' || p_std_code ,1);
915: itg_debug_pub.Add('p_ext_type ' || p_ext_type ,1);
916: itg_debug_pub.Add('p_ext_subtype ' || p_ext_subtype ,1);
917: itg_debug_pub.Add('p_direction ' || p_direction ,1);
918: itg_debug_pub.Add('p_map ' || p_map ,1);
919: itg_debug_pub.Add('p_conn_type ' || p_conn_type ,1);
920: itg_debug_pub.Add('p_hub_user_id ' || p_hub_user_id ,1);

Line 917: itg_debug_pub.Add('p_direction ' || p_direction ,1);

913: itg_debug_pub.Add('p_txn_subtype ' || p_txn_subtype ,1);
914: itg_debug_pub.Add('p_std_code ' || p_std_code ,1);
915: itg_debug_pub.Add('p_ext_type ' || p_ext_type ,1);
916: itg_debug_pub.Add('p_ext_subtype ' || p_ext_subtype ,1);
917: itg_debug_pub.Add('p_direction ' || p_direction ,1);
918: itg_debug_pub.Add('p_map ' || p_map ,1);
919: itg_debug_pub.Add('p_conn_type ' || p_conn_type ,1);
920: itg_debug_pub.Add('p_hub_user_id ' || p_hub_user_id ,1);
921: itg_debug_pub.Add('p_protocol ' || p_protocol ,1);

Line 918: itg_debug_pub.Add('p_map ' || p_map ,1);

914: itg_debug_pub.Add('p_std_code ' || p_std_code ,1);
915: itg_debug_pub.Add('p_ext_type ' || p_ext_type ,1);
916: itg_debug_pub.Add('p_ext_subtype ' || p_ext_subtype ,1);
917: itg_debug_pub.Add('p_direction ' || p_direction ,1);
918: itg_debug_pub.Add('p_map ' || p_map ,1);
919: itg_debug_pub.Add('p_conn_type ' || p_conn_type ,1);
920: itg_debug_pub.Add('p_hub_user_id ' || p_hub_user_id ,1);
921: itg_debug_pub.Add('p_protocol ' || p_protocol ,1);
922: itg_debug_pub.Add('p_protocol_addr' || p_protocol_addr,1);

Line 919: itg_debug_pub.Add('p_conn_type ' || p_conn_type ,1);

915: itg_debug_pub.Add('p_ext_type ' || p_ext_type ,1);
916: itg_debug_pub.Add('p_ext_subtype ' || p_ext_subtype ,1);
917: itg_debug_pub.Add('p_direction ' || p_direction ,1);
918: itg_debug_pub.Add('p_map ' || p_map ,1);
919: itg_debug_pub.Add('p_conn_type ' || p_conn_type ,1);
920: itg_debug_pub.Add('p_hub_user_id ' || p_hub_user_id ,1);
921: itg_debug_pub.Add('p_protocol ' || p_protocol ,1);
922: itg_debug_pub.Add('p_protocol_addr' || p_protocol_addr,1);
923: itg_debug_pub.Add('p_user ' || p_user ,1);

Line 920: itg_debug_pub.Add('p_hub_user_id ' || p_hub_user_id ,1);

916: itg_debug_pub.Add('p_ext_subtype ' || p_ext_subtype ,1);
917: itg_debug_pub.Add('p_direction ' || p_direction ,1);
918: itg_debug_pub.Add('p_map ' || p_map ,1);
919: itg_debug_pub.Add('p_conn_type ' || p_conn_type ,1);
920: itg_debug_pub.Add('p_hub_user_id ' || p_hub_user_id ,1);
921: itg_debug_pub.Add('p_protocol ' || p_protocol ,1);
922: itg_debug_pub.Add('p_protocol_addr' || p_protocol_addr,1);
923: itg_debug_pub.Add('p_user ' || p_user ,1);
924: itg_debug_pub.Add('p_passwd ' || p_passwd ,1);

Line 921: itg_debug_pub.Add('p_protocol ' || p_protocol ,1);

917: itg_debug_pub.Add('p_direction ' || p_direction ,1);
918: itg_debug_pub.Add('p_map ' || p_map ,1);
919: itg_debug_pub.Add('p_conn_type ' || p_conn_type ,1);
920: itg_debug_pub.Add('p_hub_user_id ' || p_hub_user_id ,1);
921: itg_debug_pub.Add('p_protocol ' || p_protocol ,1);
922: itg_debug_pub.Add('p_protocol_addr' || p_protocol_addr,1);
923: itg_debug_pub.Add('p_user ' || p_user ,1);
924: itg_debug_pub.Add('p_passwd ' || p_passwd ,1);
925: itg_debug_pub.Add('p_routing_id ' || p_routing_id ,1);

Line 922: itg_debug_pub.Add('p_protocol_addr' || p_protocol_addr,1);

918: itg_debug_pub.Add('p_map ' || p_map ,1);
919: itg_debug_pub.Add('p_conn_type ' || p_conn_type ,1);
920: itg_debug_pub.Add('p_hub_user_id ' || p_hub_user_id ,1);
921: itg_debug_pub.Add('p_protocol ' || p_protocol ,1);
922: itg_debug_pub.Add('p_protocol_addr' || p_protocol_addr,1);
923: itg_debug_pub.Add('p_user ' || p_user ,1);
924: itg_debug_pub.Add('p_passwd ' || p_passwd ,1);
925: itg_debug_pub.Add('p_routing_id ' || p_routing_id ,1);
926: itg_debug_pub.Add('p_src_loc ' || p_src_loc ,1);

Line 923: itg_debug_pub.Add('p_user ' || p_user ,1);

919: itg_debug_pub.Add('p_conn_type ' || p_conn_type ,1);
920: itg_debug_pub.Add('p_hub_user_id ' || p_hub_user_id ,1);
921: itg_debug_pub.Add('p_protocol ' || p_protocol ,1);
922: itg_debug_pub.Add('p_protocol_addr' || p_protocol_addr,1);
923: itg_debug_pub.Add('p_user ' || p_user ,1);
924: itg_debug_pub.Add('p_passwd ' || p_passwd ,1);
925: itg_debug_pub.Add('p_routing_id ' || p_routing_id ,1);
926: itg_debug_pub.Add('p_src_loc ' || p_src_loc ,1);
927: itg_debug_pub.Add('p_ext_loc ' || p_ext_loc ,1);

Line 924: itg_debug_pub.Add('p_passwd ' || p_passwd ,1);

920: itg_debug_pub.Add('p_hub_user_id ' || p_hub_user_id ,1);
921: itg_debug_pub.Add('p_protocol ' || p_protocol ,1);
922: itg_debug_pub.Add('p_protocol_addr' || p_protocol_addr,1);
923: itg_debug_pub.Add('p_user ' || p_user ,1);
924: itg_debug_pub.Add('p_passwd ' || p_passwd ,1);
925: itg_debug_pub.Add('p_routing_id ' || p_routing_id ,1);
926: itg_debug_pub.Add('p_src_loc ' || p_src_loc ,1);
927: itg_debug_pub.Add('p_ext_loc ' || p_ext_loc ,1);
928: itg_debug_pub.Add('p_doc_conf ' || p_doc_conf ,1);

Line 925: itg_debug_pub.Add('p_routing_id ' || p_routing_id ,1);

921: itg_debug_pub.Add('p_protocol ' || p_protocol ,1);
922: itg_debug_pub.Add('p_protocol_addr' || p_protocol_addr,1);
923: itg_debug_pub.Add('p_user ' || p_user ,1);
924: itg_debug_pub.Add('p_passwd ' || p_passwd ,1);
925: itg_debug_pub.Add('p_routing_id ' || p_routing_id ,1);
926: itg_debug_pub.Add('p_src_loc ' || p_src_loc ,1);
927: itg_debug_pub.Add('p_ext_loc ' || p_ext_loc ,1);
928: itg_debug_pub.Add('p_doc_conf ' || p_doc_conf ,1);
929: itg_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id ,1);

Line 926: itg_debug_pub.Add('p_src_loc ' || p_src_loc ,1);

922: itg_debug_pub.Add('p_protocol_addr' || p_protocol_addr,1);
923: itg_debug_pub.Add('p_user ' || p_user ,1);
924: itg_debug_pub.Add('p_passwd ' || p_passwd ,1);
925: itg_debug_pub.Add('p_routing_id ' || p_routing_id ,1);
926: itg_debug_pub.Add('p_src_loc ' || p_src_loc ,1);
927: itg_debug_pub.Add('p_ext_loc ' || p_ext_loc ,1);
928: itg_debug_pub.Add('p_doc_conf ' || p_doc_conf ,1);
929: itg_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id ,1);
930: itg_debug_pub.Add('p_tparty_type ' || p_party_type ,1);

Line 927: itg_debug_pub.Add('p_ext_loc ' || p_ext_loc ,1);

923: itg_debug_pub.Add('p_user ' || p_user ,1);
924: itg_debug_pub.Add('p_passwd ' || p_passwd ,1);
925: itg_debug_pub.Add('p_routing_id ' || p_routing_id ,1);
926: itg_debug_pub.Add('p_src_loc ' || p_src_loc ,1);
927: itg_debug_pub.Add('p_ext_loc ' || p_ext_loc ,1);
928: itg_debug_pub.Add('p_doc_conf ' || p_doc_conf ,1);
929: itg_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id ,1);
930: itg_debug_pub.Add('p_tparty_type ' || p_party_type ,1);
931: itg_debug_pub.Add('------------------------------' ,1);

Line 928: itg_debug_pub.Add('p_doc_conf ' || p_doc_conf ,1);

924: itg_debug_pub.Add('p_passwd ' || p_passwd ,1);
925: itg_debug_pub.Add('p_routing_id ' || p_routing_id ,1);
926: itg_debug_pub.Add('p_src_loc ' || p_src_loc ,1);
927: itg_debug_pub.Add('p_ext_loc ' || p_ext_loc ,1);
928: itg_debug_pub.Add('p_doc_conf ' || p_doc_conf ,1);
929: itg_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id ,1);
930: itg_debug_pub.Add('p_tparty_type ' || p_party_type ,1);
931: itg_debug_pub.Add('------------------------------' ,1);
932: END IF;

Line 929: itg_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id ,1);

925: itg_debug_pub.Add('p_routing_id ' || p_routing_id ,1);
926: itg_debug_pub.Add('p_src_loc ' || p_src_loc ,1);
927: itg_debug_pub.Add('p_ext_loc ' || p_ext_loc ,1);
928: itg_debug_pub.Add('p_doc_conf ' || p_doc_conf ,1);
929: itg_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id ,1);
930: itg_debug_pub.Add('p_tparty_type ' || p_party_type ,1);
931: itg_debug_pub.Add('------------------------------' ,1);
932: END IF;
933:

Line 930: itg_debug_pub.Add('p_tparty_type ' || p_party_type ,1);

926: itg_debug_pub.Add('p_src_loc ' || p_src_loc ,1);
927: itg_debug_pub.Add('p_ext_loc ' || p_ext_loc ,1);
928: itg_debug_pub.Add('p_doc_conf ' || p_doc_conf ,1);
929: itg_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id ,1);
930: itg_debug_pub.Add('p_tparty_type ' || p_party_type ,1);
931: itg_debug_pub.Add('------------------------------' ,1);
932: END IF;
933:
934: -- query ecx_tp_detail_id to get ecx_tp_detail_id for given location code

Line 931: itg_debug_pub.Add('------------------------------' ,1);

927: itg_debug_pub.Add('p_ext_loc ' || p_ext_loc ,1);
928: itg_debug_pub.Add('p_doc_conf ' || p_doc_conf ,1);
929: itg_debug_pub.Add('p_tp_hdr_id ' || p_tp_hdr_id ,1);
930: itg_debug_pub.Add('p_tparty_type ' || p_party_type ,1);
931: itg_debug_pub.Add('------------------------------' ,1);
932: END IF;
933:
934: -- query ecx_tp_detail_id to get ecx_tp_detail_id for given location code
935: -- if record does not exists create a new detail record

Line 944: itg_debug_pub.Add('---------------------------------', 1);

940: FETCH get_tp_detail_id INTO l_tp_dtl_id;
941: l_record_found := get_tp_detail_id%FOUND;
942:
943: IF (l_Debug_Level <= 1) THEN
944: itg_debug_pub.Add('---------------------------------', 1);
945: itg_debug_pub.Add('Cursor get_tp_detail_id ', 1);
946: END IF;
947:
948: IF l_record_found THEN

Line 945: itg_debug_pub.Add('Cursor get_tp_detail_id ', 1);

941: l_record_found := get_tp_detail_id%FOUND;
942:
943: IF (l_Debug_Level <= 1) THEN
944: itg_debug_pub.Add('---------------------------------', 1);
945: itg_debug_pub.Add('Cursor get_tp_detail_id ', 1);
946: END IF;
947:
948: IF l_record_found THEN
949: IF (l_Debug_Level <= 1) THEN

Line 950: itg_debug_pub.Add('l_record_found - true ', 1);

946: END IF;
947:
948: IF l_record_found THEN
949: IF (l_Debug_Level <= 1) THEN
950: itg_debug_pub.Add('l_record_found - true ', 1);
951: END IF;
952: ELSE
953: IF (l_Debug_Level <= 1) THEN
954: itg_debug_pub.Add('l_record_found - false', 1);

Line 954: itg_debug_pub.Add('l_record_found - false', 1);

950: itg_debug_pub.Add('l_record_found - true ', 1);
951: END IF;
952: ELSE
953: IF (l_Debug_Level <= 1) THEN
954: itg_debug_pub.Add('l_record_found - false', 1);
955: END IF;
956: END IF;
957:
958: IF (l_Debug_Level <= 1) THEN

Line 959: itg_debug_pub.Add('l_tp_dtl_id ' || l_tp_dtl_id ,1);

955: END IF;
956: END IF;
957:
958: IF (l_Debug_Level <= 1) THEN
959: itg_debug_pub.Add('l_tp_dtl_id ' || l_tp_dtl_id ,1);
960: itg_debug_pub.Add('---------------------------------',1);
961: END IF;
962:
963: CLOSE get_tp_detail_id;

Line 960: itg_debug_pub.Add('---------------------------------',1);

956: END IF;
957:
958: IF (l_Debug_Level <= 1) THEN
959: itg_debug_pub.Add('l_tp_dtl_id ' || l_tp_dtl_id ,1);
960: itg_debug_pub.Add('---------------------------------',1);
961: END IF;
962:
963: CLOSE get_tp_detail_id;
964:

Line 983: itg_debug_pub.Add('ext_process_id - ' || l_ext_process_id ,1);

979: AND txn.transaction_type = p_txn_type
980: AND txn.transaction_subtype = p_txn_subtype;
981:
982: IF (l_Debug_Level <= 1) THEN
983: itg_debug_pub.Add('ext_process_id - ' || l_ext_process_id ,1);
984: END IF;
985: EXCEPTION
986: WHEN OTHERS THEN
987: IF (l_Debug_Level <= 6) THEN

Line 988: itg_debug_pub.Add('Cannot retrieve ext_process_id', 6);

984: END IF;
985: EXCEPTION
986: WHEN OTHERS THEN
987: IF (l_Debug_Level <= 6) THEN
988: itg_debug_pub.Add('Cannot retrieve ext_process_id', 6);
989: itg_debug_pub.Add('Exception - ' || SQLCODE || ' - ' || SQLERRM, 6);
990: END IF;
991:
992: x_retcode := FND_API.G_RET_STS_ERROR;

Line 989: itg_debug_pub.Add('Exception - ' || SQLCODE || ' - ' || SQLERRM, 6);

985: EXCEPTION
986: WHEN OTHERS THEN
987: IF (l_Debug_Level <= 6) THEN
988: itg_debug_pub.Add('Cannot retrieve ext_process_id', 6);
989: itg_debug_pub.Add('Exception - ' || SQLCODE || ' - ' || SQLERRM, 6);
990: END IF;
991:
992: x_retcode := FND_API.G_RET_STS_ERROR;
993: set_errmesg(x_errbuf,SQLCODE,SQLERRM);

Line 1023: itg_debug_pub.Add('ext_process_id - ' || l_ext_process_id);

1019: RETURN;
1020: END IF;
1021:
1022: IF (l_Debug_Level <= 1) THEN
1023: itg_debug_pub.Add('ext_process_id - ' || l_ext_process_id);
1024: END IF;
1025: EXCEPTION
1026: WHEN OTHERS THEN
1027: IF (l_Debug_Level <= 6) THEN

Line 1028: itg_debug_pub.Add('Unexpected error', 6);

1024: END IF;
1025: EXCEPTION
1026: WHEN OTHERS THEN
1027: IF (l_Debug_Level <= 6) THEN
1028: itg_debug_pub.Add('Unexpected error', 6);
1029: itg_debug_pub.Add('Exception - ' || SQLCODE || ' - ' || SQLERRM, 6);
1030: END IF;
1031:
1032: x_retcode := FND_API.G_RET_STS_ERROR;

Line 1029: itg_debug_pub.Add('Exception - ' || SQLCODE || ' - ' || SQLERRM, 6);

1025: EXCEPTION
1026: WHEN OTHERS THEN
1027: IF (l_Debug_Level <= 6) THEN
1028: itg_debug_pub.Add('Unexpected error', 6);
1029: itg_debug_pub.Add('Exception - ' || SQLCODE || ' - ' || SQLERRM, 6);
1030: END IF;
1031:
1032: x_retcode := FND_API.G_RET_STS_ERROR;
1033: set_errmesg(x_errbuf,SQLCODE,SQLERRM);

Line 1058: itg_debug_pub.Add('----------------------------' ,1);

1054: p_confirmation => p_doc_conf
1055: );
1056:
1057: IF (l_Debug_Level <= 1) THEN
1058: itg_debug_pub.Add('----------------------------' ,1);
1059: itg_debug_pub.Add('ecx_tp_api.create_tp_detail returns normal',1);
1060: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1061: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1062: itg_debug_pub.Add('l_tp_dtl_id ' || l_tp_dtl_id ,1);

Line 1059: itg_debug_pub.Add('ecx_tp_api.create_tp_detail returns normal',1);

1055: );
1056:
1057: IF (l_Debug_Level <= 1) THEN
1058: itg_debug_pub.Add('----------------------------' ,1);
1059: itg_debug_pub.Add('ecx_tp_api.create_tp_detail returns normal',1);
1060: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1061: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1062: itg_debug_pub.Add('l_tp_dtl_id ' || l_tp_dtl_id ,1);
1063: itg_debug_pub.Add('----------------------------',1);

Line 1060: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);

1056:
1057: IF (l_Debug_Level <= 1) THEN
1058: itg_debug_pub.Add('----------------------------' ,1);
1059: itg_debug_pub.Add('ecx_tp_api.create_tp_detail returns normal',1);
1060: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1061: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1062: itg_debug_pub.Add('l_tp_dtl_id ' || l_tp_dtl_id ,1);
1063: itg_debug_pub.Add('----------------------------',1);
1064: END IF;

Line 1061: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);

1057: IF (l_Debug_Level <= 1) THEN
1058: itg_debug_pub.Add('----------------------------' ,1);
1059: itg_debug_pub.Add('ecx_tp_api.create_tp_detail returns normal',1);
1060: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1061: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1062: itg_debug_pub.Add('l_tp_dtl_id ' || l_tp_dtl_id ,1);
1063: itg_debug_pub.Add('----------------------------',1);
1064: END IF;
1065: ELSE

Line 1062: itg_debug_pub.Add('l_tp_dtl_id ' || l_tp_dtl_id ,1);

1058: itg_debug_pub.Add('----------------------------' ,1);
1059: itg_debug_pub.Add('ecx_tp_api.create_tp_detail returns normal',1);
1060: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1061: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1062: itg_debug_pub.Add('l_tp_dtl_id ' || l_tp_dtl_id ,1);
1063: itg_debug_pub.Add('----------------------------',1);
1064: END IF;
1065: ELSE
1066: ecx_tp_api.update_tp_detail(

Line 1063: itg_debug_pub.Add('----------------------------',1);

1059: itg_debug_pub.Add('ecx_tp_api.create_tp_detail returns normal',1);
1060: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1061: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1062: itg_debug_pub.Add('l_tp_dtl_id ' || l_tp_dtl_id ,1);
1063: itg_debug_pub.Add('----------------------------',1);
1064: END IF;
1065: ELSE
1066: ecx_tp_api.update_tp_detail(
1067: x_return_status => l_retcode,

Line 1087: itg_debug_pub.Add('----------------------------' ,1);

1083: );
1084:
1085:
1086: IF (l_Debug_Level <= 1) THEN
1087: itg_debug_pub.Add('----------------------------' ,1);
1088: itg_debug_pub.Add('ecx_tp_api.update_tp_detail returns normal',1);
1089: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1090: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1091: itg_debug_pub.Add('----------------------------',1);

Line 1088: itg_debug_pub.Add('ecx_tp_api.update_tp_detail returns normal',1);

1084:
1085:
1086: IF (l_Debug_Level <= 1) THEN
1087: itg_debug_pub.Add('----------------------------' ,1);
1088: itg_debug_pub.Add('ecx_tp_api.update_tp_detail returns normal',1);
1089: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1090: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1091: itg_debug_pub.Add('----------------------------',1);
1092: END IF;

Line 1089: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);

1085:
1086: IF (l_Debug_Level <= 1) THEN
1087: itg_debug_pub.Add('----------------------------' ,1);
1088: itg_debug_pub.Add('ecx_tp_api.update_tp_detail returns normal',1);
1089: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1090: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1091: itg_debug_pub.Add('----------------------------',1);
1092: END IF;
1093: END IF;

Line 1090: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);

1086: IF (l_Debug_Level <= 1) THEN
1087: itg_debug_pub.Add('----------------------------' ,1);
1088: itg_debug_pub.Add('ecx_tp_api.update_tp_detail returns normal',1);
1089: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1090: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1091: itg_debug_pub.Add('----------------------------',1);
1092: END IF;
1093: END IF;
1094:

Line 1091: itg_debug_pub.Add('----------------------------',1);

1087: itg_debug_pub.Add('----------------------------' ,1);
1088: itg_debug_pub.Add('ecx_tp_api.update_tp_detail returns normal',1);
1089: itg_debug_pub.Add('l_retcode ' || l_retcode ,1);
1090: itg_debug_pub.Add('l_retmesg ' || l_retmesg ,1);
1091: itg_debug_pub.Add('----------------------------',1);
1092: END IF;
1093: END IF;
1094:
1095: IF l_retcode = 0 THEN

Line 1104: itg_debug_pub.Add('EXITING itg_setup.add_or_update_tp_detail returns normal', 2);

1100: x_errbuf := l_retmesg;
1101: END IF;
1102:
1103: IF (l_Debug_Level <= 2) THEN
1104: itg_debug_pub.Add('EXITING itg_setup.add_or_update_tp_detail returns normal', 2);
1105: END IF;
1106: -- Exception Handling
1107: EXCEPTION
1108: WHEN OTHERS THEN

Line 1113: itg_debug_pub.Add(x_errbuf, 6);

1109: x_retcode := FND_API.G_RET_STS_ERROR;
1110: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
1111:
1112: IF (l_Debug_Level <= 6) THEN
1113: itg_debug_pub.Add(x_errbuf, 6);
1114: itg_debug_pub.Add('EXITING itg_setup.add_or_update_tp_detail fails,returns on exception',6);
1115: END IF;
1116: END;
1117:

Line 1114: itg_debug_pub.Add('EXITING itg_setup.add_or_update_tp_detail fails,returns on exception',6);

1110: set_errmesg(x_errbuf,SQLCODE,SQLERRM);
1111:
1112: IF (l_Debug_Level <= 6) THEN
1113: itg_debug_pub.Add(x_errbuf, 6);
1114: itg_debug_pub.Add('EXITING itg_setup.add_or_update_tp_detail fails,returns on exception',6);
1115: END IF;
1116: END;
1117:
1118:

Line 1137: itg_debug_pub.Add('ENTERING set_errmesg', 2);

1133: IS
1134: l_errmesg VARCHAR2(250);
1135: BEGIN
1136: IF (l_Debug_Level <= 2) THEN
1137: itg_debug_pub.Add('ENTERING set_errmesg', 2);
1138: END IF;
1139:
1140: l_errmesg := SUBSTR(p_errmesg,1,200);
1141:

Line 1153: itg_debug_pub.Add('EXITING set_errmesg - ' || x_errbuf, 2);

1149: FND_MESSAGE.SET_TOKEN('PROCEDURE_NAME',G_EXEC_PROC_NAME);
1150: x_errbuf := FND_MESSAGE.GET;
1151:
1152: IF (l_Debug_Level <= 2) THEN
1153: itg_debug_pub.Add('EXITING set_errmesg - ' || x_errbuf, 2);
1154: END IF;
1155:
1156: EXCEPTION
1157: WHEN OTHERS THEN

Line 1159: itg_debug_pub.Add('EXITING set_errmesg - ' || SQLCODE || ' - ' || SQLERRM,6);

1155:
1156: EXCEPTION
1157: WHEN OTHERS THEN
1158: IF (l_Debug_Level <= 6) THEN
1159: itg_debug_pub.Add('EXITING set_errmesg - ' || SQLCODE || ' - ' || SQLERRM,6);
1160: END IF;
1161: x_errbuf := p_errcode || ' - ' || p_errmesg;
1162: END;
1163: