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

Line 205: G_DEBUG_LEVEL CONSTANT PLS_INTEGER:=fnd_log.LEVEL_EXCEPTION;

201: G_EXPORT_CRMEMO_DUP_ERROR CONSTANT PLS_INTEGER:=6;
202: ------------------------------------------------------------
203: --add by Lv Xiao on 9-DEC-2008, end
204:
205: G_DEBUG_LEVEL CONSTANT PLS_INTEGER:=fnd_log.LEVEL_EXCEPTION;
206:
207: G_import_error_prefix CONSTANT VARCHAR2(240):=
208: '
209:

Line 284: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

280: )
281: IS
282: BEGIN
283: --FND_FILE.Put_Line(FND_FILE.Log,p_str);
284: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
285: THEN
286: fnd_log.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT
287: ,MODULE => G_MODULE_PREFIX||'.debug'
288: ,MESSAGE => p_str);

Line 286: fnd_log.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT

282: BEGIN
283: --FND_FILE.Put_Line(FND_FILE.Log,p_str);
284: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
285: THEN
286: fnd_log.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT
287: ,MODULE => G_MODULE_PREFIX||'.debug'
288: ,MESSAGE => p_str);
289: END IF;
290: END Put_Log;

Line 356: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

352: , x_eof OUT NOCOPY BOOLEAN
353: )
354: IS
355: l_procedure_name VARCHAR2(30) :='read_GT_Line';
356: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
357: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
358:
359: BEGIN
360: --log for debug

Line 357: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

353: )
354: IS
355: l_procedure_name VARCHAR2(30) :='read_GT_Line';
356: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
357: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
358:
359: BEGIN
360: --log for debug
361: IF( l_proc_level >= l_dbg_level )

Line 363: FND_LOG.STRING(l_proc_level

359: BEGIN
360: --log for debug
361: IF( l_proc_level >= l_dbg_level )
362: THEN
363: FND_LOG.STRING(l_proc_level
364: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
365: ,'Enter procedure');
366: END IF; --( l_proc_level >= l_dbg_level )
367:

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

459: X_EOF:=TRUE;
460: EXIT;
461:
462: WHEN OTHERS THEN
463: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
464: THEN
465: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
466: , G_MODULE_PREFIX || l_procedure_name
467: || '.OTHER_EXCEPTION'

Line 465: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

461:
462: WHEN OTHERS THEN
463: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
464: THEN
465: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
466: , G_MODULE_PREFIX || l_procedure_name
467: || '.OTHER_EXCEPTION'
468: , SQLCODE||SQLERRM);
469: END IF;

Line 482: FND_LOG.STRING(l_proc_level

478:
479: --log 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: ,'Exit procedure');
485: END IF; --( l_proc_level >= l_dbg_level )
486: EXCEPTION

Line 493: FND_LOG.string( l_proc_level

489:
490: WHEN OTHERS THEN
491: IF(l_proc_level >= l_dbg_level)
492: THEN
493: FND_LOG.string( l_proc_level
494: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
495: , SQLCODE||SQLERRM);
496: END IF;
497: RAISE;

Line 594: :=FND_LOG.G_Current_Runtime_Level;

590: l_succ_XML XMLTYPE;
591: l_report_XML XMLTYPE;
592: l_date_format VARCHAR2(20);
593: l_dbg_level NUMBER
594: :=FND_LOG.G_Current_Runtime_Level;
595: l_proc_level NUMBER
596: :=FND_LOG.Level_Procedure;
597: --Add by Sabrina for ER#14830536 Start
598: l_vat_tbl vat_tbl_type;

Line 596: :=FND_LOG.Level_Procedure;

592: l_date_format VARCHAR2(20);
593: l_dbg_level NUMBER
594: :=FND_LOG.G_Current_Runtime_Level;
595: l_proc_level NUMBER
596: :=FND_LOG.Level_Procedure;
597: --Add by Sabrina for ER#14830536 Start
598: l_vat_tbl vat_tbl_type;
599: l_vat_tbl_index AR_Gta_Trx_Headers_All.Gta_Trx_Number%TYPE;
600: l_Invoice_Num_Sum AR_Gta_Trx_Headers_All.Gt_Invoice_Number%TYPE;

Line 607: FND_LOG.STRING(l_proc_level

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

Line 735: FND_LOG.string( G_DEBUG_LEVEL

731: , message => NULL);
732:
733: IF(G_DEBUG_LEVEL >= l_dbg_level)
734: THEN
735: FND_LOG.string( G_DEBUG_LEVEL
736: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
737: , 'Number of lines is not an integer'||SQLCODE||':'||SQLERRM);
738: END IF;
739:

Line 978: FND_LOG.string( G_DEBUG_LEVEL

974: l_error_msg:=fnd_message.GET;
975:
976: IF(G_DEBUG_LEVEL >= l_dbg_level)
977: THEN
978: FND_LOG.string( G_DEBUG_LEVEL
979: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
980: , 'Assign value from TXT to record:'||SQLCODE||':'||SQLERRM);
981: END IF;
982:

Line 1104: FND_LOG.string( G_DEBUG_LEVEL

1100: l_error_msg:=fnd_message.GET;
1101:
1102: IF(G_DEBUG_LEVEL >= l_dbg_level)
1103: THEN
1104: FND_LOG.string( G_DEBUG_LEVEL
1105: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
1106: , 'Update original record:'||SQLCODE||':'||SQLERRM);
1107: END IF;
1108:

Line 1170: FND_LOG.string( G_DEBUG_LEVEL

1166: l_error_msg:=fnd_message.GET;
1167:
1168: IF(G_DEBUG_LEVEL >= l_dbg_level)
1169: THEN
1170: FND_LOG.string( G_DEBUG_LEVEL
1171: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
1172: , 'Insert into base table:'||SQLCODE||':'||SQLERRM);
1173: END IF;
1174:

Line 1476: FND_LOG.STRING(l_proc_level

1472:
1473: --log for debug
1474: IF( l_proc_level >= l_dbg_level )
1475: THEN
1476: FND_LOG.STRING(l_proc_level
1477: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1478: ,'Exit procedure');
1479: END IF; --( l_proc_level >= l_dbg_level )
1480: EXCEPTION

Line 1484: FND_LOG.string( l_proc_level

1480: EXCEPTION
1481: WHEN OTHERS THEN
1482: IF(l_proc_level >= l_dbg_level)
1483: THEN
1484: FND_LOG.string( l_proc_level
1485: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
1486: , SQLCODE||SQLERRM);
1487: END IF;
1488: clear_imp_temp_table;

Line 1548: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1544: FROM AR_GTA_trx_lines
1545: WHERE GTA_trx_header_id = p_header_id
1546: AND Enabled_Flag='Y';
1547:
1548: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1549: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1550: BEGIN
1551:
1552: --log for debug

Line 1549: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1545: WHERE GTA_trx_header_id = p_header_id
1546: AND Enabled_Flag='Y';
1547:
1548: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1549: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1550: BEGIN
1551:
1552: --log for debug
1553: IF( l_proc_level >= l_dbg_level )

Line 1555: FND_LOG.STRING(l_proc_level

1551:
1552: --log for debug
1553: IF( l_proc_level >= l_dbg_level )
1554: THEN
1555: FND_LOG.STRING(l_proc_level
1556: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
1557: ,'Enter procedure');
1558: END IF; --( l_proc_level >= l_dbg_level )
1559:

Line 1736: FND_LOG.STRING(l_proc_level

1732:
1733: --log for debug
1734: IF( l_proc_level >= l_dbg_level )
1735: THEN
1736: FND_LOG.STRING(l_proc_level
1737: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1738: ,'Exit procedure');
1739: END IF; --( l_proc_level >= l_dbg_level )
1740:

Line 1746: FND_LOG.string( l_proc_level

1742:
1743: WHEN OTHERS THEN
1744: IF(l_proc_level >= l_dbg_level)
1745: THEN
1746: FND_LOG.string( l_proc_level
1747: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION'
1748: , SQLCODE||SQLERRM);
1749: END IF;
1750: RAISE;

Line 1811: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1807: l_conc_succ BOOLEAN;
1808: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
1809: i INTEGER;
1810: l_str VARCHAR2(1000); --Jun-22, 2006, jogen bug 5335265
1811: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1812: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1813: l_first_Inv BOOLEAN :=TRUE;
1814:
1815: --add by Lv Xiao on 9-Dec-2008 for bug#7626503, begin

Line 1812: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1808: l_gta_trx_header_id ar_gta_trx_headers_all.gta_trx_header_id%TYPE;
1809: i INTEGER;
1810: l_str VARCHAR2(1000); --Jun-22, 2006, jogen bug 5335265
1811: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1812: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1813: l_first_Inv BOOLEAN :=TRUE;
1814:
1815: --add by Lv Xiao on 9-Dec-2008 for bug#7626503, begin
1816: --------------------------------------------------------------------------

Line 1856: FND_LOG.STRING(l_proc_level

1852:
1853: --log for debug
1854: IF( l_proc_level >= l_dbg_level )
1855: THEN
1856: FND_LOG.STRING(l_proc_level
1857: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
1858: ,'Enter procedure');
1859: END IF; --( l_proc_level >= l_dbg_level )
1860:

Line 2307: FND_LOG.STRING(l_proc_level

2303:
2304: --log for debug
2305: IF( l_proc_level >= l_dbg_level )
2306: THEN
2307: FND_LOG.STRING(l_proc_level
2308: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
2309: ,'Exit procedure');
2310: END IF; --( l_proc_level >= l_dbg_level )
2311:

Line 2317: FND_LOG.string( l_proc_level

2313:
2314: WHEN OTHERS THEN
2315: IF(l_proc_level >= l_dbg_level)
2316: THEN
2317: FND_LOG.string( l_proc_level
2318: , G_MODULE_PREFIX || l_procedure_name ||'.OTHER_EXCEPTION '
2319: , SQLCODE||SQLERRM);
2320: END IF;
2321: RAISE;

Line 2360: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

2356: l_procedure_name VARCHAR2(30):='check_batch_number';
2357: l_batch_numbering_flag VARCHAR2(1);
2358: l_error_msg VARCHAR2(1000);
2359: l_rows_same_batch NUMBER;
2360: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2361: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2362:
2363: BEGIN
2364: --log for debug

Line 2361: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

2357: l_batch_numbering_flag VARCHAR2(1);
2358: l_error_msg VARCHAR2(1000);
2359: l_rows_same_batch NUMBER;
2360: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2361: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2362:
2363: BEGIN
2364: --log for debug
2365: IF( l_proc_level >= l_dbg_level )

Line 2367: FND_LOG.STRING(l_proc_level

2363: BEGIN
2364: --log for debug
2365: IF( l_proc_level >= l_dbg_level )
2366: THEN
2367: FND_LOG.STRING(l_proc_level
2368: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
2369: ,'Enter procedure');
2370: END IF; --( l_proc_level >= l_dbg_level )
2371:

Line 2433: FND_LOG.STRING(l_proc_level

2429:
2430: --log for debug
2431: IF( l_proc_level >= l_dbg_level )
2432: THEN
2433: FND_LOG.STRING(l_proc_level
2434: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
2435: ,'Exit procedure');
2436: END IF; --( l_proc_level >= l_dbg_level )
2437:

Line 2535: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

2531: l_error_msg VARCHAR2(1000);
2532:
2533: l_batch_number AR_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=p_batch_number;
2534: l_batch_number_ok BOOLEAN;
2535: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2536: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2537: l_invoice_type_check VARCHAR2(1); --added for invoice_type condition by Subba.
2538: BEGIN
2539:

Line 2536: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

2532:
2533: l_batch_number AR_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=p_batch_number;
2534: l_batch_number_ok BOOLEAN;
2535: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2536: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2537: l_invoice_type_check VARCHAR2(1); --added for invoice_type condition by Subba.
2538: BEGIN
2539:
2540: --log for debug

Line 2543: FND_LOG.STRING(l_proc_level

2539:
2540: --log for debug
2541: IF( l_proc_level >= l_dbg_level )
2542: THEN
2543: FND_LOG.STRING(l_proc_level
2544: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
2545: ,'Enter procedure');
2546: END IF; --( l_proc_level >= l_dbg_level )
2547:

Line 2949: FND_LOG.STRING(l_proc_level

2945:
2946: --log for debug
2947: IF( l_proc_level >= l_dbg_level )
2948: THEN
2949: FND_LOG.STRING(l_proc_level
2950: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
2951: ,'Exit procedure');
2952: END IF; --( l_proc_level >= l_dbg_level )
2953:

Line 2959: FND_LOG.string( l_proc_level

2955:
2956: WHEN OTHERS THEN
2957: IF(l_proc_level >= l_dbg_level)
2958: THEN
2959: FND_LOG.string( l_proc_level
2960: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION'
2961: , SQLCODE||SQLERRM);
2962: END IF;
2963: RAISE;

Line 3011: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3007: --add by Lv Xiao for bug#7626503 on 11-Dec-2008, end
3008:
3009: l_batch_number AR_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=P_Batch_ID;
3010: l_batch_number_ok BOOLEAN;
3011: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3012: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3013: BEGIN
3014:
3015: --log for debug

Line 3012: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3008:
3009: l_batch_number AR_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=P_Batch_ID;
3010: l_batch_number_ok BOOLEAN;
3011: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3012: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3013: BEGIN
3014:
3015: --log for debug
3016: IF( l_proc_level >= l_dbg_level )

Line 3018: FND_LOG.STRING(l_proc_level

3014:
3015: --log for debug
3016: IF( l_proc_level >= l_dbg_level )
3017: THEN
3018: FND_LOG.STRING(l_proc_level
3019: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
3020: ,'Enter procedure');
3021: END IF; --( l_proc_level >= l_dbg_level )
3022:

Line 3138: FND_LOG.STRING(l_proc_level

3134:
3135: --log for debug
3136: IF( l_proc_level >= l_dbg_level )
3137: THEN
3138: FND_LOG.STRING(l_proc_level
3139: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
3140: ,'Exit procedure');
3141: END IF; --( l_proc_level >= l_dbg_level )
3142:

Line 3149: FND_LOG.string( l_proc_level

3145:
3146: WHEN OTHERS THEN
3147: IF(l_proc_level >= l_dbg_level)
3148: THEN
3149: FND_LOG.string( l_proc_level
3150: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
3151: , SQLCODE||SQLERRM);
3152: END IF;
3153:

Line 3189: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3185:
3186: lv_class_type VARCHAR2(30);
3187:
3188: l_procedure_name VARCHAR2(50) :='Get_Trx_Class';
3189: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3190: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3191:
3192:
3193: BEGIN

Line 3190: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3186: lv_class_type VARCHAR2(30);
3187:
3188: l_procedure_name VARCHAR2(50) :='Get_Trx_Class';
3189: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3190: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3191:
3192:
3193: BEGIN
3194:

Line 3198: FND_LOG.STRING(l_proc_level

3194:
3195: --log for debug
3196: IF( l_proc_level >= l_dbg_level )
3197: THEN
3198: FND_LOG.STRING(l_proc_level
3199: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
3200: ,'Enter procedure');
3201: END IF; --( l_proc_level >= l_dbg_level )
3202:

Line 3216: FND_LOG.STRING(l_proc_level

3212: AND JGTH.ra_trx_id = p_GTA_trx_id;
3213: --log for debug
3214: IF( l_proc_level >= l_dbg_level )
3215: THEN
3216: FND_LOG.STRING(l_proc_level
3217: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
3218: ,'Exit procedure');
3219: END IF; --( l_proc_level >= l_dbg_level )
3220:

Line 3262: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3258:
3259: l_cm_delimiter2 VARCHAR2(100);
3260:
3261: l_procedure_name VARCHAR2(50) :='Check_Header';
3262: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3263: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3264: l_trx_class VARCHAR2(20); --added by yao Zhang for bug 7670310
3265: BEGIN
3266:

Line 3263: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3259: l_cm_delimiter2 VARCHAR2(100);
3260:
3261: l_procedure_name VARCHAR2(50) :='Check_Header';
3262: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3263: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3264: l_trx_class VARCHAR2(20); --added by yao Zhang for bug 7670310
3265: BEGIN
3266:
3267: --log for debug

Line 3270: FND_LOG.STRING(l_proc_level

3266:
3267: --log for debug
3268: IF( l_proc_level >= l_dbg_level )
3269: THEN
3270: FND_LOG.STRING(l_proc_level
3271: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
3272: ,'Enter procedure');
3273: END IF; --( l_proc_level >= l_dbg_level )
3274:

Line 3366: FND_LOG.STRING(l_proc_level

3362:
3363: --log for debug
3364: IF( l_proc_level >= l_dbg_level )
3365: THEN
3366: FND_LOG.STRING(l_proc_level
3367: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
3368: ,'Exit procedure');
3369: END IF; --( l_proc_level >= l_dbg_level )
3370:

Line 3413: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3409: l_len_before_dot_tax NUMBER :=0;
3410: l_len_after_dot_tax NUMBER :=0;
3411: l_pos NUMBER :=0;
3412: l_procedure_name VARCHAR2(50) :='Check_Line_Length';
3413: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3414: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3415:
3416: BEGIN
3417:

Line 3414: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3410: l_len_after_dot_tax NUMBER :=0;
3411: l_pos NUMBER :=0;
3412: l_procedure_name VARCHAR2(50) :='Check_Line_Length';
3413: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3414: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3415:
3416: BEGIN
3417:
3418: --log for debug

Line 3421: FND_LOG.STRING(l_proc_level

3417:
3418: --log for debug
3419: IF( l_proc_level >= l_dbg_level )
3420: THEN
3421: FND_LOG.STRING(l_proc_level
3422: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
3423: ,'Enter procedure');
3424: END IF; --( l_proc_level >= l_dbg_level )
3425:

Line 3485: FND_LOG.STRING(l_proc_level

3481:
3482: --log for debug
3483: IF( l_proc_level >= l_dbg_level )
3484: THEN
3485: FND_LOG.STRING(l_proc_level
3486: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
3487: ,'Exit procedure');
3488: END IF; --( l_proc_level >= l_dbg_level )
3489:

Line 3612: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3608: l_ar_gta_gta_not_enabled VARCHAR2(2000);
3609: l_count NUMBER;
3610: l_conc_succ BOOLEAN; -- the status of concurrent
3611:
3612: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3613: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3614:
3615: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
3616: --Yao Zhang fix bug 7670710 add begin

Line 3613: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3609: l_count NUMBER;
3610: l_conc_succ BOOLEAN; -- the status of concurrent
3611:
3612: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3613: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3614:
3615: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
3616: --Yao Zhang fix bug 7670710 add begin
3617: l_bank_name HZ_PARTIES.party_name%TYPE;

Line 3747: fnd_log.STRING(l_proc_level

3743: -- add the chinese token
3744:
3745: IF(l_proc_level >= l_dbg_level)
3746: THEN
3747: fnd_log.STRING(l_proc_level
3748: , G_MODULE_PREFIX||l_procedure_name
3749: , ' Procedure begin . ');
3750: END IF;
3751:

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

3755: fnd_message.set_name('AR', 'AR_GTA_BANKACCOUNT_MASKING');
3756:
3757: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
3758:
3759: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3760: THEN
3761: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
3762: , G_MODULE_PREFIX||l_procedure_name
3763: , l_error_string);

Line 3761: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

3757: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
3758:
3759: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3760: THEN
3761: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
3762: , G_MODULE_PREFIX||l_procedure_name
3763: , l_error_string);
3764: END IF;
3765: --set concurrent status to Warning

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

3921: AND addr.cust_account_id = l_customer_id;
3922:
3923: EXCEPTION
3924: WHEN NO_DATA_FOUND THEN
3925: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3926: THEN
3927: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
3928: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3929: ,'Customer'|| l_customer_name || 'has no primary bill to address');

Line 3927: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION

3923: EXCEPTION
3924: WHEN NO_DATA_FOUND THEN
3925: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3926: THEN
3927: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
3928: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3929: ,'Customer'|| l_customer_name || 'has no primary bill to address');
3930: END IF;
3931: END;

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

3946: AND contact_point_type = 'PHONE';
3947:
3948: EXCEPTION
3949: WHEN NO_DATA_FOUND THEN
3950: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3951: THEN
3952: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
3953: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3954: ,'Customer'|| l_customer_name || 'has no primary phone number'||SQLCODE||SQLERRM);

Line 3952: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION

3948: EXCEPTION
3949: WHEN NO_DATA_FOUND THEN
3950: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3951: THEN
3952: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
3953: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3954: ,'Customer'|| l_customer_name || 'has no primary phone number'||SQLCODE||SQLERRM);
3955: END IF;
3956: END;

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

3967: AND SITE.SITE_USE_CODE = 'BILL_TO'
3968: AND SITE.STATUS = 'A';
3969: EXCEPTION
3970: WHEN OTHERS THEN
3971: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3972: THEN
3973: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3974: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3975: , l_err_text||SQLCODE ||SQLERRM);

Line 3973: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3969: EXCEPTION
3970: WHEN OTHERS THEN
3971: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3972: THEN
3973: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3974: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3975: , l_err_text||SQLCODE ||SQLERRM);
3976: END IF;
3977: END;

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

3990: org_id = p_org_id;
3991:
3992: EXCEPTION
3993: WHEN OTHERS THEN
3994: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3995: THEN
3996: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3997: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3998: , l_err_text||SQLCODE ||SQLERRM);

Line 3996: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3992: EXCEPTION
3993: WHEN OTHERS THEN
3994: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3995: THEN
3996: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3997: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3998: , l_err_text||SQLCODE ||SQLERRM);
3999: END IF;
4000: END;

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

4015: AND payment_function = 'CUSTOMER_PAYMENT'; -- function
4016:
4017: EXCEPTION
4018: WHEN OTHERS THEN
4019: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4020: THEN
4021: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4022: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
4023: , l_err_text||SQLCODE ||SQLERRM);

Line 4021: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

4017: EXCEPTION
4018: WHEN OTHERS THEN
4019: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4020: THEN
4021: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4022: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
4023: , l_err_text||SQLCODE ||SQLERRM);
4024: END IF;
4025: END;

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

4107: -------------------------------------------------------------------------------------------
4108:
4109: EXCEPTION
4110: WHEN OTHERS THEN
4111: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4112: THEN
4113: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4114: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
4115: , l_err_text||SQLCODE ||SQLERRM);

Line 4113: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

4109: EXCEPTION
4110: WHEN OTHERS THEN
4111: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4112: THEN
4113: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4114: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
4115: , l_err_text||SQLCODE ||SQLERRM);
4116: END IF;
4117: END;

Line 4335: fnd_log.STRING(l_proc_level

4331:
4332:
4333: IF(l_proc_level >= l_dbg_level)
4334: THEN
4335: fnd_log.STRING(l_proc_level
4336: , G_MODULE_PREFIX||l_procedure_name
4337: , ' Procedure End . ');
4338: END IF;
4339:

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

4338: END IF;
4339:
4340: EXCEPTION
4341: WHEN OTHERS THEN
4342: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4343: THEN
4344: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4345: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
4346: , SQLCODE||':'||SQLERRM);

Line 4344: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

4340: EXCEPTION
4341: WHEN OTHERS THEN
4342: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4343: THEN
4344: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
4345: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
4346: , SQLCODE||':'||SQLERRM);
4347: END IF;
4348: RAISE;

Line 4378: -- 06-MAR-2006 Donghai Wang Add fnd log

4374: --
4375: -- CHANGE HISTORY:
4376: --
4377: -- 17-MAY-2005 Donghai Wang Creation
4378: -- 06-MAR-2006 Donghai Wang Add fnd log
4379: -- 06-APR-2006 Donghai Wang Remove the parameter p_tax_rate to
4380: -- fix bug 5138356 due to no longer
4381: -- export tax rate by items
4382: --===========================================================================

Line 4411: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

4407: l_tax_rate_length_before_dot NUMBER;
4408: l_tax_rate_length_after_dot NUMBER;
4409: l_item_model_length NUMBER;
4410: l_uom_length NUMBER;
4411: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4412: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4413: l_procedure_name VARCHAR2(100) :='Check_Item_Length';
4414: l_dbg_msg VARCHAR2(1000);
4415: BEGIN

Line 4412: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

4408: l_tax_rate_length_after_dot NUMBER;
4409: l_item_model_length NUMBER;
4410: l_uom_length NUMBER;
4411: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4412: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4413: l_procedure_name VARCHAR2(100) :='Check_Item_Length';
4414: l_dbg_msg VARCHAR2(1000);
4415: BEGIN
4416:

Line 4420: FND_LOG.STRING(l_proc_level

4416:
4417: --log for debug
4418: IF( l_proc_level >= l_dbg_level )
4419: THEN
4420: FND_LOG.STRING(l_proc_level
4421: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
4422: ,'Enter function');
4423:
4424: FND_LOG.STRING(l_proc_level

Line 4424: FND_LOG.STRING(l_proc_level

4420: FND_LOG.STRING(l_proc_level
4421: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
4422: ,'Enter function');
4423:
4424: FND_LOG.STRING(l_proc_level
4425: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4426: ,'p_item_number '||p_item_number);
4427:
4428: FND_LOG.STRING(l_proc_level

Line 4428: FND_LOG.STRING(l_proc_level

4424: FND_LOG.STRING(l_proc_level
4425: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4426: ,'p_item_number '||p_item_number);
4427:
4428: FND_LOG.STRING(l_proc_level
4429: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4430: ,'p_item_name '||p_item_name);
4431:
4432: FND_LOG.STRING(l_proc_level

Line 4432: FND_LOG.STRING(l_proc_level

4428: FND_LOG.STRING(l_proc_level
4429: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4430: ,'p_item_name '||p_item_name);
4431:
4432: FND_LOG.STRING(l_proc_level
4433: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4434: ,'p_tax_name '||p_tax_name);
4435:
4436:

Line 4437: FND_LOG.STRING(l_proc_level

4433: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4434: ,'p_tax_name '||p_tax_name);
4435:
4436:
4437: FND_LOG.STRING(l_proc_level
4438: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4439: ,'p_item_model '||p_item_model);
4440:
4441: FND_LOG.STRING(l_proc_level

Line 4441: FND_LOG.STRING(l_proc_level

4437: FND_LOG.STRING(l_proc_level
4438: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4439: ,'p_item_model '||p_item_model);
4440:
4441: FND_LOG.STRING(l_proc_level
4442: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4443: ,'p_uom '||p_uom);
4444: END IF; --( l_proc_level >= l_dbg_level )
4445:

Line 4471: FND_LOG.STRING(l_proc_level

4467:
4468: --log for debug
4469: IF( l_proc_level >= l_dbg_level )
4470: THEN
4471: FND_LOG.STRING(l_proc_level
4472: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
4473: ,'Exit function');
4474: END IF; --( l_proc_level >= l_dbg_level )
4475:

Line 4480: FND_LOG.string( l_proc_level

4476: EXCEPTION
4477: WHEN OTHERS THEN
4478: IF(l_proc_level >= l_dbg_level)
4479: THEN
4480: FND_LOG.string( l_proc_level
4481: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
4482: , SQLCODE||':'||SQLERRM);
4483: END IF;--(l_proc_level >= l_dbg_level)
4484: END Check_Item_Length;

Line 4535: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

4531: l_export_item AR_GTA_TXT_OPERATOR_PROC.G_Item_Tbl :=p_export_item;
4532: l_item_length_exp AR_GTA_TXT_OPERATOR_PROC.G_Item_Tbl :=p_item_length_exp;
4533: l_idx NUMBER;
4534: l_export_record VARCHAR2(4000);
4535: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4536: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4537: l_procedure_name VARCHAR2(100) :='Export_To_Flat_file';
4538: l_dbg_msg VARCHAR2(1000);
4539: BEGIN

Line 4536: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

4532: l_item_length_exp AR_GTA_TXT_OPERATOR_PROC.G_Item_Tbl :=p_item_length_exp;
4533: l_idx NUMBER;
4534: l_export_record VARCHAR2(4000);
4535: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4536: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4537: l_procedure_name VARCHAR2(100) :='Export_To_Flat_file';
4538: l_dbg_msg VARCHAR2(1000);
4539: BEGIN
4540:

Line 4544: FND_LOG.STRING(l_proc_level

4540:
4541: --log for debug
4542: IF( l_proc_level >= l_dbg_level )
4543: THEN
4544: FND_LOG.STRING(l_proc_level
4545: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
4546: ,'Enter procedure');
4547: END IF; --( l_proc_level >= l_dbg_level )
4548:

Line 4676: FND_LOG.STRING(l_proc_level

4672:
4673: --log for debug
4674: IF( l_proc_level >= l_dbg_level )
4675: THEN
4676: FND_LOG.STRING(l_proc_level
4677: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
4678: ,'Exit procedure');
4679: END IF; --( l_proc_level >= l_dbg_level )
4680:

Line 4685: FND_LOG.string( l_proc_level

4681: EXCEPTION
4682: WHEN OTHERS THEN
4683: IF(l_proc_level >= l_dbg_level)
4684: THEN
4685: FND_LOG.string( l_proc_level
4686: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
4687: , SQLCODE||':'||SQLERRM);
4688: END IF;--(l_proc_level >= l_dbg_level)
4689:

Line 4733: -- 06-MAR-2006 Donghai Wang Add fnd log

4729: --
4730: -- CHANGE HISTORY:
4731: --
4732: -- 17-MAY-2005 Donghai Wang Creation
4733: -- 06-MAR-2006 Donghai Wang Add fnd log
4734: -- 06-Apr-2006 Donghai Wang Remove tax rate from the procedure
4735: -- for fix bug 5138356
4736: -- 18-Mar-2009 Yao Zhang modified for bug 7812065
4737: -- 19-Mar-2009 Yao Zhang modified for bug 8339490

Line 5000: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

4996:
4997: l_export_item g_item_tbl;
4998: l_export_item_idx NUMBER;
4999: l_procedure_name VARCHAR2(50) :='Export_Items';
5000: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
5001: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
5002: l_nodatafound_msg VARCHAR2(1000);
5003:
5004: BEGIN

Line 5001: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

4997: l_export_item g_item_tbl;
4998: l_export_item_idx NUMBER;
4999: l_procedure_name VARCHAR2(50) :='Export_Items';
5000: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
5001: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
5002: l_nodatafound_msg VARCHAR2(1000);
5003:
5004: BEGIN
5005:

Line 5010: FND_LOG.STRING(l_proc_level

5006: --log for debug
5007:
5008: IF( l_proc_level >= l_dbg_level )
5009: THEN
5010: FND_LOG.STRING(l_proc_level
5011: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
5012: ,'Enter procedure');
5013:
5014: FND_LOG.STRING(l_proc_level

Line 5014: FND_LOG.STRING(l_proc_level

5010: FND_LOG.STRING(l_proc_level
5011: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
5012: ,'Enter procedure');
5013:
5014: FND_LOG.STRING(l_proc_level
5015: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5016: ,'p_org_id '||p_org_id);
5017:
5018: FND_LOG.STRING(l_proc_level

Line 5018: FND_LOG.STRING(l_proc_level

5014: FND_LOG.STRING(l_proc_level
5015: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5016: ,'p_org_id '||p_org_id);
5017:
5018: FND_LOG.STRING(l_proc_level
5019: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5020: ,'p_master_org_id '||p_master_org_id);
5021:
5022: FND_LOG.STRING(l_proc_level

Line 5022: FND_LOG.STRING(l_proc_level

5018: FND_LOG.STRING(l_proc_level
5019: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5020: ,'p_master_org_id '||p_master_org_id);
5021:
5022: FND_LOG.STRING(l_proc_level
5023: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5024: ,'p_item_num_from '||p_item_num_from);
5025:
5026: FND_LOG.STRING(l_proc_level

Line 5026: FND_LOG.STRING(l_proc_level

5022: FND_LOG.STRING(l_proc_level
5023: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5024: ,'p_item_num_from '||p_item_num_from);
5025:
5026: FND_LOG.STRING(l_proc_level
5027: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5028: ,'p_item_num_to '||p_item_num_to);
5029:
5030: FND_LOG.STRING(l_proc_level

Line 5030: FND_LOG.STRING(l_proc_level

5026: FND_LOG.STRING(l_proc_level
5027: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5028: ,'p_item_num_to '||p_item_num_to);
5029:
5030: FND_LOG.STRING(l_proc_level
5031: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5032: ,'p_category_set_id '||p_category_set_id);
5033:
5034: FND_LOG.STRING(l_proc_level

Line 5034: FND_LOG.STRING(l_proc_level

5030: FND_LOG.STRING(l_proc_level
5031: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5032: ,'p_category_set_id '||p_category_set_id);
5033:
5034: FND_LOG.STRING(l_proc_level
5035: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5036: ,'p_category_structure_id '||p_category_structure_id);
5037:
5038: FND_LOG.STRING(l_proc_level

Line 5038: FND_LOG.STRING(l_proc_level

5034: FND_LOG.STRING(l_proc_level
5035: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5036: ,'p_category_structure_id '||p_category_structure_id);
5037:
5038: FND_LOG.STRING(l_proc_level
5039: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5040: ,'p_item_category_from '||p_item_category_from);
5041:
5042: FND_LOG.STRING(l_proc_level

Line 5042: FND_LOG.STRING(l_proc_level

5038: FND_LOG.STRING(l_proc_level
5039: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5040: ,'p_item_category_from '||p_item_category_from);
5041:
5042: FND_LOG.STRING(l_proc_level
5043: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5044: ,'p_item_category_to '||p_item_category_to);
5045:
5046: FND_LOG.STRING(l_proc_level

Line 5046: FND_LOG.STRING(l_proc_level

5042: FND_LOG.STRING(l_proc_level
5043: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5044: ,'p_item_category_to '||p_item_category_to);
5045:
5046: FND_LOG.STRING(l_proc_level
5047: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5048: ,'p_item_name_source '||p_item_name_source);
5049:
5050: FND_LOG.STRING(l_proc_level

Line 5050: FND_LOG.STRING(l_proc_level

5046: FND_LOG.STRING(l_proc_level
5047: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5048: ,'p_item_name_source '||p_item_name_source);
5049:
5050: FND_LOG.STRING(l_proc_level
5051: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5052: ,'p_cross_reference_type '||p_cross_reference_type);
5053:
5054: FND_LOG.STRING(l_proc_level

Line 5054: FND_LOG.STRING(l_proc_level

5050: FND_LOG.STRING(l_proc_level
5051: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5052: ,'p_cross_reference_type '||p_cross_reference_type);
5053:
5054: FND_LOG.STRING(l_proc_level
5055: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5056: ,'p_item_status '||p_item_status);
5057:
5058: FND_LOG.STRING(l_proc_level

Line 5058: FND_LOG.STRING(l_proc_level

5054: FND_LOG.STRING(l_proc_level
5055: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5056: ,'p_item_status '||p_item_status);
5057:
5058: FND_LOG.STRING(l_proc_level
5059: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5060: ,'p_creation_date_from '||p_creation_date_from);
5061:
5062: FND_LOG.STRING(l_proc_level

Line 5062: FND_LOG.STRING(l_proc_level

5058: FND_LOG.STRING(l_proc_level
5059: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5060: ,'p_creation_date_from '||p_creation_date_from);
5061:
5062: FND_LOG.STRING(l_proc_level
5063: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
5064: ,'p_creation_date_to '||p_creation_date_to);
5065: END IF; --( l_proc_level >= l_dbg_level )
5066:

Line 5190: FND_LOG.String(l_proc_level

5186: );
5187: END IF; --l_export_item_count=0
5188: IF( l_proc_level >= l_dbg_level )
5189: THEN
5190: FND_LOG.String(l_proc_level
5191: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
5192: ,'Exit procedure');
5193: END IF; --( l_proc_level >= l_dbg_level )
5194:

Line 5199: FND_LOG.string( l_proc_level

5195: EXCEPTION
5196: WHEN OTHERS THEN
5197: IF(l_proc_level >= l_dbg_level)
5198: THEN
5199: FND_LOG.string( l_proc_level
5200: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
5201: , SQLCODE||':'||SQLERRM);
5202: END IF;--(l_proc_level >= l_dbg_level)
5203: END Export_items;