DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on FND_LOG_MESSAGES

Line 275: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

271: l_curr_calling_sequence VARCHAR2(2000);
272:
273: -- Logging:
274: l_procedure_name CONSTANT VARCHAR2(30) := 'delete_invoice_event';
275: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
276:
277: l_event_status VARCHAR2(1);
278: l_legal_entity_id NUMBER(15);
279: l_ledger_id NUMBER(15);

Line 408: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

404: l_curr_calling_sequence VARCHAR2(2000);
405:
406: -- Logging:
407: l_procedure_name CONSTANT VARCHAR2(30) := 'Create_Events';
408: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
409:
410: BEGIN
411:
412: l_curr_calling_sequence :=

Line 1055: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1051: l_transaction_date AP_INVOICES_ALL.invoice_date%TYPE;
1052:
1053: -- Logging:
1054: l_procedure_name CONSTANT VARCHAR2(30) := 'DERIVE_INVOICE_EVENTS';
1055: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1056:
1057: TYPE l_inv_dist_list IS TABLE OF ap_invoice_distributions.invoice_distribution_id%TYPE;
1058: l_inv_dist_tab l_inv_dist_list;
1059:

Line 1841: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1837: l_curr_calling_sequence VARCHAR2(2000);
1838:
1839: -- Logging:
1840: l_procedure_name CONSTANT VARCHAR2(30) := 'CREATE_INVOICE_EVENT';
1841: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1842:
1843: BEGIN
1844:
1845: l_curr_calling_sequence :=

Line 1985: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1981: l_curr_calling_sequence VARCHAR2(2000);
1982:
1983: -- Logging:
1984: l_procedure_name CONSTANT VARCHAR2(30) := 'CREATE_PAYMENT_EVENT';
1985: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1986: l_when_to_acct ap_system_parameters.when_to_account_pmt%TYPE; --bug 8771563
1987:
1988: -- Bug 7374984.
1989: -- Cursor to get all the unaccounted maturity and clearing transactions

Line 2521: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2517: l_curr_calling_sequence VARCHAR2(2000);
2518:
2519: -- Logging:
2520: l_procedure_name CONSTANT VARCHAR2(30) := 'update_invoice_events_status';
2521: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2522: --7011943
2523: l_count NUMBER;
2524: l_check_id NUMBER;
2525: l_pmt_awt_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;

Line 3100: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3096: l_curr_calling_sequence VARCHAR2(2000);
3097:
3098: -- Logging:
3099: l_procedure_name CONSTANT VARCHAR2(30) := 'UPDATE_PAYMENT_EVENTS_STATUS';
3100: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3101: --7011943
3102: l_count NUMBER;
3103: l_check_id NUMBER;
3104: l_pmt_awt_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;

Line 3734: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3730:
3731: -- Logging:
3732: --4700081
3733: l_procedure_name CONSTANT VARCHAR2(40) := 'update_payment_batch_event_status';
3734: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3735:
3736: BEGIN
3737:
3738: l_curr_calling_sequence := p_calling_sequence ||

Line 3868: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3864: l_count NUMBER := 0;
3865:
3866: -- Logging:
3867: l_procedure_name CONSTANT VARCHAR2(30) := 'CREATE_PAYMENT_BATCH_EVENTS';
3868: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3869:
3870: --bug 8358552 starts
3871: l_dummy number;
3872: --bug 8358552 ends

Line 4217: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4213: l_curr_calling_sequence VARCHAR2(2000);
4214:
4215: -- Logging:
4216: l_procedure_name CONSTANT VARCHAR2(30) := 'UPDATE_AWT_INT_DISTS';
4217: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4218:
4219: BEGIN
4220:
4221: l_curr_calling_sequence :=

Line 4363: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4359: l_curr_calling_sequence VARCHAR2(2000);
4360:
4361: -- Logging:
4362: l_procedure_name CONSTANT VARCHAR2(30) := 'BATCH_UPDATE_PAYMENT_INFO';
4363: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4364:
4365: BEGIN
4366:
4367: l_curr_calling_sequence := p_calling_sequence ||

Line 4520: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4516: l_curr_calling_sequence VARCHAR2(2000);
4517:
4518: -- Logging:
4519: l_procedure_name CONSTANT VARCHAR2(30) := 'BATCH_UPDATE_PAYMENT_INFO';
4520: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4521:
4522: BEGIN
4523:
4524: l_curr_calling_sequence :=

Line 4751: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4747: l_curr_calling_sequence VARCHAR2(2000);
4748:
4749: -- Logging:
4750: l_procedure_name CONSTANT VARCHAR2(30) := 'BATCH_UPDATE_PAYMENT_INFO';
4751: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4752:
4753:
4754: BEGIN
4755:

Line 5251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5247: l_org_id NUMBER;
5248:
5249: -- Logging:
5250: l_procedure_name CONSTANT VARCHAR2(30) := 'DERIVE_CASCADE_EVENTS';
5251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5252:
5253: l_event_type xla_events.event_type_code%TYPE;
5254: l_pay_type ap_checks_all.payment_type_flag%TYPE;
5255: l_automatic_offsets_flag ap_system_parameters_all.automatic_offsets_flag%TYPE; ---7209263

Line 5964: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5960: l_curr_calling_sequence VARCHAR2(2000);
5961:
5962: -- Logging:
5963: l_procedure_name CONSTANT VARCHAR2(30) := 'DERIVE_INVOICE_CANCEL_EVENT';
5964: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5965:
5966: BEGIN
5967:
5968: l_curr_calling_sequence := p_calling_sequence ||

Line 6157: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

6153: l_curr_calling_sequence VARCHAR2(2000);
6154:
6155: -- Logging:
6156: l_procedure_name CONSTANT VARCHAR2(30) := 'NO_ACTION_PMT_EVENT_UPDATE';
6157: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
6158:
6159: BEGIN
6160:
6161: l_curr_calling_sequence := p_calling_sequence ||

Line 6607: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

6603: l_curr_calling_sequence VARCHAR2(2000);
6604:
6605: -- Logging:
6606: l_procedure_name CONSTANT VARCHAR2(30) := 'MULTI_ORG_EVENTS_SWEEP';
6607: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
6608:
6609: BEGIN
6610:
6611: l_curr_calling_sequence :=

Line 7017: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

7013: l_curr_calling_sequence VARCHAR2(2000);
7014:
7015: -- Logging:
7016: l_procedure_name CONSTANT VARCHAR2(30) := 'SINGLE_ORG_EVENTS_SWEEP';
7017: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
7018:
7019: BEGIN
7020:
7021: l_curr_calling_sequence := p_calling_sequence

Line 7297: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

7293: l_curr_calling_sequence VARCHAR2(2000);
7294:
7295: -- Logging:
7296: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_CLASS_CODE';
7297: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
7298:
7299: BEGIN
7300:
7301: l_curr_calling_sequence :=

Line 7427: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

7423: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
7424:
7425: -- Logging:
7426: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_EVENT_SECURITY_CONTEXT';
7427: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
7428:
7429: BEGIN
7430:
7431: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 7488: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

7484: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
7485:
7486: -- Logging:
7487: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_EVENT_SOURCE_INFO';
7488: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
7489:
7490: BEGIN
7491:
7492: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 7560: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

7556: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
7557:
7558: -- Logging:
7559: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_PAYMENT_EVENT_SOURCE_INFO';
7560: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
7561:
7562: BEGIN
7563:
7564: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 7632: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

7628: l_curr_calling_sequence VARCHAR2(2000);
7629:
7630: -- Logging:
7631: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_EVENT_SOURCE_INFO';
7632: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
7633:
7634: BEGIN
7635:
7636: l_curr_calling_sequence :=

Line 7717: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

7713: l_curr_calling_sequence VARCHAR2(2000);
7714:
7715: -- Logging:
7716: l_procedure_name CONSTANT VARCHAR2(30) := 'GET_PAYMENT_INFO';
7717: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
7718:
7719: BEGIN
7720:
7721: l_curr_calling_sequence :=

Line 7797: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

7793: l_related_prepay_app_event_id AP_PREPAY_HISTORY_ALL.related_prepay_app_event_id%TYPE;
7794:
7795: -- Logging:
7796: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_Prepayment_Header';
7797: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
7798:
7799: BEGIN
7800:
7801: l_curr_calling_sequence := p_calling_sequence ||

Line 7918: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

7914: l_related_prepay_app_event_id NUMBER;
7915:
7916: -- Logging:
7917: l_procedure_name CONSTANT VARCHAR2(30) := 'Insert_Prepayment_Header';
7918: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
7919:
7920: --bugfix:4936043
7921: CURSOR prepayment_invoices IS
7922: SELECT AIL.amount,

Line 8251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

8247: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
8248: l_invoice_id AP_INVOICES_ALL.invoice_id%TYPE;
8249: l_accounting_event_id XLA_EVENTS.event_id%TYPE;
8250: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
8251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
8252:
8253: l_procedure_name CONSTANT VARCHAR2(30) := 'Set_Prepay_Event_Noaction';
8254:
8255: BEGIN