APPS.CS_CONTRACTS_PUB dependencies on CS_CP_SERVICES_ALL

Line 304: set_msg_no_children('CS_CP_SERVICES_ALL', 'CS_COVERAGES');

300: p_coverages_tbl IN coverages_tbl_type
301: ) IS
302: BEGIN
303: IF (p_coverages_tbl.COUNT = 0) THEN
304: set_msg_no_children('CS_CP_SERVICES_ALL', 'CS_COVERAGES');
305: l_return_status := FND_API.G_RET_STS_ERROR;
306: RAISE l_return_error_exc;
307: END IF;
308: END verify_cov_children_exist;

Line 420: FROM cs_cp_services_all

416: l_return_error_exc EXCEPTION;
417:
418: CURSOR chk_csr (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS
419: SELECT *
420: FROM cs_cp_services_all
421: WHERE contract_id = p_contract_id;
422:
423: l_services_all_tbl services_all_tbl_type;
424: ---------------------------------

Line 435: -- While the 2 columns are allowed to be NULL in CS_CP_SERVICES_ALL,

431: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
432: BEGIN
433: ----------------------------------------------------------------------
434: -- Check FIRST_BILL_DATE and BILLING_FREQUENCY_PERIOD are NOT NULL.
435: -- While the 2 columns are allowed to be NULL in CS_CP_SERVICES_ALL,
436: -- the columns should not be NULL for a contract.
437: -- If the fields are null in CS_CP_SERVICES_ALL, as well as
438: -- CS_CONTRACTS_ALL then give a warning.
439: ----------------------------------------------------------------------

Line 437: -- If the fields are null in CS_CP_SERVICES_ALL, as well as

433: ----------------------------------------------------------------------
434: -- Check FIRST_BILL_DATE and BILLING_FREQUENCY_PERIOD are NOT NULL.
435: -- While the 2 columns are allowed to be NULL in CS_CP_SERVICES_ALL,
436: -- the columns should not be NULL for a contract.
437: -- If the fields are null in CS_CP_SERVICES_ALL, as well as
438: -- CS_CONTRACTS_ALL then give a warning.
439: ----------------------------------------------------------------------
440: IF ((p_services_all_rec.FIRST_BILL_DATE IS NULL)
441: AND (p_contract_rec.FIRST_BILL_DATE IS NULL)) THEN

Line 538: set_msg_no_children('CS_CONTRACTS_ALL', 'CS_CP_SERVICES_ALL');

534: FOR l_csr_rec IN chk_csr(p_contract_rec.contract_id) LOOP
535: l_services_all_tbl(chk_csr%ROWCOUNT) := l_csr_rec;
536: END LOOP;
537: IF (l_services_all_tbl.COUNT = 0) THEN
538: set_msg_no_children('CS_CONTRACTS_ALL', 'CS_CP_SERVICES_ALL');
539: l_return_status := FND_API.G_RET_STS_ERROR;
540: RAISE l_return_error_exc;
541: END IF;
542:

Line 569: -- Validate children of CS_CP_SERVICES_ALL

565: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
566: RAISE l_return_error_exc;
567: END IF;
568: ------------------------------------------
569: -- Validate children of CS_CP_SERVICES_ALL
570: ------------------------------------------
571: l_return_status := val_coverage_levels_children(l_services_all_tbl(l_index));
572: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
573: RAISE l_return_error_exc;