APPS.LNS_DISTRIBUTIONS_PUB dependencies on XLA_ACCOUNTING_ERRORS

Line 4285: from xla_accounting_errors err

4281:
4282: -- cursor to get accounting errors
4283: cursor c_acc_errors (p_loan_id number, p_accounting_batch_id number) is
4284: select xlt.transaction_number, xlt.entity_code, err.encoded_msg
4285: from xla_accounting_errors err
4286: ,xla_transaction_entities xlt
4287: where xlt.application_id = 222
4288: --and err.accounting_batch_id = nvl(p_accounting_batch_id, null)
4289: and xlt.entity_id = err.entity_id

Line 4586: /* query XLA_ACCOUNTING_ERRORS */

4582: if l_retcode <> 0 then
4583:
4584: logMessage(FND_LOG.level_unexpected, G_PKG_NAME, 'Online accounting failed with error: ' || l_errbuf);
4585:
4586: /* query XLA_ACCOUNTING_ERRORS */
4587: l_error_counter := 0;
4588: open c_acc_errors(p_loan_id, l_accounting_batch_id);
4589:
4590: LOOP

Line 5095: from xla_accounting_errors err

5091:
5092: -- this is only for loans entities
5093: cursor c_acc_errors (p_loan_id number, p_accounting_batch_id number) is
5094: select xlt.transaction_number, xlt.entity_code, err.encoded_msg
5095: from xla_accounting_errors err
5096: ,xla_Transaction_entities xlt
5097: where xlt.application_id = 206
5098: and err.accounting_batch_id = p_accounting_batch_id
5099: and err.entity_id = xlt.entity_id

Line 5252: /* query XLA_ACCOUNTING_ERRORS */

5248:
5249: elsif l_retcode = 1 then
5250:
5251: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'online accounting failed ' || l_errbuf);
5252: /* query XLA_ACCOUNTING_ERRORS */
5253: l_error_counter := 0;
5254: open c_acc_errors(p_loan_id, l_accounting_batch_id);
5255:
5256: LOOP

Line 6578: from xla_accounting_errors err

6574:
6575: -- cursor to get accounting errors
6576: cursor c_acc_errors (p_loan_line_id number, p_accounting_batch_id number) is
6577: select xlt.transaction_number, xlt.entity_code, err.encoded_msg
6578: from xla_accounting_errors err
6579: ,xla_transaction_entities xlt
6580: where xlt.application_id = 222
6581: --and err.accounting_batch_id = nvl(p_accounting_batch_id, null)
6582: and xlt.entity_id = err.entity_id

Line 6838: /* query XLA_ACCOUNTING_ERRORS */

6834: if l_retcode <> 0 then
6835:
6836: logMessage(FND_LOG.level_unexpected, G_PKG_NAME, 'Online accounting failed with error: ' || l_errbuf);
6837:
6838: /* query XLA_ACCOUNTING_ERRORS */
6839: l_error_counter := 0;
6840: open c_acc_errors(p_loan_line_id, l_accounting_batch_id);
6841:
6842: LOOP

Line 9080: FROM xla_accounting_errors err

9076:
9077: -- cursor to get accounting errors
9078: CURSOR cur_acc_errors(c_event_id NUMBER) IS
9079: SELECT xlt.transaction_number, xlt.entity_code, err.encoded_msg
9080: FROM xla_accounting_errors err
9081: ,xla_transaction_entities xlt
9082: WHERE xlt.application_id = 206
9083: AND xlt.entity_id = err.entity_id
9084: AND err.event_id = C_EVENT_ID;