[Home] [Help]
1296: , avalue => p_effective_date);
1297: wf_engine.SetItemAttrText(itemtype => p_itemtype
1298: , itemkey => p_ItemKey
1299: , aname => 'ROUTED_BY_USER'
1300: , avalue => nvl(fnd_profile.value('USERNAME'),p_route_to_user));
1301: wf_engine.SetItemAttrText( itemtype => p_itemtype,
1302: itemkey => p_itemkey,
1303: aname => 'COMMENTS',
1304: avalue => p_comments);
1682: IF p_effective_date IS NULL THEN
1683: hr_utility.set_message(8302,'PQH_NULL_EFFECTIVE_DATE');
1684: hr_utility.raise_error;
1685: END IF;
1686: l_route_to_user := nvl(fnd_profile.value('USERNAME'),p_route_to_user);
1687: hr_utility.set_location('route_to user'||l_route_to_user, 281);
1688: ELSIF l_user_action_cd IN ('FORWARD') THEN
1689: IF p_member_cd = 'R' AND p_forwarded_to_member_id IS NULL THEN
1690: hr_utility.set_location(l_proc || ' PQH_NULL_MEMBER_ID', 30);
1741: , p_forwarded_by_user_id => l_forwarded_to_user_id
1742: , p_forwarded_by_role_id => l_forwarded_to_role_id
1743: );
1744: hr_utility.set_location(l_proc || 'requestor is '||l_requestor,401);
1745: l_rejector := nvl(fnd_profile.value('USERNAME'),p_route_to_user);
1746: hr_utility.set_location(l_proc || 'rejected by is '||l_rejector,402);
1747: IF l_requestor is null or l_rejector is null then
1748: hr_utility.set_location('requestor or rejector null ', 403);
1749: l_forwarded_to_assignment_id := p_forwarded_to_assignment_id;
2698: -- which in turn builds the default role
2699:
2700: FUNCTION get_default_role (
2701: p_transaction_category_id NUMBER
2702: , p_user_id in NUMBER default FND_PROFILE.VALUE('USER_ID')
2703: )
2704: RETURN NUMBER
2705: IS
2706: