DBA Data[Home] [Help]

APPS.OTA_EL_ENROLL_SS dependencies on HR_UTILITY

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

1137: l_no number := 0;
1138: BEGIN
1139:
1140: --
1141: hr_utility.set_location('Entering:'||l_proc, 5);
1142: --
1143: For a in csr_cost loop
1144: l_no := l_no+1;
1145: p_cost_alloc_keyflex_id :=a.cost_allocation_keyflex_id;

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

1158: p_organization_id :=asg_rec.organization_id ;
1159: end loop;
1160: end if;
1161: --
1162: hr_utility.set_location(' Leaving:'||l_proc, 10);
1163:
1164: END check_cost_center;
1165:
1166: --

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

1220: WHERE
1221: user_id = l_current_user_id ;
1222:
1223: BEGIN
1224: hr_utility.set_location('Entering:'||l_proc, 5);
1225:
1226: OPEN C_USER;
1227: FETCH C_USER INTO l_creator_person_id;
1228: CLOSE C_USER;

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

1226: OPEN C_USER;
1227: FETCH C_USER INTO l_creator_person_id;
1228: CLOSE C_USER;
1229:
1230: hr_utility.set_location('Entering:'||l_proc, 10);
1231: -- Get the next item key from the sequence
1232: select hr_workflow_item_key_s.nextval
1233: into l_item_key
1234: from sys.dual;

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

1248:
1249: EXCEPTION
1250: WHEN OTHERS THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: hr_utility.set_location('leaving:'||l_proc, 20);
1253:
1254:
1255: End create_enroll_wf_process;
1256:

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

1789: l_proc varchar2(72) := g_package||'check_enrollment_creation';
1790:
1791:
1792: BEGIN
1793: hr_utility.set_location('Entering:'||l_proc, 5);
1794: IF (funcmode = 'RUN') THEN
1795: l_booking_id := wf_engine.GetItemAttrNUMBER(itemtype => itemtype
1796: ,itemkey => itemkey
1797: ,aname => 'BOOKING_ID');

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

1825: wf_core.context('OTA_WF', 'Check_Creation',
1826: itemtype, itemkey, to_char(actid), funcmode);
1827: RAISE;
1828:
1829: hr_utility.set_location(' Leaving:'||l_proc, 10);
1830: END;
1831:
1832:
1833: --

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

1875: AND item_type = p_item_type
1876: AND item_key = p_item_key;
1877:
1878: BEGIN
1879: hr_utility.set_location('Entering:'||l_proc, 5);
1880: OPEN line_wf;
1881: fetch line_wf into l_exist;
1882: if line_wf%found then
1883: l_return := True;

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

1884: end if;
1885: CLOSE line_wf;
1886: Return(l_return);
1887:
1888: hr_utility.set_location('Leaving:'||l_proc, 10);
1889: END check_wf_status;
1890:
1891: --
1892: -- -----------------------------------------------------------