eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_CCR_DATA_LOAD_PKG dependencies on FND_MESSAGE

Line 95: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');

91: END IF;
92: END LOOP;
93: IF not code_exist THEN
94:
95: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
96: FND_MESSAGE.set_TOKEN('TYPE','Business Type');
97: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
98: message_text := FND_MESSAGE.get;
99:

Line 96: FND_MESSAGE.set_TOKEN('TYPE','Business Type');

92: END LOOP;
93: IF not code_exist THEN
94:
95: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
96: FND_MESSAGE.set_TOKEN('TYPE','Business Type');
97: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
98: message_text := FND_MESSAGE.get;
99:
100: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

Line 97: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);

93: IF not code_exist THEN
94:
95: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
96: FND_MESSAGE.set_TOKEN('TYPE','Business Type');
97: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
98: message_text := FND_MESSAGE.get;
99:
100: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
101: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

Line 98: message_text := FND_MESSAGE.get;

94:
95: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
96: FND_MESSAGE.set_TOKEN('TYPE','Business Type');
97: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
98: message_text := FND_MESSAGE.get;
99:
100: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
101: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
102:

Line 100: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

96: FND_MESSAGE.set_TOKEN('TYPE','Business Type');
97: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
98: message_text := FND_MESSAGE.get;
99:
100: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
101: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
102:
103: message_action := FND_MESSAGE.get;
104:

Line 101: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

97: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
98: message_text := FND_MESSAGE.get;
99:
100: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
101: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
102:
103: message_action := FND_MESSAGE.get;
104:
105: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;

Line 103: message_action := FND_MESSAGE.get;

99:
100: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
101: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
102:
103: message_action := FND_MESSAGE.get;
104:
105: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;
106: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);
107: insert_temp_data(3,null,message_text ,message_action,'ORACLE',null,null);

Line 125: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');

121: END IF;
122: END LOOP;
123: IF not code_exist THEN
124:
125: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
126: FND_MESSAGE.set_TOKEN('TYPE','SIC Code');
127: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
128:
129: message_text := FND_MESSAGE.get;

Line 126: FND_MESSAGE.set_TOKEN('TYPE','SIC Code');

122: END LOOP;
123: IF not code_exist THEN
124:
125: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
126: FND_MESSAGE.set_TOKEN('TYPE','SIC Code');
127: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
128:
129: message_text := FND_MESSAGE.get;
130:

Line 127: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);

123: IF not code_exist THEN
124:
125: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
126: FND_MESSAGE.set_TOKEN('TYPE','SIC Code');
127: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
128:
129: message_text := FND_MESSAGE.get;
130:
131: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

Line 129: message_text := FND_MESSAGE.get;

125: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
126: FND_MESSAGE.set_TOKEN('TYPE','SIC Code');
127: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
128:
129: message_text := FND_MESSAGE.get;
130:
131: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
132: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
133:

Line 131: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

127: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
128:
129: message_text := FND_MESSAGE.get;
130:
131: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
132: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
133:
134: message_action := FND_MESSAGE.get;
135:

Line 132: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

128:
129: message_text := FND_MESSAGE.get;
130:
131: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
132: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
133:
134: message_action := FND_MESSAGE.get;
135:
136: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;

Line 134: message_action := FND_MESSAGE.get;

130:
131: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
132: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
133:
134: message_action := FND_MESSAGE.get;
135:
136: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;
137: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);
138: insert_temp_data(3,null,message_text ,message_action,'ORACLE',null,null);

Line 153: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');

149: END IF;
150: END LOOP;
151: IF not code_exist THEN
152:
153: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
154: FND_MESSAGE.set_TOKEN('TYPE','NAICS Code');
155: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
156: message_text := FND_MESSAGE.get;
157:

Line 154: FND_MESSAGE.set_TOKEN('TYPE','NAICS Code');

150: END LOOP;
151: IF not code_exist THEN
152:
153: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
154: FND_MESSAGE.set_TOKEN('TYPE','NAICS Code');
155: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
156: message_text := FND_MESSAGE.get;
157:
158: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

Line 155: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);

151: IF not code_exist THEN
152:
153: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
154: FND_MESSAGE.set_TOKEN('TYPE','NAICS Code');
155: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
156: message_text := FND_MESSAGE.get;
157:
158: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
159: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

Line 156: message_text := FND_MESSAGE.get;

152:
153: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
154: FND_MESSAGE.set_TOKEN('TYPE','NAICS Code');
155: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
156: message_text := FND_MESSAGE.get;
157:
158: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
159: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
160:

Line 158: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

154: FND_MESSAGE.set_TOKEN('TYPE','NAICS Code');
155: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
156: message_text := FND_MESSAGE.get;
157:
158: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
159: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
160:
161: message_action := FND_MESSAGE.get;
162:

Line 159: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

155: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
156: message_text := FND_MESSAGE.get;
157:
158: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
159: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
160:
161: message_action := FND_MESSAGE.get;
162:
163: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;

Line 161: message_action := FND_MESSAGE.get;

157:
158: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
159: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
160:
161: message_action := FND_MESSAGE.get;
162:
163: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;
164: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);
165: insert_temp_data(3,null,message_text ,message_action,'ORACLE',null,null);

Line 180: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');

176: END IF;
177: END LOOP;
178: IF not code_exist THEN
179:
180: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
181: FND_MESSAGE.set_TOKEN('TYPE','FSC code');
182: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
183:
184: message_text := FND_MESSAGE.get;

Line 181: FND_MESSAGE.set_TOKEN('TYPE','FSC code');

177: END LOOP;
178: IF not code_exist THEN
179:
180: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
181: FND_MESSAGE.set_TOKEN('TYPE','FSC code');
182: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
183:
184: message_text := FND_MESSAGE.get;
185:

Line 182: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);

178: IF not code_exist THEN
179:
180: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
181: FND_MESSAGE.set_TOKEN('TYPE','FSC code');
182: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
183:
184: message_text := FND_MESSAGE.get;
185:
186: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

Line 184: message_text := FND_MESSAGE.get;

180: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
181: FND_MESSAGE.set_TOKEN('TYPE','FSC code');
182: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
183:
184: message_text := FND_MESSAGE.get;
185:
186: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
187: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
188:

Line 186: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

182: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
183:
184: message_text := FND_MESSAGE.get;
185:
186: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
187: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
188:
189: message_action := FND_MESSAGE.get;
190:

Line 187: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

183:
184: message_text := FND_MESSAGE.get;
185:
186: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
187: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
188:
189: message_action := FND_MESSAGE.get;
190:
191: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;

Line 189: message_action := FND_MESSAGE.get;

185:
186: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
187: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
188:
189: message_action := FND_MESSAGE.get;
190:
191: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;
192: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);
193: insert_temp_data(3,null,message_text ,message_action,'ORACLE',null,null);

Line 208: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');

204: END IF;
205: END LOOP;
206: IF not code_exist THEN
207:
208: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
209: FND_MESSAGE.set_TOKEN('TYPE','PSC Code');
210: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
211:
212: message_text := FND_MESSAGE.get;

Line 209: FND_MESSAGE.set_TOKEN('TYPE','PSC Code');

205: END LOOP;
206: IF not code_exist THEN
207:
208: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
209: FND_MESSAGE.set_TOKEN('TYPE','PSC Code');
210: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
211:
212: message_text := FND_MESSAGE.get;
213:

Line 210: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);

206: IF not code_exist THEN
207:
208: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
209: FND_MESSAGE.set_TOKEN('TYPE','PSC Code');
210: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
211:
212: message_text := FND_MESSAGE.get;
213:
214: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

Line 212: message_text := FND_MESSAGE.get;

208: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
209: FND_MESSAGE.set_TOKEN('TYPE','PSC Code');
210: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
211:
212: message_text := FND_MESSAGE.get;
213:
214: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
215: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
216:

Line 214: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

210: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
211:
212: message_text := FND_MESSAGE.get;
213:
214: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
215: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
216:
217: message_action := FND_MESSAGE.get;
218:

Line 215: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

211:
212: message_text := FND_MESSAGE.get;
213:
214: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
215: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
216:
217: message_action := FND_MESSAGE.get;
218:
219: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;

Line 217: message_action := FND_MESSAGE.get;

213:
214: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
215: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
216:
217: message_action := FND_MESSAGE.get;
218:
219: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;
220: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);
221: insert_temp_data(3,null,message_text ,message_action,'ORACLE',null,null);

Line 235: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');

231: END IF;
232: CLOSE c_lookup_info;
233: IF not code_exist THEN
234:
235: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
236: FND_MESSAGE.set_TOKEN('TYPE','Organization Type');
237: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
238: message_text := FND_MESSAGE.get;
239:

Line 236: FND_MESSAGE.set_TOKEN('TYPE','Organization Type');

232: CLOSE c_lookup_info;
233: IF not code_exist THEN
234:
235: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
236: FND_MESSAGE.set_TOKEN('TYPE','Organization Type');
237: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
238: message_text := FND_MESSAGE.get;
239:
240: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

Line 237: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);

233: IF not code_exist THEN
234:
235: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
236: FND_MESSAGE.set_TOKEN('TYPE','Organization Type');
237: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
238: message_text := FND_MESSAGE.get;
239:
240: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
241: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

Line 238: message_text := FND_MESSAGE.get;

234:
235: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
236: FND_MESSAGE.set_TOKEN('TYPE','Organization Type');
237: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
238: message_text := FND_MESSAGE.get;
239:
240: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
241: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
242:

Line 240: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

236: FND_MESSAGE.set_TOKEN('TYPE','Organization Type');
237: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
238: message_text := FND_MESSAGE.get;
239:
240: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
241: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
242:
243: message_action := FND_MESSAGE.get;
244:

Line 241: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

237: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
238: message_text := FND_MESSAGE.get;
239:
240: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
241: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
242:
243: message_action := FND_MESSAGE.get;
244:
245: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;

Line 243: message_action := FND_MESSAGE.get;

239:
240: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
241: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
242:
243: message_action := FND_MESSAGE.get;
244:
245: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;
246: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);
247: insert_temp_data(3,null,message_text ,message_action,'ORACLE',null,null);

Line 260: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');

256: END IF;
257: CLOSE c_lookup_info;
258: IF not code_exist THEN
259:
260: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
261: FND_MESSAGE.set_TOKEN('TYPE','Correspondence Type');
262: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
263: message_text := FND_MESSAGE.get;
264:

Line 261: FND_MESSAGE.set_TOKEN('TYPE','Correspondence Type');

257: CLOSE c_lookup_info;
258: IF not code_exist THEN
259:
260: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
261: FND_MESSAGE.set_TOKEN('TYPE','Correspondence Type');
262: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
263: message_text := FND_MESSAGE.get;
264:
265: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

Line 262: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);

258: IF not code_exist THEN
259:
260: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
261: FND_MESSAGE.set_TOKEN('TYPE','Correspondence Type');
262: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
263: message_text := FND_MESSAGE.get;
264:
265: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
266: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

Line 263: message_text := FND_MESSAGE.get;

259:
260: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
261: FND_MESSAGE.set_TOKEN('TYPE','Correspondence Type');
262: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
263: message_text := FND_MESSAGE.get;
264:
265: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
266: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
267:

Line 265: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

261: FND_MESSAGE.set_TOKEN('TYPE','Correspondence Type');
262: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
263: message_text := FND_MESSAGE.get;
264:
265: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
266: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
267:
268: message_action := FND_MESSAGE.get;
269:

Line 266: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

262: FND_MESSAGE.SET_TOKEN('CODE',p_lookup(i).code);
263: message_text := FND_MESSAGE.get;
264:
265: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
266: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
267:
268: message_action := FND_MESSAGE.get;
269:
270: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;

Line 268: message_action := FND_MESSAGE.get;

264:
265: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
266: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
267:
268: message_action := FND_MESSAGE.get;
269:
270: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;
271: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);
272: insert_temp_data(3,null,message_text ,message_action,'ORACLE',null,null);

Line 290: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');

286:
287: select decode(p_lookup(i).code,'CS','Corporate Security Code', 'Employee Security Code') into l_token
288: from dual;
289:
290: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
291: FND_MESSAGE.set_TOKEN('TYPE',p_lookup(i).rec_type);
292: FND_MESSAGE.SET_TOKEN('CODE',l_token);
293: message_text := FND_MESSAGE.get;
294:

Line 291: FND_MESSAGE.set_TOKEN('TYPE',p_lookup(i).rec_type);

287: select decode(p_lookup(i).code,'CS','Corporate Security Code', 'Employee Security Code') into l_token
288: from dual;
289:
290: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
291: FND_MESSAGE.set_TOKEN('TYPE',p_lookup(i).rec_type);
292: FND_MESSAGE.SET_TOKEN('CODE',l_token);
293: message_text := FND_MESSAGE.get;
294:
295: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

Line 292: FND_MESSAGE.SET_TOKEN('CODE',l_token);

288: from dual;
289:
290: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
291: FND_MESSAGE.set_TOKEN('TYPE',p_lookup(i).rec_type);
292: FND_MESSAGE.SET_TOKEN('CODE',l_token);
293: message_text := FND_MESSAGE.get;
294:
295: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
296: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

Line 293: message_text := FND_MESSAGE.get;

289:
290: FND_MESSAGE.set_NAME('FV','FV_CCR_TYPE_INEXISTS');
291: FND_MESSAGE.set_TOKEN('TYPE',p_lookup(i).rec_type);
292: FND_MESSAGE.SET_TOKEN('CODE',l_token);
293: message_text := FND_MESSAGE.get;
294:
295: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
296: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
297:

Line 295: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');

291: FND_MESSAGE.set_TOKEN('TYPE',p_lookup(i).rec_type);
292: FND_MESSAGE.SET_TOKEN('CODE',l_token);
293: message_text := FND_MESSAGE.get;
294:
295: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
296: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
297:
298: message_action := FND_MESSAGE.get;
299:

Line 296: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);

292: FND_MESSAGE.SET_TOKEN('CODE',l_token);
293: message_text := FND_MESSAGE.get;
294:
295: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
296: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
297:
298: message_action := FND_MESSAGE.get;
299:
300: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;

Line 298: message_action := FND_MESSAGE.get;

294:
295: FND_MESSAGE.set_NAME('FV','FV_CCR_ACTION5');
296: FND_MESSAGE.set_token('TYPE',p_lookup(i).code);
297:
298: message_action := FND_MESSAGE.get;
299:
300: l_errbuf :=p_lookup(i).code||' -> Code does not exist' ;
301: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);
302: insert_temp_data(3,null,message_text ,message_action,'ORACLE',null,null);

Line 456: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION1');

452: -- construct the file name from the file location and name
453: -- file name ( '\\' --> for WINDOWS NT , '/' --> UNIX )
454:
455:
456: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION1');
457: l_message_action1 := FND_MESSAGE.GET;
458:
459: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION2');
460: l_message_action2 := FND_MESSAGE.GET;

Line 457: l_message_action1 := FND_MESSAGE.GET;

453: -- file name ( '\\' --> for WINDOWS NT , '/' --> UNIX )
454:
455:
456: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION1');
457: l_message_action1 := FND_MESSAGE.GET;
458:
459: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION2');
460: l_message_action2 := FND_MESSAGE.GET;
461:

Line 459: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION2');

455:
456: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION1');
457: l_message_action1 := FND_MESSAGE.GET;
458:
459: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION2');
460: l_message_action2 := FND_MESSAGE.GET;
461:
462: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION3');
463: l_message_action3 := FND_MESSAGE.GET;

Line 460: l_message_action2 := FND_MESSAGE.GET;

456: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION1');
457: l_message_action1 := FND_MESSAGE.GET;
458:
459: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION2');
460: l_message_action2 := FND_MESSAGE.GET;
461:
462: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION3');
463: l_message_action3 := FND_MESSAGE.GET;
464:

Line 462: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION3');

458:
459: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION2');
460: l_message_action2 := FND_MESSAGE.GET;
461:
462: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION3');
463: l_message_action3 := FND_MESSAGE.GET;
464:
465: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION4');
466: l_message_action4 := FND_MESSAGE.GET;

Line 463: l_message_action3 := FND_MESSAGE.GET;

459: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION2');
460: l_message_action2 := FND_MESSAGE.GET;
461:
462: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION3');
463: l_message_action3 := FND_MESSAGE.GET;
464:
465: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION4');
466: l_message_action4 := FND_MESSAGE.GET;
467:

Line 465: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION4');

461:
462: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION3');
463: l_message_action3 := FND_MESSAGE.GET;
464:
465: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION4');
466: l_message_action4 := FND_MESSAGE.GET;
467:
468: FND_MESSAGE.SET_NAME('FV','FV_CCR_NO_DUNS');
469: l_msg_no_duns := FND_MESSAGE.GET;

Line 466: l_message_action4 := FND_MESSAGE.GET;

462: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION3');
463: l_message_action3 := FND_MESSAGE.GET;
464:
465: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION4');
466: l_message_action4 := FND_MESSAGE.GET;
467:
468: FND_MESSAGE.SET_NAME('FV','FV_CCR_NO_DUNS');
469: l_msg_no_duns := FND_MESSAGE.GET;
470:

Line 468: FND_MESSAGE.SET_NAME('FV','FV_CCR_NO_DUNS');

464:
465: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION4');
466: l_message_action4 := FND_MESSAGE.GET;
467:
468: FND_MESSAGE.SET_NAME('FV','FV_CCR_NO_DUNS');
469: l_msg_no_duns := FND_MESSAGE.GET;
470:
471: -- need to perform file name validations only if we are intending to call direct
472: IF p_xml_import <> 'Y' THEN

Line 469: l_msg_no_duns := FND_MESSAGE.GET;

465: FND_MESSAGE.SET_NAME('FV','FV_CCR_ACTION4');
466: l_message_action4 := FND_MESSAGE.GET;
467:
468: FND_MESSAGE.SET_NAME('FV','FV_CCR_NO_DUNS');
469: l_msg_no_duns := FND_MESSAGE.GET;
470:
471: -- need to perform file name validations only if we are intending to call direct
472: IF p_xml_import <> 'Y' THEN
473:

Line 496: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');

492: l_invalid_file_name := TRUE;
493: l_errbuf := 'Error in Position#1 of filename';
494: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
495:
496: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
497: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
498: l_msg_inv_file_name := FND_MESSAGE.GET;
499:
500: insert_temp_data(3,null,l_msg_inv_file_name,l_message_action1,null,null,null);

Line 497: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);

493: l_errbuf := 'Error in Position#1 of filename';
494: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
495:
496: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
497: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
498: l_msg_inv_file_name := FND_MESSAGE.GET;
499:
500: insert_temp_data(3,null,l_msg_inv_file_name,l_message_action1,null,null,null);
501: END IF;

Line 498: l_msg_inv_file_name := FND_MESSAGE.GET;

494: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
495:
496: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
497: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
498: l_msg_inv_file_name := FND_MESSAGE.GET;
499:
500: insert_temp_data(3,null,l_msg_inv_file_name,l_message_action1,null,null,null);
501: END IF;
502:

Line 511: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');

507: l_invalid_file_name := TRUE;
508: l_errbuf := 'Error in Position#2-3 of filename';
509: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
510:
511: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
512: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
513: l_msg_inv_file_name := FND_MESSAGE.GET;
514: insert_temp_data(3,null,l_msg_inv_file_name,l_message_action1,null,null,null);
515: END IF;

Line 512: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);

508: l_errbuf := 'Error in Position#2-3 of filename';
509: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
510:
511: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
512: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
513: l_msg_inv_file_name := FND_MESSAGE.GET;
514: insert_temp_data(3,null,l_msg_inv_file_name,l_message_action1,null,null,null);
515: END IF;
516:

Line 513: l_msg_inv_file_name := FND_MESSAGE.GET;

509: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
510:
511: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
512: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
513: l_msg_inv_file_name := FND_MESSAGE.GET;
514: insert_temp_data(3,null,l_msg_inv_file_name,l_message_action1,null,null,null);
515: END IF;
516:
517: --find out if master/sensitive

Line 529: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');

525: l_invalid_file_name := TRUE;
526: l_errbuf := 'The file name does not match the file type';
527: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
528:
529: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
530: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
531: l_msg_inv_file_name := FND_MESSAGE.GET;
532: insert_temp_data(3,null,l_msg_inv_file_name,l_message_action4,null,null,null);
533:

Line 530: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);

526: l_errbuf := 'The file name does not match the file type';
527: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
528:
529: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
530: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
531: l_msg_inv_file_name := FND_MESSAGE.GET;
532: insert_temp_data(3,null,l_msg_inv_file_name,l_message_action4,null,null,null);
533:
534: END IF;

Line 531: l_msg_inv_file_name := FND_MESSAGE.GET;

527: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
528:
529: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
530: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
531: l_msg_inv_file_name := FND_MESSAGE.GET;
532: insert_temp_data(3,null,l_msg_inv_file_name,l_message_action4,null,null,null);
533:
534: END IF;
535:

