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

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

22: -- ========================================================================
23:
24: PROCEDURE WEBMARKETING_PLCE_CONTENT_TYPE (
25: p_api_version_number IN NUMBER := 1.0,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: p_placement_mp_id IN NUMBER,
30: placement_id IN NUMBER,

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

23:
24: PROCEDURE WEBMARKETING_PLCE_CONTENT_TYPE (
25: p_api_version_number IN NUMBER := 1.0,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: p_placement_mp_id IN NUMBER,
30: placement_id IN NUMBER,
31: x_content_type OUT NOCOPY VARCHAR2,

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

24: PROCEDURE WEBMARKETING_PLCE_CONTENT_TYPE (
25: p_api_version_number IN NUMBER := 1.0,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: p_placement_mp_id IN NUMBER,
30: placement_id IN NUMBER,
31: x_content_type OUT NOCOPY VARCHAR2,
32: x_msg_count OUT NOCOPY NUMBER,

Line 44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

40:
41: BEGIN
42:
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)
48: THEN

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)
48: THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: -- Standard Start of API savepoint
53:

Line 59: x_return_status := FND_API.g_ret_sts_error;

55:
56: EXCEPTION
57:
58: WHEN AMS_Utility_PVT.resource_locked THEN
59: x_return_status := FND_API.g_ret_sts_error;
60: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
61:
62:
63: WHEN FND_API.G_EXC_ERROR THEN

Line 63: WHEN FND_API.G_EXC_ERROR THEN

59: x_return_status := FND_API.g_ret_sts_error;
60: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
61:
62:
63: WHEN FND_API.G_EXC_ERROR THEN
64: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: -- Standard call to get message count and if count=1, get the message
67:

Line 65: x_return_status := FND_API.G_RET_STS_ERROR;

61:
62:
63: WHEN FND_API.G_EXC_ERROR THEN
64: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66: -- Standard call to get message count and if count=1, get the message
67:
68: FND_MSG_PUB.Count_And_Get (
69: p_encoded => FND_API.G_FALSE,

Line 69: p_encoded => FND_API.G_FALSE,

65: x_return_status := FND_API.G_RET_STS_ERROR;
66: -- Standard call to get message count and if count=1, get the message
67:
68: FND_MSG_PUB.Count_And_Get (
69: p_encoded => FND_API.G_FALSE,
70: p_count => x_msg_count,
71: p_data => x_msg_data
72: );
73:

Line 74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

70: p_count => x_msg_count,
71: p_data => x_msg_data
72: );
73:
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: -- Standard call to get message count and if count=1, get the message

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

72: );
73:
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: -- Standard call to get message count and if count=1, get the message
79: FND_MSG_PUB.Count_And_Get (
80: p_encoded => FND_API.G_FALSE,

Line 80: p_encoded => FND_API.G_FALSE,

76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77:
78: -- Standard call to get message count and if count=1, get the message
79: FND_MSG_PUB.Count_And_Get (
80: p_encoded => FND_API.G_FALSE,
81: p_count => x_msg_count,
82: p_data => x_msg_data
83: );
84:

Line 87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

83: );
84:
85: WHEN OTHERS THEN
86: ROLLBACK TO WEBMARKETING_PLCE_CONTENT_TYPE;
87: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
88: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
89: THEN
90: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
91: END IF;

Line 94: p_encoded => FND_API.G_FALSE,

90: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
91: END IF;
92: -- Standard call to get message count and if count=1, get the message
93: FND_MSG_PUB.Count_And_Get (
94: p_encoded => FND_API.G_FALSE,
95: p_count => x_msg_count,
96: p_data => x_msg_data
97: );
98:

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

110: -- ========================================================================
111:
112: PROCEDURE WEBMARKETING_PLCE_CITEMS (
113: p_api_version_number IN NUMBER := 1.0,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_placement_mp_id IN NUMBER,
118: p_web_mp_rec IN web_mp_track_rec_type := g_miss_web_mp_track_rec,

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

111:
112: PROCEDURE WEBMARKETING_PLCE_CITEMS (
113: p_api_version_number IN NUMBER := 1.0,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_placement_mp_id IN NUMBER,
118: p_web_mp_rec IN web_mp_track_rec_type := g_miss_web_mp_track_rec,
119: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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

112: PROCEDURE WEBMARKETING_PLCE_CITEMS (
113: p_api_version_number IN NUMBER := 1.0,
114: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
115: p_commit IN VARCHAR2 := FND_API.G_FALSE,
116: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
117: p_placement_mp_id IN NUMBER,
118: p_web_mp_rec IN web_mp_track_rec_type := g_miss_web_mp_track_rec,
119: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
120: p_content_item_id IN NUMBER,

Line 179: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

175:
176: BEGIN
177:
178: -- Standard call to check for call compatibility.
179: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
180: p_api_version_number,
181: l_api_name,
182: G_PKG_NAME)
183: THEN

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180: p_api_version_number,
181: l_api_name,
182: G_PKG_NAME)
183: THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186:
187: -- Standard Start of API savepoint
188:

Line 192: IF FND_API.to_Boolean( p_init_msg_list )

188:
189: SAVEPOINT webmarketing_plce_citems_pvt;
190:
191: -- Initialize message list if p_init_msg_list is set to TRUE.
192: IF FND_API.to_Boolean( p_init_msg_list )
193: THEN
194: FND_MSG_PUB.initialize;
195: END IF;
196:

Line 205: x_return_status := FND_API.G_RET_STS_SUCCESS;

201: END IF;
202:
203:
204: -- Initialize API return status to SUCCESS
205: x_return_status := FND_API.G_RET_STS_SUCCESS;
206:
207: -- Retrieve the Content Items may be compound or simple .
208:
209:

Line 224: IF (p_web_mp_rec.placement_citem_id IS NULL OR p_web_mp_rec.placement_citem_id = FND_API.g_miss_num) THEN

220: -- Call Table Handlers (AMS_WEB_PLCE_CITEM_ASSOC )
221: -- Invoke table handler(AMS_WEB_PLCE_CITEM_ASSOC_PKG.INSERT_ROW)
222:
223: l_simple := 'N';
224: IF (p_web_mp_rec.placement_citem_id IS NULL OR p_web_mp_rec.placement_citem_id = FND_API.g_miss_num) THEN
225:
226: LOOP
227:
228: l_dummy := NULL;

Line 260: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

256: p_msg_count => x_msg_data,
257: p_msg_data => x_msg_data);
258:
259:
260: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263: i := i+1;
264: l_placement_citem_id_tbl.EXTEND;

Line 261: RAISE FND_API.G_EXC_ERROR;

257: p_msg_data => x_msg_data);
258:
259:
260: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263: i := i+1;
264: l_placement_citem_id_tbl.EXTEND;
265: l_placement_citem_id_tbl(i) := l_placement_citem_id;

Line 273: IF (p_web_mp_rec.placement_citem_id IS NULL OR p_web_mp_rec.placement_citem_id = FND_API.g_miss_num) THEN

269: -- May be a Simple Item
270:
271: IF ( i = 0 AND l_simple = 'Y' ) THEN
272:
273: IF (p_web_mp_rec.placement_citem_id IS NULL OR p_web_mp_rec.placement_citem_id = FND_API.g_miss_num) THEN
274:
275: LOOP
276:
277: l_dummy := NULL;

Line 307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

303: p_msg_count => x_msg_data,
304: p_msg_data => x_msg_data);
305:
306:
307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: RAISE FND_API.G_EXC_ERROR;
309: END IF;
310: i := i+1;
311: l_placement_citem_id_tbl.EXTEND;

Line 308: RAISE FND_API.G_EXC_ERROR;

304: p_msg_data => x_msg_data);
305:
306:
307: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
308: RAISE FND_API.G_EXC_ERROR;
309: END IF;
310: i := i+1;
311: l_placement_citem_id_tbl.EXTEND;
312: l_placement_citem_id_tbl(i) := l_placement_citem_id;

Line 343: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

339: x_msg_count => x_msg_count ,
340: x_msg_data => x_msg_data );
341:
342:
343: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347:

Line 344: RAISE FND_API.G_EXC_ERROR;

340: x_msg_data => x_msg_data );
341:
342:
343: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347:
348:

Line 350: IF FND_API.to_Boolean( p_commit )

346:
347:
348:
349: -- Standard check for p_commit
350: IF FND_API.to_Boolean( p_commit )
351: THEN
352: COMMIT WORK;
353: END IF;
354:

Line 383: WHEN FND_API.G_EXC_ERROR THEN

379: -- End of API body
380:
381: EXCEPTION
382:
383: WHEN FND_API.G_EXC_ERROR THEN
384: ROLLBACK TO webmarketing_plce_citems_pvt;
385: x_return_status := FND_API.G_RET_STS_ERROR;
386: -- Standard call to get message count and if count=1, get the message
387: FND_MSG_PUB.Count_And_Get (

Line 385: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 388: p_encoded => FND_API.G_FALSE,

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

Line 393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 398: p_encoded => FND_API.G_FALSE,

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

Line 405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 412: p_encoded => FND_API.G_FALSE,

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

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

418:
419:
420: PROCEDURE VALIDATE_WEB_PLCE_ASSOC(
421: p_api_version_number IN NUMBER,
422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
424: p_web_mp_rec IN web_mp_track_rec_type,
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,

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

419:
420: PROCEDURE VALIDATE_WEB_PLCE_ASSOC(
421: p_api_version_number IN NUMBER,
422: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
423: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
424: p_web_mp_rec IN web_mp_track_rec_type,
425: x_return_status OUT NOCOPY VARCHAR2,
426: x_msg_count OUT NOCOPY NUMBER,
427: x_msg_data OUT NOCOPY VARCHAR2,

Line 478: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

474: -- Standard Start of API savepoint
475: SAVEPOINT VALIDATE_WEB_PLCE_ASSOC_PVT;
476:
477: -- Standard call to check for call compatibility.
478: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
479: p_api_version_number,
480: l_api_name,
481: G_PKG_NAME)
482: THEN

Line 483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479: p_api_version_number,
480: l_api_name,
481: G_PKG_NAME)
482: THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: -- Initialize message list if p_init_msg_list is set to TRUE.
487: IF FND_API.to_Boolean( p_init_msg_list )

Line 487: IF FND_API.to_Boolean( p_init_msg_list )

483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: -- Initialize message list if p_init_msg_list is set to TRUE.
487: IF FND_API.to_Boolean( p_init_msg_list )
488: THEN
489: FND_MSG_PUB.initialize;
490: END IF;
491:

Line 519: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

515: OPEN c_pctype_id_exists(l_web_mp_rec.object_used_by_id);
516: FETCH c_pctype_id_exists INTO l_object_used_by_id;
517: CLOSE c_pctype_id_exists;
518:
519: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
520: RAISE FND_API.G_EXC_ERROR;
521: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: END IF;

Line 520: RAISE FND_API.G_EXC_ERROR;

516: FETCH c_pctype_id_exists INTO l_object_used_by_id;
517: CLOSE c_pctype_id_exists;
518:
519: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
520: RAISE FND_API.G_EXC_ERROR;
521: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: END IF;
524: END IF;

Line 521: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

517: CLOSE c_pctype_id_exists;
518:
519: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
520: RAISE FND_API.G_EXC_ERROR;
521: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: END IF;
524: END IF;
525:

Line 522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

518:
519: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
520: RAISE FND_API.G_EXC_ERROR;
521: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
523: END IF;
524: END IF;
525:
526: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 541: x_return_status := FND_API.G_RET_STS_SUCCESS;

537: END IF;
538:
539:
540: -- Initialize API return status to SUCCESS
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543:
544: -- Debug Message
545: IF (AMS_DEBUG_HIGH_ON) THEN

Line 558: x_return_status := FND_API.g_ret_sts_error;

554:
555: EXCEPTION
556:
557: WHEN AMS_Utility_PVT.resource_locked THEN
558: x_return_status := FND_API.g_ret_sts_error;
559: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
560: WHEN FND_API.G_EXC_ERROR THEN
561: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
562: x_return_status := FND_API.G_RET_STS_ERROR;

Line 560: WHEN FND_API.G_EXC_ERROR THEN

556:
557: WHEN AMS_Utility_PVT.resource_locked THEN
558: x_return_status := FND_API.g_ret_sts_error;
559: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
560: WHEN FND_API.G_EXC_ERROR THEN
561: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: -- Standard call to get message count and if count=1, get the message
564: FND_MSG_PUB.Count_And_Get (

Line 562: x_return_status := FND_API.G_RET_STS_ERROR;

558: x_return_status := FND_API.g_ret_sts_error;
559: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
560: WHEN FND_API.G_EXC_ERROR THEN
561: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: -- Standard call to get message count and if count=1, get the message
564: FND_MSG_PUB.Count_And_Get (
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,

Line 565: p_encoded => FND_API.G_FALSE,

561: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
562: x_return_status := FND_API.G_RET_STS_ERROR;
563: -- Standard call to get message count and if count=1, get the message
564: FND_MSG_PUB.Count_And_Get (
565: p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,
567: p_data => x_msg_data
568: );
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

565: p_encoded => FND_API.G_FALSE,
566: p_count => x_msg_count,
567: p_data => x_msg_data
568: );
569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
570: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
571: IF (AMS_DEBUG_HIGH_ON) THEN
572: AMS_UTILITY_PVT.debug_message('In Validate - unexpected err: validation_mode= ' || p_validation_mode);
573: END IF;

Line 574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

570: ROLLBACK TO VALIDATE_WEB_PLCE_ASSOC_PVT;
571: IF (AMS_DEBUG_HIGH_ON) THEN
572: AMS_UTILITY_PVT.debug_message('In Validate - unexpected err: validation_mode= ' || p_validation_mode);
573: END IF;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: -- Standard call to get message count and if count=1, get the message
576: FND_MSG_PUB.Count_And_Get (
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,

Line 577: p_encoded => FND_API.G_FALSE,

573: END IF;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: -- Standard call to get message count and if count=1, get the message
576: FND_MSG_PUB.Count_And_Get (
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data
580: );
581: WHEN OTHERS THEN

Line 587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

583: IF (AMS_DEBUG_HIGH_ON) THEN
584:
585: AMS_UTILITY_PVT.debug_message('In Validate - others err: validation_mode= ' || p_validation_mode);
586: END IF;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
589: THEN
590: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
591: END IF;

Line 595: p_encoded => FND_API.G_FALSE,

591: END IF;
592:
593: -- Standard call to get message count and if count=1, get the message
594: FND_MSG_PUB.Count_And_Get (
595: p_encoded => FND_API.G_FALSE,
596: p_count => x_msg_count,
597: p_data => x_msg_data
598: );
599:

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

664: -- ========================================================================
665:
666: PROCEDURE CREATE_WEB_PLCE_ASSOC (
667: p_api_version_number IN NUMBER := 1.0,
668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
669: p_commit IN VARCHAR2 := FND_API.G_FALSE,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
671: p_web_mp_rec IN web_mp_track_rec_type := g_miss_web_mp_track_rec,
672: x_placement_mp_id OUT NOCOPY NUMBER,

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

665:
666: PROCEDURE CREATE_WEB_PLCE_ASSOC (
667: p_api_version_number IN NUMBER := 1.0,
668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
669: p_commit IN VARCHAR2 := FND_API.G_FALSE,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
671: p_web_mp_rec IN web_mp_track_rec_type := g_miss_web_mp_track_rec,
672: x_placement_mp_id OUT NOCOPY NUMBER,
673: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,

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

666: PROCEDURE CREATE_WEB_PLCE_ASSOC (
667: p_api_version_number IN NUMBER := 1.0,
668: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
669: p_commit IN VARCHAR2 := FND_API.G_FALSE,
670: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
671: p_web_mp_rec IN web_mp_track_rec_type := g_miss_web_mp_track_rec,
672: x_placement_mp_id OUT NOCOPY NUMBER,
673: x_placement_citem_id_tbl OUT NOCOPY JTF_NUMBER_TABLE,
674: x_msg_count OUT NOCOPY NUMBER,

Line 722: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

718: -- Standard Start of API savepoint
719: SAVEPOINT CREATE_WEB_PLCE_ASSOC;
720:
721: -- Standard call to check for call compatibility.
722: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
723: p_api_version_number,
724: l_api_name,
725: G_PKG_NAME)
726: THEN

Line 727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

723: p_api_version_number,
724: l_api_name,
725: G_PKG_NAME)
726: THEN
727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: END IF;
729:
730: -- Initialize message list if p_init_msg_list is set to TRUE.
731: IF FND_API.to_Boolean(p_init_msg_list)

Line 731: IF FND_API.to_Boolean(p_init_msg_list)

727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
728: END IF;
729:
730: -- Initialize message list if p_init_msg_list is set to TRUE.
731: IF FND_API.to_Boolean(p_init_msg_list)
732: THEN
733: FND_MSG_PUB.initialize;
734: END IF;
735:

Line 742: x_return_status := FND_API.G_RET_STS_SUCCESS;

738: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
739: END IF;
740:
741: -- Initialize API return status to SUCCESS
742: x_return_status := FND_API.G_RET_STS_SUCCESS;
743:
744: -- Validate the In Rec
745:
746: -- =========================================================================

Line 753: RAISE FND_API.G_EXC_ERROR;

749:
750: IF FND_GLOBAL.User_Id IS NULL
751: THEN
752: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755:
756:
757: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755:
756:
757: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
758:
759: THEN
760:
761: -- Debug message

Line 782: IF (p_web_mp_rec.PLACEMENT_MP_ID IS NULL OR p_web_mp_rec.PLACEMENT_MP_ID = FND_API.g_miss_num) THEN

778:
779: -- Local variable initialization
780:
781:
782: IF (p_web_mp_rec.PLACEMENT_MP_ID IS NULL OR p_web_mp_rec.PLACEMENT_MP_ID = FND_API.g_miss_num) THEN
783: LOOP
784: l_dummy := NULL;
785: OPEN c_mp_id;
786: FETCH c_mp_id INTO l_PLACEMENT_MP_ID;

Line 857: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

853: x_last_updated_by => fnd_global.user_id,
854: x_last_update_login => fnd_global.conc_login_id );
855:
856:
857: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861: -- Only for WebAdv / WebOffer

Line 858: RAISE FND_API.G_EXC_ERROR;

854: x_last_update_login => fnd_global.conc_login_id );
855:
856:
857: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:
861: -- Only for WebAdv / WebOffer
862: -- Verify the media-id for the Dynamic recommendations

Line 885: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

881:
882:
883: END IF;
884:
885: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888:
889: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 886: RAISE FND_API.G_EXC_ERROR;

882:
883: END IF;
884:
885: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888:
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890:

Line 889: x_return_status := FND_API.G_RET_STS_SUCCESS;

885: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888:
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890:
891: -- Standard check for p_commit ( This shud be romved after testing - Actual Commit is done by the calling program )
892: IF FND_API.to_Boolean( p_commit) THEN
893: COMMIT WORK;

Line 892: IF FND_API.to_Boolean( p_commit) THEN

888:
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890:
891: -- Standard check for p_commit ( This shud be romved after testing - Actual Commit is done by the calling program )
892: IF FND_API.to_Boolean( p_commit) THEN
893: COMMIT WORK;
894: END IF;
895:
896: -- Debug Message

Line 920: x_return_status := FND_API.g_ret_sts_error;

916:
917: EXCEPTION
918:
919: WHEN AMS_Utility_PVT.resource_locked THEN
920: x_return_status := FND_API.g_ret_sts_error;
921: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
922:
923:
924: WHEN FND_API.G_EXC_ERROR THEN

Line 924: WHEN FND_API.G_EXC_ERROR THEN

920: x_return_status := FND_API.g_ret_sts_error;
921: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
922:
923:
924: WHEN FND_API.G_EXC_ERROR THEN
925: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: -- Standard call to get message count and if count=1, get the message
928:

Line 926: x_return_status := FND_API.G_RET_STS_ERROR;

922:
923:
924: WHEN FND_API.G_EXC_ERROR THEN
925: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
926: x_return_status := FND_API.G_RET_STS_ERROR;
927: -- Standard call to get message count and if count=1, get the message
928:
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,

Line 930: p_encoded => FND_API.G_FALSE,

926: x_return_status := FND_API.G_RET_STS_ERROR;
927: -- Standard call to get message count and if count=1, get the message
928:
929: FND_MSG_PUB.Count_And_Get (
930: p_encoded => FND_API.G_FALSE,
931: p_count => x_msg_count,
932: p_data => x_msg_data
933: );
934:

Line 935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

931: p_count => x_msg_count,
932: p_data => x_msg_data
933: );
934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938:
939: -- Standard call to get message count and if count=1, get the message

Line 937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

933: );
934:
935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
936: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938:
939: -- Standard call to get message count and if count=1, get the message
940: FND_MSG_PUB.Count_And_Get (
941: p_encoded => FND_API.G_FALSE,

Line 941: p_encoded => FND_API.G_FALSE,

937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
938:
939: -- Standard call to get message count and if count=1, get the message
940: FND_MSG_PUB.Count_And_Get (
941: p_encoded => FND_API.G_FALSE,
942: p_count => x_msg_count,
943: p_data => x_msg_data
944: );
945:

Line 948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

944: );
945:
946: WHEN OTHERS THEN
947: ROLLBACK TO CREATE_WEB_PLCE_ASSOC;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
949: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
950: THEN
951: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
952: END IF;

Line 956: p_encoded => FND_API.G_FALSE,

952: END IF;
953: -- Standard call to get message count and if count=1, get the message
954:
955: FND_MSG_PUB.Count_And_Get (
956: p_encoded => FND_API.G_FALSE,
957: p_count => x_msg_count,
958: p_data => x_msg_data
959: );
960:

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

975: -- ========================================================================
976:
977: PROCEDURE WEBMARKETING_PLCE_CONTENT_TYPE (
978: p_api_version_number IN NUMBER := 1.0,
979: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
980: p_commit IN VARCHAR2 := FND_API.G_FALSE,
981: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
982: p_placement_mp_id IN NUMBER,
983: p_content_item_id IN NUMBER,

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

976:
977: PROCEDURE WEBMARKETING_PLCE_CONTENT_TYPE (
978: p_api_version_number IN NUMBER := 1.0,
979: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
980: p_commit IN VARCHAR2 := FND_API.G_FALSE,
981: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
982: p_placement_mp_id IN NUMBER,
983: p_content_item_id IN NUMBER,
984: x_content_type OUT NOCOPY VARCHAR2,

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

977: PROCEDURE WEBMARKETING_PLCE_CONTENT_TYPE (
978: p_api_version_number IN NUMBER := 1.0,
979: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
980: p_commit IN VARCHAR2 := FND_API.G_FALSE,
981: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
982: p_placement_mp_id IN NUMBER,
983: p_content_item_id IN NUMBER,
984: x_content_type OUT NOCOPY VARCHAR2,
985: x_msg_count OUT NOCOPY NUMBER,

Line 1017: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1013: -- Standard Start of API savepoint
1014: SAVEPOINT webmarketing_plce_content_type ;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1018: p_api_version_number,
1019: l_api_name,
1020: G_PKG_NAME)
1021: THEN

Line 1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1018: p_api_version_number,
1019: l_api_name,
1020: G_PKG_NAME)
1021: THEN
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024:
1025: -- Initialize message list if p_init_msg_list is set to TRUE.
1026: IF FND_API.to_Boolean( p_init_msg_list )

Line 1026: IF FND_API.to_Boolean( p_init_msg_list )

1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024:
1025: -- Initialize message list if p_init_msg_list is set to TRUE.
1026: IF FND_API.to_Boolean( p_init_msg_list )
1027: THEN
1028: FND_MSG_PUB.initialize;
1029: END IF;
1030:

Line 1039: x_return_status := FND_API.G_RET_STS_SUCCESS;

1035: END IF;
1036:
1037:
1038: -- Initialize API return status to SUCCESS
1039: x_return_status := FND_API.G_RET_STS_SUCCESS;
1040:
1041: OPEN c_mp_id_exists(p_placement_mp_id);
1042: FETCH c_mp_id_exists INTO l_placement_mp_id;
1043: CLOSE c_mp_id_exists;

Line 1060: WHEN FND_API.G_EXC_ERROR THEN

1056: -- x_content_type := l_content_type;
1057:
1058: EXCEPTION
1059:
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: ROLLBACK TO webmarketing_plce_content_type;
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: -- Standard call to get message count and if count=1, get the message
1064: FND_MSG_PUB.Count_And_Get (

Line 1062: x_return_status := FND_API.G_RET_STS_ERROR;

1058: EXCEPTION
1059:
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: ROLLBACK TO webmarketing_plce_content_type;
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: -- Standard call to get message count and if count=1, get the message
1064: FND_MSG_PUB.Count_And_Get (
1065: p_encoded => FND_API.G_FALSE,
1066: p_count => x_msg_count,

Line 1065: p_encoded => FND_API.G_FALSE,

1061: ROLLBACK TO webmarketing_plce_content_type;
1062: x_return_status := FND_API.G_RET_STS_ERROR;
1063: -- Standard call to get message count and if count=1, get the message
1064: FND_MSG_PUB.Count_And_Get (
1065: p_encoded => FND_API.G_FALSE,
1066: p_count => x_msg_count,
1067: p_data => x_msg_data
1068: );
1069:

Line 1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1066: p_count => x_msg_count,
1067: p_data => x_msg_data
1068: );
1069:
1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1071: ROLLBACK TO webmarketing_plce_content_type;
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073: -- Standard call to get message count and if count=1, get the message
1074: FND_MSG_PUB.Count_And_Get (

Line 1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1068: );
1069:
1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1071: ROLLBACK TO webmarketing_plce_content_type;
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073: -- Standard call to get message count and if count=1, get the message
1074: FND_MSG_PUB.Count_And_Get (
1075: p_encoded => FND_API.G_FALSE,
1076: p_count => x_msg_count,

Line 1075: p_encoded => FND_API.G_FALSE,

1071: ROLLBACK TO webmarketing_plce_content_type;
1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073: -- Standard call to get message count and if count=1, get the message
1074: FND_MSG_PUB.Count_And_Get (
1075: p_encoded => FND_API.G_FALSE,
1076: p_count => x_msg_count,
1077: p_data => x_msg_data
1078: );
1079:

Line 1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1078: );
1079:
1080: WHEN OTHERS THEN
1081: ROLLBACK TO webmarketing_plce_content_type;
1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1084: THEN
1085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1086: END IF;

Line 1089: p_encoded => FND_API.G_FALSE,

1085: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1086: END IF;
1087: -- Standard call to get message count and if count=1, get the message
1088: FND_MSG_PUB.Count_And_Get (
1089: p_encoded => FND_API.G_FALSE,
1090: p_count => x_msg_count,
1091: p_data => x_msg_data
1092: );
1093:

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

1105:
1106:
1107: PROCEDURE WEBMARKETING_CONTENT_STATUS (
1108: p_api_version_number IN NUMBER := 1.0,
1109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1111: p_campaign_activity_id IN NUMBER,
1112: x_msg_count OUT NOCOPY NUMBER,
1113: x_msg_data OUT NOCOPY VARCHAR2,

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

1106:
1107: PROCEDURE WEBMARKETING_CONTENT_STATUS (
1108: p_api_version_number IN NUMBER := 1.0,
1109: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1111: p_campaign_activity_id IN NUMBER,
1112: x_msg_count OUT NOCOPY NUMBER,
1113: x_msg_data OUT NOCOPY VARCHAR2,
1114: x_return_status OUT NOCOPY VARCHAR2

Line 1152: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1148: -- Standard Start of API savepoint
1149: SAVEPOINT WEBMARKETING_CONTENT_STATUS_S ;
1150:
1151: -- Standard call to check for call compatibility.
1152: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1153: p_api_version_number,
1154: l_api_name,
1155: G_PKG_NAME)
1156: THEN

Line 1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1153: p_api_version_number,
1154: l_api_name,
1155: G_PKG_NAME)
1156: THEN
1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1158: END IF;
1159:
1160: -- Initialize message list if p_init_msg_list is set to TRUE.
1161: IF FND_API.to_Boolean( p_init_msg_list )

Line 1161: IF FND_API.to_Boolean( p_init_msg_list )

1157: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1158: END IF;
1159:
1160: -- Initialize message list if p_init_msg_list is set to TRUE.
1161: IF FND_API.to_Boolean( p_init_msg_list )
1162: THEN
1163: FND_MSG_PUB.initialize;
1164: END IF;
1165:

Line 1174: x_return_status := FND_API.G_RET_STS_SUCCESS;

1170: END IF;
1171:
1172:
1173: -- Initialize API return status to SUCCESS
1174: x_return_status := FND_API.G_RET_STS_SUCCESS;
1175:
1176: IF (p_campaign_activity_id IS NOT NULL ) THEN
1177:
1178: OPEN c_media_id_exists(p_campaign_activity_id);

Line 1198: x_return_status := FND_API.G_RET_STS_SUCCESS;

1194: FETCH c_content_id_exists INTO l_content_item_rec;
1195: CLOSE c_content_id_exists;
1196:
1197: IF (l_content_item_rec.content_item_id IS NULL) then
1198: x_return_status := FND_API.G_RET_STS_SUCCESS;
1199: ELSE
1200: x_return_status := FND_API. G_RET_STS_ERROR;
1201: FND_MESSAGE.set_name('AMS', 'AMS_WEB_PLCE_CITEM_NOT_APPR');
1202: FND_MSG_PUB.add;

Line 1200: x_return_status := FND_API. G_RET_STS_ERROR;

1196:
1197: IF (l_content_item_rec.content_item_id IS NULL) then
1198: x_return_status := FND_API.G_RET_STS_SUCCESS;
1199: ELSE
1200: x_return_status := FND_API. G_RET_STS_ERROR;
1201: FND_MESSAGE.set_name('AMS', 'AMS_WEB_PLCE_CITEM_NOT_APPR');
1202: FND_MSG_PUB.add;
1203: FND_MSG_PUB.Count_AND_Get
1204: ( p_count => x_msg_count,

Line 1206: p_encoded => FND_API.G_FALSE

1202: FND_MSG_PUB.add;
1203: FND_MSG_PUB.Count_AND_Get
1204: ( p_count => x_msg_count,
1205: p_data => x_msg_data,
1206: p_encoded => FND_API.G_FALSE
1207: );
1208: END IF;
1209: -- Invalid association
1210: ELSE

Line 1211: x_return_status := FND_API. G_RET_STS_ERROR;

1207: );
1208: END IF;
1209: -- Invalid association
1210: ELSE
1211: x_return_status := FND_API. G_RET_STS_ERROR;
1212: FND_MESSAGE.set_name('AMS', 'AMS_WEB_PLCE_ACTIVITY_INVALID');
1213: FND_MSG_PUB.add;
1214: FND_MSG_PUB.Count_AND_Get
1215: ( p_count => x_msg_count,

Line 1217: p_encoded => FND_API.G_FALSE

1213: FND_MSG_PUB.add;
1214: FND_MSG_PUB.Count_AND_Get
1215: ( p_count => x_msg_count,
1216: p_data => x_msg_data,
1217: p_encoded => FND_API.G_FALSE
1218: );
1219: END IF;
1220:
1221: ELSE

Line 1224: x_return_status := FND_API. G_RET_STS_SUCCESS;

1220:
1221: ELSE
1222:
1223: -- not required to validate
1224: x_return_status := FND_API. G_RET_STS_SUCCESS;
1225:
1226: END IF;
1227:
1228: ELSE

Line 1231: x_return_status := FND_API. G_RET_STS_ERROR;

1227:
1228: ELSE
1229:
1230: -- Invalid activity id passed
1231: x_return_status := FND_API. G_RET_STS_ERROR;
1232: FND_MESSAGE.set_name('AMS', 'AMS_WEB_PLCE_NO_ACTIVITY');
1233: FND_MSG_PUB.add;
1234: FND_MSG_PUB.Count_AND_Get
1235: ( p_count => x_msg_count,

Line 1237: p_encoded => FND_API.G_FALSE

1233: FND_MSG_PUB.add;
1234: FND_MSG_PUB.Count_AND_Get
1235: ( p_count => x_msg_count,
1236: p_data => x_msg_data,
1237: p_encoded => FND_API.G_FALSE
1238: );
1239:
1240: END IF;
1241:

Line 1245: WHEN FND_API.G_EXC_ERROR THEN

1241:
1242:
1243: EXCEPTION
1244:
1245: WHEN FND_API.G_EXC_ERROR THEN
1246: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (

Line 1247: x_return_status := FND_API.G_RET_STS_ERROR;

1243: EXCEPTION
1244:
1245: WHEN FND_API.G_EXC_ERROR THEN
1246: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (
1250: p_encoded => FND_API.G_FALSE,
1251: p_count => x_msg_count,

Line 1250: p_encoded => FND_API.G_FALSE,

1246: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: -- Standard call to get message count and if count=1, get the message
1249: FND_MSG_PUB.Count_And_Get (
1250: p_encoded => FND_API.G_FALSE,
1251: p_count => x_msg_count,
1252: p_data => x_msg_data
1253: );
1254:

Line 1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1251: p_count => x_msg_count,
1252: p_data => x_msg_data
1253: );
1254:
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: -- Standard call to get message count and if count=1, get the message
1259: FND_MSG_PUB.Count_And_Get (

Line 1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1253: );
1254:
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: -- Standard call to get message count and if count=1, get the message
1259: FND_MSG_PUB.Count_And_Get (
1260: p_encoded => FND_API.G_FALSE,
1261: p_count => x_msg_count,

Line 1260: p_encoded => FND_API.G_FALSE,

1256: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: -- Standard call to get message count and if count=1, get the message
1259: FND_MSG_PUB.Count_And_Get (
1260: p_encoded => FND_API.G_FALSE,
1261: p_count => x_msg_count,
1262: p_data => x_msg_data
1263: );
1264:

Line 1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1263: );
1264:
1265: WHEN OTHERS THEN
1266: ROLLBACK TO WEBMARKETING_CONTENT_STATUS_S;
1267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1268: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1269: THEN
1270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1271: END IF;

Line 1274: p_encoded => FND_API.G_FALSE,

1270: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,L_API_NAME);
1271: END IF;
1272: -- Standard call to get message count and if count=1, get the message
1273: FND_MSG_PUB.Count_And_Get (
1274: p_encoded => FND_API.G_FALSE,
1275: p_count => x_msg_count,
1276: p_data => x_msg_data
1277: );
1278: