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 89: 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'));

85: okc_debug.Log('50: p_before_after : '||p_before_after ,2);
86: okc_debug.Log('50: p_last_rundate : '||p_last_rundate ,2);
87: END IF;
88:
89: 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'));
90: 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' ));
91: -- call start_activity to create savepoint, check comptability
92: -- and initialize message list
93: l_return_status := OKC_API.START_ACTIVITY(l_api_name

Line 90: 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' ));

86: okc_debug.Log('50: p_last_rundate : '||p_last_rundate ,2);
87: END IF;
88:
89: 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'));
90: 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' ));
91: -- call start_activity to create savepoint, check comptability
92: -- and initialize message list
93: l_return_status := OKC_API.START_ACTIVITY(l_api_name
94: ,p_init_msg_list

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

137: k1_rec.authoring_org_id);
138:
139: IF l_hook_filter='Y' THEN
140:
141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract picked for Renewal :'||substr(k1_rec.k_number,1,200));
142: --Initialize the table
143: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
144: FOR elements_rec IN elements_csr LOOP
145:

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

231:
232: FND_MESSAGE.SET_NAME('OKC','OKC_EDA_CONTRACTS');
233: -- FND_MESSAGE.SET_TOKEN('NUMBER',k1_rec.k_number);
234: 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'));
235: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
236: END IF; -- l_hook_filter if
237: END LOOP; -- end of k1_csr
238: COMMIT;
239: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 374: 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'));

370: okc_debug.Log('100: p_before_after : '||p_before_after ,2);
371: okc_debug.Log('100: p_last_rundate : '||p_last_rundate ,2);
372: END IF;
373:
374: 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'));
375: 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' ));
376:
377:
378: -- call start_activity to create savepoint, check comptability

Line 375: 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' ));

371: okc_debug.Log('100: p_last_rundate : '||p_last_rundate ,2);
372: END IF;
373:
374: 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'));
375: 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' ));
376:
377:
378: -- call start_activity to create savepoint, check comptability
379: -- and initialize message list

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

418: FOR k1_rec in k1_csr(p_chr_id => p_dnz_chr_id,
419: p_variance => l_variance,
420: p_last_rundate => l_last_rundate) LOOP
421: k := 0;
422: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Contract picked for Renewal :'||substr(k1_rec.k_number,1,200));
423:
424: --Initialize the table
425: l_msg_tbl := okc_aq_pvt.msg_tab_typ();
426: FOR elements_rec IN elements_csr LOOP

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

528:
529: FND_MESSAGE.SET_NAME('OKC','OKC_EDA_CONTRACTS');
530: 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'));
531: FND_MESSAGE.SET_TOKEN('NUMBER',k1_rec.k_number);
532: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
533:
534: IF (l_debug = 'Y') THEN
535: okc_debug.Log('170: going to next k ',2);
536: END IF;