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.

[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on INV_EBI_ITEM_HELPER

Line 91: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');

87: FND_MESSAGE.set_token('COL_VALUE', 'ENG');
88: FND_MSG_PUB.add;
89: RAISE FND_API.g_exc_error;
90: END IF;
91: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');
92: INV_EBI_ITEM_HELPER.get_uda_attributes(
93: p_classification_id => l_change_order_type_id,
94: p_attr_group_type => INV_EBI_UTIL.G_ENG_CHANGEMGMT_GROUP,
95: p_application_id => l_application_id,

Line 92: INV_EBI_ITEM_HELPER.get_uda_attributes(

88: FND_MSG_PUB.add;
89: RAISE FND_API.g_exc_error;
90: END IF;
91: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');
92: INV_EBI_ITEM_HELPER.get_uda_attributes(
93: p_classification_id => l_change_order_type_id,
94: p_attr_group_type => INV_EBI_UTIL.G_ENG_CHANGEMGMT_GROUP,
95: p_application_id => l_application_id,
96: p_attr_grp_id_tbl => l_attr_group_id_tbl,

Line 103: INV_EBI_UTIL.debug_line('STEP 40: END CALLING INV_EBI_ITEM_HELPER.get_uda_attributes STATUS: '|| l_uda_output_obj.output_status.return_status);

99: p_object_name => INV_EBI_UTIL.G_CHANGE_OBJ_NAME,
100: p_pk_data => l_pkdata,
101: x_uda_obj => x_change_uda,
102: x_uda_output_obj => l_uda_output_obj );
103: INV_EBI_UTIL.debug_line('STEP 40: END CALLING INV_EBI_ITEM_HELPER.get_uda_attributes STATUS: '|| l_uda_output_obj.output_status.return_status);
104: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
105: x_msg_data := l_uda_output_obj.output_status.msg_data ;
106: RAISE FND_API.g_exc_unexpected_error;
107: END IF;

Line 233: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');

229: FND_MESSAGE.set_token('COL_VALUE', 'BOM');
230: FND_MSG_PUB.add;
231: RAISE FND_API.g_exc_error;
232: END IF;
233: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');
234: INV_EBI_ITEM_HELPER.get_uda_attributes(
235: p_classification_id => l_structure_type_id,
236: p_attr_group_type => INV_EBI_UTIL.G_BOM_STRUCTUREMGMT_GROUP,
237: p_application_id => l_application_id,

Line 234: INV_EBI_ITEM_HELPER.get_uda_attributes(

230: FND_MSG_PUB.add;
231: RAISE FND_API.g_exc_error;
232: END IF;
233: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');
234: INV_EBI_ITEM_HELPER.get_uda_attributes(
235: p_classification_id => l_structure_type_id,
236: p_attr_group_type => INV_EBI_UTIL.G_BOM_STRUCTUREMGMT_GROUP,
237: p_application_id => l_application_id,
238: p_attr_grp_id_tbl => l_attr_group_id_tbl,

Line 246: INV_EBI_UTIL.debug_line('STEP 40: END CALLING INV_EBI_ITEM_HELPER.get_uda_attributes STATUS: ' || l_uda_output_obj.output_status.return_status );

242: p_pk_data => l_pkdata,
243: x_uda_obj => x_structure_header_uda,
244: x_uda_output_obj => l_uda_output_obj
245: );
246: INV_EBI_UTIL.debug_line('STEP 40: END CALLING INV_EBI_ITEM_HELPER.get_uda_attributes STATUS: ' || l_uda_output_obj.output_status.return_status );
247: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
248: x_msg_data := l_uda_output_obj.output_status.msg_data ;
249: RAISE FND_API.g_exc_unexpected_error;
250: END IF;

Line 378: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

374: FETCH c_bom_count INTO l_bill_sequence_id,l_structure_type_id;
375:
376: IF(c_bom_count % ROWCOUNT > 0) THEN
377:
378: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
379: p_organization_id => p_organization_id
380: ,p_item_number => p_component_item_name
381: );
382: INV_EBI_UTIL.debug_line('STEP 30: COMPONENT ITEM ID: '|| l_component_item_id );

Line 416: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');

412: FND_MESSAGE.set_token('COL_VALUE', 'BOM');
413: FND_MSG_PUB.add;
414: RAISE FND_API.g_exc_error;
415: END IF;
416: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');
417: INV_EBI_ITEM_HELPER.get_uda_attributes(
418: p_classification_id => l_structure_type_id,
419: p_attr_group_type => INV_EBI_UTIL.G_BOM_COMPONENTMGMT_GROUP,
420: p_application_id => l_application_id,

Line 417: INV_EBI_ITEM_HELPER.get_uda_attributes(

413: FND_MSG_PUB.add;
414: RAISE FND_API.g_exc_error;
415: END IF;
416: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_ITEM_HELPER.get_uda_attributes');
417: INV_EBI_ITEM_HELPER.get_uda_attributes(
418: p_classification_id => l_structure_type_id,
419: p_attr_group_type => INV_EBI_UTIL.G_BOM_COMPONENTMGMT_GROUP,
420: p_application_id => l_application_id,
421: p_attr_grp_id_tbl => l_attr_group_id_tbl,

Line 429: INV_EBI_UTIL.debug_line('STEP 50: END CALLING INV_EBI_ITEM_HELPER.get_uda_attributes STATUS: '|| l_uda_output_obj.output_status.return_status);

425: p_pk_data => l_pkdata,
426: x_uda_obj => x_comp_item_uda,
427: x_uda_output_obj => l_uda_output_obj
428: );
429: INV_EBI_UTIL.debug_line('STEP 50: END CALLING INV_EBI_ITEM_HELPER.get_uda_attributes STATUS: '|| l_uda_output_obj.output_status.return_status);
430: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
431: x_msg_data := l_uda_output_obj.output_status.msg_data ;
432: RAISE FND_API.g_exc_unexpected_error;
433: END IF;

Line 869: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id (

865: ,p_config_param_name => 'REPLICATE_BOM_IMPLEMENTATION_SCOPE'
866: );
867: l_as_of_date := l_revised_item_obj.orignal_bom_reference.as_of_date;
868:
869: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id (
870: p_organization_code => p_eco_obj_list(i).eco_change_order_type.organization_code
871: );
872:
873: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id(

Line 873: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id(

869: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id (
870: p_organization_code => p_eco_obj_list(i).eco_change_order_type.organization_code
871: );
872:
873: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id(
874: p_organization_id => l_organization_id
875: ,p_item_number => p_eco_obj_list(i).eco_revised_item_type(j).revised_item_name
876: ) ;
877:

Line 2307: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

2303: l_revised_item1 inv_ebi_revised_item_obj;
2304: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;
2305: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;
2306: l_context_org_code mtl_parameters.organization_code%TYPE;
2307: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
2308: l_component_item inv_ebi_rev_comp_obj;
2309: l_component_item1 inv_ebi_rev_comp_obj;
2310: l_eco_obj inv_ebi_eco_obj;
2311: l_from_item_id NUMBER;

Line 2359: l_from_org_id := INV_EBI_ITEM_HELPER.get_organization_id( p_organization_code => l_reference_org_code);

2355:
2356: l_from_org_id := l_revised_item.orignal_bom_reference.organization_id;
2357: l_reference_org_code := l_revised_item.orignal_bom_reference.organization_code;
2358: IF l_from_org_id IS NULL OR l_from_org_id = fnd_api.g_miss_num THEN
2359: l_from_org_id := INV_EBI_ITEM_HELPER.get_organization_id( p_organization_code => l_reference_org_code);
2360: ELSIF l_reference_org_code IS NULL OR l_reference_org_code = fnd_api.g_miss_char THEN
2361: SELECT
2362: organization_code
2363: INTO

Line 2388: l_from_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_from_org_id

2384: organization_id = l_from_org_id;
2385: END IF;
2386:
2387: IF l_from_item_id IS NULL THEN
2388: l_from_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_from_org_id
2389: ,p_item_number => l_reference_item_num);
2390: INV_EBI_UTIL.debug_line('STEP 30: FROM ITEM ID: '|| l_from_item_id);
2391: END IF;
2392:

Line 2393: l_to_org_id := INV_EBI_ITEM_HELPER.get_organization_id ( p_organization_code => l_context_org_code);

2389: ,p_item_number => l_reference_item_num);
2390: INV_EBI_UTIL.debug_line('STEP 30: FROM ITEM ID: '|| l_from_item_id);
2391: END IF;
2392:
2393: l_to_org_id := INV_EBI_ITEM_HELPER.get_organization_id ( p_organization_code => l_context_org_code);
2394: l_to_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_to_org_id
2395: ,p_item_number => l_revised_item.revised_item_name) ;
2396: INV_EBI_UTIL.debug_line('STEP 40: TO ORG ID: '|| l_to_org_id || ' TO ITEM ID: '|| l_to_item_id);
2397: l_context_org_bom_exists := Is_BOM_Exists(

Line 2394: l_to_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_to_org_id

2390: INV_EBI_UTIL.debug_line('STEP 30: FROM ITEM ID: '|| l_from_item_id);
2391: END IF;
2392:
2393: l_to_org_id := INV_EBI_ITEM_HELPER.get_organization_id ( p_organization_code => l_context_org_code);
2394: l_to_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id ( p_organization_id => l_to_org_id
2395: ,p_item_number => l_revised_item.revised_item_name) ;
2396: INV_EBI_UTIL.debug_line('STEP 40: TO ORG ID: '|| l_to_org_id || ' TO ITEM ID: '|| l_to_item_id);
2397: l_context_org_bom_exists := Is_BOM_Exists(
2398: p_item_number => l_revised_item.revised_item_name

Line 2680: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

2676:
2677: Error_Handler.initialize;
2678: IF(p_organization_code IS NOT NULL) THEN
2679:
2680: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
2681: p_organization_code => p_organization_code
2682: );
2683: END IF;
2684: IF (p_revised_item_name IS NOT NULL) THEN

Line 2685: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

2681: p_organization_code => p_organization_code
2682: );
2683: END IF;
2684: IF (p_revised_item_name IS NOT NULL) THEN
2685: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2686: p_organization_id => l_organization_id
2687: ,p_item_number => p_revised_item_name
2688: );
2689:

Line 2698: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

2694: LOOP
2695: IF(p_component_tbl(i).component_revision_uda IS NOT NULL AND p_component_tbl(i).component_revision_uda.attribute_group_tbl.COUNT > 0) THEN
2696: IF(p_component_tbl(i).component_item_name IS NOT NULL) THEN
2697: INV_EBI_UTIL.debug_line('STEP 40: COMPONENT ITEM NAME: '|| p_component_tbl(i).component_item_name);
2698: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
2699: p_organization_id => l_organization_id
2700: ,p_item_number => p_component_tbl(i).component_item_name
2701: );
2702:

Line 3038: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id

3034:
3035: BEGIN
3036: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_existing_component_attr');
3037: -- To Retrive revisied item id
3038: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id
3039: (p_organization_id => p_organization_id
3040: ,p_item_number => p_revised_item_name);
3041: INV_EBI_UTIL.debug_line('STEP 20: ASSY ITEM ID: ' || l_assembly_item_id);
3042:

Line 3070: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id

3066: EXIT;
3067: END LOOP;
3068:
3069: --To Retrive Component Item Id
3070: l_component_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id
3071: ( p_organization_id => p_organization_id
3072: ,p_item_number => p_component_item_name);
3073:
3074: INV_EBI_UTIL.debug_line('STEP 60: COMP ITEM ID: '|| l_component_item_id);

Line 3325: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(

3321: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items');
3322: INV_EBI_UTIL.debug_line('STEP 20: ORG ID : '|| p_organization_id || ' ITEM NAME: '|| p_item_name);
3323:
3324: x_return_status := FND_API.G_RET_STS_SUCCESS;
3325: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
3326: p_organization_id => p_organization_id
3327: ,p_item_number => p_item_name
3328: );
3329: IF (l_is_item_exists = FND_API.g_false) THEN

Line 3334: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(

3330:
3331: l_master_org := INV_EBI_UTIL.get_master_organization(
3332: p_organization_id => p_organization_id
3333: );
3334: l_is_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
3335: p_organization_id => l_master_org
3336: ,p_item_number => p_item_name
3337: );
3338:

Line 3351: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'

3347: INTO l_item_catalog_group_id, l_approval_status
3348: FROM mtl_system_items_kfv
3349: WHERE organization_id = l_master_org
3350: AND concatenated_segments = p_item_name;
3351: IF (INV_EBI_ITEM_HELPER.is_new_item_request_reqd( l_item_catalog_group_id ) = FND_API.g_true) AND l_approval_status <> 'A'
3352: THEN
3353: FND_MSG_PUB.initialize();
3354: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_APROVAL_STS');
3355: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);

Line 3375: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

3371: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING EGO_ITEM_PUB.assign_item_to_org STATUS: ' || x_return_status);
3372: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3373: RAISE FND_API.g_exc_unexpected_error;
3374: END IF;
3375: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
3376: p_organization_id => l_master_org
3377: ,p_item_number => p_item_name
3378: );
3379: INV_EBI_UTIL.debug_line('STEP 50: INV ITEM ID: '||l_inventory_item_id);

Line 3871: l_src_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

3867: x_return_status := FND_API.G_RET_STS_SUCCESS;
3868: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom');
3869: INV_EBI_UTIL.debug_line('STEP 20: ORG CODE : '|| p_organization_code || ' ASSY ITEM NAME: '|| p_assembly_item_name ||
3870: ' COMMON ASSY ITEM NAME: '|| p_common_assembly_item_name || ' COMMON ORG CODE: '|| p_common_organization_code);
3871: l_src_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3872: p_organization_code => p_common_organization_code
3873: );
3874: l_src_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
3875: p_organization_id => l_src_organization_id

Line 3874: l_src_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

3870: ' COMMON ASSY ITEM NAME: '|| p_common_assembly_item_name || ' COMMON ORG CODE: '|| p_common_organization_code);
3871: l_src_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3872: p_organization_code => p_common_organization_code
3873: );
3874: l_src_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
3875: p_organization_id => l_src_organization_id
3876: ,p_item_number => p_common_assembly_item_name
3877: );
3878: l_src_bill_sequence_id := get_bill_sequence_id(

Line 3892: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

3888: FND_MSG_PUB.add;
3889: RAISE FND_API.g_exc_error;
3890: END IF;
3891:
3892: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3893: p_organization_code => p_organization_code
3894: );
3895:
3896: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

Line 3896: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

3892: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3893: p_organization_code => p_organization_code
3894: );
3895:
3896: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
3897: p_organization_id => l_organization_id
3898: ,p_item_number => p_assembly_item_name
3899: );
3900: INV_EBI_UTIL.debug_line('STEP 40: ASST ITEM ID: '|| l_assembly_item_id || 'ORG ID: '|| l_organization_id );

Line 3986: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(

3982: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs');
3983: INV_EBI_UTIL.debug_line('STEP 20: ASSY ITEM NAME: '|| p_assembly_item_name ||' ORG CODE: '|| p_organization_code);
3984:
3985: x_return_status := FND_API.G_RET_STS_SUCCESS;
3986: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3987: p_organization_code => p_organization_code
3988: );
3989:
3990: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

Line 3990: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

3986: l_organization_id := INV_EBI_ITEM_HELPER.get_organization_id(
3987: p_organization_code => p_organization_code
3988: );
3989:
3990: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
3991: p_organization_id => l_organization_id
3992: ,p_item_number => p_assembly_item_name);
3993:
3994: l_bill_sequence_id := get_bill_sequence_id(

Line 4176: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;

4172: l_inventory_item_id NUMBER;
4173: l_organization_id NUMBER;
4174: l_component_item_name VARCHAR2(240);
4175: l_master_org NUMBER;
4176: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
4177: l_subst_comp_name mtl_system_items_kfv.concatenated_segments%TYPE;
4178: l_return_status VARCHAR2(10);
4179: l_msg_count NUMBER;
4180: l_output_status inv_ebi_output_status;

Line 4206: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

4202:
4203: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
4204: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
4205:
4206: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
4207: l_pk_col_name_val_pairs.EXTEND(1);
4208: l_pk_col_name_val_pairs(1).name := 'organization_code';
4209: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
4210:

Line 4211: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(

4207: l_pk_col_name_val_pairs.EXTEND(1);
4208: l_pk_col_name_val_pairs(1).name := 'organization_code';
4209: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
4210:
4211: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
4212: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
4213: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
4214: );
4215: l_pk_col_name_val_pairs.TRIM(1);

Line 4213: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION

4209: l_pk_col_name_val_pairs(1).value := p_change_order.organization_code;
4210:
4211: l_organization_id := INV_EBI_ITEM_HELPER.value_to_id(
4212: p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
4213: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
4214: );
4215: l_pk_col_name_val_pairs.TRIM(1);
4216:
4217: IF (l_organization_id IS NULL) THEN

Line 4387: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (

4383: END IF;
4384: IF(p_revised_item_type_tbl IS NOT NULL AND p_revised_item_type_tbl.COUNT > 0) THEN
4385: FOR i IN p_revised_item_type_tbl.FIRST..p_revised_item_type_tbl.LAST
4386: LOOP
4387: l_inventory_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id (
4388: p_organization_id => l_organization_id
4389: ,p_item_number => p_revised_item_type_tbl(i).revised_item_name
4390: );
4391: -- To get effectivty date of recently created revision Bug 7197943

Line 5837: INV_EBI_ITEM_HELPER.get_Operating_unit

5833: ,NULL
5834: ,NULL
5835: ,NULL
5836: );
5837: INV_EBI_ITEM_HELPER.get_Operating_unit
5838: (p_oranization_id => ri.organization_id
5839: ,x_operating_unit => l_item_obj.operating_unit
5840: ,x_ouid => l_item_obj.operating_unit_id
5841: );

Line 6044: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);

6040: INV_EBI_UTIL.debug_line('STEP 20: ORG CODES'||p_org_codes);
6041: l_eco_output_tbl := inv_ebi_change_id_obj_tbl();
6042:
6043: IF p_org_codes IS NOT NULL THEN
6044: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);
6045: END IF;
6046:
6047: IF p_eco_tbl IS NOT NULL AND p_eco_tbl.COUNT>0 THEN
6048: FOR i in p_eco_tbl.FIRST..p_eco_tbl.LAST LOOP

Line 6079: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.filter_ecos_based_on_org';

6075: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.filter_ecos_based_on_org STATUS: '|| x_return_status);
6076: EXCEPTION
6077: WHEN OTHERS THEN
6078: x_return_status := FND_API.g_ret_sts_unexp_error;
6079: x_msg_data := SQLERRM ||' at INV_EBI_ITEM_HELPER.filter_ecos_based_on_org';
6080: END filter_ecos_based_on_org;
6081:
6082: /***************************************************************************************************
6083: -- API name : parse_and_get_eco

Line 6109: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;

6105: l_eco_tbl FND_TABLE_OF_VARCHAR2_255;
6106: l_org_tbl FND_TABLE_OF_VARCHAR2_255;
6107: l_valid_eco_tbl FND_TABLE_OF_VARCHAR2_255;
6108: l_valid_org_tbl FND_TABLE_OF_VARCHAR2_255;
6109: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl ;
6110: CURSOR c_get_all_orgs( p_chg_notice VARCHAR2) IS
6111: SELECT change_id
6112: FROM eng_engineering_changes
6113: WHERE change_notice = p_chg_notice;

Line 6122: l_eco_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_eco_names);

6118: INV_EBI_UTIL.debug_line('STEP 30: ORG CODE NAMES '|| p_org_codes);
6119: l_eco_output_tbl :=inv_ebi_change_id_obj_tbl();
6120:
6121: IF p_eco_names IS NOT NULL THEN
6122: l_eco_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_eco_names);
6123: END IF;
6124:
6125: IF p_org_codes IS NOT NULL THEN
6126: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);

Line 6126: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);

6122: l_eco_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_eco_names);
6123: END IF;
6124:
6125: IF p_org_codes IS NOT NULL THEN
6126: l_org_tbl := INV_EBI_ITEM_HELPER.parse_input_string(p_org_codes);
6127: END IF;
6128:
6129: IF l_eco_tbl IS NOT NULL AND l_eco_tbl.COUNT > 0 THEN
6130: l_valid_eco_tbl := FND_TABLE_OF_VARCHAR2_255();

Line 6204: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();

6200: FND_MSG_PUB.initialize();
6201: l_count :=0;
6202: IF l_valid_org_tbl IS NOT NULL AND l_valid_org_tbl.COUNT > 0 THEN
6203: FOR j in l_valid_org_tbl.FIRST..l_valid_org_tbl.LAST LOOP
6204: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
6205: l_pk_col_name_val_pairs.EXTEND();
6206: l_pk_col_name_val_pairs(1).name := 'organization_code';
6207: l_pk_col_name_val_pairs(1).value := l_valid_org_tbl(j);
6208: l_org_id := INV_EBI_ITEM_HELPER.value_to_id( p_pk_col_name_val_pairs => l_pk_col_name_val_pairs

Line 6208: l_org_id := INV_EBI_ITEM_HELPER.value_to_id( p_pk_col_name_val_pairs => l_pk_col_name_val_pairs

6204: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
6205: l_pk_col_name_val_pairs.EXTEND();
6206: l_pk_col_name_val_pairs(1).name := 'organization_code';
6207: l_pk_col_name_val_pairs(1).value := l_valid_org_tbl(j);
6208: l_org_id := INV_EBI_ITEM_HELPER.value_to_id( p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
6209: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
6210: );
6211: l_pk_col_name_val_pairs.TRIM(1);
6212:

Line 6209: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION

6205: l_pk_col_name_val_pairs.EXTEND();
6206: l_pk_col_name_val_pairs(1).name := 'organization_code';
6207: l_pk_col_name_val_pairs(1).value := l_valid_org_tbl(j);
6208: l_org_id := INV_EBI_ITEM_HELPER.value_to_id( p_pk_col_name_val_pairs => l_pk_col_name_val_pairs
6209: ,p_entity_name => INV_EBI_ITEM_HELPER.G_ORGANIZATION
6210: );
6211: l_pk_col_name_val_pairs.TRIM(1);
6212:
6213: l_chg_id := NULL;

Line 6371: l_from_date :=INV_EBI_ITEM_HELPER.get_last_run_date( p_conc_prog_id => p_prog_id

6367: END IF;
6368: END IF;
6369:
6370: IF (l_eco_string IS NULL AND l_from_date IS NULL AND l_to_date IS NULL AND l_last_x_hrs IS NULL) THEN
6371: l_from_date :=INV_EBI_ITEM_HELPER.get_last_run_date( p_conc_prog_id => p_prog_id
6372: ,p_appl_id => p_appl_id
6373: );
6374: INV_EBI_UTIL.debug_line('STEP 110: FROM DATE IF ALL THE PARAMETERS ARE NULL'|| l_from_date);
6375: l_to_date := SYSDATE;