222: ,lv_error_mesg ) ;
223:
224: if lv_error_mesg is not null then
225: if substr(lv_error_mesg,1,45) is not null then
226: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
227: pay_core_utils.push_token('record_name',' ');
228: pay_core_utils.push_token('description',substr(lv_error_mesg,1,45));
229: end if;
230:
223:
224: if lv_error_mesg is not null then
225: if substr(lv_error_mesg,1,45) is not null then
226: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
227: pay_core_utils.push_token('record_name',' ');
228: pay_core_utils.push_token('description',substr(lv_error_mesg,1,45));
229: end if;
230:
231: if substr(lv_error_mesg,46,45) is not null then
224: if lv_error_mesg is not null then
225: if substr(lv_error_mesg,1,45) is not null then
226: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
227: pay_core_utils.push_token('record_name',' ');
228: pay_core_utils.push_token('description',substr(lv_error_mesg,1,45));
229: end if;
230:
231: if substr(lv_error_mesg,46,45) is not null then
232: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
228: pay_core_utils.push_token('description',substr(lv_error_mesg,1,45));
229: end if;
230:
231: if substr(lv_error_mesg,46,45) is not null then
232: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
233: pay_core_utils.push_token('record_name',' ');
234: pay_core_utils.push_token('description',substr(lv_error_mesg,46,45));
235: end if;
236:
229: end if;
230:
231: if substr(lv_error_mesg,46,45) is not null then
232: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
233: pay_core_utils.push_token('record_name',' ');
234: pay_core_utils.push_token('description',substr(lv_error_mesg,46,45));
235: end if;
236:
237: if substr(lv_error_mesg,91,45) is not null then
230:
231: if substr(lv_error_mesg,46,45) is not null then
232: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
233: pay_core_utils.push_token('record_name',' ');
234: pay_core_utils.push_token('description',substr(lv_error_mesg,46,45));
235: end if;
236:
237: if substr(lv_error_mesg,91,45) is not null then
238: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
234: pay_core_utils.push_token('description',substr(lv_error_mesg,46,45));
235: end if;
236:
237: if substr(lv_error_mesg,91,45) is not null then
238: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
239: pay_core_utils.push_token('record_name',' ');
240: pay_core_utils.push_token('description',substr(lv_error_mesg,91,45));
241: end if;
242:
235: end if;
236:
237: if substr(lv_error_mesg,91,45) is not null then
238: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
239: pay_core_utils.push_token('record_name',' ');
240: pay_core_utils.push_token('description',substr(lv_error_mesg,91,45));
241: end if;
242:
243: if substr(lv_error_mesg,136,45) is not null then
236:
237: if substr(lv_error_mesg,91,45) is not null then
238: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
239: pay_core_utils.push_token('record_name',' ');
240: pay_core_utils.push_token('description',substr(lv_error_mesg,91,45));
241: end if;
242:
243: if substr(lv_error_mesg,136,45) is not null then
244: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
240: pay_core_utils.push_token('description',substr(lv_error_mesg,91,45));
241: end if;
242:
243: if substr(lv_error_mesg,136,45) is not null then
244: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
245: pay_core_utils.push_token('record_name',' ');
246: pay_core_utils.push_token('description',substr(lv_error_mesg,136,45));
247: end if;
248:
241: end if;
242:
243: if substr(lv_error_mesg,136,45) is not null then
244: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
245: pay_core_utils.push_token('record_name',' ');
246: pay_core_utils.push_token('description',substr(lv_error_mesg,136,45));
247: end if;
248:
249: hr_utility.raise_error;
242:
243: if substr(lv_error_mesg,136,45) is not null then
244: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
245: pay_core_utils.push_token('record_name',' ');
246: pay_core_utils.push_token('description',substr(lv_error_mesg,136,45));
247: end if;
248:
249: hr_utility.raise_error;
250:
506:
507: lv_record_name := 'W2C Report';
508: lv_message := 'No W2c archive actions exist for this employee';
509:
510: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
511: pay_core_utils.push_token('record_name',lv_record_name);
512: pay_core_utils.push_token('name_or_number',lv_full_name);
513: pay_core_utils.push_token('description',lv_message);
514: end if;
507: lv_record_name := 'W2C Report';
508: lv_message := 'No W2c archive actions exist for this employee';
509:
510: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
511: pay_core_utils.push_token('record_name',lv_record_name);
512: pay_core_utils.push_token('name_or_number',lv_full_name);
513: pay_core_utils.push_token('description',lv_message);
514: end if;
515:
508: lv_message := 'No W2c archive actions exist for this employee';
509:
510: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
511: pay_core_utils.push_token('record_name',lv_record_name);
512: pay_core_utils.push_token('name_or_number',lv_full_name);
513: pay_core_utils.push_token('description',lv_message);
514: end if;
515:
516: if get_prev_w2c_dtls%found then
509:
510: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
511: pay_core_utils.push_token('record_name',lv_record_name);
512: pay_core_utils.push_token('name_or_number',lv_full_name);
513: pay_core_utils.push_token('description',lv_message);
514: end if;
515:
516: if get_prev_w2c_dtls%found then
517: if lv_report_type in ('W2C_PRE_PROCESS') then
580: lv_record_name := 'W2C Report';
581: lv_message := 'No new w2c archive actions exist '||
582: 'for this employee';
583:
584: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
585: pay_core_utils.push_token('record_name',lv_record_name);
586: pay_core_utils.push_token('name_or_number',lv_full_name);
587: pay_core_utils.push_token('description',lv_message);
588:
581: lv_message := 'No new w2c archive actions exist '||
582: 'for this employee';
583:
584: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
585: pay_core_utils.push_token('record_name',lv_record_name);
586: pay_core_utils.push_token('name_or_number',lv_full_name);
587: pay_core_utils.push_token('description',lv_message);
588:
589: end if; /* report type */
582: 'for this employee';
583:
584: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
585: pay_core_utils.push_token('record_name',lv_record_name);
586: pay_core_utils.push_token('name_or_number',lv_full_name);
587: pay_core_utils.push_token('description',lv_message);
588:
589: end if; /* report type */
590:
583:
584: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
585: pay_core_utils.push_token('record_name',lv_record_name);
586: pay_core_utils.push_token('name_or_number',lv_full_name);
587: pay_core_utils.push_token('description',lv_message);
588:
589: end if; /* report type */
590:
591: end if; /* employee found*/