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

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

91: sysdate between start_date and (end_date - ame_util.oneSecond);
92: l_proc varchar2(72) := g_package||'group_is_in_group';
93: tempGroupId number;
94: begin
95: hr_utility.set_location('Entering:'|| l_proc, 10);
96: for tempGroup in groupMemberCursor(approvalGroupIdIn => p_approval_group_id) loop
97: if(tempGroup.parameter_name = ame_util.approverOamGroupId) then
98: tempGroupId := to_number(tempGroup.parameter);
99: if(tempGroupId = possiblyNestedGroupIdIn) then

Line 108: hr_utility.set_location(' Leaving:'||l_proc, 70);

104: end if;
105: end if;
106: end loop;
107: return(false);
108: hr_utility.set_location(' Leaving:'||l_proc, 70);
109: end group_is_in_group;
110: --
111: --
112: -- ----------------------------------------------------------------------------

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

126: sysdate between start_date and (end_date - ame_util.oneSecond);
127: l_proc varchar2(72) := g_package||'get_allowed_nested_groups';
128: tempIndex number;
129: begin
130: hr_utility.set_location('Entering:'|| l_proc, 10);
131: tempIndex := 0; /* pre-increment */
132: for tempGroup in groupCursor loop
133: /*
134: Check whether the group identified by groupIdIn G is nested in

Line 149: hr_utility.set_location(' Leaving:'||l_proc, 70);

145: allowedNestedGroupIdsOut(tempIndex) := to_char(tempGroup.approval_group_id);
146: allowedNestedGroupNamesOut(tempIndex) := tempGroup.name;
147: end if;
148: end loop;
149: hr_utility.set_location(' Leaving:'||l_proc, 70);
150: end get_allowed_nested_groups;
151:
152: -- ----------------------------------------------------------------------------
153: -- |-------------------------< CHK_APPROVER_TYPE >----------------------------|

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

212: and sysdate between start_date and
213: nvl(end_date-ame_util.oneSecond,SYSDATE);
214:
215: Begin
216: hr_utility.set_location('Entering:'||l_proc,10);
217: hr_api.mandatory_arg_error(p_api_name => l_proc
218: ,p_argument => 'APPROVAL_GROUP_ID'
219: ,p_argument_value => p_approval_group_id
220: );

Line 266: hr_utility.set_location(' Leaving:'||l_proc,30);

262: fnd_message.raise_error;
263: end if;
264: end loop;
265: end if;
266: hr_utility.set_location(' Leaving:'||l_proc,30);
267: exception
268: when app_exception.application_exception then
269: if hr_multi_message.exception_add
270: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'

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

268: when app_exception.application_exception then
269: if hr_multi_message.exception_add
270: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'
271: ) then
272: hr_utility.set_location(' Leaving:'||l_proc, 40);
273: raise;
274: end if;
275: hr_utility.set_location( ' Leaving:'||l_proc,50 );
276: End chk_approver_type;

Line 275: hr_utility.set_location( ' Leaving:'||l_proc,50 );

271: ) then
272: hr_utility.set_location(' Leaving:'||l_proc, 40);
273: raise;
274: end if;
275: hr_utility.set_location( ' Leaving:'||l_proc,50 );
276: End chk_approver_type;
277:
278: -- ----------------------------------------------------------------------------
279: -- |-------------------------< CHK_APPROVAL_GROUP_ID >---------------------------|

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

324: and t.is_static = 'Y'
325: and p_effective_date between t.start_date
326: and (t.end_date - ame_util.oneSecond);
327: Begin
328: hr_utility.set_location('Entering:'||l_proc,10);
329: hr_api.mandatory_arg_error(p_api_name => l_proc
330: ,p_argument => 'APPROVAL_GROUP_ID'
331: ,p_argument_value => p_approval_group_id
332: );

Line 349: hr_utility.set_location(' Leaving:'||l_proc,30);

345: if l_count = 0 then
346: fnd_message.set_name('PER','AME_400801_INV_STATIC_APG');
347: fnd_message.raise_error;
348: end if;
349: hr_utility.set_location(' Leaving:'||l_proc,30);
350: exception
351: when app_exception.application_exception then
352: if hr_multi_message.exception_add
353: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'

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

351: when app_exception.application_exception then
352: if hr_multi_message.exception_add
353: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'
354: ) then
355: hr_utility.set_location(' Leaving:'||l_proc, 40);
356: raise;
357: end if;
358: hr_utility.set_location( ' Leaving:'||l_proc,50 );
359: End chk_approval_group_id;

Line 358: hr_utility.set_location( ' Leaving:'||l_proc,50 );

354: ) then
355: hr_utility.set_location(' Leaving:'||l_proc, 40);
356: raise;
357: end if;
358: hr_utility.set_location( ' Leaving:'||l_proc,50 );
359: End chk_approval_group_id;
360:
361:
362: -- ----------------------------------------------------------------------------

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

390: --
391: l_proc varchar2(72) := g_package || 'CHK_PARAMETER_NAME';
392:
393: Begin
394: hr_utility.set_location('Entering:'||l_proc,10);
395: hr_api.mandatory_arg_error(p_api_name => l_proc
396: ,p_argument => 'PARAMETER_NAME'
397: ,p_argument_value => p_parameter_name
398: );

Line 404: hr_utility.set_location(' Leaving:'||l_proc,30);

400: if p_parameter_name not in ('OAM_group_id','wf_roles_name') then
401: fnd_message.set_name('PER','AME_400567_INV_APG_ITM_PAR_NAM');
402: fnd_message.raise_error;
403: end if;
404: hr_utility.set_location(' Leaving:'||l_proc,30);
405: exception
406: when app_exception.application_exception then
407: if hr_multi_message.exception_add
408: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER_NAME'

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

406: when app_exception.application_exception then
407: if hr_multi_message.exception_add
408: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER_NAME'
409: ) then
410: hr_utility.set_location(' Leaving:'||l_proc, 40);
411: raise;
412: end if;
413: hr_utility.set_location( ' Leaving:'||l_proc,50 );
414: End chk_parameter_name;

Line 413: hr_utility.set_location( ' Leaving:'||l_proc,50 );

409: ) then
410: hr_utility.set_location(' Leaving:'||l_proc, 40);
411: raise;
412: end if;
413: hr_utility.set_location( ' Leaving:'||l_proc,50 );
414: End chk_parameter_name;
415:
416:
417: -- ----------------------------------------------------------------------------

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

472: sysdate < expiration_date)
473: and rownum < 2;
474:
475: Begin
476: hr_utility.set_location('Entering:'||l_proc,10);
477: hr_api.mandatory_arg_error(p_api_name => l_proc
478: ,p_argument => 'PARAMETER'
479: ,p_argument_value => p_parameter
480: );

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

505: exit;
506: end if;
507: end loop;
508: if l_parameter_allowed = false then
509: hr_utility.set_location('Leaving:'|| l_proc, 20);
510: fnd_message.set_name('AME','NESTED_GROUP_INVALID');
511: fnd_message.raise_error;
512: end if;
513: */

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

514: if not ( is_nesting_allowed(p_group => p_approval_group_id
515: ,p_nest => to_number(p_parameter)
516: )
517: ) then
518: hr_utility.set_location('Leaving:'|| l_proc, 20);
519: fnd_message.set_name('PER','AME_400569_NEST_APG_NOT_ALLOW');
520: fnd_message.raise_error;
521: end if;
522:

Line 532: hr_utility.set_location(' Leaving:'||l_proc,30);

528: fnd_message.set_name('PER','AME_400568_INV_APG_ITM_PARAM');
529: fnd_message.raise_error;
530: end if;
531: end if;
532: hr_utility.set_location(' Leaving:'||l_proc,30);
533: exception
534: when app_exception.application_exception then
535: if hr_multi_message.exception_add
536: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'

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

534: when app_exception.application_exception then
535: if hr_multi_message.exception_add
536: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'
537: ) then
538: hr_utility.set_location(' Leaving:'||l_proc, 40);
539: raise;
540: end if;
541: hr_utility.set_location( ' Leaving:'||l_proc,50 );
542: End chk_parameter;

Line 541: hr_utility.set_location( ' Leaving:'||l_proc,50 );

537: ) then
538: hr_utility.set_location(' Leaving:'||l_proc, 40);
539: raise;
540: end if;
541: hr_utility.set_location( ' Leaving:'||l_proc,50 );
542: End chk_parameter;
543: -- ----------------------------------------------------------------------------
544: -- |-------------------------< CHK_ORDER_NUMBER>---------------------------|
545: -- ----------------------------------------------------------------------------

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

570: ) IS
571: --
572: l_proc varchar2(72) := g_package || 'CHK_ORDER_NUMBER';
573: Begin
574: hr_utility.set_location('Entering:'||l_proc,10);
575: hr_api.mandatory_arg_error(p_api_name => l_proc
576: ,p_argument => 'ORDER_NUMBER'
577: ,p_argument_value => p_order_number
578: );

Line 585: hr_utility.set_location(' Leaving:'||l_proc,30);

581: if p_order_number <=0 then
582: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
583: fnd_message.raise_error;
584: end if;
585: hr_utility.set_location(' Leaving:'||l_proc,30);
586: exception
587: when app_exception.application_exception then
588: if hr_multi_message.exception_add
589: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.ORDER_NUMBER'

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

587: when app_exception.application_exception then
588: if hr_multi_message.exception_add
589: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.ORDER_NUMBER'
590: ) then
591: hr_utility.set_location(' Leaving:'||l_proc, 40);
592: raise;
593: end if;
594: hr_utility.set_location( ' Leaving:'||l_proc,50 );
595: End chk_order_number;

Line 594: hr_utility.set_location( ' Leaving:'||l_proc,50 );

590: ) then
591: hr_utility.set_location(' Leaving:'||l_proc, 40);
592: raise;
593: end if;
594: hr_utility.set_location( ' Leaving:'||l_proc,50 );
595: End chk_order_number;
596: -- ----------------------------------------------------------------------------
597: -- |-------------------------< CHK_UNIQUE >---------------------------|
598: -- ----------------------------------------------------------------------------

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

639: and t.parameter_name = p_parameter_name
640: and t.parameter = p_parameter
641: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
642: Begin
643: hr_utility.set_location('Entering:'||l_proc,10);
644: hr_api.mandatory_arg_error(p_api_name => l_proc
645: ,p_argument => 'APPROVAL_GROUP_ID'
646: ,p_argument_value => p_approval_group_id
647: );

Line 664: hr_utility.set_location(' Leaving:'||l_proc,30);

660: if (l_count <> 0) then
661: fnd_message.set_name('PER','AME_400570_APG_ITM_NON_UNIQ');
662: fnd_message.raise_error;
663: end if;
664: hr_utility.set_location(' Leaving:'||l_proc,30);
665: exception
666: when app_exception.application_exception then
667: if hr_multi_message.exception_add
668: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'

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

666: when app_exception.application_exception then
667: if hr_multi_message.exception_add
668: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'
669: ) then
670: hr_utility.set_location(' Leaving:'||l_proc, 40);
671: raise;
672: end if;
673: hr_utility.set_location( ' Leaving:'||l_proc,50 );
674: End chk_unique;

Line 673: hr_utility.set_location( ' Leaving:'||l_proc,50 );

669: ) then
670: hr_utility.set_location(' Leaving:'||l_proc, 40);
671: raise;
672: end if;
673: hr_utility.set_location( ' Leaving:'||l_proc,50 );
674: End chk_unique;
675:
676: --
677: -- ----------------------------------------------------------------------------

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

976: --
977: l_proc varchar2(72) := g_package||'insert_validate';
978: --
979: Begin
980: hr_utility.set_location('Entering:'||l_proc, 5);
981: --
982: -- Validate Dependent Attributes
983: --
984: --

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

1015: ,p_parameter_name => p_rec.parameter_name
1016: ,p_parameter => p_rec.parameter
1017: );
1018:
1019: hr_utility.set_location(' Leaving:'||l_proc, 10);
1020: End insert_validate;
1021: --
1022: -- ----------------------------------------------------------------------------
1023: -- |---------------------------< update_validate >----------------------------|

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

1032: --
1033: l_proc varchar2(72) := g_package||'update_validate';
1034: --
1035: Begin
1036: hr_utility.set_location('Entering:'||l_proc, 5);
1037: --
1038: -- Validate Dependent Attributes
1039: --
1040: -- Call the datetrack update integrity operation

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

1055: -- User Entered calls to validate procedures
1056: chk_order_number (
1057: p_order_number => p_rec.order_number
1058: );
1059: hr_utility.set_location(' Leaving:'||l_proc, 10);
1060: End update_validate;
1061: --
1062: -- ----------------------------------------------------------------------------
1063: -- |---------------------------< delete_validate >----------------------------|

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

1072: --
1073: l_proc varchar2(72) := g_package||'delete_validate';
1074: --
1075: Begin
1076: hr_utility.set_location('Entering:'||l_proc, 5);
1077: --
1078: -- Call all supporting business operations
1079: --
1080: dt_delete_validate

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

1083: ,p_validation_end_date => p_validation_end_date
1084: ,p_approval_group_item_id => p_rec.approval_group_item_id
1085: );
1086: --
1087: hr_utility.set_location(' Leaving:'||l_proc, 10);
1088: End delete_validate;
1089: --
1090: end ame_gpi_bus;