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.EAM_ACTIVITY_PUB dependencies on INV_ITEM_GRP

Line 131: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

127: END;
128:
129: -- ----------------------------------------------------------------------
130: PROCEDURE Create_Activity_Routing(
131: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
132: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
133: p_operation_copy_option IN NUMBER,
134: p_resource_copy_option IN NUMBER,
135:

Line 464: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

460: END;
461:
462: -- ----------------------------------------------------------------------
463: PROCEDURE Create_Activity_BOM(
464: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
465: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
466: p_material_copy_option IN NUMBER,
467:
468: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,

Line 647: ( p_item_error_tbl IN INV_Item_GRP.Error_Tbl_Type ,

643:
644: END;
645: -- ================================================================================
646: PROCEDURE Get_Errors
647: ( p_item_error_tbl IN INV_Item_GRP.Error_Tbl_Type ,
648: x_error_msg_old IN VARCHAR2,
649: x_error_msg_new OUT NOCOPY VARCHAR2
650: )
651: IS

Line 668: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,

664: -- ================================================================================
665:
666: -- ----------------------------------------------------------------------
667: PROCEDURE Create_Item(
668: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
669: p_template_id IN NUMBER := NULL,
670: p_template_name IN VARCHAR2 := NULL,
671:
672: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

Line 672: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

668: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
669: p_template_id IN NUMBER := NULL,
670: p_template_name IN VARCHAR2 := NULL,
671:
672: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
673: x_curr_item_return_status OUT NOCOPY VARCHAR2,
674: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
675:
676: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

Line 674: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

670: p_template_name IN VARCHAR2 := NULL,
671:
672: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
673: x_curr_item_return_status OUT NOCOPY VARCHAR2,
674: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
675:
676: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
677: x_master_item_return_status OUT NOCOPY VARCHAR2,
678: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type

Line 676: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

672: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
673: x_curr_item_return_status OUT NOCOPY VARCHAR2,
674: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
675:
676: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
677: x_master_item_return_status OUT NOCOPY VARCHAR2,
678: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
679: )
680: IS

Line 678: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type

674: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
675:
676: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
677: x_master_item_return_status OUT NOCOPY VARCHAR2,
678: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
679: )
680: IS
681: l_master_organization_id NUMBER;
682: l_curr_organization_id NUMBER;

Line 683: l_item_rec INV_Item_GRP.Item_rec_type;

679: )
680: IS
681: l_master_organization_id NUMBER;
682: l_curr_organization_id NUMBER;
683: l_item_rec INV_Item_GRP.Item_rec_type;
684: l_validate_org_ret_sts VARCHAR2(1);
685:
686: l_temp_org_id NUMBER;
687: l_temp_org_code VARCHAR2(3);

Line 689: -- local variables for calling INV_Item_GRP package

685:
686: l_temp_org_id NUMBER;
687: l_temp_org_code VARCHAR2(3);
688:
689: -- local variables for calling INV_Item_GRP package
690:
691: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
692: l_x_curr_item_return_status VARCHAR2(1);
693: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 691: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

687: l_temp_org_code VARCHAR2(3);
688:
689: -- local variables for calling INV_Item_GRP package
690:
691: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
692: l_x_curr_item_return_status VARCHAR2(1);
693: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
694:
695: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

Line 693: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

689: -- local variables for calling INV_Item_GRP package
690:
691: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
692: l_x_curr_item_return_status VARCHAR2(1);
693: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
694:
695: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
696: l_x_master_item_return_status VARCHAR2(1);
697: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 695: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

691: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
692: l_x_curr_item_return_status VARCHAR2(1);
693: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
694:
695: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
696: l_x_master_item_return_status VARCHAR2(1);
697: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
698: l_error_string VARCHAR(2000);
699:

Line 697: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

693: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
694:
695: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
696: l_x_master_item_return_status VARCHAR2(1);
697: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
698: l_error_string VARCHAR(2000);
699:
700: BEGIN
701: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.

Line 701: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.

697: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
698: l_error_string VARCHAR(2000);
699:
700: BEGIN
701: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.
702:
703: -- Copy input activity record to a working record
704: l_item_rec := p_asset_activity;
705:

Line 767: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');

763: l_item_rec.organization_id := l_master_organization_id;
764: l_item_rec.organization_code := NULL;
765:
766: EAM_ActivityUtilities_PVT.Write_Debug('Creating MASTER Item...');
767: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
768: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
769: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
770: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
771: INV_Item_GRP.Create_Item(

Line 771: INV_Item_GRP.Create_Item(

767: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
768: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
769: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
770: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
771: INV_Item_GRP.Create_Item(
772: p_Item_rec => l_item_rec,
773: p_Template_Id => p_template_id,
774: p_Template_Name => p_template_name,
775: x_Item_rec => l_x_master_item_rec,

Line 786: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');

782: x_master_item_error_tbl := l_x_master_item_error_tbl;
783:
784: -- log outputs
785: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
786: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
787: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
790: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);

Line 788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');

784: -- log outputs
785: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
786: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
787: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
790: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
791:
792: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');

785: EAM_ActivityUtilities_PVT.Write_Debug('l_x_master_item_return_status=' || l_x_master_item_return_status);
786: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (master item) >>>>>');
787: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_master_item_error_tbl);
788: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (master item) <<<<<');
789: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
790: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_master_item_rec);
791:
792: IF l_x_master_item_return_status <> FND_API.G_RET_STS_SUCCESS THEN
793: -- Create Item under master org fail, no use tyring to create it under child org.

Line 824: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');

820: END IF;
821: /*Bug#3269789 - end*/
822:
823: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
824: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
825: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
826: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
827: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
828: INV_Item_GRP.Create_Item(

Line 828: INV_Item_GRP.Create_Item(

824: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
825: EAM_ActivityUtilities_PVT.Write_Debug('p_template_id=' || p_template_id);
826: EAM_ActivityUtilities_PVT.Write_Debug('p_template_name=' || p_template_name);
827: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
828: INV_Item_GRP.Create_Item(
829: p_Item_rec => l_item_rec,
830: p_Template_Id => p_template_id,
831: p_Template_Name => p_template_name,
832: x_Item_rec => l_x_curr_item_rec,

Line 843: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');

839: x_curr_item_error_tbl := l_x_curr_item_error_tbl;
840:
841: -- log outputs
842: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
843: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
844: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
845: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
847: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);

Line 845: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');

841: -- log outputs
842: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
843: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
844: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
845: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
847: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
848:
849: -- ============================================================

Line 846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');

842: EAM_ActivityUtilities_PVT.Write_Debug('l_x_curr_item_return_status=' || l_x_curr_item_return_status);
843: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item (current item) >>>>>');
844: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_curr_item_error_tbl);
845: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item (current item) <<<<<');
846: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
847: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_curr_item_rec);
848:
849: -- ============================================================
850: EAM_ActivityUtilities_PVT.Write_Debug('-------- Finished EAM_Activity_PUB.Create_Item --------');

Line 864: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,

860: x_return_status OUT NOCOPY VARCHAR2 ,
861: x_msg_count OUT NOCOPY NUMBER ,
862: x_msg_data OUT NOCOPY VARCHAR2 ,
863:
864: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
865: p_template_id IN NUMBER := NULL,
866: p_template_name IN VARCHAR2 := NULL,
867: p_activity_type_code IN VARCHAR2 := NULL,
868: p_activity_cause_code IN VARCHAR2 := NULL,

Line 881: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

877:
878: -- x_inventory_item_id OUT NUMBER, -- the inventory_item_it the system has created
879: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
880:
881: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
882: x_curr_item_return_status OUT NOCOPY VARCHAR2,
883: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
884: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
885: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 883: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

879: x_work_order_rec OUT NOCOPY EAM_Activity_PUB.Work_Order_Rec_Type,
880:
881: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
882: x_curr_item_return_status OUT NOCOPY VARCHAR2,
883: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
884: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
885: x_master_item_return_status OUT NOCOPY VARCHAR2,
886: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
887:

Line 884: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

880:
881: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
882: x_curr_item_return_status OUT NOCOPY VARCHAR2,
883: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
884: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
885: x_master_item_return_status OUT NOCOPY VARCHAR2,
886: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
887:
888: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,

Line 886: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

882: x_curr_item_return_status OUT NOCOPY VARCHAR2,
883: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
884: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
885: x_master_item_return_status OUT NOCOPY VARCHAR2,
886: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
887:
888: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
889: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
890: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

Line 922: -- local variables for calling INV_Item_GRP package

918: -- local variables for validating source Work Order
919: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
920: l_x_work_order_ret_sts VARCHAR2(1);
921:
922: -- local variables for calling INV_Item_GRP package
923: l_asset_activity INV_Item_GRP.Item_rec_type;
924: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
925: l_x_curr_item_return_status VARCHAR2(1);
926: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 923: l_asset_activity INV_Item_GRP.Item_rec_type;

919: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
920: l_x_work_order_ret_sts VARCHAR2(1);
921:
922: -- local variables for calling INV_Item_GRP package
923: l_asset_activity INV_Item_GRP.Item_rec_type;
924: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
925: l_x_curr_item_return_status VARCHAR2(1);
926: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
927: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

Line 924: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

920: l_x_work_order_ret_sts VARCHAR2(1);
921:
922: -- local variables for calling INV_Item_GRP package
923: l_asset_activity INV_Item_GRP.Item_rec_type;
924: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
925: l_x_curr_item_return_status VARCHAR2(1);
926: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
927: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
928: l_x_master_item_return_status VARCHAR2(1);

Line 926: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

922: -- local variables for calling INV_Item_GRP package
923: l_asset_activity INV_Item_GRP.Item_rec_type;
924: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
925: l_x_curr_item_return_status VARCHAR2(1);
926: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
927: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
928: l_x_master_item_return_status VARCHAR2(1);
929: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
930:

Line 927: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

923: l_asset_activity INV_Item_GRP.Item_rec_type;
924: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
925: l_x_curr_item_return_status VARCHAR2(1);
926: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
927: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
928: l_x_master_item_return_status VARCHAR2(1);
929: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
930:
931: -- local variabels for calling BOM Business Object API

Line 929: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

925: l_x_curr_item_return_status VARCHAR2(1);
926: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
927: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
928: l_x_master_item_return_status VARCHAR2(1);
929: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
930:
931: -- local variabels for calling BOM Business Object API
932: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
933: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

Line 1032: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.

1028: p_association_copy_option
1029: );
1030:
1031: -- ============================================================
1032: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.
1033:
1034: l_asset_activity := p_asset_activity;
1035:
1036: -- Get org id from work order

Line 1306: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,

1302: x_msg_count OUT NOCOPY NUMBER ,
1303: x_msg_data OUT NOCOPY VARCHAR2 ,
1304:
1305: -- target activity, need to set org, item name, description
1306: p_asset_activity IN INV_Item_GRP.Item_Rec_Type,
1307:
1308:
1309: p_template_id IN NUMBER := NULL,
1310: p_template_name IN VARCHAR2 := NULL,

Line 1331: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

1327: p_bom_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
1328: p_routing_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
1329: p_association_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
1330:
1331: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1332: x_curr_item_return_status OUT NOCOPY VARCHAR2,
1333: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1334: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1335: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 1333: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

1329: p_association_copy_option IN NUMBER := 2, -- 1 (NONE) or 2 (ALL)
1330:
1331: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1332: x_curr_item_return_status OUT NOCOPY VARCHAR2,
1333: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1334: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1335: x_master_item_return_status OUT NOCOPY VARCHAR2,
1336: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1337:

Line 1334: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

1330:
1331: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1332: x_curr_item_return_status OUT NOCOPY VARCHAR2,
1333: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1334: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1335: x_master_item_return_status OUT NOCOPY VARCHAR2,
1336: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1337:
1338: x_assoc_return_status OUT NOCOPY VARCHAR2,

Line 1336: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

1332: x_curr_item_return_status OUT NOCOPY VARCHAR2,
1333: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1334: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
1335: x_master_item_return_status OUT NOCOPY VARCHAR2,
1336: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
1337:
1338: x_assoc_return_status OUT NOCOPY VARCHAR2,
1339: x_assoc_msg_count OUT NOCOPY NUMBER,
1340: x_assoc_msg_data OUT NOCOPY VARCHAR2,

Line 1355: -- local variables for calling INV_Item_GRP package

1351: -- local variables for validating source Work Order
1352: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1353: l_x_work_order_ret_sts VARCHAR2(1);
1354:
1355: -- local variables for calling INV_Item_GRP package
1356: l_asset_activity INV_Item_GRP.Item_rec_type;
1357: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
1358: l_x_curr_item_return_status VARCHAR2(1);
1359: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 1356: l_asset_activity INV_Item_GRP.Item_rec_type;

1352: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1353: l_x_work_order_ret_sts VARCHAR2(1);
1354:
1355: -- local variables for calling INV_Item_GRP package
1356: l_asset_activity INV_Item_GRP.Item_rec_type;
1357: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
1358: l_x_curr_item_return_status VARCHAR2(1);
1359: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
1360: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

Line 1357: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

1353: l_x_work_order_ret_sts VARCHAR2(1);
1354:
1355: -- local variables for calling INV_Item_GRP package
1356: l_asset_activity INV_Item_GRP.Item_rec_type;
1357: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
1358: l_x_curr_item_return_status VARCHAR2(1);
1359: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
1360: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
1361: l_x_master_item_return_status VARCHAR2(1);

Line 1359: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

1355: -- local variables for calling INV_Item_GRP package
1356: l_asset_activity INV_Item_GRP.Item_rec_type;
1357: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
1358: l_x_curr_item_return_status VARCHAR2(1);
1359: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
1360: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
1361: l_x_master_item_return_status VARCHAR2(1);
1362: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
1363:

Line 1360: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

1356: l_asset_activity INV_Item_GRP.Item_rec_type;
1357: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
1358: l_x_curr_item_return_status VARCHAR2(1);
1359: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
1360: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
1361: l_x_master_item_return_status VARCHAR2(1);
1362: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
1363:
1364: -- local variables for calling copy_bill API

Line 1362: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

1358: l_x_curr_item_return_status VARCHAR2(1);
1359: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
1360: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
1361: l_x_master_item_return_status VARCHAR2(1);
1362: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
1363:
1364: -- local variables for calling copy_bill API
1365: l_source_bom_sequence_id NUMBER;
1366: l_target_bom_sequence_id NUMBER;

Line 1464: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.

1460: p_association_copy_option
1461: );
1462:
1463: -- ============================================================
1464: -- Step 2: Create Asset Activity. Call INV_Item_GRP package.
1465:
1466: l_asset_activity := p_asset_activity;
1467:
1468: l_asset_activity.EAM_ACTIVITY_TYPE_CODE := p_activity_type_code;

Line 1906: l_asset_activity INV_Item_GRP.Item_Rec_Type;

1902: l_x_return_status VARCHAR2(1);
1903: l_x_msg_count NUMBER;
1904: l_x_msg_data VARCHAR2(20000);
1905:
1906: l_asset_activity INV_Item_GRP.Item_Rec_Type;
1907: l_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1908: l_x_inventory_item_id NUMBER;
1909: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1910:

Line 1912: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;

1908: l_x_inventory_item_id NUMBER;
1909: l_x_work_order_rec EAM_Activity_PUB.Work_Order_Rec_Type;
1910:
1911: -- output variables of inv package
1912: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
1913: l_x_curr_item_return_status VARCHAR2(1);
1914: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1915: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
1916: l_x_master_item_return_status VARCHAR2(1);

Line 1914: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

1910:
1911: -- output variables of inv package
1912: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
1913: l_x_curr_item_return_status VARCHAR2(1);
1914: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1915: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
1916: l_x_master_item_return_status VARCHAR2(1);
1917: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1918: -- output variables of Routing Business Object API

Line 1915: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;

1911: -- output variables of inv package
1912: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
1913: l_x_curr_item_return_status VARCHAR2(1);
1914: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1915: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
1916: l_x_master_item_return_status VARCHAR2(1);
1917: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1918: -- output variables of Routing Business Object API
1919: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

Line 1917: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

1913: l_x_curr_item_return_status VARCHAR2(1);
1914: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1915: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
1916: l_x_master_item_return_status VARCHAR2(1);
1917: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1918: -- output variables of Routing Business Object API
1919: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1920: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1921: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

Line 2125: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

2121: p_shutdown_type_code IN VARCHAR2 := NULL,
2122: p_notification_req_flag IN VARCHAR2 := NULL,
2123: p_activity_source_code IN VARCHAR2 := NULL,
2124:
2125: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2126: x_curr_item_return_status OUT NOCOPY VARCHAR2,
2127: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
2128: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2129: x_master_item_return_status OUT NOCOPY VARCHAR2,

Line 2127: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,

2123: p_activity_source_code IN VARCHAR2 := NULL,
2124:
2125: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2126: x_curr_item_return_status OUT NOCOPY VARCHAR2,
2127: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
2128: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2129: x_master_item_return_status OUT NOCOPY VARCHAR2,
2130: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
2131:

Line 2128: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,

2124:
2125: x_curr_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2126: x_curr_item_return_status OUT NOCOPY VARCHAR2,
2127: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
2128: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2129: x_master_item_return_status OUT NOCOPY VARCHAR2,
2130: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
2131:
2132: )

Line 2130: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type

2126: x_curr_item_return_status OUT NOCOPY VARCHAR2,
2127: x_curr_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
2128: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
2129: x_master_item_return_status OUT NOCOPY VARCHAR2,
2130: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type
2131:
2132: )
2133: IS
2134:

Line 2135: l_asset_activity INV_Item_GRP.Item_rec_type;

2131:
2132: )
2133: IS
2134:
2135: l_asset_activity INV_Item_GRP.Item_rec_type;
2136:
2137: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2138: l_api_version CONSTANT NUMBER := 1.0;
2139:

Line 2140: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

2136:
2137: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2138: l_api_version CONSTANT NUMBER := 1.0;
2139:
2140: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2141: l_x_curr_item_return_status VARCHAR2(1);
2142: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2143:
2144: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

Line 2142: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

2138: l_api_version CONSTANT NUMBER := 1.0;
2139:
2140: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2141: l_x_curr_item_return_status VARCHAR2(1);
2142: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2143:
2144: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2145: l_x_master_item_return_status VARCHAR2(1);
2146: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 2144: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

2140: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2141: l_x_curr_item_return_status VARCHAR2(1);
2142: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2143:
2144: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2145: l_x_master_item_return_status VARCHAR2(1);
2146: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2147:
2148: BEGIN

Line 2146: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

2142: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2143:
2144: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2145: l_x_master_item_return_status VARCHAR2(1);
2146: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2147:
2148: BEGIN
2149: -- Standard Start of API savepoint
2150: SAVEPOINT Create_Act_With_Templ_PUB;

Line 2195: -- Create Asset Activity. Call INV_Item_GRP package.

2191: EAM_ActivityUtilities_PVT.Write_Debug('p_segment20=' || p_segment20);
2192: EAM_ActivityUtilities_PVT.Write_Debug('p_description=' || p_description);
2193:
2194: -- ============================================================
2195: -- Create Asset Activity. Call INV_Item_GRP package.
2196:
2197: l_asset_activity.organization_id := p_organization_id;
2198: l_asset_activity.organization_code := p_organization_code;
2199:

Line 2348: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

2344:
2345:
2346: -- From Saurabh
2347: procedure create_bom_header(
2348: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2349: --p_source_org_id IN NUMBER,
2350: --p_source_activity_id IN NUMBER, -- inventory_item_id
2351:
2352: --p_material_copy_option IN NUMBER,

Line 2439: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

2435: x_bom_msg_list := l_x_bom_msg_list;
2436: end create_bom_header;
2437:
2438: procedure create_bom_header_form(
2439: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2440: p_inventory_item_name varchar2,
2441: p_organization_code varchar2,
2442: x_return_status OUT NOCOPY VARCHAR2
2443: )is

Line 2444: l_target_item_rec INV_Item_GRP.Item_Rec_Type;

2440: p_inventory_item_name varchar2,
2441: p_organization_code varchar2,
2442: x_return_status OUT NOCOPY VARCHAR2
2443: )is
2444: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2445: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2446: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2447: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2448: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;

Line 2521: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,

2517: p_shutdown_type_code IN VARCHAR2 := NULL,
2518: p_notification_req_flag IN VARCHAR2 := NULL,
2519: p_activity_source_code IN VARCHAR2 := NULL
2520:
2521: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2522: --x_curr_item_return_status OUT VARCHAR2,
2523: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
2524: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2525: --x_master_item_return_status OUT VARCHAR2,

Line 2523: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,

2519: p_activity_source_code IN VARCHAR2 := NULL
2520:
2521: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2522: --x_curr_item_return_status OUT VARCHAR2,
2523: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
2524: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2525: --x_master_item_return_status OUT VARCHAR2,
2526: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
2527: )is

Line 2524: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,

2520:
2521: --x_curr_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2522: --x_curr_item_return_status OUT VARCHAR2,
2523: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
2524: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2525: --x_master_item_return_status OUT VARCHAR2,
2526: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
2527: )is
2528: l_asset_activity INV_Item_GRP.Item_rec_type;

Line 2526: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type

2522: --x_curr_item_return_status OUT VARCHAR2,
2523: --x_curr_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type,
2524: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2525: --x_master_item_return_status OUT VARCHAR2,
2526: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
2527: )is
2528: l_asset_activity INV_Item_GRP.Item_rec_type;
2529:
2530: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';

Line 2528: l_asset_activity INV_Item_GRP.Item_rec_type;

2524: --x_master_item_rec OUT INV_Item_GRP.Item_Rec_Type,
2525: --x_master_item_return_status OUT VARCHAR2,
2526: --x_master_item_error_tbl OUT INV_Item_GRP.Error_Tbl_Type
2527: )is
2528: l_asset_activity INV_Item_GRP.Item_rec_type;
2529:
2530: l_api_name CONSTANT VARCHAR2(30) := 'Create_Activity_With_Template';
2531: l_api_version CONSTANT NUMBER := 1.0;
2532: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;

Line 2536: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;

2532: l_init_msg_list CONSTANT VARCHAR2(1) := FND_API.G_FALSE ;
2533: l_commit CONSTANT VARCHAR2(1) := FND_API.G_TRUE ;
2534: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2535:
2536: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2537: l_x_curr_item_return_status VARCHAR2(1);
2538: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2539:
2540: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

Line 2538: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;

2534: l_validation_level NUMBER := FND_API.G_VALID_LEVEL_FULL;
2535:
2536: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2537: l_x_curr_item_return_status VARCHAR2(1);
2538: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2539:
2540: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2541: l_x_master_item_return_status VARCHAR2(1);
2542: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

Line 2540: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

2536: l_x_curr_item_rec INV_Item_GRP.Item_rec_type;
2537: l_x_curr_item_return_status VARCHAR2(1);
2538: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2539:
2540: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2541: l_x_master_item_return_status VARCHAR2(1);
2542: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2543: l_msg_count number;
2544: l_msg_data varchar2(20000);

Line 2542: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

2538: l_x_curr_item_error_tbl INV_Item_GRP.Error_tbl_type;
2539:
2540: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2541: l_x_master_item_return_status VARCHAR2(1);
2542: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2543: l_msg_count number;
2544: l_msg_data varchar2(20000);
2545: begin
2546:

Line 2615: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

2611:
2612: end create_activity_with_template;
2613:
2614: PROCEDURE Create_Routing_Header(
2615: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2616:
2617: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2618: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2619: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

Line 2695: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,

2691:
2692: END Create_Routing_Header;
2693:
2694: procedure create_routing_header_form(
2695: --p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2696: p_inventory_item_name varchar2,
2697: p_organization_code varchar2,
2698: x_return_status OUT NOCOPY VARCHAR2
2699: )is

Line 2718: l_target_item_rec INV_Item_GRP.Item_Rec_Type;

2714: l_x_rtg_return_status VARCHAR2(1);
2715: l_x_rtg_msg_count NUMBER;
2716: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
2717:
2718: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2719:
2720: begin
2721: l_target_item_rec.item_number := p_inventory_item_name;
2722: l_target_item_rec.organization_code := p_organization_code;

Line 2799: l_asset_activity INV_Item_GRP.Item_Rec_Type;

2795: p_association_copy_option IN NUMBER := 2 -- 1 (NONE) or 2 (ALL)
2796:
2797: )
2798: is
2799: l_asset_activity INV_Item_GRP.Item_Rec_Type;
2800: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
2801: l_x_curr_item_return_status VARCHAR2(1);
2802: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2803: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;

Line 2800: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;

2796:
2797: )
2798: is
2799: l_asset_activity INV_Item_GRP.Item_Rec_Type;
2800: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
2801: l_x_curr_item_return_status VARCHAR2(1);
2802: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2803: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
2804: l_x_master_item_return_status VARCHAR2(1);

Line 2802: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

2798: is
2799: l_asset_activity INV_Item_GRP.Item_Rec_Type;
2800: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
2801: l_x_curr_item_return_status VARCHAR2(1);
2802: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2803: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
2804: l_x_master_item_return_status VARCHAR2(1);
2805: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2806:

Line 2803: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;

2799: l_asset_activity INV_Item_GRP.Item_Rec_Type;
2800: l_x_curr_item_rec INV_Item_GRP.Item_Rec_Type;
2801: l_x_curr_item_return_status VARCHAR2(1);
2802: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2803: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
2804: l_x_master_item_return_status VARCHAR2(1);
2805: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2806:
2807: l_x_assoc_return_status VARCHAR2(1);

Line 2805: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;

2801: l_x_curr_item_return_status VARCHAR2(1);
2802: l_x_curr_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2803: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
2804: l_x_master_item_return_status VARCHAR2(1);
2805: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
2806:
2807: l_x_assoc_return_status VARCHAR2(1);
2808: l_x_assoc_msg_count NUMBER;
2809: l_x_assoc_msg_data VARCHAR2(20000);

Line 2936: l_item_rec INV_Item_GRP.Item_rec_type;

2932: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2933:
2934:
2935: l_master_organization_id NUMBER;
2936: l_item_rec INV_Item_GRP.Item_rec_type;
2937:
2938: -- local variables for calling INV_Item_GRP package
2939:
2940: l_x_item_rec INV_Item_GRP.Item_rec_type;

Line 2938: -- local variables for calling INV_Item_GRP package

2934:
2935: l_master_organization_id NUMBER;
2936: l_item_rec INV_Item_GRP.Item_rec_type;
2937:
2938: -- local variables for calling INV_Item_GRP package
2939:
2940: l_x_item_rec INV_Item_GRP.Item_rec_type;
2941: l_x_return_status VARCHAR2(1);
2942: l_x_error_tbl INV_Item_GRP.Error_tbl_type;

Line 2940: l_x_item_rec INV_Item_GRP.Item_rec_type;

2936: l_item_rec INV_Item_GRP.Item_rec_type;
2937:
2938: -- local variables for calling INV_Item_GRP package
2939:
2940: l_x_item_rec INV_Item_GRP.Item_rec_type;
2941: l_x_return_status VARCHAR2(1);
2942: l_x_error_tbl INV_Item_GRP.Error_tbl_type;
2943: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2944: l_x_master_item_return_status VARCHAR2(1);

Line 2942: l_x_error_tbl INV_Item_GRP.Error_tbl_type;

2938: -- local variables for calling INV_Item_GRP package
2939:
2940: l_x_item_rec INV_Item_GRP.Item_rec_type;
2941: l_x_return_status VARCHAR2(1);
2942: l_x_error_tbl INV_Item_GRP.Error_tbl_type;
2943: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2944: l_x_master_item_return_status VARCHAR2(1);
2945: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2946: l_error_string VARCHAR2(2000);

Line 2943: l_x_master_item_rec INV_Item_GRP.Item_rec_type;

2939:
2940: l_x_item_rec INV_Item_GRP.Item_rec_type;
2941: l_x_return_status VARCHAR2(1);
2942: l_x_error_tbl INV_Item_GRP.Error_tbl_type;
2943: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2944: l_x_master_item_return_status VARCHAR2(1);
2945: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2946: l_error_string VARCHAR2(2000);
2947: l_msg_string VARCHAR2(200);

Line 2945: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;

2941: l_x_return_status VARCHAR2(1);
2942: l_x_error_tbl INV_Item_GRP.Error_tbl_type;
2943: l_x_master_item_rec INV_Item_GRP.Item_rec_type;
2944: l_x_master_item_return_status VARCHAR2(1);
2945: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
2946: l_error_string VARCHAR2(2000);
2947: l_msg_string VARCHAR2(200);
2948:
2949:

Line 3034: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');

3030: l_item_rec.bom_enabled_flag = fnd_api.g_MISS_CHAR THEN
3031: l_item_rec.bom_enabled_flag := 'Y';
3032: END IF;
3033:
3034: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3035: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3036:
3037:
3038: INV_Item_GRP.Create_Item

Line 3038: INV_Item_GRP.Create_Item

3034: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3035: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3036:
3037:
3038: INV_Item_GRP.Create_Item
3039: (
3040: p_Item_rec => l_item_rec,
3041: p_Template_Id => 19,
3042: p_Template_Name => null,

Line 3056: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');

3052: );
3053:
3054: -- log outputs
3055: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3056: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3057: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3058: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3059: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3060: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);

Line 3058: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');

3054: -- log outputs
3055: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3056: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3057: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3058: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3059: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3060: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3061:
3062: EXCEPTION

Line 3059: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');

3055: EAM_ActivityUtilities_PVT.Write_Debug('l_x_return_status=' || l_x_return_status);
3056: EAM_ActivityUtilities_PVT.Write_Debug('Results of INV_Item_GRP.Create_Item >>>>>');
3057: EAM_ActivityUtilities_PVT.Log_Item_Error_Tbl(l_x_error_tbl);
3058: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of INV_Item_GRP.Create_Item <<<<<');
3059: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< INV_Item_GRP.Create_Item OUTPUT Parameters <<<<<<<<<<<<<<<');
3060: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_x_item_rec);
3061:
3062: EXCEPTION
3063: WHEN NO_DATA_FOUND THEN

Line 3085: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');

3081: AND ROWNUM = 1;
3082:
3083: l_item_rec.organization_id := p_org_id;
3084: EAM_ActivityUtilities_PVT.Write_Debug('Creating CURRENT Item...');
3085: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> INV_Item_GRP.Create_Item INPUT Parameters >>>>>>>>>>>>>>>');
3086: EAM_ActivityUtilities_PVT.Log_Inv_Item_Rec(l_item_rec);
3087:
3088: Create_Item(
3089: p_asset_activity => l_item_rec,