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 734: x_return_status := FND_API.g_ret_sts_success;

730: -- Fix for Bug#13329321
731: , 'S'
732: );
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');

Line 746: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
749:
750: PROCEDURE Insert_Interface_Tax

Line 859: x_return_status := FND_API.g_ret_sts_success;

855: , p_interface_tax_rec.org_id
856: , p_interface_tax_rec.legal_entity_id
857: );
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');

Line 871: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
874:
875: PROCEDURE Insert_Interface_Sales_Credits(

Line 968: x_return_status := FND_API.g_ret_sts_success;

964: p_int_sales_credits_rec.INTERFACE_LINE_ATTRIBUTE15 ,
965: p_int_sales_credits_rec.ORG_ID
966: );
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');

Line 980: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
983:
984: /* ---------------------------------------------- *

Line 1175: x_return_status := FND_API.g_ret_sts_success;

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

Line 1201: x_return_status := FND_API.g_ret_sts_error;

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

Line 1353: p_claim_rec.payment_method = FND_API.G_MISS_CHAR )

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

Line 1415: x_return_status := FND_API.g_ret_sts_error;

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

Line 1431: x_return_status := FND_API.g_ret_sts_error;

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

Line 1447: x_return_status := FND_API.g_ret_sts_error;

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

Line 1457: x_return_status := FND_API.g_ret_sts_error;

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;
1460: END IF;
1461: END IF;

Line 1605: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
1608:
1609: /* ---------------------------------------------- *

Line 1624: x_return_status := FND_API.g_ret_sts_success;

1620: l_tax_name VARCHAR2(60);
1621:
1622: BEGIN
1623: -- Start populating the interface record values
1624: x_return_status := FND_API.g_ret_sts_success;
1625:
1626: /* -- Standard Who Columns ------------------------- */
1627: x_interface_tax_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1628: x_interface_tax_rec.CREATION_DATE := SYSDATE ;

Line 1706: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
1709:
1710: /* ---------------------------------------------- *

Line 1731: x_return_status := FND_API.g_ret_sts_success;

1727: WHERE reason_code_id = cv_reason_code_id;
1728:
1729: BEGIN
1730: -- Start populating the interface record values
1731: x_return_status := FND_API.g_ret_sts_success;
1732:
1733: /* -- Standard Who Columns ------------------------- */
1734: p_x_int_distributions_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1735: p_x_int_distributions_rec.CREATION_DATE := SYSDATE ;

Line 1810: x_return_status := FND_API.g_ret_sts_unexp_error;

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:
1813: PROCEDURE Interface_Claim_Line
1814: ( p_claim_id IN NUMBER

Line 1835: x_return_status := FND_API.G_RET_STS_SUCCESS;

1831: WHERE salesrep_id = cv_salesrep_id;
1832:
1833: BEGIN
1834:
1835: x_return_status := FND_API.G_RET_STS_SUCCESS;
1836:
1837: Query_Claim ( p_claim_id => p_claim_id,
1838: x_claim_rec => l_claim_rec,
1839: x_return_status => x_return_status);

Line 1841: IF x_return_status = FND_API.g_ret_sts_error THEN

1837: Query_Claim ( p_claim_id => p_claim_id,
1838: x_claim_rec => l_claim_rec,
1839: x_return_status => x_return_status);
1840:
1841: IF x_return_status = FND_API.g_ret_sts_error THEN
1842: RAISE FND_API.g_exc_error;
1843: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1844: RAISE FND_API.g_exc_unexpected_error;
1845: END IF;

Line 1842: RAISE FND_API.g_exc_error;

1838: x_claim_rec => l_claim_rec,
1839: x_return_status => x_return_status);
1840:
1841: IF x_return_status = FND_API.g_ret_sts_error THEN
1842: RAISE FND_API.g_exc_error;
1843: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1844: RAISE FND_API.g_exc_unexpected_error;
1845: END IF;
1846:

Line 1843: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1839: x_return_status => x_return_status);
1840:
1841: IF x_return_status = FND_API.g_ret_sts_error THEN
1842: RAISE FND_API.g_exc_error;
1843: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1844: RAISE FND_API.g_exc_unexpected_error;
1845: END IF;
1846:
1847: --Populate the interface record with information from claim header and line

Line 1844: RAISE FND_API.g_exc_unexpected_error;

1840:
1841: IF x_return_status = FND_API.g_ret_sts_error THEN
1842: RAISE FND_API.g_exc_error;
1843: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1844: RAISE FND_API.g_exc_unexpected_error;
1845: END IF;
1846:
1847: --Populate the interface record with information from claim header and line
1848: Populate_Interface_Line_Rec(p_claim_rec => l_claim_rec,

Line 1857: IF x_return_status = FND_API.g_ret_sts_error THEN

1853: p_line_cc_id_flag => p_line_cc_id_flag,
1854: p_x_interface_line_rec => l_interface_line_rec,
1855: x_return_status => x_return_status
1856: );
1857: IF x_return_status = FND_API.g_ret_sts_error THEN
1858: RAISE FND_API.g_exc_error;
1859: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1860: RAISE FND_API.g_exc_unexpected_error;
1861: END IF;

Line 1858: RAISE FND_API.g_exc_error;

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

Line 1859: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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

Line 1860: RAISE FND_API.g_exc_unexpected_error;

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

Line 1867: IF x_return_status = FND_API.g_ret_sts_error THEN

1863: --Insert the line into RA_INTERFACE_LINES_ALL
1864: Insert_Interface_Line(l_interface_line_rec,
1865: x_return_status);
1866:
1867: IF x_return_status = FND_API.g_ret_sts_error THEN
1868: RAISE FND_API.g_exc_error;
1869: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1870: RAISE FND_API.g_exc_unexpected_error;
1871: END IF;

Line 1868: RAISE FND_API.g_exc_error;

1864: Insert_Interface_Line(l_interface_line_rec,
1865: x_return_status);
1866:
1867: IF x_return_status = FND_API.g_ret_sts_error THEN
1868: RAISE FND_API.g_exc_error;
1869: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1870: RAISE FND_API.g_exc_unexpected_error;
1871: END IF;
1872:

Line 1869: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1865: x_return_status);
1866:
1867: IF x_return_status = FND_API.g_ret_sts_error THEN
1868: RAISE FND_API.g_exc_error;
1869: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1870: RAISE FND_API.g_exc_unexpected_error;
1871: END IF;
1872:
1873: -------------------

Line 1870: RAISE FND_API.g_exc_unexpected_error;

1866:
1867: IF x_return_status = FND_API.g_ret_sts_error THEN
1868: RAISE FND_API.g_exc_error;
1869: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1870: RAISE FND_API.g_exc_unexpected_error;
1871: END IF;
1872:
1873: -------------------
1874: -- Sales Credits --

Line 1902: IF x_return_status = FND_API.g_ret_sts_error THEN

1898: Insert_Interface_Sales_Credits(
1899: l_int_sales_credits_rec,
1900: x_return_status
1901: );
1902: IF x_return_status = FND_API.g_ret_sts_error THEN
1903: RAISE FND_API.g_exc_error;
1904: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1905: RAISE FND_API.g_exc_unexpected_error;
1906: END IF;

Line 1903: RAISE FND_API.g_exc_error;

1899: l_int_sales_credits_rec,
1900: x_return_status
1901: );
1902: IF x_return_status = FND_API.g_ret_sts_error THEN
1903: RAISE FND_API.g_exc_error;
1904: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1905: RAISE FND_API.g_exc_unexpected_error;
1906: END IF;
1907: END IF;

Line 1904: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1900: x_return_status
1901: );
1902: IF x_return_status = FND_API.g_ret_sts_error THEN
1903: RAISE FND_API.g_exc_error;
1904: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1905: RAISE FND_API.g_exc_unexpected_error;
1906: END IF;
1907: END IF;
1908:

Line 1905: RAISE FND_API.g_exc_unexpected_error;

1901: );
1902: IF x_return_status = FND_API.g_ret_sts_error THEN
1903: RAISE FND_API.g_exc_error;
1904: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1905: RAISE FND_API.g_exc_unexpected_error;
1906: END IF;
1907: END IF;
1908:
1909: /* passing tax lines through AutoInvoice if tax_code exists in claim line. */

Line 1918: IF x_return_status = FND_API.g_ret_sts_error THEN

1914: p_interface_line_rec => l_interface_line_rec,
1915: x_interface_tax_rec => l_interface_tax_rec,
1916: x_return_status => x_return_status
1917: );
1918: IF x_return_status = FND_API.g_ret_sts_error THEN
1919: RAISE FND_API.g_exc_error;
1920: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1921: RAISE FND_API.g_exc_unexpected_error;
1922: END IF;

Line 1919: RAISE FND_API.g_exc_error;

1915: x_interface_tax_rec => l_interface_tax_rec,
1916: x_return_status => x_return_status
1917: );
1918: IF x_return_status = FND_API.g_ret_sts_error THEN
1919: RAISE FND_API.g_exc_error;
1920: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1921: RAISE FND_API.g_exc_unexpected_error;
1922: END IF;
1923:

Line 1920: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

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

Line 1921: RAISE FND_API.g_exc_unexpected_error;

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

Line 1928: IF x_return_status = FND_API.g_ret_sts_error THEN

1924: --Insert the tax into RA_INTERFACE_LINES_ALL
1925: Insert_Interface_Tax( l_interface_tax_rec,
1926: x_return_status
1927: );
1928: IF x_return_status = FND_API.g_ret_sts_error THEN
1929: RAISE FND_API.g_exc_error;
1930: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1931: RAISE FND_API.g_exc_unexpected_error;
1932: END IF;

Line 1929: RAISE FND_API.g_exc_error;

1925: Insert_Interface_Tax( l_interface_tax_rec,
1926: x_return_status
1927: );
1928: IF x_return_status = FND_API.g_ret_sts_error THEN
1929: RAISE FND_API.g_exc_error;
1930: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1931: RAISE FND_API.g_exc_unexpected_error;
1932: END IF;
1933: END IF; -- end of passing tax interface record.

Line 1930: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1926: x_return_status
1927: );
1928: IF x_return_status = FND_API.g_ret_sts_error THEN
1929: RAISE FND_API.g_exc_error;
1930: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1931: RAISE FND_API.g_exc_unexpected_error;
1932: END IF;
1933: END IF; -- end of passing tax interface record.
1934: */

Line 1931: RAISE FND_API.g_exc_unexpected_error;

1927: );
1928: IF x_return_status = FND_API.g_ret_sts_error THEN
1929: RAISE FND_API.g_exc_error;
1930: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1931: RAISE FND_API.g_exc_unexpected_error;
1932: END IF;
1933: END IF; -- end of passing tax interface record.
1934: */
1935:

Line 1950: x_return_status := FND_API.G_RET_STS_SUCCESS;

1946: l_claim_rec Claim_Rec_Type;
1947:
1948: BEGIN
1949:
1950: x_return_status := FND_API.G_RET_STS_SUCCESS;
1951:
1952: Query_Claim ( p_claim_id => p_claim_id,
1953: x_claim_rec => l_claim_rec,
1954: x_return_status => x_return_status);

Line 1956: IF x_return_status = FND_API.g_ret_sts_error THEN

1952: Query_Claim ( p_claim_id => p_claim_id,
1953: x_claim_rec => l_claim_rec,
1954: x_return_status => x_return_status);
1955:
1956: IF x_return_status = FND_API.g_ret_sts_error THEN
1957: RAISE FND_API.g_exc_error;
1958: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1959: RAISE FND_API.g_exc_unexpected_error;
1960: END IF;

Line 1957: RAISE FND_API.g_exc_error;

1953: x_claim_rec => l_claim_rec,
1954: x_return_status => x_return_status);
1955:
1956: IF x_return_status = FND_API.g_ret_sts_error THEN
1957: RAISE FND_API.g_exc_error;
1958: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1959: RAISE FND_API.g_exc_unexpected_error;
1960: END IF;
1961:

Line 1958: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1954: x_return_status => x_return_status);
1955:
1956: IF x_return_status = FND_API.g_ret_sts_error THEN
1957: RAISE FND_API.g_exc_error;
1958: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1959: RAISE FND_API.g_exc_unexpected_error;
1960: END IF;
1961:
1962: --Populate the distribution record with info from claim header and line

Line 1959: RAISE FND_API.g_exc_unexpected_error;

1955:
1956: IF x_return_status = FND_API.g_ret_sts_error THEN
1957: RAISE FND_API.g_exc_error;
1958: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1959: RAISE FND_API.g_exc_unexpected_error;
1960: END IF;
1961:
1962: --Populate the distribution record with info from claim header and line
1963: Populate_Distributions_Rec(p_claim_rec => l_claim_rec,

Line 1969: IF x_return_status = FND_API.g_ret_sts_error THEN

1965: p_cc_id_rec => p_cc_id_rec,
1966: p_x_int_distributions_rec => l_int_distributions_rec,
1967: x_return_status => x_return_status
1968: );
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: p_x_int_distributions_rec => l_int_distributions_rec,
1967: x_return_status => x_return_status
1968: );
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: x_return_status => x_return_status
1968: );
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: -- Insert the line into RA_INTERFACE_DISTRIBUTIONS_ALL

Line 1972: RAISE FND_API.g_exc_unexpected_error;

1968: );
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: -- Insert the line into RA_INTERFACE_DISTRIBUTIONS_ALL
1976: Insert_Int_Distributions(l_int_distributions_rec,

Line 1978: IF x_return_status = FND_API.g_ret_sts_error THEN

1974:
1975: -- Insert the line into RA_INTERFACE_DISTRIBUTIONS_ALL
1976: Insert_Int_Distributions(l_int_distributions_rec,
1977: x_return_status);
1978: IF x_return_status = FND_API.g_ret_sts_error THEN
1979: RAISE FND_API.g_exc_error;
1980: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1981: RAISE FND_API.g_exc_unexpected_error;
1982: END IF;

Line 1979: RAISE FND_API.g_exc_error;

1975: -- Insert the line into RA_INTERFACE_DISTRIBUTIONS_ALL
1976: Insert_Int_Distributions(l_int_distributions_rec,
1977: x_return_status);
1978: IF x_return_status = FND_API.g_ret_sts_error THEN
1979: RAISE FND_API.g_exc_error;
1980: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1981: RAISE FND_API.g_exc_unexpected_error;
1982: END IF;
1983:

Line 1980: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

1976: Insert_Int_Distributions(l_int_distributions_rec,
1977: x_return_status);
1978: IF x_return_status = FND_API.g_ret_sts_error THEN
1979: RAISE FND_API.g_exc_error;
1980: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1981: RAISE FND_API.g_exc_unexpected_error;
1982: END IF;
1983:
1984: END Distribute_Claim_Line;

Line 1981: RAISE FND_API.g_exc_unexpected_error;

1977: x_return_status);
1978: IF x_return_status = FND_API.g_ret_sts_error THEN
1979: RAISE FND_API.g_exc_error;
1980: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
1981: RAISE FND_API.g_exc_unexpected_error;
1982: END IF;
1983:
1984: END Distribute_Claim_Line;
1985:

Line 2062: IF NOT FND_API.Compatible_API_Call (

2058: /* ------- Begin Standard API Calls --------------------------- */
2059: -- Standard begin of API savepoint
2060: SAVEPOINT Interface_Claim_PVT ;
2061: -- Standard call to check for call compatibility.
2062: IF NOT FND_API.Compatible_API_Call (
2063: l_api_version,
2064: p_api_version,
2065: l_api_name,
2066: G_PKG_NAME)

Line 2068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2064: p_api_version,
2065: l_api_name,
2066: G_PKG_NAME)
2067: THEN
2068: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2069: END IF;
2070: -- Debug Message
2071: IF OZF_DEBUG_LOW_ON THEN
2072: FND_MESSAGE.Set_Name('OZF','OZF_API_DEBUG_MESSAGE');

Line 2077: IF FND_API.To_Boolean (p_init_msg_list) THEN

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;
2079: END IF;
2080: -- Initialize API return status to sucess
2081: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2081: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
2083: /* ------- End Standard API Calls ----------------------------- */
2084:
2085: /* ------- Begin API Logic ------------------------------------ */

Line 2108: ,p_init_msg_list => FND_API.g_false

2104: IF ((l_earnings_asso_flag = 'T' AND l_post_to_gl = 'T') OR (l_source_object_class = 'PPCUSTOMER'))
2105: THEN
2106: OZF_GL_INTERFACE_PVT.Get_GL_Account(
2107: p_api_version => l_api_version
2108: ,p_init_msg_list => FND_API.g_false
2109: ,p_commit => FND_API.g_false
2110: ,p_validation_level => FND_API.g_valid_level_full
2111: ,x_return_status => l_return_status
2112: ,x_msg_data => x_msg_data

Line 2109: ,p_commit => FND_API.g_false

2105: THEN
2106: OZF_GL_INTERFACE_PVT.Get_GL_Account(
2107: p_api_version => l_api_version
2108: ,p_init_msg_list => FND_API.g_false
2109: ,p_commit => FND_API.g_false
2110: ,p_validation_level => FND_API.g_valid_level_full
2111: ,x_return_status => l_return_status
2112: ,x_msg_data => x_msg_data
2113: ,x_msg_count => x_msg_count

Line 2110: ,p_validation_level => FND_API.g_valid_level_full

2106: OZF_GL_INTERFACE_PVT.Get_GL_Account(
2107: p_api_version => l_api_version
2108: ,p_init_msg_list => FND_API.g_false
2109: ,p_commit => FND_API.g_false
2110: ,p_validation_level => FND_API.g_valid_level_full
2111: ,x_return_status => l_return_status
2112: ,x_msg_data => x_msg_data
2113: ,x_msg_count => x_msg_count
2114: ,p_source_id => l_claim_line_id

Line 2119: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2115: ,p_source_table => 'OZF_CLAIM_LINES_ALL'
2116: ,p_account_type => 'REC_CLEARING'
2117: ,x_cc_id_tbl => l_cc_id_tbl
2118: );
2119: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2120: RAISE FND_API.G_EXC_ERROR;
2121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2123: END IF;

Line 2120: RAISE FND_API.G_EXC_ERROR;

2116: ,p_account_type => 'REC_CLEARING'
2117: ,x_cc_id_tbl => l_cc_id_tbl
2118: );
2119: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2120: RAISE FND_API.G_EXC_ERROR;
2121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2123: END IF;
2124:

Line 2121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2117: ,x_cc_id_tbl => l_cc_id_tbl
2118: );
2119: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2120: RAISE FND_API.G_EXC_ERROR;
2121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2123: END IF;
2124:
2125: l_line_cc_id_flag := 'Y';

Line 2122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2118: );
2119: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2120: RAISE FND_API.G_EXC_ERROR;
2121: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2122: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2123: END IF;
2124:
2125: l_line_cc_id_flag := 'Y';
2126: ELSE

Line 2138: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2134: l_line_tax_code,
2135: l_line_cc_id_flag,
2136: l_return_status);
2137:
2138: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2139: RAISE FND_API.G_EXC_ERROR;
2140: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2142: END IF;

Line 2139: RAISE FND_API.G_EXC_ERROR;

2135: l_line_cc_id_flag,
2136: l_return_status);
2137:
2138: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2139: RAISE FND_API.G_EXC_ERROR;
2140: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2142: END IF;
2143:

Line 2140: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2136: l_return_status);
2137:
2138: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2139: RAISE FND_API.G_EXC_ERROR;
2140: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2142: END IF;
2143:
2144: IF l_line_cc_id_flag = 'Y' THEN

Line 2141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2137:
2138: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2139: RAISE FND_API.G_EXC_ERROR;
2140: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2142: END IF;
2143:
2144: IF l_line_cc_id_flag = 'Y' THEN
2145: FOR i IN 1..(l_cc_id_tbl.COUNT) LOOP

Line 2151: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

2147: l_claim_line_id,
2148: l_cc_id_tbl(i),
2149: l_return_status
2150: );
2151: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2152: RAISE FND_API.G_EXC_ERROR;
2153: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2155: END IF;

Line 2152: RAISE FND_API.G_EXC_ERROR;

2148: l_cc_id_tbl(i),
2149: l_return_status
2150: );
2151: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2152: RAISE FND_API.G_EXC_ERROR;
2153: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2155: END IF;
2156: END LOOP;

Line 2153: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2149: l_return_status
2150: );
2151: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2152: RAISE FND_API.G_EXC_ERROR;
2153: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2155: END IF;
2156: END LOOP;
2157: END IF;

Line 2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2150: );
2151: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2152: RAISE FND_API.G_EXC_ERROR;
2153: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2155: END IF;
2156: END LOOP;
2157: END IF;
2158: END LOOP;

Line 2173: IF FND_API.To_Boolean ( p_commit ) THEN

2169:
2170: /* ------- Begin Standard API Calls --------------------------- */
2171:
2172: --Standard check of commit
2173: IF FND_API.To_Boolean ( p_commit ) THEN
2174: COMMIT WORK;
2175: END IF;
2176: -- Debug Message
2177: IF OZF_DEBUG_LOW_ON THEN

Line 2184: p_encoded => FND_API.G_FALSE,

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

Line 2191: WHEN FND_API.G_EXC_ERROR THEN

2187: );
2188:
2189: /* ------- End Standard API Calls ----------------------------- */
2190: EXCEPTION
2191: WHEN FND_API.G_EXC_ERROR THEN
2192: IF (claim_line_csr%ISOPEN) THEN
2193: CLOSE claim_line_csr;
2194: END IF;
2195: ROLLBACK TO Interface_Claim_PVT;

Line 2196: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2199: p_encoded => FND_API.G_FALSE,

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

Line 2203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2199: p_encoded => FND_API.G_FALSE,
2200: p_count => x_msg_count,
2201: p_data => x_msg_data
2202: );
2203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2204: IF (claim_line_csr%ISOPEN) THEN
2205: CLOSE claim_line_csr;
2206: END IF;
2207: ROLLBACK TO Interface_Claim_PVT;

Line 2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2211: p_encoded => FND_API.G_FALSE,

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

Line 2220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2227: p_encoded => FND_API.G_FALSE,

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