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 363: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';

359: FND_MSG_PUB.initialize;
360: END IF;
361:
362: -- initialize Global variable
363: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
364: IF(p_created_by_module IS NULL) THEN
365: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
366: ELSE
367: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

361:
362: -- initialize Global variable
363: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
364: IF(p_created_by_module IS NULL) THEN
365: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
366: ELSE
367: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
368: END IF;
369:

Line 367: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

363: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
364: IF(p_created_by_module IS NULL) THEN
365: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
366: ELSE
367: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
368: END IF;
369:
370: -- Debug info.
371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

368: END IF;
369:
370: -- Debug info.
371: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
372: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(+)',
373: p_prefix=>l_debug_prefix,
374: p_msg_level=>fnd_log.level_procedure);
375: END IF;
376:

Line 543: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

539: RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: END IF;
542:
543: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
544:
545: -------------------------------------
546: -- Call cust account contact
547: -------------------------------------

Line 570: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

566: RAISE FND_API.G_EXC_ERROR;
567: END IF;
568: END IF;
569:
570: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
571:
572: -------------------------------------
573: -- Call cust account site
574: -------------------------------------

Line 596: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

592: RAISE FND_API.G_EXC_ERROR;
593: END IF;
594: END IF;
595:
596: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
597:
598: ------------------------
599: -- Call bank account use
600: ------------------------

Line 637: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

633: END IF;
634: END IF;
635:
636: -- reset Global variable
637: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
638: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
639:
640: -- Debug info.
641: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 638: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

634: END IF;
635:
636: -- reset Global variable
637: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
638: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
639:
640: -- Debug info.
641: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

638: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
639:
640: -- Debug info.
641: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
642: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
643: p_msg_data=>x_msg_data,
644: p_msg_type=>'WARNING',
645: p_msg_level=>fnd_log.level_exception);
646: END IF;

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

644: p_msg_type=>'WARNING',
645: p_msg_level=>fnd_log.level_exception);
646: END IF;
647: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
648: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
649: p_prefix=>l_debug_prefix,
650: p_msg_level=>fnd_log.level_procedure);
651: END IF;
652:

Line 658: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

654: WHEN fnd_api.g_exc_error THEN
655: ROLLBACK TO do_create_cust_acct_bo_pub;
656:
657: -- reset Global variable
658: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
659: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
660:
661: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
662: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 659: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

655: ROLLBACK TO do_create_cust_acct_bo_pub;
656:
657: -- reset Global variable
658: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
659: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
660:
661: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
662: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
663: FND_MSG_PUB.ADD;

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

669: p_data => x_msg_data);
670:
671: -- Debug info.
672: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
673: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
674: p_msg_data=>x_msg_data,
675: p_msg_type=>'ERROR',
676: p_msg_level=>fnd_log.level_error);
677: END IF;

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

675: p_msg_type=>'ERROR',
676: p_msg_level=>fnd_log.level_error);
677: END IF;
678: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
679: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
680: p_prefix=>l_debug_prefix,
681: p_msg_level=>fnd_log.level_procedure);
682: END IF;
683:

Line 688: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

684: WHEN fnd_api.g_exc_unexpected_error THEN
685: ROLLBACK TO do_create_cust_acct_bo_pub;
686:
687: -- reset Global variable
688: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
689: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
690:
691: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
692: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 689: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

685: ROLLBACK TO do_create_cust_acct_bo_pub;
686:
687: -- reset Global variable
688: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
689: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
690:
691: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
692: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
693: FND_MSG_PUB.ADD;

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

699: p_data => x_msg_data);
700:
701: -- Debug info.
702: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
703: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
704: p_msg_data=>x_msg_data,
705: p_msg_type=>'UNEXPECTED ERROR',
706: p_msg_level=>fnd_log.level_error);
707: END IF;

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

705: p_msg_type=>'UNEXPECTED ERROR',
706: p_msg_level=>fnd_log.level_error);
707: END IF;
708: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
709: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
710: p_prefix=>l_debug_prefix,
711: p_msg_level=>fnd_log.level_procedure);
712: END IF;
713:

Line 718: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

714: WHEN OTHERS THEN
715: ROLLBACK TO do_create_cust_acct_bo_pub;
716:
717: -- reset Global variable
718: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
719: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
720:
721: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
722: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 719: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

715: ROLLBACK TO do_create_cust_acct_bo_pub;
716:
717: -- reset Global variable
718: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
719: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
720:
721: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
722: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
723: FND_MSG_PUB.ADD;

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

733: p_data => x_msg_data);
734:
735: -- Debug info.
736: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
737: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
738: p_msg_data=>x_msg_data,
739: p_msg_type=>'SQL ERROR',
740: p_msg_level=>fnd_log.level_error);
741: END IF;

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

739: p_msg_type=>'SQL ERROR',
740: p_msg_level=>fnd_log.level_error);
741: END IF;
742: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
743: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_bo(-)',
744: p_prefix=>l_debug_prefix,
745: p_msg_level=>fnd_log.level_procedure);
746: END IF;
747: END do_create_cust_acct_bo;

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

944: FND_MSG_PUB.initialize;
945: END IF;
946:
947: -- initialize Global variable
948: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
949: IF(p_created_by_module IS NULL) THEN
950: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
951: ELSE
952: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

946:
947: -- initialize Global variable
948: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
949: IF(p_created_by_module IS NULL) THEN
950: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
951: ELSE
952: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
953: END IF;
954:

Line 952: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

948: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
949: IF(p_created_by_module IS NULL) THEN
950: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
951: ELSE
952: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
953: END IF;
954:
955: -- Debug info.
956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

953: END IF;
954:
955: -- Debug info.
956: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
957: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo_pub(+)',
958: p_prefix=>l_debug_prefix,
959: p_msg_level=>fnd_log.level_procedure);
960: END IF;
961:

Line 1053: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

1049: END IF;
1050: END IF;
1051: END IF;
1052:
1053: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1054:
1055: -----------------------------------
1056: -- For cust account contact
1057: -----------------------------------

Line 1078: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1074: RAISE FND_API.G_EXC_ERROR;
1075: END IF;
1076: END IF;
1077:
1078: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1079:
1080: -------------------------------
1081: -- For Update account acct relate
1082: -------------------------------

Line 1122: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;
1120: END IF;
1121:
1122: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
1123:
1124: ------------------------
1125: -- Call bank account use
1126: ------------------------

Line 1163: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1159: END IF;
1160: END IF;
1161:
1162: -- reset Global variable
1163: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1164: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1165:
1166: -- Debug info.
1167: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 1164: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1160: END IF;
1161:
1162: -- reset Global variable
1163: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1164: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1165:
1166: -- Debug info.
1167: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1168: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

1164: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1165:
1166: -- Debug info.
1167: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1168: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1169: p_msg_data=>x_msg_data,
1170: p_msg_type=>'WARNING',
1171: p_msg_level=>fnd_log.level_exception);
1172: END IF;

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

1170: p_msg_type=>'WARNING',
1171: p_msg_level=>fnd_log.level_exception);
1172: END IF;
1173: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1174: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1175: p_prefix=>l_debug_prefix,
1176: p_msg_level=>fnd_log.level_procedure);
1177: END IF;
1178: EXCEPTION

Line 1183: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1179: WHEN fnd_api.g_exc_error THEN
1180: ROLLBACK TO do_update_cust_acct_bo_pub;
1181:
1182: -- reset Global variable
1183: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1184: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1185:
1186: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1187: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 1184: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1180: ROLLBACK TO do_update_cust_acct_bo_pub;
1181:
1182: -- reset Global variable
1183: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1184: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1185:
1186: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1187: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1188: FND_MSG_PUB.ADD;

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

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

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

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

Line 1213: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1209: WHEN fnd_api.g_exc_unexpected_error THEN
1210: ROLLBACK TO do_update_cust_acct_bo_pub;
1211:
1212: -- reset Global variable
1213: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1214: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1215:
1216: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1217: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 1214: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1210: ROLLBACK TO do_update_cust_acct_bo_pub;
1211:
1212: -- reset Global variable
1213: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1214: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1215:
1216: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1217: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1218: FND_MSG_PUB.ADD;

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

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

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

1230: p_msg_type=>'UNEXPECTED ERROR',
1231: p_msg_level=>fnd_log.level_error);
1232: END IF;
1233: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1234: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1235: p_prefix=>l_debug_prefix,
1236: p_msg_level=>fnd_log.level_procedure);
1237: END IF;
1238:

Line 1243: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

1239: WHEN OTHERS THEN
1240: ROLLBACK TO do_update_cust_acct_bo_pub;
1241:
1242: -- reset Global variable
1243: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1244: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1245:
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1247: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 1244: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

1240: ROLLBACK TO do_update_cust_acct_bo_pub;
1241:
1242: -- reset Global variable
1243: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
1244: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
1245:
1246: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
1247: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
1248: FND_MSG_PUB.ADD;

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

1258: p_data => x_msg_data);
1259:
1260: -- Debug info.
1261: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1262: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1263: p_msg_data=>x_msg_data,
1264: p_msg_type=>'SQL ERROR',
1265: p_msg_level=>fnd_log.level_error);
1266: END IF;

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

1264: p_msg_type=>'SQL ERROR',
1265: p_msg_level=>fnd_log.level_error);
1266: END IF;
1267: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1268: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_bo(-)',
1269: p_prefix=>l_debug_prefix,
1270: p_msg_level=>fnd_log.level_procedure);
1271: END IF;
1272: END do_update_cust_acct_bo;

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

1307: END IF;
1308:
1309: -- Debug info.
1310: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1311: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(+)',
1312: p_prefix=>l_debug_prefix,
1313: p_msg_level=>fnd_log.level_procedure);
1314: END IF;
1315:

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

1370: END IF;
1371:
1372: -- Debug info.
1373: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1374: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1375: p_msg_data=>x_msg_data,
1376: p_msg_type=>'WARNING',
1377: p_msg_level=>fnd_log.level_exception);
1378: END IF;

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

1376: p_msg_type=>'WARNING',
1377: p_msg_level=>fnd_log.level_exception);
1378: END IF;
1379: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1380: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1381: p_prefix=>l_debug_prefix,
1382: p_msg_level=>fnd_log.level_procedure);
1383: END IF;
1384:

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

1393: p_data => x_msg_data);
1394:
1395: -- Debug info.
1396: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1397: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1398: p_msg_data=>x_msg_data,
1399: p_msg_type=>'ERROR',
1400: p_msg_level=>fnd_log.level_error);
1401: END IF;

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

1399: p_msg_type=>'ERROR',
1400: p_msg_level=>fnd_log.level_error);
1401: END IF;
1402: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1403: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1404: p_prefix=>l_debug_prefix,
1405: p_msg_level=>fnd_log.level_procedure);
1406: END IF;
1407: WHEN fnd_api.g_exc_unexpected_error THEN

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

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

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

1418: p_msg_type=>'UNEXPECTED ERROR',
1419: p_msg_level=>fnd_log.level_error);
1420: END IF;
1421: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1422: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1423: p_prefix=>l_debug_prefix,
1424: p_msg_level=>fnd_log.level_procedure);
1425: END IF;
1426: WHEN OTHERS THEN

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

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

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

1441: p_msg_type=>'SQL ERROR',
1442: p_msg_level=>fnd_log.level_error);
1443: END IF;
1444: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1445: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_bo(-)',
1446: p_prefix=>l_debug_prefix,
1447: p_msg_level=>fnd_log.level_procedure);
1448: END IF;
1449: END do_save_cust_acct_bo;

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

1619:
1620:
1621: -- Debug info.
1622: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1623: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo(+)',
1624: p_prefix=>l_debug_prefix,
1625: p_msg_level=>fnd_log.level_procedure);
1626: END IF;
1627:

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

1663:
1664:
1665: -- Debug info.
1666: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1667: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1668: p_msg_data=>x_msg_data,
1669: p_msg_type=>'WARNING',
1670: p_msg_level=>fnd_log.level_exception);
1671: END IF;

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

1671: END IF;
1672:
1673: -- Debug info.
1674: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1675: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1676: p_prefix=>l_debug_prefix,
1677: p_msg_level=>fnd_log.level_procedure);
1678: END IF;
1679:

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

1688: p_data => x_msg_data);
1689:
1690: -- Debug info.
1691: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1692: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1693: p_msg_data=>x_msg_data,
1694: p_msg_type=>'ERROR',
1695: p_msg_level=>fnd_log.level_error);
1696: END IF;

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

1694: p_msg_type=>'ERROR',
1695: p_msg_level=>fnd_log.level_error);
1696: END IF;
1697: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1698: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1699: p_prefix=>l_debug_prefix,
1700: p_msg_level=>fnd_log.level_procedure);
1701: END IF;
1702: WHEN fnd_api.g_exc_unexpected_error THEN

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

1707: p_data => x_msg_data);
1708:
1709: -- Debug info.
1710: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1711: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1712: p_msg_data=>x_msg_data,
1713: p_msg_type=>'UNEXPECTED ERROR',
1714: p_msg_level=>fnd_log.level_error);
1715: END IF;

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

1713: p_msg_type=>'UNEXPECTED ERROR',
1714: p_msg_level=>fnd_log.level_error);
1715: END IF;
1716: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1717: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1718: p_prefix=>l_debug_prefix,
1719: p_msg_level=>fnd_log.level_procedure);
1720: END IF;
1721: WHEN OTHERS THEN

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

1730: p_data => x_msg_data);
1731:
1732: -- Debug info.
1733: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1734: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1735: p_msg_data=>x_msg_data,
1736: p_msg_type=>'SQL ERROR',
1737: p_msg_level=>fnd_log.level_error);
1738: END IF;

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

1736: p_msg_type=>'SQL ERROR',
1737: p_msg_level=>fnd_log.level_error);
1738: END IF;
1739: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1740: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_bo (-)',
1741: p_prefix=>l_debug_prefix,
1742: p_msg_level=>fnd_log.level_procedure);
1743: END IF;
1744:

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

1912: px_cust_acct_rec.selling_party_id := p_cust_acct_v2_obj.selling_party_id;
1913: IF(p_create_or_update = 'C') THEN
1914: px_cust_acct_rec.orig_system := p_cust_acct_os;
1915: px_cust_acct_rec.orig_system_reference := p_cust_acct_osr;
1916: px_cust_acct_rec.created_by_module := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
1917: END IF;
1918: px_cust_acct_rec.attribute_category := p_cust_acct_v2_obj.attribute_category;
1919: px_cust_acct_rec.attribute1 := p_cust_acct_v2_obj.attribute1;
1920: px_cust_acct_rec.attribute2 := p_cust_acct_v2_obj.attribute2;

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

2012: FND_MSG_PUB.initialize;
2013: END IF;
2014:
2015: -- initialize Global variable
2016: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2017: IF(p_created_by_module IS NULL) THEN
2018: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2019: ELSE
2020: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

2014:
2015: -- initialize Global variable
2016: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2017: IF(p_created_by_module IS NULL) THEN
2018: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2019: ELSE
2020: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2021: END IF;
2022:

Line 2020: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

2016: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2017: IF(p_created_by_module IS NULL) THEN
2018: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2019: ELSE
2020: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2021: END IF;
2022:
2023: -- Debug info.
2024: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

2021: END IF;
2022:
2023: -- Debug info.
2024: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2025: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(+)',
2026: p_prefix=>l_debug_prefix,
2027: p_msg_level=>fnd_log.level_procedure);
2028: END IF;
2029:

Line 2188: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2184: RAISE FND_API.G_EXC_ERROR;
2185: END IF;
2186: END IF;
2187:
2188: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2189:
2190: -------------------------------------
2191: -- Call cust account contact
2192: -------------------------------------

Line 2215: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2211: RAISE FND_API.G_EXC_ERROR;
2212: END IF;
2213: END IF;
2214:
2215: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2216:
2217: -------------------------------------
2218: -- Call cust account site
2219: -------------------------------------

Line 2241: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2237: RAISE FND_API.G_EXC_ERROR;
2238: END IF;
2239: END IF;
2240:
2241: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2242:
2243: ------------------------
2244: -- Call bank account use
2245: ------------------------

Line 2283: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2279: END IF;
2280: END IF;
2281:
2282: -- reset Global variable
2283: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2284: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2285:
2286: -- Debug info.
2287: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2284: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2280: END IF;
2281:
2282: -- reset Global variable
2283: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2284: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2285:
2286: -- Debug info.
2287: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2288: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

2284: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2285:
2286: -- Debug info.
2287: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2288: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2289: p_msg_data=>x_msg_data,
2290: p_msg_type=>'WARNING',
2291: p_msg_level=>fnd_log.level_exception);
2292: END IF;

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

2290: p_msg_type=>'WARNING',
2291: p_msg_level=>fnd_log.level_exception);
2292: END IF;
2293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2294: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2295: p_prefix=>l_debug_prefix,
2296: p_msg_level=>fnd_log.level_procedure);
2297: END IF;
2298:

Line 2304: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2300: WHEN fnd_api.g_exc_error THEN
2301: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2302:
2303: -- reset Global variable
2304: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2305: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2306:
2307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2308: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2305: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2301: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2302:
2303: -- reset Global variable
2304: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2305: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2306:
2307: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2308: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2309: FND_MSG_PUB.ADD;

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

2315: p_data => x_msg_data);
2316:
2317: -- Debug info.
2318: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2319: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2320: p_msg_data=>x_msg_data,
2321: p_msg_type=>'ERROR',
2322: p_msg_level=>fnd_log.level_error);
2323: END IF;

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

2321: p_msg_type=>'ERROR',
2322: p_msg_level=>fnd_log.level_error);
2323: END IF;
2324: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2325: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2326: p_prefix=>l_debug_prefix,
2327: p_msg_level=>fnd_log.level_procedure);
2328: END IF;
2329:

Line 2334: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2330: WHEN fnd_api.g_exc_unexpected_error THEN
2331: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2332:
2333: -- reset Global variable
2334: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2335: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2336:
2337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2338: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2335: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2331: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2332:
2333: -- reset Global variable
2334: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2335: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2336:
2337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2338: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2339: FND_MSG_PUB.ADD;

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

2345: p_data => x_msg_data);
2346:
2347: -- Debug info.
2348: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2349: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2350: p_msg_data=>x_msg_data,
2351: p_msg_type=>'UNEXPECTED ERROR',
2352: p_msg_level=>fnd_log.level_error);
2353: END IF;

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

2351: p_msg_type=>'UNEXPECTED ERROR',
2352: p_msg_level=>fnd_log.level_error);
2353: END IF;
2354: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2355: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2356: p_prefix=>l_debug_prefix,
2357: p_msg_level=>fnd_log.level_procedure);
2358: END IF;
2359:

Line 2364: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2360: WHEN OTHERS THEN
2361: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2362:
2363: -- reset Global variable
2364: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2365: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2366:
2367: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2368: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2365: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2361: ROLLBACK TO do_create_cust_acct_v2_bo_pub;
2362:
2363: -- reset Global variable
2364: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2365: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2366:
2367: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2368: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2369: FND_MSG_PUB.ADD;

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

2379: p_data => x_msg_data);
2380:
2381: -- Debug info.
2382: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2383: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2384: p_msg_data=>x_msg_data,
2385: p_msg_type=>'SQL ERROR',
2386: p_msg_level=>fnd_log.level_error);
2387: END IF;

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

2385: p_msg_type=>'SQL ERROR',
2386: p_msg_level=>fnd_log.level_error);
2387: END IF;
2388: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2389: hz_utility_v2pub.debug(p_message=>'do_create_cust_acct_v2_bo(-)',
2390: p_prefix=>l_debug_prefix,
2391: p_msg_level=>fnd_log.level_procedure);
2392: END IF;
2393: END do_create_cust_acct_v2_bo;

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

2522: FND_MSG_PUB.initialize;
2523: END IF;
2524:
2525: -- initialize Global variable
2526: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2527: IF(p_created_by_module IS NULL) THEN
2528: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2529: ELSE
2530: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

2524:
2525: -- initialize Global variable
2526: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2527: IF(p_created_by_module IS NULL) THEN
2528: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2529: ELSE
2530: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2531: END IF;
2532:

Line 2530: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

2526: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2527: IF(p_created_by_module IS NULL) THEN
2528: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2529: ELSE
2530: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2531: END IF;
2532:
2533: -- Debug info.
2534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

2531: END IF;
2532:
2533: -- Debug info.
2534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2535: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo_pub(+)',
2536: p_prefix=>l_debug_prefix,
2537: p_msg_level=>fnd_log.level_procedure);
2538: END IF;
2539:

Line 2631: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2627: END IF;
2628: END IF;
2629: END IF;
2630:
2631: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2632:
2633: -----------------------------------
2634: -- For cust account contact
2635: -----------------------------------

Line 2656: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2652: RAISE FND_API.G_EXC_ERROR;
2653: END IF;
2654: END IF;
2655:
2656: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2657:
2658: -------------------------------
2659: -- For Update account acct relate
2660: -------------------------------

Line 2700: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2696: RAISE FND_API.G_EXC_ERROR;
2697: END IF;
2698: END IF;
2699:
2700: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2701:
2702: ------------------------
2703: -- Call bank account use
2704: ------------------------

Line 2742: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2738: END IF;
2739: END IF;
2740:
2741: -- reset Global variable
2742: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2743: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2744:
2745: -- Debug info.
2746: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 2743: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2739: END IF;
2740:
2741: -- reset Global variable
2742: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2743: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2744:
2745: -- Debug info.
2746: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2747: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

2743: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2744:
2745: -- Debug info.
2746: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2747: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2748: p_msg_data=>x_msg_data,
2749: p_msg_type=>'WARNING',
2750: p_msg_level=>fnd_log.level_exception);
2751: END IF;

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

2749: p_msg_type=>'WARNING',
2750: p_msg_level=>fnd_log.level_exception);
2751: END IF;
2752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2753: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2754: p_prefix=>l_debug_prefix,
2755: p_msg_level=>fnd_log.level_procedure);
2756: END IF;
2757: EXCEPTION

Line 2762: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2758: WHEN fnd_api.g_exc_error THEN
2759: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2760:
2761: -- reset Global variable
2762: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2763: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2764:
2765: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2766: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2763: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2759: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2760:
2761: -- reset Global variable
2762: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2763: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2764:
2765: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2766: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2767: FND_MSG_PUB.ADD;

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

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

2779: p_msg_type=>'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=>'do_update_cust_acct_v2_bo(-)',
2784: p_prefix=>l_debug_prefix,
2785: p_msg_level=>fnd_log.level_procedure);
2786: END IF;
2787:

Line 2792: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2788: WHEN fnd_api.g_exc_unexpected_error THEN
2789: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2790:
2791: -- reset Global variable
2792: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2793: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2794:
2795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2796: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2793: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2789: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2790:
2791: -- reset Global variable
2792: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2793: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2794:
2795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2796: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2797: FND_MSG_PUB.ADD;

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

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

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

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

Line 2822: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2818: WHEN OTHERS THEN
2819: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2820:
2821: -- reset Global variable
2822: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2823: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2824:
2825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2826: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');

Line 2823: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2819: ROLLBACK TO do_update_cust_acct_v2_bo_pub;
2820:
2821: -- reset Global variable
2822: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2823: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2824:
2825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2826: FND_MESSAGE.SET_TOKEN('OBJECT', 'CUST_ACCT');
2827: FND_MSG_PUB.ADD;

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

2837: p_data => x_msg_data);
2838:
2839: -- Debug info.
2840: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2841: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2842: p_msg_data=>x_msg_data,
2843: p_msg_type=>'SQL ERROR',
2844: p_msg_level=>fnd_log.level_error);
2845: END IF;

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

2843: p_msg_type=>'SQL ERROR',
2844: p_msg_level=>fnd_log.level_error);
2845: END IF;
2846: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2847: hz_utility_v2pub.debug(p_message=>'do_update_cust_acct_v2_bo(-)',
2848: p_prefix=>l_debug_prefix,
2849: p_msg_level=>fnd_log.level_procedure);
2850: END IF;
2851: END do_update_cust_acct_v2_bo;

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

2886: END IF;
2887:
2888: -- Debug info.
2889: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2890: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(+)',
2891: p_prefix=>l_debug_prefix,
2892: p_msg_level=>fnd_log.level_procedure);
2893: END IF;
2894:

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

2949: END IF;
2950:
2951: -- Debug info.
2952: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2954: p_msg_data=>x_msg_data,
2955: p_msg_type=>'WARNING',
2956: p_msg_level=>fnd_log.level_exception);
2957: END IF;

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

2955: p_msg_type=>'WARNING',
2956: p_msg_level=>fnd_log.level_exception);
2957: END IF;
2958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2959: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2960: p_prefix=>l_debug_prefix,
2961: p_msg_level=>fnd_log.level_procedure);
2962: END IF;
2963:

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

2972: p_data => x_msg_data);
2973:
2974: -- Debug info.
2975: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2976: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2977: p_msg_data=>x_msg_data,
2978: p_msg_type=>'ERROR',
2979: p_msg_level=>fnd_log.level_error);
2980: END IF;

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

2978: p_msg_type=>'ERROR',
2979: p_msg_level=>fnd_log.level_error);
2980: END IF;
2981: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2982: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
2983: p_prefix=>l_debug_prefix,
2984: p_msg_level=>fnd_log.level_procedure);
2985: END IF;
2986: WHEN fnd_api.g_exc_unexpected_error THEN

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

2991: p_data => x_msg_data);
2992:
2993: -- Debug info.
2994: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2995: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2996: p_msg_data=>x_msg_data,
2997: p_msg_type=>'UNEXPECTED ERROR',
2998: p_msg_level=>fnd_log.level_error);
2999: END IF;

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

2997: p_msg_type=>'UNEXPECTED ERROR',
2998: p_msg_level=>fnd_log.level_error);
2999: END IF;
3000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3001: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
3002: p_prefix=>l_debug_prefix,
3003: p_msg_level=>fnd_log.level_procedure);
3004: END IF;
3005: WHEN OTHERS THEN

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

3014: p_data => x_msg_data);
3015:
3016: -- Debug info.
3017: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3018: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3019: p_msg_data=>x_msg_data,
3020: p_msg_type=>'SQL ERROR',
3021: p_msg_level=>fnd_log.level_error);
3022: END IF;

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

3020: p_msg_type=>'SQL ERROR',
3021: p_msg_level=>fnd_log.level_error);
3022: END IF;
3023: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3024: hz_utility_v2pub.debug(p_message=>'do_save_cust_acct_v2_bo(-)',
3025: p_prefix=>l_debug_prefix,
3026: p_msg_level=>fnd_log.level_procedure);
3027: END IF;
3028: END do_save_cust_acct_v2_bo;

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

3161:
3162:
3163: -- Debug info.
3164: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3165: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo(+)',
3166: p_prefix=>l_debug_prefix,
3167: p_msg_level=>fnd_log.level_procedure);
3168: END IF;
3169:

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

3205:
3206:
3207: -- Debug info.
3208: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3209: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3210: p_msg_data=>x_msg_data,
3211: p_msg_type=>'WARNING',
3212: p_msg_level=>fnd_log.level_exception);
3213: END IF;

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

3213: END IF;
3214:
3215: -- Debug info.
3216: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3217: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3218: p_prefix=>l_debug_prefix,
3219: p_msg_level=>fnd_log.level_procedure);
3220: END IF;
3221:

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

3230: p_data => x_msg_data);
3231:
3232: -- Debug info.
3233: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3234: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3235: p_msg_data=>x_msg_data,
3236: p_msg_type=>'ERROR',
3237: p_msg_level=>fnd_log.level_error);
3238: END IF;

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

3236: p_msg_type=>'ERROR',
3237: p_msg_level=>fnd_log.level_error);
3238: END IF;
3239: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3240: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3241: p_prefix=>l_debug_prefix,
3242: p_msg_level=>fnd_log.level_procedure);
3243: END IF;
3244: WHEN fnd_api.g_exc_unexpected_error THEN

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

3249: p_data => x_msg_data);
3250:
3251: -- Debug info.
3252: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3253: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3254: p_msg_data=>x_msg_data,
3255: p_msg_type=>'UNEXPECTED ERROR',
3256: p_msg_level=>fnd_log.level_error);
3257: END IF;

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

3255: p_msg_type=>'UNEXPECTED ERROR',
3256: p_msg_level=>fnd_log.level_error);
3257: END IF;
3258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3259: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3260: p_prefix=>l_debug_prefix,
3261: p_msg_level=>fnd_log.level_procedure);
3262: END IF;
3263: WHEN OTHERS THEN

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

3272: p_data => x_msg_data);
3273:
3274: -- Debug info.
3275: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3276: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3277: p_msg_data=>x_msg_data,
3278: p_msg_type=>'SQL ERROR',
3279: p_msg_level=>fnd_log.level_error);
3280: END IF;

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

3278: p_msg_type=>'SQL ERROR',
3279: p_msg_level=>fnd_log.level_error);
3280: END IF;
3281: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3282: hz_utility_v2pub.debug(p_message=>'hz_cust_acct_bo_pub.get_cust_acct_v2_bo (-)',
3283: p_prefix=>l_debug_prefix,
3284: p_msg_level=>fnd_log.level_procedure);
3285: END IF;
3286: