305: hr_utility.set_location('NO_DATA_FOUND for UDT : ', 90);
306:
307: p_column_value := trim(to_char(0,'9'));
308:
309: -- fnd_message.set_name('PQP','PQP_230129_PEN_AGE_ANN_SAL_THR');
310: -- fnd_message.set_token('PT Name',g_pension_rec(l_pension_id).pension_type_name);
311: -- p_error_message := fnd_message.get();
312:
313: p_error_message := 'Pension Type: '
306:
307: p_column_value := trim(to_char(0,'9'));
308:
309: -- fnd_message.set_name('PQP','PQP_230129_PEN_AGE_ANN_SAL_THR');
310: -- fnd_message.set_token('PT Name',g_pension_rec(l_pension_id).pension_type_name);
311: -- p_error_message := fnd_message.get();
312:
313: p_error_message := 'Pension Type: '
314: || g_pension_rec(l_pension_id).pension_type_name
307: p_column_value := trim(to_char(0,'9'));
308:
309: -- fnd_message.set_name('PQP','PQP_230129_PEN_AGE_ANN_SAL_THR');
310: -- fnd_message.set_token('PT Name',g_pension_rec(l_pension_id).pension_type_name);
311: -- p_error_message := fnd_message.get();
312:
313: p_error_message := 'Pension Type: '
314: || g_pension_rec(l_pension_id).pension_type_name
315: ||' has age dependent thresholds. '
2351: -- The effective date is now the valid assignemnt
2352: --start date for the assignment
2353: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);
2354: IF(l_error_status = trim(to_char(1,'9'))) Then
2355: fnd_message.set_name('PQP',l_error_message);
2356: p_error_message :='Error : '|| fnd_message.get();
2357: p_salary_balance_value :=0;
2358: RETURN 1;
2359: End IF;
2352: --start date for the assignment
2353: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);
2354: IF(l_error_status = trim(to_char(1,'9'))) Then
2355: fnd_message.set_name('PQP',l_error_message);
2356: p_error_message :='Error : '|| fnd_message.get();
2357: p_salary_balance_value :=0;
2358: RETURN 1;
2359: End IF;
2360: ELSE
3201: -- NON-ABP Pension Types
3202: -- The effective date is now the valid assignment start date
3203: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);
3204: IF (l_error_status = trim(to_char(1,'9'))) Then
3205: fnd_message.set_name('PQP',l_error_message);
3206: p_error_message :='Error' || fnd_message.get();
3207: RETURN 0;
3208: End IF;
3209: ELSE
3202: -- The effective date is now the valid assignment start date
3203: l_effective_date := PQP_NL_ABP_FUNCTIONS.GET_VALID_START_DATE(p_assignment_id,p_date_earned,l_error_status,l_error_message);
3204: IF (l_error_status = trim(to_char(1,'9'))) Then
3205: fnd_message.set_name('PQP',l_error_message);
3206: p_error_message :='Error' || fnd_message.get();
3207: RETURN 0;
3208: End IF;
3209: ELSE
3210: -- ABP Pension Types
3594:
3595: if c_get_person_id%NOTFOUND THEN
3596:
3597: close c_get_person_id;
3598: fnd_message.set_name('PQP','PQP_NO_PERSON');
3599:
3600:
3601: fnd_message.raise_error;
3602:
3597: close c_get_person_id;
3598: fnd_message.set_name('PQP','PQP_NO_PERSON');
3599:
3600:
3601: fnd_message.raise_error;
3602:
3603: else
3604:
3605: hr_utility.set_location('get all assignment ids ',30);