1063: -- EXECEPTION HANDLING TO GMS_AP_API TO SUPPORT CODE HOOK IN AP APPROVAL.
1064: -- Added exception handling routine.
1065: EXCEPTION
1066: WHEN AWARD_NOT_FOUND THEN
1067: fnd_message.set_name('GMS','GMS_INVALID_AWARD_FOUND');
1068: --
1069: -- Message : Incorrect award is associated with the invoice id : ??? and
1070: -- distribution line number : ??????. Please change award information
1071: -- on the distribution line.
1069: -- Message : Incorrect award is associated with the invoice id : ??? and
1070: -- distribution line number : ??????. Please change award information
1071: -- on the distribution line.
1072:
1073: fnd_message.set_token('INVNUM',l_invoice_num);
1074: fnd_message.set_token('DISTLNO', l_distribution_line_number(l_count));
1075: app_exception.raise_exception;
1076:
1077: WHEN OTHERS THEN
1070: -- distribution line number : ??????. Please change award information
1071: -- on the distribution line.
1072:
1073: fnd_message.set_token('INVNUM',l_invoice_num);
1074: fnd_message.set_token('DISTLNO', l_distribution_line_number(l_count));
1075: app_exception.raise_exception;
1076:
1077: WHEN OTHERS THEN
1078: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
1074: fnd_message.set_token('DISTLNO', l_distribution_line_number(l_count));
1075: app_exception.raise_exception;
1076:
1077: WHEN OTHERS THEN
1078: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
1079: fnd_message.set_token('PROGRAM_NAME',NVL(p_calling_sequence,' ')||'->gms_ap_api.verify_create_adls');
1080: fnd_message.set_token('OERRNO',to_char(sqlcode));
1081: fnd_message.set_token('OERRM',sqlerrm);
1082: app_exception.raise_exception;
1075: app_exception.raise_exception;
1076:
1077: WHEN OTHERS THEN
1078: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
1079: fnd_message.set_token('PROGRAM_NAME',NVL(p_calling_sequence,' ')||'->gms_ap_api.verify_create_adls');
1080: fnd_message.set_token('OERRNO',to_char(sqlcode));
1081: fnd_message.set_token('OERRM',sqlerrm);
1082: app_exception.raise_exception;
1083:
1076:
1077: WHEN OTHERS THEN
1078: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
1079: fnd_message.set_token('PROGRAM_NAME',NVL(p_calling_sequence,' ')||'->gms_ap_api.verify_create_adls');
1080: fnd_message.set_token('OERRNO',to_char(sqlcode));
1081: fnd_message.set_token('OERRM',sqlerrm);
1082: app_exception.raise_exception;
1083:
1084: -- EXECEPTION HANDLING TO GMS_AP_API TO SUPPORT CODE HOOK IN AP APPROVAL.
1077: WHEN OTHERS THEN
1078: fnd_message.set_name('GMS','GMS_UNEXPECTED_ERROR');
1079: fnd_message.set_token('PROGRAM_NAME',NVL(p_calling_sequence,' ')||'->gms_ap_api.verify_create_adls');
1080: fnd_message.set_token('OERRNO',to_char(sqlcode));
1081: fnd_message.set_token('OERRM',sqlerrm);
1082: app_exception.raise_exception;
1083:
1084: -- EXECEPTION HANDLING TO GMS_AP_API TO SUPPORT CODE HOOK IN AP APPROVAL.
1085: -- Bug 3077074 End here