DBA Data[Home] [Help]

APPS.CAC_SYNC_CONTACTS_PVT dependencies on FND_MSG_PUB

Line 882: fnd_msg_pub.initialize;

878:
879: IF p_init_msg_list IS NULL OR
880: fnd_api.to_boolean (p_init_msg_list)
881: THEN
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...',

Line 1105: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1101: p_module_prefix=>'PREPARE_FASTSYNC');
1102:
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');

Line 1115: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1111: WHEN fnd_api.g_exc_unexpected_error
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

Line 1124: fnd_msg_pub.add;

1120: THEN
1121: ROLLBACK TO prepare_fastsync_sp;
1122: fnd_message.set_name ('CAC', 'CAC_CONTACT_UNKNOWN_ERROR');
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,

Line 1126: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1122: fnd_message.set_name ('CAC', 'CAC_CONTACT_UNKNOWN_ERROR');
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;

Line 1169: fnd_msg_pub.initialize;

1165:
1166: IF p_init_msg_list IS NULL OR
1167: fnd_api.to_boolean (p_init_msg_list)
1168: THEN
1169: fnd_msg_pub.initialize;
1170: END IF;
1171:
1172: -- Emptying the CAC_SYNC_CONTACT_TEMPS table not reqd as using ON COMMIT DELETE ROWS clause
1173:

Line 1247: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1243: p_module_prefix=>'PREPARE_SLOWSYNC');
1244:
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');

Line 1257: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1253: WHEN fnd_api.g_exc_unexpected_error
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:

Line 1267: fnd_msg_pub.add;

1263: THEN
1264: ROLLBACK TO prepare_slowsync_sp;
1265: fnd_message.set_name ('CAC', 'CAC_CONTACT_UNKNOWN_ERROR');
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,

Line 1269: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

1265: fnd_message.set_name ('CAC', 'CAC_CONTACT_UNKNOWN_ERROR');
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: