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