eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_PS_CNDCLSES_PUB dependencies on FND_API

Line 25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

21: AMS_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
22:
23: PROCEDURE Create_Ps_Cndclses(
24: p_api_version_number IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27:
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,

Line 26: p_commit IN VARCHAR2 := FND_API.G_FALSE,

22:
23: PROCEDURE Create_Ps_Cndclses(
24: p_api_version_number IN NUMBER,
25: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
26: p_commit IN VARCHAR2 := FND_API.G_FALSE,
27:
28: x_return_status OUT NOCOPY VARCHAR2,
29: x_msg_count OUT NOCOPY NUMBER,
30: x_msg_data OUT NOCOPY VARCHAR2,

Line 45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

41: -- Standard Start of API savepoint
42: SAVEPOINT CREATE_Ps_Cndclses_PUB;
43:
44: -- Standard call to check for call compatibility.
45: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
46: p_api_version_number,
47: l_api_name,
48: G_PKG_NAME)
49: THEN

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

46: p_api_version_number,
47: l_api_name,
48: G_PKG_NAME)
49: THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list )

Line 54: IF FND_API.to_Boolean( p_init_msg_list )

50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list )
55: THEN
56: FND_MSG_PUB.initialize;
57: END IF;
58:

Line 67: x_return_status := FND_API.G_RET_STS_SUCCESS;

63: END IF;
64:
65:
66: -- Initialize API return status to SUCCESS
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: --
70: -- API body
71: --

Line 76: p_init_msg_list => FND_API.G_FALSE,

72: -- Calling Private package: Create_Ps_Cndclses
73: -- Hint: Primary key needs to be returned
74: AMS_Ps_Cndclses_PVT.Create_Ps_Cndclses(
75: p_api_version_number => 1.0,
76: p_init_msg_list => FND_API.G_FALSE,
77: p_commit => FND_API.G_FALSE,
78: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
79: x_return_status => x_return_status,
80: x_msg_count => x_msg_count,

Line 77: p_commit => FND_API.G_FALSE,

73: -- Hint: Primary key needs to be returned
74: AMS_Ps_Cndclses_PVT.Create_Ps_Cndclses(
75: p_api_version_number => 1.0,
76: p_init_msg_list => FND_API.G_FALSE,
77: p_commit => FND_API.G_FALSE,
78: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
79: x_return_status => x_return_status,
80: x_msg_count => x_msg_count,
81: x_msg_data => x_msg_data,

Line 78: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

74: AMS_Ps_Cndclses_PVT.Create_Ps_Cndclses(
75: p_api_version_number => 1.0,
76: p_init_msg_list => FND_API.G_FALSE,
77: p_commit => FND_API.G_FALSE,
78: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
79: x_return_status => x_return_status,
80: x_msg_count => x_msg_count,
81: x_msg_data => x_msg_data,
82: p_ps_cndclses_rec => l_pvt_ps_cndclses_rec,

Line 87: IF x_return_status = FND_API.G_RET_STS_ERROR then

83: x_cnd_clause_id => x_cnd_clause_id);
84:
85:
86: -- Check return status from the above procedure call
87: IF x_return_status = FND_API.G_RET_STS_ERROR then
88: RAISE FND_API.G_EXC_ERROR;
89: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;

Line 88: RAISE FND_API.G_EXC_ERROR;

84:
85:
86: -- Check return status from the above procedure call
87: IF x_return_status = FND_API.G_RET_STS_ERROR then
88: RAISE FND_API.G_EXC_ERROR;
89: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92: --

Line 89: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

85:
86: -- Check return status from the above procedure call
87: IF x_return_status = FND_API.G_RET_STS_ERROR then
88: RAISE FND_API.G_EXC_ERROR;
89: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92: --
93: -- End of API body.

Line 90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

86: -- Check return status from the above procedure call
87: IF x_return_status = FND_API.G_RET_STS_ERROR then
88: RAISE FND_API.G_EXC_ERROR;
89: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
90: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
91: END IF;
92: --
93: -- End of API body.
94: --

Line 97: IF FND_API.to_Boolean( p_commit )

93: -- End of API body.
94: --
95:
96: -- Standard check for p_commit
97: IF FND_API.to_Boolean( p_commit )
98: THEN
99: COMMIT WORK;
100: END IF;
101:

Line 117: x_return_status := FND_API.g_ret_sts_error;

113: );
114: EXCEPTION
115:
116: WHEN AMS_Utility_PVT.resource_locked THEN
117: x_return_status := FND_API.g_ret_sts_error;
118: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
119:
120: WHEN FND_API.G_EXC_ERROR THEN
121: ROLLBACK TO CREATE_Ps_Cndclses_PUB;

Line 120: WHEN FND_API.G_EXC_ERROR THEN

116: WHEN AMS_Utility_PVT.resource_locked THEN
117: x_return_status := FND_API.g_ret_sts_error;
118: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
119:
120: WHEN FND_API.G_EXC_ERROR THEN
121: ROLLBACK TO CREATE_Ps_Cndclses_PUB;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: -- Standard call to get message count and if count=1, get the message
124: FND_MSG_PUB.Count_And_Get (

Line 122: x_return_status := FND_API.G_RET_STS_ERROR;

118: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
119:
120: WHEN FND_API.G_EXC_ERROR THEN
121: ROLLBACK TO CREATE_Ps_Cndclses_PUB;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: -- Standard call to get message count and if count=1, get the message
124: FND_MSG_PUB.Count_And_Get (
125: p_encoded => FND_API.G_FALSE,
126: p_count => x_msg_count,

Line 125: p_encoded => FND_API.G_FALSE,

121: ROLLBACK TO CREATE_Ps_Cndclses_PUB;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123: -- Standard call to get message count and if count=1, get the message
124: FND_MSG_PUB.Count_And_Get (
125: p_encoded => FND_API.G_FALSE,
126: p_count => x_msg_count,
127: p_data => x_msg_data
128: );
129:

Line 130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

126: p_count => x_msg_count,
127: p_data => x_msg_data
128: );
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ROLLBACK TO CREATE_Ps_Cndclses_PUB;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: -- Standard call to get message count and if count=1, get the message
134: FND_MSG_PUB.Count_And_Get (

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

128: );
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ROLLBACK TO CREATE_Ps_Cndclses_PUB;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: -- Standard call to get message count and if count=1, get the message
134: FND_MSG_PUB.Count_And_Get (
135: p_encoded => FND_API.G_FALSE,
136: p_count => x_msg_count,

Line 135: p_encoded => FND_API.G_FALSE,

131: ROLLBACK TO CREATE_Ps_Cndclses_PUB;
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: -- Standard call to get message count and if count=1, get the message
134: FND_MSG_PUB.Count_And_Get (
135: p_encoded => FND_API.G_FALSE,
136: p_count => x_msg_count,
137: p_data => x_msg_data
138: );
139:

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

138: );
139:
140: WHEN OTHERS THEN
141: ROLLBACK TO CREATE_Ps_Cndclses_PUB;
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
144: THEN
145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
146: END IF;

Line 149: p_encoded => FND_API.G_FALSE,

145: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
146: END IF;
147: -- Standard call to get message count and if count=1, get the message
148: FND_MSG_PUB.Count_And_Get (
149: p_encoded => FND_API.G_FALSE,
150: p_count => x_msg_count,
151: p_data => x_msg_data
152: );
153: End Create_Ps_Cndclses;

Line 158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

154:
155:
156: PROCEDURE Update_Ps_Cndclses(
157: p_api_version_number IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
160:
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,

Line 159: p_commit IN VARCHAR2 := FND_API.G_FALSE,

155:
156: PROCEDURE Update_Ps_Cndclses(
157: p_api_version_number IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
160:
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,

Line 179: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

175: -- Standard Start of API savepoint
176: SAVEPOINT UPDATE_Ps_Cndclses_PUB;
177:
178: -- Standard call to check for call compatibility.
179: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
180: p_api_version_number,
181: l_api_name,
182: G_PKG_NAME)
183: THEN

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: p_api_version_number,
181: l_api_name,
182: G_PKG_NAME)
183: THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186:
187: -- Initialize message list if p_init_msg_list is set to TRUE.
188: IF FND_API.to_Boolean( p_init_msg_list )

Line 188: IF FND_API.to_Boolean( p_init_msg_list )

184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186:
187: -- Initialize message list if p_init_msg_list is set to TRUE.
188: IF FND_API.to_Boolean( p_init_msg_list )
189: THEN
190: FND_MSG_PUB.initialize;
191: END IF;
192:

Line 201: x_return_status := FND_API.G_RET_STS_SUCCESS;

197: END IF;
198:
199:
200: -- Initialize API return status to SUCCESS
201: x_return_status := FND_API.G_RET_STS_SUCCESS;
202:
203: --
204: -- API body
205: --

Line 208: p_init_msg_list => FND_API.G_FALSE,

204: -- API body
205: --
206: AMS_Ps_Cndclses_PVT.Update_Ps_Cndclses(
207: p_api_version_number => 1.0,
208: p_init_msg_list => FND_API.G_FALSE,
209: p_commit => p_commit,
210: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
211: x_return_status => x_return_status,
212: x_msg_count => x_msg_count,

Line 210: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

206: AMS_Ps_Cndclses_PVT.Update_Ps_Cndclses(
207: p_api_version_number => 1.0,
208: p_init_msg_list => FND_API.G_FALSE,
209: p_commit => p_commit,
210: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
211: x_return_status => x_return_status,
212: x_msg_count => x_msg_count,
213: x_msg_data => x_msg_data,
214: p_ps_cndclses_rec => l_pvt_ps_cndclses_rec,

Line 219: IF x_return_status = FND_API.G_RET_STS_ERROR then

215: x_object_version_number => l_object_version_number );
216:
217:
218: -- Check return status from the above procedure call
219: IF x_return_status = FND_API.G_RET_STS_ERROR then
220: RAISE FND_API.G_EXC_ERROR;
221: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;

Line 220: RAISE FND_API.G_EXC_ERROR;

216:
217:
218: -- Check return status from the above procedure call
219: IF x_return_status = FND_API.G_RET_STS_ERROR then
220: RAISE FND_API.G_EXC_ERROR;
221: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: --

Line 221: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

217:
218: -- Check return status from the above procedure call
219: IF x_return_status = FND_API.G_RET_STS_ERROR then
220: RAISE FND_API.G_EXC_ERROR;
221: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: --
225: -- End of API body

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: -- Check return status from the above procedure call
219: IF x_return_status = FND_API.G_RET_STS_ERROR then
220: RAISE FND_API.G_EXC_ERROR;
221: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: --
225: -- End of API body
226: --

Line 229: IF FND_API.to_Boolean( p_commit )

225: -- End of API body
226: --
227:
228: -- Standard check for p_commit
229: IF FND_API.to_Boolean( p_commit )
230: THEN
231: COMMIT WORK;
232: END IF;
233:

Line 249: x_return_status := FND_API.g_ret_sts_error;

245: );
246: EXCEPTION
247:
248: WHEN AMS_Utility_PVT.resource_locked THEN
249: x_return_status := FND_API.g_ret_sts_error;
250: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
251:
252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO UPDATE_Ps_Cndclses_PUB;

Line 252: WHEN FND_API.G_EXC_ERROR THEN

248: WHEN AMS_Utility_PVT.resource_locked THEN
249: x_return_status := FND_API.g_ret_sts_error;
250: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
251:
252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO UPDATE_Ps_Cndclses_PUB;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (

Line 254: x_return_status := FND_API.G_RET_STS_ERROR;

250: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
251:
252: WHEN FND_API.G_EXC_ERROR THEN
253: ROLLBACK TO UPDATE_Ps_Cndclses_PUB;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.G_FALSE,
258: p_count => x_msg_count,

Line 257: p_encoded => FND_API.G_FALSE,

253: ROLLBACK TO UPDATE_Ps_Cndclses_PUB;
254: x_return_status := FND_API.G_RET_STS_ERROR;
255: -- Standard call to get message count and if count=1, get the message
256: FND_MSG_PUB.Count_And_Get (
257: p_encoded => FND_API.G_FALSE,
258: p_count => x_msg_count,
259: p_data => x_msg_data
260: );
261:

Line 262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

258: p_count => x_msg_count,
259: p_data => x_msg_data
260: );
261:
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO UPDATE_Ps_Cndclses_PUB;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (

Line 264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

260: );
261:
262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
263: ROLLBACK TO UPDATE_Ps_Cndclses_PUB;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,

Line 267: p_encoded => FND_API.G_FALSE,

263: ROLLBACK TO UPDATE_Ps_Cndclses_PUB;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,
269: p_data => x_msg_data
270: );
271:

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

270: );
271:
272: WHEN OTHERS THEN
273: ROLLBACK TO UPDATE_Ps_Cndclses_PUB;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
276: THEN
277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
278: END IF;

Line 281: p_encoded => FND_API.G_FALSE,

277: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
278: END IF;
279: -- Standard call to get message count and if count=1, get the message
280: FND_MSG_PUB.Count_And_Get (
281: p_encoded => FND_API.G_FALSE,
282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );
285: End Update_Ps_Cndclses;

Line 290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

286:
287:
288: PROCEDURE Delete_Ps_Cndclses(
289: p_api_version_number IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,

Line 291: p_commit IN VARCHAR2 := FND_API.G_FALSE,

287:
288: PROCEDURE Delete_Ps_Cndclses(
289: p_api_version_number IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: x_return_status OUT NOCOPY VARCHAR2,
293: x_msg_count OUT NOCOPY NUMBER,
294: x_msg_data OUT NOCOPY VARCHAR2,
295: p_cnd_clause_id IN NUMBER,

Line 310: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

306: -- Standard Start of API savepoint
307: SAVEPOINT DELETE_Ps_Cndclses_PUB;
308:
309: -- Standard call to check for call compatibility.
310: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
311: p_api_version_number,
312: l_api_name,
313: G_PKG_NAME)
314: THEN

Line 315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

311: p_api_version_number,
312: l_api_name,
313: G_PKG_NAME)
314: THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: -- Initialize message list if p_init_msg_list is set to TRUE.
319: IF FND_API.to_Boolean( p_init_msg_list )

Line 319: IF FND_API.to_Boolean( p_init_msg_list )

315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: -- Initialize message list if p_init_msg_list is set to TRUE.
319: IF FND_API.to_Boolean( p_init_msg_list )
320: THEN
321: FND_MSG_PUB.initialize;
322: END IF;
323:

Line 332: x_return_status := FND_API.G_RET_STS_SUCCESS;

328: END IF;
329:
330:
331: -- Initialize API return status to SUCCESS
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:
334: --
335: -- API body
336: --

Line 339: p_init_msg_list => FND_API.G_FALSE,

335: -- API body
336: --
337: AMS_Ps_Cndclses_PVT.Delete_Ps_Cndclses(
338: p_api_version_number => 1.0,
339: p_init_msg_list => FND_API.G_FALSE,
340: p_commit => p_commit,
341: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
342: x_return_status => x_return_status,
343: x_msg_count => x_msg_count,

Line 341: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

337: AMS_Ps_Cndclses_PVT.Delete_Ps_Cndclses(
338: p_api_version_number => 1.0,
339: p_init_msg_list => FND_API.G_FALSE,
340: p_commit => p_commit,
341: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
342: x_return_status => x_return_status,
343: x_msg_count => x_msg_count,
344: x_msg_data => x_msg_data,
345: p_cnd_clause_id => l_cnd_clause_id,

Line 350: IF x_return_status = FND_API.G_RET_STS_ERROR then

346: p_object_version_number => l_object_version_number );
347:
348:
349: -- Check return status from the above procedure call
350: IF x_return_status = FND_API.G_RET_STS_ERROR then
351: RAISE FND_API.G_EXC_ERROR;
352: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
354: END IF;

Line 351: RAISE FND_API.G_EXC_ERROR;

347:
348:
349: -- Check return status from the above procedure call
350: IF x_return_status = FND_API.G_RET_STS_ERROR then
351: RAISE FND_API.G_EXC_ERROR;
352: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
354: END IF;
355: --

Line 352: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

348:
349: -- Check return status from the above procedure call
350: IF x_return_status = FND_API.G_RET_STS_ERROR then
351: RAISE FND_API.G_EXC_ERROR;
352: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
354: END IF;
355: --
356: -- End of API body

Line 353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

349: -- Check return status from the above procedure call
350: IF x_return_status = FND_API.G_RET_STS_ERROR then
351: RAISE FND_API.G_EXC_ERROR;
352: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
354: END IF;
355: --
356: -- End of API body
357: --

Line 360: IF FND_API.to_Boolean( p_commit )

356: -- End of API body
357: --
358:
359: -- Standard check for p_commit
360: IF FND_API.to_Boolean( p_commit )
361: THEN
362: COMMIT WORK;
363: END IF;
364:

Line 380: x_return_status := FND_API.g_ret_sts_error;

376: );
377: EXCEPTION
378:
379: WHEN AMS_Utility_PVT.resource_locked THEN
380: x_return_status := FND_API.g_ret_sts_error;
381: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
382:
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO DELETE_Ps_Cndclses_PUB;

