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.FEM_DS_WHERE_CLAUSE_GENERATOR dependencies on FND_API

Line 1026: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1022: End Populate_WhereClause_List;
1023:
1024:
1025: PROCEDURE FEM_GetOutputDS_PVT(p_api_version IN NUMBER
1026: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1027: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
1028: ,x_return_status OUT NOCOPY VARCHAR2
1029: ,x_msg_count OUT NOCOPY NUMBER
1030: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1027: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE

1023:
1024:
1025: PROCEDURE FEM_GetOutputDS_PVT(p_api_version IN NUMBER
1026: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1027: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
1028: ,x_return_status OUT NOCOPY VARCHAR2
1029: ,x_msg_count OUT NOCOPY NUMBER
1030: ,x_msg_data OUT NOCOPY VARCHAR2
1031: ,p_DSGroup_Def_ID IN NUMBER

Line 1033: ,p_pop_messages_at_exit IN VARCHAR2 := FND_API.G_TRUE)

1029: ,x_msg_count OUT NOCOPY NUMBER
1030: ,x_msg_data OUT NOCOPY VARCHAR2
1031: ,p_DSGroup_Def_ID IN NUMBER
1032: ,x_Output_DS_ID OUT NOCOPY NUMBER
1033: ,p_pop_messages_at_exit IN VARCHAR2 := FND_API.G_TRUE)
1034: IS
1035: l_api_version NUMBER := 1.0;
1036: l_api_name CONSTANT VARCHAR2(30) := 'FEM_GetOutputDS_PVT';
1037: l_module_name VARCHAR2(70) := G_MODULE_NAME || l_api_name;

Line 1061: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1057: -- Parameters
1058: -- IN
1059: -- p_api_version IN NUMBER
1060: -- Current version of this API
1061: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1062: -- If set to
1063: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
1064: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1065: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE

Line 1063: -- FND_API.G_TRUE - Initialize FND_MSG_PUB

1059: -- p_api_version IN NUMBER
1060: -- Current version of this API
1061: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1062: -- If set to
1063: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
1064: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1065: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE
1066: -- If set to
1067: -- FND_API.G_TRUE - return error messages in encoded format

Line 1064: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB

1060: -- Current version of this API
1061: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1062: -- If set to
1063: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
1064: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1065: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE
1066: -- If set to
1067: -- FND_API.G_TRUE - return error messages in encoded format
1068: -- FND_API.G_FALSE - return error messages in non-encoded (natural language) format

Line 1065: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE

1061: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1062: -- If set to
1063: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
1064: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1065: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE
1066: -- If set to
1067: -- FND_API.G_TRUE - return error messages in encoded format
1068: -- FND_API.G_FALSE - return error messages in non-encoded (natural language) format
1069:

Line 1067: -- FND_API.G_TRUE - return error messages in encoded format

1063: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
1064: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1065: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE
1066: -- If set to
1067: -- FND_API.G_TRUE - return error messages in encoded format
1068: -- FND_API.G_FALSE - return error messages in non-encoded (natural language) format
1069:
1070: -- p_DSGroup_Def_ID IN NUMBER
1071: -- - dataset group's object_definition_id

Line 1068: -- FND_API.G_FALSE - return error messages in non-encoded (natural language) format

1064: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1065: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE
1066: -- If set to
1067: -- FND_API.G_TRUE - return error messages in encoded format
1068: -- FND_API.G_FALSE - return error messages in non-encoded (natural language) format
1069:
1070: -- p_DSGroup_Def_ID IN NUMBER
1071: -- - dataset group's object_definition_id
1072: -- x_Output_DS_ID OUT NOCOPY NUMBER

Line 1078: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may

1074: --
1075: -- OUT
1076: -- x_return_status OUT VARCHAR2
1077: -- Possible return status
1078: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
1079: -- still be present (check x_msg_count)
1080: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
1081: -- be present (check x_msg_count)
1082: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are

Line 1080: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should

1076: -- x_return_status OUT VARCHAR2
1077: -- Possible return status
1078: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
1079: -- still be present (check x_msg_count)
1080: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
1081: -- be present (check x_msg_count)
1082: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are
1083: -- unrecoverable (check x_msg_count)
1084: --

Line 1082: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are

1078: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
1079: -- still be present (check x_msg_count)
1080: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
1081: -- be present (check x_msg_count)
1082: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are
1083: -- unrecoverable (check x_msg_count)
1084: --
1085: -- x_msg_count OUT NUMBER
1086: -- Count of messages returned. If x_msg_count = 1, then the message is returned

Line 1104: x_return_status := FND_API.G_RET_STS_SUCCESS;

1100: p_msg_text=> 'ENTRY');
1101: reset_master_err_state;
1102:
1103: -- initialize our status to 'we are good!'
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:
1106: -- initialize msg stack?
1107: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1108: fnd_msg_pub.initialize;

Line 1107: IF fnd_api.to_Boolean(p_init_msg_list) THEN

1103: -- initialize our status to 'we are good!'
1104: x_return_status := FND_API.G_RET_STS_SUCCESS;
1105:
1106: -- initialize msg stack?
1107: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1108: fnd_msg_pub.initialize;
1109: END IF;
1110:
1111: -- check API version...

Line 1112: IF NOT fnd_api.Compatible_API_Call (l_api_version,

1108: fnd_msg_pub.initialize;
1109: END IF;
1110:
1111: -- check API version...
1112: IF NOT fnd_api.Compatible_API_Call (l_api_version,
1113: p_api_version,
1114: l_api_name,
1115: G_PKG_NAME ) THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1112: IF NOT fnd_api.Compatible_API_Call (l_api_version,
1113: p_api_version,
1114: l_api_name,
1115: G_PKG_NAME ) THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: END IF;
1118:
1119: OPEN GetOutputDS;
1120: FETCH GetOutputDS INTO

Line 1129: RAISE FND_API.G_EXC_ERROR;

1125: FEM_UTILS.G_RSM_FATAL_ERR,
1126: G_APP_NAME,
1127: G_ERRMSG_NO_ODS_FOR_DSG );
1128: -- this one and only error is utterly fatal if we get it (no output ds!!!)
1129: RAISE FND_API.G_EXC_ERROR;
1130: ELSE
1131: CLOSE GetOutputDS;
1132: END IF;
1133:

Line 1134: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN

1130: ELSE
1131: CLOSE GetOutputDS;
1132: END IF;
1133:
1134: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN
1135: FND_MSG_PUB.Count_And_Get ( p_encoded,
1136: x_msg_count,
1137: x_msg_data );
1138: END IF;

Line 1146: WHEN FND_API.G_EXC_ERROR THEN

1142: p_msg_text=> 'EXIT');
1143:
1144:
1145: EXCEPTION
1146: WHEN FND_API.G_EXC_ERROR THEN
1147: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN
1148: FND_MSG_PUB.Count_And_Get ( p_encoded,
1149: x_msg_count,
1150: x_msg_data );

Line 1147: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN

1143:
1144:
1145: EXCEPTION
1146: WHEN FND_API.G_EXC_ERROR THEN
1147: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN
1148: FND_MSG_PUB.Count_And_Get ( p_encoded,
1149: x_msg_count,
1150: x_msg_data );
1151: END IF;

Line 1152: x_return_status := FND_API.G_RET_STS_ERROR;

1148: FND_MSG_PUB.Count_And_Get ( p_encoded,
1149: x_msg_count,
1150: x_msg_data );
1151: END IF;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:
1154:
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN

Line 1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1151: END IF;
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:
1154:
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN
1157: FND_MSG_PUB.Count_And_Get ( p_encoded,
1158: x_msg_count,
1159: x_msg_data );

Line 1156: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN

1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153:
1154:
1155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1156: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN
1157: FND_MSG_PUB.Count_And_Get ( p_encoded,
1158: x_msg_count,
1159: x_msg_data );
1160: END IF;

Line 1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1158: x_msg_count,
1159: x_msg_data );
1160: END IF;
1161:
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163:
1164: WHEN OTHERS THEN
1165: FEM_UTILS.set_master_err_state( z_master_err_state,
1166: FEM_UTILS.G_RSM_FATAL_ERR,

Line 1175: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN

1171: NULL,
1172: G_ERRMAC_SQL_ERROR,
1173: SQLERRM);
1174:
1175: IF fnd_api.to_Boolean(p_pop_messages_at_exit) THEN
1176: FND_MSG_PUB.Count_And_Get ( p_encoded,
1177: x_msg_count,
1178: x_msg_data );
1179: END IF;

Line 1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1177: x_msg_count,
1178: x_msg_data );
1179: END IF;
1180:
1181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1182:
1183: END FEM_GetOutputDS_PVT;
1184:
1185:

Line 1200: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1196: -- Parameters
1197: -- IN
1198: -- p_api_version IN NUMBER
1199: -- Current version of this API
1200: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1201: -- If set to
1202: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
1203: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1204: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE

Line 1202: -- FND_API.G_TRUE - Initialize FND_MSG_PUB

1198: -- p_api_version IN NUMBER
1199: -- Current version of this API
1200: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1201: -- If set to
1202: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
1203: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1204: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE
1205: -- If set to
1206: -- FND_API.G_TRUE - return error messages in encoded format

Line 1203: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB

1199: -- Current version of this API
1200: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1201: -- If set to
1202: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
1203: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1204: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE
1205: -- If set to
1206: -- FND_API.G_TRUE - return error messages in encoded format
1207: -- FND_API.G_FALSE - return error messages in non-encoded (natural language) format

Line 1204: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE

1200: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1201: -- If set to
1202: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
1203: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1204: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE
1205: -- If set to
1206: -- FND_API.G_TRUE - return error messages in encoded format
1207: -- FND_API.G_FALSE - return error messages in non-encoded (natural language) format
1208:

Line 1206: -- FND_API.G_TRUE - return error messages in encoded format

1202: -- FND_API.G_TRUE - Initialize FND_MSG_PUB
1203: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1204: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE
1205: -- If set to
1206: -- FND_API.G_TRUE - return error messages in encoded format
1207: -- FND_API.G_FALSE - return error messages in non-encoded (natural language) format
1208:
1209: -- p_DS_IO_Def_ID IN NUMBER
1210: -- - dataset group's object_definition_id

Line 1207: -- FND_API.G_FALSE - return error messages in non-encoded (natural language) format

1203: -- FND_API.G_FALSE - DO NOT Initialize FND_MSG_PUB
1204: -- p_encoded IN VARCHAR2 := FND_API.G_TRUE
1205: -- If set to
1206: -- FND_API.G_TRUE - return error messages in encoded format
1207: -- FND_API.G_FALSE - return error messages in non-encoded (natural language) format
1208:
1209: -- p_DS_IO_Def_ID IN NUMBER
1210: -- - dataset group's object_definition_id
1211: -- p_Output_Period_ID OUT NUMBER

Line 1224: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may

1220: --
1221: -- OUT
1222: -- x_return_status OUT VARCHAR2
1223: -- Possible return status
1224: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
1225: -- still be present (check x_msg_count)
1226: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
1227: -- be present (check x_msg_count)
1228: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are

Line 1226: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should

1222: -- x_return_status OUT VARCHAR2
1223: -- Possible return status
1224: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
1225: -- still be present (check x_msg_count)
1226: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
1227: -- be present (check x_msg_count)
1228: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are
1229: -- unrecoverable (check x_msg_count)
1230: --

Line 1228: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are

1224: -- FND_API.G_RET_STS_SUCCESS - Call was successful, msgs may
1225: -- still be present (check x_msg_count)
1226: -- FND_API.G_RET_STS_ERROR - Call was not successful, msgs should
1227: -- be present (check x_msg_count)
1228: -- FND_API.G_RET_STS_UNEXP_ERROR - Unexpected errors occurred which are
1229: -- unrecoverable (check x_msg_count)
1230: --
1231: -- x_msg_count OUT NUMBER
1232: -- Count of messages returned. If x_msg_count = 1, then the message is returned

Line 1245: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1241: -- Initial version 1.0
1242: -- *******************************************************************************************
1243: PROCEDURE FEM_Gen_DS_WClause_PVT(
1244: p_api_version IN NUMBER
1245: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1246: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
1247: ,x_return_status OUT NOCOPY VARCHAR2
1248: ,x_msg_count OUT NOCOPY NUMBER
1249: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1246: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE

1242: -- *******************************************************************************************
1243: PROCEDURE FEM_Gen_DS_WClause_PVT(
1244: p_api_version IN NUMBER
1245: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1246: ,p_encoded IN VARCHAR2 := FND_API.G_TRUE
1247: ,x_return_status OUT NOCOPY VARCHAR2
1248: ,x_msg_count OUT NOCOPY NUMBER
1249: ,x_msg_data OUT NOCOPY VARCHAR2
1250: ,p_DS_IO_Def_ID IN NUMBER

Line 1281: x_return_status := FND_API.G_RET_STS_SUCCESS;

1277: p_msg_text=> 'ENTRY');
1278: reset_master_err_state;
1279:
1280: -- initialize our status to 'we are good!'
1281: x_return_status := FND_API.G_RET_STS_SUCCESS;
1282:
1283: -- initialize msg stack?
1284: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1285: fnd_msg_pub.initialize;

Line 1284: IF fnd_api.to_Boolean(p_init_msg_list) THEN

1280: -- initialize our status to 'we are good!'
1281: x_return_status := FND_API.G_RET_STS_SUCCESS;
1282:
1283: -- initialize msg stack?
1284: IF fnd_api.to_Boolean(p_init_msg_list) THEN
1285: fnd_msg_pub.initialize;
1286: END IF;
1287:
1288: -- check API version...

Line 1289: IF NOT fnd_api.Compatible_API_Call (l_api_version,

1285: fnd_msg_pub.initialize;
1286: END IF;
1287:
1288: -- check API version...
1289: IF NOT fnd_api.Compatible_API_Call (l_api_version,
1290: p_api_version,
1291: l_api_name,
1292: G_PKG_NAME ) THEN
1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1289: IF NOT fnd_api.Compatible_API_Call (l_api_version,
1290: p_api_version,
1291: l_api_name,
1292: G_PKG_NAME ) THEN
1293: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1294: END IF;
1295:
1296: -- ===============================================================
1297: -- =========imported from first version call======================

Line 1309: ,p_init_msg_list => FND_API.G_FALSE

1305: z_Dup_Entries_Ctr := 0;
1306: /*-----------------------------------------------*/
1307:
1308: FEM_GetOutputDS_PVT( p_api_version => 1.0
1309: ,p_init_msg_list => FND_API.G_FALSE
1310: ,p_encoded => p_encoded
1311: ,x_return_status => l_return_status
1312: ,x_msg_count => l_msg_count
1313: ,x_msg_data => l_msg_data

Line 1316: ,p_pop_messages_at_exit => FND_API.G_FALSE );

1312: ,x_msg_count => l_msg_count
1313: ,x_msg_data => l_msg_data
1314: ,p_DSGroup_Def_ID => p_DS_IO_Def_ID
1315: ,x_Output_DS_ID => l_output_ds_code
1316: ,p_pop_messages_at_exit => FND_API.G_FALSE );
1317:
1318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;

Line 1318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1314: ,p_DSGroup_Def_ID => p_DS_IO_Def_ID
1315: ,x_Output_DS_ID => l_output_ds_code
1316: ,p_pop_messages_at_exit => FND_API.G_FALSE );
1317:
1318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321:
1322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1319: RAISE FND_API.G_EXC_ERROR;

1315: ,x_Output_DS_ID => l_output_ds_code
1316: ,p_pop_messages_at_exit => FND_API.G_FALSE );
1317:
1318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321:
1322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1318: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321:
1322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324: END IF;
1325:
1326: If (p_Ledger_Id is NULL) then

Line 1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321:
1322: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1324: END IF;
1325:
1326: If (p_Ledger_Id is NULL) then
1327: FEM_UTILS.set_master_err_state( z_master_err_state,

Line 1390: RAISE FND_API.G_EXC_ERROR;

1386: p_msg_text=> 'EXIT');
1387:
1388:
1389: IF (z_master_err_state = FEM_UTILS.G_RSM_FATAL_ERR) THEN
1390: RAISE FND_API.G_EXC_ERROR;
1391: END IF;
1392:
1393: FND_MSG_PUB.Count_And_Get ( p_encoded,
1394: x_msg_count,

Line 1397: WHEN FND_API.G_EXC_ERROR THEN

1393: FND_MSG_PUB.Count_And_Get ( p_encoded,
1394: x_msg_count,
1395: x_msg_data );
1396: EXCEPTION
1397: WHEN FND_API.G_EXC_ERROR THEN
1398: FND_MSG_PUB.Count_And_Get ( p_encoded,
1399: x_msg_count,
1400: x_msg_data );
1401: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1401: x_return_status := FND_API.G_RET_STS_ERROR;

1397: WHEN FND_API.G_EXC_ERROR THEN
1398: FND_MSG_PUB.Count_And_Get ( p_encoded,
1399: x_msg_count,
1400: x_msg_data );
1401: x_return_status := FND_API.G_RET_STS_ERROR;
1402:
1403:
1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1405: FND_MSG_PUB.Count_And_Get ( p_encoded,

Line 1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1400: x_msg_data );
1401: x_return_status := FND_API.G_RET_STS_ERROR;
1402:
1403:
1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1405: FND_MSG_PUB.Count_And_Get ( p_encoded,
1406: x_msg_count,
1407: x_msg_data );
1408:

Line 1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1405: FND_MSG_PUB.Count_And_Get ( p_encoded,
1406: x_msg_count,
1407: x_msg_data );
1408:
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1410:
1411: WHEN OTHERS THEN
1412: FEM_UTILS.set_master_err_state( z_master_err_state,
1413: FEM_UTILS.G_RSM_FATAL_ERR,

Line 1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1422: FND_MSG_PUB.Count_And_Get ( p_encoded,
1423: x_msg_count,
1424: x_msg_data );
1425:
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427:
1428:
1429: END FEM_Gen_DS_WClause_PVT;
1430: