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_CONTACT_BO_PVT dependencies on FND_API

Line 93: -- be fnd_api.g_ret_sts_success (success),

89: -- p_ocr_objs List of org contact role objects.
90: -- p_oc_id Org contact Id.
91: -- OUT:
92: -- x_return_status Return status after the call. The status can
93: -- be fnd_api.g_ret_sts_success (success),
94: -- fnd_api.g_ret_sts_error (error),
95: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
96: -- x_msg_count Number of messages in message stack.
97: -- x_msg_data Message text if x_msg_count is 1.

Line 94: -- fnd_api.g_ret_sts_error (error),

90: -- p_oc_id Org contact Id.
91: -- OUT:
92: -- x_return_status Return status after the call. The status can
93: -- be fnd_api.g_ret_sts_success (success),
94: -- fnd_api.g_ret_sts_error (error),
95: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
96: -- x_msg_count Number of messages in message stack.
97: -- x_msg_data Message text if x_msg_count is 1.
98: --

Line 95: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

91: -- OUT:
92: -- x_return_status Return status after the call. The status can
93: -- be fnd_api.g_ret_sts_success (success),
94: -- fnd_api.g_ret_sts_error (error),
95: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
96: -- x_msg_count Number of messages in message stack.
97: -- x_msg_data Message text if x_msg_count is 1.
98: --
99: -- NOTES

Line 120: x_return_status := FND_API.G_RET_STS_SUCCESS;

116: -- Standard start of API savepoint
117: SAVEPOINT create_org_contact_roles_pvt;
118:
119: -- initialize API return status to success.
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: -- Debug info.
123: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
124: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(+)',

Line 148: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

144: x_msg_count => x_msg_count,
145: x_msg_data => x_msg_data
146: );
147:
148: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
149: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
150: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.create_org_contact_roles, org contact id: '||p_oc_id,
151: p_prefix=>l_debug_prefix,
152: p_msg_level=>fnd_log.level_procedure);

Line 154: RAISE fnd_api.g_exc_error;

150: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.create_org_contact_roles, org contact id: '||p_oc_id,
151: p_prefix=>l_debug_prefix,
152: p_msg_level=>fnd_log.level_procedure);
153: END IF;
154: RAISE fnd_api.g_exc_error;
155: END IF;
156:
157: -- assign org_contact_role_id
158: p_ocr_objs(i).org_contact_role_id := l_ocr_id;

Line 175: WHEN fnd_api.g_exc_error THEN

171: p_prefix=>l_debug_prefix,
172: p_msg_level=>fnd_log.level_procedure);
173: END IF;
174: EXCEPTION
175: WHEN fnd_api.g_exc_error THEN
176: ROLLBACK TO create_org_contact_roles_pvt;
177: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
178: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
179: FND_MSG_PUB.ADD;

Line 181: x_return_status := fnd_api.g_ret_sts_error;

177: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
178: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
179: FND_MSG_PUB.ADD;
180:
181: x_return_status := fnd_api.g_ret_sts_error;
182:
183: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
184: p_count => x_msg_count,
185: p_data => x_msg_data);

Line 183: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

179: FND_MSG_PUB.ADD;
180:
181: x_return_status := fnd_api.g_ret_sts_error;
182:
183: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
184: p_count => x_msg_count,
185: p_data => x_msg_data);
186:
187: -- Debug info.

Line 199: WHEN fnd_api.g_exc_unexpected_error THEN

195: hz_utility_v2pub.debug(p_message=>'create_org_contact_roles(-)',
196: p_prefix=>l_debug_prefix,
197: p_msg_level=>fnd_log.level_procedure);
198: END IF;
199: WHEN fnd_api.g_exc_unexpected_error THEN
200: ROLLBACK TO create_org_contact_roles_pvt;
201: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
202: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
203: FND_MSG_PUB.ADD;

Line 205: x_return_status := fnd_api.g_ret_sts_unexp_error;

201: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
202: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
203: FND_MSG_PUB.ADD;
204:
205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206:
207: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
208: p_count => x_msg_count,
209: p_data => x_msg_data);

Line 207: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

203: FND_MSG_PUB.ADD;
204:
205: x_return_status := fnd_api.g_ret_sts_unexp_error;
206:
207: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
208: p_count => x_msg_count,
209: p_data => x_msg_data);
210:
211: -- Debug info.

Line 229: x_return_status := fnd_api.g_ret_sts_unexp_error;

225: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
226: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
227: FND_MSG_PUB.ADD;
228:
229: x_return_status := fnd_api.g_ret_sts_unexp_error;
230:
231: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
232: fnd_message.set_token('ERROR' ,SQLERRM);
233: fnd_msg_pub.add;

Line 235: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

231: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
232: fnd_message.set_token('ERROR' ,SQLERRM);
233: fnd_msg_pub.add;
234:
235: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
236: p_count => x_msg_count,
237: p_data => x_msg_data);
238:
239: -- Debug info.

Line 273: x_return_status := FND_API.G_RET_STS_SUCCESS;

269: -- Standard start of API savepoint
270: SAVEPOINT save_org_contact_roles_pvt;
271:
272: -- initialize API return status to success.
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: -- Debug info.
276: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
277: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(+)',

Line 312: RAISE FND_API.G_EXC_ERROR;

308: FND_MSG_PUB.ADD;
309: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
310: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
311: FND_MSG_PUB.ADD;
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:
315: IF(l_ocr_rec.org_contact_role_id IS NULL) THEN
316: HZ_PARTY_CONTACT_V2PUB.create_org_contact_role(

Line 340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

336:
337: -- assign org_contact_role_id
338: p_ocr_objs(i).org_contact_role_id := l_ocr_rec.org_contact_role_id;
339: END IF;
340: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
341: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
342: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contact_roles, org contact id: '||p_oc_id,
343: p_prefix=>l_debug_prefix,
344: p_msg_level=>fnd_log.level_procedure);

Line 346: RAISE fnd_api.g_exc_error;

342: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contact_roles, org contact id: '||p_oc_id,
343: p_prefix=>l_debug_prefix,
344: p_msg_level=>fnd_log.level_procedure);
345: END IF;
346: RAISE fnd_api.g_exc_error;
347: END IF;
348: END LOOP;
349: END IF;
350:

Line 364: WHEN fnd_api.g_exc_error THEN

360: p_prefix=>l_debug_prefix,
361: p_msg_level=>fnd_log.level_procedure);
362: END IF;
363: EXCEPTION
364: WHEN fnd_api.g_exc_error THEN
365: ROLLBACK TO save_org_contact_roles_pvt;
366: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
367: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
368: FND_MSG_PUB.ADD;

Line 370: x_return_status := fnd_api.g_ret_sts_error;

366: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
367: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
368: FND_MSG_PUB.ADD;
369:
370: x_return_status := fnd_api.g_ret_sts_error;
371:
372: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
373: p_count => x_msg_count,
374: p_data => x_msg_data);

Line 372: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

368: FND_MSG_PUB.ADD;
369:
370: x_return_status := fnd_api.g_ret_sts_error;
371:
372: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
373: p_count => x_msg_count,
374: p_data => x_msg_data);
375:
376: -- Debug info.

Line 388: WHEN fnd_api.g_exc_unexpected_error THEN

384: hz_utility_v2pub.debug(p_message=>'save_org_contact_roles(-)',
385: p_prefix=>l_debug_prefix,
386: p_msg_level=>fnd_log.level_procedure);
387: END IF;
388: WHEN fnd_api.g_exc_unexpected_error THEN
389: ROLLBACK TO save_org_contact_roles_pvt;
390: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
391: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
392: FND_MSG_PUB.ADD;

Line 394: x_return_status := fnd_api.g_ret_sts_unexp_error;

390: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
391: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
392: FND_MSG_PUB.ADD;
393:
394: x_return_status := fnd_api.g_ret_sts_unexp_error;
395:
396: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
397: p_count => x_msg_count,
398: p_data => x_msg_data);

Line 396: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

392: FND_MSG_PUB.ADD;
393:
394: x_return_status := fnd_api.g_ret_sts_unexp_error;
395:
396: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
397: p_count => x_msg_count,
398: p_data => x_msg_data);
399:
400: -- Debug info.

Line 418: x_return_status := fnd_api.g_ret_sts_unexp_error;

414: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
415: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ORG_CONTACT_ROLES');
416: FND_MSG_PUB.ADD;
417:
418: x_return_status := fnd_api.g_ret_sts_unexp_error;
419:
420: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
421: fnd_message.set_token('ERROR' ,SQLERRM);
422: fnd_msg_pub.add;

Line 424: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

420: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
421: fnd_message.set_token('ERROR' ,SQLERRM);
422: fnd_msg_pub.add;
423:
424: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
425: p_count => x_msg_count,
426: p_data => x_msg_data);
427:
428: -- Debug info.

Line 458: -- be fnd_api.g_ret_sts_success (success),

454: -- p_parent_org_os Parent organization original system.
455: -- p_parent_org_osr Parent organization original system reference.
456: -- OUT:
457: -- x_return_status Return status after the call. The status can
458: -- be fnd_api.g_ret_sts_success (success),
459: -- fnd_api.g_ret_sts_error (error),
460: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
461: -- x_msg_count Number of messages in message stack.
462: -- x_msg_data Message text if x_msg_count is 1.

Line 459: -- fnd_api.g_ret_sts_error (error),

455: -- p_parent_org_osr Parent organization original system reference.
456: -- OUT:
457: -- x_return_status Return status after the call. The status can
458: -- be fnd_api.g_ret_sts_success (success),
459: -- fnd_api.g_ret_sts_error (error),
460: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
461: -- x_msg_count Number of messages in message stack.
462: -- x_msg_data Message text if x_msg_count is 1.
463: --

Line 460: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

456: -- OUT:
457: -- x_return_status Return status after the call. The status can
458: -- be fnd_api.g_ret_sts_success (success),
459: -- fnd_api.g_ret_sts_error (error),
460: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
461: -- x_msg_count Number of messages in message stack.
462: -- x_msg_data Message text if x_msg_count is 1.
463: --
464: -- NOTES

Line 491: x_return_status := FND_API.G_RET_STS_SUCCESS;

487: l_parent_org_osr VARCHAR2(255);
488: l_cbm VARCHAR2(30);
489: BEGIN
490: -- initialize API return status to success.
491: x_return_status := FND_API.G_RET_STS_SUCCESS;
492:
493: -- Debug info.
494: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
495: hz_utility_v2pub.debug(p_message=>'save_org_contacts(+)',

Line 512: p_init_msg_list => fnd_api.g_false,

508: -- Create logical org contact
509: -----------------------------
510: FOR i IN 1..p_oc_objs.COUNT LOOP
511: HZ_ORG_CONTACT_BO_PUB.do_create_org_contact_bo(
512: p_init_msg_list => fnd_api.g_false,
513: p_validate_bo_flag => fnd_api.g_false,
514: p_org_contact_obj => p_oc_objs(i),
515: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
516: p_obj_source => p_obj_source,

Line 513: p_validate_bo_flag => fnd_api.g_false,

509: -----------------------------
510: FOR i IN 1..p_oc_objs.COUNT LOOP
511: HZ_ORG_CONTACT_BO_PUB.do_create_org_contact_bo(
512: p_init_msg_list => fnd_api.g_false,
513: p_validate_bo_flag => fnd_api.g_false,
514: p_org_contact_obj => p_oc_objs(i),
515: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
516: p_obj_source => p_obj_source,
517: x_return_status => x_return_status,

Line 528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

524: px_parent_org_os => l_parent_org_os,
525: px_parent_org_osr => l_parent_org_osr
526: );
527:
528: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
529: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
530: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contacts, parent id: '||l_parent_org_id||' '||l_parent_org_os||'-'||l_parent_org_osr,
531: p_prefix=>l_debug_prefix,
532: p_msg_level=>fnd_log.level_procedure);

Line 534: RAISE fnd_api.g_exc_error;

530: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contacts, parent id: '||l_parent_org_id||' '||l_parent_org_os||'-'||l_parent_org_osr,
531: p_prefix=>l_debug_prefix,
532: p_msg_level=>fnd_log.level_procedure);
533: END IF;
534: RAISE fnd_api.g_exc_error;
535: END IF;
536:
537: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
538: END LOOP;

Line 545: p_init_msg_list => fnd_api.g_false,

541: -- Create/Update logical org contact
542: ------------------------------------
543: FOR i IN 1..p_oc_objs.COUNT LOOP
544: HZ_ORG_CONTACT_BO_PUB.do_save_org_contact_bo(
545: p_init_msg_list => fnd_api.g_false,
546: p_validate_bo_flag => fnd_api.g_false,
547: p_org_contact_obj => p_oc_objs(i),
548: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
549: p_obj_source => p_obj_source,

Line 546: p_validate_bo_flag => fnd_api.g_false,

542: ------------------------------------
543: FOR i IN 1..p_oc_objs.COUNT LOOP
544: HZ_ORG_CONTACT_BO_PUB.do_save_org_contact_bo(
545: p_init_msg_list => fnd_api.g_false,
546: p_validate_bo_flag => fnd_api.g_false,
547: p_org_contact_obj => p_oc_objs(i),
548: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
549: p_obj_source => p_obj_source,
550: x_return_status => x_return_status,

Line 561: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

557: px_parent_org_os => l_parent_org_os,
558: px_parent_org_osr => l_parent_org_osr
559: );
560:
561: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
562: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
563: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contacts, parent id: '||l_parent_org_id||' '||l_parent_org_os||'-'||l_parent_org_osr,
564: p_prefix=>l_debug_prefix,
565: p_msg_level=>fnd_log.level_procedure);

Line 567: RAISE fnd_api.g_exc_error;

563: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_org_contact_bo_pvt.save_org_contacts, parent id: '||l_parent_org_id||' '||l_parent_org_os||'-'||l_parent_org_osr,
564: p_prefix=>l_debug_prefix,
565: p_msg_level=>fnd_log.level_procedure);
566: END IF;
567: RAISE fnd_api.g_exc_error;
568: END IF;
569:
570: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
571: END LOOP;

Line 588: WHEN fnd_api.g_exc_error THEN

584: p_msg_level=>fnd_log.level_procedure);
585: END IF;
586:
587: EXCEPTION
588: WHEN fnd_api.g_exc_error THEN
589: x_return_status := fnd_api.g_ret_sts_error;
590:
591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
592: p_count => x_msg_count,

Line 589: x_return_status := fnd_api.g_ret_sts_error;

585: END IF;
586:
587: EXCEPTION
588: WHEN fnd_api.g_exc_error THEN
589: x_return_status := fnd_api.g_ret_sts_error;
590:
591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
592: p_count => x_msg_count,
593: p_data => x_msg_data);

Line 591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

587: EXCEPTION
588: WHEN fnd_api.g_exc_error THEN
589: x_return_status := fnd_api.g_ret_sts_error;
590:
591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
592: p_count => x_msg_count,
593: p_data => x_msg_data);
594:
595: -- Debug info.

Line 607: WHEN fnd_api.g_exc_unexpected_error THEN

603: hz_utility_v2pub.debug(p_message=>'save_org_contacts(-)',
604: p_prefix=>l_debug_prefix,
605: p_msg_level=>fnd_log.level_procedure);
606: END IF;
607: WHEN fnd_api.g_exc_unexpected_error THEN
608: x_return_status := fnd_api.g_ret_sts_unexp_error;
609:
610: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
611: p_count => x_msg_count,

Line 608: x_return_status := fnd_api.g_ret_sts_unexp_error;

604: p_prefix=>l_debug_prefix,
605: p_msg_level=>fnd_log.level_procedure);
606: END IF;
607: WHEN fnd_api.g_exc_unexpected_error THEN
608: x_return_status := fnd_api.g_ret_sts_unexp_error;
609:
610: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
611: p_count => x_msg_count,
612: p_data => x_msg_data);

Line 610: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

606: END IF;
607: WHEN fnd_api.g_exc_unexpected_error THEN
608: x_return_status := fnd_api.g_ret_sts_unexp_error;
609:
610: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
611: p_count => x_msg_count,
612: p_data => x_msg_data);
613:
614: -- Debug info.

Line 627: x_return_status := fnd_api.g_ret_sts_unexp_error;

623: p_prefix=>l_debug_prefix,
624: p_msg_level=>fnd_log.level_procedure);
625: END IF;
626: WHEN OTHERS THEN
627: x_return_status := fnd_api.g_ret_sts_unexp_error;
628:
629: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
630: fnd_message.set_token('ERROR' ,SQLERRM);
631: fnd_msg_pub.add;

Line 633: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

629: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
630: fnd_message.set_token('ERROR' ,SQLERRM);
631: fnd_msg_pub.add;
632:
633: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
634: p_count => x_msg_count,
635: p_data => x_msg_data);
636:
637: -- Debug info.