104: fnd_msg_pub.initialize;
105: END IF;
106:
107: /* Intialize the setup fields */
108: IF NOT gmd_api_grp.setup_done THEN
109: gmd_api_grp.setup_done := gmd_api_grp.setup;
110: END IF;
111: IF NOT gmd_api_grp.setup_done THEN
112: RAISE setup_failure;
105: END IF;
106:
107: /* Intialize the setup fields */
108: IF NOT gmd_api_grp.setup_done THEN
109: gmd_api_grp.setup_done := gmd_api_grp.setup;
110: END IF;
111: IF NOT gmd_api_grp.setup_done THEN
112: RAISE setup_failure;
113: END IF;
107: /* Intialize the setup fields */
108: IF NOT gmd_api_grp.setup_done THEN
109: gmd_api_grp.setup_done := gmd_api_grp.setup;
110: END IF;
111: IF NOT gmd_api_grp.setup_done THEN
112: RAISE setup_failure;
113: END IF;
114:
115: /* Make sure we are call compatible */
168: /* Routing Security Validation */
169: /* Validation: Check if for given user this routing can be modified */
170: IF (l_debug = 'Y') THEN
171: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
172: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
173: END IF;
174:
175:
176: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
172: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
173: END IF;
174:
175:
176: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
177: ,Entity_id => l_routing_id) THEN
178: RAISE routing_step_creation_failure;
179: END IF;
180:
496: fnd_msg_pub.initialize;
497: END IF;
498:
499: /* Intialize the setup fields */
500: IF NOT gmd_api_grp.setup_done THEN
501: gmd_api_grp.setup_done := gmd_api_grp.setup;
502: END IF;
503: IF NOT gmd_api_grp.setup_done THEN
504: RAISE setup_failure;
497: END IF;
498:
499: /* Intialize the setup fields */
500: IF NOT gmd_api_grp.setup_done THEN
501: gmd_api_grp.setup_done := gmd_api_grp.setup;
502: END IF;
503: IF NOT gmd_api_grp.setup_done THEN
504: RAISE setup_failure;
505: END IF;
499: /* Intialize the setup fields */
500: IF NOT gmd_api_grp.setup_done THEN
501: gmd_api_grp.setup_done := gmd_api_grp.setup;
502: END IF;
503: IF NOT gmd_api_grp.setup_done THEN
504: RAISE setup_failure;
505: END IF;
506:
507: /* Make sure we are call compatible */
544: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_NO_UOM');
545: FND_MSG_PUB.ADD;
546: RAISE routing_step_dep_failure;
547: /* call common function to check if um passed is valid */
548: ELSIF (NOT(gmd_api_grp.validate_um(p_routings_step_dep_tbl(1).routingstep_no_uom))) THEN
549: IF (l_debug = 'Y') THEN
550: gmd_debug.put_line('Item uom invalid');
551: END IF;
552: FND_MESSAGE.SET_NAME('GMA', 'SY_INVALID_UM_CODE');
619: /* Routing Security Validation */
620: /* Validation: Check if for given user this routing can be modified */
621: IF (l_debug = 'Y') THEN
622: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
623: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
624: END IF;
625: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
626: ,Entity_id => l_routing_id) THEN
627: RAISE routing_step_dep_failure;
621: IF (l_debug = 'Y') THEN
622: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
623: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
624: END IF;
625: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
626: ,Entity_id => l_routing_id) THEN
627: RAISE routing_step_dep_failure;
628: END IF;
629:
795: fnd_msg_pub.initialize;
796: END IF;
797:
798: /* Intialize the setup fields */
799: IF NOT gmd_api_grp.setup_done THEN
800: gmd_api_grp.setup_done := gmd_api_grp.setup;
801: END IF;
802: IF NOT gmd_api_grp.setup_done THEN
803: RAISE setup_failure;
796: END IF;
797:
798: /* Intialize the setup fields */
799: IF NOT gmd_api_grp.setup_done THEN
800: gmd_api_grp.setup_done := gmd_api_grp.setup;
801: END IF;
802: IF NOT gmd_api_grp.setup_done THEN
803: RAISE setup_failure;
804: END IF;
798: /* Intialize the setup fields */
799: IF NOT gmd_api_grp.setup_done THEN
800: gmd_api_grp.setup_done := gmd_api_grp.setup;
801: END IF;
802: IF NOT gmd_api_grp.setup_done THEN
803: RAISE setup_failure;
804: END IF;
805:
806: /* Make sure we are call compatible */
860: /* Routing Security fix */
861: /* Validation: Check if for given user this routing can be modified */
862: IF (l_debug = 'Y') THEN
863: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
864: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
865: END IF;
866: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
867: ,Entity_id => l_routing_id) THEN
868: RAISE routing_update_step_failure;
862: IF (l_debug = 'Y') THEN
863: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
864: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
865: END IF;
866: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
867: ,Entity_id => l_routing_id) THEN
868: RAISE routing_update_step_failure;
869: END IF;
870:
1099: fnd_msg_pub.initialize;
1100: END IF;
1101:
1102: /* Intialize the setup fields */
1103: IF NOT gmd_api_grp.setup_done THEN
1104: gmd_api_grp.setup_done := gmd_api_grp.setup;
1105: END IF;
1106: IF NOT gmd_api_grp.setup_done THEN
1107: RAISE setup_failure;
1100: END IF;
1101:
1102: /* Intialize the setup fields */
1103: IF NOT gmd_api_grp.setup_done THEN
1104: gmd_api_grp.setup_done := gmd_api_grp.setup;
1105: END IF;
1106: IF NOT gmd_api_grp.setup_done THEN
1107: RAISE setup_failure;
1108: END IF;
1102: /* Intialize the setup fields */
1103: IF NOT gmd_api_grp.setup_done THEN
1104: gmd_api_grp.setup_done := gmd_api_grp.setup;
1105: END IF;
1106: IF NOT gmd_api_grp.setup_done THEN
1107: RAISE setup_failure;
1108: END IF;
1109:
1110: /* Make sure we are call compatible */
1205: /* Routing Security fix */
1206: /* Validation: Check if for given user this routing can be modified */
1207: IF (l_debug = 'Y') THEN
1208: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
1209: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
1210: END IF;
1211: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
1212: ,Entity_id => l_routing_id) THEN
1213: RAISE routing_update_dep_failure;
1207: IF (l_debug = 'Y') THEN
1208: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
1209: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
1210: END IF;
1211: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
1212: ,Entity_id => l_routing_id) THEN
1213: RAISE routing_update_dep_failure;
1214: END IF;
1215:
1393: fnd_msg_pub.initialize;
1394: END IF;
1395:
1396: /* Intialize the setup fields */
1397: IF NOT gmd_api_grp.setup_done THEN
1398: gmd_api_grp.setup_done := gmd_api_grp.setup;
1399: END IF;
1400: IF NOT gmd_api_grp.setup_done THEN
1401: RAISE setup_failure;
1394: END IF;
1395:
1396: /* Intialize the setup fields */
1397: IF NOT gmd_api_grp.setup_done THEN
1398: gmd_api_grp.setup_done := gmd_api_grp.setup;
1399: END IF;
1400: IF NOT gmd_api_grp.setup_done THEN
1401: RAISE setup_failure;
1402: END IF;
1396: /* Intialize the setup fields */
1397: IF NOT gmd_api_grp.setup_done THEN
1398: gmd_api_grp.setup_done := gmd_api_grp.setup;
1399: END IF;
1400: IF NOT gmd_api_grp.setup_done THEN
1401: RAISE setup_failure;
1402: END IF;
1403:
1404: /* Make sure we are call compatible */
1457: /* Routing Security Validation */
1458: /* Validation: Check if for given user this routing can be modified */
1459: IF (l_debug = 'Y') THEN
1460: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
1461: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
1462: END IF;
1463: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
1464: ,Entity_id => l_routing_id) THEN
1465: RAISE routing_delete_step_failure;
1459: IF (l_debug = 'Y') THEN
1460: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
1461: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
1462: END IF;
1463: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
1464: ,Entity_id => l_routing_id) THEN
1465: RAISE routing_delete_step_failure;
1466: END IF;
1467:
1653: fnd_msg_pub.initialize;
1654: END IF;
1655:
1656: /* Intialize the setup fields */
1657: IF NOT gmd_api_grp.setup_done THEN
1658: gmd_api_grp.setup_done := gmd_api_grp.setup;
1659: END IF;
1660: IF NOT gmd_api_grp.setup_done THEN
1661: RAISE setup_failure;
1654: END IF;
1655:
1656: /* Intialize the setup fields */
1657: IF NOT gmd_api_grp.setup_done THEN
1658: gmd_api_grp.setup_done := gmd_api_grp.setup;
1659: END IF;
1660: IF NOT gmd_api_grp.setup_done THEN
1661: RAISE setup_failure;
1662: END IF;
1656: /* Intialize the setup fields */
1657: IF NOT gmd_api_grp.setup_done THEN
1658: gmd_api_grp.setup_done := gmd_api_grp.setup;
1659: END IF;
1660: IF NOT gmd_api_grp.setup_done THEN
1661: RAISE setup_failure;
1662: END IF;
1663:
1664: /* Make sure we are call compatible */
1720: /* Routing Security Validation */
1721: /* Validation: Check if for given user this routing can be modified */
1722: IF (l_debug = 'Y') THEN
1723: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
1724: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
1725: END IF;
1726: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
1727: ,Entity_id => l_routing_id) THEN
1728: RAISE routing_delete_dep_failure;
1722: IF (l_debug = 'Y') THEN
1723: gmd_debug.put_line(m_pkg_name||'.'||l_api_name||':'
1724: ||'Validation of user - owner orgn code = '||gmd_api_grp.user_id);
1725: END IF;
1726: IF NOT GMD_API_GRP.Check_orgn_access(Entity => 'ROUTING'
1727: ,Entity_id => l_routing_id) THEN
1728: RAISE routing_delete_dep_failure;
1729: END IF;
1730: