APPS.HR_AMEUTIL_SS dependencies on HR_UTILITY

Line 7: g_debug constant boolean := hr_utility.debug_enabled;

3:
4: -- Package Variables
5: --
6: g_package constant varchar2(14) := 'hr_ameutil_ss.';
7: g_debug constant boolean := hr_utility.debug_enabled;
8:
9:
10:
11:

Line 26: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);

22: begin
23:
24: begin
25: if g_debug then
26: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
27: end if;
28: select t.item_type
29: into c_item_type
30: from hr_api_transactions t

Line 36: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);

32: exception
33: when no_data_found then
34: -- get the data from the steps
35: if g_debug then
36: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
37: end if;
38: select ts.item_type
39: into get_item_type.c_item_type
40: from hr_api_transaction_steps ts

Line 69: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);

65: begin
66:
67: begin
68: if g_debug then
69: hr_utility.set_location('querying hr_api_transactions.item_type for p_transaction_id:'||p_transaction_id, 2);
70: end if;
71: select t.item_key
72: into get_item_key.c_item_key
73: from hr_api_transactions t

Line 79: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);

75: exception
76: when no_data_found then
77: -- get the data from the steps
78: if g_debug then
79: hr_utility.set_location('querying hr_api_transaction_steps.item_type for p_transaction_id:'||p_transaction_id, 2);
80: end if;
81: select ts.item_key
82: into get_item_key.c_item_key
83: from hr_api_transaction_steps ts

Line 137: hr_utility.set_location(lv_procedure_name,1);

133: l_transaction_category varchar2(50);
134: l_category_undefined constant varchar2(5) :='OTHER';
135:
136: BEGIN
137: hr_utility.set_location(lv_procedure_name,1);
138: if(hr_utility.debug_enabled) then
139: -- write debug statements
140: hr_utility.set_location('Entered'||lv_procedure_name||'with step_id:'||p_transaction_step_id, 2);
141: end if;

Line 138: if(hr_utility.debug_enabled) then

134: l_category_undefined constant varchar2(5) :='OTHER';
135:
136: BEGIN
137: hr_utility.set_location(lv_procedure_name,1);
138: if(hr_utility.debug_enabled) then
139: -- write debug statements
140: hr_utility.set_location('Entered'||lv_procedure_name||'with step_id:'||p_transaction_step_id, 2);
141: end if;
142:

Line 140: hr_utility.set_location('Entered'||lv_procedure_name||'with step_id:'||p_transaction_step_id, 2);

136: BEGIN
137: hr_utility.set_location(lv_procedure_name,1);
138: if(hr_utility.debug_enabled) then
139: -- write debug statements
140: hr_utility.set_location('Entered'||lv_procedure_name||'with step_id:'||p_transaction_step_id, 2);
141: end if;
142:
143: BEGIN
144: select decode(hats.api_name,

Line 194: if(hr_utility.debug_enabled) then

190: where hats.transaction_step_id = p_transaction_step_id;
191:
192: END;
193:
194: if(hr_utility.debug_enabled) then
195: -- write debug statements
196: hr_utility.set_location('Leaving '||lv_procedure_name||'with p_transaction_step_id:'||p_transaction_step_id, 10);
197: end if;
198:

Line 196: hr_utility.set_location('Leaving '||lv_procedure_name||'with p_transaction_step_id:'||p_transaction_step_id, 10);

192: END;
193:
194: if(hr_utility.debug_enabled) then
195: -- write debug statements
196: hr_utility.set_location('Leaving '||lv_procedure_name||'with p_transaction_step_id:'||p_transaction_step_id, 10);
197: end if;
198:
199: return l_transaction_category;
200: EXCEPTION

Line 243: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

239:
240: p_hrhd varchar2(1);
241:
242: BEGIN
243: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
244: if(hr_utility.debug_enabled) then
245: -- write debug statements
246: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
247: end if;

Line 244: if(hr_utility.debug_enabled) then

240: p_hrhd varchar2(1);
241:
242: BEGIN
243: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
244: if(hr_utility.debug_enabled) then
245: -- write debug statements
246: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
247: end if;
248:

Line 246: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

242: BEGIN
243: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
244: if(hr_utility.debug_enabled) then
245: -- write debug statements
246: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
247: end if;
248:
249: p_hrhd := isHrHelpDeskAgent(p_transaction_id);
250:

Line 304: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||

300: end;
301: end if;
302: exception
303: when others then
304: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'||
305: lv_transaction_ref_table||' : ' || sqlerrm);
306: -- just log the message no need to raise it
307: end;
308:

Line 309: if(hr_utility.debug_enabled) then

305: lv_transaction_ref_table||' : ' || sqlerrm);
306: -- just log the message no need to raise it
307: end;
308:
309: if(hr_utility.debug_enabled) then
310: -- write debug statements
311: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
312: end if;
313:

Line 311: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

307: end;
308:
309: if(hr_utility.debug_enabled) then
310: -- write debug statements
311: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
312: end if;
313:
314: return fnd_number.number_to_canonical(ln_requestor_person_id);
315: EXCEPTION

Line 363: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

359: -- local variables
360: lv_procedure_name constant varchar2(19) := 'get_payrate_step_id';
361: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
362: BEGIN
363: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
364: if(hr_utility.debug_enabled) then
365: -- write debug statements
366: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
367: end if;

Line 364: if(hr_utility.debug_enabled) then

360: lv_procedure_name constant varchar2(19) := 'get_payrate_step_id';
361: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
362: BEGIN
363: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
364: if(hr_utility.debug_enabled) then
365: -- write debug statements
366: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
367: end if;
368: begin

Line 366: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

362: BEGIN
363: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
364: if(hr_utility.debug_enabled) then
365: -- write debug statements
366: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
367: end if;
368: begin
369: select transaction_step_id
370: into ln_step_id

Line 381: if(hr_utility.debug_enabled) then

377: return null;
378: when others then
379: raise;
380: end;
381: if(hr_utility.debug_enabled) then
382: -- write debug statements
383: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
384: end if;
385: return fnd_number.number_to_canonical(ln_step_id);

Line 383: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

379: raise;
380: end;
381: if(hr_utility.debug_enabled) then
382: -- write debug statements
383: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
384: end if;
385: return fnd_number.number_to_canonical(ln_step_id);
386: EXCEPTION
387:

Line 402: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

398: -- local variables
399: lv_procedure_name constant varchar2(22) := 'get_assignment_step_id';
400: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
401: BEGIN
402: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
403: if(hr_utility.debug_enabled) then
404: -- write debug statements
405: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
406: end if;

Line 403: if(hr_utility.debug_enabled) then

399: lv_procedure_name constant varchar2(22) := 'get_assignment_step_id';
400: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
401: BEGIN
402: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
403: if(hr_utility.debug_enabled) then
404: -- write debug statements
405: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
406: end if;
407: begin

Line 405: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

401: BEGIN
402: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
403: if(hr_utility.debug_enabled) then
404: -- write debug statements
405: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
406: end if;
407: begin
408: select transaction_step_id
409: into ln_step_id

Line 420: if(hr_utility.debug_enabled) then

416: return null;
417: when others then
418: raise;
419: end;
420: if(hr_utility.debug_enabled) then
421: -- write debug statements
422: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
423: end if;
424:

Line 422: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

418: raise;
419: end;
420: if(hr_utility.debug_enabled) then
421: -- write debug statements
422: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
423: end if;
424:
425: return fnd_number.number_to_canonical(ln_step_id);
426: EXCEPTION

Line 442: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

438: -- local variables
439: lv_procedure_name constant varchar2(27) := 'get_supeversior_Chg_step_id';
440: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
441: BEGIN
442: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
443: if(hr_utility.debug_enabled) then
444: -- write debug statements
445: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
446: end if;

Line 443: if(hr_utility.debug_enabled) then

439: lv_procedure_name constant varchar2(27) := 'get_supeversior_Chg_step_id';
440: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
441: BEGIN
442: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
443: if(hr_utility.debug_enabled) then
444: -- write debug statements
445: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
446: end if;
447: begin

Line 445: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

441: BEGIN
442: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
443: if(hr_utility.debug_enabled) then
444: -- write debug statements
445: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
446: end if;
447: begin
448: select transaction_step_id
449: into ln_step_id

Line 459: if(hr_utility.debug_enabled) then

455: return null;
456: when others then
457: raise;
458: end;
459: if(hr_utility.debug_enabled) then
460: -- write debug statements
461: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
462: end if;
463: return fnd_number.number_to_canonical(ln_step_id);

Line 461: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

457: raise;
458: end;
459: if(hr_utility.debug_enabled) then
460: -- write debug statements
461: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
462: end if;
463: return fnd_number.number_to_canonical(ln_step_id);
464: EXCEPTION
465:

Line 480: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

476: -- local variables
477: lv_procedure_name constant varchar2(15) default 'get_loa_step_id';
478: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
479: BEGIN
480: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
481: if(hr_utility.debug_enabled) then
482: -- write debug statements
483: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
484: end if;

Line 481: if(hr_utility.debug_enabled) then

477: lv_procedure_name constant varchar2(15) default 'get_loa_step_id';
478: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
479: BEGIN
480: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
481: if(hr_utility.debug_enabled) then
482: -- write debug statements
483: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
484: end if;
485: begin

Line 483: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

479: BEGIN
480: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
481: if(hr_utility.debug_enabled) then
482: -- write debug statements
483: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
484: end if;
485: begin
486: select transaction_step_id
487: into ln_step_id

Line 497: if(hr_utility.debug_enabled) then

493: return null;
494: when others then
495: raise;
496: end;
497: if(hr_utility.debug_enabled) then
498: -- write debug statements
499: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
500: end if;
501: return fnd_number.number_to_canonical(ln_step_id);

Line 499: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

495: raise;
496: end;
497: if(hr_utility.debug_enabled) then
498: -- write debug statements
499: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
500: end if;
501: return fnd_number.number_to_canonical(ln_step_id);
502: EXCEPTION
503:

Line 518: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

514: -- local variables
515: lv_procedure_name constant varchar2(23) := 'get_termination_step_id';
516: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
517: BEGIN
518: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
519: if(hr_utility.debug_enabled) then
520: -- write debug statements
521: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
522: end if;

Line 519: if(hr_utility.debug_enabled) then

515: lv_procedure_name constant varchar2(23) := 'get_termination_step_id';
516: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
517: BEGIN
518: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
519: if(hr_utility.debug_enabled) then
520: -- write debug statements
521: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
522: end if;
523: begin

Line 521: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

517: BEGIN
518: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
519: if(hr_utility.debug_enabled) then
520: -- write debug statements
521: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
522: end if;
523: begin
524: select transaction_step_id
525: into ln_step_id

Line 535: if(hr_utility.debug_enabled) then

531: return null;
532: when others then
533: raise;
534: end;
535: if(hr_utility.debug_enabled) then
536: -- write debug statements
537: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
538: end if;
539: return fnd_number.number_to_canonical(ln_step_id);

Line 537: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

533: raise;
534: end;
535: if(hr_utility.debug_enabled) then
536: -- write debug statements
537: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
538: end if;
539: return fnd_number.number_to_canonical(ln_step_id);
540: EXCEPTION
541:

Line 556: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

552: lv_procedure_name constant varchar2(11) := 'isChangePay';
553: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
554: lv_status varchar2(10);
555: BEGIN
556: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
557: if(hr_utility.debug_enabled) then
558: -- write debug statements
559: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
560: end if;

Line 557: if(hr_utility.debug_enabled) then

553: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
554: lv_status varchar2(10);
555: BEGIN
556: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
557: if(hr_utility.debug_enabled) then
558: -- write debug statements
559: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
560: end if;
561:

Line 559: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

555: BEGIN
556: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
557: if(hr_utility.debug_enabled) then
558: -- write debug statements
559: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
560: end if;
561:
562: ln_step_id :=get_payrate_step_id(p_transaction_id);
563:

Line 570: if(hr_utility.debug_enabled) then

566: else
567: lv_status := ame_util.booleanAttributeFalse;
568: end if;
569:
570: if(hr_utility.debug_enabled) then
571: -- write debug statements
572: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
573: end if;
574: return lv_status;

Line 572: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

568: end if;
569:
570: if(hr_utility.debug_enabled) then
571: -- write debug statements
572: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
573: end if;
574: return lv_status;
575: EXCEPTION
576:

Line 592: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

588: lv_procedure_name constant varchar2(18) := 'isAssignmentChange';
589: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
590: lv_status varchar2(10);
591: BEGIN
592: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
593: if(hr_utility.debug_enabled) then
594: -- write debug statements
595: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
596: end if;

Line 593: if(hr_utility.debug_enabled) then

589: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
590: lv_status varchar2(10);
591: BEGIN
592: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
593: if(hr_utility.debug_enabled) then
594: -- write debug statements
595: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
596: end if;
597:

Line 595: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

591: BEGIN
592: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
593: if(hr_utility.debug_enabled) then
594: -- write debug statements
595: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
596: end if;
597:
598: ln_step_id :=get_assignment_step_id(p_transaction_id);
599: if(ln_step_id is not null) then

Line 605: if(hr_utility.debug_enabled) then

601: else
602: lv_status := ame_util.booleanAttributeFalse;
603: end if;
604:
605: if(hr_utility.debug_enabled) then
606: -- write debug statements
607: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
608: end if;
609: return lv_status;

Line 607: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

603: end if;
604:
605: if(hr_utility.debug_enabled) then
606: -- write debug statements
607: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
608: end if;
609: return lv_status;
610: EXCEPTION
611:

Line 627: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

623: lv_procedure_name constant varchar2(18) := 'isSupervisorChange';
624: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
625: lv_status varchar2(10);
626: BEGIN
627: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
628: if(hr_utility.debug_enabled) then
629: -- write debug statements
630: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
631: end if;

Line 628: if(hr_utility.debug_enabled) then

624: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
625: lv_status varchar2(10);
626: BEGIN
627: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
628: if(hr_utility.debug_enabled) then
629: -- write debug statements
630: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
631: end if;
632:

Line 630: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

626: BEGIN
627: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
628: if(hr_utility.debug_enabled) then
629: -- write debug statements
630: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
631: end if;
632:
633: ln_step_id := get_supeversior_Chg_step_id(p_transaction_id);
634: if(ln_step_id is not null) then

Line 640: if(hr_utility.debug_enabled) then

636: else
637: lv_status := ame_util.booleanAttributeFalse;
638: end if;
639:
640: if(hr_utility.debug_enabled) then
641: -- write debug statements
642: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
643: end if;
644:

Line 642: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

638: end if;
639:
640: if(hr_utility.debug_enabled) then
641: -- write debug statements
642: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
643: end if;
644:
645: return lv_status;
646: EXCEPTION

Line 664: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

660: lv_procedure_name constant varchar2(11) := 'isLOAChange';
661: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
662: lv_status varchar2(10);
663: BEGIN
664: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
665: if(hr_utility.debug_enabled) then
666: -- write debug statements
667: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
668: end if;

Line 665: if(hr_utility.debug_enabled) then

661: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
662: lv_status varchar2(10);
663: BEGIN
664: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
665: if(hr_utility.debug_enabled) then
666: -- write debug statements
667: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
668: end if;
669:

Line 667: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

663: BEGIN
664: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
665: if(hr_utility.debug_enabled) then
666: -- write debug statements
667: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
668: end if;
669:
670: ln_step_id := get_loa_step_id(p_transaction_id);
671: if(ln_step_id is not null) then

Line 677: if(hr_utility.debug_enabled) then

673: else
674: lv_status := ame_util.booleanAttributeFalse;
675: end if;
676:
677: if(hr_utility.debug_enabled) then
678: -- write debug statements
679: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
680: end if;
681:

Line 679: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

675: end if;
676:
677: if(hr_utility.debug_enabled) then
678: -- write debug statements
679: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
680: end if;
681:
682: return lv_status;
683: EXCEPTION

Line 701: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

697: lv_procedure_name constant varchar2(18) := 'isAssignmentChange';
698: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
699: lv_status varchar2(10);
700: BEGIN
701: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
702: if(hr_utility.debug_enabled) then
703: -- write debug statements
704: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
705: end if;

Line 702: if(hr_utility.debug_enabled) then

698: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
699: lv_status varchar2(10);
700: BEGIN
701: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
702: if(hr_utility.debug_enabled) then
703: -- write debug statements
704: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
705: end if;
706:

Line 704: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

700: BEGIN
701: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
702: if(hr_utility.debug_enabled) then
703: -- write debug statements
704: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
705: end if;
706:
707: ln_step_id :=get_termination_step_id(p_transaction_id);
708: if(ln_step_id is not null) then

Line 714: if(hr_utility.debug_enabled) then

710: else
711: lv_status := ame_util.booleanAttributeFalse;
712: end if;
713:
714: if(hr_utility.debug_enabled) then
715: -- write debug statements
716: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
717: end if;
718: return lv_status;

Line 716: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

712: end if;
713:
714: if(hr_utility.debug_enabled) then
715: -- write debug statements
716: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
717: end if;
718: return lv_status;
719: EXCEPTION
720:

Line 739: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

735: ln_no_of_components NUMBER ;
736: lv_param_name hr_api_transaction_values.varchar2_value%type;
737: p_sum_percentage per_pay_transactions.change_percentage%type;
738: BEGIN
739: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
740: if(hr_utility.debug_enabled) then
741: -- write debug statements
742: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
743: end if;

Line 740: if(hr_utility.debug_enabled) then

736: lv_param_name hr_api_transaction_values.varchar2_value%type;
737: p_sum_percentage per_pay_transactions.change_percentage%type;
738: BEGIN
739: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
740: if(hr_utility.debug_enabled) then
741: -- write debug statements
742: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
743: end if;
744:

Line 742: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

738: BEGIN
739: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
740: if(hr_utility.debug_enabled) then
741: -- write debug statements
742: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
743: end if;
744:
745: -- get payrate step id
746: ln_step_id := get_payrate_step_id(p_transaction_id);

Line 796: if(hr_utility.debug_enabled) then

792: end if;
793: return ln_salary_percent_change;
794:
795:
796: if(hr_utility.debug_enabled) then
797: -- write debug statements
798: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
799: end if;
800: EXCEPTION

Line 798: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

794:
795:
796: if(hr_utility.debug_enabled) then
797: -- write debug statements
798: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
799: end if;
800: EXCEPTION
801:
802: WHEN OTHERS THEN

Line 820: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

816: ln_no_of_components NUMBER ;
817: lv_param_name hr_api_transaction_values.varchar2_value%type;
818: p_sum_amount per_pay_transactions.change_amount_n%type;
819: BEGIN
820: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
821: if(hr_utility.debug_enabled) then
822: -- write debug statements
823: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
824: end if;

Line 821: if(hr_utility.debug_enabled) then

817: lv_param_name hr_api_transaction_values.varchar2_value%type;
818: p_sum_amount per_pay_transactions.change_amount_n%type;
819: BEGIN
820: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
821: if(hr_utility.debug_enabled) then
822: -- write debug statements
823: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
824: end if;
825:

Line 823: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

819: BEGIN
820: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
821: if(hr_utility.debug_enabled) then
822: -- write debug statements
823: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
824: end if;
825:
826: -- get the payrate step id
827: ln_step_id := get_payrate_step_id(p_transaction_id);

Line 871: if(hr_utility.debug_enabled) then

867: end if;
868: end if;
869: return ln_salary_amt_change;
870:
871: if(hr_utility.debug_enabled) then
872: -- write debug statements
873: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
874: end if;
875: EXCEPTION

Line 873: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

869: return ln_salary_amt_change;
870:
871: if(hr_utility.debug_enabled) then
872: -- write debug statements
873: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
874: end if;
875: EXCEPTION
876:
877: WHEN OTHERS THEN

Line 892: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

888: lv_procedure_name constant varchar2(19) := 'is_new_change_pay';
889: ln_api_name hr_api_transaction_steps.api_name%type;
890: lv_status varchar2(10);
891: BEGIN
892: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
893: if(hr_utility.debug_enabled) then
894: -- write debug statements
895: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_step_id:'||p_transaction_step_id, 2);
896: end if;

Line 893: if(hr_utility.debug_enabled) then

889: ln_api_name hr_api_transaction_steps.api_name%type;
890: lv_status varchar2(10);
891: BEGIN
892: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
893: if(hr_utility.debug_enabled) then
894: -- write debug statements
895: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_step_id:'||p_transaction_step_id, 2);
896: end if;
897: begin

Line 895: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_step_id:'||p_transaction_step_id, 2);

891: BEGIN
892: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
893: if(hr_utility.debug_enabled) then
894: -- write debug statements
895: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_step_id:'||p_transaction_step_id, 2);
896: end if;
897: begin
898: select api_name
899: into ln_api_name

Line 908: if(hr_utility.debug_enabled) then

904: return null;
905: when others then
906: raise;
907: end;
908: if(hr_utility.debug_enabled) then
909: -- write debug statements
910: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_step__id:'||p_transaction_step_id, 10);
911: end if;
912: if (ln_api_name='PER_SSHR_CHANGE_PAY.PROCESS_API') then

Line 910: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_step__id:'||p_transaction_step_id, 10);

906: raise;
907: end;
908: if(hr_utility.debug_enabled) then
909: -- write debug statements
910: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_step__id:'||p_transaction_step_id, 10);
911: end if;
912: if (ln_api_name='PER_SSHR_CHANGE_PAY.PROCESS_API') then
913: lv_status := ame_util.booleanAttributeTrue;
914: else

Line 932: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

928: -- local variables
929: lv_procedure_name constant varchar2(25) := 'get_transaction_init_date';
930: lv_creation_date_string varchar2(30) default null;
931: BEGIN
932: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
933: if(hr_utility.debug_enabled) then
934: -- write debug statements
935: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
936: end if;

Line 933: if(hr_utility.debug_enabled) then

929: lv_procedure_name constant varchar2(25) := 'get_transaction_init_date';
930: lv_creation_date_string varchar2(30) default null;
931: BEGIN
932: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
933: if(hr_utility.debug_enabled) then
934: -- write debug statements
935: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
936: end if;
937: begin

Line 935: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

931: BEGIN
932: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
933: if(hr_utility.debug_enabled) then
934: -- write debug statements
935: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
936: end if;
937: begin
938: select ame_util.versiondatetostring(creation_date)
939: into lv_creation_date_string

Line 947: if(hr_utility.debug_enabled) then

943: when others then
944: raise;
945: end;
946:
947: if(hr_utility.debug_enabled) then
948: -- write debug statements
949: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
950: end if;
951: return lv_creation_date_string;

Line 949: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

945: end;
946:
947: if(hr_utility.debug_enabled) then
948: -- write debug statements
949: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
950: end if;
951: return lv_creation_date_string;
952: EXCEPTION
953:

Line 971: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

967: lv_effective_date_string varchar2(30) default null;
968: lv_item_type varchar2(50);
969: lv_item_key varchar2(100);
970: BEGIN
971: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
972: if(hr_utility.debug_enabled) then
973: -- write debug statements
974: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
975: end if;

Line 972: if(hr_utility.debug_enabled) then

968: lv_item_type varchar2(50);
969: lv_item_key varchar2(100);
970: BEGIN
971: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
972: if(hr_utility.debug_enabled) then
973: -- write debug statements
974: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
975: end if;
976:

Line 974: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

970: BEGIN
971: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
972: if(hr_utility.debug_enabled) then
973: -- write debug statements
974: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
975: end if;
976:
977:
978: lv_item_type := get_item_type(p_transaction_id);

Line 992: if(hr_utility.debug_enabled) then

988: select transaction_effective_date into lv_effective_date_string from hr_api_transactions
989: where transaction_id = p_transaction_id;
990: end if;
991:
992: if(hr_utility.debug_enabled) then
993: -- write debug statements
994: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
995: end if;
996:

Line 994: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

990: end if;
991:
992: if(hr_utility.debug_enabled) then
993: -- write debug statements
994: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
995: end if;
996:
997: return lv_effective_date_string;
998:

Line 1020: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1016: ln_new_sel_person_prop_sup_id number;
1017: ln_old_sel_person_prop_sup_id number;
1018:
1019: BEGIN
1020: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1021: if(hr_utility.debug_enabled) then
1022: -- write debug statements
1023: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1024: end if;

Line 1021: if(hr_utility.debug_enabled) then

1017: ln_old_sel_person_prop_sup_id number;
1018:
1019: BEGIN
1020: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1021: if(hr_utility.debug_enabled) then
1022: -- write debug statements
1023: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1024: end if;
1025: -- get step id

Line 1023: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1019: BEGIN
1020: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1021: if(hr_utility.debug_enabled) then
1022: -- write debug statements
1023: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1024: end if;
1025: -- get step id
1026: ln_step_id:= get_supeversior_Chg_step_id(p_transaction_id);
1027: if(ln_step_id is not null) then

Line 1047: if(hr_utility.debug_enabled) then

1043: ln_sel_person_prop_sup_id := null;
1044: end if;
1045:
1046:
1047: if(hr_utility.debug_enabled) then
1048: -- write debug statements
1049: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1050: end if;
1051: return ln_sel_person_prop_sup_id;

Line 1049: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1045:
1046:
1047: if(hr_utility.debug_enabled) then
1048: -- write debug statements
1049: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1050: end if;
1051: return ln_sel_person_prop_sup_id;
1052:
1053: EXCEPTION

Line 1070: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1066: lv_selected_person_id varchar2(10);
1067: lv_item_type varchar2(50);
1068: lv_item_key varchar2(100);
1069: BEGIN
1070: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1071: if(hr_utility.debug_enabled) then
1072: -- write debug statements
1073: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1074: end if;

Line 1071: if(hr_utility.debug_enabled) then

1067: lv_item_type varchar2(50);
1068: lv_item_key varchar2(100);
1069: BEGIN
1070: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1071: if(hr_utility.debug_enabled) then
1072: -- write debug statements
1073: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1074: end if;
1075:

Line 1073: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1069: BEGIN
1070: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1071: if(hr_utility.debug_enabled) then
1072: -- write debug statements
1073: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1074: end if;
1075:
1076: lv_item_type := get_item_type(p_transaction_id);
1077: lv_item_key := get_item_key(p_transaction_id);

Line 1091: if(hr_utility.debug_enabled) then

1087: select selected_person_id into lv_selected_person_id from hr_api_transactions
1088: where transaction_id = p_transaction_id;
1089: end if;
1090:
1091: if(hr_utility.debug_enabled) then
1092: -- write debug statements
1093: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1094: end if;
1095:

Line 1093: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1089: end if;
1090:
1091: if(hr_utility.debug_enabled) then
1092: -- write debug statements
1093: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1094: end if;
1095:
1096: return fnd_number.number_to_canonical(lv_selected_person_id);
1097: EXCEPTION

Line 1115: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1111: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1112: ln_new_job_id number;
1113: ln_orginal_job_id number;
1114: BEGIN
1115: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1116: if(hr_utility.debug_enabled) then
1117: -- write debug statements
1118: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1119: end if;

Line 1116: if(hr_utility.debug_enabled) then

1112: ln_new_job_id number;
1113: ln_orginal_job_id number;
1114: BEGIN
1115: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1116: if(hr_utility.debug_enabled) then
1117: -- write debug statements
1118: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1119: end if;
1120:

Line 1118: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1114: BEGIN
1115: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1116: if(hr_utility.debug_enabled) then
1117: -- write debug statements
1118: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1119: end if;
1120:
1121: ln_step_id := get_assignment_step_id(p_transaction_id);
1122: if(ln_step_id is not null) then

Line 1140: if(hr_utility.debug_enabled) then

1136: else
1137: lv_job_id:= null;
1138: end if;
1139:
1140: if(hr_utility.debug_enabled) then
1141: -- write debug statements
1142: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1143: end if;
1144:

Line 1142: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1138: end if;
1139:
1140: if(hr_utility.debug_enabled) then
1141: -- write debug statements
1142: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1143: end if;
1144:
1145: return lv_job_id;
1146: EXCEPTION

Line 1165: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1161: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1162: ln_new_position_id number;
1163: ln_orginal_position_id number;
1164: BEGIN
1165: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1166: if(hr_utility.debug_enabled) then
1167: -- write debug statements
1168: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1169: end if;

Line 1166: if(hr_utility.debug_enabled) then

1162: ln_new_position_id number;
1163: ln_orginal_position_id number;
1164: BEGIN
1165: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1166: if(hr_utility.debug_enabled) then
1167: -- write debug statements
1168: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1169: end if;
1170:

Line 1168: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1164: BEGIN
1165: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1166: if(hr_utility.debug_enabled) then
1167: -- write debug statements
1168: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1169: end if;
1170:
1171: ln_step_id := get_assignment_step_id(p_transaction_id);
1172: if(ln_step_id is not null) then

Line 1190: if(hr_utility.debug_enabled) then

1186: else
1187: lv_position_id:= null;
1188: end if;
1189:
1190: if(hr_utility.debug_enabled) then
1191: -- write debug statements
1192: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1193: end if;
1194: return lv_position_id;

Line 1192: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1188: end if;
1189:
1190: if(hr_utility.debug_enabled) then
1191: -- write debug statements
1192: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1193: end if;
1194: return lv_position_id;
1195: EXCEPTION
1196:

Line 1216: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1212: ln_new_id number;
1213: ln_orginal_id number;
1214:
1215: BEGIN
1216: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1217: if(hr_utility.debug_enabled) then
1218: -- write debug statements
1219: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1220: end if;

Line 1217: if(hr_utility.debug_enabled) then

1213: ln_orginal_id number;
1214:
1215: BEGIN
1216: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1217: if(hr_utility.debug_enabled) then
1218: -- write debug statements
1219: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1220: end if;
1221:

Line 1219: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1215: BEGIN
1216: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1217: if(hr_utility.debug_enabled) then
1218: -- write debug statements
1219: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1220: end if;
1221:
1222:
1223: ln_step_id := get_assignment_step_id(p_transaction_id);

Line 1244: if(hr_utility.debug_enabled) then

1240: lv_grade_id:= null;
1241: end if;
1242:
1243:
1244: if(hr_utility.debug_enabled) then
1245: -- write debug statements
1246: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1247: end if;
1248: return lv_grade_id;

Line 1246: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1242:
1243:
1244: if(hr_utility.debug_enabled) then
1245: -- write debug statements
1246: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1247: end if;
1248: return lv_grade_id;
1249: EXCEPTION
1250:

Line 1267: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1263: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1264: ln_new_id number;
1265: ln_orginal_id number;
1266: BEGIN
1267: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1268: if(hr_utility.debug_enabled) then
1269: -- write debug statements
1270: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1271: end if;

Line 1268: if(hr_utility.debug_enabled) then

1264: ln_new_id number;
1265: ln_orginal_id number;
1266: BEGIN
1267: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1268: if(hr_utility.debug_enabled) then
1269: -- write debug statements
1270: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1271: end if;
1272: ln_step_id := get_assignment_step_id(p_transaction_id);

Line 1270: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1266: BEGIN
1267: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1268: if(hr_utility.debug_enabled) then
1269: -- write debug statements
1270: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1271: end if;
1272: ln_step_id := get_assignment_step_id(p_transaction_id);
1273: if(ln_step_id is not null) then
1274:

Line 1291: if(hr_utility.debug_enabled) then

1287: else
1288: lv_location_id:= null;
1289: end if;
1290:
1291: if(hr_utility.debug_enabled) then
1292: -- write debug statements
1293: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1294: end if;
1295: return lv_location_id;

Line 1293: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1289: end if;
1290:
1291: if(hr_utility.debug_enabled) then
1292: -- write debug statements
1293: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1294: end if;
1295: return lv_location_id;
1296: EXCEPTION
1297:

Line 1313: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1309: lv_transaction_ref_table hr_api_transactions.transaction_ref_table%type;
1310: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1311: lv_system_type VARCHAR2(30) default null;
1312: BEGIN
1313: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1314: if(hr_utility.debug_enabled) then
1315: -- write debug statements
1316: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1317: end if;

Line 1314: if(hr_utility.debug_enabled) then

1310: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1311: lv_system_type VARCHAR2(30) default null;
1312: BEGIN
1313: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1314: if(hr_utility.debug_enabled) then
1315: -- write debug statements
1316: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1317: end if;
1318:

Line 1316: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1312: BEGIN
1313: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1314: if(hr_utility.debug_enabled) then
1315: -- write debug statements
1316: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1317: end if;
1318:
1319: begin
1320: select transaction_ref_table,transaction_ref_id

Line 1339: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'|| sqlerrm);

1335: end;
1336: end if;
1337: exception
1338: when others then
1339: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'|| sqlerrm);
1340: -- just log the message no need to raise it
1341: end;
1342: if(hr_utility.debug_enabled) then
1343: -- write debug statements

Line 1342: if(hr_utility.debug_enabled) then

1338: when others then
1339: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'|| sqlerrm);
1340: -- just log the message no need to raise it
1341: end;
1342: if(hr_utility.debug_enabled) then
1343: -- write debug statements
1344: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1345: end if;
1346: return lv_system_type;

Line 1344: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1340: -- just log the message no need to raise it
1341: end;
1342: if(hr_utility.debug_enabled) then
1343: -- write debug statements
1344: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1345: end if;
1346: return lv_system_type;
1347: EXCEPTION
1348:

Line 1366: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1362: lv_transaction_ref_id hr_api_transactions.transaction_ref_id%type;
1363: ln_overall_rating number;
1364:
1365: BEGIN
1366: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1367: if(hr_utility.debug_enabled) then
1368: -- write debug statements
1369: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1370: end if;

Line 1367: if(hr_utility.debug_enabled) then

1363: ln_overall_rating number;
1364:
1365: BEGIN
1366: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1367: if(hr_utility.debug_enabled) then
1368: -- write debug statements
1369: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1370: end if;
1371:

Line 1369: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1365: BEGIN
1366: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1367: if(hr_utility.debug_enabled) then
1368: -- write debug statements
1369: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1370: end if;
1371:
1372: begin
1373: select transaction_ref_table,transaction_ref_id

Line 1393: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'|| sqlerrm);

1389: end;
1390: end if;
1391: exception
1392: when others then
1393: hr_utility.trace(' exception in checking the hr_api_transactions.transaction_ref_table:'|| sqlerrm);
1394: -- just log the message no need to raise it
1395: end;
1396:
1397:

Line 1402: if(hr_utility.debug_enabled) then

1398:
1399:
1400:
1401:
1402: if(hr_utility.debug_enabled) then
1403: -- write debug statements
1404: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1405: end if;
1406: return fnd_number.number_to_canonical(ln_overall_rating);

Line 1404: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1400:
1401:
1402: if(hr_utility.debug_enabled) then
1403: -- write debug statements
1404: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1405: end if;
1406: return fnd_number.number_to_canonical(ln_overall_rating);
1407: EXCEPTION
1408:

Line 1423: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1419: lv_procedure_name constant varchar2(19) := 'get_absence_type_id';
1420: lv_absence_type_id number;
1421: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1422: BEGIN
1423: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1424: if(hr_utility.debug_enabled) then
1425: -- write debug statements
1426: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1427: end if;

Line 1424: if(hr_utility.debug_enabled) then

1420: lv_absence_type_id number;
1421: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1422: BEGIN
1423: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1424: if(hr_utility.debug_enabled) then
1425: -- write debug statements
1426: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1427: end if;
1428:

Line 1426: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1422: BEGIN
1423: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1424: if(hr_utility.debug_enabled) then
1425: -- write debug statements
1426: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1427: end if;
1428:
1429: ln_step_id := get_loa_step_id(p_transaction_id);
1430: if(ln_step_id is not null) then

Line 1436: if(hr_utility.debug_enabled) then

1432: else
1433: lv_absence_type_id:= null;
1434: end if;
1435:
1436: if(hr_utility.debug_enabled) then
1437: -- write debug statements
1438: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1439: end if;
1440: return lv_absence_type_id;

Line 1438: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1434: end if;
1435:
1436: if(hr_utility.debug_enabled) then
1437: -- write debug statements
1438: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1439: end if;
1440: return lv_absence_type_id;
1441: EXCEPTION
1442:

Line 1461: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1457: ln_new_id number;
1458: ln_orginal_id number;
1459:
1460: BEGIN
1461: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1462: if(hr_utility.debug_enabled) then
1463: -- write debug statements
1464: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1465: end if;

Line 1462: if(hr_utility.debug_enabled) then

1458: ln_orginal_id number;
1459:
1460: BEGIN
1461: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1462: if(hr_utility.debug_enabled) then
1463: -- write debug statements
1464: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1465: end if;
1466: ln_step_id := get_assignment_step_id(p_transaction_id);

Line 1464: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1460: BEGIN
1461: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1462: if(hr_utility.debug_enabled) then
1463: -- write debug statements
1464: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1465: end if;
1466: ln_step_id := get_assignment_step_id(p_transaction_id);
1467: if(ln_step_id is not null) then
1468:

Line 1485: if(hr_utility.debug_enabled) then

1481: else
1482: lv_payroll_id:= null;
1483: end if;
1484:
1485: if(hr_utility.debug_enabled) then
1486: -- write debug statements
1487: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1488: end if;
1489: return lv_payroll_id;

Line 1487: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1483: end if;
1484:
1485: if(hr_utility.debug_enabled) then
1486: -- write debug statements
1487: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1488: end if;
1489: return lv_payroll_id;
1490: EXCEPTION
1491:

Line 1514: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1510: ln_new_id number;
1511: ln_orginal_id number;
1512:
1513: BEGIN
1514: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1515: if(hr_utility.debug_enabled) then
1516: -- write debug statements
1517: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1518: end if;

Line 1515: if(hr_utility.debug_enabled) then

1511: ln_orginal_id number;
1512:
1513: BEGIN
1514: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1515: if(hr_utility.debug_enabled) then
1516: -- write debug statements
1517: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1518: end if;
1519:

Line 1517: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1513: BEGIN
1514: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1515: if(hr_utility.debug_enabled) then
1516: -- write debug statements
1517: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1518: end if;
1519:
1520: ln_step_id := get_assignment_step_id(p_transaction_id);
1521: if(ln_step_id is not null) then

Line 1571: if(hr_utility.debug_enabled) then

1567: lv_salary_basis:= null;
1568: end if;
1569:
1570:
1571: if(hr_utility.debug_enabled) then
1572: -- write debug statements
1573: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1574: end if;
1575: return lv_salary_basis;

Line 1573: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1569:
1570:
1571: if(hr_utility.debug_enabled) then
1572: -- write debug statements
1573: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1574: end if;
1575: return lv_salary_basis;
1576: EXCEPTION
1577:

Line 1596: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1592: lv_new_value VARCHAR2(30);
1593: lv_orginal_value VARCHAR2(30);
1594:
1595: BEGIN
1596: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1597: if(hr_utility.debug_enabled) then
1598: -- write debug statements
1599: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1600: end if;

Line 1597: if(hr_utility.debug_enabled) then

1593: lv_orginal_value VARCHAR2(30);
1594:
1595: BEGIN
1596: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1597: if(hr_utility.debug_enabled) then
1598: -- write debug statements
1599: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1600: end if;
1601:

Line 1599: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1595: BEGIN
1596: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1597: if(hr_utility.debug_enabled) then
1598: -- write debug statements
1599: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1600: end if;
1601:
1602: ln_step_id := get_assignment_step_id(p_transaction_id);
1603: if(ln_step_id is not null) then

Line 1624: if(hr_utility.debug_enabled) then

1620: lv_asg_change_reason:= null;
1621: end if;
1622:
1623:
1624: if(hr_utility.debug_enabled) then
1625: -- write debug statements
1626: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1627: end if;
1628: return lv_asg_change_reason;

Line 1626: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1622:
1623:
1624: if(hr_utility.debug_enabled) then
1625: -- write debug statements
1626: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1627: end if;
1628: return lv_asg_change_reason;
1629: EXCEPTION
1630:

Line 1646: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1642: lv_leaving_reason VARCHAR2(30) default null;
1643: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1644:
1645: BEGIN
1646: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1647: if(hr_utility.debug_enabled) then
1648: -- write debug statements
1649: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1650: end if;

Line 1647: if(hr_utility.debug_enabled) then

1643: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1644:
1645: BEGIN
1646: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1647: if(hr_utility.debug_enabled) then
1648: -- write debug statements
1649: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1650: end if;
1651: ln_step_id := get_termination_step_id(p_transaction_id);

Line 1649: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1645: BEGIN
1646: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1647: if(hr_utility.debug_enabled) then
1648: -- write debug statements
1649: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1650: end if;
1651: ln_step_id := get_termination_step_id(p_transaction_id);
1652: if(ln_step_id is not null) then
1653: lv_leaving_reason:= hr_transaction_api.get_varchar2_value

Line 1660: if(hr_utility.debug_enabled) then

1656: else
1657: lv_leaving_reason:= null;
1658: end if;
1659:
1660: if(hr_utility.debug_enabled) then
1661: -- write debug statements
1662: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1663: end if;
1664: return lv_leaving_reason;

Line 1662: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1658: end if;
1659:
1660: if(hr_utility.debug_enabled) then
1661: -- write debug statements
1662: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1663: end if;
1664: return lv_leaving_reason;
1665: EXCEPTION
1666:

Line 1681: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1677: -- local variables
1678: lv_procedure_name constant varchar2(18) := 'get_person_type_id';
1679: lv_person_type_id VARCHAR2(30) default null;
1680: BEGIN
1681: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1682: if(hr_utility.debug_enabled) then
1683: -- write debug statements
1684: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1685: end if;

Line 1682: if(hr_utility.debug_enabled) then

1678: lv_procedure_name constant varchar2(18) := 'get_person_type_id';
1679: lv_person_type_id VARCHAR2(30) default null;
1680: BEGIN
1681: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1682: if(hr_utility.debug_enabled) then
1683: -- write debug statements
1684: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1685: end if;
1686:

Line 1684: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1680: BEGIN
1681: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1682: if(hr_utility.debug_enabled) then
1683: -- write debug statements
1684: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1685: end if;
1686:
1687:
1688: if(hr_utility.debug_enabled) then

Line 1688: if(hr_utility.debug_enabled) then

1684: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1685: end if;
1686:
1687:
1688: if(hr_utility.debug_enabled) then
1689: -- write debug statements
1690: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1691: end if;
1692: return lv_person_type_id;

Line 1690: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1686:
1687:
1688: if(hr_utility.debug_enabled) then
1689: -- write debug statements
1690: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1691: end if;
1692: return lv_person_type_id;
1693: EXCEPTION
1694:

Line 1741: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1737: -- local variables
1738: lv_procedure_name constant varchar2(21) := 'get_length_of_service';
1739: ln_length_of_service number;
1740: BEGIN
1741: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1742: if(hr_utility.debug_enabled) then
1743: -- write debug statements
1744: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1745: end if;

Line 1742: if(hr_utility.debug_enabled) then

1738: lv_procedure_name constant varchar2(21) := 'get_length_of_service';
1739: ln_length_of_service number;
1740: BEGIN
1741: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1742: if(hr_utility.debug_enabled) then
1743: -- write debug statements
1744: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1745: end if;
1746:

Line 1744: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1740: BEGIN
1741: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1742: if(hr_utility.debug_enabled) then
1743: -- write debug statements
1744: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1745: end if;
1746:
1747: ln_length_of_service := getYOS(get_selected_person_id(p_transaction_id),trunc(sysdate));
1748:

Line 1749: if(hr_utility.debug_enabled) then

1745: end if;
1746:
1747: ln_length_of_service := getYOS(get_selected_person_id(p_transaction_id),trunc(sysdate));
1748:
1749: if(hr_utility.debug_enabled) then
1750: -- write debug statements
1751: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1752: end if;
1753: return fnd_number.number_to_canonical(ln_length_of_service);

Line 1751: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1747: ln_length_of_service := getYOS(get_selected_person_id(p_transaction_id),trunc(sysdate));
1748:
1749: if(hr_utility.debug_enabled) then
1750: -- write debug statements
1751: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1752: end if;
1753: return fnd_number.number_to_canonical(ln_length_of_service);
1754: EXCEPTION
1755:

Line 1774: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1770: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1771: lv_new_value VARCHAR2(30);
1772: lv_orginal_value VARCHAR2(30);
1773: BEGIN
1774: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1775: if(hr_utility.debug_enabled) then
1776: -- write debug statements
1777: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1778: end if;

Line 1775: if(hr_utility.debug_enabled) then

1771: lv_new_value VARCHAR2(30);
1772: lv_orginal_value VARCHAR2(30);
1773: BEGIN
1774: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1775: if(hr_utility.debug_enabled) then
1776: -- write debug statements
1777: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1778: end if;
1779: ln_step_id := get_assignment_step_id(p_transaction_id);

Line 1777: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1773: BEGIN
1774: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1775: if(hr_utility.debug_enabled) then
1776: -- write debug statements
1777: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1778: end if;
1779: ln_step_id := get_assignment_step_id(p_transaction_id);
1780: if(ln_step_id is not null) then
1781: lv_new_value:= hr_transaction_api.get_varchar2_value

Line 1801: if(hr_utility.debug_enabled) then

1797: end if;
1798:
1799:
1800:
1801: if(hr_utility.debug_enabled) then
1802: -- write debug statements
1803: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1804: end if;
1805: return lv_assignment_category;

Line 1803: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1799:
1800:
1801: if(hr_utility.debug_enabled) then
1802: -- write debug statements
1803: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1804: end if;
1805: return lv_assignment_category;
1806: EXCEPTION
1807:

Line 1824: if(hr_utility.debug_enabled) then

1820: lv_orig_system varchar2(50);
1821: lv_orig_system_id number;
1822: BEGIN
1823:
1824: if(hr_utility.debug_enabled) then
1825: -- write debug statements
1826: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1827: end if;
1828:

Line 1826: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1822: BEGIN
1823:
1824: if(hr_utility.debug_enabled) then
1825: -- write debug statements
1826: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1827: end if;
1828:
1829: if(isMidPayPayPeriodChange(p_transaction_id)=ame_util.booleanAttributeTrue) then
1830: if(hr_utility.debug_enabled) then

Line 1830: if(hr_utility.debug_enabled) then

1826: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1827: end if;
1828:
1829: if(isMidPayPayPeriodChange(p_transaction_id)=ame_util.booleanAttributeTrue) then
1830: if(hr_utility.debug_enabled) then
1831: hr_utility.set_location('calling wf_engine.getitemattrtext ',3);
1832: end if;
1833: lv_user_name:= wf_engine.getitemattrtext(get_item_type(p_transaction_id),get_item_key(p_transaction_id),'HR_PAYROLL_CONTACT_USERNAME',true);
1834: -- get the role info details

Line 1831: hr_utility.set_location('calling wf_engine.getitemattrtext ',3);

1827: end if;
1828:
1829: if(isMidPayPayPeriodChange(p_transaction_id)=ame_util.booleanAttributeTrue) then
1830: if(hr_utility.debug_enabled) then
1831: hr_utility.set_location('calling wf_engine.getitemattrtext ',3);
1832: end if;
1833: lv_user_name:= wf_engine.getitemattrtext(get_item_type(p_transaction_id),get_item_key(p_transaction_id),'HR_PAYROLL_CONTACT_USERNAME',true);
1834: -- get the role info details
1835: if(lv_user_name is not null) then

Line 1841: if(hr_utility.debug_enabled) then

1837: lv_user_name:=lv_orig_system||':'||lv_orig_system_id;
1838: end if;
1839: end if;
1840:
1841: if(hr_utility.debug_enabled) then
1842: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1843: end if;
1844:
1845: return lv_user_name;

Line 1842: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1838: end if;
1839: end if;
1840:
1841: if(hr_utility.debug_enabled) then
1842: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1843: end if;
1844:
1845: return lv_user_name;
1846:

Line 1863: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1859: -- local variables
1860: lv_procedure_name constant varchar2(25) := 'get_basic_details_step_id';
1861: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1862: BEGIN
1863: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1864: if(hr_utility.debug_enabled) then
1865: -- write debug statements
1866: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1867: end if;

Line 1864: if(hr_utility.debug_enabled) then

1860: lv_procedure_name constant varchar2(25) := 'get_basic_details_step_id';
1861: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1862: BEGIN
1863: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1864: if(hr_utility.debug_enabled) then
1865: -- write debug statements
1866: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1867: end if;
1868: begin

Line 1866: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1862: BEGIN
1863: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1864: if(hr_utility.debug_enabled) then
1865: -- write debug statements
1866: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1867: end if;
1868: begin
1869: select transaction_step_id
1870: into ln_step_id

Line 1880: if(hr_utility.debug_enabled) then

1876: return null;
1877: when others then
1878: raise;
1879: end;
1880: if(hr_utility.debug_enabled) then
1881: -- write debug statements
1882: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1883: end if;
1884: return fnd_number.number_to_canonical(ln_step_id);

Line 1882: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1878: raise;
1879: end;
1880: if(hr_utility.debug_enabled) then
1881: -- write debug statements
1882: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1883: end if;
1884: return fnd_number.number_to_canonical(ln_step_id);
1885: EXCEPTION
1886:

Line 1902: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1898: lv_procedure_name constant varchar2(21) := 'isPersonDetailsChange';
1899: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1900: lv_status varchar2(10);
1901: BEGIN
1902: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1903: if(hr_utility.debug_enabled) then
1904: -- write debug statements
1905: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1906: end if;

Line 1903: if(hr_utility.debug_enabled) then

1899: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1900: lv_status varchar2(10);
1901: BEGIN
1902: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1903: if(hr_utility.debug_enabled) then
1904: -- write debug statements
1905: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1906: end if;
1907:

Line 1905: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1901: BEGIN
1902: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1903: if(hr_utility.debug_enabled) then
1904: -- write debug statements
1905: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1906: end if;
1907:
1908: ln_step_id := get_basic_details_step_id(p_transaction_id);
1909:

Line 1916: if(hr_utility.debug_enabled) then

1912: else
1913: lv_status := ame_util.booleanAttributeFalse;
1914: end if;
1915:
1916: if(hr_utility.debug_enabled) then
1917: -- write debug statements
1918: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1919: end if;
1920: return lv_status;

Line 1918: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1914: end if;
1915:
1916: if(hr_utility.debug_enabled) then
1917: -- write debug statements
1918: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1919: end if;
1920: return lv_status;
1921: EXCEPTION
1922:

Line 1939: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1935: -- local variables
1936: lv_procedure_name constant varchar2(26) := 'get_person_address_step_id';
1937: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1938: BEGIN
1939: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1940: if(hr_utility.debug_enabled) then
1941: -- write debug statements
1942: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1943: end if;

Line 1940: if(hr_utility.debug_enabled) then

1936: lv_procedure_name constant varchar2(26) := 'get_person_address_step_id';
1937: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1938: BEGIN
1939: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1940: if(hr_utility.debug_enabled) then
1941: -- write debug statements
1942: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1943: end if;
1944: begin

Line 1942: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1938: BEGIN
1939: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1940: if(hr_utility.debug_enabled) then
1941: -- write debug statements
1942: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1943: end if;
1944: begin
1945: select transaction_step_id
1946: into ln_step_id

Line 1956: if(hr_utility.debug_enabled) then

1952: return null;
1953: when others then
1954: raise;
1955: end;
1956: if(hr_utility.debug_enabled) then
1957: -- write debug statements
1958: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1959: end if;
1960: return fnd_number.number_to_canonical(ln_step_id);

Line 1958: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1954: raise;
1955: end;
1956: if(hr_utility.debug_enabled) then
1957: -- write debug statements
1958: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1959: end if;
1960: return fnd_number.number_to_canonical(ln_step_id);
1961: EXCEPTION
1962:

Line 1978: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

1974: lv_procedure_name constant varchar2(21) := 'isPersonAddressChange';
1975: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1976: lv_status varchar2(10);
1977: BEGIN
1978: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1979: if(hr_utility.debug_enabled) then
1980: -- write debug statements
1981: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1982: end if;

Line 1979: if(hr_utility.debug_enabled) then

1975: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
1976: lv_status varchar2(10);
1977: BEGIN
1978: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1979: if(hr_utility.debug_enabled) then
1980: -- write debug statements
1981: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1982: end if;
1983:

Line 1981: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

1977: BEGIN
1978: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
1979: if(hr_utility.debug_enabled) then
1980: -- write debug statements
1981: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
1982: end if;
1983:
1984: ln_step_id := get_person_address_step_id(p_transaction_id);
1985:

Line 1992: if(hr_utility.debug_enabled) then

1988: else
1989: lv_status := ame_util.booleanAttributeFalse;
1990: end if;
1991:
1992: if(hr_utility.debug_enabled) then
1993: -- write debug statements
1994: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1995: end if;
1996: return lv_status;

Line 1994: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

1990: end if;
1991:
1992: if(hr_utility.debug_enabled) then
1993: -- write debug statements
1994: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
1995: end if;
1996: return lv_status;
1997: EXCEPTION
1998:

Line 2013: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

2009: -- local variables
2010: lv_procedure_name constant varchar2(30) := 'get_person_contact_step_id';
2011: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2012: BEGIN
2013: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2014: if(hr_utility.debug_enabled) then
2015: -- write debug statements
2016: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2017: end if;

Line 2014: if(hr_utility.debug_enabled) then

2010: lv_procedure_name constant varchar2(30) := 'get_person_contact_step_id';
2011: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2012: BEGIN
2013: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2014: if(hr_utility.debug_enabled) then
2015: -- write debug statements
2016: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2017: end if;
2018: begin

Line 2016: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

2012: BEGIN
2013: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2014: if(hr_utility.debug_enabled) then
2015: -- write debug statements
2016: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2017: end if;
2018: begin
2019: select transaction_step_id
2020: into ln_step_id

Line 2033: if(hr_utility.debug_enabled) then

2029: return null;
2030: when others then
2031: raise;
2032: end;
2033: if(hr_utility.debug_enabled) then
2034: -- write debug statements
2035: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2036: end if;
2037: return fnd_number.number_to_canonical(ln_step_id);

Line 2035: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

2031: raise;
2032: end;
2033: if(hr_utility.debug_enabled) then
2034: -- write debug statements
2035: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2036: end if;
2037: return fnd_number.number_to_canonical(ln_step_id);
2038: EXCEPTION
2039:

Line 2055: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

2051: lv_procedure_name constant varchar2(21) := 'isPersonAddressChange';
2052: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2053: lv_status varchar2(10);
2054: BEGIN
2055: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2056: if(hr_utility.debug_enabled) then
2057: -- write debug statements
2058: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2059: end if;

Line 2056: if(hr_utility.debug_enabled) then

2052: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2053: lv_status varchar2(10);
2054: BEGIN
2055: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2056: if(hr_utility.debug_enabled) then
2057: -- write debug statements
2058: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2059: end if;
2060:

Line 2058: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

2054: BEGIN
2055: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2056: if(hr_utility.debug_enabled) then
2057: -- write debug statements
2058: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2059: end if;
2060:
2061: ln_step_id := get_person_contact_step_id(p_transaction_id);
2062:

Line 2069: if(hr_utility.debug_enabled) then

2065: else
2066: lv_status := ame_util.booleanAttributeFalse;
2067: end if;
2068:
2069: if(hr_utility.debug_enabled) then
2070: -- write debug statements
2071: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2072: end if;
2073: return lv_status;

Line 2071: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

2067: end if;
2068:
2069: if(hr_utility.debug_enabled) then
2070: -- write debug statements
2071: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2072: end if;
2073: return lv_status;
2074: EXCEPTION
2075:

Line 2091: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

2087: -- local variables
2088: lv_procedure_name constant varchar2(16) := 'get_caed_step_id';
2089: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2090: BEGIN
2091: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2092: if(hr_utility.debug_enabled) then
2093: -- write debug statements
2094: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2095: end if;

Line 2092: if(hr_utility.debug_enabled) then

2088: lv_procedure_name constant varchar2(16) := 'get_caed_step_id';
2089: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2090: BEGIN
2091: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2092: if(hr_utility.debug_enabled) then
2093: -- write debug statements
2094: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2095: end if;
2096: begin

Line 2094: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

2090: BEGIN
2091: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2092: if(hr_utility.debug_enabled) then
2093: -- write debug statements
2094: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2095: end if;
2096: begin
2097: select transaction_step_id
2098: into ln_step_id

Line 2108: if(hr_utility.debug_enabled) then

2104: return null;
2105: when others then
2106: raise;
2107: end;
2108: if(hr_utility.debug_enabled) then
2109: -- write debug statements
2110: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2111: end if;
2112: return fnd_number.number_to_canonical(ln_step_id);

Line 2110: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

2106: raise;
2107: end;
2108: if(hr_utility.debug_enabled) then
2109: -- write debug statements
2110: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2111: end if;
2112: return fnd_number.number_to_canonical(ln_step_id);
2113: EXCEPTION
2114:

Line 2130: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

2126: lv_procedure_name constant varchar2(20) := 'isReleaseInformation';
2127: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2128: lv_status varchar2(10);
2129: BEGIN
2130: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2131: if(hr_utility.debug_enabled) then
2132: -- write debug statements
2133: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2134: end if;

Line 2131: if(hr_utility.debug_enabled) then

2127: ln_step_id hr_api_transaction_steps.transaction_step_id%type;
2128: lv_status varchar2(10);
2129: BEGIN
2130: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2131: if(hr_utility.debug_enabled) then
2132: -- write debug statements
2133: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2134: end if;
2135:

Line 2133: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

2129: BEGIN
2130: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2131: if(hr_utility.debug_enabled) then
2132: -- write debug statements
2133: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2134: end if;
2135:
2136: ln_step_id := get_caed_step_id(p_transaction_id);
2137:

Line 2144: if(hr_utility.debug_enabled) then

2140: else
2141: lv_status := ame_util.booleanAttributeFalse;
2142: end if;
2143:
2144: if(hr_utility.debug_enabled) then
2145: -- write debug statements
2146: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2147: end if;
2148: return lv_status;

Line 2146: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

2142: end if;
2143:
2144: if(hr_utility.debug_enabled) then
2145: -- write debug statements
2146: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2147: end if;
2148: return lv_status;
2149: EXCEPTION
2150:

Line 2170: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

2166: lv_item_type varchar2(50);
2167: lv_item_key varchar2(100);
2168: ld_effective_date date;
2169: BEGIN
2170: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2171: if(hr_utility.debug_enabled) then
2172: -- write debug statements
2173: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2174: end if;

Line 2171: if(hr_utility.debug_enabled) then

2167: lv_item_key varchar2(100);
2168: ld_effective_date date;
2169: BEGIN
2170: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2171: if(hr_utility.debug_enabled) then
2172: -- write debug statements
2173: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2174: end if;
2175:

Line 2173: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

2169: BEGIN
2170: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2171: if(hr_utility.debug_enabled) then
2172: -- write debug statements
2173: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2174: end if;
2175:
2176: ln_step_id := get_assignment_step_id(p_transaction_id);
2177: if(ln_step_id is not null) then

Line 2184: if(hr_utility.debug_enabled) then

2180: ,p_name => 'P_PAY_BASIS_ID');
2181:
2182: end if;
2183:
2184: if(hr_utility.debug_enabled) then
2185: -- write debug statements
2186: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2187: end if;
2188: return fnd_number.number_to_canonical(ln_pay_basis_id);

Line 2186: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

2182: end if;
2183:
2184: if(hr_utility.debug_enabled) then
2185: -- write debug statements
2186: hr_utility.set_location('Leaving'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2187: end if;
2188: return fnd_number.number_to_canonical(ln_pay_basis_id);
2189: EXCEPTION
2190:

Line 2237: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);

2233: and effective_end_date
2234: AND assignment_type = 'E';
2235:
2236: BEGIN
2237: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2238: if(hr_utility.debug_enabled) then
2239: -- write debug statements
2240: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2241: end if;

Line 2238: if(hr_utility.debug_enabled) then

2234: AND assignment_type = 'E';
2235:
2236: BEGIN
2237: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2238: if(hr_utility.debug_enabled) then
2239: -- write debug statements
2240: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2241: end if;
2242:

Line 2240: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);

2236: BEGIN
2237: hr_utility.set_location(g_package||'.'||lv_procedure_name,1);
2238: if(hr_utility.debug_enabled) then
2239: -- write debug statements
2240: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 2);
2241: end if;
2242:
2243: -- check if this transaction has assignment step
2244: if(isAssignmentChange(p_transaction_id)=ame_util.booleanAttributeTrue) then

Line 2300: if(hr_utility.debug_enabled) then

2296: else
2297: lv_status := ame_util.booleanAttributeFalse;
2298: end if;
2299:
2300: if(hr_utility.debug_enabled) then
2301: -- write debug statements
2302: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2303: end if;
2304:

Line 2302: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);

2298: end if;
2299:
2300: if(hr_utility.debug_enabled) then
2301: -- write debug statements
2302: hr_utility.set_location('Entered'||lv_procedure_name||'with transaction_id:'||p_transaction_id, 10);
2303: end if;
2304:
2305: return lv_status;
2306:

Line 2345: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

2341: and pps.position_structure_id = ppsv.position_structure_id(+)
2342: and trunc(sysdate) between ppsv.date_from(+) and nvl(ppsv.date_to(+),sysdate);
2343: begin
2344: if g_debug then
2345: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
2346: end if;
2347:
2348: open requestorPosId;
2349: fetch requestorPosId into ln_position_id;

Line 2356: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);

2352: end if;
2353: close requestorPosId;
2354:
2355: if (g_debug ) then
2356: hr_utility.set_location('Leaving:'|| g_package||'.'||c_proc, 10);
2357: end if;
2358:
2359: return ln_position_id;
2360:

Line 2365: hr_utility.set_location('Error in getRequestorPositionId SQLERRM' ||' '||to_char(SQLCODE),20);

2361: exception
2362: when others then
2363:
2364: if g_debug then
2365: hr_utility.set_location('Error in getRequestorPositionId SQLERRM' ||' '||to_char(SQLCODE),20);
2366: end if;
2367: -- close the cursor if open
2368: if(requestorPosId%isopen) then
2369: close requestorPosId;