DBA Data[Home] [Help]

APPS.AMW_PARAMETERS_PVT_PKG dependencies on FND_API

Line 98: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 99: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 100: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

Line 112: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 113: IF FND_API.to_Boolean( p_init_msg_list ) 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');

Line 118: RAISE FND_API.G_EXC_ERROR;

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:

Line 185: WHEN FND_API.G_EXC_ERROR THEN

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:

Line 187: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 188: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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;

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_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;
193: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
194:

Line 192: x_return_status := FND_API.G_RET_STS_UNEXP_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:
195: WHEN OTHERS THEN
196: ROLLBACK;

Line 193: 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;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 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;

Line 202: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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,

Line 213: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 214: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 215: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

Line 227: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 228: IF FND_API.to_Boolean( p_init_msg_list ) 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');

Line 233: RAISE FND_API.G_EXC_ERROR;

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:

Line 258: WHEN FND_API.G_EXC_ERROR THEN

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:

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 261: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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;

Line 263: WHEN FND_API.G_EXC_UNEXPECTED_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;
266: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
267:

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_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:
268: WHEN OTHERS THEN
269: ROLLBACK;

Line 266: 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;
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 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;

Line 275: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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:

Line 334: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 335: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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

Line 336: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

Line 352: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 353: IF FND_API.to_Boolean( p_init_msg_list ) 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');

Line 358: RAISE FND_API.G_EXC_ERROR;

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:

Line 386: WHEN FND_API.G_EXC_ERROR THEN

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:

Line 388: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 389: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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;

Line 391: WHEN FND_API.G_EXC_UNEXPECTED_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;
394: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
395:

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_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:
396: WHEN OTHERS THEN
397: ROLLBACK;

Line 394: 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;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 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;

Line 403: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

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(