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

Line 125: IF x_return_status = fnd_api.g_ret_sts_error THEN

121: l_rowid,
122: x_return_status
123: );
124:
125: IF x_return_status = fnd_api.g_ret_sts_error THEN
126: RAISE fnd_api.g_exc_error;
127: END IF;
128:
129: BEGIN

Line 126: RAISE fnd_api.g_exc_error;

122: x_return_status
123: );
124:
125: IF x_return_status = fnd_api.g_ret_sts_error THEN
126: RAISE fnd_api.g_exc_error;
127: END IF;
128:
129: BEGIN
130: -- find the original default style

Line 232: RAISE FND_API.G_EXC_ERROR;

228: THEN
229: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
230: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_style_formats');
231: FND_MSG_PUB.ADD;
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:
235: p_object_version_number := nvl(l_object_version_number, 1) + 1;
236:

Line 242: RAISE FND_API.G_EXC_ERROR;

238: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
239: FND_MESSAGE.SET_TOKEN('RECORD', 'style format');
240: FND_MESSAGE.SET_TOKEN('VALUE', NVL(( p_style_format_rec.style_format_code), 'null'));
241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;
243: END;
244:
245: -- validate style format record
246: HZ_NAME_ADDRESS_FMT_VALIDATE.validate_style_format(

Line 252: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

248: p_style_format_rec,
249: l_rowid,
250: x_return_status);
251:
252: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;
255:
256: -- default_flag cannot be set from 'Y' to 'N'

Line 253: RAISE FND_API.G_EXC_ERROR;

249: l_rowid,
250: x_return_status);
251:
252: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
253: RAISE FND_API.G_EXC_ERROR;
254: END IF;
255:
256: -- default_flag cannot be set from 'Y' to 'N'
257: IF p_style_format_rec.default_flag = 'Y' AND

Line 277: -- has been set to 'N' or NULL or FND_API.G_MISS_CHAR.

273: NULL;
274: END;
275: ELSE
276: -- ignore the value of default flag if the flag
277: -- has been set to 'N' or NULL or FND_API.G_MISS_CHAR.
278: -- user can not unset a primary address flag by passing
279: -- value 'N' or NULL. to unset a default flag, he/she
280: -- needs to select another style format as primary. this
281: -- style format will be unmarked automatically.

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

331: *
332: * ARGUMENTS
333: * IN:
334: * p_init_msg_list Initialize message stack if it is set to
335: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
336: * p_style_format_rec Style format record.
337: * IN/OUT:
338: * OUT:
339: * x_return_status Return status after the call. The status can

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

336: * p_style_format_rec Style format record.
337: * IN/OUT:
338: * OUT:
339: * x_return_status Return status after the call. The status can
340: * be FND_API.G_RET_STS_SUCCESS (success),
341: * FND_API.G_RET_STS_ERROR (error),
342: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
343: * x_msg_count Number of messages in message stack.
344: * x_msg_data Message text if x_msg_count is 1.

Line 341: * FND_API.G_RET_STS_ERROR (error),

337: * IN/OUT:
338: * OUT:
339: * x_return_status Return status after the call. The status can
340: * be FND_API.G_RET_STS_SUCCESS (success),
341: * FND_API.G_RET_STS_ERROR (error),
342: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
343: * x_msg_count Number of messages in message stack.
344: * x_msg_data Message text if x_msg_count is 1.
345: *

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

338: * OUT:
339: * x_return_status Return status after the call. The status can
340: * be FND_API.G_RET_STS_SUCCESS (success),
341: * FND_API.G_RET_STS_ERROR (error),
342: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
343: * x_msg_count Number of messages in message stack.
344: * x_msg_data Message text if x_msg_count is 1.
345: *
346: * NOTES

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

351: *
352: */
353:
354: PROCEDURE create_style_format (
355: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
356: p_style_format_rec IN STYLE_FORMAT_REC_TYPE,
357: x_return_status OUT NOCOPY VARCHAR2,
358: x_msg_count OUT NOCOPY NUMBER,
359: x_msg_data OUT NOCOPY VARCHAR2

Line 380: IF FND_API.to_Boolean(p_init_msg_list) THEN

376: p_msg_level=>fnd_log.level_procedure);
377: END IF;
378:
379: -- initialize message list if p_init_msg_list is set to TRUE.
380: IF FND_API.to_Boolean(p_init_msg_list) THEN
381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: -- initialize API return status to success.

Line 385: x_return_status := FND_API.G_RET_STS_SUCCESS;

381: FND_MSG_PUB.initialize;
382: END IF;
383:
384: -- initialize API return status to success.
385: x_return_status := FND_API.G_RET_STS_SUCCESS;
386:
387: -- call to business logic.
388: do_create_style_format(
389: l_style_format_rec,

Line 394: p_encoded => FND_API.G_FALSE,

390: x_return_status);
391:
392: -- standard call to get message count and if count is 1, get message info.
393: FND_MSG_PUB.Count_And_Get(
394: p_encoded => FND_API.G_FALSE,
395: p_count => x_msg_count,
396: p_data => x_msg_data);
397: -- Debug info.
398: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 414: WHEN FND_API.G_EXC_ERROR THEN

410: -- Check if API is called in debug mode. If yes, disable debug.
411: --disable_debug;
412:
413: EXCEPTION
414: WHEN FND_API.G_EXC_ERROR THEN
415: ROLLBACK TO create_style_format;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: FND_MSG_PUB.Count_And_Get(
418: p_encoded => FND_API.G_FALSE,

Line 416: x_return_status := FND_API.G_RET_STS_ERROR;

412:
413: EXCEPTION
414: WHEN FND_API.G_EXC_ERROR THEN
415: ROLLBACK TO create_style_format;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: FND_MSG_PUB.Count_And_Get(
418: p_encoded => FND_API.G_FALSE,
419: p_count => x_msg_count,
420: p_data => x_msg_data);

Line 418: p_encoded => FND_API.G_FALSE,

414: WHEN FND_API.G_EXC_ERROR THEN
415: ROLLBACK TO create_style_format;
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: FND_MSG_PUB.Count_And_Get(
418: p_encoded => FND_API.G_FALSE,
419: p_count => x_msg_count,
420: p_data => x_msg_data);
421:
422: -- Debug info.

Line 438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

434:
435: -- Check if API is called in debug mode. If yes, disable debug.
436: --disable_debug;
437:
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO create_style_format;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

436: --disable_debug;
437:
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO create_style_format;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data);

Line 442: p_encoded => FND_API.G_FALSE,

438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO create_style_format;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get(
442: p_encoded => FND_API.G_FALSE,
443: p_count => x_msg_count,
444: p_data => x_msg_data);
445:
446: -- Debug info.

Line 464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

460: --disable_debug;
461:
462: WHEN OTHERS THEN
463: ROLLBACK TO create_style_format;
464: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
465:
466: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
467: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
468: FND_MSG_PUB.ADD;

Line 471: p_encoded => FND_API.G_FALSE,

467: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
468: FND_MSG_PUB.ADD;
469:
470: FND_MSG_PUB.Count_And_Get(
471: p_encoded => FND_API.G_FALSE,
472: p_count => x_msg_count,
473: p_data => x_msg_data);
474:
475: -- Debug info.

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

501: *
502: * ARGUMENTS
503: * IN:
504: * p_init_msg_list Initialize message stack if it is set to
505: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
506: * p_style_format_rec Style record.
507: * IN/OUT:
508: * p_object_version_number Used for locking the being updated record.
509: * OUT:

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

507: * IN/OUT:
508: * p_object_version_number Used for locking the being updated record.
509: * OUT:
510: * x_return_status Return status after the call. The status can
511: * be FND_API.G_RET_STS_SUCCESS (success),
512: * FND_API.G_RET_STS_ERROR (error),
513: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
514: * x_msg_count Number of messages in message stack.
515: * x_msg_data Message text if x_msg_count is 1.

Line 512: * FND_API.G_RET_STS_ERROR (error),

508: * p_object_version_number Used for locking the being updated record.
509: * OUT:
510: * x_return_status Return status after the call. The status can
511: * be FND_API.G_RET_STS_SUCCESS (success),
512: * FND_API.G_RET_STS_ERROR (error),
513: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
514: * x_msg_count Number of messages in message stack.
515: * x_msg_data Message text if x_msg_count is 1.
516: *

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

509: * OUT:
510: * x_return_status Return status after the call. The status can
511: * be FND_API.G_RET_STS_SUCCESS (success),
512: * FND_API.G_RET_STS_ERROR (error),
513: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
514: * x_msg_count Number of messages in message stack.
515: * x_msg_data Message text if x_msg_count is 1.
516: *
517: * NOTES

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

522: *
523: */
524:
525: PROCEDURE update_style_format (
526: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
527: p_style_format_rec IN STYLE_FORMAT_REC_TYPE,
528: p_object_version_number IN OUT NOCOPY NUMBER,
529: x_return_status OUT NOCOPY VARCHAR2,
530: x_msg_count OUT NOCOPY NUMBER,

Line 554: IF FND_API.to_Boolean(p_init_msg_list) THEN

550: p_msg_level=>fnd_log.level_procedure);
551: END IF;
552:
553: -- initialize message list if p_init_msg_list is set to TRUE.
554: IF FND_API.to_Boolean(p_init_msg_list) THEN
555: FND_MSG_PUB.initialize;
556: END IF;
557:
558: -- initialize API return status to success.

Line 559: x_return_status := FND_API.G_RET_STS_SUCCESS;

555: FND_MSG_PUB.initialize;
556: END IF;
557:
558: -- initialize API return status to success.
559: x_return_status := FND_API.G_RET_STS_SUCCESS;
560:
561: -- call to business logic.
562: do_update_style_format(
563: l_style_format_rec,

Line 569: p_encoded => FND_API.G_FALSE,

565: x_return_status);
566:
567: -- standard call to get message count and if count is 1, get message info.
568: FND_MSG_PUB.Count_And_Get(
569: p_encoded => FND_API.G_FALSE,
570: p_count => x_msg_count,
571: p_data => x_msg_data);
572:
573: -- Debug info.

Line 590: WHEN FND_API.G_EXC_ERROR THEN

586: -- Check if API is called in debug mode. If yes, disable debug.
587: --disable_debug;
588:
589: EXCEPTION
590: WHEN FND_API.G_EXC_ERROR THEN
591: ROLLBACK TO update_style_format;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

588:
589: EXCEPTION
590: WHEN FND_API.G_EXC_ERROR THEN
591: ROLLBACK TO update_style_format;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => x_msg_data);

Line 594: p_encoded => FND_API.G_FALSE,

590: WHEN FND_API.G_EXC_ERROR THEN
591: ROLLBACK TO update_style_format;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: FND_MSG_PUB.Count_And_Get(
594: p_encoded => FND_API.G_FALSE,
595: p_count => x_msg_count,
596: p_data => x_msg_data);
597:
598: -- Debug info.

Line 614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

610:
611: -- Check if API is called in debug mode. If yes, disable debug.
612: --disable_debug;
613:
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: ROLLBACK TO update_style_format;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.Count_And_Get(
618: p_encoded => FND_API.G_FALSE,

Line 616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

612: --disable_debug;
613:
614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: ROLLBACK TO update_style_format;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.Count_And_Get(
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data);

Line 618: p_encoded => FND_API.G_FALSE,

614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
615: ROLLBACK TO update_style_format;
616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
617: FND_MSG_PUB.Count_And_Get(
618: p_encoded => FND_API.G_FALSE,
619: p_count => x_msg_count,
620: p_data => x_msg_data);
621:
622: -- Debug info.

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

636: --disable_debug;
637:
638: WHEN OTHERS THEN
639: ROLLBACK TO update_style_format;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641:
642: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
644: FND_MSG_PUB.ADD;

Line 647: p_encoded => FND_API.G_FALSE,

643: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
644: FND_MSG_PUB.ADD;
645:
646: FND_MSG_PUB.Count_And_Get(
647: p_encoded => FND_API.G_FALSE,
648: p_count => x_msg_count,
649: p_data => x_msg_data);
650:
651: -- Debug info.

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

678: *
679: * ARGUMENTS
680: * IN:
681: * p_init_msg_list Initialize message stack if it is set to
682: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
683: * p_style_format_code Style Code.
684: * IN/OUT:
685: * OUT:
686: * x_style_format_rec Style record.

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

684: * IN/OUT:
685: * OUT:
686: * x_style_format_rec Style record.
687: * x_return_status Return status after the call. The status can
688: * be FND_API.G_RET_STS_SUCCESS (success),
689: * FND_API.G_RET_STS_ERROR (error),
690: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
691: * x_msg_count Number of messages in message stack.
692: * x_msg_data Message text if x_msg_count is 1.

Line 689: * FND_API.G_RET_STS_ERROR (error),

685: * OUT:
686: * x_style_format_rec Style record.
687: * x_return_status Return status after the call. The status can
688: * be FND_API.G_RET_STS_SUCCESS (success),
689: * FND_API.G_RET_STS_ERROR (error),
690: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
691: * x_msg_count Number of messages in message stack.
692: * x_msg_data Message text if x_msg_count is 1.
693: *

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

686: * x_style_format_rec Style record.
687: * x_return_status Return status after the call. The status can
688: * be FND_API.G_RET_STS_SUCCESS (success),
689: * FND_API.G_RET_STS_ERROR (error),
690: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
691: * x_msg_count Number of messages in message stack.
692: * x_msg_data Message text if x_msg_count is 1.
693: *
694: * NOTES

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

699: *
700: */
701:
702: PROCEDURE get_style_format_rec (
703: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
704: p_style_format_code IN VARCHAR2,
705: x_style_format_rec OUT NOCOPY STYLE_FORMAT_REC_TYPE,
706: x_return_status OUT NOCOPY VARCHAR2,
707: x_msg_count OUT NOCOPY NUMBER,

Line 723: IF fnd_api.to_boolean(p_init_msg_list) THEN

719: p_msg_level=>fnd_log.level_procedure);
720: END IF;
721:
722: -- Initialize message list if p_init_msg_list is set to TRUE.
723: IF fnd_api.to_boolean(p_init_msg_list) THEN
724: fnd_msg_pub.initialize;
725: END IF;
726:
727: -- Initialize API return status to success.

Line 728: x_return_status := fnd_api.g_ret_sts_success;

724: fnd_msg_pub.initialize;
725: END IF;
726:
727: -- Initialize API return status to success.
728: x_return_status := fnd_api.g_ret_sts_success;
729:
730: -- Check whether primary key has been passed in.
731: IF p_style_format_code IS NULL OR
732: p_style_format_code = fnd_api.g_miss_char THEN

Line 732: p_style_format_code = fnd_api.g_miss_char THEN

728: x_return_status := fnd_api.g_ret_sts_success;
729:
730: -- Check whether primary key has been passed in.
731: IF p_style_format_code IS NULL OR
732: p_style_format_code = fnd_api.g_miss_char THEN
733: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
734: fnd_message.set_token('COLUMN', 'style_format_code');
735: fnd_msg_pub.add;
736: RAISE fnd_api.g_exc_error;

Line 736: RAISE fnd_api.g_exc_error;

732: p_style_format_code = fnd_api.g_miss_char THEN
733: fnd_message.set_name('AR', 'HZ_API_MISSING_COLUMN');
734: fnd_message.set_token('COLUMN', 'style_format_code');
735: fnd_msg_pub.add;
736: RAISE fnd_api.g_exc_error;
737: END IF;
738:
739: x_style_format_rec.style_format_code := p_style_format_code;
740:

Line 765: p_encoded => fnd_api.g_false,

761: END IF;
762:
763: --Standard call to get message count and if count is 1, get message info.
764: fnd_msg_pub.count_and_get(
765: p_encoded => fnd_api.g_false,
766: p_count => x_msg_count,
767: p_data => x_msg_data
768: );
769:

Line 786: WHEN fnd_api.g_exc_error THEN

782:
783: -- Check if API is called in debug mode. If yes, disable debug.
784: --disable_debug;
785: EXCEPTION
786: WHEN fnd_api.g_exc_error THEN
787: x_return_status := fnd_api.g_ret_sts_error;
788: fnd_msg_pub.count_and_get(
789: p_encoded => fnd_api.g_false,
790: p_count => x_msg_count,

Line 787: x_return_status := fnd_api.g_ret_sts_error;

783: -- Check if API is called in debug mode. If yes, disable debug.
784: --disable_debug;
785: EXCEPTION
786: WHEN fnd_api.g_exc_error THEN
787: x_return_status := fnd_api.g_ret_sts_error;
788: fnd_msg_pub.count_and_get(
789: p_encoded => fnd_api.g_false,
790: p_count => x_msg_count,
791: p_data => x_msg_data

Line 789: p_encoded => fnd_api.g_false,

785: EXCEPTION
786: WHEN fnd_api.g_exc_error THEN
787: x_return_status := fnd_api.g_ret_sts_error;
788: fnd_msg_pub.count_and_get(
789: p_encoded => fnd_api.g_false,
790: p_count => x_msg_count,
791: p_data => x_msg_data
792: );
793:

Line 810: WHEN fnd_api.g_exc_unexpected_error THEN

806:
807: -- Check if API is called in debug mode. If yes, disable debug.
808: --disable_debug;
809:
810: WHEN fnd_api.g_exc_unexpected_error THEN
811: x_return_status := fnd_api.g_ret_sts_unexp_error;
812:
813: fnd_msg_pub.count_and_get(
814: p_encoded => fnd_api.g_false,

Line 811: x_return_status := fnd_api.g_ret_sts_unexp_error;

807: -- Check if API is called in debug mode. If yes, disable debug.
808: --disable_debug;
809:
810: WHEN fnd_api.g_exc_unexpected_error THEN
811: x_return_status := fnd_api.g_ret_sts_unexp_error;
812:
813: fnd_msg_pub.count_and_get(
814: p_encoded => fnd_api.g_false,
815: p_count => x_msg_count,

Line 814: p_encoded => fnd_api.g_false,

810: WHEN fnd_api.g_exc_unexpected_error THEN
811: x_return_status := fnd_api.g_ret_sts_unexp_error;
812:
813: fnd_msg_pub.count_and_get(
814: p_encoded => fnd_api.g_false,
815: p_count => x_msg_count,
816: p_data => x_msg_data
817: );
818:

Line 837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

833: -- Check if API is called in debug mode. If yes, disable debug.
834: --disable_debug;
835:
836: WHEN OTHERS THEN
837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
838:
839: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
840: fnd_message.set_token('ERROR' ,SQLERRM);
841: fnd_msg_pub.add;

Line 844: p_encoded => fnd_api.g_false,

840: fnd_message.set_token('ERROR' ,SQLERRM);
841: fnd_msg_pub.add;
842:
843: fnd_msg_pub.count_and_get(
844: p_encoded => fnd_api.g_false,
845: p_count => x_msg_count,
846: p_data => x_msg_data
847: );
848: