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 668: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');

664: x_return_code => l_return_code,
665: x_recipe_id => l_recipe_id);
666:
667: IF (l_recipe_id IS NULL) THEN
668: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
669: FND_MSG_PUB.ADD;
670: RAISE Recipe_VR_insert_failure;
671: ELSE
672: p_recipe_vr_rec.recipe_id := l_recipe_id;

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

709: OPEN get_specific_VR_details(p_recipe_vr_rec.recipe_id,p_recipe_vr_rec.inventory_item_id);
710: FETCH get_specific_VR_details INTO l_std_qty, l_std_qty_um;
711: IF get_specific_VR_details%NOTFOUND THEN
712: CLOSE get_specific_VR_details;
713: FND_MESSAGE.SET_NAME('GMD','GMD_ITEM_IS_PRODUCT');
714: fnd_msg_pub.add;
715: RAISE Recipe_VR_insert_failure;
716: END IF;
717: CLOSE get_specific_VR_details;

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

980: x_recipe_id => l_recipe_id);
981:
982: IF (l_recipe_id IS NULL) THEN
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
985: FND_MSG_PUB.ADD;
986: ELSE
987: p_recipe_mtl_rec.recipe_id := l_recipe_id;
988: END IF;

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

1001: /* Use the validation to check if */
1002: /* the routingstep_id has been provided */
1003: /* ==================================== */
1004: IF (p_recipe_mtl_rec.routingstep_id IS NULL) THEN
1005: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1006: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
1007: FND_MSG_PUB.ADD;
1008: RAISE insert_rcp_mat_failure;
1009: END IF;

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

1002: /* the routingstep_id has been provided */
1003: /* ==================================== */
1004: IF (p_recipe_mtl_rec.routingstep_id IS NULL) THEN
1005: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1006: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
1007: FND_MSG_PUB.ADD;
1008: RAISE insert_rcp_mat_failure;
1009: END IF;
1010:

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

1018: /* check if the formula line is valid and */
1019: /* exists */
1020: /* ======================================= */
1021: IF (p_recipe_mtl_rec.formulaline_id IS NULL) THEN
1022: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1023: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULALINE_ID');
1024: FND_MSG_PUB.ADD;
1025: RAISE insert_rcp_mat_failure;
1026: END IF;

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

1019: /* exists */
1020: /* ======================================= */
1021: IF (p_recipe_mtl_rec.formulaline_id IS NULL) THEN
1022: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1023: FND_MESSAGE.SET_TOKEN ('MISSING', 'FORMULALINE_ID');
1024: FND_MSG_PUB.ADD;
1025: RAISE insert_rcp_mat_failure;
1026: END IF;
1027:

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

1180: /* For updates we expect the surrogate */
1181: /* key to be provided */
1182: /* ================================== */
1183: IF (p_recipe_detail_rec.recipe_process_loss_id IS NULL) THEN
1184: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1185: FND_MESSAGE.SET_TOKEN ('MISSING', 'RECIPE_PROCESS_LOSS_ID');
1186: FND_MSG_PUB.ADD;
1187: RAISE update_pr_loss_failure;
1188: END IF;

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

1181: /* key to be provided */
1182: /* ================================== */
1183: IF (p_recipe_detail_rec.recipe_process_loss_id IS NULL) THEN
1184: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1185: FND_MESSAGE.SET_TOKEN ('MISSING', 'RECIPE_PROCESS_LOSS_ID');
1186: FND_MSG_PUB.ADD;
1187: RAISE update_pr_loss_failure;
1188: END IF;
1189:

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

1420: x_return_code => l_return_code,
1421: x_recipe_id => l_recipe_id);
1422:
1423: IF (l_recipe_id IS NULL) THEN
1424: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
1425: FND_MSG_PUB.ADD;
1426: RAISE update_rcp_cust_failure;
1427: ELSE
1428: p_recipe_detail_rec.recipe_id := l_recipe_id;

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

1448: XORG_ID => l_org_id,
1449: XRETURN_CODE => l_return_code);
1450:
1451: IF (l_customer_id IS NULL) THEN
1452: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_CUSTOMER_INVALID');
1453: FND_MSG_PUB.ADD;
1454: RAISE update_rcp_cust_failure;
1455: ELSE
1456: p_recipe_detail_rec.customer_id := l_customer_id;

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

1643: /* Send an error message if surrogate key */
1644: /* value is not provided */
1645: /* ======================================== */
1646: If (p_recipe_vr_rec.recipe_validity_rule_id IS NULL) THEN
1647: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1648: FND_MESSAGE.SET_TOKEN ('MISSING', 'RECIPE_VALIDITY_RULE_ID');
1649: FND_MSG_PUB.ADD;
1650: RAISE Update_VR_Failure;
1651: END IF;

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

1644: /* value is not provided */
1645: /* ======================================== */
1646: If (p_recipe_vr_rec.recipe_validity_rule_id IS NULL) THEN
1647: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1648: FND_MESSAGE.SET_TOKEN ('MISSING', 'RECIPE_VALIDITY_RULE_ID');
1649: FND_MSG_PUB.ADD;
1650: RAISE Update_VR_Failure;
1651: END IF;
1652:

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

1707: OPEN get_item_id(p_recipe_vr_rec.Item_no);
1708: FETCH get_item_id INTO p_recipe_vr_rec.inventory_item_id;
1709: IF get_item_id%NOTFOUND THEN
1710: CLOSE get_item_id;
1711: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1712: FND_MESSAGE.SET_TOKEN ('MISSING', 'ITEM_ID');
1713: FND_MSG_PUB.ADD;
1714: RAISE Update_VR_Failure;
1715: END IF;

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

1708: FETCH get_item_id INTO p_recipe_vr_rec.inventory_item_id;
1709: IF get_item_id%NOTFOUND THEN
1710: CLOSE get_item_id;
1711: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
1712: FND_MESSAGE.SET_TOKEN ('MISSING', 'ITEM_ID');
1713: FND_MSG_PUB.ADD;
1714: RAISE Update_VR_Failure;
1715: END IF;
1716: CLOSE get_item_id;

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

2121: x_recipe_id => l_recipe_id);
2122:
2123: IF (l_recipe_id IS NULL) OR x_return_status <> 'S' THEN
2124: x_return_status := FND_API.G_RET_STS_ERROR;
2125: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
2126: FND_MSG_PUB.ADD;
2127: RAISE FND_API.G_EXC_ERROR;
2128: ELSE
2129: p_recipe_detail_rec.recipe_id := l_recipe_id;

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

2137: END IF;
2138:
2139: IF (p_recipe_detail_tbl(i).routingstep_id IS NULL) THEN
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
2142: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
2143: FND_MSG_PUB.ADD;
2144: END IF;
2145:

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

2138:
2139: IF (p_recipe_detail_tbl(i).routingstep_id IS NULL) THEN
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: FND_MESSAGE.SET_NAME ('GMI', 'GMI_MISSING');
2142: FND_MESSAGE.SET_TOKEN ('MISSING', 'ROUTINGSTEP_ID');
2143: FND_MSG_PUB.ADD;
2144: END IF;
2145:
2146: IF (p_recipe_insert_flex.count = 0) THEN

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

2579: x_recipe_id => l_recipe_id);
2580:
2581: IF (l_recipe_id IS NULL) THEN
2582: x_return_status := FND_API.G_RET_STS_ERROR;
2583: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
2584: FND_MSG_PUB.ADD;
2585: ELSE
2586: p_recipe_detail_rec.recipe_id := l_recipe_id;
2587: END IF;

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

2599: /* routing step exists */
2600: /* ================================ */
2601: IF (p_recipe_detail_rec.routingstep_id IS NULL) THEN
2602: x_return_status := FND_API.G_RET_STS_ERROR;
2603: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
2604: FND_MSG_PUB.ADD;
2605: END IF;
2606:
2607: /* ==================================== */

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

2608: /* Check if a valid oprn line id exists */
2609: /* ===================================== */
2610: IF (p_recipe_detail_rec.oprn_line_id IS NULL) THEN
2611: x_return_status := FND_API.G_RET_STS_ERROR;
2612: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
2613: FND_MSG_PUB.ADD;
2614: END IF;
2615:
2616: /* Assign flex fields */

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

3036: x_recipe_id => l_recipe_id);
3037:
3038: IF (l_recipe_id IS NULL) THEN
3039: x_return_status := FND_API.G_RET_STS_ERROR;
3040: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DOES_NOT_EXIST');
3041: FND_MSG_PUB.ADD;
3042: ELSE
3043: p_recipe_detail_rec.recipe_id := l_recipe_id;
3044: END IF;

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

3057: /* routing step exists */
3058: /* ================================ */
3059: IF (p_recipe_detail_rec.routingstep_id IS NULL) THEN
3060: x_return_status := FND_API.G_RET_STS_ERROR;
3061: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
3062: FND_MSG_PUB.ADD;
3063: END IF;
3064:
3065: /* ==================================== */

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

3066: /* Check if a valid oprn line id exists */
3067: /* ===================================== */
3068: IF (p_recipe_detail_rec.oprn_line_id IS NULL) THEN
3069: x_return_status := FND_API.G_RET_STS_ERROR;
3070: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
3071: FND_MSG_PUB.ADD;
3072: END IF;
3073:
3074: /* ===================================== */

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

3075: /* Check if a valid resource exists */
3076: /* ================================== */
3077: IF (p_recipe_detail_rec.resources IS NULL) THEN
3078: x_return_status := FND_API.G_RET_STS_ERROR;
3079: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
3080: FND_MSG_PUB.ADD;
3081: END IF;
3082:
3083: FOR update_rec IN update_res_cur (p_recipe_detail_rec.recipe_id,