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_ACCUM_UTILS dependencies on PA_DEBUG

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

25: V_accum_id Number := 0;
26: V_prev_accum_period Varchar2(30);
27: v_current_period Varchar2(30);
28: V_Old_Stack Varchar2(630);
29: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
30: Begin
31: V_Old_Stack := x_err_stack;
32: x_err_stack :=
33: x_err_stack||'->PA_ACCUM_UTILS.Proj_level_record';

Line 36: pa_debug.debug('Proj_level_record: ' || x_err_stack);

32: x_err_stack :=
33: x_err_stack||'->PA_ACCUM_UTILS.Proj_level_record';
34:
35: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
36: pa_debug.debug('Proj_level_record: ' || x_err_stack);
37: END IF;
38:
39: -- Check whether Implementation option is PA or GL , based on which the
40: -- current period is set

Line 75: pa_debug.debug('Proj_level_record: ' || 'Creating Project Level Header Record');

71:
72: WHEN NO_DATA_FOUND THEN
73:
74: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
75: pa_debug.debug('Proj_level_record: ' || 'Creating Project Level Header Record');
76: END IF;
77:
78: SELECT PA_PROJECT_ACCUM_HEADERS_S.Nextval
79: INTO V_accum_id

Line 113: pa_debug.debug('Proj_level_record: ' || 'Creating Project Level Header record for Actuals');

109: pa_proj_accum_main.x_last_update_login );
110: -- Create Actuals record for the Project level record
111:
112: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
113: pa_debug.debug('Proj_level_record: ' || 'Creating Project Level Header record for Actuals');
114: END IF;
115:
116: INSERT INTO PA_PROJECT_ACCUM_ACTUALS (
117: PROJECT_ACCUM_ID,RAW_COST_ITD,RAW_COST_YTD,RAW_COST_PP,RAW_COST_PTD,

Line 138: pa_debug.debug('Proj_level_record: ' || 'Creating Project Level Header record for Commitments');

134:
135: -- Create commitments record for the Project level record
136:
137: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
138: pa_debug.debug('Proj_level_record: ' || 'Creating Project Level Header record for Commitments');
139: END IF;
140:
141: INSERT INTO PA_PROJECT_ACCUM_COMMITMENTS (
142: PROJECT_ACCUM_ID,CMT_RAW_COST_ITD,CMT_RAW_COST_YTD,CMT_RAW_COST_PP,

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

166: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
167:
168:
169: V_Old_Stack Varchar2(630);
170: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
171: Begin
172: V_Old_Stack := x_err_stack;
173: x_err_stack :=
174: x_err_stack||'->PA_ACCUM_UTILS.Get_Impl_Option';

Line 177: pa_debug.debug('Get_Impl_Option: ' || x_err_stack);

173: x_err_stack :=
174: x_err_stack||'->PA_ACCUM_UTILS.Get_Impl_Option';
175:
176: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
177: pa_debug.debug('Get_Impl_Option: ' || x_err_stack);
178: END IF;
179:
180: SELECT accumulation_period_type
181: INTO x_impl_option

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

204: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
205: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
206:
207: V_Old_Stack Varchar2(630);
208: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
209: Begin
210: V_Old_Stack := x_err_stack;
211: x_err_stack :=
212: x_err_stack||'->PA_ACCUM_UTILS.Get_Current_period_Info';

Line 215: pa_debug.debug('Get_Current_period_Info: ' || x_err_stack);

211: x_err_stack :=
212: x_err_stack||'->PA_ACCUM_UTILS.Get_Current_period_Info';
213:
214: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
215: pa_debug.debug('Get_Current_period_Info: ' || x_err_stack);
216: END IF;
217: /* Commented out for the bug#2634995
218: SELECT
219: period_name,

Line 271: pa_debug.debug('Get_Current_period_Info: ' || 'REPORTING PERIOD NOT SET*',pa_debug.DEBUG_LEVEL_EXCEPTION);

267:
268: Exception
269: WHEN NO_DATA_FOUND THEN
270: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
271: pa_debug.debug('Get_Current_period_Info: ' || '****REPORTING PERIOD NOT SET*****',pa_debug.DEBUG_LEVEL_EXCEPTION);
272: pa_debug.debug('Get_Current_period_Info: ' || '****SET REPORTING PERIOD AND RE-RUN PROCESS *****',pa_debug.DEBUG_LEVEL_EXCEPTION);
273: END IF;
274: x_err_code := SQLCODE;
275: RAISE;

Line 272: pa_debug.debug('Get_Current_period_Info: ' || 'SET REPORTING PERIOD AND RE-RUN PROCESS *',pa_debug.DEBUG_LEVEL_EXCEPTION);

268: Exception
269: WHEN NO_DATA_FOUND THEN
270: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
271: pa_debug.debug('Get_Current_period_Info: ' || '****REPORTING PERIOD NOT SET*****',pa_debug.DEBUG_LEVEL_EXCEPTION);
272: pa_debug.debug('Get_Current_period_Info: ' || '****SET REPORTING PERIOD AND RE-RUN PROCESS *****',pa_debug.DEBUG_LEVEL_EXCEPTION);
273: END IF;
274: x_err_code := SQLCODE;
275: RAISE;
276: WHEN OTHERS THEN

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

309: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
310: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
311:
312: V_Old_Stack Varchar2(630);
313: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
314: BEGIN
315: V_Old_Stack := x_err_stack;
316: x_err_stack :=
317: x_err_stack||'->PA_ACCUM_UTILS.Get_pa_period_Info';

Line 323: pa_debug.debug('Get_pa_period_Info: ' || x_err_stack);

319:
320: -- Select the details pertaining to the previous pa period.
321:
322: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
323: pa_debug.debug('Get_pa_period_Info: ' || x_err_stack);
324: END IF;
325:
326: <>
327: BEGIN

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

466: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
467: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
468:
469: V_Old_Stack Varchar2(630);
470: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
471: BEGIN
472: V_Old_Stack := x_err_stack;
473: x_err_stack :=
474: x_err_stack||'->PA_ACCUM_UTILS.Get_period_year_Info';

Line 477: pa_debug.debug('Get_period_year_info: ' || x_err_stack);

473: x_err_stack :=
474: x_err_stack||'->PA_ACCUM_UTILS.Get_period_year_Info';
475:
476: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
477: pa_debug.debug('Get_period_year_info: ' || x_err_stack);
478: END IF;
479:
480: -- Get the period year start date
481:

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

980: and Accum_Category_Code = x_Accum_category_code
981: and Accum_Column_Code = x_Accum_column_code ;
982:
983: V_old_stack Varchar2(630);
984: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
985: Begin
986: x_err_code := 0;
987: x_Accum_flag := NULL;
988: v_old_stack := x_err_stack;

Line 993: pa_debug.debug('Get_Config_Option: ' || x_err_stack);

989: x_err_stack := x_err_stack || '->PA_ACCUM_UTILS.Get_config_Option ';
990: x_err_stage := ' Select Project_Type_class_code ';
991:
992: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
993: pa_debug.debug('Get_Config_Option: ' || x_err_stack);
994: END IF;
995:
996: Open Get_Project_type_class_cur;
997: Fetch Get_Project_type_class_cur into v_project_type_class_code;

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

1090: x_err_stage IN OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
1091: x_err_code IN OUT NOCOPY Number ) IS --File.Sql.39 bug 4440895
1092:
1093: V_old_stack Varchar2(630);
1094: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
1095:
1096: Begin
1097: V_Old_Stack := x_err_stack;
1098: x_err_code := 0;

Line 1103: pa_debug.debug('update_proj_accum_header: ' || x_err_stack);

1099: x_err_stack :=
1100: x_err_stack||'->PA_ACCUM_UTILS.update_proj_accum_header';
1101:
1102: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1103: pa_debug.debug('update_proj_accum_header: ' || x_err_stack);
1104: END IF;
1105:
1106: -- update the accum_period to current period
1107:

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

1132: x_err_stage IN OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
1133: x_err_code IN OUT NOCOPY Number ) IS --File.Sql.39 bug 4440895
1134:
1135: V_old_stack Varchar2(630);
1136: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
1137: Begin
1138: V_Old_Stack := x_err_stack;
1139: x_err_code := 0;
1140: x_err_stack :=

Line 1144: pa_debug.debug('update_tasks_restructured_flag: ' || x_err_stack);

1140: x_err_stack :=
1141: x_err_stack||'->PA_ACCUM_UTILS.update_tasks_restructured_flag';
1142:
1143: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1144: pa_debug.debug('update_tasks_restructured_flag: ' || x_err_stack);
1145: END IF;
1146:
1147: -- update the accum_period to current period
1148:

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

1173: x_err_stage IN OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
1174: x_err_code IN OUT NOCOPY Number ) IS --File.Sql.39 bug 4440895
1175:
1176: V_old_stack Varchar2(630);
1177: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
1178: Begin
1179: V_Old_Stack := x_err_stack;
1180: x_err_code := 0;
1181: x_err_stack :=

Line 1185: pa_debug.debug('check_tasks_restructured_flag: ' || x_err_stack);

1181: x_err_stack :=
1182: x_err_stack||'->PA_ACCUM_UTILS.check_tasks_restructured_flag';
1183:
1184: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1185: pa_debug.debug('check_tasks_restructured_flag: ' || x_err_stack);
1186: END IF;
1187:
1188: -- Select the accum_period to current period
1189: SELECT

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

1492: END get_check_reporting_end_date;
1493:
1494:
1495: Procedure Set_current_period_Info IS
1496: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
1497: Begin
1498: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1499: pa_debug.debug('pa_accum_utils.set_current_period_info');
1500: END IF;

Line 1499: pa_debug.debug('pa_accum_utils.set_current_period_info');

1495: Procedure Set_current_period_Info IS
1496: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N'); /* Added Debug Profile Option variable initialization for bug#2674619 */
1497: Begin
1498: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1499: pa_debug.debug('pa_accum_utils.set_current_period_info');
1500: END IF;
1501:
1502: SELECT
1503: period_name,

Line 1515: pa_debug.debug('Data not found to set g_current_pa_period and g_current

1511:
1512: Exception
1513: WHEN NO_DATA_FOUND THEN
1514: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1515: pa_debug.debug('Data not found to set g_current_pa_period and g_current
1516: _gl_period',PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1517: END IF;
1518: RAISE;
1519: WHEN OTHERS THEN

Line 1516: _gl_period',PA_DEBUG.DEBUG_LEVEL_EXCEPTION);

1512: Exception
1513: WHEN NO_DATA_FOUND THEN
1514: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
1515: pa_debug.debug('Data not found to set g_current_pa_period and g_current
1516: _gl_period',PA_DEBUG.DEBUG_LEVEL_EXCEPTION);
1517: END IF;
1518: RAISE;
1519: WHEN OTHERS THEN
1520: RAISE;

Line 1775: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1771: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
1772: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
1773:
1774: V_Old_Stack Varchar2(630);
1775: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1776: BEGIN
1777: V_Old_Stack := x_err_stack;
1778: x_err_stack :=
1779: x_err_stack||'->PA_ACCUM_UTILS.Get_pa_period_Info1';

Line 1784: pa_debug.debug('Get_pa_period_Info1: ' || x_err_stack);

1780:
1781: -- Select the details pertaining to the previous pa period.
1782:
1783: IF P_DEBUG_MODE = 'Y' THEN
1784: pa_debug.debug('Get_pa_period_Info1: ' || x_err_stack);
1785: END IF;
1786:
1787: <>
1788: BEGIN

Line 1877: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1873: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
1874: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
1875:
1876: V_Old_Stack Varchar2(630);
1877: P_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
1878: BEGIN
1879: V_Old_Stack := x_err_stack;
1880: x_err_stack :=
1881: x_err_stack||'->PA_ACCUM_UTILS.Get_pa_period_Info2';

Line 1885: pa_debug.debug('Get_pa_period_Info2: ' || x_err_stack);

1881: x_err_stack||'->PA_ACCUM_UTILS.Get_pa_period_Info2';
1882: x_accum_period_type_changed := FALSE;
1883:
1884: IF P_DEBUG_MODE = 'Y' THEN
1885: pa_debug.debug('Get_pa_period_Info2: ' || x_err_stack);
1886: END IF;
1887:
1888: BEGIN
1889: