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.IGI_IMP_IAC_IMPORT_PKG dependencies on FND_MESSAGE

Line 148: FND_MESSAGE.Retrieve(l_message);

144:
145: EXCEPTION
146:
147: WHEN e_request_submit_error THEN
148: FND_MESSAGE.Retrieve(l_message);
149: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
150: p_full_path => l_path_name,
151: p_remove_from_stack => FALSE);
152: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 156: FND_MESSAGE.Retrieve(l_message);

152: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
153: RAISE;
154:
155: WHEN e_request_wait_error THEN
156: FND_MESSAGE.Retrieve(l_message);
157: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
158: p_full_path => l_path_name,
159: p_remove_from_stack => FALSE);
160: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 164: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_NOT_NORM_COMPLETE');

160: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
161: RAISE;
162:
163: WHEN e_loader_failure THEN
164: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_NOT_NORM_COMPLETE');
165: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
166: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
167: p_full_path => l_path_name,
168: p_remove_from_stack => FALSE);

Line 165: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);

161: RAISE;
162:
163: WHEN e_loader_failure THEN
164: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_NOT_NORM_COMPLETE');
165: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
166: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
167: p_full_path => l_path_name,
168: p_remove_from_stack => FALSE);
169: l_message := FND_MESSAGE.Get;

Line 169: l_message := FND_MESSAGE.Get;

165: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
166: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
167: p_full_path => l_path_name,
168: p_remove_from_stack => FALSE);
169: l_message := FND_MESSAGE.Get;
170: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
171: RAISE;
172:
173: WHEN OTHERS THEN

Line 174: FND_MESSAGE.Retrieve(l_message);

170: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
171: RAISE;
172:
173: WHEN OTHERS THEN
174: FND_MESSAGE.Retrieve(l_message);
175: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
176: p_full_path => l_path_name,
177: p_remove_from_stack => FALSE);
178: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 290: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_RECORDS_TO_PROCESS');

286: -- Log count of records to process
287: OPEN c_count_recs;
288: FETCH c_count_recs INTO l_count;
289: CLOSE c_count_recs;
290: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_RECORDS_TO_PROCESS');
291: FND_MESSAGE.Set_Token('RECORD_COUNT',l_count);
292: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
293: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
294: p_full_path => l_path_name,

Line 291: FND_MESSAGE.Set_Token('RECORD_COUNT',l_count);

287: OPEN c_count_recs;
288: FETCH c_count_recs INTO l_count;
289: CLOSE c_count_recs;
290: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_RECORDS_TO_PROCESS');
291: FND_MESSAGE.Set_Token('RECORD_COUNT',l_count);
292: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
293: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
294: p_full_path => l_path_name,
295: p_remove_from_stack => FALSE);

Line 292: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);

288: FETCH c_count_recs INTO l_count;
289: CLOSE c_count_recs;
290: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_RECORDS_TO_PROCESS');
291: FND_MESSAGE.Set_Token('RECORD_COUNT',l_count);
292: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
293: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
294: p_full_path => l_path_name,
295: p_remove_from_stack => FALSE);
296: l_message := FND_MESSAGE.Get;

Line 296: l_message := FND_MESSAGE.Get;

292: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
293: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
294: p_full_path => l_path_name,
295: p_remove_from_stack => FALSE);
296: l_message := FND_MESSAGE.Get;
297: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
298:
299: -- Process records
300: FOR cv_recs_to_process IN c_recs_to_process LOOP

Line 306: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_BOOK');

302:
303: -- If IGIIMPIP, validate the record's book type code
304: IF l_igiimpip THEN
305: IF l_book_type_code <> cv_recs_to_process.book_type_code THEN
306: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_BOOK');
307: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);
308: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
309: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
310: FND_MESSAGE.Set_Token('P_BOOK_TYPE_CODE',l_book_type_code);

Line 307: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);

303: -- If IGIIMPIP, validate the record's book type code
304: IF l_igiimpip THEN
305: IF l_book_type_code <> cv_recs_to_process.book_type_code THEN
306: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_BOOK');
307: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);
308: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
309: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
310: FND_MESSAGE.Set_Token('P_BOOK_TYPE_CODE',l_book_type_code);
311: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

Line 308: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);

304: IF l_igiimpip THEN
305: IF l_book_type_code <> cv_recs_to_process.book_type_code THEN
306: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_BOOK');
307: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);
308: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
309: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
310: FND_MESSAGE.Set_Token('P_BOOK_TYPE_CODE',l_book_type_code);
311: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
312: p_full_path => l_path_name,

Line 309: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);

305: IF l_book_type_code <> cv_recs_to_process.book_type_code THEN
306: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_BOOK');
307: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);
308: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
309: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
310: FND_MESSAGE.Set_Token('P_BOOK_TYPE_CODE',l_book_type_code);
311: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
312: p_full_path => l_path_name,
313: p_remove_from_stack => FALSE);

Line 310: FND_MESSAGE.Set_Token('P_BOOK_TYPE_CODE',l_book_type_code);

306: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_BOOK');
307: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);
308: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
309: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
310: FND_MESSAGE.Set_Token('P_BOOK_TYPE_CODE',l_book_type_code);
311: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
312: p_full_path => l_path_name,
313: p_remove_from_stack => FALSE);
314: l_message := FND_MESSAGE.Get;

Line 314: l_message := FND_MESSAGE.Get;

310: FND_MESSAGE.Set_Token('P_BOOK_TYPE_CODE',l_book_type_code);
311: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
312: p_full_path => l_path_name,
313: p_remove_from_stack => FALSE);
314: l_message := FND_MESSAGE.Get;
315: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
316:
317: l_valid := FALSE;
318: END IF;

Line 324: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_CATEGORY_ID');

320:
321: -- If IGIIMPIP, validate the record's category id
322: IF l_valid AND l_igiimpip THEN
323: IF l_category_id <> cv_recs_to_process.category_id THEN
324: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_CATEGORY_ID');
325: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);
326: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
327: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
328: FND_MESSAGE.Set_Token('P_CATEGORY_ID',l_category_id);

Line 325: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);

321: -- If IGIIMPIP, validate the record's category id
322: IF l_valid AND l_igiimpip THEN
323: IF l_category_id <> cv_recs_to_process.category_id THEN
324: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_CATEGORY_ID');
325: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);
326: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
327: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
328: FND_MESSAGE.Set_Token('P_CATEGORY_ID',l_category_id);
329: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

Line 326: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);

322: IF l_valid AND l_igiimpip THEN
323: IF l_category_id <> cv_recs_to_process.category_id THEN
324: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_CATEGORY_ID');
325: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);
326: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
327: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
328: FND_MESSAGE.Set_Token('P_CATEGORY_ID',l_category_id);
329: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
330: p_full_path => l_path_name,

Line 327: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);

323: IF l_category_id <> cv_recs_to_process.category_id THEN
324: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_CATEGORY_ID');
325: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);
326: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
327: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
328: FND_MESSAGE.Set_Token('P_CATEGORY_ID',l_category_id);
329: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
330: p_full_path => l_path_name,
331: p_remove_from_stack => FALSE);

Line 328: FND_MESSAGE.Set_Token('P_CATEGORY_ID',l_category_id);

324: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_WRONG_CATEGORY_ID');
325: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);
326: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
327: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
328: FND_MESSAGE.Set_Token('P_CATEGORY_ID',l_category_id);
329: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
330: p_full_path => l_path_name,
331: p_remove_from_stack => FALSE);
332: l_message := FND_MESSAGE.Get;

Line 332: l_message := FND_MESSAGE.Get;

328: FND_MESSAGE.Set_Token('P_CATEGORY_ID',l_category_id);
329: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
330: p_full_path => l_path_name,
331: p_remove_from_stack => FALSE);
332: l_message := FND_MESSAGE.Get;
333: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
334:
335: l_valid := FALSE;
336: END IF;

Line 350: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INTFACE_ASSET_ERR');

346: CLOSE c_validate_asset;
347:
348: IF l_count <> 1 THEN
349: -- Log the invalid asset
350: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INTFACE_ASSET_ERR');
351: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
352: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
353: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
354: p_full_path => l_path_name,

Line 351: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);

347:
348: IF l_count <> 1 THEN
349: -- Log the invalid asset
350: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INTFACE_ASSET_ERR');
351: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
352: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
353: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
354: p_full_path => l_path_name,
355: p_remove_from_stack => FALSE);

Line 352: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);

348: IF l_count <> 1 THEN
349: -- Log the invalid asset
350: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INTFACE_ASSET_ERR');
351: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
352: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
353: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
354: p_full_path => l_path_name,
355: p_remove_from_stack => FALSE);
356: l_message := FND_MESSAGE.Get;

Line 356: l_message := FND_MESSAGE.Get;

352: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
353: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
354: p_full_path => l_path_name,
355: p_remove_from_stack => FALSE);
356: l_message := FND_MESSAGE.Get;
357: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
358:
359: l_valid := FALSE;
360: END IF; -- asset count

Line 375: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_TRNSFRD_TO_IAC');

371: CLOSE c_chk_transfer_to_iac;
372:
373: IF l_transfer_status = 'C' THEN
374: -- Log the transfer already completed message.
375: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_TRNSFRD_TO_IAC');
376: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
377: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
378: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);
379: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);

Line 376: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);

372:
373: IF l_transfer_status = 'C' THEN
374: -- Log the transfer already completed message.
375: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_TRNSFRD_TO_IAC');
376: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
377: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
378: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);
379: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);
380: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

Line 377: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);

373: IF l_transfer_status = 'C' THEN
374: -- Log the transfer already completed message.
375: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_TRNSFRD_TO_IAC');
376: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
377: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
378: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);
379: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);
380: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
381: p_full_path => l_path_name,

Line 378: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);

374: -- Log the transfer already completed message.
375: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_TRNSFRD_TO_IAC');
376: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
377: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
378: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);
379: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);
380: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
381: p_full_path => l_path_name,
382: p_remove_from_stack => FALSE);

Line 379: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);

375: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_TRNSFRD_TO_IAC');
376: FND_MESSAGE.Set_Token('ASSET_ID',cv_recs_to_process.asset_id);
377: FND_MESSAGE.Set_Token('ASSET_NUMBER',cv_recs_to_process.asset_number);
378: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',cv_recs_to_process.book_type_code);
379: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);
380: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
381: p_full_path => l_path_name,
382: p_remove_from_stack => FALSE);
383: l_message := FND_MESSAGE.Get;

Line 383: l_message := FND_MESSAGE.Get;

379: FND_MESSAGE.Set_Token('CATEGORY_ID',cv_recs_to_process.category_id);
380: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
381: p_full_path => l_path_name,
382: p_remove_from_stack => FALSE);
383: l_message := FND_MESSAGE.Get;
384: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
385:
386: l_valid := FALSE;
387: END IF; -- transfer status

Line 471: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FAILED_RECS');

467:
468: END LOOP; -- loop through records to process
469:
470: IF l_any_err_recs THEN
471: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FAILED_RECS');
472: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
473: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
474: p_full_path => l_path_name,
475: p_remove_from_stack => FALSE);

Line 472: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);

468: END LOOP; -- loop through records to process
469:
470: IF l_any_err_recs THEN
471: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FAILED_RECS');
472: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
473: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
474: p_full_path => l_path_name,
475: p_remove_from_stack => FALSE);
476: l_message := FND_MESSAGE.Get;

Line 476: l_message := FND_MESSAGE.Get;

472: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
473: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
474: p_full_path => l_path_name,
475: p_remove_from_stack => FALSE);
476: l_message := FND_MESSAGE.Get;
477: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
478: END IF;
479:
480: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FILE_COMPLETE');

Line 480: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FILE_COMPLETE');

476: l_message := FND_MESSAGE.Get;
477: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
478: END IF;
479:
480: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FILE_COMPLETE');
481: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
482: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
483: p_full_path => l_path_name,
484: p_remove_from_stack => FALSE);

Line 481: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);

477: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
478: END IF;
479:
480: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FILE_COMPLETE');
481: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
482: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
483: p_full_path => l_path_name,
484: p_remove_from_stack => FALSE);
485: l_message := FND_MESSAGE.Get;

Line 485: l_message := FND_MESSAGE.Get;

481: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
482: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
483: p_full_path => l_path_name,
484: p_remove_from_stack => FALSE);
485: l_message := FND_MESSAGE.Get;
486: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
487:
488: EXCEPTION
489:

Line 491: FND_MESSAGE.Retrieve(l_message);

487:
488: EXCEPTION
489:
490: WHEN OTHERS THEN
491: FND_MESSAGE.Retrieve(l_message);
492: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
493: p_full_path => l_path_name,
494: p_remove_from_stack => FALSE);
495: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 628: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FILE_LOG');

624: TO_CHAR(cv_group_id.group_id)|| '_' ||
625: 'in.csv';
626:
627: -- Write file name to log file
628: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FILE_LOG');
629: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
630: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
631: p_full_path => l_path_name,
632: p_remove_from_stack => FALSE);

Line 629: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);

625: 'in.csv';
626:
627: -- Write file name to log file
628: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_FILE_LOG');
629: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
630: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
631: p_full_path => l_path_name,
632: p_remove_from_stack => FALSE);
633: l_message := FND_MESSAGE.Get;

Line 633: l_message := FND_MESSAGE.Get;

629: FND_MESSAGE.Set_Token('FILE_NAME',l_file_name);
630: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
631: p_full_path => l_path_name,
632: p_remove_from_stack => FALSE);
633: l_message := FND_MESSAGE.Get;
634: --FND_FILE.Put_Line(FND_FILE.Log,l_message);
635:
636: -- Invoking SQL*Loader to upload the file to the intermediate table.
637: spawn_loader( l_file_name

Line 652: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');

648: COMMIT;
649:
650: EXCEPTION
651: WHEN e_iac_not_enabled THEN
652: FND_MESSAGE.Set_Name('IGI','IGI_IAC_NOT_INSTALLED');
653: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
654: p_full_path => l_path_name,
655: p_remove_from_stack => FALSE);
656: retcode := 2;

Line 657: errbuf := FND_MESSAGE.Get;

653: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
654: p_full_path => l_path_name,
655: p_remove_from_stack => FALSE);
656: retcode := 2;
657: errbuf := FND_MESSAGE.Get;
658:
659: WHEN e_not_null_params THEN
660: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_MANDATORY_PARAMS');
661: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);

Line 660: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_MANDATORY_PARAMS');

656: retcode := 2;
657: errbuf := FND_MESSAGE.Get;
658:
659: WHEN e_not_null_params THEN
660: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_MANDATORY_PARAMS');
661: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
662: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);
663: FND_MESSAGE.Set_Token('CATEGORY_NAME',l_category_name);
664: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

Line 661: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);

657: errbuf := FND_MESSAGE.Get;
658:
659: WHEN e_not_null_params THEN
660: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_MANDATORY_PARAMS');
661: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
662: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);
663: FND_MESSAGE.Set_Token('CATEGORY_NAME',l_category_name);
664: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
665: p_full_path => l_path_name,

Line 662: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);

658:
659: WHEN e_not_null_params THEN
660: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_MANDATORY_PARAMS');
661: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
662: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);
663: FND_MESSAGE.Set_Token('CATEGORY_NAME',l_category_name);
664: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
665: p_full_path => l_path_name,
666: p_remove_from_stack => FALSE);

Line 663: FND_MESSAGE.Set_Token('CATEGORY_NAME',l_category_name);

659: WHEN e_not_null_params THEN
660: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_MANDATORY_PARAMS');
661: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
662: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);
663: FND_MESSAGE.Set_Token('CATEGORY_NAME',l_category_name);
664: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
665: p_full_path => l_path_name,
666: p_remove_from_stack => FALSE);
667: retcode := 2;

Line 668: errbuf := FND_MESSAGE.Get;

664: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
665: p_full_path => l_path_name,
666: p_remove_from_stack => FALSE);
667: retcode := 2;
668: errbuf := FND_MESSAGE.Get;
669:
670: WHEN e_invalid_book THEN
671: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_BOOK');
672: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);

Line 671: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_BOOK');

667: retcode := 2;
668: errbuf := FND_MESSAGE.Get;
669:
670: WHEN e_invalid_book THEN
671: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_BOOK');
672: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
673: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
674: p_full_path => l_path_name,
675: p_remove_from_stack => FALSE);

Line 672: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);

668: errbuf := FND_MESSAGE.Get;
669:
670: WHEN e_invalid_book THEN
671: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_BOOK');
672: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
673: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
674: p_full_path => l_path_name,
675: p_remove_from_stack => FALSE);
676: retcode := 2;

Line 677: errbuf := FND_MESSAGE.Get;

673: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
674: p_full_path => l_path_name,
675: p_remove_from_stack => FALSE);
676: retcode := 2;
677: errbuf := FND_MESSAGE.Get;
678:
679: WHEN e_incomplete_preparation THEN
680: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_PREP_NOT_COMPLETE');
681: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);

Line 680: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_PREP_NOT_COMPLETE');

676: retcode := 2;
677: errbuf := FND_MESSAGE.Get;
678:
679: WHEN e_incomplete_preparation THEN
680: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_PREP_NOT_COMPLETE');
681: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
682: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
683: p_full_path => l_path_name,
684: p_remove_from_stack => FALSE);

Line 681: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);

677: errbuf := FND_MESSAGE.Get;
678:
679: WHEN e_incomplete_preparation THEN
680: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_PREP_NOT_COMPLETE');
681: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
682: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
683: p_full_path => l_path_name,
684: p_remove_from_stack => FALSE);
685: retcode := 2;

Line 686: errbuf := FND_MESSAGE.Get;

682: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
683: p_full_path => l_path_name,
684: p_remove_from_stack => FALSE);
685: retcode := 2;
686: errbuf := FND_MESSAGE.Get;
687:
688: WHEN e_invalid_category_id THEN
689: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_CAT_ID');
690: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);

Line 689: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_CAT_ID');

685: retcode := 2;
686: errbuf := FND_MESSAGE.Get;
687:
688: WHEN e_invalid_category_id THEN
689: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_CAT_ID');
690: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);
691: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
692: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
693: p_full_path => l_path_name,

Line 690: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);

686: errbuf := FND_MESSAGE.Get;
687:
688: WHEN e_invalid_category_id THEN
689: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_CAT_ID');
690: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);
691: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
692: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
693: p_full_path => l_path_name,
694: p_remove_from_stack => FALSE);

Line 691: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);

687:
688: WHEN e_invalid_category_id THEN
689: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_INVALID_CAT_ID');
690: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);
691: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
692: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
693: p_full_path => l_path_name,
694: p_remove_from_stack => FALSE);
695: retcode := 2;

Line 696: errbuf := FND_MESSAGE.Get;

692: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
693: p_full_path => l_path_name,
694: p_remove_from_stack => FALSE);
695: retcode := 2;
696: errbuf := FND_MESSAGE.Get;
697:
698: WHEN e_no_files THEN
699: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_NO_FILES_TO_IMPORT');
700: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);

Line 699: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_NO_FILES_TO_IMPORT');

695: retcode := 2;
696: errbuf := FND_MESSAGE.Get;
697:
698: WHEN e_no_files THEN
699: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_NO_FILES_TO_IMPORT');
700: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
701: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);
702: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
703: p_full_path => l_path_name,

Line 700: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);

696: errbuf := FND_MESSAGE.Get;
697:
698: WHEN e_no_files THEN
699: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_NO_FILES_TO_IMPORT');
700: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
701: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);
702: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
703: p_full_path => l_path_name,
704: p_remove_from_stack => FALSE);

Line 701: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);

697:
698: WHEN e_no_files THEN
699: FND_MESSAGE.Set_Name('IGI','IGI_IMP_IAC_NO_FILES_TO_IMPORT');
700: FND_MESSAGE.Set_Token('BOOK_TYPE_CODE',l_book_type_code);
701: FND_MESSAGE.Set_Token('CATEGORY_ID',l_category_id);
702: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
703: p_full_path => l_path_name,
704: p_remove_from_stack => FALSE);
705: retcode := 1;

Line 706: errbuf := FND_MESSAGE.Get;

702: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
703: p_full_path => l_path_name,
704: p_remove_from_stack => FALSE);
705: retcode := 1;
706: errbuf := FND_MESSAGE.Get;
707:
708: WHEN OTHERS THEN
709: FND_MESSAGE.Retrieve(l_message);
710: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

Line 709: FND_MESSAGE.Retrieve(l_message);

705: retcode := 1;
706: errbuf := FND_MESSAGE.Get;
707:
708: WHEN OTHERS THEN
709: FND_MESSAGE.Retrieve(l_message);
710: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
711: p_full_path => l_path_name,
712: p_remove_from_stack => FALSE);
713: retcode := 2;