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 781: p_module IN fnd_log_messages.module%TYPE,

777: WHERE book_type_code = p_book_type_code;
778:
779: PROCEDURE write_to_log(
780: p_level IN VARCHAR2,
781: p_module IN fnd_log_messages.module%TYPE,
782: msg IN VARCHAR2 )
783: AS
784: -- l_level: S - Statement, P- Procedure, B - Both
785: BEGIN

Line 796: p_module IN fnd_log_messages.module%TYPE,

792: PROCEDURE put_in_log(
793: p_debug_enabled IN VARCHAR2,
794: is_debug_procedure_on IN BOOLEAN,
795: is_debug_statement_on IN BOOLEAN,
796: p_module IN fnd_log_messages.module%TYPE,
797: p_level IN VARCHAR2,
798: msg IN VARCHAR2 )
799: AS
800: -- l_level: S - Statement, P- Procedure, B - Both

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

817:
818: PROCEDURE write_ext_hdr_to_log(
819: p_teh_rec IN okl_teh_pvt.teh_rec_type
820: ,p_tehl_tbl IN okl_teh_pvt.tehl_tbl_type
821: ,p_module IN fnd_log_messages.module%TYPE)
822: AS
823: tl_index NUMBER;
824: BEGIN
825: -- Print the Sources captured at extension Header Level

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

893:
894: PROCEDURE write_ext_line_to_log(
895: p_tel_rec IN tel_rec_type
896: ,p_tell_tbl IN tell_tbl_type
897: ,p_module IN fnd_log_messages.module%TYPE)
898: AS
899: tl_index NUMBER;
900: BEGIN
901: -- Print the Sources captured at Extension Line Level

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

1017: l_res_ia_chr_id okc_k_headers_all_b.id%TYPE;
1018: l_master_lease_id okc_k_headers_all_b.id%TYPE;
1019: l_acc_sources_rec asev_rec_type;
1020: -- Local Variables for enabling the Debug Statements
1021: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
1022: l_debug_enabled VARCHAR2(10);
1023: is_debug_procedure_on BOOLEAN;
1024: is_debug_statement_on BOOLEAN;
1025: tl_sources_in NUMBER := 1;

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

1665: -- Local Variables
1666: i NUMBER := 0;
1667: tl_sources_in NUMBER := 1;
1668: -- Local Variables for enabling the Debug Statements
1669: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
1670: l_debug_enabled VARCHAR2(10);
1671: is_debug_procedure_on BOOLEAN;
1672: is_debug_statement_on BOOLEAN;
1673: BEGIN

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

2238: l_trans_line_tbl telv_tbl_type;
2239: l_fetch_sources BOOLEAN := FALSE;
2240:
2241: -- Local Variables for enabling the Debug Statements
2242: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
2243: l_debug_enabled VARCHAR2(10);
2244: is_debug_procedure_on BOOLEAN;
2245: is_debug_statement_on BOOLEAN;
2246: BEGIN

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

2897: l_acc_sources_tbl asev_tbl_type;
2898: l_trans_line_tbl telv_tbl_type; -- Added by PRASJAIN Bug#6134235
2899: x_trans_line_tbl telv_tbl_type; -- Added by PRASJAIN Bug#6134235
2900:
2901: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
2902: l_debug_enabled VARCHAR2(10);
2903: is_debug_procedure_on BOOLEAN;
2904: is_debug_statement_on BOOLEAN;
2905: BEGIN

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

3074: ,tel.source_table source_table
3075: FROM OKL_TXL_EXTENSION_B tel
3076: WHERE tel.teh_id = p_teh_id;
3077: -- Local Variables for enabling the Debug Statements
3078: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
3079: l_debug_enabled VARCHAR2(10);
3080: is_debug_procedure_on BOOLEAN;
3081: is_debug_statement_on BOOLEAN;
3082: BEGIN

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

3228: ------------------------------------------------------------------------------
3229:
3230: PROCEDURE write_khr_sources_to_log(
3231: p_khr_source_rec IN khr_source_rec_type
3232: ,p_module IN fnd_log_messages.module%TYPE)
3233: AS
3234: BEGIN
3235: write_to_log(FND_LOG.LEVEL_STATEMENT,p_module,'KHR_ID =' || p_khr_source_rec.KHR_ID );
3236: write_to_log(FND_LOG.LEVEL_STATEMENT,p_module,'CONTRACT_NUMBER =' || p_khr_source_rec.CONTRACT_NUMBER );

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

3313: ------------------------------------------------------------------------------
3314:
3315: PROCEDURE write_kle_sources_to_log(
3316: p_kle_source_rec IN kle_source_rec_type
3317: ,p_module IN fnd_log_messages.module%TYPE)
3318: AS
3319: BEGIN
3320: write_to_log(FND_LOG.LEVEL_STATEMENT,p_module,'KHR_ID =' || p_kle_source_rec.KHR_ID );
3321: write_to_log(FND_LOG.LEVEL_STATEMENT,p_module,'KLE_ID =' || p_kle_source_rec.KLE_ID );

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

3533:
3534: ----------------------------------------------------
3535: -- Local variables for enabling the debug statements
3536: ----------------------------------------------------
3537: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
3538: l_debug_enabled VARCHAR2(10);
3539: is_debug_procedure_on BOOLEAN;
3540: is_debug_statement_on BOOLEAN;
3541: BEGIN

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

3912:
3913: ----------------------------------------------------
3914: -- Local Variables for enabling the Debug Statements
3915: ----------------------------------------------------
3916: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
3917: l_debug_enabled VARCHAR2(10);
3918: is_debug_procedure_on BOOLEAN;
3919: is_debug_statement_on BOOLEAN;
3920: BEGIN

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

4161:
4162: -- Record structures based on the Cursor defintions
4163: l_sales_rep_csr_rec c_sales_rep_csr%ROWTYPE;
4164: -- Local Variables for enabling the Debug Statements
4165: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
4166: l_debug_enabled VARCHAR2(10);
4167: is_debug_procedure_on BOOLEAN;
4168: is_debug_statement_on BOOLEAN;
4169: tl_sources_in NUMBER := 1;

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

4772: ,fxl.source_table source_table
4773: FROM okl_ext_fa_line_sources_b fxl
4774: WHERE fxl.header_extension_id = p_hdr_ext_id;
4775: -- Local Variables for enabling the Debug Statements
4776: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
4777: l_debug_enabled VARCHAR2(10);
4778: is_debug_procedure_on BOOLEAN;
4779: is_debug_statement_on BOOLEAN;
4780: BEGIN

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

5153: l_led_lang_tbl led_lang_tbl_type;
5154: -- End : PRASJAIN : Bug# 6268782
5155: l_ledger_lang_rec c_ledger_lang_csr%ROWTYPE;
5156: -- Local Variables for enabling the Debug Statements
5157: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
5158: l_debug_enabled VARCHAR2(10);
5159: is_debug_procedure_on BOOLEAN;
5160: is_debug_statement_on BOOLEAN;
5161: tl_sources_in NUMBER := 1;

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

5818: l_rxhv_rec rxhv_rec_type;
5819: l_rxlv_rec rxlv_rec_type;
5820: l_rxlv_tbl rxlv_tbl_type;
5821: -- Local Variables for enabling the Debug Statements
5822: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
5823: l_debug_enabled VARCHAR2(10);
5824: is_debug_procedure_on BOOLEAN;
5825: is_debug_statement_on BOOLEAN;
5826: BEGIN

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

6194: ,rxl.source_table source_table
6195: FROM okl_ext_ar_line_sources_b rxl
6196: WHERE rxl.header_extension_id = p_hdr_ext_id;
6197: -- Local Variables for enabling the Debug Statements
6198: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
6199: l_debug_enabled VARCHAR2(10);
6200: is_debug_procedure_on BOOLEAN;
6201: is_debug_statement_on BOOLEAN;
6202: BEGIN

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

6572: l_led_lang_tbl led_lang_tbl_type;
6573:
6574: l_ledger_lang_rec c_ledger_lang_csr%ROWTYPE;
6575: -- Local Variables for enabling the Debug Statements
6576: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
6577: l_debug_enabled VARCHAR2(10);
6578: is_debug_procedure_on BOOLEAN;
6579: is_debug_statement_on BOOLEAN;
6580: tl_sources_in NUMBER := 1;

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

7165: l_pxhv_rec pxhv_rec_type;
7166: l_pxlv_rec pxlv_rec_type;
7167: l_pxlv_tbl pxlv_tbl_type;
7168: -- Local Variables for enabling the Debug Statements
7169: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
7170: l_debug_enabled VARCHAR2(10);
7171: is_debug_procedure_on BOOLEAN;
7172: is_debug_statement_on BOOLEAN;
7173: BEGIN

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

7435: ,pxl.source_table source_table
7436: FROM okl_ext_ap_line_sources_b pxl
7437: WHERE pxl.header_extension_id = p_hdr_ext_id;
7438: -- Local Variables for enabling the Debug Statements
7439: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
7440: l_debug_enabled VARCHAR2(10);
7441: is_debug_procedure_on BOOLEAN;
7442: is_debug_statement_on BOOLEAN;
7443: BEGIN

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

7644: -- Record structures based on the Cursor defintions
7645: l_sales_rep_csr_rec c_sales_rep_csr%ROWTYPE;
7646: l_ledger_lang_rec c_ledger_lang_csr%ROWTYPE;
7647: -- Local Variables for enabling the Debug Statements
7648: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
7649: l_debug_enabled VARCHAR2(10);
7650: is_debug_procedure_on BOOLEAN;
7651: is_debug_statement_on BOOLEAN;
7652: tl_sources_in NUMBER := 1;

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

8683: l_api_version CONSTANT NUMBER := 1;
8684: l_api_name CONSTANT VARCHAR2(30) := 'POPULATE_SOURCES-RECEIPT';
8685: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
8686: -- Local Variables for enabling the Debug Statements
8687: l_module CONSTANT fnd_log_messages.module%TYPE := G_MODULE || l_api_name;
8688: l_debug_enabled VARCHAR2(10);
8689: is_debug_procedure_on BOOLEAN;
8690: is_debug_statement_on BOOLEAN;
8691: -----------------------------------------------------------------