1: PACKAGE BODY ICX_POR_POPULATE_DESC AS
2: -- $Header: ICXPLCDB.pls 115.8 2004/03/31 21:52:02 vkartik ship $
3:
4:
5: /*
25:
26: WHEN OTHERS THEN
27: rollback;
28: RAISE_APPLICATION_ERROR
29: (-20000, 'Exception at ICX_POR_POPULATE_DESC.populateCtxDescAll('||
30: xErrLoc||'), '|| SQLERRM );
31: END populateCtxDescAll;
32:
33: /*
52:
53: WHEN OTHERS THEN
54: rollback;
55: RAISE_APPLICATION_ERROR
56: (-20000, 'Exception at ICX_POR_POPULATE_DESC.populateCtxDescAll('||
57: xErrLoc||'), '|| SQLERRM );
58: END populateCtxDescAll;
59:
60: PROCEDURE populateCtxDescAll(p_jobno IN INTEGER := 0,
74: EXCEPTION
75:
76: WHEN OTHERS THEN
77: icx_por_ext_utl.debug(icx_por_ext_utl.DEBUG_LEVEL,
78: 'Exception at ICX_POR_POPULATE_DESC.populateCtxDescAll('||
79: xErrLoc || '), ' || SQLERRM);
80: rollback;
81: ICX_POR_EXT_UTL.printStackTrace;
82: ICX_POR_EXT_UTL.closeLog;
80: rollback;
81: ICX_POR_EXT_UTL.printStackTrace;
82: ICX_POR_EXT_UTL.closeLog;
83: RAISE_APPLICATION_ERROR
84: (-20000, 'Exception at ICX_POR_POPULATE_DESC.populateCtxDescAll('||
85: xErrLoc||'), '|| SQLERRM );
86: END populateCtxDescAll;
87:
88:
101: EXCEPTION
102:
103: WHEN OTHERS THEN
104: icx_por_ext_utl.debug(-- icx_por_ext_utl.DEBUG_LEVEL,
105: 'Exception at ICX_POR_POPULATE_DESC.populateDescAll('||
106: xErrLoc || '), ' || SQLERRM);
107: rollback;
108: RAISE_APPLICATION_ERROR
109: (-20000, 'Exception at ICX_POR_POPULATE_DESC.populateDescAll('||
105: 'Exception at ICX_POR_POPULATE_DESC.populateDescAll('||
106: xErrLoc || '), ' || SQLERRM);
107: rollback;
108: RAISE_APPLICATION_ERROR
109: (-20000, 'Exception at ICX_POR_POPULATE_DESC.populateDescAll('||
110: xErrLoc||'), '|| SQLERRM );
111:
112: END populateDescAll;
113:
124: EXCEPTION
125:
126: WHEN OTHERS THEN
127: icx_por_ext_utl.debug(-- icx_por_ext_utl.DEBUG_LEVEL,
128: 'Exception at ICX_POR_POPULATE_DESC.rebuildAll('||
129: xErrLoc || '), ' || SQLERRM);
130: rollback;
131: RAISE_APPLICATION_ERROR
132: (-20000, 'Exception at ICX_POR_POPULATE_DESC.rebuildAll('||
128: 'Exception at ICX_POR_POPULATE_DESC.rebuildAll('||
129: xErrLoc || '), ' || SQLERRM);
130: rollback;
131: RAISE_APPLICATION_ERROR
132: (-20000, 'Exception at ICX_POR_POPULATE_DESC.rebuildAll('||
133: xErrLoc||'), '|| SQLERRM );
134:
135: END rebuildAll;
136:
142:
143: EXCEPTION
144: WHEN OTHERS THEN
145: icx_por_ext_utl.debug(-- icx_por_ext_utl.DEBUG_LEVEL,
146: 'Exception at ICX_POR_POPULATE_DESC.rebuild_indexes('||
147: xErrLoc || '), ' || SQLERRM);
148:
149: RAISE_APPLICATION_ERROR(-20000, 'Exception at '||
150: 'ICX_POR_POPULATE_DESC.rebuild_indexes(' ||
146: 'Exception at ICX_POR_POPULATE_DESC.rebuild_indexes('||
147: xErrLoc || '), ' || SQLERRM);
148:
149: RAISE_APPLICATION_ERROR(-20000, 'Exception at '||
150: 'ICX_POR_POPULATE_DESC.rebuild_indexes(' ||
151: xErrLoc||'), '|| SQLERRM );
152: END rebuild_indexes;
153:
154:
151: xErrLoc||'), '|| SQLERRM );
152: END rebuild_indexes;
153:
154:
155: END ICX_POR_POPULATE_DESC;