DBA Data[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on FND_MSG_PUB

Line 325: FND_MSG_PUB.initialize;

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

Line 569: FND_MSG_PUB.ADD;

565: IF incident_csr%NOTFOUND THEN
566: CLOSE incident_csr;
567: FND_MESSAGE.SET_NAME('CS', 'CS_INCIDENT_NOT_FOUND');
568: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_sbe_record.incident_id);
569: FND_MSG_PUB.ADD;
570: RAISE EXCP_USER_DEFINED;
571: END IF;
572: CLOSE incident_csr;
573:

Line 618: FND_MSG_PUB.ADD;

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;
620: END IF;
621: --DBMS_OUTPUT.PUT_LINE('x_contract_id => l_contract_id = ' || l_contract_id);
622: ----DBMS_OUTPUT.PUT_LINE('x_coverage_id => l_coverage_id = ' || l_coverage_id);

Line 714: FND_MSG_PUB.ADD;

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

Line 764: FND_MSG_PUB.ADD;

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;
767: END IF;
768:

Line 788: FND_MSG_PUB.ADD;

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;
791:
792:

Line 858: FND_MSG_PUB.ADD;

854: IF txn_billing_type_csr%NOTFOUND THEN
855: CLOSE txn_billing_type_csr;
856: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TXN_BILLING_TYPE_ERROR');
857: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE_ID', l_charges_rec.transaction_type_id);
858: FND_MSG_PUB.ADD;
859: RAISE EXCP_USER_DEFINED;
860: END IF;
861: CLOSE txn_billing_type_csr;
862: ELSE

Line 865: FND_MSG_PUB.ADD;

861: CLOSE txn_billing_type_csr;
862: ELSE
863: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TXN_BILLING_TYPE_ERROR');
864: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE_ID', l_charges_rec.transaction_type_id);
865: FND_MSG_PUB.ADD;
866: RAISE EXCP_USER_DEFINED;
867: END IF;
868:
869: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 967: FND_MSG_PUB.ADD;

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;
969: END IF;
970:
971: -- Consolidate contracts labor coverage time segments

Line 1128: FND_MSG_PUB.ADD;

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

Line 1168: FND_MSG_PUB.ADD;

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;
1170: END IF;
1171:
1172: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 1279: FND_MSG_PUB.ADD;

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;
1282:
1283: END LOOP;

Line 1314: FND_MSG_PUB.ADD;

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;
1316: END IF;
1317:
1318: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

Line 1422: FND_MSG_PUB.ADD;

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;
1425:
1426: END LOOP;

Line 1569: FND_MSG_PUB.ADD;

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;
1572:
1573: END IF; -- inventory_item_id check

Line 1594: fnd_msg_pub.count_and_get(

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

Line 1601: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 1610: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1611: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1612: ,X_MSG_COUNT => x_MSG_COUNT
1613: ,X_MSG_DATA => x_MSG_DATA
1614: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 1620: FND_MSG_PUB.ADD;

1616: Rollback to Create_Charges;
1617: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_UNEXPECTED_EXEC_ERRORS');
1618: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name);
1619: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm);
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;

Line 1621: fnd_msg_pub.count_and_get(

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

Line 1688: FND_MSG_PUB.initialize;

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

Line 1760: FND_MSG_PUB.ADD;

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;
1761: RAISE EXCP_USER_DEFINED;
1762: END IF;
1763:
1764: END IF;

Line 1798: FND_MSG_PUB.ADD;

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;
1799: RAISE EXCP_USER_DEFINED;
1800: END IF;
1801:
1802: END LOOP;

Line 1826: fnd_msg_pub.count_and_get(

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

Line 1833: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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

Line 1842: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
1843: ,P_PACKAGE_TYPE => JTF_PLSQL_API.G_PUB
1844: ,X_MSG_COUNT => x_MSG_COUNT
1845: ,X_MSG_DATA => x_MSG_DATA
1846: ,X_RETURN_STATUS => x_RETURN_STATUS);

Line 1852: FND_MSG_PUB.ADD;

1848: Rollback to Delete_In_Progress_Charges;
1849: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_UNEXPECTED_EXEC_ERRORS');
1850: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name);
1851: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm);
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;

Line 1853: fnd_msg_pub.count_and_get(

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