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_SR_PROB_CODE_MAPPING_PKG dependencies on FND_API

Line 261: x_return_status := FND_API.G_RET_STS_SUCCESS;

257:
258:
259: BEGIN
260:
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: IF fnd_api.to_boolean (p_init_msg_list)
264: THEN
265: fnd_msg_pub.initialize;

Line 263: IF fnd_api.to_boolean (p_init_msg_list)

259: BEGIN
260:
261: x_return_status := FND_API.G_RET_STS_SUCCESS;
262:
263: IF fnd_api.to_boolean (p_init_msg_list)
264: THEN
265: fnd_msg_pub.initialize;
266: END IF;
267:

Line 276: IF (l_service_request_type_id = FND_API.G_MISS_NUM) THEN

272: l_organization_id := nvl(p_probcode_criteria_rec.organization_id,0);
273: l_problem_code := p_problem_code;
274: l_category_set_id := FND_PROFILE.value('CS_SR_DEFAULT_CATEGORY_SET');
275:
276: IF (l_service_request_type_id = FND_API.G_MISS_NUM) THEN
277: l_service_request_type_id := 0;
278: END IF;
279: IF (l_product_category_id = FND_API.G_MISS_NUM) THEN
280: l_product_category_id := 0;

Line 279: IF (l_product_category_id = FND_API.G_MISS_NUM) THEN

275:
276: IF (l_service_request_type_id = FND_API.G_MISS_NUM) THEN
277: l_service_request_type_id := 0;
278: END IF;
279: IF (l_product_category_id = FND_API.G_MISS_NUM) THEN
280: l_product_category_id := 0;
281: END IF;
282: IF (l_inventory_item_id = FND_API.G_MISS_NUM) THEN
283: l_inventory_item_id := 0;

Line 282: IF (l_inventory_item_id = FND_API.G_MISS_NUM) THEN

278: END IF;
279: IF (l_product_category_id = FND_API.G_MISS_NUM) THEN
280: l_product_category_id := 0;
281: END IF;
282: IF (l_inventory_item_id = FND_API.G_MISS_NUM) THEN
283: l_inventory_item_id := 0;
284: END IF;
285: IF (l_organization_id = FND_API.G_MISS_NUM) THEN
286: l_organization_id := 0;

Line 285: IF (l_organization_id = FND_API.G_MISS_NUM) THEN

281: END IF;
282: IF (l_inventory_item_id = FND_API.G_MISS_NUM) THEN
283: l_inventory_item_id := 0;
284: END IF;
285: IF (l_organization_id = FND_API.G_MISS_NUM) THEN
286: l_organization_id := 0;
287: END IF;
288: IF (l_problem_code = FND_API.G_MISS_CHAR) THEN
289: RAISE FND_API.G_EXC_ERROR;

Line 288: IF (l_problem_code = FND_API.G_MISS_CHAR) THEN

284: END IF;
285: IF (l_organization_id = FND_API.G_MISS_NUM) THEN
286: l_organization_id := 0;
287: END IF;
288: IF (l_problem_code = FND_API.G_MISS_CHAR) THEN
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:
292: IF (l_inventory_item_id <> 0 and l_organization_id = 0) THEN

Line 289: RAISE FND_API.G_EXC_ERROR;

285: IF (l_organization_id = FND_API.G_MISS_NUM) THEN
286: l_organization_id := 0;
287: END IF;
288: IF (l_problem_code = FND_API.G_MISS_CHAR) THEN
289: RAISE FND_API.G_EXC_ERROR;
290: END IF;
291:
292: IF (l_inventory_item_id <> 0 and l_organization_id = 0) THEN
293: l_organization_id := FND_PROFILE.value('CS_INV_VALIDATION_ORG');

Line 325: RAISE FND_API.G_EXC_ERROR;

321: /* Validation Check #7 */
322: OPEN cs_sr_active_pc_csr;
323: FETCH cs_sr_active_pc_csr into l_problem_code_meaning;
324: IF (cs_sr_active_pc_csr%NOTFOUND) THEN
325: RAISE FND_API.G_EXC_ERROR;
326: END IF;
327:
328: /* Validation Check #1 */
329: OPEN cs_sr_unmapped_pc_csr;

Line 370: RAISE FND_API.G_EXC_ERROR;

366: /* Validation Check #4 */
367: OPEN cs_sr_pc_cat_with_prodcat;
368: FETCH cs_sr_pc_cat_with_prodcat into l_problem_code_meaning;
369: IF (cs_sr_pc_cat_with_prodcat%NOTFOUND) THEN
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372: END IF;
373:
374: END IF;

Line 386: RAISE FND_API.G_EXC_ERROR;

382: /* Validation Check #6 */
383: OPEN cs_sr_pc_catset_with_prod;
384: FETCH cs_sr_pc_catset_with_prod into l_problem_code_meaning;
385: IF (cs_sr_pc_catset_with_prod%NOTFOUND) THEN
386: RAISE FND_API.G_EXC_ERROR;
387: END IF;
388: END IF;
389:
390: END IF;

Line 413: WHEN FND_API.G_EXC_ERROR THEN

409: END IF;
410:
411:
412: EXCEPTION
413: WHEN FND_API.G_EXC_ERROR THEN
414: IF cs_sr_unmapped_pc_csr%isopen THEN
415: CLOSE cs_sr_unmapped_pc_csr;
416: END IF;
417: IF cs_sr_pc_cat_with_srtype%isopen THEN

Line 432: x_return_status := FND_API.G_RET_STS_ERROR;

428: END IF;
429: IF cs_sr_pc_catset_with_prod%isopen THEN
430: CLOSE cs_sr_pc_catset_with_prod;
431: END IF;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: FND_MSG_PUB.Count_And_Get
434: ( p_count => x_msg_count,
435: p_data => x_msg_data
436: );

Line 437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

433: FND_MSG_PUB.Count_And_Get
434: ( p_count => x_msg_count,
435: p_data => x_msg_data
436: );
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: IF cs_sr_unmapped_pc_csr%isopen THEN
439: CLOSE cs_sr_unmapped_pc_csr;
440: END IF;
441: IF cs_sr_pc_cat_with_srtype%isopen THEN

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

452: END IF;
453: IF cs_sr_pc_catset_with_prod%isopen THEN
454: CLOSE cs_sr_pc_catset_with_prod;
455: END IF;
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: FND_MSG_PUB.Count_And_Get
458: ( p_count => x_msg_count,
459: p_data => x_msg_data
460: );

Line 480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

476: END IF;
477: IF cs_sr_pc_catset_with_prod%isopen THEN
478: CLOSE cs_sr_pc_catset_with_prod;
479: END IF;
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
482: FND_MSG_PUB.Add_Exc_Msg('CS_SR_PROB_CODE_MAPPING_PKG', l_api_name);
483: END IF;
484: FND_MSG_PUB.Count_And_Get

Line 569: x_return_status := fnd_api.g_ret_sts_success;

565:
566: BEGIN
567:
568: SAVEPOINT create_mapping_rules;
569: x_return_status := fnd_api.g_ret_sts_success;
570:
571: IF fnd_api.to_boolean (p_init_msg_list) THEN
572: fnd_msg_pub.initialize;
573: END IF;

Line 571: IF fnd_api.to_boolean (p_init_msg_list) THEN

567:
568: SAVEPOINT create_mapping_rules;
569: x_return_status := fnd_api.g_ret_sts_success;
570:
571: IF fnd_api.to_boolean (p_init_msg_list) THEN
572: fnd_msg_pub.initialize;
573: END IF;
574:
575: /* First, we create the search criteria

Line 591: RAISE fnd_api.g_exc_unexpected_error;

587:
588: /* Validation check #1 */
589: IF ( p_probcode_map_criteria_rec.product_category_id is not null and
590: p_probcode_map_criteria_rec.inventory_item_id is not null) THEN
591: RAISE fnd_api.g_exc_unexpected_error;
592: END IF;
593:
594: /* Validation check #2 */
595: IF (p_probcode_map_criteria_rec.product_category_id is null and

Line 598: RAISE fnd_api.g_exc_unexpected_error;

594: /* Validation check #2 */
595: IF (p_probcode_map_criteria_rec.product_category_id is null and
596: p_probcode_map_criteria_rec.inventory_item_id is null and
597: p_probcode_map_criteria_rec.service_request_type_id is null) THEN
598: RAISE fnd_api.g_exc_unexpected_error;
599: END IF;
600:
601: /* Validation check #3 */
602: IF (p_probcode_map_criteria_rec.inventory_item_id is not null and

Line 604: RAISE fnd_api.g_exc_unexpected_error;

600:
601: /* Validation check #3 */
602: IF (p_probcode_map_criteria_rec.inventory_item_id is not null and
603: p_probcode_map_criteria_rec.organization_id is null) THEN
604: RAISE fnd_api.g_exc_unexpected_error;
605: END IF;
606:
607: /* Validation check #4 */
608: l_product_category_id := nvl(p_probcode_map_criteria_rec.product_category_id,0);

Line 619: RAISE fnd_api.g_exc_unexpected_error;

615:
616: OPEN c_sr_criteria_exists_csr;
617: FETCH c_sr_criteria_exists_csr into c_sr_criteria_exists_rec;
618: IF (c_sr_criteria_exists_csr%FOUND) THEN
619: RAISE fnd_api.g_exc_unexpected_error;
620: END IF;-- end of IF (c_sr_criteria_exists_csr%FOUND)
621: CLOSE c_sr_criteria_exists_csr;
622:
623: /* Validation check #5 */

Line 631: RAISE fnd_api.g_exc_unexpected_error;

627: l_product_category_set := FND_PROFILE.Value('CS_SR_DEFAULT_CATEGORY_SET');
628: OPEN c_sr_prod_cat_valid_csr;
629: FETCH c_sr_prod_cat_valid_csr into l_temp;
630: IF (c_sr_prod_cat_valid_csr%NOTFOUND) THEN
631: RAISE fnd_api.g_exc_unexpected_error;
632: END IF;
633: CLOSE c_sr_prod_cat_valid_csr;
634: END IF;
635:

Line 641: RAISE fnd_api.g_exc_unexpected_error;

637: /* Validation check #6 */
638: /* start date cannot be greater then end date */
639: IF(l_start_date_active is not null AND l_end_date_active is not null AND
640: l_start_date_active >= l_end_date_active) THEN
641: RAISE fnd_api.g_exc_unexpected_error;
642: END IF;
643:
644: /* All validations have passed for the search criteria. Hence we can create a search criteria record in
645: CS_SR_PROB_CODE_MAPPING table */

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

677: X_RETURN_STATUS => l_return_status,
678: X_MSG_COUNT => l_msg_count,
679: X_MSG_DATA => l_errmsg);
680:
681: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
682: RAISE fnd_api.g_exc_unexpected_error;
683: END IF;
684:
685: /* Now, we need to create the actual problem code -> search criteria mapping details in

Line 682: RAISE fnd_api.g_exc_unexpected_error;

678: X_MSG_COUNT => l_msg_count,
679: X_MSG_DATA => l_errmsg);
680:
681: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
682: RAISE fnd_api.g_exc_unexpected_error;
683: END IF;
684:
685: /* Now, we need to create the actual problem code -> search criteria mapping details in
686: CS_SR_PROB_CODE_MAPPING_DETAIL table */

Line 700: (p_problem_codes_tbl(l_prob_code_index).problem_code <> FND_API.G_MISS_CHAR)) THEN

696: l_prob_code_index := p_problem_codes_tbl.FIRST;
697: WHILE l_prob_code_index IS NOT NULL LOOP
698:
699: IF ((p_problem_codes_tbl(l_prob_code_index).problem_code IS NOT NULL) AND
700: (p_problem_codes_tbl(l_prob_code_index).problem_code <> FND_API.G_MISS_CHAR)) THEN
701:
702: l_problem_code := p_problem_codes_tbl(l_prob_code_index).problem_code;
703: l_start_date_active := p_problem_codes_tbl(l_prob_code_index).start_date_active;
704: l_end_date_active := p_problem_codes_tbl(l_prob_code_index).end_date_active;

Line 710: RAISE fnd_api.g_exc_unexpected_error;

706: /* Validation check #1 */
707: OPEN c_sr_problem_code_valid_csr;
708: FETCH c_sr_problem_code_valid_csr INTO l_problem_code;
709: IF(c_sr_problem_code_valid_csr%NOTFOUND) THEN
710: RAISE fnd_api.g_exc_unexpected_error;
711: END IF;
712: CLOSE c_sr_problem_code_valid_csr;
713:
714: /* Validation check #2 */

Line 718: RAISE fnd_api.g_exc_unexpected_error;

714: /* Validation check #2 */
715: OPEN c_sr_prob_code_map_exists_csr;
716: FETCH c_sr_prob_code_map_exists_csr into c_sr_prob_code_map_exists_rec;
717: IF(c_sr_prob_code_map_exists_csr%FOUND) THEN
718: RAISE fnd_api.g_exc_unexpected_error;
719: END IF;
720: CLOSE c_sr_prob_code_map_exists_csr;
721:
722: /* Validation check #3 */

Line 726: RAISE fnd_api.g_exc_unexpected_error;

722: /* Validation check #3 */
723: /* start date cannot be greater then end date */
724: IF(l_start_date_active is not null AND l_end_date_active is not null AND
725: l_start_date_active >= l_end_date_active) THEN
726: RAISE fnd_api.g_exc_unexpected_error;
727: END IF;
728:
729: /* We can create the problem code mapping in CS_SR_PROB_CODE_MAPPING_DETAIL table now */
730: CS_SR_PROB_CODE_MAP_DETAIL_PKG.INSERT_ROW (

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

764: X_RETURN_STATUS => l_return_status,
765: X_MSG_COUNT => l_msg_count,
766: X_MSG_DATA => l_errmsg);
767:
768: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
769: RAISE fnd_api.g_exc_unexpected_error;
770: END IF;
771:
772: END IF;

Line 769: RAISE fnd_api.g_exc_unexpected_error;

765: X_MSG_COUNT => l_msg_count,
766: X_MSG_DATA => l_errmsg);
767:
768: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
769: RAISE fnd_api.g_exc_unexpected_error;
770: END IF;
771:
772: END IF;
773: l_prob_code_index := p_problem_codes_tbl.NEXT(l_prob_code_index);

Line 792: WHEN FND_API.G_EXC_ERROR THEN

788: END IF;
789:
790:
791: EXCEPTION
792: WHEN FND_API.G_EXC_ERROR THEN
793: IF c_sr_criteria_exists_csr%isopen THEN
794: CLOSE c_sr_criteria_exists_csr;
795: END IF;
796: IF c_sr_prod_cat_valid_csr%isopen THEN

Line 806: x_return_status := FND_API.G_RET_STS_ERROR;

802: IF c_sr_prob_code_map_exists_csr%isopen THEN
803: CLOSE c_sr_prob_code_map_exists_csr;
804: END IF;
805: ROLLBACK TO create_mapping_rules;
806: x_return_status := FND_API.G_RET_STS_ERROR;
807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count,
809: p_data => x_msg_data
810: );

Line 811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

807: FND_MSG_PUB.Count_And_Get
808: ( p_count => x_msg_count,
809: p_data => x_msg_data
810: );
811: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
812: IF c_sr_criteria_exists_csr%isopen THEN
813: CLOSE c_sr_criteria_exists_csr;
814: END IF;
815: IF c_sr_prod_cat_valid_csr%isopen THEN

Line 825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

821: IF c_sr_prob_code_map_exists_csr%isopen THEN
822: CLOSE c_sr_prob_code_map_exists_csr;
823: END IF;
824: ROLLBACK TO create_mapping_rules;
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826: FND_MSG_PUB.Count_And_Get
827: ( p_count => x_msg_count,
828: p_data => x_msg_data
829: );

Line 844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

840: IF c_sr_prob_code_map_exists_csr%isopen THEN
841: CLOSE c_sr_prob_code_map_exists_csr;
842: END IF;
843: ROLLBACK TO create_mapping_rules;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
846: FND_MSG_PUB.Add_Exc_Msg('CS_SR_PROB_CODE_MAPPING_PKG', l_api_name);
847: END IF;
848: FND_MSG_PUB.Count_And_Get

Line 857: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

853:
854:
855: PROCEDURE UPDATE_MAPPING_RULES
856: ( p_api_version IN NUMBER,
857: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
858: p_commit IN VARCHAR2 := FND_API.G_FALSE,
859: p_probcode_map_criteria_rec IN probcode_map_criteria_rec,
860: p_problem_codes_tbl IN problem_codes_tbl_type,
861: x_return_status OUT NOCOPY VARCHAR2,

Line 858: p_commit IN VARCHAR2 := FND_API.G_FALSE,

854:
855: PROCEDURE UPDATE_MAPPING_RULES
856: ( p_api_version IN NUMBER,
857: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
858: p_commit IN VARCHAR2 := FND_API.G_FALSE,
859: p_probcode_map_criteria_rec IN probcode_map_criteria_rec,
860: p_problem_codes_tbl IN problem_codes_tbl_type,
861: x_return_status OUT NOCOPY VARCHAR2,
862: x_msg_count OUT NOCOPY NUMBER,

Line 932: x_return_status := fnd_api.g_ret_sts_success;

928:
929: BEGIN
930:
931: SAVEPOINT update_mapping_rules;
932: x_return_status := fnd_api.g_ret_sts_success;
933:
934: IF fnd_api.to_boolean (p_init_msg_list) THEN
935: fnd_msg_pub.initialize;
936: END IF;

Line 934: IF fnd_api.to_boolean (p_init_msg_list) THEN

930:
931: SAVEPOINT update_mapping_rules;
932: x_return_status := fnd_api.g_ret_sts_success;
933:
934: IF fnd_api.to_boolean (p_init_msg_list) THEN
935: fnd_msg_pub.initialize;
936: END IF;
937:
938: l_problem_map_id := p_probcode_map_criteria_rec.problem_map_id;

Line 958: RAISE fnd_api.g_exc_unexpected_error;

954: */
955:
956: /* Validation check #1 */
957: IF (l_problem_map_id is null) THEN
958: RAISE fnd_api.g_exc_unexpected_error;
959: END IF;
960:
961:
962: /* Validation check #2 */

Line 966: RAISE fnd_api.g_exc_unexpected_error;

962: /* Validation check #2 */
963: IF (l_service_request_type_id = 0 AND
964: l_product_category_id = 0 AND
965: l_inventory_item_id = 0) THEN
966: RAISE fnd_api.g_exc_unexpected_error;
967: END IF;
968:
969: /* Validation check #3 */
970: IF (l_product_category_id <> 0 AND

Line 972: RAISE fnd_api.g_exc_unexpected_error;

968:
969: /* Validation check #3 */
970: IF (l_product_category_id <> 0 AND
971: l_inventory_item_id <> 0) THEN
972: RAISE fnd_api.g_exc_unexpected_error;
973: END IF;
974:
975:
976: /* Validation check #4 */

Line 980: RAISE fnd_api.g_exc_unexpected_error;

976: /* Validation check #4 */
977: IF (l_start_date_active is not null AND
978: l_end_date_active is not null AND
979: l_start_date_active >= l_end_date_active) THEN
980: RAISE fnd_api.g_exc_unexpected_error;
981: END IF;
982:
983: /* Validation check #5 */
984: OPEN cs_sr_probmapid_exists_csr;

Line 986: RAISE fnd_api.g_exc_unexpected_error;

982:
983: /* Validation check #5 */
984: OPEN cs_sr_probmapid_exists_csr;
985: IF(cs_sr_probmapid_exists_csr%FOUND) THEN
986: RAISE fnd_api.g_exc_unexpected_error;
987: END IF;
988: CLOSE cs_sr_probmapid_exists_csr;
989:
990:

Line 995: (p_problem_codes_tbl(l_prob_code_index).problem_code <> FND_API.G_MISS_CHAR)) THEN

991: l_prob_code_index := p_problem_codes_tbl.FIRST;
992: WHILE l_prob_code_index IS NOT NULL LOOP
993:
994: IF ((p_problem_codes_tbl(l_prob_code_index).problem_code IS NOT NULL) AND
995: (p_problem_codes_tbl(l_prob_code_index).problem_code <> FND_API.G_MISS_CHAR)) THEN
996:
997: l_problem_code := p_problem_codes_tbl(l_prob_code_index).problem_code;
998: l_start_date_active := p_problem_codes_tbl(l_prob_code_index).start_date_active;
999: l_end_date_active := p_problem_codes_tbl(l_prob_code_index).end_date_active;

Line 1006: RAISE fnd_api.g_exc_unexpected_error;

1002:
1003: /* Validation check #6 */
1004: OPEN cs_sr_problem_code_valid_csr;
1005: IF(cs_sr_problem_code_valid_csr%NOTFOUND) THEN
1006: RAISE fnd_api.g_exc_unexpected_error;
1007: END IF;
1008: CLOSE cs_sr_problem_code_valid_csr;
1009:
1010: /* Validation check #7 */

Line 1014: RAISE fnd_api.g_exc_unexpected_error;

1010: /* Validation check #7 */
1011: OPEN cs_sr_probcode_mapped_csr;
1012: FETCH cs_sr_probcode_mapped_csr into cs_sr_probcode_mapped_rec;
1013: IF(cs_sr_probcode_mapped_csr%FOUND) THEN
1014: RAISE fnd_api.g_exc_unexpected_error;
1015: END IF;
1016: CLOSE cs_sr_probcode_mapped_csr;
1017:
1018: IF(p_problem_codes_tbl(l_prob_code_index).problem_map_detail_id is null) THEN

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

1095:
1096:
1097:
1098: END IF;
1099: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1100: RAISE fnd_api.g_exc_unexpected_error;
1101: END IF;
1102: END IF;
1103: l_prob_code_index := p_problem_codes_tbl.NEXT(l_prob_code_index);

Line 1100: RAISE fnd_api.g_exc_unexpected_error;

1096:
1097:
1098: END IF;
1099: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1100: RAISE fnd_api.g_exc_unexpected_error;
1101: END IF;
1102: END IF;
1103: l_prob_code_index := p_problem_codes_tbl.NEXT(l_prob_code_index);
1104: END LOOP;

Line 1107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1103: l_prob_code_index := p_problem_codes_tbl.NEXT(l_prob_code_index);
1104: END LOOP;
1105:
1106: EXCEPTION
1107: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1108: IF cs_sr_probmapid_exists_csr%isopen THEN
1109: CLOSE cs_sr_probmapid_exists_csr;
1110: END IF;
1111: IF cs_sr_problem_code_valid_csr%isopen THEN

Line 1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1114: IF cs_sr_probcode_mapped_csr%isopen THEN
1115: CLOSE cs_sr_probcode_mapped_csr;
1116: END IF;
1117: ROLLBACK TO update_mapping_rules;
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1119: FND_MSG_PUB.Count_And_Get
1120: ( p_count => x_msg_count,
1121: p_data => x_msg_data
1122: );

Line 1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1130: IF cs_sr_probcode_mapped_csr%isopen THEN
1131: CLOSE cs_sr_probcode_mapped_csr;
1132: END IF;
1133: ROLLBACK TO update_mapping_rules;
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: FND_MSG_PUB.Count_And_Get
1136: ( p_count => x_msg_count,
1137: p_data => x_msg_data
1138: );

Line 1147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1143:
1144:
1145: PROCEDURE PROPAGATE_MAP_CRITERIA_DATES
1146: ( p_api_version IN NUMBER,
1147: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1148: x_return_status OUT NOCOPY VARCHAR2,
1149: x_msg_count OUT NOCOPY NUMBER,
1150: x_msg_data OUT NOCOPY VARCHAR2
1151: ) IS

Line 1200: x_return_status := fnd_api.g_ret_sts_success;

1196:
1197:
1198: BEGIN
1199: SAVEPOINT propagate_map_criteria_dates;
1200: x_return_status := fnd_api.g_ret_sts_success;
1201:
1202: IF fnd_api.to_boolean (p_init_msg_list) THEN
1203: fnd_msg_pub.initialize;
1204: END IF;

Line 1202: IF fnd_api.to_boolean (p_init_msg_list) THEN

1198: BEGIN
1199: SAVEPOINT propagate_map_criteria_dates;
1200: x_return_status := fnd_api.g_ret_sts_success;
1201:
1202: IF fnd_api.to_boolean (p_init_msg_list) THEN
1203: fnd_msg_pub.initialize;
1204: END IF;
1205:
1206: OPEN cs_sr_probmapid_crit_csr;

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

1272: X_MSG_COUNT => l_msg_count,
1273: X_MSG_DATA => l_errmsg
1274: );
1275:
1276: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1277: RAISE fnd_api.g_exc_unexpected_error;
1278: END IF;
1279: */
1280: END IF;

Line 1277: RAISE fnd_api.g_exc_unexpected_error;

1273: X_MSG_DATA => l_errmsg
1274: );
1275:
1276: IF(l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1277: RAISE fnd_api.g_exc_unexpected_error;
1278: END IF;
1279: */
1280: END IF;
1281: END LOOP;

Line 1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1282: CLOSE cs_sr_probmapid_crit_csr;
1283: commit;
1284:
1285: EXCEPTION
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287: IF cs_sr_probmapid_crit_csr%isopen THEN
1288: CLOSE cs_sr_probmapid_crit_csr;
1289: END IF;
1290: IF cs_sr_probmapid_rules_csr%isopen THEN

Line 1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1290: IF cs_sr_probmapid_rules_csr%isopen THEN
1291: CLOSE cs_sr_probmapid_rules_csr;
1292: END IF;
1293: ROLLBACK TO propagate_map_criteria_dates;
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1295: FND_MSG_PUB.Count_And_Get
1296: ( p_count => x_msg_count,
1297: p_data => x_msg_data
1298: );

Line 1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1303: IF cs_sr_probmapid_rules_csr%isopen THEN
1304: CLOSE cs_sr_probmapid_rules_csr;
1305: END IF;
1306: ROLLBACK TO propagate_map_criteria_dates;
1307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1308: FND_MSG_PUB.Count_And_Get
1309: ( p_count => x_msg_count,
1310: p_data => x_msg_data
1311: );