APPS.AME_ACTION_API dependencies on HR_API

Line 287: ,p_language_code in varchar2 default hr_api.userenv_lang

283: -- ----------------------------------------------------------------------------
284: --
285: procedure create_ame_action_type
286: (p_validate in boolean default false
287: ,p_language_code in varchar2 default hr_api.userenv_lang
288: ,p_name in varchar2
289: ,p_procedure_name in varchar2
290: ,p_dynamic_description in varchar2
291: ,p_description in varchar2

Line 331: hr_api.validate_language_code(p_language_code => l_language_code);

327: begin
328: hr_utility.set_location('Entering:'|| l_proc, 10);
329: -- Validate language code
330: l_language_code := p_language_code;
331: hr_api.validate_language_code(p_language_code => l_language_code);
332: -- Set the effective date to the sysdate
333: l_effective_date := sysdate;
334: -- Issue a savepoint.
335: --

Line 350: when hr_api.cannot_find_prog_unit then

346: ,p_dynamic_description => p_dynamic_description
347: ,p_description_query => p_description_query
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'create_ame_action_type'
353: ,p_hook_type => 'BP'
354: );

Line 351: hr_api.cannot_find_prog_unit_error

347: ,p_description_query => p_description_query
348: );
349: exception
350: when hr_api.cannot_find_prog_unit then
351: hr_api.cannot_find_prog_unit_error
352: (p_module_name => 'create_ame_action_type'
353: ,p_hook_type => 'BP'
354: );
355: end;

Line 390: when hr_api.cannot_find_prog_unit then

386: ,p_start_date => l_aty_start_date
387: ,p_end_date => l_aty_end_date
388: );
389: exception
390: when hr_api.cannot_find_prog_unit then
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'create_ame_action_type'
393: ,p_hook_type => 'AP'
394: );

Line 391: hr_api.cannot_find_prog_unit_error

387: ,p_end_date => l_aty_end_date
388: );
389: exception
390: when hr_api.cannot_find_prog_unit then
391: hr_api.cannot_find_prog_unit_error
392: (p_module_name => 'create_ame_action_type'
393: ,p_hook_type => 'AP'
394: );
395: end;

Line 433: when hr_api.validate_enabled then

429: p_apu_end_date := l_apu_end_date;
430: --
431: hr_utility.set_location(' Leaving:'||l_proc, 50);
432: exception
433: when hr_api.validate_enabled then
434: --
435: -- As the Validate_Enabled exception has been raised
436: -- we must rollback to the savepoint
437: --

Line 513: when hr_api.cannot_find_prog_unit then

509: (p_action_type_id => p_action_type_id
510: ,p_rule_type => i
511: );
512: exception
513: when hr_api.cannot_find_prog_unit then
514: hr_api.cannot_find_prog_unit_error
515: (p_module_name => 'create_ame_action_type_usage'
516: ,p_hook_type => 'BP'
517: );

Line 514: hr_api.cannot_find_prog_unit_error

510: ,p_rule_type => i
511: );
512: exception
513: when hr_api.cannot_find_prog_unit then
514: hr_api.cannot_find_prog_unit_error
515: (p_module_name => 'create_ame_action_type_usage'
516: ,p_hook_type => 'BP'
517: );
518: end;

Line 536: when hr_api.cannot_find_prog_unit then

532: ,p_start_date => l_start_date
533: ,p_end_date => l_end_date
534: );
535: exception
536: when hr_api.cannot_find_prog_unit then
537: hr_api.cannot_find_prog_unit_error
538: (p_module_name => 'create_ame_action_type_usage'
539: ,p_hook_type => 'AP'
540: );

Line 537: hr_api.cannot_find_prog_unit_error

533: ,p_end_date => l_end_date
534: );
535: exception
536: when hr_api.cannot_find_prog_unit then
537: hr_api.cannot_find_prog_unit_error
538: (p_module_name => 'create_ame_action_type_usage'
539: ,p_hook_type => 'AP'
540: );
541: end;

Line 558: when hr_api.cannot_find_prog_unit then

554: (p_action_type_id => p_action_type_id
555: ,p_rule_type => l_rule_type
556: );
557: exception
558: when hr_api.cannot_find_prog_unit then
559: hr_api.cannot_find_prog_unit_error
560: (p_module_name => 'create_ame_action_type_usage'
561: ,p_hook_type => 'BP'
562: );

Line 559: hr_api.cannot_find_prog_unit_error

555: ,p_rule_type => l_rule_type
556: );
557: exception
558: when hr_api.cannot_find_prog_unit then
559: hr_api.cannot_find_prog_unit_error
560: (p_module_name => 'create_ame_action_type_usage'
561: ,p_hook_type => 'BP'
562: );
563: end;

Line 584: when hr_api.cannot_find_prog_unit then

580: ,p_start_date => l_start_date
581: ,p_end_date => l_end_date
582: );
583: exception
584: when hr_api.cannot_find_prog_unit then
585: hr_api.cannot_find_prog_unit_error
586: (p_module_name => 'create_ame_action_type_usage'
587: ,p_hook_type => 'AP'
588: );

Line 585: hr_api.cannot_find_prog_unit_error

581: ,p_end_date => l_end_date
582: );
583: exception
584: when hr_api.cannot_find_prog_unit then
585: hr_api.cannot_find_prog_unit_error
586: (p_module_name => 'create_ame_action_type_usage'
587: ,p_hook_type => 'AP'
588: );
589: end;

Line 594: raise hr_api.validate_enabled;

590: -- end if;
591: -- When in validation only mode raise the Validate_Enabled exception
592: --
593: if p_validate then
594: raise hr_api.validate_enabled;
595: end if;
596: --
597: p_object_version_number := l_object_version_number;
598: p_start_date := l_start_date;

Line 603: when hr_api.validate_enabled then

599: p_end_date := l_end_date;
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 50);
602: exception
603: when hr_api.validate_enabled then
604: --
605: -- As the Validate_Enabled exception has been raised
606: -- we must rollback to the savepoint
607: --

Line 668: when hr_api.cannot_find_prog_unit then

664: (p_approver_type_id => p_approver_type_id
665: ,p_action_type_id => p_action_type_id
666: );
667: exception
668: when hr_api.cannot_find_prog_unit then
669: hr_api.cannot_find_prog_unit_error
670: (p_module_name => 'create_ame_appr_type_usage'
671: ,p_hook_type => 'BP'
672: );

Line 669: hr_api.cannot_find_prog_unit_error

665: ,p_action_type_id => p_action_type_id
666: );
667: exception
668: when hr_api.cannot_find_prog_unit then
669: hr_api.cannot_find_prog_unit_error
670: (p_module_name => 'create_ame_appr_type_usage'
671: ,p_hook_type => 'BP'
672: );
673: end;

Line 694: when hr_api.cannot_find_prog_unit then

690: ,p_start_date => l_start_date
691: ,p_end_date => l_end_date
692: );
693: exception
694: when hr_api.cannot_find_prog_unit then
695: hr_api.cannot_find_prog_unit_error
696: (p_module_name => 'create_ame_appr_type_usage'
697: ,p_hook_type => 'AP'
698: );

Line 695: hr_api.cannot_find_prog_unit_error

691: ,p_end_date => l_end_date
692: );
693: exception
694: when hr_api.cannot_find_prog_unit then
695: hr_api.cannot_find_prog_unit_error
696: (p_module_name => 'create_ame_appr_type_usage'
697: ,p_hook_type => 'AP'
698: );
699: end;

Line 704: raise hr_api.validate_enabled;

700: -- When in validation only mode raise the Validate_Enabled exception
701: hr_utility.set_location(l_proc, 9);
702: --
703: if p_validate then
704: raise hr_api.validate_enabled;
705: end if;
706: --
707: p_object_version_number := l_object_version_number;
708: p_start_date := l_start_date;

Line 713: when hr_api.validate_enabled then

709: p_end_date := l_end_date;
710: --
711: hr_utility.set_location(' Leaving:'||l_proc, 50);
712: exception
713: when hr_api.validate_enabled then
714: --
715: -- As the Validate_Enabled exception has been raised
716: -- we must rollback to the savepoint
717: --

Line 791: when hr_api.cannot_find_prog_unit then

787: ,p_chain_ordering_mode => p_chain_ordering_mode
788: ,p_order_number => p_order_number
789: );
790: exception
791: when hr_api.cannot_find_prog_unit then
792: hr_api.cannot_find_prog_unit_error
793: (p_module_name => 'create_ame_action_type_conf'
794: ,p_hook_type => 'BP'
795: );

Line 792: hr_api.cannot_find_prog_unit_error

788: ,p_order_number => p_order_number
789: );
790: exception
791: when hr_api.cannot_find_prog_unit then
792: hr_api.cannot_find_prog_unit_error
793: (p_module_name => 'create_ame_action_type_conf'
794: ,p_hook_type => 'BP'
795: );
796: end;

Line 819: when hr_api.cannot_find_prog_unit then

815: ,p_start_date => l_start_date
816: ,p_end_date => l_end_date
817: );
818: exception
819: when hr_api.cannot_find_prog_unit then
820: hr_api.cannot_find_prog_unit_error
821: (p_module_name => 'create_ame_action_type_conf'
822: ,p_hook_type => 'AP'
823: );

Line 820: hr_api.cannot_find_prog_unit_error

816: ,p_end_date => l_end_date
817: );
818: exception
819: when hr_api.cannot_find_prog_unit then
820: hr_api.cannot_find_prog_unit_error
821: (p_module_name => 'create_ame_action_type_conf'
822: ,p_hook_type => 'AP'
823: );
824: end;

Line 836: when hr_api.cannot_find_prog_unit then

832: ,p_chain_ordering_mode => p_chain_ordering_mode
833: ,p_order_number => p_order_number
834: );
835: exception
836: when hr_api.cannot_find_prog_unit then
837: hr_api.cannot_find_prog_unit_error
838: (p_module_name => 'create_ame_action_type_conf'
839: ,p_hook_type => 'BP'
840: );

Line 837: hr_api.cannot_find_prog_unit_error

833: ,p_order_number => p_order_number
834: );
835: exception
836: when hr_api.cannot_find_prog_unit then
837: hr_api.cannot_find_prog_unit_error
838: (p_module_name => 'create_ame_action_type_conf'
839: ,p_hook_type => 'BP'
840: );
841: end;

Line 867: when hr_api.cannot_find_prog_unit then

863: ,p_start_date => l_start_date
864: ,p_end_date => l_end_date
865: );
866: exception
867: when hr_api.cannot_find_prog_unit then
868: hr_api.cannot_find_prog_unit_error
869: (p_module_name => 'create_ame_action_type_conf'
870: ,p_hook_type => 'AP'
871: );

Line 868: hr_api.cannot_find_prog_unit_error

864: ,p_end_date => l_end_date
865: );
866: exception
867: when hr_api.cannot_find_prog_unit then
868: hr_api.cannot_find_prog_unit_error
869: (p_module_name => 'create_ame_action_type_conf'
870: ,p_hook_type => 'AP'
871: );
872: end;

Line 877: raise hr_api.validate_enabled;

873: end if;
874: -- When in validation only mode raise the Validate_Enabled exception
875: --
876: if p_validate then
877: raise hr_api.validate_enabled;
878: end if;
879: --
880: p_object_version_number := l_object_version_number;
881: p_start_date := l_start_date;

Line 886: when hr_api.validate_enabled then

882: p_end_date := l_end_date;
883: --
884: hr_utility.set_location(' Leaving:'||l_proc, 50);
885: exception
886: when hr_api.validate_enabled then
887: --
888: -- As the Validate_Enabled exception has been raised
889: -- we must rollback to the savepoint
890: --

Line 971: when hr_api.cannot_find_prog_unit then

967: (p_attribute_id => p_attribute_id
968: ,p_action_type_id => p_action_type_id
969: );
970: exception
971: when hr_api.cannot_find_prog_unit then
972: hr_api.cannot_find_prog_unit_error
973: (p_module_name => 'create_ame_req_attribute'
974: ,p_hook_type => 'BP'
975: );

Line 972: hr_api.cannot_find_prog_unit_error

968: ,p_action_type_id => p_action_type_id
969: );
970: exception
971: when hr_api.cannot_find_prog_unit then
972: hr_api.cannot_find_prog_unit_error
973: (p_module_name => 'create_ame_req_attribute'
974: ,p_hook_type => 'BP'
975: );
976: end;

Line 1022: when hr_api.cannot_find_prog_unit then

1018: ,p_start_date => l_start_date
1019: ,p_end_date => l_end_date
1020: );
1021: exception
1022: when hr_api.cannot_find_prog_unit then
1023: hr_api.cannot_find_prog_unit_error
1024: (p_module_name => 'create_ame_req_attribute'
1025: ,p_hook_type => 'AP'
1026: );

Line 1023: hr_api.cannot_find_prog_unit_error

1019: ,p_end_date => l_end_date
1020: );
1021: exception
1022: when hr_api.cannot_find_prog_unit then
1023: hr_api.cannot_find_prog_unit_error
1024: (p_module_name => 'create_ame_req_attribute'
1025: ,p_hook_type => 'AP'
1026: );
1027: end;

Line 1031: raise hr_api.validate_enabled;

1027: end;
1028: -- When in validation only mode raise the Validate_Enabled exception
1029: --
1030: if p_validate then
1031: raise hr_api.validate_enabled;
1032: end if;
1033: --
1034: p_object_version_number := l_object_version_number;
1035: p_start_date := l_start_date;

Line 1040: when hr_api.validate_enabled then

1036: p_end_date := l_end_date;
1037: --
1038: hr_utility.set_location(' Leaving:'||l_proc, 50);
1039: exception
1040: when hr_api.validate_enabled then
1041: --
1042: -- As the Validate_Enabled exception has been raised
1043: -- we must rollback to the savepoint
1044: --

Line 1077: ,p_language_code in varchar2 default hr_api.userenv_lang

1073: -- ----------------------------------------------------------------------------
1074: --
1075: procedure create_ame_action
1076: (p_validate in boolean default false
1077: ,p_language_code in varchar2 default hr_api.userenv_lang
1078: ,p_action_type_id in number
1079: ,p_parameter in varchar2
1080: ,p_description in varchar2
1081: ,p_parameter_two in varchar2 default null

Line 1121: hr_api.validate_language_code(p_language_code => l_language_code);

1117: hr_utility.set_location('Entering:'|| l_proc, 10);
1118: --
1119: -- Validate language code
1120: l_language_code := p_language_code;
1121: hr_api.validate_language_code(p_language_code => l_language_code);
1122: -- Set the effective date to the sysdate
1123: l_effective_date := sysdate;
1124: -- Issue a savepoint.
1125: --

Line 1139: when hr_api.cannot_find_prog_unit then

1135: ,p_parameter_two => p_parameter_two
1136: ,p_description => p_description
1137: );
1138: exception
1139: when hr_api.cannot_find_prog_unit then
1140: hr_api.cannot_find_prog_unit_error
1141: (p_module_name => 'create_ame_action'
1142: ,p_hook_type => 'BP'
1143: );

Line 1140: hr_api.cannot_find_prog_unit_error

1136: ,p_description => p_description
1137: );
1138: exception
1139: when hr_api.cannot_find_prog_unit then
1140: hr_api.cannot_find_prog_unit_error
1141: (p_module_name => 'create_ame_action'
1142: ,p_hook_type => 'BP'
1143: );
1144: end;

Line 1194: when hr_api.cannot_find_prog_unit then

1190: ,p_start_date => l_start_date
1191: ,p_end_date => l_end_date
1192: );
1193: exception
1194: when hr_api.cannot_find_prog_unit then
1195: hr_api.cannot_find_prog_unit_error
1196: (p_module_name => 'create_ame_action'
1197: ,p_hook_type => 'AP'
1198: );

Line 1195: hr_api.cannot_find_prog_unit_error

1191: ,p_end_date => l_end_date
1192: );
1193: exception
1194: when hr_api.cannot_find_prog_unit then
1195: hr_api.cannot_find_prog_unit_error
1196: (p_module_name => 'create_ame_action'
1197: ,p_hook_type => 'AP'
1198: );
1199: end;

Line 1207: when hr_api.validate_enabled then

1203: p_end_date := l_end_date;
1204: --
1205: hr_utility.set_location(' Leaving:'||l_proc, 50);
1206: exception
1207: when hr_api.validate_enabled then
1208: --
1209: -- As the Validate_Enabled exception has been raised
1210: -- we must rollback to the savepoint
1211: --

Line 1246: p_language_code in varchar2 default hr_api.userenv_lang,

1242: -- ----------------------------------------------------------------------------
1243: --
1244: procedure update_ame_action_type
1245: (p_validate in boolean default false,
1246: p_language_code in varchar2 default hr_api.userenv_lang,
1247: p_action_type_id in number,
1248: p_procedure_name in varchar2 default hr_api.g_varchar2,
1249: p_description in varchar2 default hr_api.g_varchar2,
1250: p_description_query in varchar2 default hr_api.g_varchar2,

Line 1248: p_procedure_name in varchar2 default hr_api.g_varchar2,

1244: procedure update_ame_action_type
1245: (p_validate in boolean default false,
1246: p_language_code in varchar2 default hr_api.userenv_lang,
1247: p_action_type_id in number,
1248: p_procedure_name in varchar2 default hr_api.g_varchar2,
1249: p_description in varchar2 default hr_api.g_varchar2,
1250: p_description_query in varchar2 default hr_api.g_varchar2,
1251: p_object_version_number in out nocopy number,
1252: p_start_date out nocopy date,

Line 1249: p_description in varchar2 default hr_api.g_varchar2,

1245: (p_validate in boolean default false,
1246: p_language_code in varchar2 default hr_api.userenv_lang,
1247: p_action_type_id in number,
1248: p_procedure_name in varchar2 default hr_api.g_varchar2,
1249: p_description in varchar2 default hr_api.g_varchar2,
1250: p_description_query in varchar2 default hr_api.g_varchar2,
1251: p_object_version_number in out nocopy number,
1252: p_start_date out nocopy date,
1253: p_end_date out nocopy date

Line 1250: p_description_query in varchar2 default hr_api.g_varchar2,

1246: p_language_code in varchar2 default hr_api.userenv_lang,
1247: p_action_type_id in number,
1248: p_procedure_name in varchar2 default hr_api.g_varchar2,
1249: p_description in varchar2 default hr_api.g_varchar2,
1250: p_description_query in varchar2 default hr_api.g_varchar2,
1251: p_object_version_number in out nocopy number,
1252: p_start_date out nocopy date,
1253: p_end_date out nocopy date
1254: ) is

Line 1270: hr_api.validate_language_code(p_language_code => l_language_code);

1266: hr_utility.set_location('Entering:'|| l_proc, 10);
1267: --
1268: -- Validate language code
1269: l_language_code := p_language_code;
1270: hr_api.validate_language_code(p_language_code => l_language_code);
1271: -- Set the effective date to the sysdate
1272: l_effective_date := sysdate;
1273: l_object_version_number := p_object_version_number;
1274: -- Issue a savepoint.

Line 1289: when hr_api.cannot_find_prog_unit then

1285: ,p_description_query => p_description_query
1286: ,p_object_version_number => l_object_version_number
1287: );
1288: exception
1289: when hr_api.cannot_find_prog_unit then
1290: hr_api.cannot_find_prog_unit_error
1291: (p_module_name => 'update_ame_action_type'
1292: ,p_hook_type => 'BP'
1293: );

Line 1290: hr_api.cannot_find_prog_unit_error

1286: ,p_object_version_number => l_object_version_number
1287: );
1288: exception
1289: when hr_api.cannot_find_prog_unit then
1290: hr_api.cannot_find_prog_unit_error
1291: (p_module_name => 'update_ame_action_type'
1292: ,p_hook_type => 'BP'
1293: );
1294: end;

Line 1297: p_datetrack_mode => hr_api.g_update,

1293: );
1294: end;
1295: -- Update action type.
1296: ame_aty_upd.upd(p_effective_date => l_effective_date,
1297: p_datetrack_mode => hr_api.g_update,
1298: p_action_type_id => p_action_type_id,
1299: p_object_version_number => l_object_version_number,
1300: p_procedure_name => p_procedure_name,
1301: p_description => p_description,

Line 1322: when hr_api.cannot_find_prog_unit then

1318: ,p_start_date => l_start_date
1319: ,p_end_date => l_end_date
1320: );
1321: exception
1322: when hr_api.cannot_find_prog_unit then
1323: hr_api.cannot_find_prog_unit_error
1324: (p_module_name => 'update_ame_action_type'
1325: ,p_hook_type => 'AP'
1326: );

Line 1323: hr_api.cannot_find_prog_unit_error

1319: ,p_end_date => l_end_date
1320: );
1321: exception
1322: when hr_api.cannot_find_prog_unit then
1323: hr_api.cannot_find_prog_unit_error
1324: (p_module_name => 'update_ame_action_type'
1325: ,p_hook_type => 'AP'
1326: );
1327: end;

Line 1332: raise hr_api.validate_enabled;

1328: --
1329: -- When in validation only mode raise the Validate_Enabled exception
1330: --
1331: if p_validate then
1332: raise hr_api.validate_enabled;
1333: end if;
1334: --
1335: p_object_version_number := l_object_version_number;
1336: p_start_date := l_start_date;

Line 1340: when hr_api.validate_enabled then

1336: p_start_date := l_start_date;
1337: p_end_date := l_end_date;
1338: hr_utility.set_location(' Leaving:'||l_proc, 50);
1339: exception
1340: when hr_api.validate_enabled then
1341: --
1342: -- As the Validate_Enabled exception has been raised
1343: -- we must rollback to the savepoint
1344: --

Line 1379: p_voting_regime in varchar2 default hr_api.g_varchar2,

1375: procedure update_ame_action_type_conf
1376: (p_validate in boolean default false,
1377: p_action_type_id in number,
1378: p_application_id in number,
1379: p_voting_regime in varchar2 default hr_api.g_varchar2,
1380: p_chain_ordering_mode in varchar2 default hr_api.g_varchar2,
1381: p_order_number in number default hr_api.g_number,
1382: p_object_version_number in out nocopy number,
1383: p_start_date out nocopy date,

Line 1380: p_chain_ordering_mode in varchar2 default hr_api.g_varchar2,

1376: (p_validate in boolean default false,
1377: p_action_type_id in number,
1378: p_application_id in number,
1379: p_voting_regime in varchar2 default hr_api.g_varchar2,
1380: p_chain_ordering_mode in varchar2 default hr_api.g_varchar2,
1381: p_order_number in number default hr_api.g_number,
1382: p_object_version_number in out nocopy number,
1383: p_start_date out nocopy date,
1384: p_end_date out nocopy date

Line 1381: p_order_number in number default hr_api.g_number,

1377: p_action_type_id in number,
1378: p_application_id in number,
1379: p_voting_regime in varchar2 default hr_api.g_varchar2,
1380: p_chain_ordering_mode in varchar2 default hr_api.g_varchar2,
1381: p_order_number in number default hr_api.g_number,
1382: p_object_version_number in out nocopy number,
1383: p_start_date out nocopy date,
1384: p_end_date out nocopy date
1385: ) is

Line 1421: when hr_api.cannot_find_prog_unit then

1417: ,p_chain_ordering_mode => p_chain_ordering_mode
1418: ,p_object_version_number => l_object_version_number
1419: );
1420: exception
1421: when hr_api.cannot_find_prog_unit then
1422: hr_api.cannot_find_prog_unit_error
1423: (p_module_name => 'update_ame_action_type_conf'
1424: ,p_hook_type => 'BP'
1425: );

Line 1422: hr_api.cannot_find_prog_unit_error

1418: ,p_object_version_number => l_object_version_number
1419: );
1420: exception
1421: when hr_api.cannot_find_prog_unit then
1422: hr_api.cannot_find_prog_unit_error
1423: (p_module_name => 'update_ame_action_type_conf'
1424: ,p_hook_type => 'BP'
1425: );
1426: end;

Line 1430: ,p_datetrack_mode => hr_api.g_update

1426: end;
1427:
1428: -- Update action type config details
1429: ame_acf_upd.upd(p_effective_date => l_effective_date
1430: ,p_datetrack_mode => hr_api.g_update
1431: ,p_application_id => p_application_id
1432: ,p_action_type_id => p_action_type_id
1433: ,p_voting_regime => p_voting_regime
1434: ,p_order_number => p_order_number

Line 1454: when hr_api.cannot_find_prog_unit then

1450: ,p_start_date => l_start_date
1451: ,p_end_date => l_end_date
1452: );
1453: exception
1454: when hr_api.cannot_find_prog_unit then
1455: hr_api.cannot_find_prog_unit_error
1456: (p_module_name => 'update_ame_action_type_conf'
1457: ,p_hook_type => 'AP'
1458: );

Line 1455: hr_api.cannot_find_prog_unit_error

1451: ,p_end_date => l_end_date
1452: );
1453: exception
1454: when hr_api.cannot_find_prog_unit then
1455: hr_api.cannot_find_prog_unit_error
1456: (p_module_name => 'update_ame_action_type_conf'
1457: ,p_hook_type => 'AP'
1458: );
1459: end;

Line 1464: raise hr_api.validate_enabled;

1460: --
1461: -- When in validation only mode raise the Validate_Enabled exception
1462: --
1463: if p_validate then
1464: raise hr_api.validate_enabled;
1465: end if;
1466: --
1467: p_object_version_number := l_object_version_number;
1468: p_start_date := l_start_date;

Line 1472: when hr_api.validate_enabled then

1468: p_start_date := l_start_date;
1469: p_end_date := l_end_date;
1470: hr_utility.set_location(' Leaving:'||l_proc, 50);
1471: exception
1472: when hr_api.validate_enabled then
1473: --
1474: -- As the Validate_Enabled exception has been raised
1475: -- we must rollback to the savepoint
1476: --

Line 1510: p_language_code in varchar2 default hr_api.userenv_lang,

1506: -- ----------------------------------------------------------------------------
1507: --
1508: procedure update_ame_action
1509: (p_validate in boolean default false,
1510: p_language_code in varchar2 default hr_api.userenv_lang,
1511: p_action_id in number,
1512: p_action_type_id in number,
1513: p_parameter in varchar2 default hr_api.g_varchar2,
1514: p_parameter_two in varchar2 default hr_api.g_varchar2,

Line 1513: p_parameter in varchar2 default hr_api.g_varchar2,

1509: (p_validate in boolean default false,
1510: p_language_code in varchar2 default hr_api.userenv_lang,
1511: p_action_id in number,
1512: p_action_type_id in number,
1513: p_parameter in varchar2 default hr_api.g_varchar2,
1514: p_parameter_two in varchar2 default hr_api.g_varchar2,
1515: p_description in varchar2 default hr_api.g_varchar2,
1516: p_object_version_number in out nocopy number,
1517: p_start_date out nocopy date,

Line 1514: p_parameter_two in varchar2 default hr_api.g_varchar2,

1510: p_language_code in varchar2 default hr_api.userenv_lang,
1511: p_action_id in number,
1512: p_action_type_id in number,
1513: p_parameter in varchar2 default hr_api.g_varchar2,
1514: p_parameter_two in varchar2 default hr_api.g_varchar2,
1515: p_description in varchar2 default hr_api.g_varchar2,
1516: p_object_version_number in out nocopy number,
1517: p_start_date out nocopy date,
1518: p_end_date out nocopy date

Line 1515: p_description in varchar2 default hr_api.g_varchar2,

1511: p_action_id in number,
1512: p_action_type_id in number,
1513: p_parameter in varchar2 default hr_api.g_varchar2,
1514: p_parameter_two in varchar2 default hr_api.g_varchar2,
1515: p_description in varchar2 default hr_api.g_varchar2,
1516: p_object_version_number in out nocopy number,
1517: p_start_date out nocopy date,
1518: p_end_date out nocopy date
1519: ) is

Line 1559: hr_api.validate_language_code(p_language_code => l_language_code);

1555: l_effective_date := sysdate;
1556: l_object_version_number := p_object_version_number;
1557: -- Validate language code
1558: l_language_code := p_language_code;
1559: hr_api.validate_language_code(p_language_code => l_language_code);
1560: -- Issue a savepoint.
1561: --
1562: savepoint update_ame_action;
1563: --

Line 1575: when hr_api.cannot_find_prog_unit then

1571: ,p_description => p_description
1572: ,p_object_version_number => l_object_version_number
1573: );
1574: exception
1575: when hr_api.cannot_find_prog_unit then
1576: hr_api.cannot_find_prog_unit_error
1577: (p_module_name => 'update_ame_action'
1578: ,p_hook_type => 'BP'
1579: );

Line 1576: hr_api.cannot_find_prog_unit_error

1572: ,p_object_version_number => l_object_version_number
1573: );
1574: exception
1575: when hr_api.cannot_find_prog_unit then
1576: hr_api.cannot_find_prog_unit_error
1577: (p_module_name => 'update_ame_action'
1578: ,p_hook_type => 'BP'
1579: );
1580: end;

Line 1600: p_datetrack_mode => hr_api.g_update,

1596: fnd_message.set_token('APPROVER', l_approver);
1597: l_description := fnd_message.get;
1598: end if;
1599: ame_act_upd.upd(p_effective_date => l_effective_date,
1600: p_datetrack_mode => hr_api.g_update,
1601: p_action_id => p_action_id,
1602: p_action_type_id => p_action_type_id,
1603: p_object_version_number => l_object_version_number,
1604: p_parameter => p_parameter,

Line 1626: when hr_api.cannot_find_prog_unit then

1622: ,p_start_date => l_start_date
1623: ,p_end_date => l_end_date
1624: );
1625: exception
1626: when hr_api.cannot_find_prog_unit then
1627: hr_api.cannot_find_prog_unit_error
1628: (p_module_name => 'update_ame_action'
1629: ,p_hook_type => 'AP'
1630: );

Line 1627: hr_api.cannot_find_prog_unit_error

1623: ,p_end_date => l_end_date
1624: );
1625: exception
1626: when hr_api.cannot_find_prog_unit then
1627: hr_api.cannot_find_prog_unit_error
1628: (p_module_name => 'update_ame_action'
1629: ,p_hook_type => 'AP'
1630: );
1631: end;

Line 1636: raise hr_api.validate_enabled;

1632: --
1633: -- When in validation only mode raise the Validate_Enabled exception
1634: --
1635: if p_validate then
1636: raise hr_api.validate_enabled;
1637: end if;
1638: --
1639: p_object_version_number := l_object_version_number;
1640: p_start_date := l_start_date;

Line 1644: when hr_api.validate_enabled then

1640: p_start_date := l_start_date;
1641: p_end_date := l_end_date;
1642: hr_utility.set_location(' Leaving:'||l_proc, 50);
1643: exception
1644: when hr_api.validate_enabled then
1645: --
1646: -- As the Validate_Enabled exception has been raised
1647: -- we must rollback to the savepoint
1648: --

Line 1876: when hr_api.cannot_find_prog_unit then

1872: (p_action_type_id => p_action_type_id
1873: ,p_object_version_number => p_object_version_number
1874: );
1875: exception
1876: when hr_api.cannot_find_prog_unit then
1877: hr_api.cannot_find_prog_unit_error
1878: (p_module_name => 'delete_ame_action_type'
1879: ,p_hook_type => 'BP'
1880: );

Line 1877: hr_api.cannot_find_prog_unit_error

1873: ,p_object_version_number => p_object_version_number
1874: );
1875: exception
1876: when hr_api.cannot_find_prog_unit then
1877: hr_api.cannot_find_prog_unit_error
1878: (p_module_name => 'delete_ame_action_type'
1879: ,p_hook_type => 'BP'
1880: );
1881: end;

Line 1886: p_datetrack_mode => hr_api.g_delete,

1882: -- Remove action type
1883: l_effective_date2 := sysdate;
1884: ame_aty_del.del
1885: (p_action_type_id => p_action_type_id,
1886: p_datetrack_mode => hr_api.g_delete,
1887: p_object_version_number => l_aty_object_version_number,
1888: p_effective_date => l_effective_date2,
1889: p_start_date => l_aty_start_date,
1890: p_end_date => l_aty_end_date);

Line 1900: when hr_api.cannot_find_prog_unit then

1896: ,p_start_date => l_aty_start_date
1897: ,p_end_date => l_aty_end_date
1898: );
1899: exception
1900: when hr_api.cannot_find_prog_unit then
1901: hr_api.cannot_find_prog_unit_error
1902: (p_module_name => 'delete_ame_action_type'
1903: ,p_hook_type => 'AP'
1904: );

Line 1901: hr_api.cannot_find_prog_unit_error

1897: ,p_end_date => l_aty_end_date
1898: );
1899: exception
1900: when hr_api.cannot_find_prog_unit then
1901: hr_api.cannot_find_prog_unit_error
1902: (p_module_name => 'delete_ame_action_type'
1903: ,p_hook_type => 'AP'
1904: );
1905: end;

Line 1907: raise hr_api.validate_enabled;

1903: ,p_hook_type => 'AP'
1904: );
1905: end;
1906: if p_validate then
1907: raise hr_api.validate_enabled;
1908: end if;
1909: --
1910: p_object_version_number := l_aty_object_version_number;
1911: p_start_date := l_aty_start_date;

Line 1915: when hr_api.validate_enabled then

1911: p_start_date := l_aty_start_date;
1912: p_end_date := l_aty_end_date;
1913: hr_utility.set_location(' Leaving:'||l_proc, 50);
1914: exception
1915: when hr_api.validate_enabled then
1916: --
1917: -- As the Validate_Enabled exception has been raised
1918: -- we must rollback to the savepoint
1919: --

Line 1978: when hr_api.cannot_find_prog_unit then

1974: ,p_rule_type => p_rule_type
1975: ,p_object_version_number => l_object_version_number
1976: );
1977: exception
1978: when hr_api.cannot_find_prog_unit then
1979: hr_api.cannot_find_prog_unit_error
1980: (p_module_name => 'delete_ame_action_type_usage'
1981: ,p_hook_type => 'BP'
1982: );

Line 1979: hr_api.cannot_find_prog_unit_error

1975: ,p_object_version_number => l_object_version_number
1976: );
1977: exception
1978: when hr_api.cannot_find_prog_unit then
1979: hr_api.cannot_find_prog_unit_error
1980: (p_module_name => 'delete_ame_action_type_usage'
1981: ,p_hook_type => 'BP'
1982: );
1983: end;

Line 1987: p_datetrack_mode => hr_api.g_delete,

1983: end;
1984: ame_axu_del.del
1985: (p_action_type_id => p_action_type_id,
1986: p_rule_type => p_rule_type,
1987: p_datetrack_mode => hr_api.g_delete,
1988: p_object_version_number => l_object_version_number,
1989: p_effective_date => l_effective_date,
1990: p_start_date => l_start_date,
1991: p_end_date => l_end_date);

Line 2002: when hr_api.cannot_find_prog_unit then

1998: ,p_start_date => l_start_date
1999: ,p_end_date => l_end_date
2000: );
2001: exception
2002: when hr_api.cannot_find_prog_unit then
2003: hr_api.cannot_find_prog_unit_error
2004: (p_module_name => 'delete_ame_action_type_usage'
2005: ,p_hook_type => 'AP'
2006: );

Line 2003: hr_api.cannot_find_prog_unit_error

1999: ,p_end_date => l_end_date
2000: );
2001: exception
2002: when hr_api.cannot_find_prog_unit then
2003: hr_api.cannot_find_prog_unit_error
2004: (p_module_name => 'delete_ame_action_type_usage'
2005: ,p_hook_type => 'AP'
2006: );
2007: end;

Line 2009: raise hr_api.validate_enabled;

2005: ,p_hook_type => 'AP'
2006: );
2007: end;
2008: if p_validate then
2009: raise hr_api.validate_enabled;
2010: end if;
2011: --
2012: p_object_version_number := l_object_version_number;
2013: p_start_date := l_start_date;

Line 2017: when hr_api.validate_enabled then

2013: p_start_date := l_start_date;
2014: p_end_date := l_end_date;
2015: hr_utility.set_location(' Leaving:'||l_proc, 50);
2016: exception
2017: when hr_api.validate_enabled then
2018: --
2019: p_object_version_number := null;
2020: p_start_date := null;
2021: p_end_date := null;

Line 2082: when hr_api.cannot_find_prog_unit then

2078: ,p_ame_application_id => p_application_id
2079: ,p_object_version_number => l_object_version_number
2080: );
2081: exception
2082: when hr_api.cannot_find_prog_unit then
2083: hr_api.cannot_find_prog_unit_error
2084: (p_module_name => 'delete_ame_action_type_conf'
2085: ,p_hook_type => 'BP'
2086: );

Line 2083: hr_api.cannot_find_prog_unit_error

2079: ,p_object_version_number => l_object_version_number
2080: );
2081: exception
2082: when hr_api.cannot_find_prog_unit then
2083: hr_api.cannot_find_prog_unit_error
2084: (p_module_name => 'delete_ame_action_type_conf'
2085: ,p_hook_type => 'BP'
2086: );
2087: end;

Line 2091: p_datetrack_mode => hr_api.g_delete,

2087: end;
2088: ame_acf_del.del
2089: (p_action_type_id => p_action_type_id,
2090: p_application_id => p_application_id,
2091: p_datetrack_mode => hr_api.g_delete,
2092: p_object_version_number => l_object_version_number,
2093: p_effective_date => l_effective_date,
2094: p_start_date => l_start_date,
2095: p_end_date => l_end_date);

Line 2106: when hr_api.cannot_find_prog_unit then

2102: ,p_start_date => l_start_date
2103: ,p_end_date => l_end_date
2104: );
2105: exception
2106: when hr_api.cannot_find_prog_unit then
2107: hr_api.cannot_find_prog_unit_error
2108: (p_module_name => 'delete_ame_action_type_conf'
2109: ,p_hook_type => 'AP'
2110: );

Line 2107: hr_api.cannot_find_prog_unit_error

2103: ,p_end_date => l_end_date
2104: );
2105: exception
2106: when hr_api.cannot_find_prog_unit then
2107: hr_api.cannot_find_prog_unit_error
2108: (p_module_name => 'delete_ame_action_type_conf'
2109: ,p_hook_type => 'AP'
2110: );
2111: end;

Line 2113: raise hr_api.validate_enabled;

2109: ,p_hook_type => 'AP'
2110: );
2111: end;
2112: if p_validate then
2113: raise hr_api.validate_enabled;
2114: end if;
2115: --
2116: p_object_version_number := l_object_version_number;
2117: p_start_date := l_start_date;

Line 2121: when hr_api.validate_enabled then

2117: p_start_date := l_start_date;
2118: p_end_date := l_end_date;
2119: hr_utility.set_location(' Leaving:'||l_proc, 50);
2120: exception
2121: when hr_api.validate_enabled then
2122: --
2123: p_object_version_number := null;
2124: p_start_date := null;
2125: p_end_date := null;

Line 2184: when hr_api.cannot_find_prog_unit then

2180: ,p_approver_type_id => p_approver_type_id
2181: ,p_object_version_number => p_object_version_number
2182: );
2183: exception
2184: when hr_api.cannot_find_prog_unit then
2185: hr_api.cannot_find_prog_unit_error
2186: (p_module_name => 'delete_ame_appr_type_usage'
2187: ,p_hook_type => 'BP'
2188: );

Line 2185: hr_api.cannot_find_prog_unit_error

2181: ,p_object_version_number => p_object_version_number
2182: );
2183: exception
2184: when hr_api.cannot_find_prog_unit then
2185: hr_api.cannot_find_prog_unit_error
2186: (p_module_name => 'delete_ame_appr_type_usage'
2187: ,p_hook_type => 'BP'
2188: );
2189: end;

Line 2195: p_datetrack_mode => hr_api.g_delete,

2191: --
2192: ame_apu_del.del
2193: (p_action_type_id => p_action_type_id,
2194: p_approver_type_id => p_approver_type_id,
2195: p_datetrack_mode => hr_api.g_delete,
2196: p_object_version_number => l_object_version_number,
2197: p_effective_date => l_effective_date,
2198: p_start_date => l_start_date,
2199: p_end_date => l_end_date);

Line 2210: when hr_api.cannot_find_prog_unit then

2206: ,p_start_date => l_start_date
2207: ,p_end_date => l_end_date
2208: );
2209: exception
2210: when hr_api.cannot_find_prog_unit then
2211: hr_api.cannot_find_prog_unit_error
2212: (p_module_name => 'delete_ame_appr_type_usage'
2213: ,p_hook_type => 'AP'
2214: );

Line 2211: hr_api.cannot_find_prog_unit_error

2207: ,p_end_date => l_end_date
2208: );
2209: exception
2210: when hr_api.cannot_find_prog_unit then
2211: hr_api.cannot_find_prog_unit_error
2212: (p_module_name => 'delete_ame_appr_type_usage'
2213: ,p_hook_type => 'AP'
2214: );
2215: end;

Line 2217: raise hr_api.validate_enabled;

2213: ,p_hook_type => 'AP'
2214: );
2215: end;
2216: if p_validate then
2217: raise hr_api.validate_enabled;
2218: end if;
2219: --
2220: p_object_version_number := l_object_version_number;
2221: p_start_date := l_start_date;

Line 2225: when hr_api.validate_enabled then

2221: p_start_date := l_start_date;
2222: p_end_date := l_end_date;
2223: hr_utility.set_location(' Leaving:'||l_proc, 50);
2224: exception
2225: when hr_api.validate_enabled then
2226: --
2227: p_object_version_number := null;
2228: p_start_date := null;
2229: p_end_date := null;

Line 2288: when hr_api.cannot_find_prog_unit then

2284: ,p_attribute_id => p_attribute_id
2285: ,p_object_version_number => p_object_version_number
2286: );
2287: exception
2288: when hr_api.cannot_find_prog_unit then
2289: hr_api.cannot_find_prog_unit_error
2290: (p_module_name => 'delete_ame_req_attribute'
2291: ,p_hook_type => 'BP'
2292: );

Line 2289: hr_api.cannot_find_prog_unit_error

2285: ,p_object_version_number => p_object_version_number
2286: );
2287: exception
2288: when hr_api.cannot_find_prog_unit then
2289: hr_api.cannot_find_prog_unit_error
2290: (p_module_name => 'delete_ame_req_attribute'
2291: ,p_hook_type => 'BP'
2292: );
2293: end;

Line 2299: p_datetrack_mode => hr_api.g_delete,

2295: -- Process Logic
2296: ame_man_del.del
2297: (p_action_type_id => p_action_type_id,
2298: p_attribute_id => p_attribute_id,
2299: p_datetrack_mode => hr_api.g_delete,
2300: p_object_version_number => l_object_version_number,
2301: p_effective_date => l_effective_date,
2302: p_start_date => l_start_date,
2303: p_end_date => l_end_date);

Line 2314: when hr_api.cannot_find_prog_unit then

2310: ,p_start_date => l_start_date
2311: ,p_end_date => l_end_date
2312: );
2313: exception
2314: when hr_api.cannot_find_prog_unit then
2315: hr_api.cannot_find_prog_unit_error
2316: (p_module_name => 'delete_ame_req_attribute'
2317: ,p_hook_type => 'AP'
2318: );

Line 2315: hr_api.cannot_find_prog_unit_error

2311: ,p_end_date => l_end_date
2312: );
2313: exception
2314: when hr_api.cannot_find_prog_unit then
2315: hr_api.cannot_find_prog_unit_error
2316: (p_module_name => 'delete_ame_req_attribute'
2317: ,p_hook_type => 'AP'
2318: );
2319: end;

Line 2322: raise hr_api.validate_enabled;

2318: );
2319: end;
2320: --
2321: if p_validate then
2322: raise hr_api.validate_enabled;
2323: end if;
2324: --
2325: p_object_version_number := l_object_version_number;
2326: p_start_date := l_start_date;

Line 2330: when hr_api.validate_enabled then

2326: p_start_date := l_start_date;
2327: p_end_date := l_end_date;
2328: hr_utility.set_location(' Leaving:'||l_proc, 50);
2329: exception
2330: when hr_api.validate_enabled then
2331: --
2332: p_object_version_number := null;
2333: p_start_date := null;
2334: p_end_date := null;

Line 2393: when hr_api.cannot_find_prog_unit then

2389: (p_action_id => p_action_id
2390: ,p_object_version_number => p_object_version_number
2391: );
2392: exception
2393: when hr_api.cannot_find_prog_unit then
2394: hr_api.cannot_find_prog_unit_error
2395: (p_module_name => 'delete_ame_action'
2396: ,p_hook_type => 'BP'
2397: );

Line 2394: hr_api.cannot_find_prog_unit_error

2390: ,p_object_version_number => p_object_version_number
2391: );
2392: exception
2393: when hr_api.cannot_find_prog_unit then
2394: hr_api.cannot_find_prog_unit_error
2395: (p_module_name => 'delete_ame_action'
2396: ,p_hook_type => 'BP'
2397: );
2398: end;

Line 2404: p_datetrack_mode => hr_api.g_delete,

2400: -- Process Logic
2401: ame_act_del.del
2402: (p_action_id => p_action_id,
2403: p_action_type_id => p_action_type_id,
2404: p_datetrack_mode => hr_api.g_delete,
2405: p_object_version_number => l_object_version_number,
2406: p_effective_date => l_effective_date,
2407: p_start_date => l_start_date,
2408: p_end_date => l_end_date);

Line 2418: when hr_api.cannot_find_prog_unit then

2414: ,p_start_date => l_start_date
2415: ,p_end_date => l_end_date
2416: );
2417: exception
2418: when hr_api.cannot_find_prog_unit then
2419: hr_api.cannot_find_prog_unit_error
2420: (p_module_name => 'delete_ame_action'
2421: ,p_hook_type => 'AP'
2422: );

Line 2419: hr_api.cannot_find_prog_unit_error

2415: ,p_end_date => l_end_date
2416: );
2417: exception
2418: when hr_api.cannot_find_prog_unit then
2419: hr_api.cannot_find_prog_unit_error
2420: (p_module_name => 'delete_ame_action'
2421: ,p_hook_type => 'AP'
2422: );
2423: end;

Line 2425: raise hr_api.validate_enabled;

2421: ,p_hook_type => 'AP'
2422: );
2423: end;
2424: if p_validate then
2425: raise hr_api.validate_enabled;
2426: end if;
2427: --
2428: p_object_version_number := l_object_version_number;
2429: p_start_date := l_start_date;

Line 2433: when hr_api.validate_enabled then

2429: p_start_date := l_start_date;
2430: p_end_date := l_end_date;
2431: hr_utility.set_location(' Leaving:'||l_proc, 50);
2432: exception
2433: when hr_api.validate_enabled then
2434: --
2435: p_object_version_number := null;
2436: p_start_date := null;
2437: p_end_date := null;