DBA Data[Home] [Help]

APPS.LNS_UTILITY_PUB dependencies on FND_MSG_PUB

Line 175: FND_MSG_PUB.initialize;

171:
172: -- Initialize message list if p_init_msg_list is set to TRUE.
173: IF FND_API.to_Boolean(p_init_msg_list)
174: THEN
175: FND_MSG_PUB.initialize;
176: END IF;
177:
178: -- API body
179: vPlsql :=

Line 207: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

203: EXCEPTION
204: WHEN FND_API.G_EXC_ERROR THEN
205: ROLLBACK TO Validate_any_id_PVT;
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO Validate_any_id_PVT;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 212: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO Validate_any_id_PVT;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
213:
214: WHEN OTHERS THEN
215: ROLLBACK TO Validate_any_id_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

213:
214: WHEN OTHERS THEN
215: ROLLBACK TO Validate_any_id_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
218: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
219: END IF;
220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
221:

Line 218: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

214: WHEN OTHERS THEN
215: ROLLBACK TO Validate_any_id_PVT;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
218: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
219: END IF;
220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
221:
222: END Validate_any_id;

Line 220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
218: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
219: END IF;
220: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
221:
222: END Validate_any_id;
223:
224: PROCEDURE Validate_any_varchar(p_api_version IN NUMBER := 1.0,

Line 267: FND_MSG_PUB.initialize;

263:
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean(p_init_msg_list)
266: THEN
267: FND_MSG_PUB.initialize;
268: END IF;
269:
270: -- API body
271: --dbms_output.put_line('col is ' || p_col_value);

Line 301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

297: EXCEPTION
298: WHEN FND_API.G_EXC_ERROR THEN
299: ROLLBACK TO Validate_any_varchar_PVT;
300: x_return_status := FND_API.G_RET_STS_ERROR;
301: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO Validate_any_varchar_PVT;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 306: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO Validate_any_varchar_PVT;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
307:
308: WHEN OTHERS THEN
309: ROLLBACK TO Validate_any_varchar_PVT;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 311: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

307:
308: WHEN OTHERS THEN
309: ROLLBACK TO Validate_any_varchar_PVT;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
313: END IF;
314: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
315:

Line 312: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

308: WHEN OTHERS THEN
309: ROLLBACK TO Validate_any_varchar_PVT;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
313: END IF;
314: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
315:
316: END Validate_any_varchar;

Line 314: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
312: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
313: END IF;
314: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
315:
316: END Validate_any_varchar;
317:
318: PROCEDURE Validate_Lookup_CODE(p_api_version IN NUMBER := 1.0,

Line 361: FND_MSG_PUB.initialize;

357:
358: -- Initialize message list if p_init_msg_list is set to TRUE.
359: IF FND_API.to_Boolean(p_init_msg_list)
360: THEN
361: FND_MSG_PUB.initialize;
362: END IF;
363:
364: -- API body
365: l_lookup_code := '''' || p_lookup_code || '''';

Line 394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

390: EXCEPTION
391: WHEN FND_API.G_EXC_ERROR THEN
392: ROLLBACK TO Validate_any_varchar_PVT;
393: x_return_status := FND_API.G_RET_STS_ERROR;
394: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO Validate_any_varchar_PVT;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO Validate_any_varchar_PVT;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
400:
401: WHEN OTHERS THEN
402: ROLLBACK TO Validate_any_varchar_PVT;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

400:
401: WHEN OTHERS THEN
402: ROLLBACK TO Validate_any_varchar_PVT;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
405: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
406: END IF;
407: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
408:

Line 405: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

401: WHEN OTHERS THEN
402: ROLLBACK TO Validate_any_varchar_PVT;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
405: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
406: END IF;
407: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
408:
409: END Validate_LOOKUP_CODE;

Line 407: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
405: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
406: END IF;
407: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
408:
409: END Validate_LOOKUP_CODE;
410:
411: Procedure getObjectVersion(p_table_name IN varchar2

Line 445: FND_MSG_PUB.ADD;

441: )
442: THEN
443: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
444: FND_MESSAGE.SET_TOKEN('TABLE', p_table_name);
445: FND_MSG_PUB.ADD;
446: RAISE FND_API.G_EXC_ERROR;
447: END IF;
448:
449: x_object_version_number := nvl(l_object_version_number, 1) + 1;

Line 455: FND_MSG_PUB.ADD;

451: EXCEPTION WHEN NO_DATA_FOUND THEN
452: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
453: FND_MESSAGE.SET_TOKEN('RECORD', p_primary_key_name);
454: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_primary_key_value), 'null'));
455: FND_MSG_PUB.ADD;
456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: --RAISE FND_API.G_EXC_ERROR;
459: END getObjectVersion;

Line 456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

452: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
453: FND_MESSAGE.SET_TOKEN('RECORD', p_primary_key_name);
454: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_primary_key_value), 'null'));
455: FND_MSG_PUB.ADD;
456: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: --RAISE FND_API.G_EXC_ERROR;
459: END getObjectVersion;
460: