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 126: Mctx INV_ITEM_MSG.Msg_Ctx_type;

122: , p_validate_rec_flag IN NUMBER DEFAULT 1 /*Fix for bug 9714783 - moved p_validate_rec_flag parameter to the end*/
123: )
124: IS
125: l_api_name CONSTANT VARCHAR2(30) := 'process_Item_Category_records';
126: Mctx INV_ITEM_MSG.Msg_Ctx_type;
127:
128: --
129: -- Select records to flag missing or invalid organization_id
130: --

Line 391: INV_ITEM_MSG.Initialize;

387: l_udex_catalog_id := NULL;
388: END;
389:
390:
391: INV_ITEM_MSG.Initialize;
392:
393: INV_ITEM_MSG.set_Message_Mode ('CP_LOG');
394:
395: -- Set message level

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

389:
390:
391: INV_ITEM_MSG.Initialize;
392:
393: INV_ITEM_MSG.set_Message_Mode ('CP_LOG');
394:
395: -- Set message level
396:
397: -- Bug 10077974 : Start

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

394:
395: -- Set message level
396:
397: -- Bug 10077974 : Start
398: -- INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Statement);
399: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
400: -- Bug 10077974 : End
401:
402: -- Define message context

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

395: -- Set message level
396:
397: -- Bug 10077974 : Start
398: -- INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Statement);
399: INV_ITEM_MSG.set_Message_Level (INV_ITEM_MSG.g_Level_Error);
400: -- Bug 10077974 : End
401:
402: -- Define message context
403: Mctx.Package_Name := G_PKG_NAME;

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

403: Mctx.Package_Name := G_PKG_NAME;
404: Mctx.Procedure_Name := l_api_name;
405:
406: IF (l_debug = 1) THEN
407: INV_ITEM_MSG.Debug(Mctx, 'start rec_set_id = '|| TO_CHAR(p_rec_set_id));
408: END IF;
409:
410: -- Set global package variables for the current import session
411:

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

416: g_Prog_appid := NVL(p_prog_appid, FND_GLOBAL.prog_appl_id );
417: g_Prog_id := NVL(p_prog_id, FND_GLOBAL.conc_program_id );
418: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
419:
420: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
421:
422: INV_ITEM_MSG.g_User_id := g_User_id;
423: INV_ITEM_MSG.g_Login_id := g_Login_id;
424: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;

Line 422: INV_ITEM_MSG.g_User_id := g_User_id;

418: g_Request_id := NVL(p_request_id, FND_GLOBAL.conc_request_id );
419:
420: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
421:
422: INV_ITEM_MSG.g_User_id := g_User_id;
423: INV_ITEM_MSG.g_Login_id := g_Login_id;
424: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;
425: INV_ITEM_MSG.g_Prog_id := g_Prog_id;
426: INV_ITEM_MSG.g_Request_id := g_Request_id;

Line 423: INV_ITEM_MSG.g_Login_id := g_Login_id;

419:
420: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
421:
422: INV_ITEM_MSG.g_User_id := g_User_id;
423: INV_ITEM_MSG.g_Login_id := g_Login_id;
424: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;
425: INV_ITEM_MSG.g_Prog_id := g_Prog_id;
426: INV_ITEM_MSG.g_Request_id := g_Request_id;
427:

Line 424: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;

420: INV_ITEM_MSG.g_Table_Name := 'MTL_ITEM_CATEGORIES_INTERFACE';
421:
422: INV_ITEM_MSG.g_User_id := g_User_id;
423: INV_ITEM_MSG.g_Login_id := g_Login_id;
424: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;
425: INV_ITEM_MSG.g_Prog_id := g_Prog_id;
426: INV_ITEM_MSG.g_Request_id := g_Request_id;
427:
428: IF ( p_commit_flag = 1 ) THEN

Line 425: INV_ITEM_MSG.g_Prog_id := g_Prog_id;

421:
422: INV_ITEM_MSG.g_User_id := g_User_id;
423: INV_ITEM_MSG.g_Login_id := g_Login_id;
424: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;
425: INV_ITEM_MSG.g_Prog_id := g_Prog_id;
426: INV_ITEM_MSG.g_Request_id := g_Request_id;
427:
428: IF ( p_commit_flag = 1 ) THEN
429: l_commit := fnd_api.g_TRUE;

Line 426: INV_ITEM_MSG.g_Request_id := g_Request_id;

422: INV_ITEM_MSG.g_User_id := g_User_id;
423: INV_ITEM_MSG.g_Login_id := g_Login_id;
424: INV_ITEM_MSG.g_Prog_appid := g_Prog_appid;
425: INV_ITEM_MSG.g_Prog_id := g_Prog_id;
426: INV_ITEM_MSG.g_Request_id := g_Request_id;
427:
428: IF ( p_commit_flag = 1 ) THEN
429: l_commit := fnd_api.g_TRUE;
430: ELSE

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

441:
442: -- Assign all missing organization_id from organization_code
443:
444: IF (l_debug = 1) THEN
445: INV_ITEM_MSG.Debug(Mctx, 'assign all missing organization_id');
446: END IF;
447:
448: UPDATE mtl_item_categories_interface mici
449: SET

Line 506: INV_ITEM_MSG.Add_Message

502: END IF;
503:
504: l_RETCODE := G_WARNING;
505:
506: INV_ITEM_MSG.Add_Message
507: ( p_Msg_Name => l_msg_name
508: , p_token1 => l_token
509: , p_value1 => l_token_value
510: , p_transaction_id => l_transaction_id

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

519: END IF;
520:
521: -- Write all accumulated messages
522: --
523: INV_ITEM_MSG.Write_List (p_delete => TRUE);
524:
525: --------------------------------------------------------------------------
526: -- Process step 2: Loop through item category interface records --
527: -- (a) convert category set, item, category values to ids, if missing --

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

531: -- converted values --
532: --------------------------------------------------------------------------
533:
534: IF (l_debug = 1) THEN
535: INV_ITEM_MSG.Debug(Mctx, 'starting the main ICOI loop');
536: END IF;
537:
538: FOR icoi_rec IN icoi_csr LOOP --{
539:

Line 576: INV_ITEM_MSG.Add_Message

572: l_token := fnd_api.g_MISS_CHAR;
573: l_token_value := l_transaction_type;
574: l_column_name := 'TRANSACTION_TYPE';
575:
576: INV_ITEM_MSG.Add_Message
577: ( p_Msg_Name => l_msg_name
578: , p_token1 => l_token
579: , p_value1 => l_token_value
580: , p_transaction_id => l_transaction_id

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

593:
594: IF ( l_category_set_id IS NULL ) THEN
595:
596: IF (l_debug = 1) THEN
597: INV_ITEM_MSG.Debug(Mctx, 'assign missing category_set_id');
598: END IF;
599:
600: IF ( icoi_rec.category_set_name IS NOT NULL ) THEN
601: OPEN category_set_name_csr

Line 635: INV_ITEM_MSG.Add_Message

631: l_process_flag := 3;
632:
633: l_RETCODE := G_WARNING;
634:
635: INV_ITEM_MSG.Add_Message
636: ( p_Msg_Name => l_msg_name
637: , p_token1 => l_token
638: , p_value1 => l_token_value
639: , p_transaction_id => l_transaction_id

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

655: IF ( l_transaction_type IN ('UPDATE', 'SYNC') AND (l_category_set_id IS NOT NULL)
656: AND (l_old_category_id IS NULL) ) THEN
657:
658: IF (l_debug = 1) THEN
659: INV_ITEM_MSG.Debug(Mctx, 'assign missing old category_id');
660: END IF;
661:
662: IF ( icoi_rec.old_category_name IS NOT NULL ) THEN
663: --* Fetching Category Id using Category Name

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

661:
662: IF ( icoi_rec.old_category_name IS NOT NULL ) THEN
663: --* Fetching Category Id using Category Name
664: IF (l_debug = 1) THEN
665: INV_ITEM_MSG.Debug(Mctx, 'Fetching Category Id using Category Name');
666: END IF;
667: BEGIN
668: SELECT Category_id
669: INTO l_old_category_id

Line 700: INV_ITEM_MSG.Add_Message

696: l_process_flag := 3;
697:
698: l_RETCODE := G_WARNING;
699:
700: INV_ITEM_MSG.Add_Message
701: ( p_Msg_Name => l_msg_name
702: , p_token1 => l_token
703: , p_value1 => l_token_value
704: , p_transaction_id => l_transaction_id

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

719:
720: IF ( (l_category_set_id IS NOT NULL) AND (l_category_id IS NULL) ) THEN
721:
722: IF (l_debug = 1) THEN
723: INV_ITEM_MSG.Debug(Mctx, 'assign missing category_id');
724: END IF;
725:
726: IF ( icoi_rec.category_name IS NOT NULL ) THEN
727: -- commented for fixing 2636268

Line 752: INV_ITEM_MSG.Debug(Mctx, 'Comes out correctly after fetching from KFV');

748: WHERE concatenated_segments = icoi_rec.category_name
749: -- bug 3500492
750: AND structure_id = l_structure_id
751: AND NVL(disable_date,SYSDATE+1) > SYSDATE;
752: INV_ITEM_MSG.Debug(Mctx, 'Comes out correctly after fetching from KFV');
753: EXCEPTION
754: WHEN NO_DATA_FOUND THEN
755: l_return_status := fnd_api.g_RET_STS_ERROR;
756: l_msg_name := 'INV_ICOI_INVALID_CAT_NAME';

Line 784: INV_ITEM_MSG.Add_Message

780: l_process_flag := 3;
781:
782: l_RETCODE := G_WARNING;
783:
784: INV_ITEM_MSG.Add_Message
785: ( p_Msg_Name => l_msg_name
786: , p_token1 => l_token
787: , p_value1 => l_token_value
788: , p_transaction_id => l_transaction_id

Line 801: INV_ITEM_MSG.Debug(Mctx, 'Before missing inventory_item_id');

797: l_return_status := fnd_api.g_RET_STS_SUCCESS;
798:
799: l_inventory_item_id := icoi_rec.inventory_item_id;
800:
801: INV_ITEM_MSG.Debug(Mctx, 'Before missing inventory_item_id');
802: IF ( l_inventory_item_id IS NULL ) THEN
803:
804: IF (l_debug = 1) THEN
805: INV_ITEM_MSG.Debug(Mctx, 'assign missing inventory_item_id');

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

801: INV_ITEM_MSG.Debug(Mctx, 'Before missing inventory_item_id');
802: IF ( l_inventory_item_id IS NULL ) THEN
803:
804: IF (l_debug = 1) THEN
805: INV_ITEM_MSG.Debug(Mctx, 'assign missing inventory_item_id');
806: END IF;
807:
808: IF ( icoi_rec.item_number IS NOT NULL ) THEN
809: -- commented for fixing 2636268

Line 904: INV_ITEM_MSG.Add_Message

900: l_process_flag := 3;
901:
902: l_RETCODE := G_WARNING;
903:
904: INV_ITEM_MSG.Add_Message
905: ( p_Msg_Name => l_msg_name
906: , p_token1 => l_token
907: , p_value1 => l_token_value
908: , p_transaction_id => l_transaction_id

Line 916: INV_ITEM_MSG.Debug(Mctx, 'Before checking for created_by ');

912: END IF;
913:
914: l_return_status := fnd_api.g_RET_STS_SUCCESS;
915:
916: INV_ITEM_MSG.Debug(Mctx, 'Before checking for created_by ');
917: -- Security check to be skipped for defaulted records bug 6456493
918: IF ( icoi_rec.created_by <> -99 ) THEN
919: l_has_privilege := INV_EGO_REVISION_VALIDATE.check_data_security(
920: p_function => 'EGO_MANAGE_CATEGORY_SET'

Line 935: INV_ITEM_MSG.Add_Message

931:
932: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
933: l_process_flag := 3;
934: l_RETCODE := G_WARNING;
935: INV_ITEM_MSG.Add_Message
936: ( p_Msg_Name => l_msg_name
937: , p_token1 => l_token
938: , p_value1 => l_token_value
939: , p_transaction_id => l_transaction_id

Line 948: INV_ITEM_MSG.Debug(Mctx, 'After checking for created_by ');

944: IF l_inv_debug_level IN(101, 102) THEN
945: INVPUTLI.info('INVCICIB. Security check skipped for Item Org CS' || l_inventory_item_id || '-' || l_organization_id || '-' || l_category_set_id);
946: END IF;
947: END IF;
948: INV_ITEM_MSG.Debug(Mctx, 'After checking for created_by ');
949: --Resolve SYNC records to CREATE/UPDATE
950: IF l_transaction_type = 'SYNC' THEN
951: INV_ITEM_MSG.Debug(Mctx, 'inside transaction type of SYNC ');
952: UPDATE_SYNC_RECORDS(p_inventory_item_id => l_inventory_item_id,

Line 951: INV_ITEM_MSG.Debug(Mctx, 'inside transaction type of SYNC ');

947: END IF;
948: INV_ITEM_MSG.Debug(Mctx, 'After checking for created_by ');
949: --Resolve SYNC records to CREATE/UPDATE
950: IF l_transaction_type = 'SYNC' THEN
951: INV_ITEM_MSG.Debug(Mctx, 'inside transaction type of SYNC ');
952: UPDATE_SYNC_RECORDS(p_inventory_item_id => l_inventory_item_id,
953: p_organization_id => l_organization_id,
954: p_category_set_id => l_category_set_id,
955: p_transaction_id => l_transaction_id,

Line 969: INV_ITEM_MSG.Debug(Mctx, 'Value for p_upload_rec_flag is '|| to_char(p_upload_rec_flag));

965: l_old_category_id := l_ret_old_category_id;
966: END IF;
967: END IF;
968:
969: INV_ITEM_MSG.Debug(Mctx, 'Value for p_upload_rec_flag is '|| to_char(p_upload_rec_flag));
970: IF p_upload_rec_flag = 1 THEN
971: --Start: Check for data security and user privileges
972: l_return_status := fnd_api.g_RET_STS_SUCCESS;
973:

Line 1005: INV_ITEM_MSG.Add_Message

1001:
1002: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1003: l_process_flag := 3;
1004: l_RETCODE := G_WARNING;
1005: INV_ITEM_MSG.Add_Message
1006: ( p_Msg_Name => l_msg_name
1007: , p_token1 => l_token
1008: , p_value1 => l_token_value
1009: , p_transaction_id => l_transaction_id

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

1017: END IF; -- created_d by
1018: END IF; -- UPLOAD REC
1019:
1020: -- Write all accumulated messages
1021: INV_ITEM_MSG.Write_List (p_delete => TRUE);
1022:
1023: --
1024: -- If value-to-id conversions are successful, call the API
1025: -- to process item category assignment.

Line 1028: INV_ITEM_MSG.Debug(Mctx, 'Value for l_process_flag is '|| to_char(l_process_flag));

1024: -- If value-to-id conversions are successful, call the API
1025: -- to process item category assignment.
1026: --
1027:
1028: INV_ITEM_MSG.Debug(Mctx, 'Value for l_process_flag is '|| to_char(l_process_flag));
1029: INV_ITEM_MSG.Debug(Mctx, 'Value for p_upload_rec_flag again '|| to_char(p_upload_rec_flag));
1030: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type '|| l_transaction_type);
1031:
1032: IF ( l_process_flag = 4 AND p_upload_rec_flag = 1 ) THEN

Line 1029: INV_ITEM_MSG.Debug(Mctx, 'Value for p_upload_rec_flag again '|| to_char(p_upload_rec_flag));

1025: -- to process item category assignment.
1026: --
1027:
1028: INV_ITEM_MSG.Debug(Mctx, 'Value for l_process_flag is '|| to_char(l_process_flag));
1029: INV_ITEM_MSG.Debug(Mctx, 'Value for p_upload_rec_flag again '|| to_char(p_upload_rec_flag));
1030: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type '|| l_transaction_type);
1031:
1032: IF ( l_process_flag = 4 AND p_upload_rec_flag = 1 ) THEN
1033:

Line 1030: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type '|| l_transaction_type);

1026: --
1027:
1028: INV_ITEM_MSG.Debug(Mctx, 'Value for l_process_flag is '|| to_char(l_process_flag));
1029: INV_ITEM_MSG.Debug(Mctx, 'Value for p_upload_rec_flag again '|| to_char(p_upload_rec_flag));
1030: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type '|| l_transaction_type);
1031:
1032: IF ( l_process_flag = 4 AND p_upload_rec_flag = 1 ) THEN
1033:
1034: IF ( l_transaction_type = 'DELETE' ) THEN

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

1033:
1034: IF ( l_transaction_type = 'DELETE' ) THEN
1035:
1036: IF (l_debug = 1) THEN
1037: INV_ITEM_MSG.Debug(Mctx, 'calling INV_ITEM_CATEGORY_PVT.Delete_Category_Assignment');
1038: END IF;
1039:
1040: INV_ITEM_CATEGORY_PVT.Delete_Category_Assignment
1041: (

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

1057: ELSE
1058: l_process_flag := 3;
1059:
1060: IF (l_debug = 1) THEN
1061: INV_ITEM_MSG.Debug(Mctx, 'error in Delete_Category_Assignment. Msg count=' || TO_CHAR(INV_ITEM_MSG.Count_Msg));
1062: END IF;
1063:
1064: l_RETCODE := G_WARNING;
1065:

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

1073:
1074: ELSIF ( l_transaction_type = 'CREATE' ) THEN
1075:
1076: IF (l_debug = 1) THEN
1077: INV_ITEM_MSG.Debug(Mctx, 'calling INV_ITEM_CATEGORY_PVT.Create_Category_Assignment');
1078: END IF;
1079:
1080: INV_ITEM_CATEGORY_PVT.Create_Category_Assignment
1081: (

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

1114: END;
1115: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1116: l_process_flag := 3;
1117: IF (l_debug = 1) THEN
1118: INV_ITEM_MSG.Debug(Mctx, 'error in Create_Category_Assignment ' || l_msg_data);
1119: END IF;
1120: l_RETCODE := G_WARNING;
1121: END IF;
1122: /* End of bug 5517473 */

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

1124: ELSE
1125: l_process_flag := 3;
1126:
1127: IF (l_debug = 1) THEN
1128: INV_ITEM_MSG.Debug(Mctx, 'error in Create_Category_Assignment. Msg count=' || TO_CHAR(INV_ITEM_MSG.Count_Msg));
1129: END IF;
1130:
1131: l_RETCODE := G_WARNING;
1132:

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

1136:
1137: FOR idx IN 1 .. FND_MSG_PUB.Count_Msg LOOP
1138:
1139: IF (l_debug = 1) THEN
1140: INV_ITEM_MSG.Debug(Mctx, 'LOOP FND_MSG_PUB Msg: idx=' || TO_CHAR(idx));
1141: END IF;
1142:
1143: DECLARE
1144: l_app_short_name VARCHAR2(30);

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

1158: l_msg_text := FND_MSG_PUB.Get ( p_msg_index => idx
1159: , p_encoded => FND_API.g_FALSE
1160: );
1161:
1162: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || SUBSTRB(l_msg_name, 1,30));
1163: IF (l_debug = 1) THEN
1164: INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || l_msg_name);
1165: INV_ITEM_MSG.Debug(Mctx, 'l_msg_text=' || l_msg_text);
1166: END IF;

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

1160: );
1161:
1162: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || SUBSTRB(l_msg_name, 1,30));
1163: IF (l_debug = 1) THEN
1164: INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || l_msg_name);
1165: INV_ITEM_MSG.Debug(Mctx, 'l_msg_text=' || l_msg_text);
1166: END IF;
1167: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_text_length=' || TO_CHAR( LENGTH(l_msg_text) ));
1168: END;

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

1161:
1162: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || SUBSTRB(l_msg_name, 1,30));
1163: IF (l_debug = 1) THEN
1164: INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || l_msg_name);
1165: INV_ITEM_MSG.Debug(Mctx, 'l_msg_text=' || l_msg_text);
1166: END IF;
1167: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_text_length=' || TO_CHAR( LENGTH(l_msg_text) ));
1168: END;
1169:

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

1163: IF (l_debug = 1) THEN
1164: INV_ITEM_MSG.Debug(Mctx, 'l_msg_name=' || l_msg_name);
1165: INV_ITEM_MSG.Debug(Mctx, 'l_msg_text=' || l_msg_text);
1166: END IF;
1167: -- INV_ITEM_MSG.Debug(Mctx, 'l_msg_text_length=' || TO_CHAR( LENGTH(l_msg_text) ));
1168: END;
1169:
1170: END LOOP; -- loop through the messages
1171: */

Line 1184: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type before update'|| l_transaction_type);

1180: RAISE Processing_Error;
1181: END IF;
1182: --* Code added for Bug #3991044
1183:
1184: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type before update'|| l_transaction_type);
1185:
1186: ELSIF ( l_transaction_type = 'UPDATE' ) THEN
1187: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type inside update'|| l_transaction_type);
1188: IF (l_debug = 1) THEN

Line 1187: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type inside update'|| l_transaction_type);

1183:
1184: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type before update'|| l_transaction_type);
1185:
1186: ELSIF ( l_transaction_type = 'UPDATE' ) THEN
1187: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type inside update'|| l_transaction_type);
1188: IF (l_debug = 1) THEN
1189: INV_ITEM_MSG.Debug(Mctx, 'calling INV_ITEM_CATEGORY_PVT.Update_Category_Assignment');
1190: END IF;
1191:

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

1185:
1186: ELSIF ( l_transaction_type = 'UPDATE' ) THEN
1187: INV_ITEM_MSG.Debug(Mctx, 'Value for l_transaction_type inside update'|| l_transaction_type);
1188: IF (l_debug = 1) THEN
1189: INV_ITEM_MSG.Debug(Mctx, 'calling INV_ITEM_CATEGORY_PVT.Update_Category_Assignment');
1190: END IF;
1191:
1192: l_return_status := fnd_api.g_RET_STS_SUCCESS;
1193:

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

1233: END;
1234: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1235: l_process_flag := 3;
1236: IF (l_debug = 1) THEN
1237: INV_ITEM_MSG.Debug(Mctx, 'error in Update_Category_Assignment ' || l_msg_data);
1238: END IF;
1239: l_RETCODE := G_WARNING;
1240: END IF;
1241: /* End of bug 5517473 */

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

1242: END IF; --Udex Catalog
1243: ELSE
1244: l_process_flag := 3;
1245: IF (l_debug = 1) THEN
1246: INV_ITEM_MSG.Debug(Mctx, 'error in Update_Category_Assignment. Msg count=' || TO_CHAR(INV_ITEM_MSG.Count_Msg));
1247: END IF;
1248: l_RETCODE := G_WARNING;
1249: END IF; -- l_return_status
1250: --* End of Bug #3991044

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

1256: IF ( l_process_flag = 7 ) THEN
1257: -- Sync item category assignment with item record in STAR.
1258:
1259: IF (l_debug = 1) THEN
1260: INV_ITEM_MSG.Debug(Mctx, 'calling Sync_Category_Assignments');
1261: END IF;
1262:
1263: -- Bug: 2718703 checking for ENI product before calling their package
1264: -- Start Bug: 3185516

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

1302: END IF; -- process_flag = 4 AND p_upload_rec_flag = 1
1303:
1304: -- Write all accumulated messages
1305: --
1306: INV_ITEM_MSG.Write_List (p_delete => TRUE);
1307:
1308: --
1309: -- Update the current interface record
1310: --

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

1309: -- Update the current interface record
1310: --
1311:
1312: IF (l_debug = 1) THEN
1313: INV_ITEM_MSG.Debug(Mctx, 'update interface record');
1314: END IF;
1315:
1316: UPDATE mtl_item_categories_interface
1317: SET

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

1447:
1448: IF ( p_delete_rec_flag = 1 ) THEN
1449:
1450: IF (l_debug = 1) THEN
1451: INV_ITEM_MSG.Debug(Mctx, 'calling delete_OI_records');
1452: END IF;
1453:
1454: INV_ITEM_CATEGORY_OI.delete_OI_records
1455: ( p_commit => l_commit

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

1457: , x_return_status => l_return_status
1458: );
1459:
1460: IF (l_debug = 1) THEN
1461: INV_ITEM_MSG.Debug(Mctx, 'done delete_OI_records: return_status=' || l_return_status);
1462: END IF;
1463:
1464: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1465: RAISE Processing_Error;

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

1465: RAISE Processing_Error;
1466: END IF;
1467:
1468: -- Write all accumulated messages
1469: INV_ITEM_MSG.Write_List (p_delete => TRUE);
1470:
1471: END IF; -- p_delete_rec_flag = 1
1472:
1473: --

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

1489: RETCODE := G_ERROR;
1490: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_ICOI_FAILURE');
1491:
1492: -- Write all accumulated messages
1493: INV_ITEM_MSG.Write_List (p_delete => TRUE);
1494:
1495: -- Check of commit
1496: IF ( FND_API.To_Boolean(l_commit) ) THEN
1497: COMMIT WORK;

Line 1506: INV_ITEM_MSG.Add_Message

1502: ERRBUF := FND_MESSAGE.Get_String('INV', 'INV_ICOI_FAILURE');
1503:
1504: l_err_text := SUBSTRB(SQLERRM, 1,240);
1505:
1506: INV_ITEM_MSG.Add_Message
1507: ( p_Msg_Name => 'INV_ITEM_UNEXPECTED_ERROR'
1508: , p_token1 => 'PKG_NAME'
1509: , p_value1 => G_PKG_NAME
1510: , p_token2 => 'PROCEDURE_NAME'

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

1514: , p_transaction_id => l_transaction_id
1515: );
1516:
1517: -- Write all accumulated messages
1518: INV_ITEM_MSG.Write_List (p_delete => TRUE);
1519:
1520: -- Check of commit
1521: IF ( FND_API.To_Boolean(l_commit) ) THEN
1522: COMMIT WORK;

Line 1550: Mctx INV_ITEM_MSG.Msg_Ctx_type;

1546: , x_return_status OUT NOCOPY VARCHAR2
1547: )
1548: IS
1549: l_api_name CONSTANT VARCHAR2(30) := 'delete_OI_records';
1550: Mctx INV_ITEM_MSG.Msg_Ctx_type;
1551:
1552: l_del_process_flag NUMBER := 7; -- process_flag value for records to be deleted
1553: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1554: BEGIN

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

1556: Mctx.Package_Name := G_PKG_NAME;
1557: Mctx.Procedure_Name := l_api_name;
1558:
1559: IF (l_debug = 1) THEN
1560: INV_ITEM_MSG.Debug(Mctx, 'begin');
1561: END IF;
1562:
1563: -- Initialize API return status to success
1564: x_return_status := FND_API.g_RET_STS_SUCCESS;

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

1570: AND rownum < G_ROWS_TO_COMMIT;
1571:
1572: EXIT WHEN SQL%NOTFOUND;
1573:
1574: --INV_ITEM_MSG.Debug(Mctx, 'deleted ' || TO_CHAR(SQL%ROWCOUNT) || ' record(s)');
1575:
1576: -- Check of commit
1577: IF ( FND_API.To_Boolean(p_commit) ) THEN
1578: COMMIT WORK;

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

1584:
1585: WHEN others THEN
1586: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1587:
1588: INV_ITEM_MSG.Add_Unexpected_Error (Mctx, SQLERRM);
1589:
1590: -- Check of commit
1591: IF ( FND_API.To_Boolean(p_commit) ) THEN
1592: COMMIT WORK;