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.CZ_MIGRATE dependencies on CZ_MIGRATE

Line 1: PACKAGE BODY cz_migrate AS

1: PACKAGE BODY cz_migrate AS
2: /* $Header: czmigrb.pls 120.6 2012/02/28 21:41:40 smanna ship $ */
3:
4: G_OA_UI_STYLE VARCHAR2(1) := '7';
5: G_OA_UIMT_STYLE VARCHAR2(1) := '5';

Line 1150: ' cz_migrate.report(CZ_UTILS.GET_TEXT(''CZ_MIGR_UNABLE_UPDATE'', ''TABLENAME'', ''' || inTableName || ''', ''ERRORTEXT'', SQLERRM), cz_migrate.URGENCY_WARNING); ' ||

1146: tableUpdateStatement||
1147: ' nUpdates := nUpdates + 1; '||
1148: ' exception '||
1149: ' when others then '||
1150: ' cz_migrate.report(CZ_UTILS.GET_TEXT(''CZ_MIGR_UNABLE_UPDATE'', ''TABLENAME'', ''' || inTableName || ''', ''ERRORTEXT'', SQLERRM), cz_migrate.URGENCY_WARNING); ' ||
1151: ' if((sqlcode between -999 and -900) or '||
1152: ' (sqlcode between -1489 and -1400) or '||
1153: ' sqlcode = -1)then '||
1154: ' if(:StopOnSkippable = 1)then raise cz_migrate.CZ_MIGR_SKIPPABLE_EXCEPTION; end if; '||

Line 1154: ' if(:StopOnSkippable = 1)then raise cz_migrate.CZ_MIGR_SKIPPABLE_EXCEPTION; end if; '||

1150: ' cz_migrate.report(CZ_UTILS.GET_TEXT(''CZ_MIGR_UNABLE_UPDATE'', ''TABLENAME'', ''' || inTableName || ''', ''ERRORTEXT'', SQLERRM), cz_migrate.URGENCY_WARNING); ' ||
1151: ' if((sqlcode between -999 and -900) or '||
1152: ' (sqlcode between -1489 and -1400) or '||
1153: ' sqlcode = -1)then '||
1154: ' if(:StopOnSkippable = 1)then raise cz_migrate.CZ_MIGR_SKIPPABLE_EXCEPTION; end if; '||
1155: ' else '||
1156: ' raise cz_migrate.CZ_MIGR_FATAL_EXCEPTION; '||
1157: ' end if; '||
1158: ' end; '||

Line 1156: ' raise cz_migrate.CZ_MIGR_FATAL_EXCEPTION; '||

1152: ' (sqlcode between -1489 and -1400) or '||
1153: ' sqlcode = -1)then '||
1154: ' if(:StopOnSkippable = 1)then raise cz_migrate.CZ_MIGR_SKIPPABLE_EXCEPTION; end if; '||
1155: ' else '||
1156: ' raise cz_migrate.CZ_MIGR_FATAL_EXCEPTION; '||
1157: ' end if; '||
1158: ' end; '||
1159: ' else '||
1160: ' cz_migrate.report(CZ_UTILS.GET_TEXT(''CZ_MIGR_UNABLE_INSERT'', ''TABLENAME'', ''' || inTableName || ''', ''ERRORTEXT'', SQLERRM), cz_migrate.URGENCY_WARNING); ' ||

Line 1160: ' cz_migrate.report(CZ_UTILS.GET_TEXT(''CZ_MIGR_UNABLE_INSERT'', ''TABLENAME'', ''' || inTableName || ''', ''ERRORTEXT'', SQLERRM), cz_migrate.URGENCY_WARNING); ' ||

1156: ' raise cz_migrate.CZ_MIGR_FATAL_EXCEPTION; '||
1157: ' end if; '||
1158: ' end; '||
1159: ' else '||
1160: ' cz_migrate.report(CZ_UTILS.GET_TEXT(''CZ_MIGR_UNABLE_INSERT'', ''TABLENAME'', ''' || inTableName || ''', ''ERRORTEXT'', SQLERRM), cz_migrate.URGENCY_WARNING); ' ||
1161: ' if(:StopOnSkippable = 1)then raise cz_migrate.CZ_MIGR_SKIPPABLE_EXCEPTION; end if; '||
1162: ' end if; '||
1163: ' else '||
1164: ' raise cz_migrate.CZ_MIGR_FATAL_EXCEPTION; '||

Line 1161: ' if(:StopOnSkippable = 1)then raise cz_migrate.CZ_MIGR_SKIPPABLE_EXCEPTION; end if; '||

1157: ' end if; '||
1158: ' end; '||
1159: ' else '||
1160: ' cz_migrate.report(CZ_UTILS.GET_TEXT(''CZ_MIGR_UNABLE_INSERT'', ''TABLENAME'', ''' || inTableName || ''', ''ERRORTEXT'', SQLERRM), cz_migrate.URGENCY_WARNING); ' ||
1161: ' if(:StopOnSkippable = 1)then raise cz_migrate.CZ_MIGR_SKIPPABLE_EXCEPTION; end if; '||
1162: ' end if; '||
1163: ' else '||
1164: ' raise cz_migrate.CZ_MIGR_FATAL_EXCEPTION; '||
1165: ' end if; '||

Line 1164: ' raise cz_migrate.CZ_MIGR_FATAL_EXCEPTION; '||

1160: ' cz_migrate.report(CZ_UTILS.GET_TEXT(''CZ_MIGR_UNABLE_INSERT'', ''TABLENAME'', ''' || inTableName || ''', ''ERRORTEXT'', SQLERRM), cz_migrate.URGENCY_WARNING); ' ||
1161: ' if(:StopOnSkippable = 1)then raise cz_migrate.CZ_MIGR_SKIPPABLE_EXCEPTION; end if; '||
1162: ' end if; '||
1163: ' else '||
1164: ' raise cz_migrate.CZ_MIGR_FATAL_EXCEPTION; '||
1165: ' end if; '||
1166: ' end; '||
1167: ' end loop; '||
1168: ' commit; '||

Line 1169: ' cz_migrate.report(CZ_UTILS.GET_TEXT(''CZ_MIGR_COPY_SUCCESS'', ''TABLENAME'', ''' || inTableName || ''', ''INSERTROWS'', TO_CHAR(nInserts), ''UPDATEROWS'', TO_CHAR(nUpdates)), cz_migrate.URGENCY_MESSAGE); ' ||

1165: ' end if; '||
1166: ' end; '||
1167: ' end loop; '||
1168: ' commit; '||
1169: ' cz_migrate.report(CZ_UTILS.GET_TEXT(''CZ_MIGR_COPY_SUCCESS'', ''TABLENAME'', ''' || inTableName || ''', ''INSERTROWS'', TO_CHAR(nInserts), ''UPDATEROWS'', TO_CHAR(nUpdates)), cz_migrate.URGENCY_MESSAGE); ' ||
1170: 'end;',
1171: dbms_sql.native);
1172:
1173: dbms_sql.bind_variable(cdyn, ':Refreshable', inRefreshable);

Line 1460: cz_utils.log_report('cz_migrate', null, thisStatusCode, inMessage, fnd_log.LEVEL_ERROR);

1456: END adjust_all_sequences;
1457: ------------------------------------------------------------------------------------------------------------
1458: PROCEDURE report(inMessage IN VARCHAR2, inUrgency IN PLS_INTEGER) IS
1459: BEGIN
1460: cz_utils.log_report('cz_migrate', null, thisStatusCode, inMessage, fnd_log.LEVEL_ERROR);
1461:
1462: --Bug #4347347.
1463:
1464: IF(FND_GLOBAL.CONC_REQUEST_ID > 0)THEN

Line 2055: EXECUTE IMMEDIATE 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'

2051: ' begin delete from cz_jrad_chunks'||l_link_name||'; commit; end; ';
2052: delete from cz_jrad_chunks; commit;
2053:
2054: ----get XML chunks from the target to be imported
2055: EXECUTE IMMEDIATE 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'
2056: USING p_ui_def_id,l_template_id;
2057:
2058: ----insert XML chunks from the target to the cz_jrad_chunks table on the source
2059: OPEN l_ref_cursor FOR 'SELECT JRAD_DOC,SEQ_NBR,XML_CHUNK

Line 2143: 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'

2139: delete from cz_jrad_chunks; commit;
2140:
2141: ----get XML chunks from the target to be imported
2142: EXECUTE IMMEDIATE
2143: 'begin cz_migrate.get_xml_chunks'||l_link_name||'(:1,:2); end;'
2144: USING l_ui_def_id_tbl(i),l_template_id_tbl(i);
2145:
2146: ----insert XML chunks from the target to the cz_jrad_chunks table on the source
2147: OPEN l_ref_cursor FOR 'SELECT JRAD_DOC,SEQ_NBR,XML_CHUNK

Line 2185: END cz_migrate;

2181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2182: x_msg_data := SQLERRM;
2183: END import_template_jrad_docs ;
2184: ------------------------------------------------------------------------------------------------------------
2185: END cz_migrate;