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

APPS.INV_EBI_CHANGE_ORDER_PUB dependencies on FND_API

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

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_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
22: IF(p_revised_item.item IS NOT NULL ) THEN
23: x_item := p_revised_item.item;
24: ELSE

Line 25: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,

21: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
22: IF(p_revised_item.item IS NOT NULL ) THEN
23: x_item := p_revised_item.item;
24: ELSE
25: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,
26: 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_num,fnd_api.g_miss_char,
29: fnd_api.g_miss_char,fnd_api.g_miss_char,

Line 26: fnd_api.g_miss_char,fnd_api.g_miss_num,

22: IF(p_revised_item.item IS NOT NULL ) THEN
23: x_item := p_revised_item.item;
24: ELSE
25: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,
26: 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_num,fnd_api.g_miss_char,
29: fnd_api.g_miss_char,fnd_api.g_miss_char,
30: fnd_api.g_miss_char,fnd_api.g_miss_char,

Line 27: fnd_api.g_miss_char,fnd_api.g_miss_num,

23: x_item := p_revised_item.item;
24: ELSE
25: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,
26: 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_num,fnd_api.g_miss_char,
29: 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_num,

Line 28: fnd_api.g_miss_num,fnd_api.g_miss_char,

24: ELSE
25: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,
26: 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_num,fnd_api.g_miss_char,
29: 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_num,
32: fnd_api.g_miss_num,fnd_api.g_miss_char,

Line 29: fnd_api.g_miss_char,fnd_api.g_miss_char,

25: l_main_item_obj := inv_ebi_item_main_obj(fnd_api.g_miss_num,fnd_api.g_miss_char,
26: 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_num,fnd_api.g_miss_char,
29: 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_num,
32: fnd_api.g_miss_num,fnd_api.g_miss_char,
33: fnd_api.g_miss_char,fnd_api.g_miss_num,

Line 30: fnd_api.g_miss_char,fnd_api.g_miss_char,

26: 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_num,fnd_api.g_miss_char,
29: 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_num,
32: fnd_api.g_miss_num,fnd_api.g_miss_char,
33: fnd_api.g_miss_char,fnd_api.g_miss_num,
34: fnd_api.g_miss_num,fnd_api.g_miss_char,

Line 31: 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_num,fnd_api.g_miss_char,
29: 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_num,
32: fnd_api.g_miss_num,fnd_api.g_miss_char,
33: fnd_api.g_miss_char,fnd_api.g_miss_num,
34: fnd_api.g_miss_num,fnd_api.g_miss_char,
35: fnd_api.g_miss_char,fnd_api.g_miss_char,

Line 32: fnd_api.g_miss_num,fnd_api.g_miss_char,

28: fnd_api.g_miss_num,fnd_api.g_miss_char,
29: 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_num,
32: fnd_api.g_miss_num,fnd_api.g_miss_char,
33: fnd_api.g_miss_char,fnd_api.g_miss_num,
34: fnd_api.g_miss_num,fnd_api.g_miss_char,
35: fnd_api.g_miss_char,fnd_api.g_miss_char,
36: fnd_api.g_miss_char,fnd_api.g_miss_char,

Line 33: fnd_api.g_miss_char,fnd_api.g_miss_num,

29: 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_num,
32: fnd_api.g_miss_num,fnd_api.g_miss_char,
33: fnd_api.g_miss_char,fnd_api.g_miss_num,
34: fnd_api.g_miss_num,fnd_api.g_miss_char,
35: 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,

Line 34: 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_num,
32: fnd_api.g_miss_num,fnd_api.g_miss_char,
33: fnd_api.g_miss_char,fnd_api.g_miss_num,
34: fnd_api.g_miss_num,fnd_api.g_miss_char,
35: 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,

Line 35: fnd_api.g_miss_char,fnd_api.g_miss_char,

31: fnd_api.g_miss_char,fnd_api.g_miss_num,
32: fnd_api.g_miss_num,fnd_api.g_miss_char,
33: fnd_api.g_miss_char,fnd_api.g_miss_num,
34: fnd_api.g_miss_num,fnd_api.g_miss_char,
35: 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,

Line 36: fnd_api.g_miss_char,fnd_api.g_miss_char,

32: fnd_api.g_miss_num,fnd_api.g_miss_char,
33: fnd_api.g_miss_char,fnd_api.g_miss_num,
34: fnd_api.g_miss_num,fnd_api.g_miss_char,
35: 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,

Line 37: fnd_api.g_miss_char,fnd_api.g_miss_char,

33: fnd_api.g_miss_char,fnd_api.g_miss_num,
34: fnd_api.g_miss_num,fnd_api.g_miss_char,
35: 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,

Line 38: fnd_api.g_miss_char,fnd_api.g_miss_char,

34: fnd_api.g_miss_num,fnd_api.g_miss_char,
35: 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,

Line 39: fnd_api.g_miss_char,fnd_api.g_miss_char,

35: 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,

Line 40: 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,

Line 41: 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,

Line 42: 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,

Line 43: 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_date,

Line 44: 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_date,
48: fnd_api.g_miss_date,fnd_api.g_miss_date,

Line 45: 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_date,
48: fnd_api.g_miss_date,fnd_api.g_miss_date,
49: fnd_api.g_miss_num,fnd_api.g_miss_date,

Line 46: 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_date,
48: fnd_api.g_miss_date,fnd_api.g_miss_date,
49: fnd_api.g_miss_num,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,fnd_api.g_miss_num,

Line 47: fnd_api.g_miss_char,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_date,
48: fnd_api.g_miss_date,fnd_api.g_miss_date,
49: fnd_api.g_miss_num,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,fnd_api.g_miss_num,
51: fnd_api.g_miss_num,fnd_api.g_miss_num,

Line 48: fnd_api.g_miss_date,fnd_api.g_miss_date,

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_date,
48: fnd_api.g_miss_date,fnd_api.g_miss_date,
49: fnd_api.g_miss_num,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,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_date,

Line 49: fnd_api.g_miss_num,fnd_api.g_miss_date,

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_date,
48: fnd_api.g_miss_date,fnd_api.g_miss_date,
49: fnd_api.g_miss_num,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,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_date,
53: fnd_api.g_miss_num,fnd_api.g_miss_char,

Line 50: fnd_api.g_miss_num,fnd_api.g_miss_num,

46: fnd_api.g_miss_char,fnd_api.g_miss_char,
47: fnd_api.g_miss_char,fnd_api.g_miss_date,
48: fnd_api.g_miss_date,fnd_api.g_miss_date,
49: fnd_api.g_miss_num,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,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_date,
53: fnd_api.g_miss_num,fnd_api.g_miss_char,
54: fnd_api.g_miss_num,fnd_api.g_miss_char,

Line 51: fnd_api.g_miss_num,fnd_api.g_miss_num,

47: fnd_api.g_miss_char,fnd_api.g_miss_date,
48: fnd_api.g_miss_date,fnd_api.g_miss_date,
49: fnd_api.g_miss_num,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,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_date,
53: 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,

Line 52: fnd_api.g_miss_num,fnd_api.g_miss_date,

48: fnd_api.g_miss_date,fnd_api.g_miss_date,
49: fnd_api.g_miss_num,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,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_date,
53: 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_char,fnd_api.g_miss_char,

Line 53: fnd_api.g_miss_num,fnd_api.g_miss_char,

49: fnd_api.g_miss_num,fnd_api.g_miss_date,
50: fnd_api.g_miss_num,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_date,
53: 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_char,fnd_api.g_miss_char,
57: fnd_api.g_miss_date,fnd_api.g_miss_num,

Line 54: fnd_api.g_miss_num,fnd_api.g_miss_char,

50: fnd_api.g_miss_num,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_date,
53: 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_char,fnd_api.g_miss_char,
57: fnd_api.g_miss_date,fnd_api.g_miss_num,
58: fnd_api.g_miss_char,fnd_api.g_miss_num,

Line 55: fnd_api.g_miss_num,fnd_api.g_miss_char,

51: fnd_api.g_miss_num,fnd_api.g_miss_num,
52: fnd_api.g_miss_num,fnd_api.g_miss_date,
53: 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_char,fnd_api.g_miss_char,
57: fnd_api.g_miss_date,fnd_api.g_miss_num,
58: fnd_api.g_miss_char,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_char,

Line 56: fnd_api.g_miss_char,fnd_api.g_miss_char,

52: fnd_api.g_miss_num,fnd_api.g_miss_date,
53: 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_char,fnd_api.g_miss_char,
57: fnd_api.g_miss_date,fnd_api.g_miss_num,
58: fnd_api.g_miss_char,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_char,
60: fnd_api.g_miss_num,fnd_api.g_miss_char,

Line 57: fnd_api.g_miss_date,fnd_api.g_miss_num,

53: 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_char,fnd_api.g_miss_char,
57: fnd_api.g_miss_date,fnd_api.g_miss_num,
58: fnd_api.g_miss_char,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_char,
60: fnd_api.g_miss_num,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,

Line 58: fnd_api.g_miss_char,fnd_api.g_miss_num,

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_char,fnd_api.g_miss_char,
57: fnd_api.g_miss_date,fnd_api.g_miss_num,
58: fnd_api.g_miss_char,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_char,
60: fnd_api.g_miss_num,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_char,fnd_api.g_miss_char,

Line 59: fnd_api.g_miss_char,fnd_api.g_miss_char,

55: fnd_api.g_miss_num,fnd_api.g_miss_char,
56: fnd_api.g_miss_char,fnd_api.g_miss_char,
57: fnd_api.g_miss_date,fnd_api.g_miss_num,
58: fnd_api.g_miss_char,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_char,
60: fnd_api.g_miss_num,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_char,fnd_api.g_miss_char,
63: fnd_api.g_miss_char,fnd_api.g_miss_char,

Line 60: fnd_api.g_miss_num,fnd_api.g_miss_char,

56: fnd_api.g_miss_char,fnd_api.g_miss_char,
57: fnd_api.g_miss_date,fnd_api.g_miss_num,
58: fnd_api.g_miss_char,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_char,
60: fnd_api.g_miss_num,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_char,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,

Line 61: fnd_api.g_miss_num,fnd_api.g_miss_char,

57: fnd_api.g_miss_date,fnd_api.g_miss_num,
58: fnd_api.g_miss_char,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_char,
60: fnd_api.g_miss_num,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_char,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,

Line 62: fnd_api.g_miss_char,fnd_api.g_miss_char,

58: fnd_api.g_miss_char,fnd_api.g_miss_num,
59: fnd_api.g_miss_char,fnd_api.g_miss_char,
60: fnd_api.g_miss_num,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_char,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);

Line 63: fnd_api.g_miss_char,fnd_api.g_miss_char,

59: fnd_api.g_miss_char,fnd_api.g_miss_char,
60: fnd_api.g_miss_num,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_char,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);
67: x_item:=inv_ebi_Item_Obj(l_main_item_obj,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,

Line 64: fnd_api.g_miss_char,fnd_api.g_miss_char,

60: fnd_api.g_miss_num,fnd_api.g_miss_char,
61: fnd_api.g_miss_num,fnd_api.g_miss_char,
62: fnd_api.g_miss_char,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);
67: x_item:=inv_ebi_Item_Obj(l_main_item_obj,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
68: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

Line 65: 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_char,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);
67: x_item:=inv_ebi_Item_Obj(l_main_item_obj,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
68: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
69: END IF;

Line 66: fnd_api.g_miss_char);

62: fnd_api.g_miss_char,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);
67: x_item:=inv_ebi_Item_Obj(l_main_item_obj,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
68: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
69: END IF;
70: IF(x_item.main_obj_type.item_number IS NULL OR x_item.main_obj_type.item_number = fnd_api.g_miss_char )THEN

Line 70: IF(x_item.main_obj_type.item_number IS NULL OR x_item.main_obj_type.item_number = fnd_api.g_miss_char )THEN

66: fnd_api.g_miss_char);
67: x_item:=inv_ebi_Item_Obj(l_main_item_obj,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,
68: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
69: END IF;
70: IF(x_item.main_obj_type.item_number IS NULL OR x_item.main_obj_type.item_number = fnd_api.g_miss_char )THEN
71: x_item.main_obj_type.item_number := p_revised_item.revised_item_name;
72: END IF;
73: IF(x_item.main_obj_type.organization_id IS NULL OR x_item.main_obj_type.organization_id = fnd_api.g_miss_num )THEN
74: IF((p_change_order_obj.organization_id IS NULL

Line 73: IF(x_item.main_obj_type.organization_id IS NULL OR x_item.main_obj_type.organization_id = fnd_api.g_miss_num )THEN

69: END IF;
70: IF(x_item.main_obj_type.item_number IS NULL OR x_item.main_obj_type.item_number = fnd_api.g_miss_char )THEN
71: x_item.main_obj_type.item_number := p_revised_item.revised_item_name;
72: END IF;
73: IF(x_item.main_obj_type.organization_id IS NULL OR x_item.main_obj_type.organization_id = fnd_api.g_miss_num )THEN
74: IF((p_change_order_obj.organization_id IS NULL
75: OR p_change_order_obj.organization_id = fnd_api.g_miss_num)
76: AND (p_change_order_obj.organization_code IS NOT NULL
77: OR p_change_order_obj.organization_code <> fnd_api.g_miss_char)) THEN

Line 75: OR p_change_order_obj.organization_id = fnd_api.g_miss_num)

71: x_item.main_obj_type.item_number := p_revised_item.revised_item_name;
72: END IF;
73: IF(x_item.main_obj_type.organization_id IS NULL OR x_item.main_obj_type.organization_id = fnd_api.g_miss_num )THEN
74: IF((p_change_order_obj.organization_id IS NULL
75: OR p_change_order_obj.organization_id = fnd_api.g_miss_num)
76: AND (p_change_order_obj.organization_code IS NOT NULL
77: OR p_change_order_obj.organization_code <> fnd_api.g_miss_char)) THEN
78: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
79: l_pk_col_name_val_pairs.EXTEND(1);

Line 77: OR p_change_order_obj.organization_code <> fnd_api.g_miss_char)) THEN

73: IF(x_item.main_obj_type.organization_id IS NULL OR x_item.main_obj_type.organization_id = fnd_api.g_miss_num )THEN
74: IF((p_change_order_obj.organization_id IS NULL
75: OR p_change_order_obj.organization_id = fnd_api.g_miss_num)
76: AND (p_change_order_obj.organization_code IS NOT NULL
77: OR p_change_order_obj.organization_code <> fnd_api.g_miss_char)) THEN
78: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
79: l_pk_col_name_val_pairs.EXTEND(1);
80: l_pk_col_name_val_pairs(1).name := 'organization_code';
81: l_pk_col_name_val_pairs(1).value := p_change_order_obj.organization_code;

Line 91: RAISE FND_API.G_EXC_ERROR;

87: IF (x_item.main_obj_type.organization_id IS NULL) THEN
88: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
89: FND_MESSAGE.set_token('COL_VALUE', p_change_order_obj.organization_code);
90: FND_MSG_PUB.add;
91: RAISE FND_API.G_EXC_ERROR;
92: END IF;
93: ELSE
94: x_item.main_obj_type.organization_id := p_change_order_obj.organization_id;
95: END IF;

Line 98: 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

94: x_item.main_obj_type.organization_id := p_change_order_obj.organization_id;
95: END IF;
96: END IF;
97:
98: 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
99: x_item.main_obj_type.init_msg_list := FND_API.G_TRUE;
100: END IF;
101: EXCEPTION
102: WHEN FND_API.g_exc_error THEN

Line 99: x_item.main_obj_type.init_msg_list := FND_API.G_TRUE;

95: END IF;
96: END IF;
97:
98: 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
99: x_item.main_obj_type.init_msg_list := FND_API.G_TRUE;
100: END IF;
101: EXCEPTION
102: WHEN FND_API.g_exc_error THEN
103: x_out.output_status.return_status := FND_API.g_ret_sts_error;

Line 102: WHEN FND_API.g_exc_error THEN

98: 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
99: x_item.main_obj_type.init_msg_list := FND_API.G_TRUE;
100: END IF;
101: EXCEPTION
102: WHEN FND_API.g_exc_error THEN
103: x_out.output_status.return_status := FND_API.g_ret_sts_error;
104: IF(x_out.output_status.msg_data IS NULL) THEN
105: FND_MSG_PUB.count_and_get(
106: p_encoded => FND_API.g_false

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

99: x_item.main_obj_type.init_msg_list := FND_API.G_TRUE;
100: END IF;
101: EXCEPTION
102: WHEN FND_API.g_exc_error THEN
103: x_out.output_status.return_status := FND_API.g_ret_sts_error;
104: IF(x_out.output_status.msg_data IS NULL) THEN
105: FND_MSG_PUB.count_and_get(
106: p_encoded => FND_API.g_false
107: ,p_count => x_out.output_status.msg_count

Line 106: p_encoded => FND_API.g_false

102: WHEN FND_API.g_exc_error THEN
103: x_out.output_status.return_status := FND_API.g_ret_sts_error;
104: IF(x_out.output_status.msg_data IS NULL) THEN
105: FND_MSG_PUB.count_and_get(
106: p_encoded => FND_API.g_false
107: ,p_count => x_out.output_status.msg_count
108: ,p_data => x_out.output_status.msg_data
109: );
110: END IF;

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

108: ,p_data => x_out.output_status.msg_data
109: );
110: END IF;
111: WHEN OTHERS THEN
112: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
113: IF (x_out.output_status.msg_data IS NOT NULL) THEN
114: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes ';
115: ELSE
116: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.populate_item_attributes ';

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

138: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
139:
140: BEGIN
141: SAVEPOINT inv_ebi_engg_item_save_pnt;
142: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
143: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
144:
145: IF(p_item.main_obj_type.inventory_item_id IS NULL OR
146: p_item.main_obj_type.inventory_item_id = fnd_api.g_miss_num) THEN

Line 146: p_item.main_obj_type.inventory_item_id = fnd_api.g_miss_num) THEN

142: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
143: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
144:
145: IF(p_item.main_obj_type.inventory_item_id IS NULL OR
146: p_item.main_obj_type.inventory_item_id = fnd_api.g_miss_num) THEN
147:
148: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
149: l_pk_col_name_val_pairs.EXTEND(2);
150: l_pk_col_name_val_pairs(1).name := 'concatenated_segments';

Line 164: RAISE FND_API.g_exc_unexpected_error;

160: IF (l_inventory_item_id IS NULL ) THEN
161: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_INVALID');
162: FND_MESSAGE.set_token('COL_VALUE', p_item.main_obj_type.item_number);
163: FND_MSG_PUB.add;
164: RAISE FND_API.g_exc_unexpected_error;
165: END IF;
166: ELSE
167: l_inventory_item_id := p_item.main_obj_type.inventory_item_id;
168:

Line 172: AND l_inventory_item_id <> fnd_api.g_miss_num)

168:
169: END IF;
170:
171: IF((l_inventory_item_id IS NOT NULL
172: AND l_inventory_item_id <> fnd_api.g_miss_num)
173: AND (p_item.main_obj_type.organization_id IS NOT NULL
174: AND p_item.main_obj_type.organization_id <> fnd_api.g_miss_num)) THEN
175:
176: SELECT approval_status INTO l_approval_status

Line 174: AND p_item.main_obj_type.organization_id <> fnd_api.g_miss_num)) THEN

170:
171: IF((l_inventory_item_id IS NOT NULL
172: AND l_inventory_item_id <> fnd_api.g_miss_num)
173: AND (p_item.main_obj_type.organization_id IS NOT NULL
174: AND p_item.main_obj_type.organization_id <> fnd_api.g_miss_num)) THEN
175:
176: SELECT approval_status INTO l_approval_status
177: FROM mtl_system_items_b
178: WHERE inventory_item_id = l_inventory_item_id

Line 187: IF(l_is_engineering_item = FND_API.g_true

183: p_organization_id => p_item.main_obj_type.organization_id
184: ,p_item_number => p_item.main_obj_type.item_number
185: );
186:
187: IF(l_is_engineering_item = FND_API.g_true
188: AND l_approval_status = 'A'
189: AND p_item.bom_obj_type.eng_item_flag = 'N'
190: ) THEN
191:

Line 194: IF(p_alt_bom_designator IS NULL OR p_alt_bom_designator = fnd_api.g_miss_char ) THEN

190: ) THEN
191:
192: --Transfer Engg Item to Manufacturing
193: -- If alt_bom_code is null then transfer all boms,if not transfer only that particular bom
194: IF(p_alt_bom_designator IS NULL OR p_alt_bom_designator = fnd_api.g_miss_char ) THEN
195: l_designator_option := 1;
196: l_alt_bom_designator := NULL;
197: ELSE
198: l_designator_option := 3;

Line 244: WHEN FND_API.g_exc_unexpected_error THEN

240: x_commit => FALSE
241: );
242: END IF;
243: EXCEPTION
244: WHEN FND_API.g_exc_unexpected_error THEN
245: ROLLBACK TO inv_ebi_engg_item_save_pnt;
246: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
247: IF(x_out.output_status.msg_data IS NULL) THEN
248: FND_MSG_PUB.count_and_get(

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

242: END IF;
243: EXCEPTION
244: WHEN FND_API.g_exc_unexpected_error THEN
245: ROLLBACK TO inv_ebi_engg_item_save_pnt;
246: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
247: IF(x_out.output_status.msg_data IS NULL) THEN
248: FND_MSG_PUB.count_and_get(
249: p_encoded => FND_API.g_false
250: ,p_count => x_out.output_status.msg_count

Line 249: p_encoded => FND_API.g_false

245: ROLLBACK TO inv_ebi_engg_item_save_pnt;
246: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
247: IF(x_out.output_status.msg_data IS NULL) THEN
248: FND_MSG_PUB.count_and_get(
249: p_encoded => FND_API.g_false
250: ,p_count => x_out.output_status.msg_count
251: ,p_data => x_out.output_status.msg_data
252: );
253: END IF;

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

252: );
253: END IF;
254: WHEN OTHERS THEN
255: ROLLBACK TO inv_ebi_engg_item_save_pnt;
256: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
257: IF (x_out.output_status.msg_data IS NOT NULL) THEN
258: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_manufacturing ';
259: ELSE
260: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.transfer_engg_item_manufacturing ';

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

278: l_is_component_item_exists VARCHAR2(3);
279: l_pk_col_name_val_pairs INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl;
280: l_output_status inv_ebi_output_status;
281: BEGIN
282: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
283: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
284: l_pk_col_name_val_pairs := INV_EBI_ITEM_HELPER.inv_ebi_name_value_pair_tbl();
285: l_pk_col_name_val_pairs.EXTEND(1);
286: l_pk_col_name_val_pairs(1).name := 'organization_code';

Line 296: RAISE FND_API.g_exc_error;

292: IF (l_organization_id IS NULL) THEN
293: FND_MESSAGE.set_name('INV','INV_EBI_ORG_CODE_INVALID');
294: FND_MESSAGE.set_token('COL_VALUE',p_organization_code);
295: FND_MSG_PUB.add;
296: RAISE FND_API.g_exc_error;
297: END IF;
298: l_is_master_org := INV_EBI_UTIL.is_master_org(l_organization_id);
299: IF(p_component_item_tbl IS NOT NULL AND p_component_item_tbl.COUNT > 0) THEN
300: FOR i IN 1.. p_component_item_tbl.COUNT LOOP

Line 307: IF(l_is_master_org = fnd_api.g_true AND l_is_component_item_exists = fnd_api.g_false) THEN

303: l_is_component_item_exists := INV_EBI_ITEM_HELPER.is_item_exists(
304: p_organization_id => l_organization_id
305: ,p_item_number => l_component_item_name
306: );
307: IF(l_is_master_org = fnd_api.g_true AND l_is_component_item_exists = fnd_api.g_false) THEN
308: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
309: FND_MESSAGE.set_token('COMP_ITEM', l_component_item_name);
310: FND_MSG_PUB.add;
311: RAISE FND_API.g_exc_error;

Line 311: RAISE FND_API.g_exc_error;

307: IF(l_is_master_org = fnd_api.g_true AND l_is_component_item_exists = fnd_api.g_false) THEN
308: FND_MESSAGE.set_name('INV','INV_EBI_ITEM_NO_MASTER_ORG');
309: FND_MESSAGE.set_token('COMP_ITEM', l_component_item_name);
310: FND_MSG_PUB.add;
311: RAISE FND_API.g_exc_error;
312: END IF;
313: END IF;
314: END LOOP;
315: END IF;

Line 317: WHEN FND_API.g_exc_error THEN

313: END IF;
314: END LOOP;
315: END IF;
316: EXCEPTION
317: WHEN FND_API.g_exc_error THEN
318: x_out.output_status.return_status := FND_API.g_ret_sts_error;
319: IF(x_out.output_status.msg_data IS NULL) THEN
320: FND_MSG_PUB.count_and_get(
321: p_encoded => FND_API.g_false

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

314: END LOOP;
315: END IF;
316: EXCEPTION
317: WHEN FND_API.g_exc_error THEN
318: x_out.output_status.return_status := FND_API.g_ret_sts_error;
319: IF(x_out.output_status.msg_data IS NULL) THEN
320: FND_MSG_PUB.count_and_get(
321: p_encoded => FND_API.g_false
322: ,p_count => x_out.output_status.msg_count

Line 321: p_encoded => FND_API.g_false

317: WHEN FND_API.g_exc_error THEN
318: x_out.output_status.return_status := FND_API.g_ret_sts_error;
319: IF(x_out.output_status.msg_data IS NULL) THEN
320: FND_MSG_PUB.count_and_get(
321: p_encoded => FND_API.g_false
322: ,p_count => x_out.output_status.msg_count
323: ,p_data => x_out.output_status.msg_data
324: );
325: END IF;

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

323: ,p_data => x_out.output_status.msg_data
324: );
325: END IF;
326: WHEN OTHERS THEN
327: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
328: IF (x_out.output_status.msg_data IS NOT NULL) THEN
329: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.validate_component_items ';
330: ELSE
331: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.validate_component_items ';

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

347: l_item_output inv_ebi_item_output_obj;
348: l_transaction_type VARCHAR2(20);
349: l_organization_id NUMBER;
350: BEGIN
351: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
352: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
353: FND_MSG_PUB.initialize;
354: IF p_eco_obj.eco_revised_item_type IS NOT NULL THEN
355: FOR i IN 1..p_eco_obj.eco_revised_item_type.COUNT LOOP

Line 363: ) = FND_API.g_false ) THEN

359: );
360: IF(INV_EBI_ITEM_HELPER.is_item_exists (
361: p_organization_id => l_organization_id
362: ,p_item_number => p_eco_obj.eco_revised_item_type(i).revised_item_name
363: ) = FND_API.g_false ) THEN
364: l_transaction_type := INV_EBI_ITEM_PUB.g_otype_create;
365: INV_EBI_ITEM_PUB.validate_item (
366: p_transaction_type => l_transaction_type
367: ,p_item => p_eco_obj.eco_revised_item_type(i).item

Line 370: IF(l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN

366: p_transaction_type => l_transaction_type
367: ,p_item => p_eco_obj.eco_revised_item_type(i).item
368: ,x_out => l_item_output
369: ) ;
370: IF(l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN
371: RAISE FND_API.g_exc_unexpected_error;
372: END IF;
373: END IF;
374: END IF;

Line 371: RAISE FND_API.g_exc_unexpected_error;

367: ,p_item => p_eco_obj.eco_revised_item_type(i).item
368: ,x_out => l_item_output
369: ) ;
370: IF(l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN
371: RAISE FND_API.g_exc_unexpected_error;
372: END IF;
373: END IF;
374: END IF;
375: END LOOP;

Line 378: WHEN FND_API.g_exc_unexpected_error THEN

374: END IF;
375: END LOOP;
376: END IF;
377: EXCEPTION
378: WHEN FND_API.g_exc_unexpected_error THEN
379: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
380: IF(x_out.output_status.msg_data IS NULL) THEN
381: FND_MSG_PUB.count_and_get(
382: p_encoded => FND_API.g_false

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

375: END LOOP;
376: END IF;
377: EXCEPTION
378: WHEN FND_API.g_exc_unexpected_error THEN
379: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
380: IF(x_out.output_status.msg_data IS NULL) THEN
381: FND_MSG_PUB.count_and_get(
382: p_encoded => FND_API.g_false
383: ,p_count => x_out.output_status.msg_count

Line 382: p_encoded => FND_API.g_false

378: WHEN FND_API.g_exc_unexpected_error THEN
379: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
380: IF(x_out.output_status.msg_data IS NULL) THEN
381: FND_MSG_PUB.count_and_get(
382: p_encoded => FND_API.g_false
383: ,p_count => x_out.output_status.msg_count
384: ,p_data => x_out.output_status.msg_data
385: );
386: END IF;

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

384: ,p_data => x_out.output_status.msg_data
385: );
386: END IF;
387: WHEN OTHERS THEN
388: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
389: IF (x_out.output_status.msg_data IS NOT NULL) THEN
390: x_out.output_status.msg_data := x_out.output_status.msg_data ||' -> INV_EBI_CHANGE_ORDER_PUB.validate_eco ';
391: ELSE
392: x_out.output_status.msg_data := SQLERRM||' INV_EBI_CHANGE_ORDER_PUB.validate_eco ';

Line 491: p_commit IN VARCHAR2 := FND_API.g_false

487: --
488: ************************************************************************************/
489:
490: PROCEDURE process_change_order(
491: p_commit IN VARCHAR2 := FND_API.g_false
492: ,p_eco_obj IN inv_ebi_eco_obj
493: ,x_out OUT NOCOPY inv_ebi_eco_output_obj
494: ) IS
495: l_change_id NUMBER;

Line 517: l_assign_item_to_child_org VARCHAR2(1):= fnd_api.g_false;

513: l_is_wf_Set BOOLEAN;
514: l_item_obj_tbl inv_ebi_item_attr_tbl;
515: l_item_count NUMBER :=0;
516: l_update_item_count NUMBER :=0;
517: l_assign_item_to_child_org VARCHAR2(1):= fnd_api.g_false;
518: l_update_item_tab FND_TABLE_OF_NUMBER;
519: l_update_item_index NUMBER := 0;
520: l_cnt_nmval NUMBER := 0;
521: l_revitem_output_tbl inv_ebi_revitem_output_obj_tbl;

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

546: --fnd_global.apps_initialize(1068,56229,724,0);
547: l_uda_output := inv_ebi_uda_output_obj(NULL,NULL);
548: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order');
549: l_category_output := inv_ebi_category_output_obj(NULL);
550: l_output_status := inv_ebi_output_status(fnd_api.g_ret_sts_success,NULL,NULL,NULL);
551: x_out := inv_ebi_eco_output_obj(NULL,NULL,NULL,NULL,l_output_status,NULL,NULL);
552: l_item_output_tbl := inv_ebi_item_output_tbl();
553: l_item_obj_tbl := inv_ebi_item_attr_tbl();
554: l_update_item_tab := FND_TABLE_OF_NUMBER();

Line 568: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

564: ,p_revised_item => l_eco_obj_validate_eco.eco_revised_item_type(i)
565: ,x_item => l_item
566: ,x_out => l_out
567: );
568: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
569: x_out.output_status.msg_data := l_out.output_status.msg_data;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: INV_EBI_ITEM_HELPER.populate_item_ids(

Line 570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

566: ,x_out => l_out
567: );
568: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
569: x_out.output_status.msg_data := l_out.output_status.msg_data;
570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
571: END IF;
572: INV_EBI_ITEM_HELPER.populate_item_ids(
573: p_item => l_item
574: ,x_out => l_item_output

Line 577: IF (l_item_output.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

573: p_item => l_item
574: ,x_out => l_item_output
575: ,x_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item
576: );
577: IF (l_item_output.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
578: x_out.output_status.msg_data := l_item_output.OUTPUT_STATUS.MSG_DATA;
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: END IF;
581: END LOOP;

Line 579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

575: ,x_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item
576: );
577: IF (l_item_output.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
578: x_out.output_status.msg_data := l_item_output.OUTPUT_STATUS.MSG_DATA;
579: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
580: END IF;
581: END LOOP;
582: END IF;
583: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_CHANGE_ORDER_PUB.validate_eco');

Line 590: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

586: p_eco_obj => l_eco_obj_validate_eco
587: ,x_out => l_out
588: );
589: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_CHANGE_ORDER_PUB.validate_eco');
590: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
591: x_out.output_status.msg_data := l_out.output_Status.msg_data;
592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
593: END IF;
594: IF(l_eco_obj_validate_eco.eco_revised_item_type IS NOT NULL AND l_eco_obj_validate_eco.eco_change_order_type IS NOT NULL) THEN

Line 592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

588: );
589: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_CHANGE_ORDER_PUB.validate_eco');
590: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
591: x_out.output_status.msg_data := l_out.output_Status.msg_data;
592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
593: END IF;
594: IF(l_eco_obj_validate_eco.eco_revised_item_type IS NOT NULL AND l_eco_obj_validate_eco.eco_change_order_type IS NOT NULL) THEN
595: FOR i IN 1 .. l_eco_obj_validate_eco.eco_revised_item_type.COUNT
596: LOOP

Line 614: ) = FND_API.g_false ) THEN

610: l_revision_set := FALSE;
611: IF( INV_EBI_ITEM_HELPER.is_item_exists (
612: p_organization_id => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.organization_id
613: ,p_item_number => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.item_number
614: ) = FND_API.g_false ) THEN
615:
616: /* Bug 7197943 After subsequent release of ecos in master org ,If Chnage Order is released in Child Org
617: then we should create initial rev,current rev of the item in master org through process_item API
618: and incoming revision through process_eco API */

Line 622: ) = fnd_api.g_true) THEN

618: and incoming revision through process_eco API */
619:
620: IF(INV_EBI_CHANGE_ORDER_HELPER.is_child_org (
621: p_organization_id => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.organization_id
622: ) = fnd_api.g_true) THEN
623:
624: l_master_org := INV_EBI_UTIL.get_master_organization(
625: p_organization_id => l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.organization_id
626: );

Line 640: l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.revision_code := fnd_api.g_miss_char;

636: p_date => sysdate
637: );
638:
639: IF(l_current_revision = l_eco_obj_validate_eco.eco_revised_item_type(i).new_revised_item_revision ) THEN
640: l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.revision_code := fnd_api.g_miss_char;
641: ELSIF( l_current_revision <> l_eco_obj_validate_eco.eco_revised_item_type(i).new_revised_item_revision AND
642: l_current_revision < l_eco_obj_validate_eco.eco_revised_item_type(i).new_revised_item_revision ) THEN
643:
644: l_eco_obj_validate_eco.eco_revised_item_type(i).item.main_obj_type.revision_code := l_current_revision;

Line 656: p_commit => FND_API.g_false

652:
653: --call Create New Production Item API .This will also process existing item information.
654: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_ITEM_HELPER.sync_item');
655: INV_EBI_ITEM_HELPER.sync_item(
656: p_commit => FND_API.g_false
657: ,p_operation => INV_EBI_ITEM_PUB.g_otype_create
658: ,p_item => l_eco_obj_validate_eco.eco_revised_item_type(i).item
659: ,x_out => l_item_output
660: );

Line 666: IF (l_item_output.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

662: l_item_count := l_item_count + 1;
663: l_item_output_tbl.EXTEND(1);
664: l_item_output_tbl(l_item_count) := l_item_output;
665:
666: IF (l_item_output.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
667: x_out.output_status.msg_data := l_item_output.output_status.msg_data;
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:

Line 668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

664: l_item_output_tbl(l_item_count) := l_item_output;
665:
666: IF (l_item_output.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
667: x_out.output_status.msg_data := l_item_output.output_status.msg_data;
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:
671: /* Bug 7197943 When we create 2 revison thru EGO_ITEM_pUB.process_item API
672: they are adding sysdate + 1 sec to initial rev and given rev gets created

Line 723: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

719: ,p_alt_bom_designator => l_eco_obj_validate_eco.eco_revised_item_type(i).alternate_bom_code
720: ,x_out => l_out
721: );
722: INV_EBI_UTIL.debug_line('STEP: 90 END CALLING transfer_engg_item_mfg');
723: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
724: x_out.output_status.msg_data := l_out.output_status.msg_data;
725: RAISE fnd_api.g_exc_unexpected_error;
726: END IF;
727:

Line 725: RAISE fnd_api.g_exc_unexpected_error;

721: );
722: INV_EBI_UTIL.debug_line('STEP: 90 END CALLING transfer_engg_item_mfg');
723: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
724: x_out.output_status.msg_data := l_out.output_status.msg_data;
725: RAISE fnd_api.g_exc_unexpected_error;
726: END IF;
727:
728: END IF;
729: END LOOP;

Line 750: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

746: ,x_eco_obj => l_eco_obj
747: ,x_out => l_out
748: );
749: INV_EBI_UTIL.debug_line('STEP: 110 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');
750: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
751: x_out.output_status.msg_data := l_out.output_status.msg_data;
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;
754:

Line 752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

748: );
749: INV_EBI_UTIL.debug_line('STEP: 110 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_replicate_bom');
750: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
751: x_out.output_status.msg_data := l_out.output_status.msg_data;
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: END IF;
754:
755: IF(l_eco_obj.eco_revised_item_type IS NOT NULL AND l_eco_obj.eco_change_order_type IS NOT NULL) THEN
756: FOR i IN 1 .. l_eco_obj.eco_revised_item_type.COUNT

Line 764: p_commit => FND_API.g_false

760: INV_EBI_UTIL.debug_line('STEP: 120 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header'||
761: ' For Revised Item Name: '||l_eco_obj.eco_revised_item_type(i).revised_item_name);
762:
763: INV_EBI_CHANGE_ORDER_HELPER.process_structure_header(
764: p_commit => FND_API.g_false
765: ,p_organization_code => l_eco_obj.eco_change_order_type.organization_code
766: ,p_assembly_item_name => l_eco_obj.eco_revised_item_type(i).revised_item_name
767: ,p_alternate_bom_code => l_eco_obj.eco_revised_item_type(i).alternate_bom_code
768: ,p_structure_header => l_eco_obj.eco_revised_item_type(i).structure_header

Line 776: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

772: );
773: INV_EBI_UTIL.debug_line('STEP: 130 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_structure_header'||
774: ' For Revised Item Name: '||l_eco_obj.eco_revised_item_type(i).revised_item_name);
775: END IF;
776: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
777: x_out.output_status.msg_data := l_out.output_status.msg_data;
778: RAISE FND_API.g_exc_unexpected_error;
779: END IF;
780: END LOOP;

Line 778: RAISE FND_API.g_exc_unexpected_error;

774: ' For Revised Item Name: '||l_eco_obj.eco_revised_item_type(i).revised_item_name);
775: END IF;
776: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
777: x_out.output_status.msg_data := l_out.output_status.msg_data;
778: RAISE FND_API.g_exc_unexpected_error;
779: END IF;
780: END LOOP;
781: END IF;
782: bom_globals.set_bo_identifier(bom_globals.g_eco_bo);

Line 786: p_commit => FND_API.g_false

782: bom_globals.set_bo_identifier(bom_globals.g_eco_bo);
783: --Change Order Creation
784: INV_EBI_UTIL.debug_line('STEP: 140 START CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');
785: INV_EBI_CHANGE_ORDER_HELPER.process_eco(
786: p_commit => FND_API.g_false
787: ,p_change_order => l_eco_obj.eco_change_order_type
788: ,p_revision_type_tbl => l_eco_obj.eco_revision_type
789: ,p_revised_item_type_tbl => l_eco_obj.eco_revised_item_type
790: ,p_name_val_list => inv_ebi_name_value_list(l_eco_obj.name_value_tbl)

Line 794: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

790: ,p_name_val_list => inv_ebi_name_value_list(l_eco_obj.name_value_tbl)
791: ,x_out => l_out
792: );
793: INV_EBI_UTIL.debug_line('STEP: 150 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');
794: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
795: x_out.output_status.msg_data := l_out.output_status.msg_data;
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;
798:

Line 796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

792: );
793: INV_EBI_UTIL.debug_line('STEP: 150 END CALLING INV_EBI_CHANGE_ORDER_HELPER.process_eco');
794: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
795: x_out.output_status.msg_data := l_out.output_status.msg_data;
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;
798:
799: l_change_id := l_out.change_id;
800: l_change_notice := l_out.change_notice;

Line 840: ,p_commit => FND_API.g_false

836: INV_EBI_UTIL.debug_line('STEP: 160 START CALLING ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase');
837:
838: ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase(
839: p_api_version => 1.0
840: ,p_commit => FND_API.g_false
841: ,p_object_name => 'ENG_CHANGE'
842: ,p_change_id => l_change_id
843: ,p_status_code => l_status_code
844: ,p_action_type => ENG_CHANGE_LIFECYCLE_UTIL.G_ENG_PROMOTE -- promote/demote

Line 850: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

846: ,x_msg_count => l_out.output_status.msg_count
847: ,x_msg_data => l_out.output_status.msg_data
848: );
849: INV_EBI_UTIL.debug_line('STEP: 170 END CALLING ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase');
850: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
851: x_out.output_status.msg_data := l_out.output_status.msg_data;
852: RAISE FND_API.g_exc_unexpected_error;
853: END IF;
854: END IF;

Line 852: RAISE FND_API.g_exc_unexpected_error;

848: );
849: INV_EBI_UTIL.debug_line('STEP: 170 END CALLING ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase');
850: IF (l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
851: x_out.output_status.msg_data := l_out.output_status.msg_data;
852: RAISE FND_API.g_exc_unexpected_error;
853: END IF;
854: END IF;
855:
856: --Processing of Udas

Line 861: AND (l_eco_obj.eco_change_order_type.organization_id IS NULL OR l_eco_obj.eco_change_order_type.organization_id =FND_API.g_miss_num)

857: IF (INV_EBI_UTIL.is_pim_installed) THEN
858: IF ((l_eco_obj.eco_change_order_type IS NOT NULL AND l_eco_obj.eco_change_order_type.change_order_uda IS NOT NULL)
859: AND l_eco_obj.eco_change_order_type.change_order_uda.attribute_group_tbl.COUNT > 0) THEN
860: IF ((l_eco_obj.eco_change_order_type.eco_name IS NOT NULL)
861: AND (l_eco_obj.eco_change_order_type.organization_id IS NULL OR l_eco_obj.eco_change_order_type.organization_id =FND_API.g_miss_num)
862: AND (l_eco_obj.eco_change_order_type.organization_code IS NOT NULL OR l_eco_obj.eco_change_order_type.organization_code <> FND_API.g_miss_char)) THEN
863:
864: SELECT change_order_type_id INTO l_change_order_type_id
865: FROM eng_engineering_changes

Line 862: AND (l_eco_obj.eco_change_order_type.organization_code IS NOT NULL OR l_eco_obj.eco_change_order_type.organization_code <> FND_API.g_miss_char)) THEN

858: IF ((l_eco_obj.eco_change_order_type IS NOT NULL AND l_eco_obj.eco_change_order_type.change_order_uda IS NOT NULL)
859: AND l_eco_obj.eco_change_order_type.change_order_uda.attribute_group_tbl.COUNT > 0) THEN
860: IF ((l_eco_obj.eco_change_order_type.eco_name IS NOT NULL)
861: AND (l_eco_obj.eco_change_order_type.organization_id IS NULL OR l_eco_obj.eco_change_order_type.organization_id =FND_API.g_miss_num)
862: AND (l_eco_obj.eco_change_order_type.organization_code IS NOT NULL OR l_eco_obj.eco_change_order_type.organization_code <> FND_API.g_miss_char)) THEN
863:
864: SELECT change_order_type_id INTO l_change_order_type_id
865: FROM eng_engineering_changes
866: WHERE change_notice = l_eco_obj.eco_change_order_type.eco_name

Line 880: ,p_commit => fnd_api.g_false

876:
877: --To process Change order header udas
878: INV_EBI_CHANGE_ORDER_HELPER.process_uda(
879: p_uda_input_obj => l_eco_obj.eco_change_order_type.change_order_uda
880: ,p_commit => fnd_api.g_false
881: ,p_object_name => 'ENG_CHANGE'
882: ,p_data_level => 'CHANGE_LEVEL'
883: ,p_pk_column_name_value_pairs => l_pkdata
884: ,p_class_code_name_value_pairs => l_pkcode

Line 888: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN

884: ,p_class_code_name_value_pairs => l_pkcode
885: ,x_uda_output_obj => l_out
886: );
887: END IF;
888: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
889: x_out.output_status.msg_data := l_out.output_status.msg_data;
890: RAISE fnd_api.g_exc_unexpected_error;
891: END IF;
892: l_uda_output := inv_ebi_uda_output_obj(l_out.uda_output.failed_row_id_list,l_out.uda_output.errorcode);

Line 890: RAISE fnd_api.g_exc_unexpected_error;

886: );
887: END IF;
888: IF(l_out.output_status.return_status <> FND_API.G_RET_STS_SUCCESS) THEN
889: x_out.output_status.msg_data := l_out.output_status.msg_data;
890: RAISE fnd_api.g_exc_unexpected_error;
891: END IF;
892: l_uda_output := inv_ebi_uda_output_obj(l_out.uda_output.failed_row_id_list,l_out.uda_output.errorcode);
893: IF(l_eco_obj.eco_revised_item_type IS NOT NULL AND l_eco_obj.eco_revised_item_type.COUNT > 0) THEN
894: FOR i IN 1..l_eco_obj.eco_revised_item_type.COUNT

Line 915: ,p_commit => fnd_api.g_false

911: ,p_item_catalog_group_id => l_eco_obj.eco_revised_item_type(i).item.main_obj_type.item_catalog_group_id
912: ,p_revision_id => NULL
913: ,p_revision_code => l_eco_obj.eco_revised_item_type(i).new_revised_item_revision
914: ,p_uda_input_obj => l_eco_obj.eco_revised_item_type(i).item.uda_type
915: ,p_commit => fnd_api.g_false
916: ,x_uda_output_obj => l_item_output
917: );
918: END IF;
919:

Line 920: IF (l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN

916: ,x_uda_output_obj => l_item_output
917: );
918: END IF;
919:
920: IF (l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN
921: x_out.output_status.return_status := l_item_output.output_status.msg_data;
922: RAISE FND_API.g_exc_unexpected_error;
923: END IF;
924:

Line 922: RAISE FND_API.g_exc_unexpected_error;

918: END IF;
919:
920: IF (l_item_output.output_status.return_status <> FND_API.g_ret_sts_success) THEN
921: x_out.output_status.return_status := l_item_output.output_status.msg_data;
922: RAISE FND_API.g_exc_unexpected_error;
923: END IF;
924:
925: l_uda_output := inv_ebi_uda_output_obj(l_item_output.uda_output.failed_row_id_list,l_item_output.uda_output.errorcode);
926: -- To process Component level udas and structure header level udas

Line 928: p_commit => FND_API.g_false

924:
925: l_uda_output := inv_ebi_uda_output_obj(l_item_output.uda_output.failed_row_id_list,l_item_output.uda_output.errorcode);
926: -- To process Component level udas and structure header level udas
927: INV_EBI_CHANGE_ORDER_HELPER.process_change_order_uda(
928: p_commit => FND_API.g_false
929: ,p_organization_code => l_eco_obj.eco_change_order_type.organization_code
930: ,p_eco_name => l_eco_obj.eco_change_order_type.eco_name
931: ,p_alternate_bom_code => l_eco_obj.eco_revised_item_type(i).alternate_bom_code
932: ,p_revised_item_name => l_eco_obj.eco_revised_item_type(i).revised_item_name

Line 937: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN

933: ,p_component_tbl => l_eco_obj.eco_revised_item_type(i).component_item_tbl
934: ,p_structure_header => l_eco_obj.eco_revised_item_type(i).structure_header
935: ,x_out => l_out
936: );
937: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
938: x_out.output_status.return_status := l_out.output_status.msg_data;
939: RAISE FND_API.g_exc_unexpected_error;
940: END IF;
941: END LOOP;

Line 939: RAISE FND_API.g_exc_unexpected_error;

935: ,x_out => l_out
936: );
937: IF (l_out.output_status.return_status <> FND_API.g_ret_sts_success) THEN
938: x_out.output_status.return_status := l_out.output_status.msg_data;
939: RAISE FND_API.g_exc_unexpected_error;
940: END IF;
941: END LOOP;
942: END IF;
943: l_uda_output := inv_ebi_uda_output_obj(l_out.uda_output.failed_row_id_list,l_out.uda_output.errorcode);

Line 952: p_commit => FND_API.g_false

948: FOR j in 1..l_item_obj_tbl.COUNT LOOP
949: l_update_item_index := l_update_item_tab(j);
950: INV_EBI_UTIL.debug_line('STEP: 180 START CALLING INV_EBI_ITEM_HELPER.sync_item');
951: INV_EBI_ITEM_HELPER.sync_item(
952: p_commit => FND_API.g_false
953: ,p_operation => INV_EBI_ITEM_PUB.g_otype_update
954: ,p_item => l_item_obj_tbl(j).item_obj
955: ,x_out => l_item_output
956: );

Line 960: IF (l_item_output.output_status.return_status <> fnd_api.g_ret_sts_success) THEN

956: );
957: INV_EBI_UTIL.debug_line('STEP: 190 END CALLING INV_EBI_ITEM_HELPER.sync_item');
958: l_item_output_tbl(l_update_item_index) := l_item_output;
959:
960: IF (l_item_output.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
961: x_out.output_status.msg_data := l_item_output.output_status.msg_data;
962: RAISE fnd_api.g_exc_unexpected_error;
963: END IF;
964: END LOOP;

Line 962: RAISE fnd_api.g_exc_unexpected_error;

958: l_item_output_tbl(l_update_item_index) := l_item_output;
959:
960: IF (l_item_output.output_status.return_status <> fnd_api.g_ret_sts_success) THEN
961: x_out.output_status.msg_data := l_item_output.output_status.msg_data;
962: RAISE fnd_api.g_exc_unexpected_error;
963: END IF;
964: END LOOP;
965: INV_EBI_UTIL.debug_line('STEP: 200 START CALLING populate_revised_items_out');
966:

Line 977: IF FND_API.to_boolean(p_commit) THEN

973:
974: x_out := inv_ebi_eco_output_obj(l_change_notice,l_change_id,l_organization_id,l_organization_code,
975: l_item_output.output_status,l_revitem_output_tbl,l_uda_output);
976: INV_EBI_UTIL.debug_line('STEP: 200 END CALLING populate_revised_items_out');
977: IF FND_API.to_boolean(p_commit) THEN
978: COMMIT;
979: END IF;
980: INV_EBI_UTIL.debug_line('STEP: 210 END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order');
981: EXCEPTION

Line 982: WHEN FND_API.g_exc_unexpected_error THEN

978: COMMIT;
979: END IF;
980: INV_EBI_UTIL.debug_line('STEP: 210 END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order');
981: EXCEPTION
982: WHEN FND_API.g_exc_unexpected_error THEN
983: ROLLBACK TO inv_ebi_chg_order_save_pnt;
984: IF c_effectivity_date%ISOPEN THEN
985: CLOSE c_effectivity_date;
986: END IF;

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

983: ROLLBACK TO inv_ebi_chg_order_save_pnt;
984: IF c_effectivity_date%ISOPEN THEN
985: CLOSE c_effectivity_date;
986: END IF;
987: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
988: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
989: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
990: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
991: IF(x_out.output_status.msg_data IS NULL) THEN

Line 993: p_encoded => FND_API.g_false

989: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
990: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
991: IF(x_out.output_status.msg_data IS NULL) THEN
992: FND_MSG_PUB.count_and_get(
993: p_encoded => FND_API.g_false
994: ,p_count => x_out.output_status.msg_count
995: ,p_data => x_out.output_status.msg_data
996: );
997: END IF;

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

1002: CLOSE c_effectivity_date;
1003: END IF;
1004:
1005: x_out.output_status.error_table := INV_EBI_UTIL.get_error_table();
1006: x_out.output_status.return_status := FND_API.g_ret_sts_unexp_error;
1007: IF (x_out.output_status.error_table IS NOT NULL AND x_out.output_status.error_table.COUNT > 0) THEN
1008: x_out.output_status.msg_data := INV_EBI_UTIL.get_error_table_msgtxt(x_out.output_status.error_table);
1009: END IF;
1010: IF (x_out.output_status.msg_data IS NOT NULL) THEN

Line 1041: l_only_status_info VARCHAR2(1):= fnd_api.g_false;

1037: l_msg_data VARCHAR2(1000);
1038: l_eco_change_order_obj inv_ebi_change_order_obj;
1039: l_revised_item_tbl inv_ebi_revised_item_tbl;
1040: l_revised_item_obj inv_ebi_revised_item_obj;
1041: l_only_status_info VARCHAR2(1):= fnd_api.g_false;
1042: BEGIN
1043: x_return_status := FND_API.G_RET_STS_SUCCESS;
1044: l_eco_change_order_obj := inv_ebi_change_order_obj(
1045: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL

Line 1043: x_return_status := FND_API.G_RET_STS_SUCCESS;

1039: l_revised_item_tbl inv_ebi_revised_item_tbl;
1040: l_revised_item_obj inv_ebi_revised_item_obj;
1041: l_only_status_info VARCHAR2(1):= fnd_api.g_false;
1042: BEGIN
1043: x_return_status := FND_API.G_RET_STS_SUCCESS;
1044: l_eco_change_order_obj := inv_ebi_change_order_obj(
1045: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
1046: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
1047: ,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL

Line 1077: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1073: ,x_return_status => l_return_status
1074: ,x_msg_count => l_msg_count
1075: ,x_msg_data => l_msg_data
1076: );
1077: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1078: RAISE FND_API.g_exc_unexpected_error;
1079: END IF;
1080: IF p_name_val_list.name_value_table IS NOT NULL THEN
1081: FOR i in p_name_val_list.name_value_table.FIRST..p_name_val_list.name_value_table.LAST LOOP

Line 1078: RAISE FND_API.g_exc_unexpected_error;

1074: ,x_msg_count => l_msg_count
1075: ,x_msg_data => l_msg_data
1076: );
1077: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1078: RAISE FND_API.g_exc_unexpected_error;
1079: END IF;
1080: IF p_name_val_list.name_value_table IS NOT NULL THEN
1081: FOR i in p_name_val_list.name_value_table.FIRST..p_name_val_list.name_value_table.LAST LOOP
1082: IF UPPER(p_name_val_list.name_value_table(i).param_name) = G_ONLY_STATUS_INFO THEN

Line 1087: IF l_only_status_info = fnd_api.g_true THEN

1083: l_only_status_info := p_name_val_list.name_value_table(i).param_value;
1084: END IF;
1085: END LOOP;
1086: END IF;
1087: IF l_only_status_info = fnd_api.g_true THEN
1088: l_eco_change_order_obj.status_name := l_eco_obj.eco_change_order_type.status_name;
1089: l_eco_change_order_obj.implementation_date := l_eco_obj.eco_change_order_type.implementation_date;
1090: l_eco_change_order_obj.cancellation_date := l_eco_obj.eco_change_order_type.cancellation_date;
1091: FOR i in l_eco_obj.eco_revised_item_type.FIRST..l_eco_obj.eco_revised_item_type.LAST LOOP

Line 1102: WHEN FND_API.g_exc_unexpected_error THEN

1098: ELSE
1099: x_eco_obj := l_eco_obj;
1100: END IF;
1101: EXCEPTION
1102: WHEN FND_API.g_exc_unexpected_error THEN
1103: x_return_status := FND_API.g_ret_sts_error;
1104: IF(x_msg_data IS NULL) THEN
1105: FND_MSG_PUB.count_and_get(
1106: p_encoded => FND_API.g_false

Line 1103: x_return_status := FND_API.g_ret_sts_error;

1099: x_eco_obj := l_eco_obj;
1100: END IF;
1101: EXCEPTION
1102: WHEN FND_API.g_exc_unexpected_error THEN
1103: x_return_status := FND_API.g_ret_sts_error;
1104: IF(x_msg_data IS NULL) THEN
1105: FND_MSG_PUB.count_and_get(
1106: p_encoded => FND_API.g_false
1107: ,p_count => x_msg_count

Line 1106: p_encoded => FND_API.g_false

1102: WHEN FND_API.g_exc_unexpected_error THEN
1103: x_return_status := FND_API.g_ret_sts_error;
1104: IF(x_msg_data IS NULL) THEN
1105: FND_MSG_PUB.count_and_get(
1106: p_encoded => FND_API.g_false
1107: ,p_count => x_msg_count
1108: ,p_data => x_msg_data
1109: );
1110: END IF;

Line 1112: x_return_status := FND_API.g_ret_sts_error;

1108: ,p_data => x_msg_data
1109: );
1110: END IF;
1111: WHEN OTHERS THEN
1112: x_return_status := FND_API.g_ret_sts_error;
1113: IF (x_msg_data IS NOT NULL) THEN
1114: x_msg_data := x_msg_data ||' -> at inv_ebi_change_order_pub.get_eco';
1115: ELSE
1116: x_msg_data := SQLERRM||' at inv_ebi_change_order_pub.get_eco ';

Line 1479: x_return_status := FND_API.G_RET_STS_SUCCESS;

1475: FROM dual ) c ) geco;
1476: BEGIN
1477: l_eco_obj_tbl := inv_ebi_eco_out_obj_tbl();
1478: l_name_val_list := p_name_val_list;
1479: x_return_status := FND_API.G_RET_STS_SUCCESS;
1480: l_mult_org_chg_id_tbl := inv_ebi_change_id_obj_tbl();
1481: l_mult_org_chg_id_temp := inv_ebi_change_id_obj_tbl();
1482:
1483: INV_EBI_ITEM_HELPER.set_server_time_zone;

Line 1515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1511: ,x_return_status => l_return_status
1512: ,x_msg_count => l_count
1513: ,x_msg_data => l_msg_data
1514: );
1515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1516: x_return_status := FND_API.g_ret_sts_error;
1517: l_part_msgtxt := ' Change Id: '|| p_change_lst(l_cnt_cid).change_id||' Err Msg: '||l_msg_data ;
1518: IF (x_msg_data IS NOT NULL) THEN
1519: IF (LENGTH(x_msg_data||' , '||l_part_msgtxt) < 31000) THEN

Line 1516: x_return_status := FND_API.g_ret_sts_error;

1512: ,x_msg_count => l_count
1513: ,x_msg_data => l_msg_data
1514: );
1515: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1516: x_return_status := FND_API.g_ret_sts_error;
1517: l_part_msgtxt := ' Change Id: '|| p_change_lst(l_cnt_cid).change_id||' Err Msg: '||l_msg_data ;
1518: IF (x_msg_data IS NOT NULL) THEN
1519: IF (LENGTH(x_msg_data||' , '||l_part_msgtxt) < 31000) THEN
1520: x_msg_data :=x_msg_data||' , '||l_part_msgtxt;

Line 1546: x_return_status := FND_API.G_RET_STS_ERROR;

1542: END IF;
1543:
1544: EXCEPTION
1545: WHEN OTHERS THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547: IF (x_msg_data IS NOT NULL) THEN
1548: x_msg_data := x_msg_data ||' -> at INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr';
1549: ELSE
1550: x_msg_data := SQLERRM||' at INV_EBI_CHANGE_ORDER_PUB.get_eco_list_attr ';

Line 1563: p_commit IN VARCHAR2 := fnd_api.g_false

1559: --
1560: ************************************************************************************/
1561:
1562: PROCEDURE process_change_order_list(
1563: p_commit IN VARCHAR2 := fnd_api.g_false
1564: ,p_eco_obj_list IN inv_ebi_eco_obj_tbl
1565: ,x_out OUT NOCOPY inv_ebi_eco_output_obj_tbl
1566: ,x_return_status OUT NOCOPY VARCHAR2
1567: ,x_msg_count OUT NOCOPY NUMBER

Line 1583: x_return_status := FND_API.G_RET_STS_SUCCESS ;

1579: ERROR_HANDLER.Initialize;
1580: FND_MSG_PUB.initialize;
1581: INV_EBI_UTIL.setup();
1582: INV_EBI_UTIL.debug_line('STEP: 10 START INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
1583: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1584: x_out := inv_ebi_eco_output_obj_tbl();
1585: IF (p_eco_obj_list IS NOT NULL AND p_eco_obj_list.count > 0) THEN
1586: x_out.extend(p_eco_obj_list.count);
1587: FOR i in 1..p_eco_obj_list.count

Line 1593: IF( l_is_master_org = fnd_api.g_true ) THEN

1589: l_inv_ebi_eco_obj := p_eco_obj_list(i);
1590: l_eco_name := p_eco_obj_list(i).eco_change_order_type.eco_name;
1591: l_org_code := p_eco_obj_list(i).eco_change_order_type.organization_code;
1592: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
1593: IF( l_is_master_org = fnd_api.g_true ) THEN
1594: INV_EBI_UTIL.debug_line('STEP: 20 START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Master ORG'||
1595: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1596: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1597:

Line 1606: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN

1602: INV_EBI_UTIL.debug_line('STEP: 30 END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Master ORG'||
1603: 'Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1604: 'ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1605: x_out(i) := l_inv_ebi_eco_output_obj;
1606: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
1607: RAISE FND_API.g_exc_unexpected_error;
1608: END IF;
1609: END IF;
1610: END LOOP;

Line 1607: RAISE FND_API.g_exc_unexpected_error;

1603: 'Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1604: 'ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1605: x_out(i) := l_inv_ebi_eco_output_obj;
1606: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
1607: RAISE FND_API.g_exc_unexpected_error;
1608: END IF;
1609: END IF;
1610: END LOOP;
1611: END IF;

Line 1619: IF( l_is_master_org = fnd_api.g_false ) THEN

1615: l_inv_ebi_eco_obj := p_eco_obj_list(i);
1616: l_eco_name := p_eco_obj_list(i).eco_change_order_type.eco_name;
1617: l_org_code := p_eco_obj_list(i).eco_change_order_type.organization_code;
1618: l_is_master_org := INV_EBI_UTIL.is_master_org(l_org_code);
1619: IF( l_is_master_org = fnd_api.g_false ) THEN
1620: INV_EBI_UTIL.debug_line('STEP: 40 START CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Child ORG'||
1621: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1622: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1623: INV_EBI_CHANGE_ORDER_PUB.process_change_order( p_commit => p_commit

Line 1631: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN

1627: INV_EBI_UTIL.debug_line('STEP: 50 END CALLING INV_EBI_CHANGE_ORDER_PUB.process_change_order for Child ORG'||
1628: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1629: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1630: x_out(i) := l_inv_ebi_eco_output_obj;
1631: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
1632: RAISE FND_API.g_exc_unexpected_error;
1633: END IF;
1634: END IF;
1635: END LOOP;

Line 1632: RAISE FND_API.g_exc_unexpected_error;

1628: ' Organization Code: '||p_eco_obj_list(i).eco_change_order_type.organization_code||
1629: ' ECO Name: '||p_eco_obj_list(i).eco_change_order_type.eco_name);
1630: x_out(i) := l_inv_ebi_eco_output_obj;
1631: IF x_out(i).output_status.return_status <> FND_API.G_RET_STS_SUCCESS THEN
1632: RAISE FND_API.g_exc_unexpected_error;
1633: END IF;
1634: END IF;
1635: END LOOP;
1636: END IF;

Line 1641: WHEN FND_API.g_exc_unexpected_error THEN

1637:
1638: INV_EBI_UTIL.debug_line('STEP: 60 END INSIDE INV_EBI_CHANGE_ORDER_PUB.process_change_order_list');
1639: INV_EBI_UTIL.wrapup;
1640: EXCEPTION
1641: WHEN FND_API.g_exc_unexpected_error THEN
1642: ROLLBACK TO inv_ebi_prc_chg_ord_save_pnt;
1643: x_return_status := FND_API.G_RET_STS_ERROR;
1644: IF(x_out IS NOT NULL AND x_out.COUNT > 0) THEN
1645: FOR i in 1..x_out.COUNT

Line 1643: x_return_status := FND_API.G_RET_STS_ERROR;

1639: INV_EBI_UTIL.wrapup;
1640: EXCEPTION
1641: WHEN FND_API.g_exc_unexpected_error THEN
1642: ROLLBACK TO inv_ebi_prc_chg_ord_save_pnt;
1643: x_return_status := FND_API.G_RET_STS_ERROR;
1644: IF(x_out IS NOT NULL AND x_out.COUNT > 0) THEN
1645: FOR i in 1..x_out.COUNT
1646: LOOP
1647: x_msg_count := x_out(i).output_status.msg_count;

Line 1655: x_out(1).output_status.return_status := FND_API.g_ret_sts_unexp_error;

1651: END LOOP;
1652: END IF;
1653: WHEN OTHERS THEN
1654: x_out.EXTEND();
1655: x_out(1).output_status.return_status := FND_API.g_ret_sts_unexp_error;
1656: IF (x_out(1).output_status.msg_data IS NOT NULL) THEN
1657: x_out(1).output_status.msg_data := x_out(1).output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
1658: ELSE
1659: x_out(1).output_status.msg_data := SQLERRM|| 'INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';

Line 1661: x_return_status := FND_API.G_RET_STS_ERROR;

1657: x_out(1).output_status.msg_data := x_out(1).output_status.msg_data||' -> INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
1658: ELSE
1659: x_out(1).output_status.msg_data := SQLERRM|| 'INV_EBI_CHANGE_ORDER_PUB.process_change_order_list';
1660: END IF;
1661: x_return_status := FND_API.G_RET_STS_ERROR;
1662: x_msg_count := x_out(1).output_status.msg_count;
1663: IF (x_out IS NOT NULL AND x_out.COUNT > 0) THEN
1664: FOR i in 1..x_out.COUNT
1665: LOOP