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_INTERNAL_BILLING_PVT dependencies on OKL_DEBUG_PUB

Line 17: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

13: ----------------------------------------------------------------------------
14: -- Variables For Debugging and Logging
15: ----------------------------------------------------------------------------
16: G_MODULE VARCHAR2(40) := 'LEASE.RECEIVABLES';
17: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
18: G_LEVEL_PROCEDURE NUMBER;
19: G_IS_DEBUG_PROCEDURE_ON BOOLEAN;
20: G_IS_DEBUG_STATEMENT_ON BOOLEAN;
21: G_IS_STREAM_BASED_BILLING BOOLEAN := NULL;

Line 117: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));

113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
114: END IF;
115:
116: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
117: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));
118: END IF;
119: */
120:
121: ---- Added by Vpanwar --- Code for new accounting API uptake

Line 157: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS_NEW:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));

153:
154: ---- End Added by Vpanwar --- Code for new accounting API uptake
155:
156: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
157: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS_NEW:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));
158: END IF;
159:
160: EXIT WHEN l_tld_loop_cnt = lp_tldv_tbl.LAST;
161: l_tld_loop_cnt := lp_tldv_tbl.NEXT(l_tld_loop_cnt);

Line 442: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

438: begin
439: -- Set API savepoint
440: SAVEPOINT additional_tai_attr;
441: IF (G_DEBUG_ENABLED = 'Y') THEN
442: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
443: END IF;
444: --Print Input Variables
445: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
446: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_taiv_rec.id :'||p_taiv_rec.id);

Line 446: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_taiv_rec.id :'||p_taiv_rec.id);

442: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
443: END IF;
444: --Print Input Variables
445: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
446: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_taiv_rec.id :'||p_taiv_rec.id);
447: END IF;
448: -- Check for call compatibility
449: IF (NOT FND_API.Compatible_API_Call (l_api_version,
450: p_api_version,

Line 976: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

972: begin
973: -- Set API savepoint
974: SAVEPOINT additional_til_attr;
975: IF (G_DEBUG_ENABLED = 'Y') THEN
976: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
977: END IF;
978: --Print Input Variables
979: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
980: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tilv_rec.id :'||p_tilv_rec.id);

Line 980: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tilv_rec.id :'||p_tilv_rec.id);

976: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
977: END IF;
978: --Print Input Variables
979: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
980: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tilv_rec.id :'||p_tilv_rec.id);
981: END IF;
982: -- Check for call compatibility
983: IF (NOT FND_API.Compatible_API_Call (l_api_version,
984: p_api_version,

Line 1121: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1117: begin
1118: -- Set API savepoint
1119: SAVEPOINT additional_tld_attr;
1120: IF (G_DEBUG_ENABLED = 'Y') THEN
1121: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1122: END IF;
1123: --Print Input Variables
1124: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1125: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tldv_rec.id :'||p_tldv_rec.id);

Line 1125: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tldv_rec.id :'||p_tldv_rec.id);

1121: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1122: END IF;
1123: --Print Input Variables
1124: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1125: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_tldv_rec.id :'||p_tldv_rec.id);
1126: END IF;
1127: -- Check for call compatibility
1128: IF (NOT FND_API.Compatible_API_Call (l_api_version,
1129: p_api_version,

Line 1933: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

1929: begin
1930: -- Set API savepoint
1931: SAVEPOINT create_non_sel_billing_trx;
1932: IF (G_DEBUG_ENABLED = 'Y') THEN
1933: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1934: END IF;
1935: --Print Input Variables
1936: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1937: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);

Line 1937: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);

1933: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1934: END IF;
1935: --Print Input Variables
1936: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1937: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);
1938: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);
1939:
1940: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');
1941: IF (p_tilv_tbl.count > 0) THEN -- 6402950

Line 1938: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);

1934: END IF;
1935: --Print Input Variables
1936: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1937: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);
1938: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);
1939:
1940: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');
1941: IF (p_tilv_tbl.count > 0) THEN -- 6402950
1942: l_til_debug_cnt := p_tilv_tbl.first;

Line 1940: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');

1936: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1937: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);
1938: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);
1939:
1940: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');
1941: IF (p_tilv_tbl.count > 0) THEN -- 6402950
1942: l_til_debug_cnt := p_tilv_tbl.first;
1943: loop
1944: --for l_til_debug_cnt in 1 .. p_tilv_tbl.count loop

Line 1945: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inv receiv line code :'||p_tilv_tbl(l_til_debug_cnt).inv_receiv_line_code);

1941: IF (p_tilv_tbl.count > 0) THEN -- 6402950
1942: l_til_debug_cnt := p_tilv_tbl.first;
1943: loop
1944: --for l_til_debug_cnt in 1 .. p_tilv_tbl.count loop
1945: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inv receiv line code :'||p_tilv_tbl(l_til_debug_cnt).inv_receiv_line_code);
1946: EXIT WHEN l_til_debug_cnt = p_tilv_tbl.LAST; -- 6402950
1947: l_til_debug_cnt := p_tilv_tbl.NEXT(l_til_debug_cnt);
1948: end loop;
1949: END IF;

Line 2032: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_taiv_rec.id: '||to_char(lx_taiv_rec.id));

2028: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2029: END IF;
2030:
2031: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2032: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_taiv_rec.id: '||to_char(lx_taiv_rec.id));
2033: END IF;
2034: -- 3. Assign attributes back to lx_taiv_rec along with ID (passed lx_taiv_rec as OUT parameter)
2035:
2036: l_taiv_id := lx_taiv_rec.ID;

Line 2089: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tilv_rec.id: '||to_char(lx_tilv_rec.id));

2085: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2086: END IF;
2087:
2088: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2089: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tilv_rec.id: '||to_char(lx_tilv_rec.id));
2090: END IF;
2091:
2092: -- l_til_ln_number := lx_tilv_rec.TXL_AR_LINE_NUMBER;
2093: l_til_id := lx_tilv_rec.id;

Line 2175: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tldv_rec.id: '||to_char(lx_tldv_rec.id));

2171: END IF;
2172: lp_tldv_tbl(l_til_loop_cnt) := lx_tldv_rec;
2173:
2174: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2175: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tldv_rec.id: '||to_char(lx_tldv_rec.id));
2176: END IF;
2177:
2178: /*
2179: -- Set Loop counter to 0;

Line 2280: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));

2276: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2277: END IF;
2278:
2279: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2280: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));
2281: END IF;
2282: */
2283:
2284: ---- Added by Vpanwar --- Code for new accounting API uptake

Line 2320: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS_NEW:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));

2316:
2317: ---- End Added by Vpanwar --- Code for new accounting API uptake
2318:
2319: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2320: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS_NEW:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));
2321: END IF;
2322:
2323: EXIT WHEN l_tld_loop_cnt = lp_tldv_tbl.LAST;
2324: l_tld_loop_cnt := lp_tldv_tbl.NEXT(l_tld_loop_cnt);

Line 2488: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

2484: begin
2485: -- Set API savepoint
2486: SAVEPOINT create_sel_billing_trx;
2487: IF (G_DEBUG_ENABLED = 'Y') THEN
2488: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2489: END IF;
2490: --Print Input Variables
2491: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2492: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);

Line 2492: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);

2488: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2489: END IF;
2490: --Print Input Variables
2491: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2492: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);
2493: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);
2494:
2495: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');
2496: IF (p_tilv_tbl.count > 0) THEN -- 6402950

Line 2493: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);

2489: END IF;
2490: --Print Input Variables
2491: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2492: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);
2493: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);
2494:
2495: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');
2496: IF (p_tilv_tbl.count > 0) THEN -- 6402950
2497: l_til_debug_cnt := p_tilv_tbl.first;

Line 2495: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');

2491: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2492: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);
2493: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);
2494:
2495: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');
2496: IF (p_tilv_tbl.count > 0) THEN -- 6402950
2497: l_til_debug_cnt := p_tilv_tbl.first;
2498: loop
2499: --for l_til_debug_cnt in 1 .. p_tilv_tbl.count loop

Line 2500: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inv receiv line code :'||p_tilv_tbl(l_til_debug_cnt).inv_receiv_line_code);

2496: IF (p_tilv_tbl.count > 0) THEN -- 6402950
2497: l_til_debug_cnt := p_tilv_tbl.first;
2498: loop
2499: --for l_til_debug_cnt in 1 .. p_tilv_tbl.count loop
2500: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inv receiv line code :'||p_tilv_tbl(l_til_debug_cnt).inv_receiv_line_code);
2501: EXIT WHEN l_til_debug_cnt = p_tilv_tbl.LAST; -- 6402950
2502: l_til_debug_cnt := p_tilv_tbl.NEXT(l_til_debug_cnt);
2503: end loop;
2504: END IF;

Line 2506: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tldv Parameters');

2502: l_til_debug_cnt := p_tilv_tbl.NEXT(l_til_debug_cnt);
2503: end loop;
2504: END IF;
2505:
2506: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tldv Parameters');
2507: IF (lp_tldv_tbl.count > 0) THEN -- 6402950
2508: l_tld_debug_cnt := lp_tldv_tbl.first; -- 6402950
2509: loop
2510: --FOR l_tld_debug_cnt in 1 .. p_tldv_tbl.count LOOP

Line 2511: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'TXL AR LINE NUMBER :'||lp_tldv_tbl(l_tld_debug_cnt).TXL_AR_LINE_NUMBER);

2507: IF (lp_tldv_tbl.count > 0) THEN -- 6402950
2508: l_tld_debug_cnt := lp_tldv_tbl.first; -- 6402950
2509: loop
2510: --FOR l_tld_debug_cnt in 1 .. p_tldv_tbl.count LOOP
2511: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'TXL AR LINE NUMBER :'||lp_tldv_tbl(l_tld_debug_cnt).TXL_AR_LINE_NUMBER);
2512: EXIT WHEN l_tld_debug_cnt = lp_tldv_tbl.LAST;
2513: l_tld_debug_cnt := lp_tldv_tbl.NEXT(l_tld_debug_cnt);
2514: END LOOP;
2515: END IF;

Line 2589: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_taiv_rec.id: '||to_char(lx_taiv_rec.id));

2585: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2586: END IF;
2587: -- 3. Assign attributes back to lx_taiv_rec along with ID (passed lx_taiv_rec as OUT parameter)
2588: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2589: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_taiv_rec.id: '||to_char(lx_taiv_rec.id));
2590: END IF;
2591:
2592: l_taiv_id := lx_taiv_rec.ID;
2593:

Line 2643: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tilv_rec.id: '||to_char(lx_tilv_rec.id));

2639: END IF;
2640: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2641: END IF;
2642: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2643: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tilv_rec.id: '||to_char(lx_tilv_rec.id));
2644: END IF;
2645:
2646: l_til_ln_number := lx_tilv_rec.TXL_AR_LINE_NUMBER;
2647: l_til_id := lx_tilv_rec.id;

Line 2750: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tldv_rec.id: '||to_char(lx_tldv_rec.id));

2746: END IF;
2747: lp_tldv_tbl(l_tld_loop_cnt) := lx_tldv_rec;
2748:
2749: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2750: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tldv_rec.id: '||to_char(lx_tldv_rec.id));
2751: END IF;
2752:
2753: -- end if;
2754: End If;

Line 2813: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));

2809: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2810: END IF;
2811:
2812: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2813: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));
2814: END IF;
2815:
2816: */
2817:

Line 2856: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS_NEW:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));

2852: ---- End Added by Vpanwar --- Code for new accounting API uptake
2853:
2854:
2855: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2856: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Okl_Acc_Call_Pub.CREATE_ACC_TRANS_NEW:p_bpd_acc_rec.id: '||to_char(p_bpd_acc_rec.id));
2857: END IF;
2858:
2859: EXIT WHEN l_tld_loop_cnt = lp_tldv_tbl.LAST;
2860: l_tld_loop_cnt := lp_tldv_tbl.NEXT(l_tld_loop_cnt);

Line 3041: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

3037: begin
3038: -- Set API savepoint
3039: SAVEPOINT CREATE_BILLING_TRX;
3040: IF (G_DEBUG_ENABLED = 'Y') THEN
3041: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3042: END IF;
3043: --Print Input Variables
3044: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);

Line 3045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);

3041: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3042: END IF;
3043: --Print Input Variables
3044: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);
3046: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);
3047:
3048: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');
3049: IF (p_tilv_tbl.count > 0) THEN -- 6402950

Line 3046: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);

3042: END IF;
3043: --Print Input Variables
3044: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);
3046: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);
3047:
3048: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');
3049: IF (p_tilv_tbl.count > 0) THEN -- 6402950
3050: l_til_debug_cnt := p_tilv_tbl.first;

Line 3048: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');

3044: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Taiv Parameters '||' Currency Code :'||p_taiv_rec.currency_code||' Currency conversion type :'||p_taiv_rec.currency_conversion_type);
3046: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Currency conversion rate :'||p_taiv_rec.currency_conversion_rate||' Currency conversion date :'||p_taiv_rec.currency_conversion_date);
3047:
3048: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tilv Parameters');
3049: IF (p_tilv_tbl.count > 0) THEN -- 6402950
3050: l_til_debug_cnt := p_tilv_tbl.first;
3051: loop
3052: --for l_til_debug_cnt in 1 .. p_tilv_tbl.count loop

Line 3053: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inv receiv line code :'||p_tilv_tbl(l_til_debug_cnt).inv_receiv_line_code);

3049: IF (p_tilv_tbl.count > 0) THEN -- 6402950
3050: l_til_debug_cnt := p_tilv_tbl.first;
3051: loop
3052: --for l_til_debug_cnt in 1 .. p_tilv_tbl.count loop
3053: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inv receiv line code :'||p_tilv_tbl(l_til_debug_cnt).inv_receiv_line_code);
3054: EXIT WHEN l_til_debug_cnt = p_tilv_tbl.LAST; -- 6402950
3055: l_til_debug_cnt := p_tilv_tbl.NEXT(l_til_debug_cnt);
3056: end loop;
3057: END IF;

Line 3059: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tldv Parameters');

3055: l_til_debug_cnt := p_tilv_tbl.NEXT(l_til_debug_cnt);
3056: end loop;
3057: END IF;
3058:
3059: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'tldv Parameters');
3060: IF (p_tldv_tbl.count > 0) THEN -- 6402950
3061: l_tld_debug_cnt := lp_tldv_tbl.first; -- 6402950
3062: loop
3063: --FOR l_tld_debug_cnt in 1 .. p_tldv_tbl.count LOOP

Line 3064: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'TXL AR LINE NUMBER :'||p_tldv_tbl(l_tld_debug_cnt).TXL_AR_LINE_NUMBER);

3060: IF (p_tldv_tbl.count > 0) THEN -- 6402950
3061: l_tld_debug_cnt := lp_tldv_tbl.first; -- 6402950
3062: loop
3063: --FOR l_tld_debug_cnt in 1 .. p_tldv_tbl.count LOOP
3064: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'TXL AR LINE NUMBER :'||p_tldv_tbl(l_tld_debug_cnt).TXL_AR_LINE_NUMBER);
3065: EXIT WHEN l_tld_debug_cnt = lp_tldv_tbl.LAST;
3066: l_tld_debug_cnt := lp_tldv_tbl.NEXT(l_tld_debug_cnt);
3067: END LOOP;
3068: END IF;

Line 3206: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_taiv_rec.id: '||to_char(x_taiv_rec.id));

3202: x_taiv_rec := lx_taiv_rec;
3203: x_tilv_tbl := lx_tilv_tbl;
3204: x_tldv_tbl := lx_tldv_tbl;
3205: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3206: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_taiv_rec.id: '||to_char(x_taiv_rec.id));
3207: --OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_tilv_tbl(1).id: '||to_char(x_tilv_tbl(1).id));
3208: --OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_tldv_tbl(1).id: '||to_char(x_tldv_tbl(1).id));
3209: END IF;
3210: -- end: cklee -- fixed return parameters issues 4/6/07

Line 3207: --OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_tilv_tbl(1).id: '||to_char(x_tilv_tbl(1).id));

3203: x_tilv_tbl := lx_tilv_tbl;
3204: x_tldv_tbl := lx_tldv_tbl;
3205: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3206: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_taiv_rec.id: '||to_char(x_taiv_rec.id));
3207: --OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_tilv_tbl(1).id: '||to_char(x_tilv_tbl(1).id));
3208: --OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_tldv_tbl(1).id: '||to_char(x_tldv_tbl(1).id));
3209: END IF;
3210: -- end: cklee -- fixed return parameters issues 4/6/07
3211:

Line 3208: --OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_tldv_tbl(1).id: '||to_char(x_tldv_tbl(1).id));

3204: x_tldv_tbl := lx_tldv_tbl;
3205: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3206: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_taiv_rec.id: '||to_char(x_taiv_rec.id));
3207: --OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_tilv_tbl(1).id: '||to_char(x_tilv_tbl(1).id));
3208: --OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_tldv_tbl(1).id: '||to_char(x_tldv_tbl(1).id));
3209: END IF;
3210: -- end: cklee -- fixed return parameters issues 4/6/07
3211:
3212: /*** End API body ******************************************************/

Line 3317: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

3313: begin
3314: -- Set API savepoint
3315: SAVEPOINT Get_Invoice_format;
3316: IF (G_DEBUG_ENABLED = 'Y') THEN
3317: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3318: END IF;
3319: --Print Input Variables
3320: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3321: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_inf_id :'||p_inf_id);

Line 3321: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_inf_id :'||p_inf_id);

3317: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3318: END IF;
3319: --Print Input Variables
3320: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3321: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_inf_id :'||p_inf_id);
3322: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_sty_id :'||p_sty_id);
3323:
3324: END IF;
3325: -- Check for call compatibility

Line 3322: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_sty_id :'||p_sty_id);

3318: END IF;
3319: --Print Input Variables
3320: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3321: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_inf_id :'||p_inf_id);
3322: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_sty_id :'||p_sty_id);
3323:
3324: END IF;
3325: -- Check for call compatibility
3326: IF (NOT FND_API.Compatible_API_Call (l_api_version,

Line 3521: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_taiv_rec.id: '||to_char(lx_taiv_rec.id));

3517: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3518: END IF;
3519:
3520: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3521: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_taiv_rec.id: '||to_char(lx_taiv_rec.id));
3522: END IF;
3523: x_taiv_rec := lx_taiv_rec;
3524: -- Delete TIL record and correspondingly its TLD record which is not coming in p_tilv_tbl.
3525:

Line 3675: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tilv_rec.id: '||to_char(lx_tilv_rec.id));

3671: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3672: END IF;
3673:
3674: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3675: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tilv_rec.id: '||to_char(lx_tilv_rec.id));
3676: END IF;
3677:
3678: -- l_til_ln_number := lx_tilv_rec.TXL_AR_LINE_NUMBER;
3679: l_til_id := lx_tilv_rec.id;

Line 3750: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tldv_rec.id: '||to_char(lx_tldv_rec.id));

3746: END IF;
3747: -- lp_tldv_tbl(l_til_loop_cnt) := lx_tldv_rec;
3748:
3749: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3750: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'lx_tldv_rec.id: '||to_char(lx_tldv_rec.id));
3751: END IF;
3752:
3753: END LOOP;
3754: END IF;