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

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

80: -- p_psu_objs List of party site use objects.
81: -- p_ps_id Party site Id.
82: -- OUT:
83: -- x_return_status Return status after the call. The status can
84: -- be fnd_api.g_ret_sts_success (success),
85: -- fnd_api.g_ret_sts_error (error),
86: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
87: -- x_msg_count Number of messages in message stack.
88: -- x_msg_data Message text if x_msg_count is 1.

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

81: -- p_ps_id Party site Id.
82: -- OUT:
83: -- x_return_status Return status after the call. The status can
84: -- be fnd_api.g_ret_sts_success (success),
85: -- fnd_api.g_ret_sts_error (error),
86: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
87: -- x_msg_count Number of messages in message stack.
88: -- x_msg_data Message text if x_msg_count is 1.
89: --

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

82: -- OUT:
83: -- x_return_status Return status after the call. The status can
84: -- be fnd_api.g_ret_sts_success (success),
85: -- fnd_api.g_ret_sts_error (error),
86: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
87: -- x_msg_count Number of messages in message stack.
88: -- x_msg_data Message text if x_msg_count is 1.
89: --
90: -- NOTES

Line 112: x_return_status := FND_API.G_RET_STS_SUCCESS;

108: -- Standard start of API savepoint
109: SAVEPOINT create_party_site_uses_pvt;
110:
111: -- initialize API return status to success.
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113:
114: -- Debug info.
115: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
116: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(+)',

Line 137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

133: x_msg_count => x_msg_count,
134: x_msg_data => x_msg_data
135: );
136:
137: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
138: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
139: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.create_party_site_uses: party_site_id: '||p_ps_id,
140: p_prefix=>l_debug_prefix,
141: p_msg_level=>fnd_log.level_procedure);

Line 143: RAISE fnd_api.g_exc_error;

139: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.create_party_site_uses: party_site_id: '||p_ps_id,
140: p_prefix=>l_debug_prefix,
141: p_msg_level=>fnd_log.level_procedure);
142: END IF;
143: RAISE fnd_api.g_exc_error;
144: END IF;
145:
146: -- assign party_site_id and party_site_use_id
147: p_psu_objs(i).party_site_use_id := l_psu_id;

Line 163: WHEN fnd_api.g_exc_error THEN

159: p_prefix=>l_debug_prefix,
160: p_msg_level=>fnd_log.level_procedure);
161: END IF;
162: EXCEPTION
163: WHEN fnd_api.g_exc_error THEN
164: ROLLBACK TO create_party_site_uses_pvt;
165: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
166: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
167: FND_MSG_PUB.ADD;

Line 169: x_return_status := fnd_api.g_ret_sts_error;

165: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
166: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
167: FND_MSG_PUB.ADD;
168:
169: x_return_status := fnd_api.g_ret_sts_error;
170:
171: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
172: p_count => x_msg_count,
173: p_data => x_msg_data);

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

167: FND_MSG_PUB.ADD;
168:
169: x_return_status := fnd_api.g_ret_sts_error;
170:
171: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
172: p_count => x_msg_count,
173: p_data => x_msg_data);
174:
175: -- Debug info.

Line 187: WHEN fnd_api.g_exc_unexpected_error THEN

183: hz_utility_v2pub.debug(p_message=>'create_party_site_uses(-)',
184: p_prefix=>l_debug_prefix,
185: p_msg_level=>fnd_log.level_procedure);
186: END IF;
187: WHEN fnd_api.g_exc_unexpected_error THEN
188: ROLLBACK TO create_party_site_uses_pvt;
189: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
190: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
191: FND_MSG_PUB.ADD;

Line 193: x_return_status := fnd_api.g_ret_sts_unexp_error;

189: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
190: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
191: FND_MSG_PUB.ADD;
192:
193: x_return_status := fnd_api.g_ret_sts_unexp_error;
194:
195: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
196: p_count => x_msg_count,
197: p_data => x_msg_data);

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

191: FND_MSG_PUB.ADD;
192:
193: x_return_status := fnd_api.g_ret_sts_unexp_error;
194:
195: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
196: p_count => x_msg_count,
197: p_data => x_msg_data);
198:
199: -- Debug info.

Line 218: x_return_status := fnd_api.g_ret_sts_unexp_error;

214: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
215: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
216: FND_MSG_PUB.ADD;
217:
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219:
220: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
221: fnd_message.set_token('ERROR' ,SQLERRM);
222: fnd_msg_pub.add;

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

220: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
221: fnd_message.set_token('ERROR' ,SQLERRM);
222: fnd_msg_pub.add;
223:
224: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
225: p_count => x_msg_count,
226: p_data => x_msg_data);
227:
228: -- Debug info.

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

251: -- p_psu_objs List of party site use objects.
252: -- p_ps_id Party site Id.
253: -- OUT:
254: -- x_return_status Return status after the call. The status can
255: -- be fnd_api.g_ret_sts_success (success),
256: -- fnd_api.g_ret_sts_error (error),
257: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
258: -- x_msg_count Number of messages in message stack.
259: -- x_msg_data Message text if x_msg_count is 1.

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

252: -- p_ps_id Party site Id.
253: -- OUT:
254: -- x_return_status Return status after the call. The status can
255: -- be fnd_api.g_ret_sts_success (success),
256: -- fnd_api.g_ret_sts_error (error),
257: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
258: -- x_msg_count Number of messages in message stack.
259: -- x_msg_data Message text if x_msg_count is 1.
260: --

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

253: -- OUT:
254: -- x_return_status Return status after the call. The status can
255: -- be fnd_api.g_ret_sts_success (success),
256: -- fnd_api.g_ret_sts_error (error),
257: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
258: -- x_msg_count Number of messages in message stack.
259: -- x_msg_data Message text if x_msg_count is 1.
260: --
261: -- NOTES

Line 284: x_return_status := FND_API.G_RET_STS_SUCCESS;

280: -- Standard start of API savepoint
281: SAVEPOINT save_party_site_uses_pvt;
282:
283: -- initialize API return status to success.
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285:
286: -- Debug info.
287: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
288: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(+)',

Line 320: RAISE FND_API.G_EXC_ERROR;

316: FND_MSG_PUB.ADD;
317: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
318: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
319: FND_MSG_PUB.ADD;
320: RAISE FND_API.G_EXC_ERROR;
321: END IF;
322:
323: IF(l_ovn IS NULL) THEN
324: HZ_PARTY_SITE_V2PUB.create_party_site_use(

Line 349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

345: -- assign party_site_use_id
346: p_psu_objs(i).party_site_use_id := l_psu_rec.party_site_use_id;
347: END IF;
348:
349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
350: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
351: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_site_uses: party_site_id: '||p_ps_id,
352: p_prefix=>l_debug_prefix,
353: p_msg_level=>fnd_log.level_procedure);

Line 355: RAISE fnd_api.g_exc_error;

351: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_site_uses: party_site_id: '||p_ps_id,
352: p_prefix=>l_debug_prefix,
353: p_msg_level=>fnd_log.level_procedure);
354: END IF;
355: RAISE fnd_api.g_exc_error;
356: END IF;
357: END LOOP;
358:
359: -- Debug info.

Line 372: WHEN fnd_api.g_exc_error THEN

368: p_prefix=>l_debug_prefix,
369: p_msg_level=>fnd_log.level_procedure);
370: END IF;
371: EXCEPTION
372: WHEN fnd_api.g_exc_error THEN
373: ROLLBACK TO save_party_site_uses_pvt;
374: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
375: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
376: FND_MSG_PUB.ADD;

Line 378: x_return_status := fnd_api.g_ret_sts_error;

374: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
375: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
376: FND_MSG_PUB.ADD;
377:
378: x_return_status := fnd_api.g_ret_sts_error;
379:
380: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
381: p_count => x_msg_count,
382: p_data => x_msg_data);

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

376: FND_MSG_PUB.ADD;
377:
378: x_return_status := fnd_api.g_ret_sts_error;
379:
380: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
381: p_count => x_msg_count,
382: p_data => x_msg_data);
383:
384: -- Debug info.

Line 396: WHEN fnd_api.g_exc_unexpected_error THEN

392: hz_utility_v2pub.debug(p_message=>'save_party_site_uses(-)',
393: p_prefix=>l_debug_prefix,
394: p_msg_level=>fnd_log.level_procedure);
395: END IF;
396: WHEN fnd_api.g_exc_unexpected_error THEN
397: ROLLBACK TO save_party_site_uses_pvt;
398: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
399: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
400: FND_MSG_PUB.ADD;

Line 402: x_return_status := fnd_api.g_ret_sts_unexp_error;

398: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
399: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
400: FND_MSG_PUB.ADD;
401:
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403:
404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
405: p_count => x_msg_count,
406: p_data => x_msg_data);

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

400: FND_MSG_PUB.ADD;
401:
402: x_return_status := fnd_api.g_ret_sts_unexp_error;
403:
404: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
405: p_count => x_msg_count,
406: p_data => x_msg_data);
407:
408: -- Debug info.

Line 427: x_return_status := fnd_api.g_ret_sts_unexp_error;

423: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
424: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_SITE_USES');
425: FND_MSG_PUB.ADD;
426:
427: x_return_status := fnd_api.g_ret_sts_unexp_error;
428:
429: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
430: fnd_message.set_token('ERROR' ,SQLERRM);
431: fnd_msg_pub.add;

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

429: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
430: fnd_message.set_token('ERROR' ,SQLERRM);
431: fnd_msg_pub.add;
432:
433: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
434: p_count => x_msg_count,
435: p_data => x_msg_data);
436:
437: -- Debug info.

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

464: -- p_parent_osr Parent original system reference.
465: -- p_parent_obj_type Parent object type.
466: -- OUT:
467: -- x_return_status Return status after the call. The status can
468: -- be fnd_api.g_ret_sts_success (success),
469: -- fnd_api.g_ret_sts_error (error),
470: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
471: -- x_msg_count Number of messages in message stack.
472: -- x_msg_data Message text if x_msg_count is 1.

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

465: -- p_parent_obj_type Parent object type.
466: -- OUT:
467: -- x_return_status Return status after the call. The status can
468: -- be fnd_api.g_ret_sts_success (success),
469: -- fnd_api.g_ret_sts_error (error),
470: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
471: -- x_msg_count Number of messages in message stack.
472: -- x_msg_data Message text if x_msg_count is 1.
473: --

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

466: -- OUT:
467: -- x_return_status Return status after the call. The status can
468: -- be fnd_api.g_ret_sts_success (success),
469: -- fnd_api.g_ret_sts_error (error),
470: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
471: -- x_msg_count Number of messages in message stack.
472: -- x_msg_data Message text if x_msg_count is 1.
473: --
474: -- NOTES

Line 504: x_return_status := FND_API.G_RET_STS_SUCCESS;

500: l_parent_obj_type VARCHAR2(30);
501: l_cbm VARCHAR2(30);
502: BEGIN
503: -- initialize API return status to success.
504: x_return_status := FND_API.G_RET_STS_SUCCESS;
505:
506: -- Debug info.
507: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
508: hz_utility_v2pub.debug(p_message=>'save_party_sites(+)',

Line 526: p_init_msg_list => fnd_api.g_false,

522: -- Create logical party site
523: ----------------------------
524: FOR i IN 1..p_ps_objs.COUNT LOOP
525: HZ_PARTY_SITE_BO_PUB.do_create_party_site_bo(
526: p_init_msg_list => fnd_api.g_false,
527: p_validate_bo_flag => FND_API.G_FALSE,
528: p_party_site_obj => p_ps_objs(i),
529: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
530: p_obj_source => p_obj_source,

Line 527: p_validate_bo_flag => FND_API.G_FALSE,

523: ----------------------------
524: FOR i IN 1..p_ps_objs.COUNT LOOP
525: HZ_PARTY_SITE_BO_PUB.do_create_party_site_bo(
526: p_init_msg_list => fnd_api.g_false,
527: p_validate_bo_flag => FND_API.G_FALSE,
528: p_party_site_obj => p_ps_objs(i),
529: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
530: p_obj_source => p_obj_source,
531: x_return_status => x_return_status,

Line 543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

539: px_parent_osr => l_parent_osr,
540: px_parent_obj_type => l_parent_obj_type
541: );
542:
543: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
544: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
545: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
546: p_prefix=>l_debug_prefix,
547: p_msg_level=>fnd_log.level_procedure);

Line 549: RAISE fnd_api.g_exc_error;

545: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
546: p_prefix=>l_debug_prefix,
547: p_msg_level=>fnd_log.level_procedure);
548: END IF;
549: RAISE fnd_api.g_exc_error;
550: END IF;
551:
552: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
553: END LOOP;

Line 560: p_init_msg_list => fnd_api.g_false,

556: -- Create/Update logical party site
557: ------------------------------------
558: FOR i IN 1..p_ps_objs.COUNT LOOP
559: HZ_PARTY_SITE_BO_PUB.do_save_party_site_bo(
560: p_init_msg_list => fnd_api.g_false,
561: p_validate_bo_flag => FND_API.G_FALSE,
562: p_party_site_obj => p_ps_objs(i),
563: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
564: p_obj_source => p_obj_source,

Line 561: p_validate_bo_flag => FND_API.G_FALSE,

557: ------------------------------------
558: FOR i IN 1..p_ps_objs.COUNT LOOP
559: HZ_PARTY_SITE_BO_PUB.do_save_party_site_bo(
560: p_init_msg_list => fnd_api.g_false,
561: p_validate_bo_flag => FND_API.G_FALSE,
562: p_party_site_obj => p_ps_objs(i),
563: p_created_by_module => HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE,
564: p_obj_source => p_obj_source,
565: x_return_status => x_return_status,

Line 577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

573: px_parent_osr => l_parent_osr,
574: px_parent_obj_type => l_parent_obj_type
575: );
576:
577: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
578: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
579: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
580: p_prefix=>l_debug_prefix,
581: p_msg_level=>fnd_log.level_procedure);

Line 583: RAISE fnd_api.g_exc_error;

579: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_site_bo_pvt.save_party_sites_bo, parent id: '||l_parent_id||' '||l_parent_os||'-'||l_parent_osr,
580: p_prefix=>l_debug_prefix,
581: p_msg_level=>fnd_log.level_procedure);
582: END IF;
583: RAISE fnd_api.g_exc_error;
584: END IF;
585:
586: HZ_UTILITY_V2PUB.G_CREATED_BY_MODULE := l_cbm;
587: END LOOP;

Line 604: WHEN fnd_api.g_exc_error THEN

600: p_msg_level=>fnd_log.level_procedure);
601: END IF;
602:
603: EXCEPTION
604: WHEN fnd_api.g_exc_error THEN
605: x_return_status := fnd_api.g_ret_sts_error;
606:
607: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
608: p_count => x_msg_count,

Line 605: x_return_status := fnd_api.g_ret_sts_error;

601: END IF;
602:
603: EXCEPTION
604: WHEN fnd_api.g_exc_error THEN
605: x_return_status := fnd_api.g_ret_sts_error;
606:
607: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
608: p_count => x_msg_count,
609: p_data => x_msg_data);

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

603: EXCEPTION
604: WHEN fnd_api.g_exc_error THEN
605: x_return_status := fnd_api.g_ret_sts_error;
606:
607: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
608: p_count => x_msg_count,
609: p_data => x_msg_data);
610:
611: -- Debug info.

Line 623: WHEN fnd_api.g_exc_unexpected_error THEN

619: hz_utility_v2pub.debug(p_message=>'save_party_sites(-)',
620: p_prefix=>l_debug_prefix,
621: p_msg_level=>fnd_log.level_procedure);
622: END IF;
623: WHEN fnd_api.g_exc_unexpected_error THEN
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625:
626: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
627: p_count => x_msg_count,

Line 624: x_return_status := fnd_api.g_ret_sts_unexp_error;

620: p_prefix=>l_debug_prefix,
621: p_msg_level=>fnd_log.level_procedure);
622: END IF;
623: WHEN fnd_api.g_exc_unexpected_error THEN
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625:
626: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
627: p_count => x_msg_count,
628: p_data => x_msg_data);

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

622: END IF;
623: WHEN fnd_api.g_exc_unexpected_error THEN
624: x_return_status := fnd_api.g_ret_sts_unexp_error;
625:
626: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
627: p_count => x_msg_count,
628: p_data => x_msg_data);
629:
630: -- Debug info.

Line 644: x_return_status := fnd_api.g_ret_sts_unexp_error;

640: p_msg_level=>fnd_log.level_procedure);
641: END IF;
642:
643: WHEN OTHERS THEN
644: x_return_status := fnd_api.g_ret_sts_unexp_error;
645:
646: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
647: fnd_message.set_token('ERROR' ,SQLERRM);
648: fnd_msg_pub.add;

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

646: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
647: fnd_message.set_token('ERROR' ,SQLERRM);
648: fnd_msg_pub.add;
649:
650: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
651: p_count => x_msg_count,
652: p_data => x_msg_data);
653:
654: -- Debug info.