DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on HZ_COMMON_PUB

Line 574: hz_common_pub.enable_cont_source_security;

570: END IF;
571: END IF;
572: EXCEPTION
573: WHEN OTHERS THEN
574: hz_common_pub.enable_cont_source_security;
575: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
576: FND_MESSAGE.SET_TOKEN('PROC','sync_org');
577: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
578: FND_MSG_PUB.ADD;

Line 696: hz_common_pub.enable_cont_source_security;

692: END IF;
693: END IF;
694: EXCEPTION
695: WHEN OTHERS THEN
696: hz_common_pub.enable_cont_source_security;
697: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
698: FND_MESSAGE.SET_TOKEN('PROC','sync_party_site');
699: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
700: FND_MSG_PUB.ADD;

Line 744: hz_common_pub.enable_cont_source_security;

740: EXCEPTION
741: WHEN NO_DATA_FOUND THEN
742: NULL;
743: WHEN OTHERS THEN
744: hz_common_pub.enable_cont_source_security;
745: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
746: FND_MESSAGE.SET_TOKEN('PROC','sync_contact');
747: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
748: FND_MSG_PUB.ADD;

Line 841: hz_common_pub.enable_cont_source_security;

837: END IF;
838: END IF;
839: EXCEPTION
840: WHEN OTHERS THEN
841: hz_common_pub.enable_cont_source_security;
842: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
843: FND_MESSAGE.SET_TOKEN('PROC','sync_contact_point');
844: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
845: FND_MSG_PUB.ADD;

Line 878: hz_common_pub.enable_cont_source_security;

874: END IF;
875:
876: EXCEPTION
877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878: hz_common_pub.enable_cont_source_security;
879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
880: WHEN OTHERS THEN
881: hz_common_pub.enable_cont_source_security;
882: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

Line 881: hz_common_pub.enable_cont_source_security;

877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878: hz_common_pub.enable_cont_source_security;
879: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
880: WHEN OTHERS THEN
881: hz_common_pub.enable_cont_source_security;
882: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
883: FND_MESSAGE.SET_TOKEN('PROC','sync_relationship');
884: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
885: FND_MSG_PUB.ADD;

Line 919: hz_common_pub.enable_cont_source_security;

915: END IF;
916:
917: EXCEPTION
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: hz_common_pub.enable_cont_source_security;
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: WHEN OTHERS THEN
922: hz_common_pub.enable_cont_source_security;
923: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

Line 922: hz_common_pub.enable_cont_source_security;

918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: hz_common_pub.enable_cont_source_security;
920: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
921: WHEN OTHERS THEN
922: hz_common_pub.enable_cont_source_security;
923: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
924: FND_MESSAGE.SET_TOKEN('PROC','sync_location');
925: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
926: FND_MSG_PUB.ADD;

Line 967: hz_common_pub.enable_cont_source_security;

963: CLOSE c_cust_party;
964: END IF;
965: EXCEPTION
966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
967: hz_common_pub.enable_cont_source_security;
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
969: WHEN OTHERS THEN
970: hz_common_pub.enable_cont_source_security;
971: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');

Line 970: hz_common_pub.enable_cont_source_security;

966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
967: hz_common_pub.enable_cont_source_security;
968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
969: WHEN OTHERS THEN
970: hz_common_pub.enable_cont_source_security;
971: FND_MESSAGE.SET_NAME('AR', 'HZ_SYNC_SQL_EXCEP');
972: FND_MESSAGE.SET_TOKEN('PROC','sync_cust_account');
973: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
974: FND_MSG_PUB.ADD;