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 FND_API

Line 58: x_return_status := FND_API.g_ret_sts_success;

54:
55: BEGIN
56: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ');
57: INV_EBI_UTIL.debug_line('STEP 20: ECO NUMBER: '|| p_change_id);
58: x_return_status := FND_API.g_ret_sts_success;
59: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
60: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
61:
62: IF(p_change_id IS NOT NULL ) THEN

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

55: BEGIN
56: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ');
57: INV_EBI_UTIL.debug_line('STEP 20: ECO NUMBER: '|| p_change_id);
58: x_return_status := FND_API.g_ret_sts_success;
59: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
60: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
61:
62: IF(p_change_id IS NOT NULL ) THEN
63:

Line 89: RAISE FND_API.g_exc_error;

85: IF(l_application_id IS NULL ) THEN
86: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
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,

Line 104: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;
108: END IF;

Line 106: RAISE FND_API.g_exc_unexpected_error;

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;
108: END IF;
109: END IF;
110: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ');

Line 112: WHEN FND_API.g_exc_unexpected_error THEN

108: END IF;
109: END IF;
110: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ');
111: EXCEPTION
112: WHEN FND_API.g_exc_unexpected_error THEN
113:
114: IF c_attr_group_id%ISOPEN THEN
115: CLOSE c_attr_group_id;
116: END IF;

Line 118: x_return_status := FND_API.g_ret_sts_unexp_error;

114: IF c_attr_group_id%ISOPEN THEN
115: CLOSE c_attr_group_id;
116: END IF;
117:
118: x_return_status := FND_API.g_ret_sts_unexp_error;
119: IF(x_msg_data IS NULL) THEN
120: fnd_msg_pub.count_and_get(
121: p_encoded => FND_API.g_false
122: ,p_count => x_msg_count

Line 121: p_encoded => FND_API.g_false

117:
118: x_return_status := FND_API.g_ret_sts_unexp_error;
119: IF(x_msg_data IS NULL) THEN
120: fnd_msg_pub.count_and_get(
121: p_encoded => FND_API.g_false
122: ,p_count => x_msg_count
123: ,p_data => x_msg_data
124: );
125: END IF;

Line 132: x_return_status := FND_API.g_ret_sts_unexp_error;

128: IF c_attr_group_id%ISOPEN THEN
129: CLOSE c_attr_group_id;
130: END IF;
131:
132: x_return_status := FND_API.g_ret_sts_unexp_error;
133: IF (x_msg_data IS NOT NULL) THEN
134: x_msg_data := x_msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ';
135: ELSE
136: x_msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ';

Line 187: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

183: FROM bom_bill_of_materials
184: WHERE
185: assembly_item_id = p_assembly_item_id
186: AND organization_id = p_organization_id
187: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
188:
189:
190: BEGIN
191: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda');

Line 193: x_return_status := FND_API.g_ret_sts_success;

189:
190: BEGIN
191: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda');
192: INV_EBI_UTIL.debug_line('STEP 20: ASSY ITEM ID :' || p_assembly_item_id || 'ORG ID: '|| p_organization_id );
193: x_return_status := FND_API.g_ret_sts_success;
194: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
195: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
196:
197: IF( p_assembly_item_id IS NOT NULL AND

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

190: BEGIN
191: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda');
192: INV_EBI_UTIL.debug_line('STEP 20: ASSY ITEM ID :' || p_assembly_item_id || 'ORG ID: '|| p_organization_id );
193: x_return_status := FND_API.g_ret_sts_success;
194: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
195: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
196:
197: IF( p_assembly_item_id IS NOT NULL AND
198: p_organization_id IS NOT NULL) THEN

Line 231: RAISE FND_API.g_exc_error;

227:
228: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
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,

Line 247: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;
251: END IF;

Line 249: RAISE FND_API.g_exc_unexpected_error;

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;
251: END IF;
252: CLOSE c_attr_group_id;
253: END IF;

Line 258: WHEN FND_API.g_exc_unexpected_error THEN

254: CLOSE c_bom_count;
255: END IF;
256: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda');
257: EXCEPTION
258: WHEN FND_API.g_exc_unexpected_error THEN
259:
260: IF c_attr_group_id%ISOPEN THEN
261: CLOSE c_attr_group_id;
262: END IF;

Line 268: x_return_status := FND_API.g_ret_sts_unexp_error;

264: IF c_bom_count%ISOPEN THEN
265: CLOSE c_bom_count;
266: END IF;
267:
268: x_return_status := FND_API.g_ret_sts_unexp_error;
269: IF(x_msg_data IS NULL) THEN
270: fnd_msg_pub.count_and_get(
271: p_encoded => FND_API.g_false
272: ,p_count => x_msg_count

Line 271: p_encoded => FND_API.g_false

267:
268: x_return_status := FND_API.g_ret_sts_unexp_error;
269: IF(x_msg_data IS NULL) THEN
270: fnd_msg_pub.count_and_get(
271: p_encoded => FND_API.g_false
272: ,p_count => x_msg_count
273: ,p_data => x_msg_data
274: );
275: END IF;

Line 286: x_return_status := FND_API.g_ret_sts_unexp_error;

282: IF c_bom_count%ISOPEN THEN
283: CLOSE c_bom_count;
284: END IF;
285:
286: x_return_status := FND_API.g_ret_sts_unexp_error;
287: IF (x_msg_data IS NOT NULL) THEN
288: x_msg_data := x_msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda ';
289: ELSE
290: x_msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda ';

Line 345: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

341: FROM bom_bill_of_materials
342: WHERE
343: assembly_item_id = p_revised_item_id
344: AND organization_id = p_organization_id
345: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
346:
347: CURSOR c_comp_count(
348: p_bill_sequence_id NUMBER,
349: p_component_item_id NUMBER

Line 362: x_return_status := FND_API.g_ret_sts_success;

358: BEGIN
359: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda');
360: INV_EBI_UTIL.debug_line('STEP 20: ECO NAME: '|| p_eco_name || 'REVISED ITEM ID: '|| p_revised_item_id ||
361: 'COMPONENT NAME: '|| p_component_item_name ||'ORG ID: ' || p_organization_id);
362: x_return_status := FND_API.g_ret_sts_success;
363: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
364: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
365:
366: IF( p_revised_item_id IS NOT NULL AND

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

359: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda');
360: INV_EBI_UTIL.debug_line('STEP 20: ECO NAME: '|| p_eco_name || 'REVISED ITEM ID: '|| p_revised_item_id ||
361: 'COMPONENT NAME: '|| p_component_item_name ||'ORG ID: ' || p_organization_id);
362: x_return_status := FND_API.g_ret_sts_success;
363: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
364: l_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
365:
366: IF( p_revised_item_id IS NOT NULL AND
367: p_organization_id IS NOT NULL) THEN

Line 414: RAISE FND_API.g_exc_error;

410: IF(l_application_id IS NULL ) THEN
411: FND_MESSAGE.set_name('INV','INV_EBI_APP_INVALID');
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,

Line 430: IF(l_uda_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;
434: END IF;

Line 432: RAISE FND_API.g_exc_unexpected_error;

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;
434: END IF;
435: CLOSE c_attr_group_id;
436: END IF;

Line 443: WHEN FND_API.g_exc_unexpected_error THEN

439: CLOSE c_bom_count;
440: END IF;
441: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda');
442: EXCEPTION
443: WHEN FND_API.g_exc_unexpected_error THEN
444:
445: IF c_attr_group_id%ISOPEN THEN
446: CLOSE c_attr_group_id;
447: END IF;

Line 457: x_return_status := FND_API.g_ret_sts_unexp_error;

453: IF c_comp_count%ISOPEN THEN
454: CLOSE c_comp_count;
455: END IF;
456:
457: x_return_status := FND_API.g_ret_sts_unexp_error;
458: IF(x_msg_data IS NULL) THEN
459: fnd_msg_pub.count_and_get(
460: p_encoded => FND_API.g_false
461: ,p_count => x_msg_count

Line 460: p_encoded => FND_API.g_false

456:
457: x_return_status := FND_API.g_ret_sts_unexp_error;
458: IF(x_msg_data IS NULL) THEN
459: fnd_msg_pub.count_and_get(
460: p_encoded => FND_API.g_false
461: ,p_count => x_msg_count
462: ,p_data => x_msg_data
463: );
464: END IF;

Line 479: x_return_status := FND_API.g_ret_sts_unexp_error;

475: IF c_comp_count%ISOPEN THEN
476: CLOSE c_comp_count;
477: END IF;
478:
479: x_return_status := FND_API.g_ret_sts_unexp_error;
480: IF (x_msg_data IS NOT NULL) THEN
481: x_msg_data := x_msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda ';
482: ELSE
483: x_msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda ';

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

550: l_output_status inv_ebi_output_status;
551:
552: BEGIN
553:
554: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
555: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
556:
557: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info');
558: l_component_item := p_component_item;

Line 592: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

588: x_component_item := l_component_item;
589: EXCEPTION
590: WHEN OTHERS THEN
591:
592: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
593: IF (x_out.output_status.msg_data IS NOT NULL) THEN
594: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info ';
595: ELSE
596: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info ';

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

616: l_component_item inv_ebi_rev_comp_obj;
617: l_ref_desg_count NUMBER := 0;
618: BEGIN
619:
620: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
621: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
622: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg');
623: l_component_item := p_component_item;
624:

Line 658: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

654: x_component_item := l_component_item;
655: EXCEPTION
656: WHEN OTHERS THEN
657:
658: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
659: IF (x_out.output_status.msg_data IS NOT NULL) THEN
660: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg ';
661: ELSE
662: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg ';

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

692: l_is_sub_comp_tbl_new BOOLEAN := FALSE;
693: l_is_ref_desg_tbl_new BOOLEAN := FALSE;
694:
695: BEGIN
696: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
697: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
698:
699: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info');
700: l_dest_component_item := p_dest_component_item;

Line 798: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

794: x_dest_component_item := l_dest_component_item;
795: EXCEPTION
796:
797: WHEN OTHERS THEN
798: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
799: IF (x_out.output_status.msg_data IS NOT NULL) THEN
800: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info ';
801: ELSE
802: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info ';

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

833: l_is_comp_tbl_new BOOLEAN := FALSE;
834:
835: BEGIN
836:
837: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
838: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
839:
840: l_revised_item_obj := p_revised_item_obj;
841: l_comp_item_tbl := inv_ebi_rev_comp_tbl();

Line 888: OR p_eco_obj_list(i).eco_revised_item_type(j).start_effective_date = fnd_api.g_miss_date

884: l_effectivity_date := SYSDATE;
885: END IF;
886:
887: IF( p_eco_obj_list(i).eco_revised_item_type(j).start_effective_date IS NULL
888: OR p_eco_obj_list(i).eco_revised_item_type(j).start_effective_date = fnd_api.g_miss_date
889: OR p_eco_obj_list(i).eco_revised_item_type(j).start_effective_date < l_effectivity_date)
890: THEN
891: l_rev_item_eff_date := l_effectivity_date;
892: ELSE

Line 896: IF (l_as_of_date IS NULL OR l_as_of_date = fnd_api.g_miss_date) THEN

892: ELSE
893: l_rev_item_eff_date := p_eco_obj_list(i).eco_revised_item_type(j).start_effective_date;
894: END IF;
895:
896: IF (l_as_of_date IS NULL OR l_as_of_date = fnd_api.g_miss_date) THEN
897: l_as_of_date := SYSDATE;
898: END IF;
899:
900: END IF;

Line 938: IF(x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN

934: ,x_out => x_out
935: );
936: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info STATUS: '|| x_out.output_status.return_status);
937:
938: IF(x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
939: RAISE FND_API.g_exc_unexpected_error;
940: END IF;
941: END IF;
942: END IF;

Line 939: RAISE FND_API.g_exc_unexpected_error;

935: );
936: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info STATUS: '|| x_out.output_status.return_status);
937:
938: IF(x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
939: RAISE FND_API.g_exc_unexpected_error;
940: END IF;
941: END IF;
942: END IF;
943: END LOOP;

Line 952: OR l_comp_item_tbl(i).disable_date = fnd_api.g_miss_date

948: IF( ( l_config_view_scope = G_VIEW_SCOPE_CURRENT
949: AND l_rev_item_eff_date <= l_as_of_date
950: AND ( l_comp_item_tbl(i).disable_date > l_as_of_date
951: OR l_comp_item_tbl(i).disable_date IS NULL
952: OR l_comp_item_tbl(i).disable_date = fnd_api.g_miss_date
953: )
954: )
955: OR ( l_config_view_scope = G_VIEW_SCOPE_CURR_FUTURE
956: AND ( l_comp_item_tbl(i).disable_date > l_as_of_date

Line 958: OR l_comp_item_tbl(i).disable_date = fnd_api.g_miss_date

954: )
955: OR ( l_config_view_scope = G_VIEW_SCOPE_CURR_FUTURE
956: AND ( l_comp_item_tbl(i).disable_date > l_as_of_date
957: OR l_comp_item_tbl(i).disable_date IS NULL
958: OR l_comp_item_tbl(i).disable_date = fnd_api.g_miss_date
959: )
960: )
961: OR( l_config_view_scope = G_VIEW_SCOPE_ALL )
962:

Line 1006: IF(x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN

1002: ,x_component_item => l_revised_item_obj.component_item_tbl(l_comp_count)
1003: ,x_out => x_out
1004: );
1005: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info STATUS: ' || x_out.output_status.return_status);
1006: IF(x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
1007: RAISE FND_API.g_exc_unexpected_error;
1008: END IF;
1009: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg');
1010: transform_ref_desg(

Line 1007: RAISE FND_API.g_exc_unexpected_error;

1003: ,x_out => x_out
1004: );
1005: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info STATUS: ' || x_out.output_status.return_status);
1006: IF(x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
1007: RAISE FND_API.g_exc_unexpected_error;
1008: END IF;
1009: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg');
1010: transform_ref_desg(
1011: p_ref_desg_tbl => l_comp_item_tbl(i).reference_designator_tbl

Line 1017: IF(x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN

1013: ,x_component_item => l_revised_item_obj.component_item_tbl(i)
1014: ,x_out => x_out
1015: );
1016: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg STATUS: '|| x_out.output_status.return_status);
1017: IF(x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
1018: RAISE FND_API.g_exc_unexpected_error;
1019: END IF;
1020: l_comp_exists := TRUE;
1021: END IF;

Line 1018: RAISE FND_API.g_exc_unexpected_error;

1014: ,x_out => x_out
1015: );
1016: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg STATUS: '|| x_out.output_status.return_status);
1017: IF(x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
1018: RAISE FND_API.g_exc_unexpected_error;
1019: END IF;
1020: l_comp_exists := TRUE;
1021: END IF;
1022: END IF;

Line 1031: WHEN FND_API.g_exc_unexpected_error THEN

1027: END IF;
1028: x_revised_item_obj := l_revised_item_obj;
1029: INV_EBI_UTIL.debug_line('STEP 110: END INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info STATUS: '|| x_out.output_status.return_status);
1030: EXCEPTION
1031: WHEN FND_API.g_exc_unexpected_error THEN
1032: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1033:
1034: IF(x_out.output_status.msg_data IS NULL) THEN
1035: fnd_msg_pub.count_and_get(

Line 1032: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1028: x_revised_item_obj := l_revised_item_obj;
1029: INV_EBI_UTIL.debug_line('STEP 110: END INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info STATUS: '|| x_out.output_status.return_status);
1030: EXCEPTION
1031: WHEN FND_API.g_exc_unexpected_error THEN
1032: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1033:
1034: IF(x_out.output_status.msg_data IS NULL) THEN
1035: fnd_msg_pub.count_and_get(
1036: p_encoded => FND_API.g_false

Line 1036: p_encoded => FND_API.g_false

1032: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1033:
1034: IF(x_out.output_status.msg_data IS NULL) THEN
1035: fnd_msg_pub.count_and_get(
1036: p_encoded => FND_API.g_false
1037: ,p_count => x_out.output_status.msg_count
1038: ,p_data => x_out.output_status.msg_data
1039: );
1040: END IF;

Line 1043: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1039: );
1040: END IF;
1041: WHEN OTHERS THEN
1042:
1043: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1044: IF (x_out.output_status.msg_data IS NOT NULL) THEN
1045: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info ';
1046: ELSE
1047: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info ';

Line 1099: ,fnd_api.g_miss_num ,NVL(sc.acd_type,1) ,p_new_substitute_comp.acd_type)) acd_type

1095: ,p_substitute_component_name IN VARCHAR2
1096: ) IS
1097: SELECT
1098: DECODE(p_new_substitute_comp ,NULL ,NVL(sc.acd_type,1) ,DECODE(p_new_substitute_comp.acd_type
1099: ,fnd_api.g_miss_num ,NVL(sc.acd_type,1) ,p_new_substitute_comp.acd_type)) acd_type
1100: ,DECODE(p_new_substitute_comp ,NULL ,sc.substitute_item_quantity ,DECODE(p_new_substitute_comp.substitute_item_quantity
1101: ,fnd_api.g_miss_num ,sc.substitute_item_quantity ,p_new_substitute_comp.substitute_item_quantity)) substitute_item_quantity
1102: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute_category ,DECODE(p_new_substitute_comp.attribute_category
1103: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category

Line 1101: ,fnd_api.g_miss_num ,sc.substitute_item_quantity ,p_new_substitute_comp.substitute_item_quantity)) substitute_item_quantity

1097: SELECT
1098: DECODE(p_new_substitute_comp ,NULL ,NVL(sc.acd_type,1) ,DECODE(p_new_substitute_comp.acd_type
1099: ,fnd_api.g_miss_num ,NVL(sc.acd_type,1) ,p_new_substitute_comp.acd_type)) acd_type
1100: ,DECODE(p_new_substitute_comp ,NULL ,sc.substitute_item_quantity ,DECODE(p_new_substitute_comp.substitute_item_quantity
1101: ,fnd_api.g_miss_num ,sc.substitute_item_quantity ,p_new_substitute_comp.substitute_item_quantity)) substitute_item_quantity
1102: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute_category ,DECODE(p_new_substitute_comp.attribute_category
1103: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category
1104: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute1 ,DECODE(p_new_substitute_comp.attribute1
1105: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1

Line 1103: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category

1099: ,fnd_api.g_miss_num ,NVL(sc.acd_type,1) ,p_new_substitute_comp.acd_type)) acd_type
1100: ,DECODE(p_new_substitute_comp ,NULL ,sc.substitute_item_quantity ,DECODE(p_new_substitute_comp.substitute_item_quantity
1101: ,fnd_api.g_miss_num ,sc.substitute_item_quantity ,p_new_substitute_comp.substitute_item_quantity)) substitute_item_quantity
1102: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute_category ,DECODE(p_new_substitute_comp.attribute_category
1103: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category
1104: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute1 ,DECODE(p_new_substitute_comp.attribute1
1105: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1
1106: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute2 ,DECODE(p_new_substitute_comp.attribute2
1107: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2

Line 1105: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1

1101: ,fnd_api.g_miss_num ,sc.substitute_item_quantity ,p_new_substitute_comp.substitute_item_quantity)) substitute_item_quantity
1102: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute_category ,DECODE(p_new_substitute_comp.attribute_category
1103: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category
1104: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute1 ,DECODE(p_new_substitute_comp.attribute1
1105: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1
1106: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute2 ,DECODE(p_new_substitute_comp.attribute2
1107: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2
1108: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute3 ,DECODE(p_new_substitute_comp.attribute3
1109: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3

Line 1107: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2

1103: ,fnd_api.g_miss_char ,sc.attribute_category ,p_new_substitute_comp.attribute_category )) attribute_category
1104: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute1 ,DECODE(p_new_substitute_comp.attribute1
1105: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1
1106: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute2 ,DECODE(p_new_substitute_comp.attribute2
1107: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2
1108: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute3 ,DECODE(p_new_substitute_comp.attribute3
1109: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3
1110: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute4 ,DECODE(p_new_substitute_comp.attribute4
1111: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4

Line 1109: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3

1105: ,fnd_api.g_miss_char ,sc.attribute1 ,p_new_substitute_comp.attribute1 )) attribute1
1106: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute2 ,DECODE(p_new_substitute_comp.attribute2
1107: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2
1108: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute3 ,DECODE(p_new_substitute_comp.attribute3
1109: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3
1110: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute4 ,DECODE(p_new_substitute_comp.attribute4
1111: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4
1112: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute5 ,DECODE(p_new_substitute_comp.attribute5
1113: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5

Line 1111: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4

1107: ,fnd_api.g_miss_char ,sc.attribute2 ,p_new_substitute_comp.attribute2 )) attribute2
1108: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute3 ,DECODE(p_new_substitute_comp.attribute3
1109: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3
1110: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute4 ,DECODE(p_new_substitute_comp.attribute4
1111: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4
1112: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute5 ,DECODE(p_new_substitute_comp.attribute5
1113: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5
1114: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute6 ,DECODE(p_new_substitute_comp.attribute6
1115: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6

Line 1113: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5

1109: ,fnd_api.g_miss_char ,sc.attribute3 ,p_new_substitute_comp.attribute3 )) attribute3
1110: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute4 ,DECODE(p_new_substitute_comp.attribute4
1111: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4
1112: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute5 ,DECODE(p_new_substitute_comp.attribute5
1113: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5
1114: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute6 ,DECODE(p_new_substitute_comp.attribute6
1115: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6
1116: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute7 ,DECODE(p_new_substitute_comp.attribute7
1117: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7

Line 1115: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6

1111: ,fnd_api.g_miss_char ,sc.attribute4 ,p_new_substitute_comp.attribute4 )) attribute4
1112: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute5 ,DECODE(p_new_substitute_comp.attribute5
1113: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5
1114: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute6 ,DECODE(p_new_substitute_comp.attribute6
1115: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6
1116: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute7 ,DECODE(p_new_substitute_comp.attribute7
1117: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7
1118: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute8 ,DECODE(p_new_substitute_comp.attribute8
1119: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8

Line 1117: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7

1113: ,fnd_api.g_miss_char ,sc.attribute5 ,p_new_substitute_comp.attribute5 )) attribute5
1114: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute6 ,DECODE(p_new_substitute_comp.attribute6
1115: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6
1116: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute7 ,DECODE(p_new_substitute_comp.attribute7
1117: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7
1118: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute8 ,DECODE(p_new_substitute_comp.attribute8
1119: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8
1120: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute9 ,DECODE(p_new_substitute_comp.attribute9
1121: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9

Line 1119: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8

1115: ,fnd_api.g_miss_char ,sc.attribute6 ,p_new_substitute_comp.attribute6 )) attribute6
1116: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute7 ,DECODE(p_new_substitute_comp.attribute7
1117: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7
1118: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute8 ,DECODE(p_new_substitute_comp.attribute8
1119: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8
1120: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute9 ,DECODE(p_new_substitute_comp.attribute9
1121: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9
1122: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute10 ,DECODE(p_new_substitute_comp.attribute10
1123: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10

Line 1121: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9

1117: ,fnd_api.g_miss_char ,sc.attribute7 ,p_new_substitute_comp.attribute7 )) attribute7
1118: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute8 ,DECODE(p_new_substitute_comp.attribute8
1119: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8
1120: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute9 ,DECODE(p_new_substitute_comp.attribute9
1121: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9
1122: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute10 ,DECODE(p_new_substitute_comp.attribute10
1123: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10
1124: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute11 ,DECODE(p_new_substitute_comp.attribute11
1125: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11

Line 1123: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10

1119: ,fnd_api.g_miss_char ,sc.attribute8 ,p_new_substitute_comp.attribute8 )) attribute8
1120: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute9 ,DECODE(p_new_substitute_comp.attribute9
1121: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9
1122: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute10 ,DECODE(p_new_substitute_comp.attribute10
1123: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10
1124: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute11 ,DECODE(p_new_substitute_comp.attribute11
1125: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11
1126: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute12 ,DECODE(p_new_substitute_comp.attribute12
1127: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12

Line 1125: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11

1121: ,fnd_api.g_miss_char ,sc.attribute9 ,p_new_substitute_comp.attribute9 )) attribute9
1122: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute10 ,DECODE(p_new_substitute_comp.attribute10
1123: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10
1124: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute11 ,DECODE(p_new_substitute_comp.attribute11
1125: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11
1126: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute12 ,DECODE(p_new_substitute_comp.attribute12
1127: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12
1128: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute13 ,DECODE(p_new_substitute_comp.attribute13
1129: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13

Line 1127: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12

1123: ,fnd_api.g_miss_char ,sc.attribute10 ,p_new_substitute_comp.attribute10 )) attribute10
1124: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute11 ,DECODE(p_new_substitute_comp.attribute11
1125: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11
1126: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute12 ,DECODE(p_new_substitute_comp.attribute12
1127: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12
1128: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute13 ,DECODE(p_new_substitute_comp.attribute13
1129: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13
1130: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute14 ,DECODE(p_new_substitute_comp.attribute14
1131: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14

Line 1129: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13

1125: ,fnd_api.g_miss_char ,sc.attribute11 ,p_new_substitute_comp.attribute11 )) attribute11
1126: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute12 ,DECODE(p_new_substitute_comp.attribute12
1127: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12
1128: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute13 ,DECODE(p_new_substitute_comp.attribute13
1129: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13
1130: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute14 ,DECODE(p_new_substitute_comp.attribute14
1131: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14
1132: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute15 ,DECODE(p_new_substitute_comp.attribute15
1133: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15

Line 1131: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14

1127: ,fnd_api.g_miss_char ,sc.attribute12 ,p_new_substitute_comp.attribute12 )) attribute12
1128: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute13 ,DECODE(p_new_substitute_comp.attribute13
1129: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13
1130: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute14 ,DECODE(p_new_substitute_comp.attribute14
1131: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14
1132: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute15 ,DECODE(p_new_substitute_comp.attribute15
1133: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15
1134: ,DECODE(p_new_substitute_comp ,NULL ,sc.original_system_reference ,DECODE(p_new_substitute_comp.original_system_reference
1135: ,fnd_api.g_miss_char ,sc.original_system_reference ,p_new_substitute_comp.original_system_reference)) original_system_reference

Line 1133: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15

1129: ,fnd_api.g_miss_char ,sc.attribute13 ,p_new_substitute_comp.attribute13 )) attribute13
1130: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute14 ,DECODE(p_new_substitute_comp.attribute14
1131: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14
1132: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute15 ,DECODE(p_new_substitute_comp.attribute15
1133: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15
1134: ,DECODE(p_new_substitute_comp ,NULL ,sc.original_system_reference ,DECODE(p_new_substitute_comp.original_system_reference
1135: ,fnd_api.g_miss_char ,sc.original_system_reference ,p_new_substitute_comp.original_system_reference)) original_system_reference
1136: ,DECODE(p_new_substitute_comp ,NULL ,sc.enforce_int_requirements ,DECODE(p_new_substitute_comp.enforce_int_requirements
1137: ,fnd_api.g_miss_num ,sc.enforce_int_requirements ,p_new_substitute_comp.enforce_int_requirements)) enforce_int_requirements

Line 1135: ,fnd_api.g_miss_char ,sc.original_system_reference ,p_new_substitute_comp.original_system_reference)) original_system_reference

1131: ,fnd_api.g_miss_char ,sc.attribute14 ,p_new_substitute_comp.attribute14 )) attribute14
1132: ,DECODE(p_new_substitute_comp ,NULL ,sc.attribute15 ,DECODE(p_new_substitute_comp.attribute15
1133: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15
1134: ,DECODE(p_new_substitute_comp ,NULL ,sc.original_system_reference ,DECODE(p_new_substitute_comp.original_system_reference
1135: ,fnd_api.g_miss_char ,sc.original_system_reference ,p_new_substitute_comp.original_system_reference)) original_system_reference
1136: ,DECODE(p_new_substitute_comp ,NULL ,sc.enforce_int_requirements ,DECODE(p_new_substitute_comp.enforce_int_requirements
1137: ,fnd_api.g_miss_num ,sc.enforce_int_requirements ,p_new_substitute_comp.enforce_int_requirements)) enforce_int_requirements
1138: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.start_effective_date) start_effective_date
1139: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.new_substitute_component_name ) new_substitute_component_name

Line 1137: ,fnd_api.g_miss_num ,sc.enforce_int_requirements ,p_new_substitute_comp.enforce_int_requirements)) enforce_int_requirements

1133: ,fnd_api.g_miss_char ,sc.attribute15 ,p_new_substitute_comp.attribute15 )) attribute15
1134: ,DECODE(p_new_substitute_comp ,NULL ,sc.original_system_reference ,DECODE(p_new_substitute_comp.original_system_reference
1135: ,fnd_api.g_miss_char ,sc.original_system_reference ,p_new_substitute_comp.original_system_reference)) original_system_reference
1136: ,DECODE(p_new_substitute_comp ,NULL ,sc.enforce_int_requirements ,DECODE(p_new_substitute_comp.enforce_int_requirements
1137: ,fnd_api.g_miss_num ,sc.enforce_int_requirements ,p_new_substitute_comp.enforce_int_requirements)) enforce_int_requirements
1138: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.start_effective_date) start_effective_date
1139: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.new_substitute_component_name ) new_substitute_component_name
1140: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.from_end_item_unit_number) from_end_item_unit_number
1141: ,DECODE(p_new_substitute_comp ,NULL ,NULL ,p_new_substitute_comp.new_routing_revision) new_routing_revision

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

1160: l_substitute_comp_tbl inv_ebi_sub_comp_tbl;
1161: l_sub_comp_count NUMBER := 1;
1162: l_output_status inv_ebi_output_status;
1163: BEGIN
1164: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1165: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1166: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components');
1167: OPEN c_comp_sequence_id;
1168: FETCH c_comp_sequence_id INTO l_component_sequence_id;

Line 1299: WHEN FND_API.g_exc_unexpected_error THEN

1295: x_component_item := l_component_item;
1296: INV_EBI_UTIL.debug_line('STEP 30: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components STATUS : '|| x_out.output_status.return_status );
1297:
1298: EXCEPTION
1299: WHEN FND_API.g_exc_unexpected_error THEN
1300: IF c_Merged_Substitute_Comp%ISOPEN THEN
1301: CLOSE c_merged_substitute_comp;
1302: END IF;
1303: IF c_copied_substitute_comps%ISOPEN THEN

Line 1306: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1302: END IF;
1303: IF c_copied_substitute_comps%ISOPEN THEN
1304: CLOSE c_copied_substitute_comps;
1305: END IF;
1306: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1307: IF(x_out.output_status.msg_data IS NULL) THEN
1308: fnd_msg_pub.count_and_get(
1309: p_encoded => FND_API.g_false
1310: ,p_count => x_out.output_status.msg_count

Line 1309: p_encoded => FND_API.g_false

1305: END IF;
1306: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1307: IF(x_out.output_status.msg_data IS NULL) THEN
1308: fnd_msg_pub.count_and_get(
1309: p_encoded => FND_API.g_false
1310: ,p_count => x_out.output_status.msg_count
1311: ,p_data => x_out.output_status.msg_data
1312: );
1313: END IF;

Line 1321: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1317: END IF;
1318: IF c_copied_substitute_comps%ISOPEN THEN
1319: CLOSE c_copied_substitute_comps;
1320: END IF;
1321: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1322: IF (x_out.output_status.msg_data IS NOT NULL) THEN
1323: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components ';
1324: ELSE
1325: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components ';

Line 1373: ,fnd_api.g_miss_num ,NVL(acd_type,1) ,p_new_ref_designator.acd_type)) acd_type

1369: ,p_ref_designator_name IN VARCHAR2
1370: ) IS
1371: SELECT
1372: DECODE(p_new_ref_designator ,NULL ,NVL(acd_type,1) ,DECODE(p_new_ref_designator.acd_type
1373: ,fnd_api.g_miss_num ,NVL(acd_type,1) ,p_new_ref_designator.acd_type)) acd_type
1374: ,DECODE(p_new_ref_designator ,NULL ,attribute_category ,DECODE(p_new_ref_designator.attribute_category
1375: ,fnd_api.g_miss_char ,attribute_category ,p_new_ref_designator.attribute_category )) attribute_category
1376: ,DECODE(p_new_ref_designator ,NULL ,attribute1 ,DECODE(p_new_ref_designator.attribute1
1377: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1

Line 1375: ,fnd_api.g_miss_char ,attribute_category ,p_new_ref_designator.attribute_category )) attribute_category

1371: SELECT
1372: DECODE(p_new_ref_designator ,NULL ,NVL(acd_type,1) ,DECODE(p_new_ref_designator.acd_type
1373: ,fnd_api.g_miss_num ,NVL(acd_type,1) ,p_new_ref_designator.acd_type)) acd_type
1374: ,DECODE(p_new_ref_designator ,NULL ,attribute_category ,DECODE(p_new_ref_designator.attribute_category
1375: ,fnd_api.g_miss_char ,attribute_category ,p_new_ref_designator.attribute_category )) attribute_category
1376: ,DECODE(p_new_ref_designator ,NULL ,attribute1 ,DECODE(p_new_ref_designator.attribute1
1377: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1
1378: ,DECODE(p_new_ref_designator ,NULL ,attribute2 ,DECODE(p_new_ref_designator.attribute2
1379: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2

Line 1377: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1

1373: ,fnd_api.g_miss_num ,NVL(acd_type,1) ,p_new_ref_designator.acd_type)) acd_type
1374: ,DECODE(p_new_ref_designator ,NULL ,attribute_category ,DECODE(p_new_ref_designator.attribute_category
1375: ,fnd_api.g_miss_char ,attribute_category ,p_new_ref_designator.attribute_category )) attribute_category
1376: ,DECODE(p_new_ref_designator ,NULL ,attribute1 ,DECODE(p_new_ref_designator.attribute1
1377: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1
1378: ,DECODE(p_new_ref_designator ,NULL ,attribute2 ,DECODE(p_new_ref_designator.attribute2
1379: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2
1380: ,DECODE(p_new_ref_designator ,NULL ,attribute3 ,DECODE(p_new_ref_designator.attribute3
1381: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3

Line 1379: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2

1375: ,fnd_api.g_miss_char ,attribute_category ,p_new_ref_designator.attribute_category )) attribute_category
1376: ,DECODE(p_new_ref_designator ,NULL ,attribute1 ,DECODE(p_new_ref_designator.attribute1
1377: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1
1378: ,DECODE(p_new_ref_designator ,NULL ,attribute2 ,DECODE(p_new_ref_designator.attribute2
1379: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2
1380: ,DECODE(p_new_ref_designator ,NULL ,attribute3 ,DECODE(p_new_ref_designator.attribute3
1381: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3
1382: ,DECODE(p_new_ref_designator ,NULL ,attribute4 ,DECODE(p_new_ref_designator.attribute4
1383: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4

Line 1381: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3

1377: ,fnd_api.g_miss_char ,attribute1 ,p_new_ref_designator.attribute1 )) attribute1
1378: ,DECODE(p_new_ref_designator ,NULL ,attribute2 ,DECODE(p_new_ref_designator.attribute2
1379: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2
1380: ,DECODE(p_new_ref_designator ,NULL ,attribute3 ,DECODE(p_new_ref_designator.attribute3
1381: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3
1382: ,DECODE(p_new_ref_designator ,NULL ,attribute4 ,DECODE(p_new_ref_designator.attribute4
1383: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4
1384: ,DECODE(p_new_ref_designator ,NULL ,attribute5 ,DECODE(p_new_ref_designator.attribute5
1385: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5

Line 1383: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4

1379: ,fnd_api.g_miss_char ,attribute2 ,p_new_ref_designator.attribute2 )) attribute2
1380: ,DECODE(p_new_ref_designator ,NULL ,attribute3 ,DECODE(p_new_ref_designator.attribute3
1381: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3
1382: ,DECODE(p_new_ref_designator ,NULL ,attribute4 ,DECODE(p_new_ref_designator.attribute4
1383: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4
1384: ,DECODE(p_new_ref_designator ,NULL ,attribute5 ,DECODE(p_new_ref_designator.attribute5
1385: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5
1386: ,DECODE(p_new_ref_designator ,NULL ,attribute6 ,DECODE(p_new_ref_designator.attribute6
1387: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6

Line 1385: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5

1381: ,fnd_api.g_miss_char ,attribute3 ,p_new_ref_designator.attribute3 )) attribute3
1382: ,DECODE(p_new_ref_designator ,NULL ,attribute4 ,DECODE(p_new_ref_designator.attribute4
1383: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4
1384: ,DECODE(p_new_ref_designator ,NULL ,attribute5 ,DECODE(p_new_ref_designator.attribute5
1385: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5
1386: ,DECODE(p_new_ref_designator ,NULL ,attribute6 ,DECODE(p_new_ref_designator.attribute6
1387: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6
1388: ,DECODE(p_new_ref_designator ,NULL ,attribute7 ,DECODE(p_new_ref_designator.attribute7
1389: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7

Line 1387: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6

1383: ,fnd_api.g_miss_char ,attribute4 ,p_new_ref_designator.attribute4 )) attribute4
1384: ,DECODE(p_new_ref_designator ,NULL ,attribute5 ,DECODE(p_new_ref_designator.attribute5
1385: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5
1386: ,DECODE(p_new_ref_designator ,NULL ,attribute6 ,DECODE(p_new_ref_designator.attribute6
1387: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6
1388: ,DECODE(p_new_ref_designator ,NULL ,attribute7 ,DECODE(p_new_ref_designator.attribute7
1389: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7
1390: ,DECODE(p_new_ref_designator ,NULL ,attribute8 ,DECODE(p_new_ref_designator.attribute8
1391: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8

Line 1389: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7

1385: ,fnd_api.g_miss_char ,attribute5 ,p_new_ref_designator.attribute5 )) attribute5
1386: ,DECODE(p_new_ref_designator ,NULL ,attribute6 ,DECODE(p_new_ref_designator.attribute6
1387: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6
1388: ,DECODE(p_new_ref_designator ,NULL ,attribute7 ,DECODE(p_new_ref_designator.attribute7
1389: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7
1390: ,DECODE(p_new_ref_designator ,NULL ,attribute8 ,DECODE(p_new_ref_designator.attribute8
1391: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8
1392: ,DECODE(p_new_ref_designator ,NULL ,attribute9 ,DECODE(p_new_ref_designator.attribute9
1393: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9

Line 1391: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8

1387: ,fnd_api.g_miss_char ,attribute6 ,p_new_ref_designator.attribute6 )) attribute6
1388: ,DECODE(p_new_ref_designator ,NULL ,attribute7 ,DECODE(p_new_ref_designator.attribute7
1389: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7
1390: ,DECODE(p_new_ref_designator ,NULL ,attribute8 ,DECODE(p_new_ref_designator.attribute8
1391: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8
1392: ,DECODE(p_new_ref_designator ,NULL ,attribute9 ,DECODE(p_new_ref_designator.attribute9
1393: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9
1394: ,DECODE(p_new_ref_designator ,NULL ,attribute10 ,DECODE(p_new_ref_designator.attribute10
1395: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10

Line 1393: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9

1389: ,fnd_api.g_miss_char ,attribute7 ,p_new_ref_designator.attribute7 )) attribute7
1390: ,DECODE(p_new_ref_designator ,NULL ,attribute8 ,DECODE(p_new_ref_designator.attribute8
1391: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8
1392: ,DECODE(p_new_ref_designator ,NULL ,attribute9 ,DECODE(p_new_ref_designator.attribute9
1393: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9
1394: ,DECODE(p_new_ref_designator ,NULL ,attribute10 ,DECODE(p_new_ref_designator.attribute10
1395: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10
1396: ,DECODE(p_new_ref_designator ,NULL ,attribute11 ,DECODE(p_new_ref_designator.attribute11
1397: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11

Line 1395: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10

1391: ,fnd_api.g_miss_char ,attribute8 ,p_new_ref_designator.attribute8 )) attribute8
1392: ,DECODE(p_new_ref_designator ,NULL ,attribute9 ,DECODE(p_new_ref_designator.attribute9
1393: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9
1394: ,DECODE(p_new_ref_designator ,NULL ,attribute10 ,DECODE(p_new_ref_designator.attribute10
1395: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10
1396: ,DECODE(p_new_ref_designator ,NULL ,attribute11 ,DECODE(p_new_ref_designator.attribute11
1397: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11
1398: ,DECODE(p_new_ref_designator ,NULL ,attribute12 ,DECODE(p_new_ref_designator.attribute12
1399: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12

Line 1397: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11

1393: ,fnd_api.g_miss_char ,attribute9 ,p_new_ref_designator.attribute9 )) attribute9
1394: ,DECODE(p_new_ref_designator ,NULL ,attribute10 ,DECODE(p_new_ref_designator.attribute10
1395: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10
1396: ,DECODE(p_new_ref_designator ,NULL ,attribute11 ,DECODE(p_new_ref_designator.attribute11
1397: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11
1398: ,DECODE(p_new_ref_designator ,NULL ,attribute12 ,DECODE(p_new_ref_designator.attribute12
1399: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12
1400: ,DECODE(p_new_ref_designator ,NULL ,attribute13 ,DECODE(p_new_ref_designator.attribute13
1401: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13

Line 1399: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12

1395: ,fnd_api.g_miss_char ,attribute10 ,p_new_ref_designator.attribute10 )) attribute10
1396: ,DECODE(p_new_ref_designator ,NULL ,attribute11 ,DECODE(p_new_ref_designator.attribute11
1397: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11
1398: ,DECODE(p_new_ref_designator ,NULL ,attribute12 ,DECODE(p_new_ref_designator.attribute12
1399: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12
1400: ,DECODE(p_new_ref_designator ,NULL ,attribute13 ,DECODE(p_new_ref_designator.attribute13
1401: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13
1402: ,DECODE(p_new_ref_designator ,NULL ,attribute14 ,DECODE(p_new_ref_designator.attribute14
1403: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14

Line 1401: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13

1397: ,fnd_api.g_miss_char ,attribute11 ,p_new_ref_designator.attribute11 )) attribute11
1398: ,DECODE(p_new_ref_designator ,NULL ,attribute12 ,DECODE(p_new_ref_designator.attribute12
1399: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12
1400: ,DECODE(p_new_ref_designator ,NULL ,attribute13 ,DECODE(p_new_ref_designator.attribute13
1401: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13
1402: ,DECODE(p_new_ref_designator ,NULL ,attribute14 ,DECODE(p_new_ref_designator.attribute14
1403: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14
1404: ,DECODE(p_new_ref_designator ,NULL ,attribute15 ,DECODE(p_new_ref_designator.attribute15
1405: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15

Line 1403: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14

1399: ,fnd_api.g_miss_char ,attribute12 ,p_new_ref_designator.attribute12 )) attribute12
1400: ,DECODE(p_new_ref_designator ,NULL ,attribute13 ,DECODE(p_new_ref_designator.attribute13
1401: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13
1402: ,DECODE(p_new_ref_designator ,NULL ,attribute14 ,DECODE(p_new_ref_designator.attribute14
1403: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14
1404: ,DECODE(p_new_ref_designator ,NULL ,attribute15 ,DECODE(p_new_ref_designator.attribute15
1405: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15
1406: ,DECODE(p_new_ref_designator ,NULL ,original_system_reference ,DECODE(p_new_ref_designator.original_system_reference
1407: ,fnd_api.g_miss_char ,original_system_reference ,p_new_ref_designator.original_system_reference)) original_system_reference

Line 1405: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15

1401: ,fnd_api.g_miss_char ,attribute13 ,p_new_ref_designator.attribute13 )) attribute13
1402: ,DECODE(p_new_ref_designator ,NULL ,attribute14 ,DECODE(p_new_ref_designator.attribute14
1403: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14
1404: ,DECODE(p_new_ref_designator ,NULL ,attribute15 ,DECODE(p_new_ref_designator.attribute15
1405: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15
1406: ,DECODE(p_new_ref_designator ,NULL ,original_system_reference ,DECODE(p_new_ref_designator.original_system_reference
1407: ,fnd_api.g_miss_char ,original_system_reference ,p_new_ref_designator.original_system_reference)) original_system_reference
1408: ,DECODE(p_new_ref_designator ,NULL ,ref_designator_comment ,DECODE(p_new_ref_designator.ref_designator_comment
1409: ,fnd_api.g_miss_char ,ref_designator_comment ,p_new_ref_designator.ref_designator_comment )) ref_designator_comment

Line 1407: ,fnd_api.g_miss_char ,original_system_reference ,p_new_ref_designator.original_system_reference)) original_system_reference

1403: ,fnd_api.g_miss_char ,attribute14 ,p_new_ref_designator.attribute14 )) attribute14
1404: ,DECODE(p_new_ref_designator ,NULL ,attribute15 ,DECODE(p_new_ref_designator.attribute15
1405: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15
1406: ,DECODE(p_new_ref_designator ,NULL ,original_system_reference ,DECODE(p_new_ref_designator.original_system_reference
1407: ,fnd_api.g_miss_char ,original_system_reference ,p_new_ref_designator.original_system_reference)) original_system_reference
1408: ,DECODE(p_new_ref_designator ,NULL ,ref_designator_comment ,DECODE(p_new_ref_designator.ref_designator_comment
1409: ,fnd_api.g_miss_char ,ref_designator_comment ,p_new_ref_designator.ref_designator_comment )) ref_designator_comment
1410: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.start_effective_date) start_effective_date
1411: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.new_reference_designator ) new_reference_designator

Line 1409: ,fnd_api.g_miss_char ,ref_designator_comment ,p_new_ref_designator.ref_designator_comment )) ref_designator_comment

1405: ,fnd_api.g_miss_char ,attribute15 ,p_new_ref_designator.attribute15 )) attribute15
1406: ,DECODE(p_new_ref_designator ,NULL ,original_system_reference ,DECODE(p_new_ref_designator.original_system_reference
1407: ,fnd_api.g_miss_char ,original_system_reference ,p_new_ref_designator.original_system_reference)) original_system_reference
1408: ,DECODE(p_new_ref_designator ,NULL ,ref_designator_comment ,DECODE(p_new_ref_designator.ref_designator_comment
1409: ,fnd_api.g_miss_char ,ref_designator_comment ,p_new_ref_designator.ref_designator_comment )) ref_designator_comment
1410: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.start_effective_date) start_effective_date
1411: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.new_reference_designator ) new_reference_designator
1412: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.from_end_item_unit_number) from_end_item_unit_number
1413: ,DECODE(p_new_ref_designator ,NULL ,NULL ,p_new_ref_designator.new_routing_revision) new_routing_revision

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

1429: l_ref_dsgn_count NUMBER := 1;
1430: l_output_status inv_ebi_output_status;
1431:
1432: BEGIN
1433: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1434: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1435: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators');
1436: OPEN c_comp_sequence_id;
1437: FETCH c_comp_sequence_id INTO l_component_sequence_id;

Line 1558: WHEN FND_API.g_exc_unexpected_error THEN

1554: x_component_item := l_component_item;
1555: INV_EBI_UTIL.debug_line('STEP 20: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators STATUS: ' || x_out.output_status.return_status);
1556:
1557: EXCEPTION
1558: WHEN FND_API.g_exc_unexpected_error THEN
1559: IF c_merged_ref_designators%ISOPEN THEN
1560: CLOSE c_merged_ref_designators;
1561: END IF;
1562: IF c_copied_ref_designators%ISOPEN THEN

Line 1565: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1561: END IF;
1562: IF c_copied_ref_designators%ISOPEN THEN
1563: CLOSE c_copied_ref_designators;
1564: END IF;
1565: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1566: IF(x_out.output_status.msg_data IS NULL) THEN
1567: fnd_msg_pub.count_and_get(
1568: p_encoded => FND_API.g_false
1569: ,p_count => x_out.output_status.msg_count

Line 1568: p_encoded => FND_API.g_false

1564: END IF;
1565: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1566: IF(x_out.output_status.msg_data IS NULL) THEN
1567: fnd_msg_pub.count_and_get(
1568: p_encoded => FND_API.g_false
1569: ,p_count => x_out.output_status.msg_count
1570: ,p_data => x_out.output_status.msg_data
1571: );
1572: END IF;

Line 1580: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

1576: END IF;
1577: IF c_copied_ref_designators%ISOPEN THEN
1578: CLOSE c_copied_ref_designators;
1579: END IF;
1580: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1581: IF (x_out.output_status.msg_data IS NOT NULL) THEN
1582: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators ';
1583: ELSE
1584: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators ';

Line 1692: ,fnd_api.g_miss_date ,bic.disable_date ,p_new_comp_item.disable_date)) disable_date

1688: ,p_bill_sequence_id IN NUMBER
1689: ) IS
1690: SELECT
1691: DECODE(p_new_comp_item ,NULL ,bic.disable_date ,DECODE(p_new_comp_item.disable_date
1692: ,fnd_api.g_miss_date ,bic.disable_date ,p_new_comp_item.disable_date)) disable_date
1693: ,DECODE(p_new_comp_item ,NULL ,NVL(bic.acd_type,1) ,DECODE(p_new_comp_item.acd_type
1694: ,fnd_api.g_miss_char ,NVL(bic.acd_type,1) ,p_new_comp_item.acd_type)) acd_type
1695: ,DECODE(p_new_comp_item ,NULL ,bic.basis_type ,DECODE(p_new_comp_item.basis_type
1696: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type

Line 1694: ,fnd_api.g_miss_char ,NVL(bic.acd_type,1) ,p_new_comp_item.acd_type)) acd_type

1690: SELECT
1691: DECODE(p_new_comp_item ,NULL ,bic.disable_date ,DECODE(p_new_comp_item.disable_date
1692: ,fnd_api.g_miss_date ,bic.disable_date ,p_new_comp_item.disable_date)) disable_date
1693: ,DECODE(p_new_comp_item ,NULL ,NVL(bic.acd_type,1) ,DECODE(p_new_comp_item.acd_type
1694: ,fnd_api.g_miss_char ,NVL(bic.acd_type,1) ,p_new_comp_item.acd_type)) acd_type
1695: ,DECODE(p_new_comp_item ,NULL ,bic.basis_type ,DECODE(p_new_comp_item.basis_type
1696: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type
1697: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.quantity_per_assembly
1698: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly

Line 1696: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type

1692: ,fnd_api.g_miss_date ,bic.disable_date ,p_new_comp_item.disable_date)) disable_date
1693: ,DECODE(p_new_comp_item ,NULL ,NVL(bic.acd_type,1) ,DECODE(p_new_comp_item.acd_type
1694: ,fnd_api.g_miss_char ,NVL(bic.acd_type,1) ,p_new_comp_item.acd_type)) acd_type
1695: ,DECODE(p_new_comp_item ,NULL ,bic.basis_type ,DECODE(p_new_comp_item.basis_type
1696: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type
1697: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.quantity_per_assembly
1698: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly
1699: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.inverse_quantity
1700: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity

Line 1698: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly

1694: ,fnd_api.g_miss_char ,NVL(bic.acd_type,1) ,p_new_comp_item.acd_type)) acd_type
1695: ,DECODE(p_new_comp_item ,NULL ,bic.basis_type ,DECODE(p_new_comp_item.basis_type
1696: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type
1697: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.quantity_per_assembly
1698: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly
1699: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.inverse_quantity
1700: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity
1701: ,DECODE(p_new_comp_item ,NULL ,bic.include_in_cost_rollup ,DECODE(p_new_comp_item.include_in_cost_rollup
1702: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup

Line 1700: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity

1696: ,fnd_api.g_miss_num ,bic.basis_type ,p_new_comp_item.basis_type)) basis_type
1697: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.quantity_per_assembly
1698: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly
1699: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.inverse_quantity
1700: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity
1701: ,DECODE(p_new_comp_item ,NULL ,bic.include_in_cost_rollup ,DECODE(p_new_comp_item.include_in_cost_rollup
1702: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup
1703: ,DECODE(p_new_comp_item ,NULL ,bic.wip_supply_type ,DECODE(p_new_comp_item.wip_supply_type
1704: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type

Line 1702: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup

1698: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.quantity_per_assembly )) quantity_per_assembly
1699: ,DECODE(p_new_comp_item ,NULL ,bic.component_quantity ,DECODE(p_new_comp_item.inverse_quantity
1700: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity
1701: ,DECODE(p_new_comp_item ,NULL ,bic.include_in_cost_rollup ,DECODE(p_new_comp_item.include_in_cost_rollup
1702: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup
1703: ,DECODE(p_new_comp_item ,NULL ,bic.wip_supply_type ,DECODE(p_new_comp_item.wip_supply_type
1704: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type
1705: ,DECODE(p_new_comp_item ,NULL ,bic.so_basis ,DECODE(p_new_comp_item.so_basis
1706: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis

Line 1704: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type

1700: ,fnd_api.g_miss_num ,bic.component_quantity ,p_new_comp_item.inverse_quantity )) inverse_quantity
1701: ,DECODE(p_new_comp_item ,NULL ,bic.include_in_cost_rollup ,DECODE(p_new_comp_item.include_in_cost_rollup
1702: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup
1703: ,DECODE(p_new_comp_item ,NULL ,bic.wip_supply_type ,DECODE(p_new_comp_item.wip_supply_type
1704: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type
1705: ,DECODE(p_new_comp_item ,NULL ,bic.so_basis ,DECODE(p_new_comp_item.so_basis
1706: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis
1707: ,DECODE(p_new_comp_item ,NULL ,bic.optional ,DECODE(p_new_comp_item.optional
1708: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional

Line 1706: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis

1702: ,fnd_api.g_miss_num ,bic.include_in_cost_rollup ,p_new_comp_item.include_in_cost_rollup)) include_in_cost_rollup
1703: ,DECODE(p_new_comp_item ,NULL ,bic.wip_supply_type ,DECODE(p_new_comp_item.wip_supply_type
1704: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type
1705: ,DECODE(p_new_comp_item ,NULL ,bic.so_basis ,DECODE(p_new_comp_item.so_basis
1706: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis
1707: ,DECODE(p_new_comp_item ,NULL ,bic.optional ,DECODE(p_new_comp_item.optional
1708: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional
1709: ,DECODE(p_new_comp_item ,NULL ,bic.mutually_exclusive_options ,DECODE(p_new_comp_item.mutually_exclusive
1710: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive

Line 1708: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional

1704: ,fnd_api.g_miss_num ,bic.wip_supply_type ,p_new_comp_item.wip_supply_type)) wip_supply_type
1705: ,DECODE(p_new_comp_item ,NULL ,bic.so_basis ,DECODE(p_new_comp_item.so_basis
1706: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis
1707: ,DECODE(p_new_comp_item ,NULL ,bic.optional ,DECODE(p_new_comp_item.optional
1708: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional
1709: ,DECODE(p_new_comp_item ,NULL ,bic.mutually_exclusive_options ,DECODE(p_new_comp_item.mutually_exclusive
1710: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive
1711: ,DECODE(p_new_comp_item ,NULL ,bic.check_atp ,DECODE(p_new_comp_item.check_atp
1712: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp

Line 1710: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive

1706: ,fnd_api.g_miss_num ,bic.so_basis ,p_new_comp_item.so_basis)) so_basis
1707: ,DECODE(p_new_comp_item ,NULL ,bic.optional ,DECODE(p_new_comp_item.optional
1708: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional
1709: ,DECODE(p_new_comp_item ,NULL ,bic.mutually_exclusive_options ,DECODE(p_new_comp_item.mutually_exclusive
1710: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive
1711: ,DECODE(p_new_comp_item ,NULL ,bic.check_atp ,DECODE(p_new_comp_item.check_atp
1712: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp
1713: ,DECODE(p_new_comp_item ,NULL ,bic.shipping_allowed ,DECODE(p_new_comp_item.shipping_allowed
1714: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed

Line 1712: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp

1708: ,fnd_api.g_miss_num ,bic.optional ,p_new_comp_item.optional)) optional
1709: ,DECODE(p_new_comp_item ,NULL ,bic.mutually_exclusive_options ,DECODE(p_new_comp_item.mutually_exclusive
1710: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive
1711: ,DECODE(p_new_comp_item ,NULL ,bic.check_atp ,DECODE(p_new_comp_item.check_atp
1712: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp
1713: ,DECODE(p_new_comp_item ,NULL ,bic.shipping_allowed ,DECODE(p_new_comp_item.shipping_allowed
1714: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed
1715: ,DECODE(p_new_comp_item ,NULL ,bic.required_to_ship ,DECODE(p_new_comp_item.required_to_ship
1716: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship

Line 1714: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed

1710: ,fnd_api.g_miss_num ,bic.mutually_exclusive_options ,p_new_comp_item.mutually_exclusive)) mutually_exclusive
1711: ,DECODE(p_new_comp_item ,NULL ,bic.check_atp ,DECODE(p_new_comp_item.check_atp
1712: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp
1713: ,DECODE(p_new_comp_item ,NULL ,bic.shipping_allowed ,DECODE(p_new_comp_item.shipping_allowed
1714: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed
1715: ,DECODE(p_new_comp_item ,NULL ,bic.required_to_ship ,DECODE(p_new_comp_item.required_to_ship
1716: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship
1717: ,DECODE(p_new_comp_item ,NULL ,bic.required_for_revenue ,DECODE(p_new_comp_item.required_for_revenue
1718: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue

Line 1716: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship

1712: ,fnd_api.g_miss_num ,bic.check_atp ,p_new_comp_item.check_atp)) check_atp
1713: ,DECODE(p_new_comp_item ,NULL ,bic.shipping_allowed ,DECODE(p_new_comp_item.shipping_allowed
1714: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed
1715: ,DECODE(p_new_comp_item ,NULL ,bic.required_to_ship ,DECODE(p_new_comp_item.required_to_ship
1716: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship
1717: ,DECODE(p_new_comp_item ,NULL ,bic.required_for_revenue ,DECODE(p_new_comp_item.required_for_revenue
1718: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue
1719: ,DECODE(p_new_comp_item ,NULL ,bic.include_on_ship_docs ,DECODE(p_new_comp_item.include_on_ship_docs
1720: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs

Line 1718: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue

1714: ,fnd_api.g_miss_num ,bic.shipping_allowed ,p_new_comp_item.shipping_allowed)) shipping_allowed
1715: ,DECODE(p_new_comp_item ,NULL ,bic.required_to_ship ,DECODE(p_new_comp_item.required_to_ship
1716: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship
1717: ,DECODE(p_new_comp_item ,NULL ,bic.required_for_revenue ,DECODE(p_new_comp_item.required_for_revenue
1718: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue
1719: ,DECODE(p_new_comp_item ,NULL ,bic.include_on_ship_docs ,DECODE(p_new_comp_item.include_on_ship_docs
1720: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs
1721: ,DECODE(p_new_comp_item ,NULL ,bic.quantity_related ,DECODE(p_new_comp_item.quantity_related
1722: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related

Line 1720: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs

1716: ,fnd_api.g_miss_num ,bic.required_to_ship ,p_new_comp_item.required_to_ship)) required_to_ship
1717: ,DECODE(p_new_comp_item ,NULL ,bic.required_for_revenue ,DECODE(p_new_comp_item.required_for_revenue
1718: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue
1719: ,DECODE(p_new_comp_item ,NULL ,bic.include_on_ship_docs ,DECODE(p_new_comp_item.include_on_ship_docs
1720: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs
1721: ,DECODE(p_new_comp_item ,NULL ,bic.quantity_related ,DECODE(p_new_comp_item.quantity_related
1722: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related
1723: ,DECODE(p_new_comp_item ,NULL ,bic.supply_subinventory ,DECODE(p_new_comp_item.supply_subinventory
1724: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory

Line 1722: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related

1718: ,fnd_api.g_miss_num ,bic.required_for_revenue ,p_new_comp_item.required_for_revenue)) required_for_revenue
1719: ,DECODE(p_new_comp_item ,NULL ,bic.include_on_ship_docs ,DECODE(p_new_comp_item.include_on_ship_docs
1720: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs
1721: ,DECODE(p_new_comp_item ,NULL ,bic.quantity_related ,DECODE(p_new_comp_item.quantity_related
1722: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related
1723: ,DECODE(p_new_comp_item ,NULL ,bic.supply_subinventory ,DECODE(p_new_comp_item.supply_subinventory
1724: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory
1725: ,DECODE(p_new_comp_item ,NULL ,bic.attribute_category ,DECODE(p_new_comp_item.attribute_category
1726: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category

Line 1724: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory

1720: ,fnd_api.g_miss_num ,bic.include_on_ship_docs ,p_new_comp_item.include_on_ship_docs)) include_on_ship_docs
1721: ,DECODE(p_new_comp_item ,NULL ,bic.quantity_related ,DECODE(p_new_comp_item.quantity_related
1722: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related
1723: ,DECODE(p_new_comp_item ,NULL ,bic.supply_subinventory ,DECODE(p_new_comp_item.supply_subinventory
1724: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory
1725: ,DECODE(p_new_comp_item ,NULL ,bic.attribute_category ,DECODE(p_new_comp_item.attribute_category
1726: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category
1727: ,DECODE(p_new_comp_item ,NULL ,bic.attribute1 ,DECODE(p_new_comp_item.attribute1
1728: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1

Line 1726: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category

1722: ,fnd_api.g_miss_num ,bic.quantity_related ,p_new_comp_item.quantity_related)) quantity_related
1723: ,DECODE(p_new_comp_item ,NULL ,bic.supply_subinventory ,DECODE(p_new_comp_item.supply_subinventory
1724: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory
1725: ,DECODE(p_new_comp_item ,NULL ,bic.attribute_category ,DECODE(p_new_comp_item.attribute_category
1726: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category
1727: ,DECODE(p_new_comp_item ,NULL ,bic.attribute1 ,DECODE(p_new_comp_item.attribute1
1728: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1
1729: ,DECODE(p_new_comp_item ,NULL ,bic.attribute2 ,DECODE(p_new_comp_item.attribute2
1730: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2

Line 1728: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1

1724: ,fnd_api.g_miss_char ,bic.supply_subinventory ,p_new_comp_item.supply_subinventory)) supply_subinventory
1725: ,DECODE(p_new_comp_item ,NULL ,bic.attribute_category ,DECODE(p_new_comp_item.attribute_category
1726: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category
1727: ,DECODE(p_new_comp_item ,NULL ,bic.attribute1 ,DECODE(p_new_comp_item.attribute1
1728: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1
1729: ,DECODE(p_new_comp_item ,NULL ,bic.attribute2 ,DECODE(p_new_comp_item.attribute2
1730: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2
1731: ,DECODE(p_new_comp_item ,NULL ,bic.attribute3 ,DECODE(p_new_comp_item.attribute3
1732: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3

Line 1730: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2

1726: ,fnd_api.g_miss_char ,bic.attribute_category ,p_new_comp_item.attribute_category)) attribute_category
1727: ,DECODE(p_new_comp_item ,NULL ,bic.attribute1 ,DECODE(p_new_comp_item.attribute1
1728: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1
1729: ,DECODE(p_new_comp_item ,NULL ,bic.attribute2 ,DECODE(p_new_comp_item.attribute2
1730: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2
1731: ,DECODE(p_new_comp_item ,NULL ,bic.attribute3 ,DECODE(p_new_comp_item.attribute3
1732: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3
1733: ,DECODE(p_new_comp_item ,NULL ,bic.attribute4 ,DECODE(p_new_comp_item.attribute4
1734: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4

Line 1732: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3

1728: ,fnd_api.g_miss_char ,bic.attribute1 ,p_new_comp_item.attribute1)) attribute1
1729: ,DECODE(p_new_comp_item ,NULL ,bic.attribute2 ,DECODE(p_new_comp_item.attribute2
1730: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2
1731: ,DECODE(p_new_comp_item ,NULL ,bic.attribute3 ,DECODE(p_new_comp_item.attribute3
1732: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3
1733: ,DECODE(p_new_comp_item ,NULL ,bic.attribute4 ,DECODE(p_new_comp_item.attribute4
1734: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4
1735: ,DECODE(p_new_comp_item ,NULL ,bic.attribute5 ,DECODE(p_new_comp_item.attribute5
1736: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5

Line 1734: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4

1730: ,fnd_api.g_miss_char ,bic.attribute2 ,p_new_comp_item.attribute2)) attribute2
1731: ,DECODE(p_new_comp_item ,NULL ,bic.attribute3 ,DECODE(p_new_comp_item.attribute3
1732: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3
1733: ,DECODE(p_new_comp_item ,NULL ,bic.attribute4 ,DECODE(p_new_comp_item.attribute4
1734: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4
1735: ,DECODE(p_new_comp_item ,NULL ,bic.attribute5 ,DECODE(p_new_comp_item.attribute5
1736: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5
1737: ,DECODE(p_new_comp_item ,NULL ,bic.attribute6 ,DECODE(p_new_comp_item.attribute6
1738: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6

Line 1736: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5

1732: ,fnd_api.g_miss_char ,bic.attribute3 ,p_new_comp_item.attribute3)) attribute3
1733: ,DECODE(p_new_comp_item ,NULL ,bic.attribute4 ,DECODE(p_new_comp_item.attribute4
1734: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4
1735: ,DECODE(p_new_comp_item ,NULL ,bic.attribute5 ,DECODE(p_new_comp_item.attribute5
1736: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5
1737: ,DECODE(p_new_comp_item ,NULL ,bic.attribute6 ,DECODE(p_new_comp_item.attribute6
1738: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6
1739: ,DECODE(p_new_comp_item ,NULL ,bic.attribute7 ,DECODE(p_new_comp_item.attribute7
1740: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7

Line 1738: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6

1734: ,fnd_api.g_miss_char ,bic.attribute4 ,p_new_comp_item.attribute4)) attribute4
1735: ,DECODE(p_new_comp_item ,NULL ,bic.attribute5 ,DECODE(p_new_comp_item.attribute5
1736: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5
1737: ,DECODE(p_new_comp_item ,NULL ,bic.attribute6 ,DECODE(p_new_comp_item.attribute6
1738: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6
1739: ,DECODE(p_new_comp_item ,NULL ,bic.attribute7 ,DECODE(p_new_comp_item.attribute7
1740: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7
1741: ,DECODE(p_new_comp_item ,NULL ,bic.attribute8 ,DECODE(p_new_comp_item.attribute8
1742: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8

Line 1740: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7

1736: ,fnd_api.g_miss_char ,bic.attribute5 ,p_new_comp_item.attribute5)) attribute5
1737: ,DECODE(p_new_comp_item ,NULL ,bic.attribute6 ,DECODE(p_new_comp_item.attribute6
1738: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6
1739: ,DECODE(p_new_comp_item ,NULL ,bic.attribute7 ,DECODE(p_new_comp_item.attribute7
1740: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7
1741: ,DECODE(p_new_comp_item ,NULL ,bic.attribute8 ,DECODE(p_new_comp_item.attribute8
1742: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8
1743: ,DECODE(p_new_comp_item ,NULL ,bic.attribute9 ,DECODE(p_new_comp_item.attribute9
1744: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9

Line 1742: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8

1738: ,fnd_api.g_miss_char ,bic.attribute6 ,p_new_comp_item.attribute6)) attribute6
1739: ,DECODE(p_new_comp_item ,NULL ,bic.attribute7 ,DECODE(p_new_comp_item.attribute7
1740: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7
1741: ,DECODE(p_new_comp_item ,NULL ,bic.attribute8 ,DECODE(p_new_comp_item.attribute8
1742: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8
1743: ,DECODE(p_new_comp_item ,NULL ,bic.attribute9 ,DECODE(p_new_comp_item.attribute9
1744: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9
1745: ,DECODE(p_new_comp_item ,NULL ,bic.attribute10 ,DECODE(p_new_comp_item.attribute10
1746: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10

Line 1744: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9

1740: ,fnd_api.g_miss_char ,bic.attribute7 ,p_new_comp_item.attribute7)) attribute7
1741: ,DECODE(p_new_comp_item ,NULL ,bic.attribute8 ,DECODE(p_new_comp_item.attribute8
1742: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8
1743: ,DECODE(p_new_comp_item ,NULL ,bic.attribute9 ,DECODE(p_new_comp_item.attribute9
1744: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9
1745: ,DECODE(p_new_comp_item ,NULL ,bic.attribute10 ,DECODE(p_new_comp_item.attribute10
1746: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10
1747: ,DECODE(p_new_comp_item ,NULL ,bic.attribute11 ,DECODE(p_new_comp_item.attribute11
1748: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11

Line 1746: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10

1742: ,fnd_api.g_miss_char ,bic.attribute8 ,p_new_comp_item.attribute8)) attribute8
1743: ,DECODE(p_new_comp_item ,NULL ,bic.attribute9 ,DECODE(p_new_comp_item.attribute9
1744: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9
1745: ,DECODE(p_new_comp_item ,NULL ,bic.attribute10 ,DECODE(p_new_comp_item.attribute10
1746: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10
1747: ,DECODE(p_new_comp_item ,NULL ,bic.attribute11 ,DECODE(p_new_comp_item.attribute11
1748: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11
1749: ,DECODE(p_new_comp_item ,NULL ,bic.attribute12 ,DECODE(p_new_comp_item.attribute12
1750: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12

Line 1748: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11

1744: ,fnd_api.g_miss_char ,bic.attribute9 ,p_new_comp_item.attribute9)) attribute9
1745: ,DECODE(p_new_comp_item ,NULL ,bic.attribute10 ,DECODE(p_new_comp_item.attribute10
1746: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10
1747: ,DECODE(p_new_comp_item ,NULL ,bic.attribute11 ,DECODE(p_new_comp_item.attribute11
1748: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11
1749: ,DECODE(p_new_comp_item ,NULL ,bic.attribute12 ,DECODE(p_new_comp_item.attribute12
1750: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12
1751: ,DECODE(p_new_comp_item ,NULL ,bic.attribute13 ,DECODE(p_new_comp_item.attribute13
1752: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13

Line 1750: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12

1746: ,fnd_api.g_miss_char ,bic.attribute10 ,p_new_comp_item.attribute10)) attribute10
1747: ,DECODE(p_new_comp_item ,NULL ,bic.attribute11 ,DECODE(p_new_comp_item.attribute11
1748: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11
1749: ,DECODE(p_new_comp_item ,NULL ,bic.attribute12 ,DECODE(p_new_comp_item.attribute12
1750: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12
1751: ,DECODE(p_new_comp_item ,NULL ,bic.attribute13 ,DECODE(p_new_comp_item.attribute13
1752: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13
1753: ,DECODE(p_new_comp_item ,NULL ,bic.attribute14 ,DECODE(p_new_comp_item.attribute14
1754: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14

Line 1752: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13

1748: ,fnd_api.g_miss_char ,bic.attribute11 ,p_new_comp_item.attribute11)) attribute11
1749: ,DECODE(p_new_comp_item ,NULL ,bic.attribute12 ,DECODE(p_new_comp_item.attribute12
1750: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12
1751: ,DECODE(p_new_comp_item ,NULL ,bic.attribute13 ,DECODE(p_new_comp_item.attribute13
1752: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13
1753: ,DECODE(p_new_comp_item ,NULL ,bic.attribute14 ,DECODE(p_new_comp_item.attribute14
1754: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14
1755: ,DECODE(p_new_comp_item ,NULL ,bic.attribute15 ,DECODE(p_new_comp_item.attribute15
1756: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15

Line 1754: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14

1750: ,fnd_api.g_miss_char ,bic.attribute12 ,p_new_comp_item.attribute12)) attribute12
1751: ,DECODE(p_new_comp_item ,NULL ,bic.attribute13 ,DECODE(p_new_comp_item.attribute13
1752: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13
1753: ,DECODE(p_new_comp_item ,NULL ,bic.attribute14 ,DECODE(p_new_comp_item.attribute14
1754: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14
1755: ,DECODE(p_new_comp_item ,NULL ,bic.attribute15 ,DECODE(p_new_comp_item.attribute15
1756: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15
1757: ,DECODE(p_new_comp_item ,NULL ,bic.from_end_item_unit_number ,DECODE(p_new_comp_item.from_end_item_unit_number
1758: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number

Line 1756: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15

1752: ,fnd_api.g_miss_char ,bic.attribute13 ,p_new_comp_item.attribute13)) attribute13
1753: ,DECODE(p_new_comp_item ,NULL ,bic.attribute14 ,DECODE(p_new_comp_item.attribute14
1754: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14
1755: ,DECODE(p_new_comp_item ,NULL ,bic.attribute15 ,DECODE(p_new_comp_item.attribute15
1756: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15
1757: ,DECODE(p_new_comp_item ,NULL ,bic.from_end_item_unit_number ,DECODE(p_new_comp_item.from_end_item_unit_number
1758: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number
1759: ,DECODE(p_new_comp_item ,NULL ,bic.to_end_item_unit_number ,DECODE(p_new_comp_item.to_end_item_unit_number
1760: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number

Line 1758: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number

1754: ,fnd_api.g_miss_char ,bic.attribute14 ,p_new_comp_item.attribute14)) attribute14
1755: ,DECODE(p_new_comp_item ,NULL ,bic.attribute15 ,DECODE(p_new_comp_item.attribute15
1756: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15
1757: ,DECODE(p_new_comp_item ,NULL ,bic.from_end_item_unit_number ,DECODE(p_new_comp_item.from_end_item_unit_number
1758: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number
1759: ,DECODE(p_new_comp_item ,NULL ,bic.to_end_item_unit_number ,DECODE(p_new_comp_item.to_end_item_unit_number
1760: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number
1761: ,DECODE(p_new_comp_item ,NULL ,bic.enforce_int_requirements ,DECODE(p_new_comp_item.enforce_int_requirements
1762: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements

Line 1760: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number

1756: ,fnd_api.g_miss_char ,bic.attribute15 ,p_new_comp_item.attribute15)) attribute15
1757: ,DECODE(p_new_comp_item ,NULL ,bic.from_end_item_unit_number ,DECODE(p_new_comp_item.from_end_item_unit_number
1758: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number
1759: ,DECODE(p_new_comp_item ,NULL ,bic.to_end_item_unit_number ,DECODE(p_new_comp_item.to_end_item_unit_number
1760: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number
1761: ,DECODE(p_new_comp_item ,NULL ,bic.enforce_int_requirements ,DECODE(p_new_comp_item.enforce_int_requirements
1762: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements
1763: ,DECODE(p_new_comp_item ,NULL ,bic.auto_request_material ,DECODE(p_new_comp_item.auto_request_material
1764: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material

Line 1762: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements

1758: ,fnd_api.g_miss_char ,bic.from_end_item_unit_number ,p_new_comp_item.from_end_item_unit_number)) from_end_item_unit_number
1759: ,DECODE(p_new_comp_item ,NULL ,bic.to_end_item_unit_number ,DECODE(p_new_comp_item.to_end_item_unit_number
1760: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number
1761: ,DECODE(p_new_comp_item ,NULL ,bic.enforce_int_requirements ,DECODE(p_new_comp_item.enforce_int_requirements
1762: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements
1763: ,DECODE(p_new_comp_item ,NULL ,bic.auto_request_material ,DECODE(p_new_comp_item.auto_request_material
1764: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material
1765: ,DECODE(p_new_comp_item ,NULL ,bic.suggested_vendor_name ,DECODE(p_new_comp_item.suggested_vendor_name
1766: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name

Line 1764: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material

1760: ,fnd_api.g_miss_char ,bic.to_end_item_unit_number ,p_new_comp_item.to_end_item_unit_number)) to_end_item_unit_number
1761: ,DECODE(p_new_comp_item ,NULL ,bic.enforce_int_requirements ,DECODE(p_new_comp_item.enforce_int_requirements
1762: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements
1763: ,DECODE(p_new_comp_item ,NULL ,bic.auto_request_material ,DECODE(p_new_comp_item.auto_request_material
1764: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material
1765: ,DECODE(p_new_comp_item ,NULL ,bic.suggested_vendor_name ,DECODE(p_new_comp_item.suggested_vendor_name
1766: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name
1767: ,DECODE(p_new_comp_item ,NULL ,bic.unit_price ,DECODE(p_new_comp_item.unit_price
1768: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price

Line 1766: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name

1762: ,fnd_api.g_miss_char ,bic.enforce_int_requirements ,p_new_comp_item.enforce_int_requirements)) enforce_int_requirements
1763: ,DECODE(p_new_comp_item ,NULL ,bic.auto_request_material ,DECODE(p_new_comp_item.auto_request_material
1764: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material
1765: ,DECODE(p_new_comp_item ,NULL ,bic.suggested_vendor_name ,DECODE(p_new_comp_item.suggested_vendor_name
1766: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name
1767: ,DECODE(p_new_comp_item ,NULL ,bic.unit_price ,DECODE(p_new_comp_item.unit_price
1768: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price
1769: ,DECODE(p_new_comp_item ,NULL ,bic.original_system_reference ,DECODE(p_new_comp_item.original_system_reference
1770: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference

Line 1768: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price

1764: ,fnd_api.g_miss_char ,bic.auto_request_material ,p_new_comp_item.auto_request_material)) auto_request_material
1765: ,DECODE(p_new_comp_item ,NULL ,bic.suggested_vendor_name ,DECODE(p_new_comp_item.suggested_vendor_name
1766: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name
1767: ,DECODE(p_new_comp_item ,NULL ,bic.unit_price ,DECODE(p_new_comp_item.unit_price
1768: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price
1769: ,DECODE(p_new_comp_item ,NULL ,bic.original_system_reference ,DECODE(p_new_comp_item.original_system_reference
1770: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference
1771: ,DECODE(p_new_comp_item ,NULL ,SYSDATE ,DECODE(p_new_comp_item.start_effective_date
1772: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date

Line 1770: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference

1766: ,fnd_api.g_miss_char ,bic.suggested_vendor_name ,p_new_comp_item.suggested_vendor_name)) suggested_vendor_name
1767: ,DECODE(p_new_comp_item ,NULL ,bic.unit_price ,DECODE(p_new_comp_item.unit_price
1768: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price
1769: ,DECODE(p_new_comp_item ,NULL ,bic.original_system_reference ,DECODE(p_new_comp_item.original_system_reference
1770: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference
1771: ,DECODE(p_new_comp_item ,NULL ,SYSDATE ,DECODE(p_new_comp_item.start_effective_date
1772: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date
1773: ,DECODE(p_new_comp_item ,NULL ,bic.item_num ,DECODE(p_new_comp_item.item_sequence_number
1774: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number

Line 1772: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date

1768: ,fnd_api.g_miss_num ,bic.unit_price ,p_new_comp_item.unit_price)) unit_price
1769: ,DECODE(p_new_comp_item ,NULL ,bic.original_system_reference ,DECODE(p_new_comp_item.original_system_reference
1770: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference
1771: ,DECODE(p_new_comp_item ,NULL ,SYSDATE ,DECODE(p_new_comp_item.start_effective_date
1772: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date
1773: ,DECODE(p_new_comp_item ,NULL ,bic.item_num ,DECODE(p_new_comp_item.item_sequence_number
1774: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number
1775: ,DECODE(p_new_comp_item ,NULL ,bic.planning_factor ,DECODE(p_new_comp_item.planning_percent
1776: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent

Line 1774: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number

1770: ,fnd_api.g_miss_num ,bic.original_system_reference ,p_new_comp_item.original_system_reference)) original_system_reference
1771: ,DECODE(p_new_comp_item ,NULL ,SYSDATE ,DECODE(p_new_comp_item.start_effective_date
1772: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date
1773: ,DECODE(p_new_comp_item ,NULL ,bic.item_num ,DECODE(p_new_comp_item.item_sequence_number
1774: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number
1775: ,DECODE(p_new_comp_item ,NULL ,bic.planning_factor ,DECODE(p_new_comp_item.planning_percent
1776: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent
1777: ,DECODE(p_new_comp_item ,NULL ,bic.component_yield_factor ,DECODE(p_new_comp_item.projected_yield
1778: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield

Line 1776: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent

1772: ,fnd_api.g_miss_date ,bic.effectivity_date ,p_new_comp_item.start_effective_date)) start_effective_date
1773: ,DECODE(p_new_comp_item ,NULL ,bic.item_num ,DECODE(p_new_comp_item.item_sequence_number
1774: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number
1775: ,DECODE(p_new_comp_item ,NULL ,bic.planning_factor ,DECODE(p_new_comp_item.planning_percent
1776: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent
1777: ,DECODE(p_new_comp_item ,NULL ,bic.component_yield_factor ,DECODE(p_new_comp_item.projected_yield
1778: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield
1779: ,DECODE(p_new_comp_item ,NULL ,bic.high_quantity ,DECODE(p_new_comp_item.maximum_allowed_quantity
1780: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity

Line 1778: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield

1774: ,fnd_api.g_miss_num ,bic.item_num ,p_new_comp_item.item_sequence_number)) item_sequence_number
1775: ,DECODE(p_new_comp_item ,NULL ,bic.planning_factor ,DECODE(p_new_comp_item.planning_percent
1776: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent
1777: ,DECODE(p_new_comp_item ,NULL ,bic.component_yield_factor ,DECODE(p_new_comp_item.projected_yield
1778: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield
1779: ,DECODE(p_new_comp_item ,NULL ,bic.high_quantity ,DECODE(p_new_comp_item.maximum_allowed_quantity
1780: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity
1781: ,DECODE(p_new_comp_item ,NULL ,bic.low_quantity ,DECODE(p_new_comp_item.minimum_allowed_quantity
1782: ,fnd_api.g_miss_num ,bic.low_quantity ,p_new_comp_item.minimum_allowed_quantity)) minimum_allowed_quantity

Line 1780: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity

1776: ,fnd_api.g_miss_num ,bic.planning_factor ,p_new_comp_item.planning_percent)) planning_percent
1777: ,DECODE(p_new_comp_item ,NULL ,bic.component_yield_factor ,DECODE(p_new_comp_item.projected_yield
1778: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield
1779: ,DECODE(p_new_comp_item ,NULL ,bic.high_quantity ,DECODE(p_new_comp_item.maximum_allowed_quantity
1780: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity
1781: ,DECODE(p_new_comp_item ,NULL ,bic.low_quantity ,DECODE(p_new_comp_item.minimum_allowed_quantity
1782: ,fnd_api.g_miss_num ,bic.low_quantity ,p_new_comp_item.minimum_allowed_quantity)) minimum_allowed_quantity
1783: ,DECODE(p_new_comp_item ,NULL ,bic.component_remarks ,DECODE(p_new_comp_item.comments
1784: ,fnd_api.g_miss_char ,component_remarks ,p_new_comp_item.comments)) comments

Line 1782: ,fnd_api.g_miss_num ,bic.low_quantity ,p_new_comp_item.minimum_allowed_quantity)) minimum_allowed_quantity

1778: ,fnd_api.g_miss_num ,bic.component_yield_factor ,p_new_comp_item.projected_yield)) projected_yield
1779: ,DECODE(p_new_comp_item ,NULL ,bic.high_quantity ,DECODE(p_new_comp_item.maximum_allowed_quantity
1780: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity
1781: ,DECODE(p_new_comp_item ,NULL ,bic.low_quantity ,DECODE(p_new_comp_item.minimum_allowed_quantity
1782: ,fnd_api.g_miss_num ,bic.low_quantity ,p_new_comp_item.minimum_allowed_quantity)) minimum_allowed_quantity
1783: ,DECODE(p_new_comp_item ,NULL ,bic.component_remarks ,DECODE(p_new_comp_item.comments
1784: ,fnd_api.g_miss_char ,component_remarks ,p_new_comp_item.comments)) comments
1785: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.new_effectivity_date) new_effectivity_date
1786: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.old_effectivity_date) old_effectivity_date

Line 1784: ,fnd_api.g_miss_char ,component_remarks ,p_new_comp_item.comments)) comments

1780: ,fnd_api.g_miss_num ,bic.high_quantity ,p_new_comp_item.maximum_allowed_quantity)) maximum_allowed_quantity
1781: ,DECODE(p_new_comp_item ,NULL ,bic.low_quantity ,DECODE(p_new_comp_item.minimum_allowed_quantity
1782: ,fnd_api.g_miss_num ,bic.low_quantity ,p_new_comp_item.minimum_allowed_quantity)) minimum_allowed_quantity
1783: ,DECODE(p_new_comp_item ,NULL ,bic.component_remarks ,DECODE(p_new_comp_item.comments
1784: ,fnd_api.g_miss_char ,component_remarks ,p_new_comp_item.comments)) comments
1785: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.new_effectivity_date) new_effectivity_date
1786: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.old_effectivity_date) old_effectivity_date
1787: ,DECODE(p_new_comp_item ,NULL ,1 ,p_new_comp_item.old_operation_sequence_number) old_operation_sequence_number
1788: ,DECODE(p_new_comp_item ,NULL ,1 ,p_new_comp_item.new_operation_sequence_number) new_operation_sequence_number

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

1809: l_revised_comp_tbl inv_ebi_rev_comp_tbl;
1810: l_revised_comp_count NUMBER := 1;
1811: l_output_status inv_ebi_output_status;
1812: BEGIN
1813: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1814: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1815: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items');
1816: IF (bom_eamutil.enabled = 'Y'
1817: AND bom_eamutil.serial_effective_item (item_id => p_from_item_id,

Line 2050: WHEN FND_API.g_exc_unexpected_error THEN

2046: x_revised_item := l_revised_item;
2047:
2048:
2049: EXCEPTION
2050: WHEN FND_API.g_exc_unexpected_error THEN
2051: IF c_copied_comps%ISOPEN THEN
2052: CLOSE c_copied_comps;
2053: END IF;
2054: IF c_merged_component%ISOPEN THEN

Line 2057: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

2053: END IF;
2054: IF c_merged_component%ISOPEN THEN
2055: CLOSE c_merged_component;
2056: END IF;
2057: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2058: IF(x_out.output_status.msg_data IS NULL) THEN
2059: fnd_msg_pub.count_and_get(
2060: p_encoded => FND_API.g_false
2061: ,p_count => x_out.output_status.msg_count

Line 2060: p_encoded => FND_API.g_false

2056: END IF;
2057: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2058: IF(x_out.output_status.msg_data IS NULL) THEN
2059: fnd_msg_pub.count_and_get(
2060: p_encoded => FND_API.g_false
2061: ,p_count => x_out.output_status.msg_count
2062: ,p_data => x_out.output_status.msg_data
2063: );
2064: END IF;

Line 2072: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

2068: END IF;
2069: IF c_merged_component%ISOPEN THEN
2070: CLOSE c_merged_component;
2071: END IF;
2072: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2073: IF (x_out.output_status.msg_data IS NOT NULL) THEN
2074: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items ';
2075: ELSE
2076: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items ';

Line 2113: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS '|| FND_API.g_true);

2109: ((p_alternate_bom_code IS NULL AND bb.alternate_bom_designator IS NULL) OR
2110: (bb.alternate_bom_designator = p_alternate_bom_code));
2111:
2112: IF l_Count = 1 THEN
2113: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS '|| FND_API.g_true);
2114: RETURN FND_API.g_true;
2115: END IF;
2116: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS ' || FND_API.g_false);
2117: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_Exists');

Line 2114: RETURN FND_API.g_true;

2110: (bb.alternate_bom_designator = p_alternate_bom_code));
2111:
2112: IF l_Count = 1 THEN
2113: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS '|| FND_API.g_true);
2114: RETURN FND_API.g_true;
2115: END IF;
2116: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS ' || FND_API.g_false);
2117: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_Exists');
2118: RETURN FND_API.g_false;

Line 2116: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS ' || FND_API.g_false);

2112: IF l_Count = 1 THEN
2113: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS '|| FND_API.g_true);
2114: RETURN FND_API.g_true;
2115: END IF;
2116: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS ' || FND_API.g_false);
2117: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_Exists');
2118: RETURN FND_API.g_false;
2119:
2120: EXCEPTION

Line 2118: RETURN FND_API.g_false;

2114: RETURN FND_API.g_true;
2115: END IF;
2116: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS ' || FND_API.g_false);
2117: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_Exists');
2118: RETURN FND_API.g_false;
2119:
2120: EXCEPTION
2121: WHEN OTHERS THEN
2122: RETURN FND_API.g_false;

Line 2122: RETURN FND_API.g_false;

2118: RETURN FND_API.g_false;
2119:
2120: EXCEPTION
2121: WHEN OTHERS THEN
2122: RETURN FND_API.g_false;
2123: END Is_BOM_Exists;
2124:
2125: /************************************************************************************
2126: -- API name : Is_BOM_Already_Commoned

Line 2153: AND NVL(bb.alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

2149: AND it.organization_id = bb.organization_id
2150: AND bb.organization_id = mp.organization_id
2151: AND mp.organization_code = p_Organization_Code
2152: AND it.concatenated_segments = p_Item_Number
2153: AND NVL(bb.alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2154:
2155: IF( l_bill_sequence_id <> l_src_bill_sequence_id) THEN
2156:
2157: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS ' || FND_API.g_true);

Line 2157: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS ' || FND_API.g_true);

2153: AND NVL(bb.alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2154:
2155: IF( l_bill_sequence_id <> l_src_bill_sequence_id) THEN
2156:
2157: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS ' || FND_API.g_true);
2158: RETURN fnd_api.g_true;
2159:
2160: END IF;
2161:

Line 2158: RETURN fnd_api.g_true;

2154:
2155: IF( l_bill_sequence_id <> l_src_bill_sequence_id) THEN
2156:
2157: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS ' || FND_API.g_true);
2158: RETURN fnd_api.g_true;
2159:
2160: END IF;
2161:
2162: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS ' || FND_API.g_false);

Line 2162: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS ' || FND_API.g_false);

2158: RETURN fnd_api.g_true;
2159:
2160: END IF;
2161:
2162: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS ' || FND_API.g_false);
2163: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_ALready_Commoned');
2164: RETURN FND_API.g_false;
2165:
2166: EXCEPTION

Line 2164: RETURN FND_API.g_false;

2160: END IF;
2161:
2162: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS ' || FND_API.g_false);
2163: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_ALready_Commoned');
2164: RETURN FND_API.g_false;
2165:
2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: RETURN FND_API.g_false;

Line 2168: RETURN FND_API.g_false;

2164: RETURN FND_API.g_false;
2165:
2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: RETURN FND_API.g_false;
2169: END Is_BOM_ALready_Commoned;
2170:
2171:
2172: /************************************************************************************

Line 2205: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS '|| FND_API.g_true);

2201: msi.concatenated_segments = p_item_number AND
2202: eri.new_item_revision = p_revision ;
2203:
2204: IF l_Count >=1 THEN
2205: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS '|| FND_API.g_true);
2206: RETURN FND_API.g_true;
2207: END IF;
2208: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS '|| FND_API.g_false);
2209: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.is_new_revision_exists');

Line 2206: RETURN FND_API.g_true;

2202: eri.new_item_revision = p_revision ;
2203:
2204: IF l_Count >=1 THEN
2205: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS '|| FND_API.g_true);
2206: RETURN FND_API.g_true;
2207: END IF;
2208: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS '|| FND_API.g_false);
2209: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.is_new_revision_exists');
2210: RETURN FND_API.g_false;

Line 2208: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS '|| FND_API.g_false);

2204: IF l_Count >=1 THEN
2205: INV_EBI_UTIL.debug_line('STEP 30: RETURN STATUS '|| FND_API.g_true);
2206: RETURN FND_API.g_true;
2207: END IF;
2208: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS '|| FND_API.g_false);
2209: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.is_new_revision_exists');
2210: RETURN FND_API.g_false;
2211:
2212: EXCEPTION

Line 2210: RETURN FND_API.g_false;

2206: RETURN FND_API.g_true;
2207: END IF;
2208: INV_EBI_UTIL.debug_line('STEP 40: RETURN STATUS '|| FND_API.g_false);
2209: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.is_new_revision_exists');
2210: RETURN FND_API.g_false;
2211:
2212: EXCEPTION
2213: WHEN OTHERS THEN
2214: RETURN FND_API.g_false;

Line 2214: RETURN FND_API.g_false;

2210: RETURN FND_API.g_false;
2211:
2212: EXCEPTION
2213: WHEN OTHERS THEN
2214: RETURN FND_API.g_false;
2215: END is_new_revision_exists;
2216:
2217: /*******************************************************************************
2218: API name : is_child_org

Line 2236: RETURN FND_API.g_true;

2232: FROM mtl_parameters
2233: WHERE organization_id= p_organization_id;
2234:
2235: IF(l_master_org <> p_organization_id) THEN
2236: RETURN FND_API.g_true;
2237: ELSE
2238: RETURN FND_API.g_false;
2239: END IF;
2240:

Line 2238: RETURN FND_API.g_false;

2234:
2235: IF(l_master_org <> p_organization_id) THEN
2236: RETURN FND_API.g_true;
2237: ELSE
2238: RETURN FND_API.g_false;
2239: END IF;
2240:
2241: EXCEPTION
2242: WHEN OTHERS THEN

Line 2270: decode(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code);

2266: WHERE
2267: assembly_item_id = p_assembly_item_id AND
2268: organization_id = p_organization_id AND
2269: NVL(alternate_bom_designator, 'NONE') =
2270: decode(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code);
2271:
2272: RETURN l_bill_sequence_id;
2273:
2274: EXCEPTION

Line 2304: l_context_org_bom_exists VARCHAR2(1) := FND_API.g_false;

2300: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
2301: ) IS
2302: l_revised_item inv_ebi_revised_item_obj;
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;

Line 2305: l_ref_org_bom_exists VARCHAR2(1) := FND_API.g_false;

2301: ) IS
2302: l_revised_item inv_ebi_revised_item_obj;
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;

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

2326: l_output_status inv_ebi_output_status;
2327:
2328: BEGIN
2329: SAVEPOINT process_replicate_bom_save_pnt;
2330: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2331: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
2332: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');
2333: INV_EBI_UTIL.debug_line('STEP 20: ORG_CODE: '|| p_organization_code || ' REVISED ITEM NAME: '|| p_revised_item_obj.revised_item_name);
2334: l_context_org_code:= p_organization_code;

Line 2358: IF l_from_org_id IS NULL OR l_from_org_id = fnd_api.g_miss_num THEN

2354: l_revised_item.orignal_bom_reference.organization_code IS NOT NULL )) THEN
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

Line 2360: ELSIF l_reference_org_code IS NULL OR l_reference_org_code = fnd_api.g_miss_char THEN

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
2364: l_reference_org_code

Line 2408: IF (NOT FND_API.To_Boolean(l_context_org_bom_exists)) AND FND_API.To_Boolean(l_ref_org_bom_exists) THEN

2404: p_item_number => l_reference_item_num
2405: ,p_organization_code => l_reference_org_code
2406: ,p_alternate_bom_code => l_revised_item.orignal_bom_reference.alternate_bom_code
2407: );
2408: IF (NOT FND_API.To_Boolean(l_context_org_bom_exists)) AND FND_API.To_Boolean(l_ref_org_bom_exists) THEN
2409: SELECT
2410: bill_sequence_id
2411: INTO
2412: l_from_sequence_id

Line 2421: IF l_view_scope IS NULL OR l_view_scope = fnd_api.g_miss_char THEN

2417: organization_id = l_from_org_id AND
2418: ((l_revised_item.alternate_bom_code IS NULL AND alternate_bom_designator IS NULL) OR
2419: (alternate_bom_designator = l_revised_item.alternate_bom_code));
2420: l_view_scope := l_revised_item.orignal_bom_reference.view_scope;
2421: IF l_view_scope IS NULL OR l_view_scope = fnd_api.g_miss_char THEN
2422: l_view_scope := l_config_view_scope;
2423: END IF;
2424:
2425: l_impl_scope := l_revised_item.orignal_bom_reference.implementation_scope;

Line 2426: IF l_impl_scope IS NULL OR l_impl_scope = fnd_api.g_miss_char THEN

2422: l_view_scope := l_config_view_scope;
2423: END IF;
2424:
2425: l_impl_scope := l_revised_item.orignal_bom_reference.implementation_scope;
2426: IF l_impl_scope IS NULL OR l_impl_scope = fnd_api.g_miss_char THEN
2427: l_impl_scope := l_config_impl_scope;
2428: END IF;
2429:
2430: l_as_of_date := l_revised_item.orignal_bom_reference.as_of_date;

Line 2431: IF l_as_of_date IS NULL OR l_as_of_date = fnd_api.g_miss_date THEN

2427: l_impl_scope := l_config_impl_scope;
2428: END IF;
2429:
2430: l_as_of_date := l_revised_item.orignal_bom_reference.as_of_date;
2431: IF l_as_of_date IS NULL OR l_as_of_date = fnd_api.g_miss_date THEN
2432: l_as_of_date := SYSDATE;
2433: END IF;
2434: l_revised_item1 := l_revised_item;
2435: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items ');

Line 2449: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

2445: ,x_revised_item => l_revised_item
2446: ,x_out => x_out
2447: );
2448: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items STATUS: ' || x_out.output_status.return_status);
2449: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2450: RAISE FND_API.g_exc_unexpected_error;
2451: END IF;
2452:
2453: IF l_revised_item.component_item_tbl IS NOT NULL THEN

Line 2450: RAISE FND_API.g_exc_unexpected_error;

2446: ,x_out => x_out
2447: );
2448: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items STATUS: ' || x_out.output_status.return_status);
2449: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2450: RAISE FND_API.g_exc_unexpected_error;
2451: END IF;
2452:
2453: IF l_revised_item.component_item_tbl IS NOT NULL THEN
2454: FOR j IN 1..l_revised_item.component_item_tbl.COUNT LOOP

Line 2464: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

2460: ,x_component_item => l_component_item
2461: ,x_out => x_out
2462: );
2463: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components STATUS: '|| x_out.output_status.return_status);
2464: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2465: RAISE FND_API.g_exc_unexpected_error;
2466: END IF;
2467: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators'||'COMP ITEM NAME: '||l_component_item.component_item_name);
2468: prepare_reference_designators (

Line 2465: RAISE FND_API.g_exc_unexpected_error;

2461: ,x_out => x_out
2462: );
2463: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components STATUS: '|| x_out.output_status.return_status);
2464: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2465: RAISE FND_API.g_exc_unexpected_error;
2466: END IF;
2467: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators'||'COMP ITEM NAME: '||l_component_item.component_item_name);
2468: prepare_reference_designators (
2469: p_component_item => l_component_item

Line 2476: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

2472: ,x_component_item => l_component_item1
2473: ,x_out => x_out
2474: );
2475: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators STATUS: '|| x_out.output_status.return_status);
2476: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2477: RAISE FND_API.g_exc_unexpected_error;
2478: END IF;
2479:
2480: l_revised_item.component_item_tbl(j) := l_component_item1;

Line 2477: RAISE FND_API.g_exc_unexpected_error;

2473: ,x_out => x_out
2474: );
2475: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators STATUS: '|| x_out.output_status.return_status);
2476: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2477: RAISE FND_API.g_exc_unexpected_error;
2478: END IF;
2479:
2480: l_revised_item.component_item_tbl(j) := l_component_item1;
2481: END LOOP;

Line 2491: WHEN FND_API.g_exc_unexpected_error THEN

2487: --END IF;
2488: x_revised_item_obj := l_revised_item;
2489: INV_EBI_UTIL.debug_line('STEP 110: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ');
2490: EXCEPTION
2491: WHEN FND_API.g_exc_unexpected_error THEN
2492: ROLLBACK TO process_replicate_bom_save_pnt;
2493: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2494: IF(x_out.output_status.msg_data IS NULL) THEN
2495: fnd_msg_pub.count_and_get(

Line 2493: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

2489: INV_EBI_UTIL.debug_line('STEP 110: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ');
2490: EXCEPTION
2491: WHEN FND_API.g_exc_unexpected_error THEN
2492: ROLLBACK TO process_replicate_bom_save_pnt;
2493: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2494: IF(x_out.output_status.msg_data IS NULL) THEN
2495: fnd_msg_pub.count_and_get(
2496: p_encoded => FND_API.g_false
2497: ,p_count => x_out.output_status.msg_count

Line 2496: p_encoded => FND_API.g_false

2492: ROLLBACK TO process_replicate_bom_save_pnt;
2493: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2494: IF(x_out.output_status.msg_data IS NULL) THEN
2495: fnd_msg_pub.count_and_get(
2496: p_encoded => FND_API.g_false
2497: ,p_count => x_out.output_status.msg_count
2498: ,p_data => x_out.output_status.msg_data
2499: );
2500: END IF;

Line 2503: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

2499: );
2500: END IF;
2501: WHEN OTHERS THEN
2502: ROLLBACK TO process_replicate_bom_save_pnt;
2503: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2504: IF (x_out.output_status.msg_data IS NOT NULL) THEN
2505: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ';
2506: ELSE
2507: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ';

Line 2518: p_commit IN VARCHAR2 := FND_API.g_false

2514: -- Function :
2515: --
2516: ************************************************************************************/
2517: PROCEDURE process_uda (
2518: p_commit IN VARCHAR2 := FND_API.g_false
2519: ,p_api_version IN NUMBER DEFAULT 1.0
2520: ,p_uda_input_obj IN inv_ebi_uda_input_obj
2521: ,p_object_name IN VARCHAR2
2522: ,p_data_level IN VARCHAR2

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

2534: BEGIN
2535: SAVEPOINT inv_ebi_process_uda_save_pnt;
2536: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_uda');
2537: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
2538: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2539: x_uda_output_obj := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,l_uda_out);
2540: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_UTIL.transform_uda');
2541: --To convert inv_ebi uda objects to ego uda compatible objects
2542: INV_EBI_UTIL.transform_uda (

Line 2551: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN

2547: ,x_msg_count => x_uda_output_obj.output_status.msg_count
2548: ,x_msg_data => x_uda_output_obj.output_status.msg_data
2549: );
2550: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_UTIL.transform_uda STATUS: '|| x_uda_output_obj.output_status.return_status);
2551: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2552: RAISE FND_API.g_exc_unexpected_error;
2553: END IF;
2554:
2555: FOR i in 1..l_attributes_row_table.COUNT

Line 2552: RAISE FND_API.g_exc_unexpected_error;

2548: ,x_msg_data => x_uda_output_obj.output_status.msg_data
2549: );
2550: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_UTIL.transform_uda STATUS: '|| x_uda_output_obj.output_status.return_status);
2551: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2552: RAISE FND_API.g_exc_unexpected_error;
2553: END IF;
2554:
2555: FOR i in 1..l_attributes_row_table.COUNT
2556: LOOP

Line 2607: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN

2603: ,x_msg_count => x_uda_output_obj.output_status.msg_count
2604: ,x_msg_data => x_uda_output_obj.output_status.msg_data
2605: );
2606: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING ego_user_attrs_data_pub.process_user_attrs_data STATUS: ' || x_uda_output_obj.output_status.return_status);
2607: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2608: RAISE FND_API.g_exc_unexpected_error;
2609: END IF;
2610:
2611: IF FND_API.To_Boolean(p_commit) THEN

Line 2608: RAISE FND_API.g_exc_unexpected_error;

2604: ,x_msg_data => x_uda_output_obj.output_status.msg_data
2605: );
2606: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING ego_user_attrs_data_pub.process_user_attrs_data STATUS: ' || x_uda_output_obj.output_status.return_status);
2607: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2608: RAISE FND_API.g_exc_unexpected_error;
2609: END IF;
2610:
2611: IF FND_API.To_Boolean(p_commit) THEN
2612: COMMIT;

Line 2611: IF FND_API.To_Boolean(p_commit) THEN

2607: IF (x_uda_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2608: RAISE FND_API.g_exc_unexpected_error;
2609: END IF;
2610:
2611: IF FND_API.To_Boolean(p_commit) THEN
2612: COMMIT;
2613: END IF;
2614: INV_EBI_UTIL.debug_line('STEP 60: END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');
2615: EXCEPTION

Line 2616: WHEN FND_API.g_exc_unexpected_error THEN

2612: COMMIT;
2613: END IF;
2614: INV_EBI_UTIL.debug_line('STEP 60: END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');
2615: EXCEPTION
2616: WHEN FND_API.g_exc_unexpected_error THEN
2617: ROLLBACK TO inv_ebi_process_uda_save_pnt;
2618: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
2619:
2620: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN

Line 2618: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;

2614: INV_EBI_UTIL.debug_line('STEP 60: END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');
2615: EXCEPTION
2616: WHEN FND_API.g_exc_unexpected_error THEN
2617: ROLLBACK TO inv_ebi_process_uda_save_pnt;
2618: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
2619:
2620: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2621: fnd_msg_pub.count_and_get(
2622: p_encoded => FND_API.g_false

Line 2622: p_encoded => FND_API.g_false

2618: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_error;
2619:
2620: IF(x_uda_output_obj.output_status.msg_data IS NULL) THEN
2621: fnd_msg_pub.count_and_get(
2622: p_encoded => FND_API.g_false
2623: ,p_count => x_uda_output_obj.output_status.msg_count
2624: ,p_data => x_uda_output_obj.output_status.msg_data
2625: );
2626: END IF;

Line 2630: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;

2626: END IF;
2627:
2628: WHEN OTHERS THEN
2629: ROLLBACK TO inv_ebi_process_uda_save_pnt;
2630: x_uda_output_obj.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2631: IF (x_uda_output_obj.output_status.msg_data IS NOT NULL) THEN
2632: x_uda_output_obj.output_status.msg_data := x_uda_output_obj.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.process_uda ';
2633: ELSE
2634: x_uda_output_obj.output_status.msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_HELPER.process_uda ';

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

2670: SAVEPOINT inv_ebi_chg_order_uda_save_pnt;
2671: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');
2672: INV_EBI_UTIL.debug_line('STEP 20: ORG CODE: '|| p_organization_code || ' ECO NAME: '|| p_eco_name || ' REVISED ITEM NAME: '|| p_revised_item_name);
2673: l_uda_out := inv_ebi_uda_output_obj(NULL,NULL);
2674: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
2675: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
2676:
2677: Error_Handler.initialize;
2678: IF(p_organization_code IS NOT NULL) THEN

Line 2709: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

2705: SELECT bill_sequence_id,structure_type_id INTO l_bill_sequence_id,l_structure_type_id
2706: FROM bom_bill_of_materials
2707: WHERE assembly_item_id = l_assembly_item_id
2708: AND organization_id = l_organization_id
2709: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2710:
2711: SELECT component_sequence_id INTO l_component_sequence_id
2712: FROM bom_components_b
2713: WHERE bill_sequence_id = l_bill_sequence_id

Line 2735: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

2731: ,p_class_code_name_value_pairs => l_pkcode
2732: ,x_uda_output_obj => x_out
2733: );
2734: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda STATUS: '|| x_out.output_status.return_status);
2735: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2736: RAISE FND_API.g_exc_unexpected_error;
2737: END IF;
2738: END IF;
2739: END LOOP;

Line 2736: RAISE FND_API.g_exc_unexpected_error;

2732: ,x_uda_output_obj => x_out
2733: );
2734: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda STATUS: '|| x_out.output_status.return_status);
2735: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2736: RAISE FND_API.g_exc_unexpected_error;
2737: END IF;
2738: END IF;
2739: END LOOP;
2740: END IF;

Line 2748: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;

2744: SELECT bill_sequence_id,structure_type_id INTO l_bill_sequence_id,l_structure_type_id
2745: FROM bom_bill_of_materials
2746: WHERE assembly_item_id = l_assembly_item_id
2747: AND organization_id = l_organization_id
2748: AND NVL(alternate_bom_designator, 'NONE') = DECODE(p_alternate_bom_code,FND_API.G_MISS_CHAR,'NONE',NULL,'NONE',p_alternate_bom_code) ;
2749:
2750: l_pkdata := ego_col_name_value_pair_array();
2751: l_pkdata.extend();
2752: l_pkdata(1) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);

Line 2767: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

2763: ,p_class_code_name_value_pairs => l_pkcode
2764: ,x_uda_output_obj => x_out
2765: );
2766: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda STATUS: '|| x_out.output_status.return_status);
2767: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2768: RAISE FND_API.g_exc_unexpected_error;
2769: END IF;
2770: END IF;
2771:

Line 2768: RAISE FND_API.g_exc_unexpected_error;

2764: ,x_uda_output_obj => x_out
2765: );
2766: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda STATUS: '|| x_out.output_status.return_status);
2767: IF(x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2768: RAISE FND_API.g_exc_unexpected_error;
2769: END IF;
2770: END IF;
2771:
2772: IF FND_API.To_Boolean(p_commit) THEN

Line 2772: IF FND_API.To_Boolean(p_commit) THEN

2768: RAISE FND_API.g_exc_unexpected_error;
2769: END IF;
2770: END IF;
2771:
2772: IF FND_API.To_Boolean(p_commit) THEN
2773: COMMIT;
2774: END IF;
2775: INV_EBI_UTIL.debug_line('STEP 90: END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');
2776: EXCEPTION

Line 2777: WHEN FND_API.g_exc_unexpected_error THEN

2773: COMMIT;
2774: END IF;
2775: INV_EBI_UTIL.debug_line('STEP 90: END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');
2776: EXCEPTION
2777: WHEN FND_API.g_exc_unexpected_error THEN
2778: ROLLBACK TO inv_ebi_chg_order_uda_save_pnt;
2779: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2780: IF(x_out.output_status.msg_data IS NULL) THEN
2781: fnd_msg_pub.count_and_get(

Line 2779: x_out.output_status.return_status := FND_API.g_ret_sts_error;

2775: INV_EBI_UTIL.debug_line('STEP 90: END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');
2776: EXCEPTION
2777: WHEN FND_API.g_exc_unexpected_error THEN
2778: ROLLBACK TO inv_ebi_chg_order_uda_save_pnt;
2779: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2780: IF(x_out.output_status.msg_data IS NULL) THEN
2781: fnd_msg_pub.count_and_get(
2782: p_encoded => FND_API.g_false
2783: ,p_count => x_out.output_status.msg_count

Line 2782: p_encoded => FND_API.g_false

2778: ROLLBACK TO inv_ebi_chg_order_uda_save_pnt;
2779: x_out.output_status.return_status := FND_API.g_ret_sts_error;
2780: IF(x_out.output_status.msg_data IS NULL) THEN
2781: fnd_msg_pub.count_and_get(
2782: p_encoded => FND_API.g_false
2783: ,p_count => x_out.output_status.msg_count
2784: ,p_data => x_out.output_status.msg_data
2785: );
2786: END IF;

Line 2789: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

2785: );
2786: END IF;
2787: WHEN OTHERS THEN
2788: ROLLBACK TO inv_ebi_chg_order_uda_save_pnt;
2789: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2790: IF (x_out.output_status.msg_data IS NOT NULL) THEN
2791: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda';
2792: ELSE
2793: x_out.output_status.msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda';

Line 3031: l_eco_exist VARCHAR2(1) := FND_API.G_FALSE ;

3027: l_organization_id NUMBER;
3028: l_component_item_id NUMBER;
3029: l_component_cur c_unimplemented_component%ROWTYPE;
3030: l_count NUMBER;
3031: l_eco_exist VARCHAR2(1) := FND_API.G_FALSE ;
3032: l_allow_unimp_bom_update VARCHAR2(1) := FND_API.G_FALSE;
3033: l_bom_comp_exist_without_eco VARCHAR2(1) := FND_API.G_FALSE; --Added of Bug 13587336
3034:
3035: BEGIN

Line 3032: l_allow_unimp_bom_update VARCHAR2(1) := FND_API.G_FALSE;

3028: l_component_item_id NUMBER;
3029: l_component_cur c_unimplemented_component%ROWTYPE;
3030: l_count NUMBER;
3031: l_eco_exist VARCHAR2(1) := FND_API.G_FALSE ;
3032: l_allow_unimp_bom_update VARCHAR2(1) := FND_API.G_FALSE;
3033: l_bom_comp_exist_without_eco VARCHAR2(1) := FND_API.G_FALSE; --Added of Bug 13587336
3034:
3035: BEGIN
3036: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_existing_component_attr');

Line 3033: l_bom_comp_exist_without_eco VARCHAR2(1) := FND_API.G_FALSE; --Added of Bug 13587336

3029: l_component_cur c_unimplemented_component%ROWTYPE;
3030: l_count NUMBER;
3031: l_eco_exist VARCHAR2(1) := FND_API.G_FALSE ;
3032: l_allow_unimp_bom_update VARCHAR2(1) := FND_API.G_FALSE;
3033: l_bom_comp_exist_without_eco VARCHAR2(1) := FND_API.G_FALSE; --Added of Bug 13587336
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

Line 3053: IF (l_allow_unimp_bom_update IS NULL OR l_allow_unimp_bom_update = fnd_api.g_miss_char) THEN

3049: INV_EBI_UTIL.debug_line('STEP 30: p_allow_unimp_bom_updates ' || p_allow_unimp_bom_updates);
3050:
3051: l_allow_unimp_bom_update := p_allow_unimp_bom_updates;
3052:
3053: IF (l_allow_unimp_bom_update IS NULL OR l_allow_unimp_bom_update = fnd_api.g_miss_char) THEN
3054:
3055: l_allow_unimp_bom_update := INV_EBI_FLAGS.get_allow_unimp_bom_updates;
3056:
3057: END IF;

Line 3080: IF( l_allow_unimp_bom_update = FND_API.G_FALSE) THEN

3076: --Start of Bug 10423301
3077: --If Unimplemented BOM updates are not allowed then open cursor c_implemented_component
3078: --else open cursor c_unimplemented_component
3079:
3080: IF( l_allow_unimp_bom_update = FND_API.G_FALSE) THEN
3081: --To Retrive old effectivity date if BOM Components are implemented
3082: INV_EBI_UTIL.debug_line('STEP 70: Opening Cursor for implemented BOM Components');
3083: IF c_implemented_component%ISOPEN THEN
3084: CLOSE c_implemented_component;

Line 3096: l_eco_exist := FND_API.G_TRUE;

3092: x_old_effectivity_date := l_component_cur.effectivity_date;
3093: x_old_op_sequence_num := l_component_cur.operation_seq_num;
3094: x_old_fm_end_item_unit := l_component_cur.from_end_item_unit_number;
3095:
3096: l_eco_exist := FND_API.G_TRUE;
3097: END IF;
3098: CLOSE c_implemented_component;
3099: ELSE
3100: INV_EBI_UTIL.debug_line('STEP 90: Opening Cursor for Unimplemented BOM Components');

Line 3115: l_eco_exist := FND_API.G_TRUE;

3111: x_old_effectivity_date := l_component_cur.effectivity_date;
3112: x_old_op_sequence_num := l_component_cur.operation_seq_num;
3113: x_old_fm_end_item_unit := l_component_cur.from_end_item_unit_number;
3114:
3115: l_eco_exist := FND_API.G_TRUE;
3116: END IF;
3117: CLOSE c_unimplemented_component;
3118: END IF;-- End of Bug 10423301
3119:

Line 3124: IF(l_eco_exist <> FND_API.G_TRUE AND p_bom_update_without_eco = FND_API.G_TRUE) THEN

3120: /*Start of Bug :8340804 If Item has BOM and no Change Order then retrieve old values from
3121: bom_inventory_components table */
3122:
3123:
3124: IF(l_eco_exist <> FND_API.G_TRUE AND p_bom_update_without_eco = FND_API.G_TRUE) THEN
3125:
3126: /*SELECT COUNT(1) INTO l_count
3127: FROM eng_revised_items
3128: WHERE revised_item_id = l_assembly_item_id

Line 3155: l_bom_comp_exist_without_eco := FND_API.G_TRUE;

3151:
3152: FOR l_bom_comps IN c_bom_components(l_component_item_id,l_bill_sequence_id)
3153: LOOP
3154:
3155: l_bom_comp_exist_without_eco := FND_API.G_TRUE;
3156: x_old_effectivity_date := l_bom_comps.effectivity_date;
3157: x_old_op_sequence_num := l_bom_comps.operation_seq_num;
3158: x_old_fm_end_item_unit := l_bom_comps.from_end_item_unit_number;
3159: EXIT;

Line 3165: IF(l_bom_comp_exist_without_eco = FND_API.G_FALSE) THEN

3161: END LOOP;
3162: END IF;
3163:
3164: --Start of Bug 13582896
3165: IF(l_bom_comp_exist_without_eco = FND_API.G_FALSE) THEN
3166: SELECT COUNT(1) INTO l_count
3167: FROM bom_inventory_components bic
3168: WHERE bic.bill_sequence_id = l_bill_sequence_id
3169: AND bic.component_item_id = l_component_item_id

Line 3324: x_return_status := FND_API.G_RET_STS_SUCCESS;

3320: SAVEPOINT inv_ebi_assign_item_save_pnt;
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: );

Line 3329: IF (l_is_item_exists = FND_API.g_false) THEN

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
3330:
3331: l_master_org := INV_EBI_UTIL.get_master_organization(
3332: p_organization_id => p_organization_id
3333: );

Line 3343: IF(l_is_item_exists = FND_API.g_true ) THEN

3339: /* If Item does not exist in context org(child org) and it exists in master org
3340: and if it approved in master org and ASSIGN_ITEM_TO_CHILD_ORG is set
3341: to true then item should be assigned to context org */
3342:
3343: IF(l_is_item_exists = FND_API.g_true ) THEN
3344: IF(get_assign_item = FND_API.g_true ) THEN
3345: IF(INV_EBI_UTIL.is_pim_installed) THEN
3346: SELECT item_catalog_group_id, approval_status
3347: INTO l_item_catalog_group_id, l_approval_status

Line 3344: IF(get_assign_item = FND_API.g_true ) THEN

3340: and if it approved in master org and ASSIGN_ITEM_TO_CHILD_ORG is set
3341: to true then item should be assigned to context org */
3342:
3343: IF(l_is_item_exists = FND_API.g_true ) THEN
3344: IF(get_assign_item = FND_API.g_true ) THEN
3345: IF(INV_EBI_UTIL.is_pim_installed) THEN
3346: SELECT item_catalog_group_id, approval_status
3347: INTO l_item_catalog_group_id, l_approval_status
3348: FROM mtl_system_items_kfv

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 3359: RAISE FND_API.g_exc_unexpected_error;

3355: FND_MESSAGE.set_token('ITEM_NUMBER',p_item_name);
3356: FND_MESSAGE.set_token('ORGANIZATION_ID',l_master_org);
3357: FND_MESSAGE.set_token('CHILD_ORGANIZATION_ID',p_organization_id);
3358: FND_MSG_PUB.add;
3359: RAISE FND_API.g_exc_unexpected_error;
3360: END IF;
3361: END IF;
3362: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.assign_item_to_org');
3363: EGO_ITEM_PUB.assign_item_to_org(

Line 3365: ,p_commit => FND_API.g_false

3361: END IF;
3362: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING EGO_ITEM_PUB.assign_item_to_org');
3363: EGO_ITEM_PUB.assign_item_to_org(
3364: p_api_version => 1.0
3365: ,p_commit => FND_API.g_false
3366: ,p_Item_Number => p_item_name
3367: ,p_Organization_Id => p_organization_id
3368: ,x_return_status => x_return_status
3369: ,x_msg_count => x_msg_count

Line 3372: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

3368: ,x_return_status => x_return_status
3369: ,x_msg_count => x_msg_count
3370: );
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

Line 3373: RAISE FND_API.g_exc_unexpected_error;

3369: ,x_msg_count => x_msg_count
3370: );
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

Line 3417: ,p_init_msg_list => FND_API.g_false

3413: l_effectivity_date := l_effectivity_date + 1/86400; -- To keep efectivity date of next rev 1 sec higher than earlier rev
3414: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING EGO_ITEM_PUB.Process_Item_Revision');
3415: EGO_ITEM_PUB.Process_Item_Revision(
3416: p_api_version => 1.0
3417: ,p_init_msg_list => FND_API.g_false
3418: ,p_commit => FND_API.g_false
3419: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create
3420: ,p_inventory_item_id => NULL
3421: ,p_item_number => p_item_name

Line 3418: ,p_commit => FND_API.g_false

3414: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING EGO_ITEM_PUB.Process_Item_Revision');
3415: EGO_ITEM_PUB.Process_Item_Revision(
3416: p_api_version => 1.0
3417: ,p_init_msg_list => FND_API.g_false
3418: ,p_commit => FND_API.g_false
3419: ,p_transaction_type => INV_EBI_ITEM_PUB.g_otype_create
3420: ,p_inventory_item_id => NULL
3421: ,p_item_number => p_item_name
3422: ,p_organization_id => p_organization_id

Line 3452: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

3448: ,x_msg_count => x_msg_count
3449: ,x_msg_data => x_msg_data
3450: ) ;
3451: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING EGO_ITEM_PUB.Process_Item_Revision STATUS: '|| x_return_status);
3452: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3453: x_msg_data := x_msg_data || ' -> Item Number:' || p_item_name || ' -> Org Id: ' || p_organization_id;
3454: RAISE FND_API.g_exc_unexpected_error;
3455: END IF;
3456: END IF;

Line 3454: RAISE FND_API.g_exc_unexpected_error;

3450: ) ;
3451: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING EGO_ITEM_PUB.Process_Item_Revision STATUS: '|| x_return_status);
3452: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3453: x_msg_data := x_msg_data || ' -> Item Number:' || p_item_name || ' -> Org Id: ' || p_organization_id;
3454: RAISE FND_API.g_exc_unexpected_error;
3455: END IF;
3456: END IF;
3457: END IF;
3458: ELSE

Line 3462: RAISE FND_API.g_exc_error;

3458: ELSE
3459: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
3460: FND_MESSAGE.set_token('ITEM', p_item_name);
3461: FND_MSG_PUB.add;
3462: RAISE FND_API.g_exc_error;
3463: END IF;
3464: END IF;
3465: INV_EBI_UTIL.debug_line('STEP 80: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ');
3466: EXCEPTION

Line 3467: WHEN FND_API.g_exc_unexpected_error THEN

3463: END IF;
3464: END IF;
3465: INV_EBI_UTIL.debug_line('STEP 80: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ');
3466: EXCEPTION
3467: WHEN FND_API.g_exc_unexpected_error THEN
3468: ROLLBACK TO inv_ebi_assign_item_save_pnt;
3469: x_return_status := FND_API.g_ret_sts_unexp_error;
3470:
3471: IF c_master_item_rev%ISOPEN THEN

Line 3469: x_return_status := FND_API.g_ret_sts_unexp_error;

3465: INV_EBI_UTIL.debug_line('STEP 80: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ');
3466: EXCEPTION
3467: WHEN FND_API.g_exc_unexpected_error THEN
3468: ROLLBACK TO inv_ebi_assign_item_save_pnt;
3469: x_return_status := FND_API.g_ret_sts_unexp_error;
3470:
3471: IF c_master_item_rev%ISOPEN THEN
3472: CLOSE c_master_item_rev;
3473: END IF;

Line 3476: p_encoded => FND_API.g_false

3472: CLOSE c_master_item_rev;
3473: END IF;
3474: IF(x_msg_data IS NULL) THEN
3475: fnd_msg_pub.count_and_get(
3476: p_encoded => FND_API.g_false
3477: ,p_count => x_msg_count
3478: ,p_data => x_msg_data
3479: );
3480: END IF;

Line 3481: WHEN FND_API.g_exc_error THEN

3477: ,p_count => x_msg_count
3478: ,p_data => x_msg_data
3479: );
3480: END IF;
3481: WHEN FND_API.g_exc_error THEN
3482: ROLLBACK TO inv_ebi_assign_item_save_pnt;
3483: x_return_status := FND_API.g_ret_sts_error;
3484:
3485: IF c_master_item_rev%ISOPEN THEN

Line 3483: x_return_status := FND_API.g_ret_sts_error;

3479: );
3480: END IF;
3481: WHEN FND_API.g_exc_error THEN
3482: ROLLBACK TO inv_ebi_assign_item_save_pnt;
3483: x_return_status := FND_API.g_ret_sts_error;
3484:
3485: IF c_master_item_rev%ISOPEN THEN
3486: CLOSE c_master_item_rev;
3487: END IF;

Line 3490: p_encoded => FND_API.g_false

3486: CLOSE c_master_item_rev;
3487: END IF;
3488: IF(x_msg_data IS NULL) THEN
3489: FND_MSG_PUB.count_and_get(
3490: p_encoded => FND_API.g_false
3491: ,p_count => x_msg_count
3492: ,p_data => x_msg_data
3493: );
3494: END IF;

Line 3497: x_return_status := FND_API.g_ret_sts_unexp_error;

3493: );
3494: END IF;
3495: WHEN OTHERS THEN
3496: ROLLBACK TO inv_ebi_assign_item_save_pnt;
3497: x_return_status := FND_API.g_ret_sts_unexp_error;
3498:
3499: IF c_master_item_rev%ISOPEN THEN
3500: CLOSE c_master_item_rev;
3501: END IF;

Line 3729: x_return_status := FND_API.G_RET_STS_SUCCESS;

3725: BEGIN
3726: INV_EBI_UTIL.DEBUG_LINE('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');
3727: INV_EBI_UTIL.DEBUG_LINE('STEP 20: ASSY ITEM ID: '|| p_assembly_item_id || ' ORG ID: '|| p_organization_id || ' SRC ORG ID: '|| p_src_organization_id);
3728: SAVEPOINT inv_ebi_comm_comp_save_pnt;
3729: x_return_status := FND_API.G_RET_STS_SUCCESS;
3730:
3731: SELECT
3732: bom_item_type,
3733: base_item_id,

Line 3770: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

3766: x_msg_data => x_msg_data ,
3767: x_msg_count => x_msg_count
3768: );
3769: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_return_status);
3770: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3771: RAISE FND_API.g_exc_unexpected_error;
3772: END IF;
3773: END LOOP;
3774: CLOSE c_common_comps;

Line 3771: RAISE FND_API.g_exc_unexpected_error;

3767: x_msg_count => x_msg_count
3768: );
3769: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_return_status);
3770: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3771: RAISE FND_API.g_exc_unexpected_error;
3772: END IF;
3773: END LOOP;
3774: CLOSE c_common_comps;
3775:

Line 3798: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

3794: x_msg_count => x_msg_count
3795: );
3796: INV_EBI_UTIL.DEBUG_LINE('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items for substitute components STATUS :' || x_return_status);
3797:
3798: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3799: RAISE FND_API.g_exc_unexpected_error;
3800: END IF;
3801: END LOOP;
3802: CLOSE c_common_sub_comps ;

Line 3799: RAISE FND_API.g_exc_unexpected_error;

3795: );
3796: INV_EBI_UTIL.DEBUG_LINE('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items for substitute components STATUS :' || x_return_status);
3797:
3798: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3799: RAISE FND_API.g_exc_unexpected_error;
3800: END IF;
3801: END LOOP;
3802: CLOSE c_common_sub_comps ;
3803: INV_EBI_UTIL.debug_line('STEP 90: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');

Line 3805: WHEN FND_API.g_exc_unexpected_error THEN

3801: END LOOP;
3802: CLOSE c_common_sub_comps ;
3803: INV_EBI_UTIL.debug_line('STEP 90: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');
3804: EXCEPTION
3805: WHEN FND_API.g_exc_unexpected_error THEN
3806: ROLLBACK TO inv_ebi_comm_comp_save_pnt;
3807: IF (c_common_comps%ISOPEN) THEN
3808: CLOSE c_common_comps;
3809: END IF;

Line 3813: x_return_status := FND_API.g_ret_sts_error;

3809: END IF;
3810: IF (c_common_sub_comps%ISOPEN) THEN
3811: CLOSE c_common_sub_comps;
3812: END IF;
3813: x_return_status := FND_API.g_ret_sts_error;
3814: IF(x_msg_data IS NULL) THEN
3815: fnd_msg_pub.count_and_get(
3816: p_encoded => FND_API.g_false
3817: ,p_count => x_msg_count

Line 3816: p_encoded => FND_API.g_false

3812: END IF;
3813: x_return_status := FND_API.g_ret_sts_error;
3814: IF(x_msg_data IS NULL) THEN
3815: fnd_msg_pub.count_and_get(
3816: p_encoded => FND_API.g_false
3817: ,p_count => x_msg_count
3818: ,p_data => x_msg_data
3819: );
3820: END IF;

Line 3829: x_return_status := FND_API.g_ret_sts_unexp_error;

3825: END IF;
3826: IF (c_common_sub_comps%ISOPEN) THEN
3827: CLOSE c_common_sub_comps;
3828: END IF;
3829: x_return_status := FND_API.g_ret_sts_unexp_error;
3830: IF (x_msg_data IS NOT NULL) THEN
3831: x_msg_data := x_msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_common_comps ';
3832: ELSE
3833: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_common_comps ';

Line 3867: x_return_status := FND_API.G_RET_STS_SUCCESS;

3863:
3864:
3865: BEGIN
3866: SAVEPOINT inv_ebi_comm_bom_save_pnt;
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(

Line 3889: RAISE FND_API.g_exc_error;

3885: IF(l_src_bill_sequence_id IS NULL ) THEN
3886: FND_MESSAGE.set_name('INV','INV_EBI_COMMON_BILL_NOT_FOUND');
3887: FND_MESSAGE.set_token('ASSY_ITEM', p_common_assembly_item_name);
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

Line 3912: IF (x_return_status <> FND_API.g_ret_sts_success) THEN

3908: x_msg_data => x_msg_data,
3909: x_msg_count => x_msg_count
3910: );
3911: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_comps STATUS: '|| x_return_status);
3912: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3913: RAISE FND_API.g_exc_unexpected_error;
3914: END IF;
3915: INV_EBI_UTIL.debug_line('STEP 70: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ');
3916: EXCEPTION

Line 3913: RAISE FND_API.g_exc_unexpected_error;

3909: x_msg_count => x_msg_count
3910: );
3911: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_comps STATUS: '|| x_return_status);
3912: IF (x_return_status <> FND_API.g_ret_sts_success) THEN
3913: RAISE FND_API.g_exc_unexpected_error;
3914: END IF;
3915: INV_EBI_UTIL.debug_line('STEP 70: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ');
3916: EXCEPTION
3917: WHEN FND_API.g_exc_unexpected_error THEN

Line 3917: WHEN FND_API.g_exc_unexpected_error THEN

3913: RAISE FND_API.g_exc_unexpected_error;
3914: END IF;
3915: INV_EBI_UTIL.debug_line('STEP 70: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ');
3916: EXCEPTION
3917: WHEN FND_API.g_exc_unexpected_error THEN
3918: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3919: x_return_status := FND_API.g_ret_sts_unexp_error;
3920: IF(x_msg_data IS NULL) THEN
3921: fnd_msg_pub.count_and_get(

Line 3919: x_return_status := FND_API.g_ret_sts_unexp_error;

3915: INV_EBI_UTIL.debug_line('STEP 70: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ');
3916: EXCEPTION
3917: WHEN FND_API.g_exc_unexpected_error THEN
3918: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3919: x_return_status := FND_API.g_ret_sts_unexp_error;
3920: IF(x_msg_data IS NULL) THEN
3921: fnd_msg_pub.count_and_get(
3922: p_encoded => FND_API.g_false
3923: ,p_count => x_msg_count

Line 3922: p_encoded => FND_API.g_false

3918: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3919: x_return_status := FND_API.g_ret_sts_unexp_error;
3920: IF(x_msg_data IS NULL) THEN
3921: fnd_msg_pub.count_and_get(
3922: p_encoded => FND_API.g_false
3923: ,p_count => x_msg_count
3924: ,p_data => x_msg_data
3925: );
3926: END IF;

Line 3927: WHEN FND_API.g_exc_error THEN

3923: ,p_count => x_msg_count
3924: ,p_data => x_msg_data
3925: );
3926: END IF;
3927: WHEN FND_API.g_exc_error THEN
3928: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3929: x_return_status := FND_API.g_ret_sts_error;
3930: IF(x_msg_data IS NULL) THEN
3931: FND_MSG_PUB.count_and_get(

Line 3929: x_return_status := FND_API.g_ret_sts_error;

3925: );
3926: END IF;
3927: WHEN FND_API.g_exc_error THEN
3928: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3929: x_return_status := FND_API.g_ret_sts_error;
3930: IF(x_msg_data IS NULL) THEN
3931: FND_MSG_PUB.count_and_get(
3932: p_encoded => FND_API.g_false
3933: ,p_count => x_msg_count

Line 3932: p_encoded => FND_API.g_false

3928: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3929: x_return_status := FND_API.g_ret_sts_error;
3930: IF(x_msg_data IS NULL) THEN
3931: FND_MSG_PUB.count_and_get(
3932: p_encoded => FND_API.g_false
3933: ,p_count => x_msg_count
3934: ,p_data => x_msg_data
3935: );
3936: END IF;

Line 3939: x_return_status := FND_API.g_ret_sts_unexp_error;

3935: );
3936: END IF;
3937: WHEN OTHERS THEN
3938: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3939: x_return_status := FND_API.g_ret_sts_unexp_error;
3940: IF (x_msg_data IS NOT NULL) THEN
3941: x_msg_data := x_msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ';
3942: ELSE
3943: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ';

Line 3985: x_return_status := FND_API.G_RET_STS_SUCCESS;

3981: BEGIN
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:

Line 4017: x_return_status := FND_API.g_ret_sts_unexp_error;

4013: END LOOP;
4014: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs STATUS: '|| x_return_status);
4015: EXCEPTION
4016: WHEN OTHERS THEN
4017: x_return_status := FND_API.g_ret_sts_unexp_error;
4018: IF (x_msg_data IS NOT NULL) THEN
4019: x_msg_data := x_msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs ';
4020: ELSE
4021: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs ';

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

4043: SAVEPOINT inv_ebi_common_orgs_save_pnt;
4044: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs');
4045: INV_EBI_UTIL.debug_line('STEP 20: ASSY ITEM NAME: '|| p_assembly_item_name || ' ORG CODE: '|| p_organization_code);
4046:
4047: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
4048: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
4049: l_common_orgs := inv_ebi_org_tbl();
4050:
4051: --Get the list of orgs to which particular bom is commoned

Line 4063: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4059: x_msg_data => x_out.output_status.msg_data ,
4060: x_msg_count => x_out.output_status.msg_count
4061: ) ;
4062: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs STATUS: '|| x_out.output_status.return_status);
4063: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4064: RAISE FND_API.g_exc_unexpected_error;
4065: END IF;
4066:
4067: FOR i IN 1..l_common_orgs.COUNT LOOP

Line 4064: RAISE FND_API.g_exc_unexpected_error;

4060: x_msg_count => x_out.output_status.msg_count
4061: ) ;
4062: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs STATUS: '|| x_out.output_status.return_status);
4063: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4064: RAISE FND_API.g_exc_unexpected_error;
4065: END IF;
4066:
4067: FOR i IN 1..l_common_orgs.COUNT LOOP
4068: IF(p_component_item_tbl IS NOT NULL AND p_component_item_tbl.COUNT > 0) THEN

Line 4084: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4080: x_msg_data => x_out.output_status.msg_data ,
4081: x_msg_count => x_out.output_status.msg_count
4082: );
4083: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_out.output_status.return_status);
4084: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4085: RAISE FND_API.g_exc_unexpected_error;
4086: END IF;
4087: END IF;
4088:

Line 4085: RAISE FND_API.g_exc_unexpected_error;

4081: x_msg_count => x_out.output_status.msg_count
4082: );
4083: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_out.output_status.return_status);
4084: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4085: RAISE FND_API.g_exc_unexpected_error;
4086: END IF;
4087: END IF;
4088:
4089: IF( p_component_item_tbl(j).substitute_component_tbl IS NOT NULL AND

Line 4104: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4100: x_msg_data => x_out.output_status.msg_data ,
4101: x_msg_count => x_out.output_status.msg_count
4102: );
4103: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_out.output_status.return_status);
4104: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4105: RAISE FND_API.g_exc_unexpected_error;
4106: END IF;
4107: END IF;
4108: END LOOP;

Line 4105: RAISE FND_API.g_exc_unexpected_error;

4101: x_msg_count => x_out.output_status.msg_count
4102: );
4103: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_out.output_status.return_status);
4104: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4105: RAISE FND_API.g_exc_unexpected_error;
4106: END IF;
4107: END IF;
4108: END LOOP;
4109: END IF;

Line 4115: WHEN FND_API.g_exc_unexpected_error THEN

4111: END IF;
4112: END LOOP;
4113: INV_EBI_UTIL.debug_line('STEP 110: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs ');
4114: EXCEPTION
4115: WHEN FND_API.g_exc_unexpected_error THEN
4116: ROLLBACK TO inv_ebi_common_orgs_save_pnt;
4117: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4118: IF(x_out.output_status.msg_data IS NULL) THEN
4119: fnd_msg_pub.count_and_get(

Line 4117: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

4113: INV_EBI_UTIL.debug_line('STEP 110: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs ');
4114: EXCEPTION
4115: WHEN FND_API.g_exc_unexpected_error THEN
4116: ROLLBACK TO inv_ebi_common_orgs_save_pnt;
4117: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4118: IF(x_out.output_status.msg_data IS NULL) THEN
4119: fnd_msg_pub.count_and_get(
4120: p_encoded => FND_API.g_false
4121: ,p_count => x_out.output_status.msg_count

Line 4120: p_encoded => FND_API.g_false

4116: ROLLBACK TO inv_ebi_common_orgs_save_pnt;
4117: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4118: IF(x_out.output_status.msg_data IS NULL) THEN
4119: fnd_msg_pub.count_and_get(
4120: p_encoded => FND_API.g_false
4121: ,p_count => x_out.output_status.msg_count
4122: ,p_data => x_out.output_status.msg_data
4123: );
4124: END IF;

Line 4127: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

4123: );
4124: END IF;
4125: WHEN OTHERS THEN
4126: ROLLBACK TO inv_ebi_common_orgs_save_pnt;
4127: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4128: IF (x_out.output_status.msg_data IS NOT NULL) THEN
4129: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs ';
4130: ELSE
4131: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs ';

Line 4143: p_commit IN VARCHAR2 := FND_API.G_FALSE

4139: -- This API is used to create the change order.
4140: --
4141: ************************************************************************************/
4142: PROCEDURE process_eco(
4143: p_commit IN VARCHAR2 := FND_API.G_FALSE
4144: ,p_change_order IN inv_ebi_change_order_obj
4145: ,p_revision_type_tbl IN inv_ebi_eco_revision_tbl
4146: ,p_revised_item_type_tbl IN inv_ebi_revised_item_tbl
4147: ,p_name_val_list IN inv_ebi_name_value_list

Line 4185: l_plm_or_erp VARCHAR2(1):=FND_API.G_TRUE;

4181: l_status_type NUMBER;
4182: l_priority_code VARCHAR2(10);
4183: l_is_wf_Set BOOLEAN;
4184: l_approval_status NUMBER :=0;
4185: l_plm_or_erp VARCHAR2(1):=FND_API.G_TRUE;
4186: l_old_effectivity_date DATE;
4187: l_old_op_sequence_num NUMBER;
4188: l_old_fm_end_item_unit NUMBER;
4189: l_acd_update CONSTANT NUMBER :=2;

Line 4195: l_bom_update_without_eco VARCHAR2(1) := FND_API.G_TRUE;

4191: l_revised_item_id NUMBER;
4192: l_effectivity_date DATE;
4193: l_change_type_code VARCHAR2(80);
4194: l_status_name VARCHAR2(30);
4195: l_bom_update_without_eco VARCHAR2(1) := FND_API.G_TRUE;
4196: l_allow_unimp_bom_update VARCHAR2(1) := NULL;
4197:
4198: BEGIN
4199: SAVEPOINT inv_ebi_proc_eco_save_pnt;

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

4199: SAVEPOINT inv_ebi_proc_eco_save_pnt;
4200: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco');
4201: INV_EBI_UTIL.debug_line('STEP 20: ECO NUMBER: '|| p_change_order.eco_name || ' ORG CODE: '|| p_change_order.organization_code);
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);

Line 4221: RAISE FND_API.g_exc_unexpected_error;

4217: IF (l_organization_id IS NULL) THEN
4218: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
4219: FND_MESSAGE.set_token('COL_VALUE', p_change_order.organization_code);
4220: FND_MSG_PUB.add;
4221: RAISE FND_API.g_exc_unexpected_error;
4222: END IF;
4223:
4224: -- Code to incorporate the DVM changes
4225: -- ECO_TYPECODE

Line 4229: p_change_order.change_type_id <> fnd_api.g_miss_num) THEN

4225: -- ECO_TYPECODE
4226: l_change_type_code := p_change_order.change_type_code;
4227:
4228: IF( p_change_order.change_type_id IS NOT NULL AND
4229: p_change_order.change_type_id <> fnd_api.g_miss_num) THEN
4230: l_change_type_code := get_change_type_code(p_change_type_id => p_change_order.change_type_id);
4231: END IF;
4232:
4233: -- ECO_STATUS_CODE

Line 4238: p_change_order.status_code <> fnd_api.g_miss_num) THEN

4234:
4235: l_status_name := p_change_order.status_name;
4236:
4237: IF( p_change_order.status_code IS NOT NULL AND
4238: p_change_order.status_code <> fnd_api.g_miss_num) THEN
4239: l_status_name := get_eco_status_name(p_status_code => p_change_order.status_code);
4240: END IF;
4241:
4242: IF p_name_val_list.name_value_table IS NOT NULL THEN

Line 4338: IF (p_change_order.plm_or_erp_change IS NOT NULL AND p_change_order.plm_or_erp_change <> fnd_api.g_miss_char ) THEN

4334: l_eco_rec.transaction_id := p_change_order.transaction_id;
4335: l_eco_rec.transaction_type := p_change_order.transaction_type ;
4336: l_eco_rec.internal_use_only := p_change_order.internal_use_only ;
4337: l_eco_rec.return_status := p_change_order.return_status ;
4338: IF (p_change_order.plm_or_erp_change IS NOT NULL AND p_change_order.plm_or_erp_change <> fnd_api.g_miss_char ) THEN
4339: l_eco_rec.plm_or_erp_change := p_change_order.plm_or_erp_change ;
4340: ELSE
4341: IF (l_plm_or_erp = FND_API.G_FALSE) THEN
4342: l_eco_rec.plm_or_erp_change := 'PLM';

Line 4341: IF (l_plm_or_erp = FND_API.G_FALSE) THEN

4337: l_eco_rec.return_status := p_change_order.return_status ;
4338: IF (p_change_order.plm_or_erp_change IS NOT NULL AND p_change_order.plm_or_erp_change <> fnd_api.g_miss_char ) THEN
4339: l_eco_rec.plm_or_erp_change := p_change_order.plm_or_erp_change ;
4340: ELSE
4341: IF (l_plm_or_erp = FND_API.G_FALSE) THEN
4342: l_eco_rec.plm_or_erp_change := 'PLM';
4343: ELSE
4344: l_eco_rec.plm_or_erp_change := 'ERP';
4345: END IF;

Line 4418: ) = FND_API.g_true ) THEN

4414: IF (is_new_revision_exists(
4415: p_item_number => l_revised_item_tbl(l_revised_item_tbl_count).revised_item_name,
4416: p_revision => p_revised_item_type_tbl(i).new_revised_item_revision,
4417: p_org_code => l_revised_item_tbl(l_revised_item_tbl_count).organization_code
4418: ) = FND_API.g_true ) THEN
4419: l_revised_item_tbl(l_revised_item_tbl_count).new_revised_item_revision := NULL;
4420: l_revised_item_tbl(l_revised_item_tbl_count).from_item_revision := p_revised_item_type_tbl(i).from_item_revision ;
4421: ELSE
4422: l_revised_item_tbl(l_revised_item_tbl_count).new_revised_item_revision := p_revised_item_type_tbl(i).new_revised_item_revision;

Line 4434: OR p_revised_item_type_tbl(i).start_effective_date = fnd_api.g_miss_date) THEN

4430: l_revised_item_tbl(l_revised_item_tbl_count).new_revised_item_rev_desc := p_revised_item_type_tbl(i).new_revised_item_rev_desc;
4431: l_revised_item_tbl(l_revised_item_tbl_count).updated_revised_item_revision := p_revised_item_type_tbl(i).upd_revised_item_revision;
4432: IF (p_revised_item_type_tbl(i).start_effective_date < l_effectivity_date
4433: OR p_revised_item_type_tbl(i).start_effective_date IS NULL
4434: OR p_revised_item_type_tbl(i).start_effective_date = fnd_api.g_miss_date) THEN
4435: l_revised_item_tbl(l_revised_item_tbl_count).start_effective_date := l_effectivity_date + 1/86400; -- BUG 7197943 To keep efectivity date of next rev 1 sec higher than earlier rev
4436: ELSE
4437: l_revised_item_tbl(l_revised_item_tbl_count).start_effective_date := p_revised_item_type_tbl(i).start_effective_date;
4438: END IF;

Line 4441: OR p_revised_item_type_tbl(i).new_effective_date = fnd_api.g_miss_date) THEN

4437: l_revised_item_tbl(l_revised_item_tbl_count).start_effective_date := p_revised_item_type_tbl(i).start_effective_date;
4438: END IF;
4439: IF (p_revised_item_type_tbl(i).new_effective_date < l_effectivity_date
4440: OR p_revised_item_type_tbl(i).new_effective_date IS NULL
4441: OR p_revised_item_type_tbl(i).new_effective_date = fnd_api.g_miss_date) THEN
4442: l_revised_item_tbl(l_revised_item_tbl_count).new_effective_date := l_effectivity_date + 1/86400; --BUG 7197943 To keep efectivity date of next rev 1 sec higher than earlier rev
4443: ELSE
4444: l_revised_item_tbl(l_revised_item_tbl_count).new_effective_date := p_revised_item_type_tbl(i).new_effective_date ;
4445: END IF;

Line 4538: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4534: p_component_item_tbl => p_revised_item_type_tbl(i).component_item_tbl,
4535: x_out => x_out
4536: );
4537: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs STATUS: '|| x_out.output_status.return_status);
4538: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4539: RAISE FND_API.g_exc_unexpected_error;
4540: END IF;
4541:
4542: FOR j IN p_revised_item_type_tbl(i).component_item_tbl.FIRST..p_revised_item_type_tbl(i).component_item_tbl.LAST

Line 4539: RAISE FND_API.g_exc_unexpected_error;

4535: x_out => x_out
4536: );
4537: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs STATUS: '|| x_out.output_status.return_status);
4538: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4539: RAISE FND_API.g_exc_unexpected_error;
4540: END IF;
4541:
4542: FOR j IN p_revised_item_type_tbl(i).component_item_tbl.FIRST..p_revised_item_type_tbl(i).component_item_tbl.LAST
4543: LOOP

Line 4555: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4551: x_msg_data => x_out.output_status.msg_data ,
4552: x_msg_count => x_out.output_status.msg_count
4553: );
4554: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_out.output_status.return_status);
4555: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4556: RAISE FND_API.g_exc_unexpected_error;
4557: END IF;
4558:
4559: l_rev_component_tbl(l_rev_component_tbl_count).eco_name := p_change_order.eco_name;

Line 4556: RAISE FND_API.g_exc_unexpected_error;

4552: x_msg_count => x_out.output_status.msg_count
4553: );
4554: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_out.output_status.return_status);
4555: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4556: RAISE FND_API.g_exc_unexpected_error;
4557: END IF;
4558:
4559: l_rev_component_tbl(l_rev_component_tbl_count).eco_name := p_change_order.eco_name;
4560: l_rev_component_tbl(l_rev_component_tbl_count).organization_code := p_change_order.organization_code ;

Line 4565: OR p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date = fnd_api.g_miss_date) THEN

4561: l_rev_component_tbl(l_rev_component_tbl_count).revised_item_name := p_revised_item_type_tbl(i).revised_item_name;
4562: l_rev_component_tbl(l_rev_component_tbl_count).new_revised_item_revision := l_revised_item_tbl(l_revised_item_tbl_count).new_revised_item_revision;
4563: IF (p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date < l_effectivity_date
4564: OR p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date IS NULL
4565: OR p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date = fnd_api.g_miss_date) THEN
4566: l_rev_component_tbl(l_rev_component_tbl_count).start_effective_date := l_effectivity_date + 1/86400 ; --BUG 7197943 To keep efectivity date of next rev 1 sec higher than earlier rev
4567: ELSE
4568: l_rev_component_tbl(l_rev_component_tbl_count).start_effective_date := p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date;
4569: END IF;

Line 4572: OR p_revised_item_type_tbl(i).component_item_tbl(j).new_effectivity_date = fnd_api.g_miss_date) THEN

4568: l_rev_component_tbl(l_rev_component_tbl_count).start_effective_date := p_revised_item_type_tbl(i).component_item_tbl(j).start_effective_date;
4569: END IF;
4570: IF (p_revised_item_type_tbl(i).component_item_tbl(j).new_effectivity_date < l_effectivity_date
4571: OR p_revised_item_type_tbl(i).component_item_tbl(j).new_effectivity_date IS NULL
4572: OR p_revised_item_type_tbl(i).component_item_tbl(j).new_effectivity_date = fnd_api.g_miss_date) THEN
4573: l_rev_component_tbl(l_rev_component_tbl_count).new_effectivity_date := l_effectivity_date + 1/86400; --BUG 7197943 To keep efectivity date of next rev 1 sec higher than earlier rev
4574: ELSE
4575: l_rev_component_tbl(l_rev_component_tbl_count).new_effectivity_date := p_revised_item_type_tbl(i).component_item_tbl(j).new_effectivity_date ;
4576: END IF;

Line 4683: OR p_revised_item_type_tbl(i).component_item_tbl(j).reference_designator_tbl(k).start_effective_date =fnd_api.g_miss_date) THEN

4679: l_ref_designator_tbl(l_ref_designator_tbl_count).component_item_name := p_revised_item_type_tbl(i).component_item_tbl(j).component_item_name ;
4680: l_ref_designator_tbl(l_ref_designator_tbl_count).alternate_bom_code := p_revised_item_type_tbl(i).alternate_bom_code;
4681: IF (p_revised_item_type_tbl(i).component_item_tbl(j).reference_designator_tbl(k).start_effective_date < l_effectivity_date
4682: OR p_revised_item_type_tbl(i).component_item_tbl(j).reference_designator_tbl(k).start_effective_date IS NULL
4683: OR p_revised_item_type_tbl(i).component_item_tbl(j).reference_designator_tbl(k).start_effective_date =fnd_api.g_miss_date) THEN
4684: l_ref_designator_tbl(l_ref_designator_tbl_count).start_effective_date := l_effectivity_date + 1/86400; --BUG 7197943 To keep efectivity date of next rev 1 sec higher than earlier rev
4685: ELSE
4686: l_ref_designator_tbl(l_ref_designator_tbl_count).start_effective_date := p_revised_item_type_tbl(i).component_item_tbl(j).reference_designator_tbl(k).start_effective_date;
4687: END IF;

Line 4732: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4728: x_msg_data => x_out.output_status.msg_data ,
4729: x_msg_count => x_out.output_status.msg_count
4730: );
4731: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_out.output_status.return_status);
4732: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4733: RAISE FND_API.g_exc_unexpected_error;
4734: END IF;
4735:
4736: l_sub_component_tbl(l_sub_component_tbl_count).eco_name := p_change_order.eco_name;

Line 4733: RAISE FND_API.g_exc_unexpected_error;

4729: x_msg_count => x_out.output_status.msg_count
4730: );
4731: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_out.output_status.return_status);
4732: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4733: RAISE FND_API.g_exc_unexpected_error;
4734: END IF;
4735:
4736: l_sub_component_tbl(l_sub_component_tbl_count).eco_name := p_change_order.eco_name;
4737: l_sub_component_tbl(l_sub_component_tbl_count).organization_code := p_change_order.organization_code ;

Line 4745: OR p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).start_effective_date =fnd_api.g_miss_date) THEN

4741: l_sub_component_tbl(l_sub_component_tbl_count).component_item_name := p_revised_item_type_tbl(i).component_item_tbl(j).component_item_name ;
4742: l_sub_component_tbl(l_sub_component_tbl_count).alternate_bom_code := p_revised_item_type_tbl(i).alternate_bom_code;
4743: IF (p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).start_effective_date < l_effectivity_date
4744: OR p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).start_effective_date IS NULL
4745: OR p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).start_effective_date =fnd_api.g_miss_date) THEN
4746: l_sub_component_tbl(l_sub_component_tbl_count).start_effective_date := l_effectivity_date + 1/86400;
4747: ELSE
4748: l_sub_component_tbl(l_sub_component_tbl_count).start_effective_date := p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).start_effective_date;
4749: END IF;

Line 4819: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4815: );
4816:
4817:
4818: INV_EBI_UTIL.debug_line('STEP 120: AFTER CALLING ENG_ECO_PUB.process_eco STATUS: '|| x_out.output_status.return_status);
4819: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4820: RAISE FND_API.g_exc_unexpected_error;
4821: END IF;
4822:
4823: SELECT change_id ,change_notice INTO x_out.change_id,x_out.change_notice

Line 4820: RAISE FND_API.g_exc_unexpected_error;

4816:
4817:
4818: INV_EBI_UTIL.debug_line('STEP 120: AFTER CALLING ENG_ECO_PUB.process_eco STATUS: '|| x_out.output_status.return_status);
4819: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4820: RAISE FND_API.g_exc_unexpected_error;
4821: END IF;
4822:
4823: SELECT change_id ,change_notice INTO x_out.change_id,x_out.change_notice
4824: FROM eng_engineering_changes

Line 4831: IF FND_API.to_boolean( p_commit ) THEN

4827:
4828: x_out.organization_code := p_change_order.organization_code;
4829: x_out.organization_id := l_organization_id;
4830:
4831: IF FND_API.to_boolean( p_commit ) THEN
4832: COMMIT;
4833: END IF;
4834: INV_EBI_UTIL.debug_line('STEP 130: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco STATUS: '|| x_out.output_status.return_status);
4835: EXCEPTION

Line 4836: WHEN FND_API.g_exc_unexpected_error THEN

4832: COMMIT;
4833: END IF;
4834: INV_EBI_UTIL.debug_line('STEP 130: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco STATUS: '|| x_out.output_status.return_status);
4835: EXCEPTION
4836: WHEN FND_API.g_exc_unexpected_error THEN
4837: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
4838: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4839: IF(x_out.output_status.msg_data IS NULL) THEN
4840: fnd_msg_pub.count_and_get(

Line 4838: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

4834: INV_EBI_UTIL.debug_line('STEP 130: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco STATUS: '|| x_out.output_status.return_status);
4835: EXCEPTION
4836: WHEN FND_API.g_exc_unexpected_error THEN
4837: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
4838: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4839: IF(x_out.output_status.msg_data IS NULL) THEN
4840: fnd_msg_pub.count_and_get(
4841: p_encoded => FND_API.g_false
4842: ,p_count => x_out.output_status.msg_count

Line 4841: p_encoded => FND_API.g_false

4837: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
4838: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4839: IF(x_out.output_status.msg_data IS NULL) THEN
4840: fnd_msg_pub.count_and_get(
4841: p_encoded => FND_API.g_false
4842: ,p_count => x_out.output_status.msg_count
4843: ,p_data => x_out.output_status.msg_data
4844: );
4845: END IF;

Line 4848: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

4844: );
4845: END IF;
4846: WHEN OTHERS THEN
4847: ROLLBACK TO inv_ebi_proc_eco_save_pnt;
4848: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
4849: IF (x_out.output_status.msg_data IS NOT NULL) THEN
4850: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_eco ';
4851: ELSE
4852: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_eco ';

Line 4864: p_commit IN VARCHAR2 := FND_API.G_FALSE

4860: -- This API is used to Process bom and common bom.
4861: --
4862: ************************************************************************************/
4863: PROCEDURE process_structure_header(
4864: p_commit IN VARCHAR2 := FND_API.G_FALSE
4865: ,p_organization_code IN VARCHAR2
4866: ,p_assembly_item_name IN VARCHAR2
4867: ,p_alternate_bom_code IN VARCHAR2
4868: ,p_structure_header IN inv_ebi_structure_header_obj

Line 4882: l_bom_already_commoned varchar2(3) := FND_API.g_false;

4878: l_bom_sub_component_tbl bom_bo_pub.bom_sub_component_tbl_type;
4879: l_output_status inv_ebi_output_status;
4880: l_is_bom_exists VARCHAR2(3);
4881: l_transaction_type VARCHAR2(20);
4882: l_bom_already_commoned varchar2(3) := FND_API.g_false;
4883:
4884: BEGIN
4885: SAVEPOINT inv_ebi_proc_bom_save_pnt;
4886: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);

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

4882: l_bom_already_commoned varchar2(3) := FND_API.g_false;
4883:
4884: BEGIN
4885: SAVEPOINT inv_ebi_proc_bom_save_pnt;
4886: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
4887: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
4888: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header');
4889:
4890: l_is_bom_exists := is_bom_exists(

Line 4896: IF(l_is_bom_exists = fnd_api.g_false ) THEN

4892: p_organization_code => p_organization_code,
4893: p_alternate_bom_code => p_alternate_bom_code
4894: );
4895:
4896: IF(l_is_bom_exists = fnd_api.g_false ) THEN
4897: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create ;
4898: ELSE
4899: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_update;
4900:

Line 4909: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4905: p_alternate_bom_code => p_alternate_bom_code,
4906: p_component_item_tbl => p_component_item_tbl,
4907: x_out => x_out
4908: );
4909: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4910: RAISE FND_API.g_exc_unexpected_error;
4911: END IF; */
4912: END IF;
4913:

Line 4910: RAISE FND_API.g_exc_unexpected_error;

4906: p_component_item_tbl => p_component_item_tbl,
4907: x_out => x_out
4908: );
4909: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4910: RAISE FND_API.g_exc_unexpected_error;
4911: END IF; */
4912: END IF;
4913:
4914: IF(p_structure_header.common_assembly_item_name IS NOT NULL AND

Line 4915: p_structure_header.common_assembly_item_name <> fnd_api.g_miss_char AND

4911: END IF; */
4912: END IF;
4913:
4914: IF(p_structure_header.common_assembly_item_name IS NOT NULL AND
4915: p_structure_header.common_assembly_item_name <> fnd_api.g_miss_char AND
4916: p_structure_header.common_organization_code IS NOT NULL AND
4917: p_structure_header.common_organization_code <> fnd_api.g_miss_char
4918: ) THEN
4919: --Bug 7127027

Line 4917: p_structure_header.common_organization_code <> fnd_api.g_miss_char

4913:
4914: IF(p_structure_header.common_assembly_item_name IS NOT NULL AND
4915: p_structure_header.common_assembly_item_name <> fnd_api.g_miss_char AND
4916: p_structure_header.common_organization_code IS NOT NULL AND
4917: p_structure_header.common_organization_code <> fnd_api.g_miss_char
4918: ) THEN
4919: --Bug 7127027
4920: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_bom '||' ORG CODE : '|| p_organization_code ||
4921: ' ASSY ITEM NAME : '|| p_assembly_item_name ||' COMMON ASSY ITEM NAME: '|| p_structure_header.common_assembly_item_name ||

Line 4934: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

4930: ,x_msg_data => x_out.output_status.msg_data
4931: ,x_msg_count => x_out.output_status.msg_count
4932: );
4933: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_bom STATUS : '|| x_out.output_status.return_status);
4934: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4935: RAISE FND_API.g_exc_unexpected_error;
4936: END IF;
4937: END IF;
4938:

Line 4935: RAISE FND_API.g_exc_unexpected_error;

4931: ,x_msg_count => x_out.output_status.msg_count
4932: );
4933: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_bom STATUS : '|| x_out.output_status.return_status);
4934: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
4935: RAISE FND_API.g_exc_unexpected_error;
4936: END IF;
4937: END IF;
4938:
4939: l_bom_header_rec.assembly_item_name := p_assembly_item_name ;

Line 4973: l_bom_header_rec.structure_type_name = fnd_api.g_miss_char )

4969: l_bom_header_rec.enable_attrs_update := p_structure_header.enable_attrs_update ;
4970: l_bom_header_rec.structure_type_name := p_structure_header.structure_type_name ;
4971:
4972: IF(l_bom_header_rec.structure_type_name IS NULL OR
4973: l_bom_header_rec.structure_type_name = fnd_api.g_miss_char )
4974: AND (INV_EBI_UTIL.is_pim_installed) THEN
4975: IF p_name_val_list.name_value_table IS NOT NULL THEN
4976: FOR i in p_name_val_list.name_value_table.FIRST..p_name_val_list.name_value_table.LAST LOOP
4977: IF UPPER(p_name_val_list.name_value_table(i).param_name) = G_DEFAULT_STRUCTURE_TYPE THEN

Line 4993: IF(l_bom_already_commoned = fnd_api.g_false) THEN -- End of Bug 13340150

4989: p_alternate_bom_code => p_alternate_bom_code
4990: );
4991:
4992: END IF;
4993: IF(l_bom_already_commoned = fnd_api.g_false) THEN -- End of Bug 13340150
4994:
4995: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING BOM_BO_PUB.process_bom');
4996:
4997: BOM_BO_PUB.process_bom

Line 5013: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

5009: ,x_return_status => x_out.output_status.return_status
5010: ,x_msg_count => x_out.output_status.msg_count
5011: );
5012: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING BOM_BO_PUB.process_bom '||' RETURN STATUS: '|| x_out.output_status.return_status);
5013: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
5014: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number: '|| p_assembly_item_name || ' ORG CODE: '|| p_organization_code;
5015: RAISE FND_API.g_exc_unexpected_error;
5016: END IF;
5017: END IF;

Line 5015: RAISE FND_API.g_exc_unexpected_error;

5011: );
5012: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING BOM_BO_PUB.process_bom '||' RETURN STATUS: '|| x_out.output_status.return_status);
5013: IF (x_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
5014: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number: '|| p_assembly_item_name || ' ORG CODE: '|| p_organization_code;
5015: RAISE FND_API.g_exc_unexpected_error;
5016: END IF;
5017: END IF;
5018: IF FND_API.to_boolean( p_commit ) THEN
5019: COMMIT;

Line 5018: IF FND_API.to_boolean( p_commit ) THEN

5014: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number: '|| p_assembly_item_name || ' ORG CODE: '|| p_organization_code;
5015: RAISE FND_API.g_exc_unexpected_error;
5016: END IF;
5017: END IF;
5018: IF FND_API.to_boolean( p_commit ) THEN
5019: COMMIT;
5020: END IF;
5021: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header STATUS: '|| x_out.output_status.return_status);
5022: EXCEPTION

Line 5023: WHEN FND_API.g_exc_unexpected_error THEN

5019: COMMIT;
5020: END IF;
5021: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header STATUS: '|| x_out.output_status.return_status);
5022: EXCEPTION
5023: WHEN FND_API.g_exc_unexpected_error THEN
5024: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
5025: x_out.output_status.return_status := FND_API.g_ret_sts_error;
5026: IF(x_out.output_status.msg_data IS NULL) THEN
5027: fnd_msg_pub.count_and_get(

Line 5025: x_out.output_status.return_status := FND_API.g_ret_sts_error;

5021: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_structure_header STATUS: '|| x_out.output_status.return_status);
5022: EXCEPTION
5023: WHEN FND_API.g_exc_unexpected_error THEN
5024: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
5025: x_out.output_status.return_status := FND_API.g_ret_sts_error;
5026: IF(x_out.output_status.msg_data IS NULL) THEN
5027: fnd_msg_pub.count_and_get(
5028: p_encoded => FND_API.g_false
5029: ,p_count => x_out.output_status.msg_count

Line 5028: p_encoded => FND_API.g_false

5024: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
5025: x_out.output_status.return_status := FND_API.g_ret_sts_error;
5026: IF(x_out.output_status.msg_data IS NULL) THEN
5027: fnd_msg_pub.count_and_get(
5028: p_encoded => FND_API.g_false
5029: ,p_count => x_out.output_status.msg_count
5030: ,p_data => x_out.output_status.msg_data
5031: );
5032: END IF;

Line 5035: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;

5031: );
5032: END IF;
5033: WHEN OTHERS THEN
5034: ROLLBACK TO inv_ebi_proc_bom_save_pnt;
5035: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
5036: IF (x_out.output_status.msg_data IS NOT NULL) THEN
5037: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ';
5038: ELSE
5039: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ';

Line 5079: l_include_rev_items VARCHAR2(1):= fnd_api.g_true;

5075: l_sub_index NUMBER;
5076: l_ref_index NUMBER;
5077: l_change_id NUMBER := NULL;
5078: l_revised_item_sequence_id NUMBER := NULL;
5079: l_include_rev_items VARCHAR2(1):= fnd_api.g_true;
5080: l_include_comp_items VARCHAR2(1):= fnd_api.g_true;
5081: l_include_sub_comp VARCHAR2(1):= fnd_api.g_true;
5082: l_include_ref_designators VARCHAR2(1):= fnd_api.g_true;
5083: l_item_obj inv_ebi_item_obj;

Line 5080: l_include_comp_items VARCHAR2(1):= fnd_api.g_true;

5076: l_ref_index NUMBER;
5077: l_change_id NUMBER := NULL;
5078: l_revised_item_sequence_id NUMBER := NULL;
5079: l_include_rev_items VARCHAR2(1):= fnd_api.g_true;
5080: l_include_comp_items VARCHAR2(1):= fnd_api.g_true;
5081: l_include_sub_comp VARCHAR2(1):= fnd_api.g_true;
5082: l_include_ref_designators VARCHAR2(1):= fnd_api.g_true;
5083: l_item_obj inv_ebi_item_obj;
5084:

Line 5081: l_include_sub_comp VARCHAR2(1):= fnd_api.g_true;

5077: l_change_id NUMBER := NULL;
5078: l_revised_item_sequence_id NUMBER := NULL;
5079: l_include_rev_items VARCHAR2(1):= fnd_api.g_true;
5080: l_include_comp_items VARCHAR2(1):= fnd_api.g_true;
5081: l_include_sub_comp VARCHAR2(1):= fnd_api.g_true;
5082: l_include_ref_designators VARCHAR2(1):= fnd_api.g_true;
5083: l_item_obj inv_ebi_item_obj;
5084:
5085: CURSOR c_change_order_type(p_change_id IN VARCHAR2) IS

Line 5082: l_include_ref_designators VARCHAR2(1):= fnd_api.g_true;

5078: l_revised_item_sequence_id NUMBER := NULL;
5079: l_include_rev_items VARCHAR2(1):= fnd_api.g_true;
5080: l_include_comp_items VARCHAR2(1):= fnd_api.g_true;
5081: l_include_sub_comp VARCHAR2(1):= fnd_api.g_true;
5082: l_include_ref_designators VARCHAR2(1):= fnd_api.g_true;
5083: l_item_obj inv_ebi_item_obj;
5084:
5085: CURSOR c_change_order_type(p_change_id IN VARCHAR2) IS
5086: SELECT

Line 5438: x_return_status := fnd_api.g_ret_sts_success;

5434: revised_item_sequence_id = p_revised_item_sequence_id;
5435:
5436: BEGIN
5437: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_eco');
5438: x_return_status := fnd_api.g_ret_sts_success;
5439: l_change_id := p_change_id ;
5440: l_revised_item_sequence_id := p_revised_item_sequence_id;
5441:
5442: FND_MSG_PUB.initialize();

Line 5446: RAISE FND_API.g_exc_error;

5442: FND_MSG_PUB.initialize();
5443: IF (l_change_id IS NULL AND l_revised_item_sequence_id IS NULL) THEN
5444: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_REV_SEQ_NULL');
5445: FND_MSG_PUB.add;
5446: RAISE FND_API.g_exc_error;
5447: END IF;
5448:
5449: IF (l_revised_item_sequence_id IS NOT NULL AND l_change_id IS NULL) THEN
5450: OPEN c_change_id(l_revised_item_sequence_id);

Line 5456: RAISE FND_API.g_exc_error;

5452: IF c_change_id%NOTFOUND THEN
5453: FND_MESSAGE.set_name('INV','INV_EBI_REV_SEQ_ID_INVALID');
5454: FND_MESSAGE.set_token('REV_SEQ_ID',l_revised_item_sequence_id);
5455: FND_MSG_PUB.add;
5456: RAISE FND_API.g_exc_error;
5457: END IF;
5458: CLOSE c_change_id;
5459: END IF;
5460:

Line 5479: l_include_rev_items := fnd_api.g_false;

5475: END LOOP;
5476: END IF;
5477:
5478: IF NVL(p_last_update_status,'Y') = 'N' THEN
5479: l_include_rev_items := fnd_api.g_false;
5480: l_include_comp_items := fnd_api.g_false;
5481: l_include_sub_comp := fnd_api.g_false;
5482: l_include_ref_designators := fnd_api.g_false;
5483: END IF;

Line 5480: l_include_comp_items := fnd_api.g_false;

5476: END IF;
5477:
5478: IF NVL(p_last_update_status,'Y') = 'N' THEN
5479: l_include_rev_items := fnd_api.g_false;
5480: l_include_comp_items := fnd_api.g_false;
5481: l_include_sub_comp := fnd_api.g_false;
5482: l_include_ref_designators := fnd_api.g_false;
5483: END IF;
5484: l_eco_revision_tbl := inv_ebi_eco_revision_tbl();

Line 5481: l_include_sub_comp := fnd_api.g_false;

5477:
5478: IF NVL(p_last_update_status,'Y') = 'N' THEN
5479: l_include_rev_items := fnd_api.g_false;
5480: l_include_comp_items := fnd_api.g_false;
5481: l_include_sub_comp := fnd_api.g_false;
5482: l_include_ref_designators := fnd_api.g_false;
5483: END IF;
5484: l_eco_revision_tbl := inv_ebi_eco_revision_tbl();
5485:

Line 5482: l_include_ref_designators := fnd_api.g_false;

5478: IF NVL(p_last_update_status,'Y') = 'N' THEN
5479: l_include_rev_items := fnd_api.g_false;
5480: l_include_comp_items := fnd_api.g_false;
5481: l_include_sub_comp := fnd_api.g_false;
5482: l_include_ref_designators := fnd_api.g_false;
5483: END IF;
5484: l_eco_revision_tbl := inv_ebi_eco_revision_tbl();
5485:
5486: OPEN c_change_order_type (l_change_id);

Line 5492: RAISE FND_API.g_exc_error;

5488: IF c_change_order_type%NOTFOUND THEN
5489: FND_MESSAGE.set_name('INV','INV_EBI_CHG_ID_INVALID');
5490: FND_MESSAGE.set_token('CHG_ID',l_change_id);
5491: FND_MSG_PUB.add;
5492: RAISE FND_API.g_exc_error;
5493: END IF;
5494: l_eco_change_order_obj := inv_ebi_change_order_obj(
5495: c_eco_header.change_notice
5496: ,l_change_id

Line 5601: IF (l_include_rev_items = fnd_api.g_true) THEN

5597: l_eco_revision_tbl(l_current_index) := l_eco_revision_obj;
5598: l_current_index := l_current_index + 1;
5599: END LOOP;
5600:
5601: IF (l_include_rev_items = fnd_api.g_true) THEN
5602: l_reviseditem_index := 1;
5603: FOR ri IN c_revised_item(l_change_id)
5604: LOOP
5605: OPEN c_structure_header(l_change_id,ri.revised_item_id);

Line 5642: IF (l_include_comp_items = fnd_api.g_true) THEN

5638: );
5639: CLOSE c_structure_header;
5640: l_comp_index := 1;
5641: l_revision_component_tbl := inv_ebi_rev_comp_tbl();
5642: IF (l_include_comp_items = fnd_api.g_true) THEN
5643: FOR rc IN c_revision_component(l_change_id,ri.revised_item_id)
5644: LOOP
5645: l_ref_index := 1;
5646: l_reference_designator_tbl := inv_ebi_ref_desg_tbl();

Line 5647: IF (l_include_ref_designators = fnd_api.g_true) THEN

5643: FOR rc IN c_revision_component(l_change_id,ri.revised_item_id)
5644: LOOP
5645: l_ref_index := 1;
5646: l_reference_designator_tbl := inv_ebi_ref_desg_tbl();
5647: IF (l_include_ref_designators = fnd_api.g_true) THEN
5648: FOR rd IN c_reference_designator(l_change_id,ri.revised_item_id,rc.component_item_id)
5649: LOOP
5650: l_reference_designator_tbl.extend();
5651: l_reference_designator_obj := inv_ebi_ref_desg_obj(

Line 5683: END IF; -- IF (l_include_ref_designators = fnd_api.g_true) THEN

5679: ,NULL);
5680: l_reference_designator_tbl(l_ref_index) := l_reference_designator_obj;
5681: l_ref_index := l_ref_index + 1;
5682: END LOOP;
5683: END IF; -- IF (l_include_ref_designators = fnd_api.g_true) THEN
5684:
5685: l_sub_index :=1;
5686: l_substitute_component_tbl := inv_ebi_sub_comp_tbl();
5687: IF (l_include_sub_comp = fnd_api.g_true) THEN

Line 5687: IF (l_include_sub_comp = fnd_api.g_true) THEN

5683: END IF; -- IF (l_include_ref_designators = fnd_api.g_true) THEN
5684:
5685: l_sub_index :=1;
5686: l_substitute_component_tbl := inv_ebi_sub_comp_tbl();
5687: IF (l_include_sub_comp = fnd_api.g_true) THEN
5688: FOR sc IN c_substitute_component(l_change_id,ri.revised_item_id,rc.component_item_id)
5689: LOOP
5690: l_substitute_component_tbl.extend();
5691: l_substitute_component_obj := inv_ebi_sub_comp_obj(

Line 5726: END IF; -- IF (l_include_sub_comp = fnd_api.g_true) THEN

5722: ,NULL);
5723: l_substitute_component_tbl(l_sub_index) := l_substitute_component_obj;
5724: l_sub_index := l_sub_index + 1;
5725: END LOOP;
5726: END IF; -- IF (l_include_sub_comp = fnd_api.g_true) THEN
5727:
5728: l_revision_component_tbl.extend();
5729: l_revision_component_obj := inv_ebi_rev_comp_obj(
5730: NULL

Line 5801: END IF; -- IF (l_include_comp_items = fnd_api.g_true) THEN

5797: ,NULL);
5798: l_revision_component_tbl(l_comp_index) := l_revision_component_obj;
5799: l_comp_index := l_comp_index + 1;
5800: END LOOP;
5801: END IF; -- IF (l_include_comp_items = fnd_api.g_true) THEN
5802:
5803:
5804: IF (l_revised_item_sequence_id IS NULL
5805: OR ri.revised_item_sequence_id = l_revised_item_sequence_id) THEN

Line 5942: END IF; -- IF (l_include_rev_items = fnd_api.g_true) THEN

5938: l_revised_item_tbl(l_reviseditem_index) := l_revised_item_obj;
5939: l_reviseditem_index := l_reviseditem_index + 1;
5940: END IF;
5941: END LOOP;
5942: END IF; -- IF (l_include_rev_items = fnd_api.g_true) THEN
5943:
5944: IF (INV_EBI_UTIL.is_pim_installed) THEN --Bug 8369900 To check is_pim_installed for reverse flow
5945: --Bug 7240247 To Retrieve Change order Header level Udas if any exists for this change_id
5946: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda');

Line 5955: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

5951: x_msg_count => x_msg_count,
5952: x_msg_data => x_msg_data
5953: );
5954: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda STATUS: '||x_return_status);
5955: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5956: RAISE FND_API.g_exc_unexpected_error;
5957: END IF;
5958:
5959: --Bug 7240247 To Retrieve Structure Header level Udas if any exists for this change_id

Line 5956: RAISE FND_API.g_exc_unexpected_error;

5952: x_msg_data => x_msg_data
5953: );
5954: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda STATUS: '||x_return_status);
5955: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5956: RAISE FND_API.g_exc_unexpected_error;
5957: END IF;
5958:
5959: --Bug 7240247 To Retrieve Structure Header level Udas if any exists for this change_id
5960: FOR i IN 1..l_revised_item_tbl.COUNT LOOP

Line 5972: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

5968: x_msg_count => x_msg_count,
5969: x_msg_data => x_msg_data
5970: );
5971: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda STATUS: '||x_return_status);
5972: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5973: RAISE FND_API.g_exc_unexpected_error;
5974: END IF;
5975:
5976: --Bug 7240247

Line 5973: RAISE FND_API.g_exc_unexpected_error;

5969: x_msg_data => x_msg_data
5970: );
5971: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda STATUS: '||x_return_status);
5972: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5973: RAISE FND_API.g_exc_unexpected_error;
5974: END IF;
5975:
5976: --Bug 7240247
5977: FOR j IN 1..l_revised_item_tbl(i).component_item_tbl.COUNT LOOP

Line 5991: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

5987: x_msg_count => x_msg_count,
5988: x_msg_data => x_msg_data
5989: );
5990: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda STATUS: '||x_return_status);
5991: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5992: RAISE FND_API.g_exc_unexpected_error;
5993: END IF;
5994: END LOOP;
5995:

Line 5992: RAISE FND_API.g_exc_unexpected_error;

5988: x_msg_data => x_msg_data
5989: );
5990: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda STATUS: '||x_return_status);
5991: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5992: RAISE FND_API.g_exc_unexpected_error;
5993: END IF;
5994: END LOOP;
5995:
5996: END LOOP;

Line 6001: WHEN FND_API.g_exc_error THEN

5997: END IF;-- Bug 8369900 end
5998: x_eco_obj := inv_ebi_eco_obj(l_eco_change_order_obj,l_eco_revision_tbl,l_revised_item_tbl,NULL);
5999: INV_EBI_UTIL.debug_line('STEP 80: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco');
6000: EXCEPTION
6001: WHEN FND_API.g_exc_error THEN
6002: x_return_status := FND_API.g_ret_sts_error;
6003: IF(x_msg_data IS NULL) THEN
6004: FND_MSG_PUB.count_and_get(
6005: p_encoded => FND_API.g_false

Line 6002: x_return_status := FND_API.g_ret_sts_error;

5998: x_eco_obj := inv_ebi_eco_obj(l_eco_change_order_obj,l_eco_revision_tbl,l_revised_item_tbl,NULL);
5999: INV_EBI_UTIL.debug_line('STEP 80: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco');
6000: EXCEPTION
6001: WHEN FND_API.g_exc_error THEN
6002: x_return_status := FND_API.g_ret_sts_error;
6003: IF(x_msg_data IS NULL) THEN
6004: FND_MSG_PUB.count_and_get(
6005: p_encoded => FND_API.g_false
6006: ,p_count => x_msg_count

Line 6005: p_encoded => FND_API.g_false

6001: WHEN FND_API.g_exc_error THEN
6002: x_return_status := FND_API.g_ret_sts_error;
6003: IF(x_msg_data IS NULL) THEN
6004: FND_MSG_PUB.count_and_get(
6005: p_encoded => FND_API.g_false
6006: ,p_count => x_msg_count
6007: ,p_data => x_msg_data
6008: );
6009: END IF;

Line 6011: x_return_status := FND_API.g_ret_sts_error;

6007: ,p_data => x_msg_data
6008: );
6009: END IF;
6010: WHEN OTHERS THEN
6011: x_return_status := FND_API.g_ret_sts_error;
6012: IF (x_msg_data IS NOT NULL) THEN
6013: x_msg_data := x_msg_data ||' -> at INV_EBI_CHANGE_ORDER_HELPER.get_eco';
6014: ELSE
6015: x_msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_HELPER.get_eco ';

Line 6038: x_return_status := FND_API.g_ret_sts_success;

6034: l_eco_output_tbl inv_ebi_change_id_obj_tbl;
6035: l_counter NUMBER:=0;
6036: l_org_code VARCHAR2(10);
6037: BEGIN
6038: x_return_status := FND_API.g_ret_sts_success;
6039: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.filter_ecos_based_on_org');
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:

Line 6078: x_return_status := FND_API.g_ret_sts_unexp_error;

6074: END IF;
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: /***************************************************************************************************

Line 6115: x_return_status := FND_API.g_ret_sts_success;

6111: SELECT change_id
6112: FROM eng_engineering_changes
6113: WHERE change_notice = p_chg_notice;
6114: BEGIN
6115: x_return_status := FND_API.g_ret_sts_success;
6116: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco');
6117: INV_EBI_UTIL.debug_line('STEP 20: CHANGE ORDER NAMES '|| 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();

Line 6146: RAISE FND_API.G_EXC_ERROR;

6142: ELSE
6143: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
6144: FND_MESSAGE.set_token('COL_VALUE', l_eco_tbl(i));
6145: FND_MSG_PUB.add;
6146: RAISE FND_API.G_EXC_ERROR;
6147: END IF;
6148: EXCEPTION
6149: WHEN FND_API.G_EXC_ERROR THEN
6150: x_return_status := FND_API.g_ret_sts_error;

Line 6149: WHEN FND_API.G_EXC_ERROR THEN

6145: FND_MSG_PUB.add;
6146: RAISE FND_API.G_EXC_ERROR;
6147: END IF;
6148: EXCEPTION
6149: WHEN FND_API.G_EXC_ERROR THEN
6150: x_return_status := FND_API.g_ret_sts_error;
6151: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6152: ,p_count => x_msg_count
6153: ,p_data => l_msg_data

Line 6150: x_return_status := FND_API.g_ret_sts_error;

6146: RAISE FND_API.G_EXC_ERROR;
6147: END IF;
6148: EXCEPTION
6149: WHEN FND_API.G_EXC_ERROR THEN
6150: x_return_status := FND_API.g_ret_sts_error;
6151: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6152: ,p_count => x_msg_count
6153: ,p_data => l_msg_data
6154: );

Line 6151: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

6147: END IF;
6148: EXCEPTION
6149: WHEN FND_API.G_EXC_ERROR THEN
6150: x_return_status := FND_API.g_ret_sts_error;
6151: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6152: ,p_count => x_msg_count
6153: ,p_data => l_msg_data
6154: );
6155: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 6157: x_return_status := FND_API.g_ret_sts_error;

6153: ,p_data => l_msg_data
6154: );
6155: x_msg_data := x_msg_data || l_msg_data ||' , ' ;
6156: WHEN OTHERS THEN
6157: x_return_status := FND_API.g_ret_sts_error;
6158: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';
6159: END;
6160: END LOOP;
6161: END IF;

Line 6180: RAISE FND_API.G_EXC_ERROR;

6176: ELSE
6177: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
6178: FND_MESSAGE.set_token('COL_VALUE', l_org_tbl(i));
6179: FND_MSG_PUB.add;
6180: RAISE FND_API.G_EXC_ERROR;
6181: END IF;
6182: EXCEPTION
6183: WHEN FND_API.G_EXC_ERROR THEN
6184: x_return_status := FND_API.g_ret_sts_error;

Line 6183: WHEN FND_API.G_EXC_ERROR THEN

6179: FND_MSG_PUB.add;
6180: RAISE FND_API.G_EXC_ERROR;
6181: END IF;
6182: EXCEPTION
6183: WHEN FND_API.G_EXC_ERROR THEN
6184: x_return_status := FND_API.g_ret_sts_error;
6185: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6186: ,p_count => x_msg_count
6187: ,p_data => l_msg_data

Line 6184: x_return_status := FND_API.g_ret_sts_error;

6180: RAISE FND_API.G_EXC_ERROR;
6181: END IF;
6182: EXCEPTION
6183: WHEN FND_API.G_EXC_ERROR THEN
6184: x_return_status := FND_API.g_ret_sts_error;
6185: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6186: ,p_count => x_msg_count
6187: ,p_data => l_msg_data
6188: );

Line 6185: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

6181: END IF;
6182: EXCEPTION
6183: WHEN FND_API.G_EXC_ERROR THEN
6184: x_return_status := FND_API.g_ret_sts_error;
6185: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6186: ,p_count => x_msg_count
6187: ,p_data => l_msg_data
6188: );
6189: x_msg_data := x_msg_data || l_msg_data ||' , ' ;

Line 6191: x_return_status := FND_API.g_ret_sts_error;

6187: ,p_data => l_msg_data
6188: );
6189: x_msg_data := x_msg_data || l_msg_data ||' , ' ;
6190: WHEN OTHERS THEN
6191: x_return_status := FND_API.g_ret_sts_error;
6192: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';
6193: END;
6194: END LOOP;
6195: END IF;

Line 6248: RAISE FND_API.G_EXC_ERROR;

6244: IF l_count = 0 THEN
6245: FND_MESSAGE.set_name('INV','INV_EBI_INVALID_USER_INPUT');
6246: FND_MESSAGE.set_token('USER_INPUT', l_valid_eco_tbl(i));
6247: FND_MSG_PUB.add;
6248: RAISE FND_API.G_EXC_ERROR;
6249: END IF;
6250: EXCEPTION
6251: WHEN FND_API.G_EXC_ERROR THEN
6252: x_return_status := FND_API.g_ret_sts_error;

Line 6251: WHEN FND_API.G_EXC_ERROR THEN

6247: FND_MSG_PUB.add;
6248: RAISE FND_API.G_EXC_ERROR;
6249: END IF;
6250: EXCEPTION
6251: WHEN FND_API.G_EXC_ERROR THEN
6252: x_return_status := FND_API.g_ret_sts_error;
6253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6254: ,p_count => x_msg_count
6255: ,p_data => l_msg_data

Line 6252: x_return_status := FND_API.g_ret_sts_error;

6248: RAISE FND_API.G_EXC_ERROR;
6249: END IF;
6250: EXCEPTION
6251: WHEN FND_API.G_EXC_ERROR THEN
6252: x_return_status := FND_API.g_ret_sts_error;
6253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6254: ,p_count => x_msg_count
6255: ,p_data => l_msg_data
6256: );

Line 6253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false

6249: END IF;
6250: EXCEPTION
6251: WHEN FND_API.G_EXC_ERROR THEN
6252: x_return_status := FND_API.g_ret_sts_error;
6253: FND_MSG_PUB.count_and_get( p_encoded => FND_API.g_false
6254: ,p_count => x_msg_count
6255: ,p_data => l_msg_data
6256: );
6257: x_msg_data := x_msg_data || l_msg_data ;

Line 6259: x_return_status := FND_API.g_ret_sts_unexp_error;

6255: ,p_data => l_msg_data
6256: );
6257: x_msg_data := x_msg_data || l_msg_data ;
6258: WHEN OTHERS THEN
6259: x_return_status := FND_API.g_ret_sts_unexp_error;
6260: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';
6261: END;
6262: END LOOP;
6263: END IF;

Line 6275: x_return_status := FND_API.g_ret_sts_unexp_error;

6271: END IF;
6272: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco STATUS: '|| x_return_status);
6273: EXCEPTION
6274: WHEN OTHERS THEN
6275: x_return_status := FND_API.g_ret_sts_unexp_error;
6276: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';
6277: END parse_and_get_eco;
6278:
6279: /************************************************************************************

Line 6339: x_return_status := FND_API.G_RET_STS_SUCCESS;

6335: BEGIN
6336: FND_MSG_PUB.initialize();
6337: INV_EBI_UTIL.setup();
6338: INV_EBI_UTIL.debug_line('Step 10: START CALLING INV_EBI_CHANGE_ORDER_HELPER.GET_ECO_LIST');
6339: x_return_status := FND_API.G_RET_STS_SUCCESS;
6340:
6341: IF (p_name_value_list IS NOT NULL AND p_name_value_list.COUNT > 0) THEN
6342: l_eco_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Change Order Name');
6343: l_org_string := INV_EBI_UTIL.get_config_param_value(p_name_value_list,'Organization Code');

Line 6393: IF (l_return_status <> FND_API.g_ret_sts_success) THEN

6389: ,x_msg_count => l_msg_count
6390: ,x_msg_data => l_msg_data);
6391: END IF;
6392: INV_EBI_UTIL.debug_line('STEP 150: AFTER CALLING PARSE_AND_GET_ECO STATUS: '|| x_return_status);
6393: IF (l_return_status <> FND_API.g_ret_sts_success) THEN
6394: x_return_status := l_return_status;
6395: IF l_msg_data IS NOT NULL THEN
6396: x_msg_data := l_msg_data;
6397: END IF;

Line 6433: IF (l_return_status = FND_API.g_ret_sts_success) THEN

6429: ,x_return_status => l_return_status
6430: ,x_msg_count => l_msg_count
6431: ,x_msg_data => l_msg_data);
6432: INV_EBI_UTIL.debug_line('STEP 180: AFTER CALLING FILTER ECOS BASED ON ORG STATUS: '|| x_return_status);
6433: IF (l_return_status = FND_API.g_ret_sts_success) THEN
6434: x_eco := l_eco_org_output_tbl;
6435: ELSE
6436: x_return_status := l_return_status;
6437: IF x_msg_data IS NOT NULL THEN

Line 6457: x_return_status := FND_API.g_ret_sts_unexp_error;

6453: INV_EBI_UTIL.debug_line('STEP 200: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco_list STATUS: '||x_return_status);
6454: INV_EBI_UTIL.wrapup;
6455: EXCEPTION
6456: WHEN OTHERS THEN
6457: x_return_status := FND_API.g_ret_sts_unexp_error;
6458: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.get_eco_list';
6459: IF (c_get_final_eco_list%ISOPEN) THEN
6460: CLOSE c_get_final_eco_list;
6461: END IF;