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.

[Home] [Help]

APPS.JMF_GTA_REPORTS_PKG dependencies on FND_LOG

Line 51: --| Adding fnd log |

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

Line 102: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

98: )
99: RETURN VARCHAR2
100: IS
101: l_procedure_name VARCHAR2(40):='Get_Gt_Count';
102: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
103: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
104:
105: l_count NUMBER:=0;
106: BEGIN

Line 103: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

99: RETURN VARCHAR2
100: IS
101: l_procedure_name VARCHAR2(40):='Get_Gt_Count';
102: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
103: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
104:
105: l_count NUMBER:=0;
106: BEGIN
107: --logging for debug

Line 110: FND_LOG.string( l_proc_level

106: BEGIN
107: --logging for debug
108: IF (l_proc_level>=l_dbg_level)
109: THEN
110: FND_LOG.string( l_proc_level
111: , G_MODULE_PREFIX||l_procedure_name||'.begin'
112: , 'enter function'
113: );
114: END IF;

Line 136: FND_LOG.string( l_proc_level

132:
133: --logging for debug
134: IF (l_proc_level>=l_dbg_level)
135: THEN
136: FND_LOG.string( l_proc_level
137: , G_MODULE_PREFIX||l_procedure_name||'.end'
138: , 'end function'
139: );
140: END IF;

Line 197: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

193: )
194: RETURN XMLTYPE
195: IS
196: l_procedure_name VARCHAR2(40):='Get_Ar_Trx';
197: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
198: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
199:
200: l_ret_xmlelement Xmltype;
201: BEGIN

Line 198: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

194: RETURN XMLTYPE
195: IS
196: l_procedure_name VARCHAR2(40):='Get_Ar_Trx';
197: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
198: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
199:
200: l_ret_xmlelement Xmltype;
201: BEGIN
202: --logging for debug

Line 205: FND_LOG.string( l_proc_level

201: BEGIN
202: --logging for debug
203: IF (l_proc_level>=l_dbg_level)
204: THEN
205: FND_LOG.string( l_proc_level
206: , G_MODULE_PREFIX||l_procedure_name||'.begin'
207: , 'enter function'
208: );
209: END IF;

Line 300: FND_LOG.string( l_proc_level

296:
297: --logging for debug
298: IF (l_proc_level>=l_dbg_level)
299: THEN
300: FND_LOG.string( l_proc_level
301: , G_MODULE_PREFIX||l_procedure_name||'.end'
302: , 'end function'
303: );
304: END IF;

Line 355: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

351: )
352: RETURN Xmltype
353: IS
354: l_procedure_name VARCHAR2(40):='Get_Gt_Trxs';
355: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
356: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
357:
358: l_Ret_Xmlelement Xmltype;
359: l_count NUMBER;

Line 356: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

352: RETURN Xmltype
353: IS
354: l_procedure_name VARCHAR2(40):='Get_Gt_Trxs';
355: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
356: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
357:
358: l_Ret_Xmlelement Xmltype;
359: l_count NUMBER;
360: BEGIN

Line 364: FND_LOG.string( l_proc_level

360: BEGIN
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||'.begin'
366: , 'enter function'
367: );
368: END IF;

Line 418: FND_LOG.string( l_proc_level

414:
415: --logging for debug
416: IF (l_proc_level>=l_dbg_level)
417: THEN
418: FND_LOG.string( l_proc_level
419: , G_MODULE_PREFIX||l_procedure_name||'.end'
420: , 'end function'
421: );
422: END IF;

Line 505: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

501: l_Ar_Inv_Date_From DATE;
502: l_Ar_Inv_Date_To DATE;
503: l_gt_cur VARCHAR2(100);
504:
505: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
506: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
507:
508: CURSOR C_cur IS
509: SELECT

Line 506: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

502: l_Ar_Inv_Date_To DATE;
503: l_gt_cur VARCHAR2(100);
504:
505: l_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
506: l_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
507:
508: CURSOR C_cur IS
509: SELECT
510: sysp.gt_currency_code

Line 544: FND_LOG.string( l_proc_level

540: BEGIN
541: --logging for debug
542: IF (l_proc_level>=l_dbg_level)
543: THEN
544: FND_LOG.string( l_proc_level
545: , G_MODULE_PREFIX||l_procedure_name||'.begin'
546: , 'enter procedure'
547: );
548: END IF;

Line 728: FND_LOG.string( l_proc_level

724:
725: --logging for debug
726: IF (l_proc_level>=l_dbg_level)
727: THEN
728: FND_LOG.string( l_proc_level
729: , G_MODULE_PREFIX||l_procedure_name||'.end'
730: , 'end procedure'
731: );
732: END IF;

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

732: END IF;
733:
734: EXCEPTION
735: WHEN OTHERS THEN
736: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
737: THEN
738: Fnd_Log.String( Fnd_Log.Level_Unexpected
739: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
740: , Sqlcode||Sqlerrm);

Line 738: Fnd_Log.String( Fnd_Log.Level_Unexpected

734: EXCEPTION
735: WHEN OTHERS THEN
736: IF(Fnd_Log.Level_Unexpected >= Fnd_Log.G_Current_Runtime_Level)
737: THEN
738: Fnd_Log.String( Fnd_Log.Level_Unexpected
739: , G_MODULE_PREFIX || l_procedure_name || '.Other_Exception '
740: , Sqlcode||Sqlerrm);
741: END IF;
742:

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

769: -- 11/25/05 Donghai Wang modify code to follow ebtax
770: -- requirement
771: -- 30/12/05 Donghai Wang Update cursor c_ar_header to
772: -- modify table names
773: -- 03/04/05 Donghai Wang Add FND Log
774: -- 07/05/07 Allen Yang Modify code to fix bug 6147067
775: -- 01/02/08 Subba Updated code for R12.1
776: --===========================================================================
777: PROCEDURE Compare_Header

Line 988: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

984: AND gta.status<>'CANCELLED'
985: AND gta.latest_version_flag='Y';
986:
987:
988: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
989: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
990:
991: BEGIN
992:

Line 989: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

985: AND gta.latest_version_flag='Y';
986:
987:
988: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
989: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
990:
991: BEGIN
992:
993: --log for debug

Line 997: FND_LOG.String(l_proc_level

993: --log for debug
994: IF( l_proc_level >= l_dbg_level)
995: THEN
996:
997: FND_LOG.String(l_proc_level
998: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
999: ,'Enter procedure'
1000: );
1001:

Line 1003: FND_LOG.String(l_proc_level

999: ,'Enter procedure'
1000: );
1001:
1002:
1003: FND_LOG.String(l_proc_level
1004: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
1005: ,'l_ar_header_id '||l_ar_header_id
1006: );
1007:

Line 1008: FND_LOG.String(l_proc_level

1004: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
1005: ,'l_ar_header_id '||l_ar_header_id
1006: );
1007:
1008: FND_LOG.String(l_proc_level
1009: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
1010: ,'l_org_id '||l_org_id
1011: );
1012:

Line 1023: FND_LOG.String(l_proc_level

1019:
1020: --log for debug
1021: IF( l_proc_level >= l_dbg_level)
1022: THEN
1023: FND_LOG.String(l_proc_level
1024: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1025: ,'l_ar_mask_bank '||l_ar_mask_bank
1026: );
1027: END IF; --( l_proc_level >= l_dbg_level)

Line 1122: FND_LOG.String(l_proc_level

1118:
1119: --log for debug
1120: IF( l_proc_level >= l_dbg_level)
1121: THEN
1122: FND_LOG.String(l_proc_level
1123: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1124: ,'l_ar_customer_id '||l_ar_customer_id
1125: );
1126:

Line 1127: FND_LOG.String(l_proc_level

1123: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1124: ,'l_ar_customer_id '||l_ar_customer_id
1125: );
1126:
1127: FND_LOG.String(l_proc_level
1128: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1129: ,'l_ar_customer_name '||l_ar_customer_name
1130: );
1131:

Line 1132: FND_LOG.String(l_proc_level

1128: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1129: ,'l_ar_customer_name '||l_ar_customer_name
1130: );
1131:
1132: FND_LOG.String(l_proc_level
1133: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1134: ,'l_ar_customer_address '||l_ar_customer_address
1135: );
1136:

Line 1170: FND_LOG.String(l_proc_level

1166:
1167: --log for debug
1168: IF( l_proc_level >= l_dbg_level)
1169: THEN
1170: FND_LOG.String(l_proc_level
1171: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1172: ,'l_ar_amount '||l_ar_amount
1173: );
1174:

Line 1175: FND_LOG.String(l_proc_level

1171: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1172: ,'l_ar_amount '||l_ar_amount
1173: );
1174:
1175: FND_LOG.String(l_proc_level
1176: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1177: ,'l_ar_taxamount '||l_ar_taxamount
1178: );
1179:

Line 1217: FND_LOG.String(l_proc_level

1213:
1214: --log for debug
1215: IF( l_proc_level >= l_dbg_level)
1216: THEN
1217: FND_LOG.String(l_proc_level
1218: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1219: ,'l_ar_customer_bank_account '||l_ar_customer_bank_account
1220: );
1221:

Line 1222: FND_LOG.String(l_proc_level

1218: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1219: ,'l_ar_customer_bank_account '||l_ar_customer_bank_account
1220: );
1221:
1222: FND_LOG.String(l_proc_level
1223: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1224: ,'l_ar_customer_address_phone '||l_ar_customer_address_phone
1225: );
1226:

Line 1252: FND_LOG.String(l_proc_level

1248:
1249: --Log for debug
1250: IF( l_proc_level >= l_dbg_level)
1251: THEN
1252: FND_LOG.String(l_proc_level
1253: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1254: ,'l_gta_amount_loop_count '||l_gta_amount_loop_count||','
1255: ||'l_gta_amount_sum '||l_gta_amount_sum||','
1256: ||'l_gta_taxamount_sum '||l_gta_taxamount_sum||','

Line 1319: FND_LOG.String(l_proc_level

1315:
1316: --log for debug
1317: IF( l_proc_level >= l_dbg_level)
1318: THEN
1319: FND_LOG.String(l_proc_level
1320: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1321: ,'l_gta_loop_count '||l_gta_loop_count
1322: );
1323:

Line 1325: FND_LOG.String(l_proc_level

1321: ,'l_gta_loop_count '||l_gta_loop_count
1322: );
1323:
1324: /*Commented by Allen to fix issue #2 in bug 6147067
1325: FND_LOG.String(l_proc_level
1326: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1327: ,'l_gta_amount '||l_gta_amount
1328: );
1329:

Line 1330: FND_LOG.String(l_proc_level

1326: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1327: ,'l_gta_amount '||l_gta_amount
1328: );
1329:
1330: FND_LOG.String(l_proc_level
1331: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1332: ,'l_gta_taxamount '||l_gta_taxamount
1333: );
1334: */

Line 1336: FND_LOG.String(l_proc_level

1332: ,'l_gta_taxamount '||l_gta_taxamount
1333: );
1334: */
1335:
1336: FND_LOG.String(l_proc_level
1337: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1338: ,'l_gta_customer_name '||l_gta_customer_name
1339: );
1340:

Line 1341: FND_LOG.String(l_proc_level

1337: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1338: ,'l_gta_customer_name '||l_gta_customer_name
1339: );
1340:
1341: FND_LOG.String(l_proc_level
1342: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1343: ,'l_gta_taxpayer_id '||l_gta_taxpayer_id
1344: );
1345:

Line 1346: FND_LOG.String(l_proc_level

1342: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1343: ,'l_gta_taxpayer_id '||l_gta_taxpayer_id
1344: );
1345:
1346: FND_LOG.String(l_proc_level
1347: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1348: ,'l_gta_customer_bank_account '||
1349: l_gta_customer_bank_account
1350: );

Line 1352: FND_LOG.String(l_proc_level

1348: ,'l_gta_customer_bank_account '||
1349: l_gta_customer_bank_account
1350: );
1351:
1352: FND_LOG.String(l_proc_level
1353: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1354: ,'l_gta_customer_address_phone '||
1355: l_gta_customer_address_phone
1356: );

Line 1358: FND_LOG.String(l_proc_level

1354: ,'l_gta_customer_address_phone '||
1355: l_gta_customer_address_phone
1356: );
1357:
1358: FND_LOG.String(l_proc_level
1359: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1360: ,'l_gta_trx_number '||l_gta_trx_number
1361: );
1362: --added by subba for R12.1

Line 1364: FND_LOG.String(l_proc_level

1360: ,'l_gta_trx_number '||l_gta_trx_number
1361: );
1362: --added by subba for R12.1
1363:
1364: FND_LOG.String(l_proc_level
1365: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1366: ,'l_gta_invoice_type '||l_gta_invoice_type
1367: );
1368:

Line 1390: FND_LOG.String(l_proc_level

1386:
1387: IF( l_proc_level >= l_dbg_level)
1388: THEN
1389:
1390: FND_LOG.String(l_proc_level
1391: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1392: ,'l_gt_amount '||l_gt_amount
1393: );
1394:

Line 1395: FND_LOG.String(l_proc_level

1391: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1392: ,'l_gt_amount '||l_gt_amount
1393: );
1394:
1395: FND_LOG.String(l_proc_level
1396: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1397: ,'l_gt_taxamount '||l_gt_taxamount
1398: );
1399:

Line 1400: FND_LOG.String(l_proc_level

1396: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1397: ,'l_gt_taxamount '||l_gt_taxamount
1398: );
1399:
1400: FND_LOG.String(l_proc_level
1401: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1402: ,'l_gt_customer_name '||l_gt_customer_name
1403: );
1404:

Line 1405: FND_LOG.String(l_proc_level

1401: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1402: ,'l_gt_customer_name '||l_gt_customer_name
1403: );
1404:
1405: FND_LOG.String(l_proc_level
1406: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1407: ,'l_gt_taxpayer_id '||l_gt_taxpayer_id
1408: );
1409:

Line 1410: FND_LOG.String(l_proc_level

1406: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1407: ,'l_gt_taxpayer_id '||l_gt_taxpayer_id
1408: );
1409:
1410: FND_LOG.String(l_proc_level
1411: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1412: ,'l_gt_customer_bank_account '||
1413: l_gt_customer_bank_account
1414: );

Line 1416: FND_LOG.String(l_proc_level

1412: ,'l_gt_customer_bank_account '||
1413: l_gt_customer_bank_account
1414: );
1415:
1416: FND_LOG.String(l_proc_level
1417: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1418: ,'l_gt_customer_address_phone '||
1419: l_gt_customer_address_phone
1420: );

Line 1422: FND_LOG.String(l_proc_level

1418: ,'l_gt_customer_address_phone '||
1419: l_gt_customer_address_phone
1420: );
1421:
1422: FND_LOG.String(l_proc_level
1423: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1424: ,'l_gt_invoice_number '||l_gt_invoice_number
1425: );
1426:

Line 1427: FND_LOG.String(l_proc_level

1423: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1424: ,'l_gt_invoice_number '||l_gt_invoice_number
1425: );
1426:
1427: FND_LOG.String(l_proc_level
1428: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
1429: ,'l_gt_invoice_type '||l_gt_invoice_type
1430: );
1431:

Line 1943: FND_LOG.String(l_proc_level

1939:
1940: --log for debug
1941: IF( l_proc_level >= l_dbg_level)
1942: THEN
1943: FND_LOG.String(l_proc_level
1944: ,G_MODULE_PREFIX||'.'||l_api_name||'.end'
1945: ,'Exit procedure');
1946:
1947:

Line 1955: FND_LOG.String( l_proc_level

1951: WHEN OTHERS THEN
1952: IF(l_proc_level >= l_dbg_level)
1953: THEN
1954: l_error_msg:=SQLCODE||':'||SQLERRM;
1955: FND_LOG.String( l_proc_level
1956: , g_module_prefix || l_api_name || '. Other_Exception '
1957: , l_error_msg
1958: );
1959:

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

1957: , l_error_msg
1958: );
1959:
1960:
1961: END IF; --(FND_LOG.Level_Unexpected >= FND_LOG.G_Current_Runtime_Level)
1962:
1963: IF c_gta_headers%ISOPEN
1964: THEN
1965: CLOSE c_gta_headers;

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

1992: --
1993: -- 05/17/05 Donghai Wang Created.
1994: -- 11/25/05 Donghai Wang modify code to follow ebtax
1995: -- requirement
1996: -- 03/04/05 Donghai Wang Add FND Log
1997: -- 06/28/06 Donghai Wang Fix the bug 5263009
1998: -- 07/21/06 Donghai Wang Fix the bug 5381833
1999: -- 06/18/07 Donghai Wang Fix the bug 6132187
2000: --

Line 2215: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

2211: );
2212:
2213:
2214:
2215: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2216: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2217: l_ar_loop_count NUMBER;
2218: l_gta_loop_count NUMBER;
2219:

Line 2216: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

2212:
2213:
2214:
2215: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2216: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2217: l_ar_loop_count NUMBER;
2218: l_gta_loop_count NUMBER;
2219:
2220: BEGIN

Line 2225: FND_LOG.String(l_proc_level

2221:
2222: --log for debug
2223: IF( l_proc_level >= l_dbg_level)
2224: THEN
2225: FND_LOG.String(l_proc_level
2226: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
2227: ,'Enter procedure'
2228: );
2229:

Line 2230: FND_LOG.String(l_proc_level

2226: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
2227: ,'Enter procedure'
2228: );
2229:
2230: FND_LOG.String(l_proc_level
2231: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
2232: ,'l_ar_header_id '||l_ar_header_id
2233: );
2234:

Line 2235: FND_LOG.String(l_proc_level

2231: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
2232: ,'l_ar_header_id '||l_ar_header_id
2233: );
2234:
2235: FND_LOG.String(l_proc_level
2236: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
2237: ,'l_org_id '||l_org_id
2238: );
2239:

Line 2377: FND_LOG.String(l_proc_level

2373: --log for debug
2374: IF( l_proc_level >= l_dbg_level)
2375: THEN
2376:
2377: FND_LOG.String(l_proc_level
2378: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2379: ,'l_ar_loop_count '||l_ar_loop_count
2380: );
2381:

Line 2382: FND_LOG.String(l_proc_level

2378: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2379: ,'l_ar_loop_count '||l_ar_loop_count
2380: );
2381:
2382: FND_LOG.String(l_proc_level
2383: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2384: ,'l_ar_line_id '||l_ar_line_id
2385: );
2386:

Line 2387: FND_LOG.String(l_proc_level

2383: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2384: ,'l_ar_line_id '||l_ar_line_id
2385: );
2386:
2387: FND_LOG.String(l_proc_level
2388: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2389: ,'l_ar_line_number '||l_ar_line_number
2390: );
2391:

Line 2392: FND_LOG.String(l_proc_level

2388: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2389: ,'l_ar_line_number '||l_ar_line_number
2390: );
2391:
2392: FND_LOG.String(l_proc_level
2393: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2394: ,'l_ar_goods_description '||l_ar_goods_description
2395: );
2396:

Line 2397: FND_LOG.String(l_proc_level

2393: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2394: ,'l_ar_goods_description '||l_ar_goods_description
2395: );
2396:
2397: FND_LOG.String(l_proc_level
2398: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2399: ,'l_ar_quantity '||l_ar_quantity
2400: );
2401:

Line 2402: FND_LOG.String(l_proc_level

2398: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2399: ,'l_ar_quantity '||l_ar_quantity
2400: );
2401:
2402: FND_LOG.String(l_proc_level
2403: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2404: ,'l_ar_unit_price '||l_ar_unit_price
2405: );
2406:

Line 2407: FND_LOG.String(l_proc_level

2403: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2404: ,'l_ar_unit_price '||l_ar_unit_price
2405: );
2406:
2407: FND_LOG.String(l_proc_level
2408: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2409: ,'l_ar_uom '||l_ar_uom
2410: );
2411:

Line 2462: FND_LOG.String(l_proc_level

2458: --log for debug
2459: IF( l_proc_level >= l_dbg_level)
2460: THEN
2461:
2462: FND_LOG.String(l_proc_level
2463: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2464: ,'l_ar_tax_reg_number '||l_ar_tax_reg_number
2465: );
2466:

Line 2467: FND_LOG.String(l_proc_level

2463: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2464: ,'l_ar_tax_reg_number '||l_ar_tax_reg_number
2465: );
2466:
2467: FND_LOG.String(l_proc_level
2468: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2469: ,'l_ar_line_amount '||l_ar_line_amount
2470: );
2471:

Line 2472: FND_LOG.String(l_proc_level

2468: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2469: ,'l_ar_line_amount '||l_ar_line_amount
2470: );
2471:
2472: FND_LOG.String(l_proc_level
2473: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2474: ,'l_ar_vat_line_tax '||l_ar_vat_line_tax
2475: );
2476:

Line 2477: FND_LOG.String(l_proc_level

2473: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2474: ,'l_ar_vat_line_tax '||l_ar_vat_line_tax
2475: );
2476:
2477: FND_LOG.String(l_proc_level
2478: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2479: ,'l_ar_vat_tax_rate '||l_ar_vat_tax_rate
2480: );
2481:

Line 2512: FND_LOG.String(l_proc_level

2508: --log for debug
2509: IF( l_proc_level >= l_dbg_level)
2510: THEN
2511:
2512: FND_LOG.String(l_proc_level
2513: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2514: ,'l_gta_loop_count '||l_gta_loop_count
2515: );
2516:

Line 2517: FND_LOG.String(l_proc_level

2513: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2514: ,'l_gta_loop_count '||l_gta_loop_count
2515: );
2516:
2517: FND_LOG.String(l_proc_level
2518: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2519: ,'l_gta_trx_number '||l_gta_trx_number
2520: );
2521:

Line 2522: FND_LOG.String(l_proc_level

2518: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2519: ,'l_gta_trx_number '||l_gta_trx_number
2520: );
2521:
2522: FND_LOG.String(l_proc_level
2523: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2524: ,'l_gta_tax_reg_number '||l_gta_tax_reg_number
2525: );
2526:

Line 2527: FND_LOG.String(l_proc_level

2523: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2524: ,'l_gta_tax_reg_number '||l_gta_tax_reg_number
2525: );
2526:
2527: FND_LOG.String(l_proc_level
2528: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2529: ,'l_gta_line_number '||l_gta_line_number
2530: );
2531:

Line 2532: FND_LOG.String(l_proc_level

2528: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2529: ,'l_gta_line_number '||l_gta_line_number
2530: );
2531:
2532: FND_LOG.String(l_proc_level
2533: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2534: ,'l_gta_vat_line_tax '||l_gta_vat_line_tax
2535: );
2536:

Line 2537: FND_LOG.String(l_proc_level

2533: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2534: ,'l_gta_vat_line_tax '||l_gta_vat_line_tax
2535: );
2536:
2537: FND_LOG.String(l_proc_level
2538: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2539: ,'l_gta_vat_tax_rate '||l_gta_vat_tax_rate
2540: );
2541:

Line 2542: FND_LOG.String(l_proc_level

2538: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2539: ,'l_gta_vat_tax_rate '||l_gta_vat_tax_rate
2540: );
2541:
2542: FND_LOG.String(l_proc_level
2543: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2544: ,'l_gta_quantity '||l_gta_quantity
2545: );
2546:

Line 2547: FND_LOG.String(l_proc_level

2543: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2544: ,'l_gta_quantity '||l_gta_quantity
2545: );
2546:
2547: FND_LOG.String(l_proc_level
2548: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2549: ,'l_gta_unit_price '||l_gta_unit_price
2550: );
2551:

Line 2552: FND_LOG.String(l_proc_level

2548: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2549: ,'l_gta_unit_price '||l_gta_unit_price
2550: );
2551:
2552: FND_LOG.String(l_proc_level
2553: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2554: ,'l_gta_uom '||l_gta_uom
2555: );
2556:

Line 2557: FND_LOG.String(l_proc_level

2553: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2554: ,'l_gta_uom '||l_gta_uom
2555: );
2556:
2557: FND_LOG.String(l_proc_level
2558: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2559: ,'l_matched_flag '||l_matched_flag
2560: );
2561:

Line 2581: FND_LOG.String(l_proc_level

2577: --log for debug
2578: IF( l_proc_level >= l_dbg_level)
2579: THEN
2580:
2581: FND_LOG.String(l_proc_level
2582: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2583: ,'l_gta_line_amount_sum '||l_gta_line_amount_sum
2584: );
2585:

Line 2586: FND_LOG.String(l_proc_level

2582: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2583: ,'l_gta_line_amount_sum '||l_gta_line_amount_sum
2584: );
2585:
2586: FND_LOG.String(l_proc_level
2587: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2588: ,'l_gta_line_taxamount_sum '||l_gta_line_taxamount_sum
2589: );
2590:

Line 2591: FND_LOG.String(l_proc_level

2587: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2588: ,'l_gta_line_taxamount_sum '||l_gta_line_taxamount_sum
2589: );
2590:
2591: FND_LOG.String(l_proc_level
2592: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2593: ,'l_gta_line_quantity_sum '||l_gta_line_quantity_sum
2594: );
2595:

Line 2607: FND_LOG.String(l_proc_level

2603: --log for debug
2604: IF( l_proc_level >= l_dbg_level)
2605: THEN
2606:
2607: FND_LOG.String(l_proc_level
2608: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2609: ,'l_gt_invoice_number '||l_gt_invoice_number
2610: );
2611: END IF; --( l_proc_level >= l_dbg_level)

Line 2626: FND_LOG.String(l_proc_level

2622: --log for debug
2623: IF( l_proc_level >= l_dbg_level)
2624: THEN
2625:
2626: FND_LOG.String(l_proc_level
2627: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2628: ,'l_gta_trx_number_con '||l_gta_trx_number_con
2629: );
2630: END IF; --( l_proc_level >= l_dbg_level)

Line 2645: FND_LOG.String(l_proc_level

2641: --log for debug
2642: IF( l_proc_level >= l_dbg_level)
2643: THEN
2644:
2645: FND_LOG.String(l_proc_level
2646: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
2647: ,'l_gt_invoice_number_con '||l_gt_invoice_number_con
2648: );
2649: END IF; --( l_proc_level >= l_dbg_level)

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_gta_line_number_con '||l_gta_line_number_con
2667: );
2668: END IF; --( l_proc_level >= l_dbg_level)

Line 3205: FND_LOG.String(l_proc_level

3201: --log for debug
3202: IF( l_proc_level >= l_dbg_level)
3203: THEN
3204:
3205: FND_LOG.String(l_proc_level
3206: ,G_MODULE_PREFIX||'.'||l_api_name||'.phase'
3207: ,'c_missing_ar_line'
3208: );
3209: END IF; --( l_proc_level >= l_dbg_level)

Line 3250: FND_LOG.String(l_proc_level

3246: --log for debug
3247: IF( l_proc_level >= l_dbg_level)
3248: THEN
3249:
3250: FND_LOG.String(l_proc_level
3251: ,G_MODULE_PREFIX||'.'||l_api_name||'.phase'
3252: ,'c_not_transferred_ar_lines'
3253: );
3254: END IF; --( l_proc_level >= l_dbg_level)

Line 3284: FND_LOG.String(l_proc_level

3280:
3281: --log for debug
3282: IF( l_proc_level >= l_dbg_level)
3283: THEN
3284: FND_LOG.String(l_proc_level
3285: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3286: ,'x_validated_lines '||l_validated_lines
3287: );
3288:

Line 3289: FND_LOG.String(l_proc_level

3285: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3286: ,'x_validated_lines '||l_validated_lines
3287: );
3288:
3289: FND_LOG.String(l_proc_level
3290: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3291: ,'x_ar_matching_lines '||l_ar_matching_lines
3292: );
3293:

Line 3294: FND_LOG.String(l_proc_level

3290: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3291: ,'x_ar_matching_lines '||l_ar_matching_lines
3292: );
3293:
3294: FND_LOG.String(l_proc_level
3295: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3296: ,'x_ar_partially_import '||l_ar_partially_import
3297: );
3298:

Line 3299: FND_LOG.String(l_proc_level

3295: ,G_MODULE_PREFIX||'.'||l_api_name||'.returned_value'
3296: ,'x_ar_partially_import '||l_ar_partially_import
3297: );
3298:
3299: FND_LOG.String(l_proc_level
3300: ,G_MODULE_PREFIX||'.'||l_api_name||'.end'
3301: ,'Exit procedure'
3302: );
3303:

Line 3314: FND_LOG.String( l_proc_level

3310: WHEN OTHERS THEN
3311: IF(l_proc_level >= l_dbg_level)
3312: THEN
3313: l_error_msg:=SQLCODE||':'||SQLERRM;
3314: FND_LOG.String( l_proc_level
3315: , G_Module_Prefix || l_api_name || '. Other_Exception '
3316: , l_error_msg);
3317:
3318:

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

3345: --
3346: -- 05/17/05 Donghai Wang Created.
3347: -- 11/25/05 Donghai Wang modify code to follow ebtax
3348: -- requirement
3349: -- 03/04/05 Donghai Wang Add FND Log
3350: -- 07/21/06 Donghai Wang Fix bug 5193632
3351: --
3352: --==========================================================================
3353: PROCEDURE Get_Unmatched_Lines

Line 3423: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3419: AND gt_line.gta_trx_header_id=gt_header.gta_trx_header_id
3420: AND gt_line.matched_flag='N';
3421:
3422: l_gt_unmatched_line c_gt_unmatched_line%ROWTYPE;
3423: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3424: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3425:
3426: BEGIN
3427:

Line 3424: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3420: AND gt_line.matched_flag='N';
3421:
3422: l_gt_unmatched_line c_gt_unmatched_line%ROWTYPE;
3423: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3424: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3425:
3426: BEGIN
3427:
3428: --log for debug

Line 3431: FND_LOG.String(l_proc_level

3427:
3428: --log for debug
3429: IF (l_proc_level >= l_dbg_level)
3430: THEN
3431: FND_LOG.String(l_proc_level
3432: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
3433: ,'Enter procedure'
3434: );
3435: END IF; --(l_proc_level >= l_dbg_level)

Line 3440: FND_LOG.String(l_proc_level

3436:
3437: --log for debug
3438: IF (l_proc_level >= l_dbg_level)
3439: THEN
3440: FND_LOG.String(l_proc_level
3441: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3442: ,'p_org_id '||p_org_id
3443: );
3444:

Line 3445: FND_LOG.String(l_proc_level

3441: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3442: ,'p_org_id '||p_org_id
3443: );
3444:
3445: FND_LOG.String(l_proc_level
3446: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3447: ,'p_ar_header_id '||p_ar_header_id
3448: );
3449: END IF; --(l_proc_level >= l_dbg_level)

Line 3551: FND_LOG.STRING(l_proc_level

3547:
3548: --log for debug
3549: IF ( l_proc_level >= l_dbg_level)
3550: THEN
3551: FND_LOG.STRING(l_proc_level
3552: ,G_MODULE_PREFIX||'.'||l_api_name||'.end'
3553: ,'Exit procedure'
3554: );
3555: END IF; --( l_proc_level >= l_dbg_level )

Line 3561: FND_LOG.String( l_proc_level

3557: EXCEPTION
3558: WHEN OTHERS THEN
3559: IF (l_proc_level >= l_dbg_level)
3560: THEN
3561: FND_LOG.String( l_proc_level
3562: , G_Module_Prefix || l_api_name || '. Other_Exception '
3563: , SQLCODE||':'||SQLERRM);
3564: END IF; --(l_proc_level >= l_dbg_level)
3565: RAISE;

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

3617: --
3618: -- 05/17/05 Donghai Wang Created.
3619: -- 11/25/05 Donghai Wang modify code to follow ebtax
3620: -- requirement
3621: -- 03/04/05 Donghai Wang Add FND Log
3622: -- 06/28/06 Donghai Wang Fix the bug 5263009
3623: -- 07/21/06 Donghai Wang Fix the bug 5381833
3624: -- 09/14/06 Donghai Wang format output date to XSD date
3625: -- format to fix the bug 5521629

Line 3896: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3892: WHERE
3893: org_id=p_org_id;
3894:
3895:
3896: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3897: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3898:
3899:
3900: BEGIN

Line 3897: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3893: org_id=p_org_id;
3894:
3895:
3896: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3897: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3898:
3899:
3900: BEGIN
3901:

Line 3905: FND_LOG.STRING(l_proc_level

3901:
3902: --log for debug
3903: IF( l_proc_level >= l_dbg_level)
3904: THEN
3905: FND_LOG.STRING(l_proc_level
3906: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
3907: ,'Enter procedure');
3908: END IF; --( l_proc_level >= l_dbg_level)
3909:

Line 3914: FND_LOG.STRING(l_proc_level

3910:
3911: --log for debug
3912: IF( l_proc_level >= l_dbg_level)
3913: THEN
3914: FND_LOG.STRING(l_proc_level
3915: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3916: ,'p_org_id '||p_org_id);
3917:
3918: FND_LOG.STRING(l_proc_level

Line 3918: FND_LOG.STRING(l_proc_level

3914: FND_LOG.STRING(l_proc_level
3915: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3916: ,'p_org_id '||p_org_id);
3917:
3918: FND_LOG.STRING(l_proc_level
3919: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3920: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
3921:
3922: FND_LOG.STRING(l_proc_level

Line 3922: FND_LOG.STRING(l_proc_level

3918: FND_LOG.STRING(l_proc_level
3919: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3920: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
3921:
3922: FND_LOG.STRING(l_proc_level
3923: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3924: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
3925:
3926: FND_LOG.STRING(l_proc_level

Line 3926: FND_LOG.STRING(l_proc_level

3922: FND_LOG.STRING(l_proc_level
3923: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3924: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
3925:
3926: FND_LOG.STRING(l_proc_level
3927: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3928: ,'p_ar_transaction_type '||p_ar_transaction_type);
3929:
3930: FND_LOG.STRING(l_proc_level

Line 3930: FND_LOG.STRING(l_proc_level

3926: FND_LOG.STRING(l_proc_level
3927: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3928: ,'p_ar_transaction_type '||p_ar_transaction_type);
3929:
3930: FND_LOG.STRING(l_proc_level
3931: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3932: ,'p_cust_num_from '||p_cust_num_from);
3933:
3934: FND_LOG.STRING(l_proc_level

Line 3934: FND_LOG.STRING(l_proc_level

3930: FND_LOG.STRING(l_proc_level
3931: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3932: ,'p_cust_num_from '||p_cust_num_from);
3933:
3934: FND_LOG.STRING(l_proc_level
3935: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3936: ,'p_cust_num_to '||p_cust_num_to);
3937:
3938: FND_LOG.STRING(l_proc_level

Line 3938: FND_LOG.STRING(l_proc_level

3934: FND_LOG.STRING(l_proc_level
3935: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3936: ,'p_cust_num_to '||p_cust_num_to);
3937:
3938: FND_LOG.STRING(l_proc_level
3939: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3940: ,'p_cust_name_id '||p_cust_name_id);
3941:
3942: FND_LOG.STRING(l_proc_level

Line 3942: FND_LOG.STRING(l_proc_level

3938: FND_LOG.STRING(l_proc_level
3939: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3940: ,'p_cust_name_id '||p_cust_name_id);
3941:
3942: FND_LOG.STRING(l_proc_level
3943: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3944: ,'p_gl_period '||p_gl_period);
3945:
3946: FND_LOG.STRING(l_proc_level

Line 3946: FND_LOG.STRING(l_proc_level

3942: FND_LOG.STRING(l_proc_level
3943: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3944: ,'p_gl_period '||p_gl_period);
3945:
3946: FND_LOG.STRING(l_proc_level
3947: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3948: ,'p_gl_date_from '||p_gl_date_from);
3949:
3950: FND_LOG.STRING(l_proc_level

Line 3950: FND_LOG.STRING(l_proc_level

3946: FND_LOG.STRING(l_proc_level
3947: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3948: ,'p_gl_date_from '||p_gl_date_from);
3949:
3950: FND_LOG.STRING(l_proc_level
3951: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3952: ,'p_gl_date_to '||p_gl_date_to);
3953:
3954: FND_LOG.STRING(l_proc_level

Line 3954: FND_LOG.STRING(l_proc_level

3950: FND_LOG.STRING(l_proc_level
3951: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3952: ,'p_gl_date_to '||p_gl_date_to);
3953:
3954: FND_LOG.STRING(l_proc_level
3955: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3956: ,'p_ar_trx_batch_from '||p_ar_trx_batch_from);
3957:
3958: FND_LOG.STRING(l_proc_level

Line 3958: FND_LOG.STRING(l_proc_level

3954: FND_LOG.STRING(l_proc_level
3955: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3956: ,'p_ar_trx_batch_from '||p_ar_trx_batch_from);
3957:
3958: FND_LOG.STRING(l_proc_level
3959: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3960: ,'p_ar_trx_batch_to '||p_ar_trx_batch_to);
3961:
3962: FND_LOG.STRING(l_proc_level

Line 3962: FND_LOG.STRING(l_proc_level

3958: FND_LOG.STRING(l_proc_level
3959: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3960: ,'p_ar_trx_batch_to '||p_ar_trx_batch_to);
3961:
3962: FND_LOG.STRING(l_proc_level
3963: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3964: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
3965:
3966: FND_LOG.STRING(l_proc_level

Line 3966: FND_LOG.STRING(l_proc_level

3962: FND_LOG.STRING(l_proc_level
3963: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3964: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
3965:
3966: FND_LOG.STRING(l_proc_level
3967: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3968: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
3969:
3970: FND_LOG.STRING(l_proc_level

Line 3970: FND_LOG.STRING(l_proc_level

3966: FND_LOG.STRING(l_proc_level
3967: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3968: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
3969:
3970: FND_LOG.STRING(l_proc_level
3971: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3972: ,'p_ar_trx_date_from '||p_ar_trx_date_from);
3973:
3974: FND_LOG.STRING(l_proc_level

Line 3974: FND_LOG.STRING(l_proc_level

3970: FND_LOG.STRING(l_proc_level
3971: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3972: ,'p_ar_trx_date_from '||p_ar_trx_date_from);
3973:
3974: FND_LOG.STRING(l_proc_level
3975: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3976: ,'p_ar_trx_date_to '||p_ar_trx_date_to);
3977:
3978: FND_LOG.STRING(l_proc_level

Line 3978: FND_LOG.STRING(l_proc_level

3974: FND_LOG.STRING(l_proc_level
3975: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3976: ,'p_ar_trx_date_to '||p_ar_trx_date_to);
3977:
3978: FND_LOG.STRING(l_proc_level
3979: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3980: ,'p_ar_doc_num_from '||p_ar_doc_num_from);
3981:
3982: FND_LOG.STRING(l_proc_level

Line 3982: FND_LOG.STRING(l_proc_level

3978: FND_LOG.STRING(l_proc_level
3979: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3980: ,'p_ar_doc_num_from '||p_ar_doc_num_from);
3981:
3982: FND_LOG.STRING(l_proc_level
3983: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3984: ,'p_ar_doc_num_to '||p_ar_doc_num_to);
3985:
3986: FND_LOG.STRING(l_proc_level

Line 3986: FND_LOG.STRING(l_proc_level

3982: FND_LOG.STRING(l_proc_level
3983: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3984: ,'p_ar_doc_num_to '||p_ar_doc_num_to);
3985:
3986: FND_LOG.STRING(l_proc_level
3987: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3988: ,'p_original_curr_code '||p_original_curr_code);
3989:
3990: FND_LOG.STRING(l_proc_level

Line 3990: FND_LOG.STRING(l_proc_level

3986: FND_LOG.STRING(l_proc_level
3987: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3988: ,'p_original_curr_code '||p_original_curr_code);
3989:
3990: FND_LOG.STRING(l_proc_level
3991: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3992: ,'p_primary_sales '||p_primary_sales);
3993:
3994: FND_LOG.STRING(l_proc_level

Line 3994: FND_LOG.STRING(l_proc_level

3990: FND_LOG.STRING(l_proc_level
3991: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3992: ,'p_primary_sales '||p_primary_sales);
3993:
3994: FND_LOG.STRING(l_proc_level
3995: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3996: ,'p_validated_lines_total '||p_validated_lines_total);
3997:
3998: FND_LOG.STRING(l_proc_level

Line 3998: FND_LOG.STRING(l_proc_level

3994: FND_LOG.STRING(l_proc_level
3995: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
3996: ,'p_validated_lines_total '||p_validated_lines_total);
3997:
3998: FND_LOG.STRING(l_proc_level
3999: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4000: ,'p_ar_matching_lines_total '||p_ar_matching_lines_total);
4001:
4002: FND_LOG.STRING(l_proc_level

Line 4002: FND_LOG.STRING(l_proc_level

3998: FND_LOG.STRING(l_proc_level
3999: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4000: ,'p_ar_matching_lines_total '||p_ar_matching_lines_total);
4001:
4002: FND_LOG.STRING(l_proc_level
4003: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4004: ,'p_ar_partially_import_total '
4005: ||p_ar_partially_import_total
4006: );

Line 4341: FND_LOG.STRING(l_proc_level

4337:
4338: --log for debug
4339: IF( l_proc_level >= l_dbg_level )
4340: THEN
4341: FND_LOG.STRING(l_proc_level
4342: ,G_MODULE_PREFIX||'.'||l_api_name||'.end'
4343: ,'Exit procedure');
4344: END IF; --( l_proc_level >= l_dbg_level)
4345:

Line 4352: FND_LOG.String( l_proc_level

4348: WHEN OTHERS THEN
4349: IF (l_proc_level >= l_dbg_level)
4350: THEN
4351: l_error_msg:=SQLCODE||':'||SQLERRM;
4352: FND_LOG.String( l_proc_level
4353: , G_Module_Prefix || l_api_name || '. Other_Exception '
4354: , l_error_msg);
4355:
4356:

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

4401: --
4402: -- CHANGE HISTORY:
4403: --
4404: -- 05/17/05 Donghai Wang Created.
4405: -- 03/04/05 Donghai Wang Add FND Log
4406: --
4407: --==========================================================================
4408: PROCEDURE Generate_Discrepancy_Rep
4409: ( p_org_id IN NUMBER

Line 4592: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

4588: WHERE gth.SOURCE='GT'
4589: AND gth.ra_trx_id=l_ar_trx_header_id;
4590:
4591: l_missing_artrx_rec c_missing_artrx%ROWTYPE;
4592: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4593: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4594:
4595:
4596: BEGIN

Line 4593: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

4589: AND gth.ra_trx_id=l_ar_trx_header_id;
4590:
4591: l_missing_artrx_rec c_missing_artrx%ROWTYPE;
4592: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4593: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4594:
4595:
4596: BEGIN
4597:

Line 4601: FND_LOG.string(l_proc_level

4597:
4598: --Logging for debug
4599: IF (l_proc_level>=l_dbg_level)
4600: THEN
4601: FND_LOG.string(l_proc_level
4602: ,G_MODULE_PREFIX||'.'||l_api_name||'.begin'
4603: ,'Enter procedure'
4604: );
4605: END IF; --(l_proc_level>=l_proc_level)

Line 4610: FND_LOG.STRING(l_proc_level

4606:
4607: --log for debug
4608: IF( l_proc_level >= l_dbg_level)
4609: THEN
4610: FND_LOG.STRING(l_proc_level
4611: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4612: ,'p_org_id '||p_org_id);
4613:
4614: FND_LOG.STRING(l_proc_level

Line 4614: FND_LOG.STRING(l_proc_level

4610: FND_LOG.STRING(l_proc_level
4611: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4612: ,'p_org_id '||p_org_id);
4613:
4614: FND_LOG.STRING(l_proc_level
4615: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4616: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
4617:
4618: FND_LOG.STRING(l_proc_level

Line 4618: FND_LOG.STRING(l_proc_level

4614: FND_LOG.STRING(l_proc_level
4615: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4616: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
4617:
4618: FND_LOG.STRING(l_proc_level
4619: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4620: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
4621:
4622: FND_LOG.STRING(l_proc_level

Line 4622: FND_LOG.STRING(l_proc_level

4618: FND_LOG.STRING(l_proc_level
4619: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4620: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
4621:
4622: FND_LOG.STRING(l_proc_level
4623: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4624: ,'p_ar_transaction_type '||p_ar_transaction_type);
4625:
4626: FND_LOG.STRING(l_proc_level

Line 4626: FND_LOG.STRING(l_proc_level

4622: FND_LOG.STRING(l_proc_level
4623: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4624: ,'p_ar_transaction_type '||p_ar_transaction_type);
4625:
4626: FND_LOG.STRING(l_proc_level
4627: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4628: ,'p_cust_num_from '||p_cust_num_from);
4629:
4630: FND_LOG.STRING(l_proc_level

Line 4630: FND_LOG.STRING(l_proc_level

4626: FND_LOG.STRING(l_proc_level
4627: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4628: ,'p_cust_num_from '||p_cust_num_from);
4629:
4630: FND_LOG.STRING(l_proc_level
4631: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4632: ,'p_cust_num_to '||p_cust_num_to);
4633:
4634: FND_LOG.STRING(l_proc_level

Line 4634: FND_LOG.STRING(l_proc_level

4630: FND_LOG.STRING(l_proc_level
4631: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4632: ,'p_cust_num_to '||p_cust_num_to);
4633:
4634: FND_LOG.STRING(l_proc_level
4635: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4636: ,'p_cust_name_id '||p_cust_name_id);
4637:
4638: FND_LOG.STRING(l_proc_level

Line 4638: FND_LOG.STRING(l_proc_level

4634: FND_LOG.STRING(l_proc_level
4635: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4636: ,'p_cust_name_id '||p_cust_name_id);
4637:
4638: FND_LOG.STRING(l_proc_level
4639: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4640: ,'p_gl_period '||p_gl_period);
4641:
4642: FND_LOG.STRING(l_proc_level

Line 4642: FND_LOG.STRING(l_proc_level

4638: FND_LOG.STRING(l_proc_level
4639: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4640: ,'p_gl_period '||p_gl_period);
4641:
4642: FND_LOG.STRING(l_proc_level
4643: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4644: ,'p_gl_date_from '||p_gl_date_from);
4645:
4646: FND_LOG.STRING(l_proc_level

Line 4646: FND_LOG.STRING(l_proc_level

4642: FND_LOG.STRING(l_proc_level
4643: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4644: ,'p_gl_date_from '||p_gl_date_from);
4645:
4646: FND_LOG.STRING(l_proc_level
4647: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4648: ,'p_gl_date_to '||p_gl_date_to);
4649:
4650: FND_LOG.STRING(l_proc_level

Line 4650: FND_LOG.STRING(l_proc_level

4646: FND_LOG.STRING(l_proc_level
4647: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4648: ,'p_gl_date_to '||p_gl_date_to);
4649:
4650: FND_LOG.STRING(l_proc_level
4651: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4652: ,'p_ar_trx_batch_from '||p_ar_trx_batch_from);
4653:
4654: FND_LOG.STRING(l_proc_level

Line 4654: FND_LOG.STRING(l_proc_level

4650: FND_LOG.STRING(l_proc_level
4651: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4652: ,'p_ar_trx_batch_from '||p_ar_trx_batch_from);
4653:
4654: FND_LOG.STRING(l_proc_level
4655: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4656: ,'p_ar_trx_batch_to '||p_ar_trx_batch_to);
4657:
4658: FND_LOG.STRING(l_proc_level

Line 4658: FND_LOG.STRING(l_proc_level

4654: FND_LOG.STRING(l_proc_level
4655: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4656: ,'p_ar_trx_batch_to '||p_ar_trx_batch_to);
4657:
4658: FND_LOG.STRING(l_proc_level
4659: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4660: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
4661:
4662: FND_LOG.STRING(l_proc_level

Line 4662: FND_LOG.STRING(l_proc_level

4658: FND_LOG.STRING(l_proc_level
4659: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4660: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
4661:
4662: FND_LOG.STRING(l_proc_level
4663: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4664: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
4665:
4666: FND_LOG.STRING(l_proc_level

Line 4666: FND_LOG.STRING(l_proc_level

4662: FND_LOG.STRING(l_proc_level
4663: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4664: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
4665:
4666: FND_LOG.STRING(l_proc_level
4667: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4668: ,'p_ar_trx_date_from '||p_ar_trx_date_from);
4669:
4670: FND_LOG.STRING(l_proc_level

Line 4670: FND_LOG.STRING(l_proc_level

4666: FND_LOG.STRING(l_proc_level
4667: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4668: ,'p_ar_trx_date_from '||p_ar_trx_date_from);
4669:
4670: FND_LOG.STRING(l_proc_level
4671: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4672: ,'p_ar_trx_date_to '||p_ar_trx_date_to);
4673:
4674: FND_LOG.STRING(l_proc_level

Line 4674: FND_LOG.STRING(l_proc_level

4670: FND_LOG.STRING(l_proc_level
4671: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4672: ,'p_ar_trx_date_to '||p_ar_trx_date_to);
4673:
4674: FND_LOG.STRING(l_proc_level
4675: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4676: ,'p_ar_doc_num_from '||p_ar_doc_num_from);
4677:
4678: FND_LOG.STRING(l_proc_level

Line 4678: FND_LOG.STRING(l_proc_level

4674: FND_LOG.STRING(l_proc_level
4675: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4676: ,'p_ar_doc_num_from '||p_ar_doc_num_from);
4677:
4678: FND_LOG.STRING(l_proc_level
4679: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4680: ,'p_ar_doc_num_to '||p_ar_doc_num_to);
4681:
4682: FND_LOG.STRING(l_proc_level

Line 4682: FND_LOG.STRING(l_proc_level

4678: FND_LOG.STRING(l_proc_level
4679: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4680: ,'p_ar_doc_num_to '||p_ar_doc_num_to);
4681:
4682: FND_LOG.STRING(l_proc_level
4683: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4684: ,'p_original_curr_code '||p_original_curr_code);
4685:
4686: FND_LOG.STRING(l_proc_level

Line 4686: FND_LOG.STRING(l_proc_level

4682: FND_LOG.STRING(l_proc_level
4683: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4684: ,'p_original_curr_code '||p_original_curr_code);
4685:
4686: FND_LOG.STRING(l_proc_level
4687: ,G_MODULE_PREFIX||'.'||l_api_name||'.parameters'
4688: ,'p_primary_sales '||p_primary_sales);
4689:
4690: END IF; --( l_proc_level >= l_dbg_level)

Line 4722: FND_LOG.string(l_proc_level

4718:
4719: --Logging for debug
4720: IF (l_proc_level>=l_dbg_level)
4721: THEN
4722: FND_LOG.string(l_proc_level
4723: ,G_MODULE_PREFIX||'.'||l_api_name||'.phase'
4724: ,'c_trx_header'
4725: );
4726:

Line 4727: FND_LOG.string(l_proc_level

4723: ,G_MODULE_PREFIX||'.'||l_api_name||'.phase'
4724: ,'c_trx_header'
4725: );
4726:
4727: FND_LOG.string(l_proc_level
4728: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4729: ,'l_ar_trx_header_id '||l_ar_trx_header_id
4730: );
4731:

Line 4732: FND_LOG.string(l_proc_level

4728: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4729: ,'l_ar_trx_header_id '||l_ar_trx_header_id
4730: );
4731:
4732: FND_LOG.string(l_proc_level
4733: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4734: ,'l_ar_trx_number '||l_ar_trx_number
4735: );
4736:

Line 4737: FND_LOG.string(l_proc_level

4733: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4734: ,'l_ar_trx_number '||l_ar_trx_number
4735: );
4736:
4737: FND_LOG.string(l_proc_level
4738: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4739: ,'l_ar_trx_date '||l_ar_trx_date
4740: );
4741:

Line 4743: FND_LOG.string(l_proc_level

4739: ,'l_ar_trx_date '||l_ar_trx_date
4740: );
4741:
4742:
4743: FND_LOG.string(l_proc_level
4744: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4745: ,'l_ar_customer_name '||l_ar_customer_name
4746: );
4747:

Line 4748: FND_LOG.string(l_proc_level

4744: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4745: ,'l_ar_customer_name '||l_ar_customer_name
4746: );
4747:
4748: FND_LOG.string(l_proc_level
4749: ,G_MODULE_PREFIX||'.'||l_api_name||'.variables'
4750: ,'l_ar_currency_code '||l_ar_currency_code
4751: );
4752: END IF; --(l_proc_level>=l_proc_level)

Line 4931: FND_LOG.string(l_proc_level

4927: --Logging for debug
4928:
4929: IF (l_proc_level>=l_dbg_level)
4930: THEN
4931: FND_LOG.string(l_proc_level
4932: ,G_MODULE_PREFIX||'.'||l_api_name||'.end'
4933: ,'Exit Procedure'
4934: );
4935: END IF;

Line 4941: Fnd_Log.String( l_proc_level

4937: EXCEPTION
4938: WHEN OTHERS THEN
4939: IF(l_proc_level>=l_dbg_level)
4940: THEN
4941: Fnd_Log.String( l_proc_level
4942: , G_Module_Prefix || l_api_name || '. Other_Exception '
4943: , Sqlcode||':'||Sqlerrm);
4944:
4945: END IF;