1410: --ideally we should check if the requestor belongs to the tp_id and tp_site_id provided.
1411: begin
1412: select user_id
1413: into l_user_id
1414: from fnd_user
1415: where user_name = p_requestor; --ideally it should be 'XML_USER'
1416: exception when others then
1417: /*
1418: PO_CHN_XML_USER_INVALID = "The USERNAME is not a valid user
1944: l_po_release_id := g_po_change_table(g_po_change_table.FIRST).PO_Release_Id;
1945: l_revision_num := g_po_change_table(g_po_change_table.FIRST).Document_Revision_Num;
1946: select user_id
1947: into l_user_id
1948: from fnd_user
1949: where user_name = g_requestor;
1950:
1951: --dbms_output.put_line('x_error_status_out inside3 : ' || x_error_status_out);
1952: PO_CHG_REQUEST_PVT.process_supplier_request (
2089: -- Bug 7287009 - End
2090:
2091: select to_char(user_id)
2092: into l_user_id
2093: from fnd_user
2094: where user_name = p_requestor;
2095:
2096: if (p_po_type = 'RELEASE') then
2097: select to_char(po_release_id), to_char(agent_id), LAST_UPDATE_DATE