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 FND_MSG_PUB

Line 104: FND_MSG_PUB.Initialize;

100: , x_Msg_Data OUT NOCOPY VARCHAR2
101: )IS
102:
103: BEGIN
104: FND_MSG_PUB.Initialize;
105: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
106:
107: BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Form_Func_Extension(
108: p_Form_Func_Extn_Rec => p_Form_Func_Extn_Rec

Line 123: FND_MSG_PUB.Count_And_Get

119: --dbms_output.put_line('after retrieve');
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: IF (x_msg_data IS NULL) THEN
123: FND_MSG_PUB.Count_And_Get
124: ( p_encoded => FND_API.G_FALSE
125: , p_count => x_msg_count
126: , p_data => x_msg_data
127: );

Line 132: FND_MSG_PUB.Count_And_Get

128: END IF;
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
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 174: FND_MSG_PUB.Initialize;

170: l_Commit VARCHAR2(30);
171:
172: BEGIN
173: SAVEPOINT TransalteFormFuncPSP;
174: FND_MSG_PUB.Initialize;
175: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
176: IF( p_Commit IS NULL) THEN
177: l_Commit := FND_API.G_FALSE;
178: ELSE

Line 212: FND_MSG_PUB.Count_And_Get

208: EXCEPTION
209: WHEN FND_API.G_EXC_ERROR THEN
210: ROLLBACK TO TransalteFormFuncPSP;
211: IF (x_msg_data IS NULL) THEN
212: FND_MSG_PUB.Count_And_Get
213: ( p_encoded => FND_API.G_FALSE
214: , p_count => x_msg_count
215: , p_data => x_msg_data
216: );

Line 222: FND_MSG_PUB.Count_And_Get

218: x_return_status := FND_API.G_RET_STS_ERROR;
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO TransalteFormFuncPSP;
221: IF (x_msg_data IS NULL) THEN
222: FND_MSG_PUB.Count_And_Get
223: ( p_encoded => FND_API.G_FALSE
224: , p_count => x_msg_count
225: , p_data => x_msg_data
226: );

Line 266: FND_MSG_PUB.Initialize;

262: l_Commit VARCHAR2(30);
263:
264: BEGIN
265: SAVEPOINT UpdateFormFuncPSP;
266: FND_MSG_PUB.Initialize;
267: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
268: IF( p_Commit IS NULL) THEN
269: l_Commit := FND_API.G_FALSE;
270: ELSE

Line 305: FND_MSG_PUB.Count_And_Get

301: EXCEPTION
302: WHEN FND_API.G_EXC_ERROR THEN
303: ROLLBACK TO UpdateFormFuncPSP;
304: IF (x_msg_data IS NULL) THEN
305: FND_MSG_PUB.Count_And_Get
306: ( p_encoded => FND_API.G_FALSE
307: , p_count => x_msg_count
308: , p_data => x_msg_data
309: );

Line 315: FND_MSG_PUB.Count_And_Get

311: x_return_status := FND_API.G_RET_STS_ERROR;
312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: ROLLBACK TO UpdateFormFuncPSP;
314: IF (x_msg_data IS NULL) THEN
315: FND_MSG_PUB.Count_And_Get
316: ( p_encoded => FND_API.G_FALSE
317: , p_count => x_msg_count
318: , p_data => x_msg_data
319: );

Line 359: FND_MSG_PUB.Initialize;

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;
360: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
361: IF( p_Commit IS NULL) THEN
362: l_Commit := FND_API.G_FALSE;
363: ELSE

Line 398: FND_MSG_PUB.Count_And_Get

394: EXCEPTION
395: WHEN FND_API.G_EXC_ERROR THEN
396: ROLLBACK TO CreateFormFuncPSP;
397: IF (x_msg_data IS NULL) THEN
398: FND_MSG_PUB.Count_And_Get
399: ( p_encoded => FND_API.G_FALSE
400: , p_count => x_msg_count
401: , p_data => x_msg_data
402: );

Line 408: FND_MSG_PUB.Count_And_Get

404: x_return_status := FND_API.G_RET_STS_ERROR;
405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
406: ROLLBACK TO CreateFormFuncPSP;
407: IF (x_msg_data IS NULL) THEN
408: FND_MSG_PUB.Count_And_Get
409: ( p_encoded => FND_API.G_FALSE
410: , p_count => x_msg_count
411: , p_data => x_msg_data
412: );

Line 455: FND_MSG_PUB.Initialize;

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;
457: IF( p_Commit IS NULL) THEN
458: l_Commit := FND_API.G_FALSE;
459: ELSE

Line 520: FND_MSG_PUB.Count_And_Get

516: EXCEPTION
517: WHEN FND_API.G_EXC_ERROR THEN
518: ROLLBACK TO LoadFormFuncPSP;
519: IF (x_msg_data IS NULL) THEN
520: FND_MSG_PUB.Count_And_Get
521: ( p_encoded => FND_API.G_FALSE
522: , p_count => x_msg_count
523: , p_data => x_msg_data
524: );

Line 530: FND_MSG_PUB.Count_And_Get

526: x_return_status := FND_API.G_RET_STS_ERROR;
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: ROLLBACK TO LoadFormFuncPSP;
529: IF (x_msg_data IS NULL) THEN
530: FND_MSG_PUB.Count_And_Get
531: ( p_encoded => FND_API.G_FALSE
532: , p_count => x_msg_count
533: , p_data => x_msg_data
534: );

Line 576: FND_MSG_PUB.Initialize;

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;
577: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
578: IF( p_Commit IS NULL) THEN
579: l_Commit := FND_API.G_FALSE;
580: ELSE

Line 615: FND_MSG_PUB.Count_And_Get

611: EXCEPTION
612: WHEN FND_API.G_EXC_ERROR THEN
613: ROLLBACK TO DeleteFormFuncPSP;
614: IF (x_msg_data IS NULL) THEN
615: FND_MSG_PUB.Count_And_Get
616: ( p_encoded => FND_API.G_FALSE
617: , p_count => x_msg_count
618: , p_data => x_msg_data
619: );

Line 625: FND_MSG_PUB.Count_And_Get

621: x_return_status := FND_API.G_RET_STS_ERROR;
622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
623: ROLLBACK TO DeleteFormFuncPSP;
624: IF (x_msg_data IS NULL) THEN
625: FND_MSG_PUB.Count_And_Get
626: ( p_encoded => FND_API.G_FALSE
627: , p_count => x_msg_count
628: , p_data => x_msg_data
629: );

Line 667: FND_MSG_PUB.Initialize;

663: ) IS
664:
665: BEGIN
666: SAVEPOINT CreateMeasExtnPSP;
667: FND_MSG_PUB.Initialize;
668:
669: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
670:
671: Validate_Measure_Extension(

Line 703: FND_MSG_PUB.Count_And_Get

699: EXCEPTION
700: WHEN FND_API.G_EXC_ERROR THEN
701: ROLLBACK TO CreateMeasExtnPSP;
702: IF (x_msg_data IS NULL) THEN
703: FND_MSG_PUB.Count_And_Get
704: ( p_encoded => FND_API.G_FALSE
705: , p_count => x_msg_count
706: , p_data => x_msg_data
707: );

Line 713: FND_MSG_PUB.Count_And_Get

709: x_return_status := FND_API.G_RET_STS_ERROR;
710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
711: ROLLBACK TO CreateMeasExtnPSP;
712: IF (x_msg_data IS NULL) THEN
713: FND_MSG_PUB.Count_And_Get
714: ( p_encoded => FND_API.G_FALSE
715: , p_count => x_msg_count
716: , p_data => x_msg_data
717: );

Line 749: FND_MSG_PUB.Initialize;

745: ,x_Msg_Data OUT NOCOPY VARCHAR2
746: ) IS
747:
748: BEGIN
749: FND_MSG_PUB.Initialize;
750: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
751:
752: BIS_OBJECT_EXTENSIONS_PVT.Retrieve_Measure_Extension(
753: p_Meas_Extn_Rec => p_Meas_Extn_Rec

Line 766: FND_MSG_PUB.Count_And_Get

762:
763: EXCEPTION
764: WHEN FND_API.G_EXC_ERROR THEN
765: IF (x_msg_data IS NULL) THEN
766: FND_MSG_PUB.Count_And_Get
767: ( p_encoded => FND_API.G_FALSE
768: , p_count => x_msg_count
769: , p_data => x_msg_data
770: );

Line 775: FND_MSG_PUB.Count_And_Get

771: END IF;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
774: IF (x_msg_data IS NULL) THEN
775: FND_MSG_PUB.Count_And_Get
776: ( p_encoded => FND_API.G_FALSE
777: , p_count => x_msg_count
778: , p_data => x_msg_data
779: );

Line 811: FND_MSG_PUB.Initialize;

807: l_Meas_Extn_Rec BIS_OBJECT_EXTENSIONS_PUB.Measure_Extension_Type;
808: BEGIN
809:
810: SAVEPOINT TranslateMeasExtnPSP;
811: FND_MSG_PUB.Initialize;
812:
813: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
814: l_Meas_Extn_Rec := p_Meas_Extn_Rec;
815:

Line 851: FND_MSG_PUB.Count_And_Get

847: EXCEPTION
848: WHEN FND_API.G_EXC_ERROR THEN
849: ROLLBACK TO TranslateMeasExtnPSP;
850: IF (x_msg_data IS NULL) THEN
851: FND_MSG_PUB.Count_And_Get
852: ( p_encoded => FND_API.G_FALSE
853: , p_count => x_msg_count
854: , p_data => x_msg_data
855: );

Line 861: FND_MSG_PUB.Count_And_Get

857: x_return_status := FND_API.G_RET_STS_ERROR;
858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
859: ROLLBACK TO TranslateMeasExtnPSP;
860: IF (x_msg_data IS NULL) THEN
861: FND_MSG_PUB.Count_And_Get
862: ( p_encoded => FND_API.G_FALSE
863: , p_count => x_msg_count
864: , p_data => x_msg_data
865: );

Line 899: FND_MSG_PUB.Initialize;

895: ) IS
896:
897: BEGIN
898: SAVEPOINT UpdateMeasExtnPSP;
899: FND_MSG_PUB.Initialize;
900:
901: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
902:
903: Validate_Measure_Extension(

Line 937: FND_MSG_PUB.Count_And_Get

933: EXCEPTION
934: WHEN FND_API.G_EXC_ERROR THEN
935: ROLLBACK TO UpdateMeasExtnPSP;
936: IF (x_msg_data IS NULL) THEN
937: FND_MSG_PUB.Count_And_Get
938: ( p_encoded => FND_API.G_FALSE
939: , p_count => x_msg_count
940: , p_data => x_msg_data
941: );

Line 947: FND_MSG_PUB.Count_And_Get

943: x_return_status := FND_API.G_RET_STS_ERROR;
944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
945: ROLLBACK TO UpdateMeasExtnPSP;
946: IF (x_msg_data IS NULL) THEN
947: FND_MSG_PUB.Count_And_Get
948: ( p_encoded => FND_API.G_FALSE
949: , p_count => x_msg_count
950: , p_data => x_msg_data
951: );

Line 985: FND_MSG_PUB.Initialize;

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;
987: Validate_Measure_Extension(
988: p_Meas_Extn_Rec => p_Meas_Extn_Rec
989: ,p_Action_Type => C_LOAD

Line 1021: FND_MSG_PUB.ADD;

1017: l_Meas_Extn_Rec.Functional_Area_Id := Get_FA_Id_By_Short_Name(l_Meas_Extn_Rec.Func_Area_Short_Name);
1018: IF (l_Meas_Extn_Rec.Functional_Area_Id = C_INVALID) THEN
1019: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_NOT_EXISTS');
1020: FND_MESSAGE.SET_TOKEN('SHORT_NAME', l_Meas_Extn_Rec.Func_Area_Short_Name);
1021: FND_MSG_PUB.ADD;
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024: END IF;
1025:

Line 1066: FND_MSG_PUB.Count_And_Get

1062: EXCEPTION
1063: WHEN FND_API.G_EXC_ERROR THEN
1064: ROLLBACK TO LoadMeasExtnPSP;
1065: IF (x_msg_data IS NULL) THEN
1066: FND_MSG_PUB.Count_And_Get
1067: ( p_encoded => FND_API.G_FALSE
1068: , p_count => x_msg_count
1069: , p_data => x_msg_data
1070: );

Line 1076: FND_MSG_PUB.Count_And_Get

1072: x_return_status := FND_API.G_RET_STS_ERROR;
1073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1074: ROLLBACK TO LoadMeasExtnPSP;
1075: IF (x_msg_data IS NULL) THEN
1076: FND_MSG_PUB.Count_And_Get
1077: ( p_encoded => FND_API.G_FALSE
1078: , p_count => x_msg_count
1079: , p_data => x_msg_data
1080: );

Line 1120: FND_MSG_PUB.Initialize;

1116: ) IS
1117: l_Commit VARCHAR2(30);
1118: BEGIN
1119: SAVEPOINT DeleteMeasExtnPSP;
1120: FND_MSG_PUB.Initialize;
1121: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1122: IF( p_Commit IS NULL) THEN
1123: l_Commit := FND_API.G_FALSE;
1124: ELSE

Line 1160: FND_MSG_PUB.Count_And_Get

1156: EXCEPTION
1157: WHEN FND_API.G_EXC_ERROR THEN
1158: ROLLBACK TO DeleteMeasExtnPSP;
1159: IF (x_msg_data IS NULL) THEN
1160: FND_MSG_PUB.Count_And_Get
1161: ( p_encoded => FND_API.G_FALSE
1162: , p_count => x_msg_count
1163: , p_data => x_msg_data
1164: );

Line 1170: FND_MSG_PUB.Count_And_Get

1166: x_return_status := FND_API.G_RET_STS_ERROR;
1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1168: ROLLBACK TO DeleteMeasExtnPSP;
1169: IF (x_msg_data IS NULL) THEN
1170: FND_MSG_PUB.Count_And_Get
1171: ( p_encoded => FND_API.G_FALSE
1172: , p_count => x_msg_count
1173: , p_data => x_msg_data
1174: );

Line 1225: FND_MSG_PUB.Initialize;

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;
1228: l_Count := 0;
1229:

Line 1232: FND_MSG_PUB.ADD;

1228: l_Count := 0;
1229:
1230: IF (BIS_UTILITIES_PVT.Value_Missing_Or_Null(TRIM(p_Meas_Extn_Rec.Measure_Short_Name)) = FND_API.G_TRUE) THEN
1231: FND_MESSAGE.SET_NAME('BIS','BIS_MX_SHORT_NAME_IS_NULL');
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

Line 1239: FND_MSG_PUB.ADD;

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;
1241: END IF;
1242:
1243: IF(BIS_UTILITIES_PVT.Value_Missing_Or_Null(p_Meas_Extn_Rec.Functional_Area_Id) = FND_API.G_FALSE) THEN

Line 1251: FND_MSG_PUB.ADD;

1247:
1248: IF (l_Count = 0) THEN
1249: FND_MESSAGE.SET_NAME('BIS','BIS_FUNCID_WRONG');
1250: FND_MESSAGE.SET_TOKEN('FORM_FUNC',TRIM(p_Meas_Extn_Rec.Functional_Area_Id));
1251: FND_MSG_PUB.ADD;
1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;
1254: END IF;
1255: END IF;

Line 1265: FND_MSG_PUB.ADD;

1261: IF (p_Action_Type = C_CREATE) THEN
1262: IF (l_Count <> 0) THEN
1263: FND_MESSAGE.SET_NAME('BIS','BIS_SHORT_NAME_EXISTS');
1264: FND_MESSAGE.SET_TOKEN('SHORT_NAME', Trim(l_Meas_Extn_Rec.Measure_Short_Name));
1265: FND_MSG_PUB.ADD;
1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: END IF;
1268: ELSIF (p_Action_Type = C_UPDATE) THEN
1269: IF (l_Count = 0) THEN

Line 1272: FND_MSG_PUB.ADD;

1268: ELSIF (p_Action_Type = C_UPDATE) THEN
1269: IF (l_Count = 0) THEN
1270: FND_MESSAGE.SET_NAME('BIS','BIS_SHORT_NAME_NOT_EXISTS');
1271: FND_MESSAGE.SET_TOKEN('SHORT_NAME', Trim(l_Meas_Extn_Rec.Measure_Short_Name));
1272: FND_MSG_PUB.ADD;
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: END IF;
1275: ELSIF (p_Action_Type = C_LOAD) THEN
1276: IF(Trim(l_Meas_Extn_Rec.Func_Area_Short_Name) IS NULL) THEN

Line 1278: FND_MSG_PUB.ADD;

1274: END IF;
1275: ELSIF (p_Action_Type = C_LOAD) THEN
1276: IF(Trim(l_Meas_Extn_Rec.Func_Area_Short_Name) IS NULL) THEN
1277: FND_MESSAGE.SET_NAME('BIS','BIS_FA_SHORT_NAME_IS_NULL');
1278: FND_MSG_PUB.ADD;
1279: RAISE FND_API.G_EXC_ERROR;
1280: ELSE
1281: SELECT COUNT(1)
1282: INTO l_Count

Line 1288: FND_MSG_PUB.ADD;

1284: WHERE UPPER(SHORT_NAME) = UPPER(TRIM(l_Meas_Extn_Rec.Func_Area_Short_Name));
1285: IF(l_Count = 0 ) THEN
1286: FND_MESSAGE.SET_NAME('BIS','BIS_FUNCSHTNAME_WRONG');
1287: FND_MESSAGE.SET_TOKEN('FORM_FUNC',Trim(l_Meas_Extn_Rec.Func_Area_Short_Name));
1288: FND_MSG_PUB.ADD;
1289: RAISE FND_API.G_EXC_ERROR;
1290: END IF;
1291: END IF;
1292: ELSIF (p_Action_Type = C_RETRIEVE OR p_Action_Type = C_DELETE OR p_Action_Type = C_TRANS) THEN

Line 1296: FND_MSG_PUB.ADD;

1292: ELSIF (p_Action_Type = C_RETRIEVE OR p_Action_Type = C_DELETE OR p_Action_Type = C_TRANS) THEN
1293: IF (l_Count = 0) THEN
1294: FND_MESSAGE.SET_NAME('BIS','BIS_SHORT_NAME_NOT_EXISTS');
1295: FND_MESSAGE.SET_TOKEN('SHORT_NAME', Trim(l_Meas_Extn_Rec.Measure_Short_Name));
1296: FND_MSG_PUB.ADD;
1297: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1298: END IF;
1299: END IF;
1300:

Line 1304: FND_MSG_PUB.Count_And_Get

1300:
1301: EXCEPTION
1302: WHEN FND_API.G_EXC_ERROR THEN
1303: IF (x_msg_data IS NULL) THEN
1304: FND_MSG_PUB.Count_And_Get
1305: ( p_encoded => FND_API.G_FALSE
1306: , p_count => x_msg_count
1307: , p_data => x_msg_data
1308: );

Line 1313: FND_MSG_PUB.Count_And_Get

1309: END IF;
1310: x_return_status := FND_API.G_RET_STS_ERROR;
1311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1312: IF (x_msg_data IS NULL) THEN
1313: FND_MSG_PUB.Count_And_Get
1314: ( p_encoded => FND_API.G_FALSE
1315: , p_count => x_msg_count
1316: , p_data => x_msg_data
1317: );

Line 1358: FND_MSG_PUB.Initialize;

1354: l_cnt_app_id NUMBER;
1355: l_cnt_sht_name NUMBER;
1356: l_cnt_func_id NUMBER;
1357: BEGIN
1358: FND_MSG_PUB.Initialize;
1359: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1360: SELECT COUNT(1)
1361: INTO l_cnt_sht_name
1362: FROM BIS_FORM_FUNCTION_EXTENSION

Line 1372: FND_MSG_PUB.ADD;

1368: WHERE FUNCTIONAL_AREA_ID = p_Form_Func_Extn_Rec.Func_Area_Id;
1369:
1370: IF (BIS_UTILITIES_PVT.Value_Missing_Or_Null(TRIM(p_Form_Func_Extn_Rec.Object_Name)) = FND_API.G_TRUE) THEN
1371: FND_MESSAGE.SET_NAME('BIS','BIS_FORM_FUNC_SHTNAME_NULL');
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

Line 1380: FND_MSG_PUB.ADD;

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;
1381: RAISE FND_API.G_EXC_ERROR;
1382: END IF;
1383: END IF;
1384:

Line 1389: FND_MSG_PUB.ADD;

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;
1390: RAISE FND_API.G_EXC_ERROR;
1391: END IF;
1392: END IF;
1393:

Line 1397: FND_MSG_PUB.ADD;

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;
1399: ELSE
1400: IF(l_cnt_func_id =0 ) THEN
1401: FND_MESSAGE.SET_NAME('BIS','BIS_FUNCID_WRONG');

Line 1403: FND_MSG_PUB.ADD;

1399: ELSE
1400: IF(l_cnt_func_id =0 ) THEN
1401: FND_MESSAGE.SET_NAME('BIS','BIS_FUNCID_WRONG');
1402: FND_MESSAGE.SET_TOKEN('FORM_FUNC',Trim(p_Form_Func_Extn_Rec.Func_Area_Id));
1403: FND_MSG_PUB.ADD;
1404: RAISE FND_API.G_EXC_ERROR;
1405: END IF;
1406: END IF;
1407: IF(TRIM(p_Form_Func_Extn_Rec.Application_Id) IS NULL ) THEN

Line 1409: FND_MSG_PUB.ADD;

1405: END IF;
1406: END IF;
1407: IF(TRIM(p_Form_Func_Extn_Rec.Application_Id) IS NULL ) THEN
1408: FND_MESSAGE.SET_NAME('BIS','BIS_APPID_CANNOT_NULL');
1409: FND_MSG_PUB.ADD;
1410: RAISE FND_API.G_EXC_ERROR;
1411: ELSE
1412: SELECT COUNT(1)
1413: INTO l_cnt_app_id

Line 1418: FND_MSG_PUB.ADD;

1414: FROM FND_APPLICATION
1415: WHERE APPLICATION_ID = p_Form_Func_Extn_Rec.Application_Id;
1416: IF(l_cnt_app_id = 0 ) THEN
1417: FND_MESSAGE.SET_NAME('BIS','BIS_APPID_WRONG');
1418: FND_MSG_PUB.ADD;
1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;
1421:
1422: END IF;

Line 1428: FND_MSG_PUB.ADD;

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;
1430: ELSE
1431: SELECT COUNT(1)
1432: INTO l_cnt_func_id

Line 1438: FND_MSG_PUB.ADD;

1434: WHERE SHORT_NAME = p_Form_Func_Extn_Rec.Func_Area_short_name;
1435: IF(l_cnt_func_id = 0 ) THEN
1436: FND_MESSAGE.SET_NAME('BIS','BIS_FUNCSHTNAME_WRONG');
1437: FND_MESSAGE.SET_TOKEN('FORM_FUNC',Trim(p_Form_Func_Extn_Rec.Func_Area_short_name));
1438: FND_MSG_PUB.ADD;
1439: RAISE FND_API.G_EXC_ERROR;
1440: END IF;
1441: END IF;
1442: END IF;

Line 1447: FND_MSG_PUB.ADD;

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;
1448: RAISE FND_API.G_EXC_ERROR;
1449: END IF;
1450: END IF;
1451:

Line 1455: FND_MSG_PUB.Count_And_Get

1451:
1452: EXCEPTION
1453: WHEN FND_API.G_EXC_ERROR THEN
1454: IF (x_msg_data IS NULL) THEN
1455: FND_MSG_PUB.Count_And_Get
1456: ( p_encoded => FND_API.G_FALSE
1457: , p_count => x_msg_count
1458: , p_data => x_msg_data
1459: );

Line 1464: FND_MSG_PUB.Count_And_Get

1460: END IF;
1461: x_return_status := FND_API.G_RET_STS_ERROR;
1462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1463: IF (x_msg_data IS NULL) THEN
1464: FND_MSG_PUB.Count_And_Get
1465: ( p_encoded => FND_API.G_FALSE
1466: , p_count => x_msg_count
1467: , p_data => x_msg_data
1468: );

Line 1564: FND_MSG_PUB.Initialize;

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:
1567: IF(p_Obj_Type=BIS_OBJECT_EXTENSIONS_PUB.C_MEASURE) THEN
1568: BIS_OBJECT_EXTENSIONS_PUB.Measure_Funct_Area_Map

Line 1603: FND_MSG_PUB.Count_And_Get

1599: END IF;
1600: EXCEPTION
1601: WHEN FND_API.G_EXC_ERROR THEN
1602: IF (x_msg_data IS NULL) THEN
1603: FND_MSG_PUB.Count_And_Get
1604: ( p_encoded => FND_API.G_FALSE
1605: , p_count => x_msg_count
1606: , p_data => x_msg_data
1607: );

Line 1612: FND_MSG_PUB.Count_And_Get

1608: END IF;
1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1611: IF (x_msg_data IS NULL) THEN
1612: FND_MSG_PUB.Count_And_Get
1613: ( p_encoded => FND_API.G_FALSE
1614: , p_count => x_msg_count
1615: , p_data => x_msg_data
1616: );

Line 1675: FND_MSG_PUB.Initialize;

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:
1678: l_count := Validate_Object_Mapping (p_object_type => p_Obj_Type ,p_object_name=>p_Obj_Name);
1679:

Line 1730: FND_MSG_PUB.ADD;

1726: END IF;
1727: ELSE
1728: IF(p_Func_Area_Sht_Name IS NULL) THEN
1729: FND_MESSAGE.SET_NAME('BIS','BIS_OBJ_EXT_DOES_NOT_EXIST');
1730: FND_MSG_PUB.ADD;
1731: RAISE FND_API.G_EXC_ERROR;
1732: ELSE
1733: l_Meas_Extn_Rec.Measure_Short_Name := p_Obj_Name;
1734: l_Meas_Extn_Rec.Functional_Area_Id := Get_FA_Id_By_Short_Name(p_Func_Area_Sht_Name);

Line 1764: FND_MSG_PUB.Count_And_Get

1760: END IF;
1761: EXCEPTION
1762: WHEN FND_API.G_EXC_ERROR THEN
1763: IF (x_msg_data IS NULL) THEN
1764: FND_MSG_PUB.Count_And_Get
1765: ( p_encoded => FND_API.G_FALSE
1766: , p_count => x_msg_count
1767: , p_data => x_msg_data
1768: );

Line 1773: FND_MSG_PUB.Count_And_Get

1769: END IF;
1770: x_return_status := FND_API.G_RET_STS_ERROR;
1771: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1772: IF (x_msg_data IS NULL) THEN
1773: FND_MSG_PUB.Count_And_Get
1774: ( p_encoded => FND_API.G_FALSE
1775: , p_count => x_msg_count
1776: , p_data => x_msg_data
1777: );

Line 1836: FND_MSG_PUB.Initialize;

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;
1838:
1839: l_count := Validate_Object_Mapping (p_object_type => p_Obj_Type ,p_object_name=>p_Obj_Name);
1840:

Line 1893: FND_MSG_PUB.ADD;

1889: END IF;
1890: ELSE
1891: IF(p_Func_Area_Sht_Name IS NULL) THEN
1892: FND_MESSAGE.SET_NAME('BIS','BIS_OBJ_EXT_DOES_NOT_EXIST');
1893: FND_MSG_PUB.ADD;
1894: RAISE FND_API.G_EXC_ERROR;
1895: ELSE
1896: l_From_Func_Extn_Rec.Object_Type := p_Obj_Type;
1897: l_From_Func_Extn_Rec.Object_Name := p_Obj_Name;

Line 1929: FND_MSG_PUB.Count_And_Get

1925: END IF;
1926: EXCEPTION
1927: WHEN FND_API.G_EXC_ERROR THEN
1928: IF (x_msg_data IS NULL) THEN
1929: FND_MSG_PUB.Count_And_Get
1930: ( p_encoded => FND_API.G_FALSE
1931: , p_count => x_msg_count
1932: , p_data => x_msg_data
1933: );

Line 1938: FND_MSG_PUB.Count_And_Get

1934: END IF;
1935: x_return_status := FND_API.G_RET_STS_ERROR;
1936: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1937: IF (x_msg_data IS NULL) THEN
1938: FND_MSG_PUB.Count_And_Get
1939: ( p_encoded => FND_API.G_FALSE
1940: , p_count => x_msg_count
1941: , p_data => x_msg_data
1942: );