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 70: l_entity_status GMD_API_GRP.status_rec_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:
72: /* Define cursors */
73: /* gets the routing class uom */
74: --Bug 6871738. Select ROUTING_CLASS_UOM instead of UOM.

Line 138: IF NOT gmd_api_grp.setup_done THEN

134: END IF;
135:
136:
137: /* Intialize the setup fields */
138: IF NOT gmd_api_grp.setup_done THEN
139: gmd_api_grp.setup_done := gmd_api_grp.setup;
140: END IF;
141: IF NOT gmd_api_grp.setup_done THEN
142: RAISE setup_failure;

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

135:
136:
137: /* Intialize the setup fields */
138: IF NOT gmd_api_grp.setup_done THEN
139: gmd_api_grp.setup_done := gmd_api_grp.setup;
140: END IF;
141: IF NOT gmd_api_grp.setup_done THEN
142: RAISE setup_failure;
143: END IF;

Line 141: IF NOT gmd_api_grp.setup_done THEN

137: /* Intialize the setup fields */
138: IF NOT gmd_api_grp.setup_done THEN
139: gmd_api_grp.setup_done := gmd_api_grp.setup;
140: END IF;
141: IF NOT gmd_api_grp.setup_done THEN
142: RAISE setup_failure;
143: END IF;
144:
145: /* Make sure we are call compatible */

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

195: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTING_UOM');
196: FND_MSG_PUB.ADD;
197: RAISE routing_creation_failure;
198: /* call common function to check if um passed is valid */
199: ELSIF (NOT(gmd_api_grp.validate_um(p_routings.routing_uom))) THEN
200: IF (l_debug = 'Y') THEN
201: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'||'Item uom invalid');
202: END IF;
203: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');

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

217: RAISE routing_creation_failure;
218: END IF;
219:
220: -- Check if the responsibility has access to the organization
221: IF NOT (GMD_API_GRP.OrgnAccessible (powner_orgn_id => p_routings.owner_organization_id) ) THEN
222: RAISE routing_creation_failure;
223: END IF;
224:
225: --Check the organization id passed is process enabled if not raise an error message

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

222: RAISE routing_creation_failure;
223: END IF;
224:
225: --Check the organization id passed is process enabled if not raise an error message
226: IF NOT (gmd_api_grp.check_orgn_status(p_routings.owner_organization_id)) THEN
227: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
228: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_routings.owner_organization_id);
229: FND_MSG_PUB.Add;
230: RAISE routing_creation_failure;

Line 296: l_routings_rec.owner_id := gmd_api_grp.user_id; -- Bug 4603060

292: END IF;
293: END LOOP; /* loop to validate routing dates */
294:
295: /* Assingning the owner_id,enforce_step_dependency if they are not passed */
296: l_routings_rec.owner_id := gmd_api_grp.user_id; -- Bug 4603060
297: l_routings_rec.enforce_step_dependency := NVL(p_routings.enforce_step_dependency,0);
298:
299: /* Validation : Check if Routing class is valid */
300: IF p_routings.routing_class IS NOT NULL THEN

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

494: COMMIT;
495: --kkillams,bug 3408799
496: SAVEPOINT default_status_sp;
497: --Getting the default status for the owner orgn code or null orgn of recipe from parameters table
498: gmd_api_grp.get_status_details (V_entity_type => 'ROUTING',
499: V_orgn_id => p_routings.owner_organization_id, --W.r.t. bug 4004501
500: X_entity_status => l_entity_status);
501: --Add this code after the call to gmd_routings_pkg.insert_row.
502: IF (l_entity_status.entity_status > 100) THEN

Line 646: IF NOT gmd_api_grp.setup_done THEN

642: ||'Begining of Update API ');
643: END IF;
644:
645: /* Intialize the setup fields */
646: IF NOT gmd_api_grp.setup_done THEN
647: gmd_api_grp.setup_done := gmd_api_grp.setup;
648: END IF;
649: IF NOT gmd_api_grp.setup_done THEN
650: RAISE setup_failure;

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

643: END IF;
644:
645: /* Intialize the setup fields */
646: IF NOT gmd_api_grp.setup_done THEN
647: gmd_api_grp.setup_done := gmd_api_grp.setup;
648: END IF;
649: IF NOT gmd_api_grp.setup_done THEN
650: RAISE setup_failure;
651: END IF;

Line 649: IF NOT gmd_api_grp.setup_done THEN

645: /* Intialize the setup fields */
646: IF NOT gmd_api_grp.setup_done THEN
647: gmd_api_grp.setup_done := gmd_api_grp.setup;
648: END IF;
649: IF NOT gmd_api_grp.setup_done THEN
650: RAISE setup_failure;
651: END IF;
652:
653: /* Make sure we are call compatible */

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

691: /* Routing Security fix */
692: /* Validation: Check if for given user this routing can be modified */
693: IF (l_debug = 'Y') THEN
694: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
695: ||'Validation of user - owner orgn ocde = '||gmd_api_grp.user_id);
696: END IF;
697:
698: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
699: ,Entity_id => l_routing_id) THEN

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

694: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
695: ||'Validation of user - owner orgn ocde = '||gmd_api_grp.user_id);
696: END IF;
697:
698: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
699: ,Entity_id => l_routing_id) THEN
700: RAISE routing_update_failure;
701: END IF;
702:

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

724: /* Validation : Check if owner_orgn_id is valid */
725: /* Routing Security fix */
726: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'OWNER_ORGANIZATION_ID' THEN
727: l_owner_orgn_id := p_update_table(a).p_value;
728: IF NOT GMD_API_GRP.OrgnAccessible(l_owner_orgn_id) THEN
729: RAISE routing_update_failure;
730: END IF;
731: /* Validation : Check if Routing class is valid */
732: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'ROUTING_CLASS' THEN

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

739: END IF;
740: /* Validation : Check if Routing uom is valid */
741: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'ROUTING_UOM' THEN
742: IF p_update_table(a).p_value IS NOT NULL THEN
743: IF (NOT(gmd_api_grp.validate_um(p_update_table(a).p_value))) THEN
744: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
745: FND_MSG_PUB.ADD;
746: RAISE routing_update_failure;
747: END IF;

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

757: END IF;
758: /*RLNAGARA B6997624 Check if the fixed process loss uom is valid*/
759: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'FIXED_PROCESS_LOSS_UOM' THEN
760: IF p_update_table(a).p_value IS NOT NULL THEN
761: IF (NOT(gmd_api_grp.validate_um(p_update_table(a).p_value))) THEN
762: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
763: FND_MSG_PUB.ADD;
764: RAISE routing_update_failure;
765: END IF;

Line 768: l_owner_id := gmd_api_grp.user_id; -- Bug 4603060

764: RAISE routing_update_failure;
765: END IF;
766: END IF;
767: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'OWNER_ID' THEN
768: l_owner_id := gmd_api_grp.user_id; -- Bug 4603060
769: END IF;
770:
771:
772: /* Validation : Routing status is not On Hold nor Obsolete/Archived

Line 911: IF NOT gmd_api_grp.setup_done THEN

907: fnd_msg_pub.initialize;
908: END IF;
909:
910: /* Intialize the setup fields */
911: IF NOT gmd_api_grp.setup_done THEN
912: gmd_api_grp.setup_done := gmd_api_grp.setup;
913: END IF;
914: IF NOT gmd_api_grp.setup_done THEN
915: RAISE setup_failure;

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

908: END IF;
909:
910: /* Intialize the setup fields */
911: IF NOT gmd_api_grp.setup_done THEN
912: gmd_api_grp.setup_done := gmd_api_grp.setup;
913: END IF;
914: IF NOT gmd_api_grp.setup_done THEN
915: RAISE setup_failure;
916: END IF;

Line 914: IF NOT gmd_api_grp.setup_done THEN

910: /* Intialize the setup fields */
911: IF NOT gmd_api_grp.setup_done THEN
912: gmd_api_grp.setup_done := gmd_api_grp.setup;
913: END IF;
914: IF NOT gmd_api_grp.setup_done THEN
915: RAISE setup_failure;
916: END IF;
917:
918: /* Make sure we are call compatible */

Line 1076: IF NOT gmd_api_grp.setup_done THEN

1072: fnd_msg_pub.initialize;
1073: END IF;
1074:
1075: /* Intialize the setup fields */
1076: IF NOT gmd_api_grp.setup_done THEN
1077: gmd_api_grp.setup_done := gmd_api_grp.setup;
1078: END IF;
1079: IF NOT gmd_api_grp.setup_done THEN
1080: RAISE setup_failure;

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

1073: END IF;
1074:
1075: /* Intialize the setup fields */
1076: IF NOT gmd_api_grp.setup_done THEN
1077: gmd_api_grp.setup_done := gmd_api_grp.setup;
1078: END IF;
1079: IF NOT gmd_api_grp.setup_done THEN
1080: RAISE setup_failure;
1081: END IF;

Line 1079: IF NOT gmd_api_grp.setup_done THEN

1075: /* Intialize the setup fields */
1076: IF NOT gmd_api_grp.setup_done THEN
1077: gmd_api_grp.setup_done := gmd_api_grp.setup;
1078: END IF;
1079: IF NOT gmd_api_grp.setup_done THEN
1080: RAISE setup_failure;
1081: END IF;
1082:
1083: /* Make sure we are call compatible */