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.OKL_TBC_PVT dependencies on OKC_API

Line 229: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'TAX_ATTRIBUTE_DEF_ID');

225: BEGIN
226: x_return_status := OKL_API.G_RET_STS_SUCCESS;
227: l_tbcv_rec := get_rec(p_tbcv_rec, l_row_notfound);
228: IF (l_row_notfound) THEN
229: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'TAX_ATTRIBUTE_DEF_ID');
230: x_return_status := OKL_API.G_RET_STS_ERROR;
231: END IF;
232: RETURN(l_tbcv_rec);
233: END get_rec;

Line 377: OKc_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'TAX_ATTRIBUTE_DEF_ID');

373: BEGIN
374: x_return_status := OKL_API.G_RET_STS_SUCCESS;
375: l_tbc_rec := get_rec(p_tbc_rec, l_row_notfound);
376: IF (l_row_notfound) THEN
377: OKc_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'TAX_ATTRIBUTE_DEF_ID');
378: x_return_status := OKL_API.G_RET_STS_ERROR;
379: END IF;
380: RETURN(l_tbc_rec);
381: END get_rec;

Line 556: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

552: ---------------------------------
553: /* PROCEDURE validate_id(
554: x_return_status OUT NOCOPY VARCHAR2,
555: p_tbcv_rec IN tbcv_rec_type) IS
556: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
557: BEGIN
558:
559: IF (p_tbcv_rec.id = OKL_API.G_MISS_NUM OR p_tbcv_rec.id IS NULL)
560: THEN

Line 586: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

582: ---------------------------------------
583: PROCEDURE validate_result_code(
584: x_return_status OUT NOCOPY VARCHAR2,
585: p_tbcv_rec IN tbcv_rec_type) IS
586: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
587: l_dummy_var VARCHAR2(1) := '?' ;
588:
589: CURSOR okl_tbc_res_code_fk_csr (p_lookup_code IN VARCHAR2) IS
590: SELECT 'x'

Line 622: OKC_API.set_message(g_app_name,

618:
619: -- still set to default means data was not found
620: IF ( l_dummy_var = '?' ) THEN
621:
622: OKC_API.set_message(g_app_name,
623: g_no_parent_record,
624: g_col_name_token,
625: 'result_code',
626: g_child_table_token ,

Line 630: l_return_status := OKC_API.G_RET_STS_ERROR;

626: g_child_table_token ,
627: 'OKL_TAX_ATTR_DEFINITIONS',
628: g_parent_table_token ,
629: 'ZX_FC_BUSINESS_CATEGORIES_V');
630: l_return_status := OKC_API.G_RET_STS_ERROR;
631:
632: END IF;
633: ELSIF (p_tbcv_rec.result_type_code = 'PC_CODE')
634: THEN

Line 642: OKC_API.set_message(g_app_name,

638:
639: -- still set to default means data was not found
640: IF ( l_dummy_var = '?' ) THEN
641:
642: OKC_API.set_message(g_app_name,
643: g_no_parent_record,
644: g_col_name_token,
645: 'result_code',
646: g_child_table_token ,

Line 650: l_return_status := OKC_API.G_RET_STS_ERROR;

646: g_child_table_token ,
647: 'OKL_TAX_ATTR_DEFINITIONS',
648: g_parent_table_token ,
649: 'ZX_FC_PRODUCT_CATEGORIES_V');
650: l_return_status := OKC_API.G_RET_STS_ERROR;
651:
652: END IF;
653: ELSIF (p_tbcv_rec.result_type_code = 'UFC_CODE')
654: THEN

Line 662: OKC_API.set_message(g_app_name,

658:
659: -- still set to default means data was not found
660: IF ( l_dummy_var = '?' ) THEN
661:
662: OKC_API.set_message(g_app_name,
663: g_no_parent_record,
664: g_col_name_token,
665: 'result_code',
666: g_child_table_token ,

Line 670: l_return_status := OKC_API.G_RET_STS_ERROR;

666: g_child_table_token ,
667: 'OKL_TAX_ATTR_DEFINITIONS',
668: g_parent_table_token ,
669: 'ZX_FC_USER_DEFINED_V');
670: l_return_status := OKC_API.G_RET_STS_ERROR;
671:
672: END IF;
673: END IF;
674:

Line 697: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

693: ---------------------------------------------------
694: PROCEDURE validate_purchase_option_code(
695: x_return_status OUT NOCOPY VARCHAR2,
696: p_tbcv_rec IN tbcv_rec_type) IS
697: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
698:
699: l_dummy_var VARCHAR2(1) := '?' ;
700:
701: CURSOR okl_tbcv_prch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS

Line 721: OKC_API.set_message(g_app_name,

717: FETCH okl_tbcv_prch_fk_csr into l_dummy_var ;
718: CLOSE okl_tbcv_prch_fk_csr ;
719: -- still set to default means data was not found
720: IF ( l_dummy_var = '?' ) THEN
721: OKC_API.set_message(g_app_name,
722: g_no_parent_record,
723: g_col_name_token,
724: 'purchase_option_code',
725: g_child_table_token ,

Line 729: l_return_status := OKC_API.G_RET_STS_ERROR;

725: g_child_table_token ,
726: 'OKL_TAX_ATTR_DEFINITIONS',
727: g_parent_table_token ,
728: 'FND_LOOKUP_VALUES');
729: l_return_status := OKC_API.G_RET_STS_ERROR;
730:
731: END IF;
732: END IF;
733: x_return_status := l_return_status;

Line 751: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

747: -------------------------------------
748: PROCEDURE validate_pdt_id(
749: x_return_status OUT NOCOPY VARCHAR2,
750: p_tbcv_rec IN tbcv_rec_type) IS
751: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
752:
753: l_dummy_var VARCHAR2(1) := '?' ;
754:
755: CURSOR okl_tbcv_pdt_fk_csr (p_id IN NUMBER) IS

Line 774: OKC_API.set_message(g_app_name,

770: FETCH okl_tbcv_pdt_fk_csr into l_dummy_var ;
771: CLOSE okl_tbcv_pdt_fk_csr ;
772: -- still set to default means data was not found
773: IF ( l_dummy_var = '?' ) THEN
774: OKC_API.set_message(g_app_name,
775: g_no_parent_record,
776: g_col_name_token,
777: 'pdt_id',
778: g_child_table_token ,

Line 782: l_return_status := OKC_API.G_RET_STS_ERROR;

778: g_child_table_token ,
779: 'OKL_TAX_ATTR_DEFINITIONS',
780: g_parent_table_token ,
781: 'OKL_PRODUCTS');
782: l_return_status := OKC_API.G_RET_STS_ERROR;
783:
784: END IF;
785:
786: END IF;

Line 805: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

801: -------------------------------------
802: PROCEDURE validate_try_id(
803: x_return_status OUT NOCOPY VARCHAR2,
804: p_tbcv_rec IN tbcv_rec_type) IS
805: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
806:
807: l_dummy_var VARCHAR2(1) := '?' ;
808:
809: CURSOR okl_tbcv_try_fk_csr (p_id IN NUMBER) IS

Line 827: OKC_API.set_message(g_app_name,

823: FETCH okl_tbcv_try_fk_csr into l_dummy_var ;
824: CLOSE okl_tbcv_try_fk_csr ;
825: -- still set to default means data was not found
826: IF ( l_dummy_var = '?' ) THEN
827: OKC_API.set_message(g_app_name,
828: g_no_parent_record,
829: g_col_name_token,
830: 'try_id',
831: g_child_table_token ,

Line 835: l_return_status := OKC_API.G_RET_STS_ERROR;

831: g_child_table_token ,
832: 'OKL_TAX_ATTR_DEFINITIONS',
833: g_parent_table_token ,
834: 'OKL_TRX_TYPES_B');
835: l_return_status := OKC_API.G_RET_STS_ERROR;
836:
837: END IF;
838: END IF;
839: x_return_status := l_return_status;

Line 857: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

853: -------------------------------------
854: PROCEDURE validate_sty_id(
855: x_return_status OUT NOCOPY VARCHAR2,
856: p_tbcv_rec IN tbcv_rec_type) IS
857: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
858:
859: l_dummy_var VARCHAR2(1) := '?' ;
860:
861: CURSOR okl_tbcv_sty_fk_csr (p_id IN NUMBER) IS

Line 879: OKC_API.set_message(g_app_name,

875: FETCH okl_tbcv_sty_fk_csr into l_dummy_var ;
876: CLOSE okl_tbcv_sty_fk_csr ;
877: -- still set to default means data was not found
878: IF ( l_dummy_var = '?' ) THEN
879: OKC_API.set_message(g_app_name,
880: g_no_parent_record,
881: g_col_name_token,
882: 'sty_id',
883: g_child_table_token ,

Line 887: l_return_status := OKC_API.G_RET_STS_ERROR;

883: g_child_table_token ,
884: 'OKL_TAX_ATTR_DEFINITIONS',
885: g_parent_table_token ,
886: 'OKL_STRM_TYPE_B');
887: l_return_status := OKC_API.G_RET_STS_ERROR;
888:
889: END IF;
890: END IF;
891: x_return_status := l_return_status;

Line 909: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

905: -------------------------------------------------
906: PROCEDURE validate_int_disclosed_code(
907: x_return_status OUT NOCOPY VARCHAR2,
908: p_tbcv_rec IN tbcv_rec_type) IS
909: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
910:
911: l_dummy_var VARCHAR2(1) := '?' ;
912:
913: CURSOR okl_tbcv_int_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS

Line 931: OKC_API.set_message(g_app_name,

927: FETCH okl_tbcv_int_fk_csr INTO l_dummy_var ;
928: CLOSE okl_tbcv_int_fk_csr ;
929: -- still set to default means data was not found
930: IF ( l_dummy_var = '?' ) THEN
931: OKC_API.set_message(g_app_name,
932: g_no_parent_record,
933: g_col_name_token,
934: 'int_disclosed_code',
935: g_child_table_token ,

Line 939: l_return_status := OKC_API.G_RET_STS_ERROR;

935: g_child_table_token ,
936: 'OKL_TAX_ATTR_DEFINITIONS',
937: g_parent_table_token ,
938: 'FND_LOOKUP_VALUES');
939: l_return_status := OKC_API.G_RET_STS_ERROR;
940:
941: END IF;
942: END IF;
943: x_return_status := l_return_status;

Line 962: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

958:
959: PROCEDURE validate_title_trnsfr_code(
960: x_return_status OUT NOCOPY VARCHAR2,
961: p_tbcv_rec IN tbcv_rec_type) IS
962: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
963:
964: l_dummy_var VARCHAR2(1) := '?' ;
965:
966: CURSOR okl_tbcv_title_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS

Line 980: OKC_API.set_message(g_app_name,

976: FETCH okl_tbcv_title_fk_csr INTO l_dummy_var ;
977: CLOSE okl_tbcv_title_fk_csr ;
978: -- still set to default means data was not found
979: IF ( l_dummy_var = '?' ) THEN
980: OKC_API.set_message(g_app_name,
981: g_no_parent_record,
982: g_col_name_token,
983: 'title_trnsfr_code',
984: g_child_table_token ,

Line 988: l_return_status := OKC_API.G_RET_STS_ERROR;

984: g_child_table_token ,
985: 'OKL_TAX_ATTR_DEFINITIONS',
986: g_parent_table_token ,
987: 'FND_LOOKUP_VALUES');
988: l_return_status := OKC_API.G_RET_STS_ERROR;
989:
990: END IF;
991: END IF;
992: x_return_status := l_return_status;

Line 1010: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1006: ---------------------------------------------------
1007: PROCEDURE validate_sale_lease_back_code(
1008: x_return_status OUT NOCOPY VARCHAR2,
1009: p_tbcv_rec IN tbcv_rec_type) IS
1010: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1011:
1012: l_dummy_var VARCHAR2(1) := '?' ;
1013:
1014: CURSOR okl_tbcv_salelease_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS

Line 1032: OKC_API.set_message(g_app_name,

1028: FETCH okl_tbcv_salelease_fk_csr INTO l_dummy_var ;
1029: CLOSE okl_tbcv_salelease_fk_csr ;
1030: -- still set to default means data was not found
1031: IF ( l_dummy_var = '?' ) THEN
1032: OKC_API.set_message(g_app_name,
1033: g_no_parent_record,
1034: g_col_name_token,
1035: 'sale_lease_back_code',
1036: g_child_table_token ,

Line 1040: l_return_status := OKC_API.G_RET_STS_ERROR;

1036: g_child_table_token ,
1037: 'OKL_TAX_ATTR_DEFINITIONS',
1038: g_parent_table_token ,
1039: 'FND_LOOKUP_VALUES');
1040: l_return_status := OKC_API.G_RET_STS_ERROR;
1041: END IF;
1042: END IF;
1043: x_return_status := l_return_status;
1044: EXCEPTION

Line 1061: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1057: ---------------------------------------------------
1058: PROCEDURE validate_lease_purchased_code(
1059: x_return_status OUT NOCOPY VARCHAR2,
1060: p_tbcv_rec IN tbcv_rec_type) IS
1061: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1062:
1063: l_dummy_var VARCHAR2(1) := '?' ;
1064:
1065: CURSOR okl_tbcv_saleprch_fk_csr (p_lookup_code IN VARCHAR2, p_lookup_type IN VARCHAR2) IS

Line 1083: OKC_API.set_message(g_app_name,

1079: FETCH okl_tbcv_saleprch_fk_csr INTO l_dummy_var ;
1080: CLOSE okl_tbcv_saleprch_fk_csr ;
1081: -- still set to default means data was not found
1082: IF ( l_dummy_var = '?' ) THEN
1083: OKC_API.set_message(g_app_name,
1084: g_no_parent_record,
1085: g_col_name_token,
1086: 'lease_purchased_code',
1087: g_child_table_token ,

Line 1091: l_return_status := OKC_API.G_RET_STS_ERROR;

1087: g_child_table_token ,
1088: 'OKL_TAX_ATTR_DEFINITIONS',
1089: g_parent_table_token ,
1090: 'FND_LOOKUP_VALUES');
1091: l_return_status := OKC_API.G_RET_STS_ERROR;
1092: END IF;
1093: END IF;
1094: x_return_status := l_return_status;
1095: EXCEPTION

Line 1113: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1109:
1110: PROCEDURE validate_equip_usage_code(
1111: x_return_status OUT NOCOPY VARCHAR2,
1112: p_tbcv_rec IN tbcv_rec_type) IS
1113: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1114:
1115: l_dummy_var VARCHAR2(1) := '?' ;
1116:
1117: CURSOR okl_tbcv_equsg_fk_csr (p_lookup_code IN VARCHAR2) IS

Line 1135: OKC_API.set_message(g_app_name,

1131: FETCH okl_tbcv_equsg_fk_csr INTO l_dummy_var ;
1132: CLOSE okl_tbcv_equsg_fk_csr ;
1133: -- still set to default means data was not found
1134: IF ( l_dummy_var = '?' ) THEN
1135: OKC_API.set_message(g_app_name,
1136: g_no_parent_record,
1137: g_col_name_token,
1138: 'equip_usage_code',
1139: g_child_table_token ,

Line 1143: l_return_status := OKC_API.G_RET_STS_ERROR;

1139: g_child_table_token ,
1140: 'OKL_TAX_ATTR_DEFINITIONS',
1141: g_parent_table_token ,
1142: 'ZX_FC_INTENDED_USE_V');
1143: l_return_status := OKC_API.G_RET_STS_ERROR;
1144: END IF;
1145: END IF;
1146: x_return_status := l_return_status;
1147: EXCEPTION

Line 1164: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1160: ---------------------------------------------
1161: PROCEDURE validate_vendor_site_id(
1162: x_return_status OUT NOCOPY VARCHAR2,
1163: p_tbcv_rec IN tbcv_rec_type) IS
1164: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1165:
1166: l_dummy_var VARCHAR2(1) := '?' ;
1167:
1168: CURSOR okl_tbcv_vsite_fk_csr (p_id IN NUMBER) IS

Line 1185: OKC_API.set_message(g_app_name,

1181: FETCH okl_tbcv_vsite_fk_csr into l_dummy_var ;
1182: CLOSE okl_tbcv_vsite_fk_csr ;
1183: -- still set to default means data was not found
1184: IF ( l_dummy_var = '?' ) THEN
1185: OKC_API.set_message(g_app_name,
1186: g_no_parent_record,
1187: g_col_name_token,
1188: 'vendor_site_id',
1189: g_child_table_token ,

Line 1193: l_return_status := OKC_API.G_RET_STS_ERROR;

1189: g_child_table_token ,
1190: 'OKL_TAX_ATTR_DEFINITIONS',
1191: g_parent_table_token ,
1192: 'Po_vendor_sites_all');
1193: l_return_status := OKC_API.G_RET_STS_ERROR;
1194:
1195: END IF;
1196: END IF;
1197: x_return_status := l_return_status;

Line 1217: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1213: -------------------------------------
1214: PROCEDURE validate_AGE_OF_EQUIP_FROM(
1215: x_return_status OUT NOCOPY VARCHAR2,
1216: p_tbcv_rec IN tbcv_rec_type) IS
1217: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1218:
1219:
1220: BEGIN
1221:

Line 1225: l_return_status := OKC_API.G_RET_STS_ERROR;

1221:
1222: IF (p_tbcv_rec.AGE_OF_EQUIP_FROM <> OKL_API.G_MISS_NUM AND p_tbcv_rec.AGE_OF_EQUIP_FROM IS NOT NULL)
1223: THEN
1224: IF p_tbcv_rec.AGE_OF_EQUIP_FROM < 0 THEN
1225: l_return_status := OKC_API.G_RET_STS_ERROR;
1226: --Unable to create Transcation Business Category definition as none of the attributes are provided.
1227: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'AGE_OF_EQUIP_FROM');
1228:
1229: END IF;

Line 1227: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'AGE_OF_EQUIP_FROM');

1223: THEN
1224: IF p_tbcv_rec.AGE_OF_EQUIP_FROM < 0 THEN
1225: l_return_status := OKC_API.G_RET_STS_ERROR;
1226: --Unable to create Transcation Business Category definition as none of the attributes are provided.
1227: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'AGE_OF_EQUIP_FROM');
1228:
1229: END IF;
1230: END IF;
1231: x_return_status := l_return_status;

Line 1250: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1246: -------------------------------------
1247: PROCEDURE validate_AGE_OF_EQUIP_TO(
1248: x_return_status OUT NOCOPY VARCHAR2,
1249: p_tbcv_rec IN tbcv_rec_type) IS
1250: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1251:
1252:
1253: BEGIN
1254:

Line 1258: l_return_status := OKC_API.G_RET_STS_ERROR;

1254:
1255: IF (p_tbcv_rec.AGE_OF_EQUIP_TO <> OKL_API.G_MISS_NUM AND p_tbcv_rec.AGE_OF_EQUIP_TO IS NOT NULL)
1256: THEN
1257: IF p_tbcv_rec.AGE_OF_EQUIP_TO < 0 THEN
1258: l_return_status := OKC_API.G_RET_STS_ERROR;
1259: --Unable to create Transcation Business Category definition as none of the attributes are provided.
1260: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'AGE_OF_EQUIP_TO');
1261:
1262: END IF;

Line 1260: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'AGE_OF_EQUIP_TO');

1256: THEN
1257: IF p_tbcv_rec.AGE_OF_EQUIP_TO < 0 THEN
1258: l_return_status := OKC_API.G_RET_STS_ERROR;
1259: --Unable to create Transcation Business Category definition as none of the attributes are provided.
1260: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'AGE_OF_EQUIP_TO');
1261:
1262: END IF;
1263: END IF;
1264: x_return_status := l_return_status;

Line 1283: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1279: ----------------------------------------------------
1280: PROCEDURE validate_object_version_number(
1281: x_return_status OUT NOCOPY VARCHAR2,
1282: p_tbcv_rec IN tbcv_rec_type) IS
1283: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1284: BEGIN
1285:
1286: IF (p_tbcv_rec.object_version_number = OKL_API.G_MISS_NUM OR p_tbcv_rec.object_version_number IS NULL)
1287: THEN

Line 1313: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1309: ----------------------------------------------------
1310: PROCEDURE validate_result_type_code(
1311: x_return_status OUT NOCOPY VARCHAR2,
1312: p_tbcv_rec IN tbcv_rec_type) IS
1313: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1314: l_dummy_var VARCHAR2(1) := '?' ;
1315:
1316: CURSOR okl_tbcv_res_type_fk_csr (p_id IN VARCHAR2) IS
1317: SELECT 'x'

Line 1330: OKC_API.set_message(g_app_name,

1326: FETCH okl_tbcv_res_type_fk_csr into l_dummy_var ;
1327: CLOSE okl_tbcv_res_type_fk_csr ;
1328: -- still set to default means data was not found
1329: IF ( l_dummy_var = '?' ) THEN
1330: OKC_API.set_message(g_app_name,
1331: g_no_parent_record,
1332: g_col_name_token,
1333: 'result_type_code',
1334: g_child_table_token ,

Line 1338: l_return_status := OKC_API.G_RET_STS_ERROR;

1334: g_child_table_token ,
1335: 'OKL_TAX_ATTR_DEFINITIONS',
1336: g_parent_table_token ,
1337: 'FND_LOOKUPS');
1338: l_return_status := OKC_API.G_RET_STS_ERROR;
1339:
1340: END IF;
1341: END IF;
1342: x_return_status := l_return_status;

Line 1361: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1357: ----------------------------------------------------
1358: PROCEDURE validate_book_class_code(
1359: x_return_status OUT NOCOPY VARCHAR2,
1360: p_tbcv_rec IN tbcv_rec_type) IS
1361: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1362: l_dummy_var VARCHAR2(1) := '?' ;
1363:
1364: CURSOR okl_tbcv_bc_fk_csr (p_id IN VARCHAR2) IS
1365: SELECT 'x'

Line 1378: OKC_API.set_message(g_app_name,

1374: FETCH okl_tbcv_bc_fk_csr into l_dummy_var ;
1375: CLOSE okl_tbcv_bc_fk_csr ;
1376: -- still set to default means data was not found
1377: IF ( l_dummy_var = '?' ) THEN
1378: OKC_API.set_message(g_app_name,
1379: g_no_parent_record,
1380: g_col_name_token,
1381: 'book_class_code',
1382: g_child_table_token ,

Line 1386: l_return_status := OKC_API.G_RET_STS_ERROR;

1382: g_child_table_token ,
1383: 'OKL_TAX_ATTR_DEFINITIONS',
1384: g_parent_table_token ,
1385: 'FND_LOOKUPS');
1386: l_return_status := OKC_API.G_RET_STS_ERROR;
1387:
1388: END IF;
1389: END IF;
1390: x_return_status := l_return_status;

Line 1409: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1405: ----------------------------------------------------
1406: PROCEDURE validate_date_eff_to(
1407: x_return_status OUT NOCOPY VARCHAR2,
1408: p_tbcv_rec IN tbcv_rec_type) IS
1409: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1410:
1411: BEGIN
1412:
1413: IF (p_tbcv_rec.date_effective_from <> OKL_API.G_MISS_DATE AND p_tbcv_rec.date_effective_from IS NOT NULL

Line 1423: l_return_status := OKC_API.G_RET_STS_ERROR;

1419: p_token1 => 'DATE_EFFECTIVE_TO',
1420: p_token1_value => p_tbcv_rec.date_effective_to,
1421: p_token2 => 'DATE_EFFECTIVE_FROM',
1422: p_token2_value => p_tbcv_rec.date_effective_from);
1423: l_return_status := OKC_API.G_RET_STS_ERROR;
1424:
1425: END IF;
1426: END IF;
1427: x_return_status := l_return_status;

Line 1446: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1442: ----------------------------------------------------
1443: PROCEDURE validate_tax_country_code(
1444: x_return_status OUT NOCOPY VARCHAR2,
1445: p_tbcv_rec IN tbcv_rec_type) IS
1446: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1447: l_dummy_var VARCHAR2(1) := '?' ;
1448:
1449: CURSOR okl_tbcv_tx_cntry_code_fk_csr (p_id IN VARCHAR2) IS
1450: SELECT 'x'

Line 1463: OKC_API.set_message(g_app_name,

1459: FETCH okl_tbcv_tx_cntry_code_fk_csr into l_dummy_var ;
1460: CLOSE okl_tbcv_tx_cntry_code_fk_csr ;
1461: -- still set to default means data was not found
1462: IF ( l_dummy_var = '?' ) THEN
1463: OKC_API.set_message(g_app_name,
1464: g_no_parent_record,
1465: g_col_name_token,
1466: 'tax_country_code',
1467: g_child_table_token ,

Line 1471: l_return_status := OKC_API.G_RET_STS_ERROR;

1467: g_child_table_token ,
1468: 'OKL_TAX_ATTR_DEFINITIONS',
1469: g_parent_table_token ,
1470: 'FND_TERRITORIES_TL');
1471: l_return_status := OKC_API.G_RET_STS_ERROR;
1472:
1473: END IF;
1474: END IF;
1475: x_return_status := l_return_status;

Line 1494: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1490: ----------------------------------------------------
1491: PROCEDURE validate_term_quote_type_code(
1492: x_return_status OUT NOCOPY VARCHAR2,
1493: p_tbcv_rec IN tbcv_rec_type) IS
1494: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1495: l_dummy_var VARCHAR2(1) := '?' ;
1496:
1497: CURSOR okl_tbcv_term_qtcode_fk_csr (p_id IN VARCHAR2) IS
1498: SELECT 'x'

Line 1512: OKC_API.set_message(g_app_name,

1508: FETCH okl_tbcv_term_qtcode_fk_csr into l_dummy_var ;
1509: CLOSE okl_tbcv_term_qtcode_fk_csr ;
1510: -- still set to default means data was not found
1511: IF ( l_dummy_var = '?' ) THEN
1512: OKC_API.set_message(g_app_name,
1513: g_no_parent_record,
1514: g_col_name_token,
1515: 'term_quote_type_code',
1516: g_child_table_token ,

Line 1520: l_return_status := OKC_API.G_RET_STS_ERROR;

1516: g_child_table_token ,
1517: 'OKL_TAX_ATTR_DEFINITIONS',
1518: g_parent_table_token ,
1519: 'FND_LOOKUPS');
1520: l_return_status := OKC_API.G_RET_STS_ERROR;
1521:
1522: END IF;
1523: END IF;
1524: x_return_status := l_return_status;

Line 1543: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1539: ----------------------------------------------------
1540: PROCEDURE validate_term_qt_reason_code(
1541: x_return_status OUT NOCOPY VARCHAR2,
1542: p_tbcv_rec IN tbcv_rec_type) IS
1543: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1544: l_dummy_var VARCHAR2(1) := '?' ;
1545:
1546: CURSOR okl_tbcv_term_qrcode_fk_csr (p_id IN VARCHAR2) IS
1547: SELECT 'x'

Line 1561: OKC_API.set_message(g_app_name,

1557: FETCH okl_tbcv_term_qrcode_fk_csr into l_dummy_var ;
1558: CLOSE okl_tbcv_term_qrcode_fk_csr ;
1559: -- still set to default means data was not found
1560: IF ( l_dummy_var = '?' ) THEN
1561: OKC_API.set_message(g_app_name,
1562: g_no_parent_record,
1563: g_col_name_token,
1564: 'term_quote_reason_code',
1565: g_child_table_token ,

Line 1569: l_return_status := OKC_API.G_RET_STS_ERROR;

1565: g_child_table_token ,
1566: 'OKL_TAX_ATTR_DEFINITIONS',
1567: g_parent_table_token ,
1568: 'FND_LOOKUPS');
1569: l_return_status := OKC_API.G_RET_STS_ERROR;
1570:
1571: END IF;
1572: END IF;
1573: x_return_status := l_return_status;

Line 1606: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1602: -- ***
1603: -- id
1604: -- ***
1605: /* validate_id(x_return_status, p_tbcv_rec);
1606: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1607: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1608: x_return_status := l_return_status;
1609: RAISE G_EXCEPTION_HALT_VALIDATION;
1610: ELSE

Line 1607: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1603: -- id
1604: -- ***
1605: /* validate_id(x_return_status, p_tbcv_rec);
1606: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1607: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1608: x_return_status := l_return_status;
1609: RAISE G_EXCEPTION_HALT_VALIDATION;
1610: ELSE
1611: x_return_status := l_return_status;

Line 1622: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1618: -- ***
1619: -- result_code
1620: -- ***
1621: validate_result_code(l_return_status, p_tbcv_rec);
1622: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1623: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1624: x_return_status := l_return_status;
1625: RAISE G_EXCEPTION_HALT_VALIDATION;
1626: ELSE

Line 1623: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1619: -- result_code
1620: -- ***
1621: validate_result_code(l_return_status, p_tbcv_rec);
1622: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1623: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1624: x_return_status := l_return_status;
1625: RAISE G_EXCEPTION_HALT_VALIDATION;
1626: ELSE
1627: x_return_status := l_return_status;

Line 1636: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1632: -- ***
1633: -- purchase_option_code
1634: -- ***
1635: validate_purchase_option_code(l_return_status, p_tbcv_rec);
1636: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1637: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1638: x_return_status := l_return_status;
1639: RAISE G_EXCEPTION_HALT_VALIDATION;
1640: ELSE

Line 1637: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1633: -- purchase_option_code
1634: -- ***
1635: validate_purchase_option_code(l_return_status, p_tbcv_rec);
1636: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1637: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1638: x_return_status := l_return_status;
1639: RAISE G_EXCEPTION_HALT_VALIDATION;
1640: ELSE
1641: x_return_status := l_return_status;

Line 1649: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1645: -- ***
1646: -- pdt_id
1647: -- ***
1648: validate_pdt_id(l_return_status, p_tbcv_rec);
1649: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1650: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1651: x_return_status := l_return_status;
1652: RAISE G_EXCEPTION_HALT_VALIDATION;
1653: ELSE

Line 1650: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1646: -- pdt_id
1647: -- ***
1648: validate_pdt_id(l_return_status, p_tbcv_rec);
1649: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1650: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1651: x_return_status := l_return_status;
1652: RAISE G_EXCEPTION_HALT_VALIDATION;
1653: ELSE
1654: x_return_status := l_return_status;

Line 1662: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1658: -- ***
1659: -- try_id
1660: -- ***
1661: validate_try_id(l_return_status, p_tbcv_rec);
1662: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1663: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1664: x_return_status := l_return_status;
1665: RAISE G_EXCEPTION_HALT_VALIDATION;
1666: ELSE

Line 1663: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1659: -- try_id
1660: -- ***
1661: validate_try_id(l_return_status, p_tbcv_rec);
1662: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1663: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1664: x_return_status := l_return_status;
1665: RAISE G_EXCEPTION_HALT_VALIDATION;
1666: ELSE
1667: x_return_status := l_return_status;

Line 1675: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1671: -- ***
1672: -- sty_id
1673: -- ***
1674: validate_sty_id(l_return_status, p_tbcv_rec);
1675: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1676: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1677: x_return_status := l_return_status;
1678: RAISE G_EXCEPTION_HALT_VALIDATION;
1679: ELSE

Line 1676: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1672: -- sty_id
1673: -- ***
1674: validate_sty_id(l_return_status, p_tbcv_rec);
1675: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1676: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1677: x_return_status := l_return_status;
1678: RAISE G_EXCEPTION_HALT_VALIDATION;
1679: ELSE
1680: x_return_status := l_return_status;

Line 1688: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1684: -- ***
1685: -- int_disclosed_code
1686: -- ***
1687: validate_int_disclosed_code(l_return_status, p_tbcv_rec);
1688: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1689: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1690: x_return_status := l_return_status;
1691: RAISE G_EXCEPTION_HALT_VALIDATION;
1692: ELSE

Line 1689: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1685: -- int_disclosed_code
1686: -- ***
1687: validate_int_disclosed_code(l_return_status, p_tbcv_rec);
1688: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1689: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1690: x_return_status := l_return_status;
1691: RAISE G_EXCEPTION_HALT_VALIDATION;
1692: ELSE
1693: x_return_status := l_return_status;

Line 1701: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1697: -- ***
1698: -- title_trnsfr_code
1699: -- ***
1700: validate_title_trnsfr_code(l_return_status, p_tbcv_rec);
1701: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1702: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1703: x_return_status := l_return_status;
1704: RAISE G_EXCEPTION_HALT_VALIDATION;
1705: ELSE

Line 1702: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1698: -- title_trnsfr_code
1699: -- ***
1700: validate_title_trnsfr_code(l_return_status, p_tbcv_rec);
1701: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1702: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1703: x_return_status := l_return_status;
1704: RAISE G_EXCEPTION_HALT_VALIDATION;
1705: ELSE
1706: x_return_status := l_return_status;

Line 1713: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1709: -- ***
1710: -- sale_lease_back_code
1711: -- ***
1712: validate_sale_lease_back_code(l_return_status, p_tbcv_rec);
1713: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1714: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1715: x_return_status := l_return_status;
1716: RAISE G_EXCEPTION_HALT_VALIDATION;
1717: ELSE

Line 1714: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1710: -- sale_lease_back_code
1711: -- ***
1712: validate_sale_lease_back_code(l_return_status, p_tbcv_rec);
1713: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1714: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1715: x_return_status := l_return_status;
1716: RAISE G_EXCEPTION_HALT_VALIDATION;
1717: ELSE
1718: x_return_status := l_return_status;

Line 1726: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1722: -- ***
1723: -- lease_purchased_code
1724: -- ***
1725: validate_lease_purchased_code(l_return_status, p_tbcv_rec);
1726: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1727: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1728: x_return_status := l_return_status;
1729: RAISE G_EXCEPTION_HALT_VALIDATION;
1730: ELSE

Line 1727: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1723: -- lease_purchased_code
1724: -- ***
1725: validate_lease_purchased_code(l_return_status, p_tbcv_rec);
1726: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1727: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1728: x_return_status := l_return_status;
1729: RAISE G_EXCEPTION_HALT_VALIDATION;
1730: ELSE
1731: x_return_status := l_return_status;

Line 1739: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1735: -- ***
1736: -- equip_usage_code
1737: -- ***
1738: validate_equip_usage_code(l_return_status, p_tbcv_rec);
1739: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1740: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1741: x_return_status := l_return_status;
1742: RAISE G_EXCEPTION_HALT_VALIDATION;
1743: ELSE

Line 1740: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1736: -- equip_usage_code
1737: -- ***
1738: validate_equip_usage_code(l_return_status, p_tbcv_rec);
1739: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1740: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1741: x_return_status := l_return_status;
1742: RAISE G_EXCEPTION_HALT_VALIDATION;
1743: ELSE
1744: x_return_status := l_return_status;

Line 1752: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1748: -- ***
1749: -- vendor_site_id
1750: -- ***
1751: validate_vendor_site_id(l_return_status, p_tbcv_rec);
1752: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1753: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1754: x_return_status := l_return_status;
1755: RAISE G_EXCEPTION_HALT_VALIDATION;
1756: ELSE

Line 1753: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1749: -- vendor_site_id
1750: -- ***
1751: validate_vendor_site_id(l_return_status, p_tbcv_rec);
1752: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1753: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1754: x_return_status := l_return_status;
1755: RAISE G_EXCEPTION_HALT_VALIDATION;
1756: ELSE
1757: x_return_status := l_return_status;

Line 1765: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1761: -- ***
1762: -- age_of_equip_from
1763: -- ***
1764: validate_age_of_equip_from(l_return_status, p_tbcv_rec);
1765: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1767: x_return_status := l_return_status;
1768: RAISE G_EXCEPTION_HALT_VALIDATION;
1769: ELSE

Line 1766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1762: -- age_of_equip_from
1763: -- ***
1764: validate_age_of_equip_from(l_return_status, p_tbcv_rec);
1765: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1766: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1767: x_return_status := l_return_status;
1768: RAISE G_EXCEPTION_HALT_VALIDATION;
1769: ELSE
1770: x_return_status := l_return_status;

Line 1778: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1774: -- ***
1775: -- age_of_equip_to
1776: -- ***
1777: validate_age_of_equip_to(l_return_status, p_tbcv_rec);
1778: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1779: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1780: x_return_status := l_return_status;
1781: RAISE G_EXCEPTION_HALT_VALIDATION;
1782: ELSE

Line 1779: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1775: -- age_of_equip_to
1776: -- ***
1777: validate_age_of_equip_to(l_return_status, p_tbcv_rec);
1778: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1779: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1780: x_return_status := l_return_status;
1781: RAISE G_EXCEPTION_HALT_VALIDATION;
1782: ELSE
1783: x_return_status := l_return_status;

Line 1791: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1787: -- ***
1788: -- object_version_number
1789: -- ***
1790: validate_object_version_number(l_return_status, p_tbcv_rec);
1791: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1792: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1793: x_return_status := l_return_status;
1794: RAISE G_EXCEPTION_HALT_VALIDATION;
1795: ELSE

Line 1792: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1788: -- object_version_number
1789: -- ***
1790: validate_object_version_number(l_return_status, p_tbcv_rec);
1791: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1792: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1793: x_return_status := l_return_status;
1794: RAISE G_EXCEPTION_HALT_VALIDATION;
1795: ELSE
1796: x_return_status := l_return_status;

Line 1806: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1802: -- ***
1803: -- result_type_code
1804: -- ***
1805: validate_result_type_code(l_return_status, p_tbcv_rec);
1806: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1807: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1808: x_return_status := l_return_status;
1809: RAISE G_EXCEPTION_HALT_VALIDATION;
1810: ELSE

Line 1807: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1803: -- result_type_code
1804: -- ***
1805: validate_result_type_code(l_return_status, p_tbcv_rec);
1806: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1807: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1808: x_return_status := l_return_status;
1809: RAISE G_EXCEPTION_HALT_VALIDATION;
1810: ELSE
1811: x_return_status := l_return_status;

Line 1819: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1815: -- ***
1816: -- book_class_code
1817: -- ***
1818: validate_book_class_code(l_return_status, p_tbcv_rec);
1819: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1820: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1821: x_return_status := l_return_status;
1822: RAISE G_EXCEPTION_HALT_VALIDATION;
1823: ELSE

Line 1820: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1816: -- book_class_code
1817: -- ***
1818: validate_book_class_code(l_return_status, p_tbcv_rec);
1819: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1820: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1821: x_return_status := l_return_status;
1822: RAISE G_EXCEPTION_HALT_VALIDATION;
1823: ELSE
1824: x_return_status := l_return_status;

Line 1832: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1828: -- ***
1829: -- Date check
1830: -- ***
1831: validate_date_eff_to(l_return_status, p_tbcv_rec);
1832: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1833: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1834: x_return_status := l_return_status;
1835: RAISE G_EXCEPTION_HALT_VALIDATION;
1836: ELSE

Line 1833: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1829: -- Date check
1830: -- ***
1831: validate_date_eff_to(l_return_status, p_tbcv_rec);
1832: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1833: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1834: x_return_status := l_return_status;
1835: RAISE G_EXCEPTION_HALT_VALIDATION;
1836: ELSE
1837: x_return_status := l_return_status;

Line 1845: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1841: -- ***
1842: -- tax_country_code
1843: -- ***
1844: validate_tax_country_code(l_return_status, p_tbcv_rec);
1845: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1846: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1847: x_return_status := l_return_status;
1848: RAISE G_EXCEPTION_HALT_VALIDATION;
1849: ELSE

Line 1846: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1842: -- tax_country_code
1843: -- ***
1844: validate_tax_country_code(l_return_status, p_tbcv_rec);
1845: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1846: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1847: x_return_status := l_return_status;
1848: RAISE G_EXCEPTION_HALT_VALIDATION;
1849: ELSE
1850: x_return_status := l_return_status;

Line 1858: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1854: -- ***
1855: -- term_quote_type_code
1856: -- ***
1857: validate_term_quote_type_code(l_return_status, p_tbcv_rec);
1858: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1859: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1860: x_return_status := l_return_status;
1861: RAISE G_EXCEPTION_HALT_VALIDATION;
1862: ELSE

Line 1859: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1855: -- term_quote_type_code
1856: -- ***
1857: validate_term_quote_type_code(l_return_status, p_tbcv_rec);
1858: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1859: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1860: x_return_status := l_return_status;
1861: RAISE G_EXCEPTION_HALT_VALIDATION;
1862: ELSE
1863: x_return_status := l_return_status;

Line 1871: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1867: -- ***
1868: -- term_quote_reason_code
1869: -- ***
1870: validate_term_qt_reason_code(l_return_status, p_tbcv_rec);
1871: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1872: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1873: x_return_status := l_return_status;
1874: RAISE G_EXCEPTION_HALT_VALIDATION;
1875: ELSE

Line 1872: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1868: -- term_quote_reason_code
1869: -- ***
1870: validate_term_qt_reason_code(l_return_status, p_tbcv_rec);
1871: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1872: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1873: x_return_status := l_return_status;
1874: RAISE G_EXCEPTION_HALT_VALIDATION;
1875: ELSE
1876: x_return_status := l_return_status;

Line 2277: x_return_status := OKC_API.G_RET_STS_ERROR;

2273: -- (p_tbcv_rec.AGE_OF_EQUIP_FROM = OKL_API.G_MISS_NUM OR p_tbcv_rec.AGE_OF_EQUIP_FROM IS NULL) AND
2274: -- (p_tbcv_rec.AGE_OF_EQUIP_TO = OKL_API.G_MISS_NUM OR p_tbcv_rec.AGE_OF_EQUIP_TO IS NULL)
2275: (p_tbcv_rec.RESULT_CODE = OKL_API.G_MISS_CHAR OR p_tbcv_rec.RESULT_CODE IS NULL) ) THEN
2276:
2277: x_return_status := OKC_API.G_RET_STS_ERROR;
2278: --Unable to create Category definition as mandatory attributes are provided.
2279: OKL_API.set_message(p_app_name => 'OKL',
2280: p_msg_name => 'OKL_TX_NO_TBC_ATTR');
2281: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 2287: x_return_status := OKC_API.G_RET_STS_ERROR;

2283: END IF;
2284: IF (p_tbcv_rec.AGE_OF_EQUIP_FROM IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_FROM <> OKL_API.G_MISS_NUM) AND
2285: (p_tbcv_rec.AGE_OF_EQUIP_TO IS NOT NULL AND p_tbcv_rec.AGE_OF_EQUIP_TO <> OKL_API.G_MISS_NUM) THEN
2286: IF p_tbcv_rec.AGE_OF_EQUIP_TO < p_tbcv_rec.AGE_OF_EQUIP_FROM THEN
2287: x_return_status := OKC_API.G_RET_STS_ERROR;
2288: --Unable to create Transcation Business Category definition as none of the attributes are provided.
2289: OKL_API.set_message(p_app_name => 'OKL',
2290: p_msg_name => 'OKL_TX_INVALID_AGE_RANGE');
2291: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 2337: x_return_status := OKC_API.G_RET_STS_ERROR;

2333: 'Rollover Credit Memo',
2334: 'Release Billing',
2335: 'Release Credit Memo') THEN
2336:
2337: x_return_status := OKC_API.G_RET_STS_ERROR;
2338: OKL_API.set_message(p_app_name => 'OKL',
2339: p_msg_name => 'OKL_TERMQTE_RSNTYP_NA_ERR',
2340: p_token1 => 'TRX_TYPE',
2341: p_token1_value => l_try_name);

Line 2361: x_return_status := OKC_API.G_RET_STS_ERROR;

2357: 'Rollover Credit Memo',
2358: 'Release Billing',
2359: 'Release Credit Memo') THEN
2360:
2361: x_return_status := OKC_API.G_RET_STS_ERROR;
2362: OKL_API.set_message(p_app_name => 'OKL',
2363: p_msg_name => 'OKL_TERMQTE_RSNTYP_NA_ERR',
2364: p_token1 => 'TRX_TYPE',
2365: p_token1_value => l_try_name);

Line 2390: x_return_status := OKC_API.G_RET_STS_ERROR;

2386: -- modified by dcshanmu for eBTax project - modification end
2387:
2388: -- There can be at the most one duplicate record.
2389: IF l_result_code <> 'XXXXX' THEN
2390: x_return_status := OKC_API.G_RET_STS_ERROR;
2391: -- Another Category already exists for this combination of tax determinants.
2392: -- modified by dcshanmu for eBTax project - modification start
2393: -- modified default values passed to p_msg_name and p_token1
2394: