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_ROUTINGS_PUB dependencies on FND_API

Line 57: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

53: /* Local variable section */
54: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_ROUTING';
55: l_row_id ROWID;
56: k NUMBER := 1;
57: l_return_from_routing_step_dep VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
58: l_routing_id NUMBER;
59: l_owner_id NUMBER;
60: l_oprn_no gmd_operations.oprn_no%TYPE;
61: l_oprn_vers gmd_operations.oprn_vers%TYPE;

Line 62: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

58: l_routing_id NUMBER;
59: l_owner_id NUMBER;
60: l_oprn_no gmd_operations.oprn_no%TYPE;
61: l_oprn_vers gmd_operations.oprn_vers%TYPE;
62: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
63: l_return_from_routing_hdr VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
64: l_return_from_routing_step VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
65: l_routing_qty gmd_routings.routing_qty%TYPE := 0;
66: l_process_loss gmd_routings.process_loss%TYPE := 0;

Line 63: l_return_from_routing_hdr VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

59: l_owner_id NUMBER;
60: l_oprn_no gmd_operations.oprn_no%TYPE;
61: l_oprn_vers gmd_operations.oprn_vers%TYPE;
62: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
63: l_return_from_routing_hdr VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
64: l_return_from_routing_step VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
65: l_routing_qty gmd_routings.routing_qty%TYPE := 0;
66: l_process_loss gmd_routings.process_loss%TYPE := 0;
67: l_routing_class_um fm_rout_cls.uom%TYPE;

Line 64: l_return_from_routing_step VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

60: l_oprn_no gmd_operations.oprn_no%TYPE;
61: l_oprn_vers gmd_operations.oprn_vers%TYPE;
62: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
63: l_return_from_routing_hdr VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
64: l_return_from_routing_step VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
65: l_routing_qty gmd_routings.routing_qty%TYPE := 0;
66: l_process_loss gmd_routings.process_loss%TYPE := 0;
67: l_routing_class_um fm_rout_cls.uom%TYPE;
68: l_stepdep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;

Line 129: x_return_status := FND_API.G_RET_STS_SUCCESS;

125: BEGIN
126: SAVEPOINT create_routing;
127:
128: /* Set the return status to success initially */
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130: l_routings_rec := p_routings;
131:
132: /* B5609637 Initialize the routing qty and the process loss with the passed values */
133: l_process_loss := p_routings.process_loss;

Line 157: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version

153: RAISE setup_failure;
154: END IF;
155:
156: /* Make sure we are call compatible */
157: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
158: ,p_api_version
159: ,'INSERT_ROUTING'
160: ,gmd_routings_PUB.m_pkg_name) THEN
161: RAISE invalid_version;

Line 377: x_return_status := FND_API.G_RET_STS_ERROR;

373:
374: ELSE
375: FND_MESSAGE.SET_NAME('GMD', 'GMD_RTG_CLS_VS_RTG_UM_TYPE');
376: FND_MSG_PUB.Add;
377: x_return_status := FND_API.G_RET_STS_ERROR;
378: Raise routing_creation_failure;
379:
380: END IF; /* IF l_routing_um_class = l_routing_class_um_class */
381:

Line 418: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

414: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
415: ||'Insert the routing steps for routing with routing id = '||l_routing_id);
416: END IF;
417:
418: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
419: Raise routing_creation_failure;
420: END IF;
421:
422: /* Looping each routing step detail row */

Line 437: IF l_return_from_routing_step <> FND_API.G_RET_STS_SUCCESS THEN

433: ,x_message_list => x_message_list
434: ,x_return_status => l_return_from_routing_step
435: );
436: -- Check if routing detail was created
437: IF l_return_from_routing_step <> FND_API.G_RET_STS_SUCCESS THEN
438: RAISE routing_step_creation_failure;
439: END IF;
440: END LOOP; /* End loop for p_routings_step_tbl */
441:

Line 499: IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS THEN

495: ,x_return_status => l_return_from_routing_step_dep
496: );
497:
498: /* Check if insert of step dependency was done */
499: IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS THEN
500: RAISE routing_step_dep_failure;
501: END IF; /* IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS */
502: END IF; /* when l_step_dep_tab.count > 0 */
503: END LOOP;

Line 501: END IF; /* IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS */

497:
498: /* Check if insert of step dependency was done */
499: IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS THEN
500: RAISE routing_step_dep_failure;
501: END IF; /* IF l_return_from_routing_step_dep <> FND_API.G_RET_STS_SUCCESS */
502: END IF; /* when l_step_dep_tab.count > 0 */
503: END LOOP;
504: END IF; /* if p_routings_step_dep_tbl.count > 0 */
505: ELSE

Line 514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

510: RAISE routing_creation_failure;
511: END IF;
512:
513: /* Check if work was done */
514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
515: RAISE routing_creation_failure;
516: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
517:
518: IF (P_commit) THEN

Line 516: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */

512:
513: /* Check if work was done */
514: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
515: RAISE routing_creation_failure;
516: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
517:
518: IF (P_commit) THEN
519: COMMIT;
520: --kkillams,bug 3408799

Line 539: IF x_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN

535: , p_ignore_flag => FALSE
536: , x_message_count => x_message_count
537: , x_message_list => x_message_list
538: , x_return_status => X_return_status);
539: IF x_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
540: RAISE default_status_err;
541: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
542: END IF; --l_entity_status <> 100
543: COMMIT;

Line 541: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')

537: , x_message_list => x_message_list
538: , x_return_status => X_return_status);
539: IF x_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
540: RAISE default_status_err;
541: END IF; --x_return_status NOT IN (FND_API.g_ret_sts_success,'P')
542: END IF; --l_entity_status <> 100
543: COMMIT;
544: END IF; --P_commit
545:

Line 548: ,p_encoded => FND_API.g_false

544: END IF; --P_commit
545:
546: fnd_msg_pub.count_and_get (
547: p_count => x_message_count
548: ,p_encoded => FND_API.g_false
549: ,p_data => x_message_list);
550:
551: IF x_message_count = 0 THEN
552: IF (l_debug = 'Y') THEN

Line 570: ,p_encoded => FND_API.g_false

566: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
567: END IF;
568: fnd_msg_pub.count_and_get (
569: p_count => x_message_count
570: ,p_encoded => FND_API.g_false
571: ,p_data => x_message_list);
572: x_return_status := FND_API.G_RET_STS_ERROR;
573: ROLLBACK TO SAVEPOINT create_routing;
574: WHEN setup_failure THEN

Line 572: x_return_status := FND_API.G_RET_STS_ERROR;

568: fnd_msg_pub.count_and_get (
569: p_count => x_message_count
570: ,p_encoded => FND_API.g_false
571: ,p_data => x_message_list);
572: x_return_status := FND_API.G_RET_STS_ERROR;
573: ROLLBACK TO SAVEPOINT create_routing;
574: WHEN setup_failure THEN
575: ROLLBACK TO SAVEPOINT create_routing;
576: x_return_status := FND_API.G_RET_STS_ERROR;

Line 576: x_return_status := FND_API.G_RET_STS_ERROR;

572: x_return_status := FND_API.G_RET_STS_ERROR;
573: ROLLBACK TO SAVEPOINT create_routing;
574: WHEN setup_failure THEN
575: ROLLBACK TO SAVEPOINT create_routing;
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: fnd_msg_pub.count_and_get (
578: p_count => x_message_count
579: ,p_encoded => FND_API.g_false
580: ,p_data => x_message_list);

Line 579: ,p_encoded => FND_API.g_false

575: ROLLBACK TO SAVEPOINT create_routing;
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: fnd_msg_pub.count_and_get (
578: p_count => x_message_count
579: ,p_encoded => FND_API.g_false
580: ,p_data => x_message_list);
581: WHEN default_status_err THEN
582: ROLLBACK TO default_status_sp;
583: x_return_status := FND_API.G_RET_STS_ERROR;

Line 583: x_return_status := FND_API.G_RET_STS_ERROR;

579: ,p_encoded => FND_API.g_false
580: ,p_data => x_message_list);
581: WHEN default_status_err THEN
582: ROLLBACK TO default_status_sp;
583: x_return_status := FND_API.G_RET_STS_ERROR;
584: fnd_msg_pub.count_and_get (
585: p_count => x_message_count
586: ,p_encoded => FND_API.g_false
587: ,p_data => x_message_list);

Line 586: ,p_encoded => FND_API.g_false

582: ROLLBACK TO default_status_sp;
583: x_return_status := FND_API.G_RET_STS_ERROR;
584: fnd_msg_pub.count_and_get (
585: p_count => x_message_count
586: ,p_encoded => FND_API.g_false
587: ,p_data => x_message_list);
588: WHEN OTHERS THEN
589: ROLLBACK TO SAVEPOINT create_routing;
590: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 590: x_return_status := FND_API.g_ret_sts_unexp_error;

586: ,p_encoded => FND_API.g_false
587: ,p_data => x_message_list);
588: WHEN OTHERS THEN
589: ROLLBACK TO SAVEPOINT create_routing;
590: x_return_status := FND_API.g_ret_sts_unexp_error;
591: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
592: IF (l_debug = 'Y') THEN
593: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
594: END IF;

Line 597: ,p_encoded => FND_API.g_false

593: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
594: END IF;
595: fnd_msg_pub.count_and_get (
596: p_count => x_message_count
597: ,p_encoded => FND_API.g_false
598: ,p_data => x_message_list);
599: END insert_routing;
600:
601: /* =============================================================== */

Line 632: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

628:
629: /* Local variable section */
630: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ROUTING';
631: l_routing_id gmd_routings.routing_id%TYPE;
632: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
633: l_cur_status gmd_status.status_code%TYPE;
634: l_owner_id gmd_routings.owner_id%TYPE;
635: l_owner_orgn_id NUMBER;
636:

Line 669: x_return_status := FND_API.G_RET_STS_SUCCESS;

665: BEGIN
666: SAVEPOINT update_routing;
667:
668: /* Set the return status to success initially */
669: x_return_status := FND_API.G_RET_STS_SUCCESS;
670:
671: /* Initialize message list and count if needed */
672: IF p_init_msg_list THEN
673: fnd_msg_pub.initialize;

Line 690: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version

686: RAISE setup_failure;
687: END IF;
688:
689: /* Make sure we are call compatible */
690: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
691: ,p_api_version
692: ,l_api_name
693: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
694: RAISE invalid_version;

Line 708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

704: ,pRouting_vers => p_routing_vers
705: ,xRouting_id => l_routing_id
706: ,xReturn_status => l_return_status);
707:
708: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
709: /* it indicates that this routing does'ntexists */
710: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
711: FND_MSG_PUB.ADD;
712: RAISE routing_update_failure;

Line 841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

837: , x_return_status => x_return_status
838: );
839:
840: /* Check if work was done */
841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
842: RAISE routing_update_failure;
843: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
844:
845: fnd_msg_pub.count_and_get (

Line 843: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */

839:
840: /* Check if work was done */
841: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
842: RAISE routing_update_failure;
843: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
844:
845: fnd_msg_pub.count_and_get (
846: p_count => x_message_count
847: ,p_encoded => FND_API.g_false

Line 847: ,p_encoded => FND_API.g_false

843: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
844:
845: fnd_msg_pub.count_and_get (
846: p_count => x_message_count
847: ,p_encoded => FND_API.g_false
848: ,p_data => x_message_list);
849:
850: IF x_message_count = 0 THEN
851: IF (l_debug = 'Y') THEN

Line 868: x_return_status := FND_API.G_RET_STS_ERROR;

864:
865: EXCEPTION
866: WHEN routing_update_failure OR invalid_version THEN
867: ROLLBACK TO SAVEPOINT update_routing;
868: x_return_status := FND_API.G_RET_STS_ERROR;
869: IF (l_debug = 'Y') THEN
870: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
871: END IF;
872: fnd_msg_pub.count_and_get (

Line 874: ,p_encoded => FND_API.g_false

870: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
871: END IF;
872: fnd_msg_pub.count_and_get (
873: p_count => x_message_count
874: ,p_encoded => FND_API.g_false
875: ,p_data => x_message_list);
876: WHEN setup_failure THEN
877: ROLLBACK TO SAVEPOINT update_routing;
878: x_return_status := FND_API.G_RET_STS_ERROR;

Line 878: x_return_status := FND_API.G_RET_STS_ERROR;

874: ,p_encoded => FND_API.g_false
875: ,p_data => x_message_list);
876: WHEN setup_failure THEN
877: ROLLBACK TO SAVEPOINT update_routing;
878: x_return_status := FND_API.G_RET_STS_ERROR;
879: fnd_msg_pub.count_and_get (
880: p_count => x_message_count
881: ,p_encoded => FND_API.g_false
882: ,p_data => x_message_list);

Line 881: ,p_encoded => FND_API.g_false

877: ROLLBACK TO SAVEPOINT update_routing;
878: x_return_status := FND_API.G_RET_STS_ERROR;
879: fnd_msg_pub.count_and_get (
880: p_count => x_message_count
881: ,p_encoded => FND_API.g_false
882: ,p_data => x_message_list);
883: WHEN OTHERS THEN
884: ROLLBACK TO SAVEPOINT update_routing;
885: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 885: x_return_status := FND_API.g_ret_sts_unexp_error;

881: ,p_encoded => FND_API.g_false
882: ,p_data => x_message_list);
883: WHEN OTHERS THEN
884: ROLLBACK TO SAVEPOINT update_routing;
885: x_return_status := FND_API.g_ret_sts_unexp_error;
886: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
887: IF (l_debug = 'Y') THEN
888: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
889: END IF;

Line 892: ,p_encoded => FND_API.g_false

888: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
889: END IF;
890: fnd_msg_pub.count_and_get (
891: p_count => x_message_count
892: ,p_encoded => FND_API.g_false
893: ,p_data => x_message_list);
894: END update_routing;
895:
896: /* =============================================================== */

Line 931: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

927: AND delete_mark = 0;
928: /* Local variable section */
929: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_ROUTING';
930: l_routing_id gmd_routings.routing_id%TYPE;
931: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
932: l_count NUMBER;
933:
934: /* Define a table type */
935: l_update_table GMD_ROUTINGS_PUB.UPDATE_TBL_TYPE;

Line 950: x_return_status := FND_API.G_RET_STS_SUCCESS;

946: gmd_debug.log_initialize('Dertpub');
947: END IF;
948:
949: /* Set the return status to success initially */
950: x_return_status := FND_API.G_RET_STS_SUCCESS;
951:
952: /* Initialize message list and count if needed */
953: IF p_init_msg_list THEN
954: fnd_msg_pub.initialize;

Line 966: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version

962: RAISE setup_failure;
963: END IF;
964:
965: /* Make sure we are call compatible */
966: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
967: ,p_api_version
968: ,l_api_name
969: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
970: x_return_status := FND_API.G_RET_STS_ERROR;

Line 970: x_return_status := FND_API.G_RET_STS_ERROR;

966: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
967: ,p_api_version
968: ,l_api_name
969: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
970: x_return_status := FND_API.G_RET_STS_ERROR;
971: RAISE invalid_version;
972: END IF;
973:
974: /* Validation :. Check if this routing that is deleted does exists

Line 985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

981: ,pRouting_vers => p_routing_vers
982: ,xRouting_id => l_routing_id
983: ,xReturn_status => l_return_status);
984:
985: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
986: /* it indicates that this routing does'ntexists */
987: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
988: FND_MSG_PUB.ADD;
989: RAISE routing_delete_failure;

Line 998: x_return_status := FND_API.G_RET_STS_ERROR;

994: If yes, then system raises error and terminates remaining processes w.r.t. bug 3355204*/
995: OPEN Cur_check_rout(p_routing_id);
996: FETCH Cur_check_rout INTO l_count;
997: IF (l_count <> 0) THEN
998: x_return_status := FND_API.G_RET_STS_ERROR;
999: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_USED');
1000: FND_MSG_PUB.ADD;
1001: RAISE routing_used;
1002: END IF;

Line 1017: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1013: , x_return_status => x_return_status
1014: );
1015:
1016: /* Check if work was done */
1017: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1018: RAISE routing_delete_failure;
1019: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1020:
1021: fnd_msg_pub.count_and_get (

Line 1019: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */

1015:
1016: /* Check if work was done */
1017: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1018: RAISE routing_delete_failure;
1019: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1020:
1021: fnd_msg_pub.count_and_get (
1022: p_count => x_message_count
1023: ,p_encoded => FND_API.g_false

Line 1023: ,p_encoded => FND_API.g_false

1019: END IF; /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS */
1020:
1021: fnd_msg_pub.count_and_get (
1022: p_count => x_message_count
1023: ,p_encoded => FND_API.g_false
1024: ,p_data => x_message_list);
1025:
1026: IF x_message_count = 0 THEN
1027: IF (l_debug = 'Y') THEN

Line 1044: x_return_status := FND_API.G_RET_STS_ERROR;

1040:
1041: EXCEPTION
1042: WHEN routing_delete_failure OR invalid_version or routing_used THEN
1043: ROLLBACK TO SAVEPOINT delete_routing;
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: IF (l_debug = 'Y') THEN
1046: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1047: END IF;
1048: fnd_msg_pub.count_and_get (

Line 1050: ,p_encoded => FND_API.g_false

1046: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1047: END IF;
1048: fnd_msg_pub.count_and_get (
1049: p_count => x_message_count
1050: ,p_encoded => FND_API.g_false
1051: ,p_data => x_message_list);
1052: WHEN setup_failure THEN
1053: ROLLBACK TO SAVEPOINT delete_routing;
1054: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1054: x_return_status := FND_API.G_RET_STS_ERROR;

1050: ,p_encoded => FND_API.g_false
1051: ,p_data => x_message_list);
1052: WHEN setup_failure THEN
1053: ROLLBACK TO SAVEPOINT delete_routing;
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055: fnd_msg_pub.count_and_get (
1056: p_count => x_message_count
1057: ,p_encoded => FND_API.g_false
1058: ,p_data => x_message_list);

Line 1057: ,p_encoded => FND_API.g_false

1053: ROLLBACK TO SAVEPOINT delete_routing;
1054: x_return_status := FND_API.G_RET_STS_ERROR;
1055: fnd_msg_pub.count_and_get (
1056: p_count => x_message_count
1057: ,p_encoded => FND_API.g_false
1058: ,p_data => x_message_list);
1059: WHEN OTHERS THEN
1060: ROLLBACK TO SAVEPOINT delete_routing;
1061: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1061: x_return_status := FND_API.g_ret_sts_unexp_error;

1057: ,p_encoded => FND_API.g_false
1058: ,p_data => x_message_list);
1059: WHEN OTHERS THEN
1060: ROLLBACK TO SAVEPOINT delete_routing;
1061: x_return_status := FND_API.g_ret_sts_unexp_error;
1062: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1063: IF (l_debug = 'Y') THEN
1064: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1065: END IF;

Line 1068: ,p_encoded => FND_API.g_false

1064: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1065: END IF;
1066: fnd_msg_pub.count_and_get (
1067: p_count => x_message_count
1068: ,p_encoded => FND_API.g_false
1069: ,p_data => x_message_list);
1070: END delete_routing;
1071:
1072: /* =============================================================== */

Line 1099: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1095:
1096: /* Local variable section */
1097: l_api_name CONSTANT VARCHAR2(30) := 'UNDELETE_ROUTING';
1098: l_routing_id gmd_routings.routing_id%TYPE;
1099: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1100:
1101: /* Define a table type */
1102: l_update_table GMD_ROUTINGS_PUB.UPDATE_TBL_TYPE;
1103:

Line 1115: x_return_status := FND_API.G_RET_STS_SUCCESS;

1111: gmd_debug.log_initialize('Undrtpub');
1112: END IF;
1113:
1114: /* Set the return status to success initially */
1115: x_return_status := FND_API.G_RET_STS_SUCCESS;
1116:
1117: /* Initialize message list and count if needed */
1118: IF p_init_msg_list THEN
1119: fnd_msg_pub.initialize;

Line 1131: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version

1127: RAISE setup_failure;
1128: END IF;
1129:
1130: /* Make sure we are call compatible */
1131: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
1132: ,p_api_version
1133: ,l_api_name
1134: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
1135: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR;

1131: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
1132: ,p_api_version
1133: ,l_api_name
1134: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
1135: x_return_status := FND_API.G_RET_STS_ERROR;
1136: RAISE invalid_version;
1137: END IF;
1138:
1139: /* Validation :. Check if this routing that is deleted does exists

Line 1150: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1146: ,pRouting_vers => p_routing_vers
1147: ,xRouting_id => l_routing_id
1148: ,xReturn_status => l_return_status);
1149:
1150: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1151: /* it indicates that this routing does'ntexists */
1152: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUTING_INVALID');
1153: FND_MSG_PUB.ADD;
1154: RAISE routing_undelete_failure;

Line 1164: ,p_encoded => FND_API.g_false

1160: WHERE routing_id = l_routing_id;
1161:
1162: fnd_msg_pub.count_and_get (
1163: p_count => x_message_count
1164: ,p_encoded => FND_API.g_false
1165: ,p_data => x_message_list);
1166:
1167: IF x_message_count = 0 THEN
1168: IF (l_debug = 'Y') THEN

Line 1185: x_return_status := FND_API.G_RET_STS_ERROR;

1181:
1182: EXCEPTION
1183: WHEN routing_undelete_failure OR invalid_version THEN
1184: ROLLBACK TO SAVEPOINT undelete_routing;
1185: x_return_status := FND_API.G_RET_STS_ERROR;
1186: IF (l_debug = 'Y') THEN
1187: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1188: END IF;
1189: fnd_msg_pub.count_and_get (

Line 1191: ,p_encoded => FND_API.g_false

1187: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'API not complete');
1188: END IF;
1189: fnd_msg_pub.count_and_get (
1190: p_count => x_message_count
1191: ,p_encoded => FND_API.g_false
1192: ,p_data => x_message_list);
1193: WHEN setup_failure THEN
1194: ROLLBACK TO SAVEPOINT undelete_routing;
1195: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1195: x_return_status := FND_API.G_RET_STS_ERROR;

1191: ,p_encoded => FND_API.g_false
1192: ,p_data => x_message_list);
1193: WHEN setup_failure THEN
1194: ROLLBACK TO SAVEPOINT undelete_routing;
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: fnd_msg_pub.count_and_get (
1197: p_count => x_message_count
1198: ,p_encoded => FND_API.g_false
1199: ,p_data => x_message_list);

Line 1198: ,p_encoded => FND_API.g_false

1194: ROLLBACK TO SAVEPOINT undelete_routing;
1195: x_return_status := FND_API.G_RET_STS_ERROR;
1196: fnd_msg_pub.count_and_get (
1197: p_count => x_message_count
1198: ,p_encoded => FND_API.g_false
1199: ,p_data => x_message_list);
1200: WHEN OTHERS THEN
1201: ROLLBACK TO SAVEPOINT undelete_routing;
1202: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1202: x_return_status := FND_API.g_ret_sts_unexp_error;

1198: ,p_encoded => FND_API.g_false
1199: ,p_data => x_message_list);
1200: WHEN OTHERS THEN
1201: ROLLBACK TO SAVEPOINT undelete_routing;
1202: x_return_status := FND_API.g_ret_sts_unexp_error;
1203: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1204: IF (l_debug = 'Y') THEN
1205: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1206: END IF;

Line 1209: ,p_encoded => FND_API.g_false

1205: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1206: END IF;
1207: fnd_msg_pub.count_and_get (
1208: p_count => x_message_count
1209: ,p_encoded => FND_API.g_false
1210: ,p_data => x_message_list);
1211: END undelete_routing;
1212:
1213: