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

Line 171: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR )

167: IF FND_PROFILE.VALUE( 'HZ_API_ERR_ON_OBSOLETE_COLUMN' ) = 'Y' THEN
168:
169: IF ( p_create_update_flag = 'C' AND
170: p_credit_ratings_rec.suit_judge_ind IS NOT NULL AND
171: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR )
172: OR
173: ( p_create_update_flag = 'U' AND
174: ( p_credit_ratings_rec.suit_judge_ind is null OR
175: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR

Line 175: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR

171: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR )
172: OR
173: ( p_create_update_flag = 'U' AND
174: ( p_credit_ratings_rec.suit_judge_ind is null OR
175: p_credit_ratings_rec.suit_judge_ind <> FND_API.G_MISS_CHAR
176: ) )
177: THEN
178: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OBSOLETE_COLUMN' );
179: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'suit_judge_ind' );

Line 181: x_return_status := FND_API.G_RET_STS_ERROR;

177: THEN
178: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_OBSOLETE_COLUMN' );
179: FND_MESSAGE.SET_TOKEN( 'COLUMN', 'suit_judge_ind' );
180: FND_MSG_PUB.ADD;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: END IF;
183:
184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: RAISE FND_API.G_EXC_ERROR;

Line 184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

180: FND_MSG_PUB.ADD;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: END IF;
183:
184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187: END IF;
188:

Line 185: RAISE FND_API.G_EXC_ERROR;

181: x_return_status := FND_API.G_RET_STS_ERROR;
182: END IF;
183:
184: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
185: RAISE FND_API.G_EXC_ERROR;
186: END IF;
187: END IF;
188:
189: -- mandatory fields: party_id, content_source_type

Line 192: p_credit_ratings_rec.party_id = FND_API.G_MISS_NUM))

188:
189: -- mandatory fields: party_id, content_source_type
190: IF (p_create_update_flag = 'C' AND
191: (p_credit_ratings_rec.party_id IS NULL OR
192: p_credit_ratings_rec.party_id = FND_API.G_MISS_NUM))
193: OR
194: (p_create_update_flag = 'U' AND
195: p_credit_ratings_rec.party_id IS NULL) THEN
196:

Line 200: x_return_status := FND_API.G_RET_STS_ERROR;

196:
197: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
198: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
199: FND_MSG_PUB.ADD;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201:
202: END IF;
203:
204: -- Bug 2197181: removed validation for mix-n-match

Line 208: p_credit_ratings_rec.content_source_type = FND_API.G_MISS_CHAR))

204: -- Bug 2197181: removed validation for mix-n-match
205: /*
206: IF (p_create_update_flag = 'C' AND
207: (p_credit_ratings_rec.content_source_type IS NULL OR
208: p_credit_ratings_rec.content_source_type = FND_API.G_MISS_CHAR))
209: OR
210: (p_create_update_flag = 'U' AND
211: p_credit_ratings_rec.content_source_type IS NULL) THEN
212:

Line 216: x_return_status := FND_API.G_RET_STS_ERROR;

212:
213: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
214: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');
215: FND_MSG_PUB.ADD;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217:
218: END IF;
219: */
220: -- non updateable field

Line 275: IF (p_credit_ratings_rec.party_id <> FND_API.G_MISS_NUM) AND

271: db_actual_content_source
272: FROM hz_credit_ratings
273: where credit_rating_id = p_credit_ratings_rec.credit_rating_id;
274:
275: IF (p_credit_ratings_rec.party_id <> FND_API.G_MISS_NUM) AND
276: (p_credit_ratings_rec.party_id <> l_party_id) THEN
277: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
278: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
279: FND_MSG_PUB.ADD;

Line 280: x_return_status := FND_API.G_RET_STS_ERROR;

276: (p_credit_ratings_rec.party_id <> l_party_id) THEN
277: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
278: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
279: FND_MSG_PUB.ADD;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: end if;
282:
283: -- Bug 2197181: removed validation for mix-n-match
284: /*

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285: IF p_credit_ratings_rec.content_source_type <> l_content_source_type THEN
286: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
287: FND_MESSAGE.SET_TOKEN('COLUMN', 'content_source_type');
288: FND_MSG_PUB.ADD;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290: END IF;
291: */
292:
293: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 298: x_return_status := FND_API.G_RET_STS_ERROR;

294: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
295: FND_MESSAGE.SET_TOKEN('RECORD', 'credit rating');
296: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_credit_ratings_rec.credit_rating_id));
297: FND_MSG_PUB.ADD;
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: END;
300:
301: END IF;
302:

Line 306: p_credit_ratings_rec.party_id <> FND_API.G_MISS_NUM) THEN

302:
303: -- foreign key : party_id to hz_parties
304:
305: IF (p_credit_ratings_rec.party_id is NOT NULL AND
306: p_credit_ratings_rec.party_id <> FND_API.G_MISS_NUM) THEN
307:
308: SELECT count(*)
309: INTO l_count
310: FROM hz_parties

Line 319: x_return_status := FND_API.G_RET_STS_ERROR;

315: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
316: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
317: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
318: FND_MSG_PUB.ADD;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: END IF;
321:
322: END IF;
323:

Line 348: p_credit_ratings_rec.suit_ind <> fnd_api.g_miss_char

344:
345: -- suit_ind is lookup code in lookup type YES/NO
346: IF p_credit_ratings_rec.suit_ind IS NOT NULL
347: AND
348: p_credit_ratings_rec.suit_ind <> fnd_api.g_miss_char
349: AND
350: (p_create_update_flag = 'C'
351: OR
352: (p_create_update_flag = 'U'

Line 354: p_credit_ratings_rec.suit_ind <> NVL(l_suit_ind, fnd_api.g_miss_char)

350: (p_create_update_flag = 'C'
351: OR
352: (p_create_update_flag = 'U'
353: AND
354: p_credit_ratings_rec.suit_ind <> NVL(l_suit_ind, fnd_api.g_miss_char)
355: )
356: )
357: THEN
358:

Line 380: p_credit_ratings_rec.lien_ind <> fnd_api.g_miss_char

376:
377: -- lien_ind is lookup code in lookup type YES/NO
378: IF p_credit_ratings_rec.lien_ind IS NOT NULL
379: AND
380: p_credit_ratings_rec.lien_ind <> fnd_api.g_miss_char
381: AND
382: (p_create_update_flag = 'C'
383: OR
384: (p_create_update_flag = 'U'

Line 386: p_credit_ratings_rec.lien_ind <> NVL(l_lien_ind, fnd_api.g_miss_char)

382: (p_create_update_flag = 'C'
383: OR
384: (p_create_update_flag = 'U'
385: AND
386: p_credit_ratings_rec.lien_ind <> NVL(l_lien_ind, fnd_api.g_miss_char)
387: )
388: )
389: THEN
390:

Line 412: p_credit_ratings_rec.judgement_ind <> fnd_api.g_miss_char

408:
409: -- judgement_ind is lookup code in lookup type YES/NO
410: IF p_credit_ratings_rec.judgement_ind IS NOT NULL
411: AND
412: p_credit_ratings_rec.judgement_ind <> fnd_api.g_miss_char
413: AND
414: (p_create_update_flag = 'C'
415: OR
416: (p_create_update_flag = 'U'

Line 418: p_credit_ratings_rec.judgement_ind <> NVL(l_judgement_ind, fnd_api.g_miss_char)

414: (p_create_update_flag = 'C'
415: OR
416: (p_create_update_flag = 'U'
417: AND
418: p_credit_ratings_rec.judgement_ind <> NVL(l_judgement_ind, fnd_api.g_miss_char)
419: )
420: )
421: THEN
422:

Line 444: p_credit_ratings_rec.bankruptcy_ind <> fnd_api.g_miss_char

440:
441: -- bankruptcy_ind is lookup code in lookup type YES/NO
442: IF p_credit_ratings_rec.bankruptcy_ind IS NOT NULL
443: AND
444: p_credit_ratings_rec.bankruptcy_ind <> fnd_api.g_miss_char
445: AND
446: (p_create_update_flag = 'C'
447: OR
448: (p_create_update_flag = 'U'

Line 450: p_credit_ratings_rec.bankruptcy_ind <> NVL(l_bankruptcy_ind, fnd_api.g_miss_char)

446: (p_create_update_flag = 'C'
447: OR
448: (p_create_update_flag = 'U'
449: AND
450: p_credit_ratings_rec.bankruptcy_ind <> NVL(l_bankruptcy_ind, fnd_api.g_miss_char)
451: )
452: )
453: THEN
454:

Line 476: p_credit_ratings_rec.no_trade_ind <> fnd_api.g_miss_char

472:
473: -- no_trade_ind is lookup code in lookup type YES/NO
474: IF p_credit_ratings_rec.no_trade_ind IS NOT NULL
475: AND
476: p_credit_ratings_rec.no_trade_ind <> fnd_api.g_miss_char
477: AND
478: (p_create_update_flag = 'C'
479: OR
480: (p_create_update_flag = 'U'

Line 482: p_credit_ratings_rec.no_trade_ind <> NVL(l_no_trade_ind, fnd_api.g_miss_char)

478: (p_create_update_flag = 'C'
479: OR
480: (p_create_update_flag = 'U'
481: AND
482: p_credit_ratings_rec.no_trade_ind <> NVL(l_no_trade_ind, fnd_api.g_miss_char)
483: )
484: )
485: THEN
486:

Line 507: p_credit_ratings_rec.prnt_hq_bkcy_ind <> fnd_api.g_miss_char

503:
504: -- prnt_hq_bkcy_ind is lookup code in PRNT_HQ_IND
505: IF p_credit_ratings_rec.prnt_hq_bkcy_ind IS NOT NULL
506: AND
507: p_credit_ratings_rec.prnt_hq_bkcy_ind <> fnd_api.g_miss_char
508: AND
509: (p_create_update_flag = 'C'
510: OR
511: (p_create_update_flag = 'U'

Line 513: p_credit_ratings_rec.prnt_hq_bkcy_ind <> NVL(l_prnt_hq_bkcy_ind, fnd_api.g_miss_char)

509: (p_create_update_flag = 'C'
510: OR
511: (p_create_update_flag = 'U'
512: AND
513: p_credit_ratings_rec.prnt_hq_bkcy_ind <> NVL(l_prnt_hq_bkcy_ind, fnd_api.g_miss_char)
514: )
515: )
516: THEN
517:

Line 539: p_credit_ratings_rec.credit_score_override_code <> fnd_api.g_miss_char

535:
536: -- credit_score_override_code is lookup code in FAILURE_SCORE_OVERRIDE_CODE
537: IF p_credit_ratings_rec.credit_score_override_code IS NOT NULL
538: AND
539: p_credit_ratings_rec.credit_score_override_code <> fnd_api.g_miss_char
540: AND
541: (p_create_update_flag = 'C'
542: OR
543: (p_create_update_flag = 'U'

Line 545: p_credit_ratings_rec.credit_score_override_code <> NVL(l_credit_score_override_code, fnd_api.g_miss_char)

541: (p_create_update_flag = 'C'
542: OR
543: (p_create_update_flag = 'U'
544: AND
545: p_credit_ratings_rec.credit_score_override_code <> NVL(l_credit_score_override_code, fnd_api.g_miss_char)
546: )
547: )
548: THEN
549:

Line 570: p_credit_ratings_rec.debarment_ind <> fnd_api.g_miss_char

566:
567: -- debarment_ind is lookup code in lookup type YES/NO
568: IF p_credit_ratings_rec.debarment_ind IS NOT NULL
569: AND
570: p_credit_ratings_rec.debarment_ind <> fnd_api.g_miss_char
571: AND
572: (p_create_update_flag = 'C'
573: OR
574: (p_create_update_flag = 'U'

Line 576: p_credit_ratings_rec.debarment_ind <> NVL(l_debarment_ind, fnd_api.g_miss_char)

572: (p_create_update_flag = 'C'
573: OR
574: (p_create_update_flag = 'U'
575: AND
576: p_credit_ratings_rec.debarment_ind <> NVL(l_debarment_ind, fnd_api.g_miss_char)
577: )
578: )
579: THEN
580:

Line 602: p_credit_ratings_rec.credit_score_commentary <> fnd_api.g_miss_char

598:
599: -- credit_score_commentary is lookup code in lookup type CREDIT_SCORE_COMMENTARY
600: IF p_credit_ratings_rec.credit_score_commentary IS NOT NULL
601: AND
602: p_credit_ratings_rec.credit_score_commentary <> fnd_api.g_miss_char
603: AND
604: (p_create_update_flag = 'C'
605: OR
606: (p_create_update_flag = 'U'

Line 608: p_credit_ratings_rec.credit_score_commentary <> NVL(l_credit_score_commentary, fnd_api.g_miss_char)

604: (p_create_update_flag = 'C'
605: OR
606: (p_create_update_flag = 'U'
607: AND
608: p_credit_ratings_rec.credit_score_commentary <> NVL(l_credit_score_commentary, fnd_api.g_miss_char)
609: )
610: )
611: THEN
612:

Line 635: p_credit_ratings_rec.credit_score_commentary2 <> fnd_api.g_miss_char

631:
632: -- credit_score_commentary is lookup code in lookup type CREDIT_SCORE_COMMENTARY
633: IF p_credit_ratings_rec.credit_score_commentary2 IS NOT NULL
634: AND
635: p_credit_ratings_rec.credit_score_commentary2 <> fnd_api.g_miss_char
636: AND
637: (p_create_update_flag = 'C'
638: OR
639: (p_create_update_flag = 'U'

Line 641: p_credit_ratings_rec.credit_score_commentary2 <> NVL(l_credit_score_commentary2, fnd_api.g_miss_char)

637: (p_create_update_flag = 'C'
638: OR
639: (p_create_update_flag = 'U'
640: AND
641: p_credit_ratings_rec.credit_score_commentary2 <> NVL(l_credit_score_commentary2, fnd_api.g_miss_char)
642: )
643: )
644: THEN
645:

Line 667: p_credit_ratings_rec.credit_score_commentary3 <> fnd_api.g_miss_char

663:
664: -- credit_score_commentary3 is lookup code in lookup type CREDIT_SCORE_COMMENTARY
665: IF p_credit_ratings_rec.credit_score_commentary3 IS NOT NULL
666: AND
667: p_credit_ratings_rec.credit_score_commentary3 <> fnd_api.g_miss_char
668: AND
669: (p_create_update_flag = 'C'
670: OR
671: (p_create_update_flag = 'U'

Line 673: p_credit_ratings_rec.credit_score_commentary3 <> NVL(l_credit_score_commentary3, fnd_api.g_miss_char)

669: (p_create_update_flag = 'C'
670: OR
671: (p_create_update_flag = 'U'
672: AND
673: p_credit_ratings_rec.credit_score_commentary3 <> NVL(l_credit_score_commentary3, fnd_api.g_miss_char)
674: )
675: )
676: THEN
677:

Line 699: p_credit_ratings_rec.credit_score_commentary4 <> fnd_api.g_miss_char

695:
696: -- credit_score_commentary4 is lookup code in lookup type CREDIT_SCORE_COMMENTARY
697: IF p_credit_ratings_rec.credit_score_commentary4 IS NOT NULL
698: AND
699: p_credit_ratings_rec.credit_score_commentary4 <> fnd_api.g_miss_char
700: AND
701: (p_create_update_flag = 'C'
702: OR
703: (p_create_update_flag = 'U'

Line 705: p_credit_ratings_rec.credit_score_commentary4 <> NVL(l_credit_score_commentary4, fnd_api.g_miss_char)

701: (p_create_update_flag = 'C'
702: OR
703: (p_create_update_flag = 'U'
704: AND
705: p_credit_ratings_rec.credit_score_commentary4 <> NVL(l_credit_score_commentary4, fnd_api.g_miss_char)
706: )
707: )
708: THEN
709:

Line 731: p_credit_ratings_rec.credit_score_commentary5 <> fnd_api.g_miss_char

727:
728: -- credit_score_commentary5 is lookup code in lookup type CREDIT_SCORE_COMMENTARY
729: IF p_credit_ratings_rec.credit_score_commentary5 IS NOT NULL
730: AND
731: p_credit_ratings_rec.credit_score_commentary5 <> fnd_api.g_miss_char
732: AND
733: (p_create_update_flag = 'C'
734: OR
735: (p_create_update_flag = 'U'

Line 737: p_credit_ratings_rec.credit_score_commentary5 <> NVL(l_credit_score_commentary5, fnd_api.g_miss_char)

733: (p_create_update_flag = 'C'
734: OR
735: (p_create_update_flag = 'U'
736: AND
737: p_credit_ratings_rec.credit_score_commentary5 <> NVL(l_credit_score_commentary5, fnd_api.g_miss_char)
738: )
739: )
740: THEN
741:

Line 763: p_credit_ratings_rec.credit_score_commentary6 <> fnd_api.g_miss_char

759:
760: -- credit_score_commentary6 is lookup code in lookup type CREDIT_SCORE_COMMENTARY
761: IF p_credit_ratings_rec.credit_score_commentary6 IS NOT NULL
762: AND
763: p_credit_ratings_rec.credit_score_commentary6 <> fnd_api.g_miss_char
764: AND
765: (p_create_update_flag = 'C'
766: OR
767: (p_create_update_flag = 'U'

Line 769: p_credit_ratings_rec.credit_score_commentary6 <> NVL(l_credit_score_commentary6, fnd_api.g_miss_char)

765: (p_create_update_flag = 'C'
766: OR
767: (p_create_update_flag = 'U'
768: AND
769: p_credit_ratings_rec.credit_score_commentary6 <> NVL(l_credit_score_commentary6, fnd_api.g_miss_char)
770: )
771: )
772: THEN
773:

Line 795: p_credit_ratings_rec.credit_score_commentary7 <> fnd_api.g_miss_char

791:
792: -- credit_score_commentary7 is lookup code in lookup type CREDIT_SCORE_COMMENTARY
793: IF p_credit_ratings_rec.credit_score_commentary7 IS NOT NULL
794: AND
795: p_credit_ratings_rec.credit_score_commentary7 <> fnd_api.g_miss_char
796: AND
797: (p_create_update_flag = 'C'
798: OR
799: (p_create_update_flag = 'U'

Line 801: p_credit_ratings_rec.credit_score_commentary7 <> NVL(l_credit_score_commentary7, fnd_api.g_miss_char)

797: (p_create_update_flag = 'C'
798: OR
799: (p_create_update_flag = 'U'
800: AND
801: p_credit_ratings_rec.credit_score_commentary7 <> NVL(l_credit_score_commentary7, fnd_api.g_miss_char)
802: )
803: )
804: THEN
805:

Line 827: p_credit_ratings_rec.credit_score_commentary8 <> fnd_api.g_miss_char

823:
824: -- credit_score_commentary8 is lookup code in lookup type CREDIT_SCORE_COMMENTARY
825: IF p_credit_ratings_rec.credit_score_commentary8 IS NOT NULL
826: AND
827: p_credit_ratings_rec.credit_score_commentary8 <> fnd_api.g_miss_char
828: AND
829: (p_create_update_flag = 'C'
830: OR
831: (p_create_update_flag = 'U'

Line 833: p_credit_ratings_rec.credit_score_commentary8 <> NVL(l_credit_score_commentary8, fnd_api.g_miss_char)

829: (p_create_update_flag = 'C'
830: OR
831: (p_create_update_flag = 'U'
832: AND
833: p_credit_ratings_rec.credit_score_commentary8 <> NVL(l_credit_score_commentary8, fnd_api.g_miss_char)
834: )
835: )
836: THEN
837:

Line 859: p_credit_ratings_rec.credit_score_commentary9 <> fnd_api.g_miss_char

855:
856: -- credit_score_commentary9 is lookup code in lookup type CREDIT_SCORE_COMMENTARY
857: IF p_credit_ratings_rec.credit_score_commentary9 IS NOT NULL
858: AND
859: p_credit_ratings_rec.credit_score_commentary9 <> fnd_api.g_miss_char
860: AND
861: (p_create_update_flag = 'C'
862: OR
863: (p_create_update_flag = 'U'

Line 865: p_credit_ratings_rec.credit_score_commentary9 <> NVL(l_credit_score_commentary9, fnd_api.g_miss_char)

861: (p_create_update_flag = 'C'
862: OR
863: (p_create_update_flag = 'U'
864: AND
865: p_credit_ratings_rec.credit_score_commentary9 <> NVL(l_credit_score_commentary9, fnd_api.g_miss_char)
866: )
867: )
868: THEN
869:

Line 891: p_credit_ratings_rec.credit_score_commentary10 <> fnd_api.g_miss_char

887:
888: -- credit_score_commentary10 is lookup code in lookup type CREDIT_SCORE_COMMENTARY
889: IF p_credit_ratings_rec.credit_score_commentary10 IS NOT NULL
890: AND
891: p_credit_ratings_rec.credit_score_commentary10 <> fnd_api.g_miss_char
892: AND
893: (p_create_update_flag = 'C'
894: OR
895: (p_create_update_flag = 'U'

Line 897: p_credit_ratings_rec.credit_score_commentary10 <> NVL(l_credit_score_commentary10, fnd_api.g_miss_char)

893: (p_create_update_flag = 'C'
894: OR
895: (p_create_update_flag = 'U'
896: AND
897: p_credit_ratings_rec.credit_score_commentary10 <> NVL(l_credit_score_commentary10, fnd_api.g_miss_char)
898: )
899: )
900: THEN
901:

Line 923: p_credit_ratings_rec.failure_score_commentary <> fnd_api.g_miss_char

919:
920: -- failure_score_commentary is lookup code in lookup type FAILURE_SCORE_COMMENTARY
921: IF p_credit_ratings_rec.failure_score_commentary IS NOT NULL
922: AND
923: p_credit_ratings_rec.failure_score_commentary <> fnd_api.g_miss_char
924: AND
925: (p_create_update_flag = 'C'
926: OR
927: (p_create_update_flag = 'U'

Line 929: p_credit_ratings_rec.failure_score_commentary <> NVL(l_credit_score_commentary, fnd_api.g_miss_char)

925: (p_create_update_flag = 'C'
926: OR
927: (p_create_update_flag = 'U'
928: AND
929: p_credit_ratings_rec.failure_score_commentary <> NVL(l_credit_score_commentary, fnd_api.g_miss_char)
930: )
931: )
932: THEN
933: HZ_UTILITY_V2PUB.validate_lookup (

Line 954: p_credit_ratings_rec.failure_score_commentary2 <> fnd_api.g_miss_char

950:
951: -- failure_score_commentary2 is lookup code in lookup type FAILURE_SCORE_COMMENTARY
952: IF p_credit_ratings_rec.failure_score_commentary2 IS NOT NULL
953: AND
954: p_credit_ratings_rec.failure_score_commentary2 <> fnd_api.g_miss_char
955: AND
956: (p_create_update_flag = 'C'
957: OR
958: (p_create_update_flag = 'U'

Line 960: p_credit_ratings_rec.failure_score_commentary2 <> NVL(l_credit_score_commentary2, fnd_api.g_miss_char)

956: (p_create_update_flag = 'C'
957: OR
958: (p_create_update_flag = 'U'
959: AND
960: p_credit_ratings_rec.failure_score_commentary2 <> NVL(l_credit_score_commentary2, fnd_api.g_miss_char)
961: )
962: )
963: THEN
964:

Line 986: p_credit_ratings_rec.failure_score_commentary3 <> fnd_api.g_miss_char

982:
983: -- failure_score_commentary3 is lookup code in lookup type FAILURE_SCORE_COMMENTARY
984: IF p_credit_ratings_rec.failure_score_commentary3 IS NOT NULL
985: AND
986: p_credit_ratings_rec.failure_score_commentary3 <> fnd_api.g_miss_char
987: AND
988: (p_create_update_flag = 'C'
989: OR
990: (p_create_update_flag = 'U'

Line 992: p_credit_ratings_rec.failure_score_commentary3 <> NVL(l_credit_score_commentary3, fnd_api.g_miss_char)

988: (p_create_update_flag = 'C'
989: OR
990: (p_create_update_flag = 'U'
991: AND
992: p_credit_ratings_rec.failure_score_commentary3 <> NVL(l_credit_score_commentary3, fnd_api.g_miss_char)
993: )
994: )
995: THEN
996:

Line 1018: p_credit_ratings_rec.failure_score_commentary4 <> fnd_api.g_miss_char

1014:
1015: -- failure_score_commentary4 is lookup code in lookup type FAILURE_SCORE_COMMENTARY
1016: IF p_credit_ratings_rec.failure_score_commentary4 IS NOT NULL
1017: AND
1018: p_credit_ratings_rec.failure_score_commentary4 <> fnd_api.g_miss_char
1019: AND
1020: (p_create_update_flag = 'C'
1021: OR
1022: (p_create_update_flag = 'U'

Line 1024: p_credit_ratings_rec.failure_score_commentary4 <> NVL(l_credit_score_commentary4, fnd_api.g_miss_char)

1020: (p_create_update_flag = 'C'
1021: OR
1022: (p_create_update_flag = 'U'
1023: AND
1024: p_credit_ratings_rec.failure_score_commentary4 <> NVL(l_credit_score_commentary4, fnd_api.g_miss_char)
1025: )
1026: )
1027: THEN
1028:

Line 1050: p_credit_ratings_rec.failure_score_commentary5 <> fnd_api.g_miss_char

1046:
1047: -- failure_score_commentary5 is lookup code in lookup type FAILURE_SCORE_COMMENTARY
1048: IF p_credit_ratings_rec.failure_score_commentary5 IS NOT NULL
1049: AND
1050: p_credit_ratings_rec.failure_score_commentary5 <> fnd_api.g_miss_char
1051: AND
1052: (p_create_update_flag = 'C'
1053: OR
1054: (p_create_update_flag = 'U'

Line 1056: p_credit_ratings_rec.failure_score_commentary5 <> NVL(l_credit_score_commentary5, fnd_api.g_miss_char)

1052: (p_create_update_flag = 'C'
1053: OR
1054: (p_create_update_flag = 'U'
1055: AND
1056: p_credit_ratings_rec.failure_score_commentary5 <> NVL(l_credit_score_commentary5, fnd_api.g_miss_char)
1057: )
1058: )
1059: THEN
1060:

Line 1082: p_credit_ratings_rec.failure_score_commentary6 <> fnd_api.g_miss_char

1078:
1079: -- failure_score_commentary6 is lookup code in lookup type FAILURE_SCORE_COMMENTARY
1080: IF p_credit_ratings_rec.failure_score_commentary6 IS NOT NULL
1081: AND
1082: p_credit_ratings_rec.failure_score_commentary6 <> fnd_api.g_miss_char
1083: AND
1084: (p_create_update_flag = 'C'
1085: OR
1086: (p_create_update_flag = 'U'

Line 1088: p_credit_ratings_rec.failure_score_commentary6 <> NVL(l_credit_score_commentary6, fnd_api.g_miss_char)

1084: (p_create_update_flag = 'C'
1085: OR
1086: (p_create_update_flag = 'U'
1087: AND
1088: p_credit_ratings_rec.failure_score_commentary6 <> NVL(l_credit_score_commentary6, fnd_api.g_miss_char)
1089: )
1090: )
1091: THEN
1092:

Line 1114: p_credit_ratings_rec.failure_score_commentary7 <> fnd_api.g_miss_char

1110:
1111: -- failure_score_commentary7 is lookup code in lookup type FAILURE_SCORE_COMMENTARY
1112: IF p_credit_ratings_rec.failure_score_commentary7 IS NOT NULL
1113: AND
1114: p_credit_ratings_rec.failure_score_commentary7 <> fnd_api.g_miss_char
1115: AND
1116: (p_create_update_flag = 'C'
1117: OR
1118: (p_create_update_flag = 'U'

Line 1120: p_credit_ratings_rec.failure_score_commentary7 <> NVL(l_credit_score_commentary7, fnd_api.g_miss_char)

1116: (p_create_update_flag = 'C'
1117: OR
1118: (p_create_update_flag = 'U'
1119: AND
1120: p_credit_ratings_rec.failure_score_commentary7 <> NVL(l_credit_score_commentary7, fnd_api.g_miss_char)
1121: )
1122: )
1123: THEN
1124:

Line 1146: p_credit_ratings_rec.failure_score_commentary8 <> fnd_api.g_miss_char

1142:
1143: -- failure_score_commentary8 is lookup code in lookup type FAILURE_SCORE_COMMENTARY
1144: IF p_credit_ratings_rec.failure_score_commentary8 IS NOT NULL
1145: AND
1146: p_credit_ratings_rec.failure_score_commentary8 <> fnd_api.g_miss_char
1147: AND
1148: (p_create_update_flag = 'C'
1149: OR
1150: (p_create_update_flag = 'U'

Line 1152: p_credit_ratings_rec.failure_score_commentary8 <> NVL(l_credit_score_commentary8, fnd_api.g_miss_char)

1148: (p_create_update_flag = 'C'
1149: OR
1150: (p_create_update_flag = 'U'
1151: AND
1152: p_credit_ratings_rec.failure_score_commentary8 <> NVL(l_credit_score_commentary8, fnd_api.g_miss_char)
1153: )
1154: )
1155: THEN
1156:

Line 1178: p_credit_ratings_rec.failure_score_commentary9 <> fnd_api.g_miss_char

1174:
1175: -- failure_score_commentary9 is lookup code in lookup type FAILURE_SCORE_COMMENTARY
1176: IF p_credit_ratings_rec.failure_score_commentary9 IS NOT NULL
1177: AND
1178: p_credit_ratings_rec.failure_score_commentary9 <> fnd_api.g_miss_char
1179: AND
1180: (p_create_update_flag = 'C'
1181: OR
1182: (p_create_update_flag = 'U'

Line 1184: p_credit_ratings_rec.failure_score_commentary9 <> NVL(l_credit_score_commentary9, fnd_api.g_miss_char)

1180: (p_create_update_flag = 'C'
1181: OR
1182: (p_create_update_flag = 'U'
1183: AND
1184: p_credit_ratings_rec.failure_score_commentary9 <> NVL(l_credit_score_commentary9, fnd_api.g_miss_char)
1185: )
1186: )
1187: THEN
1188:

Line 1210: p_credit_ratings_rec.failure_score_commentary10 <> fnd_api.g_miss_char

1206:
1207: -- failure_score_commentary10 is lookup code in lookup type FAILURE_SCORE_COMMENTARY
1208: IF p_credit_ratings_rec.failure_score_commentary10 IS NOT NULL
1209: AND
1210: p_credit_ratings_rec.failure_score_commentary10 <> fnd_api.g_miss_char
1211: AND
1212: (p_create_update_flag = 'C'
1213: OR
1214: (p_create_update_flag = 'U'

Line 1216: p_credit_ratings_rec.failure_score_commentary10 <> NVL(l_credit_score_commentary10, fnd_api.g_miss_char)

1212: (p_create_update_flag = 'C'
1213: OR
1214: (p_create_update_flag = 'U'
1215: AND
1216: p_credit_ratings_rec.failure_score_commentary10 <> NVL(l_credit_score_commentary10, fnd_api.g_miss_char)
1217: )
1218: )
1219: THEN
1220:

Line 1244: p_credit_ratings_rec.maximum_credit_currency_code <> fnd_api.g_miss_char

1240: -- maximum_credit_currency_code is foreign key of fnd_currencies.currency_code
1241:
1242: IF p_credit_ratings_rec.maximum_credit_currency_code IS NOT NULL
1243: AND
1244: p_credit_ratings_rec.maximum_credit_currency_code <> fnd_api.g_miss_char
1245: THEN
1246: BEGIN
1247: SELECT 'Y'
1248: INTO l_dummy

Line 1260: x_return_status := fnd_api.g_ret_sts_error;

1256: fnd_message.set_token('FK', 'maximum_credit_currency_code');
1257: fnd_message.set_token('COLUMN', 'currency_code');
1258: fnd_message.set_token('TABLE', 'fnd_currencies');
1259: fnd_msg_pub.add;
1260: x_return_status := fnd_api.g_ret_sts_error;
1261: END;
1262:
1263: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
1264: hz_utility_v2pub.debug(p_message=>'maximum_credit_currency_code is foreign key of fnd_currencies.currency_code. ' ||

Line 1330: p_financial_profile_rec.party_id = FND_API.G_MISS_NUM))

1326: BEGIN
1327: -- mandatory fields: party_id
1328: IF (p_create_update_flag = 'C' AND
1329: (p_financial_profile_rec.party_id IS NULL OR
1330: p_financial_profile_rec.party_id = FND_API.G_MISS_NUM))
1331: OR
1332: (p_create_update_flag = 'U' AND
1333: p_financial_profile_rec.party_id IS NULL) THEN
1334:

Line 1338: x_return_status := FND_API.G_RET_STS_ERROR;

1334:
1335: FND_MESSAGE.SET_NAME('AR', 'HZ_API_MISSING_COLUMN');
1336: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1337: FND_MSG_PUB.ADD;
1338: x_return_status := FND_API.G_RET_STS_ERROR;
1339:
1340: END IF;
1341:
1342: -- non updateable field

Line 1345: p_financial_profile_rec.party_id <> FND_API.G_MISS_NUM) THEN

1341:
1342: -- non updateable field
1343:
1344: IF (p_create_update_flag = 'U' AND
1345: p_financial_profile_rec.party_id <> FND_API.G_MISS_NUM) THEN
1346:
1347: SELECT party_id
1348: INTO l_party_id
1349: FROM hz_financial_profile

Line 1357: x_return_status := FND_API.G_RET_STS_ERROR;

1353: if l_party_id <> p_financial_profile_rec.party_id then
1354: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NONUPDATEABLE_COLUMN');
1355: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1356: FND_MSG_PUB.ADD;
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: end if;
1359:
1360: END IF;
1361:

Line 1365: p_financial_profile_rec.party_id <> FND_API.G_MISS_NUM) THEN

1361:
1362: -- foreign key : party_id to hz_parties
1363:
1364: IF (p_financial_profile_rec.party_id is NOT NULL AND
1365: p_financial_profile_rec.party_id <> FND_API.G_MISS_NUM) THEN
1366:
1367: -- Bug 4461511.
1368: BEGIN
1369: SELECT party_type

Line 1382: x_return_status := FND_API.G_RET_STS_ERROR;

1378: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_PARTY_TYPE');
1379: FND_MESSAGE.SET_TOKEN('PARTY_ID', to_char(p_financial_profile_rec.party_id));
1380: FND_MESSAGE.SET_TOKEN('TYPE', 'ORGANIZATION or PERSON');
1381: FND_MSG_PUB.ADD;
1382: x_return_status := FND_API.G_RET_STS_ERROR;
1383: END IF;
1384:
1385: EXCEPTION
1386: WHEN NO_DATA_FOUND THEN

Line 1392: x_return_status := FND_API.G_RET_STS_ERROR;

1388: FND_MESSAGE.SET_TOKEN('FK', 'party_id');
1389: FND_MESSAGE.SET_TOKEN('COLUMN', 'party_id');
1390: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_parties');
1391: FND_MSG_PUB.ADD;
1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393: END;
1394: END IF;
1395:
1396: