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_PB_SYNC dependencies on CZ_PB_SYNC_UTIL

Line 8: m_msg_tbl cz_pb_sync_util.message_list;

4: --------package variable declaration
5: TYPE t_ref IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6: TYPE t_name IS TABLE OF VARCHAR2(255) INDEX BY BINARY_INTEGER;
7:
8: m_msg_tbl cz_pb_sync_util.message_list;
9: m_err_message VARCHAR2(2000);
10:
11: SRC_SERVER_FLAG cz_servers.source_server_flag%TYPE := '1';
12:

Line 123: v_target_server_id := cz_pb_sync_util.get_target_instance_id(p_target_instance);

119: error_msg_populate(m_err_message ,'CZ_PB_SYNC.VERIFYSRCINST',21061);
120: RETURN FALSE;
121: END IF;
122:
123: v_target_server_id := cz_pb_sync_util.get_target_instance_id(p_target_instance);
124: v_link_name := cz_pb_sync_util.retrieve_link_name(v_target_server_id);
125: IF (NOT verify_src_server_entry(v_link_name,l_instance_name) ) THEN
126: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_NOT_TGT_INSTANCE',
127: 'TGTINSTANCE', p_target_instance,

Line 124: v_link_name := cz_pb_sync_util.retrieve_link_name(v_target_server_id);

120: RETURN FALSE;
121: END IF;
122:
123: v_target_server_id := cz_pb_sync_util.get_target_instance_id(p_target_instance);
124: v_link_name := cz_pb_sync_util.retrieve_link_name(v_target_server_id);
125: IF (NOT verify_src_server_entry(v_link_name,l_instance_name) ) THEN
126: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_NOT_TGT_INSTANCE',
127: 'TGTINSTANCE', p_target_instance,
128: 'SRCINSTANCE', l_instance_name);

Line 349: v_link_name := cz_pb_sync_util.retrieve_link_name(p_tgt_server_id);

345: BEGIN
346: FOR I IN 1..1
347: LOOP
348: ------get db link name for tgt instance
349: v_link_name := cz_pb_sync_util.retrieve_link_name(p_tgt_server_id);
350: IF ( NOT cz_pb_sync_util.check_db_link(v_link_name) ) THEN
351: v_sync_flag := FALSE;
352: EXIT;
353: END IF;

Line 350: IF ( NOT cz_pb_sync_util.check_db_link(v_link_name) ) THEN

346: FOR I IN 1..1
347: LOOP
348: ------get db link name for tgt instance
349: v_link_name := cz_pb_sync_util.retrieve_link_name(p_tgt_server_id);
350: IF ( NOT cz_pb_sync_util.check_db_link(v_link_name) ) THEN
351: v_sync_flag := FALSE;
352: EXIT;
353: END IF;
354:

Line 906: l_link_name := cz_pb_sync_util.retrieve_link_name(p_tgt_server_id);

902: OBJ_TYPE_ERR EXCEPTION;
903:
904: BEGIN
905: clear_publication_data(p_tgt_server_id);
906: l_link_name := cz_pb_sync_util.retrieve_link_name(p_tgt_server_id);
907:
908: l_tgt_src_pub_tbl.DELETE;
909: l_tgt_rem_pub_tbl.DELETE;
910: l_tgt_object_id_tbl.DELETE;

Line 1315: v_link_name := cz_pb_sync_util.retrieve_link_name(p_target_server_id);

1311: ----clear pb exports
1312: clear_pb_exports;
1313:
1314: ----update server id in tgt publication record
1315: v_link_name := cz_pb_sync_util.retrieve_link_name(p_target_server_id);
1316: update_tgt_server_id(p_target_server_id,v_link_name);
1317:
1318: ----update target server information
1319: update_server_info(p_target_server_id,v_link_name);

Line 1354: l_run_id := cz_pb_sync_util.get_run_id;

1350:
1351: FOR I IN 1..1
1352: LOOP
1353: ----get run id
1354: l_run_id := cz_pb_sync_util.get_run_id;
1355: x_run_id := l_run_id;
1356:
1357: IF (l_run_id = 0) THEN
1358: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SEQ_XFR');

Line 1365: l_proc_name := cz_pb_sync_util.check_process;

1361: EXIT;
1362: END IF;
1363:
1364: ----check if another sync is in progress
1365: l_proc_name := cz_pb_sync_util.check_process;
1366: IF l_proc_name IS NOT NULL THEN
1367: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_PROCESS_EXISTS');
1368: error_msg_populate(m_err_message ,'CZ_PB_SYNC.CHKPROCESS',21001);
1369: x_status := FND_API.G_RET_STS_ERROR;

Line 1373: cz_pb_sync_util.set_dbms_info('CZ_PB_SYNC');

1369: x_status := FND_API.G_RET_STS_ERROR;
1370: EXIT;
1371: ELSE
1372: ----register application
1373: cz_pb_sync_util.set_dbms_info('CZ_PB_SYNC');
1374: END IF;
1375:
1376: ----validate input parameters
1377: IF (NOT verify_input_parameters(p_target_instance) ) THEN

Line 1383: l_target_server_id := cz_pb_sync_util.get_target_instance_id(p_target_instance);

1379: EXIT;
1380: END IF;
1381:
1382: ---verify schema versions on the source and target instances
1383: l_target_server_id := cz_pb_sync_util.get_target_instance_id(p_target_instance);
1384:
1385: ------check for active links
1386: l_link_name := cz_pb_sync_util.retrieve_link_name(l_target_server_id);
1387: IF ( NOT cz_pb_sync_util.check_db_link(l_link_name) ) THEN

Line 1386: l_link_name := cz_pb_sync_util.retrieve_link_name(l_target_server_id);

1382: ---verify schema versions on the source and target instances
1383: l_target_server_id := cz_pb_sync_util.get_target_instance_id(p_target_instance);
1384:
1385: ------check for active links
1386: l_link_name := cz_pb_sync_util.retrieve_link_name(l_target_server_id);
1387: IF ( NOT cz_pb_sync_util.check_db_link(l_link_name) ) THEN
1388: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_NO_LINK_EXISTS','LINKNAME',l_link_name);
1389: error_msg_populate(m_err_message ,'CHECKDBLINK',21025);
1390: x_status := FND_API.G_RET_STS_ERROR;

Line 1387: IF ( NOT cz_pb_sync_util.check_db_link(l_link_name) ) THEN

1383: l_target_server_id := cz_pb_sync_util.get_target_instance_id(p_target_instance);
1384:
1385: ------check for active links
1386: l_link_name := cz_pb_sync_util.retrieve_link_name(l_target_server_id);
1387: IF ( NOT cz_pb_sync_util.check_db_link(l_link_name) ) THEN
1388: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_NO_LINK_EXISTS','LINKNAME',l_link_name);
1389: error_msg_populate(m_err_message ,'CHECKDBLINK',21025);
1390: x_status := FND_API.G_RET_STS_ERROR;
1391: EXIT;

Line 1401: l_validate_flg := cz_pb_sync_util.validate_schema(l_target_server_id);

1397: x_status := FND_API.G_RET_STS_ERROR;
1398: EXIT;
1399: END IF;
1400:
1401: l_validate_flg := cz_pb_sync_util.validate_schema(l_target_server_id);
1402: IF (NOT l_validate_flg ) THEN
1403: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SCHEMA_COMPAT_ERR');
1404: error_msg_populate(m_err_message ,'VALIDATESCHEMA',21005);
1405: x_status := FND_API.G_RET_STS_ERROR;

Line 1440: cz_pb_sync_util.log_pb_sync_errors(m_msg_tbl,l_run_id);

1436: IF (x_status = FND_API.G_RET_STS_ERROR) THEN
1437: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_FAILURE', 'INSTANCENAME',p_target_instance);
1438: error_msg_populate(m_err_message ,'SYNCCLOTGTPBDATA',21014);
1439: END IF;
1440: cz_pb_sync_util.log_pb_sync_errors(m_msg_tbl,l_run_id);
1441:
1442: -----unregister application
1443: cz_pb_sync_util.reset_dbms_info;
1444: EXCEPTION

Line 1443: cz_pb_sync_util.reset_dbms_info;

1439: END IF;
1440: cz_pb_sync_util.log_pb_sync_errors(m_msg_tbl,l_run_id);
1441:
1442: -----unregister application
1443: cz_pb_sync_util.reset_dbms_info;
1444: EXCEPTION
1445: WHEN OTHERS THEN
1446: x_status := FND_API.G_RET_STS_UNEXP_ERROR;
1447: END sync_cloned_tgt_pub_data;

Line 1562: v_run_id := cz_pb_sync_util.get_run_id;

1558:
1559: FOR I IN 1..1
1560: LOOP
1561: ----get run id for message
1562: v_run_id := cz_pb_sync_util.get_run_id;
1563: x_run_id := v_run_id;
1564:
1565: IF (v_run_id = 0) THEN
1566: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SEQ_XFR');

Line 1573: l_proc_name := cz_pb_sync_util.check_process;

1569: EXIT;
1570: END IF;
1571:
1572: ----check if another sync is in progress
1573: l_proc_name := cz_pb_sync_util.check_process;
1574: IF l_proc_name IS NOT NULL THEN
1575: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_PROCESS_EXISTS');
1576: error_msg_populate(m_err_message ,'CZ_PB_SYNC.CHKPROCESS',21001);
1577: x_status := FND_API.G_RET_STS_ERROR;

Line 1581: cz_pb_sync_util.set_dbms_info('CZ_PB_SYNC');

1577: x_status := FND_API.G_RET_STS_ERROR;
1578: EXIT;
1579: ELSE
1580: ----register application
1581: cz_pb_sync_util.set_dbms_info('CZ_PB_SYNC');
1582: END IF;
1583:
1584: ----validate input parameter
1585: IF (UPPER(p_decomm_flag) NOT IN ('YES','NO') ) THEN

Line 1621: IF ( NOT cz_pb_sync_util.check_db_link(v_link_name) ) THEN

1617: LOOP
1618: v_link_name := get_link_name(l_local_name_tbl(localName));
1619: IF (v_link_name IS NOT NULL) THEN
1620: v_link_name := '@'||v_link_name;
1621: IF ( NOT cz_pb_sync_util.check_db_link(v_link_name) ) THEN
1622: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_NO_LINK_EXISTS','LINKNAME',v_link_name);
1623: error_msg_populate(m_err_message ,'CHECKDBLINK',21025);
1624: x_status := FND_API.G_RET_STS_ERROR;
1625: EXIT;

Line 1645: cz_pb_sync_util.log_pb_sync_errors(m_msg_tbl,v_run_id);

1641: m_err_message := CZ_UTILS.GET_TEXT('CZ_PB_SYNC_FAILURE', 'SRCINSTANCE',l_instance_name);
1642: error_msg_populate(m_err_message ,'SYNCCLOTGTPBDATA',21014);
1643: x_status := FND_API.G_RET_STS_ERROR;
1644: END IF;
1645: cz_pb_sync_util.log_pb_sync_errors(m_msg_tbl,v_run_id);
1646:
1647: -----unregister application
1648: cz_pb_sync_util.reset_dbms_info;
1649: COMMIT;

Line 1648: cz_pb_sync_util.reset_dbms_info;

1644: END IF;
1645: cz_pb_sync_util.log_pb_sync_errors(m_msg_tbl,v_run_id);
1646:
1647: -----unregister application
1648: cz_pb_sync_util.reset_dbms_info;
1649: COMMIT;
1650: EXCEPTION
1651: WHEN OTHERS THEN
1652: x_status := FND_API.G_RET_STS_UNEXP_ERROR;