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

Line 150: p_fnd_user_id IN NUMBER,

146:
147: /*=======================================================================*/
148:
149: PROCEDURE Add_Bookmark(
150: p_fnd_user_id IN NUMBER,
151: p_bookmarked_party_id IN NUMBER,
152: x_party_id OUT NOCOPY NUMBER,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY VARCHAR2,

Line 161: l_user_name FND_USER.USER_NAME%TYPE;

157:
158: l_return_status VARCHAR2(1);
159: l_hz_return_status VARCHAR2(1);
160: l_party_id NUMBER;
161: l_user_name FND_USER.USER_NAME%TYPE;
162: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
163: l_person_id FND_USER.EMPLOYEE_ID%TYPE;
164: BEGIN
165:

Line 162: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;

158: l_return_status VARCHAR2(1);
159: l_hz_return_status VARCHAR2(1);
160: l_party_id NUMBER;
161: l_user_name FND_USER.USER_NAME%TYPE;
162: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
163: l_person_id FND_USER.EMPLOYEE_ID%TYPE;
164: BEGIN
165:
166: SELECT user_name, email_address, customer_id, employee_id

Line 163: l_person_id FND_USER.EMPLOYEE_ID%TYPE;

159: l_hz_return_status VARCHAR2(1);
160: l_party_id NUMBER;
161: l_user_name FND_USER.USER_NAME%TYPE;
162: l_email_address FND_USER.EMAIL_ADDRESS%TYPE;
163: l_person_id FND_USER.EMPLOYEE_ID%TYPE;
164: BEGIN
165:
166: SELECT user_name, email_address, customer_id, employee_id
167: INTO l_user_name, l_email_address, l_party_id, l_person_id

Line 168: FROM fnd_user

164: BEGIN
165:
166: SELECT user_name, email_address, customer_id, employee_id
167: INTO l_user_name, l_email_address, l_party_id, l_person_id
168: FROM fnd_user
169: WHERE user_id = p_fnd_user_id;
170:
171: IF l_party_id is NULL THEN
172: /* create new party using user name as both first and last names */

Line 169: WHERE user_id = p_fnd_user_id;

165:
166: SELECT user_name, email_address, customer_id, employee_id
167: INTO l_user_name, l_email_address, l_party_id, l_person_id
168: FROM fnd_user
169: WHERE user_id = p_fnd_user_id;
170:
171: IF l_party_id is NULL THEN
172: /* create new party using user name as both first and last names */
173: HZ_USER_PARTY_UTILS.get_user_party_id(

Line 182: /* problem creating party for FND user */

178: l_party_id,
179: l_hz_return_status);
180:
181: IF l_hz_return_status <> FND_API.G_RET_STS_SUCCESS THEN
182: /* problem creating party for FND user */
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MESSAGE.SET_NAME('IMC', 'HZ_API_OTHERS_EXCEP');
185: FND_MSG_PUB.ADD;
186: FND_MSG_PUB.Count_And_Get(

Line 192: /* hook up fnd_user.customer_id and hz_parties.party_id */

188: p_count => x_msg_count,
189: p_data => x_msg_data);
190: END IF;
191:
192: /* hook up fnd_user.customer_id and hz_parties.party_id */
193: fnd_user_pkg.updateuser(x_user_name=>l_user_name,
194: x_owner=>'SEED',
195: x_customer_id=>l_party_id);
196:

Line 193: fnd_user_pkg.updateuser(x_user_name=>l_user_name,

189: p_data => x_msg_data);
190: END IF;
191:
192: /* hook up fnd_user.customer_id and hz_parties.party_id */
193: fnd_user_pkg.updateuser(x_user_name=>l_user_name,
194: x_owner=>'SEED',
195: x_customer_id=>l_party_id);
196:
197: Add_Bookmark(

Line 232: /* FND user ID does not exist */

228: p_count => x_msg_count,
229: p_data => x_msg_data);
230:
231: WHEN NO_DATA_FOUND THEN
232: /* FND user ID does not exist */
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: FND_MESSAGE.SET_NAME('IMC', 'IMC_FND_USER_NOT_EXIST');
235: FND_MSG_PUB.ADD;
236: FND_MSG_PUB.Count_And_Get(

Line 234: FND_MESSAGE.SET_NAME('IMC', 'IMC_FND_USER_NOT_EXIST');

230:
231: WHEN NO_DATA_FOUND THEN
232: /* FND user ID does not exist */
233: x_return_status := FND_API.G_RET_STS_ERROR;
234: FND_MESSAGE.SET_NAME('IMC', 'IMC_FND_USER_NOT_EXIST');
235: FND_MSG_PUB.ADD;
236: FND_MSG_PUB.Count_And_Get(
237: p_encoded => FND_API.G_FALSE,
238: p_count => x_msg_count,

Line 269: IF p_user_type NOT IN (G_PARTY_USER_TYPE, G_FND_USER_TYPE) THEN

265: p_encoded => FND_API.G_FALSE,
266: p_count => x_msg_count,
267: p_data => x_msg_data);
268: ELSE
269: IF p_user_type NOT IN (G_PARTY_USER_TYPE, G_FND_USER_TYPE) THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: FND_MESSAGE.SET_NAME('IMC', 'IMC_INVALID_USER_TYPE');
272: FND_MSG_PUB.ADD;
273: FND_MSG_PUB.Count_And_Get(

Line 282: /* find party id of FND user */

278:
279: IF p_user_type = G_PARTY_USER_TYPE THEN
280: l_user_id := p_party_id;
281: ELSE
282: /* find party id of FND user */
283: select customer_id into l_user_id
284: from fnd_user
285: where user_id = p_party_id;
286: END IF;

Line 284: from fnd_user

280: l_user_id := p_party_id;
281: ELSE
282: /* find party id of FND user */
283: select customer_id into l_user_id
284: from fnd_user
285: where user_id = p_party_id;
286: END IF;
287:
288:

Line 430: IF p_user_type NOT IN (G_PARTY_USER_TYPE, G_FND_USER_TYPE) THEN

426: IF l_category IS NULL THEN
427: RETURN 'E';
428: END IF;
429:
430: IF p_user_type NOT IN (G_PARTY_USER_TYPE, G_FND_USER_TYPE) THEN
431: RETURN 'E';
432: END IF;
433:
434: IF p_user_type = G_PARTY_USER_TYPE THEN

Line 437: /* find party id of FND user */

433:
434: IF p_user_type = G_PARTY_USER_TYPE THEN
435: l_user_id := p_party_id;
436: ELSE
437: /* find party id of FND user */
438: select customer_id into l_user_id
439: from fnd_user
440: where user_id = p_party_id;
441: END IF;

Line 439: from fnd_user

435: l_user_id := p_party_id;
436: ELSE
437: /* find party id of FND user */
438: select customer_id into l_user_id
439: from fnd_user
440: where user_id = p_party_id;
441: END IF;
442:
443: l_ret := HZ_PREFERENCE_PUB.Contains_Value(

Line 495: | the fnd users that are already assigned a per_all_people.

491: | *** Copy from ARHUSRPB.pls ***
492: | Create a party for a per_all_people_f person if it has not
493: | already created. The concept here is that we believe that
494: | HR person is more reliable resource than email_address for
495: | the fnd users that are already assigned a per_all_people.
496: |
497: | We will use the first name and last name from the HR table,
498: | and use 'PER:' + person_id as orig system reference
499: | so we can use Party Merge to merge this party created from