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_API_GRP

Line 38: /* to be considered else assign gmd_api_grp.user_id. */

34: /* defined organization level w.r.t. bug 3408799 */
35: /* Uday Phadtare 13-MAR-2008 Bug 6871738. Select ROUTING_CLASS_UOM */
36: /* instead of UOM in Cursor Rout_cls_cur. */
37: /* Raju -- Bug 9314021 Feb 02 2010 if owner id is passed then it has */
38: /* to be considered else assign gmd_api_grp.user_id. */
39: /* ================================================================= */
40: PROCEDURE insert_routing
41: (
42: p_api_version IN NUMBER := 1

Line 72: l_entity_status GMD_API_GRP.status_rec_type;

68: l_stepdep_tbl GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
69: l_step_dep_tab GMD_ROUTINGS_PUB.gmd_routings_step_dep_tab;
70:
71: --kkillams,bug 3408799
72: l_entity_status GMD_API_GRP.status_rec_type;
73:
74: /* Define cursors */
75: /* gets the routing class uom */
76: --Bug 6871738. Select ROUTING_CLASS_UOM instead of UOM.

Line 149: IF NOT gmd_api_grp.setup_done THEN

145: END IF;
146:
147:
148: /* Intialize the setup fields */
149: IF NOT gmd_api_grp.setup_done THEN
150: gmd_api_grp.setup_done := gmd_api_grp.setup;
151: END IF;
152: IF NOT gmd_api_grp.setup_done THEN
153: RAISE setup_failure;

Line 150: gmd_api_grp.setup_done := gmd_api_grp.setup;

146:
147:
148: /* Intialize the setup fields */
149: IF NOT gmd_api_grp.setup_done THEN
150: gmd_api_grp.setup_done := gmd_api_grp.setup;
151: END IF;
152: IF NOT gmd_api_grp.setup_done THEN
153: RAISE setup_failure;
154: END IF;

Line 152: IF NOT gmd_api_grp.setup_done THEN

148: /* Intialize the setup fields */
149: IF NOT gmd_api_grp.setup_done THEN
150: gmd_api_grp.setup_done := gmd_api_grp.setup;
151: END IF;
152: IF NOT gmd_api_grp.setup_done THEN
153: RAISE setup_failure;
154: END IF;
155:
156: /* Make sure we are call compatible */

Line 210: ELSIF (NOT(gmd_api_grp.validate_um(p_routings.routing_uom))) THEN

206: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_UOM');
207: FND_MSG_PUB.ADD;
208: RAISE routing_creation_failure;
209: /* call common function to check if um passed is valid */
210: ELSIF (NOT(gmd_api_grp.validate_um(p_routings.routing_uom))) THEN
211: IF (l_debug = 'Y') THEN
212: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom invalid');
213: END IF;
214: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

Line 232: IF NOT (GMD_API_GRP.OrgnAccessible (powner_orgn_id => p_routings.owner_organization_id) ) THEN

228: RAISE routing_creation_failure;
229: END IF;
230:
231: -- Check if the responsibility has access to the organization
232: IF NOT (GMD_API_GRP.OrgnAccessible (powner_orgn_id => p_routings.owner_organization_id) ) THEN
233: RAISE routing_creation_failure;
234: END IF;
235:
236: --Check the organization id passed is process enabled if not raise an error message

Line 237: IF NOT (gmd_api_grp.check_orgn_status(p_routings.owner_organization_id)) THEN

233: RAISE routing_creation_failure;
234: END IF;
235:
236: --Check the organization id passed is process enabled if not raise an error message
237: IF NOT (gmd_api_grp.check_orgn_status(p_routings.owner_organization_id)) THEN
238: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
239: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_routings.owner_organization_id);
240: FND_MSG_PUB.Add;
241: RAISE routing_creation_failure;

Line 321: l_routings_rec.owner_id := NVL(p_routings.owner_id, gmd_api_grp.user_id); -- Bug 9314021

317: END IF;
318: CLOSE Cur_user_id;
319: END IF;
320: /* Assingning the owner_id,enforce_step_dependency if they are not passed */
321: l_routings_rec.owner_id := NVL(p_routings.owner_id, gmd_api_grp.user_id); -- Bug 9314021
322: l_routings_rec.enforce_step_dependency := NVL(p_routings.enforce_step_dependency,0);
323:
324: /* Validation : Check if Routing class is valid */
325: IF p_routings.routing_class IS NOT NULL THEN

Line 523: gmd_api_grp.get_status_details (V_entity_type => 'ROUTING',

519: COMMIT;
520: --kkillams,bug 3408799
521: SAVEPOINT default_status_sp;
522: --Getting the default status for the owner orgn code or null orgn of recipe from parameters table
523: gmd_api_grp.get_status_details (V_entity_type => 'ROUTING',
524: V_orgn_id => p_routings.owner_organization_id, --W.r.t. bug 4004501
525: X_entity_status => l_entity_status);
526: --Add this code after the call to gmd_routings_pkg.insert_row.
527: IF (l_entity_status.entity_status > 100) THEN

Line 682: IF NOT gmd_api_grp.setup_done THEN

678: ||'Begining of Update API ');
679: END IF;
680:
681: /* Intialize the setup fields */
682: IF NOT gmd_api_grp.setup_done THEN
683: gmd_api_grp.setup_done := gmd_api_grp.setup;
684: END IF;
685: IF NOT gmd_api_grp.setup_done THEN
686: RAISE setup_failure;

Line 683: gmd_api_grp.setup_done := gmd_api_grp.setup;

679: END IF;
680:
681: /* Intialize the setup fields */
682: IF NOT gmd_api_grp.setup_done THEN
683: gmd_api_grp.setup_done := gmd_api_grp.setup;
684: END IF;
685: IF NOT gmd_api_grp.setup_done THEN
686: RAISE setup_failure;
687: END IF;

Line 685: IF NOT gmd_api_grp.setup_done THEN

681: /* Intialize the setup fields */
682: IF NOT gmd_api_grp.setup_done THEN
683: gmd_api_grp.setup_done := gmd_api_grp.setup;
684: END IF;
685: IF NOT gmd_api_grp.setup_done THEN
686: RAISE setup_failure;
687: END IF;
688:
689: /* Make sure we are call compatible */

Line 731: ||'Validation of user - owner orgn ocde = '||gmd_api_grp.user_id);

727: /* Routing Security fix */
728: /* Validation: Check if for given user this routing can be modified */
729: IF (l_debug = 'Y') THEN
730: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
731: ||'Validation of user - owner orgn ocde = '||gmd_api_grp.user_id);
732: END IF;
733:
734: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
735: ,Entity_id => l_routing_id) THEN

Line 734: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'

730: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
731: ||'Validation of user - owner orgn ocde = '||gmd_api_grp.user_id);
732: END IF;
733:
734: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
735: ,Entity_id => l_routing_id) THEN
736: RAISE routing_update_failure;
737: END IF;
738:

Line 764: IF NOT GMD_API_GRP.OrgnAccessible(l_owner_orgn_id) THEN

760: /* Validation : Check if owner_orgn_id is valid */
761: /* Routing Security fix */
762: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'OWNER_ORGANIZATION_ID' THEN
763: l_owner_orgn_id := p_update_table(a).p_value;
764: IF NOT GMD_API_GRP.OrgnAccessible(l_owner_orgn_id) THEN
765: RAISE routing_update_failure;
766: END IF;
767: /* Validation : Check if Routing class is valid */
768: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'ROUTING_CLASS' THEN

Line 779: IF (NOT(gmd_api_grp.validate_um(p_update_table(a).p_value))) THEN

775: END IF;
776: /* Validation : Check if Routing uom is valid */
777: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'ROUTING_UOM' THEN
778: IF p_update_table(a).p_value IS NOT NULL THEN
779: IF (NOT(gmd_api_grp.validate_um(p_update_table(a).p_value))) THEN
780: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
781: FND_MSG_PUB.ADD;
782: RAISE routing_update_failure;
783: END IF;

Line 797: IF (NOT(gmd_api_grp.validate_um(p_update_table(a).p_value))) THEN

793: END IF;
794: /*RLNAGARA B6997624 Check if the fixed process loss uom is valid*/
795: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'FIXED_PROCESS_LOSS_UOM' THEN
796: IF p_update_table(a).p_value IS NOT NULL THEN
797: IF (NOT(gmd_api_grp.validate_um(p_update_table(a).p_value))) THEN
798: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
799: FND_MSG_PUB.ADD;
800: RAISE routing_update_failure;
801: END IF;

Line 958: IF NOT gmd_api_grp.setup_done THEN

954: fnd_msg_pub.initialize;
955: END IF;
956:
957: /* Intialize the setup fields */
958: IF NOT gmd_api_grp.setup_done THEN
959: gmd_api_grp.setup_done := gmd_api_grp.setup;
960: END IF;
961: IF NOT gmd_api_grp.setup_done THEN
962: RAISE setup_failure;

Line 959: gmd_api_grp.setup_done := gmd_api_grp.setup;

955: END IF;
956:
957: /* Intialize the setup fields */
958: IF NOT gmd_api_grp.setup_done THEN
959: gmd_api_grp.setup_done := gmd_api_grp.setup;
960: END IF;
961: IF NOT gmd_api_grp.setup_done THEN
962: RAISE setup_failure;
963: END IF;

Line 961: IF NOT gmd_api_grp.setup_done THEN

957: /* Intialize the setup fields */
958: IF NOT gmd_api_grp.setup_done THEN
959: gmd_api_grp.setup_done := gmd_api_grp.setup;
960: END IF;
961: IF NOT gmd_api_grp.setup_done THEN
962: RAISE setup_failure;
963: END IF;
964:
965: /* Make sure we are call compatible */

Line 1123: IF NOT gmd_api_grp.setup_done THEN

1119: fnd_msg_pub.initialize;
1120: END IF;
1121:
1122: /* Intialize the setup fields */
1123: IF NOT gmd_api_grp.setup_done THEN
1124: gmd_api_grp.setup_done := gmd_api_grp.setup;
1125: END IF;
1126: IF NOT gmd_api_grp.setup_done THEN
1127: RAISE setup_failure;

Line 1124: gmd_api_grp.setup_done := gmd_api_grp.setup;

1120: END IF;
1121:
1122: /* Intialize the setup fields */
1123: IF NOT gmd_api_grp.setup_done THEN
1124: gmd_api_grp.setup_done := gmd_api_grp.setup;
1125: END IF;
1126: IF NOT gmd_api_grp.setup_done THEN
1127: RAISE setup_failure;
1128: END IF;

Line 1126: IF NOT gmd_api_grp.setup_done THEN

1122: /* Intialize the setup fields */
1123: IF NOT gmd_api_grp.setup_done THEN
1124: gmd_api_grp.setup_done := gmd_api_grp.setup;
1125: END IF;
1126: IF NOT gmd_api_grp.setup_done THEN
1127: RAISE setup_failure;
1128: END IF;
1129:
1130: /* Make sure we are call compatible */