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

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

142: px_cust_acct_rec.selling_party_id := p_cust_acct_obj.selling_party_id;
143: IF(p_create_or_update = 'C') THEN
144: px_cust_acct_rec.orig_system := p_cust_acct_os;
145: px_cust_acct_rec.orig_system_reference := p_cust_acct_osr;
146: px_cust_acct_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
147: END IF;
148: px_cust_acct_rec.attribute_category := p_cust_acct_obj.attribute_category;
149: px_cust_acct_rec.attribute1 := p_cust_acct_obj.attribute1;
150: px_cust_acct_rec.attribute2 := p_cust_acct_obj.attribute2;

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

241: FND_MSG_PUB.initialize;
242: END IF;
243:
244: -- initialize Global variable
245: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
246: IF(p_created_by_module IS NULL) THEN
247: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
248: ELSE
249: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

243:
244: -- initialize Global variable
245: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
246: IF(p_created_by_module IS NULL) THEN
247: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
248: ELSE
249: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
250: END IF;
251:

Line 249: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

245: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
246: IF(p_created_by_module IS NULL) THEN
247: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
248: ELSE
249: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
250: END IF;
251:
252: -- Debug info.
253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 254: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(+)',

250: END IF;
251:
252: -- Debug info.
253: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
254: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(+)',
255: p_prefix=>l_debug_prefix,
256: p_msg_level=>fnd_log.level_procedure);
257: END IF;
258:

Line 415: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413: END IF;
414:
415: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
416:
417: -------------------------------------
418: -- Call cust account contact
419: -------------------------------------

Line 442: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

438: RAISE FND_API.G_EXC_ERROR;
439: END IF;
440: END IF;
441:
442: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
443:
444: -------------------------------------
445: -- Call cust account site
446: -------------------------------------

Line 468: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

464: RAISE FND_API.G_EXC_ERROR;
465: END IF;
466: END IF;
467:
468: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
469:
470: ------------------------
471: -- Call bank account use
472: ------------------------

Line 509: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

505: END IF;
506: END IF;
507:
508: -- reset Global variable
509: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
510: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
511:
512: -- Debug info.
513: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 510: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

506: END IF;
507:
508: -- reset Global variable
509: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
510: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
511:
512: -- Debug info.
513: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
514: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

510: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
511:
512: -- Debug info.
513: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
514: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
515: p_msg_data=>x_msg_data,
516: p_msg_type=>'WARNING',
517: p_msg_level=>fnd_log.level_exception);
518: END IF;

Line 520: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',

516: p_msg_type=>'WARNING',
517: p_msg_level=>fnd_log.level_exception);
518: END IF;
519: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
520: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
521: p_prefix=>l_debug_prefix,
522: p_msg_level=>fnd_log.level_procedure);
523: END IF;
524:

Line 530: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

526: WHEN fnd_api.g_exc_error THEN
527: ROLLBACK TO do_create_cust_acct_bo_pub;
528:
529: -- reset Global variable
530: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
531: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
532:
533: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
534: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 531: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

527: ROLLBACK TO do_create_cust_acct_bo_pub;
528:
529: -- reset Global variable
530: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
531: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
532:
533: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
534: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
535: FND_MSG_PUB.ADD;

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

541: p_data => x_msg_data);
542:
543: -- Debug info.
544: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
546: p_msg_data=>x_msg_data,
547: p_msg_type=>'ERROR',
548: p_msg_level=>fnd_log.level_error);
549: END IF;

Line 551: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',

547: p_msg_type=>'ERROR',
548: p_msg_level=>fnd_log.level_error);
549: END IF;
550: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
551: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
552: p_prefix=>l_debug_prefix,
553: p_msg_level=>fnd_log.level_procedure);
554: END IF;
555:

Line 560: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

556: WHEN fnd_api.g_exc_unexpected_error THEN
557: ROLLBACK TO do_create_cust_acct_bo_pub;
558:
559: -- reset Global variable
560: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
561: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
562:
563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
564: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 561: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

557: ROLLBACK TO do_create_cust_acct_bo_pub;
558:
559: -- reset Global variable
560: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
561: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
562:
563: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
564: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
565: FND_MSG_PUB.ADD;

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

571: p_data => x_msg_data);
572:
573: -- Debug info.
574: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
575: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
576: p_msg_data=>x_msg_data,
577: p_msg_type=>'UNEXPECTED ERROR',
578: p_msg_level=>fnd_log.level_error);
579: END IF;

Line 581: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',

577: p_msg_type=>'UNEXPECTED ERROR',
578: p_msg_level=>fnd_log.level_error);
579: END IF;
580: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
581: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
582: p_prefix=>l_debug_prefix,
583: p_msg_level=>fnd_log.level_procedure);
584: END IF;
585:

Line 590: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

586: WHEN OTHERS THEN
587: ROLLBACK TO do_create_cust_acct_bo_pub;
588:
589: -- reset Global variable
590: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
591: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
592:
593: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
594: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 591: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

587: ROLLBACK TO do_create_cust_acct_bo_pub;
588:
589: -- reset Global variable
590: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
591: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
592:
593: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
594: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
595: FND_MSG_PUB.ADD;

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

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

Line 615: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',

611: p_msg_type=>'SQL ERROR',
612: p_msg_level=>fnd_log.level_error);
613: END IF;
614: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
615: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
616: p_prefix=>l_debug_prefix,
617: p_msg_level=>fnd_log.level_procedure);
618: END IF;
619: END do_create_cust_acct_bo;

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

815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- initialize Global variable
819: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
820: IF(p_created_by_module IS NULL) THEN
821: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
822: ELSE
823: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

817:
818: -- initialize Global variable
819: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
820: IF(p_created_by_module IS NULL) THEN
821: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
822: ELSE
823: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
824: END IF;
825:

Line 823: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

819: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
820: IF(p_created_by_module IS NULL) THEN
821: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
822: ELSE
823: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
824: END IF;
825:
826: -- Debug info.
827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 828: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo_pub(+)',

824: END IF;
825:
826: -- Debug info.
827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
828: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo_pub(+)',
829: p_prefix=>l_debug_prefix,
830: p_msg_level=>fnd_log.level_procedure);
831: END IF;
832:

Line 924: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

920: END IF;
921: END IF;
922: END IF;
923:
924: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
925:
926: -----------------------------------
927: -- For cust account contact
928: -----------------------------------

Line 949: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

945: RAISE FND_API.G_EXC_ERROR;
946: END IF;
947: END IF;
948:
949: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
950:
951: -------------------------------
952: -- For Update account acct relate
953: -------------------------------

Line 993: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

989: RAISE FND_API.G_EXC_ERROR;
990: END IF;
991: END IF;
992:
993: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
994:
995: ------------------------
996: -- Call bank account use
997: ------------------------

Line 1034: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1030: END IF;
1031: END IF;
1032:
1033: -- reset Global variable
1034: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1035: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1036:
1037: -- Debug info.
1038: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1035: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1031: END IF;
1032:
1033: -- reset Global variable
1034: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1035: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1036:
1037: -- Debug info.
1038: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1039: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

1035: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1036:
1037: -- Debug info.
1038: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1039: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1040: p_msg_data=>x_msg_data,
1041: p_msg_type=>'WARNING',
1042: p_msg_level=>fnd_log.level_exception);
1043: END IF;

Line 1045: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',

1041: p_msg_type=>'WARNING',
1042: p_msg_level=>fnd_log.level_exception);
1043: END IF;
1044: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1045: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1046: p_prefix=>l_debug_prefix,
1047: p_msg_level=>fnd_log.level_procedure);
1048: END IF;
1049: EXCEPTION

Line 1054: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1050: WHEN fnd_api.g_exc_error THEN
1051: ROLLBACK TO do_update_cust_acct_bo_pub;
1052:
1053: -- reset Global variable
1054: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1055: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1056:
1057: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1058: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 1055: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1051: ROLLBACK TO do_update_cust_acct_bo_pub;
1052:
1053: -- reset Global variable
1054: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1055: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1056:
1057: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1058: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1059: FND_MSG_PUB.ADD;

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

1065: p_data => x_msg_data);
1066:
1067: -- Debug info.
1068: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1069: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1070: p_msg_data=>x_msg_data,
1071: p_msg_type=>'ERROR',
1072: p_msg_level=>fnd_log.level_error);
1073: END IF;

Line 1075: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',

1071: p_msg_type=>'ERROR',
1072: p_msg_level=>fnd_log.level_error);
1073: END IF;
1074: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1075: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1076: p_prefix=>l_debug_prefix,
1077: p_msg_level=>fnd_log.level_procedure);
1078: END IF;
1079:

