DBA Data[Home] [Help]

APPS.XLA_BALANCES_PKG dependencies on FND_FILE

Line 7378: fnd_file.put_line(fnd_file.log,'p_application_id: ' || p_application_id);

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:

Line 7379: fnd_file.put_line(fnd_file.log,'p_ledger_id: ' || p_ledger_id);

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'

Line 7380: fnd_file.put_line(fnd_file.log,'p_accounting_batch_id: ' || p_accounting_batch_id);

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

Line 7381: fnd_file.put_line(fnd_file.log,'p_update_mode: ' || p_update_mode);

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';

Line 9234: fnd_file.put_line(fnd_file.log,'p_application_id : ' || p_application_id);

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);

Line 9235: fnd_file.put_line(fnd_file.log,'p_ledger_id : ' || p_ledger_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);

Line 9236: fnd_file.put_line(fnd_file.log,'p_party_type_code : ' || p_party_type_code);

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);

Line 9237: fnd_file.put_line(fnd_file.log,'p_party_id : ' || p_party_id);

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);

Line 9238: fnd_file.put_line(fnd_file.log,'p_party_site_id : ' || p_party_site_id);

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:

Line 9239: fnd_file.put_line(fnd_file.log,'p_starting_period_name : ' || p_starting_period_name);

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

Line 9240: fnd_file.put_line(fnd_file.log,'p_account_segment_value_low : ' || p_account_segment_value_low);

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:

Line 9241: fnd_file.put_line(fnd_file.log,'p_account_segment_value_high: ' || p_account_segment_value_high);

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

Line 10009: fnd_file.put_line(fnd_file.log,'p_ledger_id: ' || p_ledger_id);

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

Line 10018: fnd_file.put_line(fnd_file.log,'Opening control account balances for application_id '||i.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'

Line 10025: fnd_file.put_line(fnd_file.log,'Successful' );

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;

Line 10028: fnd_file.put_line(fnd_file.log,'Unsuccessful' );

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

Line 10031: fnd_file.put_line(fnd_file.log,'Opening analytical criteria balances for application_id '||i.application_id );

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'

Line 10038: fnd_file.put_line(fnd_file.log,'Successful' );

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;

Line 10041: fnd_file.put_line(fnd_file.log,'Unsuccessful' );

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: