DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_DPSA dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_FI_ARCHIVE_DPSA AS
2: /* $Header: pyfidpsa.pkb 120.8 2010/10/27 14:27:05 vijranga ship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_FI_ARCHIVE_DPSA.';
6: g_payroll_action_id NUMBER ;
7: g_le_assignment_action_id NUMBER ;
8: g_lu_assignment_action_id NUMBER ;

Line 32: hr_utility.set_location(' Entering Function GET_PARAMETER',10);

28: l_proc VARCHAR2(40):= g_package||' get parameter ';
29: BEGIN
30: --
31: IF g_debug THEN
32: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
33: END IF;
34: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
35: --
36: IF l_start_pos = 0 THEN

Line 58: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);

54: END IF;
55: END IF;
56: --
57: IF g_debug THEN
58: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
59: END IF;
60:
61: RETURN l_parameter;
62:

Line 109: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);

105: ,p_business_group_id;
106: CLOSE csr_parameter_info;
107: --
108: IF g_debug THEN
109: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
110: END IF;
111:
112: END GET_ALL_PARAMETERS;
113:

Line 218: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);

214:
215: -- fnd_file.put_line(fnd_file.log,'Range Code 1');
216:
217: IF g_debug THEN
218: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
219: END IF;
220:
221: p_sql := 'SELECT DISTINCT person_id
222: FROM per_people_f ppf

Line 271: hr_utility.set_location('Entered Procedure GETDATA',10);

267: -- fnd_file.put_line(fnd_file.log,'Range Code 6');
268:
269: IF l_count < 1 then
270:
271: hr_utility.set_location('Entered Procedure GETDATA',10);
272:
273: -- fnd_file.put_line(fnd_file.log,'Range Code 7');
274:
275: OPEN csr_Legal_Emp_Details(g_legal_employer_id);

Line 290: hr_utility.set_location('Calculation for Local Unit',40);

286: -- fnd_file.put_line(fnd_file.log,'Range Code 9');
287:
288: g_emp_type:='LU' ;
289: l_emp_id:=g_local_unit_id;
290: hr_utility.set_location('Calculation for Local Unit',40);
291:
292: /* Pick up the details belonging to Local Unit */
293:
294: OPEN csr_Local_Unit_Details( g_local_unit_id);

Line 305: hr_utility.set_location('Pick up the details belonging to Local Unit',60);

301: OPEN csr_Local_Unit_Details( g_local_unit_id);
302: FETCH csr_Local_Unit_Details INTO rg_Local_Unit_Details;
303: CLOSE csr_Local_Unit_Details;
304:
305: hr_utility.set_location('Pick up the details belonging to Local Unit',60);
306:
307: /* Pick up the contact details belonging to Local Unit*/
308:
309: OPEN csr_Local_Unit_contact( g_local_unit_id);

Line 316: hr_utility.set_location('Pick up the contact details belonging to Local Unit',70);

312:
313: l_contact_person := rg_Local_Unit_contact.contact_person ;
314: l_phone := rg_Local_Unit_contact.phone ;
315:
316: hr_utility.set_location('Pick up the contact details belonging to Local Unit',70);
317: -- fnd_file.put_line(fnd_file.log,'Range Code 10');
318: ELSE
319: -- fnd_file.put_line(fnd_file.log,'Range Code 11');
320: g_emp_type:='LE' ;

Line 437: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);

433:
434: END IF;
435:
436: IF g_debug THEN
437: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
438: END IF;
439:
440: EXCEPTION
441: WHEN others THEN

Line 443: hr_utility.set_location('error raised assignment_action_code ',5);

439:
440: EXCEPTION
441: WHEN others THEN
442: IF g_debug THEN
443: hr_utility.set_location('error raised assignment_action_code ',5);
444: END if;
445: RAISE;
446: END RANGE_CODE;
447:

Line 588: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);

584:
585: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 1');
586:
587: IF g_debug THEN
588: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
589: END IF;
590:
591: PAY_FI_ARCHIVE_DPSA.GET_ALL_PARAMETERS(
592: p_payroll_action_id

Line 682: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);

678: END LOOP;
679: END IF;
680:
681: IF g_debug THEN
682: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
683: END IF;
684:
685: EXCEPTION
686: WHEN others THEN

Line 688: hr_utility.set_location('error raised assignment_action_code ',5);

684:
685: EXCEPTION
686: WHEN others THEN
687: IF g_debug THEN
688: hr_utility.set_location('error raised assignment_action_code ',5);
689: END if;
690: RAISE;
691: END ASSIGNMENT_ACTION_CODE;
692:

Line 700: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);

696: IS
697:
698: BEGIN
699: IF g_debug THEN
700: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
701: END IF;
702: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
703: IF g_debug THEN
704: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

Line 704: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

700: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
701: END IF;
702: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
703: IF g_debug THEN
704: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
705: END IF;
706:
707: EXCEPTION
708: WHEN others THEN

Line 710: hr_utility.set_location('error raised initialization code ',5);

706:
707: EXCEPTION
708: WHEN others THEN
709: IF g_debug THEN
710: hr_utility.set_location('error raised initialization code ',5);
711: END if;
712: RAISE;
713: END INITIALIZATION_CODE;
714:

Line 1210: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);

1206: l_month := 0 ;
1207:
1208:
1209: IF g_debug THEN
1210: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
1211: END IF;
1212:
1213: /* Fetching data from the Header record(Employer level) */
1214: OPEN csr_rpt_header(p_assignment_action_id);

Line 3076: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);

3072: END IF;
3073: END IF;
3074: END IF;---ARCHIVE=YES
3075: IF g_debug THEN
3076: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
3077: END IF;
3078:
3079: EXCEPTION
3080: WHEN others THEN

Line 3082: hr_utility.set_location('error raised in archive code ',5);

3078:
3079: EXCEPTION
3080: WHEN others THEN
3081: IF g_debug THEN
3082: hr_utility.set_location('error raised in archive code ',5);
3083: END if;
3084: RAISE;
3085: END ARCHIVE_CODE;
3086:

Line 3264: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',380);

3260: l_tot_631 :=0;
3261: l_tot_670 :=0;
3262:
3263: IF g_debug THEN
3264: hr_utility.set_location(' Entering Procedure DEINITIALIZATION_CODE',380);
3265: END IF;
3266:
3267: /* Fetching data from the Header record(Employer level) */
3268: OPEN csr_prpt_header(p_payroll_action_id);

Line 3619: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',390);

3615:
3616: END IF;---ARCHIVE=YES
3617:
3618: IF g_debug THEN
3619: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',390);
3620: END IF;
3621:
3622: EXCEPTION
3623: WHEN others THEN

Line 3625: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',5);

3621:
3622: EXCEPTION
3623: WHEN others THEN
3624: IF g_debug THEN
3625: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',5);
3626: END if;
3627: RAISE;
3628: END;
3629: