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_CUST_ACCT_CONTACT_BO_PUB dependencies on FND_LOG

Line 222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

218: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
219: END IF;
220:
221: -- Debug info.
222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
223: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(+)',
224: p_prefix=>l_debug_prefix,
225: p_msg_level=>fnd_log.level_procedure);
226: END IF;

Line 225: p_msg_level=>fnd_log.level_procedure);

221: -- Debug info.
222: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
223: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(+)',
224: p_prefix=>l_debug_prefix,
225: p_msg_level=>fnd_log.level_procedure);
226: END IF;
227:
228: -- Base on p_validate_bo_flag, check the completeness of business objects
229: IF(p_validate_bo_flag = FND_API.G_TRUE) THEN

Line 369: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

365: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
366: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
367:
368: -- Debug info.
369: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
370: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
371: p_msg_data=>x_msg_data,
372: p_msg_type=>'WARNING',
373: p_msg_level=>fnd_log.level_exception);

Line 373: p_msg_level=>fnd_log.level_exception);

369: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
370: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
371: p_msg_data=>x_msg_data,
372: p_msg_type=>'WARNING',
373: p_msg_level=>fnd_log.level_exception);
374: END IF;
375: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
376: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
377: p_prefix=>l_debug_prefix,

Line 375: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

371: p_msg_data=>x_msg_data,
372: p_msg_type=>'WARNING',
373: p_msg_level=>fnd_log.level_exception);
374: END IF;
375: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
376: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
377: p_prefix=>l_debug_prefix,
378: p_msg_level=>fnd_log.level_procedure);
379: END IF;

Line 378: p_msg_level=>fnd_log.level_procedure);

374: END IF;
375: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
376: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
377: p_prefix=>l_debug_prefix,
378: p_msg_level=>fnd_log.level_procedure);
379: END IF;
380:
381: EXCEPTION
382: WHEN fnd_api.g_exc_error THEN

Line 400: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

396: p_count => x_msg_count,
397: p_data => x_msg_data);
398:
399: -- Debug info.
400: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
401: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
402: p_msg_data=>x_msg_data,
403: p_msg_type=>'ERROR',
404: p_msg_level=>fnd_log.level_error);

Line 404: p_msg_level=>fnd_log.level_error);

400: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
401: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
402: p_msg_data=>x_msg_data,
403: p_msg_type=>'ERROR',
404: p_msg_level=>fnd_log.level_error);
405: END IF;
406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
407: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
408: p_prefix=>l_debug_prefix,

Line 406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

402: p_msg_data=>x_msg_data,
403: p_msg_type=>'ERROR',
404: p_msg_level=>fnd_log.level_error);
405: END IF;
406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
407: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
408: p_prefix=>l_debug_prefix,
409: p_msg_level=>fnd_log.level_procedure);
410: END IF;

Line 409: p_msg_level=>fnd_log.level_procedure);

405: END IF;
406: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
407: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
408: p_prefix=>l_debug_prefix,
409: p_msg_level=>fnd_log.level_procedure);
410: END IF;
411:
412: WHEN fnd_api.g_exc_unexpected_error THEN
413: ROLLBACK TO do_create_cac_bo_pub;

Line 430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

426: p_count => x_msg_count,
427: p_data => x_msg_data);
428:
429: -- Debug info.
430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
432: p_msg_data=>x_msg_data,
433: p_msg_type=>'UNEXPECTED ERROR',
434: p_msg_level=>fnd_log.level_error);

Line 434: p_msg_level=>fnd_log.level_error);

430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
432: p_msg_data=>x_msg_data,
433: p_msg_type=>'UNEXPECTED ERROR',
434: p_msg_level=>fnd_log.level_error);
435: END IF;
436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
437: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
438: p_prefix=>l_debug_prefix,

Line 436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

432: p_msg_data=>x_msg_data,
433: p_msg_type=>'UNEXPECTED ERROR',
434: p_msg_level=>fnd_log.level_error);
435: END IF;
436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
437: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
438: p_prefix=>l_debug_prefix,
439: p_msg_level=>fnd_log.level_procedure);
440: END IF;

Line 439: p_msg_level=>fnd_log.level_procedure);

435: END IF;
436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
437: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
438: p_prefix=>l_debug_prefix,
439: p_msg_level=>fnd_log.level_procedure);
440: END IF;
441:
442: WHEN OTHERS THEN
443: ROLLBACK TO do_create_cac_bo_pub;

Line 464: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

460: p_count => x_msg_count,
461: p_data => x_msg_data);
462:
463: -- Debug info.
464: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
466: p_msg_data=>x_msg_data,
467: p_msg_type=>'SQL ERROR',
468: p_msg_level=>fnd_log.level_error);

Line 468: p_msg_level=>fnd_log.level_error);

464: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
466: p_msg_data=>x_msg_data,
467: p_msg_type=>'SQL ERROR',
468: p_msg_level=>fnd_log.level_error);
469: END IF;
470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
471: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
472: p_prefix=>l_debug_prefix,

Line 470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

466: p_msg_data=>x_msg_data,
467: p_msg_type=>'SQL ERROR',
468: p_msg_level=>fnd_log.level_error);
469: END IF;
470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
471: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
472: p_prefix=>l_debug_prefix,
473: p_msg_level=>fnd_log.level_procedure);
474: END IF;

Line 473: p_msg_level=>fnd_log.level_procedure);

469: END IF;
470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
471: hz_utility_v2pub.debug(p_message=>'do_create_cac_bo(-)',
472: p_prefix=>l_debug_prefix,
473: p_msg_level=>fnd_log.level_procedure);
474: END IF;
475: END do_create_cac_bo;
476:
477: PROCEDURE create_cust_acct_contact_bo(

Line 688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

684: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
685: END IF;
686:
687: -- Debug info.
688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
689: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(+)',
690: p_prefix=>l_debug_prefix,
691: p_msg_level=>fnd_log.level_procedure);
692: END IF;

Line 691: p_msg_level=>fnd_log.level_procedure);

687: -- Debug info.
688: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
689: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(+)',
690: p_prefix=>l_debug_prefix,
691: p_msg_level=>fnd_log.level_procedure);
692: END IF;
693:
694: x_cust_acct_contact_id := p_cust_acct_contact_obj.cust_acct_contact_id;
695: x_cust_acct_contact_os := p_cust_acct_contact_obj.orig_system;

Line 769: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

765: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
766: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
767:
768: -- Debug info.
769: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
770: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
771: p_msg_data=>x_msg_data,
772: p_msg_type=>'WARNING',
773: p_msg_level=>fnd_log.level_exception);

Line 773: p_msg_level=>fnd_log.level_exception);

769: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
770: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
771: p_msg_data=>x_msg_data,
772: p_msg_type=>'WARNING',
773: p_msg_level=>fnd_log.level_exception);
774: END IF;
775: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
776: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
777: p_prefix=>l_debug_prefix,

Line 775: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

771: p_msg_data=>x_msg_data,
772: p_msg_type=>'WARNING',
773: p_msg_level=>fnd_log.level_exception);
774: END IF;
775: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
776: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
777: p_prefix=>l_debug_prefix,
778: p_msg_level=>fnd_log.level_procedure);
779: END IF;

Line 778: p_msg_level=>fnd_log.level_procedure);

774: END IF;
775: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
776: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
777: p_prefix=>l_debug_prefix,
778: p_msg_level=>fnd_log.level_procedure);
779: END IF;
780: EXCEPTION
781: WHEN fnd_api.g_exc_error THEN
782: ROLLBACK TO do_update_cac_bo_pub;

Line 799: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

795: p_count => x_msg_count,
796: p_data => x_msg_data);
797:
798: -- Debug info.
799: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
800: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
801: p_msg_data=>x_msg_data,
802: p_msg_type=>'ERROR',
803: p_msg_level=>fnd_log.level_error);

Line 803: p_msg_level=>fnd_log.level_error);

799: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
800: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
801: p_msg_data=>x_msg_data,
802: p_msg_type=>'ERROR',
803: p_msg_level=>fnd_log.level_error);
804: END IF;
805: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
806: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
807: p_prefix=>l_debug_prefix,

Line 805: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

801: p_msg_data=>x_msg_data,
802: p_msg_type=>'ERROR',
803: p_msg_level=>fnd_log.level_error);
804: END IF;
805: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
806: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
807: p_prefix=>l_debug_prefix,
808: p_msg_level=>fnd_log.level_procedure);
809: END IF;

Line 808: p_msg_level=>fnd_log.level_procedure);

804: END IF;
805: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
806: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
807: p_prefix=>l_debug_prefix,
808: p_msg_level=>fnd_log.level_procedure);
809: END IF;
810:
811: WHEN fnd_api.g_exc_unexpected_error THEN
812: ROLLBACK TO do_update_cac_bo_pub;

Line 829: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

825: p_count => x_msg_count,
826: p_data => x_msg_data);
827:
828: -- Debug info.
829: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
830: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
831: p_msg_data=>x_msg_data,
832: p_msg_type=>'UNEXPECTED ERROR',
833: p_msg_level=>fnd_log.level_error);

Line 833: p_msg_level=>fnd_log.level_error);

829: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
830: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
831: p_msg_data=>x_msg_data,
832: p_msg_type=>'UNEXPECTED ERROR',
833: p_msg_level=>fnd_log.level_error);
834: END IF;
835: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
836: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
837: p_prefix=>l_debug_prefix,

Line 835: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

831: p_msg_data=>x_msg_data,
832: p_msg_type=>'UNEXPECTED ERROR',
833: p_msg_level=>fnd_log.level_error);
834: END IF;
835: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
836: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
837: p_prefix=>l_debug_prefix,
838: p_msg_level=>fnd_log.level_procedure);
839: END IF;

Line 838: p_msg_level=>fnd_log.level_procedure);

834: END IF;
835: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
836: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
837: p_prefix=>l_debug_prefix,
838: p_msg_level=>fnd_log.level_procedure);
839: END IF;
840:
841: WHEN OTHERS THEN
842: ROLLBACK TO do_update_cac_bo_pub;

Line 863: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

859: p_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);

Line 867: p_msg_level=>fnd_log.level_error);

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;
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
871: p_prefix=>l_debug_prefix,

Line 869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

865: p_msg_data=>x_msg_data,
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=>'do_update_cac_bo(-)',
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;

Line 872: p_msg_level=>fnd_log.level_procedure);

868: END IF;
869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
870: hz_utility_v2pub.debug(p_message=>'do_update_cac_bo(-)',
871: p_prefix=>l_debug_prefix,
872: p_msg_level=>fnd_log.level_procedure);
873: END IF;
874: END do_update_cac_bo;
875:
876: -- PROCEDURE do_save_cac_bo

Line 912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

908: FND_MSG_PUB.initialize;
909: END IF;
910:
911: -- Debug info.
912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
913: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(+)',
914: p_prefix=>l_debug_prefix,
915: p_msg_level=>fnd_log.level_procedure);
916: END IF;

Line 915: p_msg_level=>fnd_log.level_procedure);

911: -- Debug info.
912: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
913: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(+)',
914: p_prefix=>l_debug_prefix,
915: p_msg_level=>fnd_log.level_procedure);
916: END IF;
917:
918: x_cust_acct_contact_id := p_cust_acct_contact_obj.cust_acct_contact_id;
919: x_cust_acct_contact_os := p_cust_acct_contact_obj.orig_system;

Line 977: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

973: RAISE FND_API.G_EXC_ERROR;
974: END IF;
975:
976: -- Debug info.
977: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
978: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
979: p_msg_data=>x_msg_data,
980: p_msg_type=>'WARNING',
981: p_msg_level=>fnd_log.level_exception);

Line 981: p_msg_level=>fnd_log.level_exception);

977: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
978: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
979: p_msg_data=>x_msg_data,
980: p_msg_type=>'WARNING',
981: p_msg_level=>fnd_log.level_exception);
982: END IF;
983: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
984: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
985: p_prefix=>l_debug_prefix,

Line 983: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

979: p_msg_data=>x_msg_data,
980: p_msg_type=>'WARNING',
981: p_msg_level=>fnd_log.level_exception);
982: END IF;
983: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
984: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
985: p_prefix=>l_debug_prefix,
986: p_msg_level=>fnd_log.level_procedure);
987: END IF;

Line 986: p_msg_level=>fnd_log.level_procedure);

982: END IF;
983: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
984: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
985: p_prefix=>l_debug_prefix,
986: p_msg_level=>fnd_log.level_procedure);
987: END IF;
988:
989: EXCEPTION
990: WHEN fnd_api.g_exc_error THEN

Line 1000: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

996: p_count => x_msg_count,
997: p_data => x_msg_data);
998:
999: -- Debug info.
1000: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1001: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1002: p_msg_data=>x_msg_data,
1003: p_msg_type=>'ERROR',
1004: p_msg_level=>fnd_log.level_error);

Line 1004: p_msg_level=>fnd_log.level_error);

1000: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1001: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1002: p_msg_data=>x_msg_data,
1003: p_msg_type=>'ERROR',
1004: p_msg_level=>fnd_log.level_error);
1005: END IF;
1006: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1007: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
1008: p_prefix=>l_debug_prefix,

Line 1006: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1002: p_msg_data=>x_msg_data,
1003: p_msg_type=>'ERROR',
1004: p_msg_level=>fnd_log.level_error);
1005: END IF;
1006: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1007: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
1008: p_prefix=>l_debug_prefix,
1009: p_msg_level=>fnd_log.level_procedure);
1010: END IF;

Line 1009: p_msg_level=>fnd_log.level_procedure);

1005: END IF;
1006: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1007: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
1008: p_prefix=>l_debug_prefix,
1009: p_msg_level=>fnd_log.level_procedure);
1010: END IF;
1011: WHEN fnd_api.g_exc_unexpected_error THEN
1012: x_return_status := fnd_api.g_ret_sts_unexp_error;
1013:

Line 1019: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1015: p_count => x_msg_count,
1016: p_data => x_msg_data);
1017:
1018: -- Debug info.
1019: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1020: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1021: p_msg_data=>x_msg_data,
1022: p_msg_type=>'UNEXPECTED ERROR',
1023: p_msg_level=>fnd_log.level_error);

Line 1023: p_msg_level=>fnd_log.level_error);

1019: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1020: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1021: p_msg_data=>x_msg_data,
1022: p_msg_type=>'UNEXPECTED ERROR',
1023: p_msg_level=>fnd_log.level_error);
1024: END IF;
1025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1026: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
1027: p_prefix=>l_debug_prefix,

Line 1025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1021: p_msg_data=>x_msg_data,
1022: p_msg_type=>'UNEXPECTED ERROR',
1023: p_msg_level=>fnd_log.level_error);
1024: END IF;
1025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1026: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
1027: p_prefix=>l_debug_prefix,
1028: p_msg_level=>fnd_log.level_procedure);
1029: END IF;

Line 1028: p_msg_level=>fnd_log.level_procedure);

1024: END IF;
1025: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1026: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
1027: p_prefix=>l_debug_prefix,
1028: p_msg_level=>fnd_log.level_procedure);
1029: END IF;
1030: WHEN OTHERS THEN
1031: x_return_status := fnd_api.g_ret_sts_unexp_error;
1032:

Line 1042: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

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

Line 1046: p_msg_level=>fnd_log.level_error);

1042: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1043: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1044: p_msg_data=>x_msg_data,
1045: p_msg_type=>'SQL ERROR',
1046: p_msg_level=>fnd_log.level_error);
1047: END IF;
1048: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1049: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
1050: p_prefix=>l_debug_prefix,

Line 1048: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

Line 1051: p_msg_level=>fnd_log.level_procedure);

1047: END IF;
1048: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1049: hz_utility_v2pub.debug(p_message=>'do_save_cac_bo(-)',
1050: p_prefix=>l_debug_prefix,
1051: p_msg_level=>fnd_log.level_procedure);
1052: END IF;
1053: END do_save_cac_bo;
1054:
1055: PROCEDURE save_cust_acct_contact_bo(

Line 1224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1220: END IF;
1221:
1222:
1223: -- Debug info.
1224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1225: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo(+)',
1226: p_prefix=>l_debug_prefix,
1227: p_msg_level=>fnd_log.level_procedure);
1228: END IF;

Line 1227: p_msg_level=>fnd_log.level_procedure);

1223: -- Debug info.
1224: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1225: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo(+)',
1226: p_prefix=>l_debug_prefix,
1227: p_msg_level=>fnd_log.level_procedure);
1228: END IF;
1229:
1230: -- check if pass in contact_point_id and/or os+osr
1231: -- extraction validation logic is same as update

Line 1268: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

1264: END IF;
1265:
1266:
1267: -- Debug info.
1268: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1269: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1270: p_msg_data=>x_msg_data,
1271: p_msg_type=>'WARNING',
1272: p_msg_level=>fnd_log.level_exception);

Line 1272: p_msg_level=>fnd_log.level_exception);

1268: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1269: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1270: p_msg_data=>x_msg_data,
1271: p_msg_type=>'WARNING',
1272: p_msg_level=>fnd_log.level_exception);
1273: END IF;
1274:
1275: -- Debug info.
1276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1272: p_msg_level=>fnd_log.level_exception);
1273: END IF;
1274:
1275: -- Debug info.
1276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1277: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1278: p_prefix=>l_debug_prefix,
1279: p_msg_level=>fnd_log.level_procedure);
1280: END IF;

Line 1279: p_msg_level=>fnd_log.level_procedure);

1275: -- Debug info.
1276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1277: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1278: p_prefix=>l_debug_prefix,
1279: p_msg_level=>fnd_log.level_procedure);
1280: END IF;
1281:
1282:
1283: EXCEPTION

Line 1293: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1289: p_count => x_msg_count,
1290: p_data => x_msg_data);
1291:
1292: -- Debug info.
1293: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1294: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1295: p_msg_data=>x_msg_data,
1296: p_msg_type=>'ERROR',
1297: p_msg_level=>fnd_log.level_error);

Line 1297: p_msg_level=>fnd_log.level_error);

1293: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1294: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1295: p_msg_data=>x_msg_data,
1296: p_msg_type=>'ERROR',
1297: p_msg_level=>fnd_log.level_error);
1298: END IF;
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1301: p_prefix=>l_debug_prefix,

Line 1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1295: p_msg_data=>x_msg_data,
1296: p_msg_type=>'ERROR',
1297: p_msg_level=>fnd_log.level_error);
1298: END IF;
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;

Line 1302: p_msg_level=>fnd_log.level_procedure);

1298: END IF;
1299: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1300: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1301: p_prefix=>l_debug_prefix,
1302: p_msg_level=>fnd_log.level_procedure);
1303: END IF;
1304: WHEN fnd_api.g_exc_unexpected_error THEN
1305: x_return_status := fnd_api.g_ret_sts_unexp_error;
1306:

Line 1312: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1308: p_count => x_msg_count,
1309: p_data => x_msg_data);
1310:
1311: -- Debug info.
1312: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1313: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1314: p_msg_data=>x_msg_data,
1315: p_msg_type=>'UNEXPECTED ERROR',
1316: p_msg_level=>fnd_log.level_error);

Line 1316: p_msg_level=>fnd_log.level_error);

1312: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1313: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1314: p_msg_data=>x_msg_data,
1315: p_msg_type=>'UNEXPECTED ERROR',
1316: p_msg_level=>fnd_log.level_error);
1317: END IF;
1318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1319: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1320: p_prefix=>l_debug_prefix,

Line 1318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1314: p_msg_data=>x_msg_data,
1315: p_msg_type=>'UNEXPECTED ERROR',
1316: p_msg_level=>fnd_log.level_error);
1317: END IF;
1318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1319: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1320: p_prefix=>l_debug_prefix,
1321: p_msg_level=>fnd_log.level_procedure);
1322: END IF;

Line 1321: p_msg_level=>fnd_log.level_procedure);

1317: END IF;
1318: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1319: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1320: p_prefix=>l_debug_prefix,
1321: p_msg_level=>fnd_log.level_procedure);
1322: END IF;
1323: WHEN OTHERS THEN
1324: x_return_status := fnd_api.g_ret_sts_unexp_error;
1325:

Line 1335: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN

1331: p_count => x_msg_count,
1332: p_data => x_msg_data);
1333:
1334: -- Debug info.
1335: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1336: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1337: p_msg_data=>x_msg_data,
1338: p_msg_type=>'SQL ERROR',
1339: p_msg_level=>fnd_log.level_error);

Line 1339: p_msg_level=>fnd_log.level_error);

1335: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1336: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1337: p_msg_data=>x_msg_data,
1338: p_msg_type=>'SQL ERROR',
1339: p_msg_level=>fnd_log.level_error);
1340: END IF;
1341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1343: p_prefix=>l_debug_prefix,

Line 1341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

1337: p_msg_data=>x_msg_data,
1338: p_msg_type=>'SQL ERROR',
1339: p_msg_level=>fnd_log.level_error);
1340: END IF;
1341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1343: p_prefix=>l_debug_prefix,
1344: p_msg_level=>fnd_log.level_procedure);
1345: END IF;

Line 1344: p_msg_level=>fnd_log.level_procedure);

1340: END IF;
1341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1342: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_contact_bo_pub.get_cust_acct_contact_bo (-)',
1343: p_prefix=>l_debug_prefix,
1344: p_msg_level=>fnd_log.level_procedure);
1345: END IF;
1346:
1347: end;
1348: