DBA Data[Home] [Help]

APPS.GMD_API_PUB dependencies on FND_GLOBAL

Line 120: --| Notes : When calling Public API's using SQLPLUS the FND_GLOBAL |

116: --Start of comments
117: --+========================================================================+
118: --| API Name : SET_USER_CONTEXT
119: --| TYPE : UTIL |
120: --| Notes : When calling Public API's using SQLPLUS the FND_GLOBAL |
121: --| .user_id is default to -1. This API will set the user_id |
122: --| to the value specified. It will also set the resp, appl |
123: --| values based on the Quality Manager Responsbility. |
124: --| It assumes that this responsibility will always exist. |

Line 162: -- Compare the Current Value from FND_GLOBAL, with the User_id

158: -- Initialize API return Parameters
159:
160: l_return_status := FND_API.G_RET_STS_SUCCESS;
161:
162: -- Compare the Current Value from FND_GLOBAL, with the User_id
163: -- parameter if they are the same , We need to do Nothing.
164:
165:
166: IF FND_GLOBAL.USER_ID <> p_user_id THEN

Line 166: IF FND_GLOBAL.USER_ID <> p_user_id THEN

162: -- Compare the Current Value from FND_GLOBAL, with the User_id
163: -- parameter if they are the same , We need to do Nothing.
164:
165:
166: IF FND_GLOBAL.USER_ID <> p_user_id THEN
167:
168: -- Get the values for the application id and responsibility
169: -- For Quality Manager Responsibility.
170: -- Could Select More than one Line With Matching Keys

Line 184: FND_GLOBAL.APPS_INITIALIZE

180: CLOSE c_get_appl_resp;
181:
182: -- Now set the appl, resp and user context.
183:
184: FND_GLOBAL.APPS_INITIALIZE
185: ( USER_ID => p_user_id,
186: RESP_ID => l_responsibility_id,
187: RESP_APPL_ID => l_application_id);
188:

Line 190: -- will set the FND_GLOBAL.USER_NAME = NULL.

186: RESP_ID => l_responsibility_id,
187: RESP_APPL_ID => l_application_id);
188:
189: -- Additional Check, if user_id is invalid, the above routine
190: -- will set the FND_GLOBAL.USER_NAME = NULL.
191:
192: IF (FND_GLOBAL.USER_NAME IS NULL) THEN
193:
194: GMD_API_PUB.Log_Message('GME_API_INVALID_USER_NAME');

Line 192: IF (FND_GLOBAL.USER_NAME IS NULL) THEN

188:
189: -- Additional Check, if user_id is invalid, the above routine
190: -- will set the FND_GLOBAL.USER_NAME = NULL.
191:
192: IF (FND_GLOBAL.USER_NAME IS NULL) THEN
193:
194: GMD_API_PUB.Log_Message('GME_API_INVALID_USER_NAME');
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;