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_INITIALIZATION_WF dependencies on HR_UTILITY

Line 97: hr_utility.set_location('Entering:'||l_proc, 5);

93:
94: l_proc varchar2(72) := g_package||'initialize_cancel_enrollment';
95:
96: BEGIN
97: hr_utility.set_location('Entering:'||l_proc, 5);
98:
99: OPEN C_ORDER;
100: FETCH C_ORDER INTO l_order_number,l_header_id;
101: CLOSE C_ORDER;

Line 102: hr_utility.set_location('Entering:'||l_proc, 10);

98:
99: OPEN C_ORDER;
100: FETCH C_ORDER INTO l_order_number,l_header_id;
101: CLOSE C_ORDER;
102: hr_utility.set_location('Entering:'||l_proc, 10);
103: OPEN c_event;
104: FETCH c_event INTO l_event_title,l_owner_id;
105: CLOSE c_event;
106: hr_utility.set_location('Entering:'||l_proc, 15);

Line 106: hr_utility.set_location('Entering:'||l_proc, 15);

102: hr_utility.set_location('Entering:'||l_proc, 10);
103: OPEN c_event;
104: FETCH c_event INTO l_event_title,l_owner_id;
105: CLOSE c_event;
106: hr_utility.set_location('Entering:'||l_proc, 15);
107:
108: /* OPEN c_person;
109: FETCH c_person INTO l_full_name,l_email_address;
110: CLOSE c_person;*/

Line 111: hr_utility.set_location('Entering:'||l_proc, 20);

107:
108: /* OPEN c_person;
109: FETCH c_person INTO l_full_name,l_email_address;
110: CLOSE c_person;*/
111: hr_utility.set_location('Entering:'||l_proc, 20);
112:
113: WF_ENGINE.CREATEPROCESS(p_itemtype, l_itemkey, 'OTA_ENR_CANCEL' );
114: -- WF_ENGINE.setitemattrnumber(p_itemtype, l_itemkey,'BOOKING_ID', p_booking_id);
115: WF_ENGINE.setitemattrtext(p_itemtype, l_itemkey,'EVENT_TITLE', l_Event_title);

Line 123: hr_utility.set_location('Leaving:'||l_proc, 25);

119: WF_ENGINE.SetItemattrnumber(p_itemtype,l_itemkey,'ORG_ID',p_org_id);
120:
121: -- WF_ENGINE.SetItemattrtext(p_itemtype,l_itemkey,'FULL_NAME',l_full_name);
122: WF_ENGINE.STARTPROCESS(p_itemtype,l_itemkey);
123: hr_utility.set_location('Leaving:'||l_proc, 25);
124:
125: EXCEPTION
126: WHEN OTHERS THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 225: hr_utility.set_location('Entering:'||l_proc, 5);

221: l_item_key wf_items.item_key%TYPE;
222: l_line_number oe_order_lines_all.line_number%type;
223:
224: BEGIN
225: hr_utility.set_location('Entering:'||l_proc, 5);
226:
227: OPEN C_ORDER;
228: FETCH C_ORDER INTO l_order_number,l_header_id;
229: CLOSE C_ORDER;

Line 230: hr_utility.set_location('Entering:'||l_proc, 15);

226:
227: OPEN C_ORDER;
228: FETCH C_ORDER INTO l_order_number,l_header_id;
229: CLOSE C_ORDER;
230: hr_utility.set_location('Entering:'||l_proc, 15);
231: OPEN C_PEOPLE;
232: FETCH c_people INTO l_user_name;
233: CLOSE c_people;
234: hr_utility.set_location('Entering:'||l_proc, 17);

Line 234: hr_utility.set_location('Entering:'||l_proc, 17);

230: hr_utility.set_location('Entering:'||l_proc, 15);
231: OPEN C_PEOPLE;
232: FETCH c_people INTO l_user_name;
233: CLOSE c_people;
234: hr_utility.set_location('Entering:'||l_proc, 17);
235: SELECT to_char(sysdate, 'DD-MON-YYYY:HH24:MI:SS')
236: INTO l_wf_date
237: FROM dual;
238: --Bug#2587983 get line number

Line 257: hr_utility.set_location('Leaving:'||l_proc, 20);

253:
254: EXCEPTION
255: WHEN OTHERS THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: hr_utility.set_location('Leaving:'||l_proc, 20);
258:
259: END;
260:
261:

Line 391: hr_utility.set_location('Entering:'||l_proc, 5);

387:
388: l_proc varchar2(72) := g_package||'initialize_cancel_order';
389:
390: BEGIN
391: hr_utility.set_location('Entering:'||l_proc, 5);
392:
393: OPEN C_ORDER;
394: FETCH C_ORDER INTO l_order_number,l_header_id;
395: CLOSE C_ORDER;

Line 396: hr_utility.set_location('Entering:'||l_proc, 10);

392:
393: OPEN C_ORDER;
394: FETCH C_ORDER INTO l_order_number,l_header_id;
395: CLOSE C_ORDER;
396: hr_utility.set_location('Entering:'||l_proc, 10);
397:
398: --Bug#2587983 get line number
399: OPEN C_ORDER_LINE;
400: FETCH C_ORDER_LINE into l_line_number;

Line 416: hr_utility.set_location('leaving:'||l_proc, 20);

412:
413: EXCEPTION
414: WHEN OTHERS THEN
415: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
416: hr_utility.set_location('leaving:'||l_proc, 20);
417:
418: END;
419:
420:

Line 468: hr_utility.set_location('Entering:'||l_proc, 5);

464: l_proc varchar2(72) := g_package||'manual_waitlist';
465: l_process wf_activities.name%type := upper(p_process);
466:
467: BEGIN
468: hr_utility.set_location('Entering:'||l_proc, 5);
469:
470:
471: hr_utility.set_location('Entering:'||l_proc, 10);
472:

Line 471: hr_utility.set_location('Entering:'||l_proc, 10);

467: BEGIN
468: hr_utility.set_location('Entering:'||l_proc, 5);
469:
470:
471: hr_utility.set_location('Entering:'||l_proc, 10);
472:
473: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);
474: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_id); --Enh 5606090: Language support for Event Details.
475: WF_ENGINE.SetItemattrtext(p_itemtype, p_item_key,'EVENT_OWNER',p_user_name);

Line 481: hr_utility.set_location('leaving:'||l_proc, 20);

477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
481: hr_utility.set_location('leaving:'||l_proc, 20);
482:
483: END;
484:
485: -- ----------------------------------------------------------------------------

Line 541: hr_utility.set_location('Entering:'||l_proc, 5);

537: Employee_id = p_owner_id
538: AND trunc(sysdate) between start_date and nvl(end_date,to_date('4712/12/31', 'YYYY/MM/DD')); --Bug 5676892
539:
540: BEGIN
541: hr_utility.set_location('Entering:'||l_proc, 5);
542:
543: OPEN C_USER;
544: FETCH C_USER INTO l_user_name;
545: CLOSE C_USER;

Line 547: hr_utility.set_location('Entering:'||l_proc, 10);

543: OPEN C_USER;
544: FETCH C_USER INTO l_user_name;
545: CLOSE C_USER;
546:
547: hr_utility.set_location('Entering:'||l_proc, 10);
548:
549: WF_ENGINE.CREATEPROCESS(p_itemtype, p_item_key, l_process);
550: WF_ENGINE.setitemattrtext(p_itemtype, p_item_key, 'EVENT_TITLE', p_event_title);
551: WF_ENGINE.SetItemattrtext(p_itemtype,p_item_key, 'EVENT_OWNER',l_user_name);

Line 557: hr_utility.set_location('leaving:'||l_proc, 20);

553:
554: EXCEPTION
555: WHEN OTHERS THEN
556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
557: hr_utility.set_location('leaving:'||l_proc, 20);
558:
559: END;
560:
561: Procedure set_addnl_attributes(p_item_type in wf_items.item_type%type,

Line 749: hr_utility.set_location('Entering:'||l_proc, 5);

745:
746: resource_rec get_resource_info%ROWTYPE;
747:
748: begin
749: hr_utility.set_location('Entering:'||l_proc, 5);
750:
751: open get_event_info;
752: fetch get_event_info into l_title,l_start_date,l_end_date,l_start_time,
753: l_end_time,l_location_id,l_event_type,l_timezone;

Line 756: hr_utility.trace ('after get_event_info ' ||l_title);

752: fetch get_event_info into l_title,l_start_date,l_end_date,l_start_time,
753: l_end_time,l_location_id,l_event_type,l_timezone;
754: close get_event_info;
755:
756: hr_utility.trace ('after get_event_info ' ||l_title);
757:
758: -- get location
759: l_location_name := ota_general.get_Location_code(l_location_id);
760:

Line 772: hr_utility.trace ('after Createprocess ' ||l_item_key);

768:
769: -- get item key for the process
770: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
771:
772: hr_utility.trace ('after Createprocess ' ||l_item_key);
773:
774:
775: -- set creator,current and supervisor name
776: set_wf_item_attr(p_person_id => p_person_id,

Line 824: hr_utility.trace ('Before Createprocess ' ||resource_rec.trainer_id );

820: select hr_workflow_item_key_s.nextval
821: into l_item_key
822: from sys.dual;
823:
824: hr_utility.trace ('Before Createprocess ' ||resource_rec.trainer_id );
825: -- get item key for the process
826: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
827:
828: hr_utility.trace ('after Createprocess ' ||l_item_key);

Line 828: hr_utility.trace ('after Createprocess ' ||l_item_key);

824: hr_utility.trace ('Before Createprocess ' ||resource_rec.trainer_id );
825: -- get item key for the process
826: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
827:
828: hr_utility.trace ('after Createprocess ' ||l_item_key);
829:
830: set_wf_item_attr(p_person_id => resource_rec.trainer_id,
831: p_item_type => p_item_type,
832: p_item_key => l_item_key);

Line 872: hr_utility.trace ('Before Createprocess ' ||rec.trainer_id);

868: select hr_workflow_item_key_s.nextval
869: into l_item_key
870: from sys.dual;
871:
872: hr_utility.trace ('Before Createprocess ' ||rec.trainer_id);
873: -- get item key for the process
874: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
875:
876: hr_utility.trace ('after Createprocess ' ||l_item_key);

Line 876: hr_utility.trace ('after Createprocess ' ||l_item_key);

872: hr_utility.trace ('Before Createprocess ' ||rec.trainer_id);
873: -- get item key for the process
874: WF_ENGINE.CREATEPROCESS(p_item_type, l_item_key, l_process);
875:
876: hr_utility.trace ('after Createprocess ' ||l_item_key);
877:
878:
879: /*
880: open get_resource_info;

Line 935: hr_utility.set_location('Leaving:'||l_proc, 5);

931: WF_ENGINE.STARTPROCESS(p_item_type,l_item_key);
932: end loop;
933:
934: end if;
935: hr_utility.set_location('Leaving:'||l_proc, 5);
936:
937: end Initialize_instructor_wf;
938:
939: Procedure Initialize_wf(p_process in wf_process_activities.process_name%type,

Line 999: hr_utility.set_location('Entering:'||l_proc, 5);

995: and odb.booking_status_type_id = bst.booking_status_type_id;
996:
997:
998: begin
999: hr_utility.set_location('Entering:'||l_proc, 5);
1000:
1001: open get_event_info;
1002: fetch get_event_info into l_title,l_start_date,l_end_date,l_start_time,
1003: l_end_time,l_location_id;

Line 1097: hr_utility.set_location('Leaving:'||l_proc, 5);

1093:
1094: end loop;
1095:
1096: end if;
1097: hr_utility.set_location('Leaving:'||l_proc, 5);
1098:
1099: end initialize_wf;
1100:
1101:

Line 1158: hr_utility.set_location('Entering:'||l_proc, 5);

1154: and orb.event_id is not null;*/
1155:
1156:
1157: begin
1158: hr_utility.set_location('Entering:'||l_proc, 5);
1159: fnd_file.put_line(FND_FILE.LOG,'Event Fired ' ||p_event_fired);
1160:
1161: if p_event_fired ='CLASS_START' then
1162: --this code would be called when classbeginning notification has to be fired

Line 1212: hr_utility.set_location('Leaving:'||l_proc, 5);

1208: end loop;
1209: end if;
1210:
1211:
1212: hr_utility.set_location('Leaving:'||l_proc, 5);
1213: end Initialize_auto_wf;
1214:
1215: Procedure Init_LP_wf(p_item_type in wf_items.item_type%type,
1216: p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type,

Line 1279: hr_utility.set_location('ENTERING get_event_fired', 10);

1275: is
1276: l_value varchar2(100);
1277:
1278: begin
1279: hr_utility.set_location('ENTERING get_event_fired', 10);
1280: IF (funcmode='RUN') THEN
1281:
1282: l_value := wf_engine.getItemAttrText(itemtype => itemtype
1283: ,itemkey => itemkey

Line 1285: hr_utility.trace ('l_value ' ||l_value);

1281:
1282: l_value := wf_engine.getItemAttrText(itemtype => itemtype
1283: ,itemkey => itemkey
1284: , aname => 'OTA_NTF_EVENT_FIRED');
1285: hr_utility.trace ('l_value ' ||l_value);
1286: if l_value is not null then
1287:
1288: resultout:='COMPLETE:' || l_value;
1289:

Line 1293: hr_utility.trace ('resultout ' ||resultout);

1289:
1290: else
1291: resultout:='COMPLETE';
1292: end if;
1293: hr_utility.trace ('resultout ' ||resultout);
1294: RETURN;
1295: end if;
1296: IF (funcmode='CANCEL') THEN
1297: resultout:='COMPLETE';

Line 1379: hr_utility.set_location('Entering:'||l_proc, 5);

1375:
1376:
1377:
1378: begin
1379: hr_utility.set_location('Entering:'||l_proc, 5);
1380:
1381: OPEN curr_per_info;
1382: FETCH curr_per_info INTO l_current_user_id, l_current_username;
1383: CLOSE curr_per_info;

Line 1395: hr_utility.trace ('Current username ' ||l_current_username);

1391:
1392: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CURRENT_PERSON_USERNAME', l_current_username);
1393: WF_ENGINE.setitemattrtext(p_item_type, p_item_key, 'CREATOR_PERSON_USERNAME', l_creator_username);
1394:
1395: hr_utility.trace ('Current username ' ||l_current_username);
1396:
1397: open csr_person_name(l_creator_person_id);
1398: fetch csr_person_name into l_creator_full_name;
1399: close csr_person_name;

Line 1447: hr_utility.set_location('after supervisor cursor'||l_proc, 20);

1443: FOR b IN csr_supervisor_user LOOP
1444: l_supervisor_username := b.user_name;
1445: END LOOP;
1446:
1447: hr_utility.set_location('after supervisor cursor'||l_proc, 20);
1448:
1449:
1450: wf_engine.setitemattrtext
1451: (p_item_type,

Line 1455: hr_utility.set_location('after supervisor username'||l_supervisor_username, 20);

1451: (p_item_type,
1452: p_item_key,
1453: 'SUPERVISOR_USERNAME',
1454: l_supervisor_username);
1455: hr_utility.set_location('after supervisor username'||l_supervisor_username, 20);
1456: if p_item_type <> 'OTWF' then
1457: wf_engine.setitemattrtext
1458: (p_item_type,
1459: p_item_key,

Line 1470: hr_utility.set_location('Before Getting Owner'||l_proc, 10);

1466: 'SUPERVISOR_ID',
1467: l_supervisor_id);
1468: end if;
1469:
1470: hr_utility.set_location('Before Getting Owner'||l_proc, 10);
1471:
1472: WF_DIRECTORY.GetRoleName(p_orig_system =>'PER',
1473: p_orig_system_id => p_person_id,
1474: p_name =>l_role_name,

Line 1483: hr_utility.trace ('after setowner ' ||l_role_display_name);

1479: itemtype => p_item_type,
1480: itemkey =>p_item_key,
1481: owner =>l_role_name);
1482:
1483: hr_utility.trace ('after setowner ' ||l_role_display_name);
1484:
1485: hr_utility.set_location('Leaving:'||l_proc, 5);
1486:
1487: end set_wf_item_attr;

Line 1485: hr_utility.set_location('Leaving:'||l_proc, 5);

1481: owner =>l_role_name);
1482:
1483: hr_utility.trace ('after setowner ' ||l_role_display_name);
1484:
1485: hr_utility.set_location('Leaving:'||l_proc, 5);
1486:
1487: end set_wf_item_attr;
1488:
1489: procedure init_assessment_wf(p_person_id in number,

Line 1518: hr_utility.set_location('Entering:'||l_proc, 5);

1514:
1515:
1516:
1517: begin
1518: hr_utility.set_location('Entering:'||l_proc, 5);
1519:
1520: open get_test_info;
1521: fetch get_test_info into l_title,l_score,l_time;
1522: --l_end_time,l_location_id;

Line 1531: hr_utility.trace ('title ' ||l_title);

1527: end if;
1528:
1529: l_format_time := ota_utility.get_test_time(l_time);
1530:
1531: hr_utility.trace ('title ' ||l_title);
1532:
1533: -- Get the next item key from the sequence
1534: select hr_workflow_item_key_s.nextval
1535: into l_item_key

Line 1539: hr_utility.trace ('item key ' ||l_item_key);

1535: into l_item_key
1536: from sys.dual;
1537: -- get item key for the process
1538: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
1539: hr_utility.trace ('item key ' ||l_item_key);
1540: -- set creator,current and supervisor name
1541: set_wf_item_attr(p_person_id => p_person_id,
1542: p_item_type => l_item_type,
1543: p_item_key => l_item_key);

Line 1560: hr_utility.set_location('Leaving:'||l_proc, 5);

1556:
1557: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1558:
1559:
1560: hr_utility.set_location('Leaving:'||l_proc, 5);
1561:
1562: exception
1563: when others then
1564:

Line 1738: hr_utility.set_location('Entering:'||l_proc, 5);

1734: and enr.person_id is not null
1735: and (trunc(sysdate) + nvl(ceb.notify_days_before_expire, 0)) = trunc(ceb.end_date_active);
1736:
1737: begin
1738: hr_utility.set_location('Entering:'||l_proc, 5);
1739:
1740: if p_cert_ntf_type = 'Completion' OR p_cert_ntf_type = 'All' THEN
1741: for prd_enr_rem in get_data_for_reminder_ntf
1742: Loop

Line 1797: hr_utility.set_location('Leaving:'||l_proc, 5);

1793: p_cert_prd_enrollment_id => null,
1794: p_cert_ntf_type => 'CERT_CANCELLATION' );
1795: End Loop;
1796: end if;
1797: hr_utility.set_location('Leaving:'||l_proc, 5);
1798: EXCEPTION
1799: when others then
1800: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
1801: ||','||SUBSTR(SQLERRM, 1, 500));

Line 1844: hr_utility.set_location('Entering:'||l_proc, 5);

1840:
1841:
1842:
1843: begin
1844: hr_utility.set_location('Entering:'||l_proc, 5);
1845:
1846: open get_message_details;
1847: fetch get_message_details into l_forum_name,l_subject, l_person_id,l_contact_id,
1848: l_creation_date, l_message_body;

Line 1883: hr_utility.set_location('Leaving:'||l_proc, 10);

1879: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1880:
1881: end loop;
1882:
1883: hr_utility.set_location('Leaving:'||l_proc, 10);
1884:
1885: end init_forum_notif;
1886:
1887:

Line 1944: hr_utility.set_location('Entering:'||l_proc, 5);

1940: WHERE tdb.booking_id = p_booking_id
1941: AND bst.booking_status_type_id = tdb.booking_status_type_id;
1942:
1943: begin
1944: hr_utility.set_location('Entering:'||l_proc, 5);
1945:
1946: open csr_booking_status;
1947: fetch csr_booking_status into l_status_type,l_person_id, l_contact_id,l_event_id;
1948: close csr_booking_status;

Line 1958: hr_utility.set_location('Leaving:'||l_proc, 10);

1954: wf_engine.setitemattrtext(l_item_type,l_item_key, 'EVENT_ID' ,l_event_id);
1955: wf_engine.setitemattrtext(l_item_type,l_item_key, 'STATUS' ,l_status_type);
1956: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1957:
1958: hr_utility.set_location('Leaving:'||l_proc, 10);
1959:
1960: end init_course_eval_notif;
1961:
1962: procedure get_course_eval_status ( itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,