eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_AE_HEADER_PKG dependencies on XLA_AE_JOURNAL_ENTRY_PKG

Line 525: -- XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

521: --
522: -- bulk performance
523: -- Following may not be needed in the bulk approach as
524: -- je status is handled in a different way.
525: -- XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
526: --
527: -- bulk performance
528: -- following initial1ses the status of je headers for each balance type
529: -- initial status is kept as 'valid'

Line 530: g_rec_header_new.array_actual_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

526: --
527: -- bulk performance
528: -- following initial1ses the status of je headers for each balance type
529: -- initial status is kept as 'valid'
530: g_rec_header_new.array_actual_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
531: g_rec_header_new.array_budget_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
532: g_rec_header_new.array_encumbrance_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
533: g_rec_header_new.array_event_status(g_header_idx) := 'X'; -- X indicates processed sucessfully.
534:

Line 531: g_rec_header_new.array_budget_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

527: -- bulk performance
528: -- following initial1ses the status of je headers for each balance type
529: -- initial status is kept as 'valid'
530: g_rec_header_new.array_actual_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
531: g_rec_header_new.array_budget_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
532: g_rec_header_new.array_encumbrance_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
533: g_rec_header_new.array_event_status(g_header_idx) := 'X'; -- X indicates processed sucessfully.
534:
535: --

Line 532: g_rec_header_new.array_encumbrance_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;

528: -- following initial1ses the status of je headers for each balance type
529: -- initial status is kept as 'valid'
530: g_rec_header_new.array_actual_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
531: g_rec_header_new.array_budget_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
532: g_rec_header_new.array_encumbrance_status(g_header_idx) := XLA_AE_JOURNAL_ENTRY_PKG.C_VALID;
533: g_rec_header_new.array_event_status(g_header_idx) := 'X'; -- X indicates processed sucessfully.
534:
535: --
536: --

Line 546: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

542:
543: END IF;
544: EXCEPTION
545: WHEN xla_exceptions_pkg.application_exception THEN
546: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
547: RAISE;
548: WHEN OTHERS THEN
549: xla_exceptions_pkg.raise_message
550: (p_location => 'XLA_AE_HEADER_PKG.InitHeader');

Line 660: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date

656: , p_accted_amt IN NUMBER -- this should be the unrounded_accounted_amount
657: , p_entered_amt IN NUMBER -- this should be the unrounded_entered_amount
658: , p_bflow_applied_to_amt IN NUMBER -- 5132302
659: , x_num_entries IN OUT NOCOPY NUMBER
660: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date
661: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
662: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
663: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L
664: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302

Line 661: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num

657: , p_entered_amt IN NUMBER -- this should be the unrounded_entered_amount
658: , p_bflow_applied_to_amt IN NUMBER -- 5132302
659: , x_num_entries IN OUT NOCOPY NUMBER
660: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date
661: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
662: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
663: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L
664: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302
665: )

Line 662: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num

658: , p_bflow_applied_to_amt IN NUMBER -- 5132302
659: , x_num_entries IN OUT NOCOPY NUMBER
660: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date
661: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
662: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
663: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L
664: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302
665: )
666: IS

Line 663: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L

659: , x_num_entries IN OUT NOCOPY NUMBER
660: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date
661: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
662: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
663: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L
664: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302
665: )
666: IS
667: --

Line 664: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302

660: , x_gl_dates IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_date
661: , x_accted_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
662: , x_entered_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num
663: , x_period_names IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_V15L
664: , x_bflow_applied_to_amts IN OUT NOCOPY xla_ae_journal_entry_pkg.t_array_num -- 5132302
665: )
666: IS
667: --
668: cursor c_one_period is

Line 713: --l_closing_statuses xla_ae_journal_entry_pkg.t_array_V30L;

709: AND end_date > p_start_date
710: AND start_date < p_end_date
711: ORDER BY start_date;
712:
713: --l_closing_statuses xla_ae_journal_entry_pkg.t_array_V30L;
714: l_days_in_periods xla_ae_journal_entry_pkg.t_array_num;
715: l_days_in_first_periods xla_ae_journal_entry_pkg.t_array_num;
716: l_days_in_last_periods xla_ae_journal_entry_pkg.t_array_num;
717:

Line 714: l_days_in_periods xla_ae_journal_entry_pkg.t_array_num;

710: AND start_date < p_end_date
711: ORDER BY start_date;
712:
713: --l_closing_statuses xla_ae_journal_entry_pkg.t_array_V30L;
714: l_days_in_periods xla_ae_journal_entry_pkg.t_array_num;
715: l_days_in_first_periods xla_ae_journal_entry_pkg.t_array_num;
716: l_days_in_last_periods xla_ae_journal_entry_pkg.t_array_num;
717:
718: l_total_months NUMBER;

Line 715: l_days_in_first_periods xla_ae_journal_entry_pkg.t_array_num;

711: ORDER BY start_date;
712:
713: --l_closing_statuses xla_ae_journal_entry_pkg.t_array_V30L;
714: l_days_in_periods xla_ae_journal_entry_pkg.t_array_num;
715: l_days_in_first_periods xla_ae_journal_entry_pkg.t_array_num;
716: l_days_in_last_periods xla_ae_journal_entry_pkg.t_array_num;
717:
718: l_total_months NUMBER;
719: l_whole_months NUMBER;

Line 716: l_days_in_last_periods xla_ae_journal_entry_pkg.t_array_num;

712:
713: --l_closing_statuses xla_ae_journal_entry_pkg.t_array_V30L;
714: l_days_in_periods xla_ae_journal_entry_pkg.t_array_num;
715: l_days_in_first_periods xla_ae_journal_entry_pkg.t_array_num;
716: l_days_in_last_periods xla_ae_journal_entry_pkg.t_array_num;
717:
718: l_total_months NUMBER;
719: l_whole_months NUMBER;
720: l_other_accted_amt NUMBER;

Line 1242: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1238: -------------------------------------------
1239: -- Validate header accounting attributes
1240: -------------------------------------------
1241: IF NVL(g_rec_header_new.array_party_change_option(p_hdr_idx),'N') NOT IN ('Y','N') THEN
1242: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1243: xla_accounting_err_pkg.build_message
1244: (p_appli_s_name => 'XLA'
1245: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
1246: ,p_token_1 => 'PRODUCT_NAME'

Line 1247: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1243: xla_accounting_err_pkg.build_message
1244: (p_appli_s_name => 'XLA'
1245: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
1246: ,p_token_1 => 'PRODUCT_NAME'
1247: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1248: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1249: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1250: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1251: END IF;

Line 1248: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1244: (p_appli_s_name => 'XLA'
1245: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
1246: ,p_token_1 => 'PRODUCT_NAME'
1247: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1248: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1249: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1250: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1251: END IF;
1252:

Line 1249: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1245: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
1246: ,p_token_1 => 'PRODUCT_NAME'
1247: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1248: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1249: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1250: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1251: END IF;
1252:
1253: IF g_rec_header_new.array_gl_transfer_flag(p_hdr_idx) NOT IN ('Y', 'N') THEN

Line 1250: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

1246: ,p_token_1 => 'PRODUCT_NAME'
1247: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1248: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1249: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1250: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1251: END IF;
1252:
1253: IF g_rec_header_new.array_gl_transfer_flag(p_hdr_idx) NOT IN ('Y', 'N') THEN
1254: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

Line 1254: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1250: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1251: END IF;
1252:
1253: IF g_rec_header_new.array_gl_transfer_flag(p_hdr_idx) NOT IN ('Y', 'N') THEN
1254: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1255: xla_accounting_err_pkg.build_message
1256: (p_appli_s_name => 'XLA'
1257: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1258: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 1261: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1257: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1258: ,p_token_1 => 'ACCT_ATTR_NAME'
1259: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
1260: ,p_token_2 => 'PRODUCT_NAME'
1261: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1262: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1263: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1264: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1265: END IF;

Line 1262: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1258: ,p_token_1 => 'ACCT_ATTR_NAME'
1259: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
1260: ,p_token_2 => 'PRODUCT_NAME'
1261: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1262: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1263: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1264: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1265: END IF;
1266:

Line 1263: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1259: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
1260: ,p_token_2 => 'PRODUCT_NAME'
1261: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1262: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1263: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1264: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1265: END IF;
1266:
1267: IF g_rec_header_new.array_trx_acct_reversal_option(p_hdr_idx) NOT IN ('Y', 'N') THEN

Line 1264: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

1260: ,p_token_2 => 'PRODUCT_NAME'
1261: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1262: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1263: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1264: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1265: END IF;
1266:
1267: IF g_rec_header_new.array_trx_acct_reversal_option(p_hdr_idx) NOT IN ('Y', 'N') THEN
1268: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

Line 1268: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1264: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1265: END IF;
1266:
1267: IF g_rec_header_new.array_trx_acct_reversal_option(p_hdr_idx) NOT IN ('Y', 'N') THEN
1268: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1269: xla_accounting_err_pkg.build_message
1270: (p_appli_s_name => 'XLA'
1271: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1272: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 1275: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1271: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1272: ,p_token_1 => 'ACCT_ATTR_NAME'
1273: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
1274: ,p_token_2 => 'PRODUCT_NAME'
1275: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1276: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1277: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1278: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1279: END IF;

Line 1276: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1272: ,p_token_1 => 'ACCT_ATTR_NAME'
1273: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
1274: ,p_token_2 => 'PRODUCT_NAME'
1275: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1276: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1277: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1278: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1279: END IF;
1280:

Line 1277: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1273: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
1274: ,p_token_2 => 'PRODUCT_NAME'
1275: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1276: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1277: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1278: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1279: END IF;
1280:
1281: IF g_rec_header_new.array_gl_date(p_hdr_idx) is NULL THEN

Line 1278: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

1274: ,p_token_2 => 'PRODUCT_NAME'
1275: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1276: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1277: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1278: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1279: END IF;
1280:
1281: IF g_rec_header_new.array_gl_date(p_hdr_idx) is NULL THEN
1282: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

Line 1282: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1278: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1279: END IF;
1280:
1281: IF g_rec_header_new.array_gl_date(p_hdr_idx) is NULL THEN
1282: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1283: xla_accounting_err_pkg.build_message
1284: (p_appli_s_name => 'XLA'
1285: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1286: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 1289: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

1285: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
1286: ,p_token_1 => 'ACCT_ATTR_NAME'
1287: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
1288: ,p_token_2 => 'PRODUCT_NAME'
1289: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1290: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1291: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1292: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1293: END IF;

Line 1290: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

1286: ,p_token_1 => 'ACCT_ATTR_NAME'
1287: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
1288: ,p_token_2 => 'PRODUCT_NAME'
1289: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1290: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1291: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1292: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1293: END IF;
1294:

Line 1291: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

1287: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
1288: ,p_token_2 => 'PRODUCT_NAME'
1289: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1290: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1291: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1292: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1293: END IF;
1294:
1295: --

Line 1292: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

1288: ,p_token_2 => 'PRODUCT_NAME'
1289: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
1290: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
1291: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
1292: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
1293: END IF;
1294:
1295: --
1296: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1331: , p_gl_dates IN xla_ae_journal_entry_pkg.t_array_date

1327: , p_num_entries IN INTEGER
1328: , p_last_hdr_idx IN INTEGER
1329: , p_recog_line_num_1 IN INTEGER
1330: , p_recog_line_num_2 IN INTEGER
1331: , p_gl_dates IN xla_ae_journal_entry_pkg.t_array_date
1332: , p_accted_amts IN xla_ae_journal_entry_pkg.t_array_num
1333: , p_entered_amts IN xla_ae_journal_entry_pkg.t_array_num
1334: , p_bflow_applied_to_amts IN xla_ae_journal_entry_pkg.t_array_num -- 5132302
1335: ) RETURN NUMBER

Line 1332: , p_accted_amts IN xla_ae_journal_entry_pkg.t_array_num

1328: , p_last_hdr_idx IN INTEGER
1329: , p_recog_line_num_1 IN INTEGER
1330: , p_recog_line_num_2 IN INTEGER
1331: , p_gl_dates IN xla_ae_journal_entry_pkg.t_array_date
1332: , p_accted_amts IN xla_ae_journal_entry_pkg.t_array_num
1333: , p_entered_amts IN xla_ae_journal_entry_pkg.t_array_num
1334: , p_bflow_applied_to_amts IN xla_ae_journal_entry_pkg.t_array_num -- 5132302
1335: ) RETURN NUMBER
1336: IS

Line 1333: , p_entered_amts IN xla_ae_journal_entry_pkg.t_array_num

1329: , p_recog_line_num_1 IN INTEGER
1330: , p_recog_line_num_2 IN INTEGER
1331: , p_gl_dates IN xla_ae_journal_entry_pkg.t_array_date
1332: , p_accted_amts IN xla_ae_journal_entry_pkg.t_array_num
1333: , p_entered_amts IN xla_ae_journal_entry_pkg.t_array_num
1334: , p_bflow_applied_to_amts IN xla_ae_journal_entry_pkg.t_array_num -- 5132302
1335: ) RETURN NUMBER
1336: IS
1337:

Line 1334: , p_bflow_applied_to_amts IN xla_ae_journal_entry_pkg.t_array_num -- 5132302

1330: , p_recog_line_num_2 IN INTEGER
1331: , p_gl_dates IN xla_ae_journal_entry_pkg.t_array_date
1332: , p_accted_amts IN xla_ae_journal_entry_pkg.t_array_num
1333: , p_entered_amts IN xla_ae_journal_entry_pkg.t_array_num
1334: , p_bflow_applied_to_amts IN xla_ae_journal_entry_pkg.t_array_num -- 5132302
1335: ) RETURN NUMBER
1336: IS
1337:
1338: l_hdr_idx NUMBER;

Line 1391: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx

1387: --**************************************************************************************************************
1388: g_rec_header_new.array_gl_date(l_hdr_idx) := trunc(p_gl_dates(i));
1389:
1390:
1391: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx
1392: ,p_balance_type_code => 'A');
1393:
1394: -----------------------------------------------------------
1395: -- create recognition line - for Recognition JLT1

Line 1414: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx

1410:
1411: XLA_AE_LINES_PKG.ValidateCurrentLine;
1412: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1413:
1414: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx
1415: ,p_balance_type_code => 'A');
1416:
1417: -----------------------------------------------------------
1418: -- create recognition line - for Recognition JLT2

Line 1436: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx

1432: g_rec_header_new.array_gl_date(l_hdr_idx);
1433: XLA_AE_LINES_PKG.ValidateCurrentLine;
1434: XLA_AE_LINES_PKG.SetDebitCreditAmounts;
1435:
1436: XLA_AE_JOURNAL_ENTRY_PKG.UpdateJournalEntryStatus (p_hdr_idx => l_hdr_idx
1437: ,p_balance_type_code => 'A');
1438:
1439: END LOOP;
1440:

Line 1490: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.base_ledger_id

1486: ,p_module => l_log_module);
1487: END IF;
1488: --
1489: g_rec_header_new.array_je_category_name(g_header_idx) := xla_accounting_cache_pkg.get_je_category(
1490: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.base_ledger_id
1491: ,p_event_class_code => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_class);
1492: --
1493:
1494: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 1491: ,p_event_class_code => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_class);

1487: END IF;
1488: --
1489: g_rec_header_new.array_je_category_name(g_header_idx) := xla_accounting_cache_pkg.get_je_category(
1490: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.base_ledger_id
1491: ,p_event_class_code => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_class);
1492: --
1493:
1494: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1495:

Line 1509: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1505: END IF;
1506: --
1507: EXCEPTION
1508: WHEN xla_exceptions_pkg.application_exception THEN
1509: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1510: RAISE;
1511: WHEN OTHERS THEN
1512: xla_exceptions_pkg.raise_message
1513: (p_location => 'XLA_AE_HEADER_PKG.InitHeader');

Line 1707: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1703: END IF;
1704: RETURN l_analytical_criteria;
1705: EXCEPTION
1706: WHEN xla_exceptions_pkg.application_exception THEN
1707: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1708: RETURN NULL;
1709: WHEN OTHERS THEN
1710: xla_exceptions_pkg.raise_message
1711: (p_location => 'XLA_AE_HEADER_PKG.SetAnalyticalCriteria');

Line 1754: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

1750: END IF;
1751: EXCEPTION
1752: --
1753: WHEN xla_exceptions_pkg.application_exception THEN
1754: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
1755: RAISE;
1756: WHEN OTHERS THEN
1757: xla_exceptions_pkg.raise_message
1758: (p_location => 'XLA_AE_HEADER_PKG.SetHdrDescription');

Line 1772: l_array_header_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;

1768: RETURN BOOLEAN
1769: IS
1770: --
1771: l_period_name VARCHAR2(25);
1772: l_array_header_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
1773: l_array_balance_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L;
1774: l_result BOOLEAN;
1775: l_Idx BINARY_INTEGER := 0;
1776: l_log_module VARCHAR2(240);

Line 1773: l_array_balance_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L;

1769: IS
1770: --
1771: l_period_name VARCHAR2(25);
1772: l_array_header_id XLA_AE_JOURNAL_ENTRY_PKG.t_array_Num;
1773: l_array_balance_type XLA_AE_JOURNAL_ENTRY_PKG.t_array_V1L;
1774: l_result BOOLEAN;
1775: l_Idx BINARY_INTEGER := 0;
1776: l_log_module VARCHAR2(240);
1777: -- added 7526530

Line 1813: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

1809: l_array_header_id(l_Idx) := g_rec_header_new.array_actual_header_id(g_header_idx);
1810: l_array_balance_type(l_Idx) := C_ACTUAL;
1811: --
1812: l_period_name := get_period_name(
1813: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1814: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1815: , p_ae_header_id => g_rec_header_new.array_actual_header_id(g_header_idx)
1816: );
1817: END IF;

Line 1814: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date

1810: l_array_balance_type(l_Idx) := C_ACTUAL;
1811: --
1812: l_period_name := get_period_name(
1813: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1814: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1815: , p_ae_header_id => g_rec_header_new.array_actual_header_id(g_header_idx)
1816: );
1817: END IF;
1818: --

Line 1826: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

1822: l_array_header_id(l_Idx) := g_rec_header_new.array_budget_header_id(g_header_idx);
1823: l_array_balance_type(l_Idx) := C_BUDGET;
1824: --
1825: l_period_name := get_period_name(
1826: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1827: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1828: , p_ae_header_id => g_rec_header_new.array_budget_header_id(g_header_idx)
1829: );
1830: END IF;

Line 1827: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date

1823: l_array_balance_type(l_Idx) := C_BUDGET;
1824: --
1825: l_period_name := get_period_name(
1826: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1827: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1828: , p_ae_header_id => g_rec_header_new.array_budget_header_id(g_header_idx)
1829: );
1830: END IF;
1831: --

Line 1839: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

1835: l_array_header_id(l_Idx) := g_rec_header_new.array_encumb_header_id(g_header_idx);
1836: l_array_balance_type(l_Idx) := C_ENCUMBRANCE;
1837: --
1838: l_period_name := get_period_name(
1839: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1840: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1841: , p_ae_header_id => g_rec_header_new.array_encumb_header_id(g_header_idx)
1842: );
1843: END IF;

Line 1840: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date

1836: l_array_balance_type(l_Idx) := C_ENCUMBRANCE;
1837: --
1838: l_period_name := get_period_name(
1839: p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
1840: , p_accounting_date => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_date
1841: , p_ae_header_id => g_rec_header_new.array_encumb_header_id(g_header_idx)
1842: );
1843: END IF;
1844: */

Line 2011: XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED

2007: g_rec_header_new.array_encumbrance_status(Idx)
2008: when C_ACTUAL THEN
2009: g_rec_header_new.array_actual_status(Idx)
2010: ELSE
2011: XLA_AE_JOURNAL_ENTRY_PKG.C_NOT_CREATED
2012: END CASE
2013: , C_STANDARD
2014: , g_rec_header_new.array_target_ledger_id(Idx)
2015: , g_rec_header_new.array_entity_id(Idx)

Line 2019: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_type_code

2015: , g_rec_header_new.array_entity_id(Idx)
2016: , g_rec_header_new.array_event_id(Idx)
2017: , g_rec_header_new.array_event_type_code(Idx)
2018: , g_rec_header_new.array_gl_date(Idx)
2019: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_type_code
2020: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_code
2021: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_version
2022: , g_rec_header_new.array_je_category_name(Idx)
2023: --, 'XYZ' --l_period_name

Line 2020: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_code

2016: , g_rec_header_new.array_event_id(Idx)
2017: , g_rec_header_new.array_event_type_code(Idx)
2018: , g_rec_header_new.array_gl_date(Idx)
2019: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_type_code
2020: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_code
2021: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_version
2022: , g_rec_header_new.array_je_category_name(Idx)
2023: --, 'XYZ' --l_period_name
2024: , g_rec_header_new.array_doc_sequence_id(Idx)

Line 2021: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_version

2017: , g_rec_header_new.array_event_type_code(Idx)
2018: , g_rec_header_new.array_gl_date(Idx)
2019: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_type_code
2020: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_code
2021: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.product_rule_version
2022: , g_rec_header_new.array_je_category_name(Idx)
2023: --, 'XYZ' --l_period_name
2024: , g_rec_header_new.array_doc_sequence_id(Idx)
2025: , g_rec_header_new.array_doc_sequence_value(Idx)

Line 2034: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.amb_context_code

2030: ,NULL)
2031: --, DECODE(ael.balance_type_code, C_ENCUMBRANCE, g_rec_header_new.array_encumbrance_type_id(Idx)
2032: -- , NULL) -- 4458381 Public Sector Enh
2033: , ael.balance_type_code
2034: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_pad.amb_context_code
2035: , g_rec_header_new.array_doc_category_code(Idx)
2036: , DECODE(g_rec_header_new.array_gl_transfer_flag(Idx), 'N', 'NT', 'Y', 'N', 'N')
2037: , g_rec_header_new.array_event_status(Idx)
2038: , g_rec_header_new.array_anc_id_1(Idx)

Line 2165: (XLA_AE_JOURNAL_ENTRY_PKG.g_global_status = XLA_AE_JOURNAL_ENTRY_PKG.C_VALID)) ;

2161: ,p_module => l_log_module);
2162: END IF;
2163: --
2164: l_result:= ( (SQL%ROWCOUNT > 0) OR
2165: (XLA_AE_JOURNAL_ENTRY_PKG.g_global_status = XLA_AE_JOURNAL_ENTRY_PKG.C_VALID)) ;
2166:
2167: --
2168: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2169:

Line 2418: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

2414: WHEN C_BUDGET THEN g_rec_header_new.array_budget_header_id(g_header_idx)
2415: WHEN C_ENCUMBRANCE THEN g_rec_header_new.array_encumb_header_id(g_header_idx)
2416: END
2417: , XLA_AE_LINES_PKG.SetLineNum(xah.balance_type_code)
2418: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2419: --
2420: , xal.ae_header_id
2421: , xal.ae_line_num
2422: , xdl.temp_line_num

Line 2441: , DECODE(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option,

2437: , NULL
2438: , xal.description
2439: , xal.gl_transfer_mode_code
2440: , xdl.merge_duplicate_code
2441: , DECODE(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option,
2442: 'SIDE', C_SWITCH,
2443: C_NO_SWITCH
2444: )
2445: /* , xdl.entered_amount

Line 2725: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

2721: AND xe.event_id = xah.event_id
2722: AND xal.ae_header_id = xdl.ae_header_id
2723: AND xal.ae_header_id = xah.ae_header_id
2724: AND xal.ae_line_num = xdl.ae_line_num
2725: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2726: AND anc.ae_header_id = xdl.ae_header_id
2727: AND anc.ae_line_num = xdl.ae_line_num
2728: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2729: AND (g_rec_header_new.array_previous_party_id(g_header_idx) IS NULL

Line 2728: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

2724: AND xal.ae_line_num = xdl.ae_line_num
2725: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2726: AND anc.ae_header_id = xdl.ae_header_id
2727: AND anc.ae_line_num = xdl.ae_line_num
2728: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2729: AND (g_rec_header_new.array_previous_party_id(g_header_idx) IS NULL
2730: OR
2731: xal.party_id = g_rec_header_new.array_previous_party_id(g_header_idx))
2732: AND (g_rec_header_new.array_previous_party_site_id(g_header_idx) IS NULL

Line 2843: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

2839: WHEN C_BUDGET THEN g_rec_header_new.array_budget_header_id(g_header_idx)
2840: WHEN C_ENCUMBRANCE THEN g_rec_header_new.array_encumb_header_id(g_header_idx)
2841: END
2842: , XLA_AE_LINES_PKG.SetLineNum(xah.balance_type_code)
2843: , XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
2844: --
2845: , xal.ae_header_id
2846: , xal.ae_line_num
2847: , xdl.temp_line_num

Line 2866: , DECODE(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option,

2862: , NULL
2863: , xal.description
2864: , xal.gl_transfer_mode_code
2865: , xdl.merge_duplicate_code
2866: , DECODE(XLA_AE_JOURNAL_ENTRY_PKG.g_cache_ledgers_info.ledger_reversal_option,
2867: 'SIDE', C_SWITCH,
2868: C_NO_SWITCH
2869: )
2870: -- , xdl.entered_amount

Line 2924: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

2920: AND xe.event_id = xah.event_id
2921: AND xal.ae_header_id = xdl.ae_header_id
2922: AND xal.ae_header_id = xah.ae_header_id
2923: AND xal.ae_line_num = xdl.ae_line_num
2924: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2925: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2926: AND ( g_rec_header_new.array_previous_party_id(g_header_idx) IS NULL
2927: OR
2928: xal.party_id = g_rec_header_new.array_previous_party_id(g_header_idx))

Line 2925: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id

2921: AND xal.ae_header_id = xdl.ae_header_id
2922: AND xal.ae_header_id = xah.ae_header_id
2923: AND xal.ae_line_num = xdl.ae_line_num
2924: AND xe.entity_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
2925: AND xah.ledger_id = XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id
2926: AND ( g_rec_header_new.array_previous_party_id(g_header_idx) IS NULL
2927: OR
2928: xal.party_id = g_rec_header_new.array_previous_party_id(g_header_idx))
2929: AND ( g_rec_header_new.array_previous_party_site_id(g_header_idx) IS NULL

Line 2995: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := NULL;

2991: END IF;
2992: --
2993: g_rec_header_new := l_null_rec_header_new ;
2994: g_cache_period_name := l_null_rec_period_name;
2995: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := NULL;
2996: --
2997: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2998:
2999: trace

Line 3075: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

3071: g_rec_header_new.array_party_change_option(g_header_idx) := p_rec_acct_attrs.array_num_value(i);
3072: END IF;
3073:
3074: IF NVL(g_rec_header_new.array_party_change_option(g_header_idx),'N') NOT IN ('Y','N') THEN
3075: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
3076: xla_accounting_err_pkg.build_message
3077: (p_appli_s_name => 'XLA'
3078: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
3079: ,p_token_1 => 'PRODUCT_NAME'

Line 3080: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

3076: xla_accounting_err_pkg.build_message
3077: (p_appli_s_name => 'XLA'
3078: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
3079: ,p_token_1 => 'PRODUCT_NAME'
3080: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3081: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3082: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3083: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3084: END IF;

Line 3081: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

3077: (p_appli_s_name => 'XLA'
3078: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
3079: ,p_token_1 => 'PRODUCT_NAME'
3080: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3081: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3082: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3083: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3084: END IF;
3085:

Line 3082: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

3078: ,p_msg_name => 'XLA_AP_THIRD_PARTY_OPTION'
3079: ,p_token_1 => 'PRODUCT_NAME'
3080: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3081: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3082: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3083: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3084: END IF;
3085:
3086: WHEN 'GL_TRANSFER_FLAG' THEN

Line 3083: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

3079: ,p_token_1 => 'PRODUCT_NAME'
3080: ,p_value_1 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3081: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3082: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3083: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3084: END IF;
3085:
3086: WHEN 'GL_TRANSFER_FLAG' THEN
3087: -- 5161760

Line 3099: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

3095: g_rec_header_new.array_gl_transfer_flag(g_header_idx) := nvl(p_rec_acct_attrs.array_num_value(i), 'Y');
3096: END IF;
3097:
3098: IF NVL(g_rec_header_new.array_gl_transfer_flag(g_header_idx),'Y') NOT IN ('Y', 'N') THEN
3099: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
3100: xla_accounting_err_pkg.build_message
3101: (p_appli_s_name => 'XLA'
3102: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3103: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 3106: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

3102: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3103: ,p_token_1 => 'ACCT_ATTR_NAME'
3104: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
3105: ,p_token_2 => 'PRODUCT_NAME'
3106: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3107: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3108: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3109: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3110: END IF;

Line 3107: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

3103: ,p_token_1 => 'ACCT_ATTR_NAME'
3104: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
3105: ,p_token_2 => 'PRODUCT_NAME'
3106: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3107: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3108: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3109: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3110: END IF;
3111:

Line 3108: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

3104: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_TRANSFER_FLAG')
3105: ,p_token_2 => 'PRODUCT_NAME'
3106: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3107: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3108: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3109: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3110: END IF;
3111:
3112: WHEN 'TRX_ACCT_REVERSAL_OPTION' THEN

Line 3109: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

3105: ,p_token_2 => 'PRODUCT_NAME'
3106: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3107: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3108: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3109: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3110: END IF;
3111:
3112: WHEN 'TRX_ACCT_REVERSAL_OPTION' THEN
3113: -- 5161760

Line 3125: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

3121: g_rec_header_new.array_trx_acct_reversal_option(g_header_idx) := nvl(p_rec_acct_attrs.array_num_value(i), 'N');
3122: END IF;
3123:
3124: IF NVL(g_rec_header_new.array_trx_acct_reversal_option(g_header_idx),'N') NOT IN ('Y', 'N') THEN
3125: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
3126: xla_accounting_err_pkg.build_message
3127: (p_appli_s_name => 'XLA'
3128: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3129: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 3132: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

3128: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3129: ,p_token_1 => 'ACCT_ATTR_NAME'
3130: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3131: ,p_token_2 => 'PRODUCT_NAME'
3132: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3133: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3134: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3135: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3136: END IF;

Line 3133: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

3129: ,p_token_1 => 'ACCT_ATTR_NAME'
3130: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3131: ,p_token_2 => 'PRODUCT_NAME'
3132: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3133: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3134: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3135: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3136: END IF;
3137:

Line 3134: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

3130: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('TRX_ACCT_REVERSAL_OPTION')
3131: ,p_token_2 => 'PRODUCT_NAME'
3132: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3133: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3134: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3135: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3136: END IF;
3137:
3138: WHEN 'PARTY_CHANGE_TYPE' THEN

Line 3135: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

3131: ,p_token_2 => 'PRODUCT_NAME'
3132: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3133: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3134: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3135: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3136: END IF;
3137:
3138: WHEN 'PARTY_CHANGE_TYPE' THEN
3139: IF p_rec_acct_attrs.array_char_value.EXISTS(i) THEN

Line 3174: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;

3170:
3171: WHEN 'GL_DATE' THEN
3172: g_rec_header_new.array_gl_date(g_header_idx) := trunc(p_rec_acct_attrs.array_date_value(i));
3173: IF p_rec_acct_attrs.array_date_value(i) is NULL THEN
3174: XLA_AE_JOURNAL_ENTRY_PKG.g_global_status := XLA_AE_JOURNAL_ENTRY_PKG.C_INVALID;
3175: xla_accounting_err_pkg.build_message
3176: (p_appli_s_name => 'XLA'
3177: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3178: ,p_token_1 => 'ACCT_ATTR_NAME'

Line 3181: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name

3177: ,p_msg_name => 'XLA_AP_INVALID_HDR_ATTR'
3178: ,p_token_1 => 'ACCT_ATTR_NAME'
3179: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
3180: ,p_token_2 => 'PRODUCT_NAME'
3181: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3182: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3183: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3184: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3185: END IF;

Line 3182: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id

3178: ,p_token_1 => 'ACCT_ATTR_NAME'
3179: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
3180: ,p_token_2 => 'PRODUCT_NAME'
3181: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3182: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3183: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3184: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3185: END IF;
3186: ELSE null;

Line 3183: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id

3179: ,p_value_1 => XLA_AE_SOURCES_PKG.GetAccountingSourceName('GL_DATE')
3180: ,p_token_2 => 'PRODUCT_NAME'
3181: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3182: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3183: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3184: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3185: END IF;
3186: ELSE null;
3187: END CASE;

Line 3184: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);

3180: ,p_token_2 => 'PRODUCT_NAME'
3181: ,p_value_2 => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.application_name
3182: ,p_entity_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.entity_id
3183: ,p_event_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.event_id
3184: ,p_ledger_id => XLA_AE_JOURNAL_ENTRY_PKG.g_cache_event.target_ledger_id);
3185: END IF;
3186: ELSE null;
3187: END CASE;
3188: end loop;