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.PQH_GSP_PRGRULES dependencies on HR_UTILITY

Line 211: hr_utility.set_location('Inside create_dup_elp_tree', 10);

207: where parent_entity_result_id = p_parent_cer_id
208: and copy_entity_txn_id = p_copy_entity_txn_id;
209:
210: begin
211: hr_utility.set_location('Inside create_dup_elp_tree', 10);
212: hr_utility.set_location('p_copy_entity_txn_id'||p_copy_entity_txn_id, 20);
213: hr_utility.set_location('p_business_group_id'||p_business_group_id, 30);
214: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id, 40);
215: for rec_elp in cur_elp

Line 212: hr_utility.set_location('p_copy_entity_txn_id'||p_copy_entity_txn_id, 20);

208: and copy_entity_txn_id = p_copy_entity_txn_id;
209:
210: begin
211: hr_utility.set_location('Inside create_dup_elp_tree', 10);
212: hr_utility.set_location('p_copy_entity_txn_id'||p_copy_entity_txn_id, 20);
213: hr_utility.set_location('p_business_group_id'||p_business_group_id, 30);
214: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id, 40);
215: for rec_elp in cur_elp
216: loop

Line 213: hr_utility.set_location('p_business_group_id'||p_business_group_id, 30);

209:
210: begin
211: hr_utility.set_location('Inside create_dup_elp_tree', 10);
212: hr_utility.set_location('p_copy_entity_txn_id'||p_copy_entity_txn_id, 20);
213: hr_utility.set_location('p_business_group_id'||p_business_group_id, 30);
214: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id, 40);
215: for rec_elp in cur_elp
216: loop
217: -- create duplicate ELP record

Line 214: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id, 40);

210: begin
211: hr_utility.set_location('Inside create_dup_elp_tree', 10);
212: hr_utility.set_location('p_copy_entity_txn_id'||p_copy_entity_txn_id, 20);
213: hr_utility.set_location('p_business_group_id'||p_business_group_id, 30);
214: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id, 40);
215: for rec_elp in cur_elp
216: loop
217: -- create duplicate ELP record
218: l_elp_cerid := create_bcer_rec(rec_elp);

Line 242: hr_utility.set_location('Leaving create_dup_elp_tree', 10);

238: update_child(l_gchild_cerid,l_child_cerid);
239: end loop ;
240: end loop;
241: end loop ;
242: hr_utility.set_location('Leaving create_dup_elp_tree', 10);
243: end create_dup_elp_tree ;
244:
245: procedure purge_dup_elp_tree (
246: p_copy_entity_txn_id number

Line 337: hr_utility.set_location('hm Inside sync_elp_rec',123) ;

333: -- 2. save the GS_PARENT_ENTITY_RESULT_ID PARENT_ENTITY_RESULT_ID of this
334: -- 3. delete the whole dup hierarchy using cer_id of this dup elp
335: -- 4. recreate the whole hierarchy
336: -- 5. update the ELP record with variables saved in step 2
337: hr_utility.set_location('hm Inside sync_elp_rec',123) ;
338:
339: open cur_org_elp;
340: fetch cur_org_elp into l_org_elp_exist ;
341: close cur_org_elp ;

Line 352: hr_utility.set_location('hm Inside for loop',123) ;

348: l_gs_per_id := rec_dup_elp.gs_parent_entity_result_id ;
349: l_per_id := rec_dup_elp.parent_entity_result_id ;
350: l_gm_ser_id := rec_dup_elp.Gs_Mirror_Src_Entity_Result_id;
351:
352: hr_utility.set_location('hm Inside for loop',123) ;
353: hr_utility.set_location('hm cerid-'||rec_dup_elp.copy_entity_result_id,123) ;
354:
355: purge_dup_elp_tree
356: (p_copy_entity_txn_id => p_copy_entity_txn_id

Line 353: hr_utility.set_location('hm cerid-'||rec_dup_elp.copy_entity_result_id,123) ;

349: l_per_id := rec_dup_elp.parent_entity_result_id ;
350: l_gm_ser_id := rec_dup_elp.Gs_Mirror_Src_Entity_Result_id;
351:
352: hr_utility.set_location('hm Inside for loop',123) ;
353: hr_utility.set_location('hm cerid-'||rec_dup_elp.copy_entity_result_id,123) ;
354:
355: purge_dup_elp_tree
356: (p_copy_entity_txn_id => p_copy_entity_txn_id
357: ,p_eligy_prfl_id => rec_dup_elp.information101

Line 373: hr_utility.set_location('leaving sync_elp_rec',123) ;

369: ,p_gm_ser_id => l_gm_ser_id
370: );
371:
372: end if;
373: hr_utility.set_location('leaving sync_elp_rec',123) ;
374: end sync_elp_records;
375:
376: --<-------- function create_duplicate_elp_tree -------->
377: -- purpose - To create a duplicate hierarchy of an existing ELPRO in staging area

Line 424: hr_utility.set_location('Inside duplicate_elp_tree', 10);

420: where parent_entity_result_id = p_parent_cer_id
421: and copy_entity_txn_id = p_copy_entity_txn_id;
422:
423: begin
424: hr_utility.set_location('Inside duplicate_elp_tree', 10);
425: hr_utility.set_location('p_copy_entity_txn_id'||p_copy_entity_txn_id, 20);
426: hr_utility.set_location('p_business_group_id'||p_business_group_id, 30);
427: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id, 40);
428: for rec_elp in cur_elp

Line 425: hr_utility.set_location('p_copy_entity_txn_id'||p_copy_entity_txn_id, 20);

421: and copy_entity_txn_id = p_copy_entity_txn_id;
422:
423: begin
424: hr_utility.set_location('Inside duplicate_elp_tree', 10);
425: hr_utility.set_location('p_copy_entity_txn_id'||p_copy_entity_txn_id, 20);
426: hr_utility.set_location('p_business_group_id'||p_business_group_id, 30);
427: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id, 40);
428: for rec_elp in cur_elp
429: loop

Line 426: hr_utility.set_location('p_business_group_id'||p_business_group_id, 30);

422:
423: begin
424: hr_utility.set_location('Inside duplicate_elp_tree', 10);
425: hr_utility.set_location('p_copy_entity_txn_id'||p_copy_entity_txn_id, 20);
426: hr_utility.set_location('p_business_group_id'||p_business_group_id, 30);
427: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id, 40);
428: for rec_elp in cur_elp
429: loop
430: -- create duplicate ELP record

Line 427: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id, 40);

423: begin
424: hr_utility.set_location('Inside duplicate_elp_tree', 10);
425: hr_utility.set_location('p_copy_entity_txn_id'||p_copy_entity_txn_id, 20);
426: hr_utility.set_location('p_business_group_id'||p_business_group_id, 30);
427: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id, 40);
428: for rec_elp in cur_elp
429: loop
430: -- create duplicate ELP record
431: l_elp_cerid := create_bcer_rec(rec_elp);

Line 452: hr_utility.set_location('Leaving duplicate_elp_tree', 10);

448: end loop ;
449: end loop;
450: end loop ;
451:
452: hr_utility.set_location('Leaving duplicate_elp_tree', 10);
453: return l_elp_cerid;
454:
455: end create_duplicate_elp_tree ;
456:

Line 553: hr_utility.set_location('Entering creating bcer rec', 10);

549: l_grr_cer_ovn number;
550: l_effective_date date; -- ask GANESH
551: bcer_rec ben_copy_entity_results%rowtype ;
552: begin
553: hr_utility.set_location('Entering creating bcer rec', 10);
554: bcer_rec := p_bcer_rec ;
555: ben_copy_entity_results_api.create_copy_entity_results(
556: p_effective_date => l_effective_date
557: ,p_copy_entity_txn_id => bcer_rec.copy_entity_txn_id

Line 927: hr_utility.set_location('Leaving creating bcer rec', 10);

923: ,p_datetrack_mode => bcer_rec.datetrack_mode
924:
925: ,p_copy_entity_result_id => l_grr_cer_id
926: ,p_object_version_number => l_grr_cer_ovn);
927: hr_utility.set_location('Leaving creating bcer rec', 10);
928: return l_grr_cer_id;
929: end create_bcer_rec ;
930:
931:

Line 1221: --hr_utility.trace_on(NULL,'GUN');

1217: As such reference level is applicable on ly Plan and Plan In program */
1218:
1219: /* Initialize Multi Message Detection */
1220:
1221: --hr_utility.trace_on(NULL,'GUN');
1222:
1223: hr_multi_message.enable_message_list;
1224:
1225: hr_utility.set_location('Inside Create Progression Rules ',10);

Line 1225: hr_utility.set_location('Inside Create Progression Rules ',10);

1221: --hr_utility.trace_on(NULL,'GUN');
1222:
1223: hr_multi_message.enable_message_list;
1224:
1225: hr_utility.set_location('Inside Create Progression Rules ',10);
1226: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1227: hr_utility.set_location('P_gs_Parent_Entity_Result_Id'||P_gs_Parent_Entity_Result_Id,10);
1228: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1229: hr_utility.set_location('P_Prfl_Id'||P_Prfl_Id,10);

Line 1226: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);

1222:
1223: hr_multi_message.enable_message_list;
1224:
1225: hr_utility.set_location('Inside Create Progression Rules ',10);
1226: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1227: hr_utility.set_location('P_gs_Parent_Entity_Result_Id'||P_gs_Parent_Entity_Result_Id,10);
1228: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1229: hr_utility.set_location('P_Prfl_Id'||P_Prfl_Id,10);
1230: hr_utility.set_location('P_Name '||P_Name,10);

Line 1227: hr_utility.set_location('P_gs_Parent_Entity_Result_Id'||P_gs_Parent_Entity_Result_Id,10);

1223: hr_multi_message.enable_message_list;
1224:
1225: hr_utility.set_location('Inside Create Progression Rules ',10);
1226: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1227: hr_utility.set_location('P_gs_Parent_Entity_Result_Id'||P_gs_Parent_Entity_Result_Id,10);
1228: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1229: hr_utility.set_location('P_Prfl_Id'||P_Prfl_Id,10);
1230: hr_utility.set_location('P_Name '||P_Name,10);
1231: hr_utility.set_location('P_Txn_Type'||P_Txn_Type,10);

Line 1228: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);

1224:
1225: hr_utility.set_location('Inside Create Progression Rules ',10);
1226: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1227: hr_utility.set_location('P_gs_Parent_Entity_Result_Id'||P_gs_Parent_Entity_Result_Id,10);
1228: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1229: hr_utility.set_location('P_Prfl_Id'||P_Prfl_Id,10);
1230: hr_utility.set_location('P_Name '||P_Name,10);
1231: hr_utility.set_location('P_Txn_Type'||P_Txn_Type,10);
1232: hr_utility.set_location('p_Txn_Mode'||p_Txn_Mode,10);

Line 1229: hr_utility.set_location('P_Prfl_Id'||P_Prfl_Id,10);

1225: hr_utility.set_location('Inside Create Progression Rules ',10);
1226: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1227: hr_utility.set_location('P_gs_Parent_Entity_Result_Id'||P_gs_Parent_Entity_Result_Id,10);
1228: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1229: hr_utility.set_location('P_Prfl_Id'||P_Prfl_Id,10);
1230: hr_utility.set_location('P_Name '||P_Name,10);
1231: hr_utility.set_location('P_Txn_Type'||P_Txn_Type,10);
1232: hr_utility.set_location('p_Txn_Mode'||p_Txn_Mode,10);
1233: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);

Line 1230: hr_utility.set_location('P_Name '||P_Name,10);

1226: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1227: hr_utility.set_location('P_gs_Parent_Entity_Result_Id'||P_gs_Parent_Entity_Result_Id,10);
1228: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1229: hr_utility.set_location('P_Prfl_Id'||P_Prfl_Id,10);
1230: hr_utility.set_location('P_Name '||P_Name,10);
1231: hr_utility.set_location('P_Txn_Type'||P_Txn_Type,10);
1232: hr_utility.set_location('p_Txn_Mode'||p_Txn_Mode,10);
1233: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1234: hr_utility.set_location('P_Req_opt'||P_Req_opt,19);

Line 1231: hr_utility.set_location('P_Txn_Type'||P_Txn_Type,10);

1227: hr_utility.set_location('P_gs_Parent_Entity_Result_Id'||P_gs_Parent_Entity_Result_Id,10);
1228: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1229: hr_utility.set_location('P_Prfl_Id'||P_Prfl_Id,10);
1230: hr_utility.set_location('P_Name '||P_Name,10);
1231: hr_utility.set_location('P_Txn_Type'||P_Txn_Type,10);
1232: hr_utility.set_location('p_Txn_Mode'||p_Txn_Mode,10);
1233: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1234: hr_utility.set_location('P_Req_opt'||P_Req_opt,19);
1235: hr_utility.set_location('P_Ref_level'||P_Ref_level,19);

Line 1232: hr_utility.set_location('p_Txn_Mode'||p_Txn_Mode,10);

1228: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1229: hr_utility.set_location('P_Prfl_Id'||P_Prfl_Id,10);
1230: hr_utility.set_location('P_Name '||P_Name,10);
1231: hr_utility.set_location('P_Txn_Type'||P_Txn_Type,10);
1232: hr_utility.set_location('p_Txn_Mode'||p_Txn_Mode,10);
1233: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1234: hr_utility.set_location('P_Req_opt'||P_Req_opt,19);
1235: hr_utility.set_location('P_Ref_level'||P_Ref_level,19);
1236: hr_utility.set_location('P_Compute_Score_Flag'||P_Compute_Score_Flag,19);

Line 1233: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);

1229: hr_utility.set_location('P_Prfl_Id'||P_Prfl_Id,10);
1230: hr_utility.set_location('P_Name '||P_Name,10);
1231: hr_utility.set_location('P_Txn_Type'||P_Txn_Type,10);
1232: hr_utility.set_location('p_Txn_Mode'||p_Txn_Mode,10);
1233: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1234: hr_utility.set_location('P_Req_opt'||P_Req_opt,19);
1235: hr_utility.set_location('P_Ref_level'||P_Ref_level,19);
1236: hr_utility.set_location('P_Compute_Score_Flag'||P_Compute_Score_Flag,19);
1237:

Line 1234: hr_utility.set_location('P_Req_opt'||P_Req_opt,19);

1230: hr_utility.set_location('P_Name '||P_Name,10);
1231: hr_utility.set_location('P_Txn_Type'||P_Txn_Type,10);
1232: hr_utility.set_location('p_Txn_Mode'||p_Txn_Mode,10);
1233: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1234: hr_utility.set_location('P_Req_opt'||P_Req_opt,19);
1235: hr_utility.set_location('P_Ref_level'||P_Ref_level,19);
1236: hr_utility.set_location('P_Compute_Score_Flag'||P_Compute_Score_Flag,19);
1237:
1238:

Line 1235: hr_utility.set_location('P_Ref_level'||P_Ref_level,19);

1231: hr_utility.set_location('P_Txn_Type'||P_Txn_Type,10);
1232: hr_utility.set_location('p_Txn_Mode'||p_Txn_Mode,10);
1233: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1234: hr_utility.set_location('P_Req_opt'||P_Req_opt,19);
1235: hr_utility.set_location('P_Ref_level'||P_Ref_level,19);
1236: hr_utility.set_location('P_Compute_Score_Flag'||P_Compute_Score_Flag,19);
1237:
1238:
1239:

Line 1236: hr_utility.set_location('P_Compute_Score_Flag'||P_Compute_Score_Flag,19);

1232: hr_utility.set_location('p_Txn_Mode'||p_Txn_Mode,10);
1233: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1234: hr_utility.set_location('P_Req_opt'||P_Req_opt,19);
1235: hr_utility.set_location('P_Ref_level'||P_Ref_level,19);
1236: hr_utility.set_location('P_Compute_Score_Flag'||P_Compute_Score_Flag,19);
1237:
1238:
1239:
1240: Open BusArea;

Line 1246: hr_utility.set_location('P_Txn_Type = ' || P_Txn_Type ,20);

1242: Close BusArea;
1243:
1244: If P_Txn_Type <> 'GRD' Then
1245:
1246: hr_utility.set_location('P_Txn_Type = ' || P_Txn_Type ,20);
1247:
1248: Open Prtn(P_Gs_Parent_Entity_Result_Id);
1249: Fetch Prtn into l_Prtn_Elig_id, l_Prtn_Copy_Entity_Rslt_Id, l_Prtn_ovn, L_DML_OPERATION;
1250: If Prtn%FOUND Then

Line 1258: hr_utility.set_location('Insert EPA ' || l_InsYN ,30);

1254: End If;
1255: Close Prtn;
1256: L_Prtn_Mirror_result_Id := P_Gs_Parent_Entity_Result_Id;
1257:
1258: hr_utility.set_location('Insert EPA ' || l_InsYN ,30);
1259:
1260: ElsIf P_Txn_Type = 'GRD' Then
1261:
1262: If p_Txn_Mode = 'U' Then

Line 1272: hr_utility.set_location('l_Ref_Level ' || l_Ref_Level ,40);

1268: Fetch Plip_Dtls into l_Pl_Cer_Id;
1269: Close Plip_Dtls;
1270: End If;
1271:
1272: hr_utility.set_location('l_Ref_Level ' || l_Ref_Level ,40);
1273: hr_utility.set_location('p_Ref_Level ' || p_Ref_Level ,50);
1274:
1275: If P_Txn_Mode = 'U' Then
1276: If l_Ref_Level <> P_Ref_Level Then

Line 1273: hr_utility.set_location('p_Ref_Level ' || p_Ref_Level ,50);

1269: Close Plip_Dtls;
1270: End If;
1271:
1272: hr_utility.set_location('l_Ref_Level ' || l_Ref_Level ,40);
1273: hr_utility.set_location('p_Ref_Level ' || p_Ref_Level ,50);
1274:
1275: If P_Txn_Mode = 'U' Then
1276: If l_Ref_Level <> P_Ref_Level Then
1277: If l_Ref_Level = 'PLIP' Then

Line 1297: hr_utility.set_location('Delete Epa ' || L_DelYN ,60);

1293: End If;
1294: End If;
1295: End If;
1296:
1297: hr_utility.set_location('Delete Epa ' || L_DelYN ,60);
1298:
1299: If p_Txn_Mode = 'U' and L_DelYN = 'Y' Then
1300:
1301: -- Delete CEP Row ---

Line 1325: hr_utility.set_location('Deleting Epa .. Cer_id is ' || l_DelPrtn_Copy_Entity_Rslt_Id ,70);

1321: End If;
1322: End If;
1323: Close PrtnElig;
1324:
1325: hr_utility.set_location('Deleting Epa .. Cer_id is ' || l_DelPrtn_Copy_Entity_Rslt_Id ,70);
1326: l_Dml_Opr := NULL;
1327: L_Dml_Opr := Get_Dml_Operation(l_DelPrtn_Copy_Entity_Rslt_Id, 'D');
1328:
1329: If L_Dml_Opr = 'PURGE' then

Line 1385: hr_utility.set_location('DML Operation is INSERT so this ELP is created now', 79);

1381: FETCH Csr_is_elp_present into l_elp_count;
1382: close Csr_is_elp_present;
1383:
1384: if l_elp_count > 0 then
1385: hr_utility.set_location('DML Operation is INSERT so this ELP is created now', 79);
1386:
1387: l_Copy_Entity_Rslt_Id := create_duplicate_elp_tree (
1388: p_copy_entity_txn_id => p_Copy_Entity_txn_Id
1389: ,p_business_group_id => P_Business_Group_Id

Line 1397: hr_utility.set_location('DML Operation is not INSERT so this ELP is from PUI', 79);

1393: set gs_parent_entity_result_id = P_gs_Parent_Entity_Result_Id
1394: ,parent_entity_result_id = P_gs_Parent_Entity_Result_Id
1395: where copy_entity_result_id = l_Copy_Entity_Rslt_Id;
1396: else
1397: hr_utility.set_location('DML Operation is not INSERT so this ELP is from PUI', 79);
1398:
1399: Pqh_Gsp_Hr_To_Stage.Populate_Ep_Hierarchy
1400: (p_copy_entity_txn_id => p_Copy_Entity_txn_Id
1401: ,p_effective_date => P_Effective_Date

Line 1408: hr_utility.set_location('Cer Id of ELP is:'||l_Copy_Entity_Rslt_Id, 79);

1404: ,P_BUSINESS_AREA => Nvl(l_Business_Area,'PQH_GSP_TASK_LIST')
1405: ,p_ep_cer_id => l_Copy_Entity_Rslt_Id);
1406:
1407: End If;
1408: hr_utility.set_location('Cer Id of ELP is:'||l_Copy_Entity_Rslt_Id, 79);
1409: End If;
1410:
1411:
1412: Open TablRoute('EPA');

Line 1419: hr_utility.set_location('Inserting EPA .. L_Prtn_Mirror_result_Id ' || L_Prtn_Mirror_result_Id , 80);

1415:
1416: If l_InsYN = 'Y' Then
1417:
1418: /* This Insert Links the Ben Object with the Eligibility Profiles (CEP) */
1419: hr_utility.set_location('Inserting EPA .. L_Prtn_Mirror_result_Id ' || L_Prtn_Mirror_result_Id , 80);
1420:
1421: Ben_Copy_Entity_Results_Api.CREATE_COPY_ENTITY_RESULTS
1422: (P_EFFECTIVE_DATE => P_Effective_Date,
1423: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,

Line 1455: hr_utility.set_location('Inserting CEP ..l_Prtn_Copy_Entity_Rslt_Id ' || l_Prtn_Copy_Entity_Rslt_Id , 90);

1451: Open PrtnElig;
1452: Fetch PrtnElig into l_PrtnPrfl_Copy_Entity_Rslt_Id, l_Prtn_Elig_Prfl_Ovn, l_Elp_Cer_id, l_Elp_Ovn;
1453:
1454: If PrtnElig%FOUND Then
1455: hr_utility.set_location('Inserting CEP ..l_Prtn_Copy_Entity_Rslt_Id ' || l_Prtn_Copy_Entity_Rslt_Id , 90);
1456:
1457: Ben_Copy_Entity_Results_Api.UPDATE_COPY_ENTITY_RESULTS
1458: (P_EFFECTIVE_DATE => P_Effective_Date,
1459: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,

Line 1484: hr_utility.set_location('Updating CEP ..l_Prtn_Copy_Entity_Rslt_Id ' || l_Prtn_Copy_Entity_Rslt_Id , 90);

1480: P_OBJECT_VERSION_NUMBER => l_Prtn_Elig_Prfl_Ovn);
1481:
1482: Else
1483:
1484: hr_utility.set_location('Updating CEP ..l_Prtn_Copy_Entity_Rslt_Id ' || l_Prtn_Copy_Entity_Rslt_Id , 90);
1485:
1486: Ben_Copy_Entity_Results_Api.CREATE_COPY_ENTITY_RESULTS
1487: (P_EFFECTIVE_DATE => P_Effective_Date,
1488: P_COPY_ENTITY_TXN_ID => p_Copy_Entity_txn_Id,

Line 1527: hr_utility.set_location('Txn Mode is I so going for update', 100);

1523: Close PrtnElig;
1524:
1525: If p_Txn_Mode = 'I' Then
1526:
1527: hr_utility.set_location('Txn Mode is I so going for update', 100);
1528:
1529: /* this update is used to Link the ELP with the BEN Object */
1530: Open ovn;
1531: Fetch ovn into l_ovn;

Line 1543: hr_utility.set_location('Updated gs_paernt successfully', 100);

1539: P_COPY_ENTITY_RESULT_ID => l_Copy_Entity_Rslt_Id,
1540: P_INFORMATION323 => NULL,
1541: P_OBJECT_VERSION_NUMBER => l_ovn);
1542:
1543: hr_utility.set_location('Updated gs_paernt successfully', 100);
1544:
1545: pull_elpro_to_stage(p_copy_entity_txn_id => p_copy_entity_txn_id,
1546: p_eligy_prfl_id => p_Prfl_Id,
1547: p_effective_date => p_effective_date,

Line 1552: --hr_utility.trace_off;

1548: p_business_group_id => p_business_group_id
1549: );
1550:
1551: End If;
1552: --hr_utility.trace_off;
1553: /*
1554: Exception
1555: when hr_multi_message.error_message_exist then
1556:

Line 1557: hr_utility.set_location('Exception handled ', 100);

1553: /*
1554: Exception
1555: when hr_multi_message.error_message_exist then
1556:
1557: hr_utility.set_location('Exception handled ', 100);
1558: --hr_utility.trace_off;
1559: rollback;
1560:
1561: When others then

Line 1558: --hr_utility.trace_off;

1554: Exception
1555: when hr_multi_message.error_message_exist then
1556:
1557: hr_utility.set_location('Exception handled ', 100);
1558: --hr_utility.trace_off;
1559: rollback;
1560:
1561: When others then
1562:

Line 1563: hr_utility.set_location('Unhandled Exception ', 110);

1559: rollback;
1560:
1561: When others then
1562:
1563: hr_utility.set_location('Unhandled Exception ', 110);
1564: --hr_utility.trace_off;
1565: Raise;
1566: */
1567: End Create_Eligibility_Profile;

Line 1564: --hr_utility.trace_off;

1560:
1561: When others then
1562:
1563: hr_utility.set_location('Unhandled Exception ', 110);
1564: --hr_utility.trace_off;
1565: Raise;
1566: */
1567: End Create_Eligibility_Profile;
1568:

Line 1699: hr_utility.set_location('Entering '||l_proc,10);

1695: and table_alias = 'ELP'
1696: and information1 = p_eligy_prfl_id;
1697:
1698: begin
1699: hr_utility.set_location('Entering '||l_proc,10);
1700: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1701: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1702: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id,10);
1703: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);

Line 1700: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);

1696: and information1 = p_eligy_prfl_id;
1697:
1698: begin
1699: hr_utility.set_location('Entering '||l_proc,10);
1700: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1701: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1702: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id,10);
1703: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1704:

Line 1701: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);

1697:
1698: begin
1699: hr_utility.set_location('Entering '||l_proc,10);
1700: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1701: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1702: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id,10);
1703: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1704:
1705: OPEN csr_elp_orignal_in_stage;

Line 1702: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id,10);

1698: begin
1699: hr_utility.set_location('Entering '||l_proc,10);
1700: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1701: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1702: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id,10);
1703: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1704:
1705: OPEN csr_elp_orignal_in_stage;
1706: Fetch csr_elp_orignal_in_stage into l_elp_orignal_in_stage;

Line 1703: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);

1699: hr_utility.set_location('Entering '||l_proc,10);
1700: hr_utility.set_location('p_Copy_Entity_txn_Id '||p_Copy_Entity_txn_Id,10);
1701: hr_utility.set_location('P_Effective_Date'||P_Effective_Date,10);
1702: hr_utility.set_location('p_eligy_prfl_id'||p_eligy_prfl_id,10);
1703: hr_utility.set_location(' P_Business_Group_Id'||P_Business_Group_Id,10);
1704:
1705: OPEN csr_elp_orignal_in_stage;
1706: Fetch csr_elp_orignal_in_stage into l_elp_orignal_in_stage;
1707:

Line 1716: hr_utility.set_location('copying ep hier',20);

1712: end if;
1713:
1714: close csr_elp_orignal_in_stage;
1715: if l_pull_elpro then
1716: hr_utility.set_location('copying ep hier',20);
1717:
1718: ben_plan_design_elpro_module.create_elig_prfl_results
1719: (p_copy_entity_txn_id => p_copy_entity_txn_id
1720: ,p_mirror_src_entity_result_id => l_parent_cer_id

Line 1729: hr_utility.set_location('copied ep hier',20);

1725: ,p_number_of_copies => 1
1726: ,p_object_version_number => l_cer_ovn
1727: ,p_effective_date => p_effective_date
1728: );
1729: hr_utility.set_location('copied ep hier',20);
1730:
1731: BEN_PDW_COPY_BEN_TO_STG.populate_extra_mapping_ELP(
1732: p_copy_entity_txn_id => p_copy_entity_txn_id,
1733: p_effective_date => p_effective_date,

Line 1737: hr_utility.set_location('Done with the mapping',25);

1733: p_effective_date => p_effective_date,
1734: p_elig_prfl_id =>p_eligy_prfl_id
1735: );
1736:
1737: hr_utility.set_location('Done with the mapping',25);
1738: end if;
1739:
1740: -- For elp/child_records which have future records , pdw needs the
1741: -- attribute FUTURE_DATA_EXISTS properly set so that they can properly

Line 1756: hr_utility.set_location('Updated bcer records for future_data_exists flag',25);

1752: where b.copy_entity_txn_id = a.copy_entity_txn_id
1753: and b.table_alias = a.table_alias
1754: and b.information1 = a.information1
1755: and b.information2 = a.information3+1);
1756: hr_utility.set_location('Updated bcer records for future_data_exists flag',25);
1757:
1758: hr_utility.set_location('Leaving '||l_proc,10);
1759: end pull_elpro_to_stage;
1760:

Line 1758: hr_utility.set_location('Leaving '||l_proc,10);

1754: and b.information1 = a.information1
1755: and b.information2 = a.information3+1);
1756: hr_utility.set_location('Updated bcer records for future_data_exists flag',25);
1757:
1758: hr_utility.set_location('Leaving '||l_proc,10);
1759: end pull_elpro_to_stage;
1760:
1761: procedure upd_alias_of_dup
1762: (p_copy_entity_txn_id in number,

Line 1768: hr_utility.set_location('Inside upd_alias_of_dup',10);

1764: )
1765: is
1766: l_rows number;
1767: begin
1768: hr_utility.set_location('Inside upd_alias_of_dup',10);
1769: update ben_copy_entity_results
1770: set table_alias = table_alias||'-DUP'
1771: where copy_entity_txn_id = p_copy_entity_txn_id
1772: and information1 is null

Line 1784: hr_utility.set_location('Total-'||l_rows||'-table aliases updated',10);

1780: ,'ECV'
1781: ,'AGF','CLA','CLF','HWF','LSF','PFF','SVA','RZR','BNG','EGL' );
1782:
1783: l_rows:= sql%rowcount ;
1784: hr_utility.set_location('Total-'||l_rows||'-table aliases updated',10);
1785: end upd_alias_of_dup;
1786:
1787: procedure reset_alias_of_dup
1788: (p_copy_entity_txn_id in number,

Line 1794: hr_utility.set_location('Inside reset_alias_of_dup',10);

1790: )
1791: is
1792: l_rows number;
1793: begin
1794: hr_utility.set_location('Inside reset_alias_of_dup',10);
1795: update ben_copy_entity_results
1796: set table_alias = replace(table_alias,'-DUP',null)
1797: where copy_entity_txn_id = p_copy_entity_txn_id
1798: and information1 is null;

Line 1801: hr_utility.set_location('Total-'||l_rows||'-table aliases updated',10);

1797: where copy_entity_txn_id = p_copy_entity_txn_id
1798: and information1 is null;
1799:
1800: l_rows:= sql%rowcount ;
1801: hr_utility.set_location('Total-'||l_rows||'-table aliases updated',10);
1802: end reset_alias_of_dup;
1803:
1804: procedure prepare_drv_fctr4pdw (
1805: p_copy_entity_txn_id number,