Line 383: WHEN FND_API.G_EXC_ERROR THEN

379: WHEN AMS_Utility_PVT.resource_locked THEN
380: x_return_status := FND_API.g_ret_sts_error;
381: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
382:
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO DELETE_Ps_Cndclses_PUB;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

381: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
382:
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO DELETE_Ps_Cndclses_PUB;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,

Line 388: p_encoded => FND_API.G_FALSE,

384: ROLLBACK TO DELETE_Ps_Cndclses_PUB;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (
388: p_encoded => FND_API.G_FALSE,
389: p_count => x_msg_count,
390: p_data => x_msg_data
391: );
392:

Line 393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

389: p_count => x_msg_count,
390: p_data => x_msg_data
391: );
392:
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO DELETE_Ps_Cndclses_PUB;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (

Line 395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

391: );
392:
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO DELETE_Ps_Cndclses_PUB;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (
398: p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,

Line 398: p_encoded => FND_API.G_FALSE,

394: ROLLBACK TO DELETE_Ps_Cndclses_PUB;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: -- Standard call to get message count and if count=1, get the message
397: FND_MSG_PUB.Count_And_Get (
398: p_encoded => FND_API.G_FALSE,
399: p_count => x_msg_count,
400: p_data => x_msg_data
401: );
402:

Line 405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

401: );
402:
403: WHEN OTHERS THEN
404: ROLLBACK TO DELETE_Ps_Cndclses_PUB;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
407: THEN
408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
409: END IF;

Line 412: p_encoded => FND_API.G_FALSE,

408: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
409: END IF;
410: -- Standard call to get message count and if count=1, get the message
411: FND_MSG_PUB.Count_And_Get (
412: p_encoded => FND_API.G_FALSE,
413: p_count => x_msg_count,
414: p_data => x_msg_data
415: );
416: End Delete_Ps_Cndclses;

Line 421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

417:
418:
419: PROCEDURE Lock_Ps_Cndclses(
420: p_api_version_number IN NUMBER,
421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: x_msg_data OUT NOCOPY VARCHAR2,
425:

Line 437: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

433: l_pvt_ps_cndclses_rec AMS_Ps_Cndclses_PVT.ps_cndclses_rec_type;
434: BEGIN
435:
436: -- Standard call to check for call compatibility.
437: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
438: p_api_version_number,
439: l_api_name,
440: G_PKG_NAME)
441: THEN

Line 442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

438: p_api_version_number,
439: l_api_name,
440: G_PKG_NAME)
441: THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: -- Initialize message list if p_init_msg_list is set to TRUE.
446: IF FND_API.to_Boolean( p_init_msg_list )

Line 446: IF FND_API.to_Boolean( p_init_msg_list )

442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445: -- Initialize message list if p_init_msg_list is set to TRUE.
446: IF FND_API.to_Boolean( p_init_msg_list )
447: THEN
448: FND_MSG_PUB.initialize;
449: END IF;
450:

Line 459: x_return_status := FND_API.G_RET_STS_SUCCESS;

455: END IF;
456:
457:
458: -- Initialize API return status to SUCCESS
459: x_return_status := FND_API.G_RET_STS_SUCCESS;
460:
461: --
462: -- API body
463: --

Line 468: p_init_msg_list => FND_API.G_FALSE,

464: -- Calling Private package: Create_Ps_Cndclses
465: -- Hint: Primary key needs to be returned
466: AMS_Ps_Cndclses_PVT.Lock_Ps_Cndclses(
467: p_api_version_number => 1.0,
468: p_init_msg_list => FND_API.G_FALSE,
469: x_return_status => x_return_status,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: p_cnd_clause_id => p_cnd_clause_id,

Line 477: IF x_return_status = FND_API.G_RET_STS_ERROR then

473: p_object_version => p_object_version);
474:
475:
476: -- Check return status from the above procedure call
477: IF x_return_status = FND_API.G_RET_STS_ERROR then
478: RAISE FND_API.G_EXC_ERROR;
479: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
481: END IF;

Line 478: RAISE FND_API.G_EXC_ERROR;

474:
475:
476: -- Check return status from the above procedure call
477: IF x_return_status = FND_API.G_RET_STS_ERROR then
478: RAISE FND_API.G_EXC_ERROR;
479: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
481: END IF;
482: --

Line 479: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

475:
476: -- Check return status from the above procedure call
477: IF x_return_status = FND_API.G_RET_STS_ERROR then
478: RAISE FND_API.G_EXC_ERROR;
479: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
481: END IF;
482: --
483: -- End of API body.

Line 480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

476: -- Check return status from the above procedure call
477: IF x_return_status = FND_API.G_RET_STS_ERROR then
478: RAISE FND_API.G_EXC_ERROR;
479: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
481: END IF;
482: --
483: -- End of API body.
484: --

Line 495: x_return_status := FND_API.g_ret_sts_error;

491:
492: EXCEPTION
493:
494: WHEN AMS_Utility_PVT.resource_locked THEN
495: x_return_status := FND_API.g_ret_sts_error;
496: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
497:
498: WHEN FND_API.G_EXC_ERROR THEN
499: ROLLBACK TO LOCK_Ps_Cndclses_PUB;

Line 498: WHEN FND_API.G_EXC_ERROR THEN

494: WHEN AMS_Utility_PVT.resource_locked THEN
495: x_return_status := FND_API.g_ret_sts_error;
496: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
497:
498: WHEN FND_API.G_EXC_ERROR THEN
499: ROLLBACK TO LOCK_Ps_Cndclses_PUB;
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: -- Standard call to get message count and if count=1, get the message
502: FND_MSG_PUB.Count_And_Get (

Line 500: x_return_status := FND_API.G_RET_STS_ERROR;

496: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
497:
498: WHEN FND_API.G_EXC_ERROR THEN
499: ROLLBACK TO LOCK_Ps_Cndclses_PUB;
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: -- Standard call to get message count and if count=1, get the message
502: FND_MSG_PUB.Count_And_Get (
503: p_encoded => FND_API.G_FALSE,
504: p_count => x_msg_count,

Line 503: p_encoded => FND_API.G_FALSE,

499: ROLLBACK TO LOCK_Ps_Cndclses_PUB;
500: x_return_status := FND_API.G_RET_STS_ERROR;
501: -- Standard call to get message count and if count=1, get the message
502: FND_MSG_PUB.Count_And_Get (
503: p_encoded => FND_API.G_FALSE,
504: p_count => x_msg_count,
505: p_data => x_msg_data
506: );
507:

Line 508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

504: p_count => x_msg_count,
505: p_data => x_msg_data
506: );
507:
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: ROLLBACK TO LOCK_Ps_Cndclses_PUB;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: );
507:
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: ROLLBACK TO LOCK_Ps_Cndclses_PUB;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,
514: p_count => x_msg_count,

Line 513: p_encoded => FND_API.G_FALSE,

509: ROLLBACK TO LOCK_Ps_Cndclses_PUB;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: -- Standard call to get message count and if count=1, get the message
512: FND_MSG_PUB.Count_And_Get (
513: p_encoded => FND_API.G_FALSE,
514: p_count => x_msg_count,
515: p_data => x_msg_data
516: );
517:

Line 520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

516: );
517:
518: WHEN OTHERS THEN
519: ROLLBACK TO LOCK_Ps_Cndclses_PUB;
520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
522: THEN
523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
524: END IF;

Line 527: p_encoded => FND_API.G_FALSE,

523: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
524: END IF;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data
530: );
531: End Lock_Ps_Cndclses;