DBA Data[Home] [Help]

APPS.AP_BANK_CHARGE_PKG dependencies on APP_EXCEPTION

Line 73: APP_EXCEPTION.RAISE_EXCEPTION;

69: when NO_DATA_FOUND then
70: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
71: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
72: FND_MESSAGE.set_TOKEN('DEBUG_INFO', 'Bank Branch Info can not be derived');
73: APP_EXCEPTION.RAISE_EXCEPTION;
74: when OTHERS then
75: IF (SQLCODE <> -20001) THEN
76: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
77: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

Line 81: APP_EXCEPTION.RAISE_EXCEPTION;

77: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
78: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
79: END IF;
80:
81: APP_EXCEPTION.RAISE_EXCEPTION;
82:
83: END get_bank_branch_name;
84:
85: PROCEDURE CHECK_BANK_COMBINATION(

Line 262: APP_EXCEPTION.RAISE_EXCEPTION;

258: end if;
259: EXCEPTION
260: WHEN RECORD_EXIST THEN
261: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CHARGE_EXIST');
262: APP_EXCEPTION.RAISE_EXCEPTION;
263: WHEN NO_DATA_FOUND THEN
264: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
265: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
266: FND_MESSAGE.set_TOKEN('DEBUG_INFO', 'Transferring and Receiving Bank Combination'||

Line 268: APP_EXCEPTION.RAISE_EXCEPTION;

264: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
265: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
266: FND_MESSAGE.set_TOKEN('DEBUG_INFO', 'Transferring and Receiving Bank Combination'||
267: ' is Invalid');
268: APP_EXCEPTION.RAISE_EXCEPTION;
269: WHEN OTHERS then
270: IF (SQLCODE <> -20001) THEN
271: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
272: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

Line 346: APP_EXCEPTION.RAISE_EXCEPTION;

342:
343: EXCEPTION
344: WHEN AMOUNT_OVERLAP THEN
345: FND_MESSAGE.SET_NAME('SQLAP', 'AP_GAPS');
346: APP_EXCEPTION.RAISE_EXCEPTION;
347: WHEN OTHERS THEN
348: IF (SQLCODE <> -20001) THEN
349: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
350: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

Line 353: APP_EXCEPTION.RAISE_EXCEPTION;

349: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
350: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
351: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
352: END IF;
353: APP_EXCEPTION.RAISE_EXCEPTION;
354: END CHECK_RANGE_OVERLAP;
355:
356: PROCEDURE CHECK_RANGE_GAP(X_bank_charge_id IN NUMBER) IS
357:

Line 425: APP_EXCEPTION.RAISE_EXCEPTION;

421: end if;
422: EXCEPTION
423: WHEN AMOUNT_GAP THEN
424: FND_MESSAGE.SET_NAME('SQLAP', 'AP_GAPS');
425: APP_EXCEPTION.RAISE_EXCEPTION;
426: WHEN START_ZERO THEN
427: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NEED_ZERO');
428: APP_EXCEPTION.RAISE_EXCEPTION;
429: WHEN OTHERS THEN

Line 428: APP_EXCEPTION.RAISE_EXCEPTION;

424: FND_MESSAGE.SET_NAME('SQLAP', 'AP_GAPS');
425: APP_EXCEPTION.RAISE_EXCEPTION;
426: WHEN START_ZERO THEN
427: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NEED_ZERO');
428: APP_EXCEPTION.RAISE_EXCEPTION;
429: WHEN OTHERS THEN
430: IF (SQLCODE <> -20001) THEN
431: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
432: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

Line 435: APP_EXCEPTION.RAISE_EXCEPTION;

431: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
432: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
433: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
434: END IF;
435: APP_EXCEPTION.RAISE_EXCEPTION;
436: END CHECK_RANGE_GAP;
437:
438: PROCEDURE CHECK_LAST_RANGE(X_bank_charge_id IN NUMBER) IS
439: CURSOR C_lines(P_bank_charge_id NUMBER) IS

Line 520: APP_EXCEPTION.RAISE_EXCEPTION;

516: end if;
517: EXCEPTION
518: WHEN AMOUNT_GAP THEN
519: FND_MESSAGE.SET_NAME('SQLAP', 'AP_GAPS');
520: APP_EXCEPTION.RAISE_EXCEPTION;
521: WHEN AMOUNT_OVERLAP THEN
522: FND_MESSAGE.SET_NAME('SQLAP', 'AP_OVERLAP1');
523: APP_EXCEPTION.RAISE_EXCEPTION;
524: WHEN NO_DATA_FOUND THEN

Line 523: APP_EXCEPTION.RAISE_EXCEPTION;

519: FND_MESSAGE.SET_NAME('SQLAP', 'AP_GAPS');
520: APP_EXCEPTION.RAISE_EXCEPTION;
521: WHEN AMOUNT_OVERLAP THEN
522: FND_MESSAGE.SET_NAME('SQLAP', 'AP_OVERLAP1');
523: APP_EXCEPTION.RAISE_EXCEPTION;
524: WHEN NO_DATA_FOUND THEN
525: FND_MESSAGE.SET_NAME('SQLAP', 'AP_LAST4');
526: APP_EXCEPTION.RAISE_EXCEPTION;
527: WHEN TOO_MANY_ROWS THEN

Line 526: APP_EXCEPTION.RAISE_EXCEPTION;

522: FND_MESSAGE.SET_NAME('SQLAP', 'AP_OVERLAP1');
523: APP_EXCEPTION.RAISE_EXCEPTION;
524: WHEN NO_DATA_FOUND THEN
525: FND_MESSAGE.SET_NAME('SQLAP', 'AP_LAST4');
526: APP_EXCEPTION.RAISE_EXCEPTION;
527: WHEN TOO_MANY_ROWS THEN
528: FND_MESSAGE.SET_NAME('SQLAP', 'AP_LAST5');
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: WHEN OTHERS THEN

Line 529: APP_EXCEPTION.RAISE_EXCEPTION;

525: FND_MESSAGE.SET_NAME('SQLAP', 'AP_LAST4');
526: APP_EXCEPTION.RAISE_EXCEPTION;
527: WHEN TOO_MANY_ROWS THEN
528: FND_MESSAGE.SET_NAME('SQLAP', 'AP_LAST5');
529: APP_EXCEPTION.RAISE_EXCEPTION;
530: WHEN OTHERS THEN
531: IF (SQLCODE <> -20001) THEN
532: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
533: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

Line 536: APP_EXCEPTION.RAISE_EXCEPTION;

532: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
533: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
534: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
535: END IF;
536: APP_EXCEPTION.RAISE_EXCEPTION;
537:
538: END CHECK_LAST_RANGE;
539:
540: PROCEDURE GET_BANK_CHARGE(

Line 912: --APP_EXCEPTION.RAISE_EXCEPTION;

908: WHEN NO_BANK_CHARGES THEN
909: p_tolerance_limit := NULL;
910: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');
911: FND_MSG_PUB.ADD;
912: --APP_EXCEPTION.RAISE_EXCEPTION;
913: WHEN NO_DATA_FOUND THEN
914: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');
915: FND_MSG_PUB.ADD;
916: p_tolerance_limit := NULL;

Line 917: --APP_EXCEPTION.RAISE_EXCEPTION;

913: WHEN NO_DATA_FOUND THEN
914: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');
915: FND_MSG_PUB.ADD;
916: p_tolerance_limit := NULL;
917: --APP_EXCEPTION.RAISE_EXCEPTION;
918: WHEN OTHERS THEN
919: IF (SQLCODE <> -20001) THEN
920: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
921: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

Line 926: --APP_EXCEPTION.RAISE_EXCEPTION;

922: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
923: END IF;
924: p_tolerance_limit := NULL;
925: FND_MSG_PUB.ADD;
926: --APP_EXCEPTION.RAISE_EXCEPTION;
927:
928:
929: END GET_BANK_CHARGE;
930:

Line 1440: --APP_EXCEPTION.RAISE_EXCEPTION;

1436: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1437: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1438: ' p_selected_check_id = '||to_char(p_selected_check_id));
1439: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);
1440: --APP_EXCEPTION.RAISE_EXCEPTION;
1441:
1442: RETURN (FALSE);
1443:
1444: END bank_charge_get_amt_due;

Line 1714: --APP_EXCEPTION.RAISE_EXCEPTION;

1710: ||' l_payment_date = '||to_char(l_payment_date) );
1711: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1712: FND_MSG_PUB.ADD;
1713: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1714: --APP_EXCEPTION.RAISE_EXCEPTION;
1715:
1716: END;
1717:
1718: -------------------------------------------------

Line 1816: --APP_EXCEPTION.RAISE_EXCEPTION;

1812: ||' l_payment_date = '||to_char(l_payment_date) );
1813: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
1814: FND_MSG_PUB.ADD;
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: --APP_EXCEPTION.RAISE_EXCEPTION;
1817:
1818:
1819: END;
1820: