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 305: l_return_status VARCHAR2(1); -- := fnd_api.g_MISS_CHAR

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

Line 422: l_commit := fnd_api.g_TRUE;

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
424: l_commit := fnd_api.g_FALSE;
425: END IF;
426:

Line 424: l_commit := fnd_api.g_FALSE;

420:
421: IF ( p_commit_flag = 1 ) THEN
422: l_commit := fnd_api.g_TRUE;
423: ELSE
424: l_commit := fnd_api.g_FALSE;
425: END IF;
426:
427: l_RETCODE := G_SUCCESS;
428:

Line 482: l_token := fnd_api.g_MISS_CHAR;

478:
479: IF ( cr.organization_id IS NULL ) THEN
480: IF ( cr.organization_code IS NULL ) THEN
481: l_msg_name := 'INV_ICOI_MISS_ORG_CODE';
482: l_token := fnd_api.g_MISS_CHAR;
483: l_token_value := cr.organization_code;
484: ELSE
485: l_msg_name := 'INV_ICOI_INVALID_ORG_CODE';
486: l_token := 'VALUE';

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

506:
507: END LOOP; -- miss_org_id_csr
508:
509: -- Check of commit
510: IF ( FND_API.To_Boolean(l_commit) ) THEN
511: COMMIT WORK;
512: END IF;
513:
514: -- Write all accumulated messages

Line 553: l_return_status := fnd_api.g_RET_STS_SUCCESS;

549: --
550: -- Validate transaction_type
551: --
552:
553: l_return_status := fnd_api.g_RET_STS_SUCCESS;
554:
555: l_transaction_type := UPPER(icoi_rec.transaction_type);
556:
557: --*Included UPDATE trans type for Bug #3991044

Line 559: l_return_status := fnd_api.g_RET_STS_ERROR;

555: l_transaction_type := UPPER(icoi_rec.transaction_type);
556:
557: --*Included UPDATE trans type for Bug #3991044
558: IF ( l_transaction_type NOT IN ('CREATE', 'DELETE','UPDATE', 'SYNC') ) THEN
559: l_return_status := fnd_api.g_RET_STS_ERROR;
560: l_process_flag := 3;
561:
562: l_RETCODE := G_WARNING;
563:

Line 565: l_token := fnd_api.g_MISS_CHAR;

561:
562: l_RETCODE := G_WARNING;
563:
564: l_msg_name := 'INV_ICOI_INVALID_TRANSACT_TYPE';
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

Line 583: l_return_status := fnd_api.g_RET_STS_SUCCESS;

579: --
580: -- Assign missing category_set_id from category_set_name
581: --
582:
583: l_return_status := fnd_api.g_RET_STS_SUCCESS;
584:
585: l_category_set_id := icoi_rec.category_set_id;
586:
587: IF ( l_category_set_id IS NULL ) THEN

Line 598: l_return_status := fnd_api.g_RET_STS_ERROR;

594: OPEN category_set_name_csr
595: ( p_category_set_name => icoi_rec.category_set_name );
596: FETCH category_set_name_csr INTO l_category_set_id, l_structure_id;
597: IF ( category_set_name_csr%NOTFOUND ) THEN
598: l_return_status := fnd_api.g_RET_STS_ERROR;
599: l_category_set_id := NULL;
600: l_msg_name := 'INV_ICOI_INVALID_CAT_SET_NAME';
601: l_token := 'VALUE';
602: l_token_value := icoi_rec.category_set_name;

Line 607: l_return_status := fnd_api.g_RET_STS_ERROR;

603: l_column_name := 'CATEGORY_SET_NAME';
604: END IF;
605: CLOSE category_set_name_csr;
606: ELSE
607: l_return_status := fnd_api.g_RET_STS_ERROR;
608: l_msg_name := 'INV_ICOI_MISS_CAT_SET_NAME';
609: l_token := fnd_api.g_MISS_CHAR;
610: l_token_value := icoi_rec.category_set_name;
611: l_column_name := 'CATEGORY_SET_NAME';

Line 609: l_token := fnd_api.g_MISS_CHAR;

605: CLOSE category_set_name_csr;
606: ELSE
607: l_return_status := fnd_api.g_RET_STS_ERROR;
608: l_msg_name := 'INV_ICOI_MISS_CAT_SET_NAME';
609: l_token := fnd_api.g_MISS_CHAR;
610: l_token_value := icoi_rec.category_set_name;
611: l_column_name := 'CATEGORY_SET_NAME';
612: END IF;
613:

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

619: --l_column_name := 'CATEGORY_SET_ID';
620:
621: END IF; -- category_set_id
622:
623: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
624: l_process_flag := 3;
625:
626: l_RETCODE := G_WARNING;
627:

Line 643: l_return_status := fnd_api.g_RET_STS_SUCCESS;

639: --
640: -- Assign missing old_category_id from old_category_name
641: --
642:
643: l_return_status := fnd_api.g_RET_STS_SUCCESS;
644:
645: l_old_category_id := icoi_rec.old_category_id;
646:
647:

Line 670: l_return_status := fnd_api.g_RET_STS_ERROR;

666: WHERE category_set_id = l_category_set_id )
667: AND Concatenated_Segments = icoi_rec.old_category_name;
668: EXCEPTION
669: WHEN NO_DATA_FOUND THEN
670: l_return_status := fnd_api.g_RET_STS_ERROR;
671: l_msg_name := 'INV_ICOI_INVALID_CAT_NAME';
672: l_token := 'VALUE';
673: l_token_value := icoi_rec.old_category_name;
674: l_column_name := 'CATEGORY_NAME';

Line 678: l_return_status := fnd_api.g_ret_sts_error;

674: l_column_name := 'CATEGORY_NAME';
675: END;
676: ELSE
677: IF l_transaction_type = 'UPDATE' THEN
678: l_return_status := fnd_api.g_ret_sts_error;
679: l_msg_name := 'INV_ICOI_MISS_CAT_NAME';
680: l_token := fnd_api.G_MISS_CHAR;
681: l_token_value := icoi_rec.old_category_name;
682: l_column_name := 'CATEGORY_NAME';

Line 680: l_token := fnd_api.G_MISS_CHAR;

676: ELSE
677: IF l_transaction_type = 'UPDATE' THEN
678: l_return_status := fnd_api.g_ret_sts_error;
679: l_msg_name := 'INV_ICOI_MISS_CAT_NAME';
680: l_token := fnd_api.G_MISS_CHAR;
681: l_token_value := icoi_rec.old_category_name;
682: l_column_name := 'CATEGORY_NAME';
683: END IF;
684: END IF; --Old Category Name not null

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

683: END IF;
684: END IF; --Old Category Name not null
685: END IF; -- category_id
686:
687: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
688: l_process_flag := 3;
689:
690: l_RETCODE := G_WARNING;
691:

Line 706: l_return_status := fnd_api.g_RET_STS_SUCCESS;

702: --
703: -- Assign missing category_id from category_name
704: --
705:
706: l_return_status := fnd_api.g_RET_STS_SUCCESS;
707:
708: l_category_id := icoi_rec.category_id;
709:
710: -- The category_set_id must be known at this point

Line 746: l_return_status := fnd_api.g_RET_STS_ERROR;

742: AND structure_id = l_structure_id
743: AND NVL(disable_date,SYSDATE+1) > SYSDATE;
744: EXCEPTION
745: WHEN NO_DATA_FOUND THEN
746: l_return_status := fnd_api.g_RET_STS_ERROR;
747: l_msg_name := 'INV_ICOI_INVALID_CAT_NAME';
748: l_token := 'VALUE';
749: l_token_value := icoi_rec.category_name;
750: l_column_name := 'CATEGORY_NAME';

Line 754: l_return_status := fnd_api.g_RET_STS_ERROR;

750: l_column_name := 'CATEGORY_NAME';
751: END;
752: -- END IF;
753: ELSE
754: l_return_status := fnd_api.g_RET_STS_ERROR;
755: l_msg_name := 'INV_ICOI_MISS_CAT_NAME';
756: l_token := fnd_api.g_MISS_CHAR;
757: l_token_value := icoi_rec.category_name;
758: l_column_name := 'CATEGORY_NAME';

Line 756: l_token := fnd_api.g_MISS_CHAR;

752: -- END IF;
753: ELSE
754: l_return_status := fnd_api.g_RET_STS_ERROR;
755: l_msg_name := 'INV_ICOI_MISS_CAT_NAME';
756: l_token := fnd_api.g_MISS_CHAR;
757: l_token_value := icoi_rec.category_name;
758: l_column_name := 'CATEGORY_NAME';
759: END IF;
760:

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

766: --l_column_name := 'CATEGORY_ID';
767:
768: END IF; -- category_id
769:
770: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
771: l_process_flag := 3;
772:
773: l_RETCODE := G_WARNING;
774:

Line 788: l_return_status := fnd_api.g_RET_STS_SUCCESS;

784: --
785: -- Assign missing inventory_item_id from item_number
786: --
787:
788: l_return_status := fnd_api.g_RET_STS_SUCCESS;
789:
790: l_inventory_item_id := icoi_rec.inventory_item_id;
791:
792: IF ( l_inventory_item_id IS NULL ) THEN

Line 825: l_return_status := fnd_api.g_RET_STS_ERROR;

821: CLOSE msii_item_number_csr;
822: END IF;
823:
824: IF ( l_inventory_item_id IS NULL ) THEN
825: l_return_status := fnd_api.g_RET_STS_ERROR;
826: l_msg_name := 'INV_ICOI_INVALID_ITEM_NUMBER';
827: l_token := 'VALUE';
828: l_token_value := icoi_rec.item_number;
829: l_column_name := 'ITEM_NUMBER';

Line 833: l_return_status := fnd_api.g_RET_STS_ERROR;

829: l_column_name := 'ITEM_NUMBER';
830: END IF;
831:
832: ELSE
833: l_return_status := fnd_api.g_RET_STS_ERROR;
834: l_msg_name := 'INV_ICOI_MISS_ITEM_NUMBER';
835: l_token := fnd_api.g_MISS_CHAR;
836: l_token_value := icoi_rec.item_number;
837: l_column_name := 'ITEM_NUMBER';

Line 835: l_token := fnd_api.g_MISS_CHAR;

831:
832: ELSE
833: l_return_status := fnd_api.g_RET_STS_ERROR;
834: l_msg_name := 'INV_ICOI_MISS_ITEM_NUMBER';
835: l_token := fnd_api.g_MISS_CHAR;
836: l_token_value := icoi_rec.item_number;
837: l_column_name := 'ITEM_NUMBER';
838: END IF;
839:

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

845: --l_column_name := 'INVENTORY_ITEM_ID';
846:
847: END IF; -- inventory_item_id
848:
849: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
850: l_process_flag := 3;
851:
852: l_RETCODE := G_WARNING;
853:

Line 864: l_return_status := fnd_api.g_RET_STS_SUCCESS;

860: );
861:
862: END IF;
863:
864: l_return_status := fnd_api.g_RET_STS_SUCCESS;
865:
866: -- Security check to be skipped for defaulted records bug 6456493
867: IF ( icoi_rec.created_by <> -99 ) THEN
868: l_has_privilege := INV_EGO_REVISION_VALIDATE.check_data_security(

Line 874: l_return_status := fnd_api.g_RET_STS_ERROR;

870: ,p_object_name => 'EGO_CATEGORY_SET'
871: ,p_instance_pk1_value => l_category_set_id
872: ,P_User_Id => g_User_id);
873: IF l_has_privilege <> 'T' THEN
874: l_return_status := fnd_api.g_RET_STS_ERROR;
875: l_msg_name := 'INV_IOI_NOT_CATEGORY_USER';
876: l_token := fnd_api.g_MISS_CHAR;
877: l_token_value := icoi_rec.category_set_name;
878: l_column_name := 'CATEGORY_SET_NAME';

Line 876: l_token := fnd_api.g_MISS_CHAR;

872: ,P_User_Id => g_User_id);
873: IF l_has_privilege <> 'T' THEN
874: l_return_status := fnd_api.g_RET_STS_ERROR;
875: l_msg_name := 'INV_IOI_NOT_CATEGORY_USER';
876: l_token := fnd_api.g_MISS_CHAR;
877: l_token_value := icoi_rec.category_set_name;
878: l_column_name := 'CATEGORY_SET_NAME';
879: END IF;
880:

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

877: l_token_value := icoi_rec.category_set_name;
878: l_column_name := 'CATEGORY_SET_NAME';
879: END IF;
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

Line 919: l_return_status := fnd_api.g_RET_STS_SUCCESS;

915: END IF;
916:
917: IF p_upload_rec_flag = 1 THEN
918: --Start: Check for data security and user privileges
919: l_return_status := fnd_api.g_RET_STS_SUCCESS;
920:
921: IF ( icoi_rec.created_by <> -99 ) THEN
922: l_has_privilege := INV_EGO_REVISION_VALIDATE.check_data_security(
923: p_function => 'EGO_EDIT_ITEM_CAT_ASSIGNMENTS'

Line 930: l_return_status := fnd_api.g_RET_STS_ERROR;

926: ,p_instance_pk2_value => l_organization_id
927: ,P_User_Id => g_User_id);
928:
929: IF l_has_privilege <> 'T' THEN
930: l_return_status := fnd_api.g_RET_STS_ERROR;
931: l_msg_name := 'INV_IOI_ITEM_UPDATE_PRIV';
932:
933: --Bug: 5522789 Tokenise the message to display item number.
934: l_token := 'VALUE';

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

945:
946: l_column_name := 'ITEM_NUMBER';
947: END IF; -- has privilege
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

Line 986: , p_init_msg_list => fnd_api.g_TRUE

982:
983: INV_ITEM_CATEGORY_PVT.Delete_Category_Assignment
984: (
985: p_api_version => 1.0
986: , p_init_msg_list => fnd_api.g_TRUE
987: , p_commit => fnd_api.g_FALSE
988: , p_inventory_item_id => l_inventory_item_id
989: , p_organization_id => l_organization_id
990: , p_category_set_id => l_category_set_id

Line 987: , p_commit => fnd_api.g_FALSE

983: INV_ITEM_CATEGORY_PVT.Delete_Category_Assignment
984: (
985: p_api_version => 1.0
986: , p_init_msg_list => fnd_api.g_TRUE
987: , p_commit => fnd_api.g_FALSE
988: , p_inventory_item_id => l_inventory_item_id
989: , p_organization_id => l_organization_id
990: , p_category_set_id => l_category_set_id
991: , p_category_id => l_category_id

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

994: , x_msg_count => l_msg_count
995: , x_msg_data => l_msg_data
996: );
997:
998: IF ( l_return_status = fnd_api.g_RET_STS_SUCCESS ) THEN
999: l_process_flag := 7;
1000: ELSE
1001: l_process_flag := 3;
1002:

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

1008:
1009: END IF; -- l_return_status
1010:
1011: -- If unexpected error in Delete_Category_Assignment API, stop the processing
1012: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1013: l_RETCODE := G_ERROR;
1014: RAISE Processing_Error;
1015: END IF;
1016:

Line 1026: , p_init_msg_list => fnd_api.g_TRUE

1022:
1023: INV_ITEM_CATEGORY_PVT.Create_Category_Assignment
1024: (
1025: p_api_version => 1.0
1026: , p_init_msg_list => fnd_api.g_TRUE
1027: , p_commit => fnd_api.g_FALSE
1028: , p_validation_level => INV_ITEM_CATEGORY_PVT.g_VALIDATE_IDS
1029: , p_inventory_item_id => l_inventory_item_id
1030: , p_organization_id => l_organization_id

Line 1027: , p_commit => fnd_api.g_FALSE

1023: INV_ITEM_CATEGORY_PVT.Create_Category_Assignment
1024: (
1025: p_api_version => 1.0
1026: , p_init_msg_list => fnd_api.g_TRUE
1027: , p_commit => fnd_api.g_FALSE
1028: , p_validation_level => INV_ITEM_CATEGORY_PVT.g_VALIDATE_IDS
1029: , p_inventory_item_id => l_inventory_item_id
1030: , p_organization_id => l_organization_id
1031: , p_category_set_id => l_category_set_id

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

1037: , x_msg_count => l_msg_count
1038: , x_msg_data => l_msg_data
1039: );
1040:
1041: IF ( l_return_status = fnd_api.g_RET_STS_SUCCESS ) THEN
1042: l_process_flag := 7;
1043: IF ( l_gpc_catalog_id = l_category_set_id) THEN
1044: -- Bug 5517473 removing the call to process_cat_assignment it is same as update_reg_pub_update_dates
1045: BEGIN

Line 1050: p_commit => FND_API.G_FALSE,

1046: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES
1047: (p_inventory_item_id => l_inventory_item_id,
1048: p_organization_id => l_organization_id,
1049: p_update_reg => 'Y',
1050: p_commit => FND_API.G_FALSE,
1051: x_return_status => l_return_status,
1052: x_msg_count => l_msg_count,
1053: x_msg_data => l_msg_data);
1054: EXCEPTION

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

1054: EXCEPTION
1055: WHEN others THEN
1056: l_msg_data := SQLERRM;
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;

Line 1092: , p_encoded => FND_API.g_TRUE

1088: l_msg_text VARCHAR2(2000);
1089: BEGIN
1090: l_msg_data := FND_MSG_PUB.Get
1091: ( p_msg_index => idx
1092: , p_encoded => FND_API.g_TRUE
1093: );
1094:
1095: FND_MESSAGE.Parse_Encoded
1096: ( encoded_message => l_msg_data

Line 1102: , p_encoded => FND_API.g_FALSE

1098: , message_name => l_msg_name
1099: );
1100:
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

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

1117:
1118: -- If unexpected error in Create_Category_Assignment API,
1119: -- stop the processing.
1120:
1121: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1122: l_RETCODE := G_ERROR;
1123: RAISE Processing_Error;
1124: END IF;
1125: --* Code added for Bug #3991044

Line 1131: l_return_status := fnd_api.g_RET_STS_SUCCESS;

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:
1133: INV_ITEM_CATEGORY_PVT.Update_Category_Assignment
1134: ( p_api_version => 1.0
1135: , p_init_msg_list => fnd_api.g_TRUE

Line 1135: , p_init_msg_list => fnd_api.g_TRUE

1131: l_return_status := fnd_api.g_RET_STS_SUCCESS;
1132:
1133: INV_ITEM_CATEGORY_PVT.Update_Category_Assignment
1134: ( p_api_version => 1.0
1135: , p_init_msg_list => fnd_api.g_TRUE
1136: , p_commit => fnd_api.g_FALSE
1137: , p_inventory_item_id => l_inventory_item_id
1138: , p_organization_id => l_organization_id
1139: , p_category_set_id => l_category_set_id

Line 1136: , p_commit => fnd_api.g_FALSE

1132:
1133: INV_ITEM_CATEGORY_PVT.Update_Category_Assignment
1134: ( p_api_version => 1.0
1135: , p_init_msg_list => fnd_api.g_TRUE
1136: , p_commit => fnd_api.g_FALSE
1137: , p_inventory_item_id => l_inventory_item_id
1138: , p_organization_id => l_organization_id
1139: , p_category_set_id => l_category_set_id
1140: , p_category_id => l_category_id

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

1144: , x_msg_count => l_msg_count
1145: , x_msg_data => l_msg_data
1146: );
1147:
1148: IF ( l_return_status = fnd_api.g_RET_STS_SUCCESS ) THEN
1149: l_process_flag := 7;
1150: IF ( l_udex_catalog_id = l_category_set_id
1151: OR l_gpc_catalog_id = l_category_set_id) THEN
1152: -- Bug 5517473 removing the call to process_cat_assignment it is same as update_reg_pub_update_dates

Line 1165: p_commit => FND_API.G_FALSE,

1161: EGO_GTIN_PVT.UPDATE_REG_PUB_UPDATE_DATES
1162: (p_inventory_item_id => l_inventory_item_id,
1163: p_organization_id => l_organization_id,
1164: p_update_reg => 'Y',
1165: p_commit => FND_API.G_FALSE,
1166: x_return_status => l_return_status,
1167: x_msg_count => l_msg_count,
1168: x_msg_data => l_msg_data);
1169: EXCEPTION

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

1169: EXCEPTION
1170: WHEN others THEN
1171: l_msg_data := SQLERRM;
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;

Line 1207: ,p_init_msg_list => FND_API.g_TRUE

1203: -- Start Bug: 3185516
1204: IF ( l_transaction_type = 'CREATE' ) THEN
1205: INV_ENI_ITEMS_STAR_PKG.Sync_Category_Assignments(
1206: p_api_version => 1.0
1207: ,p_init_msg_list => FND_API.g_TRUE
1208: ,p_inventory_item_id => l_inventory_item_id
1209: ,p_organization_id => l_organization_id
1210: ,p_category_set_id => l_category_set_id
1211: ,p_old_category_id => NULL

Line 1219: ,p_init_msg_list => FND_API.g_TRUE

1215: ,x_msg_data => l_msg_data);
1216: ELSIF( l_transaction_type = 'DELETE' ) THEN
1217: INV_ENI_ITEMS_STAR_PKG.Sync_Category_Assignments(
1218: p_api_version => 1.0
1219: ,p_init_msg_list => FND_API.g_TRUE
1220: ,p_inventory_item_id => l_inventory_item_id
1221: ,p_organization_id => l_organization_id
1222: ,p_category_set_id => l_category_set_id
1223: ,p_old_category_id => l_category_id

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

1230: -- End Bug: 3185516
1231: -- If unexpected error in Sync_Category_Assignments,
1232: -- stop the processing.
1233:
1234: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1235: l_RETCODE := G_ERROR;
1236: RAISE Processing_Error;
1237: END IF;
1238:

Line 1296: ,p_init_msg_list => FND_API.g_TRUE

1292: IF l_records_updated = 'Y' THEN
1293: BEGIN
1294: INV_ENI_ITEMS_STAR_PKG.Sync_Star_ItemCatg_From_COI(
1295: p_api_version => 1.0
1296: ,p_init_msg_list => FND_API.g_TRUE
1297: ,p_set_process_id => g_xset_id
1298: ,x_return_status => l_return_Status
1299: ,x_msg_count => l_msg_count
1300: ,x_msg_data => l_msg_data);

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

1301: -- End Bug: 3185516
1302: -- If unexpected error in Sync_Star_ItemCatg_From_COI,
1303: -- stop the processing.
1304: /*Bug 4569555
1305: IF ( l_return_status = fnd_api.g_RET_STS_UNEXP_ERROR ) THEN
1306: l_RETCODE := G_ERROR;
1307: RAISE Processing_Error;
1308: END IF;*/
1309: END;

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

1373: END IF;
1374: --R12: Business Event Enhancement
1375:
1376: -- Check of commit
1377: IF ( FND_API.To_Boolean( l_commit ) ) THEN
1378: COMMIT WORK;
1379: -- Call IP Intermedia Sync
1380: INV_ITEM_EVENTS_PVT.Sync_IP_IM_Index;
1381: END IF;

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

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;
1405: END IF;
1406:
1407: -- Write all accumulated messages

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

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;
1437: END IF;
1438:
1439: WHEN others THEN

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

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;
1462: END IF;
1463:
1464: END process_Item_Category_records;

Line 1483: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

1479: ------------------------------ delete_OI_records -----------------------------
1480:
1481: PROCEDURE delete_OI_records
1482: (
1483: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
1484: , p_rec_set_id IN NUMBER
1485: , x_return_status OUT NOCOPY VARCHAR2
1486: )
1487: IS

Line 1503: x_return_status := FND_API.g_RET_STS_SUCCESS;

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;
1504:
1505: LOOP
1506: DELETE FROM mtl_item_categories_interface
1507: WHERE set_process_id = p_rec_set_id

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

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;
1518: END IF;
1519:
1520: END LOOP;

Line 1525: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;

1521:
1522: EXCEPTION
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

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

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;
1532: END IF;
1533:
1534: END delete_OI_records;