[Home] [Help]
145: --Check for other running migration/setup sessions.
146:
147: FOR c_running IN (SELECT action FROM v$session WHERE module IN (
148: 'CZMIGRATION',
149: 'CZ_PB_MGR',
150: 'CZ_MODEL_MIGRATION',
151: 'CZIMPORT',
152: CZ_PUBL_SYNC_CRASH.pbSourceClone,
153: CZ_PUBL_SYNC_CRASH.pbTargetClone,
332: --Check for other running migration/setup sessions.
333:
334: FOR c_running IN (SELECT action FROM v$session WHERE module IN (
335: 'CZMIGRATION',
336: 'CZ_PB_MGR',
337: 'CZ_MODEL_MIGRATION',
338: 'CZIMPORT',
339: CZ_PUBL_SYNC_CRASH.pbSourceClone,
340: CZ_PUBL_SYNC_CRASH.pbTargetClone,
2055: COMMIT;
2056: CLOSE l_ref_cursor;
2057:
2058: -----upload the XML to the jrad repository
2059: cz_pb_mgr.insert_jrad_docs;
2060:
2061: ----delete from temp table on target and source
2062: EXECUTE IMMEDIATE
2063: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2072: x_msg_count := 1;
2073:
2074: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
2075: fnd_message.set_token('ERROR_TEXT', SQLERRM);
2076: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
2077: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
2078:
2079: x_msg_data := fnd_message.get;
2080: WHEN OTHERS THEN
2143: COMMIT;
2144: CLOSE l_ref_cursor;
2145:
2146: -----upload the XML to the jrad repository
2147: cz_pb_mgr.insert_jrad_docs;
2148:
2149: ----delete from temp table on target and source
2150: EXECUTE IMMEDIATE
2151: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2160: x_msg_count := 1;
2161:
2162: fnd_message.set_name('FND', 'FND_AS_UNEXPECTED_ERROR');
2163: fnd_message.set_token('ERROR_TEXT', SQLERRM);
2164: fnd_message.set_token('PKG_NAME', 'CZ_PB_MGR');
2165: fnd_message.set_token('PROCEDURE_NAME', 'INSERT_JRAD_DOCS');
2166:
2167: x_msg_data := fnd_message.get;
2168: WHEN OTHERS THEN