APPS.AMS_TRACKING_PVT dependencies on FND_API

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

42:
43:
44: PROCEDURE Log_interaction(
45: p_api_version_number IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49:
50: x_return_status OUT NOCOPY VARCHAR2,

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

43:
44: PROCEDURE Log_interaction(
45: p_api_version_number IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49:
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,

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

44: PROCEDURE Log_interaction(
45: p_api_version_number IN NUMBER,
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_commit IN VARCHAR2 := FND_API.G_FALSE,
48: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
49:
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2,

Line 95: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 104: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 113: l_return_status := FND_API.G_RET_STS_SUCCESS;

109: -- Debug Message
110: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
111:
112: -- Initialize API return status to SUCCESS
113: l_return_status := FND_API.G_RET_STS_SUCCESS;
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115:
116: -- JTF_IH_PUB.open_mediaitem
117: l_media_rec.start_date_time := SYSDATE;

Line 114: x_return_status := FND_API.G_RET_STS_SUCCESS;

110: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
111:
112: -- Initialize API return status to SUCCESS
113: l_return_status := FND_API.G_RET_STS_SUCCESS;
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115:
116: -- JTF_IH_PUB.open_mediaitem
117: l_media_rec.start_date_time := SYSDATE;
118:

Line 159: p_init_msg_list => FND_API.g_false,

155: -- End Minisite Population
156:
157: JTF_IH_PUB.open_mediaitem(
158: p_api_version => 1.0,
159: p_init_msg_list => FND_API.g_false,
160: p_commit => FND_API.g_false,
161: p_resp_appl_id => FND_GLOBAL.resp_appl_id,
162: p_resp_id => FND_GLOBAL.resp_id,
163: p_user_id => FND_GLOBAL.user_id,

Line 160: p_commit => FND_API.g_false,

156:
157: JTF_IH_PUB.open_mediaitem(
158: p_api_version => 1.0,
159: p_init_msg_list => FND_API.g_false,
160: p_commit => FND_API.g_false,
161: p_resp_appl_id => FND_GLOBAL.resp_appl_id,
162: p_resp_id => FND_GLOBAL.resp_id,
163: p_user_id => FND_GLOBAL.user_id,
164: p_login_id => FND_GLOBAL.conc_login_id,

Line 172: IF l_return_status <> FND_API.g_ret_sts_success THEN

168: p_media_rec => l_media_rec,
169: x_media_id => l_media_id
170: );
171:
172: IF l_return_status <> FND_API.g_ret_sts_success THEN
173: RAISE FND_API.g_exc_error;
174: END IF;
175:
176: -- JTF_IH_PUB.close_mediaitem

Line 173: RAISE FND_API.g_exc_error;

169: x_media_id => l_media_id
170: );
171:
172: IF l_return_status <> FND_API.g_ret_sts_success THEN
173: RAISE FND_API.g_exc_error;
174: END IF;
175:
176: -- JTF_IH_PUB.close_mediaitem
177: l_media_rec.media_id := l_media_id;

Line 181: p_init_msg_list => FND_API.g_false,

177: l_media_rec.media_id := l_media_id;
178:
179: JTF_IH_PUB.close_mediaitem(
180: p_api_version => 1.0,
181: p_init_msg_list => FND_API.g_false,
182: p_commit => FND_API.g_false,
183: p_resp_appl_id => FND_GLOBAL.resp_appl_id,
184: p_resp_id => FND_GLOBAL.resp_id,
185: p_user_id => FND_GLOBAL.user_id,

Line 182: p_commit => FND_API.g_false,

178:
179: JTF_IH_PUB.close_mediaitem(
180: p_api_version => 1.0,
181: p_init_msg_list => FND_API.g_false,
182: p_commit => FND_API.g_false,
183: p_resp_appl_id => FND_GLOBAL.resp_appl_id,
184: p_resp_id => FND_GLOBAL.resp_id,
185: p_user_id => FND_GLOBAL.user_id,
186: p_login_id => FND_GLOBAL.conc_login_id,

Line 193: IF l_return_status <> FND_API.g_ret_sts_success THEN

189: x_msg_data => l_msg_data,
190: p_media_rec => l_media_rec
191: );
192:
193: IF l_return_status <> FND_API.g_ret_sts_success THEN
194: RAISE FND_API.g_exc_error;
195: END IF;
196:
197: /* Bug fix:5594167 */

Line 194: RAISE FND_API.g_exc_error;

190: p_media_rec => l_media_rec
191: );
192:
193: IF l_return_status <> FND_API.g_ret_sts_success THEN
194: RAISE FND_API.g_exc_error;
195: END IF;
196:
197: /* Bug fix:5594167 */
198:

Line 295: p_init_msg_list => FND_API.g_false,

291: l_activity_tbl(1) := l_activity_rec;
292:
293: JTF_IH_PUB. create_interaction(
294: p_api_version => 1.0,
295: p_init_msg_list => FND_API.g_false,
296: p_commit => FND_API.g_false,
297: p_resp_appl_id => FND_GLOBAL.resp_appl_id,
298: p_resp_id => FND_GLOBAL.resp_id,
299: p_user_id => FND_GLOBAL.user_id,

Line 296: p_commit => FND_API.g_false,

292:
293: JTF_IH_PUB. create_interaction(
294: p_api_version => 1.0,
295: p_init_msg_list => FND_API.g_false,
296: p_commit => FND_API.g_false,
297: p_resp_appl_id => FND_GLOBAL.resp_appl_id,
298: p_resp_id => FND_GLOBAL.resp_id,
299: p_user_id => FND_GLOBAL.user_id,
300: p_login_id => FND_GLOBAL.conc_login_id,

Line 309: IF l_return_status <> FND_API.g_ret_sts_success THEN

305: p_activities => l_activity_tbl
306: );
307:
308:
309: IF l_return_status <> FND_API.g_ret_sts_success THEN
310: RAISE FND_API.g_exc_error;
311: END IF;
312:
313: -- Standard check for p_commit

Line 310: RAISE FND_API.g_exc_error;

306: );
307:
308:
309: IF l_return_status <> FND_API.g_ret_sts_success THEN
310: RAISE FND_API.g_exc_error;
311: END IF;
312:
313: -- Standard check for p_commit
314: IF FND_API.to_Boolean( p_commit )

Line 314: IF FND_API.to_Boolean( p_commit )

310: RAISE FND_API.g_exc_error;
311: END IF;
312:
313: -- Standard check for p_commit
314: IF FND_API.to_Boolean( p_commit )
315: THEN
316: COMMIT WORK;
317: END IF;
318:

Line 330: WHEN FND_API.G_EXC_ERROR THEN

326: );
327:
328: EXCEPTION
329:
330: WHEN FND_API.G_EXC_ERROR THEN
331: ROLLBACK TO Log_interaction;
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: -- Standard call to get message count and if count=1, get the message
334: FND_MSG_PUB.Count_And_Get (

Line 332: x_return_status := FND_API.G_RET_STS_ERROR;

328: EXCEPTION
329:
330: WHEN FND_API.G_EXC_ERROR THEN
331: ROLLBACK TO Log_interaction;
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: -- Standard call to get message count and if count=1, get the message
334: FND_MSG_PUB.Count_And_Get (
335: p_encoded => FND_API.G_FALSE,
336: p_count => x_msg_count,

Line 335: p_encoded => FND_API.G_FALSE,

331: ROLLBACK TO Log_interaction;
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: -- Standard call to get message count and if count=1, get the message
334: FND_MSG_PUB.Count_And_Get (
335: p_encoded => FND_API.G_FALSE,
336: p_count => x_msg_count,
337: p_data => x_msg_data
338: );
339:

Line 340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

336: p_count => x_msg_count,
337: p_data => x_msg_data
338: );
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: ROLLBACK TO Log_interaction;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: -- Standard call to get message count and if count=1, get the message
344: FND_MSG_PUB.Count_And_Get (

Line 342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

338: );
339:
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: ROLLBACK TO Log_interaction;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: -- Standard call to get message count and if count=1, get the message
344: FND_MSG_PUB.Count_And_Get (
345: p_encoded => FND_API.G_FALSE,
346: p_count => x_msg_count,

Line 345: p_encoded => FND_API.G_FALSE,

341: ROLLBACK TO Log_interaction;
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: -- Standard call to get message count and if count=1, get the message
344: FND_MSG_PUB.Count_And_Get (
345: p_encoded => FND_API.G_FALSE,
346: p_count => x_msg_count,
347: p_data => x_msg_data
348: );
349:

Line 352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

348: );
349:
350: WHEN OTHERS THEN
351: ROLLBACK TO Log_interaction;
352: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
353: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
354: THEN
355: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
356: END IF;

Line 359: p_encoded => FND_API.G_FALSE,

355: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
356: END IF;
357: -- Standard call to get message count and if count=1, get the message
358: FND_MSG_PUB.Count_And_Get (
359: p_encoded => FND_API.G_FALSE,
360: p_count => x_msg_count,
361: p_data => x_msg_data
362: );
363: End Log_interaction;

Line 389: p_init_msg_list := FND_API.G_FALSE;

385: l_redirect_url VARCHAR2(2000) := null;
386: BEGIN
387: -- Standard Start of API savepoint
388: SAVEPOINT Log_redirect;
389: p_init_msg_list := FND_API.G_FALSE;
390: p_commit := FND_API.G_FALSE;
391: -- Initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list )
393: THEN

Line 390: p_commit := FND_API.G_FALSE;

386: BEGIN
387: -- Standard Start of API savepoint
388: SAVEPOINT Log_redirect;
389: p_init_msg_list := FND_API.G_FALSE;
390: p_commit := FND_API.G_FALSE;
391: -- Initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list )
393: THEN
394: FND_MSG_PUB.initialize;

Line 392: IF FND_API.to_Boolean( p_init_msg_list )

388: SAVEPOINT Log_redirect;
389: p_init_msg_list := FND_API.G_FALSE;
390: p_commit := FND_API.G_FALSE;
391: -- Initialize message list if p_init_msg_list is set to TRUE.
392: IF FND_API.to_Boolean( p_init_msg_list )
393: THEN
394: FND_MSG_PUB.initialize;
395: END IF;
396:

Line 399: x_return_status := FND_API.G_RET_STS_SUCCESS;

395: END IF;
396:
397: -- Debug Message
398: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400: l_profile := FND_PROFILE.VALUE('AMS_LOG_INTERACTION') ;
401:
402: IF (l_profile='Y' or tracking_rec.did <> null) THEN
403:

Line 405: p_init_msg_list => FND_API.G_FALSE,

401:
402: IF (l_profile='Y' or tracking_rec.did <> null) THEN
403:
404: Log_interaction( p_api_version_number => 1.0,
405: p_init_msg_list => FND_API.G_FALSE,
406: p_commit => FND_API.G_TRUE,
407: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
408:
409: x_return_status => x_return_status,

Line 406: p_commit => FND_API.G_TRUE,

402: IF (l_profile='Y' or tracking_rec.did <> null) THEN
403:
404: Log_interaction( p_api_version_number => 1.0,
405: p_init_msg_list => FND_API.G_FALSE,
406: p_commit => FND_API.G_TRUE,
407: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
408:
409: x_return_status => x_return_status,
410: x_msg_count => x_msg_count,

Line 407: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

403:
404: Log_interaction( p_api_version_number => 1.0,
405: p_init_msg_list => FND_API.G_FALSE,
406: p_commit => FND_API.G_TRUE,
407: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
408:
409: x_return_status => x_return_status,
410: x_msg_count => x_msg_count,
411: x_msg_data => x_msg_data,

Line 416: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

412: x_interaction_id => l_interaction_id,
413: p_track_rec => tracking_rec
414: );
415:
416: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419: x_interaction_id := l_interaction_id;
420: get_redirect_url

Line 417: RAISE FND_API.G_EXC_ERROR;

413: p_track_rec => tracking_rec
414: );
415:
416: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419: x_interaction_id := l_interaction_id;
420: get_redirect_url
421: (

Line 447: IF FND_API.to_Boolean( p_commit ) THEN

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

Line 456: WHEN FND_API.G_EXC_ERROR THEN

452: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
453:
454: EXCEPTION
455:
456: WHEN FND_API.G_EXC_ERROR THEN
457: ROLLBACK TO Log_redirect;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (

Line 458: x_return_status := FND_API.G_RET_STS_ERROR;

454: EXCEPTION
455:
456: WHEN FND_API.G_EXC_ERROR THEN
457: ROLLBACK TO Log_redirect;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE,
462: p_count => x_msg_count,

Line 461: p_encoded => FND_API.G_FALSE,

457: ROLLBACK TO Log_redirect;
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: -- Standard call to get message count and if count=1, get the message
460: FND_MSG_PUB.Count_And_Get (
461: p_encoded => FND_API.G_FALSE,
462: p_count => x_msg_count,
463: p_data => x_msg_data
464: );
465:

Line 466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

462: p_count => x_msg_count,
463: p_data => x_msg_data
464: );
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: ROLLBACK TO Log_redirect;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: -- Standard call to get message count and if count=1, get the message
470: FND_MSG_PUB.Count_And_Get (

Line 468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

464: );
465:
466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
467: ROLLBACK TO Log_redirect;
468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: -- Standard call to get message count and if count=1, get the message
470: FND_MSG_PUB.Count_And_Get (
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,

Line 471: p_encoded => FND_API.G_FALSE,

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

Line 478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

474: );
475:
476: WHEN OTHERS THEN
477: ROLLBACK TO Log_redirect;
478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
479: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
480: THEN
481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
482: END IF;

Line 485: p_encoded => FND_API.G_FALSE,

481: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
482: END IF;
483: -- Standard call to get message count and if count=1, get the message
484: FND_MSG_PUB.Count_And_Get (
485: p_encoded => FND_API.G_FALSE,
486: p_count => x_msg_count,
487: p_data => x_msg_data
488: );
489:

Line 545: p_init_msg_list := FND_API.G_FALSE;

541: -- Standard Start of API savepoint
542: SAVEPOINT weblite_log;
543: -- Debug Message
544: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
545: p_init_msg_list := FND_API.G_FALSE;
546: p_commit := FND_API.G_FALSE;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;

Line 546: p_commit := FND_API.G_FALSE;

542: SAVEPOINT weblite_log;
543: -- Debug Message
544: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
545: p_init_msg_list := FND_API.G_FALSE;
546: p_commit := FND_API.G_FALSE;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;

Line 548: IF FND_API.to_Boolean( p_init_msg_list ) THEN

544: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
545: p_init_msg_list := FND_API.G_FALSE;
546: p_commit := FND_API.G_FALSE;
547: -- Initialize message list if p_init_msg_list is set to TRUE.
548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551:
552: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 552: x_return_status := FND_API.G_RET_STS_SUCCESS;

548: IF FND_API.to_Boolean( p_init_msg_list ) THEN
549: FND_MSG_PUB.initialize;
550: END IF;
551:
552: x_return_status := FND_API.G_RET_STS_SUCCESS;
553:
554: l_profile := FND_PROFILE.VALUE('AMS_LOG_INTERACTION') ;
555:
556: --insert_log_mesg('Profile: Log Interaction: '||l_profile);

Line 560: p_init_msg_list => FND_API.G_FALSE,

556: --insert_log_mesg('Profile: Log Interaction: '||l_profile);
557:
558: IF (l_profile = 'Y') THEN
559: Log_interaction( p_api_version_number => 1.0,
560: p_init_msg_list => FND_API.G_FALSE,
561: p_commit => FND_API.G_TRUE,
562: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
563: x_return_status => x_return_status,
564: x_msg_count => x_msg_count,

Line 561: p_commit => FND_API.G_TRUE,

557:
558: IF (l_profile = 'Y') THEN
559: Log_interaction( p_api_version_number => 1.0,
560: p_init_msg_list => FND_API.G_FALSE,
561: p_commit => FND_API.G_TRUE,
562: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
563: x_return_status => x_return_status,
564: x_msg_count => x_msg_count,
565: x_msg_data => x_msg_data,

Line 562: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

558: IF (l_profile = 'Y') THEN
559: Log_interaction( p_api_version_number => 1.0,
560: p_init_msg_list => FND_API.G_FALSE,
561: p_commit => FND_API.G_TRUE,
562: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
563: x_return_status => x_return_status,
564: x_msg_count => x_msg_count,
565: x_msg_data => x_msg_data,
566: x_interaction_id => l_interaction_id,

Line 574: --if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

570:
571: --insert_log_mesg('Log Interaction return status: '||x_return_status);
572: --insert_log_mesg('Interaction Id: '||l_interaction_id);
573:
574: --if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
575: --for i in 1..x_msg_count
576: --loop
577: --insert_log_mesg('Message count: '||x_msg_count);
578: --insert_log_mesg('Message Data: '||x_msg_data);

Line 592: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

588: CLOSE c_code_id;
589: END IF;
590: --insert_log_mesg('Msource: '||l_code_id);
591:
592: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
593: RAISE FND_API.G_EXC_ERROR;
594: END IF;
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596: x_interaction_id := l_interaction_id;

Line 593: RAISE FND_API.G_EXC_ERROR;

589: END IF;
590: --insert_log_mesg('Msource: '||l_code_id);
591:
592: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
593: RAISE FND_API.G_EXC_ERROR;
594: END IF;
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596: x_interaction_id := l_interaction_id;
597: x_msource := l_code_id;

Line 595: x_return_status := FND_API.G_RET_STS_SUCCESS;

591:
592: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
593: RAISE FND_API.G_EXC_ERROR;
594: END IF;
595: x_return_status := FND_API.G_RET_STS_SUCCESS;
596: x_interaction_id := l_interaction_id;
597: x_msource := l_code_id;
598:
599: -- End of API body.

Line 602: IF FND_API.to_Boolean( p_commit ) THEN

598:
599: -- End of API body.
600:
601: -- Standard check for p_commit
602: IF FND_API.to_Boolean( p_commit ) THEN
603: COMMIT WORK;
604: END IF;
605:
606: --insert_log_mesg('Leaving weblitelog Happily !!!:)');

Line 612: WHEN FND_API.G_EXC_ERROR THEN

608: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
609:
610: EXCEPTION
611:
612: WHEN FND_API.G_EXC_ERROR THEN
613: ROLLBACK TO weblite_log;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_ERROR');
616: -- Standard call to get message count and if count=1, get the message

Line 614: x_return_status := FND_API.G_RET_STS_ERROR;

610: EXCEPTION
611:
612: WHEN FND_API.G_EXC_ERROR THEN
613: ROLLBACK TO weblite_log;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_ERROR');
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,

Line 615: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_ERROR');

611:
612: WHEN FND_API.G_EXC_ERROR THEN
613: ROLLBACK TO weblite_log;
614: x_return_status := FND_API.G_RET_STS_ERROR;
615: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_ERROR');
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,

Line 618: p_encoded => FND_API.G_FALSE,

614: x_return_status := FND_API.G_RET_STS_ERROR;
615: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_ERROR');
616: -- Standard call to get message count and if count=1, get the message
617: FND_MSG_PUB.Count_And_Get (
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );
622:

Line 623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

619: p_count => x_msg_count,
620: p_data => x_msg_data
621: );
622:
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: ROLLBACK TO weblite_log;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_UNEXPECTED_ERROR');
627: -- Standard call to get message count and if count=1, get the message

Line 625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

621: );
622:
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: ROLLBACK TO weblite_log;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_UNEXPECTED_ERROR');
627: -- Standard call to get message count and if count=1, get the message
628: FND_MSG_PUB.Count_And_Get (
629: p_encoded => FND_API.G_FALSE,

Line 626: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_UNEXPECTED_ERROR');

622:
623: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
624: ROLLBACK TO weblite_log;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_UNEXPECTED_ERROR');
627: -- Standard call to get message count and if count=1, get the message
628: FND_MSG_PUB.Count_And_Get (
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_msg_count,

Line 629: p_encoded => FND_API.G_FALSE,

625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: --insert_log_mesg('amsvtrkb:weblitelog:FND_API.G_EXC_UNEXPECTED_ERROR');
627: -- Standard call to get message count and if count=1, get the message
628: FND_MSG_PUB.Count_And_Get (
629: p_encoded => FND_API.G_FALSE,
630: p_count => x_msg_count,
631: p_data => x_msg_data
632: );
633:

Line 636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

632: );
633:
634: WHEN OTHERS THEN
635: ROLLBACK TO weblite_log;
636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
637: --insert_log_mesg('amsvtrkb:weblitelog:OTHERS');
638: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
639: THEN
640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

Line 644: p_encoded => FND_API.G_FALSE,

640: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
641: END IF;
642: -- Standard call to get message count and if count=1, get the message
643: FND_MSG_PUB.Count_And_Get (
644: p_encoded => FND_API.G_FALSE,
645: p_count => x_msg_count,
646: p_data => x_msg_data
647: );
648: