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.OTA_ILEARNING dependencies on HR_UTILITY

Line 198: hr_utility.clear_message;

194: -- Create activity_version
195:
196: BEGIN
197: -- clear message before calling API
198: hr_utility.clear_message;
199: /* change for eBS
200: ota_tav_ins.Ins
201: (
202: P_activity_version_id => l_activity_version_id -- (Output)

Line 236: p_activity_version_name || '. Reason:' || hr_utility.get_message);

232: /* change for eBS
233: EXCEPTION
234: when others then
235: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create an Activity Version for RCO '||
236: p_activity_version_name || '. Reason:' || hr_utility.get_message);
237: p_message := 'Error in creating Activity_version found corresponding to ';
238: -- dbms_output.put_line(p_message);
239: p_activity_version_id := NULL;
240: -- p_status := 'F';

Line 271: hr_utility.clear_message;

267:
268: --- update activity_version
269: BEGIN
270: -- clear message before calling API
271: hr_utility.clear_message;
272:
273: ota_tav_upd.Upd
274: (
275: P_activity_version_id => l_activity_version_id -- (Input)

Line 306: p_activity_version_name || '. Reason:' || hr_utility.get_message);

302:
303: EXCEPTION
304: when others then
305: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Activity Version for RCO '||
306: p_activity_version_name || '. Reason:' || hr_utility.get_message);
307: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Activity version for rco_id - ' ||
308: -- p_rco_id || '. REASON:' || hr_utility.get_message);
309: p_message := 'updated successfully ';
310: -- dbms_output.put_line(p_message);

Line 308: -- p_rco_id || '. REASON:' || hr_utility.get_message);

304: when others then
305: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Activity Version for RCO '||
306: p_activity_version_name || '. Reason:' || hr_utility.get_message);
307: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Activity version for rco_id - ' ||
308: -- p_rco_id || '. REASON:' || hr_utility.get_message);
309: p_message := 'updated successfully ';
310: -- dbms_output.put_line(p_message);
311: -- p_status := 'F';
312: p_status := 'W';

Line 325: hr_utility.clear_message;

321: for cur_evt in cur_get_event_id
322: LOOP
323: BEGIN
324: -- clear message before calling API
325: hr_utility.clear_message;
326:
327: OTA_EVT_UPD.UPD
328: (
329: P_EVENT_ID => cur_evt.event_id -- (Input)

Line 345: cur_evt.event_id || '. Reason:' || hr_utility.get_message);

341: -- dbms_output.put_line(p_message);
342: EXCEPTION
343: when others then
344: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the language ID for Event ID '||
345: cur_evt.event_id || '. Reason:' || hr_utility.get_message);
346: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Event.Event id is - '|| cur_evt.event_id ||
347: -- ' for Language id - ' || l2_language_id || '. REASON:' || hr_utility.get_message);
348: p_message := 'ERROR:In updating Event.Event id is -'||cur_evt.event_id||
349: ' for Language id - '||l2_language_id;

Line 347: -- ' for Language id - ' || l2_language_id || '. REASON:' || hr_utility.get_message);

343: when others then
344: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the language ID for Event ID '||
345: cur_evt.event_id || '. Reason:' || hr_utility.get_message);
346: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Event.Event id is - '|| cur_evt.event_id ||
347: -- ' for Language id - ' || l2_language_id || '. REASON:' || hr_utility.get_message);
348: p_message := 'ERROR:In updating Event.Event id is -'||cur_evt.event_id||
349: ' for Language id - '||l2_language_id;
350: -- dbms_output.put_line(p_message);
351: -- p_status := 'F';

Line 405: hr_utility.clear_message;

401:
402: --- update activity_version
403: BEGIN
404: -- clear message before calling API
405: hr_utility.clear_message;
406:
407: ota_tav_upd.Upd
408: (
409: P_activity_version_id => l_activity_version_id -- (Input)

Line 441: p_activity_version_name || '. Reason:' || hr_utility.get_message);

437:
438: EXCEPTION
439: when others then
440: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Activity Version for RCO '||
441: p_activity_version_name || '. Reason:' || hr_utility.get_message);
442: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Activity version for rco_id - ' ||
443: -- p_rco_id || '.REASON:' || hr_utility.get_message);
444: p_message := 'ERROR:In updating Activity version for rco_id - ' || p_rco_id;
445: -- dbms_output.put_line(p_message);

Line 443: -- p_rco_id || '.REASON:' || hr_utility.get_message);

439: when others then
440: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Activity Version for RCO '||
441: p_activity_version_name || '. Reason:' || hr_utility.get_message);
442: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Activity version for rco_id - ' ||
443: -- p_rco_id || '.REASON:' || hr_utility.get_message);
444: p_message := 'ERROR:In updating Activity version for rco_id - ' || p_rco_id;
445: -- dbms_output.put_line(p_message);
446: -- p_status := 'F';
447: p_status := 'W';

Line 459: hr_utility.clear_message;

455: for cur_evt in cur_get_event_id
456: LOOP
457: BEGIN
458: -- clear message before calling API
459: hr_utility.clear_message;
460:
461: OTA_EVT_UPD.UPD
462: (
463: P_EVENT_ID => cur_evt.event_id -- (Input)

Line 479: cur_evt.event_id || '. Reason:' || hr_utility.get_message);

475: -- dbms_output.put_line(p_message);
476: EXCEPTION
477: when others then
478: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the language ID for Event ID '||
479: cur_evt.event_id || '. Reason:' || hr_utility.get_message);
480: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Event.Event id is - '|| cur_evt.event_id ||
481: -- ' for Language id - ' || l2_language_id || '. REASON:' || hr_utility.get_message);
482: p_message := 'ERROR:In updating Event.Event id is -'||cur_evt.event_id||
483: ' for Language id - '||l2_language_id;

Line 481: -- ' for Language id - ' || l2_language_id || '. REASON:' || hr_utility.get_message);

477: when others then
478: fND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the language ID for Event ID '||
479: cur_evt.event_id || '. Reason:' || hr_utility.get_message);
480: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:In updating Event.Event id is - '|| cur_evt.event_id ||
481: -- ' for Language id - ' || l2_language_id || '. REASON:' || hr_utility.get_message);
482: p_message := 'ERROR:In updating Event.Event id is -'||cur_evt.event_id||
483: ' for Language id - '||l2_language_id;
484: -- dbms_output.put_line(p_message);
485: -- p_status := 'F';

Line 834: hr_utility.clear_message;

830: close cur_get_cat_usage_id;
831:
832: BEGIN
833: -- clear message before calling API
834: hr_utility.clear_message;
835:
836: ota_ctu_ins.ins
837: (
838: p_category_usage_id => l_category_usage_id --(Output)

Line 864: || '. Reason:' || hr_utility.get_message);

860: EXCEPTION
861: when others then
862:
863: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create the Delivery Method for Category ' || l_category
864: || '. Reason:' || hr_utility.get_message);
865:
866: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category usage for category - '||
867: -- l_category || '. REASON:' || hr_utility.get_message);
868: p_message := 'ERROR:Unable to create category usage for category - '|| l_category;

Line 867: -- l_category || '. REASON:' || hr_utility.get_message);

863: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create the Delivery Method for Category ' || l_category
864: || '. Reason:' || hr_utility.get_message);
865:
866: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category usage for category - '||
867: -- l_category || '. REASON:' || hr_utility.get_message);
868: p_message := 'ERROR:Unable to create category usage for category - '|| l_category;
869: -- dbms_output.put_line(p_message);
870: -- p_status := 'F';
871: p_status := 'W';

Line 895: hr_utility.clear_message;

891: -- create category inclusions
892:
893: BEGIN
894: -- clear message before calling API
895: hr_utility.clear_message;
896: /* OTA_ACI_API.INS
897: (
898: p_activity_version_id => p_activity_version_id -- (Input)
899: ,p_activity_category => l_category -- (Input)

Line 928: p_activity_version_id || '. Reason:' || hr_utility.get_message);

924:
925: EXCEPTION
926: when others then
927: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not include Delivery Method in Activity Version ID '||
928: p_activity_version_id || '. Reason:' || hr_utility.get_message);
929: p_message := 'ERROR:Unable to create category inclusion for category usage id - '|| l_category_usage_id;
930: -- dbms_output.put_line(p_message);
931: -- dbms_output.put_line('p_activity_version_id - ' || p_activity_version_id);
932: -- dbms_output.put_line('l_category - ' || l_category);

Line 951: hr_utility.clear_message;

947: if l_activity_start_date > l_course_start_date then --if event start date is earlier then activity start date
948:
949: BEGIN
950: -- clear message before calling API
951: hr_utility.clear_message;
952: -- Bug#2201416 trunc included for l_course_start_date parameter.
953: ota_tav_upd.Upd
954: (
955: p_activity_version_id => p_activity_version_id -- (Input)

Line 965: p_activity_version_id || '. REASON:' || hr_utility.get_message);

961:
962: EXCEPTION
963: when others then
964: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Activity Start Date for Activity Version ID '||
965: p_activity_version_id || '. REASON:' || hr_utility.get_message);
966: p_message := 'ERROR:Unable to update Activity start date for activity_version_id - '||
967: p_activity_version_id || ' And offering Id - ' ||p_offering_id;
968: -- dbms_output.put_line(p_message);
969: -- p_status := 'F';

Line 981: hr_utility.clear_message;

977: -- Create Event
978:
979: BEGIN
980: -- clear message before calling API
981: hr_utility.clear_message;
982: /* change for eBS
983: OTA_EVT_INS.INS
984: (
985: P_EVENT_ID => l_event_id -- (Output)

Line 1033: || '. Reason:' || hr_utility.get_message);

1029: /*
1030: EXCEPTION
1031: when others then
1032: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create an Event for the Offering '|| p_offering_title
1033: || '. Reason:' || hr_utility.get_message);
1034: p_message := 'ERROR:Unable to create Event for Offering id - '||p_offering_id;
1035:
1036: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'l_event_id -' || l_event_id);
1037: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'p_business_group_id - ' || p_business_group_id);

Line 1125: hr_utility.clear_message;

1121: close cur_get_cat_usage_id;
1122:
1123: BEGIN
1124: -- clear message before calling API
1125: hr_utility.clear_message;
1126:
1127: ota_ctu_ins.ins
1128: (
1129: p_category_usage_id => l_category_usage_id --(Output)

Line 1157: || '. Reason:' || hr_utility.get_message);

1153:
1154: EXCEPTION
1155: when others then
1156: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create the Delivery Method for Category ' || l_category
1157: || '. Reason:' || hr_utility.get_message);
1158: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category usage for category - '||
1159: -- l_category || '. REASON:' || hr_utility.get_message);
1160: p_message := 'ERROR:Unable to create category usage for category - '|| l_category;
1161: -- dbms_output.put_line(p_message);

Line 1159: -- l_category || '. REASON:' || hr_utility.get_message);

1155: when others then
1156: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not create the Delivery Method for Category ' || l_category
1157: || '. Reason:' || hr_utility.get_message);
1158: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category usage for category - '||
1159: -- l_category || '. REASON:' || hr_utility.get_message);
1160: p_message := 'ERROR:Unable to create category usage for category - '|| l_category;
1161: -- dbms_output.put_line(p_message);
1162: -- p_status := 'F';
1163: p_status := 'W';

Line 1187: hr_utility.clear_message;

1183: -- create category inclusions
1184:
1185: BEGIN
1186: -- clear message before calling API
1187: hr_utility.clear_message;
1188: /* OTA_ACI_API.INS
1189: (
1190: p_activity_version_id => p_activity_version_id -- (Input)
1191: ,p_activity_category => l_category -- (Input)

Line 1222: p_activity_version_id || '. Reason:' || hr_utility.get_message);

1218:
1219: EXCEPTION
1220: when others then
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not include Delivery Method in Activity Version ID '||
1222: p_activity_version_id || '. Reason:' || hr_utility.get_message);
1223: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category inclusion for category usage id- '||
1224: -- l_category_usage_id || '. REASON:' || hr_utility.get_message);
1225: p_message := 'ERROR:Unable to create category inclusion for category usage id - '|| l_category_usage_id;
1226: -- dbms_output.put_line(p_message);

Line 1224: -- l_category_usage_id || '. REASON:' || hr_utility.get_message);

1220: when others then
1221: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not include Delivery Method in Activity Version ID '||
1222: p_activity_version_id || '. Reason:' || hr_utility.get_message);
1223: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to create category inclusion for category usage id- '||
1224: -- l_category_usage_id || '. REASON:' || hr_utility.get_message);
1225: p_message := 'ERROR:Unable to create category inclusion for category usage id - '|| l_category_usage_id;
1226: -- dbms_output.put_line(p_message);
1227: -- dbms_output.put_line('p_activity_version_id - ' || p_activity_version_id);
1228: -- dbms_output.put_line('l_category - ' || l_category);

Line 1248: hr_utility.clear_message;

1244: if l_activity_start_date > l_course_start_date then --if event start date is earlier then activity start date
1245:
1246: BEGIN
1247: -- clear message before calling API
1248: hr_utility.clear_message;
1249: -- Bug#2201416 trunc included for l_course_start_date parameter.
1250: ota_tav_upd.Upd
1251: (
1252: p_activity_version_id => p_activity_version_id -- (Input)

Line 1261: p_activity_version_id || '. REASON:' || hr_utility.get_message);

1257: );
1258: EXCEPTION
1259: when others then
1260: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Activity Start Date for Activity Version ID '||
1261: p_activity_version_id || '. REASON:' || hr_utility.get_message);
1262: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to update Activity start date for activity_version_id - '||
1263: -- p_activity_version_id || ' And offering Id - ' ||p_offering_id
1264: -- || '. REASON:' || hr_utility.get_message);
1265: p_message := 'ERROR:Unable to update Activity start date for activity_version_id - '||

Line 1264: -- || '. REASON:' || hr_utility.get_message);

1260: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update Activity Start Date for Activity Version ID '||
1261: p_activity_version_id || '. REASON:' || hr_utility.get_message);
1262: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ERROR:Unable to update Activity start date for activity_version_id - '||
1263: -- p_activity_version_id || ' And offering Id - ' ||p_offering_id
1264: -- || '. REASON:' || hr_utility.get_message);
1265: p_message := 'ERROR:Unable to update Activity start date for activity_version_id - '||
1266: p_activity_version_id || ' And offering Id - ' ||p_offering_id;
1267: -- dbms_output.put_line(p_message);
1268: -- p_status := 'F';

Line 1438: hr_utility.clear_message;

1434: -- Update event
1435:
1436: BEGIN
1437: -- clear message before calling API
1438: hr_utility.clear_message;
1439:
1440: OTA_EVT_UPD.UPD
1441: (
1442: P_EVENT_ID => l_event_id -- (Input)

Line 1482: '. Reason:' || hr_utility.get_message);

1478:
1479: EXCEPTION
1480: when others then
1481: FND_FILE.PUT_LINE(FND_FILE.LOG,'The application could not update the Event '|| p_offering_title ||
1482: '. Reason:' || hr_utility.get_message);
1483: p_message := 'ERROR:Unable to update Event.Event id is -'||l_event_id||' for Offering id - '||p_offering_id;
1484: -- dbms_output.put_line(p_message);
1485: -- dbms_output.put_line(l_event_id);
1486: -- dbms_output.put_line(p_business_group_id);