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.CAC_SYNC_CONTACTS_PVT dependencies on CAC_SYNC_CONTACT_UTIL_PVT

Line 875: cac_sync_contact_util_pvt.log(p_message=>'Entering PREPARE_FASTSYNC...',

871: l_bkm_preference_code := fnd_profile.value('CAC_SYNC_CONT_BKM_PREFERENCE_CODE');
872:
873: SAVEPOINT prepare_fastsync_sp;
874:
875: cac_sync_contact_util_pvt.log(p_message=>'Entering PREPARE_FASTSYNC...',
876: p_msg_level=>fnd_log.level_procedure,
877: p_module_prefix=>'PREPARE_FASTSYNC');
878:
879: IF p_init_msg_list IS NULL OR

Line 886: cac_sync_contact_util_pvt.log(p_message=>'Querying the new contacts...',

882: fnd_msg_pub.initialize;
883: END IF;
884:
885: -- Emptying the CAC_SYNC_CONTACT_TEMPS table not reqd as using ON COMMIT DELETE ROWS clause
886: cac_sync_contact_util_pvt.log(p_message=>'Querying the new contacts...',
887: p_msg_level=>fnd_log.level_procedure,
888: p_module_prefix=>'PREPARE_FASTSYNC');
889:
890: l_count := 0;

Line 954: cac_sync_contact_util_pvt.log(p_message=>'The number of new contacts queried: '||l_count,

950: );
951: l_count := l_count + 1;
952: END LOOP;
953:
954: cac_sync_contact_util_pvt.log(p_message=>'The number of new contacts queried: '||l_count,
955: p_msg_level=>fnd_log.level_procedure,
956: p_module_prefix=>'PREPARE_FASTSYNC');
957:
958: cac_sync_contact_util_pvt.log(p_message=>'Querying the updated contacts...',

Line 958: cac_sync_contact_util_pvt.log(p_message=>'Querying the updated contacts...',

954: cac_sync_contact_util_pvt.log(p_message=>'The number of new contacts queried: '||l_count,
955: p_msg_level=>fnd_log.level_procedure,
956: p_module_prefix=>'PREPARE_FASTSYNC');
957:
958: cac_sync_contact_util_pvt.log(p_message=>'Querying the updated contacts...',
959: p_msg_level=>fnd_log.level_procedure,
960: p_module_prefix=>'PREPARE_FASTSYNC');
961:
962: l_count := 0;

Line 1027: cac_sync_contact_util_pvt.log(p_message=>'The number of updated contacts queried: '||l_count,

1023: );
1024: l_count := l_count + 1;
1025: END LOOP;
1026:
1027: cac_sync_contact_util_pvt.log(p_message=>'The number of updated contacts queried: '||l_count,
1028: p_msg_level=>fnd_log.level_procedure,
1029: p_module_prefix=>'PREPARE_FASTSYNC');
1030:
1031: cac_sync_contact_util_pvt.log(p_message=>'Querying the deleted contacts...',

Line 1031: cac_sync_contact_util_pvt.log(p_message=>'Querying the deleted contacts...',

1027: cac_sync_contact_util_pvt.log(p_message=>'The number of updated contacts queried: '||l_count,
1028: p_msg_level=>fnd_log.level_procedure,
1029: p_module_prefix=>'PREPARE_FASTSYNC');
1030:
1031: cac_sync_contact_util_pvt.log(p_message=>'Querying the deleted contacts...',
1032: p_msg_level=>fnd_log.level_procedure,
1033: p_module_prefix=>'PREPARE_FASTSYNC');
1034:
1035: l_count := 0;

Line 1099: cac_sync_contact_util_pvt.log(p_message => 'The number of deleted contacts queried: '||l_count,

1095: );
1096: l_count := l_count + 1;
1097: END LOOP;
1098:
1099: cac_sync_contact_util_pvt.log(p_message => 'The number of deleted contacts queried: '||l_count,
1100: p_msg_level => fnd_log.level_procedure,
1101: p_module_prefix=>'PREPARE_FASTSYNC');
1102:
1103: x_return_status := fnd_api.g_ret_sts_success;

Line 1107: cac_sync_contact_util_pvt.log(p_message => 'Leaving PREPARE_FASTSYNC...: '||x_return_status,

1103: x_return_status := fnd_api.g_ret_sts_success;
1104:
1105: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1106:
1107: cac_sync_contact_util_pvt.log(p_message => 'Leaving PREPARE_FASTSYNC...: '||x_return_status,
1108: p_msg_level => fnd_log.level_procedure,
1109: p_module_prefix=>'PREPARE_FASTSYNC');
1110: EXCEPTION
1111: WHEN fnd_api.g_exc_unexpected_error

Line 1116: cac_sync_contact_util_pvt.log(p_message => x_msg_data,

1112: THEN
1113: ROLLBACK TO prepare_fastsync_sp;
1114: x_return_status := fnd_api.g_ret_sts_unexp_error;
1115: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1116: cac_sync_contact_util_pvt.log(p_message => x_msg_data,
1117: p_msg_level => fnd_log.level_exception,
1118: p_module_prefix=>'PREPARE_FASTSYNC');
1119: WHEN OTHERS
1120: THEN

Line 1127: cac_sync_contact_util_pvt.log(p_message => x_msg_data,

1123: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1124: fnd_msg_pub.add;
1125: x_return_status := fnd_api.g_ret_sts_unexp_error;
1126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1127: cac_sync_contact_util_pvt.log(p_message => x_msg_data,
1128: p_msg_level => fnd_log.level_exception,
1129: p_module_prefix=>'PREPARE_FASTSYNC');
1130: END PREPARE_FASTSYNC;
1131:

Line 1162: cac_sync_contact_util_pvt.log(p_message => 'Entering PREPARE_SLOWSYNC...: ',

1158: l_bkm_preference_code := fnd_profile.value('CAC_SYNC_CONT_BKM_PREFERENCE_CODE');
1159:
1160: SAVEPOINT prepare_slowsync_sp;
1161:
1162: cac_sync_contact_util_pvt.log(p_message => 'Entering PREPARE_SLOWSYNC...: ',
1163: p_msg_level => fnd_log.level_procedure,
1164: p_module_prefix=>'PREPARE_SLOWSYNC');
1165:
1166: IF p_init_msg_list IS NULL OR

Line 1174: cac_sync_contact_util_pvt.log(p_message=>'Retrieving all the contacts...',

1170: END IF;
1171:
1172: -- Emptying the CAC_SYNC_CONTACT_TEMPS table not reqd as using ON COMMIT DELETE ROWS clause
1173:
1174: cac_sync_contact_util_pvt.log(p_message=>'Retrieving all the contacts...',
1175: p_msg_level=>fnd_log.level_procedure,
1176: p_module_prefix=>'PREPARE_SLOWSYNC');
1177:
1178: l_count := 0;

Line 1241: cac_sync_contact_util_pvt.log(p_message => 'The number of contacts queried: '||l_count,

1237: );
1238: l_count := l_count + 1;
1239: END LOOP;
1240:
1241: cac_sync_contact_util_pvt.log(p_message => 'The number of contacts queried: '||l_count,
1242: p_msg_level => fnd_log.level_procedure,
1243: p_module_prefix=>'PREPARE_SLOWSYNC');
1244:
1245: x_return_status := fnd_api.g_ret_sts_success;

Line 1249: cac_sync_contact_util_pvt.log(p_message => 'Leaving PREPARE_SLOWSYNC...:'||x_return_status,

1245: x_return_status := fnd_api.g_ret_sts_success;
1246:
1247: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1248:
1249: cac_sync_contact_util_pvt.log(p_message => 'Leaving PREPARE_SLOWSYNC...:'||x_return_status,
1250: p_msg_level => fnd_log.level_procedure,
1251: p_module_prefix=>'PREPARE_SLOWSYNC');
1252: EXCEPTION
1253: WHEN fnd_api.g_exc_unexpected_error

Line 1258: cac_sync_contact_util_pvt.log(p_message => x_msg_data,

1254: THEN
1255: ROLLBACK TO prepare_slowsync_sp;
1256: x_return_status := fnd_api.g_ret_sts_unexp_error;
1257: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1258: cac_sync_contact_util_pvt.log(p_message => x_msg_data,
1259: p_msg_level => fnd_log.level_exception,
1260: p_module_prefix=>'PREPARE_SLOWSYNC');
1261:
1262: WHEN OTHERS

Line 1270: cac_sync_contact_util_pvt.log(p_message => x_msg_data,

1266: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
1267: fnd_msg_pub.add;
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1270: cac_sync_contact_util_pvt.log(p_message => x_msg_data,
1271: p_msg_level => fnd_log.level_exception,
1272: p_module_prefix=>'PREPARE_SLOWSYNC');
1273:
1274: END PREPARE_SLOWSYNC;

Line 1281: ** Format phone fucntion calling CAC_SYNC_CONTACT_UTIL_PVT.format_phone()

1277: /*******************************************************************************
1278: **
1279: ** FORMAT_PHONE
1280: **
1281: ** Format phone fucntion calling CAC_SYNC_CONTACT_UTIL_PVT.format_phone()
1282: **
1283: *******************************************************************************/
1284: ( p_country_code IN VARCHAR2
1285: , p_area_code IN VARCHAR2

Line 1291: cac_sync_contact_util_pvt.log(p_message => 'Entering FORMAT_PHONE...',

1287: , p_phone_extension IN VARCHAR2
1288: ) RETURN VARCHAR2
1289: IS
1290: BEGIN
1291: cac_sync_contact_util_pvt.log(p_message => 'Entering FORMAT_PHONE...',
1292: p_msg_level => fnd_log.level_procedure,
1293: p_module_prefix=>'FORMAT_PHONE');
1294:
1295: cac_sync_contact_util_pvt.log(p_message => 'Calling CAC_SYNC_CONTACT_UTIL_PVT.FORMAT_PHONE...',

Line 1295: cac_sync_contact_util_pvt.log(p_message => 'Calling CAC_SYNC_CONTACT_UTIL_PVT.FORMAT_PHONE...',

1291: cac_sync_contact_util_pvt.log(p_message => 'Entering FORMAT_PHONE...',
1292: p_msg_level => fnd_log.level_procedure,
1293: p_module_prefix=>'FORMAT_PHONE');
1294:
1295: cac_sync_contact_util_pvt.log(p_message => 'Calling CAC_SYNC_CONTACT_UTIL_PVT.FORMAT_PHONE...',
1296: p_msg_level => fnd_log.level_procedure,
1297: p_module_prefix=>'FORMAT_PHONE');
1298:
1299: RETURN CAC_SYNC_CONTACT_UTIL_PVT.FORMAT_PHONE(

Line 1299: RETURN CAC_SYNC_CONTACT_UTIL_PVT.FORMAT_PHONE(

1295: cac_sync_contact_util_pvt.log(p_message => 'Calling CAC_SYNC_CONTACT_UTIL_PVT.FORMAT_PHONE...',
1296: p_msg_level => fnd_log.level_procedure,
1297: p_module_prefix=>'FORMAT_PHONE');
1298:
1299: RETURN CAC_SYNC_CONTACT_UTIL_PVT.FORMAT_PHONE(
1300: p_country_code => p_country_code,
1301: p_area_code => p_area_code,
1302: p_phone_number => p_phone_number,
1303: p_phone_extension => p_phone_extension,