340: if p_wip_entity_id is not null and p_emp_id is not null then
341: set_message_context(p_wip_entity_id,p_emp_id);
342: end if;
343: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
344: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
345: fnd_message.set_token('EMP', G_EMPLOYEE);
346: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
347: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
348: fnd_message.set_token('EMP', G_EMPLOYEE);
341: set_message_context(p_wip_entity_id,p_emp_id);
342: end if;
343: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
344: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
345: fnd_message.set_token('EMP', G_EMPLOYEE);
346: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
347: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
348: fnd_message.set_token('EMP', G_EMPLOYEE);
349: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
343: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
344: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
345: fnd_message.set_token('EMP', G_EMPLOYEE);
346: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
347: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
348: fnd_message.set_token('EMP', G_EMPLOYEE);
349: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
350: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
351: fnd_message.set_token('EMP', G_EMPLOYEE);
344: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
345: fnd_message.set_token('EMP', G_EMPLOYEE);
346: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
347: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
348: fnd_message.set_token('EMP', G_EMPLOYEE);
349: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
350: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
351: fnd_message.set_token('EMP', G_EMPLOYEE);
352: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
346: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
347: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
348: fnd_message.set_token('EMP', G_EMPLOYEE);
349: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
350: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
351: fnd_message.set_token('EMP', G_EMPLOYEE);
352: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
353: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
354: end if;
347: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
348: fnd_message.set_token('EMP', G_EMPLOYEE);
349: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
350: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
351: fnd_message.set_token('EMP', G_EMPLOYEE);
352: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
353: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
354: end if;
355: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
349: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
350: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
351: fnd_message.set_token('EMP', G_EMPLOYEE);
352: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
353: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
354: end if;
355: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
356: fnd_message.set_token('OP', to_char(l_op_seq_num));
357: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
351: fnd_message.set_token('EMP', G_EMPLOYEE);
352: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
353: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
354: end if;
355: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
356: fnd_message.set_token('OP', to_char(l_op_seq_num));
357: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
358: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
359: end if;
352: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
353: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
354: end if;
355: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
356: fnd_message.set_token('OP', to_char(l_op_seq_num));
357: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
358: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
359: end if;
360: l_err_msg := fnd_message.get;
354: end if;
355: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
356: fnd_message.set_token('OP', to_char(l_op_seq_num));
357: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
358: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
359: end if;
360: l_err_msg := fnd_message.get;
361: end if;
362: if G_PREF_MOVE_VALUE = G_ENABLE_MOVE_VALIDATION then
356: fnd_message.set_token('OP', to_char(l_op_seq_num));
357: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
358: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
359: end if;
360: l_err_msg := fnd_message.get;
361: end if;
362: if G_PREF_MOVE_VALUE = G_ENABLE_MOVE_VALIDATION then
363: fnd_message.set_name('WIP','WIP_YES');
364: l_move_pref := fnd_message.get;
359: end if;
360: l_err_msg := fnd_message.get;
361: end if;
362: if G_PREF_MOVE_VALUE = G_ENABLE_MOVE_VALIDATION then
363: fnd_message.set_name('WIP','WIP_YES');
364: l_move_pref := fnd_message.get;
365: else
366: fnd_message.set_name('WIP','WIP_NO');
367: l_move_pref := fnd_message.get;
360: l_err_msg := fnd_message.get;
361: end if;
362: if G_PREF_MOVE_VALUE = G_ENABLE_MOVE_VALIDATION then
363: fnd_message.set_name('WIP','WIP_YES');
364: l_move_pref := fnd_message.get;
365: else
366: fnd_message.set_name('WIP','WIP_NO');
367: l_move_pref := fnd_message.get;
368: end if;
362: if G_PREF_MOVE_VALUE = G_ENABLE_MOVE_VALIDATION then
363: fnd_message.set_name('WIP','WIP_YES');
364: l_move_pref := fnd_message.get;
365: else
366: fnd_message.set_name('WIP','WIP_NO');
367: l_move_pref := fnd_message.get;
368: end if;
369: if G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
370: fnd_message.set_name('WIP','WIP_YES');
363: fnd_message.set_name('WIP','WIP_YES');
364: l_move_pref := fnd_message.get;
365: else
366: fnd_message.set_name('WIP','WIP_NO');
367: l_move_pref := fnd_message.get;
368: end if;
369: if G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
370: fnd_message.set_name('WIP','WIP_YES');
371: l_certify_pref := fnd_message.get;
366: fnd_message.set_name('WIP','WIP_NO');
367: l_move_pref := fnd_message.get;
368: end if;
369: if G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
370: fnd_message.set_name('WIP','WIP_YES');
371: l_certify_pref := fnd_message.get;
372: else
373: fnd_message.set_name('WIP','WIP_NO');
374: l_certify_pref := fnd_message.get;
367: l_move_pref := fnd_message.get;
368: end if;
369: if G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
370: fnd_message.set_name('WIP','WIP_YES');
371: l_certify_pref := fnd_message.get;
372: else
373: fnd_message.set_name('WIP','WIP_NO');
374: l_certify_pref := fnd_message.get;
375: end if;
369: if G_PREF_CERTIFY_VALUE = G_ENABLE_CERTIFICATION_CHECK then
370: fnd_message.set_name('WIP','WIP_YES');
371: l_certify_pref := fnd_message.get;
372: else
373: fnd_message.set_name('WIP','WIP_NO');
374: l_certify_pref := fnd_message.get;
375: end if;
376: exception
377: when others then
370: fnd_message.set_name('WIP','WIP_YES');
371: l_certify_pref := fnd_message.get;
372: else
373: fnd_message.set_name('WIP','WIP_NO');
374: l_certify_pref := fnd_message.get;
375: end if;
376: exception
377: when others then
378: l_validate_skill := G_SKILL_VALIDATION_EXCEPTION;
403: if p_wip_entity_id is not null and p_emp_id is not null then
404: set_message_context(p_wip_entity_id,p_emp_id);
405: end if;
406: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
407: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
408: fnd_message.set_token('EMP', G_EMPLOYEE);
409: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
410: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
411: fnd_message.set_token('EMP', G_EMPLOYEE);
404: set_message_context(p_wip_entity_id,p_emp_id);
405: end if;
406: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
407: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
408: fnd_message.set_token('EMP', G_EMPLOYEE);
409: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
410: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
411: fnd_message.set_token('EMP', G_EMPLOYEE);
412: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
406: if l_validate_skill = G_COMPETENCE_CHECK_FAIL then
407: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
408: fnd_message.set_token('EMP', G_EMPLOYEE);
409: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
410: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
411: fnd_message.set_token('EMP', G_EMPLOYEE);
412: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
413: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
414: fnd_message.set_token('EMP', G_EMPLOYEE);
407: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');
408: fnd_message.set_token('EMP', G_EMPLOYEE);
409: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
410: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
411: fnd_message.set_token('EMP', G_EMPLOYEE);
412: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
413: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
414: fnd_message.set_token('EMP', G_EMPLOYEE);
415: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
409: elsif l_validate_skill = G_CERTIFY_CHECK_FAIL then
410: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
411: fnd_message.set_token('EMP', G_EMPLOYEE);
412: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
413: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
414: fnd_message.set_token('EMP', G_EMPLOYEE);
415: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
416: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
417: end if;
410: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');
411: fnd_message.set_token('EMP', G_EMPLOYEE);
412: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
413: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
414: fnd_message.set_token('EMP', G_EMPLOYEE);
415: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
416: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
417: end if;
418: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
412: elsif l_validate_skill = G_QUALIFY_CHECK_FAIL then
413: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');
414: fnd_message.set_token('EMP', G_EMPLOYEE);
415: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
416: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
417: end if;
418: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
419: fnd_message.set_token('OP', to_char(p_op_seq_num));
420: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
414: fnd_message.set_token('EMP', G_EMPLOYEE);
415: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
416: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
417: end if;
418: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
419: fnd_message.set_token('OP', to_char(p_op_seq_num));
420: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
421: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
422: end if;
415: elsif l_validate_skill = G_NO_SKILL_EMP_CLOCKIN then
416: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');
417: end if;
418: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
419: fnd_message.set_token('OP', to_char(p_op_seq_num));
420: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
421: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
422: end if;
423: l_err_msg := fnd_message.get;
417: end if;
418: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);
419: fnd_message.set_token('OP', to_char(p_op_seq_num));
420: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
421: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
422: end if;
423: l_err_msg := fnd_message.get;
424: end if;
425: exception
419: fnd_message.set_token('OP', to_char(p_op_seq_num));
420: if l_validate_skill = G_INV_SKILL_CHECK_EMP then
421: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');
422: end if;
423: l_err_msg := fnd_message.get;
424: end if;
425: exception
426: when others then
427: l_validate_skill := G_SKILL_VALIDATION_EXCEPTION;