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

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

127:
128: l_org_id oe_order_lines.org_id%type;
129: BEGIN
130:
131: hr_utility.set_location('Entering:'||l_proc, 5);
132:
133: IF (funcmode = 'RUN') THEN
134:
135: l_header_id := WF_ENGINE.getitemattrnumber(

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

236: wf_core.context('OTA_WF', 'cancel_order',
237: itemtype, itemkey, to_char(actid), funcmode);
238: RAISE;
239:
240: hr_utility.set_location(' Leaving:'||l_proc, 10);
241:
242: END;
243:
244: -- ----------------------------------------------------------------------------

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

364: l_org_id oe_order_lines.org_id%type;
365:
366:
367: BEGIN
368: hr_utility.set_location('Entering:'||l_proc, 5);
369:
370: IF (funcmode = 'RUN') THEN
371:
372: l_header_id := WF_ENGINE.getitemattrnumber(

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

500: wf_core.context('OTA_WF', 'create_rma',
501: itemtype, itemkey, to_char(actid), funcmode);
502: RAISE;
503:
504: hr_utility.set_location(' Leaving:'||l_proc, 10);
505:
506: END;
507:
508:

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

640: FROM OE_ORDER_LINES_ALL
641: WHERE LINE_ID = l_line_id;
642:
643: BEGIN
644: hr_utility.set_location('Entering:'||l_proc, 5);
645:
646: IF (funcmode = 'RUN') THEN
647: OPEN C_ORDER;
648: FETCH C_ORDER INTO l_header_id,l_org_id;

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

759: wf_core.context('OTA_WF', 'update_fulfill_date',
760: itemtype, itemkey, to_char(actid), funcmode);
761: RAISE;
762:
763: hr_utility.set_location(' Leaving:'||l_proc, 10);
764:
765: END;
766:
767: -- ----------------------------------------------------------------------------

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

825: line_id = l_line_id;
826:
827:
828: BEGIN
829: hr_utility.set_location('Entering:'||l_proc, 5);
830:
831: IF (funcmode = 'RUN') THEN
832: OPEN c_invoice;
833: FETCH c_invoice into l_invoice_quantity;

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

871: -- in the case of an exception.
872: wf_core.context('OTA_WF', 'Chk_invoice_exists',
873: itemtype, itemkey, to_char(actid), funcmode);
874: RAISE;
875: hr_utility.set_location(' Leaving:'||l_proc, 10);
876: END;
877:
878: -- ----------------------------------------------------------------------------
879: -- |------------------------------------< CHECK_UOM>-------------------------|

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

960: line_id = l_line_id);*/
961:
962:
963: BEGIN
964: hr_utility.set_location('Entering:'||l_proc, 5);
965: IF (funcmode = 'RUN') THEN
966:
967: OPEN c_uom;
968: FETCH c_uom into l_uom,

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

1007: wf_core.context('OTA_WF', 'Check_UOM',
1008: itemtype, itemkey, to_char(actid), funcmode);
1009: RAISE;
1010:
1011: hr_utility.set_location(' Leaving:'||l_proc, 10);
1012: END;
1013:
1014:
1015:

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

1105: line_id = l_line_id;
1106:
1107:
1108: BEGIN
1109: hr_utility.set_location('Entering:'||l_proc, 5);
1110: IF (funcmode = 'RUN') THEN
1111:
1112: OPEN c_uom;
1113: FETCH c_uom into l_uom;

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

1158: wf_core.context('OTA_WF', 'Check_Creation',
1159: itemtype, itemkey, to_char(actid), funcmode);
1160: RAISE;
1161:
1162: hr_utility.set_location(' Leaving:'||l_proc, 10);
1163: END;
1164:
1165: -- ----------------------------------------------------------------------------
1166: -- |------------------------< CHK_ENROLL_STATUS_ADV >-------------------------|

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

1232: l_proc varchar2(72) := g_package||'chk_enroll_status_adv';
1233: l_type ota_booking_status_types.type%type;
1234:
1235: BEGIN
1236: hr_utility.set_location('Entering:'||l_proc, 5);
1237: IF (funcmode = 'RUN') THEN
1238: OPEN c_enroll_type;
1239: FETCH c_enroll_type INTO l_type;
1240: IF c_enroll_type%found THEN

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

1270: wf_core.context('OTA_WF', 'chk_enroll_status_adv',
1271: itemtype, itemkey, to_char(actid), funcmode);
1272: RAISE;
1273:
1274: hr_utility.set_location(' Leaving:'||l_proc, 10);
1275:
1276: END;
1277: --
1278: -- ----------------------------------------------------------------------------

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

1345: l_proc varchar2(72) := g_package||'chk_enroll_status_arr';
1346: l_type ota_booking_status_types.type%type;
1347:
1348: BEGIN
1349: hr_utility.set_location('Entering:'||l_proc, 5);
1350: IF (funcmode = 'RUN') THEN
1351: OPEN c_enroll_type;
1352: FETCH c_enroll_type INTO l_type;
1353: IF c_enroll_type%found THEN

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

1387: wf_core.context('OTA_WF', 'chk_enroll_status_arr',
1388: itemtype, itemkey, to_char(actid), funcmode);
1389: RAISE;
1390:
1391: hr_utility.set_location(' Leaving:'||l_proc, 10);
1392:
1393: END;
1394:
1395: --

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

1461: l_proc varchar2(72) := g_package||'check_invoice_rule';
1462: l_rule_id oe_order_lines_all.invoicing_rule_id%type;
1463:
1464: BEGIN
1465: hr_utility.set_location('Entering:'||l_proc, 5);
1466: IF (funcmode = 'RUN') THEN
1467: OPEN c_invoice_rule;
1468: FETCH c_invoice_rule INTO l_rule_id;
1469: IF c_invoice_rule%found THEN

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

1499: itemtype, itemkey, to_char(actid), funcmode);
1500: RAISE;
1501:
1502:
1503: hr_utility.set_location(' Leaving:'||l_proc, 10);
1504:
1505: END;
1506: --
1507:

Line 1577: hr_utility.set_location(' entering:'||l_proc, 5);

1573:
1574:
1575: BEGIN
1576: IF (funcmode = 'RUN') THEN
1577: hr_utility.set_location(' entering:'||l_proc, 5);
1578: OPEN C_ENROLLMENT;
1579: FETCH c_enrollment into
1580: l_Booking_status_type_id;
1581: IF c_enrollment%found THEN

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

1632: wf_core.context('OTA_WF', 'cancel_enrollment',
1633: itemtype, itemkey, to_char(actid), funcmode);
1634: RAISE;
1635:
1636: hr_utility.set_location(' Leaving:'||l_proc, 10);
1637:
1638:
1639: END;
1640:

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

1722: line_id = l_line_id);
1723:
1724:
1725: BEGIN
1726: hr_utility.set_location('Entering:'||l_proc, 5);
1727: IF (funcmode = 'RUN') THEN
1728:
1729: OPEN c_event;
1730: FETCH c_event into l_user_name;

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

1755: wf_core.context('OTA_WF', 'UPDATE_OWNER_EMAIL',
1756: itemtype, itemkey, to_char(actid), funcmode);
1757: RAISE;
1758:
1759: hr_utility.set_location(' Leaving:'||l_proc, 10);
1760: END;
1761:
1762: -- ----------------------------------------------------------------------------
1763: -- |------------------------< CHK_EVENT_ENROLL_STATUS >------------------------|

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

1842: l_proc varchar2(72) := g_package||'chk_event_enroll_status';
1843: l_type ota_booking_status_types.type%type;
1844:
1845: BEGIN
1846: hr_utility.set_location('Entering:'||l_proc, 5);
1847: IF (funcmode = 'RUN') THEN
1848: OPEN C_EVENT;
1849: FETCH C_EVENT INTO l_event_id;
1850: IF c_event%found then

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

1889: wf_core.context('OTA_WF', 'chk_enroll_status_arr',
1890: itemtype, itemkey, to_char(actid), funcmode);
1891: RAISE;
1892:
1893: hr_utility.set_location(' Leaving:'||l_proc, 10);
1894:
1895: END;
1896:
1897: