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.

[Home] [Help]

APPS.OKC_XPRT_INT_GRP dependencies on FND_LOG

Line 10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: ------------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_INT_GRP';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9:
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.' || g_pkg_name || '.';
12: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
13:
14: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

Line 95: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

91:
92: BEGIN
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
97: G_MODULE || l_api_name,
98: '100: Entered ' || G_PKG_NAME || '.' || l_api_name);
99: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

92: BEGIN
93: x_return_status := FND_API.G_RET_STS_SUCCESS;
94:
95: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
97: G_MODULE || l_api_name,
98: '100: Entered ' || G_PKG_NAME || '.' || l_api_name);
99: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
100: G_MODULE || l_api_name,

Line 99: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

95: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
97: G_MODULE || l_api_name,
98: '100: Entered ' || G_PKG_NAME || '.' || l_api_name);
99: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
100: G_MODULE || l_api_name,
101: 'Parameters : ');
102: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
103: G_MODULE || l_api_name,

Line 102: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

98: '100: Entered ' || G_PKG_NAME || '.' || l_api_name);
99: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
100: G_MODULE || l_api_name,
101: 'Parameters : ');
102: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
103: G_MODULE || l_api_name,
104: 'p_document_id : ' || p_document_id);
105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
106: G_MODULE || l_api_name,

Line 105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

101: 'Parameters : ');
102: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
103: G_MODULE || l_api_name,
104: 'p_document_id : ' || p_document_id);
105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
106: G_MODULE || l_api_name,
107: 'p_document_type : ' || p_document_type);
108: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
109: G_MODULE || l_api_name,

Line 108: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

104: 'p_document_id : ' || p_document_id);
105: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
106: G_MODULE || l_api_name,
107: 'p_document_type : ' || p_document_type);
108: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
109: G_MODULE || l_api_name,
110: 'p_document_number : ' || p_document_number);
111: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
112: G_MODULE || l_api_name,

Line 111: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

107: 'p_document_type : ' || p_document_type);
108: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
109: G_MODULE || l_api_name,
110: 'p_document_number : ' || p_document_number);
111: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
112: G_MODULE || l_api_name,
113: 'p_template_id : ' || p_template_id);
114: END IF;
115:

Line 275: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

271: END IF; --l_num_scheme_id is not zero
272: END IF;
273:
274: -- end debug log
275: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
277: G_MODULE || l_api_name,
278: '1000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
279: END IF;

Line 276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

272: END IF;
273:
274: -- end debug log
275: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
276: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
277: G_MODULE || l_api_name,
278: '1000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
279: END IF;
280:

Line 284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

280:
281: EXCEPTION
282:
283: WHEN FND_API.G_EXC_ERROR THEN
284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
286: G_MODULE || l_api_name,
287: '2000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
288: END IF;

Line 285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

281: EXCEPTION
282:
283: WHEN FND_API.G_EXC_ERROR THEN
284: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
285: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
286: G_MODULE || l_api_name,
287: '2000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
288: END IF;
289:

Line 297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

293: p_data => x_msg_data
294: );
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
299: G_MODULE || l_api_name,
300: '3000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
301: END IF;

Line 298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

294: );
295:
296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
299: G_MODULE || l_api_name,
300: '3000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
301: END IF;
302:

Line 310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

306: p_data => x_msg_data
307: );
308:
309: WHEN OTHERS THEN
310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
312: G_MODULE || l_api_name,
313: '4000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
314: END IF;

Line 311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

307: );
308:
309: WHEN OTHERS THEN
310: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
312: G_MODULE || l_api_name,
313: '4000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
314: END IF;
315:

Line 411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

407: BEGIN
408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409:
410:
411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
413: G_MODULE || l_api_name,
414: '100: Entered ' || G_PKG_NAME || '.' || l_api_name);
415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

408: x_return_status := FND_API.G_RET_STS_SUCCESS;
409:
410:
411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
413: G_MODULE || l_api_name,
414: '100: Entered ' || G_PKG_NAME || '.' || l_api_name);
415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
416: G_MODULE || l_api_name,

Line 415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

411: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
412: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
413: G_MODULE || l_api_name,
414: '100: Entered ' || G_PKG_NAME || '.' || l_api_name);
415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
416: G_MODULE || l_api_name,
417: 'Parameters : ');
418: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
419: G_MODULE || l_api_name,

Line 418: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

414: '100: Entered ' || G_PKG_NAME || '.' || l_api_name);
415: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
416: G_MODULE || l_api_name,
417: 'Parameters : ');
418: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
419: G_MODULE || l_api_name,
420: 'p_document_id : ' || p_document_id);
421: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
422: G_MODULE || l_api_name,

Line 421: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

417: 'Parameters : ');
418: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
419: G_MODULE || l_api_name,
420: 'p_document_id : ' || p_document_id);
421: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
422: G_MODULE || l_api_name,
423: 'p_document_type : ' || p_document_type);
424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
425: G_MODULE || l_api_name,

Line 424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

420: 'p_document_id : ' || p_document_id);
421: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
422: G_MODULE || l_api_name,
423: 'p_document_type : ' || p_document_type);
424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
425: G_MODULE || l_api_name,
426: 'p_called_from_ui : ' || p_called_from_ui);
427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
428: G_MODULE || l_api_name,

Line 427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

423: 'p_document_type : ' || p_document_type);
424: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
425: G_MODULE || l_api_name,
426: 'p_called_from_ui : ' || p_called_from_ui);
427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
428: G_MODULE || l_api_name,
429: 'p_document_number : ' || p_document_number);
430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
431: G_MODULE || l_api_name,

Line 430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

426: 'p_called_from_ui : ' || p_called_from_ui);
427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
428: G_MODULE || l_api_name,
429: 'p_document_number : ' || p_document_number);
430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
431: G_MODULE || l_api_name,
432: 'p_template_id : ' || p_template_id);
433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
434: G_MODULE || l_api_name,

Line 433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

429: 'p_document_number : ' || p_document_number);
430: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
431: G_MODULE || l_api_name,
432: 'p_template_id : ' || p_template_id);
433: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
434: G_MODULE || l_api_name,
435: 'p_run_xprt_flag : ' || p_run_xprt_flag);
436: END IF;
437:

Line 471: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

467: FETCH csr_quote_status INTO l_quote_status;
468: CLOSE csr_quote_status;
469:
470: --Logging local variables
471: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
473: G_MODULE || l_api_name,
474: '100: Is expert enabled : ' ||l_expert_enabled );
475: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

468: CLOSE csr_quote_status;
469:
470: --Logging local variables
471: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
473: G_MODULE || l_api_name,
474: '100: Is expert enabled : ' ||l_expert_enabled );
475: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
476: G_MODULE || l_api_name,

Line 475: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

471: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
472: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
473: G_MODULE || l_api_name,
474: '100: Is expert enabled : ' ||l_expert_enabled );
475: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
476: G_MODULE || l_api_name,
477: '100: template id on doc : ' ||l_tmpl_id_on_doc );
478: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
479: G_MODULE || l_api_name,

Line 478: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

474: '100: Is expert enabled : ' ||l_expert_enabled );
475: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
476: G_MODULE || l_api_name,
477: '100: template id on doc : ' ||l_tmpl_id_on_doc );
478: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
479: G_MODULE || l_api_name,
480: '100: template id passed: ' ||p_template_id);
481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
482: G_MODULE || l_api_name,

Line 481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

477: '100: template id on doc : ' ||l_tmpl_id_on_doc );
478: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
479: G_MODULE || l_api_name,
480: '100: template id passed: ' ||p_template_id);
481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
482: G_MODULE || l_api_name,
483: '100: l_tmpl_lang_on_doc : ' ||l_tmpl_lang_on_doc );
484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
485: G_MODULE || l_api_name,

Line 484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

480: '100: template id passed: ' ||p_template_id);
481: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
482: G_MODULE || l_api_name,
483: '100: l_tmpl_lang_on_doc : ' ||l_tmpl_lang_on_doc );
484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
485: G_MODULE || l_api_name,
486: '100: l_tmpl_lang_passed : ' ||l_tmpl_lang_passed );
487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
488: G_MODULE || l_api_name,

Line 487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

483: '100: l_tmpl_lang_on_doc : ' ||l_tmpl_lang_on_doc );
484: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
485: G_MODULE || l_api_name,
486: '100: l_tmpl_lang_passed : ' ||l_tmpl_lang_passed );
487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
488: G_MODULE || l_api_name,
489: '100: document status : ' ||l_quote_status );
490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
491: G_MODULE || l_api_name,

Line 490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

486: '100: l_tmpl_lang_passed : ' ||l_tmpl_lang_passed );
487: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
488: G_MODULE || l_api_name,
489: '100: document status : ' ||l_quote_status );
490: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
491: G_MODULE || l_api_name,
492: '100: l_ce_profile_option_enabled : ' ||l_ce_profile_option_enabled);
493: END IF;
494:

Line 505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

501: l_tmpl_lang_on_doc <> l_tmpl_lang_passed and
502: l_quote_status = 28 -- 28 means quote status = 'STORE DRAFT'
503: )
504: ) THEN
505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
506: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
507: G_MODULE || l_api_name,
508: '120: Calling copy_terms' );
509: END IF;

Line 506: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

502: l_quote_status = 28 -- 28 means quote status = 'STORE DRAFT'
503: )
504: ) THEN
505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
506: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
507: G_MODULE || l_api_name,
508: '120: Calling copy_terms' );
509: END IF;
510: OKC_TERMS_COPY_GRP.copy_terms(

Line 541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

537: -- Begin Fix for bug 4919069. Added if Condition before running expert
538: -- if the template is expert enabled and Expert profile option is 'Y'
539: IF (upper(l_ce_profile_option_enabled) = 'Y') THEN
540:
541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
543: G_MODULE || l_api_name,
544: '130: Before calling get_current_config_dtls ' );
545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

538: -- if the template is expert enabled and Expert profile option is 'Y'
539: IF (upper(l_ce_profile_option_enabled) = 'Y') THEN
540:
541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
543: G_MODULE || l_api_name,
544: '130: Before calling get_current_config_dtls ' );
545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
546: G_MODULE || l_api_name,

Line 545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
543: G_MODULE || l_api_name,
544: '130: Before calling get_current_config_dtls ' );
545: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
546: G_MODULE || l_api_name,
547: '130: l_tmpl_id_for_bv '||l_tmpl_id_for_bv );
548:
549: END IF;

Line 572: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

568: l_config_rev_nbr IS NOT NULL
569: )
570: ) THEN
571:
572: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
573: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
574: G_MODULE || l_api_name,
575: '140: Before running CE' );
576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 573: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

569: )
570: ) THEN
571:
572: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
573: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
574: G_MODULE || l_api_name,
575: '140: Before running CE' );
576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
577: G_MODULE || l_api_name,

Line 576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

572: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
573: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
574: G_MODULE || l_api_name,
575: '140: Before running CE' );
576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
577: G_MODULE || l_api_name,
578: '140: l_config_header_id '||l_config_header_id );
579: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
580: G_MODULE || l_api_name,

Line 579: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

575: '140: Before running CE' );
576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
577: G_MODULE || l_api_name,
578: '140: l_config_header_id '||l_config_header_id );
579: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
580: G_MODULE || l_api_name,
581: '140: l_config_rev_nbr '||l_config_rev_nbr );
582: END IF;
583:

Line 603: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

599: THEN
600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: END IF;
602:
603: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
605: G_MODULE || l_api_name,
606: '150: before calling batch_validate' );
607: END IF;

Line 604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

600: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
601: END IF;
602:
603: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
604: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
605: G_MODULE || l_api_name,
606: '150: before calling batch_validate' );
607: END IF;
608: OKC_XPRT_CZ_INT_PVT.batch_validate(

Line 628: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

624:
625: -- To parse x_cz_xml_terminate_msg and check if the CZ batch validate
626: -- was successful. If batch validate was successful, it would return
627: -- the new config_header_id and config_revision_number
628: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
629: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
630: G_MODULE || l_api_name,
631: '160: before calling parse_cz_xml_terminate_msg');
632: END IF;

Line 629: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

625: -- To parse x_cz_xml_terminate_msg and check if the CZ batch validate
626: -- was successful. If batch validate was successful, it would return
627: -- the new config_header_id and config_revision_number
628: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
629: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
630: G_MODULE || l_api_name,
631: '160: before calling parse_cz_xml_terminate_msg');
632: END IF;
633:

Line 651: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

647: THEN
648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;
650:
651: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
652: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
653: G_MODULE || l_api_name,
654: '170: before calling update_ce_config');
655: END IF;

Line 652: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

648: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
649: END IF;
650:
651: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
652: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
653: G_MODULE || l_api_name,
654: '170: before calling update_ce_config');
655: END IF;
656:

Line 683: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

679: END IF; -- if l_ce_profile_option_enabled = 'Y'
680:
681: END IF; -- if p_run_exprt_flag
682:
683: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
684: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
685: G_MODULE || l_api_name,
686: '200: deleting empty sections' );
687: END IF;

Line 684: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

680:
681: END IF; -- if p_run_exprt_flag
682:
683: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
684: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
685: G_MODULE || l_api_name,
686: '200: deleting empty sections' );
687: END IF;
688:

Line 709: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

705: END IF;
706:
707:
708: -- end debug log
709: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
711: G_MODULE || l_api_name,
712: '1000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
713: END IF;

Line 710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

706:
707:
708: -- end debug log
709: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
711: G_MODULE || l_api_name,
712: '1000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
713: END IF;
714:

Line 720: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

716:
717: EXCEPTION
718:
719: WHEN FND_API.G_EXC_ERROR THEN
720: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
722: G_MODULE || l_api_name,
723: '2000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
724: END IF;

Line 721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

717: EXCEPTION
718:
719: WHEN FND_API.G_EXC_ERROR THEN
720: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
721: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
722: G_MODULE || l_api_name,
723: '2000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
724: END IF;
725:

Line 733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

729: p_data => x_msg_data
730: );
731:
732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
735: G_MODULE || l_api_name,
736: '3000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
737: END IF;

Line 734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

730: );
731:
732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
733: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
734: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
735: G_MODULE || l_api_name,
736: '3000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
737: END IF;
738:

Line 746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

742: p_data => x_msg_data
743: );
744:
745: WHEN OTHERS THEN
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
748: G_MODULE || l_api_name,
749: '4000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
750: END IF;

Line 747: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

743: );
744:
745: WHEN OTHERS THEN
746: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
747: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
748: G_MODULE || l_api_name,
749: '4000: Leaving ' || G_PKG_NAME || '.' || l_api_name);
750: END IF;
751: