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

Line 28: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));

24: PROCEDURE get_fnd_msg_stack(p_msg_data IN VARCHAR2) IS
25: BEGIN
26: IF FND_MSG_PUB.Count_Msg > 1 Then
27: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
28: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
29: END LOOP;
30: ELSE
31: FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);
32: END IF;

Line 31: FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);

27: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
28: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MSG_PUB.Get(i,p_encoded =>FND_API.G_FALSE ));
29: END LOOP;
30: ELSE
31: FND_FILE.PUT_LINE(FND_FILE.LOG,p_msg_data);
32: END IF;
33: FND_MSG_PUB.initialize;
34: END get_fnd_msg_stack;
35:

Line 369: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

365: IF (l_debug = 'Y') THEN
366: OKC_DEBUG.log(' 400:Exception Error in task_alert...', 2);
367: OKC_DEBUG.Reset_Indentation;
368: END IF;
369: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
370: get_fnd_msg_stack(' Exception Error in task_alert is '||g_msg_data);
371:
372: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
373: IF (l_debug = 'Y') THEN

Line 377: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

373: IF (l_debug = 'Y') THEN
374: OKC_DEBUG.log(' 400:Unexcepted Error in task_alert...', 2);
375: OKC_DEBUG.Reset_Indentation;
376: END IF;
377: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
378: get_fnd_msg_stack(' Unexpected error in task_alert is '||g_msg_data);
379:
380: WHEN OTHERS THEN
381: IF (l_debug = 'Y') THEN

Line 385: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

381: IF (l_debug = 'Y') THEN
382: OKC_DEBUG.log(' 400:Other Exception Error in task_alert...', 2);
383: OKC_DEBUG.Reset_Indentation;
384: END IF;
385: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
386: retcode := 2;
387: FND_FILE.PUT_LINE( FND_FILE.LOG,substr(sqlerrm,1,250));
388: get_fnd_msg_stack(' Other Exception Error in task_alert is '||g_msg_data);
389: exit;

Line 387: FND_FILE.PUT_LINE( FND_FILE.LOG,substr(sqlerrm,1,250));

383: OKC_DEBUG.Reset_Indentation;
384: END IF;
385: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
386: retcode := 2;
387: FND_FILE.PUT_LINE( FND_FILE.LOG,substr(sqlerrm,1,250));
388: get_fnd_msg_stack(' Other Exception Error in task_alert is '||g_msg_data);
389: exit;
390: END;
391: END LOOP;

Line 398: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);

394: IF (l_debug = 'Y') THEN
395: OKC_DEBUG.log('400: Exiting task_alert...', 2);
396: OKC_DEBUG.Reset_Indentation;
397: END IF;
398: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);
399: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);
400:
401: EXCEPTION
402: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 399: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);

395: OKC_DEBUG.log('400: Exiting task_alert...', 2);
396: OKC_DEBUG.Reset_Indentation;
397: END IF;
398: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);
399: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);
400:
401: EXCEPTION
402: WHEN OKC_API.G_EXCEPTION_ERROR THEN
403: IF (l_debug = 'Y') THEN

Line 407: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

403: IF (l_debug = 'Y') THEN
404: OKC_DEBUG.log(' 400:Exception Error in task_alert...', 2);
405: OKC_DEBUG.Reset_Indentation;
406: END IF;
407: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
408:
409: retcode := 2;
410: errbuf := substr(sqlerrm,1,250);
411: g_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 426: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

422: IF (l_debug = 'Y') THEN
423: OKC_DEBUG.log(' 400:Unexcepted Error in task_alert...', 2);
424: OKC_DEBUG.Reset_Indentation;
425: END IF;
426: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
427:
428: retcode := 2;
429: errbuf := substr(sqlerrm,1,250);
430: g_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 445: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

441: IF (l_debug = 'Y') THEN
442: OKC_DEBUG.log(' 400:Other Exception Error in task_alert...', 2);
443: OKC_DEBUG.Reset_Indentation;
444: END IF;
445: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
446:
447: retcode := 2;
448: errbuf := substr(sqlerrm,1,250);
449: g_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 810: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

806: IF (l_debug = 'Y') THEN
807: OKC_DEBUG.log(' 400:Exception Error in task_alert...', 2);
808: OKC_DEBUG.Reset_Indentation;
809: END IF;
810: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
811: get_fnd_msg_stack(' Exception Error in task_alert is '||g_msg_data);
812:
813: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
814: IF (l_debug = 'Y') THEN

Line 818: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

814: IF (l_debug = 'Y') THEN
815: OKC_DEBUG.log(' 400:Unexcepted Error in task_alert...', 2);
816: OKC_DEBUG.Reset_Indentation;
817: END IF;
818: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
819: get_fnd_msg_stack(' Unexpected error in task_alert is '||g_msg_data);
820:
821: WHEN OTHERS THEN
822: IF (l_debug = 'Y') THEN

Line 826: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

822: IF (l_debug = 'Y') THEN
823: OKC_DEBUG.log(' 400:Other Exception Error in task_alert...', 2);
824: OKC_DEBUG.Reset_Indentation;
825: END IF;
826: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
827:
828: retcode := 2;
829: FND_FILE.PUT_LINE( FND_FILE.LOG,substr(sqlerrm,1,250));
830:

Line 829: FND_FILE.PUT_LINE( FND_FILE.LOG,substr(sqlerrm,1,250));

825: END IF;
826: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
827:
828: retcode := 2;
829: FND_FILE.PUT_LINE( FND_FILE.LOG,substr(sqlerrm,1,250));
830:
831: get_fnd_msg_stack(' Other Exception Error in task_alert is '||g_msg_data);
832: exit;
833: END;

Line 841: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);

837: IF (l_debug = 'Y') THEN
838: OKC_DEBUG.log('900: Exiting task_task_escalation1...', 2);
839: OKC_DEBUG.Reset_Indentation;
840: END IF;
841: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);
842: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);
843:
844: EXCEPTION
845: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 842: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);

838: OKC_DEBUG.log('900: Exiting task_task_escalation1...', 2);
839: OKC_DEBUG.Reset_Indentation;
840: END IF;
841: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);
842: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);
843:
844: EXCEPTION
845: WHEN OKC_API.G_EXCEPTION_ERROR THEN
846: IF (l_debug = 'Y') THEN

Line 850: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

846: IF (l_debug = 'Y') THEN
847: OKC_DEBUG.log(' 900:Exception Error in task_escalation1...', 2);
848: OKC_DEBUG.Reset_Indentation;
849: END IF;
850: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
851:
852: retcode := 2;
853: errbuf := substr(sqlerrm,1,250);
854: g_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 869: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

865: IF (l_debug = 'Y') THEN
866: OKC_DEBUG.log(' 900:Unexcepted Error in task_escalation1...', 2);
867: OKC_DEBUG.Reset_Indentation;
868: END IF;
869: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
870:
871: retcode := 2;
872: errbuf := substr(sqlerrm,1,250);
873: g_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 888: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

884: IF (l_debug = 'Y') THEN
885: OKC_DEBUG.log(' 900:Other Exception Error in task_escalation1...', 2);
886: OKC_DEBUG.Reset_Indentation;
887: END IF;
888: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
889:
890: retcode := 2;
891: errbuf := substr(sqlerrm,1,250);
892: g_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1240: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

1236: IF (l_debug = 'Y') THEN
1237: OKC_DEBUG.log(' 400:Exception Error in task_alert...', 2);
1238: OKC_DEBUG.Reset_Indentation;
1239: END IF;
1240: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
1241: get_fnd_msg_stack(' Exception Error in task_alert is '||g_msg_data);
1242:
1243: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1244: IF (l_debug = 'Y') THEN

Line 1248: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

1244: IF (l_debug = 'Y') THEN
1245: OKC_DEBUG.log(' 400:Unexcepted Error in task_alert...', 2);
1246: OKC_DEBUG.Reset_Indentation;
1247: END IF;
1248: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
1249: get_fnd_msg_stack(' Unexpected error in task_alert is '||g_msg_data);
1250:
1251: WHEN OTHERS THEN
1252: IF (l_debug = 'Y') THEN

Line 1256: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);

1252: IF (l_debug = 'Y') THEN
1253: OKC_DEBUG.log(' 400:Other Exception Error in task_alert...', 2);
1254: OKC_DEBUG.Reset_Indentation;
1255: END IF;
1256: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
1257:
1258: retcode := 2;
1259: FND_FILE.PUT_LINE( FND_FILE.LOG,substr(sqlerrm,1,250));
1260: exit;

Line 1259: FND_FILE.PUT_LINE( FND_FILE.LOG,substr(sqlerrm,1,250));

1255: END IF;
1256: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_number);
1257:
1258: retcode := 2;
1259: FND_FILE.PUT_LINE( FND_FILE.LOG,substr(sqlerrm,1,250));
1260: exit;
1261: END;
1262: END LOOP;
1263: OKC_API.END_ACTIVITY(g_msg_count, g_msg_data);

Line 1269: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);

1265: IF (l_debug = 'Y') THEN
1266: OKC_DEBUG.log('4000: Exiting task_task_escalation2...', 2);
1267: OKC_DEBUG.Reset_Indentation;
1268: END IF;
1269: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);
1270: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);
1271:
1272: EXCEPTION
1273: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1270: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);

1266: OKC_DEBUG.log('4000: Exiting task_task_escalation2...', 2);
1267: OKC_DEBUG.Reset_Indentation;
1268: END IF;
1269: FND_FILE.PUT_LINE( FND_FILE.LOG,'Success Count:'||l_success_count);
1270: FND_FILE.PUT_LINE( FND_FILE.LOG,'Failure Count:'||l_failure_count);
1271:
1272: EXCEPTION
1273: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1274: IF (l_debug = 'Y') THEN

Line 1278: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_name);

1274: IF (l_debug = 'Y') THEN
1275: OKC_DEBUG.log(' 4000:Exception Error in task_escalation2...', 2);
1276: OKC_DEBUG.Reset_Indentation;
1277: END IF;
1278: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_name);
1279: retcode := 2;
1280: errbuf := substr(sqlerrm,1,250);
1281: g_return_status := OKC_API.HANDLE_EXCEPTIONS
1282: (l_api_name,

Line 1296: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_name);

1292: IF (l_debug = 'Y') THEN
1293: OKC_DEBUG.log(' 4000:Unexcepted Error in task_escalation2...', 2);
1294: OKC_DEBUG.Reset_Indentation;
1295: END IF;
1296: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_name);
1297:
1298: retcode := 2;
1299: errbuf := substr(sqlerrm,1,250);
1300: g_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 1315: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_name);

1311: IF (l_debug = 'Y') THEN
1312: OKC_DEBUG.log(' 4000:Other Exception Error in task_escalation2...', 2);
1313: OKC_DEBUG.Reset_Indentation;
1314: END IF;
1315: FND_FILE.PUT_LINE( FND_FILE.LOG,'Task:'||l_task_name);
1316:
1317: retcode := 2;
1318: errbuf := substr(sqlerrm,1,250);
1319: g_return_status := OKC_API.HANDLE_EXCEPTIONS