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.BEN_CWB_CD_SUMMARY_PKG dependencies on BEN_CWB_CD_SUMMARY_PKG

Line 1: PACKAGE BODY BEN_CWB_CD_SUMMARY_PKG as

1: PACKAGE BODY BEN_CWB_CD_SUMMARY_PKG as
2: /* $Header: bencwbsum.pkb 120.0.12020000.2 2012/12/06 10:21:22 sgnanama noship $ */
3: FUNCTION Check_refresh_jobs
4: RETURN NUMBER
5: IS

Line 41: ben_cwb_cd_summary_pkg.Message_log_proc('Inserted Pilot row in BEN_CWB_COMP_DETAILS', 5);

37: -2,
38: -2,
39: Conc_Prog_Id);
40:
41: ben_cwb_cd_summary_pkg.Message_log_proc('Inserted Pilot row in BEN_CWB_COMP_DETAILS', 5);
42:
43: COMMIT;
44: END insert_refresh_jobs;
45:

Line 50: ben_cwb_cd_summary_pkg.Message_log_proc('Deleting Pilot row in BEN_CWB_COMP_DETAILS', 99);

46: PROCEDURE Delete_refresh_jobs
47: IS
48: PRAGMA autonomous_transaction;
49: BEGIN
50: ben_cwb_cd_summary_pkg.Message_log_proc('Deleting Pilot row in BEN_CWB_COMP_DETAILS', 99);
51:
52: DELETE FROM BEN_CWB_COMP_DETAILS
53: WHERE Nvl(bg_id, -1) = -2
54: AND Nvl(org_id, -1) = -2

Line 1073: ben_cwb_cd_summary_pkg.Message_log_proc('INSERTED '||SQL%ROWCOUNT || ' Rows in to BEN_CWB_COMP_DETAILS TABLE', 50);

1069: forall i IN 1..PSA.COUNT
1070: INSERT INTO BEN_CWB_COMP_DETAILS
1071: VALUES Psa(i);
1072:
1073: ben_cwb_cd_summary_pkg.Message_log_proc('INSERTED '||SQL%ROWCOUNT || ' Rows in to BEN_CWB_COMP_DETAILS TABLE', 50);
1074:
1075: EXIT WHEN companalytics%NOTFOUND;
1076:
1077: COMMIT;

Line 1149: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Started-------',10);

1145: WHERE synonym_name = 'BEN_CWB_COMP_DETAILS'
1146: AND ev.owner(+) = s.table_owner
1147: AND ev.view_name(+) = s.table_name;
1148:
1149: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Started-------',10);
1150:
1151: ben_cwb_cd_summary_pkg.Message_log_proc('Entering Ben_cwb_cd_summary_proc PROC', 10);
1152: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Id : '||Nvl(To_char(P_GROUP_PL_ID), 'Not Mentioned'), 10);
1153: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Effective Date : '||Nvl(P_LF_EVT_OCRD_DT, 'Not Mentioned'), 10);

Line 1151: ben_cwb_cd_summary_pkg.Message_log_proc('Entering Ben_cwb_cd_summary_proc PROC', 10);

1147: AND ev.view_name(+) = s.table_name;
1148:
1149: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Started-------',10);
1150:
1151: ben_cwb_cd_summary_pkg.Message_log_proc('Entering Ben_cwb_cd_summary_proc PROC', 10);
1152: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Id : '||Nvl(To_char(P_GROUP_PL_ID), 'Not Mentioned'), 10);
1153: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Effective Date : '||Nvl(P_LF_EVT_OCRD_DT, 'Not Mentioned'), 10);
1154: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Purge or Not : '||Nvl(P_PURGE, 'Not Mentioned'), 10);
1155:

Line 1152: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Id : '||Nvl(To_char(P_GROUP_PL_ID), 'Not Mentioned'), 10);

1148:
1149: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Started-------',10);
1150:
1151: ben_cwb_cd_summary_pkg.Message_log_proc('Entering Ben_cwb_cd_summary_proc PROC', 10);
1152: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Id : '||Nvl(To_char(P_GROUP_PL_ID), 'Not Mentioned'), 10);
1153: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Effective Date : '||Nvl(P_LF_EVT_OCRD_DT, 'Not Mentioned'), 10);
1154: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Purge or Not : '||Nvl(P_PURGE, 'Not Mentioned'), 10);
1155:
1156: l_check_var := BEN_CWB_CD_SUMMARY_PKG.check_refresh_jobs;

Line 1153: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Effective Date : '||Nvl(P_LF_EVT_OCRD_DT, 'Not Mentioned'), 10);

1149: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Started-------',10);
1150:
1151: ben_cwb_cd_summary_pkg.Message_log_proc('Entering Ben_cwb_cd_summary_proc PROC', 10);
1152: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Id : '||Nvl(To_char(P_GROUP_PL_ID), 'Not Mentioned'), 10);
1153: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Effective Date : '||Nvl(P_LF_EVT_OCRD_DT, 'Not Mentioned'), 10);
1154: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Purge or Not : '||Nvl(P_PURGE, 'Not Mentioned'), 10);
1155:
1156: l_check_var := BEN_CWB_CD_SUMMARY_PKG.check_refresh_jobs;
1157:

Line 1154: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Purge or Not : '||Nvl(P_PURGE, 'Not Mentioned'), 10);

1150:
1151: ben_cwb_cd_summary_pkg.Message_log_proc('Entering Ben_cwb_cd_summary_proc PROC', 10);
1152: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Id : '||Nvl(To_char(P_GROUP_PL_ID), 'Not Mentioned'), 10);
1153: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Effective Date : '||Nvl(P_LF_EVT_OCRD_DT, 'Not Mentioned'), 10);
1154: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Purge or Not : '||Nvl(P_PURGE, 'Not Mentioned'), 10);
1155:
1156: l_check_var := BEN_CWB_CD_SUMMARY_PKG.check_refresh_jobs;
1157:
1158: IF fnd_global.conc_request_id = -1

Line 1156: l_check_var := BEN_CWB_CD_SUMMARY_PKG.check_refresh_jobs;

1152: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Id : '||Nvl(To_char(P_GROUP_PL_ID), 'Not Mentioned'), 10);
1153: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Plan Effective Date : '||Nvl(P_LF_EVT_OCRD_DT, 'Not Mentioned'), 10);
1154: ben_cwb_cd_summary_pkg.Message_log_proc('Parameter - Purge or Not : '||Nvl(P_PURGE, 'Not Mentioned'), 10);
1155:
1156: l_check_var := BEN_CWB_CD_SUMMARY_PKG.check_refresh_jobs;
1157:
1158: IF fnd_global.conc_request_id = -1
1159: AND l_check_var = 1 THEN
1160: ben_cwb_cd_summary_pkg.Message_log_proc('This Concurrent Program already in Progress, Cannot run this request', 20);

Line 1160: ben_cwb_cd_summary_pkg.Message_log_proc('This Concurrent Program already in Progress, Cannot run this request', 20);

1156: l_check_var := BEN_CWB_CD_SUMMARY_PKG.check_refresh_jobs;
1157:
1158: IF fnd_global.conc_request_id = -1
1159: AND l_check_var = 1 THEN
1160: ben_cwb_cd_summary_pkg.Message_log_proc('This Concurrent Program already in Progress, Cannot run this request', 20);
1161:
1162: fnd_message.Set_name('BEN', 'BEN_CWB_CD_REFRESH_RUNG');
1163:
1164: fnd_message.raise_error;

Line 1170: ben_cwb_cd_summary_pkg.Message_log_proc('Plan Security is disabled', 30);

1166:
1167: IF ( P_GROUP_PL_ID IS NULL
1168: AND P_LF_EVT_OCRD_DT IS NULL
1169: AND fnd_profile.Value('BEN_CWB_PLAN_SECURITY') <> 'Y' ) THEN
1170: ben_cwb_cd_summary_pkg.Message_log_proc('Plan Security is disabled', 30);
1171:
1172: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||table_name_var;
1173:
1174: ben_cwb_cd_summary_pkg.Message_log_proc('Purged Table BEN_CWB_COMP_DETAILS', 40);

Line 1174: ben_cwb_cd_summary_pkg.Message_log_proc('Purged Table BEN_CWB_COMP_DETAILS', 40);

1170: ben_cwb_cd_summary_pkg.Message_log_proc('Plan Security is disabled', 30);
1171:
1172: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||table_name_var;
1173:
1174: ben_cwb_cd_summary_pkg.Message_log_proc('Purged Table BEN_CWB_COMP_DETAILS', 40);
1175:
1176: IF Nvl(Lower(Trim(P_PURGE)), 'n') <> 'y' THEN
1177: BEN_CWB_CD_SUMMARY_PKG.insert_refresh_jobs;
1178:

Line 1177: BEN_CWB_CD_SUMMARY_PKG.insert_refresh_jobs;

1173:
1174: ben_cwb_cd_summary_pkg.Message_log_proc('Purged Table BEN_CWB_COMP_DETAILS', 40);
1175:
1176: IF Nvl(Lower(Trim(P_PURGE)), 'n') <> 'y' THEN
1177: BEN_CWB_CD_SUMMARY_PKG.insert_refresh_jobs;
1178:
1179: OPEN c_group_plan_list (P_GROUP_PL_ID, To_date(P_LF_EVT_OCRD_DT, 'yyyy/mm/dd HH24:MI:SS'));
1180:
1181: LOOP

Line 1186: ben_cwb_cd_summary_pkg.Message_log_proc('Populating for the plan '||L_PARAM_PL_NAME||'-'||L_PARAM_EVT_OCRD_DT, 60);

1182: FETCH c_group_plan_list INTO L_PARAM_GROUP_PL_ID, L_PARAM_PL_NAME, L_PARAM_EVT_OCRD_DT;
1183:
1184: EXIT WHEN c_group_plan_list%NOTFOUND;
1185:
1186: ben_cwb_cd_summary_pkg.Message_log_proc('Populating for the plan '||L_PARAM_PL_NAME||'-'||L_PARAM_EVT_OCRD_DT, 60);
1187:
1188: Ben_cwb_summary_populate(L_PARAM_GROUP_PL_ID, L_PARAM_EVT_OCRD_DT);
1189:
1190: COMMIT;

Line 1196: BEN_CWB_CD_SUMMARY_PKG.insert_refresh_jobs;

1192: END IF;
1193:
1194: COMMIT;
1195: ELSE
1196: BEN_CWB_CD_SUMMARY_PKG.insert_refresh_jobs;
1197:
1198: ben_cwb_cd_summary_pkg.Message_log_proc('Specific Plan is Selected (And/or) Plan Security is Enabled', 20);
1199:
1200: OPEN c_group_plan_list (P_GROUP_PL_ID, To_date(P_LF_EVT_OCRD_DT, 'yyyy/mm/dd HH24:MI:SS'));

Line 1198: ben_cwb_cd_summary_pkg.Message_log_proc('Specific Plan is Selected (And/or) Plan Security is Enabled', 20);

1194: COMMIT;
1195: ELSE
1196: BEN_CWB_CD_SUMMARY_PKG.insert_refresh_jobs;
1197:
1198: ben_cwb_cd_summary_pkg.Message_log_proc('Specific Plan is Selected (And/or) Plan Security is Enabled', 20);
1199:
1200: OPEN c_group_plan_list (P_GROUP_PL_ID, To_date(P_LF_EVT_OCRD_DT, 'yyyy/mm/dd HH24:MI:SS'));
1201:
1202: LOOP

Line 1211: ben_cwb_cd_summary_pkg.Message_log_proc('Deleted '||SQL%ROWCOUNT ||' Rows for ' ||L_PARAM_PL_NAME||'-'||L_PARAM_EVT_OCRD_DT||' from BEN_CWB_COMP_DETAILS', 40);

1207: DELETE FROM BEN_CWB_COMP_DETAILS
1208: WHERE group_pl_id = L_PARAM_GROUP_PL_ID
1209: AND LF_EVT_OCRD_DT = L_PARAM_EVT_OCRD_DT;
1210:
1211: ben_cwb_cd_summary_pkg.Message_log_proc('Deleted '||SQL%ROWCOUNT ||' Rows for ' ||L_PARAM_PL_NAME||'-'||L_PARAM_EVT_OCRD_DT||' from BEN_CWB_COMP_DETAILS', 40);
1212:
1213: COMMIT;
1214: END LOOP;
1215:

Line 1228: ben_cwb_cd_summary_pkg.Message_log_proc('Populating for the plan ' ||L_PARAM_PL_NAME||'-'||L_PARAM_EVT_OCRD_DT, 60);

1224: FETCH c_group_plan_list INTO L_PARAM_GROUP_PL_ID, L_PARAM_PL_NAME, L_PARAM_EVT_OCRD_DT;
1225:
1226: EXIT WHEN c_group_plan_list%NOTFOUND;
1227:
1228: ben_cwb_cd_summary_pkg.Message_log_proc('Populating for the plan ' ||L_PARAM_PL_NAME||'-'||L_PARAM_EVT_OCRD_DT, 60);
1229:
1230: Ben_cwb_summary_populate(L_PARAM_GROUP_PL_ID, L_PARAM_EVT_OCRD_DT);
1231:
1232: COMMIT;

Line 1241: BEN_CWB_CD_SUMMARY_PKG.delete_refresh_jobs;

1237: CLOSE c_group_plan_list;
1238: END IF;
1239: END IF;
1240:
1241: BEN_CWB_CD_SUMMARY_PKG.delete_refresh_jobs;
1242:
1243: ben_cwb_cd_summary_pkg.Message_log_proc('Gathering in Statistics BEN_CWB_COMP_DETAILS', 80);
1244: fnd_stats.Gather_table_stats('BEN', 'BEN_CWB_COMP_DETAILS');
1245: ben_cwb_cd_summary_pkg.Message_log_proc('Leaving BEN_CWB_COMP_DETAILS_PROC', 95);

Line 1243: ben_cwb_cd_summary_pkg.Message_log_proc('Gathering in Statistics BEN_CWB_COMP_DETAILS', 80);

1239: END IF;
1240:
1241: BEN_CWB_CD_SUMMARY_PKG.delete_refresh_jobs;
1242:
1243: ben_cwb_cd_summary_pkg.Message_log_proc('Gathering in Statistics BEN_CWB_COMP_DETAILS', 80);
1244: fnd_stats.Gather_table_stats('BEN', 'BEN_CWB_COMP_DETAILS');
1245: ben_cwb_cd_summary_pkg.Message_log_proc('Leaving BEN_CWB_COMP_DETAILS_PROC', 95);
1246: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Finished Successfully-------', 100);
1247:

Line 1245: ben_cwb_cd_summary_pkg.Message_log_proc('Leaving BEN_CWB_COMP_DETAILS_PROC', 95);

1241: BEN_CWB_CD_SUMMARY_PKG.delete_refresh_jobs;
1242:
1243: ben_cwb_cd_summary_pkg.Message_log_proc('Gathering in Statistics BEN_CWB_COMP_DETAILS', 80);
1244: fnd_stats.Gather_table_stats('BEN', 'BEN_CWB_COMP_DETAILS');
1245: ben_cwb_cd_summary_pkg.Message_log_proc('Leaving BEN_CWB_COMP_DETAILS_PROC', 95);
1246: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Finished Successfully-------', 100);
1247:
1248: EXCEPTION
1249: WHEN OTHERS THEN

Line 1246: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Finished Successfully-------', 100);

1242:
1243: ben_cwb_cd_summary_pkg.Message_log_proc('Gathering in Statistics BEN_CWB_COMP_DETAILS', 80);
1244: fnd_stats.Gather_table_stats('BEN', 'BEN_CWB_COMP_DETAILS');
1245: ben_cwb_cd_summary_pkg.Message_log_proc('Leaving BEN_CWB_COMP_DETAILS_PROC', 95);
1246: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Finished Successfully-------', 100);
1247:
1248: EXCEPTION
1249: WHEN OTHERS THEN
1250: errbuf := errbuf

Line 1258: ben_cwb_cd_summary_pkg.Message_log_proc('Deleted '||SQL%ROWCOUNT ||' from summary Table', 90);

1254:
1255: DELETE FROM BEN_CWB_COMP_DETAILS
1256: WHERE CONC_REQUEST_ID = Conc_Prog_Id;
1257:
1258: ben_cwb_cd_summary_pkg.Message_log_proc('Deleted '||SQL%ROWCOUNT ||' from summary Table', 90);
1259:
1260: COMMIT;
1261:
1262: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Throwed an Exception-------', 100);

Line 1262: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Throwed an Exception-------', 100);

1258: ben_cwb_cd_summary_pkg.Message_log_proc('Deleted '||SQL%ROWCOUNT ||' from summary Table', 90);
1259:
1260: COMMIT;
1261:
1262: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Throwed an Exception-------', 100);
1263: ben_cwb_cd_summary_pkg.Message_log_proc('Error in BEN_CWB_COMP_DETAILS_PROC: '||SQLCODE, 100);
1264: ben_cwb_cd_summary_pkg.Message_log_proc(1, 100);
1265: ben_cwb_cd_summary_pkg.Message_log_proc('Error Msg: '||Substr(SQLERRM, 1, 700), 100);
1266:

Line 1263: ben_cwb_cd_summary_pkg.Message_log_proc('Error in BEN_CWB_COMP_DETAILS_PROC: '||SQLCODE, 100);

1259:
1260: COMMIT;
1261:
1262: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Throwed an Exception-------', 100);
1263: ben_cwb_cd_summary_pkg.Message_log_proc('Error in BEN_CWB_COMP_DETAILS_PROC: '||SQLCODE, 100);
1264: ben_cwb_cd_summary_pkg.Message_log_proc(1, 100);
1265: ben_cwb_cd_summary_pkg.Message_log_proc('Error Msg: '||Substr(SQLERRM, 1, 700), 100);
1266:
1267: END ben_cwb_cd_summary_proc;

Line 1264: ben_cwb_cd_summary_pkg.Message_log_proc(1, 100);

1260: COMMIT;
1261:
1262: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Throwed an Exception-------', 100);
1263: ben_cwb_cd_summary_pkg.Message_log_proc('Error in BEN_CWB_COMP_DETAILS_PROC: '||SQLCODE, 100);
1264: ben_cwb_cd_summary_pkg.Message_log_proc(1, 100);
1265: ben_cwb_cd_summary_pkg.Message_log_proc('Error Msg: '||Substr(SQLERRM, 1, 700), 100);
1266:
1267: END ben_cwb_cd_summary_proc;
1268:

Line 1265: ben_cwb_cd_summary_pkg.Message_log_proc('Error Msg: '||Substr(SQLERRM, 1, 700), 100);

1261:
1262: ben_cwb_cd_summary_pkg.Message_log_proc('-----Concurrent Program Compensation Detail Report Summary Refresh Throwed an Exception-------', 100);
1263: ben_cwb_cd_summary_pkg.Message_log_proc('Error in BEN_CWB_COMP_DETAILS_PROC: '||SQLCODE, 100);
1264: ben_cwb_cd_summary_pkg.Message_log_proc(1, 100);
1265: ben_cwb_cd_summary_pkg.Message_log_proc('Error Msg: '||Substr(SQLERRM, 1, 700), 100);
1266:
1267: END ben_cwb_cd_summary_proc;
1268:
1269:

Line 1281: END BEN_CWB_CD_SUMMARY_PKG;

1277: ELSE
1278: fnd_file.Put_line(fnd_file.log, MESSAGE);
1279: END IF;
1280: END message_log_proc;
1281: END BEN_CWB_CD_SUMMARY_PKG;