eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_STATUS_PUB dependencies on FND_API

Line 43: x_return_status := FND_API.G_RET_STS_SUCCESS;

39: x_temp_rec Cur_get_activities%ROWTYPE;
40: x_activity LONG;
41: x_o_res_act_cnt NUMBER := 0;
42: BEGIN
43: x_return_status := FND_API.G_RET_STS_SUCCESS;
44: FOR oprn_rec IN Cur_get_activities(oprn_id) LOOP
45: x_o_res_act_cnt := x_o_res_act_cnt + 1;
46: X_activity := x_activity||oprn_rec.activity||', ';
47: END LOOP;

Line 52: x_return_status := FND_API.G_RET_STS_ERROR;

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:
56: /* =============================================================== */

Line 93: , p_commit IN VARCHAR2 := fnd_api.g_true --added by bug 16052649

89: , p_ignore_flag IN BOOLEAN := FALSE
90: , x_message_count OUT NOCOPY NUMBER
91: , x_message_list OUT NOCOPY VARCHAR2
92: , x_return_status OUT NOCOPY VARCHAR2
93: , p_commit IN VARCHAR2 := fnd_api.g_true --added by bug 16052649
94: ) IS
95:
96: /* Local variable section */
97: l_api_name CONSTANT VARCHAR2(30) := 'MODIFY_STATUS';

Line 313: x_return_status := FND_API.G_RET_STS_SUCCESS;

309: gmd_debug.put_line('Begin of modify_status() ');
310: END IF;
311:
312: /* Set the return status to success initially */
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;

Line 329: IF NOT FND_API.compatible_api_call ( GMD_STATUS_PUB.m_api_version

325: RAISE setup_failure;
326: END IF;
327:
328: /* Make sure we have call compatibility */
329: IF NOT FND_API.compatible_api_call ( GMD_STATUS_PUB.m_api_version
330: ,p_api_version
331: ,l_api_name
332: ,GMD_STATUS_PUB.m_pkg_name) THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: IF NOT FND_API.compatible_api_call ( GMD_STATUS_PUB.m_api_version
330: ,p_api_version
331: ,l_api_name
332: ,GMD_STATUS_PUB.m_pkg_name) THEN
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: RAISE invalid_version;
335: END IF;
336:
337: /* Get the TO status type and description */

Line 344: x_return_status := FND_API.g_ret_sts_error;

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;
348: CLOSE get_To_status_details;

Line 366: x_return_status := FND_API.g_ret_sts_error;

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;
370: CLOSE get_curr_recipe_status;

Line 385: x_return_status := FND_API.g_ret_sts_error;

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;
389: CLOSE get_curr_formula_status;

Line 410: x_return_status := FND_API.g_ret_sts_error;

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:
414: -- Sriram - Bug 5035818

Line 423: x_return_status := FND_API.g_ret_sts_error;

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;
427:

Line 444: x_return_status := FND_API.g_ret_sts_error;

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;
448: CLOSE get_curr_routing_status;

Line 463: x_return_status := FND_API.g_ret_sts_error;

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;
467: CLOSE get_curr_operation_status;

Line 480: IF (x_return_status = FND_API.g_ret_sts_error) THEN

476: IF l_debug = 'Y' THEN
477: gmd_debug.put_line('The return status after calling val operation is '||
478: x_return_status);
479: END IF;
480: IF (x_return_status = FND_API.g_ret_sts_error) THEN
481: RAISE status_update_failure;
482: END IF;
483: END IF;
484: ELSIF (UPPER(P_entity_name) like '%VALIDITY%') THEN

Line 493: x_return_status := FND_API.g_ret_sts_error;

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;
497: CLOSE get_curr_vr_status;

Line 516: IF l_return_status <> FND_API.g_ret_sts_success THEN

512: x_return_status => l_return_status,
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);

Line 522: x_return_status := FND_API.g_ret_sts_error;

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
526: GMD_API_GRP.check_item_exists( p_formula_id => l_form_id,

Line 531: IF l_return_status <> FND_API.g_ret_sts_success THEN

527: x_return_status => l_return_status,
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);

Line 537: x_return_status := FND_API.g_ret_sts_error;

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;
541:

Line 563: x_return_status := FND_API.g_ret_sts_error;

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;
567: CLOSE get_curr_subst_status;

Line 572: x_return_status := FND_API.g_ret_sts_error;

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:
576: IF (l_debug = 'Y') THEN

Line 601: x_return_status := FND_API.g_ret_sts_error;

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;
605: CLOSE validate_To_status;

Line 639: x_return_status := FND_API.g_ret_sts_error;

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
643: FND_MESSAGE.SET_NAME('GMD',l_mesg_text);

Line 645: x_return_status := FND_API.g_ret_sts_error;

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
649: END IF; -- Checking parent status

Line 680: x_return_status := FND_API.g_ret_sts_error;

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:
684: IF (l_debug = 'Y') THEN

Line 721: x_return_status := FND_API.g_ret_sts_error;

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:
725: /* Check if the VR for this recipe needs to be updated */

Line 753: x_return_status := FND_API.g_ret_sts_error;

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 */
757: END IF; /* IF (l_entity_name = 'RECIPE') */

Line 760: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

756: END IF ; /* if validity rules exists , l_check_vr=1 */
757: END IF; /* IF (l_entity_name = 'RECIPE') */
758: END IF; /* Check Dependent Status */
759:
760: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
761: IF (l_from_status <> P_to_status) THEN
762: IF (l_debug = 'Y') THEN
763: gmd_debug.put_line('About to get the pending and rework status ');
764: END IF;

Line 881: IF p_commit = fnd_api.g_true THEN

877:
878: IF (l_eSignature_status IN ('S','P') ) THEN
879: x_return_status := l_eSignature_status;
880: --Added by bug 16052649 to check p_commit, commit changes when it is true
881: IF p_commit = fnd_api.g_true THEN
882: -- Commit your changes
883: Commit;
884: END IF;
885: IF (x_return_status = 'P') THEN

Line 897: x_return_status := FND_API.G_RET_STS_ERROR;

893: fnd_message.set_token('PENDING_STATUS',get_status_meaning(l_pending_status) );
894: END IF;
895:
896: ELSE
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: RAISE status_update_failure;
899: END IF;
900:
901: END IF; --IF (l_from_status <> P_to_status)

Line 906: ,p_encoded => FND_API.g_false

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:
909: IF (l_debug = 'Y') THEN
910: gmd_debug.put_line('Status was updated successfullly');

Line 926: ,p_encoded => FND_API.g_false

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;
929: WHEN setup_failure THEN
930: ROLLBACK TO SAVEPOINT modify_status;

Line 928: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 931: x_return_status := FND_API.G_RET_STS_ERROR;

927: ,p_data => x_message_list);
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);

Line 934: ,p_encoded => FND_API.g_false

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
937: ROLLBACK TO SAVEPOINT modify_status;
938: x_return_status := FND_API.G_RET_STS_ERROR;

Line 938: x_return_status := FND_API.G_RET_STS_ERROR;

934: ,p_encoded => FND_API.g_false
935: ,p_data => x_message_list);
936: WHEN app_exception.record_lock_exception THEN
937: ROLLBACK TO SAVEPOINT modify_status;
938: x_return_status := FND_API.G_RET_STS_ERROR;
939:
940: IF (l_debug = 'Y') THEN
941: gmd_debug.put_line ('In locked exception section ');
942: END IF;

Line 957: ,p_encoded => FND_API.g_false

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
960: ROLLBACK TO SAVEPOINT modify_status;
961: fnd_msg_pub.add_exc_msg (gmd_status_pub.m_pkg_name, l_api_name);

Line 967: ,p_encoded => FND_API.g_false

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;
970: END Modify_status;
971:

Line 969: x_return_status := FND_API.g_ret_sts_unexp_error;

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;
970: END Modify_status;
971:
972: END GMD_STATUS_PUB;