791:
792: EXCEPTION
793: WHEN OTHERS THEN
794: IF (SQLCODE <> -20001) THEN
795: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
796: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
797: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
798: l_curr_calling_sequence);
799: FND_MESSAGE.SET_TOKEN('PARAMETERS',
792: EXCEPTION
793: WHEN OTHERS THEN
794: IF (SQLCODE <> -20001) THEN
795: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
796: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
797: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
798: l_curr_calling_sequence);
799: FND_MESSAGE.SET_TOKEN('PARAMETERS',
800: 'p_doc_type = '||p_doc_type
793: WHEN OTHERS THEN
794: IF (SQLCODE <> -20001) THEN
795: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
796: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
797: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
798: l_curr_calling_sequence);
799: FND_MESSAGE.SET_TOKEN('PARAMETERS',
800: 'p_doc_type = '||p_doc_type
801: ||', p_doc_id = '||p_doc_id
795: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
796: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
797: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
798: l_curr_calling_sequence);
799: FND_MESSAGE.SET_TOKEN('PARAMETERS',
800: 'p_doc_type = '||p_doc_type
801: ||', p_doc_id = '||p_doc_id
802: ||', p_accounting_date = '||p_accounting_date
803: ||', p_checkrun_name = '||p_checkrun_name);
800: 'p_doc_type = '||p_doc_type
801: ||', p_doc_id = '||p_doc_id
802: ||', p_accounting_date = '||p_accounting_date
803: ||', p_checkrun_name = '||p_checkrun_name);
804: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
805: END IF;
806: APP_EXCEPTION.RAISE_EXCEPTION();
807:
808: END create_events;
1524: CLOSE inv_event_dists;
1525: END IF;
1526:
1527: IF (SQLCODE <> -20001) THEN
1528: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1529: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1531: l_curr_calling_sequence);
1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1525: END IF;
1526:
1527: IF (SQLCODE <> -20001) THEN
1528: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1529: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1531: l_curr_calling_sequence);
1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1533: 'p_invoice_id = '||p_invoice_id);
1526:
1527: IF (SQLCODE <> -20001) THEN
1528: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1529: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1531: l_curr_calling_sequence);
1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1533: 'p_invoice_id = '||p_invoice_id);
1534: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1528: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1529: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1531: l_curr_calling_sequence);
1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1533: 'p_invoice_id = '||p_invoice_id);
1534: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1535: END IF;
1536:
1530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1531: l_curr_calling_sequence);
1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1533: 'p_invoice_id = '||p_invoice_id);
1534: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1535: END IF;
1536:
1537: APP_EXCEPTION.RAISE_EXCEPTION();
1538: END derive_invoice_events;
1659:
1660: EXCEPTION
1661: WHEN OTHERS THEN
1662: IF (SQLCODE <> -20001) THEN
1663: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1664: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1665: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1666: l_curr_calling_sequence);
1667: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1660: EXCEPTION
1661: WHEN OTHERS THEN
1662: IF (SQLCODE <> -20001) THEN
1663: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1664: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1665: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1666: l_curr_calling_sequence);
1667: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1668: 'p_event_type = '||p_event_type
1661: WHEN OTHERS THEN
1662: IF (SQLCODE <> -20001) THEN
1663: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1664: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1665: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1666: l_curr_calling_sequence);
1667: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1668: 'p_event_type = '||p_event_type
1669: ||', p_invoice_id = '||p_invoice_id
1663: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1664: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1665: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1666: l_curr_calling_sequence);
1667: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1668: 'p_event_type = '||p_event_type
1669: ||', p_invoice_id = '||p_invoice_id
1670: ||', p_event_date = '||p_event_date);
1671: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1667: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1668: 'p_event_type = '||p_event_type
1669: ||', p_invoice_id = '||p_invoice_id
1670: ||', p_event_date = '||p_event_date);
1671: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1672: END IF;
1673:
1674: APP_EXCEPTION.RAISE_EXCEPTION();
1675: END create_invoice_event;
1968:
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: IF (SQLCODE <> -20001) THEN
1972: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1973: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1974: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1975: l_curr_calling_sequence);
1976: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1969: EXCEPTION
1970: WHEN OTHERS THEN
1971: IF (SQLCODE <> -20001) THEN
1972: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1973: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1974: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1975: l_curr_calling_sequence);
1976: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1977: 'p_event_type = '||p_event_type
1970: WHEN OTHERS THEN
1971: IF (SQLCODE <> -20001) THEN
1972: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1973: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1974: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1975: l_curr_calling_sequence);
1976: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1977: 'p_event_type = '||p_event_type
1978: ||', p_check_id = '||p_check_id
1972: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
1973: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
1974: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
1975: l_curr_calling_sequence);
1976: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1977: 'p_event_type = '||p_event_type
1978: ||', p_check_id = '||p_check_id
1979: ||', p_event_date = '||p_event_date);
1980: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1976: FND_MESSAGE.SET_TOKEN('PARAMETERS',
1977: 'p_event_type = '||p_event_type
1978: ||', p_check_id = '||p_check_id
1979: ||', p_event_date = '||p_event_date);
1980: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
1981: END IF;
1982: APP_EXCEPTION.RAISE_EXCEPTION();
1983: END create_payment_event;
1984:
2527:
2528: EXCEPTION
2529: WHEN OTHERS THEN
2530: IF (SQLCODE <> -20001) THEN
2531: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2532: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2533: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2534: l_curr_calling_sequence);
2535: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2528: EXCEPTION
2529: WHEN OTHERS THEN
2530: IF (SQLCODE <> -20001) THEN
2531: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2532: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2533: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2534: l_curr_calling_sequence);
2535: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2536: 'p_invoice_id = '||p_invoice_id);
2529: WHEN OTHERS THEN
2530: IF (SQLCODE <> -20001) THEN
2531: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2532: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2533: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2534: l_curr_calling_sequence);
2535: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2536: 'p_invoice_id = '||p_invoice_id);
2537: END IF;
2531: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
2532: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
2533: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
2534: l_curr_calling_sequence);
2535: FND_MESSAGE.SET_TOKEN('PARAMETERS',
2536: 'p_invoice_id = '||p_invoice_id);
2537: END IF;
2538: APP_EXCEPTION.RAISE_EXCEPTION();
2539: END update_invoice_events_status;
3165:
3166: EXCEPTION
3167: WHEN OTHERS THEN
3168: IF (SQLCODE <> -20001) THEN
3169: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3170: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3171: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3172: l_curr_calling_sequence);
3173: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3166: EXCEPTION
3167: WHEN OTHERS THEN
3168: IF (SQLCODE <> -20001) THEN
3169: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3170: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3171: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3172: l_curr_calling_sequence);
3173: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3174: 'p_check_id = '||p_check_id);
3167: WHEN OTHERS THEN
3168: IF (SQLCODE <> -20001) THEN
3169: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3170: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3171: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3172: l_curr_calling_sequence);
3173: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3174: 'p_check_id = '||p_check_id);
3175: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3169: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3170: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3171: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3172: l_curr_calling_sequence);
3173: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3174: 'p_check_id = '||p_check_id);
3175: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3176: END IF;
3177: APP_EXCEPTION.RAISE_EXCEPTION();
3171: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3172: l_curr_calling_sequence);
3173: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3174: 'p_check_id = '||p_check_id);
3175: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3176: END IF;
3177: APP_EXCEPTION.RAISE_EXCEPTION();
3178: END update_payment_events_status;
3179:
3291: EXCEPTION
3292: WHEN OTHERS THEN
3293:
3294: IF (SQLCODE <> -20001) THEN
3295: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3296: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3297: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3298: l_curr_calling_sequence);
3299: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3292: WHEN OTHERS THEN
3293:
3294: IF (SQLCODE <> -20001) THEN
3295: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3296: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3297: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3298: l_curr_calling_sequence);
3299: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3300: 'p_checkrun_name = '||p_checkrun_name
3293:
3294: IF (SQLCODE <> -20001) THEN
3295: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3296: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3297: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3298: l_curr_calling_sequence);
3299: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3300: 'p_checkrun_name = '||p_checkrun_name
3301: ||', p_completed_pmts_group_id = '||p_completed_pmts_group_id
3295: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3296: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3297: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3298: l_curr_calling_sequence);
3299: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3300: 'p_checkrun_name = '||p_checkrun_name
3301: ||', p_completed_pmts_group_id = '||p_completed_pmts_group_id
3302: ||', p_org_id = '||p_org_id
3303: ||', p_checkrun_name = '||p_checkrun_name);
3300: 'p_checkrun_name = '||p_checkrun_name
3301: ||', p_completed_pmts_group_id = '||p_completed_pmts_group_id
3302: ||', p_org_id = '||p_org_id
3303: ||', p_checkrun_name = '||p_checkrun_name);
3304: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3305: END IF;
3306: APP_EXCEPTION.RAISE_EXCEPTION();
3307: END update_pmt_batch_event_status;
3308:
3620: EXCEPTION
3621: WHEN OTHERS THEN
3622:
3623: IF (SQLCODE <> -20001) THEN
3624: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3625: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3626: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3627: l_curr_calling_sequence);
3628: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3621: WHEN OTHERS THEN
3622:
3623: IF (SQLCODE <> -20001) THEN
3624: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3625: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3626: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3627: l_curr_calling_sequence);
3628: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3629: 'p_completed_pmts_group_id = '||p_completed_pmts_group_id
3622:
3623: IF (SQLCODE <> -20001) THEN
3624: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3625: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3626: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3627: l_curr_calling_sequence);
3628: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3629: 'p_completed_pmts_group_id = '||p_completed_pmts_group_id
3630: ||', p_set_of_books_id = '||p_set_of_books_id
3624: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3625: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3626: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3627: l_curr_calling_sequence);
3628: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3629: 'p_completed_pmts_group_id = '||p_completed_pmts_group_id
3630: ||', p_set_of_books_id = '||p_set_of_books_id
3631: ||', p_org_id = '||p_set_of_books_id
3632: ||', p_accounting_date = '||p_accounting_date);
3629: 'p_completed_pmts_group_id = '||p_completed_pmts_group_id
3630: ||', p_set_of_books_id = '||p_set_of_books_id
3631: ||', p_org_id = '||p_set_of_books_id
3632: ||', p_accounting_date = '||p_accounting_date);
3633: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3634: END IF;
3635: APP_EXCEPTION.RAISE_EXCEPTION();
3636: END create_payment_batch_events;
3637:
3747:
3748: EXCEPTION
3749: WHEN OTHERS THEN
3750: IF (SQLCODE <> -20001) THEN
3751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3754: l_curr_calling_sequence);
3755: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3748: EXCEPTION
3749: WHEN OTHERS THEN
3750: IF (SQLCODE <> -20001) THEN
3751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3754: l_curr_calling_sequence);
3755: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3756: 'p_event_type = '||p_event_type
3749: WHEN OTHERS THEN
3750: IF (SQLCODE <> -20001) THEN
3751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3754: l_curr_calling_sequence);
3755: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3756: 'p_event_type = '||p_event_type
3757: ||', p_check_id = '||p_check_id
3751: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3752: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3754: l_curr_calling_sequence);
3755: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3756: 'p_event_type = '||p_event_type
3757: ||', p_check_id = '||p_check_id
3758: ||', p_event_id = '||p_event_id);
3759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3755: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3756: 'p_event_type = '||p_event_type
3757: ||', p_check_id = '||p_check_id
3758: ||', p_event_id = '||p_event_id);
3759: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3760: END IF;
3761: APP_EXCEPTION.RAISE_EXCEPTION();
3762: END update_awt_int_dists;
3763:
3901: CLOSE get_payment_info;
3902: END IF;
3903:
3904: IF (SQLCODE <> -20001) THEN
3905: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3906: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3907: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3908: l_curr_calling_sequence);
3909: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3902: END IF;
3903:
3904: IF (SQLCODE <> -20001) THEN
3905: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3906: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3907: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3908: l_curr_calling_sequence);
3909: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3910: ' p_checkrun_name = '|| p_checkrun_name);
3903:
3904: IF (SQLCODE <> -20001) THEN
3905: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3906: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3907: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3908: l_curr_calling_sequence);
3909: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3910: ' p_checkrun_name = '|| p_checkrun_name);
3911: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3905: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3906: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3907: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3908: l_curr_calling_sequence);
3909: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3910: ' p_checkrun_name = '|| p_checkrun_name);
3911: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3912: END IF;
3913: APP_EXCEPTION.RAISE_EXCEPTION();
3907: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
3908: l_curr_calling_sequence);
3909: FND_MESSAGE.SET_TOKEN('PARAMETERS',
3910: ' p_checkrun_name = '|| p_checkrun_name);
3911: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
3912: END IF;
3913: APP_EXCEPTION.RAISE_EXCEPTION();
3914: END batch_update_payment_info;
3915:
4108:
4109: EXCEPTION
4110: WHEN OTHERS THEN
4111: IF (SQLCODE <> -20001) THEN
4112: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4113: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4114: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4115: l_curr_calling_sequence);
4116: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4109: EXCEPTION
4110: WHEN OTHERS THEN
4111: IF (SQLCODE <> -20001) THEN
4112: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4113: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4114: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4115: l_curr_calling_sequence);
4116: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4117: 'p_doc_type = '||p_doc_type
4110: WHEN OTHERS THEN
4111: IF (SQLCODE <> -20001) THEN
4112: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4113: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4114: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4115: l_curr_calling_sequence);
4116: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4117: 'p_doc_type = '||p_doc_type
4118: ||', p_source_id = '||p_source_id);
4112: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4113: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4114: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4115: l_curr_calling_sequence);
4116: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4117: 'p_doc_type = '||p_doc_type
4118: ||', p_source_id = '||p_source_id);
4119: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4120: END IF;
4115: l_curr_calling_sequence);
4116: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4117: 'p_doc_type = '||p_doc_type
4118: ||', p_source_id = '||p_source_id);
4119: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4120: END IF;
4121: APP_EXCEPTION.RAISE_EXCEPTION();
4122: END is_event_complete;
4123:
4400: IF (l_event_cur%ISOPEN) THEN
4401: CLOSE l_event_cur;
4402: END IF;
4403: IF (SQLCODE <> -20001) THEN
4404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4405: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4407: l_curr_calling_sequence);
4408: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4401: CLOSE l_event_cur;
4402: END IF;
4403: IF (SQLCODE <> -20001) THEN
4404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4405: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4407: l_curr_calling_sequence);
4408: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4409: 'p_check_id = '||p_check_id
4402: END IF;
4403: IF (SQLCODE <> -20001) THEN
4404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4405: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4407: l_curr_calling_sequence);
4408: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4409: 'p_check_id = '||p_check_id
4410: ||', p_accounting_date = '||p_accounting_date
4404: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
4405: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
4406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
4407: l_curr_calling_sequence);
4408: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4409: 'p_check_id = '||p_check_id
4410: ||', p_accounting_date = '||p_accounting_date
4411: ||', p_event_type = ' ||p_event_type);
4412: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4408: FND_MESSAGE.SET_TOKEN('PARAMETERS',
4409: 'p_check_id = '||p_check_id
4410: ||', p_accounting_date = '||p_accounting_date
4411: ||', p_event_type = ' ||p_event_type);
4412: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
4413: END IF;
4414: APP_EXCEPTION.RAISE_EXCEPTION();
4415: END derive_payment_adj_event;
4416:
5104: IF (l_payment_maturities_cur%ISOPEN) THEN
5105: CLOSE l_payment_maturities_cur;
5106: END IF;
5107: IF (SQLCODE <> -20001) THEN
5108: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5109: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5110: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5111: l_curr_calling_sequence);
5112: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5105: CLOSE l_payment_maturities_cur;
5106: END IF;
5107: IF (SQLCODE <> -20001) THEN
5108: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5109: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5110: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5111: l_curr_calling_sequence);
5112: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5113: 'p_invoice_id = '||p_invoice_id
5106: END IF;
5107: IF (SQLCODE <> -20001) THEN
5108: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5109: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5110: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5111: l_curr_calling_sequence);
5112: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5113: 'p_invoice_id = '||p_invoice_id
5114: ||', p_adj_accounting_event_id = '||p_adj_accounting_event_id);
5108: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5109: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5110: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5111: l_curr_calling_sequence);
5112: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5113: 'p_invoice_id = '||p_invoice_id
5114: ||', p_adj_accounting_event_id = '||p_adj_accounting_event_id);
5115: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
5116: END IF;
5111: l_curr_calling_sequence);
5112: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5113: 'p_invoice_id = '||p_invoice_id
5114: ||', p_adj_accounting_event_id = '||p_adj_accounting_event_id);
5115: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
5116: END IF;
5117: APP_EXCEPTION.RAISE_EXCEPTION();
5118: END derive_cascade_events;
5119:
5339: IF (all_unaccounted_dists_cur%ISOPEN) THEN
5340: CLOSE all_unaccounted_dists_cur;
5341: END IF;
5342: IF (SQLCODE <> -20001) THEN
5343: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5344: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5345: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5346: l_curr_calling_sequence);
5347: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5340: CLOSE all_unaccounted_dists_cur;
5341: END IF;
5342: IF (SQLCODE <> -20001) THEN
5343: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5344: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5345: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5346: l_curr_calling_sequence);
5347: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5348: 'p_invoice_id = '||p_invoice_id);
5341: END IF;
5342: IF (SQLCODE <> -20001) THEN
5343: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5344: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5345: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5346: l_curr_calling_sequence);
5347: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5348: 'p_invoice_id = '||p_invoice_id);
5349: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
5343: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5344: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5345: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5346: l_curr_calling_sequence);
5347: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5348: 'p_invoice_id = '||p_invoice_id);
5349: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
5350: END IF;
5351: APP_EXCEPTION.RAISE_EXCEPTION();
5345: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5346: l_curr_calling_sequence);
5347: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5348: 'p_invoice_id = '||p_invoice_id);
5349: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
5350: END IF;
5351: APP_EXCEPTION.RAISE_EXCEPTION();
5352: END derive_invoice_cancel_events;
5353:
5651:
5652: EXCEPTION
5653: WHEN OTHERS THEN
5654: IF (SQLCODE <> -20001) THEN
5655: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5656: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5657: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5658: l_curr_calling_sequence);
5659: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5652: EXCEPTION
5653: WHEN OTHERS THEN
5654: IF (SQLCODE <> -20001) THEN
5655: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5656: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5657: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5658: l_curr_calling_sequence);
5659: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5660: 'p_check_id = '||p_check_id
5653: WHEN OTHERS THEN
5654: IF (SQLCODE <> -20001) THEN
5655: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5656: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5657: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5658: l_curr_calling_sequence);
5659: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5660: 'p_check_id = '||p_check_id
5661: ||', p_event_type_code = '||p_event_type_code
5655: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
5656: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
5657: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
5658: l_curr_calling_sequence);
5659: FND_MESSAGE.SET_TOKEN('PARAMETERS',
5660: 'p_check_id = '||p_check_id
5661: ||', p_event_type_code = '||p_event_type_code
5662: ||', p_accounting_date = '||p_accounting_date
5663: ||', p_accounting_event_id = '||p_accounting_event_id);
5660: 'p_check_id = '||p_check_id
5661: ||', p_event_type_code = '||p_event_type_code
5662: ||', p_accounting_date = '||p_accounting_date
5663: ||', p_accounting_event_id = '||p_accounting_event_id);
5664: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
5665: END IF;
5666: APP_EXCEPTION.RAISE_EXCEPTION();
5667: END no_action_pmt_event_update;
5668:
6146: END IF;
6147: end if;
6148:
6149: IF (SQLCODE <> -20001) THEN
6150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6153: l_curr_calling_sequence);
6154: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6147: end if;
6148:
6149: IF (SQLCODE <> -20001) THEN
6150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6153: l_curr_calling_sequence);
6154: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6155: 'p_ledger_id = '||p_ledger_id
6148:
6149: IF (SQLCODE <> -20001) THEN
6150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6153: l_curr_calling_sequence);
6154: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6155: 'p_ledger_id = '||p_ledger_id
6156: ||', p_period_name = '||p_period_name
6150: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6151: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6153: l_curr_calling_sequence);
6154: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6155: 'p_ledger_id = '||p_ledger_id
6156: ||', p_period_name = '||p_period_name
6157: ||', p_from_date = '||p_from_date
6158: ||', p_to_date = '||p_to_date
6156: ||', p_period_name = '||p_period_name
6157: ||', p_from_date = '||p_from_date
6158: ||', p_to_date = '||p_to_date
6159: ||', p_sweep_to_date = '||p_sweep_to_date);
6160: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6161: END IF;
6162: APP_EXCEPTION.RAISE_EXCEPTION();
6163: END multi_org_events_sweep;
6164:
6503: END IF;
6504: end if;
6505:
6506: IF (SQLCODE <> -20001) THEN
6507: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6508: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6509: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6510: l_curr_calling_sequence);
6511: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6504: end if;
6505:
6506: IF (SQLCODE <> -20001) THEN
6507: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6508: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6509: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6510: l_curr_calling_sequence);
6511: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6512: 'p_period_name = '||p_period_name
6505:
6506: IF (SQLCODE <> -20001) THEN
6507: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6508: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6509: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6510: l_curr_calling_sequence);
6511: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6512: 'p_period_name = '||p_period_name
6513: ||', p_from_date = '||p_from_date
6507: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
6508: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6509: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6510: l_curr_calling_sequence);
6511: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6512: 'p_period_name = '||p_period_name
6513: ||', p_from_date = '||p_from_date
6514: ||', p_to_date = '||p_to_date
6515: ||', p_sweep_to_date = '||p_sweep_to_date);
6512: 'p_period_name = '||p_period_name
6513: ||', p_from_date = '||p_from_date
6514: ||', p_to_date = '||p_to_date
6515: ||', p_sweep_to_date = '||p_sweep_to_date);
6516: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6517: END IF;
6518: APP_EXCEPTION.RAISE_EXCEPTION();
6519: END single_org_events_sweep;
6520:
6635: RETURN RECONCILED_PAYMENTS_CLASS;
6636: END IF;
6637:
6638:
6639: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6640: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6641: l_curr_calling_sequence);
6642: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6643: 'p_event_type = '||p_event_type );
6636: END IF;
6637:
6638:
6639: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6640: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6641: l_curr_calling_sequence);
6642: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6643: 'p_event_type = '||p_event_type );
6644: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6638:
6639: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6640: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6641: l_curr_calling_sequence);
6642: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6643: 'p_event_type = '||p_event_type );
6644: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6645:
6646: APP_EXCEPTION.RAISE_EXCEPTION();
6640: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6641: l_curr_calling_sequence);
6642: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6643: 'p_event_type = '||p_event_type );
6644: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6645:
6646: APP_EXCEPTION.RAISE_EXCEPTION();
6647: RETURN NULL; -- unreachable
6648:
6924:
6925: EXCEPTION
6926: WHEN OTHERS THEN
6927: IF (SQLCODE <> -20001) THEN
6928: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6929: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6930: l_curr_calling_sequence);
6931: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6932: 'p_org_id = '||p_org_id);
6925: EXCEPTION
6926: WHEN OTHERS THEN
6927: IF (SQLCODE <> -20001) THEN
6928: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6929: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6930: l_curr_calling_sequence);
6931: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6932: 'p_org_id = '||p_org_id);
6933: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6927: IF (SQLCODE <> -20001) THEN
6928: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
6929: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6930: l_curr_calling_sequence);
6931: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6932: 'p_org_id = '||p_org_id);
6933: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6934: END IF;
6935: APP_EXCEPTION.RAISE_EXCEPTION();
6929: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
6930: l_curr_calling_sequence);
6931: FND_MESSAGE.SET_TOKEN('PARAMETERS',
6932: 'p_org_id = '||p_org_id);
6933: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
6934: END IF;
6935: APP_EXCEPTION.RAISE_EXCEPTION();
6936: END get_invoice_info;
6937:
7005:
7006: EXCEPTION
7007: WHEN OTHERS THEN
7008: IF (SQLCODE <> -20001) THEN
7009: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7010: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7011: l_curr_calling_sequence);
7012: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7013: 'p_check_id = '||p_check_id);
7006: EXCEPTION
7007: WHEN OTHERS THEN
7008: IF (SQLCODE <> -20001) THEN
7009: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7010: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7011: l_curr_calling_sequence);
7012: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7013: 'p_check_id = '||p_check_id);
7014: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7008: IF (SQLCODE <> -20001) THEN
7009: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7010: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7011: l_curr_calling_sequence);
7012: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7013: 'p_check_id = '||p_check_id);
7014: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7015: END IF;
7016: APP_EXCEPTION.RAISE_EXCEPTION();
7010: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7011: l_curr_calling_sequence);
7012: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7013: 'p_check_id = '||p_check_id);
7014: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7015: END IF;
7016: APP_EXCEPTION.RAISE_EXCEPTION();
7017: END get_payment_info;
7018:
7096: EXCEPTION
7097: WHEN OTHERS THEN
7098:
7099: IF (SQLCODE <> -20001) THEN
7100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7102: l_curr_calling_sequence);
7103: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7104: 'p_invoice_id = '||p_invoice_id);
7097: WHEN OTHERS THEN
7098:
7099: IF (SQLCODE <> -20001) THEN
7100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7102: l_curr_calling_sequence);
7103: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7104: 'p_invoice_id = '||p_invoice_id);
7105: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7099: IF (SQLCODE <> -20001) THEN
7100: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7102: l_curr_calling_sequence);
7103: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7104: 'p_invoice_id = '||p_invoice_id);
7105: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7106: END IF;
7107: APP_EXCEPTION.RAISE_EXCEPTION();
7101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7102: l_curr_calling_sequence);
7103: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7104: 'p_invoice_id = '||p_invoice_id);
7105: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7106: END IF;
7107: APP_EXCEPTION.RAISE_EXCEPTION();
7108:
7109: END Update_Prepayment_Header;
7386: EXCEPTION
7387: WHEN OTHERS THEN
7388:
7389: IF (SQLCODE <> -20001) THEN
7390: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7391: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7392: l_curr_calling_sequence);
7393: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7394: 'p_invoice_id = '||p_invoice_id);
7387: WHEN OTHERS THEN
7388:
7389: IF (SQLCODE <> -20001) THEN
7390: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7391: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7392: l_curr_calling_sequence);
7393: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7394: 'p_invoice_id = '||p_invoice_id);
7395: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7389: IF (SQLCODE <> -20001) THEN
7390: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
7391: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7392: l_curr_calling_sequence);
7393: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7394: 'p_invoice_id = '||p_invoice_id);
7395: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7396: END IF;
7397: APP_EXCEPTION.RAISE_EXCEPTION();
7391: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',
7392: l_curr_calling_sequence);
7393: FND_MESSAGE.SET_TOKEN('PARAMETERS',
7394: 'p_invoice_id = '||p_invoice_id);
7395: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',l_log_msg);
7396: END IF;
7397: APP_EXCEPTION.RAISE_EXCEPTION();
7398:
7399: END Insert_Prepayment_Header;