DBA Data[Home] [Help]

APPS.IGI_IMP_IAC_TRANSFER_PKG dependencies on FND_FILE

Line 87: fnd_file.put_line(fnd_file.log, 'The following assets are invalid:');

83: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
84: p_full_path => g_path||'Validate_Assets',
85: p_string => 'Starting Assets Validation');
86:
87: fnd_file.put_line(fnd_file.log, 'The following assets are invalid:');
88:
89: FOR arec in C_Assets LOOP
90:
91: SELECT depreciate_flag

Line 121: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

117: p_string => 'Error: Non_Depreciating asset provided with Depreciation figures');
118:
119: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_NON _DEP');
120: l_errbuf := FND_MESSAGE.GET;
121: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
122:
123: l_assets_valid := FALSE;
124: goto Next_Record;
125: END IF;

Line 143: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

139: 'Revalued Accumulated Depreciation not correct.');
140:
141: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_DEP_RATIO');
142: l_errbuf := FND_MESSAGE.GET;
143: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
144:
145: l_assets_valid := FALSE;
146: goto Next_Record;
147: END IF;

Line 199: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

195: ' than or equal to zero, when revalued cost is greater than historic cost.');
196:
197: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_BACKLOG_NEG');
198: l_errbuf := FND_MESSAGE.GET;
199: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
200:
201: l_assets_valid := FALSE;
202: goto Next_Record;
203: END IF;

Line 214: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

210: p_string => 'Error: Operating Account must be 0. ');
211:
212: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_OP_COST_NOT_ZERO');
213: l_errbuf := FND_MESSAGE.GET;
214: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
215:
216: l_assets_valid := FALSE;
217: goto Next_Record;
218: END IF;

Line 231: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

227: p_string => 'Error: Backlog value greater than the max value permissable');
228:
229: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_MAX_BACKLOG');
230: l_errbuf := FND_MESSAGE.GET;
231: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
232:
233: l_assets_valid := FALSE;
234: goto Next_Record;
235: END IF;

Line 257: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

253: p_string => 'Error: Invalid value for General Fund');
254:
255: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_GEN_FUND');
256: l_errbuf := FND_MESSAGE.GET;
257: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
258:
259: l_assets_valid := FALSE;
260: goto Next_Record;
261: END IF;

Line 274: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

270: p_string => 'Error: Invalid value for Reval Reserve');
271:
272: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_REVAL_RES');
273: l_errbuf := FND_MESSAGE.GET;
274: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
275:
276: l_assets_valid := FALSE;
277: goto Next_Record;
278: END IF;

Line 294: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

290: p_string => 'Error: Invalid value for Operating Account Backlog');
291:
292: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_OP_BACKLOG_POS');
293: l_errbuf := FND_MESSAGE.GET;
294: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
295:
296: l_assets_valid := FALSE;
297: goto Next_Record;
298:

Line 314: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

310: p_string => 'Error: Invalid value for General Fund');
311:
312: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_GEN_FUND');
313: l_errbuf := FND_MESSAGE.GET;
314: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
315:
316: l_assets_valid := FALSE;
317: goto Next_Record;
318: END IF;

Line 332: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

328: p_string => 'Error: Invalid value for Reval Reserve');
329:
330: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_REVAL_RES');
331: l_errbuf := FND_MESSAGE.GET;
332: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
333:
334: l_assets_valid := FALSE;
335: goto Next_Record;
336: END IF;

Line 356: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

352: p_string => 'Error: Invalid value for Revalued YTD Depreciation');
353:
354: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_YTD');
355: l_errbuf := FND_MESSAGE.GET;
356: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
357:
358: l_assets_valid := FALSE;
359: goto Next_Record;
360: END IF;

Line 394: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

390: ' than or equal to zero, when revalued cost is lesser than historic cost.');
391:
392: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_BACKLOG_POS');
393: l_errbuf := FND_MESSAGE.GET;
394: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
395:
396: l_assets_valid := FALSE;
397: goto Next_Record;
398: END IF;

Line 409: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

405: p_string => 'Error: Invalid value for Reval Reserve');
406:
407: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_REVAL_RES_NOT_ZERO');
408: l_errbuf := FND_MESSAGE.GET;
409: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
410:
411: l_assets_valid := FALSE;
412: goto Next_Record;
413: END IF;

Line 427: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

423: p_string => 'Error: Backlog value less than permissable value');
424:
425: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_MIN_BACKLOG');
426: l_errbuf := FND_MESSAGE.GET;
427: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
428:
429: l_assets_valid := FALSE;
430: goto Next_Record;
431: END IF;

Line 444: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

440: p_string => 'Error: Invalid value for General Fund');
441:
442: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_GEN_FUND_NEG');
443: l_errbuf := FND_MESSAGE.GET;
444: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
445:
446: l_assets_valid := FALSE;
447: goto Next_Record;
448:

Line 462: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

458: p_string => 'Error: Invalid value for Operating Account Backlog');
459:
460: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_OP_BACKLOG');
461: l_errbuf := FND_MESSAGE.GET;
462: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
463:
464: l_assets_valid := FALSE;
465: goto Next_Record;
466: END IF;

Line 479: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

475: p_string => 'Error: Invalid value for Operating Account Backlog');
476:
477: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_OP_BACKLOG');
478: l_errbuf := FND_MESSAGE.GET;
479: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
480:
481: l_assets_valid := FALSE;
482: goto Next_Record;
483: END IF;

Line 497: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

493: p_string => 'Error: Invalid value for Operating Account Cost');
494:
495: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_OP_COST');
496: l_errbuf := FND_MESSAGE.GET;
497: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
498:
499: l_assets_valid := FALSE;
500: goto Next_Record;
501: END IF;

Line 519: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

515: p_string => 'Error: Invalid value for Revalued YTD Depreciation');
516:
517: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_YTD');
518: l_errbuf := FND_MESSAGE.GET;
519: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
520:
521: l_assets_valid := FALSE;
522: goto Next_Record;
523: END IF;

Line 550: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

546: p_string => 'Error: Invalid value for Reval Reserve');
547:
548: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_NET_RES_NOT_ZERO');
549: l_errbuf := FND_MESSAGE.GET;
550: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
551:
552: l_assets_valid := FALSE;
553: goto Next_Record;
554: END IF;

Line 565: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

561: p_string => 'Error: Invalid value for Reval Backlog Depreciation');
562:
563: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_ACC_BLOG_NOT_ZERO');
564: l_errbuf := FND_MESSAGE.GET;
565: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
566:
567: l_assets_valid := FALSE;
568: goto Next_Record;
569: END IF;

Line 580: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

576: p_string => 'Error: Invalid value for Revalued YTD Depreciation');
577:
578: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_YTD_NOT_EQUAL');
579: l_errbuf := FND_MESSAGE.GET;
580: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
581:
582: l_assets_valid := FALSE;
583: goto Next_Record;
584: END IF;

Line 594: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

590: p_string => 'Error: Invalid value for Revalued Accumulated Depreciation');
591:
592: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_ACC_DEP_NOT_EQUAL');
593: l_errbuf := FND_MESSAGE.GET;
594: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
595:
596: l_assets_valid := FALSE;
597: goto Next_Record;
598: END IF;

Line 608: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

604: p_string => 'Error: Invalid value for Operating Account Cost');
605:
606: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_OP_CST_NOT_ZERO');
607: l_errbuf := FND_MESSAGE.GET;
608: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
609:
610: l_assets_valid := FALSE;
611: goto Next_Record;
612: END IF;

Line 622: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

618: p_string => 'Error: Invalid value for Operating Account Backlog');
619:
620: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_OP_BLOG_NOT_ZERO');
621: l_errbuf := FND_MESSAGE.GET;
622: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
623:
624: l_assets_valid := FALSE;
625: goto Next_Record;
626: END IF;

Line 635: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);

631: p_string => 'Error: Invalid value for General Fund');
632:
633: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_GEN_FUND_NOT_ZERO');
634: l_errbuf := FND_MESSAGE.GET;
635: fnd_file.put_line(fnd_file.log, arec.asset_id||': '||l_errbuf);
636:
637: l_assets_valid := FALSE;
638: goto Next_Record;
639: END IF;

Line 1632: fnd_file.put_line(fnd_file.log, p_errbuf);

1628: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
1629: p_full_path => g_path||'create_adjustments',
1630: p_remove_from_stack => FALSE);
1631: p_errbuf := FND_MESSAGE.GET;
1632: fnd_file.put_line(fnd_file.log, p_errbuf);
1633: RETURN FALSE ;
1634: END IF;
1635:
1636: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 2004: fnd_file.put_line(fnd_file.log, errbuf);

2000: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
2001: p_full_path => g_path||'transfer_data',
2002: p_remove_from_stack => FALSE);
2003: errbuf := fnd_message.get;
2004: fnd_file.put_line(fnd_file.log, errbuf);
2005: retcode := 0 ;
2006: RETURN ;
2007: END IF;
2008: END LOOP ;

Line 2020: fnd_file.put_line(fnd_file.log, errbuf);

2016: igi_iac_debug_pkg.debug_other_msg(p_level => g_state_level,
2017: p_full_path => g_path||'transfer_data',
2018: p_remove_from_stack => FALSE);
2019: errbuf := fnd_message.get;
2020: fnd_file.put_line(fnd_file.log, errbuf);
2021: retcode := 0 ;
2022: COMMIT WORK;
2023: RETURN ;
2024: END IF;

Line 2049: fnd_file.put_line(fnd_file.log, errbuf);

2045: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2046: p_full_path => g_path||'transfer_data',
2047: p_remove_from_stack => FALSE);
2048: errbuf := fnd_message.get;
2049: fnd_file.put_line(fnd_file.log, errbuf);
2050: raise igi_imp_tfr_error ;
2051: END;
2052:
2053:

Line 2074: fnd_file.put_line(fnd_file.log, errbuf);

2070: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2071: p_full_path => g_path||'transfer_data',
2072: p_remove_from_stack => FALSE);
2073: Errbuf := fnd_message.get;
2074: fnd_file.put_line(fnd_file.log, errbuf);
2075: retcode := 2 ;
2076: COMMIT WORK;
2077: RETURN ;
2078: End If;

Line 2095: fnd_file.put_line(fnd_file.log, errbuf);

2091: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2092: p_full_path => g_path||'transfer_data',
2093: p_remove_from_stack => FALSE);
2094: Errbuf := fnd_message.get;
2095: fnd_file.put_line(fnd_file.log, errbuf);
2096: retcode := 2 ;
2097: COMMIT WORK;
2098: RETURN ;
2099: END IF;

Line 2119: fnd_file.put_line(fnd_file.log, errbuf);

2115: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2116: p_full_path => g_path||'transfer_data',
2117: p_remove_from_stack => FALSE);
2118: errbuf := fnd_message.get;
2119: fnd_file.put_line(fnd_file.log, errbuf);
2120: raise igi_imp_tfr_error ;
2121: END IF;
2122:
2123: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 2142: fnd_file.put_line(fnd_file.log, errbuf);

2138: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2139: p_full_path => g_path||'transfer_data',
2140: p_remove_from_stack => FALSE);
2141: errbuf := fnd_message.get;
2142: fnd_file.put_line(fnd_file.log, errbuf);
2143: raise igi_imp_tfr_error ;
2144: END IF;
2145:
2146:

Line 2208: fnd_file.put_line(fnd_file.log, errbuf);

2204: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2205: p_full_path => g_path||'transfer_data',
2206: p_remove_from_stack => FALSE);
2207: errbuf := fnd_message.get;
2208: fnd_file.put_line(fnd_file.log, errbuf);
2209: raise igi_imp_tfr_error ;
2210: END;
2211:
2212:

Line 2547: fnd_file.put_line(fnd_file.log, errbuf);

2543: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2544: p_full_path => g_path||'transfer_data',
2545: p_remove_from_stack => FALSE);
2546: errbuf := fnd_message.get;
2547: fnd_file.put_line(fnd_file.log, errbuf);
2548: raise igi_imp_tfr_error ;
2549: END IF;
2550:
2551:

Line 2588: fnd_file.put_line(fnd_file.log, errbuf);

2584: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2585: p_full_path => g_path||'transfer_data',
2586: p_remove_from_stack => FALSE);
2587: errbuf := fnd_message.get;
2588: fnd_file.put_line(fnd_file.log, errbuf);
2589: raise igi_imp_tfr_error ;
2590: END IF;
2591:
2592:

Line 2611: fnd_file.put_line(fnd_file.log, errbuf);

2607: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2608: p_full_path => g_path||'transfer_data',
2609: p_remove_from_stack => FALSE);
2610: errbuf := fnd_message.get;
2611: fnd_file.put_line(fnd_file.log, errbuf);
2612: raise igi_imp_tfr_error ;
2613: END IF;
2614:
2615: IF ( p_book_type_code = l_corporate_book ) THEN

Line 2630: fnd_file.put_line(fnd_file.log, errbuf);

2626: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2627: p_full_path => g_path||'transfer_data',
2628: p_remove_from_stack => FALSE);
2629: errbuf := fnd_message.get;
2630: fnd_file.put_line(fnd_file.log, errbuf);
2631: raise igi_imp_tfr_error ;
2632: END ;
2633: BEGIN
2634: SELECT period_num_for_catchup

Line 2645: fnd_file.put_line(fnd_file.log, errbuf);

2641: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2642: p_full_path => g_path||'transfer_data',
2643: p_remove_from_stack => FALSE);
2644: errbuf := fnd_message.get;
2645: fnd_file.put_line(fnd_file.log, errbuf);
2646: raise igi_imp_tfr_error ;
2647: END ;
2648:
2649: IF ( l_prev_prd_rec.period_num < l_period_num_for_catchup ) THEN

Line 2719: fnd_file.put_line(fnd_file.log, errbuf);

2715: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2716: p_full_path => g_path||'transfer_data',
2717: p_remove_from_stack => FALSE);
2718: errbuf := fnd_message.get;
2719: fnd_file.put_line(fnd_file.log, errbuf);
2720: raise igi_imp_tfr_error ;
2721: END;
2722:
2723:

Line 2756: fnd_file.put_line(fnd_file.log, errbuf);

2752: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2753: p_full_path => g_path||'transfer_data',
2754: p_remove_from_stack => FALSE);
2755: errbuf := fnd_message.get;
2756: fnd_file.put_line(fnd_file.log, errbuf);
2757: raise igi_imp_tfr_error ;
2758: ELSE
2759: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2760: p_full_path => g_path||'transfer_data',