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

Line 95: FND_MSG_PUB.initialize;

91: l_api_name, G_PKG_NAME) THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94: IF FND_API.to_Boolean(p_init_msg_list) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: IF (p_recipe_id IS NOT NULL) THEN

Line 104: FND_MSG_PUB.Add;

100: OPEN get_record_with_recipe_id(p_recipe_id);
101: FETCH get_record_with_recipe_id into x_recipe_id;
102: IF get_record_with_recipe_id%NOTFOUND THEN
103: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_VALID');
104: FND_MSG_PUB.Add;
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107: CLOSE get_record_with_recipe_id;
108: ELSE

Line 113: FND_MSG_PUB.Add;

109: OPEN get_record_without_recipe_id(p_recipe_no, p_recipe_version);
110: FETCH get_record_without_recipe_id into x_recipe_id;
111: IF get_record_without_recipe_id%NOTFOUND THEN
112: FND_MESSAGE.SET_NAME('GMD', 'GMD_RECIPE_NOT_VALID');
113: FND_MSG_PUB.Add;
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116: CLOSE get_record_without_recipe_id;
117: END IF;

Line 120: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

116: CLOSE get_record_without_recipe_id;
117: END IF;
118:
119: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
120: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: X_return_code := SQLCODE;

Line 126: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: X_return_code := SQLCODE;
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: X_return_code := SQLCODE;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 131: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: X_return_code := SQLCODE;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
132:
133: WHEN OTHERS THEN
134: X_return_code := SQLCODE;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 136: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

132:
133: WHEN OTHERS THEN
134: X_return_code := SQLCODE;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
137:
138: END recipe_exists;
139:
140: /* ************************************************************************** */

Line 182: FND_MSG_PUB.initialize;

178: l_api_name, G_PKG_NAME) THEN
179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
180: END IF;
181: IF FND_API.to_Boolean(p_init_msg_list) THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: OPEN get_record;

Line 206: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

202:
203: /* no standard check of p_commit because no insert/update/delete */
204:
205: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
206: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
207:
208: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN
210: X_return_code := SQLCODE;

Line 212: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

208: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN
210: X_return_code := SQLCODE;
211: x_return_status := FND_API.G_RET_STS_ERROR;
212: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: X_return_code := SQLCODE;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 217: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: X_return_code := SQLCODE;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
218:
219: WHEN OTHERS THEN
220: X_return_code := SQLCODE;
221: x_return_status := FND_API.G_RET_STS_ERROR;

Line 222: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

218:
219: WHEN OTHERS THEN
220: X_return_code := SQLCODE;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
223:
224: END recipe_name;
225:
226: /* **************************************************************************/

Line 267: FND_MSG_PUB.initialize;

263: l_api_name, G_PKG_NAME) THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266: IF FND_API.to_Boolean(p_init_msg_list) THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: OPEN get_new_id;

Line 277: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

273: CLOSE get_new_id;
274:
275: /* no standard check of p_commit because no insert/update/delete */
276: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
277: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
278:
279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: X_return_code := SQLCODE;

Line 283: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

279: EXCEPTION
280: WHEN FND_API.G_EXC_ERROR THEN
281: X_return_code := SQLCODE;
282: x_return_status := FND_API.G_RET_STS_ERROR;
283: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: X_return_code := SQLCODE;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

284:
285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: X_return_code := SQLCODE;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
289:
290: WHEN OTHERS THEN
291: X_return_code := SQLCODE;
292: x_return_status := FND_API.G_RET_STS_ERROR;

Line 293: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

289:
290: WHEN OTHERS THEN
291: X_return_code := SQLCODE;
292: x_return_status := FND_API.G_RET_STS_ERROR;
293: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
294:
295: END get_new_id;
296:
297:

Line 343: FND_MSG_PUB.initialize;

339: l_api_name, G_PKG_NAME) THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342: IF FND_API.to_Boolean(p_init_msg_list) THEN
343: FND_MSG_PUB.initialize;
344: END IF;
345: x_return_status := FND_API.G_RET_STS_SUCCESS;
346:
347: OPEN get_recipe_data;

Line 365: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

361: CLOSE get_recipe_data;
362:
363: /* no standard check of p_commit because no insert/update/delete */
364: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
365: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: X_return_code := SQLCODE;

Line 371: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: X_return_code := SQLCODE;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: X_return_code := SQLCODE;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 376: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: X_return_code := SQLCODE;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
377:
378: WHEN OTHERS THEN
379: X_return_code := SQLCODE;
380: x_return_status := FND_API.G_RET_STS_ERROR;

Line 381: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

377:
378: WHEN OTHERS THEN
379: X_return_code := SQLCODE;
380: x_return_status := FND_API.G_RET_STS_ERROR;
381: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
382:
383: END recipe_for_update;
384:
385:

Line 423: FND_MSG_PUB.initialize;

419: l_api_name, G_PKG_NAME) THEN
420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
421: END IF;
422: IF FND_API.to_Boolean(p_init_msg_list) THEN
423: FND_MSG_PUB.initialize;
424: END IF;
425: x_return_status := FND_API.G_RET_STS_SUCCESS;
426:
427: IF p_recipe_description IS NULL THEN

Line 433: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

429: END IF;
430:
431: /* no standard check of p_commit because no insert/update/delete */
432: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
433: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
434:
435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
437: X_return_code := SQLCODE;

Line 439: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
437: X_return_code := SQLCODE;
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
440:
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_return_code := SQLCODE;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 444: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

440:
441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
442: X_return_code := SQLCODE;
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
445:
446: WHEN OTHERS THEN
447: X_return_code := SQLCODE;
448: x_return_status := FND_API.G_RET_STS_ERROR;

Line 449: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

445:
446: WHEN OTHERS THEN
447: X_return_code := SQLCODE;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
450:
451: END recipe_description;
452:
453: /* **************************************************************************/

Line 513: FND_MSG_PUB.initialize;

509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: IF FND_API.to_Boolean(p_init_msg_list) THEN
513: FND_MSG_PUB.initialize;
514: END IF;
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: IF (p_required_ind = 'Y' and g_orgn_id is NULL) THEN

Line 547: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

543: END IF; /* end if orgn code is null or not */
544:
545: /* no standard check of p_commit because no insert/update/delete */
546: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
547: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
548:
549: EXCEPTION
550: WHEN FND_API.G_EXC_ERROR THEN
551: X_return_code := SQLCODE;

Line 553: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

549: EXCEPTION
550: WHEN FND_API.G_EXC_ERROR THEN
551: X_return_code := SQLCODE;
552: x_return_status := FND_API.G_RET_STS_ERROR;
553: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: X_return_code := SQLCODE;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 558: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: X_return_code := SQLCODE;
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
558: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
559:
560: WHEN OTHERS THEN
561: X_return_code := SQLCODE;
562: x_return_status := FND_API.G_RET_STS_ERROR;

Line 563: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

559:
560: WHEN OTHERS THEN
561: X_return_code := SQLCODE;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
564:
565: END recipe_orgn_code;
566:
567: /* **************************************************************************/

Line 613: FND_MSG_PUB.initialize;

609: l_api_name, G_PKG_NAME) THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611: END IF;
612: IF FND_API.to_Boolean(p_init_msg_list) THEN
613: FND_MSG_PUB.initialize;
614: END IF;
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: OPEN check_recipe_id;

Line 636: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

632: CLOSE check_recipe_id;
633:
634: /* no standard check of p_commit because no insert/update/delete */
635: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
636: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
637:
638: EXCEPTION
639: WHEN FND_API.G_EXC_ERROR THEN
640: X_return_code := SQLCODE;

Line 642: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

638: EXCEPTION
639: WHEN FND_API.G_EXC_ERROR THEN
640: X_return_code := SQLCODE;
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: X_return_code := SQLCODE;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 647: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: X_return_code := SQLCODE;
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
648:
649: WHEN OTHERS THEN
650: X_return_code := SQLCODE;
651: x_return_status := FND_API.G_RET_STS_ERROR;

Line 652: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

648:
649: WHEN OTHERS THEN
650: X_return_code := SQLCODE;
651: x_return_status := FND_API.G_RET_STS_ERROR;
652: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
653:
654: END process_loss_for_update;
655:
656: /* **************************************************************************/

Line 696: FND_MSG_PUB.initialize;

692: l_api_name, G_PKG_NAME) THEN
693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
694: END IF;
695: IF FND_API.to_Boolean(p_init_msg_list) THEN
696: FND_MSG_PUB.initialize;
697: END IF;
698: x_return_status := FND_API.G_RET_STS_SUCCESS;
699:
700: OPEN get_record;

Line 712: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

708:
709: /* no standard check of p_commit because no insert/update/delete */
710:
711: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
712: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
713:
714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR THEN
716: X_return_code := SQLCODE;

Line 718: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

714: EXCEPTION
715: WHEN FND_API.G_EXC_ERROR THEN
716: X_return_code := SQLCODE;
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: X_return_code := SQLCODE;
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 723: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

719:
720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
721: X_return_code := SQLCODE;
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
724:
725: WHEN OTHERS THEN
726: X_return_code := SQLCODE;
727: x_return_status := FND_API.G_RET_STS_ERROR;

Line 728: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

724:
725: WHEN OTHERS THEN
726: X_return_code := SQLCODE;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
729:
730: END recipe_cust_exists;
731:
732: /* **************************************************************************

Line 798: FND_MSG_PUB.ADD;

794: x_return_status := 'S';
795:
796: IF P_disp_start_date < P_routing_start_date THEN
797: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');
798: FND_MSG_PUB.ADD;
799: x_return_status := 'E';
800: END IF;
801:
802: EXCEPTION

Line 804: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

800: END IF;
801:
802: EXCEPTION
803: WHEN OTHERS THEN
804: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
805: x_return_status := FND_API.g_ret_sts_unexp_error;
806: END validate_start_date;
807:
808: /*#####################################################

Line 829: FND_MSG_PUB.ADD;

825: IF (P_end_date IS NOT NULL) AND
826: (P_routing_end_date IS NOT NULL) AND
827: (P_end_date > P_routing_end_date) THEN
828: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');
829: FND_MSG_PUB.ADD;
830: x_return_status := 'E';
831: END IF;
832:
833: -- Routing end date is finite but Vr end date is infinite

Line 837: FND_MSG_PUB.ADD;

833: -- Routing end date is finite but Vr end date is infinite
834: IF (P_routing_end_date IS NOT NULL) AND
835: (P_end_date IS NULL) THEN
836: FND_MESSAGE.SET_NAME('GMD','GMD_VALIDITY_DATE_IN_ROUT_DATE');
837: FND_MSG_PUB.ADD;
838: x_return_status := 'E';
839: END IF;
840:
841: EXCEPTION

Line 843: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

839: END IF;
840:
841: EXCEPTION
842: WHEN OTHERS THEN
843: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
844: x_return_status := FND_API.g_ret_sts_unexp_error;
845: END validate_end_date;
846:
847:

Line 867: FND_MSG_PUB.ADD;

863:
864: IF (P_end_date IS NOT NULL AND P_start_date IS NOT NULL) THEN
865: IF (P_end_date < P_start_date) THEN
866: FND_MESSAGE.SET_NAME('GMD', 'QC_MIN_MAX_DATE');
867: FND_MSG_PUB.ADD;
868: x_return_status := 'E';
869: END IF;
870: END IF;
871: EXCEPTION

Line 873: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

869: END IF;
870: END IF;
871: EXCEPTION
872: WHEN OTHERS THEN
873: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
874: x_return_status := FND_API.g_ret_sts_unexp_error;
875: END effective_dates;
876:
877: /*###################################################################

Line 901: FND_MSG_PUB.ADD;

897: OR P_std_qty > P_max_qty)
898: OR P_std_qty <= 0 THEN
899: IF P_std_qty <= 0 THEN
900: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_QTY');
901: FND_MSG_PUB.ADD;
902: x_return_status := 'E';
903: ELSE
904: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_RANGE');
905: FND_MSG_PUB.ADD;

Line 905: FND_MSG_PUB.ADD;

901: FND_MSG_PUB.ADD;
902: x_return_status := 'E';
903: ELSE
904: FND_MESSAGE.SET_NAME('GMD','FM_INV_STD_RANGE');
905: FND_MSG_PUB.ADD;
906: x_return_status := 'E';
907: END IF; -- end if std qty is the problem, or the range
908: END IF; -- end if std qty not within range
909: END IF; -- end if std qty is not null

Line 912: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

908: END IF; -- end if std qty not within range
909: END IF; -- end if std qty is not null
910: EXCEPTION
911: WHEN OTHERS THEN
912: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
913: x_return_status := FND_API.g_ret_sts_unexp_error;
914: END std_qty;
915:
916: /*#####################################################

Line 937: FND_MSG_PUB.ADD;

933: IF (P_max_qty < P_min_qty
934: OR P_min_qty < 0) THEN
935: IF P_min_qty < 0 THEN
936: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_QTY');
937: FND_MSG_PUB.ADD;
938: x_return_status := 'E';
939: ELSE
940: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_MAX');
941: FND_MSG_PUB.ADD;

Line 941: FND_MSG_PUB.ADD;

937: FND_MSG_PUB.ADD;
938: x_return_status := 'E';
939: ELSE
940: FND_MESSAGE.SET_NAME('GMD','FM_INV_MIN_MAX');
941: FND_MSG_PUB.ADD;
942: x_return_status := 'E';
943: END IF; -- end if qty is the problem, or the range
944: END IF; -- IF (P_max_qty < P_min_qty
945: END IF; -- IF P_max_qty IS NOT NULL

Line 948: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

944: END IF; -- IF (P_max_qty < P_min_qty
945: END IF; -- IF P_max_qty IS NOT NULL
946: EXCEPTION
947: WHEN OTHERS THEN
948: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
949: x_return_status := FND_API.g_ret_sts_unexp_error;
950: END max_qty;
951:
952:

Line 1006: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

1002: X_inv_min_qty := ROUND(X_inv_min_qty,5);
1003: X_inv_max_qty := ROUND(X_inv_max_qty,5);
1004: EXCEPTION
1005: WHEN OTHERS THEN
1006: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1007: x_return_status := FND_API.g_ret_sts_unexp_error;
1008: END calc_inv_qtys;
1009:
1010: /*#####################################################

Line 1073: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

1069: END IF;
1070: END IF;
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1074: x_return_status := FND_API.g_ret_sts_unexp_error;
1075: END calculate_process_loss;
1076:
1077: /*#####################################################

Line 1129: FND_MSG_PUB.ADD;

1125: BEGIN
1126: x_return_status := 'S';
1127: FOR VR_dup_rec IN Cur_check_dup_upd LOOP
1128: FND_MESSAGE.SET_NAME('GMD','GMD_DUP_VR_EXIST');
1129: FND_MSG_PUB.ADD;
1130: x_return_status := 'E';
1131: END LOOP;
1132: EXCEPTION
1133: WHEN OTHERS THEN

Line 1134: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);

1130: x_return_status := 'E';
1131: END LOOP;
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: fnd_msg_pub.add_exc_msg (m_pkg_name, l_api_name);
1135: x_return_status := FND_API.g_ret_sts_unexp_error;
1136: END check_for_duplicate;
1137:
1138: