eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_GB_ABSENCE_EVIDENCE_SWI dependencies on HR_UTILITY

Line 24: hr_utility.set_location(' Entering:' || l_proc,5);

20: from per_absence_attendance_types
21: where absence_attendance_type_id = p_absence_attendance_type_id;
22:
23: begin
24: hr_utility.set_location(' Entering:' || l_proc,5);
25:
26: open get_category_code(p_absence_attendance_type_id);
27: fetch get_category_code into l_absence_category ;
28: close get_category_code ;

Line 33: hr_utility.set_location(l_proc,10);

29:
30: IF l_absence_category = 'S' THEN
31: l_legislation_code := hr_api.return_legislation_code(p_business_group_id);
32: IF l_legislation_code = 'GB' THEN
33: hr_utility.set_location(l_proc,10);
34:
35: populate_sickness_dates := true;
36: END IF;
37: END IF;

Line 38: hr_utility.set_location(' Leaving:' || l_proc,15);

34:
35: populate_sickness_dates := true;
36: END IF;
37: END IF;
38: hr_utility.set_location(' Leaving:' || l_proc,15);
39:
40: return populate_sickness_dates;
41: END is_gb_leg_and_category_s ;
42: --

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

106: --
107: -- Other variables
108: l_proc varchar2(72) := g_package ||'create_gb_absence_evidence';
109: Begin
110: hr_utility.set_location(' Entering:' || l_proc,10);
111: --
112: -- Issue a savepoint
113: --
114: savepoint create_gb_absence_evidence_swi;

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

238: null;
239: end if;
240:
241: p_return_status := 'S';
242: hr_utility.set_location(' Leaving:' || l_proc,20);
243: --
244: exception
245: when DUP_VAL_ON_INDEX then
246: rollback to create_gb_absence_evidence_swi;

Line 247: hr_utility.set_message(804, 'SSP_35020_NON_UNQ_MED_EVID');

243: --
244: exception
245: when DUP_VAL_ON_INDEX then
246: rollback to create_gb_absence_evidence_swi;
247: hr_utility.set_message(804, 'SSP_35020_NON_UNQ_MED_EVID');
248: hr_multi_message.add(p_message_type => hr_multi_message.g_error_msg);
249: p_return_status := 'E';
250: when others then
251: --

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

256: -- error.
257: --
258: rollback to create_gb_absence_evidence_swi;
259: if hr_multi_message.unexpected_error_add(l_proc) then
260: hr_utility.set_location(' Leaving:' || l_proc,40);
261: raise;
262: end if;
263: l_sqlerrm := sqlerrm;
264: l_error_text := hr_utility.get_message;

Line 264: l_error_text := hr_utility.get_message;

260: hr_utility.set_location(' Leaving:' || l_proc,40);
261: raise;
262: end if;
263: l_sqlerrm := sqlerrm;
264: l_error_text := hr_utility.get_message;
265: if l_error_text is null then
266: l_error_text := fnd_message.get;
267: end if;
268:

Line 270: hr_utility.set_location(' Leaving:' || l_proc,45);

266: l_error_text := fnd_message.get;
267: end if;
268:
269: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then
270: hr_utility.set_location(' Leaving:' || l_proc,45);
271: raise;
272: end if;
273: --
274: -- Reset IN OUT and set OUT parameters

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

274: -- Reset IN OUT and set OUT parameters
275: --
276: p_object_version_number := null;
277: p_return_status := 'E';
278: hr_utility.set_location(' Leaving:' || l_proc,50);
279: end create_gb_absence_evidence;
280: -- ----------------------------------------------------------------------------
281: -- |---------------------< update_gb_absence_evidence >-----------------------|
282: -- ----------------------------------------------------------------------------

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

352:
353: ssp_rec c_ssp_medicals%rowtype;
354:
355: Begin
356: hr_utility.set_location(' Entering:' || l_proc,10);
357: --
358: -- Issue a savepoint
359: --
360: savepoint update_gb_absence_swi;

Line 374: hr_utility.set_location(' Stage:' || l_proc,12);

370: l_validate :=
371: hr_api.constant_to_boolean
372: (p_constant_value => p_validate);
373:
374: hr_utility.set_location(' Stage:' || l_proc,12);
375: open c_ssp_medicals;
376: fetch c_ssp_medicals into ssp_rec;
377:
378: if c_ssp_medicals%found then

Line 379: hr_utility.set_location(' Stage:' || l_proc,13);

375: open c_ssp_medicals;
376: fetch c_ssp_medicals into ssp_rec;
377:
378: if c_ssp_medicals%found then
379: hr_utility.set_location(' Stage:' || l_proc,13);
380: if p_evidence_source <> hr_api.g_varchar2 then
381: ssp_rec.evidence_source := p_evidence_source;
382: end if;
383: if p_evidence_date <> hr_api.g_date then

Line 470: hr_utility.set_location(' Stage:' || l_proc,14);

466:
467:
468: open c_is_gb_leg;
469: fetch c_is_gb_leg into l_absence_attendance_type_id, l_business_group_id;
470: hr_utility.set_location(' Stage:' || l_proc,14);
471: IF c_is_gb_leg%FOUND THEN
472: l_populate_sickness_dates := is_gb_leg_and_category_s(l_absence_attendance_type_id , l_business_group_id);
473: END IF;
474: close c_is_gb_leg;

Line 477: hr_utility.set_location(' Stage:' || l_proc,15);

473: END IF;
474: close c_is_gb_leg;
475:
476: -- IF l_populate_sickness_dates THEN
477: hr_utility.set_location(' Stage:' || l_proc,15);
478:
479: update ssp_medicals set
480: evidence_source = ssp_rec.evidence_source
481: ,evidence_date = ssp_rec.evidence_date

Line 511: hr_utility.set_location(' Stage:' || l_proc,16);

507: ,attribute20 = ssp_rec.attribute20
508: where MEDICAL_ID=p_medical_id;
509: -- END IF;
510:
511: hr_utility.set_location(' Stage:' || l_proc,16);
512:
513:
514: -- Convert API non-warning boolean parameter values
515: --

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

518: -- messages of any type exist in the Multiple Message List.
519: -- Also disable Multiple Message Detection.
520:
521: p_return_status := 'S';
522: hr_utility.set_location(' Leaving:' || l_proc,20);
523: --
524: exception
525: when DUP_VAL_ON_INDEX then
526: rollback to create_gb_absence_evidence_swi;

Line 527: hr_utility.set_message(804, 'SSP_35020_NON_UNQ_MED_EVID');

523: --
524: exception
525: when DUP_VAL_ON_INDEX then
526: rollback to create_gb_absence_evidence_swi;
527: hr_utility.set_message(804, 'SSP_35020_NON_UNQ_MED_EVID');
528: hr_multi_message.add(p_message_type => hr_multi_message.g_error_msg);
529: p_return_status := 'E';
530: when others then
531: --

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

536: -- error.
537: --
538: rollback to update_gb_absence_swi;
539: if hr_multi_message.unexpected_error_add(l_proc) then
540: hr_utility.set_location(' Leaving:' || l_proc,40);
541: raise;
542: end if;
543: l_sqlerrm := sqlerrm;
544: l_error_text := hr_utility.get_message;

Line 544: l_error_text := hr_utility.get_message;

540: hr_utility.set_location(' Leaving:' || l_proc,40);
541: raise;
542: end if;
543: l_sqlerrm := sqlerrm;
544: l_error_text := hr_utility.get_message;
545: if l_error_text is null then
546: l_error_text := fnd_message.get;
547: end if;
548:

Line 550: hr_utility.set_location(' Leaving:' || l_proc,45);

546: l_error_text := fnd_message.get;
547: end if;
548:
549: if (((l_error_text is not null) OR (l_sqlerrm is not null)) and (p_validate = hr_api.g_false_num)) then
550: hr_utility.set_location(' Leaving:' || l_proc,45);
551: raise;
552: end if;
553:
554: p_return_status := 'E';

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

551: raise;
552: end if;
553:
554: p_return_status := 'E';
555: hr_utility.set_location(' Leaving:' || l_proc,50);
556: end update_gb_absence_evidence;
557: -- ----------------------------------------------------------------------------
558: -- |----------------------< delete_gb_absence_evidence >----------------------|
559: -- ----------------------------------------------------------------------------

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

574: l_proc varchar2(72) := g_package ||'delete_gb_absence_evidence';
575: Begin
576:
577:
578: hr_utility.set_location(' Entering:' || l_proc,10);
579: --
580: -- Issue a savepoint
581: --
582: savepoint delete_gb_absence_swi;

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

617: -- messages of any type exist in the Multiple Message List.
618: -- Also disable Multiple Message Detection.
619: --
620: p_return_status := 'S';
621: hr_utility.set_location(' Leaving:' || l_proc,20);
622: --
623: exception
624: when others then
625: --

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

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

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

637: --
638: -- Reset IN OUT and set OUT parameters
639: --
640: p_return_status := 'E';
641: hr_utility.set_location(' Leaving:' || l_proc,50);
642: end delete_gb_absence_evidence;
643:
644:
645: -- ----------------------------------------------------------------------------

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

671: where absence_attendance_id = p_absence_attendance_id;
672:
673:
674: BEGIN
675: hr_utility.set_location(' Entering:' || l_proc,10);
676: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
677: savepoint gb_abs_evidence_process_api;
678: l_parser := xmlparser.newParser;
679: xmlparser.ParseCLOB(l_parser,p_document);

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

672:
673:
674: BEGIN
675: hr_utility.set_location(' Entering:' || l_proc,10);
676: hr_utility.set_location(' CLOB --> xmldom.DOMNode:' || l_proc,15);
677: savepoint gb_abs_evidence_process_api;
678: l_parser := xmlparser.newParser;
679: xmlparser.ParseCLOB(l_parser,p_document);
680: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));

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

678: l_parser := xmlparser.newParser;
679: xmlparser.ParseCLOB(l_parser,p_document);
680: l_CommitNode := xmldom.makeNode(xmldom.getDocumentElement(xmlparser.getDocument(l_parser)));
681:
682: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
683:
684: l_commitElement := xmldom.makeElement(l_CommitNode);
685: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
686: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

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

806:
807: end if;
808:
809: p_return_status := l_return_status;
810: hr_utility.set_location('Exiting:' || l_proc,40);
811: EXCEPTION
812: WHEN OTHERS THEN
813: rollback to gb_abs_evidence_process_api;
814: hr_utility.trace('Exception in .process_api:' || SQLERRM );

Line 814: hr_utility.trace('Exception in .process_api:' || SQLERRM );

810: hr_utility.set_location('Exiting:' || l_proc,40);
811: EXCEPTION
812: WHEN OTHERS THEN
813: rollback to gb_abs_evidence_process_api;
814: hr_utility.trace('Exception in .process_api:' || SQLERRM );
815: hr_utility.set_location(' Leaving:' || l_proc,50);
816:
817: raise;
818:

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

811: EXCEPTION
812: WHEN OTHERS THEN
813: rollback to gb_abs_evidence_process_api;
814: hr_utility.trace('Exception in .process_api:' || SQLERRM );
815: hr_utility.set_location(' Leaving:' || l_proc,50);
816:
817: raise;
818:
819: END process_api;