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_PA_DATA_INTEGRITY dependencies on FND_LOG

Line 134: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_date_overlap';

130:
131: l_return_value VARCHAR2(1) ;
132: lv_dummy VARCHAR2(1);
133:
134: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_date_overlap';
135: l_debug_enabled VARCHAR2(10);
136:
137: BEGIN
138: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 140: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call validate_date_overlap');

136:
137: BEGIN
138: l_debug_enabled := okl_debug_pub.check_log_enabled;
139: IF(l_debug_enabled='Y') THEN
140: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call validate_date_overlap');
141: END IF;
142:
143: l_return_value := 'S';
144:

Line 223: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call validate_date_overlap');

219: EXIT WHEN l_return_value = 'E';
220: END LOOP;
221:
222: IF(l_debug_enabled='Y') THEN
223: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call validate_date_overlap');
224: END IF;
225: */
226: return l_return_value;
227:

Line 236: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_end_date';

232:
233:
234: l_return_value VARCHAR2(1) ;
235:
236: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_end_date';
237: l_debug_enabled VARCHAR2(10);
238:
239: BEGIN
240:

Line 243: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call validate_end_date');

239: BEGIN
240:
241: l_debug_enabled := okl_debug_pub.check_log_enabled;
242: IF(l_debug_enabled='Y') THEN
243: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call validate_end_date');
244: END IF;
245:
246: l_return_value := 'S';
247:

Line 274: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call validate_end_date');

270: END IF;
271: END IF;
272:
273: IF(l_debug_enabled='Y') THEN
274: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call validate_end_date');
275: END IF;
276:
277: return l_return_value;
278:

Line 286: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_start_date';

282: FUNCTION validate_start_date(p_assoc_start_date IN DATE, p_agrmnt_start_date IN DATE, p_agrmnt_end_date IN DATE) RETURN VARCHAR2 IS
283:
284: l_return_value VARCHAR2(1) ;
285:
286: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_start_date';
287: l_debug_enabled VARCHAR2(10);
288:
289: BEGIN
290:

Line 293: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call validate_start_date');

289: BEGIN
290:
291: l_debug_enabled := okl_debug_pub.check_log_enabled;
292: IF(l_debug_enabled='Y') THEN
293: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call validate_start_date');
294: END IF;
295:
296: l_return_value := 'S';
297:

Line 315: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call validate_start_date');

311: END IF;
312: END IF;
313:
314: IF(l_debug_enabled='Y') THEN
315: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call validate_start_date');
316: END IF;
317:
318: return l_return_value;
319:

Line 328: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_status';

324: FUNCTION validate_status(p_status IN VARCHAR2) RETURN VARCHAR2 IS
325:
326: l_return_value VARCHAR2(1) ;
327:
328: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.validate_status';
329: l_debug_enabled VARCHAR2(10);
330:
331: BEGIN
332:

Line 335: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call validate_status');

331: BEGIN
332:
333: l_debug_enabled := okl_debug_pub.check_log_enabled;
334: IF(l_debug_enabled='Y') THEN
335: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call validate_status');
336: END IF;
337:
338: l_return_value := 'S';
339: -- if the status of lease agreement template or the lease application template attached to the agreement is not in

Line 348: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call validate_status');

344: l_return_value := 'S';
345: END IF;
346:
347: IF(l_debug_enabled='Y') THEN
348: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call validate_status');
349: END IF;
350:
351: return l_return_value;
352:

Line 370: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.get_lookup_meaning';

366: AND FND.LOOKUP_CODE = p_lookup_code;
367:
368: l_return_value fnd_lookups.meaning%TYPE;
369:
370: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.get_lookup_meaning';
371: l_debug_enabled VARCHAR2(10);
372:
373: BEGIN
374: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 376: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call get_lookup_meaning');

372:
373: BEGIN
374: l_debug_enabled := okl_debug_pub.check_log_enabled;
375: IF(l_debug_enabled='Y') THEN
376: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call get_lookup_meaning');
377: END IF;
378:
379: IF ( p_lookup_type IS NOT NULL AND p_lookup_code IS NOT NULL )
380: THEN

Line 386: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call evaluate_territory');

382: FETCH fnd_lookup_csr INTO l_return_value;
383: CLOSE fnd_lookup_csr;
384: END IF;
385: IF(l_debug_enabled='Y') THEN
386: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call evaluate_territory');
387: END IF;
388: return l_return_value;
389: END get_lookup_meaning;
390:

Line 620: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.check_functional_constraints';

616: p_api_version NUMBER;
617: p_init_msg_list VARCHAR2(256) DEFAULT OKC_API.G_FALSE;
618: x_msg_count NUMBER;
619: x_msg_data VARCHAR2(256);
620: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_pa_data_integrity.check_functional_constraints';
621: l_debug_enabled VARCHAR2(10);
622:
623: l_dummy VARCHAR2(1);
624: -- Manu 02-Sep-2005 remove references to APPLICATION_TYPE

Line 639: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call get_lookup_meaning');

635:
636: l_debug_enabled := okl_debug_pub.check_log_enabled;
637:
638: IF(l_debug_enabled='Y') THEN
639: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRPAQB.pls.pls call get_lookup_meaning');
640: END IF;
641: -- initialize return status
642: x_return_status := OKL_API.G_RET_STS_SUCCESS;
643:

Line 1097: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call evaluate_territory');

1093: p_msg_name => G_QA_SUCCESS);
1094: END IF;
1095:
1096: IF(l_debug_enabled='Y') THEN
1097: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRPAQB.pls.pls call evaluate_territory');
1098: END IF;
1099:
1100: EXCEPTION
1101: