DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_PUB_PKG dependencies on XLA_ACCT_PROG_DOCS_GT

Line 530: UPDATE xla_acct_prog_docs_gt xap

526: ,p_level => C_LEVEL_PROCEDURE
527: ,p_module => l_log_module);
528: END IF;
529:
530: UPDATE xla_acct_prog_docs_gt xap
531: SET entity_id =
532: (SELECT xte.entity_id
533: FROM xla_transaction_entities xte
534: WHERE xte.application_id = p_application_id

Line 549: FROM xla_acct_prog_docs_gt xap

545: AND NVL(xte.source_id_char_4,C_CHAR) = NVL(xap.source_id_char_4,C_CHAR))
546: WHERE xap.entity_id IS NULL;
547:
548: SELECT count(*) INTO l_count
549: FROM xla_acct_prog_docs_gt xap
550: WHERE entity_id IS NULL
551: OR NOT EXISTS (SELECT entity_id
552: FROM xla_transaction_entities xte
553: WHERE xte.application_id = p_application_id

Line 559: (p_msg => 'Invalid entity is used in the xla_acct_prog_docs_gt'

555:
556: IF (l_count > 0) THEN
557: IF (C_LEVEL_ERROR >= g_log_level) THEN
558: trace
559: (p_msg => 'Invalid entity is used in the xla_acct_prog_docs_gt'
560: ,p_level => C_LEVEL_ERROR
561: ,p_module =>l_log_module);
562: END IF;
563: xla_exceptions_pkg.raise_message

Line 567: ,p_value_1 => 'Invalid entity is used in the xla_acct_prog_docs_gt'

563: xla_exceptions_pkg.raise_message
564: (p_appli_s_name => 'XLA'
565: ,p_msg_name => 'XLA_COMMON_ERROR'
566: ,p_token_1 => 'ERROR'
567: ,p_value_1 => 'Invalid entity is used in the xla_acct_prog_docs_gt'
568: ,p_token_2 => 'LOCATION'
569: ,p_value_2 => 'xla_accounting_pub_pkg.accounting_program_doc_batch');
570:
571: END IF;

Line 575: FROM xla_acct_prog_docs_gt xap

571: END IF;
572:
573: INSERT INTO XLA_ACCT_PROG_EVENTS_GT(event_id, ledger_id)
574: SELECT xe.event_id, xte.ledger_id
575: FROM xla_acct_prog_docs_gt xap
576: ,xla_events xe
577: ,xla_transaction_entities xte
578: WHERE xte.application_id = p_application_id
579: AND xte.entity_id = xap.entity_id