APPS.WMS_CONTAINER_GRP dependencies on FND_MSG_PUB

Line 51: fnd_msg_pub.add;

47: IF (l_debug = 1) THEN
48: mdebug('Organization is required, can not auto create LPN ');
49: END IF;
50: fnd_message.set_name('INV','INV_ORG_REQUIRED');
51: fnd_msg_pub.add;
52: RAISE fnd_api.g_exc_error;
53:
54: ELSIF p_gen_lpn_rec.quantity IS NULL THEN
55: IF (l_debug = 1) THEN

Line 59: fnd_msg_pub.add;

55: IF (l_debug = 1) THEN
56: mdebug('Quantity is required, can not auto create LPN ');
57: END IF;
58: fnd_message.set_name('WMS','WMS_QUANTITY_REQUIRED');
59: fnd_msg_pub.add;
60: RAISE fnd_api.g_exc_error;
61:
62: END IF;
63:

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

110:
111: EXCEPTION
112: WHEN FND_API.G_EXC_ERROR THEN
113: x_return_status := fnd_api.g_ret_sts_error;
114: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
115: IF (l_debug = 1) THEN
116: FOR i in 1..x_msg_count LOOP
117: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
118: END LOOP;

Line 117: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);

113: x_return_status := fnd_api.g_ret_sts_error;
114: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
115: IF (l_debug = 1) THEN
116: FOR i in 1..x_msg_count LOOP
117: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
118: END LOOP;
119: mdebug(l_api_name ||' SQL error: '|| SQLERRM(SQLCODE), G_ERROR);
120: mdebug('msg: '||l_msgdata, G_ERROR);
121: END IF;

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

120: mdebug('msg: '||l_msgdata, G_ERROR);
121: END IF;
122: WHEN OTHERS THEN
123: x_return_status := fnd_api.g_ret_sts_unexp_error;
124: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
125: IF (l_debug = 1) THEN
126: mdebug(l_api_name ||' SQL error: '|| SQLERRM(SQLCODE), G_ERROR);
127: END IF;
128:

Line 283: fnd_msg_pub.add;

279: IF (l_debug = 1) THEN
280: mdebug('Validation failed, can not proceed');
281: END IF;
282: fnd_message.set_name('WMS','WMS_LPN_PURGE_VALIDATION');
283: fnd_msg_pub.add;
284: RAISE FND_API.G_EXC_ERROR;
285: ELSE
286: -- Validation passed, call Purge_LPNs to delete LPNs
287: IF (l_debug = 1) THEN

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

305: END IF; -- End if of p_action
306: EXCEPTION
307: WHEN FND_API.G_EXC_ERROR THEN
308: x_return_status := fnd_api.g_ret_sts_error;
309: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
310: IF (l_debug = 1) THEN
311: FOR i in 1..x_msg_count LOOP
312: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
313: END LOOP;

Line 312: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);

308: x_return_status := fnd_api.g_ret_sts_error;
309: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
310: IF (l_debug = 1) THEN
311: FOR i in 1..x_msg_count LOOP
312: l_msgdata := substr(l_msgdata||' | '||substr(fnd_msg_pub.get(x_msg_count-i+1, 'F'), 0, 200),1,2000);
313: END LOOP;
314: mdebug(l_api_name ||' SQL error: '|| SQLERRM(SQLCODE), G_ERROR);
315: mdebug('msg: '||l_msgdata, G_ERROR);
316: END IF;

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

315: mdebug('msg: '||l_msgdata, G_ERROR);
316: END IF;
317: WHEN OTHERS THEN
318: x_return_status := fnd_api.g_ret_sts_unexp_error;
319: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
320: IF (l_debug = 1) THEN
321: mdebug(l_api_name ||' SQL error: '|| SQLERRM(SQLCODE), G_ERROR);
322: END IF;
323: