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_OBJECT_EXTENSIONS_PUB dependencies on BIS_OBJECT_EXTENSIONS_PUB

Line 1: PACKAGE BODY BIS_OBJECT_EXTENSIONS_PUB AS

1: PACKAGE BODY BIS_OBJECT_EXTENSIONS_PUB AS
2: /* $Header: BISPEXTB.pls 120.1 2005/11/17 05:54:35 akoduri noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2004 Oracle Corporation, Redwood Shores, CA, USA |

Line 27: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_OBJECT_EXTENSIONS_PUB';

23: REM | 17-Nov-2005 akoduri bug4725352: Issue in translating seed data |
24: REM +=======================================================================+
25: */
26:
27: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_OBJECT_EXTENSIONS_PUB';
28: FUNCTION Get_FA_Id_By_Short_Name (p_Functional_Area_Short_Name IN VARCHAR2)RETURN NUMBER;
29:
30: PROCEDURE Validate_Measure_Extension(
31: p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type

Line 31: p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type

27: G_PKG_NAME CONSTANT VARCHAR2(30):='BIS_OBJECT_EXTENSIONS_PUB';
28: FUNCTION Get_FA_Id_By_Short_Name (p_Functional_Area_Short_Name IN VARCHAR2)RETURN NUMBER;
29:
30: PROCEDURE Validate_Measure_Extension(
31: p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
32: ,p_Action_Type IN VARCHAR2
33: ,x_Return_Status OUT NOCOPY VARCHAR2
34: ,x_Msg_Count OUT NOCOPY NUMBER
35: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 40: p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type

36: );
37:
38:
39: PROCEDURE Validate_Form_Func_Extension(
40: p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
41: , p_Action_Type IN VARCHAR2
42: , x_Return_Status OUT NOCOPY VARCHAR2
43: , x_Msg_Count OUT NOCOPY NUMBER
44: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 96: p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type

92: DESCRIPTION :- This retrieves the details of give form function name
93: AUTHOR :- KRISHNA
94: *********************************************************************************************/
95: PROCEDURE Retrieve_Form_Func_Extension(
96: p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
97: , x_Form_Func_Extn_Rec OUT NOCOPY BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
98: , x_Return_Status OUT NOCOPY VARCHAR2
99: , x_Msg_Count OUT NOCOPY NUMBER
100: , x_Msg_Data OUT NOCOPY VARCHAR2

Line 97: , x_Form_Func_Extn_Rec OUT NOCOPY BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type

93: AUTHOR :- KRISHNA
94: *********************************************************************************************/
95: PROCEDURE Retrieve_Form_Func_Extension(
96: p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
97: , x_Form_Func_Extn_Rec OUT NOCOPY BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
98: , x_Return_Status OUT NOCOPY VARCHAR2
99: , x_Msg_Count OUT NOCOPY NUMBER
100: , x_Msg_Data OUT NOCOPY VARCHAR2
101: )IS

Line 142: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';

138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
139: WHEN NO_DATA_FOUND THEN
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: IF (x_msg_data IS NOT NULL) THEN
142: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';
143: ELSE
144: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';
145: END IF;
146: WHEN OTHERS THEN

Line 144: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';

140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: IF (x_msg_data IS NOT NULL) THEN
142: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';
143: ELSE
144: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';
145: END IF;
146: WHEN OTHERS THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: IF (x_msg_data IS NOT NULL) THEN

Line 149: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';

145: END IF;
146: WHEN OTHERS THEN
147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: IF (x_msg_data IS NOT NULL) THEN
149: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';
150: ELSE
151: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';
152: END IF;
153: END Retrieve_Form_Func_Extension;

Line 151: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';

147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
148: IF (x_msg_data IS NOT NULL) THEN
149: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';
150: ELSE
151: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Form_Func_Extension ';
152: END IF;
153: END Retrieve_Form_Func_Extension;
154: /*********************************************************************************************
155: FUNCTION Name :- Translate_Form_Func_Extension

Line 165: ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type

161: *********************************************************************************************/
162: PROCEDURE Translate_Form_Func_Extension(
163: p_Api_Version IN NUMBER
164: ,p_Commit IN VARCHAR2
165: ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
166: ,x_Return_Status OUT NOCOPY VARCHAR2
167: ,x_Msg_Count OUT NOCOPY NUMBER
168: ,x_Msg_Data OUT NOCOPY VARCHAR2
169: )IS

Line 185: , p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_TRANS

181: --dbms_output.put_line('calling validate from trans');
182: --dbms_output.put_line('the value i am passing for tarns is :- '||BIS_OBJECT_EXTENSIONS_PKG.C_TRANS);
183: Validate_Form_Func_Extension(
184: p_Form_Func_Extn_Rec => p_Form_Func_Extn_Rec
185: , p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_TRANS
186: , x_Return_Status => x_Return_Status
187: , x_Msg_Count => x_Msg_Count
188: , x_Msg_Data => x_Msg_Data
189: );

Line 233: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';

229: WHEN NO_DATA_FOUND THEN
230: ROLLBACK TO TransalteFormFuncPSP;
231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: IF (x_msg_data IS NOT NULL) THEN
233: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';
234: ELSE
235: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';
236: END IF;
237: WHEN OTHERS THEN

Line 235: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';

231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
232: IF (x_msg_data IS NOT NULL) THEN
233: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';
234: ELSE
235: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';
236: END IF;
237: WHEN OTHERS THEN
238: ROLLBACK TO TransalteFormFuncPSP;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 241: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';

237: WHEN OTHERS THEN
238: ROLLBACK TO TransalteFormFuncPSP;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF (x_msg_data IS NOT NULL) THEN
241: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';
242: ELSE
243: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';
244: END IF;
245: END Translate_Form_Func_Extension;

Line 243: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';

239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF (x_msg_data IS NOT NULL) THEN
241: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';
242: ELSE
243: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Form_Func_Extension ';
244: END IF;
245: END Translate_Form_Func_Extension;
246: /*********************************************************************************************
247: FUNCTION Name :- Update_Form_Func_Extension

Line 257: ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type

253: *********************************************************************************************/
254: PROCEDURE Update_Form_Func_Extension(
255: p_Api_Version IN NUMBER
256: ,p_Commit IN VARCHAR2
257: ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
258: ,x_Return_Status OUT NOCOPY VARCHAR2
259: ,x_Msg_Count OUT NOCOPY NUMBER
260: ,x_Msg_Data OUT NOCOPY VARCHAR2
261: )IS

Line 276: , p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE

272: END IF;
273: --dbms_output.put_line('i am calling validate from update ');
274: Validate_Form_Func_Extension(
275: p_Form_Func_Extn_Rec => p_Form_Func_Extn_Rec
276: , p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE
277: , x_Return_Status => x_Return_Status
278: , x_Msg_Count => x_Msg_Count
279: , x_Msg_Data => x_Msg_Data
280: );

Line 326: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';

322: WHEN NO_DATA_FOUND THEN
323: ROLLBACK TO UpdateFormFuncPSP;
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
325: IF (x_msg_data IS NOT NULL) THEN
326: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';
327: ELSE
328: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';
329: END IF;
330: WHEN OTHERS THEN

Line 328: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';

324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
325: IF (x_msg_data IS NOT NULL) THEN
326: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';
327: ELSE
328: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';
329: END IF;
330: WHEN OTHERS THEN
331: ROLLBACK TO UpdateFormFuncPSP;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 334: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';

330: WHEN OTHERS THEN
331: ROLLBACK TO UpdateFormFuncPSP;
332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: IF (x_msg_data IS NOT NULL) THEN
334: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';
335: ELSE
336: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';
337: END IF;
338: END Update_Form_Func_Extension;

Line 336: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';

332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
333: IF (x_msg_data IS NOT NULL) THEN
334: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';
335: ELSE
336: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension ';
337: END IF;
338: END Update_Form_Func_Extension;
339: /*********************************************************************************************
340: FUNCTION Name :- Create_Form_Func_Extension

Line 349: , p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type

345: *********************************************************************************************/
346: PROCEDURE Create_Form_Func_Extension(
347: p_Api_Version IN NUMBER
348: , p_Commit IN VARCHAR2
349: , p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
350: , x_Return_Status OUT NOCOPY VARCHAR2
351: , x_Msg_Count OUT NOCOPY NUMBER
352: , x_Msg_Data OUT NOCOPY VARCHAR2
353: )IS

Line 355: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;

351: , x_Msg_Count OUT NOCOPY NUMBER
352: , x_Msg_Data OUT NOCOPY VARCHAR2
353: )IS
354: l_Commit VARCHAR2(30);
355: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
356:
357: BEGIN
358: SAVEPOINT CreateFormFuncPSP;
359: FND_MSG_PUB.Initialize;

Line 369: , p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_CREATE

365: END IF;
366: --dbms_output.put_line('i am calling validate from create ');
367: Validate_Form_Func_Extension(
368: p_Form_Func_Extn_Rec => p_Form_Func_Extn_Rec
369: , p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_CREATE
370: , x_Return_Status => x_Return_Status
371: , x_Msg_Count => x_Msg_Count
372: , x_Msg_Data => x_Msg_Data
373: );

Line 419: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';

415: WHEN NO_DATA_FOUND THEN
416: ROLLBACK TO CreateFormFuncPSP;
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF (x_msg_data IS NOT NULL) THEN
419: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';
420: ELSE
421: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';
422: END IF;
423: WHEN OTHERS THEN

Line 421: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';

417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418: IF (x_msg_data IS NOT NULL) THEN
419: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';
420: ELSE
421: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';
422: END IF;
423: WHEN OTHERS THEN
424: ROLLBACK TO CreateFormFuncPSP;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 427: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';

423: WHEN OTHERS THEN
424: ROLLBACK TO CreateFormFuncPSP;
425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: IF (x_msg_data IS NOT NULL) THEN
427: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';
428: ELSE
429: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';
430: END IF;
431: END Create_Form_Func_Extension;

Line 429: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';

425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426: IF (x_msg_data IS NOT NULL) THEN
427: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';
428: ELSE
429: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension ';
430: END IF;
431: END Create_Form_Func_Extension;
432: /*********************************************************************************************
433: FUNCTION Name :- Load_Form_Func_Extension

Line 443: ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type

439: *********************************************************************************************/
440: PROCEDURE Load_Form_Func_Extension(
441: p_Api_Version IN NUMBER
442: ,p_Commit IN VARCHAR2
443: ,p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
444: ,p_Custom_mode IN VARCHAR2
445: ,x_Return_Status OUT NOCOPY VARCHAR2
446: ,x_Msg_Count OUT NOCOPY NUMBER
447: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 452: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;

448: )IS
449:
450: l_Commit VARCHAR2(30);
451: l_Count NUMBER;
452: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
453: BEGIN
454: SAVEPOINT LoadFormFuncPSP;
455: FND_MSG_PUB.Initialize;
456: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 465: , p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_LOAD

461: END IF;
462:
463: Validate_Form_Func_Extension(
464: p_Form_Func_Extn_Rec => p_Form_Func_Extn_Rec
465: , p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_LOAD
466: , x_Return_Status => x_Return_Status
467: , x_Msg_Count => x_Msg_Count
468: , x_Msg_Data => x_Msg_Data
469: );

Line 484: BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension(

480:
481: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
482: l_Form_Func_Extn_Rec := p_Form_Func_Extn_Rec;
483: l_Form_Func_Extn_Rec.Func_Area_Id := Get_FA_Id_By_Short_Name(p_Form_Func_Extn_Rec.Func_Area_short_name);
484: BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension(
485: p_Api_Version => p_Api_Version
486: , p_Commit => p_Commit
487: , p_Form_Func_Extn_Rec => l_Form_Func_Extn_Rec
488: , x_Return_Status => x_Return_Status

Line 500: BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension(

496: , l_Form_Func_Extn_Rec.Last_Update_Date
497: , p_Custom_mode)) THEN
498: l_Form_Func_Extn_Rec := p_Form_Func_Extn_Rec;
499: l_Form_Func_Extn_Rec.Func_Area_Id := Get_FA_Id_By_Short_Name(p_Form_Func_Extn_Rec.Func_Area_short_name);
500: BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension(
501: p_Api_Version => p_Api_Version
502: , p_Commit => p_Commit
503: , p_Form_Func_Extn_Rec => l_Form_Func_Extn_Rec
504: , x_Return_Status => x_Return_Status

Line 541: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';

537: WHEN NO_DATA_FOUND THEN
538: ROLLBACK TO LoadFormFuncPSP;
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: IF (x_msg_data IS NOT NULL) THEN
541: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';
542: ELSE
543: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';
544: END IF;
545: WHEN OTHERS THEN

Line 543: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';

539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: IF (x_msg_data IS NOT NULL) THEN
541: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';
542: ELSE
543: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';
544: END IF;
545: WHEN OTHERS THEN
546: ROLLBACK TO LoadFormFuncPSP;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 549: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';

545: WHEN OTHERS THEN
546: ROLLBACK TO LoadFormFuncPSP;
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: IF (x_msg_data IS NOT NULL) THEN
549: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';
550: ELSE
551: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';
552: END IF;
553: END Load_Form_Func_Extension;

Line 551: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';

547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548: IF (x_msg_data IS NOT NULL) THEN
549: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';
550: ELSE
551: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Form_Func_Extension ';
552: END IF;
553: END Load_Form_Func_Extension;
554: /*********************************************************************************************
555: FUNCTION Name :- Delete_Form_Func_Extension

Line 566: , p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type

562:
563: PROCEDURE Delete_Form_Func_Extension(
564: p_Api_Version IN NUMBER
565: , p_Commit IN VARCHAR2
566: , p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
567: , x_Return_Status OUT NOCOPY VARCHAR2
568: , x_Msg_Count OUT NOCOPY NUMBER
569: , x_Msg_Data OUT NOCOPY VARCHAR2
570: )IS

Line 572: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;

568: , x_Msg_Count OUT NOCOPY NUMBER
569: , x_Msg_Data OUT NOCOPY VARCHAR2
570: )IS
571: l_Commit VARCHAR2(30);
572: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
573:
574: BEGIN
575: SAVEPOINT DeleteFormFuncPSP;
576: FND_MSG_PUB.Initialize;

Line 586: , p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_DELETE

582: END IF;
583: --dbms_output.put_line('i am calling validate from create ');
584: Validate_Form_Func_Extension(
585: p_Form_Func_Extn_Rec => p_Form_Func_Extn_Rec
586: , p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_DELETE
587: , x_Return_Status => x_Return_Status
588: , x_Msg_Count => x_Msg_Count
589: , x_Msg_Data => x_Msg_Data
590: );

Line 636: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';

632: WHEN NO_DATA_FOUND THEN
633: ROLLBACK TO DeleteFormFuncPSP;
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: IF (x_msg_data IS NOT NULL) THEN
636: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';
637: ELSE
638: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';
639: END IF;
640: WHEN OTHERS THEN

Line 638: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';

634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: IF (x_msg_data IS NOT NULL) THEN
636: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';
637: ELSE
638: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';
639: END IF;
640: WHEN OTHERS THEN
641: ROLLBACK TO DeleteFormFuncPSP;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 644: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';

640: WHEN OTHERS THEN
641: ROLLBACK TO DeleteFormFuncPSP;
642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: IF (x_msg_data IS NOT NULL) THEN
644: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';
645: ELSE
646: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';
647: END IF;
648: END Delete_Form_Func_Extension;

Line 646: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';

642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
643: IF (x_msg_data IS NOT NULL) THEN
644: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';
645: ELSE
646: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension ';
647: END IF;
648: END Delete_Form_Func_Extension;
649:
650:

Line 659: ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type

655:
656: PROCEDURE Create_Measure_Extension(
657: p_Api_Version IN NUMBER
658: ,p_Commit IN VARCHAR2
659: ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
660: ,x_Return_Status OUT NOCOPY VARCHAR2
661: ,x_Msg_Count OUT NOCOPY NUMBER
662: ,x_Msg_Data OUT NOCOPY VARCHAR2
663: ) IS

Line 724: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';

720: WHEN NO_DATA_FOUND THEN
721: ROLLBACK TO CreateMeasExtnPSP;
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: IF (x_msg_data IS NOT NULL) THEN
724: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';
725: ELSE
726: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';
727: END IF;
728: WHEN OTHERS THEN

Line 726: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';

722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
723: IF (x_msg_data IS NOT NULL) THEN
724: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';
725: ELSE
726: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';
727: END IF;
728: WHEN OTHERS THEN
729: ROLLBACK TO CreateMeasExtnPSP;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 732: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';

728: WHEN OTHERS THEN
729: ROLLBACK TO CreateMeasExtnPSP;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: IF (x_msg_data IS NOT NULL) THEN
732: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';
733: ELSE
734: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';
735: END IF;
736:

Line 734: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';

730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: IF (x_msg_data IS NOT NULL) THEN
732: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';
733: ELSE
734: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension ';
735: END IF;
736:
737: END Create_Measure_Extension;
738:

Line 741: p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type

737: END Create_Measure_Extension;
738:
739:
740: PROCEDURE Retrieve_Measure_Extension(
741: p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
742: ,x_Meas_Extn_Rec OUT NOCOPY BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
743: ,x_Return_Status OUT NOCOPY VARCHAR2
744: ,x_Msg_Count OUT NOCOPY NUMBER
745: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 742: ,x_Meas_Extn_Rec OUT NOCOPY BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type

738:
739:
740: PROCEDURE Retrieve_Measure_Extension(
741: p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
742: ,x_Meas_Extn_Rec OUT NOCOPY BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
743: ,x_Return_Status OUT NOCOPY VARCHAR2
744: ,x_Msg_Count OUT NOCOPY NUMBER
745: ,x_Msg_Data OUT NOCOPY VARCHAR2
746: ) IS

Line 785: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';

781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782: WHEN NO_DATA_FOUND THEN
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: IF (x_msg_data IS NOT NULL) THEN
785: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';
786: ELSE
787: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';
788: END IF;
789: WHEN OTHERS THEN

Line 787: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';

783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: IF (x_msg_data IS NOT NULL) THEN
785: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';
786: ELSE
787: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';
788: END IF;
789: WHEN OTHERS THEN
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF (x_msg_data IS NOT NULL) THEN

Line 792: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';

788: END IF;
789: WHEN OTHERS THEN
790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF (x_msg_data IS NOT NULL) THEN
792: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';
793: ELSE
794: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';
795: END IF;
796: END Retrieve_Measure_Extension;

Line 794: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';

790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
791: IF (x_msg_data IS NOT NULL) THEN
792: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';
793: ELSE
794: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension ';
795: END IF;
796: END Retrieve_Measure_Extension;
797:
798:

Line 802: ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type

798:
799: PROCEDURE Translate_Measure_Extension(
800: p_Api_Version IN NUMBER
801: ,p_Commit IN VARCHAR2
802: ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
803: ,x_Return_Status OUT NOCOPY VARCHAR2
804: ,x_Msg_Count OUT NOCOPY NUMBER
805: ,x_Msg_Data OUT NOCOPY VARCHAR2
806: ) IS

Line 807: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;

803: ,x_Return_Status OUT NOCOPY VARCHAR2
804: ,x_Msg_Count OUT NOCOPY NUMBER
805: ,x_Msg_Data OUT NOCOPY VARCHAR2
806: ) IS
807: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
808: BEGIN
809:
810: SAVEPOINT TranslateMeasExtnPSP;
811: FND_MSG_PUB.Initialize;

Line 820: ,p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_TRANS

816: ------dbms_output.put_line ('l_Meas_Extn_Rec.Measure_Short_Name - ' || l_Meas_Extn_Rec.Measure_Short_Name);
817:
818: Validate_Measure_Extension(
819: p_Meas_Extn_Rec => l_Meas_Extn_Rec
820: ,p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_TRANS
821: ,x_Return_Status => x_Return_Status
822: ,x_Msg_Count => x_Msg_Count
823: ,x_Msg_Data => x_Msg_Data
824: );

Line 872: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';

868: WHEN NO_DATA_FOUND THEN
869: ROLLBACK TO TranslateMeasExtnPSP;
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: IF (x_msg_data IS NOT NULL) THEN
872: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';
873: ELSE
874: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';
875: END IF;
876: WHEN OTHERS THEN

Line 874: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';

870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: IF (x_msg_data IS NOT NULL) THEN
872: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';
873: ELSE
874: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';
875: END IF;
876: WHEN OTHERS THEN
877: ROLLBACK TO TranslateMeasExtnPSP;
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 880: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';

876: WHEN OTHERS THEN
877: ROLLBACK TO TranslateMeasExtnPSP;
878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: IF (x_msg_data IS NOT NULL) THEN
880: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';
881: ELSE
882: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';
883: END IF;
884:

Line 882: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';

878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
879: IF (x_msg_data IS NOT NULL) THEN
880: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';
881: ELSE
882: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Translate_Measure_Extension ';
883: END IF;
884:
885: END Translate_Measure_Extension;
886:

Line 891: ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type

887: -- Update the Measure Extensions
888: PROCEDURE Update_Measure_Extension(
889: p_Api_Version IN NUMBER
890: ,p_Commit IN VARCHAR2
891: ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
892: ,x_Return_Status OUT NOCOPY VARCHAR2
893: ,x_Msg_Count OUT NOCOPY NUMBER
894: ,x_Msg_Data OUT NOCOPY VARCHAR2
895: ) IS

Line 905: ,p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE

901: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
902:
903: Validate_Measure_Extension(
904: p_Meas_Extn_Rec => p_Meas_Extn_Rec
905: ,p_Action_Type => BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE
906: ,x_Return_Status => x_Return_Status
907: ,x_Msg_Count => x_Msg_Count
908: ,x_Msg_Data => x_Msg_Data
909: );

Line 958: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';

954: WHEN NO_DATA_FOUND THEN
955: ROLLBACK TO UpdateMeasExtnPSP;
956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: IF (x_msg_data IS NOT NULL) THEN
958: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';
959: ELSE
960: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';
961: END IF;
962: WHEN OTHERS THEN

Line 960: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';

956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
957: IF (x_msg_data IS NOT NULL) THEN
958: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';
959: ELSE
960: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';
961: END IF;
962: WHEN OTHERS THEN
963: ROLLBACK TO UpdateMeasExtnPSP;
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 966: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';

962: WHEN OTHERS THEN
963: ROLLBACK TO UpdateMeasExtnPSP;
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: IF (x_msg_data IS NOT NULL) THEN
966: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';
967: ELSE
968: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';
969: END IF;
970: END Update_Measure_Extension;

Line 968: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';

964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: IF (x_msg_data IS NOT NULL) THEN
966: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';
967: ELSE
968: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension ';
969: END IF;
970: END Update_Measure_Extension;
971:
972: PROCEDURE Load_Measure_Extension(

Line 975: ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type

971:
972: PROCEDURE Load_Measure_Extension(
973: p_Api_Version IN NUMBER
974: ,p_Commit IN VARCHAR2
975: ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
976: ,p_Custom_mode IN VARCHAR2
977: ,x_Return_Status OUT NOCOPY VARCHAR2
978: ,x_Msg_Count OUT NOCOPY NUMBER
979: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 981: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;

977: ,x_Return_Status OUT NOCOPY VARCHAR2
978: ,x_Msg_Count OUT NOCOPY NUMBER
979: ,x_Msg_Data OUT NOCOPY VARCHAR2
980: ) IS
981: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
982: l_Mes_up_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
983: BEGIN
984: SAVEPOINT LoadMeasExtnPSP;
985: FND_MSG_PUB.Initialize;

Line 982: l_Mes_up_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;

978: ,x_Msg_Count OUT NOCOPY NUMBER
979: ,x_Msg_Data OUT NOCOPY VARCHAR2
980: ) IS
981: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
982: l_Mes_up_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
983: BEGIN
984: SAVEPOINT LoadMeasExtnPSP;
985: FND_MSG_PUB.Initialize;
986: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 999: BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension(

995: RAISE FND_API.G_EXC_ERROR;
996: END IF;
997: --dbms_output.put_line('func short name i sent is :- '|| p_Meas_Extn_Rec.Func_Area_short_name);
998:
999: BIS_OBJECT_EXTENSIONS_PUB.Retrieve_Measure_Extension(
1000: p_Meas_Extn_Rec => p_Meas_Extn_Rec
1001: ,x_Meas_Extn_Rec => l_Meas_Extn_Rec
1002: ,x_Return_Status => x_Return_Status
1003: ,x_Msg_Count => x_Msg_Count

Line 1026: BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension(

1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024: END IF;
1025:
1026: BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension(
1027: p_Api_Version => p_Api_Version
1028: ,p_Commit => p_Commit
1029: ,p_Meas_Extn_Rec => l_Meas_Extn_Rec
1030: ,x_Return_Status => x_Return_Status

Line 1049: BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension(

1045: , p_Custom_mode)) THEN
1046: --dbms_output.put_line('UPLDOATE SUCESS I AM GOING TO UPDATE FOR MEASURES' );
1047: l_Mes_up_Rec := p_Meas_Extn_Rec;
1048: l_Mes_up_Rec.Functional_Area_Id := Get_FA_Id_By_Short_Name(p_Meas_Extn_Rec.Func_Area_Short_Name);
1049: BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension(
1050: p_Api_Version => p_Api_Version
1051: ,p_Commit => p_Commit
1052: ,p_Meas_Extn_Rec => l_Mes_up_Rec
1053: ,x_Return_Status => x_Return_Status

Line 1087: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';

1083: WHEN NO_DATA_FOUND THEN
1084: ROLLBACK TO LoadMeasExtnPSP;
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: IF (x_msg_data IS NOT NULL) THEN
1087: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';
1088: ELSE
1089: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';
1090: END IF;
1091: WHEN OTHERS THEN

Line 1089: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';

1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1086: IF (x_msg_data IS NOT NULL) THEN
1087: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';
1088: ELSE
1089: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';
1090: END IF;
1091: WHEN OTHERS THEN
1092: ROLLBACK TO LoadMeasExtnPSP;
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1095: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';

1091: WHEN OTHERS THEN
1092: ROLLBACK TO LoadMeasExtnPSP;
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: IF (x_msg_data IS NOT NULL) THEN
1095: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';
1096: ELSE
1097: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';
1098: END IF;
1099: END Load_Measure_Extension;

Line 1097: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';

1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: IF (x_msg_data IS NOT NULL) THEN
1095: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';
1096: ELSE
1097: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Load_Measure_Extension ';
1098: END IF;
1099: END Load_Measure_Extension;
1100: /*********************************************************************************************
1101: FUNCTION Name :- Delete_Measure_Extension

Line 1112: ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type

1108:
1109: PROCEDURE Delete_Measure_Extension(
1110: p_Api_Version IN NUMBER
1111: ,p_Commit IN VARCHAR2
1112: ,p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
1113: ,x_Return_Status OUT NOCOPY VARCHAR2
1114: ,x_Msg_Count OUT NOCOPY NUMBER
1115: ,x_Msg_Data OUT NOCOPY VARCHAR2
1116: ) IS

Line 1181: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';

1177: WHEN NO_DATA_FOUND THEN
1178: ROLLBACK TO DeleteMeasExtnPSP;
1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: IF (x_msg_data IS NOT NULL) THEN
1181: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';
1182: ELSE
1183: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';
1184: END IF;
1185: WHEN OTHERS THEN

Line 1183: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';

1179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: IF (x_msg_data IS NOT NULL) THEN
1181: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';
1182: ELSE
1183: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';
1184: END IF;
1185: WHEN OTHERS THEN
1186: ROLLBACK TO DeleteMeasExtnPSP;
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1189: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';

1185: WHEN OTHERS THEN
1186: ROLLBACK TO DeleteMeasExtnPSP;
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: IF (x_msg_data IS NOT NULL) THEN
1189: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';
1190: ELSE
1191: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';
1192: END IF;
1193:

Line 1191: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';

1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: IF (x_msg_data IS NOT NULL) THEN
1189: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';
1190: ELSE
1191: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension ';
1192: END IF;
1193:
1194: END Delete_Measure_Extension;
1195:

Line 1216: p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type

1212: END Get_FA_Id_By_Short_Name;
1213:
1214: -- Validation APIs
1215: PROCEDURE Validate_Measure_Extension(
1216: p_Meas_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type
1217: ,p_Action_Type IN VARCHAR2
1218: ,x_Return_Status OUT NOCOPY VARCHAR2
1219: ,x_Msg_Count OUT NOCOPY NUMBER
1220: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 1223: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;

1219: ,x_Msg_Count OUT NOCOPY NUMBER
1220: ,x_Msg_Data OUT NOCOPY VARCHAR2
1221: ) IS
1222: l_Count NUMBER;
1223: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
1224: BEGIN
1225: FND_MSG_PUB.Initialize;
1226: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1227: l_Meas_Extn_Rec := p_Meas_Extn_Rec;

Line 1236: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE OR p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_CREATE) THEN

1232: FND_MSG_PUB.ADD;
1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1234: END IF;
1235: --dbms_output.put_line('FROM CREATE 1');
1236: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE OR p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_CREATE) THEN
1237: IF(Trim(l_Meas_Extn_Rec.Functional_Area_Id) IS NULL) THEN
1238: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');
1239: FND_MSG_PUB.ADD;
1240: RAISE FND_API.G_EXC_ERROR;

Line 1323: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';

1319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1320: WHEN NO_DATA_FOUND THEN
1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1322: IF (x_msg_data IS NOT NULL) THEN
1323: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';
1324: ELSE
1325: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';
1326: END IF;
1327: WHEN OTHERS THEN

Line 1325: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';

1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1322: IF (x_msg_data IS NOT NULL) THEN
1323: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';
1324: ELSE
1325: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';
1326: END IF;
1327: WHEN OTHERS THEN
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1329: IF (x_msg_data IS NOT NULL) THEN

Line 1330: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';

1326: END IF;
1327: WHEN OTHERS THEN
1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1329: IF (x_msg_data IS NOT NULL) THEN
1330: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';
1331: ELSE
1332: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';
1333: END IF;
1334: END Validate_Measure_Extension;

Line 1332: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';

1328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1329: IF (x_msg_data IS NOT NULL) THEN
1330: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';
1331: ELSE
1332: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Measure_Extension ';
1333: END IF;
1334: END Validate_Measure_Extension;
1335:
1336:

Line 1347: p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type

1343: AUTHOR :- KRISHNA
1344: *********************************************************************************************/
1345:
1346: PROCEDURE Validate_Form_Func_Extension(
1347: p_Form_Func_Extn_Rec IN BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type
1348: ,p_Action_Type IN VARCHAR2
1349: ,x_Return_Status OUT NOCOPY VARCHAR2
1350: ,x_Msg_Count OUT NOCOPY NUMBER
1351: ,x_Msg_Data OUT NOCOPY VARCHAR2

Line 1376: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_CREATE) THEN

1372: FND_MSG_PUB.ADD;
1373: RAISE FND_API.G_EXC_ERROR;
1374: END IF;
1375:
1376: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_CREATE) THEN
1377: IF(l_cnt_sht_name <> 0 ) THEN
1378: FND_MESSAGE.SET_NAME('BIS','BIS_FORM_FUNC_EXISTS');
1379: FND_MESSAGE.SET_TOKEN('FORM_FUNC',Trim(p_Form_Func_Extn_Rec.Object_Name));
1380: FND_MSG_PUB.ADD;

Line 1385: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE) THEN

1381: RAISE FND_API.G_EXC_ERROR;
1382: END IF;
1383: END IF;
1384:
1385: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE) THEN
1386: IF(l_cnt_sht_name = 0 ) THEN
1387: FND_MESSAGE.SET_NAME('BIS','BIS_FORM_FUNC_SHTNAME_NOTEXIST');
1388: FND_MESSAGE.SET_TOKEN('FORM_FUNC',Trim(p_Form_Func_Extn_Rec.Object_Name));
1389: FND_MSG_PUB.ADD;

Line 1394: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE OR p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_CREATE) THEN

1390: RAISE FND_API.G_EXC_ERROR;
1391: END IF;
1392: END IF;
1393:
1394: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_UPDATE OR p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_CREATE) THEN
1395: IF(Trim(p_Form_Func_Extn_Rec.Func_Area_Id) IS NULL) THEN
1396: FND_MESSAGE.SET_NAME('BIS','BIS_FUNC_ID_NOT_ENTERED');
1397: FND_MSG_PUB.ADD;
1398: RAISE FND_API.G_EXC_ERROR;

Line 1425: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_LOAD) THEN

1421:
1422: END IF;
1423: END IF;
1424:
1425: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_LOAD) THEN
1426: IF(Trim(p_Form_Func_Extn_Rec.Func_Area_short_name) IS NULL) THEN
1427: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_IS_NULL');
1428: FND_MSG_PUB.ADD;
1429: RAISE FND_API.G_EXC_ERROR;

Line 1443: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_TRANS OR p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_DELETE OR p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_RETRIEVE) THEN

1439: RAISE FND_API.G_EXC_ERROR;
1440: END IF;
1441: END IF;
1442: END IF;
1443: IF(p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_TRANS OR p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_DELETE OR p_Action_Type = BIS_OBJECT_EXTENSIONS_PUB.C_RETRIEVE) THEN
1444: IF(l_cnt_sht_name = 0 ) THEN
1445: FND_MESSAGE.SET_NAME('BIS','BIS_FORM_FUNC_SHTNAME_NOTEXIST');
1446: FND_MESSAGE.SET_TOKEN('FORM_FUNC',Trim(p_Form_Func_Extn_Rec.Object_Name));
1447: FND_MSG_PUB.ADD;

Line 1474: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';

1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1471: WHEN NO_DATA_FOUND THEN
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF (x_msg_data IS NOT NULL) THEN
1474: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';
1475: ELSE
1476: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';
1477: END IF;
1478: WHEN OTHERS THEN

Line 1476: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';

1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF (x_msg_data IS NOT NULL) THEN
1474: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';
1475: ELSE
1476: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';
1477: END IF;
1478: WHEN OTHERS THEN
1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1480: IF (x_msg_data IS NOT NULL) THEN

Line 1481: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';

1477: END IF;
1478: WHEN OTHERS THEN
1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1480: IF (x_msg_data IS NOT NULL) THEN
1481: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';
1482: ELSE
1483: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';
1484: END IF;
1485: END Validate_Form_Func_Extension;

Line 1483: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';

1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1480: IF (x_msg_data IS NOT NULL) THEN
1481: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';
1482: ELSE
1483: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Validate_Form_Func_Extension ';
1484: END IF;
1485: END Validate_Form_Func_Extension;
1486:
1487: /*********************************************************************************************

Line 1511: IF (p_object_type <> BIS_OBJECT_EXTENSIONS_PUB.C_MEASURE) THEN

1507: IS
1508: l_count NUMBER;
1509: BEGIN
1510:
1511: IF (p_object_type <> BIS_OBJECT_EXTENSIONS_PUB.C_MEASURE) THEN
1512:
1513: SELECT COUNT(0)
1514: INTO l_count
1515: FROM BIS_FORM_FUNCTION_EXTENSION

Line 1561: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;

1557: , x_Msg_Count OUT NOCOPY NUMBER
1558: , x_Msg_Data OUT NOCOPY VARCHAR2
1559:
1560: ) IS
1561: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
1562: l_Mes_up_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
1563: BEGIN
1564: FND_MSG_PUB.Initialize;
1565: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 1562: l_Mes_up_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;

1558: , x_Msg_Data OUT NOCOPY VARCHAR2
1559:
1560: ) IS
1561: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
1562: l_Mes_up_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
1563: BEGIN
1564: FND_MSG_PUB.Initialize;
1565: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1566:

Line 1567: IF(p_Obj_Type=BIS_OBJECT_EXTENSIONS_PUB.C_MEASURE) THEN

1563: BEGIN
1564: FND_MSG_PUB.Initialize;
1565: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1566:
1567: IF(p_Obj_Type=BIS_OBJECT_EXTENSIONS_PUB.C_MEASURE) THEN
1568: BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map
1569: (
1570: p_Api_Version => p_Api_Version
1571: , p_Commit => p_Commit

Line 1568: BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map

1564: FND_MSG_PUB.Initialize;
1565: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1566:
1567: IF(p_Obj_Type=BIS_OBJECT_EXTENSIONS_PUB.C_MEASURE) THEN
1568: BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map
1569: (
1570: p_Api_Version => p_Api_Version
1571: , p_Commit => p_Commit
1572: , p_Obj_Type => p_Obj_Type

Line 1584: BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map

1580: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1581: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1582: END IF;
1583: ELSE
1584: BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map
1585: (
1586: p_Api_Version => p_Api_Version
1587: , p_Commit => p_Commit
1588: , p_Obj_Type => p_Obj_Type

Line 1622: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';

1618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1619: WHEN NO_DATA_FOUND THEN
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: IF (x_msg_data IS NOT NULL) THEN
1622: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';
1623: ELSE
1624: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';
1625: END IF;
1626: WHEN OTHERS THEN

Line 1624: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';

1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: IF (x_msg_data IS NOT NULL) THEN
1622: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';
1623: ELSE
1624: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';
1625: END IF;
1626: WHEN OTHERS THEN
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1628: IF (x_msg_data IS NOT NULL) THEN

Line 1629: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';

1625: END IF;
1626: WHEN OTHERS THEN
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1628: IF (x_msg_data IS NOT NULL) THEN
1629: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';
1630: ELSE
1631: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';
1632: END IF;
1633:

Line 1631: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';

1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1628: IF (x_msg_data IS NOT NULL) THEN
1629: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';
1630: ELSE
1631: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Object_Funct_Area_Map ';
1632: END IF;
1633:
1634: END Object_Funct_Area_Map;
1635:

Line 1673: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;

1669: , x_Msg_Count OUT NOCOPY NUMBER
1670: , x_Msg_Data OUT NOCOPY VARCHAR2
1671: )IS
1672: l_count NUMBER;
1673: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
1674: BEGIN
1675: FND_MSG_PUB.Initialize;
1676: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1677:

Line 1693: BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension

1689: l_Meas_Extn_Rec.Last_Updated_By := FND_GLOBAL.user_id;
1690: l_Meas_Extn_Rec.Last_Update_Date := SYSDATE;
1691: l_Meas_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
1692:
1693: BIS_OBJECT_EXTENSIONS_PUB.Update_Measure_Extension
1694: (
1695: p_Api_Version => p_Api_Version
1696: , p_Commit => p_Commit
1697: , p_Meas_Extn_Rec => l_Meas_Extn_Rec

Line 1710: BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension

1706: x_Msg_Data := FND_MESSAGE.GET;
1707: END IF;
1708: ELSE
1709: l_Meas_Extn_Rec.Measure_Short_Name := p_Obj_Name;
1710: BIS_OBJECT_EXTENSIONS_PUB.Delete_Measure_Extension
1711: (
1712: p_Api_Version => p_Api_Version
1713: , p_Commit => p_Commit
1714: , p_Meas_Extn_Rec => l_Meas_Extn_Rec

Line 1744: BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension

1740: l_Meas_Extn_Rec.Last_Updated_By := FND_GLOBAL.user_id;
1741: l_Meas_Extn_Rec.Last_Update_Date := SYSDATE;
1742: l_Meas_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
1743:
1744: BIS_OBJECT_EXTENSIONS_PUB.Create_Measure_Extension
1745: (
1746: p_Api_Version => p_Api_Version
1747: , p_Commit => p_Commit
1748: , p_Meas_Extn_Rec => l_Meas_Extn_Rec

Line 1783: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';

1779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1780: WHEN NO_DATA_FOUND THEN
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: IF (x_msg_data IS NOT NULL) THEN
1783: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';
1784: ELSE
1785: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';
1786: END IF;
1787: WHEN OTHERS THEN

Line 1785: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';

1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: IF (x_msg_data IS NOT NULL) THEN
1783: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';
1784: ELSE
1785: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';
1786: END IF;
1787: WHEN OTHERS THEN
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: IF (x_msg_data IS NOT NULL) THEN

Line 1790: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';

1786: END IF;
1787: WHEN OTHERS THEN
1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: IF (x_msg_data IS NOT NULL) THEN
1790: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';
1791: ELSE
1792: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';
1793: END IF;
1794: END Measure_Funct_Area_Map;

Line 1792: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';

1788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1789: IF (x_msg_data IS NOT NULL) THEN
1790: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';
1791: ELSE
1792: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map ';
1793: END IF;
1794: END Measure_Funct_Area_Map;
1795:
1796: /*********************************************************************************************

Line 1833: l_From_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;

1829: , x_Msg_Count OUT NOCOPY NUMBER
1830: , x_Msg_Data OUT NOCOPY VARCHAR2
1831: )IS
1832: l_count NUMBER;
1833: l_From_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
1834: --l_out VARCHAR2(3);
1835: BEGIN
1836: FND_MSG_PUB.Initialize;
1837: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

Line 1856: BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension

1852: l_From_Func_Extn_Rec.Last_Updated_By := FND_GLOBAL.user_id;
1853: l_From_Func_Extn_Rec.Last_Update_Date := SYSDATE;
1854: l_From_Func_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
1855:
1856: BIS_OBJECT_EXTENSIONS_PUB.Update_Form_Func_Extension
1857: (
1858: p_Api_Version => p_Api_Version
1859: , p_Commit => p_Commit
1860: , p_Form_Func_Extn_Rec => l_From_Func_Extn_Rec

Line 1873: BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension

1869: x_Msg_Data := FND_MESSAGE.GET;
1870: END IF;
1871: ELSE
1872: l_From_Func_Extn_Rec.Object_Name := p_Obj_Name;
1873: BIS_OBJECT_EXTENSIONS_PUB.Delete_Form_Func_Extension
1874: (
1875: p_Api_Version => p_Api_Version
1876: , p_Commit => p_Commit
1877: , p_Form_Func_Extn_Rec => l_From_Func_Extn_Rec

Line 1909: BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension

1905: l_From_Func_Extn_Rec.Last_Updated_By := FND_GLOBAL.user_id;
1906: l_From_Func_Extn_Rec.Last_Update_Date := SYSDATE;
1907: l_From_Func_Extn_Rec.Last_Update_Login := FND_GLOBAL.LOGIN_ID;
1908:
1909: BIS_OBJECT_EXTENSIONS_PUB.Create_Form_Func_Extension
1910: (
1911: p_Api_Version => p_Api_Version
1912: , p_Commit => p_Commit
1913: , p_Form_Func_Extn_Rec => l_From_Func_Extn_Rec

Line 1948: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';

1944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1945: WHEN NO_DATA_FOUND THEN
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1947: IF (x_msg_data IS NOT NULL) THEN
1948: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';
1949: ELSE
1950: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';
1951: END IF;
1952: WHEN OTHERS THEN

Line 1950: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';

1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1947: IF (x_msg_data IS NOT NULL) THEN
1948: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';
1949: ELSE
1950: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';
1951: END IF;
1952: WHEN OTHERS THEN
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: IF (x_msg_data IS NOT NULL) THEN

Line 1955: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';

1951: END IF;
1952: WHEN OTHERS THEN
1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: IF (x_msg_data IS NOT NULL) THEN
1955: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';
1956: ELSE
1957: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';
1958: END IF;
1959: END Form_Func_Functional_Area_Map;

Line 1957: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';

1953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1954: IF (x_msg_data IS NOT NULL) THEN
1955: x_msg_data := x_msg_data||' -> BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';
1956: ELSE
1957: x_msg_data := SQLERRM||' at BIS_OBJECT_EXTENSIONS_PUB.Form_Func_Functional_Area_Map ';
1958: END IF;
1959: END Form_Func_Functional_Area_Map;
1960: PROCEDURE ADD_LANGUAGE
1961: IS

Line 1966: END BIS_OBJECT_EXTENSIONS_PUB;

1962: BEGIN
1963: BIS_OBJECT_EXTENSIONS_PVT.ADD_LANGUAGE;
1964: END ADD_LANGUAGE;
1965:
1966: END BIS_OBJECT_EXTENSIONS_PUB;