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