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

Line 921: fnd_file.put_line(FND_FILE.LOG, p_mesg);

917: IF l_conc_program = 'N' THEN
918: -- errorout_ad(p_mesg);
919: null;
920: ELSE
921: fnd_file.put_line(FND_FILE.LOG, p_mesg);
922: END IF;
923: END LOG_MESSAGES;
924:
925:

Line 1846: fnd_file.put_line(FND_FILE.LOG,'Start Time ' || to_char(sysdate,'HH:MI:SS'));

1842: END GET_ORG_ID;
1843:
1844: BEGIN
1845:
1846: fnd_file.put_line(FND_FILE.LOG,'Start Time ' || to_char(sysdate,'HH:MI:SS'));
1847: -- l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1848:
1849: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1850: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

Line 1863: fnd_file.put_line(FND_FILE.LOG,'OKS: Use Territories to Default Sales Person: Yes');

1859:
1860: l_org_id := p_org_id;
1861:
1862: IF (FND_PROFILE.VALUE('OKS_USE_JTF') = 'YES') THEN
1863: fnd_file.put_line(FND_FILE.LOG,'OKS: Use Territories to Default Sales Person: Yes');
1864: l_cro_code := FND_PROFILE.VALUE('OKS_VENDOR_CONTACT_ROLE');
1865:
1866: -- set org context when the org parameter is not null
1867: IF l_org_id IS NOT NULL THEN

Line 1872: fnd_file.put_line(FND_FILE.LOG,'Invalid CRO Code');

1868: OKC_CONTEXT.set_okc_org_context(l_org_id,null);
1869: END IF;
1870:
1871: IF l_cro_code IS NULL THEN
1872: fnd_file.put_line(FND_FILE.LOG,'Invalid CRO Code');
1873: NOTIFY_SETUP_ADMIN;
1874: ELSE
1875: IF NVL(fnd_profile.value('OKS_SRC_TERR_QUALFIERS'),'V')='V' THEN
1876: l_terr_res := 'V';

Line 2270: fnd_file.put_line(FND_FILE.LOG,'After JTF API Call : ' || l_return_status ) ;

2266: x_msg_data => l_msg_data,
2267: x_winners_rec => l_gen_return_rec
2268: );
2269:
2270: fnd_file.put_line(FND_FILE.LOG,'After JTF API Call : ' || l_return_status ) ;
2271: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2272: -- Handle error from territory API
2273: fnd_file.put_line(FND_FILE.LOG,'Exception in JTF Territory call');
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2273: fnd_file.put_line(FND_FILE.LOG,'Exception in JTF Territory call');

2269:
2270: fnd_file.put_line(FND_FILE.LOG,'After JTF API Call : ' || l_return_status ) ;
2271: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2272: -- Handle error from territory API
2273: fnd_file.put_line(FND_FILE.LOG,'Exception in JTF Territory call');
2274: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2275: ELSE
2276: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2277: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',

Line 2356: fnd_file.put_line(FND_FILE.LOG,l_admin_msg || ' Contract Number - ' || l_e_contract_number);

2352: ( 1,
2353: l_e_contract_number,
2354: l_e_contract_number_mod,
2355: l_admin_msg);
2356: fnd_file.put_line(FND_FILE.LOG,l_admin_msg || ' Contract Number - ' || l_e_contract_number);
2357: END IF;
2358: EXIT WHEN idx4 =l_winning_tbl.LAST;
2359: idx4 := l_winning_tbl.NEXT(idx4);
2360: END IF;

Line 2395: fnd_file.put_line(FND_FILE.LOG,'There is no resource setup. Contract Number - '|| contract_noresource_rec.Contract_number);

2391: contract_noresource_rec.Contract_number,
2392: contract_noresource_rec.Contract_number_modifier,l_terr_admin_msg);
2393: DELETE FROM oks_k_res_temp
2394: WHERE id = contract_noresource_rec.id;
2395: fnd_file.put_line(FND_FILE.LOG,'There is no resource setup. Contract Number - '|| contract_noresource_rec.Contract_number);
2396: END LOOP;
2397:
2398: -- Send notification for those contracts which has a vendor contact starting in future.
2399: l_f_chr_id := 0;

Line 2413: fnd_file.put_line(FND_FILE.LOG,'Unable to terminate current vendor contact. Contract Number - ' || contact_resource_inf_rec.Contract_number);

2409: NOTIFY_TERRITORY_ADMIN
2410: ( contact_resource_inf_rec.id,
2411: contact_resource_inf_rec.Contract_number,
2412: contact_resource_inf_rec.Contract_number_modifier,l_terr_admin_msg);
2413: fnd_file.put_line(FND_FILE.LOG,'Unable to terminate current vendor contact. Contract Number - ' || contact_resource_inf_rec.Contract_number);
2414: END IF;
2415: l_f_chr_id := contact_resource_inf_rec.id;
2416: END LOOP;
2417:

Line 2605: fnd_file.put_line(FND_FILE.LOG,'Exception in update contact');

2601: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2602: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2603: 'Exception in update contact ');
2604: END IF;
2605: fnd_file.put_line(FND_FILE.LOG,'Exception in update contact');
2606: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2607: END IF;
2608:
2609: IF (l_ctcv_tbl_in_del.count > 0 ) THEN

Line 2634: fnd_file.put_line(FND_FILE.LOG,'Exception in delete contact');

2630: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2631: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2632: 'Exception in delete contact ');
2633: END IF;
2634: fnd_file.put_line(FND_FILE.LOG,'Exception in delete contact');
2635: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2636: END IF;
2637:
2638: IF (l_ctcv_tbl_in.count > 0 ) THEN

Line 2820: fnd_file.put_line(FND_FILE.LOG,'Program completed successfully ' || to_char(sysdate,'HH:MI:SS'));

2816: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2817: 'Reassugn End Time ' ||
2818: to_char(sysdate,'HH:MI:SS') );
2819: END IF;
2820: fnd_file.put_line(FND_FILE.LOG,'Program completed successfully ' || to_char(sysdate,'HH:MI:SS'));
2821: EXCEPTION
2822:
2823: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2824: fnd_file.put_line(FND_FILE.LOG,'Exception occured');

Line 2824: fnd_file.put_line(FND_FILE.LOG,'Exception occured');

2820: fnd_file.put_line(FND_FILE.LOG,'Program completed successfully ' || to_char(sysdate,'HH:MI:SS'));
2821: EXCEPTION
2822:
2823: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2824: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2825: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2826: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2827: 'Error occured : ' || get_fnd_message() );
2828: END IF;

Line 2832: fnd_file.put_line(FND_FILE.LOG,'Exception occured');

2828: END IF;
2829: rollback;
2830: RAISE_APPLICATION_ERROR(-20001, 'Exception occured');
2831: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2832: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2833: IF (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2834: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE_CURRENT ||'.SUBMIT_CONTACT_CREATION',
2835: 'Unexpected Error : ' || get_fnd_message() );
2836: END IF;

Line 2840: fnd_file.put_line(FND_FILE.LOG,'Exception occured');

2836: END IF;
2837: rollback;
2838: RAISE_APPLICATION_ERROR(-20001, 'Exception occured');
2839: WHEN OTHERS THEN
2840: fnd_file.put_line(FND_FILE.LOG,'Exception occured');
2841: OKC_API.set_message(p_app_name => g_app_name,
2842: p_msg_name => g_unexpected_error,
2843: p_token1 => g_sqlcode_token,
2844: p_token1_value => sqlcode,