158: x_ret_status := FND_API.G_RET_STS_ERROR;
159:
160: fnd_message.set_name('FLM', 'FLM_ATTRIBUTE_INVALID');
161: fnd_message.set_token('ATTRIBUTE', 'Receipt Quantity');
162: x_err_msg := x_err_msg || fnd_message.get || FND_CONST.NEWLINE;
163:
164: END IF;
165:
166:
169:
170: x_ret_status := FND_API.G_RET_STS_ERROR;
171:
172: fnd_message.set_name('FLM', 'FLM_INVALID_CARD_STATUS');
173: x_err_msg := x_err_msg || fnd_message.get || FND_CONST.NEWLINE;
174:
175: END IF;
176:
177: -- Validate source type for supplier / inter org
179:
180: x_ret_status := FND_API.G_RET_STS_ERROR;
181:
182: fnd_message.set_name('FLM', 'FLM_RCV_SRC_TYPE_ERR');
183: x_err_msg := x_err_msg || fnd_message.get || FND_CONST.NEWLINE;
184:
185: END IF;
186:
187: -- Validate supply status for In Process
189:
190: x_ret_status := FND_API.G_RET_STS_ERROR;
191:
192: fnd_message.set_name('FLM', 'FLM_INVALID_KANBAN_STATUS');
193: x_err_msg := x_err_msg || fnd_message.get || FND_CONST.NEWLINE;
194:
195: RETURN;
196:
197: END IF;
205:
206: x_ret_status := FND_API.G_RET_STS_ERROR;
207:
208: fnd_message.set_name('FLM', 'FLM_EKB_LOT_SERIAL_ERR');
209: x_err_msg := x_err_msg || fnd_message.get || FND_CONST.NEWLINE;
210:
211: END IF;
212:
213:
221:
222: x_ret_status := FND_API.G_RET_STS_ERROR;
223:
224: fnd_message.set_name ('FLM', 'FLM_EKB_PO_NOT_EXISTS');
225: x_err_msg := x_err_msg || fnd_message.get || FND_CONST.NEWLINE;
226:
227: ELSE
228:
229: -- Check for Approved PO
231:
232: x_ret_status := FND_API.G_RET_STS_ERROR;
233:
234: fnd_message.set_name('FLM', 'FLM_EKB_APPROVED_PO');
235: x_err_msg := x_err_msg || fnd_message.get || FND_CONST.NEWLINE;
236:
237: END IF;
238:
239: l_receivable_quantity := l_po_details_rec.quantity_ordered
253:
254: x_ret_status := FND_API.G_RET_STS_ERROR;
255:
256: fnd_message.set_name('FLM', 'FLM_EKB_SHIP_NOT_EXISTS');
257: x_err_msg := x_err_msg || fnd_message.get || FND_CONST.NEWLINE;
258:
259: ELSE
260:
261: l_receivable_quantity := l_ship_totals_rec.quantity_shipped - l_ship_totals_rec.quantity_received;
269:
270: x_ret_status := FND_API.G_RET_STS_ERROR;
271:
272: fnd_message.set_name('FLM', 'FLM_RECEIVE_QTY_ERR');
273: x_err_msg := x_err_msg || fnd_message.get || FND_CONST.NEWLINE;
274:
275: END IF;
276:
277:
396: );
397:
398: l_str := l_val1;
399:
400: IF (l_val2 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val2; END IF;
401: IF (l_val3 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val3; END IF;
402: IF (l_val4 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val4; END IF;
403: IF (l_val5 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val5; END IF;
404: IF (l_val6 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val6; END IF;
397:
398: l_str := l_val1;
399:
400: IF (l_val2 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val2; END IF;
401: IF (l_val3 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val3; END IF;
402: IF (l_val4 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val4; END IF;
403: IF (l_val5 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val5; END IF;
404: IF (l_val6 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val6; END IF;
405: IF (l_val7 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val7; END IF;
398: l_str := l_val1;
399:
400: IF (l_val2 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val2; END IF;
401: IF (l_val3 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val3; END IF;
402: IF (l_val4 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val4; END IF;
403: IF (l_val5 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val5; END IF;
404: IF (l_val6 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val6; END IF;
405: IF (l_val7 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val7; END IF;
406: IF (l_val8 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val8; END IF;
399:
400: IF (l_val2 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val2; END IF;
401: IF (l_val3 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val3; END IF;
402: IF (l_val4 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val4; END IF;
403: IF (l_val5 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val5; END IF;
404: IF (l_val6 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val6; END IF;
405: IF (l_val7 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val7; END IF;
406: IF (l_val8 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val8; END IF;
407: IF (l_val9 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val9; END IF;
400: IF (l_val2 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val2; END IF;
401: IF (l_val3 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val3; END IF;
402: IF (l_val4 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val4; END IF;
403: IF (l_val5 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val5; END IF;
404: IF (l_val6 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val6; END IF;
405: IF (l_val7 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val7; END IF;
406: IF (l_val8 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val8; END IF;
407: IF (l_val9 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val9; END IF;
408: IF (l_val10 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val10; END IF;
401: IF (l_val3 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val3; END IF;
402: IF (l_val4 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val4; END IF;
403: IF (l_val5 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val5; END IF;
404: IF (l_val6 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val6; END IF;
405: IF (l_val7 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val7; END IF;
406: IF (l_val8 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val8; END IF;
407: IF (l_val9 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val9; END IF;
408: IF (l_val10 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val10; END IF;
409: IF (l_val11 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val11; END IF;
402: IF (l_val4 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val4; END IF;
403: IF (l_val5 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val5; END IF;
404: IF (l_val6 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val6; END IF;
405: IF (l_val7 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val7; END IF;
406: IF (l_val8 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val8; END IF;
407: IF (l_val9 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val9; END IF;
408: IF (l_val10 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val10; END IF;
409: IF (l_val11 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val11; END IF;
410: IF (l_val12 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val12; END IF;
403: IF (l_val5 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val5; END IF;
404: IF (l_val6 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val6; END IF;
405: IF (l_val7 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val7; END IF;
406: IF (l_val8 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val8; END IF;
407: IF (l_val9 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val9; END IF;
408: IF (l_val10 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val10; END IF;
409: IF (l_val11 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val11; END IF;
410: IF (l_val12 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val12; END IF;
411: IF (l_val13 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val13; END IF;
404: IF (l_val6 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val6; END IF;
405: IF (l_val7 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val7; END IF;
406: IF (l_val8 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val8; END IF;
407: IF (l_val9 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val9; END IF;
408: IF (l_val10 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val10; END IF;
409: IF (l_val11 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val11; END IF;
410: IF (l_val12 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val12; END IF;
411: IF (l_val13 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val13; END IF;
412: IF (l_val14 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val14; END IF;
405: IF (l_val7 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val7; END IF;
406: IF (l_val8 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val8; END IF;
407: IF (l_val9 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val9; END IF;
408: IF (l_val10 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val10; END IF;
409: IF (l_val11 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val11; END IF;
410: IF (l_val12 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val12; END IF;
411: IF (l_val13 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val13; END IF;
412: IF (l_val14 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val14; END IF;
413: IF (l_val15 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val15; END IF;
406: IF (l_val8 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val8; END IF;
407: IF (l_val9 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val9; END IF;
408: IF (l_val10 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val10; END IF;
409: IF (l_val11 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val11; END IF;
410: IF (l_val12 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val12; END IF;
411: IF (l_val13 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val13; END IF;
412: IF (l_val14 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val14; END IF;
413: IF (l_val15 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val15; END IF;
414: IF (l_val16 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val16; END IF;
407: IF (l_val9 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val9; END IF;
408: IF (l_val10 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val10; END IF;
409: IF (l_val11 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val11; END IF;
410: IF (l_val12 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val12; END IF;
411: IF (l_val13 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val13; END IF;
412: IF (l_val14 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val14; END IF;
413: IF (l_val15 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val15; END IF;
414: IF (l_val16 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val16; END IF;
415: IF (l_val17 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val17; END IF;
408: IF (l_val10 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val10; END IF;
409: IF (l_val11 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val11; END IF;
410: IF (l_val12 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val12; END IF;
411: IF (l_val13 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val13; END IF;
412: IF (l_val14 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val14; END IF;
413: IF (l_val15 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val15; END IF;
414: IF (l_val16 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val16; END IF;
415: IF (l_val17 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val17; END IF;
416: IF (l_val18 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val18; END IF;
409: IF (l_val11 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val11; END IF;
410: IF (l_val12 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val12; END IF;
411: IF (l_val13 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val13; END IF;
412: IF (l_val14 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val14; END IF;
413: IF (l_val15 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val15; END IF;
414: IF (l_val16 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val16; END IF;
415: IF (l_val17 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val17; END IF;
416: IF (l_val18 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val18; END IF;
417: IF (l_val19 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val19; END IF;
410: IF (l_val12 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val12; END IF;
411: IF (l_val13 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val13; END IF;
412: IF (l_val14 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val14; END IF;
413: IF (l_val15 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val15; END IF;
414: IF (l_val16 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val16; END IF;
415: IF (l_val17 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val17; END IF;
416: IF (l_val18 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val18; END IF;
417: IF (l_val19 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val19; END IF;
418: IF (l_val20 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val20; END IF;
411: IF (l_val13 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val13; END IF;
412: IF (l_val14 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val14; END IF;
413: IF (l_val15 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val15; END IF;
414: IF (l_val16 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val16; END IF;
415: IF (l_val17 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val17; END IF;
416: IF (l_val18 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val18; END IF;
417: IF (l_val19 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val19; END IF;
418: IF (l_val20 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val20; END IF;
419:
412: IF (l_val14 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val14; END IF;
413: IF (l_val15 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val15; END IF;
414: IF (l_val16 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val16; END IF;
415: IF (l_val17 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val17; END IF;
416: IF (l_val18 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val18; END IF;
417: IF (l_val19 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val19; END IF;
418: IF (l_val20 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val20; END IF;
419:
420: x_err_msg := l_str;
413: IF (l_val15 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val15; END IF;
414: IF (l_val16 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val16; END IF;
415: IF (l_val17 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val17; END IF;
416: IF (l_val18 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val18; END IF;
417: IF (l_val19 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val19; END IF;
418: IF (l_val20 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val20; END IF;
419:
420: x_err_msg := l_str;
421:
414: IF (l_val16 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val16; END IF;
415: IF (l_val17 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val17; END IF;
416: IF (l_val18 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val18; END IF;
417: IF (l_val19 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val19; END IF;
418: IF (l_val20 IS NOT NULL) THEN l_str := l_str || FND_CONST.NEWLINE || l_val20; END IF;
419:
420: x_err_msg := l_str;
421:
422: l_delete_rows := TRUE;