Line 1084: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1080: WHEN fnd_api.g_exc_unexpected_error THEN
1081: ROLLBACK TO do_update_cust_acct_bo_pub;
1082:
1083: -- reset Global variable
1084: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1085: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1086:
1087: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1088: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 1085: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1081: ROLLBACK TO do_update_cust_acct_bo_pub;
1082:
1083: -- reset Global variable
1084: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1085: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1086:
1087: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1088: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1089: FND_MSG_PUB.ADD;

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

1095: p_data => x_msg_data);
1096:
1097: -- Debug info.
1098: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1099: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1100: p_msg_data=>x_msg_data,
1101: p_msg_type=>'UNEXPECTED ERROR',
1102: p_msg_level=>fnd_log.level_error);
1103: END IF;

Line 1105: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',

1101: p_msg_type=>'UNEXPECTED ERROR',
1102: p_msg_level=>fnd_log.level_error);
1103: END IF;
1104: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1105: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1106: p_prefix=>l_debug_prefix,
1107: p_msg_level=>fnd_log.level_procedure);
1108: END IF;
1109:

Line 1114: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1110: WHEN OTHERS THEN
1111: ROLLBACK TO do_update_cust_acct_bo_pub;
1112:
1113: -- reset Global variable
1114: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1115: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1116:
1117: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1118: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 1115: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1111: ROLLBACK TO do_update_cust_acct_bo_pub;
1112:
1113: -- reset Global variable
1114: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1115: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1116:
1117: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1118: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1119: FND_MSG_PUB.ADD;

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

1129: p_data => x_msg_data);
1130:
1131: -- Debug info.
1132: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1133: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1134: p_msg_data=>x_msg_data,
1135: p_msg_type=>'SQL ERROR',
1136: p_msg_level=>fnd_log.level_error);
1137: END IF;

Line 1139: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',

1135: p_msg_type=>'SQL ERROR',
1136: p_msg_level=>fnd_log.level_error);
1137: END IF;
1138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1139: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1140: p_prefix=>l_debug_prefix,
1141: p_msg_level=>fnd_log.level_procedure);
1142: END IF;
1143: END do_update_cust_acct_bo;

Line 1182: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(+)',

1178: END IF;
1179:
1180: -- Debug info.
1181: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1182: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(+)',
1183: p_prefix=>l_debug_prefix,
1184: p_msg_level=>fnd_log.level_procedure);
1185: END IF;
1186:

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

1241: END IF;
1242:
1243: -- Debug info.
1244: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1245: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1246: p_msg_data=>x_msg_data,
1247: p_msg_type=>'WARNING',
1248: p_msg_level=>fnd_log.level_exception);
1249: END IF;

Line 1251: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',

1247: p_msg_type=>'WARNING',
1248: p_msg_level=>fnd_log.level_exception);
1249: END IF;
1250: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1251: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1252: p_prefix=>l_debug_prefix,
1253: p_msg_level=>fnd_log.level_procedure);
1254: END IF;
1255:

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

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

Line 1274: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',

1270: p_msg_type=>'ERROR',
1271: p_msg_level=>fnd_log.level_error);
1272: END IF;
1273: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1274: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1275: p_prefix=>l_debug_prefix,
1276: p_msg_level=>fnd_log.level_procedure);
1277: END IF;
1278: WHEN fnd_api.g_exc_unexpected_error THEN

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

1283: p_data => x_msg_data);
1284:
1285: -- Debug info.
1286: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1287: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1288: p_msg_data=>x_msg_data,
1289: p_msg_type=>'UNEXPECTED ERROR',
1290: p_msg_level=>fnd_log.level_error);
1291: END IF;

Line 1293: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',

1289: p_msg_type=>'UNEXPECTED ERROR',
1290: p_msg_level=>fnd_log.level_error);
1291: END IF;
1292: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1293: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1294: p_prefix=>l_debug_prefix,
1295: p_msg_level=>fnd_log.level_procedure);
1296: END IF;
1297: WHEN OTHERS THEN

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

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

Line 1316: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',

1312: p_msg_type=>'SQL ERROR',
1313: p_msg_level=>fnd_log.level_error);
1314: END IF;
1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1317: p_prefix=>l_debug_prefix,
1318: p_msg_level=>fnd_log.level_procedure);
1319: END IF;
1320: END do_save_cust_acct_bo;

Line 1494: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo(+)',

1490:
1491:
1492: -- Debug info.
1493: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1494: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo(+)',
1495: p_prefix=>l_debug_prefix,
1496: p_msg_level=>fnd_log.level_procedure);
1497: END IF;
1498:

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

1534:
1535:
1536: -- Debug info.
1537: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1538: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1539: p_msg_data=>x_msg_data,
1540: p_msg_type=>'WARNING',
1541: p_msg_level=>fnd_log.level_exception);
1542: END IF;

Line 1546: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',

1542: END IF;
1543:
1544: -- Debug info.
1545: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1546: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1547: p_prefix=>l_debug_prefix,
1548: p_msg_level=>fnd_log.level_procedure);
1549: END IF;
1550:

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

1559: p_data => x_msg_data);
1560:
1561: -- Debug info.
1562: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1563: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1564: p_msg_data=>x_msg_data,
1565: p_msg_type=>'ERROR',
1566: p_msg_level=>fnd_log.level_error);
1567: END IF;

Line 1569: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',

1565: p_msg_type=>'ERROR',
1566: p_msg_level=>fnd_log.level_error);
1567: END IF;
1568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1569: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1570: p_prefix=>l_debug_prefix,
1571: p_msg_level=>fnd_log.level_procedure);
1572: END IF;
1573: WHEN fnd_api.g_exc_unexpected_error THEN

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

1578: p_data => x_msg_data);
1579:
1580: -- Debug info.
1581: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1582: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1583: p_msg_data=>x_msg_data,
1584: p_msg_type=>'UNEXPECTED ERROR',
1585: p_msg_level=>fnd_log.level_error);
1586: END IF;

Line 1588: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',

1584: p_msg_type=>'UNEXPECTED ERROR',
1585: p_msg_level=>fnd_log.level_error);
1586: END IF;
1587: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1588: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1589: p_prefix=>l_debug_prefix,
1590: p_msg_level=>fnd_log.level_procedure);
1591: END IF;
1592: WHEN OTHERS THEN

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

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

1607: p_msg_type=>'SQL 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=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1612: p_prefix=>l_debug_prefix,
1613: p_msg_level=>fnd_log.level_procedure);
1614: END IF;
1615:

Line 1787: px_cust_acct_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1783: px_cust_acct_rec.selling_party_id := p_cust_acct_v2_obj.selling_party_id;
1784: IF(p_create_or_update = 'C') THEN
1785: px_cust_acct_rec.orig_system := p_cust_acct_os;
1786: px_cust_acct_rec.orig_system_reference := p_cust_acct_osr;
1787: px_cust_acct_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1788: END IF;
1789: px_cust_acct_rec.attribute_category := p_cust_acct_v2_obj.attribute_category;
1790: px_cust_acct_rec.attribute1 := p_cust_acct_v2_obj.attribute1;
1791: px_cust_acct_rec.attribute2 := p_cust_acct_v2_obj.attribute2;

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

1883: FND_MSG_PUB.initialize;
1884: END IF;
1885:
1886: -- initialize Global variable
1887: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1888: IF(p_created_by_module IS NULL) THEN
1889: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1890: ELSE
1891: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

1885:
1886: -- initialize Global variable
1887: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1888: IF(p_created_by_module IS NULL) THEN
1889: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1890: ELSE
1891: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1892: END IF;
1893:

Line 1891: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

1887: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
1888: IF(p_created_by_module IS NULL) THEN
1889: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
1890: ELSE
1891: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
1892: END IF;
1893:
1894: -- Debug info.
1895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1896: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(+)',

1892: END IF;
1893:
1894: -- Debug info.
1895: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1896: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(+)',
1897: p_prefix=>l_debug_prefix,
1898: p_msg_level=>fnd_log.level_procedure);
1899: END IF;
1900:

Line 2057: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2053: RAISE FND_API.G_EXC_ERROR;
2054: END IF;
2055: END IF;
2056:
2057: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2058:
2059: -------------------------------------
2060: -- Call cust account contact
2061: -------------------------------------

Line 2084: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2080: RAISE FND_API.G_EXC_ERROR;
2081: END IF;
2082: END IF;
2083:
2084: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2085:
2086: -------------------------------------
2087: -- Call cust account site
2088: -------------------------------------

Line 2110: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2106: RAISE FND_API.G_EXC_ERROR;
2107: END IF;
2108: END IF;
2109:
2110: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2111:
2112: ------------------------
2113: -- Call bank account use
2114: ------------------------

Line 2152: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2148: END IF;
2149: END IF;
2150:
2151: -- reset Global variable
2152: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2153: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2154:
2155: -- Debug info.
2156: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2153: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2149: END IF;
2150:
2151: -- reset Global variable
2152: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2153: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2154:
2155: -- Debug info.
2156: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2157: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

2153: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2154:
2155: -- Debug info.
2156: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2157: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2158: p_msg_data=>x_msg_data,
2159: p_msg_type=>'WARNING',
2160: p_msg_level=>fnd_log.level_exception);
2161: END IF;

Line 2163: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',

2159: p_msg_type=>'WARNING',
2160: p_msg_level=>fnd_log.level_exception);
2161: END IF;
2162: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2163: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2164: p_prefix=>l_debug_prefix,
2165: p_msg_level=>fnd_log.level_procedure);
2166: END IF;
2167:

Line 2173: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2169: WHEN fnd_api.g_exc_error THEN
2170: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2171:
2172: -- reset Global variable
2173: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2174: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2175:
2176: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2177: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2174: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2170: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2171:
2172: -- reset Global variable
2173: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2174: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2175:
2176: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2177: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2178: FND_MSG_PUB.ADD;

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

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

Line 2194: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',

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

Line 2203: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2199: WHEN fnd_api.g_exc_unexpected_error THEN
2200: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2201:
2202: -- reset Global variable
2203: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2204: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2205:
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2207: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2204: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2200: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2201:
2202: -- reset Global variable
2203: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2204: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2205:
2206: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2207: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2208: FND_MSG_PUB.ADD;

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

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

Line 2224: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',

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

Line 2233: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2229: WHEN OTHERS THEN
2230: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2231:
2232: -- reset Global variable
2233: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2234: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2235:
2236: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2237: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2234: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2230: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2231:
2232: -- reset Global variable
2233: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2234: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2235:
2236: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2237: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2238: FND_MSG_PUB.ADD;

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

2248: p_data => x_msg_data);
2249:
2250: -- Debug info.
2251: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2252: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2253: p_msg_data=>x_msg_data,
2254: p_msg_type=>'SQL ERROR',
2255: p_msg_level=>fnd_log.level_error);
2256: END IF;

Line 2258: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',

2254: p_msg_type=>'SQL ERROR',
2255: p_msg_level=>fnd_log.level_error);
2256: END IF;
2257: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2258: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2259: p_prefix=>l_debug_prefix,
2260: p_msg_level=>fnd_log.level_procedure);
2261: END IF;
2262: END do_create_cust_acct_v2_bo;

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

2391: FND_MSG_PUB.initialize;
2392: END IF;
2393:
2394: -- initialize Global variable
2395: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2396: IF(p_created_by_module IS NULL) THEN
2397: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2398: ELSE
2399: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

2393:
2394: -- initialize Global variable
2395: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2396: IF(p_created_by_module IS NULL) THEN
2397: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2398: ELSE
2399: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2400: END IF;
2401:

Line 2399: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

2395: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2396: IF(p_created_by_module IS NULL) THEN
2397: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2398: ELSE
2399: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2400: END IF;
2401:
2402: -- Debug info.
2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 2404: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo_pub(+)',

2400: END IF;
2401:
2402: -- Debug info.
2403: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2404: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo_pub(+)',
2405: p_prefix=>l_debug_prefix,
2406: p_msg_level=>fnd_log.level_procedure);
2407: END IF;
2408:

Line 2500: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2496: END IF;
2497: END IF;
2498: END IF;
2499:
2500: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2501:
2502: -----------------------------------
2503: -- For cust account contact
2504: -----------------------------------

Line 2525: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2521: RAISE FND_API.G_EXC_ERROR;
2522: END IF;
2523: END IF;
2524:
2525: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2526:
2527: -------------------------------
2528: -- For Update account acct relate
2529: -------------------------------

Line 2569: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2565: RAISE FND_API.G_EXC_ERROR;
2566: END IF;
2567: END IF;
2568:
2569: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2570:
2571: ------------------------
2572: -- Call bank account use
2573: ------------------------

Line 2611: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2607: END IF;
2608: END IF;
2609:
2610: -- reset Global variable
2611: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2612: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2613:
2614: -- Debug info.
2615: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2612: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2608: END IF;
2609:
2610: -- reset Global variable
2611: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2612: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2613:
2614: -- Debug info.
2615: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2616: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

2612: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2613:
2614: -- Debug info.
2615: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2616: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2617: p_msg_data=>x_msg_data,
2618: p_msg_type=>'WARNING',
2619: p_msg_level=>fnd_log.level_exception);
2620: END IF;

Line 2622: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',

2618: p_msg_type=>'WARNING',
2619: p_msg_level=>fnd_log.level_exception);
2620: END IF;
2621: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2622: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2623: p_prefix=>l_debug_prefix,
2624: p_msg_level=>fnd_log.level_procedure);
2625: END IF;
2626: EXCEPTION

Line 2631: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2627: WHEN fnd_api.g_exc_error THEN
2628: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2629:
2630: -- reset Global variable
2631: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2632: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2633:
2634: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2635: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2632: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2628: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2629:
2630: -- reset Global variable
2631: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2632: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2633:
2634: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2635: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2636: FND_MSG_PUB.ADD;

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

2642: p_data => x_msg_data);
2643:
2644: -- Debug info.
2645: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2646: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2647: p_msg_data=>x_msg_data,
2648: p_msg_type=>'ERROR',
2649: p_msg_level=>fnd_log.level_error);
2650: END IF;

Line 2652: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',

2648: p_msg_type=>'ERROR',
2649: p_msg_level=>fnd_log.level_error);
2650: END IF;
2651: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2652: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2653: p_prefix=>l_debug_prefix,
2654: p_msg_level=>fnd_log.level_procedure);
2655: END IF;
2656:

Line 2661: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2657: WHEN fnd_api.g_exc_unexpected_error THEN
2658: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2659:
2660: -- reset Global variable
2661: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2662: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2663:
2664: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2665: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2662: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2658: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2659:
2660: -- reset Global variable
2661: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2662: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2663:
2664: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2665: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2666: FND_MSG_PUB.ADD;

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

2672: p_data => x_msg_data);
2673:
2674: -- Debug info.
2675: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2676: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2677: p_msg_data=>x_msg_data,
2678: p_msg_type=>'UNEXPECTED ERROR',
2679: p_msg_level=>fnd_log.level_error);
2680: END IF;

Line 2682: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',

2678: p_msg_type=>'UNEXPECTED ERROR',
2679: p_msg_level=>fnd_log.level_error);
2680: END IF;
2681: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2682: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2683: p_prefix=>l_debug_prefix,
2684: p_msg_level=>fnd_log.level_procedure);
2685: END IF;
2686:

Line 2691: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2687: WHEN OTHERS THEN
2688: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2689:
2690: -- reset Global variable
2691: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2692: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2693:
2694: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2695: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2692: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2688: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2689:
2690: -- reset Global variable
2691: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2692: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2693:
2694: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2695: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2696: FND_MSG_PUB.ADD;

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

2706: p_data => x_msg_data);
2707:
2708: -- Debug info.
2709: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2710: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2711: p_msg_data=>x_msg_data,
2712: p_msg_type=>'SQL ERROR',
2713: p_msg_level=>fnd_log.level_error);
2714: END IF;

Line 2716: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',

2712: p_msg_type=>'SQL ERROR',
2713: p_msg_level=>fnd_log.level_error);
2714: END IF;
2715: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2716: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2717: p_prefix=>l_debug_prefix,
2718: p_msg_level=>fnd_log.level_procedure);
2719: END IF;
2720: END do_update_cust_acct_v2_bo;

Line 2759: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(+)',

2755: END IF;
2756:
2757: -- Debug info.
2758: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2759: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(+)',
2760: p_prefix=>l_debug_prefix,
2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;
2763:

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

2818: END IF;
2819:
2820: -- Debug info.
2821: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2822: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2823: p_msg_data=>x_msg_data,
2824: p_msg_type=>'WARNING',
2825: p_msg_level=>fnd_log.level_exception);
2826: END IF;

Line 2828: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',

2824: p_msg_type=>'WARNING',
2825: p_msg_level=>fnd_log.level_exception);
2826: END IF;
2827: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2828: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2829: p_prefix=>l_debug_prefix,
2830: p_msg_level=>fnd_log.level_procedure);
2831: END IF;
2832:

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

2841: p_data => x_msg_data);
2842:
2843: -- Debug info.
2844: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2845: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2846: p_msg_data=>x_msg_data,
2847: p_msg_type=>'ERROR',
2848: p_msg_level=>fnd_log.level_error);
2849: END IF;

Line 2851: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',

2847: p_msg_type=>'ERROR',
2848: p_msg_level=>fnd_log.level_error);
2849: END IF;
2850: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2851: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2852: p_prefix=>l_debug_prefix,
2853: p_msg_level=>fnd_log.level_procedure);
2854: END IF;
2855: WHEN fnd_api.g_exc_unexpected_error THEN

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

2860: p_data => x_msg_data);
2861:
2862: -- Debug info.
2863: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2864: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2865: p_msg_data=>x_msg_data,
2866: p_msg_type=>'UNEXPECTED ERROR',
2867: p_msg_level=>fnd_log.level_error);
2868: END IF;

Line 2870: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',

2866: p_msg_type=>'UNEXPECTED ERROR',
2867: p_msg_level=>fnd_log.level_error);
2868: END IF;
2869: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2870: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2871: p_prefix=>l_debug_prefix,
2872: p_msg_level=>fnd_log.level_procedure);
2873: END IF;
2874: WHEN OTHERS THEN

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

2883: p_data => x_msg_data);
2884:
2885: -- Debug info.
2886: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2887: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2888: p_msg_data=>x_msg_data,
2889: p_msg_type=>'SQL ERROR',
2890: p_msg_level=>fnd_log.level_error);
2891: END IF;

Line 2893: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',

2889: p_msg_type=>'SQL ERROR',
2890: p_msg_level=>fnd_log.level_error);
2891: END IF;
2892: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2893: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2894: p_prefix=>l_debug_prefix,
2895: p_msg_level=>fnd_log.level_procedure);
2896: END IF;
2897: END do_save_cust_acct_v2_bo;

Line 3034: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo(+)',

3030:
3031:
3032: -- Debug info.
3033: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3034: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo(+)',
3035: p_prefix=>l_debug_prefix,
3036: p_msg_level=>fnd_log.level_procedure);
3037: END IF;
3038:

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

3074:
3075:
3076: -- Debug info.
3077: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3078: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3079: p_msg_data=>x_msg_data,
3080: p_msg_type=>'WARNING',
3081: p_msg_level=>fnd_log.level_exception);
3082: END IF;

Line 3086: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',

3082: END IF;
3083:
3084: -- Debug info.
3085: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3086: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3087: p_prefix=>l_debug_prefix,
3088: p_msg_level=>fnd_log.level_procedure);
3089: END IF;
3090:

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

3099: p_data => x_msg_data);
3100:
3101: -- Debug info.
3102: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3103: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3104: p_msg_data=>x_msg_data,
3105: p_msg_type=>'ERROR',
3106: p_msg_level=>fnd_log.level_error);
3107: END IF;

Line 3109: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',

3105: p_msg_type=>'ERROR',
3106: p_msg_level=>fnd_log.level_error);
3107: END IF;
3108: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3109: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3110: p_prefix=>l_debug_prefix,
3111: p_msg_level=>fnd_log.level_procedure);
3112: END IF;
3113: WHEN fnd_api.g_exc_unexpected_error THEN

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

3118: p_data => x_msg_data);
3119:
3120: -- Debug info.
3121: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3122: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3123: p_msg_data=>x_msg_data,
3124: p_msg_type=>'UNEXPECTED ERROR',
3125: p_msg_level=>fnd_log.level_error);
3126: END IF;

Line 3128: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',

3124: p_msg_type=>'UNEXPECTED ERROR',
3125: p_msg_level=>fnd_log.level_error);
3126: END IF;
3127: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3128: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3129: p_prefix=>l_debug_prefix,
3130: p_msg_level=>fnd_log.level_procedure);
3131: END IF;
3132: WHEN OTHERS THEN

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

3141: p_data => x_msg_data);
3142:
3143: -- Debug info.
3144: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3145: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3146: p_msg_data=>x_msg_data,
3147: p_msg_type=>'SQL ERROR',
3148: p_msg_level=>fnd_log.level_error);
3149: END IF;

Line 3151: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',

3147: p_msg_type=>'SQL ERROR',
3148: p_msg_level=>fnd_log.level_error);
3149: END IF;
3150: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3151: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3152: p_prefix=>l_debug_prefix,
3153: p_msg_level=>fnd_log.level_procedure);
3154: END IF;
3155: