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_WPM_MASS_APR_PUSH dependencies on HR_UTILITY

Line 6: g_debug BOOLEAN := hr_utility.debug_enabled;

2: /* $Header: pewpmaprpush.pkb 120.53.12020000.6 2013/04/23 11:04:16 schowdhu ship $ */
3: -- Package Variables
4: --
5: g_package VARCHAR2 (33) := 'hr_wpm_mass_apr_push.';
6: g_debug BOOLEAN := hr_utility.debug_enabled;
7: g_num_errors NUMBER := 0;
8: g_max_errors NUMBER;
9: --
10: -- Proprietory debugging. Allows for concurrent request output, etc.

Line 280: hr_utility.set_location (SUBSTR (l_msg, 1, 70), p_location);

276: IF g_dbg_type = g_pipe OR g_debug
277: THEN
278: IF p_location IS NOT NULL
279: THEN
280: hr_utility.set_location (SUBSTR (l_msg, 1, 70), p_location);
281: ELSE
282: hr_utility.TRACE (SUBSTR (l_msg, 1, 70));
283: END IF;
284: ELSIF g_dbg_type = g_fnd_log

Line 282: hr_utility.TRACE (SUBSTR (l_msg, 1, 70));

278: IF p_location IS NOT NULL
279: THEN
280: hr_utility.set_location (SUBSTR (l_msg, 1, 70), p_location);
281: ELSE
282: hr_utility.TRACE (SUBSTR (l_msg, 1, 70));
283: END IF;
284: ELSIF g_dbg_type = g_fnd_log
285: THEN
286: IF p_location IS NOT NULL

Line 3200: hr_utility.set_location ('p_batch_action_id: ' || p_batch_action_id, 11);

3196: BEGIN
3197: initialize_logging (p_action_parameter_group_id => NULL,
3198: p_log_output => p_log_output
3199: );
3200: hr_utility.set_location ('p_batch_action_id: ' || p_batch_action_id, 11);
3201: op ('Entering: ' || l_proc, g_regular_log, 10);
3202: op ('p_batch_action_id: ' || p_batch_action_id, g_regular_log, 20);
3203: errbuf := NULL;
3204: retcode := success;

Line 3268: hr_utility.set_location ( 'l_wpm_person_action_id: '

3264: || l_to_nma_role
3265: || ').',
3266: g_regular_log
3267: );
3268: hr_utility.set_location ( 'l_wpm_person_action_id: '
3269: || l_wpm_person_action_id,
3270: 11
3271: );
3272: hr_utility.set_location ('l_appraisal_id: ' || l_appraisal_id, 11);

Line 3272: hr_utility.set_location ('l_appraisal_id: ' || l_appraisal_id, 11);

3268: hr_utility.set_location ( 'l_wpm_person_action_id: '
3269: || l_wpm_person_action_id,
3270: 11
3271: );
3272: hr_utility.set_location ('l_appraisal_id: ' || l_appraisal_id, 11);
3273: hr_utility.set_location ( 'l_appraisee_person_id: '
3274: || l_appraisee_person_id,
3275: 11
3276: );

Line 3273: hr_utility.set_location ( 'l_appraisee_person_id: '

3269: || l_wpm_person_action_id,
3270: 11
3271: );
3272: hr_utility.set_location ('l_appraisal_id: ' || l_appraisal_id, 11);
3273: hr_utility.set_location ( 'l_appraisee_person_id: '
3274: || l_appraisee_person_id,
3275: 11
3276: );
3277: hr_utility.set_location ( 'l_main_appraiser_id: '

Line 3277: hr_utility.set_location ( 'l_main_appraiser_id: '

3273: hr_utility.set_location ( 'l_appraisee_person_id: '
3274: || l_appraisee_person_id,
3275: 11
3276: );
3277: hr_utility.set_location ( 'l_main_appraiser_id: '
3278: || l_main_appraiser_id,
3279: 11
3280: );
3281: hr_utility.set_location ( 'l_new_main_appraiser_id: '

Line 3281: hr_utility.set_location ( 'l_new_main_appraiser_id: '

3277: hr_utility.set_location ( 'l_main_appraiser_id: '
3278: || l_main_appraiser_id,
3279: 11
3280: );
3281: hr_utility.set_location ( 'l_new_main_appraiser_id: '
3282: || l_new_main_appraiser_id,
3283: 11
3284: );
3285: hr_utility.set_location ('l_to_wkr_role: ' || l_to_wkr_role, 11);

Line 3285: hr_utility.set_location ('l_to_wkr_role: ' || l_to_wkr_role, 11);

3281: hr_utility.set_location ( 'l_new_main_appraiser_id: '
3282: || l_new_main_appraiser_id,
3283: 11
3284: );
3285: hr_utility.set_location ('l_to_wkr_role: ' || l_to_wkr_role, 11);
3286: hr_utility.set_location ('l_to_wkr_name: ' || l_to_wkr_name, 11);
3287: hr_utility.set_location ('l_to_mgr_role: ' || l_to_mgr_role, 11);
3288: hr_utility.set_location ('l_to_mgr_name: ' || l_to_mgr_name, 11);
3289: hr_utility.set_location ('l_to_nma_role: ' || l_to_nma_role, 11);

Line 3286: hr_utility.set_location ('l_to_wkr_name: ' || l_to_wkr_name, 11);

3282: || l_new_main_appraiser_id,
3283: 11
3284: );
3285: hr_utility.set_location ('l_to_wkr_role: ' || l_to_wkr_role, 11);
3286: hr_utility.set_location ('l_to_wkr_name: ' || l_to_wkr_name, 11);
3287: hr_utility.set_location ('l_to_mgr_role: ' || l_to_mgr_role, 11);
3288: hr_utility.set_location ('l_to_mgr_name: ' || l_to_mgr_name, 11);
3289: hr_utility.set_location ('l_to_nma_role: ' || l_to_nma_role, 11);
3290: hr_utility.set_location ('l_to_nma_name: ' || l_to_nma_name, 11);

Line 3287: hr_utility.set_location ('l_to_mgr_role: ' || l_to_mgr_role, 11);

3283: 11
3284: );
3285: hr_utility.set_location ('l_to_wkr_role: ' || l_to_wkr_role, 11);
3286: hr_utility.set_location ('l_to_wkr_name: ' || l_to_wkr_name, 11);
3287: hr_utility.set_location ('l_to_mgr_role: ' || l_to_mgr_role, 11);
3288: hr_utility.set_location ('l_to_mgr_name: ' || l_to_mgr_name, 11);
3289: hr_utility.set_location ('l_to_nma_role: ' || l_to_nma_role, 11);
3290: hr_utility.set_location ('l_to_nma_name: ' || l_to_nma_name, 11);
3291:

Line 3288: hr_utility.set_location ('l_to_mgr_name: ' || l_to_mgr_name, 11);

3284: );
3285: hr_utility.set_location ('l_to_wkr_role: ' || l_to_wkr_role, 11);
3286: hr_utility.set_location ('l_to_wkr_name: ' || l_to_wkr_name, 11);
3287: hr_utility.set_location ('l_to_mgr_role: ' || l_to_mgr_role, 11);
3288: hr_utility.set_location ('l_to_mgr_name: ' || l_to_mgr_name, 11);
3289: hr_utility.set_location ('l_to_nma_role: ' || l_to_nma_role, 11);
3290: hr_utility.set_location ('l_to_nma_name: ' || l_to_nma_name, 11);
3291:
3292: IF (l_plan_id IS NOT NULL)

Line 3289: hr_utility.set_location ('l_to_nma_role: ' || l_to_nma_role, 11);

3285: hr_utility.set_location ('l_to_wkr_role: ' || l_to_wkr_role, 11);
3286: hr_utility.set_location ('l_to_wkr_name: ' || l_to_wkr_name, 11);
3287: hr_utility.set_location ('l_to_mgr_role: ' || l_to_mgr_role, 11);
3288: hr_utility.set_location ('l_to_mgr_name: ' || l_to_mgr_name, 11);
3289: hr_utility.set_location ('l_to_nma_role: ' || l_to_nma_role, 11);
3290: hr_utility.set_location ('l_to_nma_name: ' || l_to_nma_name, 11);
3291:
3292: IF (l_plan_id IS NOT NULL)
3293: THEN -- need not check for the standard appraisals.

Line 3290: hr_utility.set_location ('l_to_nma_name: ' || l_to_nma_name, 11);

3286: hr_utility.set_location ('l_to_wkr_name: ' || l_to_wkr_name, 11);
3287: hr_utility.set_location ('l_to_mgr_role: ' || l_to_mgr_role, 11);
3288: hr_utility.set_location ('l_to_mgr_name: ' || l_to_mgr_name, 11);
3289: hr_utility.set_location ('l_to_nma_role: ' || l_to_nma_role, 11);
3290: hr_utility.set_location ('l_to_nma_name: ' || l_to_nma_name, 11);
3291:
3292: IF (l_plan_id IS NOT NULL)
3293: THEN -- need not check for the standard appraisals.
3294: OPEN in_plan (l_plan_id, l_new_main_appraiser_id);

Line 3352: hr_utility.set_location ( 'blockedactivityid: '

3348: CLOSE get_instance_label;
3349:
3350: op ('blockedactivityid: ' || blockedactivityid, g_regular_log);
3351: op ('l_instance_label: ' || l_instance_label, g_regular_log);
3352: hr_utility.set_location ( 'blockedactivityid: '
3353: || blockedactivityid,
3354: 11
3355: );
3356: hr_utility.set_location ( 'l_instance_label: '

Line 3356: hr_utility.set_location ( 'l_instance_label: '

3352: hr_utility.set_location ( 'blockedactivityid: '
3353: || blockedactivityid,
3354: 11
3355: );
3356: hr_utility.set_location ( 'l_instance_label: '
3357: || l_instance_label,
3358: 11
3359: );
3360: wf_engine.setitemattrtext (l_item_type,

Line 3415: hr_utility.set_location ( '1)ln_notification_id:: '

3411: );
3412: op ('1)ln_notification_id: ' || ln_notification_id,
3413: g_regular_log
3414: );
3415: hr_utility.set_location ( '1)ln_notification_id:: '
3416: || ln_notification_id,
3417: 11
3418: );
3419: wf_notification.denormalize_notification (ln_notification_id,

Line 3451: hr_utility.set_location ( '2)ln_notification_id:: '

3447: );
3448: op ('2) ln_notification_id: ' || ln_notification_id,
3449: g_regular_log
3450: );
3451: hr_utility.set_location ( '2)ln_notification_id:: '
3452: || ln_notification_id,
3453: 11
3454: );
3455: wf_notification.denormalize_notification (ln_notification_id,

Line 3483: hr_utility.set_location ( '3)ln_notification_id:: '

3479: );
3480: op ('3) ln_notification_id: ' || ln_notification_id,
3481: g_regular_log
3482: );
3483: hr_utility.set_location ( '3)ln_notification_id:: '
3484: || ln_notification_id,
3485: 11
3486: );
3487: wf_notification.denormalize_notification (ln_notification_id,

Line 3508: hr_utility.set_location ('l_no_of_errors:: ' || l_no_of_errors,

3504: THEN
3505: l_no_of_errors := l_no_of_errors + 1;
3506: ecode := SQLCODE;
3507: emesg := SUBSTR (SQLERRM, 1, 4000);
3508: hr_utility.set_location ('l_no_of_errors:: ' || l_no_of_errors,
3509: 11
3510: );
3511: hr_utility.set_location ('ecode: ' || ecode, 11);
3512: hr_utility.set_location ('emesg:: ' || emesg, 11);

Line 3511: hr_utility.set_location ('ecode: ' || ecode, 11);

3507: emesg := SUBSTR (SQLERRM, 1, 4000);
3508: hr_utility.set_location ('l_no_of_errors:: ' || l_no_of_errors,
3509: 11
3510: );
3511: hr_utility.set_location ('ecode: ' || ecode, 11);
3512: hr_utility.set_location ('emesg:: ' || emesg, 11);
3513:
3514: UPDATE per_wpm_person_actions
3515: SET processing_status = 'ERROR',

Line 3512: hr_utility.set_location ('emesg:: ' || emesg, 11);

3508: hr_utility.set_location ('l_no_of_errors:: ' || l_no_of_errors,
3509: 11
3510: );
3511: hr_utility.set_location ('ecode: ' || ecode, 11);
3512: hr_utility.set_location ('emesg:: ' || emesg, 11);
3513:
3514: UPDATE per_wpm_person_actions
3515: SET processing_status = 'ERROR',
3516: message_number = ecode,

Line 3559: hr_utility.set_location ('Error ' || SQLCODE, 11);

3555: WHERE wpm_batch_action_id = l_current_wpm_batch_action_id;
3556:
3557: op ('Error ' || SQLCODE, g_regular_log);
3558: op ('Error ' || SUBSTR (SQLERRM, 1, 200), g_regular_log);
3559: hr_utility.set_location ('Error ' || SQLCODE, 11);
3560: hr_utility.set_location ('Error ' || SQLERRM, 11);
3561: COMMIT;
3562: errbuf := g_errbuf;
3563: retcode := error;

Line 3560: hr_utility.set_location ('Error ' || SQLERRM, 11);

3556:
3557: op ('Error ' || SQLCODE, g_regular_log);
3558: op ('Error ' || SUBSTR (SQLERRM, 1, 200), g_regular_log);
3559: hr_utility.set_location ('Error ' || SQLCODE, 11);
3560: hr_utility.set_location ('Error ' || SQLERRM, 11);
3561: COMMIT;
3562: errbuf := g_errbuf;
3563: retcode := error;
3564: END ma_change_cp;