DBA Data[Home] [Help]

APPS.BIS_OBJECT_EXTENSIONS_PVT dependencies on FND_MSG_PUB

Line 46: FND_MSG_PUB.Initialize;

42: l_Commit VARCHAR2(30);
43: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
44: BEGIN
45: SAVEPOINT CreateFormFuncSP_Pvt;
46: FND_MSG_PUB.Initialize;
47: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
48: IF( p_Commit IS NULL) THEN
49: l_Commit := FND_API.G_FALSE;
50: ELSE

Line 132: FND_MSG_PUB.Count_And_Get

128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: ROLLBACK TO CreateFormFuncSP_Pvt;
131: IF (x_msg_data IS NULL) THEN
132: FND_MSG_PUB.Count_And_Get
133: ( p_encoded => FND_API.G_FALSE
134: , p_count => x_msg_count
135: , p_data => x_msg_data
136: );

Line 142: FND_MSG_PUB.Count_And_Get

138: x_return_status := FND_API.G_RET_STS_ERROR;
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: ROLLBACK TO CreateFormFuncSP_Pvt;
141: IF (x_msg_data IS NULL) THEN
142: FND_MSG_PUB.Count_And_Get
143: ( p_encoded => FND_API.G_FALSE
144: , p_count => x_msg_count
145: , p_data => x_msg_data
146: );

Line 189: FND_MSG_PUB.Initialize;

185: l_Commit VARCHAR2(30);
186: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
187: BEGIN
188: SAVEPOINT UpdateFormFuncSP;
189: FND_MSG_PUB.Initialize;
190: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
191: IF( p_Commit IS NULL) THEN
192: l_Commit := FND_API.G_FALSE;
193: ELSE

Line 262: FND_MSG_PUB.Count_And_Get

258: EXCEPTION
259: WHEN FND_API.G_EXC_ERROR THEN
260: ROLLBACK TO UpdateFormFuncSP;
261: IF (x_msg_data IS NULL) THEN
262: FND_MSG_PUB.Count_And_Get
263: ( p_encoded => FND_API.G_FALSE
264: , p_count => x_msg_count
265: , p_data => x_msg_data
266: );

Line 272: FND_MSG_PUB.Count_And_Get

268: x_return_status := FND_API.G_RET_STS_ERROR;
269: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
270: ROLLBACK TO UpdateFormFuncSP;
271: IF (x_msg_data IS NULL) THEN
272: FND_MSG_PUB.Count_And_Get
273: ( p_encoded => FND_API.G_FALSE
274: , p_count => x_msg_count
275: , p_data => x_msg_data
276: );

Line 319: FND_MSG_PUB.Initialize;

315: l_Form_Func_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
316: l_valid_func_ext_rec BIS_OBJECT_EXTENSIONS_PUB.Form_Function_Extension_Type;
317: BEGIN
318: SAVEPOINT TransalteFormFuncSP;
319: FND_MSG_PUB.Initialize;
320: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
321: IF( p_Commit IS NULL) THEN
322: l_Commit := FND_API.G_FALSE;
323: ELSE

Line 391: FND_MSG_PUB.Count_And_Get

387: EXCEPTION
388: WHEN FND_API.G_EXC_ERROR THEN
389: ROLLBACK TO TransalteFormFuncSP;
390: IF (x_msg_data IS NULL) THEN
391: FND_MSG_PUB.Count_And_Get
392: ( p_encoded => FND_API.G_FALSE
393: , p_count => x_msg_count
394: , p_data => x_msg_data
395: );

Line 401: FND_MSG_PUB.Count_And_Get

397: x_return_status := FND_API.G_RET_STS_ERROR;
398: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
399: ROLLBACK TO TransalteFormFuncSP;
400: IF (x_msg_data IS NULL) THEN
401: FND_MSG_PUB.Count_And_Get
402: ( p_encoded => FND_API.G_FALSE
403: , p_count => x_msg_count
404: , p_data => x_msg_data
405: );

Line 444: FND_MSG_PUB.Initialize;

440: , x_Msg_Data OUT NOCOPY VARCHAR2
441: )IS
442:
443: BEGIN
444: FND_MSG_PUB.Initialize;
445: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
446:
447: ----dbms_output.put_line('before retrieve');
448:

Line 477: FND_MSG_PUB.Count_And_Get

473: ----dbms_output.put_line('after retrieve');
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR THEN
476: IF (x_msg_data IS NULL) THEN
477: FND_MSG_PUB.Count_And_Get
478: ( p_encoded => FND_API.G_FALSE
479: , p_count => x_msg_count
480: , p_data => x_msg_data
481: );

Line 486: FND_MSG_PUB.Count_And_Get

482: END IF;
483: x_return_status := FND_API.G_RET_STS_ERROR;
484: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
485: IF (x_msg_data IS NULL) THEN
486: FND_MSG_PUB.Count_And_Get
487: ( p_encoded => FND_API.G_FALSE
488: , p_count => x_msg_count
489: , p_data => x_msg_data
490: );

Line 526: FND_MSG_PUB.Initialize;

522: , x_Msg_Data OUT NOCOPY VARCHAR2
523: )IS
524: BEGIN
525: SAVEPOINT DeleteFormFuncSP_Pvt;
526: FND_MSG_PUB.Initialize;
527: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
528: -- Delete from base table
529: DELETE FROM BIS_FORM_FUNCTION_EXTENSION
530: WHERE OBJECT_NAME = TRIM(p_Form_Func_Extn_Rec.Object_Name);

Line 543: FND_MSG_PUB.Count_And_Get

539: EXCEPTION
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO DeleteFormFuncSP_Pvt;
542: IF (x_msg_data IS NULL) THEN
543: FND_MSG_PUB.Count_And_Get
544: ( p_encoded => FND_API.G_FALSE
545: , p_count => x_msg_count
546: , p_data => x_msg_data
547: );

Line 553: FND_MSG_PUB.Count_And_Get

549: x_return_status := FND_API.G_RET_STS_ERROR;
550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
551: ROLLBACK TO DeleteFormFuncSP_Pvt;
552: IF (x_msg_data IS NULL) THEN
553: FND_MSG_PUB.Count_And_Get
554: ( p_encoded => FND_API.G_FALSE
555: , p_count => x_msg_count
556: , p_data => x_msg_data
557: );

Line 592: FND_MSG_PUB.Initialize;

588: l_Count NUMBER;
589: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
590: BEGIN
591: SAVEPOINT CreateMeasExtnSP;
592: FND_MSG_PUB.Initialize;
593:
594: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
595: l_Meas_Extn_Rec := p_Meas_Extn_Rec;
596:

Line 676: FND_MSG_PUB.Count_And_Get

672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: ROLLBACK TO CreateMeasExtnSP;
675: IF (x_msg_data IS NULL) THEN
676: FND_MSG_PUB.Count_And_Get
677: ( p_encoded => FND_API.G_FALSE
678: , p_count => x_msg_count
679: , p_data => x_msg_data
680: );

Line 686: FND_MSG_PUB.Count_And_Get

682: x_return_status := FND_API.G_RET_STS_ERROR;
683: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
684: ROLLBACK TO CreateMeasExtnSP;
685: IF (x_msg_data IS NULL) THEN
686: FND_MSG_PUB.Count_And_Get
687: ( p_encoded => FND_API.G_FALSE
688: , p_count => x_msg_count
689: , p_data => x_msg_data
690: );

Line 737: FND_MSG_PUB.Initialize;

733: FROM BIS_MEASURES_EXTENSION_VL B
734: WHERE B.MEASURE_SHORT_NAME = TRIM(p_Meas_Extn_Rec.Measure_Short_Name);
735:
736: BEGIN
737: FND_MSG_PUB.Initialize;
738: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
739:
740: l_Flag := FALSE;
741:

Line 762: FND_MSG_PUB.Count_And_Get

758:
759: EXCEPTION
760: WHEN FND_API.G_EXC_ERROR THEN
761: IF (x_msg_data IS NULL) THEN
762: FND_MSG_PUB.Count_And_Get
763: ( p_encoded => FND_API.G_FALSE
764: , p_count => x_msg_count
765: , p_data => x_msg_data
766: );

Line 771: FND_MSG_PUB.Count_And_Get

767: END IF;
768: x_return_status := FND_API.G_RET_STS_ERROR;
769: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
770: IF (x_msg_data IS NULL) THEN
771: FND_MSG_PUB.Count_And_Get
772: ( p_encoded => FND_API.G_FALSE
773: , p_count => x_msg_count
774: , p_data => x_msg_data
775: );

Line 806: FND_MSG_PUB.Initialize;

802: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
803: BEGIN
804:
805: SAVEPOINT TranslateMeasExtnSP;
806: FND_MSG_PUB.Initialize;
807:
808: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
809:
810: ------dbms_output.put_line ('l_Meas_Extn_Rec.Measure_Short_Name - ' || l_Meas_Extn_Rec.Measure_Short_Name);

Line 882: FND_MSG_PUB.Count_And_Get

878: EXCEPTION
879: WHEN FND_API.G_EXC_ERROR THEN
880: ROLLBACK TO TranslateMeasExtnSP;
881: IF (x_msg_data IS NULL) THEN
882: FND_MSG_PUB.Count_And_Get
883: ( p_encoded => FND_API.G_FALSE
884: , p_count => x_msg_count
885: , p_data => x_msg_data
886: );

Line 892: FND_MSG_PUB.Count_And_Get

888: x_return_status := FND_API.G_RET_STS_ERROR;
889: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
890: ROLLBACK TO TranslateMeasExtnSP;
891: IF (x_msg_data IS NULL) THEN
892: FND_MSG_PUB.Count_And_Get
893: ( p_encoded => FND_API.G_FALSE
894: , p_count => x_msg_count
895: , p_data => x_msg_data
896: );

Line 931: FND_MSG_PUB.Initialize;

927: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
928:
929: BEGIN
930: SAVEPOINT UpdateMeasExtnSP;
931: FND_MSG_PUB.Initialize;
932:
933: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
934:
935: -- Since there is no base table, a direct transalation

Line 1002: FND_MSG_PUB.Count_And_Get

998: EXCEPTION
999: WHEN FND_API.G_EXC_ERROR THEN
1000: ROLLBACK TO UpdateMeasExtnSP;
1001: IF (x_msg_data IS NULL) THEN
1002: FND_MSG_PUB.Count_And_Get
1003: ( p_encoded => FND_API.G_FALSE
1004: , p_count => x_msg_count
1005: , p_data => x_msg_data
1006: );

Line 1012: FND_MSG_PUB.Count_And_Get

1008: x_return_status := FND_API.G_RET_STS_ERROR;
1009: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1010: ROLLBACK TO UpdateMeasExtnSP;
1011: IF (x_msg_data IS NULL) THEN
1012: FND_MSG_PUB.Count_And_Get
1013: ( p_encoded => FND_API.G_FALSE
1014: , p_count => x_msg_count
1015: , p_data => x_msg_data
1016: );

Line 1054: FND_MSG_PUB.Initialize;

1050: ) IS
1051:
1052: BEGIN
1053: SAVEPOINT DeleteMeasExtnSP;
1054: FND_MSG_PUB.Initialize;
1055: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1056:
1057: DELETE FROM BIS_MEASURES_EXTENSION
1058: WHERE MEASURE_SHORT_NAME = TRIM(p_Meas_Extn_Rec.Measure_Short_Name);

Line 1073: FND_MSG_PUB.Count_And_Get

1069: EXCEPTION
1070: WHEN FND_API.G_EXC_ERROR THEN
1071: ROLLBACK TO DeleteMeasExtnSP;
1072: IF (x_msg_data IS NULL) THEN
1073: FND_MSG_PUB.Count_And_Get
1074: ( p_encoded => FND_API.G_FALSE
1075: , p_count => x_msg_count
1076: , p_data => x_msg_data
1077: );

Line 1083: FND_MSG_PUB.Count_And_Get

1079: x_return_status := FND_API.G_RET_STS_ERROR;
1080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1081: ROLLBACK TO DeleteMeasExtnSP;
1082: IF (x_msg_data IS NULL) THEN
1083: FND_MSG_PUB.Count_And_Get
1084: ( p_encoded => FND_API.G_FALSE
1085: , p_count => x_msg_count
1086: , p_data => x_msg_data
1087: );