[Home] [Help]
16: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
17: l_main_item_obj inv_ebi_item_main_obj;
18: l_output_status inv_ebi_output_status;
19: BEGIN
20: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
21: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
22: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes');
23: IF(p_revised_item.item IS NOT NULL ) THEN
24: x_item := p_revised_item.item;
22: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes');
23: IF(p_revised_item.item IS NOT NULL ) THEN
24: x_item := p_revised_item.item;
25: ELSE
26: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,
27: fnd_api.g_miss_char,fnd_api.g_miss_num,
28: fnd_api.g_miss_char,fnd_api.g_miss_num,
29: fnd_api.g_miss_num,fnd_api.g_miss_char,
30: fnd_api.g_miss_char,fnd_api.g_miss_char,
23: IF(p_revised_item.item IS NOT NULL ) THEN
24: x_item := p_revised_item.item;
25: ELSE
26: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,
27: fnd_api.g_miss_char,fnd_api.g_miss_num,
28: fnd_api.g_miss_char,fnd_api.g_miss_num,
29: fnd_api.g_miss_num,fnd_api.g_miss_char,
30: fnd_api.g_miss_char,fnd_api.g_miss_char,
31: fnd_api.g_miss_char,fnd_api.g_miss_char,
24: x_item := p_revised_item.item;
25: ELSE
26: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,
27: fnd_api.g_miss_char,fnd_api.g_miss_num,
28: fnd_api.g_miss_char,fnd_api.g_miss_num,
29: fnd_api.g_miss_num,fnd_api.g_miss_char,
30: fnd_api.g_miss_char,fnd_api.g_miss_char,
31: fnd_api.g_miss_char,fnd_api.g_miss_char,
32: fnd_api.g_miss_char,fnd_api.g_miss_num,
25: ELSE
26: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,
27: fnd_api.g_miss_char,fnd_api.g_miss_num,
28: fnd_api.g_miss_char,fnd_api.g_miss_num,
29: fnd_api.g_miss_num,fnd_api.g_miss_char,
30: fnd_api.g_miss_char,fnd_api.g_miss_char,
31: fnd_api.g_miss_char,fnd_api.g_miss_char,
32: fnd_api.g_miss_char,fnd_api.g_miss_num,
33: fnd_api.g_miss_num,fnd_api.g_miss_char,
26: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,
27: fnd_api.g_miss_char,fnd_api.g_miss_num,
28: fnd_api.g_miss_char,fnd_api.g_miss_num,
29: fnd_api.g_miss_num,fnd_api.g_miss_char,
30: fnd_api.g_miss_char,fnd_api.g_miss_char,
31: fnd_api.g_miss_char,fnd_api.g_miss_char,
32: fnd_api.g_miss_char,fnd_api.g_miss_num,
33: fnd_api.g_miss_num,fnd_api.g_miss_char,
34: fnd_api.g_miss_char,fnd_api.g_miss_num,
27: fnd_api.g_miss_char,fnd_api.g_miss_num,
28: fnd_api.g_miss_char,fnd_api.g_miss_num,
29: fnd_api.g_miss_num,fnd_api.g_miss_char,
30: fnd_api.g_miss_char,fnd_api.g_miss_char,
31: fnd_api.g_miss_char,fnd_api.g_miss_char,
32: fnd_api.g_miss_char,fnd_api.g_miss_num,
33: fnd_api.g_miss_num,fnd_api.g_miss_char,
34: fnd_api.g_miss_char,fnd_api.g_miss_num,
35: fnd_api.g_miss_num,fnd_api.g_miss_char,
28: fnd_api.g_miss_char,fnd_api.g_miss_num,
29: fnd_api.g_miss_num,fnd_api.g_miss_char,
30: fnd_api.g_miss_char,fnd_api.g_miss_char,
31: fnd_api.g_miss_char,fnd_api.g_miss_char,
32: fnd_api.g_miss_char,fnd_api.g_miss_num,
33: fnd_api.g_miss_num,fnd_api.g_miss_char,
34: fnd_api.g_miss_char,fnd_api.g_miss_num,
35: fnd_api.g_miss_num,fnd_api.g_miss_char,
36: fnd_api.g_miss_char,fnd_api.g_miss_char,
29: fnd_api.g_miss_num,fnd_api.g_miss_char,
30: fnd_api.g_miss_char,fnd_api.g_miss_char,
31: fnd_api.g_miss_char,fnd_api.g_miss_char,
32: fnd_api.g_miss_char,fnd_api.g_miss_num,
33: fnd_api.g_miss_num,fnd_api.g_miss_char,
34: fnd_api.g_miss_char,fnd_api.g_miss_num,
35: fnd_api.g_miss_num,fnd_api.g_miss_char,
36: fnd_api.g_miss_char,fnd_api.g_miss_char,
37: fnd_api.g_miss_char,fnd_api.g_miss_char,
30: fnd_api.g_miss_char,fnd_api.g_miss_char,
31: fnd_api.g_miss_char,fnd_api.g_miss_char,
32: fnd_api.g_miss_char,fnd_api.g_miss_num,
33: fnd_api.g_miss_num,fnd_api.g_miss_char,
34: fnd_api.g_miss_char,fnd_api.g_miss_num,
35: fnd_api.g_miss_num,fnd_api.g_miss_char,
36: fnd_api.g_miss_char,fnd_api.g_miss_char,
37: fnd_api.g_miss_char,fnd_api.g_miss_char,
38: fnd_api.g_miss_char,fnd_api.g_miss_char,
31: fnd_api.g_miss_char,fnd_api.g_miss_char,
32: fnd_api.g_miss_char,fnd_api.g_miss_num,
33: fnd_api.g_miss_num,fnd_api.g_miss_char,
34: fnd_api.g_miss_char,fnd_api.g_miss_num,
35: fnd_api.g_miss_num,fnd_api.g_miss_char,
36: fnd_api.g_miss_char,fnd_api.g_miss_char,
37: fnd_api.g_miss_char,fnd_api.g_miss_char,
38: fnd_api.g_miss_char,fnd_api.g_miss_char,
39: fnd_api.g_miss_char,fnd_api.g_miss_char,
32: fnd_api.g_miss_char,fnd_api.g_miss_num,
33: fnd_api.g_miss_num,fnd_api.g_miss_char,
34: fnd_api.g_miss_char,fnd_api.g_miss_num,
35: fnd_api.g_miss_num,fnd_api.g_miss_char,
36: fnd_api.g_miss_char,fnd_api.g_miss_char,
37: fnd_api.g_miss_char,fnd_api.g_miss_char,
38: fnd_api.g_miss_char,fnd_api.g_miss_char,
39: fnd_api.g_miss_char,fnd_api.g_miss_char,
40: fnd_api.g_miss_char,fnd_api.g_miss_char,
33: fnd_api.g_miss_num,fnd_api.g_miss_char,
34: fnd_api.g_miss_char,fnd_api.g_miss_num,
35: fnd_api.g_miss_num,fnd_api.g_miss_char,
36: fnd_api.g_miss_char,fnd_api.g_miss_char,
37: fnd_api.g_miss_char,fnd_api.g_miss_char,
38: fnd_api.g_miss_char,fnd_api.g_miss_char,
39: fnd_api.g_miss_char,fnd_api.g_miss_char,
40: fnd_api.g_miss_char,fnd_api.g_miss_char,
41: fnd_api.g_miss_char,fnd_api.g_miss_char,
34: fnd_api.g_miss_char,fnd_api.g_miss_num,
35: fnd_api.g_miss_num,fnd_api.g_miss_char,
36: fnd_api.g_miss_char,fnd_api.g_miss_char,
37: fnd_api.g_miss_char,fnd_api.g_miss_char,
38: fnd_api.g_miss_char,fnd_api.g_miss_char,
39: fnd_api.g_miss_char,fnd_api.g_miss_char,
40: fnd_api.g_miss_char,fnd_api.g_miss_char,
41: fnd_api.g_miss_char,fnd_api.g_miss_char,
42: fnd_api.g_miss_char,fnd_api.g_miss_char,
35: fnd_api.g_miss_num,fnd_api.g_miss_char,
36: fnd_api.g_miss_char,fnd_api.g_miss_char,
37: fnd_api.g_miss_char,fnd_api.g_miss_char,
38: fnd_api.g_miss_char,fnd_api.g_miss_char,
39: fnd_api.g_miss_char,fnd_api.g_miss_char,
40: fnd_api.g_miss_char,fnd_api.g_miss_char,
41: fnd_api.g_miss_char,fnd_api.g_miss_char,
42: fnd_api.g_miss_char,fnd_api.g_miss_char,
43: fnd_api.g_miss_char,fnd_api.g_miss_char,
36: fnd_api.g_miss_char,fnd_api.g_miss_char,
37: fnd_api.g_miss_char,fnd_api.g_miss_char,
38: fnd_api.g_miss_char,fnd_api.g_miss_char,
39: fnd_api.g_miss_char,fnd_api.g_miss_char,
40: fnd_api.g_miss_char,fnd_api.g_miss_char,
41: fnd_api.g_miss_char,fnd_api.g_miss_char,
42: fnd_api.g_miss_char,fnd_api.g_miss_char,
43: fnd_api.g_miss_char,fnd_api.g_miss_char,
44: fnd_api.g_miss_char,fnd_api.g_miss_char,
37: fnd_api.g_miss_char,fnd_api.g_miss_char,
38: fnd_api.g_miss_char,fnd_api.g_miss_char,
39: fnd_api.g_miss_char,fnd_api.g_miss_char,
40: fnd_api.g_miss_char,fnd_api.g_miss_char,
41: fnd_api.g_miss_char,fnd_api.g_miss_char,
42: fnd_api.g_miss_char,fnd_api.g_miss_char,
43: fnd_api.g_miss_char,fnd_api.g_miss_char,
44: fnd_api.g_miss_char,fnd_api.g_miss_char,
45: fnd_api.g_miss_char,fnd_api.g_miss_char,
38: fnd_api.g_miss_char,fnd_api.g_miss_char,
39: fnd_api.g_miss_char,fnd_api.g_miss_char,
40: fnd_api.g_miss_char,fnd_api.g_miss_char,
41: fnd_api.g_miss_char,fnd_api.g_miss_char,
42: fnd_api.g_miss_char,fnd_api.g_miss_char,
43: fnd_api.g_miss_char,fnd_api.g_miss_char,
44: fnd_api.g_miss_char,fnd_api.g_miss_char,
45: fnd_api.g_miss_char,fnd_api.g_miss_char,
46: fnd_api.g_miss_char,fnd_api.g_miss_char,
39: fnd_api.g_miss_char,fnd_api.g_miss_char,
40: fnd_api.g_miss_char,fnd_api.g_miss_char,
41: fnd_api.g_miss_char,fnd_api.g_miss_char,
42: fnd_api.g_miss_char,fnd_api.g_miss_char,
43: fnd_api.g_miss_char,fnd_api.g_miss_char,
44: fnd_api.g_miss_char,fnd_api.g_miss_char,
45: fnd_api.g_miss_char,fnd_api.g_miss_char,
46: fnd_api.g_miss_char,fnd_api.g_miss_char,
47: fnd_api.g_miss_char,fnd_api.g_miss_char,
40: fnd_api.g_miss_char,fnd_api.g_miss_char,
41: fnd_api.g_miss_char,fnd_api.g_miss_char,
42: fnd_api.g_miss_char,fnd_api.g_miss_char,
43: fnd_api.g_miss_char,fnd_api.g_miss_char,
44: fnd_api.g_miss_char,fnd_api.g_miss_char,
45: fnd_api.g_miss_char,fnd_api.g_miss_char,
46: fnd_api.g_miss_char,fnd_api.g_miss_char,
47: fnd_api.g_miss_char,fnd_api.g_miss_char,
48: fnd_api.g_miss_char,fnd_api.g_miss_date,
41: fnd_api.g_miss_char,fnd_api.g_miss_char,
42: fnd_api.g_miss_char,fnd_api.g_miss_char,
43: fnd_api.g_miss_char,fnd_api.g_miss_char,
44: fnd_api.g_miss_char,fnd_api.g_miss_char,
45: fnd_api.g_miss_char,fnd_api.g_miss_char,
46: fnd_api.g_miss_char,fnd_api.g_miss_char,
47: fnd_api.g_miss_char,fnd_api.g_miss_char,
48: fnd_api.g_miss_char,fnd_api.g_miss_date,
49: fnd_api.g_miss_date,fnd_api.g_miss_date,
42: fnd_api.g_miss_char,fnd_api.g_miss_char,
43: fnd_api.g_miss_char,fnd_api.g_miss_char,
44: fnd_api.g_miss_char,fnd_api.g_miss_char,
45: fnd_api.g_miss_char,fnd_api.g_miss_char,
46: fnd_api.g_miss_char,fnd_api.g_miss_char,
47: fnd_api.g_miss_char,fnd_api.g_miss_char,
48: fnd_api.g_miss_char,fnd_api.g_miss_date,
49: fnd_api.g_miss_date,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,fnd_api.g_miss_date,
43: fnd_api.g_miss_char,fnd_api.g_miss_char,
44: fnd_api.g_miss_char,fnd_api.g_miss_char,
45: fnd_api.g_miss_char,fnd_api.g_miss_char,
46: fnd_api.g_miss_char,fnd_api.g_miss_char,
47: fnd_api.g_miss_char,fnd_api.g_miss_char,
48: fnd_api.g_miss_char,fnd_api.g_miss_date,
49: fnd_api.g_miss_date,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,fnd_api.g_miss_date,
51: fnd_api.g_miss_num,fnd_api.g_miss_num,
44: fnd_api.g_miss_char,fnd_api.g_miss_char,
45: fnd_api.g_miss_char,fnd_api.g_miss_char,
46: fnd_api.g_miss_char,fnd_api.g_miss_char,
47: fnd_api.g_miss_char,fnd_api.g_miss_char,
48: fnd_api.g_miss_char,fnd_api.g_miss_date,
49: fnd_api.g_miss_date,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,fnd_api.g_miss_date,
51: fnd_api.g_miss_num,fnd_api.g_miss_num,
52: fnd_api.g_miss_num,fnd_api.g_miss_num,
45: fnd_api.g_miss_char,fnd_api.g_miss_char,
46: fnd_api.g_miss_char,fnd_api.g_miss_char,
47: fnd_api.g_miss_char,fnd_api.g_miss_char,
48: fnd_api.g_miss_char,fnd_api.g_miss_date,
49: fnd_api.g_miss_date,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,fnd_api.g_miss_date,
51: fnd_api.g_miss_num,fnd_api.g_miss_num,
52: fnd_api.g_miss_num,fnd_api.g_miss_num,
53: fnd_api.g_miss_num,fnd_api.g_miss_date,
46: fnd_api.g_miss_char,fnd_api.g_miss_char,
47: fnd_api.g_miss_char,fnd_api.g_miss_char,
48: fnd_api.g_miss_char,fnd_api.g_miss_date,
49: fnd_api.g_miss_date,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,fnd_api.g_miss_date,
51: fnd_api.g_miss_num,fnd_api.g_miss_num,
52: fnd_api.g_miss_num,fnd_api.g_miss_num,
53: fnd_api.g_miss_num,fnd_api.g_miss_date,
54: fnd_api.g_miss_num,fnd_api.g_miss_char,
47: fnd_api.g_miss_char,fnd_api.g_miss_char,
48: fnd_api.g_miss_char,fnd_api.g_miss_date,
49: fnd_api.g_miss_date,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,fnd_api.g_miss_date,
51: fnd_api.g_miss_num,fnd_api.g_miss_num,
52: fnd_api.g_miss_num,fnd_api.g_miss_num,
53: fnd_api.g_miss_num,fnd_api.g_miss_date,
54: fnd_api.g_miss_num,fnd_api.g_miss_char,
55: fnd_api.g_miss_num,fnd_api.g_miss_char,
48: fnd_api.g_miss_char,fnd_api.g_miss_date,
49: fnd_api.g_miss_date,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,fnd_api.g_miss_date,
51: fnd_api.g_miss_num,fnd_api.g_miss_num,
52: fnd_api.g_miss_num,fnd_api.g_miss_num,
53: fnd_api.g_miss_num,fnd_api.g_miss_date,
54: fnd_api.g_miss_num,fnd_api.g_miss_char,
55: fnd_api.g_miss_num,fnd_api.g_miss_char,
56: fnd_api.g_miss_num,fnd_api.g_miss_char,
49: fnd_api.g_miss_date,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,fnd_api.g_miss_date,
51: fnd_api.g_miss_num,fnd_api.g_miss_num,
52: fnd_api.g_miss_num,fnd_api.g_miss_num,
53: fnd_api.g_miss_num,fnd_api.g_miss_date,
54: fnd_api.g_miss_num,fnd_api.g_miss_char,
55: fnd_api.g_miss_num,fnd_api.g_miss_char,
56: fnd_api.g_miss_num,fnd_api.g_miss_char,
57: fnd_api.g_miss_char,fnd_api.g_miss_char,
50: fnd_api.g_miss_num,fnd_api.g_miss_date,
51: fnd_api.g_miss_num,fnd_api.g_miss_num,
52: fnd_api.g_miss_num,fnd_api.g_miss_num,
53: fnd_api.g_miss_num,fnd_api.g_miss_date,
54: fnd_api.g_miss_num,fnd_api.g_miss_char,
55: fnd_api.g_miss_num,fnd_api.g_miss_char,
56: fnd_api.g_miss_num,fnd_api.g_miss_char,
57: fnd_api.g_miss_char,fnd_api.g_miss_char,
58: fnd_api.g_miss_date,fnd_api.g_miss_num,
51: fnd_api.g_miss_num,fnd_api.g_miss_num,
52: fnd_api.g_miss_num,fnd_api.g_miss_num,
53: fnd_api.g_miss_num,fnd_api.g_miss_date,
54: fnd_api.g_miss_num,fnd_api.g_miss_char,
55: fnd_api.g_miss_num,fnd_api.g_miss_char,
56: fnd_api.g_miss_num,fnd_api.g_miss_char,
57: fnd_api.g_miss_char,fnd_api.g_miss_char,
58: fnd_api.g_miss_date,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_num,
52: fnd_api.g_miss_num,fnd_api.g_miss_num,
53: fnd_api.g_miss_num,fnd_api.g_miss_date,
54: fnd_api.g_miss_num,fnd_api.g_miss_char,
55: fnd_api.g_miss_num,fnd_api.g_miss_char,
56: fnd_api.g_miss_num,fnd_api.g_miss_char,
57: fnd_api.g_miss_char,fnd_api.g_miss_char,
58: fnd_api.g_miss_date,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_num,
60: fnd_api.g_miss_char,fnd_api.g_miss_char,
53: fnd_api.g_miss_num,fnd_api.g_miss_date,
54: fnd_api.g_miss_num,fnd_api.g_miss_char,
55: fnd_api.g_miss_num,fnd_api.g_miss_char,
56: fnd_api.g_miss_num,fnd_api.g_miss_char,
57: fnd_api.g_miss_char,fnd_api.g_miss_char,
58: fnd_api.g_miss_date,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_num,
60: fnd_api.g_miss_char,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
54: fnd_api.g_miss_num,fnd_api.g_miss_char,
55: fnd_api.g_miss_num,fnd_api.g_miss_char,
56: fnd_api.g_miss_num,fnd_api.g_miss_char,
57: fnd_api.g_miss_char,fnd_api.g_miss_char,
58: fnd_api.g_miss_date,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_num,
60: fnd_api.g_miss_char,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_num,fnd_api.g_miss_char,
55: fnd_api.g_miss_num,fnd_api.g_miss_char,
56: fnd_api.g_miss_num,fnd_api.g_miss_char,
57: fnd_api.g_miss_char,fnd_api.g_miss_char,
58: fnd_api.g_miss_date,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_num,
60: fnd_api.g_miss_char,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_num,fnd_api.g_miss_char,
63: fnd_api.g_miss_char,fnd_api.g_miss_char,
56: fnd_api.g_miss_num,fnd_api.g_miss_char,
57: fnd_api.g_miss_char,fnd_api.g_miss_char,
58: fnd_api.g_miss_date,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_num,
60: fnd_api.g_miss_char,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_num,fnd_api.g_miss_char,
63: fnd_api.g_miss_char,fnd_api.g_miss_char,
64: fnd_api.g_miss_char,fnd_api.g_miss_char,
57: fnd_api.g_miss_char,fnd_api.g_miss_char,
58: fnd_api.g_miss_date,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_num,
60: fnd_api.g_miss_char,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_num,fnd_api.g_miss_char,
63: fnd_api.g_miss_char,fnd_api.g_miss_char,
64: fnd_api.g_miss_char,fnd_api.g_miss_char,
65: fnd_api.g_miss_char,fnd_api.g_miss_char,
58: fnd_api.g_miss_date,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_num,
60: fnd_api.g_miss_char,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_num,fnd_api.g_miss_char,
63: fnd_api.g_miss_char,fnd_api.g_miss_char,
64: fnd_api.g_miss_char,fnd_api.g_miss_char,
65: fnd_api.g_miss_char,fnd_api.g_miss_char,
66: fnd_api.g_miss_char,fnd_api.g_miss_char,
59: fnd_api.g_miss_char,fnd_api.g_miss_num,
60: fnd_api.g_miss_char,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_num,fnd_api.g_miss_char,
63: fnd_api.g_miss_char,fnd_api.g_miss_char,
64: fnd_api.g_miss_char,fnd_api.g_miss_char,
65: fnd_api.g_miss_char,fnd_api.g_miss_char,
66: fnd_api.g_miss_char,fnd_api.g_miss_char,
67: fnd_api.g_miss_char,
60: fnd_api.g_miss_char,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_num,fnd_api.g_miss_char,
63: fnd_api.g_miss_char,fnd_api.g_miss_char,
64: fnd_api.g_miss_char,fnd_api.g_miss_char,
65: fnd_api.g_miss_char,fnd_api.g_miss_char,
66: fnd_api.g_miss_char,fnd_api.g_miss_char,
67: fnd_api.g_miss_char,
68: NULL -- Added for Bug 13370136 -- ramukher
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_num,fnd_api.g_miss_char,
63: fnd_api.g_miss_char,fnd_api.g_miss_char,
64: fnd_api.g_miss_char,fnd_api.g_miss_char,
65: fnd_api.g_miss_char,fnd_api.g_miss_char,
66: fnd_api.g_miss_char,fnd_api.g_miss_char,
67: fnd_api.g_miss_char,
68: NULL -- Added for Bug 13370136 -- ramukher
69: );
62: fnd_api.g_miss_num,fnd_api.g_miss_char,
63: fnd_api.g_miss_char,fnd_api.g_miss_char,
64: fnd_api.g_miss_char,fnd_api.g_miss_char,
65: fnd_api.g_miss_char,fnd_api.g_miss_char,
66: fnd_api.g_miss_char,fnd_api.g_miss_char,
67: fnd_api.g_miss_char,
68: NULL -- Added for Bug 13370136 -- ramukher
69: );
70: x_item:=inv_ebi_Item_Obj(l_main_item_obj,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
63: fnd_api.g_miss_char,fnd_api.g_miss_char,
64: fnd_api.g_miss_char,fnd_api.g_miss_char,
65: fnd_api.g_miss_char,fnd_api.g_miss_char,
66: fnd_api.g_miss_char,fnd_api.g_miss_char,
67: fnd_api.g_miss_char,
68: NULL -- Added for Bug 13370136 -- ramukher
69: );
70: x_item:=inv_ebi_Item_Obj(l_main_item_obj,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
71: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
69: );
70: x_item:=inv_ebi_Item_Obj(l_main_item_obj,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
71: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
72: END IF;
73: IF(x_item.main_obj_type.item_number IS NULL OR x_item.main_obj_type.item_number = fnd_api.g_miss_char )THEN
74: x_item.main_obj_type.item_number := p_revised_item.revised_item_name;
75: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| x_item.main_obj_type.item_number);
76: END IF;
77: IF(x_item.main_obj_type.organization_id IS NULL OR x_item.main_obj_type.organization_id = fnd_api.g_miss_num )THEN
73: IF(x_item.main_obj_type.item_number IS NULL OR x_item.main_obj_type.item_number = fnd_api.g_miss_char )THEN
74: x_item.main_obj_type.item_number := p_revised_item.revised_item_name;
75: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| x_item.main_obj_type.item_number);
76: END IF;
77: IF(x_item.main_obj_type.organization_id IS NULL OR x_item.main_obj_type.organization_id = fnd_api.g_miss_num )THEN
78: IF((p_change_order_obj.organization_id IS NULL
79: OR p_change_order_obj.organization_id = fnd_api.g_miss_num)
80: AND (p_change_order_obj.organization_code IS NOT NULL
81: OR p_change_order_obj.organization_code <> fnd_api.g_miss_char)) THEN
75: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER: '|| x_item.main_obj_type.item_number);
76: END IF;
77: IF(x_item.main_obj_type.organization_id IS NULL OR x_item.main_obj_type.organization_id = fnd_api.g_miss_num )THEN
78: IF((p_change_order_obj.organization_id IS NULL
79: OR p_change_order_obj.organization_id = fnd_api.g_miss_num)
80: AND (p_change_order_obj.organization_code IS NOT NULL
81: OR p_change_order_obj.organization_code <> fnd_api.g_miss_char)) THEN
82: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
83: l_pk_col_name_val_pairs.EXTEND(1);
77: IF(x_item.main_obj_type.organization_id IS NULL OR x_item.main_obj_type.organization_id = fnd_api.g_miss_num )THEN
78: IF((p_change_order_obj.organization_id IS NULL
79: OR p_change_order_obj.organization_id = fnd_api.g_miss_num)
80: AND (p_change_order_obj.organization_code IS NOT NULL
81: OR p_change_order_obj.organization_code <> fnd_api.g_miss_char)) THEN
82: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
83: l_pk_col_name_val_pairs.EXTEND(1);
84: l_pk_col_name_val_pairs(1).name := 'organization_code';
85: l_pk_col_name_val_pairs(1).value := p_change_order_obj.organization_code;
92: IF (x_item.main_obj_type.organization_id IS NULL) THEN
93: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
94: FND_MESSAGE.set_token('COL_VALUE', p_change_order_obj.organization_code);
95: FND_MSG_PUB.add;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98: ELSE
99: x_item.main_obj_type.organization_id := p_change_order_obj.organization_id;
100: END IF;
99: x_item.main_obj_type.organization_id := p_change_order_obj.organization_id;
100: END IF;
101: END IF;
102:
103: IF(x_item.main_obj_type.init_msg_list IS NULL OR x_item.main_obj_type.init_msg_list = fnd_api.g_miss_char )THEN
104: x_item.main_obj_type.init_msg_list := FND_API.G_TRUE;
105: END IF;
106: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes STATUS: '||x_out.output_status.return_status);
107: EXCEPTION
100: END IF;
101: END IF;
102:
103: IF(x_item.main_obj_type.init_msg_list IS NULL OR x_item.main_obj_type.init_msg_list = fnd_api.g_miss_char )THEN
104: x_item.main_obj_type.init_msg_list := FND_API.G_TRUE;
105: END IF;
106: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes STATUS: '||x_out.output_status.return_status);
107: EXCEPTION
108: WHEN FND_API.g_exc_error THEN
104: x_item.main_obj_type.init_msg_list := FND_API.G_TRUE;
105: END IF;
106: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes STATUS: '||x_out.output_status.return_status);
107: EXCEPTION
108: WHEN FND_API.g_exc_error THEN
109: x_out.output_status.return_status := FND_API.g_ret_sts_error;
110: IF(x_out.output_status.msg_data IS NULL) THEN
111: FND_MSG_PUB.count_and_get(
112: p_encoded => FND_API.g_false
105: END IF;
106: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes STATUS: '||x_out.output_status.return_status);
107: EXCEPTION
108: WHEN FND_API.g_exc_error THEN
109: x_out.output_status.return_status := FND_API.g_ret_sts_error;
110: IF(x_out.output_status.msg_data IS NULL) THEN
111: FND_MSG_PUB.count_and_get(
112: p_encoded => FND_API.g_false
113: ,p_count => x_out.output_status.msg_count
108: WHEN FND_API.g_exc_error THEN
109: x_out.output_status.return_status := FND_API.g_ret_sts_error;
110: IF(x_out.output_status.msg_data IS NULL) THEN
111: FND_MSG_PUB.count_and_get(
112: p_encoded => FND_API.g_false
113: ,p_count => x_out.output_status.msg_count
114: ,p_data => x_out.output_status.msg_data
115: );
116: END IF;
114: ,p_data => x_out.output_status.msg_data
115: );
116: END IF;
117: WHEN OTHERS THEN
118: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
119: IF (x_out.output_status.msg_data IS NOT NULL) THEN
120: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes ';
121: ELSE
122: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes ';
146:
147: BEGIN
148: SAVEPOINT inv_ebi_engg_item_save_pnt;
149: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_mfg');
150: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
151: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
152:
153: IF(p_item.main_obj_type.inventory_item_id IS NULL OR
154: p_item.main_obj_type.inventory_item_id = fnd_api.g_miss_num) THEN
150: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
151: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
152:
153: IF(p_item.main_obj_type.inventory_item_id IS NULL OR
154: p_item.main_obj_type.inventory_item_id = fnd_api.g_miss_num) THEN
155:
156: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
157: l_pk_col_name_val_pairs.EXTEND(2);
158: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';
169: IF (l_inventory_item_id IS NULL ) THEN
170: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
171: FND_MESSAGE.set_token('COL_VALUE', p_item.main_obj_type.item_number);
172: FND_MSG_PUB.add;
173: RAISE FND_API.g_exc_unexpected_error;
174: END IF;
175: ELSE
176: l_inventory_item_id := p_item.main_obj_type.inventory_item_id;
177:
177:
178: END IF;
179:
180: IF((l_inventory_item_id IS NOT NULL
181: AND l_inventory_item_id <> fnd_api.g_miss_num)
182: AND (p_item.main_obj_type.organization_id IS NOT NULL
183: AND p_item.main_obj_type.organization_id <> fnd_api.g_miss_num)) THEN
184:
185: SELECT approval_status INTO l_item_approval_status
179:
180: IF((l_inventory_item_id IS NOT NULL
181: AND l_inventory_item_id <> fnd_api.g_miss_num)
182: AND (p_item.main_obj_type.organization_id IS NOT NULL
183: AND p_item.main_obj_type.organization_id <> fnd_api.g_miss_num)) THEN
184:
185: SELECT approval_status INTO l_item_approval_status
186: FROM mtl_system_items_b
187: WHERE inventory_item_id = l_inventory_item_id
196:
197: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NOT_APPROVED');
198: FND_MESSAGE.set_token('ITEM', p_item.main_obj_type.item_number);
199: FND_MSG_PUB.add;
200: RAISE FND_API.g_exc_error;
201:
202: ELSE --End of Bug 8299853
203:
204: l_is_engineering_item := INV_EBI_ITEM_HELPER.is_engineering_item(
205: p_organization_id => p_item.main_obj_type.organization_id
206: ,p_item_number => p_item.main_obj_type.item_number
207: );
208:
209: IF(l_is_engineering_item = FND_API.g_true
210: AND p_item.bom_obj_type.eng_item_flag = 'N'
211: ) THEN
212:
213: --Transfer Engg Item to Manufacturing
212:
213: --Transfer Engg Item to Manufacturing
214: -- If alt_bom_code is null then transfer all boms,if not transfer only that particular bom
215:
216: IF(p_alt_bom_designator IS NULL OR p_alt_bom_designator = fnd_api.g_miss_char ) THEN
217: l_designator_option := 1;
218: l_alt_bom_designator := NULL;
219: ELSE
220: l_designator_option := 3;
265: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING ENG_BOM_RTG_TRANSFER_PKG.eng_bom_rtg_transfer');
266: END IF;
267: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_mfg STATUS: '|| x_out.output_status.return_status);
268: EXCEPTION
269: WHEN FND_API.g_exc_unexpected_error THEN
270: ROLLBACK TO inv_ebi_engg_item_save_pnt;
271: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
272: IF(x_out.output_status.msg_data IS NULL) THEN
273: FND_MSG_PUB.count_and_get(
267: INV_EBI_UTIL.debug_line('STEP 60: END INSIDE INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_mfg STATUS: '|| x_out.output_status.return_status);
268: EXCEPTION
269: WHEN FND_API.g_exc_unexpected_error THEN
270: ROLLBACK TO inv_ebi_engg_item_save_pnt;
271: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
272: IF(x_out.output_status.msg_data IS NULL) THEN
273: FND_MSG_PUB.count_and_get(
274: p_encoded => FND_API.g_false
275: ,p_count => x_out.output_status.msg_count
270: ROLLBACK TO inv_ebi_engg_item_save_pnt;
271: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
272: IF(x_out.output_status.msg_data IS NULL) THEN
273: FND_MSG_PUB.count_and_get(
274: p_encoded => FND_API.g_false
275: ,p_count => x_out.output_status.msg_count
276: ,p_data => x_out.output_status.msg_data
277: );
278: END IF;
276: ,p_data => x_out.output_status.msg_data
277: );
278: END IF;
279: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number:' || p_item.main_obj_type.item_number || ' -> Org Code: ' || p_item.main_obj_type.organization_code;
280: WHEN FND_API.g_exc_error THEN
281: ROLLBACK TO inv_ebi_engg_item_save_pnt;
282: x_out.output_status.return_status := FND_API.g_ret_sts_error;
283: IF(x_out.output_status.msg_data IS NULL) THEN
284: FND_MSG_PUB.count_and_get(
278: END IF;
279: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number:' || p_item.main_obj_type.item_number || ' -> Org Code: ' || p_item.main_obj_type.organization_code;
280: WHEN FND_API.g_exc_error THEN
281: ROLLBACK TO inv_ebi_engg_item_save_pnt;
282: x_out.output_status.return_status := FND_API.g_ret_sts_error;
283: IF(x_out.output_status.msg_data IS NULL) THEN
284: FND_MSG_PUB.count_and_get(
285: p_encoded => FND_API.g_false
286: ,p_count => x_out.output_status.msg_count
281: ROLLBACK TO inv_ebi_engg_item_save_pnt;
282: x_out.output_status.return_status := FND_API.g_ret_sts_error;
283: IF(x_out.output_status.msg_data IS NULL) THEN
284: FND_MSG_PUB.count_and_get(
285: p_encoded => FND_API.g_false
286: ,p_count => x_out.output_status.msg_count
287: ,p_data => x_out.output_status.msg_data
288: );
289: END IF;
289: END IF;
290: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number:' || p_item.main_obj_type.item_number || ' -> Org Code: ' || p_item.main_obj_type.organization_code;
291: WHEN OTHERS THEN
292: ROLLBACK TO inv_ebi_engg_item_save_pnt;
293: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
294: IF (x_out.output_status.msg_data IS NOT NULL) THEN
295: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_manufacturing ';
296: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> Item Number:' || p_item.main_obj_type.item_number || ' -> Org Code: ' || p_item.main_obj_type.organization_code;
297: ELSE
319: l_is_component_item_exists VARCHAR2(3);
320: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
321: l_output_status inv_ebi_output_status;
322: BEGIN
323: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
324: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
325: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.validate_component_items ORG CODE: '|| p_organization_code);
326: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
327: l_pk_col_name_val_pairs.EXTEND(1);
335: IF (l_organization_id IS NULL) THEN
336: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
337: FND_MESSAGE.set_token('COL_VALUE',p_organization_code);
338: FND_MSG_PUB.add;
339: RAISE FND_API.g_exc_error;
340: END IF;
341: l_is_master_org := INV_EBI_UTIL.is_master_org(l_organization_id);
342: IF(p_component_item_tbl IS NOT NULL AND p_component_item_tbl.COUNT > 0) THEN
343: FOR i IN 1.. p_component_item_tbl.COUNT LOOP
347: l_is_component_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
348: p_organization_id => l_organization_id
349: ,p_item_number => l_component_item_name
350: );
351: IF(l_is_master_org = fnd_api.g_true AND l_is_component_item_exists = fnd_api.g_false) THEN
352: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
353: FND_MESSAGE.set_token('COMP_ITEM', l_component_item_name);
354: FND_MSG_PUB.add;
355: RAISE FND_API.g_exc_error;
351: IF(l_is_master_org = fnd_api.g_true AND l_is_component_item_exists = fnd_api.g_false) THEN
352: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
353: FND_MESSAGE.set_token('COMP_ITEM', l_component_item_name);
354: FND_MSG_PUB.add;
355: RAISE FND_API.g_exc_error;
356: END IF;
357: END IF;
358: END LOOP;
359: END IF;
358: END LOOP;
359: END IF;
360: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.validate_component_items STATUS: '|| x_out.output_status.return_status);
361: EXCEPTION
362: WHEN FND_API.g_exc_error THEN
363: x_out.output_status.return_status := FND_API.g_ret_sts_error;
364: IF(x_out.output_status.msg_data IS NULL) THEN
365: FND_MSG_PUB.count_and_get(
366: p_encoded => FND_API.g_false
359: END IF;
360: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.validate_component_items STATUS: '|| x_out.output_status.return_status);
361: EXCEPTION
362: WHEN FND_API.g_exc_error THEN
363: x_out.output_status.return_status := FND_API.g_ret_sts_error;
364: IF(x_out.output_status.msg_data IS NULL) THEN
365: FND_MSG_PUB.count_and_get(
366: p_encoded => FND_API.g_false
367: ,p_count => x_out.output_status.msg_count
362: WHEN FND_API.g_exc_error THEN
363: x_out.output_status.return_status := FND_API.g_ret_sts_error;
364: IF(x_out.output_status.msg_data IS NULL) THEN
365: FND_MSG_PUB.count_and_get(
366: p_encoded => FND_API.g_false
367: ,p_count => x_out.output_status.msg_count
368: ,p_data => x_out.output_status.msg_data
369: );
370: END IF;
368: ,p_data => x_out.output_status.msg_data
369: );
370: END IF;
371: WHEN OTHERS THEN
372: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
373: IF (x_out.output_status.msg_data IS NOT NULL) THEN
374: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.validate_component_items ';
375: ELSE
376: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.validate_component_items ';
398: BEGIN
399: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.validate_item');
400: INV_EBI_UTIL.debug_line('STEP 20: ITEM NUMBER TO VALIDATE : '|| p_item.main_obj_type.item_number ||
401: ' ORGANIZATION ID : '|| p_item.main_obj_type.organization_id);
402: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
403: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
404: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
405: FND_MSG_PUB.initialize;
406:
406:
407: IF(INV_EBI_ITEM_HELPER.is_item_exists (
408: p_organization_id => p_item.main_obj_type.organization_id
409: ,p_item_number => p_item.main_obj_type.item_number
410: ) = FND_API.g_false ) THEN
411:
412: /* Start of Bug 8299853 FDD says if CO item is new ICC is configured for NIR then
413: we should error out */
414:
411:
412: /* Start of Bug 8299853 FDD says if CO item is new ICC is configured for NIR then
413: we should error out */
414:
415: IF(p_item.main_obj_type.organization_id IS NOT NULL AND p_item.main_obj_type.organization_id <> FND_API.g_miss_num) THEN
416:
417: IF(INV_EBI_UTIL.is_master_org(
418: p_organization_id => p_item.main_obj_type.organization_id
419: ) = FND_API.g_true) THEN
415: IF(p_item.main_obj_type.organization_id IS NOT NULL AND p_item.main_obj_type.organization_id <> FND_API.g_miss_num) THEN
416:
417: IF(INV_EBI_UTIL.is_master_org(
418: p_organization_id => p_item.main_obj_type.organization_id
419: ) = FND_API.g_true) THEN
420:
421: IF( p_item.main_obj_type.item_catalog_group_id IS NOT NULL
422: AND p_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
423:
418: p_organization_id => p_item.main_obj_type.organization_id
419: ) = FND_API.g_true) THEN
420:
421: IF( p_item.main_obj_type.item_catalog_group_id IS NOT NULL
422: AND p_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
423:
424: IF(INV_EBI_ITEM_HELPER.is_new_item_request_reqd(
425: p_item_catalog_group_id => p_item.main_obj_type.item_catalog_group_id
426: ) = FND_API.g_true AND
422: AND p_item.main_obj_type.item_catalog_group_id <> fnd_api.g_miss_num) THEN
423:
424: IF(INV_EBI_ITEM_HELPER.is_new_item_request_reqd(
425: p_item_catalog_group_id => p_item.main_obj_type.item_catalog_group_id
426: ) = FND_API.g_true AND
427: p_item.bom_obj_type.eng_item_flag = 'N') THEN
428:
429: FND_MESSAGE.set_name('INV','INV_EBI_ICC_CONFG_FOR_NIR');
430:
428:
429: FND_MESSAGE.set_name('INV','INV_EBI_ICC_CONFG_FOR_NIR');
430:
431: IF ( p_item.main_obj_type.item_catalog_group_code IS NULL
432: OR p_item.main_obj_type.item_catalog_group_code = fnd_api.g_miss_char)THEN
433:
434: l_pk_col_name_val_pairs.EXTEND(1);
435: l_pk_col_name_val_pairs(1).name := 'item_catalog_group_id';
436: l_pk_col_name_val_pairs(1).value := p_item.main_obj_type.item_catalog_group_id;
448:
449: FND_MESSAGE.set_token('ITEM',p_item.main_obj_type.item_number);
450: FND_MESSAGE.set_token('ITEM_CATALOG', l_item_catalog_group_code);
451: FND_MSG_PUB.add;
452: RAISE FND_API.g_exc_error;
453:
454: END IF;
455: END IF;
456: END IF;
461: ,p_item => p_item
462: ,x_out => l_item_output
463: ) ;
464: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_ITEM_PUB.validate_item RETURN STATUS: '|| l_item_output.output_status.return_status);
465: IF(l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN
466: RAISE FND_API.g_exc_unexpected_error;
467: END IF;
468: END IF;
469: INV_EBI_UTIL.debug_line('STEP 50: END CALLING INV_EBI_CHANGE_ORDER_PUB.validate_item RETURN STATUS: '|| x_out.output_status.return_status);
462: ,x_out => l_item_output
463: ) ;
464: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_ITEM_PUB.validate_item RETURN STATUS: '|| l_item_output.output_status.return_status);
465: IF(l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN
466: RAISE FND_API.g_exc_unexpected_error;
467: END IF;
468: END IF;
469: INV_EBI_UTIL.debug_line('STEP 50: END CALLING INV_EBI_CHANGE_ORDER_PUB.validate_item RETURN STATUS: '|| x_out.output_status.return_status);
470: EXCEPTION
467: END IF;
468: END IF;
469: INV_EBI_UTIL.debug_line('STEP 50: END CALLING INV_EBI_CHANGE_ORDER_PUB.validate_item RETURN STATUS: '|| x_out.output_status.return_status);
470: EXCEPTION
471: WHEN FND_API.g_exc_unexpected_error THEN
472: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
473: IF(x_out.output_status.msg_data IS NULL) THEN
474: FND_MSG_PUB.count_and_get(
475: p_encoded => FND_API.g_false
468: END IF;
469: INV_EBI_UTIL.debug_line('STEP 50: END CALLING INV_EBI_CHANGE_ORDER_PUB.validate_item RETURN STATUS: '|| x_out.output_status.return_status);
470: EXCEPTION
471: WHEN FND_API.g_exc_unexpected_error THEN
472: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
473: IF(x_out.output_status.msg_data IS NULL) THEN
474: FND_MSG_PUB.count_and_get(
475: p_encoded => FND_API.g_false
476: ,p_count => x_out.output_status.msg_count
471: WHEN FND_API.g_exc_unexpected_error THEN
472: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
473: IF(x_out.output_status.msg_data IS NULL) THEN
474: FND_MSG_PUB.count_and_get(
475: p_encoded => FND_API.g_false
476: ,p_count => x_out.output_status.msg_count
477: ,p_data => x_out.output_status.msg_data
478: );
479: END IF;
476: ,p_count => x_out.output_status.msg_count
477: ,p_data => x_out.output_status.msg_data
478: );
479: END IF;
480: WHEN FND_API.g_exc_error THEN
481: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
482: IF(x_out.output_status.msg_data IS NULL) THEN
483: FND_MSG_PUB.count_and_get(
484: p_encoded => FND_API.g_false
477: ,p_data => x_out.output_status.msg_data
478: );
479: END IF;
480: WHEN FND_API.g_exc_error THEN
481: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
482: IF(x_out.output_status.msg_data IS NULL) THEN
483: FND_MSG_PUB.count_and_get(
484: p_encoded => FND_API.g_false
485: ,p_count => x_out.output_status.msg_count
480: WHEN FND_API.g_exc_error THEN
481: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
482: IF(x_out.output_status.msg_data IS NULL) THEN
483: FND_MSG_PUB.count_and_get(
484: p_encoded => FND_API.g_false
485: ,p_count => x_out.output_status.msg_count
486: ,p_data => x_out.output_status.msg_data
487: );
488: END IF;
486: ,p_data => x_out.output_status.msg_data
487: );
488: END IF;
489: WHEN OTHERS THEN
490: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
491: IF (x_out.output_status.msg_data IS NOT NULL) THEN
492: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.validate_eco ';
493: ELSE
494: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.validate_eco ';
608: l_msg_data VARCHAR2(1000);
609: l_eco_change_order_obj inv_ebi_change_order_obj;
610: l_revised_item_tbl inv_ebi_revised_item_tbl;
611: l_revised_item_obj inv_ebi_revised_item_obj;
612: l_only_status_info VARCHAR2(1):= fnd_api.g_false;
613: BEGIN
614: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.get_eco ');
615: INV_EBI_UTIL.debug_line('STEP 20: CHANGE ID: '|| p_change_id);
616: x_return_status := FND_API.G_RET_STS_SUCCESS;
612: l_only_status_info VARCHAR2(1):= fnd_api.g_false;
613: BEGIN
614: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.get_eco ');
615: INV_EBI_UTIL.debug_line('STEP 20: CHANGE ID: '|| p_change_id);
616: x_return_status := FND_API.G_RET_STS_SUCCESS;
617: l_eco_change_order_obj := inv_ebi_change_order_obj(
618: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
619: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
620: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
647: ,x_msg_count => l_msg_count
648: ,x_msg_data => l_msg_data
649: );
650: INV_EBI_UTIL.debug_line('STEP 40: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco RETURN STATUS: '||l_return_status);
651: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
652: RAISE FND_API.g_exc_unexpected_error;
653: END IF;
654: IF p_name_val_list.name_value_table IS NOT NULL THEN
655: FOR i in p_name_val_list.name_value_table.FIRST..p_name_val_list.name_value_table.LAST LOOP
648: ,x_msg_data => l_msg_data
649: );
650: INV_EBI_UTIL.debug_line('STEP 40: END CALLING INV_EBI_CHANGE_ORDER_HELPER.get_eco RETURN STATUS: '||l_return_status);
651: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
652: RAISE FND_API.g_exc_unexpected_error;
653: END IF;
654: IF p_name_val_list.name_value_table IS NOT NULL THEN
655: FOR i in p_name_val_list.name_value_table.FIRST..p_name_val_list.name_value_table.LAST LOOP
656: IF UPPER(p_name_val_list.name_value_table(i).param_name) = G_ONLY_STATUS_INFO THEN
657: l_only_status_info := p_name_val_list.name_value_table(i).param_value;
658: END IF;
659: END LOOP;
660: END IF;
661: IF l_only_status_info = fnd_api.g_true THEN
662: l_eco_change_order_obj.status_name := l_eco_obj.eco_change_order_type.status_name;
663: l_eco_change_order_obj.implementation_date := l_eco_obj.eco_change_order_type.implementation_date;
664: l_eco_change_order_obj.cancellation_date := l_eco_obj.eco_change_order_type.cancellation_date;
665: FOR i in l_eco_obj.eco_revised_item_type.FIRST..l_eco_obj.eco_revised_item_type.LAST LOOP
673: x_eco_obj := l_eco_obj;
674: END IF;
675: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_PUB.get_eco STATUS: '|| x_return_status);
676: EXCEPTION
677: WHEN FND_API.g_exc_unexpected_error THEN
678: x_return_status := FND_API.g_ret_sts_error;
679: IF(x_msg_data IS NULL) THEN
680: FND_MSG_PUB.count_and_get(
681: p_encoded => FND_API.g_false
674: END IF;
675: INV_EBI_UTIL.debug_line('STEP 50: END INSIDE INV_EBI_CHANGE_ORDER_PUB.get_eco STATUS: '|| x_return_status);
676: EXCEPTION
677: WHEN FND_API.g_exc_unexpected_error THEN
678: x_return_status := FND_API.g_ret_sts_error;
679: IF(x_msg_data IS NULL) THEN
680: FND_MSG_PUB.count_and_get(
681: p_encoded => FND_API.g_false
682: ,p_count => x_msg_count
677: WHEN FND_API.g_exc_unexpected_error THEN
678: x_return_status := FND_API.g_ret_sts_error;
679: IF(x_msg_data IS NULL) THEN
680: FND_MSG_PUB.count_and_get(
681: p_encoded => FND_API.g_false
682: ,p_count => x_msg_count
683: ,p_data => x_msg_data
684: );
685: END IF;
683: ,p_data => x_msg_data
684: );
685: END IF;
686: WHEN OTHERS THEN
687: x_return_status := FND_API.g_ret_sts_error;
688: IF (x_msg_data IS NOT NULL) THEN
689: x_msg_data := x_msg_data ||' -> at inv_ebi_change_order_pub.get_eco';
690: ELSE
691: x_msg_data := SQLERRM||' at inv_ebi_change_order_pub.get_eco ';
1057: THEN
1058: INV_EBI_UTIL.set_apps_context(l_name_val_list.name_value_table);
1059: END IF;
1060: */
1061: x_return_status := FND_API.G_RET_STS_SUCCESS;
1062: l_mult_org_chg_id_tbl := inv_ebi_change_id_obj_tbl();
1063: l_mult_org_chg_id_temp := inv_ebi_change_id_obj_tbl();
1064:
1065: INV_EBI_ITEM_HELPER.set_server_time_zone;
1081: END IF;
1082: END LOOP;
1083: END IF;
1084:
1085: IF(l_get_multiorg_change IS NULL OR l_get_multiorg_change = fnd_api.g_miss_char) THEN
1086: l_get_multiorg_change := INV_EBI_FLAGS.G_INCLUDE_MULTIORG_CHANGE;
1087: END IF;
1088: --End of Bug 13874263
1089: INV_EBI_UTIL.debug_line( 'Get Multi Org Change Details ' || l_get_multiorg_change);
1087: END IF;
1088: --End of Bug 13874263
1089: INV_EBI_UTIL.debug_line( 'Get Multi Org Change Details ' || l_get_multiorg_change);
1090:
1091: IF(l_get_multiorg_change = FND_API.G_TRUE) THEN -- added if condition for bug 13874263
1092: IF p_change_lst IS NOT NULL AND p_change_lst.COUNT > 0 THEN
1093: FOR i in 1..p_change_lst.COUNT LOOP
1094: OPEN c_get_multi_org_chg_id(p_change_lst(i).change_id);
1095: FETCH c_get_multi_org_chg_id BULK COLLECT INTO l_mult_org_chg_id_temp;
1125: ,x_return_status => l_return_status
1126: ,x_msg_count => l_count
1127: ,x_msg_data => l_msg_data
1128: );
1129: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1130: x_return_status := FND_API.g_ret_sts_error;
1131: l_part_msgtxt := ' Change Id: '|| p_change_lst(l_cnt_cid).change_id||' Err Msg: '||l_msg_data ;
1132: IF (x_msg_data IS NOT NULL) THEN
1133: IF (LENGTH(x_msg_data||' , '||l_part_msgtxt) < 31000) THEN
1126: ,x_msg_count => l_count
1127: ,x_msg_data => l_msg_data
1128: );
1129: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1130: x_return_status := FND_API.g_ret_sts_error;
1131: l_part_msgtxt := ' Change Id: '|| p_change_lst(l_cnt_cid).change_id||' Err Msg: '||l_msg_data ;
1132: IF (x_msg_data IS NOT NULL) THEN
1133: IF (LENGTH(x_msg_data||' , '||l_part_msgtxt) < 31000) THEN
1134: x_msg_data :=x_msg_data||' , '||l_part_msgtxt;
1161: INV_EBI_UTIL.wrapup;
1162:
1163: EXCEPTION
1164: WHEN OTHERS THEN
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: IF (x_msg_data IS NOT NULL) THEN
1167: x_msg_data := x_msg_data ||' -> at INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr';
1168: ELSE
1169: x_msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr ';
1179: -- Added this API for Bug 8397083
1180: ************************************************************************************/
1181:
1182: PROCEDURE process_change_order_items(
1183: p_commit IN VARCHAR2 := FND_API.g_false
1184: ,p_eco_obj IN inv_ebi_eco_obj
1185: ,p_update_item_tbl IN inv_ebi_item_attr_tbl
1186: ,x_update_item_tbl OUT NOCOPY inv_ebi_item_attr_tbl
1187: ,x_out OUT NOCOPY inv_ebi_item_output_obj
1217: BEGIN
1218: SAVEPOINT inv_ebi_chg_items_save_pnt;
1219: FND_MSG_PUB.initialize;
1220:
1221: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1222: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
1223:
1224: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_items');
1225:
1244: ,x_out => l_item_output_obj
1245: );
1246: INV_EBI_UTIL.debug_line('STEP 30: END CALLING INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes STATUS: '|| l_item_output_obj.output_status.return_status);
1247:
1248: IF (l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1249: x_out.output_status.msg_data := l_item_output_obj.output_status.msg_data;
1250: x_out.output_status.msg_count := l_item_output_obj.output_status.msg_count;
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252:
1247:
1248: IF (l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1249: x_out.output_status.msg_data := l_item_output_obj.output_status.msg_data;
1250: x_out.output_status.msg_count := l_item_output_obj.output_status.msg_count;
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252:
1253: END IF;
1254: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_CHANGE_ORDER_PUB.populate_item_ids');
1255:
1258: ,x_out => l_item_output_obj
1259: ,x_item => l_eco_obj.eco_revised_item_type(i).item
1260: );
1261: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.populate_item_ids STATUS: '|| l_item_output_obj.output_status.return_status);
1262: IF (l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1263: x_out.output_status.msg_data := l_item_output_obj.output_status.msg_data;
1264: x_out.output_status.msg_count := l_item_output_obj.output_status.msg_count;
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: END IF;
1261: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.populate_item_ids STATUS: '|| l_item_output_obj.output_status.return_status);
1262: IF (l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1263: x_out.output_status.msg_data := l_item_output_obj.output_status.msg_data;
1264: x_out.output_status.msg_count := l_item_output_obj.output_status.msg_count;
1265: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1266: END IF;
1267:
1268:
1269: INV_EBI_UTIL.debug_line('STEP 60: START CALLING INV_EBI_CHANGE_ORDER_PUB.validate_item');
1274: );
1275:
1276: INV_EBI_UTIL.debug_line('STEP 70: END CALLING INV_EBI_CHANGE_ORDER_PUB.validate_item STATUS: '|| l_item_output_obj.output_status.return_status);
1277:
1278: IF (l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1279: x_out.output_status.msg_data := l_item_output_obj.output_status.msg_data;
1280: x_out.output_status.msg_count := l_item_output_obj.output_status.msg_count;
1281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1282: END IF;
1277:
1278: IF (l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1279: x_out.output_status.msg_data := l_item_output_obj.output_status.msg_data;
1280: x_out.output_status.msg_count := l_item_output_obj.output_status.msg_count;
1281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1282: END IF;
1283:
1284:
1285: l_eco_obj.eco_revised_item_type(i).item.NAME_VALUE_TBL := INV_EBI_NAME_VALUE_TBL();
1304:
1305: IF( INV_EBI_ITEM_HELPER.is_item_exists (
1306: p_organization_id => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.organization_id
1307: ,p_item_number => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.item_number
1308: ) = FND_API.g_false ) THEN
1309:
1310: /* Bug 7132835 After subsequent release of ecos in master org ,If Change order is released in Child Org
1311: then we should create initial rev,current rev of the item in master org through process_item API
1312: and incoming revision through process_eco API */
1312: and incoming revision through process_eco API */
1313:
1314: IF(INV_EBI_CHANGE_ORDER_HELPER.is_child_org (
1315: p_organization_id => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.organization_id
1316: ) = fnd_api.g_true) THEN
1317:
1318: l_master_org := INV_EBI_UTIL.get_master_organization(
1319: p_organization_id => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.organization_id
1320: );
1331: );
1332: INV_EBI_UTIL.debug_line('STEP 80: MASTER ORG: '|| l_master_org || 'INV ITEM ID: '||l_inventory_item_id || 'CURRENT REVISION: '|| l_current_revision);
1333: IF(l_current_revision = l_eco_obj.eco_revised_item_type(i).new_revised_item_revision ) THEN
1334:
1335: l_eco_obj.eco_revised_item_type(i).item.main_obj_type.revision_code := fnd_api.g_miss_char;
1336:
1337: ELSIF( l_current_revision <> l_eco_obj.eco_revised_item_type(i).new_revised_item_revision AND
1338: l_current_revision < l_eco_obj.eco_revised_item_type(i).new_revised_item_revision ) THEN
1339:
1351: --call Create New Production Item API .This will also process existing item information.
1352:
1353: INV_EBI_UTIL.debug_line('STEP 90: BEFORE CALLING INV_EBI_ITEM_HELPER.sync_item');
1354: INV_EBI_ITEM_HELPER.sync_item(
1355: p_commit => FND_API.g_false
1356: ,p_operation => INV_EBI_ITEM_PUB.g_otype_create
1357: ,p_item => l_eco_obj.eco_revised_item_type(i).item
1358: ,x_out => l_item_output_obj
1359: );
1361: INV_EBI_UTIL.debug_line('STEP 100: END CALLING INV_EBI_ITEM_HELPER.sync_item STATUS: '|| l_item_output_obj.output_status.return_status);
1362:
1363: l_item_count := l_item_count + 1;
1364:
1365: IF (l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1366: x_out.output_status.msg_data := l_item_output_obj.output_status.msg_data;
1367: x_out.output_status.msg_count := l_item_output_obj.output_status.msg_count;
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: END IF;
1364:
1365: IF (l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1366: x_out.output_status.msg_data := l_item_output_obj.output_status.msg_data;
1367: x_out.output_status.msg_count := l_item_output_obj.output_status.msg_count;
1368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1369: END IF;
1370:
1371: IF(l_revision_set = TRUE ) THEN
1372:
1425: );
1426:
1427: INV_EBI_UTIL.debug_line('STEP 140: AFTER CALLING transfer_engg_item_mfg STATUS: '||l_eco_output_obj.output_status.return_status);
1428:
1429: IF (l_eco_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1430: x_out.output_status.msg_data := l_eco_output_obj.output_status.msg_data;
1431: x_out.output_status.msg_count := l_eco_output_obj.output_status.msg_count;
1432: RAISE fnd_api.g_exc_unexpected_error;
1433: END IF;
1428:
1429: IF (l_eco_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1430: x_out.output_status.msg_data := l_eco_output_obj.output_status.msg_data;
1431: x_out.output_status.msg_count := l_eco_output_obj.output_status.msg_count;
1432: RAISE fnd_api.g_exc_unexpected_error;
1433: END IF;
1434:
1435: END IF;
1436: END LOOP;
1435: END IF;
1436: END LOOP;
1437: END IF;
1438: x_eco_obj := l_eco_obj;
1439: IF FND_API.to_boolean(p_commit) THEN
1440: COMMIT;
1441: END IF;
1442:
1443: INV_EBI_UTIL.debug_line('STEP 150: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_items STATUS: '|| x_out.output_status.return_status);
1443: INV_EBI_UTIL.debug_line('STEP 150: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_items STATUS: '|| x_out.output_status.return_status);
1444:
1445:
1446: EXCEPTION
1447: WHEN FND_API.g_exc_unexpected_error THEN
1448: ROLLBACK TO inv_ebi_chg_items_save_pnt;
1449:
1450: IF c_effectivity_date%ISOPEN THEN
1451: CLOSE c_effectivity_date;
1450: IF c_effectivity_date%ISOPEN THEN
1451: CLOSE c_effectivity_date;
1452: END IF;
1453:
1454: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1455:
1456: IF(x_out.output_status.msg_data IS NULL) THEN
1457:
1458: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
1462: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
1463:
1464: IF(x_out.output_status.msg_data IS NULL) THEN
1465: FND_MSG_PUB.count_and_get(
1466: p_encoded => FND_API.g_false
1467: ,p_count => x_out.output_status.msg_data
1468: ,p_data => x_out.output_status.msg_data
1469: );
1470: END IF;
1477: IF c_effectivity_date%ISOPEN THEN
1478: CLOSE c_effectivity_date;
1479: END IF;
1480:
1481: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1482: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
1483:
1484: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
1485: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
1500: -- This API is used to update chnage order items
1501: -- Added this API for Bug 8397083
1502: ************************************************************************************/
1503: PROCEDURE process_update_items(
1504: p_commit IN VARCHAR2 := FND_API.g_false
1505: ,p_update_item_tbl IN inv_ebi_item_attr_tbl
1506: ,x_out OUT NOCOPY inv_ebi_item_output_obj
1507: ) IS
1508:
1511: BEGIN
1512: SAVEPOINT inv_ebi_proc_upd_item_save_pnt;
1513: FND_MSG_PUB.initialize;
1514: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_update_items');
1515: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1516: x_out := inv_ebi_item_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL,NULL,NULL,NULL,NULL);
1517:
1518: IF(p_update_item_tbl IS NOT NULL AND p_update_item_tbl.COUNT > 0) THEN
1519:
1521:
1522: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_ITEM_HELPER.sync_item');
1523:
1524: INV_EBI_ITEM_HELPER.sync_item(
1525: p_commit => FND_API.g_false
1526: ,p_operation => INV_EBI_ITEM_PUB.g_otype_update
1527: ,p_item => p_update_item_tbl(i).item_obj
1528: ,x_out => x_out
1529: );
1527: ,p_item => p_update_item_tbl(i).item_obj
1528: ,x_out => x_out
1529: );
1530: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_HELPER.sync_item for item updation STATUS: '|| x_out.output_status.return_status);
1531: IF (x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
1532: x_out.item_number := p_update_item_tbl(i).item_obj.main_obj_type.item_number;
1533: x_out.organization_code := p_update_item_tbl(i).item_obj.main_obj_type.organization_code;
1534: RAISE fnd_api.g_exc_unexpected_error;
1535: END IF;
1530: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_ITEM_HELPER.sync_item for item updation STATUS: '|| x_out.output_status.return_status);
1531: IF (x_out.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
1532: x_out.item_number := p_update_item_tbl(i).item_obj.main_obj_type.item_number;
1533: x_out.organization_code := p_update_item_tbl(i).item_obj.main_obj_type.organization_code;
1534: RAISE fnd_api.g_exc_unexpected_error;
1535: END IF;
1536: END LOOP;
1537: END IF;
1538: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_update_items');
1536: END LOOP;
1537: END IF;
1538: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_update_items');
1539: EXCEPTION
1540: WHEN FND_API.g_exc_unexpected_error THEN
1541: ROLLBACK TO inv_ebi_proc_upd_item_save_pnt;
1542: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1543: IF(x_out.output_status.msg_data IS NULL) THEN
1544:
1538: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_update_items');
1539: EXCEPTION
1540: WHEN FND_API.g_exc_unexpected_error THEN
1541: ROLLBACK TO inv_ebi_proc_upd_item_save_pnt;
1542: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1543: IF(x_out.output_status.msg_data IS NULL) THEN
1544:
1545: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
1546:
1549: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
1550:
1551: IF(x_out.output_status.msg_data IS NULL) THEN
1552: FND_MSG_PUB.count_and_get(
1553: p_encoded => FND_API.g_false
1554: ,p_count => x_out.output_status.msg_count
1555: ,p_data => x_out.output_status.msg_data
1556: );
1557: END IF;
1559: END IF;
1560:
1561: WHEN OTHERS THEN
1562: ROLLBACK TO inv_ebi_proc_upd_item_save_pnt;
1563: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1564:
1565: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
1566:
1567: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
1582: -- This API is used create BOM
1583: -- Added this API for Bug 8397083
1584: ************************************************************************************/
1585: PROCEDURE process_bom(
1586: p_commit IN VARCHAR2 := FND_API.g_false
1587: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
1588: ,x_eco_obj_list OUT NOCOPY inv_ebi_eco_obj_tbl
1589: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1590: ) IS
1613: SAVEPOINT inv_ebi_process_bom_save_pnt;
1614:
1615: FND_MSG_PUB.initialize;
1616:
1617: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1618: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1619:
1620: l_common_assy_item_tbl := inv_ebi_revised_item_tbl();
1621: l_replicate_bom_tbl := inv_ebi_revised_item_tbl();
1633:
1634: l_eco_obj := p_eco_obj_list(i);
1635: x_eco_obj_list(i) := p_eco_obj_list(i);
1636:
1637: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1638:
1639: IF( l_eco_obj.eco_revised_item_type IS NOT NULL AND
1640: l_eco_obj.eco_revised_item_type.COUNT > 0) THEN
1641:
1640: l_eco_obj.eco_revised_item_type.COUNT > 0) THEN
1641:
1642: FOR j IN 1..l_eco_obj.eco_revised_item_type.COUNT LOOP
1643:
1644: l_common_bom_found := FND_API.g_false;
1645: l_replicate_bom_found := FND_API.g_false;
1646:
1647:
1648: IF(l_eco_obj.eco_revised_item_type(j).structure_header IS NOT NULL) THEN
1641:
1642: FOR j IN 1..l_eco_obj.eco_revised_item_type.COUNT LOOP
1643:
1644: l_common_bom_found := FND_API.g_false;
1645: l_replicate_bom_found := FND_API.g_false;
1646:
1647:
1648: IF(l_eco_obj.eco_revised_item_type(j).structure_header IS NOT NULL) THEN
1649: IF(l_eco_obj.eco_revised_item_type(j).structure_header.common_assembly_item_name IS NOT NULL
1646:
1647:
1648: IF(l_eco_obj.eco_revised_item_type(j).structure_header IS NOT NULL) THEN
1649: IF(l_eco_obj.eco_revised_item_type(j).structure_header.common_assembly_item_name IS NOT NULL
1650: AND l_eco_obj.eco_revised_item_type(j).structure_header.common_assembly_item_name <> fnd_api.g_miss_char
1651: AND l_eco_obj.eco_revised_item_type(j).structure_header.common_organization_code IS NOT NULL
1652: AND l_eco_obj.eco_revised_item_type(j).structure_header.common_organization_code <> fnd_api.g_miss_char
1653: ) THEN
1654: INV_EBI_UTIL.debug_line('STEP 20: Commoning Needed '||' ECO NAME: '|| l_eco_obj.eco_change_order_type.eco_name ||
1648: IF(l_eco_obj.eco_revised_item_type(j).structure_header IS NOT NULL) THEN
1649: IF(l_eco_obj.eco_revised_item_type(j).structure_header.common_assembly_item_name IS NOT NULL
1650: AND l_eco_obj.eco_revised_item_type(j).structure_header.common_assembly_item_name <> fnd_api.g_miss_char
1651: AND l_eco_obj.eco_revised_item_type(j).structure_header.common_organization_code IS NOT NULL
1652: AND l_eco_obj.eco_revised_item_type(j).structure_header.common_organization_code <> fnd_api.g_miss_char
1653: ) THEN
1654: INV_EBI_UTIL.debug_line('STEP 20: Commoning Needed '||' ECO NAME: '|| l_eco_obj.eco_change_order_type.eco_name ||
1655: 'ORG CODE : '|| l_eco_obj.eco_change_order_type.organization_code);
1656: l_common_assy_item_tbl.EXTEND(1);
1659: l_common_assy_item_cnt := l_common_assy_item_cnt+1;
1660: l_common_assy_item_tbl(l_common_assy_item_cnt) := l_eco_obj.eco_revised_item_type(j);
1661: l_common_org_tbl(l_common_assy_item_cnt) := l_eco_obj.eco_change_order_type.organization_code;
1662: l_common_eco_tbl(l_common_assy_item_cnt) := l_eco_obj.eco_change_order_type.eco_name;
1663: l_common_bom_found := fnd_api.g_true;
1664:
1665: END IF;
1666: END IF;
1667:
1668: IF(l_eco_obj.eco_revised_item_type(j).orignal_bom_reference IS NOT NULL) THEN
1669:
1670:
1671: IF( l_eco_obj.eco_revised_item_type(j).orignal_bom_reference.item_name IS NOT NULL
1672: AND l_eco_obj.eco_revised_item_type(j).orignal_bom_reference.item_name <> fnd_api.g_miss_char
1673: AND l_eco_obj.eco_revised_item_type(j).orignal_bom_reference.ORGANIZATION_CODE IS NOT NULL
1674: AND l_eco_obj.eco_revised_item_type(j).orignal_bom_reference.ORGANIZATION_CODE <> fnd_api.g_miss_char
1675: ) THEN
1676:
1670:
1671: IF( l_eco_obj.eco_revised_item_type(j).orignal_bom_reference.item_name IS NOT NULL
1672: AND l_eco_obj.eco_revised_item_type(j).orignal_bom_reference.item_name <> fnd_api.g_miss_char
1673: AND l_eco_obj.eco_revised_item_type(j).orignal_bom_reference.ORGANIZATION_CODE IS NOT NULL
1674: AND l_eco_obj.eco_revised_item_type(j).orignal_bom_reference.ORGANIZATION_CODE <> fnd_api.g_miss_char
1675: ) THEN
1676:
1677: l_is_bom_exists := INV_EBI_CHANGE_ORDER_HELPER.is_bom_exists(
1678: p_item_number => l_eco_obj.eco_revised_item_type(j).revised_item_name,
1679: p_organization_code => l_eco_obj.eco_change_order_type.organization_code,
1680: p_alternate_bom_code => l_eco_obj.eco_revised_item_type(j).alternate_bom_code
1681: );
1682:
1683: IF(l_is_bom_exists = FND_API.g_false) THEN
1684: INV_EBI_UTIL.debug_line('STEP 30: Replication Needed');
1685: l_replicate_bom_tbl.EXTEND(1);
1686: l_replicate_bom_org_tbl.EXTEND(1);
1687: l_replicate_bom_eco_tbl.EXTEND(1);
1697: ,x_revised_item_obj => l_eco_obj.eco_revised_item_type(j)
1698: ,x_out => l_out
1699: );
1700: INV_EBI_UTIL.debug_line('STEP 50: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.transform_replicate_bom_info STATUS: '|| l_out.output_status.return_status);
1701: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1702: x_out.change_notice := l_eco_obj.eco_change_order_type.eco_name;
1703: x_out.organization_code := l_eco_obj.eco_change_order_type.organization_code;
1704: x_out.output_status.msg_data := l_out.output_status.msg_data;
1705: x_out.output_status.msg_count := l_out.output_status.msg_count;
1702: x_out.change_notice := l_eco_obj.eco_change_order_type.eco_name;
1703: x_out.organization_code := l_eco_obj.eco_change_order_type.organization_code;
1704: x_out.output_status.msg_data := l_out.output_status.msg_data;
1705: x_out.output_status.msg_count := l_out.output_status.msg_count;
1706: RAISE FND_API.g_exc_unexpected_error;
1707: END IF;
1708:
1709: l_replicate_bom_tbl(l_replicate_bom_cnt) := l_eco_obj.eco_revised_item_type(j);
1710: l_replicate_bom_found := fnd_api.g_true;
1706: RAISE FND_API.g_exc_unexpected_error;
1707: END IF;
1708:
1709: l_replicate_bom_tbl(l_replicate_bom_cnt) := l_eco_obj.eco_revised_item_type(j);
1710: l_replicate_bom_found := fnd_api.g_true;
1711:
1712:
1713: END IF;
1714: END IF;
1713: END IF;
1714: END IF;
1715: END IF;
1716:
1717: IF( l_common_bom_found = FND_API.g_false
1718: AND l_replicate_bom_found = FND_API.g_false
1719: AND l_eco_obj.eco_revised_item_type(j).structure_header IS NOT NULL) THEN
1720:
1721: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ' ||
1714: END IF;
1715: END IF;
1716:
1717: IF( l_common_bom_found = FND_API.g_false
1718: AND l_replicate_bom_found = FND_API.g_false
1719: AND l_eco_obj.eco_revised_item_type(j).structure_header IS NOT NULL) THEN
1720:
1721: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ' ||
1722: ' FOR Normal BOM '||' REVISED ITEM NAME: '|| l_eco_obj.eco_revised_item_type(j).revised_item_name);
1720:
1721: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ' ||
1722: ' FOR Normal BOM '||' REVISED ITEM NAME: '|| l_eco_obj.eco_revised_item_type(j).revised_item_name);
1723: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(
1724: p_commit => FND_API.g_false
1725: ,p_organization_code => l_eco_obj.eco_change_order_type.organization_code
1726: ,p_assembly_item_name => l_eco_obj.eco_revised_item_type(j).revised_item_name
1727: ,p_alternate_bom_code => l_eco_obj.eco_revised_item_type(j).alternate_bom_code
1728: ,p_structure_header => l_eco_obj.eco_revised_item_type(j).structure_header
1730: ,p_name_val_list => inv_ebi_name_value_list(l_eco_obj.name_value_tbl)
1731: ,x_out => l_out
1732: );
1733: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header STATUS: '|| l_out.output_status.return_status);
1734: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1735: x_out.change_notice := l_eco_obj.eco_change_order_type.eco_name;
1736: x_out.organization_code := l_eco_obj.eco_change_order_type.organization_code;
1737: x_out.output_status.msg_data := l_out.output_status.msg_data;
1738: x_out.output_status.msg_count := l_out.output_status.msg_count;
1735: x_out.change_notice := l_eco_obj.eco_change_order_type.eco_name;
1736: x_out.organization_code := l_eco_obj.eco_change_order_type.organization_code;
1737: x_out.output_status.msg_data := l_out.output_status.msg_data;
1738: x_out.output_status.msg_count := l_out.output_status.msg_count;
1739: RAISE FND_API.g_exc_unexpected_error;
1740: END IF;
1741:
1742: END IF;
1743: END LOOP;
1761: ' REVISED ITEM NAME: '|| l_common_assy_item_tbl(l_common_assy_item_cnt).revised_item_name ||
1762: ' COMMON ORG CODE: '|| l_common_assy_item_tbl(l_common_assy_item_cnt).structure_header.common_organization_code ||
1763: ' COMMON ASSY ITEM NAME: '|| l_common_assy_item_tbl(l_common_assy_item_cnt).structure_header.common_assembly_item_name);
1764: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(
1765: p_commit => FND_API.g_false
1766: ,p_organization_code => l_common_org_tbl(l_common_assy_item_cnt)
1767: ,p_assembly_item_name => l_common_assy_item_tbl(l_common_assy_item_cnt).revised_item_name
1768: ,p_alternate_bom_code => l_common_assy_item_tbl(l_common_assy_item_cnt).alternate_bom_code
1769: ,p_structure_header => l_common_assy_item_tbl(l_common_assy_item_cnt).structure_header
1772: ,x_out => l_out
1773: );
1774: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header '
1775: || 'FOR COMMON BOM STATUS: '|| l_out.output_status.return_status);
1776: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1777: x_out.change_notice := l_common_eco_tbl(l_common_assy_item_cnt);
1778: x_out.organization_code := l_common_org_tbl(l_common_assy_item_cnt);
1779: x_out.output_status.msg_data := l_out.output_status.msg_data;
1780: x_out.output_status.msg_count := l_out.output_status.msg_count;
1778: x_out.organization_code := l_common_org_tbl(l_common_assy_item_cnt);
1779: x_out.output_status.msg_data := l_out.output_status.msg_data;
1780: x_out.output_status.msg_count := l_out.output_status.msg_count;
1781:
1782: RAISE FND_API.g_exc_unexpected_error;
1783: END IF;
1784: END LOOP;
1785: END IF;
1786:
1816: ' FOR REPLICATE BOM STATUS: '|| l_out.output_status.return_status);
1817:
1818: x_eco_obj_list(l_eco_idx).eco_revised_item_type(l_item_idx) := l_replicate_bom_item_obj;
1819:
1820: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1821:
1822: x_out.change_notice := l_replicate_bom_eco_tbl(l_replicate_bom_cnt);
1823: x_out.organization_code := l_replicate_bom_org_tbl(l_replicate_bom_cnt);
1824: x_out.output_status.msg_data := l_out.output_status.msg_data;
1824: x_out.output_status.msg_data := l_out.output_status.msg_data;
1825: x_out.output_status.msg_count := l_out.output_status.msg_count;
1826:
1827:
1828: RAISE FND_API.g_exc_unexpected_error;
1829: END IF;
1830:
1831: IF(l_replicate_bom_tbl(l_replicate_bom_cnt).structure_header IS NOT NULL) THEN
1832: INV_EBI_UTIL.debug_line('STEP 120: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header ' ||
1833: ' FOR REPLICATE BOM '||' REVISED ITEM NAME: '|| l_replicate_bom_tbl(l_replicate_bom_cnt).revised_item_name ||
1834: ' COMMON ASSY ITEM NAME: '|| l_replicate_bom_tbl(l_replicate_bom_cnt).structure_header.common_assembly_item_name ||
1835: ' COMMON ORG CODE: '|| l_replicate_bom_tbl(l_replicate_bom_cnt).structure_header.common_organization_code);
1836: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(
1837: p_commit => FND_API.g_false
1838: ,p_organization_code => l_replicate_bom_org_tbl(l_replicate_bom_cnt)
1839: ,p_assembly_item_name => l_replicate_bom_tbl(l_replicate_bom_cnt).revised_item_name
1840: ,p_alternate_bom_code => l_replicate_bom_tbl(l_replicate_bom_cnt).alternate_bom_code
1841: ,p_structure_header => l_replicate_bom_tbl(l_replicate_bom_cnt).structure_header
1845: );
1846:
1847: INV_EBI_UTIL.debug_line('STEP 130: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header STATUS: '|| l_out.output_status.return_status);
1848:
1849: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1850:
1851: x_out.change_notice := l_replicate_bom_eco_tbl(l_replicate_bom_cnt);
1852: x_out.organization_code := l_replicate_bom_org_tbl(l_replicate_bom_cnt);
1853: x_out.output_status.msg_data := l_out.output_status.msg_data;
1852: x_out.organization_code := l_replicate_bom_org_tbl(l_replicate_bom_cnt);
1853: x_out.output_status.msg_data := l_out.output_status.msg_data;
1854: x_out.output_status.msg_count := l_out.output_status.msg_count;
1855:
1856: RAISE FND_API.g_exc_unexpected_error;
1857: END IF;
1858: END IF;
1859: END LOOP;
1860: END IF;
1858: END IF;
1859: END LOOP;
1860: END IF;
1861: INV_EBI_UTIL.debug_line('STEP 140: END OF INV_EBI_CHANGE_ORDER_PUB.process_bom STATUS: '|| x_out.output_status.return_status);
1862: IF FND_API.to_boolean(p_commit) THEN
1863: COMMIT;
1864: END IF;
1865:
1866: EXCEPTION
1864: END IF;
1865:
1866: EXCEPTION
1867:
1868: WHEN FND_API.g_exc_unexpected_error THEN
1869: ROLLBACK TO inv_ebi_process_bom_save_pnt;
1870: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1871:
1872: IF(x_out.output_status.msg_data IS NULL) THEN
1866: EXCEPTION
1867:
1868: WHEN FND_API.g_exc_unexpected_error THEN
1869: ROLLBACK TO inv_ebi_process_bom_save_pnt;
1870: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1871:
1872: IF(x_out.output_status.msg_data IS NULL) THEN
1873:
1874: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
1878: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
1879:
1880: IF(x_out.output_status.msg_data IS NULL) THEN
1881: FND_MSG_PUB.count_and_get(
1882: p_encoded => FND_API.g_false
1883: ,p_count => x_out.output_status.msg_count
1884: ,p_data => x_out.output_status.msg_data
1885: );
1886: END IF;
1889: END IF;
1890:
1891: WHEN OTHERS THEN
1892: ROLLBACK TO inv_ebi_process_bom_save_pnt;
1893: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1894:
1895: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
1896:
1897: IF (x_out.output_status.error_table IS NOT NULL AND
1916: -- Changed this API for Bug 8397083
1917: ************************************************************************************/
1918:
1919: PROCEDURE process_change_order(
1920: p_commit IN VARCHAR2 := FND_API.g_false
1921: ,p_eco_obj IN inv_ebi_eco_obj
1922: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
1923: ) IS
1924:
1951: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order' );
1952: INV_EBI_UTIL.debug_line('STEP 20: CHANGE NOTICE: '|| p_eco_obj.eco_change_order_type.eco_name ||
1953: ' ORG CODE: '|| p_eco_obj.eco_change_order_type.organization_code );
1954: l_uda_output := inv_ebi_uda_output_obj(NULL,NULL);
1955: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
1956: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
1957:
1958: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();
1959:
1960: bom_globals.set_bo_identifier(bom_globals.g_eco_bo);
1961:
1962: INV_EBI_UTIL.debug_line('STEP 30: START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');
1963: INV_EBI_CHANGE_ORDER_HELPER.process_eco(
1964: p_commit => FND_API.g_false
1965: ,p_change_order => p_eco_obj.eco_change_order_type
1966: ,p_revision_type_tbl => p_eco_obj.eco_revision_type
1967: ,p_revised_item_type_tbl => p_eco_obj.eco_revised_item_type
1968: ,p_name_val_list => inv_ebi_name_value_list(p_eco_obj.name_value_tbl)
1968: ,p_name_val_list => inv_ebi_name_value_list(p_eco_obj.name_value_tbl)
1969: ,x_out => l_out
1970: );
1971: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco STATUS: '|| l_out.output_status.return_status);
1972: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1973: x_out.output_status.msg_data := l_out.output_status.msg_data;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: END IF;
1976:
1970: );
1971: INV_EBI_UTIL.debug_line('STEP 40: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco STATUS: '|| l_out.output_status.return_status);
1972: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1973: x_out.output_status.msg_data := l_out.output_status.msg_data;
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: END IF;
1976:
1977: l_change_id := l_out.change_id;
1978: l_change_notice := l_out.change_notice;
1994:
1995: l_status_name := p_eco_obj.eco_change_order_type.status_name;
1996:
1997: IF( p_eco_obj.eco_change_order_type.status_code IS NOT NULL AND
1998: p_eco_obj.eco_change_order_type.status_code <> fnd_api.g_miss_num) THEN
1999:
2000: l_status_name := INV_EBI_CHANGE_ORDER_HELPER.get_eco_status_name(p_eco_obj.eco_change_order_type.status_code);
2001:
2002: END IF;
2027:
2028: INV_EBI_UTIL.debug_line('STEP 50: START CALLING ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase');
2029: ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase(
2030: p_api_version => 1.0
2031: ,p_commit => FND_API.g_false
2032: ,p_object_name => 'ENG_CHANGE'
2033: ,p_change_id => l_change_id
2034: ,p_status_code => l_status_code
2035: ,p_action_type => ENG_CHANGE_LIFECYCLE_UTIL.G_ENG_PROMOTE -- promote/demote
2037: ,x_msg_count => l_out.output_status.msg_count
2038: ,x_msg_data => l_out.output_status.msg_data
2039: );
2040: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase STATUS: '|| l_out.output_status.return_status);
2041: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2042: x_out.output_status.msg_data := l_out.output_status.msg_data;
2043: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> ECO Name:' || l_change_notice || ' -> Org Code: ' || l_organization_code;
2044: RAISE FND_API.g_exc_unexpected_error;
2045: END IF;
2040: INV_EBI_UTIL.debug_line('STEP 60: AFTER CALLING ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase STATUS: '|| l_out.output_status.return_status);
2041: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2042: x_out.output_status.msg_data := l_out.output_status.msg_data;
2043: x_out.output_status.msg_data := x_out.output_status.msg_data || ' -> ECO Name:' || l_change_notice || ' -> Org Code: ' || l_organization_code;
2044: RAISE FND_API.g_exc_unexpected_error;
2045: END IF;
2046: END IF;
2047:
2048: --Processing of Udas
2049: IF (INV_EBI_UTIL.is_pim_installed) THEN
2050: IF ((p_eco_obj.eco_change_order_type IS NOT NULL AND p_eco_obj.eco_change_order_type.change_order_uda IS NOT NULL)
2051: AND p_eco_obj.eco_change_order_type.change_order_uda.attribute_group_tbl.COUNT > 0) THEN
2052: IF ((p_eco_obj.eco_change_order_type.eco_name IS NOT NULL)
2053: AND (p_eco_obj.eco_change_order_type.organization_id IS NULL OR p_eco_obj.eco_change_order_type.organization_id =FND_API.g_miss_num)
2054: AND (p_eco_obj.eco_change_order_type.organization_code IS NOT NULL OR p_eco_obj.eco_change_order_type.organization_code <> FND_API.g_miss_char)) THEN
2055:
2056: SELECT change_order_type_id INTO l_change_order_type_id
2057: FROM eng_engineering_changes
2050: IF ((p_eco_obj.eco_change_order_type IS NOT NULL AND p_eco_obj.eco_change_order_type.change_order_uda IS NOT NULL)
2051: AND p_eco_obj.eco_change_order_type.change_order_uda.attribute_group_tbl.COUNT > 0) THEN
2052: IF ((p_eco_obj.eco_change_order_type.eco_name IS NOT NULL)
2053: AND (p_eco_obj.eco_change_order_type.organization_id IS NULL OR p_eco_obj.eco_change_order_type.organization_id =FND_API.g_miss_num)
2054: AND (p_eco_obj.eco_change_order_type.organization_code IS NOT NULL OR p_eco_obj.eco_change_order_type.organization_code <> FND_API.g_miss_char)) THEN
2055:
2056: SELECT change_order_type_id INTO l_change_order_type_id
2057: FROM eng_engineering_changes
2058: WHERE change_notice = p_eco_obj.eco_change_order_type.eco_name
2069: --To process Change order header udas
2070: INV_EBI_UTIL.debug_line('STEP 70: BEFORE CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda');
2071: INV_EBI_CHANGE_ORDER_HELPER.process_uda(
2072: p_uda_input_obj => p_eco_obj.eco_change_order_type.change_order_uda
2073: ,p_commit => fnd_api.g_false
2074: ,p_object_name => 'ENG_CHANGE'
2075: ,p_data_level => 'CHANGE_LEVEL'
2076: ,p_pk_column_name_value_pairs => l_pkdata
2077: ,p_class_code_name_value_pairs => l_pkcode
2078: ,x_uda_output_obj => l_out
2079: );
2080: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda STATUS: '|| l_out.output_status.return_status);
2081: END IF;
2082: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2083: x_out.output_status.msg_data := l_out.output_status.msg_data;
2084: RAISE fnd_api.g_exc_unexpected_error;
2085: END IF;
2086:
2080: INV_EBI_UTIL.debug_line('STEP 80: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_uda STATUS: '|| l_out.output_status.return_status);
2081: END IF;
2082: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2083: x_out.output_status.msg_data := l_out.output_status.msg_data;
2084: RAISE fnd_api.g_exc_unexpected_error;
2085: END IF;
2086:
2087: l_uda_output := inv_ebi_uda_output_obj(l_out.uda_output.failed_row_id_list,l_out.uda_output.errorcode);
2088:
2110: ,p_item_catalog_group_id => p_eco_obj.eco_revised_item_type(i).item.main_obj_type.item_catalog_group_id
2111: ,p_revision_id => NULL
2112: ,p_revision_code => p_eco_obj.eco_revised_item_type(i).new_revised_item_revision
2113: ,p_uda_input_obj => p_eco_obj.eco_revised_item_type(i).item.uda_type
2114: ,p_commit => fnd_api.g_false
2115: ,x_uda_output_obj => l_item_output
2116: );
2117: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_item_output.output_status.return_status);
2118: END IF;
2116: );
2117: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_item_output.output_status.return_status);
2118: END IF;
2119:
2120: IF (l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2121: x_out.output_status.return_status := l_item_output.output_status.msg_data;
2122: RAISE FND_API.g_exc_unexpected_error;
2123: END IF;
2124:
2118: END IF;
2119:
2120: IF (l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2121: x_out.output_status.return_status := l_item_output.output_status.msg_data;
2122: RAISE FND_API.g_exc_unexpected_error;
2123: END IF;
2124:
2125: l_uda_output := inv_ebi_uda_output_obj(l_item_output.uda_output.failed_row_id_list,l_item_output.uda_output.errorcode);*/
2126:
2126:
2127: -- To process Component level udas and structure header level udas
2128: INV_EBI_UTIL.debug_line('STEP 90: START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda');
2129: INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda(
2130: p_commit => FND_API.g_false
2131: ,p_organization_code => p_eco_obj.eco_change_order_type.organization_code
2132: ,p_eco_name => p_eco_obj.eco_change_order_type.eco_name
2133: ,p_alternate_bom_code => p_eco_obj.eco_revised_item_type(i).alternate_bom_code
2134: ,p_revised_item_name => p_eco_obj.eco_revised_item_type(i).revised_item_name
2136: ,p_structure_header => p_eco_obj.eco_revised_item_type(i).structure_header
2137: ,x_out => l_out
2138: );
2139: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda STATUS: '|| l_out.output_status.return_status);
2140: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2141: x_out.output_status.msg_data := l_out.output_status.msg_data;
2142: RAISE FND_API.g_exc_unexpected_error;
2143: END IF;
2144: END LOOP;
2138: );
2139: INV_EBI_UTIL.debug_line('STEP 100: AFTER CALLING INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda STATUS: '|| l_out.output_status.return_status);
2140: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2141: x_out.output_status.msg_data := l_out.output_status.msg_data;
2142: RAISE FND_API.g_exc_unexpected_error;
2143: END IF;
2144: END LOOP;
2145: END IF;
2146: l_uda_output := inv_ebi_uda_output_obj(l_out.uda_output.failed_row_id_list,l_out.uda_output.errorcode);
2149: INV_EBI_UTIL.debug_line('STEP 110: END Processing UDAS');
2150: x_out := inv_ebi_eco_output_obj( l_change_notice,l_change_id,l_organization_id,l_organization_code,
2151: l_out.output_status,NULL,l_uda_output);
2152:
2153: IF FND_API.to_boolean(p_commit) THEN
2154: COMMIT;
2155: END IF;
2156: INV_EBI_UTIL.debug_line('STEP 120: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order'||'RETURN STATUS: '||x_out.output_status.return_status);
2157: EXCEPTION
2154: COMMIT;
2155: END IF;
2156: INV_EBI_UTIL.debug_line('STEP 120: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order'||'RETURN STATUS: '||x_out.output_status.return_status);
2157: EXCEPTION
2158: WHEN FND_API.g_exc_unexpected_error THEN
2159: ROLLBACK TO inv_ebi_chg_order_save_pnt;
2160:
2161: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2162: IF(x_out.output_status.msg_data IS NULL) THEN
2157: EXCEPTION
2158: WHEN FND_API.g_exc_unexpected_error THEN
2159: ROLLBACK TO inv_ebi_chg_order_save_pnt;
2160:
2161: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2162: IF(x_out.output_status.msg_data IS NULL) THEN
2163: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
2164:
2165: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
2166: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
2167:
2168: IF(x_out.output_status.msg_data IS NULL) THEN
2169: FND_MSG_PUB.count_and_get(
2170: p_encoded => FND_API.g_false
2171: ,p_count => x_out.output_status.msg_count
2172: ,p_data => x_out.output_status.msg_data
2173: );
2174: END IF;
2178: WHEN OTHERS THEN
2179: ROLLBACK TO inv_ebi_chg_order_save_pnt;
2180:
2181: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
2182: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
2183:
2184: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
2185: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
2186: END IF;
2200: -- Changed this API for Bug 8397083
2201: ************************************************************************************/
2202:
2203: PROCEDURE process_change_order_list_core(
2204: p_commit IN VARCHAR2 := fnd_api.g_false
2205: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
2206: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
2207: ,x_return_status OUT NOCOPY VARCHAR2
2208: ,x_msg_count OUT NOCOPY NUMBER
2217: l_org_code VARCHAR2(3);
2218: l_is_master_org VARCHAR2(1);
2219: l_updated_item_tbl inv_ebi_item_attr_tbl;
2220: l_upd_item_tbl inv_ebi_item_attr_tbl;
2221: l_assign_item_to_child_org VARCHAR2(1):= fnd_api.g_false;
2222: l_item_output_obj inv_ebi_item_output_obj;
2223: l_eco_obj_list inv_ebi_eco_obj_tbl;
2224: l_eco_obj_tbl inv_ebi_eco_obj_tbl;
2225: l_upd_eco_name_tbl FND_TABLE_OF_VARCHAR2_30;
2259: FND_GLOBAL.RESP_APPL_ID || '; Responsibility Id: ' || FND_GLOBAL.RESP_ID ||
2260: '; Security Group id: '|| FND_GLOBAL.SECURITY_GROUP_ID ||'; User Lang: '|| USERENV('LANG') );
2261: INV_EBI_UTIL.debug_line( ' **************** End of Apps Context ****************' );
2262:
2263: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2264: x_out := inv_ebi_eco_output_obj_tbl();
2265: l_revitem_output_tbl := inv_ebi_revitem_output_obj_tbl();
2266: l_eco_obj_tbl := inv_ebi_eco_obj_tbl();
2267: l_eco_obj_tbl := p_eco_obj_list;
2283: l_org_code := l_eco_obj_tbl(i).eco_change_order_type.organization_code;
2284:
2285: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
2286:
2287: IF( l_is_master_org = fnd_api.g_true ) THEN
2288:
2289: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order_items for Master ORG'||
2290: ' Organization Code: '||l_eco_obj_tbl(i).eco_change_order_type.organization_code||
2291: ' ECO Name: '||l_eco_obj_tbl(i).eco_change_order_type.eco_name);
2300: ,x_out => l_item_output_obj
2301: ,x_eco_obj => l_eco_obj
2302: );
2303:
2304: IF l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
2305: x_out(i) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_item_output_obj.output_status,NULL,NULL);
2306: RAISE FND_API.g_exc_unexpected_error;
2307: END IF;
2308:
2302: );
2303:
2304: IF l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
2305: x_out(i) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_item_output_obj.output_status,NULL,NULL);
2306: RAISE FND_API.g_exc_unexpected_error;
2307: END IF;
2308:
2309: l_eco_obj_tbl(i) := l_eco_obj;
2310:
2337: l_eco_name := l_eco_obj_tbl(i).eco_change_order_type.eco_name;
2338: l_org_code := l_eco_obj_tbl(i).eco_change_order_type.organization_code;
2339: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
2340:
2341: IF( l_is_master_org = fnd_api.g_false ) THEN
2342:
2343: INV_EBI_UTIL.debug_line('STEP 40: BEFORE CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order_items for Child ORG'||
2344: ' Organization Code: '||l_eco_obj_tbl(i).eco_change_order_type.organization_code||
2345: ' ECO Name: '||l_eco_obj_tbl(i).eco_change_order_type.eco_name);
2357: ,x_eco_obj => l_eco_obj
2358: );
2359:
2360:
2361: IF l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
2362: x_out(i) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_item_output_obj.output_status,NULL,NULL);
2363: RAISE FND_API.g_exc_unexpected_error;
2364: END IF;
2365:
2359:
2360:
2361: IF l_item_output_obj.output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
2362: x_out(i) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_item_output_obj.output_status,NULL,NULL);
2363: RAISE FND_API.g_exc_unexpected_error;
2364: END IF;
2365:
2366: l_eco_obj_tbl(i) := l_eco_obj;
2367:
2411: -- If user wants to update these values again,all the pending CO's should be implemented/cancelled.
2412:
2413: INV_EBI_UTIL.debug_line('STEP 60: BEFORE CALLING INV_EBI_ITEM_HELPER.process_update_item_lifecycle');
2414: INV_EBI_ITEM_HELPER.process_update_item_lifecycle(
2415: p_commit => FND_API.g_false
2416: ,p_update_item_tbl => l_updated_item_tbl
2417: ,x_out => l_item_output_obj
2418: );
2419: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_ITEM_HELPER.process_update_item_lifecycle for item updation STATUS: '|| l_item_output_obj.output_status.return_status);
2419: INV_EBI_UTIL.debug_line('STEP 70: AFTER CALLING INV_EBI_ITEM_HELPER.process_update_item_lifecycle for item updation STATUS: '|| l_item_output_obj.output_status.return_status);
2420:
2421: --End of bug 10416391
2422:
2423: IF (l_item_output_obj.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
2424: l_item_name := l_item_output_obj.item_number;
2425: l_org_code := l_item_output_obj.organization_code;
2426:
2427: FOR i IN 1..l_updated_item_tbl.COUNT LOOP
2434: x_out(l_index) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_output_status,NULL,NULL);
2435:
2436: END IF;
2437: END LOOP;
2438: RAISE fnd_api.g_exc_unexpected_error;
2439: END IF;
2440:
2441: INV_EBI_UTIL.debug_line('STEP 80: BEFORE CALLING INV_EBI_CHANGE_ORDER_PUB.process_bom');
2442: process_bom(
2446: ,x_out => l_inv_ebi_eco_output_obj
2447: );
2448:
2449: INV_EBI_UTIL.debug_line('STEP 90: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_bom status is ' || l_inv_ebi_eco_output_obj.output_status.return_status);
2450: IF (l_inv_ebi_eco_output_obj.output_status.return_status <> FND_API.g_ret_sts_success )THEN
2451: l_eco_name := l_inv_ebi_eco_output_obj.change_notice;
2452: l_org_code := l_inv_ebi_eco_output_obj.organization_code;
2453: FOR i IN 1..l_eco_obj_tbl.COUNT LOOP
2454:
2457: x_out(i) := l_inv_ebi_eco_output_obj;
2458: END IF;
2459:
2460: END LOOP;
2461: RAISE FND_API.g_exc_unexpected_error;
2462: END IF;
2463:
2464: FOR i in 1..l_eco_obj_list.COUNT
2465: LOOP
2475: );
2476: INV_EBI_UTIL.debug_line('STEP 110: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order STATUS '|| l_inv_ebi_eco_output_obj.output_status.return_status);
2477: x_out(i) := l_inv_ebi_eco_output_obj;
2478:
2479: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
2480:
2481: RAISE FND_API.g_exc_unexpected_error;
2482:
2483: END IF;
2477: x_out(i) := l_inv_ebi_eco_output_obj;
2478:
2479: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
2480:
2481: RAISE FND_API.g_exc_unexpected_error;
2482:
2483: END IF;
2484: END LOOP;
2485: END IF;
2494: ,x_out => l_item_output_obj
2495: );
2496:
2497: INV_EBI_UTIL.debug_line('STEP 130: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_update_items STATUS: '|| l_item_output_obj.output_status.return_status);
2498: IF (l_item_output_obj.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
2499: l_item_name := l_item_output_obj.item_number;
2500: l_org_code := l_item_output_obj.organization_code;
2501:
2502: FOR i IN 1..l_updated_item_tbl.COUNT LOOP
2509: x_out(l_index) := inv_ebi_eco_output_obj( l_eco_name,NULL,NULL,l_org_code,l_output_status,NULL,NULL);
2510:
2511: END IF;
2512: END LOOP;
2513: RAISE fnd_api.g_exc_unexpected_error;
2514: END IF;
2515:
2516: -- Start of Bug 10416673
2517: IF (INV_EBI_UTIL.is_pim_installed) THEN
2547: ,p_item_catalog_group_id => l_eco_obj_list(i).eco_revised_item_type(j).item.main_obj_type.item_catalog_group_id
2548: ,p_revision_id => NULL
2549: ,p_revision_code => l_eco_obj_list(i).eco_revised_item_type(j).new_revised_item_revision
2550: ,p_uda_input_obj => l_eco_obj_list(i).eco_revised_item_type(j).item.uda_type
2551: ,p_commit => fnd_api.g_false
2552: ,x_uda_output_obj => l_item_output_obj
2553: );
2554:
2555: INV_EBI_UTIL.debug_line('STEP 160: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_item_output_obj.output_status.return_status);
2554:
2555: INV_EBI_UTIL.debug_line('STEP 160: AFTER CALLING INV_EBI_ITEM_HELPER.process_item_uda STATUS: '|| l_item_output_obj.output_status.return_status);
2556: END IF;
2557:
2558: IF (l_item_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2559: x_out(i) := inv_ebi_eco_output_obj( l_eco_obj_list(i).eco_change_order_type.eco_name,NULL,NULL,l_eco_obj_list(i).eco_change_order_type.organization_code
2560: ,l_item_output_obj.output_status,NULL,NULL);
2561: RAISE FND_API.g_exc_unexpected_error;
2562: END IF;
2557:
2558: IF (l_item_output_obj.output_status.return_status <> FND_API.g_ret_sts_success) THEN
2559: x_out(i) := inv_ebi_eco_output_obj( l_eco_obj_list(i).eco_change_order_type.eco_name,NULL,NULL,l_eco_obj_list(i).eco_change_order_type.organization_code
2560: ,l_item_output_obj.output_status,NULL,NULL);
2561: RAISE FND_API.g_exc_unexpected_error;
2562: END IF;
2563: END LOOP;
2564: END IF;
2565: END LOOP;
2577: );
2578: x_out(i).item_output_tbl := l_revitem_output_tbl;
2579: END LOOP;
2580:
2581: IF FND_API.to_boolean(p_commit) THEN
2582: COMMIT;
2583: END IF;
2584:
2585: INV_EBI_UTIL.debug_line('STEP 180: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list STATUS: '|| x_return_status);
2584:
2585: INV_EBI_UTIL.debug_line('STEP 180: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list STATUS: '|| x_return_status);
2586:
2587: EXCEPTION
2588: WHEN FND_API.g_exc_unexpected_error THEN
2589: ROLLBACK TO inv_ebi_prc_chg_ord_save_pnt;
2590: x_return_status := FND_API.G_RET_STS_ERROR;
2591: IF (x_out IS NOT NULL AND x_out.COUNT > 0) THEN
2592: FOR i in 1..x_out.COUNT
2586:
2587: EXCEPTION
2588: WHEN FND_API.g_exc_unexpected_error THEN
2589: ROLLBACK TO inv_ebi_prc_chg_ord_save_pnt;
2590: x_return_status := FND_API.G_RET_STS_ERROR;
2591: IF (x_out IS NOT NULL AND x_out.COUNT > 0) THEN
2592: FOR i in 1..x_out.COUNT
2593: LOOP
2594: x_msg_count := x_out(i).output_status.msg_count;
2600:
2601: WHEN OTHERS THEN
2602: ROLLBACK TO inv_ebi_prc_chg_ord_save_pnt;
2603: x_out.EXTEND();
2604: x_out(1).output_status.return_status := FND_API.g_ret_sts_unexp_error;
2605: IF (x_out(1).output_status.msg_data IS NOT NULL) THEN
2606: x_out(1).output_status.msg_data := x_out(1).output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
2607: ELSE
2608: x_out(1).output_status.msg_data := SQLERRM|| 'INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
2606: x_out(1).output_status.msg_data := x_out(1).output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
2607: ELSE
2608: x_out(1).output_status.msg_data := SQLERRM|| 'INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
2609: END IF;
2610: x_return_status := FND_API.G_RET_STS_ERROR;
2611: x_msg_count := x_out(1).output_status.msg_count;
2612:
2613: IF (x_out IS NOT NULL AND x_out.COUNT > 0) THEN
2614: FOR i in 1..x_out.COUNT
2629: --
2630: ************************************************************************************/
2631:
2632: PROCEDURE process_change_order_list(
2633: p_commit IN VARCHAR2 := fnd_api.g_false
2634: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
2635: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
2636: ,x_return_status OUT NOCOPY VARCHAR2
2637: ,x_msg_count OUT NOCOPY NUMBER
2643: ERROR_HANDLER.Initialize;
2644: FND_MSG_PUB.initialize;
2645: INV_EBI_UTIL.setup();
2646: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
2647: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2648:
2649: IF (p_eco_obj_list IS NOT NULL AND p_eco_obj_list.count > 0) THEN
2650: INV_EBI_UTIL.debug_line('STEP 20: START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core');
2651: process_change_order_list_core( p_commit => fnd_api.g_false
2647: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2648:
2649: IF (p_eco_obj_list IS NOT NULL AND p_eco_obj_list.count > 0) THEN
2650: INV_EBI_UTIL.debug_line('STEP 20: START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core');
2651: process_change_order_list_core( p_commit => fnd_api.g_false
2652: ,p_eco_obj_list => p_eco_obj_list
2653: ,x_out => x_out
2654: ,x_return_status => x_return_status
2655: ,x_msg_count => x_msg_count
2654: ,x_return_status => x_return_status
2655: ,x_msg_count => x_msg_count
2656: ,x_msg_data => x_msg_data);
2657: INV_EBI_UTIL.debug_line('STEP 30: END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core STATUS: '|| x_return_status);
2658: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2659: RAISE FND_API.g_exc_unexpected_error;
2660: END IF;
2661: END IF;
2662:
2655: ,x_msg_count => x_msg_count
2656: ,x_msg_data => x_msg_data);
2657: INV_EBI_UTIL.debug_line('STEP 30: END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core STATUS: '|| x_return_status);
2658: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2659: RAISE FND_API.g_exc_unexpected_error;
2660: END IF;
2661: END IF;
2662:
2663: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
2663: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
2664: INV_EBI_UTIL.wrapup;
2665:
2666: EXCEPTION
2667: WHEN FND_API.g_exc_unexpected_error THEN
2668: ROLLBACK TO inv_ebi_prc_chg_lst_save_pnt;
2669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2670: WHEN OTHERS THEN
2671: ROLLBACK TO inv_ebi_prc_chg_lst_save_pnt;
2665:
2666: EXCEPTION
2667: WHEN FND_API.g_exc_unexpected_error THEN
2668: ROLLBACK TO inv_ebi_prc_chg_lst_save_pnt;
2669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2670: WHEN OTHERS THEN
2671: ROLLBACK TO inv_ebi_prc_chg_lst_save_pnt;
2672: x_return_status := FND_API.G_RET_STS_ERROR;
2673: IF x_msg_data IS NULL THEN
2668: ROLLBACK TO inv_ebi_prc_chg_lst_save_pnt;
2669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2670: WHEN OTHERS THEN
2671: ROLLBACK TO inv_ebi_prc_chg_lst_save_pnt;
2672: x_return_status := FND_API.G_RET_STS_ERROR;
2673: IF x_msg_data IS NULL THEN
2674: x_msg_data := SQLERRM|| 'INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
2675: END IF;
2676: END process_change_order_list;
2680: -- This API is used to validate change order list
2681: --
2682: ************************************************************************************/
2683: PROCEDURE validate_change_order_list(
2684: p_commit IN VARCHAR2 := fnd_api.g_false
2685: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
2686: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
2687: ,x_return_status OUT NOCOPY VARCHAR2
2688: ,x_msg_count OUT NOCOPY NUMBER
2694: ERROR_HANDLER.Initialize;
2695: FND_MSG_PUB.initialize;
2696: INV_EBI_UTIL.setup();
2697: INV_EBI_UTIL.debug_line('STEP 10: START INSIDE INV_EBI_CHANGE_ORDER_PUB.validate_change_order_list');
2698: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2699:
2700: IF (p_eco_obj_list IS NOT NULL AND p_eco_obj_list.count > 0) THEN
2701: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core');
2702: process_change_order_list_core( p_commit => fnd_api.g_false
2698: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2699:
2700: IF (p_eco_obj_list IS NOT NULL AND p_eco_obj_list.count > 0) THEN
2701: INV_EBI_UTIL.debug_line('STEP 20: BEFORE CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core');
2702: process_change_order_list_core( p_commit => fnd_api.g_false
2703: ,p_eco_obj_list => p_eco_obj_list
2704: ,x_out => x_out
2705: ,x_return_status => x_return_status
2706: ,x_msg_count => x_msg_count
2705: ,x_return_status => x_return_status
2706: ,x_msg_count => x_msg_count
2707: ,x_msg_data => x_msg_data);
2708: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core'||'RETURN STATUS: '||x_return_status);
2709: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2710: RAISE FND_API.g_exc_unexpected_error;
2711: END IF;
2712: END IF;
2713:
2706: ,x_msg_count => x_msg_count
2707: ,x_msg_data => x_msg_data);
2708: INV_EBI_UTIL.debug_line('STEP 30: AFTER CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order_list_core'||'RETURN STATUS: '||x_return_status);
2709: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2710: RAISE FND_API.g_exc_unexpected_error;
2711: END IF;
2712: END IF;
2713:
2714: -- ROLLBACK TO inv_ebi_val_chg_lst_save_pnt;
2716: INV_EBI_UTIL.debug_line('STEP 40: END INSIDE INV_EBI_CHANGE_ORDER_PUB.validate_change_order_list');
2717: INV_EBI_UTIL.wrapup;
2718:
2719: EXCEPTION
2720: WHEN FND_API.g_exc_unexpected_error THEN
2721: --ROLLBACK TO inv_ebi_val_chg_lst_save_pnt;
2722: ROLLBACK;
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2724: WHEN OTHERS THEN
2719: EXCEPTION
2720: WHEN FND_API.g_exc_unexpected_error THEN
2721: --ROLLBACK TO inv_ebi_val_chg_lst_save_pnt;
2722: ROLLBACK;
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2724: WHEN OTHERS THEN
2725: -- ROLLBACK TO inv_ebi_val_chg_lst_save_pnt;
2726: ROLLBACK;
2727: x_return_status := FND_API.G_RET_STS_ERROR;
2723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2724: WHEN OTHERS THEN
2725: -- ROLLBACK TO inv_ebi_val_chg_lst_save_pnt;
2726: ROLLBACK;
2727: x_return_status := FND_API.G_RET_STS_ERROR;
2728: IF x_msg_data IS NULL THEN
2729: x_msg_data := SQLERRM|| 'INV_EBI_CHANGE_ORDER_PUB.validate_change_order_list';
2730: END IF;
2731: END validate_change_order_list;