DBA Data[Home] [Help]

APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_UTILS

Line 79: cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);

75: EXCEPTION
76: WHEN OTHERS THEN
77: x_status := FND_API.G_RET_STS_ERROR;
78: l_errbuf := SQLERRM;
79: cz_utils.log_report(G_PKG_NAME, l_api_name, null, l_errbuf, fnd_log.LEVEL_UNEXPECTED);
80: END;
81: ---------------------------------------------------------------------------------------
82: /*
83: * Migrate Models concurrent procedure.

Line 117: errbuf := CZ_UTILS.GET_TEXT('CZ_MM_WARNING');

113:
114: errbuf := NULL;
115: IF(cz_pb_mgr.GLOBAL_EXPORT_RETCODE = 1)THEN
116:
117: errbuf := CZ_UTILS.GET_TEXT('CZ_MM_WARNING');
118:
119: ELSIF(cz_pb_mgr.GLOBAL_EXPORT_RETCODE = 2) THEN
120:
121: errbuf := CZ_UTILS.GET_TEXT('CZ_MM_FAILURE');

Line 121: errbuf := CZ_UTILS.GET_TEXT('CZ_MM_FAILURE');

117: errbuf := CZ_UTILS.GET_TEXT('CZ_MM_WARNING');
118:
119: ELSIF(cz_pb_mgr.GLOBAL_EXPORT_RETCODE = 2) THEN
120:
121: errbuf := CZ_UTILS.GET_TEXT('CZ_MM_FAILURE');
122: END IF;
123: END LOOP;
124:
125: IF NOT l_mig_group_found THEN

Line 126: errbuf := cz_utils.get_text('CZ_INVALID_MIGR_GROUP_NUMBER', 'MIGRGRP', p_request_id);

122: END IF;
123: END LOOP;
124:
125: IF NOT l_mig_group_found THEN
126: errbuf := cz_utils.get_text('CZ_INVALID_MIGR_GROUP_NUMBER', 'MIGRGRP', p_request_id);
127: log_msg(l_api_name, l_ndebug, errbuf , FND_LOG.LEVEL_PROCEDURE);
128: raise_application_error('-20020', 'INVALID_MIGRATION_GROUP');
129: END IF;
130:

Line 136: errbuf := CZ_UTILS.GET_TEXT('CZ_MM_UNEXPECTED');

132:
133: EXCEPTION
134: WHEN OTHERS THEN
135: retcode := 2;
136: errbuf := CZ_UTILS.GET_TEXT('CZ_MM_UNEXPECTED');
137: END;
138: ---------------------------------------------------------------------------------------
139: /*
140: * Procedure for persistent id(s) allocation in migrated models.

Line 170: cz_utils.log_report(G_PKG_NAME, p_caller, p_ndebug, p_msg, p_level);

166: BEGIN
167: IF FND_GLOBAL.CONC_REQUEST_ID > 0 THEN
168: FND_FILE.PUT_LINE(FND_FILE.LOG, p_msg);
169: END IF;
170: cz_utils.log_report(G_PKG_NAME, p_caller, p_ndebug, p_msg, p_level);
171: END log_msg;
172:
173: --------------------------------------------------------------------------------
174: PROCEDURE get_commit_size_setting IS

Line 289: AND creation_date >= NVL(p_begin_date, cz_utils.EPOCH_BEGIN_)

285: SELECT config_hdr_id, config_rev_nbr, component_id
286: BULK COLLECT INTO l_hdr_tbl, l_rev_tbl, l_mdl_tbl
287: FROM cz_config_hdrs hdr
288: WHERE deleted_flag = '0'
289: AND creation_date >= NVL(p_begin_date, cz_utils.EPOCH_BEGIN_)
290: AND creation_date <= NVL(p_end_date, SYSDATE)
291: AND persistent_component_id = (SELECT persistent_project_id
292: FROM cz_devl_projects
293: WHERE devl_project_id = p_model_id)

Line 304: l_msg := cz_utils.get_text('CZ_UPGCFG_NO_CFG', 'MODELNAME', l_model_name);

300: IF l_hdr_tbl.COUNT = 0 THEN
301: SELECT name INTO l_model_name
302: FROM cz_devl_projects
303: WHERE devl_project_id = p_model_id;
304: l_msg := cz_utils.get_text('CZ_UPGCFG_NO_CFG', 'MODELNAME', l_model_name);
305: log_msg(l_api_name, l_ndebug, l_msg, FND_LOG.LEVEL_STATEMENT);
306: x_retcode := CP_RETCODE_SUCCESS;
307: RETURN;
308: ELSE

Line 445: l_msg := cz_utils.get_text('CZ_UPGCFG_ITEM_NO_NODE', 'ID', to_char(l_miss_item_tbl(j)),

441:
442: IF l_miss_item_tbl.COUNT > 0 THEN
443: l_no_miss_item := FALSE;
444: FOR j IN l_miss_item_tbl.FIRST ..l_miss_item_tbl.LAST LOOP
445: l_msg := cz_utils.get_text('CZ_UPGCFG_ITEM_NO_NODE', 'ID', to_char(l_miss_item_tbl(j)),
446: 'HDR', to_char(l_hdr_tbl(i)), 'REV', to_char(l_rev_tbl(i)));
447: log_msg(l_api_name, l_ndebug, l_msg, FND_LOG.LEVEL_STATEMENT);
448: END LOOP;
449: END IF;

Line 507: l_msg := cz_utils.get_text('CZ_UPGCFG_NO_PUB_ITEM', 'ITEM', to_char(p_inventory_item_id),

503: l_model_id := cz_cf_api.config_model_for_item(p_inventory_item_id,
504: p_organization_id, SYSDATE, p_application_id, NULL);
505: IF l_model_id IS NULL THEN
506: x_retcode := CP_RETCODE_FAILURE;
507: l_msg := cz_utils.get_text('CZ_UPGCFG_NO_PUB_ITEM', 'ITEM', to_char(p_inventory_item_id),
508: 'ORG', to_char(p_organization_id));
509: log_msg(l_api_name, l_ndebug, l_msg, FND_LOG.LEVEL_ERROR);
510: RETURN;
511: END IF;

Line 534: l_msg := cz_utils.get_text(l_msg_name, 'ITEM', to_char(p_inventory_item_id),

530: l_msg_name := 'CZ_UPGCFG_ITEM_WARN';
531: ELSE
532: l_msg_name := 'CZ_UPGCFG_ITEM_FAIL';
533: END IF;
534: l_msg := cz_utils.get_text(l_msg_name, 'ITEM', to_char(p_inventory_item_id),
535: 'ORG', to_char(p_organization_id));
536: log_msg(l_api_name, l_ndebug, l_msg, FND_LOG.LEVEL_PROCEDURE);
537: EXCEPTION
538: WHEN OTHERS THEN

Line 676: l_msg := cz_utils.get_text('CZ_UPGCFG_ITEMS', 'NSUCC', to_char(l_num_success),

672: retcode := CP_RETCODE_FAILURE;
673: ELSE
674: retcode := CP_RETCODE_WARNING;
675: END IF;
676: l_msg := cz_utils.get_text('CZ_UPGCFG_ITEMS', 'NSUCC', to_char(l_num_success),
677: 'NWARN', to_char(l_num_warning), 'NFAIL', to_char(l_num_failure));
678: -- log_msg(l_api_name, l_ndebug, l_msg, FND_LOG.LEVEL_ERROR);
679: errbuf := l_msg;
680: EXCEPTION

Line 734: errbuf := cz_utils.get_text('CZ_UPGCFG_NO_PUB_PRD', 'PRD', p_product_key);

730:
731: l_ndebug := 2;
732: l_model_id := cz_cf_api.config_model_for_product(p_product_key,SYSDATE,p_application_id,NULL);
733: IF l_model_id IS NULL THEN
734: errbuf := cz_utils.get_text('CZ_UPGCFG_NO_PUB_PRD', 'PRD', p_product_key);
735: retcode := CP_RETCODE_FAILURE;
736: log_msg(l_api_name, l_ndebug, errbuf, FND_LOG.LEVEL_ERROR);
737: RETURN;
738: ELSE

Line 762: errbuf := cz_utils.get_text ('CZ_UPGCFG_WRONG_PUB4PRODKEY', 'PUBID1', v_publication_id, 'PUBID2', v_publication_id);

758: usage_name => NULL,
759: publication_mode => NULL,
760: language => NULL
761: );
762: errbuf := cz_utils.get_text ('CZ_UPGCFG_WRONG_PUB4PRODKEY', 'PUBID1', v_publication_id, 'PUBID2', v_publication_id);
763: retcode := CP_RETCODE_FAILURE;
764: log_msg (l_api_name, l_ndebug, errbuf, FND_LOG.LEVEL_ERROR);
765: RETURN;
766: ELSE

Line 793: errbuf := cz_utils.get_text(l_msg_name, 'PRD', p_product_key);

789: l_msg_name := 'CZ_UPGCFG_PROD_WARN';
790: ELSE
791: l_msg_name := 'CZ_UPGCFG_PROD_FAIL';
792: END IF;
793: errbuf := cz_utils.get_text(l_msg_name, 'PRD', p_product_key);
794: -- l_msg := 'retcode=' || retcode || ',msg=' || errbuf;
795: -- log_msg(l_api_name, l_ndebug, l_msg, FND_LOG.LEVEL_PROCEDURE);
796: EXCEPTION
797: WHEN OTHERS THEN

Line 929: errbuf:=CZ_UTILS.Get_Text('CZ_ALREADY_CONVERTED_MESSAGE');

925:
926: EXCEPTION
927: WHEN ALREADY_MIGRATED_EXCEPTION THEN
928: retcode:=2;
929: errbuf:=CZ_UTILS.Get_Text('CZ_ALREADY_CONVERTED_MESSAGE');
930: l_return := cz_utils.log_report(Msg => errbuf,
931: Urgency => 1,
932: ByCaller => 'CZ_MODEL_MIGRATION',
933: StatusCode => 11276,

Line 930: l_return := cz_utils.log_report(Msg => errbuf,

926: EXCEPTION
927: WHEN ALREADY_MIGRATED_EXCEPTION THEN
928: retcode:=2;
929: errbuf:=CZ_UTILS.Get_Text('CZ_ALREADY_CONVERTED_MESSAGE');
930: l_return := cz_utils.log_report(Msg => errbuf,
931: Urgency => 1,
932: ByCaller => 'CZ_MODEL_MIGRATION',
933: StatusCode => 11276,
934: RunId => p_run_id);

Line 939: l_return := cz_utils.log_report(Msg => errbuf,

935: WHEN OTHERS THEN
936: rollback;
937: retcode:=2;
938: errbuf:=SQLERRM;
939: l_return := cz_utils.log_report(Msg => errbuf,
940: Urgency => 1,
941: ByCaller => 'CZ_MODEL_MIGRATION',
942: StatusCode => 11276,
943: RunId => p_run_id);

Line 1023: CZ_UTILS.add_error_message_to_stack(p_message_name => 'CZ_OBSELETE_RECORDS_EXISTS',

1019:
1020: x_return_status := FND_API.G_RET_STS_ERROR;
1021:
1022: --add message to the error stack
1023: CZ_UTILS.add_error_message_to_stack(p_message_name => 'CZ_OBSELETE_RECORDS_EXISTS',
1024: p_token_name1 => 'INSTANCE_NAME',
1025: p_token_value1 => r_instance_name,
1026: x_msg_count => x_msg_count,
1027: x_msg_data => x_msg_data);

Line 1050: CZ_UTILS.add_exc_msg_to_fndstack(

1046: END IF;
1047:
1048: EXCEPTION
1049: WHEN others THEN
1050: CZ_UTILS.add_exc_msg_to_fndstack(
1051: p_package_name => 'CZ_MODEL_MIGRATION',
1052: p_procedure_name => 'obselete_nonpublishable',
1053: p_error_message => SQLERRM);
1054: