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_SYSTEM_PRETTY_URL_PVT dependencies on AMS_SYSTEM_PRETTY_URL

Line 1: PACKAGE BODY AMS_System_Pretty_Url_PVT as

1: PACKAGE BODY AMS_System_Pretty_Url_PVT as
2: /* $Header: amsvspub.pls 120.0 2005/07/01 03:51:51 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name

Line 6: -- AMS_System_Pretty_Url_PVT

2: /* $Header: amsvspub.pls 120.0 2005/07/01 03:51:51 appldev noship $ */
3: -- ===============================================================
4: -- Start of Comments
5: -- Package name
6: -- AMS_System_Pretty_Url_PVT
7: -- Purpose
8: --
9: -- History
10: --

Line 17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_System_Pretty_Url_PVT';

13: -- End of Comments
14: -- ===============================================================
15:
16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_System_Pretty_Url_PVT';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amsvspub.pls';
19:
20: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
21: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

Line 48: SELECT AMS_SYSTEM_PRETTY_URL_s.NEXTVAL

44: l_SYSTEM_URL_ID NUMBER;
45: l_dummy NUMBER;
46:
47: CURSOR c_id IS
48: SELECT AMS_SYSTEM_PRETTY_URL_s.NEXTVAL
49: FROM dual;
50:
51: CURSOR c_id_exists (l_id IN NUMBER) IS
52: SELECT 1

Line 53: FROM AMS_SYSTEM_PRETTY_URL

49: FROM dual;
50:
51: CURSOR c_id_exists (l_id IN NUMBER) IS
52: SELECT 1
53: FROM AMS_SYSTEM_PRETTY_URL
54: WHERE SYSTEM_URL_ID = l_id;
55:
56: BEGIN
57: -- Standard Start of API savepoint

Line 132: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Insert_Row)

128:
129: -- Debug Message
130: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
131:
132: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Insert_Row)
133: AMS_SYSTEM_PRETTY_URL_PKG.Insert_Row(
134: px_system_url_id => l_system_url_id,
135: p_creation_date => SYSDATE,
136: p_created_by => G_USER_ID,

Line 133: AMS_SYSTEM_PRETTY_URL_PKG.Insert_Row(

129: -- Debug Message
130: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
131:
132: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Insert_Row)
133: AMS_SYSTEM_PRETTY_URL_PKG.Insert_Row(
134: px_system_url_id => l_system_url_id,
135: p_creation_date => SYSDATE,
136: p_created_by => G_USER_ID,
137: p_last_update_date => SYSDATE,

Line 229: FROM AMS_SYSTEM_PRETTY_URL;

225:
226: IS
227: CURSOR c_get_system_pretty_url(system_url_id NUMBER) IS
228: SELECT *
229: FROM AMS_SYSTEM_PRETTY_URL;
230: -- Hint: Developer need to provide Where clause
231: L_API_NAME CONSTANT VARCHAR2(30) := 'Update_System_Pretty_Url';
232: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
233: -- Local Variables

Line 237: l_tar_system_pretty_url_rec AMS_System_Pretty_Url_PVT.system_pretty_url_rec_type := P_system_pretty_url_rec;

233: -- Local Variables
234: l_object_version_number NUMBER;
235: l_SYSTEM_URL_ID NUMBER;
236: l_ref_system_pretty_url_rec c_get_System_Pretty_Url%ROWTYPE ;
237: l_tar_system_pretty_url_rec AMS_System_Pretty_Url_PVT.system_pretty_url_rec_type := P_system_pretty_url_rec;
238: l_rowid ROWID;
239:
240: BEGIN
241: -- Standard Start of API savepoint

Line 324: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Update_Row)

320:
321: -- Debug Message
322: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
323:
324: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Update_Row)
325: AMS_SYSTEM_PRETTY_URL_PKG.Update_Row(
326: p_system_url_id => p_system_pretty_url_rec.system_url_id,
327: p_creation_date => SYSDATE,
328: p_created_by => G_USER_ID,

Line 325: AMS_SYSTEM_PRETTY_URL_PKG.Update_Row(

321: -- Debug Message
322: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
323:
324: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Update_Row)
325: AMS_SYSTEM_PRETTY_URL_PKG.Update_Row(
326: p_system_url_id => p_system_pretty_url_rec.system_url_id,
327: p_creation_date => SYSDATE,
328: p_created_by => G_USER_ID,
329: p_last_update_date => SYSDATE,

Line 448: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Delete_Row)

444: --
445: -- Debug Message
446: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
447:
448: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Delete_Row)
449: AMS_SYSTEM_PRETTY_URL_PKG.Delete_Row(
450: p_SYSTEM_URL_ID => p_SYSTEM_URL_ID);
451: --
452: -- End of API body

Line 449: AMS_SYSTEM_PRETTY_URL_PKG.Delete_Row(

445: -- Debug Message
446: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
447:
448: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Delete_Row)
449: AMS_SYSTEM_PRETTY_URL_PKG.Delete_Row(
450: p_SYSTEM_URL_ID => p_SYSTEM_URL_ID);
451: --
452: -- End of API body
453: --

Line 534: FROM AMS_SYSTEM_PRETTY_URL

530: l_SYSTEM_URL_ID NUMBER;
531:
532: CURSOR c_System_Pretty_Url IS
533: SELECT SYSTEM_URL_ID
534: FROM AMS_SYSTEM_PRETTY_URL
535: WHERE SYSTEM_URL_ID = p_SYSTEM_URL_ID
536: AND object_version_number = p_object_version
537: FOR UPDATE NOWAIT;
538:

Line 641: 'AMS_SYSTEM_PRETTY_URL',

637: BEGIN
638: x_return_status := FND_API.g_ret_sts_success;
639: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
640: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
641: 'AMS_SYSTEM_PRETTY_URL',
642: 'SYSTEM_URL_ID = ''' || p_system_pretty_url_rec.SYSTEM_URL_ID ||''''
643: );
644: ELSE
645: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

Line 646: 'AMS_SYSTEM_PRETTY_URL',

642: 'SYSTEM_URL_ID = ''' || p_system_pretty_url_rec.SYSTEM_URL_ID ||''''
643: );
644: ELSE
645: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
646: 'AMS_SYSTEM_PRETTY_URL',
647: 'SYSTEM_URL_ID = ''' || p_system_pretty_url_rec.SYSTEM_URL_ID ||
648: ''' AND SYSTEM_URL_ID <> ' || p_system_pretty_url_rec.SYSTEM_URL_ID
649: );
650: END IF;

Line 673: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url_id');

669: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
670:
671:
672: IF p_system_pretty_url_rec.system_url_id = FND_API.g_miss_num OR p_system_pretty_url_rec.system_url_id IS NULL THEN
673: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url_id');
674: x_return_status := FND_API.g_ret_sts_error;
675: RETURN;
676: END IF;
677:

Line 680: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_creation_date');

676: END IF;
677:
678:
679: IF p_system_pretty_url_rec.creation_date = FND_API.g_miss_date OR p_system_pretty_url_rec.creation_date IS NULL THEN
680: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_creation_date');
681: x_return_status := FND_API.g_ret_sts_error;
682: RETURN;
683: END IF;
684:

Line 687: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_created_by');

683: END IF;
684:
685:
686: IF p_system_pretty_url_rec.created_by = FND_API.g_miss_num OR p_system_pretty_url_rec.created_by IS NULL THEN
687: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_created_by');
688: x_return_status := FND_API.g_ret_sts_error;
689: RETURN;
690: END IF;
691:

Line 694: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_update_date');

690: END IF;
691:
692:
693: IF p_system_pretty_url_rec.last_update_date = FND_API.g_miss_date OR p_system_pretty_url_rec.last_update_date IS NULL THEN
694: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_update_date');
695: x_return_status := FND_API.g_ret_sts_error;
696: RETURN;
697: END IF;
698:

Line 701: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_updated_by');

697: END IF;
698:
699:
700: IF p_system_pretty_url_rec.last_updated_by = FND_API.g_miss_num OR p_system_pretty_url_rec.last_updated_by IS NULL THEN
701: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_updated_by');
702: x_return_status := FND_API.g_ret_sts_error;
703: RETURN;
704: END IF;
705:

Line 708: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_pretty_url_id');

704: END IF;
705:
706:
707: IF p_system_pretty_url_rec.pretty_url_id = FND_API.g_miss_num OR p_system_pretty_url_rec.pretty_url_id IS NULL THEN
708: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_pretty_url_id');
709: x_return_status := FND_API.g_ret_sts_error;
710: RETURN;
711: END IF;
712:

Line 715: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url');

711: END IF;
712:
713:
714: IF p_system_pretty_url_rec.system_url = FND_API.g_miss_char OR p_system_pretty_url_rec.system_url IS NULL THEN
715: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url');
716: x_return_status := FND_API.g_ret_sts_error;
717: RETURN;
718: END IF;
719: ELSE

Line 723: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url_id');

719: ELSE
720:
721:
722: IF p_system_pretty_url_rec.system_url_id IS NULL THEN
723: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url_id');
724: x_return_status := FND_API.g_ret_sts_error;
725: RETURN;
726: END IF;
727:

Line 730: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_creation_date');

726: END IF;
727:
728:
729: IF p_system_pretty_url_rec.creation_date IS NULL THEN
730: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_creation_date');
731: x_return_status := FND_API.g_ret_sts_error;
732: RETURN;
733: END IF;
734:

Line 737: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_created_by');

733: END IF;
734:
735:
736: IF p_system_pretty_url_rec.created_by IS NULL THEN
737: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_created_by');
738: x_return_status := FND_API.g_ret_sts_error;
739: RETURN;
740: END IF;
741:

Line 744: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_update_date');

740: END IF;
741:
742:
743: IF p_system_pretty_url_rec.last_update_date IS NULL THEN
744: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_update_date');
745: x_return_status := FND_API.g_ret_sts_error;
746: RETURN;
747: END IF;
748:

Line 751: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_updated_by');

747: END IF;
748:
749:
750: IF p_system_pretty_url_rec.last_updated_by IS NULL THEN
751: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_updated_by');
752: x_return_status := FND_API.g_ret_sts_error;
753: RETURN;
754: END IF;
755:

Line 758: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_pretty_url_id');

754: END IF;
755:
756:
757: IF p_system_pretty_url_rec.pretty_url_id IS NULL THEN
758: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_pretty_url_id');
759: x_return_status := FND_API.g_ret_sts_error;
760: RETURN;
761: END IF;
762:

Line 765: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url');

761: END IF;
762:
763:
764: IF p_system_pretty_url_rec.system_url IS NULL THEN
765: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url');
766: x_return_status := FND_API.g_ret_sts_error;
767: RETURN;
768: END IF;
769: END IF;

Line 852: FROM ams_system_pretty_url

848: l_return_status VARCHAR2(1);
849:
850: CURSOR c_complete IS
851: SELECT *
852: FROM ams_system_pretty_url
853: WHERE system_url_id = p_system_pretty_url_rec.system_url_id;
854: l_system_pretty_url_rec c_complete%ROWTYPE;
855: BEGIN
856: x_complete_rec := p_system_pretty_url_rec;

Line 938: l_system_pretty_url_rec AMS_System_Pretty_Url_PVT.system_pretty_url_rec_type;

934: IS
935: L_API_NAME CONSTANT VARCHAR2(30) := 'Validate_System_Pretty_Url';
936: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
937: l_object_version_number NUMBER;
938: l_system_pretty_url_rec AMS_System_Pretty_Url_PVT.system_pretty_url_rec_type;
939:
940: BEGIN
941: -- Standard Start of API savepoint
942: SAVEPOINT VALIDATE_System_Pretty_Url_;

Line 1085: END AMS_System_Pretty_Url_PVT;

1081: p_data => x_msg_data
1082: );
1083: END Validate_system_pretty_url_Rec;
1084:
1085: END AMS_System_Pretty_Url_PVT;