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_BALANCES_CALC_PKG dependencies on FND_FILE

Line 362: fnd_file.put_line (fnd_file.LOG ,'inside not header,entity,accounting_batch');

358: , p_request_id ) ;
359:
360: else
361: -- end bug 13614923
362: fnd_file.put_line (fnd_file.LOG ,'inside not header,entity,accounting_batch');
363: select
364: p_ledger_id
365: ,p_application_id
366: ,p_accounting_batch_id

Line 2733: fnd_file.put_line

2729: --Proceed with balance calculation only if the balnaces are carried forward to the latest open peirod
2730: --
2731: IF l_eff_period_num > 0
2732: THEN
2733: fnd_file.put_line
2734: (fnd_file.LOG
2735: , 'Balances are not initialized for the latest open period.
2736: Before proceeding with balance calculation, run Open Period Balances Program for Ledger ID: '||p_ledger_id||' for the latest open period in General Ledger.'
2737: );

Line 2734: (fnd_file.LOG

2730: --
2731: IF l_eff_period_num > 0
2732: THEN
2733: fnd_file.put_line
2734: (fnd_file.LOG
2735: , 'Balances are not initialized for the latest open period.
2736: Before proceeding with balance calculation, run Open Period Balances Program for Ledger ID: '||p_ledger_id||' for the latest open period in General Ledger.'
2737: );
2738: xla_exceptions_pkg.raise_message

Line 2954: fnd_file.put_line

2950: END IF;
2951:
2952: IF l_from_effective_period_num IS NULL
2953: THEN
2954: fnd_file.put_line
2955: (fnd_file.LOG
2956: , 'There is no record in xla_ledger_options for ledger '||p_ledger_id
2957: );
2958: RETURN FALSE;

Line 2955: (fnd_file.LOG

2951:
2952: IF l_from_effective_period_num IS NULL
2953: THEN
2954: fnd_file.put_line
2955: (fnd_file.LOG
2956: , 'There is no record in xla_ledger_options for ledger '||p_ledger_id
2957: );
2958: RETURN FALSE;
2959: ELSIF l_from_effective_period_num >= p_effective_period_num

Line 2962: fnd_file.put_line

2958: RETURN FALSE;
2959: ELSIF l_from_effective_period_num >= p_effective_period_num
2960: THEN -- Proceed only if target period is greater than current open period
2961:
2962: fnd_file.put_line
2963: (fnd_file.LOG
2964: , 'Balances exists for the target period ' ||p_period_name||' and ledger '||p_ledger_id
2965: );
2966: RETURN TRUE; -- Bug 13702056

Line 2963: (fnd_file.LOG

2959: ELSIF l_from_effective_period_num >= p_effective_period_num
2960: THEN -- Proceed only if target period is greater than current open period
2961:
2962: fnd_file.put_line
2963: (fnd_file.LOG
2964: , 'Balances exists for the target period ' ||p_period_name||' and ledger '||p_ledger_id
2965: );
2966: RETURN TRUE; -- Bug 13702056
2967:

Line 2970: fnd_file.put_line

2966: RETURN TRUE; -- Bug 13702056
2967:
2968: ELSIF l_count = 0
2969: THEN -- if target period is Future enterable or Never open period EXIT
2970: fnd_file.put_line
2971: (fnd_file.LOG
2972: , 'Target period '||p_period_name||' is not Open/Close/Pending close Period '
2973: );
2974: return FALSE;

Line 2971: (fnd_file.LOG

2967:
2968: ELSIF l_count = 0
2969: THEN -- if target period is Future enterable or Never open period EXIT
2970: fnd_file.put_line
2971: (fnd_file.LOG
2972: , 'Target period '||p_period_name||' is not Open/Close/Pending close Period '
2973: );
2974: return FALSE;
2975:

Line 3446: fnd_file.put_line(fnd_file.LOG ,'Period:'||p_period_name||' is Adjustment Period so Balances data need not be maintained for this period');

3442: SAVEPOINT SAVEPOINT_BAL; -- Bug 13614923
3443:
3444:
3445: if l_adjustment_period_flag = 'Y' then -- Bug12613841
3446: fnd_file.put_line(fnd_file.LOG ,'Period:'||p_period_name||' is Adjustment Period so Balances data need not be maintained for this period');
3447: p_retcode := 0;
3448: else
3449:
3450:

Line 3537: fnd_file.put_line(fnd_file.LOG

3533: -- End Bug 13928188
3534:
3535:
3536: ELSE
3537: fnd_file.put_line(fnd_file.LOG
3538: ,'Balances upgrade script xlabalupg.sql has not been run.
3539: Run xlabalupg.sql to use Update Subledger Accounting Balances program'
3540: );
3541: p_retcode := 0;

Line 3640: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);

3636: IF l_ledger_category_code <> 'ALC'
3637: THEN -- ALC ledger's balances are created along with primary.
3638: -- So exit if the program is called for ALC ledger.
3639:
3640: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);
3641: fnd_file.put_line (fnd_file.LOG, 'p_effective_period_num: ' || l_effective_period_num);
3642: p_retcode := 0;
3643:
3644: IF NOT lock_bal_concurrency_control ( p_application_id => NULL

Line 3641: fnd_file.put_line (fnd_file.LOG, 'p_effective_period_num: ' || l_effective_period_num);

3637: THEN -- ALC ledger's balances are created along with primary.
3638: -- So exit if the program is called for ALC ledger.
3639:
3640: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);
3641: fnd_file.put_line (fnd_file.LOG, 'p_effective_period_num: ' || l_effective_period_num);
3642: p_retcode := 0;
3643:
3644: IF NOT lock_bal_concurrency_control ( p_application_id => NULL
3645: , p_ledger_id => p_ledger_id

Line 3669: fnd_file.put_line (fnd_file.LOG, 'Opening SLA Period Balances');

3665:
3666: OPEN lock_bal_control (p_ledger_id => p_ledger_id );
3667: CLOSE lock_bal_control;
3668:
3669: fnd_file.put_line (fnd_file.LOG, 'Opening SLA Period Balances');
3670:
3671: IF move_balances_forward (p_ledger_id => p_ledger_id
3672: , p_effective_period_num => l_effective_period_num
3673: , p_period_name => p_period_name

Line 3676: fnd_file.put_line (fnd_file.LOG, 'Open Period Balances Successfully completed');

3672: , p_effective_period_num => l_effective_period_num
3673: , p_period_name => p_period_name
3674: )
3675: THEN
3676: fnd_file.put_line (fnd_file.LOG, 'Open Period Balances Successfully completed');
3677:
3678: delete xla_bal_concurrency_control where request_id = g_req_id; --Bug 13614923
3679:
3680:

Line 3685: fnd_file.put_line (fnd_file.LOG, 'Unsuccessful');

3681: ELSE
3682: delete xla_bal_concurrency_control where request_id = g_req_id; --Bug 13614923
3683:
3684: p_retcode := p_retcode + 1;
3685: fnd_file.put_line (fnd_file.LOG, 'Unsuccessful');
3686: ROLLBACK TO SAVEPOINT_BAL;
3687: END IF;
3688: END IF;
3689:

Line 3719: fnd_file.put_line

3715: );
3716: END IF;
3717:
3718: p_retcode := 1;
3719: fnd_file.put_line
3720: (fnd_file.LOG
3721: ,'There is another request running for the ledger_id : '
3722: || p_ledger_id
3723: || '. Pls. submit Open Period Balances Concurrent Program once the running request is completed'

Line 3720: (fnd_file.LOG

3716: END IF;
3717:
3718: p_retcode := 1;
3719: fnd_file.put_line
3720: (fnd_file.LOG
3721: ,'There is another request running for the ledger_id : '
3722: || p_ledger_id
3723: || '. Pls. submit Open Period Balances Concurrent Program once the running request is completed'
3724: );

Line 3846: fnd_file.put_line (fnd_file.LOG

3842: , p_level => c_level_procedure
3843: );
3844: END IF;
3845:
3846: fnd_file.put_line (fnd_file.LOG
3847: , 'p_application_id: ' || p_application_id
3848: );
3849: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);
3850: fnd_file.put_line (fnd_file.LOG

Line 3849: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);

3845:
3846: fnd_file.put_line (fnd_file.LOG
3847: , 'p_application_id: ' || p_application_id
3848: );
3849: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);
3850: fnd_file.put_line (fnd_file.LOG
3851: , 'p_accounting_batch_id: ' || p_accounting_batch_id
3852: );
3853: fnd_file.put_line (fnd_file.LOG, 'p_request_id: ' || g_req_id);

Line 3850: fnd_file.put_line (fnd_file.LOG

3846: fnd_file.put_line (fnd_file.LOG
3847: , 'p_application_id: ' || p_application_id
3848: );
3849: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);
3850: fnd_file.put_line (fnd_file.LOG
3851: , 'p_accounting_batch_id: ' || p_accounting_batch_id
3852: );
3853: fnd_file.put_line (fnd_file.LOG, 'p_request_id: ' || g_req_id);
3854:

Line 3853: fnd_file.put_line (fnd_file.LOG, 'p_request_id: ' || g_req_id);

3849: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);
3850: fnd_file.put_line (fnd_file.LOG
3851: , 'p_accounting_batch_id: ' || p_accounting_batch_id
3852: );
3853: fnd_file.put_line (fnd_file.LOG, 'p_request_id: ' || g_req_id);
3854:
3855: --Bug 12575468
3856: --ESTABLISH SAVEPOINT
3857: SAVEPOINT SAVEPOINT_BAL;

Line 3867: fnd_file.put_line(fnd_file.LOG

3863: WHERE effective_period_num IS NOT NULL;
3864:
3865: IF l_ledger_count = 0
3866: THEN
3867: fnd_file.put_line(fnd_file.LOG
3868: ,'Balances upgrade script xlabalupg.sql has not been run. Run xlabalupg.sql to use Update Subledger Accounting Balances program'
3869: );
3870: p_retcode := 1; --bug13614923
3871: ELSE

Line 3953: fnd_file.put_line (fnd_file.LOG , 'Successfully Locked');

3949: OPEN lock_bal_control (p_application_id => p_application_id);
3950:
3951: CLOSE lock_bal_control;
3952:
3953: fnd_file.put_line (fnd_file.LOG , 'Successfully Locked');
3954:
3955: IF calculate_balances ( p_application_id => p_application_id
3956: , p_ledger_id => p_ledger_id
3957: , p_entity_id => NULL

Line 4004: fnd_file.put_line

4000: FROM xla_bal_concurrency_control
4001: WHERE application_id = p_application_id
4002: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array)))
4003: loop
4004: fnd_file.put_line
4005: (fnd_file.LOG
4006: , 'There is another request(s) running for the ledger_id : '
4007: || i.ledger_id
4008: || ' application_id : '

Line 4005: (fnd_file.LOG

4001: WHERE application_id = p_application_id
4002: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array)))
4003: loop
4004: fnd_file.put_line
4005: (fnd_file.LOG
4006: , 'There is another request(s) running for the ledger_id : '
4007: || i.ledger_id
4008: || ' application_id : '
4009: || i.application_id);

Line 4012: fnd_file.put_line

4008: || ' application_id : '
4009: || i.application_id);
4010: end loop;
4011:
4012: fnd_file.put_line
4013: (fnd_file.LOG ,
4014: 'Pls. submit Subledger Accounting Balances Update Concurrent Program once the running request is completed');
4015:
4016: --Bug 12575468

Line 4013: (fnd_file.LOG ,

4009: || i.application_id);
4010: end loop;
4011:
4012: fnd_file.put_line
4013: (fnd_file.LOG ,
4014: 'Pls. submit Subledger Accounting Balances Update Concurrent Program once the running request is completed');
4015:
4016: --Bug 12575468
4017: --Added below rollback statement

Line 4173: fnd_file.put_line (fnd_file.LOG

4169: );
4170: END IF;
4171:
4172:
4173: fnd_file.put_line (fnd_file.LOG
4174: , 'p_application_id: ' || p_application_id
4175: );
4176: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);
4177: fnd_file.put_line (fnd_file.LOG

Line 4176: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);

4172:
4173: fnd_file.put_line (fnd_file.LOG
4174: , 'p_application_id: ' || p_application_id
4175: );
4176: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);
4177: fnd_file.put_line (fnd_file.LOG
4178: , 'p_accounting_batch_id: ' || p_accounting_batch_id
4179: );
4180: fnd_file.put_line (fnd_file.LOG, 'p_request_id: ' || g_req_id);

Line 4177: fnd_file.put_line (fnd_file.LOG

4173: fnd_file.put_line (fnd_file.LOG
4174: , 'p_application_id: ' || p_application_id
4175: );
4176: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);
4177: fnd_file.put_line (fnd_file.LOG
4178: , 'p_accounting_batch_id: ' || p_accounting_batch_id
4179: );
4180: fnd_file.put_line (fnd_file.LOG, 'p_request_id: ' || g_req_id);
4181:

Line 4180: fnd_file.put_line (fnd_file.LOG, 'p_request_id: ' || g_req_id);

4176: fnd_file.put_line (fnd_file.LOG, 'p_ledger_id: ' || p_ledger_id);
4177: fnd_file.put_line (fnd_file.LOG
4178: , 'p_accounting_batch_id: ' || p_accounting_batch_id
4179: );
4180: fnd_file.put_line (fnd_file.LOG, 'p_request_id: ' || g_req_id);
4181:
4182: --ESTABLISH SAVEPOINT
4183: SAVEPOINT SAVEPOINT_BAL;
4184:

Line 4193: fnd_file.put_line(fnd_file.LOG

4189: WHERE effective_period_num IS NOT NULL;
4190:
4191: IF l_ledger_count = 0
4192: THEN
4193: fnd_file.put_line(fnd_file.LOG
4194: ,'Balances upgrade script xlabalupg.sql has not been run. Run xlabalupg.sql to use Update Subledger Accounting Balances program'
4195: );
4196: RETURN TRUE;
4197: ELSE

Line 4289: fnd_file.put_line (fnd_file.LOG , 'Successfully Locked');

4285: OPEN lock_bal_control (p_application_id => p_application_id );
4286:
4287: CLOSE lock_bal_control;
4288:
4289: fnd_file.put_line (fnd_file.LOG , 'Successfully Locked');
4290:
4291: IF calculate_balances ( p_application_id => p_application_id
4292: , p_ledger_id => p_ledger_id
4293: , p_entity_id => p_entity_id

Line 4344: fnd_file.put_line

4340: FROM xla_bal_concurrency_control
4341: WHERE application_id = p_application_id
4342: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array)))
4343: loop
4344: fnd_file.put_line
4345: (fnd_file.LOG
4346: , 'There is another request(s) running for the ledger_id : '
4347: || i.ledger_id
4348: || ' application_id : '

Line 4345: (fnd_file.LOG

4341: WHERE application_id = p_application_id
4342: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array)))
4343: loop
4344: fnd_file.put_line
4345: (fnd_file.LOG
4346: , 'There is another request(s) running for the ledger_id : '
4347: || i.ledger_id
4348: || ' application_id : '
4349: || i.application_id);

Line 4352: fnd_file.put_line

4348: || ' application_id : '
4349: || i.application_id);
4350: end loop;
4351:
4352: fnd_file.put_line
4353: (fnd_file.LOG ,
4354: 'Pls. submit Subledger Accounting Balances Update Concurrent Program once the running request is completed');
4355:
4356: IF (c_level_procedure >= g_log_level)

Line 4353: (fnd_file.LOG ,

4349: || i.application_id);
4350: end loop;
4351:
4352: fnd_file.put_line
4353: (fnd_file.LOG ,
4354: 'Pls. submit Subledger Accounting Balances Update Concurrent Program once the running request is completed');
4355:
4356: IF (c_level_procedure >= g_log_level)
4357: THEN

Line 4475: fnd_file.put_line(fnd_file.LOG

4471:
4472:
4473: IF l_ledger_count = 0
4474: THEN
4475: fnd_file.put_line(fnd_file.LOG
4476: ,'Balances upgrade script xlabalupg.sql has not been run. Run xlabalupg.sql to use Update Subledger Accounting Balances program'
4477: );
4478: RETURN TRUE;
4479: ELSE

Line 4578: fnd_file.put_line (fnd_file.LOG , 'Successfully Locked');

4574: OPEN lock_bal_control;
4575:
4576: CLOSE lock_bal_control;
4577:
4578: fnd_file.put_line (fnd_file.LOG , 'Successfully Locked');
4579:
4580: l_return_value := calculate_balances ( p_application_id => p_application_id
4581: , p_ledger_id => NULL
4582: , p_entity_id => NULL

Line 4636: fnd_file.put_line

4632: FROM xla_bal_concurrency_control
4633: WHERE application_id = p_application_id
4634: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array)))
4635: loop
4636: fnd_file.put_line
4637: (fnd_file.LOG
4638: , 'There is another request(s) running for the ledger_id : '
4639: || i.ledger_id
4640: || ' application_id : '

Line 4637: (fnd_file.LOG

4633: WHERE application_id = p_application_id
4634: AND ledger_id IN ( SELECT * FROM TABLE(g_ledger_array)))
4635: loop
4636: fnd_file.put_line
4637: (fnd_file.LOG
4638: , 'There is another request(s) running for the ledger_id : '
4639: || i.ledger_id
4640: || ' application_id : '
4641: || i.application_id);

Line 4644: fnd_file.put_line

4640: || ' application_id : '
4641: || i.application_id);
4642: end loop;
4643:
4644: fnd_file.put_line
4645: (fnd_file.LOG ,
4646: 'Pls. submit Subledger Accounting Balances Update Concurrent Program once the running request is completed');
4647:
4648: ROLLBACK TO SAVEPOINT_BAL;

Line 4645: (fnd_file.LOG ,

4641: || i.application_id);
4642: end loop;
4643:
4644: fnd_file.put_line
4645: (fnd_file.LOG ,
4646: 'Pls. submit Subledger Accounting Balances Update Concurrent Program once the running request is completed');
4647:
4648: ROLLBACK TO SAVEPOINT_BAL;
4649: DELETE FROM xla_bal_concurrency_control where request_id=-1*p_ae_header_id;