357: if p_wip_entity_id is not null and p_emp_id is not null then
358: set_message_context(p_wip_entity_id,p_emp_id);
359: end if;
360: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
361: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
362: fnd_message.set_token('EMP', G_EMPLOYEE);
363: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
364: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
365: fnd_message.set_token('EMP', G_EMPLOYEE);
358: set_message_context(p_wip_entity_id,p_emp_id);
359: end if;
360: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
361: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
362: fnd_message.set_token('EMP', G_EMPLOYEE);
363: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
364: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
365: fnd_message.set_token('EMP', G_EMPLOYEE);
366: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
360: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
361: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
362: fnd_message.set_token('EMP', G_EMPLOYEE);
363: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
364: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
365: fnd_message.set_token('EMP', G_EMPLOYEE);
366: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
367: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
368: fnd_message.set_token('EMP', G_EMPLOYEE);
361: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
362: fnd_message.set_token('EMP', G_EMPLOYEE);
363: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
364: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
365: fnd_message.set_token('EMP', G_EMPLOYEE);
366: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
367: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
368: fnd_message.set_token('EMP', G_EMPLOYEE);
369: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
363: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
364: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
365: fnd_message.set_token('EMP', G_EMPLOYEE);
366: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
367: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
368: fnd_message.set_token('EMP', G_EMPLOYEE);
369: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
370: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
371: end if;
364: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
365: fnd_message.set_token('EMP', G_EMPLOYEE);
366: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
367: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
368: fnd_message.set_token('EMP', G_EMPLOYEE);
369: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
370: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
371: end if;
372: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
366: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
367: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
368: fnd_message.set_token('EMP', G_EMPLOYEE);
369: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
370: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
371: end if;
372: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
373: fnd_message.set_token('OP', to_char(l_op_seq_num));
374: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
368: fnd_message.set_token('EMP', G_EMPLOYEE);
369: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
370: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
371: end if;
372: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
373: fnd_message.set_token('OP', to_char(l_op_seq_num));
374: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
375: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
376: end if;
369: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
370: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
371: end if;
372: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
373: fnd_message.set_token('OP', to_char(l_op_seq_num));
374: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
375: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
376: end if;
377: l_err_msg := fnd_message.get;
371: end if;
372: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
373: fnd_message.set_token('OP', to_char(l_op_seq_num));
374: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
375: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
376: end if;
377: l_err_msg := fnd_message.get;
378: end if;
379: if G_PREF_MOVE_VALUE = G_ENABLE_MOVE_VALIDATION then
373: fnd_message.set_token('OP', to_char(l_op_seq_num));
374: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
375: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
376: end if;
377: l_err_msg := fnd_message.get;
378: end if;
379: if G_PREF_MOVE_VALUE = G_ENABLE_MOVE_VALIDATION then
380: fnd_message.set_name('WIP','WIP_YES');
381: l_move_pref := fnd_message.get;
376: end if;
377: l_err_msg := fnd_message.get;
378: end if;
379: if G_PREF_MOVE_VALUE = G_ENABLE_MOVE_VALIDATION then
380: fnd_message.set_name('WIP','WIP_YES');
381: l_move_pref := fnd_message.get;
382: else
383: fnd_message.set_name('WIP','WIP_NO');
384: l_move_pref := fnd_message.get;
377: l_err_msg := fnd_message.get;
378: end if;
379: if G_PREF_MOVE_VALUE = G_ENABLE_MOVE_VALIDATION then
380: fnd_message.set_name('WIP','WIP_YES');
381: l_move_pref := fnd_message.get;
382: else
383: fnd_message.set_name('WIP','WIP_NO');
384: l_move_pref := fnd_message.get;
385: end if;
379: if G_PREF_MOVE_VALUE = G_ENABLE_MOVE_VALIDATION then
380: fnd_message.set_name('WIP','WIP_YES');
381: l_move_pref := fnd_message.get;
382: else
383: fnd_message.set_name('WIP','WIP_NO');
384: l_move_pref := fnd_message.get;
385: end if;
386: if G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
387: fnd_message.set_name('WIP','WIP_YES');
380: fnd_message.set_name('WIP','WIP_YES');
381: l_move_pref := fnd_message.get;
382: else
383: fnd_message.set_name('WIP','WIP_NO');
384: l_move_pref := fnd_message.get;
385: end if;
386: if G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
387: fnd_message.set_name('WIP','WIP_YES');
388: l_certify_pref := fnd_message.get;
383: fnd_message.set_name('WIP','WIP_NO');
384: l_move_pref := fnd_message.get;
385: end if;
386: if G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
387: fnd_message.set_name('WIP','WIP_YES');
388: l_certify_pref := fnd_message.get;
389: else
390: fnd_message.set_name('WIP','WIP_NO');
391: l_certify_pref := fnd_message.get;
384: l_move_pref := fnd_message.get;
385: end if;
386: if G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
387: fnd_message.set_name('WIP','WIP_YES');
388: l_certify_pref := fnd_message.get;
389: else
390: fnd_message.set_name('WIP','WIP_NO');
391: l_certify_pref := fnd_message.get;
392: end if;
386: if G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
387: fnd_message.set_name('WIP','WIP_YES');
388: l_certify_pref := fnd_message.get;
389: else
390: fnd_message.set_name('WIP','WIP_NO');
391: l_certify_pref := fnd_message.get;
392: end if;
393: exception
394: when others then
387: fnd_message.set_name('WIP','WIP_YES');
388: l_certify_pref := fnd_message.get;
389: else
390: fnd_message.set_name('WIP','WIP_NO');
391: l_certify_pref := fnd_message.get;
392: end if;
393: exception
394: when others then
395: l_validate_skill := G_SKILL_VALIDATION_EXCEPTION;
420: if p_wip_entity_id is not null and p_emp_id is not null then
421: set_message_context(p_wip_entity_id,p_emp_id);
422: end if;
423: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
424: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
425: fnd_message.set_token('EMP', G_EMPLOYEE);
426: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
427: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
428: fnd_message.set_token('EMP', G_EMPLOYEE);
421: set_message_context(p_wip_entity_id,p_emp_id);
422: end if;
423: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
424: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
425: fnd_message.set_token('EMP', G_EMPLOYEE);
426: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
427: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
428: fnd_message.set_token('EMP', G_EMPLOYEE);
429: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
423: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
424: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
425: fnd_message.set_token('EMP', G_EMPLOYEE);
426: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
427: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
428: fnd_message.set_token('EMP', G_EMPLOYEE);
429: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
430: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
431: fnd_message.set_token('EMP', G_EMPLOYEE);
424: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
425: fnd_message.set_token('EMP', G_EMPLOYEE);
426: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
427: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
428: fnd_message.set_token('EMP', G_EMPLOYEE);
429: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
430: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
431: fnd_message.set_token('EMP', G_EMPLOYEE);
432: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
426: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
427: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
428: fnd_message.set_token('EMP', G_EMPLOYEE);
429: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
430: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
431: fnd_message.set_token('EMP', G_EMPLOYEE);
432: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
433: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
434: end if;
427: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
428: fnd_message.set_token('EMP', G_EMPLOYEE);
429: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
430: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
431: fnd_message.set_token('EMP', G_EMPLOYEE);
432: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
433: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
434: end if;
435: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
429: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
430: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
431: fnd_message.set_token('EMP', G_EMPLOYEE);
432: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
433: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
434: end if;
435: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
436: fnd_message.set_token('OP', to_char(p_op_seq_num));
437: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
431: fnd_message.set_token('EMP', G_EMPLOYEE);
432: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
433: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
434: end if;
435: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
436: fnd_message.set_token('OP', to_char(p_op_seq_num));
437: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
438: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
439: end if;
432: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
433: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
434: end if;
435: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
436: fnd_message.set_token('OP', to_char(p_op_seq_num));
437: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
438: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
439: end if;
440: l_err_msg := fnd_message.get;
434: end if;
435: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
436: fnd_message.set_token('OP', to_char(p_op_seq_num));
437: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
438: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
439: end if;
440: l_err_msg := fnd_message.get;
441: end if;
442: exception
436: fnd_message.set_token('OP', to_char(p_op_seq_num));
437: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
438: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
439: end if;
440: l_err_msg := fnd_message.get;
441: end if;
442: exception
443: when others then
444: l_validate_skill := G_SKILL_VALIDATION_EXCEPTION;