eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.POS_EXCELASN_PVT dependencies on FND_MESSAGE

Line 334: fnd_message.set_name('POS','POS_EXASN_PLPNQTYNULL');

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;

Line 335: fnd_message.set_token('LINE_NUM',l_error_ln);

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;

Line 336: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

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;

Line 347: fnd_message.set_name('POS','POS_EXASN_LOT_NE_LN');

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;

Line 348: fnd_message.set_token('LINE_NUM',l_error_ln);

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;

Line 349: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

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;

Line 361: fnd_message.set_name('POS','POS_EXASN_SER_NE_LN');

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;

Line 362: fnd_message.set_token('LINE_NUM',l_error_ln);

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;

Line 363: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

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;

Line 374: fnd_message.set_name('POS','POS_EXASN_LPN_NE_LN');

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;

Line 375: fnd_message.set_token('LINE_NUM',l_error_ln);

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:

Line 376: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

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;

Line 388: fnd_message.set_name('POS','POS_EXASN_SER_NE_LOT');

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;

Line 389: fnd_message.set_token('LINE_NUM',l_error_ln);

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;

Line 390: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

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;

Line 585: fnd_message.set_name('POS','POS_EXASN_INVALID_LOT');

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

Line 586: fnd_message.set_token('LOT',l_lot_number);

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;

Line 587: fnd_message.set_token('LINE_NUM',l_lot_ln);

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;

Line 588: fnd_message.set_token('ERROR_MSG',l_lot_return_msg);

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

Line 589: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) 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

Line 611: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');

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

Line 612: fnd_message.set_token('LPN',l_lpn);

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;

Line 613: fnd_message.set_token('LINE_NUM',l_lot_ln);

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;

Line 614: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);

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

Line 615: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) 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

Line 658: fnd_message.set_name('POS','POS_EXASN_INVALID_SER');

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);

Line 659: fnd_message.set_token('FMSERIAL',l_fm_serial);

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);

Line 660: fnd_message.set_token('TOSERIAL',l_to_serial);

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

Line 661: fnd_message.set_token('QTY',l_ser_qty);

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;

Line 662: fnd_message.set_token('LINE_NUM',l_ser_ln);

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;

Line 663: fnd_message.set_token('ERROR_MSG',l_ser_return_msg);

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

Line 664: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) 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

Line 685: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');

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

Line 686: fnd_message.set_token('LPN',l_lpn);

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;

Line 687: fnd_message.set_token('LINE_NUM',l_ser_ln);

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;

Line 688: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);

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

Line 689: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) 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

Line 725: fnd_message.set_name('POS','POS_EXASN_INVALID_LPN');

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

Line 726: fnd_message.set_token('LPN',l_lpn);

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;

Line 727: fnd_message.set_token('LINE_NUM',l_lpn_ln);

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;

Line 728: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);

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:

Line 729: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

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

Line 752: fnd_message.set_name('POS','POS_EXASN_INVALID_PLPN');

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

Line 753: fnd_message.set_token('PLPN',l_parent_lpn);

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;

Line 754: fnd_message.set_token('LINE_NUM',l_lpn_ln);

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;

Line 755: fnd_message.set_token('ERROR_MSG',l_lpn_return_msg);

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:

Line 756: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

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

Line 951: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');

947: open l_checkUOM_csr;
948: loop
949: fetch l_checkUOM_csr into l_error_ln, l_error_field;
950: exit when l_checkUOM_csr%NOTFOUND;
951: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
952: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));
953: fnd_message.set_token('LOV_VALUE',l_error_field);
954: fnd_message.set_token('LINE_NUM',l_error_ln);
955: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

Line 952: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));

948: loop
949: fetch l_checkUOM_csr into l_error_ln, l_error_field;
950: exit when l_checkUOM_csr%NOTFOUND;
951: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
952: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));
953: fnd_message.set_token('LOV_VALUE',l_error_field);
954: fnd_message.set_token('LINE_NUM',l_error_ln);
955: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
956: raise l_25errors;

Line 953: fnd_message.set_token('LOV_VALUE',l_error_field);

949: fetch l_checkUOM_csr into l_error_ln, l_error_field;
950: exit when l_checkUOM_csr%NOTFOUND;
951: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
952: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));
953: fnd_message.set_token('LOV_VALUE',l_error_field);
954: fnd_message.set_token('LINE_NUM',l_error_ln);
955: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
956: raise l_25errors;
957: end if;

Line 954: fnd_message.set_token('LINE_NUM',l_error_ln);

950: exit when l_checkUOM_csr%NOTFOUND;
951: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
952: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));
953: fnd_message.set_token('LOV_VALUE',l_error_field);
954: fnd_message.set_token('LINE_NUM',l_error_ln);
955: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
956: raise l_25errors;
957: end if;
958: end loop;

Line 955: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

951: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
952: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_QTYUOM'));
953: fnd_message.set_token('LOV_VALUE',l_error_field);
954: fnd_message.set_token('LINE_NUM',l_error_ln);
955: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
956: raise l_25errors;
957: end if;
958: end loop;
959: close l_checkUOM_csr;

Line 966: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');

962: open l_checkCountryOO_csr;
963: loop
964: fetch l_checkCountryOO_csr into l_error_ln, l_error_field;
965: exit when l_checkCountryOO_csr%NOTFOUND;
966: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
967: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));
968: fnd_message.set_token('LOV_VALUE',l_error_field);
969: fnd_message.set_token('LINE_NUM',l_error_ln);
970: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

Line 967: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));

963: loop
964: fetch l_checkCountryOO_csr into l_error_ln, l_error_field;
965: exit when l_checkCountryOO_csr%NOTFOUND;
966: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
967: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));
968: fnd_message.set_token('LOV_VALUE',l_error_field);
969: fnd_message.set_token('LINE_NUM',l_error_ln);
970: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
971: raise l_25errors;

Line 968: fnd_message.set_token('LOV_VALUE',l_error_field);

964: fetch l_checkCountryOO_csr into l_error_ln, l_error_field;
965: exit when l_checkCountryOO_csr%NOTFOUND;
966: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
967: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));
968: fnd_message.set_token('LOV_VALUE',l_error_field);
969: fnd_message.set_token('LINE_NUM',l_error_ln);
970: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
971: raise l_25errors;
972: end if;

Line 969: fnd_message.set_token('LINE_NUM',l_error_ln);

965: exit when l_checkCountryOO_csr%NOTFOUND;
966: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
967: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));
968: fnd_message.set_token('LOV_VALUE',l_error_field);
969: fnd_message.set_token('LINE_NUM',l_error_ln);
970: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
971: raise l_25errors;
972: end if;
973: end loop;

Line 970: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

966: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
967: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_COORIGIN'));
968: fnd_message.set_token('LOV_VALUE',l_error_field);
969: fnd_message.set_token('LINE_NUM',l_error_ln);
970: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
971: raise l_25errors;
972: end if;
973: end loop;
974: close l_checkCountryOO_csr;

Line 989: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');

985: open l_checkOrgName_csr;
986: loop
987: fetch l_checkOrgName_csr into l_error_ln, l_error_field;
988: exit when l_checkOrgName_csr%notfound;
989: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
990: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));
991: fnd_message.set_token('LOV_VALUE',l_error_field);
992: fnd_message.set_token('LINE_NUM',l_error_ln);
993: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

Line 990: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));

986: loop
987: fetch l_checkOrgName_csr into l_error_ln, l_error_field;
988: exit when l_checkOrgName_csr%notfound;
989: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
990: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));
991: fnd_message.set_token('LOV_VALUE',l_error_field);
992: fnd_message.set_token('LINE_NUM',l_error_ln);
993: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
994: raise l_25errors;

Line 991: fnd_message.set_token('LOV_VALUE',l_error_field);

987: fetch l_checkOrgName_csr into l_error_ln, l_error_field;
988: exit when l_checkOrgName_csr%notfound;
989: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
990: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));
991: fnd_message.set_token('LOV_VALUE',l_error_field);
992: fnd_message.set_token('LINE_NUM',l_error_ln);
993: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
994: raise l_25errors;
995: end if;

Line 992: fnd_message.set_token('LINE_NUM',l_error_ln);

988: exit when l_checkOrgName_csr%notfound;
989: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
990: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));
991: fnd_message.set_token('LOV_VALUE',l_error_field);
992: fnd_message.set_token('LINE_NUM',l_error_ln);
993: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
994: raise l_25errors;
995: end if;
996: end loop;

Line 993: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

989: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
990: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_ORGUNIT'));
991: fnd_message.set_token('LOV_VALUE',l_error_field);
992: fnd_message.set_token('LINE_NUM',l_error_ln);
993: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
994: raise l_25errors;
995: end if;
996: end loop;
997: close l_checkOrgName_csr;

Line 1178: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');

1174: l_po_shipment,
1175: l_org_name;
1176: exit when l_checkPO_csr%NOTFOUND;
1177: l_failPORelCheck := 'T';
1178: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');
1179: fnd_message.set_token('DOC_NUM',l_doc_num);
1180: fnd_message.set_token('REV_NUM',l_revision_num);
1181: fnd_message.set_token('LINENUM',l_po_line);
1182: fnd_message.set_token('SHIP_NUM',l_po_shipment);

Line 1179: fnd_message.set_token('DOC_NUM',l_doc_num);

1175: l_org_name;
1176: exit when l_checkPO_csr%NOTFOUND;
1177: l_failPORelCheck := 'T';
1178: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');
1179: fnd_message.set_token('DOC_NUM',l_doc_num);
1180: fnd_message.set_token('REV_NUM',l_revision_num);
1181: fnd_message.set_token('LINENUM',l_po_line);
1182: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1183: fnd_message.set_token('LINE_NUM',l_error_ln);

Line 1180: fnd_message.set_token('REV_NUM',l_revision_num);

1176: exit when l_checkPO_csr%NOTFOUND;
1177: l_failPORelCheck := 'T';
1178: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');
1179: fnd_message.set_token('DOC_NUM',l_doc_num);
1180: fnd_message.set_token('REV_NUM',l_revision_num);
1181: fnd_message.set_token('LINENUM',l_po_line);
1182: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1183: fnd_message.set_token('LINE_NUM',l_error_ln);
1184: fnd_message.set_token('OP_UNIT',l_org_name);

Line 1181: fnd_message.set_token('LINENUM',l_po_line);

1177: l_failPORelCheck := 'T';
1178: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');
1179: fnd_message.set_token('DOC_NUM',l_doc_num);
1180: fnd_message.set_token('REV_NUM',l_revision_num);
1181: fnd_message.set_token('LINENUM',l_po_line);
1182: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1183: fnd_message.set_token('LINE_NUM',l_error_ln);
1184: fnd_message.set_token('OP_UNIT',l_org_name);
1185: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

Line 1182: fnd_message.set_token('SHIP_NUM',l_po_shipment);

1178: fnd_message.set_name('POS','POS_EXASN_PO_NOEXIST');
1179: fnd_message.set_token('DOC_NUM',l_doc_num);
1180: fnd_message.set_token('REV_NUM',l_revision_num);
1181: fnd_message.set_token('LINENUM',l_po_line);
1182: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1183: fnd_message.set_token('LINE_NUM',l_error_ln);
1184: fnd_message.set_token('OP_UNIT',l_org_name);
1185: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1186: raise l_25errors;

Line 1183: fnd_message.set_token('LINE_NUM',l_error_ln);

1179: fnd_message.set_token('DOC_NUM',l_doc_num);
1180: fnd_message.set_token('REV_NUM',l_revision_num);
1181: fnd_message.set_token('LINENUM',l_po_line);
1182: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1183: fnd_message.set_token('LINE_NUM',l_error_ln);
1184: fnd_message.set_token('OP_UNIT',l_org_name);
1185: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1186: raise l_25errors;
1187: end if;

Line 1184: fnd_message.set_token('OP_UNIT',l_org_name);

1180: fnd_message.set_token('REV_NUM',l_revision_num);
1181: fnd_message.set_token('LINENUM',l_po_line);
1182: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1183: fnd_message.set_token('LINE_NUM',l_error_ln);
1184: fnd_message.set_token('OP_UNIT',l_org_name);
1185: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1186: raise l_25errors;
1187: end if;
1188: end loop;

Line 1185: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

1181: fnd_message.set_token('LINENUM',l_po_line);
1182: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1183: fnd_message.set_token('LINE_NUM',l_error_ln);
1184: fnd_message.set_token('OP_UNIT',l_org_name);
1185: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1186: raise l_25errors;
1187: end if;
1188: end loop;
1189: close l_checkPO_csr;

Line 1202: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');

1198: l_po_shipment,
1199: l_org_name;
1200: exit when l_checkREL_csr%NOTFOUND;
1201: l_failPORelCheck := 'T';
1202: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');
1203: fnd_message.set_token('DOC_NUM',l_doc_num);
1204: fnd_message.set_token('REL_NUM',l_rel_num);
1205: fnd_message.set_token('REV_NUM',l_revision_num);
1206: fnd_message.set_token('SHIP_NUM',l_po_shipment);

Line 1203: fnd_message.set_token('DOC_NUM',l_doc_num);

1199: l_org_name;
1200: exit when l_checkREL_csr%NOTFOUND;
1201: l_failPORelCheck := 'T';
1202: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');
1203: fnd_message.set_token('DOC_NUM',l_doc_num);
1204: fnd_message.set_token('REL_NUM',l_rel_num);
1205: fnd_message.set_token('REV_NUM',l_revision_num);
1206: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1207: fnd_message.set_token('LINE_NUM',l_error_ln);

Line 1204: fnd_message.set_token('REL_NUM',l_rel_num);

1200: exit when l_checkREL_csr%NOTFOUND;
1201: l_failPORelCheck := 'T';
1202: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');
1203: fnd_message.set_token('DOC_NUM',l_doc_num);
1204: fnd_message.set_token('REL_NUM',l_rel_num);
1205: fnd_message.set_token('REV_NUM',l_revision_num);
1206: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1207: fnd_message.set_token('LINE_NUM',l_error_ln);
1208: fnd_message.set_token('OP_UNIT',l_org_name);

Line 1205: fnd_message.set_token('REV_NUM',l_revision_num);

1201: l_failPORelCheck := 'T';
1202: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');
1203: fnd_message.set_token('DOC_NUM',l_doc_num);
1204: fnd_message.set_token('REL_NUM',l_rel_num);
1205: fnd_message.set_token('REV_NUM',l_revision_num);
1206: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1207: fnd_message.set_token('LINE_NUM',l_error_ln);
1208: fnd_message.set_token('OP_UNIT',l_org_name);
1209: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

Line 1206: fnd_message.set_token('SHIP_NUM',l_po_shipment);

1202: fnd_message.set_name('POS','POS_EXASN_REL_NO_EXIST');
1203: fnd_message.set_token('DOC_NUM',l_doc_num);
1204: fnd_message.set_token('REL_NUM',l_rel_num);
1205: fnd_message.set_token('REV_NUM',l_revision_num);
1206: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1207: fnd_message.set_token('LINE_NUM',l_error_ln);
1208: fnd_message.set_token('OP_UNIT',l_org_name);
1209: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1210: raise l_25errors;

Line 1207: fnd_message.set_token('LINE_NUM',l_error_ln);

1203: fnd_message.set_token('DOC_NUM',l_doc_num);
1204: fnd_message.set_token('REL_NUM',l_rel_num);
1205: fnd_message.set_token('REV_NUM',l_revision_num);
1206: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1207: fnd_message.set_token('LINE_NUM',l_error_ln);
1208: fnd_message.set_token('OP_UNIT',l_org_name);
1209: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1210: raise l_25errors;
1211: end if;

Line 1208: fnd_message.set_token('OP_UNIT',l_org_name);

1204: fnd_message.set_token('REL_NUM',l_rel_num);
1205: fnd_message.set_token('REV_NUM',l_revision_num);
1206: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1207: fnd_message.set_token('LINE_NUM',l_error_ln);
1208: fnd_message.set_token('OP_UNIT',l_org_name);
1209: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1210: raise l_25errors;
1211: end if;
1212: end loop;

Line 1209: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

1205: fnd_message.set_token('REV_NUM',l_revision_num);
1206: fnd_message.set_token('SHIP_NUM',l_po_shipment);
1207: fnd_message.set_token('LINE_NUM',l_error_ln);
1208: fnd_message.set_token('OP_UNIT',l_org_name);
1209: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1210: raise l_25errors;
1211: end if;
1212: end loop;
1213: close l_checkREL_csr;

Line 1256: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');

1252: l_vendor_id||' is not secured');
1253: END IF;
1254:
1255: l_failSecure := 'T';
1256: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1257: fnd_message.set_token('LINE_NUM',l_error_ln);
1258: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN
1259: raise l_25errors;
1260: END IF;

Line 1257: fnd_message.set_token('LINE_NUM',l_error_ln);

1253: END IF;
1254:
1255: l_failSecure := 'T';
1256: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1257: fnd_message.set_token('LINE_NUM',l_error_ln);
1258: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN
1259: raise l_25errors;
1260: END IF;
1261: END IF;

Line 1258: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN

1254:
1255: l_failSecure := 'T';
1256: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1257: fnd_message.set_token('LINE_NUM',l_error_ln);
1258: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN
1259: raise l_25errors;
1260: END IF;
1261: END IF;
1262:

Line 1273: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');

1269: loop
1270: fetch l_checkVendorSites_csr into l_error_ln;
1271: exit when l_checkVendorSites_csr%NOTFOUND;
1272: l_failSecure := 'T';
1273: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1274: fnd_message.set_token('LINE_NUM',l_error_ln);
1275: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1276: raise l_25errors;
1277: end if;

Line 1274: fnd_message.set_token('LINE_NUM',l_error_ln);

1270: fetch l_checkVendorSites_csr into l_error_ln;
1271: exit when l_checkVendorSites_csr%NOTFOUND;
1272: l_failSecure := 'T';
1273: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1274: fnd_message.set_token('LINE_NUM',l_error_ln);
1275: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1276: raise l_25errors;
1277: end if;
1278: end loop;

Line 1275: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

1271: exit when l_checkVendorSites_csr%NOTFOUND;
1272: l_failSecure := 'T';
1273: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1274: fnd_message.set_token('LINE_NUM',l_error_ln);
1275: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1276: raise l_25errors;
1277: end if;
1278: end loop;
1279: close l_checkVendorSites_csr;

Line 1288: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');

1284: loop
1285: fetch l_checkVendorContacts_csr into l_error_ln;
1286: exit when l_checkVendorContacts_csr%NOTFOUND;
1287: l_failSecure := 'T';
1288: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1289: fnd_message.set_token('LINE_NUM',l_error_ln);
1290: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1291: raise l_25errors;
1292: end if;

Line 1289: fnd_message.set_token('LINE_NUM',l_error_ln);

1285: fetch l_checkVendorContacts_csr into l_error_ln;
1286: exit when l_checkVendorContacts_csr%NOTFOUND;
1287: l_failSecure := 'T';
1288: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1289: fnd_message.set_token('LINE_NUM',l_error_ln);
1290: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1291: raise l_25errors;
1292: end if;
1293: end loop;

Line 1290: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

1286: exit when l_checkVendorContacts_csr%NOTFOUND;
1287: l_failSecure := 'T';
1288: fnd_message.set_name('POS','POS_EXASN_NOT_SEC');
1289: fnd_message.set_token('LINE_NUM',l_error_ln);
1290: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1291: raise l_25errors;
1292: end if;
1293: end loop;
1294: close l_checkVendorContacts_csr;

Line 1337: fnd_message.set_name('POS','POS_EXASN_EXCEPT_UOM');

1333:
1334: l_tolerableShipQty := POS_CREATE_ASN.getTolerableShipmentQuantity(l_po_line_location_id);
1335:
1336: if(l_primary_Qty = -1) then
1337: fnd_message.set_name('POS','POS_EXASN_EXCEPT_UOM');
1338: --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.
1339: fnd_message.set_token('LINE_NUM',l_line_number);
1340: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1341: raise l_25errors;

Line 1339: fnd_message.set_token('LINE_NUM',l_line_number);

1335:
1336: if(l_primary_Qty = -1) then
1337: fnd_message.set_name('POS','POS_EXASN_EXCEPT_UOM');
1338: --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.
1339: fnd_message.set_token('LINE_NUM',l_line_number);
1340: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1341: raise l_25errors;
1342: end if;
1343: elsif(l_tolerableShipQty < l_primary_qty ) then

Line 1340: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

1336: if(l_primary_Qty = -1) then
1337: fnd_message.set_name('POS','POS_EXASN_EXCEPT_UOM');
1338: --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.
1339: fnd_message.set_token('LINE_NUM',l_line_number);
1340: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1341: raise l_25errors;
1342: end if;
1343: elsif(l_tolerableShipQty < l_primary_qty ) then
1344:

Line 1345: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');

1341: raise l_25errors;
1342: end if;
1343: elsif(l_tolerableShipQty < l_primary_qty ) then
1344:
1345: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1346: fnd_message.set_token('QTY',l_quantity);
1347: fnd_message.set_token('LINE_NUM',l_line_number);
1348: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1349: raise l_25errors;

Line 1346: fnd_message.set_token('QTY',l_quantity);

1342: end if;
1343: elsif(l_tolerableShipQty < l_primary_qty ) then
1344:
1345: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1346: fnd_message.set_token('QTY',l_quantity);
1347: fnd_message.set_token('LINE_NUM',l_line_number);
1348: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1349: raise l_25errors;
1350: end if;

Line 1347: fnd_message.set_token('LINE_NUM',l_line_number);

1343: elsif(l_tolerableShipQty < l_primary_qty ) then
1344:
1345: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1346: fnd_message.set_token('QTY',l_quantity);
1347: fnd_message.set_token('LINE_NUM',l_line_number);
1348: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1349: raise l_25errors;
1350: end if;
1351: end if;

Line 1348: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

1344:
1345: fnd_message.set_name('POS','POS_EXASN_QTY_GRT_REM');
1346: fnd_message.set_token('QTY',l_quantity);
1347: fnd_message.set_token('LINE_NUM',l_line_number);
1348: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1349: raise l_25errors;
1350: end if;
1351: end if;
1352: end if;

Line 1365: fnd_message.set_name('POS','POS_EXASN_ERDATE_TOL');

1361: from pos_exasn_headers
1362: where header_id = l_header_id;
1363:
1364: if(l_exp_rec_date > l_due_date+l_days_late OR l_exp_rec_date < l_due_date-l_days_early) then
1365: fnd_message.set_name('POS','POS_EXASN_ERDATE_TOL');
1366: fnd_message.set_token('HDR_LINE_NUM',l_header_line_number);
1367: fnd_message.set_token('LINE_NUM',l_line_number);
1368: --the expected receipt date defined in line HDR_LINE_NUM will violate the tolerance for PO Shipment at line LINE_NUM
1369: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

Line 1366: fnd_message.set_token('HDR_LINE_NUM',l_header_line_number);

1362: where header_id = l_header_id;
1363:
1364: if(l_exp_rec_date > l_due_date+l_days_late OR l_exp_rec_date < l_due_date-l_days_early) then
1365: fnd_message.set_name('POS','POS_EXASN_ERDATE_TOL');
1366: fnd_message.set_token('HDR_LINE_NUM',l_header_line_number);
1367: fnd_message.set_token('LINE_NUM',l_line_number);
1368: --the expected receipt date defined in line HDR_LINE_NUM will violate the tolerance for PO Shipment at line LINE_NUM
1369: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1370: raise l_25errors;

Line 1367: fnd_message.set_token('LINE_NUM',l_line_number);

1363:
1364: if(l_exp_rec_date > l_due_date+l_days_late OR l_exp_rec_date < l_due_date-l_days_early) then
1365: fnd_message.set_name('POS','POS_EXASN_ERDATE_TOL');
1366: fnd_message.set_token('HDR_LINE_NUM',l_header_line_number);
1367: fnd_message.set_token('LINE_NUM',l_line_number);
1368: --the expected receipt date defined in line HDR_LINE_NUM will violate the tolerance for PO Shipment at line LINE_NUM
1369: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1370: raise l_25errors;
1371: end if;

Line 1369: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

1365: fnd_message.set_name('POS','POS_EXASN_ERDATE_TOL');
1366: fnd_message.set_token('HDR_LINE_NUM',l_header_line_number);
1367: fnd_message.set_token('LINE_NUM',l_line_number);
1368: --the expected receipt date defined in line HDR_LINE_NUM will violate the tolerance for PO Shipment at line LINE_NUM
1369: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1370: raise l_25errors;
1371: end if;
1372: end if;
1373: end if;

Line 1376: fnd_message.set_name('POS','POS_EXASN_ERR_SHIKYU');

1372: end if;
1373: end if;
1374:
1375: if ( l_outsourced_assembly = 1 ) then
1376: fnd_message.set_name('POS','POS_EXASN_ERR_SHIKYU');
1377: fnd_message.set_token('LINE_NUM',l_line_number);
1378: -- Shipments can not be created using Outsourced assembly items
1379: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1380: raise l_25errors;

Line 1377: fnd_message.set_token('LINE_NUM',l_line_number);

1373: end if;
1374:
1375: if ( l_outsourced_assembly = 1 ) then
1376: fnd_message.set_name('POS','POS_EXASN_ERR_SHIKYU');
1377: fnd_message.set_token('LINE_NUM',l_line_number);
1378: -- Shipments can not be created using Outsourced assembly items
1379: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1380: raise l_25errors;
1381: end if;

Line 1379: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

1375: if ( l_outsourced_assembly = 1 ) then
1376: fnd_message.set_name('POS','POS_EXASN_ERR_SHIKYU');
1377: fnd_message.set_token('LINE_NUM',l_line_number);
1378: -- Shipments can not be created using Outsourced assembly items
1379: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1380: raise l_25errors;
1381: end if;
1382: end if;
1383: end loop;

Line 1401: fnd_message.set_name('POS','POS_EXASN_DUPE_SHIP');

1397: l_new_sn := 'F';
1398: end if;
1399:
1400: if(l_new_sn = 'T') then
1401: fnd_message.set_name('POS','POS_EXASN_DUPE_SHIP');
1402: --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.
1403: fnd_message.set_token('LINE_NUM',l_error_ln);
1404: fnd_message.set_token('SHIP_NUM',l_error_field);
1405: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

Line 1403: fnd_message.set_token('LINE_NUM',l_error_ln);

1399:
1400: if(l_new_sn = 'T') then
1401: fnd_message.set_name('POS','POS_EXASN_DUPE_SHIP');
1402: --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.
1403: fnd_message.set_token('LINE_NUM',l_error_ln);
1404: fnd_message.set_token('SHIP_NUM',l_error_field);
1405: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1406: raise l_25errors;
1407: end if;

Line 1404: fnd_message.set_token('SHIP_NUM',l_error_field);

1400: if(l_new_sn = 'T') then
1401: fnd_message.set_name('POS','POS_EXASN_DUPE_SHIP');
1402: --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.
1403: fnd_message.set_token('LINE_NUM',l_error_ln);
1404: fnd_message.set_token('SHIP_NUM',l_error_field);
1405: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1406: raise l_25errors;
1407: end if;
1408: end if;

Line 1405: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then

1401: fnd_message.set_name('POS','POS_EXASN_DUPE_SHIP');
1402: --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.
1403: fnd_message.set_token('LINE_NUM',l_error_ln);
1404: fnd_message.set_token('SHIP_NUM',l_error_field);
1405: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) then
1406: raise l_25errors;
1407: end if;
1408: end if;
1409:

Line 1509: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');

1505: open l_checkGrossWtUOM_csr;
1506: loop
1507: fetch l_checkGrossWtUOM_csr into l_error_ln, l_error_field;
1508: exit when l_checkGrossWtUOM_csr%NOTFOUND;
1509: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1510: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));
1511: fnd_message.set_token('LOV_VALUE',l_error_field);
1512: fnd_message.set_token('LINE_NUM',l_error_ln);
1513: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

Line 1510: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));

1506: loop
1507: fetch l_checkGrossWtUOM_csr into l_error_ln, l_error_field;
1508: exit when l_checkGrossWtUOM_csr%NOTFOUND;
1509: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1510: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));
1511: fnd_message.set_token('LOV_VALUE',l_error_field);
1512: fnd_message.set_token('LINE_NUM',l_error_ln);
1513: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1514: raise l_25errors;

Line 1511: fnd_message.set_token('LOV_VALUE',l_error_field);

1507: fetch l_checkGrossWtUOM_csr into l_error_ln, l_error_field;
1508: exit when l_checkGrossWtUOM_csr%NOTFOUND;
1509: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1510: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));
1511: fnd_message.set_token('LOV_VALUE',l_error_field);
1512: fnd_message.set_token('LINE_NUM',l_error_ln);
1513: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1514: raise l_25errors;
1515: end if;

Line 1512: fnd_message.set_token('LINE_NUM',l_error_ln);

1508: exit when l_checkGrossWtUOM_csr%NOTFOUND;
1509: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1510: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));
1511: fnd_message.set_token('LOV_VALUE',l_error_field);
1512: fnd_message.set_token('LINE_NUM',l_error_ln);
1513: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1514: raise l_25errors;
1515: end if;
1516: end loop;

Line 1513: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

1509: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1510: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_GWUOM'));
1511: fnd_message.set_token('LOV_VALUE',l_error_field);
1512: fnd_message.set_token('LINE_NUM',l_error_ln);
1513: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1514: raise l_25errors;
1515: end if;
1516: end loop;
1517: close l_checkGrossWtUOM_csr;

Line 1532: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');

1528: open l_checkNetWtUOM_csr;
1529: loop
1530: fetch l_checkNetWtUOM_csr into l_error_ln, l_error_field;
1531: exit when l_checkNetWtUOM_csr%NOTFOUND;
1532: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1533: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));
1534: fnd_message.set_token('LOV_VALUE',l_error_field);
1535: fnd_message.set_token('LINE_NUM',l_error_ln);
1536: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

Line 1533: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));

1529: loop
1530: fetch l_checkNetWtUOM_csr into l_error_ln, l_error_field;
1531: exit when l_checkNetWtUOM_csr%NOTFOUND;
1532: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1533: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));
1534: fnd_message.set_token('LOV_VALUE',l_error_field);
1535: fnd_message.set_token('LINE_NUM',l_error_ln);
1536: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1537: raise l_25errors;

Line 1534: fnd_message.set_token('LOV_VALUE',l_error_field);

1530: fetch l_checkNetWtUOM_csr into l_error_ln, l_error_field;
1531: exit when l_checkNetWtUOM_csr%NOTFOUND;
1532: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1533: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));
1534: fnd_message.set_token('LOV_VALUE',l_error_field);
1535: fnd_message.set_token('LINE_NUM',l_error_ln);
1536: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1537: raise l_25errors;
1538: end if;

Line 1535: fnd_message.set_token('LINE_NUM',l_error_ln);

1531: exit when l_checkNetWtUOM_csr%NOTFOUND;
1532: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1533: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));
1534: fnd_message.set_token('LOV_VALUE',l_error_field);
1535: fnd_message.set_token('LINE_NUM',l_error_ln);
1536: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1537: raise l_25errors;
1538: end if;
1539: end loop;

Line 1536: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

1532: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1533: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_NWUOM'));
1534: fnd_message.set_token('LOV_VALUE',l_error_field);
1535: fnd_message.set_token('LINE_NUM',l_error_ln);
1536: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1537: raise l_25errors;
1538: end if;
1539: end loop;
1540: close l_checkNetWtUOM_csr;

Line 1555: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');

1551: open l_checkTarWtUOM_csr;
1552: loop
1553: fetch l_checkTarWtUOM_csr into l_error_ln, l_error_field;
1554: exit when l_checkTarWtUOM_csr%NOTFOUND;
1555: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1556: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));
1557: fnd_message.set_token('LOV_VALUE',l_error_field);
1558: fnd_message.set_token('LINE_NUM',l_error_ln);
1559: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

Line 1556: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));

1552: loop
1553: fetch l_checkTarWtUOM_csr into l_error_ln, l_error_field;
1554: exit when l_checkTarWtUOM_csr%NOTFOUND;
1555: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1556: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));
1557: fnd_message.set_token('LOV_VALUE',l_error_field);
1558: fnd_message.set_token('LINE_NUM',l_error_ln);
1559: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1560: raise l_25errors;

Line 1557: fnd_message.set_token('LOV_VALUE',l_error_field);

1553: fetch l_checkTarWtUOM_csr into l_error_ln, l_error_field;
1554: exit when l_checkTarWtUOM_csr%NOTFOUND;
1555: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1556: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));
1557: fnd_message.set_token('LOV_VALUE',l_error_field);
1558: fnd_message.set_token('LINE_NUM',l_error_ln);
1559: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1560: raise l_25errors;
1561: end if;

Line 1558: fnd_message.set_token('LINE_NUM',l_error_ln);

1554: exit when l_checkTarWtUOM_csr%NOTFOUND;
1555: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1556: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));
1557: fnd_message.set_token('LOV_VALUE',l_error_field);
1558: fnd_message.set_token('LINE_NUM',l_error_ln);
1559: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1560: raise l_25errors;
1561: end if;
1562: end loop;

Line 1559: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

1555: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1556: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_TWUOM'));
1557: fnd_message.set_token('LOV_VALUE',l_error_field);
1558: fnd_message.set_token('LINE_NUM',l_error_ln);
1559: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1560: raise l_25errors;
1561: end if;
1562: end loop;
1563: close l_checkTarWtUOM_csr;

Line 1579: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');

1575: open l_checkFreightTerms_csr;
1576: loop
1577: fetch l_checkFreightTerms_csr into l_error_ln, l_error_field;
1578: exit when l_checkFreightTerms_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_FRTERM'));
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

Line 1580: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FRTERM'));

1576: loop
1577: fetch l_checkFreightTerms_csr into l_error_ln, l_error_field;
1578: exit when l_checkFreightTerms_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_FRTERM'));
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;

Line 1581: fnd_message.set_token('LOV_VALUE',l_error_field);

1577: fetch l_checkFreightTerms_csr into l_error_ln, l_error_field;
1578: exit when l_checkFreightTerms_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_FRTERM'));
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;

Line 1582: fnd_message.set_token('LINE_NUM',l_error_ln);

1578: exit when l_checkFreightTerms_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_FRTERM'));
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;

Line 1583: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

1579: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1580: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FRTERM'));
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_checkFreightTerms_csr;

Line 1594: fnd_message.set_name('POS','POS_EXASN_BAD_SHP_DATE');

1590: open l_checkShipDate_csr;
1591: loop
1592: fetch l_checkShipDate_csr into l_error_ln, l_error_field;
1593: exit when l_checkShipDate_csr%NOTFOUND;
1594: fnd_message.set_name('POS','POS_EXASN_BAD_SHP_DATE');
1595: fnd_message.set_token('LINE_NUM',l_error_ln);
1596: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1597: raise l_25errors;
1598: end if;

Line 1595: fnd_message.set_token('LINE_NUM',l_error_ln);

1591: loop
1592: fetch l_checkShipDate_csr into l_error_ln, l_error_field;
1593: exit when l_checkShipDate_csr%NOTFOUND;
1594: fnd_message.set_name('POS','POS_EXASN_BAD_SHP_DATE');
1595: fnd_message.set_token('LINE_NUM',l_error_ln);
1596: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1597: raise l_25errors;
1598: end if;
1599: end loop;

Line 1596: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

1592: fetch l_checkShipDate_csr into l_error_ln, l_error_field;
1593: exit when l_checkShipDate_csr%NOTFOUND;
1594: fnd_message.set_name('POS','POS_EXASN_BAD_SHP_DATE');
1595: fnd_message.set_token('LINE_NUM',l_error_ln);
1596: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1597: raise l_25errors;
1598: end if;
1599: end loop;
1600: close l_checkShipDate_csr;

Line 1607: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');

1603: open l_checkInvPT_csr;
1604: loop
1605: fetch l_checkInvPT_csr into l_error_ln, l_error_field;
1606: exit when l_checkInvPT_csr%NOTFOUND;
1607: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1608: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));
1609: fnd_message.set_token('LOV_VALUE',l_error_field);
1610: fnd_message.set_token('LINE_NUM',l_error_ln);
1611: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

Line 1608: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));

1604: loop
1605: fetch l_checkInvPT_csr into l_error_ln, l_error_field;
1606: exit when l_checkInvPT_csr%NOTFOUND;
1607: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1608: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));
1609: fnd_message.set_token('LOV_VALUE',l_error_field);
1610: fnd_message.set_token('LINE_NUM',l_error_ln);
1611: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1612: raise l_25errors;

Line 1609: fnd_message.set_token('LOV_VALUE',l_error_field);

1605: fetch l_checkInvPT_csr into l_error_ln, l_error_field;
1606: exit when l_checkInvPT_csr%NOTFOUND;
1607: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1608: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));
1609: fnd_message.set_token('LOV_VALUE',l_error_field);
1610: fnd_message.set_token('LINE_NUM',l_error_ln);
1611: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1612: raise l_25errors;
1613: end if;

Line 1610: fnd_message.set_token('LINE_NUM',l_error_ln);

1606: exit when l_checkInvPT_csr%NOTFOUND;
1607: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1608: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));
1609: fnd_message.set_token('LOV_VALUE',l_error_field);
1610: fnd_message.set_token('LINE_NUM',l_error_ln);
1611: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1612: raise l_25errors;
1613: end if;
1614: end loop;

Line 1611: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

1607: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
1608: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_PAYTERM'));
1609: fnd_message.set_token('LOV_VALUE',l_error_field);
1610: fnd_message.set_token('LINE_NUM',l_error_ln);
1611: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1612: raise l_25errors;
1613: end if;
1614: end loop;
1615: close l_checkInvPT_csr;

Line 1622: fnd_message.set_name('POS','POS_EXASN_ERDATE_SDATE');

1618: open l_checkER_Ship_csr;
1619: loop
1620: fetch l_checkER_Ship_csr into l_error_ln;
1621: exit when l_checkER_Ship_csr%NOTFOUND;
1622: fnd_message.set_name('POS','POS_EXASN_ERDATE_SDATE');
1623: fnd_message.set_token('LINE_NUM',l_error_ln);
1624: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1625: raise l_25errors;
1626: end if;

Line 1623: fnd_message.set_token('LINE_NUM',l_error_ln);

1619: loop
1620: fetch l_checkER_Ship_csr into l_error_ln;
1621: exit when l_checkER_Ship_csr%NOTFOUND;
1622: fnd_message.set_name('POS','POS_EXASN_ERDATE_SDATE');
1623: fnd_message.set_token('LINE_NUM',l_error_ln);
1624: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1625: raise l_25errors;
1626: end if;
1627: end loop;

Line 1624: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then

1620: fetch l_checkER_Ship_csr into l_error_ln;
1621: exit when l_checkER_Ship_csr%NOTFOUND;
1622: fnd_message.set_name('POS','POS_EXASN_ERDATE_SDATE');
1623: fnd_message.set_token('LINE_NUM',l_error_ln);
1624: if(InsertError(p_error_tbl, fnd_message.get, p_error_pointer)=1) then
1625: raise l_25errors;
1626: end if;
1627: end loop;
1628: close l_checkER_Ship_csr;

Line 2951: fnd_message.set_name('POS','POS_EXASN_ASBN_XHDR');

2947: into l_error_ln
2948: from pos_exasn_headers
2949: where header_id = l_ex_header_id;
2950:
2951: fnd_message.set_name('POS','POS_EXASN_ASBN_XHDR');
2952: fnd_message.set_token('LINE_NUM',l_error_ln);
2953: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
2954: raise l_early_exit;
2955: end if;

Line 2952: fnd_message.set_token('LINE_NUM',l_error_ln);

2948: from pos_exasn_headers
2949: where header_id = l_ex_header_id;
2950:
2951: fnd_message.set_name('POS','POS_EXASN_ASBN_XHDR');
2952: fnd_message.set_token('LINE_NUM',l_error_ln);
2953: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
2954: raise l_early_exit;
2955: end if;
2956: end if;

Line 2953: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

2949: where header_id = l_ex_header_id;
2950:
2951: fnd_message.set_name('POS','POS_EXASN_ASBN_XHDR');
2952: fnd_message.set_token('LINE_NUM',l_error_ln);
2953: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
2954: raise l_early_exit;
2955: end if;
2956: end if;
2957:

Line 3009: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');

3005: open l_checkFreightCC_csr;
3006: loop
3007: fetch l_checkFreightCC_csr into l_error_ln, l_fcc;
3008: exit when l_checkFreightCC_csr%NOTFOUND;
3009: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3010: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));
3011: fnd_message.set_token('LOV_VALUE',l_fcc);
3012: fnd_message.set_token('LINE_NUM',l_error_ln);
3013: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

Line 3010: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));

3006: loop
3007: fetch l_checkFreightCC_csr into l_error_ln, l_fcc;
3008: exit when l_checkFreightCC_csr%NOTFOUND;
3009: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3010: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));
3011: fnd_message.set_token('LOV_VALUE',l_fcc);
3012: fnd_message.set_token('LINE_NUM',l_error_ln);
3013: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3014: raise l_early_exit;

Line 3011: fnd_message.set_token('LOV_VALUE',l_fcc);

3007: fetch l_checkFreightCC_csr into l_error_ln, l_fcc;
3008: exit when l_checkFreightCC_csr%NOTFOUND;
3009: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3010: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));
3011: fnd_message.set_token('LOV_VALUE',l_fcc);
3012: fnd_message.set_token('LINE_NUM',l_error_ln);
3013: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3014: raise l_early_exit;
3015: end if;

Line 3012: fnd_message.set_token('LINE_NUM',l_error_ln);

3008: exit when l_checkFreightCC_csr%NOTFOUND;
3009: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3010: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));
3011: fnd_message.set_token('LOV_VALUE',l_fcc);
3012: fnd_message.set_token('LINE_NUM',l_error_ln);
3013: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3014: raise l_early_exit;
3015: end if;
3016: end loop;

Line 3013: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

3009: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3010: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_FCCODE'));
3011: fnd_message.set_token('LOV_VALUE',l_fcc);
3012: fnd_message.set_token('LINE_NUM',l_error_ln);
3013: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3014: raise l_early_exit;
3015: end if;
3016: end loop;
3017: close l_checkFreightCC_csr;

Line 3024: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');

3020: open l_shipFrom_Loc_csr;
3021: loop
3022: fetch l_shipFrom_Loc_csr into l_error_ln,l_ship_from_loc;
3023: exit when l_shipFrom_Loc_csr%NOTFOUND;
3024: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3025: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));
3026: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);
3027: fnd_message.set_token('LINE_NUM',l_error_ln);
3028: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

Line 3025: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));

3021: loop
3022: fetch l_shipFrom_Loc_csr into l_error_ln,l_ship_from_loc;
3023: exit when l_shipFrom_Loc_csr%NOTFOUND;
3024: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3025: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));
3026: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);
3027: fnd_message.set_token('LINE_NUM',l_error_ln);
3028: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3029: raise l_early_exit;

Line 3026: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);

3022: fetch l_shipFrom_Loc_csr into l_error_ln,l_ship_from_loc;
3023: exit when l_shipFrom_Loc_csr%NOTFOUND;
3024: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3025: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));
3026: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);
3027: fnd_message.set_token('LINE_NUM',l_error_ln);
3028: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3029: raise l_early_exit;
3030: end if;

Line 3027: fnd_message.set_token('LINE_NUM',l_error_ln);

3023: exit when l_shipFrom_Loc_csr%NOTFOUND;
3024: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3025: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));
3026: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);
3027: fnd_message.set_token('LINE_NUM',l_error_ln);
3028: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3029: raise l_early_exit;
3030: end if;
3031: end loop;

Line 3028: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

3024: fnd_message.set_name('POS','POS_EXASN_INVALID_LOV');
3025: fnd_message.set_token('LOV_NAME',fnd_message.get_string('POS','POS_EXASN_SHP_FROM'));
3026: fnd_message.set_token('LOV_VALUE',l_ship_from_loc);
3027: fnd_message.set_token('LINE_NUM',l_error_ln);
3028: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3029: raise l_early_exit;
3030: end if;
3031: end loop;
3032: close l_shipFrom_Loc_csr;

Line 3042: fnd_message.set_name('POS','POS_EXASN_NOTPAYSITE');

3038: open l_checkNotPaySite_csr;
3039: loop
3040: fetch l_checkNotPaySite_csr into l_error_ln;
3041: exit when l_checkNotPaySite_csr%notfound;
3042: fnd_message.set_name('POS','POS_EXASN_NOTPAYSITE');
3043: fnd_message.set_token('LINE_NUM',l_error_ln);
3044: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3045: raise l_early_exit;
3046: end if;

Line 3043: fnd_message.set_token('LINE_NUM',l_error_ln);

3039: loop
3040: fetch l_checkNotPaySite_csr into l_error_ln;
3041: exit when l_checkNotPaySite_csr%notfound;
3042: fnd_message.set_name('POS','POS_EXASN_NOTPAYSITE');
3043: fnd_message.set_token('LINE_NUM',l_error_ln);
3044: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3045: raise l_early_exit;
3046: end if;
3047: end loop;

Line 3044: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

3040: fetch l_checkNotPaySite_csr into l_error_ln;
3041: exit when l_checkNotPaySite_csr%notfound;
3042: fnd_message.set_name('POS','POS_EXASN_NOTPAYSITE');
3043: fnd_message.set_token('LINE_NUM',l_error_ln);
3044: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3045: raise l_early_exit;
3046: end if;
3047: end loop;
3048: close l_checkNotPaySite_csr;

Line 3576: fnd_message.set_name('POS','POS_EXASN_NT_LC');

3572: loop
3573: fetch l_checkLotControl_csr into l_error_ln;
3574: exit when l_checkLotControl_csr%NOTFOUND;
3575: --Item at line LINE_NUM is not lot controlled, therefore shall not have any lot information.
3576: fnd_message.set_name('POS','POS_EXASN_NT_LC');
3577: fnd_message.set_token('LINE_NUM',l_error_ln);
3578: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3579: raise l_25errors;
3580: end if;

Line 3577: fnd_message.set_token('LINE_NUM',l_error_ln);

3573: fetch l_checkLotControl_csr into l_error_ln;
3574: exit when l_checkLotControl_csr%NOTFOUND;
3575: --Item at line LINE_NUM is not lot controlled, therefore shall not have any lot information.
3576: fnd_message.set_name('POS','POS_EXASN_NT_LC');
3577: fnd_message.set_token('LINE_NUM',l_error_ln);
3578: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3579: raise l_25errors;
3580: end if;
3581: end loop;

Line 3578: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

3574: exit when l_checkLotControl_csr%NOTFOUND;
3575: --Item at line LINE_NUM is not lot controlled, therefore shall not have any lot information.
3576: fnd_message.set_name('POS','POS_EXASN_NT_LC');
3577: fnd_message.set_token('LINE_NUM',l_error_ln);
3578: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3579: raise l_25errors;
3580: end if;
3581: end loop;
3582: close l_checkLotControl_csr;

Line 3589: fnd_message.set_name('POS','POS_EXASN_NT_SC');

3585: loop
3586: fetch l_checkSerialControl_csr into l_error_ln;
3587: exit when l_checkSerialControl_csr%NOTFOUND;
3588: --Item at line LINE_NUM is not serial controlled, therefore shall not have any serial information.
3589: fnd_message.set_name('POS','POS_EXASN_NT_SC');
3590: fnd_message.set_token('LINE_NUM',l_error_ln);
3591: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3592: raise l_25errors;
3593: end if;

Line 3590: fnd_message.set_token('LINE_NUM',l_error_ln);

3586: fetch l_checkSerialControl_csr into l_error_ln;
3587: exit when l_checkSerialControl_csr%NOTFOUND;
3588: --Item at line LINE_NUM is not serial controlled, therefore shall not have any serial information.
3589: fnd_message.set_name('POS','POS_EXASN_NT_SC');
3590: fnd_message.set_token('LINE_NUM',l_error_ln);
3591: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3592: raise l_25errors;
3593: end if;
3594: end loop;

Line 3591: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

3587: exit when l_checkSerialControl_csr%NOTFOUND;
3588: --Item at line LINE_NUM is not serial controlled, therefore shall not have any serial information.
3589: fnd_message.set_name('POS','POS_EXASN_NT_SC');
3590: fnd_message.set_token('LINE_NUM',l_error_ln);
3591: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3592: raise l_25errors;
3593: end if;
3594: end loop;
3595: close l_checkSerialControl_csr;

Line 3602: fnd_message.set_name('POS','POS_EXASN_LPN_NOREF');

3598: loop
3599: fetch l_check_lpnref_csr into l_lpn, l_error_ln;
3600: exit when l_check_lpnref_csr%NOTFOUND;
3601: --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".
3602: fnd_message.set_name('POS','POS_EXASN_LPN_NOREF');
3603: fnd_message.set_token('LINE_NUM',l_error_ln);
3604: fnd_message.set_token('LPN',l_lpn);
3605: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3606: raise l_25errors;

Line 3603: fnd_message.set_token('LINE_NUM',l_error_ln);

3599: fetch l_check_lpnref_csr into l_lpn, l_error_ln;
3600: exit when l_check_lpnref_csr%NOTFOUND;
3601: --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".
3602: fnd_message.set_name('POS','POS_EXASN_LPN_NOREF');
3603: fnd_message.set_token('LINE_NUM',l_error_ln);
3604: fnd_message.set_token('LPN',l_lpn);
3605: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3606: raise l_25errors;
3607: end if;

Line 3604: fnd_message.set_token('LPN',l_lpn);

3600: exit when l_check_lpnref_csr%NOTFOUND;
3601: --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".
3602: fnd_message.set_name('POS','POS_EXASN_LPN_NOREF');
3603: fnd_message.set_token('LINE_NUM',l_error_ln);
3604: fnd_message.set_token('LPN',l_lpn);
3605: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3606: raise l_25errors;
3607: end if;
3608: end loop;

Line 3605: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

3601: --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".
3602: fnd_message.set_name('POS','POS_EXASN_LPN_NOREF');
3603: fnd_message.set_token('LINE_NUM',l_error_ln);
3604: fnd_message.set_token('LPN',l_lpn);
3605: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
3606: raise l_25errors;
3607: end if;
3608: end loop;
3609: close l_check_lpnref_csr;

Line 3956: fnd_message.set_name('POS','POS_EXASN_NOT_ORG_SEC');

3952: MODULE => 'pos.plsql.pos_asn_create_pvt.CheckSecuringAtt',
3953: MESSAGE => 'No data found for cursor: l_vendorId_csr');
3954: END IF;
3955:
3956: fnd_message.set_name('POS','POS_EXASN_NOT_ORG_SEC');
3957: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN
3958: null;
3959: END IF;
3960: x_return_status := 'E';

Line 3957: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN

3953: MESSAGE => 'No data found for cursor: l_vendorId_csr');
3954: END IF;
3955:
3956: fnd_message.set_name('POS','POS_EXASN_NOT_ORG_SEC');
3957: IF(InsertError(x_error_tbl, fnd_message.get, x_error_pointer)=1) THEN
3958: null;
3959: END IF;
3960: x_return_status := 'E';
3961: END;

Line 3993: fnd_message.set_name('POS','POS_EXASN_NOT_SITE_SEC');

3989: open l_vendorSite_csr(fnd_global.user_id);
3990: fetch l_vendorSite_csr into l_num;
3991: close l_vendorSite_csr;
3992: if(l_num is null) then
3993: fnd_message.set_name('POS','POS_EXASN_NOT_SITE_SEC');
3994: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer) = 1) then
3995: null;
3996: end if;
3997: x_return_status := 'E';

Line 3994: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer) = 1) then

3990: fetch l_vendorSite_csr into l_num;
3991: close l_vendorSite_csr;
3992: if(l_num is null) then
3993: fnd_message.set_name('POS','POS_EXASN_NOT_SITE_SEC');
3994: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer) = 1) then
3995: null;
3996: end if;
3997: x_return_status := 'E';
3998: end if;

Line 4030: fnd_message.set_name('POS','POS_EXASN_NOT_CT_SEC');

4026: open l_vendorContact_csr(fnd_global.user_id);
4027: fetch l_vendorContact_csr into l_num;
4028: close l_vendorContact_csr;
4029: if(l_num is null) then
4030: fnd_message.set_name('POS','POS_EXASN_NOT_CT_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';

Line 4031: if(InsertError(x_error_tbl, fnd_message.get, x_error_pointer) = 1) then

4027: fetch l_vendorContact_csr into l_num;
4028: close l_vendorContact_csr;
4029: if(l_num is null) then
4030: fnd_message.set_name('POS','POS_EXASN_NOT_CT_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:

Line 4214: fnd_message.set_name('POS','POS_EXASN_NEW_DUPE_SHIP');

4210: open l_checkDocAsn_csr;
4211: loop
4212: fetch l_checkDocAsn_csr into l_shipment_number;
4213: exit when l_checkDocAsn_csr%NOTFOUND;
4214: fnd_message.set_name('POS','POS_EXASN_NEW_DUPE_SHIP');
4215: --Shipment number SHIP_NUM is used more than once for shipments with the same vendor, vendor site.
4216: fnd_message.set_token('SHIP_NUM',l_shipment_number);
4217: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4218: raise l_25errors;

Line 4216: fnd_message.set_token('SHIP_NUM',l_shipment_number);

4212: fetch l_checkDocAsn_csr into l_shipment_number;
4213: exit when l_checkDocAsn_csr%NOTFOUND;
4214: fnd_message.set_name('POS','POS_EXASN_NEW_DUPE_SHIP');
4215: --Shipment number SHIP_NUM is used more than once for shipments with the same vendor, vendor site.
4216: fnd_message.set_token('SHIP_NUM',l_shipment_number);
4217: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4218: raise l_25errors;
4219: end if;
4220: end loop;

Line 4217: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

4213: exit when l_checkDocAsn_csr%NOTFOUND;
4214: fnd_message.set_name('POS','POS_EXASN_NEW_DUPE_SHIP');
4215: --Shipment number SHIP_NUM is used more than once for shipments with the same vendor, vendor site.
4216: fnd_message.set_token('SHIP_NUM',l_shipment_number);
4217: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4218: raise l_25errors;
4219: end if;
4220: end loop;
4221: close l_checkDocAsn_csr;

Line 4280: fnd_message.set_name('POS','POS_EXASN_PLPN_CONTRA');

4276: l_error_ln,
4277: l_error_ln2;
4278: exit when l_checkLpnContra_csr%NOTFOUND;
4279: --The Parent-Child relationships for license plate number at line LINE_NUM1 and LINE_NUM2 contradict each other.
4280: fnd_message.set_name('POS','POS_EXASN_PLPN_CONTRA');
4281: fnd_message.set_token('LINE_NUM1',l_error_ln);
4282: fnd_message.set_token('LINE_NUM2',l_error_ln2);
4283: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4284: raise l_25errors;

Line 4281: fnd_message.set_token('LINE_NUM1',l_error_ln);

4277: l_error_ln2;
4278: exit when l_checkLpnContra_csr%NOTFOUND;
4279: --The Parent-Child relationships for license plate number at line LINE_NUM1 and LINE_NUM2 contradict each other.
4280: fnd_message.set_name('POS','POS_EXASN_PLPN_CONTRA');
4281: fnd_message.set_token('LINE_NUM1',l_error_ln);
4282: fnd_message.set_token('LINE_NUM2',l_error_ln2);
4283: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4284: raise l_25errors;
4285: end if;

Line 4282: fnd_message.set_token('LINE_NUM2',l_error_ln2);

4278: exit when l_checkLpnContra_csr%NOTFOUND;
4279: --The Parent-Child relationships for license plate number at line LINE_NUM1 and LINE_NUM2 contradict each other.
4280: fnd_message.set_name('POS','POS_EXASN_PLPN_CONTRA');
4281: fnd_message.set_token('LINE_NUM1',l_error_ln);
4282: fnd_message.set_token('LINE_NUM2',l_error_ln2);
4283: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4284: raise l_25errors;
4285: end if;
4286: end loop;

Line 4283: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then

4279: --The Parent-Child relationships for license plate number at line LINE_NUM1 and LINE_NUM2 contradict each other.
4280: fnd_message.set_name('POS','POS_EXASN_PLPN_CONTRA');
4281: fnd_message.set_token('LINE_NUM1',l_error_ln);
4282: fnd_message.set_token('LINE_NUM2',l_error_ln2);
4283: if(InsertError(x_error_tbl, fnd_message.get, l_error_pointer)=1) then
4284: raise l_25errors;
4285: end if;
4286: end loop;
4287: close l_checkLpnContra_csr;