DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on FND_MSG_PUB

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

8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozfvaris.pls';
9: G_OBJECT_TYPE CONSTANT VARCHAR2(10) := 'OZF_????';
10: G_OWNER_OBJECT CONSTANT VARCHAR2(30) := 'RS_EMPLOYEE';
11:
12: OZF_DEBUG_LOW_ON BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
13:
14: --------------------------------------
15:
16:

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

284:
285: x_return_status := FND_API.g_ret_sts_success;
286: EXCEPTION
287: WHEN OTHERS THEN
288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
289: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
290: FND_MSG_PUB.add;
291: END IF;
292: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 290: FND_MSG_PUB.add;

286: EXCEPTION
287: WHEN OTHERS THEN
288: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
289: FND_MESSAGE.set_name('OZF', 'OZF_CLAIM_QUERY_ERROR');
290: FND_MSG_PUB.add;
291: END IF;
292: x_return_status := FND_API.g_ret_sts_unexp_error;
293: END Query_Claim;
294:

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

525: x_return_status := FND_API.g_ret_sts_success;
526:
527: EXCEPTION
528: WHEN OTHERS THEN
529: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
530: FND_MESSAGE.set_name('OZF', 'OZF_AR_DISTRIBUTE_ERROR');
531: FND_MSG_PUB.add;
532: END IF;
533: IF OZF_DEBUG_LOW_ON THEN

Line 531: FND_MSG_PUB.add;

527: EXCEPTION
528: WHEN OTHERS THEN
529: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
530: FND_MESSAGE.set_name('OZF', 'OZF_AR_DISTRIBUTE_ERROR');
531: FND_MSG_PUB.add;
532: END IF;
533: IF OZF_DEBUG_LOW_ON THEN
534: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
535: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 536: FND_MSG_PUB.Add;

532: END IF;
533: IF OZF_DEBUG_LOW_ON THEN
534: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
535: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
536: FND_MSG_PUB.Add;
537: END IF;
538: x_return_status := FND_API.g_ret_sts_unexp_error;
539: END Insert_Int_Distributions ;
540:

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

733:
734: x_return_status := FND_API.g_ret_sts_success;
735: EXCEPTION
736: WHEN OTHERS THEN
737: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
738: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
739: FND_MSG_PUB.add;
740: END IF;
741: IF OZF_DEBUG_LOW_ON THEN

Line 739: FND_MSG_PUB.add;

735: EXCEPTION
736: WHEN OTHERS THEN
737: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
738: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
739: FND_MSG_PUB.add;
740: END IF;
741: IF OZF_DEBUG_LOW_ON THEN
742: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
743: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 744: FND_MSG_PUB.Add;

740: END IF;
741: IF OZF_DEBUG_LOW_ON THEN
742: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
743: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
744: FND_MSG_PUB.Add;
745: END IF;
746: x_return_status := FND_API.g_ret_sts_unexp_error;
747: END Insert_Interface_Line ;
748:

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

858:
859: x_return_status := FND_API.g_ret_sts_success;
860: EXCEPTION
861: WHEN OTHERS THEN
862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
863: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
864: FND_MSG_PUB.add;
865: END IF;
866: IF OZF_DEBUG_LOW_ON THEN

Line 864: FND_MSG_PUB.add;

860: EXCEPTION
861: WHEN OTHERS THEN
862: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
863: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
864: FND_MSG_PUB.add;
865: END IF;
866: IF OZF_DEBUG_LOW_ON THEN
867: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
868: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 869: FND_MSG_PUB.Add;

865: END IF;
866: IF OZF_DEBUG_LOW_ON THEN
867: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
868: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
869: FND_MSG_PUB.Add;
870: END IF;
871: x_return_status := FND_API.g_ret_sts_unexp_error;
872: END Insert_Interface_Tax;
873:

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

967:
968: x_return_status := FND_API.g_ret_sts_success;
969: EXCEPTION
970: WHEN OTHERS THEN
971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
972: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
973: FND_MSG_PUB.add;
974: END IF;
975: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

Line 973: FND_MSG_PUB.add;

969: EXCEPTION
970: WHEN OTHERS THEN
971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
972: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
973: FND_MSG_PUB.add;
974: END IF;
975: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
976: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
977: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 975: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN

971: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
972: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
973: FND_MSG_PUB.add;
974: END IF;
975: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
976: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
977: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
978: FND_MSG_PUB.Add;
979: END IF;

Line 978: FND_MSG_PUB.Add;

974: END IF;
975: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
976: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
977: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
978: FND_MSG_PUB.Add;
979: END IF;
980: x_return_status := FND_API.g_ret_sts_unexp_error;
981: END Insert_Interface_Sales_Credits;
982:

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

1193: l_cm_trx_type_id ;
1194: CLOSE sys_param_csr;
1195:
1196: IF (l_batch_source_id IS NULL) THEN
1197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1198: FND_MESSAGE.set_name('OZF','OZF_BATCH_SRC_REQ_FOR_INTF');
1199: FND_MSG_PUB.add;
1200: END IF;
1201: x_return_status := FND_API.g_ret_sts_error;

Line 1199: FND_MSG_PUB.add;

1195:
1196: IF (l_batch_source_id IS NULL) THEN
1197: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1198: FND_MESSAGE.set_name('OZF','OZF_BATCH_SRC_REQ_FOR_INTF');
1199: FND_MSG_PUB.add;
1200: END IF;
1201: x_return_status := FND_API.g_ret_sts_error;
1202: ELSE
1203: OPEN batch_source_csr(l_batch_source_id) ;

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

1351: -- Check for Payment Method First
1352: IF ( p_claim_rec.payment_method IS NULL OR
1353: p_claim_rec.payment_method = FND_API.G_MISS_CHAR )
1354: THEN
1355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1356: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_PAYMENT_METHOD');
1357: FND_MSG_PUB.add;
1358: END IF;
1359: ELSIF p_claim_rec.payment_method IS NOT NULL THEN

Line 1357: FND_MSG_PUB.add;

1353: p_claim_rec.payment_method = FND_API.G_MISS_CHAR )
1354: THEN
1355: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1356: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_PAYMENT_METHOD');
1357: FND_MSG_PUB.add;
1358: END IF;
1359: ELSIF p_claim_rec.payment_method IS NOT NULL THEN
1360: -- Now get Trx_type from the claim type
1361: OPEN claim_type_csr(p_claim_rec.claim_type_id) ;

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

1407: CLOSE csr_trx_type_payment_term;
1408: END IF;
1409:
1410: IF p_x_interface_line_rec.TERM_ID IS NULL THEN
1411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1412: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_PAYMENT_TERM');
1413: FND_MSG_PUB.add;
1414: END IF;
1415: x_return_status := FND_API.g_ret_sts_error;

Line 1413: FND_MSG_PUB.add;

1409:
1410: IF p_x_interface_line_rec.TERM_ID IS NULL THEN
1411: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1412: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_PAYMENT_TERM');
1413: FND_MSG_PUB.add;
1414: END IF;
1415: x_return_status := FND_API.g_ret_sts_error;
1416: END IF;
1417:

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

1423:
1424: p_x_interface_line_rec.AMOUNT := p_line_claim_curr_amt;
1425:
1426: ELSE
1427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1428: FND_MESSAGE.set_name('OZF', 'OZF_SETL_INT_ERR_PAYMETHOD');
1429: FND_MSG_PUB.add;
1430: END IF;
1431: x_return_status := FND_API.g_ret_sts_error;

Line 1429: FND_MSG_PUB.add;

1425:
1426: ELSE
1427: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1428: FND_MESSAGE.set_name('OZF', 'OZF_SETL_INT_ERR_PAYMETHOD');
1429: FND_MSG_PUB.add;
1430: END IF;
1431: x_return_status := FND_API.g_ret_sts_error;
1432: END IF;
1433:

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

1439: -- from the sys_param_csr above
1440: IF ( p_claim_rec.payment_method IN ('CHARGEBACK','DEBIT_MEMO') )
1441: THEN
1442: IF l_billback_trx_type_id IS NULL THEN
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_BILLBACK_TRX_TYPE');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: x_return_status := FND_API.g_ret_sts_error;

Line 1445: FND_MSG_PUB.add;

1441: THEN
1442: IF l_billback_trx_type_id IS NULL THEN
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1444: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_BILLBACK_TRX_TYPE');
1445: FND_MSG_PUB.add;
1446: END IF;
1447: x_return_status := FND_API.g_ret_sts_error;
1448: ELSE
1449: p_x_interface_line_rec.cust_trx_type_id :=l_billback_trx_type_id;

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

1449: p_x_interface_line_rec.cust_trx_type_id :=l_billback_trx_type_id;
1450: END IF;
1451: ELSIF p_claim_rec.payment_method = 'CREDIT_MEMO' THEN
1452: IF l_cm_trx_type_id IS NULL THEN
1453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1454: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_CM_TRX_TYPE');
1455: FND_MSG_PUB.add;
1456: END IF;
1457: x_return_status := FND_API.g_ret_sts_error;

Line 1455: FND_MSG_PUB.add;

1451: ELSIF p_claim_rec.payment_method = 'CREDIT_MEMO' THEN
1452: IF l_cm_trx_type_id IS NULL THEN
1453: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1454: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_CM_TRX_TYPE');
1455: FND_MSG_PUB.add;
1456: END IF;
1457: x_return_status := FND_API.g_ret_sts_error;
1458: ELSE
1459: p_x_interface_line_rec.cust_trx_type_id := l_cm_trx_type_id;

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

1592: IF csr_claim_line_product%ISOPEN THEN
1593: CLOSE csr_claim_line_product ;
1594: END IF;
1595:
1596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1597: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1598: FND_MSG_PUB.add;
1599: END IF;
1600: IF OZF_DEBUG_LOW_ON THEN

Line 1598: FND_MSG_PUB.add;

1594: END IF;
1595:
1596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1597: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1598: FND_MSG_PUB.add;
1599: END IF;
1600: IF OZF_DEBUG_LOW_ON THEN
1601: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1602: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 1603: FND_MSG_PUB.Add;

1599: END IF;
1600: IF OZF_DEBUG_LOW_ON THEN
1601: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1602: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1603: FND_MSG_PUB.Add;
1604: END IF;
1605: x_return_status := FND_API.g_ret_sts_unexp_error;
1606: END Populate_Interface_Line_Rec;
1607:

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

1693: */
1694:
1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1698: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1699: FND_MSG_PUB.add;
1700: END IF;
1701: IF OZF_DEBUG_LOW_ON THEN

Line 1699: FND_MSG_PUB.add;

1695: EXCEPTION
1696: WHEN OTHERS THEN
1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1698: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1699: FND_MSG_PUB.add;
1700: END IF;
1701: IF OZF_DEBUG_LOW_ON THEN
1702: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1703: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 1704: FND_MSG_PUB.Add;

1700: END IF;
1701: IF OZF_DEBUG_LOW_ON THEN
1702: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1703: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1704: FND_MSG_PUB.Add;
1705: END IF;
1706: x_return_status := FND_API.g_ret_sts_unexp_error;
1707: END Populate_Interface_Tax_Rec;
1708:

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

1797: /* ------------------------------------------------------------- */
1798:
1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1802: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_DIST_ERROR');
1803: FND_MSG_PUB.add;
1804: END IF;
1805: IF OZF_DEBUG_LOW_ON THEN

Line 1803: FND_MSG_PUB.add;

1799: EXCEPTION
1800: WHEN OTHERS THEN
1801: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1802: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_DIST_ERROR');
1803: FND_MSG_PUB.add;
1804: END IF;
1805: IF OZF_DEBUG_LOW_ON THEN
1806: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1807: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 1808: FND_MSG_PUB.Add;

1804: END IF;
1805: IF OZF_DEBUG_LOW_ON THEN
1806: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1807: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1808: FND_MSG_PUB.Add;
1809: END IF;
1810: x_return_status := FND_API.g_ret_sts_unexp_error;
1811: END Populate_Distributions_Rec;
1812:

Line 2074: FND_MSG_PUB.Add;

2070: -- Debug Message
2071: IF OZF_DEBUG_LOW_ON THEN
2072: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2073: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2074: FND_MSG_PUB.Add;
2075: END IF;
2076: --Initialize message list if p_init_msg_list is TRUE.
2077: IF FND_API.To_Boolean (p_init_msg_list) THEN
2078: FND_MSG_PUB.initialize;

Line 2078: FND_MSG_PUB.initialize;

2074: FND_MSG_PUB.Add;
2075: END IF;
2076: --Initialize message list if p_init_msg_list is TRUE.
2077: IF FND_API.To_Boolean (p_init_msg_list) THEN
2078: FND_MSG_PUB.initialize;
2079: END IF;
2080: -- Initialize API return status to sucess
2081: x_return_status := FND_API.G_RET_STS_SUCCESS;
2082:

Line 2180: FND_MSG_PUB.Add;

2176: -- Debug Message
2177: IF OZF_DEBUG_LOW_ON THEN
2178: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2179: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2180: FND_MSG_PUB.Add;
2181: END IF;
2182: --Standard call to get message count and if count=1, get the message
2183: FND_MSG_PUB.Count_And_Get (
2184: p_encoded => FND_API.G_FALSE,

Line 2183: FND_MSG_PUB.Count_And_Get (

2179: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2180: FND_MSG_PUB.Add;
2181: END IF;
2182: --Standard call to get message count and if count=1, get the message
2183: FND_MSG_PUB.Count_And_Get (
2184: p_encoded => FND_API.G_FALSE,
2185: p_count => x_msg_count,
2186: p_data => x_msg_data
2187: );

Line 2198: FND_MSG_PUB.Count_And_Get (

2194: END IF;
2195: ROLLBACK TO Interface_Claim_PVT;
2196: x_return_status := FND_API.G_RET_STS_ERROR;
2197: -- Standard call to get message count and if count=1, get the message
2198: FND_MSG_PUB.Count_And_Get (
2199: p_encoded => FND_API.G_FALSE,
2200: p_count => x_msg_count,
2201: p_data => x_msg_data
2202: );

Line 2210: FND_MSG_PUB.Count_And_Get (

2206: END IF;
2207: ROLLBACK TO Interface_Claim_PVT;
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2209: -- Standard call to get message count and if count=1, get the message
2210: FND_MSG_PUB.Count_And_Get (
2211: p_encoded => FND_API.G_FALSE,
2212: p_count => x_msg_count,
2213: p_data => x_msg_data
2214: );

Line 2221: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2217: CLOSE claim_line_csr;
2218: END IF;
2219: ROLLBACK TO Interface_Claim_PVT;
2220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2221: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2222: THEN
2223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2224: END IF;
2225: -- Standard call to get message count and if count=1, get the message

Line 2223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2219: ROLLBACK TO Interface_Claim_PVT;
2220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2221: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2222: THEN
2223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2224: END IF;
2225: -- Standard call to get message count and if count=1, get the message
2226: FND_MSG_PUB.Count_And_Get (
2227: p_encoded => FND_API.G_FALSE,

Line 2226: FND_MSG_PUB.Count_And_Get (

2222: THEN
2223: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2224: END IF;
2225: -- Standard call to get message count and if count=1, get the message
2226: FND_MSG_PUB.Count_And_Get (
2227: p_encoded => FND_API.G_FALSE,
2228: p_count => x_msg_count,
2229: p_data => x_msg_data
2230: );