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 733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

729:
730: x_return_status := FND_API.g_ret_sts_success;
731: EXCEPTION
732: WHEN OTHERS THEN
733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
734: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
735: FND_MSG_PUB.add;
736: END IF;
737: IF OZF_DEBUG_LOW_ON THEN

Line 735: FND_MSG_PUB.add;

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

Line 740: FND_MSG_PUB.Add;

736: END IF;
737: IF OZF_DEBUG_LOW_ON THEN
738: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
739: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
740: FND_MSG_PUB.Add;
741: END IF;
742: x_return_status := FND_API.g_ret_sts_unexp_error;
743: END Insert_Interface_Line ;
744:

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

854:
855: x_return_status := FND_API.g_ret_sts_success;
856: EXCEPTION
857: WHEN OTHERS THEN
858: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
859: FND_MESSAGE.set_name('OZF', 'OZF_AR_INTERFACE_ERROR');
860: FND_MSG_PUB.add;
861: END IF;
862: IF OZF_DEBUG_LOW_ON THEN

Line 860: FND_MSG_PUB.add;

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

Line 865: FND_MSG_PUB.Add;

861: END IF;
862: IF OZF_DEBUG_LOW_ON THEN
863: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
864: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
865: FND_MSG_PUB.Add;
866: END IF;
867: x_return_status := FND_API.g_ret_sts_unexp_error;
868: END Insert_Interface_Tax;
869:

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

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

Line 969: FND_MSG_PUB.add;

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

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

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

Line 974: FND_MSG_PUB.Add;

970: END IF;
971: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
972: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
973: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
974: FND_MSG_PUB.Add;
975: END IF;
976: x_return_status := FND_API.g_ret_sts_unexp_error;
977: END Insert_Interface_Sales_Credits;
978:

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

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

Line 1195: FND_MSG_PUB.add;

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

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

1345: -- Check for Payment Method First
1346: IF ( p_claim_rec.payment_method IS NULL OR
1347: p_claim_rec.payment_method = FND_API.G_MISS_CHAR )
1348: THEN
1349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1350: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_PAYMENT_METHOD');
1351: FND_MSG_PUB.add;
1352: END IF;
1353: ELSIF p_claim_rec.payment_method IS NOT NULL THEN

Line 1351: FND_MSG_PUB.add;

1347: p_claim_rec.payment_method = FND_API.G_MISS_CHAR )
1348: THEN
1349: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1350: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_PAYMENT_METHOD');
1351: FND_MSG_PUB.add;
1352: END IF;
1353: ELSIF p_claim_rec.payment_method IS NOT NULL THEN
1354: -- Now get Trx_type from the claim type
1355: OPEN claim_type_csr(p_claim_rec.claim_type_id) ;

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

1401: CLOSE csr_trx_type_payment_term;
1402: END IF;
1403:
1404: IF p_x_interface_line_rec.TERM_ID 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_MISSING_PAYMENT_TERM');
1407: FND_MSG_PUB.add;
1408: END IF;
1409: x_return_status := FND_API.g_ret_sts_error;

Line 1407: FND_MSG_PUB.add;

1403:
1404: IF p_x_interface_line_rec.TERM_ID 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_MISSING_PAYMENT_TERM');
1407: FND_MSG_PUB.add;
1408: END IF;
1409: x_return_status := FND_API.g_ret_sts_error;
1410: END IF;
1411:

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

1417:
1418: p_x_interface_line_rec.AMOUNT := p_line_claim_curr_amt;
1419:
1420: ELSE
1421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1422: FND_MESSAGE.set_name('OZF', 'OZF_SETL_INT_ERR_PAYMETHOD');
1423: FND_MSG_PUB.add;
1424: END IF;
1425: x_return_status := FND_API.g_ret_sts_error;

Line 1423: FND_MSG_PUB.add;

1419:
1420: ELSE
1421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1422: FND_MESSAGE.set_name('OZF', 'OZF_SETL_INT_ERR_PAYMETHOD');
1423: FND_MSG_PUB.add;
1424: END IF;
1425: x_return_status := FND_API.g_ret_sts_error;
1426: END IF;
1427:

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

1433: -- from the sys_param_csr above
1434: IF ( p_claim_rec.payment_method IN ('CHARGEBACK','DEBIT_MEMO') )
1435: THEN
1436: IF l_billback_trx_type_id IS NULL THEN
1437: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1438: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_BILLBACK_TRX_TYPE');
1439: FND_MSG_PUB.add;
1440: END IF;
1441: x_return_status := FND_API.g_ret_sts_error;

Line 1439: FND_MSG_PUB.add;

1435: THEN
1436: IF l_billback_trx_type_id IS NULL THEN
1437: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1438: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_BILLBACK_TRX_TYPE');
1439: FND_MSG_PUB.add;
1440: END IF;
1441: x_return_status := FND_API.g_ret_sts_error;
1442: ELSE
1443: p_x_interface_line_rec.cust_trx_type_id :=l_billback_trx_type_id;

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

1443: p_x_interface_line_rec.cust_trx_type_id :=l_billback_trx_type_id;
1444: END IF;
1445: ELSIF p_claim_rec.payment_method = 'CREDIT_MEMO' THEN
1446: IF l_cm_trx_type_id IS NULL THEN
1447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1448: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_CM_TRX_TYPE');
1449: FND_MSG_PUB.add;
1450: END IF;
1451: x_return_status := FND_API.g_ret_sts_error;

Line 1449: FND_MSG_PUB.add;

1445: ELSIF p_claim_rec.payment_method = 'CREDIT_MEMO' THEN
1446: IF l_cm_trx_type_id IS NULL THEN
1447: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1448: FND_MESSAGE.set_name('OZF', 'OZF_MISSING_CM_TRX_TYPE');
1449: FND_MSG_PUB.add;
1450: END IF;
1451: x_return_status := FND_API.g_ret_sts_error;
1452: ELSE
1453: p_x_interface_line_rec.cust_trx_type_id := l_cm_trx_type_id;

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

1583: IF csr_claim_line_product%ISOPEN THEN
1584: CLOSE csr_claim_line_product ;
1585: END IF;
1586:
1587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1588: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1589: FND_MSG_PUB.add;
1590: END IF;
1591: IF OZF_DEBUG_LOW_ON THEN

Line 1589: FND_MSG_PUB.add;

1585: END IF;
1586:
1587: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1588: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1589: FND_MSG_PUB.add;
1590: END IF;
1591: IF OZF_DEBUG_LOW_ON THEN
1592: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1593: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 1594: FND_MSG_PUB.Add;

1590: END IF;
1591: IF OZF_DEBUG_LOW_ON THEN
1592: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1593: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1594: FND_MSG_PUB.Add;
1595: END IF;
1596: x_return_status := FND_API.g_ret_sts_unexp_error;
1597: END Populate_Interface_Line_Rec;
1598:

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

1684: */
1685:
1686: EXCEPTION
1687: WHEN OTHERS THEN
1688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1689: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1690: FND_MSG_PUB.add;
1691: END IF;
1692: IF OZF_DEBUG_LOW_ON THEN

Line 1690: FND_MSG_PUB.add;

1686: EXCEPTION
1687: WHEN OTHERS THEN
1688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1689: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_INTF_ERROR');
1690: FND_MSG_PUB.add;
1691: END IF;
1692: IF OZF_DEBUG_LOW_ON THEN
1693: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1694: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 1695: FND_MSG_PUB.Add;

1691: END IF;
1692: IF OZF_DEBUG_LOW_ON THEN
1693: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1694: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1695: FND_MSG_PUB.Add;
1696: END IF;
1697: x_return_status := FND_API.g_ret_sts_unexp_error;
1698: END Populate_Interface_Tax_Rec;
1699:

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

1788: /* ------------------------------------------------------------- */
1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1793: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_DIST_ERROR');
1794: FND_MSG_PUB.add;
1795: END IF;
1796: IF OZF_DEBUG_LOW_ON THEN

Line 1794: FND_MSG_PUB.add;

1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1793: FND_MESSAGE.set_name('OZF', 'OZF_POPULATE_DIST_ERROR');
1794: FND_MSG_PUB.add;
1795: END IF;
1796: IF OZF_DEBUG_LOW_ON THEN
1797: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1798: FND_MESSAGE.Set_Token('TEXT',sqlerrm);

Line 1799: FND_MSG_PUB.Add;

1795: END IF;
1796: IF OZF_DEBUG_LOW_ON THEN
1797: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
1798: FND_MESSAGE.Set_Token('TEXT',sqlerrm);
1799: FND_MSG_PUB.Add;
1800: END IF;
1801: x_return_status := FND_API.g_ret_sts_unexp_error;
1802: END Populate_Distributions_Rec;
1803:

Line 2065: FND_MSG_PUB.Add;

2061: -- Debug Message
2062: IF OZF_DEBUG_LOW_ON THEN
2063: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2064: FND_MESSAGE.Set_Token('TEXT',l_full_name||': Start');
2065: FND_MSG_PUB.Add;
2066: END IF;
2067: --Initialize message list if p_init_msg_list is TRUE.
2068: IF FND_API.To_Boolean (p_init_msg_list) THEN
2069: FND_MSG_PUB.initialize;

Line 2069: FND_MSG_PUB.initialize;

2065: FND_MSG_PUB.Add;
2066: END IF;
2067: --Initialize message list if p_init_msg_list is TRUE.
2068: IF FND_API.To_Boolean (p_init_msg_list) THEN
2069: FND_MSG_PUB.initialize;
2070: END IF;
2071: -- Initialize API return status to sucess
2072: x_return_status := FND_API.G_RET_STS_SUCCESS;
2073:

Line 2171: FND_MSG_PUB.Add;

2167: -- Debug Message
2168: IF OZF_DEBUG_LOW_ON THEN
2169: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');
2170: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2171: FND_MSG_PUB.Add;
2172: END IF;
2173: --Standard call to get message count and if count=1, get the message
2174: FND_MSG_PUB.Count_And_Get (
2175: p_encoded => FND_API.G_FALSE,

Line 2174: FND_MSG_PUB.Count_And_Get (

2170: FND_MESSAGE.Set_Token('TEXT',l_full_name||': End');
2171: FND_MSG_PUB.Add;
2172: END IF;
2173: --Standard call to get message count and if count=1, get the message
2174: FND_MSG_PUB.Count_And_Get (
2175: p_encoded => FND_API.G_FALSE,
2176: p_count => x_msg_count,
2177: p_data => x_msg_data
2178: );

Line 2189: FND_MSG_PUB.Count_And_Get (

2185: END IF;
2186: ROLLBACK TO Interface_Claim_PVT;
2187: x_return_status := FND_API.G_RET_STS_ERROR;
2188: -- Standard call to get message count and if count=1, get the message
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 2201: FND_MSG_PUB.Count_And_Get (

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

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

2208: CLOSE claim_line_csr;
2209: END IF;
2210: ROLLBACK TO Interface_Claim_PVT;
2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2212: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2213: THEN
2214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2215: END IF;
2216: -- Standard call to get message count and if count=1, get the message

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

2210: ROLLBACK TO Interface_Claim_PVT;
2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2212: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2213: THEN
2214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2215: END IF;
2216: -- Standard call to get message count and if count=1, get the message
2217: FND_MSG_PUB.Count_And_Get (
2218: p_encoded => FND_API.G_FALSE,

Line 2217: FND_MSG_PUB.Count_And_Get (

2213: THEN
2214: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2215: END IF;
2216: -- Standard call to get message count and if count=1, get the message
2217: FND_MSG_PUB.Count_And_Get (
2218: p_encoded => FND_API.G_FALSE,
2219: p_count => x_msg_count,
2220: p_data => x_msg_data
2221: );