APPS.OTA_TFH_API_BUSINESS_RULES dependencies on FND_USER

Line 164: -- The authorised_by attribute must be a valid FND_USER

160: -- ----------------------------------------------------------------------------
161: --
162: -- PUBLIC
163: -- Description:
164: -- The authorised_by attribute must be a valid FND_USER
165: --
166: Procedure check_authorized_by
167: (
168: p_person_id in number

Line 177: If NOT ota_general.check_fnd_user( p_person_id) Then

173: Begin
174: hr_utility.set_location('Entering:'|| v_proc, 5);
175: --
176: If p_person_id is not null Then
177: If NOT ota_general.check_fnd_user( p_person_id) Then
178: fnd_message.set_name('OTA','OTA_13281_TFH_AUTHORIZER');
179: fnd_message.raise_error;
180: End if;
181: End if;

Line 2226: if not ota_general.check_fnd_user(p_administrator) then

2222: hr_utility.set_location('Entering:'|| v_proc, 5);
2223: --
2224: If p_administrator is NOT null Then
2225: --
2226: if not ota_general.check_fnd_user(p_administrator) then
2227: fnd_message.set_name('OTA','OTA_13291_TFH_ADMINISTRATOR');
2228: fnd_message.raise_error;
2229: end if;
2230: End if;

Line 2430: ,p_fnd_user_id in number

2426: --
2427: procedure initialize_finance_header
2428: (
2429: p_business_group_id in number
2430: ,p_fnd_user_id in number
2431: ,p_deflt_currency_code out nocopy varchar2
2432: ,p_deflt_trans_status_meaning out nocopy varchar2
2433: ,p_deflt_administrator out nocopy varchar2
2434: ,p_deflt_organization out nocopy varchar2

Line 2436: cursor get_fnd_user is

2432: ,p_deflt_trans_status_meaning out nocopy varchar2
2433: ,p_deflt_administrator out nocopy varchar2
2434: ,p_deflt_organization out nocopy varchar2
2435: ) is
2436: cursor get_fnd_user is
2437: select user_name
2438: from fnd_user
2439: where user_id = p_fnd_user_id;
2440: --

Line 2438: from fnd_user

2434: ,p_deflt_organization out nocopy varchar2
2435: ) is
2436: cursor get_fnd_user is
2437: select user_name
2438: from fnd_user
2439: where user_id = p_fnd_user_id;
2440: --
2441: begin
2442: -- get default currency code for the Business group

Line 2439: where user_id = p_fnd_user_id;

2435: ) is
2436: cursor get_fnd_user is
2437: select user_name
2438: from fnd_user
2439: where user_id = p_fnd_user_id;
2440: --
2441: begin
2442: -- get default currency code for the Business group
2443: --

Line 2455: open get_fnd_user;

2451: hr_general.decode_lookup('GL_TRANSFER_STATUS' ,'NT');
2452: --
2453: -- Get default Administrator
2454: --
2455: open get_fnd_user;
2456: fetch get_fnd_user into p_deflt_administrator;
2457: close get_fnd_user;
2458: --
2459: --

Line 2456: fetch get_fnd_user into p_deflt_administrator;

2452: --
2453: -- Get default Administrator
2454: --
2455: open get_fnd_user;
2456: fetch get_fnd_user into p_deflt_administrator;
2457: close get_fnd_user;
2458: --
2459: --
2460: -- Get default organization

Line 2457: close get_fnd_user;

2453: -- Get default Administrator
2454: --
2455: open get_fnd_user;
2456: fetch get_fnd_user into p_deflt_administrator;
2457: close get_fnd_user;
2458: --
2459: --
2460: -- Get default organization
2461: --