APPS.GMD_ROUTINGS_PUB dependencies on GMDRTVAL_PUB

Line 252: GMDRTVAL_PUB.check_routing(pRouting_no => p_routings.routing_no

248:
249: /* Validation 1. Check if this routing that is created does not exists
250: in the the database. The routing_id is the PK or Routing_no and version is
251: the unique key for this table (gmd_routings_b). */
252: GMDRTVAL_PUB.check_routing(pRouting_no => p_routings.routing_no
253: ,pRouting_vers => p_routings.routing_vers
254: ,xRouting_id => l_routing_id
255: ,xReturn_status => l_return_status);
256:

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

281: RAISE routing_creation_failure;
282: END IF;
283: CLOSE Get_oprn_details;
284:
285: IF GMDRTVAL_PUB.check_oprn(poprn_no =>l_oprn_no
286: ,poprn_vers => l_oprn_vers
287: ,prouting_start_date => l_routings_rec.effective_start_date
288: ) <> 0 THEN
289: FND_MESSAGE.SET_NAME('GMD', 'GMD_ROUT_DATES_INVALID');

Line 301: IF GMDRTVAL_PUB.check_routing_class(p_routings.routing_class) <> 0 THEN

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
301: IF GMDRTVAL_PUB.check_routing_class(p_routings.routing_class) <> 0 THEN
302: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_CLS');
303: FND_MSG_PUB.ADD;
304: RAISE routing_creation_failure;
305: END IF;

Line 345: l_process_loss := GMDRTVAL_PUB.get_theoretical_process_loss

341: ,from_name => NULL
342: ,to_name => NULL);
343:
344: /* Calculate the process loss */
345: l_process_loss := GMDRTVAL_PUB.get_theoretical_process_loss
346: (prouting_class => p_routings.Routing_class,
347: pquantity => l_routing_qty_cnv);
348:
349: ELSE

Line 667: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

663: the unique key for this table (gmd_routings_b). */
664: IF p_routing_id IS NOT NULL THEN
665: l_routing_id := p_routing_id;
666: ELSE
667: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
668: ,pRouting_vers => p_routing_vers
669: ,xRouting_id => l_routing_id
670: ,xReturn_status => l_return_status);
671:

Line 734: IF GMDRTVAL_PUB.check_routing_class(p_update_table(a).p_value) <> 0 THEN

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
733: IF p_update_table(a).p_value IS NOT NULL THEN
734: IF GMDRTVAL_PUB.check_routing_class(p_update_table(a).p_value) <> 0 THEN
735: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_CLS');
736: FND_MSG_PUB.ADD;
737: RAISE routing_update_failure;
738: END IF;

Line 751: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(a).p_value,

747: END IF;
748: END IF;
749: /* Validation: delete_mark validation */
750: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'DELETE_MARK' THEN
751: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(a).p_value,
752: x_return_status => l_return_status);
753: IF l_return_status <> 'S' THEN /* it indicates that invalid value has been passed */
754: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');
755: FND_MSG_PUB.ADD;

Line 933: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

929: the unique key for this table (gmd_routings_b). */
930: IF p_routing_id IS NOT NULL THEN
931: l_routing_id := p_routing_id;
932: ELSE
933: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
934: ,pRouting_vers => p_routing_vers
935: ,xRouting_id => l_routing_id
936: ,xReturn_status => l_return_status);
937:

Line 1098: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

1094: the unique key for this table (gmd_routings_b). */
1095: IF p_routing_id IS NOT NULL THEN
1096: l_routing_id := p_routing_id;
1097: ELSE
1098: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1099: ,pRouting_vers => p_routing_vers
1100: ,xRouting_id => l_routing_id
1101: ,xReturn_status => l_return_status);
1102: