DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE_EIN dependencies on HR_UTILITY

Line 4: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY PAY_DK_ARCHIVE_EIN AS
2: /* $Header: pydkeina.pkb 120.1.12010000.2 2008/10/14 14:37:00 pvelugul ship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5: g_package VARCHAR2(33) := ' PAY_DK_ARCHIVE_EIN.';
6: g_payroll_action_id NUMBER ;
7: g_le_assignment_action_id NUMBER ;
8: g_business_group_id NUMBER;

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

64: l_proc VARCHAR2(40):= g_package||' get parameter ';
65: BEGIN
66: --
67: IF g_debug THEN
68: hr_utility.set_location(' Entering Function GET_PARAMETER',10);
69: END IF;
70: l_start_pos := instr(' '||p_parameter_string,l_delimiter||p_token||'=');
71: --
72: IF l_start_pos = 0 THEN

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

90: END IF;
91: END IF;
92: --
93: IF g_debug THEN
94: hr_utility.set_location(' Leaving Function GET_PARAMETER',20);
95: END IF;
96:
97: RETURN l_parameter;
98:

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

137: ,p_business_group_id;
138: CLOSE csr_parameter_info;
139: --
140: IF g_debug THEN
141: hr_utility.set_location(' Leaving Procedure GET_ALL_PARAMETERS',30);
142: END IF;
143:
144: END GET_ALL_PARAMETERS;
145:

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

223:
224: -- fnd_file.put_line(fnd_file.log,'Range Code 1');
225:
226: IF g_debug THEN
227: hr_utility.set_location(' Entering Procedure RANGE_CODE',40);
228: END IF;
229:
230: p_sql := 'SELECT DISTINCT person_id FROM per_people_f ppf,pay_payroll_actions ppa WHERE ppa.payroll_action_id = :payroll_action_id AND ppa.business_group_id = ppf.business_group_id ORDER BY ppf.person_id';
231:

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

265: -- fnd_file.put_line(fnd_file.log,'Range Code 6');
266:
267: IF l_count < 1 then
268:
269: hr_utility.set_location('Entered Procedure GETDATA',10);
270:
271:
272: -- fnd_file.put_line(fnd_file.log,'g_legal_employer_id : '||g_legal_employer_id);
273: -- fnd_file.put_line(fnd_file.log,'l_business_group_id : '||l_business_group_id);

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

548:
549: END IF;
550:
551: IF g_debug THEN
552: hr_utility.set_location(' Leaving Procedure RANGE_CODE',50);
553: END IF;
554:
555: EXCEPTION
556: WHEN others THEN

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

554:
555: EXCEPTION
556: WHEN others THEN
557: IF g_debug THEN
558: hr_utility.set_location('error raised assignment_action_code ',5);
559: END if;
560: RAISE;
561: END RANGE_CODE;
562:

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

638: if(g_flag=0) then
639: -- fnd_file.put_line(fnd_file.log,'ASSIGNMENT_ACTION_CODE 1');
640:
641: IF g_debug THEN
642: hr_utility.set_location(' Entering Procedure ASSIGNMENT_ACTION_CODE',60);
643: END IF;
644:
645: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(
646: p_payroll_action_id

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

696: l_prev_person_id := rec_prepaid_assignments.person_id;
697: END LOOP;
698:
699: IF g_debug THEN
700: hr_utility.set_location(' Leaving Procedure ASSIGNMENT_ACTION_CODE',70);
701: END IF;
702: end if; -- end g_flag condition.
703:
704: EXCEPTION

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

703:
704: EXCEPTION
705: WHEN others THEN
706: IF g_debug THEN
707: hr_utility.set_location('error raised assignment_action_code ',5);
708: END if;
709: RAISE;
710: END ASSIGNMENT_ACTION_CODE;
711:

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

715: IS
716:
717: BEGIN
718: IF g_debug THEN
719: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
720: END IF;
721: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
722: IF g_debug THEN
723: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);

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

719: hr_utility.set_location(' Entering Procedure INITIALIZATION_CODE',80);
720: END IF;
721: -- fnd_file.put_line(fnd_file.log,'INITIALIZATION_CODE 1');
722: IF g_debug THEN
723: hr_utility.set_location(' Leaving Procedure INITIALIZATION_CODE',90);
724: END IF;
725:
726: EXCEPTION
727: WHEN others THEN

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

725:
726: EXCEPTION
727: WHEN others THEN
728: IF g_debug THEN
729: hr_utility.set_location('error raised initialization code ',5);
730: END if;
731: RAISE;
732: END INITIALIZATION_CODE;
733:

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

1079: WHERE assignment_action_id=p_assignment_action_id;
1080: END;
1081:
1082: IF g_debug THEN
1083: hr_utility.set_location(' Entering Procedure ARCHIVE_CODE',380);
1084: END IF;
1085:
1086: /* Fetching report parameters */
1087: PAY_DK_ARCHIVE_EIN.GET_ALL_PARAMETERS(

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

1557: end if; -- g_flag
1558:
1559: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16');
1560: IF g_debug THEN
1561: hr_utility.set_location(' Leaving Procedure ARCHIVE_CODE',390);
1562: END IF;
1563:
1564: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE END');
1565:

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

1565:
1566: EXCEPTION
1567: WHEN others THEN
1568: IF g_debug THEN
1569: hr_utility.set_location('error raised in archive code ',5);
1570: END if;
1571: RAISE;
1572: END ARCHIVE_CODE;
1573:

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

1681:
1682: end if; -- g_flag
1683: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 7');
1684: IF g_debug THEN
1685: hr_utility.set_location(' Leaving Procedure DEINITIALIZATION_CODE',390);
1686: END IF;
1687:
1688: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 8');
1689: EXCEPTION

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

1688: -- fnd_file.put_line(fnd_file.log,'DE-INITIALIZATION CODE 8');
1689: EXCEPTION
1690: WHEN others THEN
1691: IF g_debug THEN
1692: hr_utility.set_location('error raised in DEINITIALIZATION_CODE ',5);
1693: END if;
1694: RAISE;
1695: END;
1696: