APPS.OZF_CLAIM_LINE_PVT dependencies on FND_MSG_PUB

Line 19: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

15:
16: -- object_type
17: G_CLAIM_OBJECT_TYPE CONSTANT VARCHAR2(30) := 'CLAM';
18:
19: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
20: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
21:
22:
23:

Line 20: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

16: -- object_type
17: G_CLAIM_OBJECT_TYPE CONSTANT VARCHAR2(30) := 'CLAM';
18:
19: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
20: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
21:
22:
23:
24: ---------------------------------------------------------------------

Line 252: FND_MSG_PUB.initialize;

248: OZF_Utility_PVT.debug_message(l_full_name||': start');
249: END IF;
250:
251: IF FND_API.to_boolean(p_init_msg_list) THEN
252: FND_MSG_PUB.initialize;
253: END IF;
254:
255: IF NOT FND_API.compatible_api_call(
256: l_api_version,

Line 365: FND_MSG_PUB.count_and_get(

361: RAISE FND_API.g_exc_error;
362: END IF;
363:
364: ------------------------- finish -------------------------------
365: FND_MSG_PUB.count_and_get(
366: p_encoded => FND_API.g_false,
367: p_count => x_msg_count,
368: p_data => x_msg_data
369: );

Line 379: FND_MSG_PUB.count_and_get (

375: EXCEPTION
376: WHEN FND_API.g_exc_error THEN
377: ROLLBACK TO Check_Create_Line_Hist;
378: x_return_status := FND_API.g_ret_sts_error;
379: FND_MSG_PUB.count_and_get (
380: p_encoded => FND_API.g_false
381: ,p_count => x_msg_count
382: ,p_data => x_msg_data
383: );

Line 388: FND_MSG_PUB.count_and_get (

384:
385: WHEN FND_API.g_exc_unexpected_error THEN
386: ROLLBACK TO Check_Create_Line_Hist;
387: x_return_status := FND_API.g_ret_sts_unexp_error ;
388: FND_MSG_PUB.count_and_get (
389: p_encoded => FND_API.g_false
390: ,p_count => x_msg_count
391: ,p_data => x_msg_data
392: );

Line 397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

393:
394: WHEN OTHERS THEN
395: ROLLBACK TO Check_Create_Line_Hist;
396: x_return_status := FND_API.g_ret_sts_unexp_error ;
397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
398: THEN
399: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
400: END IF;
401: FND_MSG_PUB.count_and_get(

Line 399: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

395: ROLLBACK TO Check_Create_Line_Hist;
396: x_return_status := FND_API.g_ret_sts_unexp_error ;
397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
398: THEN
399: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
400: END IF;
401: FND_MSG_PUB.count_and_get(
402: p_encoded => FND_API.g_false
403: ,p_count => x_msg_count

Line 401: FND_MSG_PUB.count_and_get(

397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
398: THEN
399: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
400: END IF;
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 531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

527: x_rate => l_rate
528: );
529: EXCEPTION
530: WHEN OTHERS THEN
531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
532: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TRIANG_API_ERR');
533: FND_MSG_PUB.add;
534: END IF;
535: RAISE FND_API.g_exc_error;

Line 533: FND_MSG_PUB.add;

529: EXCEPTION
530: WHEN OTHERS THEN
531: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
532: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TRIANG_API_ERR');
533: FND_MSG_PUB.add;
534: END IF;
535: RAISE FND_API.g_exc_error;
536: END;
537:

Line 589: FND_MSG_PUB.add;

585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: IF OZF_DEBUG_LOW_ON THEN
587: FND_MESSAGE.set_name('OZF', 'OZF_API_DEBUG_MESSAGE');
588: FND_MESSAGE.set_token('TEXT', l_full_name||': An error happened while converting line amount');
589: FND_MSG_PUB.add;
590: END IF;
591:
592: END Convert_Line_Amount;
593:

Line 683: FND_MSG_PUB.initialize;

679: OZF_Utility_PVT.debug_message(l_full_name||': start');
680: END IF;
681:
682: IF FND_API.to_boolean(p_init_msg_list) THEN
683: FND_MSG_PUB.initialize;
684: END IF;
685:
686: IF NOT FND_API.compatible_api_call(
687: l_api_version,

Line 908: FND_MSG_PUB.count_and_get(

904: IF FND_API.to_boolean(p_commit) THEN
905: COMMIT;
906: END IF;
907:
908: FND_MSG_PUB.count_and_get(
909: p_encoded => FND_API.g_false,
910: p_count => x_msg_count,
911: p_data => x_msg_data
912: );

Line 922: FND_MSG_PUB.count_and_get (

918: EXCEPTION
919: WHEN FND_API.g_exc_error THEN
920: ROLLBACK TO Update_Line_Fm_Claim;
921: x_return_status := FND_API.g_ret_sts_error;
922: FND_MSG_PUB.count_and_get (
923: p_encoded => FND_API.g_false
924: ,p_count => x_msg_count
925: ,p_data => x_msg_data
926: );

Line 931: FND_MSG_PUB.count_and_get (

927:
928: WHEN FND_API.g_exc_unexpected_error THEN
929: ROLLBACK TO Update_Line_Fm_Claim;
930: x_return_status := FND_API.g_ret_sts_unexp_error ;
931: FND_MSG_PUB.count_and_get (
932: p_encoded => FND_API.g_false
933: ,p_count => x_msg_count
934: ,p_data => x_msg_data
935: );

Line 940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

936:
937: WHEN OTHERS THEN
938: ROLLBACK TO Update_Line_Fm_Claim;
939: x_return_status := FND_API.g_ret_sts_unexp_error ;
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
941: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
942: END IF;
943: FND_MSG_PUB.count_and_get(
944: p_encoded => FND_API.g_false

Line 941: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

937: WHEN OTHERS THEN
938: ROLLBACK TO Update_Line_Fm_Claim;
939: x_return_status := FND_API.g_ret_sts_unexp_error ;
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
941: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
942: END IF;
943: FND_MSG_PUB.count_and_get(
944: p_encoded => FND_API.g_false
945: ,p_count => x_msg_count

Line 943: FND_MSG_PUB.count_and_get(

939: x_return_status := FND_API.g_ret_sts_unexp_error ;
940: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
941: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
942: END IF;
943: FND_MSG_PUB.count_and_get(
944: p_encoded => FND_API.g_false
945: ,p_count => x_msg_count
946: ,p_data => x_msg_data
947: );

Line 1025: FND_MSG_PUB.initialize;

1021: OZF_Utility_PVT.debug_message(l_full_name||': start');
1022: END IF;
1023:
1024: IF FND_API.to_boolean(p_init_msg_list) THEN
1025: FND_MSG_PUB.initialize;
1026: END IF;
1027:
1028: IF NOT FND_API.compatible_api_call(
1029: l_api_version,

Line 1056: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1052: -- Fix for Bug 12373880 : Throwing error if vendor information is missing
1053: IF (p_tax_action IS NOT NULL AND p_tax_action <> FND_API.G_MISS_CHAR) THEN
1054: IF l_payment_method IN ( 'EFT','WIRE','CHECK','AP_DEBIT', 'AP_DEFAULT') AND
1055: l_vendor_id IS NULL AND l_vendor_site_id IS NULL THEN
1056: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1057: FND_MESSAGE.set_name('OZF', 'OZF_VENDOR_INFO_MISSING');
1058: FND_MSG_PUB.add;
1059: END IF;
1060: RAISE FND_API.g_exc_error;

Line 1058: FND_MSG_PUB.add;

1054: IF l_payment_method IN ( 'EFT','WIRE','CHECK','AP_DEBIT', 'AP_DEFAULT') AND
1055: l_vendor_id IS NULL AND l_vendor_site_id IS NULL THEN
1056: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1057: FND_MESSAGE.set_name('OZF', 'OZF_VENDOR_INFO_MISSING');
1058: FND_MSG_PUB.add;
1059: END IF;
1060: RAISE FND_API.g_exc_error;
1061: END IF;
1062: END IF;

Line 1147: FND_MSG_PUB.count_and_get(

1143: IF FND_API.to_boolean(p_commit) THEN
1144: COMMIT;
1145: END IF;
1146:
1147: FND_MSG_PUB.count_and_get(
1148: p_encoded => FND_API.g_false,
1149: p_count => x_msg_count,
1150: p_data => x_msg_data
1151: );

Line 1161: FND_MSG_PUB.count_and_get (

1157: EXCEPTION
1158: WHEN FND_API.g_exc_error THEN
1159: ROLLBACK TO Update_Line_Fm_Claim;
1160: x_return_status := FND_API.g_ret_sts_error;
1161: FND_MSG_PUB.count_and_get (
1162: p_encoded => FND_API.g_false
1163: ,p_count => x_msg_count
1164: ,p_data => x_msg_data
1165: );

Line 1170: FND_MSG_PUB.count_and_get (

1166:
1167: WHEN FND_API.g_exc_unexpected_error THEN
1168: ROLLBACK TO Update_Line_Fm_Claim;
1169: x_return_status := FND_API.g_ret_sts_unexp_error ;
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 1179: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1175:
1176: WHEN OTHERS THEN
1177: ROLLBACK TO Update_Line_Fm_Claim;
1178: x_return_status := FND_API.g_ret_sts_unexp_error ;
1179: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1180: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1181: END IF;
1182: FND_MSG_PUB.count_and_get(
1183: p_encoded => FND_API.g_false

Line 1180: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1176: WHEN OTHERS THEN
1177: ROLLBACK TO Update_Line_Fm_Claim;
1178: x_return_status := FND_API.g_ret_sts_unexp_error ;
1179: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1180: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1181: END IF;
1182: FND_MSG_PUB.count_and_get(
1183: p_encoded => FND_API.g_false
1184: ,p_count => x_msg_count

Line 1182: FND_MSG_PUB.count_and_get(

1178: x_return_status := FND_API.g_ret_sts_unexp_error ;
1179: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1180: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1181: END IF;
1182: FND_MSG_PUB.count_and_get(
1183: p_encoded => FND_API.g_false
1184: ,p_count => x_msg_count
1185: ,p_data => x_msg_data
1186: );

Line 1280: FND_MSG_PUB.initialize;

1276: OZF_Utility_PVT.debug_message(l_full_name||': start');
1277: END IF;
1278:
1279: IF FND_API.to_boolean(p_init_msg_list) THEN
1280: FND_MSG_PUB.initialize;
1281: END IF;
1282:
1283: IF NOT FND_API.compatible_api_call(
1284: l_api_version,

Line 1315: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1311: , X_Msg_Data => l_msg_data
1312: , X_access => l_access);
1313:
1314: IF l_access = 'N' THEN
1315: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1316: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
1317: FND_MSG_PUB.add;
1318: END IF;
1319: RAISE FND_API.G_EXC_ERROR;

Line 1317: FND_MSG_PUB.add;

1313:
1314: IF l_access = 'N' THEN
1315: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1316: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
1317: FND_MSG_PUB.add;
1318: END IF;
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321: EXIT;

Line 1384: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1380: OZF_Utility_PVT.debug_message('Total Claim Line Quantity for source_object_line_id '|| l_claim_line_tbl(j).source_object_line_id || 'is ' || l_tot_quantity);
1381: END IF;
1382:
1383: IF l_inv_quantity < l_tot_quantity THEN
1384: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1385: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_INV_QTY');
1386: FND_MSG_PUB.add;
1387: END IF;
1388: x_error_index := j;

Line 1386: FND_MSG_PUB.add;

1382:
1383: IF l_inv_quantity < l_tot_quantity THEN
1384: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1385: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_INV_QTY');
1386: FND_MSG_PUB.add;
1387: END IF;
1388: x_error_index := j;
1389: RAISE FND_API.g_exc_error;
1390: END IF;

Line 1405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1401:
1402: -- raise error if claim currency amount is null
1403: -- added by slkrishn
1404: IF l_claim_line_tbl(j).claim_currency_amount IS NULL THEN
1405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1406: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
1407: FND_MSG_PUB.add;
1408: END IF;
1409: x_error_index := j;

Line 1407: FND_MSG_PUB.add;

1403: -- added by slkrishn
1404: IF l_claim_line_tbl(j).claim_currency_amount IS NULL THEN
1405: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1406: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
1407: FND_MSG_PUB.add;
1408: END IF;
1409: x_error_index := j;
1410: RAISE FND_API.g_exc_error;
1411: ELSE

Line 1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1439: --Skip the check in case of Subsequent Receipt Application.
1440: IF l_claim_class <> 'GROUP' THEN
1441: IF sign(l_exist_total_amt + l_create_total_amt) <> sign(l_claim_amount)
1442: THEN
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: RAISE FND_API.g_exc_error;

Line 1445: FND_MSG_PUB.add;

1441: IF sign(l_exist_total_amt + l_create_total_amt) <> sign(l_claim_amount)
1442: THEN
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: RAISE FND_API.g_exc_error;
1448: END IF;
1449: END IF;

Line 1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1450:
1451:
1452: IF ABS((l_exist_total_amt + l_create_total_amt)) > ABS(l_claim_amount) AND
1453: l_claim_class <> 'GROUP' THEN
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1455: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1456: FND_MSG_PUB.add;
1457: END IF;
1458: RAISE FND_API.g_exc_error;

Line 1456: FND_MSG_PUB.add;

1452: IF ABS((l_exist_total_amt + l_create_total_amt)) > ABS(l_claim_amount) AND
1453: l_claim_class <> 'GROUP' THEN
1454: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1455: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1456: FND_MSG_PUB.add;
1457: END IF;
1458: RAISE FND_API.g_exc_error;
1459: END IF;
1460: END IF;

Line 1513: FND_MSG_PUB.count_and_get(

1509: IF FND_API.to_boolean(p_commit) THEN
1510: COMMIT;
1511: END IF;
1512:
1513: FND_MSG_PUB.count_and_get(
1514: p_encoded => FND_API.g_false,
1515: p_count => x_msg_count,
1516: p_data => x_msg_data
1517: );

Line 1527: FND_MSG_PUB.count_and_get (

1523: EXCEPTION
1524: WHEN FND_API.g_exc_error THEN
1525: ROLLBACK TO Create_Claim_Line_Tbl;
1526: x_return_status := FND_API.g_ret_sts_error;
1527: FND_MSG_PUB.count_and_get (
1528: p_encoded => FND_API.g_false
1529: ,p_count => x_msg_count
1530: ,p_data => x_msg_data
1531: );

Line 1536: FND_MSG_PUB.count_and_get (

1532:
1533: WHEN FND_API.g_exc_unexpected_error THEN
1534: ROLLBACK TO Create_Claim_Line_Tbl;
1535: x_return_status := FND_API.g_ret_sts_unexp_error ;
1536: FND_MSG_PUB.count_and_get (
1537: p_encoded => FND_API.g_false
1538: ,p_count => x_msg_count
1539: ,p_data => x_msg_data
1540: );

Line 1545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

1541:
1542: WHEN OTHERS THEN
1543: ROLLBACK TO Create_Claim_Line_Tbl;
1544: x_return_status := FND_API.g_ret_sts_unexp_error ;
1545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1546: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1547: END IF;
1548: FND_MSG_PUB.count_and_get(
1549: p_encoded => FND_API.g_false

Line 1546: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1542: WHEN OTHERS THEN
1543: ROLLBACK TO Create_Claim_Line_Tbl;
1544: x_return_status := FND_API.g_ret_sts_unexp_error ;
1545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1546: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1547: END IF;
1548: FND_MSG_PUB.count_and_get(
1549: p_encoded => FND_API.g_false
1550: ,p_count => x_msg_count

Line 1548: FND_MSG_PUB.count_and_get(

1544: x_return_status := FND_API.g_ret_sts_unexp_error ;
1545: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1546: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1547: END IF;
1548: FND_MSG_PUB.count_and_get(
1549: p_encoded => FND_API.g_false
1550: ,p_count => x_msg_count
1551: ,p_data => x_msg_data
1552: );

Line 1704: FND_MSG_PUB.initialize;

1700: OZF_Utility_PVT.debug_message(l_full_name||': start');
1701: END IF;
1702:
1703: IF FND_API.to_boolean(p_init_msg_list) THEN
1704: FND_MSG_PUB.initialize;
1705: END IF;
1706:
1707: IF NOT FND_API.compatible_api_call(
1708: l_api_version,

Line 1736: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

1732: , X_Msg_Data => x_msg_data
1733: , X_access => l_access);
1734:
1735: IF l_access = 'N' THEN
1736: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1737: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
1738: FND_MSG_PUB.add;
1739: END IF;
1740: RAISE FND_API.G_EXC_ERROR;

Line 1738: FND_MSG_PUB.add;

1734:
1735: IF l_access = 'N' THEN
1736: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1737: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
1738: FND_MSG_PUB.add;
1739: END IF;
1740: RAISE FND_API.G_EXC_ERROR;
1741: END IF;
1742: END IF;

Line 1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1896: l_claim_line_rec := l_x_claim_line_rec;
1897: END IF;
1898: -- raise error if claim currency amount is null
1899: ELSE
1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1901: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
1902: FND_MSG_PUB.add;
1903: END IF;
1904: RAISE FND_API.g_exc_error;

Line 1902: FND_MSG_PUB.add;

1898: -- raise error if claim currency amount is null
1899: ELSE
1900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1901: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
1902: FND_MSG_PUB.add;
1903: END IF;
1904: RAISE FND_API.g_exc_error;
1905: END IF;
1906:

Line 1957: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1953: -- Sign of claim_currency_amount should be the same as claim amount_remaining
1954: -- 20-APR-04 Commenting the sign check for the claim amounts, as for a claim negative line amount
1955: -- can be specified to associate negative accruals. Similarily valid for DED/OPM.
1956: --IF SIGN(l_claim_line_rec.claim_currency_amount) <> SIGN(l_claim_amount) THEN
1957: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1958: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
1959: -- FND_MSG_PUB.add;
1960: -- END IF;
1961: -- RAISE FND_API.g_exc_error;

Line 1959: -- FND_MSG_PUB.add;

1955: -- can be specified to associate negative accruals. Similarily valid for DED/OPM.
1956: --IF SIGN(l_claim_line_rec.claim_currency_amount) <> SIGN(l_claim_amount) THEN
1957: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1958: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
1959: -- FND_MSG_PUB.add;
1960: -- END IF;
1961: -- RAISE FND_API.g_exc_error;
1962: --END IF;
1963:

Line 1978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1974:
1975: -- comparison of claim amount and line amount (claim_currency_amount)
1976: IF l_line_sum_amt IS NOT NULL THEN
1977: IF ABS((l_line_sum_amt + l_claim_line_rec.claim_currency_amount)) > ABS(l_claim_amount) THEN
1978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1979: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1980: FND_MSG_PUB.add;
1981: END IF;
1982: RAISE FND_API.g_exc_error;

Line 1980: FND_MSG_PUB.add;

1976: IF l_line_sum_amt IS NOT NULL THEN
1977: IF ABS((l_line_sum_amt + l_claim_line_rec.claim_currency_amount)) > ABS(l_claim_amount) THEN
1978: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1979: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1980: FND_MSG_PUB.add;
1981: END IF;
1982: RAISE FND_API.g_exc_error;
1983: END IF;
1984: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN

Line 1985: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1981: END IF;
1982: RAISE FND_API.g_exc_error;
1983: END IF;
1984: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
1985: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1986: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1987: FND_MSG_PUB.add;
1988: END IF;
1989: RAISE FND_API.g_exc_error;

Line 1987: FND_MSG_PUB.add;

1983: END IF;
1984: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
1985: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1986: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1987: FND_MSG_PUB.add;
1988: END IF;
1989: RAISE FND_API.g_exc_error;
1990: END IF;
1991: END IF;

Line 2249: FND_MSG_PUB.count_and_get(

2245: IF FND_API.to_boolean(p_commit) THEN
2246: COMMIT;
2247: END IF;
2248:
2249: FND_MSG_PUB.count_and_get(
2250: p_encoded => FND_API.g_false,
2251: p_count => x_msg_count,
2252: p_data => x_msg_data
2253: );

Line 2263: FND_MSG_PUB.count_and_get (

2259: EXCEPTION
2260: WHEN FND_API.g_exc_error THEN
2261: ROLLBACK TO Create_Claim_Line;
2262: x_return_status := FND_API.g_ret_sts_error;
2263: FND_MSG_PUB.count_and_get (
2264: p_encoded => FND_API.g_false
2265: ,p_count => x_msg_count
2266: ,p_data => x_msg_data
2267: );

Line 2272: FND_MSG_PUB.count_and_get (

2268:
2269: WHEN FND_API.g_exc_unexpected_error THEN
2270: ROLLBACK TO Create_Claim_Line;
2271: x_return_status := FND_API.g_ret_sts_unexp_error ;
2272: FND_MSG_PUB.count_and_get (
2273: p_encoded => FND_API.g_false
2274: ,p_count => x_msg_count
2275: ,p_data => x_msg_data
2276: );

Line 2281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2277:
2278: WHEN OTHERS THEN
2279: ROLLBACK TO Create_Claim_Line;
2280: x_return_status := FND_API.g_ret_sts_unexp_error ;
2281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2282: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2283: END IF;
2284: FND_MSG_PUB.count_and_get(
2285: p_encoded => FND_API.g_false

Line 2282: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2278: WHEN OTHERS THEN
2279: ROLLBACK TO Create_Claim_Line;
2280: x_return_status := FND_API.g_ret_sts_unexp_error ;
2281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2282: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2283: END IF;
2284: FND_MSG_PUB.count_and_get(
2285: p_encoded => FND_API.g_false
2286: ,p_count => x_msg_count

Line 2284: FND_MSG_PUB.count_and_get(

2280: x_return_status := FND_API.g_ret_sts_unexp_error ;
2281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2282: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2283: END IF;
2284: FND_MSG_PUB.count_and_get(
2285: p_encoded => FND_API.g_false
2286: ,p_count => x_msg_count
2287: ,p_data => x_msg_data
2288: );

Line 2366: FND_MSG_PUB.initialize;

2362: OZF_Utility_PVT.debug_message(l_full_name||': start');
2363: END IF;
2364:
2365: IF FND_API.to_boolean(p_init_msg_list) THEN
2366: FND_MSG_PUB.initialize;
2367: END IF;
2368:
2369: IF NOT FND_API.compatible_api_call(
2370: l_api_version,

Line 2398: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2394: , X_Msg_Data => l_msg_data
2395: , X_access => l_access);
2396:
2397: IF l_access = 'N' THEN
2398: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2399: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2400: FND_MSG_PUB.add;
2401: END IF;
2402: RAISE FND_API.G_EXC_ERROR;

Line 2400: FND_MSG_PUB.add;

2396:
2397: IF l_access = 'N' THEN
2398: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2399: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2400: FND_MSG_PUB.add;
2401: END IF;
2402: RAISE FND_API.G_EXC_ERROR;
2403: END IF;
2404: EXIT;

Line 2434: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2430: IF l_claim_class <> 'GROUP' THEN
2431: IF (sign(l_effective_line_amount) <> sign(l_claim_amount))
2432: AND l_effective_line_amount <> 0
2433: THEN
2434: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2435: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
2436: FND_MSG_PUB.add;
2437: END IF;
2438: RAISE FND_API.g_exc_error;

Line 2436: FND_MSG_PUB.add;

2432: AND l_effective_line_amount <> 0
2433: THEN
2434: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2435: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
2436: FND_MSG_PUB.add;
2437: END IF;
2438: RAISE FND_API.g_exc_error;
2439: END IF;
2440:

Line 2443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2439: END IF;
2440:
2441: IF ABS(l_effective_line_amount) > ABS(l_claim_amount)
2442: THEN
2443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2444: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
2445: FND_MSG_PUB.add;
2446: END IF;
2447: RAISE FND_API.g_exc_error;

Line 2445: FND_MSG_PUB.add;

2441: IF ABS(l_effective_line_amount) > ABS(l_claim_amount)
2442: THEN
2443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2444: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
2445: FND_MSG_PUB.add;
2446: END IF;
2447: RAISE FND_API.g_exc_error;
2448: END IF;
2449: END IF;

Line 2504: FND_MSG_PUB.count_and_get(

2500: IF FND_API.to_boolean(p_commit) THEN
2501: COMMIT;
2502: END IF;
2503:
2504: FND_MSG_PUB.count_and_get(
2505: p_encoded => FND_API.g_false,
2506: p_count => x_msg_count,
2507: p_data => x_msg_data
2508: );

Line 2518: FND_MSG_PUB.count_and_get (

2514: EXCEPTION
2515: WHEN FND_API.g_exc_error THEN
2516: ROLLBACK TO Delete_Claim_Line_Tbl;
2517: x_return_status := FND_API.g_ret_sts_error;
2518: FND_MSG_PUB.count_and_get (
2519: p_encoded => FND_API.g_false
2520: ,p_count => x_msg_count
2521: ,p_data => x_msg_data
2522: );

Line 2527: FND_MSG_PUB.count_and_get (

2523:
2524: WHEN FND_API.g_exc_unexpected_error THEN
2525: ROLLBACK TO Delete_Claim_Line_Tbl;
2526: x_return_status := FND_API.g_ret_sts_unexp_error ;
2527: FND_MSG_PUB.count_and_get (
2528: p_encoded => FND_API.g_false
2529: ,p_count => x_msg_count
2530: ,p_data => x_msg_data
2531: );

Line 2536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2532:
2533: WHEN OTHERS THEN
2534: ROLLBACK TO Delete_Claim_Line_Tbl;
2535: x_return_status := FND_API.g_ret_sts_unexp_error ;
2536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2537: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2538: END IF;
2539: FND_MSG_PUB.count_and_get(
2540: p_encoded => FND_API.g_false

Line 2537: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2533: WHEN OTHERS THEN
2534: ROLLBACK TO Delete_Claim_Line_Tbl;
2535: x_return_status := FND_API.g_ret_sts_unexp_error ;
2536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2537: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2538: END IF;
2539: FND_MSG_PUB.count_and_get(
2540: p_encoded => FND_API.g_false
2541: ,p_count => x_msg_count

Line 2539: FND_MSG_PUB.count_and_get(

2535: x_return_status := FND_API.g_ret_sts_unexp_error ;
2536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2537: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2538: END IF;
2539: FND_MSG_PUB.count_and_get(
2540: p_encoded => FND_API.g_false
2541: ,p_count => x_msg_count
2542: ,p_data => x_msg_data
2543: );

Line 2625: FND_MSG_PUB.initialize;

2621: OZF_Utility_PVT.debug_message(l_full_name||': start');
2622: END IF;
2623:
2624: IF FND_API.to_boolean(p_init_msg_list) THEN
2625: FND_MSG_PUB.initialize;
2626: END IF;
2627:
2628: IF NOT FND_API.compatible_api_call(
2629: l_api_version,

Line 2659: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

2655: , X_Msg_Data => x_msg_data
2656: , X_access => l_access);
2657:
2658: IF l_access = 'N' THEN
2659: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2660: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2661: FND_MSG_PUB.add;
2662: END IF;
2663: RAISE FND_API.G_EXC_ERROR;

Line 2661: FND_MSG_PUB.add;

2657:
2658: IF l_access = 'N' THEN
2659: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2660: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2661: FND_MSG_PUB.add;
2662: END IF;
2663: RAISE FND_API.G_EXC_ERROR;
2664: END IF;
2665: END IF;

Line 2681: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2677:
2678: -- comparison of claim amount and line amount (claim_currency_amount)
2679: --IF l_line_sum_amt IS NOT NULL THEN
2680: --IF ABS(l_line_sum_amt) > ABS(l_claim_amount) THEN
2681: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2682: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
2683: --FND_MSG_PUB.add;
2684: --END IF;
2685: --RAISE FND_API.g_exc_error;

Line 2683: --FND_MSG_PUB.add;

2679: --IF l_line_sum_amt IS NOT NULL THEN
2680: --IF ABS(l_line_sum_amt) > ABS(l_claim_amount) THEN
2681: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2682: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
2683: --FND_MSG_PUB.add;
2684: --END IF;
2685: --RAISE FND_API.g_exc_error;
2686: --END IF;
2687: --END IF;

Line 2733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2729: WHERE claim_line_id = p_claim_line_id
2730: AND object_version_number = p_object_version;
2731:
2732: IF (SQL%NOTFOUND) THEN
2733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2734: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2735: FND_MSG_PUB.add;
2736: END IF;
2737: RAISE FND_API.g_exc_error;

Line 2735: FND_MSG_PUB.add;

2731:
2732: IF (SQL%NOTFOUND) THEN
2733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2734: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2735: FND_MSG_PUB.add;
2736: END IF;
2737: RAISE FND_API.g_exc_error;
2738: END IF;
2739:

Line 2745: FND_MSG_PUB.count_and_get(

2741: IF FND_API.to_boolean(p_commit) THEN
2742: COMMIT;
2743: END IF;
2744:
2745: FND_MSG_PUB.count_and_get(
2746: p_encoded => FND_API.g_false,
2747: p_count => x_msg_count,
2748: p_data => x_msg_data
2749: );

Line 2759: FND_MSG_PUB.count_and_get(

2755: EXCEPTION
2756: WHEN FND_API.g_exc_error THEN
2757: ROLLBACK TO Delete_Claim_Line;
2758: x_return_status := FND_API.g_ret_sts_error;
2759: FND_MSG_PUB.count_and_get(
2760: p_encoded => FND_API.g_false,
2761: p_count => x_msg_count,
2762: p_data => x_msg_data
2763: );

Line 2768: FND_MSG_PUB.count_and_get(

2764:
2765: WHEN FND_API.g_exc_unexpected_error THEN
2766: ROLLBACK TO Delete_Claim_Line;
2767: x_return_status := FND_API.g_ret_sts_unexp_error ;
2768: FND_MSG_PUB.count_and_get(
2769: p_encoded => FND_API.g_false,
2770: p_count => x_msg_count,
2771: p_data => x_msg_data
2772: );

Line 2777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2773:
2774: WHEN OTHERS THEN
2775: ROLLBACK TO Delete_Claim_Line;
2776: x_return_status := FND_API.g_ret_sts_unexp_error ;
2777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2778: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2779: END IF;
2780: FND_MSG_PUB.count_and_get(
2781: p_encoded => FND_API.g_false,

Line 2778: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2774: WHEN OTHERS THEN
2775: ROLLBACK TO Delete_Claim_Line;
2776: x_return_status := FND_API.g_ret_sts_unexp_error ;
2777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2778: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2779: END IF;
2780: FND_MSG_PUB.count_and_get(
2781: p_encoded => FND_API.g_false,
2782: p_count => x_msg_count,

Line 2780: FND_MSG_PUB.count_and_get(

2776: x_return_status := FND_API.g_ret_sts_unexp_error ;
2777: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2778: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2779: END IF;
2780: FND_MSG_PUB.count_and_get(
2781: p_encoded => FND_API.g_false,
2782: p_count => x_msg_count,
2783: p_data => x_msg_data
2784: );

Line 2828: FND_MSG_PUB.initialize;

2824: OZF_Utility_PVT.debug_message(l_full_name||': start');
2825: END IF;
2826:
2827: IF FND_API.to_boolean(p_init_msg_list) THEN
2828: FND_MSG_PUB.initialize;
2829: END IF;
2830:
2831: IF NOT FND_API.compatible_api_call(
2832: l_api_version,

Line 2851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2847: OPEN c_claim_line;
2848: FETCH c_claim_line INTO l_claim_line_id;
2849: IF (c_claim_line%NOTFOUND) THEN
2850: CLOSE c_claim_line;
2851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2852: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2853: FND_MSG_PUB.add;
2854: END IF;
2855: RAISE FND_API.g_exc_error;

Line 2853: FND_MSG_PUB.add;

2849: IF (c_claim_line%NOTFOUND) THEN
2850: CLOSE c_claim_line;
2851: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2852: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2853: FND_MSG_PUB.add;
2854: END IF;
2855: RAISE FND_API.g_exc_error;
2856: END IF;
2857: CLOSE c_claim_line;

Line 2860: FND_MSG_PUB.count_and_get(

2856: END IF;
2857: CLOSE c_claim_line;
2858:
2859: -------------------- finish --------------------------
2860: FND_MSG_PUB.count_and_get(
2861: p_encoded => FND_API.g_false,
2862: p_count => x_msg_count,
2863: p_data => x_msg_data
2864: );

Line 2873: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2869:
2870: EXCEPTION
2871: WHEN OZF_Utility_PVT.resource_locked THEN
2872: x_return_status := FND_API.g_ret_sts_error;
2873: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2874: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
2875: FND_MSG_PUB.add;
2876: END IF;
2877: FND_MSG_PUB.count_and_get(

Line 2875: FND_MSG_PUB.add;

2871: WHEN OZF_Utility_PVT.resource_locked THEN
2872: x_return_status := FND_API.g_ret_sts_error;
2873: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2874: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
2875: FND_MSG_PUB.add;
2876: END IF;
2877: FND_MSG_PUB.count_and_get(
2878: p_encoded => FND_API.g_false,
2879: p_count => x_msg_count,

Line 2877: FND_MSG_PUB.count_and_get(

2873: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2874: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
2875: FND_MSG_PUB.add;
2876: END IF;
2877: FND_MSG_PUB.count_and_get(
2878: p_encoded => FND_API.g_false,
2879: p_count => x_msg_count,
2880: p_data => x_msg_data
2881: );

Line 2885: FND_MSG_PUB.count_and_get(

2881: );
2882:
2883: WHEN FND_API.g_exc_error THEN
2884: x_return_status := FND_API.g_ret_sts_error;
2885: FND_MSG_PUB.count_and_get(
2886: p_encoded => FND_API.g_false,
2887: p_count => x_msg_count,
2888: p_data => x_msg_data
2889: );

Line 2893: FND_MSG_PUB.count_and_get(

2889: );
2890:
2891: WHEN FND_API.g_exc_unexpected_error THEN
2892: x_return_status := FND_API.g_ret_sts_unexp_error ;
2893: FND_MSG_PUB.count_and_get(
2894: p_encoded => FND_API.g_false,
2895: p_count => x_msg_count,
2896: p_data => x_msg_data
2897: );

Line 2901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

2897: );
2898:
2899: WHEN OTHERS THEN
2900: x_return_status := FND_API.g_ret_sts_unexp_error ;
2901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2902: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2903: END IF;
2904: FND_MSG_PUB.count_and_get(
2905: p_encoded => FND_API.g_false,

Line 2902: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2898:
2899: WHEN OTHERS THEN
2900: x_return_status := FND_API.g_ret_sts_unexp_error ;
2901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2902: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2903: END IF;
2904: FND_MSG_PUB.count_and_get(
2905: p_encoded => FND_API.g_false,
2906: p_count => x_msg_count,

Line 2904: FND_MSG_PUB.count_and_get(

2900: x_return_status := FND_API.g_ret_sts_unexp_error ;
2901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2902: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2903: END IF;
2904: FND_MSG_PUB.count_and_get(
2905: p_encoded => FND_API.g_false,
2906: p_count => x_msg_count,
2907: p_data => x_msg_data
2908: );

Line 2968: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2964:
2965: -------------- Lock items when earnings is associated --------------
2966: IF l_earnings_associated_flag = FND_API.g_true THEN
2967: IF NVL(p_claim_line_rec.source_object_id,FND_API.g_miss_num) <> l_source_object_id THEN
2968: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2969: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2970: FND_MESSAGE.set_token('LOCK', 'Name OR Line / Product');
2971: FND_MSG_PUB.add;
2972: END IF;

Line 2971: FND_MSG_PUB.add;

2967: IF NVL(p_claim_line_rec.source_object_id,FND_API.g_miss_num) <> l_source_object_id THEN
2968: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2969: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2970: FND_MESSAGE.set_token('LOCK', 'Name OR Line / Product');
2971: FND_MSG_PUB.add;
2972: END IF;
2973: x_return_status := FND_API.g_ret_sts_error;
2974: RETURN;
2975: END IF;

Line 2977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2973: x_return_status := FND_API.g_ret_sts_error;
2974: RETURN;
2975: END IF;
2976: IF NVL(p_claim_line_rec.source_object_class,FND_API.g_miss_char) <> l_source_object_class THEN
2977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2978: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2979: FND_MESSAGE.set_token('LOCK', 'Type');
2980: FND_MSG_PUB.add;
2981: END IF;

Line 2980: FND_MSG_PUB.add;

2976: IF NVL(p_claim_line_rec.source_object_class,FND_API.g_miss_char) <> l_source_object_class THEN
2977: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2978: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2979: FND_MESSAGE.set_token('LOCK', 'Type');
2980: FND_MSG_PUB.add;
2981: END IF;
2982: x_return_status := FND_API.g_ret_sts_error;
2983: RETURN;
2984: END IF;

Line 2986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2982: x_return_status := FND_API.g_ret_sts_error;
2983: RETURN;
2984: END IF;
2985: IF NVL(p_claim_line_rec.source_object_type_id,FND_API.g_miss_num) <> l_source_object_type_id THEN
2986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2987: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2988: FND_MESSAGE.set_token('LOCK', 'Type');
2989: FND_MSG_PUB.add;
2990: END IF;

Line 2989: FND_MSG_PUB.add;

2985: IF NVL(p_claim_line_rec.source_object_type_id,FND_API.g_miss_num) <> l_source_object_type_id THEN
2986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2987: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2988: FND_MESSAGE.set_token('LOCK', 'Type');
2989: FND_MSG_PUB.add;
2990: END IF;
2991: x_return_status := FND_API.g_ret_sts_error;
2992: RETURN;
2993: END IF;

Line 2995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2991: x_return_status := FND_API.g_ret_sts_error;
2992: RETURN;
2993: END IF;
2994: IF NVL(p_claim_line_rec.plan_id,FND_API.g_miss_num) <> l_plan_id THEN
2995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2996: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2997: FND_MESSAGE.set_token('LOCK', 'Type');
2998: FND_MSG_PUB.add;
2999: END IF;

Line 2998: FND_MSG_PUB.add;

2994: IF NVL(p_claim_line_rec.plan_id,FND_API.g_miss_num) <> l_plan_id THEN
2995: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2996: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2997: FND_MESSAGE.set_token('LOCK', 'Type');
2998: FND_MSG_PUB.add;
2999: END IF;
3000: x_return_status := FND_API.g_ret_sts_error;
3001: RETURN;
3002: END IF;

Line 3004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3000: x_return_status := FND_API.g_ret_sts_error;
3001: RETURN;
3002: END IF;
3003: IF NVL(p_claim_line_rec.item_id,FND_API.g_miss_num) <> l_item_id THEN
3004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3005: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
3006: FND_MESSAGE.set_token('LOCK', 'Line / Product');
3007: FND_MSG_PUB.add;
3008: END IF;

Line 3007: FND_MSG_PUB.add;

3003: IF NVL(p_claim_line_rec.item_id,FND_API.g_miss_num) <> l_item_id THEN
3004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3005: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
3006: FND_MESSAGE.set_token('LOCK', 'Line / Product');
3007: FND_MSG_PUB.add;
3008: END IF;
3009: x_return_status := FND_API.g_ret_sts_error;
3010: RETURN;
3011: END IF;

Line 3014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3010: RETURN;
3011: END IF;
3012: /*
3013: IF NVL(p_claim_line_rec.item_description,FND_API.g_miss_char) <> l_item_description THEN
3014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3015: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
3016: FND_MESSAGE.set_token('LOCK', 'ITEM_DESCRIPTION');
3017: FND_MSG_PUB.add;
3018: END IF;

Line 3017: FND_MSG_PUB.add;

3013: IF NVL(p_claim_line_rec.item_description,FND_API.g_miss_char) <> l_item_description THEN
3014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3015: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
3016: FND_MESSAGE.set_token('LOCK', 'ITEM_DESCRIPTION');
3017: FND_MSG_PUB.add;
3018: END IF;
3019: x_return_status := FND_API.g_ret_sts_error;
3020: RETURN;
3021: END IF;

Line 3024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3020: RETURN;
3021: END IF;
3022: */
3023: IF NVL(p_claim_line_rec.activity_type,FND_API.g_miss_char) <> l_activity_type THEN
3024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3025: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
3026: FND_MESSAGE.set_token('LOCK', 'Name');
3027: FND_MSG_PUB.add;
3028: END IF;

Line 3027: FND_MSG_PUB.add;

3023: IF NVL(p_claim_line_rec.activity_type,FND_API.g_miss_char) <> l_activity_type THEN
3024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3025: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
3026: FND_MESSAGE.set_token('LOCK', 'Name');
3027: FND_MSG_PUB.add;
3028: END IF;
3029: x_return_status := FND_API.g_ret_sts_error;
3030: RETURN;
3031: END IF;

Line 3033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3029: x_return_status := FND_API.g_ret_sts_error;
3030: RETURN;
3031: END IF;
3032: IF NVL(p_claim_line_rec.activity_id,FND_API.g_miss_num) <> l_activity_id THEN
3033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3034: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
3035: FND_MESSAGE.set_token('LOCK', 'Name');
3036: FND_MSG_PUB.add;
3037: END IF;

Line 3036: FND_MSG_PUB.add;

3032: IF NVL(p_claim_line_rec.activity_id,FND_API.g_miss_num) <> l_activity_id THEN
3033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3034: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
3035: FND_MESSAGE.set_token('LOCK', 'Name');
3036: FND_MSG_PUB.add;
3037: END IF;
3038: x_return_status := FND_API.g_ret_sts_error;
3039: RETURN;
3040: END IF;

Line 3143: FND_MSG_PUB.initialize;

3139: OZF_Utility_PVT.debug_message(l_full_name||': start');
3140: END IF;
3141:
3142: IF FND_API.to_boolean(p_init_msg_list) THEN
3143: FND_MSG_PUB.initialize;
3144: END IF;
3145:
3146: IF NOT FND_API.compatible_api_call(
3147: l_api_version,

Line 3177: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3173: , X_Msg_Data => l_msg_data
3174: , X_access => l_access);
3175:
3176: IF l_access = 'N' THEN
3177: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3178: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
3179: FND_MSG_PUB.add;
3180: END IF;
3181: RAISE FND_API.G_EXC_ERROR;

Line 3179: FND_MSG_PUB.add;

3175:
3176: IF l_access = 'N' THEN
3177: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3178: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
3179: FND_MSG_PUB.add;
3180: END IF;
3181: RAISE FND_API.G_EXC_ERROR;
3182: END IF;
3183: EXIT;

Line 3256: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3252: OZF_Utility_PVT.debug_message('Total Quantity is ' || l_tot_quantity);
3253: END IF;
3254:
3255: IF l_inv_quantity < l_tot_quantity THEN
3256: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3257: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_INV_QTY');
3258: FND_MSG_PUB.add;
3259: END IF;
3260: x_error_index := j;

Line 3258: FND_MSG_PUB.add;

3254:
3255: IF l_inv_quantity < l_tot_quantity THEN
3256: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3257: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_INV_QTY');
3258: FND_MSG_PUB.add;
3259: END IF;
3260: x_error_index := j;
3261: RAISE FND_API.g_exc_error;
3262: END IF;

Line 3278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3274: END IF;
3275:
3276: -------- raise error if claim currency amount is null ----------
3277: IF l_claim_line_tbl(j).claim_currency_amount IS NULL THEN
3278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3279: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
3280: FND_MSG_PUB.add;
3281: END IF;
3282: x_error_index := j;

Line 3280: FND_MSG_PUB.add;

3276: -------- raise error if claim currency amount is null ----------
3277: IF l_claim_line_tbl(j).claim_currency_amount IS NULL THEN
3278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3279: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
3280: FND_MSG_PUB.add;
3281: END IF;
3282: x_error_index := j;
3283: RAISE FND_API.g_exc_error;
3284: ELSE

Line 3314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3310: --ER#9453443 : Added the Offer ID check
3311: IF (l_claim_class <> 'GROUP' AND l_offer_id IS NULL) THEN
3312: IF sign(l_exist_total_amt - l_old_upd_total_amt + l_new_upd_total_amt) <> sign(l_claim_amount)
3313: THEN
3314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3315: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
3316: FND_MSG_PUB.add;
3317: END IF;
3318: RAISE FND_API.g_exc_error;

Line 3316: FND_MSG_PUB.add;

3312: IF sign(l_exist_total_amt - l_old_upd_total_amt + l_new_upd_total_amt) <> sign(l_claim_amount)
3313: THEN
3314: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3315: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
3316: FND_MSG_PUB.add;
3317: END IF;
3318: RAISE FND_API.g_exc_error;
3319: END IF;
3320:

Line 3328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3324: --ER#9453443 : Added the Offer ID check
3325: IF ((p_mode <> OZF_CLAIM_UTILITY_PVT.g_request_mode OR
3326: l_claim_class <> 'GROUP') AND l_offer_id IS NULL) THEN
3327: IF ABS(l_exist_total_amt - l_old_upd_total_amt + l_new_upd_total_amt) > ABS(l_claim_amount) THEN
3328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3329: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
3330: FND_MSG_PUB.add;
3331: END IF;
3332: RAISE FND_API.g_exc_error;

Line 3330: FND_MSG_PUB.add;

3326: l_claim_class <> 'GROUP') AND l_offer_id IS NULL) THEN
3327: IF ABS(l_exist_total_amt - l_old_upd_total_amt + l_new_upd_total_amt) > ABS(l_claim_amount) THEN
3328: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3329: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
3330: FND_MSG_PUB.add;
3331: END IF;
3332: RAISE FND_API.g_exc_error;
3333: END IF;
3334: END IF;

Line 3381: FND_MSG_PUB.count_and_get(

3377: IF FND_API.to_boolean(p_commit) THEN
3378: COMMIT;
3379: END IF;
3380:
3381: FND_MSG_PUB.count_and_get(
3382: p_encoded => FND_API.g_false,
3383: p_count => x_msg_count,
3384: p_data => x_msg_data
3385: );

Line 3395: FND_MSG_PUB.count_and_get (

3391: EXCEPTION
3392: WHEN FND_API.g_exc_error THEN
3393: ROLLBACK TO Update_Claim_Line_Tbl;
3394: x_return_status := FND_API.g_ret_sts_error;
3395: FND_MSG_PUB.count_and_get (
3396: p_encoded => FND_API.g_false
3397: ,p_count => x_msg_count
3398: ,p_data => x_msg_data
3399: );

Line 3404: FND_MSG_PUB.count_and_get (

3400:
3401: WHEN FND_API.g_exc_unexpected_error THEN
3402: ROLLBACK TO Update_Claim_Line_Tbl;
3403: x_return_status := FND_API.g_ret_sts_unexp_error ;
3404: FND_MSG_PUB.count_and_get (
3405: p_encoded => FND_API.g_false
3406: ,p_count => x_msg_count
3407: ,p_data => x_msg_data
3408: );

Line 3413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3409:
3410: WHEN OTHERS THEN
3411: ROLLBACK TO Update_Claim_Line_Tbl;
3412: x_return_status := FND_API.g_ret_sts_unexp_error ;
3413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3414: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3415: END IF;
3416: FND_MSG_PUB.count_and_get(
3417: p_encoded => FND_API.g_false

Line 3414: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3410: WHEN OTHERS THEN
3411: ROLLBACK TO Update_Claim_Line_Tbl;
3412: x_return_status := FND_API.g_ret_sts_unexp_error ;
3413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3414: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3415: END IF;
3416: FND_MSG_PUB.count_and_get(
3417: p_encoded => FND_API.g_false
3418: ,p_count => x_msg_count

Line 3416: FND_MSG_PUB.count_and_get(

3412: x_return_status := FND_API.g_ret_sts_unexp_error ;
3413: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3414: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3415: END IF;
3416: FND_MSG_PUB.count_and_get(
3417: p_encoded => FND_API.g_false
3418: ,p_count => x_msg_count
3419: ,p_data => x_msg_data
3420: );

Line 3561: FND_MSG_PUB.initialize;

3557: OZF_Utility_PVT.debug_message(l_full_name||': start');
3558: END IF;
3559:
3560: IF FND_API.to_boolean(p_init_msg_list) THEN
3561: FND_MSG_PUB.initialize;
3562: END IF;
3563:
3564: IF NOT FND_API.compatible_api_call(
3565: l_api_version,

Line 3591: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

3587: , X_Msg_Data => x_msg_data
3588: , X_access => l_access);
3589:
3590: IF l_access = 'N' THEN
3591: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3592: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
3593: FND_MSG_PUB.add;
3594: END IF;
3595: RAISE FND_API.G_EXC_ERROR;

Line 3593: FND_MSG_PUB.add;

3589:
3590: IF l_access = 'N' THEN
3591: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3592: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
3593: FND_MSG_PUB.add;
3594: END IF;
3595: RAISE FND_API.G_EXC_ERROR;
3596: END IF;
3597: END IF;

Line 3701: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3697: END IF;
3698:
3699: -------- raise error if claim currency amount is null ----------
3700: IF l_claim_line_rec.claim_currency_amount IS NULL THEN
3701: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3702: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
3703: FND_MSG_PUB.add;
3704: END IF;
3705: RAISE FND_API.g_exc_error;

Line 3703: FND_MSG_PUB.add;

3699: -------- raise error if claim currency amount is null ----------
3700: IF l_claim_line_rec.claim_currency_amount IS NULL THEN
3701: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3702: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
3703: FND_MSG_PUB.add;
3704: END IF;
3705: RAISE FND_API.g_exc_error;
3706: END IF;
3707: END IF;

Line 3854: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3850: --DATE : 03-jun-2003 [Changed for Sign erro in case of partial application for claim investigation.]
3851: -- IF l_claim_amount <> 0 THEN
3852: -- Sign of claim_currency_amount should be the same as claim amount_remaining
3853: -- IF SIGN(l_claim_line_rec.claim_currency_amount) <> SIGN(l_claim_amount) THEN
3854: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3855: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
3856: -- FND_MSG_PUB.add;
3857: -- END IF;
3858: -- RAISE FND_API.g_exc_error;

Line 3856: -- FND_MSG_PUB.add;

3852: -- Sign of claim_currency_amount should be the same as claim amount_remaining
3853: -- IF SIGN(l_claim_line_rec.claim_currency_amount) <> SIGN(l_claim_amount) THEN
3854: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3855: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
3856: -- FND_MSG_PUB.add;
3857: -- END IF;
3858: -- RAISE FND_API.g_exc_error;
3859: -- END IF;
3860: --END IF;

Line 3891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3887: THEN --Bug:2781186
3888: -- comparison of claim amount and line amount
3889: IF l_line_sum_amt IS NOT NULL THEN
3890: IF ABS(l_line_sum_amt + l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
3891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
3893: FND_MSG_PUB.add;
3894: END IF;
3895: RAISE FND_API.g_exc_error;

Line 3893: FND_MSG_PUB.add;

3889: IF l_line_sum_amt IS NOT NULL THEN
3890: IF ABS(l_line_sum_amt + l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
3891: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3892: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
3893: FND_MSG_PUB.add;
3894: END IF;
3895: RAISE FND_API.g_exc_error;
3896: END IF;
3897: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN

Line 3898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3894: END IF;
3895: RAISE FND_API.g_exc_error;
3896: END IF;
3897: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
3898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3899: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
3900: FND_MSG_PUB.add;
3901: END IF;
3902: RAISE FND_API.g_exc_error;

Line 3900: FND_MSG_PUB.add;

3896: END IF;
3897: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
3898: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3899: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
3900: FND_MSG_PUB.add;
3901: END IF;
3902: RAISE FND_API.g_exc_error;
3903: END IF;
3904: END IF;

Line 3946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3942: ELSE
3943: ------- check line acctd amount is more then earnings acctd amount -------
3944:
3945: IF ABS(nvl(l_claim_line_rec.acctd_amount,0)) < ABS(l_line_util_acc_amt) THEN
3946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3947: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_EXCESS_LINE_AMT');
3948: FND_MSG_PUB.add;
3949: END IF;
3950: RAISE FND_API.g_exc_error;

Line 3948: FND_MSG_PUB.add;

3944:
3945: IF ABS(nvl(l_claim_line_rec.acctd_amount,0)) < ABS(l_line_util_acc_amt) THEN
3946: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3947: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_EXCESS_LINE_AMT');
3948: FND_MSG_PUB.add;
3949: END IF;
3950: RAISE FND_API.g_exc_error;
3951: END IF;
3952:

Line 4107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4103: WHERE claim_line_id = l_claim_line_rec.claim_line_id
4104: AND object_version_number = l_claim_line_rec.object_version_number;
4105:
4106: IF (SQL%NOTFOUND) THEN
4107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4108: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
4109: FND_MSG_PUB.add;
4110: END IF;
4111: RAISE FND_API.g_exc_error;

Line 4109: FND_MSG_PUB.add;

4105:
4106: IF (SQL%NOTFOUND) THEN
4107: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4108: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
4109: FND_MSG_PUB.add;
4110: END IF;
4111: RAISE FND_API.g_exc_error;
4112: END IF;
4113:

Line 4122: FND_MSG_PUB.count_and_get(

4118: IF FND_API.to_boolean(p_commit) THEN
4119: COMMIT;
4120: END IF;
4121:
4122: FND_MSG_PUB.count_and_get(
4123: p_encoded => FND_API.g_false,
4124: p_count => x_msg_count,
4125: p_data => x_msg_data
4126: );

Line 4136: FND_MSG_PUB.count_and_get(

4132: EXCEPTION
4133: WHEN FND_API.g_exc_error THEN
4134: ROLLBACK TO Update_Claim_Line;
4135: x_return_status := FND_API.g_ret_sts_error;
4136: FND_MSG_PUB.count_and_get(
4137: p_encoded => FND_API.g_false,
4138: p_count => x_msg_count,
4139: p_data => x_msg_data
4140: );

Line 4145: FND_MSG_PUB.count_and_get(

4141:
4142: WHEN FND_API.g_exc_unexpected_error THEN
4143: ROLLBACK TO Update_Claim_Line;
4144: x_return_status := FND_API.g_ret_sts_unexp_error ;
4145: FND_MSG_PUB.count_and_get(
4146: p_encoded => FND_API.g_false,
4147: p_count => x_msg_count,
4148: p_data => x_msg_data
4149: );

Line 4154: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4150:
4151: WHEN OTHERS THEN
4152: ROLLBACK TO Update_Claim_Line;
4153: x_return_status := FND_API.g_ret_sts_unexp_error ;
4154: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4155: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4156: END IF;
4157: FND_MSG_PUB.count_and_get(
4158: p_encoded => FND_API.g_false,

Line 4155: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

4151: WHEN OTHERS THEN
4152: ROLLBACK TO Update_Claim_Line;
4153: x_return_status := FND_API.g_ret_sts_unexp_error ;
4154: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4155: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4156: END IF;
4157: FND_MSG_PUB.count_and_get(
4158: p_encoded => FND_API.g_false,
4159: p_count => x_msg_count,

Line 4157: FND_MSG_PUB.count_and_get(

4153: x_return_status := FND_API.g_ret_sts_unexp_error ;
4154: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4155: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4156: END IF;
4157: FND_MSG_PUB.count_and_get(
4158: p_encoded => FND_API.g_false,
4159: p_count => x_msg_count,
4160: p_data => x_msg_data
4161: );

Line 4198: FND_MSG_PUB.initialize;

4194: OZF_Utility_PVT.debug_message(l_full_name||': start');
4195: END IF;
4196:
4197: IF FND_API.to_boolean(p_init_msg_list) THEN
4198: FND_MSG_PUB.initialize;
4199: END IF;
4200:
4201: IF NOT FND_API.compatible_api_call(
4202: l_api_version,

Line 4250: FND_MSG_PUB.count_and_get(

4246: END IF;
4247: END IF;
4248:
4249: -------------------- finish --------------------------
4250: FND_MSG_PUB.count_and_get(
4251: p_encoded => FND_API.g_false,
4252: p_count => x_msg_count,
4253: p_data => x_msg_data
4254: );

Line 4263: FND_MSG_PUB.count_and_get(

4259:
4260: EXCEPTION
4261: WHEN FND_API.g_exc_error THEN
4262: x_return_status := FND_API.g_ret_sts_error;
4263: FND_MSG_PUB.count_and_get(
4264: p_encoded => FND_API.g_false,
4265: p_count => x_msg_count,
4266: p_data => x_msg_data
4267: );

Line 4271: FND_MSG_PUB.count_and_get(

4267: );
4268:
4269: WHEN FND_API.g_exc_unexpected_error THEN
4270: x_return_status := FND_API.g_ret_sts_unexp_error ;
4271: FND_MSG_PUB.count_and_get(
4272: p_encoded => FND_API.g_false,
4273: p_count => x_msg_count,
4274: p_data => x_msg_data
4275: );

Line 4279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

4275: );
4276:
4277: WHEN OTHERS THEN
4278: x_return_status := FND_API.g_ret_sts_unexp_error;
4279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4281: END IF;
4282: FND_MSG_PUB.count_and_get(
4283: p_encoded => FND_API.g_false,

Line 4280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

4276:
4277: WHEN OTHERS THEN
4278: x_return_status := FND_API.g_ret_sts_unexp_error;
4279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4281: END IF;
4282: FND_MSG_PUB.count_and_get(
4283: p_encoded => FND_API.g_false,
4284: p_count => x_msg_count,

Line 4282: FND_MSG_PUB.count_and_get(

4278: x_return_status := FND_API.g_ret_sts_unexp_error;
4279: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
4280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4281: END IF;
4282: FND_MSG_PUB.count_and_get(
4283: p_encoded => FND_API.g_false,
4284: p_count => x_msg_count,
4285: p_data => x_msg_data
4286: );

Line 4310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4306:
4307: ------------------------ CLAIM_ID -------------------------------
4308: IF p_claim_line_rec.claim_id <> FND_API.g_miss_num AND
4309: p_claim_line_rec.claim_id IS NULL THEN
4310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4311: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
4312: FND_MESSAGE.set_token('COLUMN', 'CLAIM_ID');
4313: FND_MSG_PUB.add;
4314: END IF;

Line 4313: FND_MSG_PUB.add;

4309: p_claim_line_rec.claim_id IS NULL THEN
4310: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4311: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
4312: FND_MESSAGE.set_token('COLUMN', 'CLAIM_ID');
4313: FND_MSG_PUB.add;
4314: END IF;
4315:
4316: x_return_status := FND_API.g_ret_sts_error;
4317: RETURN;

Line 4321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4317: RETURN;
4318: ------------------------ LINE_NUMBER -------------------------------
4319: ELSIF p_claim_line_rec.line_number <> FND_API.g_miss_num AND
4320: p_claim_line_rec.line_number IS NULL THEN
4321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4322: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
4323: FND_MESSAGE.set_token('COLUMN', 'LINE_NUMBER');
4324: FND_MSG_PUB.add;
4325: END IF;

Line 4324: FND_MSG_PUB.add;

4320: p_claim_line_rec.line_number IS NULL THEN
4321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4322: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
4323: FND_MESSAGE.set_token('COLUMN', 'LINE_NUMBER');
4324: FND_MSG_PUB.add;
4325: END IF;
4326:
4327: x_return_status := FND_API.g_ret_sts_error;
4328: RETURN;

Line 4332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4328: RETURN;
4329: ------------------------ SET_OF_BOOKS_ID -------------------------------
4330: ELSIF p_claim_line_rec.set_of_books_id <> FND_API.g_miss_num AND
4331: p_claim_line_rec.set_of_books_id IS NULL THEN
4332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4333: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
4334: FND_MESSAGE.set_token('COLUMN', 'SET_OF_BOOKS_ID');
4335: FND_MSG_PUB.add;
4336: END IF;

Line 4335: FND_MSG_PUB.add;

4331: p_claim_line_rec.set_of_books_id IS NULL THEN
4332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4333: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
4334: FND_MESSAGE.set_token('COLUMN', 'SET_OF_BOOKS_ID');
4335: FND_MSG_PUB.add;
4336: END IF;
4337:
4338: x_return_status := FND_API.g_ret_sts_error;
4339: RETURN;

Line 4371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4367: IF OZF_Utility_PVT.check_uniqueness(
4368: 'ozf_claim_lines',
4369: 'claim_line_id = ' || p_claim_line_rec.claim_line_id
4370: ) = FND_API.g_false THEN
4371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4372: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DUPLICATE_VALUE');
4373: FND_MESSAGE.set_token('COLLUMN', 'CLAIM_LINE_ID');
4374: FND_MSG_PUB.add;
4375: END IF;

Line 4374: FND_MSG_PUB.add;

4370: ) = FND_API.g_false THEN
4371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4372: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DUPLICATE_VALUE');
4373: FND_MESSAGE.set_token('COLLUMN', 'CLAIM_LINE_ID');
4374: FND_MSG_PUB.add;
4375: END IF;
4376: x_return_status := FND_API.g_ret_sts_error;
4377: RETURN;
4378: END IF;

Line 4448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4444: IF p_claim_line_rec.valid_flag <> FND_API.g_miss_char AND
4445: p_claim_line_rec.valid_flag IS NOT NULL THEN
4446: IF p_claim_line_rec.valid_flag <> FND_API.g_true AND
4447: p_claim_line_rec.valid_flag <> FND_API.g_false THEN
4448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4449: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4450: FND_MESSAGE.set_token('FLAG', 'VALID_FLAG');
4451: FND_MSG_PUB.add;
4452: END IF;

Line 4451: FND_MSG_PUB.add;

4447: p_claim_line_rec.valid_flag <> FND_API.g_false THEN
4448: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4449: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4450: FND_MESSAGE.set_token('FLAG', 'VALID_FLAG');
4451: FND_MSG_PUB.add;
4452: END IF;
4453: x_return_status := FND_API.g_ret_sts_error;
4454: RETURN;
4455: END IF;

Line 4463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4459: IF p_claim_line_rec.approved_flag <> FND_API.g_miss_char AND
4460: p_claim_line_rec.approved_flag IS NOT NULL THEN
4461: IF p_claim_line_rec.approved_flag <> FND_API.g_true AND
4462: p_claim_line_rec.approved_flag <> FND_API.g_false THEN
4463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4464: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4465: FND_MESSAGE.set_token('FLAG', 'APPROVED_FLAG');
4466: FND_MSG_PUB.add;
4467: END IF;

Line 4466: FND_MSG_PUB.add;

4462: p_claim_line_rec.approved_flag <> FND_API.g_false THEN
4463: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4464: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4465: FND_MESSAGE.set_token('FLAG', 'APPROVED_FLAG');
4466: FND_MSG_PUB.add;
4467: END IF;
4468: x_return_status := FND_API.g_ret_sts_error;
4469: RETURN;
4470: END IF;

Line 4478: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4474: IF p_claim_line_rec.performance_complete_flag <> FND_API.g_miss_char AND
4475: p_claim_line_rec.performance_complete_flag IS NOT NULL THEN
4476: IF p_claim_line_rec.performance_complete_flag <> FND_API.g_true AND
4477: p_claim_line_rec.performance_complete_flag <> FND_API.g_false THEN
4478: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4479: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4480: FND_MESSAGE.set_token('FLAG', 'PERFORMANCE_COMPLETE_FLAG');
4481: FND_MSG_PUB.add;
4482: END IF;

Line 4481: FND_MSG_PUB.add;

4477: p_claim_line_rec.performance_complete_flag <> FND_API.g_false THEN
4478: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4479: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4480: FND_MESSAGE.set_token('FLAG', 'PERFORMANCE_COMPLETE_FLAG');
4481: FND_MSG_PUB.add;
4482: END IF;
4483: x_return_status := FND_API.g_ret_sts_error;
4484: RETURN;
4485: END IF;

Line 4493: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4489: IF p_claim_line_rec.performance_attached_flag <> FND_API.g_miss_char AND
4490: p_claim_line_rec.performance_attached_flag IS NOT NULL THEN
4491: IF p_claim_line_rec.performance_attached_flag <> FND_API.g_true AND
4492: p_claim_line_rec.performance_attached_flag <> FND_API.g_false THEN
4493: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4494: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4495: FND_MESSAGE.set_token('FLAG', 'PERFORMANCE_ATTACHED_FLAG');
4496: FND_MSG_PUB.add;
4497: END IF;

Line 4496: FND_MSG_PUB.add;

4492: p_claim_line_rec.performance_attached_flag <> FND_API.g_false THEN
4493: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4494: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4495: FND_MESSAGE.set_token('FLAG', 'PERFORMANCE_ATTACHED_FLAG');
4496: FND_MSG_PUB.add;
4497: END IF;
4498: x_return_status := FND_API.g_ret_sts_error;
4499: RETURN;
4500: END IF;

Line 4508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4504: IF p_claim_line_rec.earnings_associated_flag <> FND_API.g_miss_char AND
4505: p_claim_line_rec.earnings_associated_flag IS NOT NULL THEN
4506: IF p_claim_line_rec.earnings_associated_flag <> FND_API.g_true AND
4507: p_claim_line_rec.earnings_associated_flag <> FND_API.g_false THEN
4508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4509: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4510: FND_MESSAGE.set_token('FLAG', 'EARNINGS_ASSOCIATED_FLAG');
4511: FND_MSG_PUB.add;
4512: END IF;

Line 4511: FND_MSG_PUB.add;

4507: p_claim_line_rec.earnings_associated_flag <> FND_API.g_false THEN
4508: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4509: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4510: FND_MESSAGE.set_token('FLAG', 'EARNINGS_ASSOCIATED_FLAG');
4511: FND_MSG_PUB.add;
4512: END IF;
4513: x_return_status := FND_API.g_ret_sts_error;
4514: RETURN;
4515: END IF;

Line 4646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4642: FETCH csr_ap_tax_code INTO l_tax_code;
4643: CLOSE csr_ap_tax_code;
4644:
4645: IF l_tax_code IS NULL THEN
4646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4647: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4648: FND_MSG_PUB.add;
4649: END IF;
4650: x_return_status := FND_API.g_ret_sts_error;

Line 4648: FND_MSG_PUB.add;

4644:
4645: IF l_tax_code IS NULL THEN
4646: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4647: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4648: FND_MSG_PUB.add;
4649: END IF;
4650: x_return_status := FND_API.g_ret_sts_error;
4651: RETURN;
4652: END IF;

Line 4659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4655: FETCH csr_ar_tax_code INTO l_tax_code;
4656: CLOSE csr_ar_tax_code;
4657:
4658: IF l_tax_code IS NULL THEN
4659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4660: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4661: FND_MSG_PUB.add;
4662: END IF;
4663: x_return_status := FND_API.g_ret_sts_error;

Line 4661: FND_MSG_PUB.add;

4657:
4658: IF l_tax_code IS NULL THEN
4659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4660: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4661: FND_MSG_PUB.add;
4662: END IF;
4663: x_return_status := FND_API.g_ret_sts_error;
4664: RETURN;
4665: END IF;

Line 4667: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4663: x_return_status := FND_API.g_ret_sts_error;
4664: RETURN;
4665: END IF;
4666: ELSIF l_tax_for IS NULL THEN
4667: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4668: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4669: FND_MSG_PUB.add;
4670: END IF;
4671: x_return_status := FND_API.g_ret_sts_error;

Line 4669: FND_MSG_PUB.add;

4665: END IF;
4666: ELSIF l_tax_for IS NULL THEN
4667: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4668: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4669: FND_MSG_PUB.add;
4670: END IF;
4671: x_return_status := FND_API.g_ret_sts_error;
4672: RETURN;
4673: END IF;

Line 4685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4681: FETCH csr_customer_trx_id INTO l_source_object_id;
4682: CLOSE csr_customer_trx_id;
4683:
4684: IF l_source_object_id <> p_complete_rec.source_object_id THEN
4685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4686: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVLINE_NOT_IN_INV');
4687: FND_MSG_PUB.add;
4688: END IF;
4689: x_return_status := FND_API.g_ret_sts_error;

Line 4687: FND_MSG_PUB.add;

4683:
4684: IF l_source_object_id <> p_complete_rec.source_object_id THEN
4685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4686: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVLINE_NOT_IN_INV');
4687: FND_MSG_PUB.add;
4688: END IF;
4689: x_return_status := FND_API.g_ret_sts_error;
4690: RETURN;
4691: END IF;

Line 4818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

4814: OPEN c_claim_line(p_claim_line_rec.claim_line_id);
4815: FETCH c_claim_line INTO l_claim_line_rec;
4816: IF c_claim_line%NOTFOUND THEN
4817: CLOSE c_claim_line;
4818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4819: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
4820: FND_MSG_PUB.add;
4821: END IF;
4822: RAISE FND_API.g_exc_error;

Line 4820: FND_MSG_PUB.add;

4816: IF c_claim_line%NOTFOUND THEN
4817: CLOSE c_claim_line;
4818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4819: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
4820: FND_MSG_PUB.add;
4821: END IF;
4822: RAISE FND_API.g_exc_error;
4823: END IF;
4824: CLOSE c_claim_line;

Line 5576: FND_MSG_PUB.initialize;

5572: OZF_Utility_PVT.debug_message(l_full_name||': start');
5573: END IF;
5574:
5575: IF FND_API.to_boolean(p_init_msg_list) THEN
5576: FND_MSG_PUB.initialize;
5577: END IF;
5578:
5579: IF NOT FND_API.compatible_api_call(
5580: l_api_version,

Line 5822: FND_MSG_PUB.count_and_get(

5818: IF FND_API.to_boolean(p_commit) THEN
5819: COMMIT;
5820: END IF;
5821:
5822: FND_MSG_PUB.count_and_get(
5823: p_encoded => FND_API.g_false,
5824: p_count => x_msg_count,
5825: p_data => x_msg_data
5826: );

Line 5836: FND_MSG_PUB.count_and_get(

5832: EXCEPTION
5833: WHEN FND_API.g_exc_error THEN
5834: ROLLBACK TO split_claim_line;
5835: x_return_status := FND_API.g_ret_sts_error;
5836: FND_MSG_PUB.count_and_get(
5837: p_encoded => FND_API.g_false,
5838: p_count => x_msg_count,
5839: p_data => x_msg_data
5840: );

Line 5845: FND_MSG_PUB.count_and_get(

5841:
5842: WHEN FND_API.g_exc_unexpected_error THEN
5843: ROLLBACK TO split_claim_line;
5844: x_return_status := FND_API.g_ret_sts_unexp_error ;
5845: FND_MSG_PUB.count_and_get(
5846: p_encoded => FND_API.g_false,
5847: p_count => x_msg_count,
5848: p_data => x_msg_data
5849: );

Line 5854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

5850:
5851: WHEN OTHERS THEN
5852: ROLLBACK TO split_claim_line;
5853: x_return_status := FND_API.g_ret_sts_unexp_error ;
5854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5855: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5856: END IF;
5857: FND_MSG_PUB.count_and_get(
5858: p_encoded => FND_API.g_false,

Line 5855: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

5851: WHEN OTHERS THEN
5852: ROLLBACK TO split_claim_line;
5853: x_return_status := FND_API.g_ret_sts_unexp_error ;
5854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5855: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5856: END IF;
5857: FND_MSG_PUB.count_and_get(
5858: p_encoded => FND_API.g_false,
5859: p_count => x_msg_count,

Line 5857: FND_MSG_PUB.count_and_get(

5853: x_return_status := FND_API.g_ret_sts_unexp_error ;
5854: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5855: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5856: END IF;
5857: FND_MSG_PUB.count_and_get(
5858: p_encoded => FND_API.g_false,
5859: p_count => x_msg_count,
5860: p_data => x_msg_data
5861: );

Line 5925: FND_MSG_PUB.initialize;

5921: OZF_Utility_PVT.debug_message(l_full_name||': start');
5922: END IF;
5923:
5924: IF FND_API.to_boolean(p_init_msg_list) THEN
5925: FND_MSG_PUB.initialize;
5926: END IF;
5927:
5928: IF NOT FND_API.compatible_api_call(
5929: l_api_version,

Line 5975: FND_MSG_PUB.count_and_get(

5971: IF FND_API.to_boolean(p_commit) THEN
5972: COMMIT;
5973: END IF;
5974:
5975: FND_MSG_PUB.count_and_get(
5976: p_encoded => FND_API.g_false,
5977: p_count => x_msg_count,
5978: p_data => x_msg_data
5979: );

Line 5989: FND_MSG_PUB.count_and_get(

5985: EXCEPTION
5986: WHEN FND_API.g_exc_error THEN
5987: ROLLBACK TO delete_all_association;
5988: x_return_status := FND_API.g_ret_sts_error;
5989: FND_MSG_PUB.count_and_get(
5990: p_encoded => FND_API.g_false,
5991: p_count => x_msg_count,
5992: p_data => x_msg_data
5993: );

Line 5998: FND_MSG_PUB.count_and_get(

5994:
5995: WHEN FND_API.g_exc_unexpected_error THEN
5996: ROLLBACK TO delete_all_association;
5997: x_return_status := FND_API.g_ret_sts_unexp_error ;
5998: FND_MSG_PUB.count_and_get(
5999: p_encoded => FND_API.g_false,
6000: p_count => x_msg_count,
6001: p_data => x_msg_data
6002: );

Line 6007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

6003:
6004: WHEN OTHERS THEN
6005: ROLLBACK TO delete_all_association;
6006: x_return_status := FND_API.g_ret_sts_unexp_error ;
6007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6008: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6009: END IF;
6010: FND_MSG_PUB.count_and_get(
6011: p_encoded => FND_API.g_false,

Line 6008: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

6004: WHEN OTHERS THEN
6005: ROLLBACK TO delete_all_association;
6006: x_return_status := FND_API.g_ret_sts_unexp_error ;
6007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6008: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6009: END IF;
6010: FND_MSG_PUB.count_and_get(
6011: p_encoded => FND_API.g_false,
6012: p_count => x_msg_count,

Line 6010: FND_MSG_PUB.count_and_get(

6006: x_return_status := FND_API.g_ret_sts_unexp_error ;
6007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
6008: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6009: END IF;
6010: FND_MSG_PUB.count_and_get(
6011: p_encoded => FND_API.g_false,
6012: p_count => x_msg_count,
6013: p_data => x_msg_data
6014: );