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.

[Home] [Help]

APPS.PAY_IE_P45PART3_P46_PKG dependencies on HR_UTILITY

Line 121: hr_utility.set_location('Entering ' || l_proc, 100);

117: l_proc VARCHAR2(50) := g_package ||'get_parameters';
118:
119: BEGIN
120:
121: hr_utility.set_location('Entering ' || l_proc, 100);
122: hr_utility.set_location('p_token_name ' || TO_CHAR(p_token_name), 110);
123:
124: OPEN csr_parameter_info
125: (

Line 122: hr_utility.set_location('p_token_name ' || TO_CHAR(p_token_name), 110);

118:
119: BEGIN
120:
121: hr_utility.set_location('Entering ' || l_proc, 100);
122: hr_utility.set_location('p_token_name ' || TO_CHAR(p_token_name), 110);
123:
124: OPEN csr_parameter_info
125: (
126: p_payroll_action_id,

Line 132: hr_utility.set_location('l_token_value ' || TO_CHAR(l_token_value), 115);

128: );
129: FETCH csr_parameter_info INTO l_token_value, l_business_group_id;
130: CLOSE csr_parameter_info;
131:
132: hr_utility.set_location('l_token_value ' || TO_CHAR(l_token_value), 115);
133: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);
134:
135: IF p_token_name = 'BG_ID' THEN
136: p_token_value := l_business_group_id;

Line 133: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);

129: FETCH csr_parameter_info INTO l_token_value, l_business_group_id;
130: CLOSE csr_parameter_info;
131:
132: hr_utility.set_location('l_token_value ' || TO_CHAR(l_token_value), 115);
133: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);
134:
135: IF p_token_name = 'BG_ID' THEN
136: p_token_value := l_business_group_id;
137: hr_utility.set_location('p_token_name '||p_token_name,125);

Line 137: hr_utility.set_location('p_token_name '||p_token_name,125);

133: hr_utility.set_location('l_business_group_id ' || TO_CHAR(l_business_group_id), 120);
134:
135: IF p_token_name = 'BG_ID' THEN
136: p_token_value := l_business_group_id;
137: hr_utility.set_location('p_token_name '||p_token_name,125);
138: ELSE
139: p_token_value := l_token_value;
140: hr_utility.set_location('p_token_name '||p_token_name,130);
141: END IF;

Line 140: hr_utility.set_location('p_token_name '||p_token_name,130);

136: p_token_value := l_business_group_id;
137: hr_utility.set_location('p_token_name '||p_token_name,125);
138: ELSE
139: p_token_value := l_token_value;
140: hr_utility.set_location('p_token_name '||p_token_name,130);
141: END IF;
142:
143: hr_utility.set_location('Leaving ' || l_proc, 135);
144: --

Line 143: hr_utility.set_location('Leaving ' || l_proc, 135);

139: p_token_value := l_token_value;
140: hr_utility.set_location('p_token_name '||p_token_name,130);
141: END IF;
142:
143: hr_utility.set_location('Leaving ' || l_proc, 135);
144: --
145: EXCEPTION
146: WHEN others THEN
147: hr_utility.set_location('Leaving' || l_proc,140);

Line 147: hr_utility.set_location('Leaving' || l_proc,140);

143: hr_utility.set_location('Leaving ' || l_proc, 135);
144: --
145: EXCEPTION
146: WHEN others THEN
147: hr_utility.set_location('Leaving' || l_proc,140);
148: p_token_value := NULL;
149: --
150: END get_parameters;
151: -----------------------------------------------------------------------

Line 166: hr_utility.set_location(' Entering pay_ie_p45p3_p46_pkg.get_all_parameters ', 145);

162: ,p_employer_id OUT NOCOPY VARCHAR2)
163: IS
164:
165: BEGIN
166: hr_utility.set_location(' Entering pay_ie_p45p3_p46_pkg.get_all_parameters ', 145);
167:
168: get_parameters(p_payroll_action_id,'BG_ID',p_business_Group_id);
169: --get_parameters(p_payroll_action_id,'ORG_STR_VER_ID',P_Org_Struct_Version_Id);
170: get_parameters(p_payroll_action_id,'REP_GROUP',p_rep_group);

Line 178: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,150);

174: get_parameters(p_payroll_action_id,'FILE_TYPE',p_file_type);
175: get_parameters(p_payroll_action_id,'START_DATE',p_start_date);
176: get_parameters(p_payroll_action_id,'END_DATE',p_end_date);
177:
178: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,150);
179: hr_utility.set_location(' REP_GROUP = '||p_rep_group,155);
180: hr_utility.set_location(' EMPLOYER = '||p_employer_id,160);
181: hr_utility.set_location(' PAYROLL = '||p_payroll_id,165);
182: hr_utility.set_location(' EMPLOYEE = '||p_person_id,170);

Line 179: hr_utility.set_location(' REP_GROUP = '||p_rep_group,155);

175: get_parameters(p_payroll_action_id,'START_DATE',p_start_date);
176: get_parameters(p_payroll_action_id,'END_DATE',p_end_date);
177:
178: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,150);
179: hr_utility.set_location(' REP_GROUP = '||p_rep_group,155);
180: hr_utility.set_location(' EMPLOYER = '||p_employer_id,160);
181: hr_utility.set_location(' PAYROLL = '||p_payroll_id,165);
182: hr_utility.set_location(' EMPLOYEE = '||p_person_id,170);
183: hr_utility.set_location(' FILE_TYPE = '|| p_file_type,175);

Line 180: hr_utility.set_location(' EMPLOYER = '||p_employer_id,160);

176: get_parameters(p_payroll_action_id,'END_DATE',p_end_date);
177:
178: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,150);
179: hr_utility.set_location(' REP_GROUP = '||p_rep_group,155);
180: hr_utility.set_location(' EMPLOYER = '||p_employer_id,160);
181: hr_utility.set_location(' PAYROLL = '||p_payroll_id,165);
182: hr_utility.set_location(' EMPLOYEE = '||p_person_id,170);
183: hr_utility.set_location(' FILE_TYPE = '|| p_file_type,175);
184: hr_utility.set_location(' START_DATE = '||p_start_date,180);

Line 181: hr_utility.set_location(' PAYROLL = '||p_payroll_id,165);

177:
178: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,150);
179: hr_utility.set_location(' REP_GROUP = '||p_rep_group,155);
180: hr_utility.set_location(' EMPLOYER = '||p_employer_id,160);
181: hr_utility.set_location(' PAYROLL = '||p_payroll_id,165);
182: hr_utility.set_location(' EMPLOYEE = '||p_person_id,170);
183: hr_utility.set_location(' FILE_TYPE = '|| p_file_type,175);
184: hr_utility.set_location(' START_DATE = '||p_start_date,180);
185: hr_utility.set_location(' END_DATE = '||p_end_date,185);

Line 182: hr_utility.set_location(' EMPLOYEE = '||p_person_id,170);

178: hr_utility.set_location(' p_business_Group_id = '||p_business_Group_id,150);
179: hr_utility.set_location(' REP_GROUP = '||p_rep_group,155);
180: hr_utility.set_location(' EMPLOYER = '||p_employer_id,160);
181: hr_utility.set_location(' PAYROLL = '||p_payroll_id,165);
182: hr_utility.set_location(' EMPLOYEE = '||p_person_id,170);
183: hr_utility.set_location(' FILE_TYPE = '|| p_file_type,175);
184: hr_utility.set_location(' START_DATE = '||p_start_date,180);
185: hr_utility.set_location(' END_DATE = '||p_end_date,185);
186:

Line 183: hr_utility.set_location(' FILE_TYPE = '|| p_file_type,175);

179: hr_utility.set_location(' REP_GROUP = '||p_rep_group,155);
180: hr_utility.set_location(' EMPLOYER = '||p_employer_id,160);
181: hr_utility.set_location(' PAYROLL = '||p_payroll_id,165);
182: hr_utility.set_location(' EMPLOYEE = '||p_person_id,170);
183: hr_utility.set_location(' FILE_TYPE = '|| p_file_type,175);
184: hr_utility.set_location(' START_DATE = '||p_start_date,180);
185: hr_utility.set_location(' END_DATE = '||p_end_date,185);
186:
187:

Line 184: hr_utility.set_location(' START_DATE = '||p_start_date,180);

180: hr_utility.set_location(' EMPLOYER = '||p_employer_id,160);
181: hr_utility.set_location(' PAYROLL = '||p_payroll_id,165);
182: hr_utility.set_location(' EMPLOYEE = '||p_person_id,170);
183: hr_utility.set_location(' FILE_TYPE = '|| p_file_type,175);
184: hr_utility.set_location(' START_DATE = '||p_start_date,180);
185: hr_utility.set_location(' END_DATE = '||p_end_date,185);
186:
187:
188: IF p_person_id IS NOT NULL THEN

Line 185: hr_utility.set_location(' END_DATE = '||p_end_date,185);

181: hr_utility.set_location(' PAYROLL = '||p_payroll_id,165);
182: hr_utility.set_location(' EMPLOYEE = '||p_person_id,170);
183: hr_utility.set_location(' FILE_TYPE = '|| p_file_type,175);
184: hr_utility.set_location(' START_DATE = '||p_start_date,180);
185: hr_utility.set_location(' END_DATE = '||p_end_date,185);
186:
187:
188: IF p_person_id IS NOT NULL THEN
189: g_where_clause1 :=

Line 202: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,190);

198: ELSE
199: g_where_clause :=' and 1=1 ';
200: END IF;
201:
202: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,190);
203: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,195);
204: --hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,200);
205: hr_utility.set_location(' Leaving: pay_ie_p45p3_p46_pkg.get_all_parameters: ', 205);
206:

Line 203: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,195);

199: g_where_clause :=' and 1=1 ';
200: END IF;
201:
202: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,190);
203: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,195);
204: --hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,200);
205: hr_utility.set_location(' Leaving: pay_ie_p45p3_p46_pkg.get_all_parameters: ', 205);
206:
207: EXCEPTION

Line 204: --hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,200);

200: END IF;
201:
202: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,190);
203: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,195);
204: --hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,200);
205: hr_utility.set_location(' Leaving: pay_ie_p45p3_p46_pkg.get_all_parameters: ', 205);
206:
207: EXCEPTION
208: WHEN Others THEN

Line 205: hr_utility.set_location(' Leaving: pay_ie_p45p3_p46_pkg.get_all_parameters: ', 205);

201:
202: hr_utility.set_location(' Inside get_all_parameters:g_where_clause: '||g_where_clause,190);
203: hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,195);
204: --hr_utility.set_location(' Inside get_all_parameters:g_where_clause1: '||g_where_clause1,200);
205: hr_utility.set_location(' Leaving: pay_ie_p45p3_p46_pkg.get_all_parameters: ', 205);
206:
207: EXCEPTION
208: WHEN Others THEN
209: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1215);

Line 209: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1215);

205: hr_utility.set_location(' Leaving: pay_ie_p45p3_p46_pkg.get_all_parameters: ', 205);
206:
207: EXCEPTION
208: WHEN Others THEN
209: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1215);
210: END get_all_parameters;
211: -----------------------------------------------------------------------
212: -- RANGE_CODE
213: -----------------------------------------------------------------------

Line 264: hr_utility.set_location('Entering '||l_procedure_name, 200);

260: BEGIN
261:
262: l_procedure_name := g_package||'range_code';
263:
264: hr_utility.set_location('Entering '||l_procedure_name, 200);
265: hr_utility.set_location('pactid '||TO_CHAR(pactid), 200);
266:
267: sqlstr := ' select distinct p.person_id' ||
268: ' from per_people_f p,' ||

Line 265: hr_utility.set_location('pactid '||TO_CHAR(pactid), 200);

261:
262: l_procedure_name := g_package||'range_code';
263:
264: hr_utility.set_location('Entering '||l_procedure_name, 200);
265: hr_utility.set_location('pactid '||TO_CHAR(pactid), 200);
266:
267: sqlstr := ' select distinct p.person_id' ||
268: ' from per_people_f p,' ||
269: ' pay_payroll_actions pa' ||

Line 343: hr_utility.set_location(' g_start_date: '||g_start_date, 205);

339: Raise l_p45_exception;
340: END IF;
341:
342:
343: hr_utility.set_location(' g_start_date: '||g_start_date, 205);
344: hr_utility.set_location(' g_end_date: '||g_end_date, 205);
345: hr_utility.set_location('Leaving '||l_procedure_name, 215);
346:
347: EXCEPTION

Line 344: hr_utility.set_location(' g_end_date: '||g_end_date, 205);

340: END IF;
341:
342:
343: hr_utility.set_location(' g_start_date: '||g_start_date, 205);
344: hr_utility.set_location(' g_end_date: '||g_end_date, 205);
345: hr_utility.set_location('Leaving '||l_procedure_name, 215);
346:
347: EXCEPTION
348: WHEN l_p45_exception THEN

Line 345: hr_utility.set_location('Leaving '||l_procedure_name, 215);

341:
342:
343: hr_utility.set_location(' g_start_date: '||g_start_date, 205);
344: hr_utility.set_location(' g_end_date: '||g_end_date, 205);
345: hr_utility.set_location('Leaving '||l_procedure_name, 215);
346:
347: EXCEPTION
348: WHEN l_p45_exception THEN
349: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);

Line 349: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);

345: hr_utility.set_location('Leaving '||l_procedure_name, 215);
346:
347: EXCEPTION
348: WHEN l_p45_exception THEN
349: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);
350: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','P46 part3 XML Process errors out.');
351: WHEN Others THEN
352: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);
353: END range_code;

Line 352: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);

348: WHEN l_p45_exception THEN
349: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);
350: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','P46 part3 XML Process errors out.');
351: WHEN Others THEN
352: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);
353: END range_code;
354: -----------------------------------------------------------------------
355: -- ASSIGNMENT_ACTION_CODE
356: -----------------------------------------------------------------------

Line 463: hr_utility.set_location('Entering pay_ie_p45p3_p46_pkg.assignment_action_code',220);

459:
460: l_ass_check varchar2(1);
461: l_csr_already_archived pay_element_entry_values_f.screen_entry_value%TYPE := 'N';
462: BEGIN
463: hr_utility.set_location('Entering pay_ie_p45p3_p46_pkg.assignment_action_code',220);
464:
465: -- Get all the parameters
466: get_all_parameters(pactid
467: ,g_rep_group

Line 480: hr_utility.set_location('after get_all_parameter called',225);

476: g_start_date := fnd_date.canonical_to_date(l_start_date);
477: g_end_date := fnd_date.canonical_to_date(l_end_date);
478: g_pact_id := pactid;
479:
480: hr_utility.set_location('after get_all_parameter called',225);
481: hr_utility.set_location('report start date= '||g_start_date,300);
482:
483: -- Query to fetch assignment_id.
484: /*l_select_str := 'select distinct paaf.assignment_id, ppf.person_id from

Line 481: hr_utility.set_location('report start date= '||g_start_date,300);

477: g_end_date := fnd_date.canonical_to_date(l_end_date);
478: g_pact_id := pactid;
479:
480: hr_utility.set_location('after get_all_parameter called',225);
481: hr_utility.set_location('report start date= '||g_start_date,300);
482:
483: -- Query to fetch assignment_id.
484: /*l_select_str := 'select distinct paaf.assignment_id, ppf.person_id from
485: per_all_assignments_f paaf,

Line 532: hr_utility.set_location('l_select_str'||l_select_str,225);

528: ||' and pps.date_start between '||''''||g_start_date||''''||' and '||''''||g_end_date||''''
529: ||' and paaf.effective_start_date between pps.date_start and '||''''||g_end_date||''''
530: ||' Order by ppf.person_id, paaf.assignment_number, paaf.assignment_id ';
531:
532: hr_utility.set_location('l_select_str'||l_select_str,225);
533:
534: /*
535: OPEN csr_get_asg FOR l_select_str; -- ref cursor
536: LOOP

Line 537: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',230);

533:
534: /*
535: OPEN csr_get_asg FOR l_select_str; -- ref cursor
536: LOOP
537: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',230);
538: FETCH csr_get_asg INTO l_assg_id, l_person_id;
539: EXIT WHEN csr_get_asg%NOTFOUND;
540: hr_utility.set_location(' Inside ass action code,l_assg_id: '||l_assg_id,235);
541: -- Check if the report is already run for this assignment, dont run it again

Line 540: hr_utility.set_location(' Inside ass action code,l_assg_id: '||l_assg_id,235);

536: LOOP
537: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',230);
538: FETCH csr_get_asg INTO l_assg_id, l_person_id;
539: EXIT WHEN csr_get_asg%NOTFOUND;
540: hr_utility.set_location(' Inside ass action code,l_assg_id: '||l_assg_id,235);
541: -- Check if the report is already run for this assignment, dont run it again
542: l_csr_already_archived := NULL;
543: l_ass_check :=NULL;
544: l_valid_assg := False;

Line 549: hr_utility.set_location(' l_csr_already_archived: '||l_csr_already_archived,240);

545: OPEN csr_already_archived(l_assg_id);
546: FETCH csr_already_archived INTO l_csr_already_archived;
547: -- EXIT WHEN csr_already_archived%NOTFOUND;
548: CLOSE csr_already_archived;
549: hr_utility.set_location(' l_csr_already_archived: '||l_csr_already_archived,240);
550: IF l_csr_already_archived ='N' THEN -- means report has not run previously
551: OPEN csr_ass_check(l_assg_id, l_person_id);
552: FETCH csr_ass_check into l_ass_check;
553: CLOSE csr_ass_check;

Line 554: hr_utility.set_location('any assg before:'||l_ass_check, 250);

550: IF l_csr_already_archived ='N' THEN -- means report has not run previously
551: OPEN csr_ass_check(l_assg_id, l_person_id);
552: FETCH csr_ass_check into l_ass_check;
553: CLOSE csr_ass_check;
554: hr_utility.set_location('any assg before:'||l_ass_check, 250);
555: IF (l_ass_check='X') THEN --THERE R NO ASSG BEFORE
556: l_element_name :='Already Submitted';
557: OPEN csr_scr_ent_val(l_assg_id,l_element_name);
558: --hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',250);

Line 558: --hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',250);

554: hr_utility.set_location('any assg before:'||l_ass_check, 250);
555: IF (l_ass_check='X') THEN --THERE R NO ASSG BEFORE
556: l_element_name :='Already Submitted';
557: OPEN csr_scr_ent_val(l_assg_id,l_element_name);
558: --hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',250);
559: FETCH csr_scr_ent_val INTO l_submitted;
560: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_submitted,250);
561: CLOSE csr_scr_ent_val;
562: IF (l_submitted='N') then --not submitted online

Line 560: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_submitted,250);

556: l_element_name :='Already Submitted';
557: OPEN csr_scr_ent_val(l_assg_id,l_element_name);
558: --hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',250);
559: FETCH csr_scr_ent_val INTO l_submitted;
560: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_submitted,250);
561: CLOSE csr_scr_ent_val;
562: IF (l_submitted='N') then --not submitted online
563: l_element_name :='P45P3 Or P46';
564: OPEN csr_scr_ent_val(l_assg_id,l_element_name);

Line 566: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_file_type,245);

562: IF (l_submitted='N') then --not submitted online
563: l_element_name :='P45P3 Or P46';
564: OPEN csr_scr_ent_val(l_assg_id,l_element_name);
565: FETCH csr_scr_ent_val INTO l_file_type;
566: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_file_type,245);
567: CLOSE csr_scr_ent_val;
568: IF (g_file_type='P46' AND l_file_type='Y') THEN --file type is p46
569: l_valid_assg := TRUE;
570: END IF; --file type is p46

Line 577: hr_utility.set_location('inserting into ASSIGNMENT_ACTIONS', 255);

573: END IF; --file type is p45p3
574: END IF; --not submitted online
575: END IF; --THERE R NO ASSG BEFORE
576: IF (l_valid_assg = TRUE) THEN
577: hr_utility.set_location('inserting into ASSIGNMENT_ACTIONS', 255);
578: SELECT pay_assignment_actions_s.nextval
579: INTO lockingactid
580: FROM dual;
581: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 1083);

Line 581: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 1083);

577: hr_utility.set_location('inserting into ASSIGNMENT_ACTIONS', 255);
578: SELECT pay_assignment_actions_s.nextval
579: INTO lockingactid
580: FROM dual;
581: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 1083);
582: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE
583: hr_nonrun_asact.insact(lockingactid => lockingactid
584: ,assignid => l_assg_id
585: ,pactid => pactid

Line 591: -- hr_utility.set_location('assignment_action_code, the assignment id finally',980);

587: ,greid => NULL);
588: END IF; -- processing of assignment
589: -- UPDATE pay_element_entry_values_f SET screen_entry_value='Y' WHERE CURRENT OF csr_already_archived;
590: --ELSE
591: -- hr_utility.set_location('assignment_action_code, the assignment id finally',980);
592: END IF; -- Already processed assignment check
593:
594: END LOOP;-- ref cursor
595: */

Line 601: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',230);

597: l_prev_period_of_service_id := 0;
598:
599: OPEN csr_get_asg FOR l_select_str; -- ref cursor
600: LOOP
601: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',230);
602: FETCH csr_get_asg INTO l_assg_id, l_person_id, l_period_of_service_id, l_assignment_number;
603: EXIT WHEN csr_get_asg%NOTFOUND;
604:
605: hr_utility.set_location(' l_assg_id: '||l_assg_id,235);

Line 605: hr_utility.set_location(' l_assg_id: '||l_assg_id,235);

601: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',230);
602: FETCH csr_get_asg INTO l_assg_id, l_person_id, l_period_of_service_id, l_assignment_number;
603: EXIT WHEN csr_get_asg%NOTFOUND;
604:
605: hr_utility.set_location(' l_assg_id: '||l_assg_id,235);
606: hr_utility.set_location(' l_person_id: '||l_person_id,235);
607: hr_utility.set_location(' l_period_of_service_id: '||l_period_of_service_id,235);
608: hr_utility.set_location(' l_assignment_number: '||l_assignment_number,235);
609: hr_utility.set_location(' l_prev_person_id: '||l_prev_person_id,235);

Line 606: hr_utility.set_location(' l_person_id: '||l_person_id,235);

602: FETCH csr_get_asg INTO l_assg_id, l_person_id, l_period_of_service_id, l_assignment_number;
603: EXIT WHEN csr_get_asg%NOTFOUND;
604:
605: hr_utility.set_location(' l_assg_id: '||l_assg_id,235);
606: hr_utility.set_location(' l_person_id: '||l_person_id,235);
607: hr_utility.set_location(' l_period_of_service_id: '||l_period_of_service_id,235);
608: hr_utility.set_location(' l_assignment_number: '||l_assignment_number,235);
609: hr_utility.set_location(' l_prev_person_id: '||l_prev_person_id,235);
610: hr_utility.set_location(' l_prev_period_of_service_id: '||l_prev_period_of_service_id,235);

Line 607: hr_utility.set_location(' l_period_of_service_id: '||l_period_of_service_id,235);

603: EXIT WHEN csr_get_asg%NOTFOUND;
604:
605: hr_utility.set_location(' l_assg_id: '||l_assg_id,235);
606: hr_utility.set_location(' l_person_id: '||l_person_id,235);
607: hr_utility.set_location(' l_period_of_service_id: '||l_period_of_service_id,235);
608: hr_utility.set_location(' l_assignment_number: '||l_assignment_number,235);
609: hr_utility.set_location(' l_prev_person_id: '||l_prev_person_id,235);
610: hr_utility.set_location(' l_prev_period_of_service_id: '||l_prev_period_of_service_id,235);
611:

Line 608: hr_utility.set_location(' l_assignment_number: '||l_assignment_number,235);

604:
605: hr_utility.set_location(' l_assg_id: '||l_assg_id,235);
606: hr_utility.set_location(' l_person_id: '||l_person_id,235);
607: hr_utility.set_location(' l_period_of_service_id: '||l_period_of_service_id,235);
608: hr_utility.set_location(' l_assignment_number: '||l_assignment_number,235);
609: hr_utility.set_location(' l_prev_person_id: '||l_prev_person_id,235);
610: hr_utility.set_location(' l_prev_period_of_service_id: '||l_prev_period_of_service_id,235);
611:
612: --IF l_prev_person_id <> l_person_id and l_prev_period_of_service_id <> l_period_of_service_id THEN

Line 609: hr_utility.set_location(' l_prev_person_id: '||l_prev_person_id,235);

605: hr_utility.set_location(' l_assg_id: '||l_assg_id,235);
606: hr_utility.set_location(' l_person_id: '||l_person_id,235);
607: hr_utility.set_location(' l_period_of_service_id: '||l_period_of_service_id,235);
608: hr_utility.set_location(' l_assignment_number: '||l_assignment_number,235);
609: hr_utility.set_location(' l_prev_person_id: '||l_prev_person_id,235);
610: hr_utility.set_location(' l_prev_period_of_service_id: '||l_prev_period_of_service_id,235);
611:
612: --IF l_prev_person_id <> l_person_id and l_prev_period_of_service_id <> l_period_of_service_id THEN
613: IF l_prev_period_of_service_id <> l_period_of_service_id THEN

Line 610: hr_utility.set_location(' l_prev_period_of_service_id: '||l_prev_period_of_service_id,235);

606: hr_utility.set_location(' l_person_id: '||l_person_id,235);
607: hr_utility.set_location(' l_period_of_service_id: '||l_period_of_service_id,235);
608: hr_utility.set_location(' l_assignment_number: '||l_assignment_number,235);
609: hr_utility.set_location(' l_prev_person_id: '||l_prev_person_id,235);
610: hr_utility.set_location(' l_prev_period_of_service_id: '||l_prev_period_of_service_id,235);
611:
612: --IF l_prev_person_id <> l_person_id and l_prev_period_of_service_id <> l_period_of_service_id THEN
613: IF l_prev_period_of_service_id <> l_period_of_service_id THEN
614: l_valid_assg := False;

Line 623: hr_utility.set_location(' l_csr_already_archived: '||l_csr_already_archived,240);

619: OPEN csr_already_archived(l_assg_id,g_business_group_id);
620: FETCH csr_already_archived INTO l_csr_already_archived;
621: CLOSE csr_already_archived;
622:
623: hr_utility.set_location(' l_csr_already_archived: '||l_csr_already_archived,240);
624: --
625: IF l_csr_already_archived ='N' THEN -- means report has not run previously
626:
627: hr_utility.set_location('any assg before:'||l_ass_check, 250);

Line 627: hr_utility.set_location('any assg before:'||l_ass_check, 250);

623: hr_utility.set_location(' l_csr_already_archived: '||l_csr_already_archived,240);
624: --
625: IF l_csr_already_archived ='N' THEN -- means report has not run previously
626:
627: hr_utility.set_location('any assg before:'||l_ass_check, 250);
628: l_element_name :='Already Submitted';
629:
630: OPEN csr_scr_ent_val(l_assg_id,l_element_name);
631: --hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',250);

Line 631: --hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',250);

627: hr_utility.set_location('any assg before:'||l_ass_check, 250);
628: l_element_name :='Already Submitted';
629:
630: OPEN csr_scr_ent_val(l_assg_id,l_element_name);
631: --hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',250);
632: FETCH csr_scr_ent_val INTO l_submitted;
633: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_submitted,250);
634: CLOSE csr_scr_ent_val;
635: --

Line 633: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_submitted,250);

629:
630: OPEN csr_scr_ent_val(l_assg_id,l_element_name);
631: --hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',250);
632: FETCH csr_scr_ent_val INTO l_submitted;
633: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_submitted,250);
634: CLOSE csr_scr_ent_val;
635: --
636: hr_utility.set_location('any assg before:'||l_ass_check, 250);
637: IF (l_submitted='N') then --not submitted online

Line 636: hr_utility.set_location('any assg before:'||l_ass_check, 250);

632: FETCH csr_scr_ent_val INTO l_submitted;
633: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_submitted,250);
634: CLOSE csr_scr_ent_val;
635: --
636: hr_utility.set_location('any assg before:'||l_ass_check, 250);
637: IF (l_submitted='N') then --not submitted online
638: l_element_name :='P45P3 Or P46';
639: OPEN csr_scr_ent_val(l_assg_id,l_element_name);
640: FETCH csr_scr_ent_val INTO l_file_type;

Line 641: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_file_type,245);

637: IF (l_submitted='N') then --not submitted online
638: l_element_name :='P45P3 Or P46';
639: OPEN csr_scr_ent_val(l_assg_id,l_element_name);
640: FETCH csr_scr_ent_val INTO l_file_type;
641: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor'||l_file_type,245);
642: CLOSE csr_scr_ent_val;
643:
644: IF (g_file_type='P46' AND l_file_type='Y') THEN --file type is p46
645: l_valid_assg := TRUE;

Line 653: hr_utility.set_location('inserting into ASSIGNMENT_ACTIONS', 255);

649: END IF; --not submitted online
650: --
651:
652: IF (l_valid_assg = TRUE) THEN
653: hr_utility.set_location('inserting into ASSIGNMENT_ACTIONS', 255);
654: SELECT pay_assignment_actions_s.nextval
655: INTO lockingactid
656: FROM dual;
657:

Line 658: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 1083);

654: SELECT pay_assignment_actions_s.nextval
655: INTO lockingactid
656: FROM dual;
657:
658: hr_utility.set_location('assignment_action_code, the assignment id finally picked up: '||l_assg_id, 1083);
659: -- Insert assignment into PAY_ASSIGNMENT_ACTIONS TABLE
660: hr_nonrun_asact.insact(lockingactid => lockingactid
661: ,assignid => l_assg_id
662: ,pactid => pactid

Line 725: hr_utility.set_location('Entering: pay_ie_p45p3_p46_pkg.archive_init: ',940);

721: l_telphone_no hr_locations_all.telephone_number_1%type;
722: l_fax_no hr_locations_all.telephone_number_2%type;
723: */
724: BEGIN
725: hr_utility.set_location('Entering: pay_ie_p45p3_p46_pkg.archive_init: ',940);
726:
727: OPEN csr_archive_effective_date(p_payroll_action_id);
728: FETCH csr_archive_effective_date
729: INTO g_archive_effective_date;

Line 778: hr_utility.set_location(' g_start_date: '||g_start_date, 945);

774: ,p_action_information12 => l_contact_name
775: ,p_action_information13 => l_telphone_no
776: ,p_action_information14 => l_fax_no);
777: */
778: hr_utility.set_location(' g_start_date: '||g_start_date, 945);
779: hr_utility.set_location(' g_end_date: '||g_end_date, 950);
780: hr_utility.set_location(' pay_ie_p45p3_p46_pkg.archive_init', 955);
781:
782: EXCEPTION

Line 779: hr_utility.set_location(' g_end_date: '||g_end_date, 950);

775: ,p_action_information13 => l_telphone_no
776: ,p_action_information14 => l_fax_no);
777: */
778: hr_utility.set_location(' g_start_date: '||g_start_date, 945);
779: hr_utility.set_location(' g_end_date: '||g_end_date, 950);
780: hr_utility.set_location(' pay_ie_p45p3_p46_pkg.archive_init', 955);
781:
782: EXCEPTION
783: WHEN Others THEN

Line 780: hr_utility.set_location(' pay_ie_p45p3_p46_pkg.archive_init', 955);

776: ,p_action_information14 => l_fax_no);
777: */
778: hr_utility.set_location(' g_start_date: '||g_start_date, 945);
779: hr_utility.set_location(' g_end_date: '||g_end_date, 950);
780: hr_utility.set_location(' pay_ie_p45p3_p46_pkg.archive_init', 955);
781:
782: EXCEPTION
783: WHEN Others THEN
784: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1211);

Line 784: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1211);

780: hr_utility.set_location(' pay_ie_p45p3_p46_pkg.archive_init', 955);
781:
782: EXCEPTION
783: WHEN Others THEN
784: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1211);
785:
786: END archive_init;
787: -----------------------------------------------------------------------
788: -- ARCHIVE_DATA

Line 909: hr_utility.set_location(' Entering pay_ie_p45p3_p46_pkg.ARCHIVE_CODE: ',1100);

905: k NUMBER(3) := 0;
906: -- Bug# 7005067
907:
908: BEGIN
909: hr_utility.set_location(' Entering pay_ie_p45p3_p46_pkg.ARCHIVE_CODE: ',1100);
910: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),1105);
911: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),1110);
912:
913: OPEN csr_person_details(p_assactid);

Line 910: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),1105);

906: -- Bug# 7005067
907:
908: BEGIN
909: hr_utility.set_location(' Entering pay_ie_p45p3_p46_pkg.ARCHIVE_CODE: ',1100);
910: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),1105);
911: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),1110);
912:
913: OPEN csr_person_details(p_assactid);
914: FETCH csr_person_details into l_person_details;

Line 911: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),1110);

907:
908: BEGIN
909: hr_utility.set_location(' Entering pay_ie_p45p3_p46_pkg.ARCHIVE_CODE: ',1100);
910: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),1105);
911: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),1110);
912:
913: OPEN csr_person_details(p_assactid);
914: FETCH csr_person_details into l_person_details;
915: CLOSE csr_person_details;

Line 918: hr_utility.set_location(' Before deleting the PL table pl_address. ',1100);

914: FETCH csr_person_details into l_person_details;
915: CLOSE csr_person_details;
916:
917: -- Bug# 7005067
918: hr_utility.set_location(' Before deleting the PL table pl_address. ',1100);
919: pl_address.delete;
920:
921: hr_utility.set_location(' Initializing the PL table pl_address. ',1100);
922: pl_address(1) := l_person_details.addr1;

Line 921: hr_utility.set_location(' Initializing the PL table pl_address. ',1100);

917: -- Bug# 7005067
918: hr_utility.set_location(' Before deleting the PL table pl_address. ',1100);
919: pl_address.delete;
920:
921: hr_utility.set_location(' Initializing the PL table pl_address. ',1100);
922: pl_address(1) := l_person_details.addr1;
923: pl_address(2) := l_person_details.addr2;
924: pl_address(3) := l_person_details.addr3;
925: pl_address(4) := l_person_details.City;

Line 929: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);

925: pl_address(4) := l_person_details.City;
926: pl_address(5) := l_person_details.COUNTY;
927: pl_address(6) := l_person_details.Country_Name;
928:
929: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
930:
931: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
932: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
933: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);

Line 931: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);

927: pl_address(6) := l_person_details.Country_Name;
928:
929: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
930:
931: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
932: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
933: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
934: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
935: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);

Line 932: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);

928:
929: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
930:
931: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
932: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
933: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
934: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
935: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
936: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);

Line 933: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);

929: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
930:
931: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
932: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
933: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
934: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
935: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
936: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
937:

Line 934: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);

930:
931: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
932: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
933: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
934: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
935: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
936: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
937:
938: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);

Line 935: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);

931: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
932: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
933: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
934: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
935: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
936: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
937:
938: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
939: pl_address_final.delete;

Line 936: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);

932: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
933: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
934: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
935: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
936: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
937:
938: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
939: pl_address_final.delete;
940: hr_utility.set_location(' Initializing the PL table pl_address_final. ',1100);

Line 938: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);

934: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
935: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
936: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
937:
938: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
939: pl_address_final.delete;
940: hr_utility.set_location(' Initializing the PL table pl_address_final. ',1100);
941:
942: FOR j in 1..pl_address.LAST

Line 940: hr_utility.set_location(' Initializing the PL table pl_address_final. ',1100);

936: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
937:
938: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
939: pl_address_final.delete;
940: hr_utility.set_location(' Initializing the PL table pl_address_final. ',1100);
941:
942: FOR j in 1..pl_address.LAST
943: LOOP
944: IF pl_address(j) IS NOT NULL THEN

Line 947: hr_utility.set_location('pl_address_final'||k||'--'||pl_address_final(k),1100);

943: LOOP
944: IF pl_address(j) IS NOT NULL THEN
945: k:=k+1;
946: pl_address_final(k) := pl_address(j);
947: hr_utility.set_location('pl_address_final'||k||'--'||pl_address_final(k),1100);
948: END IF;
949: END LOOP;
950:
951: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);

Line 951: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);

947: hr_utility.set_location('pl_address_final'||k||'--'||pl_address_final(k),1100);
948: END IF;
949: END LOOP;
950:
951: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);
952:
953:
954:
955: hr_utility.set_location(' Re Initializing the cursor record l_person_details with actual values. ',1100);

Line 955: hr_utility.set_location(' Re Initializing the cursor record l_person_details with actual values. ',1100);

951: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);
952:
953:
954:
955: hr_utility.set_location(' Re Initializing the cursor record l_person_details with actual values. ',1100);
956: hr_utility.set_location(' pl_address_final.COUNT: '||pl_address_final.COUNT,1100);
957:
958: IF pl_address_final.COUNT > 0 THEN
959:

Line 956: hr_utility.set_location(' pl_address_final.COUNT: '||pl_address_final.COUNT,1100);

952:
953:
954:
955: hr_utility.set_location(' Re Initializing the cursor record l_person_details with actual values. ',1100);
956: hr_utility.set_location(' pl_address_final.COUNT: '||pl_address_final.COUNT,1100);
957:
958: IF pl_address_final.COUNT > 0 THEN
959:
960: l_person_details.addr1 := NULL;

Line 967: hr_utility.set_location(' Inside the loop of PL table pl_address_final',1100);

963: l_person_details.addr4 := NULL;
964:
965: FOR l in 1..pl_address_final.LAST
966: LOOP
967: hr_utility.set_location(' Inside the loop of PL table pl_address_final',1100);
968: BEGIN
969: IF l = 1 THEN
970: hr_utility.set_location(' l_person_details.addr1 ',1100);
971: l_person_details.addr1 := pl_address_final(1);

Line 970: hr_utility.set_location(' l_person_details.addr1 ',1100);

966: LOOP
967: hr_utility.set_location(' Inside the loop of PL table pl_address_final',1100);
968: BEGIN
969: IF l = 1 THEN
970: hr_utility.set_location(' l_person_details.addr1 ',1100);
971: l_person_details.addr1 := pl_address_final(1);
972: hr_utility.set_location(' l_person_details.addr1 ',1101);
973: END IF;
974: --

Line 972: hr_utility.set_location(' l_person_details.addr1 ',1101);

968: BEGIN
969: IF l = 1 THEN
970: hr_utility.set_location(' l_person_details.addr1 ',1100);
971: l_person_details.addr1 := pl_address_final(1);
972: hr_utility.set_location(' l_person_details.addr1 ',1101);
973: END IF;
974: --
975: IF l = 2 THEN
976: hr_utility.set_location(' l_person_details.addr2 ',1102);

Line 976: hr_utility.set_location(' l_person_details.addr2 ',1102);

972: hr_utility.set_location(' l_person_details.addr1 ',1101);
973: END IF;
974: --
975: IF l = 2 THEN
976: hr_utility.set_location(' l_person_details.addr2 ',1102);
977: l_person_details.addr2 := pl_address_final(2);
978: hr_utility.set_location(' l_person_details.addr2 ',1103);
979: END IF;
980: --

Line 978: hr_utility.set_location(' l_person_details.addr2 ',1103);

974: --
975: IF l = 2 THEN
976: hr_utility.set_location(' l_person_details.addr2 ',1102);
977: l_person_details.addr2 := pl_address_final(2);
978: hr_utility.set_location(' l_person_details.addr2 ',1103);
979: END IF;
980: --
981: IF l = 3 THEN
982: hr_utility.set_location(' l_person_details.addr3 ',1104);

Line 982: hr_utility.set_location(' l_person_details.addr3 ',1104);

978: hr_utility.set_location(' l_person_details.addr2 ',1103);
979: END IF;
980: --
981: IF l = 3 THEN
982: hr_utility.set_location(' l_person_details.addr3 ',1104);
983: l_person_details.addr3 := pl_address_final(3);
984: hr_utility.set_location(' l_person_details.addr3 ',1105);
985: END IF;
986: --

Line 984: hr_utility.set_location(' l_person_details.addr3 ',1105);

980: --
981: IF l = 3 THEN
982: hr_utility.set_location(' l_person_details.addr3 ',1104);
983: l_person_details.addr3 := pl_address_final(3);
984: hr_utility.set_location(' l_person_details.addr3 ',1105);
985: END IF;
986: --
987: IF l = 4 THEN
988: hr_utility.set_location(' l_person_details.addr4 ',1106);

Line 988: hr_utility.set_location(' l_person_details.addr4 ',1106);

984: hr_utility.set_location(' l_person_details.addr3 ',1105);
985: END IF;
986: --
987: IF l = 4 THEN
988: hr_utility.set_location(' l_person_details.addr4 ',1106);
989: l_person_details.addr4 := pl_address_final(4);
990: hr_utility.set_location(' l_person_details.addr4 ',1107);
991: END IF;
992: EXCEPTION

Line 990: hr_utility.set_location(' l_person_details.addr4 ',1107);

986: --
987: IF l = 4 THEN
988: hr_utility.set_location(' l_person_details.addr4 ',1106);
989: l_person_details.addr4 := pl_address_final(4);
990: hr_utility.set_location(' l_person_details.addr4 ',1107);
991: END IF;
992: EXCEPTION
993: WHEN NO_DATA_FOUND THEN
994: NULL;

Line 998: hr_utility.set_location(' After Re Initializing the cursor record l_person_details with actual values. ',1100);

994: NULL;
995: END;
996: END LOOP;
997: END IF;
998: hr_utility.set_location(' After Re Initializing the cursor record l_person_details with actual values. ',1100);
999: -- Bug# 7005067
1000:
1001: l_per_emp_start_date := fnd_date.date_to_canonical(l_person_details.emp_start_date);
1002:

Line 1007: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',230);

1003: i:=1;
1004: l_refund :='false';
1005: OPEN csr_get_assg_detail(p_assactid);
1006: LOOP
1007: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',230);
1008: FETCH csr_get_assg_detail INTO l_get_assg_detail(i).i_name,l_get_assg_detail(i).i_value;
1009: i:=i+1;
1010: EXIT WHEN csr_get_assg_detail%notfound;
1011: END LOOP;

Line 1037: hr_utility.set_location('archive data',1200);

1033: ELSE
1034: null;
1035: END CASE;
1036: END LOOP;
1037: hr_utility.set_location('archive data',1200);
1038: --
1039: -- archive the details
1040: IF l_person_details.ppsn IS NOT NULL
1041: AND l_person_details.surname IS NOT NULL

Line 1081: hr_utility.set_location('after archive data',1200);

1077: , p_action_information23 => l_refund
1078: , p_action_information24 => l_paye_employer
1079: );
1080:
1081: hr_utility.set_location('after archive data',1200);
1082: ELSIF l_person_details.ppsn IS NULL THEN
1083: Fnd_file.put_line(FND_FILE.LOG,'Employee PPSN number is missing. Assignment Number: '||l_person_details.unit);
1084: l_errflag := 'Y';
1085: ELSIF l_person_details.surname IS NULL THEN

Line 1120: hr_utility.set_location('Leaving archive ',20);

1116: UPDATE pay_element_entry_values_f set screen_entry_value='Y'
1117: WHERE CURRENT OF csr_archive_processed;
1118: close csr_archive_processed;
1119: */ --
1120: hr_utility.set_location('Leaving archive ',20);
1121: --update pay_element_entries_f set screen_entry_value='Y' where
1122: Exception
1123: WHEN l_p45_exception THEN
1124: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);

Line 1124: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);

1120: hr_utility.set_location('Leaving archive ',20);
1121: --update pay_element_entries_f set screen_entry_value='Y' where
1122: Exception
1123: WHEN l_p45_exception THEN
1124: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);
1125: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','P46 part3 XML Process errors out');
1126: END archive_data;
1127: -----------------------------------------------------------------------
1128: --C2B

Line 1138: Hr_Utility.set_location('Entering: pay_ie_p45p3_p46_pkg.c2b',260);

1134: buffer RAW( 32767 );
1135: res BLOB;
1136: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
1137: BEGIN
1138: Hr_Utility.set_location('Entering: pay_ie_p45p3_p46_pkg.c2b',260);
1139: DBMS_LOB.createTemporary( res, TRUE );
1140: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
1141:
1142:

Line 1154: Hr_Utility.set_location('Leaving: pay_ie_p45p3_p46_pkg.c2b',265);

1150: pos := pos + 16000;
1151: EXIT WHEN pos > lob_len;
1152: END LOOP;
1153:
1154: Hr_Utility.set_location('Leaving: pay_ie_p45p3_p46_pkg.c2b',265);
1155: RETURN res; -- res is OPEN here
1156: END c2b;
1157: -----------------------------------------------------------------------
1158: -- GEN_BODY_XML

Line 1201: hr_utility.set_location(' Entering: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 270);

1197: l_sur_name varchar2(1000);
1198: l_first_name varchar2(1000);
1199:
1200: BEGIN
1201: hr_utility.set_location(' Entering: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 270);
1202:
1203: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1204: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
1205:

Line 1206: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),275);

1202:
1203: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1204: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
1205:
1206: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),275);
1207: hr_utility.set_location('l_asg_action_id '||TO_CHAR(l_asg_action_id),280);
1208:
1209: FOR l_emp_information IN c_action_information('IE_P45P3_P46_DETAILS',l_asg_action_id)
1210: LOOP

Line 1207: hr_utility.set_location('l_asg_action_id '||TO_CHAR(l_asg_action_id),280);

1203: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1204: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
1205:
1206: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),275);
1207: hr_utility.set_location('l_asg_action_id '||TO_CHAR(l_asg_action_id),280);
1208:
1209: FOR l_emp_information IN c_action_information('IE_P45P3_P46_DETAILS',l_asg_action_id)
1210: LOOP
1211: hr_utility.set_location('Inside IE P45P3 P46',285);

Line 1211: hr_utility.set_location('Inside IE P45P3 P46',285);

1207: hr_utility.set_location('l_asg_action_id '||TO_CHAR(l_asg_action_id),280);
1208:
1209: FOR l_emp_information IN c_action_information('IE_P45P3_P46_DETAILS',l_asg_action_id)
1210: LOOP
1211: hr_utility.set_location('Inside IE P45P3 P46',285);
1212: IF( g_file_type='P45P3') THEN
1213: l_emp_information.addr1:=NULL;
1214: l_emp_information.addr2:=NULL;
1215: l_emp_information.addr3:=NULL;

Line 1259: hr_utility.set_location('Before leaving gen_body_xml: length(l_string) = '||length(l_string),290);

1255: l_string := l_string ||''||EOL ;
1256: --
1257: END LOOP;
1258:
1259: hr_utility.set_location('Before leaving gen_body_xml: length(l_string) = '||length(l_string),290);
1260: l_clob := l_clob||l_string;
1261:
1262: IF l_clob IS NOT NULL THEN
1263: l_blob := c2b(l_clob);

Line 1269: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1213);

1265: END IF;
1266:
1267: EXCEPTION
1268: WHEN Others THEN
1269: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1213);
1270: END gen_body_xml;
1271: -----------------------------------------------------------------------
1272: -- GEN_HEADER_XML
1273: -----------------------------------------------------------------------

Line 1310: hr_utility.set_location ('Entering '||l_proc,1500);

1306:
1307:
1308: BEGIN
1309: l_proc := g_package || 'gen_header_xml';
1310: hr_utility.set_location ('Entering '||l_proc,1500);
1311:
1312: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1313: hr_utility.set_location('Inside pay_ie_p45p3_p46_pkg.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
1314:

Line 1313: hr_utility.set_location('Inside pay_ie_p45p3_p46_pkg.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);

1309: l_proc := g_package || 'gen_header_xml';
1310: hr_utility.set_location ('Entering '||l_proc,1500);
1311:
1312: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1313: hr_utility.set_location('Inside pay_ie_p45p3_p46_pkg.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
1314:
1315: OPEN c_get_header(l_payroll_action_id);
1316: FETCH c_get_header into l_header;
1317: CLOSE c_get_header;

Line 1347: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1214);

1343: END IF;
1344:
1345: EXCEPTION
1346: WHEN Others THEN
1347: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1214);
1348:
1349: END gen_header_xml;
1350: -----------------------------------------------------------------------
1351: -- GEN_FOOTER_XML

Line 1359: hr_utility.set_location ('Entering '||l_proc, 1520);

1355: l_buf VARCHAR2(2000);
1356: l_proc VARCHAR2(100);
1357: begin
1358: l_proc := g_package || 'gen_footer_xml';
1359: hr_utility.set_location ('Entering '||l_proc, 1520);
1360: --
1361: --l_buf := l_buf || '

'||EOL ;
1363: l_buf := l_buf || ''||EOL ;

Line 1366: hr_utility.set_location ('Leaving '||l_proc, 1530);

1362: --l_buf := l_buf || ''||EOL ;
1363: l_buf := l_buf || ''||EOL ;
1364: --
1365: pay_core_files.write_to_magtape_lob(l_buf);
1366: hr_utility.set_location ('Leaving '||l_proc, 1530);
1367:
1368: end gen_footer_xml;
1369:
1370: END PAY_IE_P45PART3_P46_PKG;