APPS.AP_RECONCILIATION_PKG dependencies on APP_EXCEPTION

Line 146: APP_EXCEPTION.RAISE_EXCEPTION ;

142: ( X_CREATION_DATE IS NULL ) or
143: ( X_CREATED_BY IS NULL ) or
144: ( X_LAST_UPDATE_DATE IS NULL ) or
145: ( X_LAST_UPDATED_BY IS NULL ) ) THEN
146: APP_EXCEPTION.RAISE_EXCEPTION ;
147: END IF ;
148:
149: l_Trx_Bank_Amount := X_TRANSACTION_AMOUNT;
150: l_Errors_Bank_Amount := X_ERROR_AMOUNT;

Line 244: APP_EXCEPTION.RAISE_EXCEPTION ;

240: X_REQUEST_ID,
241: X_CALLING_SEQUENCE ) ;
242:
243: ELSE
244: APP_EXCEPTION.RAISE_EXCEPTION ;
245: END IF ;
246:
247: EXCEPTION
248: WHEN OTHERS THEN

Line 255: APP_EXCEPTION.RAISE_EXCEPTION;

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;
258:
259:

Line 423: APP_EXCEPTION.RAISE_EXCEPTION ;

419: X_REQUEST_ID => X_REQUEST_ID,
420: X_CALLING_SEQUENCE => CURRENT_CALLING_SEQUENCE ) ;
421:
422: ELSE
423: APP_EXCEPTION.RAISE_EXCEPTION ;
424: END IF ;
425:
426: EXCEPTION
427: WHEN NO_DATA_FOUND THEN

Line 429: APP_EXCEPTION.RAISE_EXCEPTION;

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');
433: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 437: APP_EXCEPTION.RAISE_EXCEPTION;

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 ;
440:
441:

Line 473: APP_EXCEPTION.RAISE_EXCEPTION;

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');
477: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 481: APP_EXCEPTION.RAISE_EXCEPTION;

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:
484:
485: /* *************************************************************************

Line 1705: APP_EXCEPTION.RAISE_EXCEPTION;

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 ;
1709: END IF ;

Line 1710: APP_EXCEPTION.RAISE_EXCEPTION;

1706: WHEN G_abort_it THEN
1707: IF pay_batch_cur%ISOPEN THEN
1708: CLOSE pay_batch_cur ;
1709: END IF ;
1710: APP_EXCEPTION.RAISE_EXCEPTION;
1711: WHEN cant_do_recon_acct THEN
1712: IF pay_batch_cur%ISOPEN THEN
1713: CLOSE pay_batch_cur ;
1714: END IF ;

Line 1716: APP_EXCEPTION.RAISE_EXCEPTION;

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 ;
1720: END IF ;

Line 1727: APP_EXCEPTION.RAISE_EXCEPTION;

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 ;
1730:
1731:

Line 2150: APP_EXCEPTION.RAISE_EXCEPTION;

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');
2154: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 2158: APP_EXCEPTION.RAISE_EXCEPTION;

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:
2161: --============================================================================
2162: -- INSERT_PAYMENT_HISTORY : API to insert a row into the AP_Payment_History

Line 2456: APP_EXCEPTION.RAISE_EXCEPTION;

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;
2459:
2460: