eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_AR_INTERFACE_PVT dependencies on FND_API

Line 285: x_return_status := FND_API.g_ret_sts_success;

281: ,x_claim_rec.legal_entity_id
282: FROM ozf_claims_all
283: WHERE claim_id = p_claim_id ;
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');

Line 292: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
295: PROCEDURE Insert_Int_Distributions
296: ( p_int_distributions_rec IN RA_Int_Distributions_Rec_Type

Line 525: x_return_status := FND_API.g_ret_sts_success;

521: p_int_distributions_rec.interim_tax_segment29,
522: p_int_distributions_rec.interim_tax_segment30
523: );
524:
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

Line 538: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
541: PROCEDURE Insert_Interface_Line
542: ( p_interface_line_rec IN RA_Interface_Lines_Rec_Type

Line 730: x_return_status := FND_API.g_ret_sts_success;

726: ,'OZF_CLAIMS'
727: , 'TRADE_MGT_RECEIVABLES'
728: );
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');

Line 742: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
745:
746: PROCEDURE Insert_Interface_Tax

Line 855: x_return_status := FND_API.g_ret_sts_success;

851: , p_interface_tax_rec.org_id
852: , p_interface_tax_rec.legal_entity_id
853: );
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');

Line 867: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
870:
871: PROCEDURE Insert_Interface_Sales_Credits(

Line 964: x_return_status := FND_API.g_ret_sts_success;

960: p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE15 ,
961: p_int_sales_credits_rec.ORG_ID
962: );
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');

Line 976: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
979:
980: /* ---------------------------------------------- *

Line 1171: x_return_status := FND_API.g_ret_sts_success;

1167: WHERE channel_id = cv_media_channel_id;
1168:
1169: BEGIN
1170: -- Start populating the interface record values
1171: x_return_status := FND_API.g_ret_sts_success;
1172:
1173: /* -- Standard Who Columns ------------------------- */
1174: p_x_interface_line_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1175: p_x_interface_line_rec.CREATION_DATE := SYSDATE ;

Line 1197: x_return_status := FND_API.g_ret_sts_error;

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) ;
1200: FETCH batch_source_csr INTO p_x_interface_line_rec.batch_source_name;
1201: CLOSE batch_source_csr;

Line 1347: p_claim_rec.payment_method = FND_API.G_MISS_CHAR )

1343:
1344: /* -- Derive and Validate the transaction type ---------- */
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;

Line 1409: x_return_status := FND_API.g_ret_sts_error;

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:
1412: -- Overpayment amount is negative; Creation sign for debit memo should be positive.
1413: p_x_interface_line_rec.AMOUNT := p_line_claim_curr_amt * -1;

Line 1425: x_return_status := FND_API.g_ret_sts_error;

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:
1428: -- If trx_type is not defined at claim type level, get it from
1429: -- system parameters

Line 1441: x_return_status := FND_API.g_ret_sts_error;

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;
1444: END IF;
1445: ELSIF p_claim_rec.payment_method = 'CREDIT_MEMO' THEN

Line 1451: x_return_status := FND_API.g_ret_sts_error;

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;
1454: END IF;
1455: END IF;

Line 1596: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
1599:
1600: /* ---------------------------------------------- *

Line 1615: x_return_status := FND_API.g_ret_sts_success;

1611: l_tax_name VARCHAR2(60);
1612:
1613: BEGIN
1614: -- Start populating the interface record values
1615: x_return_status := FND_API.g_ret_sts_success;
1616:
1617: /* -- Standard Who Columns ------------------------- */
1618: x_interface_tax_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1619: x_interface_tax_rec.CREATION_DATE := SYSDATE ;

Line 1697: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
1700:
1701: /* ---------------------------------------------- *

Line 1722: x_return_status := FND_API.g_ret_sts_success;

1718: WHERE reason_code_id = cv_reason_code_id;
1719:
1720: BEGIN
1721: -- Start populating the interface record values
1722: x_return_status := FND_API.g_ret_sts_success;
1723:
1724: /* -- Standard Who Columns ------------------------- */
1725: p_x_int_distributions_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1726: p_x_int_distributions_rec.CREATION_DATE := SYSDATE ;

Line 1801: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
1804: PROCEDURE Interface_Claim_Line
1805: ( p_claim_id IN NUMBER

Line 1826: x_return_status := FND_API.G_RET_STS_SUCCESS;

1822: WHERE salesrep_id = cv_salesrep_id;
1823:
1824: BEGIN
1825:
1826: x_return_status := FND_API.G_RET_STS_SUCCESS;
1827:
1828: Query_Claim ( p_claim_id => p_claim_id,
1829: x_claim_rec => l_claim_rec,
1830: x_return_status => x_return_status);

Line 1832: IF x_return_status = FND_API.g_ret_sts_error THEN

1828: Query_Claim ( p_claim_id => p_claim_id,
1829: x_claim_rec => l_claim_rec,
1830: x_return_status => x_return_status);
1831:
1832: IF x_return_status = FND_API.g_ret_sts_error THEN
1833: RAISE FND_API.g_exc_error;
1834: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1835: RAISE FND_API.g_exc_unexpected_error;
1836: END IF;

Line 1833: RAISE FND_API.g_exc_error;

1829: x_claim_rec => l_claim_rec,
1830: x_return_status => x_return_status);
1831:
1832: IF x_return_status = FND_API.g_ret_sts_error THEN
1833: RAISE FND_API.g_exc_error;
1834: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1835: RAISE FND_API.g_exc_unexpected_error;
1836: END IF;
1837:

Line 1834: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1830: x_return_status => x_return_status);
1831:
1832: IF x_return_status = FND_API.g_ret_sts_error THEN
1833: RAISE FND_API.g_exc_error;
1834: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1835: RAISE FND_API.g_exc_unexpected_error;
1836: END IF;
1837:
1838: --Populate the interface record with information from claim header and line

Line 1835: RAISE FND_API.g_exc_unexpected_error;

1831:
1832: IF x_return_status = FND_API.g_ret_sts_error THEN
1833: RAISE FND_API.g_exc_error;
1834: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1835: RAISE FND_API.g_exc_unexpected_error;
1836: END IF;
1837:
1838: --Populate the interface record with information from claim header and line
1839: Populate_Interface_Line_Rec(p_claim_rec => l_claim_rec,

Line 1848: IF x_return_status = FND_API.g_ret_sts_error THEN

1844: p_line_cc_id_flag => p_line_cc_id_flag,
1845: p_x_interface_line_rec => l_interface_line_rec,
1846: x_return_status => x_return_status
1847: );
1848: IF x_return_status = FND_API.g_ret_sts_error THEN
1849: RAISE FND_API.g_exc_error;
1850: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1851: RAISE FND_API.g_exc_unexpected_error;
1852: END IF;

Line 1849: RAISE FND_API.g_exc_error;

1845: p_x_interface_line_rec => l_interface_line_rec,
1846: x_return_status => x_return_status
1847: );
1848: IF x_return_status = FND_API.g_ret_sts_error THEN
1849: RAISE FND_API.g_exc_error;
1850: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1851: RAISE FND_API.g_exc_unexpected_error;
1852: END IF;
1853:

Line 1850: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1846: x_return_status => x_return_status
1847: );
1848: IF x_return_status = FND_API.g_ret_sts_error THEN
1849: RAISE FND_API.g_exc_error;
1850: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1851: RAISE FND_API.g_exc_unexpected_error;
1852: END IF;
1853:
1854: --Insert the line into RA_INTERFACE_LINES_ALL

Line 1851: RAISE FND_API.g_exc_unexpected_error;

1847: );
1848: IF x_return_status = FND_API.g_ret_sts_error THEN
1849: RAISE FND_API.g_exc_error;
1850: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1851: RAISE FND_API.g_exc_unexpected_error;
1852: END IF;
1853:
1854: --Insert the line into RA_INTERFACE_LINES_ALL
1855: Insert_Interface_Line(l_interface_line_rec,

Line 1858: IF x_return_status = FND_API.g_ret_sts_error THEN

1854: --Insert the line into RA_INTERFACE_LINES_ALL
1855: Insert_Interface_Line(l_interface_line_rec,
1856: x_return_status);
1857:
1858: IF x_return_status = FND_API.g_ret_sts_error THEN
1859: RAISE FND_API.g_exc_error;
1860: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1861: RAISE FND_API.g_exc_unexpected_error;
1862: END IF;

Line 1859: RAISE FND_API.g_exc_error;

1855: Insert_Interface_Line(l_interface_line_rec,
1856: x_return_status);
1857:
1858: IF x_return_status = FND_API.g_ret_sts_error THEN
1859: RAISE FND_API.g_exc_error;
1860: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1861: RAISE FND_API.g_exc_unexpected_error;
1862: END IF;
1863:

Line 1860: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1856: x_return_status);
1857:
1858: IF x_return_status = FND_API.g_ret_sts_error THEN
1859: RAISE FND_API.g_exc_error;
1860: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1861: RAISE FND_API.g_exc_unexpected_error;
1862: END IF;
1863:
1864: -------------------

Line 1861: RAISE FND_API.g_exc_unexpected_error;

1857:
1858: IF x_return_status = FND_API.g_ret_sts_error THEN
1859: RAISE FND_API.g_exc_error;
1860: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1861: RAISE FND_API.g_exc_unexpected_error;
1862: END IF;
1863:
1864: -------------------
1865: -- Sales Credits --

Line 1893: IF x_return_status = FND_API.g_ret_sts_error THEN

1889: Insert_Interface_Sales_Credits(
1890: l_int_sales_credits_rec,
1891: x_return_status
1892: );
1893: IF x_return_status = FND_API.g_ret_sts_error THEN
1894: RAISE FND_API.g_exc_error;
1895: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1896: RAISE FND_API.g_exc_unexpected_error;
1897: END IF;

Line 1894: RAISE FND_API.g_exc_error;

1890: l_int_sales_credits_rec,
1891: x_return_status
1892: );
1893: IF x_return_status = FND_API.g_ret_sts_error THEN
1894: RAISE FND_API.g_exc_error;
1895: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1896: RAISE FND_API.g_exc_unexpected_error;
1897: END IF;
1898: END IF;

Line 1895: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1891: x_return_status
1892: );
1893: IF x_return_status = FND_API.g_ret_sts_error THEN
1894: RAISE FND_API.g_exc_error;
1895: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1896: RAISE FND_API.g_exc_unexpected_error;
1897: END IF;
1898: END IF;
1899:

Line 1896: RAISE FND_API.g_exc_unexpected_error;

1892: );
1893: IF x_return_status = FND_API.g_ret_sts_error THEN
1894: RAISE FND_API.g_exc_error;
1895: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1896: RAISE FND_API.g_exc_unexpected_error;
1897: END IF;
1898: END IF;
1899:
1900: /* passing tax lines through AutoInvoice if tax_code exists in claim line. */

Line 1909: IF x_return_status = FND_API.g_ret_sts_error THEN

1905: p_interface_line_rec => l_interface_line_rec,
1906: x_interface_tax_rec => l_interface_tax_rec,
1907: x_return_status => x_return_status
1908: );
1909: IF x_return_status = FND_API.g_ret_sts_error THEN
1910: RAISE FND_API.g_exc_error;
1911: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1912: RAISE FND_API.g_exc_unexpected_error;
1913: END IF;

Line 1910: RAISE FND_API.g_exc_error;

1906: x_interface_tax_rec => l_interface_tax_rec,
1907: x_return_status => x_return_status
1908: );
1909: IF x_return_status = FND_API.g_ret_sts_error THEN
1910: RAISE FND_API.g_exc_error;
1911: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1912: RAISE FND_API.g_exc_unexpected_error;
1913: END IF;
1914:

Line 1911: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1907: x_return_status => x_return_status
1908: );
1909: IF x_return_status = FND_API.g_ret_sts_error THEN
1910: RAISE FND_API.g_exc_error;
1911: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1912: RAISE FND_API.g_exc_unexpected_error;
1913: END IF;
1914:
1915: --Insert the tax into RA_INTERFACE_LINES_ALL

Line 1912: RAISE FND_API.g_exc_unexpected_error;

1908: );
1909: IF x_return_status = FND_API.g_ret_sts_error THEN
1910: RAISE FND_API.g_exc_error;
1911: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1912: RAISE FND_API.g_exc_unexpected_error;
1913: END IF;
1914:
1915: --Insert the tax into RA_INTERFACE_LINES_ALL
1916: Insert_Interface_Tax( l_interface_tax_rec,

Line 1919: IF x_return_status = FND_API.g_ret_sts_error THEN

1915: --Insert the tax into RA_INTERFACE_LINES_ALL
1916: Insert_Interface_Tax( l_interface_tax_rec,
1917: x_return_status
1918: );
1919: IF x_return_status = FND_API.g_ret_sts_error THEN
1920: RAISE FND_API.g_exc_error;
1921: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1922: RAISE FND_API.g_exc_unexpected_error;
1923: END IF;

Line 1920: RAISE FND_API.g_exc_error;

1916: Insert_Interface_Tax( l_interface_tax_rec,
1917: x_return_status
1918: );
1919: IF x_return_status = FND_API.g_ret_sts_error THEN
1920: RAISE FND_API.g_exc_error;
1921: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1922: RAISE FND_API.g_exc_unexpected_error;
1923: END IF;
1924: END IF; -- end of passing tax interface record.

Line 1921: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1917: x_return_status
1918: );
1919: IF x_return_status = FND_API.g_ret_sts_error THEN
1920: RAISE FND_API.g_exc_error;
1921: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1922: RAISE FND_API.g_exc_unexpected_error;
1923: END IF;
1924: END IF; -- end of passing tax interface record.
1925: */

Line 1922: RAISE FND_API.g_exc_unexpected_error;

1918: );
1919: IF x_return_status = FND_API.g_ret_sts_error THEN
1920: RAISE FND_API.g_exc_error;
1921: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1922: RAISE FND_API.g_exc_unexpected_error;
1923: END IF;
1924: END IF; -- end of passing tax interface record.
1925: */
1926:

Line 1941: x_return_status := FND_API.G_RET_STS_SUCCESS;

1937: l_claim_rec Claim_Rec_Type;
1938:
1939: BEGIN
1940:
1941: x_return_status := FND_API.G_RET_STS_SUCCESS;
1942:
1943: Query_Claim ( p_claim_id => p_claim_id,
1944: x_claim_rec => l_claim_rec,
1945: x_return_status => x_return_status);

Line 1947: IF x_return_status = FND_API.g_ret_sts_error THEN

1943: Query_Claim ( p_claim_id => p_claim_id,
1944: x_claim_rec => l_claim_rec,
1945: x_return_status => x_return_status);
1946:
1947: IF x_return_status = FND_API.g_ret_sts_error THEN
1948: RAISE FND_API.g_exc_error;
1949: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1950: RAISE FND_API.g_exc_unexpected_error;
1951: END IF;

Line 1948: RAISE FND_API.g_exc_error;

1944: x_claim_rec => l_claim_rec,
1945: x_return_status => x_return_status);
1946:
1947: IF x_return_status = FND_API.g_ret_sts_error THEN
1948: RAISE FND_API.g_exc_error;
1949: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1950: RAISE FND_API.g_exc_unexpected_error;
1951: END IF;
1952:

Line 1949: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1945: x_return_status => x_return_status);
1946:
1947: IF x_return_status = FND_API.g_ret_sts_error THEN
1948: RAISE FND_API.g_exc_error;
1949: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1950: RAISE FND_API.g_exc_unexpected_error;
1951: END IF;
1952:
1953: --Populate the distribution record with info from claim header and line

Line 1950: RAISE FND_API.g_exc_unexpected_error;

1946:
1947: IF x_return_status = FND_API.g_ret_sts_error THEN
1948: RAISE FND_API.g_exc_error;
1949: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1950: RAISE FND_API.g_exc_unexpected_error;
1951: END IF;
1952:
1953: --Populate the distribution record with info from claim header and line
1954: Populate_Distributions_Rec(p_claim_rec => l_claim_rec,

Line 1960: IF x_return_status = FND_API.g_ret_sts_error THEN

1956: p_cc_id_rec => p_cc_id_rec,
1957: p_x_int_distributions_rec => l_int_distributions_rec,
1958: x_return_status => x_return_status
1959: );
1960: IF x_return_status = FND_API.g_ret_sts_error THEN
1961: RAISE FND_API.g_exc_error;
1962: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1963: RAISE FND_API.g_exc_unexpected_error;
1964: END IF;

Line 1961: RAISE FND_API.g_exc_error;

1957: p_x_int_distributions_rec => l_int_distributions_rec,
1958: x_return_status => x_return_status
1959: );
1960: IF x_return_status = FND_API.g_ret_sts_error THEN
1961: RAISE FND_API.g_exc_error;
1962: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1963: RAISE FND_API.g_exc_unexpected_error;
1964: END IF;
1965:

Line 1962: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1958: x_return_status => x_return_status
1959: );
1960: IF x_return_status = FND_API.g_ret_sts_error THEN
1961: RAISE FND_API.g_exc_error;
1962: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1963: RAISE FND_API.g_exc_unexpected_error;
1964: END IF;
1965:
1966: -- Insert the line into RA_INTERFACE_DISTRIBUTIONS_ALL

Line 1963: RAISE FND_API.g_exc_unexpected_error;

1959: );
1960: IF x_return_status = FND_API.g_ret_sts_error THEN
1961: RAISE FND_API.g_exc_error;
1962: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1963: RAISE FND_API.g_exc_unexpected_error;
1964: END IF;
1965:
1966: -- Insert the line into RA_INTERFACE_DISTRIBUTIONS_ALL
1967: Insert_Int_Distributions(l_int_distributions_rec,

Line 1969: IF x_return_status = FND_API.g_ret_sts_error THEN

1965:
1966: -- Insert the line into RA_INTERFACE_DISTRIBUTIONS_ALL
1967: Insert_Int_Distributions(l_int_distributions_rec,
1968: x_return_status);
1969: IF x_return_status = FND_API.g_ret_sts_error THEN
1970: RAISE FND_API.g_exc_error;
1971: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1972: RAISE FND_API.g_exc_unexpected_error;
1973: END IF;

Line 1970: RAISE FND_API.g_exc_error;

1966: -- Insert the line into RA_INTERFACE_DISTRIBUTIONS_ALL
1967: Insert_Int_Distributions(l_int_distributions_rec,
1968: x_return_status);
1969: IF x_return_status = FND_API.g_ret_sts_error THEN
1970: RAISE FND_API.g_exc_error;
1971: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1972: RAISE FND_API.g_exc_unexpected_error;
1973: END IF;
1974:

Line 1971: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1967: Insert_Int_Distributions(l_int_distributions_rec,
1968: x_return_status);
1969: IF x_return_status = FND_API.g_ret_sts_error THEN
1970: RAISE FND_API.g_exc_error;
1971: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1972: RAISE FND_API.g_exc_unexpected_error;
1973: END IF;
1974:
1975: END Distribute_Claim_Line;

Line 1972: RAISE FND_API.g_exc_unexpected_error;

1968: x_return_status);
1969: IF x_return_status = FND_API.g_ret_sts_error THEN
1970: RAISE FND_API.g_exc_error;
1971: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1972: RAISE FND_API.g_exc_unexpected_error;
1973: END IF;
1974:
1975: END Distribute_Claim_Line;
1976:

Line 2053: IF NOT FND_API.Compatible_API_Call (

2049: /* ------- Begin Standard API Calls --------------------------- */
2050: -- Standard begin of API savepoint
2051: SAVEPOINT Interface_Claim_PVT ;
2052: -- Standard call to check for call compatibility.
2053: IF NOT FND_API.Compatible_API_Call (
2054: l_api_version,
2055: p_api_version,
2056: l_api_name,
2057: G_PKG_NAME)

Line 2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2055: p_api_version,
2056: l_api_name,
2057: G_PKG_NAME)
2058: THEN
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: END IF;
2061: -- Debug Message
2062: IF OZF_DEBUG_LOW_ON THEN
2063: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 2068: IF FND_API.To_Boolean (p_init_msg_list) THEN

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;
2070: END IF;
2071: -- Initialize API return status to sucess
2072: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2072: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
2074: /* ------- End Standard API Calls ----------------------------- */
2075:
2076: /* ------- Begin API Logic ------------------------------------ */

Line 2099: ,p_init_msg_list => FND_API.g_false

2095: IF ((l_earnings_asso_flag = 'T' AND l_post_to_gl = 'T') OR (l_source_object_class = 'PPCUSTOMER'))
2096: THEN
2097: OZF_GL_INTERFACE_PVT.Get_GL_Account(
2098: p_api_version => l_api_version
2099: ,p_init_msg_list => FND_API.g_false
2100: ,p_commit => FND_API.g_false
2101: ,p_validation_level => FND_API.g_valid_level_full
2102: ,x_return_status => l_return_status
2103: ,x_msg_data => x_msg_data

Line 2100: ,p_commit => FND_API.g_false

2096: THEN
2097: OZF_GL_INTERFACE_PVT.Get_GL_Account(
2098: p_api_version => l_api_version
2099: ,p_init_msg_list => FND_API.g_false
2100: ,p_commit => FND_API.g_false
2101: ,p_validation_level => FND_API.g_valid_level_full
2102: ,x_return_status => l_return_status
2103: ,x_msg_data => x_msg_data
2104: ,x_msg_count => x_msg_count

Line 2101: ,p_validation_level => FND_API.g_valid_level_full

2097: OZF_GL_INTERFACE_PVT.Get_GL_Account(
2098: p_api_version => l_api_version
2099: ,p_init_msg_list => FND_API.g_false
2100: ,p_commit => FND_API.g_false
2101: ,p_validation_level => FND_API.g_valid_level_full
2102: ,x_return_status => l_return_status
2103: ,x_msg_data => x_msg_data
2104: ,x_msg_count => x_msg_count
2105: ,p_source_id => l_claim_line_id

Line 2110: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2106: ,p_source_table => 'OZF_CLAIM_LINES_ALL'
2107: ,p_account_type => 'REC_CLEARING'
2108: ,x_cc_id_tbl => l_cc_id_tbl
2109: );
2110: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2111: RAISE FND_API.G_EXC_ERROR;
2112: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2114: END IF;

Line 2111: RAISE FND_API.G_EXC_ERROR;

2107: ,p_account_type => 'REC_CLEARING'
2108: ,x_cc_id_tbl => l_cc_id_tbl
2109: );
2110: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2111: RAISE FND_API.G_EXC_ERROR;
2112: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2114: END IF;
2115:

Line 2112: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2108: ,x_cc_id_tbl => l_cc_id_tbl
2109: );
2110: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2111: RAISE FND_API.G_EXC_ERROR;
2112: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2114: END IF;
2115:
2116: l_line_cc_id_flag := 'Y';

Line 2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2109: );
2110: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2111: RAISE FND_API.G_EXC_ERROR;
2112: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2114: END IF;
2115:
2116: l_line_cc_id_flag := 'Y';
2117: ELSE

Line 2129: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2125: l_line_tax_code,
2126: l_line_cc_id_flag,
2127: l_return_status);
2128:
2129: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2130: RAISE FND_API.G_EXC_ERROR;
2131: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: END IF;

Line 2130: RAISE FND_API.G_EXC_ERROR;

2126: l_line_cc_id_flag,
2127: l_return_status);
2128:
2129: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2130: RAISE FND_API.G_EXC_ERROR;
2131: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: END IF;
2134:

Line 2131: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2127: l_return_status);
2128:
2129: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2130: RAISE FND_API.G_EXC_ERROR;
2131: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: END IF;
2134:
2135: IF l_line_cc_id_flag = 'Y' THEN

Line 2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2128:
2129: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2130: RAISE FND_API.G_EXC_ERROR;
2131: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2133: END IF;
2134:
2135: IF l_line_cc_id_flag = 'Y' THEN
2136: FOR i IN 1..(l_cc_id_tbl.COUNT) LOOP

Line 2142: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2138: l_claim_line_id,
2139: l_cc_id_tbl(i),
2140: l_return_status
2141: );
2142: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2143: RAISE FND_API.G_EXC_ERROR;
2144: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: END IF;

Line 2143: RAISE FND_API.G_EXC_ERROR;

2139: l_cc_id_tbl(i),
2140: l_return_status
2141: );
2142: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2143: RAISE FND_API.G_EXC_ERROR;
2144: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: END IF;
2147: END LOOP;

Line 2144: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2140: l_return_status
2141: );
2142: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2143: RAISE FND_API.G_EXC_ERROR;
2144: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: END IF;
2147: END LOOP;
2148: END IF;

Line 2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2141: );
2142: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2143: RAISE FND_API.G_EXC_ERROR;
2144: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2145: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2146: END IF;
2147: END LOOP;
2148: END IF;
2149: END LOOP;

Line 2164: IF FND_API.To_Boolean ( p_commit ) THEN

2160:
2161: /* ------- Begin Standard API Calls --------------------------- */
2162:
2163: --Standard check of commit
2164: IF FND_API.To_Boolean ( p_commit ) THEN
2165: COMMIT WORK;
2166: END IF;
2167: -- Debug Message
2168: IF OZF_DEBUG_LOW_ON THEN

Line 2175: p_encoded => FND_API.G_FALSE,

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: );
2179:

Line 2182: WHEN FND_API.G_EXC_ERROR THEN

2178: );
2179:
2180: /* ------- End Standard API Calls ----------------------------- */
2181: EXCEPTION
2182: WHEN FND_API.G_EXC_ERROR THEN
2183: IF (claim_line_csr%ISOPEN) THEN
2184: CLOSE claim_line_csr;
2185: END IF;
2186: ROLLBACK TO Interface_Claim_PVT;

Line 2187: x_return_status := FND_API.G_RET_STS_ERROR;

2183: IF (claim_line_csr%ISOPEN) THEN
2184: CLOSE claim_line_csr;
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,

Line 2190: p_encoded => FND_API.G_FALSE,

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: );
2194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2190: p_encoded => FND_API.G_FALSE,
2191: p_count => x_msg_count,
2192: p_data => x_msg_data
2193: );
2194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2195: IF (claim_line_csr%ISOPEN) THEN
2196: CLOSE claim_line_csr;
2197: END IF;
2198: ROLLBACK TO Interface_Claim_PVT;

Line 2199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2195: IF (claim_line_csr%ISOPEN) THEN
2196: CLOSE claim_line_csr;
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,

Line 2202: p_encoded => FND_API.G_FALSE,

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: );
2206: WHEN OTHERS THEN

Line 2211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2207: IF (claim_line_csr%ISOPEN) THEN
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;

Line 2218: p_encoded => FND_API.G_FALSE,

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: );
2222: