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

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

2339: l_person_extra_info_id NUMBER;
2340: l_ovn NUMBER;
2341: BEGIN
2342: l_proc := 'HR_COMPLETE_APPRAISAL_SS.UPDATE_SUCC_PLAN_EIT';
2343: hr_utility.set_location ('Entering:' || l_proc, 10);
2344:
2345: FOR i IN csr_succ_details (p_appraisal_id)
2346: LOOP
2347: --insert only if potential data entered in appraisal

Line 2369: hr_utility.set_location ('Error in :' || l_proc, 90);

2365: );
2366: EXCEPTION
2367: WHEN OTHERS
2368: THEN
2369: hr_utility.set_location ('Error in :' || l_proc, 90);
2370: hr_utility.TRACE (SUBSTR (SQLERRM, 1, 240));
2371: RAISE;
2372: END;
2373: END IF;

Line 2370: hr_utility.TRACE (SUBSTR (SQLERRM, 1, 240));

2366: EXCEPTION
2367: WHEN OTHERS
2368: THEN
2369: hr_utility.set_location ('Error in :' || l_proc, 90);
2370: hr_utility.TRACE (SUBSTR (SQLERRM, 1, 240));
2371: RAISE;
2372: END;
2373: END IF;
2374: END LOOP;

Line 2376: hr_utility.set_location ('Leaving:' || l_proc, 100);

2372: END;
2373: END IF;
2374: END LOOP;
2375:
2376: hr_utility.set_location ('Leaving:' || l_proc, 100);
2377: END update_succ_plan_eit;
2378:
2379: --
2380: PROCEDURE validate_mandatory_questions (

Line 2495: hr_utility.set_location (' Entering:' || l_proc, 5);

2491: );
2492: BEGIN
2493:
2494: l_proc := 'HR_COMPLETE_APPRAISAL_SS.VALIDATE_MANDTORY_QUESTIONS';
2495: hr_utility.set_location (' Entering:' || l_proc, 5);
2496:
2497: l_result := 'E';
2498:
2499: appr_id := to_number(appraisal_id);

Line 2502: hr_utility.set_location('Not a valid Appraisal ID.', 300);

2498:
2499: appr_id := to_number(appraisal_id);
2500: IF appr_id IS NULL
2501: THEN
2502: hr_utility.set_location('Not a valid Appraisal ID.', 300);
2503: RAISE lv_no_appraisal;
2504: END IF;
2505:
2506: OPEN c_main_appr_mandate_quest (appr_id);

Line 2512: hr_utility.set_location('Main Appraiser(s) have not answered mandatory question(s).', 7777);

2508: INTO l_main_appr_mandate_quest;
2509:
2510: IF(c_main_appr_mandate_quest%FOUND)
2511: THEN
2512: hr_utility.set_location('Main Appraiser(s) have not answered mandatory question(s).', 7777);
2513: IF(l_result = 'E')
2514: THEN
2515: l_result := 'M';
2516: ELSE

Line 2519: hr_utility.set_location('l_result : ' || l_result, 7777);

2515: l_result := 'M';
2516: ELSE
2517: l_result := l_result || '~M';
2518: END IF;
2519: hr_utility.set_location('l_result : ' || l_result, 7777);
2520: END IF;
2521:
2522: OPEN c_particip_mandate_quest (appr_id);
2523: LOOP

Line 2530: hr_utility.set_location('Participant(s) have not answered mandatory question(s).', 7777);

2526: EXIT WHEN c_particip_mandate_quest%NOTFOUND;
2527:
2528: IF(c_particip_mandate_quest%FOUND)
2529: THEN
2530: hr_utility.set_location('Participant(s) have not answered mandatory question(s).', 7777);
2531: hr_utility.set_location('l_particip_mandate_quest : ' || l_particip_mandate_quest, 7777);
2532: IF(l_result = 'E')
2533: THEN
2534: l_result := 'P~' || l_particip_mandate_quest;

Line 2531: hr_utility.set_location('l_particip_mandate_quest : ' || l_particip_mandate_quest, 7777);

2527:
2528: IF(c_particip_mandate_quest%FOUND)
2529: THEN
2530: hr_utility.set_location('Participant(s) have not answered mandatory question(s).', 7777);
2531: hr_utility.set_location('l_particip_mandate_quest : ' || l_particip_mandate_quest, 7777);
2532: IF(l_result = 'E')
2533: THEN
2534: l_result := 'P~' || l_particip_mandate_quest;
2535: ELSE

Line 2538: hr_utility.set_location('l_result : ' || l_result, 7777);

2534: l_result := 'P~' || l_particip_mandate_quest;
2535: ELSE
2536: l_result := l_result || '~P~' || l_particip_mandate_quest;
2537: END IF;
2538: hr_utility.set_location('l_result : ' || l_result, 7777);
2539: END IF;
2540: END LOOP;
2541:
2542: OPEN c_appraisee_mandate_quest (appr_id);

Line 2548: hr_utility.set_location('Appraisee has not answered mandatory question(s).', 7777);

2544: INTO l_appraisee_mandate_quest;
2545:
2546: IF(c_appraisee_mandate_quest%FOUND)
2547: THEN
2548: hr_utility.set_location('Appraisee has not answered mandatory question(s).', 7777);
2549: IF(l_result = 'E')
2550: THEN
2551: l_result := 'A';
2552: ELSE

Line 2555: hr_utility.set_location('l_result : ' || l_result, 7777);

2551: l_result := 'A';
2552: ELSE
2553: l_result := l_result || '~A';
2554: END IF;
2555: hr_utility.set_location('l_result : ' || l_result, 7777);
2556: END IF;
2557:
2558: IF(l_result = 'E')
2559: THEN

Line 2560: hr_utility.set_location('Main Appraiser(s) Participant(s) and Appraisee have answered all mandatory question(s).', 7777);

2556: END IF;
2557:
2558: IF(l_result = 'E')
2559: THEN
2560: hr_utility.set_location('Main Appraiser(s) Participant(s) and Appraisee have answered all mandatory question(s).', 7777);
2561: l_result := 'S';
2562: END IF;
2563:
2564: p_result_out := l_result;

Line 2565: hr_utility.set_location('p_result_out : ' || p_result_out, 7777);

2561: l_result := 'S';
2562: END IF;
2563:
2564: p_result_out := l_result;
2565: hr_utility.set_location('p_result_out : ' || p_result_out, 7777);
2566:
2567: CLOSE c_main_appr_mandate_quest;
2568: CLOSE c_particip_mandate_quest;
2569: CLOSE c_appraisee_mandate_quest;

Line 2570: hr_utility.set_location(' Leaving: ' || l_proc, 20);

2566:
2567: CLOSE c_main_appr_mandate_quest;
2568: CLOSE c_particip_mandate_quest;
2569: CLOSE c_appraisee_mandate_quest;
2570: hr_utility.set_location(' Leaving: ' || l_proc, 20);
2571:
2572: EXCEPTION
2573: WHEN lv_no_appraisal
2574: THEN

Line 2575: hr_utility.set_location(' Invalid Appraisal Id Passed. ', 300);

2571:
2572: EXCEPTION
2573: WHEN lv_no_appraisal
2574: THEN
2575: hr_utility.set_location(' Invalid Appraisal Id Passed. ', 300);
2576: p_result_out := 'E';
2577: WHEN OTHERS
2578: THEN
2579: hr_utility.set_location(' Erroring out on procedure : ' || l_proc, 300);

Line 2579: hr_utility.set_location(' Erroring out on procedure : ' || l_proc, 300);

2575: hr_utility.set_location(' Invalid Appraisal Id Passed. ', 300);
2576: p_result_out := 'E';
2577: WHEN OTHERS
2578: THEN
2579: hr_utility.set_location(' Erroring out on procedure : ' || l_proc, 300);
2580: p_result_out := 'E';
2581: END validate_mandatory_questions;
2582:
2583: --

Line 2629: hr_utility.set_location (' Entering:' || l_proc, 5);

2625: l_source_pk1_value NUMBER;
2626: BEGIN
2627: l_proc := 'HR_COMPLETE_APPRAISAL_SS.COMPLETE_APPR';
2628: --10060770
2629: hr_utility.set_location (' Entering:' || l_proc, 5);
2630: appraisal_id :=
2631: wf_engine.getitemattrnumber (itemtype => item_type,
2632: itemkey => item_key,
2633: aname => 'APPRAISAL_ID',

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

2632: itemkey => item_key,
2633: aname => 'APPRAISAL_ID',
2634: ignore_notfound => TRUE
2635: );
2636: hr_utility.set_location (' Entering:' || l_proc, 10);
2637:
2638: IF appraisal_id IS NULL
2639: THEN
2640: hr_utility.set_location (' Entering:' || l_proc, 20);

Line 2640: hr_utility.set_location (' Entering:' || l_proc, 20);

2636: hr_utility.set_location (' Entering:' || l_proc, 10);
2637:
2638: IF appraisal_id IS NULL
2639: THEN
2640: hr_utility.set_location (' Entering:' || l_proc, 20);
2641: l_log := l_log || 'No Appraisal Id for this WorkFlow Transaction';
2642: RAISE lv_no_appraisal;
2643: END IF;
2644: SAVEPOINT complete_appraisal_status;

Line 2671: hr_utility.set_message (800, 'HR_52256_APR_TEMP_MANDATORY');

2667: l_talent_mang_src_typ;
2668:
2669: IF (c_appr_template_details%NOTFOUND)
2670: THEN
2671: hr_utility.set_message (800, 'HR_52256_APR_TEMP_MANDATORY');
2672: hr_utility.raise_error;
2673: END IF;
2674:
2675: hr_utility.set_location (' Entering:' || l_proc, 30);

Line 2672: hr_utility.raise_error;

2668:
2669: IF (c_appr_template_details%NOTFOUND)
2670: THEN
2671: hr_utility.set_message (800, 'HR_52256_APR_TEMP_MANDATORY');
2672: hr_utility.raise_error;
2673: END IF;
2674:
2675: hr_utility.set_location (' Entering:' || l_proc, 30);
2676: check_item_attribute (item_type, item_key, gv_appr_compl_status);

Line 2675: hr_utility.set_location (' Entering:' || l_proc, 30);

2671: hr_utility.set_message (800, 'HR_52256_APR_TEMP_MANDATORY');
2672: hr_utility.raise_error;
2673: END IF;
2674:
2675: hr_utility.set_location (' Entering:' || l_proc, 30);
2676: check_item_attribute (item_type, item_key, gv_appr_compl_status);
2677: hr_utility.set_location (' Entering:' || l_proc, 35);
2678: check_item_attribute (item_type, item_key, gv_upd_appr_status_log);
2679: hr_utility.set_location (' Entering:' || l_proc, 40);

Line 2677: hr_utility.set_location (' Entering:' || l_proc, 35);

2673: END IF;
2674:
2675: hr_utility.set_location (' Entering:' || l_proc, 30);
2676: check_item_attribute (item_type, item_key, gv_appr_compl_status);
2677: hr_utility.set_location (' Entering:' || l_proc, 35);
2678: check_item_attribute (item_type, item_key, gv_upd_appr_status_log);
2679: hr_utility.set_location (' Entering:' || l_proc, 40);
2680: check_item_attribute (item_type, item_key, gv_apply_asses_comps_log);
2681: hr_utility.set_location (' Entering:' || l_proc, 45);

Line 2679: hr_utility.set_location (' Entering:' || l_proc, 40);

2675: hr_utility.set_location (' Entering:' || l_proc, 30);
2676: check_item_attribute (item_type, item_key, gv_appr_compl_status);
2677: hr_utility.set_location (' Entering:' || l_proc, 35);
2678: check_item_attribute (item_type, item_key, gv_upd_appr_status_log);
2679: hr_utility.set_location (' Entering:' || l_proc, 40);
2680: check_item_attribute (item_type, item_key, gv_apply_asses_comps_log);
2681: hr_utility.set_location (' Entering:' || l_proc, 45);
2682: check_item_attribute (item_type, item_key, gv_create_event_log);
2683: hr_utility.set_location (' Entering:' || l_proc, 50);

Line 2681: hr_utility.set_location (' Entering:' || l_proc, 45);

2677: hr_utility.set_location (' Entering:' || l_proc, 35);
2678: check_item_attribute (item_type, item_key, gv_upd_appr_status_log);
2679: hr_utility.set_location (' Entering:' || l_proc, 40);
2680: check_item_attribute (item_type, item_key, gv_apply_asses_comps_log);
2681: hr_utility.set_location (' Entering:' || l_proc, 45);
2682: check_item_attribute (item_type, item_key, gv_create_event_log);
2683: hr_utility.set_location (' Entering:' || l_proc, 50);
2684: check_item_attribute (item_type, item_key, gv_upd_trn_act_status_log);
2685: hr_utility.set_location (' Entering:' || l_proc, 55);

Line 2683: hr_utility.set_location (' Entering:' || l_proc, 50);

2679: hr_utility.set_location (' Entering:' || l_proc, 40);
2680: check_item_attribute (item_type, item_key, gv_apply_asses_comps_log);
2681: hr_utility.set_location (' Entering:' || l_proc, 45);
2682: check_item_attribute (item_type, item_key, gv_create_event_log);
2683: hr_utility.set_location (' Entering:' || l_proc, 50);
2684: check_item_attribute (item_type, item_key, gv_upd_trn_act_status_log);
2685: hr_utility.set_location (' Entering:' || l_proc, 55);
2686:
2687: -- change the appraisal system status to completed

Line 2685: hr_utility.set_location (' Entering:' || l_proc, 55);

2681: hr_utility.set_location (' Entering:' || l_proc, 45);
2682: check_item_attribute (item_type, item_key, gv_create_event_log);
2683: hr_utility.set_location (' Entering:' || l_proc, 50);
2684: check_item_attribute (item_type, item_key, gv_upd_trn_act_status_log);
2685: hr_utility.set_location (' Entering:' || l_proc, 55);
2686:
2687: -- change the appraisal system status to completed
2688: -- if this errors out then exit from the procudure
2689: -- with out processing furhter

Line 2690: hr_utility.set_location (' Entering:' || l_proc, 60);

2686:
2687: -- change the appraisal system status to completed
2688: -- if this errors out then exit from the procudure
2689: -- with out processing furhter
2690: hr_utility.set_location (' Entering:' || l_proc, 60);
2691: change_appr_status (appraisal_id, item_type, item_key, lv_chg_appr_status_log,
2692: chg_appr_status);
2693: hr_utility.set_location (' Entering:' || l_proc, 70);
2694: set_appr_status_log (item_type,

Line 2693: hr_utility.set_location (' Entering:' || l_proc, 70);

2689: -- with out processing furhter
2690: hr_utility.set_location (' Entering:' || l_proc, 60);
2691: change_appr_status (appraisal_id, item_type, item_key, lv_chg_appr_status_log,
2692: chg_appr_status);
2693: hr_utility.set_location (' Entering:' || l_proc, 70);
2694: set_appr_status_log (item_type,
2695: item_key,
2696: chg_appr_status,
2697: gv_upd_appr_status_log,

Line 2700: hr_utility.set_location (' Entering:' || l_proc, 75);

2696: chg_appr_status,
2697: gv_upd_appr_status_log,
2698: lv_chg_appr_status_log
2699: );
2700: hr_utility.set_location (' Entering:' || l_proc, 75);
2701: -- SSHR Attachment feature changes : 8814550
2702: hr_utility.set_location ( 'merge_attachments Start : l_sel_person_id = '
2703: || l_sel_person_id
2704: || ' '

Line 2702: hr_utility.set_location ( 'merge_attachments Start : l_sel_person_id = '

2698: lv_chg_appr_status_log
2699: );
2700: hr_utility.set_location (' Entering:' || l_proc, 75);
2701: -- SSHR Attachment feature changes : 8814550
2702: hr_utility.set_location ( 'merge_attachments Start : l_sel_person_id = '
2703: || l_sel_person_id
2704: || ' '
2705: || l_proc,
2706: 76

Line 2713: hr_utility.set_location ( 'merge_attachments End: l_attach_status = '

2709: p_source_pk1_value => l_source_pk1_value,
2710: p_dest_pk1_value => l_sel_person_id,
2711: p_return_status => l_attach_status
2712: );
2713: hr_utility.set_location ( 'merge_attachments End: l_attach_status = '
2714: || l_attach_status
2715: || ' '
2716: || l_proc,
2717: 76

Line 2723: hr_utility.set_location (' Entering:' || l_proc, 77);

2719:
2720: -- create and event and add a performance record
2721: IF l_available_flag IS NULL
2722: THEN
2723: hr_utility.set_location (' Entering:' || l_proc, 77);
2724: update_personal_profile := fnd_profile.VALUE ('HR_APPLY_COMPETENCIES_TO_PERSON');
2725: l_talent_mang_src_typ := fnd_profile.VALUE ('HR_TALENT_MGMT_SRC_TYPE');
2726: END IF;
2727:

Line 2728: hr_utility.set_location (' Entering:' || l_proc, 80);

2724: update_personal_profile := fnd_profile.VALUE ('HR_APPLY_COMPETENCIES_TO_PERSON');
2725: l_talent_mang_src_typ := fnd_profile.VALUE ('HR_TALENT_MGMT_SRC_TYPE');
2726: END IF;
2727:
2728: hr_utility.set_location (' Entering:' || l_proc, 80);
2729: p_new_appraisal := is_new_appraisal (item_type, item_key);
2730:
2731: IF (update_personal_profile IS NOT NULL AND update_personal_profile = 'Y')
2732: THEN

Line 2733: hr_utility.set_location (' Entering:' || l_proc, 85);

2729: p_new_appraisal := is_new_appraisal (item_type, item_key);
2730:
2731: IF (update_personal_profile IS NOT NULL AND update_personal_profile = 'Y')
2732: THEN
2733: hr_utility.set_location (' Entering:' || l_proc, 85);
2734: apply_to_personal_profile (appraisal_id,
2735: lv_apply_pers_comps_log,
2736: apply_pers_profile_status,
2737: p_new_appraisal,

Line 2740: hr_utility.set_location (' Entering:' || l_proc, 90);

2736: apply_pers_profile_status,
2737: p_new_appraisal,
2738: l_talent_mang_src_typ
2739: );
2740: hr_utility.set_location (' Entering:' || l_proc, 90);
2741: set_appr_status_log (item_type,
2742: item_key,
2743: apply_pers_profile_status,
2744: gv_apply_asses_comps_log,

Line 2747: hr_utility.set_location (' Entering:' || l_proc, 95);

2743: apply_pers_profile_status,
2744: gv_apply_asses_comps_log,
2745: lv_apply_pers_comps_log
2746: );
2747: hr_utility.set_location (' Entering:' || l_proc, 95);
2748: END IF;
2749:
2750: ------------ Update Succession Plan Details
2751: IF NVL (fnd_profile.VALUE ('HR_SUCCESSION_MGMT_LICENSED'), 'N') = 'Y'

Line 2753: hr_utility.set_location ('before update_succ_plan_eit:' || l_proc, 96);

2749:
2750: ------------ Update Succession Plan Details
2751: IF NVL (fnd_profile.VALUE ('HR_SUCCESSION_MGMT_LICENSED'), 'N') = 'Y'
2752: THEN
2753: hr_utility.set_location ('before update_succ_plan_eit:' || l_proc, 96);
2754: update_succ_plan_eit (appraisal_id);
2755: hr_utility.set_location ('before update_succ_plan_eit:' || l_proc, 96);
2756: END IF;
2757:

Line 2755: hr_utility.set_location ('before update_succ_plan_eit:' || l_proc, 96);

2751: IF NVL (fnd_profile.VALUE ('HR_SUCCESSION_MGMT_LICENSED'), 'N') = 'Y'
2752: THEN
2753: hr_utility.set_location ('before update_succ_plan_eit:' || l_proc, 96);
2754: update_succ_plan_eit (appraisal_id);
2755: hr_utility.set_location ('before update_succ_plan_eit:' || l_proc, 96);
2756: END IF;
2757:
2758: ------------
2759:

Line 2762: hr_utility.set_location (' Entering:' || l_proc, 100);

2758: ------------
2759:
2760: -- update the OTA status
2761: --update_train_component_status(appraisal_id, item_type, item_key, l_log, p_result_out);
2762: hr_utility.set_location (' Entering:' || l_proc, 100);
2763: update_train_component_status (appraisal_id,
2764: lv_upd_train_comps_status_log,
2765: upd_train_comps_status,
2766: p_new_appraisal

Line 2768: hr_utility.set_location (' Entering:' || l_proc, 105);

2764: lv_upd_train_comps_status_log,
2765: upd_train_comps_status,
2766: p_new_appraisal
2767: );
2768: hr_utility.set_location (' Entering:' || l_proc, 105);
2769: set_appr_status_log (item_type,
2770: item_key,
2771: upd_train_comps_status,
2772: gv_upd_trn_act_status_log,

Line 2775: hr_utility.set_location (' Entering:' || l_proc, 110);

2771: upd_train_comps_status,
2772: gv_upd_trn_act_status_log,
2773: lv_upd_train_comps_status_log
2774: );
2775: hr_utility.set_location (' Entering:' || l_proc, 110);
2776: create_event (appraisal_id,
2777: lv_upd_create_event_status_log,
2778: upd_create_event_status,
2779: p_new_appraisal

Line 2781: hr_utility.set_location (' Entering:' || l_proc, 115);

2777: lv_upd_create_event_status_log,
2778: upd_create_event_status,
2779: p_new_appraisal
2780: );
2781: hr_utility.set_location (' Entering:' || l_proc, 115);
2782: set_appr_status_log (item_type,
2783: item_key,
2784: upd_create_event_status,
2785: gv_create_event_log,

Line 2788: hr_utility.set_location (' Entering:' || l_proc, 120);

2784: upd_create_event_status,
2785: gv_create_event_log,
2786: lv_upd_create_event_status_log
2787: );
2788: hr_utility.set_location (' Entering:' || l_proc, 120);
2789: -- add the following line to disable multi messaging for fixing bug#5947176
2790: hr_multi_message.disable_message_list;
2791: -- END changes for bug#5947176
2792: post_appraisal_completion (appraisal_id);

Line 2800: hr_utility.set_location (' Entering:' || l_proc, 125);

2796: OR upd_train_comps_status = 'W'
2797: OR upd_create_event_status = 'W'
2798: )
2799: THEN
2800: hr_utility.set_location (' Entering:' || l_proc, 125);
2801: p_result_out := 'W';
2802: ELSE
2803: hr_utility.set_location (' Entering:' || l_proc, 130);
2804: p_result_out := 'S';

Line 2803: hr_utility.set_location (' Entering:' || l_proc, 130);

2799: THEN
2800: hr_utility.set_location (' Entering:' || l_proc, 125);
2801: p_result_out := 'W';
2802: ELSE
2803: hr_utility.set_location (' Entering:' || l_proc, 130);
2804: p_result_out := 'S';
2805: END IF;
2806: EXCEPTION
2807: -- when there is an exception it is due to change appraisal status

Line 2814: hr_utility.set_location (' Entering:' || l_proc, 200);

2810: -- can read and display corresponding message / warning.
2811: WHEN lv_no_appraisal
2812: THEN
2813: p_result_out := 'E';
2814: hr_utility.set_location (' Entering:' || l_proc, 200);
2815: set_appr_status_log (item_type,
2816: item_key,
2817: 'E',
2818: gv_upd_appr_status_log,

Line 2823: hr_utility.set_location (' Entering:' || l_proc, 300);

2819: lv_chg_appr_status_log
2820: );
2821: WHEN OTHERS
2822: THEN
2823: hr_utility.set_location (' Entering:' || l_proc, 300);
2824: ROLLBACK TO complete_appraisal_status;
2825: p_result_out := 'E';
2826: set_appr_status_log (item_type,
2827: item_key,