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.AR_GTA_TRX_UTIL dependencies on FND_LOG

Line 175: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

171: ) --Change the type of p_fp_tax_registration_num from NUMBER to VARCHAR2 for bug 13812077
172: RETURN VARCHAR2
173: IS
174: l_procedure_name VARCHAR2(30) := 'get_invoice_type';
175: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
176: l_proc_level NUMBER := fnd_log.LEVEL_PROCEDURE;
177: l_error_string VARCHAR2(1000);
178:
179: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;

Line 176: l_proc_level NUMBER := fnd_log.LEVEL_PROCEDURE;

172: RETURN VARCHAR2
173: IS
174: l_procedure_name VARCHAR2(30) := 'get_invoice_type';
175: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
176: l_proc_level NUMBER := fnd_log.LEVEL_PROCEDURE;
177: l_error_string VARCHAR2(1000);
178:
179: l_invoice_type ar_gta_tax_limits_all.invoice_type%TYPE;
180: l_class_code hz_code_assignments.CLASS_CODE%TYPE;

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

200:
201: RETURN(l_invoice_type);
202: */
203:
204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
206: G_MODULE_PREFIX || l_procedure_name,
207: 'begin Procedure. ');
208: END IF;

Line 205: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

201: RETURN(l_invoice_type);
202: */
203:
204: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
205: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
206: G_MODULE_PREFIX || l_procedure_name,
207: 'begin Procedure. ');
208: END IF;
209:

Line 257: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

253: AND h.customer_trx_id = p_customer_trx_id;
254: EXCEPTION
255: WHEN no_data_found THEN
256: l_invoice_type := NULL;
257: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
258: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
259: ,G_MODULE_PREFIX || l_procedure_name
260: , 'tax classification is not defined at any level.');
261: END IF;

Line 258: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

254: EXCEPTION
255: WHEN no_data_found THEN
256: l_invoice_type := NULL;
257: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
258: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
259: ,G_MODULE_PREFIX || l_procedure_name
260: , 'tax classification is not defined at any level.');
261: END IF;
262: --RAISE;--Yao zhang Modified for bug 14580597

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

278: ELSIF l_class_code = 'AR_GTA_SMALL_SCALE_TAXPAYER' THEN
279: l_invoice_type := '2'; -- 'COMMON';
280: END IF;
281:
282: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
283: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
284: G_MODULE_PREFIX || l_procedure_name,
285: 'End Procedure. ');
286: END IF;

Line 283: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,

279: l_invoice_type := '2'; -- 'COMMON';
280: END IF;
281:
282: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
283: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE,
284: G_MODULE_PREFIX || l_procedure_name,
285: 'End Procedure. ');
286: END IF;
287:

Line 292: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

288: RETURN(l_invoice_type);
289:
290: EXCEPTION
291: WHEN OTHERS THEN
292: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
294: G_MODULE_PREFIX || l_procedure_name ||
295: '. OTHER_EXCEPTION',
296: SQLCODE || SQLERRM);

Line 293: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

289:
290: EXCEPTION
291: WHEN OTHERS THEN
292: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
293: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
294: G_MODULE_PREFIX || l_procedure_name ||
295: '. OTHER_EXCEPTION',
296: SQLCODE || SQLERRM);
297: END IF;

Line 321: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

317: PROCEDURE log
318: (p_message IN VARCHAR2)
319: IS
320: BEGIN
321: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
322: THEN
323: fnd_log.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE
324: ,MODULE => g_module_prefix || '.Debug'
325: ,MESSAGE => p_message

Line 323: fnd_log.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE

319: IS
320: BEGIN
321: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
322: THEN
323: fnd_log.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE
324: ,MODULE => g_module_prefix || '.Debug'
325: ,MESSAGE => p_message
326: );
327: END IF;

Line 559: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

555: BEGIN
556: fnd_file.put_line(FND_FILE.LOG,
557: g_module_prefix || l_procedure_name ||
558: '----001 ');
559: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
560: THEN
561: fnd_log.STRING(fnd_log.level_procedure
562: ,g_module_prefix || l_procedure_name
563: ,'Begin Procedure. ');

Line 561: fnd_log.STRING(fnd_log.level_procedure

557: g_module_prefix || l_procedure_name ||
558: '----001 ');
559: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
560: THEN
561: fnd_log.STRING(fnd_log.level_procedure
562: ,g_module_prefix || l_procedure_name
563: ,'Begin Procedure. ');
564: END IF;
565: -- begin log

Line 566: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

562: ,g_module_prefix || l_procedure_name
563: ,'Begin Procedure. ');
564: END IF;
565: -- begin log
566: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
567: THEN
568: log( 'begin create_trxs '||p_gta_trxs.COUNT);
569: END IF;
570: -- end log

Line 583: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

579: l_index := l_gta_trx_tbl.NEXT(l_index);
580:
581: END LOOP;
582:
583: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
584: THEN
585: fnd_log.STRING(fnd_log.level_procedure
586: ,g_module_prefix || l_procedure_name
587: ,'End Procedure. ');

Line 585: fnd_log.STRING(fnd_log.level_procedure

581: END LOOP;
582:
583: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
584: THEN
585: fnd_log.STRING(fnd_log.level_procedure
586: ,g_module_prefix || l_procedure_name
587: ,'End Procedure. ');
588: END IF;
589: fnd_file.put_line(FND_FILE.LOG,

Line 595: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level

591: '----002 ');
592:
593: EXCEPTION
594: WHEN OTHERS THEN
595: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
596: THEN
597: fnd_log.STRING(fnd_log.level_unexpected
598: ,g_module_prefix || l_procedure_name ||
599: '. OTHER_EXCEPTION '

Line 597: fnd_log.STRING(fnd_log.level_unexpected

593: EXCEPTION
594: WHEN OTHERS THEN
595: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
596: THEN
597: fnd_log.STRING(fnd_log.level_unexpected
598: ,g_module_prefix || l_procedure_name ||
599: '. OTHER_EXCEPTION '
600: ,SQLCODE || SQLERRM);
601: END IF;

Line 642: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

638: l_count NUMBER;
639:
640: BEGIN
641:
642: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
643: THEN
644: fnd_log.STRING(fnd_log.level_procedure
645: ,g_module_prefix || l_procedure_name
646: ,'Begin Procedure. ');

Line 644: fnd_log.STRING(fnd_log.level_procedure

640: BEGIN
641:
642: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
643: THEN
644: fnd_log.STRING(fnd_log.level_procedure
645: ,g_module_prefix || l_procedure_name
646: ,'Begin Procedure. ');
647: END IF;
648:

Line 650: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

646: ,'Begin Procedure. ');
647: END IF;
648:
649: -- begin log
650: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
651: THEN
652: log('begin create_trx '||p_gta_trx.trx_header.ra_trx_id);
653: END IF;
654: -- end log

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

742: l_count := p_gta_trx.trx_lines.FIRST;
743: WHILE l_count IS NOT NULL
744: LOOP
745: -- begin log
746: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
747: THEN
748: log( 'begin create_trx_line '||p_gta_trx.trx_lines(l_count).ar_trx_line_id);
749: END IF;
750: -- end log

Line 814: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

810:
811: l_count := p_gta_trx.trx_lines.NEXT(l_count);
812: END LOOP;
813:
814: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
815: THEN
816: fnd_log.STRING(fnd_log.level_procedure
817: ,g_module_prefix || l_procedure_name
818: ,'End Procedure. ');

Line 816: fnd_log.STRING(fnd_log.level_procedure

812: END LOOP;
813:
814: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
815: THEN
816: fnd_log.STRING(fnd_log.level_procedure
817: ,g_module_prefix || l_procedure_name
818: ,'End Procedure. ');
819: END IF;
820:

Line 823: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

819: END IF;
820:
821: EXCEPTION
822: WHEN dup_val_on_index THEN
823: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
824: THEN
825: fnd_log.STRING(fnd_log.level_unexpected
826: ,g_module_prefix || l_procedure_name ||
827: '. dup_val_on_index '

Line 825: fnd_log.STRING(fnd_log.level_unexpected

821: EXCEPTION
822: WHEN dup_val_on_index THEN
823: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
824: THEN
825: fnd_log.STRING(fnd_log.level_unexpected
826: ,g_module_prefix || l_procedure_name ||
827: '. dup_val_on_index '
828: ,SQLCODE || SQLERRM);
829: END IF;

Line 832: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

828: ,SQLCODE || SQLERRM);
829: END IF;
830:
831: WHEN OTHERS THEN
832: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
833: THEN
834: fnd_log.STRING(fnd_log.level_unexpected
835: ,g_module_prefix || l_procedure_name ||
836: '. OTHER_EXCEPTION '

Line 834: fnd_log.STRING(fnd_log.level_unexpected

830:
831: WHEN OTHERS THEN
832: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
833: THEN
834: fnd_log.STRING(fnd_log.level_unexpected
835: ,g_module_prefix || l_procedure_name ||
836: '. OTHER_EXCEPTION '
837: ,'Exception occur when insert data into database' ||
838: SQLCODE || SQLERRM);

Line 841: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

837: ,'Exception occur when insert data into database' ||
838: SQLCODE || SQLERRM);
839:
840: -- begin log
841: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
842: THEN
843: log( 'Exception occur when insert data into database' ||SQLCODE || SQLERRM);
844: END IF;
845: -- end log

Line 886: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

882: FROM ar_gta_trx_lines_all
883: WHERE gta_trx_header_id = l_header_id;
884:
885: BEGIN
886: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
887: THEN
888: fnd_log.STRING(fnd_log.level_procedure
889: ,g_module_prefix || l_procedure_name
890: ,'Begin Procedure. ');

Line 888: fnd_log.STRING(fnd_log.level_procedure

884:
885: BEGIN
886: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
887: THEN
888: fnd_log.STRING(fnd_log.level_procedure
889: ,g_module_prefix || l_procedure_name
890: ,'Begin Procedure. ');
891: END IF;
892: --get trx header

Line 906: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

902: LOOP
903: FETCH c_trx_lines INTO l_gta_trx_line_id;
904: EXIT WHEN c_trx_lines%NOTFOUND;
905:
906: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
907: THEN
908: log('get trx_line_id: '||l_gta_trx_line_id);
909: END IF;
910: l_trx_rec.trx_lines.EXTEND;

Line 920: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

916: CLOSE c_trx_lines;
917: -- end log
918: x_trx_rec:=l_trx_rec;
919: --log for debug
920: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
921: THEN
922:
923: FND_LOG.String(fnd_log.level_procedure
924: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'

Line 923: FND_LOG.String(fnd_log.level_procedure

919: --log for debug
920: IF(fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
921: THEN
922:
923: FND_LOG.String(fnd_log.level_procedure
924: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
925: ,'Exit procedure'
926: );
927:

Line 1160: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1156: AND tax_currency_code=l_gt_currency_code
1157: AND event_class_code IN ('INVOICE','CREDIT_MEMO','DEBIT_MEMO')--jogen bug5212702 May-17,2006
1158: AND trx_id=pc_trx_id; --jogen bug5212702 May-17,2006
1159:
1160: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1161: l_proc_level NUMBER := fnd_log.level_procedure;
1162: l_procedure_name VARCHAR2(30) := 'Check_Taxcount_Of_Arline';
1163:
1164: BEGIN

Line 1161: l_proc_level NUMBER := fnd_log.level_procedure;

1157: AND event_class_code IN ('INVOICE','CREDIT_MEMO','DEBIT_MEMO')--jogen bug5212702 May-17,2006
1158: AND trx_id=pc_trx_id; --jogen bug5212702 May-17,2006
1159:
1160: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1161: l_proc_level NUMBER := fnd_log.level_procedure;
1162: l_procedure_name VARCHAR2(30) := 'Check_Taxcount_Of_Arline';
1163:
1164: BEGIN
1165: --logging for debug

Line 1168: fnd_log.STRING(l_proc_level

1164: BEGIN
1165: --logging for debug
1166: IF (l_proc_level >= l_dbg_level)
1167: THEN
1168: fnd_log.STRING(l_proc_level
1169: ,g_module_prefix || l_procedure_name || '.begin'
1170: ,'Enter function');
1171: END IF; --l_proc_level>=l_dbg_level)
1172:

Line 1198: fnd_log.STRING(l_proc_level

1194:
1195: --logging for debug
1196: IF (l_proc_level >= l_dbg_level)
1197: THEN
1198: fnd_log.STRING(l_proc_level
1199: ,g_module_prefix || l_procedure_name || '.End'
1200: ,'Exit function');
1201: END IF; --l_proc_level>=l_dbg_level)
1202:

Line 1280: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1276: HAVING COUNT(*)>1);
1277:
1278:
1279:
1280: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1281: l_proc_level NUMBER := fnd_log.level_procedure;
1282: l_procedure_name VARCHAR2(30) := 'Check_Taxcount_Of_Artrx';
1283:
1284: BEGIN

Line 1281: l_proc_level NUMBER := fnd_log.level_procedure;

1277:
1278:
1279:
1280: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1281: l_proc_level NUMBER := fnd_log.level_procedure;
1282: l_procedure_name VARCHAR2(30) := 'Check_Taxcount_Of_Artrx';
1283:
1284: BEGIN
1285: --logging for debug

Line 1288: fnd_log.STRING(l_proc_level

1284: BEGIN
1285: --logging for debug
1286: IF (l_proc_level >= l_dbg_level)
1287: THEN
1288: fnd_log.STRING(l_proc_level
1289: ,g_module_prefix || l_procedure_name || '.begin'
1290: ,'Enter function');
1291: END IF; --l_proc_level>=l_dbg_level)
1292:

Line 1308: fnd_log.STRING(l_proc_level

1304:
1305: --logging for debug
1306: IF (l_proc_level >= l_dbg_level)
1307: THEN
1308: fnd_log.STRING(l_proc_level
1309: ,g_module_prefix || l_procedure_name || '.End'
1310: ,'Exit function');
1311: END IF; --l_proc_level>=l_dbg_level)
1312:

Line 1353: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1349: )
1350: RETURN NUMBER
1351: IS
1352: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Amount';
1353: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1354: l_proc_level NUMBER := fnd_log.level_procedure;
1355:
1356: l_tax_type_code zx_lines.tax_type_code%TYPE;
1357: l_gt_currency_code fnd_currencies.currency_code%TYPE;

Line 1354: l_proc_level NUMBER := fnd_log.level_procedure;

1350: RETURN NUMBER
1351: IS
1352: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Amount';
1353: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1354: l_proc_level NUMBER := fnd_log.level_procedure;
1355:
1356: l_tax_type_code zx_lines.tax_type_code%TYPE;
1357: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1358: l_ar_taxable_amount NUMBER;

Line 1389: fnd_log.STRING(l_proc_level

1385: BEGIN
1386: --logging for debug
1387: IF (l_proc_level >= l_dbg_level)
1388: THEN
1389: fnd_log.STRING(l_proc_level
1390: ,g_module_prefix || l_procedure_name || '.begin'
1391: ,'enter function');
1392: END IF;--(l_proc_level >= l_dbg_level)
1393:

Line 1409: fnd_log.STRING(l_proc_level

1405:
1406: --logging for debug
1407: IF (l_proc_level >= l_dbg_level)
1408: THEN
1409: fnd_log.STRING(l_proc_level
1410: ,g_module_prefix || l_procedure_name || '.end'
1411: ,'end function');
1412: END IF; --(l_proc_level >= l_dbg_level)
1413:

Line 1448: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1444: )
1445: RETURN NUMBER
1446: IS
1447: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Tax_Amount';
1448: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1449: l_proc_level NUMBER := fnd_log.level_procedure;
1450:
1451: l_tax_type_code zx_lines.tax_type_code%TYPE;
1452: l_gt_currency_code fnd_currencies.currency_code%TYPE;

Line 1449: l_proc_level NUMBER := fnd_log.level_procedure;

1445: RETURN NUMBER
1446: IS
1447: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Tax_Amount';
1448: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1449: l_proc_level NUMBER := fnd_log.level_procedure;
1450:
1451: l_tax_type_code zx_lines.tax_type_code%TYPE;
1452: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1453: l_ar_tax_amount NUMBER;

Line 1484: fnd_log.STRING(l_proc_level

1480: BEGIN
1481: --logging for debug
1482: IF (l_proc_level >= l_dbg_level)
1483: THEN
1484: fnd_log.STRING(l_proc_level
1485: ,g_module_prefix || l_procedure_name || '.begin'
1486: ,'enter function');
1487: END IF;--(l_proc_level >= l_dbg_level)
1488:

Line 1504: fnd_log.STRING(l_proc_level

1500:
1501: --logging for debug
1502: IF (l_proc_level >= l_dbg_level)
1503: THEN
1504: fnd_log.STRING(l_proc_level
1505: ,g_module_prefix || l_procedure_name || '.end'
1506: ,'end function');
1507: END IF; --(l_proc_level >= l_dbg_level)
1508:

Line 1577: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1573: --
1574: --===========================================================================
1575: FUNCTION format_date(p_date IN DATE) RETURN VARCHAR2 IS
1576: l_procedure_name VARCHAR2(30) := 'Format_Date';
1577: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1578: l_proc_level NUMBER := fnd_log.level_procedure;
1579: l_ret VARCHAR(40);
1580:
1581: l_date_format fnd_profile_option_values.profile_option_value%TYPE := NULL;

Line 1578: l_proc_level NUMBER := fnd_log.level_procedure;

1574: --===========================================================================
1575: FUNCTION format_date(p_date IN DATE) RETURN VARCHAR2 IS
1576: l_procedure_name VARCHAR2(30) := 'Format_Date';
1577: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1578: l_proc_level NUMBER := fnd_log.level_procedure;
1579: l_ret VARCHAR(40);
1580:
1581: l_date_format fnd_profile_option_values.profile_option_value%TYPE := NULL;
1582:

Line 1587: fnd_log.STRING(l_proc_level

1583: BEGIN
1584: --logging for debug
1585: IF (l_proc_level >= l_dbg_level)
1586: THEN
1587: fnd_log.STRING(l_proc_level
1588: ,g_module_prefix || l_procedure_name || '.begin'
1589: ,'enter function');
1590: END IF;
1591:

Line 1601: fnd_log.STRING(l_proc_level

1597:
1598: --logging for debug
1599: IF (l_proc_level >= l_dbg_level)
1600: THEN
1601: fnd_log.STRING(l_proc_level
1602: ,g_module_prefix || l_procedure_name || '.end'
1603: ,'end function');
1604: END IF;
1605:

Line 1664: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1660: )
1661: AND hcp.primary_flag = 'Y';
1662:
1663: l_procedure_name VARCHAR2(30) := 'Get_Primary_Phone_Number';
1664: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1665: l_proc_level NUMBER := fnd_log.level_procedure;
1666: BEGIN
1667:
1668: --logging for debug

Line 1665: l_proc_level NUMBER := fnd_log.level_procedure;

1661: AND hcp.primary_flag = 'Y';
1662:
1663: l_procedure_name VARCHAR2(30) := 'Get_Primary_Phone_Number';
1664: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1665: l_proc_level NUMBER := fnd_log.level_procedure;
1666: BEGIN
1667:
1668: --logging for debug
1669: IF (l_proc_level >= l_dbg_level)

Line 1671: fnd_log.STRING(l_proc_level

1667:
1668: --logging for debug
1669: IF (l_proc_level >= l_dbg_level)
1670: THEN
1671: fnd_log.STRING(l_proc_level
1672: ,g_module_prefix || l_procedure_name || '.begin'
1673: ,'Enter function');
1674: END IF; --l_proc_level>=l_dbg_level)
1675: OPEN c_phone_number;

Line 1683: fnd_log.STRING(l_proc_level

1679:
1680: --logging for debug
1681: IF (l_proc_level >= l_dbg_level)
1682: THEN
1683: fnd_log.STRING(l_proc_level
1684: ,g_module_prefix || l_procedure_name || '.End'
1685: ,'Exit function');
1686: END IF; --l_proc_level>=l_dbg_level)
1687:

Line 1715: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1711: -- 26-Dec-2005: Qiang Li fix a performance issue
1712: --=========================================================================
1713: FUNCTION get_operatingunit(p_org_id IN NUMBER) RETURN VARCHAR2 IS
1714: l_procedure_name VARCHAR2(30) := 'Get_OperatingUnit';
1715: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1716: l_proc_level NUMBER := fnd_log.level_procedure;
1717:
1718: l_operating_unit hr_operating_units.NAME%TYPE;
1719: CURSOR c_operating_unit IS

Line 1716: l_proc_level NUMBER := fnd_log.level_procedure;

1712: --=========================================================================
1713: FUNCTION get_operatingunit(p_org_id IN NUMBER) RETURN VARCHAR2 IS
1714: l_procedure_name VARCHAR2(30) := 'Get_OperatingUnit';
1715: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1716: l_proc_level NUMBER := fnd_log.level_procedure;
1717:
1718: l_operating_unit hr_operating_units.NAME%TYPE;
1719: CURSOR c_operating_unit IS
1720: SELECT OTL.NAME

Line 1731: fnd_log.STRING(l_proc_level

1727: BEGIN
1728: --logging for debug
1729: IF (l_proc_level >= l_dbg_level)
1730: THEN
1731: fnd_log.STRING(l_proc_level
1732: ,g_module_prefix || l_procedure_name || '.begin'
1733: ,'enter function');
1734: END IF;
1735:

Line 1747: fnd_log.STRING(l_proc_level

1743:
1744: --logging for debug
1745: IF (l_proc_level >= l_dbg_level)
1746: THEN
1747: fnd_log.STRING(l_proc_level
1748: ,g_module_prefix || l_procedure_name || '.end'
1749: ,'end function');
1750: END IF;
1751:

Line 1782: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1778: (p_customer_id IN NUMBER)
1779: RETURN VARCHAR2
1780: IS
1781: l_procedure_name VARCHAR2(30) := 'Get_Customer_Name';
1782: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1783: l_proc_level NUMBER := fnd_log.level_procedure;
1784:
1785: l_customer_name hz_parties.party_name%TYPE;
1786: CURSOR c_customer_name IS

Line 1783: l_proc_level NUMBER := fnd_log.level_procedure;

1779: RETURN VARCHAR2
1780: IS
1781: l_procedure_name VARCHAR2(30) := 'Get_Customer_Name';
1782: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1783: l_proc_level NUMBER := fnd_log.level_procedure;
1784:
1785: l_customer_name hz_parties.party_name%TYPE;
1786: CURSOR c_customer_name IS
1787: SELECT

Line 1799: fnd_log.STRING(l_proc_level

1795: BEGIN
1796: --logging for debug
1797: IF (l_proc_level >= l_dbg_level)
1798: THEN
1799: fnd_log.STRING(l_proc_level
1800: ,g_module_prefix || l_procedure_name || '.begin'
1801: ,'enter function');
1802: END IF;
1803:

Line 1816: fnd_log.STRING(l_proc_level

1812:
1813: --logging for debug
1814: IF (l_proc_level >= l_dbg_level)
1815: THEN
1816: fnd_log.STRING(l_proc_level
1817: ,g_module_prefix || l_procedure_name || '.end'
1818: ,'end function');
1819: END IF;
1820:

Line 1890: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1886: ORDER BY tax_line_id;
1887:
1888:
1889:
1890: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1891: l_proc_level NUMBER := fnd_log.level_procedure;
1892: l_procedure_name VARCHAR2(30) := 'Get_Arline_Amount';
1893:
1894: BEGIN

Line 1891: l_proc_level NUMBER := fnd_log.level_procedure;

1887:
1888:
1889:
1890: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1891: l_proc_level NUMBER := fnd_log.level_procedure;
1892: l_procedure_name VARCHAR2(30) := 'Get_Arline_Amount';
1893:
1894: BEGIN
1895: --logging for debug

Line 1898: fnd_log.STRING(l_proc_level

1894: BEGIN
1895: --logging for debug
1896: IF (l_proc_level >= l_dbg_level)
1897: THEN
1898: fnd_log.STRING(l_proc_level
1899: ,g_module_prefix || l_procedure_name || '.begin'
1900: ,'Enter function');
1901: END IF; --l_proc_level>=l_dbg_level)
1902:

Line 1928: fnd_log.STRING(l_proc_level

1924:
1925: --logging for debug
1926: IF (l_proc_level >= l_dbg_level)
1927: THEN
1928: fnd_log.STRING(l_proc_level
1929: ,g_module_prefix || l_procedure_name || '.End'
1930: ,'Exit function');
1931: END IF; --l_proc_level>=l_dbg_level)
1932:

Line 2002: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1998: ORDER BY tax_line_id;
1999:
2000:
2001:
2002: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
2003: l_proc_level NUMBER := fnd_log.level_procedure;
2004: l_procedure_name VARCHAR2(30) := 'Get_Arline_Vattax_Amount';
2005:
2006: BEGIN

Line 2003: l_proc_level NUMBER := fnd_log.level_procedure;

1999:
2000:
2001:
2002: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
2003: l_proc_level NUMBER := fnd_log.level_procedure;
2004: l_procedure_name VARCHAR2(30) := 'Get_Arline_Vattax_Amount';
2005:
2006: BEGIN
2007: --logging for debug

Line 2010: fnd_log.STRING(l_proc_level

2006: BEGIN
2007: --logging for debug
2008: IF (l_proc_level >= l_dbg_level)
2009: THEN
2010: fnd_log.STRING(l_proc_level
2011: ,g_module_prefix || l_procedure_name || '.begin'
2012: ,'Enter function');
2013: END IF; --l_proc_level>=l_dbg_level)
2014:

Line 2041: fnd_log.STRING(l_proc_level

2037:
2038: --logging for debug
2039: IF (l_proc_level >= l_dbg_level)
2040: THEN
2041: fnd_log.STRING(l_proc_level
2042: ,g_module_prefix || l_procedure_name || '.End'
2043: ,'Exit function');
2044: END IF; --l_proc_level>=l_dbg_level)
2045:

Line 2113: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

2109: ORDER BY tax_line_id;
2110:
2111:
2112:
2113: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
2114: l_proc_level NUMBER := fnd_log.level_procedure;
2115: l_procedure_name VARCHAR2(30) := 'Get_Arline_Vattax_Rate';
2116:
2117: BEGIN

Line 2114: l_proc_level NUMBER := fnd_log.level_procedure;

2110:
2111:
2112:
2113: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
2114: l_proc_level NUMBER := fnd_log.level_procedure;
2115: l_procedure_name VARCHAR2(30) := 'Get_Arline_Vattax_Rate';
2116:
2117: BEGIN
2118: --logging for debug

Line 2121: fnd_log.STRING(l_proc_level

2117: BEGIN
2118: --logging for debug
2119: IF (l_proc_level >= l_dbg_level)
2120: THEN
2121: fnd_log.STRING(l_proc_level
2122: ,g_module_prefix || l_procedure_name || '.begin'
2123: ,'Enter function');
2124: END IF; --l_proc_level>=l_dbg_level)
2125:

Line 2150: fnd_log.STRING(l_proc_level

2146:
2147: --logging for debug
2148: IF (l_proc_level >= l_dbg_level)
2149: THEN
2150: fnd_log.STRING(l_proc_level
2151: ,g_module_prefix || l_procedure_name || '.End'
2152: ,'Exit function');
2153: END IF; --l_proc_level>=l_dbg_level)
2154:

Line 2230: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2226:
2227:
2228:
2229: BEGIN
2230: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2231: THEN
2232: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2233: , G_MODULE_PREFIX || l_procedure_name
2234: ,'begin Procedure. ');

Line 2232: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2228:
2229: BEGIN
2230: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2231: THEN
2232: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2233: , G_MODULE_PREFIX || l_procedure_name
2234: ,'begin Procedure. ');
2235: END IF;
2236:

Line 2259: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2255: '||l_error_string||'
2256: ');
2257:
2258:
2259: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2260: THEN
2261: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
2262: , G_MODULE_PREFIX || l_procedure_name
2263: , l_error_string);

Line 2261: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

2257:
2258:
2259: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2260: THEN
2261: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
2262: , G_MODULE_PREFIX || l_procedure_name
2263: , l_error_string);
2264: END IF;
2265: RAISE;

Line 2291: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2287:
2288: WHERE h.customer_trx_id = p_customer_trx_id ;
2289: EXCEPTION
2290: WHEN no_data_found THEN
2291: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2292: THEN
2293: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2294: , G_MODULE_PREFIX || l_procedure_name
2295: , 'no date found when select header info');

Line 2293: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2289: EXCEPTION
2290: WHEN no_data_found THEN
2291: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2292: THEN
2293: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2294: , G_MODULE_PREFIX || l_procedure_name
2295: , 'no date found when select header info');
2296: END IF;
2297: END;

Line 2351: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2347: AND b.branch_party_id=brhp.party_id(+);
2348:
2349: EXCEPTION
2350: WHEN no_data_found THEN
2351: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2352: THEN
2353: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2354: , G_MODULE_PREFIX || l_procedure_name
2355: , 'no date found when select bank information');

Line 2353: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2349: EXCEPTION
2350: WHEN no_data_found THEN
2351: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2352: THEN
2353: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2354: , G_MODULE_PREFIX || l_procedure_name
2355: , 'no date found when select bank information');
2356: END IF;
2357: END;

Line 2370: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2366: WHERE
2367: ext_bank_account_id = l_instrument_id;
2368: EXCEPTION
2369: WHEN no_data_found THEN
2370: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2371: THEN
2372: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2373: , G_MODULE_PREFIX || l_procedure_name
2374: , 'no date found when select bank information');

Line 2372: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2368: EXCEPTION
2369: WHEN no_data_found THEN
2370: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2371: THEN
2372: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2373: , G_MODULE_PREFIX || l_procedure_name
2374: , 'no date found when select bank information');
2375: END IF;
2376: END;

Line 2480: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2476:
2477:
2478: EXCEPTION
2479: WHEN no_data_found THEN
2480: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2481: THEN
2482: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2483: , G_MODULE_PREFIX || l_procedure_name
2484: , 'no date found when select bank information');

Line 2482: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2478: EXCEPTION
2479: WHEN no_data_found THEN
2480: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2481: THEN
2482: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2483: , G_MODULE_PREFIX || l_procedure_name
2484: , 'no date found when select bank information');
2485: END IF;
2486: END;/*l_apba_bank_account_num IS NULL*/

Line 2495: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2491: x_bank_branch_name := l_bank_branch_name;
2492: x_bank_account_num := l_bank_account_num;
2493: x_bank_account_name := l_bank_account_name;
2494:
2495: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2496: THEN
2497: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2498: , G_MODULE_PREFIX || l_procedure_name
2499: ,'End Procedure. ');

Line 2497: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2493: x_bank_account_name := l_bank_account_name;
2494:
2495: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2496: THEN
2497: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2498: , G_MODULE_PREFIX || l_procedure_name
2499: ,'End Procedure. ');
2500: END IF;
2501:

Line 2504: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2500: END IF;
2501:
2502: EXCEPTION
2503: WHEN OTHERS THEN
2504: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2505: THEN
2506: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2507: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2508: , Sqlcode||Sqlerrm);

Line 2506: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

2502: EXCEPTION
2503: WHEN OTHERS THEN
2504: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2505: THEN
2506: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2507: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2508: , Sqlcode||Sqlerrm);
2509: END IF;
2510: RAISE;

Line 2585: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2581: l_ori_paying_site_id hz_cust_acct_sites.CUST_ACCT_SITE_ID%TYPE;
2582: l_ori_trxn_extension_id ra_customer_trx_all.payment_trxn_extension_id%TYPE;
2583:
2584: BEGIN
2585: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2586: THEN
2587: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2588: , G_MODULE_PREFIX || l_procedure_name
2589: ,'begin Procedure. ');

Line 2587: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2583:
2584: BEGIN
2585: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2586: THEN
2587: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2588: , G_MODULE_PREFIX || l_procedure_name
2589: ,'begin Procedure. ');
2590: END IF;
2591:

Line 2614: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2610: '||l_error_string||'
2611: ');
2612:
2613:
2614: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2615: THEN
2616: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
2617: , G_MODULE_PREFIX || l_procedure_name
2618: , l_error_string);

Line 2616: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

2612:
2613:
2614: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2615: THEN
2616: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
2617: , G_MODULE_PREFIX || l_procedure_name
2618: , l_error_string);
2619: END IF;
2620: RAISE;

Line 2646: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2642: ra_customer_trx_all h
2643: WHERE h.customer_trx_id = p_customer_trx_id ;
2644: EXCEPTION
2645: WHEN no_data_found THEN
2646: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2647: THEN
2648: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2649: , G_MODULE_PREFIX || l_procedure_name
2650: , 'no date found when select bank information');

Line 2648: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2644: EXCEPTION
2645: WHEN no_data_found THEN
2646: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2647: THEN
2648: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2649: , G_MODULE_PREFIX || l_procedure_name
2650: , 'no date found when select bank information');
2651: END IF;
2652: END;

Line 2706: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2702: AND b.branch_party_id=brhp.party_id(+);
2703:
2704: EXCEPTION
2705: WHEN no_data_found THEN
2706: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2707: THEN
2708: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2709: , G_MODULE_PREFIX || l_procedure_name
2710: , 'no date found when select bank information');

Line 2708: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2704: EXCEPTION
2705: WHEN no_data_found THEN
2706: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2707: THEN
2708: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2709: , G_MODULE_PREFIX || l_procedure_name
2710: , 'no date found when select bank information');
2711: END IF;
2712: END;

Line 2725: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2721: WHERE
2722: ext_bank_account_id = l_instrument_id;
2723: EXCEPTION
2724: WHEN no_data_found THEN
2725: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2726: THEN
2727: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2728: , G_MODULE_PREFIX || l_procedure_name
2729: , 'no date found when select bank information');

Line 2727: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2723: EXCEPTION
2724: WHEN no_data_found THEN
2725: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2726: THEN
2727: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2728: , G_MODULE_PREFIX || l_procedure_name
2729: , 'no date found when select bank information');
2730: END IF;
2731: END;

Line 2753: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2749:
2750: WHERE h.customer_trx_id = p_original_trx_id ;
2751: EXCEPTION
2752: WHEN no_data_found THEN
2753: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2754: THEN
2755: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2756: , G_MODULE_PREFIX || l_procedure_name
2757: , 'no date found when select header info');

Line 2755: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2751: EXCEPTION
2752: WHEN no_data_found THEN
2753: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2754: THEN
2755: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2756: , G_MODULE_PREFIX || l_procedure_name
2757: , 'no date found when select header info');
2758: END IF;
2759: END;

Line 2812: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2808: AND b.branch_party_id=brhp.party_id(+);
2809:
2810: EXCEPTION
2811: WHEN no_data_found THEN
2812: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2813: THEN
2814: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2815: , G_MODULE_PREFIX || l_procedure_name
2816: , 'no date found when select bank information');

Line 2814: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2810: EXCEPTION
2811: WHEN no_data_found THEN
2812: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2813: THEN
2814: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2815: , G_MODULE_PREFIX || l_procedure_name
2816: , 'no date found when select bank information');
2817: END IF;
2818: END;

Line 2831: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2827: WHERE
2828: ext_bank_account_id = l_instrument_id;
2829: EXCEPTION
2830: WHEN no_data_found THEN
2831: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2832: THEN
2833: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2834: , G_MODULE_PREFIX || l_procedure_name
2835: , 'no date found when select bank information');

Line 2833: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2829: EXCEPTION
2830: WHEN no_data_found THEN
2831: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2832: THEN
2833: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2834: , G_MODULE_PREFIX || l_procedure_name
2835: , 'no date found when select bank information');
2836: END IF;
2837: END;

Line 2941: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2937: HZ_PARTIES
2938: WHERE party_id = l_bank_branch_id;
2939: EXCEPTION
2940: WHEN no_data_found THEN
2941: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2942: THEN
2943: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2944: , G_MODULE_PREFIX || l_procedure_name
2945: , 'no date found when select bank information');

Line 2943: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2939: EXCEPTION
2940: WHEN no_data_found THEN
2941: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2942: THEN
2943: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2944: , G_MODULE_PREFIX || l_procedure_name
2945: , 'no date found when select bank information');
2946: END IF;
2947: END;/*l_apba_bank_account_num IS NULL*/

Line 2955: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2951: x_bank_branch_name := l_bank_branch_name;
2952: x_bank_account_num := l_bank_account_num;
2953: x_bank_account_name := l_bank_account_name;
2954:
2955: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2956: THEN
2957: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2958: , G_MODULE_PREFIX || l_procedure_name
2959: ,'End Procedure. ');

Line 2957: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2953: x_bank_account_name := l_bank_account_name;
2954:
2955: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2956: THEN
2957: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2958: , G_MODULE_PREFIX || l_procedure_name
2959: ,'End Procedure. ');
2960: END IF;
2961:

Line 2964: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2960: END IF;
2961:
2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2965: THEN
2966: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2967: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2968: , Sqlcode||Sqlerrm);

Line 2966: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2965: THEN
2966: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2967: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2968: , Sqlcode||Sqlerrm);
2969: END IF;
2970: RAISE;

Line 3012: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3008: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006
3009:
3010: BEGIN
3011:
3012: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3013: THEN
3014: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3015: , G_MODULE_PREFIX || l_procedure_name
3016: ,'begin Procedure. ');

Line 3014: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3010: BEGIN
3011:
3012: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3013: THEN
3014: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3015: , G_MODULE_PREFIX || l_procedure_name
3016: ,'begin Procedure. ');
3017: END IF;
3018:

Line 3019: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3015: , G_MODULE_PREFIX || l_procedure_name
3016: ,'begin Procedure. ');
3017: END IF;
3018:
3019: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3020: THEN
3021: log( 'Begin Verify_Tax_line---');
3022: log( 'p_trx_line_id :'||p_trx_line_id);
3023: log( 'p_tax_type_code :'||p_tax_type_code);

Line 3083: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3079: END IF;/*l_tax_line_count = 0*/
3080:
3081: x_tax_line_id := l_tax_line_id;
3082:
3083: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3084: THEN
3085: log( 'x_status : '||x_status);
3086: END IF;
3087:

Line 3088: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3084: THEN
3085: log( 'x_status : '||x_status);
3086: END IF;
3087:
3088: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3089: THEN
3090: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3091: , G_MODULE_PREFIX || l_procedure_name
3092: ,'End Procedure. ');

Line 3090: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3086: END IF;
3087:
3088: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3089: THEN
3090: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3091: , G_MODULE_PREFIX || l_procedure_name
3092: ,'End Procedure. ');
3093: END IF;
3094:

Line 3095: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3091: , G_MODULE_PREFIX || l_procedure_name
3092: ,'End Procedure. ');
3093: END IF;
3094:
3095: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3096: THEN
3097: log( 'End Verify_Tax_line---');
3098: END IF;
3099:

Line 3102: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3098: END IF;
3099:
3100: EXCEPTION
3101: WHEN OTHERS THEN
3102: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3103: THEN
3104: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3105: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3106: , Sqlcode||Sqlerrm);

Line 3104: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3100: EXCEPTION
3101: WHEN OTHERS THEN
3102: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3103: THEN
3104: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3105: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3106: , Sqlcode||Sqlerrm);
3107: END IF;
3108: RAISE;

Line 3194: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3190:
3191: tax_error_for_recycle EXCEPTION; --exception for tax_amount check for recycle Invoice
3192:
3193: BEGIN
3194: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3195: THEN
3196: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3197: , G_MODULE_PREFIX || l_procedure_name
3198: ,'begin Procedure. ');

Line 3196: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3192:
3193: BEGIN
3194: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3195: THEN
3196: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3197: , G_MODULE_PREFIX || l_procedure_name
3198: ,'begin Procedure. ');
3199: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3200: , G_MODULE_PREFIX || l_procedure_name

Line 3199: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3195: THEN
3196: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3197: , G_MODULE_PREFIX || l_procedure_name
3198: ,'begin Procedure. ');
3199: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3200: , G_MODULE_PREFIX || l_procedure_name
3201: ,'p_trx_line_id: '||p_trx_line_id);
3202:
3203: END IF;

Line 3205: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3201: ,'p_trx_line_id: '||p_trx_line_id);
3202:
3203: END IF;
3204:
3205: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3206: THEN
3207: log( 'Begin Get_Info_From_Ebtax --');
3208: log( 'p_org_id : '||p_org_id);
3209: log( 'p_trx_id : '||p_trx_id);

Line 3242: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3238: '||l_error_string||'
3239: ');
3240:
3241:
3242: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3243: THEN
3244: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
3245: , G_MODULE_PREFIX || l_procedure_name
3246: , l_error_string);

Line 3244: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

3240:
3241:
3242: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3243: THEN
3244: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
3245: , G_MODULE_PREFIX || l_procedure_name
3246: , l_error_string);
3247: END IF;
3248:

Line 3397: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3393: OR l_tax_amount IS NULL
3394: OR l_unit_price IS NULL
3395: OR l_trx_line_quantity IS NULL
3396: THEN
3397: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3398: THEN
3399: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3400: , G_MODULE_PREFIX || l_procedure_name
3401: ,'The data come from ebtax is null. ');

Line 3399: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3395: OR l_trx_line_quantity IS NULL
3396: THEN
3397: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3398: THEN
3399: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3400: , G_MODULE_PREFIX || l_procedure_name
3401: ,'The data come from ebtax is null. ');
3402: END IF;
3403: END IF;

Line 3420: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3416:
3417: END IF;
3418:
3419: -- output the status
3420: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3421: THEN
3422: log( 'x_status '||x_status);
3423: END IF;
3424:

Line 3445: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3441: --x_tax_curr_unit_price := round(l_unit_price * l_tax_curr_conversion_rate);
3442:
3443:
3444:
3445: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3446: THEN
3447: log( 'End Get_Info_From_Ebtax --');
3448: END IF;
3449:

Line 3450: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3446: THEN
3447: log( 'End Get_Info_From_Ebtax --');
3448: END IF;
3449:
3450: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3451: THEN
3452: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3453: , G_MODULE_PREFIX || l_procedure_name
3454: ,'End Procedure. ');

Line 3452: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3448: END IF;
3449:
3450: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3451: THEN
3452: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3453: , G_MODULE_PREFIX || l_procedure_name
3454: ,'End Procedure. ');
3455: END IF;
3456:

Line 3463: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3459:
3460: fnd_message.SET_NAME('AR', 'AR_GTA_TAX_ERROR_RECYCLE');
3461: l_error_string := fnd_message.get();
3462: -- begin log
3463: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3464: THEN
3465: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3466: , G_MODULE_PREFIX || l_procedure_name
3467: , 'tax rate and tax amount should be zero for Recycle Invoices');

Line 3465: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3461: l_error_string := fnd_message.get();
3462: -- begin log
3463: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3464: THEN
3465: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3466: , G_MODULE_PREFIX || l_procedure_name
3467: , 'tax rate and tax amount should be zero for Recycle Invoices');
3468: END IF;
3469: RAISE;

Line 3474: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3470:
3471: -- end log
3472: RAISE;*/
3473: WHEN OTHERS THEN
3474: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3475: THEN
3476: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3477: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3478: , Sqlcode||Sqlerrm);

Line 3476: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3472: RAISE;*/
3473: WHEN OTHERS THEN
3474: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3475: THEN
3476: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3477: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3478: , Sqlcode||Sqlerrm);
3479: END IF;
3480: RAISE;

Line 3576: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3572: AND p_tax_determine_date >= reg.effective_from
3573: AND (p_tax_determine_date < reg.effective_to OR reg.effective_to IS NULL)
3574: AND reg.registration_number IS NOT NULL;
3575: BEGIN
3576: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3577: THEN
3578: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3579: , G_MODULE_PREFIX || l_procedure_name
3580: ,'begin Procedure. ');

Line 3578: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3574: AND reg.registration_number IS NOT NULL;
3575: BEGIN
3576: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3577: THEN
3578: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3579: , G_MODULE_PREFIX || l_procedure_name
3580: ,'begin Procedure. ');
3581:
3582: END IF;

Line 3584: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3580: ,'begin Procedure. ');
3581:
3582: END IF;
3583:
3584: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3585: THEN
3586: log( 'Begin Get_Info_From_Ebtax --');
3587: log( 'p_trx_id :'||p_trx_id);
3588: log( 'p_tax_line_id:' ||p_tax_line_id);

Line 3621: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3617: hz_cust_acct_sites_all
3618: WHERE cust_acct_site_id = l_cust_acct_site_id;
3619: EXCEPTION
3620: WHEN no_data_found THEN
3621: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3622: THEN
3623: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3624: , G_MODULE_PREFIX || l_procedure_name
3625: , l_procedure_name||'no data found ');

Line 3623: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

3619: EXCEPTION
3620: WHEN no_data_found THEN
3621: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3622: THEN
3623: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3624: , G_MODULE_PREFIX || l_procedure_name
3625: , l_procedure_name||'no data found ');
3626: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3627: END;

Line 3626: END IF;/(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)/

3622: THEN
3623: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3624: , G_MODULE_PREFIX || l_procedure_name
3625: , l_procedure_name||'no data found ');
3626: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3627: END;
3628:
3629: -- get the tax_regime, tax, tax_jurisdiction by trx line id ;
3630: BEGIN

Line 3648: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3644: tax.tax_line_id = p_tax_line_id;
3645:
3646: EXCEPTION
3647: WHEN no_data_found THEN
3648: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3649: THEN
3650: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3651: , G_MODULE_PREFIX || l_procedure_name
3652: , 'no data found ');

Line 3650: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

3646: EXCEPTION
3647: WHEN no_data_found THEN
3648: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3649: THEN
3650: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3651: , G_MODULE_PREFIX || l_procedure_name
3652: , 'no data found ');
3653: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3654:

Line 3653: END IF;/(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)/

3649: THEN
3650: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3651: , G_MODULE_PREFIX || l_procedure_name
3652: , 'no data found ');
3653: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3654:
3655: END;
3656:
3657: -- get tax_profile_id by party site id

Line 3669: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3665: WHERE tax_prof.party_id = l_party_site_id
3666: AND tax_prof.party_type_code = 'THIRD_PARTY_SITE';
3667: EXCEPTION
3668: WHEN no_data_found THEN
3669: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3670: THEN
3671: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3672: , G_MODULE_PREFIX || l_procedure_name
3673: , 'no data found ');

Line 3671: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

3667: EXCEPTION
3668: WHEN no_data_found THEN
3669: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3670: THEN
3671: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3672: , G_MODULE_PREFIX || l_procedure_name
3673: , 'no data found ');
3674: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3675: WHEN too_many_rows THEN

Line 3674: END IF;/(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)/

3670: THEN
3671: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3672: , G_MODULE_PREFIX || l_procedure_name
3673: , 'no data found ');
3674: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3675: WHEN too_many_rows THEN
3676: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3677: THEN
3678: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

Line 3676: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3672: , G_MODULE_PREFIX || l_procedure_name
3673: , 'no data found ');
3674: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3675: WHEN too_many_rows THEN
3676: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3677: THEN
3678: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3679: , G_MODULE_PREFIX || l_procedure_name
3680: , 'too many rows ');

Line 3678: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

3674: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3675: WHEN too_many_rows THEN
3676: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3677: THEN
3678: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3679: , G_MODULE_PREFIX || l_procedure_name
3680: , 'too many rows ');
3681: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3682: END;

Line 3681: END IF;/(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)/

3677: THEN
3678: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
3679: , G_MODULE_PREFIX || l_procedure_name
3680: , 'too many rows ');
3681: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
3682: END;
3683:
3684: /*
3685: dbms_output.put_line('l_bill_to_site_use_id: '||l_bill_to_site_use_id);

Line 3691: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3687: dbms_output.put_line('l_tax: '||l_tax);
3688: dbms_output.put_line('l_tax_jurisdiction_code: '||l_tax_jurisdiction_code);
3689: dbms_output.put_line('l_party_tax_profile_id: '||l_party_tax_profile_id);
3690: */
3691: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3692: THEN
3693: log( 'l_bill_to_site_use_id :'||l_bill_to_site_use_id);
3694: log( 'l_tax_regime_code:' ||l_tax_regime_code);
3695: log( 'l_tax:' ||l_tax);

Line 3750: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3746:
3747: ELSE /*l_tax_regime_code IS NOT NULL AND l_tax IS NOT NULL AND l_tax_determine_date IS NOT NULL*/
3748: x_tp_tax_registration_number := NULL;
3749:
3750: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3751: THEN
3752: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3753: , G_MODULE_PREFIX || l_procedure_name
3754: ,'tax or tax_jur is null in zx_lines ');

Line 3752: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3748: x_tp_tax_registration_number := NULL;
3749:
3750: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3751: THEN
3752: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3753: , G_MODULE_PREFIX || l_procedure_name
3754: ,'tax or tax_jur is null in zx_lines ');
3755: END IF;
3756:

Line 3760: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3756:
3757: END IF;/*l_tax_regime_code IS NOT NULL AND l_tax IS NOT NULL AND l_tax_determine_date IS NOT NULL*/
3758:
3759: --dbms_output.put_line('registration_number: '||l_tax_registration_number);
3760: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3761: THEN
3762: log( 'End Get_Tp_Tax_Registration_Number --');
3763: END IF;
3764:

Line 3783: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3779:
3780: IF l_msg_count > 0
3781: THEN
3782:
3783: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3784: THEN
3785: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3786: , G_MODULE_PREFIX || l_procedure_name
3787: , 'ZX_API_PUB.get_default_tax_reg error, see below '

Line 3785: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3781: THEN
3782:
3783: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3784: THEN
3785: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3786: , G_MODULE_PREFIX || l_procedure_name
3787: , 'ZX_API_PUB.get_default_tax_reg error, see below '
3788: ||'the detail error messages' );
3789:

Line 3794: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3790: FOR i IN 1..l_msg_count
3791: LOOP
3792: FND_MSG_PUB.Get(i, FND_API.G_FALSE, l_msg_data, l_indexO);
3793: FND_MSG_PUB.Delete_Msg(l_indexO);
3794: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3795: , G_MODULE_PREFIX || l_procedure_name||'.ZX_API_PUB error'
3796: , l_msg_data);
3797:
3798: END LOOP; --i IN 1..l_msg_count

Line 3800: END IF;--FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3796: , l_msg_data);
3797:
3798: END LOOP; --i IN 1..l_msg_count
3799:
3800: END IF;--FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3801:
3802: END if;--l_msg_count = 0
3803: --add by Yao Zhang for bug 14500600
3804: IF x_tp_tax_registration_number IS NULL

Line 3837: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

3833: AND rownum = 1
3834: ORDER BY reg.tax, reg.tax_jurisdiction_code;
3835: EXCEPTION
3836: WHEN OTHERS THEN
3837: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3838: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3839: G_MODULE_PREFIX || l_procedure_name ||
3840: '. Exception while get tax reg number from customer level ',
3841: SQLCODE || SQLERRM);

Line 3838: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

3834: ORDER BY reg.tax, reg.tax_jurisdiction_code;
3835: EXCEPTION
3836: WHEN OTHERS THEN
3837: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3838: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
3839: G_MODULE_PREFIX || l_procedure_name ||
3840: '. Exception while get tax reg number from customer level ',
3841: SQLCODE || SQLERRM);
3842: END IF;

Line 3864: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3860: , p_effective_date => SYSDATE);
3861: IF l_msg_count > 0
3862: THEN
3863:
3864: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3865: THEN
3866: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3867: , G_MODULE_PREFIX || l_procedure_name
3868: , 'ZX_API_PUB.get_default_tax_reg error, see below '

Line 3866: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3862: THEN
3863:
3864: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3865: THEN
3866: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3867: , G_MODULE_PREFIX || l_procedure_name
3868: , 'ZX_API_PUB.get_default_tax_reg error, see below '
3869: ||'the detail error messages' );
3870:

Line 3875: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3871: FOR i IN 1..l_msg_count
3872: LOOP
3873: FND_MSG_PUB.Get(i, FND_API.G_FALSE, l_msg_data, l_indexO);
3874: FND_MSG_PUB.Delete_Msg(l_indexO);
3875: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3876: , G_MODULE_PREFIX || l_procedure_name||'.ZX_API_PUB error'
3877: , l_msg_data);
3878:
3879: END LOOP; --i IN 1..l_msg_count

Line 3881: END IF;--FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3877: , l_msg_data);
3878:
3879: END LOOP; --i IN 1..l_msg_count
3880:
3881: END IF;--FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3882:
3883: END if;--l_msg_count = 0
3884:
3885: END IF;--x_tp_tax_registration_number IS NULL

Line 3890: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3886:
3887: END IF; --x_tp_tax_registration_number IS NULL
3888: --jogen Mar-21, 2006 bug 5088458
3889:
3890: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3891: THEN
3892: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3893: , G_MODULE_PREFIX || l_procedure_name
3894: ,'End Procedure. ');

Line 3892: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3888: --jogen Mar-21, 2006 bug 5088458
3889:
3890: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3891: THEN
3892: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3893: , G_MODULE_PREFIX || l_procedure_name
3894: ,'End Procedure. ');
3895: END IF;
3896:

Line 3899: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

3895: END IF;
3896:
3897: EXCEPTION
3898: WHEN OTHERS THEN
3899: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3900: THEN
3901: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3902: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3903: , Sqlcode||Sqlerrm);

Line 3901: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3897: EXCEPTION
3898: WHEN OTHERS THEN
3899: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3900: THEN
3901: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3902: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3903: , Sqlcode||Sqlerrm);
3904: END IF;
3905: RAISE;

Line 3982: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

3978: ORDER BY tax_line_id;
3979:
3980:
3981:
3982: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3983: l_proc_level NUMBER := fnd_log.level_procedure;
3984: l_procedure_name VARCHAR2(30) :='Get_Arline_Tp_Taxreg_Number';
3985:
3986: BEGIN

Line 3983: l_proc_level NUMBER := fnd_log.level_procedure;

3979:
3980:
3981:
3982: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3983: l_proc_level NUMBER := fnd_log.level_procedure;
3984: l_procedure_name VARCHAR2(30) :='Get_Arline_Tp_Taxreg_Number';
3985:
3986: BEGIN
3987: --logging for debug

Line 3990: fnd_log.STRING(l_proc_level

3986: BEGIN
3987: --logging for debug
3988: IF (l_proc_level >= l_dbg_level)
3989: THEN
3990: fnd_log.STRING(l_proc_level
3991: ,g_module_prefix || l_procedure_name || '.begin'
3992: ,'Enter function');
3993: END IF; --l_proc_level>=l_dbg_level)
3994:

Line 4026: fnd_log.STRING(l_proc_level

4022:
4023: --logging for debug
4024: IF (l_proc_level >= l_dbg_level)
4025: THEN
4026: fnd_log.STRING(l_proc_level
4027: ,g_module_prefix || l_procedure_name || '.End'
4028: ,'Exit function');
4029: END IF; --l_proc_level>=l_dbg_level)
4030:

Line 4060: WHEN 'FND_LOG.STRING' THEN

4056: l_procedure_name VARCHAR2(30) := 'debug_output';
4057: BEGIN
4058:
4059: CASE p_output_to
4060: WHEN 'FND_LOG.STRING' THEN
4061: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4062: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4063: ,p_api_name || '.debug_output'
4064: ,p_message);

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

4057: BEGIN
4058:
4059: CASE p_output_to
4060: WHEN 'FND_LOG.STRING' THEN
4061: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4062: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4063: ,p_api_name || '.debug_output'
4064: ,p_message);
4065: END IF;

Line 4062: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

4058:
4059: CASE p_output_to
4060: WHEN 'FND_LOG.STRING' THEN
4061: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4062: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4063: ,p_api_name || '.debug_output'
4064: ,p_message);
4065: END IF;
4066: WHEN 'FND_FILE.OUTPUT' THEN

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

4063: ,p_api_name || '.debug_output'
4064: ,p_message);
4065: END IF;
4066: WHEN 'FND_FILE.OUTPUT' THEN
4067: IF (FND_LOG.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
4068: fnd_file.put_line(fnd_file.OUTPUT
4069: ,p_api_name || '.debug_output' || ': ' ||
4070: p_message);
4071: END IF;

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

4069: ,p_api_name || '.debug_output' || ': ' ||
4070: p_message);
4071: END IF;
4072: WHEN 'FND_FILE.LOG' THEN
4073: IF (FND_LOG.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
4074: log(p_api_name || '.debug_output' || ': ' ||
4075: p_message);
4076: END IF;
4077: ELSE

Line 4083: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4079: END CASE;
4080:
4081: EXCEPTION
4082: WHEN OTHERS THEN
4083: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4084: THEN
4085: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4086: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
4087: , Sqlcode||Sqlerrm);

Line 4085: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

4081: EXCEPTION
4082: WHEN OTHERS THEN
4083: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4084: THEN
4085: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4086: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
4087: , Sqlcode||Sqlerrm);
4088: END IF;
4089: RAISE;

Line 4123: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

4119: , p_source_id IN NUMBER
4120: )
4121: RETURN VARCHAR2 IS
4122: l_procedure_name VARCHAR2(30) := 'Get_AR_Batch_Source_Name';
4123: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4124: l_proc_level NUMBER := fnd_log.level_procedure;
4125:
4126: l_source_name RA_BATCH_SOURCES_all.NAME%TYPE;
4127: CURSOR c_source_name IS

Line 4124: l_proc_level NUMBER := fnd_log.level_procedure;

4120: )
4121: RETURN VARCHAR2 IS
4122: l_procedure_name VARCHAR2(30) := 'Get_AR_Batch_Source_Name';
4123: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4124: l_proc_level NUMBER := fnd_log.level_procedure;
4125:
4126: l_source_name RA_BATCH_SOURCES_all.NAME%TYPE;
4127: CURSOR c_source_name IS
4128: SELECT RA_BATCH_SOURCES_all.NAME

Line 4137: fnd_log.STRING(l_proc_level

4133: BEGIN
4134: --logging for debug
4135: IF (l_proc_level >= l_dbg_level)
4136: THEN
4137: fnd_log.STRING(l_proc_level
4138: ,g_module_prefix || l_procedure_name || '.begin'
4139: ,'enter function');
4140: END IF;
4141:

Line 4153: fnd_log.STRING(l_proc_level

4149:
4150: --logging for debug
4151: IF (l_proc_level >= l_dbg_level)
4152: THEN
4153: fnd_log.STRING(l_proc_level
4154: ,g_module_prefix || l_procedure_name || '.end'
4155: ,'end function');
4156: END IF;
4157:

Line 4193: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

4189: RETURN VARCHAR2
4190: IS
4191: l_xsd_date_string VARCHAR2(40);
4192: l_procedure_name VARCHAR2(30) := 'To_Xsd_Date_String';
4193: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4194: l_proc_level NUMBER := fnd_log.level_procedure;
4195:
4196: BEGIN
4197:

Line 4194: l_proc_level NUMBER := fnd_log.level_procedure;

4190: IS
4191: l_xsd_date_string VARCHAR2(40);
4192: l_procedure_name VARCHAR2(30) := 'To_Xsd_Date_String';
4193: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4194: l_proc_level NUMBER := fnd_log.level_procedure;
4195:
4196: BEGIN
4197:
4198: --logging for debug

Line 4201: fnd_log.STRING(l_proc_level

4197:
4198: --logging for debug
4199: IF (l_proc_level >= l_dbg_level)
4200: THEN
4201: fnd_log.STRING(l_proc_level
4202: ,g_module_prefix || l_procedure_name || '.begin'
4203: ,'enter function');
4204: END IF;
4205:

Line 4211: FND_LOG.string( l_proc_level

4207: IF p_date IS NULL
4208: THEN
4209: IF (l_proc_level >= l_dbg_level)
4210: THEN
4211: FND_LOG.string( l_proc_level
4212: , G_MODULE_PREFIX
4213: , G_MODULE_PREFIX || l_procedure_name
4214: || '.end'
4215: );

Line 4230: FND_LOG.string( l_proc_level

4226:
4227:
4228: IF (l_proc_level >= l_dbg_level)
4229: THEN
4230: FND_LOG.string( l_proc_level
4231: , G_MODULE_PREFIX
4232: , G_MODULE_PREFIX || l_procedure_name
4233: || '.end: Returning XSD Date = '
4234: || l_xsd_date_string);

Line 4244: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4240:
4241: EXCEPTION
4242:
4243: WHEN OTHERS THEN
4244: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4245: THEN
4246: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4247: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
4248: , Sqlcode||Sqlerrm);

Line 4246: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

4242:
4243: WHEN OTHERS THEN
4244: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4245: THEN
4246: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4247: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
4248: , Sqlcode||Sqlerrm);
4249: END IF;
4250: RAISE;

Line 4287: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

4283: )
4284: RETURN VARCHAR2
4285: IS
4286: l_procedure_name VARCHAR2(30) := 'Format_Monetary_Amount';
4287: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4288: l_proc_level NUMBER := fnd_log.level_procedure;
4289: l_base_currency ar_gta_system_parameters_all.gt_currency_code%TYPE;
4290: l_format_mask VARCHAR2(50);
4291: l_formatted_amount VARCHAR2(50);

Line 4288: l_proc_level NUMBER := fnd_log.level_procedure;

4284: RETURN VARCHAR2
4285: IS
4286: l_procedure_name VARCHAR2(30) := 'Format_Monetary_Amount';
4287: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4288: l_proc_level NUMBER := fnd_log.level_procedure;
4289: l_base_currency ar_gta_system_parameters_all.gt_currency_code%TYPE;
4290: l_format_mask VARCHAR2(50);
4291: l_formatted_amount VARCHAR2(50);
4292:

Line 4306: fnd_log.STRING(l_proc_level

4302:
4303: --logging for debug
4304: IF (l_proc_level >= l_dbg_level)
4305: THEN
4306: fnd_log.STRING(l_proc_level
4307: ,g_module_prefix || l_procedure_name || '.begin'
4308: ,'enter function');
4309: END IF;
4310:

Line 4325: fnd_log.STRING(l_proc_level

4321:
4322: --logging for debug
4323: IF (l_proc_level >= l_dbg_level)
4324: THEN
4325: fnd_log.STRING(l_proc_level
4326: ,g_module_prefix || l_procedure_name || '.end'
4327: ,'end function');
4328: END IF;
4329: RETURN l_formatted_amount;

Line 4334: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4330:
4331: EXCEPTION
4332:
4333: WHEN OTHERS THEN
4334: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4335: THEN
4336: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4337: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
4338: , Sqlcode||Sqlerrm);

Line 4336: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

4332:
4333: WHEN OTHERS THEN
4334: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4335: THEN
4336: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4337: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
4338: , Sqlcode||Sqlerrm);
4339: END IF;
4340: RAISE;

Line 4368: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

4364: --
4365: --===========================================================================
4366: PROCEDURE Populate_Invoice_Type(p_org_id IN NUMBER)
4367: IS
4368: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4369: l_proc_level NUMBER := fnd_log.level_procedure;
4370: l_procedure_name VARCHAR2(30) := 'Populate_Invoice_Type';
4371:
4372:

Line 4369: l_proc_level NUMBER := fnd_log.level_procedure;

4365: --===========================================================================
4366: PROCEDURE Populate_Invoice_Type(p_org_id IN NUMBER)
4367: IS
4368: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4369: l_proc_level NUMBER := fnd_log.level_procedure;
4370: l_procedure_name VARCHAR2(30) := 'Populate_Invoice_Type';
4371:
4372:
4373: BEGIN

Line 4377: fnd_log.STRING(l_proc_level

4373: BEGIN
4374: --logging for debug
4375: IF (l_proc_level >= l_dbg_level)
4376: THEN
4377: fnd_log.STRING(l_proc_level
4378: ,g_module_prefix || l_procedure_name || '.begin'
4379: ,'Enter procedure');
4380: END IF; --l_proc_level>=l_dbg_level)
4381: -- initialize invoice type for System Option and Transfer Rules

Line 4401: fnd_log.STRING(l_proc_level

4397:
4398: --logging for debug
4399: IF (l_proc_level >= l_dbg_level)
4400: THEN
4401: fnd_log.STRING(l_proc_level
4402: ,g_module_prefix || l_procedure_name || '.end'
4403: ,'end procedure');
4404: END IF;
4405:

Line 4409: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4405:
4406: EXCEPTION
4407:
4408: WHEN OTHERS THEN
4409: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4410: THEN
4411: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4412: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
4413: , Sqlcode||Sqlerrm);

Line 4411: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

4407:
4408: WHEN OTHERS THEN
4409: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4410: THEN
4411: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4412: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
4413: , Sqlcode||Sqlerrm);
4414: END IF;
4415: RAISE;

Line 4443: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

4439: -- 26-Aug-2009: Allen Yang Modified for bug 8839141.
4440: --===========================================================================
4441: PROCEDURE Populate_Invoice_Type_Header(p_org_id IN NUMBER)
4442: IS
4443: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4444: l_proc_level NUMBER := fnd_log.level_procedure;
4445: l_procedure_name VARCHAR2(30) := 'Populate_Invoice_Type_Header';
4446:
4447: -- all GTA invoices whose AR transaction type is not associated to invoice type

Line 4444: l_proc_level NUMBER := fnd_log.level_procedure;

4440: --===========================================================================
4441: PROCEDURE Populate_Invoice_Type_Header(p_org_id IN NUMBER)
4442: IS
4443: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
4444: l_proc_level NUMBER := fnd_log.level_procedure;
4445: l_procedure_name VARCHAR2(30) := 'Populate_Invoice_Type_Header';
4446:
4447: -- all GTA invoices whose AR transaction type is not associated to invoice type
4448: CURSOR c_inv_trx_type_no_inv_type

Line 4529: fnd_log.STRING(l_proc_level

4525: BEGIN
4526: --logging for debug
4527: IF (l_proc_level >= l_dbg_level)
4528: THEN
4529: fnd_log.STRING(l_proc_level
4530: ,g_module_prefix || l_procedure_name || '.begin'
4531: ,'Enter procedure');
4532: END IF; --l_proc_level>=l_dbg_level)
4533:

Line 4570: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4566: AND (JGTLA.Tax_Rate <> 0 OR
4567: JGTLA.Tax_Amount <> 0))));
4568: EXCEPTION
4569: WHEN no_data_found THEN
4570: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4571: THEN
4572: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
4573: , G_MODULE_PREFIX || l_procedure_name
4574: , l_procedure_name||'no data found ');

Line 4572: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

4568: EXCEPTION
4569: WHEN no_data_found THEN
4570: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4571: THEN
4572: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
4573: , G_MODULE_PREFIX || l_procedure_name
4574: , l_procedure_name||'no data found ');
4575: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
4576: END;

Line 4575: END IF;/(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)/

4571: THEN
4572: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
4573: , G_MODULE_PREFIX || l_procedure_name
4574: , l_procedure_name||'no data found ');
4575: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
4576: END;
4577: IF l_invoice_type IS NOT NULL
4578: THEN
4579: BEGIN

Line 4591: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4587: AND RCT.CUST_TRX_TYPE_ID = RCTT.CUST_TRX_TYPE_ID(+)
4588: AND RCTT.ORG_ID = l_org_id;
4589: EXCEPTION
4590: WHEN no_data_found THEN
4591: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4592: THEN
4593: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
4594: , G_MODULE_PREFIX || l_procedure_name
4595: , l_procedure_name||'no data found ');

Line 4593: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

4589: EXCEPTION
4590: WHEN no_data_found THEN
4591: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4592: THEN
4593: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
4594: , G_MODULE_PREFIX || l_procedure_name
4595: , l_procedure_name||'no data found ');
4596: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
4597: END;

Line 4596: END IF;/(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)/

4592: THEN
4593: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
4594: , G_MODULE_PREFIX || l_procedure_name
4595: , l_procedure_name||'no data found ');
4596: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
4597: END;
4598: -- if AR transaction Type is Credit Memo, then check invoice type of original transaction,
4599: -- else this GTA invoice can be successfully updated.
4600: IF (NVL(l_ar_trx_type, 'INV')='CM')

Line 4611: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4607: WHERE RCT.CUSTOMER_TRX_ID(+) = l_ra_trx_id
4608: AND JGTH.RA_TRX_id = RCT.previous_customer_trx_id;
4609: EXCEPTION
4610: WHEN no_data_found THEN
4611: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4612: THEN
4613: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
4614: , G_MODULE_PREFIX || l_procedure_name
4615: , l_procedure_name||'no data found ');

Line 4613: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

4609: EXCEPTION
4610: WHEN no_data_found THEN
4611: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4612: THEN
4613: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
4614: , G_MODULE_PREFIX || l_procedure_name
4615: , l_procedure_name||'no data found ');
4616: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
4617: END;

Line 4616: END IF;/(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)/

4612: THEN
4613: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
4614: , G_MODULE_PREFIX || l_procedure_name
4615: , l_procedure_name||'no data found ');
4616: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
4617: END;
4618: IF (l_pre_trx_invoice_type IS NOT NULL AND l_pre_trx_invoice_type = l_invoice_type)
4619: THEN
4620: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

Line 4730: fnd_log.STRING(l_proc_level

4726:
4727: --logging for debug
4728: IF (l_proc_level >= l_dbg_level)
4729: THEN
4730: fnd_log.STRING(l_proc_level
4731: ,g_module_prefix || l_procedure_name || '.end'
4732: ,'end procedure');
4733: END IF;
4734:

Line 4738: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

4734:
4735: EXCEPTION
4736:
4737: WHEN OTHERS THEN
4738: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4739: THEN
4740: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4741: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
4742: , Sqlcode||Sqlerrm);

Line 4740: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

4736:
4737: WHEN OTHERS THEN
4738: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4739: THEN
4740: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4741: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
4742: , Sqlcode||Sqlerrm);
4743: END IF;
4744: RAISE;