eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_RSG_PUB_API_PKG dependencies on FND_MSG_PUB

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

162: WHEN dup_val_on_index THEN
163: RETURN;
164: WHEN OTHERS THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
167: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
168: END IF;
169: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
170: END create_property;

Line 167: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

163: RETURN;
164: WHEN OTHERS THEN
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
167: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
168: END IF;
169: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
170: END create_property;
171:

Line 223: FND_MSG_PUB.initialize;

219: l_object_owner VARCHAR2(50);
220: l_depend_object_owner VARCHAR2(50);
221: l_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617
222: BEGIN
223: FND_MSG_PUB.initialize;
224:
225: -- since page designer passes in fnd_form_function name instead of object name
226: -- we need take care of _OA problem by calling get_page_name_by_func, if object type is PAGE
227: IF (p_object_type = 'PAGE') THEN

Line 256: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

252: ELSE
253: x_msg_data := 'BIS_REGION_NOT_EXISTING_MSG';
254: END IF;
255: x_return_status := fnd_api.g_ret_sts_error;
256: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
257: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, x_msg_data);
258: END IF;
259: RETURN;
260: END IF;

Line 257: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, x_msg_data);

253: x_msg_data := 'BIS_REGION_NOT_EXISTING_MSG';
254: END IF;
255: x_return_status := fnd_api.g_ret_sts_error;
256: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
257: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, x_msg_data);
258: END IF;
259: RETURN;
260: END IF;
261:

Line 267: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

263: object_owner_validation(l_object_owner, x_return_status);
264: IF (x_return_status = 'N') THEN
265: x_msg_data := 'BIS_BIA_RSG_INVALID_OBJ_OWNER';
266: x_return_status := fnd_api.g_ret_sts_error;
267: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
268: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_OBJ_OWNER');
269: END IF;
270: RETURN;
271: END IF;

Line 268: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_OBJ_OWNER');

264: IF (x_return_status = 'N') THEN
265: x_msg_data := 'BIS_BIA_RSG_INVALID_OBJ_OWNER';
266: x_return_status := fnd_api.g_ret_sts_error;
267: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
268: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_OBJ_OWNER');
269: END IF;
270: RETURN;
271: END IF;
272:

Line 283: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

279: ELSE
280: x_msg_data := 'BIS_REGION_NOT_EXISTING_MSG';
281: END IF;
282: x_return_status := fnd_api.g_ret_sts_error;
283: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
284: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, x_msg_data);
285: END IF;
286: RETURN;
287: END IF;

Line 284: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, x_msg_data);

280: x_msg_data := 'BIS_REGION_NOT_EXISTING_MSG';
281: END IF;
282: x_return_status := fnd_api.g_ret_sts_error;
283: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
284: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, x_msg_data);
285: END IF;
286: RETURN;
287: END IF;
288:

Line 294: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

290: object_owner_validation(l_depend_object_owner, x_return_status);
291: IF (x_return_status = 'N') THEN
292: x_msg_data := 'BIS_BIA_RSG_INV_DEP_OBJ_OWNER';
293: x_return_status := fnd_api.g_ret_sts_error;
294: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
295: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_DEP_OBJ_OWNER');
296: END IF;
297: RETURN;
298: END IF;

Line 295: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_DEP_OBJ_OWNER');

291: IF (x_return_status = 'N') THEN
292: x_msg_data := 'BIS_BIA_RSG_INV_DEP_OBJ_OWNER';
293: x_return_status := fnd_api.g_ret_sts_error;
294: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
295: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_DEP_OBJ_OWNER');
296: END IF;
297: RETURN;
298: END IF;
299:

Line 305: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

301: IF (p_enabled_flag IS NOT NULL AND p_enabled_flag <> 'Y'
302: AND p_enabled_flag <> 'N') THEN
303: x_return_status := fnd_api.g_ret_sts_error;
304: x_msg_data := 'BIS_BIA_RSG_INV_ENABLED_FLAG';
305: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
306: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');
307: END IF;
308: RETURN;
309: END IF;

Line 306: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');

302: AND p_enabled_flag <> 'N') THEN
303: x_return_status := fnd_api.g_ret_sts_error;
304: x_msg_data := 'BIS_BIA_RSG_INV_ENABLED_FLAG';
305: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
306: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');
307: END IF;
308: RETURN;
309: END IF;
310:

Line 344: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

340:
341: EXCEPTION
342: WHEN dup_val_on_index THEN -- unique constraint violation
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
345: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
346: END IF;
347: x_msg_data := 'BIS_BIA_RSG_DUP_DEP_REC';
348: WHEN OTHERS THEN

Line 345: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

341: EXCEPTION
342: WHEN dup_val_on_index THEN -- unique constraint violation
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
345: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
346: END IF;
347: x_msg_data := 'BIS_BIA_RSG_DUP_DEP_REC';
348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

346: END IF;
347: x_msg_data := 'BIS_BIA_RSG_DUP_DEP_REC';
348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
352: END IF;
353: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
354: END create_dependency;

Line 351: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

347: x_msg_data := 'BIS_BIA_RSG_DUP_DEP_REC';
348: WHEN OTHERS THEN
349: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
350: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
351: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
352: END IF;
353: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
354: END create_dependency;
355:

Line 369: FND_MSG_PUB.initialize;

365: ) IS
366: v_procedure_name VARCHAR2(50) := 'Update_Dependency';
367: l_object_name bis_obj_dependency.object_name%type; --Enhancement 4106617
368: BEGIN
369: FND_MSG_PUB.initialize;
370:
371: -- since page designer passes in fnd_form_function name instead of object name
372: -- we need take care of _OA problem by calling get_page_name_by_func, if object type is PAGE
373: IF (p_object_type = 'PAGE') THEN

Line 384: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

380: IF (p_enabled_flag IS NOT NULL AND p_enabled_flag <> 'Y'
381: AND p_enabled_flag <> 'N') THEN
382: x_return_status := fnd_api.g_ret_sts_error;
383: x_msg_data := 'BIS_BIA_RSG_INV_ENABLED_FLAG';
384: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
385: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');
386: END IF;
387: RETURN;
388: END IF;

Line 385: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');

381: AND p_enabled_flag <> 'N') THEN
382: x_return_status := fnd_api.g_ret_sts_error;
383: x_msg_data := 'BIS_BIA_RSG_INV_ENABLED_FLAG';
384: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
385: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');
386: END IF;
387: RETURN;
388: END IF;
389:

Line 406: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

402: l_object_name, p_object_type, p_depend_object_name, p_depend_object_type;
403:
404: --IF (SQL%notfound) THEN
405: -- x_return_status := FND_API.G_RET_STS_ERROR;
406: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
407: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
408: -- END IF;
409: -- x_msg_data := 'BIS_BIA_RSG_DEP_NOT_EXISTS';
410: --END IF;

Line 407: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

403:
404: --IF (SQL%notfound) THEN
405: -- x_return_status := FND_API.G_RET_STS_ERROR;
406: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
407: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
408: -- END IF;
409: -- x_msg_data := 'BIS_BIA_RSG_DEP_NOT_EXISTS';
410: --END IF;
411:

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

411:
412: EXCEPTION
413: WHEN OTHERS THEN
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
416: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
417: END IF;
418: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
419: END Update_Dependency;

Line 416: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

412: EXCEPTION
413: WHEN OTHERS THEN
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
416: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
417: END IF;
418: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
419: END Update_Dependency;
420:

Line 459: FND_MSG_PUB.initialize;

455: ) IS
456: v_procedure_name VARCHAR2(50) := 'Delete_Dependency';
457: l_object_name VARCHAR2(480); --Enhancement 4106617
458: BEGIN
459: FND_MSG_PUB.initialize;
460:
461: -- since page designer passes in fnd_form_function name instead of object name
462: -- we need take care of _OA problem by calling get_page_name_by_func, if object type is PAGE
463: IF (p_object_type = 'PAGE') THEN

Line 479: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

475:
476: -- as per discussion with Tianyi, comment out the following code
477: -- IF (SQL%notfound) THEN
478: -- x_return_status := FND_API.G_RET_STS_ERROR;
479: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
480: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
481: -- END IF;
482: -- x_msg_data := 'BIS_BIA_RSG_DEP_NOT_EXISTS';
483: -- END IF;

Line 480: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

476: -- as per discussion with Tianyi, comment out the following code
477: -- IF (SQL%notfound) THEN
478: -- x_return_status := FND_API.G_RET_STS_ERROR;
479: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
480: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
481: -- END IF;
482: -- x_msg_data := 'BIS_BIA_RSG_DEP_NOT_EXISTS';
483: -- END IF;
484:

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

488:
489: EXCEPTION
490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
493: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
494: END IF;
495: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
496: END Delete_Dependency;

Line 493: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

489: EXCEPTION
490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
493: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
494: END IF;
495: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
496: END Delete_Dependency;
497:

Line 543: FND_MSG_PUB.initialize;

539: FROM bis_obj_dependency
540: WHERE object_type = 'PAGE' AND object_name = p_page_name;
541: v_dep c_deps%ROWTYPE;
542: BEGIN
543: FND_MSG_PUB.initialize;
544:
545: -- since page designer passes in fnd_form_function name instead of object name
546: -- we need take care of _OA problem by calling get_page_name_by_func, if object type is PAGE
547: l_object_name := get_page_name_by_func(p_object_name);

Line 557: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

553: -- using l_object_name, 'PAGE';
554:
555: -- IF (SQL%notfound) THEN
556: -- x_return_status := FND_API.G_RET_STS_ERROR;
557: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
558: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
559: -- END IF;
560: -- x_msg_data := 'BIS_BIA_RSG_PAGE_NOT_EXISTS';
561: -- END IF;

Line 558: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

554:
555: -- IF (SQL%notfound) THEN
556: -- x_return_status := FND_API.G_RET_STS_ERROR;
557: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
558: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
559: -- END IF;
560: -- x_msg_data := 'BIS_BIA_RSG_PAGE_NOT_EXISTS';
561: -- END IF;
562:

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

579: CLOSE c_deps;
580: EXCEPTION
581: WHEN OTHERS THEN
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
584: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
585: END IF;
586: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
587: END Delete_Page_Dependencies;

Line 584: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

580: EXCEPTION
581: WHEN OTHERS THEN
582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
583: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
584: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
585: END IF;
586: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
587: END Delete_Page_Dependencies;
588:

Line 600: FND_MSG_PUB.initialize;

596: ) IS
597: v_procedure_name VARCHAR2(50) := 'Update_Property';
598: l_object_name VARCHAR2(480); --Enhancement 4106617
599: BEGIN
600: FND_MSG_PUB.initialize;
601:
602: -- since page designer passes in fnd_form_function name instead of object name
603: -- we need take care of _OA problem by calling get_page_name_by_func, if object type is PAGE
604: IF (p_object_type = 'PAGE') THEN

Line 615: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

611: IF (p_dimension_flag IS NOT NULL AND p_dimension_flag <> 'Y'
612: AND p_dimension_flag <> 'N') THEN
613: x_return_status := fnd_api.g_ret_sts_error;
614: x_msg_data := 'BIS_BIA_RSG_INVALID_DIM_FLAG';
615: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
616: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_DIM_FLAG');
617: END IF;
618: RETURN;
619: END IF;

Line 616: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_DIM_FLAG');

612: AND p_dimension_flag <> 'N') THEN
613: x_return_status := fnd_api.g_ret_sts_error;
614: x_msg_data := 'BIS_BIA_RSG_INVALID_DIM_FLAG';
615: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
616: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_DIM_FLAG');
617: END IF;
618: RETURN;
619: END IF;
620:

Line 635: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

631: l_object_name, p_object_type;
632:
633: --IF (SQL%notfound) THEN
634: -- x_return_status := FND_API.G_RET_STS_ERROR;
635: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
636: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
637: -- END IF;
638: -- x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
639: --END IF;

Line 636: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

632:
633: --IF (SQL%notfound) THEN
634: -- x_return_status := FND_API.G_RET_STS_ERROR;
635: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
636: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
637: -- END IF;
638: -- x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
639: --END IF;
640:

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

640:
641: EXCEPTION
642: WHEN OTHERS THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
645: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
646: END IF;
647: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
648: END update_property;

Line 645: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

641: EXCEPTION
642: WHEN OTHERS THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
645: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
646: END IF;
647: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
648: END update_property;
649:

Line 661: FND_MSG_PUB.initialize;

657: ) IS
658: v_procedure_name VARCHAR2(50) := 'Update_Property_Dim_Flag';
659: l_object_name VARCHAR2(480); --Enhancement 4106617
660: BEGIN
661: FND_MSG_PUB.initialize;
662:
663: -- since page designer passes in fnd_form_function name instead of object name
664: -- we need take care of _OA problem by calling get_page_name_by_func, if object type is PAGE
665: IF (p_object_type = 'PAGE') THEN

Line 676: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

672: IF (p_dimension_flag IS NOT NULL AND p_dimension_flag <> 'Y'
673: AND p_dimension_flag <> 'N') THEN
674: x_return_status := fnd_api.g_ret_sts_error;
675: x_msg_data := 'BIS_BIA_RSG_INVALID_DIM_FLAG';
676: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
677: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_DIM_FLAG');
678: END IF;
679: RETURN;
680: END IF;

Line 677: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_DIM_FLAG');

673: AND p_dimension_flag <> 'N') THEN
674: x_return_status := fnd_api.g_ret_sts_error;
675: x_msg_data := 'BIS_BIA_RSG_INVALID_DIM_FLAG';
676: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
677: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_DIM_FLAG');
678: END IF;
679: RETURN;
680: END IF;
681:

Line 695: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

691: l_object_name, p_object_type;
692:
693: --IF (SQL%notfound) THEN
694: -- x_return_status := FND_API.G_RET_STS_ERROR;
695: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
696: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
697: -- END IF;
698: -- x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
699: -- END IF;

Line 696: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

692:
693: --IF (SQL%notfound) THEN
694: -- x_return_status := FND_API.G_RET_STS_ERROR;
695: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
696: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
697: -- END IF;
698: -- x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
699: -- END IF;
700:

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

700:
701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
705: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
706: END IF;
707: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
708: END update_property_dim_flag;

Line 705: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

701: EXCEPTION
702: WHEN OTHERS THEN
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
705: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
706: END IF;
707: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
708: END update_property_dim_flag;
709:

Line 720: FND_MSG_PUB.initialize;

716: ) IS
717: v_procedure_name VARCHAR2(50) := 'Update_Property_Custom_API';
718: l_object_name VARCHAR2(480); --Enhancement 4106617
719: BEGIN
720: FND_MSG_PUB.initialize;
721:
722: -- since page designer passes in fnd_form_function name instead of object name
723: -- we need take care of _OA problem by calling get_page_name_by_func, if object type is PAGE
724: IF (p_object_type = 'PAGE') THEN

Line 743: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

739: l_object_name, p_object_type;
740:
741: --IF (SQL%notfound) THEN
742: -- x_return_status := FND_API.G_RET_STS_ERROR;
743: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
744: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
745: -- END IF;
746: -- x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
747: --END IF;

Line 744: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

740:
741: --IF (SQL%notfound) THEN
742: -- x_return_status := FND_API.G_RET_STS_ERROR;
743: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
744: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
745: -- END IF;
746: -- x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
747: --END IF;
748:

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

748:
749: EXCEPTION
750: WHEN OTHERS THEN
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
753: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
754: END IF;
755: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
756: END update_property_custom_api;

Line 753: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

749: EXCEPTION
750: WHEN OTHERS THEN
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
753: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
754: END IF;
755: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
756: END update_property_custom_api;
757: /**

Line 771: FND_MSG_PUB.initialize;

767: ) IS
768: v_procedure_name VARCHAR2(50) := 'Update_Property_Snapshotlog';
769: l_object_name VARCHAR2(80);
770: BEGIN
771: FND_MSG_PUB.initialize;
772:
773: -- since page designer passes in fnd_form_function name instead of object name
774: -- we need take care of _OA problem by calling get_page_name_by_func, if object type is PAGE
775: IF (p_object_type = 'PAGE') THEN

Line 794: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

790: l_object_name, p_object_type;
791:
792: --IF (SQL%notfound) THEN
793: -- x_return_status := FND_API.G_RET_STS_ERROR;
794: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
795: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
796: -- END IF;
797: -- x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
798: --END IF;

Line 795: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

791:
792: --IF (SQL%notfound) THEN
793: -- x_return_status := FND_API.G_RET_STS_ERROR;
794: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
795: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
796: -- END IF;
797: -- x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
798: --END IF;
799:

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

799:
800: EXCEPTION
801: WHEN OTHERS THEN
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
803: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
804: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
805: END IF;
806: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
807: END update_property_snapshotlog;

Line 804: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

800: EXCEPTION
801: WHEN OTHERS THEN
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
803: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
804: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
805: END IF;
806: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
807: END update_property_snapshotlog;
808: */

Line 825: FND_MSG_PUB.initialize;

821: v_procedure_name VARCHAR2(50) := 'Get_Property_Snapshotlog';
822: v_snapshot_log VARCHAR2(4000);
823: l_object_name VARCHAR2(80);
824: BEGIN
825: FND_MSG_PUB.initialize;
826:
827: -- since page designer passes in fnd_form_function name instead of object name
828: -- we need take care of _OA problem by calling get_page_name_by_func, if object type is PAGE
829: IF (p_object_type = 'PAGE') THEN

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

844:
845: EXCEPTION
846: WHEN no_data_found THEN
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
849: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
850: END IF;
851: x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
852: RETURN NULL;

Line 849: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

845: EXCEPTION
846: WHEN no_data_found THEN
847: x_return_status := FND_API.G_RET_STS_ERROR;
848: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
849: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
850: END IF;
851: x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
852: RETURN NULL;
853: WHEN OTHERS THEN

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

851: x_msg_data := 'BIS_BIA_RSG_PROP_NOT_EXISTS';
852: RETURN NULL;
853: WHEN OTHERS THEN
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
856: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
857: END IF;
858: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
859: RETURN NULL;

Line 856: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

852: RETURN NULL;
853: WHEN OTHERS THEN
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
856: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
857: END IF;
858: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
859: RETURN NULL;
860: END get_property_snapshotlog;

Line 926: FND_MSG_PUB.initialize;

922: ) IS
923: v_procedure_name VARCHAR2(50) := 'Create_Linkage';
924: v_appl_id NUMBER;
925: BEGIN
926: FND_MSG_PUB.initialize;
927:
928: -- page is not allowed to have refresh program associated
929: IF (p_object_type = 'PAGE') THEN
930: x_msg_data := 'BIS_BIA_RSG_NO_PAGE_LINKAGE';

Line 932: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

928: -- page is not allowed to have refresh program associated
929: IF (p_object_type = 'PAGE') THEN
930: x_msg_data := 'BIS_BIA_RSG_NO_PAGE_LINKAGE';
931: x_return_status := fnd_api.g_ret_sts_error;
932: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
933: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_NO_PAGE_LINKAGE');
934: END IF;
935: RETURN;
936: END IF;

Line 933: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_NO_PAGE_LINKAGE');

929: IF (p_object_type = 'PAGE') THEN
930: x_msg_data := 'BIS_BIA_RSG_NO_PAGE_LINKAGE';
931: x_return_status := fnd_api.g_ret_sts_error;
932: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
933: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_NO_PAGE_LINKAGE');
934: END IF;
935: RETURN;
936: END IF;
937:

Line 945: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

941: object_name_validation(p_object_type, p_object_name, x_return_status);
942: IF (x_return_status = 'N') THEN
943: x_msg_data := 'BIS_BIA_RSG_INVALID_OBJ';
944: x_return_status := fnd_api.g_ret_sts_error;
945: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
946: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_OBJ');
947: END IF;
948: RETURN;
949: END IF;

Line 946: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_OBJ');

942: IF (x_return_status = 'N') THEN
943: x_msg_data := 'BIS_BIA_RSG_INVALID_OBJ';
944: x_return_status := fnd_api.g_ret_sts_error;
945: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
946: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_OBJ');
947: END IF;
948: RETURN;
949: END IF;
950:

Line 958: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

954: object_owner_validation(p_object_owner, x_return_status);
955: IF (x_return_status = 'N') THEN
956: x_msg_data := 'BIS_BIA_RSG_INVALID_OBJ_OWNER';
957: x_return_status := fnd_api.g_ret_sts_error;
958: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
959: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_OBJ_OWNER');
960: END IF;
961: RETURN;
962: END IF;

Line 959: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_OBJ_OWNER');

955: IF (x_return_status = 'N') THEN
956: x_msg_data := 'BIS_BIA_RSG_INVALID_OBJ_OWNER';
957: x_return_status := fnd_api.g_ret_sts_error;
958: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
959: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_OBJ_OWNER');
960: END IF;
961: RETURN;
962: END IF;
963:

Line 971: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

967: prog_validation(P_CONC_PROG_NAME, P_APPL_SHORT_NAME, x_return_status);
968: IF (x_return_status = 'N') THEN
969: x_msg_data := 'BIS_BIA_RSG_INVALID_CONC_PROG';
970: x_return_status := fnd_api.g_ret_sts_error;
971: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
972: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_CONC_PROG');
973: END IF;
974: RETURN;
975: END IF;

Line 972: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_CONC_PROG');

968: IF (x_return_status = 'N') THEN
969: x_msg_data := 'BIS_BIA_RSG_INVALID_CONC_PROG';
970: x_return_status := fnd_api.g_ret_sts_error;
971: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
972: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INVALID_CONC_PROG');
973: END IF;
974: RETURN;
975: END IF;
976:

Line 983: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

979: -- validate enabled flag
980: IF (p_enabled_flag IS NOT NULL AND p_enabled_flag <> 'Y' AND p_enabled_flag <> 'N') THEN
981: x_return_status := fnd_api.g_ret_sts_error;
982: x_msg_data := 'BIS_BIA_RSG_INV_ENABLED_FLAG';
983: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
984: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');
985: END IF;
986: RETURN;
987: END IF;

Line 984: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');

980: IF (p_enabled_flag IS NOT NULL AND p_enabled_flag <> 'Y' AND p_enabled_flag <> 'N') THEN
981: x_return_status := fnd_api.g_ret_sts_error;
982: x_msg_data := 'BIS_BIA_RSG_INV_ENABLED_FLAG';
983: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
984: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');
985: END IF;
986: RETURN;
987: END IF;
988:

Line 996: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

992: loading_mode_validation(p_refresh_mode, x_return_status);
993: IF (x_return_status = 'N') THEN
994: x_msg_data := 'BIS_BIA_RSG_INV_LOADING_MODE';
995: x_return_status := fnd_api.g_ret_sts_error;
996: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
997: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_LOADING_MODE');
998: END IF;
999: RETURN;
1000: END IF;

Line 997: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_LOADING_MODE');

993: IF (x_return_status = 'N') THEN
994: x_msg_data := 'BIS_BIA_RSG_INV_LOADING_MODE';
995: x_return_status := fnd_api.g_ret_sts_error;
996: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
997: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_LOADING_MODE');
998: END IF;
999: RETURN;
1000: END IF;
1001:

Line 1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1035:
1036: EXCEPTION
1037: WHEN dup_val_on_index THEN -- unique constraint violation
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1040: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1041: END IF;
1042: x_msg_data := 'BIS_BIA_RSG_DUP_LINKAGE_REC';
1043: WHEN OTHERS THEN

Line 1040: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1036: EXCEPTION
1037: WHEN dup_val_on_index THEN -- unique constraint violation
1038: x_return_status := FND_API.G_RET_STS_ERROR;
1039: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1040: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1041: END IF;
1042: x_msg_data := 'BIS_BIA_RSG_DUP_LINKAGE_REC';
1043: WHEN OTHERS THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1041: END IF;
1042: x_msg_data := 'BIS_BIA_RSG_DUP_LINKAGE_REC';
1043: WHEN OTHERS THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1045: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1046: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1047: END IF;
1048: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1049: END create_linkage;

Line 1046: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1042: x_msg_data := 'BIS_BIA_RSG_DUP_LINKAGE_REC';
1043: WHEN OTHERS THEN
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1045: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1046: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1047: END IF;
1048: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1049: END create_linkage;
1050:

Line 1063: FND_MSG_PUB.initialize;

1059: x_msg_data OUT NOCOPY VARCHAR2
1060: ) IS
1061: v_procedure_name VARCHAR2(50) := 'Update_Linkage';
1062: BEGIN
1063: FND_MSG_PUB.initialize;
1064:
1065: -- validate enabled_flag
1066: IF (p_enabled_flag IS NOT NULL AND p_enabled_flag <> 'Y'
1067: AND p_enabled_flag <> 'N') THEN

Line 1070: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

1066: IF (p_enabled_flag IS NOT NULL AND p_enabled_flag <> 'Y'
1067: AND p_enabled_flag <> 'N') THEN
1068: x_return_status := fnd_api.g_ret_sts_error;
1069: x_msg_data := 'BIS_BIA_RSG_INV_ENABLED_FLAG';
1070: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1071: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');
1072: END IF;
1073: RETURN;
1074: END IF;

Line 1071: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');

1067: AND p_enabled_flag <> 'N') THEN
1068: x_return_status := fnd_api.g_ret_sts_error;
1069: x_msg_data := 'BIS_BIA_RSG_INV_ENABLED_FLAG';
1070: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1071: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');
1072: END IF;
1073: RETURN;
1074: END IF;
1075:

Line 1083: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

1079: loading_mode_validation(p_refresh_mode, x_return_status);
1080: IF (x_return_status = 'N') THEN
1081: x_msg_data := 'BIS_BIA_RSG_INV_LOADING_MODE';
1082: x_return_status := fnd_api.g_ret_sts_error;
1083: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1084: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_LOADING_MODE');
1085: END IF;
1086: RETURN;
1087: END IF;

Line 1084: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_LOADING_MODE');

1080: IF (x_return_status = 'N') THEN
1081: x_msg_data := 'BIS_BIA_RSG_INV_LOADING_MODE';
1082: x_return_status := fnd_api.g_ret_sts_error;
1083: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1084: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_LOADING_MODE');
1085: END IF;
1086: RETURN;
1087: END IF;
1088:

Line 1108: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1104: --dbms_output.put_line('3');
1105:
1106: -- IF (SQL%notfound) THEN
1107: -- x_return_status := FND_API.G_RET_STS_ERROR;
1108: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1109: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1110: -- END IF;
1111: -- x_msg_data := 'BIS_BIA_RSG_LINKAGE_NOT_EXISTS';
1112: --END IF;

Line 1109: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1105:
1106: -- IF (SQL%notfound) THEN
1107: -- x_return_status := FND_API.G_RET_STS_ERROR;
1108: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1109: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1110: -- END IF;
1111: -- x_msg_data := 'BIS_BIA_RSG_LINKAGE_NOT_EXISTS';
1112: --END IF;
1113:

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

1115:
1116: EXCEPTION
1117: WHEN OTHERS THEN
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1120: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1121: END IF;
1122: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1123: END update_linkage;

Line 1120: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1116: EXCEPTION
1117: WHEN OTHERS THEN
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1120: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1121: END IF;
1122: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1123: END update_linkage;
1124:

Line 1137: FND_MSG_PUB.initialize;

1133: x_msg_data OUT NOCOPY VARCHAR2
1134: ) IS
1135: v_procedure_name VARCHAR2(50) := 'Update_Linkage_Enabled_Flag';
1136: BEGIN
1137: FND_MSG_PUB.initialize;
1138:
1139: -- validate enabled_flag
1140: IF (p_enabled_flag IS NOT NULL AND p_enabled_flag <> 'Y'
1141: AND p_enabled_flag <> 'N') THEN

Line 1144: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

1140: IF (p_enabled_flag IS NOT NULL AND p_enabled_flag <> 'Y'
1141: AND p_enabled_flag <> 'N') THEN
1142: x_return_status := fnd_api.g_ret_sts_error;
1143: x_msg_data := 'BIS_BIA_RSG_INV_ENABLED_FLAG';
1144: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1145: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');
1146: END IF;
1147: RETURN;
1148: END IF;

Line 1145: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');

1141: AND p_enabled_flag <> 'N') THEN
1142: x_return_status := fnd_api.g_ret_sts_error;
1143: x_msg_data := 'BIS_BIA_RSG_INV_ENABLED_FLAG';
1144: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1145: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_ENABLED_FLAG');
1146: END IF;
1147: RETURN;
1148: END IF;
1149:

Line 1164: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1160: p_object_name, p_object_type, p_conc_prog_name, p_appl_short_name;
1161:
1162: --IF (SQL%notfound) THEN
1163: -- x_return_status := FND_API.G_RET_STS_ERROR;
1164: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1165: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1166: -- END IF;
1167: -- x_msg_data := 'BIS_BIA_RSG_LINKAGE_NOT_EXISTS';
1168: --END IF;

Line 1165: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1161:
1162: --IF (SQL%notfound) THEN
1163: -- x_return_status := FND_API.G_RET_STS_ERROR;
1164: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1165: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1166: -- END IF;
1167: -- x_msg_data := 'BIS_BIA_RSG_LINKAGE_NOT_EXISTS';
1168: --END IF;
1169:

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

1169:
1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1173: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1174: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1175: END IF;
1176: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1177: END Update_Linkage_Enabled_Flag;

Line 1174: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1170: EXCEPTION
1171: WHEN OTHERS THEN
1172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1173: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1174: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1175: END IF;
1176: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1177: END Update_Linkage_Enabled_Flag;
1178:

Line 1191: FND_MSG_PUB.initialize;

1187: x_msg_data OUT NOCOPY VARCHAR2
1188: ) IS
1189: v_procedure_name VARCHAR2(50) := 'Update_Linkage_Refresh_Mode';
1190: BEGIN
1191: FND_MSG_PUB.initialize;
1192:
1193: --validate refresh mode
1194: loading_mode_validation(p_refresh_mode, x_return_status);
1195: IF (x_return_status = 'N') THEN

Line 1198: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

1194: loading_mode_validation(p_refresh_mode, x_return_status);
1195: IF (x_return_status = 'N') THEN
1196: x_msg_data := 'BIS_BIA_RSG_INV_LOADING_MODE';
1197: x_return_status := fnd_api.g_ret_sts_error;
1198: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1199: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_LOADING_MODE');
1200: END IF;
1201: RETURN;
1202: END IF;

Line 1199: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_LOADING_MODE');

1195: IF (x_return_status = 'N') THEN
1196: x_msg_data := 'BIS_BIA_RSG_INV_LOADING_MODE';
1197: x_return_status := fnd_api.g_ret_sts_error;
1198: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1199: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_LOADING_MODE');
1200: END IF;
1201: RETURN;
1202: END IF;
1203:

Line 1218: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1214: p_object_name, p_object_type, p_conc_prog_name, p_appl_short_name;
1215:
1216: --IF (SQL%notfound) THEN
1217: -- x_return_status := FND_API.G_RET_STS_ERROR;
1218: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1219: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1220: -- END IF;
1221: -- x_msg_data := 'BIS_BIA_RSG_LINKAGE_NOT_EXISTS';
1222: --END IF;

Line 1219: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1215:
1216: --IF (SQL%notfound) THEN
1217: -- x_return_status := FND_API.G_RET_STS_ERROR;
1218: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1219: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1220: -- END IF;
1221: -- x_msg_data := 'BIS_BIA_RSG_LINKAGE_NOT_EXISTS';
1222: --END IF;
1223:

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

1223:
1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1228: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1229: END IF;
1230: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1231: END update_linkage_refresh_mode;

Line 1228: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1224: EXCEPTION
1225: WHEN OTHERS THEN
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1227: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1228: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1229: END IF;
1230: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1231: END update_linkage_refresh_mode;
1232:

Line 1243: FND_MSG_PUB.initialize;

1239: x_msg_data OUT NOCOPY VARCHAR2
1240: ) IS
1241: v_procedure_name VARCHAR2(50) := 'Delete_Linkage';
1242: BEGIN
1243: FND_MSG_PUB.initialize;
1244: x_return_status := FND_API.G_RET_STS_SUCCESS;
1245:
1246: execute immediate 'delete from bis_obj_prog_linkages
1247: WHERE object_name = :1 AND object_type = :2

Line 1254: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1250: p_conc_prog_name, p_appl_short_name;
1251:
1252: --IF (SQL%notfound) THEN
1253: -- x_return_status := FND_API.G_RET_STS_ERROR;
1254: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1255: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1256: -- END IF;
1257: -- x_msg_data := 'BIS_BIA_RSG_LINKAGE_NOT_EXISTS';
1258: --END IF;

Line 1255: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1251:
1252: --IF (SQL%notfound) THEN
1253: -- x_return_status := FND_API.G_RET_STS_ERROR;
1254: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1255: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1256: -- END IF;
1257: -- x_msg_data := 'BIS_BIA_RSG_LINKAGE_NOT_EXISTS';
1258: --END IF;
1259:

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

1259:
1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1264: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1265: END IF;
1266: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1267: END Delete_Linkage;

Line 1264: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1260: EXCEPTION
1261: WHEN OTHERS THEN
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1264: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1265: END IF;
1266: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1267: END Delete_Linkage;
1268:

Line 1309: FND_MSG_PUB.initialize;

1305: x_msg_data OUT NOCOPY VARCHAR2
1306: ) IS
1307: v_procedure_name VARCHAR2(50) := 'Delete_Obj_Linkages';
1308: BEGIN
1309: FND_MSG_PUB.initialize;
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311:
1312: execute immediate 'delete from bis_obj_prog_linkages
1313: WHERE object_name = :1 AND object_type = :2'

Line 1318: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1314: using p_object_name, p_object_type;
1315:
1316: --IF (SQL%notfound) THEN
1317: -- x_return_status := FND_API.G_RET_STS_ERROR;
1318: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1319: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1320: -- END IF;
1321: -- x_msg_data := 'BIS_BIA_RSG_NO_OBJ_LINKAGES';
1322: --END IF;

Line 1319: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1315:
1316: --IF (SQL%notfound) THEN
1317: -- x_return_status := FND_API.G_RET_STS_ERROR;
1318: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1319: -- FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1320: -- END IF;
1321: -- x_msg_data := 'BIS_BIA_RSG_NO_OBJ_LINKAGES';
1322: --END IF;
1323:

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

1323:
1324: EXCEPTION
1325: WHEN OTHERS THEN
1326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1327: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1328: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1329: END IF;
1330: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1331: END Delete_Obj_Linkages;

Line 1328: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1324: EXCEPTION
1325: WHEN OTHERS THEN
1326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1327: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1328: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1329: END IF;
1330: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1331: END Delete_Obj_Linkages;
1332:

Line 1361: FND_MSG_PUB.initialize;

1357: WHERE object_type = p_obj_type
1358: START WITH depend_object_name = p_dep_obj_name AND depend_object_type = p_dep_obj_type
1359: CONNECT BY PRIOR object_name = depend_object_name AND PRIOR object_type = depend_object_type;
1360: BEGIN
1361: FND_MSG_PUB.initialize;
1362: x_return_status := FND_API.G_RET_STS_SUCCESS;
1363:
1364: IF (p_dep_obj_name IS NULL OR p_dep_obj_name = '') THEN
1365: x_msg_data := 'BIS_BIA_RSG_INV_DEP_OBJ_NAME';

Line 1367: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

1363:
1364: IF (p_dep_obj_name IS NULL OR p_dep_obj_name = '') THEN
1365: x_msg_data := 'BIS_BIA_RSG_INV_DEP_OBJ_NAME';
1366: x_return_status := fnd_api.g_ret_sts_error;
1367: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1368: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_DEP_OBJ_NAME');
1369: END IF;
1370: RETURN x_parent_obj_table;
1371: END IF;

Line 1368: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_DEP_OBJ_NAME');

1364: IF (p_dep_obj_name IS NULL OR p_dep_obj_name = '') THEN
1365: x_msg_data := 'BIS_BIA_RSG_INV_DEP_OBJ_NAME';
1366: x_return_status := fnd_api.g_ret_sts_error;
1367: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1368: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_DEP_OBJ_NAME');
1369: END IF;
1370: RETURN x_parent_obj_table;
1371: END IF;
1372:

Line 1377: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

1373: IF (p_dep_obj_type IS NULL OR
1374: p_dep_obj_type NOT IN ('TABLE','VIEW', 'MV', 'PORTLET', 'PAGE', 'REPORT')) THEN
1375: x_msg_data := 'BIS_BIA_RSG_INV_DEP_OBJ_TYPE';
1376: x_return_status := fnd_api.g_ret_sts_error;
1377: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1378: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_DEP_OBJ_TYPE');
1379: END IF;
1380: RETURN x_parent_obj_table;
1381: END IF;

Line 1378: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_DEP_OBJ_TYPE');

1374: p_dep_obj_type NOT IN ('TABLE','VIEW', 'MV', 'PORTLET', 'PAGE', 'REPORT')) THEN
1375: x_msg_data := 'BIS_BIA_RSG_INV_DEP_OBJ_TYPE';
1376: x_return_status := fnd_api.g_ret_sts_error;
1377: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1378: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_DEP_OBJ_TYPE');
1379: END IF;
1380: RETURN x_parent_obj_table;
1381: END IF;
1382:

Line 1387: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN

1383: IF (p_obj_type IS NULL OR
1384: p_obj_type NOT IN ('TABLE','VIEW', 'MV', 'PORTLET', 'PAGE', 'REPORT')) THEN
1385: x_msg_data := 'BIS_BIA_RSG_INV_OBJ_TYPE';
1386: x_return_status := fnd_api.g_ret_sts_error;
1387: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1388: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_OBJ_TYPE');
1389: END IF;
1390: RETURN x_parent_obj_table;
1391: END IF;

Line 1388: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_OBJ_TYPE');

1384: p_obj_type NOT IN ('TABLE','VIEW', 'MV', 'PORTLET', 'PAGE', 'REPORT')) THEN
1385: x_msg_data := 'BIS_BIA_RSG_INV_OBJ_TYPE';
1386: x_return_status := fnd_api.g_ret_sts_error;
1387: IF (fnd_msg_pub.check_msg_level(fnd_msg_pub.G_MSG_LVL_ERROR)) THEN
1388: fnd_msg_pub.add_exc_msg(g_pkg_name, v_procedure_name, 'BIS_BIA_RSG_INV_OBJ_TYPE');
1389: END IF;
1390: RETURN x_parent_obj_table;
1391: END IF;
1392:

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

1404:
1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1409: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1410: END IF;
1411: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1412: RETURN x_parent_obj_table;

Line 1409: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);

1405: EXCEPTION
1406: WHEN OTHERS THEN
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1409: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,v_procedure_name, NULL);
1410: END IF;
1411: x_msg_data := 'BIS_BIA_RSG_UNEXP_ERROR';
1412: RETURN x_parent_obj_table;
1413: END;