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

Line 51: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

47: AMS_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
48:
49: PROCEDURE Create_Venue_Base (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
52: p_commit IN VARCHAR2 := FND_API.g_false,
53: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
54:
55: x_return_status OUT NOCOPY VARCHAR2,

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

48:
49: PROCEDURE Create_Venue_Base (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
52: p_commit IN VARCHAR2 := FND_API.g_false,
53: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
54:
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,

Line 53: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

49: PROCEDURE Create_Venue_Base (
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
52: p_commit IN VARCHAR2 := FND_API.g_false,
53: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
54:
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2,

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

62: );
63:
64: PROCEDURE Update_Venue_Base (
65: p_api_version 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:
70: x_return_status OUT NOCOPY VARCHAR2,

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

63:
64: PROCEDURE Update_Venue_Base (
65: p_api_version 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:
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,

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

64: PROCEDURE Update_Venue_Base (
65: p_api_version 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:
70: x_return_status OUT NOCOPY VARCHAR2,
71: x_msg_count OUT NOCOPY NUMBER,
72: x_msg_data OUT NOCOPY VARCHAR2,

Line 123: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

119: --
120: --------------------------------------------------------------------
121: PROCEDURE Create_Venue (
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
124: p_commit IN VARCHAR2 := FND_API.g_false,
125: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
126:
127: x_return_status OUT NOCOPY VARCHAR2,

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

120: --------------------------------------------------------------------
121: PROCEDURE Create_Venue (
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
124: p_commit IN VARCHAR2 := FND_API.g_false,
125: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
126:
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,

Line 125: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

121: PROCEDURE Create_Venue (
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
124: p_commit IN VARCHAR2 := FND_API.g_false,
125: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
126:
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,

Line 182: IF FND_API.to_boolean (p_init_msg_list) THEN

178: IF (AMS_DEBUG_HIGH_ON) THEN
179: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
180: END IF;
181:
182: IF FND_API.to_boolean (p_init_msg_list) THEN
183: FND_MSG_PUB.initialize;
184: END IF;
185:
186: IF NOT FND_API.compatible_api_call (

Line 186: IF NOT FND_API.compatible_api_call (

182: IF FND_API.to_boolean (p_init_msg_list) THEN
183: FND_MSG_PUB.initialize;
184: END IF;
185:
186: IF NOT FND_API.compatible_api_call (
187: L_API_VERSION,
188: p_api_version,
189: L_API_NAME,
190: G_PKG_NAME

Line 192: RAISE FND_API.g_exc_unexpected_error;

188: p_api_version,
189: L_API_NAME,
190: G_PKG_NAME
191: ) THEN
192: RAISE FND_API.g_exc_unexpected_error;
193: END IF;
194:
195: x_return_status := FND_API.g_ret_sts_success;
196:

Line 195: x_return_status := FND_API.g_ret_sts_success;

191: ) THEN
192: RAISE FND_API.g_exc_unexpected_error;
193: END IF;
194:
195: x_return_status := FND_API.g_ret_sts_success;
196:
197: ----------------------- validate -----------------------
198: IF (AMS_DEBUG_HIGH_ON) THEN
199:

Line 207: RAISE FND_API.g_exc_error;

203: -- Only Validate name here for parties - everything else will be done in the base
204: IF (l_venue_rec.venue_name is null)
205: THEN
206: AMS_Utility_PVT.error_message('AMS_VENUE_NO_VENUE_NAME');
207: RAISE FND_API.g_exc_error;
208: END IF;
209:
210: l_location_rec.address1 := l_venue_rec.address1;
211: l_location_rec.address2 := l_venue_rec.address2;

Line 244: IF l_return_status = FND_API.g_ret_sts_error THEN

240: AMS_Utility_PVT.Debug_Message('Location ID: ' || to_char(l_location_id));
241:
242: END IF;
243:
244: IF l_return_status = FND_API.g_ret_sts_error THEN
245: RAISE FND_API.g_exc_error;
246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
247: RAISE FND_API.g_exc_unexpected_error;
248: END IF;

Line 245: RAISE FND_API.g_exc_error;

241:
242: END IF;
243:
244: IF l_return_status = FND_API.g_ret_sts_error THEN
245: RAISE FND_API.g_exc_error;
246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
247: RAISE FND_API.g_exc_unexpected_error;
248: END IF;
249:

Line 246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

242: END IF;
243:
244: IF l_return_status = FND_API.g_ret_sts_error THEN
245: RAISE FND_API.g_exc_error;
246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
247: RAISE FND_API.g_exc_unexpected_error;
248: END IF;
249:
250: l_org_rec.organization_name := l_venue_rec.venue_name;

Line 247: RAISE FND_API.g_exc_unexpected_error;

243:
244: IF l_return_status = FND_API.g_ret_sts_error THEN
245: RAISE FND_API.g_exc_error;
246: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
247: RAISE FND_API.g_exc_unexpected_error;
248: END IF;
249:
250: l_org_rec.organization_name := l_venue_rec.venue_name;
251: l_org_rec.created_by_module := 'AMS_EVENT';

Line 273: IF l_return_status = FND_API.g_ret_sts_error THEN

269: AMS_Utility_PVT.Debug_Message('Party ID: ' || to_char(l_party_id));
270:
271: END IF;
272:
273: IF l_return_status = FND_API.g_ret_sts_error THEN
274: RAISE FND_API.g_exc_error;
275: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
276: RAISE FND_API.g_exc_unexpected_error;
277: END IF;

Line 274: RAISE FND_API.g_exc_error;

270:
271: END IF;
272:
273: IF l_return_status = FND_API.g_ret_sts_error THEN
274: RAISE FND_API.g_exc_error;
275: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
276: RAISE FND_API.g_exc_unexpected_error;
277: END IF;
278:

Line 275: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

271: END IF;
272:
273: IF l_return_status = FND_API.g_ret_sts_error THEN
274: RAISE FND_API.g_exc_error;
275: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
276: RAISE FND_API.g_exc_unexpected_error;
277: END IF;
278:
279: -- dhsingh start

Line 276: RAISE FND_API.g_exc_unexpected_error;

272:
273: IF l_return_status = FND_API.g_ret_sts_error THEN
274: RAISE FND_API.g_exc_error;
275: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
276: RAISE FND_API.g_exc_unexpected_error;
277: END IF;
278:
279: -- dhsingh start
280: l_code_assignment_rec_type.owner_table_name := 'HZ_PARTIES';

Line 299: IF l_return_status = FND_API.g_ret_sts_error THEN

295: , x_msg_data => x_msg_data
296: , x_code_assignment_id => l_code_assignment_id
297: );
298:
299: IF l_return_status = FND_API.g_ret_sts_error THEN
300: RAISE FND_API.g_exc_error;
301: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
302: RAISE FND_API.g_exc_unexpected_error;
303: END IF;

Line 300: RAISE FND_API.g_exc_error;

296: , x_code_assignment_id => l_code_assignment_id
297: );
298:
299: IF l_return_status = FND_API.g_ret_sts_error THEN
300: RAISE FND_API.g_exc_error;
301: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
302: RAISE FND_API.g_exc_unexpected_error;
303: END IF;
304: -- end dhsingh

Line 301: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

297: );
298:
299: IF l_return_status = FND_API.g_ret_sts_error THEN
300: RAISE FND_API.g_exc_error;
301: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
302: RAISE FND_API.g_exc_unexpected_error;
303: END IF;
304: -- end dhsingh
305: l_psite_rec.party_id := l_party_id;

Line 302: RAISE FND_API.g_exc_unexpected_error;

298:
299: IF l_return_status = FND_API.g_ret_sts_error THEN
300: RAISE FND_API.g_exc_error;
301: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
302: RAISE FND_API.g_exc_unexpected_error;
303: END IF;
304: -- end dhsingh
305: l_psite_rec.party_id := l_party_id;
306: l_psite_rec.location_id := l_location_id;

Line 313: , p_commit => FND_API.g_false

309: -- psite_rec.status := 'A';
310: /*
311: hz_party_pub.create_party_site( p_api_version => 1.0
312: , p_init_msg_list => p_init_msg_list
313: , p_commit => FND_API.g_false
314: , p_party_site_rec => l_psite_rec
315: , x_return_status => l_return_status
316: , x_msg_count => x_msg_count
317: , x_msg_data => x_msg_data

Line 343: IF l_return_status = FND_API.g_ret_sts_error THEN

339: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_id));
340:
341: END IF;
342:
343: IF l_return_status = FND_API.g_ret_sts_error THEN
344: RAISE FND_API.g_exc_error;
345: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
346: RAISE FND_API.g_exc_unexpected_error;
347: END IF;

Line 344: RAISE FND_API.g_exc_error;

340:
341: END IF;
342:
343: IF l_return_status = FND_API.g_ret_sts_error THEN
344: RAISE FND_API.g_exc_error;
345: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
346: RAISE FND_API.g_exc_unexpected_error;
347: END IF;
348:

Line 345: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

341: END IF;
342:
343: IF l_return_status = FND_API.g_ret_sts_error THEN
344: RAISE FND_API.g_exc_error;
345: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
346: RAISE FND_API.g_exc_unexpected_error;
347: END IF;
348:
349: -- start dhsingh

Line 346: RAISE FND_API.g_exc_unexpected_error;

342:
343: IF l_return_status = FND_API.g_ret_sts_error THEN
344: RAISE FND_API.g_exc_error;
345: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
346: RAISE FND_API.g_exc_unexpected_error;
347: END IF;
348:
349: -- start dhsingh
350: l_party_site_use_rec.party_site_id := l_party_site_id ;

Line 356: , p_commit => FND_API.G_false

352: l_party_site_use_rec.created_by_module := 'AMS_EVENT';
353: /*
354: hz_party_pub.create_party_site_use( p_api_version => 1.0
355: , p_init_msg_list => p_init_msg_list
356: , p_commit => FND_API.G_false
357: , p_party_site_use_rec => l_party_site_use_rec
358: , x_return_status => l_return_status
359: , x_msg_count => x_msg_count
360: , x_msg_data => x_msg_data

Line 376: IF l_return_status = FND_API.g_ret_sts_error THEN

372: , x_party_site_use_id => l_party_site_use_id
373: );
374: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_use_id));
375:
376: IF l_return_status = FND_API.g_ret_sts_error THEN
377: RAISE FND_API.g_exc_error;
378: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
379: RAISE FND_API.g_exc_unexpected_error;
380: END IF;

Line 377: RAISE FND_API.g_exc_error;

373: );
374: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_use_id));
375:
376: IF l_return_status = FND_API.g_ret_sts_error THEN
377: RAISE FND_API.g_exc_error;
378: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
379: RAISE FND_API.g_exc_unexpected_error;
380: END IF;
381:

Line 378: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

374: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_use_id));
375:
376: IF l_return_status = FND_API.g_ret_sts_error THEN
377: RAISE FND_API.g_exc_error;
378: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
379: RAISE FND_API.g_exc_unexpected_error;
380: END IF;
381:
382: -- end dhsingh

Line 379: RAISE FND_API.g_exc_unexpected_error;

375:
376: IF l_return_status = FND_API.g_ret_sts_error THEN
377: RAISE FND_API.g_exc_error;
378: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
379: RAISE FND_API.g_exc_unexpected_error;
380: END IF;
381:
382: -- end dhsingh
383:

Line 404: , p_commit => FND_API.g_false

400: l_sales_team_rec.salesforce_role_code := FND_PROFILE.value('AS_DEF_CUST_ST_ROLE');
401:
402: as_access_pub.create_salesteam( p_api_version_number => 2.0
403: , p_init_msg_list => p_init_msg_list
404: , p_commit => FND_API.g_false
405: , p_validation_level => p_validation_level
406: , p_access_profile_rec => NULL
407: , p_check_access_flag => 'N'
408: , p_admin_flag => 'N'

Line 426: IF l_return_status = FND_API.g_ret_sts_error THEN

422: AMS_Utility_PVT.Debug_Message('Access ID: ' || to_char(l_access_id));
423:
424: END IF;
425:
426: IF l_return_status = FND_API.g_ret_sts_error THEN
427: RAISE FND_API.g_exc_error;
428: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
429: RAISE FND_API.g_exc_unexpected_error;
430: END IF;

Line 427: RAISE FND_API.g_exc_error;

423:
424: END IF;
425:
426: IF l_return_status = FND_API.g_ret_sts_error THEN
427: RAISE FND_API.g_exc_error;
428: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
429: RAISE FND_API.g_exc_unexpected_error;
430: END IF;
431:

Line 428: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

424: END IF;
425:
426: IF l_return_status = FND_API.g_ret_sts_error THEN
427: RAISE FND_API.g_exc_error;
428: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
429: RAISE FND_API.g_exc_unexpected_error;
430: END IF;
431:
432: END IF; -- Create row in AS_ACCESSES_ALL

Line 429: RAISE FND_API.g_exc_unexpected_error;

425:
426: IF l_return_status = FND_API.g_ret_sts_error THEN
427: RAISE FND_API.g_exc_error;
428: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
429: RAISE FND_API.g_exc_unexpected_error;
430: END IF;
431:
432: END IF; -- Create row in AS_ACCESSES_ALL
433: */

Line 436: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

432: END IF; -- Create row in AS_ACCESSES_ALL
433: */
434:
435: /*
436: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
437: l_venue_rec.location_id := l_location_id;
438: END IF;
439: */
440: l_venue_rec.party_id := l_party_id;

Line 455: WHEN FND_API.g_exc_error THEN

451: , x_venue_id => x_venue_id
452: );
453:
454: EXCEPTION
455: WHEN FND_API.g_exc_error THEN
456: ROLLBACK TO Create_Venue;
457: x_return_status := FND_API.g_ret_sts_error;
458: FND_MSG_PUB.count_and_get(
459: p_encoded => FND_API.g_false,

Line 457: x_return_status := FND_API.g_ret_sts_error;

453:
454: EXCEPTION
455: WHEN FND_API.g_exc_error THEN
456: ROLLBACK TO Create_Venue;
457: x_return_status := FND_API.g_ret_sts_error;
458: FND_MSG_PUB.count_and_get(
459: p_encoded => FND_API.g_false,
460: p_count => x_msg_count,
461: p_data => x_msg_data

Line 459: p_encoded => FND_API.g_false,

455: WHEN FND_API.g_exc_error THEN
456: ROLLBACK TO Create_Venue;
457: x_return_status := FND_API.g_ret_sts_error;
458: FND_MSG_PUB.count_and_get(
459: p_encoded => FND_API.g_false,
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463: WHEN FND_API.g_exc_unexpected_error THEN

Line 463: WHEN FND_API.g_exc_unexpected_error THEN

459: p_encoded => FND_API.g_false,
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463: WHEN FND_API.g_exc_unexpected_error THEN
464: ROLLBACK TO Create_Venue;
465: x_return_status := FND_API.g_ret_sts_unexp_error ;
466: FND_MSG_PUB.count_and_get (
467: p_encoded => FND_API.g_false,

Line 465: x_return_status := FND_API.g_ret_sts_unexp_error ;

461: p_data => x_msg_data
462: );
463: WHEN FND_API.g_exc_unexpected_error THEN
464: ROLLBACK TO Create_Venue;
465: x_return_status := FND_API.g_ret_sts_unexp_error ;
466: FND_MSG_PUB.count_and_get (
467: p_encoded => FND_API.g_false,
468: p_count => x_msg_count,
469: p_data => x_msg_data

Line 467: p_encoded => FND_API.g_false,

463: WHEN FND_API.g_exc_unexpected_error THEN
464: ROLLBACK TO Create_Venue;
465: x_return_status := FND_API.g_ret_sts_unexp_error ;
466: FND_MSG_PUB.count_and_get (
467: p_encoded => FND_API.g_false,
468: p_count => x_msg_count,
469: p_data => x_msg_data
470: );
471: WHEN OTHERS THEN

Line 473: x_return_status := FND_API.g_ret_sts_unexp_error ;

469: p_data => x_msg_data
470: );
471: WHEN OTHERS THEN
472: ROLLBACK TO Create_Venue;
473: x_return_status := FND_API.g_ret_sts_unexp_error ;
474:
475: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
476: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
477: END IF;

Line 480: p_encoded => FND_API.g_false,

476: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
477: END IF;
478:
479: FND_MSG_PUB.count_and_get (
480: p_encoded => FND_API.g_false,
481: p_count => x_msg_count,
482: p_data => x_msg_data
483: );
484:

Line 494: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

490: --
491: --------------------------------------------------------------------
492: PROCEDURE Create_Room (
493: p_api_version IN NUMBER,
494: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
495: p_commit IN VARCHAR2 := FND_API.g_false,
496: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
497:
498: x_return_status OUT NOCOPY VARCHAR2,

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

491: --------------------------------------------------------------------
492: PROCEDURE Create_Room (
493: p_api_version IN NUMBER,
494: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
495: p_commit IN VARCHAR2 := FND_API.g_false,
496: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
497:
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,

Line 496: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

492: PROCEDURE Create_Room (
493: p_api_version IN NUMBER,
494: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
495: p_commit IN VARCHAR2 := FND_API.g_false,
496: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
497:
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,

Line 528: IF FND_API.to_boolean (p_init_msg_list) THEN

524: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
525:
526: END IF;
527:
528: IF FND_API.to_boolean (p_init_msg_list) THEN
529: FND_MSG_PUB.initialize;
530: END IF;
531:
532: IF NOT FND_API.compatible_api_call (

Line 532: IF NOT FND_API.compatible_api_call (

528: IF FND_API.to_boolean (p_init_msg_list) THEN
529: FND_MSG_PUB.initialize;
530: END IF;
531:
532: IF NOT FND_API.compatible_api_call (
533: L_API_VERSION,
534: p_api_version,
535: L_API_NAME,
536: G_PKG_NAME

Line 538: RAISE FND_API.g_exc_unexpected_error;

534: p_api_version,
535: L_API_NAME,
536: G_PKG_NAME
537: ) THEN
538: RAISE FND_API.g_exc_unexpected_error;
539: END IF;
540:
541: IF l_venue_rec.venue_type_code IS NULL THEN
542: l_venue_rec.venue_type_code := 'ROOM';

Line 545: x_return_status := FND_API.g_ret_sts_success;

541: IF l_venue_rec.venue_type_code IS NULL THEN
542: l_venue_rec.venue_type_code := 'ROOM';
543: END IF;
544:
545: x_return_status := FND_API.g_ret_sts_success;
546:
547: Create_Venue_Base( p_api_version => p_api_version
548: , p_init_msg_list => p_init_msg_list
549: , p_commit => p_commit

Line 560: WHEN FND_API.g_exc_error THEN

556: , x_venue_id => x_venue_id
557: );
558:
559: EXCEPTION
560: WHEN FND_API.g_exc_error THEN
561: ROLLBACK TO Create_Venue;
562: x_return_status := FND_API.g_ret_sts_error;
563: FND_MSG_PUB.count_and_get(
564: p_encoded => FND_API.g_false,

Line 562: x_return_status := FND_API.g_ret_sts_error;

558:
559: EXCEPTION
560: WHEN FND_API.g_exc_error THEN
561: ROLLBACK TO Create_Venue;
562: x_return_status := FND_API.g_ret_sts_error;
563: FND_MSG_PUB.count_and_get(
564: p_encoded => FND_API.g_false,
565: p_count => x_msg_count,
566: p_data => x_msg_data

Line 564: p_encoded => FND_API.g_false,

560: WHEN FND_API.g_exc_error THEN
561: ROLLBACK TO Create_Venue;
562: x_return_status := FND_API.g_ret_sts_error;
563: FND_MSG_PUB.count_and_get(
564: p_encoded => FND_API.g_false,
565: p_count => x_msg_count,
566: p_data => x_msg_data
567: );
568: WHEN FND_API.g_exc_unexpected_error THEN

Line 568: WHEN FND_API.g_exc_unexpected_error THEN

564: p_encoded => FND_API.g_false,
565: p_count => x_msg_count,
566: p_data => x_msg_data
567: );
568: WHEN FND_API.g_exc_unexpected_error THEN
569: ROLLBACK TO Create_Venue;
570: x_return_status := FND_API.g_ret_sts_unexp_error ;
571: FND_MSG_PUB.count_and_get (
572: p_encoded => FND_API.g_false,

Line 570: x_return_status := FND_API.g_ret_sts_unexp_error ;

566: p_data => x_msg_data
567: );
568: WHEN FND_API.g_exc_unexpected_error THEN
569: ROLLBACK TO Create_Venue;
570: x_return_status := FND_API.g_ret_sts_unexp_error ;
571: FND_MSG_PUB.count_and_get (
572: p_encoded => FND_API.g_false,
573: p_count => x_msg_count,
574: p_data => x_msg_data

Line 572: p_encoded => FND_API.g_false,

568: WHEN FND_API.g_exc_unexpected_error THEN
569: ROLLBACK TO Create_Venue;
570: x_return_status := FND_API.g_ret_sts_unexp_error ;
571: FND_MSG_PUB.count_and_get (
572: p_encoded => FND_API.g_false,
573: p_count => x_msg_count,
574: p_data => x_msg_data
575: );
576: WHEN OTHERS THEN

Line 578: x_return_status := FND_API.g_ret_sts_unexp_error ;

574: p_data => x_msg_data
575: );
576: WHEN OTHERS THEN
577: ROLLBACK TO Create_Venue;
578: x_return_status := FND_API.g_ret_sts_unexp_error ;
579:
580: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
581: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
582: END IF;

Line 585: p_encoded => FND_API.g_false,

581: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
582: END IF;
583:
584: FND_MSG_PUB.count_and_get (
585: p_encoded => FND_API.g_false,
586: p_count => x_msg_count,
587: p_data => x_msg_data
588: );
589:

Line 600: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

596: --
597: --------------------------------------------------------------------
598: PROCEDURE Create_Venue_Base (
599: p_api_version IN NUMBER,
600: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
601: p_commit IN VARCHAR2 := FND_API.g_false,
602: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
603:
604: x_return_status OUT NOCOPY VARCHAR2,

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

597: --------------------------------------------------------------------
598: PROCEDURE Create_Venue_Base (
599: p_api_version IN NUMBER,
600: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
601: p_commit IN VARCHAR2 := FND_API.g_false,
602: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
603:
604: x_return_status OUT NOCOPY VARCHAR2,
605: x_msg_count OUT NOCOPY NUMBER,

Line 602: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

598: PROCEDURE Create_Venue_Base (
599: p_api_version IN NUMBER,
600: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
601: p_commit IN VARCHAR2 := FND_API.g_false,
602: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
603:
604: x_return_status OUT NOCOPY VARCHAR2,
605: x_msg_count OUT NOCOPY NUMBER,
606: x_msg_data OUT NOCOPY VARCHAR2,

Line 647: x_return_status := FND_API.g_ret_sts_success;

643: FROM dual;
644:
645: BEGIN
646:
647: x_return_status := FND_API.g_ret_sts_success;
648:
649: Validate_Venue (
650: p_api_version => l_api_version,
651: p_init_msg_list => p_init_msg_list,

Line 660: IF l_return_status = FND_API.g_ret_sts_error THEN

656: p_venue_rec => l_venue_rec,
657: p_object_type => p_object_type
658: );
659:
660: IF l_return_status = FND_API.g_ret_sts_error THEN
661: RAISE FND_API.g_exc_error;
662: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
663: RAISE FND_API.g_exc_unexpected_error;
664: END IF;

Line 661: RAISE FND_API.g_exc_error;

657: p_object_type => p_object_type
658: );
659:
660: IF l_return_status = FND_API.g_ret_sts_error THEN
661: RAISE FND_API.g_exc_error;
662: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
663: RAISE FND_API.g_exc_unexpected_error;
664: END IF;
665:

Line 662: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

658: );
659:
660: IF l_return_status = FND_API.g_ret_sts_error THEN
661: RAISE FND_API.g_exc_error;
662: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
663: RAISE FND_API.g_exc_unexpected_error;
664: END IF;
665:
666: IF (AMS_DEBUG_HIGH_ON) THEN

Line 663: RAISE FND_API.g_exc_unexpected_error;

659:
660: IF l_return_status = FND_API.g_ret_sts_error THEN
661: RAISE FND_API.g_exc_error;
662: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
663: RAISE FND_API.g_exc_unexpected_error;
664: END IF;
665:
666: IF (AMS_DEBUG_HIGH_ON) THEN
667:

Line 855: P_COMMIT => FND_API.g_false,

851:
852: JTF_RS_RESOURCE_PUB.CREATE_RESOURCE(
853: P_API_VERSION => 1.0,
854: P_INIT_MSG_LIST => p_init_msg_list,
855: P_COMMIT => FND_API.g_false,
856: P_CATEGORY => l_category,
857: p_source_id => l_source_id,
858: P_START_DATE_ACTIVE => l_date,
859: P_RESOURCE_NAME => l_venue_rec.venue_name,

Line 867: IF l_return_status = FND_API.g_ret_sts_error THEN

863: x_msg_data => x_msg_data,
864: x_resource_id => x_resource_id,
865: x_resource_number => x_resource_number
866: );
867: IF l_return_status = FND_API.g_ret_sts_error THEN
868: RAISE FND_API.g_exc_error;
869: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
870: RAISE FND_API.g_exc_unexpected_error;
871: END IF;

Line 868: RAISE FND_API.g_exc_error;

864: x_resource_id => x_resource_id,
865: x_resource_number => x_resource_number
866: );
867: IF l_return_status = FND_API.g_ret_sts_error THEN
868: RAISE FND_API.g_exc_error;
869: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
870: RAISE FND_API.g_exc_unexpected_error;
871: END IF;
872:

Line 869: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

865: x_resource_number => x_resource_number
866: );
867: IF l_return_status = FND_API.g_ret_sts_error THEN
868: RAISE FND_API.g_exc_error;
869: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
870: RAISE FND_API.g_exc_unexpected_error;
871: END IF;
872:
873:

Line 870: RAISE FND_API.g_exc_unexpected_error;

866: );
867: IF l_return_status = FND_API.g_ret_sts_error THEN
868: RAISE FND_API.g_exc_error;
869: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
870: RAISE FND_API.g_exc_unexpected_error;
871: END IF;
872:
873:
874: -- GDEODHAR : Sept. 29, 2000 : Changed the p_commit to false in the above call.

Line 885: IF FND_API.To_Boolean ( p_commit ) THEN

881: -- END of API body.
882: --
883:
884: -- Standard check of p_commit.
885: IF FND_API.To_Boolean ( p_commit ) THEN
886: COMMIT WORK;
887: END IF;
888:
889: FND_MSG_PUB.count_and_get(

Line 890: p_encoded => FND_API.g_false,

886: COMMIT WORK;
887: END IF;
888:
889: FND_MSG_PUB.count_and_get(
890: p_encoded => FND_API.g_false,
891: p_count => x_msg_count,
892: p_data => x_msg_data
893: );
894:

Line 898: WHEN FND_API.g_exc_error THEN

894:
895: --IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message (l_full_name || ': End');END IF;
896:
897: EXCEPTION
898: WHEN FND_API.g_exc_error THEN
899: ROLLBACK TO Create_Venue;
900: x_return_status := FND_API.g_ret_sts_error;
901: FND_MSG_PUB.count_and_get(
902: p_encoded => FND_API.g_false,

Line 900: x_return_status := FND_API.g_ret_sts_error;

896:
897: EXCEPTION
898: WHEN FND_API.g_exc_error THEN
899: ROLLBACK TO Create_Venue;
900: x_return_status := FND_API.g_ret_sts_error;
901: FND_MSG_PUB.count_and_get(
902: p_encoded => FND_API.g_false,
903: p_count => x_msg_count,
904: p_data => x_msg_data

Line 902: p_encoded => FND_API.g_false,

898: WHEN FND_API.g_exc_error THEN
899: ROLLBACK TO Create_Venue;
900: x_return_status := FND_API.g_ret_sts_error;
901: FND_MSG_PUB.count_and_get(
902: p_encoded => FND_API.g_false,
903: p_count => x_msg_count,
904: p_data => x_msg_data
905: );
906: WHEN FND_API.g_exc_unexpected_error THEN

Line 906: WHEN FND_API.g_exc_unexpected_error THEN

902: p_encoded => FND_API.g_false,
903: p_count => x_msg_count,
904: p_data => x_msg_data
905: );
906: WHEN FND_API.g_exc_unexpected_error THEN
907: ROLLBACK TO Create_Venue;
908: x_return_status := FND_API.g_ret_sts_unexp_error ;
909: FND_MSG_PUB.count_and_get (
910: p_encoded => FND_API.g_false,

Line 908: x_return_status := FND_API.g_ret_sts_unexp_error ;

904: p_data => x_msg_data
905: );
906: WHEN FND_API.g_exc_unexpected_error THEN
907: ROLLBACK TO Create_Venue;
908: x_return_status := FND_API.g_ret_sts_unexp_error ;
909: FND_MSG_PUB.count_and_get (
910: p_encoded => FND_API.g_false,
911: p_count => x_msg_count,
912: p_data => x_msg_data

Line 910: p_encoded => FND_API.g_false,

906: WHEN FND_API.g_exc_unexpected_error THEN
907: ROLLBACK TO Create_Venue;
908: x_return_status := FND_API.g_ret_sts_unexp_error ;
909: FND_MSG_PUB.count_and_get (
910: p_encoded => FND_API.g_false,
911: p_count => x_msg_count,
912: p_data => x_msg_data
913: );
914: WHEN OTHERS THEN

Line 916: x_return_status := FND_API.g_ret_sts_unexp_error ;

912: p_data => x_msg_data
913: );
914: WHEN OTHERS THEN
915: ROLLBACK TO Create_Venue;
916: x_return_status := FND_API.g_ret_sts_unexp_error ;
917:
918: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
919: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
920: END IF;

Line 923: p_encoded => FND_API.g_false,

919: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
920: END IF;
921:
922: FND_MSG_PUB.count_and_get (
923: p_encoded => FND_API.g_false,
924: p_count => x_msg_count,
925: p_data => x_msg_data
926: );
927: END Create_Venue_Base;

Line 937: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

933: --
934: --------------------------------------------------------------------
935: PROCEDURE Update_Venue (
936: p_api_version IN NUMBER,
937: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
938: p_commit IN VARCHAR2 := FND_API.g_false,
939: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
940:
941: x_return_status OUT NOCOPY VARCHAR2,

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

934: --------------------------------------------------------------------
935: PROCEDURE Update_Venue (
936: p_api_version IN NUMBER,
937: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
938: p_commit IN VARCHAR2 := FND_API.g_false,
939: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
940:
941: x_return_status OUT NOCOPY VARCHAR2,
942: x_msg_count OUT NOCOPY NUMBER,

Line 939: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

935: PROCEDURE Update_Venue (
936: p_api_version IN NUMBER,
937: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
938: p_commit IN VARCHAR2 := FND_API.g_false,
939: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
940:
941: x_return_status OUT NOCOPY VARCHAR2,
942: x_msg_count OUT NOCOPY NUMBER,
943: x_msg_data OUT NOCOPY VARCHAR2,

Line 989: IF FND_API.to_boolean (p_init_msg_list) THEN

985: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
986:
987: END IF;
988:
989: IF FND_API.to_boolean (p_init_msg_list) THEN
990: FND_MSG_PUB.initialize;
991: END IF;
992:
993: IF NOT FND_API.compatible_api_call(

Line 993: IF NOT FND_API.compatible_api_call(

989: IF FND_API.to_boolean (p_init_msg_list) THEN
990: FND_MSG_PUB.initialize;
991: END IF;
992:
993: IF NOT FND_API.compatible_api_call(
994: l_api_version,
995: p_api_version,
996: l_api_name,
997: g_pkg_name

Line 999: RAISE FND_API.g_exc_unexpected_error;

995: p_api_version,
996: l_api_name,
997: g_pkg_name
998: ) THEN
999: RAISE FND_API.g_exc_unexpected_error;
1000: END IF;
1001:
1002: x_return_status := FND_API.g_ret_sts_success;
1003:

Line 1002: x_return_status := FND_API.g_ret_sts_success;

998: ) THEN
999: RAISE FND_API.g_exc_unexpected_error;
1000: END IF;
1001:
1002: x_return_status := FND_API.g_ret_sts_success;
1003:
1004: ----------------------- validate ----------------------
1005: IF (AMS_DEBUG_HIGH_ON) THEN
1006:

Line 1013: -- INITILIZED TO FND_API.G_MISS_CHAR'S... FROM ONE OF THE VENUE SCREENS- AMSVENCR.JSP

1009:
1010: -- replace g_miss_char/num/date with current column values
1011: -- 07/10/2000 IMPORTANT THING TO NOTE ABOUT UPDATE VENUES
1012: -- THE WAY SCREEN GOT DESIGNED... DONT BLAME ME.... p_venue_rec NOT
1013: -- INITILIZED TO FND_API.G_MISS_CHAR'S... FROM ONE OF THE VENUE SCREENS- AMSVENCR.JSP
1014: -- WE DONT LOSE ANY INFO BECAUSE THAT SCREEN IS SAME FOR CREATE AND UPDATE..
1015: -- ALL INFO FOR VENUE IS ALWAYS PASSED..
1016:
1017: -- At this point the p_venue_rec has all the data sent from the outside world

Line 1030: RAISE FND_API.g_exc_error;

1026: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1027: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1028: FND_MSG_PUB.add;
1029: END IF;
1030: RAISE FND_API.g_exc_error;
1031: END IF;
1032: CLOSE c_location;
1033: /*
1034:

Line 1081: IF l_return_status = FND_API.g_ret_sts_error THEN

1077: -- Changed the commit flag to false for the above call.
1078: -- This could potentially give the savepoint not established error.
1079: -- Refer to the create procedure for more details.
1080:
1081: IF l_return_status = FND_API.g_ret_sts_error THEN
1082: RAISE FND_API.g_exc_error;
1083: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1084: RAISE FND_API.g_exc_unexpected_error;
1085: END IF;

Line 1082: RAISE FND_API.g_exc_error;

1078: -- This could potentially give the savepoint not established error.
1079: -- Refer to the create procedure for more details.
1080:
1081: IF l_return_status = FND_API.g_ret_sts_error THEN
1082: RAISE FND_API.g_exc_error;
1083: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1084: RAISE FND_API.g_exc_unexpected_error;
1085: END IF;
1086:

Line 1083: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1079: -- Refer to the create procedure for more details.
1080:
1081: IF l_return_status = FND_API.g_ret_sts_error THEN
1082: RAISE FND_API.g_exc_error;
1083: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1084: RAISE FND_API.g_exc_unexpected_error;
1085: END IF;
1086:
1087: l_psite_rec.party_id := l_venue_rec.party_id;

Line 1084: RAISE FND_API.g_exc_unexpected_error;

1080:
1081: IF l_return_status = FND_API.g_ret_sts_error THEN
1082: RAISE FND_API.g_exc_error;
1083: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1084: RAISE FND_API.g_exc_unexpected_error;
1085: END IF;
1086:
1087: l_psite_rec.party_id := l_venue_rec.party_id;
1088: l_psite_rec.location_id := l_location_id;

Line 1111: IF l_return_status = FND_API.g_ret_sts_error THEN

1107: AMS_Utility_PVT.Debug_Message('Party Site ID: ' || to_char(l_party_site_id));
1108:
1109: END IF;
1110:
1111: IF l_return_status = FND_API.g_ret_sts_error THEN
1112: RAISE FND_API.g_exc_error;
1113: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1114: RAISE FND_API.g_exc_unexpected_error;
1115: END IF;

Line 1112: RAISE FND_API.g_exc_error;

1108:
1109: END IF;
1110:
1111: IF l_return_status = FND_API.g_ret_sts_error THEN
1112: RAISE FND_API.g_exc_error;
1113: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1114: RAISE FND_API.g_exc_unexpected_error;
1115: END IF;
1116:

Line 1113: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1109: END IF;
1110:
1111: IF l_return_status = FND_API.g_ret_sts_error THEN
1112: RAISE FND_API.g_exc_error;
1113: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1114: RAISE FND_API.g_exc_unexpected_error;
1115: END IF;
1116:
1117: END IF; --check for addr1, city, state, country

Line 1114: RAISE FND_API.g_exc_unexpected_error;

1110:
1111: IF l_return_status = FND_API.g_ret_sts_error THEN
1112: RAISE FND_API.g_exc_error;
1113: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1114: RAISE FND_API.g_exc_unexpected_error;
1115: END IF;
1116:
1117: END IF; --check for addr1, city, state, country
1118: */

Line 1131: IF x_return_status = FND_API.g_ret_sts_error THEN

1127: , p_venue_rec => l_venue_rec
1128: , p_object_type => 'VENU'
1129: );
1130:
1131: IF x_return_status = FND_API.g_ret_sts_error THEN
1132: RAISE FND_API.g_exc_error;
1133: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1134: RAISE FND_API.g_exc_unexpected_error;
1135: END IF;

Line 1132: RAISE FND_API.g_exc_error;

1128: , p_object_type => 'VENU'
1129: );
1130:
1131: IF x_return_status = FND_API.g_ret_sts_error THEN
1132: RAISE FND_API.g_exc_error;
1133: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1134: RAISE FND_API.g_exc_unexpected_error;
1135: END IF;
1136:

Line 1133: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1129: );
1130:
1131: IF x_return_status = FND_API.g_ret_sts_error THEN
1132: RAISE FND_API.g_exc_error;
1133: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1134: RAISE FND_API.g_exc_unexpected_error;
1135: END IF;
1136:
1137:

Line 1134: RAISE FND_API.g_exc_unexpected_error;

1130:
1131: IF x_return_status = FND_API.g_ret_sts_error THEN
1132: RAISE FND_API.g_exc_error;
1133: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1134: RAISE FND_API.g_exc_unexpected_error;
1135: END IF;
1136:
1137:
1138: EXCEPTION

Line 1139: WHEN FND_API.g_exc_error THEN

1135: END IF;
1136:
1137:
1138: EXCEPTION
1139: WHEN FND_API.g_exc_error THEN
1140: ROLLBACK TO Update_Venue;
1141: x_return_status := FND_API.g_ret_sts_error;
1142: FND_MSG_PUB.count_and_get (
1143: p_encoded => FND_API.g_false,

Line 1141: x_return_status := FND_API.g_ret_sts_error;

1137:
1138: EXCEPTION
1139: WHEN FND_API.g_exc_error THEN
1140: ROLLBACK TO Update_Venue;
1141: x_return_status := FND_API.g_ret_sts_error;
1142: FND_MSG_PUB.count_and_get (
1143: p_encoded => FND_API.g_false,
1144: p_count => x_msg_count,
1145: p_data => x_msg_data

Line 1143: p_encoded => FND_API.g_false,

1139: WHEN FND_API.g_exc_error THEN
1140: ROLLBACK TO Update_Venue;
1141: x_return_status := FND_API.g_ret_sts_error;
1142: FND_MSG_PUB.count_and_get (
1143: p_encoded => FND_API.g_false,
1144: p_count => x_msg_count,
1145: p_data => x_msg_data
1146: );
1147: WHEN FND_API.g_exc_unexpected_error THEN

Line 1147: WHEN FND_API.g_exc_unexpected_error THEN

1143: p_encoded => FND_API.g_false,
1144: p_count => x_msg_count,
1145: p_data => x_msg_data
1146: );
1147: WHEN FND_API.g_exc_unexpected_error THEN
1148: ROLLBACK TO Update_Venue;
1149: x_return_status := FND_API.g_ret_sts_unexp_error ;
1150: FND_MSG_PUB.count_and_get (
1151: p_encoded => FND_API.g_false,

Line 1149: x_return_status := FND_API.g_ret_sts_unexp_error ;

1145: p_data => x_msg_data
1146: );
1147: WHEN FND_API.g_exc_unexpected_error THEN
1148: ROLLBACK TO Update_Venue;
1149: x_return_status := FND_API.g_ret_sts_unexp_error ;
1150: FND_MSG_PUB.count_and_get (
1151: p_encoded => FND_API.g_false,
1152: p_count => x_msg_count,
1153: p_data => x_msg_data

Line 1151: p_encoded => FND_API.g_false,

1147: WHEN FND_API.g_exc_unexpected_error THEN
1148: ROLLBACK TO Update_Venue;
1149: x_return_status := FND_API.g_ret_sts_unexp_error ;
1150: FND_MSG_PUB.count_and_get (
1151: p_encoded => FND_API.g_false,
1152: p_count => x_msg_count,
1153: p_data => x_msg_data
1154: );
1155: WHEN OTHERS THEN

Line 1157: x_return_status := FND_API.g_ret_sts_unexp_error ;

1153: p_data => x_msg_data
1154: );
1155: WHEN OTHERS THEN
1156: ROLLBACK TO Update_Venue;
1157: x_return_status := FND_API.g_ret_sts_unexp_error ;
1158:
1159: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1160: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1161: END IF;

Line 1164: p_encoded => FND_API.g_false,

1160: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1161: END IF;
1162:
1163: FND_MSG_PUB.count_and_get (
1164: p_encoded => FND_API.g_false,
1165: p_count => x_msg_count,
1166: p_data => x_msg_data
1167: );
1168:

Line 1178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1174: --
1175: --------------------------------------------------------------------
1176: PROCEDURE Update_Room (
1177: p_api_version IN NUMBER,
1178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1179: p_commit IN VARCHAR2 := FND_API.g_false,
1180: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1181:
1182: x_return_status OUT NOCOPY VARCHAR2,

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

1175: --------------------------------------------------------------------
1176: PROCEDURE Update_Room (
1177: p_api_version IN NUMBER,
1178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1179: p_commit IN VARCHAR2 := FND_API.g_false,
1180: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1181:
1182: x_return_status OUT NOCOPY VARCHAR2,
1183: x_msg_count OUT NOCOPY NUMBER,

Line 1180: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1176: PROCEDURE Update_Room (
1177: p_api_version IN NUMBER,
1178: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1179: p_commit IN VARCHAR2 := FND_API.g_false,
1180: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1181:
1182: x_return_status OUT NOCOPY VARCHAR2,
1183: x_msg_count OUT NOCOPY NUMBER,
1184: x_msg_data OUT NOCOPY VARCHAR2,

Line 1208: IF FND_API.to_boolean (p_init_msg_list) THEN

1204: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1205:
1206: END IF;
1207:
1208: IF FND_API.to_boolean (p_init_msg_list) THEN
1209: FND_MSG_PUB.initialize;
1210: END IF;
1211:
1212: IF NOT FND_API.compatible_api_call(

Line 1212: IF NOT FND_API.compatible_api_call(

1208: IF FND_API.to_boolean (p_init_msg_list) THEN
1209: FND_MSG_PUB.initialize;
1210: END IF;
1211:
1212: IF NOT FND_API.compatible_api_call(
1213: l_api_version,
1214: p_api_version,
1215: l_api_name,
1216: g_pkg_name

Line 1218: RAISE FND_API.g_exc_unexpected_error;

1214: p_api_version,
1215: l_api_name,
1216: g_pkg_name
1217: ) THEN
1218: RAISE FND_API.g_exc_unexpected_error;
1219: END IF;
1220:
1221: x_return_status := FND_API.g_ret_sts_success;
1222:

Line 1221: x_return_status := FND_API.g_ret_sts_success;

1217: ) THEN
1218: RAISE FND_API.g_exc_unexpected_error;
1219: END IF;
1220:
1221: x_return_status := FND_API.g_ret_sts_success;
1222:
1223: ----------------------- validate ----------------------
1224: IF (AMS_DEBUG_HIGH_ON) THEN
1225:

Line 1232: -- INITILIZED TO FND_API.G_MISS_CHAR'S... FROM ONE OF THE VENUE SCREENS- AMSVENCR.JSP

1228:
1229: -- replace g_miss_char/num/date with current column values
1230: -- 07/10/2000 IMPORTANT THING TO NOTE ABOUT UPDATE VENUES
1231: -- THE WAY SCREEN GOT DESIGNED... DONT BLAME ME.... p_venue_rec NOT
1232: -- INITILIZED TO FND_API.G_MISS_CHAR'S... FROM ONE OF THE VENUE SCREENS- AMSVENCR.JSP
1233: -- WE DONT LOSE ANY INFO BECAUSE THAT SCREEN IS SAME FOR CREATE AND UPDATE..
1234: -- ALL INFO FOR VENUE IS ALWAYS PASSED..
1235:
1236: -- At this point the p_venue_rec has all the data sent from the outside world

Line 1253: WHEN FND_API.g_exc_error THEN

1249: , p_object_type => 'ROOM'
1250: );
1251:
1252: EXCEPTION
1253: WHEN FND_API.g_exc_error THEN
1254: ROLLBACK TO Update_Venue;
1255: x_return_status := FND_API.g_ret_sts_error;
1256: FND_MSG_PUB.count_and_get (
1257: p_encoded => FND_API.g_false,

Line 1255: x_return_status := FND_API.g_ret_sts_error;

1251:
1252: EXCEPTION
1253: WHEN FND_API.g_exc_error THEN
1254: ROLLBACK TO Update_Venue;
1255: x_return_status := FND_API.g_ret_sts_error;
1256: FND_MSG_PUB.count_and_get (
1257: p_encoded => FND_API.g_false,
1258: p_count => x_msg_count,
1259: p_data => x_msg_data

Line 1257: p_encoded => FND_API.g_false,

1253: WHEN FND_API.g_exc_error THEN
1254: ROLLBACK TO Update_Venue;
1255: x_return_status := FND_API.g_ret_sts_error;
1256: FND_MSG_PUB.count_and_get (
1257: p_encoded => FND_API.g_false,
1258: p_count => x_msg_count,
1259: p_data => x_msg_data
1260: );
1261: WHEN FND_API.g_exc_unexpected_error THEN

Line 1261: WHEN FND_API.g_exc_unexpected_error THEN

1257: p_encoded => FND_API.g_false,
1258: p_count => x_msg_count,
1259: p_data => x_msg_data
1260: );
1261: WHEN FND_API.g_exc_unexpected_error THEN
1262: ROLLBACK TO Update_Venue;
1263: x_return_status := FND_API.g_ret_sts_unexp_error ;
1264: FND_MSG_PUB.count_and_get (
1265: p_encoded => FND_API.g_false,

Line 1263: x_return_status := FND_API.g_ret_sts_unexp_error ;

1259: p_data => x_msg_data
1260: );
1261: WHEN FND_API.g_exc_unexpected_error THEN
1262: ROLLBACK TO Update_Venue;
1263: x_return_status := FND_API.g_ret_sts_unexp_error ;
1264: FND_MSG_PUB.count_and_get (
1265: p_encoded => FND_API.g_false,
1266: p_count => x_msg_count,
1267: p_data => x_msg_data

Line 1265: p_encoded => FND_API.g_false,

1261: WHEN FND_API.g_exc_unexpected_error THEN
1262: ROLLBACK TO Update_Venue;
1263: x_return_status := FND_API.g_ret_sts_unexp_error ;
1264: FND_MSG_PUB.count_and_get (
1265: p_encoded => FND_API.g_false,
1266: p_count => x_msg_count,
1267: p_data => x_msg_data
1268: );
1269: WHEN OTHERS THEN

Line 1271: x_return_status := FND_API.g_ret_sts_unexp_error ;

1267: p_data => x_msg_data
1268: );
1269: WHEN OTHERS THEN
1270: ROLLBACK TO Update_Venue;
1271: x_return_status := FND_API.g_ret_sts_unexp_error ;
1272:
1273: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1274: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1275: END IF;

Line 1278: p_encoded => FND_API.g_false,

1274: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1275: END IF;
1276:
1277: FND_MSG_PUB.count_and_get (
1278: p_encoded => FND_API.g_false,
1279: p_count => x_msg_count,
1280: p_data => x_msg_data
1281: );
1282:

Line 1295: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1291: -- address, city, state or country is changed
1292: --------------------------------------------------------------------
1293: PROCEDURE Update_Venue_Base (
1294: p_api_version IN NUMBER,
1295: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1296: p_commit IN VARCHAR2 := FND_API.g_false,
1297: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1298:
1299: x_return_status OUT NOCOPY VARCHAR2,

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

1292: --------------------------------------------------------------------
1293: PROCEDURE Update_Venue_Base (
1294: p_api_version IN NUMBER,
1295: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1296: p_commit IN VARCHAR2 := FND_API.g_false,
1297: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1298:
1299: x_return_status OUT NOCOPY VARCHAR2,
1300: x_msg_count OUT NOCOPY NUMBER,

Line 1297: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1293: PROCEDURE Update_Venue_Base (
1294: p_api_version IN NUMBER,
1295: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1296: p_commit IN VARCHAR2 := FND_API.g_false,
1297: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1298:
1299: x_return_status OUT NOCOPY VARCHAR2,
1300: x_msg_count OUT NOCOPY NUMBER,
1301: x_msg_data OUT NOCOPY VARCHAR2,

Line 1332: x_return_status := FND_API.g_ret_sts_success;

1328: l_return_status VARCHAR2(1);
1329: l_rec_cnt NUMBER;
1330: BEGIN
1331:
1332: x_return_status := FND_API.g_ret_sts_success;
1333:
1334: l_venue_rec := p_venue_rec;
1335:
1336: -- At this point the l_venue_rec has all the data that came from outside and all

Line 1350: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1346: p_validation_mode => JTF_PLSQL_API.g_update,
1347: x_return_status => l_return_status
1348: );
1349:
1350: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1351: RAISE FND_API.g_exc_unexpected_error;
1352: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1353: RAISE FND_API.g_exc_error;
1354: END IF;

Line 1351: RAISE FND_API.g_exc_unexpected_error;

1347: x_return_status => l_return_status
1348: );
1349:
1350: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1351: RAISE FND_API.g_exc_unexpected_error;
1352: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1353: RAISE FND_API.g_exc_error;
1354: END IF;
1355: END IF;

Line 1352: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1348: );
1349:
1350: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1351: RAISE FND_API.g_exc_unexpected_error;
1352: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1353: RAISE FND_API.g_exc_error;
1354: END IF;
1355: END IF;
1356:

Line 1353: RAISE FND_API.g_exc_error;

1349:
1350: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1351: RAISE FND_API.g_exc_unexpected_error;
1352: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1353: RAISE FND_API.g_exc_error;
1354: END IF;
1355: END IF;
1356:
1357: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN

Line 1364: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1360: p_complete_rec => l_venue_rec,
1361: x_return_status => l_return_status
1362: );
1363:
1364: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1365: RAISE FND_API.g_exc_unexpected_error;
1366: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1367: RAISE FND_API.g_exc_error;
1368: END IF;

Line 1365: RAISE FND_API.g_exc_unexpected_error;

1361: x_return_status => l_return_status
1362: );
1363:
1364: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1365: RAISE FND_API.g_exc_unexpected_error;
1366: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1367: RAISE FND_API.g_exc_error;
1368: END IF;
1369: END IF;

Line 1366: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1362: );
1363:
1364: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1365: RAISE FND_API.g_exc_unexpected_error;
1366: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1367: RAISE FND_API.g_exc_error;
1368: END IF;
1369: END IF;
1370: */ -- batoleti

Line 1367: RAISE FND_API.g_exc_error;

1363:
1364: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1365: RAISE FND_API.g_exc_unexpected_error;
1366: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1367: RAISE FND_API.g_exc_error;
1368: END IF;
1369: END IF;
1370: */ -- batoleti
1371: --batoleti

Line 1384: RAISE FND_API.g_exc_error;

1380:
1381: IF (l_rec_cnt > 0) THEN
1382: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_NAME');
1383: FND_MSG_PUB.add;
1384: RAISE FND_API.g_exc_error;
1385: END IF;
1386:
1387:
1388:

Line 1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1443: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1448: END IF;
1449:
1450: UPDATE ams_venues_tl
1451: SET

Line 1466: RAISE FND_API.g_exc_error;

1462: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1463: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1464: FND_MSG_PUB.add;
1465: END IF;
1466: RAISE FND_API.g_exc_error;
1467: END IF;
1468:
1469: -------------------- finish --------------------------
1470: IF FND_API.to_boolean (p_commit) THEN

Line 1470: IF FND_API.to_boolean (p_commit) THEN

1466: RAISE FND_API.g_exc_error;
1467: END IF;
1468:
1469: -------------------- finish --------------------------
1470: IF FND_API.to_boolean (p_commit) THEN
1471: COMMIT;
1472: END IF;
1473:
1474: FND_MSG_PUB.count_and_get (

Line 1475: p_encoded => FND_API.g_false,

1471: COMMIT;
1472: END IF;
1473:
1474: FND_MSG_PUB.count_and_get (
1475: p_encoded => FND_API.g_false,
1476: p_count => x_msg_count,
1477: p_data => x_msg_data
1478: );
1479:

Line 1489: WHEN FND_API.g_exc_error THEN

1485:
1486: END IF;
1487:
1488: EXCEPTION
1489: WHEN FND_API.g_exc_error THEN
1490: ROLLBACK TO Update_Venue;
1491: x_return_status := FND_API.g_ret_sts_error;
1492: FND_MSG_PUB.count_and_get (
1493: p_encoded => FND_API.g_false,

Line 1491: x_return_status := FND_API.g_ret_sts_error;

1487:
1488: EXCEPTION
1489: WHEN FND_API.g_exc_error THEN
1490: ROLLBACK TO Update_Venue;
1491: x_return_status := FND_API.g_ret_sts_error;
1492: FND_MSG_PUB.count_and_get (
1493: p_encoded => FND_API.g_false,
1494: p_count => x_msg_count,
1495: p_data => x_msg_data

Line 1493: p_encoded => FND_API.g_false,

1489: WHEN FND_API.g_exc_error THEN
1490: ROLLBACK TO Update_Venue;
1491: x_return_status := FND_API.g_ret_sts_error;
1492: FND_MSG_PUB.count_and_get (
1493: p_encoded => FND_API.g_false,
1494: p_count => x_msg_count,
1495: p_data => x_msg_data
1496: );
1497: WHEN FND_API.g_exc_unexpected_error THEN

Line 1497: WHEN FND_API.g_exc_unexpected_error THEN

1493: p_encoded => FND_API.g_false,
1494: p_count => x_msg_count,
1495: p_data => x_msg_data
1496: );
1497: WHEN FND_API.g_exc_unexpected_error THEN
1498: ROLLBACK TO Update_Venue;
1499: x_return_status := FND_API.g_ret_sts_unexp_error ;
1500: FND_MSG_PUB.count_and_get (
1501: p_encoded => FND_API.g_false,

Line 1499: x_return_status := FND_API.g_ret_sts_unexp_error ;

1495: p_data => x_msg_data
1496: );
1497: WHEN FND_API.g_exc_unexpected_error THEN
1498: ROLLBACK TO Update_Venue;
1499: x_return_status := FND_API.g_ret_sts_unexp_error ;
1500: FND_MSG_PUB.count_and_get (
1501: p_encoded => FND_API.g_false,
1502: p_count => x_msg_count,
1503: p_data => x_msg_data

Line 1501: p_encoded => FND_API.g_false,

1497: WHEN FND_API.g_exc_unexpected_error THEN
1498: ROLLBACK TO Update_Venue;
1499: x_return_status := FND_API.g_ret_sts_unexp_error ;
1500: FND_MSG_PUB.count_and_get (
1501: p_encoded => FND_API.g_false,
1502: p_count => x_msg_count,
1503: p_data => x_msg_data
1504: );
1505: WHEN OTHERS THEN

Line 1507: x_return_status := FND_API.g_ret_sts_unexp_error ;

1503: p_data => x_msg_data
1504: );
1505: WHEN OTHERS THEN
1506: ROLLBACK TO Update_Venue;
1507: x_return_status := FND_API.g_ret_sts_unexp_error ;
1508:
1509: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1510: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1511: END IF;

Line 1514: p_encoded => FND_API.g_false,

1510: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1511: END IF;
1512:
1513: FND_MSG_PUB.count_and_get (
1514: p_encoded => FND_API.g_false,
1515: p_count => x_msg_count,
1516: p_data => x_msg_data
1517: );
1518: END Update_Venue_Base;

Line 1528: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1524: --
1525: --------------------------------------------------------------------
1526: PROCEDURE Delete_Venue (
1527: p_api_version IN NUMBER,
1528: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1529: p_commit IN VARCHAR2 := FND_API.g_false,
1530: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1531:
1532: x_return_status OUT NOCOPY VARCHAR2,

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

1525: --------------------------------------------------------------------
1526: PROCEDURE Delete_Venue (
1527: p_api_version IN NUMBER,
1528: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1529: p_commit IN VARCHAR2 := FND_API.g_false,
1530: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1531:
1532: x_return_status OUT NOCOPY VARCHAR2,
1533: x_msg_count OUT NOCOPY NUMBER,

Line 1530: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1526: PROCEDURE Delete_Venue (
1527: p_api_version IN NUMBER,
1528: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1529: p_commit IN VARCHAR2 := FND_API.g_false,
1530: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1531:
1532: x_return_status OUT NOCOPY VARCHAR2,
1533: x_msg_count OUT NOCOPY NUMBER,
1534: x_msg_data OUT NOCOPY VARCHAR2,

Line 1555: IF FND_API.to_boolean (p_init_msg_list) THEN

1551: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1552:
1553: END IF;
1554:
1555: IF FND_API.to_boolean (p_init_msg_list) THEN
1556: FND_MSG_PUB.initialize;
1557: END IF;
1558:
1559: IF NOT FND_API.compatible_api_call (

Line 1559: IF NOT FND_API.compatible_api_call (

1555: IF FND_API.to_boolean (p_init_msg_list) THEN
1556: FND_MSG_PUB.initialize;
1557: END IF;
1558:
1559: IF NOT FND_API.compatible_api_call (
1560: l_api_version,
1561: p_api_version,
1562: l_api_name,
1563: g_pkg_name

Line 1565: RAISE FND_API.g_exc_unexpected_error;

1561: p_api_version,
1562: l_api_name,
1563: g_pkg_name
1564: ) THEN
1565: RAISE FND_API.g_exc_unexpected_error;
1566: END IF;
1567:
1568: x_return_status := FND_API.g_ret_sts_success;
1569:

Line 1568: x_return_status := FND_API.g_ret_sts_success;

1564: ) THEN
1565: RAISE FND_API.g_exc_unexpected_error;
1566: END IF;
1567:
1568: x_return_status := FND_API.g_ret_sts_success;
1569:
1570: ------------------------ delete ------------------------
1571: IF (AMS_DEBUG_HIGH_ON) THEN
1572:

Line 1585: RAISE FND_API.g_exc_error;

1581: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1582: FND_MESSAGE.set_name ('AMS', 'AMS_API_RECORD_NOT_FOUND');
1583: FND_MSG_PUB.add;
1584: END IF;
1585: RAISE FND_API.g_exc_error;
1586: END IF;
1587:
1588: DELETE FROM ams_venues_b
1589: WHERE venue_id = p_venue_id

Line 1593: IF FND_API.to_boolean (p_commit) THEN

1589: WHERE venue_id = p_venue_id
1590: AND object_version_number = p_object_version;
1591:
1592: -------------------- finish --------------------------
1593: IF FND_API.to_boolean (p_commit) THEN
1594: COMMIT;
1595: END IF;
1596:
1597: FND_MSG_PUB.count_and_get (

Line 1598: p_encoded => FND_API.g_false,

1594: COMMIT;
1595: END IF;
1596:
1597: FND_MSG_PUB.count_and_get (
1598: p_encoded => FND_API.g_false,
1599: p_count => x_msg_count,
1600: p_data => x_msg_data
1601: );
1602:

Line 1612: WHEN FND_API.g_exc_error THEN

1608:
1609: END IF;
1610:
1611: EXCEPTION
1612: WHEN FND_API.g_exc_error THEN
1613: ROLLBACK TO Delete_Venue;
1614: x_return_status := FND_API.g_ret_sts_error;
1615: FND_MSG_PUB.count_and_get (
1616: p_encoded => FND_API.g_false,

Line 1614: x_return_status := FND_API.g_ret_sts_error;

1610:
1611: EXCEPTION
1612: WHEN FND_API.g_exc_error THEN
1613: ROLLBACK TO Delete_Venue;
1614: x_return_status := FND_API.g_ret_sts_error;
1615: FND_MSG_PUB.count_and_get (
1616: p_encoded => FND_API.g_false,
1617: p_count => x_msg_count,
1618: p_data => x_msg_data

Line 1616: p_encoded => FND_API.g_false,

1612: WHEN FND_API.g_exc_error THEN
1613: ROLLBACK TO Delete_Venue;
1614: x_return_status := FND_API.g_ret_sts_error;
1615: FND_MSG_PUB.count_and_get (
1616: p_encoded => FND_API.g_false,
1617: p_count => x_msg_count,
1618: p_data => x_msg_data
1619: );
1620: WHEN FND_API.g_exc_unexpected_error THEN

Line 1620: WHEN FND_API.g_exc_unexpected_error THEN

1616: p_encoded => FND_API.g_false,
1617: p_count => x_msg_count,
1618: p_data => x_msg_data
1619: );
1620: WHEN FND_API.g_exc_unexpected_error THEN
1621: ROLLBACK TO Delete_Venue;
1622: x_return_status := FND_API.g_ret_sts_unexp_error ;
1623: FND_MSG_PUB.count_and_get (
1624: p_encoded => FND_API.g_false,

Line 1622: x_return_status := FND_API.g_ret_sts_unexp_error ;

1618: p_data => x_msg_data
1619: );
1620: WHEN FND_API.g_exc_unexpected_error THEN
1621: ROLLBACK TO Delete_Venue;
1622: x_return_status := FND_API.g_ret_sts_unexp_error ;
1623: FND_MSG_PUB.count_and_get (
1624: p_encoded => FND_API.g_false,
1625: p_count => x_msg_count,
1626: p_data => x_msg_data

Line 1624: p_encoded => FND_API.g_false,

1620: WHEN FND_API.g_exc_unexpected_error THEN
1621: ROLLBACK TO Delete_Venue;
1622: x_return_status := FND_API.g_ret_sts_unexp_error ;
1623: FND_MSG_PUB.count_and_get (
1624: p_encoded => FND_API.g_false,
1625: p_count => x_msg_count,
1626: p_data => x_msg_data
1627: );
1628: WHEN OTHERS THEN

Line 1630: x_return_status := FND_API.g_ret_sts_unexp_error ;

1626: p_data => x_msg_data
1627: );
1628: WHEN OTHERS THEN
1629: ROLLBACK TO Delete_Venue;
1630: x_return_status := FND_API.g_ret_sts_unexp_error ;
1631:
1632: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1633: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1634: END IF;

Line 1637: p_encoded => FND_API.g_false,

1633: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1634: END IF;
1635:
1636: FND_MSG_PUB.count_and_get (
1637: p_encoded => FND_API.g_false,
1638: p_count => x_msg_count,
1639: p_data => x_msg_data
1640: );
1641: END Delete_Venue;

Line 1651: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1647: --
1648: --------------------------------------------------------------------
1649: PROCEDURE Lock_Venue (
1650: p_api_version IN NUMBER,
1651: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1652: p_commit IN VARCHAR2 := FND_API.g_false,
1653: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1654:
1655: x_return_status OUT NOCOPY VARCHAR2,

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

1648: --------------------------------------------------------------------
1649: PROCEDURE Lock_Venue (
1650: p_api_version IN NUMBER,
1651: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1652: p_commit IN VARCHAR2 := FND_API.g_false,
1653: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1654:
1655: x_return_status OUT NOCOPY VARCHAR2,
1656: x_msg_count OUT NOCOPY NUMBER,

Line 1653: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1649: PROCEDURE Lock_Venue (
1650: p_api_version IN NUMBER,
1651: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1652: p_commit IN VARCHAR2 := FND_API.g_false,
1653: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1654:
1655: x_return_status OUT NOCOPY VARCHAR2,
1656: x_msg_count OUT NOCOPY NUMBER,
1657: x_msg_data OUT NOCOPY VARCHAR2,

Line 1689: IF FND_API.to_boolean (p_init_msg_list) THEN

1685:
1686: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1687: END IF;
1688:
1689: IF FND_API.to_boolean (p_init_msg_list) THEN
1690: FND_MSG_PUB.initialize;
1691: END IF;
1692:
1693: IF NOT FND_API.compatible_api_call (

Line 1693: IF NOT FND_API.compatible_api_call (

1689: IF FND_API.to_boolean (p_init_msg_list) THEN
1690: FND_MSG_PUB.initialize;
1691: END IF;
1692:
1693: IF NOT FND_API.compatible_api_call (
1694: l_api_version,
1695: p_api_version,
1696: l_api_name,
1697: g_pkg_name

Line 1699: RAISE FND_API.g_exc_unexpected_error;

1695: p_api_version,
1696: l_api_name,
1697: g_pkg_name
1698: ) THEN
1699: RAISE FND_API.g_exc_unexpected_error;
1700: END IF;
1701:
1702: x_return_status := FND_API.g_ret_sts_success;
1703:

Line 1702: x_return_status := FND_API.g_ret_sts_success;

1698: ) THEN
1699: RAISE FND_API.g_exc_unexpected_error;
1700: END IF;
1701:
1702: x_return_status := FND_API.g_ret_sts_success;
1703:
1704: ------------------------ lock -------------------------
1705: IF (AMS_DEBUG_HIGH_ON) THEN
1706:

Line 1718: RAISE FND_API.g_exc_error;

1714: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1715: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1716: FND_MSG_PUB.add;
1717: END IF;
1718: RAISE FND_API.g_exc_error;
1719: END IF;
1720: CLOSE c_lock;
1721:
1722: -------------------- finish --------------------------

Line 1724: p_encoded => FND_API.g_false,

1720: CLOSE c_lock;
1721:
1722: -------------------- finish --------------------------
1723: FND_MSG_PUB.count_and_get (
1724: p_encoded => FND_API.g_false,
1725: p_count => x_msg_count,
1726: p_data => x_msg_data
1727: );
1728:

Line 1739: x_return_status := FND_API.g_ret_sts_error;

1735: END IF;
1736:
1737: EXCEPTION
1738: WHEN AMS_Utility_PVT.resource_locked THEN
1739: x_return_status := FND_API.g_ret_sts_error;
1740: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
1741: FND_MESSAGE.set_name ('AMS', 'AMS_API_RESOURCE_LOCKED');
1742: FND_MSG_PUB.add;
1743: END IF;

Line 1746: p_encoded => FND_API.g_false,

1742: FND_MSG_PUB.add;
1743: END IF;
1744:
1745: FND_MSG_PUB.count_and_get (
1746: p_encoded => FND_API.g_false,
1747: p_count => x_msg_count,
1748: p_data => x_msg_data
1749: );
1750: WHEN FND_API.g_exc_error THEN

Line 1750: WHEN FND_API.g_exc_error THEN

1746: p_encoded => FND_API.g_false,
1747: p_count => x_msg_count,
1748: p_data => x_msg_data
1749: );
1750: WHEN FND_API.g_exc_error THEN
1751: x_return_status := FND_API.g_ret_sts_error;
1752: FND_MSG_PUB.count_and_get (
1753: p_encoded => FND_API.g_false,
1754: p_count => x_msg_count,

Line 1751: x_return_status := FND_API.g_ret_sts_error;

1747: p_count => x_msg_count,
1748: p_data => x_msg_data
1749: );
1750: WHEN FND_API.g_exc_error THEN
1751: x_return_status := FND_API.g_ret_sts_error;
1752: FND_MSG_PUB.count_and_get (
1753: p_encoded => FND_API.g_false,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data

Line 1753: p_encoded => FND_API.g_false,

1749: );
1750: WHEN FND_API.g_exc_error THEN
1751: x_return_status := FND_API.g_ret_sts_error;
1752: FND_MSG_PUB.count_and_get (
1753: p_encoded => FND_API.g_false,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data
1756: );
1757: WHEN FND_API.g_exc_unexpected_error THEN

Line 1757: WHEN FND_API.g_exc_unexpected_error THEN

1753: p_encoded => FND_API.g_false,
1754: p_count => x_msg_count,
1755: p_data => x_msg_data
1756: );
1757: WHEN FND_API.g_exc_unexpected_error THEN
1758: x_return_status := FND_API.g_ret_sts_unexp_error ;
1759: FND_MSG_PUB.count_and_get (
1760: p_encoded => FND_API.g_false,
1761: p_count => x_msg_count,

Line 1758: x_return_status := FND_API.g_ret_sts_unexp_error ;

1754: p_count => x_msg_count,
1755: p_data => x_msg_data
1756: );
1757: WHEN FND_API.g_exc_unexpected_error THEN
1758: x_return_status := FND_API.g_ret_sts_unexp_error ;
1759: FND_MSG_PUB.count_and_get (
1760: p_encoded => FND_API.g_false,
1761: p_count => x_msg_count,
1762: p_data => x_msg_data

Line 1760: p_encoded => FND_API.g_false,

1756: );
1757: WHEN FND_API.g_exc_unexpected_error THEN
1758: x_return_status := FND_API.g_ret_sts_unexp_error ;
1759: FND_MSG_PUB.count_and_get (
1760: p_encoded => FND_API.g_false,
1761: p_count => x_msg_count,
1762: p_data => x_msg_data
1763: );
1764: WHEN OTHERS THEN

Line 1765: x_return_status := FND_API.g_ret_sts_unexp_error ;

1761: p_count => x_msg_count,
1762: p_data => x_msg_data
1763: );
1764: WHEN OTHERS THEN
1765: x_return_status := FND_API.g_ret_sts_unexp_error ;
1766: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1767: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1768: END IF;
1769:

Line 1771: p_encoded => FND_API.g_false,

1767: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1768: END IF;
1769:
1770: FND_MSG_PUB.count_and_get (
1771: p_encoded => FND_API.g_false,
1772: p_count => x_msg_count,
1773: p_data => x_msg_data
1774: );
1775: END Lock_Venue;

Line 1785: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1781: --
1782: --------------------------------------------------------------------
1783: PROCEDURE Validate_Venue (
1784: p_api_version IN NUMBER,
1785: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1786: p_commit IN VARCHAR2 := FND_API.g_false,
1787: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1788:
1789: x_return_status OUT NOCOPY VARCHAR2,

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

1782: --------------------------------------------------------------------
1783: PROCEDURE Validate_Venue (
1784: p_api_version IN NUMBER,
1785: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1786: p_commit IN VARCHAR2 := FND_API.g_false,
1787: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1788:
1789: x_return_status OUT NOCOPY VARCHAR2,
1790: x_msg_count OUT NOCOPY NUMBER,

Line 1787: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

1783: PROCEDURE Validate_Venue (
1784: p_api_version IN NUMBER,
1785: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1786: p_commit IN VARCHAR2 := FND_API.g_false,
1787: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
1788:
1789: x_return_status OUT NOCOPY VARCHAR2,
1790: x_msg_count OUT NOCOPY NUMBER,
1791: x_msg_data OUT NOCOPY VARCHAR2,

Line 1809: IF FND_API.to_boolean (p_init_msg_list) THEN

1805:
1806: AMS_Utility_PVT.debug_message (l_full_name || ': Start');
1807: END IF;
1808:
1809: IF FND_API.to_boolean (p_init_msg_list) THEN
1810: FND_MSG_PUB.initialize;
1811: END IF;
1812:
1813: IF NOT FND_API.compatible_api_call (

Line 1813: IF NOT FND_API.compatible_api_call (

1809: IF FND_API.to_boolean (p_init_msg_list) THEN
1810: FND_MSG_PUB.initialize;
1811: END IF;
1812:
1813: IF NOT FND_API.compatible_api_call (
1814: l_api_version,
1815: p_api_version,
1816: l_api_name,
1817: g_pkg_name

Line 1819: RAISE FND_API.g_exc_unexpected_error;

1815: p_api_version,
1816: l_api_name,
1817: g_pkg_name
1818: ) THEN
1819: RAISE FND_API.g_exc_unexpected_error;
1820: END IF;
1821:
1822: x_return_status := FND_API.g_ret_sts_success;
1823:

Line 1822: x_return_status := FND_API.g_ret_sts_success;

1818: ) THEN
1819: RAISE FND_API.g_exc_unexpected_error;
1820: END IF;
1821:
1822: x_return_status := FND_API.g_ret_sts_success;
1823:
1824: ---------------------- validate ------------------------
1825: IF (AMS_DEBUG_HIGH_ON) THEN
1826:

Line 1838: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1834: p_validation_mode => JTF_PLSQL_API.g_create,
1835: x_return_status => l_return_status
1836: );
1837:
1838: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1839: RAISE FND_API.g_exc_unexpected_error;
1840: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1841: RAISE FND_API.g_exc_error;
1842: END IF;

Line 1839: RAISE FND_API.g_exc_unexpected_error;

1835: x_return_status => l_return_status
1836: );
1837:
1838: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1839: RAISE FND_API.g_exc_unexpected_error;
1840: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1841: RAISE FND_API.g_exc_error;
1842: END IF;
1843: END IF;

Line 1840: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1836: );
1837:
1838: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1839: RAISE FND_API.g_exc_unexpected_error;
1840: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1841: RAISE FND_API.g_exc_error;
1842: END IF;
1843: END IF;
1844:

Line 1841: RAISE FND_API.g_exc_error;

1837:
1838: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1839: RAISE FND_API.g_exc_unexpected_error;
1840: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1841: RAISE FND_API.g_exc_error;
1842: END IF;
1843: END IF;
1844:
1845: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1860: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1856: p_complete_rec => NULL,
1857: x_return_status => l_return_status
1858: );
1859:
1860: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1861: RAISE FND_API.g_exc_unexpected_error;
1862: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1863: RAISE FND_API.g_exc_error;
1864: END IF;

Line 1861: RAISE FND_API.g_exc_unexpected_error;

1857: x_return_status => l_return_status
1858: );
1859:
1860: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1861: RAISE FND_API.g_exc_unexpected_error;
1862: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1863: RAISE FND_API.g_exc_error;
1864: END IF;
1865: END IF;

Line 1862: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

1858: );
1859:
1860: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1861: RAISE FND_API.g_exc_unexpected_error;
1862: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1863: RAISE FND_API.g_exc_error;
1864: END IF;
1865: END IF;
1866:

Line 1863: RAISE FND_API.g_exc_error;

1859:
1860: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1861: RAISE FND_API.g_exc_unexpected_error;
1862: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
1863: RAISE FND_API.g_exc_error;
1864: END IF;
1865: END IF;
1866:
1867: -------------------- finish --------------------------

Line 1869: p_encoded => FND_API.g_false,

1865: END IF;
1866:
1867: -------------------- finish --------------------------
1868: FND_MSG_PUB.count_and_get (
1869: p_encoded => FND_API.g_false,
1870: p_count => x_msg_count,
1871: p_data => x_msg_data
1872: );
1873:

Line 1883: WHEN FND_API.g_exc_error THEN

1879:
1880: END IF;
1881:
1882: EXCEPTION
1883: WHEN FND_API.g_exc_error THEN
1884: x_return_status := FND_API.g_ret_sts_error;
1885: FND_MSG_PUB.count_and_get (
1886: p_encoded => FND_API.g_false,
1887: p_count => x_msg_count,

Line 1884: x_return_status := FND_API.g_ret_sts_error;

1880: END IF;
1881:
1882: EXCEPTION
1883: WHEN FND_API.g_exc_error THEN
1884: x_return_status := FND_API.g_ret_sts_error;
1885: FND_MSG_PUB.count_and_get (
1886: p_encoded => FND_API.g_false,
1887: p_count => x_msg_count,
1888: p_data => x_msg_data

Line 1886: p_encoded => FND_API.g_false,

1882: EXCEPTION
1883: WHEN FND_API.g_exc_error THEN
1884: x_return_status := FND_API.g_ret_sts_error;
1885: FND_MSG_PUB.count_and_get (
1886: p_encoded => FND_API.g_false,
1887: p_count => x_msg_count,
1888: p_data => x_msg_data
1889: );
1890: WHEN FND_API.g_exc_unexpected_error THEN

Line 1890: WHEN FND_API.g_exc_unexpected_error THEN

1886: p_encoded => FND_API.g_false,
1887: p_count => x_msg_count,
1888: p_data => x_msg_data
1889: );
1890: WHEN FND_API.g_exc_unexpected_error THEN
1891: x_return_status := FND_API.g_ret_sts_unexp_error ;
1892: FND_MSG_PUB.count_and_get (
1893: p_encoded => FND_API.g_false,
1894: p_count => x_msg_count,

Line 1891: x_return_status := FND_API.g_ret_sts_unexp_error ;

1887: p_count => x_msg_count,
1888: p_data => x_msg_data
1889: );
1890: WHEN FND_API.g_exc_unexpected_error THEN
1891: x_return_status := FND_API.g_ret_sts_unexp_error ;
1892: FND_MSG_PUB.count_and_get (
1893: p_encoded => FND_API.g_false,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data

Line 1893: p_encoded => FND_API.g_false,

1889: );
1890: WHEN FND_API.g_exc_unexpected_error THEN
1891: x_return_status := FND_API.g_ret_sts_unexp_error ;
1892: FND_MSG_PUB.count_and_get (
1893: p_encoded => FND_API.g_false,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data
1896: );
1897: WHEN OTHERS THEN

Line 1898: x_return_status := FND_API.g_ret_sts_unexp_error;

1894: p_count => x_msg_count,
1895: p_data => x_msg_data
1896: );
1897: WHEN OTHERS THEN
1898: x_return_status := FND_API.g_ret_sts_unexp_error;
1899: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1900: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1901: END IF;
1902:

Line 1904: p_encoded => FND_API.g_false,

1900: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
1901: END IF;
1902:
1903: FND_MSG_PUB.count_and_get (
1904: p_encoded => FND_API.g_false,
1905: p_count => x_msg_count,
1906: p_data => x_msg_data
1907: );
1908: END Validate_Venue;

Line 1932: IF x_return_status <> FND_API.g_ret_sts_success THEN

1928: p_object_type => p_object_type,
1929: x_return_status => x_return_status
1930: );
1931:
1932: IF x_return_status <> FND_API.g_ret_sts_success THEN
1933: RETURN;
1934: END IF;
1935:
1936: Check_Venue_FK_Items(

Line 1942: IF x_return_status <> FND_API.g_ret_sts_success THEN

1938: p_object_type => p_object_type,
1939: x_return_status => x_return_status
1940: );
1941:
1942: IF x_return_status <> FND_API.g_ret_sts_success THEN
1943: RETURN;
1944: END IF;
1945:
1946: --

Line 1955: IF x_return_status <> FND_API.g_ret_sts_success THEN

1951: p_validation_mode => p_validation_mode,
1952: x_return_status => x_return_status
1953: );
1954:
1955: IF x_return_status <> FND_API.g_ret_sts_success THEN
1956: RETURN;
1957: END IF;
1958:
1959: Check_Venue_Lookup_Items (

Line 1964: IF x_return_status <> FND_API.g_ret_sts_success THEN

1960: p_venue_rec => p_venue_rec,
1961: x_return_status => x_return_status
1962: );
1963:
1964: IF x_return_status <> FND_API.g_ret_sts_success THEN
1965: RETURN;
1966: END IF;
1967:
1968: Check_Venue_Flag_Items(

Line 1980: RAISE FND_API.g_exc_error;

1976: THEN
1977: Fnd_Message.set_name('AMS', 'AMS_USAGE_COST_NEG');
1978: Fnd_Msg_Pub.ADD;
1979: END IF;
1980: RAISE FND_API.g_exc_error;
1981: END IF;
1982:
1983: IF(p_venue_rec.capacity < 0)
1984: THEN

Line 1990: RAISE FND_API.g_exc_error;

1986: THEN
1987: Fnd_Message.set_name('AMS', 'AMS_CAPACITY_NEG');
1988: Fnd_Msg_Pub.ADD;
1989: END IF;
1990: RAISE FND_API.g_exc_error;
1991: END IF;
1992:
1993: IF(p_venue_rec.ceiling_height < 0)
1994: THEN

Line 2000: RAISE FND_API.g_exc_error;

1996: THEN
1997: Fnd_Message.set_name('AMS', 'AMS_CEILING_HEIGHT_NEG');
1998: Fnd_Msg_Pub.ADD;
1999: END IF;
2000: RAISE FND_API.g_exc_error;
2001: END IF;
2002:
2003: /* dbiswas added the following two conditions to check that no more than 15 chars are inserted for
2004: ceiling height and capacity on May 9, 2003 for bug 2950429 */

Line 2013: RAISE FND_API.g_exc_error;

2009: THEN
2010: Fnd_Message.set_name('AMS', 'AMS_OVERSIZE_CEILING_HEIGHT');
2011: Fnd_Msg_Pub.ADD;
2012: END IF;
2013: RAISE FND_API.g_exc_error;
2014: END IF;
2015:
2016: IF(length(p_venue_rec.capacity) > 15)
2017: THEN

Line 2023: RAISE FND_API.g_exc_error;

2019: THEN
2020: Fnd_Message.set_name('AMS', 'AMS_OVERSIZE_CAPACITY');
2021: Fnd_Msg_Pub.ADD;
2022: END IF;
2023: RAISE FND_API.g_exc_error;
2024: END IF;
2025:
2026: /* end update by dbiswas on May 9, 2003 */
2027:

Line 2028: IF x_return_status <> FND_API.g_ret_sts_success THEN

2024: END IF;
2025:
2026: /* end update by dbiswas on May 9, 2003 */
2027:
2028: IF x_return_status <> FND_API.g_ret_sts_success THEN
2029: RETURN;
2030: END IF;
2031: END Check_Venue_Items;
2032:

Line 2042: -- as FND_API.g_miss_char/num/date

2038: -- Check the record level business rules.
2039: --
2040: -- PARAMETERS
2041: -- p_venue_rec: the record to be validated; may contain attributes
2042: -- as FND_API.g_miss_char/num/date
2043: -- p_complete_rec: the complete record after all "g_miss" items
2044: -- have been replaced by current database values
2045: ---------------------------------------------------------------------
2046: PROCEDURE Check_Venue_Record (

Line 2056: x_return_status := FND_API.g_ret_sts_success;

2052: BEGIN
2053: --
2054: -- Currently, no business rule for record
2055: -- level validation.
2056: x_return_status := FND_API.g_ret_sts_success;
2057: END Check_Venue_Record;
2058:
2059: ---------------------------------------------------------------------
2060: -- PROCEDURE

Line 2069: x_venue_rec.venue_id := FND_API.g_miss_num;

2065: x_venue_rec OUT NOCOPY Venue_Rec_Type
2066: )
2067: IS
2068: BEGIN
2069: x_venue_rec.venue_id := FND_API.g_miss_num;
2070: x_venue_rec.custom_setup_id := FND_API.g_miss_num;
2071: x_venue_rec.last_update_date := FND_API.g_miss_date;
2072: x_venue_rec.last_updated_by := FND_API.g_miss_num;
2073: x_venue_rec.creation_date := FND_API.g_miss_date;

Line 2070: x_venue_rec.custom_setup_id := FND_API.g_miss_num;

2066: )
2067: IS
2068: BEGIN
2069: x_venue_rec.venue_id := FND_API.g_miss_num;
2070: x_venue_rec.custom_setup_id := FND_API.g_miss_num;
2071: x_venue_rec.last_update_date := FND_API.g_miss_date;
2072: x_venue_rec.last_updated_by := FND_API.g_miss_num;
2073: x_venue_rec.creation_date := FND_API.g_miss_date;
2074: x_venue_rec.created_by := FND_API.g_miss_num;

Line 2071: x_venue_rec.last_update_date := FND_API.g_miss_date;

2067: IS
2068: BEGIN
2069: x_venue_rec.venue_id := FND_API.g_miss_num;
2070: x_venue_rec.custom_setup_id := FND_API.g_miss_num;
2071: x_venue_rec.last_update_date := FND_API.g_miss_date;
2072: x_venue_rec.last_updated_by := FND_API.g_miss_num;
2073: x_venue_rec.creation_date := FND_API.g_miss_date;
2074: x_venue_rec.created_by := FND_API.g_miss_num;
2075: x_venue_rec.last_update_login := FND_API.g_miss_num;

Line 2072: x_venue_rec.last_updated_by := FND_API.g_miss_num;

2068: BEGIN
2069: x_venue_rec.venue_id := FND_API.g_miss_num;
2070: x_venue_rec.custom_setup_id := FND_API.g_miss_num;
2071: x_venue_rec.last_update_date := FND_API.g_miss_date;
2072: x_venue_rec.last_updated_by := FND_API.g_miss_num;
2073: x_venue_rec.creation_date := FND_API.g_miss_date;
2074: x_venue_rec.created_by := FND_API.g_miss_num;
2075: x_venue_rec.last_update_login := FND_API.g_miss_num;
2076: x_venue_rec.object_version_number := FND_API.g_miss_num;

Line 2073: x_venue_rec.creation_date := FND_API.g_miss_date;

2069: x_venue_rec.venue_id := FND_API.g_miss_num;
2070: x_venue_rec.custom_setup_id := FND_API.g_miss_num;
2071: x_venue_rec.last_update_date := FND_API.g_miss_date;
2072: x_venue_rec.last_updated_by := FND_API.g_miss_num;
2073: x_venue_rec.creation_date := FND_API.g_miss_date;
2074: x_venue_rec.created_by := FND_API.g_miss_num;
2075: x_venue_rec.last_update_login := FND_API.g_miss_num;
2076: x_venue_rec.object_version_number := FND_API.g_miss_num;
2077: x_venue_rec.venue_type_code := FND_API.g_miss_char;

Line 2074: x_venue_rec.created_by := FND_API.g_miss_num;

2070: x_venue_rec.custom_setup_id := FND_API.g_miss_num;
2071: x_venue_rec.last_update_date := FND_API.g_miss_date;
2072: x_venue_rec.last_updated_by := FND_API.g_miss_num;
2073: x_venue_rec.creation_date := FND_API.g_miss_date;
2074: x_venue_rec.created_by := FND_API.g_miss_num;
2075: x_venue_rec.last_update_login := FND_API.g_miss_num;
2076: x_venue_rec.object_version_number := FND_API.g_miss_num;
2077: x_venue_rec.venue_type_code := FND_API.g_miss_char;
2078: x_venue_rec.direct_phone_flag := FND_API.g_miss_char;

Line 2075: x_venue_rec.last_update_login := FND_API.g_miss_num;

2071: x_venue_rec.last_update_date := FND_API.g_miss_date;
2072: x_venue_rec.last_updated_by := FND_API.g_miss_num;
2073: x_venue_rec.creation_date := FND_API.g_miss_date;
2074: x_venue_rec.created_by := FND_API.g_miss_num;
2075: x_venue_rec.last_update_login := FND_API.g_miss_num;
2076: x_venue_rec.object_version_number := FND_API.g_miss_num;
2077: x_venue_rec.venue_type_code := FND_API.g_miss_char;
2078: x_venue_rec.direct_phone_flag := FND_API.g_miss_char;
2079: x_venue_rec.internal_flag := FND_API.g_miss_char;

Line 2076: x_venue_rec.object_version_number := FND_API.g_miss_num;

2072: x_venue_rec.last_updated_by := FND_API.g_miss_num;
2073: x_venue_rec.creation_date := FND_API.g_miss_date;
2074: x_venue_rec.created_by := FND_API.g_miss_num;
2075: x_venue_rec.last_update_login := FND_API.g_miss_num;
2076: x_venue_rec.object_version_number := FND_API.g_miss_num;
2077: x_venue_rec.venue_type_code := FND_API.g_miss_char;
2078: x_venue_rec.direct_phone_flag := FND_API.g_miss_char;
2079: x_venue_rec.internal_flag := FND_API.g_miss_char;
2080: x_venue_rec.enabled_flag := FND_API.g_miss_char;

Line 2077: x_venue_rec.venue_type_code := FND_API.g_miss_char;

2073: x_venue_rec.creation_date := FND_API.g_miss_date;
2074: x_venue_rec.created_by := FND_API.g_miss_num;
2075: x_venue_rec.last_update_login := FND_API.g_miss_num;
2076: x_venue_rec.object_version_number := FND_API.g_miss_num;
2077: x_venue_rec.venue_type_code := FND_API.g_miss_char;
2078: x_venue_rec.direct_phone_flag := FND_API.g_miss_char;
2079: x_venue_rec.internal_flag := FND_API.g_miss_char;
2080: x_venue_rec.enabled_flag := FND_API.g_miss_char;
2081: x_venue_rec.rating_code := FND_API.g_miss_char;

Line 2078: x_venue_rec.direct_phone_flag := FND_API.g_miss_char;

2074: x_venue_rec.created_by := FND_API.g_miss_num;
2075: x_venue_rec.last_update_login := FND_API.g_miss_num;
2076: x_venue_rec.object_version_number := FND_API.g_miss_num;
2077: x_venue_rec.venue_type_code := FND_API.g_miss_char;
2078: x_venue_rec.direct_phone_flag := FND_API.g_miss_char;
2079: x_venue_rec.internal_flag := FND_API.g_miss_char;
2080: x_venue_rec.enabled_flag := FND_API.g_miss_char;
2081: x_venue_rec.rating_code := FND_API.g_miss_char;
2082: x_venue_rec.telecom_code := FND_API.g_miss_char;

Line 2079: x_venue_rec.internal_flag := FND_API.g_miss_char;

2075: x_venue_rec.last_update_login := FND_API.g_miss_num;
2076: x_venue_rec.object_version_number := FND_API.g_miss_num;
2077: x_venue_rec.venue_type_code := FND_API.g_miss_char;
2078: x_venue_rec.direct_phone_flag := FND_API.g_miss_char;
2079: x_venue_rec.internal_flag := FND_API.g_miss_char;
2080: x_venue_rec.enabled_flag := FND_API.g_miss_char;
2081: x_venue_rec.rating_code := FND_API.g_miss_char;
2082: x_venue_rec.telecom_code := FND_API.g_miss_char;
2083: x_venue_rec.capacity := FND_API.g_miss_num;

Line 2080: x_venue_rec.enabled_flag := FND_API.g_miss_char;

2076: x_venue_rec.object_version_number := FND_API.g_miss_num;
2077: x_venue_rec.venue_type_code := FND_API.g_miss_char;
2078: x_venue_rec.direct_phone_flag := FND_API.g_miss_char;
2079: x_venue_rec.internal_flag := FND_API.g_miss_char;
2080: x_venue_rec.enabled_flag := FND_API.g_miss_char;
2081: x_venue_rec.rating_code := FND_API.g_miss_char;
2082: x_venue_rec.telecom_code := FND_API.g_miss_char;
2083: x_venue_rec.capacity := FND_API.g_miss_num;
2084: x_venue_rec.area_size := FND_API.g_miss_num;

Line 2081: x_venue_rec.rating_code := FND_API.g_miss_char;

2077: x_venue_rec.venue_type_code := FND_API.g_miss_char;
2078: x_venue_rec.direct_phone_flag := FND_API.g_miss_char;
2079: x_venue_rec.internal_flag := FND_API.g_miss_char;
2080: x_venue_rec.enabled_flag := FND_API.g_miss_char;
2081: x_venue_rec.rating_code := FND_API.g_miss_char;
2082: x_venue_rec.telecom_code := FND_API.g_miss_char;
2083: x_venue_rec.capacity := FND_API.g_miss_num;
2084: x_venue_rec.area_size := FND_API.g_miss_num;
2085: x_venue_rec.area_size_uom_code := FND_API.g_miss_char;

Line 2082: x_venue_rec.telecom_code := FND_API.g_miss_char;

2078: x_venue_rec.direct_phone_flag := FND_API.g_miss_char;
2079: x_venue_rec.internal_flag := FND_API.g_miss_char;
2080: x_venue_rec.enabled_flag := FND_API.g_miss_char;
2081: x_venue_rec.rating_code := FND_API.g_miss_char;
2082: x_venue_rec.telecom_code := FND_API.g_miss_char;
2083: x_venue_rec.capacity := FND_API.g_miss_num;
2084: x_venue_rec.area_size := FND_API.g_miss_num;
2085: x_venue_rec.area_size_uom_code := FND_API.g_miss_char;
2086: x_venue_rec.ceiling_height := FND_API.g_miss_num;

Line 2083: x_venue_rec.capacity := FND_API.g_miss_num;

2079: x_venue_rec.internal_flag := FND_API.g_miss_char;
2080: x_venue_rec.enabled_flag := FND_API.g_miss_char;
2081: x_venue_rec.rating_code := FND_API.g_miss_char;
2082: x_venue_rec.telecom_code := FND_API.g_miss_char;
2083: x_venue_rec.capacity := FND_API.g_miss_num;
2084: x_venue_rec.area_size := FND_API.g_miss_num;
2085: x_venue_rec.area_size_uom_code := FND_API.g_miss_char;
2086: x_venue_rec.ceiling_height := FND_API.g_miss_num;
2087: x_venue_rec.ceiling_height_uom_code := FND_API.g_miss_char;

Line 2084: x_venue_rec.area_size := FND_API.g_miss_num;

2080: x_venue_rec.enabled_flag := FND_API.g_miss_char;
2081: x_venue_rec.rating_code := FND_API.g_miss_char;
2082: x_venue_rec.telecom_code := FND_API.g_miss_char;
2083: x_venue_rec.capacity := FND_API.g_miss_num;
2084: x_venue_rec.area_size := FND_API.g_miss_num;
2085: x_venue_rec.area_size_uom_code := FND_API.g_miss_char;
2086: x_venue_rec.ceiling_height := FND_API.g_miss_num;
2087: x_venue_rec.ceiling_height_uom_code := FND_API.g_miss_char;
2088: x_venue_rec.usage_cost := FND_API.g_miss_num;

Line 2085: x_venue_rec.area_size_uom_code := FND_API.g_miss_char;

2081: x_venue_rec.rating_code := FND_API.g_miss_char;
2082: x_venue_rec.telecom_code := FND_API.g_miss_char;
2083: x_venue_rec.capacity := FND_API.g_miss_num;
2084: x_venue_rec.area_size := FND_API.g_miss_num;
2085: x_venue_rec.area_size_uom_code := FND_API.g_miss_char;
2086: x_venue_rec.ceiling_height := FND_API.g_miss_num;
2087: x_venue_rec.ceiling_height_uom_code := FND_API.g_miss_char;
2088: x_venue_rec.usage_cost := FND_API.g_miss_num;
2089: x_venue_rec.usage_cost_uom_code := FND_API.g_miss_char;

Line 2086: x_venue_rec.ceiling_height := FND_API.g_miss_num;

2082: x_venue_rec.telecom_code := FND_API.g_miss_char;
2083: x_venue_rec.capacity := FND_API.g_miss_num;
2084: x_venue_rec.area_size := FND_API.g_miss_num;
2085: x_venue_rec.area_size_uom_code := FND_API.g_miss_char;
2086: x_venue_rec.ceiling_height := FND_API.g_miss_num;
2087: x_venue_rec.ceiling_height_uom_code := FND_API.g_miss_char;
2088: x_venue_rec.usage_cost := FND_API.g_miss_num;
2089: x_venue_rec.usage_cost_uom_code := FND_API.g_miss_char;
2090: x_venue_rec.usage_cost_currency_code := FND_API.g_miss_char;

Line 2087: x_venue_rec.ceiling_height_uom_code := FND_API.g_miss_char;

2083: x_venue_rec.capacity := FND_API.g_miss_num;
2084: x_venue_rec.area_size := FND_API.g_miss_num;
2085: x_venue_rec.area_size_uom_code := FND_API.g_miss_char;
2086: x_venue_rec.ceiling_height := FND_API.g_miss_num;
2087: x_venue_rec.ceiling_height_uom_code := FND_API.g_miss_char;
2088: x_venue_rec.usage_cost := FND_API.g_miss_num;
2089: x_venue_rec.usage_cost_uom_code := FND_API.g_miss_char;
2090: x_venue_rec.usage_cost_currency_code := FND_API.g_miss_char;
2091: x_venue_rec.parent_venue_id := FND_API.g_miss_num;

Line 2088: x_venue_rec.usage_cost := FND_API.g_miss_num;

2084: x_venue_rec.area_size := FND_API.g_miss_num;
2085: x_venue_rec.area_size_uom_code := FND_API.g_miss_char;
2086: x_venue_rec.ceiling_height := FND_API.g_miss_num;
2087: x_venue_rec.ceiling_height_uom_code := FND_API.g_miss_char;
2088: x_venue_rec.usage_cost := FND_API.g_miss_num;
2089: x_venue_rec.usage_cost_uom_code := FND_API.g_miss_char;
2090: x_venue_rec.usage_cost_currency_code := FND_API.g_miss_char;
2091: x_venue_rec.parent_venue_id := FND_API.g_miss_num;
2092: x_venue_rec.location_id := FND_API.g_miss_num;

Line 2089: x_venue_rec.usage_cost_uom_code := FND_API.g_miss_char;

2085: x_venue_rec.area_size_uom_code := FND_API.g_miss_char;
2086: x_venue_rec.ceiling_height := FND_API.g_miss_num;
2087: x_venue_rec.ceiling_height_uom_code := FND_API.g_miss_char;
2088: x_venue_rec.usage_cost := FND_API.g_miss_num;
2089: x_venue_rec.usage_cost_uom_code := FND_API.g_miss_char;
2090: x_venue_rec.usage_cost_currency_code := FND_API.g_miss_char;
2091: x_venue_rec.parent_venue_id := FND_API.g_miss_num;
2092: x_venue_rec.location_id := FND_API.g_miss_num;
2093: x_venue_rec.directions := FND_API.g_miss_char;

Line 2090: x_venue_rec.usage_cost_currency_code := FND_API.g_miss_char;

2086: x_venue_rec.ceiling_height := FND_API.g_miss_num;
2087: x_venue_rec.ceiling_height_uom_code := FND_API.g_miss_char;
2088: x_venue_rec.usage_cost := FND_API.g_miss_num;
2089: x_venue_rec.usage_cost_uom_code := FND_API.g_miss_char;
2090: x_venue_rec.usage_cost_currency_code := FND_API.g_miss_char;
2091: x_venue_rec.parent_venue_id := FND_API.g_miss_num;
2092: x_venue_rec.location_id := FND_API.g_miss_num;
2093: x_venue_rec.directions := FND_API.g_miss_char;
2094: x_venue_rec.venue_code := FND_API.g_miss_char;

Line 2091: x_venue_rec.parent_venue_id := FND_API.g_miss_num;

2087: x_venue_rec.ceiling_height_uom_code := FND_API.g_miss_char;
2088: x_venue_rec.usage_cost := FND_API.g_miss_num;
2089: x_venue_rec.usage_cost_uom_code := FND_API.g_miss_char;
2090: x_venue_rec.usage_cost_currency_code := FND_API.g_miss_char;
2091: x_venue_rec.parent_venue_id := FND_API.g_miss_num;
2092: x_venue_rec.location_id := FND_API.g_miss_num;
2093: x_venue_rec.directions := FND_API.g_miss_char;
2094: x_venue_rec.venue_code := FND_API.g_miss_char;
2095: x_venue_rec.object_type := FND_API.g_miss_char;

Line 2092: x_venue_rec.location_id := FND_API.g_miss_num;

2088: x_venue_rec.usage_cost := FND_API.g_miss_num;
2089: x_venue_rec.usage_cost_uom_code := FND_API.g_miss_char;
2090: x_venue_rec.usage_cost_currency_code := FND_API.g_miss_char;
2091: x_venue_rec.parent_venue_id := FND_API.g_miss_num;
2092: x_venue_rec.location_id := FND_API.g_miss_num;
2093: x_venue_rec.directions := FND_API.g_miss_char;
2094: x_venue_rec.venue_code := FND_API.g_miss_char;
2095: x_venue_rec.object_type := FND_API.g_miss_char;
2096: x_venue_rec.party_id := FND_API.g_miss_num;

Line 2093: x_venue_rec.directions := FND_API.g_miss_char;

2089: x_venue_rec.usage_cost_uom_code := FND_API.g_miss_char;
2090: x_venue_rec.usage_cost_currency_code := FND_API.g_miss_char;
2091: x_venue_rec.parent_venue_id := FND_API.g_miss_num;
2092: x_venue_rec.location_id := FND_API.g_miss_num;
2093: x_venue_rec.directions := FND_API.g_miss_char;
2094: x_venue_rec.venue_code := FND_API.g_miss_char;
2095: x_venue_rec.object_type := FND_API.g_miss_char;
2096: x_venue_rec.party_id := FND_API.g_miss_num;
2097: x_venue_rec.attribute_category := FND_API.g_miss_char;

Line 2094: x_venue_rec.venue_code := FND_API.g_miss_char;

2090: x_venue_rec.usage_cost_currency_code := FND_API.g_miss_char;
2091: x_venue_rec.parent_venue_id := FND_API.g_miss_num;
2092: x_venue_rec.location_id := FND_API.g_miss_num;
2093: x_venue_rec.directions := FND_API.g_miss_char;
2094: x_venue_rec.venue_code := FND_API.g_miss_char;
2095: x_venue_rec.object_type := FND_API.g_miss_char;
2096: x_venue_rec.party_id := FND_API.g_miss_num;
2097: x_venue_rec.attribute_category := FND_API.g_miss_char;
2098: x_venue_rec.attribute1 := FND_API.g_miss_char;

Line 2095: x_venue_rec.object_type := FND_API.g_miss_char;

2091: x_venue_rec.parent_venue_id := FND_API.g_miss_num;
2092: x_venue_rec.location_id := FND_API.g_miss_num;
2093: x_venue_rec.directions := FND_API.g_miss_char;
2094: x_venue_rec.venue_code := FND_API.g_miss_char;
2095: x_venue_rec.object_type := FND_API.g_miss_char;
2096: x_venue_rec.party_id := FND_API.g_miss_num;
2097: x_venue_rec.attribute_category := FND_API.g_miss_char;
2098: x_venue_rec.attribute1 := FND_API.g_miss_char;
2099: x_venue_rec.attribute2 := FND_API.g_miss_char;

Line 2096: x_venue_rec.party_id := FND_API.g_miss_num;

2092: x_venue_rec.location_id := FND_API.g_miss_num;
2093: x_venue_rec.directions := FND_API.g_miss_char;
2094: x_venue_rec.venue_code := FND_API.g_miss_char;
2095: x_venue_rec.object_type := FND_API.g_miss_char;
2096: x_venue_rec.party_id := FND_API.g_miss_num;
2097: x_venue_rec.attribute_category := FND_API.g_miss_char;
2098: x_venue_rec.attribute1 := FND_API.g_miss_char;
2099: x_venue_rec.attribute2 := FND_API.g_miss_char;
2100: x_venue_rec.attribute3 := FND_API.g_miss_char;

Line 2097: x_venue_rec.attribute_category := FND_API.g_miss_char;

2093: x_venue_rec.directions := FND_API.g_miss_char;
2094: x_venue_rec.venue_code := FND_API.g_miss_char;
2095: x_venue_rec.object_type := FND_API.g_miss_char;
2096: x_venue_rec.party_id := FND_API.g_miss_num;
2097: x_venue_rec.attribute_category := FND_API.g_miss_char;
2098: x_venue_rec.attribute1 := FND_API.g_miss_char;
2099: x_venue_rec.attribute2 := FND_API.g_miss_char;
2100: x_venue_rec.attribute3 := FND_API.g_miss_char;
2101: x_venue_rec.attribute4 := FND_API.g_miss_char;

Line 2098: x_venue_rec.attribute1 := FND_API.g_miss_char;

2094: x_venue_rec.venue_code := FND_API.g_miss_char;
2095: x_venue_rec.object_type := FND_API.g_miss_char;
2096: x_venue_rec.party_id := FND_API.g_miss_num;
2097: x_venue_rec.attribute_category := FND_API.g_miss_char;
2098: x_venue_rec.attribute1 := FND_API.g_miss_char;
2099: x_venue_rec.attribute2 := FND_API.g_miss_char;
2100: x_venue_rec.attribute3 := FND_API.g_miss_char;
2101: x_venue_rec.attribute4 := FND_API.g_miss_char;
2102: x_venue_rec.attribute5 := FND_API.g_miss_char;

Line 2099: x_venue_rec.attribute2 := FND_API.g_miss_char;

2095: x_venue_rec.object_type := FND_API.g_miss_char;
2096: x_venue_rec.party_id := FND_API.g_miss_num;
2097: x_venue_rec.attribute_category := FND_API.g_miss_char;
2098: x_venue_rec.attribute1 := FND_API.g_miss_char;
2099: x_venue_rec.attribute2 := FND_API.g_miss_char;
2100: x_venue_rec.attribute3 := FND_API.g_miss_char;
2101: x_venue_rec.attribute4 := FND_API.g_miss_char;
2102: x_venue_rec.attribute5 := FND_API.g_miss_char;
2103: x_venue_rec.attribute6 := FND_API.g_miss_char;

Line 2100: x_venue_rec.attribute3 := FND_API.g_miss_char;

2096: x_venue_rec.party_id := FND_API.g_miss_num;
2097: x_venue_rec.attribute_category := FND_API.g_miss_char;
2098: x_venue_rec.attribute1 := FND_API.g_miss_char;
2099: x_venue_rec.attribute2 := FND_API.g_miss_char;
2100: x_venue_rec.attribute3 := FND_API.g_miss_char;
2101: x_venue_rec.attribute4 := FND_API.g_miss_char;
2102: x_venue_rec.attribute5 := FND_API.g_miss_char;
2103: x_venue_rec.attribute6 := FND_API.g_miss_char;
2104: x_venue_rec.attribute7 := FND_API.g_miss_char;

Line 2101: x_venue_rec.attribute4 := FND_API.g_miss_char;

2097: x_venue_rec.attribute_category := FND_API.g_miss_char;
2098: x_venue_rec.attribute1 := FND_API.g_miss_char;
2099: x_venue_rec.attribute2 := FND_API.g_miss_char;
2100: x_venue_rec.attribute3 := FND_API.g_miss_char;
2101: x_venue_rec.attribute4 := FND_API.g_miss_char;
2102: x_venue_rec.attribute5 := FND_API.g_miss_char;
2103: x_venue_rec.attribute6 := FND_API.g_miss_char;
2104: x_venue_rec.attribute7 := FND_API.g_miss_char;
2105: x_venue_rec.attribute8 := FND_API.g_miss_char;

Line 2102: x_venue_rec.attribute5 := FND_API.g_miss_char;

2098: x_venue_rec.attribute1 := FND_API.g_miss_char;
2099: x_venue_rec.attribute2 := FND_API.g_miss_char;
2100: x_venue_rec.attribute3 := FND_API.g_miss_char;
2101: x_venue_rec.attribute4 := FND_API.g_miss_char;
2102: x_venue_rec.attribute5 := FND_API.g_miss_char;
2103: x_venue_rec.attribute6 := FND_API.g_miss_char;
2104: x_venue_rec.attribute7 := FND_API.g_miss_char;
2105: x_venue_rec.attribute8 := FND_API.g_miss_char;
2106: x_venue_rec.attribute9 := FND_API.g_miss_char;

Line 2103: x_venue_rec.attribute6 := FND_API.g_miss_char;

2099: x_venue_rec.attribute2 := FND_API.g_miss_char;
2100: x_venue_rec.attribute3 := FND_API.g_miss_char;
2101: x_venue_rec.attribute4 := FND_API.g_miss_char;
2102: x_venue_rec.attribute5 := FND_API.g_miss_char;
2103: x_venue_rec.attribute6 := FND_API.g_miss_char;
2104: x_venue_rec.attribute7 := FND_API.g_miss_char;
2105: x_venue_rec.attribute8 := FND_API.g_miss_char;
2106: x_venue_rec.attribute9 := FND_API.g_miss_char;
2107: x_venue_rec.attribute10 := FND_API.g_miss_char;

Line 2104: x_venue_rec.attribute7 := FND_API.g_miss_char;

2100: x_venue_rec.attribute3 := FND_API.g_miss_char;
2101: x_venue_rec.attribute4 := FND_API.g_miss_char;
2102: x_venue_rec.attribute5 := FND_API.g_miss_char;
2103: x_venue_rec.attribute6 := FND_API.g_miss_char;
2104: x_venue_rec.attribute7 := FND_API.g_miss_char;
2105: x_venue_rec.attribute8 := FND_API.g_miss_char;
2106: x_venue_rec.attribute9 := FND_API.g_miss_char;
2107: x_venue_rec.attribute10 := FND_API.g_miss_char;
2108: x_venue_rec.attribute11 := FND_API.g_miss_char;

Line 2105: x_venue_rec.attribute8 := FND_API.g_miss_char;

2101: x_venue_rec.attribute4 := FND_API.g_miss_char;
2102: x_venue_rec.attribute5 := FND_API.g_miss_char;
2103: x_venue_rec.attribute6 := FND_API.g_miss_char;
2104: x_venue_rec.attribute7 := FND_API.g_miss_char;
2105: x_venue_rec.attribute8 := FND_API.g_miss_char;
2106: x_venue_rec.attribute9 := FND_API.g_miss_char;
2107: x_venue_rec.attribute10 := FND_API.g_miss_char;
2108: x_venue_rec.attribute11 := FND_API.g_miss_char;
2109: x_venue_rec.attribute12 := FND_API.g_miss_char;

Line 2106: x_venue_rec.attribute9 := FND_API.g_miss_char;

2102: x_venue_rec.attribute5 := FND_API.g_miss_char;
2103: x_venue_rec.attribute6 := FND_API.g_miss_char;
2104: x_venue_rec.attribute7 := FND_API.g_miss_char;
2105: x_venue_rec.attribute8 := FND_API.g_miss_char;
2106: x_venue_rec.attribute9 := FND_API.g_miss_char;
2107: x_venue_rec.attribute10 := FND_API.g_miss_char;
2108: x_venue_rec.attribute11 := FND_API.g_miss_char;
2109: x_venue_rec.attribute12 := FND_API.g_miss_char;
2110: x_venue_rec.attribute13 := FND_API.g_miss_char;

Line 2107: x_venue_rec.attribute10 := FND_API.g_miss_char;

2103: x_venue_rec.attribute6 := FND_API.g_miss_char;
2104: x_venue_rec.attribute7 := FND_API.g_miss_char;
2105: x_venue_rec.attribute8 := FND_API.g_miss_char;
2106: x_venue_rec.attribute9 := FND_API.g_miss_char;
2107: x_venue_rec.attribute10 := FND_API.g_miss_char;
2108: x_venue_rec.attribute11 := FND_API.g_miss_char;
2109: x_venue_rec.attribute12 := FND_API.g_miss_char;
2110: x_venue_rec.attribute13 := FND_API.g_miss_char;
2111: x_venue_rec.attribute14 := FND_API.g_miss_char;

Line 2108: x_venue_rec.attribute11 := FND_API.g_miss_char;

2104: x_venue_rec.attribute7 := FND_API.g_miss_char;
2105: x_venue_rec.attribute8 := FND_API.g_miss_char;
2106: x_venue_rec.attribute9 := FND_API.g_miss_char;
2107: x_venue_rec.attribute10 := FND_API.g_miss_char;
2108: x_venue_rec.attribute11 := FND_API.g_miss_char;
2109: x_venue_rec.attribute12 := FND_API.g_miss_char;
2110: x_venue_rec.attribute13 := FND_API.g_miss_char;
2111: x_venue_rec.attribute14 := FND_API.g_miss_char;
2112: x_venue_rec.attribute15 := FND_API.g_miss_char;

Line 2109: x_venue_rec.attribute12 := FND_API.g_miss_char;

2105: x_venue_rec.attribute8 := FND_API.g_miss_char;
2106: x_venue_rec.attribute9 := FND_API.g_miss_char;
2107: x_venue_rec.attribute10 := FND_API.g_miss_char;
2108: x_venue_rec.attribute11 := FND_API.g_miss_char;
2109: x_venue_rec.attribute12 := FND_API.g_miss_char;
2110: x_venue_rec.attribute13 := FND_API.g_miss_char;
2111: x_venue_rec.attribute14 := FND_API.g_miss_char;
2112: x_venue_rec.attribute15 := FND_API.g_miss_char;
2113: x_venue_rec.venue_name := FND_API.g_miss_char;

Line 2110: x_venue_rec.attribute13 := FND_API.g_miss_char;

2106: x_venue_rec.attribute9 := FND_API.g_miss_char;
2107: x_venue_rec.attribute10 := FND_API.g_miss_char;
2108: x_venue_rec.attribute11 := FND_API.g_miss_char;
2109: x_venue_rec.attribute12 := FND_API.g_miss_char;
2110: x_venue_rec.attribute13 := FND_API.g_miss_char;
2111: x_venue_rec.attribute14 := FND_API.g_miss_char;
2112: x_venue_rec.attribute15 := FND_API.g_miss_char;
2113: x_venue_rec.venue_name := FND_API.g_miss_char;
2114: x_venue_rec.description := FND_API.g_miss_char;

Line 2111: x_venue_rec.attribute14 := FND_API.g_miss_char;

2107: x_venue_rec.attribute10 := FND_API.g_miss_char;
2108: x_venue_rec.attribute11 := FND_API.g_miss_char;
2109: x_venue_rec.attribute12 := FND_API.g_miss_char;
2110: x_venue_rec.attribute13 := FND_API.g_miss_char;
2111: x_venue_rec.attribute14 := FND_API.g_miss_char;
2112: x_venue_rec.attribute15 := FND_API.g_miss_char;
2113: x_venue_rec.venue_name := FND_API.g_miss_char;
2114: x_venue_rec.description := FND_API.g_miss_char;
2115: END Init_Venue_Rec;

Line 2112: x_venue_rec.attribute15 := FND_API.g_miss_char;

2108: x_venue_rec.attribute11 := FND_API.g_miss_char;
2109: x_venue_rec.attribute12 := FND_API.g_miss_char;
2110: x_venue_rec.attribute13 := FND_API.g_miss_char;
2111: x_venue_rec.attribute14 := FND_API.g_miss_char;
2112: x_venue_rec.attribute15 := FND_API.g_miss_char;
2113: x_venue_rec.venue_name := FND_API.g_miss_char;
2114: x_venue_rec.description := FND_API.g_miss_char;
2115: END Init_Venue_Rec;
2116:

Line 2113: x_venue_rec.venue_name := FND_API.g_miss_char;

2109: x_venue_rec.attribute12 := FND_API.g_miss_char;
2110: x_venue_rec.attribute13 := FND_API.g_miss_char;
2111: x_venue_rec.attribute14 := FND_API.g_miss_char;
2112: x_venue_rec.attribute15 := FND_API.g_miss_char;
2113: x_venue_rec.venue_name := FND_API.g_miss_char;
2114: x_venue_rec.description := FND_API.g_miss_char;
2115: END Init_Venue_Rec;
2116:
2117:

Line 2114: x_venue_rec.description := FND_API.g_miss_char;

2110: x_venue_rec.attribute13 := FND_API.g_miss_char;
2111: x_venue_rec.attribute14 := FND_API.g_miss_char;
2112: x_venue_rec.attribute15 := FND_API.g_miss_char;
2113: x_venue_rec.venue_name := FND_API.g_miss_char;
2114: x_venue_rec.description := FND_API.g_miss_char;
2115: END Init_Venue_Rec;
2116:
2117:
2118:

Line 2160: RAISE FND_API.g_exc_error;

2156: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2157: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2158: FND_MSG_PUB.add;
2159: END IF;
2160: RAISE FND_API.g_exc_error;
2161: END IF;
2162: CLOSE c_venue;
2163:
2164: IF l_venue_rec.party_id IS NOT NULL THEN

Line 2173: RAISE FND_API.g_exc_error;

2169: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2170: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
2171: FND_MSG_PUB.add;
2172: END IF;
2173: RAISE FND_API.g_exc_error;
2174: END IF;
2175: CLOSE c_location;
2176: END IF;
2177:

Line 2180: IF p_venue_rec.venue_type_code = FND_API.g_miss_char THEN

2176: END IF;
2177:
2178: --
2179: -- venue_type_code
2180: IF p_venue_rec.venue_type_code = FND_API.g_miss_char THEN
2181: x_complete_rec.venue_type_code := l_venue_rec.venue_type_code;
2182: END IF;
2183:
2184: --

Line 2186: IF p_venue_rec.custom_setup_id = FND_API.g_miss_num THEN

2182: END IF;
2183:
2184: --
2185: -- custom_setup_id
2186: IF p_venue_rec.custom_setup_id = FND_API.g_miss_num THEN
2187: x_complete_rec.custom_setup_id := l_venue_rec.custom_setup_id;
2188: END IF;
2189:
2190: --

Line 2192: IF p_venue_rec.internal_flag = FND_API.g_miss_char THEN

2188: END IF;
2189:
2190: --
2191: -- INTERNAL_FLAG
2192: IF p_venue_rec.internal_flag = FND_API.g_miss_char THEN
2193: x_complete_rec.internal_flag := l_venue_rec.internal_flag;
2194: END IF;
2195:
2196: --

Line 2198: IF p_venue_rec.direct_phone_flag = FND_API.g_miss_char THEN

2194: END IF;
2195:
2196: --
2197: -- DIRECT_PHONE_FLAG
2198: IF p_venue_rec.direct_phone_flag = FND_API.g_miss_char THEN
2199: x_complete_rec.direct_phone_flag := l_venue_rec.direct_phone_flag;
2200: END IF;
2201:
2202: --

Line 2204: IF p_venue_rec.enabled_flag = FND_API.g_miss_char THEN

2200: END IF;
2201:
2202: --
2203: -- ENABLED_FLAG
2204: IF p_venue_rec.enabled_flag = FND_API.g_miss_char THEN
2205: x_complete_rec.enabled_flag := l_venue_rec.enabled_flag;
2206: END IF;
2207:
2208: --

Line 2210: IF p_venue_rec.rating_code = FND_API.g_miss_char THEN

2206: END IF;
2207:
2208: --
2209: --RATING_CODE
2210: IF p_venue_rec.rating_code = FND_API.g_miss_char THEN
2211: x_complete_rec.rating_code := l_venue_rec.rating_code;
2212: END IF;
2213:
2214: --

Line 2216: IF p_venue_rec.telecom_code = FND_API.g_miss_char THEN

2212: END IF;
2213:
2214: --
2215: --TELECOM_CODE
2216: IF p_venue_rec.telecom_code = FND_API.g_miss_char THEN
2217: x_complete_rec.telecom_code := l_venue_rec.telecom_code;
2218: END IF;
2219:
2220: --

Line 2222: IF p_venue_rec.capacity = FND_API.g_miss_num THEN

2218: END IF;
2219:
2220: --
2221: --CAPACITY
2222: IF p_venue_rec.capacity = FND_API.g_miss_num THEN
2223: x_complete_rec.capacity := l_venue_rec.capacity;
2224: END IF;
2225:
2226: --

Line 2228: IF p_venue_rec.area_size = FND_API.g_miss_num THEN

2224: END IF;
2225:
2226: --
2227: --AREA_SIZE
2228: IF p_venue_rec.area_size = FND_API.g_miss_num THEN
2229: x_complete_rec.area_size := l_venue_rec.area_size;
2230: END IF;
2231:
2232: --

Line 2234: IF p_venue_rec.area_size_uom_code = FND_API.g_miss_char THEN

2230: END IF;
2231:
2232: --
2233: --AREA_SIZE_UOM_CODE
2234: IF p_venue_rec.area_size_uom_code = FND_API.g_miss_char THEN
2235: x_complete_rec.area_size_uom_code := l_venue_rec.area_size_uom_code;
2236: END IF;
2237:
2238: --

Line 2240: IF p_venue_rec.ceiling_height = FND_API.g_miss_num THEN

2236: END IF;
2237:
2238: --
2239: -- CEILING_HEIGHT
2240: IF p_venue_rec.ceiling_height = FND_API.g_miss_num THEN
2241: x_complete_rec.ceiling_height := l_venue_rec.ceiling_height;
2242: END IF;
2243:
2244: --

Line 2246: IF p_venue_rec.ceiling_height_uom_code = FND_API.g_miss_char THEN

2242: END IF;
2243:
2244: --
2245: --CEILING_HEIGHT_UOM_CODE
2246: IF p_venue_rec.ceiling_height_uom_code = FND_API.g_miss_char THEN
2247: x_complete_rec.ceiling_height_uom_code := l_venue_rec.ceiling_height_uom_code;
2248: END IF;
2249:
2250: --

Line 2252: IF p_venue_rec.usage_cost = FND_API.g_miss_num THEN

2248: END IF;
2249:
2250: --
2251: --USAGE_COST
2252: IF p_venue_rec.usage_cost = FND_API.g_miss_num THEN
2253: x_complete_rec.usage_cost := l_venue_rec.usage_cost;
2254: END IF;
2255:
2256: --

Line 2258: IF p_venue_rec.usage_cost_uom_code = FND_API.g_miss_char THEN

2254: END IF;
2255:
2256: --
2257: --USAGE_COST_UOM_CODE
2258: IF p_venue_rec.usage_cost_uom_code = FND_API.g_miss_char THEN
2259: x_complete_rec.usage_cost_uom_code := l_venue_rec.usage_cost_uom_code;
2260: END IF;
2261: --
2262: --USAGE_COST_CURRENCY_CODE

Line 2263: IF p_venue_rec.usage_cost_currency_code = FND_API.g_miss_char THEN

2259: x_complete_rec.usage_cost_uom_code := l_venue_rec.usage_cost_uom_code;
2260: END IF;
2261: --
2262: --USAGE_COST_CURRENCY_CODE
2263: IF p_venue_rec.usage_cost_currency_code = FND_API.g_miss_char THEN
2264: x_complete_rec.usage_cost_currency_code := l_venue_rec.usage_cost_currency_code;
2265: END IF;
2266:
2267: --

Line 2269: IF p_venue_rec.parent_venue_id = FND_API.g_miss_num THEN

2265: END IF;
2266:
2267: --
2268: --PARENT_VENUE_ID
2269: IF p_venue_rec.parent_venue_id = FND_API.g_miss_num THEN
2270: x_complete_rec.parent_venue_id := l_venue_rec.parent_venue_id;
2271: END IF;
2272:
2273: --

Line 2275: IF p_venue_rec.directions = FND_API.g_miss_char THEN

2271: END IF;
2272:
2273: --
2274: --DIRECTIONS
2275: IF p_venue_rec.directions = FND_API.g_miss_char THEN
2276: x_complete_rec.directions := l_venue_rec.directions;
2277: END IF;
2278:
2279: --

Line 2281: IF p_venue_rec.venue_code = FND_API.g_miss_char THEN

2277: END IF;
2278:
2279: --
2280: --VENUE_CODE
2281: IF p_venue_rec.venue_code = FND_API.g_miss_char THEN
2282: x_complete_rec.venue_code := l_venue_rec.venue_code;
2283: END IF;
2284:
2285: --

Line 2287: IF p_venue_rec.object_type = FND_API.g_miss_char THEN

2283: END IF;
2284:
2285: --
2286: --OBJECT_TYPE
2287: IF p_venue_rec.object_type = FND_API.g_miss_char THEN
2288: x_complete_rec.object_type := l_venue_rec.object_type;
2289: END IF;
2290:
2291: --

Line 2293: IF p_venue_rec.attribute_category = FND_API.g_miss_char THEN

2289: END IF;
2290:
2291: --
2292: -- ATTRIBUTE_CATEGORY
2293: IF p_venue_rec.attribute_category = FND_API.g_miss_char THEN
2294: x_complete_rec.attribute_category := l_venue_rec.attribute_category;
2295: END IF;
2296:
2297: --

Line 2299: IF p_venue_rec.attribute1 = FND_API.g_miss_char THEN

2295: END IF;
2296:
2297: --
2298: -- ATTRIBUTE1
2299: IF p_venue_rec.attribute1 = FND_API.g_miss_char THEN
2300: x_complete_rec.attribute1 := l_venue_rec.attribute1;
2301: END IF;
2302:
2303: --

Line 2305: IF p_venue_rec.attribute2 = FND_API.g_miss_char THEN

2301: END IF;
2302:
2303: --
2304: -- ATTRIBUTE2
2305: IF p_venue_rec.attribute2 = FND_API.g_miss_char THEN
2306: x_complete_rec.attribute2 := l_venue_rec.attribute2;
2307: END IF;
2308:
2309: --

Line 2311: IF p_venue_rec.attribute3 = FND_API.g_miss_char THEN

2307: END IF;
2308:
2309: --
2310: -- ATTRIBUTE3
2311: IF p_venue_rec.attribute3 = FND_API.g_miss_char THEN
2312: x_complete_rec.attribute3 := l_venue_rec.attribute3;
2313: END IF;
2314:
2315: --

Line 2317: IF p_venue_rec.attribute4 = FND_API.g_miss_char THEN

2313: END IF;
2314:
2315: --
2316: -- ATTRIBUTE4
2317: IF p_venue_rec.attribute4 = FND_API.g_miss_char THEN
2318: x_complete_rec.attribute4 := l_venue_rec.attribute4;
2319: END IF;
2320:
2321: --

Line 2323: IF p_venue_rec.attribute5 = FND_API.g_miss_char THEN

2319: END IF;
2320:
2321: --
2322: -- ATTRIBUTE5
2323: IF p_venue_rec.attribute5 = FND_API.g_miss_char THEN
2324: x_complete_rec.attribute5 := l_venue_rec.attribute5;
2325: END IF;
2326:
2327: --

Line 2329: IF p_venue_rec.attribute6 = FND_API.g_miss_char THEN

2325: END IF;
2326:
2327: --
2328: -- ATTRIBUTE6
2329: IF p_venue_rec.attribute6 = FND_API.g_miss_char THEN
2330: x_complete_rec.attribute6 := l_venue_rec.attribute6;
2331: END IF;
2332:
2333: --

Line 2335: IF p_venue_rec.attribute7 = FND_API.g_miss_char THEN

2331: END IF;
2332:
2333: --
2334: -- ATTRIBUTE7
2335: IF p_venue_rec.attribute7 = FND_API.g_miss_char THEN
2336: x_complete_rec.attribute7 := l_venue_rec.attribute7;
2337: END IF;
2338:
2339: --

Line 2341: IF p_venue_rec.attribute8 = FND_API.g_miss_char THEN

2337: END IF;
2338:
2339: --
2340: -- ATTRIBUTE8
2341: IF p_venue_rec.attribute8 = FND_API.g_miss_char THEN
2342: x_complete_rec.attribute8 := l_venue_rec.attribute8;
2343: END IF;
2344:
2345: --

Line 2347: IF p_venue_rec.attribute9 = FND_API.g_miss_char THEN

2343: END IF;
2344:
2345: --
2346: -- ATTRIBUTE9
2347: IF p_venue_rec.attribute9 = FND_API.g_miss_char THEN
2348: x_complete_rec.attribute9 := l_venue_rec.attribute9;
2349: END IF;
2350:
2351: --

Line 2353: IF p_venue_rec.attribute10 = FND_API.g_miss_char THEN

2349: END IF;
2350:
2351: --
2352: -- ATTRIBUTE10
2353: IF p_venue_rec.attribute10 = FND_API.g_miss_char THEN
2354: x_complete_rec.attribute10 := l_venue_rec.attribute10;
2355: END IF;
2356:
2357: --

Line 2359: IF p_venue_rec.attribute11 = FND_API.g_miss_char THEN

2355: END IF;
2356:
2357: --
2358: -- ATTRIBUTE11
2359: IF p_venue_rec.attribute11 = FND_API.g_miss_char THEN
2360: x_complete_rec.attribute11 := l_venue_rec.attribute11;
2361: END IF;
2362:
2363: --

Line 2365: IF p_venue_rec.attribute12 = FND_API.g_miss_char THEN

2361: END IF;
2362:
2363: --
2364: -- ATTRIBUTE12
2365: IF p_venue_rec.attribute12 = FND_API.g_miss_char THEN
2366: x_complete_rec.attribute12 := l_venue_rec.attribute12;
2367: END IF;
2368:
2369: --

Line 2371: IF p_venue_rec.attribute13 = FND_API.g_miss_char THEN

2367: END IF;
2368:
2369: --
2370: -- ATTRIBUTE13
2371: IF p_venue_rec.attribute13 = FND_API.g_miss_char THEN
2372: x_complete_rec.attribute13 := l_venue_rec.attribute13;
2373: END IF;
2374:
2375: --

Line 2377: IF p_venue_rec.attribute14 = FND_API.g_miss_char THEN

2373: END IF;
2374:
2375: --
2376: -- ATTRIBUTE14
2377: IF p_venue_rec.attribute14 = FND_API.g_miss_char THEN
2378: x_complete_rec.attribute14 := l_venue_rec.attribute14;
2379: END IF;
2380:
2381: --

Line 2383: IF p_venue_rec.attribute15 = FND_API.g_miss_char THEN

2379: END IF;
2380:
2381: --
2382: -- ATTRIBUTE15
2383: IF p_venue_rec.attribute15 = FND_API.g_miss_char THEN
2384: x_complete_rec.attribute15 := l_venue_rec.attribute15;
2385: END IF;
2386:
2387: --

Line 2389: IF p_venue_rec.venue_name = FND_API.g_miss_char THEN

2385: END IF;
2386:
2387: --
2388: -- VENUE_NAME
2389: IF p_venue_rec.venue_name = FND_API.g_miss_char THEN
2390: x_complete_rec.venue_name := l_venue_rec.venue_name;
2391: END IF;
2392:
2393: --

Line 2395: IF p_venue_rec.description = FND_API.g_miss_char THEN

2391: END IF;
2392:
2393: --
2394: -- DESCRIPTION
2395: IF p_venue_rec.description = FND_API.g_miss_char THEN
2396: x_complete_rec.description := l_venue_rec.description;
2397: END IF;
2398:
2399: -- modified sugupta 07/10/2000 added completion for city, state, country and address

Line 2400: IF p_venue_rec.address1 = FND_API.g_miss_char THEN

2396: x_complete_rec.description := l_venue_rec.description;
2397: END IF;
2398:
2399: -- modified sugupta 07/10/2000 added completion for city, state, country and address
2400: IF p_venue_rec.address1 = FND_API.g_miss_char THEN
2401: x_complete_rec.address1 := l_address1;
2402: END IF;
2403: IF p_venue_rec.address2 = FND_API.g_miss_char THEN
2404: x_complete_rec.address2 := l_address2;

Line 2403: IF p_venue_rec.address2 = FND_API.g_miss_char THEN

2399: -- modified sugupta 07/10/2000 added completion for city, state, country and address
2400: IF p_venue_rec.address1 = FND_API.g_miss_char THEN
2401: x_complete_rec.address1 := l_address1;
2402: END IF;
2403: IF p_venue_rec.address2 = FND_API.g_miss_char THEN
2404: x_complete_rec.address2 := l_address2;
2405: END IF;
2406: IF p_venue_rec.city = FND_API.g_miss_char THEN
2407: x_complete_rec.city := l_city;

Line 2406: IF p_venue_rec.city = FND_API.g_miss_char THEN

2402: END IF;
2403: IF p_venue_rec.address2 = FND_API.g_miss_char THEN
2404: x_complete_rec.address2 := l_address2;
2405: END IF;
2406: IF p_venue_rec.city = FND_API.g_miss_char THEN
2407: x_complete_rec.city := l_city;
2408: END IF;
2409: IF p_venue_rec.state = FND_API.g_miss_char THEN
2410: x_complete_rec.state := l_state;

Line 2409: IF p_venue_rec.state = FND_API.g_miss_char THEN

2405: END IF;
2406: IF p_venue_rec.city = FND_API.g_miss_char THEN
2407: x_complete_rec.city := l_city;
2408: END IF;
2409: IF p_venue_rec.state = FND_API.g_miss_char THEN
2410: x_complete_rec.state := l_state;
2411: END IF;
2412: IF p_venue_rec.country = FND_API.g_miss_char THEN
2413: x_complete_rec.country := l_country;

Line 2412: IF p_venue_rec.country = FND_API.g_miss_char THEN

2408: END IF;
2409: IF p_venue_rec.state = FND_API.g_miss_char THEN
2410: x_complete_rec.state := l_state;
2411: END IF;
2412: IF p_venue_rec.country = FND_API.g_miss_char THEN
2413: x_complete_rec.country := l_country;
2414: END IF;
2415:
2416: -- GDEODHAR : Sept. 29, 2000. Noticed that the complete rec does not complete

Line 2422: IF p_venue_rec.location_id = FND_API.g_miss_num THEN

2418: -- gives rise to bugs. Added the following :
2419:
2420: --
2421: --LOCATION_ID
2422: IF p_venue_rec.location_id = FND_API.g_miss_num THEN
2423: x_complete_rec.location_id := l_venue_rec.location_id;
2424: END IF;
2425:
2426: --

Line 2428: IF p_venue_rec.party_id = FND_API.g_miss_num THEN

2424: END IF;
2425:
2426: --
2427: -- PARTY_ID
2428: IF p_venue_rec.party_id = FND_API.g_miss_num THEN
2429: x_complete_rec.party_id := l_venue_rec.party_id;
2430: END IF;
2431:
2432: END Complete_Venue_Rec;

Line 2453: x_return_status := FND_API.g_ret_sts_error;

2449: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2450: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_VENUE_TYPE');
2451: FND_MSG_PUB.add;
2452: END IF;
2453: x_return_status := FND_API.g_ret_sts_error;
2454: RETURN;
2455: END IF;
2456:
2457: -- VENUE_NAME

Line 2467: x_return_status := FND_API.g_ret_sts_error;

2463: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_VENUE_NAME');
2464: FND_MSG_PUB.add;
2465: END IF;
2466:
2467: x_return_status := FND_API.g_ret_sts_error;
2468: RETURN;
2469: END IF;
2470:
2471: -- PARENT_VENUE_ID (For Rooms Only)

Line 2481: x_return_status := FND_API.g_ret_sts_error;

2477: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_NO_PARENT_ID');
2478: FND_MSG_PUB.add;
2479: END IF;
2480:
2481: x_return_status := FND_API.g_ret_sts_error;
2482: RETURN;
2483: END IF;
2484:
2485:

Line 2513: x_return_status := FND_API.g_ret_sts_success;

2509: where VENUE_NAME = vnu_name_in
2510: and VENUE_ID = vnu_id_in);
2511: */
2512: BEGIN
2513: x_return_status := FND_API.g_ret_sts_success;
2514:
2515: -- VENUE_ID
2516: -- For Create_Venue, when ID is passed in, we need to
2517: -- check if this ID is unique.

Line 2524: ) = FND_API.g_false

2520: THEN
2521: IF AMS_Utility_PVT.check_uniqueness(
2522: 'ams_venues_vl',
2523: 'venue_id = ' || p_venue_rec.venue_id
2524: ) = FND_API.g_false
2525: THEN
2526: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2527: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_VENUE_ID');
2528: FND_MSG_PUB.add;

Line 2531: x_return_status := FND_API.g_ret_sts_error;

2527: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_VENUE_ID');
2528: FND_MSG_PUB.add;
2529:
2530: END IF;
2531: x_return_status := FND_API.g_ret_sts_error;
2532:
2533: RETURN;
2534: END IF;
2535: END IF;

Line 2578: --IF l_valid_flag = FND_API.g_false THEN bug # 1490374

2574: fetch c_vnu_name into l_dummy;
2575: close c_vnu_name;
2576: */
2577: IF l_dummy = 1 THEN
2578: --IF l_valid_flag = FND_API.g_false THEN bug # 1490374
2579:
2580: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2581: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_DUP_NAME');
2582: FND_MSG_PUB.add;

Line 2586: x_return_status := FND_API.g_ret_sts_error;

2582: FND_MSG_PUB.add;
2583:
2584:
2585: END IF;
2586: x_return_status := FND_API.g_ret_sts_error;
2587:
2588: RETURN;
2589: END IF;
2590: END IF;

Line 2604: x_return_status := FND_API.g_ret_sts_success;

2600: IS
2601: --
2602: -- Check for the Locations FK
2603: BEGIN
2604: x_return_status := FND_API.g_ret_sts_success;
2605:
2606: ----------------------- venue party_id ------------------------
2607: IF nvl(p_object_type, 'VENU') <> 'ROOM' THEN
2608: IF p_venue_rec.location_id <> FND_API.g_miss_num THEN

Line 2608: IF p_venue_rec.location_id <> FND_API.g_miss_num THEN

2604: x_return_status := FND_API.g_ret_sts_success;
2605:
2606: ----------------------- venue party_id ------------------------
2607: IF nvl(p_object_type, 'VENU') <> 'ROOM' THEN
2608: IF p_venue_rec.location_id <> FND_API.g_miss_num THEN
2609: IF AMS_Utility_PVT.check_fk_exists(
2610: 'hz_parties',
2611: 'party_id',
2612: p_venue_rec.party_id

Line 2613: ) = FND_API.g_false

2609: IF AMS_Utility_PVT.check_fk_exists(
2610: 'hz_parties',
2611: 'party_id',
2612: p_venue_rec.party_id
2613: ) = FND_API.g_false
2614: THEN
2615: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2616: THEN
2617: FND_MESSAGE.set_name('AMS', 'AMS_VENUE_BAD_LOCATION_ID');

Line 2621: x_return_status := FND_API.g_ret_sts_error;

2617: FND_MESSAGE.set_name('AMS', 'AMS_VENUE_BAD_LOCATION_ID');
2618: FND_MSG_PUB.add;
2619: END IF;
2620:
2621: x_return_status := FND_API.g_ret_sts_error;
2622: RETURN;
2623: END IF;
2624: END IF;
2625: ELSE

Line 2626: IF p_venue_rec.parent_venue_id <> FND_API.g_miss_num THEN

2622: RETURN;
2623: END IF;
2624: END IF;
2625: ELSE
2626: IF p_venue_rec.parent_venue_id <> FND_API.g_miss_num THEN
2627: IF AMS_Utility_PVT.check_fk_exists(
2628: 'ams_venues_b',
2629: 'venue_id',
2630: p_venue_rec.parent_venue_id

Line 2631: ) = FND_API.g_false

2627: IF AMS_Utility_PVT.check_fk_exists(
2628: 'ams_venues_b',
2629: 'venue_id',
2630: p_venue_rec.parent_venue_id
2631: ) = FND_API.g_false
2632: THEN
2633: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2634: THEN
2635: FND_MESSAGE.set_name('AMS', 'AMS_ROOM_BAD_PARENT_VENUE');

Line 2639: x_return_status := FND_API.g_ret_sts_error;

2635: FND_MESSAGE.set_name('AMS', 'AMS_ROOM_BAD_PARENT_VENUE');
2636: FND_MSG_PUB.add;
2637: END IF;
2638:
2639: x_return_status := FND_API.g_ret_sts_error;
2640: RETURN;
2641: END IF;
2642: END IF;
2643:

Line 2648: IF p_evh_rec.currency_code_fc <> FND_API.g_miss_char

2644: END IF;
2645:
2646: /*
2647: --------------------- currency_code_fc ------------------------
2648: IF p_evh_rec.currency_code_fc <> FND_API.g_miss_char
2649: AND p_evh_rec.currency_code_fc IS NOT NULL
2650: THEN
2651: IF AMS_Utility_PVT.check_fk_exists(
2652: 'fnd_currencies_vl',

Line 2656: ) = FND_API.g_false

2652: 'fnd_currencies_vl',
2653: 'currency_code',
2654: p_evh_rec.currency_code_fc,
2655: AMS_Utility_PVT.g_varchar2
2656: ) = FND_API.g_false
2657: THEN
2658: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2659: THEN
2660: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CURRENCY_CODE_FC');

Line 2663: x_return_status := FND_API.g_ret_sts_error;

2659: THEN
2660: FND_MESSAGE.set_name('AMS', 'AMS_EVH_BAD_CURRENCY_CODE_FC');
2661: FND_MSG_PUB.add;
2662: END IF;
2663: x_return_status := FND_API.g_ret_sts_error;
2664: RETURN;
2665: END IF;
2666: END IF;
2667:

Line 2682: x_return_status := FND_API.g_ret_sts_success;

2678: L_AREA_SIZE_UOM_CODE CONSTANT VARCHAR(30) := 'AMS_VENUE_AREA_SIZE_UOM_CODE';
2679: L_USAGE_COST_CURRENCY_CODE CONSTANT VARCHAR(30) := 'AMS_USAGE_COST_CURRENCY_CODE';
2680: L_CEILING_HEIGHT_UOM_CODE CONSTANT VARCHAR(30) := 'AMS_CEILING_HEIGHT_UOM_CODE';
2681: BEGIN
2682: x_return_status := FND_API.g_ret_sts_success;
2683:
2684: /* --
2685: -- VENUE_TYPE_CODE
2686: IF p_venue_rec.venue_type_code <> FND_API.g_miss_char THEN

Line 2686: IF p_venue_rec.venue_type_code <> FND_API.g_miss_char THEN

2682: x_return_status := FND_API.g_ret_sts_success;
2683:
2684: /* --
2685: -- VENUE_TYPE_CODE
2686: IF p_venue_rec.venue_type_code <> FND_API.g_miss_char THEN
2687: IF AMS_Utility_PVT.check_lookup_exists (
2688: p_lookup_type => L_VENUE_TYPE,
2689: p_lookup_code => p_venue_rec.venue_type_code
2690: ) = FND_API.g_false

Line 2690: ) = FND_API.g_false

2686: IF p_venue_rec.venue_type_code <> FND_API.g_miss_char THEN
2687: IF AMS_Utility_PVT.check_lookup_exists (
2688: p_lookup_type => L_VENUE_TYPE,
2689: p_lookup_code => p_venue_rec.venue_type_code
2690: ) = FND_API.g_false
2691: THEN
2692: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2693: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_VENUE_TYPE');
2694: FND_MSG_PUB.add;

Line 2697: x_return_status := FND_API.g_ret_sts_error;

2693: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_VENUE_TYPE');
2694: FND_MSG_PUB.add;
2695: END IF;
2696:
2697: x_return_status := FND_API.g_ret_sts_error;
2698: RETURN;
2699: END IF;
2700: END IF;
2701: */

Line 2706: IF p_venue_rec.area_size_uom_code <> FND_API.g_miss_char THEN

2702:
2703: /*
2704: --
2705: -- AREA_SIZE_UOM_CODE
2706: IF p_venue_rec.area_size_uom_code <> FND_API.g_miss_char THEN
2707: IF AMS_Utility_PVT.check_lookup_exists (
2708: p_lookup_type => L_AREA_SIZE_UOM_CODE,
2709: p_lookup_code => p_venue_rec.area_size_uom_code
2710: ) = FND_API.g_false

Line 2710: ) = FND_API.g_false

2706: IF p_venue_rec.area_size_uom_code <> FND_API.g_miss_char THEN
2707: IF AMS_Utility_PVT.check_lookup_exists (
2708: p_lookup_type => L_AREA_SIZE_UOM_CODE,
2709: p_lookup_code => p_venue_rec.area_size_uom_code
2710: ) = FND_API.g_false
2711: THEN
2712: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2713: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_AREA_SIZE_UOM_CODE');
2714: FND_MSG_PUB.add;

Line 2717: x_return_status := FND_API.g_ret_sts_error;

2713: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_AREA_SIZE_UOM_CODE');
2714: FND_MSG_PUB.add;
2715: END IF;
2716:
2717: x_return_status := FND_API.g_ret_sts_error;
2718: RETURN;
2719: END IF;
2720: END IF;
2721:

Line 2726: IF p_venue_rec.ceiling_height_uom_code <> FND_API.g_miss_char THEN

2722:
2723:
2724: --
2725: -- CEILING_HEIGHT_UOM_CODE
2726: IF p_venue_rec.ceiling_height_uom_code <> FND_API.g_miss_char THEN
2727: IF AMS_Utility_PVT.check_lookup_exists (
2728: p_lookup_type => L_CEILING_HEIGHT_UOM_CODE,
2729: p_lookup_code => p_venue_rec.ceiling_height_uom_code
2730: ) = FND_API.g_false

Line 2730: ) = FND_API.g_false

2726: IF p_venue_rec.ceiling_height_uom_code <> FND_API.g_miss_char THEN
2727: IF AMS_Utility_PVT.check_lookup_exists (
2728: p_lookup_type => L_CEILING_HEIGHT_UOM_CODE,
2729: p_lookup_code => p_venue_rec.ceiling_height_uom_code
2730: ) = FND_API.g_false
2731: THEN
2732: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2733: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_CEILING_HEIGHT_UOM_CODE');
2734: FND_MSG_PUB.add;

Line 2737: x_return_status := FND_API.g_ret_sts_error;

2733: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_CEILING_HEIGHT_UOM_CODE');
2734: FND_MSG_PUB.add;
2735: END IF;
2736:
2737: x_return_status := FND_API.g_ret_sts_error;
2738: RETURN;
2739: END IF;
2740: END IF;
2741:

Line 2744: IF p_venue_rec.usage_cost_currency_code <> FND_API.g_miss_char THEN

2740: END IF;
2741:
2742: --
2743: -- USAGE_COST_CURRENCY_CODE
2744: IF p_venue_rec.usage_cost_currency_code <> FND_API.g_miss_char THEN
2745: IF AMS_Utility_PVT.check_lookup_exists (
2746: p_lookup_type => L_USAGE_COST_CURRENCY_CODE,
2747: p_lookup_code => p_venue_rec.usage_cost_currency_code
2748: ) = FND_API.g_false

Line 2748: ) = FND_API.g_false

2744: IF p_venue_rec.usage_cost_currency_code <> FND_API.g_miss_char THEN
2745: IF AMS_Utility_PVT.check_lookup_exists (
2746: p_lookup_type => L_USAGE_COST_CURRENCY_CODE,
2747: p_lookup_code => p_venue_rec.usage_cost_currency_code
2748: ) = FND_API.g_false
2749: THEN
2750: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2751: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_USAGE_COST_CURRENCY_CODE');
2752: FND_MSG_PUB.add;

Line 2755: x_return_status := FND_API.g_ret_sts_error;

2751: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_USAGE_COST_CURRENCY_CODE');
2752: FND_MSG_PUB.add;
2753: END IF;
2754:
2755: x_return_status := FND_API.g_ret_sts_error;
2756: RETURN;
2757: END IF;
2758: END IF;
2759:

Line 2773: x_return_status := FND_API.g_ret_sts_success;

2769: x_return_status OUT NOCOPY VARCHAR2
2770: )
2771: IS
2772: BEGIN
2773: x_return_status := FND_API.g_ret_sts_success;
2774:
2775: -- INTERNAL_FLAG
2776: IF p_venue_rec.internal_flag <> FND_API.g_miss_char AND p_venue_rec.internal_flag IS NOT NULL THEN
2777: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.internal_flag) = FND_API.g_false THEN

Line 2776: IF p_venue_rec.internal_flag <> FND_API.g_miss_char AND p_venue_rec.internal_flag IS NOT NULL THEN

2772: BEGIN
2773: x_return_status := FND_API.g_ret_sts_success;
2774:
2775: -- INTERNAL_FLAG
2776: IF p_venue_rec.internal_flag <> FND_API.g_miss_char AND p_venue_rec.internal_flag IS NOT NULL THEN
2777: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.internal_flag) = FND_API.g_false THEN
2778: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2779: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_INTERNAL_FLAG');
2780: FND_MSG_PUB.add;

Line 2777: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.internal_flag) = FND_API.g_false THEN

2773: x_return_status := FND_API.g_ret_sts_success;
2774:
2775: -- INTERNAL_FLAG
2776: IF p_venue_rec.internal_flag <> FND_API.g_miss_char AND p_venue_rec.internal_flag IS NOT NULL THEN
2777: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.internal_flag) = FND_API.g_false THEN
2778: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2779: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_INTERNAL_FLAG');
2780: FND_MSG_PUB.add;
2781: END IF;

Line 2783: x_return_status := FND_API.g_ret_sts_error;

2779: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_INTERNAL_FLAG');
2780: FND_MSG_PUB.add;
2781: END IF;
2782:
2783: x_return_status := FND_API.g_ret_sts_error;
2784: RETURN;
2785: END IF;
2786: END IF;
2787:

Line 2789: IF p_venue_rec.enabled_flag <> FND_API.g_miss_char AND p_venue_rec.enabled_flag IS NOT NULL THEN

2785: END IF;
2786: END IF;
2787:
2788: -- ENABLED_FLAG
2789: IF p_venue_rec.enabled_flag <> FND_API.g_miss_char AND p_venue_rec.enabled_flag IS NOT NULL THEN
2790: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.enabled_flag) = FND_API.g_false THEN
2791: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2792: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_ENABLED_FLAG');
2793: FND_MSG_PUB.add;

Line 2790: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.enabled_flag) = FND_API.g_false THEN

2786: END IF;
2787:
2788: -- ENABLED_FLAG
2789: IF p_venue_rec.enabled_flag <> FND_API.g_miss_char AND p_venue_rec.enabled_flag IS NOT NULL THEN
2790: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.enabled_flag) = FND_API.g_false THEN
2791: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2792: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_ENABLED_FLAG');
2793: FND_MSG_PUB.add;
2794: END IF;

Line 2796: x_return_status := FND_API.g_ret_sts_error;

2792: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_ENABLED_FLAG');
2793: FND_MSG_PUB.add;
2794: END IF;
2795:
2796: x_return_status := FND_API.g_ret_sts_error;
2797: RETURN;
2798: END IF;
2799: END IF;
2800:

Line 2802: IF p_venue_rec.direct_phone_flag <> FND_API.g_miss_char AND p_venue_rec.direct_phone_flag IS NOT NULL THEN

2798: END IF;
2799: END IF;
2800:
2801: -- DIRECT_PHONE_FLAG
2802: IF p_venue_rec.direct_phone_flag <> FND_API.g_miss_char AND p_venue_rec.direct_phone_flag IS NOT NULL THEN
2803: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.direct_phone_flag) = FND_API.g_false THEN
2804: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2805: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_DIRECT_PH');
2806: FND_MSG_PUB.add;

Line 2803: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.direct_phone_flag) = FND_API.g_false THEN

2799: END IF;
2800:
2801: -- DIRECT_PHONE_FLAG
2802: IF p_venue_rec.direct_phone_flag <> FND_API.g_miss_char AND p_venue_rec.direct_phone_flag IS NOT NULL THEN
2803: IF AMS_Utility_PVT.is_Y_or_N (p_venue_rec.direct_phone_flag) = FND_API.g_false THEN
2804: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_error) THEN
2805: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_DIRECT_PH');
2806: FND_MSG_PUB.add;
2807: END IF;

Line 2809: x_return_status := FND_API.g_ret_sts_error;

2805: FND_MESSAGE.set_name ('AMS', 'AMS_VENUE_BAD_DIRECT_PH');
2806: FND_MSG_PUB.add;
2807: END IF;
2808:
2809: x_return_status := FND_API.g_ret_sts_error;
2810: RETURN;
2811: END IF;
2812: END IF;
2813: