DBA Data[Home] [Help]

APPS.AP_AUTOSELECT_PKG dependencies on FND_MESSAGE

Line 196: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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: '||

Line 197: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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));

Line 198: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_calling_sequence );

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:

Line 199: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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;

Line 200: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

Line 231: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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: '||

Line 232: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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);

Line 233: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

Line 234: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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;

Line 235: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_name: '||

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;

Line 620: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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: '||

Line 621: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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));

Line 622: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

Line 623: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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;

Line 624: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

Line 667: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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: '||

Line 668: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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));

Line 669: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

Line 670: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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;

Line 671: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

Line 769: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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: '||

Line 770: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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));

Line 771: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

Line 772: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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;

Line 773: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

Line 1309: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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: '||

Line 1310: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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);

Line 1311: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

Line 1312: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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:

Line 1313: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_payment_process_request_name: '||

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;

Line 1942: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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:

Line 1943: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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;

Line 2214: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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= '||

Line 2215: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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));

Line 2216: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

Line 2217: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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:

Line 2218: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_template_id= '||

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;

Line 5292: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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

Line 5293: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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

Line 5294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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

Line 5295: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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

Line 5296: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id

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);

Line 6117: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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: '||

Line 6118: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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));

Line 6119: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

Line 6120: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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;

Line 6121: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

Line 6246: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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: '||

Line 6247: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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));

Line 6248: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

Line 6249: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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;

Line 6250: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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;

Line 6373: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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);

Line 6374: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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:

Line 6375: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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:

Line 6376: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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:

Line 6377: FND_MESSAGE.SET_TOKEN('PARAMETERS','p_checkrun_id '||p_checkrun_id);

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;

Line 6511: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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: '||

Line 6512: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

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));

Line 6513: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_current_calling_sequence );

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;

Line 6514: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info );

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;

Line 6515: FND_MESSAGE.SET_TOKEN('PARAMETERS', 'p_checkrun_id: '||

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: