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_PRETTY_URL_PVT dependencies on AMS_PRETTY_URL

Line 1: PACKAGE BODY AMS_PRETTY_URL_PVT AS

1: PACKAGE BODY AMS_PRETTY_URL_PVT AS
2: /* $Header: amsvpurb.pls 120.2 2006/09/06 17:38:19 dbiswas noship $ */
3:
4: -- ===============================================================
5: -- Start of Comments

Line 7: -- AMS_PRETTY_URL_PVT

3:
4: -- ===============================================================
5: -- Start of Comments
6: -- Package name
7: -- AMS_PRETTY_URL_PVT
8: -- Purpose
9: --
10: -- This package contains all the program units for Pretty URLS
11: --

Line 18: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_PRETTY_URL_PVT';

14: -- NOTE
15: --
16: -- End of Comments
17:
18: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_PRETTY_URL_PVT';
19: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvpurb.pls';
20: g_log_level CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
21: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
22: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 92: FROM ams_pretty_url_assoc assoc,

88: WHERE schedule_id = p_current_used_by_id;
89:
90: CURSOR c_is_sysUrl_unique IS
91: SELECT sched.schedule_name, res.full_name
92: FROM ams_pretty_url_assoc assoc,
93: ams_system_pretty_url sysUrl,
94: ams_campaign_schedules_vl sched,
95: ams_jtf_rs_emp_v res
96: WHERE sysUrl.system_url = p_sys_url

Line 110: WRITE_LOG(l_api_name, 'Entering AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ ');

106: BEGIN
107:
108: x_return_status := FND_API.g_ret_sts_success;
109: l_api_name :='IS_SYSTEM_URL_UNIQ';
110: WRITE_LOG(l_api_name, 'Entering AMS_PRETTY_URL_PVT.IS_SYSTEM_URL_UNIQ ');
111:
112: IF p_sys_url IS NULL THEN
113: WRITE_LOG(l_api_name, 'System Value entered is null ');
114: RETURN;

Line 160: FND_MESSAGE.set_name('AMS', 'AMS_PRETTY_URL_NOT_UNIQUE_ERR');

156: IF l_scheduleName is not null
157: THEN
158: WRITE_LOG(l_api_name, p_sys_url||' is also used by ' ||p_current_used_by_id);
159: x_return_status := FND_API.g_ret_sts_error;
160: FND_MESSAGE.set_name('AMS', 'AMS_PRETTY_URL_NOT_UNIQUE_ERR');
161: FND_MESSAGE.set_token('SCHEDULENAME', l_scheduleName);
162: FND_MESSAGE.set_token('OWNER', l_ownerName);
163: FND_MSG_PUB.add;
164: RETURN;

Line 195: SELECT AMS_PRETTY_URL_s.NEXTVAL

191: l_PRETTY_URL_ID NUMBER;
192: l_dummy NUMBER;
193:
194: CURSOR c_id IS
195: SELECT AMS_PRETTY_URL_s.NEXTVAL
196: FROM dual;
197:
198: CURSOR c_id_exists (l_id IN NUMBER) IS
199: SELECT 1

Line 200: FROM AMS_PRETTY_URL

196: FROM dual;
197:
198: CURSOR c_id_exists (l_id IN NUMBER) IS
199: SELECT 1
200: FROM AMS_PRETTY_URL
201: WHERE PRETTY_URL_ID = l_id;
202:
203: BEGIN
204: -- Standard Start of API savepoint

Line 279: -- Invoke table handler(AMS_PRETTY_URL_PKG.Insert_Row)

275:
276: -- Debug Message
277: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
278:
279: -- Invoke table handler(AMS_PRETTY_URL_PKG.Insert_Row)
280: AMS_PRETTY_URL_PKG.Insert_Row(
281: px_pretty_url_id => l_pretty_url_id,
282: p_creation_date => SYSDATE,
283: p_created_by => G_USER_ID,

Line 280: AMS_PRETTY_URL_PKG.Insert_Row(

276: -- Debug Message
277: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
278:
279: -- Invoke table handler(AMS_PRETTY_URL_PKG.Insert_Row)
280: AMS_PRETTY_URL_PKG.Insert_Row(
281: px_pretty_url_id => l_pretty_url_id,
282: p_creation_date => SYSDATE,
283: p_created_by => G_USER_ID,
284: p_last_update_date => SYSDATE,

Line 372: FROM AMS_PRETTY_URL;

368:
369: IS
370: CURSOR c_get_pretty_url(pretty_url_id NUMBER) IS
371: SELECT *
372: FROM AMS_PRETTY_URL;
373: -- Hint: Developer need to provide Where clause
374: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_Pretty_Url';
375: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
376: -- Local Variables

Line 380: l_tar_pretty_url_rec AMS_Pretty_Url_PVT.pretty_url_rec_type := P_pretty_url_rec;

376: -- Local Variables
377: l_object_version_number NUMBER;
378: l_PRETTY_URL_ID NUMBER;
379: l_ref_pretty_url_rec c_get_Pretty_Url%ROWTYPE ;
380: l_tar_pretty_url_rec AMS_Pretty_Url_PVT.pretty_url_rec_type := P_pretty_url_rec;
381: l_rowid ROWID;
382:
383: BEGIN
384: -- Standard Start of API savepoint

Line 467: -- Invoke table handler(AMS_PRETTY_URL_PKG.Update_Row)

463:
464: -- Debug Message
465: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
466:
467: -- Invoke table handler(AMS_PRETTY_URL_PKG.Update_Row)
468: AMS_PRETTY_URL_PKG.Update_Row(
469: p_pretty_url_id => p_pretty_url_rec.pretty_url_id,
470: p_creation_date => SYSDATE,
471: p_created_by => G_USER_ID,

Line 468: AMS_PRETTY_URL_PKG.Update_Row(

464: -- Debug Message
465: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
466:
467: -- Invoke table handler(AMS_PRETTY_URL_PKG.Update_Row)
468: AMS_PRETTY_URL_PKG.Update_Row(
469: p_pretty_url_id => p_pretty_url_rec.pretty_url_id,
470: p_creation_date => SYSDATE,
471: p_created_by => G_USER_ID,
472: p_last_update_date => SYSDATE,

Line 587: -- Invoke table handler(AMS_PRETTY_URL_PKG.Delete_Row)

583: --
584: -- Debug Message
585: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
586:
587: -- Invoke table handler(AMS_PRETTY_URL_PKG.Delete_Row)
588: AMS_PRETTY_URL_PKG.Delete_Row(
589: p_PRETTY_URL_ID => p_PRETTY_URL_ID);
590: --
591: -- End of API body

Line 588: AMS_PRETTY_URL_PKG.Delete_Row(

584: -- Debug Message
585: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
586:
587: -- Invoke table handler(AMS_PRETTY_URL_PKG.Delete_Row)
588: AMS_PRETTY_URL_PKG.Delete_Row(
589: p_PRETTY_URL_ID => p_PRETTY_URL_ID);
590: --
591: -- End of API body
592: --

Line 673: FROM AMS_PRETTY_URL

669: l_PRETTY_URL_ID NUMBER;
670:
671: CURSOR c_Pretty_Url IS
672: SELECT PRETTY_URL_ID
673: FROM AMS_PRETTY_URL
674: WHERE PRETTY_URL_ID = p_PRETTY_URL_ID
675: AND object_version_number = p_object_version
676: FOR UPDATE NOWAIT;
677:

Line 780: 'AMS_PRETTY_URL',

776: BEGIN
777: x_return_status := FND_API.g_ret_sts_success;
778: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
779: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
780: 'AMS_PRETTY_URL',
781: 'PRETTY_URL_ID = ''' || p_pretty_url_rec.PRETTY_URL_ID ||''''
782: );
783: ELSE
784: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 785: 'AMS_PRETTY_URL',

781: 'PRETTY_URL_ID = ''' || p_pretty_url_rec.PRETTY_URL_ID ||''''
782: );
783: ELSE
784: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
785: 'AMS_PRETTY_URL',
786: 'PRETTY_URL_ID = ''' || p_pretty_url_rec.PRETTY_URL_ID ||
787: ''' AND PRETTY_URL_ID <> ' || p_pretty_url_rec.PRETTY_URL_ID
788: );
789: END IF;

Line 792: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_PRETTY_URL_ID_DUPLICATE');

788: );
789: END IF;
790:
791: IF l_valid_flag = FND_API.g_false THEN
792: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_PRETTY_URL_ID_DUPLICATE');
793: x_return_status := FND_API.g_ret_sts_error;
794: RETURN;
795: END IF;
796:

Line 812: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_pretty_url_id');

808: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
809:
810:
811: IF p_pretty_url_rec.pretty_url_id = FND_API.g_miss_num OR p_pretty_url_rec.pretty_url_id IS NULL THEN
812: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_pretty_url_id');
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;
815: END IF;
816:

Line 819: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_creation_date');

815: END IF;
816:
817:
818: IF p_pretty_url_rec.creation_date = FND_API.g_miss_date OR p_pretty_url_rec.creation_date IS NULL THEN
819: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_creation_date');
820: x_return_status := FND_API.g_ret_sts_error;
821: RETURN;
822: END IF;
823:

Line 826: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_created_by');

822: END IF;
823:
824:
825: IF p_pretty_url_rec.created_by = FND_API.g_miss_num OR p_pretty_url_rec.created_by IS NULL THEN
826: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_created_by');
827: x_return_status := FND_API.g_ret_sts_error;
828: RETURN;
829: END IF;
830:

Line 833: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_update_date');

829: END IF;
830:
831:
832: IF p_pretty_url_rec.last_update_date = FND_API.g_miss_date OR p_pretty_url_rec.last_update_date IS NULL THEN
833: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_update_date');
834: x_return_status := FND_API.g_ret_sts_error;
835: RETURN;
836: END IF;
837:

Line 840: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_updated_by');

836: END IF;
837:
838:
839: IF p_pretty_url_rec.last_updated_by = FND_API.g_miss_num OR p_pretty_url_rec.last_updated_by IS NULL THEN
840: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_updated_by');
841: x_return_status := FND_API.g_ret_sts_error;
842: RETURN;
843: END IF;
844:

Line 847: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_landing_page_url');

843: END IF;
844:
845:
846: IF p_pretty_url_rec.landing_page_url = FND_API.g_miss_char OR p_pretty_url_rec.landing_page_url IS NULL THEN
847: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_landing_page_url');
848: x_return_status := FND_API.g_ret_sts_error;
849: RETURN;
850: END IF;
851: ELSE

Line 855: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_pretty_url_id');

851: ELSE
852:
853:
854: IF p_pretty_url_rec.pretty_url_id IS NULL THEN
855: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_pretty_url_id');
856: x_return_status := FND_API.g_ret_sts_error;
857: RETURN;
858: END IF;
859:

Line 862: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_creation_date');

858: END IF;
859:
860:
861: IF p_pretty_url_rec.creation_date IS NULL THEN
862: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_creation_date');
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;
866:

Line 869: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_created_by');

865: END IF;
866:
867:
868: IF p_pretty_url_rec.created_by IS NULL THEN
869: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_created_by');
870: x_return_status := FND_API.g_ret_sts_error;
871: RETURN;
872: END IF;
873:

Line 876: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_update_date');

872: END IF;
873:
874:
875: IF p_pretty_url_rec.last_update_date IS NULL THEN
876: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_update_date');
877: x_return_status := FND_API.g_ret_sts_error;
878: RETURN;
879: END IF;
880:

Line 883: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_updated_by');

879: END IF;
880:
881:
882: IF p_pretty_url_rec.last_updated_by IS NULL THEN
883: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_last_updated_by');
884: x_return_status := FND_API.g_ret_sts_error;
885: RETURN;
886: END IF;
887:

Line 890: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_landing_page_url');

886: END IF;
887:
888:
889: IF p_pretty_url_rec.landing_page_url IS NULL THEN
890: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_pretty_url_NO_landing_page_url');
891: x_return_status := FND_API.g_ret_sts_error;
892: RETURN;
893: END IF;
894: END IF;

Line 977: FROM ams_pretty_url

973: l_return_status VARCHAR2(1);
974:
975: CURSOR c_complete IS
976: SELECT *
977: FROM ams_pretty_url
978: WHERE pretty_url_id = p_pretty_url_rec.pretty_url_id;
979: l_pretty_url_rec c_complete%ROWTYPE;
980: BEGIN
981: x_complete_rec := p_pretty_url_rec;

Line 1043: l_pretty_url_rec AMS_Pretty_Url_PVT.pretty_url_rec_type;

1039: IS
1040: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_Pretty_Url';
1041: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
1042: l_object_version_number NUMBER;
1043: l_pretty_url_rec AMS_Pretty_Url_PVT.pretty_url_rec_type;
1044:
1045: BEGIN
1046: -- Standard Start of API savepoint
1047: SAVEPOINT VALIDATE_Pretty_Url_;

Line 1215: --AMS_Utility_PVT.error_message('AMS_pretty_url_NO_pretty_url_id'); -- need to seed message here

1211:
1212:
1213: IF p_pretty_url_rec.pretty_url_id = FND_API.g_miss_num OR p_pretty_url_rec.pretty_url_id IS NULL THEN
1214: WRITE_LOG(l_api_name, 'Pretty Url Id not found');
1215: --AMS_Utility_PVT.error_message('AMS_pretty_url_NO_pretty_url_id'); -- need to seed message here
1216: x_return_status := FND_API.g_ret_sts_error;
1217: FND_MESSAGE.set_name('AMS', 'AMS_pretty_url_NO_pretty_url_id');
1218: FND_MSG_PUB.add;
1219: RETURN;

Line 1217: FND_MESSAGE.set_name('AMS', 'AMS_pretty_url_NO_pretty_url_id');

1213: IF p_pretty_url_rec.pretty_url_id = FND_API.g_miss_num OR p_pretty_url_rec.pretty_url_id IS NULL THEN
1214: WRITE_LOG(l_api_name, 'Pretty Url Id not found');
1215: --AMS_Utility_PVT.error_message('AMS_pretty_url_NO_pretty_url_id'); -- need to seed message here
1216: x_return_status := FND_API.g_ret_sts_error;
1217: FND_MESSAGE.set_name('AMS', 'AMS_pretty_url_NO_pretty_url_id');
1218: FND_MSG_PUB.add;
1219: RETURN;
1220: END IF;
1221:

Line 1234: END AMS_PRETTY_URL_PVT;

1230:
1231: END CHECK_PU_MANDATORY_FIELDS;
1232:
1233:
1234: END AMS_PRETTY_URL_PVT;