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_PS_COPY dependencies on CZ_PS_COPY

Line 1: PACKAGE BODY cz_ps_copy AS

1: PACKAGE BODY cz_ps_copy AS
2: /* $Header: czpscpb.pls 120.0 2005/05/25 07:27:11 appldev noship $ */
3:
4: GLOBAL_ORIG_SYS_REF CZ_DEVL_PROJECTS.orig_sys_ref%TYPE;
5: BATCH_SIZE INTEGER:=20000;

Line 130: --LOG_REPORT('CZ_PS_COPY.PACK',TO_CHAR(BATCH_SIZE)|| ' records has been inserted...');

126:
127: BEGIN
128:
129: IF numRecords>BATCH_SIZE THEN
130: --LOG_REPORT('CZ_PS_COPY.PACK',TO_CHAR(BATCH_SIZE)|| ' records has been inserted...');
131: numRecords:=0;
132: COMMIT;
133: ELSE
134: numRecords:=numRecords+1;

Line 1756: LOG_REPORT('CZ_PS_COPY.copy_UI','UI node='||to_char(i.ui_node_id)||' is corrupted.');

1752: PACK;
1753:
1754: EXCEPTION
1755: WHEN NO_DATA_FOUND THEN
1756: LOG_REPORT('CZ_PS_COPY.copy_UI','UI node='||to_char(i.ui_node_id)||' is corrupted.');
1757: END;
1758: END LOOP;
1759:
1760: EXCEPTION

Line 2237: LOG_REPORT('CZ_PS_COPY.Copy_CHART_Tables',SQLERRM);

2233: END LOOP;
2234:
2235: EXCEPTION
2236: WHEN NO_DATA_FOUND THEN
2237: LOG_REPORT('CZ_PS_COPY.Copy_CHART_Tables',SQLERRM);
2238: END;
2239:
2240: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2241: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 2262: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');

2258:
2259: BEGIN
2260:
2261: /* Exception is raised for BUG No.4028599*/
2262: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
2263:
2264: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
2265:
2266: Initialize;

Line 2499: LOG_REPORT('CZ_PS_COPY.Copy_FUNC_COMP_SPEC_',SQLERRM);

2495: END LOOP;
2496:
2497: EXCEPTION
2498: WHEN NO_DATA_FOUND THEN
2499: LOG_REPORT('CZ_PS_COPY.Copy_FUNC_COMP_SPEC_',SQLERRM);
2500: WHEN OTHERS THEN
2501: LOG_REPORT('CZ_PS_COPY.Copy_FUNC_COMP_SPEC_',SQLERRM);
2502: END;
2503:

Line 2501: LOG_REPORT('CZ_PS_COPY.Copy_FUNC_COMP_SPEC_',SQLERRM);

2497: EXCEPTION
2498: WHEN NO_DATA_FOUND THEN
2499: LOG_REPORT('CZ_PS_COPY.Copy_FUNC_COMP_SPEC_',SQLERRM);
2500: WHEN OTHERS THEN
2501: LOG_REPORT('CZ_PS_COPY.Copy_FUNC_COMP_SPEC_',SQLERRM);
2502: END;
2503:
2504: PROCEDURE COPY_FUNC_COMPANION
2505: (p_func_comp_id IN INTEGER,

Line 2516: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');

2512:
2513: BEGIN
2514:
2515: /* Exception is raised for BUG No.4028599*/
2516: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
2517:
2518: SELECT CZ_FUNC_COMP_SPECS_S.NEXTVAL INTO p_out_new_func_comp_id FROM dual;
2519:
2520: var_component_id:=NULL;

Line 2574: LOG_REPORT('CZ_PS_COPY.COPY_FUNC_COMPANION',SQLERRM);

2570: END LOOP;
2571:
2572: EXCEPTION
2573: WHEN NO_DATA_FOUND THEN
2574: LOG_REPORT('CZ_PS_COPY.COPY_FUNC_COMPANION',SQLERRM);
2575: WHEN OTHERS THEN
2576: LOG_REPORT('CZ_PS_COPY.COPY_FUNC_COMPANION',SQLERRM);
2577: END;
2578:

Line 2576: LOG_REPORT('CZ_PS_COPY.COPY_FUNC_COMPANION',SQLERRM);

2572: EXCEPTION
2573: WHEN NO_DATA_FOUND THEN
2574: LOG_REPORT('CZ_PS_COPY.COPY_FUNC_COMPANION',SQLERRM);
2575: WHEN OTHERS THEN
2576: LOG_REPORT('CZ_PS_COPY.COPY_FUNC_COMPANION',SQLERRM);
2577: END;
2578:
2579: PROCEDURE Copy_EXPRESSION_
2580: (p_express_id IN INTEGER,

Line 2696: LOG_REPORT('CZ_PS_COPY.Copy_CHART_Tables_',SQLERRM);

2692: PACK;
2693:
2694: EXCEPTION
2695: WHEN NO_DATA_FOUND THEN
2696: LOG_REPORT('CZ_PS_COPY.Copy_CHART_Tables_',SQLERRM);
2697: END;
2698:
2699: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2700: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 2736: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');

2732:
2733: BEGIN
2734:
2735: /* Exception is raised for BUG No.4028599*/
2736: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
2737:
2738: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
2739:
2740: p_out_new_rule_id:=0;

Line 2990: LOG_REPORT('CZ_PS_COPY.Copy_RULES_subschema',SQLERRM);

2986: EXCEPTION
2987: WHEN END_OPERATION THEN
2988: NULL;
2989: WHEN NO_DATA_FOUND THEN
2990: LOG_REPORT('CZ_PS_COPY.Copy_RULES_subschema',SQLERRM);
2991: WHEN OTHERS THEN
2992: LOG_REPORT('CZ_PS_COPY.Copy_RULES_subschema',SQLERRM);
2993: END;
2994:

Line 2992: LOG_REPORT('CZ_PS_COPY.Copy_RULES_subschema',SQLERRM);

2988: NULL;
2989: WHEN NO_DATA_FOUND THEN
2990: LOG_REPORT('CZ_PS_COPY.Copy_RULES_subschema',SQLERRM);
2991: WHEN OTHERS THEN
2992: LOG_REPORT('CZ_PS_COPY.Copy_RULES_subschema',SQLERRM);
2993: END;
2994:
2995: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
2996: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 3062: LOG_REPORT('CZ_PS_COPY.Copy_DES_CHART_COLUMN','rule_id='||TO_CHAR(i.rule_id)||

3058: PACK;
3059:
3060: EXCEPTION
3061: WHEN NO_DATA_FOUND THEN
3062: LOG_REPORT('CZ_PS_COPY.Copy_DES_CHART_COLUMN','rule_id='||TO_CHAR(i.rule_id)||
3063: ' option_id='||TO_CHAR(i.option_id)||' : '||SQLERRM);
3064: WHEN OTHERS THEN
3065: LOG_REPORT('CZ_PS_COPY.Copy_DES_CHART_COLUMN','rule_id='||TO_CHAR(i.rule_id)||
3066: ' option_id='||TO_CHAR(i.option_id)||' : '||SQLERRM);

Line 3065: LOG_REPORT('CZ_PS_COPY.Copy_DES_CHART_COLUMN','rule_id='||TO_CHAR(i.rule_id)||

3061: WHEN NO_DATA_FOUND THEN
3062: LOG_REPORT('CZ_PS_COPY.Copy_DES_CHART_COLUMN','rule_id='||TO_CHAR(i.rule_id)||
3063: ' option_id='||TO_CHAR(i.option_id)||' : '||SQLERRM);
3064: WHEN OTHERS THEN
3065: LOG_REPORT('CZ_PS_COPY.Copy_DES_CHART_COLUMN','rule_id='||TO_CHAR(i.rule_id)||
3066: ' option_id='||TO_CHAR(i.option_id)||' : '||SQLERRM);
3067: END;
3068: END LOOP;
3069:

Line 3072: LOG_REPORT('CZ_PS_COPY.Copy_DES_CHART_COLUMN',SQLERRM);

3068: END LOOP;
3069:
3070: EXCEPTION
3071: WHEN OTHERS THEN
3072: LOG_REPORT('CZ_PS_COPY.Copy_DES_CHART_COLUMN',SQLERRM);
3073: END;
3074:
3075: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3076: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 3087: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');

3083:
3084: BEGIN
3085:
3086: /* Exception is raised for BUG No.4028599*/
3087: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
3088:
3089: SELECT CZ_RULE_FOLDERS_S.NEXTVAL INTO p_new_rule_seq_id FROM dual;
3090: INSERT INTO CZ_RULE_FOLDERS
3091: (RULE_FOLDER_ID,

Line 3144: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);

3140:
3141: EXCEPTION
3142: WHEN NO_DATA_FOUND THEN
3143: p_new_rule_seq_id:=-GLOBAL_RUN_ID;
3144: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);
3145: WHEN OTHERS THEN
3146: p_new_rule_seq_id:=-GLOBAL_RUN_ID;
3147: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);
3148: END;

Line 3147: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);

3143: p_new_rule_seq_id:=-GLOBAL_RUN_ID;
3144: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);
3145: WHEN OTHERS THEN
3146: p_new_rule_seq_id:=-GLOBAL_RUN_ID;
3147: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);
3148: END;
3149:
3150: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3151: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 3171: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);

3167:
3168: EXCEPTION
3169: WHEN NO_DATA_FOUND THEN
3170: p_new_rule_seq_id:=-GLOBAL_RUN_ID;
3171: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);
3172: WHEN OTHERS THEN
3173: p_new_rule_seq_id:=-GLOBAL_RUN_ID;
3174: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);
3175: END;

Line 3174: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);

3170: p_new_rule_seq_id:=-GLOBAL_RUN_ID;
3171: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);
3172: WHEN OTHERS THEN
3173: p_new_rule_seq_id:=-GLOBAL_RUN_ID;
3174: LOG_REPORT('CZ_PS_COPY.copy_RULE_SEQ',SQLERRM);
3175: END;
3176:
3177: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3178: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 3194: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');

3190:
3191: BEGIN
3192:
3193: /* Exception is raised for BUG No.4028599*/
3194: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
3195:
3196: SELECT CZ_XFR_RUN_INFOS_S.NEXTVAL INTO GLOBAL_RUN_ID FROM dual;
3197: Initialize;
3198:

Line 3251: LOG_REPORT('CZ_PS_COPY.Project_Copy',SQLERRM);

3247:
3248: EXCEPTION
3249: WHEN NO_DATA_FOUND THEN
3250: p_new_id:=-GLOBAL_RUN_ID;
3251: LOG_REPORT('CZ_PS_COPY.Project_Copy',SQLERRM);
3252: WHEN OTHERS THEN
3253: p_new_id:=-GLOBAL_RUN_ID;
3254: LOG_REPORT('CZ_PS_COPY.Project_Copy',SQLERRM);
3255: END;

Line 3254: LOG_REPORT('CZ_PS_COPY.Project_Copy',SQLERRM);

3250: p_new_id:=-GLOBAL_RUN_ID;
3251: LOG_REPORT('CZ_PS_COPY.Project_Copy',SQLERRM);
3252: WHEN OTHERS THEN
3253: p_new_id:=-GLOBAL_RUN_ID;
3254: LOG_REPORT('CZ_PS_COPY.Project_Copy',SQLERRM);
3255: END;
3256:
3257: /*>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
3258: <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<*/

Line 3270: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');

3266: new_id INTEGER;
3267: BEGIN
3268:
3269: /* Exception is raised for BUG No.4028599*/
3270: RAISE_APPLICATION_ERROR(-20001, 'ERROR: CZ_PS_COPY is obsolete in 11.5.10 and later builds.');
3271:
3272: Project_Copy(p_id,new_id,p_Rules,p_UI,NULL,p_folder_id);
3273: END;
3274: