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_NL_NSI_PROCESS dependencies on HR_UTILITY

Line 32: hr_utility.set_location('Entering get_parameter',52);

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

Line 57: hr_utility.set_location('Leaving get_parameter',53);

53: - instr(l_parameter,':',1,p_segment_number));
54: END IF;
55: END IF;
56: --
57: hr_utility.set_location('Leaving get_parameter',53);
58: RETURN l_parameter;
59: END get_parameter;
60:
61: /*-----------------------------------------------------------------------------

Line 99: hr_utility.set_location('Entering get_all_parameters',51);

95: l_proc VARCHAR2(240):= g_package||' get_all_parameters ';
96: --
97: BEGIN
98: --
99: hr_utility.set_location('Entering get_all_parameters',51);
100:
101: OPEN csr_parameter_info (p_payroll_action_id);
102: FETCH csr_parameter_info INTO
103: p_employer_id,p_si_provider_id,p_nsi_month

Line 108: hr_utility.set_location('Leaving get_all_parameters',54);

104: ,p_output_media_type,p_payroll_id,p_withdraw_asg_set_id
105: ,p_business_group_id,p_report_type;
106: CLOSE csr_parameter_info;
107: --
108: hr_utility.set_location('Leaving get_all_parameters',54);
109:
110: END get_all_parameters;
111:
112: /*-------------------------------------------------------------------------------

Line 142: hr_utility.set_location('Checking Field '||p_field,425);

138: v_message_text fnd_new_messages.message_text%TYPE;
139: v_employee_dat VARCHAR2(255);
140: v_label_desc hr_lookups.meaning%TYPE;
141: Begin
142: hr_utility.set_location('Checking Field '||p_field,425);
143: If p_value is null then
144: v_label_desc := hr_general.decode_lookup('HR_NL_REPORT_LABELS', p_field);
145: v_employee_dat :=RPAD(SUBSTR(g_assignment_number,1,20),20)
146: ||' '||RPAD(SUBSTR(g_full_name,1,25),25)

Line 149: hr_utility.set_message(801,p_message_name);

145: v_employee_dat :=RPAD(SUBSTR(g_assignment_number,1,20),20)
146: ||' '||RPAD(SUBSTR(g_full_name,1,25),25)
147: ||' '||RPAD(SUBSTR(v_label_desc,1,25),25)
148: ||' '||RPAD(SUBSTR(g_error_flag,1,15),15);
149: hr_utility.set_message(801,p_message_name);
150: v_message_text :=SUBSTR(fnd_message.get,1,70);
151: g_error_count := NVL(g_error_count,0) +1;
152: FND_FILE.PUT_LINE(FND_FILE.LOG, v_employee_dat||' '||v_message_text);
153: end if;

Line 235: --hr_utility.trace_on(NULL,'NL_NSI');

231:
232: Begin
233:
234: --
235: --hr_utility.trace_on(NULL,'NL_NSI');
236: hr_utility.set_location('Entering Range Code',50);
237: --
238: --
239:

Line 236: hr_utility.set_location('Entering Range Code',50);

232: Begin
233:
234: --
235: --hr_utility.trace_on(NULL,'NL_NSI');
236: hr_utility.set_location('Entering Range Code',50);
237: --
238: --
239:
240: g_error_count := 0;

Line 255: hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);

251: ,p_withdraw_asg_set_id => l_withdraw_asg_set_id
252: ,p_report_type => l_report_type
253: );
254:
255: hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);
256: hr_utility.set_location('NSI Archive p_payroll_action_id '||pactid,425);
257: hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
258: hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
259: hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);

Line 256: hr_utility.set_location('NSI Archive p_payroll_action_id '||pactid,425);

252: ,p_report_type => l_report_type
253: );
254:
255: hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);
256: hr_utility.set_location('NSI Archive p_payroll_action_id '||pactid,425);
257: hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
258: hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
259: hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
260: hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);

Line 257: hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);

253: );
254:
255: hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);
256: hr_utility.set_location('NSI Archive p_payroll_action_id '||pactid,425);
257: hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
258: hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
259: hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
260: hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
261: hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);

Line 258: hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);

254:
255: hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);
256: hr_utility.set_location('NSI Archive p_payroll_action_id '||pactid,425);
257: hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
258: hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
259: hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
260: hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
261: hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
262: hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);

Line 259: hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);

255: hr_utility.set_location('g_payroll_action_id = ' || g_payroll_action_id,55);
256: hr_utility.set_location('NSI Archive p_payroll_action_id '||pactid,425);
257: hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
258: hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
259: hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
260: hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
261: hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
262: hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
263: hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);

Line 260: hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);

256: hr_utility.set_location('NSI Archive p_payroll_action_id '||pactid,425);
257: hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
258: hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
259: hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
260: hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
261: hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
262: hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
263: hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);
264: hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);

Line 261: hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);

257: hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
258: hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
259: hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
260: hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
261: hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
262: hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
263: hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);
264: hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);
265: --

Line 262: hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);

258: hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
259: hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
260: hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
261: hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
262: hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
263: hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);
264: hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);
265: --
266:

Line 263: hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);

259: hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
260: hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
261: hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
262: hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
263: hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);
264: hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);
265: --
266:
267: --Determine the Process Dates

Line 264: hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);

260: hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
261: hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
262: hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
263: hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);
264: hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);
265: --
266:
267: --Determine the Process Dates
268: l_NSI_Process_Date := LAST_DAY(TO_DATE('01'||l_nsi_month,'DDMMYYYY'));

Line 283: --hr_utility.set_location('l_Sender_Reg_Number :'||l_Sender_Reg_Number,425);

279: END IF;
280: CLOSE csr_get_sender_det;
281: l_Sender_Report_Name := UPPER(RPAD(NVL(l_Sender_Report_Name,' '),22));
282: l_Employer_Name := UPPER(RPAD(NVL(l_Employer_Name,' '),22));
283: --hr_utility.set_location('l_Sender_Reg_Number :'||l_Sender_Reg_Number,425);
284: --hr_utility.set_location('l_Sender_Report_Name :'||l_Sender_Report_Name,425);
285: --hr_utility.set_location('l_Employer_Name :'||l_Employer_Name,425);
286: --hr_utility.set_location('l_Employer_Reg_Number :'||l_Employer_Reg_Number,425);
287:

Line 284: --hr_utility.set_location('l_Sender_Report_Name :'||l_Sender_Report_Name,425);

280: CLOSE csr_get_sender_det;
281: l_Sender_Report_Name := UPPER(RPAD(NVL(l_Sender_Report_Name,' '),22));
282: l_Employer_Name := UPPER(RPAD(NVL(l_Employer_Name,' '),22));
283: --hr_utility.set_location('l_Sender_Reg_Number :'||l_Sender_Reg_Number,425);
284: --hr_utility.set_location('l_Sender_Report_Name :'||l_Sender_Report_Name,425);
285: --hr_utility.set_location('l_Employer_Name :'||l_Employer_Name,425);
286: --hr_utility.set_location('l_Employer_Reg_Number :'||l_Employer_Reg_Number,425);
287:
288:

Line 285: --hr_utility.set_location('l_Employer_Name :'||l_Employer_Name,425);

281: l_Sender_Report_Name := UPPER(RPAD(NVL(l_Sender_Report_Name,' '),22));
282: l_Employer_Name := UPPER(RPAD(NVL(l_Employer_Name,' '),22));
283: --hr_utility.set_location('l_Sender_Reg_Number :'||l_Sender_Reg_Number,425);
284: --hr_utility.set_location('l_Sender_Report_Name :'||l_Sender_Report_Name,425);
285: --hr_utility.set_location('l_Employer_Name :'||l_Employer_Name,425);
286: --hr_utility.set_location('l_Employer_Reg_Number :'||l_Employer_Reg_Number,425);
287:
288:
289: --Determine Sender Address (Business Group - Location)

Line 286: --hr_utility.set_location('l_Employer_Reg_Number :'||l_Employer_Reg_Number,425);

282: l_Employer_Name := UPPER(RPAD(NVL(l_Employer_Name,' '),22));
283: --hr_utility.set_location('l_Sender_Reg_Number :'||l_Sender_Reg_Number,425);
284: --hr_utility.set_location('l_Sender_Report_Name :'||l_Sender_Report_Name,425);
285: --hr_utility.set_location('l_Employer_Name :'||l_Employer_Name,425);
286: --hr_utility.set_location('l_Employer_Reg_Number :'||l_Employer_Reg_Number,425);
287:
288:
289: --Determine Sender Address (Business Group - Location)
290: OPEN csr_get_address(l_business_group_id);

Line 324: --hr_utility.set_location('l_Sender_Address :'||l_Sender_Address,425);

320: ELSE
321: l_Sender_Address := l_Sender_Address||RPAD(' ',20);
322: END IF;
323: l_Sender_Address :=UPPER(l_Sender_Address);
324: --hr_utility.set_location('l_Sender_Address :'||l_Sender_Address,425);
325:
326: v_House_Number := NULL;
327: --v_csr_get_address:= NULL;
328:

Line 363: --hr_utility.set_location('l_Employer_Address :'||l_Employer_Address,425);

359: ELSE
360: l_Employer_Address := l_Employer_Address||RPAD(' ',20);
361: END IF;
362: l_Employer_Address :=UPPER(l_Employer_Address);
363: --hr_utility.set_location('l_Employer_Address :'||l_Employer_Address,425);
364:
365:
366:
367: -- Validate Checks for Employer NSI Data

Line 435: hr_utility.set_location('Leaving Range Code',350);

431: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
432: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
433: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
434:
435: hr_utility.set_location('Leaving Range Code',350);
436:
437: EXCEPTION
438:
439: WHEN OTHERS THEN

Line 440: hr_utility.set_location('SQLERRM '||SQLERRM,350);

436:
437: EXCEPTION
438:
439: WHEN OTHERS THEN
440: hr_utility.set_location('SQLERRM '||SQLERRM,350);
441:
442: -- Return cursor that selects no rows
443: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
444: END RANGE_CODE;

Line 899: hr_utility.set_location('Entering Archive NL NSI EE Details',350);

895: l_utab_cib_value VARCHAR2(100);
896: l_Starter_Flag VARCHAR2(50);
897:
898: BEGIN
899: hr_utility.set_location('Entering Archive NL NSI EE Details',350);
900: hr_utility.set_location('Payroll Action Id '||p_payroll_action_id,350);
901:
902: --Intialize Variables
903: l_Asg_NSI_Rec_Count := 0;

Line 900: hr_utility.set_location('Payroll Action Id '||p_payroll_action_id,350);

896: l_Starter_Flag VARCHAR2(50);
897:
898: BEGIN
899: hr_utility.set_location('Entering Archive NL NSI EE Details',350);
900: hr_utility.set_location('Payroll Action Id '||p_payroll_action_id,350);
901:
902: --Intialize Variables
903: l_Asg_NSI_Rec_Count := 0;
904: l_asg_act_id := p_assignment_action_id;

Line 917: hr_utility.set_location('p_person_id '||p_person_id||' p_assignment_id '||p_assignment_id,350);

913: END IF;
914: g_error_count := 0;
915:
916:
917: hr_utility.set_location('p_person_id '||p_person_id||' p_assignment_id '||p_assignment_id,350);
918: hr_utility.set_location(' p_si_provider_id '||p_si_provider_id
919: ||' p_report_type'||p_report_type,350);
920: hr_utility.set_location(' p_cur_nsi_process_date '||p_cur_nsi_process_date
921: ||' p_lst_nsi_process_date '||p_lst_nsi_process_date

Line 918: hr_utility.set_location(' p_si_provider_id '||p_si_provider_id

914: g_error_count := 0;
915:
916:
917: hr_utility.set_location('p_person_id '||p_person_id||' p_assignment_id '||p_assignment_id,350);
918: hr_utility.set_location(' p_si_provider_id '||p_si_provider_id
919: ||' p_report_type'||p_report_type,350);
920: hr_utility.set_location(' p_cur_nsi_process_date '||p_cur_nsi_process_date
921: ||' p_lst_nsi_process_date '||p_lst_nsi_process_date
922: ||' l_Starter_Flag '||l_Starter_Flag,350);

Line 920: hr_utility.set_location(' p_cur_nsi_process_date '||p_cur_nsi_process_date

916:
917: hr_utility.set_location('p_person_id '||p_person_id||' p_assignment_id '||p_assignment_id,350);
918: hr_utility.set_location(' p_si_provider_id '||p_si_provider_id
919: ||' p_report_type'||p_report_type,350);
920: hr_utility.set_location(' p_cur_nsi_process_date '||p_cur_nsi_process_date
921: ||' p_lst_nsi_process_date '||p_lst_nsi_process_date
922: ||' l_Starter_Flag '||l_Starter_Flag,350);
923: IF l_Starter_Flag='EXISTING' THEN
924: OPEN csr_ee_lat_nsi(p_employer_id,p_si_provider_id

Line 928: hr_utility.set_location('v_csr_ee_lat_nsi.notify_a_date '||v_csr_ee_lat_nsi.notify_a_date,350);

924: OPEN csr_ee_lat_nsi(p_employer_id,p_si_provider_id
925: ,p_person_id,p_assignment_id,p_lst_nsi_process_date );
926: FETCH csr_ee_lat_nsi INTO v_csr_ee_lat_nsi;
927: CLOSE csr_ee_lat_nsi;
928: hr_utility.set_location('v_csr_ee_lat_nsi.notify_a_date '||v_csr_ee_lat_nsi.notify_a_date,350);
929: hr_utility.set_location('v_csr_ee_lat_nsi.notify_b_date '||v_csr_ee_lat_nsi.notify_b_date,350);
930:
931: l_last_nsi_min_notify_date := p_lst_nsi_process_date;
932:

Line 929: hr_utility.set_location('v_csr_ee_lat_nsi.notify_b_date '||v_csr_ee_lat_nsi.notify_b_date,350);

925: ,p_person_id,p_assignment_id,p_lst_nsi_process_date );
926: FETCH csr_ee_lat_nsi INTO v_csr_ee_lat_nsi;
927: CLOSE csr_ee_lat_nsi;
928: hr_utility.set_location('v_csr_ee_lat_nsi.notify_a_date '||v_csr_ee_lat_nsi.notify_a_date,350);
929: hr_utility.set_location('v_csr_ee_lat_nsi.notify_b_date '||v_csr_ee_lat_nsi.notify_b_date,350);
930:
931: l_last_nsi_min_notify_date := p_lst_nsi_process_date;
932:
933: SELECT LEAST(NVL(v_csr_ee_lat_nsi.notify_a_date,v_csr_ee_lat_nsi.notify_b_date),

Line 937: hr_utility.set_location(' l_last_nsi_min_notify_date '||l_last_nsi_min_notify_date,350);

933: SELECT LEAST(NVL(v_csr_ee_lat_nsi.notify_a_date,v_csr_ee_lat_nsi.notify_b_date),
934: NVL(v_csr_ee_lat_nsi.notify_b_date,v_csr_ee_lat_nsi.notify_a_date))
935: INTO l_last_nsi_min_notify_date FROM DUAL;
936: END IF;
937: hr_utility.set_location(' l_last_nsi_min_notify_date '||l_last_nsi_min_notify_date,350);
938:
939: --Determine EE Termination Details
940: OPEN csr_ee_term(p_person_id);
941: FETCH csr_ee_term INTO v_csr_ee_term;

Line 951: hr_utility.set_location(' Date Track ee_nsi.Eff_St_Date '||csr_ee_asg_nsi.Effective_Start_Date,350);

947: ,NVL(l_last_nsi_min_notify_date,hr_general.START_OF_TIME),p_cur_nsi_process_date );
948: LOOP
949: FETCH csr_ee_asg_si_info INTO csr_ee_asg_nsi;
950: EXIT WHEN (csr_ee_asg_si_info%NOTFOUND OR g_error_count>0);
951: hr_utility.set_location(' Date Track ee_nsi.Eff_St_Date '||csr_ee_asg_nsi.Effective_Start_Date,350);
952:
953: l_Asg_Effective_Start_Date := GREATEST(csr_ee_asg_nsi.Effective_Start_Date
954: ,csr_ee_asg_nsi.si_eff_start_date
955: ,csr_ee_asg_nsi.cad_eff_start_date);

Line 956: hr_utility.set_location('l_Asg_Effective_Start_Date :'||l_Asg_Effective_Start_Date,450);

952:
953: l_Asg_Effective_Start_Date := GREATEST(csr_ee_asg_nsi.Effective_Start_Date
954: ,csr_ee_asg_nsi.si_eff_start_date
955: ,csr_ee_asg_nsi.cad_eff_start_date);
956: hr_utility.set_location('l_Asg_Effective_Start_Date :'||l_Asg_Effective_Start_Date,450);
957:
958:
959:
960: --Intialize all NSI Record Variables

Line 1013: hr_utility.set_location(' ZW -'||v_csr_ee_si_prov_info.zw_provider||' WW -'||v_csr_ee_si_prov_info.ww_provider

1009: ,v_csr_ee_siinfo.wao_si_status,v_csr_ee_siinfo.zfw_si_status);
1010: FETCH csr_ee_si_prov_info INTO v_csr_ee_si_prov_info;
1011: CLOSE csr_ee_si_prov_info;
1012:
1013: hr_utility.set_location(' ZW -'||v_csr_ee_si_prov_info.zw_provider||' WW -'||v_csr_ee_si_prov_info.ww_provider
1014: ||' WAO -'||v_csr_ee_si_prov_info.wao_provider||' ZFW - '||v_csr_ee_si_prov_info.zfw_provider,450);
1015:
1016:
1017: --Determine Code Insurance

Line 1057: hr_utility.set_location('Tab Value l_utab_row_value :'||l_utab_row_value,450);

1053: -- Determine the l_Code_Ins_Basis from EE Type and EE Sub Type Information
1054: --
1055: l_utab_row_value := csr_ee_asg_nsi.Employment_Type||csr_ee_asg_nsi.Employment_SubType;
1056: BEGIN
1057: hr_utility.set_location('Tab Value l_utab_row_value :'||l_utab_row_value,450);
1058: l_utab_cib_value:= hruserdt.get_table_value(p_business_group_id,'NL_EMP_SUB_TYPE_CIB_KOA','GAK_CADANS_CIB',l_utab_row_value,p_cur_nsi_process_date);
1059: EXCEPTION
1060: WHEN OTHERS THEN
1061: hr_utility.set_location('Tab Value Error '||SQLCODE||' : '||SQLERRM(SQLCODE),450);

Line 1061: hr_utility.set_location('Tab Value Error '||SQLCODE||' : '||SQLERRM(SQLCODE),450);

1057: hr_utility.set_location('Tab Value l_utab_row_value :'||l_utab_row_value,450);
1058: l_utab_cib_value:= hruserdt.get_table_value(p_business_group_id,'NL_EMP_SUB_TYPE_CIB_KOA','GAK_CADANS_CIB',l_utab_row_value,p_cur_nsi_process_date);
1059: EXCEPTION
1060: WHEN OTHERS THEN
1061: hr_utility.set_location('Tab Value Error '||SQLCODE||' : '||SQLERRM(SQLCODE),450);
1062: l_utab_cib_value:=null;
1063: END;
1064:
1065: hr_utility.set_location('CIB : l_utab_cib_value '||l_utab_cib_value,450);

Line 1065: hr_utility.set_location('CIB : l_utab_cib_value '||l_utab_cib_value,450);

1061: hr_utility.set_location('Tab Value Error '||SQLCODE||' : '||SQLERRM(SQLCODE),450);
1062: l_utab_cib_value:=null;
1063: END;
1064:
1065: hr_utility.set_location('CIB : l_utab_cib_value '||l_utab_cib_value,450);
1066: FOR i IN 18..31
1067: LOOP
1068: IF i IN(21,24,30) THEN
1069: l_Code_Ins_Basis:=l_Code_Ins_Basis||'0';

Line 1102: hr_utility.set_location('l_Gak_Rep_Info : '||l_Gak_Rep_Info,450);

1098: l_Gak_Rep_Info := RPAD(SUBSTR(v_csr_ee_gak.Occupation_Desc||' ',1,12),12);
1099: l_Gak_Rep_Info := l_Gak_Rep_Info||LPAD(SUBSTR(v_csr_ee_gak.Weekly_4_Exp_SI_Days,1,5),3,'0');
1100: END IF;
1101: l_Gak_Rep_Info := UPPER(l_Gak_Rep_Info); /* Convert to Upper Case*/
1102: hr_utility.set_location('l_Gak_Rep_Info : '||l_Gak_Rep_Info,450);
1103:
1104: IF (P_Report_Type='NL_CAD_NSI_ARCHIVE' OR P_Report_Type='NL_CADZ_NSI_ARCHIVE' ) THEN
1105:
1106: IF l_Work_Pattern='R' THEN

Line 1127: hr_utility.set_location('l_Cadans_Rep_Info : '||l_Cadans_Rep_Info,450);

1123: l_Cadans_Rep_Info := l_Cadans_Rep_Info||LPAD(SUBSTR(v_csr_ee_cadans.insurance_abp||' ',1,1),1,'0');
1124: l_Cadans_Rep_Info := l_Cadans_Rep_Info||LPAD(SUBSTR(v_csr_ee_cadans.risk_fund||' ',1,1),1,'2');
1125: END IF;
1126: l_Cadans_Rep_Info := UPPER(l_Cadans_Rep_Info); /* Convert to Upper Case*/
1127: hr_utility.set_location('l_Cadans_Rep_Info : '||l_Cadans_Rep_Info,450);
1128:
1129: l_St_Date_Lab_Rel := l_Assignment_Start_Date;
1130:
1131: hr_utility.set_location('l_Code_Insurance '||l_Code_Insurance,450);

Line 1131: hr_utility.set_location('l_Code_Insurance '||l_Code_Insurance,450);

1127: hr_utility.set_location('l_Cadans_Rep_Info : '||l_Cadans_Rep_Info,450);
1128:
1129: l_St_Date_Lab_Rel := l_Assignment_Start_Date;
1130:
1131: hr_utility.set_location('l_Code_Insurance '||l_Code_Insurance,450);
1132: hr_utility.set_location('l_Code_Ins_Basis '||l_Code_Ins_Basis,450);
1133: hr_utility.set_location('l_Code_Occupation '||l_Code_Occupation,450);
1134: hr_utility.set_location('l_Work_Pattern '||l_Work_Pattern,450);
1135: hr_utility.set_location('l_St_Date_Lab_Rel '||l_St_Date_Lab_Rel,450);

Line 1132: hr_utility.set_location('l_Code_Ins_Basis '||l_Code_Ins_Basis,450);

1128:
1129: l_St_Date_Lab_Rel := l_Assignment_Start_Date;
1130:
1131: hr_utility.set_location('l_Code_Insurance '||l_Code_Insurance,450);
1132: hr_utility.set_location('l_Code_Ins_Basis '||l_Code_Ins_Basis,450);
1133: hr_utility.set_location('l_Code_Occupation '||l_Code_Occupation,450);
1134: hr_utility.set_location('l_Work_Pattern '||l_Work_Pattern,450);
1135: hr_utility.set_location('l_St_Date_Lab_Rel '||l_St_Date_Lab_Rel,450);
1136:

Line 1133: hr_utility.set_location('l_Code_Occupation '||l_Code_Occupation,450);

1129: l_St_Date_Lab_Rel := l_Assignment_Start_Date;
1130:
1131: hr_utility.set_location('l_Code_Insurance '||l_Code_Insurance,450);
1132: hr_utility.set_location('l_Code_Ins_Basis '||l_Code_Ins_Basis,450);
1133: hr_utility.set_location('l_Code_Occupation '||l_Code_Occupation,450);
1134: hr_utility.set_location('l_Work_Pattern '||l_Work_Pattern,450);
1135: hr_utility.set_location('l_St_Date_Lab_Rel '||l_St_Date_Lab_Rel,450);
1136:
1137:

Line 1134: hr_utility.set_location('l_Work_Pattern '||l_Work_Pattern,450);

1130:
1131: hr_utility.set_location('l_Code_Insurance '||l_Code_Insurance,450);
1132: hr_utility.set_location('l_Code_Ins_Basis '||l_Code_Ins_Basis,450);
1133: hr_utility.set_location('l_Code_Occupation '||l_Code_Occupation,450);
1134: hr_utility.set_location('l_Work_Pattern '||l_Work_Pattern,450);
1135: hr_utility.set_location('l_St_Date_Lab_Rel '||l_St_Date_Lab_Rel,450);
1136:
1137:
1138: IF l_Code_Insurance <>'2222' AND length(l_Code_Insurance)=4

Line 1135: hr_utility.set_location('l_St_Date_Lab_Rel '||l_St_Date_Lab_Rel,450);

1131: hr_utility.set_location('l_Code_Insurance '||l_Code_Insurance,450);
1132: hr_utility.set_location('l_Code_Ins_Basis '||l_Code_Ins_Basis,450);
1133: hr_utility.set_location('l_Code_Occupation '||l_Code_Occupation,450);
1134: hr_utility.set_location('l_Work_Pattern '||l_Work_Pattern,450);
1135: hr_utility.set_location('l_St_Date_Lab_Rel '||l_St_Date_Lab_Rel,450);
1136:
1137:
1138: IF l_Code_Insurance <>'2222' AND length(l_Code_Insurance)=4
1139: AND csr_ee_asg_nsi.PER_SYSTEM_STATUS <>'TERM_ASSIGN' THEN

Line 1156: hr_utility.set_location('Actual_Termination_Date '||v_csr_ee_term.Actual_Termination_Date,450);

1152: IF v_csr_ee_asg_status.PER_SYSTEM_STATUS='TERM_ASSIGN' THEN
1153: l_Notification_b :='1';
1154: l_Notification_b_date :=TO_CHAR(csr_ee_asg_nsi.effective_end_date,'DDMMYYYY');
1155: ELSE
1156: hr_utility.set_location('Actual_Termination_Date '||v_csr_ee_term.Actual_Termination_Date,450);
1157: hr_utility.set_location('effective_end_date '||v_csr_ee_asg_status.effective_end_date,450);
1158: IF v_csr_ee_term.Actual_Termination_Date IS NOT NULL
1159: AND v_csr_ee_term.Actual_Termination_Date <= p_cur_nsi_process_date
1160: AND v_csr_ee_term.Actual_Termination_Date >= csr_ee_asg_nsi.effective_start_date

Line 1157: hr_utility.set_location('effective_end_date '||v_csr_ee_asg_status.effective_end_date,450);

1153: l_Notification_b :='1';
1154: l_Notification_b_date :=TO_CHAR(csr_ee_asg_nsi.effective_end_date,'DDMMYYYY');
1155: ELSE
1156: hr_utility.set_location('Actual_Termination_Date '||v_csr_ee_term.Actual_Termination_Date,450);
1157: hr_utility.set_location('effective_end_date '||v_csr_ee_asg_status.effective_end_date,450);
1158: IF v_csr_ee_term.Actual_Termination_Date IS NOT NULL
1159: AND v_csr_ee_term.Actual_Termination_Date <= p_cur_nsi_process_date
1160: AND v_csr_ee_term.Actual_Termination_Date >= csr_ee_asg_nsi.effective_start_date
1161: AND v_csr_ee_term.Actual_Termination_Date <= csr_ee_asg_nsi.effective_end_date THEN

Line 1176: hr_utility.set_location('Fetching NSI Record as on l_Asg_Effective_Start_Date'||l_Asg_Effective_Start_Date,450);

1172: END IF;
1173: END IF;
1174:
1175: IF l_Starter_Flag='EXISTING' THEN
1176: hr_utility.set_location('Fetching NSI Record as on l_Asg_Effective_Start_Date'||l_Asg_Effective_Start_Date,450);
1177:
1178: OPEN csr_ee_nsi_record(p_person_id,p_assignment_id
1179: ,p_employer_id,p_si_provider_id,l_Asg_Effective_Start_Date,p_lst_nsi_process_date);
1180: FETCH csr_ee_nsi_record INTO v_csr_ee_nsi_record;

Line 1182: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a '||v_csr_ee_nsi_record.Notification_a,450);

1178: OPEN csr_ee_nsi_record(p_person_id,p_assignment_id
1179: ,p_employer_id,p_si_provider_id,l_Asg_Effective_Start_Date,p_lst_nsi_process_date);
1180: FETCH csr_ee_nsi_record INTO v_csr_ee_nsi_record;
1181: IF csr_ee_nsi_record%FOUND THEN
1182: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a '||v_csr_ee_nsi_record.Notification_a,450);
1183: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a_date '||v_csr_ee_nsi_record.Notification_a_date,450);
1184: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b '||v_csr_ee_nsi_record.Notification_b,450);
1185: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b_date '||v_csr_ee_nsi_record.Notification_b_date,450);
1186: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance '||v_csr_ee_nsi_record.Code_Insurance,450);

Line 1183: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a_date '||v_csr_ee_nsi_record.Notification_a_date,450);

1179: ,p_employer_id,p_si_provider_id,l_Asg_Effective_Start_Date,p_lst_nsi_process_date);
1180: FETCH csr_ee_nsi_record INTO v_csr_ee_nsi_record;
1181: IF csr_ee_nsi_record%FOUND THEN
1182: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a '||v_csr_ee_nsi_record.Notification_a,450);
1183: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a_date '||v_csr_ee_nsi_record.Notification_a_date,450);
1184: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b '||v_csr_ee_nsi_record.Notification_b,450);
1185: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b_date '||v_csr_ee_nsi_record.Notification_b_date,450);
1186: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance '||v_csr_ee_nsi_record.Code_Insurance,450);
1187: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance_Basis '||v_csr_ee_nsi_record.Code_Insurance_Basis,450);

Line 1184: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b '||v_csr_ee_nsi_record.Notification_b,450);

1180: FETCH csr_ee_nsi_record INTO v_csr_ee_nsi_record;
1181: IF csr_ee_nsi_record%FOUND THEN
1182: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a '||v_csr_ee_nsi_record.Notification_a,450);
1183: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a_date '||v_csr_ee_nsi_record.Notification_a_date,450);
1184: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b '||v_csr_ee_nsi_record.Notification_b,450);
1185: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b_date '||v_csr_ee_nsi_record.Notification_b_date,450);
1186: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance '||v_csr_ee_nsi_record.Code_Insurance,450);
1187: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance_Basis '||v_csr_ee_nsi_record.Code_Insurance_Basis,450);
1188: hr_utility.set_location('v_csr_ee_nsi_record.Code_Occupation '||v_csr_ee_nsi_record.Code_Occupation,450);

Line 1185: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b_date '||v_csr_ee_nsi_record.Notification_b_date,450);

1181: IF csr_ee_nsi_record%FOUND THEN
1182: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a '||v_csr_ee_nsi_record.Notification_a,450);
1183: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a_date '||v_csr_ee_nsi_record.Notification_a_date,450);
1184: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b '||v_csr_ee_nsi_record.Notification_b,450);
1185: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b_date '||v_csr_ee_nsi_record.Notification_b_date,450);
1186: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance '||v_csr_ee_nsi_record.Code_Insurance,450);
1187: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance_Basis '||v_csr_ee_nsi_record.Code_Insurance_Basis,450);
1188: hr_utility.set_location('v_csr_ee_nsi_record.Code_Occupation '||v_csr_ee_nsi_record.Code_Occupation,450);
1189: hr_utility.set_location('v_csr_ee_nsi_record.Work_Pattern '||v_csr_ee_nsi_record.Work_Pattern,450);

Line 1186: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance '||v_csr_ee_nsi_record.Code_Insurance,450);

1182: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a '||v_csr_ee_nsi_record.Notification_a,450);
1183: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a_date '||v_csr_ee_nsi_record.Notification_a_date,450);
1184: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b '||v_csr_ee_nsi_record.Notification_b,450);
1185: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b_date '||v_csr_ee_nsi_record.Notification_b_date,450);
1186: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance '||v_csr_ee_nsi_record.Code_Insurance,450);
1187: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance_Basis '||v_csr_ee_nsi_record.Code_Insurance_Basis,450);
1188: hr_utility.set_location('v_csr_ee_nsi_record.Code_Occupation '||v_csr_ee_nsi_record.Code_Occupation,450);
1189: hr_utility.set_location('v_csr_ee_nsi_record.Work_Pattern '||v_csr_ee_nsi_record.Work_Pattern,450);
1190: hr_utility.set_location('v_csr_ee_nsi_record.St_Date_Lab_Rel '||v_csr_ee_nsi_record.St_Date_Lab_Rel,450);

Line 1187: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance_Basis '||v_csr_ee_nsi_record.Code_Insurance_Basis,450);

1183: hr_utility.set_location('v_csr_ee_nsi_record.Notification_a_date '||v_csr_ee_nsi_record.Notification_a_date,450);
1184: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b '||v_csr_ee_nsi_record.Notification_b,450);
1185: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b_date '||v_csr_ee_nsi_record.Notification_b_date,450);
1186: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance '||v_csr_ee_nsi_record.Code_Insurance,450);
1187: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance_Basis '||v_csr_ee_nsi_record.Code_Insurance_Basis,450);
1188: hr_utility.set_location('v_csr_ee_nsi_record.Code_Occupation '||v_csr_ee_nsi_record.Code_Occupation,450);
1189: hr_utility.set_location('v_csr_ee_nsi_record.Work_Pattern '||v_csr_ee_nsi_record.Work_Pattern,450);
1190: hr_utility.set_location('v_csr_ee_nsi_record.St_Date_Lab_Rel '||v_csr_ee_nsi_record.St_Date_Lab_Rel,450);
1191: l_Prev_Notification_a := v_csr_ee_nsi_record.Notification_a;

Line 1188: hr_utility.set_location('v_csr_ee_nsi_record.Code_Occupation '||v_csr_ee_nsi_record.Code_Occupation,450);

1184: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b '||v_csr_ee_nsi_record.Notification_b,450);
1185: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b_date '||v_csr_ee_nsi_record.Notification_b_date,450);
1186: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance '||v_csr_ee_nsi_record.Code_Insurance,450);
1187: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance_Basis '||v_csr_ee_nsi_record.Code_Insurance_Basis,450);
1188: hr_utility.set_location('v_csr_ee_nsi_record.Code_Occupation '||v_csr_ee_nsi_record.Code_Occupation,450);
1189: hr_utility.set_location('v_csr_ee_nsi_record.Work_Pattern '||v_csr_ee_nsi_record.Work_Pattern,450);
1190: hr_utility.set_location('v_csr_ee_nsi_record.St_Date_Lab_Rel '||v_csr_ee_nsi_record.St_Date_Lab_Rel,450);
1191: l_Prev_Notification_a := v_csr_ee_nsi_record.Notification_a;
1192: l_Prev_Notification_a_date := v_csr_ee_nsi_record.Notification_a_date;

Line 1189: hr_utility.set_location('v_csr_ee_nsi_record.Work_Pattern '||v_csr_ee_nsi_record.Work_Pattern,450);

1185: hr_utility.set_location('v_csr_ee_nsi_record.Notification_b_date '||v_csr_ee_nsi_record.Notification_b_date,450);
1186: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance '||v_csr_ee_nsi_record.Code_Insurance,450);
1187: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance_Basis '||v_csr_ee_nsi_record.Code_Insurance_Basis,450);
1188: hr_utility.set_location('v_csr_ee_nsi_record.Code_Occupation '||v_csr_ee_nsi_record.Code_Occupation,450);
1189: hr_utility.set_location('v_csr_ee_nsi_record.Work_Pattern '||v_csr_ee_nsi_record.Work_Pattern,450);
1190: hr_utility.set_location('v_csr_ee_nsi_record.St_Date_Lab_Rel '||v_csr_ee_nsi_record.St_Date_Lab_Rel,450);
1191: l_Prev_Notification_a := v_csr_ee_nsi_record.Notification_a;
1192: l_Prev_Notification_a_date := v_csr_ee_nsi_record.Notification_a_date;
1193: l_Prev_Notification_b := v_csr_ee_nsi_record.Notification_b ;

Line 1190: hr_utility.set_location('v_csr_ee_nsi_record.St_Date_Lab_Rel '||v_csr_ee_nsi_record.St_Date_Lab_Rel,450);

1186: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance '||v_csr_ee_nsi_record.Code_Insurance,450);
1187: hr_utility.set_location('v_csr_ee_nsi_record.Code_Insurance_Basis '||v_csr_ee_nsi_record.Code_Insurance_Basis,450);
1188: hr_utility.set_location('v_csr_ee_nsi_record.Code_Occupation '||v_csr_ee_nsi_record.Code_Occupation,450);
1189: hr_utility.set_location('v_csr_ee_nsi_record.Work_Pattern '||v_csr_ee_nsi_record.Work_Pattern,450);
1190: hr_utility.set_location('v_csr_ee_nsi_record.St_Date_Lab_Rel '||v_csr_ee_nsi_record.St_Date_Lab_Rel,450);
1191: l_Prev_Notification_a := v_csr_ee_nsi_record.Notification_a;
1192: l_Prev_Notification_a_date := v_csr_ee_nsi_record.Notification_a_date;
1193: l_Prev_Notification_b := v_csr_ee_nsi_record.Notification_b ;
1194: l_Prev_Notification_b_date := v_csr_ee_nsi_record.Notification_b_date;

Line 1237: hr_utility.set_location('l_Prev_Code_Insurance '||l_Prev_Code_Insurance,450);

1233: END IF;
1234: CLOSE csr_ee_nsi_record;
1235: END IF;
1236:
1237: hr_utility.set_location('l_Prev_Code_Insurance '||l_Prev_Code_Insurance,450);
1238: hr_utility.set_location('l_Prev_Code_Ins_Basis '||l_Prev_Code_Ins_Basis,450);
1239: hr_utility.set_location('l_Prev_Code_Occupation '||l_Prev_Code_Occupation,450);
1240: hr_utility.set_location('l_Prev_Work_Pattern '||l_Prev_Work_Pattern,450);
1241: hr_utility.set_location('l_Prev_St_Date_Lab_Rel '||l_Prev_St_Date_Lab_Rel,450);

Line 1238: hr_utility.set_location('l_Prev_Code_Ins_Basis '||l_Prev_Code_Ins_Basis,450);

1234: CLOSE csr_ee_nsi_record;
1235: END IF;
1236:
1237: hr_utility.set_location('l_Prev_Code_Insurance '||l_Prev_Code_Insurance,450);
1238: hr_utility.set_location('l_Prev_Code_Ins_Basis '||l_Prev_Code_Ins_Basis,450);
1239: hr_utility.set_location('l_Prev_Code_Occupation '||l_Prev_Code_Occupation,450);
1240: hr_utility.set_location('l_Prev_Work_Pattern '||l_Prev_Work_Pattern,450);
1241: hr_utility.set_location('l_Prev_St_Date_Lab_Rel '||l_Prev_St_Date_Lab_Rel,450);
1242:

Line 1239: hr_utility.set_location('l_Prev_Code_Occupation '||l_Prev_Code_Occupation,450);

1235: END IF;
1236:
1237: hr_utility.set_location('l_Prev_Code_Insurance '||l_Prev_Code_Insurance,450);
1238: hr_utility.set_location('l_Prev_Code_Ins_Basis '||l_Prev_Code_Ins_Basis,450);
1239: hr_utility.set_location('l_Prev_Code_Occupation '||l_Prev_Code_Occupation,450);
1240: hr_utility.set_location('l_Prev_Work_Pattern '||l_Prev_Work_Pattern,450);
1241: hr_utility.set_location('l_Prev_St_Date_Lab_Rel '||l_Prev_St_Date_Lab_Rel,450);
1242:
1243: /* Check if the previous Archived NSI Record is same as the

Line 1240: hr_utility.set_location('l_Prev_Work_Pattern '||l_Prev_Work_Pattern,450);

1236:
1237: hr_utility.set_location('l_Prev_Code_Insurance '||l_Prev_Code_Insurance,450);
1238: hr_utility.set_location('l_Prev_Code_Ins_Basis '||l_Prev_Code_Ins_Basis,450);
1239: hr_utility.set_location('l_Prev_Code_Occupation '||l_Prev_Code_Occupation,450);
1240: hr_utility.set_location('l_Prev_Work_Pattern '||l_Prev_Work_Pattern,450);
1241: hr_utility.set_location('l_Prev_St_Date_Lab_Rel '||l_Prev_St_Date_Lab_Rel,450);
1242:
1243: /* Check if the previous Archived NSI Record is same as the
1244: NSI Data as on the Effective Date*/

Line 1241: hr_utility.set_location('l_Prev_St_Date_Lab_Rel '||l_Prev_St_Date_Lab_Rel,450);

1237: hr_utility.set_location('l_Prev_Code_Insurance '||l_Prev_Code_Insurance,450);
1238: hr_utility.set_location('l_Prev_Code_Ins_Basis '||l_Prev_Code_Ins_Basis,450);
1239: hr_utility.set_location('l_Prev_Code_Occupation '||l_Prev_Code_Occupation,450);
1240: hr_utility.set_location('l_Prev_Work_Pattern '||l_Prev_Work_Pattern,450);
1241: hr_utility.set_location('l_Prev_St_Date_Lab_Rel '||l_Prev_St_Date_Lab_Rel,450);
1242:
1243: /* Check if the previous Archived NSI Record is same as the
1244: NSI Data as on the Effective Date*/
1245: IF l_Create_NSI=FALSE AND l_Starter_Flag='EXISTING' THEN

Line 1310: hr_utility.set_location('l_Notification_a '||l_Notification_a,450);

1306: END IF;
1307: END IF;
1308:
1309: END IF;
1310: hr_utility.set_location('l_Notification_a '||l_Notification_a,450);
1311: hr_utility.set_location('l_Notification_a_date '||l_Notification_a_date,450);
1312: hr_utility.set_location('l_Notification_b '||l_Notification_b,450);
1313: hr_utility.set_location('l_Notification_b_date '||l_Notification_b_date,450);
1314:

Line 1311: hr_utility.set_location('l_Notification_a_date '||l_Notification_a_date,450);

1307: END IF;
1308:
1309: END IF;
1310: hr_utility.set_location('l_Notification_a '||l_Notification_a,450);
1311: hr_utility.set_location('l_Notification_a_date '||l_Notification_a_date,450);
1312: hr_utility.set_location('l_Notification_b '||l_Notification_b,450);
1313: hr_utility.set_location('l_Notification_b_date '||l_Notification_b_date,450);
1314:
1315: IF l_Create_NSI= TRUE THEN

Line 1312: hr_utility.set_location('l_Notification_b '||l_Notification_b,450);

1308:
1309: END IF;
1310: hr_utility.set_location('l_Notification_a '||l_Notification_a,450);
1311: hr_utility.set_location('l_Notification_a_date '||l_Notification_a_date,450);
1312: hr_utility.set_location('l_Notification_b '||l_Notification_b,450);
1313: hr_utility.set_location('l_Notification_b_date '||l_Notification_b_date,450);
1314:
1315: IF l_Create_NSI= TRUE THEN
1316: hr_utility.set_location('Creating NSI EE Record '||p_assignment_action_id,450);

Line 1313: hr_utility.set_location('l_Notification_b_date '||l_Notification_b_date,450);

1309: END IF;
1310: hr_utility.set_location('l_Notification_a '||l_Notification_a,450);
1311: hr_utility.set_location('l_Notification_a_date '||l_Notification_a_date,450);
1312: hr_utility.set_location('l_Notification_b '||l_Notification_b,450);
1313: hr_utility.set_location('l_Notification_b_date '||l_Notification_b_date,450);
1314:
1315: IF l_Create_NSI= TRUE THEN
1316: hr_utility.set_location('Creating NSI EE Record '||p_assignment_action_id,450);
1317:

Line 1316: hr_utility.set_location('Creating NSI EE Record '||p_assignment_action_id,450);

1312: hr_utility.set_location('l_Notification_b '||l_Notification_b,450);
1313: hr_utility.set_location('l_Notification_b_date '||l_Notification_b_date,450);
1314:
1315: IF l_Create_NSI= TRUE THEN
1316: hr_utility.set_location('Creating NSI EE Record '||p_assignment_action_id,450);
1317:
1318: v_csr_ee_info := NULL;
1319: v_csr_ee_sp_info := NULL;
1320: v_csr_ee_addr := NULL;

Line 1331: --hr_utility.set_location('Previous_Last_Name : '||v_csr_ee_info.Previous_Last_Name,450);

1327:
1328: g_assignment_number := v_csr_ee_info.Assignment_Number;
1329: g_full_name := v_csr_ee_info.Full_Name;
1330:
1331: --hr_utility.set_location('Previous_Last_Name : '||v_csr_ee_info.Previous_Last_Name,450);
1332: --hr_utility.set_location('Last_Name : '||v_csr_ee_info.Last_Name,450);
1333: --hr_utility.set_location('Prefix : '||v_csr_ee_info.Prefix,450);
1334: --hr_utility.set_location('First_Name : '||v_csr_ee_info.First_Name,450);
1335:

Line 1332: --hr_utility.set_location('Last_Name : '||v_csr_ee_info.Last_Name,450);

1328: g_assignment_number := v_csr_ee_info.Assignment_Number;
1329: g_full_name := v_csr_ee_info.Full_Name;
1330:
1331: --hr_utility.set_location('Previous_Last_Name : '||v_csr_ee_info.Previous_Last_Name,450);
1332: --hr_utility.set_location('Last_Name : '||v_csr_ee_info.Last_Name,450);
1333: --hr_utility.set_location('Prefix : '||v_csr_ee_info.Prefix,450);
1334: --hr_utility.set_location('First_Name : '||v_csr_ee_info.First_Name,450);
1335:
1336: l_Employee_Name := RPAD(SUBSTR(NVL(v_csr_ee_info.Previous_Last_Name,v_csr_ee_info.Last_Name),1,49),49);

Line 1333: --hr_utility.set_location('Prefix : '||v_csr_ee_info.Prefix,450);

1329: g_full_name := v_csr_ee_info.Full_Name;
1330:
1331: --hr_utility.set_location('Previous_Last_Name : '||v_csr_ee_info.Previous_Last_Name,450);
1332: --hr_utility.set_location('Last_Name : '||v_csr_ee_info.Last_Name,450);
1333: --hr_utility.set_location('Prefix : '||v_csr_ee_info.Prefix,450);
1334: --hr_utility.set_location('First_Name : '||v_csr_ee_info.First_Name,450);
1335:
1336: l_Employee_Name := RPAD(SUBSTR(NVL(v_csr_ee_info.Previous_Last_Name,v_csr_ee_info.Last_Name),1,49),49);
1337: l_Employee_Name := l_Employee_Name||RPAD(SUBSTR(v_csr_ee_info.Initials||' ',1,5),5);

Line 1334: --hr_utility.set_location('First_Name : '||v_csr_ee_info.First_Name,450);

1330:
1331: --hr_utility.set_location('Previous_Last_Name : '||v_csr_ee_info.Previous_Last_Name,450);
1332: --hr_utility.set_location('Last_Name : '||v_csr_ee_info.Last_Name,450);
1333: --hr_utility.set_location('Prefix : '||v_csr_ee_info.Prefix,450);
1334: --hr_utility.set_location('First_Name : '||v_csr_ee_info.First_Name,450);
1335:
1336: l_Employee_Name := RPAD(SUBSTR(NVL(v_csr_ee_info.Previous_Last_Name,v_csr_ee_info.Last_Name),1,49),49);
1337: l_Employee_Name := l_Employee_Name||RPAD(SUBSTR(v_csr_ee_info.Initials||' ',1,5),5);
1338: l_Employee_Name := l_Employee_Name||RPAD(SUBSTR(v_csr_ee_info.Prefix||' ',1,8),8);

Line 1352: --hr_utility.set_location('Spouse Name and Prefix Added l_Cadans_Rep_Info : '||l_Cadans_Rep_Info,450);

1348: ||RPAD(SUBSTR(v_csr_ee_sp_info.Prefix||' ',1,8),8)
1349: ||l_Cadans_Rep_Info;
1350:
1351: l_Cadans_Rep_Info := UPPER(l_Cadans_Rep_Info); /*Convert to Upper Case */
1352: --hr_utility.set_location('Spouse Name and Prefix Added l_Cadans_Rep_Info : '||l_Cadans_Rep_Info,450);
1353:
1354: --hr_utility.set_location('l_Employee_Name : '||l_Employee_Name,450);
1355:
1356: l_SOFI_Number := LPAD(SUBSTR(v_csr_ee_info.SOFI_Number,1,9),9,'0');

Line 1354: --hr_utility.set_location('l_Employee_Name : '||l_Employee_Name,450);

1350:
1351: l_Cadans_Rep_Info := UPPER(l_Cadans_Rep_Info); /*Convert to Upper Case */
1352: --hr_utility.set_location('Spouse Name and Prefix Added l_Cadans_Rep_Info : '||l_Cadans_Rep_Info,450);
1353:
1354: --hr_utility.set_location('l_Employee_Name : '||l_Employee_Name,450);
1355:
1356: l_SOFI_Number := LPAD(SUBSTR(v_csr_ee_info.SOFI_Number,1,9),9,'0');
1357: --hr_utility.set_location('l_SOFI_Number : '||l_SOFI_Number,450);
1358:

Line 1357: --hr_utility.set_location('l_SOFI_Number : '||l_SOFI_Number,450);

1353:
1354: --hr_utility.set_location('l_Employee_Name : '||l_Employee_Name,450);
1355:
1356: l_SOFI_Number := LPAD(SUBSTR(v_csr_ee_info.SOFI_Number,1,9),9,'0');
1357: --hr_utility.set_location('l_SOFI_Number : '||l_SOFI_Number,450);
1358:
1359: IF v_csr_ee_info.Sex='M' THEN
1360: l_Employee_Details:= '1';
1361: ELSIF v_csr_ee_info.Sex='F' THEN

Line 1378: --hr_utility.set_location('l_Employee_Details-Sex+MaritalStatus+EENum+AsgNum : '||l_Employee_Details,450);

1374:
1375: l_Employee_Details := upper(l_Employee_Details); /*Convert to Upper Case */
1376:
1377:
1378: --hr_utility.set_location('l_Employee_Details-Sex+MaritalStatus+EENum+AsgNum : '||l_Employee_Details,450);
1379:
1380: --hr_utility.set_location('l_Person_ID : '||l_Person_ID,450);
1381:
1382: --Fetch Employee Address

Line 1380: --hr_utility.set_location('l_Person_ID : '||l_Person_ID,450);

1376:
1377:
1378: --hr_utility.set_location('l_Employee_Details-Sex+MaritalStatus+EENum+AsgNum : '||l_Employee_Details,450);
1379:
1380: --hr_utility.set_location('l_Person_ID : '||l_Person_ID,450);
1381:
1382: --Fetch Employee Address
1383: OPEN csr_ee_addr(l_Person_ID,NULL,csr_ee_asg_nsi.Effective_Start_Date);
1384: FETCH csr_ee_addr INTO v_csr_ee_addr;

Line 1399: --hr_utility.set_location('l_EE_Prim_Add : '||l_Employee_Primary_Add,450);

1395: l_Employee_Primary_Add := l_Employee_Primary_Add||LPAD(SUBSTR(NVL(v_csr_ee_addr.House_Num,'0'),1,5),5,'0');
1396: l_Employee_Primary_Add := l_Employee_Primary_Add||RPAD(SUBSTR(NVL(v_csr_ee_addr.House_Num_Add,' '),1,5),5);
1397: END IF;
1398: END IF;
1399: --hr_utility.set_location('l_EE_Prim_Add : '||l_Employee_Primary_Add,450);
1400:
1401: IF v_csr_ee_addr.Country ='NL' THEN
1402: l_Employee_Primary_Add := l_Employee_Primary_Add||LPAD(SUBSTR(NVL(v_csr_ee_addr.Postal_Code,'0'),1,4),4,'0');
1403: l_Employee_Primary_Add := l_Employee_Primary_Add||RPAD(SUBSTR(NVL(v_csr_ee_addr.Postal_Code,' '),5,2),2);

Line 1408: --hr_utility.set_location('l_EE_Prim_Add : '||l_Employee_Primary_Add,450);

1404: ELSE
1405: l_Employee_Primary_Add := l_Employee_Primary_Add||RPAD('0',4,'0');
1406: l_Employee_Primary_Add := l_Employee_Primary_Add||RPAD(' ',2,' ');
1407: END IF;
1408: --hr_utility.set_location('l_EE_Prim_Add : '||l_Employee_Primary_Add,450);
1409:
1410: l_Employee_Primary_Add := l_Employee_Primary_Add||RPAD(SUBSTR(nvl(v_csr_ee_addr.City,' '),1,20),20);
1411: --hr_utility.set_location('l_EE_Prim_Add +City : '||l_Employee_Primary_Add,450);
1412:

Line 1411: --hr_utility.set_location('l_EE_Prim_Add +City : '||l_Employee_Primary_Add,450);

1407: END IF;
1408: --hr_utility.set_location('l_EE_Prim_Add : '||l_Employee_Primary_Add,450);
1409:
1410: l_Employee_Primary_Add := l_Employee_Primary_Add||RPAD(SUBSTR(nvl(v_csr_ee_addr.City,' '),1,20),20);
1411: --hr_utility.set_location('l_EE_Prim_Add +City : '||l_Employee_Primary_Add,450);
1412:
1413: l_Country_Name:=get_country_name(v_csr_ee_addr.country);
1414: --hr_utility.set_location('l_Country_Name : '||l_Country_Name,450);
1415: IF v_csr_ee_addr.country='NL' THEN

Line 1414: --hr_utility.set_location('l_Country_Name : '||l_Country_Name,450);

1410: l_Employee_Primary_Add := l_Employee_Primary_Add||RPAD(SUBSTR(nvl(v_csr_ee_addr.City,' '),1,20),20);
1411: --hr_utility.set_location('l_EE_Prim_Add +City : '||l_Employee_Primary_Add,450);
1412:
1413: l_Country_Name:=get_country_name(v_csr_ee_addr.country);
1414: --hr_utility.set_location('l_Country_Name : '||l_Country_Name,450);
1415: IF v_csr_ee_addr.country='NL' THEN
1416: l_Employee_Primary_Add := l_Employee_Primary_Add||RPAD(' ',15);
1417: ELSE
1418: l_Employee_Primary_Add := l_Employee_Primary_Add||RPAD(SUBSTR(l_Country_Name,1,15),15);

Line 1422: --hr_utility.set_location('l_Employee_Primary_Add : '||l_Employee_Primary_Add,450);

1418: l_Employee_Primary_Add := l_Employee_Primary_Add||RPAD(SUBSTR(l_Country_Name,1,15),15);
1419: END IF;
1420: l_Employee_Primary_Add := upper(l_Employee_Primary_Add);/*Convert to Upper Case */
1421:
1422: --hr_utility.set_location('l_Employee_Primary_Add : '||l_Employee_Primary_Add,450);
1423:
1424: --Fetch Employee Population Register Address
1425: OPEN csr_ee_addr(l_Person_ID,'PRA',csr_ee_asg_nsi.Effective_Start_Date);
1426: FETCH csr_ee_addr INTO v_csr_ee_addr1;

Line 1445: --hr_utility.set_location('l_Employee_Pop_Reg_Add : '||l_Employee_Pop_Reg_Add,450);

1441: END IF;
1442: l_Employee_Pop_Reg_Add := l_Employee_Pop_Reg_Add||RPAD(SUBSTR(NVL(v_csr_ee_addr1.City,' '),1,20),20);
1443:
1444: l_Employee_Pop_Reg_Add := upper(l_Employee_Pop_Reg_Add);/*Convert to Upper Case */
1445: --hr_utility.set_location('l_Employee_Pop_Reg_Add : '||l_Employee_Pop_Reg_Add,450);
1446:
1447: ---------------------------------------------------------------------------------------
1448: -- Validation Checks for Employee NSI Data
1449: ---------------------------------------------------------------------------------------

Line 1555: hr_utility.set_location('NSI Archive Assignment Action Id '||l_asg_act_id,450);

1551: hr_nonrun_asact.insact(l_asg_act_id,l_Assignment_ID, p_payroll_action_id,p_chunk,NULL);
1552:
1553: --
1554: END IF;
1555: hr_utility.set_location('NSI Archive Assignment Action Id '||l_asg_act_id,450);
1556:
1557: l_Prev_Notification_a := l_Notification_a;
1558: l_Prev_Notification_a_date := l_Notification_a_date;
1559: l_Prev_Notification_b := l_Notification_b ;

Line 1613: hr_utility.set_location('NSI Archive l_action_info_id'||l_action_info_id,450);

1609: ,p_action_information21 => l_Employee_Pop_Reg_Add
1610: ,p_action_information22 => l_Gak_Rep_Info
1611: ,p_action_information23 => l_Cadans_Rep_Info
1612: ,p_action_information24 => l_Employee_Details );
1613: hr_utility.set_location('NSI Archive l_action_info_id'||l_action_info_id,450);
1614:
1615: --Create Multiple NSI records with Same Data expect for NSI Notify attributes.
1616: IF l_Multiple_NSI THEN
1617: l_Notification_a := '0';

Line 1655: hr_utility.set_location('NSI Archive Multiple l_action_info_id'||l_action_info_id,450);

1651: ,p_action_information21 => l_Employee_Pop_Reg_Add
1652: ,p_action_information22 => l_Gak_Rep_Info
1653: ,p_action_information23 => l_Cadans_Rep_Info
1654: ,p_action_information24 => l_Employee_Details );
1655: hr_utility.set_location('NSI Archive Multiple l_action_info_id'||l_action_info_id,450);
1656: END IF;
1657: END IF;/* End of g_error_count Check*/
1658: END IF; /* End of l_Create_NSI= TRUE Check*/
1659: END IF;/* End of l_Code_Insurance <>'2222' Check*/

Line 1666: hr_utility.set_location('Leaving Archive NL NSI EE Details',350);

1662: l_Prev_Person_ID :=l_Person_ID;
1663: l_Prev_Assignment_ID :=l_Assignment_ID;
1664:
1665: END LOOP;
1666: hr_utility.set_location('Leaving Archive NL NSI EE Details',350);
1667: End ARCHIVE_NL_NSI_EE_DETAILS;
1668:
1669: /*-----------------------------------------------------------------------------
1670: |Name : WITHDRAW_NL_NSI_EE_NOTIF |

Line 1754: hr_utility.set_location('Entering Withdraw NSI Notification',360);

1750: l_action_info_id pay_action_information.action_information_id%TYPE;
1751: l_ovn pay_action_information.object_version_number%TYPE;
1752: l_withdrawn_action_count NUMBER :=0;
1753: BEGIN
1754: hr_utility.set_location('Entering Withdraw NSI Notification',360);
1755:
1756: hr_utility.set_location(' p_person_id '||p_person_id||' p_assignment_id '||p_assignment_id,360);
1757: hr_utility.set_location(' p_employer_id '|| p_employer_id ||' p_si_provider_id '||p_si_provider_id,360);
1758: hr_utility.set_location(' p_lst_nsi_process_date '|| p_lst_nsi_process_date,360);

Line 1756: hr_utility.set_location(' p_person_id '||p_person_id||' p_assignment_id '||p_assignment_id,360);

1752: l_withdrawn_action_count NUMBER :=0;
1753: BEGIN
1754: hr_utility.set_location('Entering Withdraw NSI Notification',360);
1755:
1756: hr_utility.set_location(' p_person_id '||p_person_id||' p_assignment_id '||p_assignment_id,360);
1757: hr_utility.set_location(' p_employer_id '|| p_employer_id ||' p_si_provider_id '||p_si_provider_id,360);
1758: hr_utility.set_location(' p_lst_nsi_process_date '|| p_lst_nsi_process_date,360);
1759: hr_utility.set_location(' p_cur_nsi_process_date '|| p_cur_nsi_process_date,360);
1760: FOR v_csr_ee_nsi_record IN csr_ee_nsi_record(p_person_id,p_assignment_id

Line 1757: hr_utility.set_location(' p_employer_id '|| p_employer_id ||' p_si_provider_id '||p_si_provider_id,360);

1753: BEGIN
1754: hr_utility.set_location('Entering Withdraw NSI Notification',360);
1755:
1756: hr_utility.set_location(' p_person_id '||p_person_id||' p_assignment_id '||p_assignment_id,360);
1757: hr_utility.set_location(' p_employer_id '|| p_employer_id ||' p_si_provider_id '||p_si_provider_id,360);
1758: hr_utility.set_location(' p_lst_nsi_process_date '|| p_lst_nsi_process_date,360);
1759: hr_utility.set_location(' p_cur_nsi_process_date '|| p_cur_nsi_process_date,360);
1760: FOR v_csr_ee_nsi_record IN csr_ee_nsi_record(p_person_id,p_assignment_id
1761: ,p_employer_id,p_si_provider_id,p_lst_nsi_process_date )

Line 1758: hr_utility.set_location(' p_lst_nsi_process_date '|| p_lst_nsi_process_date,360);

1754: hr_utility.set_location('Entering Withdraw NSI Notification',360);
1755:
1756: hr_utility.set_location(' p_person_id '||p_person_id||' p_assignment_id '||p_assignment_id,360);
1757: hr_utility.set_location(' p_employer_id '|| p_employer_id ||' p_si_provider_id '||p_si_provider_id,360);
1758: hr_utility.set_location(' p_lst_nsi_process_date '|| p_lst_nsi_process_date,360);
1759: hr_utility.set_location(' p_cur_nsi_process_date '|| p_cur_nsi_process_date,360);
1760: FOR v_csr_ee_nsi_record IN csr_ee_nsi_record(p_person_id,p_assignment_id
1761: ,p_employer_id,p_si_provider_id,p_lst_nsi_process_date )
1762: LOOP

Line 1759: hr_utility.set_location(' p_cur_nsi_process_date '|| p_cur_nsi_process_date,360);

1755:
1756: hr_utility.set_location(' p_person_id '||p_person_id||' p_assignment_id '||p_assignment_id,360);
1757: hr_utility.set_location(' p_employer_id '|| p_employer_id ||' p_si_provider_id '||p_si_provider_id,360);
1758: hr_utility.set_location(' p_lst_nsi_process_date '|| p_lst_nsi_process_date,360);
1759: hr_utility.set_location(' p_cur_nsi_process_date '|| p_cur_nsi_process_date,360);
1760: FOR v_csr_ee_nsi_record IN csr_ee_nsi_record(p_person_id,p_assignment_id
1761: ,p_employer_id,p_si_provider_id,p_lst_nsi_process_date )
1762: LOOP
1763: --Increment the Withdrawn Action count.

Line 1781: hr_utility.set_location('NSI Archive Assignment Action Id '||l_asg_act_id,450);

1777: hr_nonrun_asact.insact(l_asg_act_id,p_assignment_id, p_payroll_action_id,p_chunk,NULL);
1778:
1779: --
1780: END IF;
1781: hr_utility.set_location('NSI Archive Assignment Action Id '||l_asg_act_id,450);
1782:
1783:
1784: pay_action_information_api.create_action_information (
1785: p_action_information_id => l_action_info_id

Line 1817: hr_utility.set_location('NSI Archive l_action_info_id'||l_action_info_id,450);

1813: ,p_action_information21 => v_csr_ee_nsi_record.Employee_Pop_Reg_Add
1814: ,p_action_information22 => v_csr_ee_nsi_record.Gak_Rep_Info
1815: ,p_action_information23 => v_csr_ee_nsi_record.Cadans_Rep_Info
1816: ,p_action_information24 => v_csr_ee_nsi_record.Employee_Details );
1817: hr_utility.set_location('NSI Archive l_action_info_id'||l_action_info_id,450);
1818:
1819: END LOOP;
1820:
1821: IF l_withdrawn_action_count >0 then

Line 1829: hr_utility.set_location('Leaving Withdraw NSI Notification',370);

1825: CLOSE csr_ee_prev_nsi;
1826: END IF;
1827: p_lst_nsi_process_date :=v_csr_ee_prev_nsi.prev_nsi_process_date;
1828: p_assignment_action_id := l_asg_act_id;
1829: hr_utility.set_location('Leaving Withdraw NSI Notification',370);
1830: END WITHDRAW_NL_NSI_EE_NOTIF;
1831: /*-------------------------------------------------------------------------------
1832: |NAME : ASSIGNMENT_ACTION_CODE |
1833: |TYPE : PROCEDURE |

Line 2004: --hr_utility.trace_on(NULL,'NL_NSI');

2000: l_St_Date_Lab_Rel VARCHAR2(1);
2001:
2002: BEGIN
2003: --
2004: --hr_utility.trace_on(NULL,'NL_NSI');
2005:
2006: hr_utility.set_location('Entering Assignment Action Code',400);
2007: --
2008: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');

Line 2006: hr_utility.set_location('Entering Assignment Action Code',400);

2002: BEGIN
2003: --
2004: --hr_utility.trace_on(NULL,'NL_NSI');
2005:
2006: hr_utility.set_location('Entering Assignment Action Code',400);
2007: --
2008: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
2009: g_warning_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','WARNING');
2010:

Line 2033: --hr_utility.set_location('NSI Archive p_payroll_action_id '||p_payroll_action_id,425);

2029:
2030: l_prepay_action_id := 0;
2031: --
2032:
2033: --hr_utility.set_location('NSI Archive p_payroll_action_id '||p_payroll_action_id,425);
2034: --hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
2035: --hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
2036: --hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
2037: --hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);

Line 2034: --hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);

2030: l_prepay_action_id := 0;
2031: --
2032:
2033: --hr_utility.set_location('NSI Archive p_payroll_action_id '||p_payroll_action_id,425);
2034: --hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
2035: --hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
2036: --hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
2037: --hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
2038: --hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);

Line 2035: --hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);

2031: --
2032:
2033: --hr_utility.set_location('NSI Archive p_payroll_action_id '||p_payroll_action_id,425);
2034: --hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
2035: --hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
2036: --hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
2037: --hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
2038: --hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
2039: --hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);

Line 2036: --hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);

2032:
2033: --hr_utility.set_location('NSI Archive p_payroll_action_id '||p_payroll_action_id,425);
2034: --hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
2035: --hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
2036: --hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
2037: --hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
2038: --hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
2039: --hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
2040: --hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);

Line 2037: --hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);

2033: --hr_utility.set_location('NSI Archive p_payroll_action_id '||p_payroll_action_id,425);
2034: --hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
2035: --hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
2036: --hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
2037: --hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
2038: --hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
2039: --hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
2040: --hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);
2041: --hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);

Line 2038: --hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);

2034: --hr_utility.set_location('NSI Archive l_business_group_id '||l_business_group_id,425);
2035: --hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
2036: --hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
2037: --hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
2038: --hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
2039: --hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
2040: --hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);
2041: --hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);
2042:

Line 2039: --hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);

2035: --hr_utility.set_location('NSI Archive l_employer_id '||l_employer_id,425);
2036: --hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
2037: --hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
2038: --hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
2039: --hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
2040: --hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);
2041: --hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);
2042:
2043: l_Prev_Person_ID := NULL;

Line 2040: --hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);

2036: --hr_utility.set_location('NSI Archive l_si_provider_id '||l_si_provider_id,425);
2037: --hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
2038: --hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
2039: --hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
2040: --hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);
2041: --hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);
2042:
2043: l_Prev_Person_ID := NULL;
2044: l_Prev_Assignment_ID := NULL;

Line 2041: --hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);

2037: --hr_utility.set_location('NSI Archive l_nsi_month '||l_nsi_month,425);
2038: --hr_utility.set_location('NSI Archive l_payroll_id '||l_payroll_id,425);
2039: --hr_utility.set_location('NSI Archive l_withdraw_asg_set_id '||l_withdraw_asg_set_id,425);
2040: --hr_utility.set_location('NSI Archive l_NSI_Process_Date '||l_NSI_Process_Date,425);
2041: --hr_utility.set_location('NSI Archive l_report_type '||l_report_type,425);
2042:
2043: l_Prev_Person_ID := NULL;
2044: l_Prev_Assignment_ID := NULL;
2045:

Line 2058: hr_utility.set_location('l_Person_ID '||l_Person_ID||' l_Assignment_ID '||l_Assignment_ID,450);

2054: --Intialize all NSI Record Variables
2055: l_Code_Insurance := NULL;
2056: l_Person_ID:= csr_ee_rec.Person_ID;
2057: l_Assignment_ID:= csr_ee_rec.Assignment_ID;
2058: hr_utility.set_location('l_Person_ID '||l_Person_ID||' l_Assignment_ID '||l_Assignment_ID,450);
2059:
2060: IF l_Prev_Person_ID = l_Person_ID
2061: AND l_Prev_Assignment_ID = l_Assignment_ID THEN
2062: v_Skip_Asg := TRUE;

Line 2078: hr_utility.set_location('v_csr_ee_lat_nsi.nsi_process_date: '||v_csr_ee_lat_nsi.nsi_process_date,450);

2074: OPEN csr_ee_lat_nsi(csr_ee_rec.organization_id,l_si_provider_id
2075: ,csr_ee_rec.person_id,csr_ee_rec.assignment_id,l_NSI_Process_Date);
2076: FETCH csr_ee_lat_nsi INTO v_csr_ee_lat_nsi;
2077: CLOSE csr_ee_lat_nsi;
2078: hr_utility.set_location('v_csr_ee_lat_nsi.nsi_process_date: '||v_csr_ee_lat_nsi.nsi_process_date,450);
2079:
2080:
2081: --Withdraw the Assignment,if included in the specified Withdraw Asg Set
2082: IF l_withdraw_asg_set_id IS NOT NULL THEN

Line 2086: hr_utility.set_location('Asg in Withdrawal Set '||l_Assignment_ID,450);

2082: IF l_withdraw_asg_set_id IS NOT NULL THEN
2083: OPEN csr_withdraw_asg(l_withdraw_asg_set_id ,l_Assignment_ID);
2084: FETCH csr_withdraw_asg INTO v_csr_withdraw_asg;
2085: IF csr_withdraw_asg%FOUND THEN
2086: hr_utility.set_location('Asg in Withdrawal Set '||l_Assignment_ID,450);
2087: IF v_csr_ee_lat_nsi.nsi_process_date IS NOT NULL THEN
2088: WITHDRAW_NL_NSI_EE_NOTIF(p_payroll_action_id,p_chunk
2089: ,csr_ee_rec.person_id,csr_ee_rec.assignment_id
2090: ,csr_ee_rec.organization_id,l_si_provider_id

Line 2092: hr_utility.set_location('l_asg_act_id: '||l_asg_act_id,450);

2088: WITHDRAW_NL_NSI_EE_NOTIF(p_payroll_action_id,p_chunk
2089: ,csr_ee_rec.person_id,csr_ee_rec.assignment_id
2090: ,csr_ee_rec.organization_id,l_si_provider_id
2091: ,l_NSI_Process_Date,v_csr_ee_lat_nsi.nsi_process_date,l_asg_act_id,l_Withdraw_New_Hire);
2092: hr_utility.set_location('l_asg_act_id: '||l_asg_act_id,450);
2093: END IF;
2094:
2095: END IF;
2096: CLOSE csr_withdraw_asg;

Line 2098: hr_utility.set_location('After Withdraw v_csr_ee_lat_nsi.nsi_process_date: '||v_csr_ee_lat_nsi.nsi_process_date,450);

2094:
2095: END IF;
2096: CLOSE csr_withdraw_asg;
2097: END IF;
2098: hr_utility.set_location('After Withdraw v_csr_ee_lat_nsi.nsi_process_date: '||v_csr_ee_lat_nsi.nsi_process_date,450);
2099:
2100: IF l_Withdraw_New_Hire THEN
2101: --If Previous NSI Record- Notif-a is withdrawn
2102: --Fresh NSI Notif -a with 1 needs to be generated.

Line 2113: hr_utility.set_location(' ZW -'||v_csr_ee_si_prov_info.zw_provider||' WW -'||v_csr_ee_si_prov_info.ww_provider

2109: ,csr_ee_rec.wao_si_status,csr_ee_rec.zfw_si_status);
2110: FETCH csr_ee_si_prov_info INTO v_csr_ee_si_prov_info;
2111: CLOSE csr_ee_si_prov_info;
2112:
2113: hr_utility.set_location(' ZW -'||v_csr_ee_si_prov_info.zw_provider||' WW -'||v_csr_ee_si_prov_info.ww_provider
2114: ||' WAO -'||v_csr_ee_si_prov_info.wao_provider||' ZFW - '||v_csr_ee_si_prov_info.zfw_provider,450);
2115:
2116: --Determine Code Insurance
2117: IF v_csr_ee_si_prov_info.zw_provider=l_si_provider_id

Line 2150: hr_utility.set_location('l_Code_Insurance '||l_Code_Insurance,450);

2146: ELSE
2147: l_Code_Insurance := l_Code_Insurance||'2';
2148: END IF;
2149:
2150: hr_utility.set_location('l_Code_Insurance '||l_Code_Insurance,450);
2151: --
2152:
2153: IF l_Code_Insurance <>'2222' AND length(l_Code_Insurance)=4 THEN
2154: hr_utility.set_location('l_Prev_Person_ID '||l_Prev_Person_ID||' l_Person_ID '||l_Person_ID,450);

Line 2154: hr_utility.set_location('l_Prev_Person_ID '||l_Prev_Person_ID||' l_Person_ID '||l_Person_ID,450);

2150: hr_utility.set_location('l_Code_Insurance '||l_Code_Insurance,450);
2151: --
2152:
2153: IF l_Code_Insurance <>'2222' AND length(l_Code_Insurance)=4 THEN
2154: hr_utility.set_location('l_Prev_Person_ID '||l_Prev_Person_ID||' l_Person_ID '||l_Person_ID,450);
2155: hr_utility.set_location('l_Prev_Assignment_ID '||l_Prev_Assignment_ID||' l_Assignment_ID '||l_Assignment_ID,450);
2156: hr_utility.set_location('l_Prev_SIProvider_ID '||l_Prev_SIProvider_ID||' l_si_provider_id '||l_si_provider_id,450);
2157:
2158: l_Create_NSI := TRUE;--Reset the NSI Record Creation Flag

Line 2155: hr_utility.set_location('l_Prev_Assignment_ID '||l_Prev_Assignment_ID||' l_Assignment_ID '||l_Assignment_ID,450);

2151: --
2152:
2153: IF l_Code_Insurance <>'2222' AND length(l_Code_Insurance)=4 THEN
2154: hr_utility.set_location('l_Prev_Person_ID '||l_Prev_Person_ID||' l_Person_ID '||l_Person_ID,450);
2155: hr_utility.set_location('l_Prev_Assignment_ID '||l_Prev_Assignment_ID||' l_Assignment_ID '||l_Assignment_ID,450);
2156: hr_utility.set_location('l_Prev_SIProvider_ID '||l_Prev_SIProvider_ID||' l_si_provider_id '||l_si_provider_id,450);
2157:
2158: l_Create_NSI := TRUE;--Reset the NSI Record Creation Flag
2159: IF l_Prev_Person_ID = l_Person_ID

Line 2156: hr_utility.set_location('l_Prev_SIProvider_ID '||l_Prev_SIProvider_ID||' l_si_provider_id '||l_si_provider_id,450);

2152:
2153: IF l_Code_Insurance <>'2222' AND length(l_Code_Insurance)=4 THEN
2154: hr_utility.set_location('l_Prev_Person_ID '||l_Prev_Person_ID||' l_Person_ID '||l_Person_ID,450);
2155: hr_utility.set_location('l_Prev_Assignment_ID '||l_Prev_Assignment_ID||' l_Assignment_ID '||l_Assignment_ID,450);
2156: hr_utility.set_location('l_Prev_SIProvider_ID '||l_Prev_SIProvider_ID||' l_si_provider_id '||l_si_provider_id,450);
2157:
2158: l_Create_NSI := TRUE;--Reset the NSI Record Creation Flag
2159: IF l_Prev_Person_ID = l_Person_ID
2160: AND l_Prev_Assignment_ID <> l_Assignment_ID

Line 2166: hr_utility.set_location('l_Create_NSI TRUE '||l_withdraw_asg_set_id||' Asg Id: '||l_Assignment_ID,450);

2162: l_Create_NSI := FALSE;
2163: END IF;
2164:
2165: IF l_Create_NSI THEN
2166: hr_utility.set_location('l_Create_NSI TRUE '||l_withdraw_asg_set_id||' Asg Id: '||l_Assignment_ID,450);
2167: IF v_csr_ee_lat_nsi.nsi_process_date IS NULL THEN
2168: l_Create_NSI := TRUE;--Archive NSI Record Not Found.Hence Creating NSI
2169:
2170: hr_utility.set_location('Calling ARCHIVE_NL_NSI_EE_DETAILS in STARTER Rec Mode ',450);

Line 2170: hr_utility.set_location('Calling ARCHIVE_NL_NSI_EE_DETAILS in STARTER Rec Mode ',450);

2166: hr_utility.set_location('l_Create_NSI TRUE '||l_withdraw_asg_set_id||' Asg Id: '||l_Assignment_ID,450);
2167: IF v_csr_ee_lat_nsi.nsi_process_date IS NULL THEN
2168: l_Create_NSI := TRUE;--Archive NSI Record Not Found.Hence Creating NSI
2169:
2170: hr_utility.set_location('Calling ARCHIVE_NL_NSI_EE_DETAILS in STARTER Rec Mode ',450);
2171: ARCHIVE_NL_NSI_EE_DETAILS
2172: (l_business_group_id,l_report_type,p_payroll_action_id,l_asg_act_id,p_chunk,'STARTER'
2173: ,csr_ee_rec.person_id,csr_ee_rec.assignment_id
2174: ,csr_ee_rec.organization_id,l_si_provider_id

Line 2177: hr_utility.set_location('Calling ARCHIVE_NL_NSI_EE_DETAILS in EXISTING Rec Mode ',450);

2173: ,csr_ee_rec.person_id,csr_ee_rec.assignment_id
2174: ,csr_ee_rec.organization_id,l_si_provider_id
2175: ,l_NSI_Process_Date,v_csr_ee_lat_nsi.nsi_process_date);
2176: ELSE
2177: hr_utility.set_location('Calling ARCHIVE_NL_NSI_EE_DETAILS in EXISTING Rec Mode ',450);
2178: ARCHIVE_NL_NSI_EE_DETAILS
2179: (l_business_group_id,l_report_type,p_payroll_action_id,l_asg_act_id,p_chunk,'EXISTING'
2180: ,csr_ee_rec.person_id,csr_ee_rec.assignment_id
2181: ,csr_ee_rec.organization_id,l_si_provider_id

Line 2193: hr_utility.set_location('Leaving Assignment Action Code',500);

2189:
2190: END IF;--End of IF for Skip Asg Check
2191: END LOOP;
2192: --
2193: hr_utility.set_location('Leaving Assignment Action Code',500);
2194: --
2195: END ASSIGNMENT_ACTION_CODE;
2196:
2197:

Line 2208: hr_utility.set_location('Entering Archive Init',600);

2204: Procedure ARCHIVE_INIT(p_payroll_action_id IN NUMBER) IS
2205:
2206: BEGIN
2207: --
2208: hr_utility.set_location('Entering Archive Init',600);
2209: hr_utility.set_location('Leaving Archive Init',700);
2210: --
2211: END ARCHIVE_INIT;
2212:

Line 2209: hr_utility.set_location('Leaving Archive Init',700);

2205:
2206: BEGIN
2207: --
2208: hr_utility.set_location('Entering Archive Init',600);
2209: hr_utility.set_location('Leaving Archive Init',700);
2210: --
2211: END ARCHIVE_INIT;
2212:
2213:

Line 2229: hr_utility.set_location('Entering Archive Code',800);

2225:
2226:
2227: BEGIN
2228: --
2229: hr_utility.set_location('Entering Archive Code',800);
2230: hr_utility.set_location('Leaving Archive Code',800);
2231: --
2232: END ARCHIVE_CODE;
2233:

Line 2230: hr_utility.set_location('Leaving Archive Code',800);

2226:
2227: BEGIN
2228: --
2229: hr_utility.set_location('Entering Archive Code',800);
2230: hr_utility.set_location('Leaving Archive Code',800);
2231: --
2232: END ARCHIVE_CODE;
2233:
2234: END PAY_NL_NSI_PROCESS;