Line 552: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');

548: retcode :=-1;
549: l_errbuf := SQLERRM;
550: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
551:
552: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
553: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
554: l_msg_inv_file_name := FND_MESSAGE.GET;
555:
556: FND_MESSAGE.SET_NAME('FV','FV_CCR_JULIAN_DATE_ACTION');

Line 553: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);

549: l_errbuf := SQLERRM;
550: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
551:
552: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
553: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
554: l_msg_inv_file_name := FND_MESSAGE.GET;
555:
556: FND_MESSAGE.SET_NAME('FV','FV_CCR_JULIAN_DATE_ACTION');
557: FND_MESSAGE.SET_TOKEN('DATE',l_juliandate);

Line 554: l_msg_inv_file_name := FND_MESSAGE.GET;

550: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
551:
552: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
553: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
554: l_msg_inv_file_name := FND_MESSAGE.GET;
555:
556: FND_MESSAGE.SET_NAME('FV','FV_CCR_JULIAN_DATE_ACTION');
557: FND_MESSAGE.SET_TOKEN('DATE',l_juliandate);
558: l_msg_julian_date := FND_MESSAGE.GET;

Line 556: FND_MESSAGE.SET_NAME('FV','FV_CCR_JULIAN_DATE_ACTION');

552: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_NAME');
553: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
554: l_msg_inv_file_name := FND_MESSAGE.GET;
555:
556: FND_MESSAGE.SET_NAME('FV','FV_CCR_JULIAN_DATE_ACTION');
557: FND_MESSAGE.SET_TOKEN('DATE',l_juliandate);
558: l_msg_julian_date := FND_MESSAGE.GET;
559:
560: insert_temp_data(3,null,l_msg_inv_file_name,l_msg_julian_date,null,null,null);

Line 557: FND_MESSAGE.SET_TOKEN('DATE',l_juliandate);

553: FND_MESSAGE.SET_TOKEN('FILE',p_file_name);
554: l_msg_inv_file_name := FND_MESSAGE.GET;
555:
556: FND_MESSAGE.SET_NAME('FV','FV_CCR_JULIAN_DATE_ACTION');
557: FND_MESSAGE.SET_TOKEN('DATE',l_juliandate);
558: l_msg_julian_date := FND_MESSAGE.GET;
559:
560: insert_temp_data(3,null,l_msg_inv_file_name,l_msg_julian_date,null,null,null);
561: RETURN;

Line 558: l_msg_julian_date := FND_MESSAGE.GET;

554: l_msg_inv_file_name := FND_MESSAGE.GET;
555:
556: FND_MESSAGE.SET_NAME('FV','FV_CCR_JULIAN_DATE_ACTION');
557: FND_MESSAGE.SET_TOKEN('DATE',l_juliandate);
558: l_msg_julian_date := FND_MESSAGE.GET;
559:
560: insert_temp_data(3,null,l_msg_inv_file_name,l_msg_julian_date,null,null,null);
561: RETURN;
562: end; -- end of julian date check

Line 688: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_TYPE');

684: retcode := -1;
685: l_errbuf := 'Not a valid Daily Refresh file';
686: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
687:
688: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_TYPE');
689: l_msg_inv_file_type := FND_MESSAGE.GET;
690: insert_temp_data(3,null,l_msg_inv_file_type,l_message_action2,null,null,null);
691: RETURN;
692: END IF; -- end of extract type check in 'S'

Line 689: l_msg_inv_file_type := FND_MESSAGE.GET;

685: l_errbuf := 'Not a valid Daily Refresh file';
686: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
687:
688: FND_MESSAGE.SET_NAME('FV','FV_CCR_INVALID_FILE_TYPE');
689: l_msg_inv_file_type := FND_MESSAGE.GET;
690: insert_temp_data(3,null,l_msg_inv_file_type,l_message_action2,null,null,null);
691: RETURN;
692: END IF; -- end of extract type check in 'S'
693: END IF; -- end of file type validation

Line 2682: FND_MESSAGE.SET_NAME('FV','FV_CCR_ASSIGN_PAY_OBJ');

2678:
2679: l_errbuf := 'Processing CCR Data for a,2,3';
2680: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
2681:
2682: FND_MESSAGE.SET_NAME('FV','FV_CCR_ASSIGN_PAY_OBJ');
2683: l_msg_pay_obj := FND_MESSAGE.GET;
2684:
2685: FOR l_ccr_data IN c_ccr_data
2686: LOOP

Line 2683: l_msg_pay_obj := FND_MESSAGE.GET;

2679: l_errbuf := 'Processing CCR Data for a,2,3';
2680: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,l_errbuf);
2681:
2682: FND_MESSAGE.SET_NAME('FV','FV_CCR_ASSIGN_PAY_OBJ');
2683: l_msg_pay_obj := FND_MESSAGE.GET;
2684:
2685: FOR l_ccr_data IN c_ccr_data
2686: LOOP
2687:

Line 2695: FND_MESSAGE.set_NAME('FV','FV_CCR_INVALID_TAXPAYER_NUMBER');

2691:
2692: l_valid_tin := nvl(l_ccr_data.taxpayer_id,l_ccr_data.social_security_number);
2693: IF((l_valid_tin IS NULL or length(l_valid_tin)<>9)
2694: AND l_ccr_data.country = 'USA') THEN
2695: FND_MESSAGE.set_NAME('FV','FV_CCR_INVALID_TAXPAYER_NUMBER');
2696: message_text := FND_MESSAGE.get;
2697: l_errbuf :='Invalid Taxpayer Number: '||nvl(l_valid_tin,'null');
2698: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'main',l_errbuf);
2699: insert_temp_data(3,null,message_text ,null,l_ccr_data.duns||nvl(l_ccr_data.plus_four,''),null,null);

Line 2696: message_text := FND_MESSAGE.get;

2692: l_valid_tin := nvl(l_ccr_data.taxpayer_id,l_ccr_data.social_security_number);
2693: IF((l_valid_tin IS NULL or length(l_valid_tin)<>9)
2694: AND l_ccr_data.country = 'USA') THEN
2695: FND_MESSAGE.set_NAME('FV','FV_CCR_INVALID_TAXPAYER_NUMBER');
2696: message_text := FND_MESSAGE.get;
2697: l_errbuf :='Invalid Taxpayer Number: '||nvl(l_valid_tin,'null');
2698: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'main',l_errbuf);
2699: insert_temp_data(3,null,message_text ,null,l_ccr_data.duns||nvl(l_ccr_data.plus_four,''),null,null);
2700:

Line 2889: FND_MESSAGE.set_NAME('FV','FV_CCR_LBE_CHANGED');

2885:
2886: -- BUG 3839843
2887: IF (l_lbe_change <> l_ccr_data.legal_bus_name) THEN
2888:
2889: FND_MESSAGE.set_NAME('FV','FV_CCR_LBE_CHANGED');
2890: message_text := FND_MESSAGE.get;
2891:
2892: l_errbuf :='Legal Bus Name changed from '||l_lbe_change||' -> '||l_ccr_data.legal_bus_name;
2893: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);

Line 2890: message_text := FND_MESSAGE.get;

2886: -- BUG 3839843
2887: IF (l_lbe_change <> l_ccr_data.legal_bus_name) THEN
2888:
2889: FND_MESSAGE.set_NAME('FV','FV_CCR_LBE_CHANGED');
2890: message_text := FND_MESSAGE.get;
2891:
2892: l_errbuf :='Legal Bus Name changed from '||l_lbe_change||' -> '||l_ccr_data.legal_bus_name;
2893: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);
2894: insert_temp_data(3,null,message_text ,null,l_ccr_data.duns||l_ccr_data.plus_four,null,null);

Line 3785: FND_MESSAGE.set_NAME('FV','FV_CCR_LBE_CHANGED');

3781:
3782: --BUG 3839843
3783: IF (l_lbe_change <> l_ccr_data.legal_bus_name) THEN
3784:
3785: FND_MESSAGE.set_NAME('FV','FV_CCR_LBE_CHANGED');
3786: message_text := FND_MESSAGE.get;
3787:
3788: l_errbuf :='Legal Bus Name changed from '||l_lbe_change||' -> '||l_ccr_data.legal_bus_name;
3789: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);

Line 3786: message_text := FND_MESSAGE.get;

3782: --BUG 3839843
3783: IF (l_lbe_change <> l_ccr_data.legal_bus_name) THEN
3784:
3785: FND_MESSAGE.set_NAME('FV','FV_CCR_LBE_CHANGED');
3786: message_text := FND_MESSAGE.get;
3787:
3788: l_errbuf :='Legal Bus Name changed from '||l_lbe_change||' -> '||l_ccr_data.legal_bus_name;
3789: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'find_code',l_errbuf);
3790: insert_temp_data(3,null,message_text ,null,l_ccr_data.duns||l_ccr_data.plus_four,null,null);

Line 4699: FND_MESSAGE.set_NAME('FV','FV_CCR_DUPLICATE_TAXPAYER_NUM');

4695: OPEN c_vendor_info(l_taxpayer.vendor_id);
4696: FETCH c_vendor_info into l_vendor_id;
4697: CLOSE c_vendor_info;
4698:
4699: FND_MESSAGE.set_NAME('FV','FV_CCR_DUPLICATE_TAXPAYER_NUM');
4700: FND_MESSAGE.set_TOKEN('LISTDUNS',l_duns_list);
4701: FND_MESSAGE.SET_TOKEN('VENDOR', l_vendor_id);
4702: message_text := FND_MESSAGE.get;
4703:

Line 4700: FND_MESSAGE.set_TOKEN('LISTDUNS',l_duns_list);

4696: FETCH c_vendor_info into l_vendor_id;
4697: CLOSE c_vendor_info;
4698:
4699: FND_MESSAGE.set_NAME('FV','FV_CCR_DUPLICATE_TAXPAYER_NUM');
4700: FND_MESSAGE.set_TOKEN('LISTDUNS',l_duns_list);
4701: FND_MESSAGE.SET_TOKEN('VENDOR', l_vendor_id);
4702: message_text := FND_MESSAGE.get;
4703:
4704:

Line 4701: FND_MESSAGE.SET_TOKEN('VENDOR', l_vendor_id);

4697: CLOSE c_vendor_info;
4698:
4699: FND_MESSAGE.set_NAME('FV','FV_CCR_DUPLICATE_TAXPAYER_NUM');
4700: FND_MESSAGE.set_TOKEN('LISTDUNS',l_duns_list);
4701: FND_MESSAGE.SET_TOKEN('VENDOR', l_vendor_id);
4702: message_text := FND_MESSAGE.get;
4703:
4704:
4705: insert_temp_data(3,null,message_text ,null,'ORACLE',null,null);

Line 4702: message_text := FND_MESSAGE.get;

4698:
4699: FND_MESSAGE.set_NAME('FV','FV_CCR_DUPLICATE_TAXPAYER_NUM');
4700: FND_MESSAGE.set_TOKEN('LISTDUNS',l_duns_list);
4701: FND_MESSAGE.SET_TOKEN('VENDOR', l_vendor_id);
4702: message_text := FND_MESSAGE.get;
4703:
4704:
4705: insert_temp_data(3,null,message_text ,null,'ORACLE',null,null);
4706: END LOOP;

Line 4798: FND_MESSAGE.set_NAME('FV','FV_CCR_XML_INACTIVE_DUNS');

4794: WHERE duns = fcpg.duns
4795: AND nvl(plus_four,'N') = nvl(fcpg.plus_four,'N')
4796: ))
4797: LOOP
4798: FND_MESSAGE.set_NAME('FV','FV_CCR_XML_INACTIVE_DUNS');
4799: message_text := FND_MESSAGE.get;
4800: l_errbuf :='Expired/inactive DUNS/DUNS+4: '||crec.duns||'-'||crec.plus_four;
4801: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'main',l_errbuf);
4802: insert_temp_data(3,null,message_text ,null,crec.duns||crec.plus_four,null,null);

Line 4799: message_text := FND_MESSAGE.get;

4795: AND nvl(plus_four,'N') = nvl(fcpg.plus_four,'N')
4796: ))
4797: LOOP
4798: FND_MESSAGE.set_NAME('FV','FV_CCR_XML_INACTIVE_DUNS');
4799: message_text := FND_MESSAGE.get;
4800: l_errbuf :='Expired/inactive DUNS/DUNS+4: '||crec.duns||'-'||crec.plus_four;
4801: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, 'main',l_errbuf);
4802: insert_temp_data(3,null,message_text ,null,crec.duns||crec.plus_four,null,null);
4803: END LOOP;