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 1024: FND_MSG_PUB.initialize;

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

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

1055: , X_Msg_Data => l_msg_data
1056: , X_access => l_access);
1057:
1058: IF l_access = 'N' THEN
1059: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1060: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
1061: FND_MSG_PUB.add;
1062: END IF;
1063: RAISE FND_API.G_EXC_ERROR;

Line 1061: FND_MSG_PUB.add;

1057:
1058: IF l_access = 'N' THEN
1059: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1060: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
1061: FND_MSG_PUB.add;
1062: END IF;
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065: EXIT;

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

1102:
1103: -- raise error if claim currency amount is null
1104: -- added by slkrishn
1105: IF l_claim_line_tbl(j).claim_currency_amount IS NULL THEN
1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1107: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
1108: FND_MSG_PUB.add;
1109: END IF;
1110: x_error_index := j;

Line 1108: FND_MSG_PUB.add;

1104: -- added by slkrishn
1105: IF l_claim_line_tbl(j).claim_currency_amount IS NULL THEN
1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1107: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
1108: FND_MSG_PUB.add;
1109: END IF;
1110: x_error_index := j;
1111: RAISE FND_API.g_exc_error;
1112: ELSE

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

1140: --Skip the check in case of Subsequent Receipt Application.
1141: IF l_claim_class <> 'GROUP' THEN
1142: IF sign(l_exist_total_amt + l_create_total_amt) <> sign(l_claim_amount)
1143: THEN
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1145: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
1146: FND_MSG_PUB.add;
1147: END IF;
1148: RAISE FND_API.g_exc_error;

Line 1146: FND_MSG_PUB.add;

1142: IF sign(l_exist_total_amt + l_create_total_amt) <> sign(l_claim_amount)
1143: THEN
1144: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1145: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
1146: FND_MSG_PUB.add;
1147: END IF;
1148: RAISE FND_API.g_exc_error;
1149: END IF;
1150: END IF;

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

1151:
1152:
1153: IF ABS((l_exist_total_amt + l_create_total_amt)) > ABS(l_claim_amount) AND
1154: l_claim_class <> 'GROUP' THEN
1155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1156: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1157: FND_MSG_PUB.add;
1158: END IF;
1159: RAISE FND_API.g_exc_error;

Line 1157: FND_MSG_PUB.add;

1153: IF ABS((l_exist_total_amt + l_create_total_amt)) > ABS(l_claim_amount) AND
1154: l_claim_class <> 'GROUP' THEN
1155: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1156: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1157: FND_MSG_PUB.add;
1158: END IF;
1159: RAISE FND_API.g_exc_error;
1160: END IF;
1161: END IF;

Line 1212: FND_MSG_PUB.count_and_get(

1208: IF FND_API.to_boolean(p_commit) THEN
1209: COMMIT;
1210: END IF;
1211:
1212: FND_MSG_PUB.count_and_get(
1213: p_encoded => FND_API.g_false,
1214: p_count => x_msg_count,
1215: p_data => x_msg_data
1216: );

Line 1226: FND_MSG_PUB.count_and_get (

1222: EXCEPTION
1223: WHEN FND_API.g_exc_error THEN
1224: ROLLBACK TO Create_Claim_Line_Tbl;
1225: x_return_status := FND_API.g_ret_sts_error;
1226: FND_MSG_PUB.count_and_get (
1227: p_encoded => FND_API.g_false
1228: ,p_count => x_msg_count
1229: ,p_data => x_msg_data
1230: );

Line 1235: FND_MSG_PUB.count_and_get (

1231:
1232: WHEN FND_API.g_exc_unexpected_error THEN
1233: ROLLBACK TO Create_Claim_Line_Tbl;
1234: x_return_status := FND_API.g_ret_sts_unexp_error ;
1235: FND_MSG_PUB.count_and_get (
1236: p_encoded => FND_API.g_false
1237: ,p_count => x_msg_count
1238: ,p_data => x_msg_data
1239: );

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

1240:
1241: WHEN OTHERS THEN
1242: ROLLBACK TO Create_Claim_Line_Tbl;
1243: x_return_status := FND_API.g_ret_sts_unexp_error ;
1244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1245: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1246: END IF;
1247: FND_MSG_PUB.count_and_get(
1248: p_encoded => FND_API.g_false

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

1241: WHEN OTHERS THEN
1242: ROLLBACK TO Create_Claim_Line_Tbl;
1243: x_return_status := FND_API.g_ret_sts_unexp_error ;
1244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1245: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1246: END IF;
1247: FND_MSG_PUB.count_and_get(
1248: p_encoded => FND_API.g_false
1249: ,p_count => x_msg_count

Line 1247: FND_MSG_PUB.count_and_get(

1243: x_return_status := FND_API.g_ret_sts_unexp_error ;
1244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1245: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1246: END IF;
1247: FND_MSG_PUB.count_and_get(
1248: p_encoded => FND_API.g_false
1249: ,p_count => x_msg_count
1250: ,p_data => x_msg_data
1251: );

Line 1386: FND_MSG_PUB.initialize;

1382: OZF_Utility_PVT.debug_message(l_full_name||': start');
1383: END IF;
1384:
1385: IF FND_API.to_boolean(p_init_msg_list) THEN
1386: FND_MSG_PUB.initialize;
1387: END IF;
1388:
1389: IF NOT FND_API.compatible_api_call(
1390: l_api_version,

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

1414: , X_Msg_Data => x_msg_data
1415: , X_access => l_access);
1416:
1417: IF l_access = 'N' THEN
1418: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1419: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
1420: FND_MSG_PUB.add;
1421: END IF;
1422: RAISE FND_API.G_EXC_ERROR;

Line 1420: FND_MSG_PUB.add;

1416:
1417: IF l_access = 'N' THEN
1418: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1419: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
1420: FND_MSG_PUB.add;
1421: END IF;
1422: RAISE FND_API.G_EXC_ERROR;
1423: END IF;
1424: END IF;

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

1564: l_claim_line_rec := l_x_claim_line_rec;
1565: END IF;
1566: -- raise error if claim currency amount is null
1567: ELSE
1568: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1569: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
1570: FND_MSG_PUB.add;
1571: END IF;
1572: RAISE FND_API.g_exc_error;

Line 1570: FND_MSG_PUB.add;

1566: -- raise error if claim currency amount is null
1567: ELSE
1568: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1569: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
1570: FND_MSG_PUB.add;
1571: END IF;
1572: RAISE FND_API.g_exc_error;
1573: END IF;
1574:

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

1617: -- Sign of claim_currency_amount should be the same as claim amount_remaining
1618: -- 20-APR-04 Commenting the sign check for the claim amounts, as for a claim negative line amount
1619: -- can be specified to associate negative accruals. Similarily valid for DED/OPM.
1620: --IF SIGN(l_claim_line_rec.claim_currency_amount) <> SIGN(l_claim_amount) THEN
1621: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1622: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
1623: -- FND_MSG_PUB.add;
1624: -- END IF;
1625: -- RAISE FND_API.g_exc_error;

Line 1623: -- FND_MSG_PUB.add;

1619: -- can be specified to associate negative accruals. Similarily valid for DED/OPM.
1620: --IF SIGN(l_claim_line_rec.claim_currency_amount) <> SIGN(l_claim_amount) THEN
1621: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1622: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
1623: -- FND_MSG_PUB.add;
1624: -- END IF;
1625: -- RAISE FND_API.g_exc_error;
1626: --END IF;
1627:

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

1638:
1639: -- comparison of claim amount and line amount (claim_currency_amount)
1640: IF l_line_sum_amt IS NOT NULL THEN
1641: IF ABS((l_line_sum_amt + l_claim_line_rec.claim_currency_amount)) > ABS(l_claim_amount) THEN
1642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1643: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1644: FND_MSG_PUB.add;
1645: END IF;
1646: RAISE FND_API.g_exc_error;

Line 1644: FND_MSG_PUB.add;

1640: IF l_line_sum_amt IS NOT NULL THEN
1641: IF ABS((l_line_sum_amt + l_claim_line_rec.claim_currency_amount)) > ABS(l_claim_amount) THEN
1642: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1643: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1644: FND_MSG_PUB.add;
1645: END IF;
1646: RAISE FND_API.g_exc_error;
1647: END IF;
1648: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN

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

1645: END IF;
1646: RAISE FND_API.g_exc_error;
1647: END IF;
1648: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
1649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1650: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1651: FND_MSG_PUB.add;
1652: END IF;
1653: RAISE FND_API.g_exc_error;

Line 1651: FND_MSG_PUB.add;

1647: END IF;
1648: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
1649: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1650: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
1651: FND_MSG_PUB.add;
1652: END IF;
1653: RAISE FND_API.g_exc_error;
1654: END IF;
1655: END IF;

Line 1909: FND_MSG_PUB.count_and_get(

1905: IF FND_API.to_boolean(p_commit) THEN
1906: COMMIT;
1907: END IF;
1908:
1909: FND_MSG_PUB.count_and_get(
1910: p_encoded => FND_API.g_false,
1911: p_count => x_msg_count,
1912: p_data => x_msg_data
1913: );

Line 1923: FND_MSG_PUB.count_and_get (

1919: EXCEPTION
1920: WHEN FND_API.g_exc_error THEN
1921: ROLLBACK TO Create_Claim_Line;
1922: x_return_status := FND_API.g_ret_sts_error;
1923: FND_MSG_PUB.count_and_get (
1924: p_encoded => FND_API.g_false
1925: ,p_count => x_msg_count
1926: ,p_data => x_msg_data
1927: );

Line 1932: FND_MSG_PUB.count_and_get (

1928:
1929: WHEN FND_API.g_exc_unexpected_error THEN
1930: ROLLBACK TO Create_Claim_Line;
1931: x_return_status := FND_API.g_ret_sts_unexp_error ;
1932: FND_MSG_PUB.count_and_get (
1933: p_encoded => FND_API.g_false
1934: ,p_count => x_msg_count
1935: ,p_data => x_msg_data
1936: );

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

1937:
1938: WHEN OTHERS THEN
1939: ROLLBACK TO Create_Claim_Line;
1940: x_return_status := FND_API.g_ret_sts_unexp_error ;
1941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1942: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1943: END IF;
1944: FND_MSG_PUB.count_and_get(
1945: p_encoded => FND_API.g_false

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

1938: WHEN OTHERS THEN
1939: ROLLBACK TO Create_Claim_Line;
1940: x_return_status := FND_API.g_ret_sts_unexp_error ;
1941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1942: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1943: END IF;
1944: FND_MSG_PUB.count_and_get(
1945: p_encoded => FND_API.g_false
1946: ,p_count => x_msg_count

Line 1944: FND_MSG_PUB.count_and_get(

1940: x_return_status := FND_API.g_ret_sts_unexp_error ;
1941: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1942: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1943: END IF;
1944: FND_MSG_PUB.count_and_get(
1945: p_encoded => FND_API.g_false
1946: ,p_count => x_msg_count
1947: ,p_data => x_msg_data
1948: );

Line 2026: FND_MSG_PUB.initialize;

2022: OZF_Utility_PVT.debug_message(l_full_name||': start');
2023: END IF;
2024:
2025: IF FND_API.to_boolean(p_init_msg_list) THEN
2026: FND_MSG_PUB.initialize;
2027: END IF;
2028:
2029: IF NOT FND_API.compatible_api_call(
2030: l_api_version,

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

2054: , X_Msg_Data => l_msg_data
2055: , X_access => l_access);
2056:
2057: IF l_access = 'N' THEN
2058: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2059: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2060: FND_MSG_PUB.add;
2061: END IF;
2062: RAISE FND_API.G_EXC_ERROR;

Line 2060: FND_MSG_PUB.add;

2056:
2057: IF l_access = 'N' THEN
2058: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2059: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2060: FND_MSG_PUB.add;
2061: END IF;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2064: EXIT;

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

2090: IF l_claim_class <> 'GROUP' THEN
2091: IF (sign(l_effective_line_amount) <> sign(l_claim_amount))
2092: AND l_effective_line_amount <> 0
2093: THEN
2094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2095: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
2096: FND_MSG_PUB.add;
2097: END IF;
2098: RAISE FND_API.g_exc_error;

Line 2096: FND_MSG_PUB.add;

2092: AND l_effective_line_amount <> 0
2093: THEN
2094: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2095: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
2096: FND_MSG_PUB.add;
2097: END IF;
2098: RAISE FND_API.g_exc_error;
2099: END IF;
2100:

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

2099: END IF;
2100:
2101: IF ABS(l_effective_line_amount) > ABS(l_claim_amount)
2102: THEN
2103: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2104: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
2105: FND_MSG_PUB.add;
2106: END IF;
2107: RAISE FND_API.g_exc_error;

Line 2105: FND_MSG_PUB.add;

2101: IF ABS(l_effective_line_amount) > ABS(l_claim_amount)
2102: THEN
2103: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2104: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
2105: FND_MSG_PUB.add;
2106: END IF;
2107: RAISE FND_API.g_exc_error;
2108: END IF;
2109: END IF;

Line 2154: FND_MSG_PUB.count_and_get(

2150: IF FND_API.to_boolean(p_commit) THEN
2151: COMMIT;
2152: END IF;
2153:
2154: FND_MSG_PUB.count_and_get(
2155: p_encoded => FND_API.g_false,
2156: p_count => x_msg_count,
2157: p_data => x_msg_data
2158: );

Line 2168: FND_MSG_PUB.count_and_get (

2164: EXCEPTION
2165: WHEN FND_API.g_exc_error THEN
2166: ROLLBACK TO Delete_Claim_Line_Tbl;
2167: x_return_status := FND_API.g_ret_sts_error;
2168: FND_MSG_PUB.count_and_get (
2169: p_encoded => FND_API.g_false
2170: ,p_count => x_msg_count
2171: ,p_data => x_msg_data
2172: );

Line 2177: FND_MSG_PUB.count_and_get (

2173:
2174: WHEN FND_API.g_exc_unexpected_error THEN
2175: ROLLBACK TO Delete_Claim_Line_Tbl;
2176: x_return_status := FND_API.g_ret_sts_unexp_error ;
2177: FND_MSG_PUB.count_and_get (
2178: p_encoded => FND_API.g_false
2179: ,p_count => x_msg_count
2180: ,p_data => x_msg_data
2181: );

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

2182:
2183: WHEN OTHERS THEN
2184: ROLLBACK TO Delete_Claim_Line_Tbl;
2185: x_return_status := FND_API.g_ret_sts_unexp_error ;
2186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2187: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2188: END IF;
2189: FND_MSG_PUB.count_and_get(
2190: p_encoded => FND_API.g_false

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

2183: WHEN OTHERS THEN
2184: ROLLBACK TO Delete_Claim_Line_Tbl;
2185: x_return_status := FND_API.g_ret_sts_unexp_error ;
2186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2187: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2188: END IF;
2189: FND_MSG_PUB.count_and_get(
2190: p_encoded => FND_API.g_false
2191: ,p_count => x_msg_count

Line 2189: FND_MSG_PUB.count_and_get(

2185: x_return_status := FND_API.g_ret_sts_unexp_error ;
2186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2187: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2188: END IF;
2189: FND_MSG_PUB.count_and_get(
2190: p_encoded => FND_API.g_false
2191: ,p_count => x_msg_count
2192: ,p_data => x_msg_data
2193: );

Line 2275: FND_MSG_PUB.initialize;

2271: OZF_Utility_PVT.debug_message(l_full_name||': start');
2272: END IF;
2273:
2274: IF FND_API.to_boolean(p_init_msg_list) THEN
2275: FND_MSG_PUB.initialize;
2276: END IF;
2277:
2278: IF NOT FND_API.compatible_api_call(
2279: l_api_version,

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

2305: , X_Msg_Data => x_msg_data
2306: , X_access => l_access);
2307:
2308: IF l_access = 'N' THEN
2309: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2310: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2311: FND_MSG_PUB.add;
2312: END IF;
2313: RAISE FND_API.G_EXC_ERROR;

Line 2311: FND_MSG_PUB.add;

2307:
2308: IF l_access = 'N' THEN
2309: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2310: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2311: FND_MSG_PUB.add;
2312: END IF;
2313: RAISE FND_API.G_EXC_ERROR;
2314: END IF;
2315: END IF;

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

2327:
2328: -- comparison of claim amount and line amount (claim_currency_amount)
2329: --IF l_line_sum_amt IS NOT NULL THEN
2330: --IF ABS(l_line_sum_amt) > ABS(l_claim_amount) THEN
2331: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2332: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
2333: --FND_MSG_PUB.add;
2334: --END IF;
2335: --RAISE FND_API.g_exc_error;

Line 2333: --FND_MSG_PUB.add;

2329: --IF l_line_sum_amt IS NOT NULL THEN
2330: --IF ABS(l_line_sum_amt) > ABS(l_claim_amount) THEN
2331: --IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2332: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
2333: --FND_MSG_PUB.add;
2334: --END IF;
2335: --RAISE FND_API.g_exc_error;
2336: --END IF;
2337: --END IF;

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

2377: WHERE claim_line_id = p_claim_line_id
2378: AND object_version_number = p_object_version;
2379:
2380: IF (SQL%NOTFOUND) THEN
2381: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2382: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2383: FND_MSG_PUB.add;
2384: END IF;
2385: RAISE FND_API.g_exc_error;

Line 2383: FND_MSG_PUB.add;

2379:
2380: IF (SQL%NOTFOUND) THEN
2381: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2382: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2383: FND_MSG_PUB.add;
2384: END IF;
2385: RAISE FND_API.g_exc_error;
2386: END IF;
2387:

Line 2393: FND_MSG_PUB.count_and_get(

2389: IF FND_API.to_boolean(p_commit) THEN
2390: COMMIT;
2391: END IF;
2392:
2393: FND_MSG_PUB.count_and_get(
2394: p_encoded => FND_API.g_false,
2395: p_count => x_msg_count,
2396: p_data => x_msg_data
2397: );

Line 2407: FND_MSG_PUB.count_and_get(

2403: EXCEPTION
2404: WHEN FND_API.g_exc_error THEN
2405: ROLLBACK TO Delete_Claim_Line;
2406: x_return_status := FND_API.g_ret_sts_error;
2407: FND_MSG_PUB.count_and_get(
2408: p_encoded => FND_API.g_false,
2409: p_count => x_msg_count,
2410: p_data => x_msg_data
2411: );

Line 2416: FND_MSG_PUB.count_and_get(

2412:
2413: WHEN FND_API.g_exc_unexpected_error THEN
2414: ROLLBACK TO Delete_Claim_Line;
2415: x_return_status := FND_API.g_ret_sts_unexp_error ;
2416: FND_MSG_PUB.count_and_get(
2417: p_encoded => FND_API.g_false,
2418: p_count => x_msg_count,
2419: p_data => x_msg_data
2420: );

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

2421:
2422: WHEN OTHERS THEN
2423: ROLLBACK TO Delete_Claim_Line;
2424: x_return_status := FND_API.g_ret_sts_unexp_error ;
2425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2426: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2427: END IF;
2428: FND_MSG_PUB.count_and_get(
2429: p_encoded => FND_API.g_false,

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

2422: WHEN OTHERS THEN
2423: ROLLBACK TO Delete_Claim_Line;
2424: x_return_status := FND_API.g_ret_sts_unexp_error ;
2425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2426: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2427: END IF;
2428: FND_MSG_PUB.count_and_get(
2429: p_encoded => FND_API.g_false,
2430: p_count => x_msg_count,

Line 2428: FND_MSG_PUB.count_and_get(

2424: x_return_status := FND_API.g_ret_sts_unexp_error ;
2425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2426: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2427: END IF;
2428: FND_MSG_PUB.count_and_get(
2429: p_encoded => FND_API.g_false,
2430: p_count => x_msg_count,
2431: p_data => x_msg_data
2432: );

Line 2476: FND_MSG_PUB.initialize;

2472: OZF_Utility_PVT.debug_message(l_full_name||': start');
2473: END IF;
2474:
2475: IF FND_API.to_boolean(p_init_msg_list) THEN
2476: FND_MSG_PUB.initialize;
2477: END IF;
2478:
2479: IF NOT FND_API.compatible_api_call(
2480: l_api_version,

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

2495: OPEN c_claim_line;
2496: FETCH c_claim_line INTO l_claim_line_id;
2497: IF (c_claim_line%NOTFOUND) THEN
2498: CLOSE c_claim_line;
2499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2500: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2501: FND_MSG_PUB.add;
2502: END IF;
2503: RAISE FND_API.g_exc_error;

Line 2501: FND_MSG_PUB.add;

2497: IF (c_claim_line%NOTFOUND) THEN
2498: CLOSE c_claim_line;
2499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2500: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
2501: FND_MSG_PUB.add;
2502: END IF;
2503: RAISE FND_API.g_exc_error;
2504: END IF;
2505: CLOSE c_claim_line;

Line 2508: FND_MSG_PUB.count_and_get(

2504: END IF;
2505: CLOSE c_claim_line;
2506:
2507: -------------------- finish --------------------------
2508: FND_MSG_PUB.count_and_get(
2509: p_encoded => FND_API.g_false,
2510: p_count => x_msg_count,
2511: p_data => x_msg_data
2512: );

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

2517:
2518: EXCEPTION
2519: WHEN OZF_Utility_PVT.resource_locked THEN
2520: x_return_status := FND_API.g_ret_sts_error;
2521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2522: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
2523: FND_MSG_PUB.add;
2524: END IF;
2525: FND_MSG_PUB.count_and_get(

Line 2523: FND_MSG_PUB.add;

2519: WHEN OZF_Utility_PVT.resource_locked THEN
2520: x_return_status := FND_API.g_ret_sts_error;
2521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2522: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
2523: FND_MSG_PUB.add;
2524: END IF;
2525: FND_MSG_PUB.count_and_get(
2526: p_encoded => FND_API.g_false,
2527: p_count => x_msg_count,

Line 2525: FND_MSG_PUB.count_and_get(

2521: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2522: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
2523: FND_MSG_PUB.add;
2524: END IF;
2525: FND_MSG_PUB.count_and_get(
2526: p_encoded => FND_API.g_false,
2527: p_count => x_msg_count,
2528: p_data => x_msg_data
2529: );

Line 2533: FND_MSG_PUB.count_and_get(

2529: );
2530:
2531: WHEN FND_API.g_exc_error THEN
2532: x_return_status := FND_API.g_ret_sts_error;
2533: FND_MSG_PUB.count_and_get(
2534: p_encoded => FND_API.g_false,
2535: p_count => x_msg_count,
2536: p_data => x_msg_data
2537: );

Line 2541: FND_MSG_PUB.count_and_get(

2537: );
2538:
2539: WHEN FND_API.g_exc_unexpected_error THEN
2540: x_return_status := FND_API.g_ret_sts_unexp_error ;
2541: FND_MSG_PUB.count_and_get(
2542: p_encoded => FND_API.g_false,
2543: p_count => x_msg_count,
2544: p_data => x_msg_data
2545: );

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

2545: );
2546:
2547: WHEN OTHERS THEN
2548: x_return_status := FND_API.g_ret_sts_unexp_error ;
2549: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2550: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2551: END IF;
2552: FND_MSG_PUB.count_and_get(
2553: p_encoded => FND_API.g_false,

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

2546:
2547: WHEN OTHERS THEN
2548: x_return_status := FND_API.g_ret_sts_unexp_error ;
2549: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2550: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2551: END IF;
2552: FND_MSG_PUB.count_and_get(
2553: p_encoded => FND_API.g_false,
2554: p_count => x_msg_count,

Line 2552: FND_MSG_PUB.count_and_get(

2548: x_return_status := FND_API.g_ret_sts_unexp_error ;
2549: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
2550: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2551: END IF;
2552: FND_MSG_PUB.count_and_get(
2553: p_encoded => FND_API.g_false,
2554: p_count => x_msg_count,
2555: p_data => x_msg_data
2556: );

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

2612:
2613: -------------- Lock items when earnings is associated --------------
2614: IF l_earnings_associated_flag = FND_API.g_true THEN
2615: IF NVL(p_claim_line_rec.source_object_id,FND_API.g_miss_num) <> l_source_object_id THEN
2616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2617: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2618: FND_MESSAGE.set_token('LOCK', 'Name OR Line / Product');
2619: FND_MSG_PUB.add;
2620: END IF;

Line 2619: FND_MSG_PUB.add;

2615: IF NVL(p_claim_line_rec.source_object_id,FND_API.g_miss_num) <> l_source_object_id THEN
2616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2617: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2618: FND_MESSAGE.set_token('LOCK', 'Name OR Line / Product');
2619: FND_MSG_PUB.add;
2620: END IF;
2621: x_return_status := FND_API.g_ret_sts_error;
2622: RETURN;
2623: END IF;

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

2621: x_return_status := FND_API.g_ret_sts_error;
2622: RETURN;
2623: END IF;
2624: IF NVL(p_claim_line_rec.source_object_class,FND_API.g_miss_char) <> l_source_object_class THEN
2625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2626: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2627: FND_MESSAGE.set_token('LOCK', 'Type');
2628: FND_MSG_PUB.add;
2629: END IF;

Line 2628: FND_MSG_PUB.add;

2624: IF NVL(p_claim_line_rec.source_object_class,FND_API.g_miss_char) <> l_source_object_class THEN
2625: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2626: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2627: FND_MESSAGE.set_token('LOCK', 'Type');
2628: FND_MSG_PUB.add;
2629: END IF;
2630: x_return_status := FND_API.g_ret_sts_error;
2631: RETURN;
2632: END IF;

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

2630: x_return_status := FND_API.g_ret_sts_error;
2631: RETURN;
2632: END IF;
2633: IF NVL(p_claim_line_rec.source_object_type_id,FND_API.g_miss_num) <> l_source_object_type_id THEN
2634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2635: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2636: FND_MESSAGE.set_token('LOCK', 'Type');
2637: FND_MSG_PUB.add;
2638: END IF;

Line 2637: FND_MSG_PUB.add;

2633: IF NVL(p_claim_line_rec.source_object_type_id,FND_API.g_miss_num) <> l_source_object_type_id THEN
2634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2635: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2636: FND_MESSAGE.set_token('LOCK', 'Type');
2637: FND_MSG_PUB.add;
2638: END IF;
2639: x_return_status := FND_API.g_ret_sts_error;
2640: RETURN;
2641: END IF;

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

2639: x_return_status := FND_API.g_ret_sts_error;
2640: RETURN;
2641: END IF;
2642: IF NVL(p_claim_line_rec.plan_id,FND_API.g_miss_num) <> l_plan_id THEN
2643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2644: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2645: FND_MESSAGE.set_token('LOCK', 'Type');
2646: FND_MSG_PUB.add;
2647: END IF;

Line 2646: FND_MSG_PUB.add;

2642: IF NVL(p_claim_line_rec.plan_id,FND_API.g_miss_num) <> l_plan_id THEN
2643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2644: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2645: FND_MESSAGE.set_token('LOCK', 'Type');
2646: FND_MSG_PUB.add;
2647: END IF;
2648: x_return_status := FND_API.g_ret_sts_error;
2649: RETURN;
2650: END IF;

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

2648: x_return_status := FND_API.g_ret_sts_error;
2649: RETURN;
2650: END IF;
2651: IF NVL(p_claim_line_rec.item_id,FND_API.g_miss_num) <> l_item_id THEN
2652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2653: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2654: FND_MESSAGE.set_token('LOCK', 'Line / Product');
2655: FND_MSG_PUB.add;
2656: END IF;

Line 2655: FND_MSG_PUB.add;

2651: IF NVL(p_claim_line_rec.item_id,FND_API.g_miss_num) <> l_item_id THEN
2652: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2653: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2654: FND_MESSAGE.set_token('LOCK', 'Line / Product');
2655: FND_MSG_PUB.add;
2656: END IF;
2657: x_return_status := FND_API.g_ret_sts_error;
2658: RETURN;
2659: END IF;

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

2658: RETURN;
2659: END IF;
2660: /*
2661: IF NVL(p_claim_line_rec.item_description,FND_API.g_miss_char) <> l_item_description THEN
2662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2663: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2664: FND_MESSAGE.set_token('LOCK', 'ITEM_DESCRIPTION');
2665: FND_MSG_PUB.add;
2666: END IF;

Line 2665: FND_MSG_PUB.add;

2661: IF NVL(p_claim_line_rec.item_description,FND_API.g_miss_char) <> l_item_description THEN
2662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2663: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2664: FND_MESSAGE.set_token('LOCK', 'ITEM_DESCRIPTION');
2665: FND_MSG_PUB.add;
2666: END IF;
2667: x_return_status := FND_API.g_ret_sts_error;
2668: RETURN;
2669: END IF;

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

2668: RETURN;
2669: END IF;
2670: */
2671: IF NVL(p_claim_line_rec.activity_type,FND_API.g_miss_char) <> l_activity_type THEN
2672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2673: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2674: FND_MESSAGE.set_token('LOCK', 'Name');
2675: FND_MSG_PUB.add;
2676: END IF;

Line 2675: FND_MSG_PUB.add;

2671: IF NVL(p_claim_line_rec.activity_type,FND_API.g_miss_char) <> l_activity_type THEN
2672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2673: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_LOCK');
2674: FND_MESSAGE.set_token('LOCK', 'Name');
2675: FND_MSG_PUB.add;
2676: END IF;
2677: x_return_status := FND_API.g_ret_sts_error;
2678: RETURN;
2679: END IF;

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

2677: x_return_status := FND_API.g_ret_sts_error;
2678: RETURN;
2679: END IF;
2680: IF NVL(p_claim_line_rec.activity_id,FND_API.g_miss_num) <> l_activity_id 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_LOCK');
2683: FND_MESSAGE.set_token('LOCK', 'Name');
2684: FND_MSG_PUB.add;
2685: END IF;

Line 2684: FND_MSG_PUB.add;

2680: IF NVL(p_claim_line_rec.activity_id,FND_API.g_miss_num) <> l_activity_id 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_LOCK');
2683: FND_MESSAGE.set_token('LOCK', 'Name');
2684: FND_MSG_PUB.add;
2685: END IF;
2686: x_return_status := FND_API.g_ret_sts_error;
2687: RETURN;
2688: END IF;

Line 2777: FND_MSG_PUB.initialize;

2773: OZF_Utility_PVT.debug_message(l_full_name||': start');
2774: END IF;
2775:
2776: IF FND_API.to_boolean(p_init_msg_list) THEN
2777: FND_MSG_PUB.initialize;
2778: END IF;
2779:
2780: IF NOT FND_API.compatible_api_call(
2781: l_api_version,

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

2807: , X_Msg_Data => l_msg_data
2808: , X_access => l_access);
2809:
2810: IF l_access = 'N' THEN
2811: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2812: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2813: FND_MSG_PUB.add;
2814: END IF;
2815: RAISE FND_API.G_EXC_ERROR;

Line 2813: FND_MSG_PUB.add;

2809:
2810: IF l_access = 'N' THEN
2811: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2812: FND_MESSAGE.set_name('OZF','OZF_CLAIM_NO_ACCESS');
2813: FND_MSG_PUB.add;
2814: END IF;
2815: RAISE FND_API.G_EXC_ERROR;
2816: END IF;
2817: EXIT;

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

2868: END IF;
2869:
2870: -------- raise error if claim currency amount is null ----------
2871: IF l_claim_line_tbl(j).claim_currency_amount IS NULL THEN
2872: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2873: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
2874: FND_MSG_PUB.add;
2875: END IF;
2876: x_error_index := j;

Line 2874: FND_MSG_PUB.add;

2870: -------- raise error if claim currency amount is null ----------
2871: IF l_claim_line_tbl(j).claim_currency_amount IS NULL THEN
2872: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2873: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
2874: FND_MSG_PUB.add;
2875: END IF;
2876: x_error_index := j;
2877: RAISE FND_API.g_exc_error;
2878: ELSE

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

2902: --Skip the check in case of Subsequent Receipt Application.
2903: IF l_claim_class <> 'GROUP' THEN
2904: IF sign(l_exist_total_amt - l_old_upd_total_amt + l_new_upd_total_amt) <> sign(l_claim_amount)
2905: THEN
2906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2907: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
2908: FND_MSG_PUB.add;
2909: END IF;
2910: RAISE FND_API.g_exc_error;

Line 2908: FND_MSG_PUB.add;

2904: IF sign(l_exist_total_amt - l_old_upd_total_amt + l_new_upd_total_amt) <> sign(l_claim_amount)
2905: THEN
2906: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2907: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
2908: FND_MSG_PUB.add;
2909: END IF;
2910: RAISE FND_API.g_exc_error;
2911: END IF;
2912: END IF;

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

2913: -- Skip this check if the Claim line is updated from Request.
2914: IF p_mode <> OZF_CLAIM_UTILITY_PVT.g_request_mode OR
2915: l_claim_class <> 'GROUP' THEN
2916: IF ABS(l_exist_total_amt - l_old_upd_total_amt + l_new_upd_total_amt) > ABS(l_claim_amount) THEN
2917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2918: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
2919: FND_MSG_PUB.add;
2920: END IF;
2921: RAISE FND_API.g_exc_error;

Line 2919: FND_MSG_PUB.add;

2915: l_claim_class <> 'GROUP' THEN
2916: IF ABS(l_exist_total_amt - l_old_upd_total_amt + l_new_upd_total_amt) > ABS(l_claim_amount) THEN
2917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2918: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
2919: FND_MSG_PUB.add;
2920: END IF;
2921: RAISE FND_API.g_exc_error;
2922: END IF;
2923: END IF;

Line 2968: FND_MSG_PUB.count_and_get(

2964: IF FND_API.to_boolean(p_commit) THEN
2965: COMMIT;
2966: END IF;
2967:
2968: FND_MSG_PUB.count_and_get(
2969: p_encoded => FND_API.g_false,
2970: p_count => x_msg_count,
2971: p_data => x_msg_data
2972: );

Line 2982: FND_MSG_PUB.count_and_get (

2978: EXCEPTION
2979: WHEN FND_API.g_exc_error THEN
2980: ROLLBACK TO Update_Claim_Line_Tbl;
2981: x_return_status := FND_API.g_ret_sts_error;
2982: FND_MSG_PUB.count_and_get (
2983: p_encoded => FND_API.g_false
2984: ,p_count => x_msg_count
2985: ,p_data => x_msg_data
2986: );

Line 2991: FND_MSG_PUB.count_and_get (

2987:
2988: WHEN FND_API.g_exc_unexpected_error THEN
2989: ROLLBACK TO Update_Claim_Line_Tbl;
2990: x_return_status := FND_API.g_ret_sts_unexp_error ;
2991: FND_MSG_PUB.count_and_get (
2992: p_encoded => FND_API.g_false
2993: ,p_count => x_msg_count
2994: ,p_data => x_msg_data
2995: );

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

2996:
2997: WHEN OTHERS THEN
2998: ROLLBACK TO Update_Claim_Line_Tbl;
2999: x_return_status := FND_API.g_ret_sts_unexp_error ;
3000: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3001: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3002: END IF;
3003: FND_MSG_PUB.count_and_get(
3004: p_encoded => FND_API.g_false

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

2997: WHEN OTHERS THEN
2998: ROLLBACK TO Update_Claim_Line_Tbl;
2999: x_return_status := FND_API.g_ret_sts_unexp_error ;
3000: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3001: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3002: END IF;
3003: FND_MSG_PUB.count_and_get(
3004: p_encoded => FND_API.g_false
3005: ,p_count => x_msg_count

Line 3003: FND_MSG_PUB.count_and_get(

2999: x_return_status := FND_API.g_ret_sts_unexp_error ;
3000: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3001: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3002: END IF;
3003: FND_MSG_PUB.count_and_get(
3004: p_encoded => FND_API.g_false
3005: ,p_count => x_msg_count
3006: ,p_data => x_msg_data
3007: );

Line 3145: FND_MSG_PUB.initialize;

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

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

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

Line 3177: FND_MSG_PUB.add;

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

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

3281: END IF;
3282:
3283: -------- raise error if claim currency amount is null ----------
3284: IF l_claim_line_rec.claim_currency_amount IS NULL THEN
3285: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3286: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
3287: FND_MSG_PUB.add;
3288: END IF;
3289: RAISE FND_API.g_exc_error;

Line 3287: FND_MSG_PUB.add;

3283: -------- raise error if claim currency amount is null ----------
3284: IF l_claim_line_rec.claim_currency_amount IS NULL THEN
3285: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3286: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_NULL');
3287: FND_MSG_PUB.add;
3288: END IF;
3289: RAISE FND_API.g_exc_error;
3290: END IF;
3291: END IF;

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

3424: --DATE : 03-jun-2003 [Changed for Sign erro in case of partial application for claim investigation.]
3425: -- IF l_claim_amount <> 0 THEN
3426: -- Sign of claim_currency_amount should be the same as claim amount_remaining
3427: -- IF SIGN(l_claim_line_rec.claim_currency_amount) <> SIGN(l_claim_amount) THEN
3428: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3429: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
3430: -- FND_MSG_PUB.add;
3431: -- END IF;
3432: -- RAISE FND_API.g_exc_error;

Line 3430: -- FND_MSG_PUB.add;

3426: -- Sign of claim_currency_amount should be the same as claim amount_remaining
3427: -- IF SIGN(l_claim_line_rec.claim_currency_amount) <> SIGN(l_claim_amount) THEN
3428: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3429: -- FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_AMT_SIGN_ERR');
3430: -- FND_MSG_PUB.add;
3431: -- END IF;
3432: -- RAISE FND_API.g_exc_error;
3433: -- END IF;
3434: --END IF;

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

3456: THEN --Bug:2781186
3457: -- comparison of claim amount and line amount
3458: IF l_line_sum_amt IS NOT NULL THEN
3459: IF ABS(l_line_sum_amt + l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
3460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3461: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
3462: FND_MSG_PUB.add;
3463: END IF;
3464: RAISE FND_API.g_exc_error;

Line 3462: FND_MSG_PUB.add;

3458: IF l_line_sum_amt IS NOT NULL THEN
3459: IF ABS(l_line_sum_amt + l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
3460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3461: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
3462: FND_MSG_PUB.add;
3463: END IF;
3464: RAISE FND_API.g_exc_error;
3465: END IF;
3466: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN

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

3463: END IF;
3464: RAISE FND_API.g_exc_error;
3465: END IF;
3466: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
3467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3468: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
3469: FND_MSG_PUB.add;
3470: END IF;
3471: RAISE FND_API.g_exc_error;

Line 3469: FND_MSG_PUB.add;

3465: END IF;
3466: ELSIF ABS(l_claim_line_rec.claim_currency_amount) > ABS(l_claim_amount) THEN
3467: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3468: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_EXCESS_AMOUNT');
3469: FND_MSG_PUB.add;
3470: END IF;
3471: RAISE FND_API.g_exc_error;
3472: END IF;
3473: END IF;

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

3511: ELSE
3512: ------- check line acctd amount is more then earnings acctd amount -------
3513:
3514: IF ABS(nvl(l_claim_line_rec.acctd_amount,0)) < ABS(l_line_util_acc_amt) THEN
3515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3516: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_EXCESS_LINE_AMT');
3517: FND_MSG_PUB.add;
3518: END IF;
3519: RAISE FND_API.g_exc_error;

Line 3517: FND_MSG_PUB.add;

3513:
3514: IF ABS(nvl(l_claim_line_rec.acctd_amount,0)) < ABS(l_line_util_acc_amt) THEN
3515: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3516: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_EXCESS_LINE_AMT');
3517: FND_MSG_PUB.add;
3518: END IF;
3519: RAISE FND_API.g_exc_error;
3520: END IF;
3521:

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

3670: WHERE claim_line_id = l_claim_line_rec.claim_line_id
3671: AND object_version_number = l_claim_line_rec.object_version_number;
3672:
3673: IF (SQL%NOTFOUND) THEN
3674: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3675: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3676: FND_MSG_PUB.add;
3677: END IF;
3678: RAISE FND_API.g_exc_error;

Line 3676: FND_MSG_PUB.add;

3672:
3673: IF (SQL%NOTFOUND) THEN
3674: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3675: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
3676: FND_MSG_PUB.add;
3677: END IF;
3678: RAISE FND_API.g_exc_error;
3679: END IF;
3680:

Line 3689: FND_MSG_PUB.count_and_get(

3685: IF FND_API.to_boolean(p_commit) THEN
3686: COMMIT;
3687: END IF;
3688:
3689: FND_MSG_PUB.count_and_get(
3690: p_encoded => FND_API.g_false,
3691: p_count => x_msg_count,
3692: p_data => x_msg_data
3693: );

Line 3703: FND_MSG_PUB.count_and_get(

3699: EXCEPTION
3700: WHEN FND_API.g_exc_error THEN
3701: ROLLBACK TO Update_Claim_Line;
3702: x_return_status := FND_API.g_ret_sts_error;
3703: FND_MSG_PUB.count_and_get(
3704: p_encoded => FND_API.g_false,
3705: p_count => x_msg_count,
3706: p_data => x_msg_data
3707: );

Line 3712: FND_MSG_PUB.count_and_get(

3708:
3709: WHEN FND_API.g_exc_unexpected_error THEN
3710: ROLLBACK TO Update_Claim_Line;
3711: x_return_status := FND_API.g_ret_sts_unexp_error ;
3712: FND_MSG_PUB.count_and_get(
3713: p_encoded => FND_API.g_false,
3714: p_count => x_msg_count,
3715: p_data => x_msg_data
3716: );

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

3717:
3718: WHEN OTHERS THEN
3719: ROLLBACK TO Update_Claim_Line;
3720: x_return_status := FND_API.g_ret_sts_unexp_error ;
3721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3722: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3723: END IF;
3724: FND_MSG_PUB.count_and_get(
3725: p_encoded => FND_API.g_false,

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

3718: WHEN OTHERS THEN
3719: ROLLBACK TO Update_Claim_Line;
3720: x_return_status := FND_API.g_ret_sts_unexp_error ;
3721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3722: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3723: END IF;
3724: FND_MSG_PUB.count_and_get(
3725: p_encoded => FND_API.g_false,
3726: p_count => x_msg_count,

Line 3724: FND_MSG_PUB.count_and_get(

3720: x_return_status := FND_API.g_ret_sts_unexp_error ;
3721: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3722: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3723: END IF;
3724: FND_MSG_PUB.count_and_get(
3725: p_encoded => FND_API.g_false,
3726: p_count => x_msg_count,
3727: p_data => x_msg_data
3728: );

Line 3765: FND_MSG_PUB.initialize;

3761: OZF_Utility_PVT.debug_message(l_full_name||': start');
3762: END IF;
3763:
3764: IF FND_API.to_boolean(p_init_msg_list) THEN
3765: FND_MSG_PUB.initialize;
3766: END IF;
3767:
3768: IF NOT FND_API.compatible_api_call(
3769: l_api_version,

Line 3817: FND_MSG_PUB.count_and_get(

3813: END IF;
3814: END IF;
3815:
3816: -------------------- finish --------------------------
3817: FND_MSG_PUB.count_and_get(
3818: p_encoded => FND_API.g_false,
3819: p_count => x_msg_count,
3820: p_data => x_msg_data
3821: );

Line 3830: FND_MSG_PUB.count_and_get(

3826:
3827: EXCEPTION
3828: WHEN FND_API.g_exc_error THEN
3829: x_return_status := FND_API.g_ret_sts_error;
3830: FND_MSG_PUB.count_and_get(
3831: p_encoded => FND_API.g_false,
3832: p_count => x_msg_count,
3833: p_data => x_msg_data
3834: );

Line 3838: FND_MSG_PUB.count_and_get(

3834: );
3835:
3836: WHEN FND_API.g_exc_unexpected_error THEN
3837: x_return_status := FND_API.g_ret_sts_unexp_error ;
3838: FND_MSG_PUB.count_and_get(
3839: p_encoded => FND_API.g_false,
3840: p_count => x_msg_count,
3841: p_data => x_msg_data
3842: );

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

3842: );
3843:
3844: WHEN OTHERS THEN
3845: x_return_status := FND_API.g_ret_sts_unexp_error;
3846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3847: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3848: END IF;
3849: FND_MSG_PUB.count_and_get(
3850: p_encoded => FND_API.g_false,

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

3843:
3844: WHEN OTHERS THEN
3845: x_return_status := FND_API.g_ret_sts_unexp_error;
3846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3847: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3848: END IF;
3849: FND_MSG_PUB.count_and_get(
3850: p_encoded => FND_API.g_false,
3851: p_count => x_msg_count,

Line 3849: FND_MSG_PUB.count_and_get(

3845: x_return_status := FND_API.g_ret_sts_unexp_error;
3846: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3847: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3848: END IF;
3849: FND_MSG_PUB.count_and_get(
3850: p_encoded => FND_API.g_false,
3851: p_count => x_msg_count,
3852: p_data => x_msg_data
3853: );

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

3873:
3874: ------------------------ CLAIM_ID -------------------------------
3875: IF p_claim_line_rec.claim_id <> FND_API.g_miss_num AND
3876: p_claim_line_rec.claim_id IS NULL THEN
3877: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3878: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
3879: FND_MESSAGE.set_token('COLUMN', 'CLAIM_ID');
3880: FND_MSG_PUB.add;
3881: END IF;

Line 3880: FND_MSG_PUB.add;

3876: p_claim_line_rec.claim_id IS NULL THEN
3877: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3878: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
3879: FND_MESSAGE.set_token('COLUMN', 'CLAIM_ID');
3880: FND_MSG_PUB.add;
3881: END IF;
3882:
3883: x_return_status := FND_API.g_ret_sts_error;
3884: RETURN;

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

3884: RETURN;
3885: ------------------------ LINE_NUMBER -------------------------------
3886: ELSIF p_claim_line_rec.line_number <> FND_API.g_miss_num AND
3887: p_claim_line_rec.line_number IS NULL THEN
3888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3889: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
3890: FND_MESSAGE.set_token('COLUMN', 'LINE_NUMBER');
3891: FND_MSG_PUB.add;
3892: END IF;

Line 3891: FND_MSG_PUB.add;

3887: p_claim_line_rec.line_number IS NULL THEN
3888: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3889: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
3890: FND_MESSAGE.set_token('COLUMN', 'LINE_NUMBER');
3891: FND_MSG_PUB.add;
3892: END IF;
3893:
3894: x_return_status := FND_API.g_ret_sts_error;
3895: RETURN;

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

3895: RETURN;
3896: ------------------------ SET_OF_BOOKS_ID -------------------------------
3897: ELSIF p_claim_line_rec.set_of_books_id <> FND_API.g_miss_num AND
3898: p_claim_line_rec.set_of_books_id IS NULL THEN
3899: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3900: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
3901: FND_MESSAGE.set_token('COLUMN', 'SET_OF_BOOKS_ID');
3902: FND_MSG_PUB.add;
3903: END IF;

Line 3902: FND_MSG_PUB.add;

3898: p_claim_line_rec.set_of_books_id IS NULL THEN
3899: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3900: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_MISSING_COLUMN');
3901: FND_MESSAGE.set_token('COLUMN', 'SET_OF_BOOKS_ID');
3902: FND_MSG_PUB.add;
3903: END IF;
3904:
3905: x_return_status := FND_API.g_ret_sts_error;
3906: RETURN;

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

3934: IF OZF_Utility_PVT.check_uniqueness(
3935: 'ozf_claim_lines',
3936: 'claim_line_id = ' || p_claim_line_rec.claim_line_id
3937: ) = FND_API.g_false THEN
3938: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3939: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DUPLICATE_VALUE');
3940: FND_MESSAGE.set_token('COLLUMN', 'CLAIM_LINE_ID');
3941: FND_MSG_PUB.add;
3942: END IF;

Line 3941: FND_MSG_PUB.add;

3937: ) = FND_API.g_false THEN
3938: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3939: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_DUPLICATE_VALUE');
3940: FND_MESSAGE.set_token('COLLUMN', 'CLAIM_LINE_ID');
3941: FND_MSG_PUB.add;
3942: END IF;
3943: x_return_status := FND_API.g_ret_sts_error;
3944: RETURN;
3945: END IF;

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

4011: IF p_claim_line_rec.valid_flag <> FND_API.g_miss_char AND
4012: p_claim_line_rec.valid_flag IS NOT NULL THEN
4013: IF p_claim_line_rec.valid_flag <> FND_API.g_true AND
4014: p_claim_line_rec.valid_flag <> FND_API.g_false THEN
4015: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4016: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4017: FND_MESSAGE.set_token('FLAG', 'VALID_FLAG');
4018: FND_MSG_PUB.add;
4019: END IF;

Line 4018: FND_MSG_PUB.add;

4014: p_claim_line_rec.valid_flag <> FND_API.g_false THEN
4015: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4016: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4017: FND_MESSAGE.set_token('FLAG', 'VALID_FLAG');
4018: FND_MSG_PUB.add;
4019: END IF;
4020: x_return_status := FND_API.g_ret_sts_error;
4021: RETURN;
4022: END IF;

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

4026: IF p_claim_line_rec.approved_flag <> FND_API.g_miss_char AND
4027: p_claim_line_rec.approved_flag IS NOT NULL THEN
4028: IF p_claim_line_rec.approved_flag <> FND_API.g_true AND
4029: p_claim_line_rec.approved_flag <> FND_API.g_false THEN
4030: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4031: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4032: FND_MESSAGE.set_token('FLAG', 'APPROVED_FLAG');
4033: FND_MSG_PUB.add;
4034: END IF;

Line 4033: FND_MSG_PUB.add;

4029: p_claim_line_rec.approved_flag <> FND_API.g_false THEN
4030: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4031: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4032: FND_MESSAGE.set_token('FLAG', 'APPROVED_FLAG');
4033: FND_MSG_PUB.add;
4034: END IF;
4035: x_return_status := FND_API.g_ret_sts_error;
4036: RETURN;
4037: END IF;

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

4041: IF p_claim_line_rec.performance_complete_flag <> FND_API.g_miss_char AND
4042: p_claim_line_rec.performance_complete_flag IS NOT NULL THEN
4043: IF p_claim_line_rec.performance_complete_flag <> FND_API.g_true AND
4044: p_claim_line_rec.performance_complete_flag <> FND_API.g_false THEN
4045: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4046: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4047: FND_MESSAGE.set_token('FLAG', 'PERFORMANCE_COMPLETE_FLAG');
4048: FND_MSG_PUB.add;
4049: END IF;

Line 4048: FND_MSG_PUB.add;

4044: p_claim_line_rec.performance_complete_flag <> FND_API.g_false THEN
4045: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4046: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4047: FND_MESSAGE.set_token('FLAG', 'PERFORMANCE_COMPLETE_FLAG');
4048: FND_MSG_PUB.add;
4049: END IF;
4050: x_return_status := FND_API.g_ret_sts_error;
4051: RETURN;
4052: END IF;

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

4056: IF p_claim_line_rec.performance_attached_flag <> FND_API.g_miss_char AND
4057: p_claim_line_rec.performance_attached_flag IS NOT NULL THEN
4058: IF p_claim_line_rec.performance_attached_flag <> FND_API.g_true AND
4059: p_claim_line_rec.performance_attached_flag <> FND_API.g_false THEN
4060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4061: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4062: FND_MESSAGE.set_token('FLAG', 'PERFORMANCE_ATTACHED_FLAG');
4063: FND_MSG_PUB.add;
4064: END IF;

Line 4063: FND_MSG_PUB.add;

4059: p_claim_line_rec.performance_attached_flag <> FND_API.g_false THEN
4060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4061: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4062: FND_MESSAGE.set_token('FLAG', 'PERFORMANCE_ATTACHED_FLAG');
4063: FND_MSG_PUB.add;
4064: END IF;
4065: x_return_status := FND_API.g_ret_sts_error;
4066: RETURN;
4067: END IF;

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

4071: IF p_claim_line_rec.earnings_associated_flag <> FND_API.g_miss_char AND
4072: p_claim_line_rec.earnings_associated_flag IS NOT NULL THEN
4073: IF p_claim_line_rec.earnings_associated_flag <> FND_API.g_true AND
4074: p_claim_line_rec.earnings_associated_flag <> FND_API.g_false THEN
4075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4076: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4077: FND_MESSAGE.set_token('FLAG', 'EARNINGS_ASSOCIATED_FLAG');
4078: FND_MSG_PUB.add;
4079: END IF;

Line 4078: FND_MSG_PUB.add;

4074: p_claim_line_rec.earnings_associated_flag <> FND_API.g_false THEN
4075: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4076: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_BAD_FLAG');
4077: FND_MESSAGE.set_token('FLAG', 'EARNINGS_ASSOCIATED_FLAG');
4078: FND_MSG_PUB.add;
4079: END IF;
4080: x_return_status := FND_API.g_ret_sts_error;
4081: RETURN;
4082: END IF;

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

4209: FETCH csr_ap_tax_code INTO l_tax_code;
4210: CLOSE csr_ap_tax_code;
4211:
4212: IF l_tax_code IS NULL THEN
4213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4214: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4215: FND_MSG_PUB.add;
4216: END IF;
4217: x_return_status := FND_API.g_ret_sts_error;

Line 4215: FND_MSG_PUB.add;

4211:
4212: IF l_tax_code IS NULL THEN
4213: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4214: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4215: FND_MSG_PUB.add;
4216: END IF;
4217: x_return_status := FND_API.g_ret_sts_error;
4218: RETURN;
4219: END IF;

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

4222: FETCH csr_ar_tax_code INTO l_tax_code;
4223: CLOSE csr_ar_tax_code;
4224:
4225: IF l_tax_code IS NULL THEN
4226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4227: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4228: FND_MSG_PUB.add;
4229: END IF;
4230: x_return_status := FND_API.g_ret_sts_error;

Line 4228: FND_MSG_PUB.add;

4224:
4225: IF l_tax_code IS NULL THEN
4226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4227: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4228: FND_MSG_PUB.add;
4229: END IF;
4230: x_return_status := FND_API.g_ret_sts_error;
4231: RETURN;
4232: END IF;

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

4230: x_return_status := FND_API.g_ret_sts_error;
4231: RETURN;
4232: END IF;
4233: ELSIF l_tax_for IS NULL THEN
4234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4235: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4236: FND_MSG_PUB.add;
4237: END IF;
4238: x_return_status := FND_API.g_ret_sts_error;

Line 4236: FND_MSG_PUB.add;

4232: END IF;
4233: ELSIF l_tax_for IS NULL THEN
4234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4235: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_LINE_TAX_CODE_ERR');
4236: FND_MSG_PUB.add;
4237: END IF;
4238: x_return_status := FND_API.g_ret_sts_error;
4239: RETURN;
4240: END IF;

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

4248: FETCH csr_customer_trx_id INTO l_source_object_id;
4249: CLOSE csr_customer_trx_id;
4250:
4251: IF l_source_object_id <> p_complete_rec.source_object_id THEN
4252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4253: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVLINE_NOT_IN_INV');
4254: FND_MSG_PUB.add;
4255: END IF;
4256: x_return_status := FND_API.g_ret_sts_error;

Line 4254: FND_MSG_PUB.add;

4250:
4251: IF l_source_object_id <> p_complete_rec.source_object_id THEN
4252: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4253: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_INVLINE_NOT_IN_INV');
4254: FND_MSG_PUB.add;
4255: END IF;
4256: x_return_status := FND_API.g_ret_sts_error;
4257: RETURN;
4258: END IF;

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

4381: OPEN c_claim_line(p_claim_line_rec.claim_line_id);
4382: FETCH c_claim_line INTO l_claim_line_rec;
4383: IF c_claim_line%NOTFOUND THEN
4384: CLOSE c_claim_line;
4385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4386: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
4387: FND_MSG_PUB.add;
4388: END IF;
4389: RAISE FND_API.g_exc_error;

Line 4387: FND_MSG_PUB.add;

4383: IF c_claim_line%NOTFOUND THEN
4384: CLOSE c_claim_line;
4385: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
4386: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
4387: FND_MSG_PUB.add;
4388: END IF;
4389: RAISE FND_API.g_exc_error;
4390: END IF;
4391: CLOSE c_claim_line;

Line 5143: FND_MSG_PUB.initialize;

5139: OZF_Utility_PVT.debug_message(l_full_name||': start');
5140: END IF;
5141:
5142: IF FND_API.to_boolean(p_init_msg_list) THEN
5143: FND_MSG_PUB.initialize;
5144: END IF;
5145:
5146: IF NOT FND_API.compatible_api_call(
5147: l_api_version,

Line 5389: FND_MSG_PUB.count_and_get(

5385: IF FND_API.to_boolean(p_commit) THEN
5386: COMMIT;
5387: END IF;
5388:
5389: FND_MSG_PUB.count_and_get(
5390: p_encoded => FND_API.g_false,
5391: p_count => x_msg_count,
5392: p_data => x_msg_data
5393: );

Line 5403: FND_MSG_PUB.count_and_get(

5399: EXCEPTION
5400: WHEN FND_API.g_exc_error THEN
5401: ROLLBACK TO split_claim_line;
5402: x_return_status := FND_API.g_ret_sts_error;
5403: FND_MSG_PUB.count_and_get(
5404: p_encoded => FND_API.g_false,
5405: p_count => x_msg_count,
5406: p_data => x_msg_data
5407: );

Line 5412: FND_MSG_PUB.count_and_get(

5408:
5409: WHEN FND_API.g_exc_unexpected_error THEN
5410: ROLLBACK TO split_claim_line;
5411: x_return_status := FND_API.g_ret_sts_unexp_error ;
5412: FND_MSG_PUB.count_and_get(
5413: p_encoded => FND_API.g_false,
5414: p_count => x_msg_count,
5415: p_data => x_msg_data
5416: );

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

5417:
5418: WHEN OTHERS THEN
5419: ROLLBACK TO split_claim_line;
5420: x_return_status := FND_API.g_ret_sts_unexp_error ;
5421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5422: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5423: END IF;
5424: FND_MSG_PUB.count_and_get(
5425: p_encoded => FND_API.g_false,

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

5418: WHEN OTHERS THEN
5419: ROLLBACK TO split_claim_line;
5420: x_return_status := FND_API.g_ret_sts_unexp_error ;
5421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5422: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5423: END IF;
5424: FND_MSG_PUB.count_and_get(
5425: p_encoded => FND_API.g_false,
5426: p_count => x_msg_count,

Line 5424: FND_MSG_PUB.count_and_get(

5420: x_return_status := FND_API.g_ret_sts_unexp_error ;
5421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
5422: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5423: END IF;
5424: FND_MSG_PUB.count_and_get(
5425: p_encoded => FND_API.g_false,
5426: p_count => x_msg_count,
5427: p_data => x_msg_data
5428: );