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_MSG_PUB

Line 83: FND_MSG_PUB.initialize;

79: END IF;
80:
81: /* Initialize message list if p_init_msg_list is set to TRUE */
82: IF FND_API.to_Boolean( p_init_msg_list ) THEN
83: FND_MSG_PUB.initialize;
84: END IF;
85:
86: IF (p_recipe_detail_tbl.Count = 0) THEN
87: RAISE FND_API.G_EXC_ERROR;

Line 127: FND_MSG_PUB.ADD;

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;
131: END IF;

Line 145: FND_MSG_PUB.ADD;

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:
149: /* validate if the process loss orgn code is passed */

Line 153: FND_MSG_PUB.ADD;

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
157: IF NOT (gmd_api_grp.check_orgn_status(p_recipe_detail_rec.organization_id)) THEN

Line 160: FND_MSG_PUB.Add;

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;
164:

Line 192: FND_MSG_PUB.Count_And_Get (

188: Commit;
189: END IF;
190:
191: /* Get the message count and information */
192: FND_MSG_PUB.Count_And_Get (
193: p_count => x_msg_count,
194: p_data => x_msg_data );
195:
196: EXCEPTION

Line 200: FND_MSG_PUB.Count_And_Get (

196: EXCEPTION
197: WHEN FND_API.G_EXC_ERROR THEN
198: ROLLBACK to Insert_Recipe_Process_loss;
199: x_return_status := FND_API.G_RET_STS_ERROR;
200: FND_MSG_PUB.Count_And_Get (
201: p_count => x_msg_count,
202: p_data => x_msg_data );
203: WHEN recipe_pr_loss_ins_failure OR setup_failure THEN
204: ROLLBACK to Insert_Recipe_Process_loss;

Line 206: fnd_msg_pub.count_and_get (

202: p_data => x_msg_data );
203: WHEN recipe_pr_loss_ins_failure OR setup_failure THEN
204: ROLLBACK to Insert_Recipe_Process_loss;
205: x_return_status := FND_API.G_RET_STS_ERROR;
206: fnd_msg_pub.count_and_get (
207: p_count => x_msg_count
208: ,p_encoded => FND_API.g_false
209: ,p_data => x_msg_data);
210: WHEN OTHERS THEN

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

208: ,p_encoded => FND_API.g_false
209: ,p_data => x_msg_data);
210: WHEN OTHERS THEN
211: ROLLBACK to Insert_Recipe_Process_loss;
212: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: FND_MSG_PUB.Count_And_Get (
215: p_count => x_msg_count,
216: p_data => x_msg_data );

Line 214: FND_MSG_PUB.Count_And_Get (

210: WHEN OTHERS THEN
211: ROLLBACK to Insert_Recipe_Process_loss;
212: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
214: FND_MSG_PUB.Count_And_Get (
215: p_count => x_msg_count,
216: p_data => x_msg_data );
217:
218: END CREATE_RECIPE_PROCESS_LOSS;

Line 298: FND_MSG_PUB.initialize;

294: END IF;
295:
296: /* Initialize message list if p_init_msg_list is set to TRUE */
297: IF FND_API.to_Boolean( p_init_msg_list ) THEN
298: FND_MSG_PUB.initialize;
299: END IF;
300:
301: /* Intialize the setup fields */
302: IF NOT gmd_api_grp.setup_done THEN

Line 341: FND_MSG_PUB.ADD;

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;
345: END IF;

Line 369: FND_MSG_PUB.ADD;

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;
373: END IF;

Line 390: FND_MSG_PUB.ADD;

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;
394: END IF;

Line 411: FND_MSG_PUB.ADD;

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;
415: END IF;

Line 436: FND_MSG_PUB.ADD;

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:
440: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 455: FND_MSG_PUB.Count_And_Get (

451: Commit;
452: END IF;
453:
454: /* Get the message count and information */
455: FND_MSG_PUB.Count_And_Get (
456: p_count => x_msg_count,
457: p_data => x_msg_data );
458:
459:

Line 464: FND_MSG_PUB.Count_And_Get (

460: EXCEPTION
461: WHEN FND_API.G_EXC_ERROR THEN
462: ROLLBACK to Insert_Recipe_Customers;
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: FND_MSG_PUB.Count_And_Get (
465: p_count => x_msg_count,
466: p_data => x_msg_data );
467:
468: WHEN setup_failure OR Recipe_Cust_ins_failure THEN

Line 471: fnd_msg_pub.count_and_get (

467:
468: WHEN setup_failure OR Recipe_Cust_ins_failure THEN
469: ROLLBACK to Insert_Recipe_Customers;
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: fnd_msg_pub.count_and_get (
472: p_count => x_msg_count
473: ,p_encoded => FND_API.g_false
474: ,p_data => x_msg_data);
475: WHEN OTHERS THEN

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

473: ,p_encoded => FND_API.g_false
474: ,p_data => x_msg_data);
475: WHEN OTHERS THEN
476: ROLLBACK to Insert_Recipe_Customers;
477: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: FND_MSG_PUB.Count_And_Get (
480: p_count => x_msg_count,
481: p_data => x_msg_data );

Line 479: FND_MSG_PUB.Count_And_Get (

475: WHEN OTHERS THEN
476: ROLLBACK to Insert_Recipe_Customers;
477: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: FND_MSG_PUB.Count_And_Get (
480: p_count => x_msg_count,
481: p_data => x_msg_data );
482: END CREATE_RECIPE_CUSTOMERS;
483:

Line 629: FND_MSG_PUB.initialize;

625: END IF;
626:
627: /* Initialize message list if p_init_msg_list is set to TRUE */
628: IF FND_API.to_Boolean( p_init_msg_list ) THEN
629: FND_MSG_PUB.initialize;
630: END IF;
631:
632: /* Intialize the setup fields */
633: IF NOT gmd_api_grp.setup_done THEN

Line 677: FND_MSG_PUB.ADD;

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;
681: END IF;

Line 718: FND_MSG_PUB.ADD;

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;
722: END IF;

Line 736: fnd_msg_pub.add;

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;
740: END IF;

Line 843: FND_MSG_PUB.Count_And_Get (

839: COMMIT;
840: END IF;
841:
842: /* Get the message count and information */
843: FND_MSG_PUB.Count_And_Get (
844: p_count => x_msg_count,
845: p_data => x_msg_data );
846:
847: EXCEPTION

Line 851: FND_MSG_PUB.Count_And_Get (

847: EXCEPTION
848: WHEN FND_API.G_EXC_ERROR THEN
849: ROLLBACK to Insert_Recipe_VR;
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: FND_MSG_PUB.Count_And_Get (
852: p_count => x_msg_count,
853: p_data => x_msg_data );
854:
855: WHEN setup_failure OR Recipe_VR_insert_failure THEN

Line 858: fnd_msg_pub.count_and_get (

854:
855: WHEN setup_failure OR Recipe_VR_insert_failure THEN
856: ROLLBACK to Insert_Recipe_VR;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: fnd_msg_pub.count_and_get (
859: p_count => x_msg_count
860: ,p_encoded => FND_API.g_false
861: ,p_data => x_msg_data);
862:

Line 866: FND_MSG_PUB.Count_And_Get (

862:
863: WHEN default_status_err THEN
864: ROLLBACK TO default_status_sp;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: FND_MSG_PUB.Count_And_Get (
867: p_count => x_msg_count,
868: p_data => x_msg_data );
869:
870: --bug16072538

Line 874: FND_MSG_PUB.Count_And_Get (

870: --bug16072538
871: WHEN invalid_vr_detail_uom THEN
872: ROLLBACK to Insert_Recipe_VR;
873: x_return_status := FND_API.G_RET_STS_ERROR;
874: FND_MSG_PUB.Count_And_Get (
875: p_count => x_msg_count,
876: p_data => x_msg_data );
877:
878: WHEN OTHERS THEN

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

876: p_data => x_msg_data );
877:
878: WHEN OTHERS THEN
879: ROLLBACK to Insert_Recipe_VR;
880: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: FND_MSG_PUB.Count_And_Get (
883: p_count => x_msg_count,
884: p_data => x_msg_data );

Line 882: FND_MSG_PUB.Count_And_Get (

878: WHEN OTHERS THEN
879: ROLLBACK to Insert_Recipe_VR;
880: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
881: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
882: FND_MSG_PUB.Count_And_Get (
883: p_count => x_msg_count,
884: p_data => x_msg_data );
885:
886: END CREATE_RECIPE_VR;

Line 978: FND_MSG_PUB.initialize;

974: END IF;
975:
976: /* Initialize message list if p_init_msg_list is set to TRUE */
977: IF FND_API.to_Boolean( p_init_msg_list ) THEN
978: FND_MSG_PUB.initialize;
979: END IF;
980:
981: /* Intialize the setup fields */
982: IF NOT gmd_api_grp.setup_done THEN

Line 1028: FND_MSG_PUB.ADD;

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;
1032: END IF;

Line 1050: FND_MSG_PUB.ADD;

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:
1054: /* validate this routing step id */

Line 1067: FND_MSG_PUB.ADD;

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: /* ======================================= */
1071: /* Validations so as to insert minimum_transfer_qty,minimum_delay,maximum_delay. Bug : 10109808 */

Line 1086: FND_MSG_PUB.Add;

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:
1090:

Line 1094: FND_MSG_PUB.Add;

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:
1098: OPEN c_line_type (p_recipe_mtl_rec.formulaline_id);

Line 1130: FND_MSG_PUB.Count_And_Get (

1126: Commit;
1127: END IF;
1128:
1129: /* Get the message count and information */
1130: FND_MSG_PUB.Count_And_Get (
1131: p_count => x_msg_count,
1132: p_data => x_msg_data );
1133:
1134: EXCEPTION

Line 1138: FND_MSG_PUB.Count_And_Get (

1134: EXCEPTION
1135: WHEN FND_API.G_EXC_ERROR THEN
1136: ROLLBACK to Insert_Recipe_Materials;
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: FND_MSG_PUB.Count_And_Get (
1139: p_count => x_msg_count,
1140: p_data => x_msg_data );
1141: WHEN setup_failure OR insert_rcp_mat_failure THEN
1142: ROLLBACK to Insert_Recipe_Materials;

Line 1144: fnd_msg_pub.count_and_get (

1140: p_data => x_msg_data );
1141: WHEN setup_failure OR insert_rcp_mat_failure THEN
1142: ROLLBACK to Insert_Recipe_Materials;
1143: x_return_status := FND_API.G_RET_STS_ERROR;
1144: fnd_msg_pub.count_and_get (
1145: p_count => x_msg_count
1146: ,p_encoded => FND_API.g_false
1147: ,p_data => x_msg_data);
1148: WHEN negative_values_exception THEN

Line 1151: fnd_msg_pub.count_and_get (

1147: ,p_data => x_msg_data);
1148: WHEN negative_values_exception THEN
1149: ROLLBACK to Insert_Recipe_Materials;
1150: x_return_status := FND_API.G_RET_STS_ERROR;
1151: fnd_msg_pub.count_and_get (
1152: p_count => x_msg_count
1153: ,p_encoded => FND_API.g_false
1154: ,p_data => x_msg_data);
1155: WHEN undesired_values_exception THEN

Line 1158: fnd_msg_pub.count_and_get (

1154: ,p_data => x_msg_data);
1155: WHEN undesired_values_exception THEN
1156: ROLLBACK to Insert_Recipe_Materials;
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: fnd_msg_pub.count_and_get (
1159: p_count => x_msg_count
1160: ,p_encoded => FND_API.g_false
1161: ,p_data => x_msg_data);
1162: WHEN OTHERS THEN

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

1160: ,p_encoded => FND_API.g_false
1161: ,p_data => x_msg_data);
1162: WHEN OTHERS THEN
1163: ROLLBACK to Insert_Recipe_Materials;
1164: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: FND_MSG_PUB.Count_And_Get (
1167: p_count => x_msg_count,
1168: p_data => x_msg_data );

Line 1166: FND_MSG_PUB.Count_And_Get (

1162: WHEN OTHERS THEN
1163: ROLLBACK to Insert_Recipe_Materials;
1164: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1166: FND_MSG_PUB.Count_And_Get (
1167: p_count => x_msg_count,
1168: p_data => x_msg_data );
1169:
1170: END CREATE_RECIPE_MTL;

Line 1253: FND_MSG_PUB.initialize;

1249: END IF;
1250:
1251: /* Initialize message list if p_init_msg_list is set to TRUE */
1252: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1253: FND_MSG_PUB.initialize;
1254: END IF;
1255:
1256: /* Intialize the setup fields */
1257: IF NOT gmd_api_grp.setup_done THEN

Line 1285: FND_MSG_PUB.ADD;

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:
1289: /* ================================== */

Line 1365: FND_MSG_PUB.Count_And_Get (

1361: Commit;
1362: END IF;
1363:
1364: /* Get the message count and information */
1365: FND_MSG_PUB.Count_And_Get (
1366: p_count => x_msg_count,
1367: p_data => x_msg_data );
1368:
1369: EXCEPTION

Line 1373: FND_MSG_PUB.Count_And_Get (

1369: EXCEPTION
1370: WHEN FND_API.G_EXC_ERROR THEN
1371: ROLLBACK to Update_Recipe_Process_loss;
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: FND_MSG_PUB.Count_And_Get (
1374: p_count => x_msg_count,
1375: p_data => x_msg_data );
1376:
1377: WHEN setup_failure OR update_pr_loss_failure THEN

Line 1380: fnd_msg_pub.count_and_get (

1376:
1377: WHEN setup_failure OR update_pr_loss_failure THEN
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: ROLLBACK to Update_Recipe_Process_loss;
1380: fnd_msg_pub.count_and_get (
1381: p_count => x_msg_count
1382: ,p_encoded => FND_API.g_false
1383: ,p_data => x_msg_data);
1384: WHEN OTHERS THEN

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

1382: ,p_encoded => FND_API.g_false
1383: ,p_data => x_msg_data);
1384: WHEN OTHERS THEN
1385: ROLLBACK to Update_Recipe_Process_loss;
1386: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1388: FND_MSG_PUB.Count_And_Get (
1389: p_count => x_msg_count,
1390: p_data => x_msg_data );

Line 1388: FND_MSG_PUB.Count_And_Get (

1384: WHEN OTHERS THEN
1385: ROLLBACK to Update_Recipe_Process_loss;
1386: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1388: FND_MSG_PUB.Count_And_Get (
1389: p_count => x_msg_count,
1390: p_data => x_msg_data );
1391:
1392: END UPDATE_RECIPE_PROCESS_LOSS;

Line 1481: FND_MSG_PUB.initialize;

1477: END IF;
1478:
1479: /* Initialize message list if p_init_msg_list is set to TRUE */
1480: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1481: FND_MSG_PUB.initialize;
1482: END IF;
1483:
1484: /* Intialize the setup fields */
1485: IF NOT gmd_api_grp.setup_done THEN

Line 1524: FND_MSG_PUB.ADD;

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;
1528: END IF;

Line 1552: FND_MSG_PUB.ADD;

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;
1556: END IF;

Line 1585: FND_MSG_PUB.Count_And_Get (

1581: Commit;
1582: END IF;
1583:
1584: /* Get the message count and information */
1585: FND_MSG_PUB.Count_And_Get (
1586: p_count => x_msg_count,
1587: p_data => x_msg_data );
1588:
1589: EXCEPTION

Line 1593: FND_MSG_PUB.Count_And_Get (

1589: EXCEPTION
1590: WHEN FND_API.G_EXC_ERROR THEN
1591: ROLLBACK to Update_Recipe_Customers;
1592: x_return_status := FND_API.G_RET_STS_ERROR;
1593: FND_MSG_PUB.Count_And_Get (
1594: p_count => x_msg_count,
1595: p_data => x_msg_data );
1596:
1597: WHEN setup_failure OR update_rcp_cust_failure THEN

Line 1600: fnd_msg_pub.count_and_get (

1596:
1597: WHEN setup_failure OR update_rcp_cust_failure THEN
1598: ROLLBACK to Update_Recipe_Customers;
1599: x_return_status := FND_API.G_RET_STS_ERROR;
1600: fnd_msg_pub.count_and_get (
1601: p_count => x_msg_count
1602: ,p_encoded => FND_API.g_false
1603: ,p_data => x_msg_data);
1604: WHEN OTHERS THEN

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

1602: ,p_encoded => FND_API.g_false
1603: ,p_data => x_msg_data);
1604: WHEN OTHERS THEN
1605: ROLLBACK to Update_Recipe_Customers;
1606: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1608: FND_MSG_PUB.Count_And_Get (
1609: p_count => x_msg_count,
1610: p_data => x_msg_data );

Line 1608: FND_MSG_PUB.Count_And_Get (

1604: WHEN OTHERS THEN
1605: ROLLBACK to Update_Recipe_Customers;
1606: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1608: FND_MSG_PUB.Count_And_Get (
1609: p_count => x_msg_count,
1610: p_data => x_msg_data );
1611:
1612: END UPDATE_RECIPE_CUSTOMERS;

Line 1728: FND_MSG_PUB.initialize;

1724: END IF;
1725:
1726: /* Initialize message list if p_init_msg_list is set to TRUE */
1727: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1728: FND_MSG_PUB.initialize;
1729: END IF;
1730:
1731: /* Intialize the setup fields */
1732: IF NOT gmd_api_grp.setup_done THEN

Line 1756: FND_MSG_PUB.ADD;

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:
1760: -- bug16204615

Line 1768: FND_MSG_PUB.ADD;

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;
1772: END IF;

Line 1834: FND_MSG_PUB.ADD;

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;
1838: END IF;

Line 2049: FND_MSG_PUB.Count_And_Get (

2045: EXCEPTION
2046: WHEN Update_VR_Failure THEN
2047: x_return_status := FND_API.G_RET_STS_ERROR;
2048: /* Get the message count and information */
2049: FND_MSG_PUB.Count_And_Get (
2050: p_count => x_msg_count
2051: ,p_data => x_msg_data );
2052: -- bug16204615
2053: WHEN invalid_vr_detail_uom THEN

Line 2055: FND_MSG_PUB.Count_And_Get (

2051: ,p_data => x_msg_data );
2052: -- bug16204615
2053: WHEN invalid_vr_detail_uom THEN
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055: FND_MSG_PUB.Count_And_Get (
2056: p_count => x_msg_count,
2057: p_data => x_msg_data );
2058: END;
2059: END LOOP; -- Loops thro all VR that needs to be updated

Line 2071: FND_MSG_PUB.Count_And_Get (

2067: EXCEPTION
2068: WHEN FND_API.G_EXC_ERROR THEN
2069: ROLLBACK to Update_Recipe_VR;
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071: FND_MSG_PUB.Count_And_Get (
2072: p_count => x_msg_count,
2073: p_data => x_msg_data );
2074: WHEN setup_failure THEN
2075: ROLLBACK to Update_Recipe_VR;

Line 2077: fnd_msg_pub.count_and_get (

2073: p_data => x_msg_data );
2074: WHEN setup_failure THEN
2075: ROLLBACK to Update_Recipe_VR;
2076: x_return_status := FND_API.G_RET_STS_ERROR;
2077: fnd_msg_pub.count_and_get (
2078: p_count => x_msg_count
2079: ,p_encoded => FND_API.g_false
2080: ,p_data => x_msg_data);
2081: WHEN OTHERS THEN

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

2079: ,p_encoded => FND_API.g_false
2080: ,p_data => x_msg_data);
2081: WHEN OTHERS THEN
2082: ROLLBACK to Update_Recipe_VR;
2083: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2085: FND_MSG_PUB.Count_And_Get (
2086: p_count => x_msg_count,
2087: p_data => x_msg_data );

Line 2085: FND_MSG_PUB.Count_And_Get (

2081: WHEN OTHERS THEN
2082: ROLLBACK to Update_Recipe_VR;
2083: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2085: FND_MSG_PUB.Count_And_Get (
2086: p_count => x_msg_count,
2087: p_data => x_msg_data );
2088:
2089: END UPDATE_RECIPE_VR;

Line 2208: FND_MSG_PUB.initialize;

2204: END IF;
2205:
2206: /* Initialize message list if p_init_msg_list is set to TRUE */
2207: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2208: FND_MSG_PUB.initialize;
2209: END IF;
2210:
2211: /* Intialize the setup fields */
2212: IF NOT gmd_api_grp.setup_done THEN

Line 2253: FND_MSG_PUB.ADD;

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;
2257: END IF;

Line 2270: FND_MSG_PUB.ADD;

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
2274: p_flex_insert_rec := NULL;

Line 2536: FND_MSG_PUB.Count_And_Get (

2532: Commit;
2533: END IF;
2534:
2535: /* Get the message count and information */
2536: FND_MSG_PUB.Count_And_Get (
2537: p_count => x_msg_count,
2538: p_data => x_msg_data );
2539:
2540: EXCEPTION

Line 2544: FND_MSG_PUB.Count_And_Get (

2540: EXCEPTION
2541: WHEN FND_API.G_EXC_ERROR THEN
2542: ROLLBACK to Recipe_Routing_Steps;
2543: x_return_status := FND_API.G_RET_STS_ERROR;
2544: FND_MSG_PUB.Count_And_Get (
2545: p_count => x_msg_count,
2546: p_data => x_msg_data );
2547:
2548: WHEN setup_failure THEN

Line 2551: fnd_msg_pub.count_and_get (

2547:
2548: WHEN setup_failure THEN
2549: ROLLBACK to Recipe_Routing_Steps;
2550: x_return_status := FND_API.G_RET_STS_ERROR;
2551: fnd_msg_pub.count_and_get (
2552: p_count => x_msg_count
2553: ,p_encoded => FND_API.g_false
2554: ,p_data => x_msg_data);
2555: WHEN OTHERS THEN

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

2553: ,p_encoded => FND_API.g_false
2554: ,p_data => x_msg_data);
2555: WHEN OTHERS THEN
2556: ROLLBACK to Recipe_Routing_Steps;
2557: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2559: FND_MSG_PUB.Count_And_Get (
2560: p_count => x_msg_count,
2561: p_data => x_msg_data );

Line 2559: FND_MSG_PUB.Count_And_Get (

2555: WHEN OTHERS THEN
2556: ROLLBACK to Recipe_Routing_Steps;
2557: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2559: FND_MSG_PUB.Count_And_Get (
2560: p_count => x_msg_count,
2561: p_data => x_msg_data );
2562:
2563: END Recipe_Routing_Steps;

Line 2667: FND_MSG_PUB.initialize;

2663: END IF;
2664:
2665: /* Initialize message list if p_init_msg_list is set to TRUE */
2666: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2667: FND_MSG_PUB.initialize;
2668: END IF;
2669:
2670: /* Intialize the setup fields */
2671: IF NOT gmd_api_grp.setup_done THEN

Line 2711: FND_MSG_PUB.ADD;

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;
2715: END IF;

Line 2731: FND_MSG_PUB.ADD;

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: /* ==================================== */
2735: /* Check if a valid oprn line id exists */

Line 2740: FND_MSG_PUB.ADD;

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 */
2744: IF (p_recipe_insert_flex.count = 0) THEN

Line 2981: FND_MSG_PUB.Count_And_Get (

2977: Commit;
2978: END IF;
2979:
2980: /* Get the message count and information */
2981: FND_MSG_PUB.Count_And_Get (
2982: p_count => x_msg_count,
2983: p_data => x_msg_data );
2984:
2985: EXCEPTION

Line 2989: FND_MSG_PUB.Count_And_Get (

2985: EXCEPTION
2986: WHEN FND_API.G_EXC_ERROR THEN
2987: ROLLBACK to Recipe_Orgn_Activities;
2988: x_return_status := FND_API.G_RET_STS_ERROR;
2989: FND_MSG_PUB.Count_And_Get (
2990: p_count => x_msg_count,
2991: p_data => x_msg_data );
2992:
2993: WHEN setup_failure THEN

Line 2995: fnd_msg_pub.count_and_get (

2991: p_data => x_msg_data );
2992:
2993: WHEN setup_failure THEN
2994: x_return_status := FND_API.G_RET_STS_ERROR;
2995: fnd_msg_pub.count_and_get (
2996: p_count => x_msg_count
2997: ,p_encoded => FND_API.g_false
2998: ,p_data => x_msg_data);
2999: WHEN OTHERS THEN

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

2997: ,p_encoded => FND_API.g_false
2998: ,p_data => x_msg_data);
2999: WHEN OTHERS THEN
3000: ROLLBACK to Recipe_Orgn_Activities;
3001: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
3002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3003: FND_MSG_PUB.Count_And_Get (
3004: p_count => x_msg_count,
3005: p_data => x_msg_data );

Line 3003: FND_MSG_PUB.Count_And_Get (

2999: WHEN OTHERS THEN
3000: ROLLBACK to Recipe_Orgn_Activities;
3001: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
3002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3003: FND_MSG_PUB.Count_And_Get (
3004: p_count => x_msg_count,
3005: p_data => x_msg_data );
3006:
3007: END RECIPE_ORGN_OPERATIONS;

Line 3139: FND_MSG_PUB.initialize;

3135: END IF;
3136:
3137: /* Initialize message list if p_init_msg_list is set to TRUE */
3138: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3139: FND_MSG_PUB.initialize;
3140: END IF;
3141:
3142: /* Intialize the setup fields */
3143: IF NOT gmd_api_grp.setup_done THEN

Line 3183: FND_MSG_PUB.ADD;

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;
3187: END IF;

Line 3204: FND_MSG_PUB.ADD;

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: /* ==================================== */
3208: /* Check if a valid oprn line id exists */

Line 3213: FND_MSG_PUB.ADD;

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: /* ===================================== */
3217: /* Check if a valid resource exists */

Line 3222: FND_MSG_PUB.ADD;

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:
3226: /* Bug No.6339150 - Start */

Line 3240: FND_MSG_PUB.ADD;

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 */
3244:

Line 3525: FND_MSG_PUB.Count_And_Get (

3521: Commit;
3522: END IF;
3523:
3524: /* Get the message count and information */
3525: FND_MSG_PUB.Count_And_Get (
3526: p_count => x_msg_count,
3527: p_data => x_msg_data );
3528:
3529: EXCEPTION

Line 3533: FND_MSG_PUB.Count_And_Get (

3529: EXCEPTION
3530: WHEN FND_API.G_EXC_ERROR THEN
3531: ROLLBACK to Recipe_Orgn_Resources;
3532: x_return_status := FND_API.G_RET_STS_ERROR;
3533: FND_MSG_PUB.Count_And_Get (
3534: p_count => x_msg_count,
3535: p_data => x_msg_data );
3536:
3537: WHEN setup_failure THEN

Line 3539: fnd_msg_pub.count_and_get (

3535: p_data => x_msg_data );
3536:
3537: WHEN setup_failure THEN
3538: x_return_status := FND_API.G_RET_STS_ERROR;
3539: fnd_msg_pub.count_and_get (
3540: p_count => x_msg_count
3541: ,p_encoded => FND_API.g_false
3542: ,p_data => x_msg_data);
3543:

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

3542: ,p_data => x_msg_data);
3543:
3544: WHEN OTHERS THEN
3545: ROLLBACK to Recipe_Orgn_Resources;
3546: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
3547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3548: FND_MSG_PUB.Count_And_Get (
3549: p_count => x_msg_count,
3550: p_data => x_msg_data );

Line 3548: FND_MSG_PUB.Count_And_Get (

3544: WHEN OTHERS THEN
3545: ROLLBACK to Recipe_Orgn_Resources;
3546: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
3547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3548: FND_MSG_PUB.Count_And_Get (
3549: p_count => x_msg_count,
3550: p_data => x_msg_data );
3551:
3552: END RECIPE_ORGN_RESOURCES;