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_EN_FUTURE_DT_TRANS dependencies on FND_FILE

Line 106: FND_FILE.PUT_LINE (FND_FILE.LOG, l_msg_text);

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)
110: LOOP

Line 117: FND_FILE.PUT_LINE (FND_FILE.LOG, l_msg_text);

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

Line 2454: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2450: l_process_mode := NULL;
2451:
2452: END IF;
2453:
2454: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2455: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2456: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Term Calendar :'||l_term_cal_type||', Term Calendar Sequence Number :'||l_term_sequence_number||', Ignore warnings :'||p_ignore_warnings||', Drop Enrolled :'||p_drop_enrolled);
2457: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2458:

Line 2455: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2451:
2452: END IF;
2453:
2454: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2455: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2456: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Term Calendar :'||l_term_cal_type||', Term Calendar Sequence Number :'||l_term_sequence_number||', Ignore warnings :'||p_ignore_warnings||', Drop Enrolled :'||p_drop_enrolled);
2457: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2458:
2459: OPEN c_enr_cal_conf;

Line 2456: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Term Calendar :'||l_term_cal_type||', Term Calendar Sequence Number :'||l_term_sequence_number||', Ignore warnings :'||p_ignore_warnings||', Drop Enrolled :'||p_drop_enrolled);

2452: END IF;
2453:
2454: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2455: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2456: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Term Calendar :'||l_term_cal_type||', Term Calendar Sequence Number :'||l_term_sequence_number||', Ignore warnings :'||p_ignore_warnings||', Drop Enrolled :'||p_drop_enrolled);
2457: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2458:
2459: OPEN c_enr_cal_conf;
2460: FETCH c_enr_cal_conf INTO v_begin_pt_dt_alias,v_cleanup_dt_alias;

Line 2457: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2453:
2454: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2455: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2456: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Term Calendar :'||l_term_cal_type||', Term Calendar Sequence Number :'||l_term_sequence_number||', Ignore warnings :'||p_ignore_warnings||', Drop Enrolled :'||p_drop_enrolled);
2457: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2458:
2459: OPEN c_enr_cal_conf;
2460: FETCH c_enr_cal_conf INTO v_begin_pt_dt_alias,v_cleanup_dt_alias;
2461:

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 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 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 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 2549: FND_FILE.PUT_LINE (FND_FILE.LOG, '-----------------------------------------------------------------------------');

2545: OPEN c_person_num(v_clnup_rec.person_id);
2546: FETCH c_person_num INTO v_person_num;
2547: CLOSE c_person_num;
2548:
2549: FND_FILE.PUT_LINE (FND_FILE.LOG, '-----------------------------------------------------------------------------');
2550: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Person :'||v_person_num||' Source Course :'||v_clnup_rec.transfer_course_cd||' Destination Course :'||v_clnup_rec.course_cd);
2551: FND_FILE.PUT_LINE (FND_FILE.LOG, '-----------------------------------------------------------------------------');
2552: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2553:

Line 2550: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Person :'||v_person_num||' Source Course :'||v_clnup_rec.transfer_course_cd||' Destination Course :'||v_clnup_rec.course_cd);

2546: FETCH c_person_num INTO v_person_num;
2547: CLOSE c_person_num;
2548:
2549: FND_FILE.PUT_LINE (FND_FILE.LOG, '-----------------------------------------------------------------------------');
2550: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Person :'||v_person_num||' Source Course :'||v_clnup_rec.transfer_course_cd||' Destination Course :'||v_clnup_rec.course_cd);
2551: FND_FILE.PUT_LINE (FND_FILE.LOG, '-----------------------------------------------------------------------------');
2552: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2553:
2554: IF p_mode IN ('CLEANUP','DELETE') THEN

Line 2551: FND_FILE.PUT_LINE (FND_FILE.LOG, '-----------------------------------------------------------------------------');

2547: CLOSE c_person_num;
2548:
2549: FND_FILE.PUT_LINE (FND_FILE.LOG, '-----------------------------------------------------------------------------');
2550: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Person :'||v_person_num||' Source Course :'||v_clnup_rec.transfer_course_cd||' Destination Course :'||v_clnup_rec.course_cd);
2551: FND_FILE.PUT_LINE (FND_FILE.LOG, '-----------------------------------------------------------------------------');
2552: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2553:
2554: IF p_mode IN ('CLEANUP','DELETE') THEN
2555:

Line 2552: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');

2548:
2549: FND_FILE.PUT_LINE (FND_FILE.LOG, '-----------------------------------------------------------------------------');
2550: FND_FILE.PUT_LINE (FND_FILE.LOG, 'Person :'||v_person_num||' Source Course :'||v_clnup_rec.transfer_course_cd||' Destination Course :'||v_clnup_rec.course_cd);
2551: FND_FILE.PUT_LINE (FND_FILE.LOG, '-----------------------------------------------------------------------------');
2552: FND_FILE.PUT_LINE (FND_FILE.LOG, ' ');
2553:
2554: IF p_mode IN ('CLEANUP','DELETE') THEN
2555:
2556: BEGIN

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 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 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 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 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 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 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 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 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 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 2727: FND_FILE.PUT_LINE(FND_FILE.LOG,l_message_name);

2723: );
2724: IF l_message_name IS NOT NULL -- AND l_acad_cal_seq_num IS NULL
2725: THEN
2726:
2727: FND_FILE.PUT_LINE(FND_FILE.LOG,l_message_name);
2728:
2729: ELSE
2730: -- Call the transfer api to carry out the transfer
2731: -- set the research details flag to 'N' as it has already been transferred

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 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 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 2805: FND_FILE.PUT_LINE (FND_FILE.LOG, l_msg);

2801: IF l_msg IS NULL THEN
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;

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