DBA Data[Home] [Help]

APPS.PAY_US_GET_ITEM_DATA_PKG dependencies on PAY_CORE_UTILS

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

1076: --{
1077: IF l_addr_count = 0 THEN
1078: hr_utility.trace('WARNING: Employee Address not found ');
1079: l_valid_address := 'N';
1080: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
1081: pay_core_utils.push_token('record_name',l_record);
1082: pay_core_utils.push_token('name_or_number',
1083: lr_person_name_address.employee_number);
1084: pay_core_utils.push_token('description',l_token2);

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

1077: IF l_addr_count = 0 THEN
1078: hr_utility.trace('WARNING: Employee Address not found ');
1079: l_valid_address := 'N';
1080: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
1081: pay_core_utils.push_token('record_name',l_record);
1082: pay_core_utils.push_token('name_or_number',
1083: lr_person_name_address.employee_number);
1084: pay_core_utils.push_token('description',l_token2);
1085: ELSIF l_addr_count > 1 THEN

Line 1082: pay_core_utils.push_token('name_or_number',

1078: hr_utility.trace('WARNING: Employee Address not found ');
1079: l_valid_address := 'N';
1080: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
1081: pay_core_utils.push_token('record_name',l_record);
1082: pay_core_utils.push_token('name_or_number',
1083: lr_person_name_address.employee_number);
1084: pay_core_utils.push_token('description',l_token2);
1085: ELSIF l_addr_count > 1 THEN
1086: hr_utility.trace('Too many rows for the address');

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

1080: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
1081: pay_core_utils.push_token('record_name',l_record);
1082: pay_core_utils.push_token('name_or_number',
1083: lr_person_name_address.employee_number);
1084: pay_core_utils.push_token('description',l_token2);
1085: ELSIF l_addr_count > 1 THEN
1086: hr_utility.trace('Too many rows for the address');
1087: l_valid_address := 'N';
1088: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');

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

1084: pay_core_utils.push_token('description',l_token2);
1085: ELSIF l_addr_count > 1 THEN
1086: hr_utility.trace('Too many rows for the address');
1087: l_valid_address := 'N';
1088: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
1089: pay_core_utils.push_token('record_name',l_record);
1090: pay_core_utils.push_token('name_or_number',
1091: lr_person_name_address.employee_number);
1092: pay_core_utils.push_token('description',l_too_many_adr_token3);

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

1085: ELSIF l_addr_count > 1 THEN
1086: hr_utility.trace('Too many rows for the address');
1087: l_valid_address := 'N';
1088: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
1089: pay_core_utils.push_token('record_name',l_record);
1090: pay_core_utils.push_token('name_or_number',
1091: lr_person_name_address.employee_number);
1092: pay_core_utils.push_token('description',l_too_many_adr_token3);
1093: ELSIF l_addr_count = 1 THEN

Line 1090: pay_core_utils.push_token('name_or_number',

1086: hr_utility.trace('Too many rows for the address');
1087: l_valid_address := 'N';
1088: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
1089: pay_core_utils.push_token('record_name',l_record);
1090: pay_core_utils.push_token('name_or_number',
1091: lr_person_name_address.employee_number);
1092: pay_core_utils.push_token('description',l_too_many_adr_token3);
1093: ELSIF l_addr_count = 1 THEN
1094: l_valid_address:= 'Y';

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

1088: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
1089: pay_core_utils.push_token('record_name',l_record);
1090: pay_core_utils.push_token('name_or_number',
1091: lr_person_name_address.employee_number);
1092: pay_core_utils.push_token('description',l_too_many_adr_token3);
1093: ELSIF l_addr_count = 1 THEN
1094: l_valid_address:= 'Y';
1095: hr_utility.trace('Single Primary Valid Address Found ..'||l_valid_address);
1096: END IF;

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

1159: IF p_validate = 'Y' THEN
1160: --{
1161: IF l_addr_count = 0 THEN
1162: l_token2 := 'No data found for GRE ID '||to_char(p_organization_id);
1163: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1164: pay_core_utils.push_token('record_name',p_source_type||' record');
1165: pay_core_utils.push_token('description',l_token2);
1166: l_valid_address:='N';
1167: hr_utility.trace('ER_ADDRESS No data found for Tax_Unit_Id = '

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

1160: --{
1161: IF l_addr_count = 0 THEN
1162: l_token2 := 'No data found for GRE ID '||to_char(p_organization_id);
1163: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1164: pay_core_utils.push_token('record_name',p_source_type||' record');
1165: pay_core_utils.push_token('description',l_token2);
1166: l_valid_address:='N';
1167: hr_utility.trace('ER_ADDRESS No data found for Tax_Unit_Id = '
1168: ||to_char(p_organization_id));

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

1161: IF l_addr_count = 0 THEN
1162: l_token2 := 'No data found for GRE ID '||to_char(p_organization_id);
1163: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1164: pay_core_utils.push_token('record_name',p_source_type||' record');
1165: pay_core_utils.push_token('description',l_token2);
1166: l_valid_address:='N';
1167: hr_utility.trace('ER_ADDRESS No data found for Tax_Unit_Id = '
1168: ||to_char(p_organization_id));
1169: ELSIF l_addr_count > 1 THEN

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

1168: ||to_char(p_organization_id));
1169: ELSIF l_addr_count > 1 THEN
1170: hr_utility.trace('Too many rows for the address');
1171: l_valid_address := 'N';
1172: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1173: pay_core_utils.push_token('record_name',p_source_type||' record');
1174: pay_core_utils.push_token('description',l_too_many_adr_token3);
1175: ELSIF l_addr_count = 1 THEN
1176: hr_utility.trace('ER_ADDRESS Employer Address Found ');

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

1169: ELSIF l_addr_count > 1 THEN
1170: hr_utility.trace('Too many rows for the address');
1171: l_valid_address := 'N';
1172: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1173: pay_core_utils.push_token('record_name',p_source_type||' record');
1174: pay_core_utils.push_token('description',l_too_many_adr_token3);
1175: ELSIF l_addr_count = 1 THEN
1176: hr_utility.trace('ER_ADDRESS Employer Address Found ');
1177: l_valid_address:='Y';

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

1170: hr_utility.trace('Too many rows for the address');
1171: l_valid_address := 'N';
1172: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1173: pay_core_utils.push_token('record_name',p_source_type||' record');
1174: pay_core_utils.push_token('description',l_too_many_adr_token3);
1175: ELSIF l_addr_count = 1 THEN
1176: hr_utility.trace('ER_ADDRESS Employer Address Found ');
1177: l_valid_address:='Y';
1178: END IF;