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_SLA_ACC_SOURCES_PVT dependencies on FND_LOG_MESSAGES

Line 754: p_module IN fnd_log_messages.module%TYPE,

750: WHERE book_type_code = p_book_type_code;
751:
752: PROCEDURE write_to_log(
753: p_level IN VARCHAR2,
754: p_module IN fnd_log_messages.module%TYPE,
755: msg IN VARCHAR2 )
756: AS
757: -- l_level: S - Statement, P- Procedure, B - Both
758: BEGIN

Line 769: p_module IN fnd_log_messages.module%TYPE,

765: PROCEDURE put_in_log(
766: p_debug_enabled IN VARCHAR2,
767: is_debug_procedure_on IN BOOLEAN,
768: is_debug_statement_on IN BOOLEAN,
769: p_module IN fnd_log_messages.module%TYPE,
770: p_level IN VARCHAR2,
771: msg IN VARCHAR2 )
772: AS
773: -- l_level: S - Statement, P- Procedure, B - Both

Line 794: ,p_module IN fnd_log_messages.module%TYPE)

790:
791: PROCEDURE write_ext_hdr_to_log(
792: p_teh_rec IN okl_teh_pvt.teh_rec_type
793: ,p_tehl_tbl IN okl_teh_pvt.tehl_tbl_type
794: ,p_module IN fnd_log_messages.module%TYPE)
795: AS
796: tl_index NUMBER;
797: BEGIN
798: -- Print the Sources captured at extension Header Level

Line 870: ,p_module IN fnd_log_messages.module%TYPE)

866:
867: PROCEDURE write_ext_line_to_log(
868: p_tel_rec IN tel_rec_type
869: ,p_tell_tbl IN tell_tbl_type
870: ,p_module IN fnd_log_messages.module%TYPE)
871: AS
872: tl_index NUMBER;
873: BEGIN
874: -- Print the Sources captured at Extension Line Level

Line 994: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

990: l_res_ia_chr_id okc_k_headers_all_b.id%TYPE;
991: l_master_lease_id okc_k_headers_all_b.id%TYPE;
992: l_acc_sources_rec asev_rec_type;
993: -- Local Variables for enabling the Debug Statements
994: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
995: l_debug_enabled VARCHAR2(10);
996: is_debug_procedure_on BOOLEAN;
997: is_debug_statement_on BOOLEAN;
998: tl_sources_in NUMBER := 1;

Line 1642: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

1638: -- Local Variables
1639: i NUMBER := 0;
1640: tl_sources_in NUMBER := 1;
1641: -- Local Variables for enabling the Debug Statements
1642: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
1643: l_debug_enabled VARCHAR2(10);
1644: is_debug_procedure_on BOOLEAN;
1645: is_debug_statement_on BOOLEAN;
1646: BEGIN

Line 2215: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

2211: l_trans_line_tbl telv_tbl_type;
2212: l_fetch_sources BOOLEAN := FALSE;
2213:
2214: -- Local Variables for enabling the Debug Statements
2215: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
2216: l_debug_enabled VARCHAR2(10);
2217: is_debug_procedure_on BOOLEAN;
2218: is_debug_statement_on BOOLEAN;
2219: BEGIN

Line 2874: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

2870: l_acc_sources_tbl asev_tbl_type;
2871: l_trans_line_tbl telv_tbl_type; -- Added by PRASJAIN Bug#6134235
2872: x_trans_line_tbl telv_tbl_type; -- Added by PRASJAIN Bug#6134235
2873:
2874: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
2875: l_debug_enabled VARCHAR2(10);
2876: is_debug_procedure_on BOOLEAN;
2877: is_debug_statement_on BOOLEAN;
2878: BEGIN

Line 3051: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

3047: ,tel.source_table source_table
3048: FROM OKL_TXL_EXTENSION_B tel
3049: WHERE tel.teh_id = p_teh_id;
3050: -- Local Variables for enabling the Debug Statements
3051: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
3052: l_debug_enabled VARCHAR2(10);
3053: is_debug_procedure_on BOOLEAN;
3054: is_debug_statement_on BOOLEAN;
3055: BEGIN

Line 3205: ,p_module IN fnd_log_messages.module%TYPE)

3201: ------------------------------------------------------------------------------
3202:
3203: PROCEDURE write_khr_sources_to_log(
3204: p_khr_source_rec IN khr_source_rec_type
3205: ,p_module IN fnd_log_messages.module%TYPE)
3206: AS
3207: BEGIN
3208: write_to_log(FND_LOG.LEVEL_STATEMENT,p_module,'KHR_ID =' || p_khr_source_rec.KHR_ID );
3209: write_to_log(FND_LOG.LEVEL_STATEMENT,p_module,'CONTRACT_NUMBER =' || p_khr_source_rec.CONTRACT_NUMBER );

Line 3290: ,p_module IN fnd_log_messages.module%TYPE)

3286: ------------------------------------------------------------------------------
3287:
3288: PROCEDURE write_kle_sources_to_log(
3289: p_kle_source_rec IN kle_source_rec_type
3290: ,p_module IN fnd_log_messages.module%TYPE)
3291: AS
3292: BEGIN
3293: write_to_log(FND_LOG.LEVEL_STATEMENT,p_module,'KHR_ID =' || p_kle_source_rec.KHR_ID );
3294: write_to_log(FND_LOG.LEVEL_STATEMENT,p_module,'KLE_ID =' || p_kle_source_rec.KLE_ID );

Line 3510: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

3506:
3507: ----------------------------------------------------
3508: -- Local variables for enabling the debug statements
3509: ----------------------------------------------------
3510: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
3511: l_debug_enabled VARCHAR2(10);
3512: is_debug_procedure_on BOOLEAN;
3513: is_debug_statement_on BOOLEAN;
3514: BEGIN

Line 3857: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

3853:
3854: ----------------------------------------------------
3855: -- Local Variables for enabling the Debug Statements
3856: ----------------------------------------------------
3857: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
3858: l_debug_enabled VARCHAR2(10);
3859: is_debug_procedure_on BOOLEAN;
3860: is_debug_statement_on BOOLEAN;
3861: BEGIN

Line 4106: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

4102:
4103: -- Record structures based on the Cursor defintions
4104: l_sales_rep_csr_rec c_sales_rep_csr%ROWTYPE;
4105: -- Local Variables for enabling the Debug Statements
4106: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
4107: l_debug_enabled VARCHAR2(10);
4108: is_debug_procedure_on BOOLEAN;
4109: is_debug_statement_on BOOLEAN;
4110: tl_sources_in NUMBER := 1;

Line 4667: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

4663: ,fxl.source_table source_table
4664: FROM okl_ext_fa_line_sources_b fxl
4665: WHERE fxl.header_extension_id = p_hdr_ext_id;
4666: -- Local Variables for enabling the Debug Statements
4667: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
4668: l_debug_enabled VARCHAR2(10);
4669: is_debug_procedure_on BOOLEAN;
4670: is_debug_statement_on BOOLEAN;
4671: BEGIN

Line 5047: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

5043: l_led_lang_tbl led_lang_tbl_type;
5044: -- End : PRASJAIN : Bug# 6268782
5045: l_ledger_lang_rec c_ledger_lang_csr%ROWTYPE;
5046: -- Local Variables for enabling the Debug Statements
5047: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
5048: l_debug_enabled VARCHAR2(10);
5049: is_debug_procedure_on BOOLEAN;
5050: is_debug_statement_on BOOLEAN;
5051: tl_sources_in NUMBER := 1;

Line 5707: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

5703: l_rxhv_rec rxhv_rec_type;
5704: l_rxlv_rec rxlv_rec_type;
5705: l_rxlv_tbl rxlv_tbl_type;
5706: -- Local Variables for enabling the Debug Statements
5707: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
5708: l_debug_enabled VARCHAR2(10);
5709: is_debug_procedure_on BOOLEAN;
5710: is_debug_statement_on BOOLEAN;
5711: BEGIN

Line 6083: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

6079: ,rxl.source_table source_table
6080: FROM okl_ext_ar_line_sources_b rxl
6081: WHERE rxl.header_extension_id = p_hdr_ext_id;
6082: -- Local Variables for enabling the Debug Statements
6083: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
6084: l_debug_enabled VARCHAR2(10);
6085: is_debug_procedure_on BOOLEAN;
6086: is_debug_statement_on BOOLEAN;
6087: BEGIN

Line 6461: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

6457: l_led_lang_tbl led_lang_tbl_type;
6458:
6459: l_ledger_lang_rec c_ledger_lang_csr%ROWTYPE;
6460: -- Local Variables for enabling the Debug Statements
6461: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
6462: l_debug_enabled VARCHAR2(10);
6463: is_debug_procedure_on BOOLEAN;
6464: is_debug_statement_on BOOLEAN;
6465: tl_sources_in NUMBER := 1;

Line 7054: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

7050: l_pxhv_rec pxhv_rec_type;
7051: l_pxlv_rec pxlv_rec_type;
7052: l_pxlv_tbl pxlv_tbl_type;
7053: -- Local Variables for enabling the Debug Statements
7054: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
7055: l_debug_enabled VARCHAR2(10);
7056: is_debug_procedure_on BOOLEAN;
7057: is_debug_statement_on BOOLEAN;
7058: BEGIN

Line 7324: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

7320: ,pxl.source_table source_table
7321: FROM okl_ext_ap_line_sources_b pxl
7322: WHERE pxl.header_extension_id = p_hdr_ext_id;
7323: -- Local Variables for enabling the Debug Statements
7324: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
7325: l_debug_enabled VARCHAR2(10);
7326: is_debug_procedure_on BOOLEAN;
7327: is_debug_statement_on BOOLEAN;
7328: BEGIN

Line 7533: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

7529: -- Record structures based on the Cursor defintions
7530: l_sales_rep_csr_rec c_sales_rep_csr%ROWTYPE;
7531: l_ledger_lang_rec c_ledger_lang_csr%ROWTYPE;
7532: -- Local Variables for enabling the Debug Statements
7533: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
7534: l_debug_enabled VARCHAR2(10);
7535: is_debug_procedure_on BOOLEAN;
7536: is_debug_statement_on BOOLEAN;
7537: tl_sources_in NUMBER := 1;

Line 8572: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;

8568: l_api_version CONSTANT NUMBER := 1;
8569: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SOURCES-RECEIPT';
8570: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
8571: -- Local Variables for enabling the Debug Statements
8572: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
8573: l_debug_enabled VARCHAR2(10);
8574: is_debug_procedure_on BOOLEAN;
8575: is_debug_statement_on BOOLEAN;
8576: -----------------------------------------------------------------