110: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
111: --standard message list initialization code..
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
113: IF FND_API.to_Boolean( p_init_msg_list ) THEN
114: FND_MSG_PUB.initialize;
115: END IF;
116: IF FND_GLOBAL.User_Id IS NULL THEN
117: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
118: RAISE FND_API.G_EXC_ERROR;
184: exception
185: WHEN FND_API.G_EXC_ERROR THEN
186: ROLLBACK;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
189:
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: ROLLBACK;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
194:
195: WHEN OTHERS THEN
196: ROLLBACK;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194:
195: WHEN OTHERS THEN
196: ROLLBACK;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
199: THEN
200: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
201: END IF;
202: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
196: ROLLBACK;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
199: THEN
200: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
201: END IF;
202: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
203: END initialize_org_parameters;
204:
198: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
199: THEN
200: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
201: END IF;
202: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
203: END initialize_org_parameters;
204:
205: PROCEDURE update_org_parameters(
206: p_process_approval_option IN VARCHAR2,
225: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
226: --standard message list initialization code..
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228: IF FND_API.to_Boolean( p_init_msg_list ) THEN
229: FND_MSG_PUB.initialize;
230: END IF;
231: IF FND_GLOBAL.User_Id IS NULL THEN
232: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
233: RAISE FND_API.G_EXC_ERROR;
257: exception
258: WHEN FND_API.G_EXC_ERROR THEN
259: ROLLBACK;
260: x_return_status := FND_API.G_RET_STS_ERROR;
261: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264: ROLLBACK;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262:
263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
264: ROLLBACK;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
267:
268: WHEN OTHERS THEN
269: ROLLBACK;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
267:
268: WHEN OTHERS THEN
269: ROLLBACK;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
274: END IF;
275: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
269: ROLLBACK;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
274: END IF;
275: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
276:
277: end update_org_parameters;
271: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
272: THEN
273: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
274: END IF;
275: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
276:
277: end update_org_parameters;
278:
279:
350:
351: --standard message list initialization code..
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353: IF FND_API.to_Boolean( p_init_msg_list ) THEN
354: FND_MSG_PUB.initialize;
355: END IF;
356: IF FND_GLOBAL.User_Id IS NULL THEN
357: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
358: RAISE FND_API.G_EXC_ERROR;
385: exception
386: WHEN FND_API.G_EXC_ERROR THEN
387: ROLLBACK;
388: x_return_status := FND_API.G_RET_STS_ERROR;
389: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
390:
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: ROLLBACK;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
390:
391: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
392: ROLLBACK;
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
395:
396: WHEN OTHERS THEN
397: ROLLBACK;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
395:
396: WHEN OTHERS THEN
397: ROLLBACK;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
402: END IF;
403: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
397: ROLLBACK;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
402: END IF;
403: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
404: END default_org_parameters;
405:
399: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
400: THEN
401: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
402: END IF;
403: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
404: END default_org_parameters;
405:
406: -- kosriniv ..update orgs concurrent programs
407: PROCEDURE update_all_org_params_cp(