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_HEADER_PVT dependencies on FND_MSG_PUB

Line 102: FND_MSG_PUB.ADD;

98: NVL(p_recipe_header_rec.recipe_Status,
99: '100'));
100: IF (NOT l_val_rt_status) THEN
101: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
102: FND_MSG_PUB.ADD;
103: RAISE FND_API.G_EXC_ERROR;
104: END IF;
105: END IF;
106: -- End bug 2099699

Line 116: FND_MSG_PUB.Add;

112: If ((p_recipe_header_rec.recipe_no IS NULL )
113: OR (p_recipe_header_rec.recipe_version IS NULL)) THEN
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_VALID');
116: FND_MSG_PUB.Add;
117: END IF;
118:
119: /* ================================ */
120: /* Based on Recipe_no and */

Line 139: FND_MSG_PUB.ADD;

135:
136: IF (l_recipe_id IS NOT NULL) THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MESSAGE.SET_NAME('GMD', 'GMD_DUP_RECIPE');
139: FND_MSG_PUB.ADD;
140: END IF;
141:
142: l_formula_id := p_recipe_header_rec.formula_id;
143:

Line 175: FND_MSG_PUB.ADD;

171: NOT (p_recipe_header_rec.routing_no IS NOT NULL AND
172: p_recipe_header_rec.routing_vers IS NOT NULL))
173: THEN
174: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
175: FND_MSG_PUB.ADD;
176: END IF; -- end setting error message
177: END IF; -- end if routing info is given
178:
179: /* ==================================== */

Line 197: FND_MSG_PUB.ADD;

193:
194: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DESCRIPTION');
197: FND_MSG_PUB.ADD;
198: END IF;
199: ELSE
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DECRIPTION');

Line 202: FND_MSG_PUB.ADD;

198: END IF;
199: ELSE
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_DECRIPTION');
202: FND_MSG_PUB.ADD;
203: END IF;
204:
205: /* ============================================ */
206: /* Validate Owner and Creator Organization code. */

Line 219: FND_MSG_PUB.ADD;

215:
216: /*IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
217: x_return_status := FND_API.G_RET_STS_ERROR;
218: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
219: FND_MSG_PUB.ADD;
220: END IF;*/
221:
222: IF (x_return_status = 'S') THEN
223: /* ===================================== */

Line 312: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);

308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: x_return_status := FND_API.G_RET_STS_ERROR;
311: WHEN OTHERS THEN
312: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: END CREATE_RECIPE_HEADER;
315:
316:

Line 447: FND_MSG_PUB.ADD;

443: (p_recipe_header_rec.routing_id,
444: p_recipe_header_rec.recipe_Status);
445: IF (NOT l_val_rt_status) THEN
446: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
447: FND_MSG_PUB.ADD;
448: RAISE FND_API.G_EXC_ERROR;
449: END IF;
450: ELSIF (l_status_type IN ('700','900')) THEN
451: IF (x_routing_id IS NOT NULL AND

Line 455: FND_MSG_PUB.ADD;

451: IF (x_routing_id IS NOT NULL AND
452: p_recipe_header_rec.routing_id IS NOT NULL AND
453: x_routing_id <> p_recipe_header_rec.routing_id) THEN
454: FND_MESSAGE.SET_NAME('GMD','GMD_RECIPE_INVALID_MODE');
455: FND_MSG_PUB.ADD;
456: RAISE FND_API.G_EXC_ERROR;
457: END IF;
458: END IF;
459: END IF;

Line 481: FND_MSG_PUB.ADD;

477:
478: IF (p_recipe_header_rec.Recipe_status BETWEEN '900' and '999') THEN
479: x_return_status := FND_API.G_RET_STS_ERROR;
480: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_UPDATE_NOT_ALLOWED');
481: FND_MSG_PUB.ADD;
482: END IF;
483:
484: l_return_status := 'S';
485:

Line 516: FND_MSG_PUB.ADD;

512: NOT (p_recipe_header_rec.routing_no IS NOT NULL AND
513: p_recipe_header_rec.routing_vers IS NOT NULL))
514: THEN
515: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ROUTING_INVALID');
516: FND_MSG_PUB.ADD;
517: END IF; -- end setting error message
518: END IF; -- end if routing info is given
519:
520: /* ===================================== */

