PACKAGE: APPS.FND_NEW_MESSAGES_PKG

Source

1 package FND_NEW_MESSAGES_PKG AUTHID CURRENT_USER as
2 /* $Header: AFMDMSGS.pls 120.3.12000000.1 2007/01/18 13:20:56 appldev ship $ */
3 /*#
4 * APIs to INSERT, UPDATE and DELETE messages into FND_NEW_MESSAGES table.
5 * @rep:scope public
6 * @rep:product FND
7 * @rep:displayname Message
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY FND_MESSAGE
11 * @rep:ihelp FND/@fndmdmsg#fndmdmsg See the related online help
12 */
13 
14   ADDN_COLS		VARCHAR2(1) := NULL; -- Backward compatability flag
15 
16 procedure CHECK_COMPATIBILITY;
17 
18 procedure ADD_LANGUAGE;
19 
20     /*#
21      * Creates or updates Message Text info in Fnd_New_Messages as appropriate.
22      * @param x_application_id Application Id to which the message belongs
23      * @param x_message_name Message Name
24      * @param x_message_number Message Number
25      * @param x_message_text Message Text
26      * @param x_description Description if any
27      * @param x_type Message Type
28      * @param x_max_length Message Text's Max Length
29      * @param x_category Message Category
30      * @param x_severity Message Severity
31      * @param x_fnd_log_severity FND's log Severity used for logging debug messages
32      * @param x_owner Owner Name
33      * @param x_custom_mode Custom Mode
34      * @param x_last_update_date Insert/Update Date
35      * @rep:scope public
36      * @rep:lifecycle active
37      * @rep:displayname Create/Update Message Text
38      * @rep:compatibility S
39      * @rep:ihelp FND/@fndmdmsg#fndmdmsg See the related online help
40      */
41 procedure LOAD_ROW (
42   X_APPLICATION_ID in NUMBER,
43   X_MESSAGE_NAME in VARCHAR2,
44   X_MESSAGE_NUMBER in VARCHAR2,
45   X_MESSAGE_TEXT in VARCHAR2,
46   X_DESCRIPTION in VARCHAR2,
47   X_TYPE in VARCHAR2,
48   X_MAX_LENGTH in VARCHAR2,
49   X_CATEGORY in VARCHAR2,
50   X_SEVERITY in VARCHAR2,
51   X_FND_LOG_SEVERITY in VARCHAR2,
52   X_OWNER in VARCHAR2,
53   X_CUSTOM_MODE in VARCHAR2,
54   X_LAST_UPDATE_DATE in VARCHAR2
55 );
56 
57 procedure TRANSLATE_ROW (
58   X_APPLICATION_ID in NUMBER,
59   X_MESSAGE_NAME in VARCHAR2,
60   X_MESSAGE_TEXT in VARCHAR2,
61   X_OWNER in VARCHAR2,
62   X_CUSTOM_MODE in VARCHAR2,
63   X_LAST_UPDATE_DATE in VARCHAR2
64 );
65 
66     /*#
67      * Deletes Message from Fnd_New_Messages for a given language.
68      * @param x_application_id Application Id to which the message belongs
69      * @param x_message_name Message Name
70      * @param x_language_code Language Code
71      * @rep:scope public
72      * @rep:lifecycle active
73      * @rep:displayname Delete Message record
74      * @rep:compatibility S
75      * @rep:ihelp FND/@fndmdmsg#fndmdmsg See the related online help
76      */
77 procedure DELETE_ROW (
78   X_APPLICATION_ID in NUMBER,
79   X_LANGUAGE_CODE in VARCHAR2,
80   X_MESSAGE_NAME in VARCHAR2
81 );
82 
83 procedure CHECK_MESSAGE_TYPE (
84  X_MESSAGE_NAME in VARCHAR2,
85  X_TYPE in VARCHAR2
86  );
87 
88 procedure CHECK_MESSAGE_DESCRIPTION (
89  X_MESSAGE_NAME in VARCHAR2,
90  X_TYPE in VARCHAR2,
91  X_DESCRIPTION in VARCHAR2
92  );
93 
94 procedure CHECK_MAX_LENGTH_TYPE (
95  X_MESSAGE_NAME in VARCHAR2,
96  X_TYPE in VARCHAR2,
97  X_MAX_LENGTH in NUMBER
98  );
99 
100 /* OverLoaded Version Below */
101 procedure CHECK_MAX_LEN_MSG_LEN (
102  X_MESSAGE_NAME in VARCHAR2,
103  X_MESSAGE_TEXT in VARCHAR2,
104  X_MAX_LENGTH in NUMBER
105  );
106 
107 procedure CHECK_TOKENS_ACCESS_KEYS (
108  X_MESSAGE_NAME in VARCHAR2,
109  X_MESSAGE_TEXT in VARCHAR2
110  );
111 
112 /* OverLoaded Version Below */
113 procedure CHECK_TYPE_RULES (
114  X_MESSAGE_NAME in VARCHAR2,
115  X_TYPE in VARCHAR2,
116  X_MESSAGE_TEXT in VARCHAR2
117  );
118 
119 procedure CHECK_MAXIMUM_LENGTH_RANGE (
120   X_MAX_LENGTH in NUMBER,
121   X_MESSAGE_NAME in VARCHAR2
122 );
123 
124 procedure CHECK_CATEGORY_SEVERITY (
125   X_CATEGORY in VARCHAR2,
126   X_SEVERITY in VARCHAR2,
127   X_FND_LOG_SEVERITY in NUMBER,
128   X_MESSAGE_NAME in VARCHAR2
129 );
130 
131 
132 /* OverLoaded Version Above */
133 procedure CHECK_MAX_LEN_MSG_LEN (
134  X_MESSAGE_NAME in VARCHAR2,
135  X_MESSAGE_TEXT in VARCHAR2,
136  X_MAX_LENGTH in NUMBER,
137  X_VALIDATION in VARCHAR2
138  );
139 
140 /* OverLoaded Version Above */
141 procedure CHECK_TYPE_RULES (
142  X_MESSAGE_NAME in VARCHAR2,
143  X_TYPE in VARCHAR2,
144  X_MESSAGE_TEXT in VARCHAR2,
145  X_VALIDATION  in VARCHAR2
146  );
147 
148 end FND_NEW_MESSAGES_PKG;