DBA Data[Home] [Help]

APPS.ONT_OIP_COMMON dependencies on OE_DEBUG_PUB

Line 7: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

3:
4: procedure getContactId(lContactid in out NOCOPY varchar2) is
5: xContactId number;
6: --
7: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
8: --
9: BEGIN
10: if (xContactId is not null) then
11: lContactId:=XContactId;

Line 56: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

52:
53: lActiveHolds VARCHAR2(2000);
54:
55: --
56: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
57: --
58:
59: BEGIN
60:

Line 100: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

96:
97: lSystemNames VARCHAR2(2000);
98:
99: --
100: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
101: --
102:
103: BEGIN
104:

Line 244: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

240: lCustomerIdList VARCHAR2(1000) := '';
241: lRecCount NUMBER := 0;
242:
243: --
244: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
245: --
246: BEGIN
247: IF (C_Party%ISOPEN) THEN
248: CLOSE C_Party;

Line 345: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

341: AND cust.party_id=party.party_id
342: AND fnd.user_id=lUserID;
343:
344: --
345: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
346: --
347: BEGIN
348: IF (C_Party%ISOPEN) THEN
349: CLOSE C_Party;

Line 371: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

367:
368: lvContactID varchar2(80);
369:
370: --
371: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
372: --
373: Begin
374:
375:

Line 454: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

450: pTokenValue4 varchar2 DEFAULT NULL,
451: pTokenName5 varchar2 DEFAULT NULL,
452: pTokenValue5 varchar2 DEFAULT NULL) return varchar2 is
453: --
454: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
455: --
456: begin
457:
458: FND_MESSAGE.SET_NAME('ONT',pMsgName);

Line 488: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

484: function getRecCount(pCurrent number,
485: pPageTot number,
486: pTotal number) return varchar2 is
487: --
488: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
489: --
490: begin
491: return(getMessage('ONT_RECORD_COUNT','FIRSTREC',pCurrent,'LASTREC',pPageTot,'TOTALREC',pTotal));
492: end getRecCount;

Line 565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

561: l_min_acct_unit NUMBER;
562: l_precision_type VARCHAR2(30);
563: l_format_mask VARCHAR2(240);
564: --
565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
566: --
567:
568: BEGIN
569:

Line 571: oe_debug_pub.add('Entering ONT_OIP_COMMON.get_price_formatted ');

567:
568: BEGIN
569:
570: IF l_debug_level > 0 THEN
571: oe_debug_pub.add('Entering ONT_OIP_COMMON.get_price_formatted ');
572: END IF ;
573:
574: FND_CURRENCY.GET_INFO(Currency_Code => p_transactional_curr_code,
575: precision => l_precision,

Line 580: oe_debug_pub.add('precision: '|| l_precision );

576: ext_precision => l_ext_precision,
577: min_acct_unit => l_min_acct_unit );
578:
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add('precision: '|| l_precision );
581: oe_debug_pub.add('ext precision: '|| l_ext_precision );
582: END IF;
583:
584: fnd_profile.get('ONT_UNIT_PRICE_PRECISION_TYPE', l_precision_type);

Line 581: oe_debug_pub.add('ext precision: '|| l_ext_precision );

577: min_acct_unit => l_min_acct_unit );
578:
579: IF l_debug_level > 0 THEN
580: oe_debug_pub.add('precision: '|| l_precision );
581: oe_debug_pub.add('ext precision: '|| l_ext_precision );
582: END IF;
583:
584: fnd_profile.get('ONT_UNIT_PRICE_PRECISION_TYPE', l_precision_type);
585:

Line 587: oe_debug_pub.add('precision_type: '|| l_precision_type);

583:
584: fnd_profile.get('ONT_UNIT_PRICE_PRECISION_TYPE', l_precision_type);
585:
586: IF l_debug_level > 0 THEN
587: oe_debug_pub.add('precision_type: '|| l_precision_type);
588: END IF;
589:
590: IF (l_precision_type = 'EXTENDED') THEN
591:

Line 609: oe_debug_pub.add('l_format_mask: '|| l_format_mask );

605: ,disp_grp_sep => TRUE);
606: END IF;
607:
608: IF l_debug_level > 0 THEN
609: oe_debug_pub.add('l_format_mask: '|| l_format_mask );
610: END IF;
611:
612: BEGIN
613: select To_Char(p_price*decode(p_line_category_code,'RETURN',-1,1),l_format_mask)

Line 619: oe_debug_pub.add('x_price_formatted '|| x_price_formatted,1 );

615: from dual;
616: END;
617:
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add('x_price_formatted '|| x_price_formatted,1 );
620: oe_debug_pub.add('Exiting ONT_OIP_COMMON.get_price_formatted ',1);
621: END IF;
622:
623: END Get_Price_formatted;

Line 620: oe_debug_pub.add('Exiting ONT_OIP_COMMON.get_price_formatted ',1);

616: END;
617:
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add('x_price_formatted '|| x_price_formatted,1 );
620: oe_debug_pub.add('Exiting ONT_OIP_COMMON.get_price_formatted ',1);
621: END IF;
622:
623: END Get_Price_formatted;
624: