eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.INV_EBI_CHANGE_ORDER_HELPER dependencies on INV_EBI_CHANGE_ORDER_HELPER

Line 1: PACKAGE BODY INV_EBI_CHANGE_ORDER_HELPER AS

1: PACKAGE BODY INV_EBI_CHANGE_ORDER_HELPER AS
2: /* $Header: INVEIHCOB.pls 120.57.12020000.3 2012/07/20 15:20:28 smukka ship $ */
3:
4: /************************************************************************************
5: -- API name : set_assign_item

Line 56: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ');

52: FROM ENG_CHANGES_EXT_B
53: WHERE change_id = p_change_id;
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);

Line 110: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ');

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 ');
111: EXCEPTION
112: WHEN FND_API.g_exc_unexpected_error THEN
113:
114: IF c_attr_group_id%ISOPEN THEN

Line 134: x_msg_data := x_msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ';

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 ';
137: END IF;
138: END get_change_order_uda;

Line 136: x_msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda ';

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 ';
137: END IF;
138: END get_change_order_uda;
139:
140: /************************************************************************************

Line 191: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda');

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');
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);

Line 256: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda');

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

Line 288: x_msg_data := x_msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda ';

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 ';
291: END IF;
292: END get_structure_header_uda;

Line 290: x_msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda ';

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 ';
291: END IF;
292: END get_structure_header_uda;
293:
294: /************************************************************************************

Line 359: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda');

355: component_item_id = p_component_item_id AND
356: change_notice = p_eco_name;
357:
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);

Line 441: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda');

437: CLOSE c_comp_count;
438: END IF;
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

Line 481: x_msg_data := x_msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda ';

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 ';
484: END IF;
485: END get_component_item_uda;

Line 483: x_msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda ';

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 ';
484: END IF;
485: END get_component_item_uda;
486:
487: /************************************************************************************

Line 557: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info');

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;
559: IF(p_sub_component_tbl IS NOT NULL AND p_sub_component_tbl.COUNT > 0 ) THEN
560:
561: l_sub_comp_tbl := inv_ebi_sub_comp_tbl();

Line 587: INV_EBI_UTIL.debug_line('STEP 20: END INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info STATUS: ' || x_out.output_status.return_status);

583: l_component_item.substitute_component_tbl := l_sub_comp_tbl;
584: END IF;
585:
586: END IF;
587: INV_EBI_UTIL.debug_line('STEP 20: END INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info STATUS: ' || x_out.output_status.return_status);
588: x_component_item := l_component_item;
589: EXCEPTION
590: WHEN OTHERS THEN
591:

Line 594: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info ';

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 ';
597: END IF;
598:

Line 596: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info ';

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 ';
597: END IF;
598:
599: END transform_substitute_comp_info;
600:

Line 622: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg');

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:
625: IF(p_ref_desg_tbl IS NOT NULL AND p_ref_desg_tbl.COUNT > 0 ) THEN
626:

Line 653: INV_EBI_UTIL.debug_line('STEP 20: END INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg STATUS: ' || x_out.output_status.return_status);

649: l_component_item.reference_designator_tbl := l_ref_desg_tbl;
650: END IF;
651:
652: END IF;
653: INV_EBI_UTIL.debug_line('STEP 20: END INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg STATUS: ' || x_out.output_status.return_status);
654: x_component_item := l_component_item;
655: EXCEPTION
656: WHEN OTHERS THEN
657:

Line 660: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg ';

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 ';
663: END IF;
664:

Line 662: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg ';

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 ';
663: END IF;
664:
665: END transform_ref_desg;
666:

Line 699: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info');

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;
701: l_src_sub_comp_tbl := p_src_component_item.substitute_component_tbl;
702: l_src_ref_desg_tbl := p_src_component_item.reference_designator_tbl;
703: l_dest_sub_comp_tbl := l_dest_component_item.substitute_component_tbl;

Line 800: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info ';

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 ';
803: END IF;
804: END merge_subcomp_refdesg_info;

Line 802: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info ';

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 ';
803: END IF;
804: END merge_subcomp_refdesg_info;
805:
806:

Line 842: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info');

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();
842: INV_EBI_UTIL.debug_line('STEP 10: INSIDE INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info');
843: FOR i IN 1..p_eco_obj_list.COUNT LOOP
844: IF(p_eco_obj_list(i).eco_revised_item_type IS NOT NULL AND p_eco_obj_list(i).eco_revised_item_type.COUNT > 0) THEN
845:
846: FOR j IN 1..p_eco_obj_list(i).eco_revised_item_type.COUNT LOOP

Line 928: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info');

924: ) THEN
925:
926: l_comp_exists := TRUE;
927:
928: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.merge_subcomp_refdesg_info');
929: INV_EBI_UTIL.debug_line('STEP 50: COMPONENT ITEM NAME '|| l_comp_item_tbl(i).component_item_name);
930: merge_subcomp_refdesg_info(
931: p_src_component_item => l_comp_item_tbl(i)
932: ,p_dest_component_item => l_revised_item_obj.component_item_tbl(j)

Line 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);

932: ,p_dest_component_item => l_revised_item_obj.component_item_tbl(j)
933: ,x_dest_component_item => l_revised_item_obj.component_item_tbl(j)
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;

Line 998: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info');

994: l_revised_item_obj.component_item_tbl(l_comp_count) := l_comp_item_tbl(i);
995: l_revised_item_obj.component_item_tbl(l_comp_count).acd_type := 1;
996: l_revised_item_obj.component_item_tbl(l_comp_count).substitute_component_tbl := NULL;
997: l_revised_item_obj.component_item_tbl(l_comp_count).reference_designator_tbl := NULL;
998: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_substitute_comp_info');
999: transform_substitute_comp_info(
1000: p_sub_component_tbl => l_comp_item_tbl(i).substitute_component_tbl
1001: ,p_component_item => l_revised_item_obj.component_item_tbl(l_comp_count)
1002: ,x_component_item => l_revised_item_obj.component_item_tbl(l_comp_count)

Line 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);

1001: ,p_component_item => l_revised_item_obj.component_item_tbl(l_comp_count)
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');

Line 1009: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_ref_desg');

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
1012: ,p_component_item => l_revised_item_obj.component_item_tbl(i)
1013: ,x_component_item => l_revised_item_obj.component_item_tbl(i)

Line 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);

1012: ,p_component_item => l_revised_item_obj.component_item_tbl(i)
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;

Line 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);

1025: END IF;
1026: END LOOP;
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:

Line 1045: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info ';

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 ';
1048: END IF;
1049: END transform_replicate_bom_info;

Line 1047: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info ';

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 ';
1048: END IF;
1049: END transform_replicate_bom_info;
1050: /************************************************************************************
1051: -- API name : prepare_substitute_components

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

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;
1169: CLOSE c_comp_sequence_id;
1170:

Line 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 );

1292: END LOOP;
1293: END IF;
1294:
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

Line 1323: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components ';

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 ';
1326: END IF;
1327: END prepare_substitute_components;

Line 1325: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components ';

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 ';
1326: END IF;
1327: END prepare_substitute_components;
1328:
1329: /************************************************************************************

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

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;
1438: CLOSE c_comp_sequence_id;
1439:

Line 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);

1551: END LOOP;
1552: END IF;
1553:
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

Line 1582: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators ';

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 ';
1585: END IF;
1586: END prepare_reference_designators;

Line 1584: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.prepare_reference_designators ';

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 ';
1585: END IF;
1586: END prepare_reference_designators;
1587:
1588:

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

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

Line 2045: INV_EBI_UTIL.debug_line('STEP 30: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items'|| ' OUTPUT STATUS: '|| x_out.output_status.return_status);

2041: CLOSE c_merged_component;
2042: END IF;
2043: END LOOP;
2044: END IF;
2045: INV_EBI_UTIL.debug_line('STEP 30: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items'|| ' OUTPUT STATUS: '|| x_out.output_status.return_status);
2046: x_revised_item := l_revised_item;
2047:
2048:
2049: EXCEPTION

Line 2074: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items ';

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 ';
2077: END IF;
2078: END prepare_component_items;

Line 2076: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items ';

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 ';
2077: END IF;
2078: END prepare_component_items;
2079:
2080: /************************************************************************************

Line 2093: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_Exists');

2089: ,p_alternate_bom_code IN VARCHAR2
2090: ) RETURN VARCHAR2 IS
2091: l_Count NUMBER := 0;
2092: BEGIN
2093: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_Exists');
2094: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| p_Item_Number || ' ORG CODE: '|| p_Organization_Code);
2095: SELECT
2096: COUNT(1)
2097: INTO

Line 2117: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_Exists');

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
2121: WHEN OTHERS THEN

Line 2141: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_Already_Commoned');

2137: l_bill_sequence_id NUMBER;
2138: l_src_bill_sequence_id NUMBER;
2139:
2140: BEGIN
2141: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_Already_Commoned');
2142: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| p_Item_Number || ' ORG CODE: '|| p_Organization_Code);
2143:
2144: SELECT bill_sequence_id, source_bill_sequence_id INTO l_bill_sequence_id, l_src_bill_sequence_id
2145: FROM BOM_BILL_OF_MATERIALS bb,

Line 2163: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.Is_BOM_ALready_Commoned');

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
2167: WHEN OTHERS THEN

Line 2189: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.is_new_revision_exists');

2185:
2186: l_Count NUMBER := 0;
2187:
2188: BEGIN
2189: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.is_new_revision_exists');
2190: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| p_Item_Number || ' REVISION: '|| p_revision || ' ORG CODE: '|| p_org_code);
2191: SELECT COUNT(1) INTO l_Count
2192: FROM
2193: eng_revised_items eri,

Line 2209: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.is_new_revision_exists');

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
2213: WHEN OTHERS THEN

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

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;
2335:
2336:

Line 2435: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_component_items ');

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 ');
2436: prepare_component_items (
2437: p_revised_item => l_revised_item1
2438: ,p_from_item_id => l_from_item_id
2439: ,p_to_item_id => l_to_item_id

Line 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);

2444: ,p_as_of_date => l_as_of_date
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:

Line 2455: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components ');

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
2455: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.prepare_substitute_components ');
2456: prepare_substitute_components (
2457: p_component_item => l_revised_item.component_item_tbl(j)
2458: ,p_from_sequence_id => l_from_sequence_id
2459: ,p_reference_org_id => l_from_org_id

Line 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);

2459: ,p_reference_org_id => l_from_org_id
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);

Line 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);

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
2470: ,p_from_sequence_id => l_from_sequence_id
2471: ,p_reference_org_id => l_from_org_id

Line 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);

2471: ,p_reference_org_id => l_from_org_id
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:

Line 2489: INV_EBI_UTIL.debug_line('STEP 110: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ');

2485: END IF;
2486: --END LOOP;
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;

Line 2505: x_out.output_status.msg_data := x_out.output_status.msg_data||' ->INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ';

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 ';
2508: END IF;
2509: END process_replicate_bom;

Line 2507: x_out.output_status.msg_data := SQLERRM||'INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom ';

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 ';
2508: END IF;
2509: END process_replicate_bom;
2510:
2511: /************************************************************************************

Line 2536: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_uda');

2532: l_uda_out inv_ebi_uda_output_obj;
2533: l_output_status inv_ebi_output_status;
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');

Line 2614: INV_EBI_UTIL.debug_line('STEP 60: END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');

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
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;

Line 2632: x_uda_output_obj.output_status.msg_data := x_uda_output_obj.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.process_uda ';

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 ';
2635: END IF;
2636: END process_uda;

Line 2634: x_uda_output_obj.output_status.msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_HELPER.process_uda ';

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 ';
2635: END IF;
2636: END process_uda;
2637: /************************************************************************************
2638: -- API name : process_change_order_uda

Line 2671: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');

2667: l_uda_out inv_ebi_uda_output_obj;
2668: l_output_status inv_ebi_output_status;
2669: BEGIN
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);

Line 2724: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');

2720: l_pkdata(2) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);
2721: l_pkcode := ego_col_name_value_pair_array();
2722: l_pkcode.extend();
2723: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);
2724: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');
2725: process_uda(
2726: p_commit => p_commit
2727: ,p_uda_input_obj => p_component_tbl(i).component_revision_uda
2728: ,p_object_name => 'BOM_COMPONENTS'

Line 2734: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda STATUS: '|| x_out.output_status.return_status);

2730: ,p_pk_column_name_value_pairs => l_pkdata
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;

Line 2756: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda FOR STRUCTURE HEADER');

2752: l_pkdata(1) := ego_col_name_value_pair_obj('BILL_SEQUENCE_ID',l_bill_sequence_id);
2753: l_pkcode := ego_col_name_value_pair_array();
2754: l_pkcode.extend();
2755: l_pkcode(1) := ego_col_name_value_pair_obj('STRUCTURE_TYPE_ID',l_structure_type_id);
2756: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda FOR STRUCTURE HEADER');
2757: process_uda(
2758: p_uda_input_obj => p_structure_header.structure_header_uda
2759: ,p_commit => p_commit
2760: ,p_object_name => 'BOM_STRUCTURE'

Line 2766: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda STATUS: '|| x_out.output_status.return_status);

2762: ,p_pk_column_name_value_pairs => l_pkdata
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;

Line 2775: INV_EBI_UTIL.debug_line('STEP 90: END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');

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
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;

Line 2791: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda';

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';
2794: END IF;
2795: END process_change_order_uda;

Line 2793: x_out.output_status.msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda';

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';
2794: END IF;
2795: END process_change_order_uda;
2796:
2797: /*******************************************************************************

Line 3036: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_existing_component_attr');

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
3038: l_assembly_item_id := INV_EBI_ITEM_HELPER.get_inventory_item_id
3039: (p_organization_id => p_organization_id
3040: ,p_item_number => p_revised_item_name);

Line 3188: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_existing_component_attr');

3184: END IF;
3185: --End of Bug 13582896
3186: END IF;
3187: -- END of Bug 8340804
3188: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_existing_component_attr');
3189: EXCEPTION
3190: WHEN OTHERS THEN
3191: IF c_implemented_component%ISOPEN THEN
3192: CLOSE c_implemented_component;

Line 3234: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_current_item_revision');

3230:
3231: l_item_rev c_item_rev%ROWTYPE;
3232:
3233: BEGIN
3234: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_current_item_revision');
3235: INV_EBI_UTIL.debug_line('STEP 20: INV ITEM ID: '|| p_inventory_item_id || ' ORG ID: '|| p_organization_id);
3236: IF c_item_rev%ISOPEN THEN
3237: CLOSE c_item_rev;
3238: END IF;

Line 3247: INV_EBI_UTIL.debug_line('STEP 30: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_current_item_revision RETURN VALUE: '|| l_revision);

3243: p_revision_date => sysdate
3244: );
3245: FETCH c_item_rev INTO l_revision;
3246: CLOSE c_item_rev;
3247: INV_EBI_UTIL.debug_line('STEP 30: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_current_item_revision RETURN VALUE: '|| l_revision);
3248: RETURN l_revision;
3249: EXCEPTION
3250: WHEN OTHERS THEN
3251: IF c_item_rev%ISOPEN THEN

Line 3321: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items');

3317: l_master_item_rev c_master_item_rev%ROWTYPE;
3318:
3319: BEGIN
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(

Line 3465: INV_EBI_UTIL.debug_line('STEP 80: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ');

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
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;

Line 3503: x_msg_data := x_msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ';

3499: IF c_master_item_rev%ISOPEN THEN
3500: CLOSE c_master_item_rev;
3501: END IF;
3502: IF (x_msg_data IS NOT NULL) THEN
3503: x_msg_data := x_msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ';
3504: ELSE
3505: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ';
3506: END IF;
3507: END process_assign_items;

Line 3505: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ';

3501: END IF;
3502: IF (x_msg_data IS NOT NULL) THEN
3503: x_msg_data := x_msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ';
3504: ELSE
3505: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ';
3506: END IF;
3507: END process_assign_items;
3508:
3509: /************************************************************************************

Line 3726: INV_EBI_UTIL.DEBUG_LINE('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');

3722: );
3723:
3724: l_common_sub_comps c_common_sub_comps%ROWTYPE;
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:

Line 3760: INV_EBI_UTIL.DEBUG_LINE('STEP 30: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ');

3756: LOOP
3757:
3758: FETCH c_common_comps INTO l_common_comps;
3759: EXIT WHEN c_common_comps%NOTFOUND;
3760: INV_EBI_UTIL.DEBUG_LINE('STEP 30: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items ');
3761: INV_EBI_UTIL.DEBUG_LINE('STEP 40: COMPONENT ITEM NAME: '|| l_common_comps.component_item_name);
3762: process_assign_items(
3763: p_organization_id => p_organization_id,
3764: p_item_name => l_common_comps.component_item_name,

Line 3769: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items STATUS: '|| x_return_status);

3765: x_return_status => x_return_status ,
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;

Line 3787: INV_EBI_UTIL.DEBUG_LINE('STEP 60: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items for substitute components');

3783: LOOP
3784:
3785: FETCH c_common_sub_comps INTO l_common_sub_comps;
3786: EXIT WHEN c_common_sub_comps%NOTFOUND;
3787: INV_EBI_UTIL.DEBUG_LINE('STEP 60: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items for substitute components');
3788: INV_EBI_UTIL.DEBUG_LINE('STEP 70: SUBSTITUTE COMP NAME: '|| l_common_sub_comps.sub_comp_item_name);
3789: process_assign_items(
3790: p_organization_id => p_organization_id,
3791: p_item_name => l_common_sub_comps.sub_comp_item_name,

Line 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);

3792: x_return_status => x_return_status ,
3793: x_msg_data => x_msg_data ,
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;

Line 3803: INV_EBI_UTIL.debug_line('STEP 90: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_comps');

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');
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

Line 3831: x_msg_data := x_msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_common_comps ';

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 ';
3834: END IF;
3835: END process_common_comps;

Line 3833: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_common_comps ';

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 ';
3834: END IF;
3835: END process_common_comps;
3836:
3837:

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

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(
3872: p_organization_code => p_common_organization_code

Line 3901: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_comps ');

3897: p_organization_id => l_organization_id
3898: ,p_item_number => p_assembly_item_name
3899: );
3900: INV_EBI_UTIL.debug_line('STEP 40: ASST ITEM ID: '|| l_assembly_item_id || 'ORG ID: '|| l_organization_id );
3901: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_comps ');
3902: process_common_comps(
3903: p_assembly_item_id => l_assembly_item_id,
3904: p_organization_id => l_organization_id,
3905: p_src_organization_id => l_src_organization_id,

Line 3911: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_comps STATUS: '|| x_return_status);

3907: x_return_status => x_return_status,
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 ');

Line 3915: INV_EBI_UTIL.debug_line('STEP 70: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ');

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
3918: ROLLBACK TO inv_ebi_comm_bom_save_pnt;
3919: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 3941: x_msg_data := x_msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ';

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 ';
3944: END IF;
3945: END process_common_bom;

Line 3943: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_common_bom ';

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 ';
3944: END IF;
3945: END process_common_bom;
3946:
3947: /************************************************************************************

Line 3982: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs');

3978: common_assembly_item_id = p_common_assy_item_id AND
3979: common_organization_id = p_common_org_id;
3980:
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(

Line 4014: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs STATUS: '|| x_return_status);

4010: x_common_orgs(l_org_count) := inv_ebi_org_obj(NULL,NULL);
4011: x_common_orgs(l_org_count).org_id := l_common_orgs.organization_id;
4012: END IF;
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

Line 4019: x_msg_data := x_msg_data ||' -> INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs ';

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 ';
4022: END IF;
4023: END get_common_bom_orgs;

Line 4021: x_msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs ';

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 ';
4022: END IF;
4023: END get_common_bom_orgs;
4024:
4025: /************************************************************************************

Line 4044: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs');

4040: l_output_status inv_ebi_output_status;
4041: l_count NUMBER;
4042: BEGIN
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);

Line 4052: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs');

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
4052: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_common_bom_orgs');
4053: get_common_bom_orgs(
4054: p_assembly_item_name => p_assembly_item_name,
4055: p_organization_code => p_organization_code,
4056: p_alternate_bom_code => p_alternate_bom_code,

Line 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);

4058: x_return_status => x_out.output_status.return_status ,
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:

Line 4074: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items');

4070: IF( p_component_item_tbl(j).acd_type = 1 ) THEN
4071:
4072: /*After commoning a bom to other orgs if components or sub com are added
4073: to source ensure that those comps and sub comps exists in all the commoned orgs */
4074: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items');
4075: INV_EBI_UTIL.debug_line('STEP 60: ORG ID: '|| l_common_orgs(i).org_id || 'COMP ITEM NAME: '|| p_component_item_tbl(j).component_item_name);
4076: process_assign_items(
4077: p_organization_id => l_common_orgs(i).org_id,
4078: p_item_name => p_component_item_tbl(j).component_item_name,

Line 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);

4079: x_return_status => x_out.output_status.return_status ,
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;

Line 4094: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items FOR SUBSTITUTE COMPONENTS');

4090: p_component_item_tbl(j).substitute_component_tbl .COUNT > 0) THEN
4091: FOR k IN 1..p_component_item_tbl(j).substitute_component_tbl.COUNT LOOP
4092:
4093: IF(p_component_item_tbl(j).substitute_component_tbl(k).acd_type = 1) THEN
4094: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items FOR SUBSTITUTE COMPONENTS');
4095: INV_EBI_UTIL.debug_line('STEP 90: SUBS COMP ITEM NAME: '|| p_component_item_tbl(j).substitute_component_tbl(k).substitute_component_name);
4096: process_assign_items(
4097: p_organization_id => l_common_orgs(i).org_id,
4098: p_item_name => p_component_item_tbl(j).substitute_component_tbl(k).substitute_component_name,

Line 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);

4099: x_return_status => x_out.output_status.return_status ,
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;

Line 4113: INV_EBI_UTIL.debug_line('STEP 110: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs ');

4109: END IF;
4110: END LOOP;
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;

Line 4129: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs ';

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 ';
4132: END IF;
4133: END process_common_bom_orgs;

Line 4131: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs ';

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 ';
4132: END IF;
4133: END process_common_bom_orgs;
4134:
4135: /************************************************************************************

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

4196: l_allow_unimp_bom_update VARCHAR2(1) := NULL;
4197:
4198: BEGIN
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);

Line 4527: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs '||

4523:
4524: IF(p_revised_item_type_tbl(i).component_item_tbl IS NOT NULL AND p_revised_item_type_tbl(i).component_item_tbl.COUNT > 0) THEN
4525:
4526: -- If BOM already commoned create component in all commoned orgs
4527: INV_EBI_UTIL.debug_line('STEP 30: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_bom_orgs '||
4528: 'REVISED ITEM NAME: '|| l_revised_item_tbl(l_revised_item_tbl_count).revised_item_name ||
4529: 'ORG CODE: '|| l_revised_item_tbl(l_revised_item_tbl_count).organization_code);
4530: process_common_bom_orgs(
4531: p_assembly_item_name => l_revised_item_tbl(l_revised_item_tbl_count).revised_item_name,

Line 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);

4533: p_alternate_bom_code => l_revised_item_tbl(l_revised_item_tbl_count).alternate_bom_code,
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:

Line 4545: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items '||

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
4544: --If context org is child org and components does not exist,item assignment should be done
4545: INV_EBI_UTIL.debug_line('STEP 50: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items '||
4546: ' ORG ID: '|| l_organization_id || ' COMP ITEM NAME: '|| p_revised_item_type_tbl(i).component_item_tbl(j).component_item_name);
4547: process_assign_items(
4548: p_organization_id => l_organization_id,
4549: p_item_name => p_revised_item_type_tbl(i).component_item_tbl(j).component_item_name,

Line 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);

4550: x_return_status => x_out.output_status.return_status ,
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:

Line 4639: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_existing_component_attr '|| ' ORG ID: '|| l_organization_id ||

4635: l_rev_component_tbl(l_rev_component_tbl_count).transaction_type := p_revised_item_type_tbl(i).component_item_tbl(j).transaction_type;
4636: l_rev_component_tbl(l_rev_component_tbl_count).row_identifier := p_revised_item_type_tbl(i).component_item_tbl(j).row_identifier ;
4637: IF l_rev_component_tbl(l_rev_component_tbl_count).acd_type IN (l_acd_update,l_acd_delete)
4638: THEN
4639: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_existing_component_attr '|| ' ORG ID: '|| l_organization_id ||
4640: ' REVISED ITEM NAME: '|| l_rev_component_tbl(l_rev_component_tbl_count).revised_item_name ||
4641: ' COMPONENT ITEM NAME: '|| l_rev_component_tbl(l_rev_component_tbl_count).component_item_name);
4642:
4643: get_existing_component_attr(

Line 4656: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_existing_component_attr');

4652: ,x_old_effectivity_date => l_old_effectivity_date
4653: ,x_old_op_sequence_num => l_old_op_sequence_num
4654: ,x_old_fm_end_item_unit => l_old_fm_end_item_unit
4655: );
4656: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_existing_component_attr');
4657: IF l_rev_component_tbl(l_rev_component_tbl_count).old_effectivity_date IS NULL
4658: THEN
4659: l_rev_component_tbl(l_rev_component_tbl_count).old_effectivity_date := l_old_effectivity_date;
4660: END IF;

Line 4722: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items FOR SUBSTITUTE COMPONENTS '||

4718: IF(p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl IS NOT NULL AND p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl.COUNT > 0) THEN
4719: FOR k IN 1..p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl.COUNT
4720: LOOP
4721: --If context org is child org and components does not exist,item assignment should be done
4722: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_assign_items FOR SUBSTITUTE COMPONENTS '||
4723: ' COMPONENT NAME : '||p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).substitute_component_name);
4724: process_assign_items(
4725: p_organization_id => l_organization_id,
4726: p_item_name => p_revised_item_type_tbl(i).component_item_tbl(j).substitute_component_tbl(k).substitute_component_name,

Line 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);

4727: x_return_status => x_out.output_status.return_status ,
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:

Line 4834: INV_EBI_UTIL.debug_line('STEP 130: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.process_eco STATUS: '|| x_out.output_status.return_status);

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
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;

Line 4850: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_eco ';

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 ';
4853: END IF;
4854: END process_eco;

Line 4852: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_eco ';

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 ';
4853: END IF;
4854: END process_eco;
4855:
4856: /************************************************************************************

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

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(
4891: p_item_number => p_assembly_item_name,
4892: p_organization_code => p_organization_code,

Line 4920: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_common_bom '||' ORG CODE : '|| p_organization_code ||

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 ||
4922: ' COMMON ORG CODE : '|| p_structure_header.common_organization_code);
4923: process_common_bom(
4924: p_organization_code => p_organization_code

Line 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);

4929: ,x_return_status => x_out.output_status.return_status
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;

Line 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);

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
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;

Line 5037: x_out.output_status.msg_data := x_out.output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ';

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 ';
5040: END IF;
5041: END process_structure_header;

Line 5039: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ';

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 ';
5040: END IF;
5041: END process_structure_header;
5042:
5043: /************************************************************************************

Line 5437: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.get_eco');

5433: WHERE
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:

Line 5946: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda');

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');
5947: get_change_order_uda(
5948: p_change_id => p_change_id,
5949: x_change_uda => l_eco_change_order_obj.change_order_uda,
5950: x_return_status => x_return_status,

Line 5954: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_change_order_uda STATUS: '||x_return_status);

5950: x_return_status => x_return_status,
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:

Line 5961: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda');

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
5961: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda');
5962: get_structure_header_uda(
5963: p_assembly_item_id => l_revised_item_tbl(i).revised_item_id,
5964: p_alternate_bom_code => l_revised_item_tbl(i).alternate_bom_code,
5965: p_organization_id => l_eco_change_order_obj.organization_id,

Line 5971: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_structure_header_uda STATUS: '||x_return_status);

5967: x_return_status => x_return_status,
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:

Line 5978: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda');

5974: END IF;
5975:
5976: --Bug 7240247
5977: FOR j IN 1..l_revised_item_tbl(i).component_item_tbl.COUNT LOOP
5978: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda');
5979: get_component_item_uda(
5980: p_eco_name => l_eco_change_order_obj.eco_name,
5981: p_revised_item_id => l_revised_item_tbl(i).revised_item_id,
5982: p_component_item_name => l_revised_item_tbl(i).component_item_tbl(j).component_item_name,

Line 5990: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.get_component_item_uda STATUS: '||x_return_status);

5986: x_return_status => x_return_status,
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;

Line 5999: INV_EBI_UTIL.debug_line('STEP 80: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco');

5995:
5996: END LOOP;
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

Line 6013: x_msg_data := x_msg_data ||' -> at INV_EBI_CHANGE_ORDER_HELPER.get_eco';

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 ';
6016: END IF;
6017: END get_eco;

Line 6015: x_msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_HELPER.get_eco ';

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 ';
6016: END IF;
6017: END get_eco;
6018:
6019: /************************************************************************************

Line 6039: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.filter_ecos_based_on_org');

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:
6043: IF p_org_codes IS NOT NULL THEN

Line 6075: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.filter_ecos_based_on_org STATUS: '|| x_return_status);

6071: INV_EBI_UTIL.debug_line('STEP 30: CHANGE ID NUMBER IS '|| x_eco_tbl(i).change_id);
6072: INV_EBI_UTIL.debug_line('STEP 40: LAST UPDATE STATUS '|| x_eco_tbl(i).last_update_status);
6073: END LOOP;
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';

Line 6116: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco');

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();
6120:

Line 6158: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';

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;
6162:

Line 6192: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';

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;
6196:

Line 6260: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';

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;
6264: x_eco_tbl := l_eco_output_tbl;

Line 6272: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco STATUS: '|| x_return_status);

6268: INV_EBI_UTIL.debug_line('STEP 40: CHANGE ID NUMBER '|| x_eco_tbl(i).CHANGE_ID);
6269: INV_EBI_UTIL.debug_line('STEP 50: LAST UPDATE STATUS '|| x_eco_tbl(i).LAST_UPDATE_STATUS);
6270: END LOOP;
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';

Line 6276: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.parse_and_get_eco';

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: /************************************************************************************
6280: -- API name : get_eco_list

Line 6338: INV_EBI_UTIL.debug_line('Step 10: START CALLING INV_EBI_CHANGE_ORDER_HELPER.GET_ECO_LIST');

6334: l_ind_val NUMBER :=1;
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');

Line 6453: INV_EBI_UTIL.debug_line('STEP 200: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco_list STATUS: '||x_return_status);

6449: LOOP
6450: INV_EBI_UTIL.debug_line('STEP 190: CHANGE ID '|| x_eco(i).CHANGE_ID || ' LAST UPDATE STATUS ' ||x_eco(i).LAST_UPDATE_STATUS);
6451: END LOOP;
6452: END IF;
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;

Line 6458: x_msg_data := SQLERRM ||' at INV_EBI_CHANGE_ORDER_HELPER.get_eco_list';

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;
6462:

Line 6465: END INV_EBI_CHANGE_ORDER_HELPER;

6461: END IF;
6462:
6463: END get_eco_list;
6464:
6465: END INV_EBI_CHANGE_ORDER_HELPER;