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_WEB_TRACK_PVT dependencies on AMS_UTILITY_PVT

Line 133: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

129:
130:
131:
132: -- Debug Message
133: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
134:
135:
136:
137: -- Initialize API return status to SUCCESS

Line 146: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

142: -- =========================================================================
143:
144: IF FND_GLOBAL.USER_ID IS NULL
145: THEN
146: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
147: RAISE FND_API.G_EXC_ERROR;
148: END IF;
149:
150: --insert_log_mesg('Validate Environment');

Line 155: AMS_UTILITY_PVT.debug_message('Private API: Validate_Web_Track');

151:
152: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
153: THEN
154: -- Debug message
155: AMS_UTILITY_PVT.debug_message('Private API: Validate_Web_Track');
156:
157: -- Invoke validation procedures
158: Validate_web_track(
159: p_api_version_number => 1.0,

Line 197: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

193: l_web_tracking_id := p_web_track_rec.web_tracking_id;
194: END IF;
195:
196: -- Debug Message
197: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
198: --insert_log_mesg('Private API: Calling create table handler ::::');
199:
200: -- Invoke table handler(Ams_Web_Track_Pkg.Insert_Row)
201: Ams_Web_Track_Pkg.Insert_Row(

Line 248: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

244: END IF;
245:
246:
247: -- Debug Message
248: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
249:
250:
251: -- Standard call to get message count and if count is 1, get message info.
252: FND_MSG_PUB.Count_And_Get

Line 258: WHEN AMS_Utility_PVT.resource_locked THEN

254: p_data => x_msg_data
255: );
256: EXCEPTION
257:
258: WHEN AMS_Utility_PVT.resource_locked THEN
259: x_return_status := FND_API.g_ret_sts_error;
260: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
261: --insert_log_mesg('AMS_API_RESOURCE_LOCKED');
262:

Line 260: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

256: EXCEPTION
257:
258: WHEN AMS_Utility_PVT.resource_locked THEN
259: x_return_status := FND_API.g_ret_sts_error;
260: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
261: --insert_log_mesg('AMS_API_RESOURCE_LOCKED');
262:
263: WHEN FND_API.G_EXC_ERROR THEN
264: ROLLBACK TO create_web_track_pvt;

Line 389: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

385:
386:
387:
388: -- Debug Message
389: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
390:
391:
392:
393: -- Initialize API return status to SUCCESS

Line 397: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

393: -- Initialize API return status to SUCCESS
394: x_return_status := FND_API.G_RET_STS_SUCCESS;
395:
396: -- Debug Message
397: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
398:
399: OPEN c_get_Web_Track( l_tar_web_track_rec.web_tracking_id);
400:
401: FETCH c_get_Web_Track INTO l_ref_web_track_rec ;

Line 404: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

400:
401: FETCH c_get_Web_Track INTO l_ref_web_track_rec ;
402:
403: If ( c_get_Web_Track%NOTFOUND) THEN
404: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
405: p_token_name => 'INFO',
406: p_token_value => 'Web_Track') ;
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;

Line 410: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

406: p_token_value => 'Web_Track') ;
407: RAISE FND_API.G_EXC_ERROR;
408: END IF;
409: -- Debug Message
410: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
411: CLOSE c_get_Web_Track;
412:
413:
414: If (l_tar_web_track_rec.object_version_number is NULL or

Line 416: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

412:
413:
414: If (l_tar_web_track_rec.object_version_number is NULL or
415: l_tar_web_track_rec.object_version_number = FND_API.G_MISS_NUM ) Then
416: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
417: p_token_name => 'COLUMN',
418: p_token_value => 'Last_Update_Date') ;
419: raise FND_API.G_EXC_ERROR;
420: End if;

Line 423: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

419: raise FND_API.G_EXC_ERROR;
420: End if;
421: -- Check Whether record has been changed by someone else
422: If (l_tar_web_track_rec.object_version_number <> l_ref_web_track_rec.object_version_number) Then
423: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
424: p_token_name => 'INFO',
425: p_token_value => 'Web_Track') ;
426: raise FND_API.G_EXC_ERROR;
427: End if;

Line 433: AMS_UTILITY_PVT.debug_message('Private API: Validate_Web_Track');

429:
430: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
431: THEN
432: -- Debug message
433: AMS_UTILITY_PVT.debug_message('Private API: Validate_Web_Track');
434:
435:
436: -- Invoke validation procedures
437: Validate_web_track(

Line 454: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

450: END IF;
451:
452:
453: -- Debug Message
454: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
455:
456: -- Invoke table handler(Ams_Web_Track_Pkg.Update_Row)
457: Ams_Web_Track_Pkg.Update_Row(
458: p_web_tracking_id => p_web_track_rec.web_tracking_id,

Line 496: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

492: END IF;
493:
494:
495: -- Debug Message
496: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
497:
498:
499: -- Standard call to get message count and if count is 1, get message info.
500: FND_MSG_PUB.Count_And_Get

Line 506: WHEN AMS_Utility_PVT.resource_locked THEN

502: p_data => x_msg_data
503: );
504: EXCEPTION
505:
506: WHEN AMS_Utility_PVT.resource_locked THEN
507: x_return_status := FND_API.g_ret_sts_error;
508: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
509:
510: WHEN FND_API.G_EXC_ERROR THEN

Line 508: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

504: EXCEPTION
505:
506: WHEN AMS_Utility_PVT.resource_locked THEN
507: x_return_status := FND_API.g_ret_sts_error;
508: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
509:
510: WHEN FND_API.G_EXC_ERROR THEN
511: ROLLBACK TO UPDATE_Web_Track_PVT;
512: x_return_status := FND_API.G_RET_STS_ERROR;

Line 620: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

616:
617:
618:
619: -- Debug Message
620: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
621:
622:
623:
624: -- Initialize API return status to SUCCESS

Line 631: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

627: --
628: -- Api body
629: --
630: -- Debug Message
631: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
632:
633: -- Invoke table handler(Ams_Web_Track_Pkg.Delete_Row)
634: Ams_Web_Track_Pkg.Delete_Row(
635: p_web_tracking_id => p_web_tracking_id,

Line 649: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

645: END IF;
646:
647:
648: -- Debug Message
649: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
650:
651:
652: -- Standard call to get message count and if count is 1, get message info.
653: FND_MSG_PUB.Count_And_Get

Line 659: WHEN AMS_Utility_PVT.resource_locked THEN

655: p_data => x_msg_data
656: );
657: EXCEPTION
658:
659: WHEN AMS_Utility_PVT.resource_locked THEN
660: x_return_status := FND_API.g_ret_sts_error;
661: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
662:
663: WHEN FND_API.G_EXC_ERROR THEN

Line 661: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

657: EXCEPTION
658:
659: WHEN AMS_Utility_PVT.resource_locked THEN
660: x_return_status := FND_API.g_ret_sts_error;
661: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
662:
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO DELETE_Web_Track_PVT;
665: x_return_status := FND_API.G_RET_STS_ERROR;

Line 755: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

751:
752: BEGIN
753:
754: -- Debug Message
755: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
756:
757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.
759: IF FND_API.to_Boolean( p_init_msg_list )

Line 790: AMS_Utility_PVT.debug_message(l_full_name ||': end');

786: FND_MSG_PUB.count_and_get(
787: p_encoded => FND_API.g_false,
788: p_count => x_msg_count,
789: p_data => x_msg_data);
790: AMS_Utility_PVT.debug_message(l_full_name ||': end');
791: EXCEPTION
792:
793: WHEN AMS_Utility_PVT.resource_locked THEN
794: x_return_status := FND_API.g_ret_sts_error;

Line 793: WHEN AMS_Utility_PVT.resource_locked THEN

789: p_data => x_msg_data);
790: AMS_Utility_PVT.debug_message(l_full_name ||': end');
791: EXCEPTION
792:
793: WHEN AMS_Utility_PVT.resource_locked THEN
794: x_return_status := FND_API.g_ret_sts_error;
795: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
796:
797: WHEN FND_API.G_EXC_ERROR THEN

Line 795: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

791: EXCEPTION
792:
793: WHEN AMS_Utility_PVT.resource_locked THEN
794: x_return_status := FND_API.g_ret_sts_error;
795: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
796:
797: WHEN FND_API.G_EXC_ERROR THEN
798: ROLLBACK TO LOCK_Web_Track_PVT;
799: x_return_status := FND_API.G_RET_STS_ERROR;

Line 847: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

843: x_return_status := FND_API.g_ret_sts_success;
844: IF p_validation_mode = JTF_PLSQL_API.g_create
845: AND p_web_track_rec.web_tracking_id IS NOT NULL
846: THEN
847: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
848: 'ams_web_tracking',
849: 'web_tracking_id = ''' || p_web_track_rec.web_tracking_id ||''''
850: );
851: END IF;

Line 854: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_web_tracking_id_DUPLICATE');

850: );
851: END IF;
852:
853: IF l_valid_flag = FND_API.g_false THEN
854: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_web_tracking_id_DUPLICATE');
855: x_return_status := FND_API.g_ret_sts_error;
856: END IF;
857:
858: END check_Web_Track_Uk_Items;

Line 879: -- AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_TRACKING_ID' );

875: --insert_log_mesg('Web Tracking Id ::::'||p_web_track_rec.web_tracking_id);
876:
877: -- IF p_web_track_rec.web_tracking_id = FND_API.G_MISS_NUM OR p_web_track_rec.web_tracking_id IS NULL THEN
878: --insert_log_mesg('error');
879: -- AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_TRACKING_ID' );
880: -- x_return_status := FND_API.g_ret_sts_error;
881: -- END IF;
882: --insert_log_mesg(x_return_status);
883:

Line 885: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SCHEDULE_ID' );

881: -- END IF;
882: --insert_log_mesg(x_return_status);
883:
884: IF p_web_track_rec.schedule_id = FND_API.G_MISS_NUM OR p_web_track_rec.schedule_id IS NULL THEN
885: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SCHEDULE_ID' );
886: x_return_status := FND_API.g_ret_sts_error;
887: END IF;
888:
889: --insert_log_mesg('Schedule Id ::::'||p_web_track_rec.schedule_id);

Line 891: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTY_ID' );

887: END IF;
888:
889: --insert_log_mesg('Schedule Id ::::'||p_web_track_rec.schedule_id);
890: IF p_web_track_rec.party_id = FND_API.G_MISS_NUM OR p_web_track_rec.party_id IS NULL THEN
891: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTY_ID' );
892: x_return_status := FND_API.g_ret_sts_error;
893: END IF;
894:
895: --insert_log_mesg(p_web_track_rec.placement_id);

Line 897: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PLACEMENT_ID' );

893: END IF;
894:
895: --insert_log_mesg(p_web_track_rec.placement_id);
896: IF p_web_track_rec.placement_id = FND_API.G_MISS_NUM OR p_web_track_rec.placement_id IS NULL THEN
897: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PLACEMENT_ID' );
898: x_return_status := FND_API.g_ret_sts_error;
899: END IF;
900:
901:

Line 906: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_TRACKING_ID' );

902: ELSE
903:
904: --insert_log_mesg('else check_Web_Track_Req_Items');
905: IF p_web_track_rec.web_tracking_id = FND_API.G_MISS_NUM THEN
906: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_TRACKING_ID' );
907: x_return_status := FND_API.g_ret_sts_error;
908: END IF;
909:
910:

Line 912: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SCHEDULE_ID' );

908: END IF;
909:
910:
911: IF p_web_track_rec.schedule_id = FND_API.G_MISS_NUM THEN
912: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'SCHEDULE_ID' );
913: x_return_status := FND_API.g_ret_sts_error;
914: END IF;
915:
916:

Line 918: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTY_ID' );

914: END IF;
915:
916:
917: IF p_web_track_rec.party_id = FND_API.G_MISS_NUM THEN
918: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PARTY_ID' );
919: x_return_status := FND_API.g_ret_sts_error;
920: END IF;
921:
922:

Line 924: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PLACEMENT_ID' );

920: END IF;
921:
922:
923: IF p_web_track_rec.placement_id = FND_API.G_MISS_NUM THEN
924: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'PLACEMENT_ID' );
925: x_return_status := FND_API.g_ret_sts_error;
926: END IF;
927: END IF;
928:

Line 1289: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1285: END IF;
1286:
1287:
1288: -- Debug Message
1289: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1290:
1291:
1292:
1293: -- Initialize API return status to SUCCESS

Line 1298: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1294: x_return_status := FND_API.G_RET_STS_SUCCESS;
1295:
1296: --insert_log_mesg(x_return_status);
1297: -- Debug Message
1298: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1299:
1300:
1301: -- Standard call to get message count and if count is 1, get message info.
1302: FND_MSG_PUB.Count_And_Get

Line 1308: WHEN AMS_Utility_PVT.resource_locked THEN

1304: p_data => x_msg_data
1305: );
1306: EXCEPTION
1307:
1308: WHEN AMS_Utility_PVT.resource_locked THEN
1309: x_return_status := FND_API.g_ret_sts_error;
1310: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1311:
1312: WHEN FND_API.G_EXC_ERROR THEN

Line 1310: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1306: EXCEPTION
1307:
1308: WHEN AMS_Utility_PVT.resource_locked THEN
1309: x_return_status := FND_API.g_ret_sts_error;
1310: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1311:
1312: WHEN FND_API.G_EXC_ERROR THEN
1313: ROLLBACK TO VALIDATE_Web_Track_;
1314: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1375: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1371: -- THEN
1372: -- x_return_status := FND_API.G_RET_STS_ERROR;
1373:
1374: -- Debug Message
1375: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1376: -- Standard call to get message count and if count is 1, get message info.
1377: FND_MSG_PUB.Count_And_Get
1378: (p_count => x_msg_count,
1379: p_data => x_msg_data

Line 1478: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1474:
1475:
1476:
1477: -- Debug Message
1478: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1479:
1480:
1481:
1482: -- Initialize API return status to SUCCESS

Line 1491: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

1487: -- =========================================================================
1488:
1489: IF FND_GLOBAL.USER_ID IS NULL
1490: THEN
1491: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
1492: RAISE FND_API.G_EXC_ERROR;
1493: END IF;
1494:
1495:

Line 1500: AMS_UTILITY_PVT.debug_message('Private API: Validate_Web_Recomms');

1496:
1497: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
1498: THEN
1499: -- Debug message
1500: AMS_UTILITY_PVT.debug_message('Private API: Validate_Web_Recomms');
1501:
1502: -- Invoke validation procedures
1503: Validate_web_recomms(
1504: p_api_version_number => 1.0,

Line 1537: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

1533: l_web_recomm_id := p_web_recomms_rec.web_recomm_id;
1534: END IF;
1535:
1536: -- Debug Message
1537: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
1538:
1539: -- Invoke table handler(Ams_Web_Recomms_Pkg.Insert_Row)
1540: Ams_Web_Recomms_Pkg.Insert_Row(
1541: px_web_recomm_id => l_web_recomm_id,

Line 1588: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1584: END IF;
1585:
1586:
1587: -- Debug Message
1588: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1589:
1590:
1591: -- Standard call to get message count and if count is 1, get message info.
1592: FND_MSG_PUB.Count_And_Get

Line 1598: WHEN AMS_Utility_PVT.resource_locked THEN

1594: p_data => x_msg_data
1595: );
1596: EXCEPTION
1597:
1598: WHEN AMS_Utility_PVT.resource_locked THEN
1599: x_return_status := FND_API.g_ret_sts_error;
1600: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1601:
1602: WHEN FND_API.G_EXC_ERROR THEN

Line 1600: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1596: EXCEPTION
1597:
1598: WHEN AMS_Utility_PVT.resource_locked THEN
1599: x_return_status := FND_API.g_ret_sts_error;
1600: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1601:
1602: WHEN FND_API.G_EXC_ERROR THEN
1603: ROLLBACK TO CREATE_Web_Recomms_PVT;
1604: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1726: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1722:
1723:
1724:
1725: -- Debug Message
1726: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1727:
1728:
1729:
1730: -- Initialize API return status to SUCCESS

Line 1734: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

1730: -- Initialize API return status to SUCCESS
1731: x_return_status := FND_API.G_RET_STS_SUCCESS;
1732:
1733: -- Debug Message
1734: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
1735:
1736: OPEN c_get_Web_Recomms( l_tar_web_recomms_rec.web_recomm_id);
1737:
1738: FETCH c_get_Web_Recomms INTO l_ref_web_recomms_rec ;

Line 1741: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

1737:
1738: FETCH c_get_Web_Recomms INTO l_ref_web_recomms_rec ;
1739:
1740: If ( c_get_Web_Recomms%NOTFOUND) THEN
1741: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
1742: p_token_name => 'INFO',
1743: p_token_value => 'Web_Recomms') ;
1744: RAISE FND_API.G_EXC_ERROR;
1745: END IF;

Line 1747: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

1743: p_token_value => 'Web_Recomms') ;
1744: RAISE FND_API.G_EXC_ERROR;
1745: END IF;
1746: -- Debug Message
1747: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
1748: CLOSE c_get_Web_Recomms;
1749:
1750:
1751: If (l_tar_web_recomms_rec.object_version_number is NULL or

Line 1753: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

1749:
1750:
1751: If (l_tar_web_recomms_rec.object_version_number is NULL or
1752: l_tar_web_recomms_rec.object_version_number = FND_API.G_MISS_NUM ) Then
1753: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
1754: p_token_name => 'COLUMN',
1755: p_token_value => 'Last_Update_Date') ;
1756: raise FND_API.G_EXC_ERROR;
1757: End if;

Line 1760: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

1756: raise FND_API.G_EXC_ERROR;
1757: End if;
1758: -- Check Whether record has been changed by someone else
1759: If (l_tar_web_recomms_rec.object_version_number <> l_ref_web_recomms_rec.object_version_number) Then
1760: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
1761: p_token_name => 'INFO',
1762: p_token_value => 'Web_Recomms') ;
1763: raise FND_API.G_EXC_ERROR;
1764: End if;

Line 1770: AMS_UTILITY_PVT.debug_message('Private API: Validate_Web_Recomms');

1766:
1767: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
1768: THEN
1769: -- Debug message
1770: AMS_UTILITY_PVT.debug_message('Private API: Validate_Web_Recomms');
1771:
1772: -- Invoke validation procedures
1773: Validate_web_recomms(
1774: p_api_version_number => 1.0,

Line 1790: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

1786: END IF;
1787:
1788:
1789: -- Debug Message
1790: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
1791:
1792: -- Invoke table handler(Ams_Web_Recomms_Pkg.Update_Row)
1793: Ams_Web_Recomms_Pkg.Update_Row(
1794: p_web_recomm_id => p_web_recomms_rec.web_recomm_id,

Line 1834: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1830: END IF;
1831:
1832:
1833: -- Debug Message
1834: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1835:
1836:
1837: -- Standard call to get message count and if count is 1, get message info.
1838: FND_MSG_PUB.Count_And_Get

Line 1844: WHEN AMS_Utility_PVT.resource_locked THEN

1840: p_data => x_msg_data
1841: );
1842: EXCEPTION
1843:
1844: WHEN AMS_Utility_PVT.resource_locked THEN
1845: x_return_status := FND_API.g_ret_sts_error;
1846: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1847:
1848: WHEN FND_API.G_EXC_ERROR THEN

Line 1846: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1842: EXCEPTION
1843:
1844: WHEN AMS_Utility_PVT.resource_locked THEN
1845: x_return_status := FND_API.g_ret_sts_error;
1846: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1847:
1848: WHEN FND_API.G_EXC_ERROR THEN
1849: ROLLBACK TO UPDATE_Web_Recomms_PVT;
1850: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1958: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

1954:
1955:
1956:
1957: -- Debug Message
1958: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1959:
1960:
1961:
1962: -- Initialize API return status to SUCCESS

Line 1969: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

1965: --
1966: -- Api body
1967: --
1968: -- Debug Message
1969: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1970:
1971: -- Invoke table handler(Ams_Web_Recomms_Pkg.Delete_Row)
1972: Ams_Web_Recomms_Pkg.Delete_Row(
1973: p_web_recomm_id => p_web_recomm_id,

Line 1987: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

1983: END IF;
1984:
1985:
1986: -- Debug Message
1987: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1988:
1989:
1990: -- Standard call to get message count and if count is 1, get message info.
1991: FND_MSG_PUB.Count_And_Get

Line 1997: WHEN AMS_Utility_PVT.resource_locked THEN

1993: p_data => x_msg_data
1994: );
1995: EXCEPTION
1996:
1997: WHEN AMS_Utility_PVT.resource_locked THEN
1998: x_return_status := FND_API.g_ret_sts_error;
1999: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2000:
2001: WHEN FND_API.G_EXC_ERROR THEN

Line 1999: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1995: EXCEPTION
1996:
1997: WHEN AMS_Utility_PVT.resource_locked THEN
1998: x_return_status := FND_API.g_ret_sts_error;
1999: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2000:
2001: WHEN FND_API.G_EXC_ERROR THEN
2002: ROLLBACK TO DELETE_Web_Recomms_PVT;
2003: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2093: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

2089:
2090: BEGIN
2091:
2092: -- Debug Message
2093: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2094:
2095:
2096: -- Initialize message list if p_init_msg_list is set to TRUE.
2097: IF FND_API.to_Boolean( p_init_msg_list )

Line 2128: AMS_Utility_PVT.debug_message(l_full_name ||': end');

2124: FND_MSG_PUB.count_and_get(
2125: p_encoded => FND_API.g_false,
2126: p_count => x_msg_count,
2127: p_data => x_msg_data);
2128: AMS_Utility_PVT.debug_message(l_full_name ||': end');
2129: EXCEPTION
2130:
2131: WHEN AMS_Utility_PVT.resource_locked THEN
2132: x_return_status := FND_API.g_ret_sts_error;

Line 2131: WHEN AMS_Utility_PVT.resource_locked THEN

2127: p_data => x_msg_data);
2128: AMS_Utility_PVT.debug_message(l_full_name ||': end');
2129: EXCEPTION
2130:
2131: WHEN AMS_Utility_PVT.resource_locked THEN
2132: x_return_status := FND_API.g_ret_sts_error;
2133: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2134:
2135: WHEN FND_API.G_EXC_ERROR THEN

Line 2133: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

2129: EXCEPTION
2130:
2131: WHEN AMS_Utility_PVT.resource_locked THEN
2132: x_return_status := FND_API.g_ret_sts_error;
2133: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2134:
2135: WHEN FND_API.G_EXC_ERROR THEN
2136: ROLLBACK TO LOCK_Web_Recomms_PVT;
2137: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2185: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

2181: x_return_status := FND_API.g_ret_sts_success;
2182: IF p_validation_mode = JTF_PLSQL_API.g_create
2183: AND p_web_recomms_rec.web_recomm_id IS NOT NULL
2184: THEN
2185: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
2186: 'ams_web_recomms',
2187: 'web_recomm_id = ''' || p_web_recomms_rec.web_recomm_id ||''''
2188: );
2189: END IF;

Line 2192: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_web_recomm_id_DUPLICATE');

2188: );
2189: END IF;
2190:
2191: IF l_valid_flag = FND_API.g_false THEN
2192: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_web_recomm_id_DUPLICATE');
2193: x_return_status := FND_API.g_ret_sts_error;
2194: END IF;
2195:
2196: END check_Web_Recomms_Uk_Items;

Line 2213: -- AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_RECOMM_ID' );

2209: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
2210:
2211:
2212: -- IF p_web_recomms_rec.web_recomm_id = FND_API.G_MISS_NUM OR p_web_recomms_rec.web_recomm_id IS NULL THEN
2213: -- AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_RECOMM_ID' );
2214: -- x_return_status := FND_API.g_ret_sts_error;
2215: -- END IF;
2216:
2217:

Line 2219: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_TRACKING_ID' );

2215: -- END IF;
2216:
2217:
2218: IF p_web_recomms_rec.web_tracking_id = FND_API.G_MISS_NUM OR p_web_recomms_rec.web_tracking_id IS NULL THEN
2219: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_TRACKING_ID' );
2220: x_return_status := FND_API.g_ret_sts_error;
2221: END IF;
2222:
2223:

Line 2228: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_RECOMM_ID' );

2224: ELSE
2225:
2226:
2227: IF p_web_recomms_rec.web_recomm_id = FND_API.G_MISS_NUM THEN
2228: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_RECOMM_ID' );
2229: x_return_status := FND_API.g_ret_sts_error;
2230: END IF;
2231:
2232:

Line 2234: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_TRACKING_ID' );

2230: END IF;
2231:
2232:
2233: IF p_web_recomms_rec.web_tracking_id = FND_API.G_MISS_NUM THEN
2234: AMS_Utility_PVT.Error_Message('AMS_API_MISSING_FIELD', 'MISS_FIELD', 'WEB_TRACKING_ID' );
2235: x_return_status := FND_API.g_ret_sts_error;
2236: END IF;
2237: END IF;
2238:

Line 2592: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

2588: END IF;
2589:
2590:
2591: -- Debug Message
2592: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
2593:
2594:
2595:
2596: -- Initialize API return status to SUCCESS

Line 2601: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

2597: x_return_status := FND_API.G_RET_STS_SUCCESS;
2598:
2599:
2600: -- Debug Message
2601: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
2602:
2603:
2604: -- Standard call to get message count and if count is 1, get message info.
2605: FND_MSG_PUB.Count_And_Get

Line 2611: WHEN AMS_Utility_PVT.resource_locked THEN

2607: p_data => x_msg_data
2608: );
2609: EXCEPTION
2610:
2611: WHEN AMS_Utility_PVT.resource_locked THEN
2612: x_return_status := FND_API.g_ret_sts_error;
2613: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2614:
2615: WHEN FND_API.G_EXC_ERROR THEN

Line 2613: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

2609: EXCEPTION
2610:
2611: WHEN AMS_Utility_PVT.resource_locked THEN
2612: x_return_status := FND_API.g_ret_sts_error;
2613: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2614:
2615: WHEN FND_API.G_EXC_ERROR THEN
2616: ROLLBACK TO VALIDATE_Web_Recomms_;
2617: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2678: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

2674: -- THEN
2675: -- x_return_status := FND_API.G_RET_STS_ERROR;
2676:
2677: -- Debug Message
2678: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2679: -- Standard call to get message count and if count is 1, get message info.
2680: FND_MSG_PUB.Count_And_Get
2681: (p_count => x_msg_count,
2682: p_data => x_msg_data

Line 2741: AMS_UTILITY_PVT.debug_message('Private API: Create_Web_Imp_Track');

2737: -- THEN
2738: -- x_return_status := FND_API.G_RET_STS_ERROR;
2739:
2740: -- Debug Message
2741: AMS_UTILITY_PVT.debug_message('Private API: Create_Web_Imp_Track');
2742: -- Standard call to get message count and if count is 1, get message info.
2743: FND_MSG_PUB.Count_And_Get
2744: (p_count => x_msg_count,
2745: p_data => x_msg_data

Line 2900: WHEN AMS_Utility_PVT.resource_locked THEN

2896: --insert_log_mesg('FINALLY DONE ::::');
2897:
2898: EXCEPTION
2899:
2900: WHEN AMS_Utility_PVT.resource_locked THEN
2901: x_return_status := FND_API.g_ret_sts_error;
2902: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2903: --insert_log_mesg(x_return_status);
2904:

Line 2902: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

2898: EXCEPTION
2899:
2900: WHEN AMS_Utility_PVT.resource_locked THEN
2901: x_return_status := FND_API.g_ret_sts_error;
2902: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
2903: --insert_log_mesg(x_return_status);
2904:
2905: WHEN FND_API.G_EXC_ERROR THEN
2906: ROLLBACK TO Create_Web_Imp_Track;