DBA Data[Home] [Help]

APPS.CSP_REQUIREMENT_LINES_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_requirement_lines_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_requirement_lines_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_requirement_lines_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_requirement_lines_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 60: x_return_status := fnd_api.g_ret_sts_success;

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

Line 67: WHEN FND_API.G_EXC_ERROR THEN

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

Line 69: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 75: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 100: x_return_status := fnd_api.g_ret_sts_success;

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

Line 107: WHEN FND_API.G_EXC_ERROR THEN

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

Line 109: x_return_status := FND_API.G_RET_STS_ERROR;

105:
106: EXCEPTION
107: WHEN FND_API.G_EXC_ERROR THEN
108: ROLLBACK TO csp_requirement_lines_cuhk;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110: FND_MSG_PUB.Count_And_Get
111: ( p_count => x_msg_count,
112: p_data => x_msg_data );
113: WHEN OTHERS THEN

Line 115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 137: x_return_status := fnd_api.g_ret_sts_success;

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

Line 144: WHEN FND_API.G_EXC_ERROR THEN

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

Line 146: x_return_status := FND_API.G_RET_STS_ERROR;

142:
143: EXCEPTION
144: WHEN FND_API.G_EXC_ERROR THEN
145: ROLLBACK TO csp_requirement_lines_cuhk;
146: x_return_status := FND_API.G_RET_STS_ERROR;
147: FND_MSG_PUB.Count_And_Get
148: ( p_count => x_msg_count,
149: p_data => x_msg_data );
150: WHEN OTHERS THEN

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 173: x_return_status := fnd_api.g_ret_sts_success;

169: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
170: BEGIN
171: Savepoint csp_requirement_lines_cuhk;
172:
173: x_return_status := fnd_api.g_ret_sts_success;
174: NULL;
175: -- Standard call to get message count and if count is 1, get message info
176: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
177: p_data => x_msg_data );

Line 180: WHEN FND_API.G_EXC_ERROR THEN

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

Line 182: x_return_status := FND_API.G_RET_STS_ERROR;

178:
179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR THEN
181: ROLLBACK TO csp_requirement_lines_cuhk;
182: x_return_status := FND_API.G_RET_STS_ERROR;
183: FND_MSG_PUB.Count_And_Get
184: ( p_count => x_msg_count,
185: p_data => x_msg_data );
186: WHEN OTHERS THEN

Line 188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

184: ( p_count => x_msg_count,
185: p_data => x_msg_data );
186: WHEN OTHERS THEN
187: ROLLBACK TO csp_requirement_lines_cuhk;
188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
190: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
191: END IF;
192: FND_MSG_PUB.Count_And_Get

Line 209: x_return_status := fnd_api.g_ret_sts_success;

205: l_api_name varchar2(200) := 'create_inventory_location_Pre' ;
206: BEGIN
207: Savepoint csp_requirement_lines_cuhk;
208:
209: x_return_status := fnd_api.g_ret_sts_success;
210: NULL;
211: -- Standard call to get message count and if count is 1, get message info
212: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
213: p_data => x_msg_data );

Line 216: WHEN FND_API.G_EXC_ERROR THEN

212: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
213: p_data => x_msg_data );
214:
215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: ROLLBACK TO csp_requirement_lines_cuhk;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count,

Line 218: x_return_status := FND_API.G_RET_STS_ERROR;

214:
215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: ROLLBACK TO csp_requirement_lines_cuhk;
218: x_return_status := FND_API.G_RET_STS_ERROR;
219: FND_MSG_PUB.Count_And_Get
220: ( p_count => x_msg_count,
221: p_data => x_msg_data );
222: WHEN OTHERS THEN

Line 224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

220: ( p_count => x_msg_count,
221: p_data => x_msg_data );
222: WHEN OTHERS THEN
223: ROLLBACK TO csp_requirement_lines_cuhk;
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
226: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
227: END IF;
228: FND_MSG_PUB.Count_And_Get