198: lv_record_name := 'Provincial Amendment Pre-Process';
199: lv_message := 'No Employee or Assignment Set specified';
200:
201: /* push message into pay_message_lines */
202: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
203: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
204: pay_core_utils.push_token('name_or_number','');
205: pay_core_utils.push_token('description',substr(lv_message,1,50));
206:
199: lv_message := 'No Employee or Assignment Set specified';
200:
201: /* push message into pay_message_lines */
202: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
203: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
204: pay_core_utils.push_token('name_or_number','');
205: pay_core_utils.push_token('description',substr(lv_message,1,50));
206:
207: lv_sql_string :=
200:
201: /* push message into pay_message_lines */
202: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
203: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
204: pay_core_utils.push_token('name_or_number','');
205: pay_core_utils.push_token('description',substr(lv_message,1,50));
206:
207: lv_sql_string :=
208: 'select distinct asg.person_id person_id
201: /* push message into pay_message_lines */
202: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
203: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
204: pay_core_utils.push_token('name_or_number','');
205: pay_core_utils.push_token('description',substr(lv_message,1,50));
206:
207: lv_sql_string :=
208: 'select distinct asg.person_id person_id
209: from per_all_assignments_f asg
365: lv_record_name := 'RL1 Amendment Pre-Process';
366: lv_message := 'Prov YE Preprocess was not run for this employee';
367:
368: /* push message into pay_message_lines */
369: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
370: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
371: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
372: pay_core_utils.push_token('description',substr(lv_message,1,50));
373:
366: lv_message := 'Prov YE Preprocess was not run for this employee';
367:
368: /* push message into pay_message_lines */
369: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
370: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
371: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
372: pay_core_utils.push_token('description',substr(lv_message,1,50));
373:
374: end if;
367:
368: /* push message into pay_message_lines */
369: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
370: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
371: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
372: pay_core_utils.push_token('description',substr(lv_message,1,50));
373:
374: end if;
375:
368: /* push message into pay_message_lines */
369: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','A');
370: pay_core_utils.push_token('record_name',substr(lv_record_name,1,50));
371: pay_core_utils.push_token('name_or_number',substr(lv_name,1,50));
372: pay_core_utils.push_token('description',substr(lv_message,1,50));
373:
374: end if;
375:
376: