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: --fix 8607367 Implementor of cz_utils.log_report need to commit
41: COMMIT;

Line 40: --fix 8607367 Implementor of cz_utils.log_report need to commit

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: --fix 8607367 Implementor of cz_utils.log_report need to commit
41: COMMIT;
42: END IF;
43: EXCEPTION
44: WHEN OTHERS THEN

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

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

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

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

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

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

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

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

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

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

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

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