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_WPM_MASS_APR_PUSH

Line 1: PACKAGE BODY hr_wpm_mass_apr_push AS

1: PACKAGE BODY hr_wpm_mass_apr_push AS
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.';

Line 5: g_package VARCHAR2 (33) := 'hr_wpm_mass_apr_push.';

1: PACKAGE BODY hr_wpm_mass_apr_push AS
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: --

Line 1337: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=

1333: -- g_wpm_person_actions(log_records_index).MESSAGE_TEXT := 'NO_SCORE_CARD_WITH_THIS_ID';
1334: -- WPM Logging Changes Post Review
1335: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
1336: 'THERE IS NO SCORECARD WITH THIS ID';
1337: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
1338: 'ERROR';
1339: -- Error
1340: fnd_file.put_line (fnd_file.LOG, 'NO_SCORE_CARD_WITH_THIS_ID');
1341: RAISE no_score_card_with_this_id;

Line 1368: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=

1364: -- g_wpm_person_actions(log_records_index).MESSAGE_TEXT := 'NO_ASSIGNMENT_WITH_THIS_ID';
1365: -- WPM Logging Changes Post Review
1366: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
1367: 'THERE IS NO ASSIGNMENT WITH THIS ID';
1368: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
1369: 'ERROR';
1370: -- Error
1371: fnd_file.put_line (fnd_file.LOG, 'NO_ASSIGNMENT_WITH_THIS_ID');
1372: RAISE no_assignment_with_this_id;

Line 1397: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=

1393: -- g_wpm_person_actions(log_records_index).MESSAGE_TEXT := 'NO_APPRL_TEMPL_WITH_THIS_ID';
1394: -- WPM Logging Changes Post Review
1395: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
1396: 'THERE IS NO APPRAISAL TEMPLATE WITH THIS ID';
1397: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
1398: 'ERROR';
1399: -- Error
1400: fnd_file.put_line (fnd_file.LOG, 'NO_APPRL_TEMPL_WITH_THIS_ID');
1401: RAISE no_apprl_templ_with_this_id;

Line 1452: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=

1448: -- g_wpm_person_actions(log_records_index).MESSAGE_TEXT := 'APPRAISAL_SETUP_ISSUE';
1449: -- WPM Logging Changes Post Review
1450: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
1451: 'THERE IS AN APPRAISAL SET UP ISSUE';
1452: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
1453: 'ERROR';
1454: -- Error
1455: fnd_file.put_line (fnd_file.LOG, 'APPRAISAL_SETUP_ISSUE');
1456: RAISE appraisal_setup_issue;

Line 1548: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id :=

1544: IF find_appraisal%FOUND
1545: THEN
1546: l_found_appraisal := TRUE;
1547: -- WPM Logging Changes Post Review
1548: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id :=
1549: l_found_appraisal_id;
1550: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
1551: 'SUCCESS';
1552:

Line 1550: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=

1546: l_found_appraisal := TRUE;
1547: -- WPM Logging Changes Post Review
1548: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id :=
1549: l_found_appraisal_id;
1550: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
1551: 'SUCCESS';
1552:
1553: -- Success
1554: IF g_dbg

Line 1615: hr_wpm_mass_apr_push.g_wpm_person_actions

1611: g_wpm_person_actions (log_records_index).message_number :=
1612: 'OTHER';
1613: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
1614: SQLERRM;
1615: hr_wpm_mass_apr_push.g_wpm_person_actions
1616: (log_records_index).processing_status :=
1617: 'ERROR';
1618:
1619: -- Error

Line 1678: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=

1674: -- g_wpm_person_actions(log_records_index).MESSAGE_TEXT := 'HR_50297_WPM_CP_ERROR';
1675: -- WPM Logging Changes Post Review
1676: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
1677: 'UNABLE TO CREATE APPRAISAL FOR THIS PERSON AS MAIN APPRAISER COULD NOT BE IDENTIFIED';
1678: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
1679: 'ERROR';
1680: -- Error
1681: fnd_file.put_line (fnd_file.LOG,
1682: 'Unable to create appraisal for : '

Line 1759: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id :=

1755: p_appraisal_system_status => p_appraisal_status,
1756: p_plan_id => p_plan_id
1757: );
1758: -- WPM Logging Changes Post Review
1759: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id :=
1760: l_apprl_id;
1761: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
1762: 'SUCCESS';
1763:

Line 1761: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=

1757: );
1758: -- WPM Logging Changes Post Review
1759: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id :=
1760: l_apprl_id;
1761: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
1762: 'SUCCESS';
1763:
1764: -- Success
1765: IF g_dbg

Line 1884: hr_wpm_mass_apr_push.g_wpm_person_actions

1880: g_wpm_person_actions (log_records_index).message_number :=
1881: 'OTHER';
1882: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
1883: SQLERRM;
1884: hr_wpm_mass_apr_push.g_wpm_person_actions
1885: (log_records_index).processing_status :=
1886: 'ERROR';
1887:
1888: -- Error

Line 1976: hr_wpm_mass_apr_push.g_wpm_person_actions

1972: g_wpm_person_actions (log_records_index).message_number :=
1973: 'OTHER';
1974: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
1975: SQLERRM;
1976: hr_wpm_mass_apr_push.g_wpm_person_actions
1977: (log_records_index).processing_status :=
1978: 'ERROR';
1979: -- Error
1980: hr_wpm_mass_apr_push.g_wpm_person_actions

Line 1980: hr_wpm_mass_apr_push.g_wpm_person_actions

1976: hr_wpm_mass_apr_push.g_wpm_person_actions
1977: (log_records_index).processing_status :=
1978: 'ERROR';
1979: -- Error
1980: hr_wpm_mass_apr_push.g_wpm_person_actions
1981: (log_records_index).processing_status :=
1982: 'ERROR';
1983:
1984: -- Error

Line 2029: hr_wpm_mass_apr_push.g_wpm_person_actions

2025: g_wpm_person_actions (log_records_index).message_number :=
2026: 'OTHER';
2027: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
2028: SQLERRM;
2029: hr_wpm_mass_apr_push.g_wpm_person_actions
2030: (log_records_index).processing_status :=
2031: 'ERROR';
2032:
2033: -- Error

Line 2081: hr_wpm_mass_apr_push.g_wpm_person_actions

2077: g_wpm_person_actions (log_records_index).message_number :=
2078: 'OTHER';
2079: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
2080: SQLERRM;
2081: hr_wpm_mass_apr_push.g_wpm_person_actions
2082: (log_records_index).processing_status :=
2083: 'ERROR';
2084:
2085: -- Error

Line 2112: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=

2108: -- WPM Logging Changes
2109: g_wpm_person_actions (log_records_index).MESSAGE_TYPE := 'E';
2110: g_wpm_person_actions (log_records_index).message_number := 'OTHER';
2111: g_wpm_person_actions (log_records_index).MESSAGE_TEXT := SQLERRM;
2112: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
2113: 'ERROR';
2114:
2115: -- Error
2116: IF g_dbg

Line 2540: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS

2536: LOOP
2537: -- WPM Logging Changes
2538: log_records_index := curr_scorecard.assignment_id;
2539:
2540: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS
2541: (curr_scorecard.assignment_id)
2542: THEN
2543: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).wpm_person_action_id :=
2544: -1;

Line 2543: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).wpm_person_action_id :=

2539:
2540: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS
2541: (curr_scorecard.assignment_id)
2542: THEN
2543: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).wpm_person_action_id :=
2544: -1;
2545: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).wpm_batch_action_id :=
2546: l_current_wpm_batch_action_id;
2547: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).person_id :=

Line 2545: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).wpm_batch_action_id :=

2541: (curr_scorecard.assignment_id)
2542: THEN
2543: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).wpm_person_action_id :=
2544: -1;
2545: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).wpm_batch_action_id :=
2546: l_current_wpm_batch_action_id;
2547: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).person_id :=
2548: curr_scorecard.person_id;
2549: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).assignment_id :=

Line 2547: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).person_id :=

2543: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).wpm_person_action_id :=
2544: -1;
2545: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).wpm_batch_action_id :=
2546: l_current_wpm_batch_action_id;
2547: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).person_id :=
2548: curr_scorecard.person_id;
2549: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).assignment_id :=
2550: curr_scorecard.assignment_id;
2551: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).business_group_id :=

Line 2549: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).assignment_id :=

2545: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).wpm_batch_action_id :=
2546: l_current_wpm_batch_action_id;
2547: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).person_id :=
2548: curr_scorecard.person_id;
2549: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).assignment_id :=
2550: curr_scorecard.assignment_id;
2551: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).business_group_id :=
2552: curr_scorecard.business_group_id;
2553: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=

Line 2551: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).business_group_id :=

2547: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).person_id :=
2548: curr_scorecard.person_id;
2549: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).assignment_id :=
2550: curr_scorecard.assignment_id;
2551: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).business_group_id :=
2552: curr_scorecard.business_group_id;
2553: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
2554: 'P';
2555: -- Processing

Line 2553: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=

2549: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).assignment_id :=
2550: curr_scorecard.assignment_id;
2551: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).business_group_id :=
2552: curr_scorecard.business_group_id;
2553: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
2554: 'P';
2555: -- Processing
2556: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table := 'PER_PERSONAL_SCORECARDS';
2557: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id := curr_scorecard.scorecard_id;

Line 2556: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table := 'PER_PERSONAL_SCORECARDS';

2552: curr_scorecard.business_group_id;
2553: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
2554: 'P';
2555: -- Processing
2556: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table := 'PER_PERSONAL_SCORECARDS';
2557: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id := curr_scorecard.scorecard_id;
2558: -- WPM Logging Changes Post Review
2559: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table :=
2560: 'PER_APPRAISALS';

Line 2557: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id := curr_scorecard.scorecard_id;

2553: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).processing_status :=
2554: 'P';
2555: -- Processing
2556: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table := 'PER_PERSONAL_SCORECARDS';
2557: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id := curr_scorecard.scorecard_id;
2558: -- WPM Logging Changes Post Review
2559: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table :=
2560: 'PER_APPRAISALS';
2561: END IF;

Line 2559: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table :=

2555: -- Processing
2556: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table := 'PER_PERSONAL_SCORECARDS';
2557: -- hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_id := curr_scorecard.scorecard_id;
2558: -- WPM Logging Changes Post Review
2559: hr_wpm_mass_apr_push.g_wpm_person_actions (log_records_index).transaction_ref_table :=
2560: 'PER_APPRAISALS';
2561: END IF;
2562:
2563: IF (curr_scorecard.status_code <> 'TRANSFER_OUT')

Line 2602: hr_wpm_mass_apr_push.g_wpm_person_actions

2598:
2599: IF (l_elig_obj_id IS NULL)
2600: THEN
2601: -- WPM Logging Changes
2602: hr_wpm_mass_apr_push.g_wpm_person_actions
2603: (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=
2604: 'Y';
2605: END IF;
2606:

Line 2603: (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=

2599: IF (l_elig_obj_id IS NULL)
2600: THEN
2601: -- WPM Logging Changes
2602: hr_wpm_mass_apr_push.g_wpm_person_actions
2603: (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=
2604: 'Y';
2605: END IF;
2606:
2607: IF (l_elig_obj_id IS NOT NULL)

Line 2649: hr_wpm_mass_apr_push.g_wpm_person_actions

2645: g_wpm_person_actions (log_records_index).message_number :=
2646: 'OTHER';
2647: g_wpm_person_actions (log_records_index).MESSAGE_TEXT :=
2648: SQLERRM;
2649: hr_wpm_mass_apr_push.g_wpm_person_actions
2650: (log_records_index).processing_status :=
2651: 'ERROR';
2652: -- Error
2653: op ('Error while evaluating eligibility for: ',

Line 2746: IF hr_wpm_mass_apr_push.g_wpm_person_actions

2742: l_plan_aprsl_pds_index :=
2743: g_plan_aprsl_pds_tbl.NEXT (l_plan_aprsl_pds_index);
2744:
2745: -- WPM Logging Changes
2746: IF hr_wpm_mass_apr_push.g_wpm_person_actions
2747: (log_records_index).processing_status =
2748: 'P'
2749: THEN
2750: hr_wpm_mass_apr_push.g_wpm_person_actions

Line 2750: hr_wpm_mass_apr_push.g_wpm_person_actions

2746: IF hr_wpm_mass_apr_push.g_wpm_person_actions
2747: (log_records_index).processing_status =
2748: 'P'
2749: THEN
2750: hr_wpm_mass_apr_push.g_wpm_person_actions
2751: (log_records_index).processing_status :=
2752: 'SUCCESS';
2753: -- Success
2754: END IF;

Line 3565: END hr_wpm_mass_apr_push;

3561: COMMIT;
3562: errbuf := g_errbuf;
3563: retcode := error;
3564: END ma_change_cp;
3565: END hr_wpm_mass_apr_push;