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_UTIL

Line 79: l_application_id:= INV_EBI_UTIL.get_application_id(

75: SELECT change_order_type_id INTO l_change_order_type_id
76: FROM eng_engineering_changes
77: WHERE change_id = p_change_id;
78:
79: l_application_id:= INV_EBI_UTIL.get_application_id(
80: p_application_short_name => 'ENG'
81: );
82:
83: IF(l_application_id IS NULL ) THEN

Line 92: p_attr_group_type => INV_EBI_UTIL.G_ENG_CHANGEMGMT_GROUP,

88: END IF;
89:
90: INV_EBI_ITEM_HELPER.get_uda_attributes(
91: p_classification_id => l_change_order_type_id,
92: p_attr_group_type => INV_EBI_UTIL.G_ENG_CHANGEMGMT_GROUP,
93: p_application_id => l_application_id,
94: p_attr_grp_id_tbl => l_attr_group_id_tbl,
95: p_data_level => INV_EBI_UTIL.G_CHANGE_LEVEL,
96: p_revision_id => NULL,

Line 95: p_data_level => INV_EBI_UTIL.G_CHANGE_LEVEL,

91: p_classification_id => l_change_order_type_id,
92: p_attr_group_type => INV_EBI_UTIL.G_ENG_CHANGEMGMT_GROUP,
93: p_application_id => l_application_id,
94: p_attr_grp_id_tbl => l_attr_group_id_tbl,
95: p_data_level => INV_EBI_UTIL.G_CHANGE_LEVEL,
96: p_revision_id => NULL,
97: p_object_name => INV_EBI_UTIL.G_CHANGE_OBJ_NAME,
98: p_pk_data => l_pkdata,
99: x_uda_obj => x_change_uda,

Line 97: p_object_name => INV_EBI_UTIL.G_CHANGE_OBJ_NAME,

93: p_application_id => l_application_id,
94: p_attr_grp_id_tbl => l_attr_group_id_tbl,
95: p_data_level => INV_EBI_UTIL.G_CHANGE_LEVEL,
96: p_revision_id => NULL,
97: p_object_name => INV_EBI_UTIL.G_CHANGE_OBJ_NAME,
98: p_pk_data => l_pkdata,
99: x_uda_obj => x_change_uda,
100: x_uda_output_obj => l_uda_output_obj );
101:

Line 218: l_application_id:= INV_EBI_UTIL.get_application_id(

214: l_pkdata := EGO_COL_NAME_VALUE_PAIR_ARRAY();
215: l_pkdata.extend(1);
216: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',l_bill_sequence_id);
217:
218: l_application_id:= INV_EBI_UTIL.get_application_id(
219: p_application_short_name => 'BOM'
220: );
221: IF(l_application_id IS NULL ) THEN
222:

Line 231: p_attr_group_type => INV_EBI_UTIL.G_BOM_STRUCTUREMGMT_GROUP,

227: END IF;
228:
229: INV_EBI_ITEM_HELPER.get_uda_attributes(
230: p_classification_id => l_structure_type_id,
231: p_attr_group_type => INV_EBI_UTIL.G_BOM_STRUCTUREMGMT_GROUP,
232: p_application_id => l_application_id,
233: p_attr_grp_id_tbl => l_attr_group_id_tbl,
234: p_data_level => INV_EBI_UTIL.G_STRUCTURES_LEVEL,
235: p_revision_id => NULL,

Line 234: p_data_level => INV_EBI_UTIL.G_STRUCTURES_LEVEL,

230: p_classification_id => l_structure_type_id,
231: p_attr_group_type => INV_EBI_UTIL.G_BOM_STRUCTUREMGMT_GROUP,
232: p_application_id => l_application_id,
233: p_attr_grp_id_tbl => l_attr_group_id_tbl,
234: p_data_level => INV_EBI_UTIL.G_STRUCTURES_LEVEL,
235: p_revision_id => NULL,
236: p_object_name => INV_EBI_UTIL.G_BOM_STRUCTURE_OBJ_NAME,
237: p_pk_data => l_pkdata,
238: x_uda_obj => x_structure_header_uda,

Line 236: p_object_name => INV_EBI_UTIL.G_BOM_STRUCTURE_OBJ_NAME,

232: p_application_id => l_application_id,
233: p_attr_grp_id_tbl => l_attr_group_id_tbl,
234: p_data_level => INV_EBI_UTIL.G_STRUCTURES_LEVEL,
235: p_revision_id => NULL,
236: p_object_name => INV_EBI_UTIL.G_BOM_STRUCTURE_OBJ_NAME,
237: p_pk_data => l_pkdata,
238: x_uda_obj => x_structure_header_uda,
239: x_uda_output_obj => l_uda_output_obj
240: );

Line 397: l_application_id:= INV_EBI_UTIL.get_application_id(

393: l_pkdata.extend(2);
394: l_pkdata(1) := EGO_COL_NAME_VALUE_PAIR_OBJ('BILL_SEQUENCE_ID',l_bill_sequence_id);
395: l_pkdata(2) := EGO_COL_NAME_VALUE_PAIR_OBJ('COMPONENT_SEQUENCE_ID',l_component_sequence_id);
396:
397: l_application_id:= INV_EBI_UTIL.get_application_id(
398: p_application_short_name => 'BOM'
399: );
400:
401: IF(l_application_id IS NULL ) THEN

Line 410: p_attr_group_type => INV_EBI_UTIL.G_BOM_COMPONENTMGMT_GROUP,

406: END IF;
407:
408: INV_EBI_ITEM_HELPER.get_uda_attributes(
409: p_classification_id => l_structure_type_id,
410: p_attr_group_type => INV_EBI_UTIL.G_BOM_COMPONENTMGMT_GROUP,
411: p_application_id => l_application_id,
412: p_attr_grp_id_tbl => l_attr_group_id_tbl,
413: p_data_level => INV_EBI_UTIL.G_COMPONENTS_LEVEL,
414: p_revision_id => NULL,

Line 413: p_data_level => INV_EBI_UTIL.G_COMPONENTS_LEVEL,

409: p_classification_id => l_structure_type_id,
410: p_attr_group_type => INV_EBI_UTIL.G_BOM_COMPONENTMGMT_GROUP,
411: p_application_id => l_application_id,
412: p_attr_grp_id_tbl => l_attr_group_id_tbl,
413: p_data_level => INV_EBI_UTIL.G_COMPONENTS_LEVEL,
414: p_revision_id => NULL,
415: p_object_name => INV_EBI_UTIL.G_BOM_COMPONENTS_OBJ_NAME,
416: p_pk_data => l_pkdata,
417: x_uda_obj => x_comp_item_uda,

Line 415: p_object_name => INV_EBI_UTIL.G_BOM_COMPONENTS_OBJ_NAME,

411: p_application_id => l_application_id,
412: p_attr_grp_id_tbl => l_attr_group_id_tbl,
413: p_data_level => INV_EBI_UTIL.G_COMPONENTS_LEVEL,
414: p_revision_id => NULL,
415: p_object_name => INV_EBI_UTIL.G_BOM_COMPONENTS_OBJ_NAME,
416: p_pk_data => l_pkdata,
417: x_uda_obj => x_comp_item_uda,
418: x_uda_output_obj => l_uda_output_obj
419: );

Line 592: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components');

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;
595: CLOSE c_comp_sequence_id;
596:

Line 721: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components');

717: END LOOP;
718: END IF;
719:
720: x_component_item := l_component_item;
721: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components');
722:
723: EXCEPTION
724: WHEN FND_API.g_exc_unexpected_error THEN
725: IF c_Merged_Substitute_Comp%ISOPEN THEN

Line 860: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators');

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;
863: CLOSE c_comp_sequence_id;
864:

Line 980: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators');

976: END LOOP;
977: END IF;
978:
979: x_component_item := l_component_item;
980: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators');
981:
982: EXCEPTION
983: WHEN FND_API.g_exc_unexpected_error THEN
984: IF c_merged_ref_designators%ISOPEN THEN

Line 1240: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items');

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,
1243: org_id => p_reference_org_id
1244: ) = 'Y'

Line 1469: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items');

1465: CLOSE c_merged_component;
1466: END IF;
1467: END LOOP;
1468: END IF;
1469: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items');
1470: x_revised_item := l_revised_item;
1471:
1472:
1473: EXCEPTION

Line 1699: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');

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;
1702:
1703:

Line 1704: l_config_view_scope := INV_EBI_UTIL.get_config_param_value ( p_config_tbl => p_eco_obj.name_value_tbl

1700: l_context_org_code:= p_eco_obj.eco_change_order_type.organization_code;
1701: l_eco_obj := p_eco_obj;
1702:
1703:
1704: l_config_view_scope := INV_EBI_UTIL.get_config_param_value ( p_config_tbl => p_eco_obj.name_value_tbl
1705: ,p_config_param_name => 'REPLICATE_BOM_VIEW_SCOPE'
1706: );
1707:
1708:

Line 1709: l_config_impl_scope := INV_EBI_UTIL.get_config_param_value ( p_config_tbl => p_eco_obj.name_value_tbl

1705: ,p_config_param_name => 'REPLICATE_BOM_VIEW_SCOPE'
1706: );
1707:
1708:
1709: l_config_impl_scope := INV_EBI_UTIL.get_config_param_value ( p_config_tbl => p_eco_obj.name_value_tbl
1710: ,p_config_param_name => 'REPLICATE_BOM_IMPLEMENTATION_SCOPE'
1711: );
1712: IF l_eco_obj.eco_revised_item_type IS NOT NULL THEN
1713: FOR i IN 1..l_eco_obj.eco_revised_item_type.COUNT LOOP

Line 1846: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');

1842: END IF;
1843: END IF;
1844: END LOOP;
1845: END IF;
1846: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');
1847: x_eco_obj := l_eco_obj;
1848:
1849:
1850: EXCEPTION

Line 1901: INV_EBI_UTIL.transform_uda (

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 (
1902: p_uda_input_obj => p_uda_input_obj
1903: ,x_attributes_row_table => l_attributes_row_table
1904: ,x_attributes_data_table => l_attributes_data_table
1905: ,x_return_status => x_uda_output_obj.output_status.return_status

Line 2499: l_master_org := INV_EBI_UTIL.get_master_organization(

2495: ,p_item_number => p_item_name
2496: );
2497: IF (l_is_item_exists = FND_API.g_false) THEN
2498:
2499: l_master_org := INV_EBI_UTIL.get_master_organization(
2500: p_organization_id => p_organization_id
2501: );
2502: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
2503: p_organization_id => l_master_org

Line 2513: IF(INV_EBI_UTIL.is_pim_installed) THEN

2509: to true then item should be assigned to context org */
2510:
2511: IF(l_is_item_exists = FND_API.g_true ) THEN
2512: IF(get_assign_item = FND_API.g_true ) THEN
2513: IF(INV_EBI_UTIL.is_pim_installed) THEN
2514: SELECT item_catalog_group_id, approval_status
2515: INTO l_item_catalog_group_id, l_approval_status
2516: FROM mtl_system_items_kfv
2517: WHERE organization_id = l_master_org

Line 2630: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items');

2626: FND_MSG_PUB.add;
2627: RAISE FND_API.g_exc_error;
2628: END IF;
2629: END IF;
2630: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items');
2631: EXCEPTION
2632: WHEN FND_API.g_exc_unexpected_error THEN
2633: ROLLBACK TO inv_ebi_assign_item_save_pnt;
2634: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 2788: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco');

2784: l_status_name VARCHAR2(30);
2785:
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:

Line 3312: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING ENG_ECO_PUB.process_eco');

3308: END IF;
3309: l_revised_item_tbl_count := l_revised_item_tbl_count + 1;
3310: END LOOP;
3311: END IF;
3312: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING ENG_ECO_PUB.process_eco');
3313:
3314: --To create ECO
3315: ENG_ECO_PUB.process_eco (
3316: p_api_version_number => 1.0

Line 3341: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING ENG_ECO_PUB.process_eco');

3337: ,x_return_status => x_out.output_status.return_status
3338: ,x_msg_count => x_out.output_status.msg_count
3339: );
3340:
3341: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING ENG_ECO_PUB.process_eco');
3342: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
3343: RAISE FND_API.g_exc_unexpected_error;
3344: END IF;
3345:

Line 3357: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco');

3353:
3354: IF FND_API.to_boolean( p_commit ) THEN
3355: COMMIT;
3356: END IF;
3357: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco');
3358: EXCEPTION
3359: WHEN FND_API.g_exc_unexpected_error THEN
3360: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
3361: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

Line 3547: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');

3543: l_common_sub_comps c_common_sub_comps%ROWTYPE;
3544: BEGIN
3545: SAVEPOINT inv_ebi_comm_comp_save_pnt;
3546: x_return_status := FND_API.G_RET_STS_SUCCESS;
3547: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');
3548: SELECT
3549: bom_item_type,
3550: base_item_id,
3551: replenish_to_order_flag,

Line 3617: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');

3613: RAISE FND_API.g_exc_unexpected_error;
3614: END IF;
3615: END LOOP;
3616: CLOSE c_common_sub_comps ;
3617: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');
3618: EXCEPTION
3619: WHEN FND_API.g_exc_unexpected_error THEN
3620: ROLLBACK TO inv_ebi_comm_comp_save_pnt;
3621: IF (c_common_comps%ISOPEN) THEN

Line 3682: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');

3678:
3679: BEGIN
3680: SAVEPOINT inv_ebi_comm_bom_save_pnt;
3681: x_return_status := FND_API.G_RET_STS_SUCCESS;
3682: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');
3683: l_src_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3684: p_organization_code => p_common_organization_code
3685: );
3686: l_src_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

Line 3724: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');

3720:
3721: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3722: RAISE FND_API.g_exc_unexpected_error;
3723: END IF;
3724: INV_EBI_UTIL.debug_line('STEP: 20 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');
3725: EXCEPTION
3726: WHEN FND_API.g_exc_unexpected_error THEN
3727: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3728: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 3963: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header');

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(
3966: p_item_number => p_assembly_item_name,
3967: p_organization_code => p_organization_code,

Line 4045: AND (INV_EBI_UTIL.is_pim_installed) THEN

4041: l_bom_header_rec.structure_type_name := p_structure_header.structure_type_name ;
4042:
4043: IF(l_bom_header_rec.structure_type_name IS NULL OR
4044: l_bom_header_rec.structure_type_name = fnd_api.g_miss_char )
4045: AND (INV_EBI_UTIL.is_pim_installed) THEN
4046: IF p_name_val_list.name_value_table IS NOT NULL THEN
4047: FOR i in p_name_val_list.name_value_table.FIRST..p_name_val_list.name_value_table.LAST LOOP
4048: IF UPPER(p_name_val_list.name_value_table(i).param_name) = G_DEFAULT_STRUCTURE_TYPE THEN
4049: l_bom_header_rec.structure_type_name := p_name_val_list.name_value_table(i).param_value;

Line 4054: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING BOM_BO_PUB.process_bom');

4050: END IF;
4051: END LOOP;
4052: END IF;
4053: END IF;
4054: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING BOM_BO_PUB.process_bom');
4055:
4056: BOM_BO_PUB.process_bom
4057: (
4058: p_bom_header_rec => l_bom_header_rec

Line 4071: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING BOM_BO_PUB.process_bom');

4067: ,x_bom_sub_component_tbl => l_bom_sub_component_tbl
4068: ,x_return_status => x_out.output_status.return_status
4069: ,x_msg_count => x_out.output_status.msg_count
4070: );
4071: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING BOM_BO_PUB.process_bom');
4072: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4073: RAISE FND_API.g_exc_unexpected_error;
4074: END IF;
4075: IF FND_API.to_boolean( p_commit ) THEN

Line 4078: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header');

4074: END IF;
4075: IF FND_API.to_boolean( p_commit ) THEN
4076: COMMIT;
4077: END IF;
4078: INV_EBI_UTIL.debug_line('STEP: 40 END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header');
4079: EXCEPTION
4080: WHEN FND_API.g_exc_unexpected_error THEN
4081: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
4082: x_out.output_status.return_status := FND_API.g_ret_sts_error;

Line 5371: l_eco_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Change Order Name');

5367: FND_MSG_PUB.initialize();
5368: x_return_status := FND_API.G_RET_STS_SUCCESS;
5369:
5370: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5371: l_eco_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Change Order Name');
5372: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5373: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5374: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5375: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');

Line 5372: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');

5368: x_return_status := FND_API.G_RET_STS_SUCCESS;
5369:
5370: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5371: l_eco_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Change Order Name');
5372: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5373: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5374: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5375: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5376: IF l_from_date_str IS NOT NULL THEN

Line 5373: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');

5369:
5370: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5371: l_eco_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Change Order Name');
5372: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5373: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5374: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5375: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5376: IF l_from_date_str IS NOT NULL THEN
5377: l_from_date := TO_DATE(l_from_date_str,'YYYY/MM/DD HH24:MI:SS');

Line 5374: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');

5370: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
5371: l_eco_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Change Order Name');
5372: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5373: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5374: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5375: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5376: IF l_from_date_str IS NOT NULL THEN
5377: l_from_date := TO_DATE(l_from_date_str,'YYYY/MM/DD HH24:MI:SS');
5378: END IF;

Line 5375: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');

5371: l_eco_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Change Order Name');
5372: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');
5373: l_from_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'From Date');
5374: l_to_date_str := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'To Date');
5375: l_last_x_hrs := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Updated in the last X Hrs');
5376: IF l_from_date_str IS NOT NULL THEN
5377: l_from_date := TO_DATE(l_from_date_str,'YYYY/MM/DD HH24:MI:SS');
5378: END IF;
5379: IF l_to_date_str IS NOT NULL THEN