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_EBI_CHANGE_ORDER_HELPER dependencies on INV_EBI_OUTPUT_STATUS

Line 47: l_output_status inv_ebi_output_status;

43: l_application_id NUMBER;
44: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
45: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
46: l_uda_output_obj inv_ebi_eco_output_obj;
47: l_output_status inv_ebi_output_status;
48:
49: CURSOR c_attr_group_id IS
50:
51: SELECT DISTINCT attr_group_id

Line 57: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

53: WHERE change_id = p_change_id;
54:
55: BEGIN
56: x_return_status := FND_API.g_ret_sts_success;
57: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
58: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
59:
60: IF(p_change_id IS NOT NULL ) THEN
61:

Line 162: l_output_status inv_ebi_output_status;

158: l_application_id NUMBER;
159: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
160: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
161: l_uda_output_obj inv_ebi_eco_output_obj;
162: l_output_status inv_ebi_output_status;
163: l_structure_type_id NUMBER;
164: l_bill_sequence_id NUMBER;
165:
166: CURSOR c_attr_group_id(

Line 189: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

185:
186:
187: BEGIN
188: x_return_status := FND_API.g_ret_sts_success;
189: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
190: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
191:
192: IF( p_assembly_item_id IS NOT NULL AND
193: p_organization_id IS NOT NULL) THEN

Line 315: l_output_status inv_ebi_output_status;

311: l_application_id NUMBER;
312: l_attr_group_id_tbl FND_TABLE_OF_NUMBER;
313: l_pkdata EGO_COL_NAME_VALUE_PAIR_ARRAY;
314: l_uda_output_obj inv_ebi_eco_output_obj;
315: l_output_status inv_ebi_output_status;
316: l_structure_type_id NUMBER;
317: l_bill_sequence_id NUMBER;
318: l_component_item_id NUMBER;
319: l_component_sequence_id NUMBER;

Line 355: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

351: change_notice = p_eco_name;
352:
353: BEGIN
354: x_return_status := FND_API.g_ret_sts_success;
355: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
356: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
357:
358: IF( p_revised_item_id IS NOT NULL AND
359: p_organization_id IS NOT NULL) THEN

Line 588: l_output_status inv_ebi_output_status;

584: l_Found BOOLEAN;
585: l_merged_subst_comp c_Merged_Substitute_Comp%ROWTYPE;
586: l_substitute_comp_tbl inv_ebi_sub_comp_tbl;
587: l_sub_comp_count NUMBER := 1;
588: l_output_status inv_ebi_output_status;
589: BEGIN
590: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
591: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
592: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components');

Line 590: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

586: l_substitute_comp_tbl inv_ebi_sub_comp_tbl;
587: l_sub_comp_count NUMBER := 1;
588: l_output_status inv_ebi_output_status;
589: BEGIN
590: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
591: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
592: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components');
593: OPEN c_comp_sequence_id;
594: FETCH c_comp_sequence_id INTO l_component_sequence_id;

Line 855: l_output_status inv_ebi_output_status;

851: l_component_item inv_ebi_rev_comp_obj;
852: l_Found BOOLEAN;
853: l_ref_designator_tbl inv_ebi_ref_desg_tbl;
854: l_ref_dsgn_count NUMBER := 1;
855: l_output_status inv_ebi_output_status;
856:
857: BEGIN
858: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
859: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);

Line 858: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

854: l_ref_dsgn_count NUMBER := 1;
855: l_output_status inv_ebi_output_status;
856:
857: BEGIN
858: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
859: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
860: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators');
861: OPEN c_comp_sequence_id;
862: FETCH c_comp_sequence_id INTO l_component_sequence_id;

Line 1236: l_output_status inv_ebi_output_status;

1232: l_revised_item inv_ebi_revised_item_obj;
1233: l_found BOOLEAN;
1234: l_revised_comp_tbl inv_ebi_rev_comp_tbl;
1235: l_revised_comp_count NUMBER := 1;
1236: l_output_status inv_ebi_output_status;
1237: BEGIN
1238: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1239: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1240: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items');

Line 1238: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

1234: l_revised_comp_tbl inv_ebi_rev_comp_tbl;
1235: l_revised_comp_count NUMBER := 1;
1236: l_output_status inv_ebi_output_status;
1237: BEGIN
1238: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1239: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1240: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items');
1241: IF (bom_eamutil.enabled = 'Y'
1242: AND bom_eamutil.serial_effective_item (item_id => p_from_item_id,

Line 1693: l_output_status inv_ebi_output_status;

1689: l_reference_item_num mtl_system_items_kfv.concatenated_segments%TYPE;
1690: l_reference_org_code mtl_parameters.organization_code%TYPE;
1691: l_as_of_date DATE;
1692: l_alternate_bom_code bom_bill_of_materials.alternate_bom_designator%TYPE;
1693: l_output_status inv_ebi_output_status;
1694:
1695: BEGIN
1696: SAVEPOINT process_replicate_bom_save_pnt;
1697: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

Line 1697: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

1693: l_output_status inv_ebi_output_status;
1694:
1695: BEGIN
1696: SAVEPOINT process_replicate_bom_save_pnt;
1697: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1698: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1699: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');
1700: l_context_org_code:= p_eco_obj.eco_change_order_type.organization_code;
1701: l_eco_obj := p_eco_obj;

Line 1893: l_output_status inv_ebi_output_status;

1889: l_attributes_data_table ego_user_attr_data_table;
1890: l_attributes_row_obj ego_user_attr_row_obj;
1891: l_transaction_type VARCHAR2(20);
1892: l_uda_out inv_ebi_uda_output_obj;
1893: l_output_status inv_ebi_output_status;
1894: BEGIN
1895: SAVEPOINT inv_ebi_process_uda_save_pnt;
1896: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
1897: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

Line 1897: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

1893: l_output_status inv_ebi_output_status;
1894: BEGIN
1895: SAVEPOINT inv_ebi_process_uda_save_pnt;
1896: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
1897: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1898: x_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_uda_out);
1899:
1900: --To convert inv_ebi uda objects to ego uda compatible objects
1901: INV_EBI_UTIL.transform_uda (

Line 2027: l_output_status inv_ebi_output_status;

2023: l_return_status VARCHAR2(3);
2024: l_Error_Table Error_Handler.Error_Tbl_Type;
2025: l_count NUMBER:=0;
2026: l_uda_out inv_ebi_uda_output_obj;
2027: l_output_status inv_ebi_output_status;
2028: BEGIN
2029: SAVEPOINT inv_ebi_chg_order_uda_save_pnt;
2030:
2031: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);

Line 2032: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

2028: BEGIN
2029: SAVEPOINT inv_ebi_chg_order_uda_save_pnt;
2030:
2031: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
2032: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2033: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
2034:
2035: Error_Handler.initialize;
2036: IF(p_organization_code IS NOT NULL) THEN

Line 2770: l_output_status inv_ebi_output_status;

2766: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
2767: l_subst_comp_name mtl_system_items_kfv.concatenated_segments%TYPE;
2768: l_return_status VARCHAR2(10);
2769: l_msg_count NUMBER;
2770: l_output_status inv_ebi_output_status;
2771: l_status_type NUMBER;
2772: l_priority_code VARCHAR2(10);
2773: l_is_wf_Set BOOLEAN;
2774: l_approval_status NUMBER :=0;

Line 2790: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

2786: BEGIN
2787: SAVEPOINT inv_ebi_proc_eco_save_pnt;
2788: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco');
2789:
2790: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2791: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
2792:
2793: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
2794: l_pk_col_name_val_pairs.EXTEND(1);

Line 3845: l_output_status inv_ebi_output_status;

3841: p_component_item_tbl IN inv_ebi_rev_comp_tbl,
3842: x_out OUT NOCOPY inv_ebi_eco_output_obj
3843: ) IS
3844: l_common_orgs inv_ebi_org_tbl;
3845: l_output_status inv_ebi_output_status;
3846: l_count NUMBER;
3847: BEGIN
3848: SAVEPOINT inv_ebi_common_orgs_save_pnt;
3849: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

Line 3849: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

3845: l_output_status inv_ebi_output_status;
3846: l_count NUMBER;
3847: BEGIN
3848: SAVEPOINT inv_ebi_common_orgs_save_pnt;
3849: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3850: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
3851: l_common_orgs := inv_ebi_org_tbl();
3852:
3853: --Get the list of orgs to which particular bom is commoned

Line 3954: l_output_status inv_ebi_output_status;

3950: l_bom_revision_tbl bom_bo_pub.bom_revision_tbl_type;
3951: l_bom_component_tbl bom_bo_pub.bom_comps_tbl_type;
3952: l_bom_ref_designator_tbl bom_bo_pub.bom_ref_designator_tbl_type;
3953: l_bom_sub_component_tbl bom_bo_pub.bom_sub_component_tbl_type;
3954: l_output_status inv_ebi_output_status;
3955: l_is_bom_exists VARCHAR2(3);
3956: l_transaction_type VARCHAR2(20);
3957:
3958: BEGIN

Line 3961: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

3957:
3958: BEGIN
3959: SAVEPOINT inv_ebi_proc_bom_save_pnt;
3960:
3961: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
3962: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
3963: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header');
3964:
3965: l_is_bom_exists := is_bom_exists(