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.PSP_PEE_BUS dependencies on HR_UTILITY

Line 43: hr_utility.set_location('Entering:'|| l_proc, 10);

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

Line 83: hr_utility.set_location(' Leaving:'|| l_proc, 20);

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

Line 112: hr_utility.set_location('Entering:'|| l_proc, 10);

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

Line 130: hr_utility.set_location(l_proc, 20);

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := psp_pee_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

Line 147: hr_utility.set_location(l_proc,30);

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

Line 156: hr_utility.set_location(' Leaving:'|| l_proc, 40);

152: close csr_leg_code;
153: psp_pee_bus.g_external_effort_line_id := p_external_effort_line_id;
154: psp_pee_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

Line 195: hr_utility.set_location('Entering:'||l_proc,10);

191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --
194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.external_effort_line_id is not null) and (
198: nvl(psp_pee_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

Line 274: hr_utility.set_location(' Leaving:'||l_proc,20);

270: ,p_attribute15_value => p_rec.attribute15
271: );
272: end if;
273: --
274: hr_utility.set_location(' Leaving:'||l_proc,20);
275: end chk_df;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 369: hr_utility.set_message(8403, 'PSP_ER_INVALID_BUSINESS_GROUP');

365: OPEN business_group_csr;
366: FETCH business_group_csr INTO l_business_group_id;
367: IF business_group_csr%NOTFOUND THEN
368: CLOSE business_group_csr;
369: hr_utility.set_message(8403, 'PSP_ER_INVALID_BUSINESS_GROUP');
370: hr_utility.raise_error;
371: END IF;
372: CLOSE business_group_csr;
373: EXCEPTION

Line 370: hr_utility.raise_error;

366: FETCH business_group_csr INTO l_business_group_id;
367: IF business_group_csr%NOTFOUND THEN
368: CLOSE business_group_csr;
369: hr_utility.set_message(8403, 'PSP_ER_INVALID_BUSINESS_GROUP');
370: hr_utility.raise_error;
371: END IF;
372: CLOSE business_group_csr;
373: EXCEPTION
374: WHEN app_exception.application_exception THEN

Line 410: hr_utility.set_message(8403, 'PSP_ER_INVALID_SET_OF_BOOKS');

406: OPEN set_of_books_id_csr;
407: FETCH set_of_books_id_csr INTO l_set_of_books_id;
408: if set_of_books_id_csr%notfound then
409: CLOSE set_of_books_id_csr;
410: hr_utility.set_message(8403, 'PSP_ER_INVALID_SET_OF_BOOKS');
411: fnd_message.set_token('SET_OF_BOOKS_ID',l_set_of_books_id);
412: hr_utility.raise_error;
413: END IF;
414: CLOSE set_of_books_id_csr;

Line 412: hr_utility.raise_error;

408: if set_of_books_id_csr%notfound then
409: CLOSE set_of_books_id_csr;
410: hr_utility.set_message(8403, 'PSP_ER_INVALID_SET_OF_BOOKS');
411: fnd_message.set_token('SET_OF_BOOKS_ID',l_set_of_books_id);
412: hr_utility.raise_error;
413: END IF;
414: CLOSE set_of_books_id_csr;
415: EXCEPTION
416: WHEN app_exception.application_exception THEN

Line 469: hr_utility.set_message(8403, 'PSP_ER_INVALID_PERSON');

465: OPEN person_id_csr;
466: FETCH person_id_csr INTO l_person_id;
467: if person_id_csr%notfound then
468: CLOSE person_id_csr;
469: hr_utility.set_message(8403, 'PSP_ER_INVALID_PERSON');
470: fnd_message.set_token('PERSON_ID',l_person_id);
471: hr_utility.raise_error;
472: END IF;
473: CLOSE person_id_csr;

Line 471: hr_utility.raise_error;

467: if person_id_csr%notfound then
468: CLOSE person_id_csr;
469: hr_utility.set_message(8403, 'PSP_ER_INVALID_PERSON');
470: fnd_message.set_token('PERSON_ID',l_person_id);
471: hr_utility.raise_error;
472: END IF;
473: CLOSE person_id_csr;
474: EXCEPTION
475: WHEN app_exception.application_exception THEN

Line 541: hr_utility.set_message(8403, 'PSP_ER_INVALID_ASSIGNMENT');

537: OPEN assignment_id_csr;
538: FETCH assignment_id_csr INTO l_assignment_id;
539: if assignment_id_csr%notfound then
540: CLOSE assignment_id_csr;
541: hr_utility.set_message(8403, 'PSP_ER_INVALID_ASSIGNMENT');
542: fnd_message.set_token('ASSIGNMENT_ID',l_assignment_id);
543: hr_utility.raise_error;
544: END IF;
545: CLOSE assignment_id_csr;

Line 543: hr_utility.raise_error;

539: if assignment_id_csr%notfound then
540: CLOSE assignment_id_csr;
541: hr_utility.set_message(8403, 'PSP_ER_INVALID_ASSIGNMENT');
542: fnd_message.set_token('ASSIGNMENT_ID',l_assignment_id);
543: hr_utility.raise_error;
544: END IF;
545: CLOSE assignment_id_csr;
546: EXCEPTION
547: WHEN app_exception.application_exception THEN

Line 597: hr_utility.set_message(8403, 'PSP_ER_INVALID_CURRENCY');

593: OPEN currency_csr(p_currency_code, p_distribution_date);
594: FETCH currency_csr INTO l_currency_code;
595: if currency_csr%notfound then
596: CLOSE currency_csr;
597: hr_utility.set_message(8403, 'PSP_ER_INVALID_CURRENCY');
598: fnd_message.set_token('CURRENCY_CODE',l_currency_code);
599: hr_utility.raise_error;
600: END IF;
601: CLOSE currency_csr;

Line 599: hr_utility.raise_error;

595: if currency_csr%notfound then
596: CLOSE currency_csr;
597: hr_utility.set_message(8403, 'PSP_ER_INVALID_CURRENCY');
598: fnd_message.set_token('CURRENCY_CODE',l_currency_code);
599: hr_utility.raise_error;
600: END IF;
601: CLOSE currency_csr;
602: EXCEPTION
603: WHEN app_exception.application_exception THEN

Line 620: hr_utility.set_message(8403, 'PSP_POETA_GL');

616: (p_rec IN psp_pee_shd.g_rec_type
617: ) IS
618: BEGIN
619: IF p_rec.project_id IS NULL AND p_rec.gl_code_combination_id IS NULL THEN
620: hr_utility.set_message(8403, 'PSP_POETA_GL');
621: hr_utility.raise_error;
622: END IF;
623:
624: IF p_rec.gl_code_combination_id IS NOT NULL

Line 621: hr_utility.raise_error;

617: ) IS
618: BEGIN
619: IF p_rec.project_id IS NULL AND p_rec.gl_code_combination_id IS NULL THEN
620: hr_utility.set_message(8403, 'PSP_POETA_GL');
621: hr_utility.raise_error;
622: END IF;
623:
624: IF p_rec.gl_code_combination_id IS NOT NULL
625: AND (p_rec.project_id IS NOT NULL

Line 632: hr_utility.set_message(8403, 'PSP_ER_EXTRA_CI');

628: OR p_rec.expenditure_organization_id IS NOT NULL
629: OR p_rec.expenditure_type IS NOT NULL
630: )
631: THEN
632: hr_utility.set_message(8403, 'PSP_ER_EXTRA_CI');
633: hr_utility.raise_error;
634: END IF;
635: EXCEPTION
636: WHEN app_exception.application_exception THEN

Line 633: hr_utility.raise_error;

629: OR p_rec.expenditure_type IS NOT NULL
630: )
631: THEN
632: hr_utility.set_message(8403, 'PSP_ER_EXTRA_CI');
633: hr_utility.raise_error;
634: END IF;
635: EXCEPTION
636: WHEN app_exception.application_exception THEN
637: IF hr_multi_message.exception_add() THEN

Line 675: hr_utility.set_message(8403, 'PSP_ER_INVALID_GLCC');

671: OPEN gl_code_combination_csr(p_gl_code_combination_id);
672: FETCH gl_code_combination_csr INTO l_gl_code_combination_id;
673: IF gl_code_combination_csr%notfound then
674: CLOSE gl_code_combination_csr;
675: hr_utility.set_message(8403, 'PSP_ER_INVALID_GLCC');
676: fnd_message.set_token('GL_CODE_COMBINATION_ID',l_gl_code_combination_id);
677: hr_utility.raise_error;
678: END IF;
679: CLOSE gl_code_combination_csr;

Line 677: hr_utility.raise_error;

673: IF gl_code_combination_csr%notfound then
674: CLOSE gl_code_combination_csr;
675: hr_utility.set_message(8403, 'PSP_ER_INVALID_GLCC');
676: fnd_message.set_token('GL_CODE_COMBINATION_ID',l_gl_code_combination_id);
677: hr_utility.raise_error;
678: END IF;
679: CLOSE gl_code_combination_csr;
680: EXCEPTION
681: WHEN app_exception.application_exception THEN

Line 726: hr_utility.set_message(8403, 'PSP_ER_INVALID_PROJECT_ID');

722: OPEN project_id_csr(p_project_id, p_distribution_date);
723: FETCH project_id_csr INTO l_project_id;
724: if project_id_csr%notfound then
725: CLOSE project_id_csr;
726: hr_utility.set_message(8403, 'PSP_ER_INVALID_PROJECT_ID');
727: fnd_message.set_token('PROJECT_ID',l_project_id);
728: hr_utility.raise_error;
729: END IF;
730: CLOSE project_id_csr;

Line 728: hr_utility.raise_error;

724: if project_id_csr%notfound then
725: CLOSE project_id_csr;
726: hr_utility.set_message(8403, 'PSP_ER_INVALID_PROJECT_ID');
727: fnd_message.set_token('PROJECT_ID',l_project_id);
728: hr_utility.raise_error;
729: END IF;
730: CLOSE project_id_csr;
731: EXCEPTION
732: WHEN app_exception.application_exception THEN

Line 776: hr_utility.set_message(8403, 'PSP_ER_INVALID_TASK_ID');

772: OPEN task_id_csr(p_task_id, p_distribution_date);
773: FETCH task_id_csr INTO l_task_id;
774: if task_id_csr%notfound then
775: CLOSE task_id_csr;
776: hr_utility.set_message(8403, 'PSP_ER_INVALID_TASK_ID');
777: fnd_message.set_token('TASK_ID',l_task_id);
778: hr_utility.raise_error;
779: END IF;
780: CLOSE task_id_csr;

Line 778: hr_utility.raise_error;

774: if task_id_csr%notfound then
775: CLOSE task_id_csr;
776: hr_utility.set_message(8403, 'PSP_ER_INVALID_TASK_ID');
777: fnd_message.set_token('TASK_ID',l_task_id);
778: hr_utility.raise_error;
779: END IF;
780: CLOSE task_id_csr;
781: EXCEPTION
782: WHEN app_exception.application_exception THEN

Line 826: hr_utility.set_message(8403, 'PSP_ER_INVALID_AWARD_ID');

822: OPEN award_id_csr(p_award_id, p_distribution_date);
823: FETCH award_id_csr INTO l_award_id;
824: if award_id_csr%notfound then
825: CLOSE award_id_csr;
826: hr_utility.set_message(8403, 'PSP_ER_INVALID_AWARD_ID');
827: fnd_message.set_token('AWARD_ID',l_award_id);
828: hr_utility.raise_error;
829: END IF;
830: CLOSE award_id_csr;

Line 828: hr_utility.raise_error;

824: if award_id_csr%notfound then
825: CLOSE award_id_csr;
826: hr_utility.set_message(8403, 'PSP_ER_INVALID_AWARD_ID');
827: fnd_message.set_token('AWARD_ID',l_award_id);
828: hr_utility.raise_error;
829: END IF;
830: CLOSE award_id_csr;
831: EXCEPTION
832: WHEN app_exception.application_exception THEN

Line 877: hr_utility.set_message(8403, 'PSP_ER_INVALID_EXP_ORG_ID');

873: OPEN expenditure_organization_csr(p_expenditure_organization_id, p_distribution_date);
874: FETCH expenditure_organization_csr INTO l_expenditure_organization_id;
875: if expenditure_organization_csr%notfound then
876: CLOSE expenditure_organization_csr;
877: hr_utility.set_message(8403, 'PSP_ER_INVALID_EXP_ORG_ID');
878: fnd_message.set_token('EXP_ORG_ID',l_expenditure_organization_id);
879: hr_utility.raise_error;
880: END IF;
881: CLOSE expenditure_organization_csr;

Line 879: hr_utility.raise_error;

875: if expenditure_organization_csr%notfound then
876: CLOSE expenditure_organization_csr;
877: hr_utility.set_message(8403, 'PSP_ER_INVALID_EXP_ORG_ID');
878: fnd_message.set_token('EXP_ORG_ID',l_expenditure_organization_id);
879: hr_utility.raise_error;
880: END IF;
881: CLOSE expenditure_organization_csr;
882: EXCEPTION
883: WHEN app_exception.application_exception THEN

Line 1288: hr_utility.set_location('Entering:'||l_proc, 5);

1284: --
1285: l_proc varchar2(72) := g_package||'insert_validate';
1286: --
1287: Begin
1288: hr_utility.set_location('Entering:'||l_proc, 5);
1289: --
1290: -- Call all supporting business operations
1291: --
1292:

Line 1366: hr_utility.set_location(' Leaving:'||l_proc, 10);

1362: END IF;
1363:
1364: psp_pee_bus.chk_df(p_rec);
1365: --
1366: hr_utility.set_location(' Leaving:'||l_proc, 10);
1367: End insert_validate;
1368: --
1369: -- ----------------------------------------------------------------------------
1370: -- |---------------------------< update_validate >----------------------------|

Line 1379: hr_utility.set_location('Entering:'||l_proc, 5);

1375: --
1376: l_proc varchar2(72) := g_package||'update_validate';
1377: --
1378: Begin
1379: hr_utility.set_location('Entering:'||l_proc, 5);
1380: --
1381: -- Call all supporting business operations
1382: --
1383: hr_api.validate_bus_grp_id

Line 1461: hr_utility.set_location(' Leaving:'||l_proc, 10);

1457: --
1458: --
1459: psp_pee_bus.chk_df(p_rec);
1460: --
1461: hr_utility.set_location(' Leaving:'||l_proc, 10);
1462: End update_validate;
1463: --
1464: -- ----------------------------------------------------------------------------
1465: -- |---------------------------< delete_validate >----------------------------|

Line 1474: hr_utility.set_location('Entering:'||l_proc, 5);

1470: --
1471: l_proc varchar2(72) := g_package||'delete_validate';
1472: --
1473: Begin
1474: hr_utility.set_location('Entering:'||l_proc, 5);
1475: --
1476: -- Call all supporting business operations
1477: --
1478: chk_existing_eff_report(p_rec.person_id, p_rec.assignment_id, p_rec.distribution_date);

Line 1481: hr_utility.set_location(' Leaving:'||l_proc, 10);

1477: --
1478: chk_existing_eff_report(p_rec.person_id, p_rec.assignment_id, p_rec.distribution_date);
1479:
1480:
1481: hr_utility.set_location(' Leaving:'||l_proc, 10);
1482: End delete_validate;
1483: --
1484: end psp_pee_bus;