DBA Data[Home] [Help]

APPS.ITG_SYNCITEMINBOUND_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

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 202: INSERT INTO mtl_system_items_interface (

198: END IF;
199:
200: g_action := 'Item-interface insert';
201:
202: INSERT INTO mtl_system_items_interface (
203: set_process_id,
204: creation_date,
205: last_update_date,
206: last_updated_by,

Line 491: FROM mtl_system_items_interface

487:
488: BEGIN
489: SELECT process_flag
490: INTO l_process_flag
491: FROM mtl_system_items_interface
492: WHERE rowid = p_msii_rid;
493: EXCEPTION
494: WHEN OTHERS THEN
495: l_process_flag := null;

Line 511: error_transactions(p_request_id,'MTL_SYSTEM_ITEMS_INTERFACE');

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;
514:
515: IF p_mici_rid IS NOT NULL THEN