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);