DBA Data[Home] [Help]

APPS.GMI_MOVE_ORDER_HEADER_UTIL dependencies on FND_API

Line 55: IF l_mo_hdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN

51: IS
52: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC := p_mo_hdr_rec;
53: BEGIN
54:
55: IF l_mo_hdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN
56: l_mo_hdr_rec.attribute1 := p_old_mo_hdr_rec.attribute1;
57: END IF;
58:
59: IF l_mo_hdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 59: IF l_mo_hdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN

55: IF l_mo_hdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN
56: l_mo_hdr_rec.attribute1 := p_old_mo_hdr_rec.attribute1;
57: END IF;
58:
59: IF l_mo_hdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN
60: l_mo_hdr_rec.attribute10 := p_old_mo_hdr_rec.attribute10;
61: END IF;
62:
63: IF l_mo_hdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 63: IF l_mo_hdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN

59: IF l_mo_hdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN
60: l_mo_hdr_rec.attribute10 := p_old_mo_hdr_rec.attribute10;
61: END IF;
62:
63: IF l_mo_hdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN
64: l_mo_hdr_rec.attribute11 := p_old_mo_hdr_rec.attribute11;
65: END IF;
66:
67: IF l_mo_hdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 67: IF l_mo_hdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN

63: IF l_mo_hdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN
64: l_mo_hdr_rec.attribute11 := p_old_mo_hdr_rec.attribute11;
65: END IF;
66:
67: IF l_mo_hdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN
68: l_mo_hdr_rec.attribute12 := p_old_mo_hdr_rec.attribute12;
69: END IF;
70:
71: IF l_mo_hdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 71: IF l_mo_hdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN

67: IF l_mo_hdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN
68: l_mo_hdr_rec.attribute12 := p_old_mo_hdr_rec.attribute12;
69: END IF;
70:
71: IF l_mo_hdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN
72: l_mo_hdr_rec.attribute13 := p_old_mo_hdr_rec.attribute13;
73: END IF;
74:
75: IF l_mo_hdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 75: IF l_mo_hdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN

71: IF l_mo_hdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN
72: l_mo_hdr_rec.attribute13 := p_old_mo_hdr_rec.attribute13;
73: END IF;
74:
75: IF l_mo_hdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN
76: l_mo_hdr_rec.attribute14 := p_old_mo_hdr_rec.attribute14;
77: END IF;
78:
79: IF l_mo_hdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 79: IF l_mo_hdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN

75: IF l_mo_hdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN
76: l_mo_hdr_rec.attribute14 := p_old_mo_hdr_rec.attribute14;
77: END IF;
78:
79: IF l_mo_hdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN
80: l_mo_hdr_rec.attribute15 := p_old_mo_hdr_rec.attribute15;
81: END IF;
82:
83: IF l_mo_hdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 83: IF l_mo_hdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN

79: IF l_mo_hdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN
80: l_mo_hdr_rec.attribute15 := p_old_mo_hdr_rec.attribute15;
81: END IF;
82:
83: IF l_mo_hdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN
84: l_mo_hdr_rec.attribute2 := p_old_mo_hdr_rec.attribute2;
85: END IF;
86:
87: IF l_mo_hdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 87: IF l_mo_hdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN

83: IF l_mo_hdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN
84: l_mo_hdr_rec.attribute2 := p_old_mo_hdr_rec.attribute2;
85: END IF;
86:
87: IF l_mo_hdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN
88: l_mo_hdr_rec.attribute3 := p_old_mo_hdr_rec.attribute3;
89: END IF;
90:
91: IF l_mo_hdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 91: IF l_mo_hdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN

87: IF l_mo_hdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN
88: l_mo_hdr_rec.attribute3 := p_old_mo_hdr_rec.attribute3;
89: END IF;
90:
91: IF l_mo_hdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN
92: l_mo_hdr_rec.attribute4 := p_old_mo_hdr_rec.attribute4;
93: END IF;
94:
95: IF l_mo_hdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 95: IF l_mo_hdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN

91: IF l_mo_hdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN
92: l_mo_hdr_rec.attribute4 := p_old_mo_hdr_rec.attribute4;
93: END IF;
94:
95: IF l_mo_hdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN
96: l_mo_hdr_rec.attribute5 := p_old_mo_hdr_rec.attribute5;
97: END IF;
98:
99: IF l_mo_hdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 99: IF l_mo_hdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN

95: IF l_mo_hdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN
96: l_mo_hdr_rec.attribute5 := p_old_mo_hdr_rec.attribute5;
97: END IF;
98:
99: IF l_mo_hdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN
100: l_mo_hdr_rec.attribute6 := p_old_mo_hdr_rec.attribute6;
101: END IF;
102:
103: IF l_mo_hdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 103: IF l_mo_hdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN

99: IF l_mo_hdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN
100: l_mo_hdr_rec.attribute6 := p_old_mo_hdr_rec.attribute6;
101: END IF;
102:
103: IF l_mo_hdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN
104: l_mo_hdr_rec.attribute7 := p_old_mo_hdr_rec.attribute7;
105: END IF;
106:
107: IF l_mo_hdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 107: IF l_mo_hdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN

103: IF l_mo_hdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN
104: l_mo_hdr_rec.attribute7 := p_old_mo_hdr_rec.attribute7;
105: END IF;
106:
107: IF l_mo_hdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN
108: l_mo_hdr_rec.attribute8 := p_old_mo_hdr_rec.attribute8;
109: END IF;
110:
111: IF l_mo_hdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 111: IF l_mo_hdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN

107: IF l_mo_hdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN
108: l_mo_hdr_rec.attribute8 := p_old_mo_hdr_rec.attribute8;
109: END IF;
110:
111: IF l_mo_hdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN
112: l_mo_hdr_rec.attribute9 := p_old_mo_hdr_rec.attribute9;
113: END IF;
114:
115: IF l_mo_hdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 115: IF l_mo_hdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN

111: IF l_mo_hdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN
112: l_mo_hdr_rec.attribute9 := p_old_mo_hdr_rec.attribute9;
113: END IF;
114:
115: IF l_mo_hdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN
116: l_mo_hdr_rec.attribute_category := p_old_mo_hdr_rec.attribute_category;
117: END IF;
118:
119: IF l_mo_hdr_rec.created_by = FND_API.G_MISS_NUM THEN

Line 119: IF l_mo_hdr_rec.created_by = FND_API.G_MISS_NUM THEN

115: IF l_mo_hdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN
116: l_mo_hdr_rec.attribute_category := p_old_mo_hdr_rec.attribute_category;
117: END IF;
118:
119: IF l_mo_hdr_rec.created_by = FND_API.G_MISS_NUM THEN
120: l_mo_hdr_rec.created_by := p_old_mo_hdr_rec.created_by;
121: END IF;
122:
123: IF l_mo_hdr_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 123: IF l_mo_hdr_rec.creation_date = FND_API.G_MISS_DATE THEN

119: IF l_mo_hdr_rec.created_by = FND_API.G_MISS_NUM THEN
120: l_mo_hdr_rec.created_by := p_old_mo_hdr_rec.created_by;
121: END IF;
122:
123: IF l_mo_hdr_rec.creation_date = FND_API.G_MISS_DATE THEN
124: l_mo_hdr_rec.creation_date := p_old_mo_hdr_rec.creation_date;
125: END IF;
126:
127: IF l_mo_hdr_rec.date_required = FND_API.G_MISS_DATE THEN

Line 127: IF l_mo_hdr_rec.date_required = FND_API.G_MISS_DATE THEN

123: IF l_mo_hdr_rec.creation_date = FND_API.G_MISS_DATE THEN
124: l_mo_hdr_rec.creation_date := p_old_mo_hdr_rec.creation_date;
125: END IF;
126:
127: IF l_mo_hdr_rec.date_required = FND_API.G_MISS_DATE THEN
128: l_mo_hdr_rec.date_required := p_old_mo_hdr_rec.date_required;
129: END IF;
130:
131: IF l_mo_hdr_rec.description = FND_API.G_MISS_CHAR THEN

Line 131: IF l_mo_hdr_rec.description = FND_API.G_MISS_CHAR THEN

127: IF l_mo_hdr_rec.date_required = FND_API.G_MISS_DATE THEN
128: l_mo_hdr_rec.date_required := p_old_mo_hdr_rec.date_required;
129: END IF;
130:
131: IF l_mo_hdr_rec.description = FND_API.G_MISS_CHAR THEN
132: l_mo_hdr_rec.description := p_old_mo_hdr_rec.description;
133: END IF;
134:
135: IF l_mo_hdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN

Line 135: IF l_mo_hdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN

131: IF l_mo_hdr_rec.description = FND_API.G_MISS_CHAR THEN
132: l_mo_hdr_rec.description := p_old_mo_hdr_rec.description;
133: END IF;
134:
135: IF l_mo_hdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN
136: l_mo_hdr_rec.from_subinventory_code := p_old_mo_hdr_rec.from_subinventory_code;
137: END IF;
138:
139: IF l_mo_hdr_rec.header_id = FND_API.G_MISS_NUM THEN

Line 139: IF l_mo_hdr_rec.header_id = FND_API.G_MISS_NUM THEN

135: IF l_mo_hdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN
136: l_mo_hdr_rec.from_subinventory_code := p_old_mo_hdr_rec.from_subinventory_code;
137: END IF;
138:
139: IF l_mo_hdr_rec.header_id = FND_API.G_MISS_NUM THEN
140: l_mo_hdr_rec.header_id := p_old_mo_hdr_rec.header_id;
141: END IF;
142:
143: IF l_mo_hdr_rec.header_status = FND_API.G_MISS_NUM THEN

Line 143: IF l_mo_hdr_rec.header_status = FND_API.G_MISS_NUM THEN

139: IF l_mo_hdr_rec.header_id = FND_API.G_MISS_NUM THEN
140: l_mo_hdr_rec.header_id := p_old_mo_hdr_rec.header_id;
141: END IF;
142:
143: IF l_mo_hdr_rec.header_status = FND_API.G_MISS_NUM THEN
144: l_mo_hdr_rec.header_status := p_old_mo_hdr_rec.header_status;
145: END IF;
146:
147: IF l_mo_hdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 147: IF l_mo_hdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN

143: IF l_mo_hdr_rec.header_status = FND_API.G_MISS_NUM THEN
144: l_mo_hdr_rec.header_status := p_old_mo_hdr_rec.header_status;
145: END IF;
146:
147: IF l_mo_hdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN
148: l_mo_hdr_rec.last_updated_by := p_old_mo_hdr_rec.last_updated_by;
149: END IF;
150:
151: IF l_mo_hdr_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 151: IF l_mo_hdr_rec.last_update_date = FND_API.G_MISS_DATE THEN

147: IF l_mo_hdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN
148: l_mo_hdr_rec.last_updated_by := p_old_mo_hdr_rec.last_updated_by;
149: END IF;
150:
151: IF l_mo_hdr_rec.last_update_date = FND_API.G_MISS_DATE THEN
152: l_mo_hdr_rec.last_update_date := p_old_mo_hdr_rec.last_update_date;
153: END IF;
154:
155: IF l_mo_hdr_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 155: IF l_mo_hdr_rec.last_update_login = FND_API.G_MISS_NUM THEN

151: IF l_mo_hdr_rec.last_update_date = FND_API.G_MISS_DATE THEN
152: l_mo_hdr_rec.last_update_date := p_old_mo_hdr_rec.last_update_date;
153: END IF;
154:
155: IF l_mo_hdr_rec.last_update_login = FND_API.G_MISS_NUM THEN
156: l_mo_hdr_rec.last_update_login := p_old_mo_hdr_rec.last_update_login;
157: END IF;
158:
159: IF l_mo_hdr_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 159: IF l_mo_hdr_rec.organization_id = FND_API.G_MISS_NUM THEN

155: IF l_mo_hdr_rec.last_update_login = FND_API.G_MISS_NUM THEN
156: l_mo_hdr_rec.last_update_login := p_old_mo_hdr_rec.last_update_login;
157: END IF;
158:
159: IF l_mo_hdr_rec.organization_id = FND_API.G_MISS_NUM THEN
160: l_mo_hdr_rec.organization_id := p_old_mo_hdr_rec.organization_id;
161: END IF;
162:
163: IF l_mo_hdr_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 163: IF l_mo_hdr_rec.program_application_id = FND_API.G_MISS_NUM THEN

159: IF l_mo_hdr_rec.organization_id = FND_API.G_MISS_NUM THEN
160: l_mo_hdr_rec.organization_id := p_old_mo_hdr_rec.organization_id;
161: END IF;
162:
163: IF l_mo_hdr_rec.program_application_id = FND_API.G_MISS_NUM THEN
164: l_mo_hdr_rec.program_application_id := p_old_mo_hdr_rec.program_application_id;
165: END IF;
166:
167: IF l_mo_hdr_rec.program_id = FND_API.G_MISS_NUM THEN

Line 167: IF l_mo_hdr_rec.program_id = FND_API.G_MISS_NUM THEN

163: IF l_mo_hdr_rec.program_application_id = FND_API.G_MISS_NUM THEN
164: l_mo_hdr_rec.program_application_id := p_old_mo_hdr_rec.program_application_id;
165: END IF;
166:
167: IF l_mo_hdr_rec.program_id = FND_API.G_MISS_NUM THEN
168: l_mo_hdr_rec.program_id := p_old_mo_hdr_rec.program_id;
169: END IF;
170:
171: IF l_mo_hdr_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 171: IF l_mo_hdr_rec.program_update_date = FND_API.G_MISS_DATE THEN

167: IF l_mo_hdr_rec.program_id = FND_API.G_MISS_NUM THEN
168: l_mo_hdr_rec.program_id := p_old_mo_hdr_rec.program_id;
169: END IF;
170:
171: IF l_mo_hdr_rec.program_update_date = FND_API.G_MISS_DATE THEN
172: l_mo_hdr_rec.program_update_date := p_old_mo_hdr_rec.program_update_date;
173: END IF;
174:
175: IF l_mo_hdr_rec.request_id = FND_API.G_MISS_NUM THEN

Line 175: IF l_mo_hdr_rec.request_id = FND_API.G_MISS_NUM THEN

171: IF l_mo_hdr_rec.program_update_date = FND_API.G_MISS_DATE THEN
172: l_mo_hdr_rec.program_update_date := p_old_mo_hdr_rec.program_update_date;
173: END IF;
174:
175: IF l_mo_hdr_rec.request_id = FND_API.G_MISS_NUM THEN
176: l_mo_hdr_rec.request_id := p_old_mo_hdr_rec.request_id;
177: END IF;
178:
179: IF l_mo_hdr_rec.request_number = FND_API.G_MISS_CHAR THEN

Line 179: IF l_mo_hdr_rec.request_number = FND_API.G_MISS_CHAR THEN

175: IF l_mo_hdr_rec.request_id = FND_API.G_MISS_NUM THEN
176: l_mo_hdr_rec.request_id := p_old_mo_hdr_rec.request_id;
177: END IF;
178:
179: IF l_mo_hdr_rec.request_number = FND_API.G_MISS_CHAR THEN
180: l_mo_hdr_rec.request_number := p_old_mo_hdr_rec.request_number;
181: END IF;
182:
183: IF l_mo_hdr_rec.status_date = FND_API.G_MISS_DATE THEN

Line 183: IF l_mo_hdr_rec.status_date = FND_API.G_MISS_DATE THEN

179: IF l_mo_hdr_rec.request_number = FND_API.G_MISS_CHAR THEN
180: l_mo_hdr_rec.request_number := p_old_mo_hdr_rec.request_number;
181: END IF;
182:
183: IF l_mo_hdr_rec.status_date = FND_API.G_MISS_DATE THEN
184: l_mo_hdr_rec.status_date := p_old_mo_hdr_rec.status_date;
185: END IF;
186:
187: IF l_mo_hdr_rec.to_account_id = FND_API.G_MISS_NUM THEN

Line 187: IF l_mo_hdr_rec.to_account_id = FND_API.G_MISS_NUM THEN

183: IF l_mo_hdr_rec.status_date = FND_API.G_MISS_DATE THEN
184: l_mo_hdr_rec.status_date := p_old_mo_hdr_rec.status_date;
185: END IF;
186:
187: IF l_mo_hdr_rec.to_account_id = FND_API.G_MISS_NUM THEN
188: l_mo_hdr_rec.to_account_id := p_old_mo_hdr_rec.to_account_id;
189: END IF;
190:
191: IF l_mo_hdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN

Line 191: IF l_mo_hdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN

187: IF l_mo_hdr_rec.to_account_id = FND_API.G_MISS_NUM THEN
188: l_mo_hdr_rec.to_account_id := p_old_mo_hdr_rec.to_account_id;
189: END IF;
190:
191: IF l_mo_hdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
192: l_mo_hdr_rec.to_subinventory_code := p_old_mo_hdr_rec.to_subinventory_code;
193: END IF;
194:
195: IF l_mo_hdr_rec.move_order_type = FND_API.G_MISS_NUM THEN

Line 195: IF l_mo_hdr_rec.move_order_type = FND_API.G_MISS_NUM THEN

191: IF l_mo_hdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
192: l_mo_hdr_rec.to_subinventory_code := p_old_mo_hdr_rec.to_subinventory_code;
193: END IF;
194:
195: IF l_mo_hdr_rec.move_order_type = FND_API.G_MISS_NUM THEN
196: l_mo_hdr_rec.move_order_type := p_old_mo_hdr_rec.move_order_type;
197: END IF;
198:
199: IF l_mo_hdr_rec.transaction_type_id = FND_API.G_MISS_NUM THEN

Line 199: IF l_mo_hdr_rec.transaction_type_id = FND_API.G_MISS_NUM THEN

195: IF l_mo_hdr_rec.move_order_type = FND_API.G_MISS_NUM THEN
196: l_mo_hdr_rec.move_order_type := p_old_mo_hdr_rec.move_order_type;
197: END IF;
198:
199: IF l_mo_hdr_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
200: l_mo_hdr_rec.transaction_type_id := p_old_mo_hdr_rec.transaction_type_id;
201: END IF;
202:
203: IF l_mo_hdr_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN

Line 203: IF l_mo_hdr_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN

199: IF l_mo_hdr_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
200: l_mo_hdr_rec.transaction_type_id := p_old_mo_hdr_rec.transaction_type_id;
201: END IF;
202:
203: IF l_mo_hdr_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN
204: l_mo_hdr_rec.ship_to_location_id := p_old_mo_hdr_rec.ship_to_location_id;
205: END IF;
206:
207: RETURN l_mo_hdr_rec;

Line 220: IF l_mo_hdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN

216: IS
217: l_mo_hdr_rec GMI_MOVE_ORDER_GLOBAL.MO_HDR_REC := p_mo_hdr_rec;
218: BEGIN
219:
220: IF l_mo_hdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN
221: l_mo_hdr_rec.attribute1 := NULL;
222: END IF;
223:
224: IF l_mo_hdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 224: IF l_mo_hdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN

220: IF l_mo_hdr_rec.attribute1 = FND_API.G_MISS_CHAR THEN
221: l_mo_hdr_rec.attribute1 := NULL;
222: END IF;
223:
224: IF l_mo_hdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN
225: l_mo_hdr_rec.attribute10 := NULL;
226: END IF;
227:
228: IF l_mo_hdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 228: IF l_mo_hdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN

224: IF l_mo_hdr_rec.attribute10 = FND_API.G_MISS_CHAR THEN
225: l_mo_hdr_rec.attribute10 := NULL;
226: END IF;
227:
228: IF l_mo_hdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN
229: l_mo_hdr_rec.attribute11 := NULL;
230: END IF;
231:
232: IF l_mo_hdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 232: IF l_mo_hdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN

228: IF l_mo_hdr_rec.attribute11 = FND_API.G_MISS_CHAR THEN
229: l_mo_hdr_rec.attribute11 := NULL;
230: END IF;
231:
232: IF l_mo_hdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN
233: l_mo_hdr_rec.attribute12 := NULL;
234: END IF;
235:
236: IF l_mo_hdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 236: IF l_mo_hdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN

232: IF l_mo_hdr_rec.attribute12 = FND_API.G_MISS_CHAR THEN
233: l_mo_hdr_rec.attribute12 := NULL;
234: END IF;
235:
236: IF l_mo_hdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN
237: l_mo_hdr_rec.attribute13 := NULL;
238: END IF;
239:
240: IF l_mo_hdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 240: IF l_mo_hdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN

236: IF l_mo_hdr_rec.attribute13 = FND_API.G_MISS_CHAR THEN
237: l_mo_hdr_rec.attribute13 := NULL;
238: END IF;
239:
240: IF l_mo_hdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN
241: l_mo_hdr_rec.attribute14 := NULL;
242: END IF;
243:
244: IF l_mo_hdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 244: IF l_mo_hdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN

240: IF l_mo_hdr_rec.attribute14 = FND_API.G_MISS_CHAR THEN
241: l_mo_hdr_rec.attribute14 := NULL;
242: END IF;
243:
244: IF l_mo_hdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN
245: l_mo_hdr_rec.attribute15 := NULL;
246: END IF;
247:
248: IF l_mo_hdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 248: IF l_mo_hdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN

244: IF l_mo_hdr_rec.attribute15 = FND_API.G_MISS_CHAR THEN
245: l_mo_hdr_rec.attribute15 := NULL;
246: END IF;
247:
248: IF l_mo_hdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN
249: l_mo_hdr_rec.attribute2 := NULL;
250: END IF;
251:
252: IF l_mo_hdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 252: IF l_mo_hdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN

248: IF l_mo_hdr_rec.attribute2 = FND_API.G_MISS_CHAR THEN
249: l_mo_hdr_rec.attribute2 := NULL;
250: END IF;
251:
252: IF l_mo_hdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN
253: l_mo_hdr_rec.attribute3 := NULL;
254: END IF;
255:
256: IF l_mo_hdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 256: IF l_mo_hdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN

252: IF l_mo_hdr_rec.attribute3 = FND_API.G_MISS_CHAR THEN
253: l_mo_hdr_rec.attribute3 := NULL;
254: END IF;
255:
256: IF l_mo_hdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN
257: l_mo_hdr_rec.attribute4 := NULL;
258: END IF;
259:
260: IF l_mo_hdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 260: IF l_mo_hdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN

256: IF l_mo_hdr_rec.attribute4 = FND_API.G_MISS_CHAR THEN
257: l_mo_hdr_rec.attribute4 := NULL;
258: END IF;
259:
260: IF l_mo_hdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN
261: l_mo_hdr_rec.attribute5 := NULL;
262: END IF;
263:
264: IF l_mo_hdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 264: IF l_mo_hdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN

260: IF l_mo_hdr_rec.attribute5 = FND_API.G_MISS_CHAR THEN
261: l_mo_hdr_rec.attribute5 := NULL;
262: END IF;
263:
264: IF l_mo_hdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN
265: l_mo_hdr_rec.attribute6 := NULL;
266: END IF;
267:
268: IF l_mo_hdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 268: IF l_mo_hdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN

264: IF l_mo_hdr_rec.attribute6 = FND_API.G_MISS_CHAR THEN
265: l_mo_hdr_rec.attribute6 := NULL;
266: END IF;
267:
268: IF l_mo_hdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN
269: l_mo_hdr_rec.attribute7 := NULL;
270: END IF;
271:
272: IF l_mo_hdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 272: IF l_mo_hdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN

268: IF l_mo_hdr_rec.attribute7 = FND_API.G_MISS_CHAR THEN
269: l_mo_hdr_rec.attribute7 := NULL;
270: END IF;
271:
272: IF l_mo_hdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN
273: l_mo_hdr_rec.attribute8 := NULL;
274: END IF;
275:
276: IF l_mo_hdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 276: IF l_mo_hdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN

272: IF l_mo_hdr_rec.attribute8 = FND_API.G_MISS_CHAR THEN
273: l_mo_hdr_rec.attribute8 := NULL;
274: END IF;
275:
276: IF l_mo_hdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN
277: l_mo_hdr_rec.attribute9 := NULL;
278: END IF;
279:
280: IF l_mo_hdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 280: IF l_mo_hdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN

276: IF l_mo_hdr_rec.attribute9 = FND_API.G_MISS_CHAR THEN
277: l_mo_hdr_rec.attribute9 := NULL;
278: END IF;
279:
280: IF l_mo_hdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN
281: l_mo_hdr_rec.attribute_category := NULL;
282: END IF;
283:
284: IF l_mo_hdr_rec.created_by = FND_API.G_MISS_NUM THEN

Line 284: IF l_mo_hdr_rec.created_by = FND_API.G_MISS_NUM THEN

280: IF l_mo_hdr_rec.attribute_category = FND_API.G_MISS_CHAR THEN
281: l_mo_hdr_rec.attribute_category := NULL;
282: END IF;
283:
284: IF l_mo_hdr_rec.created_by = FND_API.G_MISS_NUM THEN
285: l_mo_hdr_rec.created_by := NULL;
286: END IF;
287:
288: IF l_mo_hdr_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 288: IF l_mo_hdr_rec.creation_date = FND_API.G_MISS_DATE THEN

284: IF l_mo_hdr_rec.created_by = FND_API.G_MISS_NUM THEN
285: l_mo_hdr_rec.created_by := NULL;
286: END IF;
287:
288: IF l_mo_hdr_rec.creation_date = FND_API.G_MISS_DATE THEN
289: l_mo_hdr_rec.creation_date := NULL;
290: END IF;
291:
292: IF l_mo_hdr_rec.date_required = FND_API.G_MISS_DATE THEN

Line 292: IF l_mo_hdr_rec.date_required = FND_API.G_MISS_DATE THEN

288: IF l_mo_hdr_rec.creation_date = FND_API.G_MISS_DATE THEN
289: l_mo_hdr_rec.creation_date := NULL;
290: END IF;
291:
292: IF l_mo_hdr_rec.date_required = FND_API.G_MISS_DATE THEN
293: l_mo_hdr_rec.date_required := NULL;
294: END IF;
295:
296: IF l_mo_hdr_rec.description = FND_API.G_MISS_CHAR THEN

Line 296: IF l_mo_hdr_rec.description = FND_API.G_MISS_CHAR THEN

292: IF l_mo_hdr_rec.date_required = FND_API.G_MISS_DATE THEN
293: l_mo_hdr_rec.date_required := NULL;
294: END IF;
295:
296: IF l_mo_hdr_rec.description = FND_API.G_MISS_CHAR THEN
297: l_mo_hdr_rec.description := NULL;
298: END IF;
299:
300: IF l_mo_hdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN

Line 300: IF l_mo_hdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN

296: IF l_mo_hdr_rec.description = FND_API.G_MISS_CHAR THEN
297: l_mo_hdr_rec.description := NULL;
298: END IF;
299:
300: IF l_mo_hdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN
301: l_mo_hdr_rec.from_subinventory_code := NULL;
302: END IF;
303:
304: IF l_mo_hdr_rec.header_id = FND_API.G_MISS_NUM THEN

Line 304: IF l_mo_hdr_rec.header_id = FND_API.G_MISS_NUM THEN

300: IF l_mo_hdr_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN
301: l_mo_hdr_rec.from_subinventory_code := NULL;
302: END IF;
303:
304: IF l_mo_hdr_rec.header_id = FND_API.G_MISS_NUM THEN
305: l_mo_hdr_rec.header_id := NULL;
306: END IF;
307:
308: IF l_mo_hdr_rec.header_status = FND_API.G_MISS_NUM THEN

Line 308: IF l_mo_hdr_rec.header_status = FND_API.G_MISS_NUM THEN

304: IF l_mo_hdr_rec.header_id = FND_API.G_MISS_NUM THEN
305: l_mo_hdr_rec.header_id := NULL;
306: END IF;
307:
308: IF l_mo_hdr_rec.header_status = FND_API.G_MISS_NUM THEN
309: l_mo_hdr_rec.header_status := NULL;
310: END IF;
311:
312: IF l_mo_hdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 312: IF l_mo_hdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN

308: IF l_mo_hdr_rec.header_status = FND_API.G_MISS_NUM THEN
309: l_mo_hdr_rec.header_status := NULL;
310: END IF;
311:
312: IF l_mo_hdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN
313: l_mo_hdr_rec.last_updated_by := NULL;
314: END IF;
315:
316: IF l_mo_hdr_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 316: IF l_mo_hdr_rec.last_update_date = FND_API.G_MISS_DATE THEN

312: IF l_mo_hdr_rec.last_updated_by = FND_API.G_MISS_NUM THEN
313: l_mo_hdr_rec.last_updated_by := NULL;
314: END IF;
315:
316: IF l_mo_hdr_rec.last_update_date = FND_API.G_MISS_DATE THEN
317: l_mo_hdr_rec.last_update_date := NULL;
318: END IF;
319:
320: IF l_mo_hdr_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 320: IF l_mo_hdr_rec.last_update_login = FND_API.G_MISS_NUM THEN

316: IF l_mo_hdr_rec.last_update_date = FND_API.G_MISS_DATE THEN
317: l_mo_hdr_rec.last_update_date := NULL;
318: END IF;
319:
320: IF l_mo_hdr_rec.last_update_login = FND_API.G_MISS_NUM THEN
321: l_mo_hdr_rec.last_update_login := NULL;
322: END IF;
323:
324: IF l_mo_hdr_rec.organization_id = FND_API.G_MISS_NUM THEN

Line 324: IF l_mo_hdr_rec.organization_id = FND_API.G_MISS_NUM THEN

320: IF l_mo_hdr_rec.last_update_login = FND_API.G_MISS_NUM THEN
321: l_mo_hdr_rec.last_update_login := NULL;
322: END IF;
323:
324: IF l_mo_hdr_rec.organization_id = FND_API.G_MISS_NUM THEN
325: l_mo_hdr_rec.organization_id := NULL;
326: END IF;
327:
328: IF l_mo_hdr_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 328: IF l_mo_hdr_rec.program_application_id = FND_API.G_MISS_NUM THEN

324: IF l_mo_hdr_rec.organization_id = FND_API.G_MISS_NUM THEN
325: l_mo_hdr_rec.organization_id := NULL;
326: END IF;
327:
328: IF l_mo_hdr_rec.program_application_id = FND_API.G_MISS_NUM THEN
329: l_mo_hdr_rec.program_application_id := NULL;
330: END IF;
331:
332: IF l_mo_hdr_rec.program_id = FND_API.G_MISS_NUM THEN

Line 332: IF l_mo_hdr_rec.program_id = FND_API.G_MISS_NUM THEN

328: IF l_mo_hdr_rec.program_application_id = FND_API.G_MISS_NUM THEN
329: l_mo_hdr_rec.program_application_id := NULL;
330: END IF;
331:
332: IF l_mo_hdr_rec.program_id = FND_API.G_MISS_NUM THEN
333: l_mo_hdr_rec.program_id := NULL;
334: END IF;
335:
336: IF l_mo_hdr_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 336: IF l_mo_hdr_rec.program_update_date = FND_API.G_MISS_DATE THEN

332: IF l_mo_hdr_rec.program_id = FND_API.G_MISS_NUM THEN
333: l_mo_hdr_rec.program_id := NULL;
334: END IF;
335:
336: IF l_mo_hdr_rec.program_update_date = FND_API.G_MISS_DATE THEN
337: l_mo_hdr_rec.program_update_date := NULL;
338: END IF;
339:
340: IF l_mo_hdr_rec.request_id = FND_API.G_MISS_NUM THEN

Line 340: IF l_mo_hdr_rec.request_id = FND_API.G_MISS_NUM THEN

336: IF l_mo_hdr_rec.program_update_date = FND_API.G_MISS_DATE THEN
337: l_mo_hdr_rec.program_update_date := NULL;
338: END IF;
339:
340: IF l_mo_hdr_rec.request_id = FND_API.G_MISS_NUM THEN
341: l_mo_hdr_rec.request_id := NULL;
342: END IF;
343:
344: IF l_mo_hdr_rec.request_number = FND_API.G_MISS_CHAR THEN

Line 344: IF l_mo_hdr_rec.request_number = FND_API.G_MISS_CHAR THEN

340: IF l_mo_hdr_rec.request_id = FND_API.G_MISS_NUM THEN
341: l_mo_hdr_rec.request_id := NULL;
342: END IF;
343:
344: IF l_mo_hdr_rec.request_number = FND_API.G_MISS_CHAR THEN
345: l_mo_hdr_rec.request_number := NULL;
346: END IF;
347:
348: IF l_mo_hdr_rec.status_date = FND_API.G_MISS_DATE THEN

Line 348: IF l_mo_hdr_rec.status_date = FND_API.G_MISS_DATE THEN

344: IF l_mo_hdr_rec.request_number = FND_API.G_MISS_CHAR THEN
345: l_mo_hdr_rec.request_number := NULL;
346: END IF;
347:
348: IF l_mo_hdr_rec.status_date = FND_API.G_MISS_DATE THEN
349: l_mo_hdr_rec.status_date := NULL;
350: END IF;
351:
352: IF l_mo_hdr_rec.to_account_id = FND_API.G_MISS_NUM THEN

Line 352: IF l_mo_hdr_rec.to_account_id = FND_API.G_MISS_NUM THEN

348: IF l_mo_hdr_rec.status_date = FND_API.G_MISS_DATE THEN
349: l_mo_hdr_rec.status_date := NULL;
350: END IF;
351:
352: IF l_mo_hdr_rec.to_account_id = FND_API.G_MISS_NUM THEN
353: l_mo_hdr_rec.to_account_id := NULL;
354: END IF;
355:
356: IF l_mo_hdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN

Line 356: IF l_mo_hdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN

352: IF l_mo_hdr_rec.to_account_id = FND_API.G_MISS_NUM THEN
353: l_mo_hdr_rec.to_account_id := NULL;
354: END IF;
355:
356: IF l_mo_hdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
357: l_mo_hdr_rec.to_subinventory_code := NULL;
358: END IF;
359:
360: IF l_mo_hdr_rec.move_order_type = FND_API.G_MISS_NUM THEN

Line 360: IF l_mo_hdr_rec.move_order_type = FND_API.G_MISS_NUM THEN

356: IF l_mo_hdr_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
357: l_mo_hdr_rec.to_subinventory_code := NULL;
358: END IF;
359:
360: IF l_mo_hdr_rec.move_order_type = FND_API.G_MISS_NUM THEN
361: l_mo_hdr_rec.move_order_type := NULL;
362: END IF;
363:
364: IF l_mo_hdr_rec.transaction_type_id = FND_API.G_MISS_NUM THEN

Line 364: IF l_mo_hdr_rec.transaction_type_id = FND_API.G_MISS_NUM THEN

360: IF l_mo_hdr_rec.move_order_type = FND_API.G_MISS_NUM THEN
361: l_mo_hdr_rec.move_order_type := NULL;
362: END IF;
363:
364: IF l_mo_hdr_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
365: l_mo_hdr_rec.transaction_type_id := NULL;
366: END IF;
367:
368: IF l_mo_hdr_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN

Line 368: IF l_mo_hdr_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN

364: IF l_mo_hdr_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
365: l_mo_hdr_rec.transaction_type_id := NULL;
366: END IF;
367:
368: IF l_mo_hdr_rec.ship_to_location_id = FND_API.G_MISS_NUM THEN
369: l_mo_hdr_rec.ship_to_location_id := NULL;
370: END IF;
371:
372: RETURN l_mo_hdr_rec;

Line 438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

434: , 'Update_Row'
435: );
436: END IF;
437:
438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
439:
440: END Update_Row;
441:
442:

Line 556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

552: , 'Insert_Row'
553: );
554: END IF;
555:
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557:
558: END Insert_Row;
559:
560: /* Procedure Delete_Row */

Line 584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

580: , 'Delete_Row'
581: );
582: END IF;
583:
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585:
586: END Delete_Row;
587:
588:

Line 620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

616: , 'Update_Row_Status'
617: );
618: END IF;
619:
620: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
621:
622: END Update_Row_Status;
623:
624: /* Function Query_Row */

Line 728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

724: , 'Query_Row'
725: );
726: END IF;
727:
728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
729:
730: END Query_Row;
731:
732: /* Procedure lock_Row */

Line 913: x_return_status := FND_API.G_RET_STS_SUCCESS;

909: x_mo_hdr_rec := l_mo_hdr_rec;
910:
911: /* Set return status */
912:
913: x_return_status := FND_API.G_RET_STS_SUCCESS;
914: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_SUCCESS;
915:
916: ELSE
917:

Line 914: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_SUCCESS;

910:
911: /* Set return status */
912:
913: x_return_status := FND_API.G_RET_STS_SUCCESS;
914: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_SUCCESS;
915:
916: ELSE
917:
918: /* Row has changed by another user. */

Line 920: x_return_status := FND_API.G_RET_STS_ERROR;

916: ELSE
917:
918: /* Row has changed by another user. */
919:
920: x_return_status := FND_API.G_RET_STS_ERROR;
921: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;
922:
923: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
924: THEN

Line 921: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;

917:
918: /* Row has changed by another user. */
919:
920: x_return_status := FND_API.G_RET_STS_ERROR;
921: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;
922:
923: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
924: THEN
925:

Line 937: x_return_status := FND_API.G_RET_STS_ERROR;

933: EXCEPTION
934:
935: WHEN NO_DATA_FOUND THEN
936:
937: x_return_status := FND_API.G_RET_STS_ERROR;
938: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;
939:
940: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
941: THEN

Line 938: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;

934:
935: WHEN NO_DATA_FOUND THEN
936:
937: x_return_status := FND_API.G_RET_STS_ERROR;
938: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;
939:
940: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
941: THEN
942:

Line 949: x_return_status := FND_API.G_RET_STS_ERROR;

945:
946: END IF;
947: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
948:
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;
951:
952: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
953: THEN

Line 950: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;

946: END IF;
947: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
948:
949: x_return_status := FND_API.G_RET_STS_ERROR;
950: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_ERROR;
951:
952: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
953: THEN
954:

Line 961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

957:
958: END IF;
959: WHEN OTHERS THEN
960:
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963:
964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
965: THEN

Line 962: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

958: END IF;
959: WHEN OTHERS THEN
960:
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: x_mo_hdr_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
963:
964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
965: THEN
966: FND_MSG_PUB.Add_Exc_Msg