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_ACCOUNTING_UTIL dependencies on OKL_API

Line 213: RETURN Okl_Api.g_true;

209: FETCH lkup_csr INTO l_found;
210: CLOSE lkup_csr;
211:
212: IF l_found IS NOT NULL THEN
213: RETURN Okl_Api.g_true;
214: ELSE
215: RETURN Okl_Api.g_false;
216: END IF;
217:

Line 215: RETURN Okl_Api.g_false;

211:
212: IF l_found IS NOT NULL THEN
213: RETURN Okl_Api.g_true;
214: ELSE
215: RETURN Okl_Api.g_false;
216: END IF;
217:
218: EXCEPTION
219: WHEN OTHERS THEN

Line 220: RETURN Okl_Api.g_false;

216: END IF;
217:
218: EXCEPTION
219: WHEN OTHERS THEN
220: RETURN Okl_Api.g_false;
221:
222: END validate_lookup_code;
223:
224:

Line 339: RETURN Okl_Api.G_TRUE;

335: FETCH curr_csr INTO l_found;
336: CLOSE curr_csr;
337:
338: IF l_found IS NOT NULL THEN
339: RETURN Okl_Api.G_TRUE;
340: ELSE
341: RETURN Okl_Api.G_FALSE;
342: END IF;
343:

Line 341: RETURN Okl_Api.G_FALSE;

337:
338: IF l_found IS NOT NULL THEN
339: RETURN Okl_Api.G_TRUE;
340: ELSE
341: RETURN Okl_Api.G_FALSE;
342: END IF;
343:
344: EXCEPTION
345: WHEN OTHERS THEN

Line 346: RETURN Okl_Api.G_FALSE;

342: END IF;
343:
344: EXCEPTION
345: WHEN OTHERS THEN
346: RETURN Okl_Api.G_FALSE;
347: END validate_currency_code;
348:
349: /**************************************************************************/
350: /* rkuttiya modified for Multi GAAP project

Line 386: RETURN Okl_Api.G_TRUE;

382: FETCH ccid_csr INTO l_found;
383: CLOSE ccid_csr;
384:
385: IF l_found IS NOT NULL THEN
386: RETURN Okl_Api.G_TRUE;
387: ELSE
388: RETURN Okl_Api.G_FALSE;
389: END IF;
390:

Line 388: RETURN Okl_Api.G_FALSE;

384:
385: IF l_found IS NOT NULL THEN
386: RETURN Okl_Api.G_TRUE;
387: ELSE
388: RETURN Okl_Api.G_FALSE;
389: END IF;
390:
391: EXCEPTION
392: WHEN OTHERS THEN

Line 393: RETURN Okl_Api.G_FALSE;

389: END IF;
390:
391: EXCEPTION
392: WHEN OTHERS THEN
393: RETURN Okl_Api.G_FALSE;
394: END validate_gl_ccid;
395:
396: /**************************************************************************/
397: --Added p_ledger_id argument as part of bug 5707866 by nikshah

Line 592: RETURN okl_api.g_false;

588: EXECUTE IMMEDIATE l_select_string
589: INTO l_found
590: USING p_source_id;
591: ELSE
592: RETURN okl_api.g_false;
593: END IF;
594: RETURN okl_api.g_true;
595: EXCEPTION
596: WHEN OTHERS THEN

Line 594: RETURN okl_api.g_true;

590: USING p_source_id;
591: ELSE
592: RETURN okl_api.g_false;
593: END IF;
594: RETURN okl_api.g_true;
595: EXCEPTION
596: WHEN OTHERS THEN
597: RETURN okl_api.g_false;
598: END validate_source_id_table;

Line 597: RETURN okl_api.g_false;

593: END IF;
594: RETURN okl_api.g_true;
595: EXCEPTION
596: WHEN OTHERS THEN
597: RETURN okl_api.g_false;
598: END validate_source_id_table;
599:
600: /**************************************************************************/
601: --Added p_ledger_id argument as part of bug 5707866 by nikshah

Line 772: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

768: l_pos_dot NUMBER;
769: l_to_add NUMBER := 1;
770: l_sysdate DATE := G_SYSDATE;
771:
772: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
773: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
774: l_msg_count NUMBER := 0;
775: l_msg_data VARCHAR2(2000);
776: l_api_version NUMBER := 1.0;

Line 773: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

769: l_to_add NUMBER := 1;
770: l_sysdate DATE := G_SYSDATE;
771:
772: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
773: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
774: l_msg_count NUMBER := 0;
775: l_msg_data VARCHAR2(2000);
776: l_api_version NUMBER := 1.0;
777:

Line 795: x_return_status := OKL_API.G_RET_STS_SUCCESS;

791: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);
792:
793: BEGIN
794:
795: x_return_status := OKL_API.G_RET_STS_SUCCESS;
796:
797: IF (p_round_option ='CC') THEN
798: FOR round_rec IN round_csr LOOP
799: l_rounding_rule := round_rec.cc_rounding_rule;

Line 814: x_return_status := OKL_API.G_RET_STS_ERROR;

810: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
811: ,p_msg_name => g_invalid_value
812: ,p_token1 => g_col_name_token
813: ,p_token1_value => 'ROUND_OPTION');
814: x_return_status := OKL_API.G_RET_STS_ERROR;
815: RAISE OKL_API.G_EXCEPTION_ERROR;
816:
817: END IF;
818:

Line 815: RAISE OKL_API.G_EXCEPTION_ERROR;

811: ,p_msg_name => g_invalid_value
812: ,p_token1 => g_col_name_token
813: ,p_token1_value => 'ROUND_OPTION');
814: x_return_status := OKL_API.G_RET_STS_ERROR;
815: RAISE OKL_API.G_EXCEPTION_ERROR;
816:
817: END IF;
818:
819:

Line 821: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

817: END IF;
818:
819:
820: IF l_rounding_rule IS NULL THEN
821: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
822: p_msg_name => 'OKL_NO_ROUNDING_RULE');
823: x_return_status := OKL_API.G_RET_STS_ERROR;
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;

Line 823: x_return_status := OKL_API.G_RET_STS_ERROR;

819:
820: IF l_rounding_rule IS NULL THEN
821: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
822: p_msg_name => 'OKL_NO_ROUNDING_RULE');
823: x_return_status := OKL_API.G_RET_STS_ERROR;
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;
826:
827:

Line 824: RAISE OKL_API.G_EXCEPTION_ERROR;

820: IF l_rounding_rule IS NULL THEN
821: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
822: p_msg_name => 'OKL_NO_ROUNDING_RULE');
823: x_return_status := OKL_API.G_RET_STS_ERROR;
824: RAISE OKL_API.G_EXCEPTION_ERROR;
825: END IF;
826:
827:
828: FOR prec_rec IN prec_csr LOOP

Line 833: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

829: l_precision := prec_rec.precision;
830: END LOOP;
831:
832: IF l_precision IS NULL THEN
833: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
834: p_msg_name => 'OKL_NO_CURR_PRECISION',
835: p_token1 => 'CURRENCY_CODE',
836: p_token1_value => p_currency_code);
837: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 837: x_return_status := OKL_API.G_RET_STS_ERROR;

833: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
834: p_msg_name => 'OKL_NO_CURR_PRECISION',
835: p_token1 => 'CURRENCY_CODE',
836: p_token1_value => p_currency_code);
837: x_return_status := OKL_API.G_RET_STS_ERROR;
838: RAISE OKL_API.G_EXCEPTION_ERROR;
839: END IF;
840:
841:

Line 838: RAISE OKL_API.G_EXCEPTION_ERROR;

834: p_msg_name => 'OKL_NO_CURR_PRECISION',
835: p_token1 => 'CURRENCY_CODE',
836: p_token1_value => p_currency_code);
837: x_return_status := OKL_API.G_RET_STS_ERROR;
838: RAISE OKL_API.G_EXCEPTION_ERROR;
839: END IF;
840:
841:
842: IF (l_rounding_rule = 'UP') THEN

Line 864: WHEN OKL_API.G_EXCEPTION_ERROR THEN

860: x_rounded_amount := l_rounded_amount;
861:
862: EXCEPTION
863:
864: WHEN OKL_API.G_EXCEPTION_ERROR THEN
865: x_return_status := OKL_API.G_RET_STS_ERROR ;
866:
867: WHEN OTHERS THEN
868: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

Line 865: x_return_status := OKL_API.G_RET_STS_ERROR ;

861:
862: EXCEPTION
863:
864: WHEN OKL_API.G_EXCEPTION_ERROR THEN
865: x_return_status := OKL_API.G_RET_STS_ERROR ;
866:
867: WHEN OTHERS THEN
868: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
869: p_msg_name => 'OKL_ERROR_ROUNDING_AMT');

Line 868: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

864: WHEN OKL_API.G_EXCEPTION_ERROR THEN
865: x_return_status := OKL_API.G_RET_STS_ERROR ;
866:
867: WHEN OTHERS THEN
868: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
869: p_msg_name => 'OKL_ERROR_ROUNDING_AMT');
870: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
871:
872: END round_amount;

Line 870: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

866:
867: WHEN OTHERS THEN
868: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
869: p_msg_name => 'OKL_ERROR_ROUNDING_AMT');
870: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
871:
872: END round_amount;
873:
874:

Line 923: x_return_status := OKL_API.G_RET_STS_SUCCESS;

919: IS
920: l_rate NUMBER;
921: BEGIN
922:
923: x_return_status := OKL_API.G_RET_STS_SUCCESS;
924:
925: l_rate := Gl_Currency_Api.get_rate_sql
926: (x_from_currency => p_from_curr_code,
927: x_to_currency => p_to_curr_code,

Line 932: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

928: x_conversion_date => p_con_date,
929: x_conversion_type => p_con_type);
930:
931: IF l_rate = -1 THEN
932: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
933: p_msg_name => 'OKL_NO_RATE_FOR_CONV',
934: p_token1 => 'FROM_CURR',
935: p_token1_value => p_from_curr_code,
936: p_token2 => 'TO_CURR',

Line 938: x_return_status := OKL_API.G_RET_STS_ERROR;

934: p_token1 => 'FROM_CURR',
935: p_token1_value => p_from_curr_code,
936: p_token2 => 'TO_CURR',
937: p_token2_value => p_to_curr_code);
938: x_return_status := OKL_API.G_RET_STS_ERROR;
939: RAISE OKL_API.G_EXCEPTION_ERROR;
940: END IF;
941:
942: IF l_rate = -2 THEN

Line 939: RAISE OKL_API.G_EXCEPTION_ERROR;

935: p_token1_value => p_from_curr_code,
936: p_token2 => 'TO_CURR',
937: p_token2_value => p_to_curr_code);
938: x_return_status := OKL_API.G_RET_STS_ERROR;
939: RAISE OKL_API.G_EXCEPTION_ERROR;
940: END IF;
941:
942: IF l_rate = -2 THEN
943: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

Line 943: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

939: RAISE OKL_API.G_EXCEPTION_ERROR;
940: END IF;
941:
942: IF l_rate = -2 THEN
943: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
944: p_msg_name => 'OKL_NO_CURR_FOR_CONV');
945: x_return_status := OKL_API.G_RET_STS_ERROR;
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;

Line 945: x_return_status := OKL_API.G_RET_STS_ERROR;

941:
942: IF l_rate = -2 THEN
943: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
944: p_msg_name => 'OKL_NO_CURR_FOR_CONV');
945: x_return_status := OKL_API.G_RET_STS_ERROR;
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;
948:
949: x_conv_rate := l_rate;

Line 946: RAISE OKL_API.G_EXCEPTION_ERROR;

942: IF l_rate = -2 THEN
943: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
944: p_msg_name => 'OKL_NO_CURR_FOR_CONV');
945: x_return_status := OKL_API.G_RET_STS_ERROR;
946: RAISE OKL_API.G_EXCEPTION_ERROR;
947: END IF;
948:
949: x_conv_rate := l_rate;
950:

Line 953: WHEN OKL_API.G_EXCEPTION_ERROR THEN

949: x_conv_rate := l_rate;
950:
951: EXCEPTION
952:
953: WHEN OKL_API.G_EXCEPTION_ERROR THEN
954: x_return_status := OKL_API.G_RET_STS_ERROR ;
955:
956: WHEN OTHERS THEN
957: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 954: x_return_status := OKL_API.G_RET_STS_ERROR ;

950:
951: EXCEPTION
952:
953: WHEN OKL_API.G_EXCEPTION_ERROR THEN
954: x_return_status := OKL_API.G_RET_STS_ERROR ;
955:
956: WHEN OTHERS THEN
957: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
958:

Line 957: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

953: WHEN OKL_API.G_EXCEPTION_ERROR THEN
954: x_return_status := OKL_API.G_RET_STS_ERROR ;
955:
956: WHEN OTHERS THEN
957: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
958:
959: END get_curr_con_rate;
960:
961: /**************************************************************************/

Line 1156: RETURN okl_api.g_true;

1152: FETCH curr_csr INTO l_return;
1153: CLOSE curr_csr;
1154:
1155: IF l_return IS NOT NULL THEN
1156: RETURN okl_api.g_true;
1157: ELSE
1158: RETURN okl_api.g_false;
1159: END IF;
1160:

Line 1158: RETURN okl_api.g_false;

1154:
1155: IF l_return IS NOT NULL THEN
1156: RETURN okl_api.g_true;
1157: ELSE
1158: RETURN okl_api.g_false;
1159: END IF;
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN

Line 1163: RETURN okl_api.g_false;

1159: END IF;
1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: RETURN okl_api.g_false;
1164: END validate_currency_con_type;
1165:
1166: /**************************************************************************/
1167: --Added p_ledger_id argument as part of bug 5707866 by nikshah

Line 1216: RETURN okl_api.g_true;

1212: FETCH cat_csr INTO l_found;
1213: CLOSE cat_csr;
1214:
1215: IF l_found IS NOT NULL THEN
1216: RETURN okl_api.g_true;
1217: ELSE
1218: RETURN okl_api.g_false;
1219: END IF;
1220:

Line 1218: RETURN okl_api.g_false;

1214:
1215: IF l_found IS NOT NULL THEN
1216: RETURN okl_api.g_true;
1217: ELSE
1218: RETURN okl_api.g_false;
1219: END IF;
1220:
1221: EXCEPTION
1222: WHEN OTHERS THEN

Line 1223: RETURN okl_api.g_false;

1219: END IF;
1220:
1221: EXCEPTION
1222: WHEN OTHERS THEN
1223: RETURN okl_api.g_false;
1224: END validate_journal_category;
1225:
1226: /*************************************************************************/
1227: --Added p_ledger_id argument as part of bug 5707866 by nikshah

Line 1297: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;

1293: G_VERSION_OVERLAPS CONSTANT VARCHAR2(200) := 'OKL_VERSION_OVERLAPS';
1294: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
1295: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
1296: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
1297: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
1298: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
1299: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
1300:
1301: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

Line 1298: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;

1294: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
1295: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
1296: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
1297: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
1298: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
1299: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
1300:
1301: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
1302:

Line 1299: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;

1295: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
1296: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
1297: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
1298: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
1299: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
1300:
1301: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
1302:
1303: FUNCTION format_date(p_date DATE) RETURN VARCHAR2

Line 1301: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

1297: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
1298: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
1299: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
1300:
1301: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
1302:
1303: FUNCTION format_date(p_date DATE) RETURN VARCHAR2
1304: IS
1305: l_str VARCHAR2(200);

Line 1318: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1314:
1315:
1316: BEGIN
1317: x_valid := TRUE;
1318: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1319:
1320: l_start_date := p_start_date;
1321: l_end_date := p_end_date;
1322: IF l_end_date IS NULL

Line 1376: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1372: l_row_found := okl_all_overlaps_csr%FOUND;
1373: CLOSE okl_all_overlaps_csr;
1374:
1375: IF l_row_found = TRUE THEN
1376: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1377: p_msg_name => G_VERSION_OVERLAPS,
1378: p_token1 => G_TABLE_TOKEN,
1379: p_token1_value => p_view,
1380: p_token2 => G_COL_NAME_TOKEN,

Line 1383: x_return_status := OKL_API.G_RET_STS_ERROR;

1379: p_token1_value => p_view,
1380: p_token2 => G_COL_NAME_TOKEN,
1381: p_token2_value => l_col_names);
1382: x_valid := FALSE;
1383: x_return_status := OKL_API.G_RET_STS_ERROR;
1384: END IF;
1385:
1386:
1387: EXCEPTION

Line 1390: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1386:
1387: EXCEPTION
1388: WHEN OTHERS THEN
1389: -- store SQL error message on message stack
1390: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1391: p_msg_name => G_UNEXPECTED_ERROR,
1392: p_token1 => G_SQLCODE_TOKEN,
1393: p_token1_value => SQLCODE,
1394: p_token2 => G_SQLERRM_TOKEN,

Line 1397: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1393: p_token1_value => SQLCODE,
1394: p_token2 => G_SQLERRM_TOKEN,
1395: p_token2_value => SQLERRM);
1396: x_valid := FALSE;
1397: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1398:
1399: IF (okl_all_overlaps_csr%ISOPEN) THEN
1400: CLOSE okl_all_overlaps_csr;
1401: END IF;

Line 1437: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;

1433: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
1434: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
1435: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
1436: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
1437: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
1438: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
1439: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
1440:
1441: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

Line 1438: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;

1434: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
1435: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
1436: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
1437: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
1438: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
1439: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
1440:
1441: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
1442:

Line 1439: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;

1435: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
1436: G_TABLE_TOKEN CONSTANT VARCHAR2(100) := 'OKL_TABLE_NAME';
1437: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
1438: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
1439: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
1440:
1441: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
1442:
1443: G_INIT_VERSION CONSTANT NUMBER := 1.0;

Line 1441: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

1437: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_PARENT_TABLE_TOKEN;
1438: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_CHILD_TABLE_TOKEN;
1439: G_COL_NAME_TOKEN CONSTANT VARCHAR2(100) := OKL_API.G_COL_NAME_TOKEN;
1440:
1441: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
1442:
1443: G_INIT_VERSION CONSTANT NUMBER := 1.0;
1444: G_VERSION_MAJOR_INCREMENT CONSTANT NUMBER := 1.0;
1445: G_VERSION_MINOR_INCREMENT CONSTANT NUMBER := 0.1;

Line 1450: IF p_cur_version = OKL_API.G_MISS_CHAR THEN

1446: G_VERSION_FORMAT CONSTANT VARCHAR2(100) := 'FM999.0999';
1447:
1448:
1449: BEGIN
1450: IF p_cur_version = OKL_API.G_MISS_CHAR THEN
1451: x_new_version := G_INIT_VERSION;
1452: ELSE
1453: i := p_attrib_tbl.FIRST;
1454: LOOP

Line 1479: '''' || OKL_API.G_MISS_DATE || '''' || ') > ' ||

1475: l_sql_stmt := 'SELECT ''1'' ' ||
1476: 'FROM ' || p_view ||
1477: l_where_clause ||
1478: ' AND NVL(' || p_end_date_attribute_name || ', ' ||
1479: '''' || OKL_API.G_MISS_DATE || '''' || ') > ' ||
1480: '''' || p_end_date || '''';
1481:
1482: OPEN okl_all_laterversionsexist_csr
1483: FOR l_sql_stmt;

Line 1497: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1493: + G_VERSION_MINOR_INCREMENT, G_VERSION_FORMAT);
1494: END IF;
1495: END IF;
1496:
1497: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: -- store SQL error message on message stack
1501: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 1501: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1497: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: -- store SQL error message on message stack
1501: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1502: p_msg_name => G_UNEXPECTED_ERROR,
1503: p_token1 => G_SQLCODE_TOKEN,
1504: p_token1_value => SQLCODE,
1505: p_token2 => G_SQLERRM_TOKEN,

Line 1507: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1503: p_token1 => G_SQLCODE_TOKEN,
1504: p_token1_value => SQLCODE,
1505: p_token2 => G_SQLERRM_TOKEN,
1506: p_token2_value => SQLERRM);
1507: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1508:
1509: IF (okl_all_laterversionsexist_csr%ISOPEN) THEN
1510: CLOSE okl_all_laterversionsexist_csr;
1511: END IF;

Line 1805: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1801: l_row_found := csr_get_rule_meaning%FOUND;
1802: CLOSE csr_get_rule_meaning;
1803:
1804: IF l_row_found = FALSE THEN
1805: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1806: p_msg_name => G_RULE_DEF_NOT_FOUND);
1807: x_return_status := OKL_API.G_RET_STS_ERROR;
1808: END IF;
1809:

Line 1807: x_return_status := OKL_API.G_RET_STS_ERROR;

1803:
1804: IF l_row_found = FALSE THEN
1805: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1806: p_msg_name => G_RULE_DEF_NOT_FOUND);
1807: x_return_status := OKL_API.G_RET_STS_ERROR;
1808: END IF;
1809:
1810: RETURN l_meaning;
1811:

Line 1815: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,

1811:
1812: EXCEPTION
1813: WHEN OTHERS THEN
1814: -- store SQL error message on message stack
1815: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
1816: p_msg_name => G_UNEXPECTED_ERROR,
1817: p_token1 => G_SQLCODE_TOKEN,
1818: p_token1_value => SQLCODE,
1819: p_token2 => G_SQLERRM_TOKEN,

Line 1821: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1817: p_token1 => G_SQLCODE_TOKEN,
1818: p_token1_value => SQLCODE,
1819: p_token2 => G_SQLERRM_TOKEN,
1820: p_token2_value => SQLERRM);
1821: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1822:
1823: IF (csr_get_rule_meaning%ISOPEN) THEN
1824: CLOSE csr_get_rule_meaning;
1825: END IF;

Line 1972: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

1968: l_pos_dot NUMBER;
1969: l_to_add NUMBER := 1;
1970: l_sysdate DATE := G_SYSDATE;
1971:
1972: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
1973: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1974: l_msg_count NUMBER := 0;
1975: l_msg_data VARCHAR2(2000);
1976: l_api_version NUMBER := 1.0;

Line 1973: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1969: l_to_add NUMBER := 1;
1970: l_sysdate DATE := G_SYSDATE;
1971:
1972: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
1973: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1974: l_msg_count NUMBER := 0;
1975: l_msg_data VARCHAR2(2000);
1976: l_api_version NUMBER := 1.0;
1977:

Line 1992: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1988: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);
1989:
1990: BEGIN
1991:
1992: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1993:
1994: FOR rnd_rul_rec IN rnd_rul_csr LOOP
1995: l_rounding_rule := rnd_rul_rec.cc_rounding_rule;
1996: END LOOP;

Line 1999: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

1995: l_rounding_rule := rnd_rul_rec.cc_rounding_rule;
1996: END LOOP;
1997:
1998: IF l_rounding_rule IS NULL THEN
1999: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2000: p_msg_name => 'OKL_NO_ROUNDING_RULE');
2001: x_return_status := OKL_API.G_RET_STS_ERROR;
2002: RAISE OKL_API.G_EXCEPTION_ERROR;
2003: END IF;

Line 2001: x_return_status := OKL_API.G_RET_STS_ERROR;

1997:
1998: IF l_rounding_rule IS NULL THEN
1999: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2000: p_msg_name => 'OKL_NO_ROUNDING_RULE');
2001: x_return_status := OKL_API.G_RET_STS_ERROR;
2002: RAISE OKL_API.G_EXCEPTION_ERROR;
2003: END IF;
2004:
2005:

Line 2002: RAISE OKL_API.G_EXCEPTION_ERROR;

1998: IF l_rounding_rule IS NULL THEN
1999: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2000: p_msg_name => 'OKL_NO_ROUNDING_RULE');
2001: x_return_status := OKL_API.G_RET_STS_ERROR;
2002: RAISE OKL_API.G_EXCEPTION_ERROR;
2003: END IF;
2004:
2005:
2006: FOR prec_rec IN prec_csr LOOP

Line 2012: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

2008: END LOOP;
2009:
2010:
2011: IF l_precision IS NULL THEN
2012: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2013: p_msg_name => 'OKL_NO_CURR_PRECISION',
2014: p_token1 => 'CURRENCY_CODE',
2015: p_token1_value => p_currency_code);
2016: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 2016: x_return_status := OKL_API.G_RET_STS_ERROR;

2012: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2013: p_msg_name => 'OKL_NO_CURR_PRECISION',
2014: p_token1 => 'CURRENCY_CODE',
2015: p_token1_value => p_currency_code);
2016: x_return_status := OKL_API.G_RET_STS_ERROR;
2017: RAISE OKL_API.G_EXCEPTION_ERROR;
2018: END IF;
2019:
2020:

Line 2017: RAISE OKL_API.G_EXCEPTION_ERROR;

2013: p_msg_name => 'OKL_NO_CURR_PRECISION',
2014: p_token1 => 'CURRENCY_CODE',
2015: p_token1_value => p_currency_code);
2016: x_return_status := OKL_API.G_RET_STS_ERROR;
2017: RAISE OKL_API.G_EXCEPTION_ERROR;
2018: END IF;
2019:
2020:
2021: IF (l_rounding_rule = 'UP') THEN

Line 2043: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2039: x_rounded_amount := l_rounded_amount;
2040:
2041: EXCEPTION
2042:
2043: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2044: x_return_status := OKL_API.G_RET_STS_ERROR ;
2045:
2046: WHEN OTHERS THEN
2047: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

Line 2044: x_return_status := OKL_API.G_RET_STS_ERROR ;

2040:
2041: EXCEPTION
2042:
2043: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2044: x_return_status := OKL_API.G_RET_STS_ERROR ;
2045:
2046: WHEN OTHERS THEN
2047: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2048: p_msg_name => 'OKL_ERROR_ROUNDING_AMT');

Line 2047: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

2043: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2044: x_return_status := OKL_API.G_RET_STS_ERROR ;
2045:
2046: WHEN OTHERS THEN
2047: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2048: p_msg_name => 'OKL_ERROR_ROUNDING_AMT');
2049: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2050:
2051: END cross_currency_round_amount;

Line 2049: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2045:
2046: WHEN OTHERS THEN
2047: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2048: p_msg_name => 'OKL_ERROR_ROUNDING_AMT');
2049: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2050:
2051: END cross_currency_round_amount;
2052:
2053: /******************************************************************************/

Line 2221: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2217: l_currency_conversion_type VARCHAR2(30);
2218: l_currency_conversion_rate NUMBER;
2219: l_currency_conversion_date DATE;
2220: l_converted_amount NUMBER;
2221: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2222: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
2223: l_msg_count NUMBER := 0;
2224: l_msg_data VARCHAR2(2000);
2225: l_api_version NUMBER := 1.0;

Line 2222: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

2218: l_currency_conversion_rate NUMBER;
2219: l_currency_conversion_date DATE;
2220: l_converted_amount NUMBER;
2221: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2222: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
2223: l_msg_count NUMBER := 0;
2224: l_msg_data VARCHAR2(2000);
2225: l_api_version NUMBER := 1.0;
2226:

Line 2230: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2226:
2227:
2228: BEGIN
2229:
2230: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2231:
2232: -- Fetch the currency conversion factors from the contract cursor
2233: FOR cntrct_rec IN cntrct_cur LOOP
2234: l_contract_currency := cntrct_rec.currency_code;

Line 2241: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

2237: l_currency_conversion_date := cntrct_rec.currency_conversion_date;
2238: END LOOP;
2239:
2240: IF l_contract_currency IS NULL THEN
2241: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2242: p_msg_name => 'OKL_NO_CONTRACT_FOR_CONV');
2243: x_return_status := OKL_API.G_RET_STS_ERROR;
2244: RAISE OKL_API.G_EXCEPTION_ERROR;
2245: END IF;

Line 2243: x_return_status := OKL_API.G_RET_STS_ERROR;

2239:
2240: IF l_contract_currency IS NULL THEN
2241: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2242: p_msg_name => 'OKL_NO_CONTRACT_FOR_CONV');
2243: x_return_status := OKL_API.G_RET_STS_ERROR;
2244: RAISE OKL_API.G_EXCEPTION_ERROR;
2245: END IF;
2246:
2247:

Line 2244: RAISE OKL_API.G_EXCEPTION_ERROR;

2240: IF l_contract_currency IS NULL THEN
2241: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2242: p_msg_name => 'OKL_NO_CONTRACT_FOR_CONV');
2243: x_return_status := OKL_API.G_RET_STS_ERROR;
2244: RAISE OKL_API.G_EXCEPTION_ERROR;
2245: END IF;
2246:
2247:
2248: -- Get the functional currency code using Accounting Util API if the passed

Line 2284: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2280:
2281:
2282:
2283:
2284: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2285: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2286: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2287: RAISE OKL_API.G_EXCEPTION_ERROR;
2288: END IF;

Line 2285: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2281:
2282:
2283:
2284: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2285: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2286: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2287: RAISE OKL_API.G_EXCEPTION_ERROR;
2288: END IF;
2289:

Line 2286: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2282:
2283:
2284: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2285: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2286: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2287: RAISE OKL_API.G_EXCEPTION_ERROR;
2288: END IF;
2289:
2290: END IF; -- The type is not USER

Line 2287: RAISE OKL_API.G_EXCEPTION_ERROR;

2283:
2284: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2285: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2286: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2287: RAISE OKL_API.G_EXCEPTION_ERROR;
2288: END IF;
2289:
2290: END IF; -- The type is not USER
2291:

Line 2309: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2305: x_currency_conversion_date := l_currency_conversion_date;
2306:
2307: EXCEPTION
2308:
2309: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2310: x_return_status := OKL_API.G_RET_STS_ERROR ;
2311: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2312: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2313: WHEN OTHERS THEN

Line 2310: x_return_status := OKL_API.G_RET_STS_ERROR ;

2306:
2307: EXCEPTION
2308:
2309: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2310: x_return_status := OKL_API.G_RET_STS_ERROR ;
2311: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2312: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2313: WHEN OTHERS THEN
2314: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2311: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2307: EXCEPTION
2308:
2309: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2310: x_return_status := OKL_API.G_RET_STS_ERROR ;
2311: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2312: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2313: WHEN OTHERS THEN
2314: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2315:

Line 2312: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2308:
2309: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2310: x_return_status := OKL_API.G_RET_STS_ERROR ;
2311: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2312: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2313: WHEN OTHERS THEN
2314: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2315:
2316: END convert_to_functional_currency;

Line 2314: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2310: x_return_status := OKL_API.G_RET_STS_ERROR ;
2311: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2312: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2313: WHEN OTHERS THEN
2314: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2315:
2316: END convert_to_functional_currency;
2317:
2318:

Line 2495: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

2491: l_currency_conversion_type VARCHAR2(30);
2492: l_currency_conversion_rate NUMBER;
2493: l_currency_conversion_date DATE;
2494: l_converted_amount NUMBER;
2495: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
2496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2497: l_msg_count NUMBER := 0;
2498: l_msg_data VARCHAR2(2000);
2499: l_api_version NUMBER := 1.0;

Line 2496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2492: l_currency_conversion_rate NUMBER;
2493: l_currency_conversion_date DATE;
2494: l_converted_amount NUMBER;
2495: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
2496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2497: l_msg_count NUMBER := 0;
2498: l_msg_data VARCHAR2(2000);
2499: l_api_version NUMBER := 1.0;
2500:

Line 2503: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2499: l_api_version NUMBER := 1.0;
2500:
2501:
2502: BEGIN
2503: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2504:
2505: -- Fetch the currency conversion factors from the contract cursor
2506: FOR cntrct_rec IN cntrct_cur LOOP
2507: l_contract_currency := cntrct_rec.currency_code;

Line 2515: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

2511: END LOOP;
2512:
2513:
2514: IF l_contract_currency IS NULL THEN
2515: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2516: p_msg_name => 'OKL_NO_CONTRACT_FOR_CONV');
2517: x_return_status := OKL_API.G_RET_STS_ERROR;
2518: RAISE OKL_API.G_EXCEPTION_ERROR;
2519: END IF;

Line 2517: x_return_status := OKL_API.G_RET_STS_ERROR;

2513:
2514: IF l_contract_currency IS NULL THEN
2515: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2516: p_msg_name => 'OKL_NO_CONTRACT_FOR_CONV');
2517: x_return_status := OKL_API.G_RET_STS_ERROR;
2518: RAISE OKL_API.G_EXCEPTION_ERROR;
2519: END IF;
2520:
2521:

Line 2518: RAISE OKL_API.G_EXCEPTION_ERROR;

2514: IF l_contract_currency IS NULL THEN
2515: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2516: p_msg_name => 'OKL_NO_CONTRACT_FOR_CONV');
2517: x_return_status := OKL_API.G_RET_STS_ERROR;
2518: RAISE OKL_API.G_EXCEPTION_ERROR;
2519: END IF;
2520:
2521:
2522: -- Get the functional currency code using Accounting Util API if the passed

Line 2558: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2554: p_con_date => l_currency_conversion_date,
2555: p_con_type => l_currency_conversion_type,
2556: x_conv_rate => l_currency_conversion_rate );
2557:
2558: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2560: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2561: RAISE OKL_API.G_EXCEPTION_ERROR;
2562: END IF;

Line 2559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2555: p_con_type => l_currency_conversion_type,
2556: x_conv_rate => l_currency_conversion_rate );
2557:
2558: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2560: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2561: RAISE OKL_API.G_EXCEPTION_ERROR;
2562: END IF;
2563:

Line 2560: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2556: x_conv_rate => l_currency_conversion_rate );
2557:
2558: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2560: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2561: RAISE OKL_API.G_EXCEPTION_ERROR;
2562: END IF;
2563:
2564: END IF; -- The type is USER

Line 2561: RAISE OKL_API.G_EXCEPTION_ERROR;

2557:
2558: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2559: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2560: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2561: RAISE OKL_API.G_EXCEPTION_ERROR;
2562: END IF;
2563:
2564: END IF; -- The type is USER
2565: END IF; -- Functional and contract currencies are not same.

Line 2583: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2579: x_currency_conversion_date := l_currency_conversion_date;
2580:
2581: EXCEPTION
2582:
2583: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2584: x_return_status := OKL_API.G_RET_STS_ERROR ;
2585: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2586: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2587: WHEN OTHERS THEN

Line 2584: x_return_status := OKL_API.G_RET_STS_ERROR ;

2580:
2581: EXCEPTION
2582:
2583: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2584: x_return_status := OKL_API.G_RET_STS_ERROR ;
2585: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2586: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2587: WHEN OTHERS THEN
2588: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2585: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2581: EXCEPTION
2582:
2583: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2584: x_return_status := OKL_API.G_RET_STS_ERROR ;
2585: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2586: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2587: WHEN OTHERS THEN
2588: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2589:

Line 2586: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2582:
2583: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2584: x_return_status := OKL_API.G_RET_STS_ERROR ;
2585: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2586: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2587: WHEN OTHERS THEN
2588: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2589:
2590: END convert_to_contract_currency;

Line 2588: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2584: x_return_status := OKL_API.G_RET_STS_ERROR ;
2585: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2586: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2587: WHEN OTHERS THEN
2588: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2589:
2590: END convert_to_contract_currency;
2591:
2592:

Line 2656: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2652: IS
2653:
2654: l_rounded_amount NUMBER;
2655: l_formatted_amount VARCHAR2(1000);
2656: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2657:
2658: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
2659: l_msg_count NUMBER := 0;
2660: l_msg_data VARCHAR2(2000);

Line 2658: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

2654: l_rounded_amount NUMBER;
2655: l_formatted_amount VARCHAR2(1000);
2656: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2657:
2658: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
2659: l_msg_count NUMBER := 0;
2660: l_msg_data VARCHAR2(2000);
2661: l_api_version NUMBER := 1.0;
2662:

Line 2665: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2661: l_api_version NUMBER := 1.0;
2662:
2663: BEGIN
2664:
2665: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2666: -- Round the amount.
2667:
2668: cross_currency_round_amount
2669: (p_api_version => l_api_version,

Line 2679: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2675: p_currency_code => p_currency_code,
2676: x_rounded_amount => l_rounded_amount);
2677:
2678:
2679: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2680: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2681: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2682: RAISE OKL_API.G_EXCEPTION_ERROR;
2683: END IF;

Line 2680: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2676: x_rounded_amount => l_rounded_amount);
2677:
2678:
2679: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2680: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2681: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2682: RAISE OKL_API.G_EXCEPTION_ERROR;
2683: END IF;
2684:

Line 2681: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

2677:
2678:
2679: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2680: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2681: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2682: RAISE OKL_API.G_EXCEPTION_ERROR;
2683: END IF;
2684:
2685: -- Format the amount

Line 2682: RAISE OKL_API.G_EXCEPTION_ERROR;

2678:
2679: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2680: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2681: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2682: RAISE OKL_API.G_EXCEPTION_ERROR;
2683: END IF;
2684:
2685: -- Format the amount
2686: l_formatted_amount := format_amount(

Line 2691: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

2687: p_amount => l_rounded_amount,
2688: p_currency_code => p_currency_code) ;
2689:
2690: IF l_formatted_amount IS NULL THEN
2691: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2692: p_msg_name => 'OKL_ERROR_FORMAT_AMT');
2693: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2694: RAISE OKL_API.G_EXCEPTION_ERROR;
2695: END IF;

Line 2693: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2689:
2690: IF l_formatted_amount IS NULL THEN
2691: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2692: p_msg_name => 'OKL_ERROR_FORMAT_AMT');
2693: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2694: RAISE OKL_API.G_EXCEPTION_ERROR;
2695: END IF;
2696:
2697: x_formatted_amount := l_formatted_amount;

Line 2694: RAISE OKL_API.G_EXCEPTION_ERROR;

2690: IF l_formatted_amount IS NULL THEN
2691: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2692: p_msg_name => 'OKL_ERROR_FORMAT_AMT');
2693: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2694: RAISE OKL_API.G_EXCEPTION_ERROR;
2695: END IF;
2696:
2697: x_formatted_amount := l_formatted_amount;
2698:

Line 2701: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2697: x_formatted_amount := l_formatted_amount;
2698:
2699: EXCEPTION
2700:
2701: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2702: x_return_status := OKL_API.G_RET_STS_ERROR ;
2703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2704: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2705: WHEN OTHERS THEN

Line 2702: x_return_status := OKL_API.G_RET_STS_ERROR ;

2698:
2699: EXCEPTION
2700:
2701: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2702: x_return_status := OKL_API.G_RET_STS_ERROR ;
2703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2704: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2705: WHEN OTHERS THEN
2706: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2699: EXCEPTION
2700:
2701: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2702: x_return_status := OKL_API.G_RET_STS_ERROR ;
2703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2704: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2705: WHEN OTHERS THEN
2706: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2707:

Line 2704: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2700:
2701: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2702: x_return_status := OKL_API.G_RET_STS_ERROR ;
2703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2704: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2705: WHEN OTHERS THEN
2706: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2707:
2708: END cc_round_format_amount;

Line 2706: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2702: x_return_status := OKL_API.G_RET_STS_ERROR ;
2703: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2704: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2705: WHEN OTHERS THEN
2706: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2707:
2708: END cc_round_format_amount;
2709:
2710: /************************************************************************************/

Line 3013: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

3009:
3010: l_fa_trx_date DATE;
3011:
3012: BEGIN
3013: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
3014:
3015: l_fa_trx_date := Okl_Accounting_Util.get_fa_trx_date(p_book_type_code);
3016:
3017: IF l_fa_trx_date IS NULL THEN

Line 3018: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

3014:
3015: l_fa_trx_date := Okl_Accounting_Util.get_fa_trx_date(p_book_type_code);
3016:
3017: IF l_fa_trx_date IS NULL THEN
3018: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
3019: p_msg_name => 'OKL_NO_FA_TRX_DATE');
3020: RAISE Okl_Api.G_EXCEPTION_ERROR;
3021: END IF;
3022:

Line 3020: RAISE Okl_Api.G_EXCEPTION_ERROR;

3016:
3017: IF l_fa_trx_date IS NULL THEN
3018: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
3019: p_msg_name => 'OKL_NO_FA_TRX_DATE');
3020: RAISE Okl_Api.G_EXCEPTION_ERROR;
3021: END IF;
3022:
3023: x_fa_trx_date := l_fa_trx_date;
3024:

Line 3026: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

3022:
3023: x_fa_trx_date := l_fa_trx_date;
3024:
3025: EXCEPTION
3026: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3027: x_return_status := Okl_Api.G_RET_STS_ERROR ;
3028: WHEN OTHERS THEN
3029: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
3030:

Line 3027: x_return_status := Okl_Api.G_RET_STS_ERROR ;

3023: x_fa_trx_date := l_fa_trx_date;
3024:
3025: EXCEPTION
3026: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3027: x_return_status := Okl_Api.G_RET_STS_ERROR ;
3028: WHEN OTHERS THEN
3029: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
3030:
3031: END get_fa_trx_date;

Line 3029: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

3025: EXCEPTION
3026: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
3027: x_return_status := Okl_Api.G_RET_STS_ERROR ;
3028: WHEN OTHERS THEN
3029: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
3030:
3031: END get_fa_trx_date;
3032:
3033:

Line 3195: p_org_id = OKL_API.G_MISS_NUM) THEN

3191: FROM OKL_SYSTEM_PARAMS_ALL
3192: WHERE ORG_ID = l_org_id;
3193: BEGIN
3194: IF (p_org_id is NULL OR
3195: p_org_id = OKL_API.G_MISS_NUM) THEN
3196: l_org_id := mo_global.get_current_org_id;
3197: ELSE
3198: l_org_id := p_org_id;
3199: END IF;

Line 3322: x_return_status := OKL_API.G_RET_STS_ERROR;

3318: p_msg_name => 'OKL_AM_NO_MG_DEAL_TYPE',
3319: p_token1 => 'REP_PROD',
3320: p_token1_value => l_reporting_product);
3321:
3322: x_return_status := OKL_API.G_RET_STS_ERROR;
3323: ELSE
3324: x_rep_deal_type := l_rep_deal_type ;
3325: END IF;
3326: END IF;

Line 3334: OKL_API.set_message(p_app_name => 'OKC',

3330: WHEN OTHERS THEN
3331: IF l_get_fin_product%ISOPEN THEN
3332: CLOSE l_get_fin_product;
3333: END IF;
3334: OKL_API.set_message(p_app_name => 'OKC',
3335: p_msg_name => g_unexpected_error,
3336: p_token1 => g_sqlcode_token,
3337: p_token1_value => sqlcode,
3338: p_token2 => g_sqlerrm_token,

Line 3340: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

3336: p_token1 => g_sqlcode_token,
3337: p_token1_value => sqlcode,
3338: p_token2 => g_sqlerrm_token,
3339: p_token2_value => sqlerrm);
3340: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3341: END get_reporting_product;
3342:
3343: END okl_accounting_util;