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

Line 739: Hr_Utility.Set_Location(Nvl(fnd_message.get,sqlerrm),100);

735: --
736: Exception
737: When Others Then
738: hr_utility.set_location('Exception raised: delete_option',99);
739: Hr_Utility.Set_Location(Nvl(fnd_message.get,sqlerrm),100);
740: Return 'FAILURE';
741: End;
742:
743: Function get_payrate(p_frequency in varchar2 default null,

Line 1227: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');

1223: p_effective_date => p_effective_date,
1224: p_datetrack_mode => l_Del_Dt_Mode);
1225: If l_return = 'FAILURE' Then
1226:
1227: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1228: fnd_message.raise_error;
1229:
1230: End If;
1231:

Line 1228: fnd_message.raise_error;

1224: p_datetrack_mode => l_Del_Dt_Mode);
1225: If l_return = 'FAILURE' Then
1226:
1227: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1228: fnd_message.raise_error;
1229:
1230: End If;
1231:
1232: -- Unlink Plan In Programs

Line 1240: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');

1236:
1237:
1238: If l_return = 'FAILURE' Then
1239:
1240: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1241: fnd_message.raise_error;
1242:
1243: End If;
1244:

Line 1241: fnd_message.raise_error;

1237:
1238: If l_return = 'FAILURE' Then
1239:
1240: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1241: fnd_message.raise_error;
1242:
1243: End If;
1244:
1245: -- Delete option

Line 1261: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');

1257: p_effective_date => p_effective_date);
1258:
1259: If l_return = 'FAILURE' Then
1260:
1261: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1262: fnd_message.raise_error;
1263:
1264: End If;
1265: End If;

Line 1262: fnd_message.raise_error;

1258:
1259: If l_return = 'FAILURE' Then
1260:
1261: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1262: fnd_message.raise_error;
1263:
1264: End If;
1265: End If;
1266: if p_business_area = 'PQH_GSP_TASK_LIST' THEN

Line 1655: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');

1651: hr_utility.set_location(' l_db_ovn is '||l_db_ovn,30);
1652: hr_utility.set_location(' l_gs_ovn is '||l_gs_ovn,30);
1653: if l_db_ovn <> l_gs_ovn then
1654: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1655: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1656: fnd_message.set_token('OBJECT ',l_object);
1657: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1658: fnd_message.raise_error;
1659: else

Line 1656: fnd_message.set_token('OBJECT ',l_object);

1652: hr_utility.set_location(' l_gs_ovn is '||l_gs_ovn,30);
1653: if l_db_ovn <> l_gs_ovn then
1654: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1655: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1656: fnd_message.set_token('OBJECT ',l_object);
1657: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1658: fnd_message.raise_error;
1659: else
1660: if p_datetrack_mode <> 'CORRECTION' then

Line 1657: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);

1653: if l_db_ovn <> l_gs_ovn then
1654: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1655: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1656: fnd_message.set_token('OBJECT ',l_object);
1657: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1658: fnd_message.raise_error;
1659: else
1660: if p_datetrack_mode <> 'CORRECTION' then
1661: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode

Line 1658: fnd_message.raise_error;

1654: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1655: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1656: fnd_message.set_token('OBJECT ',l_object);
1657: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1658: fnd_message.raise_error;
1659: else
1660: if p_datetrack_mode <> 'CORRECTION' then
1661: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode
1662: (p_table_name => 'PER_GRADE_SPINES_F',

Line 1850: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');

1846: p_key_column_value => l_point_id);
1847: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1848: if l_db_ovn <> l_point_ovn then
1849: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1850: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1851: fnd_message.set_token('OBJECT ',l_object);
1852: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);
1853: fnd_message.raise_error;
1854: else

Line 1851: fnd_message.set_token('OBJECT ',l_object);

1847: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1848: if l_db_ovn <> l_point_ovn then
1849: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1850: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1851: fnd_message.set_token('OBJECT ',l_object);
1852: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);
1853: fnd_message.raise_error;
1854: else
1855: if p_business_area = 'PQH_CORPS_TASK_LIST' then

Line 1852: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);

1848: if l_db_ovn <> l_point_ovn then
1849: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1850: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1851: fnd_message.set_token('OBJECT ',l_object);
1852: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);
1853: fnd_message.raise_error;
1854: else
1855: if p_business_area = 'PQH_CORPS_TASK_LIST' then
1856: pqh_cpd_hr_to_stage.update_point(p_point_id => l_point_id,

Line 1853: fnd_message.raise_error;

1849: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1850: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1851: fnd_message.set_token('OBJECT ',l_object);
1852: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);
1853: fnd_message.raise_error;
1854: else
1855: if p_business_area = 'PQH_CORPS_TASK_LIST' then
1856: pqh_cpd_hr_to_stage.update_point(p_point_id => l_point_id,
1857: p_point_ovn => l_point_ovn,

Line 1989: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');

1985: p_key_column_value => l_grade_id);
1986: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1987: if l_db_ovn <> l_ovn then
1988: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
1989: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1990: fnd_message.set_token('OBJECT ',l_object);
1991: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);
1992: fnd_message.raise_error;
1993: else

Line 1990: fnd_message.set_token('OBJECT ',l_object);

1986: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1987: if l_db_ovn <> l_ovn then
1988: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
1989: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1990: fnd_message.set_token('OBJECT ',l_object);
1991: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);
1992: fnd_message.raise_error;
1993: else
1994: begin

Line 1991: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);

1987: if l_db_ovn <> l_ovn then
1988: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
1989: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1990: fnd_message.set_token('OBJECT ',l_object);
1991: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);
1992: fnd_message.raise_error;
1993: else
1994: begin
1995: hr_grade_api.update_grade(p_date_from => grd_rec.information307

Line 1992: fnd_message.raise_error;

1988: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
1989: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1990: fnd_message.set_token('OBJECT ',l_object);
1991: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);
1992: fnd_message.raise_error;
1993: else
1994: begin
1995: hr_grade_api.update_grade(p_date_from => grd_rec.information307
1996: ,p_effective_date => p_effective_date

Line 2242: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');

2238: p_key_column_value => l_scale_id);
2239: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2240: if l_db_ovn <> l_scale_ovn then
2241: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2242: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2243: fnd_message.set_token('OBJECT ',l_object);
2244: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);
2245: fnd_message.raise_error;
2246: else

Line 2243: fnd_message.set_token('OBJECT ',l_object);

2239: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2240: if l_db_ovn <> l_scale_ovn then
2241: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2242: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2243: fnd_message.set_token('OBJECT ',l_object);
2244: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);
2245: fnd_message.raise_error;
2246: else
2247: if p_business_area = 'PQH_CORPS_TASK_LIST' then

Line 2244: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);

2240: if l_db_ovn <> l_scale_ovn then
2241: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2242: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2243: fnd_message.set_token('OBJECT ',l_object);
2244: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);
2245: fnd_message.raise_error;
2246: else
2247: if p_business_area = 'PQH_CORPS_TASK_LIST' then
2248: pqh_cpd_hr_to_stage.update_scale(p_scale_id => l_scale_id,

Line 2245: fnd_message.raise_error;

2241: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2242: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2243: fnd_message.set_token('OBJECT ',l_object);
2244: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);
2245: fnd_message.raise_error;
2246: else
2247: if p_business_area = 'PQH_CORPS_TASK_LIST' then
2248: pqh_cpd_hr_to_stage.update_scale(p_scale_id => l_scale_id,
2249: p_scale_ovn => l_scale_ovn,

Line 2474: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');

2470: p_effective_date => l_effective_date);
2471: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2472: if l_db_ovn <> l_hrr_ovn then
2473: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2474: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2475: fnd_message.set_token('OBJECT ',l_object);
2476: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);
2477: fnd_message.raise_error;
2478: else

Line 2475: fnd_message.set_token('OBJECT ',l_object);

2471: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2472: if l_db_ovn <> l_hrr_ovn then
2473: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2474: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2475: fnd_message.set_token('OBJECT ',l_object);
2476: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);
2477: fnd_message.raise_error;
2478: else
2479: begin

Line 2476: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);

2472: if l_db_ovn <> l_hrr_ovn then
2473: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2474: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2475: fnd_message.set_token('OBJECT ',l_object);
2476: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);
2477: fnd_message.raise_error;
2478: else
2479: begin
2480: hr_rate_values_api.update_rate_value

Line 2477: fnd_message.raise_error;

2473: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2474: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2475: fnd_message.set_token('OBJECT ',l_object);
2476: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);
2477: fnd_message.raise_error;
2478: else
2479: begin
2480: hr_rate_values_api.update_rate_value
2481: (p_effective_date => l_effective_date