DBA Data[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on FND_MESSAGE

Line 575: FND_MESSAGE.SET_NAME('CS', 'CS_INCIDENT_NOT_FOUND');

571: OPEN incident_csr(p_sbe_record.incident_id);
572: FETCH incident_csr into l_incident_date, l_creation_date, l_customer_id, l_account_id, l_customer_product_id, l_contract_id, l_contract_service_id;
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;

Line 576: FND_MESSAGE.SET_TOKEN('INCIDENT_ID', p_sbe_record.incident_id);

572: FETCH incident_csr into l_incident_date, l_creation_date, l_customer_id, l_account_id, l_customer_product_id, l_contract_id, l_contract_service_id;
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;

Line 624: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_GET_CONTRACT_API_ERROR');

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

Line 625: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);

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

Line 712: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_LBR_DATETIME_REQD');

708: -- Validate if the start datetime and end datetime are passed in and are not the same.
709: IF p_sbe_record.labor_start_date_time IS NULL OR
710: p_sbe_record.labor_end_date_time IS NULL OR
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;

Line 713: FND_MESSAGE.SET_TOKEN('LABOR_START_DATETIME', TO_CHAR(p_sbe_record.labor_start_date_time, 'DD-MON-YYYY HH24:MI:SS'));

709: IF p_sbe_record.labor_start_date_time IS NULL OR
710: p_sbe_record.labor_end_date_time IS NULL OR
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;

Line 714: FND_MESSAGE.SET_TOKEN('LABOR_END_DATETIME', TO_CHAR(p_sbe_record.labor_end_date_time, 'DD-MON-YYYY HH24:MI:SS'));

710: p_sbe_record.labor_end_date_time IS NULL OR
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:

Line 762: FND_MESSAGE.SET_NAME('CS', 'HZ_TIMEZONE_PUB_API_ERR');

758: --x_dest_day_time := fnd_timezone_pub.adjust_datetime(p_sbe_record.labor_start_date_time, l_source_tz_code,l_dest_tz_code); -- Bug 11830349
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

Line 781: FND_MESSAGE.SET_NAME('CS', 'HZ_TIMEZONE_PUB_API_ERR');

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

Line 794: FND_MESSAGE.SET_NAME('CS', 'HZ_TIMEZONE_PUB_API_ERR');

790: --x_dest_day_time := fnd_timezone_pub.adjust_datetime(p_sbe_record.labor_end_date_time, l_source_tz_code,l_dest_tz_code); -- Bug 11830349
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

Line 814: FND_MESSAGE.SET_NAME('CS', 'HZ_TIMEZONE_PUB_API_ERR');

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

Line 883: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TXN_BILLING_TYPE_ERROR');

879: OPEN txn_billing_type_csr(l_charges_rec.transaction_type_id,'L');
880: FETCH txn_billing_type_csr into l_charges_rec.txn_billing_type_id;
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;

Line 884: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE_ID', l_charges_rec.transaction_type_id);

880: FETCH txn_billing_type_csr into l_charges_rec.txn_billing_type_id;
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;

Line 890: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TXN_BILLING_TYPE_ERROR');

886: RAISE EXCP_USER_DEFINED;
887: END IF;
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;

Line 891: FND_MESSAGE.SET_TOKEN('TRANSACTION_TYPE_ID', l_charges_rec.transaction_type_id);

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

Line 994: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CON_LBR_COVERAGE_API_ER');

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

Line 995: FND_MESSAGE.SET_TOKEN('TEXT', 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;
998: END IF;
999:

Line 1163: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');

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;
1167:

Line 1202: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TM_LBR_SCHEDULE_API_ERR');

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

Line 1203: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);

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;
1206: END IF;
1207:

Line 1323: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');

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;
1327:

Line 1357: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_TM_LBR_SCHEDULE_API_ERR');

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

Line 1358: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);

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;
1361: END IF;
1362:

Line 1466: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');

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;
1470:

Line 1627: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_CHARGE_DETAILS_API_ERR');

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;
1631:

Line 1676: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_UNEXPECTED_EXEC_ERRORS');

1672: ,X_MSG_DATA => x_MSG_DATA
1673: ,X_RETURN_STATUS => x_RETURN_STATUS);
1674: WHEN OTHERS THEN
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(

Line 1677: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name);

1673: ,X_RETURN_STATUS => x_RETURN_STATUS);
1674: WHEN OTHERS THEN
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

Line 1678: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm);

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

Line 1817: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_DLT_IN_PROGRESS_CHRG_ER');

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

Line 1818: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);

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

Line 1855: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_DLT_IN_PROGRESS_CHRG_ER');

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

Line 1856: FND_MESSAGE.SET_TOKEN('TEXT', x_msg_data);

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

Line 1908: FND_MESSAGE.SET_NAME('CS', 'CS_CHG_UNEXPECTED_EXEC_ERRORS');

1904: ,X_MSG_DATA => x_MSG_DATA
1905: ,X_RETURN_STATUS => x_RETURN_STATUS);
1906: WHEN OTHERS THEN
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(

Line 1909: FND_MESSAGE.SET_TOKEN('ROUTINE', l_api_name);

1905: ,X_RETURN_STATUS => x_RETURN_STATUS);
1906: WHEN OTHERS THEN
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

Line 1910: FND_MESSAGE.SET_TOKEN('SQLERRM', sqlerrm);

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