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_RECIPE_DETAIL dependencies on FND_MESSAGE

Line 126: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXISTS');

122: x_return_code => l_return_code,
123: x_recipe_id => l_recipe_id);
124:
125: IF (l_recipe_id IS NULL) THEN
126: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXISTS');
127: FND_MSG_PUB.ADD;
128: RAISE recipe_pr_loss_ins_failure;
129: ELSE
130: p_recipe_detail_rec.recipe_id := l_recipe_id;

Line 143: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

139: END IF;
140:
141: /* validate if the process loss orgn code is passed */
142: IF p_recipe_detail_rec.process_loss IS NULL THEN
143: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
144: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_LOSS');
145: FND_MSG_PUB.ADD;
146: RAISE recipe_pr_loss_ins_failure;
147: END IF;

Line 144: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_LOSS');

140:
141: /* validate if the process loss orgn code is passed */
142: IF p_recipe_detail_rec.process_loss IS NULL THEN
143: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
144: FND_MESSAGE.SET_TOKEN ('MISSING', 'PROCESS_LOSS');
145: FND_MSG_PUB.ADD;
146: RAISE recipe_pr_loss_ins_failure;
147: END IF;
148:

Line 151: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

147: END IF;
148:
149: /* validate if the process loss orgn code is passed */
150: IF p_recipe_detail_rec.organization_id IS NULL THEN
151: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
152: FND_MESSAGE.SET_TOKEN ('MISSING', 'OWNER_ORGANIZATION_ID');
153: FND_MSG_PUB.ADD;
154: RAISE recipe_pr_loss_ins_failure;
155: ELSE

Line 152: FND_MESSAGE.SET_TOKEN ('MISSING', 'OWNER_ORGANIZATION_ID');

148:
149: /* validate if the process loss orgn code is passed */
150: IF p_recipe_detail_rec.organization_id IS NULL THEN
151: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
152: FND_MESSAGE.SET_TOKEN ('MISSING', 'OWNER_ORGANIZATION_ID');
153: FND_MSG_PUB.ADD;
154: RAISE recipe_pr_loss_ins_failure;
155: ELSE
156: --Check the organization id passed is process enabled if not raise an error message

Line 158: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');

154: RAISE recipe_pr_loss_ins_failure;
155: ELSE
156: --Check the organization id passed is process enabled if not raise an error message
157: IF NOT (gmd_api_grp.check_orgn_status(p_recipe_detail_rec.organization_id)) THEN
158: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
159: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_recipe_detail_rec.organization_id);
160: FND_MSG_PUB.Add;
161: RAISE FND_API.G_EXC_ERROR;
162: END IF;

Line 159: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_recipe_detail_rec.organization_id);

155: ELSE
156: --Check the organization id passed is process enabled if not raise an error message
157: IF NOT (gmd_api_grp.check_orgn_status(p_recipe_detail_rec.organization_id)) THEN
158: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
159: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_recipe_detail_rec.organization_id);
160: FND_MSG_PUB.Add;
161: RAISE FND_API.G_EXC_ERROR;
162: END IF;
163: END IF;

Line 340: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');

336: x_return_code => l_return_code,
337: x_recipe_id => l_recipe_id);
338:
339: IF (l_recipe_id IS NULL) THEN
340: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
341: FND_MSG_PUB.ADD;
342: RAISE Recipe_Cust_ins_failure;
343: ELSE
344: p_recipe_detail_rec.recipe_id := l_recipe_id;

Line 368: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_CUSTOMER_INVALID');

364: XORG_ID => l_org_id,
365: XRETURN_CODE => l_return_code);
366:
367: IF (l_customer_id IS NULL) THEN
368: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_CUSTOMER_INVALID');
369: FND_MSG_PUB.ADD;
370: RAISE Recipe_Cust_ins_failure;
371: ELSE
372: p_recipe_detail_rec.customer_id := l_customer_id;

Line 389: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_SITE_INVALID');

