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_REPORTS_PKG dependencies on FND_LOG

Line 54: --| Adding fnd log |

50: --| 06/03/06 Donghai Wang Update Compare_Header, |
51: --| Compare_Lines,Get_Unmatched_lines|
52: --| Generate_Discrepancy_Xml, |
53: --| Generate_Discrepancy_Rep for |
54: --| Adding fnd log |
55: --| 06/18/07 Donghai Wang Update the procedure compare_lines|
56: --| to fix bug 6132187 |
57: --| 07/05/07 Allen Yang Update procedure compare_header |
58: --| to fix bug 6147067 |

Line 123: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

119: )
120: RETURN VARCHAR2
121: IS
122: l_procedure_name VARCHAR2(40):='Get_Gt_Count';
123: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
124: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
125:
126: l_count NUMBER:=0;
127: BEGIN

Line 124: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

120: RETURN VARCHAR2
121: IS
122: l_procedure_name VARCHAR2(40):='Get_Gt_Count';
123: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
124: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
125:
126: l_count NUMBER:=0;
127: BEGIN
128: --logging for debug

Line 131: FND_LOG.string( l_proc_level

127: BEGIN
128: --logging for debug
129: IF (l_proc_level>=l_dbg_level)
130: THEN
131: FND_LOG.string( l_proc_level
132: , G_MODULE_PREFIX||l_procedure_name||'.begin'
133: , 'enter function'
134: );
135: END IF;

Line 157: FND_LOG.string( l_proc_level

153:
154: --logging for debug
155: IF (l_proc_level>=l_dbg_level)
156: THEN
157: FND_LOG.string( l_proc_level
158: , G_MODULE_PREFIX||l_procedure_name||'.end'
159: , 'end function'
160: );
161: END IF;

Line 219: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

215: )
216: RETURN XMLTYPE
217: IS
218: l_procedure_name VARCHAR2(40):='Get_Ar_Trx';
219: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
220: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
221:
222: l_ret_xmlelement Xmltype;
223: BEGIN

Line 220: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

216: RETURN XMLTYPE
217: IS
218: l_procedure_name VARCHAR2(40):='Get_Ar_Trx';
219: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
220: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
221:
222: l_ret_xmlelement Xmltype;
223: BEGIN
224: --logging for debug

Line 227: FND_LOG.string( l_proc_level

223: BEGIN
224: --logging for debug
225: IF (l_proc_level>=l_dbg_level)
226: THEN
227: FND_LOG.string( l_proc_level
228: , G_MODULE_PREFIX||l_procedure_name||'.begin'
229: , 'enter function'
230: );
231: END IF;

Line 364: FND_LOG.string( l_proc_level

360:
361: --logging for debug
362: IF (l_proc_level>=l_dbg_level)
363: THEN
364: FND_LOG.string( l_proc_level
365: , G_MODULE_PREFIX||l_procedure_name||'.end'
366: , 'end function'
367: );
368: END IF;

Line 419: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

415: )
416: RETURN Xmltype
417: IS
418: l_procedure_name VARCHAR2(40):='Get_Gt_Trxs';
419: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
420: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
421:
422: l_Ret_Xmlelement Xmltype;
423: l_count NUMBER;

Line 420: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

416: RETURN Xmltype
417: IS
418: l_procedure_name VARCHAR2(40):='Get_Gt_Trxs';
419: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
420: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
421:
422: l_Ret_Xmlelement Xmltype;
423: l_count NUMBER;
424: BEGIN

Line 428: FND_LOG.string( l_proc_level

424: BEGIN
425: --logging for debug
426: IF (l_proc_level>=l_dbg_level)
427: THEN
428: FND_LOG.string( l_proc_level
429: , G_MODULE_PREFIX||l_procedure_name||'.begin'
430: , 'enter function'
431: );
432: END IF;

Line 482: FND_LOG.string( l_proc_level

478:
479: --logging for debug
480: IF (l_proc_level>=l_dbg_level)
481: THEN
482: FND_LOG.string( l_proc_level
483: , G_MODULE_PREFIX||l_procedure_name||'.end'
484: , 'end function'
485: );
486: END IF;

Line 569: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

565: l_Ar_Inv_Date_From DATE;
566: l_Ar_Inv_Date_To DATE;
567: l_gt_cur VARCHAR2(100);
568:
569: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
570: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
571:
572: CURSOR C_cur IS
573: SELECT

Line 570: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

566: l_Ar_Inv_Date_To DATE;
567: l_gt_cur VARCHAR2(100);
568:
569: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
570: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
571:
572: CURSOR C_cur IS
573: SELECT
574: sysp.gt_currency_code

Line 608: FND_LOG.string( l_proc_level

604: BEGIN
605: --logging for debug
606: IF (l_proc_level>=l_dbg_level)
607: THEN
608: FND_LOG.string( l_proc_level
609: , G_MODULE_PREFIX||l_procedure_name||'.begin'
610: , 'enter procedure'
611: );
612: END IF;

Line 792: FND_LOG.string( l_proc_level

788:
789: --logging for debug
790: IF (l_proc_level>=l_dbg_level)
791: THEN
792: FND_LOG.string( l_proc_level
793: , G_MODULE_PREFIX||l_procedure_name||'.end'
794: , 'end procedure'
795: );
796: END IF;

Line 800: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)

796: END IF;
797:
798: EXCEPTION
799: WHEN OTHERS THEN
800: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
801: THEN
802: Fnd_Log.String( Fnd_Log.Level_Unexpected
803: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
804: , Sqlcode||Sqlerrm);

Line 802: Fnd_Log.String( Fnd_Log.Level_Unexpected

798: EXCEPTION
799: WHEN OTHERS THEN
800: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
801: THEN
802: Fnd_Log.String( Fnd_Log.Level_Unexpected
803: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
804: , Sqlcode||Sqlerrm);
805: END IF;
806:

Line 837: -- 03/04/05 Donghai Wang Add FND Log

833: -- 11/25/05 Donghai Wang modify code to follow ebtax
834: -- requirement
835: -- 30/12/05 Donghai Wang Update cursor c_ar_header to
836: -- modify table names
837: -- 03/04/05 Donghai Wang Add FND Log
838: -- 07/05/07 Allen Yang Modify code to fix bug 6147067
839: -- 01/02/08 Subba Updated code for R12.1
840: -- 05-Aug-2009 Yao Zhang Fix bug#8765631 Modified.
841: -- 11-Jan-2011 Qiong Liu Fix bug#10638369

Line 1061: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1057: AND gta.status<>'CANCELLED'
1058: AND gta.latest_version_flag='Y';
1059:
1060:
1061: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1062: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1063:
1064: BEGIN
1065:

Line 1062: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1058: AND gta.latest_version_flag='Y';
1059:
1060:
1061: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1062: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1063:
1064: BEGIN
1065:
1066: --log for debug

Line 1070: FND_LOG.String(l_proc_level

1066: --log for debug
1067: IF( l_proc_level >= l_dbg_level)
1068: THEN
1069:
1070: FND_LOG.String(l_proc_level
1071: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
1072: ,'Enter procedure'
1073: );
1074:

Line 1076: FND_LOG.String(l_proc_level

1072: ,'Enter procedure'
1073: );
1074:
1075:
1076: FND_LOG.String(l_proc_level
1077: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
1078: ,'l_ar_header_id '||l_ar_header_id
1079: );
1080:

Line 1081: FND_LOG.String(l_proc_level

1077: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
1078: ,'l_ar_header_id '||l_ar_header_id
1079: );
1080:
1081: FND_LOG.String(l_proc_level
1082: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
1083: ,'l_org_id '||l_org_id
1084: );
1085:

Line 1096: FND_LOG.String(l_proc_level

1092:
1093: --log for debug
1094: IF( l_proc_level >= l_dbg_level)
1095: THEN
1096: FND_LOG.String(l_proc_level
1097: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1098: ,'l_ar_mask_bank '||l_ar_mask_bank
1099: );
1100: END IF; --( l_proc_level >= l_dbg_level)

Line 1195: FND_LOG.String(l_proc_level

1191:
1192: --log for debug
1193: IF( l_proc_level >= l_dbg_level)
1194: THEN
1195: FND_LOG.String(l_proc_level
1196: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1197: ,'l_ar_customer_id '||l_ar_customer_id
1198: );
1199:

Line 1200: FND_LOG.String(l_proc_level

1196: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1197: ,'l_ar_customer_id '||l_ar_customer_id
1198: );
1199:
1200: FND_LOG.String(l_proc_level
1201: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1202: ,'l_ar_customer_name '||l_ar_customer_name
1203: );
1204:

Line 1205: FND_LOG.String(l_proc_level

1201: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1202: ,'l_ar_customer_name '||l_ar_customer_name
1203: );
1204:
1205: FND_LOG.String(l_proc_level
1206: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1207: ,'l_ar_customer_address '||l_ar_customer_address
1208: );
1209:

Line 1243: FND_LOG.String(l_proc_level

1239:
1240: --log for debug
1241: IF( l_proc_level >= l_dbg_level)
1242: THEN
1243: FND_LOG.String(l_proc_level
1244: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1245: ,'l_ar_amount '||l_ar_amount
1246: );
1247:

Line 1248: FND_LOG.String(l_proc_level

1244: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1245: ,'l_ar_amount '||l_ar_amount
1246: );
1247:
1248: FND_LOG.String(l_proc_level
1249: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1250: ,'l_ar_taxamount '||l_ar_taxamount
1251: );
1252:

Line 1290: FND_LOG.String(l_proc_level

1286:
1287: --log for debug
1288: IF( l_proc_level >= l_dbg_level)
1289: THEN
1290: FND_LOG.String(l_proc_level
1291: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1292: ,'l_ar_customer_bank_account '||l_ar_customer_bank_account
1293: );
1294:

Line 1295: FND_LOG.String(l_proc_level

1291: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1292: ,'l_ar_customer_bank_account '||l_ar_customer_bank_account
1293: );
1294:
1295: FND_LOG.String(l_proc_level
1296: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1297: ,'l_ar_customer_address_phone '||l_ar_customer_address_phone
1298: );
1299:

Line 1325: FND_LOG.String(l_proc_level

1321:
1322: --Log for debug
1323: IF( l_proc_level >= l_dbg_level)
1324: THEN
1325: FND_LOG.String(l_proc_level
1326: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1327: ,'l_gta_amount_loop_count '||l_gta_amount_loop_count||','
1328: ||'l_gta_amount_sum '||l_gta_amount_sum||','
1329: ||'l_gta_taxamount_sum '||l_gta_taxamount_sum||','

Line 1396: FND_LOG.String(l_proc_level

1392:
1393: --log for debug
1394: IF( l_proc_level >= l_dbg_level)
1395: THEN
1396: FND_LOG.String(l_proc_level
1397: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1398: ,'l_gta_loop_count '||l_gta_loop_count
1399: );
1400:

Line 1402: FND_LOG.String(l_proc_level

1398: ,'l_gta_loop_count '||l_gta_loop_count
1399: );
1400:
1401: /*Commented by Allen to fix issue #2 in bug 6147067
1402: FND_LOG.String(l_proc_level
1403: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1404: ,'l_gta_amount '||l_gta_amount
1405: );
1406:

Line 1407: FND_LOG.String(l_proc_level

1403: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1404: ,'l_gta_amount '||l_gta_amount
1405: );
1406:
1407: FND_LOG.String(l_proc_level
1408: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1409: ,'l_gta_taxamount '||l_gta_taxamount
1410: );
1411: */

Line 1413: FND_LOG.String(l_proc_level

1409: ,'l_gta_taxamount '||l_gta_taxamount
1410: );
1411: */
1412:
1413: FND_LOG.String(l_proc_level
1414: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1415: ,'l_gta_customer_name '||l_gta_customer_name
1416: );
1417:

Line 1418: FND_LOG.String(l_proc_level

1414: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1415: ,'l_gta_customer_name '||l_gta_customer_name
1416: );
1417:
1418: FND_LOG.String(l_proc_level
1419: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1420: ,'l_gta_taxpayer_id '||l_gta_taxpayer_id
1421: );
1422:

Line 1423: FND_LOG.String(l_proc_level

1419: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1420: ,'l_gta_taxpayer_id '||l_gta_taxpayer_id
1421: );
1422:
1423: FND_LOG.String(l_proc_level
1424: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1425: ,'l_gta_customer_bank_account '||
1426: l_gta_customer_bank_account
1427: );

Line 1429: FND_LOG.String(l_proc_level

1425: ,'l_gta_customer_bank_account '||
1426: l_gta_customer_bank_account
1427: );
1428:
1429: FND_LOG.String(l_proc_level
1430: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1431: ,'l_gta_customer_address_phone '||
1432: l_gta_customer_address_phone
1433: );

Line 1435: FND_LOG.String(l_proc_level

1431: ,'l_gta_customer_address_phone '||
1432: l_gta_customer_address_phone
1433: );
1434:
1435: FND_LOG.String(l_proc_level
1436: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1437: ,'l_gta_trx_number '||l_gta_trx_number
1438: );
1439: --added by subba for R12.1

Line 1441: FND_LOG.String(l_proc_level

1437: ,'l_gta_trx_number '||l_gta_trx_number
1438: );
1439: --added by subba for R12.1
1440:
1441: FND_LOG.String(l_proc_level
1442: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1443: ,'l_gta_invoice_type '||l_gta_invoice_type
1444: );
1445:

Line 1478: FND_LOG.String(l_proc_level

1474:
1475: IF( l_proc_level >= l_dbg_level)
1476: THEN
1477:
1478: FND_LOG.String(l_proc_level
1479: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1480: ,'l_gt_amount '||l_gt_amount
1481: );
1482:

Line 1483: FND_LOG.String(l_proc_level

1479: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1480: ,'l_gt_amount '||l_gt_amount
1481: );
1482:
1483: FND_LOG.String(l_proc_level
1484: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1485: ,'l_gt_taxamount '||l_gt_taxamount
1486: );
1487:

Line 1488: FND_LOG.String(l_proc_level

1484: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1485: ,'l_gt_taxamount '||l_gt_taxamount
1486: );
1487:
1488: FND_LOG.String(l_proc_level
1489: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1490: ,'l_gt_customer_name '||l_gt_customer_name
1491: );
1492:

Line 1493: FND_LOG.String(l_proc_level

1489: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1490: ,'l_gt_customer_name '||l_gt_customer_name
1491: );
1492:
1493: FND_LOG.String(l_proc_level
1494: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1495: ,'l_gt_taxpayer_id '||l_gt_taxpayer_id
1496: );
1497:

Line 1498: FND_LOG.String(l_proc_level

1494: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1495: ,'l_gt_taxpayer_id '||l_gt_taxpayer_id
1496: );
1497:
1498: FND_LOG.String(l_proc_level
1499: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1500: ,'l_gt_customer_bank_account '||
1501: l_gt_customer_bank_account
1502: );

Line 1504: FND_LOG.String(l_proc_level

1500: ,'l_gt_customer_bank_account '||
1501: l_gt_customer_bank_account
1502: );
1503:
1504: FND_LOG.String(l_proc_level
1505: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1506: ,'l_gt_customer_address_phone '||
1507: l_gt_customer_address_phone
1508: );

Line 1510: FND_LOG.String(l_proc_level

1506: ,'l_gt_customer_address_phone '||
1507: l_gt_customer_address_phone
1508: );
1509:
1510: FND_LOG.String(l_proc_level
1511: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1512: ,'l_gt_invoice_number '||l_gt_invoice_number
1513: );
1514:

Line 1515: FND_LOG.String(l_proc_level

1511: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1512: ,'l_gt_invoice_number '||l_gt_invoice_number
1513: );
1514:
1515: FND_LOG.String(l_proc_level
1516: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1517: ,'l_gt_invoice_type '||l_gt_invoice_type
1518: );
1519:

Line 2042: FND_LOG.String(l_proc_level

2038:
2039: --log for debug
2040: IF( l_proc_level >= l_dbg_level)
2041: THEN
2042: FND_LOG.String(l_proc_level
2043: ,G_MODULE_PREFIX||'.'||l_api_name||'.end'
2044: ,'Exit procedure');
2045:
2046:

Line 2054: FND_LOG.String( l_proc_level

2050: WHEN OTHERS THEN
2051: IF(l_proc_level >= l_dbg_level)
2052: THEN
2053: l_error_msg:=SQLCODE||':'||SQLERRM;
2054: FND_LOG.String( l_proc_level
2055: , g_module_prefix || l_api_name || '. Other_Exception '
2056: , l_error_msg
2057: );
2058:

Line 2060: END IF; --(FND_LOG.Level_Unexpected >= FND_LOG.G_Current_Runtime_Level)

2056: , l_error_msg
2057: );
2058:
2059:
2060: END IF; --(FND_LOG.Level_Unexpected >= FND_LOG.G_Current_Runtime_Level)
2061:
2062: IF c_gta_headers%ISOPEN
2063: THEN
2064: CLOSE c_gta_headers;

Line 2095: -- 03/04/05 Donghai Wang Add FND Log

2091: --
2092: -- 05/17/05 Donghai Wang Created.
2093: -- 11/25/05 Donghai Wang modify code to follow ebtax
2094: -- requirement
2095: -- 03/04/05 Donghai Wang Add FND Log
2096: -- 06/28/06 Donghai Wang Fix the bug 5263009
2097: -- 07/21/06 Donghai Wang Fix the bug 5381833
2098: -- 06/18/07 Donghai Wang Fix the bug 6132187
2099: -- 13-MAY-2009 Yao Zhang Changed for bug 5604079

Line 2342: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

2338: FROM oe_price_adjustments opa
2339: WHERE opa.line_id = l_line_id
2340: AND opa.list_line_type_code = 'DIS';
2341:
2342: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2343: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2344: l_ar_loop_count NUMBER;
2345: l_gta_loop_count NUMBER;
2346: l_conversion_rate ra_customer_trx_all.exchange_rate%type;--Yao Zhang add for bug#5604079

Line 2343: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

2339: WHERE opa.line_id = l_line_id
2340: AND opa.list_line_type_code = 'DIS';
2341:
2342: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2343: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2344: l_ar_loop_count NUMBER;
2345: l_gta_loop_count NUMBER;
2346: l_conversion_rate ra_customer_trx_all.exchange_rate%type;--Yao Zhang add for bug#5604079
2347:

Line 2354: FND_LOG.String(l_proc_level

2350:
2351: --log for debug
2352: IF( l_proc_level >= l_dbg_level)
2353: THEN
2354: FND_LOG.String(l_proc_level
2355: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
2356: ,'Enter procedure'
2357: );
2358:

Line 2359: FND_LOG.String(l_proc_level

2355: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
2356: ,'Enter procedure'
2357: );
2358:
2359: FND_LOG.String(l_proc_level
2360: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
2361: ,'l_ar_header_id '||l_ar_header_id
2362: );
2363:

Line 2364: FND_LOG.String(l_proc_level

2360: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
2361: ,'l_ar_header_id '||l_ar_header_id
2362: );
2363:
2364: FND_LOG.String(l_proc_level
2365: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
2366: ,'l_org_id '||l_org_id
2367: );
2368:

Line 2584: FND_LOG.String(l_proc_level

2580: --log for debug
2581: IF( l_proc_level >= l_dbg_level)
2582: THEN
2583:
2584: FND_LOG.String(l_proc_level
2585: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2586: ,'l_ar_loop_count '||l_ar_loop_count
2587: );
2588:

Line 2589: FND_LOG.String(l_proc_level

2585: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2586: ,'l_ar_loop_count '||l_ar_loop_count
2587: );
2588:
2589: FND_LOG.String(l_proc_level
2590: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2591: ,'l_ar_line_id '||l_ar_line_id
2592: );
2593:

Line 2594: FND_LOG.String(l_proc_level

2590: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2591: ,'l_ar_line_id '||l_ar_line_id
2592: );
2593:
2594: FND_LOG.String(l_proc_level
2595: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2596: ,'l_ar_line_number '||l_ar_line_number
2597: );
2598:

Line 2599: FND_LOG.String(l_proc_level

2595: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2596: ,'l_ar_line_number '||l_ar_line_number
2597: );
2598:
2599: FND_LOG.String(l_proc_level
2600: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2601: ,'l_ar_goods_description '||l_ar_goods_description
2602: );
2603:

Line 2604: FND_LOG.String(l_proc_level

2600: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2601: ,'l_ar_goods_description '||l_ar_goods_description
2602: );
2603:
2604: FND_LOG.String(l_proc_level
2605: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2606: ,'l_ar_quantity '||l_ar_quantity
2607: );
2608:

Line 2609: FND_LOG.String(l_proc_level

2605: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2606: ,'l_ar_quantity '||l_ar_quantity
2607: );
2608:
2609: FND_LOG.String(l_proc_level
2610: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2611: ,'l_ar_unit_price '||l_ar_unit_price
2612: );
2613:

Line 2614: FND_LOG.String(l_proc_level

2610: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2611: ,'l_ar_unit_price '||l_ar_unit_price
2612: );
2613:
2614: FND_LOG.String(l_proc_level
2615: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2616: ,'l_ar_uom '||l_ar_uom
2617: );
2618:

Line 2664: FND_LOG.String(l_proc_level

2660: --log for debug
2661: IF( l_proc_level >= l_dbg_level)
2662: THEN
2663:
2664: FND_LOG.String(l_proc_level
2665: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2666: ,'l_ar_tax_reg_number '||l_ar_tax_reg_number
2667: );
2668:

Line 2669: FND_LOG.String(l_proc_level

2665: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2666: ,'l_ar_tax_reg_number '||l_ar_tax_reg_number
2667: );
2668:
2669: FND_LOG.String(l_proc_level
2670: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2671: ,'l_ar_line_amount '||l_ar_line_amount
2672: );
2673:

Line 2674: FND_LOG.String(l_proc_level

2670: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2671: ,'l_ar_line_amount '||l_ar_line_amount
2672: );
2673:
2674: FND_LOG.String(l_proc_level
2675: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2676: ,'l_ar_vat_line_tax '||l_ar_vat_line_tax
2677: );
2678:

Line 2679: FND_LOG.String(l_proc_level

2675: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2676: ,'l_ar_vat_line_tax '||l_ar_vat_line_tax
2677: );
2678:
2679: FND_LOG.String(l_proc_level
2680: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2681: ,'l_ar_vat_tax_rate '||l_ar_vat_tax_rate
2682: );
2683:

Line 2712: FND_LOG.String(l_proc_level

2708: --log for debug
2709: IF( l_proc_level >= l_dbg_level)
2710: THEN
2711:
2712: FND_LOG.String(l_proc_level
2713: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2714: ,'l_gta_loop_count '||l_gta_loop_count
2715: );
2716:

Line 2717: FND_LOG.String(l_proc_level

2713: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2714: ,'l_gta_loop_count '||l_gta_loop_count
2715: );
2716:
2717: FND_LOG.String(l_proc_level
2718: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2719: ,'l_gta_trx_number '||l_gta_trx_number
2720: );
2721:

Line 2722: FND_LOG.String(l_proc_level

2718: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2719: ,'l_gta_trx_number '||l_gta_trx_number
2720: );
2721:
2722: FND_LOG.String(l_proc_level
2723: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2724: ,'l_gta_tax_reg_number '||l_gta_tax_reg_number
2725: );
2726:

Line 2727: FND_LOG.String(l_proc_level

2723: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2724: ,'l_gta_tax_reg_number '||l_gta_tax_reg_number
2725: );
2726:
2727: FND_LOG.String(l_proc_level
2728: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2729: ,'l_gta_line_number '||l_gta_line_number
2730: );
2731:

Line 2732: FND_LOG.String(l_proc_level

2728: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2729: ,'l_gta_line_number '||l_gta_line_number
2730: );
2731:
2732: FND_LOG.String(l_proc_level
2733: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2734: ,'l_gta_vat_line_tax '||l_gta_vat_line_tax
2735: );
2736:

Line 2737: FND_LOG.String(l_proc_level

2733: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2734: ,'l_gta_vat_line_tax '||l_gta_vat_line_tax
2735: );
2736:
2737: FND_LOG.String(l_proc_level
2738: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2739: ,'l_gta_vat_tax_rate '||l_gta_vat_tax_rate
2740: );
2741:

Line 2742: FND_LOG.String(l_proc_level

2738: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2739: ,'l_gta_vat_tax_rate '||l_gta_vat_tax_rate
2740: );
2741:
2742: FND_LOG.String(l_proc_level
2743: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2744: ,'l_gta_quantity '||l_gta_quantity
2745: );
2746:

Line 2747: FND_LOG.String(l_proc_level

2743: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2744: ,'l_gta_quantity '||l_gta_quantity
2745: );
2746:
2747: FND_LOG.String(l_proc_level
2748: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2749: ,'l_gta_unit_price '||l_gta_unit_price
2750: );
2751:

Line 2752: FND_LOG.String(l_proc_level

2748: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2749: ,'l_gta_unit_price '||l_gta_unit_price
2750: );
2751:
2752: FND_LOG.String(l_proc_level
2753: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2754: ,'l_gta_uom '||l_gta_uom
2755: );
2756:

Line 2757: FND_LOG.String(l_proc_level

2753: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2754: ,'l_gta_uom '||l_gta_uom
2755: );
2756:
2757: FND_LOG.String(l_proc_level
2758: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2759: ,'l_matched_flag '||l_matched_flag
2760: );
2761:

Line 2783: FND_LOG.String(l_proc_level

2779: --log for debug
2780: IF( l_proc_level >= l_dbg_level)
2781: THEN
2782:
2783: FND_LOG.String(l_proc_level
2784: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2785: ,'l_gta_line_amount_sum '||l_gta_line_amount_sum
2786: );
2787:

Line 2788: FND_LOG.String(l_proc_level

2784: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2785: ,'l_gta_line_amount_sum '||l_gta_line_amount_sum
2786: );
2787:
2788: FND_LOG.String(l_proc_level
2789: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2790: ,'l_gta_line_taxamount_sum '||l_gta_line_taxamount_sum
2791: );
2792:

Line 2793: FND_LOG.String(l_proc_level

2789: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2790: ,'l_gta_line_taxamount_sum '||l_gta_line_taxamount_sum
2791: );
2792:
2793: FND_LOG.String(l_proc_level
2794: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2795: ,'l_gta_line_quantity_sum '||l_gta_line_quantity_sum
2796: );
2797:

Line 2809: FND_LOG.String(l_proc_level

2805: --log for debug
2806: IF( l_proc_level >= l_dbg_level)
2807: THEN
2808:
2809: FND_LOG.String(l_proc_level
2810: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2811: ,'l_gt_invoice_number '||l_gt_invoice_number
2812: );
2813: END IF; --( l_proc_level >= l_dbg_level)

Line 2828: FND_LOG.String(l_proc_level

2824: --log for debug
2825: IF( l_proc_level >= l_dbg_level)
2826: THEN
2827:
2828: FND_LOG.String(l_proc_level
2829: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2830: ,'l_gta_trx_number_con '||l_gta_trx_number_con
2831: );
2832: END IF; --( l_proc_level >= l_dbg_level)

Line 2847: FND_LOG.String(l_proc_level

2843: --log for debug
2844: IF( l_proc_level >= l_dbg_level)
2845: THEN
2846:
2847: FND_LOG.String(l_proc_level
2848: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2849: ,'l_gt_invoice_number_con '||l_gt_invoice_number_con
2850: );
2851: END IF; --( l_proc_level >= l_dbg_level)

Line 2866: FND_LOG.String(l_proc_level

2862: --log for debug
2863: IF( l_proc_level >= l_dbg_level)
2864: THEN
2865:
2866: FND_LOG.String(l_proc_level
2867: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2868: ,'l_gta_line_number_con '||l_gta_line_number_con
2869: );
2870: END IF; --( l_proc_level >= l_dbg_level)

Line 3381: FND_LOG.String(l_proc_level

3377: --log for debug
3378: IF( l_proc_level >= l_dbg_level)
3379: THEN
3380:
3381: FND_LOG.String(l_proc_level
3382: ,G_MODULE_PREFIX||'.'||l_api_name||'.phase'
3383: ,'c_missing_ar_line'
3384: );
3385: END IF; --( l_proc_level >= l_dbg_level)

Line 3426: FND_LOG.String(l_proc_level

3422: --log for debug
3423: IF( l_proc_level >= l_dbg_level)
3424: THEN
3425:
3426: FND_LOG.String(l_proc_level
3427: ,G_MODULE_PREFIX||'.'||l_api_name||'.phase'
3428: ,'c_not_transferred_ar_lines'
3429: );
3430: END IF; --( l_proc_level >= l_dbg_level)

Line 3460: FND_LOG.String(l_proc_level

3456:
3457: --log for debug
3458: IF( l_proc_level >= l_dbg_level)
3459: THEN
3460: FND_LOG.String(l_proc_level
3461: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3462: ,'x_validated_lines '||l_validated_lines
3463: );
3464:

Line 3465: FND_LOG.String(l_proc_level

3461: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3462: ,'x_validated_lines '||l_validated_lines
3463: );
3464:
3465: FND_LOG.String(l_proc_level
3466: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3467: ,'x_ar_matching_lines '||l_ar_matching_lines
3468: );
3469:

Line 3470: FND_LOG.String(l_proc_level

3466: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3467: ,'x_ar_matching_lines '||l_ar_matching_lines
3468: );
3469:
3470: FND_LOG.String(l_proc_level
3471: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3472: ,'x_ar_partially_import '||l_ar_partially_import
3473: );
3474:

Line 3475: FND_LOG.String(l_proc_level

3471: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3472: ,'x_ar_partially_import '||l_ar_partially_import
3473: );
3474:
3475: FND_LOG.String(l_proc_level
3476: ,G_MODULE_PREFIX||'.'||l_api_name||'.end'
3477: ,'Exit procedure'
3478: );
3479:

Line 3490: FND_LOG.String( l_proc_level

3486: WHEN OTHERS THEN
3487: IF(l_proc_level >= l_dbg_level)
3488: THEN
3489: l_error_msg:=SQLCODE||':'||SQLERRM;
3490: FND_LOG.String( l_proc_level
3491: , G_Module_Prefix || l_api_name || '. Other_Exception '
3492: , l_error_msg);
3493:
3494:

Line 3525: -- 03/04/05 Donghai Wang Add FND Log

3521: --
3522: -- 05/17/05 Donghai Wang Created.
3523: -- 11/25/05 Donghai Wang modify code to follow ebtax
3524: -- requirement
3525: -- 03/04/05 Donghai Wang Add FND Log
3526: -- 07/21/06 Donghai Wang Fix bug 5193632
3527: -- 10-Aug-2009 Yao Zhang Modified for bug# 8765631
3528: --==========================================================================
3529: PROCEDURE Get_Unmatched_Lines

Line 3601: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3597: --Yao Zhang add for bug#8765631
3598: AND gt_line.discount_flag='0';
3599:
3600: l_gt_unmatched_line c_gt_unmatched_line%ROWTYPE;
3601: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3602: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3603:
3604: BEGIN
3605:

Line 3602: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3598: AND gt_line.discount_flag='0';
3599:
3600: l_gt_unmatched_line c_gt_unmatched_line%ROWTYPE;
3601: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3602: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3603:
3604: BEGIN
3605:
3606: --log for debug

Line 3609: FND_LOG.String(l_proc_level

3605:
3606: --log for debug
3607: IF (l_proc_level >= l_dbg_level)
3608: THEN
3609: FND_LOG.String(l_proc_level
3610: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
3611: ,'Enter procedure'
3612: );
3613: END IF; --(l_proc_level >= l_dbg_level)

Line 3618: FND_LOG.String(l_proc_level

3614:
3615: --log for debug
3616: IF (l_proc_level >= l_dbg_level)
3617: THEN
3618: FND_LOG.String(l_proc_level
3619: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3620: ,'p_org_id '||p_org_id
3621: );
3622:

Line 3623: FND_LOG.String(l_proc_level

3619: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3620: ,'p_org_id '||p_org_id
3621: );
3622:
3623: FND_LOG.String(l_proc_level
3624: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3625: ,'p_ar_header_id '||p_ar_header_id
3626: );
3627: END IF; --(l_proc_level >= l_dbg_level)

Line 3729: FND_LOG.STRING(l_proc_level

3725:
3726: --log for debug
3727: IF ( l_proc_level >= l_dbg_level)
3728: THEN
3729: FND_LOG.STRING(l_proc_level
3730: ,G_MODULE_PREFIX||'.'||l_api_name||'.end'
3731: ,'Exit procedure'
3732: );
3733: END IF; --( l_proc_level >= l_dbg_level )

Line 3739: FND_LOG.String( l_proc_level

3735: EXCEPTION
3736: WHEN OTHERS THEN
3737: IF (l_proc_level >= l_dbg_level)
3738: THEN
3739: FND_LOG.String( l_proc_level
3740: , G_Module_Prefix || l_api_name || '. Other_Exception '
3741: , SQLCODE||':'||SQLERRM);
3742: END IF; --(l_proc_level >= l_dbg_level)
3743: RAISE;

Line 3799: -- 03/04/05 Donghai Wang Add FND Log

3795: --
3796: -- 05/17/05 Donghai Wang Created.
3797: -- 11/25/05 Donghai Wang modify code to follow ebtax
3798: -- requirement
3799: -- 03/04/05 Donghai Wang Add FND Log
3800: -- 06/28/06 Donghai Wang Fix the bug 5263009
3801: -- 07/21/06 Donghai Wang Fix the bug 5381833
3802: -- 09/14/06 Donghai Wang format output date to XSD date
3803: -- format to fix the bug 5521629

Line 4079: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

4075: WHERE
4076: org_id=p_org_id;
4077:
4078:
4079: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4080: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4081:
4082:
4083: BEGIN

Line 4080: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

4076: org_id=p_org_id;
4077:
4078:
4079: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4080: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4081:
4082:
4083: BEGIN
4084:

Line 4088: FND_LOG.STRING(l_proc_level

4084:
4085: --log for debug
4086: IF( l_proc_level >= l_dbg_level)
4087: THEN
4088: FND_LOG.STRING(l_proc_level
4089: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
4090: ,'Enter procedure');
4091: END IF; --( l_proc_level >= l_dbg_level)
4092:

Line 4097: FND_LOG.STRING(l_proc_level

4093:
4094: --log for debug
4095: IF( l_proc_level >= l_dbg_level)
4096: THEN
4097: FND_LOG.STRING(l_proc_level
4098: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4099: ,'p_org_id '||p_org_id);
4100:
4101: FND_LOG.STRING(l_proc_level

Line 4101: FND_LOG.STRING(l_proc_level

4097: FND_LOG.STRING(l_proc_level
4098: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4099: ,'p_org_id '||p_org_id);
4100:
4101: FND_LOG.STRING(l_proc_level
4102: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4103: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
4104:
4105: FND_LOG.STRING(l_proc_level

Line 4105: FND_LOG.STRING(l_proc_level

4101: FND_LOG.STRING(l_proc_level
4102: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4103: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
4104:
4105: FND_LOG.STRING(l_proc_level
4106: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4107: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
4108:
4109: FND_LOG.STRING(l_proc_level

Line 4109: FND_LOG.STRING(l_proc_level

4105: FND_LOG.STRING(l_proc_level
4106: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4107: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
4108:
4109: FND_LOG.STRING(l_proc_level
4110: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4111: ,'p_ar_transaction_type '||p_ar_transaction_type);
4112:
4113: FND_LOG.STRING(l_proc_level

Line 4113: FND_LOG.STRING(l_proc_level

4109: FND_LOG.STRING(l_proc_level
4110: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4111: ,'p_ar_transaction_type '||p_ar_transaction_type);
4112:
4113: FND_LOG.STRING(l_proc_level
4114: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4115: ,'p_cust_num_from '||p_cust_num_from);
4116:
4117: FND_LOG.STRING(l_proc_level

Line 4117: FND_LOG.STRING(l_proc_level

4113: FND_LOG.STRING(l_proc_level
4114: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4115: ,'p_cust_num_from '||p_cust_num_from);
4116:
4117: FND_LOG.STRING(l_proc_level
4118: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4119: ,'p_cust_num_to '||p_cust_num_to);
4120:
4121: FND_LOG.STRING(l_proc_level

Line 4121: FND_LOG.STRING(l_proc_level

4117: FND_LOG.STRING(l_proc_level
4118: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4119: ,'p_cust_num_to '||p_cust_num_to);
4120:
4121: FND_LOG.STRING(l_proc_level
4122: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4123: ,'p_cust_name_id '||p_cust_name_id);
4124:
4125: FND_LOG.STRING(l_proc_level

Line 4125: FND_LOG.STRING(l_proc_level

4121: FND_LOG.STRING(l_proc_level
4122: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4123: ,'p_cust_name_id '||p_cust_name_id);
4124:
4125: FND_LOG.STRING(l_proc_level
4126: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4127: ,'p_gl_period '||p_gl_period);
4128:
4129: FND_LOG.STRING(l_proc_level

Line 4129: FND_LOG.STRING(l_proc_level

4125: FND_LOG.STRING(l_proc_level
4126: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4127: ,'p_gl_period '||p_gl_period);
4128:
4129: FND_LOG.STRING(l_proc_level
4130: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4131: ,'p_gl_date_from '||p_gl_date_from);
4132:
4133: FND_LOG.STRING(l_proc_level

Line 4133: FND_LOG.STRING(l_proc_level

4129: FND_LOG.STRING(l_proc_level
4130: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4131: ,'p_gl_date_from '||p_gl_date_from);
4132:
4133: FND_LOG.STRING(l_proc_level
4134: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4135: ,'p_gl_date_to '||p_gl_date_to);
4136:
4137: FND_LOG.STRING(l_proc_level

Line 4137: FND_LOG.STRING(l_proc_level

4133: FND_LOG.STRING(l_proc_level
4134: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4135: ,'p_gl_date_to '||p_gl_date_to);
4136:
4137: FND_LOG.STRING(l_proc_level
4138: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4139: ,'p_ar_trx_batch_from '||p_ar_trx_batch_from);
4140:
4141: FND_LOG.STRING(l_proc_level

Line 4141: FND_LOG.STRING(l_proc_level

4137: FND_LOG.STRING(l_proc_level
4138: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4139: ,'p_ar_trx_batch_from '||p_ar_trx_batch_from);
4140:
4141: FND_LOG.STRING(l_proc_level
4142: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4143: ,'p_ar_trx_batch_to '||p_ar_trx_batch_to);
4144:
4145: FND_LOG.STRING(l_proc_level

Line 4145: FND_LOG.STRING(l_proc_level

4141: FND_LOG.STRING(l_proc_level
4142: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4143: ,'p_ar_trx_batch_to '||p_ar_trx_batch_to);
4144:
4145: FND_LOG.STRING(l_proc_level
4146: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4147: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
4148:
4149: FND_LOG.STRING(l_proc_level

Line 4149: FND_LOG.STRING(l_proc_level

4145: FND_LOG.STRING(l_proc_level
4146: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4147: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
4148:
4149: FND_LOG.STRING(l_proc_level
4150: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4151: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
4152:
4153: FND_LOG.STRING(l_proc_level

Line 4153: FND_LOG.STRING(l_proc_level

4149: FND_LOG.STRING(l_proc_level
4150: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4151: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
4152:
4153: FND_LOG.STRING(l_proc_level
4154: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4155: ,'p_ar_trx_date_from '||p_ar_trx_date_from);
4156:
4157: FND_LOG.STRING(l_proc_level

Line 4157: FND_LOG.STRING(l_proc_level

4153: FND_LOG.STRING(l_proc_level
4154: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4155: ,'p_ar_trx_date_from '||p_ar_trx_date_from);
4156:
4157: FND_LOG.STRING(l_proc_level
4158: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4159: ,'p_ar_trx_date_to '||p_ar_trx_date_to);
4160:
4161: FND_LOG.STRING(l_proc_level

Line 4161: FND_LOG.STRING(l_proc_level

4157: FND_LOG.STRING(l_proc_level
4158: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4159: ,'p_ar_trx_date_to '||p_ar_trx_date_to);
4160:
4161: FND_LOG.STRING(l_proc_level
4162: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4163: ,'p_ar_doc_num_from '||p_ar_doc_num_from);
4164:
4165: FND_LOG.STRING(l_proc_level

Line 4165: FND_LOG.STRING(l_proc_level

4161: FND_LOG.STRING(l_proc_level
4162: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4163: ,'p_ar_doc_num_from '||p_ar_doc_num_from);
4164:
4165: FND_LOG.STRING(l_proc_level
4166: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4167: ,'p_ar_doc_num_to '||p_ar_doc_num_to);
4168:
4169: FND_LOG.STRING(l_proc_level

Line 4169: FND_LOG.STRING(l_proc_level

4165: FND_LOG.STRING(l_proc_level
4166: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4167: ,'p_ar_doc_num_to '||p_ar_doc_num_to);
4168:
4169: FND_LOG.STRING(l_proc_level
4170: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4171: ,'p_original_curr_code '||p_original_curr_code);
4172:
4173: FND_LOG.STRING(l_proc_level

Line 4173: FND_LOG.STRING(l_proc_level

4169: FND_LOG.STRING(l_proc_level
4170: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4171: ,'p_original_curr_code '||p_original_curr_code);
4172:
4173: FND_LOG.STRING(l_proc_level
4174: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4175: ,'p_primary_sales '||p_primary_sales);
4176:
4177: FND_LOG.STRING(l_proc_level

Line 4177: FND_LOG.STRING(l_proc_level

4173: FND_LOG.STRING(l_proc_level
4174: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4175: ,'p_primary_sales '||p_primary_sales);
4176:
4177: FND_LOG.STRING(l_proc_level
4178: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4179: ,'p_validated_lines_total '||p_validated_lines_total);
4180:
4181: FND_LOG.STRING(l_proc_level

Line 4181: FND_LOG.STRING(l_proc_level

4177: FND_LOG.STRING(l_proc_level
4178: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4179: ,'p_validated_lines_total '||p_validated_lines_total);
4180:
4181: FND_LOG.STRING(l_proc_level
4182: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4183: ,'p_ar_matching_lines_total '||p_ar_matching_lines_total);
4184:
4185: FND_LOG.STRING(l_proc_level

Line 4185: FND_LOG.STRING(l_proc_level

4181: FND_LOG.STRING(l_proc_level
4182: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4183: ,'p_ar_matching_lines_total '||p_ar_matching_lines_total);
4184:
4185: FND_LOG.STRING(l_proc_level
4186: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4187: ,'p_ar_partially_import_total '
4188: ||p_ar_partially_import_total
4189: );

Line 4545: FND_LOG.STRING(l_proc_level

4541:
4542: --log for debug
4543: IF( l_proc_level >= l_dbg_level )
4544: THEN
4545: FND_LOG.STRING(l_proc_level
4546: ,G_MODULE_PREFIX||'.'||l_api_name||'.end'
4547: ,'Exit procedure');
4548: END IF; --( l_proc_level >= l_dbg_level)
4549:

Line 4556: FND_LOG.String( l_proc_level

4552: WHEN OTHERS THEN
4553: IF (l_proc_level >= l_dbg_level)
4554: THEN
4555: l_error_msg:=SQLCODE||':'||SQLERRM;
4556: FND_LOG.String( l_proc_level
4557: , G_Module_Prefix || l_api_name || '. Other_Exception '
4558: , l_error_msg);
4559:
4560:

Line 4609: -- 03/04/05 Donghai Wang Add FND Log

4605: --
4606: -- CHANGE HISTORY:
4607: --
4608: -- 05/17/05 Donghai Wang Created.
4609: -- 03/04/05 Donghai Wang Add FND Log
4610: -- 05-Aug-2009 Yao Zhang Fix bug#8765631 Modified
4611: --==========================================================================
4612: PROCEDURE Generate_Discrepancy_Rep
4613: ( p_org_id IN NUMBER

Line 4841: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

4837: l_consolidated_inv_header_id NUMBER;
4838: l_consolidated_difference BOOLEAN;
4839: --Yao Zhang add end;
4840: l_missing_artrx_rec c_missing_artrx%ROWTYPE;
4841: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4842: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4843:
4844:
4845: BEGIN

Line 4842: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

4838: l_consolidated_difference BOOLEAN;
4839: --Yao Zhang add end;
4840: l_missing_artrx_rec c_missing_artrx%ROWTYPE;
4841: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4842: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4843:
4844:
4845: BEGIN
4846:

Line 4850: FND_LOG.string(l_proc_level

4846:
4847: --Logging for debug
4848: IF (l_proc_level>=l_dbg_level)
4849: THEN
4850: FND_LOG.string(l_proc_level
4851: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
4852: ,'Enter procedure'
4853: );
4854: END IF; --(l_proc_level>=l_proc_level)

Line 4859: FND_LOG.STRING(l_proc_level

4855:
4856: --log for debug
4857: IF( l_proc_level >= l_dbg_level)
4858: THEN
4859: FND_LOG.STRING(l_proc_level
4860: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4861: ,'p_org_id '||p_org_id);
4862:
4863: FND_LOG.STRING(l_proc_level

Line 4863: FND_LOG.STRING(l_proc_level

4859: FND_LOG.STRING(l_proc_level
4860: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4861: ,'p_org_id '||p_org_id);
4862:
4863: FND_LOG.STRING(l_proc_level
4864: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4865: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
4866:
4867: FND_LOG.STRING(l_proc_level

Line 4867: FND_LOG.STRING(l_proc_level

4863: FND_LOG.STRING(l_proc_level
4864: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4865: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
4866:
4867: FND_LOG.STRING(l_proc_level
4868: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4869: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
4870:
4871: FND_LOG.STRING(l_proc_level

Line 4871: FND_LOG.STRING(l_proc_level

4867: FND_LOG.STRING(l_proc_level
4868: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4869: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
4870:
4871: FND_LOG.STRING(l_proc_level
4872: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4873: ,'p_ar_transaction_type '||p_ar_transaction_type);
4874:
4875: FND_LOG.STRING(l_proc_level

Line 4875: FND_LOG.STRING(l_proc_level

4871: FND_LOG.STRING(l_proc_level
4872: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4873: ,'p_ar_transaction_type '||p_ar_transaction_type);
4874:
4875: FND_LOG.STRING(l_proc_level
4876: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4877: ,'p_cust_num_from '||p_cust_num_from);
4878:
4879: FND_LOG.STRING(l_proc_level

Line 4879: FND_LOG.STRING(l_proc_level

4875: FND_LOG.STRING(l_proc_level
4876: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4877: ,'p_cust_num_from '||p_cust_num_from);
4878:
4879: FND_LOG.STRING(l_proc_level
4880: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4881: ,'p_cust_num_to '||p_cust_num_to);
4882:
4883: FND_LOG.STRING(l_proc_level

Line 4883: FND_LOG.STRING(l_proc_level

4879: FND_LOG.STRING(l_proc_level
4880: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4881: ,'p_cust_num_to '||p_cust_num_to);
4882:
4883: FND_LOG.STRING(l_proc_level
4884: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4885: ,'p_cust_name_id '||p_cust_name_id);
4886:
4887: FND_LOG.STRING(l_proc_level

Line 4887: FND_LOG.STRING(l_proc_level

4883: FND_LOG.STRING(l_proc_level
4884: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4885: ,'p_cust_name_id '||p_cust_name_id);
4886:
4887: FND_LOG.STRING(l_proc_level
4888: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4889: ,'p_gl_period '||p_gl_period);
4890:
4891: FND_LOG.STRING(l_proc_level

Line 4891: FND_LOG.STRING(l_proc_level

4887: FND_LOG.STRING(l_proc_level
4888: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4889: ,'p_gl_period '||p_gl_period);
4890:
4891: FND_LOG.STRING(l_proc_level
4892: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4893: ,'p_gl_date_from '||p_gl_date_from);
4894:
4895: FND_LOG.STRING(l_proc_level

Line 4895: FND_LOG.STRING(l_proc_level

4891: FND_LOG.STRING(l_proc_level
4892: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4893: ,'p_gl_date_from '||p_gl_date_from);
4894:
4895: FND_LOG.STRING(l_proc_level
4896: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4897: ,'p_gl_date_to '||p_gl_date_to);
4898:
4899: FND_LOG.STRING(l_proc_level

Line 4899: FND_LOG.STRING(l_proc_level

4895: FND_LOG.STRING(l_proc_level
4896: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4897: ,'p_gl_date_to '||p_gl_date_to);
4898:
4899: FND_LOG.STRING(l_proc_level
4900: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4901: ,'p_ar_trx_batch_from '||p_ar_trx_batch_from);
4902:
4903: FND_LOG.STRING(l_proc_level

Line 4903: FND_LOG.STRING(l_proc_level

4899: FND_LOG.STRING(l_proc_level
4900: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4901: ,'p_ar_trx_batch_from '||p_ar_trx_batch_from);
4902:
4903: FND_LOG.STRING(l_proc_level
4904: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4905: ,'p_ar_trx_batch_to '||p_ar_trx_batch_to);
4906:
4907: FND_LOG.STRING(l_proc_level

Line 4907: FND_LOG.STRING(l_proc_level

4903: FND_LOG.STRING(l_proc_level
4904: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4905: ,'p_ar_trx_batch_to '||p_ar_trx_batch_to);
4906:
4907: FND_LOG.STRING(l_proc_level
4908: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4909: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
4910:
4911: FND_LOG.STRING(l_proc_level

Line 4911: FND_LOG.STRING(l_proc_level

4907: FND_LOG.STRING(l_proc_level
4908: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4909: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
4910:
4911: FND_LOG.STRING(l_proc_level
4912: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4913: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
4914:
4915: FND_LOG.STRING(l_proc_level

Line 4915: FND_LOG.STRING(l_proc_level

4911: FND_LOG.STRING(l_proc_level
4912: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4913: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
4914:
4915: FND_LOG.STRING(l_proc_level
4916: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4917: ,'p_ar_trx_date_from '||p_ar_trx_date_from);
4918:
4919: FND_LOG.STRING(l_proc_level

Line 4919: FND_LOG.STRING(l_proc_level

4915: FND_LOG.STRING(l_proc_level
4916: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4917: ,'p_ar_trx_date_from '||p_ar_trx_date_from);
4918:
4919: FND_LOG.STRING(l_proc_level
4920: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4921: ,'p_ar_trx_date_to '||p_ar_trx_date_to);
4922:
4923: FND_LOG.STRING(l_proc_level

Line 4923: FND_LOG.STRING(l_proc_level

4919: FND_LOG.STRING(l_proc_level
4920: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4921: ,'p_ar_trx_date_to '||p_ar_trx_date_to);
4922:
4923: FND_LOG.STRING(l_proc_level
4924: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4925: ,'p_ar_doc_num_from '||p_ar_doc_num_from);
4926:
4927: FND_LOG.STRING(l_proc_level

Line 4927: FND_LOG.STRING(l_proc_level

4923: FND_LOG.STRING(l_proc_level
4924: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4925: ,'p_ar_doc_num_from '||p_ar_doc_num_from);
4926:
4927: FND_LOG.STRING(l_proc_level
4928: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4929: ,'p_ar_doc_num_to '||p_ar_doc_num_to);
4930:
4931: FND_LOG.STRING(l_proc_level

Line 4931: FND_LOG.STRING(l_proc_level

4927: FND_LOG.STRING(l_proc_level
4928: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4929: ,'p_ar_doc_num_to '||p_ar_doc_num_to);
4930:
4931: FND_LOG.STRING(l_proc_level
4932: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4933: ,'p_original_curr_code '||p_original_curr_code);
4934:
4935: FND_LOG.STRING(l_proc_level

Line 4935: FND_LOG.STRING(l_proc_level

4931: FND_LOG.STRING(l_proc_level
4932: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4933: ,'p_original_curr_code '||p_original_curr_code);
4934:
4935: FND_LOG.STRING(l_proc_level
4936: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4937: ,'p_primary_sales '||p_primary_sales);
4938:
4939: END IF; --( l_proc_level >= l_dbg_level)

Line 4971: FND_LOG.string(l_proc_level

4967:
4968: --Logging for debug
4969: IF (l_proc_level>=l_dbg_level)
4970: THEN
4971: FND_LOG.string(l_proc_level
4972: ,G_MODULE_PREFIX||'.'||l_api_name||'.phase'
4973: ,'c_trx_header'
4974: );
4975:

Line 4976: FND_LOG.string(l_proc_level

4972: ,G_MODULE_PREFIX||'.'||l_api_name||'.phase'
4973: ,'c_trx_header'
4974: );
4975:
4976: FND_LOG.string(l_proc_level
4977: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4978: ,'l_ar_trx_header_id '||l_ar_trx_header_id
4979: );
4980:

Line 4981: FND_LOG.string(l_proc_level

4977: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4978: ,'l_ar_trx_header_id '||l_ar_trx_header_id
4979: );
4980:
4981: FND_LOG.string(l_proc_level
4982: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4983: ,'l_ar_trx_number '||l_ar_trx_number
4984: );
4985:

Line 4986: FND_LOG.string(l_proc_level

4982: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4983: ,'l_ar_trx_number '||l_ar_trx_number
4984: );
4985:
4986: FND_LOG.string(l_proc_level
4987: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4988: ,'l_ar_trx_date '||l_ar_trx_date
4989: );
4990:

Line 4992: FND_LOG.string(l_proc_level

4988: ,'l_ar_trx_date '||l_ar_trx_date
4989: );
4990:
4991:
4992: FND_LOG.string(l_proc_level
4993: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4994: ,'l_ar_customer_name '||l_ar_customer_name
4995: );
4996:

Line 4997: FND_LOG.string(l_proc_level

4993: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4994: ,'l_ar_customer_name '||l_ar_customer_name
4995: );
4996:
4997: FND_LOG.string(l_proc_level
4998: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4999: ,'l_ar_currency_code '||l_ar_currency_code
5000: );
5001: END IF; --(l_proc_level>=l_proc_level)

Line 5207: FND_LOG.string(l_proc_level

5203: --Logging for debug
5204:
5205: IF (l_proc_level>=l_dbg_level)
5206: THEN
5207: FND_LOG.string(l_proc_level
5208: ,G_MODULE_PREFIX||'.'||l_api_name||'.end'
5209: ,'Exit Procedure'
5210: );
5211: END IF;

Line 5217: Fnd_Log.String( l_proc_level

5213: EXCEPTION
5214: WHEN OTHERS THEN
5215: IF(l_proc_level>=l_dbg_level)
5216: THEN
5217: Fnd_Log.String( l_proc_level
5218: , G_Module_Prefix || l_api_name || '. Other_Exception '
5219: , Sqlcode||':'||Sqlerrm);
5220:
5221: END IF;

Line 5305: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5301: -- added by Allen Yang for bug 8848696 02-Sep-2009
5302: l_invoice_type_disp FND_LOOKUP_VALUES_VL.MEANING%TYPE;
5303: -- end added by Allen Yang
5304:
5305: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5306: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5307:
5308: CURSOR c_consolidation_trx_ids IS
5309: SELECT

Line 5306: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

5302: l_invoice_type_disp FND_LOOKUP_VALUES_VL.MEANING%TYPE;
5303: -- end added by Allen Yang
5304:
5305: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5306: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5307:
5308: CURSOR c_consolidation_trx_ids IS
5309: SELECT
5310: GTA_TRX_HEADER_ID

Line 5343: FND_LOG.string( l_proc_level

5339: BEGIN
5340: --logging for debug
5341: IF (l_proc_level>=l_dbg_level)
5342: THEN
5343: FND_LOG.string( l_proc_level
5344: , G_MODULE_PREFIX||l_procedure_name||'.begin'
5345: , 'enter procedure');
5346: END IF; --(l_proc_level>=l_dbg_level)
5347:

Line 5414: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5410: WHERE lookup_type = 'AR_GTA_INVOICE_TYPE'
5411: AND lookup_code = p_invoice_type;
5412: EXCEPTION
5413: WHEN NO_DATA_FOUND THEN
5414: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5415: fnd_log.String(fnd_log.LEVEL_EXCEPTION,
5416: G_MODULE_PREFIX || l_procedure_name,
5417: 'No data found ');
5418: END IF;

Line 5415: fnd_log.String(fnd_log.LEVEL_EXCEPTION,

5411: AND lookup_code = p_invoice_type;
5412: EXCEPTION
5413: WHEN NO_DATA_FOUND THEN
5414: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5415: fnd_log.String(fnd_log.LEVEL_EXCEPTION,
5416: G_MODULE_PREFIX || l_procedure_name,
5417: 'No data found ');
5418: END IF;
5419: RAISE;

Line 5421: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

5417: 'No data found ');
5418: END IF;
5419: RAISE;
5420: WHEN OTHERS THEN
5421: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5422: fnd_log.String(fnd_log.LEVEL_EXCEPTION,
5423: G_MODULE_PREFIX || l_procedure_name,
5424: 'Other exception');
5425: END IF;

Line 5422: fnd_log.String(fnd_log.LEVEL_EXCEPTION,

5418: END IF;
5419: RAISE;
5420: WHEN OTHERS THEN
5421: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5422: fnd_log.String(fnd_log.LEVEL_EXCEPTION,
5423: G_MODULE_PREFIX || l_procedure_name,
5424: 'Other exception');
5425: END IF;
5426: RAISE;

Line 5485: FND_LOG.string( l_proc_level

5481:
5482: --logging for debug
5483: IF (l_proc_level>=l_dbg_level)
5484: THEN
5485: FND_LOG.string( l_proc_level
5486: , G_MODULE_PREFIX||l_procedure_name||'.end'
5487: , 'end procedure');
5488: END IF; --l_proc_level>=l_dbg_level
5489:

Line 5492: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)

5488: END IF; --l_proc_level>=l_dbg_level
5489:
5490: EXCEPTION
5491: WHEN OTHERS THEN
5492: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
5493: THEN
5494: Fnd_Log.String( Fnd_Log.Level_Unexpected
5495: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
5496: , Sqlcode||Sqlerrm);

Line 5494: Fnd_Log.String( Fnd_Log.Level_Unexpected

5490: EXCEPTION
5491: WHEN OTHERS THEN
5492: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
5493: THEN
5494: Fnd_Log.String( Fnd_Log.Level_Unexpected
5495: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
5496: , Sqlcode||Sqlerrm);
5497: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level
5498:

Line 5497: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level

5493: THEN
5494: Fnd_Log.String( Fnd_Log.Level_Unexpected
5495: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
5496: , Sqlcode||Sqlerrm);
5497: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level
5498:
5499: END Generate_Consol_Mapping_Rep;
5500:
5501: --==========================================================================

Line 5535: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5531: consolidated -- invoice which consists of several consolidation invoices
5532: consolidation -- invoice which is consolidated into a consolidated invoice
5533: */
5534: l_procedure_name VARCHAR2(40):='Get_Consolidation_Trx';
5535: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5536: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5537: l_ret_xmlelement Xmltype;
5538:
5539: BEGIN

Line 5536: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

5532: consolidation -- invoice which is consolidated into a consolidated invoice
5533: */
5534: l_procedure_name VARCHAR2(40):='Get_Consolidation_Trx';
5535: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5536: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5537: l_ret_xmlelement Xmltype;
5538:
5539: BEGIN
5540: --logging for debug

Line 5543: FND_LOG.string( l_proc_level

5539: BEGIN
5540: --logging for debug
5541: IF (l_proc_level>=l_dbg_level)
5542: THEN
5543: FND_LOG.string( l_proc_level
5544: , G_MODULE_PREFIX||l_procedure_name||'.begin'
5545: , 'enter procedure');
5546: END IF; --(l_proc_level>=l_dbg_level)
5547:

Line 5596: FND_LOG.string( l_proc_level

5592:
5593: --logging for debug
5594: IF (l_proc_level>=l_dbg_level)
5595: THEN
5596: FND_LOG.string( l_proc_level
5597: , G_MODULE_PREFIX||l_procedure_name||'.end'
5598: , 'end procedure');
5599: END IF; --l_proc_level>=l_dbg_level
5600:

Line 5605: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)

5601: RETURN l_ret_xmlelement;
5602:
5603: EXCEPTION
5604: WHEN OTHERS THEN
5605: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
5606: THEN
5607: Fnd_Log.String( Fnd_Log.Level_Unexpected
5608: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
5609: , Sqlcode||Sqlerrm);

Line 5607: Fnd_Log.String( Fnd_Log.Level_Unexpected

5603: EXCEPTION
5604: WHEN OTHERS THEN
5605: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
5606: THEN
5607: Fnd_Log.String( Fnd_Log.Level_Unexpected
5608: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
5609: , Sqlcode||Sqlerrm);
5610: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level
5611: END Get_Consolidation_Trx;

Line 5610: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level

5606: THEN
5607: Fnd_Log.String( Fnd_Log.Level_Unexpected
5608: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
5609: , Sqlcode||Sqlerrm);
5610: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level
5611: END Get_Consolidation_Trx;
5612:
5613: --==========================================================================
5614: -- PROCEDURE NAME:

Line 5647: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

5643: consolidated -- invoice which consists of several consolidation invoices
5644: consolidation -- invoice which is consolidated into a consolidated invoice
5645: */
5646: l_procedure_name VARCHAR2(40):='Get_Consolidated_Trxs';
5647: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5648: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5649: l_ret_xmlelement Xmltype;
5650:
5651: BEGIN

Line 5648: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

5644: consolidation -- invoice which is consolidated into a consolidated invoice
5645: */
5646: l_procedure_name VARCHAR2(40):='Get_Consolidated_Trxs';
5647: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5648: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
5649: l_ret_xmlelement Xmltype;
5650:
5651: BEGIN
5652: --logging for debug

Line 5655: FND_LOG.string( l_proc_level

5651: BEGIN
5652: --logging for debug
5653: IF (l_proc_level>=l_dbg_level)
5654: THEN
5655: FND_LOG.string( l_proc_level
5656: , G_MODULE_PREFIX||l_procedure_name||'.begin'
5657: , 'enter procedure');
5658: END IF; --(l_proc_level>=l_dbg_level)
5659:

Line 5692: FND_LOG.string( l_proc_level

5688:
5689: --logging for debug
5690: IF (l_proc_level>=l_dbg_level)
5691: THEN
5692: FND_LOG.string( l_proc_level
5693: , G_MODULE_PREFIX||l_procedure_name||'.end'
5694: , 'end procedure');
5695: END IF; --l_proc_level>=l_dbg_level
5696:

Line 5701: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)

5697: RETURN l_ret_xmlelement;
5698:
5699: EXCEPTION
5700: WHEN OTHERS THEN
5701: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
5702: THEN
5703: Fnd_Log.String( Fnd_Log.Level_Unexpected
5704: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
5705: , Sqlcode||Sqlerrm);

Line 5703: Fnd_Log.String( Fnd_Log.Level_Unexpected

5699: EXCEPTION
5700: WHEN OTHERS THEN
5701: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
5702: THEN
5703: Fnd_Log.String( Fnd_Log.Level_Unexpected
5704: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
5705: , Sqlcode||Sqlerrm);
5706: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level
5707: END Get_Consolidated_Trxs;

Line 5706: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level

5702: THEN
5703: Fnd_Log.String( Fnd_Log.Level_Unexpected
5704: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
5705: , Sqlcode||Sqlerrm);
5706: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level
5707: END Get_Consolidated_Trxs;
5708: --==========================================================================
5709: -- PROCEDURE NAME:
5710: --

Line 5816: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)

5812:
5813: BEGIN
5814:
5815: --logging for debug
5816: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
5817: THEN
5818: FND_LOG.string( Fnd_Log.Level_Unexpected
5819: , G_MODULE_PREFIX||l_procedure_name||'.begin'
5820: , 'enter procedure');

Line 5818: FND_LOG.string( Fnd_Log.Level_Unexpected

5814:
5815: --logging for debug
5816: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
5817: THEN
5818: FND_LOG.string( Fnd_Log.Level_Unexpected
5819: , G_MODULE_PREFIX||l_procedure_name||'.begin'
5820: , 'enter procedure');
5821: END IF; --(l_proc_level>=l_dbg_level)
5822:

Line 6097: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)

6093:
6094: x_has_difference:=l_has_difference;
6095: EXCEPTION
6096: WHEN OTHERS THEN
6097: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
6098: THEN
6099: Fnd_Log.String( Fnd_Log.Level_Unexpected
6100: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
6101: , Sqlcode||Sqlerrm);

Line 6099: Fnd_Log.String( Fnd_Log.Level_Unexpected

6095: EXCEPTION
6096: WHEN OTHERS THEN
6097: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
6098: THEN
6099: Fnd_Log.String( Fnd_Log.Level_Unexpected
6100: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
6101: , Sqlcode||Sqlerrm);
6102: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level
6103:

Line 6102: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level

6098: THEN
6099: Fnd_Log.String( Fnd_Log.Level_Unexpected
6100: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
6101: , Sqlcode||Sqlerrm);
6102: END IF; --Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level
6103:
6104: END Compare_Consolidated_Inv;
6105:
6106: END AR_GTA_REPORTS_PKG;