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_ERG_BUS dependencies on PQP_ERG_SHD

Line 180: (p_rec in pqp_erg_shd.g_rec_type

176: --
177: -- {End Of Comments}
178: -- ----------------------------------------------------------------------------
179: Procedure chk_non_updateable_args
180: (p_rec in pqp_erg_shd.g_rec_type
181: ) IS
182: --
183: l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
184: l_error EXCEPTION;

Line 192: IF NOT pqp_erg_shd.api_updating

188: --
189: -- Only proceed with the validation if a row exists for the current
190: -- record in the HR Schema.
191: --
192: IF NOT pqp_erg_shd.api_updating
193: (p_exception_group_id => p_rec.exception_group_id
194: ,p_object_version_number => p_rec.object_version_number
195: ) THEN
196: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

Line 203: nvl (pqp_erg_shd.g_old_rec.business_group_id, hr_api.g_number) THEN

199: fnd_message.raise_error;
200: END IF;
201: --
202: IF nvl(p_rec.business_group_id, hr_api.g_number) <>
203: nvl (pqp_erg_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
204: l_argument := 'business_group_id';
205: RAISE l_error;
206: END IF;
207:

Line 302: l_api_updating := pqp_erg_shd.api_updating

298: Begin
299: --
300: hr_utility.set_location('Entering:'||l_proc,5);
301: --
302: l_api_updating := pqp_erg_shd.api_updating
303: (p_exception_group_id => p_exception_group_id,
304: p_object_version_number => p_object_version_number);
305: --
306: hr_api.mandatory_arg_error

Line 314: <> nvl(pqp_erg_shd.g_old_rec.exception_report_id,hr_api.g_number)

310: );
311: --
312: if (l_api_updating
313: and nvl(p_exception_report_id,hr_api.g_number)
314: <> nvl(pqp_erg_shd.g_old_rec.exception_report_id,hr_api.g_number)
315: or not l_api_updating) and
316: p_exception_report_id is not null then
317: --
318: -- check if exception_report_id value exists in pqp_exception_reports table

Line 330: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_FK1');

326: --
327: -- raise error as FK does not relate to PK in pqp_exception_reports
328: -- table.
329: --
330: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_FK1');
331: --
332: end if;
333: --
334: close c1;

Line 389: l_api_updating := pqp_erg_shd.api_updating

385: Begin
386: --
387: hr_utility.set_location('Entering:'||l_proc,5);
388: --
389: l_api_updating := pqp_erg_shd.api_updating
390: (p_exception_group_id => p_exception_group_id,
391: p_object_version_number => p_object_version_number);
392: --
393: if (l_api_updating

Line 395: <> nvl(pqp_erg_shd.g_old_rec.consolidation_set_id,hr_api.g_number)

391: p_object_version_number => p_object_version_number);
392: --
393: if (l_api_updating
394: and nvl(p_consolidation_set_id,hr_api.g_number)
395: <> nvl(pqp_erg_shd.g_old_rec.consolidation_set_id,hr_api.g_number)
396: or not l_api_updating) and
397: p_consolidation_set_id is not null then
398: --
399: -- check if consolidation_set_id value exists in pqp_exception_reports table

Line 411: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_FK2');

407: --
408: -- raise error as FK does not relate to PK in pqp_exception_reports
409: -- table.
410: --
411: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_FK2');
412: --
413: end if;
414: --
415: close c1;

Line 470: l_api_updating := pqp_erg_shd.api_updating

466: Begin
467: --
468: hr_utility.set_location('Entering:'||l_proc,5);
469: --
470: l_api_updating := pqp_erg_shd.api_updating
471: (p_exception_group_id => p_exception_group_id,
472: p_object_version_number => p_object_version_number);
473: --
474: if (l_api_updating

Line 476: <> nvl(pqp_erg_shd.g_old_rec.payroll_id,hr_api.g_number)

472: p_object_version_number => p_object_version_number);
473: --
474: if (l_api_updating
475: and nvl(p_payroll_id,hr_api.g_number)
476: <> nvl(pqp_erg_shd.g_old_rec.payroll_id,hr_api.g_number)
477: or not l_api_updating) and
478: p_payroll_id is not null then
479: --
480: -- check if payroll_id value exists in pqp_exception_reports table

Line 492: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_FK3');

488: --
489: -- raise error as FK does not relate to PK in pqp_exception_reports
490: -- table.
491: --
492: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_FK3');
493: --
494: end if;
495: --
496: close c1;

Line 571: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_NAMECHK');

567: fetch c1 into l_dummy;
568: if c1%found then
569: close c1;
570:
571: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_NAMECHK');
572: end if;
573: --
574: hr_utility.set_location('Leaving:'||l_proc, 15);
575: End chk_group_name_unique;

Line 646: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_COMPKEY');

642: open c1;
643: fetch c1 into l_dummy;
644: if c1%found then
645: close c1;
646: pqp_erg_shd.constraint_error('PQP_REPORT_GROUPS_COMPKEY');
647: end if;
648: --
649: hr_utility.set_location('Leaving:'||l_proc, 15);
650: End chk_comp_key_unique;

Line 656: (p_rec in pqp_erg_shd.g_rec_type

652: -- ----------------------------------------------------------------------------
653: -- |---------------------------< insert_validate >----------------------------|
654: -- ----------------------------------------------------------------------------
655: Procedure insert_validate
656: (p_rec in pqp_erg_shd.g_rec_type
657: ) is
658: --
659: l_proc varchar2(72) := g_package||'insert_validate';
660: --

Line 713: (p_rec in pqp_erg_shd.g_rec_type

709: -- ----------------------------------------------------------------------------
710: -- |---------------------------< update_validate >----------------------------|
711: -- ----------------------------------------------------------------------------
712: Procedure update_validate
713: (p_rec in pqp_erg_shd.g_rec_type
714: ) is
715: --
716: l_proc varchar2(72) := g_package||'update_validate';
717: --

Line 774: (p_rec in pqp_erg_shd.g_rec_type

770: -- ----------------------------------------------------------------------------
771: -- |---------------------------< delete_validate >----------------------------|
772: -- ----------------------------------------------------------------------------
773: Procedure delete_validate
774: (p_rec in pqp_erg_shd.g_rec_type
775: ) is
776: --
777: l_proc varchar2(72) := g_package||'delete_validate';
778: --

Line 783: ,pqp_erg_shd.g_old_rec.business_group_id

779: Begin
780: hr_utility.set_location('Entering:'||l_proc, 5);
781: --
782: chk_startup_action(false
783: ,pqp_erg_shd.g_old_rec.business_group_id
784: ,pqp_erg_shd.g_old_rec.legislation_code
785: );
786: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
787: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp

Line 784: ,pqp_erg_shd.g_old_rec.legislation_code

780: hr_utility.set_location('Entering:'||l_proc, 5);
781: --
782: chk_startup_action(false
783: ,pqp_erg_shd.g_old_rec.business_group_id
784: ,pqp_erg_shd.g_old_rec.legislation_code
785: );
786: IF hr_startup_data_api_support.g_startup_mode NOT IN ('GENERIC','STARTUP') THEN
787: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate bus_grp
788: END IF;