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.7.12010000.2 2008/11/26 21:57:57 akbharga 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 451: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

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

Line 452: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

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

Line 463: ,p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

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

Line 474: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

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
478: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

Line 475: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

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
478: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
479: , x_return_status OUT NOCOPY VARCHAR2

Line 478: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

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
478: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
479: , x_return_status OUT NOCOPY VARCHAR2
480: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
481: );
482:

Line 480: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

476: , p_Template_Id IN NUMBER
477: , p_Template_Name IN VARCHAR2
478: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
479: , x_return_status OUT NOCOPY VARCHAR2
480: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
481: );
482:
483: PROCEDURE Get_IOI_Errors
484: (

Line 487: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

483: PROCEDURE Get_IOI_Errors
484: (
485: p_transaction_id IN NUMBER
486: , p_inventory_item_id IN NUMBER
487: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
488: , x_return_status OUT NOCOPY VARCHAR2
489: , x_return_err OUT NOCOPY VARCHAR2
490: );
491:

Line 502: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

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
506: , p_Template_Id IN NUMBER DEFAULT NULL

Line 503: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

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
506: , p_Template_Id IN NUMBER DEFAULT NULL
507: , p_Template_Name IN VARCHAR2 DEFAULT NULL

Line 505: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

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
506: , p_Template_Id IN NUMBER DEFAULT NULL
507: , p_Template_Name IN VARCHAR2 DEFAULT NULL
508: )
509: IS

Line 511: INV_ITEM_GRP.Create_Item(p_commit => p_commit

507: , p_Template_Name IN VARCHAR2 DEFAULT NULL
508: )
509: IS
510: BEGIN
511: INV_ITEM_GRP.Create_Item(p_commit => p_commit
512: ,p_validation_level => p_validation_level
513: ,p_Item_rec => p_Item_rec
514: ,x_Item_rec => x_Item_rec
515: ,x_return_status => x_return_status

Line 527: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

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
531: , p_Template_Id IN NUMBER DEFAULT NULL

Line 528: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

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
531: , p_Template_Id IN NUMBER DEFAULT NULL
532: , p_Template_Name IN VARCHAR2 DEFAULT NULL

Line 530: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

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
531: , p_Template_Id IN NUMBER DEFAULT NULL
532: , p_Template_Name IN VARCHAR2 DEFAULT NULL
533: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
534: )

Line 533: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

529: , x_return_status OUT NOCOPY VARCHAR2
530: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
531: , p_Template_Id IN NUMBER DEFAULT NULL
532: , p_Template_Name IN VARCHAR2 DEFAULT NULL
533: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
534: )
535: IS
536: c_transaction_type CONSTANT VARCHAR2(10) := 'CREATE';
537: l_return_status VARCHAR2(1);

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

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);
569: -- INV_message_s.sql_error('Create_Item', x_progress, SQLCODE);
570: -- INV_ITEM_debug.put_line('Create_Item: ');
571: -- RAISE;
572:

Line 582: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

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
586: , p_Template_Id IN NUMBER DEFAULT NULL

Line 583: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

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
586: , p_Template_Id IN NUMBER DEFAULT NULL
587: , p_Template_Name IN VARCHAR2 DEFAULT NULL

Line 585: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

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
586: , p_Template_Id IN NUMBER DEFAULT NULL
587: , p_Template_Name IN VARCHAR2 DEFAULT NULL
588: )
589: IS

Line 592: INV_ITEM_GRP.Update_Item(

588: )
589: IS
590: BEGIN
591:
592: INV_ITEM_GRP.Update_Item(
593: p_commit => p_commit
594: ,p_lock_rows => p_lock_rows
595: ,p_validation_level => p_validation_level
596: ,p_Item_rec => p_Item_rec

Line 612: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

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
616: , p_Template_Id IN NUMBER DEFAULT NULL

Line 613: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

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
616: , p_Template_Id IN NUMBER DEFAULT NULL
617: , p_Template_Name IN VARCHAR2 DEFAULT NULL

Line 615: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

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
616: , p_Template_Id IN NUMBER DEFAULT NULL
617: , p_Template_Name IN VARCHAR2 DEFAULT NULL
618: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
619: )

Line 618: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

614: , x_return_status OUT NOCOPY VARCHAR2
615: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
616: , p_Template_Id IN NUMBER DEFAULT NULL
617: , p_Template_Name IN VARCHAR2 DEFAULT NULL
618: , p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
619: )
620: IS
621: c_transaction_type CONSTANT VARCHAR2(10) := 'UPDATE';
622: l_return_status VARCHAR2(1);

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

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);
654:
655: END Update_Item;
656:
657: -- --------------------- Lock_Item ---------------------

Line 664: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

660: (
661: p_Item_ID IN NUMBER
662: , p_Org_ID IN NUMBER
663: , x_return_status OUT NOCOPY VARCHAR2
664: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
665: )
666: IS
667: BEGIN
668:

Line 687: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

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
691: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

Line 688: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

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
691: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
692: , x_return_status OUT NOCOPY VARCHAR2

Line 691: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

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
691: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
692: , x_return_status OUT NOCOPY VARCHAR2
693: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
694: )
695: IS

Line 693: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

689: , p_Template_Id IN NUMBER
690: , p_Template_Name IN VARCHAR2
691: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type
692: , x_return_status OUT NOCOPY VARCHAR2
693: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
694: )
695: IS
696: -- Do not commit an inserted row in MSII
697: --

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

826: l_only_validate := p_Item_rec.PROCESS_ITEM_RECORD;
827: END IF;
828:
829: IF l_inv_debug_level IN(101, 102) THEN
830: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INVPOPIF.inopinp_open_interface_process');
831: END IF;
832: l_return_code :=
833: INVPOPIF.inopinp_open_interface_process
834: (

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

848: , run_mode => l_IOI_run_mode
849: );
850:
851: IF l_inv_debug_level IN(101, 102) THEN
852: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: done INVPOPIF.inopinp_open_interface_process: l_return_code = ' || l_return_code);
853: END IF;
854:
855: --------------------------------------------------------------------------
856: -- Get IOI transaction_id and process_flag for the current set_process_id

Line 875: 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);

871: WHERE
872: set_process_id = l_set_process_id;
873:
874: IF l_inv_debug_level IN(101, 102) THEN
875: 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);
876: END IF;
877:
878: -----------------------------------------------------------
879: -- Populate the API Error_tbl with the IOI errors, if any.

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

890: -- IF ( p_transaction_type <> 'UPDATE' ) then
891: -- END IF;
892:
893: IF l_inv_debug_level IN(101, 102) THEN
894: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INV_ITEM_GRP.Get_Item');
895: END IF;
896:
897: INV_ITEM_GRP.Get_Item
898: (

Line 897: INV_ITEM_GRP.Get_Item

893: IF l_inv_debug_level IN(101, 102) THEN
894: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INV_ITEM_GRP.Get_Item');
895: END IF;
896:
897: INV_ITEM_GRP.Get_Item
898: (
899: p_Item_ID => l_Item_ID_out
900: , p_Org_ID => l_Org_ID_out
901: , x_Item_rec => x_Item_rec

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

935:
936: l_idx := NVL( x_Error_tbl.COUNT, 0);
937:
938: IF l_inv_debug_level IN(101, 102) THEN
939: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INV_ITEM_GRP.Get_IOI_Errors');
940: END IF;
941:
942: INV_ITEM_GRP.Get_IOI_Errors
943: ( p_transaction_id => l_transaction_id

Line 942: INV_ITEM_GRP.Get_IOI_Errors

938: IF l_inv_debug_level IN(101, 102) THEN
939: INVPUTLI.info('INV_ITEM_GRP.IOI_Process: calling INV_ITEM_GRP.Get_IOI_Errors');
940: END IF;
941:
942: INV_ITEM_GRP.Get_IOI_Errors
943: ( p_transaction_id => l_transaction_id
944: , p_inventory_item_id => l_inventory_item_id
945: , x_Error_tbl => x_Error_tbl
946: , x_return_status => l_return_status

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

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);
1010:
1011: END IOI_Process;
1012:
1013: -- -------------------- Get_IOI_Errors -------------------

Line 1019: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type

1015: PROCEDURE Get_IOI_Errors
1016: (
1017: p_transaction_id IN NUMBER
1018: , p_inventory_item_id IN NUMBER
1019: , x_Error_tbl IN OUT NOCOPY INV_ITEM_GRP.Error_tbl_type
1020: , x_return_status OUT NOCOPY VARCHAR2
1021: , x_return_err OUT NOCOPY VARCHAR2
1022: )
1023: IS

Line 1024: l_Error_rec INV_ITEM_GRP.Error_rec_type;

1020: , x_return_status OUT NOCOPY VARCHAR2
1021: , x_return_err OUT NOCOPY VARCHAR2
1022: )
1023: IS
1024: l_Error_rec INV_ITEM_GRP.Error_rec_type;
1025: l_init_errno NUMBER;
1026: l_idx BINARY_INTEGER;
1027:
1028: /*

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

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:
1111: -- ------------------- Insert_MSII_Row -------------------

Line 1117: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type

1113: PROCEDURE Insert_MSII_Row
1114: (
1115: p_commit IN VARCHAR2
1116: , p_transaction_type IN VARCHAR2
1117: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
1118: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
1119: , p_Template_Id IN NUMBER
1120: , p_Template_Name IN VARCHAR2
1121: , x_set_process_id OUT NOCOPY NUMBER

Line 1118: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

1114: (
1115: p_commit IN VARCHAR2
1116: , p_transaction_type IN VARCHAR2
1117: , p_Item_rec IN INV_ITEM_GRP.Item_rec_type
1118: , p_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
1119: , p_Template_Id IN NUMBER
1120: , p_Template_Name IN VARCHAR2
1121: , x_set_process_id OUT NOCOPY NUMBER
1122: , x_return_status OUT NOCOPY VARCHAR2

Line 1136: l_Item_rec INV_ITEM_GRP.Item_Rec_Type := p_Item_rec;

1132: -- x_def_master_org_id /* organization id */
1133:
1134: l_Contract_Item_Type_Code VARCHAR2(30);
1135: l_item_rowid ROWID;
1136: l_Item_rec INV_ITEM_GRP.Item_Rec_Type := p_Item_rec;
1137:
1138: BEGIN
1139:
1140: SAVEPOINT Insert_MSII_Row;

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

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:
4255: PROCEDURE Insert_Revision_Record(

Line 4257: ,p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

4253: END Insert_MSII_Row;
4254:
4255: PROCEDURE Insert_Revision_Record(
4256: p_item_rowid IN ROWID
4257: ,p_Revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type
4258: ,p_set_process_id IN NUMBER
4259: ,x_return_status OUT NOCOPY VARCHAR2
4260: ,x_return_err OUT NOCOPY VARCHAR2)
4261: IS

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

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

Line 4402: , x_Item_rec OUT NOCOPY INV_ITEM_GRP.Item_rec_type

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: )
4406: IS

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

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' );
4423: fnd_msg_pub.Add;

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

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' );
4445: fnd_msg_pub.Add;

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

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:
4463: PROCEDURE Interface_Handler

Line 4467: ,p_Item_rec IN INV_ITEM_GRP.Item_Rec_Type

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
4470: ,p_Template_Name IN VARCHAR2
4471: ,x_batch_id OUT NOCOPY NUMBER

Line 4468: ,P_revision_rec IN INV_ITEM_GRP.Item_Revision_Rec_Type

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
4470: ,p_Template_Name IN VARCHAR2
4471: ,x_batch_id OUT NOCOPY NUMBER
4472: ,x_return_status OUT NOCOPY VARCHAR2

Line 4560: END INV_ITEM_GRP;

4556:
4557: END Interface_Handler;
4558:
4559:
4560: END INV_ITEM_GRP;