DBA Data[Home] [Help]

APPS.IBY_AMOUNT_IN_WORDS dependencies on FND_LOG

Line 74: debug_level => FND_LOG.LEVEL_PROCEDURE,

70:
71: BEGIN
72:
73: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
74: debug_level => FND_LOG.LEVEL_PROCEDURE,
75: module => l_Debug_Module);
76:
77: iby_debug_pub.add(debug_msg => 'p_amount: ' || p_amount,
78: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 78: debug_level => FND_LOG.LEVEL_STATEMENT,

74: debug_level => FND_LOG.LEVEL_PROCEDURE,
75: module => l_Debug_Module);
76:
77: iby_debug_pub.add(debug_msg => 'p_amount: ' || p_amount,
78: debug_level => FND_LOG.LEVEL_STATEMENT,
79: module => l_Debug_Module);
80:
81: iby_debug_pub.add(debug_msg => 'p_currency_code: ' || p_currency_code,
82: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 82: debug_level => FND_LOG.LEVEL_STATEMENT,

78: debug_level => FND_LOG.LEVEL_STATEMENT,
79: module => l_Debug_Module);
80:
81: iby_debug_pub.add(debug_msg => 'p_currency_code: ' || p_currency_code,
82: debug_level => FND_LOG.LEVEL_STATEMENT,
83: module => l_Debug_Module);
84:
85: iby_debug_pub.add(debug_msg => 'p_precision: ' || p_precision,
86: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 86: debug_level => FND_LOG.LEVEL_STATEMENT,

82: debug_level => FND_LOG.LEVEL_STATEMENT,
83: module => l_Debug_Module);
84:
85: iby_debug_pub.add(debug_msg => 'p_precision: ' || p_precision,
86: debug_level => FND_LOG.LEVEL_STATEMENT,
87: module => l_Debug_Module);
88:
89: iby_debug_pub.add(debug_msg => 'p_country_code: ' || p_country_code,
90: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 90: debug_level => FND_LOG.LEVEL_STATEMENT,

86: debug_level => FND_LOG.LEVEL_STATEMENT,
87: module => l_Debug_Module);
88:
89: iby_debug_pub.add(debug_msg => 'p_country_code: ' || p_country_code,
90: debug_level => FND_LOG.LEVEL_STATEMENT,
91: module => l_Debug_Module);
92:
93: IF p_currency_code ='MXN' THEN
94: RETURN AMOUNT_WORDS_MEXICAN (p_amount, nvl(p_precision, 0));

Line 144: debug_level => FND_LOG.LEVEL_STATEMENT,

140: l_unit_sub_singular_msg_name := l_unit_sub_singular_msg_name || p_currency_code;
141: l_unit_sub_plural_msg_name := l_unit_sub_plural_msg_name || p_currency_code;
142:
143: iby_debug_pub.add(debug_msg => 'formulated message names: ',
144: debug_level => FND_LOG.LEVEL_STATEMENT,
145: module => l_Debug_Module);
146:
147: iby_debug_pub.add(debug_msg => 'l_unit_singular_msg_name: ' || l_unit_singular_msg_name,
148: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 148: debug_level => FND_LOG.LEVEL_STATEMENT,

144: debug_level => FND_LOG.LEVEL_STATEMENT,
145: module => l_Debug_Module);
146:
147: iby_debug_pub.add(debug_msg => 'l_unit_singular_msg_name: ' || l_unit_singular_msg_name,
148: debug_level => FND_LOG.LEVEL_STATEMENT,
149: module => l_Debug_Module);
150:
151: iby_debug_pub.add(debug_msg => 'l_unit_plural_msg_name: ' || l_unit_plural_msg_name,
152: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 152: debug_level => FND_LOG.LEVEL_STATEMENT,

148: debug_level => FND_LOG.LEVEL_STATEMENT,
149: module => l_Debug_Module);
150:
151: iby_debug_pub.add(debug_msg => 'l_unit_plural_msg_name: ' || l_unit_plural_msg_name,
152: debug_level => FND_LOG.LEVEL_STATEMENT,
153: module => l_Debug_Module);
154:
155: iby_debug_pub.add(debug_msg => 'l_unit_sub_singular_msg_name: ' || l_unit_sub_singular_msg_name,
156: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 156: debug_level => FND_LOG.LEVEL_STATEMENT,

152: debug_level => FND_LOG.LEVEL_STATEMENT,
153: module => l_Debug_Module);
154:
155: iby_debug_pub.add(debug_msg => 'l_unit_sub_singular_msg_name: ' || l_unit_sub_singular_msg_name,
156: debug_level => FND_LOG.LEVEL_STATEMENT,
157: module => l_Debug_Module);
158:
159: iby_debug_pub.add(debug_msg => 'l_unit_sub_plural_msg_name: ' || l_unit_sub_plural_msg_name,
160: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 160: debug_level => FND_LOG.LEVEL_STATEMENT,

156: debug_level => FND_LOG.LEVEL_STATEMENT,
157: module => l_Debug_Module);
158:
159: iby_debug_pub.add(debug_msg => 'l_unit_sub_plural_msg_name: ' || l_unit_sub_plural_msg_name,
160: debug_level => FND_LOG.LEVEL_STATEMENT,
161: module => l_Debug_Module);
162:
163: BEGIN
164: fnd_message.set_name('IBY', l_unit_singular_msg_name);

