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 459: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);

455: RAISE Okl_Api.G_EXCEPTION_ERROR;
456: END IF;
457: CLOSE Transaction_Type_csr;
458:
459: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
460: FETCH fnd_lookups_csr INTO l_fnd_rec;
461: IF fnd_lookups_csr%NOTFOUND THEN
462: CLOSE fnd_lookups_csr;
463: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');

Line 460: FETCH fnd_lookups_csr INTO l_fnd_rec;

456: END IF;
457: CLOSE Transaction_Type_csr;
458:
459: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
460: FETCH fnd_lookups_csr INTO l_fnd_rec;
461: IF fnd_lookups_csr%NOTFOUND THEN
462: CLOSE fnd_lookups_csr;
463: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
464: FETCH fnd_lookups_csr INTO l_fnd_rec;

Line 461: IF fnd_lookups_csr%NOTFOUND THEN

457: CLOSE Transaction_Type_csr;
458:
459: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
460: FETCH fnd_lookups_csr INTO l_fnd_rec;
461: IF fnd_lookups_csr%NOTFOUND THEN
462: CLOSE fnd_lookups_csr;
463: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
464: FETCH fnd_lookups_csr INTO l_fnd_rec;
465: IF fnd_lookups_csr%NOTFOUND THEN

Line 462: CLOSE fnd_lookups_csr;

458:
459: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
460: FETCH fnd_lookups_csr INTO l_fnd_rec;
461: IF fnd_lookups_csr%NOTFOUND THEN
462: CLOSE fnd_lookups_csr;
463: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
464: FETCH fnd_lookups_csr INTO l_fnd_rec;
465: IF fnd_lookups_csr%NOTFOUND THEN
466: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);

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

459: OPEN fnd_lookups_csr('OKL_TCN_TYPE', l_transaction_type);
460: FETCH fnd_lookups_csr INTO l_fnd_rec;
461: IF fnd_lookups_csr%NOTFOUND THEN
462: CLOSE fnd_lookups_csr;
463: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
464: FETCH fnd_lookups_csr INTO l_fnd_rec;
465: IF fnd_lookups_csr%NOTFOUND THEN
466: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
467: CLOSE fnd_lookups_csr;

Line 464: FETCH fnd_lookups_csr INTO l_fnd_rec;

460: FETCH fnd_lookups_csr INTO l_fnd_rec;
461: IF fnd_lookups_csr%NOTFOUND THEN
462: CLOSE fnd_lookups_csr;
463: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
464: FETCH fnd_lookups_csr INTO l_fnd_rec;
465: IF fnd_lookups_csr%NOTFOUND THEN
466: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
467: CLOSE fnd_lookups_csr;
468: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 465: IF fnd_lookups_csr%NOTFOUND THEN

461: IF fnd_lookups_csr%NOTFOUND THEN
462: CLOSE fnd_lookups_csr;
463: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
464: FETCH fnd_lookups_csr INTO l_fnd_rec;
465: IF fnd_lookups_csr%NOTFOUND THEN
466: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
467: CLOSE fnd_lookups_csr;
468: RAISE Okl_Api.G_EXCEPTION_ERROR;
469: End If;

Line 467: CLOSE fnd_lookups_csr;

463: OPEN fnd_lookups_csr('OKL_TCN_TYPE', 'Miscellaneous');
464: FETCH fnd_lookups_csr INTO l_fnd_rec;
465: IF fnd_lookups_csr%NOTFOUND THEN
466: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN, l_transaction_type);
467: CLOSE fnd_lookups_csr;
468: RAISE Okl_Api.G_EXCEPTION_ERROR;
469: End If;
470: END IF;
471: CLOSE fnd_lookups_csr;

Line 471: CLOSE fnd_lookups_csr;

467: CLOSE fnd_lookups_csr;
468: RAISE Okl_Api.G_EXCEPTION_ERROR;
469: End If;
470: END IF;
471: CLOSE fnd_lookups_csr;
472:
473: OPEN trx_csr(p_contract_id,l_fnd_rec.lookup_code);
474: FETCH trx_csr INTO l_trx_rec;
475: IF (l_fnd_rec.lookup_code = 'TRBK') THEN -- For Rebook, create a new trans always

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

535: l_tcl_type := l_transaction_type;
536: End If;
537: --Bug# 5964482
538:
539: --OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
540: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_tcl_type);
541: FETCH fnd_lookups_csr INTO l_fnd_rec1;
542: IF fnd_lookups_csr%NOTFOUND THEN
543: l_trxL_in_rec.tcl_type := 'MAE';

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

536: End If;
537: --Bug# 5964482
538:
539: --OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
540: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_tcl_type);
541: FETCH fnd_lookups_csr INTO l_fnd_rec1;
542: IF fnd_lookups_csr%NOTFOUND THEN
543: l_trxL_in_rec.tcl_type := 'MAE';
544: Else

Line 541: FETCH fnd_lookups_csr INTO l_fnd_rec1;

537: --Bug# 5964482
538:
539: --OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
540: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_tcl_type);
541: FETCH fnd_lookups_csr INTO l_fnd_rec1;
542: IF fnd_lookups_csr%NOTFOUND THEN
543: l_trxL_in_rec.tcl_type := 'MAE';
544: Else
545: l_trxL_in_rec.tcl_type := l_fnd_rec1.lookup_code;

Line 542: IF fnd_lookups_csr%NOTFOUND THEN

538:
539: --OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_transaction_type);
540: OPEN fnd_lookups_csr('OKL_TCL_TYPE', l_tcl_type);
541: FETCH fnd_lookups_csr INTO l_fnd_rec1;
542: IF fnd_lookups_csr%NOTFOUND THEN
543: l_trxL_in_rec.tcl_type := 'MAE';
544: Else
545: l_trxL_in_rec.tcl_type := l_fnd_rec1.lookup_code;
546: END IF;

Line 547: CLOSE fnd_lookups_csr;

543: l_trxL_in_rec.tcl_type := 'MAE';
544: Else
545: l_trxL_in_rec.tcl_type := l_fnd_rec1.lookup_code;
546: END IF;
547: CLOSE fnd_lookups_csr;
548:
549: If ( l_has_trans = OKL_API.G_FALSE ) Then
550:
551: If (UPPER(l_fnd_rec.lookup_code) = 'TRBK') THEN

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

552: l_trxH_in_rec.rbr_code := ''; -- lokup 'OKL_REBOOK_REASON'
553: l_trxH_in_rec.rpy_code := ''; -- lokup 'OKL_REBOOK_PROCESS_TYPE'
554: End If;
555:
556: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
557: FETCH fnd_lookups_csr INTO l_fnd_rec;
558: IF fnd_lookups_csr%NOTFOUND THEN
559: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
560: CLOSE fnd_lookups_csr;

Line 557: FETCH fnd_lookups_csr INTO l_fnd_rec;

553: l_trxH_in_rec.rpy_code := ''; -- lokup 'OKL_REBOOK_PROCESS_TYPE'
554: End If;
555:
556: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
557: FETCH fnd_lookups_csr INTO l_fnd_rec;
558: IF fnd_lookups_csr%NOTFOUND THEN
559: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
560: CLOSE fnd_lookups_csr;
561: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 558: IF fnd_lookups_csr%NOTFOUND THEN

554: End If;
555:
556: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
557: FETCH fnd_lookups_csr INTO l_fnd_rec;
558: IF fnd_lookups_csr%NOTFOUND THEN
559: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
560: CLOSE fnd_lookups_csr;
561: RAISE Okl_Api.G_EXCEPTION_ERROR;
562: END IF;

Line 560: CLOSE fnd_lookups_csr;

556: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Submitted');
557: FETCH fnd_lookups_csr INTO l_fnd_rec;
558: IF fnd_lookups_csr%NOTFOUND THEN
559: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
560: CLOSE fnd_lookups_csr;
561: RAISE Okl_Api.G_EXCEPTION_ERROR;
562: END IF;
563: CLOSE fnd_lookups_csr;
564:

Line 563: CLOSE fnd_lookups_csr;

559: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
560: CLOSE fnd_lookups_csr;
561: RAISE Okl_Api.G_EXCEPTION_ERROR;
562: END IF;
563: CLOSE fnd_lookups_csr;
564:
565: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
566:
567: l_trxH_in_rec.date_transaction_occurred := l_transaction_date;

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

949:
950: --l_trxL_in_rec.id := l_dist_info_rec.source_id;
951: ----Bug# 5964482 : End of Comments */
952:
953: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
954: FETCH fnd_lookups_csr INTO l_fnd_rec;
955: IF fnd_lookups_csr%NOTFOUND THEN
956: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
957: CLOSE fnd_lookups_csr;

Line 954: FETCH fnd_lookups_csr INTO l_fnd_rec;

950: --l_trxL_in_rec.id := l_dist_info_rec.source_id;
951: ----Bug# 5964482 : End of Comments */
952:
953: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
954: FETCH fnd_lookups_csr INTO l_fnd_rec;
955: IF fnd_lookups_csr%NOTFOUND THEN
956: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
957: CLOSE fnd_lookups_csr;
958: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 955: IF fnd_lookups_csr%NOTFOUND THEN

951: ----Bug# 5964482 : End of Comments */
952:
953: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
954: FETCH fnd_lookups_csr INTO l_fnd_rec;
955: IF fnd_lookups_csr%NOTFOUND THEN
956: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
957: CLOSE fnd_lookups_csr;
958: RAISE Okl_Api.G_EXCEPTION_ERROR;
959: END IF;

Line 957: CLOSE fnd_lookups_csr;

953: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
954: FETCH fnd_lookups_csr INTO l_fnd_rec;
955: IF fnd_lookups_csr%NOTFOUND THEN
956: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
957: CLOSE fnd_lookups_csr;
958: RAISE Okl_Api.G_EXCEPTION_ERROR;
959: END IF;
960: CLOSE fnd_lookups_csr;
961:

Line 960: CLOSE fnd_lookups_csr;

956: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
957: CLOSE fnd_lookups_csr;
958: RAISE Okl_Api.G_EXCEPTION_ERROR;
959: END IF;
960: CLOSE fnd_lookups_csr;
961:
962: --From the l_amount_out_tbl returned , the transaction line amount and header amount need to be updated back on the contract
963: l_tclv_tbl := x_tclv_tbl;
964: l_tcnv_rec := l_trxH_out_rec;

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

1032: l_trxH_in_rec.amount := l_trxH_in_rec.amount + l_amount_tbl(i);
1033: END LOOP;
1034: l_trxH_in_rec.currency_code := l_currency_code;
1035:
1036: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1037: FETCH fnd_lookups_csr INTO l_fnd_rec;
1038: IF fnd_lookups_csr%NOTFOUND THEN
1039: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1040: CLOSE fnd_lookups_csr;

Line 1037: FETCH fnd_lookups_csr INTO l_fnd_rec;

1033: END LOOP;
1034: l_trxH_in_rec.currency_code := l_currency_code;
1035:
1036: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1037: FETCH fnd_lookups_csr INTO l_fnd_rec;
1038: IF fnd_lookups_csr%NOTFOUND THEN
1039: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1040: CLOSE fnd_lookups_csr;
1041: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1038: IF fnd_lookups_csr%NOTFOUND THEN

1034: l_trxH_in_rec.currency_code := l_currency_code;
1035:
1036: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Processed');
1037: FETCH fnd_lookups_csr INTO l_fnd_rec;
1038: IF fnd_lookups_csr%NOTFOUND THEN
1039: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1040: CLOSE fnd_lookups_csr;
1041: RAISE Okl_Api.G_EXCEPTION_ERROR;
1042: END IF;

Line 1040: CLOSE fnd_lookups_csr;

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

Line 1043: CLOSE fnd_lookups_csr;

1039: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1040: CLOSE fnd_lookups_csr;
1041: RAISE Okl_Api.G_EXCEPTION_ERROR;
1042: END IF;
1043: CLOSE fnd_lookups_csr;
1044: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
1045:
1046: l_trxL_in_rec.amount := 0;
1047: FOR i in 1..l_amount_tbl.COUNT

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

1052:
1053:
1054: Else
1055:
1056: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
1057: FETCH fnd_lookups_csr INTO l_fnd_rec;
1058: IF fnd_lookups_csr%NOTFOUND THEN
1059: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1060: CLOSE fnd_lookups_csr;

Line 1057: FETCH fnd_lookups_csr INTO l_fnd_rec;

1053:
1054: Else
1055:
1056: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
1057: FETCH fnd_lookups_csr INTO l_fnd_rec;
1058: IF fnd_lookups_csr%NOTFOUND THEN
1059: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1060: CLOSE fnd_lookups_csr;
1061: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1058: IF fnd_lookups_csr%NOTFOUND THEN

1054: Else
1055:
1056: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
1057: FETCH fnd_lookups_csr INTO l_fnd_rec;
1058: IF fnd_lookups_csr%NOTFOUND THEN
1059: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1060: CLOSE fnd_lookups_csr;
1061: RAISE Okl_Api.G_EXCEPTION_ERROR;
1062: END IF;

Line 1060: CLOSE fnd_lookups_csr;

1056: OPEN fnd_lookups_csr('OKL_TRANSACTION_STATUS', 'Error');
1057: FETCH fnd_lookups_csr INTO l_fnd_rec;
1058: IF fnd_lookups_csr%NOTFOUND THEN
1059: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1060: CLOSE fnd_lookups_csr;
1061: RAISE Okl_Api.G_EXCEPTION_ERROR;
1062: END IF;
1063: CLOSE fnd_lookups_csr;
1064: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;

Line 1063: CLOSE fnd_lookups_csr;

1059: Okl_Api.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,l_transaction_type);
1060: CLOSE fnd_lookups_csr;
1061: RAISE Okl_Api.G_EXCEPTION_ERROR;
1062: END IF;
1063: CLOSE fnd_lookups_csr;
1064: l_trxH_in_rec.tsu_code := l_fnd_rec.lookup_code;
1065: l_trxH_in_rec.amount := null;
1066:
1067: l_trxL_in_rec.amount := null;