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_ROUTING_STEPS_PUB dependencies on GMDRTVAL_PUB

Line 133: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

129: END IF;
130:
131: IF p_routing_id IS NOT NULL THEN
132: l_routing_id := p_routing_id;
133: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
134: ,pRouting_vers => p_routing_vers
135: ,xRouting_id => l_routing_id
136: ,xReturn_status => l_return_status);
137: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 144: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

140: FND_MSG_PUB.ADD;
141: RAISE routing_step_creation_failure;
142: END IF;
143: ELSE /* usually in this case user must have passed routing_no and version */
144: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
145: ,pRouting_vers => p_routing_vers
146: ,xRouting_id => l_routing_id
147: ,xReturn_status => l_return_status);
148:

Line 215: IF GMDRTVAL_PUB.check_routingstep_no(proutingstep_no => p_routing_step_rec.routingstep_no

211: END IF;
212: /* Validation : check if this routing step exists in our system */
213: /* If this step exists indicate a duplication not allowed message */
214: IF p_routing_step_rec.routingstep_no IS NOT NULL THEN
215: IF GMDRTVAL_PUB.check_routingstep_no(proutingstep_no => p_routing_step_rec.routingstep_no
216: ,prouting_id => p_routing_id) <> 0 THEN
217: FND_MESSAGE.SET_NAME('GMD', 'FM_RTSTEPERR');
218: FND_MSG_PUB.ADD;
219: RAISE routing_step_creation_failure;

Line 285: IF GMDRTVAL_PUB.check_oprn(poprn_no =>l_oprn_no

281: CLOSE Get_oprn_details;
282: RAISE routing_step_creation_failure;
283: END IF;
284: CLOSE Get_oprn_details;
285: IF GMDRTVAL_PUB.check_oprn(poprn_no =>l_oprn_no
286: ,poprn_vers => l_oprn_vers
287: ,prouting_start_date => l_rout_eff_start_date
288: ,prouting_end_date => l_rout_eff_end_date
289: ) <> 0 THEN

Line 583: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

579: END IF;
580: /* Validation : Check if routing header exists in the database */
581: IF p_routing_id IS NOT NULL THEN
582: l_routing_id := p_routing_id;
583: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
584: ,pRouting_vers => p_routing_vers
585: ,xRouting_id => l_routing_id
586: ,xReturn_status => l_return_status);
587:

Line 595: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

591: FND_MSG_PUB.ADD;
592: RAISE routing_step_dep_failure;
593: END IF;
594: ELSE /* usually in this case use must have passed routing_no and version */
595: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
596: ,pRouting_vers => p_routing_vers
597: ,xRouting_id => l_routing_id
598: ,xReturn_status => l_return_status);
599:

Line 645: GMDRTVAL_PUB.check_deprouting(pRouting_id => l_routing_id

641: and Routing_id */
642: /* Validation : Check if routing header exists in the database */
643:
644: FOR i IN 1 .. p_routings_step_dep_tbl.count LOOP
645: GMDRTVAL_PUB.check_deprouting(pRouting_id => l_routing_id
646: ,pRoutingstep_no => p_routingstep_no
647: ,pdeproutingstep_no => p_routings_step_dep_tbl(i).dep_routingstep_no
648: ,x_Return_status => l_return_status);
649:

Line 824: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

820: gmd_debug.put_line('Validation : check if the routing id is valid ');
821: END IF;
822: IF p_routing_id IS NOT NULL THEN
823: l_routing_id := p_routing_id;
824: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
825: ,pRouting_vers => p_routing_vers
826: ,xRouting_id => l_routing_id
827: ,xReturn_status => l_return_status);
828:

Line 836: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

832: FND_MSG_PUB.ADD;
833: RAISE routing_update_step_failure;
834: END IF;
835: ELSE /* usually in this case user must have passed routing_no and version */
836: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
837: ,pRouting_vers => p_routing_vers
838: ,xRouting_id => l_routing_id
839: ,xReturn_status => l_return_status);
840:

Line 882: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no

878: l_routingstep_id := p_routingstep_id;
879: IF (l_debug = 'Y') THEN
880: gmd_debug.put_line(' get the RoutingStep_no- for rtstepid = '||l_routingStep_id);
881: END IF;
882: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no
883: ,pxRoutingStep_id => l_routingstep_id
884: ,x_return_status => l_return_status );
885: IF (l_debug = 'Y') THEN
886: gmd_debug.put_line(' After get_rouingstep_info is called ret status = '||l_return_status);

Line 897: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id

893: END IF;
894: ELSE
895: /* hopefully the Routing step no was passed in .. */
896: l_routingstep_no := p_routingstep_no;
897: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id
898: ,pxRoutingStep_no => l_routingstep_no
899: ,pxRoutingStep_id => l_routingstep_id
900: ,x_return_status => l_return_status );
901: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 960: IF GMDRTVAL_PUB.check_oprn(poprn_id =>p_update_table(a).p_value

956: into l_rout_start_date,l_rout_end_date
957: from fm_rout_hdr
958: where routing_id =l_routing_id;
959:
960: IF GMDRTVAL_PUB.check_oprn(poprn_id =>p_update_table(a).p_value
961: ,prouting_start_date => l_rout_start_date
962: ,prouting_end_date => l_rout_end_date
963: ) <> 0 THEN
964: RAISE VALID_DATE_EXCEPTION;

Line 1169: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

1165:
1166: /* Validation : Check if routing header exists in the database */
1167: IF p_routing_id IS NOT NULL THEN
1168: l_routing_id := p_routing_id;
1169: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1170: ,pRouting_vers => p_routing_vers
1171: ,xRouting_id => l_routing_id
1172: ,xReturn_status => l_return_status);
1173:

Line 1181: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

1177: FND_MSG_PUB.ADD;
1178: RAISE routing_update_dep_failure;
1179: END IF;
1180: ELSE /* usually in this case user must have passed routing_no and version */
1181: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1182: ,pRouting_vers => p_routing_vers
1183: ,xRouting_id => l_routing_id
1184: ,xReturn_status => l_return_status);
1185:

Line 1223: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id

1219: ||p_routingstep_id);
1220: END IF;
1221: IF p_routingStep_no IS NOT NULL THEN
1222: l_routingstep_no := p_routingstep_no;
1223: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id
1224: ,pxRoutingStep_no => l_routingstep_no
1225: ,pxRoutingStep_id => l_routingstep_id
1226: ,x_return_status => l_return_status );
1227: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1236: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no

1232: END IF;
1233: ELSE
1234: /* hopefully the Routing step id was passed in .. */
1235: l_routingstep_id := p_routingstep_id;
1236: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no
1237: ,pxRoutingStep_id => l_routingstep_id
1238: ,x_return_status => l_return_status );
1239: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1240: /* it indicates that this routing does'ntexists */

Line 1421: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

1417: gmd_debug.put_line('Validation : Check if routing header exists in the database ');
1418: END IF;
1419: IF p_routing_id IS NOT NULL THEN
1420: l_routing_id := p_routing_id;
1421: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1422: ,pRouting_vers => p_routing_vers
1423: ,xRouting_id => l_routing_id
1424: ,xReturn_status => l_return_status);
1425:

Line 1433: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

1429: FND_MSG_PUB.ADD;
1430: RAISE routing_delete_step_failure;
1431: END IF;
1432: ELSE /* usually in this case user must have passed routing_no and version */
1433: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1434: ,pRouting_vers => p_routing_vers
1435: ,xRouting_id => l_routing_id
1436: ,xReturn_status => l_return_status);
1437:

Line 1477: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no

1473: l_routingstep_id := p_routingstep_id;
1474: IF (l_debug = 'Y') THEN
1475: gmd_debug.put_line(' get the RoutingStep_no- for rtstepid = '||l_routingStep_id);
1476: END IF;
1477: GMDRTVAL_PUB.get_routingstep_info(pxRoutingStep_no => l_routingstep_no
1478: ,pxRoutingStep_id => l_routingstep_id
1479: ,x_return_status => l_return_status );
1480: IF (l_debug = 'Y') THEN
1481: gmd_debug.put_line(' After get_rouingstep_info is called ret status = '||l_return_status);

Line 1494: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id

1490: IF (l_debug = 'Y') THEN
1491: gmd_debug.put_line(' get the RoutingStep_id - if it is not passed as a parameter ');
1492: END IF;
1493: l_routingstep_no := p_routingstep_no;
1494: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id
1495: ,pxRoutingStep_no => l_routingstep_no
1496: ,pxRoutingStep_id => l_routingstep_id
1497: ,x_return_status => l_return_status );
1498: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 1519: IF GMDRTVAL_PUB.Check_routing_override_exists(l_routingstep_id) THEN

1515: END IF;
1516:
1517: /* Validation : Check if this step is used in recipe override table and
1518: step material association table. If it is then delete is not allowed */
1519: IF GMDRTVAL_PUB.Check_routing_override_exists(l_routingstep_id) THEN
1520: FND_MESSAGE.SET_NAME('GMD', 'GMD_STEP_USED_IN_RECIPE');
1521: FND_MSG_PUB.ADD;
1522: RAISE routing_delete_step_failure;
1523: END IF;

Line 1684: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

1680: gmd_Debug.put_line('Validation: In dep step API if routing header exists in the database ');
1681: END IF;
1682: IF p_routing_id IS NOT NULL THEN
1683: l_routing_id := p_routing_id;
1684: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1685: ,pRouting_vers => p_routing_vers
1686: ,xRouting_id => l_routing_id
1687: ,xReturn_status => l_return_status);
1688:

Line 1696: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

1692: FND_MSG_PUB.ADD;
1693: RAISE routing_delete_dep_failure;
1694: END IF;
1695: ELSE /* usually in this case user must have passed routing_no and version */
1696: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1697: ,pRouting_vers => p_routing_vers
1698: ,xRouting_id => l_routing_id
1699: ,xReturn_status => l_return_status);
1700:

Line 1733: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id

1729: END IF;
1730:
1731: IF p_routingStep_no IS NOT NULL THEN
1732: l_routingstep_no := p_routingstep_no;
1733: GMDRTVAL_PUB.get_routingstep_info(pRouting_id => l_routing_id
1734: ,pxRoutingStep_no => l_routingstep_no
1735: ,pxRoutingStep_id => l_routingstep_id
1736: ,x_return_status => l_return_status );
1737: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN