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_GRP dependencies on INV_ITEM_GRP

Line 1: PACKAGE BODY INV_ITEM_GRP AS

1: PACKAGE BODY INV_ITEM_GRP AS
2: /* $Header: INVGITMB.pls 120.13.12020000.3 2012/07/26 07:07:47 gnookala ship $ */
3:
4: -- ------------------------------------------------------------
5: -- -------------- Global variables and constants --------------

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ITEM_GRP';

4: -- ------------------------------------------------------------
5: -- -------------- Global variables and constants --------------
6: -- ------------------------------------------------------------
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'INV_ITEM_GRP';
9:
10: g_Null_CHAR VARCHAR2(1) := NULL;
11: g_Null_NUM NUMBER := NULL;
12: g_Null_DATE DATE := NULL;

Line 454: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

450: PROCEDURE Insert_MSII_Row
451: (
452: p_commit IN VARCHAR2
453: , p_transaction_type IN VARCHAR2
454: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
455: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
456: , p_Template_Id IN NUMBER
457: , p_Template_Name IN VARCHAR2
458: , x_set_process_id OUT NOCOPY NUMBER

Line 455: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

451: (
452: p_commit IN VARCHAR2
453: , p_transaction_type IN VARCHAR2
454: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
455: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
456: , p_Template_Id IN NUMBER
457: , p_Template_Name IN VARCHAR2
458: , x_set_process_id OUT NOCOPY NUMBER
459: , x_return_status OUT NOCOPY VARCHAR2

Line 466: ,p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

462:
463: PROCEDURE Insert_Revision_Record
464: (
465: p_item_rowid IN ROWID
466: ,p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
467: ,p_set_process_id IN NUMBER
468: ,x_return_status OUT NOCOPY VARCHAR2
469: ,x_return_err OUT NOCOPY VARCHAR2
470: );

Line 477: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

473: (
474: p_transaction_type IN VARCHAR2
475: , p_commit IN VARCHAR2
476: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
477: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
478: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
479: , p_Template_Id IN NUMBER
480: , p_Template_Name IN VARCHAR2
481: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

Line 478: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

474: p_transaction_type IN VARCHAR2
475: , p_commit IN VARCHAR2
476: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
477: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
478: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
479: , p_Template_Id IN NUMBER
480: , p_Template_Name IN VARCHAR2
481: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
482: , x_return_status OUT NOCOPY VARCHAR2

Line 481: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

477: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
478: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
479: , p_Template_Id IN NUMBER
480: , p_Template_Name IN VARCHAR2
481: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
482: , x_return_status OUT NOCOPY VARCHAR2
483: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
484: -- Bug 9092888 - changes
485: , p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE DEFAULT NULL

Line 483: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

479: , p_Template_Id IN NUMBER
480: , p_Template_Name IN VARCHAR2
481: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
482: , x_return_status OUT NOCOPY VARCHAR2
483: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
484: -- Bug 9092888 - changes
485: , p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE DEFAULT NULL
486: , p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
487: -- Bug 9092888 - changes

Line 494: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

490: PROCEDURE Get_IOI_Errors
491: (
492: p_transaction_id IN NUMBER
493: , p_inventory_item_id IN NUMBER
494: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
495: , x_return_status OUT NOCOPY VARCHAR2
496: , x_return_err OUT NOCOPY VARCHAR2
497: );
498:

Line 743: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

739: PROCEDURE Create_Item
740: (
741: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
742: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
743: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
744: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
745: , x_return_status OUT NOCOPY VARCHAR2
746: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
747: , p_Template_Id IN NUMBER DEFAULT NULL

Line 744: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

740: (
741: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
742: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
743: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
744: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
745: , x_return_status OUT NOCOPY VARCHAR2
746: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
747: , p_Template_Id IN NUMBER DEFAULT NULL
748: , p_Template_Name IN VARCHAR2 DEFAULT NULL

Line 746: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

742: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
743: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
744: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
745: , x_return_status OUT NOCOPY VARCHAR2
746: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
747: , p_Template_Id IN NUMBER DEFAULT NULL
748: , p_Template_Name IN VARCHAR2 DEFAULT NULL
749: )
750: IS

Line 752: INV_ITEM_GRP.Create_Item(p_commit => p_commit

748: , p_Template_Name IN VARCHAR2 DEFAULT NULL
749: )
750: IS
751: BEGIN
752: INV_ITEM_GRP.Create_Item(p_commit => p_commit
753: ,p_validation_level => p_validation_level
754: ,p_Item_rec => p_Item_rec
755: ,x_Item_rec => x_Item_rec
756: ,x_return_status => x_return_status

Line 768: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

764: PROCEDURE Create_Item
765: (
766: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
767: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
768: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
769: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
770: , x_return_status OUT NOCOPY VARCHAR2
771: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
772: , p_Template_Id IN NUMBER DEFAULT NULL

Line 769: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

765: (
766: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
767: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
768: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
769: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
770: , x_return_status OUT NOCOPY VARCHAR2
771: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
772: , p_Template_Id IN NUMBER DEFAULT NULL
773: , p_Template_Name IN VARCHAR2 DEFAULT NULL

Line 771: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

767: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
768: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
769: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
770: , x_return_status OUT NOCOPY VARCHAR2
771: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
772: , p_Template_Id IN NUMBER DEFAULT NULL
773: , p_Template_Name IN VARCHAR2 DEFAULT NULL
774: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
775: -- Bug 9092888 - changes

Line 774: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

770: , x_return_status OUT NOCOPY VARCHAR2
771: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
772: , p_Template_Id IN NUMBER DEFAULT NULL
773: , p_Template_Name IN VARCHAR2 DEFAULT NULL
774: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
775: -- Bug 9092888 - changes
776: , p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE DEFAULT NULL
777: , p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
778: -- Bug 9092888 - changes

Line 817: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR('INV_ITEM_GRP.Create_Item: Unexpexted error: ' || SQLERRM,1,239);

813: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
814: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
815: x_Error_tbl(l_idx).UNIQUE_ID := 999;
816: x_Error_tbl(l_idx).TABLE_NAME := '';
817: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR('INV_ITEM_GRP.Create_Item: Unexpexted error: ' || SQLERRM,1,239);
818: -- INV_message_s.sql_error('Create_Item', x_progress, SQLCODE);
819: -- INV_ITEM_debug.put_line('Create_Item: ');
820: -- RAISE;
821:

Line 831: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

827: (
828: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
829: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
830: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
831: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
832: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
833: , x_return_status OUT NOCOPY VARCHAR2
834: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
835: , p_Template_Id IN NUMBER DEFAULT NULL

Line 832: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

828: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
829: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
830: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
831: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
832: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
833: , x_return_status OUT NOCOPY VARCHAR2
834: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
835: , p_Template_Id IN NUMBER DEFAULT NULL
836: , p_Template_Name IN VARCHAR2 DEFAULT NULL

Line 834: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

830: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
831: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
832: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
833: , x_return_status OUT NOCOPY VARCHAR2
834: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
835: , p_Template_Id IN NUMBER DEFAULT NULL
836: , p_Template_Name IN VARCHAR2 DEFAULT NULL
837: )
838: IS

Line 841: INV_ITEM_GRP.Update_Item(

837: )
838: IS
839: BEGIN
840:
841: INV_ITEM_GRP.Update_Item(
842: p_commit => p_commit
843: ,p_lock_rows => p_lock_rows
844: ,p_validation_level => p_validation_level
845: ,p_Item_rec => p_Item_rec

Line 861: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

857: (
858: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
859: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
860: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
861: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
862: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
863: , x_return_status OUT NOCOPY VARCHAR2
864: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
865: , p_Template_Id IN NUMBER DEFAULT NULL

Line 862: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

858: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
859: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
860: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
861: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
862: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
863: , x_return_status OUT NOCOPY VARCHAR2
864: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
865: , p_Template_Id IN NUMBER DEFAULT NULL
866: , p_Template_Name IN VARCHAR2 DEFAULT NULL

Line 864: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

860: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
861: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
862: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
863: , x_return_status OUT NOCOPY VARCHAR2
864: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
865: , p_Template_Id IN NUMBER DEFAULT NULL
866: , p_Template_Name IN VARCHAR2 DEFAULT NULL
867: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
868: )

Line 867: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

863: , x_return_status OUT NOCOPY VARCHAR2
864: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
865: , p_Template_Id IN NUMBER DEFAULT NULL
866: , p_Template_Name IN VARCHAR2 DEFAULT NULL
867: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
868: )
869: IS
870: c_transaction_type CONSTANT VARCHAR2(10) := 'UPDATE';
871: l_return_status VARCHAR2(1);

Line 902: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR('INV_ITEM_GRP.Update_Item: Unexpexted error: ' || SQLERRM,1,239);

898: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
899: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
900: x_Error_tbl(l_idx).UNIQUE_ID := 999;
901: x_Error_tbl(l_idx).TABLE_NAME := '';
902: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR('INV_ITEM_GRP.Update_Item: Unexpexted error: ' || SQLERRM,1,239);
903:
904: END Update_Item;
905:
906: -- --------------------- Lock_Item ---------------------

Line 913: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

909: (
910: p_Item_ID IN NUMBER
911: , p_Org_ID IN NUMBER
912: , x_return_status OUT NOCOPY VARCHAR2
913: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
914: )
915: IS
916: BEGIN
917:

Line 934: ,p_Item_rec IN INV_ITEM_GRP.Item_rec_type

930: FUNCTION SKU_ITEM_PREPROCESS
931: (p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE DEFAULT NULL
932: ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
933: ,p_set_process_id IN NUMBER
934: ,p_Item_rec IN INV_ITEM_GRP.Item_rec_type
935: ,x_return_err OUT NOCOPY VARCHAR2
936: )
937: RETURN VARCHAR2 IS
938: l_ix NUMBER;

Line 1084: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

1080: (
1081: p_transaction_type IN VARCHAR2
1082: , p_commit IN VARCHAR2
1083: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
1084: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
1085: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
1086: , p_Template_Id IN NUMBER
1087: , p_Template_Name IN VARCHAR2
1088: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

Line 1085: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

1081: p_transaction_type IN VARCHAR2
1082: , p_commit IN VARCHAR2
1083: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
1084: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
1085: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
1086: , p_Template_Id IN NUMBER
1087: , p_Template_Name IN VARCHAR2
1088: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
1089: , x_return_status OUT NOCOPY VARCHAR2

Line 1088: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

1084: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
1085: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
1086: , p_Template_Id IN NUMBER
1087: , p_Template_Name IN VARCHAR2
1088: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
1089: , x_return_status OUT NOCOPY VARCHAR2
1090: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
1091: -- Bug 9092888 - changes
1092: , p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE DEFAULT NULL

Line 1090: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

1086: , p_Template_Id IN NUMBER
1087: , p_Template_Name IN VARCHAR2
1088: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
1089: , x_return_status OUT NOCOPY VARCHAR2
1090: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
1091: -- Bug 9092888 - changes
1092: , p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE DEFAULT NULL
1093: , p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE DEFAULT NULL
1094: -- Bug 9092888 - changes

Line 1276: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INVPOPIF.inopinp_open_interface_process');

1272: l_only_validate := p_Item_rec.PROCESS_ITEM_RECORD;
1273: END IF;
1274:
1275: IF l_inv_debug_level IN(101, 102) THEN
1276: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INVPOPIF.inopinp_open_interface_process');
1277: END IF;
1278: l_return_code :=
1279: INVPOPIF.inopinp_open_interface_process
1280: (

Line 1298: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: done INVPOPIF.inopinp_open_interface_process: l_return_code = ' || l_return_code);

1294: , run_mode => l_IOI_run_mode
1295: );
1296:
1297: IF l_inv_debug_level IN(101, 102) THEN
1298: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: done INVPOPIF.inopinp_open_interface_process: l_return_code = ' || l_return_code);
1299: END IF;
1300:
1301: --------------------------------------------------------------------------
1302: -- Get IOI transaction_id and process_flag for the current set_process_id

Line 1354: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: l_process_flag = ' || l_process_flag || ' l_return_code = ' || l_return_code || ' l_err_text = ' || l_err_text);

1350: set_process_id = l_set_process_id;
1351: END IF; -- Bug 12635842
1352:
1353: IF l_inv_debug_level IN(101, 102) THEN
1354: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: l_process_flag = ' || l_process_flag || ' l_return_code = ' || l_return_code || ' l_err_text = ' || l_err_text);
1355: END IF;
1356: -- Bug 13935085 START. Get the Item Reivsion record status also
1357: BEGIN
1358: SELECT

Line 1375: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: l_rev_process_flag = ' || l_rev_process_flag || ' l_return_code = ' || l_return_code || ' l_err_text = ' || l_err_text);

1371: END;
1372: -- Bug 13935085 END
1373:
1374: IF l_inv_debug_level IN(101, 102) THEN
1375: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: l_rev_process_flag = ' || l_rev_process_flag || ' l_return_code = ' || l_return_code || ' l_err_text = ' || l_err_text);
1376: END IF;
1377: -----------------------------------------------------------
1378: -- Populate the API Error_tbl with the IOI errors, if any.
1379: -----------------------------------------------------------

Line 1466: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INV_ITEM_GRP.Get_Item');

1462: -- IF ( p_transaction_type <> 'UPDATE' ) then
1463: -- END IF;
1464:
1465: IF l_inv_debug_level IN(101, 102) THEN
1466: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INV_ITEM_GRP.Get_Item');
1467: END IF;
1468:
1469: INV_ITEM_GRP.Get_Item
1470: (

Line 1469: INV_ITEM_GRP.Get_Item

1465: IF l_inv_debug_level IN(101, 102) THEN
1466: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INV_ITEM_GRP.Get_Item');
1467: END IF;
1468:
1469: INV_ITEM_GRP.Get_Item
1470: (
1471: p_Item_ID => l_Item_ID_out
1472: , p_Org_ID => l_Org_ID_out
1473: , x_Item_rec => x_Item_rec

Line 1511: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INV_ITEM_GRP.Get_IOI_Errors');

1507:
1508: l_idx := NVL( x_Error_tbl.COUNT, 0);
1509:
1510: IF l_inv_debug_level IN(101, 102) THEN
1511: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INV_ITEM_GRP.Get_IOI_Errors');
1512: END IF;
1513:
1514: INV_ITEM_GRP.Get_IOI_Errors
1515: ( p_transaction_id => l_transaction_id

Line 1514: INV_ITEM_GRP.Get_IOI_Errors

1510: IF l_inv_debug_level IN(101, 102) THEN
1511: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INV_ITEM_GRP.Get_IOI_Errors');
1512: END IF;
1513:
1514: INV_ITEM_GRP.Get_IOI_Errors
1515: ( p_transaction_id => l_transaction_id
1516: , p_inventory_item_id => l_inventory_item_id
1517: , x_Error_tbl => x_Error_tbl
1518: , x_return_status => l_return_status

Line 1555: INV_ITEM_GRP.Get_IOI_Errors

1551: revision validations are failed and populate the error table START
1552: */
1553: IF(l_rev_process_flag = 3) THEN
1554:
1555: INV_ITEM_GRP.Get_IOI_Errors
1556: ( p_transaction_id => l_rev_transaction_id
1557: , p_inventory_item_id => l_inventory_item_id
1558: , x_Error_tbl => x_Error_tbl
1559: , x_return_status => l_return_status

Line 1623: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR('INV_ITEM_GRP.IOI_Process: Unexpexted error: ' || SQLERRM,1,239);

1619: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1620: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1621: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1622: x_Error_tbl(l_idx).TABLE_NAME := '';
1623: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR('INV_ITEM_GRP.IOI_Process: Unexpexted error: ' || SQLERRM,1,239);
1624:
1625: END IOI_Process;
1626:
1627: -- -------------------- Get_IOI_Errors -------------------

Line 1633: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

1629: PROCEDURE Get_IOI_Errors
1630: (
1631: p_transaction_id IN NUMBER
1632: , p_inventory_item_id IN NUMBER
1633: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
1634: , x_return_status OUT NOCOPY VARCHAR2
1635: , x_return_err OUT NOCOPY VARCHAR2
1636: )
1637: IS

Line 1638: l_Error_rec INV_ITEM_GRP.Error_rec_type;

1634: , x_return_status OUT NOCOPY VARCHAR2
1635: , x_return_err OUT NOCOPY VARCHAR2
1636: )
1637: IS
1638: l_Error_rec INV_ITEM_GRP.Error_rec_type;
1639: l_init_errno NUMBER;
1640: l_idx BINARY_INTEGER;
1641:
1642: /*

Line 1721: x_return_err := 'INV_ITEM_GRP.Get_IOI_Errors: Unexpexted error: ' || SQLERRM;

1717: EXCEPTION
1718:
1719: WHEN others THEN
1720: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1721: x_return_err := 'INV_ITEM_GRP.Get_IOI_Errors: Unexpexted error: ' || SQLERRM;
1722:
1723: END Get_IOI_Errors;
1724:
1725: -- ------------------- Insert_MSII_Row -------------------

Line 1731: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

1727: PROCEDURE Insert_MSII_Row
1728: (
1729: p_commit IN VARCHAR2
1730: , p_transaction_type IN VARCHAR2
1731: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
1732: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
1733: , p_Template_Id IN NUMBER
1734: , p_Template_Name IN VARCHAR2
1735: , x_set_process_id OUT NOCOPY NUMBER

Line 1732: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

1728: (
1729: p_commit IN VARCHAR2
1730: , p_transaction_type IN VARCHAR2
1731: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
1732: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
1733: , p_Template_Id IN NUMBER
1734: , p_Template_Name IN VARCHAR2
1735: , x_set_process_id OUT NOCOPY NUMBER
1736: , x_return_status OUT NOCOPY VARCHAR2

Line 1750: l_Item_rec INV_ITEM_GRP.Item_Rec_Type := p_Item_rec;

1746: -- x_def_master_org_id /* organization id */
1747:
1748: l_Contract_Item_Type_Code VARCHAR2(30);
1749: l_item_rowid ROWID;
1750: l_Item_rec INV_ITEM_GRP.Item_Rec_Type := p_Item_rec;
1751:
1752: BEGIN
1753:
1754: SAVEPOINT Insert_MSII_Row;

Line 4865: x_return_err := 'INV_ITEM_GRP.Insert_MSII_Row: Unexpexted error: ' || SQLERRM;

4861:
4862: WHEN others THEN
4863: ROLLBACK TO Insert_MSII_Row;
4864: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4865: x_return_err := 'INV_ITEM_GRP.Insert_MSII_Row: Unexpexted error: ' || SQLERRM;
4866:
4867: END Insert_MSII_Row;
4868:
4869: PROCEDURE Insert_Revision_Record(

Line 4871: ,p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

4867: END Insert_MSII_Row;
4868:
4869: PROCEDURE Insert_Revision_Record(
4870: p_item_rowid IN ROWID
4871: ,p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
4872: ,p_set_process_id IN NUMBER
4873: ,x_return_status OUT NOCOPY VARCHAR2
4874: ,x_return_err OUT NOCOPY VARCHAR2)
4875: IS

Line 5005: x_return_err := 'INV_ITEM_GRP.Insert_Revision_Record: Unexpexted error: ' || SQLERRM;

5001:
5002: EXCEPTION
5003: WHEN OTHERS THEN
5004: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
5005: x_return_err := 'INV_ITEM_GRP.Insert_Revision_Record: Unexpexted error: ' || SQLERRM;
5006: END Insert_Revision_Record;
5007:
5008: -- -------------------- Get_Item ---------------------
5009:

Line 5016: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

5012: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
5013: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
5014: , p_Org_ID IN NUMBER
5015: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
5016: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
5017: , x_return_status OUT NOCOPY VARCHAR2
5018: , x_return_err OUT NOCOPY VARCHAR2
5019: )
5020: IS

Line 5033: x_return_err := 'INV_ITEM_GRP.Get_Item: INV_MISS_ORG_ITEM_ID';

5029: IF ( p_Item_ID = fnd_api.g_MISS_NUM ) OR ( p_Item_ID IS NULL ) OR
5030: ( p_Org_ID = fnd_api.g_MISS_NUM ) OR ( p_Org_ID IS NULL )
5031: THEN
5032: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
5033: x_return_err := 'INV_ITEM_GRP.Get_Item: INV_MISS_ORG_ITEM_ID';
5034: RETURN;
5035: /*
5036: fnd_message.SET_NAME( 'INV', 'INV_MISS_ORG_ITEM_ID' );
5037: fnd_msg_pub.Add;

Line 5055: x_return_err := 'INV_ITEM_GRP.Get_Item: Item not found.';

5051:
5052: IF ( Item_csr%NOTFOUND ) THEN
5053: CLOSE Item_csr;
5054: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
5055: x_return_err := 'INV_ITEM_GRP.Get_Item: Item not found.';
5056: RETURN;
5057: /*
5058: fnd_message.SET_NAME( 'INV', 'INV_ORG_ITEM_NOTFOUND' );
5059: fnd_msg_pub.Add;

Line 5073: x_return_err := 'INV_ITEM_GRP.Get_Item: Unexpected error: ' || SQLERRM;

5069: IF ( Item_csr%ISOPEN ) THEN
5070: CLOSE Item_csr;
5071: END IF;
5072: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
5073: x_return_err := 'INV_ITEM_GRP.Get_Item: Unexpected error: ' || SQLERRM;
5074:
5075: END Get_Item;
5076:
5077: PROCEDURE Interface_Handler

Line 5081: ,p_Item_rec IN INV_ITEM_GRP.Item_Rec_Type

5077: PROCEDURE Interface_Handler
5078: (
5079: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5080: ,p_transaction_type IN VARCHAR2
5081: ,p_Item_rec IN INV_ITEM_GRP.Item_Rec_Type
5082: ,P_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
5083: ,p_Template_Id IN NUMBER
5084: ,p_Template_Name IN VARCHAR2
5085: ,x_batch_id OUT NOCOPY NUMBER

Line 5082: ,P_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

5078: (
5079: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
5080: ,p_transaction_type IN VARCHAR2
5081: ,p_Item_rec IN INV_ITEM_GRP.Item_Rec_Type
5082: ,P_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
5083: ,p_Template_Id IN NUMBER
5084: ,p_Template_Name IN VARCHAR2
5085: ,x_batch_id OUT NOCOPY NUMBER
5086: ,x_return_status OUT NOCOPY VARCHAR2

Line 5174: END INV_ITEM_GRP;

5170:
5171: END Interface_Handler;
5172:
5173:
5174: END INV_ITEM_GRP;