268: ,lv_error_mesg ) ;
269:
270: if lv_error_mesg is not null then
271: if substr(lv_error_mesg,1,45) is not null then
272: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
273: pay_core_utils.push_token('record_name',' ');
274: pay_core_utils.push_token('description',substr(lv_error_mesg,1,45));
275: end if;
276:
269:
270: if lv_error_mesg is not null then
271: if substr(lv_error_mesg,1,45) is not null then
272: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
273: pay_core_utils.push_token('record_name',' ');
274: pay_core_utils.push_token('description',substr(lv_error_mesg,1,45));
275: end if;
276:
277: if substr(lv_error_mesg,46,45) is not null then
270: if lv_error_mesg is not null then
271: if substr(lv_error_mesg,1,45) is not null then
272: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
273: pay_core_utils.push_token('record_name',' ');
274: pay_core_utils.push_token('description',substr(lv_error_mesg,1,45));
275: end if;
276:
277: if substr(lv_error_mesg,46,45) is not null then
278: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
274: pay_core_utils.push_token('description',substr(lv_error_mesg,1,45));
275: end if;
276:
277: if substr(lv_error_mesg,46,45) is not null then
278: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
279: pay_core_utils.push_token('record_name',' ');
280: pay_core_utils.push_token('description',substr(lv_error_mesg,46,45));
281: end if;
282:
275: end if;
276:
277: if substr(lv_error_mesg,46,45) is not null then
278: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
279: pay_core_utils.push_token('record_name',' ');
280: pay_core_utils.push_token('description',substr(lv_error_mesg,46,45));
281: end if;
282:
283: if substr(lv_error_mesg,91,45) is not null then
276:
277: if substr(lv_error_mesg,46,45) is not null then
278: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
279: pay_core_utils.push_token('record_name',' ');
280: pay_core_utils.push_token('description',substr(lv_error_mesg,46,45));
281: end if;
282:
283: if substr(lv_error_mesg,91,45) is not null then
284: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
280: pay_core_utils.push_token('description',substr(lv_error_mesg,46,45));
281: end if;
282:
283: if substr(lv_error_mesg,91,45) is not null then
284: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
285: pay_core_utils.push_token('record_name',' ');
286: pay_core_utils.push_token('description',substr(lv_error_mesg,91,45));
287: end if;
288:
281: end if;
282:
283: if substr(lv_error_mesg,91,45) is not null then
284: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
285: pay_core_utils.push_token('record_name',' ');
286: pay_core_utils.push_token('description',substr(lv_error_mesg,91,45));
287: end if;
288:
289: if substr(lv_error_mesg,136,45) is not null then
282:
283: if substr(lv_error_mesg,91,45) is not null then
284: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
285: pay_core_utils.push_token('record_name',' ');
286: pay_core_utils.push_token('description',substr(lv_error_mesg,91,45));
287: end if;
288:
289: if substr(lv_error_mesg,136,45) is not null then
290: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
286: pay_core_utils.push_token('description',substr(lv_error_mesg,91,45));
287: end if;
288:
289: if substr(lv_error_mesg,136,45) is not null then
290: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
291: pay_core_utils.push_token('record_name',' ');
292: pay_core_utils.push_token('description',substr(lv_error_mesg,136,45));
293: end if;
294:
287: end if;
288:
289: if substr(lv_error_mesg,136,45) is not null then
290: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
291: pay_core_utils.push_token('record_name',' ');
292: pay_core_utils.push_token('description',substr(lv_error_mesg,136,45));
293: end if;
294:
295: hr_utility.raise_error;
288:
289: if substr(lv_error_mesg,136,45) is not null then
290: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
291: pay_core_utils.push_token('record_name',' ');
292: pay_core_utils.push_token('description',substr(lv_error_mesg,136,45));
293: end if;
294:
295: hr_utility.raise_error;
296:
558:
559: lv_record_name := 'W2C Report';
560: lv_message := 'No W2c archive actions exist for this employee';
561:
562: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
563: pay_core_utils.push_token('record_name',lv_record_name);
564: pay_core_utils.push_token('name_or_number',lv_full_name);
565: pay_core_utils.push_token('description',lv_message);
566: end if;
559: lv_record_name := 'W2C Report';
560: lv_message := 'No W2c archive actions exist for this employee';
561:
562: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
563: pay_core_utils.push_token('record_name',lv_record_name);
564: pay_core_utils.push_token('name_or_number',lv_full_name);
565: pay_core_utils.push_token('description',lv_message);
566: end if;
567:
560: lv_message := 'No W2c archive actions exist for this employee';
561:
562: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
563: pay_core_utils.push_token('record_name',lv_record_name);
564: pay_core_utils.push_token('name_or_number',lv_full_name);
565: pay_core_utils.push_token('description',lv_message);
566: end if;
567:
568: if get_prev_w2c_dtls%found then
561:
562: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
563: pay_core_utils.push_token('record_name',lv_record_name);
564: pay_core_utils.push_token('name_or_number',lv_full_name);
565: pay_core_utils.push_token('description',lv_message);
566: end if;
567:
568: if get_prev_w2c_dtls%found then
569:
634: lv_record_name := 'W2C Report';
635: lv_message := 'No new w2c archive actions exist '||
636: 'for this employee';
637:
638: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
639: pay_core_utils.push_token('record_name',lv_record_name);
640: pay_core_utils.push_token('name_or_number',lv_full_name);
641: pay_core_utils.push_token('description',lv_message);
642:
635: lv_message := 'No new w2c archive actions exist '||
636: 'for this employee';
637:
638: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
639: pay_core_utils.push_token('record_name',lv_record_name);
640: pay_core_utils.push_token('name_or_number',lv_full_name);
641: pay_core_utils.push_token('description',lv_message);
642:
643: end if; /* report type */
636: 'for this employee';
637:
638: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
639: pay_core_utils.push_token('record_name',lv_record_name);
640: pay_core_utils.push_token('name_or_number',lv_full_name);
641: pay_core_utils.push_token('description',lv_message);
642:
643: end if; /* report type */
644:
637:
638: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
639: pay_core_utils.push_token('record_name',lv_record_name);
640: pay_core_utils.push_token('name_or_number',lv_full_name);
641: pay_core_utils.push_token('description',lv_message);
642:
643: end if; /* report type */
644:
645: end if; /* employee found*/
3132: lv_message := 'W-2c not printed for Employee: '||rtrim(substr(rtrim(ltrim(lv_full_name)),1,60))||
3133: ' (SSN: '||l_w2c_fields_c.ssn
3134: ||') as no corrections found for the employee.';
3135:
3136: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
3137: pay_core_utils.push_token('record_name',lv_record_name);
3138: pay_core_utils.push_token('name_or_number',lv_full_name);
3139: pay_core_utils.push_token('description',lv_message);
3140:
3133: ' (SSN: '||l_w2c_fields_c.ssn
3134: ||') as no corrections found for the employee.';
3135:
3136: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
3137: pay_core_utils.push_token('record_name',lv_record_name);
3138: pay_core_utils.push_token('name_or_number',lv_full_name);
3139: pay_core_utils.push_token('description',lv_message);
3140:
3141: END IF;
3134: ||') as no corrections found for the employee.';
3135:
3136: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
3137: pay_core_utils.push_token('record_name',lv_record_name);
3138: pay_core_utils.push_token('name_or_number',lv_full_name);
3139: pay_core_utils.push_token('description',lv_message);
3140:
3141: END IF;
3142:
3135:
3136: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT','P');
3137: pay_core_utils.push_token('record_name',lv_record_name);
3138: pay_core_utils.push_token('name_or_number',lv_full_name);
3139: pay_core_utils.push_token('description',lv_message);
3140:
3141: END IF;
3142:
3143: ELSE