192:
193: WHEN OTHERS then
194:
195: IF (SQLCODE <> -20001) THEN
196: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
198: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence );
199: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
193: WHEN OTHERS then
194:
195: IF (SQLCODE <> -20001) THEN
196: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
198: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence );
199: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
201: to_char(p_checkrun_id));
194:
195: IF (SQLCODE <> -20001) THEN
196: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
198: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence );
199: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
201: to_char(p_checkrun_id));
202:
195: IF (SQLCODE <> -20001) THEN
196: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
198: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence );
199: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
201: to_char(p_checkrun_id));
202:
203: END IF;
196: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
198: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence );
199: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
201: to_char(p_checkrun_id));
202:
203: END IF;
204: APP_EXCEPTION.RAISE_EXCEPTION;
227: EXCEPTION
228: WHEN OTHERS then
229:
230: IF (SQLCODE <> -20001) THEN
231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
234: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
235: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||
228: WHEN OTHERS then
229:
230: IF (SQLCODE <> -20001) THEN
231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
234: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
235: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||
236: p_checkrun_name);
229:
230: IF (SQLCODE <> -20001) THEN
231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
234: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
235: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||
236: p_checkrun_name);
237:
230: IF (SQLCODE <> -20001) THEN
231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
234: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
235: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||
236: p_checkrun_name);
237:
238: END IF;
231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
234: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
235: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||
236: p_checkrun_name);
237:
238: END IF;
239: APP_EXCEPTION.RAISE_EXCEPTION;
616: exception
617: WHEN OTHERS then
618:
619: IF (SQLCODE <> -20001) THEN
620: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
621: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
622: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
623: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
624: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
617: WHEN OTHERS then
618:
619: IF (SQLCODE <> -20001) THEN
620: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
621: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
622: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
623: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
624: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
625: to_char(p_checkrun_id));
618:
619: IF (SQLCODE <> -20001) THEN
620: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
621: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
622: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
623: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
624: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
625: to_char(p_checkrun_id));
626:
619: IF (SQLCODE <> -20001) THEN
620: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
621: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
622: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
623: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
624: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
625: to_char(p_checkrun_id));
626:
627: END IF;
620: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
621: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
622: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
623: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
624: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
625: to_char(p_checkrun_id));
626:
627: END IF;
628: APP_EXCEPTION.RAISE_EXCEPTION;
663: exception
664: WHEN OTHERS then
665:
666: IF (SQLCODE <> -20001) THEN
667: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
668: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
669: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
671: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
664: WHEN OTHERS then
665:
666: IF (SQLCODE <> -20001) THEN
667: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
668: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
669: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
671: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
672: to_char(p_checkrun_id));
665:
666: IF (SQLCODE <> -20001) THEN
667: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
668: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
669: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
671: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
672: to_char(p_checkrun_id));
673:
666: IF (SQLCODE <> -20001) THEN
667: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
668: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
669: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
671: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
672: to_char(p_checkrun_id));
673:
674: END IF;
667: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
668: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
669: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
671: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
672: to_char(p_checkrun_id));
673:
674: END IF;
675: APP_EXCEPTION.RAISE_EXCEPTION;
765: exception
766: WHEN OTHERS then
767:
768: IF (SQLCODE <> -20001) THEN
769: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
770: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
771: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
772: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
773: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
766: WHEN OTHERS then
767:
768: IF (SQLCODE <> -20001) THEN
769: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
770: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
771: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
772: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
773: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
774: to_char(p_checkrun_id));
767:
768: IF (SQLCODE <> -20001) THEN
769: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
770: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
771: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
772: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
773: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
774: to_char(p_checkrun_id));
775:
768: IF (SQLCODE <> -20001) THEN
769: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
770: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
771: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
772: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
773: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
774: to_char(p_checkrun_id));
775:
776: END IF;
769: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
770: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
771: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
772: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
773: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
774: to_char(p_checkrun_id));
775:
776: END IF;
777: APP_EXCEPTION.RAISE_EXCEPTION;
1305: EXCEPTION
1306: WHEN OTHERS THEN
1307:
1308: IF (SQLCODE <> -20001) THEN
1309: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
1312: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
1313: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||
1306: WHEN OTHERS THEN
1307:
1308: IF (SQLCODE <> -20001) THEN
1309: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
1312: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
1313: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||
1314: p_payment_process_request_name);
1307:
1308: IF (SQLCODE <> -20001) THEN
1309: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
1312: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
1313: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||
1314: p_payment_process_request_name);
1315:
1308: IF (SQLCODE <> -20001) THEN
1309: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
1312: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
1313: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||
1314: p_payment_process_request_name);
1315:
1316:
1309: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
1312: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
1313: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||
1314: p_payment_process_request_name);
1315:
1316:
1317: END IF;
1938: EXCEPTION
1939: WHEN OTHERS THEN
1940:
1941: IF (SQLCODE <> -20001) THEN
1942: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1943: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1944: END IF;
1945: APP_EXCEPTION.RAISE_EXCEPTION;
1946:
1939: WHEN OTHERS THEN
1940:
1941: IF (SQLCODE <> -20001) THEN
1942: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1943: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1944: END IF;
1945: APP_EXCEPTION.RAISE_EXCEPTION;
1946:
1947: END GROUP_INTEREST_CREDITS;
2210: EXCEPTION
2211: WHEN OTHERS THEN
2212:
2213: IF (SQLCODE <> -20001) THEN
2214: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2215: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2216: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
2217: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
2218: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||
2211: WHEN OTHERS THEN
2212:
2213: IF (SQLCODE <> -20001) THEN
2214: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2215: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2216: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
2217: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
2218: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||
2219: to_char(p_template_id));
2212:
2213: IF (SQLCODE <> -20001) THEN
2214: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2215: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2216: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
2217: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
2218: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||
2219: to_char(p_template_id));
2220:
2213: IF (SQLCODE <> -20001) THEN
2214: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2215: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2216: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
2217: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
2218: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||
2219: to_char(p_template_id));
2220:
2221:
2214: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2215: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2216: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
2217: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
2218: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||
2219: to_char(p_template_id));
2220:
2221:
2222: END IF;
5288:
5289: WHEN OTHERS then
5290:
5291: IF (SQLCODE <> -20001) THEN
5292: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5293: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
5295: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
5296: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id
5289: WHEN OTHERS then
5290:
5291: IF (SQLCODE <> -20001) THEN
5292: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5293: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
5295: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
5296: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id
5297: ||',P_template_id '||P_template_id
5290:
5291: IF (SQLCODE <> -20001) THEN
5292: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5293: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
5295: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
5296: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id
5297: ||',P_template_id '||P_template_id
5298: ||',p_payment_date '||p_payment_date
5291: IF (SQLCODE <> -20001) THEN
5292: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5293: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
5295: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
5296: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id
5297: ||',P_template_id '||P_template_id
5298: ||',p_payment_date '||p_payment_date
5299: ||',p_pay_thru_date '||p_pay_thru_date
5292: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5293: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
5295: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
5296: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id
5297: ||',P_template_id '||P_template_id
5298: ||',p_payment_date '||p_payment_date
5299: ||',p_pay_thru_date '||p_pay_thru_date
5300: ||',p_pay_from_date '||p_pay_from_date);
6113: exception
6114: WHEN OTHERS then
6115:
6116: IF (SQLCODE <> -20001) THEN
6117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6120: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6121: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6114: WHEN OTHERS then
6115:
6116: IF (SQLCODE <> -20001) THEN
6117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6120: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6121: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6122: to_char(p_checkrun_id));
6115:
6116: IF (SQLCODE <> -20001) THEN
6117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6120: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6121: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6122: to_char(p_checkrun_id));
6123:
6116: IF (SQLCODE <> -20001) THEN
6117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6120: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6121: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6122: to_char(p_checkrun_id));
6123:
6124: END IF;
6117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6120: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6121: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6122: to_char(p_checkrun_id));
6123:
6124: END IF;
6125: APP_EXCEPTION.RAISE_EXCEPTION;
6242: exception
6243: WHEN OTHERS then
6244:
6245: IF (SQLCODE <> -20001) THEN
6246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6248: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6249: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6250: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6243: WHEN OTHERS then
6244:
6245: IF (SQLCODE <> -20001) THEN
6246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6248: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6249: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6250: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6251: to_char(p_checkrun_id));
6244:
6245: IF (SQLCODE <> -20001) THEN
6246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6248: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6249: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6250: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6251: to_char(p_checkrun_id));
6252:
6245: IF (SQLCODE <> -20001) THEN
6246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6248: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6249: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6250: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6251: to_char(p_checkrun_id));
6252:
6253: END IF;
6246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6248: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6249: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6250: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6251: to_char(p_checkrun_id));
6252:
6253: END IF;
6254: ROLLBACK;
6369:
6370: WHEN OTHERS then
6371:
6372: IF (SQLCODE <> -20001) THEN
6373: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6374: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6375: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6376: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6377: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);
6370: WHEN OTHERS then
6371:
6372: IF (SQLCODE <> -20001) THEN
6373: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6374: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6375: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6376: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6377: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);
6378:
6371:
6372: IF (SQLCODE <> -20001) THEN
6373: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6374: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6375: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6376: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6377: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);
6378:
6379:
6372: IF (SQLCODE <> -20001) THEN
6373: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6374: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6375: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6376: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6377: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);
6378:
6379:
6380:
6373: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6374: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6375: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6376: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6377: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);
6378:
6379:
6380:
6381: END IF;
6507: EXCEPTION
6508: WHEN OTHERS then
6509:
6510: IF (SQLCODE <> -20001) THEN
6511: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6512: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6513: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6515: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6508: WHEN OTHERS then
6509:
6510: IF (SQLCODE <> -20001) THEN
6511: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6512: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6513: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6515: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6516: to_char(p_checkrun_id));
6509:
6510: IF (SQLCODE <> -20001) THEN
6511: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6512: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6513: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6515: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6516: to_char(p_checkrun_id));
6517: END IF;
6510: IF (SQLCODE <> -20001) THEN
6511: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6512: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6513: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6515: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6516: to_char(p_checkrun_id));
6517: END IF;
6518: APP_EXCEPTION.RAISE_EXCEPTION;
6511: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6512: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6513: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );
6514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );
6515: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||
6516: to_char(p_checkrun_id));
6517: END IF;
6518: APP_EXCEPTION.RAISE_EXCEPTION;
6519: