DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on FND_MESSAGE

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

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',

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

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

Line 797: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 799: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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);

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

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;

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

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',

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

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);

Line 1530: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 1532: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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:

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

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;

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

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',

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

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

Line 1665: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 1667: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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);

Line 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;

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

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',

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

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

Line 1974: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 1976: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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);

Line 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:

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

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',

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

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);

Line 2533: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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;

Line 2535: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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;

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

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',

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

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);

Line 3171: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 3173: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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();

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

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:

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

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',

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

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

Line 3297: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 3299: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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);

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

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:

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

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',

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

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

Line 3626: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 3628: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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);

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

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:

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

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',

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

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

Line 3753: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 3755: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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);

Line 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:

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

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',

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

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);

Line 3907: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 3909: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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();

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

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:

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

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',

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

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

Line 4114: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 4116: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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;

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

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:

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

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',

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

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

Line 4406: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 4408: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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);

Line 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:

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

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',

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

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

Line 5110: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 5112: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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;

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

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:

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

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',

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

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);

Line 5345: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 5347: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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();

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

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:

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

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',

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

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

Line 5657: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 5659: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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);

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

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:

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

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',

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

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

Line 6152: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 6154: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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

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

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:

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

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',

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

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

Line 6509: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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

Line 6511: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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);

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

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:

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

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 );

Line 6640: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 6642: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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();

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

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:

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

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);

Line 6929: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 6931: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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();

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

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:

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

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);

Line 7010: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 7012: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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();

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

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:

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

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);

Line 7101: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 7103: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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();

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

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;

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

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);

Line 7391: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE',

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);

Line 7393: FND_MESSAGE.SET_TOKEN('PARAMETERS',

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();

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

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;