Line 532: FND_MSG_PUB.ADD;

528:
529: /*IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
532: FND_MSG_PUB.ADD;
533: END IF;*/
534:
535: /* Making an updates into Recipe table */
536: /* To incorporate MLS, we need to call the */

Line 668: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);

664: EXCEPTION
665: WHEN FND_API.G_EXC_ERROR THEN
666: x_return_status := FND_API.G_RET_STS_ERROR;
667: WHEN OTHERS THEN
668: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: END UPDATE_RECIPE_HEADER;
671:
672:

Line 802: fnd_msg_pub.add;

798: END IF;
799: IF p_recipe_header_rec.recipe_id = FND_API.G_MISS_NUM THEN
800: fnd_message.set_name ('GMI', 'GMI_MISSING');
801: fnd_message.set_token ('MISSING', 'RECIPE_ID');
802: fnd_msg_pub.add;
803: RAISE copy_recipe_err;
804: ELSE
805: IF p_recipe_header_rec.recipe_id IS NULL THEN
806: -- Generate Recipe Id from sequence

Line 814: fnd_msg_pub.add;

810: ELSE -- Recipe id has been provided
811: -- Chcek if Recipe id is not a negative number
812: IF p_recipe_header_rec.recipe_id < 0 THEN
813: fnd_message.set_name('GMD', 'GMD_RECIPE_NOT_VALID');
814: fnd_msg_pub.add;
815: RAISE copy_recipe_err;
816: END IF;
817:
818: -- Check if this recipe id already exists in our system

Line 835: fnd_msg_pub.add;

831: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
832: l_recipe_header_rec.recipe_id := p_recipe_header_rec.recipe_id;
833: ELSE -- This is an invalid Recipe Id
834: fnd_message.set_name('GMD', 'GMD_RECIPE_NOT_VALID');
835: fnd_msg_pub.add;
836: RAISE copy_recipe_err;
837: END IF; -- End condition when x_ret_sts is error
838: END IF; -- End condition when recipe id is null
839: END IF; -- End condition when recipe id is G_miss...

Line 848: fnd_msg_pub.add;

844:
845: IF p_recipe_header_rec.recipe_no = FND_API.G_MISS_CHAR THEN
846: fnd_message.set_name ('GMI', 'GMI_MISSING');
847: fnd_message.set_token ('MISSING', 'RECIPE_NO');
848: fnd_msg_pub.add;
849: RAISE copy_recipe_err;
850: ELSE
851: IF p_recipe_header_rec.recipe_no IS NULL THEN
852: l_recipe_header_rec.recipe_no := old_recipe_rec.recipe_no;

Line 872: fnd_msg_pub.add;

868: l_recipe_header_rec.recipe_no := p_recipe_header_rec.recipe_no;
869: l_changed_flag := TRUE;
870: ELSE
871: fnd_message.set_name('GMD', 'GMD_RECIPE_NOT_VALID');
872: fnd_msg_pub.add;
873: RAISE copy_recipe_err;
874: END IF;
875: ELSE -- recipe_no value is same as that in db
876: l_recipe_header_rec.recipe_no := old_recipe_rec.recipe_no ;

Line 888: fnd_msg_pub.add;

884:
885: IF p_recipe_header_rec.recipe_version = FND_API.G_MISS_NUM THEN
886: fnd_message.set_name ('GMI', 'GMI_MISSING');
887: fnd_message.set_token ('MISSING', 'RECIPE_VERSION');
888: fnd_msg_pub.add;
889: RAISE copy_recipe_err;
890: ELSE
891: IF p_recipe_header_rec.recipe_version IS NULL THEN
892: l_recipe_header_rec.recipe_version

Line 915: fnd_msg_pub.add;

911: := p_recipe_header_rec.recipe_version;
912: l_changed_flag := TRUE;
913: ELSE
914: fnd_message.set_name('GMD', 'GMD_RECIPE_NOT_VALID');
915: fnd_msg_pub.add;
916: RAISE copy_recipe_err;
917: END IF;
918: ELSE -- recipe_version value is same as that in db
919: l_recipe_header_rec.recipe_version

Line 932: fnd_msg_pub.add;

928: INTO l_recipe_header_rec.recipe_version ;
929: IF get_next_recipe_version%NOTFOUND THEN
930: CLOSE get_next_recipe_version;
931: fnd_message.set_name('GMD', 'GMD_RECIPE_NOT_VALID');
932: fnd_msg_pub.add;
933: RAISE copy_recipe_err;
934: END IF;
935: CLOSE get_next_recipe_version;
936: END IF;

Line 946: fnd_msg_pub.add;

942: OR l_recipe_header_rec.recipe_version IS NULL
943: OR l_recipe_header_rec.recipe_id IS NULL) THEN
944: fnd_message.set_name ('GMI', 'GMI_MISSING');
945: fnd_message.set_token ('MISSING', 'RECIPE_NO OR RECIPE_VERSION OR RECIPE_ID');
946: fnd_msg_pub.add;
947: RAISE copy_recipe_err;
948: END IF;
949:
950: IF (l_debug = 'Y') THEN

Line 957: fnd_msg_pub.add;

953:
954: IF p_recipe_header_rec.recipe_description = FND_API.G_MISS_CHAR THEN
955: fnd_message.set_name ('GMI', 'GMI_MISSING');
956: fnd_message.set_token ('MISSING', 'RECIPE_DESCRIPTION');
957: fnd_msg_pub.add;
958: RAISE copy_recipe_err;
959: ELSE
960: IF p_recipe_header_rec.recipe_description IS NULL THEN
961: l_recipe_header_rec.recipe_description

Line 981: fnd_msg_pub.add;

977: END IF;
978: IF p_recipe_header_rec.user_id = FND_API.G_MISS_NUM THEN
979: fnd_message.set_name ('GMI', 'GMI_MISSING');
980: fnd_message.set_token ('MISSING', 'USER ID');
981: fnd_msg_pub.add;
982: RAISE copy_recipe_err;
983: ELSE
984: IF p_recipe_header_rec.user_id IS NULL THEN
985: IF p_recipe_header_rec.user_name IS NOT NULL THEN

Line 1001: fnd_msg_pub.add;

997:
998: IF p_recipe_header_rec.owner_organization_id = FND_API.G_MISS_NUM THEN
999: fnd_message.set_name ('GMI', 'GMI_MISSING');
1000: fnd_message.set_token ('MISSING', 'OWNER_ORGANIZATION_ID');
1001: fnd_msg_pub.add;
1002: RAISE copy_recipe_err;
1003: ELSE
1004: IF p_recipe_header_rec.owner_organization_id IS NULL THEN
1005: l_recipe_header_rec.owner_organization_id

Line 1018: FND_MSG_PUB.ADD;

1014:
1015: IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
1016: x_return_status := FND_API.G_RET_STS_ERROR;
1017: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
1018: FND_MSG_PUB.ADD;
1019: ELSE
1020: l_recipe_header_rec.owner_organization_id
1021: := p_recipe_header_rec.owner_organization_id;
1022: l_changed_flag := TRUE;

Line 1037: fnd_msg_pub.add;

1033: END IF;
1034: IF p_recipe_header_rec.creation_organization_id = FND_API.G_MISS_NUM THEN
1035: fnd_message.set_name ('GMI', 'GMI_MISSING');
1036: fnd_message.set_token ('MISSING', 'CREATION_ORGANIZATION_ID');
1037: fnd_msg_pub.add;
1038: RAISE copy_recipe_err;
1039: ELSE
1040: IF p_recipe_header_rec.creation_organization_id IS NULL THEN
1041: l_recipe_header_rec.creation_organization_id

Line 1054: FND_MSG_PUB.ADD;

1050:
1051: IF (l_out_rec.plant_ind <> 1 OR l_out_rec.lab_ind <> 1) THEN
1052: x_return_status := FND_API.G_RET_STS_ERROR;
1053: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_ORGN_INVALID');
1054: FND_MSG_PUB.ADD;
1055: ELSE
1056: l_recipe_header_rec.creation_organization_id
1057: := p_recipe_header_rec.creation_organization_id;
1058: l_changed_flag := TRUE;

Line 1073: fnd_msg_pub.add;

1069: END IF;
1070: IF p_recipe_header_rec.formula_id = FND_API.G_MISS_NUM THEN
1071: fnd_message.set_name ('GMI', 'GMI_MISSING');
1072: fnd_message.set_token ('MISSING', 'FORMULA_ID');
1073: fnd_msg_pub.add;
1074: RAISE copy_recipe_err;
1075: ELSE
1076: IF p_recipe_header_rec.formula_id IS NULL THEN
1077: /* Check if formula_no and vers is passed */

Line 1118: fnd_msg_pub.add;

1114: IF (p_recipe_header_rec.formula_no = FND_API.G_MISS_CHAR) OR
1115: (p_recipe_header_rec.formula_vers = FND_API.G_MISS_NUM) THEN
1116: fnd_message.set_name ('GMI', 'GMI_MISSING');
1117: fnd_message.set_token ('MISSING', 'FORMULA_NO OR VERS');
1118: fnd_msg_pub.add;
1119: RAISE copy_recipe_err;
1120: ELSE
1121: IF (l_recipe_header_rec.formula_id
1122: = p_recipe_header_rec.formula_id) AND

Line 1242: fnd_msg_pub.add;

1238: /* Recipe status should always be set to New */
1239: IF p_recipe_header_rec.recipe_status = FND_API.G_MISS_CHAR THEN
1240: fnd_message.set_name ('GMI', 'GMI_MISSING');
1241: fnd_message.set_token ('MISSING', 'RECIPE_STATUS');
1242: fnd_msg_pub.add;
1243: RAISE copy_recipe_err;
1244: ELSE
1245: l_recipe_header_rec.recipe_status := '100';
1246: END IF;

Line 1353: fnd_msg_pub.add;

1349: /* Delete Mark should always be set to 0 */
1350: IF p_recipe_header_rec.delete_mark = FND_API.G_MISS_NUM THEN
1351: fnd_message.set_name ('GMI', 'GMI_MISSING');
1352: fnd_message.set_token ('MISSING', 'DELETE_MARK');
1353: fnd_msg_pub.add;
1354: RAISE copy_recipe_err;
1355: ELSE
1356: l_recipe_header_rec.delete_mark := 0;
1357: END IF;

Line 1362: fnd_msg_pub.add;

1358:
1359: IF p_recipe_header_rec.creation_date = FND_API.G_MISS_DATE THEN
1360: fnd_message.set_name ('GMI', 'GMI_MISSING');
1361: fnd_message.set_token ('MISSING', 'CREATION_DATE');
1362: fnd_msg_pub.add;
1363: RAISE copy_recipe_err;
1364: ELSE
1365: IF p_recipe_header_rec.creation_date IS NULL THEN
1366: l_recipe_header_rec.creation_date

Line 1382: fnd_msg_pub.add;

1378:
1379: IF p_recipe_header_rec.created_by = FND_API.G_MISS_NUM THEN
1380: fnd_message.set_name ('GMI', 'GMI_MISSING');
1381: fnd_message.set_token ('MISSING', 'CREATED_BY');
1382: fnd_msg_pub.add;
1383: RAISE copy_recipe_err;
1384: ELSE
1385: IF p_recipe_header_rec.created_by IS NULL THEN
1386: l_recipe_header_rec.created_by

Line 1402: fnd_msg_pub.add;

1398:
1399: IF p_recipe_header_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1400: fnd_message.set_name ('GMI', 'GMI_MISSING');
1401: fnd_message.set_token ('MISSING', 'LAST_UPDATED_BY');
1402: fnd_msg_pub.add;
1403: RAISE copy_recipe_err;
1404: ELSE
1405: IF p_recipe_header_rec.last_updated_by IS NULL THEN
1406: l_recipe_header_rec.last_updated_by

Line 1422: fnd_msg_pub.add;

1418:
1419: IF p_recipe_header_rec.last_update_date = FND_API.G_MISS_DATE THEN
1420: fnd_message.set_name ('GMI', 'GMI_MISSING');
1421: fnd_message.set_token ('MISSING', 'LAST_UPDATE_DATE');
1422: fnd_msg_pub.add;
1423: RAISE copy_recipe_err;
1424: ELSE
1425: IF p_recipe_header_rec.last_update_date IS NULL THEN
1426: l_recipe_header_rec.last_update_date

Line 1459: fnd_msg_pub.add;

1455:
1456: IF p_recipe_header_rec.owner_id = FND_API.G_MISS_NUM THEN
1457: fnd_message.set_name ('GMI', 'GMI_MISSING');
1458: fnd_message.set_token ('MISSING', 'OWNER_ID');
1459: fnd_msg_pub.add;
1460: RAISE copy_recipe_err;
1461: ELSE
1462: IF p_recipe_header_rec.owner_id IS NULL THEN
1463: l_recipe_header_rec.owner_id

Line 2054: fnd_msg_pub.add;

2050: gmd_debug.put_line('Atleast one Recipe field should change ');
2051: END IF;
2052: fnd_message.set_name ('GMD', 'GMD_CANNOT_COPY');
2053: fnd_message.set_token ('ENTITY', 'recipe');
2054: fnd_msg_pub.add;
2055: RAISE copy_recipe_err;
2056: END IF; -- End condition when l_changed flag is TRUE
2057: END LOOP; -- End Loop condition for each recipe record passed IN
2058:

Line 2061: fnd_msg_pub.add;

2057: END LOOP; -- End Loop condition for each recipe record passed IN
2058:
2059: IF (l_rowcount = 0) THEN
2060: fnd_message.set_name ('GMD','GMD_RECIPE_DOES_NOT_EXIST');
2061: fnd_msg_pub.add;
2062: RAISE copy_recipe_err;
2063: END IF;
2064:
2065:

Line 2070: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);

2066: EXCEPTION
2067: WHEN copy_recipe_err THEN
2068: x_return_status := FND_API.G_RET_STS_ERROR;
2069: WHEN OTHERS THEN
2070: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2072: END COPY_RECIPE_HEADER;
2073:
2074: /* ================================================== */

Line 2123: FND_MSG_PUB.Add;

2119: IF (p_formula_no IS NULL) AND
2120: (p_formula_id IS NULL) THEN
2121: x_return_status := FND_API.G_RET_STS_ERROR;
2122: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_NO');
2123: FND_MSG_PUB.Add;
2124: ELSIF (p_formula_vers IS NULL) AND
2125: (p_formula_id IS NULL) THEN
2126: x_return_status := FND_API.G_RET_STS_ERROR;
2127: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');

Line 2128: FND_MSG_PUB.Add;

2124: ELSIF (p_formula_vers IS NULL) AND
2125: (p_formula_id IS NULL) THEN
2126: x_return_status := FND_API.G_RET_STS_ERROR;
2127: FND_MESSAGE.SET_NAME('GMD', 'FM_MISSING_FORMULA_VERS');
2128: FND_MSG_PUB.Add;
2129: ELSE
2130: x_return_status := FND_API.G_RET_STS_ERROR;
2131: IF p_formula_id IS NOT NULL THEN
2132: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVFORMULA_ID');

Line 2138: FND_MSG_PUB.Add;

2134: ELSE
2135: FND_MESSAGE.SET_NAME('GMD', 'FM_INVFORMULA_NO');
2136: FND_MESSAGE.SET_TOKEN('FORMULA_NO', p_formula_no);
2137: END IF;
2138: FND_MSG_PUB.Add;
2139: END IF;
2140: ELSE
2141: x_formula_id := l_fm_tab_out(1).formula_id;
2142: END IF;