DBA Data[Home] [Help]

APPS.AME_APPROVER_GROUP_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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