385: XORG_ID => l_org_id,
386: XRETURN_CODE => l_return_code);
387:
388: IF (l_site_id IS NULL) THEN
389: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_SITE_INVALID');
390: FND_MSG_PUB.ADD;
391: RAISE Recipe_Cust_ins_failure;
392: ELSE
393: p_recipe_detail_rec.site_id := l_site_id;

Line 410: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORG_INVALID');

406: XORG_ID => l_org_id,
407: XRETURN_CODE => l_return_code);
408:
409: IF (l_org_id IS NULL) THEN
410: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORG_INVALID');
411: FND_MSG_PUB.ADD;
412: RAISE Recipe_Cust_ins_failure;
413: ELSE
414: p_recipe_detail_rec.org_id := l_org_id;

Line 435: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_CUSTOMER_INVALID');

431: x_return_code => l_return_code,
432: x_customer_id => l_customer_id);
433: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
434: x_return_status := FND_API.G_RET_STS_ERROR;
435: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_CUSTOMER_INVALID');
436: FND_MSG_PUB.ADD;
437: END IF;
438: END IF;
439:

Line 676: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');

672: x_return_code => l_return_code,
673: x_recipe_id => l_recipe_id);
674:
675: IF (l_recipe_id IS NULL) THEN
676: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
677: FND_MSG_PUB.ADD;
678: RAISE Recipe_VR_insert_failure;
679: ELSE
680: p_recipe_vr_rec.recipe_id := l_recipe_id;

Line 716: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_VR_DETAIL_UOM');

712: OPEN check_vr_detail_uom(p_recipe_vr_rec.detail_uom);
713: FETCH check_vr_detail_uom INTO l_vr_detail_um;
714: IF check_vr_detail_uom%NOTFOUND THEN
715: CLOSE check_vr_detail_uom;
716: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_VR_DETAIL_UOM');
717: FND_MESSAGE.SET_TOKEN ('DETAIL_UOM', p_recipe_vr_rec.detail_uom);
718: FND_MSG_PUB.ADD;
719: raise invalid_vr_detail_uom;
720: END IF;

Line 717: FND_MESSAGE.SET_TOKEN ('DETAIL_UOM', p_recipe_vr_rec.detail_uom);

713: FETCH check_vr_detail_uom INTO l_vr_detail_um;
714: IF check_vr_detail_uom%NOTFOUND THEN
715: CLOSE check_vr_detail_uom;
716: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_VR_DETAIL_UOM');
717: FND_MESSAGE.SET_TOKEN ('DETAIL_UOM', p_recipe_vr_rec.detail_uom);
718: FND_MSG_PUB.ADD;
719: raise invalid_vr_detail_uom;
720: END IF;
721: CLOSE check_vr_detail_uom;

Line 735: FND_MESSAGE.SET_NAME('GMD','GMD_ITEM_IS_PRODUCT');

731: OPEN get_specific_VR_details(p_recipe_vr_rec.recipe_id,p_recipe_vr_rec.inventory_item_id);
732: FETCH get_specific_VR_details INTO l_std_qty, l_std_qty_um;
733: IF get_specific_VR_details%NOTFOUND THEN
734: CLOSE get_specific_VR_details;
735: FND_MESSAGE.SET_NAME('GMD','GMD_ITEM_IS_PRODUCT');
736: fnd_msg_pub.add;
737: RAISE Recipe_VR_insert_failure;
738: END IF;
739: CLOSE get_specific_VR_details;

Line 1027: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');

1023: x_recipe_id => l_recipe_id);
1024:
1025: IF (l_recipe_id IS NULL) THEN
1026: x_return_status := FND_API.G_RET_STS_ERROR;
1027: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
1028: FND_MSG_PUB.ADD;
1029: ELSE
1030: p_recipe_mtl_rec.recipe_id := l_recipe_id;
1031: END IF;

Line 1048: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1044: /* Use the validation to check if */
1045: /* the routingstep_id has been provided */
1046: /* ==================================== */
1047: IF (p_recipe_mtl_rec.routingstep_id IS NULL) THEN
1048: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1049: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
1050: FND_MSG_PUB.ADD;
1051: RAISE insert_rcp_mat_failure;
1052: END IF;

Line 1049: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');

1045: /* the routingstep_id has been provided */
1046: /* ==================================== */
1047: IF (p_recipe_mtl_rec.routingstep_id IS NULL) THEN
1048: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1049: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
1050: FND_MSG_PUB.ADD;
1051: RAISE insert_rcp_mat_failure;
1052: END IF;
1053:

Line 1065: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1061: /* check if the formula line is valid and */
1062: /* exists */
1063: /* ======================================= */
1064: IF (p_recipe_mtl_rec.formulaline_id IS NULL) THEN
1065: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1066: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULALINE_ID');
1067: FND_MSG_PUB.ADD;
1068: RAISE insert_rcp_mat_failure;
1069: END IF;

Line 1066: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULALINE_ID');

1062: /* exists */
1063: /* ======================================= */
1064: IF (p_recipe_mtl_rec.formulaline_id IS NULL) THEN
1065: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1066: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULALINE_ID');
1067: FND_MSG_PUB.ADD;
1068: RAISE insert_rcp_mat_failure;
1069: END IF;
1070: /* ======================================= */

Line 1085: FND_MESSAGE.SET_NAME('GMD','GMD_NEG_VALUE_FOUND');

1081: END IF;
1082:
1083: --Minimum delay, Maximum delay and minimum_transfer_quantity cannot be negative
1084: IF( (NVL(p_recipe_mtl_rec.MINIMUM_DELAY,0)<0) or (NVL(p_recipe_mtl_rec.MAXIMUM_DELAY,0)<0) or (NVL(p_recipe_mtl_rec.MINIMUM_TRANSFER_QTY,0)<0) ) THEN
1085: FND_MESSAGE.SET_NAME('GMD','GMD_NEG_VALUE_FOUND');
1086: FND_MSG_PUB.Add;
1087: RAISE negative_values_exception;
1088: END IF;
1089:

Line 1093: FND_MESSAGE.SET_NAME('GMD','GMD_UNEXP_VALUES_FOUND');

1089:
1090:
1091: --Minimum delay must be less than to maximum delay
1092: IF ((NVL(p_recipe_mtl_rec.MINIMUM_DELAY,0)) > (NVL(p_recipe_mtl_rec.MAXIMUM_DELAY,0))) THEN
1093: FND_MESSAGE.SET_NAME('GMD','GMD_UNEXP_VALUES_FOUND');
1094: FND_MSG_PUB.Add;
1095: RAISE undesired_values_exception;
1096: END IF;
1097:

Line 1283: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1279: /* For updates we expect the surrogate */
1280: /* key to be provided */
1281: /* ================================== */
1282: IF (p_recipe_detail_rec.recipe_process_loss_id IS NULL) THEN
1283: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1284: FND_MESSAGE.SET_TOKEN ('MISSING', 'RECIPE_PROCESS_LOSS_ID');
1285: FND_MSG_PUB.ADD;
1286: RAISE update_pr_loss_failure;
1287: END IF;

Line 1284: FND_MESSAGE.SET_TOKEN ('MISSING', 'RECIPE_PROCESS_LOSS_ID');

1280: /* key to be provided */
1281: /* ================================== */
1282: IF (p_recipe_detail_rec.recipe_process_loss_id IS NULL) THEN
1283: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1284: FND_MESSAGE.SET_TOKEN ('MISSING', 'RECIPE_PROCESS_LOSS_ID');
1285: FND_MSG_PUB.ADD;
1286: RAISE update_pr_loss_failure;
1287: END IF;
1288:

Line 1523: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');

1519: x_return_code => l_return_code,
1520: x_recipe_id => l_recipe_id);
1521:
1522: IF (l_recipe_id IS NULL) THEN
1523: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
1524: FND_MSG_PUB.ADD;
1525: RAISE update_rcp_cust_failure;
1526: ELSE
1527: p_recipe_detail_rec.recipe_id := l_recipe_id;

Line 1551: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_CUSTOMER_INVALID');

1547: XORG_ID => l_org_id,
1548: XRETURN_CODE => l_return_code);
1549:
1550: IF (l_customer_id IS NULL) THEN
1551: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_CUSTOMER_INVALID');
1552: FND_MSG_PUB.ADD;
1553: RAISE update_rcp_cust_failure;
1554: ELSE
1555: p_recipe_detail_rec.customer_id := l_customer_id;

Line 1754: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1750: /* Send an error message if surrogate key */
1751: /* value is not provided */
1752: /* ======================================== */
1753: If (p_recipe_vr_rec.recipe_validity_rule_id IS NULL) THEN
1754: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1755: FND_MESSAGE.SET_TOKEN ('MISSING', 'RECIPE_VALIDITY_RULE_ID');
1756: FND_MSG_PUB.ADD;
1757: RAISE Update_VR_Failure;
1758: END IF;

Line 1755: FND_MESSAGE.SET_TOKEN ('MISSING', 'RECIPE_VALIDITY_RULE_ID');

1751: /* value is not provided */
1752: /* ======================================== */
1753: If (p_recipe_vr_rec.recipe_validity_rule_id IS NULL) THEN
1754: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1755: FND_MESSAGE.SET_TOKEN ('MISSING', 'RECIPE_VALIDITY_RULE_ID');
1756: FND_MSG_PUB.ADD;
1757: RAISE Update_VR_Failure;
1758: END IF;
1759:

Line 1766: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_VR_DETAIL_UOM');

1762: OPEN check_vr_detail_uom(p_recipe_vr_rec.detail_uom);
1763: FETCH check_vr_detail_uom INTO l_vr_detail_um;
1764: IF check_vr_detail_uom%NOTFOUND THEN
1765: CLOSE check_vr_detail_uom;
1766: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_VR_DETAIL_UOM');
1767: FND_MESSAGE.SET_TOKEN ('DETAIL_UOM', p_recipe_vr_rec.detail_uom);
1768: FND_MSG_PUB.ADD;
1769: raise invalid_vr_detail_uom;
1770: END IF;

Line 1767: FND_MESSAGE.SET_TOKEN ('DETAIL_UOM', p_recipe_vr_rec.detail_uom);

1763: FETCH check_vr_detail_uom INTO l_vr_detail_um;
1764: IF check_vr_detail_uom%NOTFOUND THEN
1765: CLOSE check_vr_detail_uom;
1766: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_VR_DETAIL_UOM');
1767: FND_MESSAGE.SET_TOKEN ('DETAIL_UOM', p_recipe_vr_rec.detail_uom);
1768: FND_MSG_PUB.ADD;
1769: raise invalid_vr_detail_uom;
1770: END IF;
1771: CLOSE check_vr_detail_uom;

Line 1832: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

1828: OPEN get_item_id(p_recipe_vr_rec.Item_no);
1829: FETCH get_item_id INTO p_recipe_vr_rec.inventory_item_id;
1830: IF get_item_id%NOTFOUND THEN
1831: CLOSE get_item_id;
1832: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1833: FND_MESSAGE.SET_TOKEN ('MISSING', 'ITEM_ID');
1834: FND_MSG_PUB.ADD;
1835: RAISE Update_VR_Failure;
1836: END IF;

Line 1833: FND_MESSAGE.SET_TOKEN ('MISSING', 'ITEM_ID');

1829: FETCH get_item_id INTO p_recipe_vr_rec.inventory_item_id;
1830: IF get_item_id%NOTFOUND THEN
1831: CLOSE get_item_id;
1832: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1833: FND_MESSAGE.SET_TOKEN ('MISSING', 'ITEM_ID');
1834: FND_MSG_PUB.ADD;
1835: RAISE Update_VR_Failure;
1836: END IF;
1837: CLOSE get_item_id;

Line 2252: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');

2248: x_recipe_id => l_recipe_id);
2249:
2250: IF (l_recipe_id IS NULL) OR x_return_status <> 'S' THEN
2251: x_return_status := FND_API.G_RET_STS_ERROR;
2252: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
2253: FND_MSG_PUB.ADD;
2254: RAISE FND_API.G_EXC_ERROR;
2255: ELSE
2256: p_recipe_detail_rec.recipe_id := l_recipe_id;

Line 2268: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');

2264: END IF;
2265:
2266: IF (p_recipe_detail_tbl(i).routingstep_id IS NULL) THEN
2267: x_return_status := FND_API.G_RET_STS_ERROR;
2268: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
2269: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
2270: FND_MSG_PUB.ADD;
2271: END IF;
2272:

Line 2269: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');

2265:
2266: IF (p_recipe_detail_tbl(i).routingstep_id IS NULL) THEN
2267: x_return_status := FND_API.G_RET_STS_ERROR;
2268: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
2269: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
2270: FND_MSG_PUB.ADD;
2271: END IF;
2272:
2273: IF (p_recipe_insert_flex.count = 0) THEN

Line 2710: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');

2706: x_recipe_id => l_recipe_id);
2707:
2708: IF (l_recipe_id IS NULL) THEN
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
2711: FND_MSG_PUB.ADD;
2712: ELSE
2713: p_recipe_detail_rec.recipe_id := l_recipe_id;
2714: END IF;

Line 2730: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');

2726: /* routing step exists */
2727: /* ================================ */
2728: IF (p_recipe_detail_rec.routingstep_id IS NULL) THEN
2729: x_return_status := FND_API.G_RET_STS_ERROR;
2730: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
2731: FND_MSG_PUB.ADD;
2732: END IF;
2733:
2734: /* ==================================== */

Line 2739: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');

2735: /* Check if a valid oprn line id exists */
2736: /* ===================================== */
2737: IF (p_recipe_detail_rec.oprn_line_id IS NULL) THEN
2738: x_return_status := FND_API.G_RET_STS_ERROR;
2739: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
2740: FND_MSG_PUB.ADD;
2741: END IF;
2742:
2743: /* Assign flex fields */

Line 3182: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');

3178: x_recipe_id => l_recipe_id);
3179:
3180: IF (l_recipe_id IS NULL) THEN
3181: x_return_status := FND_API.G_RET_STS_ERROR;
3182: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
3183: FND_MSG_PUB.ADD;
3184: ELSE
3185: p_recipe_detail_rec.recipe_id := l_recipe_id;
3186: END IF;

Line 3203: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');

3199: /* routing step exists */
3200: /* ================================ */
3201: IF (p_recipe_detail_rec.routingstep_id IS NULL) THEN
3202: x_return_status := FND_API.G_RET_STS_ERROR;
3203: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
3204: FND_MSG_PUB.ADD;
3205: END IF;
3206:
3207: /* ==================================== */

Line 3212: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');

3208: /* Check if a valid oprn line id exists */
3209: /* ===================================== */
3210: IF (p_recipe_detail_rec.oprn_line_id IS NULL) THEN
3211: x_return_status := FND_API.G_RET_STS_ERROR;
3212: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
3213: FND_MSG_PUB.ADD;
3214: END IF;
3215:
3216: /* ===================================== */

Line 3221: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');

3217: /* Check if a valid resource exists */
3218: /* ================================== */
3219: IF (p_recipe_detail_rec.resources IS NULL) THEN
3220: x_return_status := FND_API.G_RET_STS_ERROR;
3221: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
3222: FND_MSG_PUB.ADD;
3223: END IF;
3224:
3225:

Line 3239: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');

3235: IF l_oprn_uom IS NOT NULL THEN
3236: p_recipe_detail_rec.PROCESS_UM := l_oprn_uom;
3237: ELSE
3238: x_return_status := FND_API.G_RET_STS_ERROR;
3239: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
3240: FND_MSG_PUB.ADD;
3241: END IF;
3242:
3243: /* Bug No.6339150 - End */