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

Line 220: --hr_utility.trace_on(null,'ORACLE');

216: ;
217:
218: BEGIN
219:
220: --hr_utility.trace_on(null,'ORACLE');
221: hr_utility.trace('Run in Diagnostic Mode: ' || p_diagnostic_mode);
222: hr_utility.trace('Proceed with Migration when Effort Reports are not Approved: ' || p_ignore_appr);
223: hr_utility.trace('Proceed with Migration when Adjustment Batches are Pending: ' || p_ignore_da);
224: hr_utility.trace('Element Set Name for Effort Report Elements: ' || p_element_set_name);

Line 221: hr_utility.trace('Run in Diagnostic Mode: ' || p_diagnostic_mode);

217:
218: BEGIN
219:
220: --hr_utility.trace_on(null,'ORACLE');
221: hr_utility.trace('Run in Diagnostic Mode: ' || p_diagnostic_mode);
222: hr_utility.trace('Proceed with Migration when Effort Reports are not Approved: ' || p_ignore_appr);
223: hr_utility.trace('Proceed with Migration when Adjustment Batches are Pending: ' || p_ignore_da);
224: hr_utility.trace('Element Set Name for Effort Report Elements: ' || p_element_set_name);
225:

Line 222: hr_utility.trace('Proceed with Migration when Effort Reports are not Approved: ' || p_ignore_appr);

218: BEGIN
219:
220: --hr_utility.trace_on(null,'ORACLE');
221: hr_utility.trace('Run in Diagnostic Mode: ' || p_diagnostic_mode);
222: hr_utility.trace('Proceed with Migration when Effort Reports are not Approved: ' || p_ignore_appr);
223: hr_utility.trace('Proceed with Migration when Adjustment Batches are Pending: ' || p_ignore_da);
224: hr_utility.trace('Element Set Name for Effort Report Elements: ' || p_element_set_name);
225:
226: fnd_msg_pub.initialize;

Line 223: hr_utility.trace('Proceed with Migration when Adjustment Batches are Pending: ' || p_ignore_da);

219:
220: --hr_utility.trace_on(null,'ORACLE');
221: hr_utility.trace('Run in Diagnostic Mode: ' || p_diagnostic_mode);
222: hr_utility.trace('Proceed with Migration when Effort Reports are not Approved: ' || p_ignore_appr);
223: hr_utility.trace('Proceed with Migration when Adjustment Batches are Pending: ' || p_ignore_da);
224: hr_utility.trace('Element Set Name for Effort Report Elements: ' || p_element_set_name);
225:
226: fnd_msg_pub.initialize;
227:

Line 224: hr_utility.trace('Element Set Name for Effort Report Elements: ' || p_element_set_name);

220: --hr_utility.trace_on(null,'ORACLE');
221: hr_utility.trace('Run in Diagnostic Mode: ' || p_diagnostic_mode);
222: hr_utility.trace('Proceed with Migration when Effort Reports are not Approved: ' || p_ignore_appr);
223: hr_utility.trace('Proceed with Migration when Adjustment Batches are Pending: ' || p_ignore_da);
224: hr_utility.trace('Element Set Name for Effort Report Elements: ' || p_element_set_name);
225:
226: fnd_msg_pub.initialize;
227:
228: -- Check if the migration has already occurred. If not Proceed further else do nothing

Line 230: hr_utility.trace('Effort Report Already Migrated');

226: fnd_msg_pub.initialize;
227:
228: -- Check if the migration has already occurred. If not Proceed further else do nothing
229: IF psp_general.IS_EFFORT_REPORT_MIGRATED THEN
230: hr_utility.trace('Effort Report Already Migrated');
231: raise l_er_already_migrated;
232: ELSE
233: IF p_ignore_appr= 'N' THEN
234: hr_utility.trace('Checking for Pending Effort Report: START');

Line 234: hr_utility.trace('Checking for Pending Effort Report: START');

230: hr_utility.trace('Effort Report Already Migrated');
231: raise l_er_already_migrated;
232: ELSE
233: IF p_ignore_appr= 'N' THEN
234: hr_utility.trace('Checking for Pending Effort Report: START');
235:
236: OPEN effort_master_csr;
237: FETCH effort_master_csr BULK COLLECT into eff_master_rec.effort_report_id, eff_master_rec.person_id,
238: eff_master_rec.full_name, eff_master_rec.start_date, eff_master_rec.end_date,eff_master_rec.business_group_name;

Line 242: hr_utility.trace('Pending Effort reports count =' || l_appr_exists);

238: eff_master_rec.full_name, eff_master_rec.start_date, eff_master_rec.end_date,eff_master_rec.business_group_name;
239: CLOSE effort_master_csr;
240:
241: l_appr_exists := eff_master_rec.effort_report_id.count;
242: hr_utility.trace('Pending Effort reports count =' || l_appr_exists);
243:
244: FOR i in 1..l_appr_exists
245: LOOP
246: fnd_message.set_name('PSP', 'PSP_EFF_REP_PEND_STATUS');

Line 261: hr_utility.trace('Checking for Pending Effort Report: END');

257: eff_master_rec.full_name.delete;
258: eff_master_rec.start_date.delete;
259: eff_master_rec.end_date.delete;
260:
261: hr_utility.trace('Checking for Pending Effort Report: END');
262: /* check for Pending distribution adjustments -> check for unapproved DA batches
263: for whom effort reports with previous 'N'/'S' status exist. Dump that information */
264: IF p_ignore_da = 'N' THEN
265: hr_utility.trace('Checking for Pending distribution adjustments: START');

Line 265: hr_utility.trace('Checking for Pending distribution adjustments: START');

261: hr_utility.trace('Checking for Pending Effort Report: END');
262: /* check for Pending distribution adjustments -> check for unapproved DA batches
263: for whom effort reports with previous 'N'/'S' status exist. Dump that information */
264: IF p_ignore_da = 'N' THEN
265: hr_utility.trace('Checking for Pending distribution adjustments: START');
266: OPEN pending_da_csr;
267: FETCH PENDING_DA_CSR BULK COLLECT INTO eff_master_rec.effort_report_id, eff_master_rec.person_id,
268: eff_master_rec.full_name,
269: eff_master_rec.start_date,

Line 274: hr_utility.trace('Pending distribution adjustments =' || l_pending_da );

270: eff_master_rec.end_date, eff_master_rec.da_batch,eff_master_rec.business_group_name;
271: CLOSE pending_da_csr;
272:
273: l_pending_da := eff_master_rec.effort_report_id.count;
274: hr_utility.trace('Pending distribution adjustments =' || l_pending_da );
275: FOR i in 1..l_pending_da
276: LOOP
277: fnd_message.set_name('PSP', 'PSP_EFF_DA_PEND_STATUS');
278: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));

Line 292: hr_utility.trace('Checking for Pending distribution adjustments: END');

288: eff_master_rec.full_name.delete;
289: eff_master_rec.start_date.delete;
290: eff_master_rec.end_date.delete;
291:
292: hr_utility.trace('Checking for Pending distribution adjustments: END');
293:
294: /* check for Pending Distribution Adjustment Batch that has not been summarized and transferred
295: Dump that information */
296:

Line 297: hr_utility.trace('Checking for distribution adjustments not S and T: START');

293:
294: /* check for Pending Distribution Adjustment Batch that has not been summarized and transferred
295: Dump that information */
296:
297: hr_utility.trace('Checking for distribution adjustments not S and T: START');
298:
299: OPEN pending_summ_trans_csr;
300: FETCH pending_summ_trans_csr BULK COLLECT INTO eff_master_rec.effort_report_id, eff_master_rec.person_id,
301: eff_master_rec.full_name,

Line 307: hr_utility.trace('distribution adjustments not S and T ='|| l_pending_summ_trans);

303: eff_master_rec.end_date, eff_master_rec.da_batch,eff_master_rec.business_group_name;
304: CLOSE pending_summ_trans_csr;
305:
306: l_pending_summ_trans := eff_master_rec.effort_report_id.count;
307: hr_utility.trace('distribution adjustments not S and T ='|| l_pending_summ_trans);
308: FOR i in 1..l_pending_summ_trans
309: LOOP
310: fnd_message.set_name('PSP', 'PSP_EFF_DA_NOT_SUMM_TRANS');
311: fnd_message.set_token('DABATCH',eff_master_rec.da_batch(i));

Line 325: hr_utility.trace('Checking for distribution adjustments not S and T: END');

321: eff_master_rec.person_id.delete;
322: eff_master_rec.full_name.delete;
323: eff_master_rec.start_date.delete;
324: eff_master_rec.end_date.delete;
325: hr_utility.trace('Checking for distribution adjustments not S and T: END');
326: END IF;
327:
328:
329: IF (p_diagnostic_mode='N') and ((l_pending_da <>0) or (l_appr_exists <> 0) or (l_pending_summ_trans <> 0)) then

Line 334: hr_utility.trace('Migration:START');

330: raise l_migration_not_allowed;
331: END IF;
332: IF (p_diagnostic_mode='N') and (l_pending_da=0) and (l_appr_exists=0) and (l_pending_summ_trans = 0) then
333:
334: hr_utility.trace('Migration:START');
335:
336: /* Regular Mode, No pending Distribution Adjustments, No pending Effort Reports */
337:
338: -- fnd_file.put_line( FND_FILE.LOG, ' Before ES');

Line 340: hr_utility.trace('Set the Element Set Name');

336: /* Regular Mode, No pending Distribution Adjustments, No pending Effort Reports */
337:
338: -- fnd_file.put_line( FND_FILE.LOG, ' Before ES');
339:
340: hr_utility.trace('Set the Element Set Name');
341: IF p_element_Set_name is null then
342:
343: l_element_Set_name :='Effort Reporting Element Set';
344:

Line 360: hr_utility.trace(' Open element_striped_by_bg_csr');

356: IF (l_is_element_set_alredy_exist = 1) and (p_element_set_name is not null) then
357: raise l_element_set_alredy_exist;
358: END IF;
359:
360: hr_utility.trace(' Open element_striped_by_bg_csr');
361:
362: LOOP
363: FETCH element_striped_by_bg_csr into l_business_group_id;
364: EXIT when element_striped_by_bg_csr%NOTFOUND;

Line 382: hr_utility.trace(' Create Elements: pay_element_sets_pkg.insert_row');

378: OPEN effort_element_csr(l_business_group_id);
379: FETCH effort_element_csr BULK COLLECT into eff_element_rec.element_type_id;
380: CLOSE effort_element_csr;
381:
382: hr_utility.trace(' Create Elements: pay_element_sets_pkg.insert_row');
383:
384: l_rowid := null;
385: l_element_Set_id := null;
386: pay_element_sets_pkg.insert_row(l_rowid, l_element_Set_id, l_business_group_id, null, l_element_set_name,'C', 'LD Eff Reports Migration Set', null, null);

Line 401: hr_utility.trace(' Create Elements: pay_element_type_rules_pkg.insert_row');

397:
398: For i in 1..eff_element_rec.element_type_id.count
399:
400: LOOP
401: hr_utility.trace(' Create Elements: pay_element_type_rules_pkg.insert_row');
402:
403: l_rowid:=NULL;
404: pay_element_type_rules_pkg.insert_row(l_rowid, eff_element_rec.element_type_id(i), l_element_Set_id, 'I',
405: sysdate, fnd_global.user_id, fnd_global.user_id, fnd_global.user_id, sysdate);

Line 415: hr_utility.trace(' Create Elements: END');

411:
412: END LOOP;
413:
414: CLOSE element_striped_by_bg_csr;
415: hr_utility.trace(' Create Elements: END');
416:
417:
418: /* Delete the obsolete menu items */
419:

Line 422: hr_utility.trace(' Delete Menus : START');

418: /* Delete the obsolete menu items */
419:
420: -- fnd_file.put_line( FND_FILE.LOG, ' Before menu delete ');
421:
422: hr_utility.trace(' Delete Menus : START');
423: hr_utility.trace(' Delete Menu : Effort Report Period Summary');
424:
425: IF (fnd_function_security.menu_entry_exists('PSP_EFFORT_MENU', '', 'PSPERPRD')) THEN
426: l_err_phase:=1;

Line 423: hr_utility.trace(' Delete Menu : Effort Report Period Summary');

419:
420: -- fnd_file.put_line( FND_FILE.LOG, ' Before menu delete ');
421:
422: hr_utility.trace(' Delete Menus : START');
423: hr_utility.trace(' Delete Menu : Effort Report Period Summary');
424:
425: IF (fnd_function_security.menu_entry_exists('PSP_EFFORT_MENU', '', 'PSPERPRD')) THEN
426: l_err_phase:=1;
427: fnd_function_security.menu_entry(

Line 437: hr_utility.trace(' Delete Menu : Effort Report Creation');

433: delete_flag => 'Y');
434:
435:
436: END IF;
437: hr_utility.trace(' Delete Menu : Effort Report Creation');
438:
439: IF (fnd_function_security.menu_entry_exists('PSP_EFFORT_MENU', '', 'PSPERCRT')) THEN
440: l_err_phase:=2;
441: fnd_function_security.menu_entry(

Line 451: hr_utility.trace(' Delete Menu :Adhoc Effort Report Creation');

447: delete_flag => 'Y');
448: END IF;
449:
450:
451: hr_utility.trace(' Delete Menu :Adhoc Effort Report Creation');
452: IF (fnd_function_security.menu_entry_exists('PSP_EFFORT_MENU', '', 'PSPERADH')) THEN
453: l_err_phase:=3;
454: fnd_function_security.menu_entry(
455: menu_name => 'PSP_EFFORT_MENU',

Line 464: hr_utility.trace(' Delete Menu :Review Effort Report');

460: delete_flag => 'Y');
461: END IF;
462:
463:
464: hr_utility.trace(' Delete Menu :Review Effort Report');
465: IF (fnd_function_security.menu_entry_exists('PSP_EFFORT_MENU', '', 'PSPERRVW')) THEN
466: l_err_phase:=4;
467: fnd_function_security.menu_entry(
468: menu_name => 'PSP_EFFORT_MENU',

Line 476: hr_utility.trace(' Delete Menu :Review Effort Report');

472: description => '',
473: delete_flag => 'Y');
474: END IF;
475:
476: hr_utility.trace(' Delete Menu :Review Effort Report');
477: IF (fnd_function_security.menu_entry_exists('PSP_WORKFLOW_MENU', '', 'PSPERRVW')) THEN
478: l_err_phase:=4;
479: fnd_function_security.menu_entry(
480: menu_name => 'PSP_WORKFLOW_MENU',

Line 488: hr_utility.trace(' Delete Menu :Effort Report Aging');

484: description => '',
485: delete_flag => 'Y');
486: END IF;
487:
488: hr_utility.trace(' Delete Menu :Effort Report Aging');
489: IF (fnd_function_security.menu_entry_exists('PSP_EFFORT_MENU', '', 'PSPERAGI')) THEN
490: l_err_phase:=5;
491: fnd_function_security.menu_entry(
492: menu_name => 'PSP_EFFORT_MENU',

Line 500: hr_utility.trace(' Delete Menu :Effort Report Messages');

496: description => '',
497: delete_flag => 'Y');
498: END IF;
499:
500: hr_utility.trace(' Delete Menu :Effort Report Messages');
501: IF (fnd_function_security.menu_entry_exists('PSP_EFFORT_MENU', '', 'PSPERMES')) THEN
502: l_err_phase:=6;
503: fnd_function_security.menu_entry(
504: menu_name => 'PSP_EFFORT_MENU',

Line 512: hr_utility.trace(' Delete Menu :Setup: Effort Report Element Types');

508: description => '',
509: delete_flag => 'Y');
510: END IF;
511:
512: hr_utility.trace(' Delete Menu :Setup: Effort Report Element Types');
513: IF (fnd_function_security.menu_entry_exists('PSP_OTHERS', '', 'PSPSUEFF')) THEN
514: l_err_phase:=7;
515: fnd_function_security.menu_entry(
516: menu_name => 'PSP_OTHERS',

Line 524: hr_utility.trace(' Delete Menu :Setup: Create Notification Users');

520: description => '',
521: delete_flag => 'Y');
522: END IF;
523:
524: hr_utility.trace(' Delete Menu :Setup: Create Notification Users');
525: IF (fnd_function_security.menu_entry_exists('PSP_OTHERS', '', 'PSPSUCU')) THEN
526: l_err_phase:=8;
527: fnd_function_security.menu_entry(
528: menu_name => 'PSP_OTHERS',

Line 542: hr_utility.trace(' Insert into psp_upgrade_115');

538:
539: select psp_upgrade_115_s.nextval
540: into l_current_run
541: from dual;
542: hr_utility.trace(' Insert into psp_upgrade_115');
543:
544: INSERT into psp_upgrade_115(run_id, phase,object_name,date_time,status,error_message)
545: VALUES (l_current_run,10000,'PSP_UPGRADE_115',sysdate,'R','Migrated Effort Reports') ;
546:

Line 550: hr_utility.trace(' Migration Successful');

546:
547: COMMIT;
548:
549: END IF;
550: hr_utility.trace(' Migration Successful');
551: hr_utility.trace_off;
552: END IF;
553: EXCEPTION
554: WHEN l_er_already_migrated then

Line 551: hr_utility.trace_off;

547: COMMIT;
548:
549: END IF;
550: hr_utility.trace(' Migration Successful');
551: hr_utility.trace_off;
552: END IF;
553: EXCEPTION
554: WHEN l_er_already_migrated then
555: ROLLBACK;

Line 569: hr_utility.trace_off;

565: l_msg_buf := Fnd_Message.Get ;
566: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
567: fnd_msg_pub.add;
568: retCode :=2;
569: hr_utility.trace_off;
570: WHEN l_migration_not_allowed then
571: ROLLBACK;
572: fnd_message.set_name('PSP', 'PSP_ER_MIGRATION_NOT_ALLOWED');
573: l_msg_buf := Fnd_Message.Get ;

Line 577: hr_utility.trace_off;

573: l_msg_buf := Fnd_Message.Get ;
574: fnd_file.put_line (FND_FILE.LOG, l_msg_buf );
575: fnd_msg_pub.add;
576: retCode :=2;
577: hr_utility.trace_off;
578: WHEN OTHERS THEN
579: ROLLBACK;
580: fnd_message.set_name('PSP','PSP_SQL_ERROR');
581: fnd_message.set_token('SQLERROR',sqlerrm||l_err_phase);

Line 586: hr_utility.trace_off;

582: fnd_msg_pub.add;
583: psp_message_s.print_error(p_mode => FND_FILE.LOG,
584: p_print_header => FND_API.G_TRUE);
585: retCode :=2;
586: hr_utility.trace_off;
587: END migrate_eff_reports;
588: END psp_upgrade_eff_reports;