DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on FND_MESSAGE

Line 309: -- fnd_message.set_name('PQP','PQP_230129_PEN_AGE_ANN_SAL_THR');

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

Line 310: -- fnd_message.set_token('PT Name',g_pension_rec(l_pension_id).pension_type_name);

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

Line 311: -- p_error_message := fnd_message.get();

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

Line 2355: fnd_message.set_name('PQP',l_error_message);

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;

Line 2356: p_error_message :='Error : '|| fnd_message.get();

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

Line 3205: fnd_message.set_name('PQP',l_error_message);

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

Line 3206: p_error_message :='Error' || fnd_message.get();

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

Line 3598: fnd_message.set_name('PQP','PQP_NO_PERSON');

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:

Line 3601: fnd_message.raise_error;

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