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.PA_REP_UTILS_SUMM_PKG dependencies on PA_DEBUG

Line 4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */

1: PACKAGE BODY PA_REP_UTILS_SUMM_PKG as
2: /* $Header: PARRSUMB.pls 120.0.12010000.2 2009/05/26 12:46:52 nisinha ship $ */
3:
4: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
5:
6: /*
7: * This variable is populated by the public procedure of this
8: * package.

Line 156: PA_DEBUG.set_curr_function('summarize_by_period');

152: IS
153: i PLS_INTEGER;
154: BEGIN
155:
156: PA_DEBUG.set_curr_function('summarize_by_period');
157: /*
158: * Step 1 - Populate the global temporary table from individual PL/SQL Table
159: * in bulk.
160: */

Line 175: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';

171: /*
172: * Populate pa_rep_util_summ_tmp for Total Hours.
173: */
174: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
175: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';
176: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
177: END IF;
178: INSERT INTO pa_rep_util_summ_tmp
179: ( RECORD_TYPE

Line 176: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

172: * Populate pa_rep_util_summ_tmp for Total Hours.
173: */
174: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
175: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';
176: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
177: END IF;
178: INSERT INTO pa_rep_util_summ_tmp
179: ( RECORD_TYPE
180: ,EXPENDITURE_ORGANIZATION_ID

Line 263: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';

259: /*
260: * Populate pa_rep_util_summ_tmp for Total Provisional Hours.
261: */
262: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
263: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';
264: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
265: END IF;
266:
267: INSERT INTO pa_rep_util_summ_tmp

Line 264: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

260: * Populate pa_rep_util_summ_tmp for Total Provisional Hours.
261: */
262: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
263: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';
264: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
265: END IF;
266:
267: INSERT INTO pa_rep_util_summ_tmp
268: ( RECORD_TYPE

Line 349: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';

345: /*
346: * Populate pa_rep_util_summ_tmp for Total Weighted Hours - People.
347: */
348: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
349: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';
350: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
351: END IF;
352:
353: INSERT INTO pa_rep_util_summ_tmp

Line 350: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

346: * Populate pa_rep_util_summ_tmp for Total Weighted Hours - People.
347: */
348: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
349: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';
350: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
351: END IF;
352:
353: INSERT INTO pa_rep_util_summ_tmp
354: ( RECORD_TYPE

Line 434: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';

430: /*
431: * Populate pa_rep_util_summ_tmp for Total Weighted Hours -Organization.
432: */
433: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
434: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';
435: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
436: END IF;
437:
438: INSERT INTO pa_rep_util_summ_tmp

Line 435: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

431: * Populate pa_rep_util_summ_tmp for Total Weighted Hours -Organization.
432: */
433: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
434: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';
435: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
436: END IF;
437:
438: INSERT INTO pa_rep_util_summ_tmp
439: ( RECORD_TYPE

Line 520: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';

516: /*
517: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -People.
518: */
519: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
520: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';
521: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
522: END IF;
523:
524: INSERT INTO pa_rep_util_summ_tmp

Line 521: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

517: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -People.
518: */
519: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
520: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';
521: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
522: END IF;
523:
524: INSERT INTO pa_rep_util_summ_tmp
525: ( RECORD_TYPE

Line 605: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';

601: /*
602: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -Organization.
603: */
604: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
605: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';
606: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
607: END IF;
608:
609: INSERT INTO pa_rep_util_summ_tmp

Line 606: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

602: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -Organization.
603: */
604: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
605: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';
606: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
607: END IF;
608:
609: INSERT INTO pa_rep_util_summ_tmp
610: ( RECORD_TYPE

Line 691: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Reduce Capacity';

687: /*
688: * Populate pa_rep_util_summ_tmp for Reduce Capacity.
689: */
690: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
691: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Reduce Capacity';
692: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
693: END IF;
694:
695: INSERT INTO pa_rep_util_summ_tmp

Line 692: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

688: * Populate pa_rep_util_summ_tmp for Reduce Capacity.
689: */
690: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
691: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Reduce Capacity';
692: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
693: END IF;
694:
695: INSERT INTO pa_rep_util_summ_tmp
696: ( RECORD_TYPE

Line 782: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';

778: * Populate pa_rep_util_summ_tmp for Total Hours.
779: */
780:
781: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
782: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';
783: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
784: END IF;
785:
786: INSERT INTO pa_rep_util_summ_tmp

Line 783: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

779: */
780:
781: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
782: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Hours ';
783: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
784: END IF;
785:
786: INSERT INTO pa_rep_util_summ_tmp
787: ( RECORD_TYPE

Line 869: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';

865: /*
866: * Populate pa_rep_util_summ_tmp for Total Provisional Hours.
867: */
868: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
869: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';
870: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
871: END IF;
872:
873: INSERT INTO pa_rep_util_summ_tmp

Line 870: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

866: * Populate pa_rep_util_summ_tmp for Total Provisional Hours.
867: */
868: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
869: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Hours';
870: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
871: END IF;
872:
873: INSERT INTO pa_rep_util_summ_tmp
874: ( RECORD_TYPE

Line 955: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';

951: /*
952: * Populate pa_rep_util_summ_tmp for Total Weighted Hours - People.
953: */
954: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
955: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';
956: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
957: END IF;
958:
959: INSERT INTO pa_rep_util_summ_tmp

Line 956: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

952: * Populate pa_rep_util_summ_tmp for Total Weighted Hours - People.
953: */
954: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
955: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-People';
956: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
957: END IF;
958:
959: INSERT INTO pa_rep_util_summ_tmp
960: ( RECORD_TYPE

Line 1039: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';

1035: /*
1036: * Populate pa_rep_util_summ_tmp for Total Weighted Hours -Organization.
1037: */
1038: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1039: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';
1040: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1041: END IF;
1042: INSERT INTO pa_rep_util_summ_tmp
1043: ( RECORD_TYPE

Line 1040: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1036: * Populate pa_rep_util_summ_tmp for Total Weighted Hours -Organization.
1037: */
1038: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1039: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Weighted Hours-Org';
1040: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1041: END IF;
1042: INSERT INTO pa_rep_util_summ_tmp
1043: ( RECORD_TYPE
1044: ,EXPENDITURE_ORGANIZATION_ID

Line 1124: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';

1120: /*
1121: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -People.
1122: */
1123: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1124: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';
1125: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1126: END IF;
1127:
1128: INSERT INTO pa_rep_util_summ_tmp

Line 1125: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1121: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -People.
1122: */
1123: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1124: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-People';
1125: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1126: END IF;
1127:
1128: INSERT INTO pa_rep_util_summ_tmp
1129: ( RECORD_TYPE

Line 1208: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';

1204: /*
1205: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -Organization.
1206: */
1207: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1208: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';
1209: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1210: END IF;
1211:
1212: INSERT INTO pa_rep_util_summ_tmp

Line 1209: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1205: * Populate pa_rep_util_summ_tmp for Prov Weighted Hours -Organization.
1206: */
1207: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1208: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp for Prov Weighted Hours-Org';
1209: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1210: END IF;
1211:
1212: INSERT INTO pa_rep_util_summ_tmp
1213: ( RECORD_TYPE

Line 1294: PA_DEBUG.g_err_stage:='Populate pa_rep_util_summ_tmp for Reduce Capacity';

1290: /*
1291: * Populate pa_rep_util_summ_tmp for Reduce Capacity.
1292: */
1293: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1294: PA_DEBUG.g_err_stage:='Populate pa_rep_util_summ_tmp for Reduce Capacity';
1295: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1296: END IF;
1297:
1298: INSERT INTO pa_rep_util_summ_tmp

Line 1295: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1291: * Populate pa_rep_util_summ_tmp for Reduce Capacity.
1292: */
1293: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1294: PA_DEBUG.g_err_stage:='Populate pa_rep_util_summ_tmp for Reduce Capacity';
1295: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1296: END IF;
1297:
1298: INSERT INTO pa_rep_util_summ_tmp
1299: ( RECORD_TYPE

Line 1388: PA_DEBUG.g_err_stage:='Summarization By PA Period';

1384:
1385: IF ( PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag = 'Y')
1386: THEN
1387: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1388: PA_DEBUG.g_err_stage:='Summarization By PA Period';
1389: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1390: END IF;
1391:
1392: INSERT INTO pa_rep_util_summ_tmp

Line 1389: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1385: IF ( PA_REP_UTIL_GLOB.G_util_option_details.G_pa_period_flag = 'Y')
1386: THEN
1387: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1388: PA_DEBUG.g_err_stage:='Summarization By PA Period';
1389: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1390: END IF;
1391:
1392: INSERT INTO pa_rep_util_summ_tmp
1393: ( record_type,

Line 1484: PA_DEBUG.g_err_stage:='Summarization By GL Period';

1480:
1481: IF ( PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag = 'Y')
1482: THEN
1483: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1484: PA_DEBUG.g_err_stage:='Summarization By GL Period';
1485: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1486: END IF;
1487:
1488: INSERT INTO pa_rep_util_summ_tmp

Line 1485: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1481: IF ( PA_REP_UTIL_GLOB.G_util_option_details.G_gl_period_flag = 'Y')
1482: THEN
1483: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1484: PA_DEBUG.g_err_stage:='Summarization By GL Period';
1485: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1486: END IF;
1487:
1488: INSERT INTO pa_rep_util_summ_tmp
1489: ( record_type,

Line 1579: PA_DEBUG.g_err_stage:='Summarization By GE Period';

1575:
1576: IF (PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag = 'Y')
1577: THEN
1578: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1579: PA_DEBUG.g_err_stage:='Summarization By GE Period';
1580: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1581: END IF;
1582:
1583:

Line 1580: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1576: IF (PA_REP_UTIL_GLOB.G_util_option_details.G_ge_period_flag = 'Y')
1577: THEN
1578: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1579: PA_DEBUG.g_err_stage:='Summarization By GE Period';
1580: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1581: END IF;
1582:
1583:
1584: INSERT INTO pa_rep_util_summ_tmp

Line 1667: PA_DEBUG.Reset_curr_function;

1663: PERSON_ID,ASSIGNMENT_ID,WORK_TYPE_ID,ORG_UTIL_CATEGORY_ID,
1664: RES_UTIL_CATEGORY_ID,EXPENDITURE_TYPE,EXPENDITURE_TYPE_CLASS;
1665: END IF;
1666:
1667: PA_DEBUG.Reset_curr_function;
1668:
1669: EXCEPTION
1670: WHEN OTHERS
1671: THEN

Line 1673: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1669: EXCEPTION
1670: WHEN OTHERS
1671: THEN
1672: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1673: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1674: PA_DEBUG.log_message(SQLERRM);
1675: END IF;
1676: raise;
1677:

Line 1674: PA_DEBUG.log_message(SQLERRM);

1670: WHEN OTHERS
1671: THEN
1672: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1673: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1674: PA_DEBUG.log_message(SQLERRM);
1675: END IF;
1676: raise;
1677:
1678: END summarize_by_period;

Line 1686: PA_DEBUG.set_curr_function('summarize_temp_data_by_res');

1682: BEGIN
1683: /*
1684: * Summarize the lowlevel records to Resource level.
1685: */
1686: PA_DEBUG.set_curr_function('summarize_temp_data_by_res');
1687: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1688: PA_DEBUG.g_err_stage := 'Summarization at resource level';
1689: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1690: END IF;

Line 1688: PA_DEBUG.g_err_stage := 'Summarization at resource level';

1684: * Summarize the lowlevel records to Resource level.
1685: */
1686: PA_DEBUG.set_curr_function('summarize_temp_data_by_res');
1687: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1688: PA_DEBUG.g_err_stage := 'Summarization at resource level';
1689: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1690: END IF;
1691:
1692: INSERT INTO pa_rep_util_summ_tmp

Line 1689: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1685: */
1686: PA_DEBUG.set_curr_function('summarize_temp_data_by_res');
1687: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1688: PA_DEBUG.g_err_stage := 'Summarization at resource level';
1689: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1690: END IF;
1691:
1692: INSERT INTO pa_rep_util_summ_tmp
1693: ( record_type,

Line 1784: PA_DEBUG.Reset_curr_function;

1780: to_char(grouping(res_util_category_id))||
1781: to_char(grouping(work_type_id)))
1782: in ( '111','011', '101', '000');
1783:
1784: PA_DEBUG.Reset_curr_function;
1785:
1786: EXCEPTION
1787: WHEN OTHERS
1788: THEN

Line 1790: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1786: EXCEPTION
1787: WHEN OTHERS
1788: THEN
1789: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1790: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1791: PA_DEBUG.log_message(SQLERRM);
1792: END IF;
1793: raise;
1794: END summarize_temp_data_by_res;

Line 1791: PA_DEBUG.log_message(SQLERRM);

1787: WHEN OTHERS
1788: THEN
1789: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1790: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1791: PA_DEBUG.log_message(SQLERRM);
1792: END IF;
1793: raise;
1794: END summarize_temp_data_by_res;
1795:

Line 1861: PA_DEBUG.set_curr_function('populate_tmp_for_capacity');

1857:
1858: BEGIN
1859:
1860:
1861: PA_DEBUG.set_curr_function('populate_tmp_for_capacity');
1862: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1863: PA_DEBUG.g_err_stage := 'Setting the start and end dates of the run';
1864: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1865: END IF;

Line 1863: PA_DEBUG.g_err_stage := 'Setting the start and end dates of the run';

1859:
1860:
1861: PA_DEBUG.set_curr_function('populate_tmp_for_capacity');
1862: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1863: PA_DEBUG.g_err_stage := 'Setting the start and end dates of the run';
1864: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1865: END IF;
1866: /*
1867: * First figure out which balance_type is the current call for so as

Line 1864: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1860:
1861: PA_DEBUG.set_curr_function('populate_tmp_for_capacity');
1862: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1863: PA_DEBUG.g_err_stage := 'Setting the start and end dates of the run';
1864: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1865: END IF;
1866: /*
1867: * First figure out which balance_type is the current call for so as
1868: * to set the appropriate start and end dates for the run

Line 1879: PA_DEBUG.g_err_stage := 'Opening the Cursor';

1875: l_run_end_date := PA_REP_UTIL_GLOB.G_input_parameters.G_fc_end_date;
1876: END IF;
1877:
1878: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1879: PA_DEBUG.g_err_stage := 'Opening the Cursor';
1880: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1881: END IF;
1882:
1883: OPEN capacity_api_input_cur(l_run_start_date,l_run_end_date);

Line 1880: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1876: END IF;
1877:
1878: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1879: PA_DEBUG.g_err_stage := 'Opening the Cursor';
1880: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1881: END IF;
1882:
1883: OPEN capacity_api_input_cur(l_run_start_date,l_run_end_date);
1884:

Line 1891: PA_DEBUG.g_err_stage := 'Clearing PL/SQL Table';

1887: /*
1888: * Clear all PL/SQL table.
1889: */
1890: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1891: PA_DEBUG.g_err_stage := 'Clearing PL/SQL Table';
1892: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1893: END IF;
1894:
1895: l_in_exp_orgz_tab.delete;

Line 1892: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1888: * Clear all PL/SQL table.
1889: */
1890: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1891: PA_DEBUG.g_err_stage := 'Clearing PL/SQL Table';
1892: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1893: END IF;
1894:
1895: l_in_exp_orgz_tab.delete;
1896: l_in_person_id_tab.delete;

Line 1914: PA_DEBUG.g_err_stage := 'Fetching 100 records at a time in PL/SQL Table';

1910: /*
1911: * Fetch 100 records at a time.
1912: */
1913: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1914: PA_DEBUG.g_err_stage := 'Fetching 100 records at a time in PL/SQL Table';
1915: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1916: END IF;
1917:
1918: FETCH capacity_api_input_cur BULK COLLECT

Line 1915: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1911: * Fetch 100 records at a time.
1912: */
1913: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1914: PA_DEBUG.g_err_stage := 'Fetching 100 records at a time in PL/SQL Table';
1915: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1916: END IF;
1917:
1918: FETCH capacity_api_input_cur BULK COLLECT
1919: INTO l_in_exp_orgz_tab

Line 1958: PA_DEBUG.g_err_stage := 'Calling Capacity API for 100 records at a time';

1954: /*
1955: * Call CV's API in loop get value.
1956: */
1957: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1958: PA_DEBUG.g_err_stage := 'Calling Capacity API for 100 records at a time';
1959: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1960: END IF;
1961:
1962: PA_FORECAST_GRC_PVT.Get_Capacity_Vector(

Line 1959: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1955: * Call CV's API in loop get value.
1956: */
1957: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1958: PA_DEBUG.g_err_stage := 'Calling Capacity API for 100 records at a time';
1959: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1960: END IF;
1961:
1962: PA_FORECAST_GRC_PVT.Get_Capacity_Vector(
1963: p_OU_id => l_exp_org_id

Line 1986: PA_DEBUG.g_err_stage := 'Inserting Records into pa_rep_util_summ_tmp for capacity';

1982: , x_msg_count => l_msg_count
1983: , x_msg_data => l_msg_data);
1984:
1985: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1986: PA_DEBUG.g_err_stage := 'Inserting Records into pa_rep_util_summ_tmp for capacity';
1987: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1988: END IF;
1989:
1990: FORALL I in l_out_person_id_tab.FIRST..l_out_person_id_tab.LAST

Line 1987: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

1983: , x_msg_data => l_msg_data);
1984:
1985: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1986: PA_DEBUG.g_err_stage := 'Inserting Records into pa_rep_util_summ_tmp for capacity';
1987: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
1988: END IF;
1989:
1990: FORALL I in l_out_person_id_tab.FIRST..l_out_person_id_tab.LAST
1991: INSERT INTO pa_rep_util_summ_tmp

Line 2061: PA_DEBUG.g_err_stage := 'Closing the cursor';

2057: END IF;
2058:
2059: END LOOP;
2060: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2061: PA_DEBUG.g_err_stage := 'Closing the cursor';
2062: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2063: END IF;
2064:
2065: CLOSE capacity_api_input_cur;

Line 2062: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2058:
2059: END LOOP;
2060: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2061: PA_DEBUG.g_err_stage := 'Closing the cursor';
2062: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2063: END IF;
2064:
2065: CLOSE capacity_api_input_cur;
2066:

Line 2067: PA_DEBUG.Reset_curr_function;

2063: END IF;
2064:
2065: CLOSE capacity_api_input_cur;
2066:
2067: PA_DEBUG.Reset_curr_function;
2068:
2069: EXCEPTION
2070: WHEN OTHERS
2071: THEN

Line 2073: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2069: EXCEPTION
2070: WHEN OTHERS
2071: THEN
2072: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2073: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2074: PA_DEBUG.log_message(SQLERRM);
2075: END IF;
2076: raise;
2077: END populate_tmp_for_capacity;

Line 2074: PA_DEBUG.log_message(SQLERRM);

2070: WHEN OTHERS
2071: THEN
2072: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2073: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2074: PA_DEBUG.log_message(SQLERRM);
2075: END IF;
2076: raise;
2077: END populate_tmp_for_capacity;
2078:

Line 2086: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.summarize_temp_data_by_org');

2082: */
2083: PROCEDURE summarize_temp_data_by_org
2084: IS
2085: BEGIN
2086: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.summarize_temp_data_by_org');
2087: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2088: PA_DEBUG.g_err_stage := 'Summarizing at Organization level';
2089: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2090: END IF;

Line 2088: PA_DEBUG.g_err_stage := 'Summarizing at Organization level';

2084: IS
2085: BEGIN
2086: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.summarize_temp_data_by_org');
2087: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2088: PA_DEBUG.g_err_stage := 'Summarizing at Organization level';
2089: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2090: END IF;
2091:
2092: INSERT INTO pa_rep_util_summ_tmp

Line 2089: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2085: BEGIN
2086: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.summarize_temp_data_by_org');
2087: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2088: PA_DEBUG.g_err_stage := 'Summarizing at Organization level';
2089: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2090: END IF;
2091:
2092: INSERT INTO pa_rep_util_summ_tmp
2093: ( record_type,

Line 2180: PA_DEBUG.Reset_curr_function;

2176: having ((summ_level_flag = 'S'
2177: and grouping(org_util_category_id)||grouping(work_type_id) = '11')
2178: or ( summ_level_flag = 'R'));
2179:
2180: PA_DEBUG.Reset_curr_function;
2181:
2182: EXCEPTION
2183: WHEN OTHERS
2184: THEN

Line 2186: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2182: EXCEPTION
2183: WHEN OTHERS
2184: THEN
2185: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2186: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2187: PA_DEBUG.log_message(SQLERRM);
2188: END IF;
2189: raise;
2190: END summarize_temp_data_by_org;

Line 2187: PA_DEBUG.log_message(SQLERRM);

2183: WHEN OTHERS
2184: THEN
2185: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2186: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2187: PA_DEBUG.log_message(SQLERRM);
2188: END IF;
2189: raise;
2190: END summarize_temp_data_by_org;
2191:

Line 2201: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.summarize_temp_data_by_org');

2197: PROCEDURE populate_object_entity IS
2198:
2199: BEGIN
2200:
2201: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.summarize_temp_data_by_org');
2202:
2203: /*
2204: * Update the pa_rep_util_summ_tmp with matching object Id.
2205: */

Line 2207: PA_DEBUG.g_err_stage := 'Update pa_rep_util_summ_tmp with matching object Id';

2203: /*
2204: * Update the pa_rep_util_summ_tmp with matching object Id.
2205: */
2206: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2207: PA_DEBUG.g_err_stage := 'Update pa_rep_util_summ_tmp with matching object Id';
2208: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2209: END IF;
2210:
2211: UPDATE pa_rep_util_summ_tmp T

Line 2208: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2204: * Update the pa_rep_util_summ_tmp with matching object Id.
2205: */
2206: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2207: PA_DEBUG.g_err_stage := 'Update pa_rep_util_summ_tmp with matching object Id';
2208: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2209: END IF;
2210:
2211: UPDATE pa_rep_util_summ_tmp T
2212: SET (T.object_id,T.process_mode_flag)

Line 2244: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp with unique key for pa_objects';

2240: /*
2241: * Populate pa_rep_util_summ_tmp with unique key for pa_objects.
2242: */
2243: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2244: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp with unique key for pa_objects';
2245: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2246: END IF;
2247:
2248: INSERT INTO pa_rep_util_summ_tmp

Line 2245: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2241: * Populate pa_rep_util_summ_tmp with unique key for pa_objects.
2242: */
2243: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2244: PA_DEBUG.g_err_stage := 'Populate pa_rep_util_summ_tmp with unique key for pa_objects';
2245: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2246: END IF;
2247:
2248: INSERT INTO pa_rep_util_summ_tmp
2249: ( record_type,

Line 2330: PA_DEBUG.g_err_stage := 'Populate the other records of pa_rep_util_summ_tmp with record type =TMP2 and null object Id';

2326: * Populate the other records of pa_rep_util_summ_tmp with
2327: * record type = 'TMP2' and null object Id.
2328: */
2329: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2330: PA_DEBUG.g_err_stage := 'Populate the other records of pa_rep_util_summ_tmp with record type =TMP2 and null object Id';
2331: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2332: END IF;
2333:
2334: UPDATE pa_rep_util_summ_tmp T1

Line 2331: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2327: * record type = 'TMP2' and null object Id.
2328: */
2329: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2330: PA_DEBUG.g_err_stage := 'Populate the other records of pa_rep_util_summ_tmp with record type =TMP2 and null object Id';
2331: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2332: END IF;
2333:
2334: UPDATE pa_rep_util_summ_tmp T1
2335: SET (T1.object_id ,

Line 2368: PA_DEBUG.g_err_stage := 'Insert New Objects in PA_OBJECTS';

2364: /*
2365: * Insert New Objects in PA_OBJECTS.
2366: */
2367: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2368: PA_DEBUG.g_err_stage := 'Insert New Objects in PA_OBJECTS';
2369: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2370: END IF;
2371:
2372: INSERT INTO PA_OBJECTS

Line 2369: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2365: * Insert New Objects in PA_OBJECTS.
2366: */
2367: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2368: PA_DEBUG.g_err_stage := 'Insert New Objects in PA_OBJECTS';
2369: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2370: END IF;
2371:
2372: INSERT INTO PA_OBJECTS
2373: ( OBJECT_ID,

Line 2430: PA_DEBUG.Reset_curr_function;

2426: AND process_mode_flag = 'HH'
2427: AND object_type_code <> l_utildet_c
2428: ;
2429:
2430: PA_DEBUG.Reset_curr_function;
2431:
2432: EXCEPTION
2433: WHEN OTHERS
2434: THEN

Line 2436: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2432: EXCEPTION
2433: WHEN OTHERS
2434: THEN
2435: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2436: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2437: PA_DEBUG.log_message(SQLERRM);
2438: END IF;
2439: raise;
2440: END populate_object_entity;

Line 2437: PA_DEBUG.log_message(SQLERRM);

2433: WHEN OTHERS
2434: THEN
2435: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2436: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2437: PA_DEBUG.log_message(SQLERRM);
2438: END IF;
2439: raise;
2440: END populate_object_entity;
2441:

Line 2512: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.populate_balance_entity');

2508: rec_update_bal cur_update_bal%ROWTYPE;
2509:
2510: BEGIN
2511:
2512: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.populate_balance_entity');
2513:
2514: /*
2515: * Update the global temporary table for successful update.
2516: */

Line 2518: PA_DEBUG.g_err_stage := 'Update the global temporary table for successful update1';

2514: /*
2515: * Update the global temporary table for successful update.
2516: */
2517: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2518: PA_DEBUG.g_err_stage := 'Update the global temporary table for successful update1';
2519: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2520: END IF;
2521:
2522: UPDATE pa_rep_util_summ_tmp B

Line 2519: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2515: * Update the global temporary table for successful update.
2516: */
2517: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2518: PA_DEBUG.g_err_stage := 'Update the global temporary table for successful update1';
2519: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2520: END IF;
2521:
2522: UPDATE pa_rep_util_summ_tmp B
2523: SET B.process_mode_flag = 'U'

Line 2548: PA_DEBUG.g_err_stage := 'Clearing PL/SQL Table';

2544: /*
2545: * Clear all PL/SQL table.
2546: */
2547: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2548: PA_DEBUG.g_err_stage := 'Clearing PL/SQL Table';
2549: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2550: END IF;
2551:
2552: L_PERIOD_BALANCE_TAB.delete;

Line 2549: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2545: * Clear all PL/SQL table.
2546: */
2547: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2548: PA_DEBUG.g_err_stage := 'Clearing PL/SQL Table';
2549: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2550: END IF;
2551:
2552: L_PERIOD_BALANCE_TAB.delete;
2553: L_OBJECT_ID_TAB.delete;

Line 2569: PA_DEBUG.g_err_stage := 'Update the balance entity for existing records of pa_rep_util_summ_tmp marked for update';

2565: * Update the balance entity for existing records of pa_rep_util_summ_tmp
2566: * marked for update.
2567: */
2568: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2569: PA_DEBUG.g_err_stage := 'Update the balance entity for existing records of pa_rep_util_summ_tmp marked for update';
2570: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2571: END IF;
2572:
2573: IF cur_update_bal%ISOPEN then

Line 2570: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2566: * marked for update.
2567: */
2568: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2569: PA_DEBUG.g_err_stage := 'Update the balance entity for existing records of pa_rep_util_summ_tmp marked for update';
2570: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2571: END IF;
2572:
2573: IF cur_update_bal%ISOPEN then
2574: CLOSE cur_update_bal;

Line 2595: PA_DEBUG.g_err_stage := 'Records totally fetched from cur_update_bal'||l_totally_fetched||L_PERIOD_BALANCE_TAB.COUNT;

2591: , L_AMOUNT_TYPE_ID_TAB
2592: ;
2593: l_totally_fetched := cur_update_bal%ROWCOUNT;
2594: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2595: PA_DEBUG.g_err_stage := 'Records totally fetched from cur_update_bal'||l_totally_fetched||L_PERIOD_BALANCE_TAB.COUNT;
2596: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
2597: PA_DEBUG.g_err_stage := 'Before updating PA_SUMM_BALANCES from cur_update_bal';
2598: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
2599: END IF;

Line 2596: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

2592: ;
2593: l_totally_fetched := cur_update_bal%ROWCOUNT;
2594: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2595: PA_DEBUG.g_err_stage := 'Records totally fetched from cur_update_bal'||l_totally_fetched||L_PERIOD_BALANCE_TAB.COUNT;
2596: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
2597: PA_DEBUG.g_err_stage := 'Before updating PA_SUMM_BALANCES from cur_update_bal';
2598: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
2599: END IF;
2600:

Line 2597: PA_DEBUG.g_err_stage := 'Before updating PA_SUMM_BALANCES from cur_update_bal';

2593: l_totally_fetched := cur_update_bal%ROWCOUNT;
2594: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2595: PA_DEBUG.g_err_stage := 'Records totally fetched from cur_update_bal'||l_totally_fetched||L_PERIOD_BALANCE_TAB.COUNT;
2596: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
2597: PA_DEBUG.g_err_stage := 'Before updating PA_SUMM_BALANCES from cur_update_bal';
2598: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
2599: END IF;
2600:
2601:

Line 2598: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);

2594: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2595: PA_DEBUG.g_err_stage := 'Records totally fetched from cur_update_bal'||l_totally_fetched||L_PERIOD_BALANCE_TAB.COUNT;
2596: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
2597: PA_DEBUG.g_err_stage := 'Before updating PA_SUMM_BALANCES from cur_update_bal';
2598: PA_DEBUG.Log_Message( p_message => PA_DEBUG.g_err_stage);
2599: END IF;
2600:
2601:
2602: IF L_PERIOD_BALANCE_TAB.COUNT > 0 then

Line 2632: PA_DEBUG.g_err_stage := 'Insert new balance records from pa_rep_util_summ_tmp if needed.';

2628: /*
2629: * Insert new balance records from pa_rep_util_summ_tmp if needed.
2630: */
2631: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2632: PA_DEBUG.g_err_stage := 'Insert new balance records from pa_rep_util_summ_tmp if needed.';
2633: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2634: END IF;
2635:
2636: INSERT INTO pa_summ_balances

Line 2633: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2629: * Insert new balance records from pa_rep_util_summ_tmp if needed.
2630: */
2631: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2632: PA_DEBUG.g_err_stage := 'Insert new balance records from pa_rep_util_summ_tmp if needed.';
2633: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2634: END IF;
2635:
2636: INSERT INTO pa_summ_balances
2637: ( OBJECT_ID,

Line 2675: PA_DEBUG.Reset_curr_function;

2671: AND object_type_code <> l_utildet_c
2672: GROUP BY OBJECT_ID, PERIOD_TYPE, PERIOD_NAME,
2673: GLOBAL_EXP_PERIOD_END_DATE, AMOUNT_TYPE_ID;
2674:
2675: PA_DEBUG.Reset_curr_function;
2676:
2677: EXCEPTION
2678: WHEN OTHERS
2679: THEN

Line 2681: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2677: EXCEPTION
2678: WHEN OTHERS
2679: THEN
2680: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2681: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2682: PA_DEBUG.log_message(SQLERRM);
2683: END IF;
2684: raise;
2685: END populate_balance_entity;

Line 2682: PA_DEBUG.log_message(SQLERRM);

2678: WHEN OTHERS
2679: THEN
2680: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2681: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2682: PA_DEBUG.log_message(SQLERRM);
2683: END IF;
2684: raise;
2685: END populate_balance_entity;
2686:

Line 2725: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.populate_incremental_rollup');

2721:
2722:
2723: BEGIN
2724:
2725: PA_DEBUG.set_curr_function('PA_REP_UTILS_SUMM_PKG.populate_incremental_rollup');
2726:
2727: /*
2728: * populate PA_REP_UTIL_SUMM_TMP for total hours.
2729: */

Line 2731: PA_DEBUG.g_err_stage := 'populate PA_REP_UTIL_SUMM_TMP for total hours';

2727: /*
2728: * populate PA_REP_UTIL_SUMM_TMP for total hours.
2729: */
2730: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2731: PA_DEBUG.g_err_stage := 'populate PA_REP_UTIL_SUMM_TMP for total hours';
2732: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2733: END IF;
2734:
2735: INSERT INTO pa_rep_util_summ_tmp

Line 2732: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2728: * populate PA_REP_UTIL_SUMM_TMP for total hours.
2729: */
2730: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2731: PA_DEBUG.g_err_stage := 'populate PA_REP_UTIL_SUMM_TMP for total hours';
2732: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2733: END IF;
2734:
2735: INSERT INTO pa_rep_util_summ_tmp
2736: ( record_type,

Line 2816: PA_DEBUG.Reset_curr_function;

2812: and ((dummytab.dummy_col = 'S'
2813: and org.child_organization_id <> org.parent_organization_id)
2814: or (dummytab.dummy_col = 'T'));
2815:
2816: PA_DEBUG.Reset_curr_function;
2817:
2818: EXCEPTION
2819: WHEN OTHERS
2820: THEN

Line 2822: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2818: EXCEPTION
2819: WHEN OTHERS
2820: THEN
2821: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2822: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2823: PA_DEBUG.log_message(SQLERRM);
2824: END IF;
2825: raise;
2826: END populate_incremental_rollup;

Line 2823: PA_DEBUG.log_message(SQLERRM);

2819: WHEN OTHERS
2820: THEN
2821: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2822: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2823: PA_DEBUG.log_message(SQLERRM);
2824: END IF;
2825: raise;
2826: END populate_incremental_rollup;
2827:

Line 2834: PA_DEBUG.set_curr_function('populate_summ_entity');

2830: IS
2831:
2832: BEGIN
2833:
2834: PA_DEBUG.set_curr_function('populate_summ_entity');
2835:
2836: /*
2837: * Assign P_Balance_Type_Code to package variable for future use.
2838: */

Line 2846: PA_DEBUG.g_err_stage := 'Summarize the Data by Period ';

2842: * Assign p_process_method to package variable for future use.
2843: */
2844: l_delete_flag := p_process_method;
2845: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2846: PA_DEBUG.g_err_stage := 'Summarize the Data by Period ';
2847: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2848: END IF;
2849: /*
2850: * Summarize the data period wise from Global PL/SQL Table and

Line 2847: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2843: */
2844: l_delete_flag := p_process_method;
2845: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2846: PA_DEBUG.g_err_stage := 'Summarize the Data by Period ';
2847: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2848: END IF;
2849: /*
2850: * Summarize the data period wise from Global PL/SQL Table and
2851: * populate global temprary table with periodwise summarized data.

Line 2863: PA_DEBUG.g_err_stage := 'Summarize the Data by Object Type ';

2859: * Call the actual procedure to summarize data from global temporary
2860: * table.
2861: */
2862: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2863: PA_DEBUG.g_err_stage := 'Summarize the Data by Object Type ';
2864: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2865: END IF;
2866:
2867: summarize_temp_data_by_res;

Line 2864: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2860: * table.
2861: */
2862: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2863: PA_DEBUG.g_err_stage := 'Summarize the Data by Object Type ';
2864: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2865: END IF;
2866:
2867: summarize_temp_data_by_res;
2868:

Line 2882: PA_DEBUG.g_err_stage := 'Processing Incremental Rollup';

2878: */
2879: IF (l_org_rollup_method = 'I')
2880: THEN
2881: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2882: PA_DEBUG.g_err_stage := 'Processing Incremental Rollup';
2883: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2884: END IF;
2885: populate_incremental_rollup;
2886: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 2883: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2879: IF (l_org_rollup_method = 'I')
2880: THEN
2881: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2882: PA_DEBUG.g_err_stage := 'Processing Incremental Rollup';
2883: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2884: END IF;
2885: populate_incremental_rollup;
2886: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2887: PA_DEBUG.g_err_stage := 'After Processing Incremental Rollup';

Line 2887: PA_DEBUG.g_err_stage := 'After Processing Incremental Rollup';

2883: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2884: END IF;
2885: populate_incremental_rollup;
2886: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2887: PA_DEBUG.g_err_stage := 'After Processing Incremental Rollup';
2888: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2889: END IF;
2890:
2891: END IF;

Line 2888: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2884: END IF;
2885: populate_incremental_rollup;
2886: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2887: PA_DEBUG.g_err_stage := 'After Processing Incremental Rollup';
2888: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2889: END IF;
2890:
2891: END IF;
2892:

Line 2898: PA_DEBUG.g_err_stage := 'Before calling populate_object_entity';

2894: * Populate the object entity from pa_rep_util_summ_tmp
2895: * for record_type='TMP2'.
2896: */
2897: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2898: PA_DEBUG.g_err_stage := 'Before calling populate_object_entity';
2899: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2900: END IF;
2901:
2902: populate_object_entity;

Line 2899: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2895: * for record_type='TMP2'.
2896: */
2897: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2898: PA_DEBUG.g_err_stage := 'Before calling populate_object_entity';
2899: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2900: END IF;
2901:
2902: populate_object_entity;
2903:

Line 2909: PA_DEBUG.g_err_stage := 'Before calling populate_balance_entity';

2905: * Populate the balance entity from pa_rep_util_summ_tmp
2906: * for record_type='TMP2'.
2907: */
2908: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2909: PA_DEBUG.g_err_stage := 'Before calling populate_balance_entity';
2910: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2911: END IF;
2912:
2913: populate_balance_entity;

Line 2910: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2906: * for record_type='TMP2'.
2907: */
2908: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2909: PA_DEBUG.g_err_stage := 'Before calling populate_balance_entity';
2910: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2911: END IF;
2912:
2913: populate_balance_entity;
2914:

Line 2916: PA_DEBUG.g_err_stage := 'After calling populate_balance_entity';

2912:
2913: populate_balance_entity;
2914:
2915: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2916: PA_DEBUG.g_err_stage := 'After calling populate_balance_entity';
2917: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2918: END IF;
2919:
2920: PA_DEBUG.Reset_curr_function;

Line 2917: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2913: populate_balance_entity;
2914:
2915: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2916: PA_DEBUG.g_err_stage := 'After calling populate_balance_entity';
2917: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2918: END IF;
2919:
2920: PA_DEBUG.Reset_curr_function;
2921:

Line 2920: PA_DEBUG.Reset_curr_function;

2916: PA_DEBUG.g_err_stage := 'After calling populate_balance_entity';
2917: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2918: END IF;
2919:
2920: PA_DEBUG.Reset_curr_function;
2921:
2922: EXCEPTION
2923: WHEN OTHERS
2924: THEN

Line 2926: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);

2922: EXCEPTION
2923: WHEN OTHERS
2924: THEN
2925: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2926: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2927: PA_DEBUG.log_message(SQLERRM);
2928: END IF;
2929: raise;
2930:

Line 2927: PA_DEBUG.log_message(SQLERRM);

2923: WHEN OTHERS
2924: THEN
2925: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2926: PA_DEBUG.log_message(PA_DEBUG.g_err_stage);
2927: PA_DEBUG.log_message(SQLERRM);
2928: END IF;
2929: raise;
2930:
2931: END populate_summ_entity;