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 212: RETURN Okl_Api.g_true;

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

Line 214: RETURN Okl_Api.g_false;

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

Line 219: RETURN Okl_Api.g_false;

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

Line 338: RETURN Okl_Api.G_TRUE;

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

Line 340: RETURN Okl_Api.G_FALSE;

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

Line 345: RETURN Okl_Api.G_FALSE;

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

Line 385: RETURN Okl_Api.G_TRUE;

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

Line 387: RETURN Okl_Api.G_FALSE;

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

Line 392: RETURN Okl_Api.G_FALSE;

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

Line 591: RETURN okl_api.g_false;

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

Line 593: RETURN okl_api.g_true;

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

Line 596: RETURN okl_api.g_false;

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

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

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

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

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

Line 794: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

Line 813: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 814: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 822: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 823: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 836: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 837: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 863: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 864: x_return_status := OKL_API.G_RET_STS_ERROR ;

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

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

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

Line 869: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 922: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

Line 937: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 938: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 944: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 945: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 952: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 953: x_return_status := OKL_API.G_RET_STS_ERROR ;

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

Line 956: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 1155: RETURN okl_api.g_true;

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

Line 1157: RETURN okl_api.g_false;

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

Line 1162: RETURN okl_api.g_false;

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

Line 1215: RETURN okl_api.g_true;

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

Line 1217: RETURN okl_api.g_false;

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

Line 1222: RETURN okl_api.g_false;

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

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

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

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

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

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

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

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

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

Line 1317: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

Line 1382: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 1396: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

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

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

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

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

Line 1449: IF p_cur_version = OKL_API.G_MISS_CHAR THEN

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

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

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

Line 1496: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

Line 1506: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 1805: x_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

Line 1819: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

Line 1990: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

Line 1999: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 2000: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2014: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 2015: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2041: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2042: x_return_status := OKL_API.G_RET_STS_ERROR ;

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

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

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

Line 2047: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

Line 2228: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

Line 2241: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 2242: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 2285: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2307: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2308: x_return_status := OKL_API.G_RET_STS_ERROR ;

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

Line 2309: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2310: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 2312: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

Line 2501: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

Line 2515: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 2516: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2557: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 2559: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2581: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2582: x_return_status := OKL_API.G_RET_STS_ERROR ;

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

Line 2583: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2584: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 2586: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

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

Line 2663: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

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

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

Line 2678: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 2680: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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

Line 2691: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 2692: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 2699: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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

Line 2700: x_return_status := OKL_API.G_RET_STS_ERROR ;

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

Line 2701: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 2702: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 2704: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 3011: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

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

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

Line 3018: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

Line 3024: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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

Line 3025: x_return_status := Okl_Api.G_RET_STS_ERROR ;

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

Line 3027: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

Line 3193: p_org_id = OKL_API.G_MISS_NUM) THEN

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