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

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

119: END IF;
120:
121:
122: -- Debug info.
123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
124: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo(+)',
125: p_prefix=>l_debug_prefix,
126: p_msg_level=>fnd_log.level_procedure);
127: END IF;

Line 126: p_msg_level=>fnd_log.level_procedure);

122: -- Debug info.
123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
124: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo(+)',
125: p_prefix=>l_debug_prefix,
126: p_msg_level=>fnd_log.level_procedure);
127: END IF;
128:
129: open c1;
130: fetch c1 bulk collect into x_cust_acct_relate_objs;

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

130: fetch c1 bulk collect into x_cust_acct_relate_objs;
131: close c1;
132:
133: -- Debug info.
134: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
135: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
136: p_msg_data=>x_msg_data,
137: p_msg_type=>'WARNING',
138: p_msg_level=>fnd_log.level_exception);

Line 138: p_msg_level=>fnd_log.level_exception);

134: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
135: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
136: p_msg_data=>x_msg_data,
137: p_msg_type=>'WARNING',
138: p_msg_level=>fnd_log.level_exception);
139: END IF;
140:
141: -- Debug info.
142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

138: p_msg_level=>fnd_log.level_exception);
139: END IF;
140:
141: -- Debug info.
142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
143: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
144: p_prefix=>l_debug_prefix,
145: p_msg_level=>fnd_log.level_procedure);
146: END IF;

Line 145: p_msg_level=>fnd_log.level_procedure);

141: -- Debug info.
142: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
143: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
144: p_prefix=>l_debug_prefix,
145: p_msg_level=>fnd_log.level_procedure);
146: END IF;
147:
148:
149: EXCEPTION

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

155: p_count => x_msg_count,
156: p_data => x_msg_data);
157:
158: -- Debug info.
159: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
160: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
161: p_msg_data=>x_msg_data,
162: p_msg_type=>'ERROR',
163: p_msg_level=>fnd_log.level_error);

Line 163: p_msg_level=>fnd_log.level_error);

159: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
160: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
161: p_msg_data=>x_msg_data,
162: p_msg_type=>'ERROR',
163: p_msg_level=>fnd_log.level_error);
164: END IF;
165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
167: p_prefix=>l_debug_prefix,

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

161: p_msg_data=>x_msg_data,
162: p_msg_type=>'ERROR',
163: p_msg_level=>fnd_log.level_error);
164: END IF;
165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
167: p_prefix=>l_debug_prefix,
168: p_msg_level=>fnd_log.level_procedure);
169: END IF;

Line 168: p_msg_level=>fnd_log.level_procedure);

164: END IF;
165: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
166: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
167: p_prefix=>l_debug_prefix,
168: p_msg_level=>fnd_log.level_procedure);
169: END IF;
170: WHEN fnd_api.g_exc_unexpected_error THEN
171: x_return_status := fnd_api.g_ret_sts_unexp_error;
172:

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

174: p_count => x_msg_count,
175: p_data => x_msg_data);
176:
177: -- Debug info.
178: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
179: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
180: p_msg_data=>x_msg_data,
181: p_msg_type=>'UNEXPECTED ERROR',
182: p_msg_level=>fnd_log.level_error);

Line 182: p_msg_level=>fnd_log.level_error);

178: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
179: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
180: p_msg_data=>x_msg_data,
181: p_msg_type=>'UNEXPECTED ERROR',
182: p_msg_level=>fnd_log.level_error);
183: END IF;
184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
185: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
186: p_prefix=>l_debug_prefix,

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

180: p_msg_data=>x_msg_data,
181: p_msg_type=>'UNEXPECTED ERROR',
182: p_msg_level=>fnd_log.level_error);
183: END IF;
184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
185: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
186: p_prefix=>l_debug_prefix,
187: p_msg_level=>fnd_log.level_procedure);
188: END IF;

Line 187: p_msg_level=>fnd_log.level_procedure);

183: END IF;
184: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
185: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
186: p_prefix=>l_debug_prefix,
187: p_msg_level=>fnd_log.level_procedure);
188: END IF;
189: WHEN OTHERS THEN
190: x_return_status := fnd_api.g_ret_sts_unexp_error;
191:

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

197: p_count => x_msg_count,
198: p_data => x_msg_data);
199:
200: -- Debug info.
201: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
203: p_msg_data=>x_msg_data,
204: p_msg_type=>'SQL ERROR',
205: p_msg_level=>fnd_log.level_error);

Line 205: p_msg_level=>fnd_log.level_error);

201: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
202: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
203: p_msg_data=>x_msg_data,
204: p_msg_type=>'SQL ERROR',
205: p_msg_level=>fnd_log.level_error);
206: END IF;
207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
209: p_prefix=>l_debug_prefix,

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

203: p_msg_data=>x_msg_data,
204: p_msg_type=>'SQL ERROR',
205: p_msg_level=>fnd_log.level_error);
206: END IF;
207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
209: p_prefix=>l_debug_prefix,
210: p_msg_level=>fnd_log.level_procedure);
211: END IF;

Line 210: p_msg_level=>fnd_log.level_procedure);

206: END IF;
207: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
208: hz_utility_v2pub.debug(p_message=>'get_cust_acct_relate_bo (-)',
209: p_prefix=>l_debug_prefix,
210: p_msg_level=>fnd_log.level_procedure);
211: END IF;
212:
213: end;
214:

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

449: END IF;
450:
451:
452: -- Debug info.
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo(+)',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;

Line 456: p_msg_level=>fnd_log.level_procedure);

452: -- Debug info.
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo(+)',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:
459: open c1;
460: fetch c1 into x_cust_profile_obj;

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

460: fetch c1 into x_cust_profile_obj;
461: close c1;
462:
463: -- Debug info.
464: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
466: p_msg_data=>x_msg_data,
467: p_msg_type=>'WARNING',
468: p_msg_level=>fnd_log.level_exception);

Line 468: p_msg_level=>fnd_log.level_exception);

464: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
466: p_msg_data=>x_msg_data,
467: p_msg_type=>'WARNING',
468: p_msg_level=>fnd_log.level_exception);
469: END IF;
470:
471: -- Debug info.
472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

468: p_msg_level=>fnd_log.level_exception);
469: END IF;
470:
471: -- Debug info.
472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
473: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
474: p_prefix=>l_debug_prefix,
475: p_msg_level=>fnd_log.level_procedure);
476: END IF;

Line 475: p_msg_level=>fnd_log.level_procedure);

471: -- Debug info.
472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
473: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
474: p_prefix=>l_debug_prefix,
475: p_msg_level=>fnd_log.level_procedure);
476: END IF;
477:
478:
479: EXCEPTION

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

485: p_count => x_msg_count,
486: p_data => x_msg_data);
487:
488: -- Debug info.
489: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
490: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
491: p_msg_data=>x_msg_data,
492: p_msg_type=>'ERROR',
493: p_msg_level=>fnd_log.level_error);

Line 493: p_msg_level=>fnd_log.level_error);

489: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
490: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
491: p_msg_data=>x_msg_data,
492: p_msg_type=>'ERROR',
493: p_msg_level=>fnd_log.level_error);
494: END IF;
495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
496: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
497: p_prefix=>l_debug_prefix,

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

491: p_msg_data=>x_msg_data,
492: p_msg_type=>'ERROR',
493: p_msg_level=>fnd_log.level_error);
494: END IF;
495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
496: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
497: p_prefix=>l_debug_prefix,
498: p_msg_level=>fnd_log.level_procedure);
499: END IF;

Line 498: p_msg_level=>fnd_log.level_procedure);

494: END IF;
495: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
496: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
497: p_prefix=>l_debug_prefix,
498: p_msg_level=>fnd_log.level_procedure);
499: END IF;
500: WHEN fnd_api.g_exc_unexpected_error THEN
501: x_return_status := fnd_api.g_ret_sts_unexp_error;
502:

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

504: p_count => x_msg_count,
505: p_data => x_msg_data);
506:
507: -- Debug info.
508: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
509: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
510: p_msg_data=>x_msg_data,
511: p_msg_type=>'UNEXPECTED ERROR',
512: p_msg_level=>fnd_log.level_error);

Line 512: p_msg_level=>fnd_log.level_error);

508: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
509: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
510: p_msg_data=>x_msg_data,
511: p_msg_type=>'UNEXPECTED ERROR',
512: p_msg_level=>fnd_log.level_error);
513: END IF;
514: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
515: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
516: p_prefix=>l_debug_prefix,

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

510: p_msg_data=>x_msg_data,
511: p_msg_type=>'UNEXPECTED ERROR',
512: p_msg_level=>fnd_log.level_error);
513: END IF;
514: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
515: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
516: p_prefix=>l_debug_prefix,
517: p_msg_level=>fnd_log.level_procedure);
518: END IF;

Line 517: p_msg_level=>fnd_log.level_procedure);

513: END IF;
514: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
515: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
516: p_prefix=>l_debug_prefix,
517: p_msg_level=>fnd_log.level_procedure);
518: END IF;
519: WHEN OTHERS THEN
520: x_return_status := fnd_api.g_ret_sts_unexp_error;
521:

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

527: p_count => x_msg_count,
528: p_data => x_msg_data);
529:
530: -- Debug info.
531: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
532: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
533: p_msg_data=>x_msg_data,
534: p_msg_type=>'SQL ERROR',
535: p_msg_level=>fnd_log.level_error);

Line 535: p_msg_level=>fnd_log.level_error);

531: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
532: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
533: p_msg_data=>x_msg_data,
534: p_msg_type=>'SQL ERROR',
535: p_msg_level=>fnd_log.level_error);
536: END IF;
537: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
538: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
539: p_prefix=>l_debug_prefix,

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

533: p_msg_data=>x_msg_data,
534: p_msg_type=>'SQL ERROR',
535: p_msg_level=>fnd_log.level_error);
536: END IF;
537: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
538: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
539: p_prefix=>l_debug_prefix,
540: p_msg_level=>fnd_log.level_procedure);
541: END IF;

Line 540: p_msg_level=>fnd_log.level_procedure);

536: END IF;
537: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
538: hz_utility_v2pub.debug(p_message=>'get_cust_profile_bo (-)',
539: p_prefix=>l_debug_prefix,
540: p_msg_level=>fnd_log.level_procedure);
541: END IF;
542:
543: end;
544:

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

852: END IF;
853:
854:
855: -- Debug info.
856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos(+)',
858: p_prefix=>l_debug_prefix,
859: p_msg_level=>fnd_log.level_procedure);
860: END IF;

Line 859: p_msg_level=>fnd_log.level_procedure);

855: -- Debug info.
856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos(+)',
858: p_prefix=>l_debug_prefix,
859: p_msg_level=>fnd_log.level_procedure);
860: END IF;
861:
862: x_cust_acct_objs := HZ_CUST_ACCT_BO_TBL();
863: open c1;

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

923:
924: end loop;
925:
926: -- Debug info.
927: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
928: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
929: p_msg_data=>x_msg_data,
930: p_msg_type=>'WARNING',
931: p_msg_level=>fnd_log.level_exception);

Line 931: p_msg_level=>fnd_log.level_exception);

927: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
928: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
929: p_msg_data=>x_msg_data,
930: p_msg_type=>'WARNING',
931: p_msg_level=>fnd_log.level_exception);
932: END IF;
933:
934: -- Debug info.
935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

931: p_msg_level=>fnd_log.level_exception);
932: END IF;
933:
934: -- Debug info.
935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
936: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
937: p_prefix=>l_debug_prefix,
938: p_msg_level=>fnd_log.level_procedure);
939: END IF;

Line 938: p_msg_level=>fnd_log.level_procedure);

934: -- Debug info.
935: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
936: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
937: p_prefix=>l_debug_prefix,
938: p_msg_level=>fnd_log.level_procedure);
939: END IF;
940:
941:
942: EXCEPTION

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

948: p_count => x_msg_count,
949: p_data => x_msg_data);
950:
951: -- Debug info.
952: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
954: p_msg_data=>x_msg_data,
955: p_msg_type=>'ERROR',
956: p_msg_level=>fnd_log.level_error);

Line 956: p_msg_level=>fnd_log.level_error);

952: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
953: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
954: p_msg_data=>x_msg_data,
955: p_msg_type=>'ERROR',
956: p_msg_level=>fnd_log.level_error);
957: END IF;
958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
959: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
960: p_prefix=>l_debug_prefix,

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

954: p_msg_data=>x_msg_data,
955: p_msg_type=>'ERROR',
956: p_msg_level=>fnd_log.level_error);
957: END IF;
958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
959: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
960: p_prefix=>l_debug_prefix,
961: p_msg_level=>fnd_log.level_procedure);
962: END IF;

Line 961: p_msg_level=>fnd_log.level_procedure);

957: END IF;
958: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
959: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
960: p_prefix=>l_debug_prefix,
961: p_msg_level=>fnd_log.level_procedure);
962: END IF;
963: WHEN fnd_api.g_exc_unexpected_error THEN
964: x_return_status := fnd_api.g_ret_sts_unexp_error;
965:

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

967: p_count => x_msg_count,
968: p_data => x_msg_data);
969:
970: -- Debug info.
971: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
972: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
973: p_msg_data=>x_msg_data,
974: p_msg_type=>'UNEXPECTED ERROR',
975: p_msg_level=>fnd_log.level_error);

Line 975: p_msg_level=>fnd_log.level_error);

971: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
972: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
973: p_msg_data=>x_msg_data,
974: p_msg_type=>'UNEXPECTED ERROR',
975: p_msg_level=>fnd_log.level_error);
976: END IF;
977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
978: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
979: p_prefix=>l_debug_prefix,

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

973: p_msg_data=>x_msg_data,
974: p_msg_type=>'UNEXPECTED ERROR',
975: p_msg_level=>fnd_log.level_error);
976: END IF;
977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
978: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
979: p_prefix=>l_debug_prefix,
980: p_msg_level=>fnd_log.level_procedure);
981: END IF;

Line 980: p_msg_level=>fnd_log.level_procedure);

976: END IF;
977: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
978: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
979: p_prefix=>l_debug_prefix,
980: p_msg_level=>fnd_log.level_procedure);
981: END IF;
982: WHEN OTHERS THEN
983: x_return_status := fnd_api.g_ret_sts_unexp_error;
984:

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

990: p_count => x_msg_count,
991: p_data => x_msg_data);
992:
993: -- Debug info.
994: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
995: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
996: p_msg_data=>x_msg_data,
997: p_msg_type=>'SQL ERROR',
998: p_msg_level=>fnd_log.level_error);

Line 998: p_msg_level=>fnd_log.level_error);

994: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
995: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
996: p_msg_data=>x_msg_data,
997: p_msg_type=>'SQL ERROR',
998: p_msg_level=>fnd_log.level_error);
999: END IF;
1000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1001: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
1002: p_prefix=>l_debug_prefix,

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

996: p_msg_data=>x_msg_data,
997: p_msg_type=>'SQL ERROR',
998: p_msg_level=>fnd_log.level_error);
999: END IF;
1000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1001: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
1002: p_prefix=>l_debug_prefix,
1003: p_msg_level=>fnd_log.level_procedure);
1004: END IF;

Line 1003: p_msg_level=>fnd_log.level_procedure);

999: END IF;
1000: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1001: hz_utility_v2pub.debug(p_message=>'get_cust_acct_bos (-)',
1002: p_prefix=>l_debug_prefix,
1003: p_msg_level=>fnd_log.level_procedure);
1004: END IF;
1005:
1006: end;
1007:

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

1311: END IF;
1312:
1313:
1314: -- Debug info.
1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos(+)',
1317: p_prefix=>l_debug_prefix,
1318: p_msg_level=>fnd_log.level_procedure);
1319: END IF;

Line 1318: p_msg_level=>fnd_log.level_procedure);

1314: -- Debug info.
1315: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1316: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos(+)',
1317: p_prefix=>l_debug_prefix,
1318: p_msg_level=>fnd_log.level_procedure);
1319: END IF;
1320:
1321: x_cust_acct_v2_objs := HZ_CUST_ACCT_V2_BO_TBL();
1322: open c1;

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

1382:
1383: end loop;
1384:
1385: -- Debug info.
1386: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1388: p_msg_data=>x_msg_data,
1389: p_msg_type=>'WARNING',
1390: p_msg_level=>fnd_log.level_exception);

Line 1390: p_msg_level=>fnd_log.level_exception);

1386: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1387: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1388: p_msg_data=>x_msg_data,
1389: p_msg_type=>'WARNING',
1390: p_msg_level=>fnd_log.level_exception);
1391: END IF;
1392:
1393: -- Debug info.
1394: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1390: p_msg_level=>fnd_log.level_exception);
1391: END IF;
1392:
1393: -- Debug info.
1394: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1395: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1396: p_prefix=>l_debug_prefix,
1397: p_msg_level=>fnd_log.level_procedure);
1398: END IF;

Line 1397: p_msg_level=>fnd_log.level_procedure);

1393: -- Debug info.
1394: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1395: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1396: p_prefix=>l_debug_prefix,
1397: p_msg_level=>fnd_log.level_procedure);
1398: END IF;
1399:
1400:
1401: EXCEPTION

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

1407: p_count => x_msg_count,
1408: p_data => x_msg_data);
1409:
1410: -- Debug info.
1411: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1412: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1413: p_msg_data=>x_msg_data,
1414: p_msg_type=>'ERROR',
1415: p_msg_level=>fnd_log.level_error);

Line 1415: p_msg_level=>fnd_log.level_error);

1411: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1412: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1413: p_msg_data=>x_msg_data,
1414: p_msg_type=>'ERROR',
1415: p_msg_level=>fnd_log.level_error);
1416: END IF;
1417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1418: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1419: p_prefix=>l_debug_prefix,

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

1413: p_msg_data=>x_msg_data,
1414: p_msg_type=>'ERROR',
1415: p_msg_level=>fnd_log.level_error);
1416: END IF;
1417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1418: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1419: p_prefix=>l_debug_prefix,
1420: p_msg_level=>fnd_log.level_procedure);
1421: END IF;

Line 1420: p_msg_level=>fnd_log.level_procedure);

1416: END IF;
1417: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1418: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1419: p_prefix=>l_debug_prefix,
1420: p_msg_level=>fnd_log.level_procedure);
1421: END IF;
1422: WHEN fnd_api.g_exc_unexpected_error THEN
1423: x_return_status := fnd_api.g_ret_sts_unexp_error;
1424:

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

1426: p_count => x_msg_count,
1427: p_data => x_msg_data);
1428:
1429: -- Debug info.
1430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1432: p_msg_data=>x_msg_data,
1433: p_msg_type=>'UNEXPECTED ERROR',
1434: p_msg_level=>fnd_log.level_error);

Line 1434: p_msg_level=>fnd_log.level_error);

1430: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1431: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1432: p_msg_data=>x_msg_data,
1433: p_msg_type=>'UNEXPECTED ERROR',
1434: p_msg_level=>fnd_log.level_error);
1435: END IF;
1436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1438: p_prefix=>l_debug_prefix,

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

1432: p_msg_data=>x_msg_data,
1433: p_msg_type=>'UNEXPECTED ERROR',
1434: p_msg_level=>fnd_log.level_error);
1435: END IF;
1436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1438: p_prefix=>l_debug_prefix,
1439: p_msg_level=>fnd_log.level_procedure);
1440: END IF;

Line 1439: p_msg_level=>fnd_log.level_procedure);

1435: END IF;
1436: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1437: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1438: p_prefix=>l_debug_prefix,
1439: p_msg_level=>fnd_log.level_procedure);
1440: END IF;
1441: WHEN OTHERS THEN
1442: x_return_status := fnd_api.g_ret_sts_unexp_error;
1443:

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

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

Line 1457: p_msg_level=>fnd_log.level_error);

1453: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1454: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1455: p_msg_data=>x_msg_data,
1456: p_msg_type=>'SQL ERROR',
1457: p_msg_level=>fnd_log.level_error);
1458: END IF;
1459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1460: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1461: p_prefix=>l_debug_prefix,

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

1455: p_msg_data=>x_msg_data,
1456: p_msg_type=>'SQL ERROR',
1457: p_msg_level=>fnd_log.level_error);
1458: END IF;
1459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1460: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1461: p_prefix=>l_debug_prefix,
1462: p_msg_level=>fnd_log.level_procedure);
1463: END IF;

Line 1462: p_msg_level=>fnd_log.level_procedure);

1458: END IF;
1459: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1460: hz_utility_v2pub.debug(p_message=>'get_cust_acct_v2_bos (-)',
1461: p_prefix=>l_debug_prefix,
1462: p_msg_level=>fnd_log.level_procedure);
1463: END IF;
1464:
1465: end;
1466: