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 4044: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

4040: --Added by dpsingh
4041:
4042: -- Validate_LE_Id
4043: Validate_LE_Id(p_tcnv_rec, x_return_status);
4044: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4045: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4046: -- need to exit
4047: l_return_status := x_return_status;
4048: RAISE G_EXCEPTION_HALT_VALIDATION;

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

4041:
4042: -- Validate_LE_Id
4043: Validate_LE_Id(p_tcnv_rec, x_return_status);
4044: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
4045: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4046: -- need to exit
4047: l_return_status := x_return_status;
4048: RAISE G_EXCEPTION_HALT_VALIDATION;
4049: ELSE

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

4916: l_tcnv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;
4917: l_tcnv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
4918:
4919: IF (l_tcnv_rec.TRANSACTION_DATE IS NULL) OR
4920: (l_tcnv_rec.TRANSACTION_DATE = OKL_API.G_MISS_DATE) THEN
4921: l_tcnv_rec.TRANSACTION_DATE := SYSDATE;
4922: END IF;
4923:
4924: RETURN(l_tcnv_rec);

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

4962:
4963: BEGIN
4964:
4965: IF (x_tcnv_rec.trx_number IS NULL) OR
4966: (x_tcnv_rec.trx_number = OKL_API.G_MISS_CHAR) THEN
4967: SELECT OKL_TCN_SEQ.NEXTVAL INTO x_tcnv_rec.trx_number FROM DUAL;
4968: END IF;
4969:
4970: IF (x_tcnv_rec.currency_code IS NULL) OR

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

4967: SELECT OKL_TCN_SEQ.NEXTVAL INTO x_tcnv_rec.trx_number FROM DUAL;
4968: END IF;
4969:
4970: IF (x_tcnv_rec.currency_code IS NULL) OR
4971: (x_tcnv_rec.currency_code = OKL_API.G_MISS_CHAR) THEN
4972: x_tcnv_rec.currency_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
4973: END IF;
4974:
4975: EXCEPTION

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

4972: x_tcnv_rec.currency_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
4973: END IF;
4974:
4975: EXCEPTION
4976: WHEN OTHERS THEN l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
4977: END;
4978:
4979: RETURN(l_return_status);
4980: END Set_Attributes;

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

5803: THEN
5804: x_tcn_rec.canceled_date := l_tcn_rec.canceled_date;
5805: END IF;
5806:
5807: IF (x_tcn_rec.legal_entity_id = Okl_Api.G_MISS_NUM)
5808: THEN
5809: x_tcn_rec.legal_entity_id := l_tcn_rec.legal_entity_id;
5810: END IF;
5811:

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

5809: x_tcn_rec.legal_entity_id := l_tcn_rec.legal_entity_id;
5810: END IF;
5811:
5812: --Added by dpsingh for SLA Uptake (Bug 5707866)
5813: IF (x_tcn_rec.accrual_reversal_date = Okl_Api.G_MISS_DATE)
5814: THEN
5815: x_tcn_rec.accrual_reversal_date := l_tcn_rec.accrual_reversal_date;
5816: END IF;
5817:

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

5815: x_tcn_rec.accrual_reversal_date := l_tcn_rec.accrual_reversal_date;
5816: END IF;
5817:
5818: -- Added by DJANASWA for SLA project
5819: IF (x_tcn_rec.accounting_reversal_yn = Okl_Api.G_MISS_CHAR)
5820: THEN
5821: x_tcn_rec.accounting_reversal_yn := l_tcn_rec.accounting_reversal_yn;
5822: END IF;
5823: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007

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

5820: THEN
5821: x_tcn_rec.accounting_reversal_yn := l_tcn_rec.accounting_reversal_yn;
5822: END IF;
5823: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
5824: IF (x_tcn_rec.product_name = Okl_Api.G_MISS_CHAR)
5825: THEN
5826: x_tcn_rec.product_name := l_tcn_rec.product_name;
5827: END IF;
5828:

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

5825: THEN
5826: x_tcn_rec.product_name := l_tcn_rec.product_name;
5827: END IF;
5828:
5829: IF (x_tcn_rec.book_classification_code = Okl_Api.G_MISS_CHAR)
5830: THEN
5831: x_tcn_rec.book_classification_code := l_tcn_rec.book_classification_code;
5832: END IF;
5833:

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

5830: THEN
5831: x_tcn_rec.book_classification_code := l_tcn_rec.book_classification_code;
5832: END IF;
5833:
5834: IF (x_tcn_rec.tax_owner_code = Okl_Api.G_MISS_CHAR)
5835: THEN
5836: x_tcn_rec.tax_owner_code := l_tcn_rec.tax_owner_code;
5837: END IF;
5838:

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

5835: THEN
5836: x_tcn_rec.tax_owner_code := l_tcn_rec.tax_owner_code;
5837: END IF;
5838:
5839: IF (x_tcn_rec.tmt_status_code = Okl_Api.G_MISS_CHAR)
5840: THEN
5841: x_tcn_rec.tmt_status_code := l_tcn_rec.tmt_status_code;
5842: END IF;
5843: IF (x_tcn_rec.representation_name = Okl_Api.G_MISS_CHAR)

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

5839: IF (x_tcn_rec.tmt_status_code = Okl_Api.G_MISS_CHAR)
5840: THEN
5841: x_tcn_rec.tmt_status_code := l_tcn_rec.tmt_status_code;
5842: END IF;
5843: IF (x_tcn_rec.representation_name = Okl_Api.G_MISS_CHAR)
5844: THEN
5845: x_tcn_rec.representation_name := l_tcn_rec.representation_name;
5846: END IF;
5847: IF (x_tcn_rec.representation_code = Okl_Api.G_MISS_CHAR)

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

5843: IF (x_tcn_rec.representation_name = Okl_Api.G_MISS_CHAR)
5844: THEN
5845: x_tcn_rec.representation_name := l_tcn_rec.representation_name;
5846: END IF;
5847: IF (x_tcn_rec.representation_code = Okl_Api.G_MISS_CHAR)
5848: THEN
5849: x_tcn_rec.representation_code := l_tcn_rec.representation_code;
5850: END IF;
5851: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007

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

5848: THEN
5849: x_tcn_rec.representation_code := l_tcn_rec.representation_code;
5850: END IF;
5851: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
5852: IF (x_tcn_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR)
5853: THEN
5854: x_tcn_rec.UPGRADE_STATUS_FLAG := l_tcn_rec.UPGRADE_STATUS_FLAG;
5855: END IF;
5856: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007

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

5853: THEN
5854: x_tcn_rec.UPGRADE_STATUS_FLAG := l_tcn_rec.UPGRADE_STATUS_FLAG;
5855: END IF;
5856: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
5857: IF (x_tcn_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE)
5858: THEN
5859: x_tcn_rec.TRANSACTION_DATE := l_tcn_rec.TRANSACTION_DATE;
5860: END IF;
5861: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007

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

5858: THEN
5859: x_tcn_rec.TRANSACTION_DATE := l_tcn_rec.TRANSACTION_DATE;
5860: END IF;
5861: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
5862: IF (x_tcn_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM)
5863: THEN
5864: x_tcn_rec.primary_rep_trx_id := l_tcn_rec.primary_rep_trx_id;
5865: END IF;
5866: IF (x_tcn_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR)

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

5862: IF (x_tcn_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM)
5863: THEN
5864: x_tcn_rec.primary_rep_trx_id := l_tcn_rec.primary_rep_trx_id;
5865: END IF;
5866: IF (x_tcn_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR)
5867: THEN
5868: x_tcn_rec.REPRESENTATION_TYPE := l_tcn_rec.REPRESENTATION_TYPE;
5869: END IF;
5870: -- Added by sosharma for Income Account recon- report 01-Nov-2008

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

5867: THEN
5868: x_tcn_rec.REPRESENTATION_TYPE := l_tcn_rec.REPRESENTATION_TYPE;
5869: END IF;
5870: -- Added by sosharma for Income Account recon- report 01-Nov-2008
5871: IF (x_tcn_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE)
5872: THEN
5873: x_tcn_rec.TRANSACTION_REVERSAL_DATE := l_tcn_rec.TRANSACTION_REVERSAL_DATE;
5874: END IF;
5875:

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

6442: x_tcnv_rec.canceled_date := l_tcnv_rec.canceled_date;
6443: END IF;
6444:
6445: --Added by dpsingh for LE Uptake
6446: IF (x_tcnv_rec.legal_entity_id = Okl_Api.G_MISS_NUM) THEN
6447: x_tcnv_rec.legal_entity_id := l_tcnv_rec.legal_entity_id;
6448: END IF;
6449:
6450: --Added by dpsingh for SLA Uptake (Bug 5707866)

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

6447: x_tcnv_rec.legal_entity_id := l_tcnv_rec.legal_entity_id;
6448: END IF;
6449:
6450: --Added by dpsingh for SLA Uptake (Bug 5707866)
6451: IF (x_tcnv_rec.accrual_reversal_date = Okl_Api.G_MISS_DATE) THEN
6452: x_tcnv_rec.accrual_reversal_date := l_tcnv_rec.accrual_reversal_date;
6453: END IF;
6454:
6455: -- Added by DJANASWA for SLA project

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

6452: x_tcnv_rec.accrual_reversal_date := l_tcnv_rec.accrual_reversal_date;
6453: END IF;
6454:
6455: -- Added by DJANASWA for SLA project
6456: IF (x_tcnv_rec.accounting_reversal_yn = Okl_Api.G_MISS_CHAR) THEN
6457: x_tcnv_rec.accounting_reversal_yn := l_tcnv_rec.accounting_reversal_yn;
6458: END IF;
6459:
6460: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007

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

6457: x_tcnv_rec.accounting_reversal_yn := l_tcnv_rec.accounting_reversal_yn;
6458: END IF;
6459:
6460: -- Added by zrehman for SLA project (Bug 5707866) 8-Feb-2007
6461: IF (x_tcnv_rec.product_name = Okl_Api.G_MISS_CHAR) THEN
6462: x_tcnv_rec.product_name := l_tcnv_rec.product_name;
6463: END IF;
6464:
6465: IF (x_tcnv_rec.book_classification_code = Okl_Api.G_MISS_CHAR) THEN

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

6461: IF (x_tcnv_rec.product_name = Okl_Api.G_MISS_CHAR) THEN
6462: x_tcnv_rec.product_name := l_tcnv_rec.product_name;
6463: END IF;
6464:
6465: IF (x_tcnv_rec.book_classification_code = Okl_Api.G_MISS_CHAR) THEN
6466: x_tcnv_rec.book_classification_code := l_tcnv_rec.book_classification_code;
6467: END IF;
6468:
6469: IF (x_tcnv_rec.tax_owner_code = Okl_Api.G_MISS_CHAR) THEN

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

6465: IF (x_tcnv_rec.book_classification_code = Okl_Api.G_MISS_CHAR) THEN
6466: x_tcnv_rec.book_classification_code := l_tcnv_rec.book_classification_code;
6467: END IF;
6468:
6469: IF (x_tcnv_rec.tax_owner_code = Okl_Api.G_MISS_CHAR) THEN
6470: x_tcnv_rec.tax_owner_code := l_tcnv_rec.tax_owner_code;
6471: END IF;
6472:
6473: IF (x_tcnv_rec.tmt_status_code = Okl_Api.G_MISS_CHAR) THEN

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

6469: IF (x_tcnv_rec.tax_owner_code = Okl_Api.G_MISS_CHAR) THEN
6470: x_tcnv_rec.tax_owner_code := l_tcnv_rec.tax_owner_code;
6471: END IF;
6472:
6473: IF (x_tcnv_rec.tmt_status_code = Okl_Api.G_MISS_CHAR) THEN
6474: x_tcnv_rec.tmt_status_code := l_tcnv_rec.tmt_status_code;
6475: END IF;
6476:
6477: IF (x_tcnv_rec.representation_name = Okl_Api.G_MISS_CHAR) THEN

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

6473: IF (x_tcnv_rec.tmt_status_code = Okl_Api.G_MISS_CHAR) THEN
6474: x_tcnv_rec.tmt_status_code := l_tcnv_rec.tmt_status_code;
6475: END IF;
6476:
6477: IF (x_tcnv_rec.representation_name = Okl_Api.G_MISS_CHAR) THEN
6478: x_tcnv_rec.representation_name := l_tcnv_rec.representation_name;
6479: END IF;
6480:
6481: IF (x_tcnv_rec.representation_code = Okl_Api.G_MISS_CHAR) THEN

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

6477: IF (x_tcnv_rec.representation_name = Okl_Api.G_MISS_CHAR) THEN
6478: x_tcnv_rec.representation_name := l_tcnv_rec.representation_name;
6479: END IF;
6480:
6481: IF (x_tcnv_rec.representation_code = Okl_Api.G_MISS_CHAR) THEN
6482: x_tcnv_rec.representation_code := l_tcnv_rec.representation_code;
6483: END IF;
6484: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
6485: IF (x_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN

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

6481: IF (x_tcnv_rec.representation_code = Okl_Api.G_MISS_CHAR) THEN
6482: x_tcnv_rec.representation_code := l_tcnv_rec.representation_code;
6483: END IF;
6484: -- Added by nikshah for SLA project (Bug 5707866) 16-Apr-2007
6485: IF (x_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN
6486: x_tcnv_rec.UPGRADE_STATUS_FLAG := l_tcnv_rec.UPGRADE_STATUS_FLAG;
6487: END IF;
6488: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
6489: IF (x_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN

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

6485: IF (x_tcnv_rec.UPGRADE_STATUS_FLAG = Okl_Api.G_MISS_CHAR) THEN
6486: x_tcnv_rec.UPGRADE_STATUS_FLAG := l_tcnv_rec.UPGRADE_STATUS_FLAG;
6487: END IF;
6488: -- Added by dcshanmu for Transaction Date Stamping 02-Nov-2007
6489: IF (x_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN
6490: x_tcnv_rec.TRANSACTION_DATE := SYSDATE;
6491: END IF;
6492: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
6493: IF (x_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN

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

6489: IF (x_tcnv_rec.TRANSACTION_DATE = Okl_Api.G_MISS_DATE) THEN
6490: x_tcnv_rec.TRANSACTION_DATE := SYSDATE;
6491: END IF;
6492: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
6493: IF (x_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN
6494: x_tcnv_rec.primary_rep_trx_id := l_tcnv_rec.primary_rep_trx_id;
6495: END IF;
6496: IF (x_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN
6497: x_tcnv_rec.REPRESENTATION_TYPE := l_tcnv_rec.REPRESENTATION_TYPE;

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

6492: -- Added by smereddy for Multi-GAAP project (Bug 7263041) 04-Aug-2007
6493: IF (x_tcnv_rec.primary_rep_trx_id = Okl_Api.G_MISS_NUM) THEN
6494: x_tcnv_rec.primary_rep_trx_id := l_tcnv_rec.primary_rep_trx_id;
6495: END IF;
6496: IF (x_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN
6497: x_tcnv_rec.REPRESENTATION_TYPE := l_tcnv_rec.REPRESENTATION_TYPE;
6498: END IF;
6499: -- Added by sosharma for Income Account recon- report 01-Nov-2008
6500: IF (x_tcnv_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE) THEN

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

6496: IF (x_tcnv_rec.REPRESENTATION_TYPE = Okl_Api.G_MISS_CHAR) THEN
6497: x_tcnv_rec.REPRESENTATION_TYPE := l_tcnv_rec.REPRESENTATION_TYPE;
6498: END IF;
6499: -- Added by sosharma for Income Account recon- report 01-Nov-2008
6500: IF (x_tcnv_rec.TRANSACTION_REVERSAL_DATE = Okl_Api.G_MISS_DATE) THEN
6501: x_tcnv_rec.TRANSACTION_REVERSAL_DATE := l_tcnv_rec.TRANSACTION_REVERSAL_DATE;
6502: END IF;
6503:
6504: RETURN(l_return_status);