[Home] [Help]
56: Raise a temporary error, for Dummy calls
57: ======================================================================= */
58: /* FND_MESSAGE.SET_NAME('GMI','GMI_RSV_UNAVAILABLE');
59: OE_MSG_PUB.Add;
60: RAISE FND_API.G_EXC_ERROR;
61: */
62:
63: IF l_mo_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
64: l_mo_line_rec.attribute1 := NULL;
59: OE_MSG_PUB.Add;
60: RAISE FND_API.G_EXC_ERROR;
61: */
62:
63: IF l_mo_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
64: l_mo_line_rec.attribute1 := NULL;
65: END IF;
66:
67: IF l_mo_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
63: IF l_mo_line_rec.attribute1 = FND_API.G_MISS_CHAR THEN
64: l_mo_line_rec.attribute1 := NULL;
65: END IF;
66:
67: IF l_mo_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
68: l_mo_line_rec.attribute10 := NULL;
69: END IF;
70:
71: IF l_mo_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
67: IF l_mo_line_rec.attribute10 = FND_API.G_MISS_CHAR THEN
68: l_mo_line_rec.attribute10 := NULL;
69: END IF;
70:
71: IF l_mo_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
72: l_mo_line_rec.attribute11 := NULL;
73: END IF;
74:
75: IF l_mo_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
71: IF l_mo_line_rec.attribute11 = FND_API.G_MISS_CHAR THEN
72: l_mo_line_rec.attribute11 := NULL;
73: END IF;
74:
75: IF l_mo_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
76: l_mo_line_rec.attribute12 := NULL;
77: END IF;
78:
79: IF l_mo_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
75: IF l_mo_line_rec.attribute12 = FND_API.G_MISS_CHAR THEN
76: l_mo_line_rec.attribute12 := NULL;
77: END IF;
78:
79: IF l_mo_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
80: l_mo_line_rec.attribute13 := NULL;
81: END IF;
82:
83: IF l_mo_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
79: IF l_mo_line_rec.attribute13 = FND_API.G_MISS_CHAR THEN
80: l_mo_line_rec.attribute13 := NULL;
81: END IF;
82:
83: IF l_mo_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
84: l_mo_line_rec.attribute14 := NULL;
85: END IF;
86:
87: IF l_mo_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
83: IF l_mo_line_rec.attribute14 = FND_API.G_MISS_CHAR THEN
84: l_mo_line_rec.attribute14 := NULL;
85: END IF;
86:
87: IF l_mo_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
88: l_mo_line_rec.attribute15 := NULL;
89: END IF;
90:
91: IF l_mo_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
87: IF l_mo_line_rec.attribute15 = FND_API.G_MISS_CHAR THEN
88: l_mo_line_rec.attribute15 := NULL;
89: END IF;
90:
91: IF l_mo_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
92: l_mo_line_rec.attribute2 := NULL;
93: END IF;
94:
95: IF l_mo_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
91: IF l_mo_line_rec.attribute2 = FND_API.G_MISS_CHAR THEN
92: l_mo_line_rec.attribute2 := NULL;
93: END IF;
94:
95: IF l_mo_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
96: l_mo_line_rec.attribute3 := NULL;
97: END IF;
98:
99: IF l_mo_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
95: IF l_mo_line_rec.attribute3 = FND_API.G_MISS_CHAR THEN
96: l_mo_line_rec.attribute3 := NULL;
97: END IF;
98:
99: IF l_mo_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
100: l_mo_line_rec.attribute4 := NULL;
101: END IF;
102:
103: IF l_mo_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
99: IF l_mo_line_rec.attribute4 = FND_API.G_MISS_CHAR THEN
100: l_mo_line_rec.attribute4 := NULL;
101: END IF;
102:
103: IF l_mo_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
104: l_mo_line_rec.attribute5 := NULL;
105: END IF;
106:
107: IF l_mo_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
103: IF l_mo_line_rec.attribute5 = FND_API.G_MISS_CHAR THEN
104: l_mo_line_rec.attribute5 := NULL;
105: END IF;
106:
107: IF l_mo_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
108: l_mo_line_rec.attribute6 := NULL;
109: END IF;
110:
111: IF l_mo_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
107: IF l_mo_line_rec.attribute6 = FND_API.G_MISS_CHAR THEN
108: l_mo_line_rec.attribute6 := NULL;
109: END IF;
110:
111: IF l_mo_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
112: l_mo_line_rec.attribute7 := NULL;
113: END IF;
114:
115: IF l_mo_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
111: IF l_mo_line_rec.attribute7 = FND_API.G_MISS_CHAR THEN
112: l_mo_line_rec.attribute7 := NULL;
113: END IF;
114:
115: IF l_mo_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
116: l_mo_line_rec.attribute8 := NULL;
117: END IF;
118:
119: IF l_mo_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
115: IF l_mo_line_rec.attribute8 = FND_API.G_MISS_CHAR THEN
116: l_mo_line_rec.attribute8 := NULL;
117: END IF;
118:
119: IF l_mo_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
120: l_mo_line_rec.attribute9 := NULL;
121: END IF;
122:
123: IF l_mo_line_rec.attribute_category = FND_API.G_MISS_CHAR THEN
119: IF l_mo_line_rec.attribute9 = FND_API.G_MISS_CHAR THEN
120: l_mo_line_rec.attribute9 := NULL;
121: END IF;
122:
123: IF l_mo_line_rec.attribute_category = FND_API.G_MISS_CHAR THEN
124: l_mo_line_rec.attribute_category := NULL;
125: END IF;
126:
127: IF l_mo_line_rec.created_by = FND_API.G_MISS_NUM THEN
123: IF l_mo_line_rec.attribute_category = FND_API.G_MISS_CHAR THEN
124: l_mo_line_rec.attribute_category := NULL;
125: END IF;
126:
127: IF l_mo_line_rec.created_by = FND_API.G_MISS_NUM THEN
128: l_mo_line_rec.created_by := NULL;
129: END IF;
130:
131: IF l_mo_line_rec.creation_date = FND_API.G_MISS_DATE THEN
127: IF l_mo_line_rec.created_by = FND_API.G_MISS_NUM THEN
128: l_mo_line_rec.created_by := NULL;
129: END IF;
130:
131: IF l_mo_line_rec.creation_date = FND_API.G_MISS_DATE THEN
132: l_mo_line_rec.creation_date := NULL;
133: END IF;
134:
135: IF l_mo_line_rec.date_required = FND_API.G_MISS_DATE THEN
131: IF l_mo_line_rec.creation_date = FND_API.G_MISS_DATE THEN
132: l_mo_line_rec.creation_date := NULL;
133: END IF;
134:
135: IF l_mo_line_rec.date_required = FND_API.G_MISS_DATE THEN
136: l_mo_line_rec.date_required := NULL;
137: END IF;
138:
139: IF l_mo_line_rec.from_locator_id = FND_API.G_MISS_NUM THEN
135: IF l_mo_line_rec.date_required = FND_API.G_MISS_DATE THEN
136: l_mo_line_rec.date_required := NULL;
137: END IF;
138:
139: IF l_mo_line_rec.from_locator_id = FND_API.G_MISS_NUM THEN
140: l_mo_line_rec.from_locator_id := NULL;
141: END IF;
142:
143: IF l_mo_line_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN
139: IF l_mo_line_rec.from_locator_id = FND_API.G_MISS_NUM THEN
140: l_mo_line_rec.from_locator_id := NULL;
141: END IF;
142:
143: IF l_mo_line_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN
144: l_mo_line_rec.from_subinventory_code := NULL;
145: END IF;
146:
147: IF l_mo_line_rec.from_subinventory_id = FND_API.G_MISS_NUM THEN
143: IF l_mo_line_rec.from_subinventory_code = FND_API.G_MISS_CHAR THEN
144: l_mo_line_rec.from_subinventory_code := NULL;
145: END IF;
146:
147: IF l_mo_line_rec.from_subinventory_id = FND_API.G_MISS_NUM THEN
148: l_mo_line_rec.from_subinventory_id := NULL;
149: END IF;
150:
151: IF l_mo_line_rec.header_id = FND_API.G_MISS_NUM THEN
147: IF l_mo_line_rec.from_subinventory_id = FND_API.G_MISS_NUM THEN
148: l_mo_line_rec.from_subinventory_id := NULL;
149: END IF;
150:
151: IF l_mo_line_rec.header_id = FND_API.G_MISS_NUM THEN
152: l_mo_line_rec.header_id := NULL;
153: END IF;
154:
155: IF l_mo_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
151: IF l_mo_line_rec.header_id = FND_API.G_MISS_NUM THEN
152: l_mo_line_rec.header_id := NULL;
153: END IF;
154:
155: IF l_mo_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
156: l_mo_line_rec.inventory_item_id := NULL;
157: END IF;
158:
159: IF l_mo_line_rec.last_updated_by = FND_API.G_MISS_NUM THEN
155: IF l_mo_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
156: l_mo_line_rec.inventory_item_id := NULL;
157: END IF;
158:
159: IF l_mo_line_rec.last_updated_by = FND_API.G_MISS_NUM THEN
160: l_mo_line_rec.last_updated_by := NULL;
161: END IF;
162:
163: IF l_mo_line_rec.last_update_date = FND_API.G_MISS_DATE THEN
159: IF l_mo_line_rec.last_updated_by = FND_API.G_MISS_NUM THEN
160: l_mo_line_rec.last_updated_by := NULL;
161: END IF;
162:
163: IF l_mo_line_rec.last_update_date = FND_API.G_MISS_DATE THEN
164: l_mo_line_rec.last_update_date := NULL;
165: END IF;
166:
167: IF l_mo_line_rec.last_update_login = FND_API.G_MISS_NUM THEN
163: IF l_mo_line_rec.last_update_date = FND_API.G_MISS_DATE THEN
164: l_mo_line_rec.last_update_date := NULL;
165: END IF;
166:
167: IF l_mo_line_rec.last_update_login = FND_API.G_MISS_NUM THEN
168: l_mo_line_rec.last_update_login := NULL;
169: END IF;
170:
171: IF l_mo_line_rec.line_id = FND_API.G_MISS_NUM THEN
167: IF l_mo_line_rec.last_update_login = FND_API.G_MISS_NUM THEN
168: l_mo_line_rec.last_update_login := NULL;
169: END IF;
170:
171: IF l_mo_line_rec.line_id = FND_API.G_MISS_NUM THEN
172: l_mo_line_rec.line_id := NULL;
173: END IF;
174:
175: IF l_mo_line_rec.line_number = FND_API.G_MISS_NUM THEN
171: IF l_mo_line_rec.line_id = FND_API.G_MISS_NUM THEN
172: l_mo_line_rec.line_id := NULL;
173: END IF;
174:
175: IF l_mo_line_rec.line_number = FND_API.G_MISS_NUM THEN
176: l_mo_line_rec.line_number := NULL;
177: END IF;
178:
179: IF l_mo_line_rec.line_status = FND_API.G_MISS_NUM THEN
175: IF l_mo_line_rec.line_number = FND_API.G_MISS_NUM THEN
176: l_mo_line_rec.line_number := NULL;
177: END IF;
178:
179: IF l_mo_line_rec.line_status = FND_API.G_MISS_NUM THEN
180: l_mo_line_rec.line_status := NULL;
181: END IF;
182:
183:
180: l_mo_line_rec.line_status := NULL;
181: END IF;
182:
183:
184: IF l_mo_line_rec.organization_id = FND_API.G_MISS_NUM THEN
185: l_mo_line_rec.organization_id := NULL;
186: END IF;
187:
188: IF l_mo_line_rec.program_application_id = FND_API.G_MISS_NUM THEN
184: IF l_mo_line_rec.organization_id = FND_API.G_MISS_NUM THEN
185: l_mo_line_rec.organization_id := NULL;
186: END IF;
187:
188: IF l_mo_line_rec.program_application_id = FND_API.G_MISS_NUM THEN
189: l_mo_line_rec.program_application_id := NULL;
190: END IF;
191:
192: IF l_mo_line_rec.program_id = FND_API.G_MISS_NUM THEN
188: IF l_mo_line_rec.program_application_id = FND_API.G_MISS_NUM THEN
189: l_mo_line_rec.program_application_id := NULL;
190: END IF;
191:
192: IF l_mo_line_rec.program_id = FND_API.G_MISS_NUM THEN
193: l_mo_line_rec.program_id := NULL;
194: END IF;
195:
196: IF l_mo_line_rec.program_update_date = FND_API.G_MISS_DATE THEN
192: IF l_mo_line_rec.program_id = FND_API.G_MISS_NUM THEN
193: l_mo_line_rec.program_id := NULL;
194: END IF;
195:
196: IF l_mo_line_rec.program_update_date = FND_API.G_MISS_DATE THEN
197: l_mo_line_rec.program_update_date := NULL;
198: END IF;
199:
200: /* IF l_mo_line_rec.project_id = FND_API.G_MISS_NUM THEN
196: IF l_mo_line_rec.program_update_date = FND_API.G_MISS_DATE THEN
197: l_mo_line_rec.program_update_date := NULL;
198: END IF;
199:
200: /* IF l_mo_line_rec.project_id = FND_API.G_MISS_NUM THEN
201: l_mo_line_rec.project_id := NULL;
202: END IF;
203: */
204:
201: l_mo_line_rec.project_id := NULL;
202: END IF;
203: */
204:
205: IF l_mo_line_rec.quantity = FND_API.G_MISS_NUM THEN
206: l_mo_line_rec.quantity := NULL;
207: END IF;
208:
209: IF l_mo_line_rec.quantity_delivered = FND_API.G_MISS_NUM THEN
205: IF l_mo_line_rec.quantity = FND_API.G_MISS_NUM THEN
206: l_mo_line_rec.quantity := NULL;
207: END IF;
208:
209: IF l_mo_line_rec.quantity_delivered = FND_API.G_MISS_NUM THEN
210: l_mo_line_rec.quantity_delivered := NULL;
211: END IF;
212:
213: IF l_mo_line_rec.quantity_detailed = FND_API.G_MISS_NUM THEN
209: IF l_mo_line_rec.quantity_delivered = FND_API.G_MISS_NUM THEN
210: l_mo_line_rec.quantity_delivered := NULL;
211: END IF;
212:
213: IF l_mo_line_rec.quantity_detailed = FND_API.G_MISS_NUM THEN
214: l_mo_line_rec.quantity_detailed := NULL;
215: END IF;
216:
217: IF l_mo_line_rec.reason_id = FND_API.G_MISS_NUM THEN
213: IF l_mo_line_rec.quantity_detailed = FND_API.G_MISS_NUM THEN
214: l_mo_line_rec.quantity_detailed := NULL;
215: END IF;
216:
217: IF l_mo_line_rec.reason_id = FND_API.G_MISS_NUM THEN
218: l_mo_line_rec.reason_id := NULL;
219: END IF;
220:
221: IF l_mo_line_rec.reference = FND_API.G_MISS_CHAR THEN
217: IF l_mo_line_rec.reason_id = FND_API.G_MISS_NUM THEN
218: l_mo_line_rec.reason_id := NULL;
219: END IF;
220:
221: IF l_mo_line_rec.reference = FND_API.G_MISS_CHAR THEN
222: l_mo_line_rec.reference := NULL;
223: END IF;
224:
225: IF l_mo_line_rec.reference_id = FND_API.G_MISS_NUM THEN
221: IF l_mo_line_rec.reference = FND_API.G_MISS_CHAR THEN
222: l_mo_line_rec.reference := NULL;
223: END IF;
224:
225: IF l_mo_line_rec.reference_id = FND_API.G_MISS_NUM THEN
226: l_mo_line_rec.reference_id := NULL;
227: END IF;
228:
229: IF l_mo_line_rec.reference_type_code = FND_API.G_MISS_NUM THEN
225: IF l_mo_line_rec.reference_id = FND_API.G_MISS_NUM THEN
226: l_mo_line_rec.reference_id := NULL;
227: END IF;
228:
229: IF l_mo_line_rec.reference_type_code = FND_API.G_MISS_NUM THEN
230: l_mo_line_rec.reference_type_code := NULL;
231: END IF;
232:
233: IF l_mo_line_rec.request_id = FND_API.G_MISS_NUM THEN
229: IF l_mo_line_rec.reference_type_code = FND_API.G_MISS_NUM THEN
230: l_mo_line_rec.reference_type_code := NULL;
231: END IF;
232:
233: IF l_mo_line_rec.request_id = FND_API.G_MISS_NUM THEN
234: l_mo_line_rec.request_id := NULL;
235: END IF;
236:
237: /*
234: l_mo_line_rec.request_id := NULL;
235: END IF;
236:
237: /*
238: IF l_mo_line_rec.revision = FND_API.G_MISS_CHAR THEN
239: l_mo_line_rec.revision := NULL;
240: END IF;
241:
242: IF l_mo_line_rec.serial_number_end = FND_API.G_MISS_CHAR THEN
238: IF l_mo_line_rec.revision = FND_API.G_MISS_CHAR THEN
239: l_mo_line_rec.revision := NULL;
240: END IF;
241:
242: IF l_mo_line_rec.serial_number_end = FND_API.G_MISS_CHAR THEN
243: l_mo_line_rec.serial_number_end := NULL;
244: END IF;
245:
246: IF l_mo_line_rec.serial_number_start = FND_API.G_MISS_CHAR THEN
242: IF l_mo_line_rec.serial_number_end = FND_API.G_MISS_CHAR THEN
243: l_mo_line_rec.serial_number_end := NULL;
244: END IF;
245:
246: IF l_mo_line_rec.serial_number_start = FND_API.G_MISS_CHAR THEN
247: l_mo_line_rec.serial_number_start := NULL;
248: END IF;
249:
250: IF l_mo_line_rec.task_id = FND_API.G_MISS_NUM THEN
246: IF l_mo_line_rec.serial_number_start = FND_API.G_MISS_CHAR THEN
247: l_mo_line_rec.serial_number_start := NULL;
248: END IF;
249:
250: IF l_mo_line_rec.task_id = FND_API.G_MISS_NUM THEN
251: l_mo_line_rec.task_id := NULL;
252: END IF;
253:
254: IF l_mo_line_rec.lot_number = FND_API.G_MISS_CHAR THEN
250: IF l_mo_line_rec.task_id = FND_API.G_MISS_NUM THEN
251: l_mo_line_rec.task_id := NULL;
252: END IF;
253:
254: IF l_mo_line_rec.lot_number = FND_API.G_MISS_CHAR THEN
255: l_mo_line_rec.lot_number := NULL;
256: END IF;
257: */
258:
255: l_mo_line_rec.lot_number := NULL;
256: END IF;
257: */
258:
259: IF l_mo_line_rec.status_date = FND_API.G_MISS_DATE THEN
260: l_mo_line_rec.status_date := NULL;
261: END IF;
262:
263: IF l_mo_line_rec.to_account_id = FND_API.G_MISS_NUM THEN
259: IF l_mo_line_rec.status_date = FND_API.G_MISS_DATE THEN
260: l_mo_line_rec.status_date := NULL;
261: END IF;
262:
263: IF l_mo_line_rec.to_account_id = FND_API.G_MISS_NUM THEN
264: l_mo_line_rec.to_account_id := NULL;
265: END IF;
266:
267: IF l_mo_line_rec.to_locator_id = FND_API.G_MISS_NUM THEN
263: IF l_mo_line_rec.to_account_id = FND_API.G_MISS_NUM THEN
264: l_mo_line_rec.to_account_id := NULL;
265: END IF;
266:
267: IF l_mo_line_rec.to_locator_id = FND_API.G_MISS_NUM THEN
268: l_mo_line_rec.to_locator_id := NULL;
269: END IF;
270:
271: IF l_mo_line_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
267: IF l_mo_line_rec.to_locator_id = FND_API.G_MISS_NUM THEN
268: l_mo_line_rec.to_locator_id := NULL;
269: END IF;
270:
271: IF l_mo_line_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
272: l_mo_line_rec.to_subinventory_code := NULL;
273: END IF;
274:
275: IF l_mo_line_rec.to_subinventory_id = FND_API.G_MISS_NUM THEN
271: IF l_mo_line_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
272: l_mo_line_rec.to_subinventory_code := NULL;
273: END IF;
274:
275: IF l_mo_line_rec.to_subinventory_id = FND_API.G_MISS_NUM THEN
276: l_mo_line_rec.to_subinventory_id := NULL;
277: END IF;
278:
279: IF l_mo_line_rec.transaction_header_id = FND_API.G_MISS_NUM THEN
275: IF l_mo_line_rec.to_subinventory_id = FND_API.G_MISS_NUM THEN
276: l_mo_line_rec.to_subinventory_id := NULL;
277: END IF;
278:
279: IF l_mo_line_rec.transaction_header_id = FND_API.G_MISS_NUM THEN
280: l_mo_line_rec.transaction_header_id := NULL;
281: END IF;
282:
283: IF l_mo_line_rec.uom_code = FND_API.G_MISS_CHAR THEN
279: IF l_mo_line_rec.transaction_header_id = FND_API.G_MISS_NUM THEN
280: l_mo_line_rec.transaction_header_id := NULL;
281: END IF;
282:
283: IF l_mo_line_rec.uom_code = FND_API.G_MISS_CHAR THEN
284: l_mo_line_rec.uom_code := NULL;
285: END IF;
286:
287: IF l_mo_line_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
283: IF l_mo_line_rec.uom_code = FND_API.G_MISS_CHAR THEN
284: l_mo_line_rec.uom_code := NULL;
285: END IF;
286:
287: IF l_mo_line_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
288: l_mo_line_rec.transaction_type_id := NULL;
289: END IF;
290:
291: IF l_mo_line_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
287: IF l_mo_line_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
288: l_mo_line_rec.transaction_type_id := NULL;
289: END IF;
290:
291: IF l_mo_line_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
292: l_mo_line_rec.transaction_source_type_id := NULL;
293: END IF;
294:
295: IF l_mo_line_rec.txn_source_id = FND_API.G_MISS_NUM THEN
291: IF l_mo_line_rec.transaction_source_type_id = FND_API.G_MISS_NUM THEN
292: l_mo_line_rec.transaction_source_type_id := NULL;
293: END IF;
294:
295: IF l_mo_line_rec.txn_source_id = FND_API.G_MISS_NUM THEN
296: l_mo_line_rec.txn_source_id := NULL;
297: END IF;
298:
299: IF l_mo_line_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
295: IF l_mo_line_rec.txn_source_id = FND_API.G_MISS_NUM THEN
296: l_mo_line_rec.txn_source_id := NULL;
297: END IF;
298:
299: IF l_mo_line_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
300: l_mo_line_rec.txn_source_line_id := NULL;
301: END IF;
302:
303: IF l_mo_line_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
299: IF l_mo_line_rec.txn_source_line_id = FND_API.G_MISS_NUM THEN
300: l_mo_line_rec.txn_source_line_id := NULL;
301: END IF;
302:
303: IF l_mo_line_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
304: l_mo_line_rec.txn_source_line_detail_id := NULL;
305: END IF;
306:
307: IF l_mo_line_rec.to_organization_id = FND_API.G_MISS_NUM THEN
303: IF l_mo_line_rec.txn_source_line_detail_id = FND_API.G_MISS_NUM THEN
304: l_mo_line_rec.txn_source_line_detail_id := NULL;
305: END IF;
306:
307: IF l_mo_line_rec.to_organization_id = FND_API.G_MISS_NUM THEN
308: l_mo_line_rec.to_organization_id := NULL;
309: END IF;
310:
311: IF l_mo_line_rec.primary_quantity = FND_API.G_MISS_NUM THEN
307: IF l_mo_line_rec.to_organization_id = FND_API.G_MISS_NUM THEN
308: l_mo_line_rec.to_organization_id := NULL;
309: END IF;
310:
311: IF l_mo_line_rec.primary_quantity = FND_API.G_MISS_NUM THEN
312: l_mo_line_rec.primary_quantity := NULL;
313: END IF;
314:
315: IF l_mo_line_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
311: IF l_mo_line_rec.primary_quantity = FND_API.G_MISS_NUM THEN
312: l_mo_line_rec.primary_quantity := NULL;
313: END IF;
314:
315: IF l_mo_line_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
316: l_mo_line_rec.pick_strategy_id := NULL;
317: END IF;
318:
319: IF l_mo_line_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
315: IF l_mo_line_rec.pick_strategy_id = FND_API.G_MISS_NUM THEN
316: l_mo_line_rec.pick_strategy_id := NULL;
317: END IF;
318:
319: IF l_mo_line_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
320: l_mo_line_rec.put_away_strategy_id := NULL;
321: END IF;
322:
323: IF l_mo_line_rec.lot_no = FND_API.G_MISS_CHAR THEN
319: IF l_mo_line_rec.put_away_strategy_id = FND_API.G_MISS_NUM THEN
320: l_mo_line_rec.put_away_strategy_id := NULL;
321: END IF;
322:
323: IF l_mo_line_rec.lot_no = FND_API.G_MISS_CHAR THEN
324: l_mo_line_rec.lot_no := NULL;
325: END IF;
326:
327: IF l_mo_line_rec.sublot_no = FND_API.G_MISS_CHAR THEN
323: IF l_mo_line_rec.lot_no = FND_API.G_MISS_CHAR THEN
324: l_mo_line_rec.lot_no := NULL;
325: END IF;
326:
327: IF l_mo_line_rec.sublot_no = FND_API.G_MISS_CHAR THEN
328: l_mo_line_rec.sublot_no := NULL;
329: END IF;
330:
331: IF l_mo_line_rec.qc_grade = FND_API.G_MISS_CHAR THEN
327: IF l_mo_line_rec.sublot_no = FND_API.G_MISS_CHAR THEN
328: l_mo_line_rec.sublot_no := NULL;
329: END IF;
330:
331: IF l_mo_line_rec.qc_grade = FND_API.G_MISS_CHAR THEN
332: l_mo_line_rec.qc_grade := NULL;
333: END IF;
334:
335: IF l_mo_line_rec.secondary_quantity = FND_API.G_MISS_NUM THEN
331: IF l_mo_line_rec.qc_grade = FND_API.G_MISS_CHAR THEN
332: l_mo_line_rec.qc_grade := NULL;
333: END IF;
334:
335: IF l_mo_line_rec.secondary_quantity = FND_API.G_MISS_NUM THEN
336: l_mo_line_rec.secondary_quantity:= NULL;
337: END IF;
338:
339: IF l_mo_line_rec.secondary_uom_code= FND_API.G_MISS_CHAR THEN
335: IF l_mo_line_rec.secondary_quantity = FND_API.G_MISS_NUM THEN
336: l_mo_line_rec.secondary_quantity:= NULL;
337: END IF;
338:
339: IF l_mo_line_rec.secondary_uom_code= FND_API.G_MISS_CHAR THEN
340: l_mo_line_rec.secondary_uom_code:= NULL;
341: END IF;
342:
343: IF l_mo_line_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM THEN
339: IF l_mo_line_rec.secondary_uom_code= FND_API.G_MISS_CHAR THEN
340: l_mo_line_rec.secondary_uom_code:= NULL;
341: END IF;
342:
343: IF l_mo_line_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM THEN
344: l_mo_line_rec.secondary_quantity_delivered:= NULL;
345: END IF;
346:
347: IF l_mo_line_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM THEN
343: IF l_mo_line_rec.secondary_quantity_delivered = FND_API.G_MISS_NUM THEN
344: l_mo_line_rec.secondary_quantity_delivered:= NULL;
345: END IF;
346:
347: IF l_mo_line_rec.secondary_quantity_detailed = FND_API.G_MISS_NUM THEN
348: l_mo_line_rec.secondary_quantity_detailed:= NULL;
349: END IF;
350:
351: -- HW BUG#:2296620
348: l_mo_line_rec.secondary_quantity_detailed:= NULL;
349: END IF;
350:
351: -- HW BUG#:2296620
352: IF l_mo_line_rec.ship_set_id = FND_API.G_MISS_NUM THEN
353: l_mo_line_rec.ship_set_id:= NULL;
354: END IF;
355:
356: RETURN l_mo_line_rec;
455: , 'Update_Row'
456: );
457: END IF;
458:
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460:
461: END Update_Row;
462:
463: /* Procedure Update_Row_Status */
488: , 'Update_Row_Status'
489: );
490: END IF;
491:
492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
493:
494: END Update_Row_Status;
495:
496: /* Procedure Insert_Row */
674: , 'Insert_Row'
675: );
676: END IF;
677:
678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679:
680: END Insert_Row;
681:
682: /* Procedure Delete_Row */
703: , 'Delete_Row'
704: );
705: END IF;
706:
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708:
709: END Delete_Row;
710:
711: /* Function Get_Lines */
834:
835:
836: BEGIN
837:
838: -- HW BUG#:2643440. Removed the AND condition to check for FND_API.G_MISS_NUM
839: -- for both p_line_id and p_header_id
840: IF
841: (p_line_id IS NOT NULL)
842: AND
850: , 'Keys are mutually exclusive: line_id = '|| p_line_id || ', header_id = '|| p_header_id
851: );
852: END IF;
853:
854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
855:
856: END IF;
857:
858:
939:
940:
941: /* PK sent and no rows found */
942:
943: -- HW BUG#:2643440. Removed the AND condition to check for FND_API.G_MISS_NUM
944: -- for p_line_id
945: IF
946: (p_line_id IS NOT NULL)
947: AND
956: RETURN l_mo_line_tbl;
957:
958: EXCEPTION
959:
960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
961:
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963:
964: WHEN OTHERS THEN
958: EXCEPTION
959:
960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
961:
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963:
964: WHEN OTHERS THEN
965:
966: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
970: , 'Query_Rows'
971: );
972: END IF;
973:
974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
975:
976: END Query_Rows;
977:
978: /* Procedure lock_Row */
1058: FOR UPDATE NOWAIT;
1059:
1060: BEGIN
1061:
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063: GMI_Reservation_Util.PrintLn('(opm_dbg) Entering Lock_Row : line_id='||p_mo_line_rec.line_id);
1064:
1065: OPEN c_lock_mol(p_mo_line_rec.line_id);
1066: GMI_Reservation_Util.PrintLn('(opm_dbg) Entering Lock_Row :');
1145: OR SQLCODE = -54 )
1146: THEN
1147: CLOSE c_lock_mol;
1148: GMI_Reservation_Util.PrintLn('(opm_dbg) Lock_Row : the MO_line is locked for line_id='||p_mo_line_rec.line_id||', SQL_CODE='||SQLCODE);
1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: END IF;
1151: CLOSE c_lock_mol;
1152:
1153: x_mo_line_rec := l_mo_line_rec;
1153: x_mo_line_rec := l_mo_line_rec;
1154:
1155: /* Set return status */
1156:
1157: x_return_status := FND_API.G_RET_STS_SUCCESS;
1158: x_mo_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1159:
1160: EXCEPTION
1161:
1154:
1155: /* Set return status */
1156:
1157: x_return_status := FND_API.G_RET_STS_SUCCESS;
1158: x_mo_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1159:
1160: EXCEPTION
1161:
1162: WHEN NO_DATA_FOUND THEN
1161:
1162: WHEN NO_DATA_FOUND THEN
1163: GMI_Reservation_Util.PrintLn('(opm_dbg) excp Lock_Row : the MO_line is NOTFOUND line_id='||p_mo_line_rec.line_id||', SQL_CODE='||SQLCODE);
1164:
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: x_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1167:
1168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1169: THEN
1162: WHEN NO_DATA_FOUND THEN
1163: GMI_Reservation_Util.PrintLn('(opm_dbg) excp Lock_Row : the MO_line is NOTFOUND line_id='||p_mo_line_rec.line_id||', SQL_CODE='||SQLCODE);
1164:
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166: x_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1167:
1168: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1169: THEN
1170:
1175: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1176:
1177: GMI_Reservation_Util.PrintLn('(opm_dbg) excp Lock_Row : the MO_line is locked for line_id='||p_mo_line_rec.line_id||', SQL_CODE='||SQLCODE);
1178: x_return_status := '54';
1179: x_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1180:
1181: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1182: THEN
1183:
1186:
1187: END IF;
1188: WHEN OTHERS THEN
1189: GMI_Reservation_Util.PrintLn('(opm_dbg) excp Lock_Row : the MO_line is OTHERS line_id='||p_mo_line_rec.line_id||', SQL_CODE='||SQLCODE);
1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1191:
1192: x_mo_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193:
1194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1188: WHEN OTHERS THEN
1189: GMI_Reservation_Util.PrintLn('(opm_dbg) excp Lock_Row : the MO_line is OTHERS line_id='||p_mo_line_rec.line_id||', SQL_CODE='||SQLCODE);
1190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1191:
1192: x_mo_line_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193:
1194: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1195: THEN
1196: FND_MSG_PUB.Add_Exc_Msg
1213: l_trolin_val_rec INV_Move_Order_PUB.Trolin_Val_Rec_Type;
1214: BEGIN
1215:
1216: IF p_mo_line_rec.from_locator_id IS NOT NULL AND
1217: p_mo_line_rec.from_locator_id <> FND_API.G_MISS_NUM AND
1218: NOT INV_GLOBALS.Equal(p_mo_line_rec.from_locator_id,
1219: p_old_mo_line_rec.from_locator_id)
1220: THEN
1221: l_trolin_val_rec.from_locator := INV_Id_To_Value.From_Locator
1223: );
1224: END IF;
1225:
1226: -- IF p_mo_line_rec.from_subinventory_code IS NOT NULL AND
1227: -- p_mo_line_rec.from_subinventory_code <> FND_API.G_MISS_CHAR AND
1228: -- NOT INV_GLOBALS.Equal(p_mo_line_rec.from_subinventory_code,
1229: -- p_old_mo_line_rec.from_subinventory_code)
1230: -- THEN
1231: -- l_trolin_val_rec.from_subinventory := INV_Id_To_Value.From_Subinventory
1233: -- );
1234: -- END IF; -- Generated
1235: -- Line 2167
1236: IF p_mo_line_rec.from_subinventory_id IS NOT NULL AND
1237: p_mo_line_rec.from_subinventory_id <> FND_API.G_MISS_NUM AND
1238: NOT INV_GLOBALS.Equal(p_mo_line_rec.from_subinventory_id,
1239: p_old_mo_line_rec.from_subinventory_id)
1240: THEN
1241: l_trolin_val_rec.from_subinventory := INV_Id_To_Value.From_Subinventory
1245: -- );
1246: END IF;
1247:
1248: IF p_mo_line_rec.header_id IS NOT NULL AND
1249: p_mo_line_rec.header_id <> FND_API.G_MISS_NUM AND
1250: NOT INV_GLOBALS.Equal(p_mo_line_rec.header_id,
1251: p_old_mo_line_rec.header_id)
1252: THEN
1253: l_trolin_val_rec.header := INV_Id_To_Value.Header
1255: );
1256: END IF;
1257:
1258: IF p_mo_line_rec.inventory_item_id IS NOT NULL AND
1259: p_mo_line_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
1260: NOT INV_GLOBALS.Equal(p_mo_line_rec.inventory_item_id,
1261: p_old_mo_line_rec.inventory_item_id)
1262: THEN
1263: l_trolin_val_rec.inventory_item := INV_Id_To_Value.Inventory_Item
1265: );
1266: END IF;
1267:
1268: IF p_mo_line_rec.line_id IS NOT NULL AND
1269: p_mo_line_rec.line_id <> FND_API.G_MISS_NUM AND
1270: NOT INV_GLOBALS.Equal(p_mo_line_rec.line_id,
1271: p_old_mo_line_rec.line_id)
1272: THEN
1273: l_trolin_val_rec.line := INV_Id_To_Value.Line
1275: );
1276: END IF;
1277:
1278: IF p_mo_line_rec.organization_id IS NOT NULL AND
1279: p_mo_line_rec.organization_id <> FND_API.G_MISS_NUM AND
1280: NOT INV_GLOBALS.Equal(p_mo_line_rec.organization_id,
1281: p_old_mo_line_rec.organization_id)
1282: THEN
1283: l_trolin_val_rec.organization := INV_Id_To_Value.Organization
1285: );
1286: END IF;
1287:
1288: IF p_mo_line_rec.to_organization_id IS NOT NULL AND
1289: p_mo_line_rec.to_organization_id <> FND_API.G_MISS_NUM AND
1290: NOT INV_GLOBALS.Equal(p_mo_line_rec.to_organization_id,
1291: p_old_mo_line_rec.to_organization_id)
1292: THEN
1293: l_trolin_val_rec.to_organization := INV_Id_To_Value.To_Organization
1295: );
1296: END IF;
1297:
1298: IF p_mo_line_rec.project_id IS NOT NULL AND
1299: p_mo_line_rec.project_id <> FND_API.G_MISS_NUM AND
1300: NOT INV_GLOBALS.Equal(p_mo_line_rec.project_id,
1301: p_old_mo_line_rec.project_id)
1302: THEN
1303: l_trolin_val_rec.project := INV_Id_To_Value.Project
1305: );
1306: END IF;
1307:
1308: IF p_mo_line_rec.reason_id IS NOT NULL AND
1309: p_mo_line_rec.reason_id <> FND_API.G_MISS_NUM AND
1310: NOT INV_GLOBALS.Equal(p_mo_line_rec.reason_id,
1311: p_old_mo_line_rec.reason_id)
1312: THEN
1313: l_trolin_val_rec.reason := INV_Id_To_Value.Reason
1315: );
1316: END IF;
1317:
1318: IF p_mo_line_rec.reference_id IS NOT NULL AND
1319: p_mo_line_rec.reference_id <> FND_API.G_MISS_NUM AND
1320: NOT INV_GLOBALS.Equal(p_mo_line_rec.reference_id,
1321: p_old_mo_line_rec.reference_id)
1322: THEN
1323: l_trolin_val_rec.reference := INV_Id_To_Value.Reference
1325: );
1326: END IF;
1327:
1328: IF p_mo_line_rec.reference_type_code IS NOT NULL AND
1329: p_mo_line_rec.reference_type_code <> FND_API.G_MISS_NUM AND
1330: NOT INV_GLOBALS.Equal(p_mo_line_rec.reference_type_code,
1331: p_old_mo_line_rec.reference_type_code)
1332: THEN
1333: l_trolin_val_rec.reference_type := INV_Id_To_Value.Reference_Type
1335: );
1336: END IF;
1337:
1338: IF p_mo_line_rec.task_id IS NOT NULL AND
1339: p_mo_line_rec.task_id <> FND_API.G_MISS_NUM AND
1340: NOT INV_GLOBALS.Equal(p_mo_line_rec.task_id,
1341: p_old_mo_line_rec.task_id)
1342: THEN
1343: l_trolin_val_rec.task := INV_Id_To_Value.Task
1345: );
1346: END IF;
1347:
1348: IF p_mo_line_rec.to_account_id IS NOT NULL AND
1349: p_mo_line_rec.to_account_id <> FND_API.G_MISS_NUM AND
1350: NOT INV_GLOBALS.Equal(p_mo_line_rec.to_account_id,
1351: p_old_mo_line_rec.to_account_id)
1352: THEN
1353: l_trolin_val_rec.to_account := INV_Id_To_Value.To_Account
1355: );
1356: END IF;
1357:
1358: IF p_mo_line_rec.to_locator_id IS NOT NULL AND
1359: p_mo_line_rec.to_locator_id <> FND_API.G_MISS_NUM AND
1360: NOT INV_GLOBALS.Equal(p_mo_line_rec.to_locator_id,
1361: p_old_mo_line_rec.to_locator_id)
1362: THEN
1363: l_trolin_val_rec.to_locator := INV_Id_To_Value.To_Locator
1365: );
1366: END IF;
1367:
1368: -- IF p_mo_line_rec.to_subinventory_code IS NOT NULL AND
1369: -- p_mo_line_rec.to_subinventory_code <> FND_API.G_MISS_CHAR AND
1370: -- NOT INV_GLOBALS.Equal(p_mo_line_rec.to_subinventory_code,
1371: -- p_old_mo_line_rec.to_subinventory_code)
1372: -- THEN
1373: -- l_trolin_val_rec.to_subinventory := INV_Id_To_Value.To_Subinventory
1375: -- );
1376: -- END IF; -- Generated
1377:
1378: IF p_mo_line_rec.to_subinventory_id IS NOT NULL AND
1379: p_mo_line_rec.to_subinventory_id <> FND_API.G_MISS_NUM AND
1380: NOT INV_GLOBALS.Equal(p_mo_line_rec.to_subinventory_id,
1381: p_old_mo_line_rec.to_subinventory_id)
1382: THEN
1383: l_trolin_val_rec.to_subinventory := INV_Id_To_Value.To_Subinventory
1385: );
1386: END IF;
1387:
1388: IF p_mo_line_rec.transaction_header_id IS NOT NULL AND
1389: p_mo_line_rec.transaction_header_id <> FND_API.G_MISS_NUM AND
1390: NOT INV_GLOBALS.Equal(p_mo_line_rec.transaction_header_id,
1391: p_old_mo_line_rec.transaction_header_id)
1392: THEN
1393: l_trolin_val_rec.transaction_header := INV_Id_To_Value.Transaction_Header
1395: );
1396: END IF;
1397:
1398: IF p_mo_line_rec.transaction_type_id IS NOT NULL AND
1399: p_mo_line_rec.transaction_type_id <> FND_API.G_MISS_NUM AND
1400: NOT INV_GLOBALS.Equal(p_mo_line_rec.transaction_type_id,
1401: p_old_mo_line_rec.transaction_type_id)
1402: THEN
1403: l_trolin_val_rec.transaction_type := INV_Id_To_Value.Transaction_type
1405: );
1406: END IF;
1407:
1408: IF p_mo_line_rec.uom_code IS NOT NULL AND
1409: p_mo_line_rec.uom_code <> FND_API.G_MISS_CHAR AND
1410: NOT INV_GLOBALS.Equal(p_mo_line_rec.uom_code,
1411: p_old_mo_line_rec.uom_code)
1412: THEN
1413: l_trolin_val_rec.uom := INV_Id_To_Value.Uom
1430: BEGIN
1431:
1432: -- initialize return_status.
1433:
1434: l_mo_line_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1435:
1436: -- initialize l_mo_line_rec.
1437:
1438: l_mo_line_rec := p_mo_line_rec;
1436: -- initialize l_mo_line_rec.
1437:
1438: l_mo_line_rec := p_mo_line_rec;
1439:
1440: IF p_trolin_val_rec.from_locator <> FND_API.G_MISS_CHAR
1441: THEN
1442:
1443: IF p_mo_line_rec.from_locator_id <> FND_API.G_MISS_NUM THEN
1444:
1439:
1440: IF p_trolin_val_rec.from_locator <> FND_API.G_MISS_CHAR
1441: THEN
1442:
1443: IF p_mo_line_rec.from_locator_id <> FND_API.G_MISS_NUM THEN
1444:
1445: l_mo_line_rec.from_locator_id := p_mo_line_rec.from_locator_id;
1446:
1447: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1459: ( p_organizatoin_id => p_mo_line_rec.organization_id,
1460: p_from_locator => p_trolin_val_rec.from_locator
1461: );
1462:
1463: IF l_mo_line_rec.from_locator_id = FND_API.G_MISS_NUM THEN
1464: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1465: END IF;
1466:
1467: END IF;
1460: p_from_locator => p_trolin_val_rec.from_locator
1461: );
1462:
1463: IF l_mo_line_rec.from_locator_id = FND_API.G_MISS_NUM THEN
1464: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1465: END IF;
1466:
1467: END IF;
1468:
1467: END IF;
1468:
1469: END IF;
1470:
1471: IF p_trolin_val_rec.from_subinventory <> FND_API.G_MISS_CHAR
1472: THEN
1473:
1474: IF p_mo_line_rec.from_subinventory_id <> FND_API.G_MISS_NUM THEN
1475:
1470:
1471: IF p_trolin_val_rec.from_subinventory <> FND_API.G_MISS_CHAR
1472: THEN
1473:
1474: IF p_mo_line_rec.from_subinventory_id <> FND_API.G_MISS_NUM THEN
1475:
1476: l_mo_line_rec.from_subinventory_id := p_mo_line_rec.from_subinventory_id;
1477:
1478: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1490: ( p_organization_id => p_mo_line_rec.organization_id,
1491: p_from_subinventory => p_trolin_val_rec.from_subinventory
1492: );
1493:
1494: IF l_mo_line_rec.from_subinventory_id = FND_API.G_MISS_NUM THEN
1495: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1496: END IF;
1497:
1498: END IF;
1491: p_from_subinventory => p_trolin_val_rec.from_subinventory
1492: );
1493:
1494: IF l_mo_line_rec.from_subinventory_id = FND_API.G_MISS_NUM THEN
1495: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1496: END IF;
1497:
1498: END IF;
1499:
1498: END IF;
1499:
1500: END IF;
1501:
1502: IF p_trolin_val_rec.header <> FND_API.G_MISS_CHAR
1503: THEN
1504:
1505: IF p_mo_line_rec.header_id <> FND_API.G_MISS_NUM THEN
1506:
1501:
1502: IF p_trolin_val_rec.header <> FND_API.G_MISS_CHAR
1503: THEN
1504:
1505: IF p_mo_line_rec.header_id <> FND_API.G_MISS_NUM THEN
1506:
1507: l_mo_line_rec.header_id := p_mo_line_rec.header_id;
1508:
1509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1520: l_mo_line_rec.header_id := INV_Value_To_Id.header
1521: ( p_header => p_trolin_val_rec.header
1522: );
1523:
1524: IF l_mo_line_rec.header_id = FND_API.G_MISS_NUM THEN
1525: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1526: END IF;
1527:
1528: END IF;
1521: ( p_header => p_trolin_val_rec.header
1522: );
1523:
1524: IF l_mo_line_rec.header_id = FND_API.G_MISS_NUM THEN
1525: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1526: END IF;
1527:
1528: END IF;
1529:
1528: END IF;
1529:
1530: END IF;
1531:
1532: IF p_trolin_val_rec.inventory_item <> FND_API.G_MISS_CHAR
1533: THEN
1534:
1535: IF p_mo_line_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
1536:
1531:
1532: IF p_trolin_val_rec.inventory_item <> FND_API.G_MISS_CHAR
1533: THEN
1534:
1535: IF p_mo_line_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
1536:
1537: l_mo_line_rec.inventory_item_id := p_mo_line_rec.inventory_item_id;
1538:
1539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1551: ( p_organization_id => p_mo_line_rec.organization_id,
1552: p_inventory_item => p_trolin_val_rec.inventory_item
1553: );
1554:
1555: IF l_mo_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1556: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1557: END IF;
1558:
1559: END IF;
1552: p_inventory_item => p_trolin_val_rec.inventory_item
1553: );
1554:
1555: IF l_mo_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1556: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1557: END IF;
1558:
1559: END IF;
1560:
1559: END IF;
1560:
1561: END IF;
1562:
1563: IF p_trolin_val_rec.line <> FND_API.G_MISS_CHAR
1564: THEN
1565:
1566: IF p_mo_line_rec.line_id <> FND_API.G_MISS_NUM THEN
1567:
1562:
1563: IF p_trolin_val_rec.line <> FND_API.G_MISS_CHAR
1564: THEN
1565:
1566: IF p_mo_line_rec.line_id <> FND_API.G_MISS_NUM THEN
1567:
1568: l_mo_line_rec.line_id := p_mo_line_rec.line_id;
1569:
1570: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1581: l_mo_line_rec.line_id := INV_Value_To_Id.line
1582: ( p_line => p_trolin_val_rec.line
1583: );
1584:
1585: IF l_mo_line_rec.line_id = FND_API.G_MISS_NUM THEN
1586: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1587: END IF;
1588:
1589: END IF;
1582: ( p_line => p_trolin_val_rec.line
1583: );
1584:
1585: IF l_mo_line_rec.line_id = FND_API.G_MISS_NUM THEN
1586: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1587: END IF;
1588:
1589: END IF;
1590:
1589: END IF;
1590:
1591: END IF;
1592:
1593: IF p_trolin_val_rec.organization <> FND_API.G_MISS_CHAR
1594: THEN
1595:
1596: IF p_mo_line_rec.organization_id <> FND_API.G_MISS_NUM THEN
1597:
1592:
1593: IF p_trolin_val_rec.organization <> FND_API.G_MISS_CHAR
1594: THEN
1595:
1596: IF p_mo_line_rec.organization_id <> FND_API.G_MISS_NUM THEN
1597:
1598: l_mo_line_rec.organization_id := p_mo_line_rec.organization_id;
1599:
1600: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1611: l_mo_line_rec.organization_id := INV_Value_To_Id.organization
1612: ( p_organization => p_trolin_val_rec.organization
1613: );
1614:
1615: IF l_mo_line_rec.organization_id = FND_API.G_MISS_NUM THEN
1616: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1617: END IF;
1618:
1619: END IF;
1612: ( p_organization => p_trolin_val_rec.organization
1613: );
1614:
1615: IF l_mo_line_rec.organization_id = FND_API.G_MISS_NUM THEN
1616: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1617: END IF;
1618:
1619: END IF;
1620:
1619: END IF;
1620:
1621: END IF;
1622:
1623: IF p_trolin_val_rec.to_organization <> FND_API.G_MISS_CHAR
1624: THEN
1625:
1626: IF p_mo_line_rec.to_organization_id <> FND_API.G_MISS_NUM THEN
1627:
1622:
1623: IF p_trolin_val_rec.to_organization <> FND_API.G_MISS_CHAR
1624: THEN
1625:
1626: IF p_mo_line_rec.to_organization_id <> FND_API.G_MISS_NUM THEN
1627:
1628: l_mo_line_rec.to_organization_id := p_mo_line_rec.to_organization_id;
1629:
1630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1641: l_mo_line_rec.to_organization_id := INV_Value_To_Id.to_organization
1642: ( p_to_organization => p_trolin_val_rec.to_organization
1643: );
1644:
1645: IF l_mo_line_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1646: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1647: END IF;
1648:
1649: END IF;
1642: ( p_to_organization => p_trolin_val_rec.to_organization
1643: );
1644:
1645: IF l_mo_line_rec.to_organization_id = FND_API.G_MISS_NUM THEN
1646: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1647: END IF;
1648:
1649: END IF;
1650:
1648:
1649: END IF;
1650:
1651: END IF;
1652: IF p_trolin_val_rec.project <> FND_API.G_MISS_CHAR
1653: THEN
1654:
1655: IF p_mo_line_rec.project_id <> FND_API.G_MISS_NUM THEN
1656:
1651: END IF;
1652: IF p_trolin_val_rec.project <> FND_API.G_MISS_CHAR
1653: THEN
1654:
1655: IF p_mo_line_rec.project_id <> FND_API.G_MISS_NUM THEN
1656:
1657: l_mo_line_rec.project_id := p_mo_line_rec.project_id;
1658:
1659: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1670: l_mo_line_rec.project_id := INV_Value_To_Id.project
1671: ( p_project => p_trolin_val_rec.project
1672: );
1673:
1674: IF l_mo_line_rec.project_id = FND_API.G_MISS_NUM THEN
1675: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1676: END IF;
1677:
1678: END IF;
1671: ( p_project => p_trolin_val_rec.project
1672: );
1673:
1674: IF l_mo_line_rec.project_id = FND_API.G_MISS_NUM THEN
1675: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1676: END IF;
1677:
1678: END IF;
1679:
1678: END IF;
1679:
1680: END IF;
1681:
1682: IF p_trolin_val_rec.reason <> FND_API.G_MISS_CHAR
1683: THEN
1684:
1685: IF p_mo_line_rec.reason_id <> FND_API.G_MISS_NUM THEN
1686:
1681:
1682: IF p_trolin_val_rec.reason <> FND_API.G_MISS_CHAR
1683: THEN
1684:
1685: IF p_mo_line_rec.reason_id <> FND_API.G_MISS_NUM THEN
1686:
1687: l_mo_line_rec.reason_id := p_mo_line_rec.reason_id;
1688:
1689: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1700: l_mo_line_rec.reason_id := INV_Value_To_Id.reason
1701: ( p_reason => p_trolin_val_rec.reason
1702: );
1703:
1704: IF l_mo_line_rec.reason_id = FND_API.G_MISS_NUM THEN
1705: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1706: END IF;
1707:
1708: END IF;
1701: ( p_reason => p_trolin_val_rec.reason
1702: );
1703:
1704: IF l_mo_line_rec.reason_id = FND_API.G_MISS_NUM THEN
1705: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1706: END IF;
1707:
1708: END IF;
1709:
1708: END IF;
1709:
1710: END IF;
1711:
1712: IF p_trolin_val_rec.reference <> FND_API.G_MISS_CHAR
1713: THEN
1714:
1715: IF p_mo_line_rec.reference_id <> FND_API.G_MISS_NUM THEN
1716:
1711:
1712: IF p_trolin_val_rec.reference <> FND_API.G_MISS_CHAR
1713: THEN
1714:
1715: IF p_mo_line_rec.reference_id <> FND_API.G_MISS_NUM THEN
1716:
1717: l_mo_line_rec.reference_id := p_mo_line_rec.reference_id;
1718:
1719: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1730: l_mo_line_rec.reference_id := INV_Value_To_Id.reference
1731: ( p_reference => p_trolin_val_rec.reference
1732: );
1733:
1734: IF l_mo_line_rec.reference_id = FND_API.G_MISS_NUM THEN
1735: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1736: END IF;
1737:
1738: END IF;
1731: ( p_reference => p_trolin_val_rec.reference
1732: );
1733:
1734: IF l_mo_line_rec.reference_id = FND_API.G_MISS_NUM THEN
1735: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1736: END IF;
1737:
1738: END IF;
1739:
1738: END IF;
1739:
1740: END IF;
1741:
1742: IF p_trolin_val_rec.reference_type <> FND_API.G_MISS_CHAR
1743: THEN
1744:
1745: IF p_mo_line_rec.reference_type_code <> FND_API.G_MISS_NUM THEN
1746:
1741:
1742: IF p_trolin_val_rec.reference_type <> FND_API.G_MISS_CHAR
1743: THEN
1744:
1745: IF p_mo_line_rec.reference_type_code <> FND_API.G_MISS_NUM THEN
1746:
1747: l_mo_line_rec.reference_type_code := p_mo_line_rec.reference_type_code;
1748:
1749: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1760: l_mo_line_rec.reference_type_code := INV_Value_To_Id.reference_type
1761: ( p_reference_type => p_trolin_val_rec.reference_type
1762: );
1763:
1764: IF l_mo_line_rec.reference_type_code = FND_API.G_MISS_NUM THEN
1765: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1766: END IF;
1767:
1768: END IF;
1761: ( p_reference_type => p_trolin_val_rec.reference_type
1762: );
1763:
1764: IF l_mo_line_rec.reference_type_code = FND_API.G_MISS_NUM THEN
1765: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1766: END IF;
1767:
1768: END IF;
1769:
1768: END IF;
1769:
1770: END IF;
1771:
1772: IF p_trolin_val_rec.task <> FND_API.G_MISS_CHAR
1773: THEN
1774:
1775: IF p_mo_line_rec.task_id <> FND_API.G_MISS_NUM THEN
1776:
1771:
1772: IF p_trolin_val_rec.task <> FND_API.G_MISS_CHAR
1773: THEN
1774:
1775: IF p_mo_line_rec.task_id <> FND_API.G_MISS_NUM THEN
1776:
1777: l_mo_line_rec.task_id := p_mo_line_rec.task_id;
1778:
1779: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1790: l_mo_line_rec.task_id := INV_Value_To_Id.task
1791: ( p_task => p_trolin_val_rec.task
1792: );
1793:
1794: IF l_mo_line_rec.task_id = FND_API.G_MISS_NUM THEN
1795: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1796: END IF;
1797:
1798: END IF;
1791: ( p_task => p_trolin_val_rec.task
1792: );
1793:
1794: IF l_mo_line_rec.task_id = FND_API.G_MISS_NUM THEN
1795: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1796: END IF;
1797:
1798: END IF;
1799:
1798: END IF;
1799:
1800: END IF;
1801:
1802: IF p_trolin_val_rec.to_account <> FND_API.G_MISS_CHAR
1803: THEN
1804:
1805: IF p_mo_line_rec.to_account_id <> FND_API.G_MISS_NUM THEN
1806:
1801:
1802: IF p_trolin_val_rec.to_account <> FND_API.G_MISS_CHAR
1803: THEN
1804:
1805: IF p_mo_line_rec.to_account_id <> FND_API.G_MISS_NUM THEN
1806:
1807: l_mo_line_rec.to_account_id := p_mo_line_rec.to_account_id;
1808:
1809: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1821: ( p_organization_id => p_mo_line_rec.organization_id,
1822: p_to_account => p_trolin_val_rec.to_account
1823: );
1824:
1825: IF l_mo_line_rec.to_account_id = FND_API.G_MISS_NUM THEN
1826: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1827: END IF;
1828:
1829: END IF;
1822: p_to_account => p_trolin_val_rec.to_account
1823: );
1824:
1825: IF l_mo_line_rec.to_account_id = FND_API.G_MISS_NUM THEN
1826: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1827: END IF;
1828:
1829: END IF;
1830:
1829: END IF;
1830:
1831: END IF;
1832:
1833: IF p_trolin_val_rec.to_locator <> FND_API.G_MISS_CHAR
1834: THEN
1835:
1836: IF p_mo_line_rec.to_locator_id <> FND_API.G_MISS_NUM THEN
1837:
1832:
1833: IF p_trolin_val_rec.to_locator <> FND_API.G_MISS_CHAR
1834: THEN
1835:
1836: IF p_mo_line_rec.to_locator_id <> FND_API.G_MISS_NUM THEN
1837:
1838: l_mo_line_rec.to_locator_id := p_mo_line_rec.to_locator_id;
1839:
1840: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1851: l_mo_line_rec.to_locator_id := INV_Value_To_Id.to_locator
1852: ( p_to_locator => p_trolin_val_rec.to_locator
1853: );
1854:
1855: IF l_mo_line_rec.to_locator_id = FND_API.G_MISS_NUM THEN
1856: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1857: END IF;
1858:
1859: END IF;
1852: ( p_to_locator => p_trolin_val_rec.to_locator
1853: );
1854:
1855: IF l_mo_line_rec.to_locator_id = FND_API.G_MISS_NUM THEN
1856: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1857: END IF;
1858:
1859: END IF;
1860:
1859: END IF;
1860:
1861: END IF;
1862:
1863: IF p_trolin_val_rec.to_subinventory <> FND_API.G_MISS_CHAR
1864: THEN
1865:
1866: IF p_mo_line_rec.to_subinventory_code <> FND_API.G_MISS_CHAR THEN
1867:
1862:
1863: IF p_trolin_val_rec.to_subinventory <> FND_API.G_MISS_CHAR
1864: THEN
1865:
1866: IF p_mo_line_rec.to_subinventory_code <> FND_API.G_MISS_CHAR THEN
1867:
1868: l_mo_line_rec.to_subinventory_code := p_mo_line_rec.to_subinventory_code;
1869:
1870: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1882: ( p_organization_id => p_mo_line_rec.organization_id,
1883: p_to_subinventory => p_trolin_val_rec.to_subinventory
1884: );
1885:
1886: IF l_mo_line_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
1887: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1888: END IF;
1889:
1890: END IF;
1883: p_to_subinventory => p_trolin_val_rec.to_subinventory
1884: );
1885:
1886: IF l_mo_line_rec.to_subinventory_code = FND_API.G_MISS_CHAR THEN
1887: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1888: END IF;
1889:
1890: END IF;
1891:
1890: END IF;
1891:
1892: END IF;
1893: -- Line2839
1894: IF p_trolin_val_rec.to_subinventory <> FND_API.G_MISS_CHAR
1895: THEN
1896:
1897: IF p_mo_line_rec.to_subinventory_id <> FND_API.G_MISS_NUM THEN
1898:
1893: -- Line2839
1894: IF p_trolin_val_rec.to_subinventory <> FND_API.G_MISS_CHAR
1895: THEN
1896:
1897: IF p_mo_line_rec.to_subinventory_id <> FND_API.G_MISS_NUM THEN
1898:
1899: l_mo_line_rec.to_subinventory_id := p_mo_line_rec.to_subinventory_id;
1900:
1901: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1913: ( p_organization_id => p_mo_line_rec.organization_id,
1914: p_to_subinventory => p_trolin_val_rec.to_subinventory
1915: );
1916:
1917: IF l_mo_line_rec.to_subinventory_id = FND_API.G_MISS_NUM THEN
1918: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1919: END IF;
1920:
1921: END IF;
1914: p_to_subinventory => p_trolin_val_rec.to_subinventory
1915: );
1916:
1917: IF l_mo_line_rec.to_subinventory_id = FND_API.G_MISS_NUM THEN
1918: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1919: END IF;
1920:
1921: END IF;
1922:
1921: END IF;
1922:
1923: END IF;
1924:
1925: IF p_trolin_val_rec.transaction_header <> FND_API.G_MISS_CHAR
1926: THEN
1927:
1928: IF p_mo_line_rec.transaction_header_id <> FND_API.G_MISS_NUM THEN
1929:
1924:
1925: IF p_trolin_val_rec.transaction_header <> FND_API.G_MISS_CHAR
1926: THEN
1927:
1928: IF p_mo_line_rec.transaction_header_id <> FND_API.G_MISS_NUM THEN
1929:
1930: l_mo_line_rec.transaction_header_id := p_mo_line_rec.transaction_header_id;
1931:
1932: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1943: l_mo_line_rec.transaction_header_id := INV_Value_To_Id.transaction_header
1944: ( p_transaction_header => p_trolin_val_rec.transaction_header
1945: );
1946:
1947: IF l_mo_line_rec.transaction_header_id = FND_API.G_MISS_NUM THEN
1948: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1949: END IF;
1950:
1951: END IF;
1944: ( p_transaction_header => p_trolin_val_rec.transaction_header
1945: );
1946:
1947: IF l_mo_line_rec.transaction_header_id = FND_API.G_MISS_NUM THEN
1948: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1949: END IF;
1950:
1951: END IF;
1952:
1950:
1951: END IF;
1952:
1953: END IF;
1954: IF p_trolin_val_rec.transaction_type <> FND_API.G_MISS_CHAR
1955: THEN
1956:
1957: IF p_mo_line_rec.transaction_type_id <> FND_API.G_MISS_NUM THEN
1958:
1953: END IF;
1954: IF p_trolin_val_rec.transaction_type <> FND_API.G_MISS_CHAR
1955: THEN
1956:
1957: IF p_mo_line_rec.transaction_type_id <> FND_API.G_MISS_NUM THEN
1958:
1959: l_mo_line_rec.transaction_type_id := p_mo_line_rec.transaction_type_id;
1960:
1961: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
1972: l_mo_line_rec.transaction_type_id := INV_Value_To_Id.transaction_type
1973: ( p_transaction_type => p_trolin_val_rec.transaction_type
1974: );
1975:
1976: IF l_mo_line_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
1977: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1978: END IF;
1979:
1980: END IF;
1973: ( p_transaction_type => p_trolin_val_rec.transaction_type
1974: );
1975:
1976: IF l_mo_line_rec.transaction_type_id = FND_API.G_MISS_NUM THEN
1977: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
1978: END IF;
1979:
1980: END IF;
1981:
1980: END IF;
1981:
1982: END IF;
1983: -- Line2899
1984: IF p_trolin_val_rec.uom <> FND_API.G_MISS_CHAR
1985: THEN
1986:
1987: IF p_mo_line_rec.uom_code <> FND_API.G_MISS_CHAR THEN
1988:
1983: -- Line2899
1984: IF p_trolin_val_rec.uom <> FND_API.G_MISS_CHAR
1985: THEN
1986:
1987: IF p_mo_line_rec.uom_code <> FND_API.G_MISS_CHAR THEN
1988:
1989: l_mo_line_rec.uom_code := p_mo_line_rec.uom_code;
1990:
1991: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
2002: l_mo_line_rec.uom_code := INV_Value_To_Id.uom
2003: ( p_uom => p_trolin_val_rec.uom
2004: );
2005:
2006: IF l_mo_line_rec.uom_code = FND_API.G_MISS_CHAR THEN
2007: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2008: END IF;
2009:
2010: END IF;
2003: ( p_uom => p_trolin_val_rec.uom
2004: );
2005:
2006: IF l_mo_line_rec.uom_code = FND_API.G_MISS_CHAR THEN
2007: l_mo_line_rec.return_status := FND_API.G_RET_STS_ERROR;
2008: END IF;
2009:
2010: END IF;
2011:
2035: , x_msg_data OUT NOCOPY VARCHAR2
2036: )
2037: IS
2038: l_api_version_number CONSTANT NUMBER := 1.0;
2039: l_init_msg_list VARCHAR2(255) := FND_API.G_TRUE;
2040: l_api_name CONSTANT VARCHAR2(30) := 'Line_Auto_Detail';
2041: l_detailed_qty NUMBER := 0;
2042: l_ser_index NUMBER;
2043: l_expiration_date DATE;
2109:
2110: GMI_Reservation_Util.PrintLn('(opm_dbg) Entering Line_Auto_Detail.');
2111:
2112: /* Init status : */
2113: x_return_status := FND_API.G_RET_STS_SUCCESS;
2114:
2115:
2116: IF (p_init_msg_list = 1)
2117: THEN
2136:
2137: IF ( x_return_status = '54' )
2138: THEN
2139: GMI_Reservation_Util.PrintLn('(opm_dbg) Line_Auto_Detail : the MO is locked for line_id='||p_mo_line_id);
2140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2141: END IF;
2142:
2143: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_header_id ='||l_mo_line_tbl(1).header_id||', schedule_ship_date(date_required)='||l_mo_line_tbl(1).date_required);
2144: /* Get The Move Order header */
2179: EXCEPTION
2180: WHEN no_data_found THEN
2181: fnd_message.set_name('INV', 'INV_AUTO_PICK_CONFIRM_PARAM');
2182: fnd_msg_pub.add;
2183: raise fnd_api.g_exc_unexpected_error;
2184: END;
2185: */
2186: SAVEPOINT GMI_Before_Pick_Release;
2187: /* IF ( l_auto_pick_flag = 'Y') THEN
2184: END;
2185: */
2186: SAVEPOINT GMI_Before_Pick_Release;
2187: /* IF ( l_auto_pick_flag = 'Y') THEN
2188: l_commit := FND_API.G_TRUE;
2189: ELSE
2190: */
2191: l_commit := FND_API.G_FALSE;
2192: /* END IF; */
2187: /* IF ( l_auto_pick_flag = 'Y') THEN
2188: l_commit := FND_API.G_TRUE;
2189: ELSE
2190: */
2191: l_commit := FND_API.G_FALSE;
2192: /* END IF; */
2193:
2194:
2195:
2197: GMI_Reservation_Util.PrintLn('(opm_dbg) l_p_allow_delete = ' || l_p_allow_delete) ;
2198: GMI_Reservation_Util.PrintLn('(opm_dbg) Before calling Auto_detail ='||l_mo_line_tbl(1).header_id);
2199: GMI_Pick_Release_PUB.Auto_Detail(
2200: p_api_version => 1.0,
2201: p_init_msg_lst => FND_API.G_FALSE,
2202: p_commit => l_commit,
2203: p_mo_hdr_rec => l_mo_hdr_rec,
2204: p_mo_line_tbl => l_mo_line_tbl,
2205: p_grouping_rule_id => l_mo_hdr_rec.grouping_rule_id,
2211:
2212: GMI_Reservation_Util.PrintLn('(opm_dbg) l_return_status from GMI_pick_release_pub.Auto_detail is ' || l_return_status);
2213: /* Message('l_return_status from GMI_pick_release_pub.Auto_detail is ' || l_return_status); */
2214:
2215: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2216: GMI_Reservation_Util.PrintLn('return error');
2217: /* fnd_msg_pub.count_and_get(p_count => l_count,
2218: p_data => l_message,
2219: p_encoded => 'F');
2226: end LOOP;
2227: end if;
2228: */
2229:
2230: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2231: end if;
2232:
2233: GMI_Reservation_Util.PrintLn('(opm_dbg) l_prick_release_status.count='||l_pick_release_status.count);
2234:
2236: IF ( l_pick_release_status.count > 0 ) THEN
2237: FOR l_index IN 1..l_pick_release_status.count LOOP
2238: GMI_Reservation_Util.PrintLn('(opm_dbg) detail record loop pick_return_status=' || l_pick_release_status(l_index).return_status);
2239: x_number_of_rows := x_number_of_rows + l_pick_release_status(l_index).detail_rec_count;
2240: IF (l_pick_release_status(l_index).return_status <> FND_API.G_RET_STS_SUCCESS)
2241: THEN
2242: l_return_status := l_pick_release_status(l_index).return_status;
2243: END IF;
2244: END LOOP;
2260: l_mold_tbl := INV_MO_LINE_DETAIL_UTIL.query_rows(
2261: p_line_id => l_trolin_tbl(l_index).line_id);
2262: l_mold_tbl_temp := l_mold_tbl;
2263: if( l_mold_tbl.count = 0 ) then
2264: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265: fnd_message.set_name('INV', 'INV_PICK_RELEASE_ERROR');
2266: fnd_msg_pub.add;
2267: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2268: else
2263: if( l_mold_tbl.count = 0 ) then
2264: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2265: fnd_message.set_name('INV', 'INV_PICK_RELEASE_ERROR');
2266: fnd_msg_pub.add;
2267: raise FND_API.G_EXC_UNEXPECTED_ERROR;
2268: else
2269: GMI_Reservation_Util.PrintLn('number of mold record is ' || l_mold_tbl.count);
2270: GMI_Reservation_Util.PrintLn('calling pick confirm');
2271: INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm(
2269: GMI_Reservation_Util.PrintLn('number of mold record is ' || l_mold_tbl.count);
2270: GMI_Reservation_Util.PrintLn('calling pick confirm');
2271: INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm(
2272: p_api_version_number => 1.0,
2273: p_init_msg_list => FND_API.G_FALSE,
2274: p_commit => FND_API.G_TRUE,
2275: x_return_status => l_return_status,
2276: x_msg_count => x_msg_count,
2277: x_msg_data => x_msg_data,
2270: GMI_Reservation_Util.PrintLn('calling pick confirm');
2271: INV_PICK_WAVE_PICK_CONFIRM_PUB.Pick_Confirm(
2272: p_api_version_number => 1.0,
2273: p_init_msg_list => FND_API.G_FALSE,
2274: p_commit => FND_API.G_TRUE,
2275: x_return_status => l_return_status,
2276: x_msg_count => x_msg_count,
2277: x_msg_data => x_msg_data,
2278: p_move_order_type => p_move_order_type,
2282: x_mmtt_tbl => l_mold_tbl,
2283: x_trolin_tbl => l_trolin_tbl);
2284: GMI_Reservation_Util.PrintLn('after pick confirm with return status = ' || l_return_status);
2285: GMI_Reservation_Util.PrintLn('l_return_status = ' || l_return_status);
2286: if( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
2287: l_success := 0;
2288: GMI_Reservation_Util.PrintLn('rollback changes');
2289: GMI_Reservation_Util.PrintLn('l_mold_tbl_temp.count = ' || l_mold_tbl_temp.count);
2290: for l_index in 1..l_mold_tbl_temp.count LOOP
2298: x_return_status => l_return_status,
2299: x_msg_data => x_msg_data,
2300: x_msg_count => x_msg_count);
2301: GMI_Reservation_Util.PrintLn('after detele details with return status ' || l_return_status);
2302: if( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
2303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2304: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2305: RAISE FND_API.G_EXC_ERROR;
2306: END IF;
2299: x_msg_data => x_msg_data,
2300: x_msg_count => x_msg_count);
2301: GMI_Reservation_Util.PrintLn('after detele details with return status ' || l_return_status);
2302: if( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
2303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2304: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2305: RAISE FND_API.G_EXC_ERROR;
2306: END IF;
2307: update mtl_txn_request_lines
2300: x_msg_count => x_msg_count);
2301: GMI_Reservation_Util.PrintLn('after detele details with return status ' || l_return_status);
2302: if( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
2303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2304: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2305: RAISE FND_API.G_EXC_ERROR;
2306: END IF;
2307: update mtl_txn_request_lines
2308: set quantity_detailed = quantity_detailed - l_mold_tbl_temp(l_index).transaction_quantity,
2301: GMI_Reservation_Util.PrintLn('after detele details with return status ' || l_return_status);
2302: if( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
2303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2304: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2305: RAISE FND_API.G_EXC_ERROR;
2306: END IF;
2307: update mtl_txn_request_lines
2308: set quantity_detailed = quantity_detailed - l_mold_tbl_temp(l_index).transaction_quantity,
2309: quantity_delivered = quantity_delivered - l_mold_tbl_temp(l_index).transaction_quantity
2369: where line_id = l_mo_line_tbl(1).line_id;
2370:
2371: l_success := 1;
2372: if( l_success = 1 ) then
2373: x_return_status := FND_API.G_RET_STS_SUCCESS;
2374: else
2375: raise FND_API.G_EXC_ERROR;
2376: end if;
2377:
2371: l_success := 1;
2372: if( l_success = 1 ) then
2373: x_return_status := FND_API.G_RET_STS_SUCCESS;
2374: else
2375: raise FND_API.G_EXC_ERROR;
2376: end if;
2377:
2378:
2379: EXCEPTION
2376: end if;
2377:
2378:
2379: EXCEPTION
2380: WHEN FND_API.G_EXC_ERROR THEN
2381: x_return_status := FND_API.G_RET_STS_ERROR;
2382: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2383:
2384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2377:
2378:
2379: EXCEPTION
2380: WHEN FND_API.G_EXC_ERROR THEN
2381: x_return_status := FND_API.G_RET_STS_ERROR;
2382: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2383:
2384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2385: IF (x_return_status = '54')
2380: WHEN FND_API.G_EXC_ERROR THEN
2381: x_return_status := FND_API.G_RET_STS_ERROR;
2382: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2383:
2384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2385: IF (x_return_status = '54')
2386: THEN
2387: x_return_status := '54' ;
2388: ELSE
2385: IF (x_return_status = '54')
2386: THEN
2387: x_return_status := '54' ;
2388: ELSE
2389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2390: END IF;
2391:
2392: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2393:
2417: , x_msg_data OUT NOCOPY VARCHAR2
2418: )
2419: IS
2420: l_api_version_number CONSTANT NUMBER := 1.0;
2421: l_init_msg_list VARCHAR2(255) := FND_API.G_TRUE;
2422: l_api_name CONSTANT VARCHAR2(30) := 'Line_Pick_Confirm';
2423: x_success NUMBER;
2424:
2425: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;
2441: BEGIN
2442:
2443: gmi_reservation_util.println('In line_pick_confirm and line_id is '||p_mo_line_id);
2444: /* Init status : */
2445: x_return_status := FND_API.G_RET_STS_SUCCESS;
2446:
2447: IF (p_init_msg_list = 1)
2448: THEN
2449: FND_MSG_PUB.Initialize;
2470:
2471: IF ( x_return_status = '54' )
2472: THEN
2473: GMI_Reservation_Util.PrintLn('(opm_dbg) Line_Pick_Confirm : the MO is locked for line_id='||p_mo_line_id);
2474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2475: END IF;
2476:
2477:
2478: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_header_id ='||l_mo_line_tbl(1).header_id);
2478: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_header_id ='||l_mo_line_tbl(1).header_id);
2479: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_line_tbl.COUNT ='||l_mo_line_tbl.COUNT);
2480:
2481: SAVEPOINT GMI_Before_Pick_Confirm;
2482: l_commit := FND_API.G_FALSE;
2483:
2484: GMI_Reservation_Util.PrintLn('(opm_dbg) Before calling Pick_Confirm ='||l_mo_line_tbl(1).header_id);
2485: /* NC 11/14/02 changed the call from GMI_Pick_Wave_Confirm_PUB
2486: to GMI_Pick_Wave_Confirm_PVT. enhancement # 2557029 */
2486: to GMI_Pick_Wave_Confirm_PVT. enhancement # 2557029 */
2487:
2488: GMI_Pick_Wave_Confirm_PVT.Pick_Confirm(
2489: p_api_version_number => 1.0,
2490: p_init_msg_lst => FND_API.G_FALSE,
2491: p_validation_flag => FND_API.G_VALID_LEVEL_FULL,
2492: p_commit => l_commit,
2493: p_mo_line_tbl => l_mo_line_tbl,
2494: x_mo_line_tbl => ll_mo_line_tbl,
2487:
2488: GMI_Pick_Wave_Confirm_PVT.Pick_Confirm(
2489: p_api_version_number => 1.0,
2490: p_init_msg_lst => FND_API.G_FALSE,
2491: p_validation_flag => FND_API.G_VALID_LEVEL_FULL,
2492: p_commit => l_commit,
2493: p_mo_line_tbl => l_mo_line_tbl,
2494: x_mo_line_tbl => ll_mo_line_tbl,
2495: x_return_status => l_return_status,
2500: GMI_Reservation_Util.PrintLn('(opm_dbg) l_return_status from GMI_pick_wave_Confirm_pub.Pick_Confirm is ' || l_return_status);
2501: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_line.count=' || l_mo_line_tbl.count);
2502: /* Message('l_return_status from GMI_pick_release_pub.Auto_detail is ' || l_return_status); */
2503:
2504: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
2505: THEN
2506: GMI_Reservation_Util.PrintLn('return error');
2507: FND_MESSAGE.Set_Name('GMI','PICK_CONFIRM_ERROR');
2508: FND_MESSAGE.Set_Token('WHERE', 'AFTER_CALL_PICK_CONFIRM');
2507: FND_MESSAGE.Set_Name('GMI','PICK_CONFIRM_ERROR');
2508: FND_MESSAGE.Set_Token('WHERE', 'AFTER_CALL_PICK_CONFIRM');
2509: FND_MESSAGE.Set_Token('WHAT', 'UnexpectedError');
2510: FND_MSG_PUB.Add;
2511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2512: END IF;
2513:
2514: IF ( l_mo_line_tbl.count = 0 )
2515: THEN
2517: FND_MESSAGE.Set_Name('GMI','PICK_CONFIRM_ERROR');
2518: FND_MESSAGE.Set_Token('WHERE', 'MO_LINE_COUNT_0');
2519: FND_MESSAGE.Set_Token('WHAT', 'UnexpectedError');
2520: FND_MSG_PUB.Add;
2521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2522: END IF;
2523:
2524: END IF;
2525:
2539: GMI_Reservation_Util.PrintLn('(opm_dbg) End of GMI_pick_wave_Confirm_pub.Pick_Confirm, l_return_status is ' || l_return_status);
2540:
2541:
2542: EXCEPTION
2543: WHEN FND_API.G_EXC_ERROR THEN
2544: /* ROLLBACK TO SAVEPOINT GMI_Before_Pick_Confirm; */
2545:
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2542: EXCEPTION
2543: WHEN FND_API.G_EXC_ERROR THEN
2544: /* ROLLBACK TO SAVEPOINT GMI_Before_Pick_Confirm; */
2545:
2546: x_return_status := FND_API.G_RET_STS_ERROR;
2547: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
2548:
2549: WHEN OTHERS THEN
2550: /* ROLLBACK TO SAVEPOINT GMI_Before_Pick_Confirm; */
2552: IF (x_return_status = '54')
2553: THEN
2554: x_return_status := '54' ;
2555: ELSE
2556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2557: END IF;
2558:
2559: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2560: THEN
2588:
2589: c_event_separator CONSTANT VARCHAR2(100) :=
2590: '------------------------------------------------------------------------';
2591:
2592: l_init_msg_list VARCHAR2(255) := FND_API.G_TRUE;
2593: l_detailed_qty NUMBER := 0;
2594: l_mo_line_id NUMBER;
2595: l_inv_item_id NUMBER;
2596: l_txn_source_line_id NUMBER;
2759: ORDER BY 1,2;
2760:
2761: BEGIN
2762:
2763: IF p_log_level <> FND_API.G_MISS_NUM THEN -- log level fix
2764: WSH_UTIL_CORE.Set_Log_Level(p_log_level);
2765: OE_DEBUG_PUB.DEBUG_ON;
2766: OE_DEBUG_PUB.SETDEBUGLEVEL(p_log_level);
2767: WSH_UTIL_CORE.Set_Log_Level(p_log_level);
2939: -- regardless of whether lines are fully allocated.
2940: /*
2941: IF l_qty_req = l_qty_det THEN
2942: WSH_UTIL_CORE.PRINTMSG( ' Move Order Is Fully Alocated');
2943: l_return_status := FND_API.G_RET_STS_SUCCESS;
2944: ELSE
2945: l_return_status := FND_API.G_RET_STS_SUCCESS;
2946: */
2947:
2941: IF l_qty_req = l_qty_det THEN
2942: WSH_UTIL_CORE.PRINTMSG( ' Move Order Is Fully Alocated');
2943: l_return_status := FND_API.G_RET_STS_SUCCESS;
2944: ELSE
2945: l_return_status := FND_API.G_RET_STS_SUCCESS;
2946: */
2947:
2948:
2949: GMI_Reservation_Util.PrintLn('(opm_dbg) in alloc engine b4 call to LINE_AUTO_DETAIL');
3034: l_sucess_alloc := l_sucess_alloc +1;
3035:
3036: IF G_PICK_CONFIRM = 'Y' THEN
3037:
3038: l_return_status := FND_API.G_RET_STS_SUCCESS;
3039: l_return_status := FND_API.G_RET_STS_SUCCESS;
3040:
3041: WSH_UTIL_CORE.PRINTMSG( ' START PICK CONFIRMATION');
3042: WSH_UTIL_CORE.PRINTMSG;
3035:
3036: IF G_PICK_CONFIRM = 'Y' THEN
3037:
3038: l_return_status := FND_API.G_RET_STS_SUCCESS;
3039: l_return_status := FND_API.G_RET_STS_SUCCESS;
3040:
3041: WSH_UTIL_CORE.PRINTMSG( ' START PICK CONFIRMATION');
3042: WSH_UTIL_CORE.PRINTMSG;
3043:
3300: ,l_quantity2_detailed
3301: ,l_organization_id;
3302: IF c_line_info%NOTFOUND THEN
3303: GMI_Reservation_Util.PrintLn('Error: Could not find mo line');
3304: RAISE fnd_api.g_exc_error;
3305: END IF;
3306: CLOSE c_line_info;
3307:
3308: /* if the delivery_detail is deleted in shipping, all the rsv with it should be deleted */
3348: -- if so, simply delete the rsv , will balance default later
3349: GMI_Reservation_Util.PrintLn('set delete trans' );
3350: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3351: ( 1
3352: , FND_API.G_FALSE
3353: , FND_API.G_FALSE
3354: , FND_API.G_VALID_LEVEL_FULL
3355: , l_trans_rec
3356: , l_trans_row
3349: GMI_Reservation_Util.PrintLn('set delete trans' );
3350: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3351: ( 1
3352: , FND_API.G_FALSE
3353: , FND_API.G_FALSE
3354: , FND_API.G_VALID_LEVEL_FULL
3355: , l_trans_rec
3356: , l_trans_row
3357: , x_return_status
3350: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3351: ( 1
3352: , FND_API.G_FALSE
3353: , FND_API.G_FALSE
3354: , FND_API.G_VALID_LEVEL_FULL
3355: , l_trans_rec
3356: , l_trans_row
3357: , x_return_status
3358: , x_msg_count
3357: , x_return_status
3358: , x_msg_count
3359: , x_msg_data
3360: );
3361: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3362: THEN
3363: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
3364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3365: END IF;
3360: );
3361: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3362: THEN
3363: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
3364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3365: END IF;
3366: l_deleted_quantity := l_deleted_quantity + abs(l_trans_rec.trans_qty);
3367: l_deleted_quantity2 := l_deleted_quantity2 + abs(l_trans_rec.trans_qty2);
3368: ELSE
3370: l_trans_rec.trans_qty := -1 * (abs(l_trans_rec.trans_qty) - l_quantity_to_delete);
3371: l_trans_rec.trans_qty2 := -1 * (abs(l_trans_rec.trans_qty2) - l_quantity2_to_delete);
3372: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
3373: ( 1
3374: , FND_API.G_FALSE
3375: , FND_API.G_FALSE
3376: , FND_API.G_VALID_LEVEL_FULL
3377: , l_trans_rec
3378: , l_trans_row
3371: l_trans_rec.trans_qty2 := -1 * (abs(l_trans_rec.trans_qty2) - l_quantity2_to_delete);
3372: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
3373: ( 1
3374: , FND_API.G_FALSE
3375: , FND_API.G_FALSE
3376: , FND_API.G_VALID_LEVEL_FULL
3377: , l_trans_rec
3378: , l_trans_row
3379: , x_return_status
3372: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
3373: ( 1
3374: , FND_API.G_FALSE
3375: , FND_API.G_FALSE
3376: , FND_API.G_VALID_LEVEL_FULL
3377: , l_trans_rec
3378: , l_trans_row
3379: , x_return_status
3380: , x_msg_count
3379: , x_return_status
3380: , x_msg_count
3381: , x_msg_data
3382: );
3383: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3384: THEN
3385: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3387: END IF;
3382: );
3383: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3384: THEN
3385: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
3386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3387: END IF;
3388:
3389: l_deleted_quantity := l_deleted_quantity + l_quantity_to_delete;
3390: l_deleted_quantity2 := l_deleted_quantity2 + l_quantity2_to_delete;
3426: , x_return_status => x_return_status
3427: , x_msg_count => x_msg_count
3428: , x_msg_data => x_msg_data
3429: );
3430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3431: THEN
3432: GMI_RESERVATION_UTIL.PrintLn('cancle move order Error returned by balancing default lot');
3433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3434: END IF;
3429: );
3430: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3431: THEN
3432: GMI_RESERVATION_UTIL.PrintLn('cancle move order Error returned by balancing default lot');
3433: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3434: END IF;
3435: ELSE
3436: /* delete this default lot, and created a new one */
3437: GMI_Reservation_Util.PrintLn('delete trans trans_id'||l_trans_rec.trans_id);
3436: /* delete this default lot, and created a new one */
3437: GMI_Reservation_Util.PrintLn('delete trans trans_id'||l_trans_rec.trans_id);
3438: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3439: ( 1
3440: , FND_API.G_FALSE
3441: , FND_API.G_FALSE
3442: , FND_API.G_VALID_LEVEL_FULL
3443: , l_trans_rec
3444: , l_trans_row
3437: GMI_Reservation_Util.PrintLn('delete trans trans_id'||l_trans_rec.trans_id);
3438: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3439: ( 1
3440: , FND_API.G_FALSE
3441: , FND_API.G_FALSE
3442: , FND_API.G_VALID_LEVEL_FULL
3443: , l_trans_rec
3444: , l_trans_row
3445: , x_return_status
3438: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3439: ( 1
3440: , FND_API.G_FALSE
3441: , FND_API.G_FALSE
3442: , FND_API.G_VALID_LEVEL_FULL
3443: , l_trans_rec
3444: , l_trans_row
3445: , x_return_status
3446: , x_msg_count
3446: , x_msg_count
3447: , x_msg_data
3448: );
3449:
3450: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3451: THEN
3452: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
3453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3454: END IF;
3449:
3450: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3451: THEN
3452: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
3453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3454: END IF;
3455:
3456: Select whse_code
3457: Into l_trans_rec.whse_code
3460: and rownum = 1; -- just in case, should only have 1 row
3461:
3462: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3463: ( 1
3464: , FND_API.G_FALSE
3465: , FND_API.G_FALSE
3466: , FND_API.G_VALID_LEVEL_FULL
3467: , l_trans_rec
3468: , l_trans_row
3461:
3462: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3463: ( 1
3464: , FND_API.G_FALSE
3465: , FND_API.G_FALSE
3466: , FND_API.G_VALID_LEVEL_FULL
3467: , l_trans_rec
3468: , l_trans_row
3469: , x_return_status
3462: GMI_TRANS_ENGINE_PUB.CREATE_PENDING_TRANSACTION
3463: ( 1
3464: , FND_API.G_FALSE
3465: , FND_API.G_FALSE
3466: , FND_API.G_VALID_LEVEL_FULL
3467: , l_trans_rec
3468: , l_trans_row
3469: , x_return_status
3470: , x_msg_count
3470: , x_msg_count
3471: , x_msg_data
3472: );
3473:
3474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3475: THEN
3476: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
3477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3478: END IF;
3473:
3474: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3475: THEN
3476: GMI_RESERVATION_UTIL.println('Error returned by Create_Pending_Transaction');
3477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3478: END IF;
3479: l_trans_rec.trans_id := l_trans_row.trans_id;
3480: GMI_Reservation_Util.PrintLn('created trans trans_id'||l_trans_rec.trans_id);
3481: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
3487: , x_return_status => x_return_status
3488: , x_msg_count => x_msg_count
3489: , x_msg_data => x_msg_data
3490: );
3491: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3492: THEN
3493: GMI_RESERVATION_UTIL.PrintLn('cancle move order Error returned by balancing default lot');
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: END IF;
3490: );
3491: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3492: THEN
3493: GMI_RESERVATION_UTIL.PrintLn('cancle move order Error returned by balancing default lot');
3494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3495: END IF;
3496: END IF;
3497: END IF;
3498: END IF;
3536: ,secondary_quantity = l_quantity2
3537: ,line_status = l_line_status
3538: WHERE line_id = p_line_id;
3539:
3540: x_return_status := fnd_api.g_ret_sts_success;
3541: GMI_Reservation_Util.PrintLn('Return status = ' || x_return_status);
3542:
3543:
3544:
3542:
3543:
3544:
3545: EXCEPTION
3546: WHEN fnd_api.g_exc_error THEN
3547: ROLLBACK TO CANCELMO_SP;
3548: x_return_status := fnd_api.g_ret_sts_error;
3549: GMI_Reservation_Util.PrintLn('Return status = ' || x_return_status);
3550: WHEN fnd_api.g_exc_unexpected_error THEN
3544:
3545: EXCEPTION
3546: WHEN fnd_api.g_exc_error THEN
3547: ROLLBACK TO CANCELMO_SP;
3548: x_return_status := fnd_api.g_ret_sts_error;
3549: GMI_Reservation_Util.PrintLn('Return status = ' || x_return_status);
3550: WHEN fnd_api.g_exc_unexpected_error THEN
3551: ROLLBACK TO CANCELMO_SP;
3552: x_return_status := fnd_api.g_ret_sts_unexp_error;
3546: WHEN fnd_api.g_exc_error THEN
3547: ROLLBACK TO CANCELMO_SP;
3548: x_return_status := fnd_api.g_ret_sts_error;
3549: GMI_Reservation_Util.PrintLn('Return status = ' || x_return_status);
3550: WHEN fnd_api.g_exc_unexpected_error THEN
3551: ROLLBACK TO CANCELMO_SP;
3552: x_return_status := fnd_api.g_ret_sts_unexp_error;
3553: GMI_Reservation_Util.PrintLn('Return status = ' || x_return_status);
3554: WHEN OTHERS THEN
3548: x_return_status := fnd_api.g_ret_sts_error;
3549: GMI_Reservation_Util.PrintLn('Return status = ' || x_return_status);
3550: WHEN fnd_api.g_exc_unexpected_error THEN
3551: ROLLBACK TO CANCELMO_SP;
3552: x_return_status := fnd_api.g_ret_sts_unexp_error;
3553: GMI_Reservation_Util.PrintLn('Return status = ' || x_return_status);
3554: WHEN OTHERS THEN
3555: ROLLBACK TO CANCELMO_SP;
3556: x_return_status := fnd_api.g_ret_sts_unexp_error;
3552: x_return_status := fnd_api.g_ret_sts_unexp_error;
3553: GMI_Reservation_Util.PrintLn('Return status = ' || x_return_status);
3554: WHEN OTHERS THEN
3555: ROLLBACK TO CANCELMO_SP;
3556: x_return_status := fnd_api.g_ret_sts_unexp_error;
3557: GMI_Reservation_Util.PrintLn('Other error in Cancel_Move_Order_line');
3558: GMI_Reservation_Util.PrintLn('Error Code = ' || SQLCODE);
3559: GMI_Reservation_Util.PrintLn('Error Msg:' || SQLERRM);
3560: GMI_Reservation_Util.PrintLn('Return status = ' || x_return_status);
3709: ,l_mo_uom_code;
3710: IF c_line_info%NOTFOUND THEN
3711: GMI_Reservation_Util.PrintLn('Move order line not found');
3712:
3713: RAISE fnd_api.g_exc_error;
3714: END IF;
3715:
3716: CLOSE c_line_info;
3717:
3737: ,p_delivery_detail_id => p_delivery_detail_id
3738: ,p_delete_reservations => 'Y'
3739: ,p_txn_source_line_id => p_txn_source_line_id);
3740:
3741: IF l_return_status = fnd_api.g_ret_sts_error Then
3742: gmi_reservation_util.println('Error coming back from cancel_move order in reduce_move_qty');
3743: RAISE fnd_api.g_exc_error;
3744: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error Then
3745: gmi_reservation_util.println('Error coming back from cancel_move but this is different');
3739: ,p_txn_source_line_id => p_txn_source_line_id);
3740:
3741: IF l_return_status = fnd_api.g_ret_sts_error Then
3742: gmi_reservation_util.println('Error coming back from cancel_move order in reduce_move_qty');
3743: RAISE fnd_api.g_exc_error;
3744: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error Then
3745: gmi_reservation_util.println('Error coming back from cancel_move but this is different');
3746: RAISE fnd_api.g_exc_unexpected_error;
3747: END IF;
3740:
3741: IF l_return_status = fnd_api.g_ret_sts_error Then
3742: gmi_reservation_util.println('Error coming back from cancel_move order in reduce_move_qty');
3743: RAISE fnd_api.g_exc_error;
3744: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error Then
3745: gmi_reservation_util.println('Error coming back from cancel_move but this is different');
3746: RAISE fnd_api.g_exc_unexpected_error;
3747: END IF;
3748: END IF;
3742: gmi_reservation_util.println('Error coming back from cancel_move order in reduce_move_qty');
3743: RAISE fnd_api.g_exc_error;
3744: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error Then
3745: gmi_reservation_util.println('Error coming back from cancel_move but this is different');
3746: RAISE fnd_api.g_exc_unexpected_error;
3747: END IF;
3748: END IF;
3749:
3750: /* need to delete or reduce some of the inv transactions*/
3801: -- if so, simply delete the rsv , will balance default later
3802: gmi_reservation_util.println('Going to delete tran in reduceMove');
3803: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3804: ( 1
3805: , FND_API.G_FALSE
3806: , FND_API.G_FALSE
3807: , FND_API.G_VALID_LEVEL_FULL
3808: , l_trans_rec
3809: , l_trans_row
3802: gmi_reservation_util.println('Going to delete tran in reduceMove');
3803: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3804: ( 1
3805: , FND_API.G_FALSE
3806: , FND_API.G_FALSE
3807: , FND_API.G_VALID_LEVEL_FULL
3808: , l_trans_rec
3809: , l_trans_row
3810: , x_return_status
3803: GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION
3804: ( 1
3805: , FND_API.G_FALSE
3806: , FND_API.G_FALSE
3807: , FND_API.G_VALID_LEVEL_FULL
3808: , l_trans_rec
3809: , l_trans_row
3810: , x_return_status
3811: , x_msg_count
3810: , x_return_status
3811: , x_msg_count
3812: , x_msg_data
3813: );
3814: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3815: THEN
3816: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
3817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3818: END IF;
3813: );
3814: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3815: THEN
3816: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
3817: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3818: END IF;
3819: l_deleted_quantity := l_deleted_quantity + abs(l_trans_rec.trans_qty);
3820: l_deleted_quantity2:= l_deleted_quantity2 + abs(l_trans_rec.trans_qty2);
3821: ELSE
3823: l_trans_rec.trans_qty := -1 * (abs(l_trans_rec.trans_qty) - l_quantity_to_delete);
3824: l_trans_rec.trans_qty2:= -1 * (abs(l_trans_rec.trans_qty2) - l_quantity2_to_delete);
3825: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
3826: ( 1
3827: , FND_API.G_FALSE
3828: , FND_API.G_FALSE
3829: , FND_API.G_VALID_LEVEL_FULL
3830: , l_trans_rec
3831: , l_trans_row
3824: l_trans_rec.trans_qty2:= -1 * (abs(l_trans_rec.trans_qty2) - l_quantity2_to_delete);
3825: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
3826: ( 1
3827: , FND_API.G_FALSE
3828: , FND_API.G_FALSE
3829: , FND_API.G_VALID_LEVEL_FULL
3830: , l_trans_rec
3831: , l_trans_row
3832: , x_return_status
3825: GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION
3826: ( 1
3827: , FND_API.G_FALSE
3828: , FND_API.G_FALSE
3829: , FND_API.G_VALID_LEVEL_FULL
3830: , l_trans_rec
3831: , l_trans_row
3832: , x_return_status
3833: , x_msg_count
3832: , x_return_status
3833: , x_msg_count
3834: , x_msg_data
3835: );
3836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3837: THEN
3838: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
3839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3840: END IF;
3835: );
3836: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3837: THEN
3838: GMI_RESERVATION_UTIL.println('Error returned by Update_Pending_Transaction');
3839: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3840: END IF;
3841: l_deleted_quantity := l_deleted_quantity + l_quantity_to_delete;
3842: l_deleted_quantity2 := l_deleted_quantity2 + l_quantity2_to_delete;
3843: END IF;
3866: , x_return_status => x_return_status
3867: , x_msg_count => x_msg_count
3868: , x_msg_data => x_msg_data
3869: );
3870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3871: THEN
3872: GMI_RESERVATION_UTIL.PrintLn('cancle move order Error returned by balancing default lot');
3873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3874: END IF;
3869: );
3870: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3871: THEN
3872: GMI_RESERVATION_UTIL.PrintLn('cancle move order Error returned by balancing default lot');
3873: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3874: END IF;
3875: END IF;
3876: END IF;
3877: END IF;
3890: , quantity_detailed = quantity_detailed - l_deleted_quantity
3891: , secondary_quantity_detailed = secondary_quantity_detailed - l_deleted_quantity2
3892: WHERE line_id = p_line_id;
3893:
3894: x_return_status := fnd_api.g_ret_sts_success;
3895:
3896: EXCEPTION
3897: WHEN fnd_api.g_exc_error THEN
3898: --ROLLBACK TO REDUCEMO_SP;
3893:
3894: x_return_status := fnd_api.g_ret_sts_success;
3895:
3896: EXCEPTION
3897: WHEN fnd_api.g_exc_error THEN
3898: --ROLLBACK TO REDUCEMO_SP;
3899: x_return_status := fnd_api.g_ret_sts_error;
3900: WHEN OTHERS THEN
3901: --ROLLBACK TO REDUCEMO_SP;
3895:
3896: EXCEPTION
3897: WHEN fnd_api.g_exc_error THEN
3898: --ROLLBACK TO REDUCEMO_SP;
3899: x_return_status := fnd_api.g_ret_sts_error;
3900: WHEN OTHERS THEN
3901: --ROLLBACK TO REDUCEMO_SP;
3902: GMI_Reservation_Util.PrintLn('Others error' || Sqlerrm);
3903: x_return_status := fnd_api.g_ret_sts_unexp_error;
3899: x_return_status := fnd_api.g_ret_sts_error;
3900: WHEN OTHERS THEN
3901: --ROLLBACK TO REDUCEMO_SP;
3902: GMI_Reservation_Util.PrintLn('Others error' || Sqlerrm);
3903: x_return_status := fnd_api.g_ret_sts_unexp_error;
3904: END Reduce_Move_Order_Quantity;
3905:
3906: --Update_Txn_Source_Line
3907: --