291: lv_record_name := 'Provincial Amendment Pre-Process';
292: lv_message := 'No Employee or Assignment Set specified';
293:
294: /* push message into pay_message_lines */
295: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
296: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
297: pay_core_utils.push_token('name_or_number','');
298: pay_core_utils.push_token('description',substr(lv_message,1,50));
299:
292: lv_message := 'No Employee or Assignment Set specified';
293:
294: /* push message into pay_message_lines */
295: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
296: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
297: pay_core_utils.push_token('name_or_number','');
298: pay_core_utils.push_token('description',substr(lv_message,1,50));
299:
300: lv_sql_string :=
293:
294: /* push message into pay_message_lines */
295: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
296: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
297: pay_core_utils.push_token('name_or_number','');
298: pay_core_utils.push_token('description',substr(lv_message,1,50));
299:
300: lv_sql_string :=
301: 'select distinct asg.person_id person_id
294: /* push message into pay_message_lines */
295: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
296: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
297: pay_core_utils.push_token('name_or_number','');
298: pay_core_utils.push_token('description',substr(lv_message,1,50));
299:
300: lv_sql_string :=
301: 'select distinct asg.person_id person_id
302: from per_all_assignments_f asg
513: lv_record_name := 'RL2 Amendment Pre-Process';
514: lv_message := 'Prov YE Preprocess was not run for this employee';
515:
516: /* push message into pay_message_lines */
517: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
518: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
519: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
520: pay_core_utils.push_token('description',substr(lv_message,1,50));
521:
514: lv_message := 'Prov YE Preprocess was not run for this employee';
515:
516: /* push message into pay_message_lines */
517: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
518: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
519: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
520: pay_core_utils.push_token('description',substr(lv_message,1,50));
521:
522: end if;
515:
516: /* push message into pay_message_lines */
517: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
518: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
519: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
520: pay_core_utils.push_token('description',substr(lv_message,1,50));
521:
522: end if;
523:
516: /* push message into pay_message_lines */
517: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
518: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
519: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
520: pay_core_utils.push_token('description',substr(lv_message,1,50));
521:
522: end if;
523:
524: