DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on FND_MESSAGE

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

330:
331: EXCEPTION
332: WHEN OTHERS THEN
333: IF (SQLCODE <> -20001) THEN
334: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
335: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
336: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
337: l_curr_calling_sequence);
338: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

331: EXCEPTION
332: WHEN OTHERS THEN
333: IF (SQLCODE <> -20001) THEN
334: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
335: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
336: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
337: l_curr_calling_sequence);
338: FND_MESSAGE.SET_TOKEN('PARAMETERS',
339: 'p_accounting_event_id = '||p_accounting_event_id

Line 336: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

332: WHEN OTHERS THEN
333: IF (SQLCODE <> -20001) THEN
334: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
335: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
336: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
337: l_curr_calling_sequence);
338: FND_MESSAGE.SET_TOKEN('PARAMETERS',
339: 'p_accounting_event_id = '||p_accounting_event_id
340: ||', p_Invoice_Id = '||p_Invoice_Id);

Line 338: FND_MESSAGE.SET_TOKEN('PARAMETERS',

334: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
335: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
336: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
337: l_curr_calling_sequence);
338: FND_MESSAGE.SET_TOKEN('PARAMETERS',
339: 'p_accounting_event_id = '||p_accounting_event_id
340: ||', p_Invoice_Id = '||p_Invoice_Id);
341: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
342: END IF;

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

337: l_curr_calling_sequence);
338: FND_MESSAGE.SET_TOKEN('PARAMETERS',
339: 'p_accounting_event_id = '||p_accounting_event_id
340: ||', p_Invoice_Id = '||p_Invoice_Id);
341: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
342: END IF;
343: APP_EXCEPTION.RAISE_EXCEPTION();
344: END;
345:

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

900:
901: EXCEPTION
902: WHEN OTHERS THEN
903: IF (SQLCODE <> -20001) THEN
904: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
905: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
906: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
907: l_curr_calling_sequence);
908: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

901: EXCEPTION
902: WHEN OTHERS THEN
903: IF (SQLCODE <> -20001) THEN
904: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
905: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
906: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
907: l_curr_calling_sequence);
908: FND_MESSAGE.SET_TOKEN('PARAMETERS',
909: 'p_doc_type = '||p_doc_type

Line 906: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

902: WHEN OTHERS THEN
903: IF (SQLCODE <> -20001) THEN
904: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
905: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
906: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
907: l_curr_calling_sequence);
908: FND_MESSAGE.SET_TOKEN('PARAMETERS',
909: 'p_doc_type = '||p_doc_type
910: ||', p_doc_id = '||p_doc_id

Line 908: FND_MESSAGE.SET_TOKEN('PARAMETERS',

904: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
905: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
906: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
907: l_curr_calling_sequence);
908: FND_MESSAGE.SET_TOKEN('PARAMETERS',
909: 'p_doc_type = '||p_doc_type
910: ||', p_doc_id = '||p_doc_id
911: ||', p_accounting_date = '||p_accounting_date
912: ||', p_checkrun_name = '||p_checkrun_name);

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

909: 'p_doc_type = '||p_doc_type
910: ||', p_doc_id = '||p_doc_id
911: ||', p_accounting_date = '||p_accounting_date
912: ||', p_checkrun_name = '||p_checkrun_name);
913: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
914: END IF;
915: APP_EXCEPTION.RAISE_EXCEPTION();
916:
917: END create_events;

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

1783: CLOSE inv_event_dists;
1784: END IF;
1785:
1786: IF (SQLCODE <> -20001) THEN
1787: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1788: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1790: l_curr_calling_sequence);
1791: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

1784: END IF;
1785:
1786: IF (SQLCODE <> -20001) THEN
1787: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1788: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1790: l_curr_calling_sequence);
1791: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1792: 'p_invoice_id = '||p_invoice_id);

Line 1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1785:
1786: IF (SQLCODE <> -20001) THEN
1787: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1788: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1790: l_curr_calling_sequence);
1791: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1792: 'p_invoice_id = '||p_invoice_id);
1793: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 1791: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1787: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1788: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1790: l_curr_calling_sequence);
1791: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1792: 'p_invoice_id = '||p_invoice_id);
1793: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1794: END IF;
1795:

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

1789: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1790: l_curr_calling_sequence);
1791: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1792: 'p_invoice_id = '||p_invoice_id);
1793: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1794: END IF;
1795:
1796: APP_EXCEPTION.RAISE_EXCEPTION();
1797: END derive_invoice_events;

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

1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: IF (SQLCODE <> -20001) THEN
1922: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1923: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1925: l_curr_calling_sequence);
1926: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: IF (SQLCODE <> -20001) THEN
1922: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1923: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1925: l_curr_calling_sequence);
1926: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1927: 'p_event_type = '||p_event_type

Line 1924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

1920: WHEN OTHERS THEN
1921: IF (SQLCODE <> -20001) THEN
1922: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1923: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1925: l_curr_calling_sequence);
1926: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1927: 'p_event_type = '||p_event_type
1928: ||', p_invoice_id = '||p_invoice_id

Line 1926: FND_MESSAGE.SET_TOKEN('PARAMETERS',

1922: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1923: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1924: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1925: l_curr_calling_sequence);
1926: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1927: 'p_event_type = '||p_event_type
1928: ||', p_invoice_id = '||p_invoice_id
1929: ||', p_event_date = '||p_event_date);
1930: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

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

1926: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1927: 'p_event_type = '||p_event_type
1928: ||', p_invoice_id = '||p_invoice_id
1929: ||', p_event_date = '||p_event_date);
1930: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1931: END IF;
1932:
1933: APP_EXCEPTION.RAISE_EXCEPTION();
1934: END create_invoice_event;

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

2465:
2466: EXCEPTION
2467: WHEN OTHERS THEN
2468: IF (SQLCODE <> -20001) THEN
2469: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2470: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2471: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2472: l_curr_calling_sequence);
2473: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

2466: EXCEPTION
2467: WHEN OTHERS THEN
2468: IF (SQLCODE <> -20001) THEN
2469: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2470: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2471: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2472: l_curr_calling_sequence);
2473: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2474: 'p_event_type = '||p_event_type

Line 2471: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

2467: WHEN OTHERS THEN
2468: IF (SQLCODE <> -20001) THEN
2469: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2470: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2471: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2472: l_curr_calling_sequence);
2473: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2474: 'p_event_type = '||p_event_type
2475: ||', p_check_id = '||p_check_id

Line 2473: FND_MESSAGE.SET_TOKEN('PARAMETERS',

2469: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2470: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2471: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2472: l_curr_calling_sequence);
2473: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2474: 'p_event_type = '||p_event_type
2475: ||', p_check_id = '||p_check_id
2476: ||', p_event_date = '||p_event_date);
2477: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

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

2473: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2474: 'p_event_type = '||p_event_type
2475: ||', p_check_id = '||p_check_id
2476: ||', p_event_date = '||p_event_date);
2477: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
2478: END IF;
2479: APP_EXCEPTION.RAISE_EXCEPTION();
2480: END create_payment_event;
2481:

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

3047:
3048: EXCEPTION
3049: WHEN OTHERS THEN
3050: IF (SQLCODE <> -20001) THEN
3051: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3052: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3053: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3054: l_curr_calling_sequence);
3055: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

3048: EXCEPTION
3049: WHEN OTHERS THEN
3050: IF (SQLCODE <> -20001) THEN
3051: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3052: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3053: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3054: l_curr_calling_sequence);
3055: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3056: 'p_invoice_id = '||p_invoice_id);

Line 3053: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

3049: WHEN OTHERS THEN
3050: IF (SQLCODE <> -20001) THEN
3051: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3052: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3053: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3054: l_curr_calling_sequence);
3055: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3056: 'p_invoice_id = '||p_invoice_id);
3057: END IF;

Line 3055: FND_MESSAGE.SET_TOKEN('PARAMETERS',

3051: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3052: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3053: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3054: l_curr_calling_sequence);
3055: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3056: 'p_invoice_id = '||p_invoice_id);
3057: END IF;
3058: APP_EXCEPTION.RAISE_EXCEPTION();
3059: END update_invoice_events_status;

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

3685:
3686: EXCEPTION
3687: WHEN OTHERS THEN
3688: IF (SQLCODE <> -20001) THEN
3689: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3690: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3692: l_curr_calling_sequence);
3693: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

3686: EXCEPTION
3687: WHEN OTHERS THEN
3688: IF (SQLCODE <> -20001) THEN
3689: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3690: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3692: l_curr_calling_sequence);
3693: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3694: 'p_check_id = '||p_check_id);

Line 3691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

3687: WHEN OTHERS THEN
3688: IF (SQLCODE <> -20001) THEN
3689: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3690: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3692: l_curr_calling_sequence);
3693: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3694: 'p_check_id = '||p_check_id);
3695: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 3693: FND_MESSAGE.SET_TOKEN('PARAMETERS',

3689: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3690: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3692: l_curr_calling_sequence);
3693: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3694: 'p_check_id = '||p_check_id);
3695: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3696: END IF;
3697: APP_EXCEPTION.RAISE_EXCEPTION();

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

3691: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3692: l_curr_calling_sequence);
3693: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3694: 'p_check_id = '||p_check_id);
3695: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3696: END IF;
3697: APP_EXCEPTION.RAISE_EXCEPTION();
3698: END update_payment_events_status;
3699:

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

3811: EXCEPTION
3812: WHEN OTHERS THEN
3813:
3814: IF (SQLCODE <> -20001) THEN
3815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3818: l_curr_calling_sequence);
3819: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

3812: WHEN OTHERS THEN
3813:
3814: IF (SQLCODE <> -20001) THEN
3815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3818: l_curr_calling_sequence);
3819: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3820: 'p_checkrun_name = '||p_checkrun_name

Line 3817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

3813:
3814: IF (SQLCODE <> -20001) THEN
3815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3818: l_curr_calling_sequence);
3819: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3820: 'p_checkrun_name = '||p_checkrun_name
3821: ||', p_completed_pmts_group_id = '||p_completed_pmts_group_id

Line 3819: FND_MESSAGE.SET_TOKEN('PARAMETERS',

3815: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3816: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3817: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3818: l_curr_calling_sequence);
3819: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3820: 'p_checkrun_name = '||p_checkrun_name
3821: ||', p_completed_pmts_group_id = '||p_completed_pmts_group_id
3822: ||', p_org_id = '||p_org_id
3823: ||', p_checkrun_name = '||p_checkrun_name);

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

3820: 'p_checkrun_name = '||p_checkrun_name
3821: ||', p_completed_pmts_group_id = '||p_completed_pmts_group_id
3822: ||', p_org_id = '||p_org_id
3823: ||', p_checkrun_name = '||p_checkrun_name);
3824: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3825: END IF;
3826: fnd_file.put_line(FND_FILE.LOG,l_log_msg||'|'||SQLERRM||' - '||systimestamp); --Bug 14279929
3827: APP_EXCEPTION.RAISE_EXCEPTION();
3828: END update_pmt_batch_event_status;

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

4160: EXCEPTION
4161: WHEN OTHERS THEN
4162:
4163: IF (SQLCODE <> -20001) THEN
4164: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4165: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4166: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4167: l_curr_calling_sequence);
4168: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

4161: WHEN OTHERS THEN
4162:
4163: IF (SQLCODE <> -20001) THEN
4164: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4165: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4166: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4167: l_curr_calling_sequence);
4168: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4169: 'p_completed_pmts_group_id = '||p_completed_pmts_group_id

Line 4166: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

4162:
4163: IF (SQLCODE <> -20001) THEN
4164: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4165: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4166: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4167: l_curr_calling_sequence);
4168: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4169: 'p_completed_pmts_group_id = '||p_completed_pmts_group_id
4170: ||', p_set_of_books_id = '||p_set_of_books_id

Line 4168: FND_MESSAGE.SET_TOKEN('PARAMETERS',

4164: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4165: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4166: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4167: l_curr_calling_sequence);
4168: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4169: 'p_completed_pmts_group_id = '||p_completed_pmts_group_id
4170: ||', p_set_of_books_id = '||p_set_of_books_id
4171: ||', p_org_id = '||p_set_of_books_id
4172: ||', p_accounting_date = '||p_accounting_date);

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

4169: 'p_completed_pmts_group_id = '||p_completed_pmts_group_id
4170: ||', p_set_of_books_id = '||p_set_of_books_id
4171: ||', p_org_id = '||p_set_of_books_id
4172: ||', p_accounting_date = '||p_accounting_date);
4173: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4174: END IF;
4175: fnd_file.put_line(FND_FILE.LOG,l_log_msg||'|'||SQLERRM||' - '||systimestamp); --Bug 14279929
4176: APP_EXCEPTION.RAISE_EXCEPTION();
4177: END create_payment_batch_events;

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

4288:
4289: EXCEPTION
4290: WHEN OTHERS THEN
4291: IF (SQLCODE <> -20001) THEN
4292: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4293: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4295: l_curr_calling_sequence);
4296: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

4289: EXCEPTION
4290: WHEN OTHERS THEN
4291: IF (SQLCODE <> -20001) THEN
4292: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4293: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4295: l_curr_calling_sequence);
4296: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4297: 'p_event_type = '||p_event_type

Line 4294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

4290: WHEN OTHERS THEN
4291: IF (SQLCODE <> -20001) THEN
4292: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4293: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4295: l_curr_calling_sequence);
4296: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4297: 'p_event_type = '||p_event_type
4298: ||', p_check_id = '||p_check_id

Line 4296: FND_MESSAGE.SET_TOKEN('PARAMETERS',

4292: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4293: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4294: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4295: l_curr_calling_sequence);
4296: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4297: 'p_event_type = '||p_event_type
4298: ||', p_check_id = '||p_check_id
4299: ||', p_event_id = '||p_event_id);
4300: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

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

4296: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4297: 'p_event_type = '||p_event_type
4298: ||', p_check_id = '||p_check_id
4299: ||', p_event_id = '||p_event_id);
4300: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4301: END IF;
4302: APP_EXCEPTION.RAISE_EXCEPTION();
4303: END update_awt_int_dists;
4304:

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

4470: CLOSE get_payment_info;
4471: END IF;
4472:
4473: IF (SQLCODE <> -20001) THEN
4474: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4475: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4476: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4477: l_curr_calling_sequence);
4478: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

4471: END IF;
4472:
4473: IF (SQLCODE <> -20001) THEN
4474: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4475: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4476: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4477: l_curr_calling_sequence);
4478: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4479: ' p_checkrun_name = '|| p_checkrun_name);

Line 4476: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

4472:
4473: IF (SQLCODE <> -20001) THEN
4474: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4475: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4476: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4477: l_curr_calling_sequence);
4478: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4479: ' p_checkrun_name = '|| p_checkrun_name);
4480: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 4478: FND_MESSAGE.SET_TOKEN('PARAMETERS',

4474: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4475: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4476: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4477: l_curr_calling_sequence);
4478: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4479: ' p_checkrun_name = '|| p_checkrun_name);
4480: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4481: END IF;
4482: fnd_file.put_line(FND_FILE.LOG,l_log_msg||'|'||SQLERRM||' - '||systimestamp); --Bug 14279929

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

4476: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4477: l_curr_calling_sequence);
4478: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4479: ' p_checkrun_name = '|| p_checkrun_name);
4480: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4481: END IF;
4482: fnd_file.put_line(FND_FILE.LOG,l_log_msg||'|'||SQLERRM||' - '||systimestamp); --Bug 14279929
4483: APP_EXCEPTION.RAISE_EXCEPTION();
4484: END batch_update_payment_info;

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

4678:
4679: EXCEPTION
4680: WHEN OTHERS THEN
4681: IF (SQLCODE <> -20001) THEN
4682: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4683: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4684: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4685: l_curr_calling_sequence);
4686: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

4679: EXCEPTION
4680: WHEN OTHERS THEN
4681: IF (SQLCODE <> -20001) THEN
4682: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4683: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4684: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4685: l_curr_calling_sequence);
4686: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4687: 'p_doc_type = '||p_doc_type

Line 4684: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

4680: WHEN OTHERS THEN
4681: IF (SQLCODE <> -20001) THEN
4682: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4683: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4684: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4685: l_curr_calling_sequence);
4686: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4687: 'p_doc_type = '||p_doc_type
4688: ||', p_source_id = '||p_source_id);

Line 4686: FND_MESSAGE.SET_TOKEN('PARAMETERS',

4682: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4683: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4684: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4685: l_curr_calling_sequence);
4686: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4687: 'p_doc_type = '||p_doc_type
4688: ||', p_source_id = '||p_source_id);
4689: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4690: END IF;

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

4685: l_curr_calling_sequence);
4686: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4687: 'p_doc_type = '||p_doc_type
4688: ||', p_source_id = '||p_source_id);
4689: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4690: END IF;
4691: APP_EXCEPTION.RAISE_EXCEPTION();
4692: END is_event_complete;
4693:

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

4972: IF (l_event_cur%ISOPEN) THEN
4973: CLOSE l_event_cur;
4974: END IF;
4975: IF (SQLCODE <> -20001) THEN
4976: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4977: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4978: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4979: l_curr_calling_sequence);
4980: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

4973: CLOSE l_event_cur;
4974: END IF;
4975: IF (SQLCODE <> -20001) THEN
4976: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4977: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4978: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4979: l_curr_calling_sequence);
4980: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4981: 'p_check_id = '||p_check_id

Line 4978: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

4974: END IF;
4975: IF (SQLCODE <> -20001) THEN
4976: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4977: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4978: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4979: l_curr_calling_sequence);
4980: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4981: 'p_check_id = '||p_check_id
4982: ||', p_accounting_date = '||p_accounting_date

Line 4980: FND_MESSAGE.SET_TOKEN('PARAMETERS',

4976: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4977: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4978: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4979: l_curr_calling_sequence);
4980: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4981: 'p_check_id = '||p_check_id
4982: ||', p_accounting_date = '||p_accounting_date
4983: ||', p_event_type = ' ||p_event_type);
4984: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

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

4980: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4981: 'p_check_id = '||p_check_id
4982: ||', p_accounting_date = '||p_accounting_date
4983: ||', p_event_type = ' ||p_event_type);
4984: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4985: END IF;
4986: APP_EXCEPTION.RAISE_EXCEPTION();
4987: END derive_payment_adj_event;
4988:

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

5868: IF (l_payment_maturities_cur%ISOPEN) THEN
5869: CLOSE l_payment_maturities_cur;
5870: END IF;
5871: IF (SQLCODE <> -20001) THEN
5872: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5874: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5875: l_curr_calling_sequence);
5876: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

5869: CLOSE l_payment_maturities_cur;
5870: END IF;
5871: IF (SQLCODE <> -20001) THEN
5872: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5874: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5875: l_curr_calling_sequence);
5876: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5877: 'p_invoice_id = '||p_invoice_id

Line 5874: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

5870: END IF;
5871: IF (SQLCODE <> -20001) THEN
5872: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5874: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5875: l_curr_calling_sequence);
5876: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5877: 'p_invoice_id = '||p_invoice_id
5878: ||', p_adj_accounting_event_id = '||p_adj_accounting_event_id);

Line 5876: FND_MESSAGE.SET_TOKEN('PARAMETERS',

5872: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5873: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5874: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5875: l_curr_calling_sequence);
5876: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5877: 'p_invoice_id = '||p_invoice_id
5878: ||', p_adj_accounting_event_id = '||p_adj_accounting_event_id);
5879: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
5880: END IF;

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

5875: l_curr_calling_sequence);
5876: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5877: 'p_invoice_id = '||p_invoice_id
5878: ||', p_adj_accounting_event_id = '||p_adj_accounting_event_id);
5879: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
5880: END IF;
5881: APP_EXCEPTION.RAISE_EXCEPTION();
5882: END derive_cascade_events;
5883:

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

6083: IF (inv_cancel_event_dists%ISOPEN) THEN
6084: CLOSE inv_cancel_event_dists;
6085: END IF;
6086: IF (SQLCODE <> -20001) THEN
6087: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6088: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6089: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6090: l_curr_calling_sequence);
6091: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

6084: CLOSE inv_cancel_event_dists;
6085: END IF;
6086: IF (SQLCODE <> -20001) THEN
6087: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6088: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6089: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6090: l_curr_calling_sequence);
6091: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6092: 'p_invoice_id = '||p_invoice_id);

Line 6089: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

6085: END IF;
6086: IF (SQLCODE <> -20001) THEN
6087: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6088: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6089: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6090: l_curr_calling_sequence);
6091: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6092: 'p_invoice_id = '||p_invoice_id);
6093: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 6091: FND_MESSAGE.SET_TOKEN('PARAMETERS',

6087: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6088: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6089: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6090: l_curr_calling_sequence);
6091: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6092: 'p_invoice_id = '||p_invoice_id);
6093: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6094: END IF;
6095: APP_EXCEPTION.RAISE_EXCEPTION();

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

6089: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6090: l_curr_calling_sequence);
6091: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6092: 'p_invoice_id = '||p_invoice_id);
6093: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6094: END IF;
6095: APP_EXCEPTION.RAISE_EXCEPTION();
6096: END derive_invoice_cancel_events;
6097:

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

6395:
6396: EXCEPTION
6397: WHEN OTHERS THEN
6398: IF (SQLCODE <> -20001) THEN
6399: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6400: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6401: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6402: l_curr_calling_sequence);
6403: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

6396: EXCEPTION
6397: WHEN OTHERS THEN
6398: IF (SQLCODE <> -20001) THEN
6399: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6400: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6401: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6402: l_curr_calling_sequence);
6403: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6404: 'p_check_id = '||p_check_id

Line 6401: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

6397: WHEN OTHERS THEN
6398: IF (SQLCODE <> -20001) THEN
6399: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6400: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6401: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6402: l_curr_calling_sequence);
6403: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6404: 'p_check_id = '||p_check_id
6405: ||', p_event_type_code = '||p_event_type_code

Line 6403: FND_MESSAGE.SET_TOKEN('PARAMETERS',

6399: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6400: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6401: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6402: l_curr_calling_sequence);
6403: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6404: 'p_check_id = '||p_check_id
6405: ||', p_event_type_code = '||p_event_type_code
6406: ||', p_accounting_date = '||p_accounting_date
6407: ||', p_accounting_event_id = '||p_accounting_event_id);

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

6404: 'p_check_id = '||p_check_id
6405: ||', p_event_type_code = '||p_event_type_code
6406: ||', p_accounting_date = '||p_accounting_date
6407: ||', p_accounting_event_id = '||p_accounting_event_id);
6408: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6409: END IF;
6410: APP_EXCEPTION.RAISE_EXCEPTION();
6411: END no_action_pmt_event_update;
6412:

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

6890: END IF;
6891: end if;
6892:
6893: IF (SQLCODE <> -20001) THEN
6894: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6895: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6896: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6897: l_curr_calling_sequence);
6898: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

6891: end if;
6892:
6893: IF (SQLCODE <> -20001) THEN
6894: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6895: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6896: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6897: l_curr_calling_sequence);
6898: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6899: 'p_ledger_id = '||p_ledger_id

Line 6896: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

6892:
6893: IF (SQLCODE <> -20001) THEN
6894: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6895: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6896: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6897: l_curr_calling_sequence);
6898: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6899: 'p_ledger_id = '||p_ledger_id
6900: ||', p_period_name = '||p_period_name

Line 6898: FND_MESSAGE.SET_TOKEN('PARAMETERS',

6894: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6895: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6896: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6897: l_curr_calling_sequence);
6898: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6899: 'p_ledger_id = '||p_ledger_id
6900: ||', p_period_name = '||p_period_name
6901: ||', p_from_date = '||p_from_date
6902: ||', p_to_date = '||p_to_date

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

6900: ||', p_period_name = '||p_period_name
6901: ||', p_from_date = '||p_from_date
6902: ||', p_to_date = '||p_to_date
6903: ||', p_sweep_to_date = '||p_sweep_to_date);
6904: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6905: END IF;
6906: APP_EXCEPTION.RAISE_EXCEPTION();
6907: END multi_org_events_sweep;
6908:

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

7247: END IF;
7248: end if;
7249:
7250: IF (SQLCODE <> -20001) THEN
7251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7254: l_curr_calling_sequence);
7255: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

7248: end if;
7249:
7250: IF (SQLCODE <> -20001) THEN
7251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7254: l_curr_calling_sequence);
7255: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7256: 'p_period_name = '||p_period_name

Line 7253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

7249:
7250: IF (SQLCODE <> -20001) THEN
7251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7254: l_curr_calling_sequence);
7255: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7256: 'p_period_name = '||p_period_name
7257: ||', p_from_date = '||p_from_date

Line 7255: FND_MESSAGE.SET_TOKEN('PARAMETERS',

7251: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
7252: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7253: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7254: l_curr_calling_sequence);
7255: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7256: 'p_period_name = '||p_period_name
7257: ||', p_from_date = '||p_from_date
7258: ||', p_to_date = '||p_to_date
7259: ||', p_sweep_to_date = '||p_sweep_to_date);

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

7256: 'p_period_name = '||p_period_name
7257: ||', p_from_date = '||p_from_date
7258: ||', p_to_date = '||p_to_date
7259: ||', p_sweep_to_date = '||p_sweep_to_date);
7260: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7261: END IF;
7262: APP_EXCEPTION.RAISE_EXCEPTION();
7263: END single_org_events_sweep;
7264:

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

7380: RETURN RECONCILED_PAYMENTS_CLASS;
7381: END IF;
7382:
7383:
7384: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7385: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7386: l_curr_calling_sequence);
7387: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7388: 'p_event_type = '||p_event_type );

Line 7385: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

7381: END IF;
7382:
7383:
7384: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7385: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7386: l_curr_calling_sequence);
7387: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7388: 'p_event_type = '||p_event_type );
7389: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 7387: FND_MESSAGE.SET_TOKEN('PARAMETERS',

7383:
7384: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7385: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7386: l_curr_calling_sequence);
7387: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7388: 'p_event_type = '||p_event_type );
7389: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7390:
7391: APP_EXCEPTION.RAISE_EXCEPTION();

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

7385: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7386: l_curr_calling_sequence);
7387: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7388: 'p_event_type = '||p_event_type );
7389: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7390:
7391: APP_EXCEPTION.RAISE_EXCEPTION();
7392: RETURN NULL; -- unreachable
7393:

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

7669:
7670: EXCEPTION
7671: WHEN OTHERS THEN
7672: IF (SQLCODE <> -20001) THEN
7673: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7674: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7675: l_curr_calling_sequence);
7676: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7677: 'p_org_id = '||p_org_id);

Line 7674: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

7670: EXCEPTION
7671: WHEN OTHERS THEN
7672: IF (SQLCODE <> -20001) THEN
7673: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7674: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7675: l_curr_calling_sequence);
7676: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7677: 'p_org_id = '||p_org_id);
7678: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 7676: FND_MESSAGE.SET_TOKEN('PARAMETERS',

7672: IF (SQLCODE <> -20001) THEN
7673: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7674: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7675: l_curr_calling_sequence);
7676: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7677: 'p_org_id = '||p_org_id);
7678: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7679: END IF;
7680: APP_EXCEPTION.RAISE_EXCEPTION();

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

7674: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7675: l_curr_calling_sequence);
7676: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7677: 'p_org_id = '||p_org_id);
7678: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7679: END IF;
7680: APP_EXCEPTION.RAISE_EXCEPTION();
7681: END get_invoice_info;
7682:

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

7750:
7751: EXCEPTION
7752: WHEN OTHERS THEN
7753: IF (SQLCODE <> -20001) THEN
7754: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7755: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7756: l_curr_calling_sequence);
7757: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7758: 'p_check_id = '||p_check_id);

Line 7755: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

7751: EXCEPTION
7752: WHEN OTHERS THEN
7753: IF (SQLCODE <> -20001) THEN
7754: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7755: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7756: l_curr_calling_sequence);
7757: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7758: 'p_check_id = '||p_check_id);
7759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 7757: FND_MESSAGE.SET_TOKEN('PARAMETERS',

7753: IF (SQLCODE <> -20001) THEN
7754: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7755: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7756: l_curr_calling_sequence);
7757: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7758: 'p_check_id = '||p_check_id);
7759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7760: END IF;
7761: APP_EXCEPTION.RAISE_EXCEPTION();

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

7755: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7756: l_curr_calling_sequence);
7757: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7758: 'p_check_id = '||p_check_id);
7759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7760: END IF;
7761: APP_EXCEPTION.RAISE_EXCEPTION();
7762: END get_payment_info;
7763:

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

7862: EXCEPTION
7863: WHEN OTHERS THEN
7864:
7865: IF (SQLCODE <> -20001) THEN
7866: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7867: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7868: l_curr_calling_sequence);
7869: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7870: 'p_invoice_id = '||p_invoice_id);

Line 7867: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

7863: WHEN OTHERS THEN
7864:
7865: IF (SQLCODE <> -20001) THEN
7866: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7867: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7868: l_curr_calling_sequence);
7869: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7870: 'p_invoice_id = '||p_invoice_id);
7871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 7869: FND_MESSAGE.SET_TOKEN('PARAMETERS',

7865: IF (SQLCODE <> -20001) THEN
7866: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7867: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7868: l_curr_calling_sequence);
7869: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7870: 'p_invoice_id = '||p_invoice_id);
7871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7872: END IF;
7873: APP_EXCEPTION.RAISE_EXCEPTION();

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

7867: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7868: l_curr_calling_sequence);
7869: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7870: 'p_invoice_id = '||p_invoice_id);
7871: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7872: END IF;
7873: APP_EXCEPTION.RAISE_EXCEPTION();
7874:
7875: END Update_Prepayment_Header;

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

8154: EXCEPTION
8155: WHEN OTHERS THEN
8156:
8157: IF (SQLCODE <> -20001) THEN
8158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
8160: l_curr_calling_sequence);
8161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8162: 'p_invoice_id = '||p_invoice_id);

Line 8159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

8155: WHEN OTHERS THEN
8156:
8157: IF (SQLCODE <> -20001) THEN
8158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
8160: l_curr_calling_sequence);
8161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8162: 'p_invoice_id = '||p_invoice_id);
8163: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 8161: FND_MESSAGE.SET_TOKEN('PARAMETERS',

8157: IF (SQLCODE <> -20001) THEN
8158: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
8160: l_curr_calling_sequence);
8161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8162: 'p_invoice_id = '||p_invoice_id);
8163: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
8164: END IF;
8165: APP_EXCEPTION.RAISE_EXCEPTION();

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

8159: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
8160: l_curr_calling_sequence);
8161: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8162: 'p_invoice_id = '||p_invoice_id);
8163: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
8164: END IF;
8165: APP_EXCEPTION.RAISE_EXCEPTION();
8166:
8167: END Insert_Prepayment_Header;

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

8375: END IF;
8376: --bug11655195 end
8377:
8378: IF (SQLCODE <> -20001) THEN
8379: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8380: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
8381: l_curr_calling_sequence);
8382: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8383: 'p_invoice_id = '||p_invoice_id);

Line 8380: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

8376: --bug11655195 end
8377:
8378: IF (SQLCODE <> -20001) THEN
8379: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8380: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
8381: l_curr_calling_sequence);
8382: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8383: 'p_invoice_id = '||p_invoice_id);
8384: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);

Line 8382: FND_MESSAGE.SET_TOKEN('PARAMETERS',

8378: IF (SQLCODE <> -20001) THEN
8379: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
8380: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
8381: l_curr_calling_sequence);
8382: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8383: 'p_invoice_id = '||p_invoice_id);
8384: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
8385: END IF;
8386: APP_EXCEPTION.RAISE_EXCEPTION();

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

8380: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
8381: l_curr_calling_sequence);
8382: FND_MESSAGE.SET_TOKEN('PARAMETERS',
8383: 'p_invoice_id = '||p_invoice_id);
8384: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
8385: END IF;
8386: APP_EXCEPTION.RAISE_EXCEPTION();
8387:
8388: END;