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_PARTY_BO_PVT dependencies on HZ_UTILITY_V2PUB

Line 273: px_code_assign_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

269: px_code_assign_rec.start_date_active := p_code_assign_obj.start_date_active;
270: px_code_assign_rec.end_date_active := p_code_assign_obj.end_date_active;
271: px_code_assign_rec.status := p_code_assign_obj.status;
272: px_code_assign_rec.actual_content_source := p_code_assign_obj.actual_content_source;
273: px_code_assign_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
274: px_code_assign_rec.rank := p_code_assign_obj.rank;
275: END assign_code_assign_rec;
276:
277: -- PRIVATE PROCEDURE assign_relationship_rec

Line 346: px_relationship_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

342: px_relationship_rec.attribute17 := p_relationship_obj.attribute17;
343: px_relationship_rec.attribute18 := p_relationship_obj.attribute18;
344: px_relationship_rec.attribute19 := p_relationship_obj.attribute19;
345: px_relationship_rec.attribute20 := p_relationship_obj.attribute20;
346: px_relationship_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
347: /*
348: px_relationship_rec.party_rec.party_id := p_relationship_obj.party_obj.party_id;
349: px_relationship_rec.party_rec.party_number := p_relationship_obj.party_obj.party_number;
350: px_relationship_rec.party_rec.validated_flag := p_relationship_obj.party_obj.validated_flag;

Line 469: hz_utility_v2pub.debug(p_message=>'create_relationships(+)',

465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466:
467: -- Debug info.
468: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
469: hz_utility_v2pub.debug(p_message=>'create_relationships(+)',
470: p_prefix=>l_debug_prefix,
471: p_msg_level=>fnd_log.level_procedure);
472: END IF;
473:

Line 521: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_relationships, subject id: '||p_subject_id||' object id: '||p_rel_objs(i).related_object_id,

517: );
518:
519: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
520: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
521: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_relationships, subject id: '||p_subject_id||' object id: '||p_rel_objs(i).related_object_id,
522: p_prefix=>l_debug_prefix,
523: p_msg_level=>fnd_log.level_procedure);
524: END IF;
525: RAISE FND_API.G_EXC_ERROR;

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

531: END LOOP;
532:
533: -- Debug info.
534: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
535: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
536: p_msg_data=>x_msg_data,
537: p_msg_type=>'WARNING',
538: p_msg_level=>fnd_log.level_exception);
539: END IF;

Line 541: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',

537: p_msg_type=>'WARNING',
538: p_msg_level=>fnd_log.level_exception);
539: END IF;
540: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
542: p_prefix=>l_debug_prefix,
543: p_msg_level=>fnd_log.level_procedure);
544: END IF;
545: EXCEPTION

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

556: p_data => x_msg_data);
557:
558: -- Debug info.
559: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
560: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
561: p_msg_data=>x_msg_data,
562: p_msg_type=>'ERROR',
563: p_msg_level=>fnd_log.level_error);
564: END IF;

Line 566: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',

562: p_msg_type=>'ERROR',
563: p_msg_level=>fnd_log.level_error);
564: END IF;
565: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
566: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
567: p_prefix=>l_debug_prefix,
568: p_msg_level=>fnd_log.level_procedure);
569: END IF;
570: WHEN fnd_api.g_exc_unexpected_error THEN

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

580: p_data => x_msg_data);
581:
582: -- Debug info.
583: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
584: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
585: p_msg_data=>x_msg_data,
586: p_msg_type=>'UNEXPECTED ERROR',
587: p_msg_level=>fnd_log.level_error);
588: END IF;

Line 590: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',

586: p_msg_type=>'UNEXPECTED ERROR',
587: p_msg_level=>fnd_log.level_error);
588: END IF;
589: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
590: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
591: p_prefix=>l_debug_prefix,
592: p_msg_level=>fnd_log.level_procedure);
593: END IF;
594:

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

609: p_data => x_msg_data);
610:
611: -- Debug info.
612: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
613: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
614: p_msg_data=>x_msg_data,
615: p_msg_type=>'SQL ERROR',
616: p_msg_level=>fnd_log.level_error);
617: END IF;

Line 619: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',

615: p_msg_type=>'SQL ERROR',
616: p_msg_level=>fnd_log.level_error);
617: END IF;
618: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
619: hz_utility_v2pub.debug(p_message=>'create_relationships(-)',
620: p_prefix=>l_debug_prefix,
621: p_msg_level=>fnd_log.level_procedure);
622: END IF;
623: END create_relationships;

Line 693: hz_utility_v2pub.debug(p_message=>'save_relationships(+)',

689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690:
691: -- Debug info.
692: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
693: hz_utility_v2pub.debug(p_message=>'save_relationships(+)',
694: p_prefix=>l_debug_prefix,
695: p_msg_level=>fnd_log.level_procedure);
696: END IF;
697:

Line 775: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_relationships, subject id: '||p_subject_id||' object id: '||p_rel_objs(i).related_object_id,

771: END IF;
772:
773: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
774: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
775: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_relationships, subject id: '||p_subject_id||' object id: '||p_rel_objs(i).related_object_id,
776: p_prefix=>l_debug_prefix,
777: p_msg_level=>fnd_log.level_procedure);
778: END IF;
779: RAISE FND_API.G_EXC_ERROR;

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

782: END LOOP;
783:
784: -- Debug info.
785: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
786: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
787: p_msg_data=>x_msg_data,
788: p_msg_type=>'WARNING',
789: p_msg_level=>fnd_log.level_exception);
790: END IF;

Line 792: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',

788: p_msg_type=>'WARNING',
789: p_msg_level=>fnd_log.level_exception);
790: END IF;
791: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
792: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
793: p_prefix=>l_debug_prefix,
794: p_msg_level=>fnd_log.level_procedure);
795: END IF;
796: EXCEPTION

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

807: p_data => x_msg_data);
808:
809: -- Debug info.
810: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
811: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
812: p_msg_data=>x_msg_data,
813: p_msg_type=>'ERROR',
814: p_msg_level=>fnd_log.level_error);
815: END IF;

Line 817: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',

813: p_msg_type=>'ERROR',
814: p_msg_level=>fnd_log.level_error);
815: END IF;
816: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
817: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
818: p_prefix=>l_debug_prefix,
819: p_msg_level=>fnd_log.level_procedure);
820: END IF;
821: WHEN fnd_api.g_exc_unexpected_error THEN

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

831: p_data => x_msg_data);
832:
833: -- Debug info.
834: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
835: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
836: p_msg_data=>x_msg_data,
837: p_msg_type=>'UNEXPECTED ERROR',
838: p_msg_level=>fnd_log.level_error);
839: END IF;

Line 841: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',

837: p_msg_type=>'UNEXPECTED ERROR',
838: p_msg_level=>fnd_log.level_error);
839: END IF;
840: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
841: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
842: p_prefix=>l_debug_prefix,
843: p_msg_level=>fnd_log.level_procedure);
844: END IF;
845:

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

860: p_data => x_msg_data);
861:
862: -- Debug info.
863: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
865: p_msg_data=>x_msg_data,
866: p_msg_type=>'SQL ERROR',
867: p_msg_level=>fnd_log.level_error);
868: END IF;

Line 870: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',

866: p_msg_type=>'SQL ERROR',
867: p_msg_level=>fnd_log.level_error);
868: END IF;
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'save_relationships(-)',
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874: END save_relationships;

Line 907: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(+)',

903: END IF;
904:
905: -- Debug info.
906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
907: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(+)',
908: p_prefix=>l_debug_prefix,
909: p_msg_level=>fnd_log.level_procedure);
910: END IF;
911:

Line 952: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,

948: );
949:
950: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
951: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
952: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,
953: p_prefix=>l_debug_prefix,
954: p_msg_level=>fnd_log.level_procedure);
955: END IF;
956: RAISE FND_API.G_EXC_ERROR;

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

960: p_rel_obj.relationship_id := x_relationship_id;
961:
962: -- Debug info.
963: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
964: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
965: p_msg_data=>x_msg_data,
966: p_msg_type=>'WARNING',
967: p_msg_level=>fnd_log.level_exception);
968: END IF;

Line 970: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',

966: p_msg_type=>'WARNING',
967: p_msg_level=>fnd_log.level_exception);
968: END IF;
969: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
970: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
971: p_prefix=>l_debug_prefix,
972: p_msg_level=>fnd_log.level_procedure);
973: END IF;
974: EXCEPTION

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

985: p_data => x_msg_data);
986:
987: -- Debug info.
988: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
989: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
990: p_msg_data=>x_msg_data,
991: p_msg_type=>'ERROR',
992: p_msg_level=>fnd_log.level_error);
993: END IF;

Line 995: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',

991: p_msg_type=>'ERROR',
992: p_msg_level=>fnd_log.level_error);
993: END IF;
994: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
995: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
996: p_prefix=>l_debug_prefix,
997: p_msg_level=>fnd_log.level_procedure);
998: END IF;
999: WHEN fnd_api.g_exc_unexpected_error THEN

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

1009: p_data => x_msg_data);
1010:
1011: -- Debug info.
1012: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1013: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1014: p_msg_data=>x_msg_data,
1015: p_msg_type=>'UNEXPECTED ERROR',
1016: p_msg_level=>fnd_log.level_error);
1017: END IF;

Line 1019: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',

1015: p_msg_type=>'UNEXPECTED ERROR',
1016: p_msg_level=>fnd_log.level_error);
1017: END IF;
1018: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1019: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
1020: p_prefix=>l_debug_prefix,
1021: p_msg_level=>fnd_log.level_procedure);
1022: END IF;
1023:

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

1038: p_data => x_msg_data);
1039:
1040: -- Debug info.
1041: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1042: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1043: p_msg_data=>x_msg_data,
1044: p_msg_type=>'SQL ERROR',
1045: p_msg_level=>fnd_log.level_error);
1046: END IF;

Line 1048: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',

1044: p_msg_type=>'SQL ERROR',
1045: p_msg_level=>fnd_log.level_error);
1046: END IF;
1047: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1048: hz_utility_v2pub.debug(p_message=>'create_relatobj_pvt(-)',
1049: p_prefix=>l_debug_prefix,
1050: p_msg_level=>fnd_log.level_procedure);
1051: END IF;
1052: END create_relationship_obj;

Line 1095: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(+)',

1091: END IF;
1092:
1093: -- Debug info.
1094: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1095: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(+)',
1096: p_prefix=>l_debug_prefix,
1097: p_msg_level=>fnd_log.level_procedure);
1098: END IF;
1099:

Line 1139: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.update_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,

1135: p_rel_obj.relationship_id := x_relationship_id;
1136:
1137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.update_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,
1140: p_prefix=>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_procedure);
1142: END IF;
1143: RAISE FND_API.G_EXC_ERROR;

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

1144: END IF;
1145:
1146: -- Debug info.
1147: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1148: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1149: p_msg_data=>x_msg_data,
1150: p_msg_type=>'WARNING',
1151: p_msg_level=>fnd_log.level_exception);
1152: END IF;

Line 1154: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',

1150: p_msg_type=>'WARNING',
1151: p_msg_level=>fnd_log.level_exception);
1152: END IF;
1153: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1154: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1155: p_prefix=>l_debug_prefix,
1156: p_msg_level=>fnd_log.level_procedure);
1157: END IF;
1158: EXCEPTION

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

1169: p_data => x_msg_data);
1170:
1171: -- Debug info.
1172: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1173: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1174: p_msg_data=>x_msg_data,
1175: p_msg_type=>'ERROR',
1176: p_msg_level=>fnd_log.level_error);
1177: END IF;

Line 1179: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',

1175: p_msg_type=>'ERROR',
1176: p_msg_level=>fnd_log.level_error);
1177: END IF;
1178: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1179: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1180: p_prefix=>l_debug_prefix,
1181: p_msg_level=>fnd_log.level_procedure);
1182: END IF;
1183: WHEN fnd_api.g_exc_unexpected_error THEN

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

1193: p_data => x_msg_data);
1194:
1195: -- Debug info.
1196: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1197: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1198: p_msg_data=>x_msg_data,
1199: p_msg_type=>'UNEXPECTED ERROR',
1200: p_msg_level=>fnd_log.level_error);
1201: END IF;

Line 1203: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',

1199: p_msg_type=>'UNEXPECTED ERROR',
1200: p_msg_level=>fnd_log.level_error);
1201: END IF;
1202: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1203: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1204: p_prefix=>l_debug_prefix,
1205: p_msg_level=>fnd_log.level_procedure);
1206: END IF;
1207:

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

1222: p_data => x_msg_data);
1223:
1224: -- Debug info.
1225: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1226: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1227: p_msg_data=>x_msg_data,
1228: p_msg_type=>'SQL ERROR',
1229: p_msg_level=>fnd_log.level_error);
1230: END IF;

Line 1232: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',

1228: p_msg_type=>'SQL ERROR',
1229: p_msg_level=>fnd_log.level_error);
1230: END IF;
1231: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1232: hz_utility_v2pub.debug(p_message=>'update_relatobj_pvt(-)',
1233: p_prefix=>l_debug_prefix,
1234: p_msg_level=>fnd_log.level_procedure);
1235: END IF;
1236: END update_relationship_obj;

Line 1281: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(+)',

1277:
1278:
1279: -- Debug info.
1280: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1281: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(+)',
1282: p_prefix=>l_debug_prefix,
1283: p_msg_level=>fnd_log.level_procedure);
1284: END IF;
1285:

Line 1349: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,

1345: END IF;
1346:
1347: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1348: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1349: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_relationship_obj, subject id: '||p_rel_obj.parent_object_id||' object id: '||p_rel_obj.related_object_id,
1350: p_prefix=>l_debug_prefix,
1351: p_msg_level=>fnd_log.level_procedure);
1352: END IF;
1353: RAISE FND_API.G_EXC_ERROR;

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

1354: END IF;
1355:
1356: -- Debug info.
1357: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1358: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1359: p_msg_data=>x_msg_data,
1360: p_msg_type=>'WARNING',
1361: p_msg_level=>fnd_log.level_exception);
1362: END IF;

Line 1364: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',

1360: p_msg_type=>'WARNING',
1361: p_msg_level=>fnd_log.level_exception);
1362: END IF;
1363: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1364: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1365: p_prefix=>l_debug_prefix,
1366: p_msg_level=>fnd_log.level_procedure);
1367: END IF;
1368: EXCEPTION

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

1379: p_data => x_msg_data);
1380:
1381: -- Debug info.
1382: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1383: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1384: p_msg_data=>x_msg_data,
1385: p_msg_type=>'ERROR',
1386: p_msg_level=>fnd_log.level_error);
1387: END IF;

Line 1389: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',

1385: p_msg_type=>'ERROR',
1386: p_msg_level=>fnd_log.level_error);
1387: END IF;
1388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1389: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1390: p_prefix=>l_debug_prefix,
1391: p_msg_level=>fnd_log.level_procedure);
1392: END IF;
1393: WHEN fnd_api.g_exc_unexpected_error THEN

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

1403: p_data => x_msg_data);
1404:
1405: -- Debug info.
1406: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1407: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1408: p_msg_data=>x_msg_data,
1409: p_msg_type=>'UNEXPECTED ERROR',
1410: p_msg_level=>fnd_log.level_error);
1411: END IF;

Line 1413: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',

1409: p_msg_type=>'UNEXPECTED ERROR',
1410: p_msg_level=>fnd_log.level_error);
1411: END IF;
1412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1413: hz_utility_v2pub.debug(p_message=>'save_relatobj_pvt(-)',
1414: p_prefix=>l_debug_prefix,
1415: p_msg_level=>fnd_log.level_procedure);
1416: END IF;
1417:

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=>'SQL ERROR',
1439: p_msg_level=>fnd_log.level_error);
1440: END IF;

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

1438: p_msg_type=>'SQL 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=>'save_relatobj_pvt(-)',
1443: p_prefix=>l_debug_prefix,
1444: p_msg_level=>fnd_log.level_procedure);
1445: END IF;
1446: END save_relationship_obj;

Line 1573: hz_utility_v2pub.debug(p_message=>'hz_party_bo_pvt.get_relationship_obj (+)',

1569: END IF;
1570:
1571: -- Debug info.
1572: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1573: hz_utility_v2pub.debug(p_message=>'hz_party_bo_pvt.get_relationship_obj (+)',
1574: p_prefix=>l_debug_prefix,
1575: p_msg_level=>fnd_log.level_procedure);
1576: END IF;
1577:

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

1580: CLOSE c1;
1581:
1582: -- Debug info.
1583: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1584: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1585: p_msg_data=>x_msg_data,
1586: p_msg_type=>'WARNING',
1587: p_msg_level=>fnd_log.level_exception);
1588: END IF;

Line 1592: hz_utility_v2pub.debug(p_message=>'hz_party_bo_pvt.get_relationship_obj (-)',

1588: END IF;
1589:
1590: -- Debug info.
1591: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1592: hz_utility_v2pub.debug(p_message=>'hz_party_bo_pvt.get_relationship_obj (-)',
1593: p_prefix=>l_debug_prefix,
1594: p_msg_level=>fnd_log.level_procedure);
1595: END IF;
1596: EXCEPTION

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

1601: p_data => x_msg_data);
1602:
1603: -- Debug info.
1604: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1605: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1606: p_msg_data=>x_msg_data,
1607: p_msg_type=>'ERROR',
1608: p_msg_level=>fnd_log.level_error);
1609: END IF;

Line 1611: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',

1607: p_msg_type=>'ERROR',
1608: p_msg_level=>fnd_log.level_error);
1609: END IF;
1610: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1611: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1612: p_prefix=>l_debug_prefix,
1613: p_msg_level=>fnd_log.level_procedure);
1614: END IF;
1615: WHEN fnd_api.g_exc_unexpected_error THEN

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

1619: p_data => x_msg_data);
1620:
1621: -- Debug info.
1622: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1624: p_msg_data=>x_msg_data,
1625: p_msg_type=>'UNEXPECTED ERROR',
1626: p_msg_level=>fnd_log.level_error);
1627: END IF;

Line 1629: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',

1625: p_msg_type=>'UNEXPECTED ERROR',
1626: p_msg_level=>fnd_log.level_error);
1627: END IF;
1628: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1629: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1630: p_prefix=>l_debug_prefix,
1631: p_msg_level=>fnd_log.level_procedure);
1632: END IF;
1633:

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

1643: p_data => x_msg_data);
1644:
1645: -- Debug info.
1646: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1647: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1648: p_msg_data=>x_msg_data,
1649: p_msg_type=>'SQL ERROR',
1650: p_msg_level=>fnd_log.level_error);
1651: END IF;

Line 1653: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',

1649: p_msg_type=>'SQL ERROR',
1650: p_msg_level=>fnd_log.level_error);
1651: END IF;
1652: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1653: hz_utility_v2pub.debug(p_message=>'get_relationship_obj (-)',
1654: p_prefix=>l_debug_prefix,
1655: p_msg_level=>fnd_log.level_procedure);
1656: END IF;
1657: END get_relationship_obj;

Line 1716: hz_utility_v2pub.debug(p_message=>'create_classifications(+)',

1712: x_return_status := FND_API.G_RET_STS_SUCCESS;
1713:
1714: -- Debug info.
1715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1716: hz_utility_v2pub.debug(p_message=>'create_classifications(+)',
1717: p_prefix=>l_debug_prefix,
1718: p_msg_level=>fnd_log.level_procedure);
1719: END IF;
1720:

Line 1740: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_classifications, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,

1736: );
1737:
1738: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1739: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1740: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_classifications, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,
1741: p_prefix=>l_debug_prefix,
1742: p_msg_level=>fnd_log.level_procedure);
1743: END IF;
1744: RAISE FND_API.G_EXC_ERROR;

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

1749: END LOOP;
1750:
1751: -- Debug info.
1752: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1754: p_msg_data=>x_msg_data,
1755: p_msg_type=>'WARNING',
1756: p_msg_level=>fnd_log.level_exception);
1757: END IF;

Line 1759: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',

1755: p_msg_type=>'WARNING',
1756: p_msg_level=>fnd_log.level_exception);
1757: END IF;
1758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1759: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1760: p_prefix=>l_debug_prefix,
1761: p_msg_level=>fnd_log.level_procedure);
1762: END IF;
1763: EXCEPTION

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

1774: p_data => x_msg_data);
1775:
1776: -- Debug info.
1777: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1778: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1779: p_msg_data=>x_msg_data,
1780: p_msg_type=>'ERROR',
1781: p_msg_level=>fnd_log.level_error);
1782: END IF;

Line 1784: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',

1780: p_msg_type=>'ERROR',
1781: p_msg_level=>fnd_log.level_error);
1782: END IF;
1783: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1784: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1785: p_prefix=>l_debug_prefix,
1786: p_msg_level=>fnd_log.level_procedure);
1787: END IF;
1788: WHEN fnd_api.g_exc_unexpected_error THEN

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

1798: p_data => x_msg_data);
1799:
1800: -- Debug info.
1801: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1802: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1803: p_msg_data=>x_msg_data,
1804: p_msg_type=>'UNEXPECTED ERROR',
1805: p_msg_level=>fnd_log.level_error);
1806: END IF;

Line 1808: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',

1804: p_msg_type=>'UNEXPECTED ERROR',
1805: p_msg_level=>fnd_log.level_error);
1806: END IF;
1807: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1808: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1809: p_prefix=>l_debug_prefix,
1810: p_msg_level=>fnd_log.level_procedure);
1811: END IF;
1812:

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

1827: p_data => x_msg_data);
1828:
1829: -- Debug info.
1830: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1831: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1832: p_msg_data=>x_msg_data,
1833: p_msg_type=>'SQL ERROR',
1834: p_msg_level=>fnd_log.level_error);
1835: END IF;

Line 1837: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',

1833: p_msg_type=>'SQL ERROR',
1834: p_msg_level=>fnd_log.level_error);
1835: END IF;
1836: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1837: hz_utility_v2pub.debug(p_message=>'create_classifications(-)',
1838: p_prefix=>l_debug_prefix,
1839: p_msg_level=>fnd_log.level_procedure);
1840: END IF;
1841: END create_classifications;

Line 1891: hz_utility_v2pub.debug(p_message=>'save_classifications(+)',

1887: x_return_status := FND_API.G_RET_STS_SUCCESS;
1888:
1889: -- Debug info.
1890: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1891: hz_utility_v2pub.debug(p_message=>'save_classifications(+)',
1892: p_prefix=>l_debug_prefix,
1893: p_msg_level=>fnd_log.level_procedure);
1894: END IF;
1895:

Line 1917: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_code_assign_op, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,

1913: );
1914:
1915: IF (l_ovn = -1) THEN
1916: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1917: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_code_assign_op, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,
1918: p_prefix=>l_debug_prefix,
1919: p_msg_level=>fnd_log.level_procedure);
1920: END IF;
1921: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 1957: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_classifications, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,

1953: END IF;
1954:
1955: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1957: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_classifications, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,
1958: p_prefix=>l_debug_prefix,
1959: p_msg_level=>fnd_log.level_procedure);
1960: END IF;
1961: RAISE FND_API.G_EXC_ERROR;

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

1963: END LOOP;
1964:
1965: -- Debug info.
1966: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1967: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1968: p_msg_data=>x_msg_data,
1969: p_msg_type=>'WARNING',
1970: p_msg_level=>fnd_log.level_exception);
1971: END IF;

Line 1973: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',

1969: p_msg_type=>'WARNING',
1970: p_msg_level=>fnd_log.level_exception);
1971: END IF;
1972: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1973: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
1974: p_prefix=>l_debug_prefix,
1975: p_msg_level=>fnd_log.level_procedure);
1976: END IF;
1977: EXCEPTION

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

1988: p_data => x_msg_data);
1989:
1990: -- Debug info.
1991: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1992: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1993: p_msg_data=>x_msg_data,
1994: p_msg_type=>'ERROR',
1995: p_msg_level=>fnd_log.level_error);
1996: END IF;

Line 1998: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',

1994: p_msg_type=>'ERROR',
1995: p_msg_level=>fnd_log.level_error);
1996: END IF;
1997: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1998: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
1999: p_prefix=>l_debug_prefix,
2000: p_msg_level=>fnd_log.level_procedure);
2001: END IF;
2002: WHEN fnd_api.g_exc_unexpected_error THEN

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

2012: p_data => x_msg_data);
2013:
2014: -- Debug info.
2015: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2016: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2017: p_msg_data=>x_msg_data,
2018: p_msg_type=>'UNEXPECTED ERROR',
2019: p_msg_level=>fnd_log.level_error);
2020: END IF;

Line 2022: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',

2018: p_msg_type=>'UNEXPECTED ERROR',
2019: p_msg_level=>fnd_log.level_error);
2020: END IF;
2021: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2022: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
2023: p_prefix=>l_debug_prefix,
2024: p_msg_level=>fnd_log.level_procedure);
2025: END IF;
2026: WHEN OTHERS THEN

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

2040: p_data => x_msg_data);
2041:
2042: -- Debug info.
2043: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2044: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2045: p_msg_data=>x_msg_data,
2046: p_msg_type=>'SQL ERROR',
2047: p_msg_level=>fnd_log.level_error);
2048: END IF;

Line 2050: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',

2046: p_msg_type=>'SQL ERROR',
2047: p_msg_level=>fnd_log.level_error);
2048: END IF;
2049: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2050: hz_utility_v2pub.debug(p_message=>'save_classifications(-)',
2051: p_prefix=>l_debug_prefix,
2052: p_msg_level=>fnd_log.level_procedure);
2053: END IF;
2054: END save_classifications;

Line 2101: hz_utility_v2pub.debug(p_message=>'create_certifications(+)',

2097: x_return_status := FND_API.G_RET_STS_SUCCESS;
2098:
2099: -- Debug info.
2100: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2101: hz_utility_v2pub.debug(p_message=>'create_certifications(+)',
2102: p_prefix=>l_debug_prefix,
2103: p_msg_level=>fnd_log.level_procedure);
2104: END IF;
2105:

Line 2125: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_certifications, party id: '||p_party_id,

2121: );
2122:
2123: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2124: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2125: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_certifications, party id: '||p_party_id,
2126: p_prefix=>l_debug_prefix,
2127: p_msg_level=>fnd_log.level_procedure);
2128: END IF;
2129: RAISE FND_API.G_EXC_ERROR;

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

2134: END LOOP;
2135:
2136: -- Debug info.
2137: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2138: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2139: p_msg_data=>x_msg_data,
2140: p_msg_type=>'WARNING',
2141: p_msg_level=>fnd_log.level_exception);
2142: END IF;

Line 2144: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',

2140: p_msg_type=>'WARNING',
2141: p_msg_level=>fnd_log.level_exception);
2142: END IF;
2143: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2144: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2145: p_prefix=>l_debug_prefix,
2146: p_msg_level=>fnd_log.level_procedure);
2147: END IF;
2148: EXCEPTION

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

2159: p_data => x_msg_data);
2160:
2161: -- Debug info.
2162: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2163: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2164: p_msg_data=>x_msg_data,
2165: p_msg_type=>'ERROR',
2166: p_msg_level=>fnd_log.level_error);
2167: END IF;

Line 2169: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',

2165: p_msg_type=>'ERROR',
2166: p_msg_level=>fnd_log.level_error);
2167: END IF;
2168: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2169: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2170: p_prefix=>l_debug_prefix,
2171: p_msg_level=>fnd_log.level_procedure);
2172: END IF;
2173: WHEN fnd_api.g_exc_unexpected_error THEN

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

2183: p_data => x_msg_data);
2184:
2185: -- Debug info.
2186: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2187: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2188: p_msg_data=>x_msg_data,
2189: p_msg_type=>'UNEXPECTED ERROR',
2190: p_msg_level=>fnd_log.level_error);
2191: END IF;

Line 2193: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',

2189: p_msg_type=>'UNEXPECTED ERROR',
2190: p_msg_level=>fnd_log.level_error);
2191: END IF;
2192: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2193: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2194: p_prefix=>l_debug_prefix,
2195: p_msg_level=>fnd_log.level_procedure);
2196: END IF;
2197:

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

2212: p_data => x_msg_data);
2213:
2214: -- Debug info.
2215: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2216: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2217: p_msg_data=>x_msg_data,
2218: p_msg_type=>'SQL ERROR',
2219: p_msg_level=>fnd_log.level_error);
2220: END IF;

Line 2222: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',

2218: p_msg_type=>'SQL ERROR',
2219: p_msg_level=>fnd_log.level_error);
2220: END IF;
2221: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2222: hz_utility_v2pub.debug(p_message=>'create_certifications(-)',
2223: p_prefix=>l_debug_prefix,
2224: p_msg_level=>fnd_log.level_procedure);
2225: END IF;
2226: END create_certifications;

Line 2274: hz_utility_v2pub.debug(p_message=>'save_certifications(+)',

2270: x_return_status := FND_API.G_RET_STS_SUCCESS;
2271:
2272: -- Debug info.
2273: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2274: hz_utility_v2pub.debug(p_message=>'save_certifications(+)',
2275: p_prefix=>l_debug_prefix,
2276: p_msg_level=>fnd_log.level_procedure);
2277: END IF;
2278:

Line 2298: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_certification_op, party id: '||p_party_id,

2294: );
2295:
2296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2298: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_certification_op, party id: '||p_party_id,
2299: p_prefix=>l_debug_prefix,
2300: p_msg_level=>fnd_log.level_procedure);
2301: END IF;
2302: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 2338: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_certifications, party id: '||p_party_id,

2334: END IF;
2335:
2336: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2337: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2338: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_certifications, party id: '||p_party_id,
2339: p_prefix=>l_debug_prefix,
2340: p_msg_level=>fnd_log.level_procedure);
2341: END IF;
2342: RAISE FND_API.G_EXC_ERROR;

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

2344: END LOOP;
2345:
2346: -- Debug info.
2347: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2348: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2349: p_msg_data=>x_msg_data,
2350: p_msg_type=>'WARNING',
2351: p_msg_level=>fnd_log.level_exception);
2352: END IF;

Line 2354: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',

2350: p_msg_type=>'WARNING',
2351: p_msg_level=>fnd_log.level_exception);
2352: END IF;
2353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2354: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2355: p_prefix=>l_debug_prefix,
2356: p_msg_level=>fnd_log.level_procedure);
2357: END IF;
2358: EXCEPTION

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

2369: p_data => x_msg_data);
2370:
2371: -- Debug info.
2372: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2373: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2374: p_msg_data=>x_msg_data,
2375: p_msg_type=>'ERROR',
2376: p_msg_level=>fnd_log.level_error);
2377: END IF;

Line 2379: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',

2375: p_msg_type=>'ERROR',
2376: p_msg_level=>fnd_log.level_error);
2377: END IF;
2378: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2379: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2380: p_prefix=>l_debug_prefix,
2381: p_msg_level=>fnd_log.level_procedure);
2382: END IF;
2383: WHEN fnd_api.g_exc_unexpected_error THEN

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

2393: p_data => x_msg_data);
2394:
2395: -- Debug info.
2396: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2397: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2398: p_msg_data=>x_msg_data,
2399: p_msg_type=>'UNEXPECTED ERROR',
2400: p_msg_level=>fnd_log.level_error);
2401: END IF;

Line 2403: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',

2399: p_msg_type=>'UNEXPECTED ERROR',
2400: p_msg_level=>fnd_log.level_error);
2401: END IF;
2402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2403: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2404: p_prefix=>l_debug_prefix,
2405: p_msg_level=>fnd_log.level_procedure);
2406: END IF;
2407: WHEN OTHERS THEN

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

2421: p_data => x_msg_data);
2422:
2423: -- Debug info.
2424: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2425: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2426: p_msg_data=>x_msg_data,
2427: p_msg_type=>'SQL ERROR',
2428: p_msg_level=>fnd_log.level_error);
2429: END IF;

Line 2431: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',

2427: p_msg_type=>'SQL ERROR',
2428: p_msg_level=>fnd_log.level_error);
2429: END IF;
2430: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2431: hz_utility_v2pub.debug(p_message=>'save_certifications(-)',
2432: p_prefix=>l_debug_prefix,
2433: p_msg_level=>fnd_log.level_procedure);
2434: END IF;
2435: END save_certifications;

Line 2482: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(+)',

2478: x_return_status := FND_API.G_RET_STS_SUCCESS;
2479:
2480: -- Debug info.
2481: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2482: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(+)',
2483: p_prefix=>l_debug_prefix,
2484: p_msg_level=>fnd_log.level_procedure);
2485: END IF;
2486:

Line 2506: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_financial_profiles, party id: '||p_party_id,

2502: );
2503:
2504: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2505: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2506: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_financial_profiles, party id: '||p_party_id,
2507: p_prefix=>l_debug_prefix,
2508: p_msg_level=>fnd_log.level_procedure);
2509: END IF;
2510: RAISE FND_API.G_EXC_ERROR;

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

2515: END LOOP;
2516:
2517: -- Debug info.
2518: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2519: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2520: p_msg_data=>x_msg_data,
2521: p_msg_type=>'WARNING',
2522: p_msg_level=>fnd_log.level_exception);
2523: END IF;

Line 2525: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',

2521: p_msg_type=>'WARNING',
2522: p_msg_level=>fnd_log.level_exception);
2523: END IF;
2524: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2525: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2526: p_prefix=>l_debug_prefix,
2527: p_msg_level=>fnd_log.level_procedure);
2528: END IF;
2529: EXCEPTION

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

2540: p_data => x_msg_data);
2541:
2542: -- Debug info.
2543: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2544: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2545: p_msg_data=>x_msg_data,
2546: p_msg_type=>'ERROR',
2547: p_msg_level=>fnd_log.level_error);
2548: END IF;

Line 2550: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',

2546: p_msg_type=>'ERROR',
2547: p_msg_level=>fnd_log.level_error);
2548: END IF;
2549: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2550: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2551: p_prefix=>l_debug_prefix,
2552: p_msg_level=>fnd_log.level_procedure);
2553: END IF;
2554: WHEN fnd_api.g_exc_unexpected_error THEN

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

2564: p_data => x_msg_data);
2565:
2566: -- Debug info.
2567: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2568: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2569: p_msg_data=>x_msg_data,
2570: p_msg_type=>'UNEXPECTED ERROR',
2571: p_msg_level=>fnd_log.level_error);
2572: END IF;

Line 2574: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',

2570: p_msg_type=>'UNEXPECTED ERROR',
2571: p_msg_level=>fnd_log.level_error);
2572: END IF;
2573: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2574: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2575: p_prefix=>l_debug_prefix,
2576: p_msg_level=>fnd_log.level_procedure);
2577: END IF;
2578:

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

2593: p_data => x_msg_data);
2594:
2595: -- Debug info.
2596: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2597: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2598: p_msg_data=>x_msg_data,
2599: p_msg_type=>'SQL ERROR',
2600: p_msg_level=>fnd_log.level_error);
2601: END IF;

Line 2603: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',

2599: p_msg_type=>'SQL ERROR',
2600: p_msg_level=>fnd_log.level_error);
2601: END IF;
2602: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2603: hz_utility_v2pub.debug(p_message=>'create_financial_profiles(-)',
2604: p_prefix=>l_debug_prefix,
2605: p_msg_level=>fnd_log.level_procedure);
2606: END IF;
2607: END create_financial_profiles;

Line 2655: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(+)',

2651: x_return_status := FND_API.G_RET_STS_SUCCESS;
2652:
2653: -- Debug info.
2654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2655: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(+)',
2656: p_prefix=>l_debug_prefix,
2657: p_msg_level=>fnd_log.level_procedure);
2658: END IF;
2659:

Line 2678: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_financial_prof_op, financial profile id: '||l_fin_prof_rec.financial_profile_id||', party id: '||p_party_id,

2674: );
2675:
2676: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2677: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2678: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_financial_prof_op, financial profile id: '||l_fin_prof_rec.financial_profile_id||', party id: '||p_party_id,
2679: p_prefix=>l_debug_prefix,
2680: p_msg_level=>fnd_log.level_procedure);
2681: END IF;
2682: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 2718: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_financial_profiles, party id: '||p_party_id,

2714: END IF;
2715:
2716: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2717: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2718: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_financial_profiles, party id: '||p_party_id,
2719: p_prefix=>l_debug_prefix,
2720: p_msg_level=>fnd_log.level_procedure);
2721: END IF;
2722: RAISE FND_API.G_EXC_ERROR;

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

2724: END LOOP;
2725:
2726: -- Debug info.
2727: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2728: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2729: p_msg_data=>x_msg_data,
2730: p_msg_type=>'WARNING',
2731: p_msg_level=>fnd_log.level_exception);
2732: END IF;

Line 2734: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',

2730: p_msg_type=>'WARNING',
2731: p_msg_level=>fnd_log.level_exception);
2732: END IF;
2733: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2734: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2735: p_prefix=>l_debug_prefix,
2736: p_msg_level=>fnd_log.level_procedure);
2737: END IF;
2738: EXCEPTION

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

2749: p_data => x_msg_data);
2750:
2751: -- Debug info.
2752: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2753: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2754: p_msg_data=>x_msg_data,
2755: p_msg_type=>'ERROR',
2756: p_msg_level=>fnd_log.level_error);
2757: END IF;

Line 2759: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',

2755: p_msg_type=>'ERROR',
2756: p_msg_level=>fnd_log.level_error);
2757: END IF;
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2760: p_prefix=>l_debug_prefix,
2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;
2763: WHEN fnd_api.g_exc_unexpected_error THEN

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

2773: p_data => x_msg_data);
2774:
2775: -- Debug info.
2776: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2777: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2778: p_msg_data=>x_msg_data,
2779: p_msg_type=>'UNEXPECTED ERROR',
2780: p_msg_level=>fnd_log.level_error);
2781: END IF;

Line 2783: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',

2779: p_msg_type=>'UNEXPECTED ERROR',
2780: p_msg_level=>fnd_log.level_error);
2781: END IF;
2782: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2783: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2784: p_prefix=>l_debug_prefix,
2785: p_msg_level=>fnd_log.level_procedure);
2786: END IF;
2787: WHEN OTHERS THEN

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

2801: p_data => x_msg_data);
2802:
2803: -- Debug info.
2804: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2805: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2806: p_msg_data=>x_msg_data,
2807: p_msg_type=>'SQL ERROR',
2808: p_msg_level=>fnd_log.level_error);
2809: END IF;

Line 2811: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',

2807: p_msg_type=>'SQL ERROR',
2808: p_msg_level=>fnd_log.level_error);
2809: END IF;
2810: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2811: hz_utility_v2pub.debug(p_message=>'save_financial_profiles(-)',
2812: p_prefix=>l_debug_prefix,
2813: p_msg_level=>fnd_log.level_procedure);
2814: END IF;
2815: END save_financial_profiles;

Line 2861: hz_utility_v2pub.debug(p_message=>'save_party_preferences(+)',

2857: x_return_status := FND_API.G_RET_STS_SUCCESS;
2858:
2859: -- Debug info.
2860: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2861: hz_utility_v2pub.debug(p_message=>'save_party_preferences(+)',
2862: p_prefix=>l_debug_prefix,
2863: p_msg_level=>fnd_log.level_procedure);
2864: END IF;
2865:

Line 2899: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_party_preferences, party id: '||p_party_id,

2895: );
2896:
2897: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2898: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2899: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_party_preferences, party id: '||p_party_id,
2900: p_prefix=>l_debug_prefix,
2901: p_msg_level=>fnd_log.level_procedure);
2902: END IF;
2903: RAISE FND_API.G_EXC_ERROR;

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

2905: END LOOP;
2906:
2907: -- Debug info.
2908: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2909: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2910: p_msg_data=>x_msg_data,
2911: p_msg_type=>'WARNING',
2912: p_msg_level=>fnd_log.level_exception);
2913: END IF;

Line 2915: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',

2911: p_msg_type=>'WARNING',
2912: p_msg_level=>fnd_log.level_exception);
2913: END IF;
2914: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2915: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2916: p_prefix=>l_debug_prefix,
2917: p_msg_level=>fnd_log.level_procedure);
2918: END IF;
2919: EXCEPTION

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

2930: p_data => x_msg_data);
2931:
2932: -- Debug info.
2933: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2934: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2935: p_msg_data=>x_msg_data,
2936: p_msg_type=>'ERROR',
2937: p_msg_level=>fnd_log.level_error);
2938: END IF;

Line 2940: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',

2936: p_msg_type=>'ERROR',
2937: p_msg_level=>fnd_log.level_error);
2938: END IF;
2939: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2940: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2941: p_prefix=>l_debug_prefix,
2942: p_msg_level=>fnd_log.level_procedure);
2943: END IF;
2944: WHEN fnd_api.g_exc_unexpected_error THEN

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

2954: p_data => x_msg_data);
2955:
2956: -- Debug info.
2957: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2958: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2959: p_msg_data=>x_msg_data,
2960: p_msg_type=>'UNEXPECTED ERROR',
2961: p_msg_level=>fnd_log.level_error);
2962: END IF;

Line 2964: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',

2960: p_msg_type=>'UNEXPECTED ERROR',
2961: p_msg_level=>fnd_log.level_error);
2962: END IF;
2963: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2964: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2965: p_prefix=>l_debug_prefix,
2966: p_msg_level=>fnd_log.level_procedure);
2967: END IF;
2968: WHEN OTHERS THEN

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

2982: p_data => x_msg_data);
2983:
2984: -- Debug info.
2985: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2986: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2987: p_msg_data=>x_msg_data,
2988: p_msg_type=>'SQL ERROR',
2989: p_msg_level=>fnd_log.level_error);
2990: END IF;

Line 2992: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',

2988: p_msg_type=>'SQL ERROR',
2989: p_msg_level=>fnd_log.level_error);
2990: END IF;
2991: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2992: hz_utility_v2pub.debug(p_message=>'save_party_preferences(-)',
2993: p_prefix=>l_debug_prefix,
2994: p_msg_level=>fnd_log.level_procedure);
2995: END IF;
2996: END save_party_preferences;

Line 3053: px_party_usage_assignment_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

3049: px_party_usage_assignment_rec.attribute18 := p_party_usage_obj.attribute18;
3050: px_party_usage_assignment_rec.attribute19 := p_party_usage_obj.attribute19;
3051: px_party_usage_assignment_rec.attribute20 := p_party_usage_obj.attribute20;
3052: ------------------ set up created_by_module --------------------------
3053: px_party_usage_assignment_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
3054:
3055: end assign_party_usge_assgmnt_rec;
3056:
3057:

Line 3102: hz_utility_v2pub.debug(p_message=>'assign_party_usage(+)',

3098: x_return_status := FND_API.G_RET_STS_SUCCESS;
3099:
3100: -- Debug info.
3101: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3102: hz_utility_v2pub.debug(p_message=>'assign_party_usage(+)',
3103: p_prefix=>l_debug_prefix,
3104: p_msg_level=>fnd_log.level_procedure);
3105: END IF;
3106:

Line 3123: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_party_usage_assignment, party id: '||p_party_id,

3119: );
3120:
3121: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3122: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3123: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.create_party_usage_assignment, party id: '||p_party_id,
3124: p_prefix=>l_debug_prefix,
3125: p_msg_level=>fnd_log.level_procedure);
3126: END IF;
3127: RAISE FND_API.G_EXC_ERROR;

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

3129: END LOOP;
3130:
3131: -- Debug info.
3132: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3133: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3134: p_msg_data=>x_msg_data,
3135: p_msg_type=>'WARNING',
3136: p_msg_level=>fnd_log.level_exception);
3137: END IF;

Line 3139: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',

3135: p_msg_type=>'WARNING',
3136: p_msg_level=>fnd_log.level_exception);
3137: END IF;
3138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3139: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3140: p_prefix=>l_debug_prefix,
3141: p_msg_level=>fnd_log.level_procedure);
3142: END IF;
3143:

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

3155: p_data => x_msg_data);
3156:
3157: -- Debug info.
3158: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3159: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3160: p_msg_data=>x_msg_data,
3161: p_msg_type=>'ERROR',
3162: p_msg_level=>fnd_log.level_error);
3163: END IF;

Line 3165: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',

3161: p_msg_type=>'ERROR',
3162: p_msg_level=>fnd_log.level_error);
3163: END IF;
3164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3166: p_prefix=>l_debug_prefix,
3167: p_msg_level=>fnd_log.level_procedure);
3168: END IF;
3169: WHEN fnd_api.g_exc_unexpected_error THEN

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

3179: p_data => x_msg_data);
3180:
3181: -- Debug info.
3182: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3183: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3184: p_msg_data=>x_msg_data,
3185: p_msg_type=>'UNEXPECTED ERROR',
3186: p_msg_level=>fnd_log.level_error);
3187: END IF;

Line 3189: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',

3185: p_msg_type=>'UNEXPECTED ERROR',
3186: p_msg_level=>fnd_log.level_error);
3187: END IF;
3188: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3189: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3190: p_prefix=>l_debug_prefix,
3191: p_msg_level=>fnd_log.level_procedure);
3192: END IF;
3193:

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

3208: p_data => x_msg_data);
3209:
3210: -- Debug info.
3211: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3212: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3213: p_msg_data=>x_msg_data,
3214: p_msg_type=>'SQL ERROR',
3215: p_msg_level=>fnd_log.level_error);
3216: END IF;

Line 3218: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',

3214: p_msg_type=>'SQL ERROR',
3215: p_msg_level=>fnd_log.level_error);
3216: END IF;
3217: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3218: hz_utility_v2pub.debug(p_message=>'create_party_usage_assgmnt(-)',
3219: p_prefix=>l_debug_prefix,
3220: p_msg_level=>fnd_log.level_procedure);
3221: END IF;
3222:

Line 3272: hz_utility_v2pub.debug(p_message=>'assign_party_usage(+)',

3268: x_return_status := FND_API.G_RET_STS_SUCCESS;
3269:
3270: -- Debug info.
3271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3272: hz_utility_v2pub.debug(p_message=>'assign_party_usage(+)',
3273: p_prefix=>l_debug_prefix,
3274: p_msg_level=>fnd_log.level_procedure);
3275: END IF;
3276:

Line 3294: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_party_usage_op, party_usage_code ' || l_party_usg_rec.party_usage_code||', party id: '||p_party_id,

3290: x_return_status => x_return_status
3291: );
3292: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3294: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_party_usage_op, party_usage_code ' || l_party_usg_rec.party_usage_code||', party id: '||p_party_id,
3295: p_prefix=>l_debug_prefix,
3296: p_msg_level=>fnd_log.level_procedure);
3297: END IF;
3298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');

Line 3326: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_party_usage_assgmnt,party_usage_code ' || l_party_usg_rec.party_usage_code||', party id: '||p_party_id,

3322: ENd IF;
3323:
3324: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3325: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3326: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.save_party_usage_assgmnt,party_usage_code ' || l_party_usg_rec.party_usage_code||', party id: '||p_party_id,
3327: p_prefix=>l_debug_prefix,
3328: p_msg_level=>fnd_log.level_procedure);
3329: END IF;
3330: RAISE FND_API.G_EXC_ERROR;

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

3332: END LOOP;
3333:
3334: -- Debug info.
3335: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3336: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3337: p_msg_data=>x_msg_data,
3338: p_msg_type=>'WARNING',
3339: p_msg_level=>fnd_log.level_exception);
3340: END IF;

Line 3342: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',

3338: p_msg_type=>'WARNING',
3339: p_msg_level=>fnd_log.level_exception);
3340: END IF;
3341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3342: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3343: p_prefix=>l_debug_prefix,
3344: p_msg_level=>fnd_log.level_procedure);
3345: END IF;
3346: EXCEPTION

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

3357: p_data => x_msg_data);
3358:
3359: -- Debug info.
3360: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3361: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3362: p_msg_data=>x_msg_data,
3363: p_msg_type=>'ERROR',
3364: p_msg_level=>fnd_log.level_error);
3365: END IF;

Line 3367: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',

3363: p_msg_type=>'ERROR',
3364: p_msg_level=>fnd_log.level_error);
3365: END IF;
3366: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3367: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3368: p_prefix=>l_debug_prefix,
3369: p_msg_level=>fnd_log.level_procedure);
3370: END IF;
3371: WHEN fnd_api.g_exc_unexpected_error THEN

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

3381: p_data => x_msg_data);
3382:
3383: -- Debug info.
3384: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3385: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3386: p_msg_data=>x_msg_data,
3387: p_msg_type=>'UNEXPECTED ERROR',
3388: p_msg_level=>fnd_log.level_error);
3389: END IF;

Line 3391: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',

3387: p_msg_type=>'UNEXPECTED ERROR',
3388: p_msg_level=>fnd_log.level_error);
3389: END IF;
3390: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3391: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3392: p_prefix=>l_debug_prefix,
3393: p_msg_level=>fnd_log.level_procedure);
3394: END IF;
3395: WHEN OTHERS THEN

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

3409: p_data => x_msg_data);
3410:
3411: -- Debug info.
3412: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3413: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3414: p_msg_data=>x_msg_data,
3415: p_msg_type=>'SQL ERROR',
3416: p_msg_level=>fnd_log.level_error);
3417: END IF;

Line 3419: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',

3415: p_msg_type=>'SQL ERROR',
3416: p_msg_level=>fnd_log.level_error);
3417: END IF;
3418: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3419: hz_utility_v2pub.debug(p_message=>'save_party_usage_assgmnt(-)',
3420: p_prefix=>l_debug_prefix,
3421: p_msg_level=>fnd_log.level_procedure);
3422: END IF;
3423: END save_party_usage_assgmnt;

Line 3733: hz_utility_v2pub.DEBUG (p_message=>message,

3729: newline IN BOOLEAN DEFAULT TRUE) IS
3730: l_prefix VARCHAR2(20) := 'V3API_BO_RAISE';
3731: BEGIN
3732: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3733: hz_utility_v2pub.DEBUG (p_message=>message,
3734: p_prefix=>l_prefix,
3735: p_msg_level=>fnd_log.level_procedure);
3736: END IF ;
3737:

Line 3787: hz_utility_v2pub.DEBUG(p_message=> 'Record already exists in BOT',

3783: AND rownum = 1;
3784:
3785: IF l_child_rec_exists_no <> 0 THEN
3786: -- data already exists, no need to write
3787: hz_utility_v2pub.DEBUG(p_message=> 'Record already exists in BOT',
3788: p_prefix=>l_debug_prefix,
3789: p_msg_level=>fnd_log.level_procedure);
3790: END IF;
3791: EXCEPTION

Line 3818: hz_utility_v2pub.DEBUG(p_message=> 'Record already exists in BOT',

3814: AND rownum = 1;
3815:
3816: IF l_child_rec_exists_no <> 0 THEN
3817: -- data already exists, no need to write
3818: hz_utility_v2pub.DEBUG(p_message=> 'Record already exists in BOT',
3819: p_prefix=>l_debug_prefix,
3820: p_msg_level=>fnd_log.level_procedure);
3821: END IF;
3822: EXCEPTION