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 89: hr_utility.set_location('Entering:'|| l_proc, 10);

85: sysdate between start_date and (end_date - ame_util.oneSecond);
86: l_proc varchar2(72) := g_package||'group_is_in_group';
87: tempGroupId number;
88: begin
89: hr_utility.set_location('Entering:'|| l_proc, 10);
90: for tempGroup in groupMemberCursor(approvalGroupIdIn => p_approval_group_id) loop
91: if(tempGroup.parameter_name = ame_util.approverOamGroupId) then
92: tempGroupId := to_number(tempGroup.parameter);
93: if(tempGroupId = possiblyNestedGroupIdIn) then

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

98: end if;
99: end if;
100: end loop;
101: return(false);
102: hr_utility.set_location(' Leaving:'||l_proc, 70);
103: end group_is_in_group;
104: --
105: --
106: -- ----------------------------------------------------------------------------

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

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

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

139: allowedNestedGroupIdsOut(tempIndex) := to_char(tempGroup.approval_group_id);
140: allowedNestedGroupNamesOut(tempIndex) := tempGroup.name;
141: end if;
142: end loop;
143: hr_utility.set_location(' Leaving:'||l_proc, 70);
144: end get_allowed_nested_groups;
145:
146: -- ----------------------------------------------------------------------------
147: -- |-------------------------< CHK_APPROVER_TYPE >----------------------------|

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

206: and sysdate between start_date and
207: nvl(end_date-ame_util.oneSecond,SYSDATE);
208:
209: Begin
210: hr_utility.set_location('Entering:'||l_proc,10);
211: hr_api.mandatory_arg_error(p_api_name => l_proc
212: ,p_argument => 'APPROVAL_GROUP_ID'
213: ,p_argument_value => p_approval_group_id
214: );

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

256: fnd_message.raise_error;
257: end if;
258: end loop;
259: end if;
260: hr_utility.set_location(' Leaving:'||l_proc,30);
261: exception
262: when app_exception.application_exception then
263: if hr_multi_message.exception_add
264: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'

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

262: when app_exception.application_exception then
263: if hr_multi_message.exception_add
264: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'
265: ) then
266: hr_utility.set_location(' Leaving:'||l_proc, 40);
267: raise;
268: end if;
269: hr_utility.set_location( ' Leaving:'||l_proc,50 );
270: End chk_approver_type;

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

265: ) then
266: hr_utility.set_location(' Leaving:'||l_proc, 40);
267: raise;
268: end if;
269: hr_utility.set_location( ' Leaving:'||l_proc,50 );
270: End chk_approver_type;
271:
272: -- ----------------------------------------------------------------------------
273: -- |-------------------------< CHK_APPROVAL_GROUP_ID >---------------------------|

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

318: and t.is_static = 'Y'
319: and p_effective_date between t.start_date
320: and (t.end_date - ame_util.oneSecond);
321: Begin
322: hr_utility.set_location('Entering:'||l_proc,10);
323: hr_api.mandatory_arg_error(p_api_name => l_proc
324: ,p_argument => 'APPROVAL_GROUP_ID'
325: ,p_argument_value => p_approval_group_id
326: );

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

339: if l_count = 0 then
340: fnd_message.set_name('PER','AME_400801_INV_STATIC_APG');
341: fnd_message.raise_error;
342: end if;
343: hr_utility.set_location(' Leaving:'||l_proc,30);
344: exception
345: when app_exception.application_exception then
346: if hr_multi_message.exception_add
347: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'

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

345: when app_exception.application_exception then
346: if hr_multi_message.exception_add
347: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.APPROVAL_GROUP_ID'
348: ) then
349: hr_utility.set_location(' Leaving:'||l_proc, 40);
350: raise;
351: end if;
352: hr_utility.set_location( ' Leaving:'||l_proc,50 );
353: End chk_approval_group_id;

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

348: ) then
349: hr_utility.set_location(' Leaving:'||l_proc, 40);
350: raise;
351: end if;
352: hr_utility.set_location( ' Leaving:'||l_proc,50 );
353: End chk_approval_group_id;
354:
355:
356: -- ----------------------------------------------------------------------------

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

384: --
385: l_proc varchar2(72) := g_package || 'CHK_PARAMETER_NAME';
386:
387: Begin
388: hr_utility.set_location('Entering:'||l_proc,10);
389: hr_api.mandatory_arg_error(p_api_name => l_proc
390: ,p_argument => 'PARAMETER_NAME'
391: ,p_argument_value => p_parameter_name
392: );

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

394: if p_parameter_name not in ('OAM_group_id','wf_roles_name') then
395: fnd_message.set_name('PER','AME_400567_INV_APG_ITM_PAR_NAM');
396: fnd_message.raise_error;
397: end if;
398: hr_utility.set_location(' Leaving:'||l_proc,30);
399: exception
400: when app_exception.application_exception then
401: if hr_multi_message.exception_add
402: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER_NAME'

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

400: when app_exception.application_exception then
401: if hr_multi_message.exception_add
402: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER_NAME'
403: ) then
404: hr_utility.set_location(' Leaving:'||l_proc, 40);
405: raise;
406: end if;
407: hr_utility.set_location( ' Leaving:'||l_proc,50 );
408: End chk_parameter_name;

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

403: ) then
404: hr_utility.set_location(' Leaving:'||l_proc, 40);
405: raise;
406: end if;
407: hr_utility.set_location( ' Leaving:'||l_proc,50 );
408: End chk_parameter_name;
409:
410:
411: -- ----------------------------------------------------------------------------

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

466: sysdate < expiration_date)
467: and rownum < 2;
468:
469: Begin
470: hr_utility.set_location('Entering:'||l_proc,10);
471: hr_api.mandatory_arg_error(p_api_name => l_proc
472: ,p_argument => 'PARAMETER'
473: ,p_argument_value => p_parameter
474: );

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

499: exit;
500: end if;
501: end loop;
502: if l_parameter_allowed = false then
503: hr_utility.set_location('Leaving:'|| l_proc, 20);
504: fnd_message.set_name('AME','NESTED_GROUP_INVALID');
505: fnd_message.raise_error;
506: end if;
507: */

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

508: if not ( is_nesting_allowed(p_group => p_approval_group_id
509: ,p_nest => to_number(p_parameter)
510: )
511: ) then
512: hr_utility.set_location('Leaving:'|| l_proc, 20);
513: fnd_message.set_name('PER','AME_400569_NEST_APG_NOT_ALLOW');
514: fnd_message.raise_error;
515: end if;
516:

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

522: fnd_message.set_name('PER','AME_400568_INV_APG_ITM_PARAM');
523: fnd_message.raise_error;
524: end if;
525: end if;
526: hr_utility.set_location(' Leaving:'||l_proc,30);
527: exception
528: when app_exception.application_exception then
529: if hr_multi_message.exception_add
530: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'

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

528: when app_exception.application_exception then
529: if hr_multi_message.exception_add
530: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'
531: ) then
532: hr_utility.set_location(' Leaving:'||l_proc, 40);
533: raise;
534: end if;
535: hr_utility.set_location( ' Leaving:'||l_proc,50 );
536: End chk_parameter;

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

531: ) then
532: hr_utility.set_location(' Leaving:'||l_proc, 40);
533: raise;
534: end if;
535: hr_utility.set_location( ' Leaving:'||l_proc,50 );
536: End chk_parameter;
537: -- ----------------------------------------------------------------------------
538: -- |-------------------------< CHK_ORDER_NUMBER>---------------------------|
539: -- ----------------------------------------------------------------------------

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

564: ) IS
565: --
566: l_proc varchar2(72) := g_package || 'CHK_ORDER_NUMBER';
567: Begin
568: hr_utility.set_location('Entering:'||l_proc,10);
569: hr_api.mandatory_arg_error(p_api_name => l_proc
570: ,p_argument => 'ORDER_NUMBER'
571: ,p_argument_value => p_order_number
572: );

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

575: if p_order_number <=0 then
576: fnd_message.set_name('PER','AME_400565_INVALID_ORDER_NUM');
577: fnd_message.raise_error;
578: end if;
579: hr_utility.set_location(' Leaving:'||l_proc,30);
580: exception
581: when app_exception.application_exception then
582: if hr_multi_message.exception_add
583: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.ORDER_NUMBER'

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

581: when app_exception.application_exception then
582: if hr_multi_message.exception_add
583: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.ORDER_NUMBER'
584: ) then
585: hr_utility.set_location(' Leaving:'||l_proc, 40);
586: raise;
587: end if;
588: hr_utility.set_location( ' Leaving:'||l_proc,50 );
589: End chk_order_number;

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

584: ) then
585: hr_utility.set_location(' Leaving:'||l_proc, 40);
586: raise;
587: end if;
588: hr_utility.set_location( ' Leaving:'||l_proc,50 );
589: End chk_order_number;
590: -- ----------------------------------------------------------------------------
591: -- |-------------------------< CHK_UNIQUE >---------------------------|
592: -- ----------------------------------------------------------------------------

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

633: and t.parameter_name = p_parameter_name
634: and t.parameter = p_parameter
635: and p_effective_date between t.start_date and (t.end_date - ame_util.oneSecond);
636: Begin
637: hr_utility.set_location('Entering:'||l_proc,10);
638: hr_api.mandatory_arg_error(p_api_name => l_proc
639: ,p_argument => 'APPROVAL_GROUP_ID'
640: ,p_argument_value => p_approval_group_id
641: );

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

654: if (l_count <> 0) then
655: fnd_message.set_name('PER','AME_400570_APG_ITM_NON_UNIQ');
656: fnd_message.raise_error;
657: end if;
658: hr_utility.set_location(' Leaving:'||l_proc,30);
659: exception
660: when app_exception.application_exception then
661: if hr_multi_message.exception_add
662: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'

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

660: when app_exception.application_exception then
661: if hr_multi_message.exception_add
662: (p_associated_column1 => 'AME_APPROVAL_GROUP_ITEMS.PARAMETER'
663: ) then
664: hr_utility.set_location(' Leaving:'||l_proc, 40);
665: raise;
666: end if;
667: hr_utility.set_location( ' Leaving:'||l_proc,50 );
668: End chk_unique;

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

663: ) then
664: hr_utility.set_location(' Leaving:'||l_proc, 40);
665: raise;
666: end if;
667: hr_utility.set_location( ' Leaving:'||l_proc,50 );
668: End chk_unique;
669:
670: --
671: -- ----------------------------------------------------------------------------

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

970: --
971: l_proc varchar2(72) := g_package||'insert_validate';
972: --
973: Begin
974: hr_utility.set_location('Entering:'||l_proc, 5);
975: --
976: -- Validate Dependent Attributes
977: --
978: --

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

1009: ,p_parameter_name => p_rec.parameter_name
1010: ,p_parameter => p_rec.parameter
1011: );
1012:
1013: hr_utility.set_location(' Leaving:'||l_proc, 10);
1014: End insert_validate;
1015: --
1016: -- ----------------------------------------------------------------------------
1017: -- |---------------------------< update_validate >----------------------------|

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

1026: --
1027: l_proc varchar2(72) := g_package||'update_validate';
1028: --
1029: Begin
1030: hr_utility.set_location('Entering:'||l_proc, 5);
1031: --
1032: -- Validate Dependent Attributes
1033: --
1034: -- Call the datetrack update integrity operation

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

1049: -- User Entered calls to validate procedures
1050: chk_order_number (
1051: p_order_number => p_rec.order_number
1052: );
1053: hr_utility.set_location(' Leaving:'||l_proc, 10);
1054: End update_validate;
1055: --
1056: -- ----------------------------------------------------------------------------
1057: -- |---------------------------< delete_validate >----------------------------|

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

1066: --
1067: l_proc varchar2(72) := g_package||'delete_validate';
1068: --
1069: Begin
1070: hr_utility.set_location('Entering:'||l_proc, 5);
1071: --
1072: -- Call all supporting business operations
1073: --
1074: dt_delete_validate

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

1077: ,p_validation_end_date => p_validation_end_date
1078: ,p_approval_group_item_id => p_rec.approval_group_item_id
1079: );
1080: --
1081: hr_utility.set_location(' Leaving:'||l_proc, 10);
1082: End delete_validate;
1083: --
1084: end ame_gpi_bus;