7374: ,p_msg => 'BEGIN ' || l_log_module
7375: ,p_level => C_LEVEL_PROCEDURE);
7376: END IF;
7377:
7378: fnd_file.put_line(fnd_file.log,'p_application_id: ' || p_application_id);
7379: fnd_file.put_line(fnd_file.log,'p_ledger_id: ' || p_ledger_id);
7380: fnd_file.put_line(fnd_file.log,'p_accounting_batch_id: ' || p_accounting_batch_id);
7381: fnd_file.put_line(fnd_file.log,'p_update_mode: ' || p_update_mode);
7382:
7375: ,p_level => C_LEVEL_PROCEDURE);
7376: END IF;
7377:
7378: fnd_file.put_line(fnd_file.log,'p_application_id: ' || p_application_id);
7379: fnd_file.put_line(fnd_file.log,'p_ledger_id: ' || p_ledger_id);
7380: fnd_file.put_line(fnd_file.log,'p_accounting_batch_id: ' || p_accounting_batch_id);
7381: fnd_file.put_line(fnd_file.log,'p_update_mode: ' || p_update_mode);
7382:
7383: IF p_update_mode = 'F'
7376: END IF;
7377:
7378: fnd_file.put_line(fnd_file.log,'p_application_id: ' || p_application_id);
7379: fnd_file.put_line(fnd_file.log,'p_ledger_id: ' || p_ledger_id);
7380: fnd_file.put_line(fnd_file.log,'p_accounting_batch_id: ' || p_accounting_batch_id);
7381: fnd_file.put_line(fnd_file.log,'p_update_mode: ' || p_update_mode);
7382:
7383: IF p_update_mode = 'F'
7384: THEN
7377:
7378: fnd_file.put_line(fnd_file.log,'p_application_id: ' || p_application_id);
7379: fnd_file.put_line(fnd_file.log,'p_ledger_id: ' || p_ledger_id);
7380: fnd_file.put_line(fnd_file.log,'p_accounting_batch_id: ' || p_accounting_batch_id);
7381: fnd_file.put_line(fnd_file.log,'p_update_mode: ' || p_update_mode);
7382:
7383: IF p_update_mode = 'F'
7384: THEN
7385: l_commit_flag := 'N';
9230: ,p_msg => 'BEGIN ' || l_log_module
9231: ,p_level => C_LEVEL_PROCEDURE);
9232: END IF;
9233:
9234: fnd_file.put_line(fnd_file.log,'p_application_id : ' || p_application_id);
9235: fnd_file.put_line(fnd_file.log,'p_ledger_id : ' || p_ledger_id);
9236: fnd_file.put_line(fnd_file.log,'p_party_type_code : ' || p_party_type_code);
9237: fnd_file.put_line(fnd_file.log,'p_party_id : ' || p_party_id);
9238: fnd_file.put_line(fnd_file.log,'p_party_site_id : ' || p_party_site_id);
9231: ,p_level => C_LEVEL_PROCEDURE);
9232: END IF;
9233:
9234: fnd_file.put_line(fnd_file.log,'p_application_id : ' || p_application_id);
9235: fnd_file.put_line(fnd_file.log,'p_ledger_id : ' || p_ledger_id);
9236: fnd_file.put_line(fnd_file.log,'p_party_type_code : ' || p_party_type_code);
9237: fnd_file.put_line(fnd_file.log,'p_party_id : ' || p_party_id);
9238: fnd_file.put_line(fnd_file.log,'p_party_site_id : ' || p_party_site_id);
9239: fnd_file.put_line(fnd_file.log,'p_starting_period_name : ' || p_starting_period_name);
9232: END IF;
9233:
9234: fnd_file.put_line(fnd_file.log,'p_application_id : ' || p_application_id);
9235: fnd_file.put_line(fnd_file.log,'p_ledger_id : ' || p_ledger_id);
9236: fnd_file.put_line(fnd_file.log,'p_party_type_code : ' || p_party_type_code);
9237: fnd_file.put_line(fnd_file.log,'p_party_id : ' || p_party_id);
9238: fnd_file.put_line(fnd_file.log,'p_party_site_id : ' || p_party_site_id);
9239: fnd_file.put_line(fnd_file.log,'p_starting_period_name : ' || p_starting_period_name);
9240: fnd_file.put_line(fnd_file.log,'p_account_segment_value_low : ' || p_account_segment_value_low);
9233:
9234: fnd_file.put_line(fnd_file.log,'p_application_id : ' || p_application_id);
9235: fnd_file.put_line(fnd_file.log,'p_ledger_id : ' || p_ledger_id);
9236: fnd_file.put_line(fnd_file.log,'p_party_type_code : ' || p_party_type_code);
9237: fnd_file.put_line(fnd_file.log,'p_party_id : ' || p_party_id);
9238: fnd_file.put_line(fnd_file.log,'p_party_site_id : ' || p_party_site_id);
9239: fnd_file.put_line(fnd_file.log,'p_starting_period_name : ' || p_starting_period_name);
9240: fnd_file.put_line(fnd_file.log,'p_account_segment_value_low : ' || p_account_segment_value_low);
9241: fnd_file.put_line(fnd_file.log,'p_account_segment_value_high: ' || p_account_segment_value_high);
9234: fnd_file.put_line(fnd_file.log,'p_application_id : ' || p_application_id);
9235: fnd_file.put_line(fnd_file.log,'p_ledger_id : ' || p_ledger_id);
9236: fnd_file.put_line(fnd_file.log,'p_party_type_code : ' || p_party_type_code);
9237: fnd_file.put_line(fnd_file.log,'p_party_id : ' || p_party_id);
9238: fnd_file.put_line(fnd_file.log,'p_party_site_id : ' || p_party_site_id);
9239: fnd_file.put_line(fnd_file.log,'p_starting_period_name : ' || p_starting_period_name);
9240: fnd_file.put_line(fnd_file.log,'p_account_segment_value_low : ' || p_account_segment_value_low);
9241: fnd_file.put_line(fnd_file.log,'p_account_segment_value_high: ' || p_account_segment_value_high);
9242:
9235: fnd_file.put_line(fnd_file.log,'p_ledger_id : ' || p_ledger_id);
9236: fnd_file.put_line(fnd_file.log,'p_party_type_code : ' || p_party_type_code);
9237: fnd_file.put_line(fnd_file.log,'p_party_id : ' || p_party_id);
9238: fnd_file.put_line(fnd_file.log,'p_party_site_id : ' || p_party_site_id);
9239: fnd_file.put_line(fnd_file.log,'p_starting_period_name : ' || p_starting_period_name);
9240: fnd_file.put_line(fnd_file.log,'p_account_segment_value_low : ' || p_account_segment_value_low);
9241: fnd_file.put_line(fnd_file.log,'p_account_segment_value_high: ' || p_account_segment_value_high);
9242:
9243: LOOP
9236: fnd_file.put_line(fnd_file.log,'p_party_type_code : ' || p_party_type_code);
9237: fnd_file.put_line(fnd_file.log,'p_party_id : ' || p_party_id);
9238: fnd_file.put_line(fnd_file.log,'p_party_site_id : ' || p_party_site_id);
9239: fnd_file.put_line(fnd_file.log,'p_starting_period_name : ' || p_starting_period_name);
9240: fnd_file.put_line(fnd_file.log,'p_account_segment_value_low : ' || p_account_segment_value_low);
9241: fnd_file.put_line(fnd_file.log,'p_account_segment_value_high: ' || p_account_segment_value_high);
9242:
9243: LOOP
9244:
9237: fnd_file.put_line(fnd_file.log,'p_party_id : ' || p_party_id);
9238: fnd_file.put_line(fnd_file.log,'p_party_site_id : ' || p_party_site_id);
9239: fnd_file.put_line(fnd_file.log,'p_starting_period_name : ' || p_starting_period_name);
9240: fnd_file.put_line(fnd_file.log,'p_account_segment_value_low : ' || p_account_segment_value_low);
9241: fnd_file.put_line(fnd_file.log,'p_account_segment_value_high: ' || p_account_segment_value_high);
9242:
9243: LOOP
9244:
9245: DELETE
10005: ,p_msg => 'BEGIN ' || l_log_module
10006: ,p_level => C_LEVEL_PROCEDURE);
10007: END IF;
10008:
10009: fnd_file.put_line(fnd_file.log,'p_ledger_id: ' || p_ledger_id);
10010:
10011: p_retcode := 0;
10012:
10013: FOR i in (SELECT DISTINCT application_id
10014: from xla_balance_statuses
10015: where ledger_id = p_ledger_id)
10016: LOOP
10017:
10018: fnd_file.put_line(fnd_file.log,'Opening control account balances for application_id '||i.application_id);
10019: IF check_create_period_balances
10020: ( p_application_id => i.application_id
10021: ,p_ledger_id => p_ledger_id
10022: ,p_balance_source_code => 'C'
10021: ,p_ledger_id => p_ledger_id
10022: ,p_balance_source_code => 'C'
10023: )
10024: THEN
10025: fnd_file.put_line(fnd_file.log,'Successful' );
10026: ELSE
10027: p_retcode := p_retcode + 1;
10028: fnd_file.put_line(fnd_file.log,'Unsuccessful' );
10029: END IF;
10024: THEN
10025: fnd_file.put_line(fnd_file.log,'Successful' );
10026: ELSE
10027: p_retcode := p_retcode + 1;
10028: fnd_file.put_line(fnd_file.log,'Unsuccessful' );
10029: END IF;
10030:
10031: fnd_file.put_line(fnd_file.log,'Opening analytical criteria balances for application_id '||i.application_id );
10032: IF check_create_period_balances
10027: p_retcode := p_retcode + 1;
10028: fnd_file.put_line(fnd_file.log,'Unsuccessful' );
10029: END IF;
10030:
10031: fnd_file.put_line(fnd_file.log,'Opening analytical criteria balances for application_id '||i.application_id );
10032: IF check_create_period_balances
10033: ( p_application_id => i.application_id
10034: ,p_ledger_id => p_ledger_id
10035: ,p_balance_source_code => 'A'
10034: ,p_ledger_id => p_ledger_id
10035: ,p_balance_source_code => 'A'
10036: )
10037: THEN
10038: fnd_file.put_line(fnd_file.log,'Successful' );
10039: ELSE
10040: p_retcode := p_retcode + 1;
10041: fnd_file.put_line(fnd_file.log,'Unsuccessful' );
10042: END IF;
10037: THEN
10038: fnd_file.put_line(fnd_file.log,'Successful' );
10039: ELSE
10040: p_retcode := p_retcode + 1;
10041: fnd_file.put_line(fnd_file.log,'Unsuccessful' );
10042: END IF;
10043:
10044: END LOOP;
10045: