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_DEFAULT dependencies on FND_MESSAGE

Line 117: ,p_message_text => Nvl(fnd_Message.Get,sqlerrm)

113: (P_Master_txn_Id => l_Assignment_id
114: ,P_Txn_Id => l_Assignment_id
115: ,p_module_cd => 'PQH_GSP_DFLT_ENRL'
116: ,p_message_type_cd => 'E'
117: ,p_message_text => Nvl(fnd_Message.Get,sqlerrm)
118: ,P_Effective_Date => P_Effective_Date);
119:
120: L_PIL_OVN := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PER_IN_LER',
121: p_key_column_name => 'PER_IN_LER_ID',

Line 319: fnd_message.set_name('PQH','PQH_GSP_LAST_STEP');

315: End If;
316: End Loop;
317: -- l_dest_step_seq := l_step_seq + nvl(p_num_incr,1);
318: If P_next_step_id is NULL and p_called_from = 'SP' then
319: fnd_message.set_name('PQH','PQH_GSP_LAST_STEP');
320: fnd_message.raise_error;
321: End If;
322: hr_utility.set_location(' Next Step ' || p_next_step_id ,110);
323: If p_next_step_id is NULL Then

Line 320: fnd_message.raise_error;

316: End Loop;
317: -- l_dest_step_seq := l_step_seq + nvl(p_num_incr,1);
318: If P_next_step_id is NULL and p_called_from = 'SP' then
319: fnd_message.set_name('PQH','PQH_GSP_LAST_STEP');
320: fnd_message.raise_error;
321: End If;
322: hr_utility.set_location(' Next Step ' || p_next_step_id ,110);
323: If p_next_step_id is NULL Then
324: p_steps_left := Nvl(P_Num_Incr,1);

Line 357: fnd_message.set_name('PQH','PQH_GSP_NO_STEP');

353: begin
354: if p_step_id is null then
355: hr_utility.set_location('emp not on step'||p_step_id,5);
356: l_continue := FALSE;
357: fnd_message.set_name('PQH','PQH_GSP_NO_STEP');
358: fnd_message.raise_error;
359: elsif p_step_id = p_ceiling_step_id then
360: hr_utility.set_location('emp on ceiling no step prog'||p_ceiling_step_id,5);
361: l_continue := FALSE;

Line 358: fnd_message.raise_error;

354: if p_step_id is null then
355: hr_utility.set_location('emp not on step'||p_step_id,5);
356: l_continue := FALSE;
357: fnd_message.set_name('PQH','PQH_GSP_NO_STEP');
358: fnd_message.raise_error;
359: elsif p_step_id = p_ceiling_step_id then
360: hr_utility.set_location('emp on ceiling no step prog'||p_ceiling_step_id,5);
361: l_continue := FALSE;
362: fnd_message.set_name('PQH','PQH_GSP_CIEL_STEP');

Line 362: fnd_message.set_name('PQH','PQH_GSP_CIEL_STEP');

358: fnd_message.raise_error;
359: elsif p_step_id = p_ceiling_step_id then
360: hr_utility.set_location('emp on ceiling no step prog'||p_ceiling_step_id,5);
361: l_continue := FALSE;
362: fnd_message.set_name('PQH','PQH_GSP_CIEL_STEP');
363: fnd_message.raise_error;
364: else
365: hr_utility.set_location('step id is '||p_step_id,10);
366: hr_utility.set_location('# of incr for person are '||p_num_incr,20);

Line 363: fnd_message.raise_error;

359: elsif p_step_id = p_ceiling_step_id then
360: hr_utility.set_location('emp on ceiling no step prog'||p_ceiling_step_id,5);
361: l_continue := FALSE;
362: fnd_message.set_name('PQH','PQH_GSP_CIEL_STEP');
363: fnd_message.raise_error;
364: else
365: hr_utility.set_location('step id is '||p_step_id,10);
366: hr_utility.set_location('# of incr for person are '||p_num_incr,20);
367: end if;

Line 525: Fnd_message.set_name('PQH','PQH_GSP_LAST_STEP');

521: p_effective_date => p_effective_date);
522: If l_next_step_id is NOT NULL then
523: l_next_step_id := NULL;
524: Else
525: Fnd_message.set_name('PQH','PQH_GSP_LAST_STEP');
526: fnd_message.raise_error;
527: End If;
528:
529: else

Line 526: fnd_message.raise_error;

522: If l_next_step_id is NOT NULL then
523: l_next_step_id := NULL;
524: Else
525: Fnd_message.set_name('PQH','PQH_GSP_LAST_STEP');
526: fnd_message.raise_error;
527: End If;
528:
529: else
530: hr_utility.set_location('invalid step_cd ',70);

Line 814: fnd_message.set_name('PQH','PQH_GSP_PLN_NOTLNKD_TO_GRD');

810: p_effective_date => p_effective_date);
811: hr_utility.set_location('plan is'||l_plan_id,30);
812: if l_plan_id is null then
813: l_continue := FALSE;
814: fnd_message.set_name('PQH','PQH_GSP_PLN_NOTLNKD_TO_GRD');
815: fnd_message.raise_error;
816: end if;
817: else
818: hr_utility.set_location('grade is'||l_grade_id,40);

Line 815: fnd_message.raise_error;

811: hr_utility.set_location('plan is'||l_plan_id,30);
812: if l_plan_id is null then
813: l_continue := FALSE;
814: fnd_message.set_name('PQH','PQH_GSP_PLN_NOTLNKD_TO_GRD');
815: fnd_message.raise_error;
816: end if;
817: else
818: hr_utility.set_location('grade is'||l_grade_id,40);
819: l_continue := FALSE;

Line 820: fnd_message.set_name('PQH','PQH_GSP_GRDNOTLNKD_ASSGT');

816: end if;
817: else
818: hr_utility.set_location('grade is'||l_grade_id,40);
819: l_continue := FALSE;
820: fnd_message.set_name('PQH','PQH_GSP_GRDNOTLNKD_ASSGT');
821: fnd_message.raise_error;
822: end if;
823: if l_continue then
824: if l_gl_id is not null then

Line 821: fnd_message.raise_error;

817: else
818: hr_utility.set_location('grade is'||l_grade_id,40);
819: l_continue := FALSE;
820: fnd_message.set_name('PQH','PQH_GSP_GRDNOTLNKD_ASSGT');
821: fnd_message.raise_error;
822: end if;
823: if l_continue then
824: if l_gl_id is not null then
825: hr_utility.set_location('Assignment on GL'||l_gl_id,50);

Line 841: fnd_message.set_name('PQH','PQH_GSP_GRD_ORDNUM_NOTFND');

837: hr_utility.set_location('asg on def GL',80);
838: l_gl_id := l_def_gl;
839: else
840: l_continue := FALSE;
841: fnd_message.set_name('PQH','PQH_GSP_GRD_ORDNUM_NOTFND');
842: fnd_message.raise_error;
843: end if;
844: else
845: hr_utility.set_location('def GL not there',80);

Line 842: fnd_message.raise_error;

838: l_gl_id := l_def_gl;
839: else
840: l_continue := FALSE;
841: fnd_message.set_name('PQH','PQH_GSP_GRD_ORDNUM_NOTFND');
842: fnd_message.raise_error;
843: end if;
844: else
845: hr_utility.set_location('def GL not there',80);
846: l_continue := FALSE;

Line 847: fnd_message.set_name('PQH','PQH_GSP_NO_GRDLDR');

843: end if;
844: else
845: hr_utility.set_location('def GL not there',80);
846: l_continue := FALSE;
847: fnd_message.set_name('PQH','PQH_GSP_NO_GRDLDR');
848: fnd_message.raise_error;
849: end if;
850: end if;
851: end if;

Line 848: fnd_message.raise_error;

844: else
845: hr_utility.set_location('def GL not there',80);
846: l_continue := FALSE;
847: fnd_message.set_name('PQH','PQH_GSP_NO_GRDLDR');
848: fnd_message.raise_error;
849: end if;
850: end if;
851: end if;
852: if l_continue then

Line 924: fnd_message.set_name('PQH','PQH_GSP_PRGSTYLE_NOT_SET');

920: p_next_step_id => l_next_step_id);
921: else
922: hr_utility.set_location('invalid prog_style'||l_prog_style_cd,260);
923: l_continue := FALSE;
924: fnd_message.set_name('PQH','PQH_GSP_PRGSTYLE_NOT_SET');
925: fnd_message.raise_error;
926: end if;
927: hr_utility.set_location('cur grade is'||l_grade_id,260);
928: hr_utility.set_location('cur step is'||l_step_id,260);

Line 925: fnd_message.raise_error;

921: else
922: hr_utility.set_location('invalid prog_style'||l_prog_style_cd,260);
923: l_continue := FALSE;
924: fnd_message.set_name('PQH','PQH_GSP_PRGSTYLE_NOT_SET');
925: fnd_message.raise_error;
926: end if;
927: hr_utility.set_location('cur grade is'||l_grade_id,260);
928: hr_utility.set_location('cur step is'||l_step_id,260);
929: hr_utility.set_location('next grade is'||l_next_grade_id,260);

Line 956: fnd_message.set_name('PQH','PQH_GSP_EMP_NOT_ELGBL');

952: hr_utility.set_location('invalid posting style'||l_post_style_cd,260);
953: end if;
954: else
955: hr_utility.set_location('no electbl chc found ',260);
956: fnd_message.set_name('PQH','PQH_GSP_EMP_NOT_ELGBL');
957: fnd_message.raise_error;
958: l_continue := False;
959: end if;
960: end if;

Line 957: fnd_message.raise_error;

953: end if;
954: else
955: hr_utility.set_location('no electbl chc found ',260);
956: fnd_message.set_name('PQH','PQH_GSP_EMP_NOT_ELGBL');
957: fnd_message.raise_error;
958: l_continue := False;
959: end if;
960: end if;
961: end if;

Line 975: fnd_message.set_name('PQH','PQH_GSP_LAST_GRADE');

971: p_gl_id => p_gl_id,
972: p_effective_date => p_effective_date);
973: if p_next_grade_id is null then
974: hr_utility.set_location('topmost grade',260);
975: fnd_message.set_name('PQH','PQH_GSP_LAST_GRADE');
976: fnd_message.raise_error;
977: elsif p_next_grade_id = -1 then
978: hr_utility.set_location('invalid grd for GL',270);
979: else

Line 976: fnd_message.raise_error;

972: p_effective_date => p_effective_date);
973: if p_next_grade_id is null then
974: hr_utility.set_location('topmost grade',260);
975: fnd_message.set_name('PQH','PQH_GSP_LAST_GRADE');
976: fnd_message.raise_error;
977: elsif p_next_grade_id = -1 then
978: hr_utility.set_location('invalid grd for GL',270);
979: else
980: hr_utility.set_location('next grade is'||p_next_grade_id,260);

Line 1126: fnd_message.set_name('PQH','PQH_GSP_GRDNOTLNKD_ASSGT');

1122: -- we will try for step progression, if you reach the ceiling and still some point left, we will go for GSP
1123: if p_grade_id is null then
1124: hr_utility.set_location('emp doesnot have grade'||p_grade_id,10);
1125: l_continue := false;
1126: fnd_message.set_name('PQH','PQH_GSP_GRDNOTLNKD_ASSGT');
1127: fnd_message.raise_error;
1128: end if;
1129: if p_step_id is null then
1130: hr_utility.set_location('emp doesnot have step'||p_step_id,10);

Line 1127: fnd_message.raise_error;

1123: if p_grade_id is null then
1124: hr_utility.set_location('emp doesnot have grade'||p_grade_id,10);
1125: l_continue := false;
1126: fnd_message.set_name('PQH','PQH_GSP_GRDNOTLNKD_ASSGT');
1127: fnd_message.raise_error;
1128: end if;
1129: if p_step_id is null then
1130: hr_utility.set_location('emp doesnot have step'||p_step_id,10);
1131: l_continue := false;

Line 1132: fnd_message.set_name('PQH','PQH_GSP_NO_STEP');

1128: end if;
1129: if p_step_id is null then
1130: hr_utility.set_location('emp doesnot have step'||p_step_id,10);
1131: l_continue := false;
1132: fnd_message.set_name('PQH','PQH_GSP_NO_STEP');
1133: fnd_message.raise_error;
1134: end if;
1135: if l_continue then
1136: get_result_step(p_step_id => p_step_id,

Line 1133: fnd_message.raise_error;

1129: if p_step_id is null then
1130: hr_utility.set_location('emp doesnot have step'||p_step_id,10);
1131: l_continue := false;
1132: fnd_message.set_name('PQH','PQH_GSP_NO_STEP');
1133: fnd_message.raise_error;
1134: end if;
1135: if l_continue then
1136: get_result_step(p_step_id => p_step_id,
1137: p_effective_date => p_effective_date,

Line 1186: fnd_message.set_name('PQH','PQH_GSP_LAST_STEP');

1182: Return;
1183: Else
1184: hr_utility.set_location('next step is '||l_next_step_id,144);
1185: l_continue := FALSE;
1186: fnd_message.set_name('PQH','PQH_GSP_LAST_STEP');
1187: fnd_message.raise_error;
1188: End If;
1189: end if;
1190: else

Line 1187: fnd_message.raise_error;

1183: Else
1184: hr_utility.set_location('next step is '||l_next_step_id,144);
1185: l_continue := FALSE;
1186: fnd_message.set_name('PQH','PQH_GSP_LAST_STEP');
1187: fnd_message.raise_error;
1188: End If;
1189: end if;
1190: else
1191: hr_utility.set_location('step progr was sufficient',200);

Line 1241: fnd_message.set_name('PQH','PQH_GSP_EMP_NOT_ELGBL');

1237: Fetch Csr_Step into l_Min_Incr_Step_Id;
1238: Close Csr_Step;
1239:
1240: If p_grade_id is NOT NULL and l_Min_Incr_Step_Id is NULL then
1241: fnd_message.set_name('PQH','PQH_GSP_EMP_NOT_ELGBL');
1242: fnd_message.raise_error;
1243: End If;
1244: hr_utility.set_location('min sal is '||l_min_incr_sal,85);
1245: hr_utility.set_location('min step is '||l_min_incr_step_id,90);

Line 1242: fnd_message.raise_error;

1238: Close Csr_Step;
1239:
1240: If p_grade_id is NOT NULL and l_Min_Incr_Step_Id is NULL then
1241: fnd_message.set_name('PQH','PQH_GSP_EMP_NOT_ELGBL');
1242: fnd_message.raise_error;
1243: End If;
1244: hr_utility.set_location('min sal is '||l_min_incr_sal,85);
1245: hr_utility.set_location('min step is '||l_min_incr_step_id,90);
1246: return l_min_incr_step_id;