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 423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

419: , 'Employee'
420: );
421: END IF;
422:
423: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
424:
425:
426: END employee;
427:

Line 442: p_sub.secondary_inventory_name = FND_API.G_MISS_CHAR

438: v_expense_to_asset_profile VARCHAR2(1);
439: BEGIN
440:
441: IF p_sub.secondary_inventory_name IS NULL OR
442: p_sub.secondary_inventory_name = FND_API.G_MISS_CHAR
443: THEN
444: RETURN F;
445: END IF;
446:

Line 549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

545: , 'From_Subinventory'
546: );
547: END IF;
548:
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550:
551: END From_Subinventory;
552:
553: -- ---------------------------------------------------------------------

Line 653: p_last_update_login = FND_API.G_MISS_NUM

649: l_dummy VARCHAR2(10);
650: BEGIN
651:
652: IF p_last_update_login IS NULL OR
653: p_last_update_login = FND_API.G_MISS_NUM
654: THEN
655: RETURN T;
656: END IF;
657:

Line 685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

681: , 'Last_Update_Login'
682: );
683: END IF;
684:
685: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
686:
687: END Last_Update_Login;
688:
689:

Line 699: p_org.organization_id = FND_API.G_MISS_NUM

695:
696: BEGIN
697:
698: IF (p_org.organization_id IS NULL AND p_org.organization_code IS NULL) OR
699: p_org.organization_id = FND_API.G_MISS_NUM
700: THEN
701: RETURN F;
702: END IF;
703:

Line 743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

739: , 'Organization'
740: );
741: END IF;
742:
743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
744:
745: END Organization;
746:
747:

Line 789: p_to_account_id = FND_API.G_MISS_NUM

785: l_dummy VARCHAR2(10);
786: BEGIN
787:
788: IF p_to_account_id IS NULL OR
789: p_to_account_id = FND_API.G_MISS_NUM
790: THEN
791: RETURN T;
792: END IF;
793:

Line 826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

822: , 'To_Account'
823: );
824: END IF;
825:
826: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
827:
828: END To_Account;
829:
830:

Line 845: p_sub.secondary_inventory_name = FND_API.G_MISS_CHAR

841: v_expense_to_asset_profile VARCHAR2(1);
842: BEGIN
843:
844: IF p_sub.secondary_inventory_name IS NULL OR
845: p_sub.secondary_inventory_name = FND_API.G_MISS_CHAR
846: THEN
847: RETURN T;
848: END IF;
849: FND_PROFILE.GET('INV:EXPENSE_TO_ASSET_TRANSFER',v_expense_to_asset_profile);

Line 963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

959: ( G_PKG_NAME
960: , 'To_Subinventory'
961: );
962: END IF;
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: END To_Subinventory;
965:
966: -- ---------------------------------------------------------------------
967: -- ---------------------------------------------------------------------

Line 1045: p_transaction_type_id = FND_API.G_MISS_NUM

1041:
1042: BEGIN
1043:
1044: IF p_transaction_type_id IS NULL OR
1045: p_transaction_type_id = FND_API.G_MISS_NUM
1046: THEN
1047: FND_MESSAGE.SET_NAME('INV','INV_INT_TRXTYPCODE');
1048: FND_MSG_PUB.Add;
1049: RETURN F;

Line 1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1082: , 'Transaction_Type'
1083: );
1084: END IF;
1085:
1086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1087:
1088: /*
1089: IF p_transaction_type_id IN (63,64) THEN
1090: RETURN T;

Line 1107: x_transaction.transaction_type_id = FND_API.G_MISS_NUM

1103:
1104: BEGIN
1105:
1106: IF x_transaction.transaction_type_id IS NULL OR
1107: x_transaction.transaction_type_id = FND_API.G_MISS_NUM
1108: THEN
1109: FND_MESSAGE.SET_NAME('INV','INV_INT_TRXTYPCODE');
1110: FND_MSG_PUB.Add;
1111: RETURN F;

Line 1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1144: , 'Transaction_Type'
1145: );
1146: END IF;
1147:
1148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1149:
1150: END Transaction_Type;
1151:
1152: -- ---------------------------------------------------------------------

Line 1176: p_locator.inventory_location_id = FND_API.G_MISS_NUM

1172:
1173: BEGIN
1174:
1175: IF p_locator.inventory_location_id IS NULL OR
1176: p_locator.inventory_location_id = FND_API.G_MISS_NUM
1177: THEN
1178: RETURN T;
1179: END IF;
1180: v_locator_control := INV_Globals.Locator_control(

Line 1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1266: );
1267: end if;
1268: END IF;
1269:
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271:
1272: END check_locator;
1273:
1274:

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

1372:
1373: BEGIN
1374:
1375: -- IF (p_item.inventory_item_id IS NULL OR
1376: -- p_item.inventory_item_id = FND_API.g_miss_num) AND
1377: -- p_validation_mode IS NULL
1378: -- THEN
1379: -- RETURN F;
1380: -- END IF;

Line 1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1464: , 'Inventory_Item'
1465: );
1466: END IF;
1467:
1468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1469:
1470: END Inventory_Item;
1471:
1472:

Line 1498: p_locator.inventory_location_id = FND_API.g_miss_num)

1494: g_orgid := p_org.organization_id;
1495: end if;
1496:
1497: IF (p_locator.inventory_location_id IS NULL OR
1498: p_locator.inventory_location_id = FND_API.g_miss_num)
1499: THEN
1500: g_kf_segment_values(1) := p_locator.segment1;
1501: g_kf_segment_values(2) := p_locator.segment2;
1502: g_kf_segment_values(3) := p_locator.segment3;

Line 1587: RAISE fnd_api.g_exc_unexpected_error;

1583: THEN
1584: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub');
1585: END IF;
1586: -- RETURN f;
1587: RAISE fnd_api.g_exc_unexpected_error;
1588:
1589: END validateLocator;
1590:
1591:

Line 1602: p_locator.inventory_location_id = FND_API.G_MISS_NUM

1598: RETURN NUMBER
1599: IS
1600: BEGIN
1601: IF p_locator.inventory_location_id IS NULL OR
1602: p_locator.inventory_location_id = FND_API.G_MISS_NUM
1603: THEN
1604: RETURN F;
1605: END IF;
1606:

Line 1643: RAISE fnd_api.g_exc_unexpected_error;

1639: THEN
1640: fnd_msg_pub.add_exc_msg(g_pkg_name, 'validateLocator:org,sub,item');
1641: END IF;
1642:
1643: RAISE fnd_api.g_exc_unexpected_error;
1644:
1645: END validateLocator;
1646:
1647:

Line 1728: p_lot.lot_number = FND_API.G_MISS_CHAR

1724: l_dummy VARCHAR2(10);
1725:
1726: BEGIN
1727: IF p_lot.lot_number IS NULL OR
1728: p_lot.lot_number = FND_API.G_MISS_CHAR
1729: THEN
1730: RETURN T;
1731: END IF;
1732:

Line 1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1778: , 'Lot_Number'
1779: );
1780: END IF;
1781:
1782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1783:
1784: END Lot_Number;
1785:
1786: -- ---------------------------------------------------------------------

Line 1866: p_project_id = FND_API.G_MISS_NUM

1862: l_organization_id NUMBER;
1863: BEGIN
1864:
1865: IF p_project_id IS NULL OR
1866: p_project_id = FND_API.G_MISS_NUM
1867: THEN
1868: RETURN T;
1869: END IF;
1870:

Line 1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1898: , 'Project'
1899: );
1900: END IF;
1901:
1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903:
1904: END Project;
1905:
1906:

Line 1914: p_quantity = FND_API.G_MISS_NUM

1910: RETURN NUMBER
1911: IS
1912: BEGIN
1913: IF p_quantity IS NULL OR
1914: p_quantity = FND_API.G_MISS_NUM
1915: THEN
1916: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1917: THEN
1918: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');

Line 1936: p_reason_id = FND_API.G_MISS_NUM

1932: l_dummy VARCHAR2(10);
1933: BEGIN
1934:
1935: IF p_reason_id IS NULL OR
1936: p_reason_id = FND_API.G_MISS_NUM
1937: THEN
1938: RETURN T;
1939: END IF;
1940:

Line 1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1969: , 'Reason'
1970: );
1971: END IF;
1972:
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974:
1975: END Reason;
1976:
1977:

Line 1998: p_reference_id = FND_API.G_MISS_NUM

1994: l_dummy VARCHAR2(10);
1995: BEGIN
1996:
1997: IF p_reference_id IS NULL OR
1998: p_reference_id = FND_API.G_MISS_NUM
1999: THEN
2000: RETURN T;
2001: END IF;
2002:

Line 2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2037: , 'Reference'
2038: );
2039: END IF;
2040:
2041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2042:
2043: END Reference;
2044:
2045:

Line 2055: p_reference_type_code = FND_API.G_MISS_NUM

2051: l_dummy VARCHAR2(10);
2052: BEGIN
2053:
2054: IF p_reference_type_code IS NULL OR
2055: p_reference_type_code = FND_API.G_MISS_NUM
2056: THEN
2057: RETURN T;
2058: END IF;
2059:

Line 2093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2089: , 'Reference_Type'
2090: );
2091: END IF;
2092:
2093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2094:
2095: END Reference_Type;
2096:
2097:

Line 2106: p_revision = FND_API.G_MISS_CHAR

2102: IS
2103: l_dummy VARCHAR2(10);
2104: BEGIN
2105: IF p_revision IS NULL OR
2106: p_revision = FND_API.G_MISS_CHAR
2107: THEN
2108: RETURN T;
2109: END IF;
2110:

Line 2150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2146: , 'Revision'
2147: );
2148: END IF;
2149:
2150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2151:
2152: END Revision;
2153:
2154:

Line 2172: p_serial.serial_number = FND_API.G_MISS_CHAR

2168:
2169: BEGIN
2170:
2171: IF p_serial.serial_number IS NULL OR
2172: p_serial.serial_number = FND_API.G_MISS_CHAR
2173: THEN
2174: RETURN T;
2175: END IF;
2176:

Line 2253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2249: , 'Check_serial_number'
2250: );
2251: END IF;
2252:
2253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2254:
2255: end check_serial;
2256:
2257: -- ---------------------------------------------------------------------

Line 2605: p_sub.secondary_inventory_name = fnd_api.g_miss_char

2601: RETURN NUMBER
2602: IS
2603: BEGIN
2604: IF p_sub.secondary_inventory_name IS NULL OR
2605: p_sub.secondary_inventory_name = fnd_api.g_miss_char
2606: THEN
2607: RETURN F;
2608: END IF;
2609:

Line 2638: RAISE fnd_api.g_exc_unexpected_error;

2634: THEN
2635: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2636: END IF;
2637:
2638: RAISE fnd_api.g_exc_unexpected_error;
2639:
2640: END subinventory;
2641:
2642:

Line 2653: p_sub.secondary_inventory_name = fnd_api.g_miss_char

2649: RETURN NUMBER
2650: IS
2651: BEGIN
2652: IF p_sub.secondary_inventory_name IS NULL OR
2653: p_sub.secondary_inventory_name = fnd_api.g_miss_char
2654: THEN
2655: RETURN F;
2656: END IF;
2657:

Line 2689: RAISE fnd_api.g_exc_unexpected_error;

2685: THEN
2686: fnd_msg_pub.add_exc_msg(g_pkg_name,'Subinventory');
2687: END IF;
2688:
2689: RAISE fnd_api.g_exc_unexpected_error;
2690:
2691: END subinventory;
2692:
2693:

Line 2704: p_task_id = FND_API.G_MISS_NUM

2700: l_dummy VARCHAR2(10);
2701: BEGIN
2702:
2703: IF p_task_id IS NULL OR
2704: p_task_id = FND_API.G_MISS_NUM
2705: THEN
2706: RETURN T;
2707: END IF;
2708:

Line 2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2737: , 'Task'
2738: );
2739: END IF;
2740:
2741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2742:
2743: END Task;
2744:
2745:

Line 2786: p_hr_location = FND_API.G_MISS_NUM

2782: l_dummy VARCHAR2(20);
2783: BEGIN
2784:
2785: IF p_hr_location IS NULL OR
2786: p_hr_location = FND_API.G_MISS_NUM
2787: then
2788: return T;
2789: END IF;
2790:

Line 2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2832: , 'Task'
2833: );
2834: END IF;
2835:
2836: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2837: END;
2838:
2839:
2840: -- ---------------------------------------------------------------------

Line 2849: p_uom_code = FND_API.G_MISS_CHAR

2845: l_dummy VARCHAR2(10);
2846: BEGIN
2847:
2848: IF p_uom_code IS NULL OR
2849: p_uom_code = FND_API.G_MISS_CHAR
2850: THEN
2851: RETURN F;
2852: END IF;
2853:

Line 2896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2892: );
2893: END IF;
2894:
2895: RETURN F; --Bug2902031
2896: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2897:
2898: END Uom;
2899:
2900: -- END GEN validate

Line 2961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2957: WHEN OTHERS THEN
2958: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2959: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cost Group');
2960: END IF;
2961: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2962: return F;
2963: END;
2964:
2965: FUNCTION LPN( p_lpn_id IN NUMBER) return NUMBER

Line 2988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2984: WHEN OTHERS THEN
2985: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2986: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'LPN');
2987: END IF;
2988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2989: return F;
2990: END;
2991:
2992:

Line 3008: p_lot.lot_number = FND_API.G_MISS_CHAR

3004: l_dummy VARCHAR2(10);
3005:
3006: BEGIN
3007: IF p_lot.lot_number IS NULL OR
3008: p_lot.lot_number = FND_API.G_MISS_CHAR
3009: THEN
3010: RETURN T;
3011: END IF;
3012:

Line 3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3049: , 'Lot_Number'
3050: );
3051: END IF;
3052:
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054:
3055: END Lot_Number;
3056: -- ---------------------------------------------------------------------
3057: --INVCONV

Line 3064: p_secondary_quantity = FND_API.G_MISS_NUM

3060: RETURN NUMBER
3061: IS
3062: BEGIN
3063: IF p_secondary_quantity IS NULL OR
3064: p_secondary_quantity = FND_API.G_MISS_NUM
3065: THEN
3066: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
3067: THEN
3068: FND_MESSAGE.SET_NAME('INV','INV_INT_QTYCODE');