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

Line 146: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

142: )
143: RETURN VARCHAR2
144: IS
145: l_procedure_name VARCHAR2(30) := 'get_invoice_type';
146: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
147: l_proc_level NUMBER := fnd_log.LEVEL_PROCEDURE;
148: l_error_string VARCHAR2(1000);
149:
150: l_invoice_type jmf_gta_tax_limits_all.invoice_type%TYPE;

Line 147: l_proc_level NUMBER := fnd_log.LEVEL_PROCEDURE;

143: RETURN VARCHAR2
144: IS
145: l_procedure_name VARCHAR2(30) := 'get_invoice_type';
146: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
147: l_proc_level NUMBER := fnd_log.LEVEL_PROCEDURE;
148: l_error_string VARCHAR2(1000);
149:
150: l_invoice_type jmf_gta_tax_limits_all.invoice_type%TYPE;
151:

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

190: '||l_error_string||'
191: Y
192: ');*/
193: -- begin log
194: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
195: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
196: ,G_MODULE_PREFIX || l_procedure_name
197: , 'transaction type is not mapped to any invoice type.');
198: END IF;

Line 195: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

191: Y
192: ');*/
193: -- begin log
194: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
195: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
196: ,G_MODULE_PREFIX || l_procedure_name
197: , 'transaction type is not mapped to any invoice type.');
198: END IF;
199: -- end log

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

222: PROCEDURE log
223: (p_message IN VARCHAR2)
224: IS
225: BEGIN
226: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
227: THEN
228: fnd_log.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE
229: ,MODULE => g_module_prefix || '.Debug'
230: ,MESSAGE => p_message

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

224: IS
225: BEGIN
226: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
227: THEN
228: fnd_log.STRING(LOG_LEVEL => FND_LOG.LEVEL_PROCEDURE
229: ,MODULE => g_module_prefix || '.Debug'
230: ,MESSAGE => p_message
231: );
232: END IF;

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

457: l_gta_trx_tbl jmf_gta_trx_util.trx_tbl_type;
458: l_index NUMBER;
459:
460: BEGIN
461: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
462: THEN
463: fnd_log.STRING(fnd_log.level_procedure
464: ,g_module_prefix || l_procedure_name
465: ,'Begin Procedure. ');

Line 463: fnd_log.STRING(fnd_log.level_procedure

459:
460: BEGIN
461: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
462: THEN
463: fnd_log.STRING(fnd_log.level_procedure
464: ,g_module_prefix || l_procedure_name
465: ,'Begin Procedure. ');
466: END IF;
467: -- begin log

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

464: ,g_module_prefix || l_procedure_name
465: ,'Begin Procedure. ');
466: END IF;
467: -- begin log
468: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
469: THEN
470: log( 'begin create_trxs '||p_gta_trxs.COUNT);
471: END IF;
472: -- end log

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

481: l_index := l_gta_trx_tbl.NEXT(l_index);
482:
483: END LOOP;
484:
485: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
486: THEN
487: fnd_log.STRING(fnd_log.level_procedure
488: ,g_module_prefix || l_procedure_name
489: ,'End Procedure. ');

Line 487: fnd_log.STRING(fnd_log.level_procedure

483: END LOOP;
484:
485: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
486: THEN
487: fnd_log.STRING(fnd_log.level_procedure
488: ,g_module_prefix || l_procedure_name
489: ,'End Procedure. ');
490: END IF;
491:

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

490: END IF;
491:
492: EXCEPTION
493: WHEN OTHERS THEN
494: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
495: THEN
496: fnd_log.STRING(fnd_log.level_unexpected
497: ,g_module_prefix || l_procedure_name ||
498: '. OTHER_EXCEPTION '

Line 496: fnd_log.STRING(fnd_log.level_unexpected

492: EXCEPTION
493: WHEN OTHERS THEN
494: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
495: THEN
496: fnd_log.STRING(fnd_log.level_unexpected
497: ,g_module_prefix || l_procedure_name ||
498: '. OTHER_EXCEPTION '
499: ,SQLCODE || SQLERRM);
500: END IF;

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

533: l_count NUMBER;
534:
535: BEGIN
536:
537: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
538: THEN
539: fnd_log.STRING(fnd_log.level_procedure
540: ,g_module_prefix || l_procedure_name
541: ,'Begin Procedure. ');

Line 539: fnd_log.STRING(fnd_log.level_procedure

535: BEGIN
536:
537: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
538: THEN
539: fnd_log.STRING(fnd_log.level_procedure
540: ,g_module_prefix || l_procedure_name
541: ,'Begin Procedure. ');
542: END IF;
543:

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

541: ,'Begin Procedure. ');
542: END IF;
543:
544: -- begin log
545: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
546: THEN
547: log('begin create_trx '||p_gta_trx.trx_header.ra_trx_id);
548: END IF;
549: -- end log

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

632: l_count := p_gta_trx.trx_lines.FIRST;
633: WHILE l_count IS NOT NULL
634: LOOP
635: -- begin log
636: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
637: THEN
638: log( 'begin create_trx_line '||p_gta_trx.trx_lines(l_count).ar_trx_line_id);
639: END IF;
640: -- end log

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

693:
694: l_count := p_gta_trx.trx_lines.NEXT(l_count);
695: END LOOP;
696:
697: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
698: THEN
699: fnd_log.STRING(fnd_log.level_procedure
700: ,g_module_prefix || l_procedure_name
701: ,'End Procedure. ');

Line 699: fnd_log.STRING(fnd_log.level_procedure

695: END LOOP;
696:
697: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
698: THEN
699: fnd_log.STRING(fnd_log.level_procedure
700: ,g_module_prefix || l_procedure_name
701: ,'End Procedure. ');
702: END IF;
703:

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

702: END IF;
703:
704: EXCEPTION
705: WHEN dup_val_on_index THEN
706: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
707: THEN
708: fnd_log.STRING(fnd_log.level_unexpected
709: ,g_module_prefix || l_procedure_name ||
710: '. dup_val_on_index '

Line 708: fnd_log.STRING(fnd_log.level_unexpected

704: EXCEPTION
705: WHEN dup_val_on_index THEN
706: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
707: THEN
708: fnd_log.STRING(fnd_log.level_unexpected
709: ,g_module_prefix || l_procedure_name ||
710: '. dup_val_on_index '
711: ,SQLCODE || SQLERRM);
712: END IF;

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

711: ,SQLCODE || SQLERRM);
712: END IF;
713:
714: WHEN OTHERS THEN
715: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
716: THEN
717: fnd_log.STRING(fnd_log.level_unexpected
718: ,g_module_prefix || l_procedure_name ||
719: '. OTHER_EXCEPTION '

Line 717: fnd_log.STRING(fnd_log.level_unexpected

713:
714: WHEN OTHERS THEN
715: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
716: THEN
717: fnd_log.STRING(fnd_log.level_unexpected
718: ,g_module_prefix || l_procedure_name ||
719: '. OTHER_EXCEPTION '
720: ,'Exception occur when insert data into database' ||
721: SQLCODE || SQLERRM);

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

720: ,'Exception occur when insert data into database' ||
721: SQLCODE || SQLERRM);
722:
723: -- begin log
724: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
725: THEN
726: log( 'Exception occur when insert data into database' ||SQLCODE || SQLERRM);
727: END IF;
728: -- end log

Line 953: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

949: AND tax_currency_code=l_gt_currency_code
950: AND event_class_code IN ('INVOICE','CREDIT_MEMO','DEBIT_MEMO')--jogen bug5212702 May-17,2006
951: AND trx_id=pc_trx_id; --jogen bug5212702 May-17,2006
952:
953: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
954: l_proc_level NUMBER := fnd_log.level_procedure;
955: l_procedure_name VARCHAR2(30) := 'Check_Taxcount_Of_Arline';
956:
957: BEGIN

Line 954: l_proc_level NUMBER := fnd_log.level_procedure;

950: AND event_class_code IN ('INVOICE','CREDIT_MEMO','DEBIT_MEMO')--jogen bug5212702 May-17,2006
951: AND trx_id=pc_trx_id; --jogen bug5212702 May-17,2006
952:
953: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
954: l_proc_level NUMBER := fnd_log.level_procedure;
955: l_procedure_name VARCHAR2(30) := 'Check_Taxcount_Of_Arline';
956:
957: BEGIN
958: --logging for debug

Line 961: fnd_log.STRING(l_proc_level

957: BEGIN
958: --logging for debug
959: IF (l_proc_level >= l_dbg_level)
960: THEN
961: fnd_log.STRING(l_proc_level
962: ,g_module_prefix || l_procedure_name || '.begin'
963: ,'Enter function');
964: END IF; --l_proc_level>=l_dbg_level)
965:

Line 991: fnd_log.STRING(l_proc_level

987:
988: --logging for debug
989: IF (l_proc_level >= l_dbg_level)
990: THEN
991: fnd_log.STRING(l_proc_level
992: ,g_module_prefix || l_procedure_name || '.End'
993: ,'Exit function');
994: END IF; --l_proc_level>=l_dbg_level)
995:

Line 1073: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1069: HAVING COUNT(*)>1);
1070:
1071:
1072:
1073: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1074: l_proc_level NUMBER := fnd_log.level_procedure;
1075: l_procedure_name VARCHAR2(30) := 'Check_Taxcount_Of_Artrx';
1076:
1077: BEGIN

Line 1074: l_proc_level NUMBER := fnd_log.level_procedure;

1070:
1071:
1072:
1073: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1074: l_proc_level NUMBER := fnd_log.level_procedure;
1075: l_procedure_name VARCHAR2(30) := 'Check_Taxcount_Of_Artrx';
1076:
1077: BEGIN
1078: --logging for debug

Line 1081: fnd_log.STRING(l_proc_level

1077: BEGIN
1078: --logging for debug
1079: IF (l_proc_level >= l_dbg_level)
1080: THEN
1081: fnd_log.STRING(l_proc_level
1082: ,g_module_prefix || l_procedure_name || '.begin'
1083: ,'Enter function');
1084: END IF; --l_proc_level>=l_dbg_level)
1085:

Line 1101: fnd_log.STRING(l_proc_level

1097:
1098: --logging for debug
1099: IF (l_proc_level >= l_dbg_level)
1100: THEN
1101: fnd_log.STRING(l_proc_level
1102: ,g_module_prefix || l_procedure_name || '.End'
1103: ,'Exit function');
1104: END IF; --l_proc_level>=l_dbg_level)
1105:

Line 1146: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1142: )
1143: RETURN NUMBER
1144: IS
1145: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Amount';
1146: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1147: l_proc_level NUMBER := fnd_log.level_procedure;
1148:
1149: l_tax_type_code zx_lines.tax_type_code%TYPE;
1150: l_gt_currency_code fnd_currencies.currency_code%TYPE;

Line 1147: l_proc_level NUMBER := fnd_log.level_procedure;

1143: RETURN NUMBER
1144: IS
1145: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Amount';
1146: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1147: l_proc_level NUMBER := fnd_log.level_procedure;
1148:
1149: l_tax_type_code zx_lines.tax_type_code%TYPE;
1150: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1151: l_ar_taxable_amount NUMBER;

Line 1182: fnd_log.STRING(l_proc_level

1178: BEGIN
1179: --logging for debug
1180: IF (l_proc_level >= l_dbg_level)
1181: THEN
1182: fnd_log.STRING(l_proc_level
1183: ,g_module_prefix || l_procedure_name || '.begin'
1184: ,'enter function');
1185: END IF;--(l_proc_level >= l_dbg_level)
1186:

Line 1202: fnd_log.STRING(l_proc_level

1198:
1199: --logging for debug
1200: IF (l_proc_level >= l_dbg_level)
1201: THEN
1202: fnd_log.STRING(l_proc_level
1203: ,g_module_prefix || l_procedure_name || '.end'
1204: ,'end function');
1205: END IF; --(l_proc_level >= l_dbg_level)
1206:

Line 1241: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1237: )
1238: RETURN NUMBER
1239: IS
1240: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Tax_Amount';
1241: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1242: l_proc_level NUMBER := fnd_log.level_procedure;
1243:
1244: l_tax_type_code zx_lines.tax_type_code%TYPE;
1245: l_gt_currency_code fnd_currencies.currency_code%TYPE;

Line 1242: l_proc_level NUMBER := fnd_log.level_procedure;

1238: RETURN NUMBER
1239: IS
1240: l_procedure_name VARCHAR2(30) := 'Get_Arinvoice_Tax_Amount';
1241: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1242: l_proc_level NUMBER := fnd_log.level_procedure;
1243:
1244: l_tax_type_code zx_lines.tax_type_code%TYPE;
1245: l_gt_currency_code fnd_currencies.currency_code%TYPE;
1246: l_ar_tax_amount NUMBER;

Line 1277: fnd_log.STRING(l_proc_level

1273: BEGIN
1274: --logging for debug
1275: IF (l_proc_level >= l_dbg_level)
1276: THEN
1277: fnd_log.STRING(l_proc_level
1278: ,g_module_prefix || l_procedure_name || '.begin'
1279: ,'enter function');
1280: END IF;--(l_proc_level >= l_dbg_level)
1281:

Line 1297: fnd_log.STRING(l_proc_level

1293:
1294: --logging for debug
1295: IF (l_proc_level >= l_dbg_level)
1296: THEN
1297: fnd_log.STRING(l_proc_level
1298: ,g_module_prefix || l_procedure_name || '.end'
1299: ,'end function');
1300: END IF; --(l_proc_level >= l_dbg_level)
1301:

Line 1370: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1366: --
1367: --===========================================================================
1368: FUNCTION format_date(p_date IN DATE) RETURN VARCHAR2 IS
1369: l_procedure_name VARCHAR2(30) := 'Format_Date';
1370: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1371: l_proc_level NUMBER := fnd_log.level_procedure;
1372: l_ret VARCHAR(40);
1373:
1374: l_date_format fnd_profile_option_values.profile_option_value%TYPE := NULL;

Line 1371: l_proc_level NUMBER := fnd_log.level_procedure;

1367: --===========================================================================
1368: FUNCTION format_date(p_date IN DATE) RETURN VARCHAR2 IS
1369: l_procedure_name VARCHAR2(30) := 'Format_Date';
1370: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1371: l_proc_level NUMBER := fnd_log.level_procedure;
1372: l_ret VARCHAR(40);
1373:
1374: l_date_format fnd_profile_option_values.profile_option_value%TYPE := NULL;
1375:

Line 1380: fnd_log.STRING(l_proc_level

1376: BEGIN
1377: --logging for debug
1378: IF (l_proc_level >= l_dbg_level)
1379: THEN
1380: fnd_log.STRING(l_proc_level
1381: ,g_module_prefix || l_procedure_name || '.begin'
1382: ,'enter function');
1383: END IF;
1384:

Line 1394: fnd_log.STRING(l_proc_level

1390:
1391: --logging for debug
1392: IF (l_proc_level >= l_dbg_level)
1393: THEN
1394: fnd_log.STRING(l_proc_level
1395: ,g_module_prefix || l_procedure_name || '.end'
1396: ,'end function');
1397: END IF;
1398:

Line 1457: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1453: )
1454: AND hcp.primary_flag = 'Y';
1455:
1456: l_procedure_name VARCHAR2(30) := 'Get_Primary_Phone_Number';
1457: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1458: l_proc_level NUMBER := fnd_log.level_procedure;
1459: BEGIN
1460:
1461: --logging for debug

Line 1458: l_proc_level NUMBER := fnd_log.level_procedure;

1454: AND hcp.primary_flag = 'Y';
1455:
1456: l_procedure_name VARCHAR2(30) := 'Get_Primary_Phone_Number';
1457: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1458: l_proc_level NUMBER := fnd_log.level_procedure;
1459: BEGIN
1460:
1461: --logging for debug
1462: IF (l_proc_level >= l_dbg_level)

Line 1464: fnd_log.STRING(l_proc_level

1460:
1461: --logging for debug
1462: IF (l_proc_level >= l_dbg_level)
1463: THEN
1464: fnd_log.STRING(l_proc_level
1465: ,g_module_prefix || l_procedure_name || '.begin'
1466: ,'Enter function');
1467: END IF; --l_proc_level>=l_dbg_level)
1468: OPEN c_phone_number;

Line 1476: fnd_log.STRING(l_proc_level

1472:
1473: --logging for debug
1474: IF (l_proc_level >= l_dbg_level)
1475: THEN
1476: fnd_log.STRING(l_proc_level
1477: ,g_module_prefix || l_procedure_name || '.End'
1478: ,'Exit function');
1479: END IF; --l_proc_level>=l_dbg_level)
1480:

Line 1508: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1504: -- 26-Dec-2005: Qiang Li fix a performance issue
1505: --=========================================================================
1506: FUNCTION get_operatingunit(p_org_id IN NUMBER) RETURN VARCHAR2 IS
1507: l_procedure_name VARCHAR2(30) := 'Get_OperatingUnit';
1508: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1509: l_proc_level NUMBER := fnd_log.level_procedure;
1510:
1511: l_operating_unit hr_operating_units.NAME%TYPE;
1512: CURSOR c_operating_unit IS

Line 1509: l_proc_level NUMBER := fnd_log.level_procedure;

1505: --=========================================================================
1506: FUNCTION get_operatingunit(p_org_id IN NUMBER) RETURN VARCHAR2 IS
1507: l_procedure_name VARCHAR2(30) := 'Get_OperatingUnit';
1508: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1509: l_proc_level NUMBER := fnd_log.level_procedure;
1510:
1511: l_operating_unit hr_operating_units.NAME%TYPE;
1512: CURSOR c_operating_unit IS
1513: SELECT OTL.NAME

Line 1524: fnd_log.STRING(l_proc_level

1520: BEGIN
1521: --logging for debug
1522: IF (l_proc_level >= l_dbg_level)
1523: THEN
1524: fnd_log.STRING(l_proc_level
1525: ,g_module_prefix || l_procedure_name || '.begin'
1526: ,'enter function');
1527: END IF;
1528:

Line 1540: fnd_log.STRING(l_proc_level

1536:
1537: --logging for debug
1538: IF (l_proc_level >= l_dbg_level)
1539: THEN
1540: fnd_log.STRING(l_proc_level
1541: ,g_module_prefix || l_procedure_name || '.end'
1542: ,'end function');
1543: END IF;
1544:

Line 1575: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1571: (p_customer_id IN NUMBER)
1572: RETURN VARCHAR2
1573: IS
1574: l_procedure_name VARCHAR2(30) := 'Get_Customer_Name';
1575: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1576: l_proc_level NUMBER := fnd_log.level_procedure;
1577:
1578: l_customer_name hz_parties.party_name%TYPE;
1579: CURSOR c_customer_name IS

Line 1576: l_proc_level NUMBER := fnd_log.level_procedure;

1572: RETURN VARCHAR2
1573: IS
1574: l_procedure_name VARCHAR2(30) := 'Get_Customer_Name';
1575: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1576: l_proc_level NUMBER := fnd_log.level_procedure;
1577:
1578: l_customer_name hz_parties.party_name%TYPE;
1579: CURSOR c_customer_name IS
1580: SELECT

Line 1592: fnd_log.STRING(l_proc_level

1588: BEGIN
1589: --logging for debug
1590: IF (l_proc_level >= l_dbg_level)
1591: THEN
1592: fnd_log.STRING(l_proc_level
1593: ,g_module_prefix || l_procedure_name || '.begin'
1594: ,'enter function');
1595: END IF;
1596:

Line 1609: fnd_log.STRING(l_proc_level

1605:
1606: --logging for debug
1607: IF (l_proc_level >= l_dbg_level)
1608: THEN
1609: fnd_log.STRING(l_proc_level
1610: ,g_module_prefix || l_procedure_name || '.end'
1611: ,'end function');
1612: END IF;
1613:

Line 1683: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1679: ORDER BY tax_line_id;
1680:
1681:
1682:
1683: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1684: l_proc_level NUMBER := fnd_log.level_procedure;
1685: l_procedure_name VARCHAR2(30) := 'Get_Arline_Amount';
1686:
1687: BEGIN

Line 1684: l_proc_level NUMBER := fnd_log.level_procedure;

1680:
1681:
1682:
1683: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1684: l_proc_level NUMBER := fnd_log.level_procedure;
1685: l_procedure_name VARCHAR2(30) := 'Get_Arline_Amount';
1686:
1687: BEGIN
1688: --logging for debug

Line 1691: fnd_log.STRING(l_proc_level

1687: BEGIN
1688: --logging for debug
1689: IF (l_proc_level >= l_dbg_level)
1690: THEN
1691: fnd_log.STRING(l_proc_level
1692: ,g_module_prefix || l_procedure_name || '.begin'
1693: ,'Enter function');
1694: END IF; --l_proc_level>=l_dbg_level)
1695:

Line 1721: fnd_log.STRING(l_proc_level

1717:
1718: --logging for debug
1719: IF (l_proc_level >= l_dbg_level)
1720: THEN
1721: fnd_log.STRING(l_proc_level
1722: ,g_module_prefix || l_procedure_name || '.End'
1723: ,'Exit function');
1724: END IF; --l_proc_level>=l_dbg_level)
1725:

Line 1795: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1791: ORDER BY tax_line_id;
1792:
1793:
1794:
1795: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1796: l_proc_level NUMBER := fnd_log.level_procedure;
1797: l_procedure_name VARCHAR2(30) := 'Get_Arline_Vattax_Amount';
1798:
1799: BEGIN

Line 1796: l_proc_level NUMBER := fnd_log.level_procedure;

1792:
1793:
1794:
1795: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1796: l_proc_level NUMBER := fnd_log.level_procedure;
1797: l_procedure_name VARCHAR2(30) := 'Get_Arline_Vattax_Amount';
1798:
1799: BEGIN
1800: --logging for debug

Line 1803: fnd_log.STRING(l_proc_level

1799: BEGIN
1800: --logging for debug
1801: IF (l_proc_level >= l_dbg_level)
1802: THEN
1803: fnd_log.STRING(l_proc_level
1804: ,g_module_prefix || l_procedure_name || '.begin'
1805: ,'Enter function');
1806: END IF; --l_proc_level>=l_dbg_level)
1807:

Line 1834: fnd_log.STRING(l_proc_level

1830:
1831: --logging for debug
1832: IF (l_proc_level >= l_dbg_level)
1833: THEN
1834: fnd_log.STRING(l_proc_level
1835: ,g_module_prefix || l_procedure_name || '.End'
1836: ,'Exit function');
1837: END IF; --l_proc_level>=l_dbg_level)
1838:

Line 1906: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1902: ORDER BY tax_line_id;
1903:
1904:
1905:
1906: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1907: l_proc_level NUMBER := fnd_log.level_procedure;
1908: l_procedure_name VARCHAR2(30) := 'Get_Arline_Vattax_Rate';
1909:
1910: BEGIN

Line 1907: l_proc_level NUMBER := fnd_log.level_procedure;

1903:
1904:
1905:
1906: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1907: l_proc_level NUMBER := fnd_log.level_procedure;
1908: l_procedure_name VARCHAR2(30) := 'Get_Arline_Vattax_Rate';
1909:
1910: BEGIN
1911: --logging for debug

Line 1914: fnd_log.STRING(l_proc_level

1910: BEGIN
1911: --logging for debug
1912: IF (l_proc_level >= l_dbg_level)
1913: THEN
1914: fnd_log.STRING(l_proc_level
1915: ,g_module_prefix || l_procedure_name || '.begin'
1916: ,'Enter function');
1917: END IF; --l_proc_level>=l_dbg_level)
1918:

Line 1943: fnd_log.STRING(l_proc_level

1939:
1940: --logging for debug
1941: IF (l_proc_level >= l_dbg_level)
1942: THEN
1943: fnd_log.STRING(l_proc_level
1944: ,g_module_prefix || l_procedure_name || '.End'
1945: ,'Exit function');
1946: END IF; --l_proc_level>=l_dbg_level)
1947:

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

2013:
2014:
2015:
2016: BEGIN
2017: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2018: THEN
2019: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2020: , G_MODULE_PREFIX || l_procedure_name
2021: ,'begin Procedure. ');

Line 2019: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2015:
2016: BEGIN
2017: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2018: THEN
2019: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2020: , G_MODULE_PREFIX || l_procedure_name
2021: ,'begin Procedure. ');
2022: END IF;
2023:

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

2042: '||l_error_string||'
2043: ');
2044:
2045:
2046: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2047: THEN
2048: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
2049: , G_MODULE_PREFIX || l_procedure_name
2050: , l_error_string);

Line 2048: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

2044:
2045:
2046: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2047: THEN
2048: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
2049: , G_MODULE_PREFIX || l_procedure_name
2050: , l_error_string);
2051: END IF;
2052: RAISE;

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

2066:
2067: WHERE h.customer_trx_id = p_customer_trx_id ;
2068: EXCEPTION
2069: WHEN no_data_found THEN
2070: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2071: THEN
2072: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2073: , G_MODULE_PREFIX || l_procedure_name
2074: , 'no date found when select header info');

Line 2072: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2068: EXCEPTION
2069: WHEN no_data_found THEN
2070: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2071: THEN
2072: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2073: , G_MODULE_PREFIX || l_procedure_name
2074: , 'no date found when select header info');
2075: END IF;
2076: END;

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

2112: AND x.trxn_extension_id = l_trxn_extension_id;
2113:
2114: EXCEPTION
2115: WHEN no_data_found THEN
2116: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2117: THEN
2118: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2119: , G_MODULE_PREFIX || l_procedure_name
2120: , 'no date found when select bank information');

Line 2118: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2114: EXCEPTION
2115: WHEN no_data_found THEN
2116: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2117: THEN
2118: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2119: , G_MODULE_PREFIX || l_procedure_name
2120: , 'no date found when select bank information');
2121: END IF;
2122: END;

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

2131: WHERE
2132: ext_bank_account_id = l_instrument_id;
2133: EXCEPTION
2134: WHEN no_data_found THEN
2135: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2136: THEN
2137: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2138: , G_MODULE_PREFIX || l_procedure_name
2139: , 'no date found when select bank information');

Line 2137: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2133: EXCEPTION
2134: WHEN no_data_found THEN
2135: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2136: THEN
2137: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2138: , G_MODULE_PREFIX || l_procedure_name
2139: , 'no date found when select bank information');
2140: END IF;
2141: END;

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

2222:
2223:
2224: EXCEPTION
2225: WHEN no_data_found THEN
2226: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2227: THEN
2228: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2229: , G_MODULE_PREFIX || l_procedure_name
2230: , 'no date found when select bank information');

Line 2228: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2224: EXCEPTION
2225: WHEN no_data_found THEN
2226: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2227: THEN
2228: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2229: , G_MODULE_PREFIX || l_procedure_name
2230: , 'no date found when select bank information');
2231: END IF;
2232: END;/*l_apba_bank_account_num IS NULL*/

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

2237: x_bank_branch_name := l_bank_branch_name;
2238: x_bank_account_num := l_bank_account_num;
2239: x_bank_account_name := l_bank_account_name;
2240:
2241: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2242: THEN
2243: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2244: , G_MODULE_PREFIX || l_procedure_name
2245: ,'End Procedure. ');

Line 2243: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2239: x_bank_account_name := l_bank_account_name;
2240:
2241: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2242: THEN
2243: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2244: , G_MODULE_PREFIX || l_procedure_name
2245: ,'End Procedure. ');
2246: END IF;
2247:

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

2246: END IF;
2247:
2248: EXCEPTION
2249: WHEN OTHERS THEN
2250: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2251: THEN
2252: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2253: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2254: , Sqlcode||Sqlerrm);

Line 2252: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

2248: EXCEPTION
2249: WHEN OTHERS THEN
2250: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2251: THEN
2252: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2253: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2254: , Sqlcode||Sqlerrm);
2255: END IF;
2256: RAISE;

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

2294: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;--jogen bug5212702 May-17,2006
2295:
2296: BEGIN
2297:
2298: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2299: THEN
2300: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2301: , G_MODULE_PREFIX || l_procedure_name
2302: ,'begin Procedure. ');

Line 2300: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2296: BEGIN
2297:
2298: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2299: THEN
2300: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2301: , G_MODULE_PREFIX || l_procedure_name
2302: ,'begin Procedure. ');
2303: END IF;
2304:

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

2301: , G_MODULE_PREFIX || l_procedure_name
2302: ,'begin Procedure. ');
2303: END IF;
2304:
2305: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2306: THEN
2307: log( 'Begin Verify_Tax_line---');
2308: log( 'p_trx_line_id :'||p_trx_line_id);
2309: log( 'p_tax_type_code :'||p_tax_type_code);

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

2365: END IF;/*l_tax_line_count = 0*/
2366:
2367: x_tax_line_id := l_tax_line_id;
2368:
2369: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2370: THEN
2371: log( 'x_status : '||x_status);
2372: END IF;
2373:

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

2370: THEN
2371: log( 'x_status : '||x_status);
2372: END IF;
2373:
2374: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2375: THEN
2376: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2377: , G_MODULE_PREFIX || l_procedure_name
2378: ,'End Procedure. ');

Line 2376: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2372: END IF;
2373:
2374: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2375: THEN
2376: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2377: , G_MODULE_PREFIX || l_procedure_name
2378: ,'End Procedure. ');
2379: END IF;
2380:

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

2377: , G_MODULE_PREFIX || l_procedure_name
2378: ,'End Procedure. ');
2379: END IF;
2380:
2381: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2382: THEN
2383: log( 'End Verify_Tax_line---');
2384: END IF;
2385:

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

2384: END IF;
2385:
2386: EXCEPTION
2387: WHEN OTHERS THEN
2388: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2389: THEN
2390: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2391: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2392: , Sqlcode||Sqlerrm);

Line 2390: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

2386: EXCEPTION
2387: WHEN OTHERS THEN
2388: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2389: THEN
2390: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2391: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2392: , Sqlcode||Sqlerrm);
2393: END IF;
2394: RAISE;

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

2472:
2473: tax_error_for_recycle EXCEPTION; --exception for tax_amount check for recycle Invoice
2474:
2475: BEGIN
2476: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2477: THEN
2478: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2479: , G_MODULE_PREFIX || l_procedure_name
2480: ,'begin Procedure. ');

Line 2478: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2474:
2475: BEGIN
2476: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2477: THEN
2478: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2479: , G_MODULE_PREFIX || l_procedure_name
2480: ,'begin Procedure. ');
2481: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2482: , G_MODULE_PREFIX || l_procedure_name

Line 2481: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2477: THEN
2478: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2479: , G_MODULE_PREFIX || l_procedure_name
2480: ,'begin Procedure. ');
2481: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2482: , G_MODULE_PREFIX || l_procedure_name
2483: ,'p_trx_line_id: '||p_trx_line_id);
2484:
2485: END IF;

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

2483: ,'p_trx_line_id: '||p_trx_line_id);
2484:
2485: END IF;
2486:
2487: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2488: THEN
2489: log( 'Begin Get_Info_From_Ebtax --');
2490: log( 'p_org_id : '||p_org_id);
2491: log( 'p_trx_id : '||p_trx_id);

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

2520: '||l_error_string||'
2521: ');
2522:
2523:
2524: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2525: THEN
2526: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
2527: , G_MODULE_PREFIX || l_procedure_name
2528: , l_error_string);

Line 2526: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

2522:
2523:
2524: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2525: THEN
2526: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
2527: , G_MODULE_PREFIX || l_procedure_name
2528: , l_error_string);
2529: END IF;
2530:

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

2672: OR l_tax_amount IS NULL
2673: OR l_unit_price IS NULL
2674: OR l_trx_line_quantity IS NULL
2675: THEN
2676: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2677: THEN
2678: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2679: , G_MODULE_PREFIX || l_procedure_name
2680: ,'The data come from ebtax is null. ');

Line 2678: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2674: OR l_trx_line_quantity IS NULL
2675: THEN
2676: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2677: THEN
2678: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2679: , G_MODULE_PREFIX || l_procedure_name
2680: ,'The data come from ebtax is null. ');
2681: END IF;
2682: END IF;

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

2695:
2696: END IF;
2697:
2698: -- output the status
2699: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2700: THEN
2701: log( 'x_status '||x_status);
2702: END IF;
2703:

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

2719: x_tax_curr_unit_price := round(l_unit_price * l_tax_curr_conversion_rate);
2720:
2721:
2722:
2723: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2724: THEN
2725: log( 'End Get_Info_From_Ebtax --');
2726: END IF;
2727:

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

2724: THEN
2725: log( 'End Get_Info_From_Ebtax --');
2726: END IF;
2727:
2728: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2729: THEN
2730: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2731: , G_MODULE_PREFIX || l_procedure_name
2732: ,'End Procedure. ');

Line 2730: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2726: END IF;
2727:
2728: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2729: THEN
2730: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2731: , G_MODULE_PREFIX || l_procedure_name
2732: ,'End Procedure. ');
2733: END IF;
2734:

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

2737:
2738: fnd_message.SET_NAME('JMF', 'JMF_GTA_TAX_ERROR_RECYCLE');
2739: l_error_string := fnd_message.get();
2740: -- begin log
2741: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2742: THEN
2743: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2744: , G_MODULE_PREFIX || l_procedure_name
2745: , 'tax rate and tax amount should be zero for Recycle Invoices');

Line 2743: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

2739: l_error_string := fnd_message.get();
2740: -- begin log
2741: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2742: THEN
2743: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2744: , G_MODULE_PREFIX || l_procedure_name
2745: , 'tax rate and tax amount should be zero for Recycle Invoices');
2746: END IF;
2747: RAISE;

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

2748:
2749: -- end log
2750: RAISE;*/
2751: WHEN OTHERS THEN
2752: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2753: THEN
2754: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2755: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2756: , Sqlcode||Sqlerrm);

Line 2754: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

2750: RAISE;*/
2751: WHEN OTHERS THEN
2752: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2753: THEN
2754: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2755: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2756: , Sqlcode||Sqlerrm);
2757: END IF;
2758: RAISE;

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

2848: AND p_tax_determine_date >= reg.effective_from
2849: AND (p_tax_determine_date < reg.effective_to OR reg.effective_to IS NULL)
2850: AND reg.registration_number IS NOT NULL;
2851: BEGIN
2852: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2853: THEN
2854: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2855: , G_MODULE_PREFIX || l_procedure_name
2856: ,'begin Procedure. ');

Line 2854: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2850: AND reg.registration_number IS NOT NULL;
2851: BEGIN
2852: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2853: THEN
2854: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2855: , G_MODULE_PREFIX || l_procedure_name
2856: ,'begin Procedure. ');
2857:
2858: END IF;

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

2856: ,'begin Procedure. ');
2857:
2858: END IF;
2859:
2860: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2861: THEN
2862: log( 'Begin Get_Info_From_Ebtax --');
2863: log( 'p_trx_id :'||p_trx_id);
2864: log( 'p_tax_line_id:' ||p_tax_line_id);

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

2893: hz_cust_acct_sites_all
2894: WHERE cust_acct_site_id = l_cust_acct_site_id;
2895: EXCEPTION
2896: WHEN no_data_found THEN
2897: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2898: THEN
2899: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2900: , G_MODULE_PREFIX || l_procedure_name
2901: , l_procedure_name||'no data found ');

Line 2899: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2895: EXCEPTION
2896: WHEN no_data_found THEN
2897: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2898: THEN
2899: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2900: , G_MODULE_PREFIX || l_procedure_name
2901: , l_procedure_name||'no data found ');
2902: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
2903: END;

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

2898: THEN
2899: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2900: , G_MODULE_PREFIX || l_procedure_name
2901: , l_procedure_name||'no data found ');
2902: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
2903: END;
2904:
2905: -- get the tax_regime, tax, tax_jurisdiction by trx line id ;
2906: BEGIN

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

2920: tax.tax_line_id = p_tax_line_id;
2921:
2922: EXCEPTION
2923: WHEN no_data_found THEN
2924: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2925: THEN
2926: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2927: , G_MODULE_PREFIX || l_procedure_name
2928: , 'no data found ');

Line 2926: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2922: EXCEPTION
2923: WHEN no_data_found THEN
2924: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2925: THEN
2926: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2927: , G_MODULE_PREFIX || l_procedure_name
2928: , 'no data found ');
2929: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
2930:

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

2925: THEN
2926: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2927: , G_MODULE_PREFIX || l_procedure_name
2928: , 'no data found ');
2929: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
2930:
2931: END;
2932:
2933: -- get tax_profile_id by party site id

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

2941: WHERE tax_prof.party_id = l_party_site_id
2942: AND tax_prof.party_type_code = 'THIRD_PARTY_SITE';
2943: EXCEPTION
2944: WHEN no_data_found THEN
2945: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2946: THEN
2947: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2948: , G_MODULE_PREFIX || l_procedure_name
2949: , 'no data found ');

Line 2947: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2943: EXCEPTION
2944: WHEN no_data_found THEN
2945: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2946: THEN
2947: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2948: , G_MODULE_PREFIX || l_procedure_name
2949: , 'no data found ');
2950: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
2951: WHEN too_many_rows THEN

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

2946: THEN
2947: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2948: , G_MODULE_PREFIX || l_procedure_name
2949: , 'no data found ');
2950: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
2951: WHEN too_many_rows THEN
2952: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2953: THEN
2954: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

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

2948: , G_MODULE_PREFIX || l_procedure_name
2949: , 'no data found ');
2950: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
2951: WHEN too_many_rows THEN
2952: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2953: THEN
2954: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2955: , G_MODULE_PREFIX || l_procedure_name
2956: , 'too many rows ');

Line 2954: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2950: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
2951: WHEN too_many_rows THEN
2952: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2953: THEN
2954: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2955: , G_MODULE_PREFIX || l_procedure_name
2956: , 'too many rows ');
2957: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
2958: END;

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

2953: THEN
2954: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2955: , G_MODULE_PREFIX || l_procedure_name
2956: , 'too many rows ');
2957: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
2958: END;
2959:
2960: /*
2961: dbms_output.put_line('l_bill_to_site_use_id: '||l_bill_to_site_use_id);

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

2963: dbms_output.put_line('l_tax: '||l_tax);
2964: dbms_output.put_line('l_tax_jurisdiction_code: '||l_tax_jurisdiction_code);
2965: dbms_output.put_line('l_party_tax_profile_id: '||l_party_tax_profile_id);
2966: */
2967: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2968: THEN
2969: log( 'l_bill_to_site_use_id :'||l_bill_to_site_use_id);
2970: log( 'l_tax_regime_code:' ||l_tax_regime_code);
2971: log( 'l_tax:' ||l_tax);

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

3022:
3023: ELSE /*l_tax_regime_code IS NOT NULL AND l_tax IS NOT NULL AND l_tax_determine_date IS NOT NULL*/
3024: x_tp_tax_registration_number := NULL;
3025:
3026: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3027: THEN
3028: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3029: , G_MODULE_PREFIX || l_procedure_name
3030: ,'tax or tax_jur is null in zx_lines ');

Line 3028: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3024: x_tp_tax_registration_number := NULL;
3025:
3026: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3027: THEN
3028: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3029: , G_MODULE_PREFIX || l_procedure_name
3030: ,'tax or tax_jur is null in zx_lines ');
3031: END IF;
3032:

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

3032:
3033: END IF;/*l_tax_regime_code IS NOT NULL AND l_tax IS NOT NULL AND l_tax_determine_date IS NOT NULL*/
3034:
3035: --dbms_output.put_line('registration_number: '||l_tax_registration_number);
3036: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3037: THEN
3038: log( 'End Get_Tp_Tax_Registration_Number --');
3039: END IF;
3040:

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

3055:
3056: IF l_msg_count > 0
3057: THEN
3058:
3059: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3060: THEN
3061: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3062: , G_MODULE_PREFIX || l_procedure_name
3063: , 'ZX_API_PUB.get_default_tax_reg error, see below '

Line 3061: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3057: THEN
3058:
3059: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3060: THEN
3061: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3062: , G_MODULE_PREFIX || l_procedure_name
3063: , 'ZX_API_PUB.get_default_tax_reg error, see below '
3064: ||'the detail error messages' );
3065:

Line 3070: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3066: FOR i IN 1..l_msg_count
3067: LOOP
3068: FND_MSG_PUB.Get(i, FND_API.G_FALSE, l_msg_data, l_indexO);
3069: FND_MSG_PUB.Delete_Msg(l_indexO);
3070: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3071: , G_MODULE_PREFIX || l_procedure_name||'.ZX_API_PUB error'
3072: , l_msg_data);
3073:
3074: END LOOP; --i IN 1..l_msg_count

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

3072: , l_msg_data);
3073:
3074: END LOOP; --i IN 1..l_msg_count
3075:
3076: END IF;--FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3077:
3078: END if;--l_msg_count = 0
3079:
3080: IF x_tp_tax_registration_number IS NULL

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

3092: , p_effective_date => SYSDATE);
3093: IF l_msg_count > 0
3094: THEN
3095:
3096: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3097: THEN
3098: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3099: , G_MODULE_PREFIX || l_procedure_name
3100: , 'ZX_API_PUB.get_default_tax_reg error, see below '

Line 3098: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3094: THEN
3095:
3096: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3097: THEN
3098: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3099: , G_MODULE_PREFIX || l_procedure_name
3100: , 'ZX_API_PUB.get_default_tax_reg error, see below '
3101: ||'the detail error messages' );
3102:

Line 3107: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3103: FOR i IN 1..l_msg_count
3104: LOOP
3105: FND_MSG_PUB.Get(i, FND_API.G_FALSE, l_msg_data, l_indexO);
3106: FND_MSG_PUB.Delete_Msg(l_indexO);
3107: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3108: , G_MODULE_PREFIX || l_procedure_name||'.ZX_API_PUB error'
3109: , l_msg_data);
3110:
3111: END LOOP; --i IN 1..l_msg_count

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

3109: , l_msg_data);
3110:
3111: END LOOP; --i IN 1..l_msg_count
3112:
3113: END IF;--FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3114:
3115: END if;--l_msg_count = 0
3116:
3117: END IF;--x_tp_tax_registration_number IS NULL

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

3118:
3119: END IF; --x_tp_tax_registration_number IS NULL
3120: --jogen Mar-21, 2006 bug 5088458
3121:
3122: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3123: THEN
3124: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3125: , G_MODULE_PREFIX || l_procedure_name
3126: ,'End Procedure. ');

Line 3124: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

3120: --jogen Mar-21, 2006 bug 5088458
3121:
3122: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3123: THEN
3124: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
3125: , G_MODULE_PREFIX || l_procedure_name
3126: ,'End Procedure. ');
3127: END IF;
3128:

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

3127: END IF;
3128:
3129: EXCEPTION
3130: WHEN OTHERS THEN
3131: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3132: THEN
3133: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3134: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3135: , Sqlcode||Sqlerrm);

Line 3133: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3129: EXCEPTION
3130: WHEN OTHERS THEN
3131: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3132: THEN
3133: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3134: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3135: , Sqlcode||Sqlerrm);
3136: END IF;
3137: RAISE;

Line 3214: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

3210: ORDER BY tax_line_id;
3211:
3212:
3213:
3214: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3215: l_proc_level NUMBER := fnd_log.level_procedure;
3216: l_procedure_name VARCHAR2(30) :='Get_Arline_Tp_Taxreg_Number';
3217:
3218: BEGIN

Line 3215: l_proc_level NUMBER := fnd_log.level_procedure;

3211:
3212:
3213:
3214: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3215: l_proc_level NUMBER := fnd_log.level_procedure;
3216: l_procedure_name VARCHAR2(30) :='Get_Arline_Tp_Taxreg_Number';
3217:
3218: BEGIN
3219: --logging for debug

Line 3222: fnd_log.STRING(l_proc_level

3218: BEGIN
3219: --logging for debug
3220: IF (l_proc_level >= l_dbg_level)
3221: THEN
3222: fnd_log.STRING(l_proc_level
3223: ,g_module_prefix || l_procedure_name || '.begin'
3224: ,'Enter function');
3225: END IF; --l_proc_level>=l_dbg_level)
3226:

Line 3258: fnd_log.STRING(l_proc_level

3254:
3255: --logging for debug
3256: IF (l_proc_level >= l_dbg_level)
3257: THEN
3258: fnd_log.STRING(l_proc_level
3259: ,g_module_prefix || l_procedure_name || '.End'
3260: ,'Exit function');
3261: END IF; --l_proc_level>=l_dbg_level)
3262:

Line 3292: WHEN 'FND_LOG.STRING' THEN

3288: l_procedure_name VARCHAR2(30) := 'debug_output';
3289: BEGIN
3290:
3291: CASE p_output_to
3292: WHEN 'FND_LOG.STRING' THEN
3293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3294: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3295: ,p_api_name || '.debug_output'
3296: ,p_message);

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

3289: BEGIN
3290:
3291: CASE p_output_to
3292: WHEN 'FND_LOG.STRING' THEN
3293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3294: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3295: ,p_api_name || '.debug_output'
3296: ,p_message);
3297: END IF;

Line 3294: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

3290:
3291: CASE p_output_to
3292: WHEN 'FND_LOG.STRING' THEN
3293: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3294: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3295: ,p_api_name || '.debug_output'
3296: ,p_message);
3297: END IF;
3298: WHEN 'FND_FILE.OUTPUT' THEN

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

3295: ,p_api_name || '.debug_output'
3296: ,p_message);
3297: END IF;
3298: WHEN 'FND_FILE.OUTPUT' THEN
3299: IF (FND_LOG.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
3300: fnd_file.put_line(fnd_file.OUTPUT
3301: ,p_api_name || '.debug_output' || ': ' ||
3302: p_message);
3303: END IF;

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

3301: ,p_api_name || '.debug_output' || ': ' ||
3302: p_message);
3303: END IF;
3304: WHEN 'FND_FILE.LOG' THEN
3305: IF (FND_LOG.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
3306: log(p_api_name || '.debug_output' || ': ' ||
3307: p_message);
3308: END IF;
3309: ELSE

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

3311: END CASE;
3312:
3313: EXCEPTION
3314: WHEN OTHERS THEN
3315: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3316: THEN
3317: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3318: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3319: , Sqlcode||Sqlerrm);

Line 3317: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3313: EXCEPTION
3314: WHEN OTHERS THEN
3315: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3316: THEN
3317: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3318: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3319: , Sqlcode||Sqlerrm);
3320: END IF;
3321: RAISE;

Line 3355: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

3351: , p_source_id IN NUMBER
3352: )
3353: RETURN VARCHAR2 IS
3354: l_procedure_name VARCHAR2(30) := 'Get_AR_Batch_Source_Name';
3355: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3356: l_proc_level NUMBER := fnd_log.level_procedure;
3357:
3358: l_source_name RA_BATCH_SOURCES_all.NAME%TYPE;
3359: CURSOR c_source_name IS

Line 3356: l_proc_level NUMBER := fnd_log.level_procedure;

3352: )
3353: RETURN VARCHAR2 IS
3354: l_procedure_name VARCHAR2(30) := 'Get_AR_Batch_Source_Name';
3355: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3356: l_proc_level NUMBER := fnd_log.level_procedure;
3357:
3358: l_source_name RA_BATCH_SOURCES_all.NAME%TYPE;
3359: CURSOR c_source_name IS
3360: SELECT RA_BATCH_SOURCES_all.NAME

Line 3369: fnd_log.STRING(l_proc_level

3365: BEGIN
3366: --logging for debug
3367: IF (l_proc_level >= l_dbg_level)
3368: THEN
3369: fnd_log.STRING(l_proc_level
3370: ,g_module_prefix || l_procedure_name || '.begin'
3371: ,'enter function');
3372: END IF;
3373:

Line 3385: fnd_log.STRING(l_proc_level

3381:
3382: --logging for debug
3383: IF (l_proc_level >= l_dbg_level)
3384: THEN
3385: fnd_log.STRING(l_proc_level
3386: ,g_module_prefix || l_procedure_name || '.end'
3387: ,'end function');
3388: END IF;
3389:

Line 3425: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

3421: RETURN VARCHAR2
3422: IS
3423: l_xsd_date_string VARCHAR2(40);
3424: l_procedure_name VARCHAR2(30) := 'To_Xsd_Date_String';
3425: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3426: l_proc_level NUMBER := fnd_log.level_procedure;
3427:
3428: BEGIN
3429:

Line 3426: l_proc_level NUMBER := fnd_log.level_procedure;

3422: IS
3423: l_xsd_date_string VARCHAR2(40);
3424: l_procedure_name VARCHAR2(30) := 'To_Xsd_Date_String';
3425: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3426: l_proc_level NUMBER := fnd_log.level_procedure;
3427:
3428: BEGIN
3429:
3430: --logging for debug

Line 3433: fnd_log.STRING(l_proc_level

3429:
3430: --logging for debug
3431: IF (l_proc_level >= l_dbg_level)
3432: THEN
3433: fnd_log.STRING(l_proc_level
3434: ,g_module_prefix || l_procedure_name || '.begin'
3435: ,'enter function');
3436: END IF;
3437:

Line 3443: FND_LOG.string( l_proc_level

3439: IF p_date IS NULL
3440: THEN
3441: IF (l_proc_level >= l_dbg_level)
3442: THEN
3443: FND_LOG.string( l_proc_level
3444: , G_MODULE_PREFIX
3445: , G_MODULE_PREFIX || l_procedure_name
3446: || '.end'
3447: );

Line 3462: FND_LOG.string( l_proc_level

3458:
3459:
3460: IF (l_proc_level >= l_dbg_level)
3461: THEN
3462: FND_LOG.string( l_proc_level
3463: , G_MODULE_PREFIX
3464: , G_MODULE_PREFIX || l_procedure_name
3465: || '.end: Returning XSD Date = '
3466: || l_xsd_date_string);

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

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

Line 3478: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

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

Line 3519: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

3515: )
3516: RETURN VARCHAR2
3517: IS
3518: l_procedure_name VARCHAR2(30) := 'Format_Monetary_Amount';
3519: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3520: l_proc_level NUMBER := fnd_log.level_procedure;
3521: l_base_currency jmf_gta_system_parameters_all.gt_currency_code%TYPE;
3522: l_format_mask VARCHAR2(50);
3523: l_formatted_amount VARCHAR2(50);

Line 3520: l_proc_level NUMBER := fnd_log.level_procedure;

3516: RETURN VARCHAR2
3517: IS
3518: l_procedure_name VARCHAR2(30) := 'Format_Monetary_Amount';
3519: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
3520: l_proc_level NUMBER := fnd_log.level_procedure;
3521: l_base_currency jmf_gta_system_parameters_all.gt_currency_code%TYPE;
3522: l_format_mask VARCHAR2(50);
3523: l_formatted_amount VARCHAR2(50);
3524:

Line 3538: fnd_log.STRING(l_proc_level

3534:
3535: --logging for debug
3536: IF (l_proc_level >= l_dbg_level)
3537: THEN
3538: fnd_log.STRING(l_proc_level
3539: ,g_module_prefix || l_procedure_name || '.begin'
3540: ,'enter function');
3541: END IF;
3542:

Line 3557: fnd_log.STRING(l_proc_level

3553:
3554: --logging for debug
3555: IF (l_proc_level >= l_dbg_level)
3556: THEN
3557: fnd_log.STRING(l_proc_level
3558: ,g_module_prefix || l_procedure_name || '.end'
3559: ,'end function');
3560: END IF;
3561: RETURN l_formatted_amount;

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

3562:
3563: EXCEPTION
3564:
3565: WHEN OTHERS THEN
3566: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3567: THEN
3568: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3569: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3570: , Sqlcode||Sqlerrm);

Line 3568: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3564:
3565: WHEN OTHERS THEN
3566: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3567: THEN
3568: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3569: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
3570: , Sqlcode||Sqlerrm);
3571: END IF;
3572: RAISE;