DBA Data[Home] [Help]

APPS.IGS_EN_FUTURE_DT_TRANS dependencies on FND_MESSAGE

Line 104: FND_MESSAGE.SET_ENCODED(l_msg_data);

100: l_msg_data := p_msg_data;
101: l_warn_and_err_msg := null;
102:
103: IF l_msg_count =1 THEN
104: FND_MESSAGE.SET_ENCODED(l_msg_data);
105: l_msg_text := FND_MESSAGE.GET;
106: FND_FILE.PUT_LINE (FND_FILE.LOG, l_msg_text);
107:
108: ELSIF l_msg_count > 1 THEN

Line 105: l_msg_text := FND_MESSAGE.GET;

101: l_warn_and_err_msg := null;
102:
103: IF l_msg_count =1 THEN
104: FND_MESSAGE.SET_ENCODED(l_msg_data);
105: l_msg_text := FND_MESSAGE.GET;
106: FND_FILE.PUT_LINE (FND_FILE.LOG, l_msg_text);
107:
108: ELSIF l_msg_count > 1 THEN
109: FOR l_index IN 1..NVL(l_msg_count,0)

Line 115: FND_MESSAGE.SET_ENCODED(l_enc_msg);

111: FND_MSG_PUB.GET(FND_MSG_PUB.G_FIRST,
112: FND_API.G_TRUE,
113: l_enc_msg,
114: l_msg_index);
115: FND_MESSAGE.SET_ENCODED(l_enc_msg);
116: l_msg_text := FND_MESSAGE.GET;
117: FND_FILE.PUT_LINE (FND_FILE.LOG, l_msg_text);
118: FND_MSG_PUB.DELETE_MSG(l_msg_index);
119:

Line 116: l_msg_text := FND_MESSAGE.GET;

112: FND_API.G_TRUE,
113: l_enc_msg,
114: l_msg_index);
115: FND_MESSAGE.SET_ENCODED(l_enc_msg);
116: l_msg_text := FND_MESSAGE.GET;
117: FND_FILE.PUT_LINE (FND_FILE.LOG, l_msg_text);
118: FND_MSG_PUB.DELETE_MSG(l_msg_index);
119:
120: END LOOP;

Line 2467: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_BEG_PT_DAV_LT_SYSDATE');

2463:
2464: CLOSE c_enr_cal_conf;
2465: IF p_mode = 'PROCESS' AND v_begin_pt_dt_alias IS NULL THEN
2466:
2467: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_BEG_PT_DAV_LT_SYSDATE');
2468: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2469: RETURN;
2470:
2471: END IF;

Line 2468: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2464: CLOSE c_enr_cal_conf;
2465: IF p_mode = 'PROCESS' AND v_begin_pt_dt_alias IS NULL THEN
2466:
2467: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_BEG_PT_DAV_LT_SYSDATE');
2468: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2469: RETURN;
2470:
2471: END IF;
2472:

Line 2475: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CLNUP_DAV_GE_SYSDATE');

2471: END IF;
2472:
2473: IF p_mode = 'CLEANUP' AND v_cleanup_dt_alias IS NULL THEN
2474:
2475: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CLNUP_DAV_GE_SYSDATE');
2476: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2477: RETURN;
2478:
2479: END IF;

Line 2476: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2472:
2473: IF p_mode = 'CLEANUP' AND v_cleanup_dt_alias IS NULL THEN
2474:
2475: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CLNUP_DAV_GE_SYSDATE');
2476: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2477: RETURN;
2478:
2479: END IF;
2480:

Line 2497: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CLNUP_DAV_GE_SYSDATE');

2493:
2494: IF c_cln_up_dt_alias_val%NOTFOUND OR
2495: (c_cln_up_dt_alias_val%FOUND AND (v_cleanup_dt_alias_val >= SYSDATE)) THEN
2496:
2497: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CLNUP_DAV_GE_SYSDATE');
2498: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2499:
2500: CLOSE c_cln_up_dt_alias_val;
2501: RETURN;

Line 2498: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2494: IF c_cln_up_dt_alias_val%NOTFOUND OR
2495: (c_cln_up_dt_alias_val%FOUND AND (v_cleanup_dt_alias_val >= SYSDATE)) THEN
2496:
2497: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CLNUP_DAV_GE_SYSDATE');
2498: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2499:
2500: CLOSE c_cln_up_dt_alias_val;
2501: RETURN;
2502:

Line 2528: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_BEG_PT_DAV_LT_SYSDATE');

2524:
2525: IF c_begin_pt_dt_alias_val%NOTFOUND OR
2526: (c_begin_pt_dt_alias_val%FOUND AND (SYSDATE NOT BETWEEN v_begin_pt_dt_alias_val AND l_end_dt) ) THEN
2527:
2528: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_BEG_PT_DAV_LT_SYSDATE');
2529: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2530:
2531: CLOSE c_begin_pt_dt_alias_val;
2532: RETURN;

Line 2529: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2525: IF c_begin_pt_dt_alias_val%NOTFOUND OR
2526: (c_begin_pt_dt_alias_val%FOUND AND (SYSDATE NOT BETWEEN v_begin_pt_dt_alias_val AND l_end_dt) ) THEN
2527:
2528: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_BEG_PT_DAV_LT_SYSDATE');
2529: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2530:
2531: CLOSE c_begin_pt_dt_alias_val;
2532: RETURN;
2533:

Line 2577: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_DEL_DEST_PROG');

2573:
2574: -- If no transfer record is found then log the delete successful message
2575: IF c_sct%NOTFOUND THEN
2576:
2577: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_DEL_DEST_PROG');
2578: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2579:
2580: ELSE
2581: -- If destination program attempt record is found log the cant delete message

Line 2578: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2574: -- If no transfer record is found then log the delete successful message
2575: IF c_sct%NOTFOUND THEN
2576:
2577: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_DEL_DEST_PROG');
2578: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2579:
2580: ELSE
2581: -- If destination program attempt record is found log the cant delete message
2582: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CANT_DEL_DEST_PROG');

Line 2582: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CANT_DEL_DEST_PROG');

2578: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2579:
2580: ELSE
2581: -- If destination program attempt record is found log the cant delete message
2582: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CANT_DEL_DEST_PROG');
2583: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2584:
2585: END IF;
2586:

Line 2583: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2579:
2580: ELSE
2581: -- If destination program attempt record is found log the cant delete message
2582: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CANT_DEL_DEST_PROG');
2583: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2584:
2585: END IF;
2586:
2587: END IF;

Line 2599: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_UNCONF_DEST_PROG');

2595: -- then log success message
2596: IF p_mode = 'CLEANUP' AND c_sca%FOUND
2597: AND v_sca_dest_rec.future_dated_trans_flag = 'C' THEN
2598:
2599: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_UNCONF_DEST_PROG');
2600: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2601:
2602: END IF;
2603:

Line 2600: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2596: IF p_mode = 'CLEANUP' AND c_sca%FOUND
2597: AND v_sca_dest_rec.future_dated_trans_flag = 'C' THEN
2598:
2599: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_UNCONF_DEST_PROG');
2600: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2601:
2602: END IF;
2603:
2604: CLOSE c_sca;

Line 2610: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2606:
2607: EXCEPTION
2608: WHEN OTHERS THEN
2609:
2610: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2611:
2612: IF p_mode = 'CLEANUP' THEN
2613:
2614: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CANT_UNCONF_DEST_PROG');

Line 2614: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CANT_UNCONF_DEST_PROG');

2610: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2611:
2612: IF p_mode = 'CLEANUP' THEN
2613:
2614: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CANT_UNCONF_DEST_PROG');
2615: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2616:
2617: END IF;
2618:

Line 2615: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2611:
2612: IF p_mode = 'CLEANUP' THEN
2613:
2614: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_CANT_UNCONF_DEST_PROG');
2615: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2616:
2617: END IF;
2618:
2619:

Line 2633: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_INTM');

2629: --- If destination program attempt is intermitted/lapsed/discontinued/unconfirme
2630: --- then dont allow the transfer
2631: IF v_sca_dest_rec.course_attempt_status = 'INTERMITTED' THEN
2632:
2633: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_INTM');
2634: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2635: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2636: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2637:

Line 2634: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);

2630: --- then dont allow the transfer
2631: IF v_sca_dest_rec.course_attempt_status = 'INTERMITTED' THEN
2632:
2633: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_INTM');
2634: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2635: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2636: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2637:
2638: ELSIF v_sca_dest_rec.course_attempt_status = 'LAPSED' THEN

Line 2635: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);

2631: IF v_sca_dest_rec.course_attempt_status = 'INTERMITTED' THEN
2632:
2633: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_INTM');
2634: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2635: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2636: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2637:
2638: ELSIF v_sca_dest_rec.course_attempt_status = 'LAPSED' THEN
2639:

Line 2636: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2632:
2633: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_INTM');
2634: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2635: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2636: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2637:
2638: ELSIF v_sca_dest_rec.course_attempt_status = 'LAPSED' THEN
2639:
2640: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_LAPSE');

Line 2640: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_LAPSE');

2636: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2637:
2638: ELSIF v_sca_dest_rec.course_attempt_status = 'LAPSED' THEN
2639:
2640: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_LAPSE');
2641: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2642: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2643: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2644:

Line 2641: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);

2637:
2638: ELSIF v_sca_dest_rec.course_attempt_status = 'LAPSED' THEN
2639:
2640: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_LAPSE');
2641: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2642: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2643: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2644:
2645: ELSIF v_sca_dest_rec.course_attempt_status = 'DISCONTIN' THEN

Line 2642: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);

2638: ELSIF v_sca_dest_rec.course_attempt_status = 'LAPSED' THEN
2639:
2640: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_LAPSE');
2641: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2642: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2643: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2644:
2645: ELSIF v_sca_dest_rec.course_attempt_status = 'DISCONTIN' THEN
2646:

Line 2643: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2639:
2640: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_LAPSE');
2641: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2642: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2643: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2644:
2645: ELSIF v_sca_dest_rec.course_attempt_status = 'DISCONTIN' THEN
2646:
2647: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_DISCON');

Line 2647: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_DISCON');

2643: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2644:
2645: ELSIF v_sca_dest_rec.course_attempt_status = 'DISCONTIN' THEN
2646:
2647: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_DISCON');
2648: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2649: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2650: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2651:

Line 2648: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);

2644:
2645: ELSIF v_sca_dest_rec.course_attempt_status = 'DISCONTIN' THEN
2646:
2647: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_DISCON');
2648: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2649: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2650: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2651:
2652: ELSIF v_sca_dest_rec.course_attempt_status = 'UNCONFIRM' THEN

Line 2649: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);

2645: ELSIF v_sca_dest_rec.course_attempt_status = 'DISCONTIN' THEN
2646:
2647: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_DISCON');
2648: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2649: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2650: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2651:
2652: ELSIF v_sca_dest_rec.course_attempt_status = 'UNCONFIRM' THEN
2653:

Line 2650: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2646:
2647: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_DISCON');
2648: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2649: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2650: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2651:
2652: ELSIF v_sca_dest_rec.course_attempt_status = 'UNCONFIRM' THEN
2653:
2654: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_UNCONF');

Line 2654: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_UNCONF');

2650: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2651:
2652: ELSIF v_sca_dest_rec.course_attempt_status = 'UNCONFIRM' THEN
2653:
2654: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_UNCONF');
2655: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2656: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2657: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2658:

Line 2655: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);

2651:
2652: ELSIF v_sca_dest_rec.course_attempt_status = 'UNCONFIRM' THEN
2653:
2654: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_UNCONF');
2655: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2656: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2657: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2658:
2659:

Line 2656: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);

2652: ELSIF v_sca_dest_rec.course_attempt_status = 'UNCONFIRM' THEN
2653:
2654: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_UNCONF');
2655: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2656: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2657: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2658:
2659:
2660: ELSE

Line 2657: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2653:
2654: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_DEST_UNCONF');
2655: FND_MESSAGE.SET_TOKEN('SOURCE_PROGRAM', v_clnup_rec.transfer_course_cd);
2656: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2657: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2658:
2659:
2660: ELSE
2661:

Line 2679: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_SEC_DEST_INTER_CAR');

2675: -- if the transfer is across careers and destination program is secoondary
2676: -- then dont allow the transfer
2677: IF l_tran_across_careers AND v_sca_dest_rec.primary_program_type = 'SECONDARY' THEN
2678:
2679: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_SEC_DEST_INTER_CAR');
2680: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2681: App_Exception.Raise_Exception;
2682:
2683: END IF;

Line 2680: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2676: -- then dont allow the transfer
2677: IF l_tran_across_careers AND v_sca_dest_rec.primary_program_type = 'SECONDARY' THEN
2678:
2679: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_TRN_SEC_DEST_INTER_CAR');
2680: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2681: App_Exception.Raise_Exception;
2682:
2683: END IF;
2684: -- If the transfer is within careers

Line 2702: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PRIMARY_IN_PRIOR_TERM');

2698: IF (c_prim_in_prev_terms%FOUND) THEN
2699:
2700: CLOSE c_prim_in_prev_terms;
2701:
2702: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PRIMARY_IN_PRIOR_TERM');
2703: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2704: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2705: EXIT;
2706:

Line 2703: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);

2699:
2700: CLOSE c_prim_in_prev_terms;
2701:
2702: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PRIMARY_IN_PRIOR_TERM');
2703: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2704: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2705: EXIT;
2706:
2707: END IF;

Line 2704: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2700: CLOSE c_prim_in_prev_terms;
2701:
2702: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PRIMARY_IN_PRIOR_TERM');
2703: FND_MESSAGE.SET_TOKEN('DEST_PROGRAM', v_clnup_rec.course_cd);
2704: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2705: EXIT;
2706:
2707: END IF;
2708: CLOSE c_prim_in_prev_terms;

Line 2773: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF_FAIL');

2769: retcode := 2;
2770:
2771: ELSIF l_return_status = 'E' THEN
2772:
2773: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF_FAIL');
2774: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2775:
2776: ELSIF l_return_status = 'S' AND l_show_warning = 'Y' AND l_msg_count > 0 THEN
2777:

Line 2774: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2770:
2771: ELSIF l_return_status = 'E' THEN
2772:
2773: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF_FAIL');
2774: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2775:
2776: ELSIF l_return_status = 'S' AND l_show_warning = 'Y' AND l_msg_count > 0 THEN
2777:
2778: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF_WARN');

Line 2778: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF_WARN');

2774: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2775:
2776: ELSIF l_return_status = 'S' AND l_show_warning = 'Y' AND l_msg_count > 0 THEN
2777:
2778: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF_WARN');
2779: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2780:
2781: ELSE
2782:

Line 2779: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2775:
2776: ELSIF l_return_status = 'S' AND l_show_warning = 'Y' AND l_msg_count > 0 THEN
2777:
2778: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF_WARN');
2779: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2780:
2781: ELSE
2782:
2783: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF');

Line 2783: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF');

2779: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2780:
2781: ELSE
2782:
2783: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF');
2784: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2785:
2786: END IF;
2787:

Line 2784: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2780:
2781: ELSE
2782:
2783: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF');
2784: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2785:
2786: END IF;
2787:
2788: END IF; -- if condition for academic calendar details

Line 2799: l_msg := FND_MESSAGE.GET;

2795: WHEN OTHERS THEN
2796:
2797: IF p_mode = 'PROCESS' THEN
2798:
2799: l_msg := FND_MESSAGE.GET;
2800:
2801: IF l_msg IS NULL THEN
2802: l_msg := sqlerrm;
2803: END IF;

Line 2806: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF_FAIL');

2802: l_msg := sqlerrm;
2803: END IF;
2804:
2805: FND_FILE.PUT_LINE (FND_FILE.LOG, l_msg);
2806: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF_FAIL');
2807: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2808:
2809: END IF;
2810:

Line 2807: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2803: END IF;
2804:
2805: FND_FILE.PUT_LINE (FND_FILE.LOG, l_msg);
2806: FND_MESSAGE.SET_NAME ('IGS', 'IGS_EN_FUT_DT_TRANSF_FAIL');
2807: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2808:
2809: END IF;
2810:
2811: END;

Line 2818: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_NO_DATA_FOUND');

2814:
2815: --- No Data is found
2816: IF NOT l_rec_exists THEN
2817:
2818: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_NO_DATA_FOUND');
2819: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2820:
2821: END IF;
2822:

Line 2819: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);

2815: --- No Data is found
2816: IF NOT l_rec_exists THEN
2817:
2818: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_NO_DATA_FOUND');
2819: FND_FILE.PUT_LINE (FND_FILE.LOG, FND_MESSAGE.GET);
2820:
2821: END IF;
2822:
2823: EXCEPTION

Line 2827: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

2823: EXCEPTION
2824:
2825: WHEN OTHERS THEN
2826: retcode:=2;
2827: ERRBUF := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
2828:
2829: END process_fut_dt_trans;
2830:
2831: /*----------------------------------------------------------------------------