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 364: hr_multi_message.enable_message_list;

360: hr_utility.set_location('p_Effective_Date '||p_Effective_Date,40);
361: hr_utility.set_location('p_Business_Group_Id '||p_business_group_id,50);
362: end if;
363:
364: hr_multi_message.enable_message_list;
365:
366: -- Get Pgm_Id
367: Open csr_pgm_id;
368: Fetch csr_pgm_id into l_pgm_id;

Line 783: hr_multi_message.enable_message_list;

779: hr_utility.set_location('p_copy_entity_txn_id '||p_copy_entity_txn_id,40);
780: hr_utility.set_location('p_effective_date '||p_effective_date,70);
781: end if;
782:
783: hr_multi_message.enable_message_list;
784:
785: -- Get Pgm_ID
786: Open csr_pgm_id;
787: Fetch csr_pgm_id into l_pgm_id;

Line 1526: hr_multi_message.enable_message_list;

1522: hr_utility.set_location('p_copy_entity_result_id '||p_copy_entity_result_id,60);
1523: hr_utility.set_location('p_copy_entity_txn_id '||p_copy_entity_txn_id,70);
1524: end if;
1525:
1526: hr_multi_message.enable_message_list;
1527: Open csr_grade_name;
1528: Fetch csr_grade_name into l_grade_name;
1529: If(csr_grade_name%FOUND) THEN
1530: p_status := 'E';

Line 2008: hr_multi_message.add;

2004: If csr_default_chk%found then
2005: close csr_default_chk;
2006: hr_utility.set_message(8302,'PQH_GSP_GRDLDR_DFLT_ERR');
2007: hr_utility.set_message_token('LADDER',l_name);
2008: hr_multi_message.add;
2009: Else
2010: close csr_default_chk;
2011: End if;
2012: End If;

Line 2144: hr_multi_message.add;

2140: end if;
2141: hr_utility.set_message(8302,'PQH_GSP_ADD_STEPS_IN_ALL_GRDS');
2142: hr_utility.set_message_token('GRADES',l_no_step_grades);
2143:
2144: hr_multi_message.add;
2145:
2146:
2147: End If;
2148: If l_found2 then

Line 2154: hr_multi_message.add;

2150: hr_utility.set_location('Grades not having Celing Steps found',52);
2151: end if;
2152: hr_utility.set_message(8302,'PQH_GSP_ADD_CEIL_IN_ALL_GRDS');
2153: hr_utility.set_message_token('GRADES',l_no_ceil_grades);
2154: hr_multi_message.add;
2155: End If;
2156: if g_debug then
2157: hr_utility.set_location('Leaving:'||l_proc,100);
2158: end if;

Line 2222: hr_multi_message.add;

2218:
2219: If l_found then
2220: hr_utility.set_message(8302,'PQH_GSP_INVALID_GRD_IN_GRDLDR');
2221: hr_utility.set_message_token('GRADES',l_grades);
2222: hr_multi_message.add;
2223: End If;
2224:
2225: if g_debug then
2226: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 2277: hr_multi_message.enable_message_list;

2273: hr_utility.set_location('p_pgm_id:'||p_pgm_id, 15);
2274: hr_utility.set_location('p_effective_date:'||p_effective_date, 20);
2275: hr_utility.set_location('p_activate:'||p_activate, 35);
2276: end if;
2277: hr_multi_message.enable_message_list;
2278:
2279: If p_pgm_id IS NOT NULL Then
2280: if g_debug then
2281: hr_utility.set_location('PGM Id Not Null ', 40);

Line 2893: hr_multi_message.add;

2889: l_no_grades := substr(l_no_grades,1,length(l_no_grades)-2);
2890: p_status := 'E';
2891: hr_utility.set_message(8302,'PQH_GSP_CANNOT_UNLINK_GRADES');
2892: hr_utility.set_message_token('GRADES',l_no_grades );
2893: hr_multi_message.add;
2894: End if;
2895:
2896: if l_grd_war_found then
2897: if g_debug then

Line 3015: hr_multi_message.add;

3011: Fetch csr_name into l_dummy;
3012: If csr_name%Found then
3013: Close csr_name;
3014: hr_utility.set_message(8302,'PQH_GSP_GRDLDR_NAME_UNIQUE');
3015: hr_multi_message.add;
3016: Else
3017: Close csr_name;
3018: End If;
3019: --

Line 3072: hr_multi_message.add;

3068: Fetch csr_short_name into l_dummy;
3069: If csr_short_name%Found then
3070: Close csr_short_name;
3071: hr_utility.set_message(8302,'PQH_GSP_GL_SHT_NAME_CODE_UNQ');
3072: hr_multi_message.add;
3073: Else
3074: Close csr_short_name;
3075: End If;
3076: --

Line 3085: hr_multi_message.add;

3081: Fetch csr_short_code into l_dummy;
3082: If csr_short_code%Found then
3083: Close csr_short_code;
3084: hr_utility.set_message(8302,'PQH_GSP_GL_SHT_NAME_CODE_UNQ');
3085: hr_multi_message.add;
3086: Else
3087: Close csr_short_code;
3088: End If;
3089: --

Line 3332: hr_multi_message.add;

3328: end if;
3329:
3330: hr_utility.set_message(8302,'PQH_GSP_GRDS_DIFF_CURR_PERIOD');
3331: hr_utility.set_message_token('GRADES',l_dummy );
3332: hr_multi_message.add;
3333: end if;
3334: if g_debug then
3335: hr_utility.set_location('Leaving :' ||l_proc, 100);
3336: end if;

Line 3445: hr_multi_message.add;

3441: -- Criteria set name should be entered. Ideally this error should never be raised.
3442: --
3443: If crset_rec.INFORMATION151 is NULL then
3444: hr_utility.set_message(8302,'PQH_GSP_CRI_SET_NAME_ERR');
3445: hr_multi_message.add;
3446: l_continue := false;
3447: End if;
3448: --
3449: -- Criteria set should have at least one criterion

Line 3468: hr_multi_message.add;

3464: crset_rec.INFORMATION104 IS NULL ) then
3465: --
3466: hr_utility.set_message(8302,'PQH_GSP_CRI_SET_NO_CRIT');
3467: hr_utility.set_message_token('CSET',crset_rec.INFORMATION151);
3468: hr_multi_message.add;
3469: l_continue := false;
3470: --
3471: End if;
3472: --

Line 3487: hr_multi_message.add;

3483: (crset_rec.INFORMATION103 IS NOT NULL and crset_rec.INFORMATION104 IS NULL)) then
3484: --
3485: hr_utility.set_message(8302,'PQH_GSP_INVALID_PERF_RATING');
3486: hr_utility.set_message_token('CSET',crset_rec.INFORMATION151);
3487: hr_multi_message.add;
3488: l_continue := false;
3489: --
3490: End if;
3491: End if;

Line 3524: hr_multi_message.add;

3520: hr_utility.set_location('Duplicate cset || l_duplicate_cset_name' , 5);
3521: hr_utility.set_message(8302,'PQH_GSP_DUPLICATE_CSETS_ERR');
3522: hr_utility.set_message_token('CSET1',crset_rec.INFORMATION151);
3523: hr_utility.set_message_token('CSET2',l_duplicate_cset_name);
3524: hr_multi_message.add;
3525: --
3526: End if;
3527: --
3528: End if;

Line 3586: hr_multi_message.enable_message_list;

3582: l_error_status Varchar2(20) := 'E';
3583: l_grdldr_date Date;
3584:
3585: BEGIN
3586: hr_multi_message.enable_message_list;
3587: if g_debug then
3588: hr_utility.set_location('Entering :' ||l_proc, 10);
3589: end if;
3590:

Line 3693: hr_multi_message.add;

3689:
3690: if l_pt_le_status = 'WRONG-DATE-PROG-LE' then
3691: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_PROG_LE');
3692: hr_utility.set_message_token('PLANTYPESTARTDATE',l_plan_type_start_date);
3693: hr_multi_message.add;
3694: elsif l_pt_le_status = 'MANY-PROG-LE' then
3695: hr_utility.set_message(8302,'PQH_GSP_MANY_PROG_LE');
3696: hr_multi_message.add;
3697: elsif l_pt_le_status = 'WRONG-DATE-SYNC-LE' then

Line 3696: hr_multi_message.add;

3692: hr_utility.set_message_token('PLANTYPESTARTDATE',l_plan_type_start_date);
3693: hr_multi_message.add;
3694: elsif l_pt_le_status = 'MANY-PROG-LE' then
3695: hr_utility.set_message(8302,'PQH_GSP_MANY_PROG_LE');
3696: hr_multi_message.add;
3697: elsif l_pt_le_status = 'WRONG-DATE-SYNC-LE' then
3698: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_SYNC_LE');
3699: hr_utility.set_message_token('PLANTYPESTARTDATE',l_plan_type_start_date);
3700: hr_multi_message.add;

Line 3700: hr_multi_message.add;

3696: hr_multi_message.add;
3697: elsif l_pt_le_status = 'WRONG-DATE-SYNC-LE' then
3698: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_SYNC_LE');
3699: hr_utility.set_message_token('PLANTYPESTARTDATE',l_plan_type_start_date);
3700: hr_multi_message.add;
3701: elsif l_pt_le_status = 'MANY-SYNC-LE' then
3702: hr_utility.set_message(8302,'PQH_GSP_MANY_SYNC_LE');
3703: hr_multi_message.add;
3704: elsif l_pt_le_status = 'WRONG-DATE-PT' then

Line 3703: hr_multi_message.add;

3699: hr_utility.set_message_token('PLANTYPESTARTDATE',l_plan_type_start_date);
3700: hr_multi_message.add;
3701: elsif l_pt_le_status = 'MANY-SYNC-LE' then
3702: hr_utility.set_message(8302,'PQH_GSP_MANY_SYNC_LE');
3703: hr_multi_message.add;
3704: elsif l_pt_le_status = 'WRONG-DATE-PT' then
3705: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_PT');
3706: hr_multi_message.add;
3707: elsif l_pt_le_status = 'MANY-PT' then

Line 3706: hr_multi_message.add;

3702: hr_utility.set_message(8302,'PQH_GSP_MANY_SYNC_LE');
3703: hr_multi_message.add;
3704: elsif l_pt_le_status = 'WRONG-DATE-PT' then
3705: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_PT');
3706: hr_multi_message.add;
3707: elsif l_pt_le_status = 'MANY-PT' then
3708: hr_utility.set_message(8302,'PQH_GSP_MANY_PT');
3709: hr_multi_message.add;
3710: 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 3709: hr_multi_message.add;

3705: hr_utility.set_message(8302,'PQH_GSP_WRONG_ST_DT_PT');
3706: hr_multi_message.add;
3707: elsif l_pt_le_status = 'MANY-PT' then
3708: hr_utility.set_message(8302,'PQH_GSP_MANY_PT');
3709: hr_multi_message.add;
3710: elsif l_pt_le_status = 'PROG-LE-ERR' or l_pt_le_status = 'SYNC-LE-ERR' or l_pt_le_status = 'PT-ERR' then
3711: hr_utility.set_message(8302,'PQH_GSP_PT_LE_ERR');
3712: hr_multi_message.add;
3713: else

Line 3712: hr_multi_message.add;

3708: hr_utility.set_message(8302,'PQH_GSP_MANY_PT');
3709: hr_multi_message.add;
3710: elsif l_pt_le_status = 'PROG-LE-ERR' or l_pt_le_status = 'SYNC-LE-ERR' or l_pt_le_status = 'PT-ERR' then
3711: hr_utility.set_message(8302,'PQH_GSP_PT_LE_ERR');
3712: hr_multi_message.add;
3713: else
3714: null;
3715: end if;
3716:

Line 3736: hr_multi_message.end_validation_set;

3732: ,p_status => l_error_status);
3733:
3734:
3735: -- Call to raise any errors on multi-message list
3736: hr_multi_message.end_validation_set;
3737:
3738: p_status := l_status;
3739: if g_debug then
3740: hr_utility.set_location('Leaving :' ||l_proc, 200);

Line 3744: when hr_multi_message.error_message_exist then

3740: hr_utility.set_location('Leaving :' ||l_proc, 200);
3741: end if;
3742: Exception
3743:
3744: when hr_multi_message.error_message_exist then
3745: p_status := null;
3746: if g_debug then
3747: hr_utility.set_location('Error :' ||substr(sqlerrm,1,50), 240);
3748: hr_utility.set_location('Leaving:' || l_proc, 300);

Line 4475: hr_multi_message.enable_message_list;

4471: --
4472: --
4473: -- Initialise Multiple Message Detection
4474: --
4475: hr_multi_message.enable_message_list;
4476:
4477: if g_debug then
4478: hr_utility.set_location('Entering '||l_proc,100);
4479: hr_utility.set_location('p_copy_entity_txn_id :'||p_copy_entity_txn_id,20);

Line 4497: hr_multi_message.end_validation_set;

4493:
4494: --
4495: --
4496: -- Call to raise any errors on multi-message list
4497: hr_multi_message.end_validation_set;
4498: -- p_error_msg := l_msg;
4499:
4500: EXCEPTION
4501: when hr_api.validate_enabled then

Line 4504: when hr_multi_message.error_message_exist then

4500: EXCEPTION
4501: when hr_api.validate_enabled then
4502: Rollback to move_data_stage_to_hr;
4503: null;
4504: when hr_multi_message.error_message_exist then
4505: Rollback to move_data_stage_to_hr;
4506: null;
4507: when others then
4508: l_msg := nvl(fnd_message.get,sqlerrm);

Line 4727: hr_multi_message.enable_message_list;

4723: WHERE p_effective_date BETWEEN effective_start_date
4724: AND effective_end_date
4725: AND grade_id = p_grade_id;
4726: BEGIN
4727: hr_multi_message.enable_message_list;
4728: hr_utility.set_location ('Inside chk_new_ceiling', 10);
4729: OPEN csr_grade_id;
4730: FETCH csr_grade_id INTO l_grade_id;
4731: CLOSE csr_grade_id;

Line 4753: hr_multi_message.end_validation_set;

4749: END IF;
4750: END IF;
4751:
4752: -- Call to raise any errors on multi-message list
4753: hr_multi_message.end_validation_set;
4754: -- p_error_msg := l_msg;
4755: hr_utility.set_location ('Leaving chk_new_ceiling', 90);
4756: EXCEPTION
4757: WHEN OTHERS

Line 4791: hr_multi_message.enable_message_list;

4787: AND information104 = 'LINK';
4788:
4789: l_steps_for_point NUMBER;
4790: BEGIN
4791: hr_multi_message.enable_message_list;
4792: hr_utility.set_location ('Inside Proc', 2);
4793: OPEN csr_steps_for_point;
4794: FETCH csr_steps_for_point INTO l_steps_for_point;
4795:

Line 4803: hr_multi_message.end_validation_set;

4799: hr_utility.set_message (8302,'PER_7926_DEL_POINT_STEP');
4800: hr_utility.raise_error;
4801: END IF;
4802:
4803: hr_multi_message.end_validation_set;
4804: hr_utility.set_location ('Leaving Proc', 2);
4805: EXCEPTION
4806: WHEN OTHERS
4807: THEN

Line 4853: hr_multi_message.enable_message_list;

4849: l_final_step_cer_id NUMBER;
4850: l_final_step_id NUMBER;
4851: l_gspine_id NUMBER;
4852: BEGIN
4853: hr_multi_message.enable_message_list;
4854: hr_utility.set_location ('Inside Proc..', 5);
4855:
4856: if p_initial_ceiling_id <> p_final_ceiling_id THEN
4857: OPEN csr_final_step;

Line 4941: hr_multi_message.end_validation_set;

4937: )
4938: );
4939: END IF;
4940: -- Call to raise any errors on multi-message list
4941: hr_multi_message.end_validation_set;
4942: -- p_error_msg := l_msg;
4943: EXCEPTION
4944: WHEN OTHERS
4945: THEN

Line 5003: hr_multi_message.enable_message_list;

4999: l_effdate DATE;
5000: l_steps_in_grade NUMBER;
5001: l_grade_scale_dets csr_grade_scale_dets%ROWTYPE;
5002: BEGIN
5003: hr_multi_message.enable_message_list;
5004:
5005:
5006: select action_date
5007: into l_effdate

Line 5049: hr_multi_message.end_validation_set;

5045: END IF;
5046:
5047: CLOSE csr_steps_in_grade;
5048: -- Call to raise any errors on multi-message list
5049: hr_multi_message.end_validation_set;
5050: -- p_error_msg := l_msg;
5051: EXCEPTION
5052: WHEN OTHERS
5053: THEN

Line 5713: hr_multi_message.enable_message_list;

5709:
5710: l_pgm_name ben_pgm_f.NAME%TYPE;
5711: l_dummy VARCHAR2 (10);
5712: BEGIN
5713: hr_multi_message.enable_message_list;
5714:
5715: OPEN csr_name;
5716:
5717: FETCH csr_name

Line 5723: hr_multi_message.ADD;

5719:
5720: IF csr_name%FOUND
5721: THEN
5722: hr_utility.set_message (8302, 'PQH_GSP_GRDLDR_NAME_UNQ');
5723: hr_multi_message.ADD;
5724: END IF;
5725:
5726: CLOSE csr_name;
5727:

Line 5739: hr_multi_message.ADD;

5735: IF csr_dflt_grd_ldr%FOUND
5736: THEN
5737: hr_utility.set_message (8302, 'PQH_GSP_GRDLDR_DFLT_ERR');
5738: hr_utility.set_message_token ('LADDER', l_pgm_name);
5739: hr_multi_message.ADD;
5740: END IF;
5741:
5742: CLOSE csr_dflt_grd_ldr;
5743: END IF;

Line 5744: hr_multi_message.end_validation_set;

5740: END IF;
5741:
5742: CLOSE csr_dflt_grd_ldr;
5743: END IF;
5744: hr_multi_message.end_validation_set;
5745: EXCEPTION
5746: WHEN hr_multi_message.error_message_exist
5747: THEN
5748: NULL;

Line 5746: WHEN hr_multi_message.error_message_exist

5742: CLOSE csr_dflt_grd_ldr;
5743: END IF;
5744: hr_multi_message.end_validation_set;
5745: EXCEPTION
5746: WHEN hr_multi_message.error_message_exist
5747: THEN
5748: NULL;
5749: WHEN OTHERS
5750: THEN