APPS.INV_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 := 'created_by';
31: I := I + 1;
32: FND_API.g_attr_tbl(I).name := 'creation_date';

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

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 := 'created_by';
31: I := I + 1;
32: FND_API.g_attr_tbl(I).name := 'creation_date';
33: I := I + 1;
34: FND_API.g_attr_tbl(I).name := 'date_required';

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

28: FND_API.g_attr_tbl(I).name := 'Desc_Flex';
29: I := I + 1;
30: FND_API.g_attr_tbl(I).name := 'created_by';
31: I := I + 1;
32: FND_API.g_attr_tbl(I).name := 'creation_date';
33: I := I + 1;
34: FND_API.g_attr_tbl(I).name := 'date_required';
35: I := I + 1;
36: FND_API.g_attr_tbl(I).name := 'description';

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

30: FND_API.g_attr_tbl(I).name := 'created_by';
31: I := I + 1;
32: FND_API.g_attr_tbl(I).name := 'creation_date';
33: I := I + 1;
34: FND_API.g_attr_tbl(I).name := 'date_required';
35: I := I + 1;
36: FND_API.g_attr_tbl(I).name := 'description';
37: I := I + 1;
38: FND_API.g_attr_tbl(I).name := 'from_subinventory';

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

32: FND_API.g_attr_tbl(I).name := 'creation_date';
33: I := I + 1;
34: FND_API.g_attr_tbl(I).name := 'date_required';
35: I := I + 1;
36: FND_API.g_attr_tbl(I).name := 'description';
37: I := I + 1;
38: FND_API.g_attr_tbl(I).name := 'from_subinventory';
39: I := I + 1;
40: FND_API.g_attr_tbl(I).name := 'header';

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

34: FND_API.g_attr_tbl(I).name := 'date_required';
35: I := I + 1;
36: FND_API.g_attr_tbl(I).name := 'description';
37: I := I + 1;
38: FND_API.g_attr_tbl(I).name := 'from_subinventory';
39: I := I + 1;
40: FND_API.g_attr_tbl(I).name := 'header';
41: I := I + 1;
42: FND_API.g_attr_tbl(I).name := 'header_status';

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

36: FND_API.g_attr_tbl(I).name := 'description';
37: I := I + 1;
38: FND_API.g_attr_tbl(I).name := 'from_subinventory';
39: I := I + 1;
40: FND_API.g_attr_tbl(I).name := 'header';
41: I := I + 1;
42: FND_API.g_attr_tbl(I).name := 'header_status';
43: I := I + 1;
44: FND_API.g_attr_tbl(I).name := 'last_updated_by';

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

38: FND_API.g_attr_tbl(I).name := 'from_subinventory';
39: I := I + 1;
40: FND_API.g_attr_tbl(I).name := 'header';
41: I := I + 1;
42: FND_API.g_attr_tbl(I).name := 'header_status';
43: I := I + 1;
44: FND_API.g_attr_tbl(I).name := 'last_updated_by';
45: I := I + 1;
46: FND_API.g_attr_tbl(I).name := 'last_update_date';

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

40: FND_API.g_attr_tbl(I).name := 'header';
41: I := I + 1;
42: FND_API.g_attr_tbl(I).name := 'header_status';
43: I := I + 1;
44: FND_API.g_attr_tbl(I).name := 'last_updated_by';
45: I := I + 1;
46: FND_API.g_attr_tbl(I).name := 'last_update_date';
47: I := I + 1;
48: FND_API.g_attr_tbl(I).name := 'last_update_login';

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

42: FND_API.g_attr_tbl(I).name := 'header_status';
43: I := I + 1;
44: FND_API.g_attr_tbl(I).name := 'last_updated_by';
45: I := I + 1;
46: FND_API.g_attr_tbl(I).name := 'last_update_date';
47: I := I + 1;
48: FND_API.g_attr_tbl(I).name := 'last_update_login';
49: I := I + 1;
50: FND_API.g_attr_tbl(I).name := 'organization';

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

44: FND_API.g_attr_tbl(I).name := 'last_updated_by';
45: I := I + 1;
46: FND_API.g_attr_tbl(I).name := 'last_update_date';
47: I := I + 1;
48: FND_API.g_attr_tbl(I).name := 'last_update_login';
49: I := I + 1;
50: FND_API.g_attr_tbl(I).name := 'organization';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'program_application';

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

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

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

48: FND_API.g_attr_tbl(I).name := 'last_update_login';
49: I := I + 1;
50: FND_API.g_attr_tbl(I).name := 'organization';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'program_application';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'program';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'program_update_date';

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

50: FND_API.g_attr_tbl(I).name := 'organization';
51: I := I + 1;
52: FND_API.g_attr_tbl(I).name := 'program_application';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'program';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'program_update_date';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'request';

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

52: FND_API.g_attr_tbl(I).name := 'program_application';
53: I := I + 1;
54: FND_API.g_attr_tbl(I).name := 'program';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'program_update_date';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'request';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'request_number';

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

54: FND_API.g_attr_tbl(I).name := 'program';
55: I := I + 1;
56: FND_API.g_attr_tbl(I).name := 'program_update_date';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'request';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'request_number';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'status_date';

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

56: FND_API.g_attr_tbl(I).name := 'program_update_date';
57: I := I + 1;
58: FND_API.g_attr_tbl(I).name := 'request';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'request_number';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'status_date';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'to_account';

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

58: FND_API.g_attr_tbl(I).name := 'request';
59: I := I + 1;
60: FND_API.g_attr_tbl(I).name := 'request_number';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'status_date';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'to_account';
65: I := I + 1;
66: FND_API.g_attr_tbl(I).name := 'to_subinventory';

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

60: FND_API.g_attr_tbl(I).name := 'request_number';
61: I := I + 1;
62: FND_API.g_attr_tbl(I).name := 'status_date';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'to_account';
65: I := I + 1;
66: FND_API.g_attr_tbl(I).name := 'to_subinventory';
67: I := I + 1;
68: FND_API.g_attr_tbl(I).name := 'transaction_type';

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

62: FND_API.g_attr_tbl(I).name := 'status_date';
63: I := I + 1;
64: FND_API.g_attr_tbl(I).name := 'to_account';
65: I := I + 1;
66: FND_API.g_attr_tbl(I).name := 'to_subinventory';
67: I := I + 1;
68: FND_API.g_attr_tbl(I).name := 'transaction_type';
69: I := I + 1;
70: FND_API.g_attr_tbl(I).name := 'from_locator';

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

64: FND_API.g_attr_tbl(I).name := 'to_account';
65: I := I + 1;
66: FND_API.g_attr_tbl(I).name := 'to_subinventory';
67: I := I + 1;
68: FND_API.g_attr_tbl(I).name := 'transaction_type';
69: I := I + 1;
70: FND_API.g_attr_tbl(I).name := 'from_locator';
71: I := I + 1;
72: FND_API.g_attr_tbl(I).name := 'inventory_item';

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

66: FND_API.g_attr_tbl(I).name := 'to_subinventory';
67: I := I + 1;
68: FND_API.g_attr_tbl(I).name := 'transaction_type';
69: I := I + 1;
70: FND_API.g_attr_tbl(I).name := 'from_locator';
71: I := I + 1;
72: FND_API.g_attr_tbl(I).name := 'inventory_item';
73: I := I + 1;
74: FND_API.g_attr_tbl(I).name := 'line';

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

68: FND_API.g_attr_tbl(I).name := 'transaction_type';
69: I := I + 1;
70: FND_API.g_attr_tbl(I).name := 'from_locator';
71: I := I + 1;
72: FND_API.g_attr_tbl(I).name := 'inventory_item';
73: I := I + 1;
74: FND_API.g_attr_tbl(I).name := 'line';
75: I := I + 1;
76: FND_API.g_attr_tbl(I).name := 'line_number';

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

70: FND_API.g_attr_tbl(I).name := 'from_locator';
71: I := I + 1;
72: FND_API.g_attr_tbl(I).name := 'inventory_item';
73: I := I + 1;
74: FND_API.g_attr_tbl(I).name := 'line';
75: I := I + 1;
76: FND_API.g_attr_tbl(I).name := 'line_number';
77: I := I + 1;
78: FND_API.g_attr_tbl(I).name := 'line_status';

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

72: FND_API.g_attr_tbl(I).name := 'inventory_item';
73: I := I + 1;
74: FND_API.g_attr_tbl(I).name := 'line';
75: I := I + 1;
76: FND_API.g_attr_tbl(I).name := 'line_number';
77: I := I + 1;
78: FND_API.g_attr_tbl(I).name := 'line_status';
79: I := I + 1;
80: FND_API.g_attr_tbl(I).name := 'lot_number';

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

74: FND_API.g_attr_tbl(I).name := 'line';
75: I := I + 1;
76: FND_API.g_attr_tbl(I).name := 'line_number';
77: I := I + 1;
78: FND_API.g_attr_tbl(I).name := 'line_status';
79: I := I + 1;
80: FND_API.g_attr_tbl(I).name := 'lot_number';
81: I := I + 1;
82: FND_API.g_attr_tbl(I).name := 'project';

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

76: FND_API.g_attr_tbl(I).name := 'line_number';
77: I := I + 1;
78: FND_API.g_attr_tbl(I).name := 'line_status';
79: I := I + 1;
80: FND_API.g_attr_tbl(I).name := 'lot_number';
81: I := I + 1;
82: FND_API.g_attr_tbl(I).name := 'project';
83: I := I + 1;
84: FND_API.g_attr_tbl(I).name := 'quantity';

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

78: FND_API.g_attr_tbl(I).name := 'line_status';
79: I := I + 1;
80: FND_API.g_attr_tbl(I).name := 'lot_number';
81: I := I + 1;
82: FND_API.g_attr_tbl(I).name := 'project';
83: I := I + 1;
84: FND_API.g_attr_tbl(I).name := 'quantity';
85: I := I + 1;
86: FND_API.g_attr_tbl(I).name := 'quantity_delivered';

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

80: FND_API.g_attr_tbl(I).name := 'lot_number';
81: I := I + 1;
82: FND_API.g_attr_tbl(I).name := 'project';
83: I := I + 1;
84: FND_API.g_attr_tbl(I).name := 'quantity';
85: I := I + 1;
86: FND_API.g_attr_tbl(I).name := 'quantity_delivered';
87: I := I + 1;
88: FND_API.g_attr_tbl(I).name := 'quantity_detailed';

Line 86: FND_API.g_attr_tbl(I).name := 'quantity_delivered';

82: FND_API.g_attr_tbl(I).name := 'project';
83: I := I + 1;
84: FND_API.g_attr_tbl(I).name := 'quantity';
85: I := I + 1;
86: FND_API.g_attr_tbl(I).name := 'quantity_delivered';
87: I := I + 1;
88: FND_API.g_attr_tbl(I).name := 'quantity_detailed';
89: I := I + 1;
90: FND_API.g_attr_tbl(I).name := 'reason';

Line 88: FND_API.g_attr_tbl(I).name := 'quantity_detailed';

84: FND_API.g_attr_tbl(I).name := 'quantity';
85: I := I + 1;
86: FND_API.g_attr_tbl(I).name := 'quantity_delivered';
87: I := I + 1;
88: FND_API.g_attr_tbl(I).name := 'quantity_detailed';
89: I := I + 1;
90: FND_API.g_attr_tbl(I).name := 'reason';
91: I := I + 1;
92: FND_API.g_attr_tbl(I).name := 'reference';

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

86: FND_API.g_attr_tbl(I).name := 'quantity_delivered';
87: I := I + 1;
88: FND_API.g_attr_tbl(I).name := 'quantity_detailed';
89: I := I + 1;
90: FND_API.g_attr_tbl(I).name := 'reason';
91: I := I + 1;
92: FND_API.g_attr_tbl(I).name := 'reference';
93: I := I + 1;
94: FND_API.g_attr_tbl(I).name := 'reference';

Line 92: FND_API.g_attr_tbl(I).name := 'reference';

88: FND_API.g_attr_tbl(I).name := 'quantity_detailed';
89: I := I + 1;
90: FND_API.g_attr_tbl(I).name := 'reason';
91: I := I + 1;
92: FND_API.g_attr_tbl(I).name := 'reference';
93: I := I + 1;
94: FND_API.g_attr_tbl(I).name := 'reference';
95: I := I + 1;
96: FND_API.g_attr_tbl(I).name := 'reference_type';

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

90: FND_API.g_attr_tbl(I).name := 'reason';
91: I := I + 1;
92: FND_API.g_attr_tbl(I).name := 'reference';
93: I := I + 1;
94: FND_API.g_attr_tbl(I).name := 'reference';
95: I := I + 1;
96: FND_API.g_attr_tbl(I).name := 'reference_type';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'revision';

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

92: FND_API.g_attr_tbl(I).name := 'reference';
93: I := I + 1;
94: FND_API.g_attr_tbl(I).name := 'reference';
95: I := I + 1;
96: FND_API.g_attr_tbl(I).name := 'reference_type';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'revision';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'serial_number_end';

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

94: FND_API.g_attr_tbl(I).name := 'reference';
95: I := I + 1;
96: FND_API.g_attr_tbl(I).name := 'reference_type';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'revision';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'serial_number_end';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'serial_number_start';

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

96: FND_API.g_attr_tbl(I).name := 'reference_type';
97: I := I + 1;
98: FND_API.g_attr_tbl(I).name := 'revision';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'serial_number_end';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'serial_number_start';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'task';

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

98: FND_API.g_attr_tbl(I).name := 'revision';
99: I := I + 1;
100: FND_API.g_attr_tbl(I).name := 'serial_number_end';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'serial_number_start';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'task';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'to_locator';

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

100: FND_API.g_attr_tbl(I).name := 'serial_number_end';
101: I := I + 1;
102: FND_API.g_attr_tbl(I).name := 'serial_number_start';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'task';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'to_locator';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'transaction_header';

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

102: FND_API.g_attr_tbl(I).name := 'serial_number_start';
103: I := I + 1;
104: FND_API.g_attr_tbl(I).name := 'task';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'to_locator';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'transaction_header';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'uom';

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

104: FND_API.g_attr_tbl(I).name := 'task';
105: I := I + 1;
106: FND_API.g_attr_tbl(I).name := 'to_locator';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'transaction_header';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'uom';
111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'uom';

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

106: FND_API.g_attr_tbl(I).name := 'to_locator';
107: I := I + 1;
108: FND_API.g_attr_tbl(I).name := 'transaction_header';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'uom';
111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'uom';
113: --INVCONV
114: I := I + 1;

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

108: FND_API.g_attr_tbl(I).name := 'transaction_header';
109: I := I + 1;
110: FND_API.g_attr_tbl(I).name := 'uom';
111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'uom';
113: --INVCONV
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'secondary_uom';
116: I := I + 1;

Line 115: FND_API.g_attr_tbl(I).name := 'secondary_uom';

111: I := I + 1;
112: FND_API.g_attr_tbl(I).name := 'uom';
113: --INVCONV
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'secondary_uom';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'secondary_quantity';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'secondary_quantity_delivered';

Line 117: FND_API.g_attr_tbl(I).name := 'secondary_quantity';

113: --INVCONV
114: I := I + 1;
115: FND_API.g_attr_tbl(I).name := 'secondary_uom';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'secondary_quantity';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'secondary_quantity_delivered';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'secondary_quantity_detailed';

Line 119: FND_API.g_attr_tbl(I).name := 'secondary_quantity_delivered';

115: FND_API.g_attr_tbl(I).name := 'secondary_uom';
116: I := I + 1;
117: FND_API.g_attr_tbl(I).name := 'secondary_quantity';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'secondary_quantity_delivered';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'secondary_quantity_detailed';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'grade_code';

Line 121: FND_API.g_attr_tbl(I).name := 'secondary_quantity_detailed';

117: FND_API.g_attr_tbl(I).name := 'secondary_quantity';
118: I := I + 1;
119: FND_API.g_attr_tbl(I).name := 'secondary_quantity_delivered';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'secondary_quantity_detailed';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'grade_code';
124: --INVCONV
125:

Line 123: FND_API.g_attr_tbl(I).name := 'grade_code';

119: FND_API.g_attr_tbl(I).name := 'secondary_quantity_delivered';
120: I := I + 1;
121: FND_API.g_attr_tbl(I).name := 'secondary_quantity_detailed';
122: I := I + 1;
123: FND_API.g_attr_tbl(I).name := 'grade_code';
124: --INVCONV
125:
126: -- END GEN attributes
127:

Line 165: p_created_updated_by = FND_API.G_MISS_NUM

161:
162: begin
163:
164: IF p_created_updated_by IS NULL OR
165: p_created_updated_by = FND_API.G_MISS_NUM
166: then
167: return p_is_creation;
168: END IF;
169:

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206: );
207: END IF;
208: end if;
209:
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211:
212: end check_creation_updation;
213:
214:

Line 235: p_date = FND_API.G_MISS_DATE

231: RETURN NUMBER
232: is
233: begin
234: IF p_date IS NULL OR
235: p_date = FND_API.G_MISS_DATE
236: THEN
237: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
238: THEN
239: FND_MESSAGE.SET_NAME('INV','INV_ATTRIBUTE_REQUIRED');

Line 429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

425: , 'Employee'
426: );
427: END IF;
428:
429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
430:
431:
432: END employee;
433:

Line 448: p_sub.secondary_inventory_name = FND_API.G_MISS_CHAR

444: v_expense_to_asset_profile VARCHAR2(1);
445: BEGIN
446:
447: IF p_sub.secondary_inventory_name IS NULL OR
448: p_sub.secondary_inventory_name = FND_API.G_MISS_CHAR
449: THEN
450: RETURN F;
451: END IF;
452:

Line 555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

551: , 'From_Subinventory'
552: );
553: END IF;
554:
555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
556:
557: END From_Subinventory;
558:
559: -- ---------------------------------------------------------------------

Line 659: p_last_update_login = FND_API.G_MISS_NUM

655: l_dummy VARCHAR2(10);
656: BEGIN
657:
658: IF p_last_update_login IS NULL OR
659: p_last_update_login = FND_API.G_MISS_NUM
660: THEN
661: RETURN T;
662: END IF;
663:

Line 691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

687: , 'Last_Update_Login'
688: );
689: END IF;
690:
691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
692:
693: END Last_Update_Login;
694:
695:

Line 705: p_org.organization_id = FND_API.G_MISS_NUM

701:
702: BEGIN
703:
704: IF (p_org.organization_id IS NULL AND p_org.organization_code IS NULL) OR
705: p_org.organization_id = FND_API.G_MISS_NUM
706: THEN
707: RETURN F;
708: END IF;
709:

Line 749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

745: , 'Organization'
746: );
747: END IF;
748:
749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
750:
751: END Organization;
752:
753:

Line 795: p_to_account_id = FND_API.G_MISS_NUM

791: l_dummy VARCHAR2(10);
792: BEGIN
793:
794: IF p_to_account_id IS NULL OR
795: p_to_account_id = FND_API.G_MISS_NUM
796: THEN
797: RETURN T;
798: END IF;
799:

Line 832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

828: , 'To_Account'
829: );
830: END IF;
831:
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833:
834: END To_Account;
835:
836:

Line 851: p_sub.secondary_inventory_name = FND_API.G_MISS_CHAR

847: v_expense_to_asset_profile VARCHAR2(1);
848: BEGIN
849:
850: IF p_sub.secondary_inventory_name IS NULL OR
851: p_sub.secondary_inventory_name = FND_API.G_MISS_CHAR
852: THEN
853: RETURN T;
854: END IF;
855: FND_PROFILE.GET('INV:EXPENSE_TO_ASSET_TRANSFER',v_expense_to_asset_profile);

Line 969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

965: ( G_PKG_NAME
966: , 'To_Subinventory'
967: );
968: END IF;
969: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
970: END To_Subinventory;
971:
972: -- ---------------------------------------------------------------------
973: -- ---------------------------------------------------------------------

Line 1051: p_transaction_type_id = FND_API.G_MISS_NUM

1047:
1048: BEGIN
1049:
1050: IF p_transaction_type_id IS NULL OR
1051: p_transaction_type_id = FND_API.G_MISS_NUM
1052: THEN
1053: FND_MESSAGE.SET_NAME('INV','INV_INT_TRXTYPCODE');
1054: FND_MSG_PUB.Add;
1055: RETURN F;

Line 1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1088: , 'Transaction_Type'
1089: );
1090: END IF;
1091:
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093:
1094: /*
1095: IF p_transaction_type_id IN (63,64) THEN
1096: RETURN T;

Line 1113: x_transaction.transaction_type_id = FND_API.G_MISS_NUM

1109:
1110: BEGIN
1111:
1112: IF x_transaction.transaction_type_id IS NULL OR
1113: x_transaction.transaction_type_id = FND_API.G_MISS_NUM
1114: THEN
1115: FND_MESSAGE.SET_NAME('INV','INV_INT_TRXTYPCODE');
1116: FND_MSG_PUB.Add;
1117: RETURN F;

Line 1154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1150: , 'Transaction_Type'
1151: );
1152: END IF;
1153:
1154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1155:
1156: END Transaction_Type;
1157:
1158: -- ---------------------------------------------------------------------

Line 1182: p_locator.inventory_location_id = FND_API.G_MISS_NUM

1178:
1179: BEGIN
1180:
1181: IF p_locator.inventory_location_id IS NULL OR
1182: p_locator.inventory_location_id = FND_API.G_MISS_NUM
1183: THEN
1184: RETURN T;
1185: END IF;
1186: v_locator_control := INV_Globals.Locator_control(

Line 1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1272: );
1273: end if;
1274: END IF;
1275:
1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1277:
1278: END check_locator;
1279:
1280:

Line 1382: -- p_item.inventory_item_id = FND_API.g_miss_num) AND

1378:
1379: BEGIN
1380:
1381: -- IF (p_item.inventory_item_id IS NULL OR
1382: -- p_item.inventory_item_id = FND_API.g_miss_num) AND
1383: -- p_validation_mode IS NULL
1384: -- THEN
1385: -- RETURN F;
1386: -- END IF;

Line 1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1470: , 'Inventory_Item'
1471: );
1472: END IF;
1473:
1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1475:
1476: END Inventory_Item;
1477:
1478: /***Added overloaded function to pass the transaction_type_id, because

Line 1496: -- p_item.inventory_item_id = FND_API.g_miss_num) AND

1492:
1493: BEGIN
1494:
1495: -- IF (p_item.inventory_item_id IS NULL OR
1496: -- p_item.inventory_item_id = FND_API.g_miss_num) AND
1497: -- p_validation_mode IS NULL
1498: -- THEN
1499: -- RETURN F;
1500: -- END IF;

Line 1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1590: , 'Inventory_Item'
1591: );
1592: END IF;
1593:
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595:
1596: END Inventory_Item;
1597:
1598: -- ---------------------------------------------------------------------

Line 1623: p_locator.inventory_location_id = FND_API.g_miss_num)

1619: g_orgid := p_org.organization_id;
1620: end if;
1621:
1622: IF (p_locator.inventory_location_id IS NULL OR
1623: p_locator.inventory_location_id = FND_API.g_miss_num)
1624: THEN
1625: g_kf_segment_values(1) := p_locator.segment1;
1626: g_kf_segment_values(2) := p_locator.segment2;
1627: g_kf_segment_values(3) := p_locator.segment3;

Line 1712: RAISE fnd_api.g_exc_unexpected_error;

1708: THEN
1709: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub');
1710: END IF;
1711: -- RETURN f;
1712: RAISE fnd_api.g_exc_unexpected_error;
1713:
1714: END validateLocator;
1715:
1716:

Line 1727: p_locator.inventory_location_id = FND_API.G_MISS_NUM

1723: RETURN NUMBER
1724: IS
1725: BEGIN
1726: IF p_locator.inventory_location_id IS NULL OR
1727: p_locator.inventory_location_id = FND_API.G_MISS_NUM
1728: THEN
1729: RETURN F;
1730: END IF;
1731:

Line 1768: RAISE fnd_api.g_exc_unexpected_error;

1764: THEN
1765: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub,item');
1766: END IF;
1767:
1768: RAISE fnd_api.g_exc_unexpected_error;
1769:
1770: END validateLocator;
1771:
1772:

Line 1853: p_lot.lot_number = FND_API.G_MISS_CHAR

1849: l_dummy VARCHAR2(10);
1850:
1851: BEGIN
1852: IF p_lot.lot_number IS NULL OR
1853: p_lot.lot_number = FND_API.G_MISS_CHAR
1854: THEN
1855: RETURN T;
1856: END IF;
1857:

Line 1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1903: , 'Lot_Number'
1904: );
1905: END IF;
1906:
1907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1908:
1909: END Lot_Number;
1910:
1911: -- ---------------------------------------------------------------------

Line 1993: p_project_id = FND_API.G_MISS_NUM

1989: l_organization_id NUMBER;
1990: BEGIN
1991:
1992: IF p_project_id IS NULL OR
1993: p_project_id = FND_API.G_MISS_NUM
1994: THEN
1995: RETURN T;
1996: END IF;
1997:

Line 2029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2025: , 'Project'
2026: );
2027: END IF;
2028:
2029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2030:
2031: END Project;
2032:
2033:

Line 2041: p_quantity = FND_API.G_MISS_NUM

2037: RETURN NUMBER
2038: IS
2039: BEGIN
2040: IF p_quantity IS NULL OR
2041: p_quantity = FND_API.G_MISS_NUM
2042: THEN
2043: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
2044: THEN
2045: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');

Line 2063: p_reason_id = FND_API.G_MISS_NUM

2059: l_dummy VARCHAR2(10);
2060: BEGIN
2061:
2062: IF p_reason_id IS NULL OR
2063: p_reason_id = FND_API.G_MISS_NUM
2064: THEN
2065: RETURN T;
2066: END IF;
2067:

Line 2100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2096: , 'Reason'
2097: );
2098: END IF;
2099:
2100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2101:
2102: END Reason;
2103:
2104:

Line 2125: p_reference_id = FND_API.G_MISS_NUM

2121: l_dummy VARCHAR2(10);
2122: BEGIN
2123:
2124: IF p_reference_id IS NULL OR
2125: p_reference_id = FND_API.G_MISS_NUM
2126: THEN
2127: RETURN T;
2128: END IF;
2129:

Line 2168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2164: , 'Reference'
2165: );
2166: END IF;
2167:
2168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2169:
2170: END Reference;
2171:
2172:

Line 2182: p_reference_type_code = FND_API.G_MISS_NUM

2178: l_dummy VARCHAR2(10);
2179: BEGIN
2180:
2181: IF p_reference_type_code IS NULL OR
2182: p_reference_type_code = FND_API.G_MISS_NUM
2183: THEN
2184: RETURN T;
2185: END IF;
2186:

Line 2220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2216: , 'Reference_Type'
2217: );
2218: END IF;
2219:
2220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2221:
2222: END Reference_Type;
2223:
2224:

Line 2233: p_revision = FND_API.G_MISS_CHAR

2229: IS
2230: l_dummy VARCHAR2(10);
2231: BEGIN
2232: IF p_revision IS NULL OR
2233: p_revision = FND_API.G_MISS_CHAR
2234: THEN
2235: RETURN T;
2236: END IF;
2237:

Line 2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2273: , 'Revision'
2274: );
2275: END IF;
2276:
2277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2278:
2279: END Revision;
2280:
2281:

Line 2300: p_serial.serial_number = FND_API.G_MISS_CHAR

2296:
2297: BEGIN
2298:
2299: IF p_serial.serial_number IS NULL OR
2300: p_serial.serial_number = FND_API.G_MISS_CHAR
2301: THEN
2302: RETURN T;
2303: END IF;
2304:

Line 2385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2381: , 'Check_serial_number'
2382: );
2383: END IF;
2384:
2385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2386:
2387: end check_serial;
2388:
2389: -- ---------------------------------------------------------------------

Line 2739: p_sub.secondary_inventory_name = fnd_api.g_miss_char

2735: RETURN NUMBER
2736: IS
2737: BEGIN
2738: IF p_sub.secondary_inventory_name IS NULL OR
2739: p_sub.secondary_inventory_name = fnd_api.g_miss_char
2740: THEN
2741: RETURN F;
2742: END IF;
2743:

Line 2772: RAISE fnd_api.g_exc_unexpected_error;

2768: THEN
2769: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2770: END IF;
2771:
2772: RAISE fnd_api.g_exc_unexpected_error;
2773:
2774: END subinventory;
2775:
2776:

Line 2787: p_sub.secondary_inventory_name = fnd_api.g_miss_char

2783: RETURN NUMBER
2784: IS
2785: BEGIN
2786: IF p_sub.secondary_inventory_name IS NULL OR
2787: p_sub.secondary_inventory_name = fnd_api.g_miss_char
2788: THEN
2789: RETURN F;
2790: END IF;
2791:

Line 2823: RAISE fnd_api.g_exc_unexpected_error;

2819: THEN
2820: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2821: END IF;
2822:
2823: RAISE fnd_api.g_exc_unexpected_error;
2824:
2825: END subinventory;
2826:
2827:

Line 2838: p_task_id = FND_API.G_MISS_NUM

2834: l_dummy VARCHAR2(10);
2835: BEGIN
2836:
2837: IF p_task_id IS NULL OR
2838: p_task_id = FND_API.G_MISS_NUM
2839: THEN
2840: RETURN T;
2841: END IF;
2842:

Line 2875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2871: , 'Task'
2872: );
2873: END IF;
2874:
2875: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2876:
2877: END Task;
2878:
2879:

Line 2920: p_hr_location = FND_API.G_MISS_NUM

2916: l_dummy VARCHAR2(20);
2917: BEGIN
2918:
2919: IF p_hr_location IS NULL OR
2920: p_hr_location = FND_API.G_MISS_NUM
2921: then
2922: return T;
2923: END IF;
2924:

Line 2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2966: , 'Task'
2967: );
2968: END IF;
2969:
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: END;
2972:
2973:
2974: -- ---------------------------------------------------------------------

Line 2983: p_uom_code = FND_API.G_MISS_CHAR

2979: l_dummy VARCHAR2(10);
2980: BEGIN
2981:
2982: IF p_uom_code IS NULL OR
2983: p_uom_code = FND_API.G_MISS_CHAR
2984: THEN
2985: RETURN F;
2986: END IF;
2987:

Line 3030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3026: );
3027: END IF;
3028:
3029: RETURN F; --Bug2902031
3030: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3031:
3032: END Uom;
3033:
3034: -- END GEN validate

Line 3095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3091: WHEN OTHERS THEN
3092: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3093: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cost Group');
3094: END IF;
3095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3096: return F;
3097: END;
3098:
3099: FUNCTION LPN( p_lpn_id IN NUMBER) return NUMBER

Line 3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3118: WHEN OTHERS THEN
3119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3120: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'LPN');
3121: END IF;
3122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3123: return F;
3124: END;
3125:
3126:

Line 3142: p_lot.lot_number = FND_API.G_MISS_CHAR

3138: l_dummy VARCHAR2(10);
3139:
3140: BEGIN
3141: IF p_lot.lot_number IS NULL OR
3142: p_lot.lot_number = FND_API.G_MISS_CHAR
3143: THEN
3144: RETURN T;
3145: END IF;
3146:

Line 3187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3183: , 'Lot_Number'
3184: );
3185: END IF;
3186:
3187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3188:
3189: END Lot_Number;
3190: -- ---------------------------------------------------------------------
3191: --INVCONV

Line 3198: p_secondary_quantity = FND_API.G_MISS_NUM

3194: RETURN NUMBER
3195: IS
3196: BEGIN
3197: IF p_secondary_quantity IS NULL OR
3198: p_secondary_quantity = FND_API.G_MISS_NUM
3199: THEN
3200: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3201: THEN
3202: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');