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_PERF_MGMT_PLAN_INTERNAL dependencies on HR_WPM_MASS_APR_PUSH

Line 1819: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

1815: EXCEPTION
1816: WHEN OTHERS
1817: THEN
1818: -- WPM Logging changes
1819: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
1820: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
1821: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
1822: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
1823: -- Error

Line 1820: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';

1816: WHEN OTHERS
1817: THEN
1818: -- WPM Logging changes
1819: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
1820: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
1821: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
1822: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
1823: -- Error
1824:

Line 1821: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;

1817: THEN
1818: -- WPM Logging changes
1819: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
1820: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
1821: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
1822: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
1823: -- Error
1824:
1825: IF g_dbg

Line 1822: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';

1818: -- WPM Logging changes
1819: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
1820: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
1821: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
1822: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
1823: -- Error
1824:
1825: IF g_dbg
1826: THEN

Line 1939: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

1935: EXCEPTION
1936: WHEN OTHERS
1937: THEN
1938: -- WPM Logging changes
1939: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
1940: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
1941: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
1942: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
1943: -- Error

Line 1940: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';

1936: WHEN OTHERS
1937: THEN
1938: -- WPM Logging changes
1939: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
1940: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
1941: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
1942: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
1943: -- Error
1944:

Line 1941: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;

1937: THEN
1938: -- WPM Logging changes
1939: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
1940: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
1941: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
1942: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
1943: -- Error
1944:
1945: IF g_dbg

Line 1942: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';

1938: -- WPM Logging changes
1939: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
1940: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
1941: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
1942: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
1943: -- Error
1944:
1945: IF g_dbg
1946: THEN

Line 4675: -- HR_WPM_MASS_APR_PUSH.l_current_wpm_batch_action_id := per_wpm_batch_actions_s.NEXTVAL;

4671: RAISE;
4672: END;
4673:
4674: -- WPM Logging Changes
4675: -- HR_WPM_MASS_APR_PUSH.l_current_wpm_batch_action_id := per_wpm_batch_actions_s.NEXTVAL;
4676: SELECT per_wpm_batch_actions_s.NEXTVAL
4677: INTO l_wpm_batch_action_id
4678: FROM DUAL;
4679:

Line 4680: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id := l_wpm_batch_action_id;

4676: SELECT per_wpm_batch_actions_s.NEXTVAL
4677: INTO l_wpm_batch_action_id
4678: FROM DUAL;
4679:
4680: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id := l_wpm_batch_action_id;
4681:
4682: INSERT INTO per_wpm_batch_actions
4683: (wpm_batch_action_id, conc_request_id, conc_program_name, plan_id, appraisal_period_id, status, start_date,
4684: end_date

Line 4737: hr_wpm_mass_apr_push.g_wpm_person_actions.DELETE;

4733: END IF;
4734:
4735: -- WPM Logging Changes Post Review
4736: -- to avoid caching issues
4737: hr_wpm_mass_apr_push.g_wpm_person_actions.DELETE;
4738: hr_wpm_mass_apr_push.log_records_index := NULL;
4739: --
4740: -- Call the publish plan
4741: --

Line 4738: hr_wpm_mass_apr_push.log_records_index := NULL;

4734:
4735: -- WPM Logging Changes Post Review
4736: -- to avoid caching issues
4737: hr_wpm_mass_apr_push.g_wpm_person_actions.DELETE;
4738: hr_wpm_mass_apr_push.log_records_index := NULL;
4739: --
4740: -- Call the publish plan
4741: --
4742: publish_plan (p_effective_date => fnd_date.canonical_to_date (p_effective_date),

Line 4757: hr_wpm_mass_apr_push.print_cache ();

4753: errbuf := g_errbuf;
4754: retcode := g_retcode;
4755: --
4756: -- WPM Logging Changes
4757: hr_wpm_mass_apr_push.print_cache ();
4758:
4759: UPDATE per_wpm_batch_actions
4760: SET end_date = SYSDATE,
4761: status = DECODE (g_retcode, 0, 'SUCCESS', 'WARNING')

Line 4762: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

4758:
4759: UPDATE per_wpm_batch_actions
4760: SET end_date = SYSDATE,
4761: status = DECODE (g_retcode, 0, 'SUCCESS', 'WARNING')
4762: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
4763:
4764: COMMIT;
4765: --
4766: EXCEPTION

Line 4771: hr_wpm_mass_apr_push.print_cache ();

4767: WHEN OTHERS
4768: THEN
4769: ROLLBACK;
4770: -- WPM Logging Changes
4771: hr_wpm_mass_apr_push.print_cache ();
4772:
4773: UPDATE per_wpm_batch_actions
4774: SET status = 'ERROR',
4775: end_date = SYSDATE

Line 4776: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

4772:
4773: UPDATE per_wpm_batch_actions
4774: SET status = 'ERROR',
4775: end_date = SYSDATE
4776: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
4777:
4778: COMMIT;
4779:
4780: --

Line 5055: hr_wpm_mass_apr_push.log_records_index := g_qual_pop_tbl (l_qual_pop_index).assignment_id;

5051:
5052: WHILE (l_qual_pop_index IS NOT NULL)
5053: LOOP
5054: -- WPM Logging Changes
5055: hr_wpm_mass_apr_push.log_records_index := g_qual_pop_tbl (l_qual_pop_index).assignment_id;
5056:
5057: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
5058: THEN
5059: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

Line 5057: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)

5053: LOOP
5054: -- WPM Logging Changes
5055: hr_wpm_mass_apr_push.log_records_index := g_qual_pop_tbl (l_qual_pop_index).assignment_id;
5056:
5057: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
5058: THEN
5059: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
5060: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
5061: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

Line 5059: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

5055: hr_wpm_mass_apr_push.log_records_index := g_qual_pop_tbl (l_qual_pop_index).assignment_id;
5056:
5057: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
5058: THEN
5059: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
5060: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
5061: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
5062: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
5063: g_qual_pop_tbl (l_qual_pop_index).person_id;

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

5056:
5057: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
5058: THEN
5059: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
5060: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
5061: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
5062: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
5063: g_qual_pop_tbl (l_qual_pop_index).person_id;
5064: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=

Line 5061: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

5057: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
5058: THEN
5059: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
5060: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
5061: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
5062: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
5063: g_qual_pop_tbl (l_qual_pop_index).person_id;
5064: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
5065: g_qual_pop_tbl (l_qual_pop_index).assignment_id;

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

5058: THEN
5059: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
5060: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
5061: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
5062: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
5063: g_qual_pop_tbl (l_qual_pop_index).person_id;
5064: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
5065: g_qual_pop_tbl (l_qual_pop_index).assignment_id;
5066: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=

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

5060: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
5061: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
5062: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
5063: g_qual_pop_tbl (l_qual_pop_index).person_id;
5064: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
5065: g_qual_pop_tbl (l_qual_pop_index).assignment_id;
5066: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
5067: g_qual_pop_tbl (l_qual_pop_index).business_group_id;
5068: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'P';

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

5062: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
5063: g_qual_pop_tbl (l_qual_pop_index).person_id;
5064: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
5065: g_qual_pop_tbl (l_qual_pop_index).assignment_id;
5066: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
5067: g_qual_pop_tbl (l_qual_pop_index).business_group_id;
5068: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'P';
5069: -- Processing
5070: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).transaction_ref_table :=

Line 5068: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'P';

5064: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
5065: g_qual_pop_tbl (l_qual_pop_index).assignment_id;
5066: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
5067: g_qual_pop_tbl (l_qual_pop_index).business_group_id;
5068: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'P';
5069: -- Processing
5070: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).transaction_ref_table :=
5071: 'PER_PERSONAL_SCORECARDS';
5072: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status := 'Y';

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

5066: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
5067: g_qual_pop_tbl (l_qual_pop_index).business_group_id;
5068: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'P';
5069: -- Processing
5070: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).transaction_ref_table :=
5071: 'PER_PERSONAL_SCORECARDS';
5072: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status := 'Y';
5073: -- Default handling cases of plan republish
5074: END IF;

Line 5072: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status := 'Y';

5068: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'P';
5069: -- Processing
5070: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).transaction_ref_table :=
5071: 'PER_PERSONAL_SCORECARDS';
5072: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status := 'Y';
5073: -- Default handling cases of plan republish
5074: END IF;
5075:
5076: --

Line 5105: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status := 'Y';

5101:
5102: IF (l_elig_obj_id IS NULL)
5103: THEN
5104: -- WPM Logging Changes
5105: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status := 'Y';
5106: END IF;
5107:
5108: IF (l_elig_obj_id IS NOT NULL) -- Eligiblity profile is chosen
5109: THEN

Line 5130: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=

