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

Line 711: pa_debug.debug(x_err_stage);

707: x_err_stage := 'Collecting Actuals/Commitments';
708: x_old_err_stack := x_err_stack;
709: x_err_stack := x_err_stack || '-> get_fact_act_cmts';
710:
711: pa_debug.debug(x_err_stage);
712:
713: -- Process all projects one one by one
714:
715: FOR sel_prjs_r IN sel_prjs LOOP

Line 720: pa_debug.debug('Processing project_id ' || to_char(sel_prjs_r.project_id) || ' Project Number' || sel_prjs_r.segment1 );

716:
717: -- Mark the PA_TASK_HISTORY rows for latest service_type
718: -- These are the task for which the service type is latest
719:
720: pa_debug.debug('Processing project_id ' || to_char(sel_prjs_r.project_id) || ' Project Number' || sel_prjs_r.segment1 );
721:
722: UPDATE
723: PA_TASK_HISTORY PTH
724: SET

Line 734: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows for Transfer');

730: FROM PA_TASK_HISTORY PTHL
731: WHERE PTHL.TASK_ID = PTH.TASK_ID
732: );
733:
734: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows for Transfer');
735:
736: -- Update the task where the service type has changed from
737: -- the last time the tasks were interfaced to the interface table
738: -- and the task which are not refreshed earlier by the project refresh

Line 767: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows for Service Type Change');

763: AND ADW_NOTIFY_FLAG = 'Y'
764: );
765:
766: ref_ser_type_count := SQL%ROWCOUNT;
767: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows for Service Type Change');
768:
769: -- Mark the other tasks with this service type for refresh too
770:
771: UPDATE PA_ADW_INTERFACED_TASKS PTH

Line 796: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows for Service Type Change at other tasks');

792: WHERE PROJECT_ID = sel_prjs_r.project_id
793: AND TASK_ID = PTH.TASK_ID
794: AND ADW_NOTIFY_FLAG = 'Y'
795: );
796: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows for Service Type Change at other tasks');
797:
798: -- Update all lowest level tasks if any top task got changed
799:
800: UPDATE PA_ADW_INTERFACED_TASKS PTH

Line 820: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows due to the service type change at top task level');

816: WHERE PROJECT_ID = sel_prjs_r.project_id
817: AND TASK_ID = PTH.TASK_ID
818: AND ADW_NOTIFY_FLAG = 'Y'
819: );
820: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Task Rows due to the service type change at top task level');
821:
822: -- Mark all the resource accum rows need to be refreshed
823:
824: UPDATE

Line 834: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Old Resource accum details');

830: AND ADW_NOTIFY_FLAG = 'Y';
831:
832: ref_res_count := SQL%ROWCOUNT;
833:
834: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' Old Resource accum details');
835:
836: -- Check if the service type was changed for any task interfaced earlier
837: -- For all of these tasks we need to send adjustments. We will send $0
838: -- for the old service type and full amount to the new service type

Line 850: pa_debug.debug(x_err_stage);

846: -- Refresh the lowest tasks numbers
847:
848: x_err_stage := 'Refreshing txns at lowest task level';
849:
850: pa_debug.debug(x_err_stage);
851:
852: FOR ref_lowest_act_cmts_r IN sel_ref_lowest_act_cmts(sel_prjs_r.project_id) LOOP
853:
854: pa_debug.debug('Sending $0** for lowest task_id ' || to_char(ref_lowest_act_cmts_r.task_id) || ' For Service Type ' || ref_lowest_act_cmts_r.service_type_code);

Line 854: pa_debug.debug('Sending $0** for lowest task_id ' || to_char(ref_lowest_act_cmts_r.task_id) || ' For Service Type ' || ref_lowest_act_cmts_r.service_type_code);

850: pa_debug.debug(x_err_stage);
851:
852: FOR ref_lowest_act_cmts_r IN sel_ref_lowest_act_cmts(sel_prjs_r.project_id) LOOP
853:
854: pa_debug.debug('Sending $0** for lowest task_id ' || to_char(ref_lowest_act_cmts_r.task_id) || ' For Service Type ' || ref_lowest_act_cmts_r.service_type_code);
855:
856: update_tasks_act_cmt
857: (ref_lowest_act_cmts_r.task_id,
858: ref_lowest_act_cmts_r.pa_period_key,

Line 903: pa_debug.debug(x_err_stage);

899: -- Refresh the top tasks numbers
900:
901: x_err_stage := 'Refreshing txns at top task level';
902:
903: pa_debug.debug(x_err_stage);
904:
905: FOR ref_top_act_cmts_r IN sel_ref_top_act_cmts(sel_prjs_r.project_id) LOOP
906:
907: pa_debug.debug('Sending $0** for top task_id ' || to_char(ref_top_act_cmts_r.top_task_id) || ' For Service Type ' || ref_top_act_cmts_r.service_type_code);

Line 907: pa_debug.debug('Sending $0** for top task_id ' || to_char(ref_top_act_cmts_r.top_task_id) || ' For Service Type ' || ref_top_act_cmts_r.service_type_code);

903: pa_debug.debug(x_err_stage);
904:
905: FOR ref_top_act_cmts_r IN sel_ref_top_act_cmts(sel_prjs_r.project_id) LOOP
906:
907: pa_debug.debug('Sending $0** for top task_id ' || to_char(ref_top_act_cmts_r.top_task_id) || ' For Service Type ' || ref_top_act_cmts_r.service_type_code);
908:
909: update_tasks_act_cmt
910: (ref_top_act_cmts_r.top_task_id,
911: ref_top_act_cmts_r.pa_period_key,

Line 952: pa_debug.debug(x_err_stage);

948: -- Refresh the project level Numbers
949:
950: x_err_stage := 'Refreshing txns at Project level';
951:
952: pa_debug.debug(x_err_stage);
953:
954: FOR ref_prj_act_cmts_r IN sel_ref_prj_act_cmts(sel_prjs_r.project_id) LOOP
955:
956: pa_debug.debug('Sending $0*** for project_id ' || to_char(ref_prj_act_cmts_r.project_id) || ' For Service Type ' || ref_prj_act_cmts_r.service_type_code);

Line 956: pa_debug.debug('Sending $0*** for project_id ' || to_char(ref_prj_act_cmts_r.project_id) || ' For Service Type ' || ref_prj_act_cmts_r.service_type_code);

952: pa_debug.debug(x_err_stage);
953:
954: FOR ref_prj_act_cmts_r IN sel_ref_prj_act_cmts(sel_prjs_r.project_id) LOOP
955:
956: pa_debug.debug('Sending $0*** for project_id ' || to_char(ref_prj_act_cmts_r.project_id) || ' For Service Type ' || ref_prj_act_cmts_r.service_type_code);
957:
958: update_prj_act_cmt
959: (ref_prj_act_cmts_r.project_id,
960: ref_prj_act_cmts_r.pa_period_key,

Line 1019: pa_debug.debug(x_err_stage);

1015: -- Refresh the lowest tasks numbers
1016:
1017: x_err_stage := 'Refreshing txns at lowest task level for service type change';
1018:
1019: pa_debug.debug(x_err_stage);
1020:
1021: FOR ref_lowest_ser_type_act_cmts_r IN sel_ref_lowest_stype_act_cmts(sel_prjs_r.project_id) LOOP
1022:
1023: pa_debug.debug('Sending $0**** for lowest task_id ' || to_char(ref_lowest_ser_type_act_cmts_r.task_id) || ' For Service Type ' || ref_lowest_ser_type_act_cmts_r.service_type_code);

Line 1023: pa_debug.debug('Sending $0**** for lowest task_id ' || to_char(ref_lowest_ser_type_act_cmts_r.task_id) || ' For Service Type ' || ref_lowest_ser_type_act_cmts_r.service_type_code);

1019: pa_debug.debug(x_err_stage);
1020:
1021: FOR ref_lowest_ser_type_act_cmts_r IN sel_ref_lowest_stype_act_cmts(sel_prjs_r.project_id) LOOP
1022:
1023: pa_debug.debug('Sending $0**** for lowest task_id ' || to_char(ref_lowest_ser_type_act_cmts_r.task_id) || ' For Service Type ' || ref_lowest_ser_type_act_cmts_r.service_type_code);
1024:
1025: update_tasks_act_cmt
1026: (ref_lowest_ser_type_act_cmts_r.task_id,
1027: ref_lowest_ser_type_act_cmts_r.pa_period_key,

Line 1072: pa_debug.debug(x_err_stage);

1068: -- Refresh the top tasks numbers
1069:
1070: x_err_stage := 'Refreshing txns at top task level for service type change';
1071:
1072: pa_debug.debug(x_err_stage);
1073:
1074: FOR ref_top_ser_type_act_cmts_r IN sel_ref_top_ser_type_act_cmts(sel_prjs_r.project_id) LOOP
1075:
1076: pa_debug.debug('Sending $0**** for top task_id ' || to_char(ref_top_ser_type_act_cmts_r.top_task_id) || ' For Service Type ' || ref_top_ser_type_act_cmts_r.service_type_code);

Line 1076: pa_debug.debug('Sending $0**** for top task_id ' || to_char(ref_top_ser_type_act_cmts_r.top_task_id) || ' For Service Type ' || ref_top_ser_type_act_cmts_r.service_type_code);

1072: pa_debug.debug(x_err_stage);
1073:
1074: FOR ref_top_ser_type_act_cmts_r IN sel_ref_top_ser_type_act_cmts(sel_prjs_r.project_id) LOOP
1075:
1076: pa_debug.debug('Sending $0**** for top task_id ' || to_char(ref_top_ser_type_act_cmts_r.top_task_id) || ' For Service Type ' || ref_top_ser_type_act_cmts_r.service_type_code);
1077:
1078: update_tasks_act_cmt
1079: (ref_top_ser_type_act_cmts_r.top_task_id,
1080: ref_top_ser_type_act_cmts_r.pa_period_key,

Line 1121: pa_debug.debug(x_err_stage);

1117: -- Refresh the project level Numbers
1118:
1119: x_err_stage := 'Refreshing txns at Project level';
1120:
1121: pa_debug.debug(x_err_stage);
1122:
1123: FOR ref_prj_ser_type_act_cmts_r IN sel_ref_prj_ser_type_act_cmts(sel_prjs_r.project_id) LOOP
1124:
1125: pa_debug.debug('Sending $0***** for project_id ' || to_char(ref_prj_ser_type_act_cmts_r.project_id) || ' For Service Type ' || ref_prj_ser_type_act_cmts_r.service_type_code);

Line 1125: pa_debug.debug('Sending $0***** for project_id ' || to_char(ref_prj_ser_type_act_cmts_r.project_id) || ' For Service Type ' || ref_prj_ser_type_act_cmts_r.service_type_code);

1121: pa_debug.debug(x_err_stage);
1122:
1123: FOR ref_prj_ser_type_act_cmts_r IN sel_ref_prj_ser_type_act_cmts(sel_prjs_r.project_id) LOOP
1124:
1125: pa_debug.debug('Sending $0***** for project_id ' || to_char(ref_prj_ser_type_act_cmts_r.project_id) || ' For Service Type ' || ref_prj_ser_type_act_cmts_r.service_type_code);
1126:
1127: update_prj_act_cmt
1128: (ref_prj_ser_type_act_cmts_r.project_id,
1129: ref_prj_ser_type_act_cmts_r.pa_period_key,

Line 1176: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' Txn Accum rows for re-transfer due to service type change alone');

1172: WHERE PTH.TASK_ID = PTA.TASK_ID
1173: AND PTH.ADW_NOTIFY_FLAG IN ('S','P')
1174: );
1175:
1176: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' Txn Accum rows for re-transfer due to service type change alone');
1177:
1178: UPDATE
1179: PA_TASK_HISTORY
1180: SET

Line 1235: pa_debug.debug(x_err_stage);

1231: -- collect Actuals/Cmts at lowest tasks level
1232:
1233: x_err_stage := 'Collecting Actuals/Cmts txns at lowest task level';
1234:
1235: pa_debug.debug(x_err_stage);
1236:
1237: FOR lowest_act_cmts_r IN sel_lowest_act_cmts(sel_prjs_r.project_id) LOOP
1238:
1239: pa_debug.debug('Sending for lowest task_id ' || to_char(lowest_act_cmts_r.task_id) || ' For Service Type ' || lowest_act_cmts_r.service_type_code);

Line 1239: pa_debug.debug('Sending for lowest task_id ' || to_char(lowest_act_cmts_r.task_id) || ' For Service Type ' || lowest_act_cmts_r.service_type_code);

1235: pa_debug.debug(x_err_stage);
1236:
1237: FOR lowest_act_cmts_r IN sel_lowest_act_cmts(sel_prjs_r.project_id) LOOP
1238:
1239: pa_debug.debug('Sending for lowest task_id ' || to_char(lowest_act_cmts_r.task_id) || ' For Service Type ' || lowest_act_cmts_r.service_type_code);
1240:
1241:
1242: update_tasks_act_cmt
1243: (lowest_act_cmts_r.task_id,

Line 1289: pa_debug.debug(x_err_stage);

1285: -- collect Actuals/Cmts at top tasks level
1286:
1287: x_err_stage := 'Collecting Actuals/Cmts txns at top task level';
1288:
1289: pa_debug.debug(x_err_stage);
1290:
1291: FOR top_act_cmts_r IN sel_top_act_cmts(sel_prjs_r.project_id) LOOP
1292:
1293: pa_debug.debug('Sending for top task_id ' || to_char(top_act_cmts_r.top_task_id) || ' For Service Type ' || top_act_cmts_r.service_type_code);

Line 1293: pa_debug.debug('Sending for top task_id ' || to_char(top_act_cmts_r.top_task_id) || ' For Service Type ' || top_act_cmts_r.service_type_code);

1289: pa_debug.debug(x_err_stage);
1290:
1291: FOR top_act_cmts_r IN sel_top_act_cmts(sel_prjs_r.project_id) LOOP
1292:
1293: pa_debug.debug('Sending for top task_id ' || to_char(top_act_cmts_r.top_task_id) || ' For Service Type ' || top_act_cmts_r.service_type_code);
1294:
1295: update_tasks_act_cmt
1296: (top_act_cmts_r.top_task_id,
1297: top_act_cmts_r.pa_period_key,

Line 1338: pa_debug.debug(x_err_stage);

1334: -- collect Actuals/Cmts at Project level
1335:
1336: x_err_stage := 'Collecting Actuals/Cmts txns at Project level';
1337:
1338: pa_debug.debug(x_err_stage);
1339:
1340: FOR prj_act_cmts_r IN sel_prj_act_cmts(sel_prjs_r.project_id) LOOP
1341: pa_debug.debug('Sending for project_id ' || to_char(prj_act_cmts_r.project_id) || ' For Service Type ' || prj_act_cmts_r.service_type_code);
1342:

Line 1341: pa_debug.debug('Sending for project_id ' || to_char(prj_act_cmts_r.project_id) || ' For Service Type ' || prj_act_cmts_r.service_type_code);

1337:
1338: pa_debug.debug(x_err_stage);
1339:
1340: FOR prj_act_cmts_r IN sel_prj_act_cmts(sel_prjs_r.project_id) LOOP
1341: pa_debug.debug('Sending for project_id ' || to_char(prj_act_cmts_r.project_id) || ' For Service Type ' || prj_act_cmts_r.service_type_code);
1342:
1343:
1344: update_prj_act_cmt
1345: (prj_act_cmts_r.project_id,

Line 1399: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' task rows transferred to interface table');

1395: SELECT TASK_ID
1396: FROM PA_TXN_ACCUM
1397: WHERE ADW_NOTIFY_FLAG = 'S'
1398: );
1399: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' task rows transferred to interface table');
1400:
1401: UPDATE
1402: PA_TASK_HISTORY PTH
1403: SET

Line 1421: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' top task rows transferred to interface table');

1417: FROM PA_TXN_ACCUM
1418: WHERE ADW_NOTIFY_FLAG = 'S'
1419: )
1420: );
1421: pa_debug.debug('Marked '||TO_CHAR(SQL%ROWCOUNT)||' top task rows transferred to interface table');
1422:
1423: -- PLEASE NOTE THAT WE ARE UPDATING THE BASE TABLE SINCE THE
1424: -- PA_ADW_R_ACT_CMT_V IS DEFINED ON MULTIPLE TABLES
1425:

Line 1447: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' task rows Not transferred to interface table');

1443: SET ADW_NOTIFY_FLAG = 'N'
1444: WHERE
1445: ADW_NOTIFY_FLAG = 'Y';
1446:
1447: pa_debug.debug('Marked ' || TO_CHAR(SQL%ROWCOUNT) || ' task rows Not transferred to interface table');
1448: -- Commit the project
1449: COMMIT;
1450: END LOOP; -- FOR sel_prjs_r IN sel_prjs
1451:

Line 1454: pa_debug.debug('Completed ' || x_err_stage);

1450: END LOOP; -- FOR sel_prjs_r IN sel_prjs
1451:
1452: x_err_stack := x_old_err_stack;
1453:
1454: pa_debug.debug('Completed ' || x_err_stage);
1455:
1456: EXCEPTION
1457: WHEN OTHERS THEN
1458: x_err_code := SQLCODE;

Line 2209: pa_debug.debug(x_err_stage);

2205: x_err_stage := 'Collecting Budgets';
2206: x_old_err_stack := x_err_stack;
2207: x_err_stack := x_err_stack || '-> get_fact_budgets';
2208:
2209: pa_debug.debug(x_err_stage);
2210:
2211: -- Process all projects one one by one
2212:
2213: FOR sel_prjs_r IN sel_prjs LOOP

Line 2215: pa_debug.debug('Processing Budgets For Project ' || sel_prjs_r.segment1);

2211: -- Process all projects one one by one
2212:
2213: FOR sel_prjs_r IN sel_prjs LOOP
2214:
2215: pa_debug.debug('Processing Budgets For Project ' || sel_prjs_r.segment1);
2216:
2217: -- First mark all the budgets need to be transferred
2218: -- We will transfer the latest baselined budget only
2219:

Line 2535: pa_debug.debug('Completed ' || x_err_stage);

2531: END LOOP; -- FOR sel_prjs_r IN sel_prjs
2532:
2533: x_err_stack := x_old_err_stack;
2534:
2535: pa_debug.debug('Completed ' || x_err_stage);
2536:
2537: EXCEPTION
2538: WHEN OTHERS THEN
2539: x_err_code := SQLCODE;