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

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

122: * IN/OUT:
123: * OUT:
124: * x_financial_report_id Financial report Id.
125: * x_return_status Return status after the call. The status can
126: * be FND_API.G_RET_STS_SUCCESS (success),
127: * FND_API.G_RET_STS_ERROR (error),
128: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
129: *
130: * NOTES

Line 127: * FND_API.G_RET_STS_ERROR (error),

123: * OUT:
124: * x_financial_report_id Financial report Id.
125: * x_return_status Return status after the call. The status can
126: * be FND_API.G_RET_STS_SUCCESS (success),
127: * FND_API.G_RET_STS_ERROR (error),
128: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
129: *
130: * NOTES
131: *

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

124: * x_financial_report_id Financial report Id.
125: * x_return_status Return status after the call. The status can
126: * be FND_API.G_RET_STS_SUCCESS (success),
127: * FND_API.G_RET_STS_ERROR (error),
128: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
129: *
130: * NOTES
131: *
132: * MODIFICATION HISTORY

Line 156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

152: p_financial_report_rec,
153: l_rowid,
154: x_return_status);
155:
156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: --Bug 2490399: Added final_ind in financial_report_rec_type. Hence passing

Line 157: RAISE FND_API.G_EXC_ERROR;

153: l_rowid,
154: x_return_status);
155:
156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: --Bug 2490399: Added final_ind in financial_report_rec_type. Hence passing
161: --the final_ind value instead of fnd_api.g_miss_char.

Line 161: --the final_ind value instead of fnd_api.g_miss_char.

157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160: --Bug 2490399: Added final_ind in financial_report_rec_type. Hence passing
161: --the final_ind value instead of fnd_api.g_miss_char.
162: -- call table handler to insert a row
163: HZ_FINANCIAL_REPORTS_PKG.Insert_Row (
164: x_ROWID => l_rowid,
165: x_FINANCIAL_REPORT_ID => p_financial_report_rec.financial_report_id,

Line 236: RAISE FND_API.G_EXC_ERROR;

232: THEN
233: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
234: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_REPORTS');
235: FND_MSG_PUB.ADD;
236: RAISE FND_API.G_EXC_ERROR;
237: END IF;
238:
239: p_object_version_number := nvl(l_object_version_number, 1) + 1;
240:

Line 247: RAISE FND_API.G_EXC_ERROR;

243: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
244: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_FINANCIAL_REPORTS');
245: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_financial_report_rec.financial_report_id ), 'null' ) );
246: FND_MSG_PUB.ADD;
247: RAISE FND_API.G_EXC_ERROR;
248: END;
249:
250: -- validate financial report record
251: HZ_REGISTRY_VALIDATE_V2PUB.validate_financial_report(

Line 257: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

253: p_financial_report_rec,
254: l_rowid,
255: x_return_status);
256:
257: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
258: RAISE FND_API.G_EXC_ERROR;
259: END IF;
260:
261: -- Bug 4693719 : pass NULL if the secure data is not updated

Line 258: RAISE FND_API.G_EXC_ERROR;

254: l_rowid,
255: x_return_status);
256:
257: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
258: RAISE FND_API.G_EXC_ERROR;
259: END IF;
260:
261: -- Bug 4693719 : pass NULL if the secure data is not updated
262: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN

Line 270: --the final_ind value instead of fnd_api.g_miss_char.

266: END IF;
267:
268:
269: --Bug 2490399: Added final_ind in financial_report_rec_type. Hence passing
270: --the final_ind value instead of fnd_api.g_miss_char.
271: -- call table handler to update a row
272: HZ_FINANCIAL_REPORTS_PKG.Update_Row (
273: x_ROWID => l_rowid,
274: x_FINANCIAL_REPORT_ID => p_financial_report_rec.financial_report_id,

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

320: * IN/OUT:
321: * OUT:
322: * x_financial_number_id Financial Number Id.
323: * x_return_status Return status after the call. The status can
324: * be FND_API.G_RET_STS_SUCCESS (success),
325: * FND_API.G_RET_STS_ERROR (error),
326: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
327: *
328: * NOTES

Line 325: * FND_API.G_RET_STS_ERROR (error),

321: * OUT:
322: * x_financial_number_id Financial Number Id.
323: * x_return_status Return status after the call. The status can
324: * be FND_API.G_RET_STS_SUCCESS (success),
325: * FND_API.G_RET_STS_ERROR (error),
326: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
327: *
328: * NOTES
329: *

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

322: * x_financial_number_id Financial Number Id.
323: * x_return_status Return status after the call. The status can
324: * be FND_API.G_RET_STS_SUCCESS (success),
325: * FND_API.G_RET_STS_ERROR (error),
326: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
327: *
328: * NOTES
329: *
330: * MODIFICATION HISTORY

Line 357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

353: l_rowid,
354: x_return_status,
355: --bug 3942332 :added parameter l_acual_content_source
356: l_acual_content_source);
357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: -- Bug 4225452.

Line 358: RAISE FND_API.G_EXC_ERROR;

354: x_return_status,
355: --bug 3942332 :added parameter l_acual_content_source
356: l_acual_content_source);
357: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: -- Bug 4225452.
362: IF l_acual_content_source = G_MISS_CONTENT_SOURCE_TYPE THEN

Line 370: IF x_return_status = FND_API.G_RET_STS_ERROR then

366: p_mixnmatch_enabled => g_fin_mixnmatch_enabled,
367: p_actual_content_source => l_acual_content_source,
368: x_return_status => x_return_status );
369:
370: IF x_return_status = FND_API.G_RET_STS_ERROR then
371: raise fnd_api.g_exc_error;
372: END IF;
373: END IF;
374:

Line 371: raise fnd_api.g_exc_error;

367: p_actual_content_source => l_acual_content_source,
368: x_return_status => x_return_status );
369:
370: IF x_return_status = FND_API.G_RET_STS_ERROR then
371: raise fnd_api.g_exc_error;
372: END IF;
373: END IF;
374:
375: -- call table handler to insert a row

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

409: * IN/OUT:
410: * OUT:
411: * p_object_version_number Used for locking the being updated record.
412: * x_return_status Return status after the call. The status can
413: * be FND_API.G_RET_STS_SUCCESS (success),
414: * FND_API.G_RET_STS_ERROR (error),
415: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
416: *
417: * NOTES

Line 414: * FND_API.G_RET_STS_ERROR (error),

410: * OUT:
411: * p_object_version_number Used for locking the being updated record.
412: * x_return_status Return status after the call. The status can
413: * be FND_API.G_RET_STS_SUCCESS (success),
414: * FND_API.G_RET_STS_ERROR (error),
415: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
416: *
417: * NOTES
418: *

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

411: * p_object_version_number Used for locking the being updated record.
412: * x_return_status Return status after the call. The status can
413: * be FND_API.G_RET_STS_SUCCESS (success),
414: * FND_API.G_RET_STS_ERROR (error),
415: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
416: *
417: * NOTES
418: *
419: * MODIFICATION HISTORY

Line 467: RAISE FND_API.G_EXC_ERROR;

463: THEN
464: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
465: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_FINANCIAL_NUMBERS');
466: FND_MSG_PUB.ADD;
467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469:
470: p_object_version_number := nvl(l_object_version_number, 1) + 1;
471:

Line 478: RAISE FND_API.G_EXC_ERROR;

474: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
475: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_FINANCIAL_NUMBERS');
476: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_financial_number_rec.financial_number_id ), 'null' ) );
477: FND_MSG_PUB.ADD;
478: RAISE FND_API.G_EXC_ERROR;
479: END;
480:
481: -- validate financial number record
482: HZ_REGISTRY_VALIDATE_V2PUB.validate_financial_number(

Line 490: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

486: x_return_status,
487: --bug 3942332: added parameter to function call
488: l_acual_content_source);
489:
490: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: /* SSM SST Integration and Extension

Line 491: RAISE FND_API.G_EXC_ERROR;

487: --bug 3942332: added parameter to function call
488: l_acual_content_source);
489:
490: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
491: RAISE FND_API.G_EXC_ERROR;
492: END IF;
493:
494: /* SSM SST Integration and Extension
495: * For non-profile entities, the concept of select/de-select data-sources is obsoleted.

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

552: *
553: * ARGUMENTS
554: * IN:
555: * p_init_msg_list Initialize message stack if it is set to
556: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
557: * p_financial_report_rec financial_report record.
558: * IN/OUT:
559: * OUT:
560: * x_financial_report_id financial_report Id.

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

558: * IN/OUT:
559: * OUT:
560: * x_financial_report_id financial_report Id.
561: * x_return_status Return status after the call. The status can
562: * be FND_API.G_RET_STS_SUCCESS (success),
563: * FND_API.G_RET_STS_ERROR (error),
564: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
565: * x_msg_count Number of messages in message stack.
566: * x_msg_data Message text if x_msg_count is 1.

Line 563: * FND_API.G_RET_STS_ERROR (error),

559: * OUT:
560: * x_financial_report_id financial_report Id.
561: * x_return_status Return status after the call. The status can
562: * be FND_API.G_RET_STS_SUCCESS (success),
563: * FND_API.G_RET_STS_ERROR (error),
564: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
565: * x_msg_count Number of messages in message stack.
566: * x_msg_data Message text if x_msg_count is 1.
567: *

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

560: * x_financial_report_id financial_report Id.
561: * x_return_status Return status after the call. The status can
562: * be FND_API.G_RET_STS_SUCCESS (success),
563: * FND_API.G_RET_STS_ERROR (error),
564: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
565: * x_msg_count Number of messages in message stack.
566: * x_msg_data Message text if x_msg_count is 1.
567: *
568: * NOTES

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

576: *
577: */
578:
579: PROCEDURE create_financial_report(
580: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
581: p_financial_report_rec IN FINANCIAL_REPORT_REC_TYPE,
582: x_financial_report_id OUT NOCOPY NUMBER,
583: x_return_status OUT NOCOPY VARCHAR2,
584: x_msg_count OUT NOCOPY NUMBER,

Line 597: IF FND_API.to_Boolean(p_init_msg_list) THEN

593: --Standard start of API savepoint
594: SAVEPOINT create_financial_report;
595:
596: --Initialize message list if p_init_msg_list is set to TRUE.
597: IF FND_API.to_Boolean(p_init_msg_list) THEN
598: FND_MSG_PUB.initialize;
599: END IF;
600:
601: --Initialize API return status to success.

Line 602: x_return_status := FND_API.G_RET_STS_SUCCESS;

598: FND_MSG_PUB.initialize;
599: END IF;
600:
601: --Initialize API return status to success.
602: x_return_status := FND_API.G_RET_STS_SUCCESS;
603:
604: -- Bug 2868913: First load data
605: -- sources for this entity. Then assign the actual_content_source
606: -- to the real data source. The value of content_source_type is

Line 630: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

626: x_is_datasource_selected => g_fin_is_datasource_selected,
627: x_return_status => x_return_status,
628: p_api_version => 'V2');
629:
630: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
631: RAISE FND_API.G_EXC_ERROR;
632: END IF;
633:
634: -- Call to business logic.

Line 631: RAISE FND_API.G_EXC_ERROR;

627: x_return_status => x_return_status,
628: p_api_version => 'V2');
629:
630: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
631: RAISE FND_API.G_EXC_ERROR;
632: END IF;
633:
634: -- Call to business logic.
635: HZ_ORGANIZATION_INFO_V2PUB.do_create_financial_report(

Line 646: IF x_return_status = FND_API.G_RET_STS_SUCCESS /*AND

642: -- SSM SST Integration and Extension
643: -- For non-profile entities, the concept of select/de-select data-sources is obsoleted.
644: -- There is no need to check if the data-source is selected.
645:
646: IF x_return_status = FND_API.G_RET_STS_SUCCESS /*AND
647: g_fin_is_datasource_selected = 'Y' */
648: THEN
649: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
650: -- Invoke business event system.

Line 664: p_encoded => FND_API.G_FALSE,

660: END IF;
661:
662: --Standard call to get message count and if count is 1, get message info.
663: FND_MSG_PUB.Count_And_Get(
664: p_encoded => FND_API.G_FALSE,
665: p_count => x_msg_count,
666: p_data => x_msg_data);
667:
668: EXCEPTION

Line 669: WHEN FND_API.G_EXC_ERROR THEN

665: p_count => x_msg_count,
666: p_data => x_msg_data);
667:
668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: ROLLBACK TO create_financial_report;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MSG_PUB.Count_And_Get(
673: p_encoded => FND_API.G_FALSE,

Line 671: x_return_status := FND_API.G_RET_STS_ERROR;

667:
668: EXCEPTION
669: WHEN FND_API.G_EXC_ERROR THEN
670: ROLLBACK TO create_financial_report;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MSG_PUB.Count_And_Get(
673: p_encoded => FND_API.G_FALSE,
674: p_count => x_msg_count,
675: p_data => x_msg_data);

Line 673: p_encoded => FND_API.G_FALSE,

669: WHEN FND_API.G_EXC_ERROR THEN
670: ROLLBACK TO create_financial_report;
671: x_return_status := FND_API.G_RET_STS_ERROR;
672: FND_MSG_PUB.Count_And_Get(
673: p_encoded => FND_API.G_FALSE,
674: p_count => x_msg_count,
675: p_data => x_msg_data);
676:
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

673: p_encoded => FND_API.G_FALSE,
674: p_count => x_msg_count,
675: p_data => x_msg_data);
676:
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: ROLLBACK TO create_financial_report;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.Count_And_Get(
681: p_encoded => FND_API.G_FALSE,

Line 679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

675: p_data => x_msg_data);
676:
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: ROLLBACK TO create_financial_report;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.Count_And_Get(
681: p_encoded => FND_API.G_FALSE,
682: p_count => x_msg_count,
683: p_data => x_msg_data);

Line 681: p_encoded => FND_API.G_FALSE,

677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: ROLLBACK TO create_financial_report;
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
680: FND_MSG_PUB.Count_And_Get(
681: p_encoded => FND_API.G_FALSE,
682: p_count => x_msg_count,
683: p_data => x_msg_data);
684:
685: WHEN OTHERS THEN

Line 687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

683: p_data => x_msg_data);
684:
685: WHEN OTHERS THEN
686: ROLLBACK TO create_financial_report;
687: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
688: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
689: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
690: FND_MSG_PUB.ADD;
691: FND_MSG_PUB.Count_And_Get(

Line 692: p_encoded => FND_API.G_FALSE,

688: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
689: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
690: FND_MSG_PUB.ADD;
691: FND_MSG_PUB.Count_And_Get(
692: p_encoded => FND_API.G_FALSE,
693: p_count => x_msg_count,
694: p_data => x_msg_data);
695:
696: END create_financial_report;

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

706: *
707: * ARGUMENTS
708: * IN:
709: * p_init_msg_list Initialize message stack if it is set to
710: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
711: * p_financial_report_rec Financial report record.
712: * IN/OUT:
713: * p_object_version_number Used for locking the being updated record.
714: * OUT:

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

712: * IN/OUT:
713: * p_object_version_number Used for locking the being updated record.
714: * OUT:
715: * x_return_status Return status after the call. The status can
716: * be FND_API.G_RET_STS_SUCCESS (success),
717: * FND_API.G_RET_STS_ERROR (error),
718: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
719: * x_msg_count Number of messages in message stack.
720: * x_msg_data Message text if x_msg_count is 1.

Line 717: * FND_API.G_RET_STS_ERROR (error),

713: * p_object_version_number Used for locking the being updated record.
714: * OUT:
715: * x_return_status Return status after the call. The status can
716: * be FND_API.G_RET_STS_SUCCESS (success),
717: * FND_API.G_RET_STS_ERROR (error),
718: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
719: * x_msg_count Number of messages in message stack.
720: * x_msg_data Message text if x_msg_count is 1.
721: *

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

714: * OUT:
715: * x_return_status Return status after the call. The status can
716: * be FND_API.G_RET_STS_SUCCESS (success),
717: * FND_API.G_RET_STS_ERROR (error),
718: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
719: * x_msg_count Number of messages in message stack.
720: * x_msg_data Message text if x_msg_count is 1.
721: *
722: * NOTES

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

730: *
731: */
732:
733: PROCEDURE update_financial_report(
734: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
735: p_financial_report_rec IN FINANCIAL_REPORT_REC_TYPE,
736: p_object_version_number IN OUT NOCOPY NUMBER,
737: x_return_status OUT NOCOPY VARCHAR2,
738: x_msg_count OUT NOCOPY NUMBER,

Line 752: IF FND_API.to_Boolean(p_init_msg_list) THEN

748: --Standard start of API savepoint
749: SAVEPOINT update_financial_report;
750:
751: --Initialize message list if p_init_msg_list is set to TRUE.
752: IF FND_API.to_Boolean(p_init_msg_list) THEN
753: FND_MSG_PUB.initialize;
754: END IF;
755:
756: --Initialize API return status to success.

Line 757: x_return_status := FND_API.G_RET_STS_SUCCESS;

753: FND_MSG_PUB.initialize;
754: END IF;
755:
756: --Initialize API return status to success.
757: x_return_status := FND_API.G_RET_STS_SUCCESS;
758:
759: HZ_ORGANIZATION_INFO_V2PUB.get_financial_report_rec (
760: p_financial_report_id => p_financial_report_rec.financial_report_id,
761: p_financial_report_rec => l_old_fin_report_rec,

Line 767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

763: x_msg_count => x_msg_count,
764: x_msg_data => x_msg_data);
765:
766:
767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
768: RAISE FND_API.G_EXC_ERROR;
769: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: END IF;

Line 768: RAISE FND_API.G_EXC_ERROR;

764: x_msg_data => x_msg_data);
765:
766:
767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
768: RAISE FND_API.G_EXC_ERROR;
769: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: END IF;
772:

Line 769: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

765:
766:
767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
768: RAISE FND_API.G_EXC_ERROR;
769: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: END IF;
772:
773: -- Bug 2868913: default the actual_content_source through mixnm API

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

766:
767: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
768: RAISE FND_API.G_EXC_ERROR;
769: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: END IF;
772:
773: -- Bug 2868913: default the actual_content_source through mixnm API
774: /* SSM SST Integration and Extension

Line 800: IF x_return_status = FND_API.G_RET_STS_SUCCESS /*AND

796:
797: -- SSM SST Integration and Extension
798: -- For non-profile entities, the concept of select/de-select data-sources is obsoleted.
799: -- There is no need to check if the data-source is selected.
800: IF x_return_status = FND_API.G_RET_STS_SUCCESS /*AND
801: g_fin_is_datasource_selected = 'Y'*/
802: THEN
803: --Bug 2979651: Since 2907261 made to HZ.K, keeping back the changes of 115.8 version.
804: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

Line 821: p_encoded => FND_API.G_FALSE,

817:
818: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
819: --Standard call to get message count and if count is 1, get message info.
820: FND_MSG_PUB.Count_And_Get(
821: p_encoded => FND_API.G_FALSE,
822: p_count => x_msg_count,
823: p_data => x_msg_data);
824:
825: EXCEPTION

Line 826: WHEN FND_API.G_EXC_ERROR THEN

822: p_count => x_msg_count,
823: p_data => x_msg_data);
824:
825: EXCEPTION
826: WHEN FND_API.G_EXC_ERROR THEN
827: ROLLBACK TO update_financial_report;
828: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: FND_MSG_PUB.Count_And_Get(

Line 829: x_return_status := FND_API.G_RET_STS_ERROR;

825: EXCEPTION
826: WHEN FND_API.G_EXC_ERROR THEN
827: ROLLBACK TO update_financial_report;
828: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: FND_MSG_PUB.Count_And_Get(
831: p_encoded => FND_API.G_FALSE,
832: p_count => x_msg_count,
833: p_data => x_msg_data);

Line 831: p_encoded => FND_API.G_FALSE,

827: ROLLBACK TO update_financial_report;
828: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
829: x_return_status := FND_API.G_RET_STS_ERROR;
830: FND_MSG_PUB.Count_And_Get(
831: p_encoded => FND_API.G_FALSE,
832: p_count => x_msg_count,
833: p_data => x_msg_data);
834:
835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

831: p_encoded => FND_API.G_FALSE,
832: p_count => x_msg_count,
833: p_data => x_msg_data);
834:
835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
836: ROLLBACK TO update_financial_report;
837: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: FND_MSG_PUB.Count_And_Get(

Line 838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

834:
835: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
836: ROLLBACK TO update_financial_report;
837: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: FND_MSG_PUB.Count_And_Get(
840: p_encoded => FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data);

Line 840: p_encoded => FND_API.G_FALSE,

836: ROLLBACK TO update_financial_report;
837: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: FND_MSG_PUB.Count_And_Get(
840: p_encoded => FND_API.G_FALSE,
841: p_count => x_msg_count,
842: p_data => x_msg_data);
843:
844: WHEN OTHERS THEN

Line 847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

843:
844: WHEN OTHERS THEN
845: ROLLBACK TO update_financial_report;
846: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
849: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
850: FND_MSG_PUB.ADD;
851: FND_MSG_PUB.Count_And_Get(

Line 852: p_encoded => FND_API.G_FALSE,

848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
849: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
850: FND_MSG_PUB.ADD;
851: FND_MSG_PUB.Count_And_Get(
852: p_encoded => FND_API.G_FALSE,
853: p_count => x_msg_count,
854: p_data => x_msg_data);
855:
856: END update_financial_report;

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

866: *
867: * ARGUMENTS
868: * IN:
869: * p_init_msg_list Initialize message stack if it is set to
870: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
871: * p_financial_report_id Financial report ID.
872: * IN/OUT:
873: * OUT:
874: * x_financial_report_rec Returned financial report record.

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

872: * IN/OUT:
873: * OUT:
874: * x_financial_report_rec Returned financial report record.
875: * x_return_status Return status after the call. The status can
876: * be FND_API.G_RET_STS_SUCCESS (success),
877: * FND_API.G_RET_STS_ERROR (error),
878: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
879: * x_msg_count Number of messages in message stack.
880: * x_msg_data Message text if x_msg_count is 1.

Line 877: * FND_API.G_RET_STS_ERROR (error),

873: * OUT:
874: * x_financial_report_rec Returned financial report record.
875: * x_return_status Return status after the call. The status can
876: * be FND_API.G_RET_STS_SUCCESS (success),
877: * FND_API.G_RET_STS_ERROR (error),
878: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
879: * x_msg_count Number of messages in message stack.
880: * x_msg_data Message text if x_msg_count is 1.
881: *

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

874: * x_financial_report_rec Returned financial report record.
875: * x_return_status Return status after the call. The status can
876: * be FND_API.G_RET_STS_SUCCESS (success),
877: * FND_API.G_RET_STS_ERROR (error),
878: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
879: * x_msg_count Number of messages in message stack.
880: * x_msg_data Message text if x_msg_count is 1.
881: *
882: * NOTES

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

886: * 23-JAN-2003 Sreedhar Mohan o Created.
887: */
888:
889: PROCEDURE get_financial_report_rec (
890: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
891: p_financial_report_id IN NUMBER,
892: p_financial_report_rec OUT NOCOPY FINANCIAL_REPORT_REC_TYPE,
893: x_return_status OUT NOCOPY VARCHAR2,
894: x_msg_count OUT NOCOPY NUMBER,

Line 903: IF FND_API.to_Boolean(p_init_msg_list) THEN

899:
900: BEGIN
901:
902: --Initialize message list if p_init_msg_list is set to TRUE.
903: IF FND_API.to_Boolean(p_init_msg_list) THEN
904: FND_MSG_PUB.initialize;
905: END IF;
906:
907: --Initialize API return status to success.

Line 908: x_return_status := FND_API.G_RET_STS_SUCCESS;

904: FND_MSG_PUB.initialize;
905: END IF;
906:
907: --Initialize API return status to success.
908: x_return_status := FND_API.G_RET_STS_SUCCESS;
909:
910: --Check whether primary key has been passed in.
911: IF p_financial_report_id IS NULL OR
912: p_financial_report_id = FND_API.G_MISS_NUM THEN

Line 912: p_financial_report_id = FND_API.G_MISS_NUM THEN

908: x_return_status := FND_API.G_RET_STS_SUCCESS;
909:
910: --Check whether primary key has been passed in.
911: IF p_financial_report_id IS NULL OR
912: p_financial_report_id = FND_API.G_MISS_NUM THEN
913: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
914: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'financial_report_id' );
915: FND_MSG_PUB.ADD;
916: RAISE FND_API.G_EXC_ERROR;

Line 916: RAISE FND_API.G_EXC_ERROR;

912: p_financial_report_id = FND_API.G_MISS_NUM THEN
913: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
914: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'financial_report_id' );
915: FND_MSG_PUB.ADD;
916: RAISE FND_API.G_EXC_ERROR;
917: END IF;
918:
919: -- The p_financial_report_rec.financial_report_id must be initiated to p_financial_report_id
920: p_financial_report_rec.financial_report_id := p_financial_report_id;

Line 955: p_encoded => FND_API.G_FALSE,

951: );
952:
953: --Standard call to get message count and if count is 1, get message info.
954: FND_MSG_PUB.Count_And_Get(
955: p_encoded => FND_API.G_FALSE,
956: p_count => x_msg_count,
957: p_data => x_msg_data );
958:
959: EXCEPTION

Line 960: WHEN FND_API.G_EXC_ERROR THEN

956: p_count => x_msg_count,
957: p_data => x_msg_data );
958:
959: EXCEPTION
960: WHEN FND_API.G_EXC_ERROR THEN
961: x_return_status := FND_API.G_RET_STS_ERROR;
962:
963: FND_MSG_PUB.Count_And_Get(
964: p_encoded => FND_API.G_FALSE,

Line 961: x_return_status := FND_API.G_RET_STS_ERROR;

957: p_data => x_msg_data );
958:
959: EXCEPTION
960: WHEN FND_API.G_EXC_ERROR THEN
961: x_return_status := FND_API.G_RET_STS_ERROR;
962:
963: FND_MSG_PUB.Count_And_Get(
964: p_encoded => FND_API.G_FALSE,
965: p_count => x_msg_count,

Line 964: p_encoded => FND_API.G_FALSE,

960: WHEN FND_API.G_EXC_ERROR THEN
961: x_return_status := FND_API.G_RET_STS_ERROR;
962:
963: FND_MSG_PUB.Count_And_Get(
964: p_encoded => FND_API.G_FALSE,
965: p_count => x_msg_count,
966: p_data => x_msg_data );
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

963: FND_MSG_PUB.Count_And_Get(
964: p_encoded => FND_API.G_FALSE,
965: p_count => x_msg_count,
966: p_data => x_msg_data );
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969:
970: FND_MSG_PUB.Count_And_Get(
971: p_encoded => FND_API.G_FALSE,

Line 968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

964: p_encoded => FND_API.G_FALSE,
965: p_count => x_msg_count,
966: p_data => x_msg_data );
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969:
970: FND_MSG_PUB.Count_And_Get(
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_msg_count,

Line 971: p_encoded => FND_API.G_FALSE,

967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
968: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
969:
970: FND_MSG_PUB.Count_And_Get(
971: p_encoded => FND_API.G_FALSE,
972: p_count => x_msg_count,
973: p_data => x_msg_data );
974:
975: WHEN OTHERS THEN

Line 976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

972: p_count => x_msg_count,
973: p_data => x_msg_data );
974:
975: WHEN OTHERS THEN
976: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
977:
978: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
979: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
980: FND_MSG_PUB.ADD;

Line 983: p_encoded => FND_API.G_FALSE,

979: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
980: FND_MSG_PUB.ADD;
981:
982: FND_MSG_PUB.Count_And_Get(
983: p_encoded => FND_API.G_FALSE,
984: p_count => x_msg_count,
985: p_data => x_msg_data );
986:
987: END get_financial_report_rec;

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

997: *
998: * ARGUMENTS
999: * IN:
1000: * p_init_msg_list Initialize message stack if it is set to
1001: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1002: * p_financial_number_rec financial_number record.
1003: * IN/OUT:
1004: * OUT:
1005: * x_financial_number_id financial_number ID.

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

1003: * IN/OUT:
1004: * OUT:
1005: * x_financial_number_id financial_number ID.
1006: * x_return_status Return status after the call. The status can
1007: * be FND_API.G_RET_STS_SUCCESS (success),
1008: * FND_API.G_RET_STS_ERROR (error),
1009: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1010: * x_msg_count Number of messages in message stack.
1011: * x_msg_data Message text if x_msg_count is 1.

Line 1008: * FND_API.G_RET_STS_ERROR (error),

1004: * OUT:
1005: * x_financial_number_id financial_number ID.
1006: * x_return_status Return status after the call. The status can
1007: * be FND_API.G_RET_STS_SUCCESS (success),
1008: * FND_API.G_RET_STS_ERROR (error),
1009: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1010: * x_msg_count Number of messages in message stack.
1011: * x_msg_data Message text if x_msg_count is 1.
1012: *

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

1005: * x_financial_number_id financial_number ID.
1006: * x_return_status Return status after the call. The status can
1007: * be FND_API.G_RET_STS_SUCCESS (success),
1008: * FND_API.G_RET_STS_ERROR (error),
1009: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1010: * x_msg_count Number of messages in message stack.
1011: * x_msg_data Message text if x_msg_count is 1.
1012: *
1013: * NOTES

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

1021: *
1022: */
1023:
1024: PROCEDURE create_financial_number(
1025: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1026: p_financial_number_rec IN FINANCIAL_NUMBER_REC_TYPE,
1027: x_financial_number_id OUT NOCOPY NUMBER,
1028: x_return_status OUT NOCOPY VARCHAR2,
1029: x_msg_count OUT NOCOPY NUMBER,

Line 1042: IF FND_API.to_Boolean(p_init_msg_list) THEN

1038: --Standard start of API savepoint
1039: SAVEPOINT create_financial_number;
1040:
1041: --Initialize message list if p_init_msg_list is set to TRUE.
1042: IF FND_API.to_Boolean(p_init_msg_list) THEN
1043: FND_MSG_PUB.initialize;
1044: END IF;
1045:
1046: --Initialize API return status to success.

Line 1047: x_return_status := FND_API.G_RET_STS_SUCCESS;

1043: FND_MSG_PUB.initialize;
1044: END IF;
1045:
1046: --Initialize API return status to success.
1047: x_return_status := FND_API.G_RET_STS_SUCCESS;
1048:
1049: --Bug 2868913: Removed the LoadDataSources from do_create_financial_number
1050: --and added here, as per V1 way.
1051: /* SSM SST Integration and Extension

Line 1073: IF x_return_status = FND_API.G_RET_STS_SUCCESS /*AND

1069: -- SSM SST Integration and Extension
1070: -- For non-profile entities, the concept of select/de-select data-sources is obsoleted.
1071: -- There is no need to check if the data-source is selected.
1072:
1073: IF x_return_status = FND_API.G_RET_STS_SUCCESS /*AND
1074: g_fin_is_datasource_selected = 'Y' */
1075: THEN
1076: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
1077: -- Invoke business event system.

Line 1091: p_encoded => FND_API.G_FALSE,

1087: END IF;
1088:
1089: --Standard call to get message count and if count is 1, get message info.
1090: FND_MSG_PUB.Count_And_Get(
1091: p_encoded => FND_API.G_FALSE,
1092: p_count => x_msg_count,
1093: p_data => x_msg_data);
1094:
1095: EXCEPTION

Line 1096: WHEN FND_API.G_EXC_ERROR THEN

1092: p_count => x_msg_count,
1093: p_data => x_msg_data);
1094:
1095: EXCEPTION
1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO create_financial_number;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: FND_MSG_PUB.Count_And_Get(
1100: p_encoded => FND_API.G_FALSE,

Line 1098: x_return_status := FND_API.G_RET_STS_ERROR;

1094:
1095: EXCEPTION
1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO create_financial_number;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: FND_MSG_PUB.Count_And_Get(
1100: p_encoded => FND_API.G_FALSE,
1101: p_count => x_msg_count,
1102: p_data => x_msg_data);

Line 1100: p_encoded => FND_API.G_FALSE,

1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO create_financial_number;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099: FND_MSG_PUB.Count_And_Get(
1100: p_encoded => FND_API.G_FALSE,
1101: p_count => x_msg_count,
1102: p_data => x_msg_data);
1103:
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1100: p_encoded => FND_API.G_FALSE,
1101: p_count => x_msg_count,
1102: p_data => x_msg_data);
1103:
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105: ROLLBACK TO create_financial_number;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: FND_MSG_PUB.Count_And_Get(
1108: p_encoded => FND_API.G_FALSE,

Line 1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1102: p_data => x_msg_data);
1103:
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105: ROLLBACK TO create_financial_number;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: FND_MSG_PUB.Count_And_Get(
1108: p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);

Line 1108: p_encoded => FND_API.G_FALSE,

1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105: ROLLBACK TO create_financial_number;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: FND_MSG_PUB.Count_And_Get(
1108: p_encoded => FND_API.G_FALSE,
1109: p_count => x_msg_count,
1110: p_data => x_msg_data);
1111:
1112: WHEN OTHERS THEN

Line 1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1110: p_data => x_msg_data);
1111:
1112: WHEN OTHERS THEN
1113: ROLLBACK TO create_financial_number;
1114: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1117: FND_MSG_PUB.ADD;
1118: FND_MSG_PUB.Count_And_Get(

Line 1119: p_encoded => FND_API.G_FALSE,

1115: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1116: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1117: FND_MSG_PUB.ADD;
1118: FND_MSG_PUB.Count_And_Get(
1119: p_encoded => FND_API.G_FALSE,
1120: p_count => x_msg_count,
1121: p_data => x_msg_data);
1122:
1123: END create_financial_number;

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

1133: *
1134: * ARGUMENTS
1135: * IN:
1136: * p_init_msg_list Initialize message stack if it is set to
1137: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1138: * p_financial_number_rec Financial Number record.
1139: * IN/OUT:
1140: * p_object_version_number Used for locking the being updated record.
1141: * OUT:

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

1139: * IN/OUT:
1140: * p_object_version_number Used for locking the being updated record.
1141: * OUT:
1142: * x_return_status Return status after the call. The status can
1143: * be FND_API.G_RET_STS_SUCCESS (success),
1144: * FND_API.G_RET_STS_ERROR (error),
1145: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1146: * x_msg_count Number of messages in message stack.
1147: * x_msg_data Message text if x_msg_count is 1.

Line 1144: * FND_API.G_RET_STS_ERROR (error),

1140: * p_object_version_number Used for locking the being updated record.
1141: * OUT:
1142: * x_return_status Return status after the call. The status can
1143: * be FND_API.G_RET_STS_SUCCESS (success),
1144: * FND_API.G_RET_STS_ERROR (error),
1145: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1146: * x_msg_count Number of messages in message stack.
1147: * x_msg_data Message text if x_msg_count is 1.
1148: *

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

1141: * OUT:
1142: * x_return_status Return status after the call. The status can
1143: * be FND_API.G_RET_STS_SUCCESS (success),
1144: * FND_API.G_RET_STS_ERROR (error),
1145: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1146: * x_msg_count Number of messages in message stack.
1147: * x_msg_data Message text if x_msg_count is 1.
1148: *
1149: * NOTES

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

1157: *
1158: */
1159:
1160: PROCEDURE update_financial_number(
1161: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1162: p_financial_number_rec IN FINANCIAL_NUMBER_REC_TYPE,
1163: p_object_version_number IN OUT NOCOPY NUMBER,
1164: x_return_status OUT NOCOPY VARCHAR2,
1165: x_msg_count OUT NOCOPY NUMBER,

Line 1179: IF FND_API.to_Boolean(p_init_msg_list) THEN

1175: --Standard start of API savepoint
1176: SAVEPOINT update_financial_number;
1177:
1178: --Initialize message list if p_init_msg_list is set to TRUE.
1179: IF FND_API.to_Boolean(p_init_msg_list) THEN
1180: FND_MSG_PUB.initialize;
1181: END IF;
1182:
1183: --Initialize API return status to success.

Line 1184: x_return_status := FND_API.G_RET_STS_SUCCESS;

1180: FND_MSG_PUB.initialize;
1181: END IF;
1182:
1183: --Initialize API return status to success.
1184: x_return_status := FND_API.G_RET_STS_SUCCESS;
1185:
1186: get_financial_number_rec (
1187: p_financial_number_id => p_financial_number_rec.financial_number_id,
1188: p_financial_number_rec => l_old_financial_number_rec,

Line 1193: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1189: x_return_status => x_return_status,
1190: x_msg_count => x_msg_count,
1191: x_msg_data => x_msg_data);
1192:
1193: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;

Line 1194: RAISE FND_API.G_EXC_ERROR;

1190: x_msg_count => x_msg_count,
1191: x_msg_data => x_msg_data);
1192:
1193: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:

Line 1195: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1191: x_msg_data => x_msg_data);
1192:
1193: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:
1199: -- Bug 2868913: default the actual_content_source through mixnm API

Line 1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1192:
1193: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1194: RAISE FND_API.G_EXC_ERROR;
1195: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1197: END IF;
1198:
1199: -- Bug 2868913: default the actual_content_source through mixnm API
1200: /* SSM SST Integration and Extension

Line 1217: IF x_return_status = FND_API.G_RET_STS_SUCCESS /*AND

1213: p_object_version_number,
1214: x_return_status);
1215:
1216: -- Bug 2868913: Added one more condition, g_fin_is_datasource_selected = Y, before calling business event
1217: IF x_return_status = FND_API.G_RET_STS_SUCCESS /*AND
1218: g_fin_is_datasource_selected = 'Y'*/
1219: THEN
1220: --Bug 2979651: Since 2907261 made to HZ.K, keeping back the changes of 115.8 version.
1221: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN

Line 1236: p_encoded => FND_API.G_FALSE,

1232: END IF;
1233:
1234: --Standard call to get message count and if count is 1, get message info.
1235: FND_MSG_PUB.Count_And_Get(
1236: p_encoded => FND_API.G_FALSE,
1237: p_count => x_msg_count,
1238: p_data => x_msg_data);
1239:
1240: EXCEPTION

Line 1241: WHEN FND_API.G_EXC_ERROR THEN

1237: p_count => x_msg_count,
1238: p_data => x_msg_data);
1239:
1240: EXCEPTION
1241: WHEN FND_API.G_EXC_ERROR THEN
1242: ROLLBACK TO update_financial_number;
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: FND_MSG_PUB.Count_And_Get(
1245: p_encoded => FND_API.G_FALSE,

Line 1243: x_return_status := FND_API.G_RET_STS_ERROR;

1239:
1240: EXCEPTION
1241: WHEN FND_API.G_EXC_ERROR THEN
1242: ROLLBACK TO update_financial_number;
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: FND_MSG_PUB.Count_And_Get(
1245: p_encoded => FND_API.G_FALSE,
1246: p_count => x_msg_count,
1247: p_data => x_msg_data);

Line 1245: p_encoded => FND_API.G_FALSE,

1241: WHEN FND_API.G_EXC_ERROR THEN
1242: ROLLBACK TO update_financial_number;
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: FND_MSG_PUB.Count_And_Get(
1245: p_encoded => FND_API.G_FALSE,
1246: p_count => x_msg_count,
1247: p_data => x_msg_data);
1248:
1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1245: p_encoded => FND_API.G_FALSE,
1246: p_count => x_msg_count,
1247: p_data => x_msg_data);
1248:
1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1250: ROLLBACK TO update_financial_number;
1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1252: FND_MSG_PUB.Count_And_Get(
1253: p_encoded => FND_API.G_FALSE,

Line 1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1247: p_data => x_msg_data);
1248:
1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1250: ROLLBACK TO update_financial_number;
1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1252: FND_MSG_PUB.Count_And_Get(
1253: p_encoded => FND_API.G_FALSE,
1254: p_count => x_msg_count,
1255: p_data => x_msg_data);

Line 1253: p_encoded => FND_API.G_FALSE,

1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1250: ROLLBACK TO update_financial_number;
1251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1252: FND_MSG_PUB.Count_And_Get(
1253: p_encoded => FND_API.G_FALSE,
1254: p_count => x_msg_count,
1255: p_data => x_msg_data);
1256:
1257: WHEN OTHERS THEN

Line 1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1255: p_data => x_msg_data);
1256:
1257: WHEN OTHERS THEN
1258: ROLLBACK TO update_financial_number;
1259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1260: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1262: FND_MSG_PUB.ADD;
1263: FND_MSG_PUB.Count_And_Get(

Line 1264: p_encoded => FND_API.G_FALSE,

1260: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1261: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1262: FND_MSG_PUB.ADD;
1263: FND_MSG_PUB.Count_And_Get(
1264: p_encoded => FND_API.G_FALSE,
1265: p_count => x_msg_count,
1266: p_data => x_msg_data);
1267:
1268: END update_financial_number;

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

1278: *
1279: * ARGUMENTS
1280: * IN:
1281: * p_init_msg_list Initialize message stack if it is set to
1282: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
1283: * p_financial_number_id Financial Number ID.
1284: * IN/OUT:
1285: * OUT:
1286: * x_financial_number_rec Returned financial number record.

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

1284: * IN/OUT:
1285: * OUT:
1286: * x_financial_number_rec Returned financial number record.
1287: * x_return_status Return status after the call. The status can
1288: * be FND_API.G_RET_STS_SUCCESS (success),
1289: * FND_API.G_RET_STS_ERROR (error),
1290: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1291: * x_msg_count Number of messages in message stack.
1292: * x_msg_data Message text if x_msg_count is 1.

Line 1289: * FND_API.G_RET_STS_ERROR (error),

1285: * OUT:
1286: * x_financial_number_rec Returned financial number record.
1287: * x_return_status Return status after the call. The status can
1288: * be FND_API.G_RET_STS_SUCCESS (success),
1289: * FND_API.G_RET_STS_ERROR (error),
1290: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1291: * x_msg_count Number of messages in message stack.
1292: * x_msg_data Message text if x_msg_count is 1.
1293: *

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

1286: * x_financial_number_rec Returned financial number record.
1287: * x_return_status Return status after the call. The status can
1288: * be FND_API.G_RET_STS_SUCCESS (success),
1289: * FND_API.G_RET_STS_ERROR (error),
1290: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
1291: * x_msg_count Number of messages in message stack.
1292: * x_msg_data Message text if x_msg_count is 1.
1293: *
1294: * NOTES

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

1298: * 23-JAN-2003 Sreedhar Mohan o Created.
1299: */
1300:
1301: PROCEDURE get_financial_number_rec (
1302: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1303: p_financial_number_id IN NUMBER,
1304: p_financial_number_rec OUT NOCOPY FINANCIAL_NUMBER_REC_TYPE,
1305: x_return_status OUT NOCOPY VARCHAR2,
1306: x_msg_count OUT NOCOPY NUMBER,

Line 1315: IF FND_API.to_Boolean(p_init_msg_list) THEN

1311:
1312: BEGIN
1313:
1314: --Initialize message list if p_init_msg_list is set to TRUE.
1315: IF FND_API.to_Boolean(p_init_msg_list) THEN
1316: FND_MSG_PUB.initialize;
1317: END IF;
1318:
1319: --Initialize API return status to success.

Line 1320: x_return_status := FND_API.G_RET_STS_SUCCESS;

1316: FND_MSG_PUB.initialize;
1317: END IF;
1318:
1319: --Initialize API return status to success.
1320: x_return_status := FND_API.G_RET_STS_SUCCESS;
1321:
1322: --Check whether primary key has been passed in.
1323: IF p_financial_number_id IS NULL OR
1324: p_financial_number_id = FND_API.G_MISS_NUM THEN

Line 1324: p_financial_number_id = FND_API.G_MISS_NUM THEN

1320: x_return_status := FND_API.G_RET_STS_SUCCESS;
1321:
1322: --Check whether primary key has been passed in.
1323: IF p_financial_number_id IS NULL OR
1324: p_financial_number_id = FND_API.G_MISS_NUM THEN
1325: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1326: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'financial_number_id' );
1327: FND_MSG_PUB.ADD;
1328: RAISE FND_API.G_EXC_ERROR;

Line 1328: RAISE FND_API.G_EXC_ERROR;

1324: p_financial_number_id = FND_API.G_MISS_NUM THEN
1325: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
1326: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'financial_number_id' );
1327: FND_MSG_PUB.ADD;
1328: RAISE FND_API.G_EXC_ERROR;
1329: END IF;
1330:
1331: -- The p_financial_number_rec.financial_number_id must be initiated to p_financial_number_id
1332: p_financial_number_rec.financial_number_id := p_financial_number_id;

Line 1350: p_encoded => FND_API.G_FALSE,

1346: );
1347:
1348: --Standard call to get message count and if count is 1, get message info.
1349: FND_MSG_PUB.Count_And_Get(
1350: p_encoded => FND_API.G_FALSE,
1351: p_count => x_msg_count,
1352: p_data => x_msg_data );
1353:
1354: EXCEPTION

Line 1355: WHEN FND_API.G_EXC_ERROR THEN

1351: p_count => x_msg_count,
1352: p_data => x_msg_data );
1353:
1354: EXCEPTION
1355: WHEN FND_API.G_EXC_ERROR THEN
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357:
1358: FND_MSG_PUB.Count_And_Get(
1359: p_encoded => FND_API.G_FALSE,

Line 1356: x_return_status := FND_API.G_RET_STS_ERROR;

1352: p_data => x_msg_data );
1353:
1354: EXCEPTION
1355: WHEN FND_API.G_EXC_ERROR THEN
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357:
1358: FND_MSG_PUB.Count_And_Get(
1359: p_encoded => FND_API.G_FALSE,
1360: p_count => x_msg_count,

Line 1359: p_encoded => FND_API.G_FALSE,

1355: WHEN FND_API.G_EXC_ERROR THEN
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357:
1358: FND_MSG_PUB.Count_And_Get(
1359: p_encoded => FND_API.G_FALSE,
1360: p_count => x_msg_count,
1361: p_data => x_msg_data );
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1358: FND_MSG_PUB.Count_And_Get(
1359: p_encoded => FND_API.G_FALSE,
1360: p_count => x_msg_count,
1361: p_data => x_msg_data );
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364:
1365: FND_MSG_PUB.Count_And_Get(
1366: p_encoded => FND_API.G_FALSE,

Line 1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1359: p_encoded => FND_API.G_FALSE,
1360: p_count => x_msg_count,
1361: p_data => x_msg_data );
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364:
1365: FND_MSG_PUB.Count_And_Get(
1366: p_encoded => FND_API.G_FALSE,
1367: p_count => x_msg_count,

Line 1366: p_encoded => FND_API.G_FALSE,

1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364:
1365: FND_MSG_PUB.Count_And_Get(
1366: p_encoded => FND_API.G_FALSE,
1367: p_count => x_msg_count,
1368: p_data => x_msg_data );
1369:
1370: WHEN OTHERS THEN

Line 1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1367: p_count => x_msg_count,
1368: p_data => x_msg_data );
1369:
1370: WHEN OTHERS THEN
1371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1372:
1373: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
1374: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1375: FND_MSG_PUB.ADD;

Line 1378: p_encoded => FND_API.G_FALSE,

1374: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
1375: FND_MSG_PUB.ADD;
1376:
1377: FND_MSG_PUB.Count_And_Get(
1378: p_encoded => FND_API.G_FALSE,
1379: p_count => x_msg_count,
1380: p_data => x_msg_data );
1381:
1382: END get_financial_number_rec;