DBA Data[Home] [Help]

APPS.PAY_NL_CBS_FILE dependencies on HR_GENERAL

Line 104: v_label_desc := hr_general.decode_lookup('HR_NL_REPORT_LABELS', p_field);

100: hr_utility.set_location('Started Checking Field in Mandatory_Check '||p_field,425);
101: end if;
102:
103: If p_value is null then
104: v_label_desc := hr_general.decode_lookup('HR_NL_REPORT_LABELS', p_field);
105: v_employee_dat :=RPAD(SUBSTR(g_assignment_number,1,20),20)
106: ||' '||RPAD(SUBSTR(g_full_name,1,35),35)
107: ||' '||RPAD(SUBSTR(v_label_desc,1,35),35);
108: -- ||' '||RPAD(SUBSTR(g_error_flag,1,15),15);

Line 114: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)

110: -- v_message_text :=SUBSTR(fnd_message.get,1,65);
111: g_error_count := NVL(g_error_count,0) +1;
112: if p_message_name <> g_message_name then
113: if g_message_name = 'PAY_NL_EE_REQUIRED_FIELD' then
114: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
115: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)
116: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)
117: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
118: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70

Line 115: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)

111: g_error_count := NVL(g_error_count,0) +1;
112: if p_message_name <> g_message_name then
113: if g_message_name = 'PAY_NL_EE_REQUIRED_FIELD' then
114: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
115: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)
116: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)
117: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
118: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70
119: ;

Line 116: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)

112: if p_message_name <> g_message_name then
113: if g_message_name = 'PAY_NL_EE_REQUIRED_FIELD' then
114: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
115: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)
116: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)
117: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
118: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70
119: ;
120: Fnd_file.put_line(FND_FILE.LOG,v_log_header);

Line 117: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)

113: if g_message_name = 'PAY_NL_EE_REQUIRED_FIELD' then
114: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
115: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)
116: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)
117: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
118: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70
119: ;
120: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
121: end if;

Line 118: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70

114: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
115: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)
116: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)
117: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
118: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70
119: ;
120: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
121: end if;
122: hr_utility.set_message(801,p_message_name);

Line 454: AND p_date between fnd_date.canonical_to_date(PAEI.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(PAEI.AEI_INFORMATION2),hr_general.end_of_time);

450: WHERE PAEI.ASSIGNMENT_ID = p_assignment_id
451: AND PAEI.AEI_INFORMATION_CATEGORY = 'NL_PHI'
452: AND ORGANIZATION_ID = PAEI.AEI_INFORMATION3
453: AND ORG_INFORMATION_CONTEXT = 'NL_PHI_ORG_INFO'
454: AND p_date between fnd_date.canonical_to_date(PAEI.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(PAEI.AEI_INFORMATION2),hr_general.end_of_time);
455:
456: -- For Fetching IZA Information
457: cursor csr_get_iza (p_assignment_id number,
458: p_date date) IS

Line 465: AND p_date between fnd_date.canonical_to_date(PAEI.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(PAEI.AEI_INFORMATION2),hr_general.end_of_time);

461: WHERE PAEI.ASSIGNMENT_ID = p_assignment_id
462: AND PAEI.AEI_INFORMATION_CATEGORY = 'NL_IZA_INFO'
463: AND HOI.ORGANIZATION_ID = PAEI.AEI_INFORMATION3
464: AND HOI.ORG_INFORMATION_CONTEXT = 'NL_PHI_ORG_INFO'
465: AND p_date between fnd_date.canonical_to_date(PAEI.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(PAEI.AEI_INFORMATION2),hr_general.end_of_time);
466:
467: l_si_status NUMBER;
468: l_si_provider VARCHAR2(150);
469:

Line 756: and p_rep_date between fnd_date.canonical_to_date(aei.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(aei.AEI_INFORMATION2),hr_general.end_of_time);

752:
753: CURSOR csr_get_cao_code(l_assignment_id NUMBER) IS
754: select AEI_INFORMATION5 from per_assignment_extra_info aei
755: WHERE aei.information_type like 'NL_CADANS_INFO' and aei.assignment_id = l_assignment_id
756: and p_rep_date between fnd_date.canonical_to_date(aei.AEI_INFORMATION1) and nvl(fnd_date.canonical_to_date(aei.AEI_INFORMATION2),hr_general.end_of_time);
757:
758: l_cao_code VARCHAR2(50);
759:
760: begin

Line 1036: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');

1032: hr_utility.trace_on(NULL,'CBS');
1033: hr_utility.set_location('Entering GET ALL PARAMETERS of Range Code ',600);
1034: end if;
1035:
1036: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
1037:
1038: PAY_NL_CBS_FILE.get_all_parameters(pactid,
1039: P_business_group_id => l_business_group_id,
1040: P_reporting_date => l_reporting_date,

Line 1163: /* v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)

1159: ORDER BY ppf.person_id';
1160:
1161: --and ppf.person_id = 13916';
1162:
1163: /* v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
1164: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)
1165: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)
1166: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
1167: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70

Line 1164: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)

1160:
1161: --and ppf.person_id = 13916';
1162:
1163: /* v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
1164: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)
1165: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)
1166: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
1167: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70
1168: );

Line 1165: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)

1161: --and ppf.person_id = 13916';
1162:
1163: /* v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
1164: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)
1165: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)
1166: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
1167: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70
1168: );
1169:

Line 1166: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)

1162:
1163: /* v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
1164: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)
1165: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)
1166: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
1167: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70
1168: );
1169:
1170: Fnd_file.put_line(FND_FILE.LOG,v_log_header);*/

Line 1167: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70

1163: /* v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
1164: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,35),35)
1165: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,35),35)
1166: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
1167: --||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70
1168: );
1169:
1170: Fnd_file.put_line(FND_FILE.LOG,v_log_header);*/
1171:

Line 1422: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');

1418: hr_utility.set_location('Entering Assignment Action Code',600);
1419: hr_utility.set_location('p_payroll_action_id'||p_payroll_action_id,400);
1420: end if;
1421:
1422: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
1423:
1424: /*Get concurrent program parameters*/
1425: PAY_NL_CBS_FILE.get_all_parameters(p_payroll_action_id,
1426: P_business_group_id => l_business_group_id,