94: p_pk2 IN VARCHAR2 := NULL,
95: p_pk3 IN VARCHAR2 := NULL,
96: p_pk4 IN VARCHAR2 := NULL,
97: p_pk5 IN VARCHAR2 := NULL,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY VARCHAR2,
95: p_pk3 IN VARCHAR2 := NULL,
96: p_pk4 IN VARCHAR2 := NULL,
97: p_pk5 IN VARCHAR2 := NULL,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY VARCHAR2,
103: x_msg_data OUT NOCOPY VARCHAR2
96: p_pk4 IN VARCHAR2 := NULL,
97: p_pk5 IN VARCHAR2 := NULL,
98: p_commit IN VARCHAR2 := FND_API.G_FALSE,
99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY VARCHAR2,
103: x_msg_data OUT NOCOPY VARCHAR2
104: ) IS
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;
115: END IF;
116: IF FND_GLOBAL.User_Id IS NULL THEN
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;
115: END IF;
116: IF FND_GLOBAL.User_Id IS NULL THEN
117: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
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:
121: -- INSERT PROCESS_APPROVAL_OPTION..
122:
181: G_LOGIN_ID
182: );
183:
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:
183:
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;
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;
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;
193: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
194:
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;
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;
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;
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;
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;
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,
209: p_pk2 IN VARCHAR2 := NULL,
210: p_pk3 IN VARCHAR2 := NULL,
211: p_pk4 IN VARCHAR2 := NULL,
212: p_pk5 IN VARCHAR2 := NULL,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY VARCHAR2,
210: p_pk3 IN VARCHAR2 := NULL,
211: p_pk4 IN VARCHAR2 := NULL,
212: p_pk5 IN VARCHAR2 := NULL,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY VARCHAR2,
218: x_msg_data OUT NOCOPY VARCHAR2
211: p_pk4 IN VARCHAR2 := NULL,
212: p_pk5 IN VARCHAR2 := NULL,
213: p_commit IN VARCHAR2 := FND_API.G_FALSE,
214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
216: x_return_status OUT NOCOPY VARCHAR2,
217: x_msg_count OUT NOCOPY VARCHAR2,
218: x_msg_data OUT NOCOPY VARCHAR2
219: ) IS
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;
230: END IF;
231: IF FND_GLOBAL.User_Id IS NULL THEN
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;
230: END IF;
231: IF FND_GLOBAL.User_Id IS NULL THEN
232: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
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:
236: -- UPDATE PROCESS_APPROVAL_OPTION..
237:
254: p_pk3 => p_pk3,
255: p_pk4 => p_pk4,
256: p_pk5 => p_pk5);
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:
256: p_pk5 => p_pk5);
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;
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;
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;
266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
267:
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;
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;
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;
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;
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;
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:
330:
331: --kosriniv..for bug fix..4336520
332: PROCEDURE default_org_parameters(
333: p_org IN VARCHAR2,
334: p_commit IN VARCHAR2 := FND_API.G_FALSE,
335: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
336: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY VARCHAR2,
331: --kosriniv..for bug fix..4336520
332: PROCEDURE default_org_parameters(
333: p_org IN VARCHAR2,
334: p_commit IN VARCHAR2 := FND_API.G_FALSE,
335: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
336: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY VARCHAR2,
339: x_msg_data OUT NOCOPY VARCHAR2
332: PROCEDURE default_org_parameters(
333: p_org IN VARCHAR2,
334: p_commit IN VARCHAR2 := FND_API.G_FALSE,
335: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
336: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
337: x_return_status OUT NOCOPY VARCHAR2,
338: x_msg_count OUT NOCOPY VARCHAR2,
339: x_msg_data OUT NOCOPY VARCHAR2
340: ) IS
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
354: FND_MSG_PUB.initialize;
355: END IF;
356: IF FND_GLOBAL.User_Id IS NULL THEN
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
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');
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:
361: -- Select the Values from Risk Library...
362:
382: x_msg_count => x_msg_count,
383: x_msg_data => x_msg_data);
384:
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:
384:
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;
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;
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;
394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
395:
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;
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;
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;
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;
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;
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(