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.

[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on FND_API

Line 581: if(l_lot_status= FND_API.G_RET_STS_SUCCESS AND l_lot_return_code= 'F')

577: , x_return_code => l_lot_return_code
578: , x_return_msg => l_lot_return_msg
579: );
580:
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');

Line 592: elsif(l_lot_status <> FND_API.G_RET_STS_SUCCESS) then

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
594: raise l_25errors;
595: end if;
596: end if;

Line 608: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')

604: , x_return_code => l_lpn_return_code
605: , x_return_msg => l_lpn_return_msg
606: );
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);

Line 618: elsif(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then

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
620: raise l_25errors;
621: end if;
622: end if;

Line 655: if(l_ser_status = FND_API.G_RET_STS_SUCCESS and l_ser_return_code = 'F')

651: , p_line_loc_id => l_po_line_loc_id
652: , x_return_code => l_ser_return_code
653: , x_return_msg => l_ser_return_msg);
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);

Line 667: elsif(l_ser_status <> FND_API.G_RET_STS_SUCCESS) then

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
669: raise l_25errors;
670: end if;
671: end if;

Line 682: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')

678: , x_return_code => l_lpn_return_code
679: , x_return_msg => l_lpn_return_msg
680: );
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);

Line 692: elsif(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then

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
694: raise l_25errors;
695: end if;
696: end if;

Line 721: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')

717: , x_return_code => l_lpn_return_code
718: , x_return_msg => l_lpn_return_msg
719: );
720:
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');

Line 733: elsif(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then

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
734: 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
735: raise l_25errors;
736: end if;
737: end if;

Line 749: if(l_lpn_status = FND_API.G_RET_STS_SUCCESS AND l_lpn_return_code = 'F')

745: , x_return_code => l_lpn_return_code
746: , x_return_msg => l_lpn_return_msg
747: );
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);

Line 760: elsif(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then

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
761: if(InsertError(x_error_tbl, 'Error while validating Parent License Plate Number at line: '||l_lpn_ln||':'||l_lpn_return_msg, x_error_pointer)=1) then
762: raise l_25errors;
763: end if;
764: end if;

Line 2665: if(l_lot_status <> FND_API.G_RET_STS_SUCCESS) then

2661: , p_n_attribute9 => l_NATTRIBUTE9
2662: , p_n_attribute10 => l_NATTRIBUTE10
2663: );
2664:
2665: if(l_lot_status <> FND_API.G_RET_STS_SUCCESS) then
2666: if(InsertError(p_error_tbl, 'Error while inserting Lot at line '||l_lot_ln, p_error_pointer)=1) then
2667: raise l_25errors;
2668: end if;
2669: end if;

Line 2687: if(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then

2683: , p_license_plate_number => l_lpn
2684: , p_LPN_GROUP_ID => l_lpn_group_id
2685: , p_PARENT_LICENSE_PLATE_NUMBER => null
2686: );
2687: if(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
2688: if(InsertError(p_error_tbl, 'Error while inserting LPN at line '||l_lot_ln, p_error_pointer)=1) then
2689: raise l_25errors;
2690: end if;
2691: end if;

Line 2823: if(l_ser_status <> FND_API.G_RET_STS_SUCCESS) then

2819: , p_n_attribute10 => l_NATTRIBUTE10
2820: );
2821:
2822:
2823: if(l_ser_status <> FND_API.G_RET_STS_SUCCESS) then
2824: if(InsertError(p_error_tbl, 'Error while inserting Serial at line '||l_ser_ln, p_error_pointer)=1) then
2825: raise l_25errors;
2826: end if;
2827: end if;

Line 2840: if(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then

2836: , p_license_plate_number => l_lpn
2837: , p_LPN_GROUP_ID => l_lpn_group_id
2838: , p_PARENT_LICENSE_PLATE_NUMBER => null
2839: );
2840: if(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
2841: if(InsertError(p_error_tbl, 'Error while inserting Lpn at line '||l_ser_ln, p_error_pointer)=1) then
2842: raise l_25errors;
2843: end if;
2844: end if;

Line 2870: if(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then

2866: , p_LPN_GROUP_ID => l_lpn_group_id
2867: , p_PARENT_LICENSE_PLATE_NUMBER => l_parent_lpn
2868: );
2869:
2870: if(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
2871: if(InsertError(p_error_tbl, 'Error while inserting Lpn at line '||l_lpn_ln, p_error_pointer)=1) then
2872: raise l_25errors;
2873: end if;
2874: end if;

Line 4237: x_return_status := FND_API.G_RET_STS_SUCCESS;

4233:
4234: begin
4235:
4236: x_progress := '000';
4237: x_return_status := FND_API.G_RET_STS_SUCCESS;
4238: x_error_tbl := POS_EXCELASN_ERROR_TABLE();
4239:
4240: --x_user_vendor_id will no longer be retrieved from the secured attribute,
4241: --ICX_SUPPLIER_ORG_ID

Line 4432: x_return_status := FND_API.G_RET_STS_ERROR;

4428: close l_buyerNotif_csr;
4429:
4430:
4431: exception when l_early_exp then
4432: x_return_status := FND_API.G_RET_STS_ERROR;
4433:
4434: when l_25errors then
4435: x_return_status := FND_API.G_RET_STS_ERROR;
4436:

Line 4435: x_return_status := FND_API.G_RET_STS_ERROR;

4431: exception when l_early_exp then
4432: x_return_status := FND_API.G_RET_STS_ERROR;
4433:
4434: when l_25errors then
4435: x_return_status := FND_API.G_RET_STS_ERROR;
4436:
4437: when others then
4438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4439: x_return_msg := 'Unexpected error in ProcessExcelAsn:'||x_progress||':'||sqlerrm;

Line 4438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4434: when l_25errors then
4435: x_return_status := FND_API.G_RET_STS_ERROR;
4436:
4437: when others then
4438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4439: x_return_msg := 'Unexpected error in ProcessExcelAsn:'||x_progress||':'||sqlerrm;
4440: if(InsertError(x_error_tbl, 'Unexpected error in ProcessExcelAsn:'||x_progress||':'||sqlerrm, l_error_pointer)=1) then
4441: null;
4442: end if;