DBA Data[Home] [Help]

APPS.OKL_SAO_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 679: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_SEC_REP_METHOD',

675: IF (p_saov_rec.SECONDARY_REP_METHOD <> Okc_Api.G_MISS_CHAR) AND
676: (p_saov_rec.SECONDARY_REP_METHOD IS NOT NULL)
677: THEN
678: l_dummy
679: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_SEC_REP_METHOD',
680: p_lookup_code => p_saov_rec.SECONDARY_REP_METHOD);
681:
682: IF (l_dummy = Okc_Api.G_FALSE) THEN
683: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 730: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_APPLY_ROUNDING_DIFF',

726: IF (p_saov_rec.AEL_APPLY_ROUNDING_DIFFERENCE <> Okc_Api.G_MISS_CHAR ) AND
727: (p_saov_rec.AEL_APPLY_ROUNDING_DIFFERENCE IS NOT NULL) THEN
728:
729: l_dummy
730: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_APPLY_ROUNDING_DIFF',
731: p_lookup_code => p_saov_rec.ael_apply_rounding_difference);
732:
733: IF (l_dummy = Okc_Api.G_FALSE) THEN
734: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 786: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_APPLY_ROUNDING_DIFF',

782: IF (p_saov_rec.CC_APPLY_ROUNDING_DIFFERENCE <> Okc_Api.G_MISS_CHAR) AND
783: (p_saov_rec.CC_APPLY_ROUNDING_DIFFERENCE IS NOT NULL)
784: THEN
785: l_dummy
786: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_APPLY_ROUNDING_DIFF',
787: p_lookup_code => p_saov_rec.cc_apply_rounding_difference);
788:
789: IF (l_dummy = Okc_Api.G_FALSE) THEN
790: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 949: l_dummy := OKL_ACCOUNTING_UTIL.validate_currency_code(p_saov_rec.cc_rep_currency_code);

945:
946: -- check for data before processing
947: IF (p_saov_rec.cc_rep_currency_code IS NOT NULL) AND
948: (p_saov_rec.cc_rep_currency_code <> Okc_Api.G_MISS_CHAR) THEN
949: l_dummy := OKL_ACCOUNTING_UTIL.validate_currency_code(p_saov_rec.cc_rep_currency_code);
950:
951: IF (l_dummy = okc_api.g_false) THEN
952: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
953: p_msg_name => g_invalid_value,

Line 1008: l_dummy := OKL_ACCOUNTING_UTIL.validate_currency_code(p_saov_rec.ael_rep_currency_code);

1004: -- check for data before processing
1005: IF (p_saov_rec.ael_rep_currency_code IS NOT NULL) AND
1006: (p_saov_rec.ael_rep_currency_code <> Okc_Api.G_MISS_CHAR) THEN
1007:
1008: l_dummy := OKL_ACCOUNTING_UTIL.validate_currency_code(p_saov_rec.ael_rep_currency_code);
1009:
1010:
1011: IF (l_dummy = okc_api.g_false) THEN
1012: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

Line 1129: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.code_combination_id);

1125: -- Validate CODE_COMBINATION_ID
1126:
1127: IF (p_saov_rec.code_combination_id IS NOT NULL) AND
1128: (p_saov_rec.code_combination_id <> OKC_API.G_MISS_NUM) THEN
1129: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.code_combination_id);
1130: IF (l_dummy = okc_api.g_false) THEN
1131: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1132: p_msg_name => g_invalid_value,
1133: p_token1 => g_col_name_token,

Line 1142: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.REC_CCID);

1138:
1139: -- Validate REC_CCID
1140:
1141: IF (p_saov_rec.rec_ccid IS NOT NULL) AND (p_saov_rec.Rec_ccid <> OKC_API.G_MISS_NUM) THEN
1142: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.REC_CCID);
1143: IF (l_dummy = okc_api.g_false) THEN
1144: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1145: p_msg_name => g_invalid_value,
1146: p_token1 => g_col_name_token,

Line 1156: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.Realized_gain_CCID);

1152: -- Validate Realized_Gain_CCID
1153:
1154: IF (p_saov_rec.realized_gain_CCID IS NOT NULL) AND
1155: (p_saov_rec.realized_gain_CCID <> OKC_API.G_MISS_NUM) THEN
1156: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.Realized_gain_CCID);
1157: IF (l_dummy = okc_api.g_false) THEN
1158: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1159: p_msg_name => g_invalid_value,
1160: p_token1 => g_col_name_token,

Line 1170: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.realized_loss_CCID);

1166: -- Validate Realized_loss_CCID
1167:
1168: IF (p_saov_rec.realized_loss_CCID IS NOT NULL) AND
1169: (p_saov_rec.realized_loss_CCID <> OKC_API.G_MISS_NUM) THEN
1170: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.realized_loss_CCID);
1171: IF (l_dummy = okc_api.g_false) THEN
1172: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1173: p_msg_name => g_invalid_value,
1174: p_token1 => g_col_name_token,

Line 1182: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.tax_ccid);

1178: END IF;
1179:
1180: -- Validate Tax_CCID
1181: IF (p_saov_rec.tax_ccid IS NOT NULL) AND (p_saov_rec.tax_ccid <> OKC_API.G_MISS_NUM) THEN
1182: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.tax_ccid);
1183: IF (l_dummy = okc_api.g_false) THEN
1184: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1185: p_msg_name => g_invalid_value,
1186: p_token1 => g_col_name_token,

Line 1196: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.cross_currency_CCID);

1192: -- Validate Cross_Currency_CCID
1193:
1194: IF (p_saov_rec.cross_currency_CCID IS NOT NULL) AND
1195: (p_saov_rec.cross_currency_CCID <> OKC_API.G_MISS_NUM) THEN
1196: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.cross_currency_CCID);
1197: IF (l_dummy = okc_api.g_false) THEN
1198: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1199: p_msg_name => g_invalid_value,
1200: p_token1 => g_col_name_token,

Line 1210: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.rounding_CCID);

1206: -- Validate Rounding_CCID
1207:
1208: IF (p_saov_rec.rounding_CCID IS NOT NULL) AND
1209: (p_saov_rec.rounding_CCID <> OKC_API.G_MISS_NUM) THEN
1210: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.rounding_CCID);
1211: IF (l_dummy = okc_api.g_false) THEN
1212: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1213: p_msg_name => g_invalid_value,
1214: p_token1 => g_col_name_token,

Line 1224: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.AR_CLEARING_CCID);

1220: -- Validate AR_CLEARING_CCID
1221:
1222: IF (p_saov_rec.AR_CLEARING_CCID IS NOT NULL) AND
1223: (p_saov_rec.AR_CLEARING_CCID <> OKC_API.G_MISS_NUM) THEN
1224: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.AR_CLEARING_CCID);
1225: IF (l_dummy = okc_api.g_false) THEN
1226: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1227: p_msg_name => g_invalid_value,
1228: p_token1 => g_col_name_token,

Line 1238: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.PAYABLES_CCID);

1234: -- Validate PAYABLES_CCID
1235:
1236: IF (p_saov_rec.PAYABLES_CCID IS NOT NULL) AND
1237: (p_saov_rec.PAYABLES_CCID <> OKC_API.G_MISS_NUM) THEN
1238: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.PAYABLES_CCID);
1239: IF (l_dummy = okc_api.g_false) THEN
1240: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1241: p_msg_name => g_invalid_value,
1242: p_token1 => g_col_name_token,

Line 1252: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.liablity_ccid);

1248: -- Validate LIABLITY_CCID
1249:
1250: IF (p_saov_rec.liablity_ccid IS NOT NULL) AND
1251: (p_saov_rec.liablity_ccid <> OKC_API.G_MISS_NUM) THEN
1252: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.liablity_ccid);
1253: IF (l_dummy = okc_api.g_false) THEN
1254: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1255: p_msg_name => g_invalid_value,
1256: p_token1 => g_col_name_token,

Line 1266: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.pre_payment_ccid);

1262: -- Validate PRE_PAYMENT_CCID
1263:
1264: IF (p_saov_rec.pre_payment_ccid IS NOT NULL) AND
1265: (p_saov_rec.pre_payment_ccid <> OKC_API.G_MISS_NUM) THEN
1266: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.pre_payment_ccid);
1267: IF (l_dummy = okc_api.g_false) THEN
1268: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1269: p_msg_name => g_invalid_value,
1270: p_token1 => g_col_name_token,

Line 1282: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.fut_date_pay_CCID);

1278: -- Validate FUT_DATE_PAY_CCID
1279:
1280: IF (p_saov_rec.fut_date_pay_CCID IS NOT NULL) AND
1281: (p_saov_rec.fut_date_pay_CCID <> OKC_API.G_MISS_NUM) THEN
1282: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.fut_date_pay_CCID);
1283: IF (l_dummy = okc_api.g_false) THEN
1284: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1285: p_msg_name => g_invalid_value,
1286: p_token1 => g_col_name_token,

Line 1297: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.DIS_TAKEN_CCID);

1293: -- Validate DIS_TAKEN_CCID
1294:
1295: IF (p_saov_rec.DIS_TAKEN_CCID IS NOT NULL) AND
1296: (p_saov_rec.DIS_TAKEN_CCID <> OKC_API.G_MISS_NUM) THEN
1297: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.DIS_TAKEN_CCID);
1298: IF (l_dummy = okc_api.g_false) THEN
1299: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1300: p_msg_name => g_invalid_value,
1301: p_token1 => g_col_name_token,

Line 1311: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.AR_CLEARING_CCID);

1307: -- Validate AP_CLEARING_CCID
1308:
1309: IF (p_saov_rec.AR_CLEARING_CCID IS NOT NULL) AND
1310: (p_saov_rec.AR_CLEARING_CCID <> OKC_API.G_MISS_NUM) THEN
1311: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.AR_CLEARING_CCID);
1312: IF (l_dummy = okc_api.g_false) THEN
1313: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1314: p_msg_name => g_invalid_value,
1315: p_token1 => g_col_name_token,

Line 1372: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ROUNDING_RULE',

1368: -- initialize return status
1369: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1370:
1371: IF (p_saov_rec.cc_rounding_rule IS NOT NULL) THEN
1372: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ROUNDING_RULE',
1373: p_lookup_code => p_saov_rec.cc_rounding_rule);
1374:
1375: IF (l_dummy = OKC_API.G_FALSE) THEN
1376: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

Line 1431: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ROUNDING_RULE',

1427:
1428: IF (p_saov_rec.ael_rounding_rule IS NOT NULL) AND
1429: (p_saov_rec.ael_rounding_rule <> OKC_API.G_MISS_CHAR)
1430: THEN
1431: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ROUNDING_RULE',
1432: p_lookup_code => p_saov_rec.ael_rounding_rule);
1433:
1434: IF (l_dummy = OKC_API.G_FALSE) THEN
1435:

Line 1541: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_STRM_APPLY_ROUNDING_DIFF',

1537: IF (p_saov_rec.STM_APPLY_ROUNDING_DIFFERENCE <> Okc_Api.G_MISS_CHAR ) AND
1538: (p_saov_rec.STM_APPLY_ROUNDING_DIFFERENCE IS NOT NULL) THEN
1539:
1540: l_dummy
1541: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_STRM_APPLY_ROUNDING_DIFF',
1542: p_lookup_code => p_saov_rec.stm_apply_rounding_difference);
1543:
1544: IF (l_dummy = Okc_Api.G_FALSE) THEN
1545: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 1603: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ROUNDING_RULE',

1599:
1600: IF (p_saov_rec.stm_rounding_rule IS NOT NULL) AND
1601: (p_saov_rec.stm_rounding_rule <> OKC_API.G_MISS_CHAR)
1602: THEN
1603: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ROUNDING_RULE',
1604: p_lookup_code => p_saov_rec.stm_rounding_rule);
1605:
1606: IF (l_dummy = OKC_API.G_FALSE) THEN
1607:

Line 1655: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ISG_ARREAR_PAY_DATE_OPTION',

1651: IF (p_saov_rec.ISG_ARREARS_PAY_DATES_OPTION <> Okc_Api.G_MISS_CHAR ) AND
1652: (p_saov_rec.ISG_ARREARS_PAY_DATES_OPTION IS NOT NULL) THEN
1653:
1654: l_dummy
1655: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ISG_ARREAR_PAY_DATE_OPTION',
1656: p_lookup_code => p_saov_rec.isg_arrears_pay_dates_option);
1657:
1658: IF (l_dummy = Okc_Api.G_FALSE) THEN
1659: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 1720: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_YES_NO',

1716: IF (p_saov_rec.AMORT_INC_ADJ_REV_DT_YN <> Okc_Api.G_MISS_CHAR ) AND
1717: (p_saov_rec.AMORT_INC_ADJ_REV_DT_YN IS NOT NULL) THEN
1718:
1719: l_dummy
1720: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_YES_NO',
1721: p_lookup_code => p_saov_rec.amort_inc_adj_rev_dt_yn);
1722:
1723: IF (l_dummy = Okc_Api.G_FALSE) THEN
1724: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 1776: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ACCRUAL_STREAMS_BASIS',

1772: IF (p_saov_rec.VALIDATE_KHR_START_DATE <> Okc_Api.G_MISS_CHAR) AND
1773: (p_saov_rec.VALIDATE_KHR_START_DATE IS NOT NULL)
1774: THEN
1775: l_dummy
1776: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ACCRUAL_STREAMS_BASIS',
1777: p_lookup_code => p_saov_rec.validate_khr_start_date);
1778:
1779: IF (l_dummy = Okc_Api.G_FALSE) THEN
1780: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 1833: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(

1829: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1830: IF (p_saov_rec.account_derivation IS NOT NULL) AND
1831: (p_saov_rec.account_derivation <> OKC_API.G_MISS_CHAR)
1832: THEN
1833: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(
1834: p_lookup_type => 'OKL_ACCOUNT_DERIVATION_OPTION',
1835: p_lookup_code => p_saov_rec.account_derivation);
1836: IF (l_dummy = OKC_API.G_FALSE)
1837: THEN