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_FORM_FUNCTIONS_PUB dependencies on FND_API

Line 175: , p_Commit => FND_API.G_FALSE

171: l_Form_Func_Extn_Rec.application_id := l_application_id;
172: l_Form_Func_Extn_Rec.func_area_id := p_functional_area_id;
173: BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension(
174: p_Api_Version => 1.0
175: , p_Commit => FND_API.G_FALSE
176: , p_Form_Func_Extn_Rec => l_Form_Func_Extn_Rec
177: , x_Return_Status => x_return_status
178: , x_Msg_Count => x_msg_count
179: , x_Msg_Data => x_msg_data);

Line 182: WHEN FND_API.G_EXC_ERROR THEN

178: , x_Msg_Count => x_msg_count
179: , x_Msg_Data => x_msg_data);
180: end if;
181: EXCEPTION
182: WHEN FND_API.G_EXC_ERROR THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
185: ,p_data => x_msg_data);
186: WHEN OTHERS THEN

Line 183: x_return_status := FND_API.G_RET_STS_ERROR;

179: , x_Msg_Data => x_msg_data);
180: end if;
181: EXCEPTION
182: WHEN FND_API.G_EXC_ERROR THEN
183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
185: ,p_data => x_msg_data);
186: WHEN OTHERS THEN
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

183: x_return_status := FND_API.G_RET_STS_ERROR;
184: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
185: ,p_data => x_msg_data);
186: WHEN OTHERS THEN
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
189: ,p_data => x_msg_data);
190: if (x_msg_data is null) then
191: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.INSERT_ROW: ' || SQLERRM;

Line 403: , p_Commit => FND_API.G_FALSE

399: l_Form_Func_Extn_Rec.func_area_id := p_functional_area_id;
400: if l_count > 0 then
401: BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension(
402: p_Api_Version => 1.0
403: , p_Commit => FND_API.G_FALSE
404: , p_Form_Func_Extn_Rec => l_Form_Func_Extn_Rec
405: , x_Return_Status => x_return_status
406: , x_Msg_Count => x_msg_count
407: , x_Msg_Data => x_msg_data);

Line 411: , p_Commit => FND_API.G_FALSE

407: , x_Msg_Data => x_msg_data);
408: else
409: BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension(
410: p_Api_Version => 1.0
411: , p_Commit => FND_API.G_FALSE
412: , p_Form_Func_Extn_Rec => l_Form_Func_Extn_Rec
413: , x_Return_Status => x_return_status
414: , x_Msg_Count => x_msg_count
415: , x_Msg_Data => x_msg_data);

Line 421: WHEN FND_API.G_EXC_ERROR THEN

417: end if;
418: end if;
419:
420: EXCEPTION
421: WHEN FND_API.G_EXC_ERROR THEN
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
424: ,p_data => x_msg_data);
425: WHEN OTHERS THEN

Line 422: x_return_status := FND_API.G_RET_STS_ERROR;

418: end if;
419:
420: EXCEPTION
421: WHEN FND_API.G_EXC_ERROR THEN
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
424: ,p_data => x_msg_data);
425: WHEN OTHERS THEN
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

422: x_return_status := FND_API.G_RET_STS_ERROR;
423: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
424: ,p_data => x_msg_data);
425: WHEN OTHERS THEN
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
428: ,p_data => x_msg_data);
429: if (x_msg_data is null) then
430: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.UPDATE_ROW: ' || SQLERRM;

Line 463: , p_Commit => FND_API.G_FALSE

459: if l_count > 0 then
460:
461: BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension(
462: p_Api_Version => 1.0
463: , p_Commit => FND_API.G_FALSE
464: , p_Form_Func_Extn_Rec => l_Form_Func_Extn_Rec
465: , x_Return_Status => x_return_status
466: , x_Msg_Count => x_msg_count
467: , x_Msg_Data => x_msg_data);

Line 471: WHEN FND_API.G_EXC_ERROR THEN

467: , x_Msg_Data => x_msg_data);
468: end if;
469:
470: EXCEPTION
471: WHEN FND_API.G_EXC_ERROR THEN
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
474: ,p_data => x_msg_data);
475: WHEN OTHERS THEN

Line 472: x_return_status := FND_API.G_RET_STS_ERROR;

468: end if;
469:
470: EXCEPTION
471: WHEN FND_API.G_EXC_ERROR THEN
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
474: ,p_data => x_msg_data);
475: WHEN OTHERS THEN
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

472: x_return_status := FND_API.G_RET_STS_ERROR;
473: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
474: ,p_data => x_msg_data);
475: WHEN OTHERS THEN
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
478: ,p_data => x_msg_data);
479: if (x_msg_data is null) then
480: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.DELETE_ROW: ' || SQLERRM;

Line 505: x_return_status := FND_API.G_RET_STS_SUCCESS;

501: SELECT menu_id, entry_sequence
502: FROM fnd_menu_entries
503: WHERE function_id = p_function_id;
504: BEGIN
505: x_return_status := FND_API.G_RET_STS_SUCCESS;
506:
507: IF (function_id_crsr%ISOPEN) THEN
508: CLOSE function_id_crsr;
509: END IF;

Line 543: WHEN FND_API.G_EXC_ERROR THEN

539: CLOSE c_menu_entries;
540: END IF;
541:
542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
546: ,p_data => x_msg_data);
547: WHEN OTHERS THEN

Line 544: x_return_status := FND_API.G_RET_STS_ERROR;

540: END IF;
541:
542: EXCEPTION
543: WHEN FND_API.G_EXC_ERROR THEN
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
546: ,p_data => x_msg_data);
547: WHEN OTHERS THEN
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

544: x_return_status := FND_API.G_RET_STS_ERROR;
545: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
546: ,p_data => x_msg_data);
547: WHEN OTHERS THEN
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
550: ,p_data => x_msg_data);
551: if (x_msg_data is null) then
552: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.DELETE_FUNCTION_AND_MENU_ENT: ' || SQLERRM;

Line 588: WHEN FND_API.G_EXC_ERROR THEN

584: X_FUNCTION_ID => p_FUNCTION_ID
585: );
586:
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592: WHEN OTHERS THEN

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585: );
586:
587: EXCEPTION
588: WHEN FND_API.G_EXC_ERROR THEN
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

589: x_return_status := FND_API.G_RET_STS_ERROR;
590: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592: WHEN OTHERS THEN
593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
594: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
595: ,p_data => x_msg_data);
596: if (x_msg_data is null) then
597: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.DELETE_ROW_FUNC_MENUENTRIES: ' || SQLERRM;

Line 660: x_return_status := FND_API.G_RET_STS_SUCCESS;

656: SELECT menu_id, entry_sequence
657: FROM fnd_menu_entries
658: WHERE function_id = p_function_id;
659: BEGIN
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661:
662: for rec in menu_crsr(p_function_id) loop
663: BIS_MENU_ENTRIES_PUB.UPDATE_PROMPT (
664: X_USER_ID => fnd_global.user_id,

Line 676: WHEN FND_API.G_EXC_ERROR THEN

672: close menu_crsr;
673: end if;
674:
675: EXCEPTION
676: WHEN FND_API.G_EXC_ERROR THEN
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
679: ,p_data => x_msg_data);
680: WHEN OTHERS THEN

Line 677: x_return_status := FND_API.G_RET_STS_ERROR;

673: end if;
674:
675: EXCEPTION
676: WHEN FND_API.G_EXC_ERROR THEN
677: x_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
679: ,p_data => x_msg_data);
680: WHEN OTHERS THEN
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

677: x_return_status := FND_API.G_RET_STS_ERROR;
678: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
679: ,p_data => x_msg_data);
680: WHEN OTHERS THEN
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
683: ,p_data => x_msg_data);
684: if (x_msg_data is null) then
685: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.UPDATE_FUNCTION_MENU_PROMPTS: ' || SQLERRM;

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

688: END UPDATE_FUNCTION_MENU_PROMPTS;
689:
690:
691: PROCEDURE Update_Form_Func_Obsolete_Flag (
692: p_commit IN VARCHAR2 := FND_API.G_FALSE,
693: p_func_name IN VARCHAR2,
694: p_obsolete IN VARCHAR2,
695: x_return_status OUT nocopy VARCHAR2,
696: x_Msg_Count OUT NOCOPY NUMBER,

Line 708: RAISE FND_API.G_EXC_ERROR;

704: SAVEPOINT FormFunctionObsoleteUpdate;
705: IF (p_func_name IS NULL OR p_func_name = '') THEN
706: FND_MESSAGE.SET_NAME('BIS','BIS_INV_FORM_FUNC_VAL');
707: FND_MSG_PUB.ADD;
708: RAISE FND_API.G_EXC_ERROR;
709: END IF;
710:
711: IF (p_obsolete IS NULL OR (p_obsolete <> 'Y' AND p_obsolete <> 'N')) THEN
712: FND_MESSAGE.SET_NAME('BIS','BIS_PMF_INVALID_OBSOLETE_FLAG');

Line 714: RAISE FND_API.G_EXC_ERROR;

710:
711: IF (p_obsolete IS NULL OR (p_obsolete <> 'Y' AND p_obsolete <> 'N')) THEN
712: FND_MESSAGE.SET_NAME('BIS','BIS_PMF_INVALID_OBSOLETE_FLAG');
713: FND_MSG_PUB.ADD;
714: RAISE FND_API.G_EXC_ERROR;
715: END IF;
716:
717: SELECT function_id,parameters,description
718: INTO l_form_function_id,l_form_func_parameters,l_form_func_description

Line 737: IF(p_Commit = FND_API.G_TRUE) THEN

733: X_PARAMETERS => l_form_func_parameters,
734: X_DESCRIPTION => l_form_func_description
735: );
736:
737: IF(p_Commit = FND_API.G_TRUE) THEN
738: commit;
739: END IF;
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741: RETURN;

Line 740: x_return_status := FND_API.G_RET_STS_SUCCESS;

736:
737: IF(p_Commit = FND_API.G_TRUE) THEN
738: commit;
739: END IF;
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741: RETURN;
742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: IF (x_msg_data IS NULL) THEN

Line 743: WHEN FND_API.G_EXC_ERROR THEN

739: END IF;
740: x_return_status := FND_API.G_RET_STS_SUCCESS;
741: RETURN;
742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: IF (x_msg_data IS NULL) THEN
745: FND_MSG_PUB.Count_And_Get
746: ( p_encoded => FND_API.G_FALSE
747: , p_count => x_msg_count

Line 746: ( p_encoded => FND_API.G_FALSE

742: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: IF (x_msg_data IS NULL) THEN
745: FND_MSG_PUB.Count_And_Get
746: ( p_encoded => FND_API.G_FALSE
747: , p_count => x_msg_count
748: , p_data => x_msg_data
749: );
750: END IF;

Line 751: x_Return_Status := FND_API.G_RET_STS_ERROR;

747: , p_count => x_msg_count
748: , p_data => x_msg_data
749: );
750: END IF;
751: x_Return_Status := FND_API.G_RET_STS_ERROR;
752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: ROLLBACK TO FormFunctionObsoleteUpdate;
755: IF (x_msg_data IS NOT NULL) THEN

Line 753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

749: );
750: END IF;
751: x_Return_Status := FND_API.G_RET_STS_ERROR;
752: WHEN OTHERS THEN
753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
754: ROLLBACK TO FormFunctionObsoleteUpdate;
755: IF (x_msg_data IS NOT NULL) THEN
756: x_msg_data := x_msg_data||' -> BIS_FORM_FUNCTIONS_PUB.Update_Form_Func_Obsolete_Flag ';
757: ELSE

Line 781: RAISE FND_API.G_EXC_ERROR;

777: x_msg_data := '';
778: IF (p_functionName IS NULL OR p_functionName = '') THEN
779: FND_MESSAGE.SET_NAME('BIS','BIS_INV_FORM_FUNC_VAL');
780: FND_MSG_PUB.ADD;
781: RAISE FND_API.G_EXC_ERROR;
782: END IF;
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: l_parent_obj_table := BIS_RSG_PUB_API_PKG.GetParentObjects(p_functionName,'PORTLET','PAGE',l_ret_status,l_msg_data);
785:

Line 783: x_return_status := FND_API.G_RET_STS_SUCCESS;

779: FND_MESSAGE.SET_NAME('BIS','BIS_INV_FORM_FUNC_VAL');
780: FND_MSG_PUB.ADD;
781: RAISE FND_API.G_EXC_ERROR;
782: END IF;
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: l_parent_obj_table := BIS_RSG_PUB_API_PKG.GetParentObjects(p_functionName,'PORTLET','PAGE',l_ret_status,l_msg_data);
785:
786: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN
787: FND_MESSAGE.SET_NAME('BIS',l_msg_data);

Line 786: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN

782: END IF;
783: x_return_status := FND_API.G_RET_STS_SUCCESS;
784: l_parent_obj_table := BIS_RSG_PUB_API_PKG.GetParentObjects(p_functionName,'PORTLET','PAGE',l_ret_status,l_msg_data);
785:
786: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN
787: FND_MESSAGE.SET_NAME('BIS',l_msg_data);
788: FND_MSG_PUB.ADD;
789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
790: ELSE

Line 789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

785:
786: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN
787: FND_MESSAGE.SET_NAME('BIS',l_msg_data);
788: FND_MSG_PUB.ADD;
789: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
790: ELSE
791: IF (l_parent_obj_table.COUNT > 0) THEN
792: l_dep_obj_list := '';
793: l_index := l_parent_obj_table.first;

Line 806: ( p_encoded => FND_API.G_FALSE

802: FND_MSG_PUB.ADD;
803: END IF;
804: END IF;
805: FND_MSG_PUB.Count_And_Get
806: ( p_encoded => FND_API.G_FALSE
807: , p_count => x_msg_count
808: , p_data => x_msg_data
809: );
810: EXCEPTION

Line 811: WHEN FND_API.G_EXC_ERROR THEN

807: , p_count => x_msg_count
808: , p_data => x_msg_data
809: );
810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: IF (x_msg_data IS NULL) THEN
813: FND_MSG_PUB.Count_And_Get
814: ( p_encoded => FND_API.G_FALSE
815: , p_count => x_msg_count

Line 814: ( p_encoded => FND_API.G_FALSE

810: EXCEPTION
811: WHEN FND_API.G_EXC_ERROR THEN
812: IF (x_msg_data IS NULL) THEN
813: FND_MSG_PUB.Count_And_Get
814: ( p_encoded => FND_API.G_FALSE
815: , p_count => x_msg_count
816: , p_data => x_msg_data
817: );
818: END IF;

Line 819: x_Return_Status := FND_API.G_RET_STS_ERROR;

815: , p_count => x_msg_count
816: , p_data => x_msg_data
817: );
818: END IF;
819: x_Return_Status := FND_API.G_RET_STS_ERROR;
820: WHEN OTHERS THEN
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
822: IF (x_msg_data IS NOT NULL) THEN
823: x_msg_data := x_msg_data||' -> BIS_FORM_FUNCTIONS_PUB.Check_Form_Function ';

Line 821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

817: );
818: END IF;
819: x_Return_Status := FND_API.G_RET_STS_ERROR;
820: WHEN OTHERS THEN
821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
822: IF (x_msg_data IS NOT NULL) THEN
823: x_msg_data := x_msg_data||' -> BIS_FORM_FUNCTIONS_PUB.Check_Form_Function ';
824: ELSE
825: x_msg_data := SQLERRM||' at BIS_FORM_FUNCTIONS_PUB.Check_Form_Function ';