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_ITR_ACCT_GENERATOR_PKG dependencies on IGI_ITR_ACCT_GENERATOR_PKG

Line 1: PACKAGE BODY IGI_ITR_ACCT_GENERATOR_PKG AS

1: PACKAGE BODY IGI_ITR_ACCT_GENERATOR_PKG AS
2: -- $Header: igiitrrb.pls 120.5.12000000.1 2007/09/12 10:32:32 mbremkum ship $
3: --
4:
5:

Line 14: l_path VARCHAR2(50):= 'IGI.PLSQL.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.';

10: l_event_level number := FND_LOG.LEVEL_EVENT;
11: l_excep_level number := FND_LOG.LEVEL_EXCEPTION;
12: l_error_level number := FND_LOG.LEVEL_ERROR;
13: l_unexp_level number := FND_LOG.LEVEL_UNEXPECTED;
14: l_path VARCHAR2(50):= 'IGI.PLSQL.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.';
15:
16:
17: -- ****************************************************************************
18: -- Private procedure: Display diagnostic message

Line 204: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'start_acct_generator_workflow', l_itemtype, l_itemkey);

200: EXCEPTION
201: WHEN OTHERS THEN
202: x_return_ccid := l_return_ccid_old;
203: x_concat_segs := l_concat_segs_old;
204: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'start_acct_generator_workflow', l_itemtype, l_itemkey);
205: IF ( l_unexp_level >= l_debug_level) THEN
206: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
207: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
208: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

Line 209: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.start_acct_generator_workflow',TRUE);

205: IF ( l_unexp_level >= l_debug_level) THEN
206: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
207: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
208: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
209: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.start_acct_generator_workflow',TRUE);
210: END IF;
211: raise;
212:
213: END start_acct_generator_workflow;

Line 286: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG','account_type', itemtype, itemkey);

282:
283: EXCEPTION
284: WHEN OTHERS THEN
285: result := null;
286: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG','account_type', itemtype, itemkey);
287: IF ( l_unexp_level >= l_debug_level) THEN
288: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
289: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
290: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

Line 291: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.account_type',TRUE);

287: IF ( l_unexp_level >= l_debug_level) THEN
288: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
289: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
290: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
291: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.account_type',TRUE);
292: END IF;
293:
294: raise;
295: END account_type;

Line 369: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'fetch_creation_account', itemtype, itemkey);

365:
366: EXCEPTION
367: WHEN OTHERS THEN
368: result := null;
369: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'fetch_creation_account', itemtype, itemkey);
370: IF ( l_unexp_level >= l_debug_level) THEN
371: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
372: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
373: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

Line 374: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_creation_account',TRUE);

370: IF ( l_unexp_level >= l_debug_level) THEN
371: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
372: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
373: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
374: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_creation_account',TRUE);
375: END IF;
376:
377: raise;
378:

Line 449: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'find_no_of_segs', itemtype, itemkey);

445:
446: EXCEPTION
447: WHEN OTHERS THEN
448: result := null;
449: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'find_no_of_segs', itemtype, itemkey);
450: IF ( l_unexp_level >= l_debug_level) THEN
451: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
452: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
453: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

Line 454: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.find_no_of_segs',TRUE);

450: IF ( l_unexp_level >= l_debug_level) THEN
451: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
452: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
453: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
454: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.find_no_of_segs',TRUE);
455: END IF;
456: raise;
457: END find_no_of_segs;
458:

Line 517: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'increase_counter', itemtype, itemkey);

513:
514: EXCEPTION
515: WHEN OTHERS THEN
516: result := null;
517: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'increase_counter', itemtype, itemkey);
518: IF ( l_unexp_level >= l_debug_level) THEN
519: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
520: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
521: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

Line 522: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.increase_counter',TRUE);

518: IF ( l_unexp_level >= l_debug_level) THEN
519: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
520: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
521: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
522: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.increase_counter',TRUE);
523: END IF;
524: raise;
525: END increase_counter;
526:

Line 613: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'fetch_segmenti_value', itemtype, itemkey);

609:
610: EXCEPTION
611: WHEN OTHERS THEN
612: result := null;
613: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'fetch_segmenti_value', itemtype, itemkey);
614: IF ( l_unexp_level >= l_debug_level) THEN
615: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
616: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
617: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

Line 618: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_segmenti_value',TRUE);

614: IF ( l_unexp_level >= l_debug_level) THEN
615: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
616: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
617: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
618: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_segmenti_value',TRUE);
619: END IF;
620: raise;
621: END fetch_segmenti_value;
622:

Line 686: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'fetch_segmenti_name', itemtype, itemkey);

682:
683: EXCEPTION
684: WHEN OTHERS THEN
685: result := null;
686: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'fetch_segmenti_name', itemtype, itemkey);
687: IF ( l_unexp_level >= l_debug_level) THEN
688: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
689: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
690: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

Line 691: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_segmenti_name',TRUE);

687: IF ( l_unexp_level >= l_debug_level) THEN
688: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
689: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
690: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
691: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_segmenti_name',TRUE);
692: END IF;
693: raise;
694: END fetch_segmenti_name;
695:

Line 740: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.cost_center_value_chosen',TRUE);

736: IF ( l_unexp_level >= l_debug_level) THEN
737: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
738: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
739: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
740: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.cost_center_value_chosen',TRUE);
741: END IF;
742:
743: raise;
744: END cost_center_value_chosen;

Line 789: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'additional_seg_value_chosen', itemtype, itemkey);

785:
786: EXCEPTION
787: WHEN OTHERS THEN
788: result := null;
789: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'additional_seg_value_chosen', itemtype, itemkey);
790: IF ( l_unexp_level >= l_debug_level) THEN
791: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
792: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
793: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

Line 794: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.additional_seg_value_chosen',TRUE);

790: IF ( l_unexp_level >= l_debug_level) THEN
791: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
792: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
793: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
794: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.additional_seg_value_chosen',TRUE);
795: END IF;
796: raise;
797: END additional_seg_value_chosen;
798:

Line 847: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'fetch_additional_seg_name', itemtype, itemkey);

843:
844: EXCEPTION
845: WHEN OTHERS THEN
846: result := null;
847: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'fetch_additional_seg_name', itemtype, itemkey);
848: IF ( l_unexp_level >= l_debug_level) THEN
849: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
850: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
851: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

Line 852: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_additional_seg_name',TRUE);

848: IF ( l_unexp_level >= l_debug_level) THEN
849: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
850: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
851: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
852: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_additional_seg_name',TRUE);
853: END IF;
854: raise;
855: END fetch_additional_seg_name;
856:

Line 919: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'fetch_service_receiving_acct', itemtype, itemkey);

915:
916: EXCEPTION
917: WHEN OTHERS THEN
918: result := null;
919: Wf_Core.Context('IGI_ITR_ACCT_GENERATOR_PKG', 'fetch_service_receiving_acct', itemtype, itemkey);
920: IF ( l_unexp_level >= l_debug_level) THEN
921: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
922: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
923: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);

Line 924: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_service_receiving_acct',TRUE);

920: IF ( l_unexp_level >= l_debug_level) THEN
921: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
922: FND_MESSAGE.SET_TOKEN('CODE',SQLCODE);
923: FND_MESSAGE.SET_TOKEN('MSG', SQLERRM);
924: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_service_receiving_acct',TRUE);
925: END IF;
926: raise;
927: END fetch_service_receiving_acct;
928:

Line 932: END IGI_ITR_ACCT_GENERATOR_PKG;

928:
929:
930: --
931:
932: END IGI_ITR_ACCT_GENERATOR_PKG;