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 139: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

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

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

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

Line 314: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

310: BEGIN
311: SAVEPOINT Create_Charges;
312:
313: -- Standard call to check for call compatibility.
314: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
315: p_api_version_number,
316: l_api_name,
317: G_PKG_NAME)
318: THEN

Line 319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

315: p_api_version_number,
316: l_api_name,
317: G_PKG_NAME)
318: THEN
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321:
322: -- Initialize message list if p_init_msg_list is set to TRUE.
323: IF FND_API.to_Boolean(p_init_msg_list)

Line 323: IF FND_API.to_Boolean(p_init_msg_list)

319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: END IF;
321:
322: -- Initialize message list if p_init_msg_list is set to TRUE.
323: IF FND_API.to_Boolean(p_init_msg_list)
324: THEN
325: FND_MSG_PUB.initialize;
326: END IF;
327:

Line 329: x_return_status := FND_API.G_RET_STS_SUCCESS;

325: FND_MSG_PUB.initialize;
326: END IF;
327:
328: -- Initialize API return status to SUCCESS
329: x_return_status := FND_API.G_RET_STS_SUCCESS;
330:
331: ----------------------- FND Logging -----------------------------------
332: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
333: THEN

Line 615: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

611: x_return_status => x_return_status,
612: x_msg_count => x_msg_count,
613: x_msg_data => x_msg_data);
614:
615: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
616: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_GET_CONTRACT_API_ERROR');
617: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
618: FND_MSG_PUB.ADD;
619: RAISE EXCP_USER_DEFINED;

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

642: l_charges_rec.item_revision := p_sbe_record.item_revision;
643: l_charges_rec.customer_product_id := p_sbe_record.customer_product_id;
644: l_charges_rec.installed_cp_return_by_date := p_sbe_record.installed_cp_return_by_date;
645: l_charges_rec.apply_contract_discount := 'Y'; -- Always automatically apply contract discount.
646: l_charges_rec.interface_to_oe_flag := FND_API.G_MISS_CHAR;
647: l_charges_rec.rollup_flag := 'N';
648: l_charges_rec.add_to_order_flag := 'N';
649: l_charges_rec.no_charge_flag := FND_API.G_MISS_CHAR;
650: l_charges_rec.generated_by_bca_engine := 'Y';

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

645: l_charges_rec.apply_contract_discount := 'Y'; -- Always automatically apply contract discount.
646: l_charges_rec.interface_to_oe_flag := FND_API.G_MISS_CHAR;
647: l_charges_rec.rollup_flag := 'N';
648: l_charges_rec.add_to_order_flag := 'N';
649: l_charges_rec.no_charge_flag := FND_API.G_MISS_CHAR;
650: l_charges_rec.generated_by_bca_engine := 'Y';
651: l_charges_rec.line_category_code := p_sbe_record.line_category_code;
652: l_charges_rec.return_reason_code := p_sbe_record.return_reason_code;
653: l_charges_rec.serial_number := p_sbe_record.serial_number;

Line 762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

758: x_msg_data => x_msg_data);
759: --DBMS_OUTPUT.PUT_LINE('Labor_start_date' || lx_labor_start_date_time);
760:
761:
762: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
763: FND_MESSAGE.SET_NAME('CS', 'HZ_TIMEZONE_PUB_API_ERR');
764: FND_MSG_PUB.ADD;
765: RAISE EXCP_USER_DEFINED;
766: END IF;

Line 786: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

782:
783:
784: --DBMS_OUTPUT.PUT_LINE('Labor_end_date' || lx_labor_end_date_time);
785:
786: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
787: FND_MESSAGE.SET_NAME('CS', 'HZ_TIMEZONE_PUB_API_ERR');
788: FND_MSG_PUB.ADD;
789: RAISE EXCP_USER_DEFINED;
790: END IF;

Line 956: p_init_msg_list => FND_API.G_FALSE,

952:
953: -- Get Contract labor coverage billing data.
954: oks_con_coverage_pub.get_bill_rates(
955: p_api_version => p_api_version_number,
956: p_init_msg_list => FND_API.G_FALSE,
957: p_input_br_rec => l_input_br_rec,
958: p_labor_sch_tbl => l_labor_sch_tbl,
959: x_return_status => x_return_status,
960: x_msg_count => x_msg_count,

Line 964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

960: x_msg_count => x_msg_count,
961: x_msg_data => x_msg_data,
962: x_bill_rate_tbl => l_con_lbr_coverage_tbl);
963:
964: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
965: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CON_LBR_COVERAGE_API_ER');
966: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
967: FND_MSG_PUB.ADD;
968: RAISE EXCP_USER_DEFINED;

Line 1114: p_init_msg_list => FND_API.G_FALSE,

1110:
1111: -- Create charge line.
1112: cs_charge_details_pub.Create_Charge_Details(
1113: p_api_version => p_api_version_number,
1114: p_init_msg_list => FND_API.G_FALSE,
1115: p_commit => p_commit,
1116: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1117: x_return_status => x_return_status,
1118: x_msg_count => x_msg_count,

Line 1116: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1112: cs_charge_details_pub.Create_Charge_Details(
1113: p_api_version => p_api_version_number,
1114: p_init_msg_list => FND_API.G_FALSE,
1115: p_commit => p_commit,
1116: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1117: x_return_status => x_return_status,
1118: x_msg_count => x_msg_count,
1119: x_object_version_number => x_object_version_number,
1120: x_msg_data => x_msg_data,

Line 1126: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1122: x_line_number => x_line_number,
1123: p_Charges_Rec => l_charges_rec,
1124: p_create_cost_detail =>l_create_cost_detail, --Added for Service Costing
1125: x_cost_id =>x_cost_id);
1126: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1127: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');
1128: FND_MSG_PUB.ADD;
1129: RAISE EXCP_USER_DEFINED;
1130: END IF;

Line 1163: p_init_msg_list => FND_API.G_FALSE);

1159: x_return_status => x_return_status,
1160: x_msg_count => x_msg_count,
1161: x_msg_data => x_msg_data,
1162: p_api_version => p_api_version_number,
1163: p_init_msg_list => FND_API.G_FALSE);
1164:
1165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1166: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TM_LBR_SCHEDULE_API_ERR');
1167: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);

Line 1165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1161: x_msg_data => x_msg_data,
1162: p_api_version => p_api_version_number,
1163: p_init_msg_list => FND_API.G_FALSE);
1164:
1165: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1166: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TM_LBR_SCHEDULE_API_ERR');
1167: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
1168: FND_MSG_PUB.ADD;
1169: RAISE EXCP_USER_DEFINED;

Line 1265: p_init_msg_list => FND_API.G_FALSE,

1261:
1262: -- Create charge line.
1263: cs_charge_details_pub.Create_Charge_Details(
1264: p_api_version => p_api_version_number,
1265: p_init_msg_list => FND_API.G_FALSE,
1266: p_commit => p_commit,
1267: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1268: x_return_status => x_return_status,
1269: x_msg_count => x_msg_count,

Line 1267: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1263: cs_charge_details_pub.Create_Charge_Details(
1264: p_api_version => p_api_version_number,
1265: p_init_msg_list => FND_API.G_FALSE,
1266: p_commit => p_commit,
1267: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1268: x_return_status => x_return_status,
1269: x_msg_count => x_msg_count,
1270: x_object_version_number => x_object_version_number,
1271: x_msg_data => x_msg_data,

Line 1277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1273: x_line_number => x_line_number,
1274: p_Charges_Rec => l_charges_rec,
1275: p_create_cost_detail =>l_create_cost_detail, --Added for Service Costing
1276: x_cost_id =>x_cost_id);
1277: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1278: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');
1279: FND_MSG_PUB.ADD;
1280: RAISE EXCP_USER_DEFINED;
1281: END IF;

Line 1309: p_init_msg_list => FND_API.G_FALSE);

1305: x_return_status => x_return_status,
1306: x_msg_count => x_msg_count,
1307: x_msg_data => x_msg_data,
1308: p_api_version => p_api_version_number,
1309: p_init_msg_list => FND_API.G_FALSE);
1310:
1311: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1312: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TM_LBR_SCHEDULE_API_ERR');
1313: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);

Line 1311: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1307: x_msg_data => x_msg_data,
1308: p_api_version => p_api_version_number,
1309: p_init_msg_list => FND_API.G_FALSE);
1310:
1311: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1312: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TM_LBR_SCHEDULE_API_ERR');
1313: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
1314: FND_MSG_PUB.ADD;
1315: RAISE EXCP_USER_DEFINED;

Line 1407: p_init_msg_list => FND_API.G_FALSE,

1403:
1404: -- Create charge line.
1405: cs_charge_details_pub.Create_Charge_Details(
1406: p_api_version => p_api_version_number,
1407: p_init_msg_list => FND_API.G_FALSE,
1408: p_commit => p_commit,
1409: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1410: x_return_status => x_return_status,
1411: x_msg_count => x_msg_count,

Line 1409: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1405: cs_charge_details_pub.Create_Charge_Details(
1406: p_api_version => p_api_version_number,
1407: p_init_msg_list => FND_API.G_FALSE,
1408: p_commit => p_commit,
1409: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1410: x_return_status => x_return_status,
1411: x_msg_count => x_msg_count,
1412: x_object_version_number => x_object_version_number,
1413: x_msg_data => x_msg_data,

Line 1420: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1416: p_Charges_Rec => l_charges_rec,
1417: p_create_cost_detail =>l_create_cost_detail, --Added for Service Costing
1418: x_cost_id =>x_cost_id);
1419:
1420: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1421: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');
1422: FND_MSG_PUB.ADD;
1423: RAISE EXCP_USER_DEFINED;
1424: END IF;

Line 1554: p_init_msg_list => FND_API.G_FALSE,

1550:
1551: -- Create charge line.
1552: cs_charge_details_pub.Create_Charge_Details(
1553: p_api_version => p_api_version_number,
1554: p_init_msg_list => FND_API.G_FALSE,
1555: p_commit => p_commit,
1556: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1557: x_return_status => x_return_status,
1558: x_msg_count => x_msg_count,

Line 1556: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1552: cs_charge_details_pub.Create_Charge_Details(
1553: p_api_version => p_api_version_number,
1554: p_init_msg_list => FND_API.G_FALSE,
1555: p_commit => p_commit,
1556: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1557: x_return_status => x_return_status,
1558: x_msg_count => x_msg_count,
1559: x_object_version_number => x_object_version_number,
1560: x_msg_data => x_msg_data,

Line 1567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1563: p_Charges_Rec => l_charges_rec,
1564: p_create_cost_detail =>'N',
1565: x_cost_id =>x_cost_id);
1566:
1567: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1568: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');
1569: FND_MSG_PUB.ADD;
1570: RAISE EXCP_USER_DEFINED;
1571: END IF;

Line 1585: IF FND_API.to_Boolean(p_commit) THEN

1581: --DBMS_OUTPUT.PUT_LINE('----- Private API: ' || g_pkg_name || '.' || l_api_name || ' ends at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SSSSS'));
1582: --DBMS_OUTPUT.PUT_LINE('Return status = ' || x_return_status);
1583:
1584: -- Commit if p_commit is true.
1585: IF FND_API.to_Boolean(p_commit) THEN
1586: COMMIT;
1587: END IF;
1588:
1589: -- Exception Block

Line 1593: x_return_status := FND_API.G_RET_STS_ERROR;

1589: -- Exception Block
1590: EXCEPTION
1591: WHEN EXCP_USER_DEFINED THEN
1592: Rollback to Create_Charges;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: fnd_msg_pub.count_and_get(
1595: p_count => x_msg_count
1596: ,p_data => x_msg_data);
1597: WHEN FND_API.G_EXC_ERROR THEN

Line 1597: WHEN FND_API.G_EXC_ERROR THEN

1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: fnd_msg_pub.count_and_get(
1595: p_count => x_msg_count
1596: ,p_data => x_msg_data);
1597: WHEN FND_API.G_EXC_ERROR THEN
1598: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1599: P_API_NAME => L_API_NAME
1600: ,P_PKG_NAME => G_PKG_NAME
1601: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1602: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1603: ,X_MSG_COUNT => x_MSG_COUNT
1604: ,X_MSG_DATA => x_MSG_DATA
1605: ,X_RETURN_STATUS => x_RETURN_STATUS);
1606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1607: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1608: P_API_NAME => L_API_NAME
1609: ,P_PKG_NAME => G_PKG_NAME
1610: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1624: x_return_status := FND_API.G_RET_STS_ERROR;

1620: FND_MSG_PUB.ADD;
1621: fnd_msg_pub.count_and_get(
1622: p_count => x_msg_count
1623: ,p_data => x_msg_data);
1624: x_return_status := FND_API.G_RET_STS_ERROR;
1625:
1626: END Create_Charges;
1627:
1628:

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

1630: -- Delete all Billing Engine generated in progress charges for the service request (p_incident_id) passed in.
1631:
1632: PROCEDURE Delete_In_Progress_Charges(
1633: P_Api_Version_Number IN NUMBER,
1634: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1635: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1636: p_incident_id IN NUMBER,
1637: p_debrief_header_id IN NUMBER := NULL, -- Enhancement 2983340
1638: p_debrief_line_id IN NUMBER := NULL, -- To make the API backward compatible

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

1631:
1632: PROCEDURE Delete_In_Progress_Charges(
1633: P_Api_Version_Number IN NUMBER,
1634: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1635: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1636: p_incident_id IN NUMBER,
1637: p_debrief_header_id IN NUMBER := NULL, -- Enhancement 2983340
1638: p_debrief_line_id IN NUMBER := NULL, -- To make the API backward compatible
1639: x_return_status OUT NOCOPY VARCHAR2,

Line 1677: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1673: BEGIN
1674: SAVEPOINT Delete_In_Progress_Charges;
1675:
1676: -- Standard call to check for call compatibility.
1677: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1678: p_api_version_number,
1679: l_api_name,
1680: G_PKG_NAME)
1681: THEN

Line 1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1678: p_api_version_number,
1679: l_api_name,
1680: G_PKG_NAME)
1681: THEN
1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684:
1685: -- Initialize message list if p_init_msg_list is set to TRUE.
1686: IF FND_API.to_Boolean(p_init_msg_list)

Line 1686: IF FND_API.to_Boolean(p_init_msg_list)

1682: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1683: END IF;
1684:
1685: -- Initialize message list if p_init_msg_list is set to TRUE.
1686: IF FND_API.to_Boolean(p_init_msg_list)
1687: THEN
1688: FND_MSG_PUB.initialize;
1689: END IF;
1690:

Line 1735: x_return_status := FND_API.G_RET_STS_SUCCESS;

1731: --DBMS_OUTPUT.PUT_LINE('----- Private API: ' || g_pkg_name || '.' || l_api_name || ' starts at ' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1732: --DBMS_OUTPUT.PUT_LINE('p_incident_id = ' || p_incident_id);
1733:
1734: -- Initialize API return status to SUCCESS
1735: x_return_status := FND_API.G_RET_STS_SUCCESS;
1736:
1737: --Added to Fix Bug # 3539583
1738: IF p_debrief_line_id IS NOT NULL THEN
1739:

Line 1748: p_init_msg_list => FND_API.G_FALSE,

1744: IF l_estimate_detail_id IS NOT NULL THEN
1745:
1746: cs_charge_details_pub.Delete_Charge_Details(
1747: p_api_version => p_api_version_number,
1748: p_init_msg_list => FND_API.G_FALSE,
1749: p_commit => p_commit,
1750: x_return_status => x_return_status,
1751: x_msg_count => x_msg_count,
1752: x_msg_data => x_msg_data,

Line 1756: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1752: x_msg_data => x_msg_data,
1753: p_estimate_detail_id => l_estimate_detail_id,
1754: p_delete_cost_detail =>'N');
1755:
1756: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1757: CLOSE in_progress_charges_csr;
1758: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_DLT_IN_PROGRESS_CHRG_ER');
1759: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
1760: FND_MSG_PUB.ADD;

Line 1786: p_init_msg_list => FND_API.G_FALSE,

1782: --DBMS_OUTPUT.PUT_LINE('Delete l_estimate_detail_id = ' || l_estimate_detail_id);
1783:
1784: cs_charge_details_pub.Delete_Charge_Details(
1785: p_api_version => p_api_version_number,
1786: p_init_msg_list => FND_API.G_FALSE,
1787: p_commit => p_commit,
1788: x_return_status => x_return_status,
1789: x_msg_count => x_msg_count,
1790: x_msg_data => x_msg_data,

Line 1794: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1790: x_msg_data => x_msg_data,
1791: p_estimate_detail_id => l_estimate_detail_id,
1792: p_delete_cost_detail =>'N');
1793:
1794: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1795: CLOSE in_progress_charges_csr;
1796: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_DLT_IN_PROGRESS_CHRG_ER');
1797: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);
1798: FND_MSG_PUB.ADD;

Line 1807: IF FND_API.to_Boolean(p_commit) THEN

1803: CLOSE in_progress_charges_csr;
1804: END IF;
1805:
1806: -- Commit if p_commit is TRUE.
1807: IF FND_API.to_Boolean(p_commit) THEN
1808: COMMIT;
1809: END IF;
1810:
1811: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 1825: x_return_status := FND_API.G_RET_STS_ERROR;

1821: -- Exception Block
1822: EXCEPTION
1823: WHEN EXCP_USER_DEFINED THEN
1824: Rollback to Delete_In_Progress_Charges;
1825: x_return_status := FND_API.G_RET_STS_ERROR;
1826: fnd_msg_pub.count_and_get(
1827: p_count => x_msg_count
1828: ,p_data => x_msg_data);
1829: WHEN FND_API.G_EXC_ERROR THEN

Line 1829: WHEN FND_API.G_EXC_ERROR THEN

1825: x_return_status := FND_API.G_RET_STS_ERROR;
1826: fnd_msg_pub.count_and_get(
1827: p_count => x_msg_count
1828: ,p_data => x_msg_data);
1829: WHEN FND_API.G_EXC_ERROR THEN
1830: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1831: P_API_NAME => L_API_NAME
1832: ,P_PKG_NAME => G_PKG_NAME
1833: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1834: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1835: ,X_MSG_COUNT => x_MSG_COUNT
1836: ,X_MSG_DATA => x_MSG_DATA
1837: ,X_RETURN_STATUS => x_RETURN_STATUS);
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
1840: P_API_NAME => L_API_NAME
1841: ,P_PKG_NAME => G_PKG_NAME
1842: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1856: x_return_status := FND_API.G_RET_STS_ERROR;

1852: FND_MSG_PUB.ADD;
1853: fnd_msg_pub.count_and_get(
1854: p_count => x_msg_count
1855: ,p_data => x_msg_data);
1856: x_return_status := FND_API.G_RET_STS_ERROR;
1857:
1858: END Delete_In_Progress_Charges;
1859:
1860: End CS_Service_Billing_Engine_PVT;