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 313: fnd_msg_pub.initialize;

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

Line 339: FND_MSG_PUB.ADD;

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

Line 361: FND_MSG_PUB.ADD;

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

Line 380: FND_MSG_PUB.ADD;

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

Line 405: FND_MSG_PUB.ADD;

401: END IF;
402:
403: IF (l_toq = 0) THEN
404: FND_MESSAGE.SET_NAME('GMD','GMD_TOTAL_OUTPUT_ZERO');
405: FND_MSG_PUB.ADD;
406: x_return_status := FND_API.g_ret_sts_error;
407: RAISE status_update_failure;
408: END IF;
409:

Line 418: FND_MSG_PUB.ADD;

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

Line 439: FND_MSG_PUB.ADD;

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

Line 458: FND_MSG_PUB.ADD;

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

Line 488: FND_MSG_PUB.ADD;

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

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

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

Line 517: --FND_MSG_PUB.ADD;

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

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

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

Line 532: --FND_MSG_PUB.ADD;

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

Line 558: FND_MSG_PUB.ADD;

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

Line 567: FND_MSG_PUB.ADD;

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

Line 596: FND_MSG_PUB.ADD;

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

Line 605: FND_MSG_PUB.ADD;

601: CLOSE validate_To_status;
602: ELSE
603: FND_MESSAGE.SET_NAME ('GMD', 'GMD_STS_SAME');
604: FND_MESSAGE.SET_TOKEN ('NAME', P_entity_name);
605: FND_MSG_PUB.ADD;
606: RETURN;
607: END IF;
608:
609: IF (l_debug = 'Y') THEN

Line 634: FND_MSG_PUB.ADD;

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

Line 640: FND_MSG_PUB.ADD;

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

Line 675: FND_MSG_PUB.ADD;

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

Line 716: FND_MSG_PUB.ADD;

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

Line 748: FND_MSG_PUB.ADD;

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

Line 898: fnd_msg_pub.count_and_get (

894:
895: END IF; --IF (l_from_status <> P_to_status)
896: END IF;
897:
898: fnd_msg_pub.count_and_get (
899: p_count => x_message_count
900: ,p_encoded => FND_API.g_false
901: ,p_data => x_message_list);
902:

Line 918: fnd_msg_pub.count_and_get (

914: ROLLBACK TO SAVEPOINT modify_status;
915: IF (l_debug = 'Y') THEN
916: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
917: END IF;
918: fnd_msg_pub.count_and_get (
919: p_count => x_message_count
920: ,p_encoded => FND_API.g_false
921: ,p_data => x_message_list);
922: x_return_status := FND_API.G_RET_STS_ERROR;

Line 926: fnd_msg_pub.count_and_get (

922: x_return_status := FND_API.G_RET_STS_ERROR;
923: WHEN setup_failure THEN
924: ROLLBACK TO SAVEPOINT modify_status;
925: x_return_status := FND_API.G_RET_STS_ERROR;
926: fnd_msg_pub.count_and_get (
927: p_count => x_message_count
928: ,p_encoded => FND_API.g_false
929: ,p_data => x_message_list);
930: WHEN app_exception.record_lock_exception THEN

Line 949: fnd_msg_pub.count_and_get (

945: 'TABLE_NAME',l_table_name,
946: 'KEY',NVL(p_entity_id, l_entity_id)
947: );
948: -- Bug #3437582 (JKB) Changed gmd_api_pub to gmd_api_grp above.
949: fnd_msg_pub.count_and_get (
950: p_count => x_message_count
951: ,p_encoded => FND_API.g_false
952: ,p_data => x_message_list);
953: WHEN OTHERS THEN

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

951: ,p_encoded => FND_API.g_false
952: ,p_data => x_message_list);
953: WHEN OTHERS THEN
954: ROLLBACK TO SAVEPOINT modify_status;
955: fnd_msg_pub.add_exc_msg (gmd_status_pub.m_pkg_name, l_api_name);
956: IF (l_debug = 'Y') THEN
957: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
958: END IF;
959: fnd_msg_pub.count_and_get (

Line 959: fnd_msg_pub.count_and_get (

955: fnd_msg_pub.add_exc_msg (gmd_status_pub.m_pkg_name, l_api_name);
956: IF (l_debug = 'Y') THEN
957: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
958: END IF;
959: fnd_msg_pub.count_and_get (
960: p_count => x_message_count
961: ,p_encoded => FND_API.g_false
962: ,p_data => x_message_list);
963: x_return_status := FND_API.g_ret_sts_unexp_error;