APPS.ENG_VALIDATE dependencies on FND_API

Line 21: FND_API.g_attr_tbl.DELETE;

17: IS
18: I NUMBER:=0;
19: BEGIN
20:
21: FND_API.g_attr_tbl.DELETE;
22:
23: -- START GEN attributes
24:
25: -- Generator will append new attributes before end generate comment.

Line 28: FND_API.g_attr_tbl(I).name := 'Desc_Flex';

24:
25: -- Generator will append new attributes before end generate comment.
26:
27: I := I + 1;
28: FND_API.g_attr_tbl(I).name := 'Desc_Flex';
29: I := I + 1;
30: FND_API.g_attr_tbl(I).name := 'request';
31: I := I + 1;
32: FND_API.g_attr_tbl(I).name := 'program_application';

Line 30: FND_API.g_attr_tbl(I).name := 'request';

26:
27: I := I + 1;
28: FND_API.g_attr_tbl(I).name := 'Desc_Flex';
29: I := I + 1;
30: FND_API.g_attr_tbl(I).name := 'request';
31: I := I + 1;
32: FND_API.g_attr_tbl(I).name := 'program_application';
33: I := I + 1;
34: FND_API.g_attr_tbl(I).name := 'program';

Line 32: FND_API.g_attr_tbl(I).name := 'program_application';

28: FND_API.g_attr_tbl(I).name := 'Desc_Flex';
29: I := I + 1;
30: FND_API.g_attr_tbl(I).name := 'request';
31: I := I + 1;
32: FND_API.g_attr_tbl(I).name := 'program_application';
33: I := I + 1;
34: FND_API.g_attr_tbl(I).name := 'program';
35: I := I + 1;
36: FND_API.g_attr_tbl(I).name := 'program_update_date';

Line 34: FND_API.g_attr_tbl(I).name := 'program';

30: FND_API.g_attr_tbl(I).name := 'request';
31: I := I + 1;
32: FND_API.g_attr_tbl(I).name := 'program_application';
33: I := I + 1;
34: FND_API.g_attr_tbl(I).name := 'program';
35: I := I + 1;
36: FND_API.g_attr_tbl(I).name := 'program_update_date';
37: I := I + 1;
38: FND_API.g_attr_tbl(I).name := 'approval_status_type';

Line 36: FND_API.g_attr_tbl(I).name := 'program_update_date';

32: FND_API.g_attr_tbl(I).name := 'program_application';
33: I := I + 1;
34: FND_API.g_attr_tbl(I).name := 'program';
35: I := I + 1;
36: FND_API.g_attr_tbl(I).name := 'program_update_date';
37: I := I + 1;
38: FND_API.g_attr_tbl(I).name := 'approval_status_type';
39: I := I + 1;
40: FND_API.g_attr_tbl(I).name := 'approval_date';

Line 38: FND_API.g_attr_tbl(I).name := 'approval_status_type';

34: FND_API.g_attr_tbl(I).name := 'program';
35: I := I + 1;
36: FND_API.g_attr_tbl(I).name := 'program_update_date';
37: I := I + 1;
38: FND_API.g_attr_tbl(I).name := 'approval_status_type';
39: I := I + 1;
40: FND_API.g_attr_tbl(I).name := 'approval_date';
41: I := I + 1;
42: FND_API.g_attr_tbl(I).name := 'approval_list';

Line 40: FND_API.g_attr_tbl(I).name := 'approval_date';

36: FND_API.g_attr_tbl(I).name := 'program_update_date';
37: I := I + 1;
38: FND_API.g_attr_tbl(I).name := 'approval_status_type';
39: I := I + 1;
40: FND_API.g_attr_tbl(I).name := 'approval_date';
41: I := I + 1;
42: FND_API.g_attr_tbl(I).name := 'approval_list';
43: I := I + 1;
44: FND_API.g_attr_tbl(I).name := 'change_order_type';

Line 42: FND_API.g_attr_tbl(I).name := 'approval_list';

38: FND_API.g_attr_tbl(I).name := 'approval_status_type';
39: I := I + 1;
40: FND_API.g_attr_tbl(I).name := 'approval_date';
41: I := I + 1;
42: FND_API.g_attr_tbl(I).name := 'approval_list';
43: I := I + 1;
44: FND_API.g_attr_tbl(I).name := 'change_order_type';
45: I := I + 1;
46: FND_API.g_attr_tbl(I).name := 'responsible_org';

Line 44: FND_API.g_attr_tbl(I).name := 'change_order_type';

40: FND_API.g_attr_tbl(I).name := 'approval_date';
41: I := I + 1;
42: FND_API.g_attr_tbl(I).name := 'approval_list';
43: I := I + 1;
44: FND_API.g_attr_tbl(I).name := 'change_order_type';
45: I := I + 1;
46: FND_API.g_attr_tbl(I).name := 'responsible_org';
47: I := I + 1;
48: FND_API.g_attr_tbl(I).name := 'approval_request_date';

Line 46: FND_API.g_attr_tbl(I).name := 'responsible_org';

42: FND_API.g_attr_tbl(I).name := 'approval_list';
43: I := I + 1;
44: FND_API.g_attr_tbl(I).name := 'change_order_type';
45: I := I + 1;
46: FND_API.g_attr_tbl(I).name := 'responsible_org';
47: I := I + 1;
48: FND_API.g_attr_tbl(I).name := 'approval_request_date';
49: I := I + 1;
50: FND_API.g_attr_tbl(I).name := 'change_notice';

Line 48: FND_API.g_attr_tbl(I).name := 'approval_request_date';

44: FND_API.g_attr_tbl(I).name := 'change_order_type';
45: I := I + 1;
46: FND_API.g_attr_tbl(I).name := 'responsible_org';
47: I := I + 1;
48: FND_API.g_attr_tbl(I).name := 'approval_request_date';
49: I := I + 1;
50: FND_API.g_attr_tbl(I).name := 'change_notice';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'organization';

Line 50: FND_API.g_attr_tbl(I).name := 'change_notice';

46: FND_API.g_attr_tbl(I).name := 'responsible_org';
47: I := I + 1;
48: FND_API.g_attr_tbl(I).name := 'approval_request_date';
49: I := I + 1;
50: FND_API.g_attr_tbl(I).name := 'change_notice';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'organization';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'last_update_date';

Line 52: FND_API.g_attr_tbl(I).name := 'organization';

48: FND_API.g_attr_tbl(I).name := 'approval_request_date';
49: I := I + 1;
50: FND_API.g_attr_tbl(I).name := 'change_notice';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'organization';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'last_update_date';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'last_updated_by';

Line 54: FND_API.g_attr_tbl(I).name := 'last_update_date';

50: FND_API.g_attr_tbl(I).name := 'change_notice';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'organization';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'last_update_date';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'last_updated_by';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'creation_date';

Line 56: FND_API.g_attr_tbl(I).name := 'last_updated_by';

52: FND_API.g_attr_tbl(I).name := 'organization';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'last_update_date';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'last_updated_by';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'creation_date';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'created_by';

Line 58: FND_API.g_attr_tbl(I).name := 'creation_date';

54: FND_API.g_attr_tbl(I).name := 'last_update_date';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'last_updated_by';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'creation_date';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'created_by';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'last_update_login';

Line 60: FND_API.g_attr_tbl(I).name := 'created_by';

56: FND_API.g_attr_tbl(I).name := 'last_updated_by';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'creation_date';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'created_by';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'last_update_login';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'description';

Line 62: FND_API.g_attr_tbl(I).name := 'last_update_login';

58: FND_API.g_attr_tbl(I).name := 'creation_date';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'created_by';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'last_update_login';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'description';
65: I := I + 1;
66: FND_API.g_attr_tbl(I).name := 'status_type';

Line 64: FND_API.g_attr_tbl(I).name := 'description';

60: FND_API.g_attr_tbl(I).name := 'created_by';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'last_update_login';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'description';
65: I := I + 1;
66: FND_API.g_attr_tbl(I).name := 'status_type';
67: I := I + 1;
68: FND_API.g_attr_tbl(I).name := 'initiation_date';

Line 66: FND_API.g_attr_tbl(I).name := 'status_type';

62: FND_API.g_attr_tbl(I).name := 'last_update_login';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'description';
65: I := I + 1;
66: FND_API.g_attr_tbl(I).name := 'status_type';
67: I := I + 1;
68: FND_API.g_attr_tbl(I).name := 'initiation_date';
69: I := I + 1;
70: FND_API.g_attr_tbl(I).name := 'implementation_date';

Line 68: FND_API.g_attr_tbl(I).name := 'initiation_date';

64: FND_API.g_attr_tbl(I).name := 'description';
65: I := I + 1;
66: FND_API.g_attr_tbl(I).name := 'status_type';
67: I := I + 1;
68: FND_API.g_attr_tbl(I).name := 'initiation_date';
69: I := I + 1;
70: FND_API.g_attr_tbl(I).name := 'implementation_date';
71: I := I + 1;
72: FND_API.g_attr_tbl(I).name := 'cancellation_date';

Line 70: FND_API.g_attr_tbl(I).name := 'implementation_date';

66: FND_API.g_attr_tbl(I).name := 'status_type';
67: I := I + 1;
68: FND_API.g_attr_tbl(I).name := 'initiation_date';
69: I := I + 1;
70: FND_API.g_attr_tbl(I).name := 'implementation_date';
71: I := I + 1;
72: FND_API.g_attr_tbl(I).name := 'cancellation_date';
73: I := I + 1;
74: FND_API.g_attr_tbl(I).name := 'cancellation_comments';

Line 72: FND_API.g_attr_tbl(I).name := 'cancellation_date';

68: FND_API.g_attr_tbl(I).name := 'initiation_date';
69: I := I + 1;
70: FND_API.g_attr_tbl(I).name := 'implementation_date';
71: I := I + 1;
72: FND_API.g_attr_tbl(I).name := 'cancellation_date';
73: I := I + 1;
74: FND_API.g_attr_tbl(I).name := 'cancellation_comments';
75: I := I + 1;
76: FND_API.g_attr_tbl(I).name := 'priority';

Line 74: FND_API.g_attr_tbl(I).name := 'cancellation_comments';

70: FND_API.g_attr_tbl(I).name := 'implementation_date';
71: I := I + 1;
72: FND_API.g_attr_tbl(I).name := 'cancellation_date';
73: I := I + 1;
74: FND_API.g_attr_tbl(I).name := 'cancellation_comments';
75: I := I + 1;
76: FND_API.g_attr_tbl(I).name := 'priority';
77: I := I + 1;
78: FND_API.g_attr_tbl(I).name := 'reason';

Line 76: FND_API.g_attr_tbl(I).name := 'priority';

72: FND_API.g_attr_tbl(I).name := 'cancellation_date';
73: I := I + 1;
74: FND_API.g_attr_tbl(I).name := 'cancellation_comments';
75: I := I + 1;
76: FND_API.g_attr_tbl(I).name := 'priority';
77: I := I + 1;
78: FND_API.g_attr_tbl(I).name := 'reason';
79: I := I + 1;
80: FND_API.g_attr_tbl(I).name := 'estimated_eng_cost';

Line 78: FND_API.g_attr_tbl(I).name := 'reason';

74: FND_API.g_attr_tbl(I).name := 'cancellation_comments';
75: I := I + 1;
76: FND_API.g_attr_tbl(I).name := 'priority';
77: I := I + 1;
78: FND_API.g_attr_tbl(I).name := 'reason';
79: I := I + 1;
80: FND_API.g_attr_tbl(I).name := 'estimated_eng_cost';
81: I := I + 1;
82: FND_API.g_attr_tbl(I).name := 'estimated_mfg_cost';

Line 80: FND_API.g_attr_tbl(I).name := 'estimated_eng_cost';

76: FND_API.g_attr_tbl(I).name := 'priority';
77: I := I + 1;
78: FND_API.g_attr_tbl(I).name := 'reason';
79: I := I + 1;
80: FND_API.g_attr_tbl(I).name := 'estimated_eng_cost';
81: I := I + 1;
82: FND_API.g_attr_tbl(I).name := 'estimated_mfg_cost';
83: I := I + 1;
84: FND_API.g_attr_tbl(I).name := 'requestor';

Line 82: FND_API.g_attr_tbl(I).name := 'estimated_mfg_cost';

78: FND_API.g_attr_tbl(I).name := 'reason';
79: I := I + 1;
80: FND_API.g_attr_tbl(I).name := 'estimated_eng_cost';
81: I := I + 1;
82: FND_API.g_attr_tbl(I).name := 'estimated_mfg_cost';
83: I := I + 1;
84: FND_API.g_attr_tbl(I).name := 'requestor';
85:
86: I := I + 1;

Line 84: FND_API.g_attr_tbl(I).name := 'requestor';

80: FND_API.g_attr_tbl(I).name := 'estimated_eng_cost';
81: I := I + 1;
82: FND_API.g_attr_tbl(I).name := 'estimated_mfg_cost';
83: I := I + 1;
84: FND_API.g_attr_tbl(I).name := 'requestor';
85:
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'revision';
88: I := I + 1;

Line 87: FND_API.g_attr_tbl(I).name := 'revision';

83: I := I + 1;
84: FND_API.g_attr_tbl(I).name := 'requestor';
85:
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'revision';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'rev';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'comments';

Line 89: FND_API.g_attr_tbl(I).name := 'rev';

85:
86: I := I + 1;
87: FND_API.g_attr_tbl(I).name := 'revision';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'rev';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'comments';
92:
93: I := I + 1;

Line 91: FND_API.g_attr_tbl(I).name := 'comments';

87: FND_API.g_attr_tbl(I).name := 'revision';
88: I := I + 1;
89: FND_API.g_attr_tbl(I).name := 'rev';
90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'comments';
92:
93: I := I + 1;
94: FND_API.g_attr_tbl(I).name := 'using_assembly';
95: I := I + 1;

Line 94: FND_API.g_attr_tbl(I).name := 'using_assembly';

90: I := I + 1;
91: FND_API.g_attr_tbl(I).name := 'comments';
92:
93: I := I + 1;
94: FND_API.g_attr_tbl(I).name := 'using_assembly';
95: I := I + 1;
96: FND_API.g_attr_tbl(I).name := 'revised_item';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'cancel_comments';

Line 96: FND_API.g_attr_tbl(I).name := 'revised_item';

92:
93: I := I + 1;
94: FND_API.g_attr_tbl(I).name := 'using_assembly';
95: I := I + 1;
96: FND_API.g_attr_tbl(I).name := 'revised_item';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'cancel_comments';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'disposition_type';

Line 98: FND_API.g_attr_tbl(I).name := 'cancel_comments';

94: FND_API.g_attr_tbl(I).name := 'using_assembly';
95: I := I + 1;
96: FND_API.g_attr_tbl(I).name := 'revised_item';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'cancel_comments';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'disposition_type';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'new_item_revision';

Line 100: FND_API.g_attr_tbl(I).name := 'disposition_type';

96: FND_API.g_attr_tbl(I).name := 'revised_item';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'cancel_comments';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'disposition_type';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'new_item_revision';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'early_schedule_date';

Line 102: FND_API.g_attr_tbl(I).name := 'new_item_revision';

98: FND_API.g_attr_tbl(I).name := 'cancel_comments';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'disposition_type';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'new_item_revision';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'early_schedule_date';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'scheduled_date';

Line 104: FND_API.g_attr_tbl(I).name := 'early_schedule_date';

100: FND_API.g_attr_tbl(I).name := 'disposition_type';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'new_item_revision';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'early_schedule_date';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'scheduled_date';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'bill_sequence';

Line 106: FND_API.g_attr_tbl(I).name := 'scheduled_date';

102: FND_API.g_attr_tbl(I).name := 'new_item_revision';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'early_schedule_date';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'scheduled_date';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'bill_sequence';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'mrp_active';

Line 108: FND_API.g_attr_tbl(I).name := 'bill_sequence';

104: FND_API.g_attr_tbl(I).name := 'early_schedule_date';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'scheduled_date';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'bill_sequence';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'mrp_active';
111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'update_wip';

Line 110: FND_API.g_attr_tbl(I).name := 'mrp_active';

106: FND_API.g_attr_tbl(I).name := 'scheduled_date';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'bill_sequence';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'mrp_active';
111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'update_wip';
113: I := I + 1;
114: FND_API.g_attr_tbl(I).name := 'use_up';

Line 112: FND_API.g_attr_tbl(I).name := 'update_wip';

108: FND_API.g_attr_tbl(I).name := 'bill_sequence';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'mrp_active';
111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'update_wip';
113: I := I + 1;
114: FND_API.g_attr_tbl(I).name := 'use_up';
115: I := I + 1;
116: FND_API.g_attr_tbl(I).name := 'use_up_item';

Line 114: FND_API.g_attr_tbl(I).name := 'use_up';

110: FND_API.g_attr_tbl(I).name := 'mrp_active';
111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'update_wip';
113: I := I + 1;
114: FND_API.g_attr_tbl(I).name := 'use_up';
115: I := I + 1;
116: FND_API.g_attr_tbl(I).name := 'use_up_item';
117: I := I + 1;
118: FND_API.g_attr_tbl(I).name := 'revised_item_sequence';

Line 116: FND_API.g_attr_tbl(I).name := 'use_up_item';

112: FND_API.g_attr_tbl(I).name := 'update_wip';
113: I := I + 1;
114: FND_API.g_attr_tbl(I).name := 'use_up';
115: I := I + 1;
116: FND_API.g_attr_tbl(I).name := 'use_up_item';
117: I := I + 1;
118: FND_API.g_attr_tbl(I).name := 'revised_item_sequence';
119: I := I + 1;
120: FND_API.g_attr_tbl(I).name := 'use_up_plan_name';

Line 118: FND_API.g_attr_tbl(I).name := 'revised_item_sequence';

114: FND_API.g_attr_tbl(I).name := 'use_up';
115: I := I + 1;
116: FND_API.g_attr_tbl(I).name := 'use_up_item';
117: I := I + 1;
118: FND_API.g_attr_tbl(I).name := 'revised_item_sequence';
119: I := I + 1;
120: FND_API.g_attr_tbl(I).name := 'use_up_plan_name';
121: I := I + 1;
122: FND_API.g_attr_tbl(I).name := 'descriptive_text';

Line 120: FND_API.g_attr_tbl(I).name := 'use_up_plan_name';

116: FND_API.g_attr_tbl(I).name := 'use_up_item';
117: I := I + 1;
118: FND_API.g_attr_tbl(I).name := 'revised_item_sequence';
119: I := I + 1;
120: FND_API.g_attr_tbl(I).name := 'use_up_plan_name';
121: I := I + 1;
122: FND_API.g_attr_tbl(I).name := 'descriptive_text';
123: I := I + 1;
124: FND_API.g_attr_tbl(I).name := 'auto_implement_date';

Line 122: FND_API.g_attr_tbl(I).name := 'descriptive_text';

118: FND_API.g_attr_tbl(I).name := 'revised_item_sequence';
119: I := I + 1;
120: FND_API.g_attr_tbl(I).name := 'use_up_plan_name';
121: I := I + 1;
122: FND_API.g_attr_tbl(I).name := 'descriptive_text';
123: I := I + 1;
124: FND_API.g_attr_tbl(I).name := 'auto_implement_date';
125:
126: I := I + 1;

Line 124: FND_API.g_attr_tbl(I).name := 'auto_implement_date';

120: FND_API.g_attr_tbl(I).name := 'use_up_plan_name';
121: I := I + 1;
122: FND_API.g_attr_tbl(I).name := 'descriptive_text';
123: I := I + 1;
124: FND_API.g_attr_tbl(I).name := 'auto_implement_date';
125:
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'supply_subinventory';
128: I := I + 1;

Line 127: FND_API.g_attr_tbl(I).name := 'supply_subinventory';

123: I := I + 1;
124: FND_API.g_attr_tbl(I).name := 'auto_implement_date';
125:
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'supply_subinventory';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'op_lead_time_percent';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'cost_factor';

Line 129: FND_API.g_attr_tbl(I).name := 'op_lead_time_percent';

125:
126: I := I + 1;
127: FND_API.g_attr_tbl(I).name := 'supply_subinventory';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'op_lead_time_percent';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'cost_factor';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'required_for_revenue';

Line 131: FND_API.g_attr_tbl(I).name := 'cost_factor';

127: FND_API.g_attr_tbl(I).name := 'supply_subinventory';
128: I := I + 1;
129: FND_API.g_attr_tbl(I).name := 'op_lead_time_percent';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'cost_factor';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'required_for_revenue';
134: I := I + 1;
135: FND_API.g_attr_tbl(I).name := 'high_quantity';

Line 133: FND_API.g_attr_tbl(I).name := 'required_for_revenue';

129: FND_API.g_attr_tbl(I).name := 'op_lead_time_percent';
130: I := I + 1;
131: FND_API.g_attr_tbl(I).name := 'cost_factor';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'required_for_revenue';
134: I := I + 1;
135: FND_API.g_attr_tbl(I).name := 'high_quantity';
136: I := I + 1;
137: FND_API.g_attr_tbl(I).name := 'component_sequence';

Line 135: FND_API.g_attr_tbl(I).name := 'high_quantity';

131: FND_API.g_attr_tbl(I).name := 'cost_factor';
132: I := I + 1;
133: FND_API.g_attr_tbl(I).name := 'required_for_revenue';
134: I := I + 1;
135: FND_API.g_attr_tbl(I).name := 'high_quantity';
136: I := I + 1;
137: FND_API.g_attr_tbl(I).name := 'component_sequence';
138: I := I + 1;
139: FND_API.g_attr_tbl(I).name := 'wip_supply_type';

Line 137: FND_API.g_attr_tbl(I).name := 'component_sequence';

133: FND_API.g_attr_tbl(I).name := 'required_for_revenue';
134: I := I + 1;
135: FND_API.g_attr_tbl(I).name := 'high_quantity';
136: I := I + 1;
137: FND_API.g_attr_tbl(I).name := 'component_sequence';
138: I := I + 1;
139: FND_API.g_attr_tbl(I).name := 'wip_supply_type';
140: I := I + 1;
141: FND_API.g_attr_tbl(I).name := 'supply_locator';

Line 139: FND_API.g_attr_tbl(I).name := 'wip_supply_type';

135: FND_API.g_attr_tbl(I).name := 'high_quantity';
136: I := I + 1;
137: FND_API.g_attr_tbl(I).name := 'component_sequence';
138: I := I + 1;
139: FND_API.g_attr_tbl(I).name := 'wip_supply_type';
140: I := I + 1;
141: FND_API.g_attr_tbl(I).name := 'supply_locator';
142: I := I + 1;
143: FND_API.g_attr_tbl(I).name := 'bom_item_type';

Line 141: FND_API.g_attr_tbl(I).name := 'supply_locator';

137: FND_API.g_attr_tbl(I).name := 'component_sequence';
138: I := I + 1;
139: FND_API.g_attr_tbl(I).name := 'wip_supply_type';
140: I := I + 1;
141: FND_API.g_attr_tbl(I).name := 'supply_locator';
142: I := I + 1;
143: FND_API.g_attr_tbl(I).name := 'bom_item_type';
144: I := I + 1;
145: FND_API.g_attr_tbl(I).name := 'operation_seq_num';

Line 143: FND_API.g_attr_tbl(I).name := 'bom_item_type';

139: FND_API.g_attr_tbl(I).name := 'wip_supply_type';
140: I := I + 1;
141: FND_API.g_attr_tbl(I).name := 'supply_locator';
142: I := I + 1;
143: FND_API.g_attr_tbl(I).name := 'bom_item_type';
144: I := I + 1;
145: FND_API.g_attr_tbl(I).name := 'operation_seq_num';
146: I := I + 1;
147: FND_API.g_attr_tbl(I).name := 'component_item';

Line 145: FND_API.g_attr_tbl(I).name := 'operation_seq_num';

141: FND_API.g_attr_tbl(I).name := 'supply_locator';
142: I := I + 1;
143: FND_API.g_attr_tbl(I).name := 'bom_item_type';
144: I := I + 1;
145: FND_API.g_attr_tbl(I).name := 'operation_seq_num';
146: I := I + 1;
147: FND_API.g_attr_tbl(I).name := 'component_item';
148: I := I + 1;
149: FND_API.g_attr_tbl(I).name := 'item_num';

Line 147: FND_API.g_attr_tbl(I).name := 'component_item';

143: FND_API.g_attr_tbl(I).name := 'bom_item_type';
144: I := I + 1;
145: FND_API.g_attr_tbl(I).name := 'operation_seq_num';
146: I := I + 1;
147: FND_API.g_attr_tbl(I).name := 'component_item';
148: I := I + 1;
149: FND_API.g_attr_tbl(I).name := 'item_num';
150: I := I + 1;
151: FND_API.g_attr_tbl(I).name := 'component_quantity';

Line 149: FND_API.g_attr_tbl(I).name := 'item_num';

145: FND_API.g_attr_tbl(I).name := 'operation_seq_num';
146: I := I + 1;
147: FND_API.g_attr_tbl(I).name := 'component_item';
148: I := I + 1;
149: FND_API.g_attr_tbl(I).name := 'item_num';
150: I := I + 1;
151: FND_API.g_attr_tbl(I).name := 'component_quantity';
152: I := I + 1;
153: FND_API.g_attr_tbl(I).name := 'component_yield_factor';

Line 151: FND_API.g_attr_tbl(I).name := 'component_quantity';

147: FND_API.g_attr_tbl(I).name := 'component_item';
148: I := I + 1;
149: FND_API.g_attr_tbl(I).name := 'item_num';
150: I := I + 1;
151: FND_API.g_attr_tbl(I).name := 'component_quantity';
152: I := I + 1;
153: FND_API.g_attr_tbl(I).name := 'component_yield_factor';
154: I := I + 1;
155: FND_API.g_attr_tbl(I).name := 'component_remarks';

Line 153: FND_API.g_attr_tbl(I).name := 'component_yield_factor';

149: FND_API.g_attr_tbl(I).name := 'item_num';
150: I := I + 1;
151: FND_API.g_attr_tbl(I).name := 'component_quantity';
152: I := I + 1;
153: FND_API.g_attr_tbl(I).name := 'component_yield_factor';
154: I := I + 1;
155: FND_API.g_attr_tbl(I).name := 'component_remarks';
156: I := I + 1;
157: FND_API.g_attr_tbl(I).name := 'effectivity_date';

Line 155: FND_API.g_attr_tbl(I).name := 'component_remarks';

151: FND_API.g_attr_tbl(I).name := 'component_quantity';
152: I := I + 1;
153: FND_API.g_attr_tbl(I).name := 'component_yield_factor';
154: I := I + 1;
155: FND_API.g_attr_tbl(I).name := 'component_remarks';
156: I := I + 1;
157: FND_API.g_attr_tbl(I).name := 'effectivity_date';
158: I := I + 1;
159: FND_API.g_attr_tbl(I).name := 'disable_date';

Line 157: FND_API.g_attr_tbl(I).name := 'effectivity_date';

153: FND_API.g_attr_tbl(I).name := 'component_yield_factor';
154: I := I + 1;
155: FND_API.g_attr_tbl(I).name := 'component_remarks';
156: I := I + 1;
157: FND_API.g_attr_tbl(I).name := 'effectivity_date';
158: I := I + 1;
159: FND_API.g_attr_tbl(I).name := 'disable_date';
160: I := I + 1;
161: FND_API.g_attr_tbl(I).name := 'planning_factor';

Line 159: FND_API.g_attr_tbl(I).name := 'disable_date';

155: FND_API.g_attr_tbl(I).name := 'component_remarks';
156: I := I + 1;
157: FND_API.g_attr_tbl(I).name := 'effectivity_date';
158: I := I + 1;
159: FND_API.g_attr_tbl(I).name := 'disable_date';
160: I := I + 1;
161: FND_API.g_attr_tbl(I).name := 'planning_factor';
162: I := I + 1;
163: FND_API.g_attr_tbl(I).name := 'quantity_related';

Line 161: FND_API.g_attr_tbl(I).name := 'planning_factor';

157: FND_API.g_attr_tbl(I).name := 'effectivity_date';
158: I := I + 1;
159: FND_API.g_attr_tbl(I).name := 'disable_date';
160: I := I + 1;
161: FND_API.g_attr_tbl(I).name := 'planning_factor';
162: I := I + 1;
163: FND_API.g_attr_tbl(I).name := 'quantity_related';
164: I := I + 1;
165: FND_API.g_attr_tbl(I).name := 'so_basis';

Line 163: FND_API.g_attr_tbl(I).name := 'quantity_related';

159: FND_API.g_attr_tbl(I).name := 'disable_date';
160: I := I + 1;
161: FND_API.g_attr_tbl(I).name := 'planning_factor';
162: I := I + 1;
163: FND_API.g_attr_tbl(I).name := 'quantity_related';
164: I := I + 1;
165: FND_API.g_attr_tbl(I).name := 'so_basis';
166: I := I + 1;
167: FND_API.g_attr_tbl(I).name := 'optional';

Line 165: FND_API.g_attr_tbl(I).name := 'so_basis';

161: FND_API.g_attr_tbl(I).name := 'planning_factor';
162: I := I + 1;
163: FND_API.g_attr_tbl(I).name := 'quantity_related';
164: I := I + 1;
165: FND_API.g_attr_tbl(I).name := 'so_basis';
166: I := I + 1;
167: FND_API.g_attr_tbl(I).name := 'optional';
168: I := I + 1;
169: FND_API.g_attr_tbl(I).name := 'mutually_exclusive_opt';

Line 167: FND_API.g_attr_tbl(I).name := 'optional';

163: FND_API.g_attr_tbl(I).name := 'quantity_related';
164: I := I + 1;
165: FND_API.g_attr_tbl(I).name := 'so_basis';
166: I := I + 1;
167: FND_API.g_attr_tbl(I).name := 'optional';
168: I := I + 1;
169: FND_API.g_attr_tbl(I).name := 'mutually_exclusive_opt';
170: I := I + 1;
171: FND_API.g_attr_tbl(I).name := 'include_in_cost_rollup';

Line 169: FND_API.g_attr_tbl(I).name := 'mutually_exclusive_opt';

165: FND_API.g_attr_tbl(I).name := 'so_basis';
166: I := I + 1;
167: FND_API.g_attr_tbl(I).name := 'optional';
168: I := I + 1;
169: FND_API.g_attr_tbl(I).name := 'mutually_exclusive_opt';
170: I := I + 1;
171: FND_API.g_attr_tbl(I).name := 'include_in_cost_rollup';
172: I := I + 1;
173: FND_API.g_attr_tbl(I).name := 'check_atp';

Line 171: FND_API.g_attr_tbl(I).name := 'include_in_cost_rollup';

167: FND_API.g_attr_tbl(I).name := 'optional';
168: I := I + 1;
169: FND_API.g_attr_tbl(I).name := 'mutually_exclusive_opt';
170: I := I + 1;
171: FND_API.g_attr_tbl(I).name := 'include_in_cost_rollup';
172: I := I + 1;
173: FND_API.g_attr_tbl(I).name := 'check_atp';
174: I := I + 1;
175: FND_API.g_attr_tbl(I).name := 'shipping_allowed';

Line 173: FND_API.g_attr_tbl(I).name := 'check_atp';

169: FND_API.g_attr_tbl(I).name := 'mutually_exclusive_opt';
170: I := I + 1;
171: FND_API.g_attr_tbl(I).name := 'include_in_cost_rollup';
172: I := I + 1;
173: FND_API.g_attr_tbl(I).name := 'check_atp';
174: I := I + 1;
175: FND_API.g_attr_tbl(I).name := 'shipping_allowed';
176: I := I + 1;
177: FND_API.g_attr_tbl(I).name := 'required_to_ship';

Line 175: FND_API.g_attr_tbl(I).name := 'shipping_allowed';

171: FND_API.g_attr_tbl(I).name := 'include_in_cost_rollup';
172: I := I + 1;
173: FND_API.g_attr_tbl(I).name := 'check_atp';
174: I := I + 1;
175: FND_API.g_attr_tbl(I).name := 'shipping_allowed';
176: I := I + 1;
177: FND_API.g_attr_tbl(I).name := 'required_to_ship';
178: I := I + 1;
179: FND_API.g_attr_tbl(I).name := 'include_on_ship_docs';

Line 177: FND_API.g_attr_tbl(I).name := 'required_to_ship';

173: FND_API.g_attr_tbl(I).name := 'check_atp';
174: I := I + 1;
175: FND_API.g_attr_tbl(I).name := 'shipping_allowed';
176: I := I + 1;
177: FND_API.g_attr_tbl(I).name := 'required_to_ship';
178: I := I + 1;
179: FND_API.g_attr_tbl(I).name := 'include_on_ship_docs';
180: I := I + 1;
181: FND_API.g_attr_tbl(I).name := 'include_on_bill_docs';

Line 179: FND_API.g_attr_tbl(I).name := 'include_on_ship_docs';

175: FND_API.g_attr_tbl(I).name := 'shipping_allowed';
176: I := I + 1;
177: FND_API.g_attr_tbl(I).name := 'required_to_ship';
178: I := I + 1;
179: FND_API.g_attr_tbl(I).name := 'include_on_ship_docs';
180: I := I + 1;
181: FND_API.g_attr_tbl(I).name := 'include_on_bill_docs';
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'low_quantity';

Line 181: FND_API.g_attr_tbl(I).name := 'include_on_bill_docs';

177: FND_API.g_attr_tbl(I).name := 'required_to_ship';
178: I := I + 1;
179: FND_API.g_attr_tbl(I).name := 'include_on_ship_docs';
180: I := I + 1;
181: FND_API.g_attr_tbl(I).name := 'include_on_bill_docs';
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'low_quantity';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'acd_type';

Line 183: FND_API.g_attr_tbl(I).name := 'low_quantity';

179: FND_API.g_attr_tbl(I).name := 'include_on_ship_docs';
180: I := I + 1;
181: FND_API.g_attr_tbl(I).name := 'include_on_bill_docs';
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'low_quantity';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'acd_type';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'old_component_sequence';

Line 185: FND_API.g_attr_tbl(I).name := 'acd_type';

181: FND_API.g_attr_tbl(I).name := 'include_on_bill_docs';
182: I := I + 1;
183: FND_API.g_attr_tbl(I).name := 'low_quantity';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'acd_type';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'old_component_sequence';
188: I := I + 1;
189: FND_API.g_attr_tbl(I).name := 'pick_components';

Line 187: FND_API.g_attr_tbl(I).name := 'old_component_sequence';

183: FND_API.g_attr_tbl(I).name := 'low_quantity';
184: I := I + 1;
185: FND_API.g_attr_tbl(I).name := 'acd_type';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'old_component_sequence';
188: I := I + 1;
189: FND_API.g_attr_tbl(I).name := 'pick_components';
190:
191: I := I + 1;

Line 189: FND_API.g_attr_tbl(I).name := 'pick_components';

185: FND_API.g_attr_tbl(I).name := 'acd_type';
186: I := I + 1;
187: FND_API.g_attr_tbl(I).name := 'old_component_sequence';
188: I := I + 1;
189: FND_API.g_attr_tbl(I).name := 'pick_components';
190:
191: I := I + 1;
192: FND_API.g_attr_tbl(I).name := 'ref_designator';
193: I := I + 1;

Line 192: FND_API.g_attr_tbl(I).name := 'ref_designator';

188: I := I + 1;
189: FND_API.g_attr_tbl(I).name := 'pick_components';
190:
191: I := I + 1;
192: FND_API.g_attr_tbl(I).name := 'ref_designator';
193: I := I + 1;
194: FND_API.g_attr_tbl(I).name := 'ref_designator_comment';
195:
196: I := I + 1;

Line 194: FND_API.g_attr_tbl(I).name := 'ref_designator_comment';

190:
191: I := I + 1;
192: FND_API.g_attr_tbl(I).name := 'ref_designator';
193: I := I + 1;
194: FND_API.g_attr_tbl(I).name := 'ref_designator_comment';
195:
196: I := I + 1;
197: FND_API.g_attr_tbl(I).name := 'substitute_component';
198: I := I + 1;

Line 197: FND_API.g_attr_tbl(I).name := 'substitute_component';

193: I := I + 1;
194: FND_API.g_attr_tbl(I).name := 'ref_designator_comment';
195:
196: I := I + 1;
197: FND_API.g_attr_tbl(I).name := 'substitute_component';
198: I := I + 1;
199: FND_API.g_attr_tbl(I).name := 'substitute_item_quantity';
200:
201:

Line 199: FND_API.g_attr_tbl(I).name := 'substitute_item_quantity';

195:
196: I := I + 1;
197: FND_API.g_attr_tbl(I).name := 'substitute_component';
198: I := I + 1;
199: FND_API.g_attr_tbl(I).name := 'substitute_item_quantity';
200:
201:
202: -- END GEN attributes
203:

Line 240: p_approval_status_type = FND_API.G_MISS_NUM

236: l_dummy VARCHAR2(10);
237: BEGIN
238:
239: IF p_approval_status_type IS NULL OR
240: p_approval_status_type = FND_API.G_MISS_NUM
241: THEN
242: RETURN TRUE;
243: END IF;
244:

Line 283: p_approval_date = FND_API.G_MISS_DATE

279: l_dummy VARCHAR2(10);
280: BEGIN
281:
282: IF p_approval_date IS NULL OR
283: p_approval_date = FND_API.G_MISS_DATE
284: THEN
285: RETURN TRUE;
286: END IF;
287:

Line 314: p_approval_list_id = FND_API.G_MISS_NUM

310: l_dummy VARCHAR2(10);
311: BEGIN
312:
313: IF p_approval_list_id IS NULL OR
314: p_approval_list_id = FND_API.G_MISS_NUM
315: THEN
316: RETURN TRUE;
317: END IF;
318:

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

333: WHEN OTHERS THEN
334: x_err_text := 'An unexpected error occured in ' || G_PKG_NAME ||
335: ' and procedure Approval_List ' || SQLERRM;
336:
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338:
339: END Approval_List;
340:
341: /***************************************************************************

Line 358: p_change_order_type_id = FND_API.G_MISS_NUM

354: l_dummy VARCHAR2(10);
355: BEGIN
356:
357: IF p_change_order_type_id IS NULL OR
358: p_change_order_type_id = FND_API.G_MISS_NUM
359: THEN
360: RETURN TRUE;
361: END IF;
362:

Line 403: p_responsible_org_id = FND_API.G_MISS_NUM

399: l_dummy VARCHAR2(10);
400: BEGIN
401:
402: IF p_responsible_org_id IS NULL OR
403: p_responsible_org_id = FND_API.G_MISS_NUM
404: THEN
405: RETURN TRUE;
406: END IF;
407: -- Bug 4947849

Line 462: p_approval_request_date = FND_API.G_MISS_DATE

458: l_dummy VARCHAR2(10);
459: BEGIN
460:
461: IF p_approval_request_date IS NULL OR
462: p_approval_request_date = FND_API.G_MISS_DATE
463: THEN
464: RETURN TRUE;
465: END IF;
466:

Line 493: p_status_type = FND_API.G_MISS_NUM

489: l_err_text VARCHAR2(2000) := NULL;
490: BEGIN
491:
492: IF p_status_type IS NULL OR
493: p_status_type = FND_API.G_MISS_NUM
494: THEN
495: RETURN TRUE;
496: END IF;
497:

Line 546: p_from_end_item_unit_number = FND_API.G_MISS_CHAR

542: l_err_text VARCHAR2(2000) := NULL;
543: BEGIN
544:
545: IF p_from_end_item_unit_number IS NULL OR
546: p_from_end_item_unit_number = FND_API.G_MISS_CHAR
547: THEN
548: RETURN TRUE;
549: END IF;
550:

Line 593: p_initiation_date = FND_API.G_MISS_DATE

589: l_dummy VARCHAR2(10);
590: BEGIN
591:
592: IF p_initiation_date IS NULL OR
593: p_initiation_date = FND_API.G_MISS_DATE
594: THEN
595: RETURN TRUE;
596: END IF;
597:

Line 625: p_implementation_date = FND_API.G_MISS_DATE

621: l_err_text VARCHAR2(2000) := NULL;
622: BEGIN
623:
624: IF p_implementation_date IS NULL OR
625: p_implementation_date = FND_API.G_MISS_DATE
626: THEN
627: RETURN TRUE;
628: END IF;
629:

Line 656: p_cancellation_date = FND_API.G_MISS_DATE

652: l_dummy VARCHAR2(10);
653: BEGIN
654:
655: IF p_cancellation_date IS NULL OR
656: p_cancellation_date = FND_API.G_MISS_DATE
657: THEN
658: RETURN TRUE;
659: END IF;
660:

Line 689: p_priority_code = FND_API.G_MISS_CHAR

685: l_dummy VARCHAR2(10);
686: BEGIN
687:
688: IF p_priority_code IS NULL OR
689: p_priority_code = FND_API.G_MISS_CHAR
690: THEN
691: RETURN TRUE;
692: END IF;
693:

Line 729: p_reason_code = FND_API.G_MISS_CHAR

725: l_dummy VARCHAR2(10);
726: BEGIN
727:
728: IF p_reason_code IS NULL OR
729: p_reason_code = FND_API.G_MISS_CHAR
730: THEN
731: RETURN TRUE;
732: END IF;
733:

Line 767: p_disposition_type = FND_API.G_MISS_NUM

763: l_err_text VARCHAR2(2000) := NULL;
764: BEGIN
765:
766: IF p_disposition_type IS NULL OR
767: p_disposition_type = FND_API.G_MISS_NUM
768: THEN
769: RETURN TRUE;
770: END IF;
771:

Line 790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

786: WHEN OTHERS THEN
787: x_err_text := 'An unexpected error occured in ' || G_PKG_NAME ||
788: ' and procedure Disposition_Type' || SQLERRM ;
789:
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791:
792:
793: END Disposition_Type;
794:

Line 812: p_mrp_active = FND_API.G_MISS_NUM

808: l_err_text VARCHAR2(2000) := NULL;
809: BEGIN
810:
811: IF p_mrp_active IS NULL OR
812: p_mrp_active = FND_API.G_MISS_NUM
813: THEN
814: RETURN TRUE;
815: END IF;
816:

Line 842: p_update_wip = FND_API.G_MISS_NUM

838: l_dummy VARCHAR2(10);
839: BEGIN
840:
841: IF p_update_wip IS NULL OR
842: p_update_wip = FND_API.G_MISS_NUM
843: THEN
844: RETURN TRUE;
845: END IF;
846:

Line 871: p_use_up = FND_API.G_MISS_NUM

867: l_dummy VARCHAR2(10);
868: BEGIN
869:
870: IF p_use_up IS NULL OR
871: p_use_up = FND_API.G_MISS_NUM
872: THEN
873: RETURN TRUE;
874: END IF;
875:

Line 910: p_use_up_plan_name = FND_API.G_MISS_CHAR

906: l_data_completion_date DATE;
907: l_plan_completion_date DATE;
908: BEGIN
909: IF p_use_up_plan_name IS NULL OR
910: p_use_up_plan_name = FND_API.G_MISS_CHAR
911: THEN
912: RETURN TRUE;
913: END IF;
914:

Line 960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

956: WHEN OTHERS THEN
957: x_err_text := 'An unexpected error occured in ' || G_PKG_NAME ||
958: ' and procedure Use_Up_Plan_Name' || SQLERRM ;
959:
960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
961:
962: END Use_Up_Plan_Name;
963:
964:

Line 986: p_supply_subinventory = FND_API.G_MISS_CHAR

982: l_dummy VARCHAR2(10);
983: BEGIN
984:
985: IF p_supply_subinventory IS NULL OR
986: p_supply_subinventory = FND_API.G_MISS_CHAR
987: THEN
988: RETURN TRUE;
989: END IF;
990:

Line 1027: p_required_for_revenue = FND_API.G_MISS_NUM

1023: l_dummy VARCHAR2(10);
1024: BEGIN
1025:
1026: IF p_required_for_revenue IS NULL OR
1027: p_required_for_revenue = FND_API.G_MISS_NUM
1028: THEN
1029: RETURN TRUE;
1030: END IF;
1031:

Line 1057: p_wip_supply_type = FND_API.G_MISS_NUM

1053: l_dummy VARCHAR2(10);
1054: BEGIN
1055:
1056: IF p_wip_supply_type IS NULL OR
1057: p_wip_supply_type = FND_API.G_MISS_NUM
1058: THEN
1059: RETURN TRUE;
1060: END IF;
1061:

Line 1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1075: WHEN OTHERS THEN
1076: x_err_text := 'An unexpected error occured in ' || G_PKG_NAME ||
1077: ' and function Wip_Supply_Type' || SQLERRM ;
1078:
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080:
1081: END Wip_Supply_Type;
1082:
1083: /*****************************************************************************

Line 1103: p_item_num = FND_API.G_MISS_NUM

1099: to_char(p_item_num));
1100: END IF;
1101:
1102: IF p_item_num IS NULL OR
1103: p_item_num = FND_API.G_MISS_NUM
1104: THEN
1105: RETURN TRUE;
1106: ELSIF p_item_num < 0 OR
1107: p_item_num > 9999 THEN

Line 1124: p_component_yield_factor = FND_API.G_MISS_NUM

1120: l_dummy VARCHAR2(10);
1121: BEGIN
1122:
1123: IF p_component_yield_factor IS NULL OR
1124: p_component_yield_factor = FND_API.G_MISS_NUM
1125: THEN
1126: RETURN TRUE;
1127: ELSIF p_component_yield_factor < 0 THEN
1128: RETURN FALSE;

Line 1160: p_effectivity_date = FND_API.G_MISS_DATE

1156:
1157: BEGIN
1158:
1159: IF p_effectivity_date IS NULL OR
1160: p_effectivity_date = FND_API.G_MISS_DATE
1161: THEN
1162: RETURN TRUE;
1163: END IF;
1164:

Line 1201: p_disable_date = FND_API.G_MISS_DATE OR

1197: l_dummy VARCHAR2(10);
1198: BEGIN
1199:
1200: IF p_disable_date IS NULL OR
1201: p_disable_date = FND_API.G_MISS_DATE OR
1202: (p_disable_date >= SYSDATE AND
1203: p_disable_date >= p_effectivity_date
1204: )
1205: THEN

Line 1221: p_quantity_related = FND_API.G_MISS_NUM

1217: l_dummy VARCHAR2(10);
1218: BEGIN
1219:
1220: IF p_quantity_related IS NULL OR
1221: p_quantity_related = FND_API.G_MISS_NUM
1222: THEN
1223: RETURN TRUE;
1224: END IF;
1225:

Line 1242: p_so_basis = FND_API.G_MISS_NUM

1238: l_dummy VARCHAR2(10);
1239: BEGIN
1240:
1241: IF p_so_basis IS NULL OR
1242: p_so_basis = FND_API.G_MISS_NUM
1243: THEN
1244: RETURN TRUE;
1245: END IF;
1246: IF p_so_basis in (1, 2) THEN

Line 1268: p_optional = FND_API.G_MISS_NUM

1264: l_dummy VARCHAR2(10);
1265: BEGIN
1266:
1267: IF p_optional IS NULL OR
1268: p_optional = FND_API.G_MISS_NUM
1269: THEN
1270: RETURN TRUE;
1271: END IF;
1272:

Line 1294: p_mutually_exclusive_opt = FND_API.G_MISS_NUM

1290: l_dummy VARCHAR2(10);
1291: BEGIN
1292:
1293: IF p_mutually_exclusive_opt IS NULL OR
1294: p_mutually_exclusive_opt = FND_API.G_MISS_NUM
1295: THEN
1296: RETURN TRUE;
1297: END IF;
1298:

Line 1322: p_include_in_cost_rollup = FND_API.G_MISS_NUM

1318: l_dummy VARCHAR2(10);
1319: BEGIN
1320:
1321: IF p_include_in_cost_rollup IS NULL OR
1322: p_include_in_cost_rollup = FND_API.G_MISS_NUM
1323: THEN
1324: RETURN TRUE;
1325: END IF;
1326:

Line 1353: p_check_atp = FND_API.G_MISS_NUM

1349: -- Validate ATP at the Entity level as it
1350: -- requires lot of additional information.
1351:
1352: IF p_check_atp IS NULL OR
1353: p_check_atp = FND_API.G_MISS_NUM
1354: THEN
1355: RETURN TRUE;
1356: ELSIF p_check_atp NOT IN (1, 2, 3) THEN
1357: RETURN FALSE;

Line 1378: p_shipping_allowed = FND_API.G_MISS_NUM

1374: l_dummy VARCHAR2(10);
1375: BEGIN
1376:
1377: IF p_shipping_allowed IS NULL OR
1378: p_shipping_allowed = FND_API.G_MISS_NUM
1379: THEN
1380: RETURN TRUE;
1381: END IF;
1382:

Line 1406: p_required_to_ship = FND_API.G_MISS_NUM

1402: l_dummy VARCHAR2(10);
1403: BEGIN
1404:
1405: IF p_required_to_ship IS NULL OR
1406: p_required_to_ship = FND_API.G_MISS_NUM
1407: THEN
1408: RETURN TRUE;
1409: END IF;
1410:

Line 1434: p_include_on_ship_docs = FND_API.G_MISS_NUM

1430: l_dummy VARCHAR2(10);
1431: BEGIN
1432:
1433: IF p_include_on_ship_docs IS NULL OR
1434: p_include_on_ship_docs = FND_API.G_MISS_NUM
1435: THEN
1436: RETURN TRUE;
1437: END IF;
1438:

Line 1758: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1754: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1755: )
1756: IS
1757: l_err_text VARCHAR2(2000) := NULL;
1758: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1759: check_delete NUMBER := 0;
1760: l_count1 NUMBER := 0;
1761: CURSOR rev_comps IS
1762: SELECT 1

Line 1807: l_return_status := FND_API.G_RET_STS_ERROR;

1803: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1804: , p_Token_Tbl => l_Token_Tbl
1805: );
1806: END IF;
1807: l_return_status := FND_API.G_RET_STS_ERROR;
1808: END LOOP;
1809:
1810:
1811:

Line 1831: l_return_status := FND_API.G_RET_STS_ERROR;

1827: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1828: , p_Token_Tbl => l_Token_Tbl
1829: );
1830: END IF;
1831: l_return_status := FND_API.G_RET_STS_ERROR;
1832: END LOOP;
1833: -- Added by MK on 08/26/2000
1834:
1835:

Line 1858: l_return_status := FND_API.G_RET_STS_ERROR;

1854: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1855: , p_Token_Tbl => l_Token_Tbl
1856: );
1857: END IF;
1858: l_return_status := FND_API.G_RET_STS_ERROR;
1859: END IF;
1860:
1861: /*********************************************************************
1862: -- Added by MK on 08/26/2000

Line 1882: l_return_status := FND_API.G_RET_STS_ERROR;

1878: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1879: , p_Token_Tbl => l_Token_Tbl
1880: );
1881: END IF;
1882: l_return_status := FND_API.G_RET_STS_ERROR;
1883: END IF;
1884: -- Added by MK on 08/26/2000
1885:
1886: -- Done with the validations

Line 1892: WHEN FND_API.G_EXC_ERROR THEN

1888: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1889:
1890: EXCEPTION
1891:
1892: WHEN FND_API.G_EXC_ERROR THEN
1893:
1894: x_return_status := FND_API.G_RET_STS_ERROR;
1895:
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1894: x_return_status := FND_API.G_RET_STS_ERROR;

1890: EXCEPTION
1891:
1892: WHEN FND_API.G_EXC_ERROR THEN
1893:
1894: x_return_status := FND_API.G_RET_STS_ERROR;
1895:
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1897:
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1892: WHEN FND_API.G_EXC_ERROR THEN
1893:
1894: x_return_status := FND_API.G_RET_STS_ERROR;
1895:
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1897:
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1899:
1900: WHEN OTHERS THEN

Line 1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1894: x_return_status := FND_API.G_RET_STS_ERROR;
1895:
1896: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1897:
1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1899:
1900: WHEN OTHERS THEN
1901:
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1899:
1900: WHEN OTHERS THEN
1901:
1902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1903:
1904: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1905: THEN
1906: l_err_text := G_PKG_NAME || ' : (Entity Delete Validation) ' ||