DBA Data[Home] [Help]

APPS.MTL_INV_UTIL_GRP dependencies on FND_MSG_PUB

Line 99: FND_MSG_PUB.initialize;

95: END IF;
96: --
97: -- Initialize message list if p_init_msg_list is set to true
98: IF FND_API.to_Boolean(p_init_msg_list) THEN
99: FND_MSG_PUB.initialize;
100: END IF;
101: --
102: */
103: -- Initialisize API return status to access

Line 140: FND_MSG_PUB.Count_And_Get

136: IF FND_API.to_Boolean(p_commit) THEN
137: COMMIT;
138: END IF;
139: -- Standard call to get message count and if count is 1, get message info
140: FND_MSG_PUB.Count_And_Get
141: (p_count => x_msg_count
142: , p_data => x_msg_data);
143: */
144: EXCEPTION

Line 151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

147: ROLLBACK TO Get_Item_Cost;
148: --
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: --
151: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
152: , p_data => x_msg_data);
153: --
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: --

Line 160: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

156: ROLLBACK TO Get_Item_Cost;
157: --
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: --
160: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
161: , p_data => x_msg_data);
162: --
163: WHEN OTHERS THEN
164: --

Line 169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

165: ROLLBACK TO Get_Item_Cost;
166: --
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: --
169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
170: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
171: END IF;
172: --
173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 170: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

166: --
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: --
169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
170: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
171: END IF;
172: --
173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
174: , p_data => x_msg_data);

Line 173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

169: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
170: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
171: END IF;
172: --
173: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
174: , p_data => x_msg_data);
175: END;
176: END;
177: --

Line 312: FND_MSG_PUB.initialize;

308: MDEBUG( 'Begin of Calculate_Systemquantity2');
309: END IF;
310: -- Initialize message list if p_init_msg_list is set to true
311: IF FND_API.to_Boolean(p_init_msg_list) THEN
312: FND_MSG_PUB.initialize;
313: END IF;
314:
315: --
316: IF (l_debug = 1) THEN

Line 387: FND_MSG_PUB.Count_And_Get

383: IF FND_API.to_Boolean(p_commit) THEN
384: COMMIT;
385: END IF;
386: -- Standard call to get message count and if count is 1, get message info
387: FND_MSG_PUB.Count_And_Get
388: (p_count => x_msg_count
389: , p_data => x_msg_data);
390: EXCEPTION
391: WHEN FND_API.G_EXC_ERROR THEN

Line 400: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

396: MDEBUG( 'Calc.sys : Exception Error ' || sqlerrm);
397: END IF;
398: x_return_status := FND_API.G_RET_STS_ERROR;
399: --
400: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
401: , p_data => x_msg_data);
402: --
403: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
404: --

Line 412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

408: MDEBUG( 'Calc.sys : Unexp Exception Error: '|| sqlerrm);
409: END IF;
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: --
412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
413: , p_data => x_msg_data);
414: --
415: WHEN OTHERS THEN
416: --

Line 424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

420: ROLLBACK TO Calculate_Systemquantity;
421: --
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: --
424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
425: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
426: END IF;
427: --
428: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

Line 425: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

421: --
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: --
424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
425: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
426: END IF;
427: --
428: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
429: , p_data => x_msg_data);

Line 428: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count

424: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
425: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
426: END IF;
427: --
428: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count
429: , p_data => x_msg_data);
430: END;
431: END;
432:

Line 601: fnd_msg_pub.initialize;

597:
598: -- Initialize message list if p_init_msg_list is set to true
599: IF fnd_api.to_boolean (p_init_msg_list)
600: THEN
601: fnd_msg_pub.initialize;
602: END IF;
603:
604: --
605: IF (l_debug = 1)

Line 711: fnd_msg_pub.count_and_get (p_count => x_msg_count,

707: COMMIT;
708: END IF;
709:
710: -- Standard call to get message count and if count is 1, get message info
711: fnd_msg_pub.count_and_get (p_count => x_msg_count,
712: p_data => x_msg_data);
713: EXCEPTION
714: WHEN fnd_api.g_exc_error
715: THEN

Line 727: fnd_msg_pub.count_and_get (p_count => x_msg_count,

723: END IF;
724:
725: x_return_status := fnd_api.g_ret_sts_error;
726: --
727: fnd_msg_pub.count_and_get (p_count => x_msg_count,
728: p_data => x_msg_data
729: );
730: --
731: WHEN fnd_api.g_exc_unexpected_error

Line 744: fnd_msg_pub.count_and_get (p_count => x_msg_count,

740: END IF;
741:
742: x_return_status := fnd_api.g_ret_sts_unexp_error;
743: --
744: fnd_msg_pub.count_and_get (p_count => x_msg_count,
745: p_data => x_msg_data
746: );
747: --
748: WHEN OTHERS

Line 761: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)

757: --
758: x_return_status := fnd_api.g_ret_sts_unexp_error;
759:
760: --
761: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
762: THEN
763: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
764: END IF;
765:

Line 763: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

759:
760: --
761: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
762: THEN
763: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
764: END IF;
765:
766: --
767: fnd_msg_pub.count_and_get (p_count => x_msg_count,

Line 767: fnd_msg_pub.count_and_get (p_count => x_msg_count,

763: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
764: END IF;
765:
766: --
767: fnd_msg_pub.count_and_get (p_count => x_msg_count,
768: p_data => x_msg_data
769: );
770: END;
771: END;

Line 1196: FND_MSG_PUB.ADD;

1192: IF (l_debug = 1) THEN
1193: mdebug('invalid lpn id');
1194: END IF;
1195: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LPN');
1196: FND_MSG_PUB.ADD;
1197: RAISE e_Invalid_Inputs;
1198: END IF;
1199: END IF;
1200:

Line 1226: FND_MSG_PUB.ADD;

1222: IF (l_debug = 1) THEN
1223: mdebug('invalid lot number');
1224: END IF;
1225: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_LOT');
1226: FND_MSG_PUB.ADD;
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;
1229: END IF;
1230: END IF;

Line 1243: FND_MSG_PUB.ADD;

1239: IF (l_debug = 1) THEN
1240: mdebug('invalid revision number');
1241: END IF;
1242: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_REVISION');
1243: FND_MSG_PUB.ADD;
1244: RAISE FND_API.G_EXC_ERROR;
1245: END IF;
1246: END IF;
1247: END IF;

Line 1257: FND_MSG_PUB.ADD;

1253: l_result := INV_Validate.validate_serial(l_serial, l_org, l_container_item,
1254: l_sub, l_lot, l_locator, p_revision);
1255: IF (l_result = INV_Validate.F) THEN
1256: FND_MESSAGE.SET_NAME('WMS', 'WMS_CONT_INVALID_SERIAL');
1257: FND_MSG_PUB.ADD;
1258: RAISE FND_API.G_EXC_ERROR;
1259: END IF;
1260: END IF;
1261: */

Line 1329: FND_MSG_PUB.Count_And_Get

1325: EXCEPTION
1326: WHEN e_Invalid_Inputs THEN
1327: ROLLBACK TO Get_LPN_Item_SysQty;
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: FND_MSG_PUB.Count_And_Get
1330: ( p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );
1333: IF (l_debug = 1) THEN

Line 1420: fnd_msg_pub.ADD;

1416: mdebug ('invalid lpn id');
1417: END IF;
1418:
1419: fnd_message.set_name ('WMS', 'WMS_CONT_INVALID_LPN');
1420: fnd_msg_pub.ADD;
1421: RAISE e_invalid_inputs;
1422: END IF;
1423: END IF;
1424:

Line 1521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1517: EXCEPTION
1518: WHEN e_invalid_inputs THEN
1519: ROLLBACK TO get_lpn_item_sysqty;
1520: x_return_status := fnd_api.g_ret_sts_error;
1521: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1522:
1523: IF (l_debug = 1) THEN
1524: mdebug ('Invalid Inputs');
1525: END IF;