eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_CUST_ACCT_CONTACT_BO_PVT dependencies on FND_API

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

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

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

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

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

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

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

142: x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data
144: );
145:
146: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
147: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
148: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.create_role_responsibilities, cust acct contact id: '||p_cac_id,
149: p_prefix=>l_debug_prefix,
150: p_msg_level=>fnd_log.level_procedure);

Line 152: RAISE fnd_api.g_exc_error;

148: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.create_role_responsibilities, cust acct contact id: '||p_cac_id,
149: p_prefix=>l_debug_prefix,
150: p_msg_level=>fnd_log.level_procedure);
151: END IF;
152: RAISE fnd_api.g_exc_error;
153: END IF;
154:
155: -- assign role_responsibility_id
156: p_rr_objs(i).responsibility_id := l_rr_id;

Line 173: WHEN fnd_api.g_exc_error THEN

169: p_msg_level=>fnd_log.level_procedure);
170: END IF;
171:
172: EXCEPTION
173: WHEN fnd_api.g_exc_error THEN
174: ROLLBACK TO create_rr_pvt;
175: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
176: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
177: FND_MSG_PUB.ADD;

Line 179: x_return_status := fnd_api.g_ret_sts_error;

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

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

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

Line 198: WHEN fnd_api.g_exc_unexpected_error THEN

194: p_prefix=>l_debug_prefix,
195: p_msg_level=>fnd_log.level_procedure);
196: END IF;
197:
198: WHEN fnd_api.g_exc_unexpected_error THEN
199: ROLLBACK TO create_rr_pvt;
200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
201: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
202: FND_MSG_PUB.ADD;

Line 204: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

202: FND_MSG_PUB.ADD;
203:
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205:
206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
207: p_count => x_msg_count,
208: p_data => x_msg_data);
209:
210: -- 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_ROLE_RESPONSIBILITY');
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 266: -- be fnd_api.g_ret_sts_success (success),

262: -- p_rr_objs List of role responsibility objects.
263: -- p_cac_id Customer account contact Id.
264: -- OUT:
265: -- x_return_status Return status after the call. The status can
266: -- be fnd_api.g_ret_sts_success (success),
267: -- fnd_api.g_ret_sts_error (error),
268: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
269: -- x_msg_count Number of messages in message stack.
270: -- x_msg_data Message text if x_msg_count is 1.

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

263: -- p_cac_id Customer account contact Id.
264: -- OUT:
265: -- x_return_status Return status after the call. The status can
266: -- be fnd_api.g_ret_sts_success (success),
267: -- fnd_api.g_ret_sts_error (error),
268: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
269: -- x_msg_count Number of messages in message stack.
270: -- x_msg_data Message text if x_msg_count is 1.
271: --

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

264: -- OUT:
265: -- x_return_status Return status after the call. The status can
266: -- be fnd_api.g_ret_sts_success (success),
267: -- fnd_api.g_ret_sts_error (error),
268: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
269: -- x_msg_count Number of messages in message stack.
270: -- x_msg_data Message text if x_msg_count is 1.
271: --
272: -- NOTES

Line 294: x_return_status := FND_API.G_RET_STS_SUCCESS;

290: -- Standard start of API savepoint
291: SAVEPOINT save_rr_pvt;
292:
293: -- initialize API return status to success.
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: -- Debug info.
297: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
298: hz_utility_v2pub.debug(p_message=>'save_role_responsibilities(+)',

Line 330: RAISE fnd_api.g_exc_error;

326: FND_MSG_PUB.ADD;
327: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
328: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
329: FND_MSG_PUB.ADD;
330: RAISE fnd_api.g_exc_error;
331: END IF;
332:
333: IF(l_ovn IS NULL) THEN
334: HZ_CUST_ACCOUNT_ROLE_V2PUB.create_role_responsibility (

Line 359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

355: -- assign role_responsibility_id
356: p_rr_objs(i).responsibility_id := l_rr_rec.responsibility_id;
357: END IF;
358:
359: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
360: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
361: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_role_responsibilities, cust acct contact id: '||p_cac_id,
362: p_prefix=>l_debug_prefix,
363: p_msg_level=>fnd_log.level_procedure);

Line 365: RAISE fnd_api.g_exc_error;

361: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_role_responsibilities, cust acct contact id: '||p_cac_id,
362: p_prefix=>l_debug_prefix,
363: p_msg_level=>fnd_log.level_procedure);
364: END IF;
365: RAISE fnd_api.g_exc_error;
366: END IF;
367:
368: END LOOP;
369:

Line 383: WHEN fnd_api.g_exc_error THEN

379: p_prefix=>l_debug_prefix,
380: p_msg_level=>fnd_log.level_procedure);
381: END IF;
382: EXCEPTION
383: WHEN fnd_api.g_exc_error THEN
384: ROLLBACK TO save_rr_pvt;
385: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
386: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
387: FND_MSG_PUB.ADD;

Line 389: x_return_status := fnd_api.g_ret_sts_error;

385: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
386: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
387: FND_MSG_PUB.ADD;
388:
389: x_return_status := fnd_api.g_ret_sts_error;
390:
391: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
392: p_count => x_msg_count,
393: p_data => x_msg_data);

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

387: FND_MSG_PUB.ADD;
388:
389: x_return_status := fnd_api.g_ret_sts_error;
390:
391: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
392: p_count => x_msg_count,
393: p_data => x_msg_data);
394:
395: -- Debug info.

Line 408: WHEN fnd_api.g_exc_unexpected_error THEN

404: p_prefix=>l_debug_prefix,
405: p_msg_level=>fnd_log.level_procedure);
406: END IF;
407:
408: WHEN fnd_api.g_exc_unexpected_error THEN
409: ROLLBACK TO save_rr_pvt;
410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
411: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
412: FND_MSG_PUB.ADD;

Line 414: x_return_status := fnd_api.g_ret_sts_unexp_error;

410: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
411: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
412: FND_MSG_PUB.ADD;
413:
414: x_return_status := fnd_api.g_ret_sts_unexp_error;
415:
416: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
417: p_count => x_msg_count,
418: p_data => x_msg_data);

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

412: FND_MSG_PUB.ADD;
413:
414: x_return_status := fnd_api.g_ret_sts_unexp_error;
415:
416: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
417: p_count => x_msg_count,
418: p_data => x_msg_data);
419:
420: -- Debug info.

Line 439: x_return_status := fnd_api.g_ret_sts_unexp_error;

435: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
436: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_ROLE_RESPONSIBILITY');
437: FND_MSG_PUB.ADD;
438:
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440:
441: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
442: fnd_message.set_token('ERROR' ,SQLERRM);
443: fnd_msg_pub.add;

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

441: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
442: fnd_message.set_token('ERROR' ,SQLERRM);
443: fnd_msg_pub.add;
444:
445: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
446: p_count => x_msg_count,
447: p_data => x_msg_data);
448:
449: -- Debug info.

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

476: -- p_parent_osr Parent original system reference.
477: -- p_parent_obj_type Parent object type.
478: -- OUT:
479: -- x_return_status Return status after the call. The status can
480: -- be fnd_api.g_ret_sts_success (success),
481: -- fnd_api.g_ret_sts_error (error),
482: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
483: -- x_msg_count Number of messages in message stack.
484: -- x_msg_data Message text if x_msg_count is 1.

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

477: -- p_parent_obj_type Parent object type.
478: -- OUT:
479: -- x_return_status Return status after the call. The status can
480: -- be fnd_api.g_ret_sts_success (success),
481: -- fnd_api.g_ret_sts_error (error),
482: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
483: -- x_msg_count Number of messages in message stack.
484: -- x_msg_data Message text if x_msg_count is 1.
485: --

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

478: -- OUT:
479: -- x_return_status Return status after the call. The status can
480: -- be fnd_api.g_ret_sts_success (success),
481: -- fnd_api.g_ret_sts_error (error),
482: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
483: -- x_msg_count Number of messages in message stack.
484: -- x_msg_data Message text if x_msg_count is 1.
485: --
486: -- NOTES

Line 515: x_return_status := FND_API.G_RET_STS_SUCCESS;

511: l_parent_obj_type VARCHAR2(30);
512: l_cbm VARCHAR2(30);
513: BEGIN
514: -- initialize API return status to success
515: x_return_status := FND_API.G_RET_STS_SUCCESS;
516:
517: -- Debug info.
518: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
519: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(+)',

Line 535: p_init_msg_list => fnd_api.g_false,

531: IF(p_create_update_flag = 'C') THEN
532: -- Create cust account contact
533: FOR i IN 1..p_cac_objs.COUNT LOOP
534: HZ_CUST_ACCT_CONTACT_BO_PUB.do_create_cac_bo(
535: p_init_msg_list => fnd_api.g_false,
536: p_validate_bo_flag => fnd_api.g_false,
537: p_cust_acct_contact_obj => p_cac_objs(i),
538: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
539: p_obj_source => p_obj_source,

Line 536: p_validate_bo_flag => fnd_api.g_false,

532: -- Create cust account contact
533: FOR i IN 1..p_cac_objs.COUNT LOOP
534: HZ_CUST_ACCT_CONTACT_BO_PUB.do_create_cac_bo(
535: p_init_msg_list => fnd_api.g_false,
536: p_validate_bo_flag => fnd_api.g_false,
537: p_cust_acct_contact_obj => p_cac_objs(i),
538: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
539: p_obj_source => p_obj_source,
540: x_return_status => x_return_status,

Line 552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

548: px_parent_osr => l_parent_osr,
549: px_parent_obj_type => l_parent_obj_type
550: );
551:
552: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
553: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
554: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
555: p_prefix=>l_debug_prefix,
556: p_msg_level=>fnd_log.level_procedure);

Line 558: RAISE fnd_api.g_exc_error;

554: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
555: p_prefix=>l_debug_prefix,
556: p_msg_level=>fnd_log.level_procedure);
557: END IF;
558: RAISE fnd_api.g_exc_error;
559: END IF;
560:
561: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
562: END LOOP;

Line 567: p_init_msg_list => fnd_api.g_false,

563: ELSE
564: -- Create/update cust account contact
565: FOR i IN 1..p_cac_objs.COUNT LOOP
566: HZ_CUST_ACCT_CONTACT_BO_PUB.do_save_cac_bo(
567: p_init_msg_list => fnd_api.g_false,
568: p_validate_bo_flag => fnd_api.g_false,
569: p_cust_acct_contact_obj => p_cac_objs(i),
570: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
571: p_obj_source => p_obj_source,

Line 568: p_validate_bo_flag => fnd_api.g_false,

564: -- Create/update cust account contact
565: FOR i IN 1..p_cac_objs.COUNT LOOP
566: HZ_CUST_ACCT_CONTACT_BO_PUB.do_save_cac_bo(
567: p_init_msg_list => fnd_api.g_false,
568: p_validate_bo_flag => fnd_api.g_false,
569: p_cust_acct_contact_obj => p_cac_objs(i),
570: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
571: p_obj_source => p_obj_source,
572: x_return_status => x_return_status,

Line 584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

580: px_parent_osr => l_parent_osr,
581: px_parent_obj_type => l_parent_obj_type
582: );
583:
584: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
585: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
586: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
587: p_prefix=>l_debug_prefix,
588: p_msg_level=>fnd_log.level_procedure);

Line 590: RAISE fnd_api.g_exc_error;

586: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_cust_acct_contact_bo_pvt.save_cust_acct_contacts, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
587: p_prefix=>l_debug_prefix,
588: p_msg_level=>fnd_log.level_procedure);
589: END IF;
590: RAISE fnd_api.g_exc_error;
591: END IF;
592:
593: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
594: END LOOP;

Line 610: WHEN fnd_api.g_exc_error THEN

606: p_prefix=>l_debug_prefix,
607: p_msg_level=>fnd_log.level_procedure);
608: END IF;
609: EXCEPTION
610: WHEN fnd_api.g_exc_error THEN
611: x_return_status := fnd_api.g_ret_sts_error;
612:
613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
614: p_count => x_msg_count,

Line 611: x_return_status := fnd_api.g_ret_sts_error;

607: p_msg_level=>fnd_log.level_procedure);
608: END IF;
609: EXCEPTION
610: WHEN fnd_api.g_exc_error THEN
611: x_return_status := fnd_api.g_ret_sts_error;
612:
613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
614: p_count => x_msg_count,
615: p_data => x_msg_data);

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

609: EXCEPTION
610: WHEN fnd_api.g_exc_error THEN
611: x_return_status := fnd_api.g_ret_sts_error;
612:
613: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
614: p_count => x_msg_count,
615: p_data => x_msg_data);
616:
617: -- Debug info.

Line 629: WHEN fnd_api.g_exc_unexpected_error THEN

625: hz_utility_v2pub.debug(p_message=>'save_cust_acct_contacts(-)',
626: p_prefix=>l_debug_prefix,
627: p_msg_level=>fnd_log.level_procedure);
628: END IF;
629: WHEN fnd_api.g_exc_unexpected_error THEN
630: x_return_status := fnd_api.g_ret_sts_unexp_error;
631:
632: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
633: p_count => x_msg_count,

Line 630: x_return_status := fnd_api.g_ret_sts_unexp_error;

626: p_prefix=>l_debug_prefix,
627: p_msg_level=>fnd_log.level_procedure);
628: END IF;
629: WHEN fnd_api.g_exc_unexpected_error THEN
630: x_return_status := fnd_api.g_ret_sts_unexp_error;
631:
632: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
633: p_count => x_msg_count,
634: p_data => x_msg_data);

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

628: END IF;
629: WHEN fnd_api.g_exc_unexpected_error THEN
630: x_return_status := fnd_api.g_ret_sts_unexp_error;
631:
632: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
633: p_count => x_msg_count,
634: p_data => x_msg_data);
635:
636: -- Debug info.

Line 649: x_return_status := fnd_api.g_ret_sts_unexp_error;

645: p_prefix=>l_debug_prefix,
646: p_msg_level=>fnd_log.level_procedure);
647: END IF;
648: WHEN OTHERS THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650:
651: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
652: fnd_message.set_token('ERROR' ,SQLERRM);
653: fnd_msg_pub.add;

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

651: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
652: fnd_message.set_token('ERROR' ,SQLERRM);
653: fnd_msg_pub.add;
654:
655: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
656: p_count => x_msg_count,
657: p_data => x_msg_data);
658:
659: -- Debug info.