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 797: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 822: if(hr_utility.debug_enabled) then

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

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

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

Line 873: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 895: if(hr_utility.debug_enabled) then

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

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

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

Line 910: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 935: if(hr_utility.debug_enabled) then

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

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

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

Line 949: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 974: if(hr_utility.debug_enabled) then

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

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

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

Line 994: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1023: if(hr_utility.debug_enabled) then

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

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

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

Line 1049: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1073: if(hr_utility.debug_enabled) then

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

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

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

Line 1093: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1118: if(hr_utility.debug_enabled) then

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

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

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

Line 1142: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1168: if(hr_utility.debug_enabled) then

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

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

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

Line 1192: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1219: if(hr_utility.debug_enabled) then

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

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

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

Line 1246: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1270: if(hr_utility.debug_enabled) then

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

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

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

Line 1293: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1316: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1344: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1369: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1404: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1426: if(hr_utility.debug_enabled) then

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

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

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

Line 1438: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1464: if(hr_utility.debug_enabled) then

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

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

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

Line 1487: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1517: if(hr_utility.debug_enabled) then

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

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

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

Line 1573: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1599: if(hr_utility.debug_enabled) then

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

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

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

Line 1626: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1649: if(hr_utility.debug_enabled) then

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

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

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

Line 1662: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1684: if(hr_utility.debug_enabled) then

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

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

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

Line 1690: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1744: if(hr_utility.debug_enabled) then

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

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

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

Line 1751: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1777: if(hr_utility.debug_enabled) then

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

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

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

Line 1803: if(hr_utility.debug_enabled) then

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

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

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

Line 1826: if(hr_utility.debug_enabled) then

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

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

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

Line 1832: if(hr_utility.debug_enabled) then

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

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

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

Line 1843: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1866: if(hr_utility.debug_enabled) then

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

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

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

Line 1882: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1905: if(hr_utility.debug_enabled) then

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

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

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

Line 1918: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1942: if(hr_utility.debug_enabled) then

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

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

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

Line 1958: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 1981: if(hr_utility.debug_enabled) then

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

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

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

Line 1994: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 2016: if(hr_utility.debug_enabled) then

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

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

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

Line 2035: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 2058: if(hr_utility.debug_enabled) then

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

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

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

Line 2071: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 2094: if(hr_utility.debug_enabled) then

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

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

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

Line 2110: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 2133: if(hr_utility.debug_enabled) then

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

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

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

Line 2146: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 2173: if(hr_utility.debug_enabled) then

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

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

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

Line 2186: if(hr_utility.debug_enabled) then

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

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

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

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

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

Line 2240: if(hr_utility.debug_enabled) then

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

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

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

Line 2302: if(hr_utility.debug_enabled) then

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

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

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

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

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

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

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

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

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