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 FND_API

Line 473: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

469: PROCEDURE IOI_Process
470: (
471: p_transaction_type IN VARCHAR2
472: , p_commit IN VARCHAR2
473: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
474: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
475: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
476: , p_Template_Id IN NUMBER
477: , p_Template_Name IN VARCHAR2

Line 500: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

496: -- -------------------- Create_Item --------------------
497: --Start:3259338: Overloaded procedures Update_Item,Create_item
498: PROCEDURE Create_Item
499: (
500: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
501: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
502: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
503: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
504: , x_return_status OUT NOCOPY VARCHAR2

Line 501: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

497: --Start:3259338: Overloaded procedures Update_Item,Create_item
498: PROCEDURE Create_Item
499: (
500: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
501: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
502: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
503: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
504: , x_return_status OUT NOCOPY VARCHAR2
505: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

Line 525: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

521: --End:3259338: Overloaded procedures Update_Item,Create_item
522:
523: PROCEDURE Create_Item
524: (
525: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
526: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
527: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
528: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
529: , x_return_status OUT NOCOPY VARCHAR2

Line 526: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

522:
523: PROCEDURE Create_Item
524: (
525: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
526: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
527: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
528: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
529: , x_return_status OUT NOCOPY VARCHAR2
530: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

Line 542: x_return_status := fnd_api.g_RET_STS_SUCCESS;

538: l_idx BINARY_INTEGER;
539: BEGIN
540:
541: SAVEPOINT Create_Item_GRP;
542: x_return_status := fnd_api.g_RET_STS_SUCCESS;
543:
544: IOI_Process
545: (
546: p_transaction_type => c_transaction_type

Line 564: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

560: EXCEPTION
561:
562: WHEN others THEN
563: ROLLBACK TO Create_Item_GRP;
564: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
565: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
566: x_Error_tbl(l_idx).UNIQUE_ID := 999;
567: x_Error_tbl(l_idx).TABLE_NAME := '';
568: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR('INV_ITEM_GRP.Create_Item: Unexpexted error: ' || SQLERRM,1,239);

Line 579: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

575: -- -------------------- Update_Item -------------------
576: --Start:3259338: Overloaded procedures Update_Item,Create_item
577: PROCEDURE Update_Item
578: (
579: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
580: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
581: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
582: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
583: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

Line 580: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE

576: --Start:3259338: Overloaded procedures Update_Item,Create_item
577: PROCEDURE Update_Item
578: (
579: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
580: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
581: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
582: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
583: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
584: , x_return_status OUT NOCOPY VARCHAR2

Line 581: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

577: PROCEDURE Update_Item
578: (
579: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
580: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
581: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
582: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
583: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
584: , x_return_status OUT NOCOPY VARCHAR2
585: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

Line 609: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE

605: --End:3259338: Overloaded procedures Update_Item,Create_item
606:
607: PROCEDURE Update_Item
608: (
609: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
610: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
611: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
612: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
613: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

Line 610: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE

606:
607: PROCEDURE Update_Item
608: (
609: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
610: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
611: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
612: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
613: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
614: , x_return_status OUT NOCOPY VARCHAR2

Line 611: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

607: PROCEDURE Update_Item
608: (
609: p_commit IN VARCHAR2 DEFAULT fnd_api.g_FALSE
610: , p_lock_rows IN VARCHAR2 DEFAULT fnd_api.g_TRUE
611: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
612: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
613: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
614: , x_return_status OUT NOCOPY VARCHAR2
615: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

Line 627: x_return_status := fnd_api.g_RET_STS_SUCCESS;

623: l_idx BINARY_INTEGER;
624: BEGIN
625:
626: SAVEPOINT Update_Item_GRP;
627: x_return_status := fnd_api.g_RET_STS_SUCCESS;
628:
629: IOI_Process
630: (
631: p_transaction_type => c_transaction_type

Line 649: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

645: EXCEPTION
646:
647: WHEN others THEN
648: ROLLBACK TO Update_Item_GRP;
649: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
650: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
651: x_Error_tbl(l_idx).UNIQUE_ID := 999;
652: x_Error_tbl(l_idx).TABLE_NAME := '';
653: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR('INV_ITEM_GRP.Update_Item: Unexpexted error: ' || SQLERRM,1,239);

Line 673: , p_lock_Master => fnd_api.g_TRUE

669: INV_ITEM_PVT.Lock_Org_Items
670: (
671: p_Item_ID => p_Item_ID
672: , p_Org_ID => p_Org_ID
673: , p_lock_Master => fnd_api.g_TRUE
674: , p_lock_Orgs => fnd_api.g_TRUE
675: , x_return_status => x_return_status
676: );
677:

Line 674: , p_lock_Orgs => fnd_api.g_TRUE

670: (
671: p_Item_ID => p_Item_ID
672: , p_Org_ID => p_Org_ID
673: , p_lock_Master => fnd_api.g_TRUE
674: , p_lock_Orgs => fnd_api.g_TRUE
675: , x_return_status => x_return_status
676: );
677:
678: END Lock_Item;

Line 686: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL

682: PROCEDURE IOI_Process
683: (
684: p_transaction_type IN VARCHAR2
685: , p_commit IN VARCHAR2
686: , p_validation_level IN NUMBER DEFAULT fnd_api.g_VALID_LEVEL_FULL
687: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
688: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
689: , p_Template_Id IN NUMBER
690: , p_Template_Name IN VARCHAR2

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

694: )
695: IS
696: -- Do not commit an inserted row in MSII
697: --
698: c_MSII_commit_flag CONSTANT VARCHAR2(1) := fnd_api.g_FALSE;
699:
700: -- Control the IOI run mode (CREATE, UPDATE) through the IOI parameter
701: --
702: l_IOI_run_mode NUMBER;

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

758: END IF;
759:
760: -- Control the API commit through the IOI parameter
761: --
762: IF ( fnd_api.to_Boolean (p_commit) ) THEN
763: l_IOI_commit_flag := 1;
764: ELSE
765: l_IOI_commit_flag := 2;
766: END IF;

Line 768: x_return_status := fnd_api.g_RET_STS_SUCCESS;

764: ELSE
765: l_IOI_commit_flag := 2;
766: END IF;
767:
768: x_return_status := fnd_api.g_RET_STS_SUCCESS;
769:
770: ----------------------------------------------------------------------------
771: -- Insert a row into MSI INTERFACE table converting missing values to nulls
772: ----------------------------------------------------------------------------

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

783: , x_return_status => l_return_status
784: , x_return_err => l_return_err
785: );
786:
787: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
788: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
789: x_Error_tbl(1).UNIQUE_ID := 1;
790: x_Error_tbl(1).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
791: x_Error_tbl(1).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);

Line 788: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

784: , x_return_err => l_return_err
785: );
786:
787: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
788: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
789: x_Error_tbl(1).UNIQUE_ID := 1;
790: x_Error_tbl(1).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
791: x_Error_tbl(1).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);
792: RETURN;

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

902: , x_return_status => l_return_status
903: , x_return_err => l_return_err
904: );
905:
906: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
907: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
908: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
909: x_Error_tbl(l_idx).UNIQUE_ID := 999;
910: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';

Line 907: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

903: , x_return_err => l_return_err
904: );
905:
906: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
907: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
908: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
909: x_Error_tbl(l_idx).UNIQUE_ID := 999;
910: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
911: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);

Line 925: x_return_status := fnd_api.g_RET_STS_SUCCESS;

921: 'Create_Item success. IOI tnx_id=' || to_char(l_transaction_id) ||
922: ' inventory_item_id=' || to_char(l_inventory_item_id);
923: */
924: ELSIF ( (l_process_flag = 4) AND (l_return_code = 0) and (l_only_validate =2)) THEN
925: x_return_status := fnd_api.g_RET_STS_SUCCESS;
926: ELSE
927: --
928: -- An error happened during the IOI run.
929: --

Line 930: x_return_status := fnd_api.g_RET_STS_ERROR;

926: ELSE
927: --
928: -- An error happened during the IOI run.
929: --
930: x_return_status := fnd_api.g_RET_STS_ERROR;
931:
932: -----------------------------------------------------------------
933: -- Populate the Item API Error_tbl with the IOI errors, if any.
934: -----------------------------------------------------------------

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

946: , x_return_status => l_return_status
947: , x_return_err => l_return_err
948: );
949:
950: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
951: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
952: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
953: x_Error_tbl(l_idx).UNIQUE_ID := 999;
954: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_INTERFACE_ERRORS';

Line 951: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

947: , x_return_err => l_return_err
948: );
949:
950: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
951: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
952: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
953: x_Error_tbl(l_idx).UNIQUE_ID := 999;
954: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_INTERFACE_ERRORS';
955: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_return_err,1,239);

Line 986: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

982: , xset_id => l_set_process_id
983: );
984:
985: IF ( l_return_code <> 0 ) THEN
986: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
987: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
988: x_Error_tbl(l_idx).UNIQUE_ID := 999;
989: x_Error_tbl(l_idx).TABLE_NAME := 'MTL_SYSTEM_ITEMS_INTERFACE';
990: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR(l_err_text,1,239);

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

993: -- Control the API commit through the IOI
994: -- inopinp_open_interface_process parameter
995: ----------------------------------------------------------
996: /*
997: IF ( fnd_api.to_Boolean (p_commit) ) THEN
998: COMMIT WORK;
999: END IF;
1000: */
1001:

Line 1005: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1001:
1002: EXCEPTION
1003:
1004: WHEN others THEN
1005: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1006: l_idx := NVL( x_Error_tbl.COUNT, 0) + 1;
1007: x_Error_tbl(l_idx).UNIQUE_ID := 999;
1008: x_Error_tbl(l_idx).TABLE_NAME := '';
1009: x_Error_tbl(l_idx).MESSAGE_TEXT := SUBSTR('INV_ITEM_GRP.IOI_Process: Unexpexted error: ' || SQLERRM,1,239);

Line 1099: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1095: x_Error_tbl(l_idx) := l_Error_rec;
1096: END LOOP;
1097:
1098: IF ( l_idx = l_init_errno ) THEN
1099: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1100: x_return_err := 'IOI error(s) occurred, but no records found in MTL_INTERFACE_ERRORS table';
1101: END IF;
1102:
1103: EXCEPTION

Line 1106: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

1102:
1103: EXCEPTION
1104:
1105: WHEN others THEN
1106: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
1107: x_return_err := 'INV_ITEM_GRP.Get_IOI_Errors: Unexpexted error: ' || SQLERRM;
1108:
1109: END Get_IOI_Errors;
1110:

Line 1141: x_return_status := fnd_api.g_RET_STS_SUCCESS;

1137:
1138: BEGIN
1139:
1140: SAVEPOINT Insert_MSII_Row;
1141: x_return_status := fnd_api.g_RET_STS_SUCCESS;
1142:
1143: IF ( p_transaction_type = 'UPDATE' ) THEN
1144: -- Values used in IOI to indicate update to NULL.
1145: g_Upd_Null_CHAR := '!';

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

4238: ,x_return_status => x_return_status
4239: ,x_return_err => x_return_err);
4240:
4241:
4242: IF ( fnd_api.to_Boolean (p_commit) ) THEN
4243: COMMIT WORK;
4244: END IF;
4245:
4246: EXCEPTION

Line 4250: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4246: EXCEPTION
4247:
4248: WHEN others THEN
4249: ROLLBACK TO Insert_MSII_Row;
4250: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4251: x_return_err := 'INV_ITEM_GRP.Insert_MSII_Row: Unexpexted error: ' || SQLERRM;
4252:
4253: END Insert_MSII_Row;
4254:

Line 4274: x_return_status := fnd_api.g_RET_STS_SUCCESS;

4270: l_error_text VARCHAR2(1000);
4271:
4272: BEGIN
4273:
4274: x_return_status := fnd_api.g_RET_STS_SUCCESS;
4275:
4276: IF UPPER(p_Revision_rec.TRANSACTION_TYPE) IN ('CREATE','UPDATE','SYNC') THEN
4277:
4278: SELECT starting_revision

Line 4390: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4386: END IF;
4387:
4388: EXCEPTION
4389: WHEN OTHERS THEN
4390: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4391: x_return_err := 'INV_ITEM_GRP.Insert_Revision_Record: Unexpexted error: ' || SQLERRM;
4392: END Insert_Revision_Record;
4393:
4394: -- -------------------- Get_Item ---------------------

Line 4398: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR

4394: -- -------------------- Get_Item ---------------------
4395:
4396: PROCEDURE Get_Item
4397: (
4398: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
4399: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
4400: , p_Org_ID IN NUMBER
4401: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
4402: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

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

4395:
4396: PROCEDURE Get_Item
4397: (
4398: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
4399: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
4400: , p_Org_ID IN NUMBER
4401: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
4402: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
4403: , x_return_status OUT NOCOPY VARCHAR2

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

4397: (
4398: p_Item_Number IN VARCHAR2 := fnd_api.g_MISS_CHAR
4399: , p_Item_ID IN NUMBER := fnd_api.g_MISS_NUM
4400: , p_Org_ID IN NUMBER
4401: , p_Language_Code IN VARCHAR2 := fnd_api.g_MISS_CHAR
4402: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
4403: , x_return_status OUT NOCOPY VARCHAR2
4404: , x_return_err OUT NOCOPY VARCHAR2
4405: )

Line 4413: x_return_status := fnd_api.g_RET_STS_SUCCESS;

4409: BEGIN
4410:
4411: -- Initialize API return status to success
4412: --
4413: x_return_status := fnd_api.g_RET_STS_SUCCESS;
4414:
4415: IF ( p_Item_ID = fnd_api.g_MISS_NUM ) OR ( p_Item_ID IS NULL ) OR
4416: ( p_Org_ID = fnd_api.g_MISS_NUM ) OR ( p_Org_ID IS NULL )
4417: THEN

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

4411: -- Initialize API return status to success
4412: --
4413: x_return_status := fnd_api.g_RET_STS_SUCCESS;
4414:
4415: IF ( p_Item_ID = fnd_api.g_MISS_NUM ) OR ( p_Item_ID IS NULL ) OR
4416: ( p_Org_ID = fnd_api.g_MISS_NUM ) OR ( p_Org_ID IS NULL )
4417: THEN
4418: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4419: x_return_err := 'INV_ITEM_GRP.Get_Item: INV_MISS_ORG_ITEM_ID';

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

4412: --
4413: x_return_status := fnd_api.g_RET_STS_SUCCESS;
4414:
4415: IF ( p_Item_ID = fnd_api.g_MISS_NUM ) OR ( p_Item_ID IS NULL ) OR
4416: ( p_Org_ID = fnd_api.g_MISS_NUM ) OR ( p_Org_ID IS NULL )
4417: THEN
4418: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4419: x_return_err := 'INV_ITEM_GRP.Get_Item: INV_MISS_ORG_ITEM_ID';
4420: RETURN;

Line 4418: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4414:
4415: IF ( p_Item_ID = fnd_api.g_MISS_NUM ) OR ( p_Item_ID IS NULL ) OR
4416: ( p_Org_ID = fnd_api.g_MISS_NUM ) OR ( p_Org_ID IS NULL )
4417: THEN
4418: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4419: x_return_err := 'INV_ITEM_GRP.Get_Item: INV_MISS_ORG_ITEM_ID';
4420: RETURN;
4421: /*
4422: fnd_message.SET_NAME( 'INV', 'INV_MISS_ORG_ITEM_ID' );

Line 4424: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;

4420: RETURN;
4421: /*
4422: fnd_message.SET_NAME( 'INV', 'INV_MISS_ORG_ITEM_ID' );
4423: fnd_msg_pub.Add;
4424: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
4425: */
4426: END IF;
4427:
4428: --------------------------------------------

Line 4440: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4436: FETCH Item_csr INTO x_Item_rec;
4437:
4438: IF ( Item_csr%NOTFOUND ) THEN
4439: CLOSE Item_csr;
4440: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4441: x_return_err := 'INV_ITEM_GRP.Get_Item: Item not found.';
4442: RETURN;
4443: /*
4444: fnd_message.SET_NAME( 'INV', 'INV_ORG_ITEM_NOTFOUND' );

Line 4446: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;

4442: RETURN;
4443: /*
4444: fnd_message.SET_NAME( 'INV', 'INV_ORG_ITEM_NOTFOUND' );
4445: fnd_msg_pub.Add;
4446: RAISE fnd_api.g_EXC_UNEXPECTED_ERROR;
4447: */
4448: END IF;
4449:
4450: CLOSE Item_csr;

Line 4458: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4454: WHEN others THEN
4455: IF ( Item_csr%ISOPEN ) THEN
4456: CLOSE Item_csr;
4457: END IF;
4458: x_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4459: x_return_err := 'INV_ITEM_GRP.Get_Item: Unexpected error: ' || SQLERRM;
4460:
4461: END Get_Item;
4462:

Line 4465: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

4461: END Get_Item;
4462:
4463: PROCEDURE Interface_Handler
4464: (
4465: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
4466: ,p_transaction_type IN VARCHAR2
4467: ,p_Item_rec IN INV_ITEM_GRP.Item_Rec_Type
4468: ,P_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
4469: ,p_Template_Id IN NUMBER

Line 4485: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4481: --Adding basic validations before creating item row in Interface
4482:
4483: IF p_transaction_type NOT IN ('CREATE', 'UPDATE', 'SYNC') THEN
4484: l_return_err := 'INV_INVALID_TTYPE';
4485: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4486: l_error_exists := 1;
4487: END IF;
4488:
4489: IF (P_item_rec.organization_id = g_MISS_NUM AND p_item_rec.organization_code = g_MISS_CHAR )

Line 4492: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4488:
4489: IF (P_item_rec.organization_id = g_MISS_NUM AND p_item_rec.organization_code = g_MISS_CHAR )
4490: THEN
4491: l_return_err := 'INV_ORG_CODE_MAND';
4492: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4493: l_error_exists := 1;
4494: END IF;
4495:
4496: IF(p_transaction_type = 'CREATE' AND P_item_rec.item_number = g_MISS_CHAR AND

Line 4509: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4505: P_item_rec.segment17 = g_MISS_CHAR AND P_item_rec.segment18 = g_MISS_CHAR AND
4506: P_item_rec.segment19 = g_MISS_CHAR AND P_item_rec.segment20 = g_MISS_CHAR)
4507: THEN
4508: l_return_err := 'INV_SEG_ITM_NUMB_VAL';
4509: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4510: l_error_exists := 1;
4511:
4512: ELSIF(p_transaction_type = 'UPDATE' AND P_Item_rec.inventory_item_id = g_MISS_NUM AND
4513: P_item_rec.item_number = g_MISS_CHAR AND

Line 4526: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4522: P_item_rec.segment17 = g_MISS_CHAR AND P_item_rec.segment18 = g_MISS_CHAR AND
4523: P_item_rec.segment19 = g_MISS_CHAR AND P_item_rec.segment20 = g_MISS_CHAR )
4524: THEN
4525: l_return_err := 'INV_SEG_ITM_NUMB_VAL';
4526: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4527: l_error_exists := 1;
4528: END IF;
4529:
4530: IF l_error_exists = 0 THEN

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

4540: , x_return_status => l_return_status
4541: , x_return_err => l_return_err
4542: );
4543:
4544: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
4545: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4546: l_return_err := SUBSTR(l_return_err,1,239);
4547: END IF;
4548: END IF;

Line 4545: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;

4541: , x_return_err => l_return_err
4542: );
4543:
4544: IF ( l_return_status <> fnd_api.g_RET_STS_SUCCESS ) THEN
4545: l_return_status := fnd_api.g_RET_STS_UNEXP_ERROR;
4546: l_return_err := SUBSTR(l_return_err,1,239);
4547: END IF;
4548: END IF;
4549:

Line 4553: IF FND_API.To_Boolean(p_commit) THEN

4549:
4550: x_return_status := l_return_status;
4551: x_return_err := l_return_err;
4552:
4553: IF FND_API.To_Boolean(p_commit) THEN
4554: COMMIT WORK;
4555: END IF;
4556:
4557: END Interface_Handler;