DBA Data[Home] [Help]

APPS.AME_APPROVER_GROUP_API dependencies on HR_UTILITY

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

218: )
219: and sysdate >= start_date and sysdate < end_date;
220:
221: begin
222: hr_utility.set_location('Entering:'|| l_proc, 10);
223: --
224: -- Issue a savepoint
225: --
226: savepoint create_ame_approver_group;

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

332: p_start_date := l_start_date;
333: p_end_date := l_end_date;
334:
335: --
336: hr_utility.set_location(' Leaving:'||l_proc, 70);
337: exception
338: when hr_api.validate_enabled then
339: --
340: -- As the Validate_Enabled exception has been raised

Line 353: hr_utility.set_location(' Leaving:'||l_proc, 80);

349: p_object_version_number := null;
350: p_start_date := null;
351: p_end_date := null;
352: --
353: hr_utility.set_location(' Leaving:'||l_proc, 80);
354: when others then
355: --
356: -- A validation or unexpected error has occured
357: --

Line 368: hr_utility.set_location(' Leaving:'||l_proc, 90);

364: p_object_version_number := null;
365: p_start_date := null;
366: p_end_date := null;
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 90);
369: raise;
370: end create_ame_approver_group;
371: --
372: --

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

412: and sysdate >= start_date and sysdate < end_date;
413:
414: --
415: begin
416: hr_utility.set_location('Entering:'|| l_proc, 10);
417: --
418: -- Issue a savepoint
419: --
420: savepoint update_ame_approver_group;

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

525: --
526: p_start_date := l_start_date;
527: p_end_date := l_end_date;
528: --
529: hr_utility.set_location(' Leaving:'||l_proc, 70);
530: exception
531: when hr_api.validate_enabled then
532: --
533: -- As the Validate_Enabled exception has been raised

Line 546: hr_utility.set_location(' Leaving:'||l_proc, 80);

542: p_object_version_number := l_object_version_number;
543: p_start_date := null;
544: p_end_date := null;
545: --
546: hr_utility.set_location(' Leaving:'||l_proc, 80);
547: when others then
548: --
549: -- A validation or unexpected error has occured
550: --

Line 560: hr_utility.set_location(' Leaving:'||l_proc, 90);

556: p_object_version_number := l_object_version_number;
557: p_start_date := null;
558: p_end_date := null;
559: --
560: hr_utility.set_location(' Leaving:'||l_proc, 90);
561: raise;
562: end update_ame_approver_group;
563: --
564: --

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

627: l_rule_count number;
628: l_config_count number;
629: --
630: begin
631: hr_utility.set_location('Entering:'|| l_proc, 10);
632: --
633: -- Issue a savepoint
634: --
635: savepoint delete_approver_group;

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

747: --
748: p_start_date := l_start_date;
749: p_end_date := l_end_date;
750: --
751: hr_utility.set_location(' Leaving:'||l_proc, 70);
752: exception
753: when hr_api.validate_enabled then
754: --
755: -- As the Validate_Enabled exception has been raised

Line 768: hr_utility.set_location(' Leaving:'||l_proc, 80);

764: p_object_version_number := l_object_version_number;
765: p_start_date := null;
766: p_end_date := null;
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 80);
769: when others then
770: --
771: -- A validation or unexpected error has occured
772: --

Line 782: hr_utility.set_location(' Leaving:'||l_proc, 90);

778: p_object_version_number := l_object_version_number;
779: p_start_date := null;
780: p_end_date := null;
781: --
782: hr_utility.set_location(' Leaving:'||l_proc, 90);
783: raise;
784: end delete_ame_approver_group;
785: --
786: --

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

809: l_start_date date;
810: l_end_date date;
811: --
812: begin
813: hr_utility.set_location('Entering:'|| l_proc, 10);
814: --
815: -- Issue a savepoint
816: --
817: savepoint add_approver_group_config;

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

879: p_start_date := l_start_date;
880: p_end_date := l_end_date;
881: p_object_version_number := l_object_version_number;
882: --
883: hr_utility.set_location(' Leaving:'||l_proc, 70);
884: exception
885: when hr_api.validate_enabled then
886: --
887: -- As the Validate_Enabled exception has been raised

Line 900: hr_utility.set_location(' Leaving:'||l_proc, 80);

896: p_object_version_number := null;
897: p_start_date := null;
898: p_end_date := null;
899: --
900: hr_utility.set_location(' Leaving:'||l_proc, 80);
901: when others then
902: --
903: -- A validation or unexpected error has occured
904: --

Line 914: hr_utility.set_location(' Leaving:'||l_proc, 90);

910: p_object_version_number := null;
911: p_start_date := null;
912: p_end_date := null;
913: --
914: hr_utility.set_location(' Leaving:'||l_proc, 90);
915: raise;
916:
917: end create_approver_group_config;
918:

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

939: l_object_version_number number;
940: l_start_date date;
941: l_end_date date;
942: begin
943: hr_utility.set_location('Entering:'|| l_proc, 10);
944: --
945: -- Issue a savepoint
946: --
947: savepoint remove_approver_group_config;

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

1005: --
1006: p_start_date := l_start_date;
1007: p_end_date := l_end_date;
1008: --
1009: hr_utility.set_location(' Leaving:'||l_proc, 70);
1010: exception
1011: when hr_api.validate_enabled then
1012: --
1013: -- As the Validate_Enabled exception has been raised

Line 1026: hr_utility.set_location(' Leaving:'||l_proc, 80);

1022: p_object_version_number := l_object_version_number;
1023: p_start_date := null;
1024: p_end_date := null;
1025: --
1026: hr_utility.set_location(' Leaving:'||l_proc, 80);
1027: when others then
1028: --
1029: -- A validation or unexpected error has occured
1030: --

Line 1040: hr_utility.set_location(' Leaving:'||l_proc, 90);

1036: p_object_version_number := l_object_version_number;
1037: p_start_date := null;
1038: p_end_date := null;
1039: --
1040: hr_utility.set_location(' Leaving:'||l_proc, 90);
1041: raise;
1042:
1043: end delete_approver_group_config;
1044: --

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

1066: l_start_date date;
1067: l_end_date date;
1068: --
1069: begin
1070: hr_utility.set_location('Entering:'|| l_proc, 10);
1071: --
1072: -- Issue a savepoint
1073: --
1074: savepoint update_approver_group_config;

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

1138: --
1139: p_start_date := l_start_date;
1140: p_end_date := l_end_date;
1141: --
1142: hr_utility.set_location(' Leaving:'||l_proc, 70);
1143: exception
1144: when hr_api.validate_enabled then
1145: --
1146: -- As the Validate_Enabled exception has been raised

Line 1159: hr_utility.set_location(' Leaving:'||l_proc, 80);

1155: p_object_version_number := l_object_version_number;
1156: p_start_date := null;
1157: p_end_date := null;
1158: --
1159: hr_utility.set_location(' Leaving:'||l_proc, 80);
1160: when others then
1161: --
1162: -- A validation or unexpected error has occured
1163: --

Line 1173: hr_utility.set_location(' Leaving:'||l_proc, 90);

1169: p_object_version_number := l_object_version_number;
1170: p_start_date := null;
1171: p_end_date := null;
1172: --
1173: hr_utility.set_location(' Leaving:'||l_proc, 90);
1174: raise;
1175:
1176: end update_approver_group_config;
1177: --

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

1201: l_end_date date;
1202: l_parameter_allowed boolean;
1203: --
1204: begin
1205: hr_utility.set_location('Entering:'|| l_proc, 10);
1206: --
1207: -- Issue a savepoint
1208: --
1209: savepoint add_approver_group_item;

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

1275: p_start_date := l_start_date;
1276: p_end_date := l_end_date;
1277: p_object_version_number := l_object_version_number;
1278: --
1279: hr_utility.set_location(' Leaving:'||l_proc, 70);
1280: exception
1281: when hr_api.validate_enabled then
1282: --
1283: -- As the Validate_Enabled exception has been raised

Line 1296: hr_utility.set_location(' Leaving:'||l_proc, 80);

1292: p_object_version_number := null;
1293: p_start_date := null;
1294: p_end_date := null;
1295: --
1296: hr_utility.set_location(' Leaving:'||l_proc, 80);
1297: when others then
1298: --
1299: -- A validation or unexpected error has occured
1300: --

Line 1310: hr_utility.set_location(' Leaving:'||l_proc, 90);

1306: p_object_version_number := null;
1307: p_start_date := null;
1308: p_end_date := null;
1309: --
1310: hr_utility.set_location(' Leaving:'||l_proc, 90);
1311: raise;
1312:
1313: end create_approver_group_item;
1314: --

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

1340: where approval_group_item_id = p_approval_group_item_id
1341: and sysdate >= start_date and sysdate < end_date;
1342: --
1343: begin
1344: hr_utility.set_location('Entering:'|| l_proc, 10);
1345: --
1346: -- Issue a savepoint
1347: --
1348: savepoint remove_approver_group_item;

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

1417: --
1418: p_start_date := l_start_date;
1419: p_end_date := l_end_date;
1420: --
1421: hr_utility.set_location(' Leaving:'||l_proc, 70);
1422: exception
1423: when hr_api.validate_enabled then
1424: --
1425: -- As the Validate_Enabled exception has been raised

Line 1438: hr_utility.set_location(' Leaving:'||l_proc, 80);

1434: p_object_version_number := l_object_version_number;
1435: p_start_date := null;
1436: p_end_date := null;
1437: --
1438: hr_utility.set_location(' Leaving:'||l_proc, 80);
1439: when others then
1440: --
1441: -- A validation or unexpected error has occured
1442: --

Line 1452: hr_utility.set_location(' Leaving:'||l_proc, 90);

1448: p_object_version_number := l_object_version_number;
1449: p_start_date := null;
1450: p_end_date := null;
1451: --
1452: hr_utility.set_location(' Leaving:'||l_proc, 90);
1453: raise;
1454:
1455: end delete_approver_group_item;
1456:

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

1484: where approval_group_item_id = p_approval_group_item_id
1485: and sysdate between start_date and end_date;
1486: --
1487: begin
1488: hr_utility.set_location('Entering:'|| l_proc, 10);
1489: --
1490: -- Issue a savepoint
1491: --
1492: savepoint update_approver_group_item;

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

1564: --
1565: p_start_date := l_start_date;
1566: p_end_date := l_end_date;
1567: --
1568: hr_utility.set_location(' Leaving:'||l_proc, 70);
1569: exception
1570: when hr_api.validate_enabled then
1571: --
1572: -- As the Validate_Enabled exception has been raised

Line 1585: hr_utility.set_location(' Leaving:'||l_proc, 80);

1581: p_object_version_number := l_object_version_number;
1582: p_start_date := null;
1583: p_end_date := null;
1584: --
1585: hr_utility.set_location(' Leaving:'||l_proc, 80);
1586: when others then
1587: --
1588: -- A validation or unexpected error has occured
1589: --

Line 1599: hr_utility.set_location(' Leaving:'||l_proc, 90);

1595: p_object_version_number := l_object_version_number;
1596: p_start_date := null;
1597: p_end_date := null;
1598: --
1599: hr_utility.set_location(' Leaving:'||l_proc, 90);
1600: raise;
1601:
1602: end update_approver_group_item;
1603: