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 778: Hr_Utility.Set_Location(Nvl(fnd_message.get,sqlerrm),100);

774: --
775: Exception
776: When Others Then
777: hr_utility.set_location('Exception raised: delete_option',99);
778: Hr_Utility.Set_Location(Nvl(fnd_message.get,sqlerrm),100);
779: Return 'FAILURE';
780: End;
781:
782: Function get_payrate(p_frequency in varchar2 default null,

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

1262: p_effective_date => p_effective_date,
1263: p_datetrack_mode => l_Del_Dt_Mode);
1264: If l_return = 'FAILURE' Then
1265:
1266: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1267: fnd_message.raise_error;
1268:
1269: End If;
1270:

Line 1267: fnd_message.raise_error;

1263: p_datetrack_mode => l_Del_Dt_Mode);
1264: If l_return = 'FAILURE' Then
1265:
1266: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1267: fnd_message.raise_error;
1268:
1269: End If;
1270:
1271: -- Unlink Plan In Programs

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

1275:
1276:
1277: If l_return = 'FAILURE' Then
1278:
1279: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1280: fnd_message.raise_error;
1281:
1282: End If;
1283:

Line 1280: fnd_message.raise_error;

1276:
1277: If l_return = 'FAILURE' Then
1278:
1279: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1280: fnd_message.raise_error;
1281:
1282: End If;
1283:
1284: -- Delete option

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

1296: p_effective_date => p_effective_date);
1297:
1298: If l_return = 'FAILURE' Then
1299:
1300: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1301: fnd_message.raise_error;
1302:
1303: End If;
1304: End If;

Line 1301: fnd_message.raise_error;

1297:
1298: If l_return = 'FAILURE' Then
1299:
1300: fnd_message.set_name('PQH','PQH_GSP_BEN_DEL_FAILED');
1301: fnd_message.raise_error;
1302:
1303: End If;
1304: End If;
1305: if p_business_area = 'PQH_GSP_TASK_LIST' THEN

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

1690: hr_utility.set_location(' l_db_ovn is '||l_db_ovn,30);
1691: hr_utility.set_location(' l_gs_ovn is '||l_gs_ovn,30);
1692: if l_db_ovn <> l_gs_ovn then
1693: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1694: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1695: fnd_message.set_token('OBJECT ',l_object);
1696: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1697: fnd_message.raise_error;
1698: else

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

1691: hr_utility.set_location(' l_gs_ovn is '||l_gs_ovn,30);
1692: if l_db_ovn <> l_gs_ovn then
1693: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1694: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1695: fnd_message.set_token('OBJECT ',l_object);
1696: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1697: fnd_message.raise_error;
1698: else
1699: if p_datetrack_mode <> 'CORRECTION' then

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

1692: if l_db_ovn <> l_gs_ovn then
1693: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1694: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1695: fnd_message.set_token('OBJECT ',l_object);
1696: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1697: fnd_message.raise_error;
1698: else
1699: if p_datetrack_mode <> 'CORRECTION' then
1700: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode

Line 1697: fnd_message.raise_error;

1693: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GSPINE');
1694: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1695: fnd_message.set_token('OBJECT ',l_object);
1696: fnd_message.set_token('OBJECT_NAME ',l_grade_spine_id);
1697: fnd_message.raise_error;
1698: else
1699: if p_datetrack_mode <> 'CORRECTION' then
1700: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode
1701: (p_table_name => 'PER_GRADE_SPINES_F',

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

1885: p_key_column_value => l_point_id);
1886: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1887: if l_db_ovn <> l_point_ovn then
1888: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1889: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1890: fnd_message.set_token('OBJECT ',l_object);
1891: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);
1892: fnd_message.raise_error;
1893: else

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

1886: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1887: if l_db_ovn <> l_point_ovn then
1888: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1889: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1890: fnd_message.set_token('OBJECT ',l_object);
1891: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);
1892: fnd_message.raise_error;
1893: else
1894: if p_business_area = 'PQH_CORPS_TASK_LIST' then

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

1887: if l_db_ovn <> l_point_ovn then
1888: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1889: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1890: fnd_message.set_token('OBJECT ',l_object);
1891: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);
1892: fnd_message.raise_error;
1893: else
1894: if p_business_area = 'PQH_CORPS_TASK_LIST' then
1895: pqh_cpd_hr_to_stage.update_point(p_point_id => l_point_id,

Line 1892: fnd_message.raise_error;

1888: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','POINT');
1889: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1890: fnd_message.set_token('OBJECT ',l_object);
1891: fnd_message.set_token('OBJECT_NAME ',point_rec.information98);
1892: fnd_message.raise_error;
1893: else
1894: if p_business_area = 'PQH_CORPS_TASK_LIST' then
1895: pqh_cpd_hr_to_stage.update_point(p_point_id => l_point_id,
1896: p_point_ovn => l_point_ovn,

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

2025: p_key_column_value => l_grade_id);
2026: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2027: if l_db_ovn <> l_ovn then
2028: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
2029: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2030: fnd_message.set_token('OBJECT ',l_object);
2031: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);
2032: fnd_message.raise_error;
2033: else

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

2026: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2027: if l_db_ovn <> l_ovn then
2028: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
2029: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2030: fnd_message.set_token('OBJECT ',l_object);
2031: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);
2032: fnd_message.raise_error;
2033: else
2034: begin

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

2027: if l_db_ovn <> l_ovn then
2028: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
2029: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2030: fnd_message.set_token('OBJECT ',l_object);
2031: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);
2032: fnd_message.raise_error;
2033: else
2034: begin
2035: hr_grade_api.update_grade(p_date_from => grd_rec.information307

Line 2032: fnd_message.raise_error;

2028: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','GRADE');
2029: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2030: fnd_message.set_token('OBJECT ',l_object);
2031: fnd_message.set_token('OBJECT_NAME ',grd_rec.information5);
2032: fnd_message.raise_error;
2033: else
2034: begin
2035: hr_grade_api.update_grade(p_date_from => grd_rec.information307
2036: ,p_effective_date => p_effective_date

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

2278: p_key_column_value => l_scale_id);
2279: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2280: if l_db_ovn <> l_scale_ovn then
2281: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2282: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2283: fnd_message.set_token('OBJECT ',l_object);
2284: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);
2285: fnd_message.raise_error;
2286: else

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

2279: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2280: if l_db_ovn <> l_scale_ovn then
2281: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2282: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2283: fnd_message.set_token('OBJECT ',l_object);
2284: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);
2285: fnd_message.raise_error;
2286: else
2287: if p_business_area = 'PQH_CORPS_TASK_LIST' then

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

2280: if l_db_ovn <> l_scale_ovn then
2281: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2282: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2283: fnd_message.set_token('OBJECT ',l_object);
2284: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);
2285: fnd_message.raise_error;
2286: else
2287: if p_business_area = 'PQH_CORPS_TASK_LIST' then
2288: pqh_cpd_hr_to_stage.update_scale(p_scale_id => l_scale_id,

Line 2285: fnd_message.raise_error;

2281: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','SCALE');
2282: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2283: fnd_message.set_token('OBJECT ',l_object);
2284: fnd_message.set_token('OBJECT_NAME ',scl_rec.information98);
2285: fnd_message.raise_error;
2286: else
2287: if p_business_area = 'PQH_CORPS_TASK_LIST' then
2288: pqh_cpd_hr_to_stage.update_scale(p_scale_id => l_scale_id,
2289: p_scale_ovn => l_scale_ovn,

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

2511: p_effective_date => l_effective_date);
2512: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2513: if l_db_ovn <> l_hrr_ovn then
2514: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2515: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2516: fnd_message.set_token('OBJECT ',l_object);
2517: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);
2518: fnd_message.raise_error;
2519: else

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

2512: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2513: if l_db_ovn <> l_hrr_ovn then
2514: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2515: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2516: fnd_message.set_token('OBJECT ',l_object);
2517: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);
2518: fnd_message.raise_error;
2519: else
2520: begin

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

2513: if l_db_ovn <> l_hrr_ovn then
2514: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2515: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2516: fnd_message.set_token('OBJECT ',l_object);
2517: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);
2518: fnd_message.raise_error;
2519: else
2520: begin
2521: hr_rate_values_api.update_rate_value

Line 2518: fnd_message.raise_error;

2514: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','HRRATE');
2515: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2516: fnd_message.set_token('OBJECT ',l_object);
2517: fnd_message.set_token('OBJECT_NAME ',l_rate_type ||':'|| l_grd_sp_id);
2518: fnd_message.raise_error;
2519: else
2520: begin
2521: hr_rate_values_api.update_rate_value
2522: (p_effective_date => l_effective_date