APPS.WMS_SHIPPING_PUB dependencies on FND_API

Line 21: p_commit IN VARCHAR2 := FND_API.g_false,

17:
18: PROCEDURE DEL_WSTT_RECS_BY_DELIVERY_ID (x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
23: p_api_version IN NUMBER := 1.0, --3555636 changed from varchar2 to number
24: p_delivery_ids IN wsh_util_core.id_tab_type
25: )

Line 22: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

18: PROCEDURE DEL_WSTT_RECS_BY_DELIVERY_ID (x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: p_commit IN VARCHAR2 := FND_API.g_false,
22: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
23: p_api_version IN NUMBER := 1.0, --3555636 changed from varchar2 to number
24: p_delivery_ids IN wsh_util_core.id_tab_type
25: )
26: IS

Line 54: x_return_status := FND_API.G_RET_STS_SUCCESS;

50: BEGIN
51: IF (l_debug = 1) THEN debug('IN ... DEL_WSTT_RECS_BY_DELIVERY_ID ' ); END IF;
52:
53: -- Initialize return status to success
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: IF NOT FND_API.compatible_api_call(l_api_version,
57: p_api_version,
58: l_api_name,

Line 56: IF NOT FND_API.compatible_api_call(l_api_version,

52:
53: -- Initialize return status to success
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: IF NOT FND_API.compatible_api_call(l_api_version,
57: p_api_version,
58: l_api_name,
59: G_PKG_NAME) THEN
60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

56: IF NOT FND_API.compatible_api_call(l_api_version,
57: p_api_version,
58: l_api_name,
59: G_PKG_NAME) THEN
60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
61: END IF;
62:
63: -- Initialize message list.
64: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 64: IF fnd_api.to_boolean(p_init_msg_list) THEN

60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
61: END IF;
62:
63: -- Initialize message list.
64: IF fnd_api.to_boolean(p_init_msg_list) THEN
65: fnd_msg_pub.initialize;
66: END IF;
67:
68: SAVEPOINT DEL_WSTT_RECS_BY_DELIVERY_ID;

Line 234: IF fnd_api.to_boolean(p_commit) THEN

230: END LOOP;
231: END IF;
232:
233: -- Standard check of p_commit.
234: IF fnd_api.to_boolean(p_commit) THEN
235: COMMIT WORK;
236: END IF;
237:
238: IF (l_debug = 1) THEN debug('OUT ... DEL_WSTT_RECS_BY_DELIVERY_ID ' ); END IF;

Line 240: WHEN fnd_api.g_exc_error THEN

236: END IF;
237:
238: IF (l_debug = 1) THEN debug('OUT ... DEL_WSTT_RECS_BY_DELIVERY_ID ' ); END IF;
239: EXCEPTION
240: WHEN fnd_api.g_exc_error THEN
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: ROLLBACK to DEL_WSTT_RECS_BY_DELIVERY_ID;
243: fnd_msg_pub.count_and_get
244: ( p_encoded => FND_API.G_FALSE,

Line 241: x_return_status := FND_API.G_RET_STS_ERROR;

237:
238: IF (l_debug = 1) THEN debug('OUT ... DEL_WSTT_RECS_BY_DELIVERY_ID ' ); END IF;
239: EXCEPTION
240: WHEN fnd_api.g_exc_error THEN
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: ROLLBACK to DEL_WSTT_RECS_BY_DELIVERY_ID;
243: fnd_msg_pub.count_and_get
244: ( p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,

Line 244: ( p_encoded => FND_API.G_FALSE,

240: WHEN fnd_api.g_exc_error THEN
241: x_return_status := FND_API.G_RET_STS_ERROR;
242: ROLLBACK to DEL_WSTT_RECS_BY_DELIVERY_ID;
243: fnd_msg_pub.count_and_get
244: ( p_encoded => FND_API.G_FALSE,
245: p_count => x_msg_count,
246: p_data => x_msg_data
247: );
248: IF (l_debug = 1) THEN

Line 252: WHEN fnd_api.g_exc_unexpected_error THEN

248: IF (l_debug = 1) THEN
249: DEBUG('Error ! SQL Code : '||sqlcode);
250: END IF;
251:
252: WHEN fnd_api.g_exc_unexpected_error THEN
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: ROLLBACK to DEL_WSTT_RECS_BY_DELIVERY_ID;
255: fnd_msg_pub.count_and_get
256: ( p_encoded => FND_API.G_FALSE,

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

249: DEBUG('Error ! SQL Code : '||sqlcode);
250: END IF;
251:
252: WHEN fnd_api.g_exc_unexpected_error THEN
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: ROLLBACK to DEL_WSTT_RECS_BY_DELIVERY_ID;
255: fnd_msg_pub.count_and_get
256: ( p_encoded => FND_API.G_FALSE,
257: p_count => x_msg_count,

Line 256: ( p_encoded => FND_API.G_FALSE,

252: WHEN fnd_api.g_exc_unexpected_error THEN
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: ROLLBACK to DEL_WSTT_RECS_BY_DELIVERY_ID;
255: fnd_msg_pub.count_and_get
256: ( p_encoded => FND_API.G_FALSE,
257: p_count => x_msg_count,
258: p_data => x_msg_data
259: );
260: IF (l_debug = 1) THEN

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: DEBUG('Unknown Error ! SQL Code : '||sqlcode);
262: END IF;
263:
264: WHEN others THEN
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: ROLLBACK TO DEL_WSTT_RECS_BY_DELIVERY_ID;
267: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
268: fnd_msg_pub.add_exc_msg
269: ( 'WMS_SHIPPING_PUB',

Line 274: ( p_encoded => FND_API.G_FALSE,

270: 'DEL_WSTT_RECS_BY_DELIVERY_ID'
271: );
272: END IF;
273: fnd_msg_pub.count_and_get
274: ( p_encoded => FND_API.G_FALSE,
275: p_count => x_msg_count,
276: p_data => x_msg_data
277: );
278: IF (l_debug = 1) THEN