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.

[Home] [Help]

APPS.INV_ITEM_GRP dependencies on FND_API

Line 476: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

472: PROCEDURE IOI_Process
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

Line 741: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

737: -- -------------------- Create_Item --------------------
738: --Start:3259338: Overloaded procedures Update_Item,Create_item
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

Line 742: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

738: --Start:3259338: Overloaded procedures Update_Item,Create_item
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

Line 766: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

762: --End:3259338: Overloaded procedures Update_Item,Create_item
763:
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

Line 767: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

763:
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

Line 787: x_return_status := fnd_api.g_RET_STS_SUCCESS;

783: l_idx BINARY_INTEGER;
784: BEGIN
785:
786: SAVEPOINT Create_Item_GRP;
787: x_return_status := fnd_api.g_RET_STS_SUCCESS;
788:
789: IOI_Process
790: (
791: p_transaction_type => c_transaction_type

Line 813: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

809: EXCEPTION
810:
811: WHEN others THEN
812: ROLLBACK TO Create_Item_GRP;
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);

Line 828: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

824: -- -------------------- Update_Item -------------------
825: --Start:3259338: Overloaded procedures Update_Item,Create_item
826: PROCEDURE Update_Item
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

Line 829: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE

825: --Start:3259338: Overloaded procedures Update_Item,Create_item
826: PROCEDURE Update_Item
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

Line 830: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

826: PROCEDURE Update_Item
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

Line 858: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

854: --End:3259338: Overloaded procedures Update_Item,Create_item
855:
856: PROCEDURE Update_Item
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

Line 859: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE

855:
856: PROCEDURE Update_Item
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

Line 860: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

856: PROCEDURE Update_Item
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

Line 876: x_return_status := fnd_api.g_RET_STS_SUCCESS;

872: l_idx BINARY_INTEGER;
873: BEGIN
874:
875: SAVEPOINT Update_Item_GRP;
876: x_return_status := fnd_api.g_RET_STS_SUCCESS;
877:
878: IOI_Process
879: (
880: p_transaction_type => c_transaction_type

Line 898: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

894: EXCEPTION
895:
896: WHEN others THEN
897: ROLLBACK TO Update_Item_GRP;
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);

Line 922: , p_lock_Master => fnd_api.g_TRUE

918: INV_ITEM_PVT.Lock_Org_Items
919: (
920: p_Item_ID => p_Item_ID
921: , p_Org_ID => p_Org_ID
922: , p_lock_Master => fnd_api.g_TRUE
923: , p_lock_Orgs => fnd_api.g_TRUE
924: , x_return_status => x_return_status
925: );
926:

Line 923: , p_lock_Orgs => fnd_api.g_TRUE

919: (
920: p_Item_ID => p_Item_ID
921: , p_Org_ID => p_Org_ID
922: , p_lock_Master => fnd_api.g_TRUE
923: , p_lock_Orgs => fnd_api.g_TRUE
924: , x_return_status => x_return_status
925: );
926:
927: END Lock_Item;

Line 967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

963: END LOOP;
964:
965: IF l_ix = -1 THEN
966: x_return_err := 'SKU_ITEM_PREPROCESS - Unexpected Error occured';
967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
968: END IF;
969:
970: l_attr_name := p_attributes_data_table(j).ATTR_NAME;
971: l_attr_group_id := p_attributes_row_table(l_ix).ATTR_GROUP_ID;

Line 1003: ,p_message_type => FND_API.G_RET_STS_ERROR

999: ERROR_HANDLER.Add_Error_Message(
1000: p_message_name => l_err_msg_name
1001: ,p_application_id => 'EGO'
1002: ,p_token_tbl => l_token_table
1003: ,p_message_type => FND_API.G_RET_STS_ERROR
1004: );
1005: RETURN FND_API.g_RET_STS_ERROR;
1006: END;
1007: ELSE

Line 1005: RETURN FND_API.g_RET_STS_ERROR;

1001: ,p_application_id => 'EGO'
1002: ,p_token_tbl => l_token_table
1003: ,p_message_type => FND_API.G_RET_STS_ERROR
1004: );
1005: RETURN FND_API.g_RET_STS_ERROR;
1006: END;
1007: ELSE
1008: -- error attribute group details are not provided.
1009: l_err_msg_name := 'EGO_VAR_ATTR_GROUP_DETAILS_ERR';

Line 1015: ,p_message_type => FND_API.G_RET_STS_ERROR

1011: ERROR_HANDLER.Add_Error_Message(
1012: p_message_name => l_err_msg_name
1013: ,p_application_id => 'EGO'
1014: ,p_token_tbl => l_token_table
1015: ,p_message_type => FND_API.G_RET_STS_ERROR
1016: );
1017:
1018: RETURN FND_API.g_RET_STS_ERROR;
1019: END IF;

Line 1018: RETURN FND_API.g_RET_STS_ERROR;

1014: ,p_token_tbl => l_token_table
1015: ,p_message_type => FND_API.G_RET_STS_ERROR
1016: );
1017:
1018: RETURN FND_API.g_RET_STS_ERROR;
1019: END IF;
1020: END IF;
1021:
1022: INSERT INTO EGO_ITM_USR_ATTR_INTRFC

Line 1062: ,p_message_type => FND_API.G_RET_STS_ERROR

1058: ERROR_HANDLER.Add_Error_Message(
1059: p_message_name => l_err_msg_name
1060: ,p_application_id => 'EGO'
1061: ,p_token_tbl => l_token_table
1062: ,p_message_type => FND_API.G_RET_STS_ERROR
1063: );
1064: RETURN FND_API.g_RET_STS_ERROR;
1065: END IF; -- attr row and data NOT NULL
1066:

Line 1064: RETURN FND_API.g_RET_STS_ERROR;

1060: ,p_application_id => 'EGO'
1061: ,p_token_tbl => l_token_table
1062: ,p_message_type => FND_API.G_RET_STS_ERROR
1063: );
1064: RETURN FND_API.g_RET_STS_ERROR;
1065: END IF; -- attr row and data NOT NULL
1066:
1067: RETURN fnd_api.g_RET_STS_SUCCESS;
1068: EXCEPTION

Line 1067: RETURN fnd_api.g_RET_STS_SUCCESS;

1063: );
1064: RETURN FND_API.g_RET_STS_ERROR;
1065: END IF; -- attr row and data NOT NULL
1066:
1067: RETURN fnd_api.g_RET_STS_SUCCESS;
1068: EXCEPTION
1069: WHEN OTHERS THEN
1070: x_return_err := 'SKU_ITEM_PREPROCESS - Exception Othres'||SQLERRM ;
1071: RETURN fnd_api.g_RET_STS_UNEXP_ERROR;

Line 1071: RETURN fnd_api.g_RET_STS_UNEXP_ERROR;

1067: RETURN fnd_api.g_RET_STS_SUCCESS;
1068: EXCEPTION
1069: WHEN OTHERS THEN
1070: x_return_err := 'SKU_ITEM_PREPROCESS - Exception Othres'||SQLERRM ;
1071: RETURN fnd_api.g_RET_STS_UNEXP_ERROR;
1072:
1073: END SKU_ITEM_PREPROCESS;
1074: -- Bug 9092888 - changes
1075:

Line 1083: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

1079: PROCEDURE IOI_Process
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

Line 1099: c_MSII_commit_flag CONSTANT VARCHAR2(1) := fnd_api.g_FALSE;

1095: )
1096: IS
1097: -- Do not commit an inserted row in MSII
1098: --
1099: c_MSII_commit_flag CONSTANT VARCHAR2(1) := fnd_api.g_FALSE;
1100:
1101: -- Control the IOI run mode (CREATE, UPDATE) through the IOI parameter
1102: --
1103: l_IOI_run_mode NUMBER;

Line 1174: IF ( fnd_api.to_Boolean (p_commit) ) THEN

1170: END IF;
1171:
1172: -- Control the API commit through the IOI parameter
1173: --
1174: IF ( fnd_api.to_Boolean (p_commit) ) THEN
1175: l_IOI_commit_flag := 1;
1176: ELSE
1177: l_IOI_commit_flag := 2;
1178: END IF;

Line 1180: x_return_status := fnd_api.g_RET_STS_SUCCESS;

1176: ELSE
1177: l_IOI_commit_flag := 2;
1178: END IF;
1179:
1180: x_return_status := fnd_api.g_RET_STS_SUCCESS;
1181:
1182: ----------------------------------------------------------------------------
1183: -- Insert a row into MSI INTERFACE table converting missing values to nulls
1184: ----------------------------------------------------------------------------

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

1195: , x_return_status => l_return_status
1196: , x_return_err => l_return_err
1197: );
1198:
1199: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1200: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1201: x_Error_tbl(1).UNIQUE_ID := 1;
1202: x_Error_tbl(1).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
1203: x_Error_tbl(1).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);

Line 1200: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1196: , x_return_err => l_return_err
1197: );
1198:
1199: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1200: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1201: x_Error_tbl(1).UNIQUE_ID := 1;
1202: x_Error_tbl(1).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
1203: x_Error_tbl(1).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);
1204: RETURN;

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

1216: ,p_Item_rec => p_Item_rec
1217: , x_return_err => l_return_err
1218: );
1219:
1220: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1221: x_return_status := l_return_status;
1222: x_Error_tbl(1).UNIQUE_ID := 1;
1223: x_Error_tbl(1).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
1224: x_Error_tbl(1).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);

Line 1414: ,p_validate_only => FND_API.G_TRUE

1410: EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data(
1411: ERRBUF => l_err_bug
1412: ,RETCODE => l_ret_code
1413: ,p_data_set_id => l_set_process_id
1414: ,p_validate_only => FND_API.G_TRUE
1415: ,p_is_id_validations_reqd => FND_API.G_FALSE
1416: ,p_commit => p_commit
1417: );
1418: END IF;

Line 1415: ,p_is_id_validations_reqd => FND_API.G_FALSE

1411: ERRBUF => l_err_bug
1412: ,RETCODE => l_ret_code
1413: ,p_data_set_id => l_set_process_id
1414: ,p_validate_only => FND_API.G_TRUE
1415: ,p_is_id_validations_reqd => FND_API.G_FALSE
1416: ,p_commit => p_commit
1417: );
1418: END IF;
1419:

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

1474: , x_return_status => l_return_status
1475: , x_return_err => l_return_err
1476: );
1477:
1478: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1479: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1480: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1481: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1482: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';

Line 1479: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1475: , x_return_err => l_return_err
1476: );
1477:
1478: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1479: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1480: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1481: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1482: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
1483: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);

Line 1497: x_return_status := fnd_api.g_RET_STS_SUCCESS;

1493: 'Create_Item success. IOI tnx_id=' || to_char(l_transaction_id) ||
1494: ' inventory_item_id=' || to_char(l_inventory_item_id);
1495: */
1496: ELSIF ( (l_process_flag = 4) AND (l_return_code = 0) and (l_only_validate =2)) THEN
1497: x_return_status := fnd_api.g_RET_STS_SUCCESS;
1498: ELSE
1499: --
1500: -- An error happened during the IOI run.
1501: --

Line 1502: x_return_status := fnd_api.g_RET_STS_ERROR;

1498: ELSE
1499: --
1500: -- An error happened during the IOI run.
1501: --
1502: x_return_status := fnd_api.g_RET_STS_ERROR;
1503:
1504: -----------------------------------------------------------------
1505: -- Populate the Item API Error_tbl with the IOI errors, if any.
1506: -----------------------------------------------------------------

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

1518: , x_return_status => l_return_status
1519: , x_return_err => l_return_err
1520: );
1521:
1522: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1523: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1524: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1525: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1526: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_INTERFACE_ERRORS';

Line 1523: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1519: , x_return_err => l_return_err
1520: );
1521:
1522: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1523: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1524: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1525: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1526: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_INTERFACE_ERRORS';
1527: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);

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

1559: , x_return_status => l_return_status
1560: , x_return_err => l_return_err
1561: );
1562:
1563: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1564: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1565: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1566: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1567: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_INTERFACE_ERRORS';

Line 1564: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1560: , x_return_err => l_return_err
1561: );
1562:
1563: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
1564: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1565: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1566: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1567: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_INTERFACE_ERRORS';
1568: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);

Line 1600: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1596: , xset_id => l_set_process_id
1597: );
1598:
1599: IF ( l_return_code <> 0 ) THEN
1600: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1601: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1602: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1603: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
1604: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_err_text,1,239);

Line 1611: IF ( fnd_api.to_Boolean (p_commit) ) THEN

1607: -- Control the API commit through the IOI
1608: -- inopinp_open_interface_process parameter
1609: ----------------------------------------------------------
1610: /*
1611: IF ( fnd_api.to_Boolean (p_commit) ) THEN
1612: COMMIT WORK;
1613: END IF;
1614: */
1615:

Line 1619: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1615:
1616: EXCEPTION
1617:
1618: WHEN others THEN
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);

Line 1713: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1709: x_Error_tbl(l_idx) := l_Error_rec;
1710: END LOOP;
1711:
1712: IF ( l_idx = l_init_errno ) THEN
1713: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1714: x_return_err := 'IOI error(s) occurred, but no records found in MTL_INTERFACE_ERRORS table';
1715: END IF;
1716:
1717: EXCEPTION

Line 1720: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1716:
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:

Line 1755: x_return_status := fnd_api.g_RET_STS_SUCCESS;

1751:
1752: BEGIN
1753:
1754: SAVEPOINT Insert_MSII_Row;
1755: x_return_status := fnd_api.g_RET_STS_SUCCESS;
1756:
1757: IF ( p_transaction_type = 'UPDATE' ) THEN
1758: -- Values used in IOI to indicate update to NULL.
1759: g_Upd_Null_CHAR := '!';

Line 4856: IF ( fnd_api.to_Boolean (p_commit) ) THEN

4852: ,x_return_status => x_return_status
4853: ,x_return_err => x_return_err);
4854:
4855:
4856: IF ( fnd_api.to_Boolean (p_commit) ) THEN
4857: COMMIT WORK;
4858: END IF;
4859:
4860: EXCEPTION

Line 4864: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4860: EXCEPTION
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:

Line 4888: x_return_status := fnd_api.g_RET_STS_SUCCESS;

4884: l_error_text VARCHAR2(1000);
4885:
4886: BEGIN
4887:
4888: x_return_status := fnd_api.g_RET_STS_SUCCESS;
4889:
4890: IF UPPER(p_Revision_rec.TRANSACTION_TYPE) IN ('CREATE','UPDATE','SYNC') THEN
4891:
4892: SELECT starting_revision

Line 5004: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

5000: END IF;
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 ---------------------

Line 5012: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR

5008: -- -------------------- Get_Item ---------------------
5009:
5010: PROCEDURE Get_Item
5011: (
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

Line 5013: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM

5009:
5010: PROCEDURE Get_Item
5011: (
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

Line 5015: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR

5011: (
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: )

Line 5027: x_return_status := fnd_api.g_RET_STS_SUCCESS;

5023: BEGIN
5024:
5025: -- Initialize API return status to success
5026: --
5027: x_return_status := fnd_api.g_RET_STS_SUCCESS;
5028:
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

Line 5029: IF ( p_Item_ID = fnd_api.g_MISS_NUM ) OR ( p_Item_ID IS NULL ) OR

5025: -- Initialize API return status to success
5026: --
5027: x_return_status := fnd_api.g_RET_STS_SUCCESS;
5028:
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';

Line 5030: ( p_Org_ID = fnd_api.g_MISS_NUM ) OR ( p_Org_ID IS NULL )

5026: --
5027: x_return_status := fnd_api.g_RET_STS_SUCCESS;
5028:
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;

Line 5032: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

5028:
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' );

Line 5038: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;

5034: RETURN;
5035: /*
5036: fnd_message.SET_NAME( 'INV', 'INV_MISS_ORG_ITEM_ID' );
5037: fnd_msg_pub.Add;
5038: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
5039: */
5040: END IF;
5041:
5042: --------------------------------------------

Line 5054: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

5050: FETCH Item_csr INTO x_Item_rec;
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' );

Line 5060: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;

5056: RETURN;
5057: /*
5058: fnd_message.SET_NAME( 'INV', 'INV_ORG_ITEM_NOTFOUND' );
5059: fnd_msg_pub.Add;
5060: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
5061: */
5062: END IF;
5063:
5064: CLOSE Item_csr;

Line 5072: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

5068: WHEN others THEN
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:

Line 5079: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

5075: END Get_Item;
5076:
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

Line 5099: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

5095: --Adding basic validations before creating item row in Interface
5096:
5097: IF p_transaction_type NOT IN ('CREATE', 'UPDATE', 'SYNC') THEN
5098: l_return_err := 'INV_INVALID_TTYPE';
5099: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
5100: l_error_exists := 1;
5101: END IF;
5102:
5103: IF (P_item_rec.organization_id = g_MISS_NUM AND p_item_rec.organization_code = g_MISS_CHAR )

Line 5106: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

5102:
5103: IF (P_item_rec.organization_id = g_MISS_NUM AND p_item_rec.organization_code = g_MISS_CHAR )
5104: THEN
5105: l_return_err := 'INV_ORG_CODE_MAND';
5106: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
5107: l_error_exists := 1;
5108: END IF;
5109:
5110: IF(p_transaction_type = 'CREATE' AND P_item_rec.item_number = g_MISS_CHAR AND

Line 5123: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

5119: P_item_rec.segment17 = g_MISS_CHAR AND P_item_rec.segment18 = g_MISS_CHAR AND
5120: P_item_rec.segment19 = g_MISS_CHAR AND P_item_rec.segment20 = g_MISS_CHAR)
5121: THEN
5122: l_return_err := 'INV_SEG_ITM_NUMB_VAL';
5123: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
5124: l_error_exists := 1;
5125:
5126: ELSIF(p_transaction_type = 'UPDATE' AND P_Item_rec.inventory_item_id = g_MISS_NUM AND
5127: P_item_rec.item_number = g_MISS_CHAR AND

Line 5140: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

5136: P_item_rec.segment17 = g_MISS_CHAR AND P_item_rec.segment18 = g_MISS_CHAR AND
5137: P_item_rec.segment19 = g_MISS_CHAR AND P_item_rec.segment20 = g_MISS_CHAR )
5138: THEN
5139: l_return_err := 'INV_SEG_ITM_NUMB_VAL';
5140: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
5141: l_error_exists := 1;
5142: END IF;
5143:
5144: IF l_error_exists = 0 THEN

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

5154: , x_return_status => l_return_status
5155: , x_return_err => l_return_err
5156: );
5157:
5158: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
5159: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
5160: l_return_err := SUBSTR(l_return_err,1,239);
5161: END IF;
5162: END IF;

Line 5159: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

5155: , x_return_err => l_return_err
5156: );
5157:
5158: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
5159: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
5160: l_return_err := SUBSTR(l_return_err,1,239);
5161: END IF;
5162: END IF;
5163:

Line 5167: IF FND_API.To_Boolean(p_commit) THEN

5163:
5164: x_return_status := l_return_status;
5165: x_return_err := l_return_err;
5166:
5167: IF FND_API.To_Boolean(p_commit) THEN
5168: COMMIT WORK;
5169: END IF;
5170:
5171: END Interface_Handler;