326: lv_record_name := 'Federal Amendment Pre-Process';
327: lv_message := 'No Employee or Assignment Set specified';
328:
329: /* push message into pay_message_lines */
330: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
331: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
332: pay_core_utils.push_token('name_or_number','');
333: pay_core_utils.push_token('description',substr(lv_message,1,50));
334:
327: lv_message := 'No Employee or Assignment Set specified';
328:
329: /* push message into pay_message_lines */
330: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
331: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
332: pay_core_utils.push_token('name_or_number','');
333: pay_core_utils.push_token('description',substr(lv_message,1,50));
334:
335: lv_sql_string :=
328:
329: /* push message into pay_message_lines */
330: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
331: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
332: pay_core_utils.push_token('name_or_number','');
333: pay_core_utils.push_token('description',substr(lv_message,1,50));
334:
335: lv_sql_string :=
336: 'select distinct asg.person_id person_id
329: /* push message into pay_message_lines */
330: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
331: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
332: pay_core_utils.push_token('name_or_number','');
333: pay_core_utils.push_token('description',substr(lv_message,1,50));
334:
335: lv_sql_string :=
336: 'select distinct asg.person_id person_id
337: from per_all_assignments_f asg
530: lv_record_name := 'T4 Amendment Pre-Process';
531: lv_message := 'Fed YE Preprocess was not run for this employee';
532:
533: /* push message into pay_message_lines */
534: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
535: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
536: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
537: pay_core_utils.push_token('description',substr(lv_message,1,50));
538:
531: lv_message := 'Fed YE Preprocess was not run for this employee';
532:
533: /* push message into pay_message_lines */
534: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
535: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
536: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
537: pay_core_utils.push_token('description',substr(lv_message,1,50));
538:
539: end if;
532:
533: /* push message into pay_message_lines */
534: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
535: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
536: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
537: pay_core_utils.push_token('description',substr(lv_message,1,50));
538:
539: end if;
540:
533: /* push message into pay_message_lines */
534: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
535: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
536: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
537: pay_core_utils.push_token('description',substr(lv_message,1,50));
538:
539: end if;
540:
541: