DBA Data[Home] [Help]

APPS.CSP_INV_LOC_ASSIGNMENTS_CUHK dependencies on FND_API

Line 21: x_return_status := fnd_api.g_ret_sts_success;

17: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
18: BEGIN
19: Savepoint csp_inv_loc_assignments_cuhk;
20:
21: x_return_status := fnd_api.g_ret_sts_success;
22: NULL;
23: -- Standard call to get message count and if count is 1, get message info
24: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
25: p_data => x_msg_data );

Line 28: WHEN FND_API.G_EXC_ERROR THEN

24: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
25: p_data => x_msg_data );
26:
27: EXCEPTION
28: WHEN FND_API.G_EXC_ERROR THEN
29: ROLLBACK TO csp_inv_loc_assignments_cuhk;
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MSG_PUB.Count_And_Get
32: ( p_count => x_msg_count,

Line 30: x_return_status := FND_API.G_RET_STS_ERROR;

26:
27: EXCEPTION
28: WHEN FND_API.G_EXC_ERROR THEN
29: ROLLBACK TO csp_inv_loc_assignments_cuhk;
30: x_return_status := FND_API.G_RET_STS_ERROR;
31: FND_MSG_PUB.Count_And_Get
32: ( p_count => x_msg_count,
33: p_data => x_msg_data );
34: WHEN OTHERS THEN

Line 36: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

32: ( p_count => x_msg_count,
33: p_data => x_msg_data );
34: WHEN OTHERS THEN
35: ROLLBACK TO csp_inv_loc_assignments_cuhk;
36: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
37: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
38: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
39: END IF;
40: FND_MSG_PUB.Count_And_Get

Line 59: x_return_status := fnd_api.g_ret_sts_success;

55: l_api_name varchar2(200) := 'create_inventory_location_Post' ;
56: BEGIN
57: Savepoint csp_inv_loc_assignments_cuhk;
58:
59: x_return_status := fnd_api.g_ret_sts_success;
60: NULL;
61: -- Standard call to get message count and if count is 1, get message info
62: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
63: p_data => x_msg_data );

Line 66: WHEN FND_API.G_EXC_ERROR THEN

62: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
63: p_data => x_msg_data );
64:
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO csp_inv_loc_assignments_cuhk;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: FND_MSG_PUB.Count_And_Get
70: ( p_count => x_msg_count,

Line 68: x_return_status := FND_API.G_RET_STS_ERROR;

64:
65: EXCEPTION
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO csp_inv_loc_assignments_cuhk;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: FND_MSG_PUB.Count_And_Get
70: ( p_count => x_msg_count,
71: p_data => x_msg_data );
72: WHEN OTHERS THEN

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

70: ( p_count => x_msg_count,
71: p_data => x_msg_data );
72: WHEN OTHERS THEN
73: ROLLBACK TO csp_inv_loc_assignments_cuhk;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
76: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
77: END IF;
78: FND_MSG_PUB.Count_And_Get

Line 97: x_return_status := fnd_api.g_ret_sts_success;

93: l_api_name varchar2(200) := 'Update_inventory_location_Pre' ;
94: BEGIN
95: Savepoint csp_inv_loc_assignments_cuhk;
96:
97: x_return_status := fnd_api.g_ret_sts_success;
98: NULL;
99: -- Standard call to get message count and if count is 1, get message info
100: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
101: p_data => x_msg_data );

Line 104: WHEN FND_API.G_EXC_ERROR THEN

100: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
101: p_data => x_msg_data );
102:
103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN
105: ROLLBACK TO csp_inv_loc_assignments_cuhk;
106: x_return_status := FND_API.G_RET_STS_ERROR;
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => x_msg_count,

Line 106: x_return_status := FND_API.G_RET_STS_ERROR;

102:
103: EXCEPTION
104: WHEN FND_API.G_EXC_ERROR THEN
105: ROLLBACK TO csp_inv_loc_assignments_cuhk;
106: x_return_status := FND_API.G_RET_STS_ERROR;
107: FND_MSG_PUB.Count_And_Get
108: ( p_count => x_msg_count,
109: p_data => x_msg_data );
110: WHEN OTHERS THEN

Line 112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

108: ( p_count => x_msg_count,
109: p_data => x_msg_data );
110: WHEN OTHERS THEN
111: ROLLBACK TO csp_inv_loc_assignments_cuhk;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
114: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
115: END IF;
116: FND_MSG_PUB.Count_And_Get

Line 134: x_return_status := fnd_api.g_ret_sts_success;

130: l_api_name varchar2(200) := 'Update_inventory_location_post' ;
131: BEGIN
132: Savepoint csp_inv_loc_assignments_cuhk;
133:
134: x_return_status := fnd_api.g_ret_sts_success;
135: NULL;
136: -- Standard call to get message count and if count is 1, get message info
137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
138: p_data => x_msg_data );

Line 141: WHEN FND_API.G_EXC_ERROR THEN

137: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
138: p_data => x_msg_data );
139:
140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN
142: ROLLBACK TO csp_inv_loc_assignments_cuhk;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MSG_PUB.Count_And_Get
145: ( p_count => x_msg_count,

Line 143: x_return_status := FND_API.G_RET_STS_ERROR;

139:
140: EXCEPTION
141: WHEN FND_API.G_EXC_ERROR THEN
142: ROLLBACK TO csp_inv_loc_assignments_cuhk;
143: x_return_status := FND_API.G_RET_STS_ERROR;
144: FND_MSG_PUB.Count_And_Get
145: ( p_count => x_msg_count,
146: p_data => x_msg_data );
147: WHEN OTHERS THEN

Line 149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

145: ( p_count => x_msg_count,
146: p_data => x_msg_data );
147: WHEN OTHERS THEN
148: ROLLBACK TO csp_inv_loc_assignments_cuhk;
149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
151: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
152: END IF;
153: FND_MSG_PUB.Count_And_Get

Line 169: x_return_status := fnd_api.g_ret_sts_success;

165: l_api_name varchar2(200) := 'Delete_inventory_location_Pre' ;
166: BEGIN
167: Savepoint csp_inv_loc_assignments_cuhk;
168:
169: x_return_status := fnd_api.g_ret_sts_success;
170: NULL;
171: -- Standard call to get message count and if count is 1, get message info
172: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
173: p_data => x_msg_data );

Line 176: WHEN FND_API.G_EXC_ERROR THEN

172: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
173: p_data => x_msg_data );
174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO csp_inv_loc_assignments_cuhk;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: FND_MSG_PUB.Count_And_Get
180: ( p_count => x_msg_count,

Line 178: x_return_status := FND_API.G_RET_STS_ERROR;

174:
175: EXCEPTION
176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO csp_inv_loc_assignments_cuhk;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: FND_MSG_PUB.Count_And_Get
180: ( p_count => x_msg_count,
181: p_data => x_msg_data );
182: WHEN OTHERS THEN

Line 184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

180: ( p_count => x_msg_count,
181: p_data => x_msg_data );
182: WHEN OTHERS THEN
183: ROLLBACK TO csp_inv_loc_assignments_cuhk;
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
186: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
187: END IF;
188: FND_MSG_PUB.Count_And_Get

Line 204: x_return_status := fnd_api.g_ret_sts_success;

200: l_api_name varchar2(200) := 'Delete_inventory_location_post' ;
201: BEGIN
202: Savepoint csp_inv_loc_assignments_cuhk;
203:
204: x_return_status := fnd_api.g_ret_sts_success;
205: NULL;
206: -- Standard call to get message count and if count is 1, get message info
207: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
208: p_data => x_msg_data );

Line 211: WHEN FND_API.G_EXC_ERROR THEN

207: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
208: p_data => x_msg_data );
209:
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO csp_inv_loc_assignments_cuhk;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count,

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

209:
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO csp_inv_loc_assignments_cuhk;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MSG_PUB.Count_And_Get
215: ( p_count => x_msg_count,
216: p_data => x_msg_data );
217: WHEN OTHERS THEN

Line 219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

215: ( p_count => x_msg_count,
216: p_data => x_msg_data );
217: WHEN OTHERS THEN
218: ROLLBACK TO csp_inv_loc_assignments_cuhk;
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
221: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
222: END IF;
223: FND_MSG_PUB.Count_And_Get