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

Line 131: p_credit_rating_rec.credit_rating_id <> FND_API.G_MISS_NUM

127: BEGIN
128:
129: -- if primary key value is passed, check for uniqueness.
130: IF p_credit_rating_rec.credit_rating_id IS NOT NULL AND
131: p_credit_rating_rec.credit_rating_id <> FND_API.G_MISS_NUM
132: THEN
133: BEGIN
134: SELECT 'Y' INTO l_dummy
135: FROM HZ_CREDIT_RATINGS

Line 141: RAISE FND_API.G_EXC_ERROR;

137:
138: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
139: FND_MESSAGE.SET_TOKEN('COLUMN', 'credit_rating_id');
140: FND_MSG_PUB.ADD;
141: RAISE FND_API.G_EXC_ERROR;
142:
143: EXCEPTION
144: WHEN NO_DATA_FOUND THEN
145: NULL;

Line 156: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

152: p_credit_rating_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: -- call table handler to insert a row

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: -- call table handler to insert a row
161: HZ_CREDIT_RATINGS_PKG.Insert_Row (

Line 173: x_suit_judge_ind => FND_API.G_MISS_CHAR,

169: x_comments => p_credit_rating_rec.comments,
170: x_det_history_ind => p_credit_rating_rec.det_history_ind,
171: x_fincl_embt_ind => p_credit_rating_rec.fincl_embt_ind,
172: x_criminal_proceeding_ind => p_credit_rating_rec.criminal_proceeding_ind,
173: x_suit_judge_ind => FND_API.G_MISS_CHAR,
174: x_claims_ind => p_credit_rating_rec.claims_ind,
175: x_secured_flng_ind => p_credit_rating_rec.secured_flng_ind,
176: x_fincl_lgl_event_ind => p_credit_rating_rec.fincl_lgl_event_ind,
177: x_disaster_ind => p_credit_rating_rec.disaster_ind,

Line 180: x_content_source_type => FND_API.G_MISS_CHAR,

176: x_fincl_lgl_event_ind => p_credit_rating_rec.fincl_lgl_event_ind,
177: x_disaster_ind => p_credit_rating_rec.disaster_ind,
178: x_oprg_spec_evnt_ind => p_credit_rating_rec.oprg_spec_evnt_ind,
179: x_other_spec_evnt_ind => p_credit_rating_rec.other_spec_evnt_ind,
180: x_content_source_type => FND_API.G_MISS_CHAR,
181: x_status => p_credit_rating_rec.status,
182: x_object_version_number => 1,
183: x_created_by_module => p_credit_rating_rec.created_by_module,
184: x_avg_high_credit => p_credit_rating_rec.avg_high_credit,

Line 340: RAISE FND_API.G_EXC_ERROR;

336: THEN
337: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
338: FND_MESSAGE.SET_TOKEN('TABLE', 'HZ_CREDIT_RATINGS');
339: FND_MSG_PUB.ADD;
340: RAISE FND_API.G_EXC_ERROR;
341: END IF;
342:
343: p_object_version_number := nvl(l_object_version_number, 1) + 1;
344:

Line 351: RAISE FND_API.G_EXC_ERROR;

347: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
348: FND_MESSAGE.SET_TOKEN('RECORD', 'HZ_CREDIT_RATINGS');
349: FND_MESSAGE.SET_TOKEN('VALUE', NVL( TO_CHAR( p_credit_rating_rec.credit_rating_id ), 'null' ) );
350: FND_MSG_PUB.ADD;
351: RAISE FND_API.G_EXC_ERROR;
352: END;
353:
354: -- validate person interest record
355: HZ_REGISTRY_VALIDATE_V2PUB.validate_credit_rating(

Line 361: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

357: p_credit_rating_rec,
358: l_rowid,
359: x_return_status);
360:
361: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: -- Bug 4693719 : pass NULL if the secure data is not updated

Line 362: RAISE FND_API.G_EXC_ERROR;

358: l_rowid,
359: x_return_status);
360:
361: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:
365: -- Bug 4693719 : pass NULL if the secure data is not updated
366: IF HZ_UTILITY_V2PUB.G_UPDATE_ACS = 'Y' THEN

Line 385: x_suit_judge_ind => FND_API.G_MISS_CHAR,

381: x_comments => p_credit_rating_rec.comments,
382: x_det_history_ind => p_credit_rating_rec.det_history_ind,
383: x_fincl_embt_ind => p_credit_rating_rec.fincl_embt_ind,
384: x_criminal_proceeding_ind => p_credit_rating_rec.criminal_proceeding_ind,
385: x_suit_judge_ind => FND_API.G_MISS_CHAR,
386: x_claims_ind => p_credit_rating_rec.claims_ind,
387: x_secured_flng_ind => p_credit_rating_rec.secured_flng_ind,
388: x_fincl_lgl_event_ind => p_credit_rating_rec.fincl_lgl_event_ind,
389: x_disaster_ind => p_credit_rating_rec.disaster_ind,

Line 392: x_content_source_type => FND_API.G_MISS_CHAR,

388: x_fincl_lgl_event_ind => p_credit_rating_rec.fincl_lgl_event_ind,
389: x_disaster_ind => p_credit_rating_rec.disaster_ind,
390: x_oprg_spec_evnt_ind => p_credit_rating_rec.oprg_spec_evnt_ind,
391: x_other_spec_evnt_ind => p_credit_rating_rec.other_spec_evnt_ind,
392: x_content_source_type => FND_API.G_MISS_CHAR,
393: x_status => p_credit_rating_rec.status,
394: x_object_version_number => p_object_version_number,
395: x_created_by_module => p_credit_rating_rec.created_by_module,
396: x_avg_high_credit => p_credit_rating_rec.avg_high_credit,

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

490: *
491: * ARGUMENTS
492: * IN:
493: * p_init_msg_list Initialize message stack if it is set to
494: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
495: * p_credit_rating_rec Credit rating record.
496: * IN/OUT:
497: * OUT:
498: * credit_rating_id Credit rating Id.

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

496: * IN/OUT:
497: * OUT:
498: * credit_rating_id Credit rating Id.
499: * x_return_status Return status after the call. The status can
500: * be FND_API.G_RET_STS_SUCCESS (success),
501: * FND_API.G_RET_STS_ERROR (error),
502: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
503: * x_msg_count Number of messages in message stack.
504: * x_msg_data Message text if x_msg_count is 1.

Line 501: * FND_API.G_RET_STS_ERROR (error),

497: * OUT:
498: * credit_rating_id Credit rating Id.
499: * x_return_status Return status after the call. The status can
500: * be FND_API.G_RET_STS_SUCCESS (success),
501: * FND_API.G_RET_STS_ERROR (error),
502: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
503: * x_msg_count Number of messages in message stack.
504: * x_msg_data Message text if x_msg_count is 1.
505: *

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

498: * credit_rating_id Credit rating Id.
499: * x_return_status Return status after the call. The status can
500: * be FND_API.G_RET_STS_SUCCESS (success),
501: * FND_API.G_RET_STS_ERROR (error),
502: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
503: * x_msg_count Number of messages in message stack.
504: * x_msg_data Message text if x_msg_count is 1.
505: *
506: * NOTES

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

514: *
515: */
516:
517: PROCEDURE create_credit_rating(
518: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
519: p_credit_rating_rec IN CREDIT_RATING_REC_TYPE,
520: x_credit_rating_id OUT NOCOPY NUMBER,
521: x_return_status OUT NOCOPY VARCHAR2,
522: x_msg_count OUT NOCOPY NUMBER,

Line 537: IF FND_API.to_Boolean(p_init_msg_list) THEN

533: --Standard start of API savepoint
534: SAVEPOINT create_credit_rating;
535:
536: --Initialize message list if p_init_msg_list is set to TRUE.
537: IF FND_API.to_Boolean(p_init_msg_list) THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: --Initialize API return status to success.

Line 542: x_return_status := FND_API.G_RET_STS_SUCCESS;

538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: --Initialize API return status to success.
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543:
544:
545: -- Bug 4222898
546: HZ_MIXNM_UTILITY.AssignDataSourceDuringCreation (

Line 565: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

561: x_credit_rating_id,
562: x_return_status);
563:
564:
565: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
566: -- Invoke business event system.
567: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
568: HZ_BUSINESS_EVENT_V2PVT.create_credit_ratings_event(l_credit_rating_rec );
569: END IF;

Line 582: p_encoded => FND_API.G_FALSE,

578:
579:
580: --Standard call to get message count and if count is 1, get message info.
581: FND_MSG_PUB.Count_And_Get(
582: p_encoded => FND_API.G_FALSE,
583: p_count => x_msg_count,
584: p_data => x_msg_data);
585:
586: EXCEPTION

Line 587: WHEN FND_API.G_EXC_ERROR THEN

583: p_count => x_msg_count,
584: p_data => x_msg_data);
585:
586: EXCEPTION
587: WHEN FND_API.G_EXC_ERROR THEN
588: ROLLBACK TO create_credit_rating;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585:
586: EXCEPTION
587: WHEN FND_API.G_EXC_ERROR THEN
588: ROLLBACK TO create_credit_rating;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: FND_MSG_PUB.Count_And_Get(
591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data);

Line 591: p_encoded => FND_API.G_FALSE,

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

Line 595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

591: p_encoded => FND_API.G_FALSE,
592: p_count => x_msg_count,
593: p_data => x_msg_data);
594:
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO create_credit_rating;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: FND_MSG_PUB.Count_And_Get(
599: p_encoded => FND_API.G_FALSE,

Line 597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

593: p_data => x_msg_data);
594:
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO create_credit_rating;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: FND_MSG_PUB.Count_And_Get(
599: p_encoded => FND_API.G_FALSE,
600: p_count => x_msg_count,
601: p_data => x_msg_data);

Line 599: p_encoded => FND_API.G_FALSE,

595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO create_credit_rating;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: FND_MSG_PUB.Count_And_Get(
599: p_encoded => FND_API.G_FALSE,
600: p_count => x_msg_count,
601: p_data => x_msg_data);
602:
603: WHEN OTHERS THEN

Line 605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

601: p_data => x_msg_data);
602:
603: WHEN OTHERS THEN
604: ROLLBACK TO create_credit_rating;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
608: FND_MSG_PUB.ADD;
609: FND_MSG_PUB.Count_And_Get(

Line 610: p_encoded => FND_API.G_FALSE,

606: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
607: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
608: FND_MSG_PUB.ADD;
609: FND_MSG_PUB.Count_And_Get(
610: p_encoded => FND_API.G_FALSE,
611: p_count => x_msg_count,
612: p_data => x_msg_data);
613:
614: END create_credit_rating;

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

624: *
625: * ARGUMENTS
626: * IN:
627: * p_init_msg_list Initialize message stack if it is set to
628: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
629: * p_credit_rating_rec Credit rating record.
630: * IN/OUT:
631: * p_object_version_number Used for locking the being updated record.
632: * OUT:

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

630: * IN/OUT:
631: * p_object_version_number Used for locking the being updated record.
632: * OUT:
633: * x_return_status Return status after the call. The status can
634: * be FND_API.G_RET_STS_SUCCESS (success),
635: * FND_API.G_RET_STS_ERROR (error),
636: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
637: * x_msg_count Number of messages in message stack.
638: * x_msg_data Message text if x_msg_count is 1.

Line 635: * FND_API.G_RET_STS_ERROR (error),

631: * p_object_version_number Used for locking the being updated record.
632: * OUT:
633: * x_return_status Return status after the call. The status can
634: * be FND_API.G_RET_STS_SUCCESS (success),
635: * FND_API.G_RET_STS_ERROR (error),
636: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
637: * x_msg_count Number of messages in message stack.
638: * x_msg_data Message text if x_msg_count is 1.
639: *

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

632: * OUT:
633: * x_return_status Return status after the call. The status can
634: * be FND_API.G_RET_STS_SUCCESS (success),
635: * FND_API.G_RET_STS_ERROR (error),
636: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
637: * x_msg_count Number of messages in message stack.
638: * x_msg_data Message text if x_msg_count is 1.
639: *
640: * NOTES

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

645: *
646: */
647:
648: PROCEDURE update_credit_rating(
649: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
650: p_credit_rating_rec IN CREDIT_RATING_REC_TYPE,
651: p_object_version_number IN OUT NOCOPY NUMBER,
652: x_return_status OUT NOCOPY VARCHAR2,
653: x_msg_count OUT NOCOPY NUMBER,

Line 667: IF FND_API.to_Boolean(p_init_msg_list) THEN

663: --Standard start of API savepoint
664: SAVEPOINT update_credit_rating;
665:
666: --Initialize message list if p_init_msg_list is set to TRUE.
667: IF FND_API.to_Boolean(p_init_msg_list) THEN
668: FND_MSG_PUB.initialize;
669: END IF;
670:
671: --Initialize API return status to success.

Line 672: x_return_status := FND_API.G_RET_STS_SUCCESS;

668: FND_MSG_PUB.initialize;
669: END IF;
670:
671: --Initialize API return status to success.
672: x_return_status := FND_API.G_RET_STS_SUCCESS;
673:
674: get_credit_rating_rec (
675: p_credit_rating_id => p_credit_rating_rec.credit_rating_id,
676: x_credit_rating_rec => l_old_credit_rating_rec,

Line 681: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

677: x_return_status => x_return_status,
678: x_msg_count => x_msg_count,
679: x_msg_data => x_msg_data);
680:
681: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
682: RAISE FND_API.G_EXC_ERROR;
683: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;

Line 682: RAISE FND_API.G_EXC_ERROR;

678: x_msg_count => x_msg_count,
679: x_msg_data => x_msg_data);
680:
681: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
682: RAISE FND_API.G_EXC_ERROR;
683: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:

Line 683: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

679: x_msg_data => x_msg_data);
680:
681: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
682: RAISE FND_API.G_EXC_ERROR;
683: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:
687: -- Call to business logic.

Line 684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

680:
681: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
682: RAISE FND_API.G_EXC_ERROR;
683: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: END IF;
686:
687: -- Call to business logic.
688: do_update_credit_rating(

Line 694: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

690: p_object_version_number,
691: x_return_status);
692:
693:
694: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
695: -- Invoke business event system.
696: --Bug 2979651: Since 2907261 made to HZ.K, keeping back the changes of 115.4 version.
697: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('Y', 'EVENTS_ENABLED')) THEN
698: HZ_BUSINESS_EVENT_V2PVT.update_credit_ratings_event(

Line 714: p_encoded => FND_API.G_FALSE,

710: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
711:
712: --Standard call to get message count and if count is 1, get message info.
713: FND_MSG_PUB.Count_And_Get(
714: p_encoded => FND_API.G_FALSE,
715: p_count => x_msg_count,
716: p_data => x_msg_data);
717:
718: EXCEPTION

Line 719: WHEN FND_API.G_EXC_ERROR THEN

715: p_count => x_msg_count,
716: p_data => x_msg_data);
717:
718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO update_credit_rating;
721: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get(

Line 722: x_return_status := FND_API.G_RET_STS_ERROR;

718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO update_credit_rating;
721: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get(
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data);

Line 724: p_encoded => FND_API.G_FALSE,

720: ROLLBACK TO update_credit_rating;
721: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
722: x_return_status := FND_API.G_RET_STS_ERROR;
723: FND_MSG_PUB.Count_And_Get(
724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data);
727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

724: p_encoded => FND_API.G_FALSE,
725: p_count => x_msg_count,
726: p_data => x_msg_data);
727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO update_credit_rating;
730: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
732: FND_MSG_PUB.Count_And_Get(

Line 731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO update_credit_rating;
730: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
732: FND_MSG_PUB.Count_And_Get(
733: p_encoded => FND_API.G_FALSE,
734: p_count => x_msg_count,
735: p_data => x_msg_data);

Line 733: p_encoded => FND_API.G_FALSE,

729: ROLLBACK TO update_credit_rating;
730: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
732: FND_MSG_PUB.Count_And_Get(
733: p_encoded => FND_API.G_FALSE,
734: p_count => x_msg_count,
735: p_data => x_msg_data);
736:
737: WHEN OTHERS THEN

Line 740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

736:
737: WHEN OTHERS THEN
738: ROLLBACK TO update_credit_rating;
739: HZ_UTILITY_V2PUB.G_UPDATE_ACS := NULL;
740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
741: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
742: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
743: FND_MSG_PUB.ADD;
744: FND_MSG_PUB.Count_And_Get(

Line 745: p_encoded => FND_API.G_FALSE,

741: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
742: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
743: FND_MSG_PUB.ADD;
744: FND_MSG_PUB.Count_And_Get(
745: p_encoded => FND_API.G_FALSE,
746: p_count => x_msg_count,
747: p_data => x_msg_data);
748:
749: END update_credit_rating;

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

759: *
760: * ARGUMENTS
761: * IN:
762: * p_init_msg_list Initialize message stack if it is set to
763: * FND_API.G_TRUE. Default is FND_API.G_FALSE.
764: * p_credit_rating_id Credit rating Id.
765: * IN/OUT:
766: * OUT:
767: * x_credit_rating_rec Returned credit rating record.

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

765: * IN/OUT:
766: * OUT:
767: * x_credit_rating_rec Returned credit rating record.
768: * x_return_status Return status after the call. The status can
769: * be FND_API.G_RET_STS_SUCCESS (success),
770: * FND_API.G_RET_STS_ERROR (error),
771: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
772: * x_msg_count Number of messages in message stack.
773: * x_msg_data Message text if x_msg_count is 1.

Line 770: * FND_API.G_RET_STS_ERROR (error),

766: * OUT:
767: * x_credit_rating_rec Returned credit rating record.
768: * x_return_status Return status after the call. The status can
769: * be FND_API.G_RET_STS_SUCCESS (success),
770: * FND_API.G_RET_STS_ERROR (error),
771: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
772: * x_msg_count Number of messages in message stack.
773: * x_msg_data Message text if x_msg_count is 1.
774: *

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

767: * x_credit_rating_rec Returned credit rating record.
768: * x_return_status Return status after the call. The status can
769: * be FND_API.G_RET_STS_SUCCESS (success),
770: * FND_API.G_RET_STS_ERROR (error),
771: * FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
772: * x_msg_count Number of messages in message stack.
773: * x_msg_data Message text if x_msg_count is 1.
774: *
775: * NOTES

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

780: *
781: */
782:
783: PROCEDURE get_credit_rating_rec (
784: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
785: p_credit_rating_id IN NUMBER,
786: x_credit_rating_rec OUT NOCOPY CREDIT_RATING_REC_TYPE,
787: x_return_status OUT NOCOPY VARCHAR2,
788: x_msg_count OUT NOCOPY NUMBER,

Line 797: IF FND_API.to_Boolean(p_init_msg_list) THEN

793:
794: BEGIN
795:
796: --Initialize message list if p_init_msg_list is set to TRUE.
797: IF FND_API.to_Boolean(p_init_msg_list) THEN
798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: --Initialize API return status to success.

Line 802: x_return_status := FND_API.G_RET_STS_SUCCESS;

798: FND_MSG_PUB.initialize;
799: END IF;
800:
801: --Initialize API return status to success.
802: x_return_status := FND_API.G_RET_STS_SUCCESS;
803:
804: --Check whether primary key has been passed in.
805: IF p_credit_rating_id IS NULL OR
806: p_credit_rating_id = FND_API.G_MISS_NUM THEN

Line 806: p_credit_rating_id = FND_API.G_MISS_NUM THEN

802: x_return_status := FND_API.G_RET_STS_SUCCESS;
803:
804: --Check whether primary key has been passed in.
805: IF p_credit_rating_id IS NULL OR
806: p_credit_rating_id = FND_API.G_MISS_NUM THEN
807: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
808: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_rating_id' );
809: FND_MSG_PUB.ADD;
810: RAISE FND_API.G_EXC_ERROR;

Line 810: RAISE FND_API.G_EXC_ERROR;

806: p_credit_rating_id = FND_API.G_MISS_NUM THEN
807: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_MISSING_COLUMN' );
808: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'credit_rating_id' );
809: FND_MSG_PUB.ADD;
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:
813: -- The x_credit_rating_rec.credit_rating_id must be initiated to p_credit_rating_id
814: x_credit_rating_rec.credit_rating_id := p_credit_rating_id;

Line 917: p_encoded => FND_API.G_FALSE,

913: );
914:
915: --Standard call to get message count and if count is 1, get message info.
916: FND_MSG_PUB.Count_And_Get(
917: p_encoded => FND_API.G_FALSE,
918: p_count => x_msg_count,
919: p_data => x_msg_data );
920:
921: EXCEPTION

Line 922: WHEN FND_API.G_EXC_ERROR THEN

918: p_count => x_msg_count,
919: p_data => x_msg_data );
920:
921: EXCEPTION
922: WHEN FND_API.G_EXC_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924:
925: FND_MSG_PUB.Count_And_Get(
926: p_encoded => FND_API.G_FALSE,

Line 923: x_return_status := FND_API.G_RET_STS_ERROR;

919: p_data => x_msg_data );
920:
921: EXCEPTION
922: WHEN FND_API.G_EXC_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924:
925: FND_MSG_PUB.Count_And_Get(
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,

Line 926: p_encoded => FND_API.G_FALSE,

922: WHEN FND_API.G_EXC_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924:
925: FND_MSG_PUB.Count_And_Get(
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data );
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

925: FND_MSG_PUB.Count_And_Get(
926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data );
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931:
932: FND_MSG_PUB.Count_And_Get(
933: p_encoded => FND_API.G_FALSE,

Line 930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

926: p_encoded => FND_API.G_FALSE,
927: p_count => x_msg_count,
928: p_data => x_msg_data );
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931:
932: FND_MSG_PUB.Count_And_Get(
933: p_encoded => FND_API.G_FALSE,
934: p_count => x_msg_count,

Line 933: p_encoded => FND_API.G_FALSE,

929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931:
932: FND_MSG_PUB.Count_And_Get(
933: p_encoded => FND_API.G_FALSE,
934: p_count => x_msg_count,
935: p_data => x_msg_data );
936:
937: WHEN OTHERS THEN

Line 938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

934: p_count => x_msg_count,
935: p_data => x_msg_data );
936:
937: WHEN OTHERS THEN
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
939:
940: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OTHERS_EXCEP' );
941: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
942: FND_MSG_PUB.ADD;

Line 945: p_encoded => FND_API.G_FALSE,

941: FND_MESSAGE.SET_TOKEN( 'ERROR' ,SQLERRM );
942: FND_MSG_PUB.ADD;
943:
944: FND_MSG_PUB.Count_And_Get(
945: p_encoded => FND_API.G_FALSE,
946: p_count => x_msg_count,
947: p_data => x_msg_data );
948:
949: END get_credit_rating_rec;