2820: END IF;
2821:
2822: --For Bug 13711743
2823: --Handling this SQL in exception to continue the process
2824: --though Fnd User id of old buyer is fetched or not.
2825: BEGIN
2826: SELECT user_id
2827: INTO p_old_buyer_user_id
2828: FROM fnd_user
2824: --though Fnd User id of old buyer is fetched or not.
2825: BEGIN
2826: SELECT user_id
2827: INTO p_old_buyer_user_id
2828: FROM fnd_user
2829: WHERE employee_id = p_old_personid
2830: AND user_name = p_old_username;
2831: EXCEPTION
2832: WHEN OTHERS THEN
2844: */
2845: BEGIN
2846: SELECT user_id
2847: INTO p_new_buyer_user_id
2848: FROM fnd_user
2849: WHERE employee_id = p_new_personid
2850: AND user_name = p_new_username;
2851: EXCEPTION
2852: WHEN NO_DATA_FOUND THEN