DBA Data[Home] [Help]

APPS.AP_BANK_CHARGE_PKG dependencies on FND_MESSAGE

Line 70: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

66: where branch_party_id = p_bank_branch_id;
67:
68: 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

Line 71: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

67:
68: 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

Line 72: FND_MESSAGE.set_TOKEN('DEBUG_INFO', 'Bank Branch Info can not be derived');

68: 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');

Line 76: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

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);
78: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
79: END IF;
80:

Line 77: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

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);
78: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
79: END IF;
80:
81: APP_EXCEPTION.RAISE_EXCEPTION;

Line 78: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);

74: when OTHERS then
75: IF (SQLCODE <> -20001) THEN
76: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
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:

Line 261: FND_MESSAGE.SET_NAME('SQLAP', 'AP_CHARGE_EXIST');

257: RAISE RECORD_EXIST;
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);

Line 264: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

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'||
267: ' is Invalid');
268: APP_EXCEPTION.RAISE_EXCEPTION;

Line 265: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

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'||
267: ' is Invalid');
268: APP_EXCEPTION.RAISE_EXCEPTION;
269: WHEN OTHERS then

Line 266: FND_MESSAGE.set_TOKEN('DEBUG_INFO', 'Transferring and Receiving Bank Combination'||

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'||
267: ' is Invalid');
268: APP_EXCEPTION.RAISE_EXCEPTION;
269: WHEN OTHERS then
270: IF (SQLCODE <> -20001) THEN

Line 271: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

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);
273: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
274: END IF;
275:

Line 272: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

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);
273: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
274: END IF;
275:
276: end CHECK_BANK_COMBINATION;

Line 273: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);

269: WHEN OTHERS then
270: IF (SQLCODE <> -20001) THEN
271: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
272: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
273: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
274: END IF;
275:
276: end CHECK_BANK_COMBINATION;
277:

Line 345: FND_MESSAGE.SET_NAME('SQLAP', 'AP_GAPS');

341: CLOSE C_lines;
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');

Line 349: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

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);
351: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
352: END IF;
353: APP_EXCEPTION.RAISE_EXCEPTION;

Line 350: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

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);
351: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
352: END IF;
353: APP_EXCEPTION.RAISE_EXCEPTION;
354: END CHECK_RANGE_OVERLAP;

Line 351: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);

347: WHEN OTHERS THEN
348: IF (SQLCODE <> -20001) THEN
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:

Line 424: FND_MESSAGE.SET_NAME('SQLAP', 'AP_GAPS');

420: RAISE START_ZERO;
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;

Line 427: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NEED_ZERO');

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
430: IF (SQLCODE <> -20001) THEN
431: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

Line 431: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

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);
433: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
434: END IF;
435: APP_EXCEPTION.RAISE_EXCEPTION;

Line 432: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

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);
433: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
434: END IF;
435: APP_EXCEPTION.RAISE_EXCEPTION;
436: END CHECK_RANGE_GAP;

Line 433: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);

429: WHEN OTHERS THEN
430: IF (SQLCODE <> -20001) THEN
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:

Line 519: FND_MESSAGE.SET_NAME('SQLAP', 'AP_GAPS');

515: RAISE TOO_MANY_ROWS;
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;

Line 522: FND_MESSAGE.SET_NAME('SQLAP', 'AP_OVERLAP1');

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
525: FND_MESSAGE.SET_NAME('SQLAP', 'AP_LAST4');
526: APP_EXCEPTION.RAISE_EXCEPTION;

Line 525: FND_MESSAGE.SET_NAME('SQLAP', 'AP_LAST4');

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
528: FND_MESSAGE.SET_NAME('SQLAP', 'AP_LAST5');
529: APP_EXCEPTION.RAISE_EXCEPTION;

Line 528: FND_MESSAGE.SET_NAME('SQLAP', 'AP_LAST5');

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
531: IF (SQLCODE <> -20001) THEN
532: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

Line 532: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

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);
534: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
535: END IF;
536: APP_EXCEPTION.RAISE_EXCEPTION;

Line 533: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

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);
534: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
535: END IF;
536: APP_EXCEPTION.RAISE_EXCEPTION;
537:

Line 534: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);

530: WHEN OTHERS THEN
531: IF (SQLCODE <> -20001) THEN
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;

Line 910: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');

906:
907: 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');

Line 914: FND_MESSAGE.SET_NAME('SQLAP', 'AP_NO_CHARGE_FOUND');

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;
917: --APP_EXCEPTION.RAISE_EXCEPTION;
918: WHEN OTHERS THEN

Line 920: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

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);
922: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
923: END IF;
924: p_tolerance_limit := NULL;

Line 921: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

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);
922: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
923: END IF;
924: p_tolerance_limit := NULL;
925: FND_MSG_PUB.ADD;

Line 922: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);

918: WHEN OTHERS THEN
919: IF (SQLCODE <> -20001) THEN
920: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
921: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
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;

Line 1281: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');

1277: P_check_bc_flag := 'N';
1278: P_do_not_pay_reason := 'NO BANK CHARGE';
1279: WHEN OTHERS THEN
1280: IF (SQLCODE <> -20001) THEN
1281: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
1282: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
1283: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
1284: END IF;
1285: FND_MSG_PUB.ADD;

Line 1282: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);

1278: P_do_not_pay_reason := 'NO BANK CHARGE';
1279: WHEN OTHERS THEN
1280: IF (SQLCODE <> -20001) THEN
1281: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
1282: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
1283: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
1284: END IF;
1285: FND_MSG_PUB.ADD;
1286:

Line 1283: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);

1279: WHEN OTHERS THEN
1280: IF (SQLCODE <> -20001) THEN
1281: FND_MESSAGE.set_NAME('SQLAP','AP_DEBUG');
1282: FND_MESSAGE.set_TOKEN('ERROR',SQLERRM);
1283: FND_MESSAGE.set_TOKEN('DEBUG_INFO',l_debug_info);
1284: END IF;
1285: FND_MSG_PUB.ADD;
1286:
1287: END CHECK_BANK_CHARGE;

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

1430: EXCEPTION
1431:
1432: WHEN OTHERS THEN
1433:
1434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
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));

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

1431:
1432: WHEN OTHERS THEN
1433:
1434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
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);

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

1432: WHEN OTHERS THEN
1433:
1434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
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;

Line 1437: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1433:
1434: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1435: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
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:

Line 1439: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',debug_info);

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

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

1696:
1697: EXCEPTION
1698: WHEN OTHERS THEN
1699:
1700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1703: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1704: ' l_bank_charge_bearer = ' ||l_bank_charge_bearer

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

1697: EXCEPTION
1698: WHEN OTHERS THEN
1699:
1700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1703: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1704: ' l_bank_charge_bearer = ' ||l_bank_charge_bearer
1705: ||' l_transferring_bank_branch_id = '||to_char(l_transferring_bank_branch_id)

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

1698: WHEN OTHERS THEN
1699:
1700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1703: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1704: ' l_bank_charge_bearer = ' ||l_bank_charge_bearer
1705: ||' l_transferring_bank_branch_id = '||to_char(l_transferring_bank_branch_id)
1706: ||' l_receiving_bank_branch_id = '||to_char(l_receiving_bank_branch_id)

Line 1703: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1699:
1700: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1701: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1702: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1703: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1704: ' l_bank_charge_bearer = ' ||l_bank_charge_bearer
1705: ||' l_transferring_bank_branch_id = '||to_char(l_transferring_bank_branch_id)
1706: ||' l_receiving_bank_branch_id = '||to_char(l_receiving_bank_branch_id)
1707: ||' l_transfer_priority = '||l_transfer_priority

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

1707: ||' l_transfer_priority = '||l_transfer_priority
1708: ||' l_currency_code = '||l_currency_code
1709: ||' l_amt_due = '||to_char(l_amt_due)
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:

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

1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: CLOSE selected_checks;
1802: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1803: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1804: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1805: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1806: ' l_bank_charge_bearer = ' ||l_bank_charge_bearer

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

1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: CLOSE selected_checks;
1802: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1803: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1804: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1805: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1806: ' l_bank_charge_bearer = ' ||l_bank_charge_bearer
1807: ||' l_transferring_bank_branch_id = '||to_char(l_transferring_bank_branch_id)

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

1800: WHEN OTHERS THEN
1801: CLOSE selected_checks;
1802: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1803: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1804: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1805: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1806: ' l_bank_charge_bearer = ' ||l_bank_charge_bearer
1807: ||' l_transferring_bank_branch_id = '||to_char(l_transferring_bank_branch_id)
1808: ||' l_receiving_bank_branch_id = '||to_char(l_receiving_bank_branch_id)

Line 1805: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1801: CLOSE selected_checks;
1802: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1803: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1804: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
1805: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1806: ' l_bank_charge_bearer = ' ||l_bank_charge_bearer
1807: ||' l_transferring_bank_branch_id = '||to_char(l_transferring_bank_branch_id)
1808: ||' l_receiving_bank_branch_id = '||to_char(l_receiving_bank_branch_id)
1809: ||' l_transfer_priority = '||l_transfer_priority

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

1809: ||' l_transfer_priority = '||l_transfer_priority
1810: ||' l_currency_code = '||l_currency_code
1811: ||' l_amt_due = '||to_char(l_amt_due)
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:

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

2066: CLOSE selected_checks;
2067:
2068: ROLLBACK TO AP_JAPANBANKCHARGEHOOK;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2070: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2072: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2074:

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

2067:
2068: ROLLBACK TO AP_JAPANBANKCHARGEHOOK;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2070: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2072: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2074:
2075: IF FND_MSG_PUB.Check_Msg_Level

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

2068: ROLLBACK TO AP_JAPANBANKCHARGEHOOK;
2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2070: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2072: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2074:
2075: IF FND_MSG_PUB.Check_Msg_Level
2076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

2069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2070: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2071: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2072: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', current_calling_sequence);
2073: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_debug_info);
2074:
2075: IF FND_MSG_PUB.Check_Msg_Level
2076: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2077: FND_MSG_PUB.Add_Exc_Msg