5126: g_qual_pop_tbl (l_qual_pop_index).business_group_id,
5127: 'Y' ---KMG -- Added to Allow CWK's
5128: );
5129: -- WPM Logging Changes
5130: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=
5131: l_check_elig_person;
5132: EXCEPTION
5133: WHEN OTHERS
5134: THEN

Line 5137: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=

5133: WHEN OTHERS
5134: THEN
5135: l_check_elig_person := 'N';
5136: -- WPM Logging Changes
5137: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=
5138: l_check_elig_person;
5139: -- WPM Logging Changes Post Review
5140: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
5141: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number :=

Line 5140: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

5136: -- WPM Logging Changes
5137: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=
5138: l_check_elig_person;
5139: -- WPM Logging Changes Post Review
5140: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
5141: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number :=
5142: 'OTHER';
5143: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT :=
5144: SQLERRM;

Line 5141: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number :=

5137: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=
5138: l_check_elig_person;
5139: -- WPM Logging Changes Post Review
5140: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
5141: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number :=
5142: 'OTHER';
5143: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT :=
5144: SQLERRM;
5145: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status :=

Line 5143: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT :=

5139: -- WPM Logging Changes Post Review
5140: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
5141: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number :=
5142: 'OTHER';
5143: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT :=
5144: SQLERRM;
5145: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status :=
5146: 'ERROR';
5147: -- Error

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

5141: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number :=
5142: 'OTHER';
5143: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT :=
5144: SQLERRM;
5145: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status :=
5146: 'ERROR';
5147: -- Error
5148: op ( 'Eligibility Check errored for: '
5149: || l_person_name

Line 5724: IF hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status = 'P'

5720: --
5721: l_qual_pop_index := g_qual_pop_tbl.NEXT (l_qual_pop_index);
5722:
5723: -- WPM Logging changes
5724: IF hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status = 'P'
5725: THEN
5726: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';
5727: -- Success
5728: END IF;

Line 5726: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';

5722:
5723: -- WPM Logging changes
5724: IF hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status = 'P'
5725: THEN
5726: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';
5727: -- Success
5728: END IF;
5729: --
5730: END LOOP;

Line 5816: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

5812: WHEN OTHERS
5813: THEN
5814: -- WPM Logging changes
5815: /*
5816: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
5817: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_NUMBER := 'OTHER';
5818: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
5819: */
5820: IF g_dbg

Line 5817: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_NUMBER := 'OTHER';

5813: THEN
5814: -- WPM Logging changes
5815: /*
5816: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
5817: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_NUMBER := 'OTHER';
5818: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
5819: */
5820: IF g_dbg
5821: THEN

Line 5818: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;

5814: -- WPM Logging changes
5815: /*
5816: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
5817: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_NUMBER := 'OTHER';
5818: hr_wpm_mass_apr_push.g_wpm_person_actions(hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
5819: */
5820: IF g_dbg
5821: THEN
5822: op ('Leaving:' || l_proc, g_regular_log, 90);

Line 6067: hr_wpm_mass_apr_push.submit_appraisal_cp

6063: END IF;
6064:
6065: IF l_process_date >= TRUNC (SYSDATE) AND l_submit_new_req
6066: THEN
6067: hr_wpm_mass_apr_push.submit_appraisal_cp
6068: (p_effective_date => l_process_date,
6069: p_start_date => l_process_date_char,
6070: p_plan_id => p_plan_id,
6071: p_appraisal_period_id => g_plan_aprsl_pds_tbl (l_plan_aprsl_pds_index).appraisal_period_id,

Line 7686: hr_wpm_mass_apr_push.create_appraisal_for_person

7682:
7683: --23-Jun-2009 schowdhu Eligibility Profile Enhc.-start
7684: IF (l_check_period_elig = 'Y' OR (l_check_period_elig IS NULL AND l_elig_obj_id IS NULL))
7685: THEN
7686: hr_wpm_mass_apr_push.create_appraisal_for_person
7687: (p_score_card_id => l_scorecard_id,
7688: p_appraisal_templ_id => g_plan_aprsl_pds_tbl (l_plan_aprsl_pds_index).appraisal_template_id,
7689: p_effective_date => p_effective_date, --to be validated
7690: p_appraisal_start_date => g_plan_aprsl_pds_tbl (l_plan_aprsl_pds_index).start_date,

Line 10099: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;

10095:
10096: CLOSE csr_sc;
10097:
10098: BEGIN
10099: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10100: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10101: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10102: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10103: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;

Line 10100: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

10096: CLOSE csr_sc;
10097:
10098: BEGIN
10099: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10100: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10101: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10102: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10103: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10104: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=

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

10097:
10098: BEGIN
10099: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10100: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10101: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10102: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10103: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10104: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10105: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;

Line 10102: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

10098: BEGIN
10099: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10100: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10101: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10102: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10103: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10104: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10105: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10106: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=

Line 10103: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;

10099: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10100: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10101: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10102: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10103: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10104: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10105: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10106: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10107: l_sc_rec.business_group_id;

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

10100: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10101: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10102: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10103: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10104: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10105: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10106: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10107: l_sc_rec.business_group_id;
10108: log_message ('Reallocating for : ' || l_sc_rec.scorecard_id);

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

10102: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10103: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10104: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10105: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10106: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10107: l_sc_rec.business_group_id;
10108: log_message ('Reallocating for : ' || l_sc_rec.scorecard_id);
10109: sc_allocate_objs (p_plan_id => p_plan_id,
10110: p_scorecard_id => g_curr_sc_pop_tbl (l_curr_sc_pop_index).scorecard_id,

Line 10114: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';

10110: p_scorecard_id => g_curr_sc_pop_tbl (l_curr_sc_pop_index).scorecard_id,
10111: p_reallocate => 'Y'
10112: );
10113: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10114: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';
10115: EXCEPTION
10116: WHEN OTHERS
10117: THEN
10118: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

Line 10118: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

10114: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';
10115: EXCEPTION
10116: WHEN OTHERS
10117: THEN
10118: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10119: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10120: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10121: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10122: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);

Line 10119: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';

10115: EXCEPTION
10116: WHEN OTHERS
10117: THEN
10118: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10119: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10120: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10121: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10122: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10123: -- Error

Line 10120: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;

10116: WHEN OTHERS
10117: THEN
10118: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10119: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10120: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10121: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10122: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10123: -- Error
10124: END;

Line 10121: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';

10117: THEN
10118: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10119: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10120: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10121: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10122: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10123: -- Error
10124: END;
10125: END LOOP;

Line 10163: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;

10159:
10160: log_message ('sc status:' || l_sc_rec.status_code);
10161:
10162: BEGIN
10163: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10164:
10165: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10166: THEN
10167: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

Line 10165: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)

10161:
10162: BEGIN
10163: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10164:
10165: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10166: THEN
10167: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10168: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10169: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

Line 10167: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

10163: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10164:
10165: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10166: THEN
10167: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10168: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10169: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10170: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10171: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=

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

10164:
10165: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10166: THEN
10167: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10168: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10169: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10170: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10171: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10172: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;

Line 10169: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

10165: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10166: THEN
10167: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10168: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10169: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10170: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10171: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10172: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10173: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=

Line 10170: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;

10166: THEN
10167: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10168: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10169: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10170: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10171: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10172: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10173: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10174: l_sc_rec.business_group_id;

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

10167: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10168: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10169: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10170: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10171: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10172: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10173: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10174: l_sc_rec.business_group_id;
10175: END IF;

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

10169: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10170: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10171: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10172: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10173: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10174: l_sc_rec.business_group_id;
10175: END IF;
10176:
10177: IF (l_sc_rec.status_code = 'PUBLISHED')

Line 10214: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';

10210: send_message_notification (l_sc_rec.person_id, 'WPM_SC_RESET_WKR', l_sc_rec.plan_id, NULL);
10211: send_message_notification (l_sc_rec.supervisor_id, 'WPM_SC_RESET_MGR', l_sc_rec.plan_id, l_sc_rec.scorecard_owner);
10212: END IF;
10213: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10214: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';
10215: EXCEPTION
10216: WHEN OTHERS
10217: THEN
10218: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

Line 10218: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

10214: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';
10215: EXCEPTION
10216: WHEN OTHERS
10217: THEN
10218: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10219: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10220: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10221: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10222: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);

Line 10219: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';

10215: EXCEPTION
10216: WHEN OTHERS
10217: THEN
10218: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10219: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10220: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10221: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10222: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10223: -- Error

Line 10220: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;

10216: WHEN OTHERS
10217: THEN
10218: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10219: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10220: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10221: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10222: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10223: -- Error
10224: END;

Line 10221: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';

10217: THEN
10218: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10219: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10220: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10221: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10222: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10223: -- Error
10224: END;
10225: END LOOP;

Line 10264: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;

10260:
10261: CLOSE csr_sc;
10262:
10263: BEGIN
10264: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10265:
10266: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10267: THEN
10268: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

Line 10266: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)

10262:
10263: BEGIN
10264: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10265:
10266: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10267: THEN
10268: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10269: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10270: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

Line 10268: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

10264: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10265:
10266: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10267: THEN
10268: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10269: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10270: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10271: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10272: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=

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

10265:
10266: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10267: THEN
10268: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10269: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10270: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10271: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10272: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10273: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;

Line 10270: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

10266: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10267: THEN
10268: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10269: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10270: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10271: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10272: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10273: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10274: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=

Line 10271: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;

10267: THEN
10268: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10269: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10270: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10271: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10272: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10273: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10274: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10275: l_sc_rec.business_group_id;

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

10268: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10269: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10270: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10271: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10272: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10273: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10274: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10275: l_sc_rec.business_group_id;
10276: END IF;

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

10270: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10271: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10272: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10273: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10274: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10275: l_sc_rec.business_group_id;
10276: END IF;
10277:
10278: sc_allocate_objs (p_plan_id => p_plan_id,

Line 10287: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';

10283: send_message_notification (l_sc_rec.person_id, 'WPM_SC_REFRESH_WKR', l_sc_rec.plan_id, NULL);
10284: send_message_notification (l_sc_rec.supervisor_id, 'WPM_SC_REFRESH_MGR', l_sc_rec.plan_id, l_sc_rec.scorecard_owner);
10285: END IF;
10286: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10287: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';
10288: EXCEPTION
10289: WHEN OTHERS
10290: THEN
10291: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

Line 10291: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

10287: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';
10288: EXCEPTION
10289: WHEN OTHERS
10290: THEN
10291: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10292: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10293: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10294: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10295: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);

Line 10292: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';

10288: EXCEPTION
10289: WHEN OTHERS
10290: THEN
10291: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10292: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10293: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10294: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10295: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10296: -- Error

Line 10293: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;

10289: WHEN OTHERS
10290: THEN
10291: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10292: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10293: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10294: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10295: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10296: -- Error
10297: END;

Line 10294: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';

10290: THEN
10291: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10292: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10293: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10294: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10295: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10296: -- Error
10297: END;
10298: END LOOP;

Line 10370: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;

10366:
10367: CLOSE csr_sc;
10368:
10369: BEGIN
10370: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10371:
10372: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10373: THEN
10374: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

Line 10372: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)

10368:
10369: BEGIN
10370: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10371:
10372: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10373: THEN
10374: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10375: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10376: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

Line 10374: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

10370: hr_wpm_mass_apr_push.log_records_index := l_sc_rec.assignment_id;
10371:
10372: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10373: THEN
10374: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10375: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10376: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10377: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10378: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=

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

10371:
10372: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10373: THEN
10374: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10375: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10376: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10377: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10378: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10379: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;

Line 10376: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

10372: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10373: THEN
10374: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10375: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10376: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10377: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10378: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10379: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10380: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=

Line 10377: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;

10373: THEN
10374: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10375: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10376: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10377: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10378: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10379: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10380: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10381: l_sc_rec.business_group_id;

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

10374: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10375: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10376: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10377: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10378: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10379: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10380: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10381: l_sc_rec.business_group_id;
10382: END IF;

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

10376: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10377: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id := l_sc_rec.person_id;
10378: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10379: g_curr_sc_pop_tbl (l_curr_sc_pop_index).assignment_id;
10380: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10381: l_sc_rec.business_group_id;
10382: END IF;
10383:
10384: sc_refresh_sup (g_curr_sc_pop_tbl (l_curr_sc_pop_index).scorecard_id);

Line 10390: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';

10386: send_message_notification (l_sc_rec.person_id, 'WPM_SC_REFRESH_WKR', l_sc_rec.plan_id, NULL);
10387: send_message_notification (l_sc_rec.supervisor_id, 'WPM_SC_REFRESH_MGR', l_sc_rec.plan_id, l_sc_rec.scorecard_owner);
10388: END IF;
10389: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index);
10390: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';
10391: EXCEPTION
10392: WHEN OTHERS
10393: THEN
10394: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

Line 10394: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

10390: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'SUCCESS';
10391: EXCEPTION
10392: WHEN OTHERS
10393: THEN
10394: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10395: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10396: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10397: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10398: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index); -- Error

Line 10395: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';

10391: EXCEPTION
10392: WHEN OTHERS
10393: THEN
10394: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10395: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10396: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10397: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10398: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index); -- Error
10399: END;

Line 10396: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;

10392: WHEN OTHERS
10393: THEN
10394: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10395: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10396: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10397: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10398: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index); -- Error
10399: END;
10400: END LOOP;

Line 10397: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';

10393: THEN
10394: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10395: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10396: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10397: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10398: l_curr_sc_pop_index := g_curr_sc_pop_tbl.NEXT (l_curr_sc_pop_index); -- Error
10399: END;
10400: END LOOP;
10401:

Line 10474: hr_wpm_mass_apr_push.log_records_index := g_qual_pop_tbl (l_qual_pop_index).assignment_id;

10470: l_qual_pop_index := g_qual_pop_tbl.FIRST;
10471:
10472: WHILE (l_qual_pop_index IS NOT NULL)
10473: LOOP -- Qual pop looop
10474: hr_wpm_mass_apr_push.log_records_index := g_qual_pop_tbl (l_qual_pop_index).assignment_id;
10475:
10476: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10477: THEN
10478: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

Line 10476: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)

10472: WHILE (l_qual_pop_index IS NOT NULL)
10473: LOOP -- Qual pop looop
10474: hr_wpm_mass_apr_push.log_records_index := g_qual_pop_tbl (l_qual_pop_index).assignment_id;
10475:
10476: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10477: THEN
10478: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10479: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10480: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

Line 10478: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;

10474: hr_wpm_mass_apr_push.log_records_index := g_qual_pop_tbl (l_qual_pop_index).assignment_id;
10475:
10476: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10477: THEN
10478: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10479: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10480: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10481: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
10482: g_qual_pop_tbl (l_qual_pop_index).person_id;

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

10475:
10476: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10477: THEN
10478: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10479: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10480: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10481: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
10482: g_qual_pop_tbl (l_qual_pop_index).person_id;
10483: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=

Line 10480: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

10476: IF NOT hr_wpm_mass_apr_push.g_wpm_person_actions.EXISTS (hr_wpm_mass_apr_push.log_records_index)
10477: THEN
10478: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10479: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10480: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10481: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
10482: g_qual_pop_tbl (l_qual_pop_index).person_id;
10483: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10484: g_qual_pop_tbl (l_qual_pop_index).assignment_id;

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

10477: THEN
10478: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_person_action_id := -1;
10479: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10480: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10481: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
10482: g_qual_pop_tbl (l_qual_pop_index).person_id;
10483: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10484: g_qual_pop_tbl (l_qual_pop_index).assignment_id;
10485: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=

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

10479: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).wpm_batch_action_id :=
10480: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
10481: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
10482: g_qual_pop_tbl (l_qual_pop_index).person_id;
10483: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10484: g_qual_pop_tbl (l_qual_pop_index).assignment_id;
10485: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10486: g_qual_pop_tbl (l_qual_pop_index).business_group_id;
10487: END IF;

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

10481: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).person_id :=
10482: g_qual_pop_tbl (l_qual_pop_index).person_id;
10483: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).assignment_id :=
10484: g_qual_pop_tbl (l_qual_pop_index).assignment_id;
10485: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).business_group_id :=
10486: g_qual_pop_tbl (l_qual_pop_index).business_group_id;
10487: END IF;
10488:
10489: OPEN get_person_name (g_qual_pop_tbl (l_qual_pop_index).person_id);

Line 10499: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status := 'Y';

10495:
10496: IF (l_elig_obj_id IS NULL)
10497: THEN
10498: -- WPM Logging Changes
10499: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status := 'Y';
10500: END IF;
10501:
10502: IF (l_elig_obj_id IS NOT NULL) -- Eligiblity profile is chosen
10503: THEN

Line 10524: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=

10520: g_qual_pop_tbl (l_qual_pop_index).business_group_id,
10521: 'Y' ---KMG -- Added to Allow CWK's
10522: );
10523: -- WPM Logging Changes
10524: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=
10525: l_check_elig_person;
10526: EXCEPTION
10527: WHEN OTHERS
10528: THEN

Line 10531: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=

10527: WHEN OTHERS
10528: THEN
10529: l_check_elig_person := 'N';
10530: -- WPM Logging Changes
10531: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=
10532: l_check_elig_person;
10533: -- WPM Logging Changes Post Review
10534: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10535: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';

Line 10534: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';

10530: -- WPM Logging Changes
10531: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=
10532: l_check_elig_person;
10533: -- WPM Logging Changes Post Review
10534: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10535: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10536: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10537: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10538: -- Error

Line 10535: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';

10531: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).eligibility_status :=
10532: l_check_elig_person;
10533: -- WPM Logging Changes Post Review
10534: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10535: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10536: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10537: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10538: -- Error
10539: op ( 'Eligibility Check errored for: '

Line 10536: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;

10532: l_check_elig_person;
10533: -- WPM Logging Changes Post Review
10534: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10535: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10536: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10537: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10538: -- Error
10539: op ( 'Eligibility Check errored for: '
10540: || l_person_name

Line 10537: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';

10533: -- WPM Logging Changes Post Review
10534: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TYPE := 'E';
10535: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).message_number := 'OTHER';
10536: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).MESSAGE_TEXT := SQLERRM;
10537: hr_wpm_mass_apr_push.g_wpm_person_actions (hr_wpm_mass_apr_push.log_records_index).processing_status := 'ERROR';
10538: -- Error
10539: op ( 'Eligibility Check errored for: '
10540: || l_person_name
10541: || ' ('

Line 11131: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id := l_wpm_batch_action_id;

11127: SELECT per_wpm_batch_actions_s.NEXTVAL
11128: INTO l_wpm_batch_action_id
11129: FROM DUAL;
11130:
11131: hr_wpm_mass_apr_push.l_current_wpm_batch_action_id := l_wpm_batch_action_id;
11132:
11133: INSERT INTO per_wpm_batch_actions
11134: (wpm_batch_action_id, conc_request_id, conc_program_name, plan_id, appraisal_period_id, status, start_date,
11135: end_date

Line 11187: hr_wpm_mass_apr_push.g_wpm_person_actions.DELETE;

11183: END IF;
11184:
11185: -- WPM Logging Changes Post Review
11186: -- to avoid caching issues
11187: hr_wpm_mass_apr_push.g_wpm_person_actions.DELETE;
11188: hr_wpm_mass_apr_push.log_records_index := NULL;
11189: l_object_version_number := l_pl_rec.object_version_number;
11190: --
11191: -- Call the publish plan

Line 11188: hr_wpm_mass_apr_push.log_records_index := NULL;

11184:
11185: -- WPM Logging Changes Post Review
11186: -- to avoid caching issues
11187: hr_wpm_mass_apr_push.g_wpm_person_actions.DELETE;
11188: hr_wpm_mass_apr_push.log_records_index := NULL;
11189: l_object_version_number := l_pl_rec.object_version_number;
11190: --
11191: -- Call the publish plan
11192: --

Line 11210: hr_wpm_mass_apr_push.print_cache ();

11206: errbuf := g_errbuf;
11207: retcode := g_retcode;
11208: --
11209: -- WPM Logging Changes
11210: hr_wpm_mass_apr_push.print_cache ();
11211:
11212: UPDATE per_wpm_batch_actions
11213: SET end_date = SYSDATE,
11214: status = DECODE (g_retcode, 0, 'SUCCESS', 'WARNING')

Line 11215: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

11211:
11212: UPDATE per_wpm_batch_actions
11213: SET end_date = SYSDATE,
11214: status = DECODE (g_retcode, 0, 'SUCCESS', 'WARNING')
11215: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
11216:
11217: UPDATE per_perf_mgmt_plans
11218: SET status_code = 'PUBLISHED'
11219: WHERE plan_id = p_plan_id;

Line 11227: hr_wpm_mass_apr_push.print_cache ();

11223: WHEN OTHERS
11224: THEN
11225: ROLLBACK;
11226: -- WPM Logging Changes
11227: hr_wpm_mass_apr_push.print_cache ();
11228: log_message('Inside Exception in Plan_republish');
11229: log_message(SQLERRM);
11230:
11231: UPDATE per_wpm_batch_actions

Line 11234: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;

11230:
11231: UPDATE per_wpm_batch_actions
11232: SET status = 'ERROR',
11233: end_date = SYSDATE
11234: WHERE wpm_batch_action_id = hr_wpm_mass_apr_push.l_current_wpm_batch_action_id;
11235:
11236: COMMIT;
11237:
11238: --