DBA Data[Home] [Help]

APPS.IGI_IMP_IAC_IMPORT_PKG dependencies on IGI_IAC_DEBUG_PKG

Line 149: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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);
153: RAISE;

Line 157: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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);
161: RAISE;

Line 166: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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;
170: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 175: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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);
179: RAISE;

Line 293: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

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;
297: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 311: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

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;
315: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 329: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

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;
333: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 353: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

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;
357: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 380: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

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;
384: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 473: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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;
477: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 482: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

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;
486: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 492: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

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);
496: RAISE;

Line 630: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,

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;
634: --FND_FILE.Put_Line(FND_FILE.Log,l_message);

Line 653: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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;
657: errbuf := FND_MESSAGE.Get;

Line 664: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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;
668: errbuf := FND_MESSAGE.Get;

Line 673: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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;
677: errbuf := FND_MESSAGE.Get;

Line 682: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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;
686: errbuf := FND_MESSAGE.Get;

Line 692: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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;
696: errbuf := FND_MESSAGE.Get;

Line 702: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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;
706: errbuf := FND_MESSAGE.Get;

Line 710: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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;
714: errbuf := l_message;