DBA Data[Home] [Help]

APPS.HR_MAINTAIN_PROPOSAL_SWI dependencies on HR_UTILITY

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

30: --
31: -- Other variables
32: l_proc varchar2(72) := g_package ||'approve_salary_proposal';
33: Begin
34: hr_utility.set_location(' Entering:' || l_proc,10);
35: --
36: -- Issue a savepoint
37: --
38: savepoint approve_salary_proposal_swi;

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

80: -- messages of any type exist in the Multiple Message List.
81: -- Also disable Multiple Message Detection.
82: --
83: p_return_status := hr_multi_message.get_return_status_disable;
84: hr_utility.set_location(' Leaving:' || l_proc,20);
85: --
86: exception
87: when hr_multi_message.error_message_exist then
88: --

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

96: --
97: p_object_version_number := l_object_version_number;
98: p_error_text := null;
99: p_return_status := hr_multi_message.get_return_status_disable;
100: hr_utility.set_location(' Leaving:' || l_proc, 30);
101: when others then
102: --
103: -- When Multiple Message Detection is enabled catch
104: -- any Application specific or other unexpected

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

107: -- error.
108: --
109: rollback to approve_salary_proposal_swi;
110: if hr_multi_message.unexpected_error_add(l_proc) then
111: hr_utility.set_location(' Leaving:' || l_proc,40);
112: raise;
113: end if;
114: --
115: -- Reset IN OUT and set OUT parameters

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

116: --
117: p_object_version_number := l_object_version_number;
118: p_error_text := null;
119: p_return_status := hr_multi_message.get_return_status_disable;
120: hr_utility.set_location(' Leaving:' || l_proc,50);
121: end approve_salary_proposal;
122: -- ----------------------------------------------------------------------------
123: -- |----------------------< cre_or_upd_salary_proposal >----------------------|
124: -- ----------------------------------------------------------------------------

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

175: --
176: -- Other variables
177: l_proc varchar2(72) := g_package ||'cre_or_upd_salary_proposal';
178: Begin
179: hr_utility.set_location(' Entering:' || l_proc,10);
180: --
181: -- Issue a savepoint
182: --
183: savepoint cre_or_upd_salary_proposal_swi;

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

256: -- messages of any type exist in the Multiple Message List.
257: -- Also disable Multiple Message Detection.
258: --
259: p_return_status := hr_multi_message.get_return_status_disable;
260: hr_utility.set_location(' Leaving:' || l_proc,20);
261: --
262: exception
263: when hr_multi_message.error_message_exist then
264: --

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

272: --
273: p_pay_proposal_id := l_pay_proposal_id;
274: p_object_version_number := l_object_version_number;
275: p_return_status := hr_multi_message.get_return_status_disable;
276: hr_utility.set_location(' Leaving:' || l_proc, 30);
277: when others then
278: --
279: -- When Multiple Message Detection is enabled catch
280: -- any Application specific or other unexpected

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

283: -- error.
284: --
285: rollback to cre_or_upd_salary_proposal_swi;
286: if hr_multi_message.unexpected_error_add(l_proc) then
287: hr_utility.set_location(' Leaving:' || l_proc,40);
288: raise;
289: end if;
290: --
291: -- Reset IN OUT and set OUT parameters

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

292: --
293: p_pay_proposal_id := l_pay_proposal_id;
294: p_object_version_number := l_object_version_number;
295: p_return_status := hr_multi_message.get_return_status_disable;
296: hr_utility.set_location(' Leaving:' || l_proc,50);
297: end cre_or_upd_salary_proposal;
298: -- ----------------------------------------------------------------------------
299: -- |-----------------------< delete_proposal_component >----------------------|
300: -- ----------------------------------------------------------------------------

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

313: --
314: -- Other variables
315: l_proc varchar2(72) := g_package ||'delete_proposal_component';
316: Begin
317: hr_utility.set_location(' Entering:' || l_proc,10);
318: --
319: -- Issue a savepoint
320: --
321: savepoint delete_proposal_component_swi;

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

356: -- messages of any type exist in the Multiple Message List.
357: -- Also disable Multiple Message Detection.
358: --
359: p_return_status := hr_multi_message.get_return_status_disable;
360: hr_utility.set_location(' Leaving:' || l_proc,20);
361: --
362: exception
363: when hr_multi_message.error_message_exist then
364: --

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

370: --
371: -- Reset IN OUT parameters and set OUT parameters
372: --
373: p_return_status := hr_multi_message.get_return_status_disable;
374: hr_utility.set_location(' Leaving:' || l_proc, 30);
375: when others then
376: --
377: -- When Multiple Message Detection is enabled catch
378: -- any Application specific or other unexpected

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

381: -- error.
382: --
383: rollback to delete_proposal_component_swi;
384: if hr_multi_message.unexpected_error_add(l_proc) then
385: hr_utility.set_location(' Leaving:' || l_proc,40);
386: raise;
387: end if;
388: --
389: -- Reset IN OUT and set OUT parameters

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

388: --
389: -- Reset IN OUT and set OUT parameters
390: --
391: p_return_status := hr_multi_message.get_return_status_disable;
392: hr_utility.set_location(' Leaving:' || l_proc,50);
393: end delete_proposal_component;
394: -- ----------------------------------------------------------------------------
395: -- |------------------------< delete_salary_proposal >------------------------|
396: -- ----------------------------------------------------------------------------

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

410: --
411: -- Other variables
412: l_proc varchar2(72) := g_package ||'delete_salary_proposal';
413: Begin
414: hr_utility.set_location(' Entering:' || l_proc,10);
415: --
416: -- Issue a savepoint
417: --
418: savepoint delete_salary_proposal_swi;

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

454: -- messages of any type exist in the Multiple Message List.
455: -- Also disable Multiple Message Detection.
456: --
457: p_return_status := hr_multi_message.get_return_status_disable;
458: hr_utility.set_location(' Leaving:' || l_proc,20);
459: --
460: exception
461: when hr_multi_message.error_message_exist then
462: --

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

468: --
469: -- Reset IN OUT parameters and set OUT parameters
470: --
471: p_return_status := hr_multi_message.get_return_status_disable;
472: hr_utility.set_location(' Leaving:' || l_proc, 30);
473: when others then
474: --
475: -- When Multiple Message Detection is enabled catch
476: -- any Application specific or other unexpected

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

479: -- error.
480: --
481: rollback to delete_salary_proposal_swi;
482: if hr_multi_message.unexpected_error_add(l_proc) then
483: hr_utility.set_location(' Leaving:' || l_proc,40);
484: raise;
485: end if;
486: --
487: -- Reset IN OUT and set OUT parameters

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

486: --
487: -- Reset IN OUT and set OUT parameters
488: --
489: p_return_status := hr_multi_message.get_return_status_disable;
490: hr_utility.set_location(' Leaving:' || l_proc,50);
491: end delete_salary_proposal;
492: -- ----------------------------------------------------------------------------
493: -- |-----------------------< insert_proposal_component >----------------------|
494: -- ----------------------------------------------------------------------------

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

535: --
536: -- Other variables
537: l_proc varchar2(72) := g_package ||'insert_proposal_component';
538: Begin
539: hr_utility.set_location(' Entering:' || l_proc,10);
540: --
541: -- Issue a savepoint
542: --
543: savepoint insert_proposal_component_swi;

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

606: -- messages of any type exist in the Multiple Message List.
607: -- Also disable Multiple Message Detection.
608: --
609: p_return_status := hr_multi_message.get_return_status_disable;
610: hr_utility.set_location(' Leaving:' || l_proc,20);
611: --
612: exception
613: when hr_multi_message.error_message_exist then
614: --

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

622: --
623: p_component_id := null;
624: p_object_version_number := null;
625: p_return_status := hr_multi_message.get_return_status_disable;
626: hr_utility.set_location(' Leaving:' || l_proc, 30);
627: when others then
628: --
629: -- When Multiple Message Detection is enabled catch
630: -- any Application specific or other unexpected

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

633: -- error.
634: --
635: rollback to insert_proposal_component_swi;
636: if hr_multi_message.unexpected_error_add(l_proc) then
637: hr_utility.set_location(' Leaving:' || l_proc,40);
638: raise;
639: end if;
640: --
641: -- Reset IN OUT and set OUT parameters

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

642: --
643: p_component_id := null;
644: p_object_version_number := null;
645: p_return_status := hr_multi_message.get_return_status_disable;
646: hr_utility.set_location(' Leaving:' || l_proc,50);
647: end insert_proposal_component;
648: -- ----------------------------------------------------------------------------
649: -- |------------------------< insert_salary_proposal >------------------------|
650: -- ----------------------------------------------------------------------------

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

702: --
703: -- Other variables
704: l_proc varchar2(72) := g_package ||'insert_salary_proposal';
705: Begin
706: hr_utility.set_location(' Entering:' || l_proc,10);
707: --setting the global variable to Y as the proposed
708: --proposals have already been deleted through OA.
709: --schowdhu -04-Dec-2008
710:

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

793: -- messages of any type exist in the Multiple Message List.
794: -- Also disable Multiple Message Detection.
795: --
796: p_return_status := hr_multi_message.get_return_status_disable;
797: hr_utility.set_location(' Leaving:' || l_proc,20);
798: --
799: exception
800: when hr_multi_message.error_message_exist then
801: --

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

810: -- p_pay_proposal_id := null;
811: p_object_version_number := null;
812: p_element_entry_id := l_element_entry_id;
813: p_return_status := hr_multi_message.get_return_status_disable;
814: hr_utility.set_location(' Leaving:' || l_proc, 30);
815: when others then
816: --
817: -- When Multiple Message Detection is enabled catch
818: -- any Application specific or other unexpected

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

821: -- error.
822: --
823: rollback to insert_salary_proposal_swi;
824: if hr_multi_message.unexpected_error_add(l_proc) then
825: hr_utility.set_location(' Leaving:' || l_proc,40);
826: raise;
827: end if;
828: --
829: -- Reset IN OUT and set OUT parameters

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

831: -- p_pay_proposal_id := null;
832: p_object_version_number := null;
833: p_element_entry_id := l_element_entry_id;
834: p_return_status := hr_multi_message.get_return_status_disable;
835: hr_utility.set_location(' Leaving:' || l_proc,50);
836: end insert_salary_proposal;
837: -- ----------------------------------------------------------------------------
838: -- |-----------------------< update_proposal_component >----------------------|
839: -- ----------------------------------------------------------------------------

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

879: --
880: -- Other variables
881: l_proc varchar2(72) := g_package ||'update_proposal_component';
882: Begin
883: hr_utility.set_location(' Entering:' || l_proc,10);
884: --
885: -- Issue a savepoint
886: --
887: savepoint update_proposal_component_swi;

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

949: -- messages of any type exist in the Multiple Message List.
950: -- Also disable Multiple Message Detection.
951: --
952: p_return_status := hr_multi_message.get_return_status_disable;
953: hr_utility.set_location(' Leaving:' || l_proc,20);
954: --
955: exception
956: when hr_multi_message.error_message_exist then
957: --

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

964: -- Reset IN OUT parameters and set OUT parameters
965: --
966: p_object_version_number := l_object_version_number;
967: p_return_status := hr_multi_message.get_return_status_disable;
968: hr_utility.set_location(' Leaving:' || l_proc, 30);
969: when others then
970: --
971: -- When Multiple Message Detection is enabled catch
972: -- any Application specific or other unexpected

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

975: -- error.
976: --
977: rollback to update_proposal_component_swi;
978: if hr_multi_message.unexpected_error_add(l_proc) then
979: hr_utility.set_location(' Leaving:' || l_proc,40);
980: raise;
981: end if;
982: --
983: -- Reset IN OUT and set OUT parameters

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

983: -- Reset IN OUT and set OUT parameters
984: --
985: p_object_version_number := l_object_version_number;
986: p_return_status := hr_multi_message.get_return_status_disable;
987: hr_utility.set_location(' Leaving:' || l_proc,50);
988: end update_proposal_component;
989: -- ----------------------------------------------------------------------------
990: -- |------------------------< update_salary_proposal >------------------------|
991: -- ----------------------------------------------------------------------------

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

1039: --
1040: -- Other variables
1041: l_proc varchar2(72) := g_package ||'update_salary_proposal';
1042: Begin
1043: hr_utility.set_location(' Entering:' || l_proc,10);
1044:
1045: --setting the global variable to Y as the proposed
1046: --proposals have already been deleted through OA.
1047: --schowdhu -04-Dec-2008

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

1124: -- messages of any type exist in the Multiple Message List.
1125: -- Also disable Multiple Message Detection.
1126: --
1127: p_return_status := hr_multi_message.get_return_status_disable;
1128: hr_utility.set_location(' Leaving:' || l_proc,20);
1129: --
1130: exception
1131: when hr_multi_message.error_message_exist then
1132: --

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

1139: -- Reset IN OUT parameters and set OUT parameters
1140: --
1141: p_object_version_number := l_object_version_number;
1142: p_return_status := hr_multi_message.get_return_status_disable;
1143: hr_utility.set_location(' Leaving:' || l_proc, 30);
1144: when others then
1145: --
1146: -- When Multiple Message Detection is enabled catch
1147: -- any Application specific or other unexpected

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

1150: -- error.
1151: --
1152: rollback to update_salary_proposal_swi;
1153: if hr_multi_message.unexpected_error_add(l_proc) then
1154: hr_utility.set_location(' Leaving:' || l_proc,40);
1155: raise;
1156: end if;
1157: --
1158: -- Reset IN OUT and set OUT parameters

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

1158: -- Reset IN OUT and set OUT parameters
1159: --
1160: p_object_version_number := l_object_version_number;
1161: p_return_status := hr_multi_message.get_return_status_disable;
1162: hr_utility.set_location(' Leaving:' || l_proc,50);
1163: end update_salary_proposal;
1164:
1165: -- ----------------------------------------------------------------------------
1166: -- |----------------------------< process_api >-------------------------------|

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

1187: --
1188:
1189: BEGIN
1190:
1191: hr_utility.set_location(' Entering:' || l_proc,10);
1192: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1193:
1194: l_parser := xmlparser.newParser;
1195: xmlparser.ParseCLOB(l_parser,p_document);

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

1188:
1189: BEGIN
1190:
1191: hr_utility.set_location(' Entering:' || l_proc,10);
1192: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
1193:
1194: l_parser := xmlparser.newParser;
1195: xmlparser.ParseCLOB(l_parser,p_document);
1196: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

1194: l_parser := xmlparser.newParser;
1195: xmlparser.ParseCLOB(l_parser,p_document);
1196: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
1197:
1198: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1199:
1200: l_commitElement := xmldom.makeElement(l_CommitNode);
1201: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1202:

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

1258: );
1259: --
1260: end if;
1261: p_return_status := l_return_status;
1262: hr_utility.set_location('Exiting:' || l_proc,40);
1263:
1264: end process_api;
1265:
1266: end hr_maintain_proposal_swi;