DBA Data[Home] [Help]

APPS.BIS_FORM_FUNCTIONS_PUB dependencies on BIS_FORM_FUNCTIONS_PUB

Line 1: PACKAGE BODY BIS_FORM_FUNCTIONS_PUB as

1: PACKAGE BODY BIS_FORM_FUNCTIONS_PUB as
2: /* $Header: BISPFFNB.pls 120.3 2005/09/20 03:55:02 akoduri noship $ */
3: ----------------------------------------------------------------------------
4: -- PACKAGE: BIS_FORM_FUNCTIONS_PUB --
5: -- --

Line 4: -- PACKAGE: BIS_FORM_FUNCTIONS_PUB --

1: PACKAGE BODY BIS_FORM_FUNCTIONS_PUB as
2: /* $Header: BISPFFNB.pls 120.3 2005/09/20 03:55:02 akoduri noship $ */
3: ----------------------------------------------------------------------------
4: -- PACKAGE: BIS_FORM_FUNCTIONS_PUB --
5: -- --
6: -- DESCRIPTION: Private package that calls the FND packages to --
7: -- insert records in the FND tables. --
8: --

Line 191: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.INSERT_ROW: ' || SQLERRM;

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;
192: end if;
193:
194: end INSERT_ROW;
195:

Line 430: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.UPDATE_ROW: ' || SQLERRM;

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;
431: end if;
432:
433: end UPDATE_ROW;
434:

Line 480: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.DELETE_ROW: ' || SQLERRM;

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;
481: end if;
482:
483: END DELETE_ROW;
484:

Line 552: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.DELETE_FUNCTION_AND_MENU_ENT: ' || SQLERRM;

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;
553: end if;
554:
555: END DELETE_FUNCTION_AND_MENU_ENT;
556:

Line 597: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.DELETE_ROW_FUNC_MENUENTRIES: ' || SQLERRM;

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;
598: end if;
599:
600: END DELETE_ROW_FUNC_MENUENTRIES;
601:

Line 627: x_record_status := BIS_FORM_FUNCTIONS_PUB.c_RECORD_DELETED;

623: OPEN cFunction;
624: FETCH cFunction INTO l_last_update_date;
625:
626: if (cFunction%notfound) then
627: x_record_status := BIS_FORM_FUNCTIONS_PUB.c_RECORD_DELETED;
628: end if;
629:
630: if p_last_update_date is not null then
631: if p_last_update_date <> TO_CHAR(l_last_update_date, BIS_FORM_FUNCTIONS_PUB.C_LAST_UPDATE_DATE_FORMAT) then

Line 631: if p_last_update_date <> TO_CHAR(l_last_update_date, BIS_FORM_FUNCTIONS_PUB.C_LAST_UPDATE_DATE_FORMAT) then

627: x_record_status := BIS_FORM_FUNCTIONS_PUB.c_RECORD_DELETED;
628: end if;
629:
630: if p_last_update_date is not null then
631: if p_last_update_date <> TO_CHAR(l_last_update_date, BIS_FORM_FUNCTIONS_PUB.C_LAST_UPDATE_DATE_FORMAT) then
632: x_record_status := BIS_FORM_FUNCTIONS_PUB.c_RECORD_CHANGED;
633: end if;
634: end if;
635:

Line 632: x_record_status := BIS_FORM_FUNCTIONS_PUB.c_RECORD_CHANGED;

628: end if;
629:
630: if p_last_update_date is not null then
631: if p_last_update_date <> TO_CHAR(l_last_update_date, BIS_FORM_FUNCTIONS_PUB.C_LAST_UPDATE_DATE_FORMAT) then
632: x_record_status := BIS_FORM_FUNCTIONS_PUB.c_RECORD_CHANGED;
633: end if;
634: end if;
635:
636: rollback to SP_LOCK_FUNCTION_ROW;

Line 642: x_record_status := BIS_FORM_FUNCTIONS_PUB.c_RECORD_CHANGED;

638:
639: EXCEPTION
640: WHEN OTHERS THEN
641: close cFunction;
642: x_record_status := BIS_FORM_FUNCTIONS_PUB.c_RECORD_CHANGED;
643: rollback to SP_LOCK_FUNCTION_ROW;
644: END LOCK_FUNCTION_ROW;
645:
646: -- mdamle 09/28/2004 - Update menu prompts from user_function_name

Line 685: x_msg_data := 'BIS_FORM_FUNCTIONS_PUB.UPDATE_FUNCTION_MENU_PROMPTS: ' || SQLERRM;

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;
686: end if;
687:
688: END UPDATE_FUNCTION_MENU_PROMPTS;
689:

Line 730: BIS_FORM_FUNCTIONS_PUB.UPDATE_ROW(

726: IF (p_obsolete = 'N') THEN
727: l_form_func_parameters := REPLACE(l_form_func_parameters,'&pObsoleteFlag=Y');
728: END IF;
729:
730: BIS_FORM_FUNCTIONS_PUB.UPDATE_ROW(
731: X_USER_ID => FND_GLOBAL.USER_ID,
732: X_FUNCTION_ID => l_form_function_id,
733: X_PARAMETERS => l_form_func_parameters,
734: X_DESCRIPTION => l_form_func_description

Line 756: x_msg_data := x_msg_data||' -> BIS_FORM_FUNCTIONS_PUB.Update_Form_Func_Obsolete_Flag ';

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
758: x_msg_data := SQLERRM||' at BIS_FORM_FUNCTIONS_PUB.Update_Form_Func_Obsolete_Flag ';
759: END IF;
760: END Update_Form_Func_Obsolete_Flag;

Line 758: x_msg_data := SQLERRM||' at BIS_FORM_FUNCTIONS_PUB.Update_Form_Func_Obsolete_Flag ';

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
758: x_msg_data := SQLERRM||' at BIS_FORM_FUNCTIONS_PUB.Update_Form_Func_Obsolete_Flag ';
759: END IF;
760: END Update_Form_Func_Obsolete_Flag;
761:
762:

Line 823: x_msg_data := x_msg_data||' -> BIS_FORM_FUNCTIONS_PUB.Check_Form_Function ';

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 ';
826: END IF;
827: END Check_Form_Function;

Line 825: x_msg_data := SQLERRM||' at BIS_FORM_FUNCTIONS_PUB.Check_Form_Function ';

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 ';
826: END IF;
827: END Check_Form_Function;
828:
829:

Line 830: END BIS_FORM_FUNCTIONS_PUB;

826: END IF;
827: END Check_Form_Function;
828:
829:
830: END BIS_FORM_FUNCTIONS_PUB;