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

Line 817: IF (l_tcnv_rec.LEGAL_ENTITY_ID = Okl_Api.G_MISS_NUM) THEN

813: l_tcnv_rec.CANCELED_DATE := NULL;
814: END IF;
815:
816: --Added by dpsingh for LE Uptake
817: IF (l_tcnv_rec.LEGAL_ENTITY_ID = Okl_Api.G_MISS_NUM) THEN
818: l_tcnv_rec.LEGAL_ENTITY_ID := NULL;
819: END IF;
820:
821: --Added by dpsingh for SLA Uptake (Bug 5707866)

Line 822: IF (l_tcnv_rec.ACCRUAL_REVERSAL_DATE = Okl_Api.G_MISS_DATE) THEN

818: l_tcnv_rec.LEGAL_ENTITY_ID := NULL;
819: END IF;
820:
821: --Added by dpsingh for SLA Uptake (Bug 5707866)
822: IF (l_tcnv_rec.ACCRUAL_REVERSAL_DATE = Okl_Api.G_MISS_DATE) THEN
823: l_tcnv_rec.ACCRUAL_REVERSAL_DATE := NULL;
824: END IF;
825:
826: -- Added by DJANASWA for SLA project

Line 827: IF (l_tcnv_rec.ACCOUNTING_REVERSAL_YN = Okl_Api.G_MISS_CHAR) THEN

823: l_tcnv_rec.ACCRUAL_REVERSAL_DATE := NULL;
824: END IF;
825:
826: -- Added by DJANASWA for SLA project
827: IF (l_tcnv_rec.ACCOUNTING_REVERSAL_YN = Okl_Api.G_MISS_CHAR) THEN
828: l_tcnv_rec.ACCOUNTING_REVERSAL_YN := NULL;
829: END IF;
830: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
831: IF (l_tcnv_rec.PRODUCT_NAME = Okl_Api.G_MISS_CHAR) THEN

Line 831: IF (l_tcnv_rec.PRODUCT_NAME = Okl_Api.G_MISS_CHAR) THEN

827: IF (l_tcnv_rec.ACCOUNTING_REVERSAL_YN = Okl_Api.G_MISS_CHAR) THEN
828: l_tcnv_rec.ACCOUNTING_REVERSAL_YN := NULL;
829: END IF;
830: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
831: IF (l_tcnv_rec.PRODUCT_NAME = Okl_Api.G_MISS_CHAR) THEN
832: l_tcnv_rec.PRODUCT_NAME := NULL;
833: END IF;
834: IF (l_tcnv_rec.BOOK_CLASSIFICATION_CODE = Okl_Api.G_MISS_CHAR) THEN
835: l_tcnv_rec.BOOK_CLASSIFICATION_CODE := NULL;

Line 834: IF (l_tcnv_rec.BOOK_CLASSIFICATION_CODE = Okl_Api.G_MISS_CHAR) THEN

830: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
831: IF (l_tcnv_rec.PRODUCT_NAME = Okl_Api.G_MISS_CHAR) THEN
832: l_tcnv_rec.PRODUCT_NAME := NULL;
833: END IF;
834: IF (l_tcnv_rec.BOOK_CLASSIFICATION_CODE = Okl_Api.G_MISS_CHAR) THEN
835: l_tcnv_rec.BOOK_CLASSIFICATION_CODE := NULL;
836: END IF;
837: IF (l_tcnv_rec.TAX_OWNER_CODE = Okl_Api.G_MISS_CHAR) THEN
838: l_tcnv_rec.TAX_OWNER_CODE := NULL;

Line 837: IF (l_tcnv_rec.TAX_OWNER_CODE = Okl_Api.G_MISS_CHAR) THEN

833: END IF;
834: IF (l_tcnv_rec.BOOK_CLASSIFICATION_CODE = Okl_Api.G_MISS_CHAR) THEN
835: l_tcnv_rec.BOOK_CLASSIFICATION_CODE := NULL;
836: END IF;
837: IF (l_tcnv_rec.TAX_OWNER_CODE = Okl_Api.G_MISS_CHAR) THEN
838: l_tcnv_rec.TAX_OWNER_CODE := NULL;
839: END IF;
840: IF (l_tcnv_rec.TMT_STATUS_CODE = Okl_Api.G_MISS_CHAR) THEN
841: l_tcnv_rec.TMT_STATUS_CODE := NULL;

Line 840: IF (l_tcnv_rec.TMT_STATUS_CODE = Okl_Api.G_MISS_CHAR) THEN

836: END IF;
837: IF (l_tcnv_rec.TAX_OWNER_CODE = Okl_Api.G_MISS_CHAR) THEN
838: l_tcnv_rec.TAX_OWNER_CODE := NULL;
839: END IF;
840: IF (l_tcnv_rec.TMT_STATUS_CODE = Okl_Api.G_MISS_CHAR) THEN
841: l_tcnv_rec.TMT_STATUS_CODE := NULL;
842: END IF;
843: IF (l_tcnv_rec.REPRESENTATION_NAME = Okl_Api.G_MISS_CHAR) THEN
844: l_tcnv_rec.REPRESENTATION_NAME := NULL;

Line 843: IF (l_tcnv_rec.REPRESENTATION_NAME = Okl_Api.G_MISS_CHAR) THEN

839: END IF;
840: IF (l_tcnv_rec.TMT_STATUS_CODE = Okl_Api.G_MISS_CHAR) THEN
841: l_tcnv_rec.TMT_STATUS_CODE := NULL;
842: END IF;
843: IF (l_tcnv_rec.REPRESENTATION_NAME = Okl_Api.G_MISS_CHAR) THEN
844: l_tcnv_rec.REPRESENTATION_NAME := NULL;
845: END IF;
846: IF (l_tcnv_rec.REPRESENTATION_CODE = Okl_Api.G_MISS_CHAR) THEN
847: l_tcnv_rec.REPRESENTATION_CODE := NULL;

Line 846: IF (l_tcnv_rec.REPRESENTATION_CODE = Okl_Api.G_MISS_CHAR) THEN

842: END IF;
843: IF (l_tcnv_rec.REPRESENTATION_NAME = Okl_Api.G_MISS_CHAR) THEN
844: l_tcnv_rec.REPRESENTATION_NAME := NULL;
845: END IF;
846: IF (l_tcnv_rec.REPRESENTATION_CODE = Okl_Api.G_MISS_CHAR) THEN
847: l_tcnv_rec.REPRESENTATION_CODE := NULL;
848: END IF;
849: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
850: IF (l_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN

Line 850: IF (l_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN

846: IF (l_tcnv_rec.REPRESENTATION_CODE = Okl_Api.G_MISS_CHAR) THEN
847: l_tcnv_rec.REPRESENTATION_CODE := NULL;
848: END IF;
849: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
850: IF (l_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN
851: l_tcnv_rec.UPGRADE_STATUS_FLAG := NULL;
852: END IF;
853: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
854: IF (l_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN

Line 854: IF (l_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN

850: IF (l_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN
851: l_tcnv_rec.UPGRADE_STATUS_FLAG := NULL;
852: END IF;
853: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
854: IF (l_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN
855: l_tcnv_rec.TRANSACTION_DATE := NULL;
856: END IF;
857: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
858: IF (l_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN

Line 858: IF (l_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN

854: IF (l_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN
855: l_tcnv_rec.TRANSACTION_DATE := NULL;
856: END IF;
857: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
858: IF (l_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN
859: l_tcnv_rec.primary_rep_trx_id := NULL;
860: END IF;
861: IF (l_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN
862: l_tcnv_rec.REPRESENTATION_TYPE := NULL;

Line 861: IF (l_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN

857: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
858: IF (l_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN
859: l_tcnv_rec.primary_rep_trx_id := NULL;
860: END IF;
861: IF (l_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN
862: l_tcnv_rec.REPRESENTATION_TYPE := NULL;
863: END IF;
864: -- Added by sosharma for Income Account recon- report 01-Nov-2008
865: IF (l_tcnv_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE) THEN

Line 865: IF (l_tcnv_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE) THEN

861: IF (l_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN
862: l_tcnv_rec.REPRESENTATION_TYPE := NULL;
863: END IF;
864: -- Added by sosharma for Income Account recon- report 01-Nov-2008
865: IF (l_tcnv_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE) THEN
866: l_tcnv_rec.TRANSACTION_REVERSAL_DATE := NULL;
867: END IF;
868:
869: RETURN(l_tcnv_rec);

Line 1384: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1380: ---------------------------------------------------------------------------
1381: PROCEDURE Validate_LE_Id(p_tcnv_rec IN tcnv_rec_type
1382: ,x_return_status OUT NOCOPY VARCHAR2)
1383: IS
1384: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1385: l_dummy VARCHAR2(1);
1386: item_not_found_error EXCEPTION;
1387:
1388: BEGIN

Line 1390: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

1386: item_not_found_error EXCEPTION;
1387:
1388: BEGIN
1389:
1390: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1391:
1392: IF (p_tcnv_rec.legal_entity_id IS NOT NULL) AND
1393: (p_tcnv_rec.legal_entity_id <> Okl_Api.G_MISS_NUM) THEN
1394:

Line 1393: (p_tcnv_rec.legal_entity_id <> Okl_Api.G_MISS_NUM) THEN

1389:
1390: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1391:
1392: IF (p_tcnv_rec.legal_entity_id IS NOT NULL) AND
1393: (p_tcnv_rec.legal_entity_id <> Okl_Api.G_MISS_NUM) THEN
1394:
1395: l_dummy := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_tcnv_rec.legal_entity_id);
1396: IF l_dummy <>1 THEN
1397: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');

Line 1397: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');

1393: (p_tcnv_rec.legal_entity_id <> Okl_Api.G_MISS_NUM) THEN
1394:
1395: l_dummy := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_tcnv_rec.legal_entity_id);
1396: IF l_dummy <>1 THEN
1397: Okl_Api.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LEGAL_ENTITY_ID');
1398: RAISE item_not_found_error;
1399: END IF;
1400: END IF;
1401:

Line 1409: x_return_status := Okl_Api.G_RET_STS_ERROR;

1405: -- with the next column
1406: NULL;
1407:
1408: WHEN item_not_found_error THEN
1409: x_return_status := Okl_Api.G_RET_STS_ERROR;
1410:
1411: WHEN OTHERS THEN
1412: -- store SQL error message on message stack for caller
1413: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 1421: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

1417: ,p_token2 => g_sqlerrm_token
1418: ,p_token2_value => SQLERRM);
1419:
1420: -- notify caller of an UNEXPECTED error
1421: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1422:
1423: END Validate_LE_Id;
1424:
1425: ---------------------------------------------------------------------------

Line 1558: l_dummy VARCHAR2(1) := OKL_API.G_FALSE;

1554: ---------------------------------------------------------------------------
1555: PROCEDURE Validate_Tcn_Type (p_tcnv_rec IN tcnv_rec_type
1556: ,x_return_status OUT NOCOPY VARCHAR2)
1557: IS
1558: l_dummy VARCHAR2(1) := OKL_API.G_FALSE;
1559:
1560: BEGIN
1561: -- initialize return status
1562: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 1581: IF (l_dummy = OKL_API.G_FALSE) THEN

1577: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1578: (p_lookup_type => 'OKL_TCN_TYPE',
1579: p_lookup_code => p_tcnv_rec.tcn_type);
1580:
1581: IF (l_dummy = OKL_API.G_FALSE) THEN
1582: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1583: ,p_msg_name => g_invalid_value
1584: ,p_token1 => g_col_name_token
1585: ,p_token1_value => 'tcn_type');

Line 1625: l_dummy VARCHAR2(1) := OKL_API.G_FALSE;

1621: ---------------------------------------------------------------------------
1622: PROCEDURE Validate_Rjn_Code (p_tcnv_rec IN tcnv_rec_type
1623: ,x_return_status OUT NOCOPY VARCHAR2)
1624: IS
1625: l_dummy VARCHAR2(1) := OKL_API.G_FALSE;
1626:
1627: BEGIN
1628: -- initialize return status
1629: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 1637: IF (l_dummy = OKL_API.G_FALSE) THEN

1633: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1634: (p_lookup_type => 'OKL_REJECTION_REASON',
1635: p_lookup_code => p_tcnv_rec.rjn_code);
1636:
1637: IF (l_dummy = OKL_API.G_FALSE) THEN
1638: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1639: ,p_msg_name => g_invalid_value
1640: ,p_token1 => g_col_name_token
1641: ,p_token1_value => 'rjn_code');

Line 1683: l_dummy VARCHAR2(1) := OKL_API.G_FALSE;

1679: ---------------------------------------------------------------------------
1680: PROCEDURE Validate_CCID (p_tcnv_rec IN tcnv_rec_type
1681: ,x_return_status OUT NOCOPY VARCHAR2)
1682: IS
1683: l_dummy VARCHAR2(1) := OKL_API.G_FALSE;
1684:
1685: BEGIN
1686: -- initialize return status
1687: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 1695: IF (l_dummy = OKL_API.G_FALSE) THEN

1691: (p_tcnv_rec.code_combination_id <> Okc_Api.G_MISS_NUM) THEN
1692:
1693: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_tcnv_rec.Code_Combination_Id);
1694:
1695: IF (l_dummy = OKL_API.G_FALSE) THEN
1696: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1697: ,p_msg_name => g_invalid_value
1698: ,p_token1 => g_col_name_token
1699: ,p_token1_value => 'code_Combination_id');

Line 1760: IF (l_dummy = OKL_API.G_FALSE) THEN

1756: (p_lookup_type => 'YES_NO',
1757: p_lookup_code => p_tcnv_rec.accrual_status_yn,
1758: p_app_id => l_app_id,
1759: p_view_app_id => l_view_app_id);
1760: IF (l_dummy = OKL_API.G_FALSE) THEN
1761: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1762: ,p_msg_name => g_invalid_value
1763: ,p_token1 => g_col_name_token
1764: ,p_token1_value => 'accrual_status_yn');

Line 1826: IF (l_dummy = OKL_API.G_FALSE) THEN

1822: p_lookup_code => p_tcnv_rec.update_status_yn,
1823: p_app_id => l_app_id,
1824: p_view_app_id => l_view_app_id);
1825:
1826: IF (l_dummy = OKL_API.G_FALSE) THEN
1827: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1828: ,p_msg_name => g_invalid_value
1829: ,p_token1 => g_col_name_token
1830: ,p_token1_value => 'update_status_yn');

Line 1895: IF (l_dummy = OKL_API.G_FALSE) THEN

1891: p_lookup_code => p_tcnv_rec.Accounting_Reversal_YN,
1892: p_app_id => l_app_id,
1893: p_view_app_id => l_view_app_id);
1894:
1895: IF (l_dummy = OKL_API.G_FALSE) THEN
1896: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1897: ,p_msg_name => g_invalid_value
1898: ,p_token1 => g_col_name_token
1899: ,p_token1_value => 'Accounting_Reversal_YN');

Line 1961: IF (l_dummy = OKL_API.G_FALSE) THEN

1957: p_lookup_code => p_tcnv_rec.tax_deductible_local,
1958: p_app_id => l_app_id,
1959: p_view_app_id => l_view_app_id);
1960:
1961: IF (l_dummy = OKL_API.G_FALSE) THEN
1962: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
1963: ,p_msg_name => g_invalid_value
1964: ,p_token1 => g_col_name_token
1965: ,p_token1_value => 'tax_deductible_local');

Line 2029: IF (l_dummy = OKL_API.G_FALSE) THEN

2025: p_lookup_code => p_tcnv_rec.tax_deductible_corporate,
2026: p_app_id => l_app_id,
2027: p_view_app_id => l_view_app_id);
2028:
2029: IF (l_dummy = OKL_API.G_FALSE) THEN
2030: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2031: ,p_msg_name => g_invalid_value
2032: ,p_token1 => g_col_name_token
2033: ,p_token1_value => 'tax_deductible_corporate');

Line 2094: IF (l_dummy = OKL_API.G_FALSE) THEN

2090: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2091: (p_lookup_type => 'OKL_REBOOK_REASON',
2092: p_lookup_code => p_tcnv_rec.RBR_CODE);
2093:
2094: IF (l_dummy = OKL_API.G_FALSE) THEN
2095: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2096: ,p_msg_name => g_invalid_value
2097: ,p_token1 => g_col_name_token
2098: ,p_token1_value => 'RBR_CODE');

Line 2159: IF (l_dummy = OKL_API.G_FALSE) THEN

2155: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2156: (p_lookup_type => 'OKL_REBOOK_PROCESS_TYPE',
2157: p_lookup_code => p_tcnv_rec.RPY_CODE);
2158:
2159: IF (l_dummy = OKL_API.G_FALSE) THEN
2160: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2161: ,p_msg_name => g_invalid_value
2162: ,p_token1 => g_col_name_token
2163: ,p_token1_value => 'RPY_CODE');

Line 2223: IF (l_dummy = OKL_API.G_FALSE) THEN

2219: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2220: (p_lookup_type => 'OKL_REVERSE_REASON',
2221: p_lookup_code => p_tcnv_rec.RVN_CODE);
2222:
2223: IF (l_dummy = OKL_API.G_FALSE) THEN
2224: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2225: ,p_msg_name => g_invalid_value
2226: ,p_token1 => g_col_name_token
2227: ,p_token1_value => 'RVN_CODE');

Line 2295: IF (l_dummy = OKL_API.G_FALSE) THEN

2291: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2292: (p_lookup_type => 'OKL_TRANSACTION_STATUS',
2293: p_lookup_code => p_tcnv_rec.TSU_CODE);
2294:
2295: IF (l_dummy = OKL_API.G_FALSE) THEN
2296: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2297: ,p_msg_name => g_invalid_value
2298: ,p_token1 => g_col_name_token
2299: ,p_token1_value => 'TSU_CODE');

Line 2362: IF (l_dummy = OKL_API.G_FALSE) THEN

2358: p_lookup_code => p_tcnv_rec.TRN_CODE,
2359: p_app_id => l_app_id,
2360: p_view_app_id => l_view_app_id);
2361:
2362: IF (l_dummy = OKL_API.G_FALSE) THEN
2363: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2364: ,p_msg_name => g_invalid_value
2365: ,p_token1 => g_col_name_token
2366: ,p_token1_value => 'TRN_CODE');

Line 2411: l_Dummy VARCHAR2(1) := OKL_API.G_FALSE;

2407: PROCEDURE Validate_currency_code(p_tcnv_rec IN tcnv_rec_type
2408: ,x_return_status OUT NOCOPY VARCHAR2)
2409: IS
2410:
2411: l_Dummy VARCHAR2(1) := OKL_API.G_FALSE;
2412:
2413: BEGIN
2414: -- initialize return status
2415: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 2431: IF (l_dummy = okl_api.g_false) THEN

2427: END IF;
2428:
2429: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_CURRENCY_CODE (p_tcnv_rec.currency_code);
2430:
2431: IF (l_dummy = okl_api.g_false) THEN
2432: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
2433: p_msg_name => g_invalid_value,
2434: p_token1 => g_col_name_token,
2435: p_token1_value => 'CURRENCY_CODE');

Line 2703: IF (l_dummy = OKL_API.G_FALSE) THEN

2699: p_lookup_code => p_tcnv_rec.TMT_EVERGREEN_YN,
2700: p_app_id => l_app_id,
2701: p_view_app_id => l_view_app_id);
2702:
2703: IF (l_dummy = OKL_API.G_FALSE) THEN
2704: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2705: ,p_msg_name => g_invalid_value
2706: ,p_token1 => g_col_name_token
2707: ,p_token1_value => 'TMT_EVERGREEN_YN');

Line 2724: IF (l_dummy = OKL_API.G_FALSE) THEN

2720: p_lookup_code => p_tcnv_rec.TMT_CLOSE_BALANCES_YN,
2721: p_app_id => l_app_id,
2722: p_view_app_id => l_view_app_id);
2723:
2724: IF (l_dummy = OKL_API.G_FALSE) THEN
2725: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2726: ,p_msg_name => g_invalid_value
2727: ,p_token1 => g_col_name_token
2728: ,p_token1_value => 'TMT_CLOSE_BALANCES_YN');

Line 2745: IF (l_dummy = OKL_API.G_FALSE) THEN

2741: p_lookup_code => p_tcnv_rec.TMT_ACCOUNTING_ENTRIES_YN,
2742: p_app_id => l_app_id,
2743: p_view_app_id => l_view_app_id);
2744:
2745: IF (l_dummy = OKL_API.G_FALSE) THEN
2746: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2747: ,p_msg_name => g_invalid_value
2748: ,p_token1 => g_col_name_token
2749: ,p_token1_value => 'TMT_ACCOUNTING_ENTRIES_YN');

Line 2766: IF (l_dummy = OKL_API.G_FALSE) THEN

2762: p_lookup_code => p_tcnv_rec.TMT_CANCEL_INSURANCE_YN,
2763: p_app_id => l_app_id,
2764: p_view_app_id => l_view_app_id);
2765:
2766: IF (l_dummy = OKL_API.G_FALSE) THEN
2767: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2768: ,p_msg_name => g_invalid_value
2769: ,p_token1 => g_col_name_token
2770: ,p_token1_value => 'TMT_CANCEL_INSURANCE_YN');

Line 2786: IF (l_dummy = OKL_API.G_FALSE) THEN

2782: p_lookup_code => p_tcnv_rec.TMT_ASSET_DISPOSITION_YN,
2783: p_app_id => l_app_id,
2784: p_view_app_id => l_view_app_id);
2785:
2786: IF (l_dummy = OKL_API.G_FALSE) THEN
2787: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2788: ,p_msg_name => g_invalid_value
2789: ,p_token1 => g_col_name_token
2790: ,p_token1_value => 'TMT_ASSET_DISPOSITION_YN');

Line 2807: IF (l_dummy = OKL_API.G_FALSE) THEN

2803: p_lookup_code => p_tcnv_rec.TMT_AMORTIZATION_YN,
2804: p_app_id => l_app_id,
2805: p_view_app_id => l_view_app_id);
2806:
2807: IF (l_dummy = OKL_API.G_FALSE) THEN
2808: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2809: ,p_msg_name => g_invalid_value
2810: ,p_token1 => g_col_name_token
2811: ,p_token1_value => 'TMT_AMORTIZATION_YN');

Line 2827: IF (l_dummy = OKL_API.G_FALSE) THEN

2823: p_lookup_code => p_tcnv_rec.TMT_ASSET_RETURN_YN,
2824: p_app_id => l_app_id,
2825: p_view_app_id => l_view_app_id);
2826:
2827: IF (l_dummy = OKL_API.G_FALSE) THEN
2828: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2829: ,p_msg_name => g_invalid_value
2830: ,p_token1 => g_col_name_token
2831: ,p_token1_value => 'TMT_ASSET_RETURN_YN');

Line 2847: IF (l_dummy = OKL_API.G_FALSE) THEN

2843: p_lookup_code => p_tcnv_rec.TMT_CONTRACT_UPDATED_YN,
2844: p_app_id => l_app_id,
2845: p_view_app_id => l_view_app_id);
2846:
2847: IF (l_dummy = OKL_API.G_FALSE) THEN
2848: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2849: ,p_msg_name => g_invalid_value
2850: ,p_token1 => g_col_name_token
2851: ,p_token1_value => 'TMT_CONTRACT_UPDATED_YN');

Line 2867: IF (l_dummy = OKL_API.G_FALSE) THEN

2863: p_lookup_code => p_tcnv_rec.TMT_RECYCLE_YN,
2864: p_app_id => l_app_id,
2865: p_view_app_id => l_view_app_id);
2866:
2867: IF (l_dummy = OKL_API.G_FALSE) THEN
2868: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2869: ,p_msg_name => g_invalid_value
2870: ,p_token1 => g_col_name_token
2871: ,p_token1_value => 'TMT_RECYCLE_YN');

Line 2887: IF (l_dummy = OKL_API.G_FALSE) THEN

2883: p_lookup_code => p_tcnv_rec.TMT_VALIDATED_YN,
2884: p_app_id => l_app_id,
2885: p_view_app_id => l_view_app_id);
2886:
2887: IF (l_dummy = OKL_API.G_FALSE) THEN
2888: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2889: ,p_msg_name => g_invalid_value
2890: ,p_token1 => g_col_name_token
2891: ,p_token1_value => 'TMT_VALIDATED_YN');

Line 2907: IF (l_dummy = OKL_API.G_FALSE) THEN

2903: p_lookup_code => p_tcnv_rec.TMT_STREAMS_UPDATED_YN,
2904: p_app_id => l_app_id,
2905: p_view_app_id => l_view_app_id);
2906:
2907: IF (l_dummy = OKL_API.G_FALSE) THEN
2908: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2909: ,p_msg_name => g_invalid_value
2910: ,p_token1 => g_col_name_token
2911: ,p_token1_value => 'TMT_STREAMS_UPDATED_YN');

Line 2957: l_dummy VARCHAR2(1) := OKL_API.G_FALSE;

2953: ---------------------------------------------------------------------------
2954: PROCEDURE Validate_Accrual_Activity (p_tcnv_rec IN tcnv_rec_type
2955: ,x_return_status OUT NOCOPY VARCHAR2)
2956: IS
2957: l_dummy VARCHAR2(1) := OKL_API.G_FALSE;
2958:
2959: BEGIN
2960: -- initialize return status
2961: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 2969: IF (l_dummy = OKL_API.G_FALSE) THEN

2965: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2966: (p_lookup_type => 'OKL_ACCRUAL_ACTIVITY',
2967: p_lookup_code => p_tcnv_rec.accrual_activity);
2968:
2969: IF (l_dummy = OKL_API.G_FALSE) THEN
2970: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
2971: ,p_msg_name => g_invalid_value
2972: ,p_token1 => g_col_name_token
2973: ,p_token1_value => 'Accrual Activity');

Line 3288: IF (l_dummy = OKL_API.G_FALSE) THEN

3284: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
3285: (p_lookup_type => 'OKL_TRANSACTION_STATUS',
3286: p_lookup_code => p_tcnv_rec.TMT_STATUS_CODE);
3287:
3288: IF (l_dummy = OKL_API.G_FALSE) THEN
3289: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
3290: ,p_msg_name => g_invalid_value
3291: ,p_token1 => g_col_name_token
3292: ,p_token1_value => 'TMT_STATUS_CODE');

Line 3350: IF (l_dummy = OKL_API.G_FALSE) THEN

3346: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
3347: (p_lookup_type => 'OKL_YES_NO',
3348: p_lookup_code => p_tcnv_rec.UPGRADE_STATUS_FLAG);
3349:
3350: IF (l_dummy = OKL_API.G_FALSE) THEN
3351: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
3352: ,p_msg_name => g_invalid_value
3353: ,p_token1 => g_col_name_token
3354: ,p_token1_value => 'UPGRADE_STATUS_FLAG');

Line 4023: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

4019: --Added by dpsingh
4020:
4021: -- Validate_LE_Id
4022: Validate_LE_Id(p_tcnv_rec, x_return_status);
4023: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4024: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4025: -- need to exit
4026: l_return_status := x_return_status;
4027: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 4024: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

4020:
4021: -- Validate_LE_Id
4022: Validate_LE_Id(p_tcnv_rec, x_return_status);
4023: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4024: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4025: -- need to exit
4026: l_return_status := x_return_status;
4027: RAISE G_EXCEPTION_HALT_VALIDATION;
4028: ELSE

Line 4899: (l_tcnv_rec.TRANSACTION_DATE = OKL_API.G_MISS_DATE) THEN

4895: l_tcnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
4896: l_tcnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
4897:
4898: IF (l_tcnv_rec.TRANSACTION_DATE IS NULL) OR
4899: (l_tcnv_rec.TRANSACTION_DATE = OKL_API.G_MISS_DATE) THEN
4900: l_tcnv_rec.TRANSACTION_DATE := SYSDATE;
4901: END IF;
4902:
4903: RETURN(l_tcnv_rec);

Line 4945: (x_tcnv_rec.trx_number = OKL_API.G_MISS_CHAR) THEN

4941:
4942: BEGIN
4943:
4944: IF (x_tcnv_rec.trx_number IS NULL) OR
4945: (x_tcnv_rec.trx_number = OKL_API.G_MISS_CHAR) THEN
4946: SELECT OKL_TCN_SEQ.NEXTVAL INTO x_tcnv_rec.trx_number FROM DUAL;
4947: END IF;
4948:
4949: IF (x_tcnv_rec.currency_code IS NULL) OR

Line 4950: (x_tcnv_rec.currency_code = OKL_API.G_MISS_CHAR) THEN

4946: SELECT OKL_TCN_SEQ.NEXTVAL INTO x_tcnv_rec.trx_number FROM DUAL;
4947: END IF;
4948:
4949: IF (x_tcnv_rec.currency_code IS NULL) OR
4950: (x_tcnv_rec.currency_code = OKL_API.G_MISS_CHAR) THEN
4951: x_tcnv_rec.currency_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
4952: END IF;
4953:
4954: EXCEPTION

Line 4955: WHEN OTHERS THEN l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

4951: x_tcnv_rec.currency_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
4952: END IF;
4953:
4954: EXCEPTION
4955: WHEN OTHERS THEN l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4956: END;
4957:
4958: RETURN(l_return_status);
4959: END Set_Attributes;

Line 5786: IF (x_tcn_rec.legal_entity_id = Okl_Api.G_MISS_NUM)

5782: THEN
5783: x_tcn_rec.canceled_date := l_tcn_rec.canceled_date;
5784: END IF;
5785:
5786: IF (x_tcn_rec.legal_entity_id = Okl_Api.G_MISS_NUM)
5787: THEN
5788: x_tcn_rec.legal_entity_id := l_tcn_rec.legal_entity_id;
5789: END IF;
5790:

Line 5792: IF (x_tcn_rec.accrual_reversal_date = Okl_Api.G_MISS_DATE)

5788: x_tcn_rec.legal_entity_id := l_tcn_rec.legal_entity_id;
5789: END IF;
5790:
5791: --Added by dpsingh for SLA Uptake (Bug 5707866)
5792: IF (x_tcn_rec.accrual_reversal_date = Okl_Api.G_MISS_DATE)
5793: THEN
5794: x_tcn_rec.accrual_reversal_date := l_tcn_rec.accrual_reversal_date;
5795: END IF;
5796:

Line 5798: IF (x_tcn_rec.accounting_reversal_yn = Okl_Api.G_MISS_CHAR)

5794: x_tcn_rec.accrual_reversal_date := l_tcn_rec.accrual_reversal_date;
5795: END IF;
5796:
5797: -- Added by DJANASWA for SLA project
5798: IF (x_tcn_rec.accounting_reversal_yn = Okl_Api.G_MISS_CHAR)
5799: THEN
5800: x_tcn_rec.accounting_reversal_yn := l_tcn_rec.accounting_reversal_yn;
5801: END IF;
5802: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007

Line 5803: IF (x_tcn_rec.product_name = Okl_Api.G_MISS_CHAR)

5799: THEN
5800: x_tcn_rec.accounting_reversal_yn := l_tcn_rec.accounting_reversal_yn;
5801: END IF;
5802: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
5803: IF (x_tcn_rec.product_name = Okl_Api.G_MISS_CHAR)
5804: THEN
5805: x_tcn_rec.product_name := l_tcn_rec.product_name;
5806: END IF;
5807:

Line 5808: IF (x_tcn_rec.book_classification_code = Okl_Api.G_MISS_CHAR)

5804: THEN
5805: x_tcn_rec.product_name := l_tcn_rec.product_name;
5806: END IF;
5807:
5808: IF (x_tcn_rec.book_classification_code = Okl_Api.G_MISS_CHAR)
5809: THEN
5810: x_tcn_rec.book_classification_code := l_tcn_rec.book_classification_code;
5811: END IF;
5812:

Line 5813: IF (x_tcn_rec.tax_owner_code = Okl_Api.G_MISS_CHAR)

5809: THEN
5810: x_tcn_rec.book_classification_code := l_tcn_rec.book_classification_code;
5811: END IF;
5812:
5813: IF (x_tcn_rec.tax_owner_code = Okl_Api.G_MISS_CHAR)
5814: THEN
5815: x_tcn_rec.tax_owner_code := l_tcn_rec.tax_owner_code;
5816: END IF;
5817:

Line 5818: IF (x_tcn_rec.tmt_status_code = Okl_Api.G_MISS_CHAR)

5814: THEN
5815: x_tcn_rec.tax_owner_code := l_tcn_rec.tax_owner_code;
5816: END IF;
5817:
5818: IF (x_tcn_rec.tmt_status_code = Okl_Api.G_MISS_CHAR)
5819: THEN
5820: x_tcn_rec.tmt_status_code := l_tcn_rec.tmt_status_code;
5821: END IF;
5822: IF (x_tcn_rec.representation_name = Okl_Api.G_MISS_CHAR)

Line 5822: IF (x_tcn_rec.representation_name = Okl_Api.G_MISS_CHAR)

5818: IF (x_tcn_rec.tmt_status_code = Okl_Api.G_MISS_CHAR)
5819: THEN
5820: x_tcn_rec.tmt_status_code := l_tcn_rec.tmt_status_code;
5821: END IF;
5822: IF (x_tcn_rec.representation_name = Okl_Api.G_MISS_CHAR)
5823: THEN
5824: x_tcn_rec.representation_name := l_tcn_rec.representation_name;
5825: END IF;
5826: IF (x_tcn_rec.representation_code = Okl_Api.G_MISS_CHAR)

Line 5826: IF (x_tcn_rec.representation_code = Okl_Api.G_MISS_CHAR)

5822: IF (x_tcn_rec.representation_name = Okl_Api.G_MISS_CHAR)
5823: THEN
5824: x_tcn_rec.representation_name := l_tcn_rec.representation_name;
5825: END IF;
5826: IF (x_tcn_rec.representation_code = Okl_Api.G_MISS_CHAR)
5827: THEN
5828: x_tcn_rec.representation_code := l_tcn_rec.representation_code;
5829: END IF;
5830: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007

Line 5831: IF (x_tcn_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR)

5827: THEN
5828: x_tcn_rec.representation_code := l_tcn_rec.representation_code;
5829: END IF;
5830: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
5831: IF (x_tcn_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR)
5832: THEN
5833: x_tcn_rec.UPGRADE_STATUS_FLAG := l_tcn_rec.UPGRADE_STATUS_FLAG;
5834: END IF;
5835: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007

Line 5836: IF (x_tcn_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE)

5832: THEN
5833: x_tcn_rec.UPGRADE_STATUS_FLAG := l_tcn_rec.UPGRADE_STATUS_FLAG;
5834: END IF;
5835: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
5836: IF (x_tcn_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE)
5837: THEN
5838: x_tcn_rec.TRANSACTION_DATE := l_tcn_rec.TRANSACTION_DATE;
5839: END IF;
5840: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007

Line 5841: IF (x_tcn_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM)

5837: THEN
5838: x_tcn_rec.TRANSACTION_DATE := l_tcn_rec.TRANSACTION_DATE;
5839: END IF;
5840: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
5841: IF (x_tcn_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM)
5842: THEN
5843: x_tcn_rec.primary_rep_trx_id := l_tcn_rec.primary_rep_trx_id;
5844: END IF;
5845: IF (x_tcn_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR)

Line 5845: IF (x_tcn_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR)

5841: IF (x_tcn_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM)
5842: THEN
5843: x_tcn_rec.primary_rep_trx_id := l_tcn_rec.primary_rep_trx_id;
5844: END IF;
5845: IF (x_tcn_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR)
5846: THEN
5847: x_tcn_rec.REPRESENTATION_TYPE := l_tcn_rec.REPRESENTATION_TYPE;
5848: END IF;
5849: -- Added by sosharma for Income Account recon- report 01-Nov-2008

Line 5850: IF (x_tcn_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE)

5846: THEN
5847: x_tcn_rec.REPRESENTATION_TYPE := l_tcn_rec.REPRESENTATION_TYPE;
5848: END IF;
5849: -- Added by sosharma for Income Account recon- report 01-Nov-2008
5850: IF (x_tcn_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE)
5851: THEN
5852: x_tcn_rec.TRANSACTION_REVERSAL_DATE := l_tcn_rec.TRANSACTION_REVERSAL_DATE;
5853: END IF;
5854:

Line 6425: IF (x_tcnv_rec.legal_entity_id = Okl_Api.G_MISS_NUM) THEN

6421: x_tcnv_rec.canceled_date := l_tcnv_rec.canceled_date;
6422: END IF;
6423:
6424: --Added by dpsingh for LE Uptake
6425: IF (x_tcnv_rec.legal_entity_id = Okl_Api.G_MISS_NUM) THEN
6426: x_tcnv_rec.legal_entity_id := l_tcnv_rec.legal_entity_id;
6427: END IF;
6428:
6429: --Added by dpsingh for SLA Uptake (Bug 5707866)

Line 6430: IF (x_tcnv_rec.accrual_reversal_date = Okl_Api.G_MISS_DATE) THEN

6426: x_tcnv_rec.legal_entity_id := l_tcnv_rec.legal_entity_id;
6427: END IF;
6428:
6429: --Added by dpsingh for SLA Uptake (Bug 5707866)
6430: IF (x_tcnv_rec.accrual_reversal_date = Okl_Api.G_MISS_DATE) THEN
6431: x_tcnv_rec.accrual_reversal_date := l_tcnv_rec.accrual_reversal_date;
6432: END IF;
6433:
6434: -- Added by DJANASWA for SLA project

Line 6435: IF (x_tcnv_rec.accounting_reversal_yn = Okl_Api.G_MISS_CHAR) THEN

6431: x_tcnv_rec.accrual_reversal_date := l_tcnv_rec.accrual_reversal_date;
6432: END IF;
6433:
6434: -- Added by DJANASWA for SLA project
6435: IF (x_tcnv_rec.accounting_reversal_yn = Okl_Api.G_MISS_CHAR) THEN
6436: x_tcnv_rec.accounting_reversal_yn := l_tcnv_rec.accounting_reversal_yn;
6437: END IF;
6438:
6439: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007

Line 6440: IF (x_tcnv_rec.product_name = Okl_Api.G_MISS_CHAR) THEN

6436: x_tcnv_rec.accounting_reversal_yn := l_tcnv_rec.accounting_reversal_yn;
6437: END IF;
6438:
6439: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
6440: IF (x_tcnv_rec.product_name = Okl_Api.G_MISS_CHAR) THEN
6441: x_tcnv_rec.product_name := l_tcnv_rec.product_name;
6442: END IF;
6443:
6444: IF (x_tcnv_rec.book_classification_code = Okl_Api.G_MISS_CHAR) THEN

Line 6444: IF (x_tcnv_rec.book_classification_code = Okl_Api.G_MISS_CHAR) THEN

6440: IF (x_tcnv_rec.product_name = Okl_Api.G_MISS_CHAR) THEN
6441: x_tcnv_rec.product_name := l_tcnv_rec.product_name;
6442: END IF;
6443:
6444: IF (x_tcnv_rec.book_classification_code = Okl_Api.G_MISS_CHAR) THEN
6445: x_tcnv_rec.book_classification_code := l_tcnv_rec.book_classification_code;
6446: END IF;
6447:
6448: IF (x_tcnv_rec.tax_owner_code = Okl_Api.G_MISS_CHAR) THEN

Line 6448: IF (x_tcnv_rec.tax_owner_code = Okl_Api.G_MISS_CHAR) THEN

6444: IF (x_tcnv_rec.book_classification_code = Okl_Api.G_MISS_CHAR) THEN
6445: x_tcnv_rec.book_classification_code := l_tcnv_rec.book_classification_code;
6446: END IF;
6447:
6448: IF (x_tcnv_rec.tax_owner_code = Okl_Api.G_MISS_CHAR) THEN
6449: x_tcnv_rec.tax_owner_code := l_tcnv_rec.tax_owner_code;
6450: END IF;
6451:
6452: IF (x_tcnv_rec.tmt_status_code = Okl_Api.G_MISS_CHAR) THEN

Line 6452: IF (x_tcnv_rec.tmt_status_code = Okl_Api.G_MISS_CHAR) THEN

6448: IF (x_tcnv_rec.tax_owner_code = Okl_Api.G_MISS_CHAR) THEN
6449: x_tcnv_rec.tax_owner_code := l_tcnv_rec.tax_owner_code;
6450: END IF;
6451:
6452: IF (x_tcnv_rec.tmt_status_code = Okl_Api.G_MISS_CHAR) THEN
6453: x_tcnv_rec.tmt_status_code := l_tcnv_rec.tmt_status_code;
6454: END IF;
6455:
6456: IF (x_tcnv_rec.representation_name = Okl_Api.G_MISS_CHAR) THEN

Line 6456: IF (x_tcnv_rec.representation_name = Okl_Api.G_MISS_CHAR) THEN

6452: IF (x_tcnv_rec.tmt_status_code = Okl_Api.G_MISS_CHAR) THEN
6453: x_tcnv_rec.tmt_status_code := l_tcnv_rec.tmt_status_code;
6454: END IF;
6455:
6456: IF (x_tcnv_rec.representation_name = Okl_Api.G_MISS_CHAR) THEN
6457: x_tcnv_rec.representation_name := l_tcnv_rec.representation_name;
6458: END IF;
6459:
6460: IF (x_tcnv_rec.representation_code = Okl_Api.G_MISS_CHAR) THEN

Line 6460: IF (x_tcnv_rec.representation_code = Okl_Api.G_MISS_CHAR) THEN

6456: IF (x_tcnv_rec.representation_name = Okl_Api.G_MISS_CHAR) THEN
6457: x_tcnv_rec.representation_name := l_tcnv_rec.representation_name;
6458: END IF;
6459:
6460: IF (x_tcnv_rec.representation_code = Okl_Api.G_MISS_CHAR) THEN
6461: x_tcnv_rec.representation_code := l_tcnv_rec.representation_code;
6462: END IF;
6463: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
6464: IF (x_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN

Line 6464: IF (x_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN

6460: IF (x_tcnv_rec.representation_code = Okl_Api.G_MISS_CHAR) THEN
6461: x_tcnv_rec.representation_code := l_tcnv_rec.representation_code;
6462: END IF;
6463: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
6464: IF (x_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN
6465: x_tcnv_rec.UPGRADE_STATUS_FLAG := l_tcnv_rec.UPGRADE_STATUS_FLAG;
6466: END IF;
6467: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
6468: IF (x_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN

Line 6468: IF (x_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN

6464: IF (x_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN
6465: x_tcnv_rec.UPGRADE_STATUS_FLAG := l_tcnv_rec.UPGRADE_STATUS_FLAG;
6466: END IF;
6467: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
6468: IF (x_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN
6469: x_tcnv_rec.TRANSACTION_DATE := SYSDATE;
6470: END IF;
6471: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
6472: IF (x_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN

Line 6472: IF (x_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN

6468: IF (x_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN
6469: x_tcnv_rec.TRANSACTION_DATE := SYSDATE;
6470: END IF;
6471: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
6472: IF (x_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN
6473: x_tcnv_rec.primary_rep_trx_id := l_tcnv_rec.primary_rep_trx_id;
6474: END IF;
6475: IF (x_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN
6476: x_tcnv_rec.REPRESENTATION_TYPE := l_tcnv_rec.REPRESENTATION_TYPE;

Line 6475: IF (x_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN

6471: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
6472: IF (x_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN
6473: x_tcnv_rec.primary_rep_trx_id := l_tcnv_rec.primary_rep_trx_id;
6474: END IF;
6475: IF (x_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN
6476: x_tcnv_rec.REPRESENTATION_TYPE := l_tcnv_rec.REPRESENTATION_TYPE;
6477: END IF;
6478: -- Added by sosharma for Income Account recon- report 01-Nov-2008
6479: IF (x_tcnv_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE) THEN

Line 6479: IF (x_tcnv_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE) THEN

6475: IF (x_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN
6476: x_tcnv_rec.REPRESENTATION_TYPE := l_tcnv_rec.REPRESENTATION_TYPE;
6477: END IF;
6478: -- Added by sosharma for Income Account recon- report 01-Nov-2008
6479: IF (x_tcnv_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE) THEN
6480: x_tcnv_rec.TRANSACTION_REVERSAL_DATE := l_tcnv_rec.TRANSACTION_REVERSAL_DATE;
6481: END IF;
6482:
6483: RETURN(l_return_status);