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 621: FND_MSG_PUB.initialize;

617: END IF;
618:
619: /* Initialize message list if p_init_msg_list is set to TRUE */
620: IF FND_API.to_Boolean( p_init_msg_list ) THEN
621: FND_MSG_PUB.initialize;
622: END IF;
623:
624: /* Intialize the setup fields */
625: IF NOT gmd_api_grp.setup_done THEN

Line 669: FND_MSG_PUB.ADD;

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

Line 714: fnd_msg_pub.add;

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

Line 821: FND_MSG_PUB.Count_And_Get (

817: COMMIT;
818: END IF;
819:
820: /* Get the message count and information */
821: FND_MSG_PUB.Count_And_Get (
822: p_count => x_msg_count,
823: p_data => x_msg_data );
824:
825: EXCEPTION

Line 829: FND_MSG_PUB.Count_And_Get (

825: EXCEPTION
826: WHEN FND_API.G_EXC_ERROR THEN
827: ROLLBACK to Insert_Recipe_VR;
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: FND_MSG_PUB.Count_And_Get (
830: p_count => x_msg_count,
831: p_data => x_msg_data );
832:
833: WHEN setup_failure OR Recipe_VR_insert_failure THEN

Line 836: fnd_msg_pub.count_and_get (

832:
833: WHEN setup_failure OR Recipe_VR_insert_failure THEN
834: ROLLBACK to Insert_Recipe_VR;
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: fnd_msg_pub.count_and_get (
837: p_count => x_msg_count
838: ,p_encoded => FND_API.g_false
839: ,p_data => x_msg_data);
840:

Line 844: FND_MSG_PUB.Count_And_Get (

840:
841: WHEN default_status_err THEN
842: ROLLBACK TO default_status_sp;
843: x_return_status := FND_API.G_RET_STS_ERROR;
844: FND_MSG_PUB.Count_And_Get (
845: p_count => x_msg_count,
846: p_data => x_msg_data );
847:
848: WHEN OTHERS THEN

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

846: p_data => x_msg_data );
847:
848: WHEN OTHERS THEN
849: ROLLBACK to Insert_Recipe_VR;
850: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: FND_MSG_PUB.Count_And_Get (
853: p_count => x_msg_count,
854: p_data => x_msg_data );

Line 852: FND_MSG_PUB.Count_And_Get (

848: WHEN OTHERS THEN
849: ROLLBACK to Insert_Recipe_VR;
850: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: FND_MSG_PUB.Count_And_Get (
853: p_count => x_msg_count,
854: p_data => x_msg_data );
855:
856: END CREATE_RECIPE_VR;

Line 935: FND_MSG_PUB.initialize;

931: END IF;
932:
933: /* Initialize message list if p_init_msg_list is set to TRUE */
934: IF FND_API.to_Boolean( p_init_msg_list ) THEN
935: FND_MSG_PUB.initialize;
936: END IF;
937:
938: /* Intialize the setup fields */
939: IF NOT gmd_api_grp.setup_done THEN

Line 985: FND_MSG_PUB.ADD;

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

Line 1007: FND_MSG_PUB.ADD;

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

Line 1024: FND_MSG_PUB.ADD;

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:
1028: /* Insert into the recipe materials table */

Line 1045: FND_MSG_PUB.Count_And_Get (

1041: Commit;
1042: END IF;
1043:
1044: /* Get the message count and information */
1045: FND_MSG_PUB.Count_And_Get (
1046: p_count => x_msg_count,
1047: p_data => x_msg_data );
1048:
1049: EXCEPTION

Line 1053: FND_MSG_PUB.Count_And_Get (

1049: EXCEPTION
1050: WHEN FND_API.G_EXC_ERROR THEN
1051: ROLLBACK to Insert_Recipe_Materials;
1052: x_return_status := FND_API.G_RET_STS_ERROR;
1053: FND_MSG_PUB.Count_And_Get (
1054: p_count => x_msg_count,
1055: p_data => x_msg_data );
1056: WHEN setup_failure OR insert_rcp_mat_failure THEN
1057: ROLLBACK to Insert_Recipe_Materials;

Line 1059: fnd_msg_pub.count_and_get (

1055: p_data => x_msg_data );
1056: WHEN setup_failure OR insert_rcp_mat_failure THEN
1057: ROLLBACK to Insert_Recipe_Materials;
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: fnd_msg_pub.count_and_get (
1060: p_count => x_msg_count
1061: ,p_encoded => FND_API.g_false
1062: ,p_data => x_msg_data);
1063: WHEN OTHERS THEN

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

1061: ,p_encoded => FND_API.g_false
1062: ,p_data => x_msg_data);
1063: WHEN OTHERS THEN
1064: ROLLBACK to Insert_Recipe_Materials;
1065: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: FND_MSG_PUB.Count_And_Get (
1068: p_count => x_msg_count,
1069: p_data => x_msg_data );

Line 1067: FND_MSG_PUB.Count_And_Get (

1063: WHEN OTHERS THEN
1064: ROLLBACK to Insert_Recipe_Materials;
1065: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1066: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1067: FND_MSG_PUB.Count_And_Get (
1068: p_count => x_msg_count,
1069: p_data => x_msg_data );
1070:
1071: END CREATE_RECIPE_MTL;

Line 1154: FND_MSG_PUB.initialize;

1150: END IF;
1151:
1152: /* Initialize message list if p_init_msg_list is set to TRUE */
1153: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1154: FND_MSG_PUB.initialize;
1155: END IF;
1156:
1157: /* Intialize the setup fields */
1158: IF NOT gmd_api_grp.setup_done THEN

Line 1186: FND_MSG_PUB.ADD;

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

Line 1266: FND_MSG_PUB.Count_And_Get (

1262: Commit;
1263: END IF;
1264:
1265: /* Get the message count and information */
1266: FND_MSG_PUB.Count_And_Get (
1267: p_count => x_msg_count,
1268: p_data => x_msg_data );
1269:
1270: EXCEPTION

Line 1274: FND_MSG_PUB.Count_And_Get (

1270: EXCEPTION
1271: WHEN FND_API.G_EXC_ERROR THEN
1272: ROLLBACK to Update_Recipe_Process_loss;
1273: x_return_status := FND_API.G_RET_STS_ERROR;
1274: FND_MSG_PUB.Count_And_Get (
1275: p_count => x_msg_count,
1276: p_data => x_msg_data );
1277:
1278: WHEN setup_failure OR update_pr_loss_failure THEN

Line 1281: fnd_msg_pub.count_and_get (

1277:
1278: WHEN setup_failure OR update_pr_loss_failure THEN
1279: x_return_status := FND_API.G_RET_STS_ERROR;
1280: ROLLBACK to Update_Recipe_Process_loss;
1281: fnd_msg_pub.count_and_get (
1282: p_count => x_msg_count
1283: ,p_encoded => FND_API.g_false
1284: ,p_data => x_msg_data);
1285: WHEN OTHERS THEN

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

1283: ,p_encoded => FND_API.g_false
1284: ,p_data => x_msg_data);
1285: WHEN OTHERS THEN
1286: ROLLBACK to Update_Recipe_Process_loss;
1287: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1289: FND_MSG_PUB.Count_And_Get (
1290: p_count => x_msg_count,
1291: p_data => x_msg_data );

Line 1289: FND_MSG_PUB.Count_And_Get (

1285: WHEN OTHERS THEN
1286: ROLLBACK to Update_Recipe_Process_loss;
1287: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1289: FND_MSG_PUB.Count_And_Get (
1290: p_count => x_msg_count,
1291: p_data => x_msg_data );
1292:
1293: END UPDATE_RECIPE_PROCESS_LOSS;

Line 1382: FND_MSG_PUB.initialize;

1378: END IF;
1379:
1380: /* Initialize message list if p_init_msg_list is set to TRUE */
1381: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1382: FND_MSG_PUB.initialize;
1383: END IF;
1384:
1385: /* Intialize the setup fields */
1386: IF NOT gmd_api_grp.setup_done THEN

Line 1425: FND_MSG_PUB.ADD;

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

Line 1453: FND_MSG_PUB.ADD;

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

Line 1486: FND_MSG_PUB.Count_And_Get (

1482: Commit;
1483: END IF;
1484:
1485: /* Get the message count and information */
1486: FND_MSG_PUB.Count_And_Get (
1487: p_count => x_msg_count,
1488: p_data => x_msg_data );
1489:
1490: EXCEPTION

Line 1494: FND_MSG_PUB.Count_And_Get (

1490: EXCEPTION
1491: WHEN FND_API.G_EXC_ERROR THEN
1492: ROLLBACK to Update_Recipe_Customers;
1493: x_return_status := FND_API.G_RET_STS_ERROR;
1494: FND_MSG_PUB.Count_And_Get (
1495: p_count => x_msg_count,
1496: p_data => x_msg_data );
1497:
1498: WHEN setup_failure OR update_rcp_cust_failure THEN

Line 1501: fnd_msg_pub.count_and_get (

1497:
1498: WHEN setup_failure OR update_rcp_cust_failure THEN
1499: ROLLBACK to Update_Recipe_Customers;
1500: x_return_status := FND_API.G_RET_STS_ERROR;
1501: fnd_msg_pub.count_and_get (
1502: p_count => x_msg_count
1503: ,p_encoded => FND_API.g_false
1504: ,p_data => x_msg_data);
1505: WHEN OTHERS THEN

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

1503: ,p_encoded => FND_API.g_false
1504: ,p_data => x_msg_data);
1505: WHEN OTHERS THEN
1506: ROLLBACK to Update_Recipe_Customers;
1507: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1509: FND_MSG_PUB.Count_And_Get (
1510: p_count => x_msg_count,
1511: p_data => x_msg_data );

Line 1509: FND_MSG_PUB.Count_And_Get (

1505: WHEN OTHERS THEN
1506: ROLLBACK to Update_Recipe_Customers;
1507: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1509: FND_MSG_PUB.Count_And_Get (
1510: p_count => x_msg_count,
1511: p_data => x_msg_data );
1512:
1513: END UPDATE_RECIPE_CUSTOMERS;

Line 1621: FND_MSG_PUB.initialize;

1617: END IF;
1618:
1619: /* Initialize message list if p_init_msg_list is set to TRUE */
1620: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1621: FND_MSG_PUB.initialize;
1622: END IF;
1623:
1624: /* Intialize the setup fields */
1625: IF NOT gmd_api_grp.setup_done THEN

Line 1649: FND_MSG_PUB.ADD;

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:
1653: /* Thomas Daniel - Bug 2652200 */

Line 1713: FND_MSG_PUB.ADD;

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

Line 1928: FND_MSG_PUB.Count_And_Get (

1924: EXCEPTION
1925: WHEN Update_VR_Failure THEN
1926: x_return_status := FND_API.G_RET_STS_ERROR;
1927: /* Get the message count and information */
1928: FND_MSG_PUB.Count_And_Get (
1929: p_count => x_msg_count
1930: ,p_data => x_msg_data );
1931: END;
1932: END LOOP; -- Loops thro all VR that needs to be updated

Line 1944: FND_MSG_PUB.Count_And_Get (

1940: EXCEPTION
1941: WHEN FND_API.G_EXC_ERROR THEN
1942: ROLLBACK to Update_Recipe_VR;
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: FND_MSG_PUB.Count_And_Get (
1945: p_count => x_msg_count,
1946: p_data => x_msg_data );
1947: WHEN setup_failure THEN
1948: ROLLBACK to Update_Recipe_VR;

Line 1950: fnd_msg_pub.count_and_get (

1946: p_data => x_msg_data );
1947: WHEN setup_failure THEN
1948: ROLLBACK to Update_Recipe_VR;
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: fnd_msg_pub.count_and_get (
1951: p_count => x_msg_count
1952: ,p_encoded => FND_API.g_false
1953: ,p_data => x_msg_data);
1954: WHEN OTHERS THEN

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

1952: ,p_encoded => FND_API.g_false
1953: ,p_data => x_msg_data);
1954: WHEN OTHERS THEN
1955: ROLLBACK to Update_Recipe_VR;
1956: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1958: FND_MSG_PUB.Count_And_Get (
1959: p_count => x_msg_count,
1960: p_data => x_msg_data );

Line 1958: FND_MSG_PUB.Count_And_Get (

1954: WHEN OTHERS THEN
1955: ROLLBACK to Update_Recipe_VR;
1956: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
1957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1958: FND_MSG_PUB.Count_And_Get (
1959: p_count => x_msg_count,
1960: p_data => x_msg_data );
1961:
1962: END UPDATE_RECIPE_VR;

Line 2081: FND_MSG_PUB.initialize;

2077: END IF;
2078:
2079: /* Initialize message list if p_init_msg_list is set to TRUE */
2080: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2081: FND_MSG_PUB.initialize;
2082: END IF;
2083:
2084: /* Intialize the setup fields */
2085: IF NOT gmd_api_grp.setup_done THEN

Line 2126: FND_MSG_PUB.ADD;

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

Line 2143: FND_MSG_PUB.ADD;

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

Line 2409: FND_MSG_PUB.Count_And_Get (

2405: Commit;
2406: END IF;
2407:
2408: /* Get the message count and information */
2409: FND_MSG_PUB.Count_And_Get (
2410: p_count => x_msg_count,
2411: p_data => x_msg_data );
2412:
2413: EXCEPTION

Line 2417: FND_MSG_PUB.Count_And_Get (

2413: EXCEPTION
2414: WHEN FND_API.G_EXC_ERROR THEN
2415: ROLLBACK to Recipe_Routing_Steps;
2416: x_return_status := FND_API.G_RET_STS_ERROR;
2417: FND_MSG_PUB.Count_And_Get (
2418: p_count => x_msg_count,
2419: p_data => x_msg_data );
2420:
2421: WHEN setup_failure THEN

Line 2424: fnd_msg_pub.count_and_get (

2420:
2421: WHEN setup_failure THEN
2422: ROLLBACK to Recipe_Routing_Steps;
2423: x_return_status := FND_API.G_RET_STS_ERROR;
2424: fnd_msg_pub.count_and_get (
2425: p_count => x_msg_count
2426: ,p_encoded => FND_API.g_false
2427: ,p_data => x_msg_data);
2428: WHEN OTHERS THEN

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

2426: ,p_encoded => FND_API.g_false
2427: ,p_data => x_msg_data);
2428: WHEN OTHERS THEN
2429: ROLLBACK to Recipe_Routing_Steps;
2430: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2432: FND_MSG_PUB.Count_And_Get (
2433: p_count => x_msg_count,
2434: p_data => x_msg_data );

Line 2432: FND_MSG_PUB.Count_And_Get (

2428: WHEN OTHERS THEN
2429: ROLLBACK to Recipe_Routing_Steps;
2430: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2432: FND_MSG_PUB.Count_And_Get (
2433: p_count => x_msg_count,
2434: p_data => x_msg_data );
2435:
2436: END Recipe_Routing_Steps;

Line 2540: FND_MSG_PUB.initialize;

2536: END IF;
2537:
2538: /* Initialize message list if p_init_msg_list is set to TRUE */
2539: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2540: FND_MSG_PUB.initialize;
2541: END IF;
2542:
2543: /* Intialize the setup fields */
2544: IF NOT gmd_api_grp.setup_done THEN

Line 2584: FND_MSG_PUB.ADD;

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

Line 2604: FND_MSG_PUB.ADD;

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

Line 2613: FND_MSG_PUB.ADD;

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

Line 2854: FND_MSG_PUB.Count_And_Get (

2850: Commit;
2851: END IF;
2852:
2853: /* Get the message count and information */
2854: FND_MSG_PUB.Count_And_Get (
2855: p_count => x_msg_count,
2856: p_data => x_msg_data );
2857:
2858: EXCEPTION

Line 2862: FND_MSG_PUB.Count_And_Get (

2858: EXCEPTION
2859: WHEN FND_API.G_EXC_ERROR THEN
2860: ROLLBACK to Recipe_Orgn_Activities;
2861: x_return_status := FND_API.G_RET_STS_ERROR;
2862: FND_MSG_PUB.Count_And_Get (
2863: p_count => x_msg_count,
2864: p_data => x_msg_data );
2865:
2866: WHEN setup_failure THEN

Line 2868: fnd_msg_pub.count_and_get (

2864: p_data => x_msg_data );
2865:
2866: WHEN setup_failure THEN
2867: x_return_status := FND_API.G_RET_STS_ERROR;
2868: fnd_msg_pub.count_and_get (
2869: p_count => x_msg_count
2870: ,p_encoded => FND_API.g_false
2871: ,p_data => x_msg_data);
2872: WHEN OTHERS THEN

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

2870: ,p_encoded => FND_API.g_false
2871: ,p_data => x_msg_data);
2872: WHEN OTHERS THEN
2873: ROLLBACK to Recipe_Orgn_Activities;
2874: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2876: FND_MSG_PUB.Count_And_Get (
2877: p_count => x_msg_count,
2878: p_data => x_msg_data );

Line 2876: FND_MSG_PUB.Count_And_Get (

2872: WHEN OTHERS THEN
2873: ROLLBACK to Recipe_Orgn_Activities;
2874: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
2875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2876: FND_MSG_PUB.Count_And_Get (
2877: p_count => x_msg_count,
2878: p_data => x_msg_data );
2879:
2880: END RECIPE_ORGN_OPERATIONS;

Line 2997: FND_MSG_PUB.initialize;

2993: END IF;
2994:
2995: /* Initialize message list if p_init_msg_list is set to TRUE */
2996: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2997: FND_MSG_PUB.initialize;
2998: END IF;
2999:
3000: /* Intialize the setup fields */
3001: IF NOT gmd_api_grp.setup_done THEN

Line 3041: FND_MSG_PUB.ADD;

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

Line 3062: FND_MSG_PUB.ADD;

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

Line 3071: FND_MSG_PUB.ADD;

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

Line 3080: FND_MSG_PUB.ADD;

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,
3084: p_recipe_detail_rec.routingstep_id,

Line 3362: FND_MSG_PUB.Count_And_Get (

3358: Commit;
3359: END IF;
3360:
3361: /* Get the message count and information */
3362: FND_MSG_PUB.Count_And_Get (
3363: p_count => x_msg_count,
3364: p_data => x_msg_data );
3365:
3366: EXCEPTION

Line 3370: FND_MSG_PUB.Count_And_Get (

3366: EXCEPTION
3367: WHEN FND_API.G_EXC_ERROR THEN
3368: ROLLBACK to Recipe_Orgn_Resources;
3369: x_return_status := FND_API.G_RET_STS_ERROR;
3370: FND_MSG_PUB.Count_And_Get (
3371: p_count => x_msg_count,
3372: p_data => x_msg_data );
3373:
3374: WHEN setup_failure THEN

Line 3376: fnd_msg_pub.count_and_get (

3372: p_data => x_msg_data );
3373:
3374: WHEN setup_failure THEN
3375: x_return_status := FND_API.G_RET_STS_ERROR;
3376: fnd_msg_pub.count_and_get (
3377: p_count => x_msg_count
3378: ,p_encoded => FND_API.g_false
3379: ,p_data => x_msg_data);
3380:

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

3379: ,p_data => x_msg_data);
3380:
3381: WHEN OTHERS THEN
3382: ROLLBACK to Recipe_Orgn_Resources;
3383: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
3384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3385: FND_MSG_PUB.Count_And_Get (
3386: p_count => x_msg_count,
3387: p_data => x_msg_data );

Line 3385: FND_MSG_PUB.Count_And_Get (

3381: WHEN OTHERS THEN
3382: ROLLBACK to Recipe_Orgn_Resources;
3383: fnd_msg_pub.add_exc_msg (G_pkg_name, l_api_name);
3384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3385: FND_MSG_PUB.Count_And_Get (
3386: p_count => x_msg_count,
3387: p_data => x_msg_data );
3388:
3389: END RECIPE_ORGN_RESOURCES;