959: --{
960: IF l_addr_count = 0 THEN
961: hr_utility.trace('WARNING: Employee Address not found ');
962: l_valid_address := 'N';
963: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
964: pay_core_utils.push_token('record_name',l_record);
965: pay_core_utils.push_token('name_or_number',
966: lr_person_name_address.employee_number);
967: pay_core_utils.push_token('description',l_token2);
960: IF l_addr_count = 0 THEN
961: hr_utility.trace('WARNING: Employee Address not found ');
962: l_valid_address := 'N';
963: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
964: pay_core_utils.push_token('record_name',l_record);
965: pay_core_utils.push_token('name_or_number',
966: lr_person_name_address.employee_number);
967: pay_core_utils.push_token('description',l_token2);
968: ELSIF l_addr_count > 1 THEN
961: hr_utility.trace('WARNING: Employee Address not found ');
962: l_valid_address := 'N';
963: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
964: pay_core_utils.push_token('record_name',l_record);
965: pay_core_utils.push_token('name_or_number',
966: lr_person_name_address.employee_number);
967: pay_core_utils.push_token('description',l_token2);
968: ELSIF l_addr_count > 1 THEN
969: hr_utility.trace('Too many rows for the address');
963: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
964: pay_core_utils.push_token('record_name',l_record);
965: pay_core_utils.push_token('name_or_number',
966: lr_person_name_address.employee_number);
967: pay_core_utils.push_token('description',l_token2);
968: ELSIF l_addr_count > 1 THEN
969: hr_utility.trace('Too many rows for the address');
970: l_valid_address := 'N';
971: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
967: pay_core_utils.push_token('description',l_token2);
968: ELSIF l_addr_count > 1 THEN
969: hr_utility.trace('Too many rows for the address');
970: l_valid_address := 'N';
971: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
972: pay_core_utils.push_token('record_name',l_record);
973: pay_core_utils.push_token('name_or_number',
974: lr_person_name_address.employee_number);
975: pay_core_utils.push_token('description',l_too_many_adr_token3);
968: ELSIF l_addr_count > 1 THEN
969: hr_utility.trace('Too many rows for the address');
970: l_valid_address := 'N';
971: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
972: pay_core_utils.push_token('record_name',l_record);
973: pay_core_utils.push_token('name_or_number',
974: lr_person_name_address.employee_number);
975: pay_core_utils.push_token('description',l_too_many_adr_token3);
976: ELSIF l_addr_count = 1 THEN
969: hr_utility.trace('Too many rows for the address');
970: l_valid_address := 'N';
971: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
972: pay_core_utils.push_token('record_name',l_record);
973: pay_core_utils.push_token('name_or_number',
974: lr_person_name_address.employee_number);
975: pay_core_utils.push_token('description',l_too_many_adr_token3);
976: ELSIF l_addr_count = 1 THEN
977: l_valid_address:= 'Y';
971: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
972: pay_core_utils.push_token('record_name',l_record);
973: pay_core_utils.push_token('name_or_number',
974: lr_person_name_address.employee_number);
975: pay_core_utils.push_token('description',l_too_many_adr_token3);
976: ELSIF l_addr_count = 1 THEN
977: l_valid_address:= 'Y';
978: hr_utility.trace('Single Primary Valid Address Found ..'||l_valid_address);
979: END IF;
1041: IF p_validate = 'Y' THEN
1042: --{
1043: IF l_addr_count = 0 THEN
1044: l_token2 := 'No data found for GRE ID '||to_char(p_organization_id);
1045: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1046: pay_core_utils.push_token('record_name',p_source_type||' record');
1047: pay_core_utils.push_token('description',l_token2);
1048: l_valid_address:='N';
1049: hr_utility.trace('ER_ADDRESS No data found for Tax_Unit_Id = '
1042: --{
1043: IF l_addr_count = 0 THEN
1044: l_token2 := 'No data found for GRE ID '||to_char(p_organization_id);
1045: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1046: pay_core_utils.push_token('record_name',p_source_type||' record');
1047: pay_core_utils.push_token('description',l_token2);
1048: l_valid_address:='N';
1049: hr_utility.trace('ER_ADDRESS No data found for Tax_Unit_Id = '
1050: ||to_char(p_organization_id));
1043: IF l_addr_count = 0 THEN
1044: l_token2 := 'No data found for GRE ID '||to_char(p_organization_id);
1045: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1046: pay_core_utils.push_token('record_name',p_source_type||' record');
1047: pay_core_utils.push_token('description',l_token2);
1048: l_valid_address:='N';
1049: hr_utility.trace('ER_ADDRESS No data found for Tax_Unit_Id = '
1050: ||to_char(p_organization_id));
1051: ELSIF l_addr_count > 1 THEN
1050: ||to_char(p_organization_id));
1051: ELSIF l_addr_count > 1 THEN
1052: hr_utility.trace('Too many rows for the address');
1053: l_valid_address := 'N';
1054: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1055: pay_core_utils.push_token('record_name',p_source_type||' record');
1056: pay_core_utils.push_token('description',l_too_many_adr_token3);
1057: ELSIF l_addr_count = 1 THEN
1058: hr_utility.trace('ER_ADDRESS Employer Address Found ');
1051: ELSIF l_addr_count > 1 THEN
1052: hr_utility.trace('Too many rows for the address');
1053: l_valid_address := 'N';
1054: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1055: pay_core_utils.push_token('record_name',p_source_type||' record');
1056: pay_core_utils.push_token('description',l_too_many_adr_token3);
1057: ELSIF l_addr_count = 1 THEN
1058: hr_utility.trace('ER_ADDRESS Employer Address Found ');
1059: l_valid_address:='Y';
1052: hr_utility.trace('Too many rows for the address');
1053: l_valid_address := 'N';
1054: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1055: pay_core_utils.push_token('record_name',p_source_type||' record');
1056: pay_core_utils.push_token('description',l_too_many_adr_token3);
1057: ELSIF l_addr_count = 1 THEN
1058: hr_utility.trace('ER_ADDRESS Employer Address Found ');
1059: l_valid_address:='Y';
1060: END IF;