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

Line 207: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Param List Before Return ' || l_paramList);

203: IF (l_usage IS NOT NULL) THEN
204: l_paramlist := l_paramlist || ' USAGE' || '="' || l_usage ||'" ';
205: END IF;
206: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
207: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Param List Before Return ' || l_paramList);
208: END IF;
209: RETURN l_paramlist;
210: EXCEPTION
211: WHEN OTHERS THEN

Line 255: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside Campaign Code Match');

251: lx_CampaignId number;
252: */
253: BEGIN
254: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
255: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside Campaign Code Match');
256: END IF;
257: /*
258: IF ( l_campaigncode IS NOT NULL ) THEN
259: OPEN c_campaigncode(l_CampaignCode);

Line 289: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'GetCampaignCode Exception Occurred');

285: */
286: EXCEPTION
287: WHEN OTHERS THEN
288: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
289: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'GetCampaignCode Exception Occurred');
290: END IF;
291: RETURN;
292: END;
293: -- procedure to get the collateral request Id from a collateral request confirmation

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

355: l_partyTypeNext VARCHAR2(150);
356: */
357: BEGIN
358: IF (G_DEBUG_ENABLED = 'Y') THEN
359: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
360: END IF;
361: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
362: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside Phone Number Match, l_Ani: ' || l_Ani || ' l_NoAreaCodeMatch = '
363:

Line 362: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside Phone Number Match, l_Ani: ' || l_Ani || ' l_NoAreaCodeMatch = '

358: IF (G_DEBUG_ENABLED = 'Y') THEN
359: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
360: END IF;
361: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
362: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside Phone Number Match, l_Ani: ' || l_Ani || ' l_NoAreaCodeMatch = '
363:
364: || l_NoAreaCodeMatch );
365:
366: END IF;

Line 437: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'GetDtlsFromPhoneNum Exception Occurred');

433: */
434: EXCEPTION
435: WHEN OTHERS THEN
436: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
437: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'GetDtlsFromPhoneNum Exception Occurred');
438: END IF;
439: RETURN;
440: END GetDtlsFromPhoneNum;
441: PROCEDURE handleOTSInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,

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

444: p_action_param OUT NOCOPY VARCHAR2) IS
445: foo_action_param VARCHAR2(3000);
446: BEGIN
447: IF (G_DEBUG_ENABLED = 'Y') THEN
448: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
449: END IF;
450: -- setCurrentForm('ASTTMPOP');
451: p_action_type :=1;
452: p_action_name := G_CurrentForm;

Line 457: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside Foo function ');

453: p_action_param := '';
454: setDefaults;
455: getCallData(p_mediaTable);
456: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
457: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside Foo function ');
458: END IF;
459: IF (l_CampaignID = 0) AND (l_profile = 'Y') THEN
460: getCampaignCode;
461: END IF;

Line 513: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Existing OTS Inbound Foo Function');

509: foo_action_param := constructparam;
510: p_action_param := foo_action_param;
511: END IF;
512: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
513: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Existing OTS Inbound Foo Function');
514: END IF;
515: END handleOTSInbound;
516: PROCEDURE handleEmail (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
517: p_action_type OUT NOCOPY NUMBER,

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

525: p_action_name OUT NOCOPY VARCHAR2,
526: p_action_param OUT NOCOPY VARCHAR2) IS
527: BEGIN
528: IF (G_DEBUG_ENABLED = 'Y') THEN
529: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
530: END IF;
531: p_action_type :=1;
532: p_action_name := G_Currentform;
533: p_action_param := '';

Line 535: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside OTS outbound Foo function');

531: p_action_type :=1;
532: p_action_name := G_Currentform;
533: p_action_param := '';
534: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
535: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Inside OTS outbound Foo function');
536: END IF;
537: setDefaults;
538: getCallData(p_mediaTable);
539: p_action_param := constructparam;

Line 541: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Exiting OTS Outbound Foo function');

537: setDefaults;
538: getCallData(p_mediaTable);
539: p_action_param := constructparam;
540: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
541: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Exiting OTS Outbound Foo function');
542: END IF;
543: END handleOTSOutbound ;
544: PROCEDURE handleOCInbound (p_mediaTable IN SYSTEM.IEU_UWQ_MEDIA_DATA_NST,
545: p_action_type OUT NOCOPY NUMBER,