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.AR_CMGT_CREDIT_REQUEST_API dependencies on FND_USER

Line 98: FROM fnd_user

94: and person_id = p_person_id;
95:
96: CURSOR cFndUser(cp_user_id NUMBER) is
97: SELECT 'x'
98: FROM fnd_user
99: WHERE sysdate between start_date and nvl(end_date, sysdate)
100: and user_id = cp_user_id;
101:
102: BEGIN

Line 161: l_requestor_type := 'FND_USER/EMPLOYEE';

157: END IF;
158:
159: IF l_requestor_type IS NULL -- For Backward compatibility
160: THEN
161: l_requestor_type := 'FND_USER/EMPLOYEE';
162: ELSIF l_requestor_type IS NOT NULL AND
163: l_requestor_type NOT IN ('EMPLOYEE', 'FND_USER')
164: THEN
165: IF pg_debug = 'Y'

Line 163: l_requestor_type NOT IN ('EMPLOYEE', 'FND_USER')

159: IF l_requestor_type IS NULL -- For Backward compatibility
160: THEN
161: l_requestor_type := 'FND_USER/EMPLOYEE';
162: ELSIF l_requestor_type IS NOT NULL AND
163: l_requestor_type NOT IN ('EMPLOYEE', 'FND_USER')
164: THEN
165: IF pg_debug = 'Y'
166: THEN
167: debug ( 'Invalid Requestor Type ' || l_requestor_type );

Line 178: IF l_requestor_type = 'FND_USER/EMPLOYEE'

174: END IF;
175:
176: debug ( 'l_requestor_type ' || l_requestor_type );
177:
178: IF l_requestor_type = 'FND_USER/EMPLOYEE'
179: THEN
180: /* Not Sure of the Source since p_request_type is passed as NULL
181: In that case first check the requestor ID, if its passed as -1
182: or NULL then take the FND_GLOBAL.USER_ID and set the request

Line 183: type as FND_USER.

179: THEN
180: /* Not Sure of the Source since p_request_type is passed as NULL
181: In that case first check the requestor ID, if its passed as -1
182: or NULL then take the FND_GLOBAL.USER_ID and set the request
183: type as FND_USER.
184:
185: If the Requestor ID is not NULL or <> -1 then check if the
186: Requestor is an Employee
187: Else check if the Requestor is a FND User

Line 187: Else check if the Requestor is a FND User

183: type as FND_USER.
184:
185: If the Requestor ID is not NULL or <> -1 then check if the
186: Requestor is an Employee
187: Else check if the Requestor is a FND User
188: */
189:
190: IF l_requestor_id IS NULL OR l_requestor_id = -1
191: THEN

Line 192: debug('p_requestor_type is passed as NULL, p_requestor_id is NULL or -1, use FND USER');

188: */
189:
190: IF l_requestor_id IS NULL OR l_requestor_id = -1
191: THEN
192: debug('p_requestor_type is passed as NULL, p_requestor_id is NULL or -1, use FND USER');
193: l_requestor_id := FND_GLOBAL.USER_ID;
194: l_requestor_type := 'FND_USER';
195: debug('p_requestor_type is passed as NULL, l_requestor_id:'||
196: l_requestor_id||' l_requestor_type :'||l_requestor_type);

Line 194: l_requestor_type := 'FND_USER';

190: IF l_requestor_id IS NULL OR l_requestor_id = -1
191: THEN
192: debug('p_requestor_type is passed as NULL, p_requestor_id is NULL or -1, use FND USER');
193: l_requestor_id := FND_GLOBAL.USER_ID;
194: l_requestor_type := 'FND_USER';
195: debug('p_requestor_type is passed as NULL, l_requestor_id:'||
196: l_requestor_id||' l_requestor_type :'||l_requestor_type);
197: ELSE
198: debug('p_requestor_type is passed as NULL, check both EMPLOYEE and FND_USER');

Line 198: debug('p_requestor_type is passed as NULL, check both EMPLOYEE and FND_USER');

194: l_requestor_type := 'FND_USER';
195: debug('p_requestor_type is passed as NULL, l_requestor_id:'||
196: l_requestor_id||' l_requestor_type :'||l_requestor_type);
197: ELSE
198: debug('p_requestor_type is passed as NULL, check both EMPLOYEE and FND_USER');
199: OPEN employee(l_requestor_id);
200: FETCH employee INTO l_char;
201: IF employee%NOTFOUND
202: THEN

Line 208: debug('p_requestor_type is passed as NULL, FND_USER check failed');

204: OPEN cFndUser(l_requestor_id);
205: FETCH cFndUser INTO l_char;
206: IF cFndUser%NOTFOUND
207: THEN
208: debug('p_requestor_type is passed as NULL, FND_USER check failed');
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: ELSE
211: -- The Requestor is a FND User, set the Requestor Type
212: l_requestor_type := 'FND_USER';

Line 211: -- The Requestor is a FND User, set the Requestor Type

207: THEN
208: debug('p_requestor_type is passed as NULL, FND_USER check failed');
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: ELSE
211: -- The Requestor is a FND User, set the Requestor Type
212: l_requestor_type := 'FND_USER';
213: END IF;
214: CLOSE cFndUser;
215:

Line 212: l_requestor_type := 'FND_USER';

208: debug('p_requestor_type is passed as NULL, FND_USER check failed');
209: x_return_status := FND_API.G_RET_STS_ERROR;
210: ELSE
211: -- The Requestor is a FND User, set the Requestor Type
212: l_requestor_type := 'FND_USER';
213: END IF;
214: CLOSE cFndUser;
215:
216: ELSE

Line 236: ELSIF l_requestor_id IS NOT NULL and l_requestor_type = 'FND_USER'

232: debug('p_requestor_type is passed, Employee check is failed');
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: END IF;
235: CLOSE employee;
236: ELSIF l_requestor_id IS NOT NULL and l_requestor_type = 'FND_USER'
237: THEN
238: OPEN cFndUser(l_requestor_id);
239: FETCH cFndUser INTO l_char;
240: IF cFndUser%NOTFOUND

Line 242: debug('p_requestor_type is passed, FND USER check is failed');

238: OPEN cFndUser(l_requestor_id);
239: FETCH cFndUser INTO l_char;
240: IF cFndUser%NOTFOUND
241: THEN
242: debug('p_requestor_type is passed, FND USER check is failed');
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: END IF;
245: CLOSE cFndUser;
246: ELSE

Line 585: ELSIF p_requestor_id IS NOT NULL and l_requestor_type = 'FND_USER'

581: END IF;
582: x_return_status := FND_API.G_RET_STS_ERROR;
583: END IF;
584: CLOSE employee;
585: ELSIF p_requestor_id IS NOT NULL and l_requestor_type = 'FND_USER'
586: THEN
587: OPEN cFndUser(p_requestor_id);
588: FETCH cFndUser INTO l_char;
589: IF cFndUser%NOTFOUND THEN

Line 592: debug ( 'FND User Not Found');

588: FETCH cFndUser INTO l_char;
589: IF cFndUser%NOTFOUND THEN
590: IF pg_debug = 'Y'
591: THEN
592: debug ( 'FND User Not Found');
593: END IF;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595: END IF;
596: CLOSE cFndUser;