DBA Data[Home] [Help]

APPS.AP_PAY_IN_FULL_PKG dependencies on FND_MESSAGE

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

274:
275: EXCEPTION
276: WHEN OTHERS THEN
277: IF (SQLCODE <> -20001) THEN
278: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
279: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
280: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
281: FND_MESSAGE.SET_TOKEN('PARAMETERS',
282: ' P_invoice_id_list = ' || P_invoice_id_list);

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

275: EXCEPTION
276: WHEN OTHERS THEN
277: IF (SQLCODE <> -20001) THEN
278: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
279: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
280: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
281: FND_MESSAGE.SET_TOKEN('PARAMETERS',
282: ' P_invoice_id_list = ' || P_invoice_id_list);
283: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 280: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

276: WHEN OTHERS THEN
277: IF (SQLCODE <> -20001) THEN
278: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
279: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
280: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
281: FND_MESSAGE.SET_TOKEN('PARAMETERS',
282: ' P_invoice_id_list = ' || P_invoice_id_list);
283: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
284: END IF;

Line 281: FND_MESSAGE.SET_TOKEN('PARAMETERS',

277: IF (SQLCODE <> -20001) THEN
278: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
279: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
280: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
281: FND_MESSAGE.SET_TOKEN('PARAMETERS',
282: ' P_invoice_id_list = ' || P_invoice_id_list);
283: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
284: END IF;
285: APP_EXCEPTION.RAISE_EXCEPTION;

Line 283: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

279: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
280: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
281: FND_MESSAGE.SET_TOKEN('PARAMETERS',
282: ' P_invoice_id_list = ' || P_invoice_id_list);
283: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
284: END IF;
285: APP_EXCEPTION.RAISE_EXCEPTION;
286: END AP_Lock_Invoices;
287:

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

391:
392: EXCEPTION
393: WHEN OTHERS THEN
394: IF (SQLCODE <> -20001) THEN
395: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
396: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
398: FND_MESSAGE.SET_TOKEN('PARAMETERS',
399: ' P_invoice_id_list = ' ||P_invoice_id_list ||

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

392: EXCEPTION
393: WHEN OTHERS THEN
394: IF (SQLCODE <> -20001) THEN
395: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
396: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
398: FND_MESSAGE.SET_TOKEN('PARAMETERS',
399: ' P_invoice_id_list = ' ||P_invoice_id_list ||
400: ' P_payment_num_list = ' ||P_payment_num_list ||

Line 397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

393: WHEN OTHERS THEN
394: IF (SQLCODE <> -20001) THEN
395: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
396: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
398: FND_MESSAGE.SET_TOKEN('PARAMETERS',
399: ' P_invoice_id_list = ' ||P_invoice_id_list ||
400: ' P_payment_num_list = ' ||P_payment_num_list ||
401: ' P_check_date = ' ||P_check_date ||

Line 398: FND_MESSAGE.SET_TOKEN('PARAMETERS',

394: IF (SQLCODE <> -20001) THEN
395: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
396: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
397: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
398: FND_MESSAGE.SET_TOKEN('PARAMETERS',
399: ' P_invoice_id_list = ' ||P_invoice_id_list ||
400: ' P_payment_num_list = ' ||P_payment_num_list ||
401: ' P_check_date = ' ||P_check_date ||
402: ' P_currency_code = ' ||P_currency_code);

Line 403: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

399: ' P_invoice_id_list = ' ||P_invoice_id_list ||
400: ' P_payment_num_list = ' ||P_payment_num_list ||
401: ' P_check_date = ' ||P_check_date ||
402: ' P_currency_code = ' ||P_currency_code);
403: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
404: END IF;
405: APP_EXCEPTION.RAISE_EXCEPTION;
406: END AP_Discount_Available;
407:

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

517:
518: EXCEPTION
519: WHEN OTHERS THEN
520: IF (SQLCODE <> -20001) THEN
521: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
522: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
523: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
524: FND_MESSAGE.SET_TOKEN('PARAMETERS',
525: ' P_invoice_id = ' || P_invoice_id ||

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

518: EXCEPTION
519: WHEN OTHERS THEN
520: IF (SQLCODE <> -20001) THEN
521: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
522: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
523: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
524: FND_MESSAGE.SET_TOKEN('PARAMETERS',
525: ' P_invoice_id = ' || P_invoice_id ||
526: ' P_payment_num = ' || P_payment_num ||

Line 523: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

519: WHEN OTHERS THEN
520: IF (SQLCODE <> -20001) THEN
521: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
522: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
523: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
524: FND_MESSAGE.SET_TOKEN('PARAMETERS',
525: ' P_invoice_id = ' || P_invoice_id ||
526: ' P_payment_num = ' || P_payment_num ||
527: ' P_payment_type_flag = ' || P_payment_type_flag ||

Line 524: FND_MESSAGE.SET_TOKEN('PARAMETERS',

520: IF (SQLCODE <> -20001) THEN
521: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
522: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
523: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
524: FND_MESSAGE.SET_TOKEN('PARAMETERS',
525: ' P_invoice_id = ' || P_invoice_id ||
526: ' P_payment_num = ' || P_payment_num ||
527: ' P_payment_type_flag = ' || P_payment_type_flag ||
528: ' P_check_date = ' || P_check_date ||

Line 533: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

529: ' P_currency_code = ' || P_currency_code ||
530: ' P_take_discount = ' || P_take_discount ||
531: ' P_sys_auto_calc_int_flag = '|| P_sys_auto_calc_int_flag ||
532: ' P_auto_calc_int_flag = ' || P_auto_calc_int_flag);
533: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
534: END IF;
535: APP_EXCEPTION.RAISE_EXCEPTION;
536: END Get_Single_Payment_Amount;
537:

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

638:
639: EXCEPTION
640: WHEN OTHERS THEN
641: IF (SQLCODE <> -20001) THEN
642: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
643: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
644: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
645: FND_MESSAGE.SET_TOKEN('PARAMETERS',
646: ' P_invoice_id_list = ' || P_invoice_id_list ||

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

639: EXCEPTION
640: WHEN OTHERS THEN
641: IF (SQLCODE <> -20001) THEN
642: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
643: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
644: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
645: FND_MESSAGE.SET_TOKEN('PARAMETERS',
646: ' P_invoice_id_list = ' || P_invoice_id_list ||
647: ' P_payment_num_list = ' || P_payment_num_list ||

Line 644: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

640: WHEN OTHERS THEN
641: IF (SQLCODE <> -20001) THEN
642: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
643: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
644: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
645: FND_MESSAGE.SET_TOKEN('PARAMETERS',
646: ' P_invoice_id_list = ' || P_invoice_id_list ||
647: ' P_payment_num_list = ' || P_payment_num_list ||
648: ' P_payment_type_flag = ' || P_payment_type_flag ||

Line 645: FND_MESSAGE.SET_TOKEN('PARAMETERS',

641: IF (SQLCODE <> -20001) THEN
642: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
643: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
644: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
645: FND_MESSAGE.SET_TOKEN('PARAMETERS',
646: ' P_invoice_id_list = ' || P_invoice_id_list ||
647: ' P_payment_num_list = ' || P_payment_num_list ||
648: ' P_payment_type_flag = ' || P_payment_type_flag ||
649: ' P_check_date = ' || P_check_date ||

Line 654: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

650: ' P_currency_code = ' || P_currency_code ||
651: ' P_take_discount = ' || P_take_discount ||
652: ' P_sys_auto_calc_int_flag = '|| P_sys_auto_calc_int_flag ||
653: ' P_auto_calc_int_flag = ' || P_auto_calc_int_flag);
654: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
655: END IF;
656: APP_EXCEPTION.RAISE_EXCEPTION;
657: END AP_Get_Check_Amount;
658:

Line 1075: FND_MESSAGE.SET_NAME('SQLAP', 'AP_AWT_PROB_PLSQL');

1071: l_amount := l_amount + l_withholding_amount;
1072: l_amount_remaining := l_amount_remaining +
1073: l_withholding_amount;
1074: else
1075: FND_MESSAGE.SET_NAME('SQLAP', 'AP_AWT_PROB_PLSQL');
1076: FND_MESSAGE.SET_TOKEN('INVOICE', to_char(P_invoice_id));
1077: FND_MESSAGE.SET_TOKEN('PROBLEM', l_awt_success );
1078: APP_EXCEPTION.RAISE_EXCEPTION;
1079: end if;

Line 1076: FND_MESSAGE.SET_TOKEN('INVOICE', to_char(P_invoice_id));

1072: l_amount_remaining := l_amount_remaining +
1073: l_withholding_amount;
1074: else
1075: FND_MESSAGE.SET_NAME('SQLAP', 'AP_AWT_PROB_PLSQL');
1076: FND_MESSAGE.SET_TOKEN('INVOICE', to_char(P_invoice_id));
1077: FND_MESSAGE.SET_TOKEN('PROBLEM', l_awt_success );
1078: APP_EXCEPTION.RAISE_EXCEPTION;
1079: end if;
1080:

Line 1077: FND_MESSAGE.SET_TOKEN('PROBLEM', l_awt_success );

1073: l_withholding_amount;
1074: else
1075: FND_MESSAGE.SET_NAME('SQLAP', 'AP_AWT_PROB_PLSQL');
1076: FND_MESSAGE.SET_TOKEN('INVOICE', to_char(P_invoice_id));
1077: FND_MESSAGE.SET_TOKEN('PROBLEM', l_awt_success );
1078: APP_EXCEPTION.RAISE_EXCEPTION;
1079: end if;
1080:
1081: end if;

Line 1150: FND_MESSAGE.SET_NAME('SQLAP', 'AP_OVERPAID_INVOICE');

1146: ,P_checkrun_id => null);
1147:
1148: END;
1149:
1150: FND_MESSAGE.SET_NAME('SQLAP', 'AP_OVERPAID_INVOICE');
1151: FND_MESSAGE.SET_TOKEN('INVOICE', to_char(P_invoice_id));
1152: APP_EXCEPTION.RAISE_EXCEPTION;
1153:
1154: END IF;

Line 1151: FND_MESSAGE.SET_TOKEN('INVOICE', to_char(P_invoice_id));

1147:
1148: END;
1149:
1150: FND_MESSAGE.SET_NAME('SQLAP', 'AP_OVERPAID_INVOICE');
1151: FND_MESSAGE.SET_TOKEN('INVOICE', to_char(P_invoice_id));
1152: APP_EXCEPTION.RAISE_EXCEPTION;
1153:
1154: END IF;
1155:

Line 1396: FND_MESSAGE.SET_NAME('FND','UNIQUE-ALWAYS USED');

1392:
1393: WHEN OTHERS THEN
1394:
1395: IF (SQLCODE <> -20001) THEN
1396: FND_MESSAGE.SET_NAME('FND','UNIQUE-ALWAYS USED');
1397: END IF;
1398:
1399: APP_EXCEPTION.RAISE_EXCEPTION;
1400: END;

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

1505:
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: IF (SQLCODE <> -20001) THEN
1509: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1510: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1511: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1512: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1513: ' P_invoice_id = ' || P_invoice_id ||

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

1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: IF (SQLCODE <> -20001) THEN
1509: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1510: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1511: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1512: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1513: ' P_invoice_id = ' || P_invoice_id ||
1514: ' P_payment_num = ' || P_payment_num ||

Line 1511: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1507: WHEN OTHERS THEN
1508: IF (SQLCODE <> -20001) THEN
1509: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1510: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1511: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1512: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1513: ' P_invoice_id = ' || P_invoice_id ||
1514: ' P_payment_num = ' || P_payment_num ||
1515: ' P_check_id = ' || P_check_id ||

Line 1512: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1508: IF (SQLCODE <> -20001) THEN
1509: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1510: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1511: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1512: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1513: ' P_invoice_id = ' || P_invoice_id ||
1514: ' P_payment_num = ' || P_payment_num ||
1515: ' P_check_id = ' || P_check_id ||
1516: ' P_payment_type_flag = ' || P_payment_type_flag ||

Line 1540: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

1536: ' P_future_pay_ccid = ' || P_future_pay_ccid ||
1537: ' P_last_updated_by = ' || P_last_updated_by ||
1538: ' P_last_update_login = ' || P_last_update_login
1539: );
1540: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1541: END IF;
1542: APP_EXCEPTION.RAISE_EXCEPTION;
1543: END Create_Single_Payment;
1544:

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

1700:
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: IF (SQLCODE <> -20001) THEN
1704: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1705: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1706: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1707: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1708: ' P_invoice_id_list = ' || P_invoice_id_list ||

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

1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: IF (SQLCODE <> -20001) THEN
1704: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1705: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1706: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1707: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1708: ' P_invoice_id_list = ' || P_invoice_id_list ||
1709: ' P_payment_num_list = ' || P_payment_num_list ||

Line 1706: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);

1702: WHEN OTHERS THEN
1703: IF (SQLCODE <> -20001) THEN
1704: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1705: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1706: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1707: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1708: ' P_invoice_id_list = ' || P_invoice_id_list ||
1709: ' P_payment_num_list = ' || P_payment_num_list ||
1710: ' P_check_id = ' || P_check_id ||

Line 1707: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1703: IF (SQLCODE <> -20001) THEN
1704: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1705: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1706: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',l_curr_calling_sequence);
1707: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1708: ' P_invoice_id_list = ' || P_invoice_id_list ||
1709: ' P_payment_num_list = ' || P_payment_num_list ||
1710: ' P_check_id = ' || P_check_id ||
1711: ' P_payment_type_flag = ' || P_payment_type_flag ||

Line 1735: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

1731: ' P_future_pay_ccid = ' || P_future_pay_ccid ||
1732: ' P_last_updated_by = ' || P_last_updated_by ||
1733: ' P_last_update_login = ' || P_last_update_login
1734: );
1735: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1736: END IF;
1737: APP_EXCEPTION.RAISE_EXCEPTION;
1738: END AP_Create_Payments;
1739: