DBA Data[Home] [Help]

APPS.WIP_WS_SKILL_CHECK_PVT dependencies on FND_MESSAGE

Line 361: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');

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);

Line 362: 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

Line 364: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');

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);

Line 365: 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

Line 367: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');

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;

Line 368: fnd_message.set_token('EMP', G_EMPLOYEE);

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);

Line 370: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');

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

Line 372: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);

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;

Line 373: fnd_message.set_token('OP', to_char(l_op_seq_num));

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;

Line 375: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');

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

Line 377: l_err_msg := fnd_message.get;

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;

Line 380: fnd_message.set_name('WIP','WIP_YES');

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;

Line 381: 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;

Line 383: fnd_message.set_name('WIP','WIP_NO');

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');

Line 384: l_move_pref := fnd_message.get;

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;

Line 387: fnd_message.set_name('WIP','WIP_YES');

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;

Line 388: 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;

Line 390: fnd_message.set_name('WIP','WIP_NO');

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

Line 391: l_certify_pref := fnd_message.get;

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;

Line 424: fnd_message.set_name('WIP','WIP_COMPETENCE_CHECK_FAIL');

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);

Line 425: 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

Line 427: fnd_message.set_name('WIP','WIP_CERTIFY_CHECK_FAIL');

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);

Line 428: 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

Line 430: fnd_message.set_name('WIP','WIP_QUALIFY_CHECK_FAIL');

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;

Line 431: fnd_message.set_token('EMP', G_EMPLOYEE);

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);

Line 433: fnd_message.set_name('WIP','WIP_NO_SKILL_EMP_CLOCKIN');

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

Line 435: fnd_message.set_token('JOB', G_WIP_ENTITY_NAME);

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;

Line 436: fnd_message.set_token('OP', to_char(p_op_seq_num));

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;

Line 438: fnd_message.set_name('WIP','WIP_SKILL_CHECK_EMP_NULL');

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

Line 440: l_err_msg := fnd_message.get;

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;