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.PAY_IE_P45PART3_P46_PKG dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

914: k NUMBER(3) := 0;
915: -- Bug# 7005067
916:
917: BEGIN
918: hr_utility.set_location(' Entering pay_ie_p45p3_p46_pkg.ARCHIVE_CODE: ',1100);
919: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),1105);
920: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),1110);
921:
922: OPEN csr_person_details(p_assactid);

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

915: -- Bug# 7005067
916:
917: BEGIN
918: hr_utility.set_location(' Entering pay_ie_p45p3_p46_pkg.ARCHIVE_CODE: ',1100);
919: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),1105);
920: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),1110);
921:
922: OPEN csr_person_details(p_assactid);
923: FETCH csr_person_details into l_person_details;

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

916:
917: BEGIN
918: hr_utility.set_location(' Entering pay_ie_p45p3_p46_pkg.ARCHIVE_CODE: ',1100);
919: hr_utility.set_location('g_pact_id '||TO_CHAR(g_pact_id),1105);
920: hr_utility.set_location('p_assignment_action_id '||TO_CHAR(p_assactid),1110);
921:
922: OPEN csr_person_details(p_assactid);
923: FETCH csr_person_details into l_person_details;
924: CLOSE csr_person_details;

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

923: FETCH csr_person_details into l_person_details;
924: CLOSE csr_person_details;
925:
926: -- Bug# 7005067
927: hr_utility.set_location(' Before deleting the PL table pl_address. ',1100);
928: pl_address.delete;
929:
930: hr_utility.set_location(' Initializing the PL table pl_address. ',1100);
931: pl_address(1) := l_person_details.addr1;

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

926: -- Bug# 7005067
927: hr_utility.set_location(' Before deleting the PL table pl_address. ',1100);
928: pl_address.delete;
929:
930: hr_utility.set_location(' Initializing the PL table pl_address. ',1100);
931: pl_address(1) := l_person_details.addr1;
932: pl_address(2) := l_person_details.addr2;
933: pl_address(3) := l_person_details.addr3;
934: pl_address(4) := l_person_details.City;

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

934: pl_address(4) := l_person_details.City;
935: pl_address(5) := l_person_details.COUNTY;
936: pl_address(6) := l_person_details.Country_Name;
937:
938: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
939:
940: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
941: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
942: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);

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

936: pl_address(6) := l_person_details.Country_Name;
937:
938: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
939:
940: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
941: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
942: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
943: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
944: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);

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

937:
938: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
939:
940: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
941: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
942: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
943: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
944: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
945: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);

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

938: hr_utility.set_location(' pl_address.COUNT: '||pl_address.COUNT,1100);
939:
940: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
941: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
942: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
943: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
944: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
945: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
946:

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

939:
940: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
941: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
942: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
943: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
944: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
945: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
946:
947: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);

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

940: hr_utility.set_location(' pl_address(1): '||pl_address(1),1100);
941: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
942: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
943: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
944: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
945: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
946:
947: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
948: pl_address_final.delete;

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

941: hr_utility.set_location(' pl_address(2): '||pl_address(2),1100);
942: hr_utility.set_location(' pl_address(3): '||pl_address(3),1100);
943: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
944: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
945: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
946:
947: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
948: pl_address_final.delete;
949: hr_utility.set_location(' Initializing the PL table pl_address_final. ',1100);

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

943: hr_utility.set_location(' pl_address(4): '||pl_address(4),1100);
944: hr_utility.set_location(' pl_address(5): '||pl_address(5),1100);
945: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
946:
947: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
948: pl_address_final.delete;
949: hr_utility.set_location(' Initializing the PL table pl_address_final. ',1100);
950:
951: FOR j in 1..pl_address.LAST

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

945: hr_utility.set_location(' pl_address(6): '||pl_address(6),1100);
946:
947: hr_utility.set_location(' Before deleting the PL table pl_address_final. ',1100);
948: pl_address_final.delete;
949: hr_utility.set_location(' Initializing the PL table pl_address_final. ',1100);
950:
951: FOR j in 1..pl_address.LAST
952: LOOP
953: IF pl_address(j) IS NOT NULL THEN

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

952: LOOP
953: IF pl_address(j) IS NOT NULL THEN
954: k:=k+1;
955: pl_address_final(k) := pl_address(j);
956: hr_utility.set_location('pl_address_final'||k||'--'||pl_address_final(k),1100);
957: END IF;
958: END LOOP;
959:
960: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);

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

956: hr_utility.set_location('pl_address_final'||k||'--'||pl_address_final(k),1100);
957: END IF;
958: END LOOP;
959:
960: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);
961:
962:
963:
964: hr_utility.set_location(' Re Initializing the cursor record l_person_details with actual values. ',1100);

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

960: hr_utility.set_location(' Re Initializing the record l_person_details. ',1100);
961:
962:
963:
964: hr_utility.set_location(' Re Initializing the cursor record l_person_details with actual values. ',1100);
965: hr_utility.set_location(' pl_address_final.COUNT: '||pl_address_final.COUNT,1100);
966:
967: IF pl_address_final.COUNT > 0 THEN
968:

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

961:
962:
963:
964: hr_utility.set_location(' Re Initializing the cursor record l_person_details with actual values. ',1100);
965: hr_utility.set_location(' pl_address_final.COUNT: '||pl_address_final.COUNT,1100);
966:
967: IF pl_address_final.COUNT > 0 THEN
968:
969: l_person_details.addr1 := NULL;

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

972: l_person_details.addr4 := NULL;
973:
974: FOR l in 1..pl_address_final.LAST
975: LOOP
976: hr_utility.set_location(' Inside the loop of PL table pl_address_final',1100);
977: BEGIN
978: IF l = 1 THEN
979: hr_utility.set_location(' l_person_details.addr1 ',1100);
980: l_person_details.addr1 := pl_address_final(1);

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

975: LOOP
976: hr_utility.set_location(' Inside the loop of PL table pl_address_final',1100);
977: BEGIN
978: IF l = 1 THEN
979: hr_utility.set_location(' l_person_details.addr1 ',1100);
980: l_person_details.addr1 := pl_address_final(1);
981: hr_utility.set_location(' l_person_details.addr1 ',1101);
982: END IF;
983: --

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

977: BEGIN
978: IF l = 1 THEN
979: hr_utility.set_location(' l_person_details.addr1 ',1100);
980: l_person_details.addr1 := pl_address_final(1);
981: hr_utility.set_location(' l_person_details.addr1 ',1101);
982: END IF;
983: --
984: IF l = 2 THEN
985: hr_utility.set_location(' l_person_details.addr2 ',1102);

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

981: hr_utility.set_location(' l_person_details.addr1 ',1101);
982: END IF;
983: --
984: IF l = 2 THEN
985: hr_utility.set_location(' l_person_details.addr2 ',1102);
986: l_person_details.addr2 := pl_address_final(2);
987: hr_utility.set_location(' l_person_details.addr2 ',1103);
988: END IF;
989: --

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

983: --
984: IF l = 2 THEN
985: hr_utility.set_location(' l_person_details.addr2 ',1102);
986: l_person_details.addr2 := pl_address_final(2);
987: hr_utility.set_location(' l_person_details.addr2 ',1103);
988: END IF;
989: --
990: IF l = 3 THEN
991: hr_utility.set_location(' l_person_details.addr3 ',1104);

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

987: hr_utility.set_location(' l_person_details.addr2 ',1103);
988: END IF;
989: --
990: IF l = 3 THEN
991: hr_utility.set_location(' l_person_details.addr3 ',1104);
992: l_person_details.addr3 := pl_address_final(3);
993: hr_utility.set_location(' l_person_details.addr3 ',1105);
994: END IF;
995: --

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

989: --
990: IF l = 3 THEN
991: hr_utility.set_location(' l_person_details.addr3 ',1104);
992: l_person_details.addr3 := pl_address_final(3);
993: hr_utility.set_location(' l_person_details.addr3 ',1105);
994: END IF;
995: --
996: IF l = 4 THEN
997: hr_utility.set_location(' l_person_details.addr4 ',1106);

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

993: hr_utility.set_location(' l_person_details.addr3 ',1105);
994: END IF;
995: --
996: IF l = 4 THEN
997: hr_utility.set_location(' l_person_details.addr4 ',1106);
998: l_person_details.addr4 := pl_address_final(4);
999: hr_utility.set_location(' l_person_details.addr4 ',1107);
1000: END IF;
1001: EXCEPTION

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

995: --
996: IF l = 4 THEN
997: hr_utility.set_location(' l_person_details.addr4 ',1106);
998: l_person_details.addr4 := pl_address_final(4);
999: hr_utility.set_location(' l_person_details.addr4 ',1107);
1000: END IF;
1001: EXCEPTION
1002: WHEN NO_DATA_FOUND THEN
1003: NULL;

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

1003: NULL;
1004: END;
1005: END LOOP;
1006: END IF;
1007: hr_utility.set_location(' After Re Initializing the cursor record l_person_details with actual values. ',1100);
1008: -- Bug# 7005067
1009:
1010: l_per_emp_start_date := fnd_date.date_to_canonical(l_person_details.emp_start_date);
1011:

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

1013: l_refund :='false';
1014: l_refund_usc :='false'; -- BUG 13359530
1015: OPEN csr_get_assg_detail(p_assactid);
1016: LOOP
1017: hr_utility.set_location(' Inside ass action code, inside loop for ref cursor',230);
1018: FETCH csr_get_assg_detail INTO l_get_assg_detail(i).i_name,l_get_assg_detail(i).i_value;
1019: i:=i+1;
1020: EXIT WHEN csr_get_assg_detail%notfound;
1021: END LOOP;

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

1054: ELSE
1055: null;
1056: END CASE;
1057: END LOOP;
1058: hr_utility.set_location('archive data',1200);
1059: --
1060: -- archive the details
1061: IF l_person_details.ppsn IS NOT NULL
1062: AND l_person_details.surname IS NOT NULL

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

1103: , p_action_information28 => l_usc_employment
1104: , p_action_information29 => l_refund_usc
1105: );
1106:
1107: hr_utility.set_location('after archive data',1200);
1108: ELSIF l_person_details.ppsn IS NULL THEN
1109: Fnd_file.put_line(FND_FILE.LOG,'Employee PPSN number is missing. Assignment Number: '||l_person_details.unit);
1110: l_errflag := 'Y';
1111: ELSIF l_person_details.surname IS NULL THEN

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

1142: UPDATE pay_element_entry_values_f set screen_entry_value='Y'
1143: WHERE CURRENT OF csr_archive_processed;
1144: close csr_archive_processed;
1145: */ --
1146: hr_utility.set_location('Leaving archive ',20);
1147: --update pay_element_entries_f set screen_entry_value='Y' where
1148: Exception
1149: WHEN l_p45_exception THEN
1150: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);

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

1146: hr_utility.set_location('Leaving archive ',20);
1147: --update pay_element_entries_f set screen_entry_value='Y' where
1148: Exception
1149: WHEN l_p45_exception THEN
1150: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1223);
1151: error_message := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','P46 part3 XML Process errors out');
1152: END archive_data;
1153: -----------------------------------------------------------------------
1154: --C2B

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

1160: buffer RAW( 32767 );
1161: res BLOB;
1162: lob_len PLS_INTEGER := DBMS_LOB.getLength( c );
1163: BEGIN
1164: Hr_Utility.set_location('Entering: pay_ie_p45p3_p46_pkg.c2b',260);
1165: DBMS_LOB.createTemporary( res, TRUE );
1166: DBMS_LOB.OPEN( res, DBMS_LOB.LOB_ReadWrite );
1167:
1168:

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

1176: pos := pos + 16000;
1177: EXIT WHEN pos > lob_len;
1178: END LOOP;
1179:
1180: Hr_Utility.set_location('Leaving: pay_ie_p45p3_p46_pkg.c2b',265);
1181: RETURN res; -- res is OPEN here
1182: END c2b;
1183: -----------------------------------------------------------------------
1184: -- GEN_BODY_XML

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

1235: l_addressline4 varchar2(100);
1236: --7529405
1237: l_start_date VARCHAR2(30); -- bug 13359530
1238: BEGIN
1239: hr_utility.set_location(' Entering: pay_ie_p45part3_p46_pkg_test.gen_body_xml: ', 270);
1240:
1241: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1242: l_asg_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
1243:

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

1244: PAY_IE_P45PART3_P46_PKG.get_parameters (
1245: p_payroll_action_id => l_payroll_action_id
1246: , p_token_name => 'START_DATE'
1247: , p_token_value => l_start_date);
1248: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),275);
1249: hr_utility.set_location('l_asg_action_id '||TO_CHAR(l_asg_action_id),280);
1250:
1251: FOR l_emp_information IN c_action_information('IE_P45P3_P46_DETAILS',l_asg_action_id)
1252: LOOP

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

1245: p_payroll_action_id => l_payroll_action_id
1246: , p_token_name => 'START_DATE'
1247: , p_token_value => l_start_date);
1248: hr_utility.set_location('l_payroll_action_id '||TO_CHAR(l_payroll_action_id),275);
1249: hr_utility.set_location('l_asg_action_id '||TO_CHAR(l_asg_action_id),280);
1250:
1251: FOR l_emp_information IN c_action_information('IE_P45P3_P46_DETAILS',l_asg_action_id)
1252: LOOP
1253: hr_utility.set_location('Inside IE P45P3 P46',285);

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

1249: hr_utility.set_location('l_asg_action_id '||TO_CHAR(l_asg_action_id),280);
1250:
1251: FOR l_emp_information IN c_action_information('IE_P45P3_P46_DETAILS',l_asg_action_id)
1252: LOOP
1253: hr_utility.set_location('Inside IE P45P3 P46',285);
1254: IF( g_file_type='P45P3') THEN
1255: l_emp_information.addr1:=NULL;
1256: l_emp_information.addr2:=NULL;
1257: l_emp_information.addr3:=NULL;

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

1322: l_string := l_string ||''||EOL ;
1323: --
1324: END LOOP;
1325:
1326: hr_utility.set_location('Before leaving gen_body_xml: length(l_string) = '||length(l_string),290);
1327: l_clob := l_clob||l_string;
1328:
1329: IF l_clob IS NOT NULL THEN
1330: l_blob := c2b(l_clob);

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

1332: END IF;
1333:
1334: EXCEPTION
1335: WHEN Others THEN
1336: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1213);
1337: END gen_body_xml;
1338: -----------------------------------------------------------------------
1339: -- GEN_HEADER_XML
1340: -----------------------------------------------------------------------

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

1381: --7529405
1382: l_start_date VARCHAR2(30);
1383: BEGIN
1384: l_proc := g_package || 'gen_header_xml';
1385: hr_utility.set_location ('Entering '||l_proc,1500);
1386:
1387: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1388: hr_utility.set_location('Inside pay_ie_p45p3_p46_pkg.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
1389: PAY_IE_P45PART3_P46_PKG.get_parameters (

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

1384: l_proc := g_package || 'gen_header_xml';
1385: hr_utility.set_location ('Entering '||l_proc,1500);
1386:
1387: l_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1388: hr_utility.set_location('Inside pay_ie_p45p3_p46_pkg.gen_header_xml,l_payroll_action_id: '||l_payroll_action_id,300);
1389: PAY_IE_P45PART3_P46_PKG.get_parameters (
1390: p_payroll_action_id => l_payroll_action_id
1391: , p_token_name => 'START_DATE'
1392: , p_token_value => l_start_date);

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

1389: PAY_IE_P45PART3_P46_PKG.get_parameters (
1390: p_payroll_action_id => l_payroll_action_id
1391: , p_token_name => 'START_DATE'
1392: , p_token_value => l_start_date);
1393: hr_utility.set_location('Inside pay_ie_p45p3_p46_pkg.gen_header_xml,l_payroll_action_id: '||l_start_date,300);
1394:
1395: IF (to_number(to_char(to_date(l_start_date,'yyyy/mm/dd'),'yyyy')) >= 2012) THEN -- 13359530
1396: l_formversion := '2';
1397: END IF;

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

1448: END IF;
1449:
1450: EXCEPTION
1451: WHEN Others THEN
1452: Hr_Utility.set_location('..'||'SQL-ERRM :'||SQLERRM,1214);
1453:
1454: END gen_header_xml;
1455: -----------------------------------------------------------------------
1456: -- GEN_FOOTER_XML

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

1460: l_buf VARCHAR2(2000);
1461: l_proc VARCHAR2(100);
1462: begin
1463: l_proc := g_package || 'gen_footer_xml';
1464: hr_utility.set_location ('Entering '||l_proc, 1520);
1465: --
1466: --l_buf := l_buf || '

'||EOL ;
1468: l_buf := l_buf || ''||EOL ;

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

1467: --l_buf := l_buf || ''||EOL ;
1468: l_buf := l_buf || ''||EOL ;
1469: --
1470: pay_core_files.write_to_magtape_lob(l_buf);
1471: hr_utility.set_location ('Leaving '||l_proc, 1530);
1472:
1473: end gen_footer_xml;
1474:
1475: END PAY_IE_P45PART3_P46_PKG;