744: -- EXECEPTION HANDLING TO GMS_AP_API TO SUPPORT CODE HOOK IN AP APPROVAL.
745: -- Added exception handling routine.
746: EXCEPTION
747: WHEN AWARD_NOT_FOUND THEN
748: fnd_message.set_name('GMS','GMS_INVALID_AWARD_FOUND');
749: --
750: -- Message : Incorrect award is associated with the invoice id : ??? and
751: -- distribution line number : ??????. Please change award information
752: -- on the distribution line.
750: -- Message : Incorrect award is associated with the invoice id : ??? and
751: -- distribution line number : ??????. Please change award information
752: -- on the distribution line.
753:
754: fnd_message.set_token('INVNUM',l_invoice_num);
755: fnd_message.set_token('DISTLNO', l_distribution_line_number(l_count));
756: app_exception.raise_exception;
757:
758: WHEN OTHERS THEN
751: -- distribution line number : ??????. Please change award information
752: -- on the distribution line.
753:
754: fnd_message.set_token('INVNUM',l_invoice_num);
755: fnd_message.set_token('DISTLNO', l_distribution_line_number(l_count));
756: app_exception.raise_exception;
757:
758: WHEN OTHERS THEN
759: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
755: fnd_message.set_token('DISTLNO', l_distribution_line_number(l_count));
756: app_exception.raise_exception;
757:
758: WHEN OTHERS THEN
759: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
760: fnd_message.set_token('PROGRAM_NAME',NVL(p_calling_sequence,' ')||'->gms_ap_api.verify_create_adls');
761: fnd_message.set_token('OERRNO',to_char(sqlcode));
762: fnd_message.set_token('OERRM',sqlerrm);
763: app_exception.raise_exception;
756: app_exception.raise_exception;
757:
758: WHEN OTHERS THEN
759: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
760: fnd_message.set_token('PROGRAM_NAME',NVL(p_calling_sequence,' ')||'->gms_ap_api.verify_create_adls');
761: fnd_message.set_token('OERRNO',to_char(sqlcode));
762: fnd_message.set_token('OERRM',sqlerrm);
763: app_exception.raise_exception;
764:
757:
758: WHEN OTHERS THEN
759: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
760: fnd_message.set_token('PROGRAM_NAME',NVL(p_calling_sequence,' ')||'->gms_ap_api.verify_create_adls');
761: fnd_message.set_token('OERRNO',to_char(sqlcode));
762: fnd_message.set_token('OERRM',sqlerrm);
763: app_exception.raise_exception;
764:
765: -- EXECEPTION HANDLING TO GMS_AP_API TO SUPPORT CODE HOOK IN AP APPROVAL.
758: WHEN OTHERS THEN
759: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
760: fnd_message.set_token('PROGRAM_NAME',NVL(p_calling_sequence,' ')||'->gms_ap_api.verify_create_adls');
761: fnd_message.set_token('OERRNO',to_char(sqlcode));
762: fnd_message.set_token('OERRM',sqlerrm);
763: app_exception.raise_exception;
764:
765: -- EXECEPTION HANDLING TO GMS_AP_API TO SUPPORT CODE HOOK IN AP APPROVAL.
766: -- Bug 3077074 End here