240: IF p_pb_input_header_rec.pricing_perspective_code IS NULL THEN
241: BEGIN
242: SELECT customer_id
243: INTO l_customer_id
244: FROM fnd_user
245: WHERE user_id = l_user_id;
246: EXCEPTION
247: WHEN OTHERS THEN
248: l_customer_id := NULL;
273: ELSE
274: BEGIN
275: SELECT customer_id
276: INTO l_customer_id
277: FROM fnd_user
278: WHERE user_id = l_user_id;
279: EXCEPTION
280: WHEN OTHERS THEN
281: l_customer_id := NULL;
700: --Check if the user is an external or internal user
701: BEGIN
702: SELECT customer_id
703: INTO l_customer_id
704: FROM fnd_user
705: WHERE user_id = l_user_id;
706:
707: EXCEPTION
708: WHEN OTHERS THEN
4058: BEGIN
4059: -- get user based on user name
4060: SELECT user_id
4061: INTO l_user_id
4062: FROM fnd_user
4063: WHERE user_name = upper(p_user_name);
4064:
4065: -- get pricing perpective based on user
4066: fnd_global.apps_initialize(l_user_id,