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.OKC_EXP_DATE_ASMBLR_PVT dependencies on FND_FILE

Line 88: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Rundate (dd/mm/yyyy:hh24:mi:ss) :'||to_char(p_last_rundate,'dd/mm/yyyy:hh24:mi:ss'));

84: okc_debug.Log('50: p_before_after : '||p_before_after ,2);
85: okc_debug.Log('50: p_last_rundate : '||p_last_rundate ,2);
86: END IF;
87:
88: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Rundate (dd/mm/yyyy:hh24:mi:ss) :'||to_char(p_last_rundate,'dd/mm/yyyy:hh24:mi:ss'));
89: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End_Date Range (dd/mm/yyyy:hh24:mi:ss) :'||to_char((p_cnh_variance + trunc(p_last_rundate) + 1),'dd/mm/yyyy:hh24:mi:ss') || ' and ' || to_char((trunc(sysdate) + p_cnh_variance + 0.99999),'dd/mm/yyyy:hh24:mi:ss' ));
90: -- call start_activity to create savepoint, check comptability
91: -- and initialize message list
92: l_return_status := OKC_API.START_ACTIVITY(l_api_name

Line 89: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End_Date Range (dd/mm/yyyy:hh24:mi:ss) :'||to_char((p_cnh_variance + trunc(p_last_rundate) + 1),'dd/mm/yyyy:hh24:mi:ss') || ' and ' || to_char((trunc(sysdate) + p_cnh_variance + 0.99999),'dd/mm/yyyy:hh24:mi:ss' ));

85: okc_debug.Log('50: p_last_rundate : '||p_last_rundate ,2);
86: END IF;
87:
88: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Rundate (dd/mm/yyyy:hh24:mi:ss) :'||to_char(p_last_rundate,'dd/mm/yyyy:hh24:mi:ss'));
89: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End_Date Range (dd/mm/yyyy:hh24:mi:ss) :'||to_char((p_cnh_variance + trunc(p_last_rundate) + 1),'dd/mm/yyyy:hh24:mi:ss') || ' and ' || to_char((trunc(sysdate) + p_cnh_variance + 0.99999),'dd/mm/yyyy:hh24:mi:ss' ));
90: -- call start_activity to create savepoint, check comptability
91: -- and initialize message list
92: l_return_status := OKC_API.START_ACTIVITY(l_api_name
93: ,p_init_msg_list

Line 126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract picked for Renewal :'||substr(k1_rec.k_number,1,200));

122: FOR k1_rec in k1_csr(p_chr_id => p_dnz_chr_id,
123: p_variance => l_variance,
124: p_last_rundate => l_last_rundate) LOOP
125: k := 0;
126: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract picked for Renewal :'||substr(k1_rec.k_number,1,200));
127: --Initialize the table
128: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
129: FOR elements_rec IN elements_csr LOOP
130:

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

216:
217: FND_MESSAGE.SET_NAME('OKC','OKC_EDA_CONTRACTS');
218: -- FND_MESSAGE.SET_TOKEN('NUMBER',k1_rec.k_number);
219: FND_MESSAGE.SET_TOKEN('NUMBER',k1_rec.k_number||': '||k1_rec.k_nbr_mod||': Ending '|| to_char(k1_rec.k_expire_date,'DD-MM-YYYY:hh24:mi:ss'));
220: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
221: END LOOP;
222: commit;
223: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
224:

Line 358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Rundate (dd/mm/yyyy:hh24:mi:ss) :'||to_char(p_last_rundate,'dd/mm/yyyy:hh24:mi:ss'));

354: okc_debug.Log('100: p_before_after : '||p_before_after ,2);
355: okc_debug.Log('100: p_last_rundate : '||p_last_rundate ,2);
356: END IF;
357:
358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Rundate (dd/mm/yyyy:hh24:mi:ss) :'||to_char(p_last_rundate,'dd/mm/yyyy:hh24:mi:ss'));
359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End_Date Range (dd/mm/yyyy:hh24:mi:ss) :'||to_char((p_cnh_variance + trunc(p_last_rundate) + 1),'dd/mm/yyyy:hh24:mi:ss') || ' and ' || to_char((trunc(sysdate) + p_cnh_variance + 0.99999),'dd/mm/yyyy:hh24:mi:ss' ));
360:
361:
362: -- call start_activity to create savepoint, check comptability

Line 359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End_Date Range (dd/mm/yyyy:hh24:mi:ss) :'||to_char((p_cnh_variance + trunc(p_last_rundate) + 1),'dd/mm/yyyy:hh24:mi:ss') || ' and ' || to_char((trunc(sysdate) + p_cnh_variance + 0.99999),'dd/mm/yyyy:hh24:mi:ss' ));

355: okc_debug.Log('100: p_last_rundate : '||p_last_rundate ,2);
356: END IF;
357:
358: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Last Rundate (dd/mm/yyyy:hh24:mi:ss) :'||to_char(p_last_rundate,'dd/mm/yyyy:hh24:mi:ss'));
359: FND_FILE.PUT_LINE(FND_FILE.LOG, 'End_Date Range (dd/mm/yyyy:hh24:mi:ss) :'||to_char((p_cnh_variance + trunc(p_last_rundate) + 1),'dd/mm/yyyy:hh24:mi:ss') || ' and ' || to_char((trunc(sysdate) + p_cnh_variance + 0.99999),'dd/mm/yyyy:hh24:mi:ss' ));
360:
361:
362: -- call start_activity to create savepoint, check comptability
363: -- and initialize message list

Line 406: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract picked for Renewal :'||substr(k1_rec.k_number,1,200));

402: FOR k1_rec in k1_csr(p_chr_id => p_dnz_chr_id,
403: p_variance => l_variance,
404: p_last_rundate => l_last_rundate) LOOP
405: k := 0;
406: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract picked for Renewal :'||substr(k1_rec.k_number,1,200));
407:
408: --Initialize the table
409: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
410: FOR elements_rec IN elements_csr LOOP

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

512:
513: FND_MESSAGE.SET_NAME('OKC','OKC_EDA_CONTRACTS');
514: FND_MESSAGE.SET_TOKEN('NUMBER',k1_rec.k_number||': '||k1_rec.k_nbr_mod||':Ending '|| to_char(k1_rec.k_expire_date,'DD-MM-YYYY:hh24:mi:ss'));
515: FND_MESSAGE.SET_TOKEN('NUMBER',k1_rec.k_number);
516: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
517:
518: IF (l_debug = 'Y') THEN
519: okc_debug.Log('170: going to next k ',2);
520: END IF;