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

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

3:
4:
5: g_package_name VARCHAR2(100) := 'PJI_FM_PLAN_MAINT_T_PVT';
6: g_module_name VARCHAR2(100) := 'pji.plsql.PJI_FM_PLAN_MAINT_PVT';
7: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
8:
9: g_prorating_format VARCHAR2(30) := 'S';
10: -- S Start date, E End date, D (daily) Period.
11: -- Based on plan version.

Line 1406: IF P_PA_DEBUG_MODE = 'Y' THEN

1402:
1403: print_time('EXTRACT_PLAN_AMOUNTS_PRIRBS : Begin' );
1404: print_time('EXTRACT_PLAN_AMOUNTS_PRIRBS : Begin worker id is ... ' || 1);
1405:
1406: IF P_PA_DEBUG_MODE = 'Y' THEN
1407: pa_debug.write('EXTRACT_PLAN_AMOUNTS_PRIRBS: ' || g_module_name,'Inside EXTRACT_PLAN_AMOUNTS_PRIRBS' ,1);
1408: END IF;
1409: /* Added for bug 8708651
1410: l_per_analysis_flag := PJI_UTILS.GET_SETUP_PARAMETER('PER_ANALYSIS_FLAG');

Line 1407: pa_debug.write('EXTRACT_PLAN_AMOUNTS_PRIRBS: ' || g_module_name,'Inside EXTRACT_PLAN_AMOUNTS_PRIRBS' ,1);

1403: print_time('EXTRACT_PLAN_AMOUNTS_PRIRBS : Begin' );
1404: print_time('EXTRACT_PLAN_AMOUNTS_PRIRBS : Begin worker id is ... ' || 1);
1405:
1406: IF P_PA_DEBUG_MODE = 'Y' THEN
1407: pa_debug.write('EXTRACT_PLAN_AMOUNTS_PRIRBS: ' || g_module_name,'Inside EXTRACT_PLAN_AMOUNTS_PRIRBS' ,1);
1408: END IF;
1409: /* Added for bug 8708651
1410: l_per_analysis_flag := PJI_UTILS.GET_SETUP_PARAMETER('PER_ANALYSIS_FLAG');
1411: Commented for bug 9048716 */

Line 1915: IF P_PA_DEBUG_MODE = 'Y' THEN

1911: , plr.plan_type_id
1912: , DECODE(vers.time_phased_type_code, g_pa_cal_str, 'OF', g_gl_cal_str, 'OF', 'N', 'NTP', 'X')
1913: , plr.plan_type_code; /* 4471527 */
1914:
1915: IF P_PA_DEBUG_MODE = 'Y' THEN
1916: pa_debug.write('EXTRACT_PLAN_AMOUNTS_PRIRBS: ' || g_module_name,'EXTRACT_PLAN_AMOUNTS_PRIRBS count : '||SQL%ROWCOUNT ,1);
1917: END IF;
1918: -- cbs change
1919: UPDATE PJI_FM_EXTR_PLNVER3_T t

Line 1916: pa_debug.write('EXTRACT_PLAN_AMOUNTS_PRIRBS: ' || g_module_name,'EXTRACT_PLAN_AMOUNTS_PRIRBS count : '||SQL%ROWCOUNT ,1);

1912: , DECODE(vers.time_phased_type_code, g_pa_cal_str, 'OF', g_gl_cal_str, 'OF', 'N', 'NTP', 'X')
1913: , plr.plan_type_code; /* 4471527 */
1914:
1915: IF P_PA_DEBUG_MODE = 'Y' THEN
1916: pa_debug.write('EXTRACT_PLAN_AMOUNTS_PRIRBS: ' || g_module_name,'EXTRACT_PLAN_AMOUNTS_PRIRBS count : '||SQL%ROWCOUNT ,1);
1917: END IF;
1918: -- cbs change
1919: UPDATE PJI_FM_EXTR_PLNVER3_T t
1920: SET worker_id = null

Line 1981: IF P_PA_DEBUG_MODE = 'Y' THEN

1977: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
1978: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
1979:
1980: -- cbs change -- Bug 13736073
1981: IF P_PA_DEBUG_MODE = 'Y' THEN
1982: pa_debug.write('EXTRACT_PLAN_AMTS_SECRBS_GLC12: ' || g_module_name,'Before calling SET_RES_CLASS_FLAG' ,1);
1983: END IF;
1984:
1985: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;

Line 1982: pa_debug.write('EXTRACT_PLAN_AMTS_SECRBS_GLC12: ' || g_module_name,'Before calling SET_RES_CLASS_FLAG' ,1);

1978: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
1979:
1980: -- cbs change -- Bug 13736073
1981: IF P_PA_DEBUG_MODE = 'Y' THEN
1982: pa_debug.write('EXTRACT_PLAN_AMTS_SECRBS_GLC12: ' || g_module_name,'Before calling SET_RES_CLASS_FLAG' ,1);
1983: END IF;
1984:
1985: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;
1986:

Line 1987: IF P_PA_DEBUG_MODE = 'Y' THEN

1983: END IF;
1984:
1985: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;
1986:
1987: IF P_PA_DEBUG_MODE = 'Y' THEN
1988: pa_debug.write('EXTRACT_PLAN_AMTS_SECRBS_GLC12: ' || g_module_name,'After calling SET_RES_CLASS_FLAG' ,1);
1989: END IF;
1990: -- End cbs change
1991:

Line 1988: pa_debug.write('EXTRACT_PLAN_AMTS_SECRBS_GLC12: ' || g_module_name,'After calling SET_RES_CLASS_FLAG' ,1);

1984:
1985: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;
1986:
1987: IF P_PA_DEBUG_MODE = 'Y' THEN
1988: pa_debug.write('EXTRACT_PLAN_AMTS_SECRBS_GLC12: ' || g_module_name,'After calling SET_RES_CLASS_FLAG' ,1);
1989: END IF;
1990: -- End cbs change
1991:
1992: INSERT INTO PJI_FP_AGGR_PJP1_T

Line 3046: IF P_PA_DEBUG_MODE = 'Y' THEN

3042: print_time(' g_currency_conversion_rule ' || g_currency_conversion_rule || ' g_prorating_format ' || g_prorating_format );
3043: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
3044: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
3045: -- cbs change -- Bug 13736073
3046: IF P_PA_DEBUG_MODE = 'Y' THEN
3047: pa_debug.write('EXTRACT_PLAN_AMTS_PRIRBS_GLC12: ' || g_module_name,'Before calling SET_RES_CLASS_FLAG' ,1);
3048: END IF;
3049:
3050: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;

Line 3047: pa_debug.write('EXTRACT_PLAN_AMTS_PRIRBS_GLC12: ' || g_module_name,'Before calling SET_RES_CLASS_FLAG' ,1);

3043: print_time(' g_global1_currency_code ' || g_global1_currency_code || ' g_global2_currency_code ' || g_global2_currency_code );
3044: print_time(' g_global1_currency_mau ' || g_global1_currency_mau || ' g_global2_currency_mau ' || g_global2_currency_mau ) ;
3045: -- cbs change -- Bug 13736073
3046: IF P_PA_DEBUG_MODE = 'Y' THEN
3047: pa_debug.write('EXTRACT_PLAN_AMTS_PRIRBS_GLC12: ' || g_module_name,'Before calling SET_RES_CLASS_FLAG' ,1);
3048: END IF;
3049:
3050: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;
3051:

Line 3052: IF P_PA_DEBUG_MODE = 'Y' THEN

3048: END IF;
3049:
3050: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;
3051:
3052: IF P_PA_DEBUG_MODE = 'Y' THEN
3053: pa_debug.write('EXTRACT_PLAN_AMTS_PRIRBS_GLC12: ' || g_module_name,'After calling SET_RES_CLASS_FLAG' ,1);
3054: END IF;
3055: -- End cbs change
3056:

Line 3053: pa_debug.write('EXTRACT_PLAN_AMTS_PRIRBS_GLC12: ' || g_module_name,'After calling SET_RES_CLASS_FLAG' ,1);

3049:
3050: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;
3051:
3052: IF P_PA_DEBUG_MODE = 'Y' THEN
3053: pa_debug.write('EXTRACT_PLAN_AMTS_PRIRBS_GLC12: ' || g_module_name,'After calling SET_RES_CLASS_FLAG' ,1);
3054: END IF;
3055: -- End cbs change
3056:
3057: INSERT INTO PJI_FP_AGGR_PJP1_T

Line 4541: IF P_PA_DEBUG_MODE = 'Y' THEN

4537: Commented for bug 9048716*/
4538:
4539: print_time('........RETRIEVE_DELTA_SLICE : Begin.' );
4540:
4541: IF P_PA_DEBUG_MODE = 'Y' THEN
4542: pa_debug.write('RETRIEVE_DELTA_SLICE: ' || g_module_name,'Inside RETRIEVE_DELTA_SLICE' ,1);
4543: END IF;
4544:
4545: INSERT_NTP_CAL_RECORD ( x_max_plnver_id => l_max_plnver_id );

Line 4542: pa_debug.write('RETRIEVE_DELTA_SLICE: ' || g_module_name,'Inside RETRIEVE_DELTA_SLICE' ,1);

4538:
4539: print_time('........RETRIEVE_DELTA_SLICE : Begin.' );
4540:
4541: IF P_PA_DEBUG_MODE = 'Y' THEN
4542: pa_debug.write('RETRIEVE_DELTA_SLICE: ' || g_module_name,'Inside RETRIEVE_DELTA_SLICE' ,1);
4543: END IF;
4544:
4545: INSERT_NTP_CAL_RECORD ( x_max_plnver_id => l_max_plnver_id );
4546:

Line 7374: IF P_PA_DEBUG_MODE = 'Y' THEN

7370: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;
7371:
7372: BEGIN
7373:
7374: IF P_PA_DEBUG_MODE = 'Y' THEN
7375: pa_debug.write('UPDATE_FP_ROWS: ' || g_module_name,'UPDATE_FP_ROWS ',1);
7376: END IF;
7377: UPDATE /*+ ordered use_nl(rl) rowid(rl) */
7378: pji_fp_xbs_accum_f rl

Line 7375: pa_debug.write('UPDATE_FP_ROWS: ' || g_module_name,'UPDATE_FP_ROWS ',1);

7371:
7372: BEGIN
7373:
7374: IF P_PA_DEBUG_MODE = 'Y' THEN
7375: pa_debug.write('UPDATE_FP_ROWS: ' || g_module_name,'UPDATE_FP_ROWS ',1);
7376: END IF;
7377: UPDATE /*+ ordered use_nl(rl) rowid(rl) */
7378: pji_fp_xbs_accum_f rl
7379: SET (

Line 7586: IF P_PA_DEBUG_MODE = 'Y' THEN

7582: WHERE rwid.fpr_rowid IS NOT NULL
7583: AND rwid.worker_id = g_worker_id
7584: );
7585:
7586: IF P_PA_DEBUG_MODE = 'Y' THEN
7587: pa_debug.write('UPDATE_FP_ROWS: ' || g_module_name,'UPDATE_FP_ROWS : '||sql%rowcount,1);
7588: END IF;
7589: print_time ( ' MERGE_INTO_FP_FACT 2.1 ' || sql%rowcount ) ;
7590:

Line 7587: pa_debug.write('UPDATE_FP_ROWS: ' || g_module_name,'UPDATE_FP_ROWS : '||sql%rowcount,1);

7583: AND rwid.worker_id = g_worker_id
7584: );
7585:
7586: IF P_PA_DEBUG_MODE = 'Y' THEN
7587: pa_debug.write('UPDATE_FP_ROWS: ' || g_module_name,'UPDATE_FP_ROWS : '||sql%rowcount,1);
7588: END IF;
7589: print_time ( ' MERGE_INTO_FP_FACT 2.1 ' || sql%rowcount ) ;
7590:
7591:

Line 7611: IF P_PA_DEBUG_MODE = 'Y' THEN

7607: l_count NUMBER;
7608:
7609: BEGIN
7610:
7611: IF P_PA_DEBUG_MODE = 'Y' THEN
7612: pa_debug.write('INSERT_FP_ROWS: ' || g_module_name,'INSERT_FP_ROWS ',1);
7613: END IF;
7614: INSERT INTO pji_fp_xbs_accum_f fact
7615: (

Line 7612: pa_debug.write('INSERT_FP_ROWS: ' || g_module_name,'INSERT_FP_ROWS ',1);

7608:
7609: BEGIN
7610:
7611: IF P_PA_DEBUG_MODE = 'Y' THEN
7612: pa_debug.write('INSERT_FP_ROWS: ' || g_module_name,'INSERT_FP_ROWS ',1);
7613: END IF;
7614: INSERT INTO pji_fp_xbs_accum_f fact
7615: (
7616: PROJECT_ID

Line 7848: IF P_PA_DEBUG_MODE = 'Y' THEN

7844: AND ver3.plan_type_code = tmp.plan_type_code /* 4471527 */
7845: AND tmp.project_id = ver3.project_id -- use index.
7846: AND tmp.plan_type_id = NVL(ver3.plan_type_id, -1); -- each plan type can have a different -3, -4 slice.
7847:
7848: IF P_PA_DEBUG_MODE = 'Y' THEN
7849: pa_debug.write('INSERT_FP_ROWS: ' || g_module_name,'INSERT_FP_ROWS : '||SQL%ROWCOUNT ,1);
7850: END IF;
7851: /* -- Bug 10632614
7852: ORDER BY

Line 7849: pa_debug.write('INSERT_FP_ROWS: ' || g_module_name,'INSERT_FP_ROWS : '||SQL%ROWCOUNT ,1);

7845: AND tmp.project_id = ver3.project_id -- use index.
7846: AND tmp.plan_type_id = NVL(ver3.plan_type_id, -1); -- each plan type can have a different -3, -4 slice.
7847:
7848: IF P_PA_DEBUG_MODE = 'Y' THEN
7849: pa_debug.write('INSERT_FP_ROWS: ' || g_module_name,'INSERT_FP_ROWS : '||SQL%ROWCOUNT ,1);
7850: END IF;
7851: /* -- Bug 10632614
7852: ORDER BY
7853: tmp.PROJECT_ID