5: ---------------------------------------------------------------------
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_PARAMETERS_PVT_PKG';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwparpb.pls';
9: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
11:
12: PROCEDURE insert_parameter(
13: p_parameter_name IN VARCHAR2,
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_PARAMETERS_PVT_PKG';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwparpb.pls';
9: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
11:
12: PROCEDURE insert_parameter(
13: p_parameter_name IN VARCHAR2,
14: p_parameter_value IN VARCHAR2,
105: L_API_NAME CONSTANT VARCHAR2(30) := 'initialize_org_parameters';
106: BEGIN
107:
108: -- Standard Initialization..
109: G_USER_ID := FND_GLOBAL.USER_ID;
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
106: BEGIN
107:
108: -- Standard Initialization..
109: G_USER_ID := FND_GLOBAL.USER_ID;
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;
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;
119: END IF;
120:
220:
221: L_API_NAME CONSTANT VARCHAR2(30) := 'update_org_parameters';
222: BEGIN
223: -- Standard Initialization..
224: G_USER_ID := FND_GLOBAL.USER_ID;
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
221: L_API_NAME CONSTANT VARCHAR2(30) := 'update_org_parameters';
222: BEGIN
223: -- Standard Initialization..
224: G_USER_ID := FND_GLOBAL.USER_ID;
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;
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;
234: END IF;
235:
344: BEGIN
345:
346:
347: -- Standard Initialization..
348: G_USER_ID := FND_GLOBAL.USER_ID;
349: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
350:
351: --standard message list initialization code..
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
345:
346:
347: -- Standard Initialization..
348: G_USER_ID := FND_GLOBAL.USER_ID;
349: G_LOGIN_ID := FND_GLOBAL.CONC_LOGIN_ID;
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
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;
359: END IF;
360: