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.IGS_FI_CRDAPI_UTIL dependencies on IGS_FI_CRDAPI_UTIL

Line 1: PACKAGE BODY igs_fi_crdapi_util AS

1: PACKAGE BODY igs_fi_crdapi_util AS
2: /* $Header: IGSFI84B.pls 120.5 2006/02/10 04:43:13 sapanigr ship $ */
3:
4: /*
5: Procedure VALIDATE_PARAMETERS is the main procedure which has calls to

Line 381: IF NOT igs_fi_crdapi_util.validate_credit_status ( p_v_crd_status => p_credit_rec.p_credit_status ) THEN

377:
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;

Line 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

389: END IF;
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;

Line 405: igs_fi_crdapi_util.validate_credit_type ( p_n_credit_type_id => p_credit_rec.p_credit_type_id,

401: END IF;
402: END IF;
403:
404: -- Check if the Credit Type is active as on the current date
405: igs_fi_crdapi_util.validate_credit_type ( p_n_credit_type_id => p_credit_rec.p_credit_type_id,
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

Line 409: OR (igs_fi_crdapi_util.validate_igs_lkp ( 'IGS_FI_CREDIT_CLASS', l_v_credit_class ) = FALSE) THEN

405: igs_fi_crdapi_util.validate_credit_type ( p_n_credit_type_id => p_credit_rec.p_credit_type_id,
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;

Line 432: IF NOT igs_fi_crdapi_util.validate_party_id ( p_n_party_id => p_credit_rec.p_party_id,

428: END IF;
429:
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);

Line 458: IF NOT igs_fi_crdapi_util.validate_igs_lkp ( p_v_lookup_type => 'IGS_FI_CREDIT_INSTRUMENT',

454: END IF;
455: END IF;
456:
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');

Line 487: igs_fi_crdapi_util.validate_dep_crtype( p_credit_rec.p_credit_type_id,

483:
484: -- If the Credit Class is either 'Enrollment Deposit' or 'Other Deposit' then check if the
485: -- Payment Credit Type attached to the Deposit Credit Type is active as on the current date.
486: IF l_v_credit_class IN ('ENRDEPOSIT','OTHDEPOSIT') 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

Line 512: igs_fi_crdapi_util.validate_gl_date ( p_d_gl_date => p_credit_rec.p_gl_date,

508: END IF;
509: END IF;
510:
511: -- Check if the GL Date parameter (P_CREDIT_REC.P_GL_DATE) is in valid period
512: igs_fi_crdapi_util.validate_gl_date ( p_d_gl_date => p_credit_rec.p_gl_date,
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

Line 542: igs_fi_crdapi_util.validate_source_tran_type ( p_v_source_tran_type => p_credit_rec.p_source_tran_type,

538: END IF;
539:
540: -- Validate Source Transaction Type Parameter, if passed
541: IF p_credit_rec.p_source_tran_type IS NOT NULL THEN
542: igs_fi_crdapi_util.validate_source_tran_type ( p_v_source_tran_type => p_credit_rec.p_source_tran_type,
543: p_v_credit_class => l_v_credit_class,
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 );

Line 570: IF NOT igs_fi_crdapi_util.validate_source_tran_ref_num(p_n_party_id => p_credit_rec.p_party_id,

566: END IF;
567:
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);

Line 584: IF NOT igs_fi_crdapi_util.validate_cal_inst ( p_v_cal_type => p_credit_rec.p_awd_yr_cal_type,

580: END IF;
581:
582: -- Validate Award Year, If passed
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');

Line 596: igs_fi_crdapi_util.get_award_year_status( p_v_awd_cal_type => p_credit_rec.p_awd_yr_cal_type,

592: END IF;
593: END IF;
594:
595: l_v_message_name := NULL;
596: igs_fi_crdapi_util.get_award_year_status( p_v_awd_cal_type => p_credit_rec.p_awd_yr_cal_type,
597: p_n_awd_seq_number => p_credit_rec.p_awd_yr_ci_sequence_number,
598: p_v_awd_yr_status => l_v_awd_yr_status_cd,
599: p_v_message_name => l_v_message_name
600: );

Line 614: IF NOT igs_fi_crdapi_util.validate_cal_inst ( p_v_cal_type => p_credit_rec.p_fee_cal_type,

610: END IF;
611:
612: -- Validate Fee Period, If passed
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');

Line 628: igs_fi_crdapi_util.validate_fci_lci_reln ( p_v_fee_cal_type => p_credit_rec.p_fee_cal_type,

624: END IF;
625:
626: -- If Fee period is passed and it is valid then check if there exists any relation with load calendar
627: IF p_credit_rec.p_fee_cal_type IS NOT NULL AND p_credit_rec.p_fee_ci_sequence_number IS NOT NULL THEN
628: igs_fi_crdapi_util.validate_fci_lci_reln ( p_v_fee_cal_type => p_credit_rec.p_fee_cal_type,
629: p_n_fee_ci_sequence_number => p_credit_rec.p_fee_ci_sequence_number,
630: p_v_ld_cal_type => l_v_ld_cal_type,
631: p_n_ld_ci_sequence_number => l_v_ld_ci_seq_num,
632: p_v_message_name => l_v_message_name,

Line 652: ELSIF NOT igs_fi_crdapi_util.validate_curr ( p_v_currency_cd => p_credit_rec.p_currency_cd) THEN

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
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;

Line 663: igs_fi_crdapi_util.validate_amount ( p_n_amount => p_credit_rec.p_amount,

659: END IF;
660: END IF;
661:
662: -- Validate Amount Passed
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

Line 683: igs_fi_crdapi_util.validate_plan_balance(p_n_person_id => p_credit_rec.p_party_id,

679: l_b_return_status := NULL;
680: IF l_v_credit_class = 'INSTALLMENT_PAYMENTS' THEN
681: --User should not be allowed to create an Installment Payment with the transaction amount greater than
682: --the active Installment balance for the person.
683: igs_fi_crdapi_util.validate_plan_balance(p_n_person_id => p_credit_rec.p_party_id,
684: p_n_amount => p_credit_rec.p_amount,
685: p_b_status => l_b_return_status,
686: p_v_message_name => l_v_message_name
687: );

Line 700: IF NOT igs_fi_crdapi_util.validate_igs_lkp ( p_v_lookup_type => 'IGS_CREDIT_CARDS',

696: END IF;
697:
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);

Line 727: IF NOT igs_fi_crdapi_util.validate_invoice_id ( p_n_invoice_id => p_credit_rec.p_invoice_id) THEN

723:
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;

Line 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

735: END IF;
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;

Line 751: IF NOT igs_fi_crdapi_util.validate_igs_lkp ( p_v_lookup_type => 'IGS_FI_CREDIT_CARD_STATUS',

747: END IF;
748:
749: -- Check if the Credit Card Status is valid, if passed
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');

Line 764: IF NOT igs_fi_crdapi_util.validate_desc_flex (

760: END IF;
761: END IF;
762:
763: -- Validate descriptive flex-field attribute values
764: IF NOT igs_fi_crdapi_util.validate_desc_flex (
765: p_v_attribute_category => p_attribute_rec.p_attribute_category,
766: p_v_attribute1 => p_attribute_rec.p_attribute1,
767: p_v_attribute2 => p_attribute_rec.p_attribute2,
768: p_v_attribute3 => p_attribute_rec.p_attribute3,

Line 819: RETURN igs_fi_crdapi_util.validate_igs_lkp (p_v_lookup_type => 'IGS_FI_CREDIT_STATUS', p_v_lookup_code => 'CLEARED');

815: -- Parameter p_v_crd_status is mandatory.
816: IF (p_v_crd_status IS NULL) OR (p_v_crd_status <> 'CLEARED') THEN
817: RETURN FALSE;
818: END IF;
819: RETURN igs_fi_crdapi_util.validate_igs_lkp (p_v_lookup_type => 'IGS_FI_CREDIT_STATUS', p_v_lookup_code => 'CLEARED');
820:
821: END validate_credit_status;
822:
823: FUNCTION validate_igs_lkp (

Line 1045: IF igs_fi_crdapi_util.validate_cal_inst(

1041: Change History
1042: Who When What
1043: ********************************************************************************************** */
1044: BEGIN
1045: IF igs_fi_crdapi_util.validate_cal_inst(
1046: p_v_cal_type,
1047: p_n_ci_sequence_number,
1048: p_v_s_cal_cat) THEN
1049: RETURN 'TRUE';

Line 1104: IF igs_fi_crdapi_util.validate_cal_inst (

1100: p_v_message_name := l_v_message_name;
1101: p_b_return_stat := FALSE;
1102: ELSE
1103: -- Check if load calendar instance is active in the system.
1104: IF igs_fi_crdapi_util.validate_cal_inst (
1105: p_v_cal_type => l_v_ld_cal_type,
1106: p_n_ci_sequence_number => l_n_ld_seq_number,
1107: p_v_s_cal_cat => 'LOAD') THEN
1108: p_v_message_name := NULL;

Line 1316: IF NOT igs_fi_crdapi_util.validate_igs_lkp ( p_v_lookup_type => 'IGS_FI_SOURCE_TRANSACTION_REF',

1312: RETURN;
1313: END IF;
1314:
1315: -- Check if source transaction type is valid
1316: IF NOT igs_fi_crdapi_util.validate_igs_lkp ( p_v_lookup_type => 'IGS_FI_SOURCE_TRANSACTION_REF',
1317: p_v_lookup_code => p_v_source_tran_type ) THEN
1318: p_b_return_status := FALSE;
1319: p_v_message_name := 'IGS_FI_SOURCE_TRAN_TYP_INVALID';
1320: RETURN;

Line 1626: END igs_fi_crdapi_util;

1622: END IF;
1623:
1624: END translate_local_currency;
1625:
1626: END igs_fi_crdapi_util;