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_SYNCITEMINBOUND_PVT dependencies on ITG_DEBUG

Line 70: itg_debug_pub.Add('--- Entering Sync_Item ---' ,2);

66: x_return_status := FND_API.G_RET_STS_SUCCESS;
67: g_action := 'Item synchronization';
68:
69: IF (l_Debug_Level <= 2) THEN
70: itg_debug_pub.Add('--- Entering Sync_Item ---' ,2);
71: END IF;
72:
73: BEGIN
74: ITG_Debug.setup(

Line 74: ITG_Debug.setup(

70: itg_debug_pub.Add('--- Entering Sync_Item ---' ,2);
71: END IF;
72:
73: BEGIN
74: ITG_Debug.setup(
75: p_reset => TRUE,
76: p_pkg_name => G_PKG_NAME,
77: p_proc_name => l_api_name
78: );

Line 83: itg_debug_pub.Add('SI - Top of procedure.' ,1);

79:
80:
81: -- in wrapper now > FND_MSG_PUB.Initialize;
82: IF (l_Debug_Level <= 1) THEN
83: itg_debug_pub.Add('SI - Top of procedure.' ,1);
84: itg_debug_pub.Add('SI - p_syncind' ||p_syncind,1);
85: itg_debug_pub.Add('SI - p_org_id' ||p_org_id,1);
86: itg_debug_pub.Add('SI - p_hazrdmatl'||p_hazrdmatl,1);
87: itg_debug_pub.Add('SI - p_create_date'||p_create_date,1);

Line 84: itg_debug_pub.Add('SI - p_syncind' ||p_syncind,1);

80:
81: -- in wrapper now > FND_MSG_PUB.Initialize;
82: IF (l_Debug_Level <= 1) THEN
83: itg_debug_pub.Add('SI - Top of procedure.' ,1);
84: itg_debug_pub.Add('SI - p_syncind' ||p_syncind,1);
85: itg_debug_pub.Add('SI - p_org_id' ||p_org_id,1);
86: itg_debug_pub.Add('SI - p_hazrdmatl'||p_hazrdmatl,1);
87: itg_debug_pub.Add('SI - p_create_date'||p_create_date,1);
88: itg_debug_pub.Add('SI - p_item' ||p_item,1);

Line 85: itg_debug_pub.Add('SI - p_org_id' ||p_org_id,1);

81: -- in wrapper now > FND_MSG_PUB.Initialize;
82: IF (l_Debug_Level <= 1) THEN
83: itg_debug_pub.Add('SI - Top of procedure.' ,1);
84: itg_debug_pub.Add('SI - p_syncind' ||p_syncind,1);
85: itg_debug_pub.Add('SI - p_org_id' ||p_org_id,1);
86: itg_debug_pub.Add('SI - p_hazrdmatl'||p_hazrdmatl,1);
87: itg_debug_pub.Add('SI - p_create_date'||p_create_date,1);
88: itg_debug_pub.Add('SI - p_item' ||p_item,1);
89: itg_debug_pub.Add('SI - p_uom' ||p_uom,1);

Line 86: itg_debug_pub.Add('SI - p_hazrdmatl'||p_hazrdmatl,1);

82: IF (l_Debug_Level <= 1) THEN
83: itg_debug_pub.Add('SI - Top of procedure.' ,1);
84: itg_debug_pub.Add('SI - p_syncind' ||p_syncind,1);
85: itg_debug_pub.Add('SI - p_org_id' ||p_org_id,1);
86: itg_debug_pub.Add('SI - p_hazrdmatl'||p_hazrdmatl,1);
87: itg_debug_pub.Add('SI - p_create_date'||p_create_date,1);
88: itg_debug_pub.Add('SI - p_item' ||p_item,1);
89: itg_debug_pub.Add('SI - p_uom' ||p_uom,1);
90: itg_debug_pub.Add('SI - p_itemdesc' ||p_itemdesc,1);

Line 87: itg_debug_pub.Add('SI - p_create_date'||p_create_date,1);

83: itg_debug_pub.Add('SI - Top of procedure.' ,1);
84: itg_debug_pub.Add('SI - p_syncind' ||p_syncind,1);
85: itg_debug_pub.Add('SI - p_org_id' ||p_org_id,1);
86: itg_debug_pub.Add('SI - p_hazrdmatl'||p_hazrdmatl,1);
87: itg_debug_pub.Add('SI - p_create_date'||p_create_date,1);
88: itg_debug_pub.Add('SI - p_item' ||p_item,1);
89: itg_debug_pub.Add('SI - p_uom' ||p_uom,1);
90: itg_debug_pub.Add('SI - p_itemdesc' ||p_itemdesc,1);
91: itg_debug_pub.Add('SI - p_itemstatus'||p_itemstatus,1);

Line 88: itg_debug_pub.Add('SI - p_item' ||p_item,1);

84: itg_debug_pub.Add('SI - p_syncind' ||p_syncind,1);
85: itg_debug_pub.Add('SI - p_org_id' ||p_org_id,1);
86: itg_debug_pub.Add('SI - p_hazrdmatl'||p_hazrdmatl,1);
87: itg_debug_pub.Add('SI - p_create_date'||p_create_date,1);
88: itg_debug_pub.Add('SI - p_item' ||p_item,1);
89: itg_debug_pub.Add('SI - p_uom' ||p_uom,1);
90: itg_debug_pub.Add('SI - p_itemdesc' ||p_itemdesc,1);
91: itg_debug_pub.Add('SI - p_itemstatus'||p_itemstatus,1);
92: itg_debug_pub.Add('SI - p_itemtype' ||p_itemtype,1);

Line 89: itg_debug_pub.Add('SI - p_uom' ||p_uom,1);

85: itg_debug_pub.Add('SI - p_org_id' ||p_org_id,1);
86: itg_debug_pub.Add('SI - p_hazrdmatl'||p_hazrdmatl,1);
87: itg_debug_pub.Add('SI - p_create_date'||p_create_date,1);
88: itg_debug_pub.Add('SI - p_item' ||p_item,1);
89: itg_debug_pub.Add('SI - p_uom' ||p_uom,1);
90: itg_debug_pub.Add('SI - p_itemdesc' ||p_itemdesc,1);
91: itg_debug_pub.Add('SI - p_itemstatus'||p_itemstatus,1);
92: itg_debug_pub.Add('SI - p_itemtype' ||p_itemtype,1);
93: itg_debug_pub.Add('SI - p_rctrout' ||p_rctrout,1);

Line 90: itg_debug_pub.Add('SI - p_itemdesc' ||p_itemdesc,1);

86: itg_debug_pub.Add('SI - p_hazrdmatl'||p_hazrdmatl,1);
87: itg_debug_pub.Add('SI - p_create_date'||p_create_date,1);
88: itg_debug_pub.Add('SI - p_item' ||p_item,1);
89: itg_debug_pub.Add('SI - p_uom' ||p_uom,1);
90: itg_debug_pub.Add('SI - p_itemdesc' ||p_itemdesc,1);
91: itg_debug_pub.Add('SI - p_itemstatus'||p_itemstatus,1);
92: itg_debug_pub.Add('SI - p_itemtype' ||p_itemtype,1);
93: itg_debug_pub.Add('SI - p_rctrout' ||p_rctrout,1);
94: itg_debug_pub.Add('SI - p_commodity1'||p_commodity1,1);

Line 91: itg_debug_pub.Add('SI - p_itemstatus'||p_itemstatus,1);

87: itg_debug_pub.Add('SI - p_create_date'||p_create_date,1);
88: itg_debug_pub.Add('SI - p_item' ||p_item,1);
89: itg_debug_pub.Add('SI - p_uom' ||p_uom,1);
90: itg_debug_pub.Add('SI - p_itemdesc' ||p_itemdesc,1);
91: itg_debug_pub.Add('SI - p_itemstatus'||p_itemstatus,1);
92: itg_debug_pub.Add('SI - p_itemtype' ||p_itemtype,1);
93: itg_debug_pub.Add('SI - p_rctrout' ||p_rctrout,1);
94: itg_debug_pub.Add('SI - p_commodity1'||p_commodity1,1);
95: itg_debug_pub.Add('SI - p_commodity2'||p_commodity2,1);

Line 92: itg_debug_pub.Add('SI - p_itemtype' ||p_itemtype,1);

88: itg_debug_pub.Add('SI - p_item' ||p_item,1);
89: itg_debug_pub.Add('SI - p_uom' ||p_uom,1);
90: itg_debug_pub.Add('SI - p_itemdesc' ||p_itemdesc,1);
91: itg_debug_pub.Add('SI - p_itemstatus'||p_itemstatus,1);
92: itg_debug_pub.Add('SI - p_itemtype' ||p_itemtype,1);
93: itg_debug_pub.Add('SI - p_rctrout' ||p_rctrout,1);
94: itg_debug_pub.Add('SI - p_commodity1'||p_commodity1,1);
95: itg_debug_pub.Add('SI - p_commodity2'||p_commodity2,1);
96: END IF;

Line 93: itg_debug_pub.Add('SI - p_rctrout' ||p_rctrout,1);

89: itg_debug_pub.Add('SI - p_uom' ||p_uom,1);
90: itg_debug_pub.Add('SI - p_itemdesc' ||p_itemdesc,1);
91: itg_debug_pub.Add('SI - p_itemstatus'||p_itemstatus,1);
92: itg_debug_pub.Add('SI - p_itemtype' ||p_itemtype,1);
93: itg_debug_pub.Add('SI - p_rctrout' ||p_rctrout,1);
94: itg_debug_pub.Add('SI - p_commodity1'||p_commodity1,1);
95: itg_debug_pub.Add('SI - p_commodity2'||p_commodity2,1);
96: END IF;
97:

Line 94: itg_debug_pub.Add('SI - p_commodity1'||p_commodity1,1);

90: itg_debug_pub.Add('SI - p_itemdesc' ||p_itemdesc,1);
91: itg_debug_pub.Add('SI - p_itemstatus'||p_itemstatus,1);
92: itg_debug_pub.Add('SI - p_itemtype' ||p_itemtype,1);
93: itg_debug_pub.Add('SI - p_rctrout' ||p_rctrout,1);
94: itg_debug_pub.Add('SI - p_commodity1'||p_commodity1,1);
95: itg_debug_pub.Add('SI - p_commodity2'||p_commodity2,1);
96: END IF;
97:
98:

Line 95: itg_debug_pub.Add('SI - p_commodity2'||p_commodity2,1);

91: itg_debug_pub.Add('SI - p_itemstatus'||p_itemstatus,1);
92: itg_debug_pub.Add('SI - p_itemtype' ||p_itemtype,1);
93: itg_debug_pub.Add('SI - p_rctrout' ||p_rctrout,1);
94: itg_debug_pub.Add('SI - p_commodity1'||p_commodity1,1);
95: itg_debug_pub.Add('SI - p_commodity2'||p_commodity2,1);
96: END IF;
97:
98:
99: l_syncind := UPPER(p_syncind);

Line 135: itg_debug_pub.Add('SI - Completed validations' ,1);

131: END IF;
132: END;
133:
134: IF (l_Debug_Level <= 1) THEN
135: itg_debug_pub.Add('SI - Completed validations' ,1);
136: END IF;
137:
138: /* TBD: bug comment from original */
139:

Line 162: itg_debug_pub.Add('SI - Loading hazard class ID',1 );

158: END LOOP;
159:
160: IF p_hazrdmatl IS NOT NULL THEN
161: IF (l_Debug_Level <= 1) THEN
162: itg_debug_pub.Add('SI - Loading hazard class ID',1 );
163: END IF;
164:
165: BEGIN
166: SELECT hazard_class_id

Line 173: itg_debug_pub.Add('SI - No hazard class ID found',1);

169: WHERE upper(hazard_class) = upper(p_hazrdmatl);
170: EXCEPTION
171: WHEN NO_DATA_FOUND THEN
172: IF (l_Debug_Level <= 1) THEN
173: itg_debug_pub.Add('SI - No hazard class ID found',1);
174: END IF;
175:
176: itg_msg.no_hazard_class(p_hazrdmatl);
177: RAISE FND_API.G_EXC_ERROR;

Line 190: itg_debug_pub.Add('SI - Calling Get_ProcessSetId', 1);

186:
187: l_create_date := NVL(p_create_date, SYSDATE);
188:
189: IF (l_Debug_Level <= 1) THEN
190: itg_debug_pub.Add('SI - Calling Get_ProcessSetId', 1);
191: END IF;
192:
193: -- commented call to ITG_BatchManagement_PVT.Get_ProcessSetId
194: l_set_process_id := Get_NextProcessSetId;

Line 196: itg_debug_pub.Add('l_set_process_id' ||l_set_process_id, 1);

192:
193: -- commented call to ITG_BatchManagement_PVT.Get_ProcessSetId
194: l_set_process_id := Get_NextProcessSetId;
195: IF (l_Debug_Level <= 1) THEN
196: itg_debug_pub.Add('l_set_process_id' ||l_set_process_id, 1);
197: itg_debug_pub.Add( 'Inserting into mtl_system_items_interface',1);
198: END IF;
199:
200: g_action := 'Item-interface insert';

Line 197: itg_debug_pub.Add( 'Inserting into mtl_system_items_interface',1);

193: -- commented call to ITG_BatchManagement_PVT.Get_ProcessSetId
194: l_set_process_id := Get_NextProcessSetId;
195: IF (l_Debug_Level <= 1) THEN
196: itg_debug_pub.Add('l_set_process_id' ||l_set_process_id, 1);
197: itg_debug_pub.Add( 'Inserting into mtl_system_items_interface',1);
198: END IF;
199:
200: g_action := 'Item-interface insert';
201:

Line 280: itg_debug_pub.Add('SI - Inserting into mtl_items_categories_interface', 1);

276: IF p_commodity1 IS NOT NULL AND
277: p_commodity2 IS NOT NULL THEN
278:
279: IF (l_Debug_Level <= 1) THEN
280: itg_debug_pub.Add('SI - Inserting into mtl_items_categories_interface', 1);
281: END IF;
282:
283: INSERT INTO mtl_item_categories_interface(
284: set_process_id,

Line 309: itg_debug_pub.Add('Committing item interfaces insert.', 1);

305: )RETURNING rowid INTO l_ici_rowid;
306: END IF;
307:
308: IF (l_Debug_Level <= 1) THEN
309: itg_debug_pub.Add('Committing item interfaces insert.', 1);
310: END IF;
311: COMMIT;
312:
313: -- comment call to ITG_BatchManagement_PVT.Added_RequestItem

Line 328: itg_debug_pub.Add( 'Waiting for concurrent request.', 1);

324: END IF;
325:
326: -- This was pulled from the original sync item code
327: IF (l_Debug_Level <= 1) THEN
328: itg_debug_pub.Add( 'Waiting for concurrent request.', 1);
329: itg_debug_pub.Add( 'l_ccm_request_id'||l_ccm_request_id,1);
330: END IF;
331:
332: l_bool := FND_CONCURRENT.wait_for_request(l_ccm_request_id, 30, 600,

Line 329: itg_debug_pub.Add( 'l_ccm_request_id'||l_ccm_request_id,1);

325:
326: -- This was pulled from the original sync item code
327: IF (l_Debug_Level <= 1) THEN
328: itg_debug_pub.Add( 'Waiting for concurrent request.', 1);
329: itg_debug_pub.Add( 'l_ccm_request_id'||l_ccm_request_id,1);
330: END IF;
331:
332: l_bool := FND_CONCURRENT.wait_for_request(l_ccm_request_id, 30, 600,
333: l_phase, l_status, l_dev_phase, l_dev_status, l_errmsg);

Line 336: itg_debug_pub.Add( 'Results from concurrent request.', 1);

332: l_bool := FND_CONCURRENT.wait_for_request(l_ccm_request_id, 30, 600,
333: l_phase, l_status, l_dev_phase, l_dev_status, l_errmsg);
334:
335: IF (l_Debug_Level <= 1) THEN
336: itg_debug_pub.Add( 'Results from concurrent request.', 1);
337: itg_debug_pub.Add( 'l_phase' ||l_phase,1);
338: itg_debug_pub.Add( 'l_status' ||l_status,1);
339: itg_debug_pub.Add( 'l_dev_phase'||l_dev_phase,1);
340: itg_debug_pub.Add( 'l_dev_status'||l_dev_status,1);

Line 337: itg_debug_pub.Add( 'l_phase' ||l_phase,1);

333: l_phase, l_status, l_dev_phase, l_dev_status, l_errmsg);
334:
335: IF (l_Debug_Level <= 1) THEN
336: itg_debug_pub.Add( 'Results from concurrent request.', 1);
337: itg_debug_pub.Add( 'l_phase' ||l_phase,1);
338: itg_debug_pub.Add( 'l_status' ||l_status,1);
339: itg_debug_pub.Add( 'l_dev_phase'||l_dev_phase,1);
340: itg_debug_pub.Add( 'l_dev_status'||l_dev_status,1);
341: itg_debug_pub.Add( 'l_errmsg' ||l_errmsg,1);

Line 338: itg_debug_pub.Add( 'l_status' ||l_status,1);

334:
335: IF (l_Debug_Level <= 1) THEN
336: itg_debug_pub.Add( 'Results from concurrent request.', 1);
337: itg_debug_pub.Add( 'l_phase' ||l_phase,1);
338: itg_debug_pub.Add( 'l_status' ||l_status,1);
339: itg_debug_pub.Add( 'l_dev_phase'||l_dev_phase,1);
340: itg_debug_pub.Add( 'l_dev_status'||l_dev_status,1);
341: itg_debug_pub.Add( 'l_errmsg' ||l_errmsg,1);
342: END IF;

Line 339: itg_debug_pub.Add( 'l_dev_phase'||l_dev_phase,1);

335: IF (l_Debug_Level <= 1) THEN
336: itg_debug_pub.Add( 'Results from concurrent request.', 1);
337: itg_debug_pub.Add( 'l_phase' ||l_phase,1);
338: itg_debug_pub.Add( 'l_status' ||l_status,1);
339: itg_debug_pub.Add( 'l_dev_phase'||l_dev_phase,1);
340: itg_debug_pub.Add( 'l_dev_status'||l_dev_status,1);
341: itg_debug_pub.Add( 'l_errmsg' ||l_errmsg,1);
342: END IF;
343:

Line 340: itg_debug_pub.Add( 'l_dev_status'||l_dev_status,1);

336: itg_debug_pub.Add( 'Results from concurrent request.', 1);
337: itg_debug_pub.Add( 'l_phase' ||l_phase,1);
338: itg_debug_pub.Add( 'l_status' ||l_status,1);
339: itg_debug_pub.Add( 'l_dev_phase'||l_dev_phase,1);
340: itg_debug_pub.Add( 'l_dev_status'||l_dev_status,1);
341: itg_debug_pub.Add( 'l_errmsg' ||l_errmsg,1);
342: END IF;
343:
344: l_reap_status := FND_API.G_RET_STS_SUCCESS;

Line 341: itg_debug_pub.Add( 'l_errmsg' ||l_errmsg,1);

337: itg_debug_pub.Add( 'l_phase' ||l_phase,1);
338: itg_debug_pub.Add( 'l_status' ||l_status,1);
339: itg_debug_pub.Add( 'l_dev_phase'||l_dev_phase,1);
340: itg_debug_pub.Add( 'l_dev_status'||l_dev_status,1);
341: itg_debug_pub.Add( 'l_errmsg' ||l_errmsg,1);
342: END IF;
343:
344: l_reap_status := FND_API.G_RET_STS_SUCCESS;
345:

Line 368: itg_debug_pub.Add('SI - failure in Items Import concurrent request',1);

364: END IF;
365:
366: IF l_reap_status <> FND_API.G_RET_STS_SUCCESS THEN
367: IF (l_Debug_Level <= 1) THEN
368: itg_debug_pub.Add('SI - failure in Items Import concurrent request',1);
369: END IF;
370:
371: RAISE FND_API.G_EXC_ERROR;
372: END IF;

Line 375: itg_debug_pub.Add('Committing work.',1);

371: RAISE FND_API.G_EXC_ERROR;
372: END IF;
373:
374: IF (l_Debug_Level <= 1) THEN
375: itg_debug_pub.Add('Committing work.',1);
376: END IF;
377: COMMIT;
378:
379: IF (l_Debug_Level <= 2) THEN

Line 380: itg_debug_pub.Add('--- Exiting Sync_Item ---',2);

376: END IF;
377: COMMIT;
378:
379: IF (l_Debug_Level <= 2) THEN
380: itg_debug_pub.Add('--- Exiting Sync_Item ---',2);
381: END IF;
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK;

Line 388: itg_debug_pub.Add('--- Exiting Sync_Item ---ERROR',6);

384: ROLLBACK;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: ITG_msg.checked_error(g_action);
387: IF (l_Debug_Level <= 6) THEN
388: itg_debug_pub.Add('--- Exiting Sync_Item ---ERROR',6);
389: END IF;
390:
391: WHEN OTHERS THEN
392: ROLLBACK;

Line 394: ITG_Debug.msg('Unexpected error (Exchange-rate sync) - ' || substr(SQLERRM,1,255),true);

390:
391: WHEN OTHERS THEN
392: ROLLBACK;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: ITG_Debug.msg('Unexpected error (Exchange-rate sync) - ' || substr(SQLERRM,1,255),true);
395: ITG_msg.unexpected_error(g_action);
396: IF (l_Debug_Level <= 6) THEN
397: itg_debug_pub.Add('--- Exiting Sync_Item ---OTHER ERROR',6);
398: END IF;

Line 397: itg_debug_pub.Add('--- Exiting Sync_Item ---OTHER ERROR',6);

393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: ITG_Debug.msg('Unexpected error (Exchange-rate sync) - ' || substr(SQLERRM,1,255),true);
395: ITG_msg.unexpected_error(g_action);
396: IF (l_Debug_Level <= 6) THEN
397: itg_debug_pub.Add('--- Exiting Sync_Item ---OTHER ERROR',6);
398: END IF;
399: END;
400: -- Removed FND_MSG_PUB.Count_And_Get
401: END Sync_Item;

Line 429: itg_debug_pub.Add('--- Entering Start_BatchProcess ---',2);

425: -- get the parameters directly
426: -- removed call to batch mgmt.
427:
428: IF (l_Debug_Level <= 2) THEN
429: itg_debug_pub.Add('--- Entering Start_BatchProcess ---',2);
430: END IF;
431:
432: IF p_syncind = 'A' THEN
433: l_upd_flag := 1;

Line 443: ITG_Debug.add_exc_error(G_PKG_NAME, 'Start_BatchProcess');

439: FND_Client_Info.set_org_context(p_org_id);
440: MO_GLOBAL.set_policy_context('S', p_org_id); -- MOAC
441: EXCEPTION
442: WHEN OTHERS THEN
443: ITG_Debug.add_exc_error(G_PKG_NAME, 'Start_BatchProcess');
444: itg_msg.invalid_org(p_org_id);
445: RAISE FND_API.G_EXC_ERROR;
446: END;
447:

Line 449: itg_debug_pub.Add('--- Exting Start_BatchProcess ---',2);

445: RAISE FND_API.G_EXC_ERROR;
446: END;
447:
448: IF (l_Debug_Level <= 2) THEN
449: itg_debug_pub.Add('--- Exting Start_BatchProcess ---',2);
450: END IF;
451:
452: RETURN FND_REQUEST.submit_request(
453: application => 'INV',

Line 479: itg_debug_pub.Add('--- Entering Reap_BatchResults ---',2);

475: p_mici_rid ROWID) RETURN VARCHAR2 IS
476: l_process_flag VARCHAR2(30);
477: BEGIN
478: IF (l_Debug_Level <= 2) THEN
479: itg_debug_pub.Add('--- Entering Reap_BatchResults ---',2);
480: END IF;
481:
482: IF (l_Debug_Level <= 1) THEN
483: itg_debug_pub.Add( 'p_request_id' ||p_request_id ,1);

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

479: itg_debug_pub.Add('--- Entering Reap_BatchResults ---',2);
480: END IF;
481:
482: IF (l_Debug_Level <= 1) THEN
483: itg_debug_pub.Add( 'p_request_id' ||p_request_id ,1);
484: itg_debug_pub.Add( 'p_msii_rid' ||p_msii_rid,1);
485: itg_debug_pub.Add( 'p_mici_rid' ||p_mici_rid,1);
486: END IF;
487:

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

480: END IF;
481:
482: IF (l_Debug_Level <= 1) THEN
483: itg_debug_pub.Add( 'p_request_id' ||p_request_id ,1);
484: itg_debug_pub.Add( 'p_msii_rid' ||p_msii_rid,1);
485: itg_debug_pub.Add( 'p_mici_rid' ||p_mici_rid,1);
486: END IF;
487:
488: BEGIN

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

481:
482: IF (l_Debug_Level <= 1) THEN
483: itg_debug_pub.Add( 'p_request_id' ||p_request_id ,1);
484: itg_debug_pub.Add( 'p_msii_rid' ||p_msii_rid,1);
485: itg_debug_pub.Add( 'p_mici_rid' ||p_mici_rid,1);
486: END IF;
487:
488: BEGIN
489: SELECT process_flag

Line 499: itg_debug_pub.Add('process_flag '||l_process_flag ,1);

495: l_process_flag := null;
496: END;
497:
498: IF (l_Debug_Level <= 1) THEN
499: itg_debug_pub.Add('process_flag '||l_process_flag ,1);
500: END IF;
501:
502: -- if item procssing not complete, log appropriate message and return
503: IF l_process_flag IN ('1','2') THEN

Line 509: ITG_Debug.msg('Item-import errored out, request-id:' || p_request_id,TRUE);

505: return FND_API.G_RET_STS_ERROR;
506: END IF;
507:
508: IF l_process_flag NOT IN ('6','7') OR l_process_flag IS NULL THEN
509: ITG_Debug.msg('Item-import errored out, request-id:' || p_request_id,TRUE);
510: itg_msg.item_import_errors;
511: error_transactions(p_request_id,'MTL_SYSTEM_ITEMS_INTERFACE');
512: return FND_API.G_RET_STS_ERROR;
513: END IF;

Line 529: itg_debug_pub.Add('process_flag' || l_process_flag ,1);

525:
526: -- if item category procssing not complete, log appropriate message and return
527: -- since item interface import is success, make the txn/collaboration succesful
528: IF (l_Debug_Level <= 1) THEN
529: itg_debug_pub.Add('process_flag' || l_process_flag ,1);
530: END IF;
531:
532: IF l_process_flag IN ('1','2') THEN
533: itg_msg.itemcat_import_pending(p_request_id);

Line 538: ITG_Debug.msg('Item-category import errored out, request-id:' || p_request_id,TRUE);

534: return FND_API.G_RET_STS_SUCCESS;
535: END IF;
536:
537: IF l_process_flag NOT IN ('6','7') OR l_process_flag IS NULL THEN
538: ITG_Debug.msg('Item-category import errored out, request-id:' || p_request_id,TRUE);
539: itg_msg.mici_only_failed;
540: error_transactions(p_request_id,'MTL_ITEM_CATEGORIES_INTERFACE');
541: return FND_API.G_RET_STS_SUCCESS;
542: END IF;

Line 545: itg_debug_pub.Add('--- Exting Reap_BatchResults ---',2);

541: return FND_API.G_RET_STS_SUCCESS;
542: END IF;
543: END IF;
544: IF (l_Debug_Level <= 2) THEN
545: itg_debug_pub.Add('--- Exting Reap_BatchResults ---',2);
546: END IF;
547: -- code reaches here iff both item and category import are success
548: return FND_API.G_RET_STS_SUCCESS;
549: END;

Line 573: itg_debug_pub.Add('--- Entering error_transactions ---',2);

569: l_msg_name VARCHAR2(100);
570: BEGIN
571:
572: IF (l_Debug_Level <= 2) THEN
573: itg_debug_pub.Add('--- Entering error_transactions ---',2);
574: END IF;
575:
576: select count(*) into l_err_msg
577: from mtl_interface_errors

Line 588: itg_debug_pub.Add('Found an error record' ,1);

584: FETCH error_messages INTO l_msg_name, l_err_msg;
585: EXIT WHEN error_messages%NOTFOUND;
586:
587: IF (l_Debug_Level <= 1) THEN
588: itg_debug_pub.Add('Found an error record' ,1);
589: itg_debug_pub.Add('l_msg_name' || l_msg_name ,1);
590: itg_debug_pub.Add('l_err_msg ' || l_err_msg ,1);
591: END IF;
592:

Line 589: itg_debug_pub.Add('l_msg_name' || l_msg_name ,1);

585: EXIT WHEN error_messages%NOTFOUND;
586:
587: IF (l_Debug_Level <= 1) THEN
588: itg_debug_pub.Add('Found an error record' ,1);
589: itg_debug_pub.Add('l_msg_name' || l_msg_name ,1);
590: itg_debug_pub.Add('l_err_msg ' || l_err_msg ,1);
591: END IF;
592:
593: IF l_err_msg IS NOT NULL THEN

Line 590: itg_debug_pub.Add('l_err_msg ' || l_err_msg ,1);

586:
587: IF (l_Debug_Level <= 1) THEN
588: itg_debug_pub.Add('Found an error record' ,1);
589: itg_debug_pub.Add('l_msg_name' || l_msg_name ,1);
590: itg_debug_pub.Add('l_err_msg ' || l_err_msg ,1);
591: END IF;
592:
593: IF l_err_msg IS NOT NULL THEN
594: itg_debug.msg(l_err_msg, TRUE);

Line 594: itg_debug.msg(l_err_msg, TRUE);

590: itg_debug_pub.Add('l_err_msg ' || l_err_msg ,1);
591: END IF;
592:
593: IF l_err_msg IS NOT NULL THEN
594: itg_debug.msg(l_err_msg, TRUE);
595: END IF;
596:
597: IF l_msg_name IS NOT NULL AND
598: length(itg_x_utils.getCBODDescMsg) < 1000 THEN

Line 609: itg_debug_pub.Add('--- Exiting error_transactions ---',2);

605: );
606: END IF;
607: END LOOP;
608: IF (l_Debug_Level <= 2) THEN
609: itg_debug_pub.Add('--- Exiting error_transactions ---',2);
610: END IF;
611: /* no value in doing this, this table can be purged periodically */
612: --DELETE FROM mtl_interface_errors
613: --WHERE request_id = p_request_id

Line 617: itg_debug.msg('Error retrieving errors in item-import',TRUE);

613: --WHERE request_id = p_request_id
614:
615: EXCEPTION
616: WHEN OTHERS THEN
617: itg_debug.msg('Error retrieving errors in item-import',TRUE);
618: IF (l_Debug_Level <= 6) THEN
619: itg_debug_pub.Add('--- Exiting error_transactions ---OTHER ERROR',6);
620: END IF;
621: -- No value in propogating execption

Line 619: itg_debug_pub.Add('--- Exiting error_transactions ---OTHER ERROR',6);

615: EXCEPTION
616: WHEN OTHERS THEN
617: itg_debug.msg('Error retrieving errors in item-import',TRUE);
618: IF (l_Debug_Level <= 6) THEN
619: itg_debug_pub.Add('--- Exiting error_transactions ---OTHER ERROR',6);
620: END IF;
621: -- No value in propogating execption
622: END;
623: