DBA Data[Home] [Help]

APPS.IGS_FI_CRDAPI_UTIL dependencies on FND_MSG_PUB

Line 364: fnd_msg_pub.ADD;

360:
361: -- Currently p_n_validation_level can only take values 0 and 100
362: IF p_n_validation_level NOT IN (FND_API.G_VALID_LEVEL_NONE, FND_API.G_VALID_LEVEL_FULL) THEN
363: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
364: fnd_msg_pub.ADD;
365: p_b_return_status := FALSE;
366: RETURN;
367: END IF;
368:

Line 382: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

378:
379:
380: -- Check the status with which the current transaction is being created
381: IF NOT igs_fi_crdapi_util.validate_credit_status ( p_v_crd_status => p_credit_rec.p_credit_status ) THEN
382: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
383: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_INVALID_CR_STAT');
384: fnd_message.set_token ( 'CR_STAT', p_credit_rec.p_credit_status );
385: fnd_msg_pub.ADD;
386: p_b_return_status := FALSE;

Line 385: fnd_msg_pub.ADD;

381: IF NOT igs_fi_crdapi_util.validate_credit_status ( p_v_crd_status => p_credit_rec.p_credit_status ) THEN
382: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
383: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_INVALID_CR_STAT');
384: fnd_message.set_token ( 'CR_STAT', p_credit_rec.p_credit_status );
385: fnd_msg_pub.ADD;
386: p_b_return_status := FALSE;
387: RETURN;
388: END IF;
389: END IF;

Line 394: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

390:
391: -- Validate lookup code passed for Credit Source
392: IF p_credit_rec.p_credit_source IS NOT NULL THEN
393: IF NOT igs_fi_crdapi_util.validate_igf_lkp ( p_v_lookup_type => 'IGF_AW_FED_FUND', p_v_lookup_code => p_credit_rec.p_credit_source) THEN
394: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
395: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_CRD_SRC_NULL');
396: fnd_message.set_token ( 'CR_SOURCE', p_credit_rec.p_credit_source );
397: fnd_msg_pub.ADD;
398: p_b_return_status := FALSE;

Line 397: fnd_msg_pub.ADD;

393: IF NOT igs_fi_crdapi_util.validate_igf_lkp ( p_v_lookup_type => 'IGF_AW_FED_FUND', p_v_lookup_code => p_credit_rec.p_credit_source) THEN
394: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
395: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_CRD_SRC_NULL');
396: fnd_message.set_token ( 'CR_SOURCE', p_credit_rec.p_credit_source );
397: fnd_msg_pub.ADD;
398: p_b_return_status := FALSE;
399: RETURN;
400: END IF;
401: END IF;

Line 410: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

406: p_v_credit_class => l_v_credit_class,
407: p_b_return_stat => l_b_return_status);
408: IF (l_b_return_status = FALSE)
409: OR (igs_fi_crdapi_util.validate_igs_lkp ( 'IGS_FI_CREDIT_CLASS', l_v_credit_class ) = FALSE) THEN
410: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
411: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_CR_TYPE_INVALID');
412: fnd_message.set_token ( 'CR_TYPE', p_credit_rec.p_credit_type_id );
413: fnd_msg_pub.ADD;
414: p_b_return_status := FALSE;

Line 413: fnd_msg_pub.ADD;

409: OR (igs_fi_crdapi_util.validate_igs_lkp ( 'IGS_FI_CREDIT_CLASS', l_v_credit_class ) = FALSE) THEN
410: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
411: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_CR_TYPE_INVALID');
412: fnd_message.set_token ( 'CR_TYPE', p_credit_rec.p_credit_type_id );
413: fnd_msg_pub.ADD;
414: p_b_return_status := FALSE;
415: RETURN;
416: END IF;
417: END IF;

Line 421: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

417: END IF;
418: --- Check if credit_class holds a value of WAIVER
419: -- 3392095
420: IF l_v_credit_class = 'WAIVER' THEN
421: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
422: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_CR_TYPE_INVALID');
423: fnd_message.set_token ( 'CR_TYPE', p_credit_rec.p_credit_type_id );
424: fnd_msg_pub.ADD;
425: p_b_return_status := FALSE;

Line 424: fnd_msg_pub.ADD;

420: IF l_v_credit_class = 'WAIVER' THEN
421: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
422: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_CR_TYPE_INVALID');
423: fnd_message.set_token ( 'CR_TYPE', p_credit_rec.p_credit_type_id );
424: fnd_msg_pub.ADD;
425: p_b_return_status := FALSE;
426: RETURN;
427: END IF;
428: END IF;

Line 434: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

430:
431: -- Check if the Party ID, Credit Class combination is valid.
432: IF NOT igs_fi_crdapi_util.validate_party_id ( p_n_party_id => p_credit_rec.p_party_id,
433: p_v_credit_class => l_v_credit_class) THEN
434: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
435: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_PARTY_INVALID');
436: fnd_message.set_token ( 'PARTY_ID', p_credit_rec.p_party_id);
437: fnd_msg_pub.ADD;
438: p_b_return_status := FALSE;

Line 437: fnd_msg_pub.ADD;

433: p_v_credit_class => l_v_credit_class) THEN
434: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
435: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_PARTY_INVALID');
436: fnd_message.set_token ( 'PARTY_ID', p_credit_rec.p_party_id);
437: fnd_msg_pub.ADD;
438: p_b_return_status := FALSE;
439: RETURN;
440: END IF;
441: END IF;

Line 448: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

444: IF p_credit_rec.p_awd_yr_cal_type IS NULL
445: OR p_credit_rec.p_awd_yr_ci_sequence_number IS NULL
446: OR p_credit_rec.p_fee_cal_type IS NULL
447: OR p_credit_rec.p_fee_ci_sequence_number IS NULL THEN
448: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
449: fnd_message.set_name ( 'IGS', 'IGS_FI_FPAY_MAND');
450: fnd_msg_pub.ADD;
451: p_b_return_status := FALSE;
452: RETURN;

Line 450: fnd_msg_pub.ADD;

446: OR p_credit_rec.p_fee_cal_type IS NULL
447: OR p_credit_rec.p_fee_ci_sequence_number IS NULL THEN
448: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
449: fnd_message.set_name ( 'IGS', 'IGS_FI_FPAY_MAND');
450: fnd_msg_pub.ADD;
451: p_b_return_status := FALSE;
452: RETURN;
453: END IF;
454: END IF;

Line 461: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

457: -- Check if the Credit Instrument is valid
458: IF NOT igs_fi_crdapi_util.validate_igs_lkp ( p_v_lookup_type => 'IGS_FI_CREDIT_INSTRUMENT',
459: p_v_lookup_code => p_credit_rec.p_credit_instrument) THEN
460:
461: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
462: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_CRD_INSTR_NULL');
463: fnd_message.set_token ( 'CR_INSTR', p_credit_rec.p_credit_instrument);
464: fnd_msg_pub.ADD;
465: p_b_return_status := FALSE;

Line 464: fnd_msg_pub.ADD;

460:
461: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
462: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_CRD_INSTR_NULL');
463: fnd_message.set_token ( 'CR_INSTR', p_credit_rec.p_credit_instrument);
464: fnd_msg_pub.ADD;
465: p_b_return_status := FALSE;
466: RETURN;
467: END IF;
468:

Line 473: fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

469: ELSE
470: -- Check if the Credit Instrument is valid and whether instrument is of WAIVER Type
471: -- 3392095
472: IF p_credit_rec.p_credit_instrument = 'WAIVER' AND
473: fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
474:
475: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_CRD_INSTR_NULL');
476: fnd_message.set_token ( 'CR_INSTR', p_credit_rec.p_credit_instrument);
477: fnd_msg_pub.ADD;

Line 477: fnd_msg_pub.ADD;

473: fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
474:
475: fnd_message.set_name ( 'IGS', 'IGS_FI_CAPI_CRD_INSTR_NULL');
476: fnd_message.set_token ( 'CR_INSTR', p_credit_rec.p_credit_instrument);
477: fnd_msg_pub.ADD;
478: p_b_return_status := FALSE;
479: RETURN;
480:
481: END IF;

Line 491: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

487: igs_fi_crdapi_util.validate_dep_crtype( p_credit_rec.p_credit_type_id,
488: l_n_pay_cr_type_id,
489: l_b_return_status);
490: IF NOT l_b_return_status THEN
491: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
492: fnd_message.set_name('IGS','IGS_FI_PCT_DCT_INVALID');
493: fnd_message.set_token('PAY_CR_TYPE', l_n_pay_cr_type_id);
494: fnd_message.set_token('DEP_CR_TYPE', p_credit_rec.p_credit_type_id);
495: fnd_msg_pub.ADD;

Line 495: fnd_msg_pub.ADD;

491: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
492: fnd_message.set_name('IGS','IGS_FI_PCT_DCT_INVALID');
493: fnd_message.set_token('PAY_CR_TYPE', l_n_pay_cr_type_id);
494: fnd_message.set_token('DEP_CR_TYPE', p_credit_rec.p_credit_type_id);
495: fnd_msg_pub.ADD;
496: p_b_return_status := FALSE;
497: END IF;
498: END IF;
499: END IF;

Line 503: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

499: END IF;
500:
501: -- Only for a Credit Instrument of 'Check', a value can be provided to the Check Number parameter.
502: IF p_credit_rec.p_check_number IS NOT NULL AND p_credit_rec.p_credit_instrument <> 'CHECK' THEN
503: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
504: fnd_message.set_name ( 'IGS', 'IGS_FI_INVALID_CHECK_NUMBER');
505: fnd_msg_pub.ADD;
506: p_b_return_status := FALSE;
507: RETURN;

Line 505: fnd_msg_pub.ADD;

501: -- Only for a Credit Instrument of 'Check', a value can be provided to the Check Number parameter.
502: IF p_credit_rec.p_check_number IS NOT NULL AND p_credit_rec.p_credit_instrument <> 'CHECK' THEN
503: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
504: fnd_message.set_name ( 'IGS', 'IGS_FI_INVALID_CHECK_NUMBER');
505: fnd_msg_pub.ADD;
506: p_b_return_status := FALSE;
507: RETURN;
508: END IF;
509: END IF;

Line 517: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

513: p_v_credit_class => l_v_credit_class,
514: p_b_return_status=> l_b_return_status,
515: p_v_message_name => l_v_message_name );
516: IF l_b_return_status = FALSE THEN
517: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
518: fnd_message.set_name ( 'IGS', l_v_message_name);
519: IF l_v_message_name = 'IGS_FI_INVALID_GL_DATE' THEN
520: fnd_message.set_token ('GL_DATE', p_credit_rec.p_gl_date );
521: END IF;

Line 522: fnd_msg_pub.ADD;

518: fnd_message.set_name ( 'IGS', l_v_message_name);
519: IF l_v_message_name = 'IGS_FI_INVALID_GL_DATE' THEN
520: fnd_message.set_token ('GL_DATE', p_credit_rec.p_gl_date );
521: END IF;
522: fnd_msg_pub.ADD;
523: p_b_return_status := FALSE;
524: RETURN;
525: END IF;
526: END IF;

Line 531: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

527:
528: -- User is not allowed to create a transaction with Credit Class as Payment/Enrollment Deposit/Other Deposit/
529: -- Installment Payments with Credit Instrument as 'DEPOSIT'.
530: IF l_v_credit_class IN ('PMT','ENRDEPOSIT','OTHDEPOSIT','INSTALLMENT_PAYMENTS') AND p_credit_rec.p_credit_instrument = 'DEPOSIT' THEN
531: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
532: fnd_message.set_name('IGS','IGS_FI_CAPI_CRD_INSTR_NULL');
533: fnd_message.set_token('CR_INSTR', p_credit_rec.p_credit_instrument);
534: fnd_msg_pub.ADD;
535: p_b_return_status := FALSE;

Line 534: fnd_msg_pub.ADD;

530: IF l_v_credit_class IN ('PMT','ENRDEPOSIT','OTHDEPOSIT','INSTALLMENT_PAYMENTS') AND p_credit_rec.p_credit_instrument = 'DEPOSIT' THEN
531: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
532: fnd_message.set_name('IGS','IGS_FI_CAPI_CRD_INSTR_NULL');
533: fnd_message.set_token('CR_INSTR', p_credit_rec.p_credit_instrument);
534: fnd_msg_pub.ADD;
535: p_b_return_status := FALSE;
536: RETURN;
537: END IF;
538: END IF;

Line 548: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

544: p_v_credit_instrument=> p_credit_rec.p_credit_instrument,
545: p_b_return_status => l_b_return_status,
546: p_v_message_name => l_v_message_name );
547: IF l_b_return_status = FALSE THEN
548: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
549: fnd_message.set_name('IGS', l_v_message_name);
550: IF l_v_message_name = 'IGS_FI_SOURCE_TRAN_TYP_INVALID' THEN
551: fnd_message.set_token('VALUE', p_credit_rec.p_source_tran_type);
552: END IF;

Line 553: fnd_msg_pub.ADD;

549: fnd_message.set_name('IGS', l_v_message_name);
550: IF l_v_message_name = 'IGS_FI_SOURCE_TRAN_TYP_INVALID' THEN
551: fnd_message.set_token('VALUE', p_credit_rec.p_source_tran_type);
552: END IF;
553: fnd_msg_pub.ADD;
554: p_b_return_status := FALSE;
555: RETURN;
556: END IF;
557: END IF;

Line 560: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

556: END IF;
557: END IF;
558: ELSIF l_v_credit_class = 'ENRDEPOSIT' THEN
559: -- Source Transaction Type is mandatory for ENRDEPOSIT Credit Class
560: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
561: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
562: fnd_msg_pub.ADD;
563: p_b_return_status := FALSE;
564: RETURN;

Line 562: fnd_msg_pub.ADD;

558: ELSIF l_v_credit_class = 'ENRDEPOSIT' THEN
559: -- Source Transaction Type is mandatory for ENRDEPOSIT Credit Class
560: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
561: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
562: fnd_msg_pub.ADD;
563: p_b_return_status := FALSE;
564: RETURN;
565: END IF;
566: END IF;

Line 572: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

568: -- Validate Source Transaction Reference Number
569: IF l_v_credit_class = 'ENRDEPOSIT' AND p_credit_rec.p_credit_instrument <> 'DEPOSIT' THEN
570: IF NOT igs_fi_crdapi_util.validate_source_tran_ref_num(p_n_party_id => p_credit_rec.p_party_id,
571: p_n_source_tran_ref_num => p_credit_rec.p_source_tran_ref_number) THEN
572: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
573: fnd_message.set_name('IGS', 'IGS_FI_SOURCE_TRAN_REF_INVALID');
574: fnd_message.set_token('VALUE', p_credit_rec.p_source_tran_ref_number);
575: fnd_msg_pub.ADD;
576: p_b_return_status := FALSE;

Line 575: fnd_msg_pub.ADD;

571: p_n_source_tran_ref_num => p_credit_rec.p_source_tran_ref_number) THEN
572: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
573: fnd_message.set_name('IGS', 'IGS_FI_SOURCE_TRAN_REF_INVALID');
574: fnd_message.set_token('VALUE', p_credit_rec.p_source_tran_ref_number);
575: fnd_msg_pub.ADD;
576: p_b_return_status := FALSE;
577: RETURN;
578: END IF;
579: END IF;

Line 587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

583: IF p_credit_rec.p_awd_yr_cal_type IS NOT NULL AND p_credit_rec.p_awd_yr_ci_sequence_number IS NOT NULL THEN
584: IF NOT igs_fi_crdapi_util.validate_cal_inst ( p_v_cal_type => p_credit_rec.p_awd_yr_cal_type,
585: p_n_ci_sequence_number => p_credit_rec.p_awd_yr_ci_sequence_number,
586: p_v_s_cal_cat => 'AWARD') THEN
587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
588: fnd_message.set_name('IGS', 'IGS_FI_INV_AWD_YR');
589: fnd_msg_pub.ADD;
590: p_b_return_status := FALSE;
591: RETURN;

Line 589: fnd_msg_pub.ADD;

585: p_n_ci_sequence_number => p_credit_rec.p_awd_yr_ci_sequence_number,
586: p_v_s_cal_cat => 'AWARD') THEN
587: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
588: fnd_message.set_name('IGS', 'IGS_FI_INV_AWD_YR');
589: fnd_msg_pub.ADD;
590: p_b_return_status := FALSE;
591: RETURN;
592: END IF;
593: END IF;

Line 603: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

599: p_v_message_name => l_v_message_name
600: );
601:
602: IF l_v_message_name IS NOT NULL THEN
603: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
604: fnd_message.set_name('IGS',l_v_message_name);
605: fnd_msg_pub.ADD;
606: p_b_return_status := FALSE;
607: RETURN;

Line 605: fnd_msg_pub.ADD;

601:
602: IF l_v_message_name IS NOT NULL THEN
603: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
604: fnd_message.set_name('IGS',l_v_message_name);
605: fnd_msg_pub.ADD;
606: p_b_return_status := FALSE;
607: RETURN;
608: END IF;
609: END IF;

Line 617: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

613: IF p_credit_rec.p_fee_cal_type IS NOT NULL AND p_credit_rec.p_fee_ci_sequence_number IS NOT NULL THEN
614: IF NOT igs_fi_crdapi_util.validate_cal_inst ( p_v_cal_type => p_credit_rec.p_fee_cal_type,
615: p_n_ci_sequence_number => p_credit_rec.p_fee_ci_sequence_number,
616: p_v_s_cal_cat => 'FEE') THEN
617: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
618: fnd_message.set_name('IGS', 'IGS_FI_FCI_NOTFOUND');
619: fnd_msg_pub.ADD;
620: p_b_return_status := FALSE;
621: RETURN;

Line 619: fnd_msg_pub.ADD;

615: p_n_ci_sequence_number => p_credit_rec.p_fee_ci_sequence_number,
616: p_v_s_cal_cat => 'FEE') THEN
617: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
618: fnd_message.set_name('IGS', 'IGS_FI_FCI_NOTFOUND');
619: fnd_msg_pub.ADD;
620: p_b_return_status := FALSE;
621: RETURN;
622: END IF;
623: END IF;

Line 635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

631: p_n_ld_ci_sequence_number => l_v_ld_ci_seq_num,
632: p_v_message_name => l_v_message_name,
633: p_b_return_stat => l_b_return_status ) ;
634: IF l_b_return_status = FALSE THEN
635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
636: fnd_message.set_name('IGS', l_v_message_name);
637: fnd_msg_pub.ADD;
638: p_b_return_status := FALSE;
639: RETURN;

Line 637: fnd_msg_pub.ADD;

633: p_b_return_stat => l_b_return_status ) ;
634: IF l_b_return_status = FALSE THEN
635: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
636: fnd_message.set_name('IGS', l_v_message_name);
637: fnd_msg_pub.ADD;
638: p_b_return_status := FALSE;
639: RETURN;
640: END IF;
641: END IF;

Line 646: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

642: END IF;
643:
644: -- Validate the currency code
645: IF p_credit_rec.p_currency_cd IS NULL THEN
646: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
647: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');
648: fnd_msg_pub.ADD;
649: p_b_return_status := FALSE;
650: RETURN;

Line 648: fnd_msg_pub.ADD;

644: -- Validate the currency code
645: IF p_credit_rec.p_currency_cd IS NULL THEN
646: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
647: fnd_message.set_name('IGS', 'IGS_GE_INSUFFICIENT_PARAMETER');
648: fnd_msg_pub.ADD;
649: p_b_return_status := FALSE;
650: RETURN;
651: END IF;
652: ELSIF NOT igs_fi_crdapi_util.validate_curr ( p_v_currency_cd => p_credit_rec.p_currency_cd) THEN

Line 653: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

649: p_b_return_status := FALSE;
650: RETURN;
651: END IF;
652: ELSIF NOT igs_fi_crdapi_util.validate_curr ( p_v_currency_cd => p_credit_rec.p_currency_cd) THEN
653: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
654: fnd_message.set_name('IGS', 'IGS_FI_INVALID_CUR');
655: fnd_message.set_token('CUR_CD', p_credit_rec.p_currency_cd);
656: fnd_msg_pub.ADD;
657: p_b_return_status := FALSE;

Line 656: fnd_msg_pub.ADD;

652: ELSIF NOT igs_fi_crdapi_util.validate_curr ( p_v_currency_cd => p_credit_rec.p_currency_cd) THEN
653: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
654: fnd_message.set_name('IGS', 'IGS_FI_INVALID_CUR');
655: fnd_message.set_token('CUR_CD', p_credit_rec.p_currency_cd);
656: fnd_msg_pub.ADD;
657: p_b_return_status := FALSE;
658: RETURN;
659: END IF;
660: END IF;

Line 667: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

663: igs_fi_crdapi_util.validate_amount ( p_n_amount => p_credit_rec.p_amount,
664: p_b_return_status => l_b_return_status,
665: p_v_message_name => l_v_message_name );
666: IF l_b_return_status = FALSE THEN
667: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
668: fnd_message.set_name('IGS', l_v_message_name);
669: IF l_v_message_name = 'IGS_FI_CRD_AMT_NEGATIVE' THEN
670: fnd_message.set_token ( 'CR_AMT', p_credit_rec.p_amount );
671: END IF;

Line 672: fnd_msg_pub.ADD;

668: fnd_message.set_name('IGS', l_v_message_name);
669: IF l_v_message_name = 'IGS_FI_CRD_AMT_NEGATIVE' THEN
670: fnd_message.set_token ( 'CR_AMT', p_credit_rec.p_amount );
671: END IF;
672: fnd_msg_pub.ADD;
673: p_b_return_status := FALSE;
674: RETURN;
675: END IF;
676: END IF;

Line 689: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

685: p_b_status => l_b_return_status,
686: p_v_message_name => l_v_message_name
687: );
688: IF NOT l_b_return_status THEN
689: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
690: fnd_message.set_name('IGS',l_v_message_name);
691: fnd_msg_pub.ADD;
692: p_b_return_status := FALSE;
693: RETURN;

Line 691: fnd_msg_pub.ADD;

687: );
688: IF NOT l_b_return_status THEN
689: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
690: fnd_message.set_name('IGS',l_v_message_name);
691: fnd_msg_pub.ADD;
692: p_b_return_status := FALSE;
693: RETURN;
694: END IF;
695: END IF;

Line 702: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

698: -- Validate Credit Card Code, if passed
699: IF p_credit_rec.p_credit_card_code IS NOT NULL THEN
700: IF NOT igs_fi_crdapi_util.validate_igs_lkp ( p_v_lookup_type => 'IGS_CREDIT_CARDS',
701: p_v_lookup_code => p_credit_rec.p_credit_card_code) THEN
702: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
703: fnd_message.set_name('IGS', 'IGS_FI_CRD_CARD_INVALID');
704: fnd_message.set_token('CRD_CARD', p_credit_rec.p_credit_card_code);
705: fnd_msg_pub.ADD;
706: p_b_return_status := FALSE;

Line 705: fnd_msg_pub.ADD;

701: p_v_lookup_code => p_credit_rec.p_credit_card_code) THEN
702: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
703: fnd_message.set_name('IGS', 'IGS_FI_CRD_CARD_INVALID');
704: fnd_message.set_token('CRD_CARD', p_credit_rec.p_credit_card_code);
705: fnd_msg_pub.ADD;
706: p_b_return_status := FALSE;
707: RETURN;
708: END IF;
709: END IF;

Line 715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

711:
712: -- Validate Credit Card Expiration date, if passed
713: IF p_credit_rec.p_credit_card_expiration_date IS NOT NULL
714: AND TRUNC(p_credit_rec.p_credit_card_expiration_date) < TRUNC(SYSDATE) THEN
715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
716: fnd_message.set_name('IGS', 'IGS_FI_CRD_EXPDT_INVALID');
717: fnd_message.set_token('EXP_DATE', p_credit_rec.p_credit_card_expiration_date);
718: fnd_msg_pub.ADD;
719: p_b_return_status := FALSE;

Line 718: fnd_msg_pub.ADD;

714: AND TRUNC(p_credit_rec.p_credit_card_expiration_date) < TRUNC(SYSDATE) THEN
715: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
716: fnd_message.set_name('IGS', 'IGS_FI_CRD_EXPDT_INVALID');
717: fnd_message.set_token('EXP_DATE', p_credit_rec.p_credit_card_expiration_date);
718: fnd_msg_pub.ADD;
719: p_b_return_status := FALSE;
720: RETURN;
721: END IF;
722: END IF;

Line 728: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

724:
725: -- Validate the Invoice Id, if passed
726: IF p_credit_rec.p_invoice_id IS NOT NULL THEN
727: IF NOT igs_fi_crdapi_util.validate_invoice_id ( p_n_invoice_id => p_credit_rec.p_invoice_id) THEN
728: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
729: fnd_message.set_name('IGS', 'IGS_FI_NO_INV_INVOICE_TBL');
730: fnd_msg_pub.ADD;
731: p_b_return_status := FALSE;
732: RETURN;

Line 730: fnd_msg_pub.ADD;

726: IF p_credit_rec.p_invoice_id IS NOT NULL THEN
727: IF NOT igs_fi_crdapi_util.validate_invoice_id ( p_n_invoice_id => p_credit_rec.p_invoice_id) THEN
728: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
729: fnd_message.set_name('IGS', 'IGS_FI_NO_INV_INVOICE_TBL');
730: fnd_msg_pub.ADD;
731: p_b_return_status := FALSE;
732: RETURN;
733: END IF;
734: END IF;

Line 740: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

736:
737: -- Validate the Credit Card Payee, if passed
738: IF p_credit_rec.p_v_credit_card_payee_cd IS NOT NULL THEN
739: IF NOT igs_fi_crdapi_util.validate_credit_card_payee(p_v_credit_card_payee_cd => p_credit_rec.p_v_credit_card_payee_cd) THEN
740: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
741: fnd_message.set_name('IGS', 'IGS_FI_INV_PAYEEID');
742: fnd_msg_pub.ADD;
743: p_b_return_status := FALSE;
744: RETURN;

Line 742: fnd_msg_pub.ADD;

738: IF p_credit_rec.p_v_credit_card_payee_cd IS NOT NULL THEN
739: IF NOT igs_fi_crdapi_util.validate_credit_card_payee(p_v_credit_card_payee_cd => p_credit_rec.p_v_credit_card_payee_cd) THEN
740: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
741: fnd_message.set_name('IGS', 'IGS_FI_INV_PAYEEID');
742: fnd_msg_pub.ADD;
743: p_b_return_status := FALSE;
744: RETURN;
745: END IF;
746: END IF;

Line 754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

750: IF p_credit_rec.p_v_credit_card_status_code IS NOT NULL THEN
751: IF NOT igs_fi_crdapi_util.validate_igs_lkp ( p_v_lookup_type => 'IGS_FI_CREDIT_CARD_STATUS',
752: p_v_lookup_code => p_credit_rec.p_v_credit_card_status_code)
753: OR p_credit_rec.p_v_credit_card_status_code <> 'PENDING' THEN
754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
755: fnd_message.set_name ( 'IGS', 'IGS_FI_INV_CC_STATUS');
756: fnd_msg_pub.ADD;
757: p_b_return_status := FALSE;
758: RETURN;

Line 756: fnd_msg_pub.ADD;

752: p_v_lookup_code => p_credit_rec.p_v_credit_card_status_code)
753: OR p_credit_rec.p_v_credit_card_status_code <> 'PENDING' THEN
754: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
755: fnd_message.set_name ( 'IGS', 'IGS_FI_INV_CC_STATUS');
756: fnd_msg_pub.ADD;
757: p_b_return_status := FALSE;
758: RETURN;
759: END IF;
760: END IF;

Line 787: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN

783: p_v_attribute18 => p_attribute_rec.p_attribute18,
784: p_v_attribute19 => p_attribute_rec.p_attribute19,
785: p_v_attribute20 => p_attribute_rec.p_attribute20,
786: p_v_desc_flex_name => 'IGS_FI_CREDITS_ALL_FLEX') THEN
787: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
788: fnd_message.set_name('IGS', 'IGS_AD_INVALID_DESC_FLEX');
789: fnd_msg_pub.ADD;
790: p_b_return_status := FALSE;
791: RETURN;

Line 789: fnd_msg_pub.ADD;

785: p_v_attribute20 => p_attribute_rec.p_attribute20,
786: p_v_desc_flex_name => 'IGS_FI_CREDITS_ALL_FLEX') THEN
787: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR) THEN
788: fnd_message.set_name('IGS', 'IGS_AD_INVALID_DESC_FLEX');
789: fnd_msg_pub.ADD;
790: p_b_return_status := FALSE;
791: RETURN;
792: END IF;
793: END IF;