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.PQP_EXR_UPD dependencies on HR_API

Line 121: When hr_api.check_integrity_violated Then

117: --
118: hr_utility.set_location(' Leaving:'||l_proc, 10);
119: --
120: Exception
121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
124: pqp_exr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

121: When hr_api.check_integrity_violated Then
122: -- A check constraint has been violated
123: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
124: pqp_exr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
129: pqp_exr_shd.constraint_error

Line 126: When hr_api.parent_integrity_violated Then

122: -- A check constraint has been violated
123: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
124: pqp_exr_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
129: pqp_exr_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

126: When hr_api.parent_integrity_violated Then
127: -- Parent integrity has been violated
128: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
129: pqp_exr_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
134: pqp_exr_shd.constraint_error

Line 131: When hr_api.unique_integrity_violated Then

127: -- Parent integrity has been violated
128: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
129: pqp_exr_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
134: pqp_exr_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

131: When hr_api.unique_integrity_violated Then
132: -- Unique integrity has been violated
133: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
134: pqp_exr_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When Others Then
137: pqp_exr_shd.g_api_dml := false; -- Unset the api dml status
138: Raise;
139: End update_dml;

Line 259: when hr_api.cannot_find_prog_unit then

255: );
256: --
257: exception
258: --
259: when hr_api.cannot_find_prog_unit then
260: --
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'PQP_EXCEPTION_REPORTS'
263: ,p_hook_type => 'AU');

Line 261: hr_api.cannot_find_prog_unit_error

257: exception
258: --
259: when hr_api.cannot_find_prog_unit then
260: --
261: hr_api.cannot_find_prog_unit_error
262: (p_module_name => 'PQP_EXCEPTION_REPORTS'
263: ,p_hook_type => 'AU');
264: --
265: end;

Line 324: If (p_rec.exception_report_name = hr_api.g_varchar2) then

320: -- p_rec plsql record structure
321: -- to see if a system default is being used. If a system default
322: -- is being used then we must set to the 'current' argument value.
323: --
324: If (p_rec.exception_report_name = hr_api.g_varchar2) then
325: p_rec.exception_report_name :=
326: pqp_exr_shd.g_old_rec.exception_report_name;
327: End If;
328: If (p_rec.legislation_code = hr_api.g_varchar2) then

Line 328: If (p_rec.legislation_code = hr_api.g_varchar2) then

324: If (p_rec.exception_report_name = hr_api.g_varchar2) then
325: p_rec.exception_report_name :=
326: pqp_exr_shd.g_old_rec.exception_report_name;
327: End If;
328: If (p_rec.legislation_code = hr_api.g_varchar2) then
329: p_rec.legislation_code :=
330: pqp_exr_shd.g_old_rec.legislation_code;
331: End If;
332: If (p_rec.business_group_id = hr_api.g_number) then

Line 332: If (p_rec.business_group_id = hr_api.g_number) then

328: If (p_rec.legislation_code = hr_api.g_varchar2) then
329: p_rec.legislation_code :=
330: pqp_exr_shd.g_old_rec.legislation_code;
331: End If;
332: If (p_rec.business_group_id = hr_api.g_number) then
333: p_rec.business_group_id :=
334: pqp_exr_shd.g_old_rec.business_group_id;
335: End If;
336: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 336: If (p_rec.currency_code = hr_api.g_varchar2) then

332: If (p_rec.business_group_id = hr_api.g_number) then
333: p_rec.business_group_id :=
334: pqp_exr_shd.g_old_rec.business_group_id;
335: End If;
336: If (p_rec.currency_code = hr_api.g_varchar2) then
337: p_rec.currency_code :=
338: pqp_exr_shd.g_old_rec.currency_code;
339: End If;
340: If (p_rec.balance_type_id = hr_api.g_number) then

Line 340: If (p_rec.balance_type_id = hr_api.g_number) then

336: If (p_rec.currency_code = hr_api.g_varchar2) then
337: p_rec.currency_code :=
338: pqp_exr_shd.g_old_rec.currency_code;
339: End If;
340: If (p_rec.balance_type_id = hr_api.g_number) then
341: p_rec.balance_type_id :=
342: pqp_exr_shd.g_old_rec.balance_type_id;
343: End If;
344: If (p_rec.balance_dimension_id = hr_api.g_number) then

Line 344: If (p_rec.balance_dimension_id = hr_api.g_number) then

340: If (p_rec.balance_type_id = hr_api.g_number) then
341: p_rec.balance_type_id :=
342: pqp_exr_shd.g_old_rec.balance_type_id;
343: End If;
344: If (p_rec.balance_dimension_id = hr_api.g_number) then
345: p_rec.balance_dimension_id :=
346: pqp_exr_shd.g_old_rec.balance_dimension_id;
347: End If;
348: If (p_rec.variance_type = hr_api.g_varchar2) then

Line 348: If (p_rec.variance_type = hr_api.g_varchar2) then

344: If (p_rec.balance_dimension_id = hr_api.g_number) then
345: p_rec.balance_dimension_id :=
346: pqp_exr_shd.g_old_rec.balance_dimension_id;
347: End If;
348: If (p_rec.variance_type = hr_api.g_varchar2) then
349: p_rec.variance_type :=
350: pqp_exr_shd.g_old_rec.variance_type;
351: End If;
352: If (p_rec.variance_value = hr_api.g_number) then

Line 352: If (p_rec.variance_value = hr_api.g_number) then

348: If (p_rec.variance_type = hr_api.g_varchar2) then
349: p_rec.variance_type :=
350: pqp_exr_shd.g_old_rec.variance_type;
351: End If;
352: If (p_rec.variance_value = hr_api.g_number) then
353: p_rec.variance_value :=
354: pqp_exr_shd.g_old_rec.variance_value;
355: End If;
356: If (p_rec.comparison_type = hr_api.g_varchar2) then

Line 356: If (p_rec.comparison_type = hr_api.g_varchar2) then

352: If (p_rec.variance_value = hr_api.g_number) then
353: p_rec.variance_value :=
354: pqp_exr_shd.g_old_rec.variance_value;
355: End If;
356: If (p_rec.comparison_type = hr_api.g_varchar2) then
357: p_rec.comparison_type :=
358: pqp_exr_shd.g_old_rec.comparison_type;
359: End If;
360: If (p_rec.comparison_value = hr_api.g_number) then

Line 360: If (p_rec.comparison_value = hr_api.g_number) then

356: If (p_rec.comparison_type = hr_api.g_varchar2) then
357: p_rec.comparison_type :=
358: pqp_exr_shd.g_old_rec.comparison_type;
359: End If;
360: If (p_rec.comparison_value = hr_api.g_number) then
361: p_rec.comparison_value :=
362: pqp_exr_shd.g_old_rec.comparison_value;
363: End If;
364: If (p_rec.output_format_type = hr_api.g_varchar2) then

Line 364: If (p_rec.output_format_type = hr_api.g_varchar2) then

360: If (p_rec.comparison_value = hr_api.g_number) then
361: p_rec.comparison_value :=
362: pqp_exr_shd.g_old_rec.comparison_value;
363: End If;
364: If (p_rec.output_format_type = hr_api.g_varchar2) then
365: p_rec.output_format_type :=
366: pqp_exr_shd.g_old_rec.output_format_type;
367: End If;
368: If (p_rec.variance_operator = hr_api.g_varchar2) then

Line 368: If (p_rec.variance_operator = hr_api.g_varchar2) then

364: If (p_rec.output_format_type = hr_api.g_varchar2) then
365: p_rec.output_format_type :=
366: pqp_exr_shd.g_old_rec.output_format_type;
367: End If;
368: If (p_rec.variance_operator = hr_api.g_varchar2) then
369: p_rec.variance_operator :=
370: pqp_exr_shd.g_old_rec.variance_operator;
371: End If;
372: --