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_LA_JE_PVT dependencies on FND_LOOKUPS

Line 225: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS

221: FROM okl_trx_types_tl
222: WHERE name = p_transaction_type
223: AND language = 'US';
224:
225: CURSOR fnd_lookups_csr( lkp_type VARCHAR2, mng VARCHAR2 ) IS
226: select description,
227: lookup_code
228: from fnd_lookup_values
229: where language = 'US'

Line 247: l_fnd_rec fnd_lookups_csr%ROWTYPE;

243:
244: -- Cursor Types
245: l_Product_rec Product_csr%ROWTYPE;
246: l_Trx_Type_rec Transaction_Type_csr%ROWTYPE;
247: l_fnd_rec fnd_lookups_csr%ROWTYPE;
248: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;
249: l_trx_rec trx_csr%ROWTYPE;
250:
251:

Line 248: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;

244: -- Cursor Types
245: l_Product_rec Product_csr%ROWTYPE;
246: l_Trx_Type_rec Transaction_Type_csr%ROWTYPE;
247: l_fnd_rec fnd_lookups_csr%ROWTYPE;
248: l_fnd_rec1 fnd_lookups_csr%ROWTYPE;
249: l_trx_rec trx_csr%ROWTYPE;
250:
251:
252: l_isJrnlGenAllowed BOOLEAN := TRUE;

Line 275: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;

271: lx_upd_trxH_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
272: --Bug# 3153003
273:
274: --Bug# 4622198
275: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
276: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
277: --Bug# 4622198
278:
279: --Added by dpsingh for LE uptake

Line 505: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);

501: RAISE Okl_Api.G_EXCEPTION_ERROR;
502: END IF;
503: CLOSE Transaction_Type_csr;
504:
505: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
506: FETCH fnd_lookups_csr INTO l_fnd_rec;
507: IF fnd_lookups_csr%NOTFOUND THEN
508: CLOSE fnd_lookups_csr;
509: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');

Line 506: FETCH fnd_lookups_csr INTO l_fnd_rec;

502: END IF;
503: CLOSE Transaction_Type_csr;
504:
505: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
506: FETCH fnd_lookups_csr INTO l_fnd_rec;
507: IF fnd_lookups_csr%NOTFOUND THEN
508: CLOSE fnd_lookups_csr;
509: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
510: FETCH fnd_lookups_csr INTO l_fnd_rec;

Line 507: IF fnd_lookups_csr%NOTFOUND THEN

503: CLOSE Transaction_Type_csr;
504:
505: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
506: FETCH fnd_lookups_csr INTO l_fnd_rec;
507: IF fnd_lookups_csr%NOTFOUND THEN
508: CLOSE fnd_lookups_csr;
509: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
510: FETCH fnd_lookups_csr INTO l_fnd_rec;
511: IF fnd_lookups_csr%NOTFOUND THEN

Line 508: CLOSE fnd_lookups_csr;

504:
505: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
506: FETCH fnd_lookups_csr INTO l_fnd_rec;
507: IF fnd_lookups_csr%NOTFOUND THEN
508: CLOSE fnd_lookups_csr;
509: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
510: FETCH fnd_lookups_csr INTO l_fnd_rec;
511: IF fnd_lookups_csr%NOTFOUND THEN
512: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);

Line 509: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');

505: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
506: FETCH fnd_lookups_csr INTO l_fnd_rec;
507: IF fnd_lookups_csr%NOTFOUND THEN
508: CLOSE fnd_lookups_csr;
509: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
510: FETCH fnd_lookups_csr INTO l_fnd_rec;
511: IF fnd_lookups_csr%NOTFOUND THEN
512: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
513: CLOSE fnd_lookups_csr;

Line 510: FETCH fnd_lookups_csr INTO l_fnd_rec;

506: FETCH fnd_lookups_csr INTO l_fnd_rec;
507: IF fnd_lookups_csr%NOTFOUND THEN
508: CLOSE fnd_lookups_csr;
509: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
510: FETCH fnd_lookups_csr INTO l_fnd_rec;
511: IF fnd_lookups_csr%NOTFOUND THEN
512: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
513: CLOSE fnd_lookups_csr;
514: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 511: IF fnd_lookups_csr%NOTFOUND THEN

507: IF fnd_lookups_csr%NOTFOUND THEN
508: CLOSE fnd_lookups_csr;
509: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
510: FETCH fnd_lookups_csr INTO l_fnd_rec;
511: IF fnd_lookups_csr%NOTFOUND THEN
512: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
513: CLOSE fnd_lookups_csr;
514: RAISE Okl_Api.G_EXCEPTION_ERROR;
515: End If;

Line 513: CLOSE fnd_lookups_csr;

509: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
510: FETCH fnd_lookups_csr INTO l_fnd_rec;
511: IF fnd_lookups_csr%NOTFOUND THEN
512: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
513: CLOSE fnd_lookups_csr;
514: RAISE Okl_Api.G_EXCEPTION_ERROR;
515: End If;
516: END IF;
517: CLOSE fnd_lookups_csr;

Line 517: CLOSE fnd_lookups_csr;

513: CLOSE fnd_lookups_csr;
514: RAISE Okl_Api.G_EXCEPTION_ERROR;
515: End If;
516: END IF;
517: CLOSE fnd_lookups_csr;
518:
519: OPEN trx_csr(p_contract_id,l_fnd_rec.lookup_code);
520: FETCH trx_csr INTO l_trx_rec;
521: IF (l_fnd_rec.lookup_code = 'TRBK') THEN -- For Rebook, create a new trans always

Line 585: --OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);

581: l_tcl_type := l_transaction_type;
582: End If;
583: --Bug# 5964482
584:
585: --OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
586: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_tcl_type);
587: FETCH fnd_lookups_csr INTO l_fnd_rec1;
588: IF fnd_lookups_csr%NOTFOUND THEN
589: l_trxL_in_rec.tcl_type := 'MAE';

Line 586: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_tcl_type);

582: End If;
583: --Bug# 5964482
584:
585: --OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
586: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_tcl_type);
587: FETCH fnd_lookups_csr INTO l_fnd_rec1;
588: IF fnd_lookups_csr%NOTFOUND THEN
589: l_trxL_in_rec.tcl_type := 'MAE';
590: Else

Line 587: FETCH fnd_lookups_csr INTO l_fnd_rec1;

583: --Bug# 5964482
584:
585: --OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
586: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_tcl_type);
587: FETCH fnd_lookups_csr INTO l_fnd_rec1;
588: IF fnd_lookups_csr%NOTFOUND THEN
589: l_trxL_in_rec.tcl_type := 'MAE';
590: Else
591: l_trxL_in_rec.tcl_type := l_fnd_rec1.lookup_code;

Line 588: IF fnd_lookups_csr%NOTFOUND THEN

584:
585: --OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
586: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_tcl_type);
587: FETCH fnd_lookups_csr INTO l_fnd_rec1;
588: IF fnd_lookups_csr%NOTFOUND THEN
589: l_trxL_in_rec.tcl_type := 'MAE';
590: Else
591: l_trxL_in_rec.tcl_type := l_fnd_rec1.lookup_code;
592: END IF;

Line 593: CLOSE fnd_lookups_csr;

589: l_trxL_in_rec.tcl_type := 'MAE';
590: Else
591: l_trxL_in_rec.tcl_type := l_fnd_rec1.lookup_code;
592: END IF;
593: CLOSE fnd_lookups_csr;
594:
595: If ( l_has_trans = OKL_API.G_FALSE ) Then
596:
597: If (UPPER(l_fnd_rec.lookup_code) = 'TRBK') THEN

Line 602: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');

598: l_trxH_in_rec.rbr_code := ''; -- lokup 'OKL_REBOOK_REASON'
599: l_trxH_in_rec.rpy_code := ''; -- lokup 'OKL_REBOOK_PROCESS_TYPE'
600: End If;
601:
602: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
603: FETCH fnd_lookups_csr INTO l_fnd_rec;
604: IF fnd_lookups_csr%NOTFOUND THEN
605: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
606: CLOSE fnd_lookups_csr;

Line 603: FETCH fnd_lookups_csr INTO l_fnd_rec;

599: l_trxH_in_rec.rpy_code := ''; -- lokup 'OKL_REBOOK_PROCESS_TYPE'
600: End If;
601:
602: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
603: FETCH fnd_lookups_csr INTO l_fnd_rec;
604: IF fnd_lookups_csr%NOTFOUND THEN
605: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
606: CLOSE fnd_lookups_csr;
607: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 604: IF fnd_lookups_csr%NOTFOUND THEN

600: End If;
601:
602: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
603: FETCH fnd_lookups_csr INTO l_fnd_rec;
604: IF fnd_lookups_csr%NOTFOUND THEN
605: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
606: CLOSE fnd_lookups_csr;
607: RAISE Okl_Api.G_EXCEPTION_ERROR;
608: END IF;

Line 606: CLOSE fnd_lookups_csr;

602: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
603: FETCH fnd_lookups_csr INTO l_fnd_rec;
604: IF fnd_lookups_csr%NOTFOUND THEN
605: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
606: CLOSE fnd_lookups_csr;
607: RAISE Okl_Api.G_EXCEPTION_ERROR;
608: END IF;
609: CLOSE fnd_lookups_csr;
610:

Line 609: CLOSE fnd_lookups_csr;

605: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
606: CLOSE fnd_lookups_csr;
607: RAISE Okl_Api.G_EXCEPTION_ERROR;
608: END IF;
609: CLOSE fnd_lookups_csr;
610:
611: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
612:
613: l_trxH_in_rec.date_transaction_occurred := l_transaction_date;

Line 1037: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');

1033:
1034: --l_trxL_in_rec.id := l_dist_info_rec.source_id;
1035: ----Bug# 5964482 : End of Comments */
1036:
1037: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1038: FETCH fnd_lookups_csr INTO l_fnd_rec;
1039: IF fnd_lookups_csr%NOTFOUND THEN
1040: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1041: CLOSE fnd_lookups_csr;

Line 1038: FETCH fnd_lookups_csr INTO l_fnd_rec;

1034: --l_trxL_in_rec.id := l_dist_info_rec.source_id;
1035: ----Bug# 5964482 : End of Comments */
1036:
1037: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1038: FETCH fnd_lookups_csr INTO l_fnd_rec;
1039: IF fnd_lookups_csr%NOTFOUND THEN
1040: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1041: CLOSE fnd_lookups_csr;
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1039: IF fnd_lookups_csr%NOTFOUND THEN

1035: ----Bug# 5964482 : End of Comments */
1036:
1037: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1038: FETCH fnd_lookups_csr INTO l_fnd_rec;
1039: IF fnd_lookups_csr%NOTFOUND THEN
1040: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1041: CLOSE fnd_lookups_csr;
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;

Line 1041: CLOSE fnd_lookups_csr;

1037: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1038: FETCH fnd_lookups_csr INTO l_fnd_rec;
1039: IF fnd_lookups_csr%NOTFOUND THEN
1040: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1041: CLOSE fnd_lookups_csr;
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044: CLOSE fnd_lookups_csr;
1045:

Line 1044: CLOSE fnd_lookups_csr;

1040: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1041: CLOSE fnd_lookups_csr;
1042: RAISE Okl_Api.G_EXCEPTION_ERROR;
1043: END IF;
1044: CLOSE fnd_lookups_csr;
1045:
1046: --From the l_amount_out_tbl returned , the transaction line amount and header amount need to be updated back on the contract
1047: l_tclv_tbl := x_tclv_tbl;
1048: l_tcnv_rec := l_trxH_out_rec;

Line 1120: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');

1116: l_trxH_in_rec.amount := l_trxH_in_rec.amount + l_amount_tbl(i);
1117: END LOOP;
1118: l_trxH_in_rec.currency_code := l_currency_code;
1119:
1120: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1121: FETCH fnd_lookups_csr INTO l_fnd_rec;
1122: IF fnd_lookups_csr%NOTFOUND THEN
1123: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1124: CLOSE fnd_lookups_csr;

Line 1121: FETCH fnd_lookups_csr INTO l_fnd_rec;

1117: END LOOP;
1118: l_trxH_in_rec.currency_code := l_currency_code;
1119:
1120: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1121: FETCH fnd_lookups_csr INTO l_fnd_rec;
1122: IF fnd_lookups_csr%NOTFOUND THEN
1123: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1124: CLOSE fnd_lookups_csr;
1125: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1122: IF fnd_lookups_csr%NOTFOUND THEN

1118: l_trxH_in_rec.currency_code := l_currency_code;
1119:
1120: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1121: FETCH fnd_lookups_csr INTO l_fnd_rec;
1122: IF fnd_lookups_csr%NOTFOUND THEN
1123: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1124: CLOSE fnd_lookups_csr;
1125: RAISE Okl_Api.G_EXCEPTION_ERROR;
1126: END IF;

Line 1124: CLOSE fnd_lookups_csr;

1120: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1121: FETCH fnd_lookups_csr INTO l_fnd_rec;
1122: IF fnd_lookups_csr%NOTFOUND THEN
1123: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1124: CLOSE fnd_lookups_csr;
1125: RAISE Okl_Api.G_EXCEPTION_ERROR;
1126: END IF;
1127: CLOSE fnd_lookups_csr;
1128: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;

Line 1127: CLOSE fnd_lookups_csr;

1123: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1124: CLOSE fnd_lookups_csr;
1125: RAISE Okl_Api.G_EXCEPTION_ERROR;
1126: END IF;
1127: CLOSE fnd_lookups_csr;
1128: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
1129:
1130: l_trxL_in_rec.amount := 0;
1131: FOR i in 1..l_amount_tbl.COUNT

Line 1140: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');

1136:
1137:
1138: Else
1139:
1140: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
1141: FETCH fnd_lookups_csr INTO l_fnd_rec;
1142: IF fnd_lookups_csr%NOTFOUND THEN
1143: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1144: CLOSE fnd_lookups_csr;

Line 1141: FETCH fnd_lookups_csr INTO l_fnd_rec;

1137:
1138: Else
1139:
1140: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
1141: FETCH fnd_lookups_csr INTO l_fnd_rec;
1142: IF fnd_lookups_csr%NOTFOUND THEN
1143: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1144: CLOSE fnd_lookups_csr;
1145: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1142: IF fnd_lookups_csr%NOTFOUND THEN

1138: Else
1139:
1140: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
1141: FETCH fnd_lookups_csr INTO l_fnd_rec;
1142: IF fnd_lookups_csr%NOTFOUND THEN
1143: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1144: CLOSE fnd_lookups_csr;
1145: RAISE Okl_Api.G_EXCEPTION_ERROR;
1146: END IF;

Line 1144: CLOSE fnd_lookups_csr;

1140: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
1141: FETCH fnd_lookups_csr INTO l_fnd_rec;
1142: IF fnd_lookups_csr%NOTFOUND THEN
1143: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1144: CLOSE fnd_lookups_csr;
1145: RAISE Okl_Api.G_EXCEPTION_ERROR;
1146: END IF;
1147: CLOSE fnd_lookups_csr;
1148: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;

Line 1147: CLOSE fnd_lookups_csr;

1143: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1144: CLOSE fnd_lookups_csr;
1145: RAISE Okl_Api.G_EXCEPTION_ERROR;
1146: END IF;
1147: CLOSE fnd_lookups_csr;
1148: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
1149: l_trxH_in_rec.amount := null;
1150:
1151: l_trxL_in_rec.amount := null;