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.INV_ITEM_CATEGORY_OI dependencies on INV_ITEM_MSG

Line 70: INV_ITEM_MSG.Add_Message

66: l_token_value := TO_CHAR(p_category_set_id);
67: l_column_name := 'CATEGORY_SET_ID';
68: l_return_status := 3;
69:
70: INV_ITEM_MSG.Add_Message
71: ( p_Msg_Name => l_msg_name
72: , p_token1 => l_token
73: , p_value1 => l_token_value
74: , p_transaction_id => p_transaction_id

Line 125: Mctx INV_ITEM_MSG.Msg_Ctx_type;

121: , p_login_id IN NUMBER := NULL
122: )
123: IS
124: l_api_name CONSTANT VARCHAR2(30) := 'process_Item_Category_records';
125: Mctx INV_ITEM_MSG.Msg_Ctx_type;
126:
127: --
128: -- Select records to flag missing or invalid organization_id
129: --

Line 386: INV_ITEM_MSG.Initialize;

382: l_udex_catalog_id := NULL;
383: END;
384:
385:
386: INV_ITEM_MSG.Initialize;
387:
388: INV_ITEM_MSG.set_Message_Mode ('CP_LOG');
389:
390: -- Set message level

Line 388: INV_ITEM_MSG.set_Message_Mode ('CP_LOG');

384:
385:
386: INV_ITEM_MSG.Initialize;
387:
388: INV_ITEM_MSG.set_Message_Mode ('CP_LOG');
389:
390: -- Set message level
391:
392: -- INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Statement);

Line 392: -- INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Statement);

388: INV_ITEM_MSG.set_Message_Mode ('CP_LOG');
389:
390: -- Set message level
391:
392: -- INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Statement);
393: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
394:
395: -- Define message context
396: Mctx.Package_Name := G_PKG_NAME;

Line 393: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);

389:
390: -- Set message level
391:
392: -- INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Statement);
393: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
394:
395: -- Define message context
396: Mctx.Package_Name := G_PKG_NAME;
397: Mctx.Procedure_Name := l_api_name;

Line 400: INV_ITEM_MSG.Debug(Mctx, 'start rec_set_id = '|| TO_CHAR(p_rec_set_id));

396: Mctx.Package_Name := G_PKG_NAME;
397: Mctx.Procedure_Name := l_api_name;
398:
399: IF (l_debug = 1) THEN
400: INV_ITEM_MSG.Debug(Mctx, 'start rec_set_id = '|| TO_CHAR(p_rec_set_id));
401: END IF;
402:
403: -- Set global package variables for the current import session
404:

Line 413: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';

409: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
410: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
411: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
412:
413: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
414:
415: INV_ITEM_MSG.g_User_id := g_User_id;
416: INV_ITEM_MSG.g_Login_id := g_Login_id;
417: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;

Line 415: INV_ITEM_MSG.g_User_id := g_User_id;

411: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
412:
413: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
414:
415: INV_ITEM_MSG.g_User_id := g_User_id;
416: INV_ITEM_MSG.g_Login_id := g_Login_id;
417: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;
418: INV_ITEM_MSG.g_Prog_id := g_Prog_id;
419: INV_ITEM_MSG.g_Request_id := g_Request_id;

Line 416: INV_ITEM_MSG.g_Login_id := g_Login_id;

412:
413: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
414:
415: INV_ITEM_MSG.g_User_id := g_User_id;
416: INV_ITEM_MSG.g_Login_id := g_Login_id;
417: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;
418: INV_ITEM_MSG.g_Prog_id := g_Prog_id;
419: INV_ITEM_MSG.g_Request_id := g_Request_id;
420:

Line 417: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;

413: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
414:
415: INV_ITEM_MSG.g_User_id := g_User_id;
416: INV_ITEM_MSG.g_Login_id := g_Login_id;
417: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;
418: INV_ITEM_MSG.g_Prog_id := g_Prog_id;
419: INV_ITEM_MSG.g_Request_id := g_Request_id;
420:
421: IF ( p_commit_flag = 1 ) THEN

Line 418: INV_ITEM_MSG.g_Prog_id := g_Prog_id;

414:
415: INV_ITEM_MSG.g_User_id := g_User_id;
416: INV_ITEM_MSG.g_Login_id := g_Login_id;
417: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;
418: INV_ITEM_MSG.g_Prog_id := g_Prog_id;
419: INV_ITEM_MSG.g_Request_id := g_Request_id;
420:
421: IF ( p_commit_flag = 1 ) THEN
422: l_commit := fnd_api.g_TRUE;

Line 419: INV_ITEM_MSG.g_Request_id := g_Request_id;

415: INV_ITEM_MSG.g_User_id := g_User_id;
416: INV_ITEM_MSG.g_Login_id := g_Login_id;
417: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;
418: INV_ITEM_MSG.g_Prog_id := g_Prog_id;
419: INV_ITEM_MSG.g_Request_id := g_Request_id;
420:
421: IF ( p_commit_flag = 1 ) THEN
422: l_commit := fnd_api.g_TRUE;
423: ELSE

Line 438: INV_ITEM_MSG.Debug(Mctx, 'assign all missing organization_id');

434:
435: -- Assign all missing organization_id from organization_code
436:
437: IF (l_debug = 1) THEN
438: INV_ITEM_MSG.Debug(Mctx, 'assign all missing organization_id');
439: END IF;
440:
441: UPDATE mtl_item_categories_interface mici
442: SET

Line 499: INV_ITEM_MSG.Add_Message

495: END IF;
496:
497: l_RETCODE := G_WARNING;
498:
499: INV_ITEM_MSG.Add_Message
500: ( p_Msg_Name => l_msg_name
501: , p_token1 => l_token
502: , p_value1 => l_token_value
503: , p_transaction_id => l_transaction_id

Line 516: INV_ITEM_MSG.Write_List (p_delete => TRUE);

512: END IF;
513:
514: -- Write all accumulated messages
515: --
516: INV_ITEM_MSG.Write_List (p_delete => TRUE);
517:
518: --------------------------------------------------------------------------
519: -- Process step 2: Loop through item category interface records --
520: -- (a) convert category set, item, category values to ids, if missing --

Line 528: INV_ITEM_MSG.Debug(Mctx, 'starting the main ICOI loop');

524: -- converted values --
525: --------------------------------------------------------------------------
526:
527: IF (l_debug = 1) THEN
528: INV_ITEM_MSG.Debug(Mctx, 'starting the main ICOI loop');
529: END IF;
530:
531: FOR icoi_rec IN icoi_csr LOOP --{
532:

Line 569: INV_ITEM_MSG.Add_Message

565: l_token := fnd_api.g_MISS_CHAR;
566: l_token_value := l_transaction_type;
567: l_column_name := 'TRANSACTION_TYPE';
568:
569: INV_ITEM_MSG.Add_Message
570: ( p_Msg_Name => l_msg_name
571: , p_token1 => l_token
572: , p_value1 => l_token_value
573: , p_transaction_id => l_transaction_id

Line 590: INV_ITEM_MSG.Debug(Mctx, 'assign missing category_set_id');

586:
587: IF ( l_category_set_id IS NULL ) THEN
588:
589: IF (l_debug = 1) THEN
590: INV_ITEM_MSG.Debug(Mctx, 'assign missing category_set_id');
591: END IF;
592:
593: IF ( icoi_rec.category_set_name IS NOT NULL ) THEN
594: OPEN category_set_name_csr

Line 628: INV_ITEM_MSG.Add_Message

624: l_process_flag := 3;
625:
626: l_RETCODE := G_WARNING;
627:
628: INV_ITEM_MSG.Add_Message
629: ( p_Msg_Name => l_msg_name
630: , p_token1 => l_token
631: , p_value1 => l_token_value
632: , p_transaction_id => l_transaction_id

Line 652: INV_ITEM_MSG.Debug(Mctx, 'assign missing old category_id');

648: IF ( l_transaction_type IN ('UPDATE', 'SYNC') AND (l_category_set_id IS NOT NULL)
649: AND (l_old_category_id IS NULL) ) THEN
650:
651: IF (l_debug = 1) THEN
652: INV_ITEM_MSG.Debug(Mctx, 'assign missing old category_id');
653: END IF;
654:
655: IF ( icoi_rec.old_category_name IS NOT NULL ) THEN
656: --* Fetching Category Id using Category Name

Line 658: INV_ITEM_MSG.Debug(Mctx, 'Fetching Category Id using Category Name');

654:
655: IF ( icoi_rec.old_category_name IS NOT NULL ) THEN
656: --* Fetching Category Id using Category Name
657: IF (l_debug = 1) THEN
658: INV_ITEM_MSG.Debug(Mctx, 'Fetching Category Id using Category Name');
659: END IF;
660: BEGIN
661: SELECT Category_id
662: INTO l_old_category_id

Line 692: INV_ITEM_MSG.Add_Message

688: l_process_flag := 3;
689:
690: l_RETCODE := G_WARNING;
691:
692: INV_ITEM_MSG.Add_Message
693: ( p_Msg_Name => l_msg_name
694: , p_token1 => l_token
695: , p_value1 => l_token_value
696: , p_transaction_id => l_transaction_id

Line 715: INV_ITEM_MSG.Debug(Mctx, 'assign missing category_id');

711:
712: IF ( (l_category_set_id IS NOT NULL) AND (l_category_id IS NULL) ) THEN
713:
714: IF (l_debug = 1) THEN
715: INV_ITEM_MSG.Debug(Mctx, 'assign missing category_id');
716: END IF;
717:
718: IF ( icoi_rec.category_name IS NOT NULL ) THEN
719: -- commented for fixing 2636268

Line 775: INV_ITEM_MSG.Add_Message

771: l_process_flag := 3;
772:
773: l_RETCODE := G_WARNING;
774:
775: INV_ITEM_MSG.Add_Message
776: ( p_Msg_Name => l_msg_name
777: , p_token1 => l_token
778: , p_value1 => l_token_value
779: , p_transaction_id => l_transaction_id

Line 795: INV_ITEM_MSG.Debug(Mctx, 'assign missing inventory_item_id');

791:
792: IF ( l_inventory_item_id IS NULL ) THEN
793:
794: IF (l_debug = 1) THEN
795: INV_ITEM_MSG.Debug(Mctx, 'assign missing inventory_item_id');
796: END IF;
797:
798: IF ( icoi_rec.item_number IS NOT NULL ) THEN
799: -- commented for fixing 2636268

Line 854: INV_ITEM_MSG.Add_Message

850: l_process_flag := 3;
851:
852: l_RETCODE := G_WARNING;
853:
854: INV_ITEM_MSG.Add_Message
855: ( p_Msg_Name => l_msg_name
856: , p_token1 => l_token
857: , p_value1 => l_token_value
858: , p_transaction_id => l_transaction_id

Line 884: INV_ITEM_MSG.Add_Message

880:
881: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
882: l_process_flag := 3;
883: l_RETCODE := G_WARNING;
884: INV_ITEM_MSG.Add_Message
885: ( p_Msg_Name => l_msg_name
886: , p_token1 => l_token
887: , p_value1 => l_token_value
888: , p_transaction_id => l_transaction_id

Line 952: INV_ITEM_MSG.Add_Message

948:
949: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
950: l_process_flag := 3;
951: l_RETCODE := G_WARNING;
952: INV_ITEM_MSG.Add_Message
953: ( p_Msg_Name => l_msg_name
954: , p_token1 => l_token
955: , p_value1 => l_token_value
956: , p_transaction_id => l_transaction_id

Line 968: INV_ITEM_MSG.Write_List (p_delete => TRUE);

964: END IF; -- created_d by
965: END IF; -- UPLOAD REC
966:
967: -- Write all accumulated messages
968: INV_ITEM_MSG.Write_List (p_delete => TRUE);
969:
970: --
971: -- If value-to-id conversions are successful, call the API
972: -- to process item category assignment.

Line 980: INV_ITEM_MSG.Debug(Mctx, 'calling INV_ITEM_CATEGORY_PVT.Delete_Category_Assignment');

976:
977: IF ( l_transaction_type = 'DELETE' ) THEN
978:
979: IF (l_debug = 1) THEN
980: INV_ITEM_MSG.Debug(Mctx, 'calling INV_ITEM_CATEGORY_PVT.Delete_Category_Assignment');
981: END IF;
982:
983: INV_ITEM_CATEGORY_PVT.Delete_Category_Assignment
984: (

Line 1004: INV_ITEM_MSG.Debug(Mctx, 'error in Delete_Category_Assignment. Msg count=' || TO_CHAR(INV_ITEM_MSG.Count_Msg));

1000: ELSE
1001: l_process_flag := 3;
1002:
1003: IF (l_debug = 1) THEN
1004: INV_ITEM_MSG.Debug(Mctx, 'error in Delete_Category_Assignment. Msg count=' || TO_CHAR(INV_ITEM_MSG.Count_Msg));
1005: END IF;
1006:
1007: l_RETCODE := G_WARNING;
1008:

Line 1020: INV_ITEM_MSG.Debug(Mctx, 'calling INV_ITEM_CATEGORY_PVT.Create_Category_Assignment');

1016:
1017: ELSIF ( l_transaction_type = 'CREATE' ) THEN
1018:
1019: IF (l_debug = 1) THEN
1020: INV_ITEM_MSG.Debug(Mctx, 'calling INV_ITEM_CATEGORY_PVT.Create_Category_Assignment');
1021: END IF;
1022:
1023: INV_ITEM_CATEGORY_PVT.Create_Category_Assignment
1024: (

Line 1061: INV_ITEM_MSG.Debug(Mctx, 'error in Create_Category_Assignment ' || l_msg_data);

1057: END;
1058: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1059: l_process_flag := 3;
1060: IF (l_debug = 1) THEN
1061: INV_ITEM_MSG.Debug(Mctx, 'error in Create_Category_Assignment ' || l_msg_data);
1062: END IF;
1063: l_RETCODE := G_WARNING;
1064: END IF;
1065: /* End of bug 5517473 */

Line 1071: INV_ITEM_MSG.Debug(Mctx, 'error in Create_Category_Assignment. Msg count=' || TO_CHAR(INV_ITEM_MSG.Count_Msg));

1067: ELSE
1068: l_process_flag := 3;
1069:
1070: IF (l_debug = 1) THEN
1071: INV_ITEM_MSG.Debug(Mctx, 'error in Create_Category_Assignment. Msg count=' || TO_CHAR(INV_ITEM_MSG.Count_Msg));
1072: END IF;
1073:
1074: l_RETCODE := G_WARNING;
1075:

Line 1083: INV_ITEM_MSG.Debug(Mctx, 'LOOP FND_MSG_PUB Msg: idx=' || TO_CHAR(idx));

1079:
1080: FOR idx IN 1 .. FND_MSG_PUB.Count_Msg LOOP
1081:
1082: IF (l_debug = 1) THEN
1083: INV_ITEM_MSG.Debug(Mctx, 'LOOP FND_MSG_PUB Msg: idx=' || TO_CHAR(idx));
1084: END IF;
1085:
1086: DECLARE
1087: l_app_short_name VARCHAR2(30);

Line 1105: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || SUBSTRB(l_msg_name, 1,30));

1101: l_msg_text := FND_MSG_PUB.Get ( p_msg_index => idx
1102: , p_encoded => FND_API.g_FALSE
1103: );
1104:
1105: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || SUBSTRB(l_msg_name, 1,30));
1106: IF (l_debug = 1) THEN
1107: INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || l_msg_name);
1108: INV_ITEM_MSG.Debug(Mctx, 'l_msg_text=' || l_msg_text);
1109: END IF;

Line 1107: INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || l_msg_name);

1103: );
1104:
1105: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || SUBSTRB(l_msg_name, 1,30));
1106: IF (l_debug = 1) THEN
1107: INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || l_msg_name);
1108: INV_ITEM_MSG.Debug(Mctx, 'l_msg_text=' || l_msg_text);
1109: END IF;
1110: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_text_length=' || TO_CHAR( LENGTH(l_msg_text) ));
1111: END;

Line 1108: INV_ITEM_MSG.Debug(Mctx, 'l_msg_text=' || l_msg_text);

1104:
1105: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || SUBSTRB(l_msg_name, 1,30));
1106: IF (l_debug = 1) THEN
1107: INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || l_msg_name);
1108: INV_ITEM_MSG.Debug(Mctx, 'l_msg_text=' || l_msg_text);
1109: END IF;
1110: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_text_length=' || TO_CHAR( LENGTH(l_msg_text) ));
1111: END;
1112:

Line 1110: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_text_length=' || TO_CHAR( LENGTH(l_msg_text) ));

1106: IF (l_debug = 1) THEN
1107: INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || l_msg_name);
1108: INV_ITEM_MSG.Debug(Mctx, 'l_msg_text=' || l_msg_text);
1109: END IF;
1110: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_text_length=' || TO_CHAR( LENGTH(l_msg_text) ));
1111: END;
1112:
1113: END LOOP; -- loop through the messages
1114: */

Line 1128: INV_ITEM_MSG.Debug(Mctx, 'calling INV_ITEM_CATEGORY_PVT.Update_Category_Assignment');

1124: END IF;
1125: --* Code added for Bug #3991044
1126: ELSIF ( l_transaction_type = 'UPDATE' ) THEN
1127: IF (l_debug = 1) THEN
1128: INV_ITEM_MSG.Debug(Mctx, 'calling INV_ITEM_CATEGORY_PVT.Update_Category_Assignment');
1129: END IF;
1130:
1131: l_return_status := fnd_api.g_RET_STS_SUCCESS;
1132:

Line 1176: INV_ITEM_MSG.Debug(Mctx, 'error in Update_Category_Assignment ' || l_msg_data);

1172: END;
1173: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1174: l_process_flag := 3;
1175: IF (l_debug = 1) THEN
1176: INV_ITEM_MSG.Debug(Mctx, 'error in Update_Category_Assignment ' || l_msg_data);
1177: END IF;
1178: l_RETCODE := G_WARNING;
1179: END IF;
1180: /* End of bug 5517473 */

Line 1185: INV_ITEM_MSG.Debug(Mctx, 'error in Update_Category_Assignment. Msg count=' || TO_CHAR(INV_ITEM_MSG.Count_Msg));

1181: END IF; --Udex Catalog
1182: ELSE
1183: l_process_flag := 3;
1184: IF (l_debug = 1) THEN
1185: INV_ITEM_MSG.Debug(Mctx, 'error in Update_Category_Assignment. Msg count=' || TO_CHAR(INV_ITEM_MSG.Count_Msg));
1186: END IF;
1187: l_RETCODE := G_WARNING;
1188: END IF; -- l_return_status
1189: --* End of Bug #3991044

Line 1199: INV_ITEM_MSG.Debug(Mctx, 'calling Sync_Category_Assignments');

1195: IF ( l_process_flag = 7 ) THEN
1196: -- Sync item category assignment with item record in STAR.
1197:
1198: IF (l_debug = 1) THEN
1199: INV_ITEM_MSG.Debug(Mctx, 'calling Sync_Category_Assignments');
1200: END IF;
1201:
1202: -- Bug: 2718703 checking for ENI product before calling their package
1203: -- Start Bug: 3185516

Line 1245: INV_ITEM_MSG.Write_List (p_delete => TRUE);

1241: END IF; -- process_flag = 4 AND p_upload_rec_flag = 1
1242:
1243: -- Write all accumulated messages
1244: --
1245: INV_ITEM_MSG.Write_List (p_delete => TRUE);
1246:
1247: --
1248: -- Update the current interface record
1249: --

Line 1252: INV_ITEM_MSG.Debug(Mctx, 'update interface record');

1248: -- Update the current interface record
1249: --
1250:
1251: IF (l_debug = 1) THEN
1252: INV_ITEM_MSG.Debug(Mctx, 'update interface record');
1253: END IF;
1254:
1255: UPDATE mtl_item_categories_interface
1256: SET

Line 1390: INV_ITEM_MSG.Debug(Mctx, 'calling delete_OI_records');

1386:
1387: IF ( p_delete_rec_flag = 1 ) THEN
1388:
1389: IF (l_debug = 1) THEN
1390: INV_ITEM_MSG.Debug(Mctx, 'calling delete_OI_records');
1391: END IF;
1392:
1393: INV_ITEM_CATEGORY_OI.delete_OI_records
1394: ( p_commit => l_commit

Line 1400: INV_ITEM_MSG.Debug(Mctx, 'done delete_OI_records: return_status=' || l_return_status);

1396: , x_return_status => l_return_status
1397: );
1398:
1399: IF (l_debug = 1) THEN
1400: INV_ITEM_MSG.Debug(Mctx, 'done delete_OI_records: return_status=' || l_return_status);
1401: END IF;
1402:
1403: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1404: RAISE Processing_Error;

Line 1408: INV_ITEM_MSG.Write_List (p_delete => TRUE);

1404: RAISE Processing_Error;
1405: END IF;
1406:
1407: -- Write all accumulated messages
1408: INV_ITEM_MSG.Write_List (p_delete => TRUE);
1409:
1410: END IF; -- p_delete_rec_flag = 1
1411:
1412: --

Line 1432: INV_ITEM_MSG.Write_List (p_delete => TRUE);

1428: RETCODE := G_ERROR;
1429: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_ICOI_FAILURE');
1430:
1431: -- Write all accumulated messages
1432: INV_ITEM_MSG.Write_List (p_delete => TRUE);
1433:
1434: -- Check of commit
1435: IF ( FND_API.To_Boolean(l_commit) ) THEN
1436: COMMIT WORK;

Line 1445: INV_ITEM_MSG.Add_Message

1441: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_ICOI_FAILURE');
1442:
1443: l_err_text := SUBSTRB(SQLERRM, 1,240);
1444:
1445: INV_ITEM_MSG.Add_Message
1446: ( p_Msg_Name => 'INV_ITEM_UNEXPECTED_ERROR'
1447: , p_token1 => 'PKG_NAME'
1448: , p_value1 => G_PKG_NAME
1449: , p_token2 => 'PROCEDURE_NAME'

Line 1457: INV_ITEM_MSG.Write_List (p_delete => TRUE);

1453: , p_transaction_id => l_transaction_id
1454: );
1455:
1456: -- Write all accumulated messages
1457: INV_ITEM_MSG.Write_List (p_delete => TRUE);
1458:
1459: -- Check of commit
1460: IF ( FND_API.To_Boolean(l_commit) ) THEN
1461: COMMIT WORK;

Line 1489: Mctx INV_ITEM_MSG.Msg_Ctx_type;

1485: , x_return_status OUT NOCOPY VARCHAR2
1486: )
1487: IS
1488: l_api_name CONSTANT VARCHAR2(30) := 'delete_OI_records';
1489: Mctx INV_ITEM_MSG.Msg_Ctx_type;
1490:
1491: l_del_process_flag NUMBER := 7; -- process_flag value for records to be deleted
1492: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1493: BEGIN

Line 1499: INV_ITEM_MSG.Debug(Mctx, 'begin');

1495: Mctx.Package_Name := G_PKG_NAME;
1496: Mctx.Procedure_Name := l_api_name;
1497:
1498: IF (l_debug = 1) THEN
1499: INV_ITEM_MSG.Debug(Mctx, 'begin');
1500: END IF;
1501:
1502: -- Initialize API return status to success
1503: x_return_status := FND_API.g_RET_STS_SUCCESS;

Line 1513: --INV_ITEM_MSG.Debug(Mctx, 'deleted ' || TO_CHAR(SQL%ROWCOUNT) || ' record(s)');

1509: AND rownum < G_ROWS_TO_COMMIT;
1510:
1511: EXIT WHEN SQL%NOTFOUND;
1512:
1513: --INV_ITEM_MSG.Debug(Mctx, 'deleted ' || TO_CHAR(SQL%ROWCOUNT) || ' record(s)');
1514:
1515: -- Check of commit
1516: IF ( FND_API.To_Boolean(p_commit) ) THEN
1517: COMMIT WORK;

Line 1527: INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);

1523:
1524: WHEN others THEN
1525: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1526:
1527: INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);
1528:
1529: -- Check of commit
1530: IF ( FND_API.To_Boolean(p_commit) ) THEN
1531: COMMIT WORK;