DBA Data[Home] [Help]

APPS.BEN_ELIG_PER_ELC_CHC_SWI dependencies on HR_UTILITY

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

122: --
123: -- Other variables
124: l_proc varchar2(72) := g_package ||'create_elig_per_elc_chc';
125: Begin
126: hr_utility.set_location(' Entering:' || l_proc,10);
127: --
128: -- Issue a savepoint
129: --
130: savepoint create_elig_per_elc_chc_swi;

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

264: -- messages of any type exist in the Multiple Message List.
265: -- Also disable Multiple Message Detection.
266: --
267: p_return_status := hr_multi_message.get_return_status_disable;
268: hr_utility.set_location(' Leaving:' || l_proc,20);
269: --
270: exception
271: when hr_multi_message.error_message_exist then
272: --

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

280: --
281: p_elig_per_elctbl_chc_id := null;
282: p_object_version_number := null;
283: p_return_status := hr_multi_message.get_return_status_disable;
284: hr_utility.set_location(' Leaving:' || l_proc, 30);
285: when others then
286: --
287: -- When Multiple Message Detection is enabled catch
288: -- any Application specific or other unexpected

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

291: -- error.
292: --
293: rollback to create_elig_per_elc_chc_swi;
294: if hr_multi_message.unexpected_error_add(l_proc) then
295: hr_utility.set_location(' Leaving:' || l_proc,40);
296: raise;
297: end if;
298: --
299: -- Reset IN OUT and set OUT parameters

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

300: --
301: p_elig_per_elctbl_chc_id := null;
302: p_object_version_number := null;
303: p_return_status := hr_multi_message.get_return_status_disable;
304: hr_utility.set_location(' Leaving:' || l_proc,50);
305: end create_elig_per_elc_chc;
306: -- ----------------------------------------------------------------------------
307: -- |---------------------< create_perf_elig_per_elc_chc >---------------------|
308: -- ----------------------------------------------------------------------------

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

421: --
422: -- Other variables
423: l_proc varchar2(72) := g_package ||'create_perf_elig_per_elc_chc';
424: Begin
425: hr_utility.set_location(' Entering:' || l_proc,10);
426: --
427: -- Issue a savepoint
428: --
429: savepoint crt_perf_elig_per_elc_chc_swi;

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

564: -- messages of any type exist in the Multiple Message List.
565: -- Also disable Multiple Message Detection.
566: --
567: p_return_status := hr_multi_message.get_return_status_disable;
568: hr_utility.set_location(' Leaving:' || l_proc,20);
569: --
570: exception
571: when hr_multi_message.error_message_exist then
572: --

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

580: --
581: p_elig_per_elctbl_chc_id := null;
582: p_object_version_number := null;
583: p_return_status := hr_multi_message.get_return_status_disable;
584: hr_utility.set_location(' Leaving:' || l_proc, 30);
585: when others then
586: --
587: -- When Multiple Message Detection is enabled catch
588: -- any Application specific or other unexpected

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

591: -- error.
592: --
593: rollback to crt_perf_elig_per_elc_chc_swi;
594: if hr_multi_message.unexpected_error_add(l_proc) then
595: hr_utility.set_location(' Leaving:' || l_proc,40);
596: raise;
597: end if;
598: --
599: -- Reset IN OUT and set OUT parameters

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

600: --
601: p_elig_per_elctbl_chc_id := null;
602: p_object_version_number := null;
603: p_return_status := hr_multi_message.get_return_status_disable;
604: hr_utility.set_location(' Leaving:' || l_proc,50);
605: end create_perf_elig_per_elc_chc;
606: -- ----------------------------------------------------------------------------
607: -- |------------------------< delete_elig_per_elc_chc >-----------------------|
608: -- ----------------------------------------------------------------------------

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

622: --
623: -- Other variables
624: l_proc varchar2(72) := g_package ||'delete_elig_per_elc_chc';
625: Begin
626: hr_utility.set_location(' Entering:' || l_proc,10);
627: --
628: -- Issue a savepoint
629: --
630: savepoint delete_elig_per_elc_chc_swi;

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

666: -- messages of any type exist in the Multiple Message List.
667: -- Also disable Multiple Message Detection.
668: --
669: p_return_status := hr_multi_message.get_return_status_disable;
670: hr_utility.set_location(' Leaving:' || l_proc,20);
671: --
672: exception
673: when hr_multi_message.error_message_exist then
674: --

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

681: -- Reset IN OUT parameters and set OUT parameters
682: --
683: p_object_version_number := l_object_version_number;
684: p_return_status := hr_multi_message.get_return_status_disable;
685: hr_utility.set_location(' Leaving:' || l_proc, 30);
686: when others then
687: --
688: -- When Multiple Message Detection is enabled catch
689: -- any Application specific or other unexpected

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

692: -- error.
693: --
694: rollback to delete_elig_per_elc_chc_swi;
695: if hr_multi_message.unexpected_error_add(l_proc) then
696: hr_utility.set_location(' Leaving:' || l_proc,40);
697: raise;
698: end if;
699: --
700: -- Reset IN OUT and set OUT parameters

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

700: -- Reset IN OUT and set OUT parameters
701: --
702: p_object_version_number := l_object_version_number;
703: p_return_status := hr_multi_message.get_return_status_disable;
704: hr_utility.set_location(' Leaving:' || l_proc,50);
705: end delete_elig_per_elc_chc;
706: -- ----------------------------------------------------------------------------
707: -- |----------------------------------< lck >---------------------------------|
708: -- ----------------------------------------------------------------------------

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

718: --
719: -- Other variables
720: l_proc varchar2(72) := g_package ||'lck';
721: Begin
722: hr_utility.set_location(' Entering:' || l_proc,10);
723: --
724: -- Issue a savepoint
725: --
726: savepoint lck_swi;

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

756: -- messages of any type exist in the Multiple Message List.
757: -- Also disable Multiple Message Detection.
758: --
759: p_return_status := hr_multi_message.get_return_status_disable;
760: hr_utility.set_location(' Leaving:' || l_proc,20);
761: --
762: exception
763: when hr_multi_message.error_message_exist then
764: --

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

770: --
771: -- Reset IN OUT parameters and set OUT parameters
772: --
773: p_return_status := hr_multi_message.get_return_status_disable;
774: hr_utility.set_location(' Leaving:' || l_proc, 30);
775: when others then
776: --
777: -- When Multiple Message Detection is enabled catch
778: -- any Application specific or other unexpected

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

781: -- error.
782: --
783: rollback to lck_swi;
784: if hr_multi_message.unexpected_error_add(l_proc) then
785: hr_utility.set_location(' Leaving:' || l_proc,40);
786: raise;
787: end if;
788: --
789: -- Reset IN OUT and set OUT parameters

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

788: --
789: -- Reset IN OUT and set OUT parameters
790: --
791: p_return_status := hr_multi_message.get_return_status_disable;
792: hr_utility.set_location(' Leaving:' || l_proc,50);
793: end lck;
794: -- ----------------------------------------------------------------------------
795: -- |------------------------< update_elig_per_elc_chc >-----------------------|
796: -- ----------------------------------------------------------------------------

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

903: --
904: -- Other variables
905: l_proc varchar2(72) := g_package ||'update_elig_per_elc_chc';
906: Begin
907: hr_utility.set_location(' Entering:' || l_proc,10);
908: --
909: -- Issue a savepoint
910: --
911: savepoint update_elig_per_elc_chc_swi;

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

1040: -- messages of any type exist in the Multiple Message List.
1041: -- Also disable Multiple Message Detection.
1042: --
1043: p_return_status := hr_multi_message.get_return_status_disable;
1044: hr_utility.set_location(' Leaving:' || l_proc,20);
1045: --
1046: exception
1047: when hr_multi_message.error_message_exist then
1048: --

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

1055: -- Reset IN OUT parameters and set OUT parameters
1056: --
1057: p_object_version_number := l_object_version_number;
1058: p_return_status := hr_multi_message.get_return_status_disable;
1059: hr_utility.set_location(' Leaving:' || l_proc, 30);
1060: when others then
1061: --
1062: -- When Multiple Message Detection is enabled catch
1063: -- any Application specific or other unexpected

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

1066: -- error.
1067: --
1068: rollback to update_elig_per_elc_chc_swi;
1069: if hr_multi_message.unexpected_error_add(l_proc) then
1070: hr_utility.set_location(' Leaving:' || l_proc,40);
1071: raise;
1072: end if;
1073: --
1074: -- Reset IN OUT and set OUT parameters

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

1074: -- Reset IN OUT and set OUT parameters
1075: --
1076: p_object_version_number := l_object_version_number;
1077: p_return_status := hr_multi_message.get_return_status_disable;
1078: hr_utility.set_location(' Leaving:' || l_proc,50);
1079: end update_elig_per_elc_chc;
1080: -- ----------------------------------------------------------------------------
1081: -- |---------------------< update_perf_elig_per_elc_chc >---------------------|
1082: -- ----------------------------------------------------------------------------

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

1185: --
1186: -- Other variables
1187: l_proc varchar2(72) := g_package ||'update_perf_elig_per_elc_chc';
1188: Begin
1189: hr_utility.set_location(' Entering:' || l_proc,10);
1190: --
1191: -- Issue a savepoint
1192: --
1193: savepoint upd_perf_elig_per_elc_chc_swi;

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

1318: -- messages of any type exist in the Multiple Message List.
1319: -- Also disable Multiple Message Detection.
1320: --
1321: p_return_status := hr_multi_message.get_return_status_disable;
1322: hr_utility.set_location(' Leaving:' || l_proc,20);
1323: --
1324: exception
1325: when hr_multi_message.error_message_exist then
1326: --

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

1333: -- Reset IN OUT parameters and set OUT parameters
1334: --
1335: p_object_version_number := l_object_version_number;
1336: p_return_status := hr_multi_message.get_return_status_disable;
1337: hr_utility.set_location(' Leaving:' || l_proc, 30);
1338: when others then
1339: --
1340: -- When Multiple Message Detection is enabled catch
1341: -- any Application specific or other unexpected

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

1344: -- error.
1345: --
1346: rollback to upd_perf_elig_per_elc_chc_swi;
1347: if hr_multi_message.unexpected_error_add(l_proc) then
1348: hr_utility.set_location(' Leaving:' || l_proc,40);
1349: raise;
1350: end if;
1351: --
1352: -- Reset IN OUT and set OUT parameters

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

1352: -- Reset IN OUT and set OUT parameters
1353: --
1354: p_object_version_number := l_object_version_number;
1355: p_return_status := hr_multi_message.get_return_status_disable;
1356: hr_utility.set_location(' Leaving:' || l_proc,50);
1357: end update_perf_elig_per_elc_chc;
1358: -- ----------------------------------------------------------------------------
1359: -- |----------------------------< process_api >-------------------------------|
1360: -- ----------------------------------------------------------------------------

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

1377: --
1378:
1379: BEGIN
1380:
1381: hr_utility.set_location(' Entering:' || l_proc,10);
1382: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1383:
1384: l_parser := xmlparser.newParser;
1385: xmlparser.ParseCLOB(l_parser,p_document);

Line 1382: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);

1378:
1379: BEGIN
1380:
1381: hr_utility.set_location(' Entering:' || l_proc,10);
1382: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1383:
1384: l_parser := xmlparser.newParser;
1385: xmlparser.ParseCLOB(l_parser,p_document);
1386: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

Line 1388: hr_utility.set_location('Extracting the PostState:' || l_proc,20);

1384: l_parser := xmlparser.newParser;
1385: xmlparser.ParseCLOB(l_parser,p_document);
1386: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1387:
1388: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1389:
1390: l_commitElement := xmldom.makeElement(l_CommitNode);
1391: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1392:

Line 1498: hr_utility.set_location('Exiting:' || l_proc,40);

1494: --
1495: --
1496: end if;
1497: p_return_status := l_return_status;
1498: hr_utility.set_location('Exiting:' || l_proc,40);
1499:
1500: end process_api;
1501:
1502: end ben_elig_per_elc_chc_swi;