PACKAGE BODY: APPS.PRP_MIGRATION_PVT

Source

1 PACKAGE BODY PRP_MIGRATION_PVT as
2 /* $Header: PRPVMIGB.pls 115.0 2003/04/30 01:37:44 vpalaiya noship $ */
3 
4   -- Start of Comments
5   --
6   -- Package name     : PRP_MIGRATION_PVT
7   --
8   -- Purpose          : This package will be used to insert the data in all
9   --                    PRP migration scripts.
10   -- History          :
11   --
12   -- NOTE             : Data will be inserted in PRP_MIGRATION_LOGS table.
13   --
14   -- End of Comments
15 
16 G_PKG_NAME  CONSTANT VARCHAR2(30):='PRP_MIGRATION_PVT';
17 G_FILE_NAME CONSTANT VARCHAR2(12):='PRPVMIGB.pls';
18 
19 PROCEDURE Log_Message
20   (
21    p_api_version                    IN NUMBER,
22    p_init_msg_list                  IN VARCHAR2 := FND_API.G_FALSE,
23    p_commit                         IN VARCHAR2 := FND_API.G_FALSE,
24    p_validation_level               IN NUMBER   := FND_API.G_VALID_LEVEL_FULL,
25    p_module_name                    IN VARCHAR2,
26    p_log_level                      IN VARCHAR2,
27    p_message_text                   IN VARCHAR2,
28    p_migration_code                 IN VARCHAR2,
29    p_created_by                     IN NUMBER,
30    p_creation_date                  IN DATE,
31    p_last_updated_by                IN NUMBER,
32    p_last_update_date               IN DATE,
33    p_last_update_login              IN NUMBER
34   )
35 IS
36   PRAGMA AUTONOMOUS_TRANSACTION;
37 BEGIN
38 
39   INSERT INTO prp_migration_logs
40     (
41     migration_log_id,
42     object_version_number,
43     module_name,
44     log_level,
45     message_text,
46     migration_code,
47     created_by,
48     creation_date,
49     last_updated_by,
50     last_update_date,
51     last_update_login
52     )
53     VALUES
54     (
55     prp_migration_logs_s1.nextval,
56     1,
57     p_module_name,
58     p_log_level,
59     p_message_text,
60     p_migration_code,
61     p_created_by,
62     p_creation_date,
63     p_last_updated_by,
64     p_last_update_date,
65     p_last_update_login
66     );
67 
68   COMMIT;
69 
70 EXCEPTION
71 
72    WHEN OTHERS THEN
73      RAISE;
74 
75 END;
76 
77 END PRP_MIGRATION_PVT;