DBA Data[Home] [Help]

APPS.PAY_US_GET_ITEM_DATA_PKG dependencies on PAY_CORE_UTILS

Line 963: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');

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);

Line 964: pay_core_utils.push_token('record_name',l_record);

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

Line 965: pay_core_utils.push_token('name_or_number',

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');

Line 967: pay_core_utils.push_token('description',l_token2);

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');

Line 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);

Line 972: pay_core_utils.push_token('record_name',l_record);

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

Line 973: pay_core_utils.push_token('name_or_number',

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';

Line 975: pay_core_utils.push_token('description',l_too_many_adr_token3);

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;

Line 1045: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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 = '

Line 1046: pay_core_utils.push_token('record_name',p_source_type||' record');

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));

Line 1047: pay_core_utils.push_token('description',l_token2);

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

Line 1054: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');

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 ');

Line 1055: pay_core_utils.push_token('record_name',p_source_type||' record');

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';

Line 1056: pay_core_utils.push_token('description',l_too_many_adr_token3);

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;