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 FND_LOG

Line 876: p_msg_level=>fnd_log.level_procedure,

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
880: fnd_api.to_boolean (p_init_msg_list)

Line 887: p_msg_level=>fnd_log.level_procedure,

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;
891: FOR rec_new_contacts IN c_new_contacts (p_principal_id,

Line 955: p_msg_level=>fnd_log.level_procedure,

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...',
959: p_msg_level=>fnd_log.level_procedure,

Line 959: p_msg_level=>fnd_log.level_procedure,

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;
963: FOR rec_updated_contacts IN c_updated_contacts (p_principal_id,

Line 1028: p_msg_level=>fnd_log.level_procedure,

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...',
1032: p_msg_level=>fnd_log.level_procedure,

Line 1032: p_msg_level=>fnd_log.level_procedure,

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;
1036: FOR rec_deleted_contacts IN c_deleted_contacts (p_principal_id,

Line 1100: p_msg_level => fnd_log.level_procedure,

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;
1104:

Line 1108: p_msg_level => fnd_log.level_procedure,

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
1112: THEN

Line 1117: p_msg_level => fnd_log.level_exception,

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
1121: ROLLBACK TO prepare_fastsync_sp;

Line 1128: p_msg_level => fnd_log.level_exception,

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:
1132: PROCEDURE PREPARE_SLOWSYNC

Line 1163: p_msg_level => fnd_log.level_procedure,

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
1167: fnd_api.to_boolean (p_init_msg_list)

Line 1175: p_msg_level=>fnd_log.level_procedure,

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;
1179: FOR rec_all_contacts IN c_all_contacts (p_person_party_id,

Line 1242: p_msg_level => fnd_log.level_procedure,

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;
1246:

Line 1250: p_msg_level => fnd_log.level_procedure,

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
1254: THEN

Line 1259: p_msg_level => fnd_log.level_exception,

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
1263: THEN

Line 1271: p_msg_level => fnd_log.level_exception,

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;
1275:

Line 1292: p_msg_level => fnd_log.level_procedure,

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...',
1296: p_msg_level => fnd_log.level_procedure,

Line 1296: p_msg_level => fnd_log.level_procedure,

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(
1300: p_country_code => p_country_code,