eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CONTRACTS_PUB dependencies on FND_API

Line 114: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

110: FUNCTION val_cov_txn_grps_children (
111: p_coverages_rec IN coverages_rec_type
112: ) RETURN VARCHAR2 IS
113: l_index NUMBER;
114: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
115: l_return_error_exc EXCEPTION;
116: CURSOR chk_csr (p_coverage_id IN CS_COVERAGE_TXN_GROUPS.COVERAGE_ID%TYPE) IS
117: SELECT *
118: FROM cs_coverage_txn_groups

Line 128: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

124: FUNCTION val_start_end_dates (
125: p_cov_txn_grps_rec IN coverage_txn_groups_rec_type,
126: p_coverages_rec IN coverages_rec_type
127: ) RETURN VARCHAR2 IS
128: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
129: l_return_error_exc EXCEPTION;
130: BEGIN
131: -- Validate START and END dates of Coverage_Txn_Groups fall within the
132: -- START and END dates of CS_COVERAGES

Line 154: l_return_status := FND_API.G_RET_STS_ERROR;

150: END IF;
151: RETURN(l_return_status);
152: EXCEPTION
153: WHEN l_return_error_exc THEN
154: l_return_status := FND_API.G_RET_STS_ERROR;
155: RETURN(l_return_status);
156: END val_start_end_dates;
157: BEGIN
158: FOR l_rec IN chk_csr (p_coverages_rec.coverage_id) LOOP

Line 169: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

165: -- Validate START and END dates of Coverage_Txn_Groups fall within the
166: -- START and END dates of CS_COVERAGES
167: -----------------------------------------------------------------------
168: l_return_status := val_start_end_dates(l_cov_txn_grps_tbl(l_index), p_coverages_rec);
169: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
170: RAISE l_return_error_exc;
171: END IF;
172: EXIT WHEN (l_index >= l_cov_txn_grps_tbl.LAST);
173: l_index := l_cov_txn_grps_tbl.NEXT(l_index);

Line 207: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

203: --------------------------------------------------------------------------------
204: FUNCTION val_coverage_levels_children (
205: p_services_rec IN services_all_rec_type
206: ) RETURN VARCHAR2 IS
207: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
208: l_index NUMBER := 0;
209: l_return_error_exc EXCEPTION;
210: l_children_exist BOOLEAN := FALSE;
211:

Line 262: l_return_status := FND_API.G_RET_STS_ERROR;

258: (l_children_exist)) THEN
259: FND_MESSAGE.set_name(G_APP_NAME, G_INCOMPATIBLE_CONTRACT_LEVELS);
260: FND_MESSAGE.set_token('SERVICE_ID',
261: get_service_name(p_services_rec));
262: l_return_status := FND_API.G_RET_STS_ERROR;
263: RAISE l_return_error_exc;
264: END IF;
265: EXIT WHEN (l_index >= l_cov_lvls_tbl.LAST);
266: l_index := l_cov_lvls_tbl.NEXT(l_index);

Line 271: l_return_status := FND_API.G_RET_STS_ERROR;

267: END LOOP;
268: ELSE -- No children in CS_CONTRACT_COVERAGE_LEVEL for CS_CP_SERVICE_ALL,
269: -- RAISE ERROR
270: set_msg_no_children('CS_CP_SERVICE_ALL', 'CS_CONTRACT_COVERAGE_LEVEL');
271: l_return_status := FND_API.G_RET_STS_ERROR;
272: RAISE l_return_error_exc;
273: END IF;
274:
275: RETURN(l_return_status);

Line 286: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

282: --------------------------------------------------------------------------------
283: FUNCTION val_coverages_children (
284: p_services_rec IN services_all_rec_type
285: ) RETURN VARCHAR2 IS
286: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
287: l_index NUMBER := 0;
288: l_return_error_exc EXCEPTION;
289:
290: CURSOR chk_csr (p_coverage_id IN CS_COVERAGES.COVERAGE_ID%TYPE) IS

Line 305: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 323: l_return_status := FND_API.G_RET_STS_ERROR;

319: IF (p_coverages_tbl(i).TEMPLATE_FLAG = 'Y') THEN
320: FND_MESSAGE.set_name(G_APP_NAME, G_SERVICE_ATTACHED_TO_TEMPLATE);
321: FND_MESSAGE.set_token('SERVICE_ID',get_service_name(p_services_rec));
322: FND_MESSAGE.set_token('TEMPLATE_NAME', p_coverages_tbl(i).name);
323: l_return_status := FND_API.G_RET_STS_ERROR;
324: RAISE l_return_error_exc;
325: END IF;
326: EXIT WHEN (i >= p_coverages_tbl.LAST);
327: i := p_coverages_tbl.NEXT(i);

Line 337: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

333: FUNCTION val_start_end_dates (
334: p_coverages_rec IN coverages_rec_type,
335: p_services_rec IN services_all_rec_type
336: ) RETURN VARCHAR2 IS
337: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
338: l_return_error_exc EXCEPTION;
339: BEGIN
340: -- Validate START and END dates of Coverages fall within the
341: -- START and END dates of CS_CP_SERVICES

Line 358: l_return_status := FND_API.G_RET_STS_ERROR;

354: END IF;
355: RETURN (l_return_status);
356: EXCEPTION
357: WHEN l_return_error_exc THEN
358: l_return_status := FND_API.G_RET_STS_ERROR;
359: RETURN (l_return_status);
360: END val_start_end_dates;
361: BEGIN
362: FOR l_rec IN chk_csr(p_services_rec.coverage_schedule_id) LOOP

Line 381: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

377: -- Validate START and END dates of the Coverages fall withing the
378: -- START and END dates of CS_CP_SERVICES
379: ------------------------------------------------------------------
380: l_return_status:= val_start_end_dates (l_coverages_tbl(l_index), p_services_rec);
381: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
382: RAISE l_return_error_exc;
383: END IF;
384: ------------------------------------------------------------------------------
385: -- An optional relationship exists between CS_COVERAGES and

Line 395: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

391: -- in CS_COV_TXN_GRP_CTRS.
392: ------------------------------------------------------------------------------
393: IF (cov_txn_grp_children_exist(l_coverages_tbl(l_index))) THEN
394: l_return_status := val_cov_txn_grps_children (l_coverages_tbl(l_index));
395: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
396: RAISE l_return_error_exc;
397: END IF;
398: END IF;
399: EXIT WHEN (l_index >= l_coverages_tbl.LAST);

Line 415: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

411: FUNCTION val_services_children (
412: p_contract_rec IN contract_rec_type
413: ) RETURN VARCHAR2 IS
414: l_index NUMBER := 0;
415: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
416: l_return_error_exc EXCEPTION;
417:
418: CURSOR chk_csr (p_contract_id IN CS_CONTRACTS_ALL.CONTRACT_ID%TYPE) IS
419: SELECT *

Line 431: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

427: FUNCTION val_services_items (
428: p_services_all_rec IN services_all_rec_type,
429: p_contract_rec IN contract_rec_type
430: ) RETURN VARCHAR2 IS
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,

Line 462: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

458: -------------------------------------
459: FUNCTION check_coverage_overlap (
460: p_services_rec services_all_rec_type
461: ) RETURN VARCHAR2 IS
462: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
463: l_return_error_exc EXCEPTION;
464: l_overlap_flag VARCHAR2(1) := 'N';
465: CURSOR chk_csr (p_cp_service_id IN CS_CONTRACT_COV_LEVELS.CP_SERVICE_ID%TYPE) IS
466: SELECT *

Line 496: l_return_status := FND_API.G_RET_STS_ERROR;

492: x_msg_count => x_msg_count,
493: x_msg_data => x_msg_data);
494: IF (l_overlap_flag = 'Y') THEN
495: FND_MESSAGE.set_name(G_APP_NAME, G_COVERAGE_OVERLAP);
496: l_return_status := FND_API.G_RET_STS_ERROR;
497: END IF;
498: END LOOP;
499: RETURN(l_return_status);
500: EXCEPTION

Line 514: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

510: FUNCTION val_start_end_dates (
511: p_services_rec IN services_all_rec_type,
512: p_contract_rec IN contract_rec_type
513: ) RETURN VARCHAR2 IS
514: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
515: l_return_error_exc EXCEPTION;
516: BEGIN
517: -- Validate START and END dates of the service fall within the
518: -- START and END dates of CS_CONTRACTS

Line 530: l_return_status := FND_API.G_RET_STS_ERROR;

526: RETURN(l_return_status);
527: EXCEPTION
528: WHEN l_return_error_exc THEN
529: FND_MESSAGE.set_token('SERVICE_NAME', get_service_name(p_services_rec));
530: l_return_status := FND_API.G_RET_STS_ERROR;
531: RETURN(l_return_status);
532: END val_start_end_dates;
533: BEGIN
534: FOR l_csr_rec IN chk_csr(p_contract_rec.contract_id) LOOP

Line 539: l_return_status := FND_API.G_RET_STS_ERROR;

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:
543: -- validate all records

Line 550: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

546: ---------------------------------------------------------------
547: -- Validate any column values (min, max, date issues, not null)
548: ---------------------------------------------------------------
549: l_return_status := val_services_items(l_services_all_tbl(l_index), p_contract_rec);
550: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
551: RAISE l_return_error_exc;
552: END IF;
553: --------------------------------------------------------------
554: -- Validate START and END dates of the service fall within the

Line 558: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

554: -- Validate START and END dates of the service fall within the
555: -- START and END dates of CS_CONTRACTS
556: --------------------------------------------------------------
557: l_return_status := val_start_end_dates(l_services_all_tbl(l_index), p_contract_rec);
558: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
559: RAISE l_return_error_exc;
560: END IF;
561: -------------------------------
562: -- Validate no coverage overlap

Line 565: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

561: -------------------------------
562: -- Validate no coverage overlap
563: -------------------------------
564: l_return_status := check_coverage_overlap(l_services_all_tbl(l_index));
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

Line 572: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;
574: END IF;
575:
576: l_return_status := val_coverages_children(l_services_all_tbl(l_index));

Line 577: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

573: RAISE l_return_error_exc;
574: END IF;
575:
576: l_return_status := val_coverages_children(l_services_all_tbl(l_index));
577: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
578: RAISE l_return_error_exc;
579: END IF;
580: EXIT WHEN (l_index >= l_services_all_tbl.LAST);
581: l_index := l_services_all_tbl.NEXT(l_index);

Line 594: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

590: --------------------------------------------------------------------------------
591: FUNCTION val_contract_children (
592: p_contract_rec IN contract_rec_type
593: ) RETURN VARCHAR2 IS
594: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
595: BEGIN
596: l_return_status := val_services_children(p_contract_rec);
597: RETURN(l_return_status);
598: END val_contract_children;

Line 610: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

606: p_api_version,
607: p_init_msg_list,
608: '_Pvt',
609: x_return_status);
610: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;

Line 611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

607: p_init_msg_list,
608: '_Pvt',
609: x_return_status);
610: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615:

Line 612: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

608: '_Pvt',
609: x_return_status);
610: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615:
616: ---------------------------------------------------------------------------

Line 613: RAISE FND_API.G_EXC_ERROR;

609: x_return_status);
610: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
613: RAISE FND_API.G_EXC_ERROR;
614: END IF;
615:
616: ---------------------------------------------------------------------------
617: -- Validate all children of the contract

Line 620: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

616: ---------------------------------------------------------------------------
617: -- Validate all children of the contract
618: ---------------------------------------------------------------------------
619: l_return_status := val_contract_children(p_contract_rec);
620: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
623: RAISE FND_API.G_EXC_ERROR;
624: ELSIF (l_return_status = TAPI_DEV_KIT.G_RET_STS_WARNING) THEN

Line 621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

617: -- Validate all children of the contract
618: ---------------------------------------------------------------------------
619: l_return_status := val_contract_children(p_contract_rec);
620: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
623: RAISE FND_API.G_EXC_ERROR;
624: ELSIF (l_return_status = TAPI_DEV_KIT.G_RET_STS_WARNING) THEN
625: RAISE TAPI_DEV_KIT.G_EXC_WARNING;

Line 622: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

618: ---------------------------------------------------------------------------
619: l_return_status := val_contract_children(p_contract_rec);
620: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
623: RAISE FND_API.G_EXC_ERROR;
624: ELSIF (l_return_status = TAPI_DEV_KIT.G_RET_STS_WARNING) THEN
625: RAISE TAPI_DEV_KIT.G_EXC_WARNING;
626: END IF;

Line 623: RAISE FND_API.G_EXC_ERROR;

619: l_return_status := val_contract_children(p_contract_rec);
620: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
622: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
623: RAISE FND_API.G_EXC_ERROR;
624: ELSIF (l_return_status = TAPI_DEV_KIT.G_RET_STS_WARNING) THEN
625: RAISE TAPI_DEV_KIT.G_EXC_WARNING;
626: END IF;
627:

Line 629: x_return_status := FND_API.G_RET_STS_SUCCESS;

625: RAISE TAPI_DEV_KIT.G_EXC_WARNING;
626: END IF;
627:
628: -- Return Success
629: x_return_status := FND_API.G_RET_STS_SUCCESS;
630:
631: FND_MESSAGE.set_name(G_APP_NAME, G_VALIDATION_SUCCESSFUL);
632: FND_MESSAGE.set_token('CONTRACT_NUMBER', p_contract_rec.contract_number);
633:

Line 639: WHEN FND_API.G_EXC_ERROR THEN

635: -- TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
636: x_msg_count := 1;
637: x_msg_data := FND_MESSAGE.GET;
638: EXCEPTION
639: WHEN FND_API.G_EXC_ERROR THEN
640: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
641: (
642: l_api_name,
643: G_PKG_NAME,

Line 644: 'FND_API.G_RET_STS_ERROR',

640: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
641: (
642: l_api_name,
643: G_PKG_NAME,
644: 'FND_API.G_RET_STS_ERROR',
645: x_msg_count,
646: x_msg_data,
647: '_Pvt'
648: );

Line 650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

646: x_msg_data,
647: '_Pvt'
648: );
649: APP_EXCEPTION.RAISE_EXCEPTION;
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
652: (
653: l_api_name,
654: G_PKG_NAME,

Line 655: 'FND_API.G_RET_STS_UNEXP_ERROR',

651: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
652: (
653: l_api_name,
654: G_PKG_NAME,
655: 'FND_API.G_RET_STS_UNEXP_ERROR',
656: x_msg_count,
657: x_msg_data,
658: '_Pvt'
659: );

Line 773: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

769: p_api_version,
770: p_init_msg_list,
771: '_Pvt',
772: x_return_status);
773: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;

Line 774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

770: p_init_msg_list,
771: '_Pvt',
772: x_return_status);
773: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778: -- The calling program SHOULD pass in all appropriate parameters.

Line 775: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

771: '_Pvt',
772: x_return_status);
773: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778: -- The calling program SHOULD pass in all appropriate parameters.
779: -- However, because of the limitations of FORMS 4.5 we will populate the

Line 776: RAISE FND_API.G_EXC_ERROR;

772: x_return_status);
773: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
775: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
776: RAISE FND_API.G_EXC_ERROR;
777: END IF;
778: -- The calling program SHOULD pass in all appropriate parameters.
779: -- However, because of the limitations of FORMS 4.5 we will populate the
780: -- record ourselves.

Line 860: WHEN FND_API.G_EXC_ERROR THEN

856: x_msg_data,
857: l_contract_rec
858: );
859: EXCEPTION
860: WHEN FND_API.G_EXC_ERROR THEN
861: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
862: (
863: l_api_name,
864: G_PKG_NAME,

Line 865: 'FND_API.G_RET_STS_ERROR',

861: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
862: (
863: l_api_name,
864: G_PKG_NAME,
865: 'FND_API.G_RET_STS_ERROR',
866: x_msg_count,
867: x_msg_data,
868: '_Pvt'
869: );

Line 871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

867: x_msg_data,
868: '_Pvt'
869: );
870: APP_EXCEPTION.RAISE_EXCEPTION;
871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
872: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
873: (
874: l_api_name,
875: G_PKG_NAME,

Line 876: 'FND_API.G_RET_STS_UNEXP_ERROR',

872: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
873: (
874: l_api_name,
875: G_PKG_NAME,
876: 'FND_API.G_RET_STS_UNEXP_ERROR',
877: x_msg_count,
878: x_msg_data,
879: '_Pvt'
880: );

Line 977: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

973: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
974: x_object_version_number OUT NUMBER) IS
975: l_api_name CONSTANT VARCHAR2(30) := 'update_contract';
976: l_api_version CONSTANT NUMBER := 1;
977: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
978: l_contract_rec CS_CONTRACT_PVT.Contract_Val_Rec_Type;
979: p_old_status_id CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE;
980: p_new_status_id CS_CONTRACTS.CONTRACT_STATUS_ID%TYPE;
981: p_inv_flag CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE;

Line 990: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

986: p_api_version,
987: p_init_msg_list,
988: '_Pvt',
989: x_return_status);
990: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
993: RAISE FND_API.G_EXC_ERROR;
994: END IF;

Line 991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

987: p_init_msg_list,
988: '_Pvt',
989: x_return_status);
990: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
993: RAISE FND_API.G_EXC_ERROR;
994: END IF;
995: --- Get the old status id

Line 992: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

988: '_Pvt',
989: x_return_status);
990: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
993: RAISE FND_API.G_EXC_ERROR;
994: END IF;
995: --- Get the old status id
996:

Line 993: RAISE FND_API.G_EXC_ERROR;

989: x_return_status);
990: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
992: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
993: RAISE FND_API.G_EXC_ERROR;
994: END IF;
995: --- Get the old status id
996:
997: SELECT contract_status_id

Line 1125: WHEN FND_API.G_EXC_ERROR THEN

1121: END IF;
1122:
1123: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1124: EXCEPTION
1125: WHEN FND_API.G_EXC_ERROR THEN
1126: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1127: (
1128: l_api_name,
1129: G_PKG_NAME,

Line 1130: 'FND_API.G_RET_STS_ERROR',

1126: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1127: (
1128: l_api_name,
1129: G_PKG_NAME,
1130: 'FND_API.G_RET_STS_ERROR',
1131: x_msg_count,
1132: x_msg_data,
1133: '_Pvt'
1134: );

Line 1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1132: x_msg_data,
1133: '_Pvt'
1134: );
1135: APP_EXCEPTION.RAISE_EXCEPTION;
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1137: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1138: (
1139: l_api_name,
1140: G_PKG_NAME,

Line 1141: 'FND_API.G_RET_STS_UNEXP_ERROR',

1137: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1138: (
1139: l_api_name,
1140: G_PKG_NAME,
1141: 'FND_API.G_RET_STS_UNEXP_ERROR',
1142: x_msg_count,
1143: x_msg_data,
1144: '_Pvt'
1145: );