DBA Data[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on FND_MESSAGE

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

563: OPEN incident_csr(p_sbe_record.incident_id);
564: 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;
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;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

859: RAISE EXCP_USER_DEFINED;
860: END IF;
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;

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

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

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

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

Line 966: FND_MESSAGE.SET_TOKEN('TEXT', 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;
969: END IF;
970:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1613: ,X_MSG_DATA => x_MSG_DATA
1614: ,X_RETURN_STATUS => x_RETURN_STATUS);
1615: WHEN OTHERS THEN
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(

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

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

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

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

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

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

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

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

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

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

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

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

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

1845: ,X_MSG_DATA => x_MSG_DATA
1846: ,X_RETURN_STATUS => x_RETURN_STATUS);
1847: WHEN OTHERS THEN
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(

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

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

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

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