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 1377: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1836:
1837:
1838:
1839: begin
1840: hr_utility.set_location('Entering:'||l_proc, 5);
1841:
1842: open get_message_details;
1843: fetch get_message_details into l_forum_name,l_subject, l_person_id,l_contact_id,
1844: l_creation_date, l_message_body;

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

1875: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
1876:
1877: end loop;
1878:
1879: hr_utility.set_location('Leaving:'||l_proc, 10);
1880:
1881: end init_forum_notif;
1882:
1883:

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

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

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

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