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 GMD_ROUTINGS_PUB

Line 1: PACKAGE BODY GMD_ROUTINGS_PUB AS

1: PACKAGE BODY GMD_ROUTINGS_PUB AS
2: /* $Header: GMDPROUB.pls 120.4.12010000.2 2008/11/12 18:16:40 rnalla ship $ */
3:
4:
5: --Bug 3222090, NSRIVAST 20-FEB-2004, BEGIN

Line 44: , p_routings_step_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_tab

40: p_api_version IN NUMBER := 1
41: , p_init_msg_list IN BOOLEAN := TRUE
42: , p_commit IN BOOLEAN := FALSE
43: , p_routings IN gmd_routings%ROWTYPE
44: , p_routings_step_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_tab
45: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
46: , x_message_count OUT NOCOPY NUMBER
47: , x_message_list OUT NOCOPY VARCHAR2
48: , x_return_status OUT NOCOPY VARCHAR2

Line 45: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab

41: , p_init_msg_list IN BOOLEAN := TRUE
42: , p_commit IN BOOLEAN := FALSE
43: , p_routings IN gmd_routings%ROWTYPE
44: , p_routings_step_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_tab
45: , p_routings_step_dep_tbl IN GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab
46: , x_message_count OUT NOCOPY NUMBER
47: , x_message_list OUT NOCOPY VARCHAR2
48: , x_return_status OUT NOCOPY VARCHAR2
49: ) IS

Line 66: l_stepdep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;

62: l_return_from_routing_step VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
63: l_routing_qty gmd_routings.routing_qty%TYPE := 0;
64: l_process_loss gmd_routings.process_loss%TYPE := 0;
65: l_routing_class_um fm_rout_cls.uom%TYPE;
66: l_stepdep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
67: l_step_dep_tab GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
68:
69: --kkillams,bug 3408799
70: l_entity_status GMD_API_GRP.status_rec_type;

Line 67: l_step_dep_tab GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;

63: l_routing_qty gmd_routings.routing_qty%TYPE := 0;
64: l_process_loss gmd_routings.process_loss%TYPE := 0;
65: l_routing_class_um fm_rout_cls.uom%TYPE;
66: l_stepdep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
67: l_step_dep_tab GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
68:
69: --kkillams,bug 3408799
70: l_entity_status GMD_API_GRP.status_rec_type;
71:

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

142: RAISE setup_failure;
143: END IF;
144:
145: /* Make sure we are call compatible */
146: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
147: ,p_api_version
148: ,'INSERT_ROUTING'
149: ,gmd_routings_PUB.m_pkg_name) THEN
150: RAISE invalid_version;

Line 149: ,gmd_routings_PUB.m_pkg_name) THEN

145: /* Make sure we are call compatible */
146: IF NOT FND_API.compatible_api_call ( gmd_routings_PUB.m_api_version
147: ,p_api_version
148: ,'INSERT_ROUTING'
149: ,gmd_routings_PUB.m_pkg_name) THEN
150: RAISE invalid_version;
151: END IF;
152:
153: IF p_routings.routing_no IS NULL THEN

Line 566: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);

562: ,p_data => x_message_list);
563: WHEN OTHERS THEN
564: ROLLBACK TO SAVEPOINT create_routing;
565: x_return_status := FND_API.g_ret_sts_unexp_error;
566: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
567: IF (l_debug = 'Y') THEN
568: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
569: END IF;
570: fnd_msg_pub.count_and_get (

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

650: RAISE setup_failure;
651: END IF;
652:
653: /* Make sure we are call compatible */
654: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
655: ,p_api_version
656: ,l_api_name
657: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
658: RAISE invalid_version;

Line 657: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN

653: /* Make sure we are call compatible */
654: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
655: ,p_api_version
656: ,l_api_name
657: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
658: RAISE invalid_version;
659: END IF;
660:
661: /* Validation 1. Check if this routing that is updated does exists

Line 839: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);

835: ,p_data => x_message_list);
836: WHEN OTHERS THEN
837: ROLLBACK TO SAVEPOINT update_routing;
838: x_return_status := FND_API.g_ret_sts_unexp_error;
839: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
840: IF (l_debug = 'Y') THEN
841: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
842: END IF;
843: fnd_msg_pub.count_and_get (

Line 888: l_update_table GMD_ROUTINGS_PUB.UPDATE_TBL_TYPE;

884: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
885: l_count NUMBER;
886:
887: /* Define a table type */
888: l_update_table GMD_ROUTINGS_PUB.UPDATE_TBL_TYPE;
889:
890:
891: /* Define Exceptions */
892: routing_delete_failure EXCEPTION;

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

915: RAISE setup_failure;
916: END IF;
917:
918: /* Make sure we are call compatible */
919: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
920: ,p_api_version
921: ,l_api_name
922: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;

Line 922: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN

918: /* Make sure we are call compatible */
919: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
920: ,p_api_version
921: ,l_api_name
922: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: RAISE invalid_version;
925: END IF;
926:

Line 960: GMD_ROUTINGS_PUB.update_routing

956:
957: l_update_table(1).P_COL_TO_UPDATE := 'DELETE_MARK';
958: l_update_table(1).P_VALUE := '1';
959:
960: GMD_ROUTINGS_PUB.update_routing
961: ( p_routing_id => l_routing_id
962: , p_update_table => l_update_table
963: , p_commit => FALSE
964: , x_message_count => x_message_count

Line 1015: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);

1011: ,p_data => x_message_list);
1012: WHEN OTHERS THEN
1013: ROLLBACK TO SAVEPOINT delete_routing;
1014: x_return_status := FND_API.g_ret_sts_unexp_error;
1015: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1016: IF (l_debug = 'Y') THEN
1017: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1018: END IF;
1019: fnd_msg_pub.count_and_get (

Line 1055: l_update_table GMD_ROUTINGS_PUB.UPDATE_TBL_TYPE;

1051: l_routing_id gmd_routings.routing_id%TYPE;
1052: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1053:
1054: /* Define a table type */
1055: l_update_table GMD_ROUTINGS_PUB.UPDATE_TBL_TYPE;
1056:
1057: /* Define Exceptions */
1058: routing_undelete_failure EXCEPTION;
1059: invalid_version EXCEPTION;

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

1080: RAISE setup_failure;
1081: END IF;
1082:
1083: /* Make sure we are call compatible */
1084: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
1085: ,p_api_version
1086: ,l_api_name
1087: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
1088: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1087: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN

1083: /* Make sure we are call compatible */
1084: IF NOT FND_API.compatible_api_call ( GMD_ROUTINGS_PUB.m_api_version
1085: ,p_api_version
1086: ,l_api_name
1087: ,GMD_ROUTINGS_PUB.m_pkg_name) THEN
1088: x_return_status := FND_API.G_RET_STS_ERROR;
1089: RAISE invalid_version;
1090: END IF;
1091:

Line 1156: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);

1152: ,p_data => x_message_list);
1153: WHEN OTHERS THEN
1154: ROLLBACK TO SAVEPOINT undelete_routing;
1155: x_return_status := FND_API.g_ret_sts_unexp_error;
1156: fnd_msg_pub.add_exc_msg (gmd_routings_PUB.m_pkg_name, l_api_name);
1157: IF (l_debug = 'Y') THEN
1158: gmd_debug.put_line (m_pkg_name||'.'||l_api_name||':'||'When others exception:'||SQLERRM);
1159: END IF;
1160: fnd_msg_pub.count_and_get (

Line 1167: END GMD_ROUTINGS_PUB;

1163: ,p_data => x_message_list);
1164: END undelete_routing;
1165:
1166:
1167: END GMD_ROUTINGS_PUB;