DBA Data[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on FND_MSG_PUB

Line 333: FND_MSG_PUB.initialize;

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:
336: -- Initialize API return status to SUCCESS
337: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 577: FND_MSG_PUB.ADD;

573: IF incident_csr%NOTFOUND THEN
574: CLOSE incident_csr;
575: FND_MESSAGE.SET_NAME('CS', 'CS_INCIDENT_NOT_FOUND');
576: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_sbe_record.incident_id);
577: FND_MSG_PUB.ADD;
578: RAISE EXCP_USER_DEFINED;
579: END IF;
580: CLOSE incident_csr;
581:

Line 626: FND_MSG_PUB.ADD;

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;
628: END IF;
629: --DBMS_OUTPUT.PUT_LINE('x_contract_id => l_contract_id = ' || l_contract_id);
630: ----DBMS_OUTPUT.PUT_LINE('x_coverage_id => l_coverage_id = ' || l_coverage_id);

Line 715: FND_MSG_PUB.ADD;

711: TO_CHAR(p_sbe_record.labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS') = TO_CHAR(p_sbe_record.labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS') THEN
712: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LBR_DATETIME_REQD');
713: FND_MESSAGE.SET_TOKEN('LABOR_START_DATETIME', TO_CHAR(p_sbe_record.labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS'));
714: FND_MESSAGE.SET_TOKEN('LABOR_END_DATETIME', TO_CHAR(p_sbe_record.labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS'));
715: FND_MSG_PUB.ADD;
716: RAISE EXCP_USER_DEFINED;
717: END IF;
718:
719: -- Convert labor start datetime and end datetime using the new timezone routine

Line 763: FND_MSG_PUB.ADD;

759: lx_labor_start_date_time := fnd_timezone_pub.adjust_datetime(p_sbe_record.labor_start_date_time, l_source_tz_code,l_dest_tz_code);-- bug 14687745
760: Exception
761: When Others Then
762: FND_MESSAGE.SET_NAME('CS', 'HZ_TIMEZONE_PUB_API_ERR');
763: FND_MSG_PUB.ADD;
764: RAISE EXCP_USER_DEFINED;
765: End;
766: -- Commented for bug 11830349
767: /* HZ_TIMEZONE_PUB.Get_time(

Line 782: FND_MSG_PUB.ADD;

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; */
785: END IF;
786:

Line 795: FND_MSG_PUB.ADD;

791: lx_labor_start_date_time := fnd_timezone_pub.adjust_datetime(p_sbe_record.labor_start_date_time, l_source_tz_code,l_dest_tz_code);--bug 14687745
792: Exception
793: When Others Then
794: FND_MESSAGE.SET_NAME('CS', 'HZ_TIMEZONE_PUB_API_ERR');
795: FND_MSG_PUB.ADD;
796: RAISE EXCP_USER_DEFINED;
797: End;
798: -- Commented below code for bug 11830349
799: /* HZ_TIMEZONE_PUB.Get_time(

Line 815: FND_MSG_PUB.ADD;

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;
818: */
819:

Line 885: FND_MSG_PUB.ADD;

881: IF txn_billing_type_csr%NOTFOUND THEN
882: CLOSE txn_billing_type_csr;
883: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TXN_BILLING_TYPE_ERROR');
884: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE_ID', l_charges_rec.transaction_type_id);
885: FND_MSG_PUB.ADD;
886: RAISE EXCP_USER_DEFINED;
887: END IF;
888: CLOSE txn_billing_type_csr;
889: ELSE

Line 892: FND_MSG_PUB.ADD;

888: CLOSE txn_billing_type_csr;
889: ELSE
890: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TXN_BILLING_TYPE_ERROR');
891: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE_ID', l_charges_rec.transaction_type_id);
892: FND_MSG_PUB.ADD;
893: RAISE EXCP_USER_DEFINED;
894: END IF;
895:
896: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 996: FND_MSG_PUB.ADD;

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;
998: END IF;
999:
1000: -- Consolidate contracts labor coverage time segments

Line 1164: FND_MSG_PUB.ADD;

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;
1167:
1168: ELSE -- Not covered by contract.

Line 1204: FND_MSG_PUB.ADD;

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;
1206: END IF;
1207:
1208: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 1324: FND_MSG_PUB.ADD;

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;
1327:
1328: END LOOP;

Line 1359: FND_MSG_PUB.ADD;

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;
1361: END IF;
1362:
1363: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 1467: FND_MSG_PUB.ADD;

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;
1470:
1471: END LOOP;

Line 1628: FND_MSG_PUB.ADD;

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;
1631:
1632: END IF; -- inventory_item_id check

Line 1653: fnd_msg_pub.count_and_get(

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
1657: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 1660: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 1669: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1670: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1671: ,X_MSG_COUNT => x_MSG_COUNT
1672: ,X_MSG_DATA => x_MSG_DATA
1673: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 1679: FND_MSG_PUB.ADD;

1675: Rollback to Create_Charges;
1676: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_UNEXPECTED_EXEC_ERRORS');
1677: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name);
1678: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm);
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;

Line 1680: fnd_msg_pub.count_and_get(

1676: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_UNEXPECTED_EXEC_ERRORS');
1677: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name);
1678: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm);
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:

Line 1747: FND_MSG_PUB.initialize;

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:
1750: ----------------------- FND Logging -----------------------------------
1751: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

Line 1819: FND_MSG_PUB.ADD;

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;
1820: RAISE EXCP_USER_DEFINED;
1821: END IF;
1822:
1823: END IF;

Line 1857: FND_MSG_PUB.ADD;

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;
1858: RAISE EXCP_USER_DEFINED;
1859: END IF;
1860:
1861: END LOOP;

Line 1885: fnd_msg_pub.count_and_get(

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
1889: JTF_PLSQL_API.HANDLE_EXCEPTIONS(

Line 1892: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 1901: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1902: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1903: ,X_MSG_COUNT => x_MSG_COUNT
1904: ,X_MSG_DATA => x_MSG_DATA
1905: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 1911: FND_MSG_PUB.ADD;

1907: Rollback to Delete_In_Progress_Charges;
1908: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_UNEXPECTED_EXEC_ERRORS');
1909: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name);
1910: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm);
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;

Line 1912: fnd_msg_pub.count_and_get(

1908: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_UNEXPECTED_EXEC_ERRORS');
1909: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name);
1910: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm);
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: