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);
209: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.start_acct_generator_workflow',TRUE);
210: END IF;
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);
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;
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);
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:
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);
291: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.account_type',TRUE);
292: END IF;
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);
291: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.account_type',TRUE);
292: END IF;
293:
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);
291: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.account_type',TRUE);
292: END IF;
293:
294: raise;
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);
374: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_creation_account',TRUE);
375: END IF;
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);
374: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_creation_account',TRUE);
375: END IF;
376:
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);
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;
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);
454: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.find_no_of_segs',TRUE);
455: END IF;
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);
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;
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);
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;
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);
522: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.increase_counter',TRUE);
523: END IF;
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);
522: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.increase_counter',TRUE);
523: END IF;
524: raise;
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);
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;
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);
618: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_segmenti_value',TRUE);
619: END IF;
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);
618: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_segmenti_value',TRUE);
619: END IF;
620: raise;
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);
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;
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);
691: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_segmenti_name',TRUE);
692: END IF;
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);
691: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_segmenti_name',TRUE);
692: END IF;
693: raise;
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);
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;
733: WHEN OTHERS THEN
734: result := null;
735: Wf_Core.Context('IGI_ITR_ACCOUNT_GENERATOR_PKG', 'cost_center_value_chosen', itemtype, itemkey);
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;
734: result := null;
735: Wf_Core.Context('IGI_ITR_ACCOUNT_GENERATOR_PKG', 'cost_center_value_chosen', itemtype, itemkey);
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:
735: Wf_Core.Context('IGI_ITR_ACCOUNT_GENERATOR_PKG', 'cost_center_value_chosen', itemtype, itemkey);
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;
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);
794: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.additional_seg_value_chosen',TRUE);
795: END IF;
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);
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;
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);
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;
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);
852: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_additional_seg_name',TRUE);
853: END IF;
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);
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;
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);
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;
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);
924: FND_LOG.MESSAGE (l_unexp_level,'igi.plsql.igiitrrb.IGI_ITR_ACCT_GENERATOR_PKG.fetch_service_receiving_acct',TRUE);
925: END IF;
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);
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;
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);
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;