19:
20:
21:
22: BEGIN
23: hr_utility.set_location('ENTERING get_approval_req', 10);
24: IF (funcmode='RUN') THEN
25:
26:
27:
42: resultout:='COMPLETE:Y';
43:
44:
45: end if;
46: hr_utility.trace('l_resultout' || resultout);
47:
48: RETURN;
49: END IF; --RUN
50:
54: END IF;
55: Exception
56:
57: when others then
58: hr_utility.set_location('ENTERING exception get_approval_req', 10);
59:
60:
61:
62: end get_approval_req;
400: ,p_transaction_data => l_transaction_table);
401:
402:
403: EXCEPTION
404: WHEN hr_utility.hr_error THEN
405: -- -------------------------------------------
406: -- an application error has been raised so we must
407: -- redisplay the web form to display the error
408: -- --------------------------------------------
1655: CLOSE csr_chk_event;
1656:
1657: --Changed for the unhelpful error msg issue
1658: IF l_booking_id is null then
1659: hr_utility.set_message(810, 'OTA_467215_ENR_STATUS_CHANGED');
1660: hr_utility.raise_error;
1661: END IF;
1662:
1663: select sysdate into l_current_date from dual;
1656:
1657: --Changed for the unhelpful error msg issue
1658: IF l_booking_id is null then
1659: hr_utility.set_message(810, 'OTA_467215_ENR_STATUS_CHANGED');
1660: hr_utility.raise_error;
1661: END IF;
1662:
1663: select sysdate into l_current_date from dual;
1664:
2487: l_temp_event_id varchar2(100) := null;
2488: l_return_value varchar2(1) := 'N';
2489: BEGIN
2490:
2491: hr_utility.set_location('Entering:'||l_proc, 5);
2492:
2493: FOR c in cur_get_pending_trn_step_id
2494: LOOP
2495: l_temp_event_id :=
2507: l_return_value := 'Y';
2508: End If;
2509:
2510: RETURN l_return_value;
2511: hr_utility.set_location('Entering:'||l_proc, 30);
2512: END is_class_pending_for_approval;
2513:
2514:
2515: --