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

Line 48: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

44: end loop;
45:
46: return l_is_valid;
47: exception when others then
48: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
49: return false;
50: end;
51:
52:

Line 75: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

71: return true;
72: end if;
73: end loop;
74: exception when others then
75: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
76: return false;
77: end;
78:
79:

Line 105: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

101: end loop;
102:
103: return true;
104: exception when others then
105: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
106: return false;
107: end;
108:
109:

Line 152: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

148: end loop;
149:
150: return l_is_valid;
151: exception when others then
152: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
153: return false;
154: end;
155:
156: function validate_fa_revals ( fp_asset_id number

Line 192: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

188: else
189: return true;
190: end if;
191: exception when others then
192: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
193: return false;
194: end;
195:
196:

Line 208: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Begin retirements check');

204:
205: l_retirements := 'X';
206: l_path := g_path||'not_retired_in_curr_year';
207:
208: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Begin retirements check');
209: if not igi_iac_common_utils.any_ret_in_curr_yr(p_book_type_code => fp_book_type_code
210: ,p_asset_id => fp_asset_id
211: ,p_retirements => l_retirements
212: )

Line 214: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Error retirements check');

210: ,p_asset_id => fp_asset_id
211: ,p_retirements => l_retirements
212: )
213: then
214: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Error retirements check');
215: end if;
216:
217: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Retirements '|| l_retirements);
218:

Line 217: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Retirements '|| l_retirements);

213: then
214: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'Error retirements check');
215: end if;
216:
217: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Retirements '|| l_retirements);
218:
219: if l_retirements = 'Y' then
220: return false;
221: else

Line 225: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

221: else
222: return true;
223: end if;
224: exception when others then
225: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
226: return false;
227: end;
228:
229: function not_adjusted_asset ( fp_asset_id number

Line 283: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

279: ELSE
280: RETURN TRUE;
281: END IF;
282: EXCEPTION WHEN others THEN
283: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
284: RETURN FALSE;
285: END Validate_Multiple_Previews;
286:
287: function validate_asset ( fp_asset_id number

Line 346: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'+adding exception');

342: begin
343:
344: l_path := g_path||'add_exception';
345:
346: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'+adding exception');
347: begin
348: fnd_message.set_name( 'IGI', p_mesg_code );
349: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);
350: l_mesg := fnd_message.get;

Line 349: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);

345:
346: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'+adding exception');
347: begin
348: fnd_message.set_name( 'IGI', p_mesg_code );
349: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);
350: l_mesg := fnd_message.get;
351: exception when others then
352: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
353: l_mesg := p_mesg_code;

Line 352: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

348: fnd_message.set_name( 'IGI', p_mesg_code );
349: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);
350: l_mesg := fnd_message.get;
351: exception when others then
352: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
353: l_mesg := p_mesg_code;
354: end;
355: if l_mesg is null then
356: l_mesg := p_mesg_code;

Line 358: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'+mesg is '|| l_mesg);

354: end;
355: if l_mesg is null then
356: l_mesg := p_mesg_code;
357: end if;
358: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'+mesg is '|| l_mesg);
359: fp_exceptions_idx := nvl(fp_exceptions_idx,0) + 1;
360: fp_exceptions ( fp_exceptions_idx).asset_id := fp_asset_id;
361: fp_exceptions ( fp_exceptions_idx).book_type_code := fp_book_type_code;
362: fp_exceptions ( fp_exceptions_idx).reason := l_mesg ;

Line 373: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'+adding exception');

369: begin
370:
371: l_path := g_path||'add_exception';
372:
373: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'+adding exception');
374: begin
375: fnd_message.set_name( 'IGI', p_mesg_code );
376: fnd_message.set_token('REVALUATION_ID',p_token);
377: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);

Line 377: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);

373: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'+adding exception');
374: begin
375: fnd_message.set_name( 'IGI', p_mesg_code );
376: fnd_message.set_token('REVALUATION_ID',p_token);
377: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);
378: l_mesg := fnd_message.get;
379: exception when others then
380: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
381: l_mesg := p_mesg_code;

Line 380: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

376: fnd_message.set_token('REVALUATION_ID',p_token);
377: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);
378: l_mesg := fnd_message.get;
379: exception when others then
380: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
381: l_mesg := p_mesg_code;
382: end;
383: if l_mesg is null then
384: l_mesg := p_mesg_code;

Line 386: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'+mesg is '|| l_mesg);

382: end;
383: if l_mesg is null then
384: l_mesg := p_mesg_code;
385: end if;
386: igi_iac_debug_pkg.debug_other_string(g_excep_level,l_path,'+mesg is '|| l_mesg);
387: fp_exceptions_idx := nvl(fp_exceptions_idx,0) + 1;
388: fp_exceptions ( fp_exceptions_idx).asset_id := fp_asset_id;
389: fp_exceptions ( fp_exceptions_idx).book_type_code := fp_book_type_code;
390: fp_exceptions ( fp_exceptions_idx).reason := l_mesg ;

Line 408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Validating the asset '|| l_asset_num);

404: from fa_additions
405: where asset_id = fp_asset_id
406: ;
407:
408: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Validating the asset '|| l_asset_num);
409:
410: if validate_period_counter
411: ( fp_asset_id => fp_asset_id
412: , fp_book_type_code => fp_book_type_code

Line 416: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The period counter is ok');

412: , fp_book_type_code => fp_book_type_code
413: , fp_period_counter => fp_period_counter
414: )
415: then
416: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The period counter is ok');
417: l_success_ct := l_success_ct + 1;
418: else
419: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
420: add_exception('IGI_IAC_REVAL_EXCEP_PERIOD_CTR');

Line 419: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');

415: then
416: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The period counter is ok');
417: l_success_ct := l_success_ct + 1;
418: else
419: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
420: add_exception('IGI_IAC_REVAL_EXCEP_PERIOD_CTR');
421: l_failure_ct := l_failure_ct + 1;
422: end if;
423:

Line 428: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+The asset has not been adjusted');

424: if not_adjusted_asset ( fp_asset_id => fp_asset_id
425: , fp_book_type_code => fp_book_type_code
426: )
427: then
428: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+The asset has not been adjusted');
429: l_success_ct := l_success_ct + 1;
430: else
431: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
432: add_exception('IGI_IAC_REVAL_EXCEP_ASSET_ADJ');

Line 431: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');

427: then
428: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+The asset has not been adjusted');
429: l_success_ct := l_success_ct + 1;
430: else
431: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
432: add_exception('IGI_IAC_REVAL_EXCEP_ASSET_ADJ');
433: l_failure_ct := l_failure_ct + 1;
434: end if;
435:

Line 441: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The current cost and new cost of the asset are different');

437: , fp_book_type_code => fp_book_type_code
438: , fp_revaluation_id => fp_revaluation_id
439: )
440: then
441: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The current cost and new cost of the asset are different');
442: l_success_ct := l_success_ct + 1;
443: else
444: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
445: add_exception('IGI_IAC_REVAL_EXCEP_SAME_COSTS');

Line 444: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');

440: then
441: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The current cost and new cost of the asset are different');
442: l_success_ct := l_success_ct + 1;
443: else
444: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
445: add_exception('IGI_IAC_REVAL_EXCEP_SAME_COSTS');
446: l_failure_ct := l_failure_ct + 1;
447: end if;
448:

Line 453: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The asset has no pending retirements/reinstatements');

449: if not_retired_in_curr_year ( fp_asset_id => fp_asset_id
450: , fp_book_type_code => fp_book_type_code
451: )
452: then
453: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The asset has no pending retirements/reinstatements');
454: l_success_ct := l_success_ct + 1;
455: else
456: /*For bug no 2647561 changed the name of the message to the right name*/
457: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');

Line 457: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');

453: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The asset has no pending retirements/reinstatements');
454: l_success_ct := l_success_ct + 1;
455: else
456: /*For bug no 2647561 changed the name of the message to the right name*/
457: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
458: add_exception('IGI_IAC_REVAL_EXCEP_PEND_TXNS');
459: l_failure_ct := l_failure_ct + 1;
460: end if;
461:

Line 466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The asset has no pending retirements/reinstatements');

462: if validate_fully_retired ( fp_asset_id => fp_asset_id
463: , fp_book_type_code => fp_book_type_code
464: )
465: then
466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The asset has no pending retirements/reinstatements');
467: l_success_ct := l_success_ct + 1;
468: else
469: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
470: add_exception('IGI_IAC_REVAL_EXCEP_PEND_TXNS');

Line 469: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');

465: then
466: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+The asset has no pending retirements/reinstatements');
467: l_success_ct := l_success_ct + 1;
468: else
469: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
470: add_exception('IGI_IAC_REVAL_EXCEP_PEND_TXNS');
471: l_failure_ct := l_failure_ct + 1;
472: end if;
473:

Line 479: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'the asset has no new transactions that would affect revaluation');

475: , fp_book_type_code => fp_book_type_code
476: , fp_period_counter => fp_period_counter
477: )
478: then
479: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'the asset has no new transactions that would affect revaluation');
480: l_success_ct := l_success_ct + 1;
481: else
482: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
483: add_exception('IGI_IAC_REVAL_EXCEP_NEW_TXNS');

Line 482: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');

478: then
479: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'the asset has no new transactions that would affect revaluation');
480: l_success_ct := l_success_ct + 1;
481: else
482: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
483: add_exception('IGI_IAC_REVAL_EXCEP_NEW_TXNS');
484: l_failure_ct := l_failure_ct + 1;
485: end if;
486:

Line 491: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'the asset has no CORE FA revaluations');

487: if validate_fa_revals ( fp_asset_id => fp_asset_id
488: , fp_book_type_code => fp_book_type_code
489: )
490: then
491: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'the asset has no CORE FA revaluations');
492: l_success_ct := l_success_ct + 1;
493: else
494: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
495: add_exception('IGI_IAC_REVAL_EXCEP_PEND_TXNS');

Line 494: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');

490: then
491: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'the asset has no CORE FA revaluations');
492: l_success_ct := l_success_ct + 1;
493: else
494: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
495: add_exception('IGI_IAC_REVAL_EXCEP_PEND_TXNS');
496: l_failure_ct := l_failure_ct + 1;
497: end if;
498:

Line 506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'the revaluation type is valid');

502: , fp_reval_type => fp_reval_type
503: , fp_period_counter => fp_period_counter
504: )
505: then
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'the revaluation type is valid');
507: l_success_ct := l_success_ct + 1;
508: else
509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
510: add_exception('IGI_IAC_REVAL_EXCEP_REVAL_TYPE');

Line 509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');

505: then
506: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'the revaluation type is valid');
507: l_success_ct := l_success_ct + 1;
508: else
509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
510: add_exception('IGI_IAC_REVAL_EXCEP_REVAL_TYPE');
511: l_failure_ct := l_failure_ct + 1;
512: end if;
513:

Line 521: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'asset not in any other preview revaluation');

517: , fp_period_counter => fp_period_counter
518: , fp_preview_reval_id => l_preview_reval_id
519: )
520: then
521: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'asset not in any other preview revaluation');
522: l_success_ct := l_success_ct + 1;
523: else
524: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
525: add_exception('IGI_IAC_REVAL_EXCEP_PREVIEW',l_preview_reval_id);

Line 524: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');

520: then
521: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'asset not in any other preview revaluation');
522: l_success_ct := l_success_ct + 1;
523: else
524: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Calling Add Exception');
525: add_exception('IGI_IAC_REVAL_EXCEP_PREVIEW',l_preview_reval_id);
526: l_failure_ct := l_failure_ct + 1;
527: end if;
528:

Line 531: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+validation did not do anything');

527: end if;
528:
529: if l_failure_ct = 0 then
530: if l_success_ct = 0 then
531: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+validation did not do anything');
532: else
533: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+validation checks passed');
534: end if;
535: return true ;

Line 533: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+validation checks passed');

529: if l_failure_ct = 0 then
530: if l_success_ct = 0 then
531: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+validation did not do anything');
532: else
533: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+validation checks passed');
534: end if;
535: return true ;
536: else
537: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+validation checks failed');

Line 537: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+validation checks failed');

533: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+validation checks passed');
534: end if;
535: return true ;
536: else
537: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+validation checks failed');
538: return false;
539: end if;
540:
541: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End validation of the asset');

Line 541: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End validation of the asset');

537: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+validation checks failed');
538: return false;
539: end if;
540:
541: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End validation of the asset');
542: exception when others then
543: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
544: fp_exceptions := fp_exceptions_old;
545: fp_exceptions_idx := fp_exceptions_idx_old;

Line 543: igi_iac_debug_pkg.debug_unexpected_msg(l_path);

539: end if;
540:
541: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'End validation of the asset');
542: exception when others then
543: igi_iac_debug_pkg.debug_unexpected_msg(l_path);
544: fp_exceptions := fp_exceptions_old;
545: fp_exceptions_idx := fp_exceptions_idx_old;
546: return false; -- Bug No. 2647561 (Tpradhan) - Replaced "Raise" with "return false" since Raise just raises the OTHERS exception which then propagates
547: -- to Do_Revaluation_Asset where the exception is handled and that procedure returns TRUE instead of FALSE