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

Line 76: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(+)',

72: END IF;
73:
74: -- Debug info.
75: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
76: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(+)',
77: p_prefix=>l_debug_prefix,
78: p_msg_level=>fnd_log.level_procedure);
79: END IF;
80:

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

113: l_raise_event := FALSE;
114: END IF;
115:
116: -- initialize Global variable to indicate the caller of V2API is from BO API
117: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
118: IF(p_created_by_module IS NULL) THEN
119: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
120: ELSE
121: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

115:
116: -- initialize Global variable to indicate the caller of V2API is from BO API
117: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
118: IF(p_created_by_module IS NULL) THEN
119: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
120: ELSE
121: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
122: END IF;
123:

Line 121: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

117: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
118: IF(p_created_by_module IS NULL) THEN
119: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
120: ELSE
121: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
122: END IF;
123:
124: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
125:

Line 124: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

120: ELSE
121: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
122: END IF;
123:
124: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
125:
126: HZ_ORGANIZATION_BO_PUB.do_create_organization_bo(
127: p_init_msg_list => fnd_api.g_false,
128: p_validate_bo_flag => FND_API.G_FALSE,

Line 130: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

126: HZ_ORGANIZATION_BO_PUB.do_create_organization_bo(
127: p_init_msg_list => fnd_api.g_false,
128: p_validate_bo_flag => FND_API.G_FALSE,
129: p_organization_obj => p_org_cust_obj.organization_obj,
130: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
131: p_obj_source => p_obj_source,
132: x_return_status => x_return_status,
133: x_msg_count => x_msg_count,
134: x_msg_data => x_msg_data,

Line 144: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

140: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
141: RAISE fnd_api.g_exc_error;
142: END IF;
143:
144: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
145:
146: IF((p_org_cust_obj.account_objs IS NOT NULL) AND
147: (p_org_cust_obj.account_objs.COUNT > 0)) THEN
148: HZ_CUST_ACCT_BO_PVT.save_cust_accts(

Line 165: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

161: RAISE fnd_api.g_exc_error;
162: END IF;
163: END IF;
164:
165: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
166:
167: -- raise event
168: IF(l_raise_event) THEN
169: -- raise create org event

Line 189: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

185: );
186: END IF;
187:
188: -- reset Global variable
189: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
190: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
191:
192: -- Debug info.
193: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 190: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

186: END IF;
187:
188: -- reset Global variable
189: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
190: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
191:
192: -- Debug info.
193: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
194: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,

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

190: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
191:
192: -- Debug info.
193: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
194: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
195: p_msg_data=>x_msg_data,
196: p_msg_type=>'WARNING',
197: p_msg_level=>fnd_log.level_exception);
198: END IF;

Line 200: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',

196: p_msg_type=>'WARNING',
197: p_msg_level=>fnd_log.level_exception);
198: END IF;
199: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
200: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
201: p_prefix=>l_debug_prefix,
202: p_msg_level=>fnd_log.level_procedure);
203: END IF;
204: EXCEPTION

Line 209: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

205: WHEN fnd_api.g_exc_error THEN
206: ROLLBACK TO do_create_org_cust_bo_pub;
207:
208: -- reset Global variable
209: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
210: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
211:
212: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
213: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

Line 210: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

206: ROLLBACK TO do_create_org_cust_bo_pub;
207:
208: -- reset Global variable
209: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
210: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
211:
212: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
213: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
214: FND_MSG_PUB.ADD;

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

220: p_data => x_msg_data);
221:
222: -- Debug info.
223: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
224: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
225: p_msg_data=>x_msg_data,
226: p_msg_type=>'ERROR',
227: p_msg_level=>fnd_log.level_error);
228: END IF;

Line 230: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',

226: p_msg_type=>'ERROR',
227: p_msg_level=>fnd_log.level_error);
228: END IF;
229: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
230: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
231: p_prefix=>l_debug_prefix,
232: p_msg_level=>fnd_log.level_procedure);
233: END IF;
234:

Line 239: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

235: WHEN fnd_api.g_exc_unexpected_error THEN
236: ROLLBACK TO do_create_org_cust_bo_pub;
237:
238: -- reset Global variable
239: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
240: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
241:
242: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
243: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

Line 240: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

236: ROLLBACK TO do_create_org_cust_bo_pub;
237:
238: -- reset Global variable
239: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
240: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
241:
242: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
243: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
244: FND_MSG_PUB.ADD;

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

250: p_data => x_msg_data);
251:
252: -- Debug info.
253: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
254: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
255: p_msg_data=>x_msg_data,
256: p_msg_type=>'UNEXPECTED ERROR',
257: p_msg_level=>fnd_log.level_error);
258: END IF;

Line 260: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',

256: p_msg_type=>'UNEXPECTED ERROR',
257: p_msg_level=>fnd_log.level_error);
258: END IF;
259: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
260: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
261: p_prefix=>l_debug_prefix,
262: p_msg_level=>fnd_log.level_procedure);
263: END IF;
264:

Line 269: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

265: WHEN OTHERS THEN
266: ROLLBACK TO do_create_org_cust_bo_pub;
267:
268: -- reset Global variable
269: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
270: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
271:
272: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
273: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

Line 270: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

266: ROLLBACK TO do_create_org_cust_bo_pub;
267:
268: -- reset Global variable
269: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
270: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
271:
272: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
273: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
274: FND_MSG_PUB.ADD;

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

284: p_data => x_msg_data);
285:
286: -- Debug info.
287: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
289: p_msg_data=>x_msg_data,
290: p_msg_type=>'SQL ERROR',
291: p_msg_level=>fnd_log.level_error);
292: END IF;

Line 294: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',

290: p_msg_type=>'SQL ERROR',
291: p_msg_level=>fnd_log.level_error);
292: END IF;
293: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
294: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_bo(-)',
295: p_prefix=>l_debug_prefix,
296: p_msg_level=>fnd_log.level_procedure);
297: END IF;
298: END do_create_org_cust_bo;

Line 398: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',

394: END IF;
395:
396: -- Debug info.
397: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
398: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
399: p_prefix=>l_debug_prefix,
400: p_msg_level=>fnd_log.level_procedure);
401: END IF;
402:

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

400: p_msg_level=>fnd_log.level_procedure);
401: END IF;
402:
403: -- initialize Global variable to indicate the caller of V2API is from BO API
404: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
405: IF(p_created_by_module IS NULL) THEN
406: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
407: ELSE
408: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

402:
403: -- initialize Global variable to indicate the caller of V2API is from BO API
404: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
405: IF(p_created_by_module IS NULL) THEN
406: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
407: ELSE
408: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
409: END IF;
410:

Line 408: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

404: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
405: IF(p_created_by_module IS NULL) THEN
406: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
407: ELSE
408: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
409: END IF;
410:
411: x_organization_id := p_org_cust_obj.organization_obj.organization_id;
412: l_organization_os := p_org_cust_obj.organization_obj.orig_system;

Line 457: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

453: END IF;
454:
455: -- acknowledge update_organization_bo not to raise event
456: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';
457: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
458:
459: HZ_ORGANIZATION_BO_PUB.do_update_organization_bo(
460: p_init_msg_list => fnd_api.g_false,
461: p_organization_obj => p_org_cust_obj.organization_obj,

Line 462: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

458:
459: HZ_ORGANIZATION_BO_PUB.do_update_organization_bo(
460: p_init_msg_list => fnd_api.g_false,
461: p_organization_obj => p_org_cust_obj.organization_obj,
462: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
463: p_obj_source => p_obj_source,
464: x_return_status => x_return_status,
465: x_msg_count => x_msg_count,
466: x_msg_data => x_msg_data,

Line 476: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

472: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
473: RAISE FND_API.G_EXC_ERROR;
474: END IF;
475:
476: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
477:
478: IF((p_org_cust_obj.account_objs IS NOT NULL) AND
479: (p_org_cust_obj.account_objs.COUNT > 0)) THEN
480: HZ_CUST_ACCT_BO_PVT.save_cust_accts(

Line 497: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

493: RAISE fnd_api.g_exc_error;
494: END IF;
495: END IF;
496:
497: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
498:
499: -- raise event
500: IF(l_org_raise_event) THEN
501: -- raise update org event

Line 523: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

519: );
520: END IF;
521:
522: -- reset Global variable
523: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
524: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
525: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
526:
527: -- Debug info.

Line 524: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

520: END IF;
521:
522: -- reset Global variable
523: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
524: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
525: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
526:
527: -- Debug info.
528: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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

525: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
526:
527: -- Debug info.
528: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
529: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
530: p_msg_data=>x_msg_data,
531: p_msg_type=>'WARNING',
532: p_msg_level=>fnd_log.level_exception);
533: END IF;

Line 535: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',

531: p_msg_type=>'WARNING',
532: p_msg_level=>fnd_log.level_exception);
533: END IF;
534: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
535: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
536: p_prefix=>l_debug_prefix,
537: p_msg_level=>fnd_log.level_procedure);
538: END IF;
539:

Line 545: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

541: WHEN fnd_api.g_exc_error THEN
542: ROLLBACK TO do_update_org_cust_bo_pub;
543:
544: -- reset Global variable
545: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
546: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
547: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
548:
549: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');

Line 546: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

542: ROLLBACK TO do_update_org_cust_bo_pub;
543:
544: -- reset Global variable
545: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
546: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
547: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
548:
549: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
550: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

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

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

Line 567: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',

563: p_msg_type=>'ERROR',
564: p_msg_level=>fnd_log.level_error);
565: END IF;
566: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
567: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
568: p_prefix=>l_debug_prefix,
569: p_msg_level=>fnd_log.level_procedure);
570: END IF;
571:

Line 576: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

572: WHEN fnd_api.g_exc_unexpected_error THEN
573: ROLLBACK TO do_update_org_cust_bo_pub;
574:
575: -- reset Global variable
576: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
577: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
578: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
579:
580: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');

Line 577: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

573: ROLLBACK TO do_update_org_cust_bo_pub;
574:
575: -- reset Global variable
576: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
577: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
578: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
579:
580: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
581: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

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

588: p_data => x_msg_data);
589:
590: -- Debug info.
591: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
592: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
593: p_msg_data=>x_msg_data,
594: p_msg_type=>'UNEXPECTED ERROR',
595: p_msg_level=>fnd_log.level_error);
596: END IF;

Line 598: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',

594: p_msg_type=>'UNEXPECTED ERROR',
595: p_msg_level=>fnd_log.level_error);
596: END IF;
597: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
598: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
599: p_prefix=>l_debug_prefix,
600: p_msg_level=>fnd_log.level_procedure);
601: END IF;
602:

Line 607: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

603: WHEN OTHERS THEN
604: ROLLBACK TO do_update_org_cust_bo_pub;
605:
606: -- reset Global variable
607: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
608: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
609: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
610:
611: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');

Line 608: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

604: ROLLBACK TO do_update_org_cust_bo_pub;
605:
606: -- reset Global variable
607: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
608: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
609: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
610:
611: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
612: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

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

623: p_data => x_msg_data);
624:
625: -- Debug info.
626: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
627: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
628: p_msg_data=>x_msg_data,
629: p_msg_type=>'SQL ERROR',
630: p_msg_level=>fnd_log.level_error);
631: END IF;

Line 633: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',

629: p_msg_type=>'SQL ERROR',
630: p_msg_level=>fnd_log.level_error);
631: END IF;
632: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
633: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_bo(+)',
634: p_prefix=>l_debug_prefix,
635: p_msg_level=>fnd_log.level_procedure);
636: END IF;
637: END do_update_org_cust_bo;

Line 728: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(+)',

724: END IF;
725:
726: -- Debug info.
727: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
728: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(+)',
729: p_prefix=>l_debug_prefix,
730: p_msg_level=>fnd_log.level_procedure);
731: END IF;
732:

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

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

Line 793: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',

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

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

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

Line 814: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',

810: p_msg_type=>'ERROR',
811: p_msg_level=>fnd_log.level_error);
812: END IF;
813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
814: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
815: p_prefix=>l_debug_prefix,
816: p_msg_level=>fnd_log.level_procedure);
817: END IF;
818:

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

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

Line 834: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',

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

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

847: p_data => x_msg_data);
848:
849: -- Debug info.
850: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
851: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
852: p_msg_data=>x_msg_data,
853: p_msg_type=>'SQL ERROR',
854: p_msg_level=>fnd_log.level_error);
855: END IF;

Line 857: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',

853: p_msg_type=>'SQL ERROR',
854: p_msg_level=>fnd_log.level_error);
855: END IF;
856: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
857: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_bo(-)',
858: p_prefix=>l_debug_prefix,
859: p_msg_level=>fnd_log.level_procedure);
860: END IF;
861: END do_save_org_cust_bo;

Line 1006: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo(+)',

1002:
1003:
1004: -- Debug info.
1005: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1006: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo(+)',
1007: p_prefix=>l_debug_prefix,
1008: p_msg_level=>fnd_log.level_procedure);
1009: END IF;
1010:

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

1043:
1044:
1045: -- Debug info.
1046: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1047: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1048: p_msg_data=>x_msg_data,
1049: p_msg_type=>'WARNING',
1050: p_msg_level=>fnd_log.level_exception);
1051: END IF;

Line 1055: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',

1051: END IF;
1052:
1053: -- Debug info.
1054: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1055: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1056: p_prefix=>l_debug_prefix,
1057: p_msg_level=>fnd_log.level_procedure);
1058: END IF;
1059:

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

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

Line 1078: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',

1074: p_msg_type=>'ERROR',
1075: p_msg_level=>fnd_log.level_error);
1076: END IF;
1077: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1078: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1079: p_prefix=>l_debug_prefix,
1080: p_msg_level=>fnd_log.level_procedure);
1081: END IF;
1082: WHEN fnd_api.g_exc_unexpected_error THEN

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

1087: p_data => x_msg_data);
1088:
1089: -- Debug info.
1090: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1091: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1092: p_msg_data=>x_msg_data,
1093: p_msg_type=>'UNEXPECTED ERROR',
1094: p_msg_level=>fnd_log.level_error);
1095: END IF;

Line 1097: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',

1093: p_msg_type=>'UNEXPECTED ERROR',
1094: p_msg_level=>fnd_log.level_error);
1095: END IF;
1096: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1097: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1098: p_prefix=>l_debug_prefix,
1099: p_msg_level=>fnd_log.level_procedure);
1100: END IF;
1101: WHEN OTHERS THEN

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

1110: p_data => x_msg_data);
1111:
1112: -- Debug info.
1113: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1114: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1115: p_msg_data=>x_msg_data,
1116: p_msg_type=>'SQL ERROR',
1117: p_msg_level=>fnd_log.level_error);
1118: END IF;

Line 1120: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',

1116: p_msg_type=>'SQL ERROR',
1117: p_msg_level=>fnd_log.level_error);
1118: END IF;
1119: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1120: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_bo (-)',
1121: p_prefix=>l_debug_prefix,
1122: p_msg_level=>fnd_log.level_procedure);
1123: END IF;
1124:

Line 1226: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(+)',

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

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

1253:
1254:
1255: -- Debug info.
1256: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1257: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1258: p_msg_data=>x_msg_data,
1259: p_msg_type=>'WARNING',
1260: p_msg_level=>fnd_log.level_exception);
1261: END IF;

Line 1265: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created (-)',

1261: END IF;
1262:
1263: -- Debug info.
1264: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1265: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created (-)',
1266: p_prefix=>l_debug_prefix,
1267: p_msg_level=>fnd_log.level_procedure);
1268: END IF;
1269:

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

1278: p_data => x_msg_data);
1279:
1280: -- Debug info.
1281: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1282: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1283: p_msg_data=>x_msg_data,
1284: p_msg_type=>'ERROR',
1285: p_msg_level=>fnd_log.level_error);
1286: END IF;

Line 1288: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',

1284: p_msg_type=>'ERROR',
1285: p_msg_level=>fnd_log.level_error);
1286: END IF;
1287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1288: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1289: p_prefix=>l_debug_prefix,
1290: p_msg_level=>fnd_log.level_procedure);
1291: END IF;
1292: WHEN fnd_api.g_exc_unexpected_error THEN

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

1297: p_data => x_msg_data);
1298:
1299: -- Debug info.
1300: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1301: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1302: p_msg_data=>x_msg_data,
1303: p_msg_type=>'UNEXPECTED ERROR',
1304: p_msg_level=>fnd_log.level_error);
1305: END IF;

Line 1307: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',

1303: p_msg_type=>'UNEXPECTED ERROR',
1304: p_msg_level=>fnd_log.level_error);
1305: END IF;
1306: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1307: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1308: p_prefix=>l_debug_prefix,
1309: p_msg_level=>fnd_log.level_procedure);
1310: END IF;
1311: WHEN OTHERS THEN

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

1320: p_data => x_msg_data);
1321:
1322: -- Debug info.
1323: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1324: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1325: p_msg_data=>x_msg_data,
1326: p_msg_type=>'SQL ERROR',
1327: p_msg_level=>fnd_log.level_error);
1328: END IF;

Line 1330: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',

1326: p_msg_type=>'SQL ERROR',
1327: p_msg_level=>fnd_log.level_error);
1328: END IF;
1329: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1330: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_created(-)',
1331: p_prefix=>l_debug_prefix,
1332: p_msg_level=>fnd_log.level_procedure);
1333: END IF;
1334:

Line 1433: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(+)',

1429:
1430:
1431: -- Debug info.
1432: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1433: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(+)',
1434: p_prefix=>l_debug_prefix,
1435: p_msg_level=>fnd_log.level_procedure);
1436: END IF;
1437:

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

1460:
1461:
1462: -- Debug info.
1463: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1464: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1465: p_msg_data=>x_msg_data,
1466: p_msg_type=>'WARNING',
1467: p_msg_level=>fnd_log.level_exception);
1468: END IF;

Line 1472: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated (-)',

1468: END IF;
1469:
1470: -- Debug info.
1471: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1472: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated (-)',
1473: p_prefix=>l_debug_prefix,
1474: p_msg_level=>fnd_log.level_procedure);
1475: END IF;
1476:

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

1485: p_data => x_msg_data);
1486:
1487: -- Debug info.
1488: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1489: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1490: p_msg_data=>x_msg_data,
1491: p_msg_type=>'ERROR',
1492: p_msg_level=>fnd_log.level_error);
1493: END IF;

Line 1495: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',

1491: p_msg_type=>'ERROR',
1492: p_msg_level=>fnd_log.level_error);
1493: END IF;
1494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1495: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1496: p_prefix=>l_debug_prefix,
1497: p_msg_level=>fnd_log.level_procedure);
1498: END IF;
1499: WHEN fnd_api.g_exc_unexpected_error THEN

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

1504: p_data => x_msg_data);
1505:
1506: -- Debug info.
1507: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1508: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1509: p_msg_data=>x_msg_data,
1510: p_msg_type=>'UNEXPECTED ERROR',
1511: p_msg_level=>fnd_log.level_error);
1512: END IF;

Line 1514: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',

1510: p_msg_type=>'UNEXPECTED ERROR',
1511: p_msg_level=>fnd_log.level_error);
1512: END IF;
1513: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1514: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1515: p_prefix=>l_debug_prefix,
1516: p_msg_level=>fnd_log.level_procedure);
1517: END IF;
1518: WHEN OTHERS THEN

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

1527: p_data => x_msg_data);
1528:
1529: -- Debug info.
1530: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1531: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1532: p_msg_data=>x_msg_data,
1533: p_msg_type=>'SQL ERROR',
1534: p_msg_level=>fnd_log.level_error);
1535: END IF;

Line 1537: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',

1533: p_msg_type=>'SQL ERROR',
1534: p_msg_level=>fnd_log.level_error);
1535: END IF;
1536: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1537: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_custs_updated(-)',
1538: p_prefix=>l_debug_prefix,
1539: p_msg_level=>fnd_log.level_procedure);
1540: END IF;
1541:

Line 1592: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(+)',

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

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

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

Line 1632: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated (-)',

1628: END IF;
1629:
1630: -- Debug info.
1631: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1632: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated (-)',
1633: p_prefix=>l_debug_prefix,
1634: p_msg_level=>fnd_log.level_procedure);
1635: END IF;
1636:

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

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

Line 1655: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',

1651: p_msg_type=>'ERROR',
1652: p_msg_level=>fnd_log.level_error);
1653: END IF;
1654: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1655: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1656: p_prefix=>l_debug_prefix,
1657: p_msg_level=>fnd_log.level_procedure);
1658: END IF;
1659: WHEN fnd_api.g_exc_unexpected_error THEN

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

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

Line 1674: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',

1670: p_msg_type=>'UNEXPECTED ERROR',
1671: p_msg_level=>fnd_log.level_error);
1672: END IF;
1673: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1674: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1675: p_prefix=>l_debug_prefix,
1676: p_msg_level=>fnd_log.level_procedure);
1677: END IF;
1678: WHEN OTHERS THEN

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

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

Line 1697: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',

1693: p_msg_type=>'SQL ERROR',
1694: p_msg_level=>fnd_log.level_error);
1695: END IF;
1696: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1697: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_updated(-)',
1698: p_prefix=>l_debug_prefix,
1699: p_msg_level=>fnd_log.level_procedure);
1700: END IF;
1701:

Line 1753: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(+)',

1749:
1750:
1751: -- Debug info.
1752: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1753: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(+)',
1754: p_prefix=>l_debug_prefix,
1755: p_msg_level=>fnd_log.level_procedure);
1756: END IF;
1757:

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

1779:
1780:
1781: -- Debug info.
1782: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1783: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1784: p_msg_data=>x_msg_data,
1785: p_msg_type=>'WARNING',
1786: p_msg_level=>fnd_log.level_exception);
1787: END IF;

Line 1791: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created (-)',

1787: END IF;
1788:
1789: -- Debug info.
1790: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1791: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created (-)',
1792: p_prefix=>l_debug_prefix,
1793: p_msg_level=>fnd_log.level_procedure);
1794: END IF;
1795:

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

1804: p_data => x_msg_data);
1805:
1806: -- Debug info.
1807: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1808: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1809: p_msg_data=>x_msg_data,
1810: p_msg_type=>'ERROR',
1811: p_msg_level=>fnd_log.level_error);
1812: END IF;

Line 1814: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',

1810: p_msg_type=>'ERROR',
1811: p_msg_level=>fnd_log.level_error);
1812: END IF;
1813: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1814: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1815: p_prefix=>l_debug_prefix,
1816: p_msg_level=>fnd_log.level_procedure);
1817: END IF;
1818: WHEN fnd_api.g_exc_unexpected_error THEN

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

1823: p_data => x_msg_data);
1824:
1825: -- Debug info.
1826: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1827: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1828: p_msg_data=>x_msg_data,
1829: p_msg_type=>'UNEXPECTED ERROR',
1830: p_msg_level=>fnd_log.level_error);
1831: END IF;

Line 1833: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',

1829: p_msg_type=>'UNEXPECTED ERROR',
1830: p_msg_level=>fnd_log.level_error);
1831: END IF;
1832: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1833: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1834: p_prefix=>l_debug_prefix,
1835: p_msg_level=>fnd_log.level_procedure);
1836: END IF;
1837: WHEN OTHERS THEN

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

1846: p_data => x_msg_data);
1847:
1848: -- Debug info.
1849: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1850: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1851: p_msg_data=>x_msg_data,
1852: p_msg_type=>'SQL ERROR',
1853: p_msg_level=>fnd_log.level_error);
1854: END IF;

Line 1856: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',

1852: p_msg_type=>'SQL ERROR',
1853: p_msg_level=>fnd_log.level_error);
1854: END IF;
1855: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1856: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_created(-)',
1857: p_prefix=>l_debug_prefix,
1858: p_msg_level=>fnd_log.level_procedure);
1859: END IF;
1860:

Line 1887: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(+)',

1883:
1884:
1885: -- Debug info.
1886: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1887: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(+)',
1888: p_prefix=>l_debug_prefix,
1889: p_msg_level=>fnd_log.level_procedure);
1890: END IF;
1891:

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

1914:
1915:
1916: -- Debug info.
1917: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
1918: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1919: p_msg_data=>x_msg_data,
1920: p_msg_type=>'WARNING',
1921: p_msg_level=>fnd_log.level_exception);
1922: END IF;

Line 1926: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated (-)',

1922: END IF;
1923:
1924: -- Debug info.
1925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1926: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated (-)',
1927: p_prefix=>l_debug_prefix,
1928: p_msg_level=>fnd_log.level_procedure);
1929: END IF;
1930:

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

1939: p_data => x_msg_data);
1940:
1941: -- Debug info.
1942: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1943: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1944: p_msg_data=>x_msg_data,
1945: p_msg_type=>'ERROR',
1946: p_msg_level=>fnd_log.level_error);
1947: END IF;

Line 1949: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',

1945: p_msg_type=>'ERROR',
1946: p_msg_level=>fnd_log.level_error);
1947: END IF;
1948: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1949: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1950: p_prefix=>l_debug_prefix,
1951: p_msg_level=>fnd_log.level_procedure);
1952: END IF;
1953: WHEN fnd_api.g_exc_unexpected_error THEN

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

1958: p_data => x_msg_data);
1959:
1960: -- Debug info.
1961: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1962: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1963: p_msg_data=>x_msg_data,
1964: p_msg_type=>'UNEXPECTED ERROR',
1965: p_msg_level=>fnd_log.level_error);
1966: END IF;

Line 1968: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',

1964: p_msg_type=>'UNEXPECTED ERROR',
1965: p_msg_level=>fnd_log.level_error);
1966: END IF;
1967: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1968: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1969: p_prefix=>l_debug_prefix,
1970: p_msg_level=>fnd_log.level_procedure);
1971: END IF;
1972: WHEN OTHERS THEN

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

1981: p_data => x_msg_data);
1982:
1983: -- Debug info.
1984: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
1985: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
1986: p_msg_data=>x_msg_data,
1987: p_msg_type=>'SQL ERROR',
1988: p_msg_level=>fnd_log.level_error);
1989: END IF;

Line 1991: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',

1987: p_msg_type=>'SQL ERROR',
1988: p_msg_level=>fnd_log.level_error);
1989: END IF;
1990: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1991: hz_utility_v2pub.debug(p_message=>'get_ids_org_custs_updated(-)',
1992: p_prefix=>l_debug_prefix,
1993: p_msg_level=>fnd_log.level_procedure);
1994: END IF;
1995:

Line 2037: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(+)',

2033: END IF;
2034:
2035: -- Debug info.
2036: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2037: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(+)',
2038: p_prefix=>l_debug_prefix,
2039: p_msg_level=>fnd_log.level_procedure);
2040: END IF;
2041:

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

2074: l_raise_event := FALSE;
2075: END IF;
2076:
2077: -- initialize Global variable to indicate the caller of V2API is from BO API
2078: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2079: IF(p_created_by_module IS NULL) THEN
2080: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2081: ELSE
2082: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

2076:
2077: -- initialize Global variable to indicate the caller of V2API is from BO API
2078: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2079: IF(p_created_by_module IS NULL) THEN
2080: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2081: ELSE
2082: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2083: END IF;
2084:

Line 2082: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

2078: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2079: IF(p_created_by_module IS NULL) THEN
2080: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2081: ELSE
2082: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2083: END IF;
2084:
2085: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2086:

Line 2085: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2081: ELSE
2082: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2083: END IF;
2084:
2085: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2086:
2087: HZ_ORGANIZATION_BO_PUB.do_create_organization_bo(
2088: p_init_msg_list => fnd_api.g_false,
2089: p_validate_bo_flag => FND_API.G_FALSE,

Line 2091: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

2087: HZ_ORGANIZATION_BO_PUB.do_create_organization_bo(
2088: p_init_msg_list => fnd_api.g_false,
2089: p_validate_bo_flag => FND_API.G_FALSE,
2090: p_organization_obj => p_org_cust_v2_obj.organization_obj,
2091: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2092: p_obj_source => p_obj_source,
2093: x_return_status => x_return_status,
2094: x_msg_count => x_msg_count,
2095: x_msg_data => x_msg_data,

Line 2105: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2101: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2102: RAISE fnd_api.g_exc_error;
2103: END IF;
2104:
2105: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2106:
2107: IF((p_org_cust_v2_obj.account_objs IS NOT NULL) AND
2108: (p_org_cust_v2_obj.account_objs.COUNT > 0)) THEN
2109: HZ_CUST_ACCT_BO_PVT.save_cust_accts(

Line 2126: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2122: RAISE fnd_api.g_exc_error;
2123: END IF;
2124: END IF;
2125:
2126: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2127:
2128: -- raise event
2129: IF(l_raise_event) THEN
2130: -- raise create org event

Line 2150: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

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

Line 2151: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

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

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

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

Line 2161: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',

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

Line 2170: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2166: WHEN fnd_api.g_exc_error THEN
2167: ROLLBACK TO do_create_org_cust_v2_bo_pub;
2168:
2169: -- reset Global variable
2170: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2171: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2172:
2173: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2174: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

Line 2171: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2167: ROLLBACK TO do_create_org_cust_v2_bo_pub;
2168:
2169: -- reset Global variable
2170: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2171: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2172:
2173: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2174: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2175: FND_MSG_PUB.ADD;

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

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

Line 2191: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',

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

Line 2200: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2196: WHEN fnd_api.g_exc_unexpected_error THEN
2197: ROLLBACK TO do_create_org_cust_v2_bo_pub;
2198:
2199: -- reset Global variable
2200: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2201: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2202:
2203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2204: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

Line 2201: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2197: ROLLBACK TO do_create_org_cust_v2_bo_pub;
2198:
2199: -- reset Global variable
2200: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2201: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2202:
2203: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2204: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2205: FND_MSG_PUB.ADD;

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

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

Line 2221: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',

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

Line 2230: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2226: WHEN OTHERS THEN
2227: ROLLBACK TO do_create_org_cust_v2_bo_pub;
2228:
2229: -- reset Global variable
2230: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2231: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2232:
2233: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2234: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

Line 2231: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2227: ROLLBACK TO do_create_org_cust_v2_bo_pub;
2228:
2229: -- reset Global variable
2230: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2231: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2232:
2233: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2234: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');
2235: FND_MSG_PUB.ADD;

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

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

Line 2255: hz_utility_v2pub.debug(p_message=>'do_create_org_cust_v2_bo(-)',

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

Line 2334: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',

2330: END IF;
2331:
2332: -- Debug info.
2333: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2334: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2335: p_prefix=>l_debug_prefix,
2336: p_msg_level=>fnd_log.level_procedure);
2337: END IF;
2338:

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

2336: p_msg_level=>fnd_log.level_procedure);
2337: END IF;
2338:
2339: -- initialize Global variable to indicate the caller of V2API is from BO API
2340: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2341: IF(p_created_by_module IS NULL) THEN
2342: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2343: ELSE
2344: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

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

2338:
2339: -- initialize Global variable to indicate the caller of V2API is from BO API
2340: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2341: IF(p_created_by_module IS NULL) THEN
2342: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2343: ELSE
2344: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2345: END IF;
2346:

Line 2344: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;

2340: HZ_UTILITY_V2PUB.G_CALLING_API := 'BO_API';
2341: IF(p_created_by_module IS NULL) THEN
2342: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := 'BO_API';
2343: ELSE
2344: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := p_created_by_module;
2345: END IF;
2346:
2347: x_organization_id := p_org_cust_v2_obj.organization_obj.organization_id;
2348: l_organization_os := p_org_cust_v2_obj.organization_obj.orig_system;

Line 2393: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;

2389: END IF;
2390:
2391: -- acknowledge update_organization_bo not to raise event
2392: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';
2393: l_cbm := HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE;
2394:
2395: HZ_ORGANIZATION_BO_PUB.do_update_organization_bo(
2396: p_init_msg_list => fnd_api.g_false,
2397: p_organization_obj => p_org_cust_v2_obj.organization_obj,

Line 2398: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,

2394:
2395: HZ_ORGANIZATION_BO_PUB.do_update_organization_bo(
2396: p_init_msg_list => fnd_api.g_false,
2397: p_organization_obj => p_org_cust_v2_obj.organization_obj,
2398: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
2399: p_obj_source => p_obj_source,
2400: x_return_status => x_return_status,
2401: x_msg_count => x_msg_count,
2402: x_msg_data => x_msg_data,

Line 2412: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2408: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411:
2412: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2413:
2414: IF((p_org_cust_v2_obj.account_objs IS NOT NULL) AND
2415: (p_org_cust_v2_obj.account_objs.COUNT > 0)) THEN
2416: HZ_CUST_ACCT_BO_PVT.save_cust_accts(

Line 2433: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;

2429: RAISE fnd_api.g_exc_error;
2430: END IF;
2431: END IF;
2432:
2433: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
2434:
2435: -- raise event
2436: IF(l_org_raise_event) THEN
2437: -- raise update org event

Line 2459: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2455: );
2456: END IF;
2457:
2458: -- reset Global variable
2459: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2460: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2461: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2462:
2463: -- Debug info.

Line 2460: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2456: END IF;
2457:
2458: -- reset Global variable
2459: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2460: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2461: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2462:
2463: -- Debug info.
2464: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

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

2461: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2462:
2463: -- Debug info.
2464: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2465: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2466: p_msg_data=>x_msg_data,
2467: p_msg_type=>'WARNING',
2468: p_msg_level=>fnd_log.level_exception);
2469: END IF;

Line 2471: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',

2467: p_msg_type=>'WARNING',
2468: p_msg_level=>fnd_log.level_exception);
2469: END IF;
2470: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2471: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2472: p_prefix=>l_debug_prefix,
2473: p_msg_level=>fnd_log.level_procedure);
2474: END IF;
2475:

Line 2481: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2477: WHEN fnd_api.g_exc_error THEN
2478: ROLLBACK TO do_update_org_cust_v2_bo_pub;
2479:
2480: -- reset Global variable
2481: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2482: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2483: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2484:
2485: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');

Line 2482: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2478: ROLLBACK TO do_update_org_cust_v2_bo_pub;
2479:
2480: -- reset Global variable
2481: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2482: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2483: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2484:
2485: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2486: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

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

2493: p_data => x_msg_data);
2494:
2495: -- Debug info.
2496: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2497: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2498: p_msg_data=>x_msg_data,
2499: p_msg_type=>'ERROR',
2500: p_msg_level=>fnd_log.level_error);
2501: END IF;

Line 2503: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',

2499: p_msg_type=>'ERROR',
2500: p_msg_level=>fnd_log.level_error);
2501: END IF;
2502: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2503: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2504: p_prefix=>l_debug_prefix,
2505: p_msg_level=>fnd_log.level_procedure);
2506: END IF;
2507:

Line 2512: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2508: WHEN fnd_api.g_exc_unexpected_error THEN
2509: ROLLBACK TO do_update_org_cust_v2_bo_pub;
2510:
2511: -- reset Global variable
2512: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2513: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2514: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2515:
2516: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');

Line 2513: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2509: ROLLBACK TO do_update_org_cust_v2_bo_pub;
2510:
2511: -- reset Global variable
2512: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2513: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2514: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2515:
2516: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2517: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

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

2524: p_data => x_msg_data);
2525:
2526: -- Debug info.
2527: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2528: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2529: p_msg_data=>x_msg_data,
2530: p_msg_type=>'UNEXPECTED ERROR',
2531: p_msg_level=>fnd_log.level_error);
2532: END IF;

Line 2534: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',

2530: p_msg_type=>'UNEXPECTED ERROR',
2531: p_msg_level=>fnd_log.level_error);
2532: END IF;
2533: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2534: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2535: p_prefix=>l_debug_prefix,
2536: p_msg_level=>fnd_log.level_procedure);
2537: END IF;
2538:

Line 2543: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;

2539: WHEN OTHERS THEN
2540: ROLLBACK TO do_update_org_cust_v2_bo_pub;
2541:
2542: -- reset Global variable
2543: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2544: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2545: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2546:
2547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');

Line 2544: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;

2540: ROLLBACK TO do_update_org_cust_v2_bo_pub;
2541:
2542: -- reset Global variable
2543: HZ_UTILITY_V2PUB.G_CALLING_API := NULL;
2544: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := NULL;
2545: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := NULL;
2546:
2547: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_OBJECT_ERROR');
2548: FND_MESSAGE.SET_TOKEN('OBJECT', 'ORG_CUST');

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

2559: p_data => x_msg_data);
2560:
2561: -- Debug info.
2562: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2563: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2564: p_msg_data=>x_msg_data,
2565: p_msg_type=>'SQL ERROR',
2566: p_msg_level=>fnd_log.level_error);
2567: END IF;

Line 2569: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',

2565: p_msg_type=>'SQL ERROR',
2566: p_msg_level=>fnd_log.level_error);
2567: END IF;
2568: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2569: hz_utility_v2pub.debug(p_message=>'do_update_org_cust_v2_bo(+)',
2570: p_prefix=>l_debug_prefix,
2571: p_msg_level=>fnd_log.level_procedure);
2572: END IF;
2573: END do_update_org_cust_v2_bo;

Line 2641: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(+)',

2637: END IF;
2638:
2639: -- Debug info.
2640: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2641: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(+)',
2642: p_prefix=>l_debug_prefix,
2643: p_msg_level=>fnd_log.level_procedure);
2644: END IF;
2645:

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

2696: END IF;
2697:
2698: -- Debug info.
2699: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
2700: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2701: p_msg_data=>x_msg_data,
2702: p_msg_type=>'WARNING',
2703: p_msg_level=>fnd_log.level_exception);
2704: END IF;

Line 2706: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',

2702: p_msg_type=>'WARNING',
2703: p_msg_level=>fnd_log.level_exception);
2704: END IF;
2705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2706: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2707: p_prefix=>l_debug_prefix,
2708: p_msg_level=>fnd_log.level_procedure);
2709: END IF;
2710:

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

2717: p_data => x_msg_data);
2718:
2719: -- Debug info.
2720: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2721: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2722: p_msg_data=>x_msg_data,
2723: p_msg_type=>'ERROR',
2724: p_msg_level=>fnd_log.level_error);
2725: END IF;

Line 2727: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',

2723: p_msg_type=>'ERROR',
2724: p_msg_level=>fnd_log.level_error);
2725: END IF;
2726: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2727: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2728: p_prefix=>l_debug_prefix,
2729: p_msg_level=>fnd_log.level_procedure);
2730: END IF;
2731:

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

2737: p_data => x_msg_data);
2738:
2739: -- Debug info.
2740: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2741: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2742: p_msg_data=>x_msg_data,
2743: p_msg_type=>'UNEXPECTED ERROR',
2744: p_msg_level=>fnd_log.level_error);
2745: END IF;

Line 2747: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',

2743: p_msg_type=>'UNEXPECTED ERROR',
2744: p_msg_level=>fnd_log.level_error);
2745: END IF;
2746: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2747: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2748: p_prefix=>l_debug_prefix,
2749: p_msg_level=>fnd_log.level_procedure);
2750: END IF;
2751: WHEN OTHERS THEN

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

2760: p_data => x_msg_data);
2761:
2762: -- Debug info.
2763: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
2764: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
2765: p_msg_data=>x_msg_data,
2766: p_msg_type=>'SQL ERROR',
2767: p_msg_level=>fnd_log.level_error);
2768: END IF;

Line 2770: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',

2766: p_msg_type=>'SQL ERROR',
2767: p_msg_level=>fnd_log.level_error);
2768: END IF;
2769: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2770: hz_utility_v2pub.debug(p_message=>'do_save_org_cust_v2_bo(-)',
2771: p_prefix=>l_debug_prefix,
2772: p_msg_level=>fnd_log.level_procedure);
2773: END IF;
2774: END do_save_org_cust_v2_bo;

Line 2894: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo(+)',

2890:
2891:
2892: -- Debug info.
2893: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2894: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo(+)',
2895: p_prefix=>l_debug_prefix,
2896: p_msg_level=>fnd_log.level_procedure);
2897: END IF;
2898:

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

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

Line 2943: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',

2939: END IF;
2940:
2941: -- Debug info.
2942: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2943: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2944: p_prefix=>l_debug_prefix,
2945: p_msg_level=>fnd_log.level_procedure);
2946: END IF;
2947:

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

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

Line 2966: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',

2962: p_msg_type=>'ERROR',
2963: p_msg_level=>fnd_log.level_error);
2964: END IF;
2965: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2966: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2967: p_prefix=>l_debug_prefix,
2968: p_msg_level=>fnd_log.level_procedure);
2969: END IF;
2970: WHEN fnd_api.g_exc_unexpected_error THEN

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

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

Line 2985: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',

2981: p_msg_type=>'UNEXPECTED ERROR',
2982: p_msg_level=>fnd_log.level_error);
2983: END IF;
2984: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
2985: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
2986: p_prefix=>l_debug_prefix,
2987: p_msg_level=>fnd_log.level_procedure);
2988: END IF;
2989: WHEN OTHERS THEN

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

2998: p_data => x_msg_data);
2999:
3000: -- Debug info.
3001: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3002: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3003: p_msg_data=>x_msg_data,
3004: p_msg_type=>'SQL ERROR',
3005: p_msg_level=>fnd_log.level_error);
3006: END IF;

Line 3008: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',

3004: p_msg_type=>'SQL ERROR',
3005: p_msg_level=>fnd_log.level_error);
3006: END IF;
3007: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3008: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_org_cust_v2_bo (-)',
3009: p_prefix=>l_debug_prefix,
3010: p_msg_level=>fnd_log.level_procedure);
3011: END IF;
3012:

Line 3113: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(+)',

3109:
3110:
3111: -- Debug info.
3112: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3113: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(+)',
3114: p_prefix=>l_debug_prefix,
3115: p_msg_level=>fnd_log.level_procedure);
3116: END IF;
3117:

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

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

Line 3152: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created (-)',

3148: END IF;
3149:
3150: -- Debug info.
3151: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3152: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created (-)',
3153: p_prefix=>l_debug_prefix,
3154: p_msg_level=>fnd_log.level_procedure);
3155: END IF;
3156:

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

3165: p_data => x_msg_data);
3166:
3167: -- Debug info.
3168: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3169: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3170: p_msg_data=>x_msg_data,
3171: p_msg_type=>'ERROR',
3172: p_msg_level=>fnd_log.level_error);
3173: END IF;

Line 3175: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',

3171: p_msg_type=>'ERROR',
3172: p_msg_level=>fnd_log.level_error);
3173: END IF;
3174: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3175: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3176: p_prefix=>l_debug_prefix,
3177: p_msg_level=>fnd_log.level_procedure);
3178: END IF;
3179: WHEN fnd_api.g_exc_unexpected_error THEN

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

3184: p_data => x_msg_data);
3185:
3186: -- Debug info.
3187: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3188: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3189: p_msg_data=>x_msg_data,
3190: p_msg_type=>'UNEXPECTED ERROR',
3191: p_msg_level=>fnd_log.level_error);
3192: END IF;

Line 3194: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',

3190: p_msg_type=>'UNEXPECTED ERROR',
3191: p_msg_level=>fnd_log.level_error);
3192: END IF;
3193: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3194: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',
3195: p_prefix=>l_debug_prefix,
3196: p_msg_level=>fnd_log.level_procedure);
3197: END IF;
3198: WHEN OTHERS THEN

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

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

Line 3217: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_created(-)',

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

Line 3315: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(+)',

3311:
3312:
3313: -- Debug info.
3314: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3315: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(+)',
3316: p_prefix=>l_debug_prefix,
3317: p_msg_level=>fnd_log.level_procedure);
3318: END IF;
3319:

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

3342:
3343:
3344: -- Debug info.
3345: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3346: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3347: p_msg_data=>x_msg_data,
3348: p_msg_type=>'WARNING',
3349: p_msg_level=>fnd_log.level_exception);
3350: END IF;

Line 3354: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated (-)',

3350: END IF;
3351:
3352: -- Debug info.
3353: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3354: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated (-)',
3355: p_prefix=>l_debug_prefix,
3356: p_msg_level=>fnd_log.level_procedure);
3357: END IF;
3358:

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

3367: p_data => x_msg_data);
3368:
3369: -- Debug info.
3370: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3371: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3372: p_msg_data=>x_msg_data,
3373: p_msg_type=>'ERROR',
3374: p_msg_level=>fnd_log.level_error);
3375: END IF;

Line 3377: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',

3373: p_msg_type=>'ERROR',
3374: p_msg_level=>fnd_log.level_error);
3375: END IF;
3376: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3377: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3378: p_prefix=>l_debug_prefix,
3379: p_msg_level=>fnd_log.level_procedure);
3380: END IF;
3381: WHEN fnd_api.g_exc_unexpected_error THEN

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

3386: p_data => x_msg_data);
3387:
3388: -- Debug info.
3389: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3390: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3391: p_msg_data=>x_msg_data,
3392: p_msg_type=>'UNEXPECTED ERROR',
3393: p_msg_level=>fnd_log.level_error);
3394: END IF;

Line 3396: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',

3392: p_msg_type=>'UNEXPECTED ERROR',
3393: p_msg_level=>fnd_log.level_error);
3394: END IF;
3395: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3396: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_custs_updated(-)',
3397: p_prefix=>l_debug_prefix,
3398: p_msg_level=>fnd_log.level_procedure);
3399: END IF;
3400: WHEN OTHERS THEN

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

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

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

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

Line 3473: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(+)',

3469:
3470:
3471: -- Debug info.
3472: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3473: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(+)',
3474: p_prefix=>l_debug_prefix,
3475: p_msg_level=>fnd_log.level_procedure);
3476: END IF;
3477:

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

3501:
3502:
3503: -- Debug info.
3504: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN
3505: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3506: p_msg_data=>x_msg_data,
3507: p_msg_type=>'WARNING',
3508: p_msg_level=>fnd_log.level_exception);
3509: END IF;

Line 3513: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated (-)',

3509: END IF;
3510:
3511: -- Debug info.
3512: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3513: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated (-)',
3514: p_prefix=>l_debug_prefix,
3515: p_msg_level=>fnd_log.level_procedure);
3516: END IF;
3517:

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

3526: p_data => x_msg_data);
3527:
3528: -- Debug info.
3529: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3530: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3531: p_msg_data=>x_msg_data,
3532: p_msg_type=>'ERROR',
3533: p_msg_level=>fnd_log.level_error);
3534: END IF;

Line 3536: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',

3532: p_msg_type=>'ERROR',
3533: p_msg_level=>fnd_log.level_error);
3534: END IF;
3535: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3536: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3537: p_prefix=>l_debug_prefix,
3538: p_msg_level=>fnd_log.level_procedure);
3539: END IF;
3540: WHEN fnd_api.g_exc_unexpected_error THEN

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

3545: p_data => x_msg_data);
3546:
3547: -- Debug info.
3548: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3549: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3550: p_msg_data=>x_msg_data,
3551: p_msg_type=>'UNEXPECTED ERROR',
3552: p_msg_level=>fnd_log.level_error);
3553: END IF;

Line 3555: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',

3551: p_msg_type=>'UNEXPECTED ERROR',
3552: p_msg_level=>fnd_log.level_error);
3553: END IF;
3554: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3555: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3556: p_prefix=>l_debug_prefix,
3557: p_msg_level=>fnd_log.level_procedure);
3558: END IF;
3559: WHEN OTHERS THEN

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

3568: p_data => x_msg_data);
3569:
3570: -- Debug info.
3571: IF fnd_log.level_error>=fnd_log.g_current_runtime_level THEN
3572: hz_utility_v2pub.debug_return_messages(p_msg_count=>x_msg_count,
3573: p_msg_data=>x_msg_data,
3574: p_msg_type=>'SQL ERROR',
3575: p_msg_level=>fnd_log.level_error);
3576: END IF;

Line 3578: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',

3574: p_msg_type=>'SQL ERROR',
3575: p_msg_level=>fnd_log.level_error);
3576: END IF;
3577: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
3578: hz_utility_v2pub.debug(p_message=>'hz_org_cust_bo_pub.get_v2_org_cust_updated(-)',
3579: p_prefix=>l_debug_prefix,
3580: p_msg_level=>fnd_log.level_procedure);
3581: END IF;
3582: