184: lv_record_name := 'Federal Amendment Pre-Process';
185: lv_message := 'No Employee or Assignment Set specified';
186:
187: /* push message into pay_message_lines */
188: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
189: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
190: pay_core_utils.push_token('name_or_number','');
191: pay_core_utils.push_token('description',substr(lv_message,1,50));
192:
185: lv_message := 'No Employee or Assignment Set specified';
186:
187: /* push message into pay_message_lines */
188: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
189: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
190: pay_core_utils.push_token('name_or_number','');
191: pay_core_utils.push_token('description',substr(lv_message,1,50));
192:
193: lv_sql_string :=
186:
187: /* push message into pay_message_lines */
188: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
189: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
190: pay_core_utils.push_token('name_or_number','');
191: pay_core_utils.push_token('description',substr(lv_message,1,50));
192:
193: lv_sql_string :=
194: 'select distinct asg.person_id person_id
187: /* push message into pay_message_lines */
188: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
189: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
190: pay_core_utils.push_token('name_or_number','');
191: pay_core_utils.push_token('description',substr(lv_message,1,50));
192:
193: lv_sql_string :=
194: 'select distinct asg.person_id person_id
195: from per_all_assignments_f asg
354: lv_record_name := 'T4A Amendment Pre-Process';
355: lv_message := 'Federal YE Preprocess was not run for this employee';
356:
357: /* push message into pay_message_lines */
358: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
359: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
360: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
361: pay_core_utils.push_token('description',substr(lv_message,1,50));
362:
355: lv_message := 'Federal YE Preprocess was not run for this employee';
356:
357: /* push message into pay_message_lines */
358: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
359: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
360: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
361: pay_core_utils.push_token('description',substr(lv_message,1,50));
362:
363: end if;
356:
357: /* push message into pay_message_lines */
358: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
359: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
360: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
361: pay_core_utils.push_token('description',substr(lv_message,1,50));
362:
363: end if;
364:
357: /* push message into pay_message_lines */
358: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
359: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
360: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
361: pay_core_utils.push_token('description',substr(lv_message,1,50));
362:
363: end if;
364:
365: