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.AP_RECONCILIATION_PKG dependencies on FND_MESSAGE

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

246:
247: EXCEPTION
248: WHEN OTHERS THEN
249: IF (SQLCODE <> -20001) THEN
250: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
251: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
252: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
253: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
254: END IF;

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

247: EXCEPTION
248: WHEN OTHERS THEN
249: IF (SQLCODE <> -20001) THEN
250: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
251: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
252: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
253: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
254: END IF;
255: APP_EXCEPTION.RAISE_EXCEPTION;

Line 252: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

248: WHEN OTHERS THEN
249: IF (SQLCODE <> -20001) THEN
250: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
251: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
252: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
253: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
254: END IF;
255: APP_EXCEPTION.RAISE_EXCEPTION;
256:

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

249: IF (SQLCODE <> -20001) THEN
250: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
251: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
252: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
253: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
254: END IF;
255: APP_EXCEPTION.RAISE_EXCEPTION;
256:
257: END Recon_Payment_History;

Line 428: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');

424: END IF ;
425:
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN
428: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
429: APP_EXCEPTION.RAISE_EXCEPTION;
430: WHEN OTHERS THEN
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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

428: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
429: APP_EXCEPTION.RAISE_EXCEPTION;
430: WHEN OTHERS THEN
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
435: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
436: END IF;

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

429: APP_EXCEPTION.RAISE_EXCEPTION;
430: WHEN OTHERS THEN
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
435: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
436: END IF;
437: APP_EXCEPTION.RAISE_EXCEPTION;

Line 434: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

430: WHEN OTHERS THEN
431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
435: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
436: END IF;
437: APP_EXCEPTION.RAISE_EXCEPTION;
438:

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

431: IF (SQLCODE <> -20001) THEN
432: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
434: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
435: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
436: END IF;
437: APP_EXCEPTION.RAISE_EXCEPTION;
438:
439: END Recon_Payment_Maturity ;

Line 472: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');

468: AND nvl(posted_flag,'N') = 'N';
469:
470: EXCEPTION
471: WHEN NO_DATA_FOUND THEN
472: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
473: APP_EXCEPTION.RAISE_EXCEPTION;
474: WHEN OTHERS THEN
475: IF (SQLCODE <> -20001) THEN
476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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

472: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
473: APP_EXCEPTION.RAISE_EXCEPTION;
474: WHEN OTHERS THEN
475: IF (SQLCODE <> -20001) THEN
476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
479: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
480: END IF;

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

473: APP_EXCEPTION.RAISE_EXCEPTION;
474: WHEN OTHERS THEN
475: IF (SQLCODE <> -20001) THEN
476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
479: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
480: END IF;
481: APP_EXCEPTION.RAISE_EXCEPTION;

Line 478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

474: WHEN OTHERS THEN
475: IF (SQLCODE <> -20001) THEN
476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
479: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
480: END IF;
481: APP_EXCEPTION.RAISE_EXCEPTION;
482: END Delete_Payment_Maturity ;

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

475: IF (SQLCODE <> -20001) THEN
476: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
478: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
479: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
480: END IF;
481: APP_EXCEPTION.RAISE_EXCEPTION;
482: END Delete_Payment_Maturity ;
483:

Line 817: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_CLEARED_UNMATCHED');

813:
814: -- We cannot clear an already cleared check
815: IF ((X_MATCHED_FLAG <> 'Y' ) AND
816: (l_status_lookup_code IN ('CLEARED','CLEARED BUT UNACCOUNTED'))) THEN
817: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_CLEARED_UNMATCHED');
818: RAISE G_abort_it;
819: END IF ;
820:
821: IF (l_pay_sum_amt = 0) THEN

Line 1295: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_ALREADY_RECONCILED');

1291: WHERE c.check_id = X_CHECK_ID
1292: AND c.org_id = asp.org_id;
1293:
1294: IF ((l_status_lookup_code IN ('RECONCILED','RECONCILED UNACCOUNTED'))) THEN
1295: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_ALREADY_RECONCILED');
1296: RAISE G_abort_it;
1297: END IF ;
1298:
1299: IF ((l_status_lookup_code = 'ISSUED') And (l_future_pay_flag = 'Y' )) THEN

Line 1300: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_PAYMENT_NOT_MATURED');

1296: RAISE G_abort_it;
1297: END IF ;
1298:
1299: IF ((l_status_lookup_code = 'ISSUED') And (l_future_pay_flag = 'Y' )) THEN
1300: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_PAYMENT_NOT_MATURED');
1301: RAISE G_abort_it;
1302: END IF ;
1303:
1304: IF ((X_MATCHED_FLAG <> 'Y' ) And

Line 1306: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_CLEARED_UNMATCHED');

1302: END IF ;
1303:
1304: IF ((X_MATCHED_FLAG <> 'Y' ) And
1305: (l_status_lookup_code In ('CLEARED','CLEARED BUT UNACCOUNTED'))) THEN
1306: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_CLEARED_UNMATCHED');
1307: RAISE G_abort_it;
1308: END IF ;
1309: --------------------------------------------------------
1310: l_debug_info := 'checkrun is null, calling case_type';

Line 1704: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');

1700: WHEN NO_DATA_FOUND THEN
1701: IF pay_batch_cur%ISOPEN THEN
1702: CLOSE pay_batch_cur ;
1703: END IF ;
1704: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
1705: APP_EXCEPTION.RAISE_EXCEPTION;
1706: WHEN G_abort_it THEN
1707: IF pay_batch_cur%ISOPEN THEN
1708: CLOSE pay_batch_cur ;

Line 1715: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RECON_CANT_RECONCILE');

1711: WHEN cant_do_recon_acct THEN
1712: IF pay_batch_cur%ISOPEN THEN
1713: CLOSE pay_batch_cur ;
1714: END IF ;
1715: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RECON_CANT_RECONCILE');
1716: APP_EXCEPTION.RAISE_EXCEPTION;
1717: WHEN OTHERS THEN
1718: IF pay_batch_cur%ISOPEN THEN
1719: CLOSE pay_batch_cur ;

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

1718: IF pay_batch_cur%ISOPEN THEN
1719: CLOSE pay_batch_cur ;
1720: END IF ;
1721: IF (SQLCODE <> -20001) THEN
1722: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1723: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1724: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1725: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1726: END IF;

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

1719: CLOSE pay_batch_cur ;
1720: END IF ;
1721: IF (SQLCODE <> -20001) THEN
1722: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1723: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1724: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1725: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1726: END IF;
1727: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1724: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

1720: END IF ;
1721: IF (SQLCODE <> -20001) THEN
1722: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1723: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1724: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1725: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1726: END IF;
1727: APP_EXCEPTION.RAISE_EXCEPTION;
1728:

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

1721: IF (SQLCODE <> -20001) THEN
1722: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1723: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1724: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1725: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1726: END IF;
1727: APP_EXCEPTION.RAISE_EXCEPTION;
1728:
1729: END Recon_Payment_Clearing ;

Line 2149: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');

2145:
2146:
2147: EXCEPTION
2148: WHEN NO_DATA_FOUND THEN
2149: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
2150: APP_EXCEPTION.RAISE_EXCEPTION;
2151: WHEN OTHERS THEN
2152: IF (SQLCODE <> -20001) THEN
2153: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');

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

2149: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
2150: APP_EXCEPTION.RAISE_EXCEPTION;
2151: WHEN OTHERS THEN
2152: IF (SQLCODE <> -20001) THEN
2153: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2154: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2156: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2157: END IF;

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

2150: APP_EXCEPTION.RAISE_EXCEPTION;
2151: WHEN OTHERS THEN
2152: IF (SQLCODE <> -20001) THEN
2153: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2154: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2156: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2157: END IF;
2158: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);

2151: WHEN OTHERS THEN
2152: IF (SQLCODE <> -20001) THEN
2153: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2154: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2156: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2157: END IF;
2158: APP_EXCEPTION.RAISE_EXCEPTION;
2159: END Recon_Payment_Unclearing ;

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

2152: IF (SQLCODE <> -20001) THEN
2153: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2154: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2155: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
2156: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2157: END IF;
2158: APP_EXCEPTION.RAISE_EXCEPTION;
2159: END Recon_Payment_Unclearing ;
2160:

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

2416:
2417: EXCEPTION
2418: WHEN OTHERS THEN
2419: IF (SQLCODE <> -20001) then
2420: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2421: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2422: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2423: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2424: 'X_check_id = '||to_char(x_check_id)

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

2417: EXCEPTION
2418: WHEN OTHERS THEN
2419: IF (SQLCODE <> -20001) then
2420: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2421: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2422: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2423: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2424: 'X_check_id = '||to_char(x_check_id)
2425: ||' X_transaction_type = '||X_transaction_type

Line 2422: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);

2418: WHEN OTHERS THEN
2419: IF (SQLCODE <> -20001) then
2420: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2421: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2422: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2423: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2424: 'X_check_id = '||to_char(x_check_id)
2425: ||' X_transaction_type = '||X_transaction_type
2426: ||' X_accounting_date = '||to_char(x_accounting_date)

Line 2423: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2419: IF (SQLCODE <> -20001) then
2420: FND_MESSAGE.SET_NAME('SQLAP', 'AP_DEBUG');
2421: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
2422: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2423: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2424: 'X_check_id = '||to_char(x_check_id)
2425: ||' X_transaction_type = '||X_transaction_type
2426: ||' X_accounting_date = '||to_char(x_accounting_date)
2427: ||' X_trx_bank_amount = '||to_char(x_trx_bank_amount)

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

2450: ||' X_program_update_date = '||to_char(x_program_update_date)
2451: ||' X_program_application_id = '||to_char(x_program_application_id)
2452: ||' X_program_id = '||to_char(x_program_id)
2453: ||' X_request_id = '||to_char(x_request_id));
2454: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2455: END IF;
2456: APP_EXCEPTION.RAISE_EXCEPTION;
2457:
2458: END Insert_Payment_History;

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

2543: WHEN NO_DATA_FOUND THEN
2544: RETURN(TRUE);
2545: WHEN OTHERS THEN
2546: IF (SQLCODE <> -20001) THEN
2547: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2548: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2549: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_RECONCILATION_PKG.Clear_Check');
2550: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2551: END IF;

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

2544: RETURN(TRUE);
2545: WHEN OTHERS THEN
2546: IF (SQLCODE <> -20001) THEN
2547: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2548: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2549: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_RECONCILATION_PKG.Clear_Check');
2550: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2551: END IF;
2552: RETURN(FALSE);

Line 2549: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_RECONCILATION_PKG.Clear_Check');

2545: WHEN OTHERS THEN
2546: IF (SQLCODE <> -20001) THEN
2547: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2548: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2549: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_RECONCILATION_PKG.Clear_Check');
2550: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2551: END IF;
2552: RETURN(FALSE);
2553:

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

2546: IF (SQLCODE <> -20001) THEN
2547: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2548: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2549: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_RECONCILATION_PKG.Clear_Check');
2550: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2551: END IF;
2552: RETURN(FALSE);
2553:
2554: END UnClear_Check;

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

2629: RETURN(TRUE);
2630: EXCEPTION
2631: WHEN OTHERS THEN
2632: IF (SQLCODE <> -20001) THEN
2633: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_RECONCILATION_PKG.Recon_Update_Check');
2636: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2637: END IF;

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

2630: EXCEPTION
2631: WHEN OTHERS THEN
2632: IF (SQLCODE <> -20001) THEN
2633: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_RECONCILATION_PKG.Recon_Update_Check');
2636: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2637: END IF;
2638: RETURN(FALSE);

Line 2635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_RECONCILATION_PKG.Recon_Update_Check');

2631: WHEN OTHERS THEN
2632: IF (SQLCODE <> -20001) THEN
2633: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_RECONCILATION_PKG.Recon_Update_Check');
2636: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2637: END IF;
2638: RETURN(FALSE);
2639:

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

2632: IF (SQLCODE <> -20001) THEN
2633: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2634: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2635: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE','AP_RECONCILATION_PKG.Recon_Update_Check');
2636: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2637: END IF;
2638: RETURN(FALSE);
2639:
2640: END Recon_Update_Check;