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

APPS.PER_IN_PREV_EMPLOYER_LEG_HOOK dependencies on PAY_IN_UTILS

Line 6: g_token_name pay_in_utils.char_tab_type;

2: /* $Header: peinlhpr.pkb 120.3 2007/11/22 10:48:19 sivanara ship $ */
3:
4: g_package VARCHAR2(30);
5: g_debug BOOLEAN;
6: g_token_name pay_in_utils.char_tab_type;
7: g_token_value pay_in_utils.char_tab_type;
8: g_message_name VARCHAR2(30);
9:
10: --

Line 7: g_token_value pay_in_utils.char_tab_type;

3:
4: g_package VARCHAR2(30);
5: g_debug BOOLEAN;
6: g_token_name pay_in_utils.char_tab_type;
7: g_token_value pay_in_utils.char_tab_type;
8: g_message_name VARCHAR2(30);
9:
10: --
11:

Line 50: -- p_token_name OUT pay_in_utils.char_tab_type

46: -- p_pem_information_category IN VARCHAR2 --
47: -- p_pem_information1..30 IN VARCHAR2 --
48: -- p_calling_procedure IN VARCHAR2 --
49: -- OUT : p_message_name OUT VARCHAR2 --
50: -- p_token_name OUT pay_in_utils.char_tab_type
51: -- p_token_value OUT pay_in_utils.char_tab_type
52: --------------------------------------------------------------------------
53: PROCEDURE check_prev_emp_int(
54: p_effective_date IN DATE

Line 51: -- p_token_value OUT pay_in_utils.char_tab_type

47: -- p_pem_information1..30 IN VARCHAR2 --
48: -- p_calling_procedure IN VARCHAR2 --
49: -- OUT : p_message_name OUT VARCHAR2 --
50: -- p_token_name OUT pay_in_utils.char_tab_type
51: -- p_token_value OUT pay_in_utils.char_tab_type
52: --------------------------------------------------------------------------
53: PROCEDURE check_prev_emp_int(
54: p_effective_date IN DATE
55: ,p_previous_employer_id IN NUMBER

Line 93: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type

89: ,p_pem_information29 IN VARCHAR2
90: ,p_pem_information30 IN VARCHAR2
91: ,p_calling_procedure IN VARCHAR2
92: ,p_message_name OUT NOCOPY VARCHAR2
93: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
94: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
95: IS
96: ---------------------------------------------------------------------------
97: --APPLICATION_COLUMN_NAME FORM_LEFT_PROMPT

Line 94: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)

90: ,p_pem_information30 IN VARCHAR2
91: ,p_calling_procedure IN VARCHAR2
92: ,p_message_name OUT NOCOPY VARCHAR2
93: ,p_token_name OUT NOCOPY pay_in_utils.char_tab_type
94: ,p_token_value OUT NOCOPY pay_in_utils.char_tab_type)
95: IS
96: ---------------------------------------------------------------------------
97: --APPLICATION_COLUMN_NAME FORM_LEFT_PROMPT
98: ------------------------------ --------------------------------------------

Line 146: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);

142: BEGIN
143:
144: l_procedure := g_package||'check_prev_emp_int';
145: g_debug := hr_utility.debug_enabled;
146: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
147:
148: p_message_name := 'SUCCESS';
149: pay_in_utils.null_message(p_token_name, p_token_value);
150:

Line 149: pay_in_utils.null_message(p_token_name, p_token_value);

145: g_debug := hr_utility.debug_enabled;
146: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
147:
148: p_message_name := 'SUCCESS';
149: pay_in_utils.null_message(p_token_name, p_token_value);
150:
151: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
152: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
153: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

Line 153: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

149: pay_in_utils.null_message(p_token_name, p_token_value);
150:
151: IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'IN') THEN
152: hr_utility.trace ('IN Legislation not installed. Not performing the validations');
153: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
154: RETURN;
155: END IF;
156:
157: IF g_debug THEN

Line 158: pay_in_utils.trace('******************************','');

154: RETURN;
155: END IF;
156:
157: IF g_debug THEN
158: pay_in_utils.trace('**************************************************','********************');
159: pay_in_utils.trace('p_effective_date ',p_effective_date );
160: pay_in_utils.trace('p_previous_employer_id',p_previous_employer_id);
161: pay_in_utils.trace('p_business_group_id' ,p_business_group_id);
162: pay_in_utils.trace('p_preson_id' ,p_person_id);

Line 159: pay_in_utils.trace('p_effective_date ',p_effective_date );

155: END IF;
156:
157: IF g_debug THEN
158: pay_in_utils.trace('**************************************************','********************');
159: pay_in_utils.trace('p_effective_date ',p_effective_date );
160: pay_in_utils.trace('p_previous_employer_id',p_previous_employer_id);
161: pay_in_utils.trace('p_business_group_id' ,p_business_group_id);
162: pay_in_utils.trace('p_preson_id' ,p_person_id);
163: pay_in_utils.trace('p_start_date ',p_start_date );

Line 160: pay_in_utils.trace('p_previous_employer_id',p_previous_employer_id);

156:
157: IF g_debug THEN
158: pay_in_utils.trace('**************************************************','********************');
159: pay_in_utils.trace('p_effective_date ',p_effective_date );
160: pay_in_utils.trace('p_previous_employer_id',p_previous_employer_id);
161: pay_in_utils.trace('p_business_group_id' ,p_business_group_id);
162: pay_in_utils.trace('p_preson_id' ,p_person_id);
163: pay_in_utils.trace('p_start_date ',p_start_date );
164: pay_in_utils.trace('p_end_date ',p_end_date );

Line 161: pay_in_utils.trace('p_business_group_id' ,p_business_group_id);

157: IF g_debug THEN
158: pay_in_utils.trace('**************************************************','********************');
159: pay_in_utils.trace('p_effective_date ',p_effective_date );
160: pay_in_utils.trace('p_previous_employer_id',p_previous_employer_id);
161: pay_in_utils.trace('p_business_group_id' ,p_business_group_id);
162: pay_in_utils.trace('p_preson_id' ,p_person_id);
163: pay_in_utils.trace('p_start_date ',p_start_date );
164: pay_in_utils.trace('p_end_date ',p_end_date );
165: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);

Line 162: pay_in_utils.trace('p_preson_id' ,p_person_id);

158: pay_in_utils.trace('**************************************************','********************');
159: pay_in_utils.trace('p_effective_date ',p_effective_date );
160: pay_in_utils.trace('p_previous_employer_id',p_previous_employer_id);
161: pay_in_utils.trace('p_business_group_id' ,p_business_group_id);
162: pay_in_utils.trace('p_preson_id' ,p_person_id);
163: pay_in_utils.trace('p_start_date ',p_start_date );
164: pay_in_utils.trace('p_end_date ',p_end_date );
165: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
166: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );

Line 163: pay_in_utils.trace('p_start_date ',p_start_date );

159: pay_in_utils.trace('p_effective_date ',p_effective_date );
160: pay_in_utils.trace('p_previous_employer_id',p_previous_employer_id);
161: pay_in_utils.trace('p_business_group_id' ,p_business_group_id);
162: pay_in_utils.trace('p_preson_id' ,p_person_id);
163: pay_in_utils.trace('p_start_date ',p_start_date );
164: pay_in_utils.trace('p_end_date ',p_end_date );
165: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
166: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
167: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );

Line 164: pay_in_utils.trace('p_end_date ',p_end_date );

160: pay_in_utils.trace('p_previous_employer_id',p_previous_employer_id);
161: pay_in_utils.trace('p_business_group_id' ,p_business_group_id);
162: pay_in_utils.trace('p_preson_id' ,p_person_id);
163: pay_in_utils.trace('p_start_date ',p_start_date );
164: pay_in_utils.trace('p_end_date ',p_end_date );
165: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
166: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
167: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
168: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );

Line 165: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);

161: pay_in_utils.trace('p_business_group_id' ,p_business_group_id);
162: pay_in_utils.trace('p_preson_id' ,p_person_id);
163: pay_in_utils.trace('p_start_date ',p_start_date );
164: pay_in_utils.trace('p_end_date ',p_end_date );
165: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
166: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
167: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
168: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
169: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );

Line 166: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );

162: pay_in_utils.trace('p_preson_id' ,p_person_id);
163: pay_in_utils.trace('p_start_date ',p_start_date );
164: pay_in_utils.trace('p_end_date ',p_end_date );
165: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
166: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
167: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
168: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
169: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
170: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );

Line 167: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );

163: pay_in_utils.trace('p_start_date ',p_start_date );
164: pay_in_utils.trace('p_end_date ',p_end_date );
165: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
166: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
167: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
168: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
169: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
170: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
171: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );

Line 168: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );

164: pay_in_utils.trace('p_end_date ',p_end_date );
165: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
166: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
167: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
168: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
169: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
170: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
171: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
172: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );

Line 169: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );

165: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
166: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
167: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
168: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
169: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
170: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
171: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
172: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
173: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );

Line 170: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );

166: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
167: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
168: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
169: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
170: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
171: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
172: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
173: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
174: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );

Line 171: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );

167: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
168: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
169: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
170: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
171: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
172: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
173: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
174: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
175: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );

Line 172: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );

168: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
169: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
170: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
171: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
172: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
173: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
174: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
175: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
176: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );

Line 173: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );

169: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
170: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
171: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
172: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
173: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
174: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
175: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
176: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
177: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );

Line 174: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );

170: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
171: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
172: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
173: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
174: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
175: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
176: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
177: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
178: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );

Line 175: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );

171: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
172: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
173: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
174: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
175: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
176: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
177: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
178: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
179: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );

Line 176: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );

172: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
173: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
174: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
175: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
176: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
177: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
178: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
179: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
180: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );

Line 177: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );

173: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
174: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
175: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
176: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
177: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
178: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
179: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
180: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
181: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );

Line 178: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );

174: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
175: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
176: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
177: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
178: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
179: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
180: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
181: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
182: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );

Line 179: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );

175: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
176: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
177: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
178: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
179: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
180: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
181: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
182: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
183: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );

Line 180: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );

176: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
177: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
178: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
179: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
180: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
181: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
182: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
183: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
184: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );

Line 181: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );

177: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
178: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
179: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
180: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
181: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
182: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
183: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
184: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
185: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );

Line 182: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );

178: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
179: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
180: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
181: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
182: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
183: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
184: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
185: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
186: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );

Line 183: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );

179: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
180: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
181: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
182: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
183: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
184: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
185: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
186: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
187: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );

Line 184: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );

180: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
181: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
182: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
183: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
184: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
185: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
186: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
187: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
188: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );

Line 185: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );

181: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
182: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
183: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
184: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
185: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
186: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
187: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
188: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
189: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );

Line 186: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );

182: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
183: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
184: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
185: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
186: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
187: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
188: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
189: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
190: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );

Line 187: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );

183: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
184: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
185: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
186: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
187: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
188: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
189: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
190: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
191: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );

Line 188: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );

184: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
185: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
186: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
187: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
188: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
189: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
190: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
191: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
192: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );

Line 189: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );

185: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
186: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
187: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
188: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
189: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
190: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
191: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
192: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
193: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );

Line 190: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );

186: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
187: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
188: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
189: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
190: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
191: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
192: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
193: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
194: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );

Line 191: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );

187: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
188: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
189: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
190: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
191: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
192: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
193: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
194: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
195: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );

Line 192: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );

188: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
189: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
190: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
191: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
192: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
193: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
194: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
195: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
196: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );

Line 193: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );

189: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
190: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
191: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
192: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
193: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
194: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
195: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
196: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
197: pay_in_utils.trace('p_message_name ',p_message_name );

Line 194: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );

190: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
191: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
192: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
193: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
194: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
195: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
196: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
197: pay_in_utils.trace('p_message_name ',p_message_name );
198: pay_in_utils.trace('**************************************************','********************');

Line 195: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );

191: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
192: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
193: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
194: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
195: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
196: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
197: pay_in_utils.trace('p_message_name ',p_message_name );
198: pay_in_utils.trace('**************************************************','********************');
199: END IF;

Line 196: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );

192: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
193: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
194: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
195: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
196: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
197: pay_in_utils.trace('p_message_name ',p_message_name );
198: pay_in_utils.trace('**************************************************','********************');
199: END IF;
200:

Line 197: pay_in_utils.trace('p_message_name ',p_message_name );

193: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
194: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
195: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
196: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
197: pay_in_utils.trace('p_message_name ',p_message_name );
198: pay_in_utils.trace('**************************************************','********************');
199: END IF;
200:
201: IF p_pem_information_category <> 'IN' THEN

Line 198: pay_in_utils.trace('******************************','');

194: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
195: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
196: pay_in_utils.trace('p_calling_procedure ',p_calling_procedure );
197: pay_in_utils.trace('p_message_name ',p_message_name );
198: pay_in_utils.trace('**************************************************','********************');
199: END IF;
200:
201: IF p_pem_information_category <> 'IN' THEN
202: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

Line 202: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);

198: pay_in_utils.trace('**************************************************','********************');
199: END IF;
200:
201: IF p_pem_information_category <> 'IN' THEN
202: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
203: RETURN;
204: END IF;
205:
206: --

Line 214: pay_in_utils.set_location(g_debug,l_procedure,20);

210: -- 2. Ensure that Gross Earnings are entered before any other
211: -- current tax year information
212: -- 3. Prof Tax value should not be greater than IN_PTAX_CEILING
213: --
214: pay_in_utils.set_location(g_debug,l_procedure,20);
215: --
216: -- 1. End date should not be null for employee
217: --
218:

Line 223: pay_in_utils.trace('l_person_type ',l_person_type);

219: OPEN c_person_type;
220: FETCH c_person_type INTO l_person_type;
221: CLOSE c_person_type;
222:
223: pay_in_utils.trace('l_person_type ',l_person_type);
224:
225:
226: IF p_end_date IS NULL AND l_person_type = 'X' THEN
227: p_message_name := 'PER_IN_END_DATE_NOT_ENTERED';

Line 230: pay_in_utils.trace('******************************','');

226: IF p_end_date IS NULL AND l_person_type = 'X' THEN
227: p_message_name := 'PER_IN_END_DATE_NOT_ENTERED';
228:
229: IF g_debug THEN
230: pay_in_utils.trace('**************************************************','********************');
231: pay_in_utils.trace('p_message_name ',p_message_name);
232: pay_in_utils.trace('**************************************************','********************');
233: END IF;
234:

Line 231: pay_in_utils.trace('p_message_name ',p_message_name);

227: p_message_name := 'PER_IN_END_DATE_NOT_ENTERED';
228:
229: IF g_debug THEN
230: pay_in_utils.trace('**************************************************','********************');
231: pay_in_utils.trace('p_message_name ',p_message_name);
232: pay_in_utils.trace('**************************************************','********************');
233: END IF;
234:
235: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

Line 232: pay_in_utils.trace('******************************','');

228:
229: IF g_debug THEN
230: pay_in_utils.trace('**************************************************','********************');
231: pay_in_utils.trace('p_message_name ',p_message_name);
232: pay_in_utils.trace('**************************************************','********************');
233: END IF;
234:
235: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
236: RETURN;

Line 235: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);

231: pay_in_utils.trace('p_message_name ',p_message_name);
232: pay_in_utils.trace('**************************************************','********************');
233: END IF;
234:
235: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,30);
236: RETURN;
237: END IF;
238:
239: IF p_pem_information6 IS NULL AND

Line 247: pay_in_utils.trace('******************************','');

243: THEN
244: p_message_name := 'PER_IN_MISSING_ER';
245:
246: IF g_debug THEN
247: pay_in_utils.trace('**************************************************','********************');
248: pay_in_utils.trace('p_message_name ',p_message_name);
249: pay_in_utils.trace('**************************************************','********************');
250: END IF;
251:

Line 248: pay_in_utils.trace('p_message_name ',p_message_name);

244: p_message_name := 'PER_IN_MISSING_ER';
245:
246: IF g_debug THEN
247: pay_in_utils.trace('**************************************************','********************');
248: pay_in_utils.trace('p_message_name ',p_message_name);
249: pay_in_utils.trace('**************************************************','********************');
250: END IF;
251:
252: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

Line 249: pay_in_utils.trace('******************************','');

245:
246: IF g_debug THEN
247: pay_in_utils.trace('**************************************************','********************');
248: pay_in_utils.trace('p_message_name ',p_message_name);
249: pay_in_utils.trace('**************************************************','********************');
250: END IF;
251:
252: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
253: RETURN;

Line 252: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

248: pay_in_utils.trace('p_message_name ',p_message_name);
249: pay_in_utils.trace('**************************************************','********************');
250: END IF;
251:
252: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
253: RETURN;
254: END IF;
255:
256: pay_in_utils.set_location(g_debug,l_procedure,40);

Line 256: pay_in_utils.set_location(g_debug,l_procedure,40);

252: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
253: RETURN;
254: END IF;
255:
256: pay_in_utils.set_location(g_debug,l_procedure,40);
257:
258: IF g_debug THEN
259: pay_in_utils.trace ('Gross Earnings for Current Tax Year :',p_pem_information13);
260: pay_in_utils.trace ('Recognized PF Deduction for Current Tax Year :',p_pem_information14);

Line 259: pay_in_utils.trace ('Gross Earnings for Current Tax Year :',p_pem_information13);

255:
256: pay_in_utils.set_location(g_debug,l_procedure,40);
257:
258: IF g_debug THEN
259: pay_in_utils.trace ('Gross Earnings for Current Tax Year :',p_pem_information13);
260: pay_in_utils.trace ('Recognized PF Deduction for Current Tax Year :',p_pem_information14);
261: pay_in_utils.trace ('Entertainment Allowance for Current Tax Year :',p_pem_information15);
262: pay_in_utils.trace ('Professional Tax Paid in Current Tax Year :',p_pem_information16);
263: pay_in_utils.trace ('TDS Deducted in Current Tax Year :',p_pem_information17);

Line 260: pay_in_utils.trace ('Recognized PF Deduction for Current Tax Year :',p_pem_information14);

256: pay_in_utils.set_location(g_debug,l_procedure,40);
257:
258: IF g_debug THEN
259: pay_in_utils.trace ('Gross Earnings for Current Tax Year :',p_pem_information13);
260: pay_in_utils.trace ('Recognized PF Deduction for Current Tax Year :',p_pem_information14);
261: pay_in_utils.trace ('Entertainment Allowance for Current Tax Year :',p_pem_information15);
262: pay_in_utils.trace ('Professional Tax Paid in Current Tax Year :',p_pem_information16);
263: pay_in_utils.trace ('TDS Deducted in Current Tax Year :',p_pem_information17);
264: pay_in_utils.trace ('Superannuation for Current Tax Year :',p_pem_information18);

Line 261: pay_in_utils.trace ('Entertainment Allowance for Current Tax Year :',p_pem_information15);

257:
258: IF g_debug THEN
259: pay_in_utils.trace ('Gross Earnings for Current Tax Year :',p_pem_information13);
260: pay_in_utils.trace ('Recognized PF Deduction for Current Tax Year :',p_pem_information14);
261: pay_in_utils.trace ('Entertainment Allowance for Current Tax Year :',p_pem_information15);
262: pay_in_utils.trace ('Professional Tax Paid in Current Tax Year :',p_pem_information16);
263: pay_in_utils.trace ('TDS Deducted in Current Tax Year :',p_pem_information17);
264: pay_in_utils.trace ('Superannuation for Current Tax Year :',p_pem_information18);
265: END IF;

Line 262: pay_in_utils.trace ('Professional Tax Paid in Current Tax Year :',p_pem_information16);

258: IF g_debug THEN
259: pay_in_utils.trace ('Gross Earnings for Current Tax Year :',p_pem_information13);
260: pay_in_utils.trace ('Recognized PF Deduction for Current Tax Year :',p_pem_information14);
261: pay_in_utils.trace ('Entertainment Allowance for Current Tax Year :',p_pem_information15);
262: pay_in_utils.trace ('Professional Tax Paid in Current Tax Year :',p_pem_information16);
263: pay_in_utils.trace ('TDS Deducted in Current Tax Year :',p_pem_information17);
264: pay_in_utils.trace ('Superannuation for Current Tax Year :',p_pem_information18);
265: END IF;
266: --

Line 263: pay_in_utils.trace ('TDS Deducted in Current Tax Year :',p_pem_information17);

259: pay_in_utils.trace ('Gross Earnings for Current Tax Year :',p_pem_information13);
260: pay_in_utils.trace ('Recognized PF Deduction for Current Tax Year :',p_pem_information14);
261: pay_in_utils.trace ('Entertainment Allowance for Current Tax Year :',p_pem_information15);
262: pay_in_utils.trace ('Professional Tax Paid in Current Tax Year :',p_pem_information16);
263: pay_in_utils.trace ('TDS Deducted in Current Tax Year :',p_pem_information17);
264: pay_in_utils.trace ('Superannuation for Current Tax Year :',p_pem_information18);
265: END IF;
266: --
267: -- 2. Ensure that Gross Earnings are entered before any other

Line 264: pay_in_utils.trace ('Superannuation for Current Tax Year :',p_pem_information18);

260: pay_in_utils.trace ('Recognized PF Deduction for Current Tax Year :',p_pem_information14);
261: pay_in_utils.trace ('Entertainment Allowance for Current Tax Year :',p_pem_information15);
262: pay_in_utils.trace ('Professional Tax Paid in Current Tax Year :',p_pem_information16);
263: pay_in_utils.trace ('TDS Deducted in Current Tax Year :',p_pem_information17);
264: pay_in_utils.trace ('Superannuation for Current Tax Year :',p_pem_information18);
265: END IF;
266: --
267: -- 2. Ensure that Gross Earnings are entered before any other
268: -- current tax year information

Line 280: pay_in_utils.trace('******************************','');

276: THEN
277: p_message_name := 'PER_IN_MISSING_EARNINGS';
278:
279: IF g_debug THEN
280: pay_in_utils.trace('**************************************************','********************');
281: pay_in_utils.trace('p_message_name ',p_message_name);
282: pay_in_utils.trace('**************************************************','********************');
283: END IF;
284:

Line 281: pay_in_utils.trace('p_message_name ',p_message_name);

277: p_message_name := 'PER_IN_MISSING_EARNINGS';
278:
279: IF g_debug THEN
280: pay_in_utils.trace('**************************************************','********************');
281: pay_in_utils.trace('p_message_name ',p_message_name);
282: pay_in_utils.trace('**************************************************','********************');
283: END IF;
284:
285: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

Line 282: pay_in_utils.trace('******************************','');

278:
279: IF g_debug THEN
280: pay_in_utils.trace('**************************************************','********************');
281: pay_in_utils.trace('p_message_name ',p_message_name);
282: pay_in_utils.trace('**************************************************','********************');
283: END IF;
284:
285: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
286: RETURN;

Line 285: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);

281: pay_in_utils.trace('p_message_name ',p_message_name);
282: pay_in_utils.trace('**************************************************','********************');
283: END IF;
284:
285: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,40);
286: RETURN;
287: END IF;
288:
289: --

Line 298: pay_in_utils.set_location(g_debug,'P PT CEILING : '||l_pt_ceil,50);

294: INTO l_pt_ceil;
295: IF c_pt_ceil%NOTFOUND OR l_pt_ceil IS NULL THEN
296: NULL;
297: ELSE
298: pay_in_utils.set_location(g_debug,'P PT CEILING : '||l_pt_ceil,50);
299: IF p_pem_information16 IS NOT NULL AND
300: TO_NUMBER(p_pem_information16) > TO_NUMBER(l_pt_ceil)
301: THEN
302: p_message_name := 'PER_IN_PT_MORE_THAN_LIMIT';

Line 307: pay_in_utils.trace('******************************','');

303: p_token_name(1) := 'VALUE';
304: p_token_value(1):= l_pt_ceil;
305:
306: IF g_debug THEN
307: pay_in_utils.trace('**************************************************','********************');
308: pay_in_utils.trace('p_message_name ',p_message_name);
309: pay_in_utils.trace('**************************************************','********************');
310: END IF;
311:

Line 308: pay_in_utils.trace('p_message_name ',p_message_name);

304: p_token_value(1):= l_pt_ceil;
305:
306: IF g_debug THEN
307: pay_in_utils.trace('**************************************************','********************');
308: pay_in_utils.trace('p_message_name ',p_message_name);
309: pay_in_utils.trace('**************************************************','********************');
310: END IF;
311:
312: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);

Line 309: pay_in_utils.trace('******************************','');

305:
306: IF g_debug THEN
307: pay_in_utils.trace('**************************************************','********************');
308: pay_in_utils.trace('p_message_name ',p_message_name);
309: pay_in_utils.trace('**************************************************','********************');
310: END IF;
311:
312: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
313: RETURN;

Line 312: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);

308: pay_in_utils.trace('p_message_name ',p_message_name);
309: pay_in_utils.trace('**************************************************','********************');
310: END IF;
311:
312: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,60);
313: RETURN;
314: END IF;
315: END IF;
316:

Line 317: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,70);

313: RETURN;
314: END IF;
315: END IF;
316:
317: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,70);
318:
319: END check_prev_emp_int;
320:
321: --------------------------------------------------------------------------

Line 383: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);

379: BEGIN
380:
381: l_procedure := g_package||'check_prev_emp_create';
382: g_debug := hr_utility.debug_enabled;
383: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
384:
385: g_message_name := 'SUCCESS';
386: pay_in_utils.null_message(g_token_name, g_token_value);
387:

Line 386: pay_in_utils.null_message(g_token_name, g_token_value);

382: g_debug := hr_utility.debug_enabled;
383: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
384:
385: g_message_name := 'SUCCESS';
386: pay_in_utils.null_message(g_token_name, g_token_value);
387:
388: IF g_debug THEN
389: pay_in_utils.trace('**************************************************','********************');
390: pay_in_utils.trace('p_effective_date ',p_effective_date );

Line 389: pay_in_utils.trace('******************************','');

385: g_message_name := 'SUCCESS';
386: pay_in_utils.null_message(g_token_name, g_token_value);
387:
388: IF g_debug THEN
389: pay_in_utils.trace('**************************************************','********************');
390: pay_in_utils.trace('p_effective_date ',p_effective_date );
391: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
392: pay_in_utils.trace('p_start_date ',p_start_date );
393: pay_in_utils.trace('p_end_date ',p_end_date );

Line 390: pay_in_utils.trace('p_effective_date ',p_effective_date );

386: pay_in_utils.null_message(g_token_name, g_token_value);
387:
388: IF g_debug THEN
389: pay_in_utils.trace('**************************************************','********************');
390: pay_in_utils.trace('p_effective_date ',p_effective_date );
391: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
392: pay_in_utils.trace('p_start_date ',p_start_date );
393: pay_in_utils.trace('p_end_date ',p_end_date );
394: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);

Line 391: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );

387:
388: IF g_debug THEN
389: pay_in_utils.trace('**************************************************','********************');
390: pay_in_utils.trace('p_effective_date ',p_effective_date );
391: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
392: pay_in_utils.trace('p_start_date ',p_start_date );
393: pay_in_utils.trace('p_end_date ',p_end_date );
394: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
395: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );

Line 392: pay_in_utils.trace('p_start_date ',p_start_date );

388: IF g_debug THEN
389: pay_in_utils.trace('**************************************************','********************');
390: pay_in_utils.trace('p_effective_date ',p_effective_date );
391: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
392: pay_in_utils.trace('p_start_date ',p_start_date );
393: pay_in_utils.trace('p_end_date ',p_end_date );
394: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
395: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
396: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );

Line 393: pay_in_utils.trace('p_end_date ',p_end_date );

389: pay_in_utils.trace('**************************************************','********************');
390: pay_in_utils.trace('p_effective_date ',p_effective_date );
391: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
392: pay_in_utils.trace('p_start_date ',p_start_date );
393: pay_in_utils.trace('p_end_date ',p_end_date );
394: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
395: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
396: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
397: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );

Line 394: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);

390: pay_in_utils.trace('p_effective_date ',p_effective_date );
391: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
392: pay_in_utils.trace('p_start_date ',p_start_date );
393: pay_in_utils.trace('p_end_date ',p_end_date );
394: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
395: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
396: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
397: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
398: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );

Line 395: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );

391: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
392: pay_in_utils.trace('p_start_date ',p_start_date );
393: pay_in_utils.trace('p_end_date ',p_end_date );
394: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
395: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
396: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
397: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
398: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
399: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );

Line 396: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );

392: pay_in_utils.trace('p_start_date ',p_start_date );
393: pay_in_utils.trace('p_end_date ',p_end_date );
394: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
395: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
396: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
397: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
398: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
399: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
400: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );

Line 397: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );

393: pay_in_utils.trace('p_end_date ',p_end_date );
394: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
395: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
396: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
397: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
398: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
399: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
400: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
401: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );

Line 398: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );

394: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
395: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
396: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
397: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
398: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
399: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
400: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
401: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
402: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );

Line 399: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );

395: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
396: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
397: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
398: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
399: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
400: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
401: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
402: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
403: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );

Line 400: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );

396: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
397: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
398: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
399: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
400: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
401: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
402: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
403: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
404: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );

Line 401: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );

397: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
398: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
399: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
400: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
401: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
402: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
403: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
404: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
405: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );

Line 402: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );

398: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
399: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
400: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
401: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
402: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
403: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
404: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
405: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
406: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );

Line 403: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );

399: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
400: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
401: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
402: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
403: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
404: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
405: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
406: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
407: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );

Line 404: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );

400: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
401: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
402: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
403: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
404: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
405: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
406: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
407: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
408: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );

Line 405: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );

401: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
402: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
403: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
404: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
405: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
406: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
407: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
408: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
409: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );

Line 406: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );

402: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
403: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
404: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
405: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
406: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
407: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
408: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
409: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
410: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );

Line 407: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );

403: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
404: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
405: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
406: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
407: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
408: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
409: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
410: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
411: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );

Line 408: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );

404: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
405: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
406: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
407: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
408: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
409: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
410: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
411: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
412: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );

Line 409: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );

405: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
406: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
407: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
408: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
409: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
410: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
411: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
412: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
413: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );

Line 410: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );

406: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
407: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
408: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
409: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
410: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
411: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
412: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
413: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
414: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );

Line 411: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );

407: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
408: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
409: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
410: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
411: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
412: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
413: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
414: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
415: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );

Line 412: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );

408: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
409: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
410: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
411: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
412: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
413: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
414: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
415: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
416: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );

Line 413: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );

409: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
410: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
411: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
412: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
413: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
414: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
415: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
416: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
417: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );

Line 414: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );

410: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
411: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
412: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
413: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
414: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
415: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
416: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
417: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
418: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );

Line 415: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );

411: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
412: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
413: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
414: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
415: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
416: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
417: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
418: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
419: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );

Line 416: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );

412: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
413: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
414: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
415: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
416: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
417: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
418: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
419: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
420: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );

Line 417: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );

413: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
414: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
415: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
416: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
417: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
418: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
419: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
420: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
421: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );

Line 418: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );

414: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
415: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
416: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
417: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
418: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
419: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
420: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
421: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
422: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );

Line 419: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );

415: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
416: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
417: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
418: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
419: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
420: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
421: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
422: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
423: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );

Line 420: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );

416: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
417: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
418: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
419: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
420: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
421: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
422: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
423: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
424: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );

Line 421: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );

417: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
418: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
419: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
420: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
421: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
422: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
423: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
424: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
425: pay_in_utils.trace('**************************************************','********************');

Line 422: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );

418: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
419: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
420: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
421: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
422: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
423: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
424: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
425: pay_in_utils.trace('**************************************************','********************');
426: END IF;

Line 423: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );

419: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
420: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
421: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
422: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
423: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
424: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
425: pay_in_utils.trace('**************************************************','********************');
426: END IF;
427:

Line 424: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );

420: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
421: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
422: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
423: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
424: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
425: pay_in_utils.trace('**************************************************','********************');
426: END IF;
427:
428: check_prev_emp_int(

Line 425: pay_in_utils.trace('******************************','');

421: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
422: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
423: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
424: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
425: pay_in_utils.trace('**************************************************','********************');
426: END IF;
427:
428: check_prev_emp_int(
429: p_effective_date => p_effective_date

Line 472: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

468: ,p_token_name => g_token_name
469: ,p_token_value => g_token_value);
470:
471:
472: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
473: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
474:
475: END check_prev_emp_create;
476:

Line 473: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

469: ,p_token_value => g_token_value);
470:
471:
472: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
473: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
474:
475: END check_prev_emp_create;
476:
477:

Line 612: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);

608:
609: BEGIN
610: l_procedure := g_package||'check_prev_emp_update';
611: g_debug := hr_utility.debug_enabled;
612: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
613: g_message_name := 'SUCCESS';
614:
615: IF g_debug THEN
616: pay_in_utils.trace('**************************************************','********************');

Line 616: pay_in_utils.trace('******************************','');

612: pay_in_utils.set_location(g_debug, 'Entering: ' || l_procedure, 10);
613: g_message_name := 'SUCCESS';
614:
615: IF g_debug THEN
616: pay_in_utils.trace('**************************************************','********************');
617: pay_in_utils.trace('p_effective_date ',p_effective_date );
618: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
619: pay_in_utils.trace('p_start_date ',p_start_date );
620: pay_in_utils.trace('p_end_date ',p_end_date );

Line 617: pay_in_utils.trace('p_effective_date ',p_effective_date );

613: g_message_name := 'SUCCESS';
614:
615: IF g_debug THEN
616: pay_in_utils.trace('**************************************************','********************');
617: pay_in_utils.trace('p_effective_date ',p_effective_date );
618: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
619: pay_in_utils.trace('p_start_date ',p_start_date );
620: pay_in_utils.trace('p_end_date ',p_end_date );
621: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);

Line 618: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );

614:
615: IF g_debug THEN
616: pay_in_utils.trace('**************************************************','********************');
617: pay_in_utils.trace('p_effective_date ',p_effective_date );
618: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
619: pay_in_utils.trace('p_start_date ',p_start_date );
620: pay_in_utils.trace('p_end_date ',p_end_date );
621: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
622: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );

Line 619: pay_in_utils.trace('p_start_date ',p_start_date );

615: IF g_debug THEN
616: pay_in_utils.trace('**************************************************','********************');
617: pay_in_utils.trace('p_effective_date ',p_effective_date );
618: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
619: pay_in_utils.trace('p_start_date ',p_start_date );
620: pay_in_utils.trace('p_end_date ',p_end_date );
621: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
622: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
623: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );

Line 620: pay_in_utils.trace('p_end_date ',p_end_date );

616: pay_in_utils.trace('**************************************************','********************');
617: pay_in_utils.trace('p_effective_date ',p_effective_date );
618: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
619: pay_in_utils.trace('p_start_date ',p_start_date );
620: pay_in_utils.trace('p_end_date ',p_end_date );
621: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
622: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
623: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
624: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );

Line 621: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);

617: pay_in_utils.trace('p_effective_date ',p_effective_date );
618: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
619: pay_in_utils.trace('p_start_date ',p_start_date );
620: pay_in_utils.trace('p_end_date ',p_end_date );
621: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
622: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
623: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
624: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
625: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );

Line 622: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );

618: pay_in_utils.trace('p_previous_employer_id ',p_previous_employer_id );
619: pay_in_utils.trace('p_start_date ',p_start_date );
620: pay_in_utils.trace('p_end_date ',p_end_date );
621: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
622: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
623: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
624: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
625: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
626: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );

Line 623: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );

619: pay_in_utils.trace('p_start_date ',p_start_date );
620: pay_in_utils.trace('p_end_date ',p_end_date );
621: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
622: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
623: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
624: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
625: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
626: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
627: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );

Line 624: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );

620: pay_in_utils.trace('p_end_date ',p_end_date );
621: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
622: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
623: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
624: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
625: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
626: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
627: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
628: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );

Line 625: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );

621: pay_in_utils.trace('p_pem_information_category',p_pem_information_category);
622: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
623: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
624: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
625: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
626: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
627: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
628: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
629: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );

Line 626: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );

622: pay_in_utils.trace('p_pem_information1 ',p_pem_information1 );
623: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
624: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
625: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
626: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
627: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
628: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
629: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
630: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );

Line 627: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );

623: pay_in_utils.trace('p_pem_information2 ',p_pem_information2 );
624: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
625: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
626: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
627: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
628: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
629: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
630: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
631: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );

Line 628: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );

624: pay_in_utils.trace('p_pem_information3 ',p_pem_information3 );
625: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
626: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
627: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
628: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
629: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
630: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
631: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
632: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );

Line 629: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );

625: pay_in_utils.trace('p_pem_information4 ',p_pem_information4 );
626: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
627: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
628: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
629: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
630: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
631: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
632: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
633: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );

Line 630: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );

626: pay_in_utils.trace('p_pem_information5 ',p_pem_information5 );
627: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
628: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
629: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
630: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
631: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
632: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
633: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
634: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );

Line 631: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );

627: pay_in_utils.trace('p_pem_information6 ',p_pem_information6 );
628: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
629: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
630: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
631: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
632: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
633: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
634: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
635: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );

Line 632: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );

628: pay_in_utils.trace('p_pem_information7 ',p_pem_information7 );
629: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
630: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
631: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
632: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
633: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
634: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
635: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
636: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );

Line 633: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );

629: pay_in_utils.trace('p_pem_information8 ',p_pem_information8 );
630: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
631: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
632: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
633: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
634: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
635: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
636: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
637: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );

Line 634: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );

630: pay_in_utils.trace('p_pem_information9 ',p_pem_information9 );
631: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
632: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
633: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
634: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
635: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
636: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
637: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
638: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );

Line 635: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );

631: pay_in_utils.trace('p_pem_information10 ',p_pem_information10 );
632: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
633: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
634: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
635: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
636: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
637: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
638: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
639: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );

Line 636: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );

632: pay_in_utils.trace('p_pem_information11 ',p_pem_information11 );
633: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
634: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
635: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
636: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
637: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
638: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
639: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
640: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );

Line 637: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );

633: pay_in_utils.trace('p_pem_information12 ',p_pem_information12 );
634: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
635: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
636: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
637: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
638: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
639: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
640: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
641: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );

Line 638: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );

634: pay_in_utils.trace('p_pem_information13 ',p_pem_information13 );
635: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
636: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
637: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
638: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
639: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
640: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
641: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
642: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );

Line 639: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );

635: pay_in_utils.trace('p_pem_information14 ',p_pem_information14 );
636: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
637: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
638: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
639: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
640: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
641: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
642: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
643: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );

Line 640: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );

636: pay_in_utils.trace('p_pem_information15 ',p_pem_information15 );
637: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
638: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
639: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
640: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
641: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
642: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
643: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
644: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );

Line 641: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );

637: pay_in_utils.trace('p_pem_information16 ',p_pem_information16 );
638: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
639: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
640: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
641: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
642: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
643: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
644: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
645: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );

Line 642: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );

638: pay_in_utils.trace('p_pem_information17 ',p_pem_information17 );
639: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
640: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
641: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
642: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
643: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
644: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
645: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
646: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );

Line 643: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );

639: pay_in_utils.trace('p_pem_information18 ',p_pem_information18 );
640: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
641: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
642: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
643: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
644: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
645: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
646: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
647: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );

Line 644: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );

640: pay_in_utils.trace('p_pem_information19 ',p_pem_information19 );
641: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
642: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
643: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
644: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
645: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
646: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
647: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
648: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );

Line 645: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );

641: pay_in_utils.trace('p_pem_information20 ',p_pem_information20 );
642: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
643: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
644: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
645: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
646: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
647: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
648: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
649: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );

Line 646: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );

642: pay_in_utils.trace('p_pem_information21 ',p_pem_information21 );
643: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
644: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
645: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
646: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
647: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
648: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
649: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
650: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );

Line 647: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );

643: pay_in_utils.trace('p_pem_information22 ',p_pem_information22 );
644: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
645: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
646: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
647: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
648: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
649: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
650: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
651: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );

Line 648: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );

644: pay_in_utils.trace('p_pem_information23 ',p_pem_information23 );
645: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
646: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
647: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
648: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
649: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
650: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
651: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
652: pay_in_utils.trace('**************************************************','********************');

Line 649: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );

645: pay_in_utils.trace('p_pem_information24 ',p_pem_information24 );
646: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
647: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
648: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
649: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
650: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
651: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
652: pay_in_utils.trace('**************************************************','********************');
653: END IF;

Line 650: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );

646: pay_in_utils.trace('p_pem_information25 ',p_pem_information25 );
647: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
648: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
649: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
650: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
651: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
652: pay_in_utils.trace('**************************************************','********************');
653: END IF;
654:

Line 651: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );

647: pay_in_utils.trace('p_pem_information26 ',p_pem_information26 );
648: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
649: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
650: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
651: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
652: pay_in_utils.trace('**************************************************','********************');
653: END IF;
654:
655: /*IF p_end_date IS NULL THEN

Line 652: pay_in_utils.trace('******************************','');

648: pay_in_utils.trace('p_pem_information27 ',p_pem_information27 );
649: pay_in_utils.trace('p_pem_information28 ',p_pem_information28 );
650: pay_in_utils.trace('p_pem_information29 ',p_pem_information29 );
651: pay_in_utils.trace('p_pem_information30 ',p_pem_information30 );
652: pay_in_utils.trace('**************************************************','********************');
653: END IF;
654:
655: /*IF p_end_date IS NULL THEN
656: g_message_name := 'PER_IN_END_DATE_NOT_ENTERED';

Line 657: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

653: END IF;
654:
655: /*IF p_end_date IS NULL THEN
656: g_message_name := 'PER_IN_END_DATE_NOT_ENTERED';
657: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
658: END IF;*/
659:
660: OPEN c_pem_id;
661: FETCH c_pem_id

Line 699: pay_in_utils.set_location(g_debug,l_procedure,20);

695: ,l_pem_information29
696: ,l_pem_information30;
697: CLOSE c_pem_id;
698:
699: pay_in_utils.set_location(g_debug,l_procedure,20);
700:
701: IF p_start_date <> hr_api.g_date THEN
702: l_start_date := p_start_date;
703: END IF;

Line 835: pay_in_utils.set_location(g_debug,'Before call to internal proc',15);

831: END IF;
832: IF p_end_date IS NULL THEN
833: l_end_date := p_end_date;
834: END if;
835: pay_in_utils.set_location(g_debug,'Before call to internal proc',15);
836: pay_in_utils.trace('Before call to internal proc p_person_id ',l_person_id );
837: pay_in_utils.trace('Before call to internal proc p_business_group_id ',l_business_group_id );
838: check_prev_emp_int(
839: p_effective_date => p_effective_date

Line 836: pay_in_utils.trace('Before call to internal proc p_person_id ',l_person_id );

832: IF p_end_date IS NULL THEN
833: l_end_date := p_end_date;
834: END if;
835: pay_in_utils.set_location(g_debug,'Before call to internal proc',15);
836: pay_in_utils.trace('Before call to internal proc p_person_id ',l_person_id );
837: pay_in_utils.trace('Before call to internal proc p_business_group_id ',l_business_group_id );
838: check_prev_emp_int(
839: p_effective_date => p_effective_date
840: ,p_previous_employer_id => p_previous_employer_id

Line 837: pay_in_utils.trace('Before call to internal proc p_business_group_id ',l_business_group_id );

833: l_end_date := p_end_date;
834: END if;
835: pay_in_utils.set_location(g_debug,'Before call to internal proc',15);
836: pay_in_utils.trace('Before call to internal proc p_person_id ',l_person_id );
837: pay_in_utils.trace('Before call to internal proc p_business_group_id ',l_business_group_id );
838: check_prev_emp_int(
839: p_effective_date => p_effective_date
840: ,p_previous_employer_id => p_previous_employer_id
841: ,p_business_group_id => l_business_group_id

Line 881: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);

877: ,p_message_name => g_message_name
878: ,p_token_name => g_token_name
879: ,p_token_value => g_token_value);
880:
881: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
882: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
883:
884: END check_prev_emp_update;
885:

Line 882: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);

878: ,p_token_name => g_token_name
879: ,p_token_value => g_token_value);
880:
881: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
882: pay_in_utils.raise_message(800, g_message_name, g_token_name, g_token_value);
883:
884: END check_prev_emp_update;
885:
886: BEGIN