[Home] [Help]
330: loop
331: fetch l_ParentQtyNull_csr into l_error_ln;
332: exit when l_ParentQtyNull_csr%NOTFOUND;
333: --Line LINE_NUM is invalid because both parent license plate number and quantity are empty
334: fnd_message.set_name('POS','POS_EXASN_PLPNQTYNULL');
335: fnd_message.set_token('LINE_NUM',l_error_ln);
336: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
337: raise l_25errors;
338: end if;
331: fetch l_ParentQtyNull_csr into l_error_ln;
332: exit when l_ParentQtyNull_csr%NOTFOUND;
333: --Line LINE_NUM is invalid because both parent license plate number and quantity are empty
334: fnd_message.set_name('POS','POS_EXASN_PLPNQTYNULL');
335: fnd_message.set_token('LINE_NUM',l_error_ln);
336: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
337: raise l_25errors;
338: end if;
339: end loop;
332: exit when l_ParentQtyNull_csr%NOTFOUND;
333: --Line LINE_NUM is invalid because both parent license plate number and quantity are empty
334: fnd_message.set_name('POS','POS_EXASN_PLPNQTYNULL');
335: fnd_message.set_token('LINE_NUM',l_error_ln);
336: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
337: raise l_25errors;
338: end if;
339: end loop;
340: close l_ParentQtyNull_csr;
343: loop
344: fetch l_LineVsLotQty_csr into l_error_ln;
345: exit when l_LineVsLotQty_csr%NOTFOUND;
346: --Total lot quantity is not equal to the shipment quantity at line LINE_NUM
347: fnd_message.set_name('POS','POS_EXASN_LOT_NE_LN');
348: fnd_message.set_token('LINE_NUM',l_error_ln);
349: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
350: raise l_25errors;
351: end if;
344: fetch l_LineVsLotQty_csr into l_error_ln;
345: exit when l_LineVsLotQty_csr%NOTFOUND;
346: --Total lot quantity is not equal to the shipment quantity at line LINE_NUM
347: fnd_message.set_name('POS','POS_EXASN_LOT_NE_LN');
348: fnd_message.set_token('LINE_NUM',l_error_ln);
349: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
350: raise l_25errors;
351: end if;
352: end loop;
345: exit when l_LineVsLotQty_csr%NOTFOUND;
346: --Total lot quantity is not equal to the shipment quantity at line LINE_NUM
347: fnd_message.set_name('POS','POS_EXASN_LOT_NE_LN');
348: fnd_message.set_token('LINE_NUM',l_error_ln);
349: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
350: raise l_25errors;
351: end if;
352: end loop;
353: close l_LineVsLotQty_csr;
357: loop
358: fetch l_lineVsSerialQty_csr into l_error_ln;
359: exit when l_lineVsSerialQty_csr%NOTFOUND;
360: --Total serial quantity is not equal to the shipment quantity at line LINE_NUM
361: fnd_message.set_name('POS','POS_EXASN_SER_NE_LN');
362: fnd_message.set_token('LINE_NUM',l_error_ln);
363: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
364: raise l_25errors;
365: end if;
358: fetch l_lineVsSerialQty_csr into l_error_ln;
359: exit when l_lineVsSerialQty_csr%NOTFOUND;
360: --Total serial quantity is not equal to the shipment quantity at line LINE_NUM
361: fnd_message.set_name('POS','POS_EXASN_SER_NE_LN');
362: fnd_message.set_token('LINE_NUM',l_error_ln);
363: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
364: raise l_25errors;
365: end if;
366: end loop;
359: exit when l_lineVsSerialQty_csr%NOTFOUND;
360: --Total serial quantity is not equal to the shipment quantity at line LINE_NUM
361: fnd_message.set_name('POS','POS_EXASN_SER_NE_LN');
362: fnd_message.set_token('LINE_NUM',l_error_ln);
363: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
364: raise l_25errors;
365: end if;
366: end loop;
367: close l_lineVsSerialQty_csr;
370: loop
371: fetch l_lineVsLpnQty_csr into l_error_ln;
372: exit when l_lineVsLpnQty_csr%NOTFOUND;
373: --Total license plate number quantity is not equal to the shipment quantity at line LINE_NUM
374: fnd_message.set_name('POS','POS_EXASN_LPN_NE_LN');
375: fnd_message.set_token('LINE_NUM',l_error_ln);
376: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
377: raise l_25errors;
378: end if;
371: fetch l_lineVsLpnQty_csr into l_error_ln;
372: exit when l_lineVsLpnQty_csr%NOTFOUND;
373: --Total license plate number quantity is not equal to the shipment quantity at line LINE_NUM
374: fnd_message.set_name('POS','POS_EXASN_LPN_NE_LN');
375: fnd_message.set_token('LINE_NUM',l_error_ln);
376: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
377: raise l_25errors;
378: end if;
379:
372: exit when l_lineVsLpnQty_csr%NOTFOUND;
373: --Total license plate number quantity is not equal to the shipment quantity at line LINE_NUM
374: fnd_message.set_name('POS','POS_EXASN_LPN_NE_LN');
375: fnd_message.set_token('LINE_NUM',l_error_ln);
376: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
377: raise l_25errors;
378: end if;
379:
380: end loop;
384: loop
385: fetch l_LotVsSerialQty_csr into l_error_ln;
386: exit when l_LotVsSerialQty_csr%NOTFOUND;
387: --Total serial quantity is not equal to the lot quanttiy at line LINE_NUM
388: fnd_message.set_name('POS','POS_EXASN_SER_NE_LOT');
389: fnd_message.set_token('LINE_NUM',l_error_ln);
390: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
391: raise l_25errors;
392: end if;
385: fetch l_LotVsSerialQty_csr into l_error_ln;
386: exit when l_LotVsSerialQty_csr%NOTFOUND;
387: --Total serial quantity is not equal to the lot quanttiy at line LINE_NUM
388: fnd_message.set_name('POS','POS_EXASN_SER_NE_LOT');
389: fnd_message.set_token('LINE_NUM',l_error_ln);
390: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
391: raise l_25errors;
392: end if;
393: end loop;
386: exit when l_LotVsSerialQty_csr%NOTFOUND;
387: --Total serial quantity is not equal to the lot quanttiy at line LINE_NUM
388: fnd_message.set_name('POS','POS_EXASN_SER_NE_LOT');
389: fnd_message.set_token('LINE_NUM',l_error_ln);
390: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
391: raise l_25errors;
392: end if;
393: end loop;
394: close l_LotVsSerialQty_csr;
581: if(l_lot_status= FND_API.G_RET_STS_SUCCESS AND l_lot_return_code= 'F')
582: then
583:
584: --Lot LOT at line LINE_NUM is invalid: ERROR_MSG
585: fnd_message.set_name('POS','POS_EXASN_INVALID_LOT');
586: fnd_message.set_token('LOT',l_lot_number);
587: fnd_message.set_token('LINE_NUM',l_lot_ln);
588: fnd_message.set_token('ERROR_MSG',l_lot_return_msg);
589: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
582: then
583:
584: --Lot LOT at line LINE_NUM is invalid: ERROR_MSG
585: fnd_message.set_name('POS','POS_EXASN_INVALID_LOT');
586: fnd_message.set_token('LOT',l_lot_number);
587: fnd_message.set_token('LINE_NUM',l_lot_ln);
588: fnd_message.set_token('ERROR_MSG',l_lot_return_msg);
589: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
590: raise l_25errors;
583:
584: --Lot LOT at line LINE_NUM is invalid: ERROR_MSG
585: fnd_message.set_name('POS','POS_EXASN_INVALID_LOT');
586: fnd_message.set_token('LOT',l_lot_number);
587: fnd_message.set_token('LINE_NUM',l_lot_ln);
588: fnd_message.set_token('ERROR_MSG',l_lot_return_msg);
589: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
590: raise l_25errors;
591: end if;
584: --Lot LOT at line LINE_NUM is invalid: ERROR_MSG
585: fnd_message.set_name('POS','POS_EXASN_INVALID_LOT');
586: fnd_message.set_token('LOT',l_lot_number);
587: fnd_message.set_token('LINE_NUM',l_lot_ln);
588: fnd_message.set_token('ERROR_MSG',l_lot_return_msg);
589: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
590: raise l_25errors;
591: end if;
592: elsif(l_lot_status <> FND_API.G_RET_STS_SUCCESS) then
585: fnd_message.set_name('POS','POS_EXASN_INVALID_LOT');
586: fnd_message.set_token('LOT',l_lot_number);
587: fnd_message.set_token('LINE_NUM',l_lot_ln);
588: fnd_message.set_token('ERROR_MSG',l_lot_return_msg);
589: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
590: raise l_25errors;
591: end if;
592: elsif(l_lot_status <> FND_API.G_RET_STS_SUCCESS) then
593: if(InsertError(x_error_tbl, 'Unexpected error when validating Lot Number at line: '||l_lot_ln||':'||l_lot_return_msg, x_error_pointer)=1) then
607:
608: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')
609: then
610: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
611: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
612: fnd_message.set_token('LPN',l_lpn);
613: fnd_message.set_token('LINE_NUM',l_lot_ln);
614: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
615: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
608: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')
609: then
610: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
611: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
612: fnd_message.set_token('LPN',l_lpn);
613: fnd_message.set_token('LINE_NUM',l_lot_ln);
614: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
615: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
616: raise l_25errors;
609: then
610: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
611: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
612: fnd_message.set_token('LPN',l_lpn);
613: fnd_message.set_token('LINE_NUM',l_lot_ln);
614: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
615: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
616: raise l_25errors;
617: end if;
610: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
611: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
612: fnd_message.set_token('LPN',l_lpn);
613: fnd_message.set_token('LINE_NUM',l_lot_ln);
614: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
615: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
616: raise l_25errors;
617: end if;
618: elsif(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
611: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
612: fnd_message.set_token('LPN',l_lpn);
613: fnd_message.set_token('LINE_NUM',l_lot_ln);
614: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
615: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
616: raise l_25errors;
617: end if;
618: elsif(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
619: if(InsertError(x_error_tbl, 'Error while validating License Plate Number at line: '||l_lpn_ln||':'||l_lpn_return_msg, x_error_pointer)=1) then
654:
655: if(l_ser_status = FND_API.G_RET_STS_SUCCESS and l_ser_return_code = 'F')
656: then
657: --Serial range (From FMSERIAL to TOSERIAL with quantity QTY) at line LINE_NUM is invalid: ERROR_MSG
658: fnd_message.set_name('POS','POS_EXASN_INVALID_SER');
659: fnd_message.set_token('FMSERIAL',l_fm_serial);
660: fnd_message.set_token('TOSERIAL',l_to_serial);
661: fnd_message.set_token('QTY',l_ser_qty);
662: fnd_message.set_token('LINE_NUM',l_ser_ln);
655: if(l_ser_status = FND_API.G_RET_STS_SUCCESS and l_ser_return_code = 'F')
656: then
657: --Serial range (From FMSERIAL to TOSERIAL with quantity QTY) at line LINE_NUM is invalid: ERROR_MSG
658: fnd_message.set_name('POS','POS_EXASN_INVALID_SER');
659: fnd_message.set_token('FMSERIAL',l_fm_serial);
660: fnd_message.set_token('TOSERIAL',l_to_serial);
661: fnd_message.set_token('QTY',l_ser_qty);
662: fnd_message.set_token('LINE_NUM',l_ser_ln);
663: fnd_message.set_token('ERROR_MSG',l_ser_return_msg);
656: then
657: --Serial range (From FMSERIAL to TOSERIAL with quantity QTY) at line LINE_NUM is invalid: ERROR_MSG
658: fnd_message.set_name('POS','POS_EXASN_INVALID_SER');
659: fnd_message.set_token('FMSERIAL',l_fm_serial);
660: fnd_message.set_token('TOSERIAL',l_to_serial);
661: fnd_message.set_token('QTY',l_ser_qty);
662: fnd_message.set_token('LINE_NUM',l_ser_ln);
663: fnd_message.set_token('ERROR_MSG',l_ser_return_msg);
664: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
657: --Serial range (From FMSERIAL to TOSERIAL with quantity QTY) at line LINE_NUM is invalid: ERROR_MSG
658: fnd_message.set_name('POS','POS_EXASN_INVALID_SER');
659: fnd_message.set_token('FMSERIAL',l_fm_serial);
660: fnd_message.set_token('TOSERIAL',l_to_serial);
661: fnd_message.set_token('QTY',l_ser_qty);
662: fnd_message.set_token('LINE_NUM',l_ser_ln);
663: fnd_message.set_token('ERROR_MSG',l_ser_return_msg);
664: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
665: raise l_25errors;
658: fnd_message.set_name('POS','POS_EXASN_INVALID_SER');
659: fnd_message.set_token('FMSERIAL',l_fm_serial);
660: fnd_message.set_token('TOSERIAL',l_to_serial);
661: fnd_message.set_token('QTY',l_ser_qty);
662: fnd_message.set_token('LINE_NUM',l_ser_ln);
663: fnd_message.set_token('ERROR_MSG',l_ser_return_msg);
664: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
665: raise l_25errors;
666: end if;
659: fnd_message.set_token('FMSERIAL',l_fm_serial);
660: fnd_message.set_token('TOSERIAL',l_to_serial);
661: fnd_message.set_token('QTY',l_ser_qty);
662: fnd_message.set_token('LINE_NUM',l_ser_ln);
663: fnd_message.set_token('ERROR_MSG',l_ser_return_msg);
664: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
665: raise l_25errors;
666: end if;
667: elsif(l_ser_status <> FND_API.G_RET_STS_SUCCESS) then
660: fnd_message.set_token('TOSERIAL',l_to_serial);
661: fnd_message.set_token('QTY',l_ser_qty);
662: fnd_message.set_token('LINE_NUM',l_ser_ln);
663: fnd_message.set_token('ERROR_MSG',l_ser_return_msg);
664: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
665: raise l_25errors;
666: end if;
667: elsif(l_ser_status <> FND_API.G_RET_STS_SUCCESS) then
668: if(InsertError(x_error_tbl, 'Error while validating Serial Range/Quantity at line: '||l_ser_ln||':'||l_ser_return_msg, x_error_pointer)=1) then
681:
682: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')
683: then
684: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
685: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
686: fnd_message.set_token('LPN',l_lpn);
687: fnd_message.set_token('LINE_NUM',l_ser_ln);
688: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
689: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
682: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')
683: then
684: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
685: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
686: fnd_message.set_token('LPN',l_lpn);
687: fnd_message.set_token('LINE_NUM',l_ser_ln);
688: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
689: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
690: raise l_25errors;
683: then
684: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
685: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
686: fnd_message.set_token('LPN',l_lpn);
687: fnd_message.set_token('LINE_NUM',l_ser_ln);
688: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
689: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
690: raise l_25errors;
691: end if;
684: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
685: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
686: fnd_message.set_token('LPN',l_lpn);
687: fnd_message.set_token('LINE_NUM',l_ser_ln);
688: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
689: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
690: raise l_25errors;
691: end if;
692: elsif(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
685: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
686: fnd_message.set_token('LPN',l_lpn);
687: fnd_message.set_token('LINE_NUM',l_ser_ln);
688: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
689: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
690: raise l_25errors;
691: end if;
692: elsif(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
693: if(InsertError(x_error_tbl, 'Error while validating License Plate Number at line: '||l_lpn_ln||':'||l_lpn_return_msg, x_error_pointer)=1) then
721: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')
722: then
723:
724: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
725: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
726: fnd_message.set_token('LPN',l_lpn);
727: fnd_message.set_token('LINE_NUM',l_lpn_ln);
728: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
729: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
722: then
723:
724: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
725: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
726: fnd_message.set_token('LPN',l_lpn);
727: fnd_message.set_token('LINE_NUM',l_lpn_ln);
728: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
729: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
730: raise l_25errors;
723:
724: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
725: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
726: fnd_message.set_token('LPN',l_lpn);
727: fnd_message.set_token('LINE_NUM',l_lpn_ln);
728: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
729: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
730: raise l_25errors;
731: end if;
724: --License plate number LPN at line LINE_NUM is invalid: ERROR_MSG
725: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
726: fnd_message.set_token('LPN',l_lpn);
727: fnd_message.set_token('LINE_NUM',l_lpn_ln);
728: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
729: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
730: raise l_25errors;
731: end if;
732:
725: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');
726: fnd_message.set_token('LPN',l_lpn);
727: fnd_message.set_token('LINE_NUM',l_lpn_ln);
728: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
729: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
730: raise l_25errors;
731: end if;
732:
733: elsif(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
748:
749: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')
750: then
751: --Parent license plate number LPN at line LINE_NUM is invalid: ERROR_MSG
752: fnd_message.set_name('POS','POS_EXASN_INVALID_PLPN');
753: fnd_message.set_token('PLPN',l_parent_lpn);
754: fnd_message.set_token('LINE_NUM',l_lpn_ln);
755: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
756: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
749: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')
750: then
751: --Parent license plate number LPN at line LINE_NUM is invalid: ERROR_MSG
752: fnd_message.set_name('POS','POS_EXASN_INVALID_PLPN');
753: fnd_message.set_token('PLPN',l_parent_lpn);
754: fnd_message.set_token('LINE_NUM',l_lpn_ln);
755: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
756: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
757: raise l_25errors;
750: then
751: --Parent license plate number LPN at line LINE_NUM is invalid: ERROR_MSG
752: fnd_message.set_name('POS','POS_EXASN_INVALID_PLPN');
753: fnd_message.set_token('PLPN',l_parent_lpn);
754: fnd_message.set_token('LINE_NUM',l_lpn_ln);
755: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
756: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
757: raise l_25errors;
758: end if;
751: --Parent license plate number LPN at line LINE_NUM is invalid: ERROR_MSG
752: fnd_message.set_name('POS','POS_EXASN_INVALID_PLPN');
753: fnd_message.set_token('PLPN',l_parent_lpn);
754: fnd_message.set_token('LINE_NUM',l_lpn_ln);
755: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
756: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
757: raise l_25errors;
758: end if;
759:
752: fnd_message.set_name('POS','POS_EXASN_INVALID_PLPN');
753: fnd_message.set_token('PLPN',l_parent_lpn);
754: fnd_message.set_token('LINE_NUM',l_lpn_ln);
755: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);
756: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
757: raise l_25errors;
758: end if;
759:
760: elsif(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
948: open l_checkUOM_csr;
949: loop
950: fetch l_checkUOM_csr into l_error_ln, l_error_field;
951: exit when l_checkUOM_csr%NOTFOUND;
952: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
953: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));
954: fnd_message.set_token('LOV_VALUE',l_error_field);
955: fnd_message.set_token('LINE_NUM',l_error_ln);
956: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
949: loop
950: fetch l_checkUOM_csr into l_error_ln, l_error_field;
951: exit when l_checkUOM_csr%NOTFOUND;
952: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
953: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));
954: fnd_message.set_token('LOV_VALUE',l_error_field);
955: fnd_message.set_token('LINE_NUM',l_error_ln);
956: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
957: raise l_25errors;
950: fetch l_checkUOM_csr into l_error_ln, l_error_field;
951: exit when l_checkUOM_csr%NOTFOUND;
952: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
953: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));
954: fnd_message.set_token('LOV_VALUE',l_error_field);
955: fnd_message.set_token('LINE_NUM',l_error_ln);
956: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
957: raise l_25errors;
958: end if;
951: exit when l_checkUOM_csr%NOTFOUND;
952: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
953: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));
954: fnd_message.set_token('LOV_VALUE',l_error_field);
955: fnd_message.set_token('LINE_NUM',l_error_ln);
956: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
957: raise l_25errors;
958: end if;
959: end loop;
952: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
953: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));
954: fnd_message.set_token('LOV_VALUE',l_error_field);
955: fnd_message.set_token('LINE_NUM',l_error_ln);
956: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
957: raise l_25errors;
958: end if;
959: end loop;
960: close l_checkUOM_csr;
963: open l_checkCountryOO_csr;
964: loop
965: fetch l_checkCountryOO_csr into l_error_ln, l_error_field;
966: exit when l_checkCountryOO_csr%NOTFOUND;
967: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
968: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));
969: fnd_message.set_token('LOV_VALUE',l_error_field);
970: fnd_message.set_token('LINE_NUM',l_error_ln);
971: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
964: loop
965: fetch l_checkCountryOO_csr into l_error_ln, l_error_field;
966: exit when l_checkCountryOO_csr%NOTFOUND;
967: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
968: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));
969: fnd_message.set_token('LOV_VALUE',l_error_field);
970: fnd_message.set_token('LINE_NUM',l_error_ln);
971: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
972: raise l_25errors;
965: fetch l_checkCountryOO_csr into l_error_ln, l_error_field;
966: exit when l_checkCountryOO_csr%NOTFOUND;
967: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
968: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));
969: fnd_message.set_token('LOV_VALUE',l_error_field);
970: fnd_message.set_token('LINE_NUM',l_error_ln);
971: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
972: raise l_25errors;
973: end if;
966: exit when l_checkCountryOO_csr%NOTFOUND;
967: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
968: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));
969: fnd_message.set_token('LOV_VALUE',l_error_field);
970: fnd_message.set_token('LINE_NUM',l_error_ln);
971: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
972: raise l_25errors;
973: end if;
974: end loop;
967: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
968: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));
969: fnd_message.set_token('LOV_VALUE',l_error_field);
970: fnd_message.set_token('LINE_NUM',l_error_ln);
971: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
972: raise l_25errors;
973: end if;
974: end loop;
975: close l_checkCountryOO_csr;
986: open l_checkOrgName_csr;
987: loop
988: fetch l_checkOrgName_csr into l_error_ln, l_error_field;
989: exit when l_checkOrgName_csr%notfound;
990: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
991: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));
992: fnd_message.set_token('LOV_VALUE',l_error_field);
993: fnd_message.set_token('LINE_NUM',l_error_ln);
994: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
987: loop
988: fetch l_checkOrgName_csr into l_error_ln, l_error_field;
989: exit when l_checkOrgName_csr%notfound;
990: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
991: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));
992: fnd_message.set_token('LOV_VALUE',l_error_field);
993: fnd_message.set_token('LINE_NUM',l_error_ln);
994: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
995: raise l_25errors;
988: fetch l_checkOrgName_csr into l_error_ln, l_error_field;
989: exit when l_checkOrgName_csr%notfound;
990: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
991: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));
992: fnd_message.set_token('LOV_VALUE',l_error_field);
993: fnd_message.set_token('LINE_NUM',l_error_ln);
994: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
995: raise l_25errors;
996: end if;
989: exit when l_checkOrgName_csr%notfound;
990: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
991: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));
992: fnd_message.set_token('LOV_VALUE',l_error_field);
993: fnd_message.set_token('LINE_NUM',l_error_ln);
994: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
995: raise l_25errors;
996: end if;
997: end loop;
990: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
991: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));
992: fnd_message.set_token('LOV_VALUE',l_error_field);
993: fnd_message.set_token('LINE_NUM',l_error_ln);
994: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
995: raise l_25errors;
996: end if;
997: end loop;
998: close l_checkOrgName_csr;
1215: l_po_shipment,
1216: l_org_name;
1217: exit when l_checkPO_csr%NOTFOUND;
1218: l_failPORelCheck := 'T';
1219: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');
1220: fnd_message.set_token('DOC_NUM',l_doc_num);
1221: fnd_message.set_token('REV_NUM',l_revision_num);
1222: fnd_message.set_token('LINENUM',l_po_line);
1223: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1216: l_org_name;
1217: exit when l_checkPO_csr%NOTFOUND;
1218: l_failPORelCheck := 'T';
1219: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');
1220: fnd_message.set_token('DOC_NUM',l_doc_num);
1221: fnd_message.set_token('REV_NUM',l_revision_num);
1222: fnd_message.set_token('LINENUM',l_po_line);
1223: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1224: fnd_message.set_token('LINE_NUM',l_error_ln);
1217: exit when l_checkPO_csr%NOTFOUND;
1218: l_failPORelCheck := 'T';
1219: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');
1220: fnd_message.set_token('DOC_NUM',l_doc_num);
1221: fnd_message.set_token('REV_NUM',l_revision_num);
1222: fnd_message.set_token('LINENUM',l_po_line);
1223: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1224: fnd_message.set_token('LINE_NUM',l_error_ln);
1225: fnd_message.set_token('OP_UNIT',l_org_name);
1218: l_failPORelCheck := 'T';
1219: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');
1220: fnd_message.set_token('DOC_NUM',l_doc_num);
1221: fnd_message.set_token('REV_NUM',l_revision_num);
1222: fnd_message.set_token('LINENUM',l_po_line);
1223: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1224: fnd_message.set_token('LINE_NUM',l_error_ln);
1225: fnd_message.set_token('OP_UNIT',l_org_name);
1226: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1219: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');
1220: fnd_message.set_token('DOC_NUM',l_doc_num);
1221: fnd_message.set_token('REV_NUM',l_revision_num);
1222: fnd_message.set_token('LINENUM',l_po_line);
1223: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1224: fnd_message.set_token('LINE_NUM',l_error_ln);
1225: fnd_message.set_token('OP_UNIT',l_org_name);
1226: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1227: raise l_25errors;
1220: fnd_message.set_token('DOC_NUM',l_doc_num);
1221: fnd_message.set_token('REV_NUM',l_revision_num);
1222: fnd_message.set_token('LINENUM',l_po_line);
1223: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1224: fnd_message.set_token('LINE_NUM',l_error_ln);
1225: fnd_message.set_token('OP_UNIT',l_org_name);
1226: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1227: raise l_25errors;
1228: end if;
1221: fnd_message.set_token('REV_NUM',l_revision_num);
1222: fnd_message.set_token('LINENUM',l_po_line);
1223: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1224: fnd_message.set_token('LINE_NUM',l_error_ln);
1225: fnd_message.set_token('OP_UNIT',l_org_name);
1226: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1227: raise l_25errors;
1228: end if;
1229: end loop;
1222: fnd_message.set_token('LINENUM',l_po_line);
1223: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1224: fnd_message.set_token('LINE_NUM',l_error_ln);
1225: fnd_message.set_token('OP_UNIT',l_org_name);
1226: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1227: raise l_25errors;
1228: end if;
1229: end loop;
1230: close l_checkPO_csr;
1239: l_po_shipment,
1240: l_org_name;
1241: exit when l_checkREL_csr%NOTFOUND;
1242: l_failPORelCheck := 'T';
1243: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');
1244: fnd_message.set_token('DOC_NUM',l_doc_num);
1245: fnd_message.set_token('REL_NUM',l_rel_num);
1246: fnd_message.set_token('REV_NUM',l_revision_num);
1247: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1240: l_org_name;
1241: exit when l_checkREL_csr%NOTFOUND;
1242: l_failPORelCheck := 'T';
1243: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');
1244: fnd_message.set_token('DOC_NUM',l_doc_num);
1245: fnd_message.set_token('REL_NUM',l_rel_num);
1246: fnd_message.set_token('REV_NUM',l_revision_num);
1247: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1248: fnd_message.set_token('LINE_NUM',l_error_ln);
1241: exit when l_checkREL_csr%NOTFOUND;
1242: l_failPORelCheck := 'T';
1243: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');
1244: fnd_message.set_token('DOC_NUM',l_doc_num);
1245: fnd_message.set_token('REL_NUM',l_rel_num);
1246: fnd_message.set_token('REV_NUM',l_revision_num);
1247: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1248: fnd_message.set_token('LINE_NUM',l_error_ln);
1249: fnd_message.set_token('OP_UNIT',l_org_name);
1242: l_failPORelCheck := 'T';
1243: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');
1244: fnd_message.set_token('DOC_NUM',l_doc_num);
1245: fnd_message.set_token('REL_NUM',l_rel_num);
1246: fnd_message.set_token('REV_NUM',l_revision_num);
1247: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1248: fnd_message.set_token('LINE_NUM',l_error_ln);
1249: fnd_message.set_token('OP_UNIT',l_org_name);
1250: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1243: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');
1244: fnd_message.set_token('DOC_NUM',l_doc_num);
1245: fnd_message.set_token('REL_NUM',l_rel_num);
1246: fnd_message.set_token('REV_NUM',l_revision_num);
1247: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1248: fnd_message.set_token('LINE_NUM',l_error_ln);
1249: fnd_message.set_token('OP_UNIT',l_org_name);
1250: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1251: raise l_25errors;
1244: fnd_message.set_token('DOC_NUM',l_doc_num);
1245: fnd_message.set_token('REL_NUM',l_rel_num);
1246: fnd_message.set_token('REV_NUM',l_revision_num);
1247: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1248: fnd_message.set_token('LINE_NUM',l_error_ln);
1249: fnd_message.set_token('OP_UNIT',l_org_name);
1250: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1251: raise l_25errors;
1252: end if;
1245: fnd_message.set_token('REL_NUM',l_rel_num);
1246: fnd_message.set_token('REV_NUM',l_revision_num);
1247: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1248: fnd_message.set_token('LINE_NUM',l_error_ln);
1249: fnd_message.set_token('OP_UNIT',l_org_name);
1250: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1251: raise l_25errors;
1252: end if;
1253: end loop;
1246: fnd_message.set_token('REV_NUM',l_revision_num);
1247: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1248: fnd_message.set_token('LINE_NUM',l_error_ln);
1249: fnd_message.set_token('OP_UNIT',l_org_name);
1250: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1251: raise l_25errors;
1252: end if;
1253: end loop;
1254: close l_checkREL_csr;
1293: l_vendor_id||' is not secured');
1294: END IF;
1295:
1296: l_failSecure := 'T';
1297: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1298: fnd_message.set_token('LINE_NUM',l_error_ln);
1299: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN
1300: raise l_25errors;
1301: END IF;
1294: END IF;
1295:
1296: l_failSecure := 'T';
1297: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1298: fnd_message.set_token('LINE_NUM',l_error_ln);
1299: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN
1300: raise l_25errors;
1301: END IF;
1302: END IF;
1295:
1296: l_failSecure := 'T';
1297: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1298: fnd_message.set_token('LINE_NUM',l_error_ln);
1299: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN
1300: raise l_25errors;
1301: END IF;
1302: END IF;
1303:
1310: loop
1311: fetch l_checkVendorSites_csr into l_error_ln;
1312: exit when l_checkVendorSites_csr%NOTFOUND;
1313: l_failSecure := 'T';
1314: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1315: fnd_message.set_token('LINE_NUM',l_error_ln);
1316: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1317: raise l_25errors;
1318: end if;
1311: fetch l_checkVendorSites_csr into l_error_ln;
1312: exit when l_checkVendorSites_csr%NOTFOUND;
1313: l_failSecure := 'T';
1314: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1315: fnd_message.set_token('LINE_NUM',l_error_ln);
1316: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1317: raise l_25errors;
1318: end if;
1319: end loop;
1312: exit when l_checkVendorSites_csr%NOTFOUND;
1313: l_failSecure := 'T';
1314: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1315: fnd_message.set_token('LINE_NUM',l_error_ln);
1316: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1317: raise l_25errors;
1318: end if;
1319: end loop;
1320: close l_checkVendorSites_csr;
1325: loop
1326: fetch l_checkVendorContacts_csr into l_error_ln;
1327: exit when l_checkVendorContacts_csr%NOTFOUND;
1328: l_failSecure := 'T';
1329: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1330: fnd_message.set_token('LINE_NUM',l_error_ln);
1331: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1332: raise l_25errors;
1333: end if;
1326: fetch l_checkVendorContacts_csr into l_error_ln;
1327: exit when l_checkVendorContacts_csr%NOTFOUND;
1328: l_failSecure := 'T';
1329: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1330: fnd_message.set_token('LINE_NUM',l_error_ln);
1331: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1332: raise l_25errors;
1333: end if;
1334: end loop;
1327: exit when l_checkVendorContacts_csr%NOTFOUND;
1328: l_failSecure := 'T';
1329: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1330: fnd_message.set_token('LINE_NUM',l_error_ln);
1331: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1332: raise l_25errors;
1333: end if;
1334: end loop;
1335: close l_checkVendorContacts_csr;
1374:
1375: l_tolerableShipQty := POS_CREATE_ASN.getTolerableShipmentQuantity(l_po_line_location_id);
1376:
1377: if(l_primary_Qty = -1) then
1378: fnd_message.set_name('POS','POS_EXASN_EXCEPT_UOM');
1379: --An exception occured when trying to validate the quantity at line LINE_NUM. Please make sure the UOM you provided on that line is valid for the corresponding item.
1380: fnd_message.set_token('LINE_NUM',l_line_number);
1381: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1382: raise l_25errors;
1376:
1377: if(l_primary_Qty = -1) then
1378: fnd_message.set_name('POS','POS_EXASN_EXCEPT_UOM');
1379: --An exception occured when trying to validate the quantity at line LINE_NUM. Please make sure the UOM you provided on that line is valid for the corresponding item.
1380: fnd_message.set_token('LINE_NUM',l_line_number);
1381: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1382: raise l_25errors;
1383: end if;
1384: elsif(l_tolerableShipQty < l_primary_qty ) then
1377: if(l_primary_Qty = -1) then
1378: fnd_message.set_name('POS','POS_EXASN_EXCEPT_UOM');
1379: --An exception occured when trying to validate the quantity at line LINE_NUM. Please make sure the UOM you provided on that line is valid for the corresponding item.
1380: fnd_message.set_token('LINE_NUM',l_line_number);
1381: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1382: raise l_25errors;
1383: end if;
1384: elsif(l_tolerableShipQty < l_primary_qty ) then
1385:
1382: raise l_25errors;
1383: end if;
1384: elsif(l_tolerableShipQty < l_primary_qty ) then
1385:
1386: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1387: fnd_message.set_token('QTY',l_quantity);
1388: fnd_message.set_token('LINE_NUM',l_line_number);
1389: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1390: raise l_25errors;
1383: end if;
1384: elsif(l_tolerableShipQty < l_primary_qty ) then
1385:
1386: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1387: fnd_message.set_token('QTY',l_quantity);
1388: fnd_message.set_token('LINE_NUM',l_line_number);
1389: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1390: raise l_25errors;
1391: end if;
1384: elsif(l_tolerableShipQty < l_primary_qty ) then
1385:
1386: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1387: fnd_message.set_token('QTY',l_quantity);
1388: fnd_message.set_token('LINE_NUM',l_line_number);
1389: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1390: raise l_25errors;
1391: end if;
1392: end if;
1385:
1386: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1387: fnd_message.set_token('QTY',l_quantity);
1388: fnd_message.set_token('LINE_NUM',l_line_number);
1389: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1390: raise l_25errors;
1391: end if;
1392: end if;
1393: end if;
1402: from pos_exasn_headers
1403: where header_id = l_header_id;
1404:
1405: if(l_exp_rec_date > l_due_date+l_days_late OR l_exp_rec_date < l_due_date-l_days_early) then
1406: fnd_message.set_name('POS','POS_EXASN_ERDATE_TOL');
1407: fnd_message.set_token('HDR_LINE_NUM',l_header_line_number);
1408: fnd_message.set_token('LINE_NUM',l_line_number);
1409: --the expected receipt date defined in line HDR_LINE_NUM will violate the tolerance for PO Shipment at line LINE_NUM
1410: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1403: where header_id = l_header_id;
1404:
1405: if(l_exp_rec_date > l_due_date+l_days_late OR l_exp_rec_date < l_due_date-l_days_early) then
1406: fnd_message.set_name('POS','POS_EXASN_ERDATE_TOL');
1407: fnd_message.set_token('HDR_LINE_NUM',l_header_line_number);
1408: fnd_message.set_token('LINE_NUM',l_line_number);
1409: --the expected receipt date defined in line HDR_LINE_NUM will violate the tolerance for PO Shipment at line LINE_NUM
1410: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1411: raise l_25errors;
1404:
1405: if(l_exp_rec_date > l_due_date+l_days_late OR l_exp_rec_date < l_due_date-l_days_early) then
1406: fnd_message.set_name('POS','POS_EXASN_ERDATE_TOL');
1407: fnd_message.set_token('HDR_LINE_NUM',l_header_line_number);
1408: fnd_message.set_token('LINE_NUM',l_line_number);
1409: --the expected receipt date defined in line HDR_LINE_NUM will violate the tolerance for PO Shipment at line LINE_NUM
1410: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1411: raise l_25errors;
1412: end if;
1406: fnd_message.set_name('POS','POS_EXASN_ERDATE_TOL');
1407: fnd_message.set_token('HDR_LINE_NUM',l_header_line_number);
1408: fnd_message.set_token('LINE_NUM',l_line_number);
1409: --the expected receipt date defined in line HDR_LINE_NUM will violate the tolerance for PO Shipment at line LINE_NUM
1410: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1411: raise l_25errors;
1412: end if;
1413: end if;
1414: end if;
1427: PDSH.STATUS (+) = 'ACTIVE';
1428:
1429: IF(l_clm_flag = 'Y') THEN
1430: IF (l_tolerableShipQty < l_primary_qty) THEN
1431: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1432: fnd_message.set_token('QTY',l_quantity);
1433: fnd_message.set_token('LINE_NUM',l_line_number);
1434: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1435: raise l_25errors;
1428:
1429: IF(l_clm_flag = 'Y') THEN
1430: IF (l_tolerableShipQty < l_primary_qty) THEN
1431: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1432: fnd_message.set_token('QTY',l_quantity);
1433: fnd_message.set_token('LINE_NUM',l_line_number);
1434: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1435: raise l_25errors;
1436: end if;
1429: IF(l_clm_flag = 'Y') THEN
1430: IF (l_tolerableShipQty < l_primary_qty) THEN
1431: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1432: fnd_message.set_token('QTY',l_quantity);
1433: fnd_message.set_token('LINE_NUM',l_line_number);
1434: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1435: raise l_25errors;
1436: end if;
1437: END IF;
1430: IF (l_tolerableShipQty < l_primary_qty) THEN
1431: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1432: fnd_message.set_token('QTY',l_quantity);
1433: fnd_message.set_token('LINE_NUM',l_line_number);
1434: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1435: raise l_25errors;
1436: end if;
1437: END IF;
1438: END IF;
1442: END IF;
1443: END;
1444:
1445: if ( l_outsourced_assembly = 1 ) then
1446: fnd_message.set_name('POS','POS_EXASN_ERR_SHIKYU');
1447: fnd_message.set_token('LINE_NUM',l_line_number);
1448: -- Shipments can not be created using Outsourced assembly items
1449: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1450: raise l_25errors;
1443: END;
1444:
1445: if ( l_outsourced_assembly = 1 ) then
1446: fnd_message.set_name('POS','POS_EXASN_ERR_SHIKYU');
1447: fnd_message.set_token('LINE_NUM',l_line_number);
1448: -- Shipments can not be created using Outsourced assembly items
1449: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1450: raise l_25errors;
1451: end if;
1445: if ( l_outsourced_assembly = 1 ) then
1446: fnd_message.set_name('POS','POS_EXASN_ERR_SHIKYU');
1447: fnd_message.set_token('LINE_NUM',l_line_number);
1448: -- Shipments can not be created using Outsourced assembly items
1449: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1450: raise l_25errors;
1451: end if;
1452: end if;
1453: end loop;
1467: l_new_sn := 'F';
1468: end if;
1469:
1470: if(l_new_sn = 'T') then
1471: fnd_message.set_name('POS','POS_EXASN_DUPE_SHIP');
1472: --Shipment number SHIP_NUM at line LINE_NUM is invalid because there is an existing shipment notice with the same vendor, vendor site, and shipment number.
1473: fnd_message.set_token('LINE_NUM',l_error_ln);
1474: fnd_message.set_token('SHIP_NUM',l_error_field);
1475: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1469:
1470: if(l_new_sn = 'T') then
1471: fnd_message.set_name('POS','POS_EXASN_DUPE_SHIP');
1472: --Shipment number SHIP_NUM at line LINE_NUM is invalid because there is an existing shipment notice with the same vendor, vendor site, and shipment number.
1473: fnd_message.set_token('LINE_NUM',l_error_ln);
1474: fnd_message.set_token('SHIP_NUM',l_error_field);
1475: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1476: raise l_25errors;
1477: end if;
1470: if(l_new_sn = 'T') then
1471: fnd_message.set_name('POS','POS_EXASN_DUPE_SHIP');
1472: --Shipment number SHIP_NUM at line LINE_NUM is invalid because there is an existing shipment notice with the same vendor, vendor site, and shipment number.
1473: fnd_message.set_token('LINE_NUM',l_error_ln);
1474: fnd_message.set_token('SHIP_NUM',l_error_field);
1475: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1476: raise l_25errors;
1477: end if;
1478: end if;
1471: fnd_message.set_name('POS','POS_EXASN_DUPE_SHIP');
1472: --Shipment number SHIP_NUM at line LINE_NUM is invalid because there is an existing shipment notice with the same vendor, vendor site, and shipment number.
1473: fnd_message.set_token('LINE_NUM',l_error_ln);
1474: fnd_message.set_token('SHIP_NUM',l_error_field);
1475: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1476: raise l_25errors;
1477: end if;
1478: end if;
1479:
1575: open l_checkGrossWtUOM_csr;
1576: loop
1577: fetch l_checkGrossWtUOM_csr into l_error_ln, l_error_field;
1578: exit when l_checkGrossWtUOM_csr%NOTFOUND;
1579: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1580: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));
1581: fnd_message.set_token('LOV_VALUE',l_error_field);
1582: fnd_message.set_token('LINE_NUM',l_error_ln);
1583: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1576: loop
1577: fetch l_checkGrossWtUOM_csr into l_error_ln, l_error_field;
1578: exit when l_checkGrossWtUOM_csr%NOTFOUND;
1579: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1580: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));
1581: fnd_message.set_token('LOV_VALUE',l_error_field);
1582: fnd_message.set_token('LINE_NUM',l_error_ln);
1583: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1584: raise l_25errors;
1577: fetch l_checkGrossWtUOM_csr into l_error_ln, l_error_field;
1578: exit when l_checkGrossWtUOM_csr%NOTFOUND;
1579: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1580: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));
1581: fnd_message.set_token('LOV_VALUE',l_error_field);
1582: fnd_message.set_token('LINE_NUM',l_error_ln);
1583: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1584: raise l_25errors;
1585: end if;
1578: exit when l_checkGrossWtUOM_csr%NOTFOUND;
1579: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1580: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));
1581: fnd_message.set_token('LOV_VALUE',l_error_field);
1582: fnd_message.set_token('LINE_NUM',l_error_ln);
1583: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1584: raise l_25errors;
1585: end if;
1586: end loop;
1579: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1580: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));
1581: fnd_message.set_token('LOV_VALUE',l_error_field);
1582: fnd_message.set_token('LINE_NUM',l_error_ln);
1583: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1584: raise l_25errors;
1585: end if;
1586: end loop;
1587: close l_checkGrossWtUOM_csr;
1598: open l_checkNetWtUOM_csr;
1599: loop
1600: fetch l_checkNetWtUOM_csr into l_error_ln, l_error_field;
1601: exit when l_checkNetWtUOM_csr%NOTFOUND;
1602: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1603: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));
1604: fnd_message.set_token('LOV_VALUE',l_error_field);
1605: fnd_message.set_token('LINE_NUM',l_error_ln);
1606: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1599: loop
1600: fetch l_checkNetWtUOM_csr into l_error_ln, l_error_field;
1601: exit when l_checkNetWtUOM_csr%NOTFOUND;
1602: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1603: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));
1604: fnd_message.set_token('LOV_VALUE',l_error_field);
1605: fnd_message.set_token('LINE_NUM',l_error_ln);
1606: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1607: raise l_25errors;
1600: fetch l_checkNetWtUOM_csr into l_error_ln, l_error_field;
1601: exit when l_checkNetWtUOM_csr%NOTFOUND;
1602: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1603: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));
1604: fnd_message.set_token('LOV_VALUE',l_error_field);
1605: fnd_message.set_token('LINE_NUM',l_error_ln);
1606: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1607: raise l_25errors;
1608: end if;
1601: exit when l_checkNetWtUOM_csr%NOTFOUND;
1602: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1603: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));
1604: fnd_message.set_token('LOV_VALUE',l_error_field);
1605: fnd_message.set_token('LINE_NUM',l_error_ln);
1606: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1607: raise l_25errors;
1608: end if;
1609: end loop;
1602: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1603: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));
1604: fnd_message.set_token('LOV_VALUE',l_error_field);
1605: fnd_message.set_token('LINE_NUM',l_error_ln);
1606: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1607: raise l_25errors;
1608: end if;
1609: end loop;
1610: close l_checkNetWtUOM_csr;
1621: open l_checkTarWtUOM_csr;
1622: loop
1623: fetch l_checkTarWtUOM_csr into l_error_ln, l_error_field;
1624: exit when l_checkTarWtUOM_csr%NOTFOUND;
1625: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1626: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));
1627: fnd_message.set_token('LOV_VALUE',l_error_field);
1628: fnd_message.set_token('LINE_NUM',l_error_ln);
1629: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1622: loop
1623: fetch l_checkTarWtUOM_csr into l_error_ln, l_error_field;
1624: exit when l_checkTarWtUOM_csr%NOTFOUND;
1625: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1626: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));
1627: fnd_message.set_token('LOV_VALUE',l_error_field);
1628: fnd_message.set_token('LINE_NUM',l_error_ln);
1629: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1630: raise l_25errors;
1623: fetch l_checkTarWtUOM_csr into l_error_ln, l_error_field;
1624: exit when l_checkTarWtUOM_csr%NOTFOUND;
1625: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1626: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));
1627: fnd_message.set_token('LOV_VALUE',l_error_field);
1628: fnd_message.set_token('LINE_NUM',l_error_ln);
1629: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1630: raise l_25errors;
1631: end if;
1624: exit when l_checkTarWtUOM_csr%NOTFOUND;
1625: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1626: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));
1627: fnd_message.set_token('LOV_VALUE',l_error_field);
1628: fnd_message.set_token('LINE_NUM',l_error_ln);
1629: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1630: raise l_25errors;
1631: end if;
1632: end loop;
1625: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1626: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));
1627: fnd_message.set_token('LOV_VALUE',l_error_field);
1628: fnd_message.set_token('LINE_NUM',l_error_ln);
1629: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1630: raise l_25errors;
1631: end if;
1632: end loop;
1633: close l_checkTarWtUOM_csr;
1645: open l_checkFreightTerms_csr;
1646: loop
1647: fetch l_checkFreightTerms_csr into l_error_ln, l_error_field;
1648: exit when l_checkFreightTerms_csr%NOTFOUND;
1649: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1650: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FRTERM'));
1651: fnd_message.set_token('LOV_VALUE',l_error_field);
1652: fnd_message.set_token('LINE_NUM',l_error_ln);
1653: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1646: loop
1647: fetch l_checkFreightTerms_csr into l_error_ln, l_error_field;
1648: exit when l_checkFreightTerms_csr%NOTFOUND;
1649: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1650: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FRTERM'));
1651: fnd_message.set_token('LOV_VALUE',l_error_field);
1652: fnd_message.set_token('LINE_NUM',l_error_ln);
1653: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1654: raise l_25errors;
1647: fetch l_checkFreightTerms_csr into l_error_ln, l_error_field;
1648: exit when l_checkFreightTerms_csr%NOTFOUND;
1649: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1650: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FRTERM'));
1651: fnd_message.set_token('LOV_VALUE',l_error_field);
1652: fnd_message.set_token('LINE_NUM',l_error_ln);
1653: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1654: raise l_25errors;
1655: end if;
1648: exit when l_checkFreightTerms_csr%NOTFOUND;
1649: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1650: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FRTERM'));
1651: fnd_message.set_token('LOV_VALUE',l_error_field);
1652: fnd_message.set_token('LINE_NUM',l_error_ln);
1653: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1654: raise l_25errors;
1655: end if;
1656: end loop;
1649: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1650: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FRTERM'));
1651: fnd_message.set_token('LOV_VALUE',l_error_field);
1652: fnd_message.set_token('LINE_NUM',l_error_ln);
1653: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1654: raise l_25errors;
1655: end if;
1656: end loop;
1657: close l_checkFreightTerms_csr;
1660: open l_checkShipDate_csr;
1661: loop
1662: fetch l_checkShipDate_csr into l_error_ln, l_error_field;
1663: exit when l_checkShipDate_csr%NOTFOUND;
1664: fnd_message.set_name('POS','POS_EXASN_BAD_SHP_DATE');
1665: fnd_message.set_token('LINE_NUM',l_error_ln);
1666: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1667: raise l_25errors;
1668: end if;
1661: loop
1662: fetch l_checkShipDate_csr into l_error_ln, l_error_field;
1663: exit when l_checkShipDate_csr%NOTFOUND;
1664: fnd_message.set_name('POS','POS_EXASN_BAD_SHP_DATE');
1665: fnd_message.set_token('LINE_NUM',l_error_ln);
1666: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1667: raise l_25errors;
1668: end if;
1669: end loop;
1662: fetch l_checkShipDate_csr into l_error_ln, l_error_field;
1663: exit when l_checkShipDate_csr%NOTFOUND;
1664: fnd_message.set_name('POS','POS_EXASN_BAD_SHP_DATE');
1665: fnd_message.set_token('LINE_NUM',l_error_ln);
1666: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1667: raise l_25errors;
1668: end if;
1669: end loop;
1670: close l_checkShipDate_csr;
1673: open l_checkInvPT_csr;
1674: loop
1675: fetch l_checkInvPT_csr into l_error_ln, l_error_field;
1676: exit when l_checkInvPT_csr%NOTFOUND;
1677: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1678: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));
1679: fnd_message.set_token('LOV_VALUE',l_error_field);
1680: fnd_message.set_token('LINE_NUM',l_error_ln);
1681: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1674: loop
1675: fetch l_checkInvPT_csr into l_error_ln, l_error_field;
1676: exit when l_checkInvPT_csr%NOTFOUND;
1677: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1678: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));
1679: fnd_message.set_token('LOV_VALUE',l_error_field);
1680: fnd_message.set_token('LINE_NUM',l_error_ln);
1681: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1682: raise l_25errors;
1675: fetch l_checkInvPT_csr into l_error_ln, l_error_field;
1676: exit when l_checkInvPT_csr%NOTFOUND;
1677: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1678: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));
1679: fnd_message.set_token('LOV_VALUE',l_error_field);
1680: fnd_message.set_token('LINE_NUM',l_error_ln);
1681: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1682: raise l_25errors;
1683: end if;
1676: exit when l_checkInvPT_csr%NOTFOUND;
1677: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1678: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));
1679: fnd_message.set_token('LOV_VALUE',l_error_field);
1680: fnd_message.set_token('LINE_NUM',l_error_ln);
1681: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1682: raise l_25errors;
1683: end if;
1684: end loop;
1677: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1678: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));
1679: fnd_message.set_token('LOV_VALUE',l_error_field);
1680: fnd_message.set_token('LINE_NUM',l_error_ln);
1681: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1682: raise l_25errors;
1683: end if;
1684: end loop;
1685: close l_checkInvPT_csr;
1688: open l_checkER_Ship_csr;
1689: loop
1690: fetch l_checkER_Ship_csr into l_error_ln;
1691: exit when l_checkER_Ship_csr%NOTFOUND;
1692: fnd_message.set_name('POS','POS_EXASN_ERDATE_SDATE');
1693: fnd_message.set_token('LINE_NUM',l_error_ln);
1694: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1695: raise l_25errors;
1696: end if;
1689: loop
1690: fetch l_checkER_Ship_csr into l_error_ln;
1691: exit when l_checkER_Ship_csr%NOTFOUND;
1692: fnd_message.set_name('POS','POS_EXASN_ERDATE_SDATE');
1693: fnd_message.set_token('LINE_NUM',l_error_ln);
1694: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1695: raise l_25errors;
1696: end if;
1697: end loop;
1690: fetch l_checkER_Ship_csr into l_error_ln;
1691: exit when l_checkER_Ship_csr%NOTFOUND;
1692: fnd_message.set_name('POS','POS_EXASN_ERDATE_SDATE');
1693: fnd_message.set_token('LINE_NUM',l_error_ln);
1694: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1695: raise l_25errors;
1696: end if;
1697: end loop;
1698: close l_checkER_Ship_csr;
3017: into l_error_ln
3018: from pos_exasn_headers
3019: where header_id = l_ex_header_id;
3020:
3021: fnd_message.set_name('POS','POS_EXASN_ASBN_XHDR');
3022: fnd_message.set_token('LINE_NUM',l_error_ln);
3023: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3024: raise l_early_exit;
3025: end if;
3018: from pos_exasn_headers
3019: where header_id = l_ex_header_id;
3020:
3021: fnd_message.set_name('POS','POS_EXASN_ASBN_XHDR');
3022: fnd_message.set_token('LINE_NUM',l_error_ln);
3023: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3024: raise l_early_exit;
3025: end if;
3026: end if;
3019: where header_id = l_ex_header_id;
3020:
3021: fnd_message.set_name('POS','POS_EXASN_ASBN_XHDR');
3022: fnd_message.set_token('LINE_NUM',l_error_ln);
3023: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3024: raise l_early_exit;
3025: end if;
3026: end if;
3027:
3075: open l_checkFreightCC_csr;
3076: loop
3077: fetch l_checkFreightCC_csr into l_error_ln, l_fcc;
3078: exit when l_checkFreightCC_csr%NOTFOUND;
3079: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3080: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));
3081: fnd_message.set_token('LOV_VALUE',l_fcc);
3082: fnd_message.set_token('LINE_NUM',l_error_ln);
3083: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3076: loop
3077: fetch l_checkFreightCC_csr into l_error_ln, l_fcc;
3078: exit when l_checkFreightCC_csr%NOTFOUND;
3079: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3080: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));
3081: fnd_message.set_token('LOV_VALUE',l_fcc);
3082: fnd_message.set_token('LINE_NUM',l_error_ln);
3083: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3084: raise l_early_exit;
3077: fetch l_checkFreightCC_csr into l_error_ln, l_fcc;
3078: exit when l_checkFreightCC_csr%NOTFOUND;
3079: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3080: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));
3081: fnd_message.set_token('LOV_VALUE',l_fcc);
3082: fnd_message.set_token('LINE_NUM',l_error_ln);
3083: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3084: raise l_early_exit;
3085: end if;
3078: exit when l_checkFreightCC_csr%NOTFOUND;
3079: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3080: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));
3081: fnd_message.set_token('LOV_VALUE',l_fcc);
3082: fnd_message.set_token('LINE_NUM',l_error_ln);
3083: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3084: raise l_early_exit;
3085: end if;
3086: end loop;
3079: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3080: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));
3081: fnd_message.set_token('LOV_VALUE',l_fcc);
3082: fnd_message.set_token('LINE_NUM',l_error_ln);
3083: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3084: raise l_early_exit;
3085: end if;
3086: end loop;
3087: close l_checkFreightCC_csr;
3090: open l_shipFrom_Loc_csr;
3091: loop
3092: fetch l_shipFrom_Loc_csr into l_error_ln,l_ship_from_loc;
3093: exit when l_shipFrom_Loc_csr%NOTFOUND;
3094: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3095: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));
3096: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);
3097: fnd_message.set_token('LINE_NUM',l_error_ln);
3098: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3091: loop
3092: fetch l_shipFrom_Loc_csr into l_error_ln,l_ship_from_loc;
3093: exit when l_shipFrom_Loc_csr%NOTFOUND;
3094: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3095: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));
3096: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);
3097: fnd_message.set_token('LINE_NUM',l_error_ln);
3098: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3099: raise l_early_exit;
3092: fetch l_shipFrom_Loc_csr into l_error_ln,l_ship_from_loc;
3093: exit when l_shipFrom_Loc_csr%NOTFOUND;
3094: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3095: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));
3096: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);
3097: fnd_message.set_token('LINE_NUM',l_error_ln);
3098: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3099: raise l_early_exit;
3100: end if;
3093: exit when l_shipFrom_Loc_csr%NOTFOUND;
3094: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3095: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));
3096: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);
3097: fnd_message.set_token('LINE_NUM',l_error_ln);
3098: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3099: raise l_early_exit;
3100: end if;
3101: end loop;
3094: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3095: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));
3096: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);
3097: fnd_message.set_token('LINE_NUM',l_error_ln);
3098: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3099: raise l_early_exit;
3100: end if;
3101: end loop;
3102: close l_shipFrom_Loc_csr;
3108: open l_checkNotPaySite_csr;
3109: loop
3110: fetch l_checkNotPaySite_csr into l_error_ln;
3111: exit when l_checkNotPaySite_csr%notfound;
3112: fnd_message.set_name('POS','POS_EXASN_NOTPAYSITE');
3113: fnd_message.set_token('LINE_NUM',l_error_ln);
3114: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3115: raise l_early_exit;
3116: end if;
3109: loop
3110: fetch l_checkNotPaySite_csr into l_error_ln;
3111: exit when l_checkNotPaySite_csr%notfound;
3112: fnd_message.set_name('POS','POS_EXASN_NOTPAYSITE');
3113: fnd_message.set_token('LINE_NUM',l_error_ln);
3114: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3115: raise l_early_exit;
3116: end if;
3117: end loop;
3110: fetch l_checkNotPaySite_csr into l_error_ln;
3111: exit when l_checkNotPaySite_csr%notfound;
3112: fnd_message.set_name('POS','POS_EXASN_NOTPAYSITE');
3113: fnd_message.set_token('LINE_NUM',l_error_ln);
3114: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3115: raise l_early_exit;
3116: end if;
3117: end loop;
3118: close l_checkNotPaySite_csr;
3642: loop
3643: fetch l_checkLotControl_csr into l_error_ln;
3644: exit when l_checkLotControl_csr%NOTFOUND;
3645: --Item at line LINE_NUM is not lot controlled, therefore shall not have any lot information.
3646: fnd_message.set_name('POS','POS_EXASN_NT_LC');
3647: fnd_message.set_token('LINE_NUM',l_error_ln);
3648: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3649: raise l_25errors;
3650: end if;
3643: fetch l_checkLotControl_csr into l_error_ln;
3644: exit when l_checkLotControl_csr%NOTFOUND;
3645: --Item at line LINE_NUM is not lot controlled, therefore shall not have any lot information.
3646: fnd_message.set_name('POS','POS_EXASN_NT_LC');
3647: fnd_message.set_token('LINE_NUM',l_error_ln);
3648: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3649: raise l_25errors;
3650: end if;
3651: end loop;
3644: exit when l_checkLotControl_csr%NOTFOUND;
3645: --Item at line LINE_NUM is not lot controlled, therefore shall not have any lot information.
3646: fnd_message.set_name('POS','POS_EXASN_NT_LC');
3647: fnd_message.set_token('LINE_NUM',l_error_ln);
3648: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3649: raise l_25errors;
3650: end if;
3651: end loop;
3652: close l_checkLotControl_csr;
3655: loop
3656: fetch l_checkSerialControl_csr into l_error_ln;
3657: exit when l_checkSerialControl_csr%NOTFOUND;
3658: --Item at line LINE_NUM is not serial controlled, therefore shall not have any serial information.
3659: fnd_message.set_name('POS','POS_EXASN_NT_SC');
3660: fnd_message.set_token('LINE_NUM',l_error_ln);
3661: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3662: raise l_25errors;
3663: end if;
3656: fetch l_checkSerialControl_csr into l_error_ln;
3657: exit when l_checkSerialControl_csr%NOTFOUND;
3658: --Item at line LINE_NUM is not serial controlled, therefore shall not have any serial information.
3659: fnd_message.set_name('POS','POS_EXASN_NT_SC');
3660: fnd_message.set_token('LINE_NUM',l_error_ln);
3661: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3662: raise l_25errors;
3663: end if;
3664: end loop;
3657: exit when l_checkSerialControl_csr%NOTFOUND;
3658: --Item at line LINE_NUM is not serial controlled, therefore shall not have any serial information.
3659: fnd_message.set_name('POS','POS_EXASN_NT_SC');
3660: fnd_message.set_token('LINE_NUM',l_error_ln);
3661: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3662: raise l_25errors;
3663: end if;
3664: end loop;
3665: close l_checkSerialControl_csr;
3668: loop
3669: fetch l_check_lpnref_csr into l_lpn, l_error_ln;
3670: exit when l_check_lpnref_csr%NOTFOUND;
3671: --The license plate number (LPN) defined in line LINE_NUM is invalid. The license plate number has to be defined in the Lot/Serial section or defined as a "Contained in License Plate Number".
3672: fnd_message.set_name('POS','POS_EXASN_LPN_NOREF');
3673: fnd_message.set_token('LINE_NUM',l_error_ln);
3674: fnd_message.set_token('LPN',l_lpn);
3675: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3676: raise l_25errors;
3669: fetch l_check_lpnref_csr into l_lpn, l_error_ln;
3670: exit when l_check_lpnref_csr%NOTFOUND;
3671: --The license plate number (LPN) defined in line LINE_NUM is invalid. The license plate number has to be defined in the Lot/Serial section or defined as a "Contained in License Plate Number".
3672: fnd_message.set_name('POS','POS_EXASN_LPN_NOREF');
3673: fnd_message.set_token('LINE_NUM',l_error_ln);
3674: fnd_message.set_token('LPN',l_lpn);
3675: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3676: raise l_25errors;
3677: end if;
3670: exit when l_check_lpnref_csr%NOTFOUND;
3671: --The license plate number (LPN) defined in line LINE_NUM is invalid. The license plate number has to be defined in the Lot/Serial section or defined as a "Contained in License Plate Number".
3672: fnd_message.set_name('POS','POS_EXASN_LPN_NOREF');
3673: fnd_message.set_token('LINE_NUM',l_error_ln);
3674: fnd_message.set_token('LPN',l_lpn);
3675: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3676: raise l_25errors;
3677: end if;
3678: end loop;
3671: --The license plate number (LPN) defined in line LINE_NUM is invalid. The license plate number has to be defined in the Lot/Serial section or defined as a "Contained in License Plate Number".
3672: fnd_message.set_name('POS','POS_EXASN_LPN_NOREF');
3673: fnd_message.set_token('LINE_NUM',l_error_ln);
3674: fnd_message.set_token('LPN',l_lpn);
3675: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3676: raise l_25errors;
3677: end if;
3678: end loop;
3679: close l_check_lpnref_csr;
4026: MODULE => 'pos.plsql.pos_asn_create_pvt.CheckSecuringAtt',
4027: MESSAGE => 'No data found for cursor: l_vendorId_csr');
4028: END IF;
4029:
4030: fnd_message.set_name('POS','POS_EXASN_NOT_ORG_SEC');
4031: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN
4032: null;
4033: END IF;
4034: x_return_status := 'E';
4027: MESSAGE => 'No data found for cursor: l_vendorId_csr');
4028: END IF;
4029:
4030: fnd_message.set_name('POS','POS_EXASN_NOT_ORG_SEC');
4031: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN
4032: null;
4033: END IF;
4034: x_return_status := 'E';
4035: END;
4063: open l_vendorSite_csr(fnd_global.user_id);
4064: fetch l_vendorSite_csr into l_num;
4065: close l_vendorSite_csr;
4066: if(l_num is null) then
4067: fnd_message.set_name('POS','POS_EXASN_NOT_SITE_SEC');
4068: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer) = 1) then
4069: null;
4070: end if;
4071: x_return_status := 'E';
4064: fetch l_vendorSite_csr into l_num;
4065: close l_vendorSite_csr;
4066: if(l_num is null) then
4067: fnd_message.set_name('POS','POS_EXASN_NOT_SITE_SEC');
4068: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer) = 1) then
4069: null;
4070: end if;
4071: x_return_status := 'E';
4072: end if;
4100: open l_vendorContact_csr(fnd_global.user_id);
4101: fetch l_vendorContact_csr into l_num;
4102: close l_vendorContact_csr;
4103: if(l_num is null) then
4104: fnd_message.set_name('POS','POS_EXASN_NOT_CT_SEC');
4105: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer) = 1) then
4106: null;
4107: end if;
4108: x_return_status := 'E';
4101: fetch l_vendorContact_csr into l_num;
4102: close l_vendorContact_csr;
4103: if(l_num is null) then
4104: fnd_message.set_name('POS','POS_EXASN_NOT_CT_SEC');
4105: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer) = 1) then
4106: null;
4107: end if;
4108: x_return_status := 'E';
4109:
4284: open l_checkDocAsn_csr;
4285: loop
4286: fetch l_checkDocAsn_csr into l_shipment_number;
4287: exit when l_checkDocAsn_csr%NOTFOUND;
4288: fnd_message.set_name('POS','POS_EXASN_NEW_DUPE_SHIP');
4289: --Shipment number SHIP_NUM is used more than once for shipments with the same vendor, vendor site.
4290: fnd_message.set_token('SHIP_NUM',l_shipment_number);
4291: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4292: raise l_25errors;
4286: fetch l_checkDocAsn_csr into l_shipment_number;
4287: exit when l_checkDocAsn_csr%NOTFOUND;
4288: fnd_message.set_name('POS','POS_EXASN_NEW_DUPE_SHIP');
4289: --Shipment number SHIP_NUM is used more than once for shipments with the same vendor, vendor site.
4290: fnd_message.set_token('SHIP_NUM',l_shipment_number);
4291: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4292: raise l_25errors;
4293: end if;
4294: end loop;
4287: exit when l_checkDocAsn_csr%NOTFOUND;
4288: fnd_message.set_name('POS','POS_EXASN_NEW_DUPE_SHIP');
4289: --Shipment number SHIP_NUM is used more than once for shipments with the same vendor, vendor site.
4290: fnd_message.set_token('SHIP_NUM',l_shipment_number);
4291: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4292: raise l_25errors;
4293: end if;
4294: end loop;
4295: close l_checkDocAsn_csr;
4350: l_error_ln,
4351: l_error_ln2;
4352: exit when l_checkLpnContra_csr%NOTFOUND;
4353: --The Parent-Child relationships for license plate number at line LINE_NUM1 and LINE_NUM2 contradict each other.
4354: fnd_message.set_name('POS','POS_EXASN_PLPN_CONTRA');
4355: fnd_message.set_token('LINE_NUM1',l_error_ln);
4356: fnd_message.set_token('LINE_NUM2',l_error_ln2);
4357: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4358: raise l_25errors;
4351: l_error_ln2;
4352: exit when l_checkLpnContra_csr%NOTFOUND;
4353: --The Parent-Child relationships for license plate number at line LINE_NUM1 and LINE_NUM2 contradict each other.
4354: fnd_message.set_name('POS','POS_EXASN_PLPN_CONTRA');
4355: fnd_message.set_token('LINE_NUM1',l_error_ln);
4356: fnd_message.set_token('LINE_NUM2',l_error_ln2);
4357: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4358: raise l_25errors;
4359: end if;
4352: exit when l_checkLpnContra_csr%NOTFOUND;
4353: --The Parent-Child relationships for license plate number at line LINE_NUM1 and LINE_NUM2 contradict each other.
4354: fnd_message.set_name('POS','POS_EXASN_PLPN_CONTRA');
4355: fnd_message.set_token('LINE_NUM1',l_error_ln);
4356: fnd_message.set_token('LINE_NUM2',l_error_ln2);
4357: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4358: raise l_25errors;
4359: end if;
4360: end loop;
4353: --The Parent-Child relationships for license plate number at line LINE_NUM1 and LINE_NUM2 contradict each other.
4354: fnd_message.set_name('POS','POS_EXASN_PLPN_CONTRA');
4355: fnd_message.set_token('LINE_NUM1',l_error_ln);
4356: fnd_message.set_token('LINE_NUM2',l_error_ln2);
4357: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4358: raise l_25errors;
4359: end if;
4360: end loop;
4361: close l_checkLpnContra_csr;