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_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 2595: if(l_lot_status <> FND_API.G_RET_STS_SUCCESS) then

2591: , p_n_attribute9 => l_NATTRIBUTE9
2592: , p_n_attribute10 => l_NATTRIBUTE10
2593: );
2594:
2595: if(l_lot_status <> FND_API.G_RET_STS_SUCCESS) then
2596: if(InsertError(p_error_tbl, 'Error while inserting Lot at line '||l_lot_ln, p_error_pointer)=1) then
2597: raise l_25errors;
2598: end if;
2599: end if;

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

2613: , p_license_plate_number => l_lpn
2614: , p_LPN_GROUP_ID => l_lpn_group_id
2615: , p_PARENT_LICENSE_PLATE_NUMBER => null
2616: );
2617: if(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
2618: if(InsertError(p_error_tbl, 'Error while inserting LPN at line '||l_lot_ln, p_error_pointer)=1) then
2619: raise l_25errors;
2620: end if;
2621: end if;

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

2749: , p_n_attribute10 => l_NATTRIBUTE10
2750: );
2751:
2752:
2753: if(l_ser_status <> FND_API.G_RET_STS_SUCCESS) then
2754: if(InsertError(p_error_tbl, 'Error while inserting Serial at line '||l_ser_ln, p_error_pointer)=1) then
2755: raise l_25errors;
2756: end if;
2757: end if;

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

2766: , p_license_plate_number => l_lpn
2767: , p_LPN_GROUP_ID => l_lpn_group_id
2768: , p_PARENT_LICENSE_PLATE_NUMBER => null
2769: );
2770: if(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
2771: if(InsertError(p_error_tbl, 'Error while inserting Lpn at line '||l_ser_ln, p_error_pointer)=1) then
2772: raise l_25errors;
2773: end if;
2774: end if;

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

2796: , p_LPN_GROUP_ID => l_lpn_group_id
2797: , p_PARENT_LICENSE_PLATE_NUMBER => l_parent_lpn
2798: );
2799:
2800: if(l_lpn_status <> FND_API.G_RET_STS_SUCCESS) then
2801: if(InsertError(p_error_tbl, 'Error while inserting Lpn at line '||l_lpn_ln, p_error_pointer)=1) then
2802: raise l_25errors;
2803: end if;
2804: end if;

Line 4163: x_return_status := FND_API.G_RET_STS_SUCCESS;

4159:
4160: begin
4161:
4162: x_progress := '000';
4163: x_return_status := FND_API.G_RET_STS_SUCCESS;
4164: x_error_tbl := POS_EXCELASN_ERROR_TABLE();
4165:
4166: --x_user_vendor_id will no longer be retrieved from the secured attribute,
4167: --ICX_SUPPLIER_ORG_ID

Line 4358: x_return_status := FND_API.G_RET_STS_ERROR;

4354: close l_buyerNotif_csr;
4355:
4356:
4357: exception when l_early_exp then
4358: x_return_status := FND_API.G_RET_STS_ERROR;
4359:
4360: when l_25errors then
4361: x_return_status := FND_API.G_RET_STS_ERROR;
4362:

Line 4361: x_return_status := FND_API.G_RET_STS_ERROR;

4357: exception when l_early_exp then
4358: x_return_status := FND_API.G_RET_STS_ERROR;
4359:
4360: when l_25errors then
4361: x_return_status := FND_API.G_RET_STS_ERROR;
4362:
4363: when others then
4364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4365: x_return_msg := 'Unexpected error in ProcessExcelAsn:'||x_progress||':'||sqlerrm;

Line 4364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4360: when l_25errors then
4361: x_return_status := FND_API.G_RET_STS_ERROR;
4362:
4363: when others then
4364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4365: x_return_msg := 'Unexpected error in ProcessExcelAsn:'||x_progress||':'||sqlerrm;
4366: if(InsertError(x_error_tbl, 'Unexpected error in ProcessExcelAsn:'||x_progress||':'||sqlerrm, l_error_pointer)=1) then
4367: null;
4368: end if;