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 53: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

49: and roles.status ='A'
50: and party.status='A'
51: and fnd.user_id=lUserID;
52: --
53: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
54: --
55: BEGIN
56: IF (C_Party%ISOPEN) THEN
57: CLOSE C_Party;

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

75:
76: lvContactID varchar2(80);
77:
78: --
79: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
80: --
81: Begin
82:
83:

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

158: pTokenValue4 varchar2 DEFAULT NULL,
159: pTokenName5 varchar2 DEFAULT NULL,
160: pTokenValue5 varchar2 DEFAULT NULL) return varchar2 is
161: --
162: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
163: --
164: begin
165:
166: FND_MESSAGE.SET_NAME('ONT',pMsgName);

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

192: function getRecCount(pCurrent number,
193: pPageTot number,
194: pTotal number) return varchar2 is
195: --
196: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
197: --
198: begin
199: return(getMessage('ONT_RECORD_COUNT','FIRSTREC',pCurrent,'LASTREC',pPageTot,'TOTALREC',pTotal));
200: end getRecCount;

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

269: l_min_acct_unit NUMBER;
270: l_precision_type VARCHAR2(30);
271: l_format_mask VARCHAR2(240);
272: --
273: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
274: --
275:
276: BEGIN
277:

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

275:
276: BEGIN
277:
278: IF l_debug_level > 0 THEN
279: oe_debug_pub.add('Entering ONT_OIP_COMMON.get_price_formatted ');
280: END IF ;
281:
282: FND_CURRENCY.GET_INFO(Currency_Code => p_transactional_curr_code,
283: precision => l_precision,

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

284: ext_precision => l_ext_precision,
285: min_acct_unit => l_min_acct_unit );
286:
287: IF l_debug_level > 0 THEN
288: oe_debug_pub.add('precision: '|| l_precision );
289: oe_debug_pub.add('ext precision: '|| l_ext_precision );
290: END IF;
291:
292: fnd_profile.get('ONT_UNIT_PRICE_PRECISION_TYPE', l_precision_type);

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

285: min_acct_unit => l_min_acct_unit );
286:
287: IF l_debug_level > 0 THEN
288: oe_debug_pub.add('precision: '|| l_precision );
289: oe_debug_pub.add('ext precision: '|| l_ext_precision );
290: END IF;
291:
292: fnd_profile.get('ONT_UNIT_PRICE_PRECISION_TYPE', l_precision_type);
293:

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

291:
292: fnd_profile.get('ONT_UNIT_PRICE_PRECISION_TYPE', l_precision_type);
293:
294: IF l_debug_level > 0 THEN
295: oe_debug_pub.add('precision_type: '|| l_precision_type);
296: END IF;
297:
298: IF (l_precision_type = 'EXTENDED') THEN
299:

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

313: ,disp_grp_sep => TRUE);
314: END IF;
315:
316: IF l_debug_level > 0 THEN
317: oe_debug_pub.add('l_format_mask: '|| l_format_mask );
318: END IF;
319:
320: BEGIN
321: select To_Char(p_price*decode(p_line_category_code,'RETURN',-1,1),l_format_mask)

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

323: from dual;
324: END;
325:
326: IF l_debug_level > 0 THEN
327: oe_debug_pub.add('x_price_formatted '|| x_price_formatted,1 );
328: oe_debug_pub.add('Exiting ONT_OIP_COMMON.get_price_formatted ',1);
329: END IF;
330:
331: END Get_Price_formatted;

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

324: END;
325:
326: IF l_debug_level > 0 THEN
327: oe_debug_pub.add('x_price_formatted '|| x_price_formatted,1 );
328: oe_debug_pub.add('Exiting ONT_OIP_COMMON.get_price_formatted ',1);
329: END IF;
330:
331: END Get_Price_formatted;
332: