APPS.GMD_ROUTINGS_PUB dependencies on GMDRTVAL_PUB

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

259:
260: /* Validation 1. Check if this routing that is created does not exists
261: in the the database. The routing_id is the PK or Routing_no and version is
262: the unique key for this table (gmd_routings_b). */
263: GMDRTVAL_PUB.check_routing(pRouting_no => p_routings.routing_no
264: ,pRouting_vers => p_routings.routing_vers
265: ,xRouting_id => l_routing_id
266: ,xReturn_status => l_return_status);
267:

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

294: CLOSE Get_oprn_details;
295: --Bug 8591276 is fixed by passing
296: --(,prouting_end_date => l_routings_rec.effective_end_date) the
297: --routing end date to the validation,So that it will compare with operation dates.
298: IF GMDRTVAL_PUB.check_oprn(poprn_no =>l_oprn_no
299: ,poprn_vers => l_oprn_vers
300: ,prouting_start_date => l_routings_rec.effective_start_date
301: ,prouting_end_date => l_routings_rec.effective_end_date
302: ) <> 0 THEN

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

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
326: IF GMDRTVAL_PUB.check_routing_class(p_routings.routing_class) <> 0 THEN
327: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_CLS');
328: FND_MSG_PUB.ADD;
329: RAISE routing_creation_failure;
330: END IF;

Line 370: l_process_loss := GMDRTVAL_PUB.get_theoretical_process_loss

366: ,from_name => NULL
367: ,to_name => NULL);
368:
369: /* Calculate the process loss */
370: l_process_loss := GMDRTVAL_PUB.get_theoretical_process_loss
371: (prouting_class => p_routings.Routing_class,
372: pquantity => l_routing_qty_cnv);
373:
374: ELSE

Line 703: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

699: the unique key for this table (gmd_routings_b). */
700: IF p_routing_id IS NOT NULL THEN
701: l_routing_id := p_routing_id;
702: ELSE
703: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
704: ,pRouting_vers => p_routing_vers
705: ,xRouting_id => l_routing_id
706: ,xReturn_status => l_return_status);
707:

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

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
769: IF p_update_table(a).p_value IS NOT NULL THEN
770: IF GMDRTVAL_PUB.check_routing_class(p_update_table(a).p_value) <> 0 THEN
771: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ROUT_CLS');
772: FND_MSG_PUB.ADD;
773: RAISE routing_update_failure;
774: END IF;

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

783: END IF;
784: END IF;
785: /* Validation: delete_mark validation */
786: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'DELETE_MARK' THEN
787: GMDRTVAL_PUB.check_delete_mark ( Pdelete_mark => p_update_table(a).p_value,
788: x_return_status => l_return_status);
789: IF l_return_status <> 'S' THEN /* it indicates that invalid value has been passed */
790: FND_MESSAGE.SET_NAME('GMA', 'SY_BADDELETEMARK');
791: FND_MSG_PUB.ADD;

Line 980: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

976: the unique key for this table (gmd_routings_b). */
977: IF p_routing_id IS NOT NULL THEN
978: l_routing_id := p_routing_id;
979: ELSE
980: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
981: ,pRouting_vers => p_routing_vers
982: ,xRouting_id => l_routing_id
983: ,xReturn_status => l_return_status);
984:

Line 1145: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no

1141: the unique key for this table (gmd_routings_b). */
1142: IF p_routing_id IS NOT NULL THEN
1143: l_routing_id := p_routing_id;
1144: ELSE
1145: GMDRTVAL_PUB.check_routing(pRouting_no => p_routing_no
1146: ,pRouting_vers => p_routing_vers
1147: ,xRouting_id => l_routing_id
1148: ,xReturn_status => l_return_status);
1149: