DBA Data[Home] [Help]

APPS.GMD_STATUS_PUB dependencies on FND_MSG_PUB

Line 51: FND_MSG_PUB.ADD;

47: END LOOP;
48: IF (x_o_res_act_cnt > 0) THEN
49: FND_MESSAGE.SET_NAME('GMD','GMD_ATTACH_RESOURCES');
50: FND_MESSAGE.SET_TOKEN('ACTIVITY',x_activity);
51: FND_MSG_PUB.ADD;
52: x_return_status := FND_API.G_RET_STS_ERROR;
53: END IF;
54: END validate_operation;
55:

Line 317: fnd_msg_pub.initialize;

313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314:
315: /* Initialize message list and count if needed */
316: IF p_init_msg_list THEN
317: fnd_msg_pub.initialize;
318: END IF;
319:
320: /* Initialize the setup fields */
321: IF NOT gmd_api_grp.setup_done THEN

Line 343: FND_MSG_PUB.ADD;

339: FETCH get_To_status_details INTO l_to_status_type, l_to_status_desc;
340: IF get_To_status_details%NOTFOUND THEN
341: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
342: FND_MESSAGE.SET_TOKEN ('MISSING', FND_MESSAGE.GET);
343: FND_MSG_PUB.ADD;
344: x_return_status := FND_API.g_ret_sts_error;
345: CLOSE get_To_status_details;
346: RAISE status_update_failure;
347: END IF;

Line 365: FND_MSG_PUB.ADD;

361: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
362: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
363: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
364: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
365: FND_MSG_PUB.ADD;
366: x_return_status := FND_API.g_ret_sts_error;
367: CLOSE get_curr_recipe_status;
368: RAISE status_update_failure;
369: END IF;

Line 384: FND_MSG_PUB.ADD;

380: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
381: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
382: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
383: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
384: FND_MSG_PUB.ADD;
385: x_return_status := FND_API.g_ret_sts_error;
386: CLOSE get_curr_formula_status;
387: RAISE status_update_failure;
388: END IF;

Line 409: FND_MSG_PUB.ADD;

405: END IF;
406:
407: IF (l_toq = 0) THEN
408: FND_MESSAGE.SET_NAME('GMD','GMD_TOTAL_OUTPUT_ZERO');
409: FND_MSG_PUB.ADD;
410: x_return_status := FND_API.g_ret_sts_error;
411: RAISE status_update_failure;
412: END IF;
413:

Line 422: FND_MSG_PUB.ADD;

418: FETCH Cur_experimental_items INTO l_expr_items_found;
419: CLOSE Cur_experimental_items;
420: IF l_expr_items_found > 0 THEN
421: FND_MESSAGE.SET_NAME('GMD', 'GMD_EXPR_ITEMS_FOUND');
422: FND_MSG_PUB.ADD;
423: x_return_status := FND_API.g_ret_sts_error;
424: RAISE status_update_failure;
425: END IF;
426: END IF;

Line 443: FND_MSG_PUB.ADD;

439: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
440: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
441: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
442: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
443: FND_MSG_PUB.ADD;
444: x_return_status := FND_API.g_ret_sts_error;
445: CLOSE get_curr_routing_status;
446: RAISE status_update_failure;
447: END IF;

Line 462: FND_MSG_PUB.ADD;

458: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
459: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
460: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
461: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
462: FND_MSG_PUB.ADD;
463: x_return_status := FND_API.g_ret_sts_error;
464: CLOSE get_curr_operation_status;
465: RAISE status_update_failure;
466: END IF;

Line 492: FND_MSG_PUB.ADD;

488: FETCH get_curr_vr_status INTO l_entity_id, l_from_status, l_recipe_use;
489: IF get_curr_vr_status%NOTFOUND THEN
490: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
491: FND_MESSAGE.SET_TOKEN ('MISSING','P_ENTITY_ID');
492: FND_MSG_PUB.ADD;
493: x_return_status := FND_API.g_ret_sts_error;
494: CLOSE get_curr_vr_status;
495: RAISE status_update_failure;
496: END IF;

Line 517: FND_MSG_PUB.GET (p_msg_index => 1,

513: p_organization_id => l_org_id,
514: p_production_check => TRUE);
515:
516: IF l_return_status <> FND_API.g_ret_sts_success THEN
517: FND_MSG_PUB.GET (p_msg_index => 1,
518: p_data => l_mesg_data,
519: p_encoded => 'F',
520: p_msg_index_out => l_mesg_count);
521: --FND_MSG_PUB.ADD;

Line 521: --FND_MSG_PUB.ADD;

517: FND_MSG_PUB.GET (p_msg_index => 1,
518: p_data => l_mesg_data,
519: p_encoded => 'F',
520: p_msg_index_out => l_mesg_count);
521: --FND_MSG_PUB.ADD;
522: x_return_status := FND_API.g_ret_sts_error;
523: RAISE status_update_failure;
524: END IF;
525: ELSIF l_recipe_use = 2 THEN

Line 532: FND_MSG_PUB.GET (p_msg_index => 1,

528: p_organization_id => l_org_id,
529: p_costing_check => TRUE);
530:
531: IF l_return_status <> FND_API.g_ret_sts_success THEN
532: FND_MSG_PUB.GET (p_msg_index => 1,
533: p_data => l_mesg_data,
534: p_encoded => 'F',
535: p_msg_index_out => l_mesg_count);
536: --FND_MSG_PUB.ADD;

Line 536: --FND_MSG_PUB.ADD;

532: FND_MSG_PUB.GET (p_msg_index => 1,
533: p_data => l_mesg_data,
534: p_encoded => 'F',
535: p_msg_index_out => l_mesg_count);
536: --FND_MSG_PUB.ADD;
537: x_return_status := FND_API.g_ret_sts_error;
538: RAISE status_update_failure;
539: END IF;
540: END IF;

Line 562: FND_MSG_PUB.ADD;

558: FND_MESSAGE.SET_TOKEN ('MISSING', l_entity_name);
559: FND_MESSAGE.SET_TOKEN ('ID',P_entity_id);
560: FND_MESSAGE.SET_TOKEN ('NO',P_entity_no);
561: FND_MESSAGE.SET_TOKEN ('VERS',P_entity_version);
562: FND_MSG_PUB.ADD;
563: x_return_status := FND_API.g_ret_sts_error;
564: CLOSE get_curr_subst_status;
565: RAISE status_update_failure;
566: END IF;

Line 571: FND_MSG_PUB.ADD;

567: CLOSE get_curr_subst_status;
568: ELSE -- not able to recognize the entity name
569: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNKNOWN_ENTITY');
570: FND_MESSAGE.SET_TOKEN('ENTITY_NAME', P_entity_name);
571: FND_MSG_PUB.ADD;
572: x_return_status := FND_API.g_ret_sts_error;
573: RAISE status_update_failure;
574: END IF;
575:

Line 600: FND_MSG_PUB.ADD;

596: FETCH validate_To_status INTO l_from_status_type, l_from_status_desc, l_target_status;
597: IF validate_To_status%NOTFOUND THEN
598: FND_MESSAGE.SET_NAME ('GMD', 'GMD_INV_TARGET_STATUS');
599: FND_MESSAGE.SET_TOKEN ('TO_STATUS', l_to_status_desc);
600: FND_MSG_PUB.ADD;
601: x_return_status := FND_API.g_ret_sts_error;
602: CLOSE validate_To_status;
603: RAISE status_update_failure;
604: END IF;

Line 609: FND_MSG_PUB.ADD;

605: CLOSE validate_To_status;
606: ELSE
607: FND_MESSAGE.SET_NAME ('GMD', 'GMD_STS_SAME');
608: FND_MESSAGE.SET_TOKEN ('NAME', P_entity_name);
609: FND_MSG_PUB.ADD;
610: RETURN;
611: END IF;
612:
613: IF (l_debug = 'Y') THEN

Line 638: FND_MSG_PUB.ADD;

634: FROM sys.dual;
635:
636: IF l_entity_name IN ('FORMULA','OPERATION','ROUTING') THEN
637: FND_MESSAGE.SET_NAME('GMD',l_mesg_text);
638: FND_MSG_PUB.ADD;
639: x_return_status := FND_API.g_ret_sts_error;
640: RAISE status_update_failure;
641: ELSIF l_entity_name IN ('RECIPE','VALIDITY') THEN
642: IF NOT P_ignore_flag THEN

Line 644: FND_MSG_PUB.ADD;

640: RAISE status_update_failure;
641: ELSIF l_entity_name IN ('RECIPE','VALIDITY') THEN
642: IF NOT P_ignore_flag THEN
643: FND_MESSAGE.SET_NAME('GMD',l_mesg_text);
644: FND_MSG_PUB.ADD;
645: x_return_status := FND_API.g_ret_sts_error;
646: RAISE status_update_failure;
647: END IF; -- p_ignore_flag is false
648: END IF; -- entity type check

Line 679: FND_MSG_PUB.ADD;

675: * returns TRUE if entity does not have dependents (formula,
676: * operation) or if to_status does not require the check
677: * (frozen, on-hold, obsolete, some version of New). */
678: FND_MESSAGE.SET_NAME('GMD', 'GMD_STATUS_DEPEND_NOT_APPROVED');
679: FND_MSG_PUB.ADD;
680: x_return_status := FND_API.g_ret_sts_error;
681: RAISE status_update_failure;
682: ELSE
683:

Line 720: FND_MSG_PUB.ADD;

716: IF GMD_ERES_UTILS.check_recipe_validity_eres (p_recipe_id => l_entity_id
717: ,p_to_status => P_to_status) THEN
718: FND_MESSAGE.SET_NAME('GMD', 'GMD_VLDT_APPR_REQD');
719: FND_MESSAGE.SET_TOKEN('STATUS', l_to_status_desc);
720: FND_MSG_PUB.ADD;
721: x_return_status := FND_API.g_ret_sts_error;
722: RAISE status_update_failure;
723: END IF;
724:

Line 752: FND_MSG_PUB.ADD;

748: END IF;
749: ELSE
750: FND_MESSAGE.SET_NAME('GMD', 'GMD_RCP_VR_STATUS');
751: FND_MESSAGE.SET_TOKEN('TO_STATUS',P_to_status);
752: FND_MSG_PUB.ADD;
753: x_return_status := FND_API.g_ret_sts_error;
754: RAISE status_update_failure;
755: END IF; /* if feedback is OK */
756: END IF ; /* if validity rules exists , l_check_vr=1 */

Line 904: fnd_msg_pub.count_and_get (

900:
901: END IF; --IF (l_from_status <> P_to_status)
902: END IF;
903:
904: fnd_msg_pub.count_and_get (
905: p_count => x_message_count
906: ,p_encoded => FND_API.g_false
907: ,p_data => x_message_list);
908:

Line 924: fnd_msg_pub.count_and_get (

920: ROLLBACK TO SAVEPOINT modify_status;
921: IF (l_debug = 'Y') THEN
922: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
923: END IF;
924: fnd_msg_pub.count_and_get (
925: p_count => x_message_count
926: ,p_encoded => FND_API.g_false
927: ,p_data => x_message_list);
928: x_return_status := FND_API.G_RET_STS_ERROR;

Line 932: fnd_msg_pub.count_and_get (

928: x_return_status := FND_API.G_RET_STS_ERROR;
929: WHEN setup_failure THEN
930: ROLLBACK TO SAVEPOINT modify_status;
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: fnd_msg_pub.count_and_get (
933: p_count => x_message_count
934: ,p_encoded => FND_API.g_false
935: ,p_data => x_message_list);
936: WHEN app_exception.record_lock_exception THEN

Line 955: fnd_msg_pub.count_and_get (

951: 'TABLE_NAME',l_table_name,
952: 'KEY',NVL(p_entity_id, l_entity_id)
953: );
954: -- Bug #3437582 (JKB) Changed gmd_api_pub to gmd_api_grp above.
955: fnd_msg_pub.count_and_get (
956: p_count => x_message_count
957: ,p_encoded => FND_API.g_false
958: ,p_data => x_message_list);
959: WHEN OTHERS THEN

Line 961: fnd_msg_pub.add_exc_msg (gmd_status_pub.m_pkg_name, l_api_name);

957: ,p_encoded => FND_API.g_false
958: ,p_data => x_message_list);
959: WHEN OTHERS THEN
960: ROLLBACK TO SAVEPOINT modify_status;
961: fnd_msg_pub.add_exc_msg (gmd_status_pub.m_pkg_name, l_api_name);
962: IF (l_debug = 'Y') THEN
963: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
964: END IF;
965: fnd_msg_pub.count_and_get (

Line 965: fnd_msg_pub.count_and_get (

961: fnd_msg_pub.add_exc_msg (gmd_status_pub.m_pkg_name, l_api_name);
962: IF (l_debug = 'Y') THEN
963: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
964: END IF;
965: fnd_msg_pub.count_and_get (
966: p_count => x_message_count
967: ,p_encoded => FND_API.g_false
968: ,p_data => x_message_list);
969: x_return_status := FND_API.g_ret_sts_unexp_error;