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.PQH_GSP_UTILITY dependencies on HR_MULTI_MESSAGE

Line 245: hr_multi_message.enable_message_list;

241: hr_utility.set_location('p_Effective_Date '||p_Effective_Date,40);
242: hr_utility.set_location('p_Business_Group_Id '||p_business_group_id,50);
243: end if;
244:
245: hr_multi_message.enable_message_list;
246:
247: -- Get Pgm_Id
248: Open csr_pgm_id;
249: Fetch csr_pgm_id into l_pgm_id;

Line 664: hr_multi_message.enable_message_list;

660: hr_utility.set_location('p_copy_entity_txn_id '||p_copy_entity_txn_id,40);
661: hr_utility.set_location('p_effective_date '||p_effective_date,70);
662: end if;
663:
664: hr_multi_message.enable_message_list;
665:
666: -- Get Pgm_ID
667: Open csr_pgm_id;
668: Fetch csr_pgm_id into l_pgm_id;

Line 1407: hr_multi_message.enable_message_list;

1403: hr_utility.set_location('p_copy_entity_result_id '||p_copy_entity_result_id,60);
1404: hr_utility.set_location('p_copy_entity_txn_id '||p_copy_entity_txn_id,70);
1405: end if;
1406:
1407: hr_multi_message.enable_message_list;
1408: Open csr_grade_name;
1409: Fetch csr_grade_name into l_grade_name;
1410: If(csr_grade_name%FOUND) THEN
1411: p_status := 'E';

Line 1889: hr_multi_message.add;

1885: If csr_default_chk%found then
1886: close csr_default_chk;
1887: hr_utility.set_message(8302,'PQH_GSP_GRDLDR_DFLT_ERR');
1888: hr_utility.set_message_token('LADDER',l_name);
1889: hr_multi_message.add;
1890: Else
1891: close csr_default_chk;
1892: End if;
1893: End If;

Line 2025: hr_multi_message.add;

2021: end if;
2022: hr_utility.set_message(8302,'PQH_GSP_ADD_STEPS_IN_ALL_GRDS');
2023: hr_utility.set_message_token('GRADES',l_no_step_grades);
2024:
2025: hr_multi_message.add;
2026:
2027:
2028: End If;
2029: If l_found2 then

Line 2035: hr_multi_message.add;

2031: hr_utility.set_location('Grades not having Celing Steps found',52);
2032: end if;
2033: hr_utility.set_message(8302,'PQH_GSP_ADD_CEIL_IN_ALL_GRDS');
2034: hr_utility.set_message_token('GRADES',l_no_ceil_grades);
2035: hr_multi_message.add;
2036: End If;
2037: if g_debug then
2038: hr_utility.set_location('Leaving:'||l_proc,100);
2039: end if;

Line 2103: hr_multi_message.add;

2099:
2100: If l_found then
2101: hr_utility.set_message(8302,'PQH_GSP_INVALID_GRD_IN_GRDLDR');
2102: hr_utility.set_message_token('GRADES',l_grades);
2103: hr_multi_message.add;
2104: End If;
2105:
2106: if g_debug then
2107: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 2158: hr_multi_message.enable_message_list;

2154: hr_utility.set_location('p_pgm_id:'||p_pgm_id, 15);
2155: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);
2156: hr_utility.set_location('p_activate:'||p_activate, 35);
2157: end if;
2158: hr_multi_message.enable_message_list;
2159:
2160: If p_pgm_id IS NOT NULL Then
2161: if g_debug then
2162: hr_utility.set_location('PGM Id Not Null ', 40);

Line 2774: hr_multi_message.add;

2770: l_no_grades := substr(l_no_grades,1,length(l_no_grades)-2);
2771: p_status := 'E';
2772: hr_utility.set_message(8302,'PQH_GSP_CANNOT_UNLINK_GRADES');
2773: hr_utility.set_message_token('GRADES',l_no_grades );
2774: hr_multi_message.add;
2775: End if;
2776:
2777: if l_grd_war_found then
2778: if g_debug then

Line 2896: hr_multi_message.add;

2892: Fetch csr_name into l_dummy;
2893: If csr_name%Found then
2894: Close csr_name;
2895: hr_utility.set_message(8302,'PQH_GSP_GRDLDR_NAME_UNIQUE');
2896: hr_multi_message.add;
2897: Else
2898: Close csr_name;
2899: End If;
2900: --

Line 2953: hr_multi_message.add;

2949: Fetch csr_short_name into l_dummy;
2950: If csr_short_name%Found then
2951: Close csr_short_name;
2952: hr_utility.set_message(8302,'PQH_GSP_GL_SHT_NAME_CODE_UNQ');
2953: hr_multi_message.add;
2954: Else
2955: Close csr_short_name;
2956: End If;
2957: --

Line 2966: hr_multi_message.add;

2962: Fetch csr_short_code into l_dummy;
2963: If csr_short_code%Found then
2964: Close csr_short_code;
2965: hr_utility.set_message(8302,'PQH_GSP_GL_SHT_NAME_CODE_UNQ');
2966: hr_multi_message.add;
2967: Else
2968: Close csr_short_code;
2969: End If;
2970: --

Line 3213: hr_multi_message.add;

3209: end if;
3210:
3211: hr_utility.set_message(8302,'PQH_GSP_GRDS_DIFF_CURR_PERIOD');
3212: hr_utility.set_message_token('GRADES',l_dummy );
3213: hr_multi_message.add;
3214: end if;
3215: if g_debug then
3216: hr_utility.set_location('Leaving :' ||l_proc, 100);
3217: end if;

Line 3326: hr_multi_message.add;

3322: -- Criteria set name should be entered. Ideally this error should never be raised.
3323: --
3324: If crset_rec.INFORMATION151 is NULL then
3325: hr_utility.set_message(8302,'PQH_GSP_CRI_SET_NAME_ERR');
3326: hr_multi_message.add;
3327: l_continue := false;
3328: End if;
3329: --
3330: -- Criteria set should have at least one criterion

Line 3349: hr_multi_message.add;

3345: crset_rec.INFORMATION104 IS NULL ) then
3346: --
3347: hr_utility.set_message(8302,'PQH_GSP_CRI_SET_NO_CRIT');
3348: hr_utility.set_message_token('CSET',crset_rec.INFORMATION151);
3349: hr_multi_message.add;
3350: l_continue := false;
3351: --
3352: End if;
3353: --

Line 3368: hr_multi_message.add;

3364: (crset_rec.INFORMATION103 IS NOT NULL and crset_rec.INFORMATION104 IS NULL)) then
3365: --
3366: hr_utility.set_message(8302,'PQH_GSP_INVALID_PERF_RATING');
3367: hr_utility.set_message_token('CSET',crset_rec.INFORMATION151);
3368: hr_multi_message.add;
3369: l_continue := false;
3370: --
3371: End if;
3372: End if;

Line 3405: hr_multi_message.add;

3401: hr_utility.set_location('Duplicate cset || l_duplicate_cset_name' , 5);
3402: hr_utility.set_message(8302,'PQH_GSP_DUPLICATE_CSETS_ERR');
3403: hr_utility.set_message_token('CSET1',crset_rec.INFORMATION151);
3404: hr_utility.set_message_token('CSET2',l_duplicate_cset_name);
3405: hr_multi_message.add;
3406: --
3407: End if;
3408: --
3409: End if;

Line 3467: hr_multi_message.enable_message_list;

3463: l_error_status Varchar2(20) := 'E';
3464: l_grdldr_date Date;
3465:
3466: BEGIN
3467: hr_multi_message.enable_message_list;
3468: if g_debug then
3469: hr_utility.set_location('Entering :' ||l_proc, 10);
3470: end if;
3471:

Line 3574: hr_multi_message.add;

3570:
3571: if l_pt_le_status = 'WRONG-DATE-PROG-LE' then
3572: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_PROG_LE');
3573: hr_utility.set_message_token('PLANTYPESTARTDATE',l_plan_type_start_date);
3574: hr_multi_message.add;
3575: elsif l_pt_le_status = 'MANY-PROG-LE' then
3576: hr_utility.set_message(8302,'PQH_GSP_MANY_PROG_LE');
3577: hr_multi_message.add;
3578: elsif l_pt_le_status = 'WRONG-DATE-SYNC-LE' then

Line 3577: hr_multi_message.add;

3573: hr_utility.set_message_token('PLANTYPESTARTDATE',l_plan_type_start_date);
3574: hr_multi_message.add;
3575: elsif l_pt_le_status = 'MANY-PROG-LE' then
3576: hr_utility.set_message(8302,'PQH_GSP_MANY_PROG_LE');
3577: hr_multi_message.add;
3578: elsif l_pt_le_status = 'WRONG-DATE-SYNC-LE' then
3579: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_SYNC_LE');
3580: hr_utility.set_message_token('PLANTYPESTARTDATE',l_plan_type_start_date);
3581: hr_multi_message.add;

Line 3581: hr_multi_message.add;

3577: hr_multi_message.add;
3578: elsif l_pt_le_status = 'WRONG-DATE-SYNC-LE' then
3579: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_SYNC_LE');
3580: hr_utility.set_message_token('PLANTYPESTARTDATE',l_plan_type_start_date);
3581: hr_multi_message.add;
3582: elsif l_pt_le_status = 'MANY-SYNC-LE' then
3583: hr_utility.set_message(8302,'PQH_GSP_MANY_SYNC_LE');
3584: hr_multi_message.add;
3585: elsif l_pt_le_status = 'WRONG-DATE-PT' then

Line 3584: hr_multi_message.add;

3580: hr_utility.set_message_token('PLANTYPESTARTDATE',l_plan_type_start_date);
3581: hr_multi_message.add;
3582: elsif l_pt_le_status = 'MANY-SYNC-LE' then
3583: hr_utility.set_message(8302,'PQH_GSP_MANY_SYNC_LE');
3584: hr_multi_message.add;
3585: elsif l_pt_le_status = 'WRONG-DATE-PT' then
3586: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_PT');
3587: hr_multi_message.add;
3588: elsif l_pt_le_status = 'MANY-PT' then

Line 3587: hr_multi_message.add;

3583: hr_utility.set_message(8302,'PQH_GSP_MANY_SYNC_LE');
3584: hr_multi_message.add;
3585: elsif l_pt_le_status = 'WRONG-DATE-PT' then
3586: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_PT');
3587: hr_multi_message.add;
3588: elsif l_pt_le_status = 'MANY-PT' then
3589: hr_utility.set_message(8302,'PQH_GSP_MANY_PT');
3590: hr_multi_message.add;
3591: elsif l_pt_le_status = 'PROG-LE-ERR' or l_pt_le_status = 'SYNC-LE-ERR' or l_pt_le_status = 'PT-ERR' then

Line 3590: hr_multi_message.add;

3586: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_PT');
3587: hr_multi_message.add;
3588: elsif l_pt_le_status = 'MANY-PT' then
3589: hr_utility.set_message(8302,'PQH_GSP_MANY_PT');
3590: hr_multi_message.add;
3591: elsif l_pt_le_status = 'PROG-LE-ERR' or l_pt_le_status = 'SYNC-LE-ERR' or l_pt_le_status = 'PT-ERR' then
3592: hr_utility.set_message(8302,'PQH_GSP_PT_LE_ERR');
3593: hr_multi_message.add;
3594: else

Line 3593: hr_multi_message.add;

3589: hr_utility.set_message(8302,'PQH_GSP_MANY_PT');
3590: hr_multi_message.add;
3591: elsif l_pt_le_status = 'PROG-LE-ERR' or l_pt_le_status = 'SYNC-LE-ERR' or l_pt_le_status = 'PT-ERR' then
3592: hr_utility.set_message(8302,'PQH_GSP_PT_LE_ERR');
3593: hr_multi_message.add;
3594: else
3595: null;
3596: end if;
3597:

Line 3617: hr_multi_message.end_validation_set;

3613: ,p_status => l_error_status);
3614:
3615:
3616: -- Call to raise any errors on multi-message list
3617: hr_multi_message.end_validation_set;
3618:
3619: p_status := l_status;
3620: if g_debug then
3621: hr_utility.set_location('Leaving :' ||l_proc, 200);

Line 3625: when hr_multi_message.error_message_exist then

3621: hr_utility.set_location('Leaving :' ||l_proc, 200);
3622: end if;
3623: Exception
3624:
3625: when hr_multi_message.error_message_exist then
3626: p_status := null;
3627: if g_debug then
3628: hr_utility.set_location('Error :' ||substr(sqlerrm,1,50), 240);
3629: hr_utility.set_location('Leaving:' || l_proc, 300);

Line 4356: hr_multi_message.enable_message_list;

4352: --
4353: --
4354: -- Initialise Multiple Message Detection
4355: --
4356: hr_multi_message.enable_message_list;
4357:
4358: if g_debug then
4359: hr_utility.set_location('Entering '||l_proc,100);
4360: hr_utility.set_location('p_copy_entity_txn_id :'||p_copy_entity_txn_id,20);

Line 4378: hr_multi_message.end_validation_set;

4374:
4375: --
4376: --
4377: -- Call to raise any errors on multi-message list
4378: hr_multi_message.end_validation_set;
4379: -- p_error_msg := l_msg;
4380:
4381: EXCEPTION
4382: when hr_api.validate_enabled then

Line 4385: when hr_multi_message.error_message_exist then

4381: EXCEPTION
4382: when hr_api.validate_enabled then
4383: Rollback to move_data_stage_to_hr;
4384: null;
4385: when hr_multi_message.error_message_exist then
4386: Rollback to move_data_stage_to_hr;
4387: null;
4388: when others then
4389: l_msg := nvl(fnd_message.get,sqlerrm);

Line 4608: hr_multi_message.enable_message_list;

4604: WHERE p_effective_date BETWEEN effective_start_date
4605: AND effective_end_date
4606: AND grade_id = p_grade_id;
4607: BEGIN
4608: hr_multi_message.enable_message_list;
4609: hr_utility.set_location ('Inside chk_new_ceiling', 10);
4610: OPEN csr_grade_id;
4611: FETCH csr_grade_id INTO l_grade_id;
4612: CLOSE csr_grade_id;

Line 4634: hr_multi_message.end_validation_set;

4630: END IF;
4631: END IF;
4632:
4633: -- Call to raise any errors on multi-message list
4634: hr_multi_message.end_validation_set;
4635: -- p_error_msg := l_msg;
4636: hr_utility.set_location ('Leaving chk_new_ceiling', 90);
4637: EXCEPTION
4638: WHEN OTHERS

Line 4672: hr_multi_message.enable_message_list;

4668: AND information104 = 'LINK';
4669:
4670: l_steps_for_point NUMBER;
4671: BEGIN
4672: hr_multi_message.enable_message_list;
4673: hr_utility.set_location ('Inside Proc', 2);
4674: OPEN csr_steps_for_point;
4675: FETCH csr_steps_for_point INTO l_steps_for_point;
4676:

Line 4684: hr_multi_message.end_validation_set;

4680: hr_utility.set_message (8302,'PER_7926_DEL_POINT_STEP');
4681: hr_utility.raise_error;
4682: END IF;
4683:
4684: hr_multi_message.end_validation_set;
4685: hr_utility.set_location ('Leaving Proc', 2);
4686: EXCEPTION
4687: WHEN OTHERS
4688: THEN

Line 4734: hr_multi_message.enable_message_list;

4730: l_final_step_cer_id NUMBER;
4731: l_final_step_id NUMBER;
4732: l_gspine_id NUMBER;
4733: BEGIN
4734: hr_multi_message.enable_message_list;
4735: hr_utility.set_location ('Inside Proc..', 5);
4736:
4737: if p_initial_ceiling_id <> p_final_ceiling_id THEN
4738: OPEN csr_final_step;

Line 4822: hr_multi_message.end_validation_set;

4818: )
4819: );
4820: END IF;
4821: -- Call to raise any errors on multi-message list
4822: hr_multi_message.end_validation_set;
4823: -- p_error_msg := l_msg;
4824: EXCEPTION
4825: WHEN OTHERS
4826: THEN

Line 4884: hr_multi_message.enable_message_list;

4880: l_effdate DATE;
4881: l_steps_in_grade NUMBER;
4882: l_grade_scale_dets csr_grade_scale_dets%ROWTYPE;
4883: BEGIN
4884: hr_multi_message.enable_message_list;
4885:
4886:
4887: select action_date
4888: into l_effdate

Line 4930: hr_multi_message.end_validation_set;

4926: END IF;
4927:
4928: CLOSE csr_steps_in_grade;
4929: -- Call to raise any errors on multi-message list
4930: hr_multi_message.end_validation_set;
4931: -- p_error_msg := l_msg;
4932: EXCEPTION
4933: WHEN OTHERS
4934: THEN

Line 5594: hr_multi_message.enable_message_list;

5590:
5591: l_pgm_name ben_pgm_f.NAME%TYPE;
5592: l_dummy VARCHAR2 (10);
5593: BEGIN
5594: hr_multi_message.enable_message_list;
5595:
5596: OPEN csr_name;
5597:
5598: FETCH csr_name

Line 5604: hr_multi_message.ADD;

5600:
5601: IF csr_name%FOUND
5602: THEN
5603: hr_utility.set_message (8302, 'PQH_GSP_GRDLDR_NAME_UNQ');
5604: hr_multi_message.ADD;
5605: END IF;
5606:
5607: CLOSE csr_name;
5608:

Line 5620: hr_multi_message.ADD;

5616: IF csr_dflt_grd_ldr%FOUND
5617: THEN
5618: hr_utility.set_message (8302, 'PQH_GSP_GRDLDR_DFLT_ERR');
5619: hr_utility.set_message_token ('LADDER', l_pgm_name);
5620: hr_multi_message.ADD;
5621: END IF;
5622:
5623: CLOSE csr_dflt_grd_ldr;
5624: END IF;

Line 5625: hr_multi_message.end_validation_set;

5621: END IF;
5622:
5623: CLOSE csr_dflt_grd_ldr;
5624: END IF;
5625: hr_multi_message.end_validation_set;
5626: EXCEPTION
5627: WHEN hr_multi_message.error_message_exist
5628: THEN
5629: NULL;

Line 5627: WHEN hr_multi_message.error_message_exist

5623: CLOSE csr_dflt_grd_ldr;
5624: END IF;
5625: hr_multi_message.end_validation_set;
5626: EXCEPTION
5627: WHEN hr_multi_message.error_message_exist
5628: THEN
5629: NULL;
5630: WHEN OTHERS
5631: THEN