56:
57: IF (l_unexp_level >= l_debug_level) THEN
58:
59: IF (P_error_type = 'DEFAULT') THEN
60: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
61: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
62: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
63: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);
64: ELSIF (P_error_type = 'USER') THEN
57: IF (l_unexp_level >= l_debug_level) THEN
58:
59: IF (P_error_type = 'DEFAULT') THEN
60: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
61: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
62: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
63: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);
64: ELSIF (P_error_type = 'USER') THEN
65: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);
58:
59: IF (P_error_type = 'DEFAULT') THEN
60: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
61: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
62: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
63: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);
64: ELSIF (P_error_type = 'USER') THEN
65: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexab.igi_exp_approval_pkg.' || P_module ,TRUE);
66: END IF;
111: ' ** START FRAME_TABLE_HEADER ** ');
112: -- =============== END DEBUG LOG ==================
113:
114: -- Getting the table heads from messages
115: fnd_message.set_name ('IGI', 'IGI_EXP_TABLE_HEAD');
116: l_table_head := fnd_message.get;
117: fnd_message.set_name ('IGI', 'IGI_EXP_LINE');
118: l_line_head := fnd_message.get;
119: fnd_message.set_name ('IGI', 'IGI_EXP_DIA_LIST');
112: -- =============== END DEBUG LOG ==================
113:
114: -- Getting the table heads from messages
115: fnd_message.set_name ('IGI', 'IGI_EXP_TABLE_HEAD');
116: l_table_head := fnd_message.get;
117: fnd_message.set_name ('IGI', 'IGI_EXP_LINE');
118: l_line_head := fnd_message.get;
119: fnd_message.set_name ('IGI', 'IGI_EXP_DIA_LIST');
120: l_desc_head := fnd_message.get;
113:
114: -- Getting the table heads from messages
115: fnd_message.set_name ('IGI', 'IGI_EXP_TABLE_HEAD');
116: l_table_head := fnd_message.get;
117: fnd_message.set_name ('IGI', 'IGI_EXP_LINE');
118: l_line_head := fnd_message.get;
119: fnd_message.set_name ('IGI', 'IGI_EXP_DIA_LIST');
120: l_desc_head := fnd_message.get;
121:
114: -- Getting the table heads from messages
115: fnd_message.set_name ('IGI', 'IGI_EXP_TABLE_HEAD');
116: l_table_head := fnd_message.get;
117: fnd_message.set_name ('IGI', 'IGI_EXP_LINE');
118: l_line_head := fnd_message.get;
119: fnd_message.set_name ('IGI', 'IGI_EXP_DIA_LIST');
120: l_desc_head := fnd_message.get;
121:
122: -- =============== START DEBUG LOG ================
115: fnd_message.set_name ('IGI', 'IGI_EXP_TABLE_HEAD');
116: l_table_head := fnd_message.get;
117: fnd_message.set_name ('IGI', 'IGI_EXP_LINE');
118: l_line_head := fnd_message.get;
119: fnd_message.set_name ('IGI', 'IGI_EXP_DIA_LIST');
120: l_desc_head := fnd_message.get;
121:
122: -- =============== START DEBUG LOG ================
123: DEBUG_LOG_STRING (l_proc_level, 'Frame_table_header.Msg2',
116: l_table_head := fnd_message.get;
117: fnd_message.set_name ('IGI', 'IGI_EXP_LINE');
118: l_line_head := fnd_message.get;
119: fnd_message.set_name ('IGI', 'IGI_EXP_DIA_LIST');
120: l_desc_head := fnd_message.get;
121:
122: -- =============== START DEBUG LOG ================
123: DEBUG_LOG_STRING (l_proc_level, 'Frame_table_header.Msg2',
124: ' Getting table heading ' ||
752:
753: -- Bug 4063076 , End
754:
755: --Bug 5872277 Start
756: fnd_message.set_name ('IGI', 'IGI_EXP_APP_PROC_ERROR');
757:
758: l_msg := fnd_message.get;
759:
760: -- =============== START DEBUG LOG ================
754:
755: --Bug 5872277 Start
756: fnd_message.set_name ('IGI', 'IGI_EXP_APP_PROC_ERROR');
757:
758: l_msg := fnd_message.get;
759:
760: -- =============== START DEBUG LOG ================
761:
762: DEBUG_LOG_STRING (l_proc_level, 'Start_approval_workflow.Msg20',
777: ' SetItemAttrText APP_PROC_ERROR');
778:
779: -- =============== END DEBUG LOG ==================
780:
781: fnd_message.set_name ('IGI', 'IGI_EXP_DU_AUTH_REQ');
782: l_msg := fnd_message.get;
783: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
784: itemkey => l_itemkey,
785: aname => 'DU_AUTH_REQ',
778:
779: -- =============== END DEBUG LOG ==================
780:
781: fnd_message.set_name ('IGI', 'IGI_EXP_DU_AUTH_REQ');
782: l_msg := fnd_message.get;
783: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
784: itemkey => l_itemkey,
785: aname => 'DU_AUTH_REQ',
786: avalue => l_msg);
784: itemkey => l_itemkey,
785: aname => 'DU_AUTH_REQ',
786: avalue => l_msg);
787:
788: fnd_message.set_name ('IGI', 'IGI_EXP_DU_HOLD');
789: l_msg := fnd_message.get;
790: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
791: itemkey => l_itemkey,
792: aname => 'DU_HOLD',
785: aname => 'DU_AUTH_REQ',
786: avalue => l_msg);
787:
788: fnd_message.set_name ('IGI', 'IGI_EXP_DU_HOLD');
789: l_msg := fnd_message.get;
790: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
791: itemkey => l_itemkey,
792: aname => 'DU_HOLD',
793: avalue => l_msg);
791: itemkey => l_itemkey,
792: aname => 'DU_HOLD',
793: avalue => l_msg);
794:
795: fnd_message.set_name ('IGI', 'IGI_EXP_DU_NO_APP_ACTION');
796: l_msg := fnd_message.get;
797: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
798: itemkey => l_itemkey,
799: aname => 'DU_NO_APP_ACTION',
792: aname => 'DU_HOLD',
793: avalue => l_msg);
794:
795: fnd_message.set_name ('IGI', 'IGI_EXP_DU_NO_APP_ACTION');
796: l_msg := fnd_message.get;
797: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
798: itemkey => l_itemkey,
799: aname => 'DU_NO_APP_ACTION',
800: avalue => l_msg);
798: itemkey => l_itemkey,
799: aname => 'DU_NO_APP_ACTION',
800: avalue => l_msg);
801:
802: fnd_message.set_name ('IGI', 'IGI_EXP_DU_PER_AUTH_ACTION');
803: l_msg := fnd_message.get;
804: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
805: itemkey => l_itemkey,
806: aname => 'DU_PER_AUTH_ACTION',
799: aname => 'DU_NO_APP_ACTION',
800: avalue => l_msg);
801:
802: fnd_message.set_name ('IGI', 'IGI_EXP_DU_PER_AUTH_ACTION');
803: l_msg := fnd_message.get;
804: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
805: itemkey => l_itemkey,
806: aname => 'DU_PER_AUTH_ACTION',
807: avalue => l_msg);
805: itemkey => l_itemkey,
806: aname => 'DU_PER_AUTH_ACTION',
807: avalue => l_msg);
808:
809: fnd_message.set_name ('IGI', 'IGI_EXP_LEGAL_NUM_ERROR');
810: l_msg := fnd_message.get;
811: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
812: itemkey => l_itemkey,
813: aname => 'LEGAL_NUM_ERROR',
806: aname => 'DU_PER_AUTH_ACTION',
807: avalue => l_msg);
808:
809: fnd_message.set_name ('IGI', 'IGI_EXP_LEGAL_NUM_ERROR');
810: l_msg := fnd_message.get;
811: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
812: itemkey => l_itemkey,
813: aname => 'LEGAL_NUM_ERROR',
814: avalue => l_msg);
812: itemkey => l_itemkey,
813: aname => 'LEGAL_NUM_ERROR',
814: avalue => l_msg);
815:
816: fnd_message.set_name ('IGI', 'IGI_EXP_NTFY_DU_FAILED');
817: l_msg := fnd_message.get;
818: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
819: itemkey => l_itemkey,
820: aname => 'NTFY_DU_FAILED',
813: aname => 'LEGAL_NUM_ERROR',
814: avalue => l_msg);
815:
816: fnd_message.set_name ('IGI', 'IGI_EXP_NTFY_DU_FAILED');
817: l_msg := fnd_message.get;
818: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
819: itemkey => l_itemkey,
820: aname => 'NTFY_DU_FAILED',
821: avalue => l_msg);
819: itemkey => l_itemkey,
820: aname => 'NTFY_DU_FAILED',
821: avalue => l_msg);
822:
823: fnd_message.set_name ('IGI', 'IGI_EXP_NTFY_DU_REJECT');
824: l_msg := fnd_message.get;
825: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
826: itemkey => l_itemkey,
827: aname => 'NTFY_DU_REJECT',
820: aname => 'NTFY_DU_FAILED',
821: avalue => l_msg);
822:
823: fnd_message.set_name ('IGI', 'IGI_EXP_NTFY_DU_REJECT');
824: l_msg := fnd_message.get;
825: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
826: itemkey => l_itemkey,
827: aname => 'NTFY_DU_REJECT',
828: avalue => l_msg);
826: itemkey => l_itemkey,
827: aname => 'NTFY_DU_REJECT',
828: avalue => l_msg);
829:
830: fnd_message.set_name ('IGI', 'IGI_EXP_NTFY_LEGAL_DU_REJECT');
831: l_msg := fnd_message.get;
832: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
833: itemkey => l_itemkey,
834: aname => 'NTFY_LEGAL_DU_REJECT',
827: aname => 'NTFY_DU_REJECT',
828: avalue => l_msg);
829:
830: fnd_message.set_name ('IGI', 'IGI_EXP_NTFY_LEGAL_DU_REJECT');
831: l_msg := fnd_message.get;
832: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
833: itemkey => l_itemkey,
834: aname => 'NTFY_LEGAL_DU_REJECT',
835: avalue => l_msg);
833: itemkey => l_itemkey,
834: aname => 'NTFY_LEGAL_DU_REJECT',
835: avalue => l_msg);
836:
837: fnd_message.set_name ('IGI', 'IGI_EXP_NTFY_TU_SUCCESS');
838: l_msg := fnd_message.get;
839: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
840: itemkey => l_itemkey,
841: aname => 'NTFY_TU_SUCCESS',
834: aname => 'NTFY_LEGAL_DU_REJECT',
835: avalue => l_msg);
836:
837: fnd_message.set_name ('IGI', 'IGI_EXP_NTFY_TU_SUCCESS');
838: l_msg := fnd_message.get;
839: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
840: itemkey => l_itemkey,
841: aname => 'NTFY_TU_SUCCESS',
842: avalue => l_msg);
840: itemkey => l_itemkey,
841: aname => 'NTFY_TU_SUCCESS',
842: avalue => l_msg);
843:
844: fnd_message.set_name ('IGI', 'IGI_EXP_TU_ACTION_ASSIGNMENTS');
845: l_msg := fnd_message.get;
846: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
847: itemkey => l_itemkey,
848: aname => 'TU_ACTION_ASSIGNMENTS',
841: aname => 'NTFY_TU_SUCCESS',
842: avalue => l_msg);
843:
844: fnd_message.set_name ('IGI', 'IGI_EXP_TU_ACTION_ASSIGNMENTS');
845: l_msg := fnd_message.get;
846: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
847: itemkey => l_itemkey,
848: aname => 'TU_ACTION_ASSIGNMENTS',
849: avalue => l_msg);
847: itemkey => l_itemkey,
848: aname => 'TU_ACTION_ASSIGNMENTS',
849: avalue => l_msg);
850:
851: fnd_message.set_name ('IGI', 'IGI_EXP_TU_ACTION_ERROR');
852: l_msg := fnd_message.get;
853: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
854: itemkey => l_itemkey,
855: aname => 'TU_ACTION_ERROR',
848: aname => 'TU_ACTION_ASSIGNMENTS',
849: avalue => l_msg);
850:
851: fnd_message.set_name ('IGI', 'IGI_EXP_TU_ACTION_ERROR');
852: l_msg := fnd_message.get;
853: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
854: itemkey => l_itemkey,
855: aname => 'TU_ACTION_ERROR',
856: avalue => l_msg);
854: itemkey => l_itemkey,
855: aname => 'TU_ACTION_ERROR',
856: avalue => l_msg);
857:
858: fnd_message.set_name ('IGI', 'IGI_EXP_TU_AUTH_ACTION');
859: l_msg := fnd_message.get;
860: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
861: itemkey => l_itemkey,
862: aname => 'TU_AUTH_ACTION',
855: aname => 'TU_ACTION_ERROR',
856: avalue => l_msg);
857:
858: fnd_message.set_name ('IGI', 'IGI_EXP_TU_AUTH_ACTION');
859: l_msg := fnd_message.get;
860: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
861: itemkey => l_itemkey,
862: aname => 'TU_AUTH_ACTION',
863: avalue => l_msg);
861: itemkey => l_itemkey,
862: aname => 'TU_AUTH_ACTION',
863: avalue => l_msg);
864:
865: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_AUTH_ACTION');
866: l_msg := fnd_message.get;
867: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
868: itemkey => l_itemkey,
869: aname => 'TU_DU_AUTH_ACTION',
862: aname => 'TU_AUTH_ACTION',
863: avalue => l_msg);
864:
865: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_AUTH_ACTION');
866: l_msg := fnd_message.get;
867: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
868: itemkey => l_itemkey,
869: aname => 'TU_DU_AUTH_ACTION',
870: avalue => l_msg);
868: itemkey => l_itemkey,
869: aname => 'TU_DU_AUTH_ACTION',
870: avalue => l_msg);
871:
872: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_COMPLETE');
873: l_msg := fnd_message.get;
874: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
875: itemkey => l_itemkey,
876: aname => 'TU_DU_COMPLETE',
869: aname => 'TU_DU_AUTH_ACTION',
870: avalue => l_msg);
871:
872: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_COMPLETE');
873: l_msg := fnd_message.get;
874: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
875: itemkey => l_itemkey,
876: aname => 'TU_DU_COMPLETE',
877: avalue => l_msg);
875: itemkey => l_itemkey,
876: aname => 'TU_DU_COMPLETE',
877: avalue => l_msg);
878:
879: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_HOLD');
880: l_msg := fnd_message.get;
881: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
882: itemkey => l_itemkey,
883: aname => 'TU_DU_HOLD',
876: aname => 'TU_DU_COMPLETE',
877: avalue => l_msg);
878:
879: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_HOLD');
880: l_msg := fnd_message.get;
881: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
882: itemkey => l_itemkey,
883: aname => 'TU_DU_HOLD',
884: avalue => l_msg);
882: itemkey => l_itemkey,
883: aname => 'TU_DU_HOLD',
884: avalue => l_msg);
885:
886: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_HOLD_REMOVE');
887: l_msg := fnd_message.get;
888: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
889: itemkey => l_itemkey,
890: aname => 'TU_DU_HOLD_REMOVE',
883: aname => 'TU_DU_HOLD',
884: avalue => l_msg);
885:
886: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_HOLD_REMOVE');
887: l_msg := fnd_message.get;
888: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
889: itemkey => l_itemkey,
890: aname => 'TU_DU_HOLD_REMOVE',
891: avalue => l_msg);
889: itemkey => l_itemkey,
890: aname => 'TU_DU_HOLD_REMOVE',
891: avalue => l_msg);
892:
893: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_NO_APP_ACTION');
894: l_msg := fnd_message.get;
895: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
896: itemkey => l_itemkey,
897: aname => 'TU_DU_NO_APP_ACTION',
890: aname => 'TU_DU_HOLD_REMOVE',
891: avalue => l_msg);
892:
893: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_NO_APP_ACTION');
894: l_msg := fnd_message.get;
895: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
896: itemkey => l_itemkey,
897: aname => 'TU_DU_NO_APP_ACTION',
898: avalue => l_msg);
896: itemkey => l_itemkey,
897: aname => 'TU_DU_NO_APP_ACTION',
898: avalue => l_msg);
899:
900: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_PER_AUTH_ACTION');
901: l_msg := fnd_message.get;
902: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
903: itemkey => l_itemkey,
904: aname => 'TU_DU_PER_AUTH_ACTION',
897: aname => 'TU_DU_NO_APP_ACTION',
898: avalue => l_msg);
899:
900: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_PER_AUTH_ACTION');
901: l_msg := fnd_message.get;
902: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
903: itemkey => l_itemkey,
904: aname => 'TU_DU_PER_AUTH_ACTION',
905: avalue => l_msg);
903: itemkey => l_itemkey,
904: aname => 'TU_DU_PER_AUTH_ACTION',
905: avalue => l_msg);
906:
907: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_REMAIN');
908: l_msg := fnd_message.get;
909: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
910: itemkey => l_itemkey,
911: aname => 'TU_DU_REMAIN',
904: aname => 'TU_DU_PER_AUTH_ACTION',
905: avalue => l_msg);
906:
907: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_REMAIN');
908: l_msg := fnd_message.get;
909: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
910: itemkey => l_itemkey,
911: aname => 'TU_DU_REMAIN',
912: avalue => l_msg);
910: itemkey => l_itemkey,
911: aname => 'TU_DU_REMAIN',
912: avalue => l_msg);
913:
914: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_REMOVE');
915: l_msg := fnd_message.get;
916: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
917: itemkey => l_itemkey,
918: aname => 'TU_DU_REMOVE',
911: aname => 'TU_DU_REMAIN',
912: avalue => l_msg);
913:
914: fnd_message.set_name ('IGI', 'IGI_EXP_TU_DU_REMOVE');
915: l_msg := fnd_message.get;
916: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
917: itemkey => l_itemkey,
918: aname => 'TU_DU_REMOVE',
919: avalue => l_msg);
917: itemkey => l_itemkey,
918: aname => 'TU_DU_REMOVE',
919: avalue => l_msg);
920:
921: fnd_message.set_name ('IGI', 'IGI_EXP_TU_EMP_SETUP_ERROR');
922: l_msg := fnd_message.get;
923: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
924: itemkey => l_itemkey,
925: aname => 'TU_EMP_SETUP_ERROR',
918: aname => 'TU_DU_REMOVE',
919: avalue => l_msg);
920:
921: fnd_message.set_name ('IGI', 'IGI_EXP_TU_EMP_SETUP_ERROR');
922: l_msg := fnd_message.get;
923: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
924: itemkey => l_itemkey,
925: aname => 'TU_EMP_SETUP_ERROR',
926: avalue => l_msg);
924: itemkey => l_itemkey,
925: aname => 'TU_EMP_SETUP_ERROR',
926: avalue => l_msg);
927:
928: fnd_message.set_name ('IGI', 'IGI_EXP_TU_LEGAL_NUM_ERROR');
929: l_msg := fnd_message.get;
930: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
931: itemkey => l_itemkey,
932: aname => 'TU_LEGAL_NUM_ERROR',
925: aname => 'TU_EMP_SETUP_ERROR',
926: avalue => l_msg);
927:
928: fnd_message.set_name ('IGI', 'IGI_EXP_TU_LEGAL_NUM_ERROR');
929: l_msg := fnd_message.get;
930: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
931: itemkey => l_itemkey,
932: aname => 'TU_LEGAL_NUM_ERROR',
933: avalue => l_msg);
931: itemkey => l_itemkey,
932: aname => 'TU_LEGAL_NUM_ERROR',
933: avalue => l_msg);
934:
935: fnd_message.set_name ('IGI', 'IGI_EXP_TU_NO_PARENT');
936: l_msg := fnd_message.get;
937: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
938: itemkey => l_itemkey,
939: aname => 'TU_NO_PARENT',
932: aname => 'TU_LEGAL_NUM_ERROR',
933: avalue => l_msg);
934:
935: fnd_message.set_name ('IGI', 'IGI_EXP_TU_NO_PARENT');
936: l_msg := fnd_message.get;
937: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
938: itemkey => l_itemkey,
939: aname => 'TU_NO_PARENT',
940: avalue => l_msg);
938: itemkey => l_itemkey,
939: aname => 'TU_NO_PARENT',
940: avalue => l_msg);
941:
942: fnd_message.set_name ('IGI', 'IGI_EXP_TU_NO_USER_ERROR');
943: l_msg := fnd_message.get;
944: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
945: itemkey => l_itemkey,
946: aname => 'TU_NO_USER_ERROR',
939: aname => 'TU_NO_PARENT',
940: avalue => l_msg);
941:
942: fnd_message.set_name ('IGI', 'IGI_EXP_TU_NO_USER_ERROR');
943: l_msg := fnd_message.get;
944: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
945: itemkey => l_itemkey,
946: aname => 'TU_NO_USER_ERROR',
947: avalue => l_msg);
945: itemkey => l_itemkey,
946: aname => 'TU_NO_USER_ERROR',
947: avalue => l_msg);
948:
949: fnd_message.set_name ('IGI', 'IGI_EXP_TU_NOT_ASSG_POS_ERROR');
950: l_msg := fnd_message.get;
951: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
952: itemkey => l_itemkey,
953: aname => 'TU_NOT_ASSG_POS_ERROR',
946: aname => 'TU_NO_USER_ERROR',
947: avalue => l_msg);
948:
949: fnd_message.set_name ('IGI', 'IGI_EXP_TU_NOT_ASSG_POS_ERROR');
950: l_msg := fnd_message.get;
951: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
952: itemkey => l_itemkey,
953: aname => 'TU_NOT_ASSG_POS_ERROR',
954: avalue => l_msg);
952: itemkey => l_itemkey,
953: aname => 'TU_NOT_ASSG_POS_ERROR',
954: avalue => l_msg);
955:
956: fnd_message.set_name ('IGI', 'IGI_EXP_TU_NOT_SETUP_EMP_ERR');
957: l_msg := fnd_message.get;
958: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
959: itemkey => l_itemkey,
960: aname => 'TU_NOT_SETUP_EMP_ERROR',
953: aname => 'TU_NOT_ASSG_POS_ERROR',
954: avalue => l_msg);
955:
956: fnd_message.set_name ('IGI', 'IGI_EXP_TU_NOT_SETUP_EMP_ERR');
957: l_msg := fnd_message.get;
958: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
959: itemkey => l_itemkey,
960: aname => 'TU_NOT_SETUP_EMP_ERROR',
961: avalue => l_msg);
959: itemkey => l_itemkey,
960: aname => 'TU_NOT_SETUP_EMP_ERROR',
961: avalue => l_msg);
962:
963: fnd_message.set_name ('IGI', 'IGI_EXP_TU_PICK_AUTH');
964: l_msg := fnd_message.get;
965: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
966: itemkey => l_itemkey,
967: aname => 'TU_PICK_AUTH',
960: aname => 'TU_NOT_SETUP_EMP_ERROR',
961: avalue => l_msg);
962:
963: fnd_message.set_name ('IGI', 'IGI_EXP_TU_PICK_AUTH');
964: l_msg := fnd_message.get;
965: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
966: itemkey => l_itemkey,
967: aname => 'TU_PICK_AUTH',
968: avalue => l_msg);
966: itemkey => l_itemkey,
967: aname => 'TU_PICK_AUTH',
968: avalue => l_msg);
969:
970: fnd_message.set_name ('IGI', 'IGI_EXP_TU_PICK_NEW_AUTH');
971: l_msg := fnd_message.get;
972: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
973: itemkey => l_itemkey,
974: aname => 'TU_PICK_NEW_AUTH',
967: aname => 'TU_PICK_AUTH',
968: avalue => l_msg);
969:
970: fnd_message.set_name ('IGI', 'IGI_EXP_TU_PICK_NEW_AUTH');
971: l_msg := fnd_message.get;
972: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
973: itemkey => l_itemkey,
974: aname => 'TU_PICK_NEW_AUTH',
975: avalue => l_msg);
973: itemkey => l_itemkey,
974: aname => 'TU_PICK_NEW_AUTH',
975: avalue => l_msg);
976:
977: fnd_message.set_name ('IGI', 'IGI_EXP_TU_PICK_NEW_AUTH_LIST');
978: l_msg := fnd_message.get;
979: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
980: itemkey => l_itemkey,
981: aname => 'TU_PICK_NEW_AUTH_LIST',
974: aname => 'TU_PICK_NEW_AUTH',
975: avalue => l_msg);
976:
977: fnd_message.set_name ('IGI', 'IGI_EXP_TU_PICK_NEW_AUTH_LIST');
978: l_msg := fnd_message.get;
979: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
980: itemkey => l_itemkey,
981: aname => 'TU_PICK_NEW_AUTH_LIST',
982: avalue => l_msg);
980: itemkey => l_itemkey,
981: aname => 'TU_PICK_NEW_AUTH_LIST',
982: avalue => l_msg);
983:
984: fnd_message.set_name ('IGI', 'IGI_EXP_TU_POS_ASSG_ERROR');
985: l_msg := fnd_message.get;
986: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
987: itemkey => l_itemkey,
988: aname => 'TU_POS_ASSG_ERROR',
981: aname => 'TU_PICK_NEW_AUTH_LIST',
982: avalue => l_msg);
983:
984: fnd_message.set_name ('IGI', 'IGI_EXP_TU_POS_ASSG_ERROR');
985: l_msg := fnd_message.get;
986: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
987: itemkey => l_itemkey,
988: aname => 'TU_POS_ASSG_ERROR',
989: avalue => l_msg);
987: itemkey => l_itemkey,
988: aname => 'TU_POS_ASSG_ERROR',
989: avalue => l_msg);
990:
991: fnd_message.set_name ('IGI', 'IGI_EXP_TU_REQ_AUTHORIZATION');
992: l_msg := fnd_message.get;
993: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
994: itemkey => l_itemkey,
995: aname => 'TU_REQ_AUTHORIZATION',
988: aname => 'TU_POS_ASSG_ERROR',
989: avalue => l_msg);
990:
991: fnd_message.set_name ('IGI', 'IGI_EXP_TU_REQ_AUTHORIZATION');
992: l_msg := fnd_message.get;
993: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
994: itemkey => l_itemkey,
995: aname => 'TU_REQ_AUTHORIZATION',
996: avalue => l_msg);
994: itemkey => l_itemkey,
995: aname => 'TU_REQ_AUTHORIZATION',
996: avalue => l_msg);
997:
998: fnd_message.set_name ('IGI', 'IGI_EXP_TU_RET_ATTN');
999: l_msg := fnd_message.get;
1000: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1001: itemkey => l_itemkey,
1002: aname => 'TU_RET_ATTN',
995: aname => 'TU_REQ_AUTHORIZATION',
996: avalue => l_msg);
997:
998: fnd_message.set_name ('IGI', 'IGI_EXP_TU_RET_ATTN');
999: l_msg := fnd_message.get;
1000: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1001: itemkey => l_itemkey,
1002: aname => 'TU_RET_ATTN',
1003: avalue => l_msg);
1001: itemkey => l_itemkey,
1002: aname => 'TU_RET_ATTN',
1003: avalue => l_msg);
1004:
1005: fnd_message.set_name ('IGI', 'IGI_EXP_TU_VAL_HIER_POS_ERROR');
1006: l_msg := fnd_message.get;
1007: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1008: itemkey => l_itemkey,
1009: aname => 'TU_VAL_HIER_POS_ERROR',
1002: aname => 'TU_RET_ATTN',
1003: avalue => l_msg);
1004:
1005: fnd_message.set_name ('IGI', 'IGI_EXP_TU_VAL_HIER_POS_ERROR');
1006: l_msg := fnd_message.get;
1007: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1008: itemkey => l_itemkey,
1009: aname => 'TU_VAL_HIER_POS_ERROR',
1010: avalue => l_msg);
1008: itemkey => l_itemkey,
1009: aname => 'TU_VAL_HIER_POS_ERROR',
1010: avalue => l_msg);
1011:
1012: fnd_message.set_name ('IGI', 'IGI_EXP_TU_VAL_HR_POS_PRF_ERR');
1013: l_msg := fnd_message.get;
1014: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1015: itemkey => l_itemkey,
1016: aname => 'TU_VAL_HIER_POS_PROF_ERROR',
1009: aname => 'TU_VAL_HIER_POS_ERROR',
1010: avalue => l_msg);
1011:
1012: fnd_message.set_name ('IGI', 'IGI_EXP_TU_VAL_HR_POS_PRF_ERR');
1013: l_msg := fnd_message.get;
1014: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1015: itemkey => l_itemkey,
1016: aname => 'TU_VAL_HIER_POS_PROF_ERROR',
1017: avalue => l_msg);
1015: itemkey => l_itemkey,
1016: aname => 'TU_VAL_HIER_POS_PROF_ERROR',
1017: avalue => l_msg);
1018:
1019: fnd_message.set_name ('IGI', 'IGI_EXP_TU_VALIDATION_ERROR');
1020: l_msg := fnd_message.get;
1021: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1022: itemkey => l_itemkey,
1023: aname => 'TU_VALIDATION_ERROR',
1016: aname => 'TU_VAL_HIER_POS_PROF_ERROR',
1017: avalue => l_msg);
1018:
1019: fnd_message.set_name ('IGI', 'IGI_EXP_TU_VALIDATION_ERROR');
1020: l_msg := fnd_message.get;
1021: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1022: itemkey => l_itemkey,
1023: aname => 'TU_VALIDATION_ERROR',
1024: avalue => l_msg);
1022: itemkey => l_itemkey,
1023: aname => 'TU_VALIDATION_ERROR',
1024: avalue => l_msg);
1025:
1026: fnd_message.set_name ('IGI', 'IGI_EXP_TU_VALIDATION_HR_ERR');
1027: l_msg := fnd_message.get;
1028: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1029: itemkey => l_itemkey,
1030: aname => 'TU_VALIDATION_HIER_ERROR',
1023: aname => 'TU_VALIDATION_ERROR',
1024: avalue => l_msg);
1025:
1026: fnd_message.set_name ('IGI', 'IGI_EXP_TU_VALIDATION_HR_ERR');
1027: l_msg := fnd_message.get;
1028: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
1029: itemkey => l_itemkey,
1030: aname => 'TU_VALIDATION_HIER_ERROR',
1031: avalue => l_msg);
2546: -- =============== END DEBUG LOG ==================
2547:
2548: EXCEPTION
2549: WHEN e_wrong_user THEN
2550: fnd_message.set_name('IGI','IGI_EXP_INVALID_AUTHORIZER');
2551: -- =============== START DEBUG LOG ================
2552: DEBUG_LOG_UNEXP_ERROR ('Check_user_position.Unexp1','USER');
2553: -- =============== END DEBUG LOG ==================
2554: app_exception.raise_exception;