APPS.WMS_SHIPPING_MESSAGES dependencies on FND_API

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

16:
17: PROCEDURE PROCESS_SHIPPING_WARNING_MSGS(x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2,
20: p_commit IN VARCHAR2 := FND_API.g_false,
21: p_api_version IN VARCHAR2 := 1.0,
22: x_shipping_msg_tab IN OUT NOCOPY WSH_INTEGRATION.MSG_TABLE ) IS
23: l_api_version CONSTANT NUMBER := 1.0;
24: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_SHIPPING_WARNING_MSGS';

Line 28: x_return_status := FND_API.G_RET_STS_SUCCESS;

24: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_SHIPPING_WARNING_MSGS';
25: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
26: BEGIN
27: -- Initialize return status to success
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: IF NOT FND_API.compatible_api_call(l_api_version,
31: p_api_version,
32: l_api_name,

Line 30: IF NOT FND_API.compatible_api_call(l_api_version,

26: BEGIN
27: -- Initialize return status to success
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: IF NOT FND_API.compatible_api_call(l_api_version,
31: p_api_version,
32: l_api_name,
33: G_PKG_NAME) THEN
34: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 34: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

30: IF NOT FND_API.compatible_api_call(l_api_version,
31: p_api_version,
32: l_api_name,
33: G_PKG_NAME) THEN
34: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
35: END IF;
36:
37: IF (x_shipping_msg_tab.COUNT <> 0) THEN
38: FOR i IN 1..x_shipping_msg_tab.COUNT

Line 68: IF fnd_api.to_boolean(p_commit) THEN

64: END IF;
65: END LOOP;
66: END IF;
67: -- Standard check of p_commit.
68: IF fnd_api.to_boolean(p_commit) THEN
69: COMMIT WORK;
70: END IF;
71:
72: EXCEPTION

Line 74: WHEN fnd_api.g_exc_error THEN

70: END IF;
71:
72: EXCEPTION
73:
74: WHEN fnd_api.g_exc_error THEN
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: fnd_msg_pub.count_and_get
77: ( p_encoded => FND_API.G_FALSE,
78: p_count => x_msg_count,

Line 75: x_return_status := FND_API.G_RET_STS_ERROR;

71:
72: EXCEPTION
73:
74: WHEN fnd_api.g_exc_error THEN
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: fnd_msg_pub.count_and_get
77: ( p_encoded => FND_API.G_FALSE,
78: p_count => x_msg_count,
79: p_data => x_msg_data

Line 77: ( p_encoded => FND_API.G_FALSE,

73:
74: WHEN fnd_api.g_exc_error THEN
75: x_return_status := FND_API.G_RET_STS_ERROR;
76: fnd_msg_pub.count_and_get
77: ( p_encoded => FND_API.G_FALSE,
78: p_count => x_msg_count,
79: p_data => x_msg_data
80: );
81: IF (l_debug = 1) THEN

Line 85: WHEN fnd_api.g_exc_unexpected_error THEN

81: IF (l_debug = 1) THEN
82: DEBUG('Error ! SQL Code : '||sqlcode);
83: END IF;
84:
85: WHEN fnd_api.g_exc_unexpected_error THEN
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: fnd_msg_pub.count_and_get
88: ( p_encoded => FND_API.G_FALSE,
89: p_count => x_msg_count,

Line 86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

82: DEBUG('Error ! SQL Code : '||sqlcode);
83: END IF;
84:
85: WHEN fnd_api.g_exc_unexpected_error THEN
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: fnd_msg_pub.count_and_get
88: ( p_encoded => FND_API.G_FALSE,
89: p_count => x_msg_count,
90: p_data => x_msg_data

Line 88: ( p_encoded => FND_API.G_FALSE,

84:
85: WHEN fnd_api.g_exc_unexpected_error THEN
86: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
87: fnd_msg_pub.count_and_get
88: ( p_encoded => FND_API.G_FALSE,
89: p_count => x_msg_count,
90: p_data => x_msg_data
91: );
92: IF (l_debug = 1) THEN

Line 96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

92: IF (l_debug = 1) THEN
93: DEBUG('Unknown Error ! SQL Code : '||sqlcode);
94: END IF;
95: WHEN others THEN
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
98: fnd_msg_pub.add_exc_msg
99: ( 'WMS_SHIPPING_MESSAGES',
100: 'PROCESS_SHIPPING_WARNING_MSGS'

Line 104: ( p_encoded => FND_API.G_FALSE,

100: 'PROCESS_SHIPPING_WARNING_MSGS'
101: );
102: END IF;
103: fnd_msg_pub.count_and_get
104: ( p_encoded => FND_API.G_FALSE,
105: p_count => x_msg_count,
106: p_data => x_msg_data
107: );
108: IF (l_debug = 1) THEN