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_CAL_CRT_PVT dependencies on FND_API

Line 45: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

41: -- Parameters
42: --
43: -- IN
44: -- p_api_version_number IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
46: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
47: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
48: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
49: --

Line 46: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

42: --
43: -- IN
44: -- p_api_version_number IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
46: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
47: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
48: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
49: --
50: -- OUT

Line 47: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

43: -- IN
44: -- p_api_version_number IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
46: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
47: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
48: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
49: --
50: -- OUT
51: -- x_return_status OUT VARCHAR2

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

62: -- End of Comments
63: -- ==============================================================================
64: PROCEDURE Create_Cal_Crt(
65: p_api_version_number IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,

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

63: -- ==============================================================================
64: PROCEDURE Create_Cal_Crt(
65: p_api_version_number IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,
71: x_msg_data OUT NOCOPY VARCHAR2,

Line 68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

64: PROCEDURE Create_Cal_Crt(
65: p_api_version_number IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
67: p_commit IN VARCHAR2 := FND_API.G_FALSE,
68: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,
71: x_msg_data OUT NOCOPY VARCHAR2,
72: p_cal_crt_rec_rec IN cal_crt_rec_rec_type := g_miss_cal_crt_rec_rec,

Line 80: -- l_org_id NUMBER := FND_API.G_MISS_NUM;

76: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Cal_Crt';
77: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
78: l_return_status_full VARCHAR2(1);
79: l_object_version_number NUMBER := 1;
80: -- l_org_id NUMBER := FND_API.G_MISS_NUM;
81: l_criteria_id NUMBER;
82: l_dummy NUMBER;
83: l_cal_crt_rec_rec cal_crt_rec_rec_type := p_cal_crt_rec_rec;
84:

Line 96: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

92: BEGIN
93: -- Standard Start of API savepoint
94: SAVEPOINT create_cal_crt_pvt;
95: -- Standard call to check for call compatibility.
96: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
97: p_api_version_number,
98: l_api_name,
99: G_PKG_NAME)
100: THEN

Line 101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

97: p_api_version_number,
98: l_api_name,
99: G_PKG_NAME)
100: THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:
104: -- Initialize message list if p_init_msg_list is set to TRUE.
105: IF FND_API.to_Boolean( p_init_msg_list )

Line 105: IF FND_API.to_Boolean( p_init_msg_list )

101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:
104: -- Initialize message list if p_init_msg_list is set to TRUE.
105: IF FND_API.to_Boolean( p_init_msg_list )
106: THEN
107: FND_MSG_PUB.initialize;
108: END IF;
109: -- Debug Message

Line 115: x_return_status := FND_API.G_RET_STS_SUCCESS;

111:
112: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
113: END IF;
114: -- Initialize API return status to SUCCESS
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116:
117: -- =========================================================================
118: -- Validate Environment
119: -- =========================================================================

Line 123: RAISE FND_API.G_EXC_ERROR;

119: -- =========================================================================
120: IF FND_GLOBAL.USER_ID IS NULL
121: THEN
122: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;
125:
126: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
127: THEN

Line 126: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

122: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
123: RAISE FND_API.G_EXC_ERROR;
124: END IF;
125:
126: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
127: THEN
128: -- Debug message
129: IF (AMS_DEBUG_HIGH_ON) THEN
130:

Line 143: p_init_msg_list => FND_API.G_FALSE,

139: l_cal_crt_rec_rec.object_version_number := l_object_version_number;
140: -- Invoke validation procedures
141: Validate_cal_crt(
142: p_api_version_number => 1.0,
143: p_init_msg_list => FND_API.G_FALSE,
144: p_validation_level => p_validation_level,
145: p_validation_mode => JTF_PLSQL_API.g_create,
146: p_cal_crt_rec_rec => l_cal_crt_rec_rec,
147: x_return_status => x_return_status,

Line 152: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

148: x_msg_count => x_msg_count,
149: x_msg_data => x_msg_data);
150: END IF;
151:
152: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155: -- Local variable initialization
156: IF l_cal_crt_rec_rec.criteria_id IS NULL OR l_cal_crt_rec_rec.criteria_id = FND_API.g_miss_num THEN

Line 153: RAISE FND_API.G_EXC_ERROR;

149: x_msg_data => x_msg_data);
150: END IF;
151:
152: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155: -- Local variable initialization
156: IF l_cal_crt_rec_rec.criteria_id IS NULL OR l_cal_crt_rec_rec.criteria_id = FND_API.g_miss_num THEN
157: LOOP

Line 156: IF l_cal_crt_rec_rec.criteria_id IS NULL OR l_cal_crt_rec_rec.criteria_id = FND_API.g_miss_num THEN

152: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
153: RAISE FND_API.G_EXC_ERROR;
154: END IF;
155: -- Local variable initialization
156: IF l_cal_crt_rec_rec.criteria_id IS NULL OR l_cal_crt_rec_rec.criteria_id = FND_API.g_miss_num THEN
157: LOOP
158: l_dummy := NULL;
159: OPEN c_id;
160: FETCH c_id INTO l_criteria_id;

Line 199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

195: px_object_version_number => l_object_version_number
196: );
197:
198: x_criteria_id := l_criteria_id;
199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202: --
203: -- End of API body

Line 200: RAISE FND_API.G_EXC_ERROR;

196: );
197:
198: x_criteria_id := l_criteria_id;
199: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202: --
203: -- End of API body
204: --

Line 206: IF FND_API.to_Boolean( p_commit )

202: --
203: -- End of API body
204: --
205: -- Standard check for p_commit
206: IF FND_API.to_Boolean( p_commit )
207: THEN
208: COMMIT WORK;
209: END IF;
210: -- Debug Message

Line 221: x_return_status := FND_API.g_ret_sts_error;

217: p_data => x_msg_data
218: );
219: EXCEPTION
220: WHEN AMS_Utility_PVT.resource_locked THEN
221: x_return_status := FND_API.g_ret_sts_error;
222: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK TO CREATE_Cal_Crt_PVT;
225: x_return_status := FND_API.G_RET_STS_ERROR;

Line 223: WHEN FND_API.G_EXC_ERROR THEN

219: EXCEPTION
220: WHEN AMS_Utility_PVT.resource_locked THEN
221: x_return_status := FND_API.g_ret_sts_error;
222: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK TO CREATE_Cal_Crt_PVT;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: -- Standard call to get message count and if count=1, get the message
227: FND_MSG_PUB.Count_And_Get (

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: x_return_status := FND_API.g_ret_sts_error;
222: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
223: WHEN FND_API.G_EXC_ERROR THEN
224: ROLLBACK TO CREATE_Cal_Crt_PVT;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: -- Standard call to get message count and if count=1, get the message
227: FND_MSG_PUB.Count_And_Get (
228: p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count,

Line 228: p_encoded => FND_API.G_FALSE,

224: ROLLBACK TO CREATE_Cal_Crt_PVT;
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: -- Standard call to get message count and if count=1, get the message
227: FND_MSG_PUB.Count_And_Get (
228: p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count,
230: p_data => x_msg_data
231: );
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

228: p_encoded => FND_API.G_FALSE,
229: p_count => x_msg_count,
230: p_data => x_msg_data
231: );
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO CREATE_Cal_Crt_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: p_data => x_msg_data
231: );
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO CREATE_Cal_Crt_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,

Line 237: p_encoded => FND_API.G_FALSE,

233: ROLLBACK TO CREATE_Cal_Crt_PVT;
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: -- Standard call to get message count and if count=1, get the message
236: FND_MSG_PUB.Count_And_Get (
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241:

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

240: );
241:
242: WHEN OTHERS THEN
243: ROLLBACK TO CREATE_Cal_Crt_PVT;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
246: THEN
247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
248: END IF;

Line 251: p_encoded => FND_API.G_FALSE,

247: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
248: END IF;
249: -- Standard call to get message count and if count=1, get the message
250: FND_MSG_PUB.Count_And_Get (
251: p_encoded => FND_API.G_FALSE,
252: p_count => x_msg_count,
253: p_data => x_msg_data
254: );
255: End Create_Cal_Crt;

Line 269: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

265: -- Parameters
266:
267: -- IN
268: -- p_api_version_number IN NUMBER Required
269: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
270: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
271: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
272: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
273: --

Line 270: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

266:
267: -- IN
268: -- p_api_version_number IN NUMBER Required
269: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
270: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
271: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
272: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
273: --
274: -- OUT

Line 271: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

267: -- IN
268: -- p_api_version_number IN NUMBER Required
269: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
270: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
271: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
272: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
273: --
274: -- OUT
275: -- x_return_status OUT VARCHAR2

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

287: -- ==============================================================================
288:
289: PROCEDURE Update_Cal_Crt(
290: p_api_version_number IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292: p_commit IN VARCHAR2 := FND_API.G_FALSE,
293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294:
295: x_return_status OUT NOCOPY VARCHAR2,

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

288:
289: PROCEDURE Update_Cal_Crt(
290: p_api_version_number IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292: p_commit IN VARCHAR2 := FND_API.G_FALSE,
293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294:
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,

Line 293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

289: PROCEDURE Update_Cal_Crt(
290: p_api_version_number IN NUMBER,
291: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
292: p_commit IN VARCHAR2 := FND_API.G_FALSE,
293: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
294:
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,

Line 318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

314: BEGIN
315: -- Standard Start of API savepoint
316: SAVEPOINT update_cal_crt_pvt;
317: -- Standard call to check for call compatibility.
318: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
319: p_api_version_number,
320: l_api_name,
321: G_PKG_NAME)
322: THEN

Line 323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

319: p_api_version_number,
320: l_api_name,
321: G_PKG_NAME)
322: THEN
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: -- Initialize message list if p_init_msg_list is set to TRUE.
327: IF FND_API.to_Boolean( p_init_msg_list )

Line 327: IF FND_API.to_Boolean( p_init_msg_list )

323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: END IF;
325:
326: -- Initialize message list if p_init_msg_list is set to TRUE.
327: IF FND_API.to_Boolean( p_init_msg_list )
328: THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:

Line 343: x_return_status := FND_API.G_RET_STS_SUCCESS;

339: l_tar_cal_crt_rec_rec.last_update_date := SYSDATE;
340: l_tar_cal_crt_rec_rec.last_updated_by := FND_GLOBAL.user_id;
341: l_tar_cal_crt_rec_rec.last_update_login := FND_GLOBAL.conc_login_id;
342: -- Initialize API return status to SUCCESS
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344: IF (AMS_DEBUG_HIGH_ON) THEN
345: AMS_UTILITY_PVT.debug_message('l_tar_cal_crt_rec_rec.criteria_deleted: ' || l_tar_cal_crt_rec_rec.criteria_deleted);
346: END IF;
347: IF (AMS_DEBUG_HIGH_ON) THEN

Line 355: x_return_status := FND_API.g_ret_sts_error;

351: IF (AMS_DEBUG_HIGH_ON) THEN
352: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
353: END IF;
354: IF ( (l_tar_cal_crt_rec_rec.criteria_deleted = 'Y') AND (l_tar_cal_crt_rec_rec.criteria_enabled = 'Y') ) THEN
355: x_return_status := FND_API.g_ret_sts_error;
356: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_ENABLED_DELETE');
357: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
358: FND_MESSAGE.set_name ('AMS', 'AMS_CAL_CRT_ENABLED_DELETE');
359: FND_MSG_PUB.add;

Line 360: RAISE FND_API.G_EXC_ERROR;

356: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_ENABLED_DELETE');
357: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
358: FND_MESSAGE.set_name ('AMS', 'AMS_CAL_CRT_ENABLED_DELETE');
359: FND_MSG_PUB.add;
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362: ELSE
363: OPEN c_get_Cal_Crt( l_tar_cal_crt_rec_rec.criteria_id);
364: FETCH c_get_Cal_Crt INTO l_ref_cal_crt_rec_rec ;

Line 370: RAISE FND_API.G_EXC_ERROR;

366: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
367: p_token_name => 'INFO',
368: p_token_value => 'Cal_Crt'
369: ) ;
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372: -- Debug Message
373: IF (AMS_DEBUG_HIGH_ON) THEN
374:

Line 380: l_tar_cal_crt_rec_rec.object_version_number = FND_API.G_MISS_NUM ) Then

376: END IF;
377: CLOSE c_get_Cal_Crt;
378:
379: If (l_tar_cal_crt_rec_rec.object_version_number is NULL or
380: l_tar_cal_crt_rec_rec.object_version_number = FND_API.G_MISS_NUM ) Then
381: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
382: p_token_name => 'COLUMN',
383: p_token_value => 'Last_Update_Date') ;
384: raise FND_API.G_EXC_ERROR;

Line 384: raise FND_API.G_EXC_ERROR;

380: l_tar_cal_crt_rec_rec.object_version_number = FND_API.G_MISS_NUM ) Then
381: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
382: p_token_name => 'COLUMN',
383: p_token_value => 'Last_Update_Date') ;
384: raise FND_API.G_EXC_ERROR;
385: End if;
386: -- Check Whether record has been changed by someone else
387: If (l_tar_cal_crt_rec_rec.object_version_number <> l_ref_cal_crt_rec_rec.object_version_number) Then
388: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

Line 391: raise FND_API.G_EXC_ERROR;

387: If (l_tar_cal_crt_rec_rec.object_version_number <> l_ref_cal_crt_rec_rec.object_version_number) Then
388: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
389: p_token_name => 'INFO',
390: p_token_value => 'Cal_Crt') ;
391: raise FND_API.G_EXC_ERROR;
392: End if;
393:
394: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
395: THEN

Line 394: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

390: p_token_value => 'Cal_Crt') ;
391: raise FND_API.G_EXC_ERROR;
392: End if;
393:
394: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
395: THEN
396: -- Debug message
397: IF (AMS_DEBUG_HIGH_ON) THEN
398:

Line 404: p_init_msg_list => FND_API.G_FALSE,

400: END IF;
401: -- Invoke validation procedures
402: Validate_cal_crt(
403: p_api_version_number => 1.0,
404: p_init_msg_list => FND_API.G_FALSE,
405: p_validation_level => p_validation_level,
406: p_validation_mode => JTF_PLSQL_API.g_update,
407: p_cal_crt_rec_rec => l_tar_cal_crt_rec_rec,
408: x_return_status => x_return_status,

Line 413: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

409: x_msg_count => x_msg_count,
410: x_msg_data => x_msg_data);
411: END IF;
412:
413: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417: -- Debug Message

Line 414: RAISE FND_API.G_EXC_ERROR;

410: x_msg_data => x_msg_data);
411: END IF;
412:
413: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
414: RAISE FND_API.G_EXC_ERROR;
415: END IF;
416:
417: -- Debug Message
418: IF (AMS_DEBUG_HIGH_ON) THEN

Line 446: IF FND_API.to_Boolean( p_commit )THEN

442: --
443: END IF;
444:
445: -- Standard check for p_commit
446: IF FND_API.to_Boolean( p_commit )THEN
447: COMMIT WORK;
448: END IF;
449:
450: -- Debug Message

Line 463: x_return_status := FND_API.g_ret_sts_error;

459:
460: EXCEPTION
461:
462: WHEN AMS_Utility_PVT.resource_locked THEN
463: x_return_status := FND_API.g_ret_sts_error;
464: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
465:
466: WHEN FND_API.G_EXC_ERROR THEN
467: ROLLBACK TO UPDATE_Cal_Crt_PVT;

Line 466: WHEN FND_API.G_EXC_ERROR THEN

462: WHEN AMS_Utility_PVT.resource_locked THEN
463: x_return_status := FND_API.g_ret_sts_error;
464: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
465:
466: WHEN FND_API.G_EXC_ERROR THEN
467: ROLLBACK TO UPDATE_Cal_Crt_PVT;
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: -- Standard call to get message count and if count=1, get the message
470: FND_MSG_PUB.Count_And_Get (

Line 468: x_return_status := FND_API.G_RET_STS_ERROR;

464: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
465:
466: WHEN FND_API.G_EXC_ERROR THEN
467: ROLLBACK TO UPDATE_Cal_Crt_PVT;
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: -- Standard call to get message count and if count=1, get the message
470: FND_MSG_PUB.Count_And_Get (
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,

Line 471: p_encoded => FND_API.G_FALSE,

467: ROLLBACK TO UPDATE_Cal_Crt_PVT;
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: -- Standard call to get message count and if count=1, get the message
470: FND_MSG_PUB.Count_And_Get (
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
473: p_data => x_msg_data
474: );
475:

Line 476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

472: p_count => x_msg_count,
473: p_data => x_msg_data
474: );
475:
476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
477: ROLLBACK TO UPDATE_Cal_Crt_PVT;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: -- Standard call to get message count and if count=1, get the message
480: FND_MSG_PUB.Count_And_Get (

Line 478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

474: );
475:
476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
477: ROLLBACK TO UPDATE_Cal_Crt_PVT;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: -- Standard call to get message count and if count=1, get the message
480: FND_MSG_PUB.Count_And_Get (
481: p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,

Line 481: p_encoded => FND_API.G_FALSE,

477: ROLLBACK TO UPDATE_Cal_Crt_PVT;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: -- Standard call to get message count and if count=1, get the message
480: FND_MSG_PUB.Count_And_Get (
481: p_encoded => FND_API.G_FALSE,
482: p_count => x_msg_count,
483: p_data => x_msg_data
484: );
485: WHEN OTHERS THEN

Line 487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

483: p_data => x_msg_data
484: );
485: WHEN OTHERS THEN
486: ROLLBACK TO UPDATE_Cal_Crt_PVT;
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
489: THEN
490: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
491: END IF;

Line 494: p_encoded => FND_API.G_FALSE,

490: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
491: END IF;
492: -- Standard call to get message count and if count=1, get the message
493: FND_MSG_PUB.Count_And_Get (
494: p_encoded => FND_API.G_FALSE,
495: p_count => x_msg_count,
496: p_data => x_msg_data
497: );
498: End Update_Cal_Crt;

Line 512: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

508: -- Parameters
509: --
510: -- IN
511: -- p_api_version_number IN NUMBER Required
512: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
513: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
514: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
515: -- p_criteria_id IN NUMBER
516: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 513: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

509: --
510: -- IN
511: -- p_api_version_number IN NUMBER Required
512: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
513: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
514: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
515: -- p_criteria_id IN NUMBER
516: -- p_object_version_number IN NUMBER Optional Default = NULL
517: --

Line 514: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

510: -- IN
511: -- p_api_version_number IN NUMBER Required
512: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
513: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
514: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
515: -- p_criteria_id IN NUMBER
516: -- p_object_version_number IN NUMBER Optional Default = NULL
517: --
518: -- OUT

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

531: -- ==============================================================================
532:
533: PROCEDURE Delete_Cal_Crt(
534: p_api_version_number IN NUMBER,
535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536: p_commit IN VARCHAR2 := FND_API.G_FALSE,
537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538: x_return_status OUT NOCOPY VARCHAR2,
539: x_msg_count OUT NOCOPY NUMBER,

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

532:
533: PROCEDURE Delete_Cal_Crt(
534: p_api_version_number IN NUMBER,
535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536: p_commit IN VARCHAR2 := FND_API.G_FALSE,
537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538: x_return_status OUT NOCOPY VARCHAR2,
539: x_msg_count OUT NOCOPY NUMBER,
540: x_msg_data OUT NOCOPY VARCHAR2,

Line 537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

533: PROCEDURE Delete_Cal_Crt(
534: p_api_version_number IN NUMBER,
535: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
536: p_commit IN VARCHAR2 := FND_API.G_FALSE,
537: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
538: x_return_status OUT NOCOPY VARCHAR2,
539: x_msg_count OUT NOCOPY NUMBER,
540: x_msg_data OUT NOCOPY VARCHAR2,
541: p_criteria_id IN NUMBER,

Line 553: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

549: BEGIN
550: -- Standard Start of API savepoint
551: SAVEPOINT delete_cal_crt_pvt;
552: -- Standard call to check for call compatibility.
553: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
554: p_api_version_number,
555: l_api_name,
556: G_PKG_NAME)
557: THEN

Line 558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

554: p_api_version_number,
555: l_api_name,
556: G_PKG_NAME)
557: THEN
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
559: END IF;
560: -- Initialize message list if p_init_msg_list is set to TRUE.
561: IF FND_API.to_Boolean( p_init_msg_list )
562: THEN

Line 561: IF FND_API.to_Boolean( p_init_msg_list )

557: THEN
558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
559: END IF;
560: -- Initialize message list if p_init_msg_list is set to TRUE.
561: IF FND_API.to_Boolean( p_init_msg_list )
562: THEN
563: FND_MSG_PUB.initialize;
564: END IF;
565: -- Debug Message

Line 571: x_return_status := FND_API.G_RET_STS_SUCCESS;

567:
568: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
569: END IF;
570: -- Initialize API return status to SUCCESS
571: x_return_status := FND_API.G_RET_STS_SUCCESS;
572:
573: --
574: -- Api body
575: --

Line 588: IF FND_API.to_Boolean( p_commit )

584: --
585: -- End of API body
586: --
587: -- Standard check for p_commit
588: IF FND_API.to_Boolean( p_commit )
589: THEN
590: COMMIT WORK;
591: END IF;
592: -- Debug Message

Line 605: x_return_status := FND_API.g_ret_sts_error;

601: p_data => x_msg_data
602: );
603: EXCEPTION
604: WHEN AMS_Utility_PVT.resource_locked THEN
605: x_return_status := FND_API.g_ret_sts_error;
606: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
607: WHEN FND_API.G_EXC_ERROR THEN
608: ROLLBACK TO DELETE_Cal_Crt_PVT;
609: x_return_status := FND_API.G_RET_STS_ERROR;

Line 607: WHEN FND_API.G_EXC_ERROR THEN

603: EXCEPTION
604: WHEN AMS_Utility_PVT.resource_locked THEN
605: x_return_status := FND_API.g_ret_sts_error;
606: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
607: WHEN FND_API.G_EXC_ERROR THEN
608: ROLLBACK TO DELETE_Cal_Crt_PVT;
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: -- Standard call to get message count and if count=1, get the message
611: FND_MSG_PUB.Count_And_Get (

Line 609: x_return_status := FND_API.G_RET_STS_ERROR;

605: x_return_status := FND_API.g_ret_sts_error;
606: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
607: WHEN FND_API.G_EXC_ERROR THEN
608: ROLLBACK TO DELETE_Cal_Crt_PVT;
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: -- Standard call to get message count and if count=1, get the message
611: FND_MSG_PUB.Count_And_Get (
612: p_encoded => FND_API.G_FALSE,
613: p_count => x_msg_count,

Line 612: p_encoded => FND_API.G_FALSE,

608: ROLLBACK TO DELETE_Cal_Crt_PVT;
609: x_return_status := FND_API.G_RET_STS_ERROR;
610: -- Standard call to get message count and if count=1, get the message
611: FND_MSG_PUB.Count_And_Get (
612: p_encoded => FND_API.G_FALSE,
613: p_count => x_msg_count,
614: p_data => x_msg_data
615: );
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

612: p_encoded => FND_API.G_FALSE,
613: p_count => x_msg_count,
614: p_data => x_msg_data
615: );
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: ROLLBACK TO DELETE_Cal_Crt_PVT;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: -- Standard call to get message count and if count=1, get the message
620: FND_MSG_PUB.Count_And_Get (

Line 618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

614: p_data => x_msg_data
615: );
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: ROLLBACK TO DELETE_Cal_Crt_PVT;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: -- Standard call to get message count and if count=1, get the message
620: FND_MSG_PUB.Count_And_Get (
621: p_encoded => FND_API.G_FALSE,
622: p_count => x_msg_count,

Line 621: p_encoded => FND_API.G_FALSE,

617: ROLLBACK TO DELETE_Cal_Crt_PVT;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: -- Standard call to get message count and if count=1, get the message
620: FND_MSG_PUB.Count_And_Get (
621: p_encoded => FND_API.G_FALSE,
622: p_count => x_msg_count,
623: p_data => x_msg_data
624: );
625:

Line 628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

624: );
625:
626: WHEN OTHERS THEN
627: ROLLBACK TO DELETE_Cal_Crt_PVT;
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
630: THEN
631: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
632: END IF;

Line 635: p_encoded => FND_API.G_FALSE,

631: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
632: END IF;
633: -- Standard call to get message count and if count=1, get the message
634: FND_MSG_PUB.Count_And_Get (
635: p_encoded => FND_API.G_FALSE,
636: p_count => x_msg_count,
637: p_data => x_msg_data
638: );
639: End Delete_Cal_Crt;

Line 654: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

650: -- Parameters
651: --
652: -- IN
653: -- p_api_version_number IN NUMBER Required
654: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
655: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
656: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
657: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
658: --

Line 655: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

651: --
652: -- IN
653: -- p_api_version_number IN NUMBER Required
654: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
655: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
656: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
657: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
658: --
659: -- OUT

Line 656: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

652: -- IN
653: -- p_api_version_number IN NUMBER Required
654: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
655: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
656: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
657: -- p_cal_crt_rec_rec IN cal_crt_rec_rec_type Required
658: --
659: -- OUT
660: -- x_return_status OUT VARCHAR2

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

675:
676:
677: PROCEDURE Lock_Cal_Crt(
678: p_api_version_number IN NUMBER,
679: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
680:
681: x_return_status OUT NOCOPY VARCHAR2,
682: x_msg_count OUT NOCOPY NUMBER,
683: x_msg_data OUT NOCOPY VARCHAR2,

Line 704: IF FND_API.to_Boolean( p_init_msg_list )

700: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
701: END IF;
702:
703: -- Initialize message list if p_init_msg_list is set to TRUE.
704: IF FND_API.to_Boolean( p_init_msg_list )
705: THEN
706: FND_MSG_PUB.initialize;
707:
708: END IF;

Line 710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

706: FND_MSG_PUB.initialize;
707:
708: END IF;
709: -- Standard call to check for call compatibility.
710: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
711: p_api_version_number,
712: l_api_name,
713: G_PKG_NAME)
714: THEN

Line 715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

711: p_api_version_number,
712: l_api_name,
713: G_PKG_NAME)
714: THEN
715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
716: END IF;
717:
718: -- Initialize API return status to SUCCESS
719: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 719: x_return_status := FND_API.G_RET_STS_SUCCESS;

715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
716: END IF;
717:
718: -- Initialize API return status to SUCCESS
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720:
721:
722: ------------------------ lock -------------------------
723: Ams_Cal_Crt_Pkg.Lock_Row(l_criteria_id,p_object_version);

Line 726: p_encoded => FND_API.g_false,

722: ------------------------ lock -------------------------
723: Ams_Cal_Crt_Pkg.Lock_Row(l_criteria_id,p_object_version);
724: -------------------- finish --------------------------
725: FND_MSG_PUB.count_and_get(
726: p_encoded => FND_API.g_false,
727: p_count => x_msg_count,
728: p_data => x_msg_data);
729: IF (AMS_DEBUG_HIGH_ON) THEN
730:

Line 735: x_return_status := FND_API.g_ret_sts_error;

731: AMS_Utility_PVT.debug_message(l_full_name ||': end');
732: END IF;
733: EXCEPTION
734: WHEN AMS_Utility_PVT.resource_locked THEN
735: x_return_status := FND_API.g_ret_sts_error;
736: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
737:
738: WHEN FND_API.G_EXC_ERROR THEN
739: ROLLBACK TO LOCK_Cal_Crt_PVT;

Line 738: WHEN FND_API.G_EXC_ERROR THEN

734: WHEN AMS_Utility_PVT.resource_locked THEN
735: x_return_status := FND_API.g_ret_sts_error;
736: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
737:
738: WHEN FND_API.G_EXC_ERROR THEN
739: ROLLBACK TO LOCK_Cal_Crt_PVT;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: -- Standard call to get message count and if count=1, get the message
742: FND_MSG_PUB.Count_And_Get (

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

736: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
737:
738: WHEN FND_API.G_EXC_ERROR THEN
739: ROLLBACK TO LOCK_Cal_Crt_PVT;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: -- Standard call to get message count and if count=1, get the message
742: FND_MSG_PUB.Count_And_Get (
743: p_encoded => FND_API.G_FALSE,
744: p_count => x_msg_count,

Line 743: p_encoded => FND_API.G_FALSE,

739: ROLLBACK TO LOCK_Cal_Crt_PVT;
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: -- Standard call to get message count and if count=1, get the message
742: FND_MSG_PUB.Count_And_Get (
743: p_encoded => FND_API.G_FALSE,
744: p_count => x_msg_count,
745: p_data => x_msg_data
746: );
747:

Line 748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

744: p_count => x_msg_count,
745: p_data => x_msg_data
746: );
747:
748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
749: ROLLBACK TO LOCK_Cal_Crt_PVT;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: -- Standard call to get message count and if count=1, get the message
752: FND_MSG_PUB.Count_And_Get (

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

746: );
747:
748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
749: ROLLBACK TO LOCK_Cal_Crt_PVT;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: -- Standard call to get message count and if count=1, get the message
752: FND_MSG_PUB.Count_And_Get (
753: p_encoded => FND_API.G_FALSE,
754: p_count => x_msg_count,

Line 753: p_encoded => FND_API.G_FALSE,

749: ROLLBACK TO LOCK_Cal_Crt_PVT;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: -- Standard call to get message count and if count=1, get the message
752: FND_MSG_PUB.Count_And_Get (
753: p_encoded => FND_API.G_FALSE,
754: p_count => x_msg_count,
755: p_data => x_msg_data
756: );
757:

Line 760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

756: );
757:
758: WHEN OTHERS THEN
759: ROLLBACK TO LOCK_Cal_Crt_PVT;
760: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
761: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
762: THEN
763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
764: END IF;

Line 767: p_encoded => FND_API.G_FALSE,

763: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
764: END IF;
765: -- Standard call to get message count and if count=1, get the message
766: FND_MSG_PUB.Count_And_Get (
767: p_encoded => FND_API.G_FALSE,
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );
771: End Lock_Cal_Crt;

Line 815: x_return_status := FND_API.g_ret_sts_success;

811: BEGIN
812: OPEN c_criteria;
813: FETCH c_criteria INTO l_exist;
814: IF c_criteria%NOTFOUND THEN
815: x_return_status := FND_API.g_ret_sts_success;
816: ELSE
817: x_return_status := FND_API.g_ret_sts_error;
818: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_DUPLICATE');
819: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN

Line 817: x_return_status := FND_API.g_ret_sts_error;

813: FETCH c_criteria INTO l_exist;
814: IF c_criteria%NOTFOUND THEN
815: x_return_status := FND_API.g_ret_sts_success;
816: ELSE
817: x_return_status := FND_API.g_ret_sts_error;
818: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_DUPLICATE');
819: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
820: FND_MESSAGE.set_name ('AMS', 'AMS_CAL_CRT_DUPLICATE');
821: FND_MSG_PUB.add;

Line 822: RAISE FND_API.G_EXC_ERROR;

818: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_DUPLICATE');
819: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
820: FND_MESSAGE.set_name ('AMS', 'AMS_CAL_CRT_DUPLICATE');
821: FND_MSG_PUB.add;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF;
824: END IF;
825:
826: CLOSE c_criteria;

Line 836: x_return_status := FND_API.g_ret_sts_success;

832: x_return_status OUT NOCOPY VARCHAR2)
833: IS
834: l_valid_flag VARCHAR2(1);
835: BEGIN
836: x_return_status := FND_API.g_ret_sts_success;
837: IF p_validation_mode = JTF_PLSQL_API.g_create
838: AND p_cal_crt_rec_rec.criteria_id IS NOT NULL
839: THEN
840: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 846: IF l_valid_flag = FND_API.g_false THEN

842: 'criteria_id = ''' || p_cal_crt_rec_rec.criteria_id ||''''
843: );
844: END IF;
845:
846: IF l_valid_flag = FND_API.g_false THEN
847: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_criteria_id_DUPLICATE');
848: x_return_status := FND_API.g_ret_sts_error;
849: END IF;
850: END check_Cal_Crt_Rec_Uk_Items;

Line 848: x_return_status := FND_API.g_ret_sts_error;

844: END IF;
845:
846: IF l_valid_flag = FND_API.g_false THEN
847: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_criteria_id_DUPLICATE');
848: x_return_status := FND_API.g_ret_sts_error;
849: END IF;
850: END check_Cal_Crt_Rec_Uk_Items;
851:
852: PROCEDURE check_Cal_Crt_Rec_Req_Items(

Line 859: x_return_status := FND_API.g_ret_sts_success;

855: x_return_status OUT NOCOPY VARCHAR2
856: )
857: IS
858: BEGIN
859: x_return_status := FND_API.g_ret_sts_success;
860: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
861: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char OR p_cal_crt_rec_rec.object_type_code IS NULL THEN
862: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
863: x_return_status := FND_API.g_ret_sts_error;

Line 861: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char OR p_cal_crt_rec_rec.object_type_code IS NULL THEN

857: IS
858: BEGIN
859: x_return_status := FND_API.g_ret_sts_success;
860: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
861: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char OR p_cal_crt_rec_rec.object_type_code IS NULL THEN
862: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
863: x_return_status := FND_API.g_ret_sts_error;
864: END IF;
865:

Line 863: x_return_status := FND_API.g_ret_sts_error;

859: x_return_status := FND_API.g_ret_sts_success;
860: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
861: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char OR p_cal_crt_rec_rec.object_type_code IS NULL THEN
862: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
863: x_return_status := FND_API.g_ret_sts_error;
864: END IF;
865:
866: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM OR p_cal_crt_rec_rec.last_update_login IS NULL THEN
867: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );

Line 866: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM OR p_cal_crt_rec_rec.last_update_login IS NULL THEN

862: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
863: x_return_status := FND_API.g_ret_sts_error;
864: END IF;
865:
866: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM OR p_cal_crt_rec_rec.last_update_login IS NULL THEN
867: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
868: x_return_status := FND_API.g_ret_sts_error;
869: END IF;
870: ELSE

Line 868: x_return_status := FND_API.g_ret_sts_error;

864: END IF;
865:
866: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM OR p_cal_crt_rec_rec.last_update_login IS NULL THEN
867: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
868: x_return_status := FND_API.g_ret_sts_error;
869: END IF;
870: ELSE
871: IF p_cal_crt_rec_rec.criteria_id = FND_API.G_MISS_NUM THEN
872: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CRITERIA_ID' );

Line 871: IF p_cal_crt_rec_rec.criteria_id = FND_API.G_MISS_NUM THEN

867: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
868: x_return_status := FND_API.g_ret_sts_error;
869: END IF;
870: ELSE
871: IF p_cal_crt_rec_rec.criteria_id = FND_API.G_MISS_NUM THEN
872: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CRITERIA_ID' );
873: x_return_status := FND_API.g_ret_sts_error;
874: END IF;
875:

Line 873: x_return_status := FND_API.g_ret_sts_error;

869: END IF;
870: ELSE
871: IF p_cal_crt_rec_rec.criteria_id = FND_API.G_MISS_NUM THEN
872: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'CRITERIA_ID' );
873: x_return_status := FND_API.g_ret_sts_error;
874: END IF;
875:
876: /*
877: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char THEN

Line 877: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char THEN

873: x_return_status := FND_API.g_ret_sts_error;
874: END IF;
875:
876: /*
877: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char THEN
878: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
879: x_return_status := FND_API.g_ret_sts_error;
880: END IF;
881: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 879: x_return_status := FND_API.g_ret_sts_error;

875:
876: /*
877: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char THEN
878: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
879: x_return_status := FND_API.g_ret_sts_error;
880: END IF;
881: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM THEN
882: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
883: x_return_status := FND_API.g_ret_sts_error;

Line 881: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM THEN

877: IF p_cal_crt_rec_rec.object_type_code = FND_API.g_miss_char THEN
878: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'OBJECT_TYPE_CODE' );
879: x_return_status := FND_API.g_ret_sts_error;
880: END IF;
881: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM THEN
882: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
883: x_return_status := FND_API.g_ret_sts_error;
884: END IF;
885: */

Line 883: x_return_status := FND_API.g_ret_sts_error;

879: x_return_status := FND_API.g_ret_sts_error;
880: END IF;
881: IF p_cal_crt_rec_rec.last_update_login = FND_API.G_MISS_NUM THEN
882: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'LAST_UPDATE_LOGIN' );
883: x_return_status := FND_API.g_ret_sts_error;
884: END IF;
885: */
886: END IF;
887:

Line 896: x_return_status := FND_API.g_ret_sts_success;

892: x_return_status OUT NOCOPY VARCHAR2
893: )
894: IS
895: BEGIN
896: x_return_status := FND_API.g_ret_sts_success;
897: -- Enter custom code here
898: END check_Cal_Crt_Rec_Fk_Items;
899:
900: PROCEDURE check_Cal_Crt_Rec_Lookup_Items(

Line 906: x_return_status := FND_API.g_ret_sts_success;

902: x_return_status OUT NOCOPY VARCHAR2
903: )
904: IS
905: BEGIN
906: x_return_status := FND_API.g_ret_sts_success;
907: -- Enter custom code here
908: END check_Cal_Crt_Rec_Lookup_Items;
909: PROCEDURE Check_Cal_Crt_Rec_Items (
910: P_cal_crt_rec_rec IN cal_crt_rec_rec_type,

Line 918: l_return_status := FND_API.g_ret_sts_success;

914: IS
915: l_return_status VARCHAR2(1);
916: BEGIN
917:
918: l_return_status := FND_API.g_ret_sts_success;
919: -- Charu: Check if the current criteria is duplicate/ subset of an existing criteria
920: check_Cal_crt_rec_Dup_Items(
921: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
922: p_validation_mode => p_validation_mode,

Line 924: IF x_return_status <> FND_API.g_ret_sts_success THEN

920: check_Cal_crt_rec_Dup_Items(
921: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
922: p_validation_mode => p_validation_mode,
923: x_return_status => x_return_status);
924: IF x_return_status <> FND_API.g_ret_sts_success THEN
925: l_return_status := FND_API.g_ret_sts_error;
926: END IF;
927: -- Charu: Check if the current criteria endDate > startDate
928: IF ((p_cal_crt_rec_rec.criteria_start_date IS NOT NULL) AND (p_cal_crt_rec_rec.criteria_end_date IS NOT NULL)

Line 925: l_return_status := FND_API.g_ret_sts_error;

921: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
922: p_validation_mode => p_validation_mode,
923: x_return_status => x_return_status);
924: IF x_return_status <> FND_API.g_ret_sts_success THEN
925: l_return_status := FND_API.g_ret_sts_error;
926: END IF;
927: -- Charu: Check if the current criteria endDate > startDate
928: IF ((p_cal_crt_rec_rec.criteria_start_date IS NOT NULL) AND (p_cal_crt_rec_rec.criteria_end_date IS NOT NULL)
929: AND (p_cal_crt_rec_rec.criteria_end_date < p_cal_crt_rec_rec.criteria_start_date)) THEN

Line 934: RAISE FND_API.G_EXC_ERROR;

930: -- AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_CAL_CRT_INVALID_DATES');
931: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
932: FND_MESSAGE.set_name ('AMS', 'AMS_CAL_CRT_INVALID_DATES');
933: FND_MSG_PUB.add;
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: l_return_status := FND_API.g_ret_sts_error;
937: END IF;
938:

Line 936: l_return_status := FND_API.g_ret_sts_error;

932: FND_MESSAGE.set_name ('AMS', 'AMS_CAL_CRT_INVALID_DATES');
933: FND_MSG_PUB.add;
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: l_return_status := FND_API.g_ret_sts_error;
937: END IF;
938:
939: -- Check Items Uniqueness API calls
940: check_Cal_crt_rec_Uk_Items(

Line 944: IF x_return_status <> FND_API.g_ret_sts_success THEN

940: check_Cal_crt_rec_Uk_Items(
941: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
942: p_validation_mode => p_validation_mode,
943: x_return_status => x_return_status);
944: IF x_return_status <> FND_API.g_ret_sts_success THEN
945: l_return_status := FND_API.g_ret_sts_error;
946: END IF;
947:
948: -- Check Items Required/NOT NULL API calls

Line 945: l_return_status := FND_API.g_ret_sts_error;

941: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
942: p_validation_mode => p_validation_mode,
943: x_return_status => x_return_status);
944: IF x_return_status <> FND_API.g_ret_sts_success THEN
945: l_return_status := FND_API.g_ret_sts_error;
946: END IF;
947:
948: -- Check Items Required/NOT NULL API calls
949: check_cal_crt_rec_req_items(

Line 953: IF x_return_status <> FND_API.g_ret_sts_success THEN

949: check_cal_crt_rec_req_items(
950: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
951: p_validation_mode => p_validation_mode,
952: x_return_status => x_return_status);
953: IF x_return_status <> FND_API.g_ret_sts_success THEN
954: l_return_status := FND_API.g_ret_sts_error;
955: END IF;
956:
957: -- Check Items Foreign Keys API calls

Line 954: l_return_status := FND_API.g_ret_sts_error;

950: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
951: p_validation_mode => p_validation_mode,
952: x_return_status => x_return_status);
953: IF x_return_status <> FND_API.g_ret_sts_success THEN
954: l_return_status := FND_API.g_ret_sts_error;
955: END IF;
956:
957: -- Check Items Foreign Keys API calls
958: check_cal_crt_rec_FK_items(

Line 961: IF x_return_status <> FND_API.g_ret_sts_success THEN

957: -- Check Items Foreign Keys API calls
958: check_cal_crt_rec_FK_items(
959: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
960: x_return_status => x_return_status);
961: IF x_return_status <> FND_API.g_ret_sts_success THEN
962: l_return_status := FND_API.g_ret_sts_error;
963: END IF;
964: -- Check Items Lookups
965: check_cal_crt_rec_Lookup_items(

Line 962: l_return_status := FND_API.g_ret_sts_error;

958: check_cal_crt_rec_FK_items(
959: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
960: x_return_status => x_return_status);
961: IF x_return_status <> FND_API.g_ret_sts_success THEN
962: l_return_status := FND_API.g_ret_sts_error;
963: END IF;
964: -- Check Items Lookups
965: check_cal_crt_rec_Lookup_items(
966: p_cal_crt_rec_rec => p_cal_crt_rec_rec,

Line 968: IF x_return_status <> FND_API.g_ret_sts_success THEN

964: -- Check Items Lookups
965: check_cal_crt_rec_Lookup_items(
966: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
967: x_return_status => x_return_status);
968: IF x_return_status <> FND_API.g_ret_sts_success THEN
969: l_return_status := FND_API.g_ret_sts_error;
970: END IF;
971:
972: x_return_status := l_return_status;

Line 969: l_return_status := FND_API.g_ret_sts_error;

965: check_cal_crt_rec_Lookup_items(
966: p_cal_crt_rec_rec => p_cal_crt_rec_rec,
967: x_return_status => x_return_status);
968: IF x_return_status <> FND_API.g_ret_sts_success THEN
969: l_return_status := FND_API.g_ret_sts_error;
970: END IF;
971:
972: x_return_status := l_return_status;
973: END Check_cal_crt_rec_Items;

Line 1084: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN

1080: l_cal_crt_rec_rec cal_crt_rec_rec_type := p_cal_crt_rec_rec;
1081: BEGIN
1082: -- Developers should put their code to default the record type
1083: -- e.g. IF p_campaign_rec.status_code IS NULL
1084: -- OR p_campaign_rec.status_code = FND_API.G_MISS_CHAR THEN
1085: -- l_campaign_rec.status_code := 'NEW' ;
1086: -- END IF ;
1087: --
1088: NULL ;

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

1098: END;
1099:
1100: PROCEDURE Validate_Cal_Crt(
1101: p_api_version_number IN NUMBER,
1102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1104: p_cal_crt_rec_rec IN cal_crt_rec_rec_type,
1105: p_validation_mode IN VARCHAR2,
1106: x_return_status OUT NOCOPY VARCHAR2,

Line 1103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1099:
1100: PROCEDURE Validate_Cal_Crt(
1101: p_api_version_number IN NUMBER,
1102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1104: p_cal_crt_rec_rec IN cal_crt_rec_rec_type,
1105: p_validation_mode IN VARCHAR2,
1106: x_return_status OUT NOCOPY VARCHAR2,
1107: x_msg_count OUT NOCOPY NUMBER,

Line 1120: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1116: BEGIN
1117: -- Standard Start of API savepoint
1118: SAVEPOINT validate_cal_crt_;
1119: -- Standard call to check for call compatibility.
1120: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1121: p_api_version_number,
1122: l_api_name,
1123: G_PKG_NAME)
1124: THEN

Line 1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1121: p_api_version_number,
1122: l_api_name,
1123: G_PKG_NAME)
1124: THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127: -- Initialize message list if p_init_msg_list is set to TRUE.
1128: IF FND_API.to_Boolean( p_init_msg_list )
1129: THEN

Line 1128: IF FND_API.to_Boolean( p_init_msg_list )

1124: THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: END IF;
1127: -- Initialize message list if p_init_msg_list is set to TRUE.
1128: IF FND_API.to_Boolean( p_init_msg_list )
1129: THEN
1130: FND_MSG_PUB.initialize;
1131: END IF;
1132: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1139: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1135: p_validation_mode => p_validation_mode,
1136:
1137: x_return_status => x_return_status
1138: );
1139: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1140: RAISE FND_API.G_EXC_ERROR;
1141: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1143: END IF;

Line 1140: RAISE FND_API.G_EXC_ERROR;

1136:
1137: x_return_status => x_return_status
1138: );
1139: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1140: RAISE FND_API.G_EXC_ERROR;
1141: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1143: END IF;
1144: END IF;

Line 1141: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1137: x_return_status => x_return_status
1138: );
1139: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1140: RAISE FND_API.G_EXC_ERROR;
1141: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1143: END IF;
1144: END IF;
1145: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1138: );
1139: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1140: RAISE FND_API.G_EXC_ERROR;
1141: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1143: END IF;
1144: END IF;
1145: IF (AMS_DEBUG_HIGH_ON) THEN
1146:

Line 1170: p_init_msg_list => FND_API.G_FALSE,

1166:
1167: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1168: Validate_cal_crt_rec_Rec(
1169: p_api_version_number => 1.0,
1170: p_init_msg_list => FND_API.G_FALSE,
1171: x_return_status => x_return_status,
1172: x_msg_count => x_msg_count,
1173: x_msg_data => x_msg_data,
1174: p_cal_crt_rec_rec => l_cal_crt_rec_rec);

Line 1176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1172: x_msg_count => x_msg_count,
1173: x_msg_data => x_msg_data,
1174: p_cal_crt_rec_rec => l_cal_crt_rec_rec);
1175:
1176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;

Line 1177: RAISE FND_API.G_EXC_ERROR;

1173: x_msg_data => x_msg_data,
1174: p_cal_crt_rec_rec => l_cal_crt_rec_rec);
1175:
1176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;
1181: END IF;

Line 1178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1174: p_cal_crt_rec_rec => l_cal_crt_rec_rec);
1175:
1176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;
1181: END IF;
1182: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1175:
1176: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1177: RAISE FND_API.G_EXC_ERROR;
1178: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1179: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1180: END IF;
1181: END IF;
1182: IF (AMS_DEBUG_HIGH_ON) THEN
1183:

Line 1193: x_return_status := FND_API.G_RET_STS_SUCCESS;

1189: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1190: END IF;
1191:
1192: -- Initialize API return status to SUCCESS
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;
1194: -- Debug Message
1195: IF (AMS_DEBUG_HIGH_ON) THEN
1196: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1197: END IF;

Line 1208: x_return_status := FND_API.g_ret_sts_error;

1204: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'ended fully');
1205: END IF;
1206: EXCEPTION
1207: WHEN AMS_Utility_PVT.resource_locked THEN
1208: x_return_status := FND_API.g_ret_sts_error;
1209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Cal_Crt_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1210: WHEN FND_API.G_EXC_ERROR THEN

1206: EXCEPTION
1207: WHEN AMS_Utility_PVT.resource_locked THEN
1208: x_return_status := FND_API.g_ret_sts_error;
1209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Cal_Crt_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (

Line 1212: x_return_status := FND_API.G_RET_STS_ERROR;

1208: x_return_status := FND_API.g_ret_sts_error;
1209: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1210: WHEN FND_API.G_EXC_ERROR THEN
1211: ROLLBACK TO VALIDATE_Cal_Crt_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,

Line 1215: p_encoded => FND_API.G_FALSE,

1211: ROLLBACK TO VALIDATE_Cal_Crt_;
1212: x_return_status := FND_API.G_RET_STS_ERROR;
1213: -- Standard call to get message count and if count=1, get the message
1214: FND_MSG_PUB.Count_And_Get (
1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1215: p_encoded => FND_API.G_FALSE,
1216: p_count => x_msg_count,
1217: p_data => x_msg_data
1218: );
1219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1220: ROLLBACK TO VALIDATE_Cal_Crt_;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: -- Standard call to get message count and if count=1, get the message
1223: FND_MSG_PUB.Count_And_Get (

Line 1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1217: p_data => x_msg_data
1218: );
1219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1220: ROLLBACK TO VALIDATE_Cal_Crt_;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: -- Standard call to get message count and if count=1, get the message
1223: FND_MSG_PUB.Count_And_Get (
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_msg_count,

Line 1224: p_encoded => FND_API.G_FALSE,

1220: ROLLBACK TO VALIDATE_Cal_Crt_;
1221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1222: -- Standard call to get message count and if count=1, get the message
1223: FND_MSG_PUB.Count_And_Get (
1224: p_encoded => FND_API.G_FALSE,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data
1227: );
1228: WHEN OTHERS THEN

Line 1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1226: p_data => x_msg_data
1227: );
1228: WHEN OTHERS THEN
1229: ROLLBACK TO VALIDATE_Cal_Crt_;
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1232: THEN
1233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1234: END IF;

Line 1237: p_encoded => FND_API.G_FALSE,

1233: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1234: END IF;
1235: -- Standard call to get message count and if count=1, get the message
1236: FND_MSG_PUB.Count_And_Get (
1237: p_encoded => FND_API.G_FALSE,
1238: p_count => x_msg_count,
1239: p_data => x_msg_data
1240: );
1241: End Validate_Cal_Crt;

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

1241: End Validate_Cal_Crt;
1242:
1243: PROCEDURE Validate_Cal_Crt_Rec_Rec (
1244: p_api_version_number IN NUMBER,
1245: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1246: x_return_status OUT NOCOPY VARCHAR2,
1247: x_msg_count OUT NOCOPY NUMBER,
1248: x_msg_data OUT NOCOPY VARCHAR2,
1249: p_cal_crt_rec_rec IN cal_crt_rec_rec_type

Line 1254: IF FND_API.to_Boolean( p_init_msg_list )

1250: )
1251: IS
1252: BEGIN
1253: -- Initialize message list if p_init_msg_list is set to TRUE.
1254: IF FND_API.to_Boolean( p_init_msg_list )
1255: THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258:

Line 1260: x_return_status := FND_API.G_RET_STS_SUCCESS;

1256: FND_MSG_PUB.initialize;
1257: END IF;
1258:
1259: -- Initialize API return status to SUCCESS
1260: x_return_status := FND_API.G_RET_STS_SUCCESS;
1261: -- Hint: Validate data
1262: -- If data not valid
1263: -- THEN
1264: -- x_return_status := FND_API.G_RET_STS_ERROR;

Line 1264: -- x_return_status := FND_API.G_RET_STS_ERROR;

1260: x_return_status := FND_API.G_RET_STS_SUCCESS;
1261: -- Hint: Validate data
1262: -- If data not valid
1263: -- THEN
1264: -- x_return_status := FND_API.G_RET_STS_ERROR;
1265:
1266: -- Debug Message
1267: IF (AMS_DEBUG_HIGH_ON) THEN
1268: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');