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.

[Home] [Help]

APPS.AME_UTILITY_PKG dependencies on FND_MESSAGE

Line 80: fnd_message.set_name('PER','AME_400629_EMPTY_QUERY_STRING');

76: return 'Y';
77: end if;
78: /* Query String Cannot be null */
79: if p_query_string is null then
80: fnd_message.set_name('PER','AME_400629_EMPTY_QUERY_STRING');
81: return fnd_message.get;
82: end if;
83:
84: /* Remove any new lines and replace with spaces */

Line 81: return fnd_message.get;

77: end if;
78: /* Query String Cannot be null */
79: if p_query_string is null then
80: fnd_message.set_name('PER','AME_400629_EMPTY_QUERY_STRING');
81: return fnd_message.get;
82: end if;
83:
84: /* Remove any new lines and replace with spaces */
85: temp_query_string := ' ' || replace(replace(replace(p_query_string,

Line 97: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

93: /* Following commands are not SQL queries */
94: /* insert,update,delete,commit,rollback */
95: /* truncate,drop,grant,execute,locl,alter */
96: if instr(lower(temp_query_string),' insert ',1,1) > 0 then
97: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
98: fnd_message.set_token('KEYWORD','INSERT');
99: return fnd_message.get;
100: end if;
101: if instr(lower(temp_query_string),' update ',1,1) > 0 then

Line 98: fnd_message.set_token('KEYWORD','INSERT');

94: /* insert,update,delete,commit,rollback */
95: /* truncate,drop,grant,execute,locl,alter */
96: if instr(lower(temp_query_string),' insert ',1,1) > 0 then
97: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
98: fnd_message.set_token('KEYWORD','INSERT');
99: return fnd_message.get;
100: end if;
101: if instr(lower(temp_query_string),' update ',1,1) > 0 then
102: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

Line 99: return fnd_message.get;

95: /* truncate,drop,grant,execute,locl,alter */
96: if instr(lower(temp_query_string),' insert ',1,1) > 0 then
97: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
98: fnd_message.set_token('KEYWORD','INSERT');
99: return fnd_message.get;
100: end if;
101: if instr(lower(temp_query_string),' update ',1,1) > 0 then
102: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
103: fnd_message.set_token('KEYWORD','UPDATE');

Line 102: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

98: fnd_message.set_token('KEYWORD','INSERT');
99: return fnd_message.get;
100: end if;
101: if instr(lower(temp_query_string),' update ',1,1) > 0 then
102: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
103: fnd_message.set_token('KEYWORD','UPDATE');
104: return fnd_message.get;
105: end if;
106: if instr(lower(temp_query_string),' delete ',1,1) > 0 then

Line 103: fnd_message.set_token('KEYWORD','UPDATE');

99: return fnd_message.get;
100: end if;
101: if instr(lower(temp_query_string),' update ',1,1) > 0 then
102: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
103: fnd_message.set_token('KEYWORD','UPDATE');
104: return fnd_message.get;
105: end if;
106: if instr(lower(temp_query_string),' delete ',1,1) > 0 then
107: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

Line 104: return fnd_message.get;

100: end if;
101: if instr(lower(temp_query_string),' update ',1,1) > 0 then
102: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
103: fnd_message.set_token('KEYWORD','UPDATE');
104: return fnd_message.get;
105: end if;
106: if instr(lower(temp_query_string),' delete ',1,1) > 0 then
107: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
108: fnd_message.set_token('KEYWORD','DELETE');

Line 107: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

103: fnd_message.set_token('KEYWORD','UPDATE');
104: return fnd_message.get;
105: end if;
106: if instr(lower(temp_query_string),' delete ',1,1) > 0 then
107: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
108: fnd_message.set_token('KEYWORD','DELETE');
109: return fnd_message.get;
110: end if;
111: if instr(lower(temp_query_string),' commit ',1,1) > 0 then

Line 108: fnd_message.set_token('KEYWORD','DELETE');

104: return fnd_message.get;
105: end if;
106: if instr(lower(temp_query_string),' delete ',1,1) > 0 then
107: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
108: fnd_message.set_token('KEYWORD','DELETE');
109: return fnd_message.get;
110: end if;
111: if instr(lower(temp_query_string),' commit ',1,1) > 0 then
112: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

Line 109: return fnd_message.get;

105: end if;
106: if instr(lower(temp_query_string),' delete ',1,1) > 0 then
107: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
108: fnd_message.set_token('KEYWORD','DELETE');
109: return fnd_message.get;
110: end if;
111: if instr(lower(temp_query_string),' commit ',1,1) > 0 then
112: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
113: fnd_message.set_token('KEYWORD','COMMIT');

Line 112: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

108: fnd_message.set_token('KEYWORD','DELETE');
109: return fnd_message.get;
110: end if;
111: if instr(lower(temp_query_string),' commit ',1,1) > 0 then
112: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
113: fnd_message.set_token('KEYWORD','COMMIT');
114: return fnd_message.get;
115: end if;
116: if instr(lower(temp_query_string),' rollback ',1,1) > 0 then

Line 113: fnd_message.set_token('KEYWORD','COMMIT');

109: return fnd_message.get;
110: end if;
111: if instr(lower(temp_query_string),' commit ',1,1) > 0 then
112: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
113: fnd_message.set_token('KEYWORD','COMMIT');
114: return fnd_message.get;
115: end if;
116: if instr(lower(temp_query_string),' rollback ',1,1) > 0 then
117: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

Line 114: return fnd_message.get;

110: end if;
111: if instr(lower(temp_query_string),' commit ',1,1) > 0 then
112: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
113: fnd_message.set_token('KEYWORD','COMMIT');
114: return fnd_message.get;
115: end if;
116: if instr(lower(temp_query_string),' rollback ',1,1) > 0 then
117: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
118: fnd_message.set_token('KEYWORD','ROLLBACK');

Line 117: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

113: fnd_message.set_token('KEYWORD','COMMIT');
114: return fnd_message.get;
115: end if;
116: if instr(lower(temp_query_string),' rollback ',1,1) > 0 then
117: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
118: fnd_message.set_token('KEYWORD','ROLLBACK');
119: return fnd_message.get;
120: end if;
121: if instr(lower(temp_query_string),' truncate ',1,1) > 0 then

Line 118: fnd_message.set_token('KEYWORD','ROLLBACK');

114: return fnd_message.get;
115: end if;
116: if instr(lower(temp_query_string),' rollback ',1,1) > 0 then
117: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
118: fnd_message.set_token('KEYWORD','ROLLBACK');
119: return fnd_message.get;
120: end if;
121: if instr(lower(temp_query_string),' truncate ',1,1) > 0 then
122: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

Line 119: return fnd_message.get;

115: end if;
116: if instr(lower(temp_query_string),' rollback ',1,1) > 0 then
117: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
118: fnd_message.set_token('KEYWORD','ROLLBACK');
119: return fnd_message.get;
120: end if;
121: if instr(lower(temp_query_string),' truncate ',1,1) > 0 then
122: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
123: fnd_message.set_token('KEYWORD','TRUNCATE');

Line 122: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

118: fnd_message.set_token('KEYWORD','ROLLBACK');
119: return fnd_message.get;
120: end if;
121: if instr(lower(temp_query_string),' truncate ',1,1) > 0 then
122: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
123: fnd_message.set_token('KEYWORD','TRUNCATE');
124: return fnd_message.get;
125: end if;
126: if instr(lower(temp_query_string),' drop ',1,1) > 0 then

Line 123: fnd_message.set_token('KEYWORD','TRUNCATE');

119: return fnd_message.get;
120: end if;
121: if instr(lower(temp_query_string),' truncate ',1,1) > 0 then
122: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
123: fnd_message.set_token('KEYWORD','TRUNCATE');
124: return fnd_message.get;
125: end if;
126: if instr(lower(temp_query_string),' drop ',1,1) > 0 then
127: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

Line 124: return fnd_message.get;

120: end if;
121: if instr(lower(temp_query_string),' truncate ',1,1) > 0 then
122: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
123: fnd_message.set_token('KEYWORD','TRUNCATE');
124: return fnd_message.get;
125: end if;
126: if instr(lower(temp_query_string),' drop ',1,1) > 0 then
127: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
128: fnd_message.set_token('KEYWORD','DROP');

Line 127: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

123: fnd_message.set_token('KEYWORD','TRUNCATE');
124: return fnd_message.get;
125: end if;
126: if instr(lower(temp_query_string),' drop ',1,1) > 0 then
127: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
128: fnd_message.set_token('KEYWORD','DROP');
129: return fnd_message.get;
130: end if;
131: if instr(lower(temp_query_string),' grant ',1,1) > 0 then

Line 128: fnd_message.set_token('KEYWORD','DROP');

124: return fnd_message.get;
125: end if;
126: if instr(lower(temp_query_string),' drop ',1,1) > 0 then
127: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
128: fnd_message.set_token('KEYWORD','DROP');
129: return fnd_message.get;
130: end if;
131: if instr(lower(temp_query_string),' grant ',1,1) > 0 then
132: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

Line 129: return fnd_message.get;

125: end if;
126: if instr(lower(temp_query_string),' drop ',1,1) > 0 then
127: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
128: fnd_message.set_token('KEYWORD','DROP');
129: return fnd_message.get;
130: end if;
131: if instr(lower(temp_query_string),' grant ',1,1) > 0 then
132: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
133: fnd_message.set_token('KEYWORD','GRANT');

Line 132: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

128: fnd_message.set_token('KEYWORD','DROP');
129: return fnd_message.get;
130: end if;
131: if instr(lower(temp_query_string),' grant ',1,1) > 0 then
132: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
133: fnd_message.set_token('KEYWORD','GRANT');
134: return fnd_message.get;
135: end if;
136: if instr(lower(temp_query_string),'execute ',1,1) > 0 then

Line 133: fnd_message.set_token('KEYWORD','GRANT');

129: return fnd_message.get;
130: end if;
131: if instr(lower(temp_query_string),' grant ',1,1) > 0 then
132: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
133: fnd_message.set_token('KEYWORD','GRANT');
134: return fnd_message.get;
135: end if;
136: if instr(lower(temp_query_string),'execute ',1,1) > 0 then
137: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

Line 134: return fnd_message.get;

130: end if;
131: if instr(lower(temp_query_string),' grant ',1,1) > 0 then
132: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
133: fnd_message.set_token('KEYWORD','GRANT');
134: return fnd_message.get;
135: end if;
136: if instr(lower(temp_query_string),'execute ',1,1) > 0 then
137: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
138: fnd_message.set_token('KEYWORD','EXECUTE');

Line 137: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

133: fnd_message.set_token('KEYWORD','GRANT');
134: return fnd_message.get;
135: end if;
136: if instr(lower(temp_query_string),'execute ',1,1) > 0 then
137: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
138: fnd_message.set_token('KEYWORD','EXECUTE');
139: return fnd_message.get;
140: end if;
141: if instr(lower(temp_query_string),' lock ',1,1) > 0 then

Line 138: fnd_message.set_token('KEYWORD','EXECUTE');

134: return fnd_message.get;
135: end if;
136: if instr(lower(temp_query_string),'execute ',1,1) > 0 then
137: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
138: fnd_message.set_token('KEYWORD','EXECUTE');
139: return fnd_message.get;
140: end if;
141: if instr(lower(temp_query_string),' lock ',1,1) > 0 then
142: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

Line 139: return fnd_message.get;

135: end if;
136: if instr(lower(temp_query_string),'execute ',1,1) > 0 then
137: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
138: fnd_message.set_token('KEYWORD','EXECUTE');
139: return fnd_message.get;
140: end if;
141: if instr(lower(temp_query_string),' lock ',1,1) > 0 then
142: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
143: fnd_message.set_token('KEYWORD','LOCK');

Line 142: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

138: fnd_message.set_token('KEYWORD','EXECUTE');
139: return fnd_message.get;
140: end if;
141: if instr(lower(temp_query_string),' lock ',1,1) > 0 then
142: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
143: fnd_message.set_token('KEYWORD','LOCK');
144: return fnd_message.get;
145: end if;
146: if instr(lower(temp_query_string),' alter ',1,1) > 0 then

Line 143: fnd_message.set_token('KEYWORD','LOCK');

139: return fnd_message.get;
140: end if;
141: if instr(lower(temp_query_string),' lock ',1,1) > 0 then
142: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
143: fnd_message.set_token('KEYWORD','LOCK');
144: return fnd_message.get;
145: end if;
146: if instr(lower(temp_query_string),' alter ',1,1) > 0 then
147: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

Line 144: return fnd_message.get;

140: end if;
141: if instr(lower(temp_query_string),' lock ',1,1) > 0 then
142: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
143: fnd_message.set_token('KEYWORD','LOCK');
144: return fnd_message.get;
145: end if;
146: if instr(lower(temp_query_string),' alter ',1,1) > 0 then
147: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
148: fnd_message.set_token('KEYWORD','ALTER');

Line 147: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');

143: fnd_message.set_token('KEYWORD','LOCK');
144: return fnd_message.get;
145: end if;
146: if instr(lower(temp_query_string),' alter ',1,1) > 0 then
147: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
148: fnd_message.set_token('KEYWORD','ALTER');
149: return fnd_message.get;
150: end if;
151:

Line 148: fnd_message.set_token('KEYWORD','ALTER');

144: return fnd_message.get;
145: end if;
146: if instr(lower(temp_query_string),' alter ',1,1) > 0 then
147: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
148: fnd_message.set_token('KEYWORD','ALTER');
149: return fnd_message.get;
150: end if;
151:
152: /* Comments and semicolons are not allowed */

Line 149: return fnd_message.get;

145: end if;
146: if instr(lower(temp_query_string),' alter ',1,1) > 0 then
147: fnd_message.set_name('PER','AME_400630_PROHIBITED_KEYWORD');
148: fnd_message.set_token('KEYWORD','ALTER');
149: return fnd_message.get;
150: end if;
151:
152: /* Comments and semicolons are not allowed */
153: if instr(lower(temp_query_string),';',1,1) > 0 then

Line 154: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');

150: end if;
151:
152: /* Comments and semicolons are not allowed */
153: if instr(lower(temp_query_string),';',1,1) > 0 then
154: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
155: return fnd_message.get;
156: end if;
157: if instr(lower(temp_query_string),'/*',1,1) > 0 then
158: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');

Line 155: return fnd_message.get;

151:
152: /* Comments and semicolons are not allowed */
153: if instr(lower(temp_query_string),';',1,1) > 0 then
154: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
155: return fnd_message.get;
156: end if;
157: if instr(lower(temp_query_string),'/*',1,1) > 0 then
158: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
159: return fnd_message.get;

Line 158: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');

154: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
155: return fnd_message.get;
156: end if;
157: if instr(lower(temp_query_string),'/*',1,1) > 0 then
158: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
159: return fnd_message.get;
160: end if;
161: if instr(lower(temp_query_string),'*/',1,1) > 0 then
162: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');

Line 159: return fnd_message.get;

155: return fnd_message.get;
156: end if;
157: if instr(lower(temp_query_string),'/*',1,1) > 0 then
158: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
159: return fnd_message.get;
160: end if;
161: if instr(lower(temp_query_string),'*/',1,1) > 0 then
162: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
163: return fnd_message.get;

Line 162: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');

158: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
159: return fnd_message.get;
160: end if;
161: if instr(lower(temp_query_string),'*/',1,1) > 0 then
162: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
163: return fnd_message.get;
164: end if;
165: if instr(lower(temp_query_string),'--',1,1) > 0 then
166: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');

Line 163: return fnd_message.get;

159: return fnd_message.get;
160: end if;
161: if instr(lower(temp_query_string),'*/',1,1) > 0 then
162: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
163: return fnd_message.get;
164: end if;
165: if instr(lower(temp_query_string),'--',1,1) > 0 then
166: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
167: return fnd_message.get;

Line 166: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');

162: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
163: return fnd_message.get;
164: end if;
165: if instr(lower(temp_query_string),'--',1,1) > 0 then
166: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
167: return fnd_message.get;
168: end if;
169:
170: /* References to following packages is forbidden */

Line 167: return fnd_message.get;

163: return fnd_message.get;
164: end if;
165: if instr(lower(temp_query_string),'--',1,1) > 0 then
166: fnd_message.set_name('PER','AME_400165_ATT_DYN_USG_COMM');
167: return fnd_message.get;
168: end if;
169:
170: /* References to following packages is forbidden */
171: if instr(lower(temp_query_string),'dbms_output.',1,1) > 0 then

Line 172: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');

168: end if;
169:
170: /* References to following packages is forbidden */
171: if instr(lower(temp_query_string),'dbms_output.',1,1) > 0 then
172: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
173: fnd_message.set_token('PACKAGE','DBMS_OUTPUT');
174: return fnd_message.get;
175: end if;
176: if instr(lower(temp_query_string),'dbms_sql.',1,1) > 0 then

Line 173: fnd_message.set_token('PACKAGE','DBMS_OUTPUT');

169:
170: /* References to following packages is forbidden */
171: if instr(lower(temp_query_string),'dbms_output.',1,1) > 0 then
172: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
173: fnd_message.set_token('PACKAGE','DBMS_OUTPUT');
174: return fnd_message.get;
175: end if;
176: if instr(lower(temp_query_string),'dbms_sql.',1,1) > 0 then
177: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');

Line 174: return fnd_message.get;

170: /* References to following packages is forbidden */
171: if instr(lower(temp_query_string),'dbms_output.',1,1) > 0 then
172: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
173: fnd_message.set_token('PACKAGE','DBMS_OUTPUT');
174: return fnd_message.get;
175: end if;
176: if instr(lower(temp_query_string),'dbms_sql.',1,1) > 0 then
177: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
178: fnd_message.set_token('PACKAGE','DBMS_SQL');

Line 177: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');

173: fnd_message.set_token('PACKAGE','DBMS_OUTPUT');
174: return fnd_message.get;
175: end if;
176: if instr(lower(temp_query_string),'dbms_sql.',1,1) > 0 then
177: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
178: fnd_message.set_token('PACKAGE','DBMS_SQL');
179: return fnd_message.get;
180: end if;
181: if instr(lower(temp_query_string),'ht'||'f.',1,1) > 0 then

Line 178: fnd_message.set_token('PACKAGE','DBMS_SQL');

174: return fnd_message.get;
175: end if;
176: if instr(lower(temp_query_string),'dbms_sql.',1,1) > 0 then
177: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
178: fnd_message.set_token('PACKAGE','DBMS_SQL');
179: return fnd_message.get;
180: end if;
181: if instr(lower(temp_query_string),'ht'||'f.',1,1) > 0 then
182: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');

Line 179: return fnd_message.get;

175: end if;
176: if instr(lower(temp_query_string),'dbms_sql.',1,1) > 0 then
177: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
178: fnd_message.set_token('PACKAGE','DBMS_SQL');
179: return fnd_message.get;
180: end if;
181: if instr(lower(temp_query_string),'ht'||'f.',1,1) > 0 then
182: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
183: fnd_message.set_token('PACKAGE','HTF');

Line 182: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');

178: fnd_message.set_token('PACKAGE','DBMS_SQL');
179: return fnd_message.get;
180: end if;
181: if instr(lower(temp_query_string),'ht'||'f.',1,1) > 0 then
182: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
183: fnd_message.set_token('PACKAGE','HTF');
184: return fnd_message.get;
185: end if;
186: if instr(lower(temp_query_string),'ht'||'p.',1,1) > 0 then

Line 183: fnd_message.set_token('PACKAGE','HTF');

179: return fnd_message.get;
180: end if;
181: if instr(lower(temp_query_string),'ht'||'f.',1,1) > 0 then
182: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
183: fnd_message.set_token('PACKAGE','HTF');
184: return fnd_message.get;
185: end if;
186: if instr(lower(temp_query_string),'ht'||'p.',1,1) > 0 then
187: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');

Line 184: return fnd_message.get;

180: end if;
181: if instr(lower(temp_query_string),'ht'||'f.',1,1) > 0 then
182: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
183: fnd_message.set_token('PACKAGE','HTF');
184: return fnd_message.get;
185: end if;
186: if instr(lower(temp_query_string),'ht'||'p.',1,1) > 0 then
187: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
188: fnd_message.set_token('PACKAGE','HTP');

Line 187: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');

183: fnd_message.set_token('PACKAGE','HTF');
184: return fnd_message.get;
185: end if;
186: if instr(lower(temp_query_string),'ht'||'p.',1,1) > 0 then
187: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
188: fnd_message.set_token('PACKAGE','HTP');
189: return fnd_message.get;
190: end if;
191: if instr(lower(temp_query_string),'owa_util.',1,1) > 0 then

Line 188: fnd_message.set_token('PACKAGE','HTP');

184: return fnd_message.get;
185: end if;
186: if instr(lower(temp_query_string),'ht'||'p.',1,1) > 0 then
187: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
188: fnd_message.set_token('PACKAGE','HTP');
189: return fnd_message.get;
190: end if;
191: if instr(lower(temp_query_string),'owa_util.',1,1) > 0 then
192: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');

Line 189: return fnd_message.get;

185: end if;
186: if instr(lower(temp_query_string),'ht'||'p.',1,1) > 0 then
187: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
188: fnd_message.set_token('PACKAGE','HTP');
189: return fnd_message.get;
190: end if;
191: if instr(lower(temp_query_string),'owa_util.',1,1) > 0 then
192: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
193: fnd_message.set_token('PACKAGE','OWA_UTIL');

Line 192: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');

188: fnd_message.set_token('PACKAGE','HTP');
189: return fnd_message.get;
190: end if;
191: if instr(lower(temp_query_string),'owa_util.',1,1) > 0 then
192: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
193: fnd_message.set_token('PACKAGE','OWA_UTIL');
194: return fnd_message.get;
195: end if;
196: if instr(lower(temp_query_string),'owa_cookie.',1,1) > 0 then

Line 193: fnd_message.set_token('PACKAGE','OWA_UTIL');

189: return fnd_message.get;
190: end if;
191: if instr(lower(temp_query_string),'owa_util.',1,1) > 0 then
192: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
193: fnd_message.set_token('PACKAGE','OWA_UTIL');
194: return fnd_message.get;
195: end if;
196: if instr(lower(temp_query_string),'owa_cookie.',1,1) > 0 then
197: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG ');

Line 194: return fnd_message.get;

190: end if;
191: if instr(lower(temp_query_string),'owa_util.',1,1) > 0 then
192: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG');
193: fnd_message.set_token('PACKAGE','OWA_UTIL');
194: return fnd_message.get;
195: end if;
196: if instr(lower(temp_query_string),'owa_cookie.',1,1) > 0 then
197: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG ');
198: fnd_message.set_token('PACKAGE','OWA_COOKIE');

Line 197: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG ');

193: fnd_message.set_token('PACKAGE','OWA_UTIL');
194: return fnd_message.get;
195: end if;
196: if instr(lower(temp_query_string),'owa_cookie.',1,1) > 0 then
197: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG ');
198: fnd_message.set_token('PACKAGE','OWA_COOKIE');
199: return fnd_message.get;
200: end if;
201:

Line 198: fnd_message.set_token('PACKAGE','OWA_COOKIE');

194: return fnd_message.get;
195: end if;
196: if instr(lower(temp_query_string),'owa_cookie.',1,1) > 0 then
197: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG ');
198: fnd_message.set_token('PACKAGE','OWA_COOKIE');
199: return fnd_message.get;
200: end if;
201:
202: --Check for valid bind variable for the module

Line 199: return fnd_message.get;

195: end if;
196: if instr(lower(temp_query_string),'owa_cookie.',1,1) > 0 then
197: fnd_message.set_name('PER','AME_400625_PROHIBITED_PKG ');
198: fnd_message.set_token('PACKAGE','OWA_COOKIE');
199: return fnd_message.get;
200: end if;
201:
202: --Check for valid bind variable for the module
203: if(p_object is not null) then

Line 222: fnd_message.set_name('PER', 'AME_400794_INV_ATR_BIND_VAR');

218: );
219: exception
220: when others then
221: if (p_object = ame_util2.attributeObject) then
222: fnd_message.set_name('PER', 'AME_400794_INV_ATR_BIND_VAR');
223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');

Line 224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');

220: when others then
221: if (p_object = ame_util2.attributeObject) then
222: fnd_message.set_name('PER', 'AME_400794_INV_ATR_BIND_VAR');
223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then
228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');

Line 226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');

222: fnd_message.set_name('PER', 'AME_400794_INV_ATR_BIND_VAR');
223: elsif p_object = ame_util2.specialObject then
224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then
228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');
229: elsif p_object = ame_util2.approverGroupObject then
230: fnd_message.set_name('PER', 'AME_400797_INV_APG_BIND_VAR');

Line 228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');

224: fnd_message.set_name('PER', 'AME_400799_INV_VATR_BIND_VAR');
225: elsif p_object = ame_util2.itemClassObject then
226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then
228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');
229: elsif p_object = ame_util2.approverGroupObject then
230: fnd_message.set_name('PER', 'AME_400797_INV_APG_BIND_VAR');
231: end if;
232: return fnd_message.get;

Line 230: fnd_message.set_name('PER', 'AME_400797_INV_APG_BIND_VAR');

226: fnd_message.set_name('PER', 'AME_400795_INV_ITU_BIND_VAR');
227: elsif p_object = ame_util2.actionTypeObject then
228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');
229: elsif p_object = ame_util2.approverGroupObject then
230: fnd_message.set_name('PER', 'AME_400797_INV_APG_BIND_VAR');
231: end if;
232: return fnd_message.get;
233: end;
234: end if;

Line 232: return fnd_message.get;

228: fnd_message.set_name('PER', 'AME_400796_INV_ATY_BIND_VAR');
229: elsif p_object = ame_util2.approverGroupObject then
230: fnd_message.set_name('PER', 'AME_400797_INV_APG_BIND_VAR');
231: end if;
232: return fnd_message.get;
233: end;
234: end if;
235: query_cursor := dbms_sql.open_cursor;
236:

Line 253: fnd_message.set_name('PER','AME_400626_INVALID_NUM_COLS');

249: begin
250: dbms_sql.define_column(query_cursor,p_columns + 1,columnb,100);
251: dbms_sql.close_cursor(query_cursor);
252: if p_columns > 1 then
253: fnd_message.set_name('PER','AME_400626_INVALID_NUM_COLS');
254: fnd_message.set_token('NUMCOLS',p_columns);
255: else
256: fnd_message.set_name('PER','AME_400628_INVALID_SINGLE_COL');
257: end if;

Line 254: fnd_message.set_token('NUMCOLS',p_columns);

250: dbms_sql.define_column(query_cursor,p_columns + 1,columnb,100);
251: dbms_sql.close_cursor(query_cursor);
252: if p_columns > 1 then
253: fnd_message.set_name('PER','AME_400626_INVALID_NUM_COLS');
254: fnd_message.set_token('NUMCOLS',p_columns);
255: else
256: fnd_message.set_name('PER','AME_400628_INVALID_SINGLE_COL');
257: end if;
258: return fnd_message.get;

Line 256: fnd_message.set_name('PER','AME_400628_INVALID_SINGLE_COL');

252: if p_columns > 1 then
253: fnd_message.set_name('PER','AME_400626_INVALID_NUM_COLS');
254: fnd_message.set_token('NUMCOLS',p_columns);
255: else
256: fnd_message.set_name('PER','AME_400628_INVALID_SINGLE_COL');
257: end if;
258: return fnd_message.get;
259: exception
260: when others then

Line 258: return fnd_message.get;

254: fnd_message.set_token('NUMCOLS',p_columns);
255: else
256: fnd_message.set_name('PER','AME_400628_INVALID_SINGLE_COL');
257: end if;
258: return fnd_message.get;
259: exception
260: when others then
261: dbms_sql.close_cursor(query_cursor);
262: return 'Y';

Line 268: fnd_message.set_name('PER','AME_400626_INVALID_NUM_COLS');

264: exception
265: when others then
266: dbms_sql.close_cursor(query_cursor);
267: if p_columns > 1 then
268: fnd_message.set_name('PER','AME_400626_INVALID_NUM_COLS');
269: fnd_message.set_token('NUMCOLS',p_columns);
270: else
271: fnd_message.set_name('PER','AME_400628_INVALID_SINGLE_COL');
272: end if;

Line 269: fnd_message.set_token('NUMCOLS',p_columns);

265: when others then
266: dbms_sql.close_cursor(query_cursor);
267: if p_columns > 1 then
268: fnd_message.set_name('PER','AME_400626_INVALID_NUM_COLS');
269: fnd_message.set_token('NUMCOLS',p_columns);
270: else
271: fnd_message.set_name('PER','AME_400628_INVALID_SINGLE_COL');
272: end if;
273: return fnd_message.get;

Line 271: fnd_message.set_name('PER','AME_400628_INVALID_SINGLE_COL');

267: if p_columns > 1 then
268: fnd_message.set_name('PER','AME_400626_INVALID_NUM_COLS');
269: fnd_message.set_token('NUMCOLS',p_columns);
270: else
271: fnd_message.set_name('PER','AME_400628_INVALID_SINGLE_COL');
272: end if;
273: return fnd_message.get;
274: end;
275: end if;

Line 273: return fnd_message.get;

269: fnd_message.set_token('NUMCOLS',p_columns);
270: else
271: fnd_message.set_name('PER','AME_400628_INVALID_SINGLE_COL');
272: end if;
273: return fnd_message.get;
274: end;
275: end if;
276: exception
277:

Line 280: fnd_message.set_name('PER','AME_400627_QUERY_SQL_INVALID');

276: exception
277:
278: when others then
279: dbms_sql.close_cursor(query_cursor);
280: fnd_message.set_name('PER','AME_400627_QUERY_SQL_INVALID');
281: error_string := sqlerrm;
282: if instrb(error_string,':',1,1) > 0 then
283: error_string := substrb(error_string,instrb(error_string,':',1,1) + 2);
284: end if;

Line 285: fnd_message.set_token('EXPSTRING',error_string);

281: error_string := sqlerrm;
282: if instrb(error_string,':',1,1) > 0 then
283: error_string := substrb(error_string,instrb(error_string,':',1,1) + 2);
284: end if;
285: fnd_message.set_token('EXPSTRING',error_string);
286: return fnd_message.get;
287: end validate_query;
288:
289: function get_action_description(p_action_id in number

Line 286: return fnd_message.get;

282: if instrb(error_string,':',1,1) > 0 then
283: error_string := substrb(error_string,instrb(error_string,':',1,1) + 2);
284: end if;
285: fnd_message.set_token('EXPSTRING',error_string);
286: return fnd_message.get;
287: end validate_query;
288:
289: function get_action_description(p_action_id in number
290: ,p_effective_date in date default sysdate) return varchar2 is

Line 369: fnd_message.set_name('PER','AME_400636_INV_DYN_ACT_DESC');

365: dbms_sql.close_cursor(query_cursor);
366: return action_description;
367: exception
368: when others then
369: fnd_message.set_name('PER','AME_400636_INV_DYN_ACT_DESC');
370: fnd_message.set_token('PARAMETER_ONE',l_parameter_one);
371: fnd_message.set_token('PARAMETER_TWO',l_parameter_two);
372: return fnd_message.get;
373: end;

Line 370: fnd_message.set_token('PARAMETER_ONE',l_parameter_one);

366: return action_description;
367: exception
368: when others then
369: fnd_message.set_name('PER','AME_400636_INV_DYN_ACT_DESC');
370: fnd_message.set_token('PARAMETER_ONE',l_parameter_one);
371: fnd_message.set_token('PARAMETER_TWO',l_parameter_two);
372: return fnd_message.get;
373: end;
374: else

Line 371: fnd_message.set_token('PARAMETER_TWO',l_parameter_two);

367: exception
368: when others then
369: fnd_message.set_name('PER','AME_400636_INV_DYN_ACT_DESC');
370: fnd_message.set_token('PARAMETER_ONE',l_parameter_one);
371: fnd_message.set_token('PARAMETER_TWO',l_parameter_two);
372: return fnd_message.get;
373: end;
374: else
375: open getActionDesc(actionIdIn => p_action_id,p_effective_date => p_effective_date);

Line 372: return fnd_message.get;

368: when others then
369: fnd_message.set_name('PER','AME_400636_INV_DYN_ACT_DESC');
370: fnd_message.set_token('PARAMETER_ONE',l_parameter_one);
371: fnd_message.set_token('PARAMETER_TWO',l_parameter_two);
372: return fnd_message.get;
373: end;
374: else
375: open getActionDesc(actionIdIn => p_action_id,p_effective_date => p_effective_date);
376: fetch getActionDesc into action_description;

Line 550: fnd_message.set_name('PER','AME_400479_LM_COND_ANY_APPR');

546:
547: if l_condition_type = 'post' then
548: l_string_value := ame_approver_type_pkg.getApproverDescription(l_parameter_two);
549: if l_parameter_one = 'any_approver' then
550: fnd_message.set_name('PER','AME_400479_LM_COND_ANY_APPR');
551: fnd_message.set_token('APPROVER',l_string_value);
552: elsif l_parameter_one = 'final_approver' then
553: fnd_message.set_name('PER','AME_400480_LM_COND_FINAL_APPR');
554: fnd_message.set_token('APPROVER',l_string_value);

Line 551: fnd_message.set_token('APPROVER',l_string_value);

547: if l_condition_type = 'post' then
548: l_string_value := ame_approver_type_pkg.getApproverDescription(l_parameter_two);
549: if l_parameter_one = 'any_approver' then
550: fnd_message.set_name('PER','AME_400479_LM_COND_ANY_APPR');
551: fnd_message.set_token('APPROVER',l_string_value);
552: elsif l_parameter_one = 'final_approver' then
553: fnd_message.set_name('PER','AME_400480_LM_COND_FINAL_APPR');
554: fnd_message.set_token('APPROVER',l_string_value);
555: end if;

Line 553: fnd_message.set_name('PER','AME_400480_LM_COND_FINAL_APPR');

549: if l_parameter_one = 'any_approver' then
550: fnd_message.set_name('PER','AME_400479_LM_COND_ANY_APPR');
551: fnd_message.set_token('APPROVER',l_string_value);
552: elsif l_parameter_one = 'final_approver' then
553: fnd_message.set_name('PER','AME_400480_LM_COND_FINAL_APPR');
554: fnd_message.set_token('APPROVER',l_string_value);
555: end if;
556: l_expression := fnd_message.get;
557: return truncate_cond_desc(l_expression,

Line 554: fnd_message.set_token('APPROVER',l_string_value);

550: fnd_message.set_name('PER','AME_400479_LM_COND_ANY_APPR');
551: fnd_message.set_token('APPROVER',l_string_value);
552: elsif l_parameter_one = 'final_approver' then
553: fnd_message.set_name('PER','AME_400480_LM_COND_FINAL_APPR');
554: fnd_message.set_token('APPROVER',l_string_value);
555: end if;
556: l_expression := fnd_message.get;
557: return truncate_cond_desc(l_expression,
558: p_truncate);

Line 556: l_expression := fnd_message.get;

552: elsif l_parameter_one = 'final_approver' then
553: fnd_message.set_name('PER','AME_400480_LM_COND_FINAL_APPR');
554: fnd_message.set_token('APPROVER',l_string_value);
555: end if;
556: l_expression := fnd_message.get;
557: return truncate_cond_desc(l_expression,
558: p_truncate);
559: end if;
560:

Line 563: fnd_message.set_name('PER','AME_400481_BOOL_T_COND_DESC');

559: end if;
560:
561: if(l_attribute_type = 'boolean') then
562: if l_parameter_one = 'true' then
563: fnd_message.set_name('PER','AME_400481_BOOL_T_COND_DESC');
564: fnd_message.set_token('ATTR',l_attribute_name);
565: elsif l_parameter_one = 'false' then
566: fnd_message.set_name('PER','AME_400482_BOOL_F_COND_DESC');
567: fnd_message.set_token('ATTR',l_attribute_name);

Line 564: fnd_message.set_token('ATTR',l_attribute_name);

560:
561: if(l_attribute_type = 'boolean') then
562: if l_parameter_one = 'true' then
563: fnd_message.set_name('PER','AME_400481_BOOL_T_COND_DESC');
564: fnd_message.set_token('ATTR',l_attribute_name);
565: elsif l_parameter_one = 'false' then
566: fnd_message.set_name('PER','AME_400482_BOOL_F_COND_DESC');
567: fnd_message.set_token('ATTR',l_attribute_name);
568: end if;

Line 566: fnd_message.set_name('PER','AME_400482_BOOL_F_COND_DESC');

562: if l_parameter_one = 'true' then
563: fnd_message.set_name('PER','AME_400481_BOOL_T_COND_DESC');
564: fnd_message.set_token('ATTR',l_attribute_name);
565: elsif l_parameter_one = 'false' then
566: fnd_message.set_name('PER','AME_400482_BOOL_F_COND_DESC');
567: fnd_message.set_token('ATTR',l_attribute_name);
568: end if;
569: l_expression := fnd_message.get;
570: return truncate_cond_desc(l_expression,

Line 567: fnd_message.set_token('ATTR',l_attribute_name);

563: fnd_message.set_name('PER','AME_400481_BOOL_T_COND_DESC');
564: fnd_message.set_token('ATTR',l_attribute_name);
565: elsif l_parameter_one = 'false' then
566: fnd_message.set_name('PER','AME_400482_BOOL_F_COND_DESC');
567: fnd_message.set_token('ATTR',l_attribute_name);
568: end if;
569: l_expression := fnd_message.get;
570: return truncate_cond_desc(l_expression,
571: p_truncate);

Line 569: l_expression := fnd_message.get;

565: elsif l_parameter_one = 'false' then
566: fnd_message.set_name('PER','AME_400482_BOOL_F_COND_DESC');
567: fnd_message.set_token('ATTR',l_attribute_name);
568: end if;
569: l_expression := fnd_message.get;
570: return truncate_cond_desc(l_expression,
571: p_truncate);
572: end if;
573:

Line 596: fnd_message.set_name('PER','AME_400483_STRING_COND_DESC');

592: else
593: l_flag := 'Y';
594: end if;
595: end loop;
596: fnd_message.set_name('PER','AME_400483_STRING_COND_DESC');
597: fnd_message.set_token('ATTR',l_attribute_name);
598: fnd_message.set_token('STRINGVALUES','('||substr(l_stringvalues,1,1900)||')');
599: l_expression := fnd_message.get;
600: return truncate_cond_desc(l_expression,

Line 597: fnd_message.set_token('ATTR',l_attribute_name);

593: l_flag := 'Y';
594: end if;
595: end loop;
596: fnd_message.set_name('PER','AME_400483_STRING_COND_DESC');
597: fnd_message.set_token('ATTR',l_attribute_name);
598: fnd_message.set_token('STRINGVALUES','('||substr(l_stringvalues,1,1900)||')');
599: l_expression := fnd_message.get;
600: return truncate_cond_desc(l_expression,
601: p_truncate);

Line 598: fnd_message.set_token('STRINGVALUES','('||substr(l_stringvalues,1,1900)||')');

594: end if;
595: end loop;
596: fnd_message.set_name('PER','AME_400483_STRING_COND_DESC');
597: fnd_message.set_token('ATTR',l_attribute_name);
598: fnd_message.set_token('STRINGVALUES','('||substr(l_stringvalues,1,1900)||')');
599: l_expression := fnd_message.get;
600: return truncate_cond_desc(l_expression,
601: p_truncate);
602: end if;

Line 599: l_expression := fnd_message.get;

595: end loop;
596: fnd_message.set_name('PER','AME_400483_STRING_COND_DESC');
597: fnd_message.set_token('ATTR',l_attribute_name);
598: fnd_message.set_token('STRINGVALUES','('||substr(l_stringvalues,1,1900)||')');
599: l_expression := fnd_message.get;
600: return truncate_cond_desc(l_expression,
601: p_truncate);
602: end if;
603:

Line 617: fnd_message.set_name('PER','AME_400484_NUM_COND_EQ_DESC');

613: l_include_lower_limit = 'Y') then
614: if l_attribute_type = 'date' then
615: l_parameter_one := to_char(to_date(l_parameter_one,'yyyy:mm:dd:hh24:mi:ss'),'DD-MON-YYYY');
616: end if;
617: fnd_message.set_name('PER','AME_400484_NUM_COND_EQ_DESC');
618: fnd_message.set_token('ATTR',l_attribute_name);
619: fnd_message.set_token('VALUE',l_parameter_one);
620: l_expression := fnd_message.get;
621: else

Line 618: fnd_message.set_token('ATTR',l_attribute_name);

614: if l_attribute_type = 'date' then
615: l_parameter_one := to_char(to_date(l_parameter_one,'yyyy:mm:dd:hh24:mi:ss'),'DD-MON-YYYY');
616: end if;
617: fnd_message.set_name('PER','AME_400484_NUM_COND_EQ_DESC');
618: fnd_message.set_token('ATTR',l_attribute_name);
619: fnd_message.set_token('VALUE',l_parameter_one);
620: l_expression := fnd_message.get;
621: else
622: l_flag := '';

Line 619: fnd_message.set_token('VALUE',l_parameter_one);

615: l_parameter_one := to_char(to_date(l_parameter_one,'yyyy:mm:dd:hh24:mi:ss'),'DD-MON-YYYY');
616: end if;
617: fnd_message.set_name('PER','AME_400484_NUM_COND_EQ_DESC');
618: fnd_message.set_token('ATTR',l_attribute_name);
619: fnd_message.set_token('VALUE',l_parameter_one);
620: l_expression := fnd_message.get;
621: else
622: l_flag := '';
623: if l_parameter_one is not null then

Line 620: l_expression := fnd_message.get;

616: end if;
617: fnd_message.set_name('PER','AME_400484_NUM_COND_EQ_DESC');
618: fnd_message.set_token('ATTR',l_attribute_name);
619: fnd_message.set_token('VALUE',l_parameter_one);
620: l_expression := fnd_message.get;
621: else
622: l_flag := '';
623: if l_parameter_one is not null then
624: if l_attribute_type = 'date' then

Line 644: fnd_message.set_name('PER','AME_400485_NUM_COND_GT_DESC');

640: l_flag := l_flag || 'LT';
641: end if;
642: end if;
643: if(l_flag = 'GT') then
644: fnd_message.set_name('PER','AME_400485_NUM_COND_GT_DESC');
645: fnd_message.set_token('ATTR',l_attribute_name);
646: fnd_message.set_token('VALUE',l_parameter_one);
647: elsif (l_flag = 'GE') then
648: fnd_message.set_name('PER','AME_400486_NUM_COND_GE_DESC');

Line 645: fnd_message.set_token('ATTR',l_attribute_name);

641: end if;
642: end if;
643: if(l_flag = 'GT') then
644: fnd_message.set_name('PER','AME_400485_NUM_COND_GT_DESC');
645: fnd_message.set_token('ATTR',l_attribute_name);
646: fnd_message.set_token('VALUE',l_parameter_one);
647: elsif (l_flag = 'GE') then
648: fnd_message.set_name('PER','AME_400486_NUM_COND_GE_DESC');
649: fnd_message.set_token('ATTR',l_attribute_name);

Line 646: fnd_message.set_token('VALUE',l_parameter_one);

642: end if;
643: if(l_flag = 'GT') then
644: fnd_message.set_name('PER','AME_400485_NUM_COND_GT_DESC');
645: fnd_message.set_token('ATTR',l_attribute_name);
646: fnd_message.set_token('VALUE',l_parameter_one);
647: elsif (l_flag = 'GE') then
648: fnd_message.set_name('PER','AME_400486_NUM_COND_GE_DESC');
649: fnd_message.set_token('ATTR',l_attribute_name);
650: fnd_message.set_token('VALUE',l_parameter_one);

Line 648: fnd_message.set_name('PER','AME_400486_NUM_COND_GE_DESC');

644: fnd_message.set_name('PER','AME_400485_NUM_COND_GT_DESC');
645: fnd_message.set_token('ATTR',l_attribute_name);
646: fnd_message.set_token('VALUE',l_parameter_one);
647: elsif (l_flag = 'GE') then
648: fnd_message.set_name('PER','AME_400486_NUM_COND_GE_DESC');
649: fnd_message.set_token('ATTR',l_attribute_name);
650: fnd_message.set_token('VALUE',l_parameter_one);
651: elsif (l_flag = 'LT') then
652: fnd_message.set_name('PER','AME_400487_NUM_COND_LT_DESC');

Line 649: fnd_message.set_token('ATTR',l_attribute_name);

645: fnd_message.set_token('ATTR',l_attribute_name);
646: fnd_message.set_token('VALUE',l_parameter_one);
647: elsif (l_flag = 'GE') then
648: fnd_message.set_name('PER','AME_400486_NUM_COND_GE_DESC');
649: fnd_message.set_token('ATTR',l_attribute_name);
650: fnd_message.set_token('VALUE',l_parameter_one);
651: elsif (l_flag = 'LT') then
652: fnd_message.set_name('PER','AME_400487_NUM_COND_LT_DESC');
653: fnd_message.set_token('ATTR',l_attribute_name);

Line 650: fnd_message.set_token('VALUE',l_parameter_one);

646: fnd_message.set_token('VALUE',l_parameter_one);
647: elsif (l_flag = 'GE') then
648: fnd_message.set_name('PER','AME_400486_NUM_COND_GE_DESC');
649: fnd_message.set_token('ATTR',l_attribute_name);
650: fnd_message.set_token('VALUE',l_parameter_one);
651: elsif (l_flag = 'LT') then
652: fnd_message.set_name('PER','AME_400487_NUM_COND_LT_DESC');
653: fnd_message.set_token('ATTR',l_attribute_name);
654: fnd_message.set_token('VALUE',l_parameter_two);

Line 652: fnd_message.set_name('PER','AME_400487_NUM_COND_LT_DESC');

648: fnd_message.set_name('PER','AME_400486_NUM_COND_GE_DESC');
649: fnd_message.set_token('ATTR',l_attribute_name);
650: fnd_message.set_token('VALUE',l_parameter_one);
651: elsif (l_flag = 'LT') then
652: fnd_message.set_name('PER','AME_400487_NUM_COND_LT_DESC');
653: fnd_message.set_token('ATTR',l_attribute_name);
654: fnd_message.set_token('VALUE',l_parameter_two);
655: elsif (l_flag = 'LE') then
656: fnd_message.set_name('PER','AME_400488_NUM_COND_LE_DESC');

Line 653: fnd_message.set_token('ATTR',l_attribute_name);

649: fnd_message.set_token('ATTR',l_attribute_name);
650: fnd_message.set_token('VALUE',l_parameter_one);
651: elsif (l_flag = 'LT') then
652: fnd_message.set_name('PER','AME_400487_NUM_COND_LT_DESC');
653: fnd_message.set_token('ATTR',l_attribute_name);
654: fnd_message.set_token('VALUE',l_parameter_two);
655: elsif (l_flag = 'LE') then
656: fnd_message.set_name('PER','AME_400488_NUM_COND_LE_DESC');
657: fnd_message.set_token('ATTR',l_attribute_name);

Line 654: fnd_message.set_token('VALUE',l_parameter_two);

650: fnd_message.set_token('VALUE',l_parameter_one);
651: elsif (l_flag = 'LT') then
652: fnd_message.set_name('PER','AME_400487_NUM_COND_LT_DESC');
653: fnd_message.set_token('ATTR',l_attribute_name);
654: fnd_message.set_token('VALUE',l_parameter_two);
655: elsif (l_flag = 'LE') then
656: fnd_message.set_name('PER','AME_400488_NUM_COND_LE_DESC');
657: fnd_message.set_token('ATTR',l_attribute_name);
658: fnd_message.set_token('VALUE',l_parameter_two);

Line 656: fnd_message.set_name('PER','AME_400488_NUM_COND_LE_DESC');

652: fnd_message.set_name('PER','AME_400487_NUM_COND_LT_DESC');
653: fnd_message.set_token('ATTR',l_attribute_name);
654: fnd_message.set_token('VALUE',l_parameter_two);
655: elsif (l_flag = 'LE') then
656: fnd_message.set_name('PER','AME_400488_NUM_COND_LE_DESC');
657: fnd_message.set_token('ATTR',l_attribute_name);
658: fnd_message.set_token('VALUE',l_parameter_two);
659: elsif (l_flag = 'GTLT') then
660: fnd_message.set_name('PER','AME_400489_NUM_COND_GTLT_DESC');

Line 657: fnd_message.set_token('ATTR',l_attribute_name);

653: fnd_message.set_token('ATTR',l_attribute_name);
654: fnd_message.set_token('VALUE',l_parameter_two);
655: elsif (l_flag = 'LE') then
656: fnd_message.set_name('PER','AME_400488_NUM_COND_LE_DESC');
657: fnd_message.set_token('ATTR',l_attribute_name);
658: fnd_message.set_token('VALUE',l_parameter_two);
659: elsif (l_flag = 'GTLT') then
660: fnd_message.set_name('PER','AME_400489_NUM_COND_GTLT_DESC');
661: fnd_message.set_token('ATTR',l_attribute_name);

Line 658: fnd_message.set_token('VALUE',l_parameter_two);

654: fnd_message.set_token('VALUE',l_parameter_two);
655: elsif (l_flag = 'LE') then
656: fnd_message.set_name('PER','AME_400488_NUM_COND_LE_DESC');
657: fnd_message.set_token('ATTR',l_attribute_name);
658: fnd_message.set_token('VALUE',l_parameter_two);
659: elsif (l_flag = 'GTLT') then
660: fnd_message.set_name('PER','AME_400489_NUM_COND_GTLT_DESC');
661: fnd_message.set_token('ATTR',l_attribute_name);
662: fnd_message.set_token('VALUE1',l_parameter_one);

Line 660: fnd_message.set_name('PER','AME_400489_NUM_COND_GTLT_DESC');

656: fnd_message.set_name('PER','AME_400488_NUM_COND_LE_DESC');
657: fnd_message.set_token('ATTR',l_attribute_name);
658: fnd_message.set_token('VALUE',l_parameter_two);
659: elsif (l_flag = 'GTLT') then
660: fnd_message.set_name('PER','AME_400489_NUM_COND_GTLT_DESC');
661: fnd_message.set_token('ATTR',l_attribute_name);
662: fnd_message.set_token('VALUE1',l_parameter_one);
663: fnd_message.set_token('VALUE2',l_parameter_two);
664: elsif (l_flag = 'GTLE') then

Line 661: fnd_message.set_token('ATTR',l_attribute_name);

657: fnd_message.set_token('ATTR',l_attribute_name);
658: fnd_message.set_token('VALUE',l_parameter_two);
659: elsif (l_flag = 'GTLT') then
660: fnd_message.set_name('PER','AME_400489_NUM_COND_GTLT_DESC');
661: fnd_message.set_token('ATTR',l_attribute_name);
662: fnd_message.set_token('VALUE1',l_parameter_one);
663: fnd_message.set_token('VALUE2',l_parameter_two);
664: elsif (l_flag = 'GTLE') then
665: fnd_message.set_name('PER','AME_400490_NUM_COND_GTLE_DESC');

Line 662: fnd_message.set_token('VALUE1',l_parameter_one);

658: fnd_message.set_token('VALUE',l_parameter_two);
659: elsif (l_flag = 'GTLT') then
660: fnd_message.set_name('PER','AME_400489_NUM_COND_GTLT_DESC');
661: fnd_message.set_token('ATTR',l_attribute_name);
662: fnd_message.set_token('VALUE1',l_parameter_one);
663: fnd_message.set_token('VALUE2',l_parameter_two);
664: elsif (l_flag = 'GTLE') then
665: fnd_message.set_name('PER','AME_400490_NUM_COND_GTLE_DESC');
666: fnd_message.set_token('ATTR',l_attribute_name);

Line 663: fnd_message.set_token('VALUE2',l_parameter_two);

659: elsif (l_flag = 'GTLT') then
660: fnd_message.set_name('PER','AME_400489_NUM_COND_GTLT_DESC');
661: fnd_message.set_token('ATTR',l_attribute_name);
662: fnd_message.set_token('VALUE1',l_parameter_one);
663: fnd_message.set_token('VALUE2',l_parameter_two);
664: elsif (l_flag = 'GTLE') then
665: fnd_message.set_name('PER','AME_400490_NUM_COND_GTLE_DESC');
666: fnd_message.set_token('ATTR',l_attribute_name);
667: fnd_message.set_token('VALUE1',l_parameter_one);

Line 665: fnd_message.set_name('PER','AME_400490_NUM_COND_GTLE_DESC');

661: fnd_message.set_token('ATTR',l_attribute_name);
662: fnd_message.set_token('VALUE1',l_parameter_one);
663: fnd_message.set_token('VALUE2',l_parameter_two);
664: elsif (l_flag = 'GTLE') then
665: fnd_message.set_name('PER','AME_400490_NUM_COND_GTLE_DESC');
666: fnd_message.set_token('ATTR',l_attribute_name);
667: fnd_message.set_token('VALUE1',l_parameter_one);
668: fnd_message.set_token('VALUE2',l_parameter_two);
669: elsif (l_flag = 'GELE') then

Line 666: fnd_message.set_token('ATTR',l_attribute_name);

662: fnd_message.set_token('VALUE1',l_parameter_one);
663: fnd_message.set_token('VALUE2',l_parameter_two);
664: elsif (l_flag = 'GTLE') then
665: fnd_message.set_name('PER','AME_400490_NUM_COND_GTLE_DESC');
666: fnd_message.set_token('ATTR',l_attribute_name);
667: fnd_message.set_token('VALUE1',l_parameter_one);
668: fnd_message.set_token('VALUE2',l_parameter_two);
669: elsif (l_flag = 'GELE') then
670: fnd_message.set_name('PER','AME_400491_NUM_COND_GELE_DESC');

Line 667: fnd_message.set_token('VALUE1',l_parameter_one);

663: fnd_message.set_token('VALUE2',l_parameter_two);
664: elsif (l_flag = 'GTLE') then
665: fnd_message.set_name('PER','AME_400490_NUM_COND_GTLE_DESC');
666: fnd_message.set_token('ATTR',l_attribute_name);
667: fnd_message.set_token('VALUE1',l_parameter_one);
668: fnd_message.set_token('VALUE2',l_parameter_two);
669: elsif (l_flag = 'GELE') then
670: fnd_message.set_name('PER','AME_400491_NUM_COND_GELE_DESC');
671: fnd_message.set_token('ATTR',l_attribute_name);

Line 668: fnd_message.set_token('VALUE2',l_parameter_two);

664: elsif (l_flag = 'GTLE') then
665: fnd_message.set_name('PER','AME_400490_NUM_COND_GTLE_DESC');
666: fnd_message.set_token('ATTR',l_attribute_name);
667: fnd_message.set_token('VALUE1',l_parameter_one);
668: fnd_message.set_token('VALUE2',l_parameter_two);
669: elsif (l_flag = 'GELE') then
670: fnd_message.set_name('PER','AME_400491_NUM_COND_GELE_DESC');
671: fnd_message.set_token('ATTR',l_attribute_name);
672: fnd_message.set_token('VALUE1',l_parameter_one);

Line 670: fnd_message.set_name('PER','AME_400491_NUM_COND_GELE_DESC');

666: fnd_message.set_token('ATTR',l_attribute_name);
667: fnd_message.set_token('VALUE1',l_parameter_one);
668: fnd_message.set_token('VALUE2',l_parameter_two);
669: elsif (l_flag = 'GELE') then
670: fnd_message.set_name('PER','AME_400491_NUM_COND_GELE_DESC');
671: fnd_message.set_token('ATTR',l_attribute_name);
672: fnd_message.set_token('VALUE1',l_parameter_one);
673: fnd_message.set_token('VALUE2',l_parameter_two);
674: elsif (l_flag = 'GELT') then

Line 671: fnd_message.set_token('ATTR',l_attribute_name);

667: fnd_message.set_token('VALUE1',l_parameter_one);
668: fnd_message.set_token('VALUE2',l_parameter_two);
669: elsif (l_flag = 'GELE') then
670: fnd_message.set_name('PER','AME_400491_NUM_COND_GELE_DESC');
671: fnd_message.set_token('ATTR',l_attribute_name);
672: fnd_message.set_token('VALUE1',l_parameter_one);
673: fnd_message.set_token('VALUE2',l_parameter_two);
674: elsif (l_flag = 'GELT') then
675: fnd_message.set_name('PER','AME_400492_NUM_COND_GELT_DESC');

Line 672: fnd_message.set_token('VALUE1',l_parameter_one);

668: fnd_message.set_token('VALUE2',l_parameter_two);
669: elsif (l_flag = 'GELE') then
670: fnd_message.set_name('PER','AME_400491_NUM_COND_GELE_DESC');
671: fnd_message.set_token('ATTR',l_attribute_name);
672: fnd_message.set_token('VALUE1',l_parameter_one);
673: fnd_message.set_token('VALUE2',l_parameter_two);
674: elsif (l_flag = 'GELT') then
675: fnd_message.set_name('PER','AME_400492_NUM_COND_GELT_DESC');
676: fnd_message.set_token('ATTR',l_attribute_name);

Line 673: fnd_message.set_token('VALUE2',l_parameter_two);

669: elsif (l_flag = 'GELE') then
670: fnd_message.set_name('PER','AME_400491_NUM_COND_GELE_DESC');
671: fnd_message.set_token('ATTR',l_attribute_name);
672: fnd_message.set_token('VALUE1',l_parameter_one);
673: fnd_message.set_token('VALUE2',l_parameter_two);
674: elsif (l_flag = 'GELT') then
675: fnd_message.set_name('PER','AME_400492_NUM_COND_GELT_DESC');
676: fnd_message.set_token('ATTR',l_attribute_name);
677: fnd_message.set_token('VALUE1',l_parameter_one);

Line 675: fnd_message.set_name('PER','AME_400492_NUM_COND_GELT_DESC');

671: fnd_message.set_token('ATTR',l_attribute_name);
672: fnd_message.set_token('VALUE1',l_parameter_one);
673: fnd_message.set_token('VALUE2',l_parameter_two);
674: elsif (l_flag = 'GELT') then
675: fnd_message.set_name('PER','AME_400492_NUM_COND_GELT_DESC');
676: fnd_message.set_token('ATTR',l_attribute_name);
677: fnd_message.set_token('VALUE1',l_parameter_one);
678: fnd_message.set_token('VALUE2',l_parameter_two);
679: end if;

Line 676: fnd_message.set_token('ATTR',l_attribute_name);

672: fnd_message.set_token('VALUE1',l_parameter_one);
673: fnd_message.set_token('VALUE2',l_parameter_two);
674: elsif (l_flag = 'GELT') then
675: fnd_message.set_name('PER','AME_400492_NUM_COND_GELT_DESC');
676: fnd_message.set_token('ATTR',l_attribute_name);
677: fnd_message.set_token('VALUE1',l_parameter_one);
678: fnd_message.set_token('VALUE2',l_parameter_two);
679: end if;
680: l_expression := fnd_message.get;

Line 677: fnd_message.set_token('VALUE1',l_parameter_one);

673: fnd_message.set_token('VALUE2',l_parameter_two);
674: elsif (l_flag = 'GELT') then
675: fnd_message.set_name('PER','AME_400492_NUM_COND_GELT_DESC');
676: fnd_message.set_token('ATTR',l_attribute_name);
677: fnd_message.set_token('VALUE1',l_parameter_one);
678: fnd_message.set_token('VALUE2',l_parameter_two);
679: end if;
680: l_expression := fnd_message.get;
681: end if;

Line 678: fnd_message.set_token('VALUE2',l_parameter_two);

674: elsif (l_flag = 'GELT') then
675: fnd_message.set_name('PER','AME_400492_NUM_COND_GELT_DESC');
676: fnd_message.set_token('ATTR',l_attribute_name);
677: fnd_message.set_token('VALUE1',l_parameter_one);
678: fnd_message.set_token('VALUE2',l_parameter_two);
679: end if;
680: l_expression := fnd_message.get;
681: end if;
682: if(l_attribute_type = 'currency') then

Line 680: l_expression := fnd_message.get;

676: fnd_message.set_token('ATTR',l_attribute_name);
677: fnd_message.set_token('VALUE1',l_parameter_one);
678: fnd_message.set_token('VALUE2',l_parameter_two);
679: end if;
680: l_expression := fnd_message.get;
681: end if;
682: if(l_attribute_type = 'currency') then
683: l_expression := l_expression || ','||l_parameter_three;
684: end if;

Line 723: fnd_message.set_name('PER','AME_400344_INVALID_APPROVER');

719: and wfroles.orig_system = appr.orig_system
720: and to_char(wfroles.orig_system_id) = l_parameter_one
721: and rownum < 2;
722:
723: fnd_message.set_name('PER','AME_400344_INVALID_APPROVER');
724: fnd_message.set_token('ATTR',l_attribute_name);
725: fnd_message.set_token('NAME',l_string_value);
726: l_string_value := fnd_message.get;
727: return truncate_cond_desc(l_string_value,

Line 724: fnd_message.set_token('ATTR',l_attribute_name);

720: and to_char(wfroles.orig_system_id) = l_parameter_one
721: and rownum < 2;
722:
723: fnd_message.set_name('PER','AME_400344_INVALID_APPROVER');
724: fnd_message.set_token('ATTR',l_attribute_name);
725: fnd_message.set_token('NAME',l_string_value);
726: l_string_value := fnd_message.get;
727: return truncate_cond_desc(l_string_value,
728: p_truncate);

Line 725: fnd_message.set_token('NAME',l_string_value);

721: and rownum < 2;
722:
723: fnd_message.set_name('PER','AME_400344_INVALID_APPROVER');
724: fnd_message.set_token('ATTR',l_attribute_name);
725: fnd_message.set_token('NAME',l_string_value);
726: l_string_value := fnd_message.get;
727: return truncate_cond_desc(l_string_value,
728: p_truncate);
729: exception

Line 726: l_string_value := fnd_message.get;

722:
723: fnd_message.set_name('PER','AME_400344_INVALID_APPROVER');
724: fnd_message.set_token('ATTR',l_attribute_name);
725: fnd_message.set_token('NAME',l_string_value);
726: l_string_value := fnd_message.get;
727: return truncate_cond_desc(l_string_value,
728: p_truncate);
729: exception
730: when others then

Line 731: fnd_message.set_name('PER','AME_400344_INVALID_APPROVER');

727: return truncate_cond_desc(l_string_value,
728: p_truncate);
729: exception
730: when others then
731: fnd_message.set_name('PER','AME_400344_INVALID_APPROVER');
732: fnd_message.set_token('ATTR',l_attribute_name);
733: select lookup.meaning ||': '|| l_parameter_one
734: into l_string_value
735: from ame_approver_types appr

Line 732: fnd_message.set_token('ATTR',l_attribute_name);

728: p_truncate);
729: exception
730: when others then
731: fnd_message.set_name('PER','AME_400344_INVALID_APPROVER');
732: fnd_message.set_token('ATTR',l_attribute_name);
733: select lookup.meaning ||': '|| l_parameter_one
734: into l_string_value
735: from ame_approver_types appr
736: ,fnd_lookups lookup

Line 743: fnd_message.set_token('NAME', l_string_value);

739: and lookup.lookup_code = appr.orig_system
740: and p_effective_date between appr.start_date
741: and nvl(appr.end_date-(1/86400),p_effective_date)
742: and rownum < 2;
743: fnd_message.set_token('NAME', l_string_value);
744: l_string_value := fnd_message.get;
745: return truncate_cond_desc(l_string_value,
746: p_truncate);
747: end;

Line 744: l_string_value := fnd_message.get;

740: and p_effective_date between appr.start_date
741: and nvl(appr.end_date-(1/86400),p_effective_date)
742: and rownum < 2;
743: fnd_message.set_token('NAME', l_string_value);
744: l_string_value := fnd_message.get;
745: return truncate_cond_desc(l_string_value,
746: p_truncate);
747: end;
748: end;

Line 750: fnd_message.set_name('PER','AME_400493_NUM_APPR_COND_DESC');

746: p_truncate);
747: end;
748: end;
749:
750: fnd_message.set_name('PER','AME_400493_NUM_APPR_COND_DESC');
751: fnd_message.set_token('ATTR',l_attribute_name);
752: fnd_message.set_token('APPROVER',l_string_value);
753: l_expression := fnd_message.get;
754: return truncate_cond_desc(l_expression,

Line 751: fnd_message.set_token('ATTR',l_attribute_name);

747: end;
748: end;
749:
750: fnd_message.set_name('PER','AME_400493_NUM_APPR_COND_DESC');
751: fnd_message.set_token('ATTR',l_attribute_name);
752: fnd_message.set_token('APPROVER',l_string_value);
753: l_expression := fnd_message.get;
754: return truncate_cond_desc(l_expression,
755: p_truncate);

Line 752: fnd_message.set_token('APPROVER',l_string_value);

748: end;
749:
750: fnd_message.set_name('PER','AME_400493_NUM_APPR_COND_DESC');
751: fnd_message.set_token('ATTR',l_attribute_name);
752: fnd_message.set_token('APPROVER',l_string_value);
753: l_expression := fnd_message.get;
754: return truncate_cond_desc(l_expression,
755: p_truncate);
756: end if;

Line 753: l_expression := fnd_message.get;

749:
750: fnd_message.set_name('PER','AME_400493_NUM_APPR_COND_DESC');
751: fnd_message.set_token('ATTR',l_attribute_name);
752: fnd_message.set_token('APPROVER',l_string_value);
753: l_expression := fnd_message.get;
754: return truncate_cond_desc(l_expression,
755: p_truncate);
756: end if;
757: return '';

Line 781: fnd_message.set_name('PER','AME_400637_TEXT_NONE');

777: fetch action_types_cursor bulk collect into action_types_list;
778: close action_types_cursor;
779:
780: if action_types_list.count = 0 then
781: fnd_message.set_name('PER','AME_400637_TEXT_NONE');
782: return fnd_message.get;
783: end if;
784:
785: for i in 1 .. action_types_list.count loop

Line 782: return fnd_message.get;

778: close action_types_cursor;
779:
780: if action_types_list.count = 0 then
781: fnd_message.set_name('PER','AME_400637_TEXT_NONE');
782: return fnd_message.get;
783: end if;
784:
785: for i in 1 .. action_types_list.count loop
786: list := list || action_types_list(i);