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.HZ_ORG_CONTACT_BO_PUB dependencies on HZ_UTILITY_V2PUB

Line 146: px_person_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

142: px_person_rec.internal_flag:= p_person_obj.internal_flag;
143: IF(p_create_or_update = 'C') THEN
144: px_person_rec.party_rec.orig_system:= p_person_os;
145: px_person_rec.party_rec.orig_system_reference:= p_person_osr;
146: px_person_rec.created_by_module:= HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
147: END IF;
148: px_person_rec.actual_content_source:= p_person_obj.actual_content_source;
149: px_person_rec.party_rec.party_id:= p_person_id;
150: px_person_rec.party_rec.party_number:= p_person_obj.party_number;

Line 262: px_org_contact_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

258: px_org_contact_rec.attribute24 := p_org_contact_obj.attribute24;
259: IF(p_create_or_update = 'C') THEN
260: px_org_contact_rec.orig_system := p_oc_os;
261: px_org_contact_rec.orig_system_reference := p_oc_osr;
262: px_org_contact_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
263: END IF;
264: px_org_contact_rec.party_rel_rec.subject_id := p_person_id;
265: px_org_contact_rec.party_rel_rec.subject_type := 'PERSON';
266: px_org_contact_rec.party_rel_rec.subject_table_name := 'HZ_PARTIES';

Line 277: px_org_contact_rec.party_rel_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

273: px_org_contact_rec.party_rel_rec.start_date := p_org_contact_obj.start_date;
274: px_org_contact_rec.party_rel_rec.end_date := p_org_contact_obj.end_date;
275: px_org_contact_rec.party_rel_rec.status := p_org_contact_obj.status;
276: IF(p_create_or_update = 'C') THEN
277: px_org_contact_rec.party_rel_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
278: END IF;
279: END assign_org_contact_rec;
280:
281: -- PROCEDURE do_create_org_contact_bo

Line 353: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

349: FND_MSG_PUB.initialize;
350: END IF;
351:
352: -- initialize Global variable
353: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
354: IF(p_created_by_module IS NULL) THEN
355: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
356: ELSE
357: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 355: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

351:
352: -- initialize Global variable
353: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
354: IF(p_created_by_module IS NULL) THEN
355: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
356: ELSE
357: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
358: END IF;
359:

Line 357: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

353: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
354: IF(p_created_by_module IS NULL) THEN
355: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
356: ELSE
357: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
358: END IF;
359:
360: -- Debug info.
361: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 362: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(+)',

358: END IF;
359:
360: -- Debug info.
361: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
362: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(+)',
363: p_prefix=>l_debug_prefix,
364: p_msg_level=>fnd_log.level_procedure);
365: END IF;
366:

Line 542: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
540: END IF;
541:
542: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
543:
544: ---------------------
545: -- Create party sites
546: ---------------------

Line 567: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565: END IF;
566:
567: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
568:
569: ----------------------------------------------------------
570: -- Create all contact points - phone, telex, email and web
571: ----------------------------------------------------------

Line 601: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599: END IF;
600:
601: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
602:
603: ----------------------------
604: -- Create contact preference
605: ----------------------------

Line 623: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

619: END IF;
620: END IF;
621:
622: -- reset Global variable
623: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
624: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
625:
626: -- Debug info.
627: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 624: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

620: END IF;
621:
622: -- reset Global variable
623: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
624: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
625:
626: -- Debug info.
627: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
628: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 628: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

624: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
625:
626: -- Debug info.
627: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
628: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
629: p_msg_data=>x_msg_data,
630: p_msg_type=>'WARNING',
631: p_msg_level=>fnd_log.level_exception);
632: END IF;

Line 634: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',

630: p_msg_type=>'WARNING',
631: p_msg_level=>fnd_log.level_exception);
632: END IF;
633: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
634: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
635: p_prefix=>l_debug_prefix,
636: p_msg_level=>fnd_log.level_procedure);
637: END IF;
638:

Line 644: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

640: WHEN fnd_api.g_exc_error THEN
641: ROLLBACK TO do_create_org_contact_bo_pub;
642:
643: -- reset Global variable
644: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
645: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
646:
647: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
648: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');

Line 645: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

641: ROLLBACK TO do_create_org_contact_bo_pub;
642:
643: -- reset Global variable
644: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
645: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
646:
647: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
648: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
649: FND_MSG_PUB.ADD;

Line 659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

655: p_data => x_msg_data);
656:
657: -- Debug info.
658: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
659: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
660: p_msg_data=>x_msg_data,
661: p_msg_type=>'ERROR',
662: p_msg_level=>fnd_log.level_error);
663: END IF;

Line 665: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',

661: p_msg_type=>'ERROR',
662: p_msg_level=>fnd_log.level_error);
663: END IF;
664: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
665: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
666: p_prefix=>l_debug_prefix,
667: p_msg_level=>fnd_log.level_procedure);
668: END IF;
669:

Line 674: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

670: WHEN fnd_api.g_exc_unexpected_error THEN
671: ROLLBACK TO do_create_org_contact_bo_pub;
672:
673: -- reset Global variable
674: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
675: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
676:
677: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
678: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');

Line 675: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

671: ROLLBACK TO do_create_org_contact_bo_pub;
672:
673: -- reset Global variable
674: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
675: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
676:
677: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
678: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
679: FND_MSG_PUB.ADD;

Line 689: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

685: p_data => x_msg_data);
686:
687: -- Debug info.
688: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
689: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
690: p_msg_data=>x_msg_data,
691: p_msg_type=>'UNEXPECTED ERROR',
692: p_msg_level=>fnd_log.level_error);
693: END IF;

Line 695: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',

691: p_msg_type=>'UNEXPECTED ERROR',
692: p_msg_level=>fnd_log.level_error);
693: END IF;
694: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
695: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
696: p_prefix=>l_debug_prefix,
697: p_msg_level=>fnd_log.level_procedure);
698: END IF;
699:

Line 704: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

700: WHEN OTHERS THEN
701: ROLLBACK TO do_create_org_contact_bo_pub;
702:
703: -- reset Global variable
704: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
705: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
706:
707: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
708: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');

Line 705: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

701: ROLLBACK TO do_create_org_contact_bo_pub;
702:
703: -- reset Global variable
704: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
705: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
706:
707: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
708: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
709: FND_MSG_PUB.ADD;

Line 723: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

719: p_data => x_msg_data);
720:
721: -- Debug info.
722: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
723: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
724: p_msg_data=>x_msg_data,
725: p_msg_type=>'SQL ERROR',
726: p_msg_level=>fnd_log.level_error);
727: END IF;

Line 729: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',

725: p_msg_type=>'SQL ERROR',
726: p_msg_level=>fnd_log.level_error);
727: END IF;
728: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
729: hz_utility_v2pub.debug(p_message=>'do_create_org_contact_bo(-)',
730: p_prefix=>l_debug_prefix,
731: p_msg_level=>fnd_log.level_procedure);
732: END IF;
733: END do_create_org_contact_bo;

Line 959: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

955: FND_MSG_PUB.initialize;
956: END IF;
957:
958: -- initialize Global variable
959: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
960: IF(p_created_by_module IS NULL) THEN
961: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
962: ELSE
963: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

Line 961: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';

957:
958: -- initialize Global variable
959: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
960: IF(p_created_by_module IS NULL) THEN
961: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
962: ELSE
963: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
964: END IF;
965:

Line 963: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

959: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
960: IF(p_created_by_module IS NULL) THEN
961: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
962: ELSE
963: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
964: END IF;
965:
966: -- Debug info.
967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 968: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(+)',

964: END IF;
965:
966: -- Debug info.
967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
968: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(+)',
969: p_prefix=>l_debug_prefix,
970: p_msg_level=>fnd_log.level_procedure);
971: END IF;
972:

Line 1121: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;
1119: END IF;
1120:
1121: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1122:
1123: ---------------------
1124: -- Update party sites
1125: ---------------------

Line 1146: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: END IF;
1145:
1146: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1147:
1148: -- Owner table id of contact point should be the party of the relationship for org contact
1149: -- Therefore, should pass in party_id as p_owner_table_id
1150: -- Same situation apply to p_owner_table_os, p_owner_table_osr

Line 1183: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181: END IF;
1182:
1183: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1184:
1185: -------------------------
1186: -- For Contact Preference
1187: -------------------------

Line 1205: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1201: END IF;
1202: END IF;
1203:
1204: -- reset Global variable
1205: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1206: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1207:
1208: -- Debug info.
1209: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1206: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1202: END IF;
1203:
1204: -- reset Global variable
1205: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1206: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1207:
1208: -- Debug info.
1209: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1210: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

Line 1210: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1206: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1207:
1208: -- Debug info.
1209: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1210: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1211: p_msg_data=>x_msg_data,
1212: p_msg_type=>'WARNING',
1213: p_msg_level=>fnd_log.level_exception);
1214: END IF;

Line 1216: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',

1212: p_msg_type=>'WARNING',
1213: p_msg_level=>fnd_log.level_exception);
1214: END IF;
1215: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1216: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1217: p_prefix=>l_debug_prefix,
1218: p_msg_level=>fnd_log.level_procedure);
1219: END IF;
1220: EXCEPTION

Line 1225: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1221: WHEN fnd_api.g_exc_error THEN
1222: ROLLBACK TO do_update_org_contact_bo_pub;
1223:
1224: -- reset Global variable
1225: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1226: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1227:
1228: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1229: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');

Line 1226: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1222: ROLLBACK TO do_update_org_contact_bo_pub;
1223:
1224: -- reset Global variable
1225: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1226: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1227:
1228: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1229: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1230: FND_MSG_PUB.ADD;

Line 1240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1236: p_data => x_msg_data);
1237:
1238: -- Debug info.
1239: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1240: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1241: p_msg_data=>x_msg_data,
1242: p_msg_type=>'ERROR',
1243: p_msg_level=>fnd_log.level_error);
1244: END IF;

Line 1246: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',

1242: p_msg_type=>'ERROR',
1243: p_msg_level=>fnd_log.level_error);
1244: END IF;
1245: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1246: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1247: p_prefix=>l_debug_prefix,
1248: p_msg_level=>fnd_log.level_procedure);
1249: END IF;
1250:

Line 1255: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1251: WHEN fnd_api.g_exc_unexpected_error THEN
1252: ROLLBACK TO do_update_org_contact_bo_pub;
1253:
1254: -- reset Global variable
1255: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1256: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1257:
1258: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1259: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');

Line 1256: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1252: ROLLBACK TO do_update_org_contact_bo_pub;
1253:
1254: -- reset Global variable
1255: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1256: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1257:
1258: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1259: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1260: FND_MSG_PUB.ADD;

Line 1270: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1266: p_data => x_msg_data);
1267:
1268: -- Debug info.
1269: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1270: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1271: p_msg_data=>x_msg_data,
1272: p_msg_type=>'UNEXPECTED ERROR',
1273: p_msg_level=>fnd_log.level_error);
1274: END IF;

Line 1276: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',

1272: p_msg_type=>'UNEXPECTED ERROR',
1273: p_msg_level=>fnd_log.level_error);
1274: END IF;
1275: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1276: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1277: p_prefix=>l_debug_prefix,
1278: p_msg_level=>fnd_log.level_procedure);
1279: END IF;
1280:

Line 1285: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1281: WHEN OTHERS THEN
1282: ROLLBACK TO do_update_org_contact_bo_pub;
1283:
1284: -- reset Global variable
1285: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1286: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1287:
1288: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1289: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');

Line 1286: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1282: ROLLBACK TO do_update_org_contact_bo_pub;
1283:
1284: -- reset Global variable
1285: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1286: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1287:
1288: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1289: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CONTACT');
1290: FND_MSG_PUB.ADD;

Line 1304: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1300: p_data => x_msg_data);
1301:
1302: -- Debug info.
1303: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1304: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1305: p_msg_data=>x_msg_data,
1306: p_msg_type=>'SQL ERROR',
1307: p_msg_level=>fnd_log.level_error);
1308: END IF;

Line 1310: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',

1306: p_msg_type=>'SQL ERROR',
1307: p_msg_level=>fnd_log.level_error);
1308: END IF;
1309: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1310: hz_utility_v2pub.debug(p_message=>'do_update_org_contact_bo(-)',
1311: p_prefix=>l_debug_prefix,
1312: p_msg_level=>fnd_log.level_procedure);
1313: END IF;
1314: END do_update_org_contact_bo;

Line 1352: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(+)',

1348: END IF;
1349:
1350: -- Debug info.
1351: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1352: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(+)',
1353: p_prefix=>l_debug_prefix,
1354: p_msg_level=>fnd_log.level_procedure);
1355: END IF;
1356:

Line 1415: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1411: END IF;
1412:
1413: -- Debug info.
1414: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1415: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1416: p_msg_data=>x_msg_data,
1417: p_msg_type=>'WARNING',
1418: p_msg_level=>fnd_log.level_exception);
1419: END IF;

Line 1421: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',

1417: p_msg_type=>'WARNING',
1418: p_msg_level=>fnd_log.level_exception);
1419: END IF;
1420: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1421: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1422: p_prefix=>l_debug_prefix,
1423: p_msg_level=>fnd_log.level_procedure);
1424: END IF;
1425:

Line 1436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1432: p_data => x_msg_data);
1433:
1434: -- Debug info.
1435: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1436: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1437: p_msg_data=>x_msg_data,
1438: p_msg_type=>'ERROR',
1439: p_msg_level=>fnd_log.level_error);
1440: END IF;

Line 1442: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',

1438: p_msg_type=>'ERROR',
1439: p_msg_level=>fnd_log.level_error);
1440: END IF;
1441: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1442: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1443: p_prefix=>l_debug_prefix,
1444: p_msg_level=>fnd_log.level_procedure);
1445: END IF;
1446: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1455: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1451: p_data => x_msg_data);
1452:
1453: -- Debug info.
1454: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1455: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1456: p_msg_data=>x_msg_data,
1457: p_msg_type=>'UNEXPECTED ERROR',
1458: p_msg_level=>fnd_log.level_error);
1459: END IF;

Line 1461: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',

1457: p_msg_type=>'UNEXPECTED ERROR',
1458: p_msg_level=>fnd_log.level_error);
1459: END IF;
1460: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1461: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1462: p_prefix=>l_debug_prefix,
1463: p_msg_level=>fnd_log.level_procedure);
1464: END IF;
1465: WHEN OTHERS THEN

Line 1478: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1474: p_data => x_msg_data);
1475:
1476: -- Debug info.
1477: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1478: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1479: p_msg_data=>x_msg_data,
1480: p_msg_type=>'SQL ERROR',
1481: p_msg_level=>fnd_log.level_error);
1482: END IF;

Line 1484: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',

1480: p_msg_type=>'SQL ERROR',
1481: p_msg_level=>fnd_log.level_error);
1482: END IF;
1483: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1484: hz_utility_v2pub.debug(p_message=>'do_save_org_contact_bo(-)',
1485: p_prefix=>l_debug_prefix,
1486: p_msg_level=>fnd_log.level_procedure);
1487: END IF;
1488: END do_save_org_contact_bo;

Line 1635: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo(+)',

1631:
1632:
1633: -- Debug info.
1634: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1635: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo(+)',
1636: p_prefix=>l_debug_prefix,
1637: p_msg_level=>fnd_log.level_procedure);
1638: END IF;
1639:

Line 1678: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1674:
1675:
1676: -- Debug info.
1677: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1678: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1679: p_msg_data=>x_msg_data,
1680: p_msg_type=>'WARNING',
1681: p_msg_level=>fnd_log.level_exception);
1682: END IF;

Line 1686: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',

1682: END IF;
1683:
1684: -- Debug info.
1685: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1686: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1687: p_prefix=>l_debug_prefix,
1688: p_msg_level=>fnd_log.level_procedure);
1689: END IF;
1690:

Line 1703: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1699: p_data => x_msg_data);
1700:
1701: -- Debug info.
1702: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1703: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1704: p_msg_data=>x_msg_data,
1705: p_msg_type=>'ERROR',
1706: p_msg_level=>fnd_log.level_error);
1707: END IF;

Line 1709: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',

1705: p_msg_type=>'ERROR',
1706: p_msg_level=>fnd_log.level_error);
1707: END IF;
1708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1709: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1710: p_prefix=>l_debug_prefix,
1711: p_msg_level=>fnd_log.level_procedure);
1712: END IF;
1713: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1722: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1718: p_data => x_msg_data);
1719:
1720: -- Debug info.
1721: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1722: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1723: p_msg_data=>x_msg_data,
1724: p_msg_type=>'UNEXPECTED ERROR',
1725: p_msg_level=>fnd_log.level_error);
1726: END IF;

Line 1728: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',

1724: p_msg_type=>'UNEXPECTED ERROR',
1725: p_msg_level=>fnd_log.level_error);
1726: END IF;
1727: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1728: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1729: p_prefix=>l_debug_prefix,
1730: p_msg_level=>fnd_log.level_procedure);
1731: END IF;
1732: WHEN OTHERS THEN

Line 1745: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

1741: p_data => x_msg_data);
1742:
1743: -- Debug info.
1744: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1745: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1746: p_msg_data=>x_msg_data,
1747: p_msg_type=>'SQL ERROR',
1748: p_msg_level=>fnd_log.level_error);
1749: END IF;

Line 1751: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',

1747: p_msg_type=>'SQL ERROR',
1748: p_msg_level=>fnd_log.level_error);
1749: END IF;
1750: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1751: hz_utility_v2pub.debug(p_message=>'hz_org_contact_bo_pub.get_org_contact_bo (-)',
1752: p_prefix=>l_debug_prefix,
1753: p_msg_level=>fnd_log.level_procedure);
1754: END IF;
1755: