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 FND_API

Line 308: l_return_status VARCHAR2(1); -- := fnd_api.g_MISS_CHAR

304: ret_code NUMBER := 0;
305: l_err_text VARCHAR2(2000);
306:
307: l_commit VARCHAR2(1);
308: l_return_status VARCHAR2(1); -- := fnd_api.g_MISS_CHAR
309: l_return_status_flag NUMBER;
310: l_msg_count NUMBER;
311: l_msg_data VARCHAR2(2000);
312:

Line 429: l_commit := fnd_api.g_TRUE;

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
431: l_commit := fnd_api.g_FALSE;
432: END IF;
433:

Line 431: l_commit := fnd_api.g_FALSE;

427:
428: IF ( p_commit_flag = 1 ) THEN
429: l_commit := fnd_api.g_TRUE;
430: ELSE
431: l_commit := fnd_api.g_FALSE;
432: END IF;
433:
434: l_RETCODE := G_SUCCESS;
435:

Line 489: l_token := fnd_api.g_MISS_CHAR;

485:
486: IF ( cr.organization_id IS NULL ) THEN
487: IF ( cr.organization_code IS NULL ) THEN
488: l_msg_name := 'INV_ICOI_MISS_ORG_CODE';
489: l_token := fnd_api.g_MISS_CHAR;
490: l_token_value := cr.organization_code;
491: ELSE
492: l_msg_name := 'INV_ICOI_INVALID_ORG_CODE';
493: l_token := 'VALUE';

Line 517: IF ( FND_API.To_Boolean(l_commit) ) THEN

513:
514: END LOOP; -- miss_org_id_csr
515:
516: -- Check of commit
517: IF ( FND_API.To_Boolean(l_commit) ) THEN
518: COMMIT WORK;
519: END IF;
520:
521: -- Write all accumulated messages

Line 560: l_return_status := fnd_api.g_RET_STS_SUCCESS;

556: --
557: -- Validate transaction_type
558: --
559:
560: l_return_status := fnd_api.g_RET_STS_SUCCESS;
561:
562: l_transaction_type := UPPER(icoi_rec.transaction_type);
563:
564: --*Included UPDATE trans type for Bug #3991044

Line 566: l_return_status := fnd_api.g_RET_STS_ERROR;

562: l_transaction_type := UPPER(icoi_rec.transaction_type);
563:
564: --*Included UPDATE trans type for Bug #3991044
565: IF ( l_transaction_type NOT IN ('CREATE', 'DELETE','UPDATE', 'SYNC') ) THEN
566: l_return_status := fnd_api.g_RET_STS_ERROR;
567: l_process_flag := 3;
568:
569: l_RETCODE := G_WARNING;
570:

Line 572: l_token := fnd_api.g_MISS_CHAR;

568:
569: l_RETCODE := G_WARNING;
570:
571: l_msg_name := 'INV_ICOI_INVALID_TRANSACT_TYPE';
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

Line 590: l_return_status := fnd_api.g_RET_STS_SUCCESS;

586: --
587: -- Assign missing category_set_id from category_set_name
588: --
589:
590: l_return_status := fnd_api.g_RET_STS_SUCCESS;
591:
592: l_category_set_id := icoi_rec.category_set_id;
593:
594: IF ( l_category_set_id IS NULL ) THEN

Line 605: l_return_status := fnd_api.g_RET_STS_ERROR;

601: OPEN category_set_name_csr
602: ( p_category_set_name => icoi_rec.category_set_name );
603: FETCH category_set_name_csr INTO l_category_set_id, l_structure_id;
604: IF ( category_set_name_csr%NOTFOUND ) THEN
605: l_return_status := fnd_api.g_RET_STS_ERROR;
606: l_category_set_id := NULL;
607: l_msg_name := 'INV_ICOI_INVALID_CAT_SET_NAME';
608: l_token := 'VALUE';
609: l_token_value := icoi_rec.category_set_name;

Line 614: l_return_status := fnd_api.g_RET_STS_ERROR;

610: l_column_name := 'CATEGORY_SET_NAME';
611: END IF;
612: CLOSE category_set_name_csr;
613: ELSE
614: l_return_status := fnd_api.g_RET_STS_ERROR;
615: l_msg_name := 'INV_ICOI_MISS_CAT_SET_NAME';
616: l_token := fnd_api.g_MISS_CHAR;
617: l_token_value := icoi_rec.category_set_name;
618: l_column_name := 'CATEGORY_SET_NAME';

Line 616: l_token := fnd_api.g_MISS_CHAR;

612: CLOSE category_set_name_csr;
613: ELSE
614: l_return_status := fnd_api.g_RET_STS_ERROR;
615: l_msg_name := 'INV_ICOI_MISS_CAT_SET_NAME';
616: l_token := fnd_api.g_MISS_CHAR;
617: l_token_value := icoi_rec.category_set_name;
618: l_column_name := 'CATEGORY_SET_NAME';
619: END IF;
620:

Line 630: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN

626: --l_column_name := 'CATEGORY_SET_ID';
627:
628: END IF; -- category_set_id
629:
630: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
631: l_process_flag := 3;
632:
633: l_RETCODE := G_WARNING;
634:

Line 650: l_return_status := fnd_api.g_RET_STS_SUCCESS;

646: --
647: -- Assign missing old_category_id from old_category_name
648: --
649:
650: l_return_status := fnd_api.g_RET_STS_SUCCESS;
651:
652: l_old_category_id := icoi_rec.old_category_id;
653:
654:

Line 678: l_return_status := fnd_api.g_RET_STS_ERROR;

674: AND Concatenated_Segments = icoi_rec.old_category_name
675: AND NVL(disable_date,SYSDATE+1) > SYSDATE; -- fix bug 15949266
676: EXCEPTION
677: WHEN NO_DATA_FOUND THEN
678: l_return_status := fnd_api.g_RET_STS_ERROR;
679: l_msg_name := 'INV_ICOI_INVALID_CAT_NAME';
680: l_token := 'VALUE';
681: l_token_value := icoi_rec.old_category_name;
682: l_column_name := 'CATEGORY_NAME';

Line 686: l_return_status := fnd_api.g_ret_sts_error;

682: l_column_name := 'CATEGORY_NAME';
683: END;
684: ELSE
685: IF l_transaction_type = 'UPDATE' THEN
686: l_return_status := fnd_api.g_ret_sts_error;
687: l_msg_name := 'INV_ICOI_MISS_CAT_NAME';
688: l_token := fnd_api.G_MISS_CHAR;
689: l_token_value := icoi_rec.old_category_name;
690: l_column_name := 'CATEGORY_NAME';

Line 688: l_token := fnd_api.G_MISS_CHAR;

684: ELSE
685: IF l_transaction_type = 'UPDATE' THEN
686: l_return_status := fnd_api.g_ret_sts_error;
687: l_msg_name := 'INV_ICOI_MISS_CAT_NAME';
688: l_token := fnd_api.G_MISS_CHAR;
689: l_token_value := icoi_rec.old_category_name;
690: l_column_name := 'CATEGORY_NAME';
691: END IF;
692: END IF; --Old Category Name not null

Line 695: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN

691: END IF;
692: END IF; --Old Category Name not null
693: END IF; -- category_id
694:
695: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
696: l_process_flag := 3;
697:
698: l_RETCODE := G_WARNING;
699:

Line 714: l_return_status := fnd_api.g_RET_STS_SUCCESS;

710: --
711: -- Assign missing category_id from category_name
712: --
713:
714: l_return_status := fnd_api.g_RET_STS_SUCCESS;
715:
716: l_category_id := icoi_rec.category_id;
717:
718: -- The category_set_id must be known at this point

Line 755: l_return_status := fnd_api.g_RET_STS_ERROR;

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';
757: l_token := 'VALUE';
758: l_token_value := icoi_rec.category_name;
759: l_column_name := 'CATEGORY_NAME';

Line 763: l_return_status := fnd_api.g_RET_STS_ERROR;

759: l_column_name := 'CATEGORY_NAME';
760: END;
761: -- END IF;
762: ELSE
763: l_return_status := fnd_api.g_RET_STS_ERROR;
764: l_msg_name := 'INV_ICOI_MISS_CAT_NAME';
765: l_token := fnd_api.g_MISS_CHAR;
766: l_token_value := icoi_rec.category_name;
767: l_column_name := 'CATEGORY_NAME';

Line 765: l_token := fnd_api.g_MISS_CHAR;

761: -- END IF;
762: ELSE
763: l_return_status := fnd_api.g_RET_STS_ERROR;
764: l_msg_name := 'INV_ICOI_MISS_CAT_NAME';
765: l_token := fnd_api.g_MISS_CHAR;
766: l_token_value := icoi_rec.category_name;
767: l_column_name := 'CATEGORY_NAME';
768: END IF;
769:

Line 779: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN

775: --l_column_name := 'CATEGORY_ID';
776:
777: END IF; -- category_id
778:
779: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
780: l_process_flag := 3;
781:
782: l_RETCODE := G_WARNING;
783:

Line 797: l_return_status := fnd_api.g_RET_STS_SUCCESS;

793: --
794: -- Assign missing inventory_item_id from item_number
795: --
796:
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');

Line 835: l_return_status := fnd_api.g_RET_STS_ERROR;

831: CLOSE msii_item_number_csr;
832: END IF;
833:
834: IF ( l_inventory_item_id IS NULL ) THEN
835: l_return_status := fnd_api.g_RET_STS_ERROR;
836: l_msg_name := 'INV_ICOI_INVALID_ITEM_NUMBER';
837: l_token := 'VALUE';
838: l_token_value := icoi_rec.item_number;
839: l_column_name := 'ITEM_NUMBER';

Line 862: l_return_status := fnd_api.g_RET_STS_ERROR;

858: AND organization_code = icoi_rec.organization_code
859: AND process_flag IN (1));
860:
861: IF ( l_ItemNum_GenMethod <> 'F') THEN
862: l_return_status := fnd_api.g_RET_STS_ERROR;
863: l_msg_name := 'INV_ICOI_MISS_ITEM_NUMBER';
864: l_token := fnd_api.g_MISS_CHAR;
865: l_token_value := icoi_rec.item_number;
866: l_column_name := 'ITEM_NUMBER';

Line 864: l_token := fnd_api.g_MISS_CHAR;

860:
861: IF ( l_ItemNum_GenMethod <> 'F') THEN
862: l_return_status := fnd_api.g_RET_STS_ERROR;
863: l_msg_name := 'INV_ICOI_MISS_ITEM_NUMBER';
864: l_token := fnd_api.g_MISS_CHAR;
865: l_token_value := icoi_rec.item_number;
866: l_column_name := 'ITEM_NUMBER';
867: END IF;
868:

Line 886: l_return_status := fnd_api.g_RET_STS_ERROR;

882: WHERE inventory_item_id = l_inventory_item_id
883: AND organization_id = l_organization_id;
884: IF l_item_count = 0 THEN
885: l_inventory_item_id := null;
886: l_return_status := fnd_api.g_RET_STS_ERROR;
887: l_msg_name := 'INV_ORGITEM_ID_NOT_FOUND';
888: END IF;
889: END;
890: --END IF;

Line 899: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN

895: --l_column_name := 'INVENTORY_ITEM_ID';
896:
897: END IF; -- inventory_item_id
898:
899: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
900: l_process_flag := 3;
901:
902: l_RETCODE := G_WARNING;
903:

Line 914: l_return_status := fnd_api.g_RET_STS_SUCCESS;

910: );
911:
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

Line 925: l_return_status := fnd_api.g_RET_STS_ERROR;

921: ,p_object_name => 'EGO_CATEGORY_SET'
922: ,p_instance_pk1_value => l_category_set_id
923: ,P_User_Id => g_User_id);
924: IF l_has_privilege <> 'T' THEN
925: l_return_status := fnd_api.g_RET_STS_ERROR;
926: l_msg_name := 'INV_IOI_NOT_CATEGORY_USER';
927: l_token := fnd_api.g_MISS_CHAR;
928: l_token_value := icoi_rec.category_set_name;
929: l_column_name := 'CATEGORY_SET_NAME';

Line 927: l_token := fnd_api.g_MISS_CHAR;

923: ,P_User_Id => g_User_id);
924: IF l_has_privilege <> 'T' THEN
925: l_return_status := fnd_api.g_RET_STS_ERROR;
926: l_msg_name := 'INV_IOI_NOT_CATEGORY_USER';
927: l_token := fnd_api.g_MISS_CHAR;
928: l_token_value := icoi_rec.category_set_name;
929: l_column_name := 'CATEGORY_SET_NAME';
930: END IF;
931:

Line 932: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN

928: l_token_value := icoi_rec.category_set_name;
929: l_column_name := 'CATEGORY_SET_NAME';
930: END IF;
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

Line 972: l_return_status := fnd_api.g_RET_STS_SUCCESS;

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:
974: IF ( icoi_rec.created_by <> -99 ) THEN
975: l_has_privilege := INV_EGO_REVISION_VALIDATE.check_data_security(
976: p_function => 'EGO_EDIT_ITEM_CAT_ASSIGNMENTS'

Line 983: l_return_status := fnd_api.g_RET_STS_ERROR;

979: ,p_instance_pk2_value => l_organization_id
980: ,P_User_Id => g_User_id);
981:
982: IF l_has_privilege <> 'T' THEN
983: l_return_status := fnd_api.g_RET_STS_ERROR;
984: l_msg_name := 'INV_IOI_ITEM_UPDATE_PRIV';
985:
986: --Bug: 5522789 Tokenise the message to display item number.
987: l_token := 'VALUE';

Line 1002: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN

998:
999: l_column_name := 'ITEM_NUMBER';
1000: END IF; -- has privilege
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

Line 1043: , p_init_msg_list => fnd_api.g_TRUE

1039:
1040: INV_ITEM_CATEGORY_PVT.Delete_Category_Assignment
1041: (
1042: p_api_version => 1.0
1043: , p_init_msg_list => fnd_api.g_TRUE
1044: , p_commit => fnd_api.g_FALSE
1045: , p_inventory_item_id => l_inventory_item_id
1046: , p_organization_id => l_organization_id
1047: , p_category_set_id => l_category_set_id

Line 1044: , p_commit => fnd_api.g_FALSE

1040: INV_ITEM_CATEGORY_PVT.Delete_Category_Assignment
1041: (
1042: p_api_version => 1.0
1043: , p_init_msg_list => fnd_api.g_TRUE
1044: , p_commit => fnd_api.g_FALSE
1045: , p_inventory_item_id => l_inventory_item_id
1046: , p_organization_id => l_organization_id
1047: , p_category_set_id => l_category_set_id
1048: , p_category_id => l_category_id

Line 1055: IF ( l_return_status = fnd_api.g_RET_STS_SUCCESS ) THEN

1051: , x_msg_count => l_msg_count
1052: , x_msg_data => l_msg_data
1053: );
1054:
1055: IF ( l_return_status = fnd_api.g_RET_STS_SUCCESS ) THEN
1056: l_process_flag := 7;
1057: ELSE
1058: l_process_flag := 3;
1059:

Line 1069: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN

1065:
1066: END IF; -- l_return_status
1067:
1068: -- If unexpected error in Delete_Category_Assignment API, stop the processing
1069: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1070: l_RETCODE := G_ERROR;
1071: RAISE Processing_Error;
1072: END IF;
1073:

Line 1083: , p_init_msg_list => fnd_api.g_TRUE

1079:
1080: INV_ITEM_CATEGORY_PVT.Create_Category_Assignment
1081: (
1082: p_api_version => 1.0
1083: , p_init_msg_list => fnd_api.g_TRUE
1084: , p_commit => fnd_api.g_FALSE
1085: , p_validation_level => INV_ITEM_CATEGORY_PVT.g_VALIDATE_IDS
1086: , p_inventory_item_id => l_inventory_item_id
1087: , p_organization_id => l_organization_id

Line 1084: , p_commit => fnd_api.g_FALSE

1080: INV_ITEM_CATEGORY_PVT.Create_Category_Assignment
1081: (
1082: p_api_version => 1.0
1083: , p_init_msg_list => fnd_api.g_TRUE
1084: , p_commit => fnd_api.g_FALSE
1085: , p_validation_level => INV_ITEM_CATEGORY_PVT.g_VALIDATE_IDS
1086: , p_inventory_item_id => l_inventory_item_id
1087: , p_organization_id => l_organization_id
1088: , p_category_set_id => l_category_set_id

Line 1098: IF ( l_return_status = fnd_api.g_RET_STS_SUCCESS ) THEN

1094: , x_msg_count => l_msg_count
1095: , x_msg_data => l_msg_data
1096: );
1097:
1098: IF ( l_return_status = fnd_api.g_RET_STS_SUCCESS ) THEN
1099: l_process_flag := 7;
1100: IF ( l_gpc_catalog_id = l_category_set_id) THEN
1101: -- Bug 5517473 removing the call to process_cat_assignment it is same as update_reg_pub_update_dates
1102: BEGIN

Line 1107: p_commit => FND_API.G_FALSE,

1103: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES
1104: (p_inventory_item_id => l_inventory_item_id,
1105: p_organization_id => l_organization_id,
1106: p_update_reg => 'Y',
1107: p_commit => FND_API.G_FALSE,
1108: x_return_status => l_return_status,
1109: x_msg_count => l_msg_count,
1110: x_msg_data => l_msg_data);
1111: EXCEPTION

Line 1115: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN

1111: EXCEPTION
1112: WHEN others THEN
1113: l_msg_data := SQLERRM;
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;

Line 1149: , p_encoded => FND_API.g_TRUE

1145: l_msg_text VARCHAR2(2000);
1146: BEGIN
1147: l_msg_data := FND_MSG_PUB.Get
1148: ( p_msg_index => idx
1149: , p_encoded => FND_API.g_TRUE
1150: );
1151:
1152: FND_MESSAGE.Parse_Encoded
1153: ( encoded_message => l_msg_data

Line 1159: , p_encoded => FND_API.g_FALSE

1155: , message_name => l_msg_name
1156: );
1157:
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

Line 1178: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN

1174:
1175: -- If unexpected error in Create_Category_Assignment API,
1176: -- stop the processing.
1177:
1178: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1179: l_RETCODE := G_ERROR;
1180: RAISE Processing_Error;
1181: END IF;
1182: --* Code added for Bug #3991044

Line 1192: l_return_status := fnd_api.g_RET_STS_SUCCESS;

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:
1194: INV_ITEM_CATEGORY_PVT.Update_Category_Assignment
1195: ( p_api_version => 1.0
1196: , p_init_msg_list => fnd_api.g_TRUE

Line 1196: , p_init_msg_list => fnd_api.g_TRUE

1192: l_return_status := fnd_api.g_RET_STS_SUCCESS;
1193:
1194: INV_ITEM_CATEGORY_PVT.Update_Category_Assignment
1195: ( p_api_version => 1.0
1196: , p_init_msg_list => fnd_api.g_TRUE
1197: , p_commit => fnd_api.g_FALSE
1198: , p_inventory_item_id => l_inventory_item_id
1199: , p_organization_id => l_organization_id
1200: , p_category_set_id => l_category_set_id

Line 1197: , p_commit => fnd_api.g_FALSE

1193:
1194: INV_ITEM_CATEGORY_PVT.Update_Category_Assignment
1195: ( p_api_version => 1.0
1196: , p_init_msg_list => fnd_api.g_TRUE
1197: , p_commit => fnd_api.g_FALSE
1198: , p_inventory_item_id => l_inventory_item_id
1199: , p_organization_id => l_organization_id
1200: , p_category_set_id => l_category_set_id
1201: , p_category_id => l_category_id

Line 1209: IF ( l_return_status = fnd_api.g_RET_STS_SUCCESS ) THEN

1205: , x_msg_count => l_msg_count
1206: , x_msg_data => l_msg_data
1207: );
1208:
1209: IF ( l_return_status = fnd_api.g_RET_STS_SUCCESS ) THEN
1210: l_process_flag := 7;
1211: IF ( l_udex_catalog_id = l_category_set_id
1212: OR l_gpc_catalog_id = l_category_set_id) THEN
1213: -- Bug 5517473 removing the call to process_cat_assignment it is same as update_reg_pub_update_dates

Line 1226: p_commit => FND_API.G_FALSE,

1222: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES
1223: (p_inventory_item_id => l_inventory_item_id,
1224: p_organization_id => l_organization_id,
1225: p_update_reg => 'Y',
1226: p_commit => FND_API.G_FALSE,
1227: x_return_status => l_return_status,
1228: x_msg_count => l_msg_count,
1229: x_msg_data => l_msg_data);
1230: EXCEPTION

Line 1234: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN

1230: EXCEPTION
1231: WHEN others THEN
1232: l_msg_data := SQLERRM;
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;

Line 1268: ,p_init_msg_list => FND_API.g_TRUE

1264: -- Start Bug: 3185516
1265: IF ( l_transaction_type = 'CREATE' ) THEN
1266: INV_ENI_ITEMS_STAR_PKG.Sync_Category_Assignments(
1267: p_api_version => 1.0
1268: ,p_init_msg_list => FND_API.g_TRUE
1269: ,p_inventory_item_id => l_inventory_item_id
1270: ,p_organization_id => l_organization_id
1271: ,p_category_set_id => l_category_set_id
1272: ,p_old_category_id => NULL

Line 1280: ,p_init_msg_list => FND_API.g_TRUE

1276: ,x_msg_data => l_msg_data);
1277: ELSIF( l_transaction_type = 'DELETE' ) THEN
1278: INV_ENI_ITEMS_STAR_PKG.Sync_Category_Assignments(
1279: p_api_version => 1.0
1280: ,p_init_msg_list => FND_API.g_TRUE
1281: ,p_inventory_item_id => l_inventory_item_id
1282: ,p_organization_id => l_organization_id
1283: ,p_category_set_id => l_category_set_id
1284: ,p_old_category_id => l_category_id

Line 1295: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN

1291: -- End Bug: 3185516
1292: -- If unexpected error in Sync_Category_Assignments,
1293: -- stop the processing.
1294:
1295: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1296: l_RETCODE := G_ERROR;
1297: RAISE Processing_Error;
1298: END IF;
1299:

Line 1357: ,p_init_msg_list => FND_API.g_TRUE

1353: IF l_records_updated = 'Y' THEN
1354: BEGIN
1355: INV_ENI_ITEMS_STAR_PKG.Sync_Star_ItemCatg_From_COI(
1356: p_api_version => 1.0
1357: ,p_init_msg_list => FND_API.g_TRUE
1358: ,p_set_process_id => g_xset_id
1359: ,x_return_status => l_return_Status
1360: ,x_msg_count => l_msg_count
1361: ,x_msg_data => l_msg_data);

Line 1366: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN

1362: -- End Bug: 3185516
1363: -- If unexpected error in Sync_Star_ItemCatg_From_COI,
1364: -- stop the processing.
1365: /*Bug 4569555
1366: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1367: l_RETCODE := G_ERROR;
1368: RAISE Processing_Error;
1369: END IF;*/
1370: END;

Line 1438: IF ( FND_API.To_Boolean( l_commit ) ) THEN

1434: END IF;
1435: --R12: Business Event Enhancement
1436:
1437: -- Check of commit
1438: IF ( FND_API.To_Boolean( l_commit ) ) THEN
1439: COMMIT WORK;
1440: -- Call IP Intermedia Sync
1441: INV_ITEM_EVENTS_PVT.Sync_IP_IM_Index;
1442: END IF;

Line 1464: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN

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;
1466: END IF;
1467:
1468: -- Write all accumulated messages

Line 1496: IF ( FND_API.To_Boolean(l_commit) ) THEN

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;
1498: END IF;
1499:
1500: WHEN others THEN

Line 1521: IF ( FND_API.To_Boolean(l_commit) ) THEN

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;
1523: END IF;
1524:
1525: END process_Item_Category_records;

Line 1544: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

1540: ------------------------------ delete_OI_records -----------------------------
1541:
1542: PROCEDURE delete_OI_records
1543: (
1544: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
1545: , p_rec_set_id IN NUMBER
1546: , x_return_status OUT NOCOPY VARCHAR2
1547: )
1548: IS

Line 1564: x_return_status := FND_API.g_RET_STS_SUCCESS;

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;
1565:
1566: LOOP
1567: DELETE FROM mtl_item_categories_interface
1568: WHERE set_process_id = p_rec_set_id

Line 1577: IF ( FND_API.To_Boolean(p_commit) ) THEN

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;
1579: END IF;
1580:
1581: END LOOP;

Line 1586: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

1582:
1583: EXCEPTION
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

Line 1591: IF ( FND_API.To_Boolean(p_commit) ) THEN

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;
1593: END IF;
1594:
1595: END delete_OI_records;