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.PJI_TIME_C dependencies on PJI_UTILS

Line 68: pji_utils.write2log(p_text||' - '||

64: PROCEDURE print_timer(p_text VARCHAR2)
65: IS
66: BEGIN
67: IF (g_duration IS NOT NULL) THEN
68: pji_utils.write2log(p_text||' - '||
69: TO_CHAR(FLOOR(g_duration)) ||' Days '||
70: TO_CHAR(MOD(FLOOR(g_duration*24), 24))||':'||
71: TO_CHAR(MOD(FLOOR(g_duration*24*60), 60))||':'||
72: TO_CHAR(MOD(FLOOR(g_duration*24*60*60), 60)));

Line 159: g_period_set_name := pji_utils.get_period_set_name;

155:
156: /*
157: ** replace Bis_Common_Parameters with pji stuff
158: */
159: g_period_set_name := pji_utils.get_period_set_name;
160: g_period_type := pji_utils.get_period_type;
161: g_week_start_day := pji_utils.get_start_day_of_week_id;
162: --g_global_start_date := pji_utils.get_GLOBAL_START_DATE;
163: g_week_offset := get_week_offset(g_week_start_day);

Line 160: g_period_type := pji_utils.get_period_type;

156: /*
157: ** replace Bis_Common_Parameters with pji stuff
158: */
159: g_period_set_name := pji_utils.get_period_set_name;
160: g_period_type := pji_utils.get_period_type;
161: g_week_start_day := pji_utils.get_start_day_of_week_id;
162: --g_global_start_date := pji_utils.get_GLOBAL_START_DATE;
163: g_week_offset := get_week_offset(g_week_start_day);
164:

Line 161: g_week_start_day := pji_utils.get_start_day_of_week_id;

157: ** replace Bis_Common_Parameters with pji stuff
158: */
159: g_period_set_name := pji_utils.get_period_set_name;
160: g_period_type := pji_utils.get_period_type;
161: g_week_start_day := pji_utils.get_start_day_of_week_id;
162: --g_global_start_date := pji_utils.get_GLOBAL_START_DATE;
163: g_week_offset := get_week_offset(g_week_start_day);
164:
165: BEGIN

Line 162: --g_global_start_date := pji_utils.get_GLOBAL_START_DATE;

158: */
159: g_period_set_name := pji_utils.get_period_set_name;
160: g_period_type := pji_utils.get_period_type;
161: g_week_start_day := pji_utils.get_start_day_of_week_id;
162: --g_global_start_date := pji_utils.get_GLOBAL_START_DATE;
163: g_week_offset := get_week_offset(g_week_start_day);
164:
165: BEGIN
166: SELECT NVL(earliest_start_date,TRUNC(SYSDATE))

Line 181: pji_utils.write2log('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');

177: g_latest_end_date:=TRUNC(SYSDATE);
178: END;
179:
180: IF g_debug_flag = 'Y' THEN
181: pji_utils.write2log('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
182: pji_utils.write2log('Week Start Day = '||g_week_start_day);
183: pji_utils.write2log('Week offset = '||g_week_offset);
184: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(g_earliest_start_date));
185: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(g_latest_end_date));

Line 182: pji_utils.write2log('Week Start Day = '||g_week_start_day);

178: END;
179:
180: IF g_debug_flag = 'Y' THEN
181: pji_utils.write2log('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
182: pji_utils.write2log('Week Start Day = '||g_week_start_day);
183: pji_utils.write2log('Week offset = '||g_week_offset);
184: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(g_earliest_start_date));
185: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(g_latest_end_date));
186: END IF;

Line 183: pji_utils.write2log('Week offset = '||g_week_offset);

179:
180: IF g_debug_flag = 'Y' THEN
181: pji_utils.write2log('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
182: pji_utils.write2log('Week Start Day = '||g_week_start_day);
183: pji_utils.write2log('Week offset = '||g_week_offset);
184: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(g_earliest_start_date));
185: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(g_latest_end_date));
186: END IF;
187:

Line 184: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(g_earliest_start_date));

180: IF g_debug_flag = 'Y' THEN
181: pji_utils.write2log('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
182: pji_utils.write2log('Week Start Day = '||g_week_start_day);
183: pji_utils.write2log('Week offset = '||g_week_offset);
184: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(g_earliest_start_date));
185: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(g_latest_end_date));
186: END IF;
187:
188: IF (g_period_set_name IS NULL OR g_period_type IS NULL) THEN

Line 185: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(g_latest_end_date));

181: pji_utils.write2log('Enterprise Calendar = '||g_period_set_name||' ('||g_period_type||')');
182: pji_utils.write2log('Week Start Day = '||g_week_start_day);
183: pji_utils.write2log('Week offset = '||g_week_offset);
184: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(g_earliest_start_date));
185: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(g_latest_end_date));
186: END IF;
187:
188: IF (g_period_set_name IS NULL OR g_period_type IS NULL) THEN
189: RAISE G_BIS_PARAMETER_NOT_SETUP;

Line 255: pji_utils.write2log(TO_CHAR(l_week_row)||' records has been populated to Week Level');

251: l_year_num := TO_CHAR(l_week-g_week_offset,'iyyy');
252: l_week_row := l_week_row+1;
253: END LOOP;
254: IF g_debug_flag = 'Y' THEN
255: pji_utils.write2log(TO_CHAR(l_week_row)||' records has been populated to Week Level');
256: END IF;
257: END LOAD_WEEK;
258:
259: ---------------------------------------------------

Line 322: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_ENT_PERIOD table.');

318:
319: l_no_rows_inserted := SQL%rowcount;
320:
321: IF g_debug_flag = 'Y' THEN
322: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_ENT_PERIOD table.');
323: END IF;
324:
325: IF l_no_rows_inserted > 0 THEN
326: SELECT MIN(start_date), MAX(end_date)

Line 337: pji_utils.write2log('Trying to insert record into PJI_TIME_EXTR_INFO table.');

333:
334: IF g_cal_info_exists = 'N' THEN
335: BEGIN
336: IF g_debug_flag = 'Y' THEN
337: pji_utils.write2log('Trying to insert record into PJI_TIME_EXTR_INFO table.');
338: END IF;
339: INSERT INTO pji_time_cal_extr_info
340: (calendar_id, earliest_start_date,
341: latest_end_date, creation_date,

Line 349: pji_utils.write2log('Duplicate records. Now trying to update the record...');

345: sysdate, sysdate, -1, -1, -1);
346: EXCEPTION
347: WHEN DUP_VAL_ON_INDEX THEN
348: IF g_debug_flag = 'Y' THEN
349: pji_utils.write2log('Duplicate records. Now trying to update the record...');
350: END IF;
351: UPDATE pji_time_cal_extr_info
352: SET earliest_start_date = LEAST(l_min_date, earliest_start_date)
353: , latest_end_date = GREATEST(l_max_date, latest_end_date)

Line 368: pji_utils.write2log('Calendar ID: -1');

364: --g_earliest_start_date:=LEAST(l_min_date, g_earliest_start_date);
365: --g_latest_end_date:=GREATEST(l_max_date, g_latest_end_date);
366:
367: IF g_debug_flag = 'Y' THEN
368: pji_utils.write2log('Calendar ID: -1');
369: pji_utils.write2log('New Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));
370: pji_utils.write2log('New Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));
371: END IF;
372:

Line 369: pji_utils.write2log('New Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));

365: --g_latest_end_date:=GREATEST(l_max_date, g_latest_end_date);
366:
367: IF g_debug_flag = 'Y' THEN
368: pji_utils.write2log('Calendar ID: -1');
369: pji_utils.write2log('New Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));
370: pji_utils.write2log('New Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));
371: END IF;
372:
373: END IF;

Line 370: pji_utils.write2log('New Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));

366:
367: IF g_debug_flag = 'Y' THEN
368: pji_utils.write2log('Calendar ID: -1');
369: pji_utils.write2log('New Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));
370: pji_utils.write2log('New Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));
371: END IF;
372:
373: END IF;
374:

Line 383: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_ENT_PERIOD table.');

379: END IF;
380: EXCEPTION
381: WHEN DUP_VAL_ON_INDEX THEN
382: IF g_debug_flag = 'Y' THEN
383: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_ENT_PERIOD table.');
384: END IF;
385: RETURN FALSE;
386: END LOAD_ENT_PERIOD;
387:

Line 417: pji_utils.write2log('l_start_qtr_id: '||l_start_qtr_id);

413: WHERE 1=1
414: AND (g_earliest_start_date BETWEEN start_date AND end_date)
415: OR (g_latest_end_date BETWEEN start_date AND end_date);
416: IF g_debug_flag = 'Y' THEN
417: pji_utils.write2log('l_start_qtr_id: '||l_start_qtr_id);
418: pji_utils.write2log('l_end_qtr_id: '||l_end_qtr_id);
419: pji_utils.write2log('l_earliest_qtr_end_date: '||l_earliest_qtr_end_date);
420: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);
421: END IF;

Line 418: pji_utils.write2log('l_end_qtr_id: '||l_end_qtr_id);

414: AND (g_earliest_start_date BETWEEN start_date AND end_date)
415: OR (g_latest_end_date BETWEEN start_date AND end_date);
416: IF g_debug_flag = 'Y' THEN
417: pji_utils.write2log('l_start_qtr_id: '||l_start_qtr_id);
418: pji_utils.write2log('l_end_qtr_id: '||l_end_qtr_id);
419: pji_utils.write2log('l_earliest_qtr_end_date: '||l_earliest_qtr_end_date);
420: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);
421: END IF;
422: END IF;

Line 419: pji_utils.write2log('l_earliest_qtr_end_date: '||l_earliest_qtr_end_date);

415: OR (g_latest_end_date BETWEEN start_date AND end_date);
416: IF g_debug_flag = 'Y' THEN
417: pji_utils.write2log('l_start_qtr_id: '||l_start_qtr_id);
418: pji_utils.write2log('l_end_qtr_id: '||l_end_qtr_id);
419: pji_utils.write2log('l_earliest_qtr_end_date: '||l_earliest_qtr_end_date);
420: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);
421: END IF;
422: END IF;
423:

Line 420: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);

416: IF g_debug_flag = 'Y' THEN
417: pji_utils.write2log('l_start_qtr_id: '||l_start_qtr_id);
418: pji_utils.write2log('l_end_qtr_id: '||l_end_qtr_id);
419: pji_utils.write2log('l_earliest_qtr_end_date: '||l_earliest_qtr_end_date);
420: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);
421: END IF;
422: END IF;
423:
424: DELETE FROM pji_time_ent_qtr

Line 430: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_ENT_QTR table.');

426:
427: l_no_rows_deleted := SQL%rowcount;
428:
429: IF g_debug_flag = 'Y' THEN
430: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_ENT_QTR table.');
431: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_ENT_QTR table.');
432: END IF;
433:
434: INSERT INTO pji_time_ent_qtr

Line 431: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_ENT_QTR table.');

427: l_no_rows_deleted := SQL%rowcount;
428:
429: IF g_debug_flag = 'Y' THEN
430: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_ENT_QTR table.');
431: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_ENT_QTR table.');
432: END IF;
433:
434: INSERT INTO pji_time_ent_qtr
435: (ent_qtr_id

Line 471: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_ENT_QTR table.');

467:
468: l_no_rows_inserted := SQL%rowcount;
469:
470: IF g_debug_flag = 'Y' THEN
471: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_ENT_QTR table.');
472: END IF;
473:
474: EXCEPTION
475: WHEN DUP_VAL_ON_INDEX THEN

Line 477: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_ENT_QTR table.');

473:
474: EXCEPTION
475: WHEN DUP_VAL_ON_INDEX THEN
476: IF g_debug_flag = 'Y' THEN
477: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_ENT_QTR table.');
478: END IF;
479: END LOAD_ENT_QTR;
480:
481: ---------------------------------------------------

Line 510: pji_utils.write2log('l_start_yr_id: '||l_start_yr_id);

506: WHERE 1=1
507: AND (g_earliest_start_date BETWEEN start_date AND end_date)
508: OR (g_latest_end_date BETWEEN start_date AND end_date);
509: IF g_debug_flag = 'Y' THEN
510: pji_utils.write2log('l_start_yr_id: '||l_start_yr_id);
511: pji_utils.write2log('l_end_yr_id: '||l_end_yr_id);
512: pji_utils.write2log('l_earliest_yr_end_date: '||l_earliest_yr_end_date);
513: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);
514: END IF;

Line 511: pji_utils.write2log('l_end_yr_id: '||l_end_yr_id);

507: AND (g_earliest_start_date BETWEEN start_date AND end_date)
508: OR (g_latest_end_date BETWEEN start_date AND end_date);
509: IF g_debug_flag = 'Y' THEN
510: pji_utils.write2log('l_start_yr_id: '||l_start_yr_id);
511: pji_utils.write2log('l_end_yr_id: '||l_end_yr_id);
512: pji_utils.write2log('l_earliest_yr_end_date: '||l_earliest_yr_end_date);
513: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);
514: END IF;
515: END IF;

Line 512: pji_utils.write2log('l_earliest_yr_end_date: '||l_earliest_yr_end_date);

508: OR (g_latest_end_date BETWEEN start_date AND end_date);
509: IF g_debug_flag = 'Y' THEN
510: pji_utils.write2log('l_start_yr_id: '||l_start_yr_id);
511: pji_utils.write2log('l_end_yr_id: '||l_end_yr_id);
512: pji_utils.write2log('l_earliest_yr_end_date: '||l_earliest_yr_end_date);
513: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);
514: END IF;
515: END IF;
516:

Line 513: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);

509: IF g_debug_flag = 'Y' THEN
510: pji_utils.write2log('l_start_yr_id: '||l_start_yr_id);
511: pji_utils.write2log('l_end_yr_id: '||l_end_yr_id);
512: pji_utils.write2log('l_earliest_yr_end_date: '||l_earliest_yr_end_date);
513: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);
514: END IF;
515: END IF;
516:
517: DELETE FROM pji_time_ent_year

Line 523: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_ENT_YEAR table.');

519:
520: l_no_rows_deleted := SQL%rowcount;
521:
522: IF g_debug_flag = 'Y' THEN
523: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_ENT_YEAR table.');
524: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_ENT_YEAR table.');
525: END IF;
526:
527: INSERT INTO pji_time_ent_year

Line 524: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_ENT_YEAR table.');

520: l_no_rows_deleted := SQL%rowcount;
521:
522: IF g_debug_flag = 'Y' THEN
523: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_ENT_YEAR table.');
524: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_ENT_YEAR table.');
525: END IF;
526:
527: INSERT INTO pji_time_ent_year
528: (ent_year_id

Line 561: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_ENT_YEAR table.');

557:
558: l_no_rows_inserted := SQL%rowcount;
559:
560: IF g_debug_flag = 'Y' THEN
561: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_ENT_YEAR table.');
562: END IF;
563:
564: EXCEPTION
565: WHEN DUP_VAL_ON_INDEX THEN

Line 567: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_ENT_YEAR table.');

563:
564: EXCEPTION
565: WHEN DUP_VAL_ON_INDEX THEN
566: IF g_debug_flag = 'Y' THEN
567: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_ENT_YEAR table.');
568: END IF;
569: END LOAD_ENT_YEAR;
570:
571: FUNCTION LOAD_CAL_PERIOD( p_calendar_id NUMBER

Line 634: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_PERIOD table.');

630:
631: l_no_rows_inserted := SQL%rowcount;
632:
633: IF g_debug_flag = 'Y' THEN
634: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_PERIOD table.');
635: END IF;
636:
637: IF l_no_rows_inserted > 0 THEN
638: SELECT MIN(start_date), MAX(end_date)

Line 650: pji_utils.write2log('Trying to insert record into PJI_TIME_EXTR_INFO table.');

646:
647: IF p_cal_info_exists = 'N' THEN
648: BEGIN
649: IF g_debug_flag = 'Y' THEN
650: pji_utils.write2log('Trying to insert record into PJI_TIME_EXTR_INFO table.');
651: END IF;
652: INSERT INTO pji_time_cal_extr_info
653: (calendar_id, earliest_start_date,
654: latest_end_date, creation_date,

Line 662: pji_utils.write2log('Duplicate records. Now trying to update the record...');

658: sysdate, sysdate, -1, -1, -1);
659: EXCEPTION
660: WHEN DUP_VAL_ON_INDEX THEN
661: IF g_debug_flag = 'Y' THEN
662: pji_utils.write2log('Duplicate records. Now trying to update the record...');
663: END IF;
664: UPDATE pji_time_cal_extr_info
665: SET earliest_start_date = LEAST(l_min_date, earliest_start_date)
666: , latest_end_date = GREATEST(l_max_date, latest_end_date)

Line 677: pji_utils.write2log('Calendar ID: '||p_calendar_id);

673: WHERE calendar_id = p_calendar_id;
674: END IF;
675:
676: IF g_debug_flag = 'Y' THEN
677: pji_utils.write2log('Calendar ID: '||p_calendar_id);
678: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));
679: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));
680: END IF;
681:

Line 678: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));

674: END IF;
675:
676: IF g_debug_flag = 'Y' THEN
677: pji_utils.write2log('Calendar ID: '||p_calendar_id);
678: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));
679: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));
680: END IF;
681:
682: END IF;

Line 679: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));

675:
676: IF g_debug_flag = 'Y' THEN
677: pji_utils.write2log('Calendar ID: '||p_calendar_id);
678: pji_utils.write2log('Earliest Start Date: '||Fnd_Date.date_to_displaydate(l_min_date));
679: pji_utils.write2log('Latest End Date: '||Fnd_Date.date_to_displaydate(l_max_date));
680: END IF;
681:
682: END IF;
683: IF l_no_rows_inserted >0 THEN

Line 691: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_PERIOD table.');

687: END IF;
688: EXCEPTION
689: WHEN DUP_VAL_ON_INDEX THEN
690: IF g_debug_flag = 'Y' THEN
691: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_PERIOD table.');
692: END IF;
693: RETURN FALSE;
694: END LOAD_CAL_PERIOD;
695:

Line 730: pji_utils.write2log('l_start_qtr_id: '||l_start_qtr_id);

726: AND calendar_id = p_calendar_id
727: AND (p_earliest_start_date BETWEEN start_date AND end_date)
728: OR (p_latest_end_date BETWEEN start_date AND end_date);
729: IF g_debug_flag = 'Y' THEN
730: pji_utils.write2log('l_start_qtr_id: '||l_start_qtr_id);
731: pji_utils.write2log('l_end_qtr_id: '||l_end_qtr_id);
732: pji_utils.write2log('l_earliest_qtr_end_date: '||l_earliest_qtr_end_date);
733: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);
734: END IF;

Line 731: pji_utils.write2log('l_end_qtr_id: '||l_end_qtr_id);

727: AND (p_earliest_start_date BETWEEN start_date AND end_date)
728: OR (p_latest_end_date BETWEEN start_date AND end_date);
729: IF g_debug_flag = 'Y' THEN
730: pji_utils.write2log('l_start_qtr_id: '||l_start_qtr_id);
731: pji_utils.write2log('l_end_qtr_id: '||l_end_qtr_id);
732: pji_utils.write2log('l_earliest_qtr_end_date: '||l_earliest_qtr_end_date);
733: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);
734: END IF;
735: END IF;

Line 732: pji_utils.write2log('l_earliest_qtr_end_date: '||l_earliest_qtr_end_date);

728: OR (p_latest_end_date BETWEEN start_date AND end_date);
729: IF g_debug_flag = 'Y' THEN
730: pji_utils.write2log('l_start_qtr_id: '||l_start_qtr_id);
731: pji_utils.write2log('l_end_qtr_id: '||l_end_qtr_id);
732: pji_utils.write2log('l_earliest_qtr_end_date: '||l_earliest_qtr_end_date);
733: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);
734: END IF;
735: END IF;
736:

Line 733: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);

729: IF g_debug_flag = 'Y' THEN
730: pji_utils.write2log('l_start_qtr_id: '||l_start_qtr_id);
731: pji_utils.write2log('l_end_qtr_id: '||l_end_qtr_id);
732: pji_utils.write2log('l_earliest_qtr_end_date: '||l_earliest_qtr_end_date);
733: pji_utils.write2log('l_latest_qtr_start_date: '||l_latest_qtr_start_date);
734: END IF;
735: END IF;
736:
737: DELETE FROM pji_time_cal_qtr

Line 743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');

739:
740: l_no_rows_deleted := SQL%rowcount;
741:
742: IF g_debug_flag = 'Y' THEN
743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');
744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');
745: END IF;
746:
747: INSERT INTO pji_time_cal_qtr

Line 744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');

740: l_no_rows_deleted := SQL%rowcount;
741:
742: IF g_debug_flag = 'Y' THEN
743: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_QTR table.');
744: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_QTR table.');
745: END IF;
746:
747: INSERT INTO pji_time_cal_qtr
748: (cal_qtr_id

Line 784: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_QTR table.');

780:
781: l_no_rows_inserted := SQL%rowcount;
782:
783: IF g_debug_flag = 'Y' THEN
784: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_QTR table.');
785: END IF;
786:
787: EXCEPTION
788: WHEN DUP_VAL_ON_INDEX THEN

Line 790: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_QTR table.');

786:
787: EXCEPTION
788: WHEN DUP_VAL_ON_INDEX THEN
789: IF g_debug_flag = 'Y' THEN
790: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_QTR table.');
791: END IF;
792: END LOAD_CAL_QUARTER;
793:
794: ---------------------------------------------------

Line 828: pji_utils.write2log('l_start_yr_id: '||l_start_yr_id);

824: AND (g_earliest_start_date BETWEEN start_date AND end_date)
825: OR (g_latest_end_date BETWEEN start_date AND end_date);
826:
827: IF g_debug_flag = 'Y' THEN
828: pji_utils.write2log('l_start_yr_id: '||l_start_yr_id);
829: pji_utils.write2log('l_end_yr_id: '||l_end_yr_id);
830: pji_utils.write2log('l_earliest_yr_end_date: '||l_earliest_yr_end_date);
831: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);
832: END IF;

Line 829: pji_utils.write2log('l_end_yr_id: '||l_end_yr_id);

825: OR (g_latest_end_date BETWEEN start_date AND end_date);
826:
827: IF g_debug_flag = 'Y' THEN
828: pji_utils.write2log('l_start_yr_id: '||l_start_yr_id);
829: pji_utils.write2log('l_end_yr_id: '||l_end_yr_id);
830: pji_utils.write2log('l_earliest_yr_end_date: '||l_earliest_yr_end_date);
831: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);
832: END IF;
833: END IF;

Line 830: pji_utils.write2log('l_earliest_yr_end_date: '||l_earliest_yr_end_date);

826:
827: IF g_debug_flag = 'Y' THEN
828: pji_utils.write2log('l_start_yr_id: '||l_start_yr_id);
829: pji_utils.write2log('l_end_yr_id: '||l_end_yr_id);
830: pji_utils.write2log('l_earliest_yr_end_date: '||l_earliest_yr_end_date);
831: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);
832: END IF;
833: END IF;
834:

Line 831: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);

827: IF g_debug_flag = 'Y' THEN
828: pji_utils.write2log('l_start_yr_id: '||l_start_yr_id);
829: pji_utils.write2log('l_end_yr_id: '||l_end_yr_id);
830: pji_utils.write2log('l_earliest_yr_end_date: '||l_earliest_yr_end_date);
831: pji_utils.write2log('l_latest_yr_start_date: '||l_latest_yr_start_date);
832: END IF;
833: END IF;
834:
835: DELETE FROM pji_time_cal_year

Line 841: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_YEAR table.');

837:
838: l_no_rows_deleted := SQL%rowcount;
839:
840: IF g_debug_flag = 'Y' THEN
841: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_YEAR table.');
842: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_YEAR table.');
843: END IF;
844:
845: INSERT INTO PJI_TIME_CAL_YEAR

Line 842: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_YEAR table.');

838: l_no_rows_deleted := SQL%rowcount;
839:
840: IF g_debug_flag = 'Y' THEN
841: pji_utils.write2log('Some records have to be refreshed in PJI_TIME_CAL_YEAR table.');
842: pji_utils.write2log(TO_CHAR(l_no_rows_deleted)||' records have been deleted from PJI_TIME_CAL_YEAR table.');
843: END IF;
844:
845: INSERT INTO PJI_TIME_CAL_YEAR
846: (cal_year_id

Line 877: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_YEAR table.');

873:
874: l_no_rows_inserted := SQL%rowcount;
875:
876: IF g_debug_flag = 'Y' THEN
877: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_YEAR table.');
878: END IF;
879:
880: EXCEPTION
881: WHEN DUP_VAL_ON_INDEX THEN

Line 883: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_YEAR table.');

879:
880: EXCEPTION
881: WHEN DUP_VAL_ON_INDEX THEN
882: IF g_debug_flag = 'Y' THEN
883: pji_utils.write2log('Duplicate records. No records have been inserted into PJI_TIME_CAL_YEAR table.');
884: END IF;
885: END LOAD_CAL_YEAR;
886:
887: ---------------------------------------------------

Line 903: pji_utils.write2log('The enterprise calendar has been extended before the earliest start date.');

899: l_period_end_date DATE;
900: BEGIN
901: IF g_min_date < g_earliest_start_date THEN
902: IF g_debug_flag = 'Y' THEN
903: pji_utils.write2log('The enterprise calendar has been extended before the earliest start date.');
904: END IF;
905: BEGIN
906: SELECT period.start_date period_start_date
907: , qtr.start_date qtr_start_date

Line 928: pji_utils.write2log('Creating prior year records for time periods after the current year.');

924: AND qtr.ent_year_id = yr.ent_year_id
925: AND period.start_date = g_earliest_start_date;
926:
927: IF g_debug_flag = 'Y' THEN
928: pji_utils.write2log('Creating prior year records for time periods after the current year.');
929: END IF;
930:
931: INSERT INTO PJI_TIME_RPT_STRUCT
932: (calendar_id

Line 963: pji_utils.write2log('Creating prior quarter records for time periods records after current quarter.');

959:
960: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
961:
962: IF g_debug_flag = 'Y' THEN
963: pji_utils.write2log('Creating prior quarter records for time periods records after current quarter.');
964: END IF;
965:
966: INSERT INTO PJI_TIME_RPT_STRUCT
967: (calendar_id

Line 1001: pji_utils.write2log('Creating prior period records for time periods records after current periods.');

997:
998: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
999:
1000: IF g_debug_flag = 'Y' THEN
1001: pji_utils.write2log('Creating prior period records for time periods records after current periods.');
1002: END IF;
1003:
1004: INSERT INTO PJI_TIME_RPT_STRUCT
1005: (calendar_id

Line 1040: pji_utils.write2log('Unable to derive records for earliest start date.');

1036: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1037: EXCEPTION
1038: WHEN NO_DATA_FOUND THEN
1039: IF g_debug_flag = 'Y' THEN
1040: pji_utils.write2log('Unable to derive records for earliest start date.');
1041: END IF;
1042: END;
1043: END IF;
1044:

Line 1046: pji_utils.write2log('Creating entries in the enterprise reporting structure table for extracted records only.');

1042: END;
1043: END IF;
1044:
1045: IF g_debug_flag = 'Y' THEN
1046: pji_utils.write2log('Creating entries in the enterprise reporting structure table for extracted records only.');
1047: END IF;
1048:
1049: FOR extr_rec IN (SELECT extr.start_date report_date
1050: , period.start_date period_start_date

Line 1206: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));

1202:
1203: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1204:
1205: IF g_debug_flag = 'Y' THEN
1206: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));
1207: END IF;
1208:
1209: END LOOP;
1210: END LOAD_TIME_RPT_STRUCT;

Line 1232: pji_utils.write2log('The fiscal calendar has been extended before the earliest start date.');

1228: l_period_end_date DATE;
1229: BEGIN
1230: IF p_min_date < p_earliest_start_date and p_cal_info_exists <> 'N' THEN
1231: IF g_debug_flag = 'Y' THEN
1232: pji_utils.write2log('The fiscal calendar has been extended before the earliest start date.');
1233: END IF;
1234: BEGIN
1235: SELECT period.start_date period_start_date
1236: , qtr.start_date qtr_start_date

Line 1258: pji_utils.write2log('Creating prior year records for time periods after the current year.');

1254: AND qtr.cal_year_id = yr.cal_year_id
1255: AND period.start_date = p_earliest_start_date;
1256:
1257: IF g_debug_flag = 'Y' THEN
1258: pji_utils.write2log('Creating prior year records for time periods after the current year.');
1259: END IF;
1260:
1261: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1262: (calendar_id

Line 1295: pji_utils.write2log('Creating prior quarter records for time periods records after current quarter.');

1291:
1292: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1293:
1294: IF g_debug_flag = 'Y' THEN
1295: pji_utils.write2log('Creating prior quarter records for time periods records after current quarter.');
1296: END IF;
1297:
1298: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1299: (calendar_id

Line 1335: pji_utils.write2log('Creating prior period records for time periods records after current periods.');

1331:
1332: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1333:
1334: IF g_debug_flag = 'Y' THEN
1335: pji_utils.write2log('Creating prior period records for time periods records after current periods.');
1336: END IF;
1337:
1338: INSERT INTO PJI_TIME_CAL_RPT_STRUCT
1339: (calendar_id

Line 1376: pji_utils.write2log('Unable to derive records for earliest start date.');

1372: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1373: EXCEPTION
1374: WHEN NO_DATA_FOUND THEN
1375: IF g_debug_flag = 'Y' THEN
1376: pji_utils.write2log('Unable to derive records for earliest start date.');
1377: END IF;
1378: END;
1379: END IF;
1380:

Line 1382: pji_utils.write2log('Creating entries in the fiscal reporting structure table for extracted records only.');

1378: END;
1379: END IF;
1380:
1381: IF g_debug_flag = 'Y' THEN
1382: pji_utils.write2log('Creating entries in the fiscal reporting structure table for extracted records only.');
1383: END IF;
1384:
1385: FOR extr_rec IN (SELECT extr.start_date report_date
1386: , period.start_date period_start_date

Line 1549: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));

1545:
1546: l_no_rows_inserted := l_no_rows_inserted + SQL%rowcount;
1547:
1548: IF g_debug_flag = 'Y' THEN
1549: pji_utils.write2log(TO_CHAR(l_no_rows_inserted)||' records have been inserted into PJI_TIME_CAL_RPT_STRUCT table for date : '||Fnd_Date.date_to_displaydate(extr_rec.report_date));
1550: END IF;
1551:
1552: END LOOP;
1553: END LOAD_TIME_CAL_RPT_STRUCT;

Line 1649: pji_utils.write2log(' ');

1645: NULL;
1646: END;
1647:
1648: IF g_debug_flag = 'Y' THEN
1649: pji_utils.write2log(' ');
1650: pji_utils.write2log('Processing Enterprise calendar.');
1651: START_TIMER;
1652: END IF;
1653:

Line 1650: pji_utils.write2log('Processing Enterprise calendar.');

1646: END;
1647:
1648: IF g_debug_flag = 'Y' THEN
1649: pji_utils.write2log(' ');
1650: pji_utils.write2log('Processing Enterprise calendar.');
1651: START_TIMER;
1652: END IF;
1653:
1654: IF l_process_ent_flag='Y' AND LOAD_ENT_PERIOD THEN

Line 1679: pji_utils.write2log(' ');

1675: LOAD_TIME_RPT_STRUCT;
1676: IF g_debug_flag = 'Y' THEN
1677: STOP_TIMER;
1678: PRINT_TIMER('Process Time for Enterprise Reporting Structures API');
1679: pji_utils.write2log(' ');
1680: END IF;
1681: ELSE
1682: IF g_debug_flag = 'Y' THEN
1683: STOP_TIMER;

Line 1685: pji_utils.write2log('No further changes to extract for enterprise calendar.'||

1681: ELSE
1682: IF g_debug_flag = 'Y' THEN
1683: STOP_TIMER;
1684: PRINT_TIMER('Process Time for Enterprise Period API');
1685: pji_utils.write2log('No further changes to extract for enterprise calendar.'||
1686: 'Skipping Quarter, Year and Reporting Struct APIs.');
1687: pji_utils.write2log(' ');
1688: END IF;
1689: END IF;

Line 1687: pji_utils.write2log(' ');

1683: STOP_TIMER;
1684: PRINT_TIMER('Process Time for Enterprise Period API');
1685: pji_utils.write2log('No further changes to extract for enterprise calendar.'||
1686: 'Skipping Quarter, Year and Reporting Struct APIs.');
1687: pji_utils.write2log(' ');
1688: END IF;
1689: END IF;
1690:
1691: IF l_calendar_ids_tbl.COUNT > 0 THEN

Line 1695: pji_utils.write2log('Processing Fiscal calendar '||l_period_set_name_tbl(i)||

1691: IF l_calendar_ids_tbl.COUNT > 0 THEN
1692: FOR i IN l_calendar_ids_tbl.FIRST..l_calendar_ids_tbl.LAST
1693: LOOP
1694: IF g_debug_flag = 'Y' THEN
1695: pji_utils.write2log('Processing Fiscal calendar '||l_period_set_name_tbl(i)||
1696: '('||l_period_type_tbl(i)||').');
1697: START_TIMER;
1698: END IF;
1699: IF LOAD_CAL_PERIOD( l_calendar_ids_tbl(i)

Line 1739: pji_utils.write2log(' ');

1735: , l_cal_info_exists_tbl(i));
1736: IF g_debug_flag = 'Y' THEN
1737: STOP_TIMER;
1738: PRINT_TIMER('Process Time for Fiscal Reporting Structures API');
1739: pji_utils.write2log(' ');
1740: END IF;
1741: ELSE
1742: IF g_debug_flag = 'Y' THEN
1743: STOP_TIMER;

Line 1745: pji_utils.write2log('No further changes to extract for this calendar. '||

1741: ELSE
1742: IF g_debug_flag = 'Y' THEN
1743: STOP_TIMER;
1744: PRINT_TIMER('Process Time for Fiscal Period API');
1745: pji_utils.write2log('No further changes to extract for this calendar. '||
1746: 'Skipping Quarter, Year and Reporting Struct APIs...');
1747: pji_utils.write2log(' ');
1748: END IF;
1749: END IF;

Line 1747: pji_utils.write2log(' ');

1743: STOP_TIMER;
1744: PRINT_TIMER('Process Time for Fiscal Period API');
1745: pji_utils.write2log('No further changes to extract for this calendar. '||
1746: 'Skipping Quarter, Year and Reporting Struct APIs...');
1747: pji_utils.write2log(' ');
1748: END IF;
1749: END IF;
1750: NULL;
1751: END LOOP;

Line 1757: pji_utils.write2log(' ');

1753: x_return_status:=Fnd_Api.G_RET_STS_SUCCESS;
1754: COMMIT;
1755: EXCEPTION
1756: WHEN OTHERS THEN
1757: pji_utils.write2log(' ');
1758: pji_utils.write2log(' ');
1759: x_return_status:=Fnd_Api.G_RET_STS_SUCCESS;
1760: ROLLBACK;
1761: END LOAD;

Line 1758: pji_utils.write2log(' ');

1754: COMMIT;
1755: EXCEPTION
1756: WHEN OTHERS THEN
1757: pji_utils.write2log(' ');
1758: pji_utils.write2log(' ');
1759: x_return_status:=Fnd_Api.G_RET_STS_SUCCESS;
1760: ROLLBACK;
1761: END LOAD;
1762: