DBA Data[Home] [Help]

APPS.IGS_FI_PRC_FEE_ROLLV dependencies on IGS_GE_MSG_STACK

Line 481: igs_ge_msg_stack.ADD;

477: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
478: p_v_message_name => l_v_message_name );
479: IF l_v_manage_accounts IS NULL THEN
480: fnd_message.set_name ( 'IGS', l_v_message_name );
481: igs_ge_msg_stack.ADD;
482: RAISE l_e_user_exception;
483: END IF;
484:
485: -- Find whether Oracle General Ledger is installed or not.

Line 501: IGS_GE_MSG_STACK.ADD;

497: -- p_rollover_fee_type_ci_ind is duplicatly checked,
498: -- changed to p_rollover_fee_cat_ci_ind inline with CALLISTA Code
499:
500: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
501: IGS_GE_MSG_STACK.ADD;
502: RAISE l_e_user_exception; -- Raised user_Exception to avoid error 'Unhandled exception' when proper error has been logged
503: END IF;
504:
505: -- Check status parameters

Line 509: IGS_GE_MSG_STACK.ADD;

505: -- Check status parameters
506: IF (p_rollover_fee_type_ci_ind = 'Y' AND p_fee_type_ci_status IS NOT NULL) THEN
507: IF (finpl_chk_fss(p_fee_type_ci_status, v_message_name) = FALSE) THEN
508: Fnd_Message.Set_Name ('IGS', v_message_name);
509: IGS_GE_MSG_STACK.ADD;
510: RAISE l_e_user_exception;
511: END IF;
512: END IF;
513:

Line 518: IGS_GE_MSG_STACK.ADD;

514: IF (p_rollover_fee_cat_ci_ind = 'Y') THEN
515: IF (p_fee_cat_ci_status IS NOT NULL) THEN
516: IF (finpl_chk_fss(p_fee_cat_ci_status,v_message_name) = FALSE) THEN
517: Fnd_Message.Set_Name ('IGS', v_message_name);
518: IGS_GE_MSG_STACK.ADD;
519: RAISE l_e_user_exception;
520: END IF;
521: END IF;
522:

Line 526: IGS_GE_MSG_STACK.ADD;

522:
523: IF (p_fee_liability_status IS NOT NULL) THEN
524: IF (finpl_chk_fss(p_fee_liability_status,v_message_name) = FALSE) THEN
525: Fnd_Message.Set_Name ('IGS', v_message_name);
526: IGS_GE_MSG_STACK.ADD;
527: RAISE l_e_user_exception;
528: END IF;
529: END IF;
530: END IF;

Line 535: IGS_GE_MSG_STACK.ADD;

531:
532: -- Can only transfer within the same IGS_CA_TYPE
533: IF (p_source_cal_type <> p_dest_cal_type) THEN
534: Fnd_Message.Set_Name ('IGS', 'IGS_FI_ROLLOVER_FEE_STRUCTURE');
535: IGS_GE_MSG_STACK.ADD;
536: RAISE l_e_user_exception;
537: END IF;
538:
539: -- Check the calendar type exists

Line 545: IGS_GE_MSG_STACK.ADD;

541: FETCH c_cat INTO v_cal_type;
542: IF (c_cat%NOTFOUND) THEN
543: CLOSE c_cat;
544: Fnd_Message.Set_Name ('IGS', 'IGS_GE_VAL_DOES_NOT_XS');
545: IGS_GE_MSG_STACK.ADD;
546: RAISE l_e_user_exception;
547: END IF;
548: CLOSE c_cat;
549:

Line 556: IGS_GE_MSG_STACK.ADD;

552: FETCH c_ci INTO v_prior_ci_sequence_number;
553: IF (c_ci%NOTFOUND) THEN
554: CLOSE c_ci;
555: Fnd_Message.Set_Name ('IGS', 'IGS_PS_DEST_CAL_INST_NOT_EXIS');
556: IGS_GE_MSG_STACK.ADD;
557: RAISE l_e_user_exception;
558: END IF;
559: CLOSE c_ci;
560: -- Validate the destination calendar instance

Line 563: IGS_GE_MSG_STACK.ADD;

559: CLOSE c_ci;
560: -- Validate the destination calendar instance
561: IF (IGS_FI_VAL_FCCI.finp_val_ci_fee(p_dest_cal_type,p_dest_sequence_number,v_message_name) = FALSE) THEN
562: Fnd_Message.Set_Name ('IGS', v_message_name);
563: IGS_GE_MSG_STACK.ADD;
564: RAISE l_e_user_exception;
565: END IF;
566:
567: -- Check destination calendar instance is a

Line 629: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

625: -- since the appropriate error is already getting logged.
626: WHEN l_e_user_exception THEN
627: ROLLBACK;
628: RETCODE:=2;
629: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
630:
631: WHEN OTHERS THEN
632: -- concurrent manager is committing though an Un-Handled exception is raised
633: -- explicitly rollbacking when the process raises Un-Handled exceptions

Line 639: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

635: ROLLBACK;
636: RETCODE:=2;
637: ERRBUF:=FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ':' || SQLERRM;
638: fnd_file.put_line(fnd_file.log,SUBSTR(SQLERRM,1,300));
639: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
640: END;
641: END finp_prc_fee_rollvr;
642: --
643: -- Routine to rollover fee type calendar instances between cal instances

Line 1163: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

1159: p_message_name := v_message_name;
1160: RETURN FALSE;
1161:
1162: WHEN OTHERS THEN
1163: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1164: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_FTCI_ERROR');
1165: fnd_message.set_token('FEE_TYPE',p_fee_type);
1166: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);
1167: fnd_message.set_token('ALT_CODE',g_v_alternate_code);

Line 1450: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

1446: END LOOP;
1447: RETURN TRUE;
1448: EXCEPTION
1449: WHEN OTHERS THEN
1450: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1451: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_FCCI_ERROR');
1452: fnd_message.set_token('FEE_CAT',p_fee_cat);
1453: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);
1454: fnd_message.set_token('ALT_CODE',g_v_alternate_code);

Line 1668: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

1664: END IF;
1665: END IF;
1666: EXCEPTION
1667: WHEN OTHERS THEN
1668: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1669: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_FRTNS_ERROR');
1670: fnd_message.set_token('FEE_CAT',p_fee_cat);
1671: fnd_message.set_token('FEE_TYPE',p_fee_type);
1672: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);

Line 1923: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

1919: v_fcfl_inserted_ind := TRUE;
1920: FND_FILE.PUT_LINE (FND_FILE.LOG, Fnd_Message.Get_String('IGS','IGS_FI_FEECAT_FEELIAB_ROLLED'));
1921: EXCEPTION
1922: WHEN OTHERS THEN
1923: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
1924: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_FCFL_ERROR');
1925: fnd_message.set_token('FEE_CAT',p_fee_cat);
1926: fnd_message.set_token('FEE_TYPE',v_fcfl_fss_rec.fee_type);
1927: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);

Line 2237: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

2233: END IF;
2234: END IF;
2235: EXCEPTION
2236: WHEN OTHERS THEN
2237: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2238: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_FAR_ERROR');
2239: fnd_message.set_token('FEE_CAT',v_far_source_rec.fee_cat);
2240: fnd_message.set_token('FEE_TYPE',p_fee_type);
2241: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);

Line 2524: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

2520: );
2521: v_er_record_inserted_ind := TRUE;
2522: EXCEPTION
2523: WHEN OTHERS THEN
2524: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2525: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_ER_ERROR');
2526: fnd_message.set_token('FEE_CAT',v_er_source_rec.fee_cat);
2527: fnd_message.set_token('FEE_TYPE',p_fee_type);
2528: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);

Line 2576: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

2572: );
2573: v_ser_record_inserted_ind := TRUE;
2574: EXCEPTION
2575: WHEN OTHERS THEN
2576: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2577: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_SUB_ER_ERROR');
2578: fnd_message.set_token('FEE_CAT',v_er_source_rec.fee_cat);
2579: fnd_message.set_token('FEE_TYPE',p_fee_type);
2580: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);

Line 2626: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

2622: OPEN c_sert_far_id_to_rt_num(v_sert_source_rec.far_id);
2623: FETCH c_sert_far_id_to_rt_num INTO v_sert_rate_number;
2624: CLOSE c_sert_far_id_to_rt_num;
2625:
2626: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2627: fnd_message.set_name('IGS','IGS_FI_ROLL_SUB_ER_RT_ERROR');
2628: fnd_message.set_token('FEE_TYPE',p_fee_type);
2629: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);
2630: fnd_message.set_token('ALT_CODE',g_v_alternate_code);

Line 2683: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

2679: );
2680: v_err_record_inserted_ind := TRUE;
2681: EXCEPTION
2682: WHEN OTHERS THEN
2683: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2684: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_ER_RT_ERROR');
2685: fnd_message.set_token('FEE_TYPE',p_fee_type);
2686: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);
2687: fnd_message.set_token('ALT_CODE',g_v_alternate_code);

Line 2815: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

2811: );
2812: v_record_inserted_ind := TRUE;
2813: EXCEPTION
2814: WHEN OTHERS THEN
2815: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2816: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_CTFT_ERROR');
2817: fnd_message.set_token('FEE_CAT',p_fee_cat);
2818: fnd_message.set_token('FEE_TYPE',p_fee_type);
2819: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);

Line 2925: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

2921: );
2922: v_record_inserted_ind := TRUE;
2923: EXCEPTION
2924: WHEN OTHERS THEN
2925: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
2926: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_CGFT_ERROR');
2927: fnd_message.set_token('FEE_CAT',p_fee_cat);
2928: fnd_message.set_token('FEE_TYPE',p_fee_type);
2929: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);

Line 3055: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

3051: );
3052: v_record_inserted_ind := TRUE;
3053: EXCEPTION
3054: WHEN OTHERS THEN
3055: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3056: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_CFT_ERROR');
3057: fnd_message.set_token('FEE_CAT',p_fee_cat);
3058: fnd_message.set_token('FEE_TYPE',p_fee_type);
3059: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);

Line 3202: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

3198: X_MODE=>'R'
3199: );
3200: EXCEPTION
3201: WHEN OTHERS THEN
3202: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3203: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_ANC_ERROR');
3204: fnd_message.set_token('FEE_TYPE',p_fee_type);
3205: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);
3206: fnd_message.set_token('ALT_CODE',g_v_alternate_code);

Line 3252: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

3248: X_MODE=>'R'
3249: );
3250: EXCEPTION
3251: WHEN OTHERS THEN
3252: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3253: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_ANC_RT_ERROR');
3254: fnd_message.set_token('FEE_TYPE',p_fee_type);
3255: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);
3256: fnd_message.set_token('ALT_CODE',g_v_alternate_code);

Line 3347: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

3343: -- l_rowid with a value will throw Un-Handled Exception
3344: l_fee_type_accid:= null;
3345: EXCEPTION
3346: WHEN OTHERS THEN
3347: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3348: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_REVSEG_ERROR');
3349: fnd_message.set_token('FEE_TYPE',p_fee_type);
3350: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);
3351: fnd_message.set_token('ALT_CODE',g_v_alternate_code);

Line 3510: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

3506: x_unit_class => l_rec_ftci_accts.unit_class
3507: );
3508: EXCEPTION
3509: WHEN OTHERS THEN
3510: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3511: fnd_message.set_name('IGS','IGS_FI_ROLL_FTCI_ACCTS_ERROR');
3512: fnd_message.set_token('FEE_TYPE',p_v_fee_type);
3513: fnd_message.set_token('FEE_CAL_TYPE',p_v_source_cal_type);
3514: fnd_message.set_token('ALT_CODE',g_v_alternate_code);

Line 3630: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

3626: x_mode => 'R');
3627: l_b_record_inserted_ind := TRUE;
3628: EXCEPTION
3629: WHEN OTHERS THEN
3630: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3631: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_TRG_GRP_ERROR');
3632: fnd_message.set_token('FEE_CAT',p_fee_cat);
3633: fnd_message.set_token('FEE_TYPE',p_fee_type);
3634: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);

Line 3769: igs_ge_msg_stack.add;

3765: FETCH cur_chk_version INTO l_v_chk_version;
3766: IF cur_chk_version%NOTFOUND THEN
3767: CLOSE cur_chk_version;
3768: fnd_message.set_name('IGS','IGS_PS_UNITVER_ST_ACTIVEPLANN');
3769: igs_ge_msg_stack.add;
3770: app_exception.raise_exception;
3771: END IF;
3772: CLOSE cur_chk_version;
3773:

Line 3795: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

3791: l_b_record_inserted_ind := TRUE;
3792:
3793: EXCEPTION
3794: WHEN OTHERS THEN
3795: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3796: IF ((l_uft_source_rec.cal_type IS NOT NULL) AND (l_uft_source_rec.ci_sequence_number IS NOT NULL)) THEN
3797: OPEN c_alt_cd(l_uft_source_rec.cal_type,l_uft_source_rec.ci_sequence_number);
3798: FETCH c_alt_cd INTO l_v_alt_code;
3799: CLOSE c_alt_cd;

Line 3930: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

3926: x_mode => 'R');
3927: l_b_record_inserted_ind := TRUE;
3928: EXCEPTION
3929: WHEN OTHERS THEN
3930: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
3931: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_USFT_ERROR');
3932: fnd_message.set_token('FEE_CAT',p_fee_cat);
3933: fnd_message.set_token('FEE_TYPE',p_fee_type);
3934: fnd_message.set_token('FEE_CAL_TYPE',p_source_cal_type);

Line 4234: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

4230: EXCEPTION
4231: WHEN OTHERS THEN
4232: ROLLBACK TO SP_ROLL_TP;
4233: l_b_prc_rollover := FALSE;
4234: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
4235: fnd_message.set_name('IGS','IGS_FI_ROLLOVER_TPRS_ERROR');
4236: fnd_message.set_token('FEE_TYPE',p_v_fee_type);
4237: fnd_message.set_token('FEE_CAL_TYPE',p_v_source_cal_type);
4238: fnd_message.set_token('ALT_CODE',g_v_alternate_code);