DBA Data[Home] [Help]

APPS.OKL_SAO_PVT dependencies on OKL_ACCOUNTING_UTIL

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

662: IF (p_saov_rec.SECONDARY_REP_METHOD <> Okc_Api.G_MISS_CHAR) AND
663: (p_saov_rec.SECONDARY_REP_METHOD IS NOT NULL)
664: THEN
665: l_dummy
666: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_SEC_REP_METHOD',
667: p_lookup_code => p_saov_rec.SECONDARY_REP_METHOD);
668:
669: IF (l_dummy = Okc_Api.G_FALSE) THEN
670: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

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

713: IF (p_saov_rec.AEL_APPLY_ROUNDING_DIFFERENCE <> Okc_Api.G_MISS_CHAR ) AND
714: (p_saov_rec.AEL_APPLY_ROUNDING_DIFFERENCE IS NOT NULL) THEN
715:
716: l_dummy
717: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_APPLY_ROUNDING_DIFF',
718: p_lookup_code => p_saov_rec.ael_apply_rounding_difference);
719:
720: IF (l_dummy = Okc_Api.G_FALSE) THEN
721: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

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

769: IF (p_saov_rec.CC_APPLY_ROUNDING_DIFFERENCE <> Okc_Api.G_MISS_CHAR) AND
770: (p_saov_rec.CC_APPLY_ROUNDING_DIFFERENCE IS NOT NULL)
771: THEN
772: l_dummy
773: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_APPLY_ROUNDING_DIFF',
774: p_lookup_code => p_saov_rec.cc_apply_rounding_difference);
775:
776: IF (l_dummy = Okc_Api.G_FALSE) THEN
777: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

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

932:
933: -- check for data before processing
934: IF (p_saov_rec.cc_rep_currency_code IS NOT NULL) AND
935: (p_saov_rec.cc_rep_currency_code <> Okc_Api.G_MISS_CHAR) THEN
936: l_dummy := OKL_ACCOUNTING_UTIL.validate_currency_code(p_saov_rec.cc_rep_currency_code);
937:
938: IF (l_dummy = okc_api.g_false) THEN
939: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
940: p_msg_name => g_invalid_value,

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

991: -- check for data before processing
992: IF (p_saov_rec.ael_rep_currency_code IS NOT NULL) AND
993: (p_saov_rec.ael_rep_currency_code <> Okc_Api.G_MISS_CHAR) THEN
994:
995: l_dummy := OKL_ACCOUNTING_UTIL.validate_currency_code(p_saov_rec.ael_rep_currency_code);
996:
997:
998: IF (l_dummy = okc_api.g_false) THEN
999: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

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

1112: -- Validate CODE_COMBINATION_ID
1113:
1114: IF (p_saov_rec.code_combination_id IS NOT NULL) AND
1115: (p_saov_rec.code_combination_id <> OKC_API.G_MISS_NUM) THEN
1116: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.code_combination_id);
1117: IF (l_dummy = okc_api.g_false) THEN
1118: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1119: p_msg_name => g_invalid_value,
1120: p_token1 => g_col_name_token,

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

1125:
1126: -- Validate REC_CCID
1127:
1128: IF (p_saov_rec.rec_ccid IS NOT NULL) AND (p_saov_rec.Rec_ccid <> OKC_API.G_MISS_NUM) THEN
1129: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.REC_CCID);
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 1143: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.Realized_gain_CCID);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1265: -- Validate FUT_DATE_PAY_CCID
1266:
1267: IF (p_saov_rec.fut_date_pay_CCID IS NOT NULL) AND
1268: (p_saov_rec.fut_date_pay_CCID <> OKC_API.G_MISS_NUM) THEN
1269: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_saov_rec.fut_date_pay_CCID);
1270: IF (l_dummy = okc_api.g_false) THEN
1271: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1272: p_msg_name => g_invalid_value,
1273: p_token1 => g_col_name_token,

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

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

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

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

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

1355: -- initialize return status
1356: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1357:
1358: IF (p_saov_rec.cc_rounding_rule IS NOT NULL) THEN
1359: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ROUNDING_RULE',
1360: p_lookup_code => p_saov_rec.cc_rounding_rule);
1361:
1362: IF (l_dummy = OKC_API.G_FALSE) THEN
1363: Okc_Api.SET_MESSAGE(p_app_name => G_APP_NAME

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

1414:
1415: IF (p_saov_rec.ael_rounding_rule IS NOT NULL) AND
1416: (p_saov_rec.ael_rounding_rule <> OKC_API.G_MISS_CHAR)
1417: THEN
1418: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ROUNDING_RULE',
1419: p_lookup_code => p_saov_rec.ael_rounding_rule);
1420:
1421: IF (l_dummy = OKC_API.G_FALSE) THEN
1422:

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

1524: IF (p_saov_rec.STM_APPLY_ROUNDING_DIFFERENCE <> Okc_Api.G_MISS_CHAR ) AND
1525: (p_saov_rec.STM_APPLY_ROUNDING_DIFFERENCE IS NOT NULL) THEN
1526:
1527: l_dummy
1528: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_STRM_APPLY_ROUNDING_DIFF',
1529: p_lookup_code => p_saov_rec.stm_apply_rounding_difference);
1530:
1531: IF (l_dummy = Okc_Api.G_FALSE) THEN
1532: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

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

1586:
1587: IF (p_saov_rec.stm_rounding_rule IS NOT NULL) AND
1588: (p_saov_rec.stm_rounding_rule <> OKC_API.G_MISS_CHAR)
1589: THEN
1590: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ROUNDING_RULE',
1591: p_lookup_code => p_saov_rec.stm_rounding_rule);
1592:
1593: IF (l_dummy = OKC_API.G_FALSE) THEN
1594:

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

1638: IF (p_saov_rec.ISG_ARREARS_PAY_DATES_OPTION <> Okc_Api.G_MISS_CHAR ) AND
1639: (p_saov_rec.ISG_ARREARS_PAY_DATES_OPTION IS NOT NULL) THEN
1640:
1641: l_dummy
1642: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ISG_ARREAR_PAY_DATE_OPTION',
1643: p_lookup_code => p_saov_rec.isg_arrears_pay_dates_option);
1644:
1645: IF (l_dummy = Okc_Api.G_FALSE) THEN
1646: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

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

1694: IF (p_saov_rec.VALIDATE_KHR_START_DATE <> Okc_Api.G_MISS_CHAR) AND
1695: (p_saov_rec.VALIDATE_KHR_START_DATE IS NOT NULL)
1696: THEN
1697: l_dummy
1698: := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_ACCRUAL_STREAMS_BASIS',
1699: p_lookup_code => p_saov_rec.validate_khr_start_date);
1700:
1701: IF (l_dummy = Okc_Api.G_FALSE) THEN
1702: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 1755: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(

1751: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1752: IF (p_saov_rec.account_derivation IS NOT NULL) AND
1753: (p_saov_rec.account_derivation <> OKC_API.G_MISS_CHAR)
1754: THEN
1755: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(
1756: p_lookup_type => 'OKL_ACCOUNT_DERIVATION_OPTION',
1757: p_lookup_code => p_saov_rec.account_derivation);
1758: IF (l_dummy = OKC_API.G_FALSE)
1759: THEN