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_TRANSFER_PKG dependencies on IGI_IAC_DEBUG_PKG

Line 41: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => g_path||'set_interface_ctrl_status');

37: RETURN ;
38:
39: EXCEPTION
40: WHEN OTHERS THEN
41: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => g_path||'set_interface_ctrl_status');
42: raise igi_imp_tfr_error ;
43: END;
44:
45: FUNCTION Validate_Assets(p_book_type_code in VARCHAR2,

Line 83: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

79:
80: BEGIN
81: l_assets_valid := TRUE;
82:
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:');

Line 108: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

104: END IF;
105:
106: total_depreciation := arec.accum_deprn_hist * (cumm_reval_rate-1) * l_salvage_correction + arec.accum_deprn_hist;
107:
108: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
109: p_full_path => g_path||'Validate_Assets',
110: p_string => 'Processing Asset: '||arec.asset_id);
111:
112: IF upper(l_depreciate) = 'NO' THEN

Line 115: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

111:
112: IF upper(l_depreciate) = 'NO' THEN
113:
114: IF(arec.backlog_mhca <> 0 OR arec.accum_deprn_mhca <> 0) THEN
115: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
116: p_full_path => g_path||'Validate_Assets',
117: p_string => 'Error: Non_Depreciating asset provided with Depreciation figures');
118:
119: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_NON _DEP');

Line 136: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

132:
133: IF ( ( (arec.backlog_mhca + arec.accum_deprn_mhca) > (total_depreciation + 0.02) )OR
134: ((arec.backlog_mhca + arec.accum_deprn_mhca) < (total_depreciation - 0.02) )) THEN
135:
136: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
137: p_full_path => g_path||'Validate_Assets',
138: p_string => 'Error: Sum of Backlog Accumulated Depreciation and'||
139: 'Revalued Accumulated Depreciation not correct.');
140:

Line 185: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

181: AND PERIOD_CLOSE_DATE IS NULL;
182:
183: IF (cumm_reval_rate > 1) THEN
184:
185: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
186: p_full_path => g_path||'Validate_Assets',
187: p_string => 'Revalued cost > Historic Cost');
188:
189: /**************************************************

Line 192: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

188:
189: /**************************************************
190: IF (arec.backlog_mhca < 0) THEN
191:
192: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
193: p_full_path => g_path||'Validate_Assets',
194: p_string => 'Error: Backlog Accumulated Depreciation has to be greater' ||
195: ' than or equal to zero, when revalued cost is greater than historic cost.');
196:

Line 208: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

204: ***************************************************/
205:
206: IF (arec.operating_account_cost <> 0) THEN
207:
208: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
209: p_full_path => g_path||'Validate_Assets',
210: p_string => 'Error: Operating Account must be 0. ');
211:
212: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_OP_COST_NOT_ZERO');

Line 225: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

221:
222: /*************************************************
223: IF (arec.backlog_mhca > (l_max_backlog + 0.1)) THEN
224:
225: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
226: p_full_path => g_path||'Validate_Assets',
227: p_string => 'Error: Backlog value greater than the max value permissable');
228:
229: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_MAX_BACKLOG');

Line 240: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

236: ***************************************************/
237:
238: IF (arec.operating_account_backlog = 0) THEN -- Upliftment
239:
240: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
241: p_full_path => g_path||'Validate_Assets',
242: p_string => 'Asset has undergone Upliftment.');
243:
244: l_adjusted_cost := arec.cost_mhca - arec.cost_hist;

Line 251: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

247:
248: IF ( (arec.general_fund_mhca > (l_general_fund + 0.1)) OR
249: (arec.general_fund_mhca < (l_general_fund - 0.1)) ) THEN
250:
251: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
252: p_full_path => g_path||'Validate_Assets',
253: p_string => 'Error: Invalid value for General Fund');
254:
255: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_GEN_FUND');

Line 268: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

264:
265: IF( (arec.reval_reserve_mhca > (l_reval_reserve + 0.1)) OR
266: (arec.reval_reserve_mhca < (l_reval_reserve - 0.1)) )THEN
267:
268: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
269: p_full_path => g_path||'Validate_Assets',
270: p_string => 'Error: Invalid value for Reval Reserve');
271:
272: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_REVAL_RES');

Line 281: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

277: goto Next_Record;
278: END IF;
279: ELSE -- Mixed Revaluation, Cumm Reval Rate > 1
280:
281: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
282: p_full_path => g_path||'Validate_Assets',
283: p_string => 'Asset has undergone Mixed Revaluation');
284:
285: /***********************************************************

Line 288: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

284:
285: /***********************************************************
286: IF (arec.operating_account_backlog < 0) THEN
287:
288: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
289: p_full_path => g_path||'Validate_Assets',
290: p_string => 'Error: Invalid value for Operating Account Backlog');
291:
292: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_OP_BACKLOG_POS');

Line 308: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

304:
305: IF ( (arec.general_fund_mhca > (l_general_fund + 0.1))
306: OR (arec.general_fund_mhca < (l_general_fund - 0.1)) ) THEN
307:
308: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
309: p_full_path => g_path||'Validate_Assets',
310: p_string => 'Error: Invalid value for General Fund');
311:
312: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_GEN_FUND');

Line 326: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

322:
323: IF( (arec.reval_reserve_mhca > (l_reval_reserve + 0.1))
324: OR (arec.reval_reserve_mhca < (l_reval_reserve - 0.1)) )THEN
325:
326: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
327: p_full_path => g_path||'Validate_Assets',
328: p_string => 'Error: Invalid value for Reval Reserve');
329:
330: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_REVAL_RES');

Line 350: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

346:
347: IF ( (arec.ytd_mhca > (l_ytd_mhca + 0.1)) OR
348: (arec.ytd_mhca < (l_ytd_mhca - 0.1)) ) THEN
349:
350: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
351: p_full_path => g_path||'Validate_Assets',
352: p_string => 'Error: Invalid value for Revalued YTD Depreciation');
353:
354: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_YTD');

Line 365: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

361: ********************************/
362:
363: -- End Bug 5372707
364:
365: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
366: p_full_path => g_path||'Validate_Assets',
367: p_string => 'Asset has valid values. Setting Valid_Flag to Y');
368:
369: UPDATE igi_imp_iac_interface

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

376: AND asset_id = arec.asset_id;
377:
378: ELSIF (cumm_reval_rate < 1) THEN
379:
380: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
381: p_full_path => g_path||'Validate_Assets',
382: p_string => 'Revalued cost < Historic Cost');
383:
384: /***************************************

Line 387: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

383:
384: /***************************************
385: IF (arec.backlog_mhca > 0) THEN
386:
387: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
388: p_full_path => g_path||'Validate_Assets',
389: p_string => 'Error: Backlog Accumulated Depreciation has to be less' ||
390: ' than or equal to zero, when revalued cost is lesser than historic cost.');
391:

Line 403: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

399: ***************************************/
400:
401: IF (arec.reval_reserve_mhca <> 0) THEN
402:
403: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
404: p_full_path => g_path||'Validate_Assets',
405: p_string => 'Error: Invalid value for Reval Reserve');
406:
407: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_REVAL_RES_NOT_ZERO');

Line 421: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

417:
418: /*****************************************
419: IF (arec.backlog_mhca < (l_min_backlog - 0.1)) THEN
420:
421: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
422: p_full_path => g_path||'Validate_Assets',
423: p_string => 'Error: Backlog value less than permissable value');
424:
425: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_MIN_BACKLOG');

Line 438: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

434: IF ( arec.general_fund_mhca <> 0) THEN --Mixed Revaluation, Cumm Reval Rate < 1
435:
436: IF (arec.general_fund_mhca < 0) THEN
437:
438: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
439: p_full_path => g_path||'Validate_Assets',
440: p_string => 'Error: Invalid value for General Fund');
441:
442: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_GEN_FUND_NEG');

Line 456: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

452:
453: IF ( (arec.operating_account_backlog > (l_operating_account_backlog + 0.1)) OR
454: (arec.operating_account_backlog < (l_operating_account_backlog - 0.1)) ) THEN
455:
456: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
457: p_full_path => g_path||'Validate_Assets',
458: p_string => 'Error: Invalid value for Operating Account Backlog');
459:
460: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_OP_BACKLOG');

Line 473: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

469:
470: IF ( (arec.operating_account_backlog > (l_operating_account_backlog + 0.1)) OR
471: (arec.operating_account_backlog < (l_operating_account_backlog - 0.1)) ) THEN
472:
473: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
474: p_full_path => g_path||'Validate_Assets',
475: p_string => 'Error: Invalid value for Operating Account Backlog');
476:
477: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_OP_BACKLOG');

Line 491: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

487:
488: IF ( (arec.operating_account_cost > (l_operating_account_cost + 0.1)) OR
489: (arec.operating_account_cost < (l_operating_account_cost - 0.1)) ) THEN
490:
491: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
492: p_full_path => g_path||'Validate_Assets',
493: p_string => 'Error: Invalid value for Operating Account Cost');
494:
495: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_OP_COST');

Line 513: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

509:
510: IF ( (arec.ytd_mhca > (l_ytd_mhca + 0.1)) OR
511: (arec.ytd_mhca < (l_ytd_mhca - 0.1)) ) THEN
512:
513: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
514: p_full_path => g_path||'Validate_Assets',
515: p_string => 'Error: Invalid value for Revalued YTD Depreciation');
516:
517: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_INV_YTD');

Line 528: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

524: ************************************/
525:
526: -- End Bug 5372707
527:
528: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
529: p_full_path => g_path||'Validate_Assets',
530: p_string => 'Asset has valid values. Setting Valid_Flag to Y');
531:
532: UPDATE igi_imp_iac_interface

Line 544: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

540:
541: ELSE -- cumm_reval_rate = 1
542: IF (arec.reval_reserve_mhca <> 0) THEN
543:
544: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
545: p_full_path => g_path||'Validate_Assets',
546: p_string => 'Error: Invalid value for Reval Reserve');
547:
548: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_NET_RES_NOT_ZERO');

Line 559: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

555:
556: /***************************************
557: IF (arec.backlog_mhca <> 0) THEN
558:
559: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
560: p_full_path => g_path||'Validate_Assets',
561: p_string => 'Error: Invalid value for Reval Backlog Depreciation');
562:
563: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_ACC_BLOG_NOT_ZERO');

Line 574: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

570: ***************************************/
571:
572: IF (arec.ytd_mhca <> arec.ytd_hist) THEN
573:
574: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
575: p_full_path => g_path||'Validate_Assets',
576: p_string => 'Error: Invalid value for Revalued YTD Depreciation');
577:
578: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_YTD_NOT_EQUAL');

Line 588: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

584: END IF;
585: /**********************
586: IF (arec.accum_deprn_mhca <> arec.accum_deprn_hist) THEN
587:
588: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
589: p_full_path => g_path||'Validate_Assets',
590: p_string => 'Error: Invalid value for Revalued Accumulated Depreciation');
591:
592: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_ACC_DEP_NOT_EQUAL');

Line 602: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

598: END IF;
599: ***********************/
600: IF (arec.operating_account_cost <> 0) THEN
601:
602: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
603: p_full_path => g_path||'Validate_Assets',
604: p_string => 'Error: Invalid value for Operating Account Cost');
605:
606: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_OP_CST_NOT_ZERO');

Line 616: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

612: END IF;
613: /**************************
614: IF (arec.operating_account_backlog <> 0) THEN
615:
616: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
617: p_full_path => g_path||'Validate_Assets',
618: p_string => 'Error: Invalid value for Operating Account Backlog');
619:
620: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_OP_BLOG_NOT_ZERO');

Line 629: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

625: goto Next_Record;
626: END IF;
627: IF (arec.general_fund_mhca <> 0) THEN
628:
629: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
630: p_full_path => g_path||'Validate_Assets',
631: p_string => 'Error: Invalid value for General Fund');
632:
633: FND_MESSAGE.SET_NAME('IGI', 'IGI_IMP_IAC_GEN_FUND_NOT_ZERO');

Line 642: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

638: goto Next_Record;
639: END IF;
640: **************************/
641:
642: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
643: p_full_path => g_path||'Validate_Assets',
644: p_string => 'Asset has valid values. Setting Valid_Flag to Y');
645:
646: UPDATE igi_imp_iac_interface

Line 660: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

656: END LOOP;
657:
658: COMMIT WORK;
659:
660: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
661: p_full_path => g_path||'Validate_Assets',
662: p_string => 'End of Asset Validation');
663:
664: RETURN l_assets_valid;

Line 668: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

664: RETURN l_assets_valid;
665:
666: EXCEPTION
667: WHEN OTHERS THEN
668: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
669: p_full_path => g_path||'Validate_Assets',
670: p_string => 'Error while Validating assets..');
671:
672: RETURN FALSE;

Line 735: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => g_path||'trxns_in_open_period');

731: END IF;
732:
733: EXCEPTION
734: WHEN OTHERS THEN
735: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => g_path||'trxns_in_open_period');
736: RETURN FALSE ;
737: END Trxns_In_Open_Period;
738:
739: FUNCTION Prorate_for_Det_Balances (

Line 1066: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_all_dists_YTD');

1062: , fp_prorate_dists_tab => l_YTD_prorate_dists_tab
1063: , fp_prorate_dists_idx => l_YTD_prorate_dists_idx
1064: )
1065: THEN
1066: igi_iac_debug_pkg.debug_other_string(g_error_level,g_path,'+error IGI_IAC_REVAL_UTILITIES.prorate_all_dists_YTD');
1067: return false;
1068: END IF;
1069:
1070: FOR l_all_dist IN C_all_dist (l_fiscal_year )

Line 1093: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1089:
1090: --
1091: -- Get the prorate factors
1092: --
1093: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1094: p_full_path => g_path||'prorate_for_det_balances',
1095: p_string => 'Getting Prorate Factor for Active Distributions...');
1096:
1097: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1097: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1093: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1094: p_full_path => g_path||'prorate_for_det_balances',
1095: p_string => 'Getting Prorate Factor for Active Distributions...');
1096:
1097: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1098: p_full_path => g_path||'prorate_for_det_balances',
1099: p_string => 'Start of prorate to detail');
1100:
1101: GLOBAL_CURRENT_PROC := 'PRORATE_FOR_DET_BALANCES > ' ;

Line 1121: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1117:
1118: --
1119: -- Process each active distribution and create det balances
1120: --
1121: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1122: p_full_path => g_path||'prorate_for_det_balances',
1123: p_string => 'Processing each active distribution ...');
1124:
1125: --Calculating the proration factors

Line 1134: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1130: ELSE
1131: l_prorate_factor:= (l_all_dist.units_assigned/l_total_units);
1132: END IF;
1133:
1134: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1135: p_full_path => g_path||'prorate_for_det_balances',
1136: p_string => 'Processing distribution ---------> '|| l_all_dist.distribution_id);
1137:
1138: IF l_index <> l_total_dists THEN

Line 1139: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1135: p_full_path => g_path||'prorate_for_det_balances',
1136: p_string => 'Processing distribution ---------> '|| l_all_dist.distribution_id);
1137:
1138: IF l_index <> l_total_dists THEN
1139: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1140: p_full_path => g_path||'prorate_for_det_balances',
1141: p_string => 'This is not the last active distribution...');
1142: --
1143: -- Not the last distribution

Line 1178: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1174: ELSE
1175: --
1176: -- Value allocation for the last distribution
1177: --
1178: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1179: p_full_path => g_path||'prorate_for_det_balances',
1180: p_string => 'This is the last active distribution...');
1181:
1182: l_det_adjustment_cost := l_rem_adjusted_cost ;

Line 1249: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1245: ELSE --Inactive Distribution
1246:
1247: l_flag:='N';
1248:
1249: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1250: p_full_path => g_path||'prorate_for_det_balances',
1251: p_string => 'Processing inactive distribution ---------> '|| l_all_dist.distribution_id);
1252:
1253: l_det_adjustment_cost := 0;

Line 1379: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1375: --
1376: -- Create rows in igi_iac_det_balances
1377: --
1378:
1379: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1380: p_full_path => g_path||'prorate_for_det_balances',
1381: p_string => ' -------- Detail Balances values --------');
1382:
1383: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1383: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1379: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1380: p_full_path => g_path||'prorate_for_det_balances',
1381: p_string => ' -------- Detail Balances values --------');
1382:
1383: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1384: p_full_path => g_path||'prorate_for_det_balances',
1385: p_string => ' | adjustment_cost => '
1386: || rpad( l_det_adjustment_cost ,20,' ') ||' |');
1387:

Line 1388: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1384: p_full_path => g_path||'prorate_for_det_balances',
1385: p_string => ' | adjustment_cost => '
1386: || rpad( l_det_adjustment_cost ,20,' ') ||' |');
1387:
1388: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1389: p_full_path => g_path||'prorate_for_det_balances',
1390: p_string => ' | net_book_value => '
1391: || rpad( l_det_net_book_value ,20,' ') ||' |');
1392:

Line 1393: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1389: p_full_path => g_path||'prorate_for_det_balances',
1390: p_string => ' | net_book_value => '
1391: || rpad( l_det_net_book_value ,20,' ') ||' |');
1392:
1393: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1394: p_full_path => g_path||'prorate_for_det_balances',
1395: p_string => ' | reval_reserve_cost => '
1396: || rpad( l_det_reval_reserve_cost ,20,' ') ||' |');
1397:

Line 1398: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1394: p_full_path => g_path||'prorate_for_det_balances',
1395: p_string => ' | reval_reserve_cost => '
1396: || rpad( l_det_reval_reserve_cost ,20,' ') ||' |');
1397:
1398: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1399: p_full_path => g_path||'prorate_for_det_balances',
1400: p_string => ' | reval_reserve_backlog => '
1401: || rpad( l_det_reval_reserve_backlog ,20,' ') ||' |');
1402:

Line 1403: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1399: p_full_path => g_path||'prorate_for_det_balances',
1400: p_string => ' | reval_reserve_backlog => '
1401: || rpad( l_det_reval_reserve_backlog ,20,' ') ||' |');
1402:
1403: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1404: p_full_path => g_path||'prorate_for_det_balances',
1405: p_string => ' | reval_reserve_gen_fund => '
1406: || rpad( l_det_reval_reserve_gen_fund ,20,' ') ||' |');
1407:

Line 1408: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1404: p_full_path => g_path||'prorate_for_det_balances',
1405: p_string => ' | reval_reserve_gen_fund => '
1406: || rpad( l_det_reval_reserve_gen_fund ,20,' ') ||' |');
1407:
1408: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1409: p_full_path => g_path||'prorate_for_det_balances',
1410: p_string => ' | reval_reserve_net => '
1411: || rpad( l_det_reval_reserve_net ,20,' ') ||' |');
1412:

Line 1413: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1409: p_full_path => g_path||'prorate_for_det_balances',
1410: p_string => ' | reval_reserve_net => '
1411: || rpad( l_det_reval_reserve_net ,20,' ') ||' |');
1412:
1413: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1414: p_full_path => g_path||'prorate_for_det_balances',
1415: p_string => ' | operating_acct_cost => '
1416: || rpad( l_det_operating_acct_cost ,20,' ') ||' |');
1417:

Line 1418: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1414: p_full_path => g_path||'prorate_for_det_balances',
1415: p_string => ' | operating_acct_cost => '
1416: || rpad( l_det_operating_acct_cost ,20,' ') ||' |');
1417:
1418: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1419: p_full_path => g_path||'prorate_for_det_balances',
1420: p_string => ' | operating_acct_backlog => '
1421: || rpad( l_det_operating_acct_backlog ,20,' ') ||' |');
1422:

Line 1423: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1419: p_full_path => g_path||'prorate_for_det_balances',
1420: p_string => ' | operating_acct_backlog => '
1421: || rpad( l_det_operating_acct_backlog ,20,' ') ||' |');
1422:
1423: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1424: p_full_path => g_path||'prorate_for_det_balances',
1425: p_string => ' | operating_acct_net => '
1426: || rpad( l_det_operating_acct_net ,20,' ') ||' |');
1427:

Line 1428: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1424: p_full_path => g_path||'prorate_for_det_balances',
1425: p_string => ' | operating_acct_net => '
1426: || rpad( l_det_operating_acct_net ,20,' ') ||' |');
1427:
1428: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1429: p_full_path => g_path||'prorate_for_det_balances',
1430: p_string => ' | operating_acct_ytd => '
1431: || rpad( l_det_operating_acct_ytd ,20,' ') ||' |');
1432:

Line 1433: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1429: p_full_path => g_path||'prorate_for_det_balances',
1430: p_string => ' | operating_acct_ytd => '
1431: || rpad( l_det_operating_acct_ytd ,20,' ') ||' |');
1432:
1433: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1434: p_full_path => g_path||'prorate_for_det_balances',
1435: p_string => ' | deprn_period => '
1436: || rpad( l_det_deprn_period ,20,' ') ||' |');
1437:

Line 1438: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1434: p_full_path => g_path||'prorate_for_det_balances',
1435: p_string => ' | deprn_period => '
1436: || rpad( l_det_deprn_period ,20,' ') ||' |');
1437:
1438: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1439: p_full_path => g_path||'prorate_for_det_balances',
1440: p_string => ' | deprn_ytd => '
1441: || rpad( l_det_deprn_ytd ,20,' ') ||' |');
1442:

Line 1443: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1439: p_full_path => g_path||'prorate_for_det_balances',
1440: p_string => ' | deprn_ytd => '
1441: || rpad( l_det_deprn_ytd ,20,' ') ||' |');
1442:
1443: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1444: p_full_path => g_path||'prorate_for_det_balances',
1445: p_string => ' | deprn_reserve => '
1446: || rpad( l_det_deprn_reserve ,20,' ') ||' |');
1447:

Line 1448: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1444: p_full_path => g_path||'prorate_for_det_balances',
1445: p_string => ' | deprn_reserve => '
1446: || rpad( l_det_deprn_reserve ,20,' ') ||' |');
1447:
1448: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1449: p_full_path => g_path||'prorate_for_det_balances',
1450: p_string => ' | deprn_reserve_backlog => '
1451: || rpad( l_det_deprn_reserve_backlog ,20,' ') ||' |');
1452:

Line 1453: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1449: p_full_path => g_path||'prorate_for_det_balances',
1450: p_string => ' | deprn_reserve_backlog => '
1451: || rpad( l_det_deprn_reserve_backlog ,20,' ') ||' |');
1452:
1453: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1454: p_full_path => g_path||'prorate_for_det_balances',
1455: p_string => ' | general_fund_per => '
1456: || rpad( l_det_general_fund_per ,20,' ') ||' |');
1457:

Line 1458: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1454: p_full_path => g_path||'prorate_for_det_balances',
1455: p_string => ' | general_fund_per => '
1456: || rpad( l_det_general_fund_per ,20,' ') ||' |');
1457:
1458: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1459: p_full_path => g_path||'prorate_for_det_balances',
1460: p_string => ' | general_fund_acc => '
1461: || rpad( l_det_general_fund_acc ,20,' ') ||' |');
1462:

Line 1463: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1459: p_full_path => g_path||'prorate_for_det_balances',
1460: p_string => ' | general_fund_acc => '
1461: || rpad( l_det_general_fund_acc ,20,' ') ||' |');
1462:
1463: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1464: p_full_path => g_path||'prorate_for_det_balances',
1465: p_string => ' | last_reval_date => '
1466: || rpad( l_det_last_reval_date ,20,' ') ||' |');
1467:

Line 1469: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1465: p_string => ' | last_reval_date => '
1466: || rpad( l_det_last_reval_date ,20,' ') ||' |');
1467:
1468:
1469: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1470: p_full_path => g_path||'prorate_for_det_balances',
1471: p_string => ' | current_reval_factor => '
1472: || rpad( l_det_current_reval_factor ,20,' ') ||' |');
1473:

Line 1474: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1470: p_full_path => g_path||'prorate_for_det_balances',
1471: p_string => ' | current_reval_factor => '
1472: || rpad( l_det_current_reval_factor ,20,' ') ||' |');
1473:
1474: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1475: p_full_path => g_path||'prorate_for_det_balances',
1476: p_string => ' | cumulative_reval_factor => '
1477: || rpad( l_det_cumulative_reval_factor ,20,' ') ||' |');
1478:

Line 1479: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1475: p_full_path => g_path||'prorate_for_det_balances',
1476: p_string => ' | cumulative_reval_factor => '
1477: || rpad( l_det_cumulative_reval_factor ,20,' ') ||' |');
1478:
1479: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1480: p_full_path => g_path||'prorate_for_det_balances',
1481: p_string => ' ----------------------------------------');
1482:
1483: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1483: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1479: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1480: p_full_path => g_path||'prorate_for_det_balances',
1481: p_string => ' ----------------------------------------');
1482:
1483: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1484: p_full_path => g_path||'prorate_for_det_balances',
1485: p_string => 'Creating Detail Balances record ....');
1486:
1487:

Line 1517: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1513: x_cumulative_reval_factor => l_det_cumulative_reval_factor ,
1514: x_active_flag => l_flag ,
1515: x_mode => 'R' );
1516:
1517: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1518: p_full_path => g_path||'prorate_for_det_balances',
1519: p_string => ' -------- Historic Deprn Balances values --------');
1520:
1521: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1521: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1517: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1518: p_full_path => g_path||'prorate_for_det_balances',
1519: p_string => ' -------- Historic Deprn Balances values --------');
1520:
1521: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1522: p_full_path => g_path||'prorate_for_det_balances',
1523: p_string => ' | deprn_period => '
1524: || rpad( l_det_hist_deprn_amount ,20,' ') ||' |');
1525:

Line 1526: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1522: p_full_path => g_path||'prorate_for_det_balances',
1523: p_string => ' | deprn_period => '
1524: || rpad( l_det_hist_deprn_amount ,20,' ') ||' |');
1525:
1526: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1527: p_full_path => g_path||'prorate_for_det_balances',
1528: p_string => ' | deprn_ytd => '
1529: || rpad( l_det_hist_deprn_ytd ,20,' ') ||' |');
1530:

Line 1531: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1527: p_full_path => g_path||'prorate_for_det_balances',
1528: p_string => ' | deprn_ytd => '
1529: || rpad( l_det_hist_deprn_ytd ,20,' ') ||' |');
1530:
1531: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1532: p_full_path => g_path||'prorate_for_det_balances',
1533: p_string => ' | deprn_reserve => '
1534: || rpad( l_det_hist_deprn_reserve ,20,' ') ||' |');
1535:

Line 1536: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1532: p_full_path => g_path||'prorate_for_det_balances',
1533: p_string => ' | deprn_reserve => '
1534: || rpad( l_det_hist_deprn_reserve ,20,' ') ||' |');
1535:
1536: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1537: p_full_path => g_path||'prorate_for_det_balances',
1538: p_string => ' ------------------------------------------------');
1539:
1540: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1540: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1536: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1537: p_full_path => g_path||'prorate_for_det_balances',
1538: p_string => ' ------------------------------------------------');
1539:
1540: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1541: p_full_path => g_path||'prorate_for_det_balances',
1542: p_string => 'Creating historic Depreciation Balances record ....');
1543:
1544: l_out_rowid := NULL;

Line 1564: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => g_path||'prorate_for_det_balances');

1560: RETURN TRUE ;
1561: EXCEPTION
1562: WHEN OTHERS
1563: THEN
1564: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => g_path||'prorate_for_det_balances');
1565: RETURN FALSE ;
1566: END Prorate_for_Det_Balances; -- end function
1567:
1568:

Line 1615: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1611: l_adjustment_offset_type := null;
1612:
1613: GLOBAL_CURRENT_PROC := 'CREATE_ADJUSTMENTS > ' ;
1614:
1615: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1616: p_full_path => g_path||'create_adjustments',
1617: p_string => 'Getting GL Info for book ...');
1618:
1619: IF ( NOT ( Igi_Iac_Common_Utils.Get_Book_GL_Info ( p_book_type_code ,

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

1624: FND_MESSAGE.SET_NAME('IGI', 'IGI_IAC_EXCEPTION');
1625: FND_MESSAGE.SET_TOKEN('PACKAGE','igi_imp_iac_transfer_pkg');
1626: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE','Error Getting GL Info.');
1627:
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);

Line 1636: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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,
1637: p_full_path => g_path||'create_adjustments',
1638: p_string => 'Processing Distributions ...');
1639:
1640: FOR drec IN c_dists LOOP

Line 1642: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1638: p_string => 'Processing Distributions ...');
1639:
1640: FOR drec IN c_dists LOOP
1641:
1642: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1643: p_full_path => g_path||'create_adjustments',
1644: p_string => '------------------- Processing Distribution ID ->'
1645: ||drec.distribution_id );
1646:

Line 1753: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1749: l_adjustment_offset_type :='REVAL RESERVE';
1750: l_report_ccid :=l_reval_rsv_ccid;
1751: END IF;
1752:
1753: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1754: p_full_path => g_path||'create_adjustments',
1755: p_string => 'Creating entry for adj '|| l_adj_type
1756: ||' account '|| l_account_type ) ;
1757:

Line 1758: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1754: p_full_path => g_path||'create_adjustments',
1755: p_string => 'Creating entry for adj '|| l_adj_type
1756: ||' account '|| l_account_type ) ;
1757:
1758: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1759: p_full_path => g_path||'create_adjustments',
1760: p_string => '==============Amount = '|| l_amount
1761: ||' DR/CR '|| l_dr_cr_flag ) ;
1762:

Line 1764: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1760: p_string => '==============Amount = '|| l_amount
1761: ||' DR/CR '|| l_dr_cr_flag ) ;
1762:
1763: IF l_amount <> 0 THEN
1764: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1765: p_full_path => g_path||'create_adjustments',
1766: p_string => 'Getting CCID ...') ;
1767:
1768: IF ( NOT ( Igi_Iac_Common_Utils.Get_Account_CCID (

Line 1775: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1771: drec.distribution_id ,
1772: l_account_Type ,
1773: l_ccid ))) THEN
1774:
1775: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1776: p_full_path => g_path||'create_adjustments',
1777: p_string => 'Error : Common Utils Function Get_Account_CCID failed for asset '|| p_asset_id
1778: ||' distribution_id '|| drec.distribution_id
1779: ||' and account type '|| l_Account_type );

Line 1782: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1778: ||' distribution_id '|| drec.distribution_id
1779: ||' and account type '|| l_Account_type );
1780: END IF;
1781:
1782: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1783: p_full_path => g_path||'create_adjustments',
1784: p_string => 'Creating Adjustment ...') ;
1785:
1786: IF l_adj_type='REVAL RESERVE' THEN

Line 1823: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => g_path||'create_adjustments');

1819:
1820: EXCEPTION
1821: WHEN OTHERS THEN
1822: p_errbuf := 'Error Creating adjustments '|| sqlerrm ;
1823: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => g_path||'create_adjustments');
1824: RETURN FALSE ;
1825: END;
1826:
1827:

Line 1965: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1961:
1962: retcode := 2 ;
1963:
1964:
1965: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1966: p_full_path => g_path||'transfer_data',
1967: p_string => '*********** Start of Transfer to IAC... **********');
1968:
1969: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1969: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1965: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1966: p_full_path => g_path||'transfer_data',
1967: p_string => '*********** Start of Transfer to IAC... **********');
1968:
1969: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1970: p_full_path => g_path||'transfer_data',
1971: p_string => '*********** Start of Transfer to IAC... **********');
1972:
1973: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1973: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1969: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1970: p_full_path => g_path||'transfer_data',
1971: p_string => '*********** Start of Transfer to IAC... **********');
1972:
1973: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1974: p_full_path => g_path||'transfer_data',
1975: p_string => '------> Book : '|| rpad(p_book_type_code ,15,' ')||' ') ;
1976:
1977: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 1977: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1973: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1974: p_full_path => g_path||'transfer_data',
1975: p_string => '------> Book : '|| rpad(p_book_type_code ,15,' ')||' ') ;
1976:
1977: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1978: p_full_path => g_path||'transfer_data',
1979: p_string => '------> Category ID : '|| rpad(p_category_id,15,' ') ||' ') ;
1980: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1981: p_full_path => g_path||'transfer_data',

Line 1980: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1976:
1977: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1978: p_full_path => g_path||'transfer_data',
1979: p_string => '------> Category ID : '|| rpad(p_category_id,15,' ') ||' ') ;
1980: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1981: p_full_path => g_path||'transfer_data',
1982: p_string => '-------------------------------------- ');
1983:
1984:

Line 1988: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

1984:
1985: GLOBAL_CURRENT_PROC := 'TRANSFER_DATA > ' ;
1986:
1987:
1988: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1989: p_full_path => g_path||'transfer_data',
1990: p_string => 'Checking availability of book and category for transfer ....');
1991:
1992: -- Check if the category has already been transferred

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

1996: FOR ctrlrec IN c_ctrl LOOP
1997: l_transfer_status := ctrlrec.transfer_Status ;
1998: IF ctrlrec.transfer_status = 'C' THEN
1999: fnd_message.set_name ('IGI','IGI_IMP_IAC_TFR_ALREADY_DONE');
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);

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

2012: set_interface_ctrl_status( p_book_type_code ,
2013: p_category_id ,
2014: 'N' );
2015: fnd_message.set_name ('IGI','IGI_IMP_IAC_NO_PREPARE');
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);

Line 2028: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2024: END IF;
2025: l_reserved_flag := 'Y' ;
2026:
2027:
2028: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2029: p_full_path => g_path||'transfer_data',
2030: p_string => ' Getting the period counter and corporate book ...');
2031:
2032: -- Get the period counter and corporate book

Line 2041: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

2037: FROM igi_imp_iac_controls ic
2038: WHERE ic.book_type_code = p_book_type_code ;
2039: EXCEPTION
2040: WHEN OTHERS THEN
2041: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2042: p_full_path => g_path||'transfer_data',
2043: p_string => 'Error : Fetching period counter from control '|| sqlerrm);
2044: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
2045: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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

2041: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2042: p_full_path => g_path||'transfer_data',
2043: p_string => 'Error : Fetching period counter from control '|| sqlerrm);
2044: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

Line 2054: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2050: raise igi_imp_tfr_error ;
2051: END;
2052:
2053:
2054: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2055: p_full_path => g_path||'transfer_data',
2056: p_string => 'Checking if there have been transactions in Inflation Accounting ...');
2057: l_txns_flag := 'N' ;
2058: For txnrec in c_txns(l_corporate_book) loop

Line 2063: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

2059: l_txns_flag := 'Y' ;
2060: end loop ;
2061:
2062: If l_txns_flag = 'Y' Then
2063: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2064: p_full_path => g_path||'transfer_data',
2065: p_string => 'Error: There have been transactions in Inflation Accounting .');
2066: set_interface_ctrl_status( p_book_type_code ,
2067: p_category_id ,

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

2066: set_interface_ctrl_status( p_book_type_code ,
2067: p_category_id ,
2068: 'E' );
2069: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_TXNS_IN_IAC');
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);

Line 2084: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

2080: --Check for transactions in open period
2081:
2082: IF( NOT Trxns_In_Open_Period(p_book_type_code))
2083: THEN
2084: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2085: p_full_path => g_path||'transfer_data',
2086: p_string => 'Error: There have been open period transactions on the Book.');
2087: set_interface_ctrl_status( p_book_type_code ,
2088: p_category_id ,

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

2087: set_interface_ctrl_status( p_book_type_code ,
2088: p_category_id ,
2089: 'E' );
2090: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRXNS_IN_OPEN_PERD');
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);

Line 2101: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2097: COMMIT WORK;
2098: RETURN ;
2099: END IF;
2100:
2101: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2102: p_full_path => g_path||'transfer_data',
2103: p_string => 'Fetching period Info for counter : '|| l_period_counter );
2104: -- Fetch period Info for the counter
2105: --

Line 2111: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

2107: l_corporate_book ,
2108: l_period_Counter ,
2109: l_prd_rec
2110: ))) THEN
2111: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2112: p_full_path => g_path||'transfer_data',
2113: p_string => 'Fetching period Info for counter : '|| l_period_counter );
2114: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
2115: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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

2111: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2112: p_full_path => g_path||'transfer_data',
2113: p_string => 'Fetching period Info for counter : '|| l_period_counter );
2114: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

Line 2123: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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,
2124: p_full_path => g_path||'transfer_data',
2125: p_string => 'Fetching period Info for closed period , counter : '|| (l_period_counter-1) );
2126:
2127: -- Fetch period Info for the closed period counter

Line 2134: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

2130: l_corporate_book ,
2131: l_period_Counter-1 ,
2132: l_prev_prd_rec
2133: ))) THEN
2134: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2135: p_full_path => g_path||'transfer_data',
2136: p_string => 'Error: Fetching period Info for counter : '|| (l_period_counter-1) );
2137: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
2138: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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

2134: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2135: p_full_path => g_path||'transfer_data',
2136: p_string => 'Error: Fetching period Info for counter : '|| (l_period_counter-1) );
2137: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

Line 2147: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2143: raise igi_imp_tfr_error ;
2144: END IF;
2145:
2146:
2147: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2148: p_full_path => g_path||'transfer_data',
2149: p_string => 'Before creating Revaluations record ...');
2150: -- Create row in igi_iac_revaluations
2151: --

Line 2167: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2163: x_event_id => p_event_id
2164: ) ;
2165:
2166:
2167: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2168: p_full_path => g_path||'transfer_data',
2169: p_string => ' Creating row in igi_iac_Reval_categories ...');
2170: -- Create row in igi_iac_Reval_categories
2171: --

Line 2199: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

2195: fnd_global.user_id
2196: );
2197: EXCEPTION
2198: WHEN OTHERS THEN
2199: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2200: p_full_path => g_path||'transfer_data',
2201: p_string => 'Error : Creating record in igi_iac_reval_categories '
2202: || sqlerrm);
2203: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');

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

2200: p_full_path => g_path||'transfer_data',
2201: p_string => 'Error : Creating record in igi_iac_reval_categories '
2202: || sqlerrm);
2203: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

Line 2213: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2209: raise igi_imp_tfr_error ;
2210: END;
2211:
2212:
2213: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2214: p_full_path => g_path||'transfer_data',
2215: p_string => 'Get all records in the category to process ...');
2216:
2217: open c_booK_class;

Line 2228: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2224: -- Get all records in the category to process.
2225: --
2226: FOR arec IN c_assets LOOP
2227:
2228: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2229: p_full_path => g_path||'transfer_data',
2230: p_string => ' ----------------> Processing Asset ID : '|| arec.asset_id ) ;
2231:
2232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

Line 2232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2228: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2229: p_full_path => g_path||'transfer_data',
2230: p_string => ' ----------------> Processing Asset ID : '|| arec.asset_id ) ;
2231:
2232: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2233: p_full_path => g_path||'transfer_data',
2234: p_string => ' Creating row in igi_iac_transaction_headers for closed period...');
2235: -- Create row in igi_iac_transaction_headers for closed period
2236: --

Line 2270: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2266: AND book_type_code = l_corporate_book
2267: AND adjustment_id_out IS NULL ;
2268:
2269:
2270: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2271: p_full_path => g_path||'transfer_data',
2272: p_string => ' Creating row in igi_iac_transaction_headers ...');
2273: -- Create row in igi_iac_transaction_headers
2274: --

Line 2299: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2295: x_mode => 'R',
2296: x_event_id => p_event_id
2297: ) ;
2298:
2299: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2300: p_full_path => g_path||'transfer_data',
2301: p_string => 'Assigning variables to populate asset balances...');
2302: -- Assign variables to populate asset balances
2303: --

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

2376: 'UPGRADE') THEN
2377:
2378: fnd_message.set_name ('IGI', 'IGI_IMP_IAC_PREP_ERROR');
2379: fnd_message.set_token('ROUTINE','igi_iac_ytd_engine.Calculate_YTD');
2380: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2381: p_full_path => g_path,
2382: p_remove_from_stack => FALSE);
2383: errbuf := fnd_message.get;
2384: Raise IGI_IMP_TFR_ERROR ;

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

2395: l_hist_info.salvage_value,
2396: P_calling_program=>'IMPLEMENTATTION') THEN
2397:
2398: fnd_message.set_token('ROUTINE','igi_iac_salvage_pkg.correction');
2399: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,
2400: p_full_path => g_path,
2401: p_remove_from_stack => FALSE);
2402: errbuf := fnd_message.get;
2403: Raise IGI_IMP_TFR_ERROR ;

Line 2462: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2458: l_corporate_book )) THEN
2459: null;
2460: END IF;
2461:
2462: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2463: p_full_path => g_path||'transfer_data',
2464: p_string => 'Creating row in igi_iac_asset_balances for closed period ...');
2465:
2466: -- Create row in igi_iac_asset_balances for closed period

Line 2488: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2484: x_mode => 'R'
2485: );
2486:
2487:
2488: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2489: p_full_path => g_path||'transfer_data',
2490: p_string => 'Creating row in igi_iac_asset_balances for current period ...');
2491: -- Create row in igi_iac_asset_balances
2492: --

Line 2512: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2508: x_cumulative_reval_factor => l_cumulative_reval_factor ,
2509: x_mode => 'R'
2510: );
2511:
2512: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2513: p_full_path => g_path||'transfer_data',
2514: p_string => ' Creating rows in igi_iac_det_balances for closed period...');
2515: -- Create rows in igi_iac_det_balances for closed period
2516: --

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

2539: p_hist_deprn_reserve => l_hist_deprn_reserve,
2540: p_errbuf => errbuf )))
2541: THEN
2542: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

Line 2552: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2548: raise igi_imp_tfr_error ;
2549: END IF;
2550:
2551:
2552: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2553: p_full_path => g_path||'transfer_data',
2554: p_string => ' Creating rows in igi_iac_det_balances ...');
2555: -- Create rows in igi_iac_det_balances
2556: --

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

2580: p_hist_deprn_reserve => l_hist_deprn_reserve,
2581: p_errbuf => errbuf )))
2582: THEN
2583: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

Line 2593: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2589: raise igi_imp_tfr_error ;
2590: END IF;
2591:
2592:
2593: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2594: p_full_path => g_path||'transfer_data',
2595: p_string => 'Creating rows in igi_iac_adjustments ...');
2596: -- Create rows in igi_iac_adjustments
2597: --

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

2603: l_prev_prd_rec.period_counter ,
2604: errbuf ,
2605: p_event_id ))) THEN
2606: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

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

2622: AND bc.book_type_code = l_corporate_book ;
2623: EXCEPTION
2624: WHEN OTHERS THEN
2625: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

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

2637: WHERE ib.book_type_code = l_corporate_book ;
2638: EXCEPTION
2639: WHEN OTHERS THEN
2640: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

Line 2666: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2662: l_period_for_rates := l_prev_prd_rec.period_counter ;
2663: END IF;
2664:
2665:
2666: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2667: p_full_path => g_path||'transfer_data',
2668: p_string => 'Creating rows in igi_iac_revaluation_rates ...');
2669: -- Create rows in igi_iac_revaluation_rates
2670: --

Line 2710: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

2706: l_out_adj_id
2707: );
2708: EXCEPTION
2709: WHEN OTHERS THEN
2710: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2711: p_full_path => g_path||'transfer_data',
2712: p_string => 'Error : Creating rows in igi_iac_revaluation_rates ...'
2713: ||sqlerrm);
2714: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');

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

2711: p_full_path => g_path||'transfer_data',
2712: p_string => 'Error : Creating rows in igi_iac_revaluation_rates ...'
2713: ||sqlerrm);
2714: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

Line 2724: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2720: raise igi_imp_tfr_error ;
2721: END;
2722:
2723:
2724: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2725: p_full_path => g_path||'transfer_data',
2726: p_string => '>>Processed Asset ID : '|| arec.asset_id ) ;
2727:
2728: UPDATE igi_imp_iac_interface --Fix for Bug 5137813

Line 2735: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2731: AND asset_id = arec.asset_id;
2732:
2733: END LOOP ;
2734:
2735: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2736: p_full_path => g_path||'transfer_data',
2737: p_string => 'Updating igi_iac_category_books run details...');
2738: -- Updating igi_iac_category_books run details...
2739: --

Line 2748: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

2744: WHERE c.book_type_code = l_corporate_book
2745: AND c.category_id = p_category_id ;
2746:
2747: IF ( SQL%ROWCOUNT = 0 ) THEN
2748: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2749: p_full_path => g_path||'transfer_data',
2750: p_string => ' ERROR -> Updating igi_iac_category_books ...'|| sqlerrm );
2751: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
2752: igi_iac_debug_pkg.debug_other_msg(p_level => g_error_level,

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

2748: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
2749: p_full_path => g_path||'transfer_data',
2750: p_string => ' ERROR -> Updating igi_iac_category_books ...'|| sqlerrm );
2751: fnd_message.set_name ('IGI','IGI_IMP_IAC_TRF_GENERIC_ERROR');
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);

Line 2759: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

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',
2761: p_string => SQL%rowcount || ' rows updated.');
2762: END IF;
2763:

Line 2765: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2761: p_string => SQL%rowcount || ' rows updated.');
2762: END IF;
2763:
2764:
2765: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2766: p_full_path => g_path||'transfer_data',
2767: p_string => 'Setting Transfer Status to Completed ...');
2768:
2769: IF (l_assets_valid) THEN --Fix for Bug 5137813

Line 2775: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2771: set_interface_ctrl_status( p_book_type_code ,
2772: p_category_id ,
2773: 'C' );
2774:
2775: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2776: p_full_path => g_path||'transfer_data',
2777: p_string => '*********** Transfer Successfully Completed ... **********');
2778:
2779: retcode := 0 ;

Line 2785: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2781: ELSE
2782: set_interface_ctrl_status( p_book_type_code ,
2783: p_category_id ,
2784: 'N' );
2785: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2786: p_full_path => g_path||'transfer_data',
2787: p_string => '*********** Transfer Partially Completed ... **********');
2788:
2789: retcode := 1 ;

Line 2795: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,

2791: END IF;
2792:
2793: COMMIT WORK;
2794:
2795: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
2796: p_full_path => g_path||'transfer_data',
2797: p_string => '*********** Transfer Successfully Completed ... **********');
2798:
2799:

Line 2815: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => g_path||'transfer_data');

2811: retcode := 2 ;
2812: RETURN ;
2813: WHEN OTHERS THEN
2814: ROLLBACK WORK ;
2815: igi_iac_debug_pkg.debug_unexpected_msg(p_full_path => g_path||'transfer_data');
2816: IF ( l_reserved_flag = 'Y' ) THEN
2817: set_interface_ctrl_status( p_book_type_code ,
2818: p_category_id ,
2819: 'E' );