DBA Data[Home] [Help]

APPS.AP_RECONCILIATION_PKG dependencies on APP_EXCEPTION

Line 131: APP_EXCEPTION.RAISE_EXCEPTION ;

127: ( X_CREATION_DATE IS NULL ) or
128: ( X_CREATED_BY IS NULL ) or
129: ( X_LAST_UPDATE_DATE IS NULL ) or
130: ( X_LAST_UPDATED_BY IS NULL ) ) THEN
131: APP_EXCEPTION.RAISE_EXCEPTION ;
132: END IF ;
133:
134: l_Trx_Bank_Amount := X_TRANSACTION_AMOUNT;
135: l_Errors_Bank_Amount := X_ERROR_AMOUNT;

Line 215: APP_EXCEPTION.RAISE_EXCEPTION ;

211: X_REQUEST_ID,
212: X_CALLING_SEQUENCE ) ;
213:
214: ELSE
215: APP_EXCEPTION.RAISE_EXCEPTION ;
216: END IF ;
217:
218: EXCEPTION
219: WHEN OTHERS THEN

Line 226: APP_EXCEPTION.RAISE_EXCEPTION;

222: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
223: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
224: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
225: END IF;
226: APP_EXCEPTION.RAISE_EXCEPTION;
227:
228:
229: END Recon_Payment_History;
230:

Line 337: APP_EXCEPTION.RAISE_EXCEPTION ;

333: X_REQUEST_ID => X_REQUEST_ID,
334: X_CALLING_SEQUENCE => CURRENT_CALLING_SEQUENCE ) ;
335:
336: ELSE
337: APP_EXCEPTION.RAISE_EXCEPTION ;
338: END IF ;
339:
340: EXCEPTION
341: WHEN NO_DATA_FOUND THEN

Line 343: APP_EXCEPTION.RAISE_EXCEPTION;

339:
340: EXCEPTION
341: WHEN NO_DATA_FOUND THEN
342: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
343: APP_EXCEPTION.RAISE_EXCEPTION;
344: WHEN OTHERS THEN
345: IF (SQLCODE <> -20001) THEN
346: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
347: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 351: APP_EXCEPTION.RAISE_EXCEPTION;

347: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
348: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
349: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
350: END IF;
351: APP_EXCEPTION.RAISE_EXCEPTION;
352:
353: END Recon_Payment_Maturity ;
354:
355:

Line 381: APP_EXCEPTION.RAISE_EXCEPTION;

377:
378: EXCEPTION
379: WHEN NO_DATA_FOUND THEN
380: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
381: APP_EXCEPTION.RAISE_EXCEPTION;
382: WHEN OTHERS THEN
383: IF (SQLCODE <> -20001) THEN
384: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
385: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 389: APP_EXCEPTION.RAISE_EXCEPTION;

385: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
386: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
387: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
388: END IF;
389: APP_EXCEPTION.RAISE_EXCEPTION;
390: END Delete_Payment_Maturity ;
391:
392:
393: /* *************************************************************************

Line 1378: APP_EXCEPTION.RAISE_EXCEPTION;

1374: IF pay_batch_cur%ISOPEN THEN
1375: CLOSE pay_batch_cur ;
1376: END IF ;
1377: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
1378: APP_EXCEPTION.RAISE_EXCEPTION;
1379: WHEN G_abort_it THEN
1380: IF pay_batch_cur%ISOPEN THEN
1381: CLOSE pay_batch_cur ;
1382: END IF ;

Line 1383: APP_EXCEPTION.RAISE_EXCEPTION;

1379: WHEN G_abort_it THEN
1380: IF pay_batch_cur%ISOPEN THEN
1381: CLOSE pay_batch_cur ;
1382: END IF ;
1383: APP_EXCEPTION.RAISE_EXCEPTION;
1384: WHEN cant_do_recon_acct THEN
1385: IF pay_batch_cur%ISOPEN THEN
1386: CLOSE pay_batch_cur ;
1387: END IF ;

Line 1389: APP_EXCEPTION.RAISE_EXCEPTION;

1385: IF pay_batch_cur%ISOPEN THEN
1386: CLOSE pay_batch_cur ;
1387: END IF ;
1388: FND_MESSAGE.SET_NAME('SQLAP', 'AP_RECON_CANT_RECONCILE');
1389: APP_EXCEPTION.RAISE_EXCEPTION;
1390: WHEN OTHERS THEN
1391: IF pay_batch_cur%ISOPEN THEN
1392: CLOSE pay_batch_cur ;
1393: END IF ;

Line 1400: APP_EXCEPTION.RAISE_EXCEPTION;

1396: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1398: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1399: END IF;
1400: APP_EXCEPTION.RAISE_EXCEPTION;
1401:
1402: END Recon_Payment_Clearing ;
1403:
1404:

Line 1802: APP_EXCEPTION.RAISE_EXCEPTION;

1798:
1799: EXCEPTION
1800: WHEN NO_DATA_FOUND THEN
1801: FND_MESSAGE.SET_NAME('SQLAP','AP_RECON_NO_DATA_FOUND');
1802: APP_EXCEPTION.RAISE_EXCEPTION;
1803: WHEN OTHERS THEN
1804: IF (SQLCODE <> -20001) THEN
1805: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1806: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);

Line 1810: APP_EXCEPTION.RAISE_EXCEPTION;

1806: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1807: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',current_calling_sequence);
1808: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1809: END IF;
1810: APP_EXCEPTION.RAISE_EXCEPTION;
1811: END Recon_Payment_Unclearing ;
1812:
1813: --============================================================================
1814: -- INSERT_PAYMENT_HISTORY : API to insert a row into the AP_Payment_History

Line 2070: APP_EXCEPTION.RAISE_EXCEPTION;

2066: ||' X_program_id = '||to_char(x_program_id)
2067: ||' X_request_id = '||to_char(x_request_id));
2068: FND_MESSAGE.SET_TOKEN('DEBUG_INFO', l_debug_info);
2069: END IF;
2070: APP_EXCEPTION.RAISE_EXCEPTION;
2071:
2072: END Insert_Payment_History;
2073:
2074: