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 15: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

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

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

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

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

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

Line 200: Fnd_Msg_Pub.Initialize;

196: ozf_utility_pvt.Debug_Message(l_full_name||': start');
197: END IF;
198:
199: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
200: Fnd_Msg_Pub.Initialize;
201: END IF;
202:
203: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION, p_api_version, L_API_NAME, G_PKG_NAME) THEN
204: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

Line 517: Fnd_Msg_Pub.Count_And_Get (

513: );
514:
515: x_objfundsum_id := l_objfundsum_rec.objfundsum_id;
516:
517: Fnd_Msg_Pub.Count_And_Get (
518: p_count => x_msg_count,
519: p_data => x_msg_data,
520: p_encoded => Fnd_Api.G_FALSE
521: );

Line 531: Fnd_Msg_Pub.Count_And_Get (

527: EXCEPTION
528: WHEN Fnd_Api.G_EXC_ERROR THEN
529: ROLLBACK TO sp_create_objfundsum;
530: x_return_status := Fnd_Api.G_RET_STS_ERROR;
531: Fnd_Msg_Pub.Count_And_Get (
532: p_count => x_msg_count,
533: p_data => x_msg_data,
534: p_encoded => FND_API.G_FALSE
535: );

Line 539: Fnd_Msg_Pub.Count_And_Get (

535: );
536: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
537: ROLLBACK TO sp_create_objfundsum;
538: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
539: Fnd_Msg_Pub.Count_And_Get (
540: p_count => x_msg_count,
541: p_data => x_msg_data,
542: p_encoded => FND_API.G_FALSE
543: );

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

543: );
544: WHEN OTHERS THEN
545: ROLLBACK TO sp_create_objfundsum;
546: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
547: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
548: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
549: END IF;
550: Fnd_Msg_Pub.Count_And_Get (
551: p_count => x_msg_count,

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

544: WHEN OTHERS THEN
545: ROLLBACK TO sp_create_objfundsum;
546: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
547: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
548: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
549: END IF;
550: Fnd_Msg_Pub.Count_And_Get (
551: p_count => x_msg_count,
552: p_data => x_msg_data,

Line 550: Fnd_Msg_Pub.Count_And_Get (

546: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
547: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
548: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
549: END IF;
550: Fnd_Msg_Pub.Count_And_Get (
551: p_count => x_msg_count,
552: p_data => x_msg_data,
553: p_encoded => FND_API.G_FALSE
554: );

Line 601: Fnd_Msg_Pub.Initialize;

597: ozf_utility_pvt.debug_message(l_full_name||': start');
598: END IF;
599:
600: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
601: Fnd_Msg_Pub.Initialize;
602: END IF;
603:
604: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
605: p_api_version,

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

828: WHERE objfundsum_id = l_objfundsum_rec.objfundsum_id
829: AND object_version_number = l_objfundsum_rec.object_version_number;
830:
831: IF (SQL%NOTFOUND) THEN
832: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
833: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
834: Fnd_Msg_Pub.ADD;
835: END IF;
836: RAISE Fnd_Api.g_exc_error;

Line 834: Fnd_Msg_Pub.ADD;

830:
831: IF (SQL%NOTFOUND) THEN
832: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
833: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
834: Fnd_Msg_Pub.ADD;
835: END IF;
836: RAISE Fnd_Api.g_exc_error;
837: END IF;
838:

Line 839: Fnd_Msg_Pub.Count_And_Get (

835: END IF;
836: RAISE Fnd_Api.g_exc_error;
837: END IF;
838:
839: Fnd_Msg_Pub.Count_And_Get (
840: p_count => x_msg_count,
841: p_data => x_msg_data,
842: p_encoded => Fnd_Api.G_FALSE
843: );

Line 854: Fnd_Msg_Pub.Count_And_Get (

850: EXCEPTION
851: WHEN Fnd_Api.G_EXC_ERROR THEN
852: ROLLBACK TO SP_Update_objfundsum;
853: x_return_status := Fnd_Api.G_RET_STS_ERROR;
854: Fnd_Msg_Pub.Count_And_Get (
855: p_count => x_msg_count,
856: p_data => x_msg_data,
857: p_encoded => FND_API.G_FALSE
858: );

Line 862: Fnd_Msg_Pub.Count_And_Get (

858: );
859: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
860: ROLLBACK TO SP_Update_objfundsum;
861: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
862: Fnd_Msg_Pub.Count_And_Get (
863: p_count => x_msg_count,
864: p_data => x_msg_data,
865: p_encoded => FND_API.G_FALSE
866: );

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

866: );
867: WHEN OTHERS THEN
868: ROLLBACK TO SP_Update_objfundsum;
869: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
870: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
871: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
872: END IF;
873: Fnd_Msg_Pub.Count_And_Get (
874: p_count => x_msg_count,

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

867: WHEN OTHERS THEN
868: ROLLBACK TO SP_Update_objfundsum;
869: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
870: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
871: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
872: END IF;
873: Fnd_Msg_Pub.Count_And_Get (
874: p_count => x_msg_count,
875: p_data => x_msg_data,

Line 873: Fnd_Msg_Pub.Count_And_Get (

869: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
870: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
871: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
872: END IF;
873: Fnd_Msg_Pub.Count_And_Get (
874: p_count => x_msg_count,
875: p_data => x_msg_data,
876: p_encoded => FND_API.G_FALSE
877: );

Line 1078: Fnd_Msg_Pub.Count_And_Get (

1074: EXCEPTION
1075: WHEN Fnd_Api.G_EXC_ERROR THEN
1076: ROLLBACK TO SP_process_objfundsum;
1077: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1078: Fnd_Msg_Pub.Count_And_Get (
1079: p_count => x_msg_count,
1080: p_data => x_msg_data,
1081: p_encoded => FND_API.G_FALSE
1082: );

Line 1086: Fnd_Msg_Pub.Count_And_Get (

1082: );
1083: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1084: ROLLBACK TO SP_process_objfundsum;
1085: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1086: Fnd_Msg_Pub.Count_And_Get (
1087: p_count => x_msg_count,
1088: p_data => x_msg_data,
1089: p_encoded => FND_API.G_FALSE
1090: );

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

1090: );
1091: WHEN OTHERS THEN
1092: ROLLBACK TO SP_process_objfundsum;
1093: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1094: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1095: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1096: END IF;
1097: Fnd_Msg_Pub.Count_And_Get (
1098: p_count => x_msg_count,

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

1091: WHEN OTHERS THEN
1092: ROLLBACK TO SP_process_objfundsum;
1093: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1094: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1095: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1096: END IF;
1097: Fnd_Msg_Pub.Count_And_Get (
1098: p_count => x_msg_count,
1099: p_data => x_msg_data,

Line 1097: Fnd_Msg_Pub.Count_And_Get (

1093: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1094: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1095: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1096: END IF;
1097: Fnd_Msg_Pub.Count_And_Get (
1098: p_count => x_msg_count,
1099: p_data => x_msg_data,
1100: p_encoded => FND_API.G_FALSE
1101: );

Line 1141: Fnd_Msg_Pub.Initialize;

1137: ozf_utility_pvt.debug_message(l_full_name||': start');
1138: END IF;
1139:
1140: IF Fnd_Api.To_Boolean (p_init_msg_list) THEN
1141: Fnd_Msg_Pub.Initialize;
1142: END IF;
1143:
1144: IF NOT Fnd_Api.Compatible_API_Call (L_API_VERSION,
1145: p_api_version,

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

1159: -- fund_id is required
1160: IF p_objfundsum_rec.fund_id IS NULL OR
1161: p_objfundsum_rec.fund_id = fnd_api.g_miss_num
1162: THEN
1163: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1164: THEN
1165: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_ID');
1166: Fnd_Msg_Pub.ADD;
1167: END IF;

Line 1166: Fnd_Msg_Pub.ADD;

1162: THEN
1163: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1164: THEN
1165: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_ID');
1166: Fnd_Msg_Pub.ADD;
1167: END IF;
1168: RAISE Fnd_Api.G_EXC_ERROR;
1169: END IF;
1170:

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

1171: -- fund_currency is required
1172: IF p_objfundsum_rec.fund_currency IS NULL OR
1173: p_objfundsum_rec.fund_currency = fnd_api.g_miss_char
1174: THEN
1175: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1176: THEN
1177: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_CURRENCY');
1178: Fnd_Msg_Pub.ADD;
1179: END IF;

Line 1178: Fnd_Msg_Pub.ADD;

1174: THEN
1175: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1176: THEN
1177: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_FUND_CURRENCY');
1178: Fnd_Msg_Pub.ADD;
1179: END IF;
1180: RAISE Fnd_Api.G_EXC_ERROR;
1181: END IF;
1182:

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

1183: -- object_type is required
1184: IF p_objfundsum_rec.object_type IS NULL OR
1185: p_objfundsum_rec.object_type = fnd_api.g_miss_char
1186: THEN
1187: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1188: THEN
1189: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_TYPE');
1190: Fnd_Msg_Pub.ADD;
1191: END IF;

Line 1190: Fnd_Msg_Pub.ADD;

1186: THEN
1187: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_ERROR)
1188: THEN
1189: Fnd_Message.Set_Name('OZF', 'OZF_OBJFUNDSUM_MISSING_OBJECT_TYPE');
1190: Fnd_Msg_Pub.ADD;
1191: END IF;
1192: RAISE Fnd_Api.G_EXC_ERROR;
1193: END IF;
1194:

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

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

Line 1202: Fnd_Msg_Pub.ADD;

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

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

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

Line 1214: Fnd_Msg_Pub.ADD;

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

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

1220: IF ozf_utility_pvt.check_lookup_exists (
1221: p_lookup_type=> 'OZF_FUND_SOURCE'
1222: ,p_lookup_code=> p_objfundsum_rec.object_type
1223: ) = fnd_api.g_false THEN
1224: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1225: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJTYPE');
1226: fnd_msg_pub.ADD;
1227: END IF;
1228: RAISE Fnd_Api.G_EXC_ERROR;

Line 1226: fnd_msg_pub.ADD;

1222: ,p_lookup_code=> p_objfundsum_rec.object_type
1223: ) = fnd_api.g_false THEN
1224: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1225: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJTYPE');
1226: fnd_msg_pub.ADD;
1227: END IF;
1228: RAISE Fnd_Api.G_EXC_ERROR;
1229: END IF;
1230:

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

1233: p_table_name=> 'OZF_FUNDS_ALL_B'
1234: ,p_pk_name=> 'FUND_ID'
1235: ,p_pk_value=> p_objfundsum_rec.fund_id
1236: ) = fnd_api.g_false THEN
1237: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1238: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_FUNDID');
1239: fnd_msg_pub.ADD;
1240: END IF;
1241: RAISE Fnd_Api.G_EXC_ERROR;

Line 1239: fnd_msg_pub.ADD;

1235: ,p_pk_value=> p_objfundsum_rec.fund_id
1236: ) = fnd_api.g_false THEN
1237: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1238: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_FUNDID');
1239: fnd_msg_pub.ADD;
1240: END IF;
1241: RAISE Fnd_Api.G_EXC_ERROR;
1242: END IF;
1243:

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

1267: p_table_name=> l_table_name
1268: ,p_pk_name=> l_pk_name
1269: ,p_pk_value=> l_pk_value
1270: ) = fnd_api.g_false THEN
1271: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1272: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJID');
1273: fnd_msg_pub.ADD;
1274: END IF;
1275: RAISE Fnd_Api.G_EXC_ERROR;

Line 1273: fnd_msg_pub.ADD;

1269: ,p_pk_value=> l_pk_value
1270: ) = fnd_api.g_false THEN
1271: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1272: fnd_message.set_name ('OZF', 'OZF_OBJFUNDSUM_BAD_OBJID');
1273: fnd_msg_pub.ADD;
1274: END IF;
1275: RAISE Fnd_Api.G_EXC_ERROR;
1276: END IF;
1277:

Line 1282: Fnd_Msg_Pub.Count_And_Get (

1278: END IF;
1279:
1280: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1281:
1282: Fnd_Msg_Pub.Count_And_Get (
1283: p_count => x_msg_count,
1284: p_data => x_msg_data,
1285: p_encoded => Fnd_Api.G_FALSE
1286: );

Line 1295: Fnd_Msg_Pub.Count_And_Get (

1291:
1292: EXCEPTION
1293: WHEN Fnd_Api.G_EXC_ERROR THEN
1294: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1295: Fnd_Msg_Pub.Count_And_Get (
1296: p_count => x_msg_count,
1297: p_data => x_msg_data,
1298: p_encoded => FND_API.G_FALSE
1299: );

Line 1302: Fnd_Msg_Pub.Count_And_Get (

1298: p_encoded => FND_API.G_FALSE
1299: );
1300: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1301: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1302: Fnd_Msg_Pub.Count_And_Get (
1303: p_count => x_msg_count,
1304: p_data => x_msg_data,
1305: p_encoded => FND_API.G_FALSE
1306: );

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

1305: p_encoded => FND_API.G_FALSE
1306: );
1307: WHEN OTHERS THEN
1308: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1309: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1310: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1311: END IF;
1312: Fnd_Msg_Pub.Count_And_Get (
1313: p_count => x_msg_count,

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

1306: );
1307: WHEN OTHERS THEN
1308: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1309: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1310: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1311: END IF;
1312: Fnd_Msg_Pub.Count_And_Get (
1313: p_count => x_msg_count,
1314: p_data => x_msg_data,

Line 1312: Fnd_Msg_Pub.Count_And_Get (

1308: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1309: IF Fnd_Msg_Pub.Check_Msg_Level (Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR) THEN
1310: Fnd_Msg_Pub.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1311: END IF;
1312: Fnd_Msg_Pub.Count_And_Get (
1313: p_count => x_msg_count,
1314: p_data => x_msg_data,
1315: p_encoded => FND_API.G_FALSE
1316: );

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

1348: OPEN c_objfundsum;
1349: FETCH c_objfundsum INTO l_objfundsum_rec;
1350: IF c_objfundsum%NOTFOUND THEN
1351: CLOSE c_objfundsum;
1352: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1353: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1354: Fnd_Msg_Pub.ADD;
1355: END IF;
1356: RAISE Fnd_Api.g_exc_error;

Line 1354: Fnd_Msg_Pub.ADD;

1350: IF c_objfundsum%NOTFOUND THEN
1351: CLOSE c_objfundsum;
1352: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1353: Fnd_Message.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1354: Fnd_Msg_Pub.ADD;
1355: END IF;
1356: RAISE Fnd_Api.g_exc_error;
1357: END IF;
1358: CLOSE c_objfundsum;