APPS.CZ_PB_SYNC_UTIL dependencies on CZ_UTILS

Line 37: cz_utils.log_report(p_msg_tbl(i).called_proc, null, p_msg_tbl(i).sql_code,

33: BEGIN
34: IF (p_msg_tbl.COUNT > 0) THEN
35: FOR I IN p_msg_tbl.FIRST..p_msg_tbl.LAST
36: LOOP
37: cz_utils.log_report(p_msg_tbl(i).called_proc, null, p_msg_tbl(i).sql_code,
38: p_msg_tbl(i).msg_text, fnd_log.LEVEL_ERROR);
39: END LOOP;
40: END IF;
41: EXCEPTION

Line 102: v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_LINK_NAME_IS_NULL');

98: v_err_message VARCHAR2(2000);
99:
100: BEGIN
101: IF ( (p_db_link_name IS NULL) OR (p_db_link_name = '@') ) THEN
102: v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_LINK_NAME_IS_NULL');
103: RETURN FALSE;
104: ELSE
105: ----check if the link is up and active
106: OPEN gl_ref_cursor FOR 'SELECT COUNT(*) FROM cz_db_settings'||p_db_link_name ;

Line 114: v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_LINK_NOT_ACTIVE');

110: END LOOP;
111: CLOSE gl_ref_cursor;
112:
113: IF (l_active_count = 0) THEN
114: v_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_LINK_NOT_ACTIVE');
115: RETURN FALSE;
116: END IF;
117: END IF;
118: RETURN TRUE;

Line 252: x_msg := CZ_UTILS.GET_TEXT('CZ_PB_MGR_NOT_PRD_INSTANCE');

248:
249: IF (l_tgt_instance_name IS NOT NULL) THEN
250: IF (l_source_server_flag IS NULL) THEN
251: x_status := '1';
252: x_msg := CZ_UTILS.GET_TEXT('CZ_PB_MGR_NOT_PRD_INSTANCE');
253:
254: ELSIF ( (l_source_server_flag IS NOT NULL)
255: AND (l_source_server_flag <> '1') ) THEN
256: x_status := '1';

Line 257: x_msg := CZ_UTILS.GET_TEXT('CZ_PB_MGR_NOT_PRD_INSTANCE');

253:
254: ELSIF ( (l_source_server_flag IS NOT NULL)
255: AND (l_source_server_flag <> '1') ) THEN
256: x_status := '1';
257: x_msg := CZ_UTILS.GET_TEXT('CZ_PB_MGR_NOT_PRD_INSTANCE');
258: END IF;
259: ELSE
260: l_msg := 'SELECT cz_servers_s.nextval from dual'||p_link_name;
261: OPEN seq_ref_cursor FOR 'SELECT cz_servers_s.nextval from dual'||p_link_name;

Line 289: x_msg := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_INSTANCE_IS_NULL','TGTINSTANCE','LOCAL');

285: END IF;
286: IF (seq_ref_cursor%ISOPEN) THEN
287: CLOSE seq_ref_cursor;
288: END IF;
289: x_msg := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_INSTANCE_IS_NULL','TGTINSTANCE','LOCAL');
290: x_status := '1';
291: WHEN OTHERS THEN
292: IF (gl_ref_cursor%ISOPEN) THEN
293: CLOSE gl_ref_cursor;

Line 326: x_msg := CZ_UTILS.GET_TEXT('CZ_CANNOT_MIGRATE');

322: IF (l_converted_target = '1') THEN
323: x_status :='0';
324: ELSE
325: x_status :='1';
326: x_msg := CZ_UTILS.GET_TEXT('CZ_CANNOT_MIGRATE');
327: END IF;
328: EXCEPTION
329: WHEN OTHERS THEN
330: x_msg := SQLERRM;