DBA Data[Home] [Help]

APPS.OKL_TCN_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 1577: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

1573: END IF;
1574:
1575: -- check in fnd_lookups for validity
1576:
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

Line 1633: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

1629: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1630:
1631: -- check in fnd_lookups for validity
1632:
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

Line 1693: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_tcnv_rec.Code_Combination_Id);

1689: -- check for data before processing
1690: IF (p_tcnv_rec.code_combination_id IS NOT NULL) AND
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

Line 1755: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

1751: -- check for data before processing
1752: IF (p_tcnv_rec.accrual_status_yn IS NOT NULL) AND
1753: (p_tcnv_rec.accrual_status_yn <> Okc_Api.G_MISS_CHAR) THEN
1754: -- check in fnd_lookups for validity
1755: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
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);

Line 1820: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

1816: -- check for data before processing
1817: IF (p_tcnv_rec.update_status_yn IS NOT NULL) AND
1818: (p_tcnv_rec.update_status_yn <> Okc_Api.G_MISS_CHAR) THEN
1819: -- check in fnd_lookups for validity
1820: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1821: (p_lookup_type => 'YES_NO',
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);

Line 1889: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

1885: -- check for data before processing
1886: IF (p_tcnv_rec.Accounting_Reversal_YN IS NOT NULL) AND
1887: (p_tcnv_rec.Accounting_Reversal_YN <> Okc_Api.G_MISS_CHAR) THEN
1888: -- check in fnd_lookups for validity
1889: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1890: (p_lookup_type => 'YES_NO',
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);

Line 1955: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

1951:
1952: -- check for data before processing
1953: IF (p_tcnv_rec.tax_deductible_local IS NOT NULL) AND
1954: (p_tcnv_rec.tax_deductible_local <> Okc_Api.G_MISS_CHAR) THEN
1955: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1956: (p_lookup_type => 'YES_NO',
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);

Line 2023: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2019:
2020: IF (p_tcnv_rec.tax_deductible_corporate IS NOT NULL) AND
2021: (p_tcnv_rec.tax_deductible_corporate <> Okc_Api.G_MISS_CHAR) THEN
2022:
2023: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2024: (p_lookup_type => 'YES_NO',
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);

Line 2090: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2086:
2087: IF (p_tcnv_rec.RBR_CODE IS NOT NULL) AND
2088: (p_tcnv_rec.RBR_CODE <> Okc_Api.G_MISS_CHAR) THEN
2089:
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

Line 2155: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2151:
2152: IF (p_tcnv_rec.RPY_CODE IS NOT NULL) AND
2153: (p_tcnv_rec.RPY_CODE <> Okc_Api.G_MISS_CHAR) THEN
2154:
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

Line 2219: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2215:
2216: IF (p_tcnv_rec.RVN_CODE IS NOT NULL) AND
2217: (p_tcnv_rec.RVN_CODE <> Okc_Api.G_MISS_CHAR) THEN
2218:
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

Line 2291: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2287: x_return_status := OKC_API.G_RET_STS_ERROR;
2288: RAISE G_EXCEPTION_HALT_VALIDATION;
2289: END IF;
2290:
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

Line 2356: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2352:
2353: IF (p_tcnv_rec.TRN_CODE IS NOT NULL) AND
2354: (p_tcnv_rec.TRN_CODE <> Okc_Api.G_MISS_CHAR) THEN
2355:
2356: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2357: (p_lookup_type => 'OKC_TERMINATION_REASON',
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);

Line 2429: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_CURRENCY_CODE (p_tcnv_rec.currency_code);

2425: x_return_status := OKC_API.G_RET_STS_ERROR;
2426: RAISE G_EXCEPTION_HALT_VALIDATION;
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,

Line 2697: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2693:
2694: IF (p_tcnv_rec.TMT_EVERGREEN_YN IS NOT NULL) AND
2695: (p_tcnv_rec.TMT_EVERGREEN_YN <> Okc_Api.G_MISS_CHAR) THEN
2696:
2697: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2698: (p_lookup_type => 'YES_NO',
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);

Line 2718: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2714:
2715: IF (p_tcnv_rec.TMT_CLOSE_BALANCES_YN IS NOT NULL) AND
2716: (p_tcnv_rec.TMT_CLOSE_BALANCES_YN <> Okc_Api.G_MISS_CHAR) THEN
2717:
2718: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2719: (p_lookup_type => 'YES_NO',
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);

Line 2739: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2735:
2736: IF (p_tcnv_rec.TMT_ACCOUNTING_ENTRIES_YN IS NOT NULL) AND
2737: (p_tcnv_rec.TMT_ACCOUNTING_ENTRIES_YN <> Okc_Api.G_MISS_CHAR) THEN
2738:
2739: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2740: (p_lookup_type => 'YES_NO',
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);

Line 2760: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2756:
2757: IF (p_tcnv_rec.TMT_CANCEL_INSURANCE_YN IS NOT NULL) AND
2758: (p_tcnv_rec.TMT_CANCEL_INSURANCE_YN <> Okc_Api.G_MISS_CHAR) THEN
2759:
2760: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2761: (p_lookup_type => 'YES_NO',
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);

Line 2780: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2776:
2777: IF (p_tcnv_rec.TMT_ASSET_DISPOSITION_YN IS NOT NULL) AND
2778: (p_tcnv_rec.TMT_ASSET_DISPOSITION_YN <> Okc_Api.G_MISS_CHAR) THEN
2779:
2780: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2781: (p_lookup_type => 'YES_NO',
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);

Line 2801: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2797:
2798: IF (p_tcnv_rec.TMT_AMORTIZATION_YN IS NOT NULL) AND
2799: (p_tcnv_rec.TMT_AMORTIZATION_YN <> Okc_Api.G_MISS_CHAR) THEN
2800:
2801: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2802: (p_lookup_type => 'YES_NO',
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);

Line 2821: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2817:
2818: IF (p_tcnv_rec.TMT_ASSET_RETURN_YN IS NOT NULL) AND
2819: (p_tcnv_rec.TMT_ASSET_RETURN_YN <> Okc_Api.G_MISS_CHAR) THEN
2820:
2821: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2822: (p_lookup_type => 'YES_NO',
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);

Line 2841: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2837:
2838: IF (p_tcnv_rec.TMT_CONTRACT_UPDATED_YN IS NOT NULL) AND
2839: (p_tcnv_rec.TMT_CONTRACT_UPDATED_YN <> Okc_Api.G_MISS_CHAR) THEN
2840:
2841: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2842: (p_lookup_type => 'YES_NO',
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);

Line 2861: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2857:
2858: IF (p_tcnv_rec.TMT_RECYCLE_YN IS NOT NULL) AND
2859: (p_tcnv_rec.TMT_RECYCLE_YN <> Okc_Api.G_MISS_CHAR) THEN
2860:
2861: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2862: (p_lookup_type => 'YES_NO',
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);

Line 2881: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2877:
2878: IF (p_tcnv_rec.TMT_VALIDATED_YN IS NOT NULL) AND
2879: (p_tcnv_rec.TMT_VALIDATED_YN <> Okc_Api.G_MISS_CHAR) THEN
2880:
2881: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2882: (p_lookup_type => 'YES_NO',
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);

Line 2901: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2897:
2898: IF (p_tcnv_rec.TMT_STREAMS_UPDATED_YN IS NOT NULL) AND
2899: (p_tcnv_rec.TMT_STREAMS_UPDATED_YN <> Okc_Api.G_MISS_CHAR) THEN
2900:
2901: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
2902: (p_lookup_type => 'YES_NO',
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);

Line 2965: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

2961: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
2962:
2963: -- check in fnd_lookups for validity
2964: IF p_tcnv_rec.accrual_activity IS NOT NULL 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

Line 3121: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_SOURCE_TRX_TYPE',

3117: ,p_token1_value => 'SOURCE_TRX_ID');
3118: x_return_status := Okc_Api.G_RET_STS_ERROR;
3119: RAISE G_EXCEPTION_HALT_VALIDATION;
3120: ELSE
3121: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE(p_lookup_type => 'OKL_SOURCE_TRX_TYPE',
3122: p_lookup_code => p_tcnv_rec.source_trx_type);
3123:
3124: IF (l_dummy = Okc_Api.G_FALSE) THEN
3125: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 3284: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

3280:
3281: -- check for data before processing
3282: IF (p_tcnv_rec.tmt_status_code IS NOT NULL) AND (p_tcnv_rec.tmt_status_code <> OKC_API.G_MISS_CHAR) THEN
3283:
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

Line 3346: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE

3342: -- check for data before processing
3343: IF (p_tcnv_rec.UPGRADE_STATUS_FLAG IS NOT NULL) AND
3344: (p_tcnv_rec.UPGRADE_STATUS_FLAG <> Okc_Api.G_MISS_CHAR) THEN
3345: -- check in fnd_lookups for validity
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

Line 4957: -- x_tcnv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id;

4953: -- Commented by zrehman for SLA project (Bug 5707866) 21-Feb-2007
4954: -- The derivation for the column is moved to OKL_TRX_CONTRACTS_PVT which in turn is
4955: -- used to derive representation_name and representation_code
4956: -- start
4957: -- x_tcnv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id;
4958: -- end
4959:
4960: -- Added by nikshah for SLA project (Bug 5707866) 17-Apr-2007
4961: x_tcnv_rec.UPGRADE_STATUS_FLAG := 'N';

Line 4972: x_tcnv_rec.currency_code := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;

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
4976: WHEN OTHERS THEN l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;