Line 173: debug_level => FND_LOG.LEVEL_STATEMENT,

169: END IF;
170:
171: iby_debug_pub.add(debug_msg => 'Got translated text for ' || l_unit_singular_msg_name
172: || ': ' || l_unit_singular_str,
173: debug_level => FND_LOG.LEVEL_STATEMENT,
174: module => l_Debug_Module);
175:
176: EXCEPTION
177: WHEN OTHERS THEN

Line 192: debug_level => FND_LOG.LEVEL_STATEMENT,

188: END IF;
189:
190: iby_debug_pub.add(debug_msg => 'Got translated text for ' || l_unit_plural_msg_name
191: || ': ' || l_unit_plural_str,
192: debug_level => FND_LOG.LEVEL_STATEMENT,
193: module => l_Debug_Module);
194:
195: EXCEPTION
196: WHEN OTHERS THEN

Line 210: debug_level => FND_LOG.LEVEL_STATEMENT,

206: END IF;
207:
208: iby_debug_pub.add(debug_msg => 'Got translated text for ' || l_unit_sub_singular_msg_name
209: || ': ' || l_unit_sub_singular_str,
210: debug_level => FND_LOG.LEVEL_STATEMENT,
211: module => l_Debug_Module);
212:
213: EXCEPTION
214: WHEN OTHERS THEN

Line 228: debug_level => FND_LOG.LEVEL_STATEMENT,

224: END IF;
225:
226: iby_debug_pub.add(debug_msg => 'Got translated text for ' || l_unit_sub_plural_msg_name
227: || ': ' || l_unit_sub_plural_str,
228: debug_level => FND_LOG.LEVEL_STATEMENT,
229: module => l_Debug_Module);
230:
231: EXCEPTION
232: WHEN OTHERS THEN

Line 241: debug_level => FND_LOG.LEVEL_STATEMENT,

237: IF p_precision IS NULL THEN
238:
239: IF p_currency_code IS NULL THEN
240: iby_debug_pub.add(debug_msg => 'Warning: p_precision and p_currency_code are both null! ',
241: debug_level => FND_LOG.LEVEL_STATEMENT,
242: module => l_Debug_Module);
243: ELSE
244:
245: OPEN l_precision_csr (p_currency_code);

Line 256: debug_level => FND_LOG.LEVEL_STATEMENT,

252: l_precision := p_precision;
253: END IF;
254:
255: iby_debug_pub.add(debug_msg => 'l_precision: ' || l_precision,
256: debug_level => FND_LOG.LEVEL_STATEMENT,
257: module => l_Debug_Module);
258:
259: IF l_precision = 1 THEN
260: l_unit_ratio := 10;

Line 294: debug_level => FND_LOG.LEVEL_STATEMENT,

290: l_word_text := rpad(l_word_text,l_width*3,'*');
291: end if;
292:
293: iby_debug_pub.add(debug_msg => 'Amount text: ' || l_word_text,
294: debug_level => FND_LOG.LEVEL_STATEMENT,
295: module => l_Debug_Module);
296:
297: return(l_word_text);
298:

Line 302: debug_level => FND_LOG.LEVEL_STATEMENT,

298:
299: EXCEPTION
300: WHEN OTHERS THEN
301: iby_debug_pub.add(debug_msg => 'Error in getting amount text. Returning null.',
302: debug_level => FND_LOG.LEVEL_STATEMENT,
303: module => l_Debug_Module);
304: RETURN NULL;
305:
306: END APXPBFOR_C_WORD_AMOUNTFormula;

Line 394: debug_level => FND_LOG.LEVEL_STATEMENT,

390: where lookup_code = to_char(p_num)
391: and lookup_type = 'NUMBERS';
392:
393: iby_debug_pub.add(debug_msg => 'Adding to lookup cache ' || p_num || ': ' || g_numlookup(p_num),
394: debug_level => FND_LOG.LEVEL_STATEMENT,
395: module => G_DEBUG_MODULE || '.Lookup_num');
396:
397: RETURN g_numlookup(p_num);
398: END;

Line 421: debug_level => FND_LOG.LEVEL_PROCEDURE,

417:
418: BEGIN
419:
420: iby_debug_pub.add(debug_msg => 'Enter: ' || l_Debug_Module,
421: debug_level => FND_LOG.LEVEL_PROCEDURE,
422: module => l_Debug_Module);
423:
424: if numeral >= power(10,max_digit) then
425: raise number_too_large;

Line 433: debug_level => FND_LOG.LEVEL_STATEMENT,

429: into session_language
430: from dual;
431:
432: iby_debug_pub.add(debug_msg => 'numeral: ' || numeral,
433: debug_level => FND_LOG.LEVEL_STATEMENT,
434: module => l_Debug_Module);
435:
436: iby_debug_pub.add(debug_msg => 'session_language: ' || session_language,
437: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 437: debug_level => FND_LOG.LEVEL_STATEMENT,

433: debug_level => FND_LOG.LEVEL_STATEMENT,
434: module => l_Debug_Module);
435:
436: iby_debug_pub.add(debug_msg => 'session_language: ' || session_language,
437: debug_level => FND_LOG.LEVEL_STATEMENT,
438: module => l_Debug_Module);
439:
440: IF g_user_lang <> session_language THEN
441:

Line 443: debug_level => FND_LOG.LEVEL_STATEMENT,

439:
440: IF g_user_lang <> session_language THEN
441:
442: iby_debug_pub.add(debug_msg => 'g_user_lang <> session_language, caching lookups ',
443: debug_level => FND_LOG.LEVEL_STATEMENT,
444: module => l_Debug_Module);
445:
446: g_user_lang := session_language;
447:

Line 490: debug_level => FND_LOG.LEVEL_STATEMENT,

486:
487: units_segN := mod(numeral,thousand);
488:
489: iby_debug_pub.add(debug_msg => 'billion_segN: ' || billion_segN,
490: debug_level => FND_LOG.LEVEL_STATEMENT,
491: module => l_Debug_Module);
492:
493: iby_debug_pub.add(debug_msg => 'million_segN: ' || million_segN,
494: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 494: debug_level => FND_LOG.LEVEL_STATEMENT,

490: debug_level => FND_LOG.LEVEL_STATEMENT,
491: module => l_Debug_Module);
492:
493: iby_debug_pub.add(debug_msg => 'million_segN: ' || million_segN,
494: debug_level => FND_LOG.LEVEL_STATEMENT,
495: module => l_Debug_Module);
496:
497: iby_debug_pub.add(debug_msg => 'thousand_segN: ' || thousand_segN,
498: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 498: debug_level => FND_LOG.LEVEL_STATEMENT,

494: debug_level => FND_LOG.LEVEL_STATEMENT,
495: module => l_Debug_Module);
496:
497: iby_debug_pub.add(debug_msg => 'thousand_segN: ' || thousand_segN,
498: debug_level => FND_LOG.LEVEL_STATEMENT,
499: module => l_Debug_Module);
500:
501: iby_debug_pub.add(debug_msg => 'units_segN: ' || units_segN,
502: debug_level => FND_LOG.LEVEL_STATEMENT,

Line 502: debug_level => FND_LOG.LEVEL_STATEMENT,

498: debug_level => FND_LOG.LEVEL_STATEMENT,
499: module => l_Debug_Module);
500:
501: iby_debug_pub.add(debug_msg => 'units_segN: ' || units_segN,
502: debug_level => FND_LOG.LEVEL_STATEMENT,
503: module => l_Debug_Module);
504:
505: if billion_segN <> 0 then
506: number_text := number_text||Lookup_num(billion_segN) ||c_billion;

Line 534: debug_level => FND_LOG.LEVEL_STATEMENT,

530: number_text := upper(substr(number_text,1,1)) ||
531: rtrim(lower(substr(number_text,2,length(number_text))));
532:
533: iby_debug_pub.add(debug_msg => 'returning number_text: ' || number_text,
534: debug_level => FND_LOG.LEVEL_STATEMENT,
535: module => l_Debug_Module);
536:
537: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
538: debug_level => FND_LOG.LEVEL_PROCEDURE,

Line 538: debug_level => FND_LOG.LEVEL_PROCEDURE,

534: debug_level => FND_LOG.LEVEL_STATEMENT,
535: module => l_Debug_Module);
536:
537: iby_debug_pub.add(debug_msg => 'Exit: ' || l_Debug_Module,
538: debug_level => FND_LOG.LEVEL_PROCEDURE,
539: module => l_Debug_Module);
540:
541: return(number_text);
542: