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.CS_SERVICE_BILLING_ENGINE_PVT dependencies on FND_API

Line 140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

136: --
137:
138: PROCEDURE Create_Charges(
139: P_Api_Version_Number IN NUMBER,
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_sbe_record IN SBE_Rec_Type,
143: p_final_charge_flag IN VARCHAR2,
144: x_return_status OUT NOCOPY VARCHAR2,

Line 141: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

137:
138: PROCEDURE Create_Charges(
139: P_Api_Version_Number IN NUMBER,
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
142: p_sbe_record IN SBE_Rec_Type,
143: p_final_charge_flag IN VARCHAR2,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,

Line 322: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

318: BEGIN
319: SAVEPOINT Create_Charges;
320:
321: -- Standard call to check for call compatibility.
322: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
323: p_api_version_number,
324: l_api_name,
325: G_PKG_NAME)
326: THEN

Line 327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

323: p_api_version_number,
324: l_api_name,
325: G_PKG_NAME)
326: THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: -- Initialize message list if p_init_msg_list is set to TRUE.
331: IF FND_API.to_Boolean(p_init_msg_list)

Line 331: IF FND_API.to_Boolean(p_init_msg_list)

327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: END IF;
329:
330: -- Initialize message list if p_init_msg_list is set to TRUE.
331: IF FND_API.to_Boolean(p_init_msg_list)
332: THEN
333: FND_MSG_PUB.initialize;
334: END IF;
335:

Line 337: x_return_status := FND_API.G_RET_STS_SUCCESS;

333: FND_MSG_PUB.initialize;
334: END IF;
335:
336: -- Initialize API return status to SUCCESS
337: x_return_status := FND_API.G_RET_STS_SUCCESS;
338:
339: ----------------------- FND Logging -----------------------------------
340: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
341: THEN

Line 623: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

619: x_return_status => x_return_status,
620: x_msg_count => x_msg_count,
621: x_msg_data => x_msg_data);
622:
623: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
624: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_GET_CONTRACT_API_ERROR');
625: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
626: FND_MSG_PUB.ADD;
627: RAISE EXCP_USER_DEFINED;

Line 654: l_charges_rec.interface_to_oe_flag := FND_API.G_MISS_CHAR;

650: l_charges_rec.item_revision := p_sbe_record.item_revision;
651: l_charges_rec.customer_product_id := p_sbe_record.customer_product_id;
652: l_charges_rec.installed_cp_return_by_date := p_sbe_record.installed_cp_return_by_date;
653: l_charges_rec.apply_contract_discount := 'Y'; -- Always automatically apply contract discount.
654: l_charges_rec.interface_to_oe_flag := FND_API.G_MISS_CHAR;
655: l_charges_rec.rollup_flag := 'N';
656: l_charges_rec.add_to_order_flag := 'N';
657: l_charges_rec.no_charge_flag := FND_API.G_MISS_CHAR;
658: l_charges_rec.generated_by_bca_engine := 'Y';

Line 657: l_charges_rec.no_charge_flag := FND_API.G_MISS_CHAR;

653: l_charges_rec.apply_contract_discount := 'Y'; -- Always automatically apply contract discount.
654: l_charges_rec.interface_to_oe_flag := FND_API.G_MISS_CHAR;
655: l_charges_rec.rollup_flag := 'N';
656: l_charges_rec.add_to_order_flag := 'N';
657: l_charges_rec.no_charge_flag := FND_API.G_MISS_CHAR;
658: l_charges_rec.generated_by_bca_engine := 'Y';
659: l_charges_rec.line_category_code := p_sbe_record.line_category_code;
660: l_charges_rec.return_reason_code := p_sbe_record.return_reason_code;
661: l_charges_rec.serial_number := p_sbe_record.serial_number;

Line 780: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

776: x_msg_data => x_msg_data);
777: --DBMS_OUTPUT.PUT_LINE('Labor_start_date' || lx_labor_start_date_time);
778:
779:
780: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
781: FND_MESSAGE.SET_NAME('CS', 'HZ_TIMEZONE_PUB_API_ERR');
782: FND_MSG_PUB.ADD;
783: RAISE EXCP_USER_DEFINED;
784: END IF; */

Line 813: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

809:
810:
811: --DBMS_OUTPUT.PUT_LINE('Labor_end_date' || lx_labor_end_date_time);
812:
813: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
814: FND_MESSAGE.SET_NAME('CS', 'HZ_TIMEZONE_PUB_API_ERR');
815: FND_MSG_PUB.ADD;
816: RAISE EXCP_USER_DEFINED;
817: END IF;

Line 985: p_init_msg_list => FND_API.G_FALSE,

981:
982:
983: oks_con_coverage_pub.get_bill_rates(
984: p_api_version => p_api_version_number,
985: p_init_msg_list => FND_API.G_FALSE,
986: p_input_br_rec => l_input_br_rec,
987: p_labor_sch_tbl => l_labor_sch_tbl,
988: x_return_status => x_return_status,
989: x_msg_count => x_msg_count,

Line 993: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

989: x_msg_count => x_msg_count,
990: x_msg_data => x_msg_data,
991: x_bill_rate_tbl => l_con_lbr_coverage_tbl);
992:
993: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
994: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CON_LBR_COVERAGE_API_ER');
995: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
996: FND_MSG_PUB.ADD;
997: RAISE EXCP_USER_DEFINED;

Line 1150: p_init_msg_list => FND_API.G_FALSE,

1146:
1147: -- Create charge line.
1148: cs_charge_details_pub.Create_Charge_Details(
1149: p_api_version => p_api_version_number,
1150: p_init_msg_list => FND_API.G_FALSE,
1151: p_commit => p_commit,
1152: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1153: x_return_status => x_return_status,
1154: x_msg_count => x_msg_count,

Line 1152: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1148: cs_charge_details_pub.Create_Charge_Details(
1149: p_api_version => p_api_version_number,
1150: p_init_msg_list => FND_API.G_FALSE,
1151: p_commit => p_commit,
1152: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1153: x_return_status => x_return_status,
1154: x_msg_count => x_msg_count,
1155: x_object_version_number => x_object_version_number,
1156: x_msg_data => x_msg_data,

Line 1162: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1158: x_line_number => x_line_number,
1159: p_Charges_Rec => l_charges_rec,
1160: p_create_cost_detail =>l_create_cost_detail, --Added for Service Costing
1161: x_cost_id =>x_cost_id);
1162: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1163: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');
1164: FND_MSG_PUB.ADD;
1165: RAISE EXCP_USER_DEFINED;
1166: END IF;

Line 1199: p_init_msg_list => FND_API.G_FALSE);

1195: x_return_status => x_return_status,
1196: x_msg_count => x_msg_count,
1197: x_msg_data => x_msg_data,
1198: p_api_version => p_api_version_number,
1199: p_init_msg_list => FND_API.G_FALSE);
1200:
1201: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1202: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TM_LBR_SCHEDULE_API_ERR');
1203: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);

Line 1201: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1197: x_msg_data => x_msg_data,
1198: p_api_version => p_api_version_number,
1199: p_init_msg_list => FND_API.G_FALSE);
1200:
1201: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1202: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TM_LBR_SCHEDULE_API_ERR');
1203: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
1204: FND_MSG_PUB.ADD;
1205: RAISE EXCP_USER_DEFINED;

Line 1310: p_init_msg_list => FND_API.G_FALSE,

1306:
1307: -- Create charge line.
1308: cs_charge_details_pub.Create_Charge_Details(
1309: p_api_version => p_api_version_number,
1310: p_init_msg_list => FND_API.G_FALSE,
1311: p_commit => p_commit,
1312: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1313: x_return_status => x_return_status,
1314: x_msg_count => x_msg_count,

Line 1312: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1308: cs_charge_details_pub.Create_Charge_Details(
1309: p_api_version => p_api_version_number,
1310: p_init_msg_list => FND_API.G_FALSE,
1311: p_commit => p_commit,
1312: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1313: x_return_status => x_return_status,
1314: x_msg_count => x_msg_count,
1315: x_object_version_number => x_object_version_number,
1316: x_msg_data => x_msg_data,

Line 1322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1318: x_line_number => x_line_number,
1319: p_Charges_Rec => l_charges_rec,
1320: p_create_cost_detail =>l_create_cost_detail, --Added for Service Costing
1321: x_cost_id =>x_cost_id);
1322: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1323: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');
1324: FND_MSG_PUB.ADD;
1325: RAISE EXCP_USER_DEFINED;
1326: END IF;

Line 1354: p_init_msg_list => FND_API.G_FALSE);

1350: x_return_status => x_return_status,
1351: x_msg_count => x_msg_count,
1352: x_msg_data => x_msg_data,
1353: p_api_version => p_api_version_number,
1354: p_init_msg_list => FND_API.G_FALSE);
1355:
1356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1357: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TM_LBR_SCHEDULE_API_ERR');
1358: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);

Line 1356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1352: x_msg_data => x_msg_data,
1353: p_api_version => p_api_version_number,
1354: p_init_msg_list => FND_API.G_FALSE);
1355:
1356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1357: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TM_LBR_SCHEDULE_API_ERR');
1358: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
1359: FND_MSG_PUB.ADD;
1360: RAISE EXCP_USER_DEFINED;

Line 1452: p_init_msg_list => FND_API.G_FALSE,

1448:
1449: -- Create charge line.
1450: cs_charge_details_pub.Create_Charge_Details(
1451: p_api_version => p_api_version_number,
1452: p_init_msg_list => FND_API.G_FALSE,
1453: p_commit => p_commit,
1454: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1455: x_return_status => x_return_status,
1456: x_msg_count => x_msg_count,

Line 1454: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1450: cs_charge_details_pub.Create_Charge_Details(
1451: p_api_version => p_api_version_number,
1452: p_init_msg_list => FND_API.G_FALSE,
1453: p_commit => p_commit,
1454: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1455: x_return_status => x_return_status,
1456: x_msg_count => x_msg_count,
1457: x_object_version_number => x_object_version_number,
1458: x_msg_data => x_msg_data,

Line 1465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1461: p_Charges_Rec => l_charges_rec,
1462: p_create_cost_detail =>l_create_cost_detail, --Added for Service Costing
1463: x_cost_id =>x_cost_id);
1464:
1465: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1466: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');
1467: FND_MSG_PUB.ADD;
1468: RAISE EXCP_USER_DEFINED;
1469: END IF;

Line 1613: p_init_msg_list => FND_API.G_FALSE,

1609:
1610: -- Create charge line.
1611: cs_charge_details_pub.Create_Charge_Details(
1612: p_api_version => p_api_version_number,
1613: p_init_msg_list => FND_API.G_FALSE,
1614: p_commit => p_commit,
1615: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1616: x_return_status => x_return_status,
1617: x_msg_count => x_msg_count,

Line 1615: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1611: cs_charge_details_pub.Create_Charge_Details(
1612: p_api_version => p_api_version_number,
1613: p_init_msg_list => FND_API.G_FALSE,
1614: p_commit => p_commit,
1615: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1616: x_return_status => x_return_status,
1617: x_msg_count => x_msg_count,
1618: x_object_version_number => x_object_version_number,
1619: x_msg_data => x_msg_data,

Line 1626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1622: p_Charges_Rec => l_charges_rec,
1623: p_create_cost_detail =>'N',
1624: x_cost_id =>x_cost_id);
1625:
1626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1627: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');
1628: FND_MSG_PUB.ADD;
1629: RAISE EXCP_USER_DEFINED;
1630: END IF;

Line 1644: IF FND_API.to_Boolean(p_commit) THEN

1640: --DBMS_OUTPUT.PUT_LINE('----- Private API: ' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS'));
1641: --DBMS_OUTPUT.PUT_LINE('Return status = ' || x_return_status);
1642:
1643: -- Commit if p_commit is true.
1644: IF FND_API.to_Boolean(p_commit) THEN
1645: COMMIT;
1646: END IF;
1647:
1648: -- Exception Block

Line 1652: x_return_status := FND_API.G_RET_STS_ERROR;

1648: -- Exception Block
1649: EXCEPTION
1650: WHEN EXCP_USER_DEFINED THEN
1651: Rollback to Create_Charges;
1652: x_return_status := FND_API.G_RET_STS_ERROR;
1653: fnd_msg_pub.count_and_get(
1654: p_count => x_msg_count
1655: ,p_data => x_msg_data);
1656: WHEN FND_API.G_EXC_ERROR THEN

Line 1656: WHEN FND_API.G_EXC_ERROR THEN

1652: x_return_status := FND_API.G_RET_STS_ERROR;
1653: fnd_msg_pub.count_and_get(
1654: p_count => x_msg_count
1655: ,p_data => x_msg_data);
1656: WHEN FND_API.G_EXC_ERROR THEN
1657: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1658: P_API_NAME => L_API_NAME
1659: ,P_PKG_NAME => G_PKG_NAME
1660: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1661: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1662: ,X_MSG_COUNT => x_MSG_COUNT
1663: ,X_MSG_DATA => x_MSG_DATA
1664: ,X_RETURN_STATUS => x_RETURN_STATUS);
1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1666: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1667: P_API_NAME => L_API_NAME
1668: ,P_PKG_NAME => G_PKG_NAME
1669: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1683: x_return_status := FND_API.G_RET_STS_ERROR;

1679: FND_MSG_PUB.ADD;
1680: fnd_msg_pub.count_and_get(
1681: p_count => x_msg_count
1682: ,p_data => x_msg_data);
1683: x_return_status := FND_API.G_RET_STS_ERROR;
1684:
1685: END Create_Charges;
1686:
1687:

Line 1693: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1689: -- Delete all Billing Engine generated in progress charges for the service request (p_incident_id) passed in.
1690:
1691: PROCEDURE Delete_In_Progress_Charges(
1692: P_Api_Version_Number IN NUMBER,
1693: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1694: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1695: p_incident_id IN NUMBER,
1696: p_debrief_header_id IN NUMBER := NULL, -- Enhancement 2983340
1697: p_debrief_line_id IN NUMBER := NULL, -- To make the API backward compatible

Line 1694: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1690:
1691: PROCEDURE Delete_In_Progress_Charges(
1692: P_Api_Version_Number IN NUMBER,
1693: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1694: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1695: p_incident_id IN NUMBER,
1696: p_debrief_header_id IN NUMBER := NULL, -- Enhancement 2983340
1697: p_debrief_line_id IN NUMBER := NULL, -- To make the API backward compatible
1698: x_return_status OUT NOCOPY VARCHAR2,

Line 1736: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1732: BEGIN
1733: SAVEPOINT Delete_In_Progress_Charges;
1734:
1735: -- Standard call to check for call compatibility.
1736: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1737: p_api_version_number,
1738: l_api_name,
1739: G_PKG_NAME)
1740: THEN

Line 1741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1737: p_api_version_number,
1738: l_api_name,
1739: G_PKG_NAME)
1740: THEN
1741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1742: END IF;
1743:
1744: -- Initialize message list if p_init_msg_list is set to TRUE.
1745: IF FND_API.to_Boolean(p_init_msg_list)

Line 1745: IF FND_API.to_Boolean(p_init_msg_list)

1741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1742: END IF;
1743:
1744: -- Initialize message list if p_init_msg_list is set to TRUE.
1745: IF FND_API.to_Boolean(p_init_msg_list)
1746: THEN
1747: FND_MSG_PUB.initialize;
1748: END IF;
1749:

Line 1794: x_return_status := FND_API.G_RET_STS_SUCCESS;

1790: --DBMS_OUTPUT.PUT_LINE('----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1791: --DBMS_OUTPUT.PUT_LINE('p_incident_id = ' || p_incident_id);
1792:
1793: -- Initialize API return status to SUCCESS
1794: x_return_status := FND_API.G_RET_STS_SUCCESS;
1795:
1796: --Added to Fix Bug # 3539583
1797: IF p_debrief_line_id IS NOT NULL THEN
1798:

Line 1807: p_init_msg_list => FND_API.G_FALSE,

1803: IF l_estimate_detail_id IS NOT NULL THEN
1804:
1805: cs_charge_details_pub.Delete_Charge_Details(
1806: p_api_version => p_api_version_number,
1807: p_init_msg_list => FND_API.G_FALSE,
1808: p_commit => p_commit,
1809: x_return_status => x_return_status,
1810: x_msg_count => x_msg_count,
1811: x_msg_data => x_msg_data,

Line 1815: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1811: x_msg_data => x_msg_data,
1812: p_estimate_detail_id => l_estimate_detail_id,
1813: p_delete_cost_detail =>'N');
1814:
1815: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1816: CLOSE in_progress_charges_csr;
1817: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_DLT_IN_PROGRESS_CHRG_ER');
1818: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
1819: FND_MSG_PUB.ADD;

Line 1845: p_init_msg_list => FND_API.G_FALSE,

1841: --DBMS_OUTPUT.PUT_LINE('Delete l_estimate_detail_id = ' || l_estimate_detail_id);
1842:
1843: cs_charge_details_pub.Delete_Charge_Details(
1844: p_api_version => p_api_version_number,
1845: p_init_msg_list => FND_API.G_FALSE,
1846: p_commit => p_commit,
1847: x_return_status => x_return_status,
1848: x_msg_count => x_msg_count,
1849: x_msg_data => x_msg_data,

Line 1853: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1849: x_msg_data => x_msg_data,
1850: p_estimate_detail_id => l_estimate_detail_id,
1851: p_delete_cost_detail =>'N');
1852:
1853: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1854: CLOSE in_progress_charges_csr;
1855: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_DLT_IN_PROGRESS_CHRG_ER');
1856: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
1857: FND_MSG_PUB.ADD;

Line 1866: IF FND_API.to_Boolean(p_commit) THEN

1862: CLOSE in_progress_charges_csr;
1863: END IF;
1864:
1865: -- Commit if p_commit is TRUE.
1866: IF FND_API.to_Boolean(p_commit) THEN
1867: COMMIT;
1868: END IF;
1869:
1870: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 1884: x_return_status := FND_API.G_RET_STS_ERROR;

1880: -- Exception Block
1881: EXCEPTION
1882: WHEN EXCP_USER_DEFINED THEN
1883: Rollback to Delete_In_Progress_Charges;
1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885: fnd_msg_pub.count_and_get(
1886: p_count => x_msg_count
1887: ,p_data => x_msg_data);
1888: WHEN FND_API.G_EXC_ERROR THEN

Line 1888: WHEN FND_API.G_EXC_ERROR THEN

1884: x_return_status := FND_API.G_RET_STS_ERROR;
1885: fnd_msg_pub.count_and_get(
1886: p_count => x_msg_count
1887: ,p_data => x_msg_data);
1888: WHEN FND_API.G_EXC_ERROR THEN
1889: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1890: P_API_NAME => L_API_NAME
1891: ,P_PKG_NAME => G_PKG_NAME
1892: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1893: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1894: ,X_MSG_COUNT => x_MSG_COUNT
1895: ,X_MSG_DATA => x_MSG_DATA
1896: ,X_RETURN_STATUS => x_RETURN_STATUS);
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1899: P_API_NAME => L_API_NAME
1900: ,P_PKG_NAME => G_PKG_NAME
1901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1915: x_return_status := FND_API.G_RET_STS_ERROR;

1911: FND_MSG_PUB.ADD;
1912: fnd_msg_pub.count_and_get(
1913: p_count => x_msg_count
1914: ,p_data => x_msg_data);
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916:
1917: END Delete_In_Progress_Charges;
1918:
1919: End CS_Service_Billing_Engine_PVT;