300: lv_record_name := 'Provincial Amendment Pre-Process';
301: lv_message := 'No Employee or Assignment Set specified';
302:
303: /* push message into pay_message_lines */
304: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
305: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
306: pay_core_utils.push_token('name_or_number','');
307: pay_core_utils.push_token('description',substr(lv_message,1,50));
308:
301: lv_message := 'No Employee or Assignment Set specified';
302:
303: /* push message into pay_message_lines */
304: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
305: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
306: pay_core_utils.push_token('name_or_number','');
307: pay_core_utils.push_token('description',substr(lv_message,1,50));
308:
309: lv_sql_string :=
302:
303: /* push message into pay_message_lines */
304: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
305: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
306: pay_core_utils.push_token('name_or_number','');
307: pay_core_utils.push_token('description',substr(lv_message,1,50));
308:
309: lv_sql_string :=
310: 'select distinct asg.person_id person_id
303: /* push message into pay_message_lines */
304: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
305: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
306: pay_core_utils.push_token('name_or_number','');
307: pay_core_utils.push_token('description',substr(lv_message,1,50));
308:
309: lv_sql_string :=
310: 'select distinct asg.person_id person_id
311: from per_all_assignments_f asg
529: lv_record_name := 'RL1 Amendment Pre-Process';
530: lv_message := 'Prov YE Preprocess was not run for this employee';
531:
532: /* push message into pay_message_lines */
533: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
534: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
535: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
536: pay_core_utils.push_token('description',substr(lv_message,1,50));
537:
530: lv_message := 'Prov YE Preprocess was not run for this employee';
531:
532: /* push message into pay_message_lines */
533: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
534: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
535: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
536: pay_core_utils.push_token('description',substr(lv_message,1,50));
537:
538: end if;
531:
532: /* push message into pay_message_lines */
533: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
534: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
535: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
536: pay_core_utils.push_token('description',substr(lv_message,1,50));
537:
538: end if;
539:
532: /* push message into pay_message_lines */
533: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
534: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
535: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
536: pay_core_utils.push_token('description',substr(lv_message,1,50));
537:
538: end if;
539:
540: