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.OZF_OBJFUNDSUM_PVT dependencies on FND_MSG_PUB

Line 16: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

12: -- 9/1/2010 nepanda Bug 10077018 - BACKPORT:8675200:MC:RMA ORDERS ARE NOT UPDATED CORRECTLY IN THE CHECKBOOK
13:
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_OBJFUNDSUM_PVT';
15:
16: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
17: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
18: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
19:
20: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');

Line 17: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

13:
14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_OBJFUNDSUM_PVT';
15:
16: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
17: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
18: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
19:
20: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
21:

Line 18: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

14: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_OBJFUNDSUM_PVT';
15:
16: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
17: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
18: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
19:
20: g_universal_currency CONSTANT VARCHAR2 (15) := fnd_profile.VALUE ('OZF_UNIV_CURR_CODE');
21:
22:

Line 206: Fnd_Msg_Pub.Initialize;

202: ozf_utility_pvt.Debug_Message(l_full_name||': start');
203: END IF;
204:
205: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
206: Fnd_Msg_Pub.Initialize;
207: END IF;
208:
209: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION, p_api_version, L_API_NAME, G_PKG_NAME) THEN
210: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 529: Fnd_Msg_Pub.Count_And_Get (

525: );
526:
527: x_objfundsum_id := l_objfundsum_rec.objfundsum_id;
528:
529: Fnd_Msg_Pub.Count_And_Get (
530: p_count => x_msg_count,
531: p_data => x_msg_data,
532: p_encoded => Fnd_Api.G_FALSE
533: );

Line 543: Fnd_Msg_Pub.Count_And_Get (

539: EXCEPTION
540: WHEN Fnd_Api.G_EXC_ERROR THEN
541: ROLLBACK TO sp_create_objfundsum;
542: x_return_status := Fnd_Api.G_RET_STS_ERROR;
543: Fnd_Msg_Pub.Count_And_Get (
544: p_count => x_msg_count,
545: p_data => x_msg_data,
546: p_encoded => FND_API.G_FALSE
547: );

Line 551: Fnd_Msg_Pub.Count_And_Get (

547: );
548: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO sp_create_objfundsum;
550: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
551: Fnd_Msg_Pub.Count_And_Get (
552: p_count => x_msg_count,
553: p_data => x_msg_data,
554: p_encoded => FND_API.G_FALSE
555: );

Line 559: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

555: );
556: WHEN OTHERS THEN
557: ROLLBACK TO sp_create_objfundsum;
558: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
559: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
560: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
561: END IF;
562: Fnd_Msg_Pub.Count_And_Get (
563: p_count => x_msg_count,

Line 560: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

556: WHEN OTHERS THEN
557: ROLLBACK TO sp_create_objfundsum;
558: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
559: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
560: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
561: END IF;
562: Fnd_Msg_Pub.Count_And_Get (
563: p_count => x_msg_count,
564: p_data => x_msg_data,

Line 562: Fnd_Msg_Pub.Count_And_Get (

558: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
559: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
560: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
561: END IF;
562: Fnd_Msg_Pub.Count_And_Get (
563: p_count => x_msg_count,
564: p_data => x_msg_data,
565: p_encoded => FND_API.G_FALSE
566: );

Line 614: Fnd_Msg_Pub.Initialize;

610: ozf_utility_pvt.debug_message(l_full_name||': start');
611: END IF;
612:
613: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
614: Fnd_Msg_Pub.Initialize;
615: END IF;
616:
617: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
618: p_api_version,

Line 869: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

865: WHERE objfundsum_id = l_objfundsum_rec.objfundsum_id
866: AND object_version_number = l_objfundsum_rec.object_version_number;
867:
868: IF (SQL%NOTFOUND) THEN
869: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
870: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
871: Fnd_Msg_Pub.ADD;
872: END IF;
873: RAISE Fnd_Api.g_exc_error;

Line 871: Fnd_Msg_Pub.ADD;

867:
868: IF (SQL%NOTFOUND) THEN
869: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
870: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
871: Fnd_Msg_Pub.ADD;
872: END IF;
873: RAISE Fnd_Api.g_exc_error;
874: END IF;
875:

Line 876: Fnd_Msg_Pub.Count_And_Get (

872: END IF;
873: RAISE Fnd_Api.g_exc_error;
874: END IF;
875:
876: Fnd_Msg_Pub.Count_And_Get (
877: p_count => x_msg_count,
878: p_data => x_msg_data,
879: p_encoded => Fnd_Api.G_FALSE
880: );

Line 891: Fnd_Msg_Pub.Count_And_Get (

887: EXCEPTION
888: WHEN Fnd_Api.G_EXC_ERROR THEN
889: ROLLBACK TO SP_Update_objfundsum;
890: x_return_status := Fnd_Api.G_RET_STS_ERROR;
891: Fnd_Msg_Pub.Count_And_Get (
892: p_count => x_msg_count,
893: p_data => x_msg_data,
894: p_encoded => FND_API.G_FALSE
895: );

Line 899: Fnd_Msg_Pub.Count_And_Get (

895: );
896: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
897: ROLLBACK TO SP_Update_objfundsum;
898: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
899: Fnd_Msg_Pub.Count_And_Get (
900: p_count => x_msg_count,
901: p_data => x_msg_data,
902: p_encoded => FND_API.G_FALSE
903: );

Line 907: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

903: );
904: WHEN OTHERS THEN
905: ROLLBACK TO SP_Update_objfundsum;
906: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
907: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
908: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
909: END IF;
910: Fnd_Msg_Pub.Count_And_Get (
911: p_count => x_msg_count,

Line 908: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

904: WHEN OTHERS THEN
905: ROLLBACK TO SP_Update_objfundsum;
906: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
907: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
908: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
909: END IF;
910: Fnd_Msg_Pub.Count_And_Get (
911: p_count => x_msg_count,
912: p_data => x_msg_data,

Line 910: Fnd_Msg_Pub.Count_And_Get (

906: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
907: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
908: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
909: END IF;
910: Fnd_Msg_Pub.Count_And_Get (
911: p_count => x_msg_count,
912: p_data => x_msg_data,
913: p_encoded => FND_API.G_FALSE
914: );

Line 1115: Fnd_Msg_Pub.Count_And_Get (

1111: EXCEPTION
1112: WHEN Fnd_Api.G_EXC_ERROR THEN
1113: ROLLBACK TO SP_process_objfundsum;
1114: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1115: Fnd_Msg_Pub.Count_And_Get (
1116: p_count => x_msg_count,
1117: p_data => x_msg_data,
1118: p_encoded => FND_API.G_FALSE
1119: );

Line 1123: Fnd_Msg_Pub.Count_And_Get (

1119: );
1120: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1121: ROLLBACK TO SP_process_objfundsum;
1122: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1123: Fnd_Msg_Pub.Count_And_Get (
1124: p_count => x_msg_count,
1125: p_data => x_msg_data,
1126: p_encoded => FND_API.G_FALSE
1127: );

Line 1131: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

1127: );
1128: WHEN OTHERS THEN
1129: ROLLBACK TO SP_process_objfundsum;
1130: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1131: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1132: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1133: END IF;
1134: Fnd_Msg_Pub.Count_And_Get (
1135: p_count => x_msg_count,

Line 1132: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

1128: WHEN OTHERS THEN
1129: ROLLBACK TO SP_process_objfundsum;
1130: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1131: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1132: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1133: END IF;
1134: Fnd_Msg_Pub.Count_And_Get (
1135: p_count => x_msg_count,
1136: p_data => x_msg_data,

Line 1134: Fnd_Msg_Pub.Count_And_Get (

1130: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1131: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1132: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1133: END IF;
1134: Fnd_Msg_Pub.Count_And_Get (
1135: p_count => x_msg_count,
1136: p_data => x_msg_data,
1137: p_encoded => FND_API.G_FALSE
1138: );

Line 1178: Fnd_Msg_Pub.Initialize;

1174: ozf_utility_pvt.debug_message(l_full_name||': start');
1175: END IF;
1176:
1177: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
1178: Fnd_Msg_Pub.Initialize;
1179: END IF;
1180:
1181: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
1182: p_api_version,

Line 1200: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1196: -- fund_id is required
1197: IF p_objfundsum_rec.fund_id IS NULL OR
1198: p_objfundsum_rec.fund_id = fnd_api.g_miss_num
1199: THEN
1200: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1201: THEN
1202: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_ID');
1203: Fnd_Msg_Pub.ADD;
1204: END IF;

Line 1203: Fnd_Msg_Pub.ADD;

1199: THEN
1200: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1201: THEN
1202: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_ID');
1203: Fnd_Msg_Pub.ADD;
1204: END IF;
1205: RAISE Fnd_Api.G_EXC_ERROR;
1206: END IF;
1207:

Line 1212: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1208: -- fund_currency is required
1209: IF p_objfundsum_rec.fund_currency IS NULL OR
1210: p_objfundsum_rec.fund_currency = fnd_api.g_miss_char
1211: THEN
1212: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1213: THEN
1214: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_CURRENCY');
1215: Fnd_Msg_Pub.ADD;
1216: END IF;

Line 1215: Fnd_Msg_Pub.ADD;

1211: THEN
1212: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1213: THEN
1214: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_CURRENCY');
1215: Fnd_Msg_Pub.ADD;
1216: END IF;
1217: RAISE Fnd_Api.G_EXC_ERROR;
1218: END IF;
1219:

Line 1224: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1220: -- object_type is required
1221: IF p_objfundsum_rec.object_type IS NULL OR
1222: p_objfundsum_rec.object_type = fnd_api.g_miss_char
1223: THEN
1224: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1225: THEN
1226: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_TYPE');
1227: Fnd_Msg_Pub.ADD;
1228: END IF;

Line 1227: Fnd_Msg_Pub.ADD;

1223: THEN
1224: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1225: THEN
1226: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_TYPE');
1227: Fnd_Msg_Pub.ADD;
1228: END IF;
1229: RAISE Fnd_Api.G_EXC_ERROR;
1230: END IF;
1231:

Line 1236: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1232: -- object_id is required
1233: IF p_objfundsum_rec.object_id IS NULL OR
1234: p_objfundsum_rec.object_id = fnd_api.g_miss_num
1235: THEN
1236: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1237: THEN
1238: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_ID');
1239: Fnd_Msg_Pub.ADD;
1240: END IF;

Line 1239: Fnd_Msg_Pub.ADD;

1235: THEN
1236: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1237: THEN
1238: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_ID');
1239: Fnd_Msg_Pub.ADD;
1240: END IF;
1241: RAISE Fnd_Api.G_EXC_ERROR;
1242: END IF;
1243:

Line 1248: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)

1244: -- object_currency is required
1245: IF p_objfundsum_rec.object_currency IS NULL OR
1246: p_objfundsum_rec.object_currency = fnd_api.g_miss_char
1247: THEN
1248: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1249: THEN
1250: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_CURRENCY');
1251: Fnd_Msg_Pub.ADD;
1252: END IF;

Line 1251: Fnd_Msg_Pub.ADD;

1247: THEN
1248: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1249: THEN
1250: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_CURRENCY');
1251: Fnd_Msg_Pub.ADD;
1252: END IF;
1253: RAISE Fnd_Api.G_EXC_ERROR;
1254: END IF;
1255:

Line 1261: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1257: IF ozf_utility_pvt.check_lookup_exists (
1258: p_lookup_type=> 'OZF_FUND_SOURCE'
1259: ,p_lookup_code=> p_objfundsum_rec.object_type
1260: ) = fnd_api.g_false THEN
1261: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1262: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJTYPE');
1263: fnd_msg_pub.ADD;
1264: END IF;
1265: RAISE Fnd_Api.G_EXC_ERROR;

Line 1263: fnd_msg_pub.ADD;

1259: ,p_lookup_code=> p_objfundsum_rec.object_type
1260: ) = fnd_api.g_false THEN
1261: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1262: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJTYPE');
1263: fnd_msg_pub.ADD;
1264: END IF;
1265: RAISE Fnd_Api.G_EXC_ERROR;
1266: END IF;
1267:

Line 1274: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1270: p_table_name=> 'OZF_FUNDS_ALL_B'
1271: ,p_pk_name=> 'FUND_ID'
1272: ,p_pk_value=> p_objfundsum_rec.fund_id
1273: ) = fnd_api.g_false THEN
1274: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1275: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_FUNDID');
1276: fnd_msg_pub.ADD;
1277: END IF;
1278: RAISE Fnd_Api.G_EXC_ERROR;

Line 1276: fnd_msg_pub.ADD;

1272: ,p_pk_value=> p_objfundsum_rec.fund_id
1273: ) = fnd_api.g_false THEN
1274: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1275: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_FUNDID');
1276: fnd_msg_pub.ADD;
1277: END IF;
1278: RAISE Fnd_Api.G_EXC_ERROR;
1279: END IF;
1280:

Line 1308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1304: p_table_name=> l_table_name
1305: ,p_pk_name=> l_pk_name
1306: ,p_pk_value=> l_pk_value
1307: ) = fnd_api.g_false THEN
1308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1309: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJID');
1310: fnd_msg_pub.ADD;
1311: END IF;
1312: RAISE Fnd_Api.G_EXC_ERROR;

Line 1310: fnd_msg_pub.ADD;

1306: ,p_pk_value=> l_pk_value
1307: ) = fnd_api.g_false THEN
1308: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1309: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJID');
1310: fnd_msg_pub.ADD;
1311: END IF;
1312: RAISE Fnd_Api.G_EXC_ERROR;
1313: END IF;
1314:

Line 1319: Fnd_Msg_Pub.Count_And_Get (

1315: END IF;
1316:
1317: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1318:
1319: Fnd_Msg_Pub.Count_And_Get (
1320: p_count => x_msg_count,
1321: p_data => x_msg_data,
1322: p_encoded => Fnd_Api.G_FALSE
1323: );

Line 1332: Fnd_Msg_Pub.Count_And_Get (

1328:
1329: EXCEPTION
1330: WHEN Fnd_Api.G_EXC_ERROR THEN
1331: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1332: Fnd_Msg_Pub.Count_And_Get (
1333: p_count => x_msg_count,
1334: p_data => x_msg_data,
1335: p_encoded => FND_API.G_FALSE
1336: );

Line 1339: Fnd_Msg_Pub.Count_And_Get (

1335: p_encoded => FND_API.G_FALSE
1336: );
1337: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1338: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1339: Fnd_Msg_Pub.Count_And_Get (
1340: p_count => x_msg_count,
1341: p_data => x_msg_data,
1342: p_encoded => FND_API.G_FALSE
1343: );

Line 1346: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN

1342: p_encoded => FND_API.G_FALSE
1343: );
1344: WHEN OTHERS THEN
1345: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1346: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1347: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1348: END IF;
1349: Fnd_Msg_Pub.Count_And_Get (
1350: p_count => x_msg_count,

Line 1347: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

1343: );
1344: WHEN OTHERS THEN
1345: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1346: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1347: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1348: END IF;
1349: Fnd_Msg_Pub.Count_And_Get (
1350: p_count => x_msg_count,
1351: p_data => x_msg_data,

Line 1349: Fnd_Msg_Pub.Count_And_Get (

1345: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1346: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1347: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1348: END IF;
1349: Fnd_Msg_Pub.Count_And_Get (
1350: p_count => x_msg_count,
1351: p_data => x_msg_data,
1352: p_encoded => FND_API.G_FALSE
1353: );

Line 1389: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

1385: OPEN c_objfundsum;
1386: FETCH c_objfundsum INTO l_objfundsum_rec;
1387: IF c_objfundsum%NOTFOUND THEN
1388: CLOSE c_objfundsum;
1389: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1390: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1391: Fnd_Msg_Pub.ADD;
1392: END IF;
1393: RAISE Fnd_Api.g_exc_error;

Line 1391: Fnd_Msg_Pub.ADD;

1387: IF c_objfundsum%NOTFOUND THEN
1388: CLOSE c_objfundsum;
1389: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1390: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1391: Fnd_Msg_Pub.ADD;
1392: END IF;
1393: RAISE Fnd_Api.g_exc_error;
1394: END IF;
1395: CLOSE c_objfundsum;