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.JL_BR_CALCBAL_PKG dependencies on FND_LOG

Line 4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY JL_BR_CALCBAL_PKG AS
2: /* $Header: jlbrcblb.pls 120.0 2008/10/23 12:15:04 nivnaray noship $ */
3:
4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1: PACKAGE BODY JL_BR_CALCBAL_PKG AS
2: /* $Header: jlbrcblb.pls 120.0 2008/10/23 12:15:04 nivnaray noship $ */
3:
4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

2: /* $Header: jlbrcblb.pls 120.0 2008/10/23 12:15:04 nivnaray noship $ */
3:
4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

Line 7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

3:
4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: g_pkg_name CONSTANT VARCHAR2(30) := 'JL_CALCBAL_PKG.';

Line 8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

4: g_current_runtime_level CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: g_pkg_name CONSTANT VARCHAR2(30) := 'JL_CALCBAL_PKG.';
12: g_module_name_1 VARCHAR2(30) := 'JL.BR.PER_BAL_CALCULATION.';

Line 9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: g_pkg_name CONSTANT VARCHAR2(30) := 'JL_CALCBAL_PKG.';
12: g_module_name_1 VARCHAR2(30) := 'JL.BR.PER_BAL_CALCULATION.';
13: g_module_name_2 VARCHAR2(30) := 'JL.BR.DATA_FIX.';

Line 10: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9: g_level_error CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
10: g_level_exception CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
11: g_pkg_name CONSTANT VARCHAR2(30) := 'JL_CALCBAL_PKG.';
12: g_module_name_1 VARCHAR2(30) := 'JL.BR.PER_BAL_CALCULATION.';
13: g_module_name_2 VARCHAR2(30) := 'JL.BR.DATA_FIX.';
14:

Line 155: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name ||'.BEGIN', g_pkg_name || l_api_name || '()+');

151: Procedure Init_Tables_And_Variables Is
152: l_api_name CONSTANT VARCHAR2(30) := 'Init_Tables_And_Variables';
153: Begin
154: If (g_level_procedure >= g_current_runtime_level) Then
155: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name ||'.BEGIN', g_pkg_name || l_api_name || '()+');
156: End If;
157:
158: l_appl_id_tbl := r_appl_id_tbl;
159: l_sob_id_tbl := r_sob_id_tbl;

Line 184: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name ||'.END', g_pkg_name || l_api_name || '()-');

180: l_max_period_ctr := NULL;
181: l_max_bal_perctr := NULL;
182:
183: If (g_level_procedure >= g_current_runtime_level) Then
184: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name ||'.END', g_pkg_name || l_api_name || '()-');
185: End If;
186: End Init_Tables_And_Variables;
187: Begin
188: If (g_level_procedure >= g_current_runtime_level) Then

Line 189: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name ||'.BEGIN', g_pkg_name || l_api_name || '()+');

185: End If;
186: End Init_Tables_And_Variables;
187: Begin
188: If (g_level_procedure >= g_current_runtime_level) Then
189: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name ||'.BEGIN', g_pkg_name || l_api_name || '()+');
190: End If;
191:
192: For PersonnelCCID_Rec In C_PersonnelCCID Loop
193: If (g_level_procedure >= g_current_runtime_level) Then

Line 194: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

190: End If;
191:
192: For PersonnelCCID_Rec In C_PersonnelCCID Loop
193: If (g_level_procedure >= g_current_runtime_level) Then
194: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
195: 'Processing Personnel ID : ' || PersonnelCCID_Rec.vendor_id ||
196: ' Org ID : ' || PersonnelCCID_Rec.org_id ||
197: ' CCID : ' || PersonnelCCID_Rec.ccid ||
198: ' Min Period Ctr : ' || PersonnelCCID_Rec.min_jrl_perctr ||

Line 210: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

206: ,PersonnelCCID_Rec.vendor_id
207: ,PersonnelCCID_Rec.ccid
208: ,PersonnelCCID_Rec.period_set_name) Loop
209: If (g_level_procedure >= g_current_runtime_level) Then
210: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
211: 'Min Period Counter in the Balances Table : ' || Bal_Periods_Rec.min_bal_perctr);
212: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
213: 'Max Period Counter in the Balances Table : ' || Bal_Periods_Rec.min_bal_perctr);
214: End If;

Line 212: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

208: ,PersonnelCCID_Rec.period_set_name) Loop
209: If (g_level_procedure >= g_current_runtime_level) Then
210: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
211: 'Min Period Counter in the Balances Table : ' || Bal_Periods_Rec.min_bal_perctr);
212: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
213: 'Max Period Counter in the Balances Table : ' || Bal_Periods_Rec.min_bal_perctr);
214: End If;
215:
216: If PersonnelCCID_Rec.min_jrl_perctr <= nvl(Bal_Periods_Rec.min_bal_perctr,PersonnelCCID_Rec.min_jrl_perctr) Then

Line 239: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

235:
236: l_max_bal_perctr := Bal_Periods_Rec.max_bal_perctr;
237:
238: If (g_level_procedure >= g_current_runtime_level) Then
239: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
240: 'Minimum Period Counter set : ' || l_min_period_ctr);
241: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
242: 'Maximum Period Counter set : ' || l_max_period_ctr);
243: End If;

Line 241: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

237:
238: If (g_level_procedure >= g_current_runtime_level) Then
239: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
240: 'Minimum Period Counter set : ' || l_min_period_ctr);
241: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
242: 'Maximum Period Counter set : ' || l_max_period_ctr);
243: End If;
244: End Loop; -- End Loop of C_Bal_Periods Cursor
245:

Line 313: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

309: l_new_end_bal_sign_tbl(i) := 'C';
310: End If;
311: End Loop; -- End of C_Journals Loop
312: If (g_level_procedure >= g_current_runtime_level) Then
313: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
314: 'Balances for Personnel ID : ' || l_personnel_id_tbl(i) || ' CCID : ' || l_ccid_tbl(i));
315: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
316: 'Appl ID : ' || l_appl_id_tbl(i) || ' Sob ID : ' || l_sob_id_tbl(i));
317: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

Line 315: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

311: End Loop; -- End of C_Journals Loop
312: If (g_level_procedure >= g_current_runtime_level) Then
313: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
314: 'Balances for Personnel ID : ' || l_personnel_id_tbl(i) || ' CCID : ' || l_ccid_tbl(i));
315: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
316: 'Appl ID : ' || l_appl_id_tbl(i) || ' Sob ID : ' || l_sob_id_tbl(i));
317: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
318: 'Period Set Name : ' || l_period_set_name_tbl(i) || ' Period Name : ' || l_period_name_tbl(i));
319: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

Line 317: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

313: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
314: 'Balances for Personnel ID : ' || l_personnel_id_tbl(i) || ' CCID : ' || l_ccid_tbl(i));
315: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
316: 'Appl ID : ' || l_appl_id_tbl(i) || ' Sob ID : ' || l_sob_id_tbl(i));
317: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
318: 'Period Set Name : ' || l_period_set_name_tbl(i) || ' Period Name : ' || l_period_name_tbl(i));
319: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
320: 'Period Year : ' || l_period_year_tbl(i) || ' Period Num : ' || l_period_num_tbl(i));
321: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

Line 319: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

315: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
316: 'Appl ID : ' || l_appl_id_tbl(i) || ' Sob ID : ' || l_sob_id_tbl(i));
317: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
318: 'Period Set Name : ' || l_period_set_name_tbl(i) || ' Period Name : ' || l_period_name_tbl(i));
319: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
320: 'Period Year : ' || l_period_year_tbl(i) || ' Period Num : ' || l_period_num_tbl(i));
321: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
322: 'Old End Balance : ' || l_old_end_bal_tbl(i) || ' Old End Balance Sign : ' || l_old_end_bal_sign_tbl(i));
323: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

Line 321: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

317: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
318: 'Period Set Name : ' || l_period_set_name_tbl(i) || ' Period Name : ' || l_period_name_tbl(i));
319: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
320: 'Period Year : ' || l_period_year_tbl(i) || ' Period Num : ' || l_period_num_tbl(i));
321: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
322: 'Old End Balance : ' || l_old_end_bal_tbl(i) || ' Old End Balance Sign : ' || l_old_end_bal_sign_tbl(i));
323: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
324: 'Old Activity Balance : ' || l_old_act_bal_tbl(i));
325: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

Line 323: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

319: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
320: 'Period Year : ' || l_period_year_tbl(i) || ' Period Num : ' || l_period_num_tbl(i));
321: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
322: 'Old End Balance : ' || l_old_end_bal_tbl(i) || ' Old End Balance Sign : ' || l_old_end_bal_sign_tbl(i));
323: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
324: 'Old Activity Balance : ' || l_old_act_bal_tbl(i));
325: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
326: 'Current Activity Balance : ' || l_cur_act_bal_tbl(i));
327: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

Line 325: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

321: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
322: 'Old End Balance : ' || l_old_end_bal_tbl(i) || ' Old End Balance Sign : ' || l_old_end_bal_sign_tbl(i));
323: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
324: 'Old Activity Balance : ' || l_old_act_bal_tbl(i));
325: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
326: 'Current Activity Balance : ' || l_cur_act_bal_tbl(i));
327: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
328: 'New End Balance : ' || l_new_end_bal_tbl(i) || ' New End Balance Sign : ' || l_new_end_bal_sign_tbl(i));
329: End If;

Line 327: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,

323: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
324: 'Old Activity Balance : ' || l_old_act_bal_tbl(i));
325: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
326: 'Current Activity Balance : ' || l_cur_act_bal_tbl(i));
327: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name,
328: 'New End Balance : ' || l_new_end_bal_tbl(i) || ' New End Balance Sign : ' || l_new_end_bal_sign_tbl(i));
329: End If;
330: End Loop; -- End of the array processay loop
331: End If; -- End of the array count condition

Line 385: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name ||'.END', g_pkg_name || l_api_name || '()-');

381:
382: retcode := 0;
383: Commit;
384: If (g_level_procedure >= g_current_runtime_level) Then
385: Fnd_Log.String(g_level_procedure, g_module_name_1 || l_api_name ||'.END', g_pkg_name || l_api_name || '()-');
386: End If;
387: Exception
388: When Others Then
389: retcode := 2;

Line 392: Fnd_Log.String(g_level_exception, g_module_name_1 || l_api_name , errbuf);

388: When Others Then
389: retcode := 2;
390: errbuf := sqlcode || ' : ' || Substr(sqlerrm,1,80);
391: If (g_level_exception >= g_current_runtime_level) Then
392: Fnd_Log.String(g_level_exception, g_module_name_1 || l_api_name , errbuf);
393: End If;
394: ROLLBACK;
395: End Update_Balances;
396:

Line 551: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name ||'.BEGIN', g_pkg_name || l_api_name || '()+');

547: Procedure Initialize_Tables Is
548: l_api_name CONSTANT VARCHAR2(30) := 'Initialize_Tables';
549: Begin
550: If (g_level_procedure >= g_current_runtime_level) Then
551: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name ||'.BEGIN', g_pkg_name || l_api_name || '()+');
552: End If;
553:
554: l_appl_id_tbl := r_appl_id_tbl;
555: l_sob_id_tbl := r_sob_id_tbl;

Line 569: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name ||'.END', g_pkg_name || l_api_name || '()-');

565: l_org_id_tbl := r_org_id_tbl;
566: l_period_bal_tbl := r_end_bal_tbl;
567:
568: If (g_level_procedure >= g_current_runtime_level) Then
569: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name ||'.END', g_pkg_name || l_api_name || '()-');
570: End If;
571: End Initialize_Tables;
572: Begin
573: If (g_level_procedure >= g_current_runtime_level) Then

Line 574: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name ||'.BEGIN', g_pkg_name || l_api_name || '()+');

570: End If;
571: End Initialize_Tables;
572: Begin
573: If (g_level_procedure >= g_current_runtime_level) Then
574: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name ||'.BEGIN', g_pkg_name || l_api_name || '()+');
575: End If;
576:
577: For Sob_Rec in C_SOB Loop
578: If (g_level_procedure >= g_current_runtime_level) Then

Line 579: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,

575: End If;
576:
577: For Sob_Rec in C_SOB Loop
578: If (g_level_procedure >= g_current_runtime_level) Then
579: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,
580: 'Processing Set of Books ID : ' || Sob_Rec.sob_id ||
581: ' Period Set Name : ' || Sob_Rec.period_set_name ||
582: ' Period Type : ' || Sob_Rec.period_type);
583: End If;

Line 602: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,

598: raise l_invalid_initial_period;
599: End If;
600:
601: If (g_level_procedure >= g_current_runtime_level) Then
602: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,
603: 'Min Period Counter : ' || l_min_period_ctr);
604: End If;
605:
606: l_max_period_year := NULL;

Line 623: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,

619: raise l_invalid_last_period;
620: End If;
621:
622: If (g_level_procedure >= g_current_runtime_level) Then
623: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,
624: 'Max Period Counter : ' || l_max_period_ctr);
625: End If;
626:
627: -- Purge the Balances Tables

Line 640: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,

636: Initialize_Tables;
637:
638: For PersonnelCCID_Rec In C_PersonnelCCID(Sob_Rec.sob_id) Loop
639: If (g_level_procedure >= g_current_runtime_level) Then
640: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,
641: 'Processing Personnel ID : ' || PersonnelCCID_Rec.vendor_id ||
642: ' Appl ID : ' || PersonnelCCID_Rec.appl_id ||
643: ' Org ID : ' || PersonnelCCID_Rec.org_id ||
644: ' CCID : ' || PersonnelCCID_Rec.ccid);

Line 671: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,

667: l_org_id_tbl(i) := PersonnelCCID_Rec.org_id;
668: l_bal_error_flag_tbl(i) := NULL;
669:
670: If (g_level_procedure >= g_current_runtime_level) Then
671: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,
672: 'Period index : ' || i ||
673: ' Period Year : ' || l_period_year_tbl(i) ||
674: ' Period Num : ' || l_period_num_tbl(i) ||
675: ' Period Name : ' || l_period_name_tbl(i));

Line 688: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,

684: ,l_period_set_name_tbl(i)
685: ,p_initial_period) Loop
686: l_initial_balance := Initial_Bal.ending_balance;
687: If (g_level_procedure >= g_current_runtime_level) Then
688: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,
689: 'Initial Balance : ' || l_initial_balance);
690: End If;
691: End Loop;
692: End If;

Line 705: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,

701:
702: l_period_bal_tbl(i) := Journals_Rec.balance;
703:
704: If (g_level_procedure >= g_current_runtime_level) Then
705: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,
706: 'Activity : ' || l_period_bal_tbl(i));
707: End If;
708:
709: If i = 1 Then

Line 722: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,

718: l_end_bal_sign_tbl(i) := 'C';
719: End If;
720:
721: If (g_level_procedure >= g_current_runtime_level) Then
722: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name,
723: 'Ending Balance : ' || l_end_bal_tbl(i) ||
724: ' Ending Balance Sign : ' || l_end_bal_sign_tbl(i));
725: End If;
726: End Loop; -- End Loop of C_Journals

Line 785: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name ||'.END', g_pkg_name || l_api_name || '()-');

781: retcode := 0;
782: Commit;
783:
784: If (g_level_procedure >= g_current_runtime_level) Then
785: Fnd_Log.String(g_level_procedure, g_module_name_2 || l_api_name ||'.END', g_pkg_name || l_api_name || '()-');
786: End If;
787: Exception
788: When l_invalid_initial_period Then
789: errbuf := 'Program aborted due to invalid initial period';

Line 791: Fnd_Log.String(g_level_exception, g_module_name_2 || l_api_name , errbuf);

787: Exception
788: When l_invalid_initial_period Then
789: errbuf := 'Program aborted due to invalid initial period';
790: If (g_level_exception >= g_current_runtime_level) Then
791: Fnd_Log.String(g_level_exception, g_module_name_2 || l_api_name , errbuf);
792: End If;
793: retcode := 2;
794: ROLLBACK;
795: When l_invalid_last_period Then

Line 798: Fnd_Log.String(g_level_exception, g_module_name_2 || l_api_name , errbuf);

794: ROLLBACK;
795: When l_invalid_last_period Then
796: errbuf := 'Program aborted due to invalid last period';
797: If (g_level_exception >= g_current_runtime_level) Then
798: Fnd_Log.String(g_level_exception, g_module_name_2 || l_api_name , errbuf);
799: End If;
800: retcode := 2;
801: ROLLBACK;
802: When Others Then

Line 805: Fnd_Log.String(g_level_exception, g_module_name_2 || l_api_name , errbuf);

801: ROLLBACK;
802: When Others Then
803: errbuf := 'Program aborted due to error : ' || sqlcode || ': ' || Substr(sqlerrm,1,80);
804: If (g_level_exception >= g_current_runtime_level) Then
805: Fnd_Log.String(g_level_exception, g_module_name_2 || l_api_name , errbuf);
806: End If;
807: retcode := 2;
808: ROLLBACK;
809: End Rebuild_Balances;