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

Line 119: p_style_fmt_locale_rec.start_date_active = FND_API.G_MISS_DATE

115: END IF;
116:
117: -- start_date_active default to sysdate
118: IF p_style_fmt_locale_rec.start_date_active is null OR
119: p_style_fmt_locale_rec.start_date_active = FND_API.G_MISS_DATE
120: THEN
121: p_style_fmt_locale_rec.start_date_active := sysdate;
122: END IF;
123:

Line 132: IF x_return_status = fnd_api.g_ret_sts_error THEN

128: l_rowid,
129: x_return_status
130: );
131:
132: IF x_return_status = fnd_api.g_ret_sts_error THEN
133: RAISE fnd_api.g_exc_error;
134: END IF;
135:
136: -- Debug info.

Line 133: RAISE fnd_api.g_exc_error;

129: x_return_status
130: );
131:
132: IF x_return_status = fnd_api.g_ret_sts_error THEN
133: RAISE fnd_api.g_exc_error;
134: END IF;
135:
136: -- Debug info.
137: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 215: RAISE FND_API.G_EXC_ERROR;

211: THEN
212: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
213: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_style_fmt_locales');
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;
216: END IF;
217:
218: p_object_version_number := nvl(l_object_version_number, 1) + 1;
219:

Line 225: RAISE FND_API.G_EXC_ERROR;

221: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
222: FND_MESSAGE.SET_TOKEN('RECORD', 'style format locale');
223: FND_MESSAGE.SET_TOKEN('VALUE', NVL(( p_style_fmt_locale_rec.style_fmt_locale_id), 'null'));
224: FND_MSG_PUB.ADD;
225: RAISE FND_API.G_EXC_ERROR;
226: END;
227:
228: -- validate style format locale record
229: HZ_NAME_ADDRESS_FMT_VALIDATE.validate_style_fmt_locale(

Line 235: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

231: p_style_fmt_locale_rec,
232: l_rowid,
233: x_return_status);
234:
235: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:
239: -- Debug info.

Line 236: RAISE FND_API.G_EXC_ERROR;

232: l_rowid,
233: x_return_status);
234:
235: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:
239: -- Debug info.
240: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 289: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

285: *
286: * ARGUMENTS
287: * IN:
288: * p_init_msg_list Initialize message stack if it is set to
289: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
290: * p_style_fmt_locale_rec Style format locale record.
291: * IN/OUT:
292: * OUT:
293: * p_style_fmt_locale_id style_fmt_locale id

Line 295: * be FND_API.G_RET_STS_SUCCESS (success),

291: * IN/OUT:
292: * OUT:
293: * p_style_fmt_locale_id style_fmt_locale id
294: * x_return_status Return status after the call. The status can
295: * be FND_API.G_RET_STS_SUCCESS (success),
296: * FND_API.G_RET_STS_ERROR (error),
297: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
298: * x_msg_count Number of messages in message stack.
299: * x_msg_data Message text if x_msg_count is 1.

Line 296: * FND_API.G_RET_STS_ERROR (error),

292: * OUT:
293: * p_style_fmt_locale_id style_fmt_locale id
294: * x_return_status Return status after the call. The status can
295: * be FND_API.G_RET_STS_SUCCESS (success),
296: * FND_API.G_RET_STS_ERROR (error),
297: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
298: * x_msg_count Number of messages in message stack.
299: * x_msg_data Message text if x_msg_count is 1.
300: *

Line 297: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

293: * p_style_fmt_locale_id style_fmt_locale id
294: * x_return_status Return status after the call. The status can
295: * be FND_API.G_RET_STS_SUCCESS (success),
296: * FND_API.G_RET_STS_ERROR (error),
297: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
298: * x_msg_count Number of messages in message stack.
299: * x_msg_data Message text if x_msg_count is 1.
300: *
301: * NOTES

Line 310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

306: *
307: */
308:
309: PROCEDURE create_style_fmt_locale (
310: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
311: p_style_fmt_locale_rec IN STYLE_FMT_LOCALE_REC_TYPE,
312: p_style_fmt_locale_id OUT NOCOPY NUMBER,
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,

Line 336: IF FND_API.to_Boolean(p_init_msg_list) THEN

332: p_msg_level=>fnd_log.level_procedure);
333: END IF;
334:
335: -- initialize message list if p_init_msg_list is set to TRUE.
336: IF FND_API.to_Boolean(p_init_msg_list) THEN
337: FND_MSG_PUB.initialize;
338: END IF;
339:
340: -- initialize API return status to success.

Line 341: x_return_status := FND_API.G_RET_STS_SUCCESS;

337: FND_MSG_PUB.initialize;
338: END IF;
339:
340: -- initialize API return status to success.
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: -- call to business logic.
344: do_create_style_fmt_locale(
345: l_style_fmt_locale_rec,

Line 352: p_encoded => FND_API.G_FALSE,

348: p_style_fmt_locale_id := l_style_fmt_locale_rec.style_fmt_locale_id;
349:
350: -- standard call to get message count and if count is 1, get message info.
351: FND_MSG_PUB.Count_And_Get(
352: p_encoded => FND_API.G_FALSE,
353: p_count => x_msg_count,
354: p_data => x_msg_data);
355: -- Debug info.
356: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 372: WHEN FND_API.G_EXC_ERROR THEN

368: -- Check if API is called in debug mode. If yes, disable debug.
369: --disable_debug;
370:
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: ROLLBACK TO create_style_fmt_locale;
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MSG_PUB.Count_And_Get(
376: p_encoded => FND_API.G_FALSE,

Line 374: x_return_status := FND_API.G_RET_STS_ERROR;

370:
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: ROLLBACK TO create_style_fmt_locale;
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MSG_PUB.Count_And_Get(
376: p_encoded => FND_API.G_FALSE,
377: p_count => x_msg_count,
378: p_data => x_msg_data);

Line 376: p_encoded => FND_API.G_FALSE,

372: WHEN FND_API.G_EXC_ERROR THEN
373: ROLLBACK TO create_style_fmt_locale;
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: FND_MSG_PUB.Count_And_Get(
376: p_encoded => FND_API.G_FALSE,
377: p_count => x_msg_count,
378: p_data => x_msg_data);
379:
380: -- Debug info.

Line 396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

392:
393: -- Check if API is called in debug mode. If yes, disable debug.
394: --disable_debug;
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO create_style_fmt_locale;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(
400: p_encoded => FND_API.G_FALSE,

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

394: --disable_debug;
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO create_style_fmt_locale;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(
400: p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data);

Line 400: p_encoded => FND_API.G_FALSE,

396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO create_style_fmt_locale;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(
400: p_encoded => FND_API.G_FALSE,
401: p_count => x_msg_count,
402: p_data => x_msg_data);
403:
404: -- Debug info.

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

418: --disable_debug;
419:
420: WHEN OTHERS THEN
421: ROLLBACK TO create_style_fmt_locale;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423:
424: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
426: FND_MSG_PUB.ADD;

Line 429: p_encoded => FND_API.G_FALSE,

425: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
426: FND_MSG_PUB.ADD;
427:
428: FND_MSG_PUB.Count_And_Get(
429: p_encoded => FND_API.G_FALSE,
430: p_count => x_msg_count,
431: p_data => x_msg_data);
432:
433: -- Debug info.

Line 464: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

460: *
461: * ARGUMENTS
462: * IN:
463: * p_init_msg_list Initialize message stack if it is set to
464: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
465: * p_style_fmt_locale_rec Style format locale record.
466: * IN/OUT:
467: * p_object_version_number Used for locking the being updated record.
468: * OUT:

Line 470: * be FND_API.G_RET_STS_SUCCESS (success),

466: * IN/OUT:
467: * p_object_version_number Used for locking the being updated record.
468: * OUT:
469: * x_return_status Return status after the call. The status can
470: * be FND_API.G_RET_STS_SUCCESS (success),
471: * FND_API.G_RET_STS_ERROR (error),
472: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
473: * x_msg_count Number of messages in message stack.
474: * x_msg_data Message text if x_msg_count is 1.

Line 471: * FND_API.G_RET_STS_ERROR (error),

467: * p_object_version_number Used for locking the being updated record.
468: * OUT:
469: * x_return_status Return status after the call. The status can
470: * be FND_API.G_RET_STS_SUCCESS (success),
471: * FND_API.G_RET_STS_ERROR (error),
472: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
473: * x_msg_count Number of messages in message stack.
474: * x_msg_data Message text if x_msg_count is 1.
475: *

Line 472: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

468: * OUT:
469: * x_return_status Return status after the call. The status can
470: * be FND_API.G_RET_STS_SUCCESS (success),
471: * FND_API.G_RET_STS_ERROR (error),
472: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
473: * x_msg_count Number of messages in message stack.
474: * x_msg_data Message text if x_msg_count is 1.
475: *
476: * NOTES

Line 485: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

481: *
482: */
483:
484: PROCEDURE update_style_fmt_locale (
485: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
486: p_style_fmt_locale_rec IN STYLE_FMT_LOCALE_REC_TYPE,
487: p_object_version_number IN OUT NOCOPY NUMBER,
488: x_return_status OUT NOCOPY VARCHAR2,
489: x_msg_count OUT NOCOPY NUMBER,

Line 513: IF FND_API.to_Boolean(p_init_msg_list) THEN

509: p_msg_level=>fnd_log.level_procedure);
510: END IF;
511:
512: -- initialize message list if p_init_msg_list is set to TRUE.
513: IF FND_API.to_Boolean(p_init_msg_list) THEN
514: FND_MSG_PUB.initialize;
515: END IF;
516:
517: -- initialize API return status to success.

Line 518: x_return_status := FND_API.G_RET_STS_SUCCESS;

514: FND_MSG_PUB.initialize;
515: END IF;
516:
517: -- initialize API return status to success.
518: x_return_status := FND_API.G_RET_STS_SUCCESS;
519:
520: -- call to business logic.
521: do_update_style_fmt_locale(
522: l_style_fmt_locale_rec,

Line 528: p_encoded => FND_API.G_FALSE,

524: x_return_status);
525:
526: -- standard call to get message count and if count is 1, get message info.
527: FND_MSG_PUB.Count_And_Get(
528: p_encoded => FND_API.G_FALSE,
529: p_count => x_msg_count,
530: p_data => x_msg_data);
531:
532: -- Debug info.

Line 549: WHEN FND_API.G_EXC_ERROR THEN

545: -- Check if API is called in debug mode. If yes, disable debug.
546: --disable_debug;
547:
548: EXCEPTION
549: WHEN FND_API.G_EXC_ERROR THEN
550: ROLLBACK TO update_style_fmt_locale;
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: FND_MSG_PUB.Count_And_Get(
553: p_encoded => FND_API.G_FALSE,

Line 551: x_return_status := FND_API.G_RET_STS_ERROR;

547:
548: EXCEPTION
549: WHEN FND_API.G_EXC_ERROR THEN
550: ROLLBACK TO update_style_fmt_locale;
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: FND_MSG_PUB.Count_And_Get(
553: p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => x_msg_data);

Line 553: p_encoded => FND_API.G_FALSE,

549: WHEN FND_API.G_EXC_ERROR THEN
550: ROLLBACK TO update_style_fmt_locale;
551: x_return_status := FND_API.G_RET_STS_ERROR;
552: FND_MSG_PUB.Count_And_Get(
553: p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => x_msg_data);
556:
557: -- Debug info.

Line 573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

569:
570: -- Check if API is called in debug mode. If yes, disable debug.
571: --disable_debug;
572:
573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: ROLLBACK TO update_style_fmt_locale;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,

Line 575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

571: --disable_debug;
572:
573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: ROLLBACK TO update_style_fmt_locale;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data);

Line 577: p_encoded => FND_API.G_FALSE,

573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: ROLLBACK TO update_style_fmt_locale;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MSG_PUB.Count_And_Get(
577: p_encoded => FND_API.G_FALSE,
578: p_count => x_msg_count,
579: p_data => x_msg_data);
580:
581: -- Debug info.

Line 599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

595: --disable_debug;
596:
597: WHEN OTHERS THEN
598: ROLLBACK TO update_style_fmt_locale;
599: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
600:
601: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;

Line 606: p_encoded => FND_API.G_FALSE,

602: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
603: FND_MSG_PUB.ADD;
604:
605: FND_MSG_PUB.Count_And_Get(
606: p_encoded => FND_API.G_FALSE,
607: p_count => x_msg_count,
608: p_data => x_msg_data);
609:
610: -- Debug info.

Line 641: * FND_API.G_TRUE. Default is FND_API.G_FALSE.

637: *
638: * ARGUMENTS
639: * IN:
640: * p_init_msg_list Initialize message stack if it is set to
641: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
642: * p_style_fmt_locale_id Style format locale id.
643: * IN/OUT:
644: * OUT:
645: * x_style_fmt_locale_rec Style format locale record.

Line 647: * be FND_API.G_RET_STS_SUCCESS (success),

643: * IN/OUT:
644: * OUT:
645: * x_style_fmt_locale_rec Style format locale record.
646: * x_return_status Return status after the call. The status can
647: * be FND_API.G_RET_STS_SUCCESS (success),
648: * FND_API.G_RET_STS_ERROR (error),
649: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
650: * x_msg_count Number of messages in message stack.
651: * x_msg_data Message text if x_msg_count is 1.

Line 648: * FND_API.G_RET_STS_ERROR (error),

644: * OUT:
645: * x_style_fmt_locale_rec Style format locale record.
646: * x_return_status Return status after the call. The status can
647: * be FND_API.G_RET_STS_SUCCESS (success),
648: * FND_API.G_RET_STS_ERROR (error),
649: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
650: * x_msg_count Number of messages in message stack.
651: * x_msg_data Message text if x_msg_count is 1.
652: *

Line 649: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

645: * x_style_fmt_locale_rec Style format locale record.
646: * x_return_status Return status after the call. The status can
647: * be FND_API.G_RET_STS_SUCCESS (success),
648: * FND_API.G_RET_STS_ERROR (error),
649: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
650: * x_msg_count Number of messages in message stack.
651: * x_msg_data Message text if x_msg_count is 1.
652: *
653: * NOTES

Line 662: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

658: *
659: */
660:
661: PROCEDURE get_style_fmt_locale_rec (
662: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
663: p_style_fmt_locale_id IN NUMBER,
664: x_style_fmt_locale_rec OUT NOCOPY STYLE_FMT_LOCALE_REC_TYPE,
665: x_return_status OUT NOCOPY VARCHAR2,
666: x_msg_count OUT NOCOPY NUMBER,

Line 682: IF fnd_api.to_boolean(p_init_msg_list) THEN

678: p_msg_level=>fnd_log.level_procedure);
679: END IF;
680:
681: -- Initialize message list if p_init_msg_list is set to TRUE.
682: IF fnd_api.to_boolean(p_init_msg_list) THEN
683: fnd_msg_pub.initialize;
684: END IF;
685:
686: -- Initialize API return status to success.

Line 687: x_return_status := fnd_api.g_ret_sts_success;

683: fnd_msg_pub.initialize;
684: END IF;
685:
686: -- Initialize API return status to success.
687: x_return_status := fnd_api.g_ret_sts_success;
688:
689: -- Check whether primary key has been passed in.
690: IF p_style_fmt_locale_id IS NULL OR
691: p_style_fmt_locale_id = fnd_api.g_miss_num THEN

Line 691: p_style_fmt_locale_id = fnd_api.g_miss_num THEN

687: x_return_status := fnd_api.g_ret_sts_success;
688:
689: -- Check whether primary key has been passed in.
690: IF p_style_fmt_locale_id IS NULL OR
691: p_style_fmt_locale_id = fnd_api.g_miss_num THEN
692: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
693: fnd_message.set_token('COLUMN', 'style_fmt_locale_id');
694: fnd_msg_pub.add;
695: RAISE fnd_api.g_exc_error;

Line 695: RAISE fnd_api.g_exc_error;

691: p_style_fmt_locale_id = fnd_api.g_miss_num THEN
692: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
693: fnd_message.set_token('COLUMN', 'style_fmt_locale_id');
694: fnd_msg_pub.add;
695: RAISE fnd_api.g_exc_error;
696: END IF;
697:
698: x_style_fmt_locale_rec.style_fmt_locale_id := p_style_fmt_locale_id;
699:

Line 725: p_encoded => fnd_api.g_false,

721: END IF;
722:
723: --Standard call to get message count and if count is 1, get message info.
724: fnd_msg_pub.count_and_get(
725: p_encoded => fnd_api.g_false,
726: p_count => x_msg_count,
727: p_data => x_msg_data
728: );
729:

Line 747: WHEN fnd_api.g_exc_error THEN

743:
744: -- Check if API is called in debug mode. If yes, disable debug.
745: --disable_debug;
746: EXCEPTION
747: WHEN fnd_api.g_exc_error THEN
748: x_return_status := fnd_api.g_ret_sts_error;
749: fnd_msg_pub.count_and_get(
750: p_encoded => fnd_api.g_false,
751: p_count => x_msg_count,

Line 748: x_return_status := fnd_api.g_ret_sts_error;

744: -- Check if API is called in debug mode. If yes, disable debug.
745: --disable_debug;
746: EXCEPTION
747: WHEN fnd_api.g_exc_error THEN
748: x_return_status := fnd_api.g_ret_sts_error;
749: fnd_msg_pub.count_and_get(
750: p_encoded => fnd_api.g_false,
751: p_count => x_msg_count,
752: p_data => x_msg_data

Line 750: p_encoded => fnd_api.g_false,

746: EXCEPTION
747: WHEN fnd_api.g_exc_error THEN
748: x_return_status := fnd_api.g_ret_sts_error;
749: fnd_msg_pub.count_and_get(
750: p_encoded => fnd_api.g_false,
751: p_count => x_msg_count,
752: p_data => x_msg_data
753: );
754:

Line 771: WHEN fnd_api.g_exc_unexpected_error THEN

767:
768: -- Check if API is called in debug mode. If yes, disable debug.
769: --disable_debug;
770:
771: WHEN fnd_api.g_exc_unexpected_error THEN
772: x_return_status := fnd_api.g_ret_sts_unexp_error;
773:
774: fnd_msg_pub.count_and_get(
775: p_encoded => fnd_api.g_false,

Line 772: x_return_status := fnd_api.g_ret_sts_unexp_error;

768: -- Check if API is called in debug mode. If yes, disable debug.
769: --disable_debug;
770:
771: WHEN fnd_api.g_exc_unexpected_error THEN
772: x_return_status := fnd_api.g_ret_sts_unexp_error;
773:
774: fnd_msg_pub.count_and_get(
775: p_encoded => fnd_api.g_false,
776: p_count => x_msg_count,

Line 775: p_encoded => fnd_api.g_false,

771: WHEN fnd_api.g_exc_unexpected_error THEN
772: x_return_status := fnd_api.g_ret_sts_unexp_error;
773:
774: fnd_msg_pub.count_and_get(
775: p_encoded => fnd_api.g_false,
776: p_count => x_msg_count,
777: p_data => x_msg_data
778: );
779:

Line 797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

793: -- Check if API is called in debug mode. If yes, disable debug.
794: --disable_debug;
795:
796: WHEN OTHERS THEN
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798:
799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
800: fnd_message.set_token('ERROR' ,SQLERRM);
801: fnd_msg_pub.add;

Line 804: p_encoded => fnd_api.g_false,

800: fnd_message.set_token('ERROR' ,SQLERRM);
801: fnd_msg_pub.add;
802:
803: fnd_msg_pub.count_and_get(
804: p_encoded => fnd_api.g_false,
805: p_count => x_msg_count,
806: p_data => x_msg_data
807: );
808: