DBA Data[Home] [Help]

APPS.PER_RECRUITMENT_ACTIVITY_SWI dependencies on HR_UTILITY

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

65: -- Other variables
66: l_recruitment_activity_id number;
67: l_proc varchar2(72) := g_package ||'create_recruitment_activity';
68: Begin
69: hr_utility.set_location(' Entering:' || l_proc,10);
70: --
71: -- Issue a savepoint
72: --
73: savepoint create_rec_activity_swi;

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

152: -- messages of any type exist in the Multiple Message List.
153: -- Also disable Multiple Message Detection.
154: --
155: p_return_status := hr_multi_message.get_return_status_disable;
156: hr_utility.set_location(' Leaving:' || l_proc,20);
157: --
158: exception
159: when hr_multi_message.error_message_exist then
160: --

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

167: -- Reset IN OUT parameters and set OUT parameters
168: --
169: p_object_version_number := null;
170: p_return_status := hr_multi_message.get_return_status_disable;
171: hr_utility.set_location(' Leaving:' || l_proc, 30);
172: when others then
173: --
174: -- When Multiple Message Detection is enabled catch
175: -- any Application specific or other unexpected

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

178: -- error.
179: --
180: rollback to create_rec_activity_swi;
181: if hr_multi_message.unexpected_error_add(l_proc) then
182: hr_utility.set_location(' Leaving:' || l_proc,40);
183: raise;
184: end if;
185: --
186: -- Reset IN OUT and set OUT parameters

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

186: -- Reset IN OUT and set OUT parameters
187: --
188: p_object_version_number := null;
189: p_return_status := hr_multi_message.get_return_status_disable;
190: hr_utility.set_location(' Leaving:' || l_proc,50);
191: end create_recruitment_activity;
192: -- ----------------------------------------------------------------------------
193: -- |----------------------< delete_recruitment_activity >---------------------|
194: -- ----------------------------------------------------------------------------

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

206: --
207: -- Other variables
208: l_proc varchar2(72) := g_package ||'delete_recruitment_activity';
209: Begin
210: hr_utility.set_location(' Entering:' || l_proc,10);
211: --
212: -- Issue a savepoint
213: --
214: savepoint delete_rec_activity_swi;

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

248: -- messages of any type exist in the Multiple Message List.
249: -- Also disable Multiple Message Detection.
250: --
251: p_return_status := hr_multi_message.get_return_status_disable;
252: hr_utility.set_location(' Leaving:' || l_proc,20);
253: --
254: exception
255: when hr_multi_message.error_message_exist then
256: --

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

262: --
263: -- Reset IN OUT parameters and set OUT parameters
264: --
265: p_return_status := hr_multi_message.get_return_status_disable;
266: hr_utility.set_location(' Leaving:' || l_proc, 30);
267: when others then
268: --
269: -- When Multiple Message Detection is enabled catch
270: -- any Application specific or other unexpected

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

273: -- error.
274: --
275: rollback to delete_rec_activity_swi;
276: if hr_multi_message.unexpected_error_add(l_proc) then
277: hr_utility.set_location(' Leaving:' || l_proc,40);
278: raise;
279: end if;
280: --
281: -- Reset IN OUT and set OUT parameters

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

280: --
281: -- Reset IN OUT and set OUT parameters
282: --
283: p_return_status := hr_multi_message.get_return_status_disable;
284: hr_utility.set_location(' Leaving:' || l_proc,50);
285: end delete_recruitment_activity;
286: -- ----------------------------------------------------------------------------
287: -- |----------------------< update_recruitment_activity >---------------------|
288: -- ----------------------------------------------------------------------------

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

342: --
343: -- Other variables
344: l_proc varchar2(72) := g_package ||'update_recruitment_activity';
345: Begin
346: hr_utility.set_location(' Entering:' || l_proc,10);
347: --
348: -- Issue a savepoint
349: --
350: savepoint update_rec_activity_swi;

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

426: -- messages of any type exist in the Multiple Message List.
427: -- Also disable Multiple Message Detection.
428: --
429: p_return_status := hr_multi_message.get_return_status_disable;
430: hr_utility.set_location(' Leaving:' || l_proc,20);
431: --
432: exception
433: when hr_multi_message.error_message_exist then
434: --

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

441: -- Reset IN OUT parameters and set OUT parameters
442: --
443: p_object_version_number := l_object_version_number;
444: p_return_status := hr_multi_message.get_return_status_disable;
445: hr_utility.set_location(' Leaving:' || l_proc, 30);
446: when others then
447: --
448: -- When Multiple Message Detection is enabled catch
449: -- any Application specific or other unexpected

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

452: -- error.
453: --
454: rollback to update_rec_activity_swi;
455: if hr_multi_message.unexpected_error_add(l_proc) then
456: hr_utility.set_location(' Leaving:' || l_proc,40);
457: raise;
458: end if;
459: --
460: -- Reset IN OUT and set OUT parameters

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

460: -- Reset IN OUT and set OUT parameters
461: --
462: p_object_version_number := l_object_version_number;
463: p_return_status := hr_multi_message.get_return_status_disable;
464: hr_utility.set_location(' Leaving:' || l_proc,50);
465: end update_recruitment_activity;
466: --
467: -- ----------------------------------------------------------------------------
468: -- |----------------------------< process_api >-------------------------------|

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

499: where recruitment_activity_id = rec_act_id;
500:
501: BEGIN
502: --
503: hr_utility.set_location(' Entering:' || l_proc,10);
504: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
505: --
506: l_parser := xmlparser.newParser;
507: xmlparser.ParseCLOB(l_parser,p_document);

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

500:
501: BEGIN
502: --
503: hr_utility.set_location(' Entering:' || l_proc,10);
504: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
505: --
506: l_parser := xmlparser.newParser;
507: xmlparser.ParseCLOB(l_parser,p_document);
508: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

506: l_parser := xmlparser.newParser;
507: xmlparser.ParseCLOB(l_parser,p_document);
508: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
509: --
510: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
511:
512: l_commitElement := xmldom.makeElement(l_CommitNode);
513: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
514: --

Line 534: hr_utility.set_location('creating :' || l_proc,30);

530: , p_dates_editable => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatesEditable',NULL));
531: --
532: if l_postState = '0' then
533: --
534: hr_utility.set_location('creating :' || l_proc,30);
535: --
536: create_recruitment_activity
537: (p_validate => p_validate
538: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',NULL)

Line 574: hr_utility.set_location('updating :' || l_proc,32);

570: );
571: --
572: elsif l_postState = '2' then
573: --
574: hr_utility.set_location('updating :' || l_proc,32);
575: --
576: update_recruitment_activity
577: (p_validate => p_validate
578: ,p_recruitment_activity_id => l_recruitment_activity_id

Line 625: hr_utility.set_location('deleting :' || l_proc,33);

621: );
622: --
623: elsif l_postState = '3' then
624: --
625: hr_utility.set_location('deleting :' || l_proc,33);
626: --
627: -- delete all child recruitment_activity_for rows before deleting
628: -- the parent entity
629: for rec_act_for in csr_rec_act_for(l_recruitment_activity_id) loop

Line 640: hr_utility.set_location('OVN is NULL for delete ' || l_proc, 36);

636: end loop;
637:
638: -- the following if block is a work around for SSHR bug 5353275
639: if l_object_version_number = hr_api.g_number then
640: hr_utility.set_location('OVN is NULL for delete ' || l_proc, 36);
641: open csr_rec_act_ovn(l_recruitment_activity_id);
642: fetch csr_rec_act_ovn into l_object_version_number;
643: close csr_rec_act_ovn;
644: end if;

Line 657: hr_utility.set_location

653: end if;
654:
655: p_return_status := l_return_status;
656:
657: hr_utility.set_location
658: ('Exiting :'|| l_proc || ': return status :'|| l_return_status || ':',40);
659:
660: end process_api;
661: --

Line 688: hr_utility.trace('Entering get_posting_date');

684: return_date date;
685: --
686: begin
687: --
688: hr_utility.trace('Entering get_posting_date');
689: --
690: return_date := p_current_start_date;
691: --
692: if (p_type_flag = 'I' AND p_current_start_date < sysdate() AND p_dates_editable = 'Y') then

Line 694: hr_utility.trace('Moving internal date to approval date');

690: return_date := p_current_start_date;
691: --
692: if (p_type_flag = 'I' AND p_current_start_date < sysdate() AND p_dates_editable = 'Y') then
693: --
694: hr_utility.trace('Moving internal date to approval date');
695: --
696: return_date := sysdate;
697: end if;
698: --

Line 702: hr_utility.trace('External date not editable - moving to internal date plus posting days');

698: --
699: if (p_type_flag = 'X') then
700: if (p_dates_editable = 'N') then
701: --
702: hr_utility.trace('External date not editable - moving to internal date plus posting days');
703: --
704: return_date := p_internal_start_date + get_internal_posting_days();
705: else
706: --

Line 707: hr_utility.trace('Dates Editable');

703: --
704: return_date := p_internal_start_date + get_internal_posting_days();
705: else
706: --
707: hr_utility.trace('Dates Editable');
708: --
709: if (p_type_flag = 'X' AND p_current_start_date < sysdate()) then
710: --
711: hr_utility.trace('moving external date');

Line 711: hr_utility.trace('moving external date');

707: hr_utility.trace('Dates Editable');
708: --
709: if (p_type_flag = 'X' AND p_current_start_date < sysdate()) then
710: --
711: hr_utility.trace('moving external date');
712: --
713: return_date := p_current_start_date + (sysdate - p_internal_start_date);
714: end if;
715: end if;

Line 718: hr_utility.trace('Exiting get_posting_date returning :' || to_char(return_date) || ':');

714: end if;
715: end if;
716: end if;
717: --
718: hr_utility.trace('Exiting get_posting_date returning :' || to_char(return_date) || ':');
719: --
720: return return_date;
721: --
722: end get_posting_date;

Line 731: hr_utility.trace('Entering get_internal_posting_days');

727: number_of_days varchar2(10);
728: --
729: BEGIN
730: --
731: hr_utility.trace('Entering get_internal_posting_days');
732: --
733: number_of_days := fnd_profile.value('IRC_INTERNAL_POSTING_DAYS');
734:
735: if (number_of_days is null) then

Line 736: hr_utility.trace('Number of days is null - returning -1');

732: --
733: number_of_days := fnd_profile.value('IRC_INTERNAL_POSTING_DAYS');
734:
735: if (number_of_days is null) then
736: hr_utility.trace('Number of days is null - returning -1');
737: return -1;
738: else
739: hr_utility.trace('Returning number of days as :' || number_of_days || ':');
740: return to_number(number_of_days);

Line 739: hr_utility.trace('Returning number of days as :' || number_of_days || ':');

735: if (number_of_days is null) then
736: hr_utility.trace('Number of days is null - returning -1');
737: return -1;
738: else
739: hr_utility.trace('Returning number of days as :' || number_of_days || ':');
740: return to_number(number_of_days);
741: end if;
742: --
743: END get_internal_posting_days;