eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on FND_LOG

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

167: G_EXPORT_CRMEMO_DUP_ERROR CONSTANT PLS_INTEGER:=6;
168: ------------------------------------------------------------
169: --add by Lv Xiao on 9-DEC-2008, end
170:
171: G_DEBUG_LEVEL CONSTANT PLS_INTEGER:=fnd_log.LEVEL_EXCEPTION;
172:
173: G_import_error_prefix CONSTANT VARCHAR2(240):=
174: '
175:

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

246: )
247: IS
248: BEGIN
249: --FND_FILE.Put_Line(FND_FILE.Log,p_str);
250: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
251: THEN
252: fnd_log.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT
253: ,MODULE => G_MODULE_PREFIX||'.debug'
254: ,MESSAGE => p_str);

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

248: BEGIN
249: --FND_FILE.Put_Line(FND_FILE.Log,p_str);
250: IF(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
251: THEN
252: fnd_log.STRING(LOG_LEVEL => fnd_log.LEVEL_STATEMENT
253: ,MODULE => G_MODULE_PREFIX||'.debug'
254: ,MESSAGE => p_str);
255: END IF;
256: END Put_Log;

Line 322: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

318: , x_eof OUT NOCOPY BOOLEAN
319: )
320: IS
321: l_procedure_name VARCHAR2(30) :='read_GT_Line';
322: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
323: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
324:
325: BEGIN
326: --log for debug

Line 323: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

319: )
320: IS
321: l_procedure_name VARCHAR2(30) :='read_GT_Line';
322: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
323: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
324:
325: BEGIN
326: --log for debug
327: IF( l_proc_level >= l_dbg_level )

Line 329: FND_LOG.STRING(l_proc_level

325: BEGIN
326: --log for debug
327: IF( l_proc_level >= l_dbg_level )
328: THEN
329: FND_LOG.STRING(l_proc_level
330: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
331: ,'Enter procedure');
332: END IF; --( l_proc_level >= l_dbg_level )
333:

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

425: X_EOF:=TRUE;
426: EXIT;
427:
428: WHEN OTHERS THEN
429: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
430: THEN
431: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
432: , G_MODULE_PREFIX || l_procedure_name
433: || '.OTHER_EXCEPTION'

Line 431: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

427:
428: WHEN OTHERS THEN
429: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
430: THEN
431: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
432: , G_MODULE_PREFIX || l_procedure_name
433: || '.OTHER_EXCEPTION'
434: , SQLCODE||SQLERRM);
435: END IF;

Line 448: FND_LOG.STRING(l_proc_level

444:
445: --log for debug
446: IF( l_proc_level >= l_dbg_level )
447: THEN
448: FND_LOG.STRING(l_proc_level
449: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.End'
450: ,'Exit procedure');
451: END IF; --( l_proc_level >= l_dbg_level )
452: EXCEPTION

Line 459: FND_LOG.string( l_proc_level

455:
456: WHEN OTHERS THEN
457: IF(l_proc_level >= l_dbg_level)
458: THEN
459: FND_LOG.string( l_proc_level
460: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
461: , SQLCODE||SQLERRM);
462: END IF;
463: RAISE;

Line 555: :=FND_LOG.G_Current_Runtime_Level;

551: l_succ_XML XMLTYPE;
552: l_report_XML XMLTYPE;
553: l_date_format VARCHAR2(20);
554: l_dbg_level NUMBER
555: :=FND_LOG.G_Current_Runtime_Level;
556: l_proc_level NUMBER
557: :=FND_LOG.Level_Procedure;
558:
559: BEGIN

Line 557: :=FND_LOG.Level_Procedure;

553: l_date_format VARCHAR2(20);
554: l_dbg_level NUMBER
555: :=FND_LOG.G_Current_Runtime_Level;
556: l_proc_level NUMBER
557: :=FND_LOG.Level_Procedure;
558:
559: BEGIN
560: --log for debug
561: IF( l_proc_level >= l_dbg_level )

Line 563: FND_LOG.STRING(l_proc_level

559: BEGIN
560: --log for debug
561: IF( l_proc_level >= l_dbg_level )
562: THEN
563: FND_LOG.STRING(l_proc_level
564: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
565: ,'Enter procedure');
566: END IF; --( l_proc_level >= l_dbg_level )
567:

Line 688: FND_LOG.string( G_DEBUG_LEVEL

684: , message => NULL);
685:
686: IF(G_DEBUG_LEVEL >= l_dbg_level)
687: THEN
688: FND_LOG.string( G_DEBUG_LEVEL
689: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
690: , 'Number of lines is not an integer'||SQLCODE||':'||SQLERRM);
691: END IF;
692:

Line 869: FND_LOG.string( G_DEBUG_LEVEL

865: l_error_msg:=fnd_message.GET;
866:
867: IF(G_DEBUG_LEVEL >= l_dbg_level)
868: THEN
869: FND_LOG.string( G_DEBUG_LEVEL
870: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
871: , 'Assign value from TXT to record:'||SQLCODE||':'||SQLERRM);
872: END IF;
873:

Line 995: FND_LOG.string( G_DEBUG_LEVEL

991: l_error_msg:=fnd_message.GET;
992:
993: IF(G_DEBUG_LEVEL >= l_dbg_level)
994: THEN
995: FND_LOG.string( G_DEBUG_LEVEL
996: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
997: , 'Update original record:'||SQLCODE||':'||SQLERRM);
998: END IF;
999:

Line 1061: FND_LOG.string( G_DEBUG_LEVEL

1057: l_error_msg:=fnd_message.GET;
1058:
1059: IF(G_DEBUG_LEVEL >= l_dbg_level)
1060: THEN
1061: FND_LOG.string( G_DEBUG_LEVEL
1062: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
1063: , 'Insert into base table:'||SQLCODE||':'||SQLERRM);
1064: END IF;
1065:

Line 1314: FND_LOG.STRING(l_proc_level

1310:
1311: --log for debug
1312: IF( l_proc_level >= l_dbg_level )
1313: THEN
1314: FND_LOG.STRING(l_proc_level
1315: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1316: ,'Exit procedure');
1317: END IF; --( l_proc_level >= l_dbg_level )
1318: EXCEPTION

Line 1322: FND_LOG.string( l_proc_level

1318: EXCEPTION
1319: WHEN OTHERS THEN
1320: IF(l_proc_level >= l_dbg_level)
1321: THEN
1322: FND_LOG.string( l_proc_level
1323: , G_MODULE_PREFIX || l_procedure_name||'.OTHER_EXCEPTION'
1324: , SQLCODE||SQLERRM);
1325: END IF;
1326: clear_imp_temp_table;

Line 1384: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1380: FROM JMF_GTA_trx_lines
1381: WHERE GTA_trx_header_id = p_header_id
1382: AND Enabled_Flag='Y';
1383:
1384: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1385: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1386: BEGIN
1387:
1388: --log for debug

Line 1385: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1381: WHERE GTA_trx_header_id = p_header_id
1382: AND Enabled_Flag='Y';
1383:
1384: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1385: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1386: BEGIN
1387:
1388: --log for debug
1389: IF( l_proc_level >= l_dbg_level )

Line 1391: FND_LOG.STRING(l_proc_level

1387:
1388: --log for debug
1389: IF( l_proc_level >= l_dbg_level )
1390: THEN
1391: FND_LOG.STRING(l_proc_level
1392: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
1393: ,'Enter procedure');
1394: END IF; --( l_proc_level >= l_dbg_level )
1395:

Line 1553: FND_LOG.STRING(l_proc_level

1549:
1550: --log for debug
1551: IF( l_proc_level >= l_dbg_level )
1552: THEN
1553: FND_LOG.STRING(l_proc_level
1554: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1555: ,'Exit procedure');
1556: END IF; --( l_proc_level >= l_dbg_level )
1557:

Line 1563: FND_LOG.string( l_proc_level

1559:
1560: WHEN OTHERS THEN
1561: IF(l_proc_level >= l_dbg_level)
1562: THEN
1563: FND_LOG.string( l_proc_level
1564: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION'
1565: , SQLCODE||SQLERRM);
1566: END IF;
1567: RAISE;

Line 1626: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1622: l_conc_succ BOOLEAN;
1623: l_gta_trx_header_id jmf_gta_trx_headers_all.gta_trx_header_id%TYPE;
1624: i INTEGER;
1625: l_str VARCHAR2(1000); --Jun-22, 2006, jogen bug 5335265
1626: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1627: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1628: l_first_Inv BOOLEAN :=TRUE;
1629:
1630: --add by Lv Xiao on 9-Dec-2008 for bug#7626503, begin

Line 1627: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1623: l_gta_trx_header_id jmf_gta_trx_headers_all.gta_trx_header_id%TYPE;
1624: i INTEGER;
1625: l_str VARCHAR2(1000); --Jun-22, 2006, jogen bug 5335265
1626: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1627: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1628: l_first_Inv BOOLEAN :=TRUE;
1629:
1630: --add by Lv Xiao on 9-Dec-2008 for bug#7626503, begin
1631: --------------------------------------------------------------------------

Line 1671: FND_LOG.STRING(l_proc_level

1667:
1668: --log for debug
1669: IF( l_proc_level >= l_dbg_level )
1670: THEN
1671: FND_LOG.STRING(l_proc_level
1672: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
1673: ,'Enter procedure');
1674: END IF; --( l_proc_level >= l_dbg_level )
1675:

Line 2085: FND_LOG.STRING(l_proc_level

2081:
2082: --log for debug
2083: IF( l_proc_level >= l_dbg_level )
2084: THEN
2085: FND_LOG.STRING(l_proc_level
2086: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
2087: ,'Exit procedure');
2088: END IF; --( l_proc_level >= l_dbg_level )
2089:

Line 2095: FND_LOG.string( l_proc_level

2091:
2092: WHEN OTHERS THEN
2093: IF(l_proc_level >= l_dbg_level)
2094: THEN
2095: FND_LOG.string( l_proc_level
2096: , G_MODULE_PREFIX || l_procedure_name ||'.OTHER_EXCEPTION '
2097: , SQLCODE||SQLERRM);
2098: END IF;
2099: RAISE;

Line 2138: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

2134: l_procedure_name VARCHAR2(30):='check_batch_number';
2135: l_batch_numbering_flag VARCHAR2(1);
2136: l_error_msg VARCHAR2(1000);
2137: l_rows_same_batch NUMBER;
2138: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2139: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2140:
2141: BEGIN
2142: --log for debug

Line 2139: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

2135: l_batch_numbering_flag VARCHAR2(1);
2136: l_error_msg VARCHAR2(1000);
2137: l_rows_same_batch NUMBER;
2138: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2139: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2140:
2141: BEGIN
2142: --log for debug
2143: IF( l_proc_level >= l_dbg_level )

Line 2145: FND_LOG.STRING(l_proc_level

2141: BEGIN
2142: --log for debug
2143: IF( l_proc_level >= l_dbg_level )
2144: THEN
2145: FND_LOG.STRING(l_proc_level
2146: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
2147: ,'Enter procedure');
2148: END IF; --( l_proc_level >= l_dbg_level )
2149:

Line 2211: FND_LOG.STRING(l_proc_level

2207:
2208: --log for debug
2209: IF( l_proc_level >= l_dbg_level )
2210: THEN
2211: FND_LOG.STRING(l_proc_level
2212: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
2213: ,'Exit procedure');
2214: END IF; --( l_proc_level >= l_dbg_level )
2215:

Line 2313: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

2309: l_error_msg VARCHAR2(1000);
2310:
2311: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=p_batch_number;
2312: l_batch_number_ok BOOLEAN;
2313: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2314: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2315: l_invoice_type_check VARCHAR2(1); --added for invoice_type condition by Subba.
2316: BEGIN
2317:

Line 2314: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

2310:
2311: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=p_batch_number;
2312: l_batch_number_ok BOOLEAN;
2313: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2314: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2315: l_invoice_type_check VARCHAR2(1); --added for invoice_type condition by Subba.
2316: BEGIN
2317:
2318: --log for debug

Line 2321: FND_LOG.STRING(l_proc_level

2317:
2318: --log for debug
2319: IF( l_proc_level >= l_dbg_level )
2320: THEN
2321: FND_LOG.STRING(l_proc_level
2322: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
2323: ,'Enter procedure');
2324: END IF; --( l_proc_level >= l_dbg_level )
2325:

Line 2727: FND_LOG.STRING(l_proc_level

2723:
2724: --log for debug
2725: IF( l_proc_level >= l_dbg_level )
2726: THEN
2727: FND_LOG.STRING(l_proc_level
2728: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
2729: ,'Exit procedure');
2730: END IF; --( l_proc_level >= l_dbg_level )
2731:

Line 2737: FND_LOG.string( l_proc_level

2733:
2734: WHEN OTHERS THEN
2735: IF(l_proc_level >= l_dbg_level)
2736: THEN
2737: FND_LOG.string( l_proc_level
2738: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION'
2739: , SQLCODE||SQLERRM);
2740: END IF;
2741: RAISE;

Line 2789: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

2785: --add by Lv Xiao for bug#7626503 on 11-Dec-2008, end
2786:
2787: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=P_Batch_ID;
2788: l_batch_number_ok BOOLEAN;
2789: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2790: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2791: BEGIN
2792:
2793: --log for debug

Line 2790: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

2786:
2787: l_batch_number Jmf_Gta_Trx_Headers_All.Gta_Batch_Number%TYPE:=P_Batch_ID;
2788: l_batch_number_ok BOOLEAN;
2789: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2790: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2791: BEGIN
2792:
2793: --log for debug
2794: IF( l_proc_level >= l_dbg_level )

Line 2796: FND_LOG.STRING(l_proc_level

2792:
2793: --log for debug
2794: IF( l_proc_level >= l_dbg_level )
2795: THEN
2796: FND_LOG.STRING(l_proc_level
2797: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
2798: ,'Enter procedure');
2799: END IF; --( l_proc_level >= l_dbg_level )
2800:

Line 2916: FND_LOG.STRING(l_proc_level

2912:
2913: --log for debug
2914: IF( l_proc_level >= l_dbg_level )
2915: THEN
2916: FND_LOG.STRING(l_proc_level
2917: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
2918: ,'Exit procedure');
2919: END IF; --( l_proc_level >= l_dbg_level )
2920:

Line 2927: FND_LOG.string( l_proc_level

2923:
2924: WHEN OTHERS THEN
2925: IF(l_proc_level >= l_dbg_level)
2926: THEN
2927: FND_LOG.string( l_proc_level
2928: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
2929: , SQLCODE||SQLERRM);
2930: END IF;
2931:

Line 2967: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

2963:
2964: lv_class_type VARCHAR2(30);
2965:
2966: l_procedure_name VARCHAR2(50) :='Get_Trx_Class';
2967: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2968: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2969:
2970:
2971: BEGIN

Line 2968: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

2964: lv_class_type VARCHAR2(30);
2965:
2966: l_procedure_name VARCHAR2(50) :='Get_Trx_Class';
2967: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
2968: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
2969:
2970:
2971: BEGIN
2972:

Line 2976: FND_LOG.STRING(l_proc_level

2972:
2973: --log for debug
2974: IF( l_proc_level >= l_dbg_level )
2975: THEN
2976: FND_LOG.STRING(l_proc_level
2977: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
2978: ,'Enter procedure');
2979: END IF; --( l_proc_level >= l_dbg_level )
2980:

Line 2994: FND_LOG.STRING(l_proc_level

2990: AND JGTH.ra_trx_id = p_GTA_trx_id;
2991: --log for debug
2992: IF( l_proc_level >= l_dbg_level )
2993: THEN
2994: FND_LOG.STRING(l_proc_level
2995: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
2996: ,'Exit procedure');
2997: END IF; --( l_proc_level >= l_dbg_level )
2998:

Line 3039: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3035:
3036: l_cm_delimiter2 VARCHAR2(100);
3037:
3038: l_procedure_name VARCHAR2(50) :='Check_Header';
3039: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3040: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3041: l_trx_class VARCHAR2(20); --added by yao Zhang for bug 7670310
3042: BEGIN
3043:

Line 3040: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3036: l_cm_delimiter2 VARCHAR2(100);
3037:
3038: l_procedure_name VARCHAR2(50) :='Check_Header';
3039: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3040: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3041: l_trx_class VARCHAR2(20); --added by yao Zhang for bug 7670310
3042: BEGIN
3043:
3044: --log for debug

Line 3047: FND_LOG.STRING(l_proc_level

3043:
3044: --log for debug
3045: IF( l_proc_level >= l_dbg_level )
3046: THEN
3047: FND_LOG.STRING(l_proc_level
3048: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
3049: ,'Enter procedure');
3050: END IF; --( l_proc_level >= l_dbg_level )
3051:

Line 3126: FND_LOG.STRING(l_proc_level

3122:
3123: --log for debug
3124: IF( l_proc_level >= l_dbg_level )
3125: THEN
3126: FND_LOG.STRING(l_proc_level
3127: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
3128: ,'Exit procedure');
3129: END IF; --( l_proc_level >= l_dbg_level )
3130:

Line 3169: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3165: l_len_before_dot_tax NUMBER :=0;
3166: l_len_after_dot_tax NUMBER :=0;
3167: l_pos NUMBER :=0;
3168: l_procedure_name VARCHAR2(50) :='Check_Line_Length';
3169: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3170: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3171:
3172: BEGIN
3173:

Line 3170: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3166: l_len_after_dot_tax NUMBER :=0;
3167: l_pos NUMBER :=0;
3168: l_procedure_name VARCHAR2(50) :='Check_Line_Length';
3169: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3170: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3171:
3172: BEGIN
3173:
3174: --log for debug

Line 3177: FND_LOG.STRING(l_proc_level

3173:
3174: --log for debug
3175: IF( l_proc_level >= l_dbg_level )
3176: THEN
3177: FND_LOG.STRING(l_proc_level
3178: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
3179: ,'Enter procedure');
3180: END IF; --( l_proc_level >= l_dbg_level )
3181:

Line 3225: FND_LOG.STRING(l_proc_level

3221:
3222: --log for debug
3223: IF( l_proc_level >= l_dbg_level )
3224: THEN
3225: FND_LOG.STRING(l_proc_level
3226: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
3227: ,'Exit procedure');
3228: END IF; --( l_proc_level >= l_dbg_level )
3229:

Line 3327: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3323: l_jmf_gta_gta_not_enabled VARCHAR2(2000);
3324: l_count NUMBER;
3325: l_conc_succ BOOLEAN; -- the status of concurrent
3326:
3327: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3328: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3329:
3330: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
3331:

Line 3328: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3324: l_count NUMBER;
3325: l_conc_succ BOOLEAN; -- the status of concurrent
3326:
3327: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3328: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3329:
3330: l_ext_payer_id IBY_EXTERNAL_PAYERS_ALL.ext_payer_id%TYPE;
3331:
3332:

Line 3373: fnd_log.STRING(l_proc_level

3369: -- add the chinese token
3370:
3371: IF(l_proc_level >= l_dbg_level)
3372: THEN
3373: fnd_log.STRING(l_proc_level
3374: , G_MODULE_PREFIX||l_procedure_name
3375: , ' Procedure begin . ');
3376: END IF;
3377:

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

3381: fnd_message.set_name('JMF', 'JMF_GTA_BANKACCOUNT_MASKING');
3382:
3383: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
3384:
3385: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3386: THEN
3387: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
3388: , G_MODULE_PREFIX||l_procedure_name
3389: , l_error_string);

Line 3387: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

3383: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
3384:
3385: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3386: THEN
3387: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
3388: , G_MODULE_PREFIX||l_procedure_name
3389: , l_error_string);
3390: END IF;
3391: --set concurrent status to Warning

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

3523: AND addr.cust_account_id = l_customer_id;
3524:
3525: EXCEPTION
3526: WHEN NO_DATA_FOUND THEN
3527: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3528: THEN
3529: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
3530: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3531: ,'Customer'|| l_customer_name || 'has no primary bill to address');

Line 3529: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION

3525: EXCEPTION
3526: WHEN NO_DATA_FOUND THEN
3527: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3528: THEN
3529: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
3530: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3531: ,'Customer'|| l_customer_name || 'has no primary bill to address');
3532: END IF;
3533: END;

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

3548: AND contact_point_type = 'PHONE';
3549:
3550: EXCEPTION
3551: WHEN NO_DATA_FOUND THEN
3552: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3553: THEN
3554: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
3555: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3556: ,'Customer'|| l_customer_name || 'has no primary phone number'||SQLCODE||SQLERRM);

Line 3554: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION

3550: EXCEPTION
3551: WHEN NO_DATA_FOUND THEN
3552: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3553: THEN
3554: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
3555: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3556: ,'Customer'|| l_customer_name || 'has no primary phone number'||SQLCODE||SQLERRM);
3557: END IF;
3558: END;

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

3569: AND SITE.SITE_USE_CODE = 'BILL_TO'
3570: AND SITE.STATUS = 'A';
3571: EXCEPTION
3572: WHEN OTHERS THEN
3573: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3574: THEN
3575: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3576: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3577: , l_err_text||SQLCODE ||SQLERRM);

Line 3575: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3571: EXCEPTION
3572: WHEN OTHERS THEN
3573: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3574: THEN
3575: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3576: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3577: , l_err_text||SQLCODE ||SQLERRM);
3578: END IF;
3579: END;

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

3592: org_id = p_org_id;
3593:
3594: EXCEPTION
3595: WHEN OTHERS THEN
3596: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3597: THEN
3598: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3599: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3600: , l_err_text||SQLCODE ||SQLERRM);

Line 3598: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3594: EXCEPTION
3595: WHEN OTHERS THEN
3596: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3597: THEN
3598: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3599: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3600: , l_err_text||SQLCODE ||SQLERRM);
3601: END IF;
3602: END;

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

3617: AND payment_function = 'CUSTOMER_PAYMENT'; -- function
3618:
3619: EXCEPTION
3620: WHEN OTHERS THEN
3621: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3622: THEN
3623: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3624: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3625: , l_err_text||SQLCODE ||SQLERRM);

Line 3623: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3619: EXCEPTION
3620: WHEN OTHERS THEN
3621: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3622: THEN
3623: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3624: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3625: , l_err_text||SQLCODE ||SQLERRM);
3626: END IF;
3627: END;

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

3652: WHERE ROWNUM =1;
3653:
3654: EXCEPTION
3655: WHEN OTHERS THEN
3656: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3657: THEN
3658: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3659: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3660: , l_err_text||SQLCODE ||SQLERRM);

Line 3658: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3654: EXCEPTION
3655: WHEN OTHERS THEN
3656: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3657: THEN
3658: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3659: , G_MODULE_PREFIX || l_procedure_name || '.NoDataFound'
3660: , l_err_text||SQLCODE ||SQLERRM);
3661: END IF;
3662: END;

Line 3795: fnd_log.STRING(l_proc_level

3791:
3792:
3793: IF(l_proc_level >= l_dbg_level)
3794: THEN
3795: fnd_log.STRING(l_proc_level
3796: , G_MODULE_PREFIX||l_procedure_name
3797: , ' Procedure End . ');
3798: END IF;
3799:

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

3798: END IF;
3799:
3800: EXCEPTION
3801: WHEN OTHERS THEN
3802: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3803: THEN
3804: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3805: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
3806: , SQLCODE||':'||SQLERRM);

Line 3804: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

3800: EXCEPTION
3801: WHEN OTHERS THEN
3802: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3803: THEN
3804: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
3805: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
3806: , SQLCODE||':'||SQLERRM);
3807: END IF;
3808: RAISE;

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

3834: --
3835: -- CHANGE HISTORY:
3836: --
3837: -- 17-MAY-2005 Donghai Wang Creation
3838: -- 06-MAR-2006 Donghai Wang Add fnd log
3839: -- 06-APR-2006 Donghai Wang Remove the parameter p_tax_rate to
3840: -- fix bug 5138356 due to no longer
3841: -- export tax rate by items
3842: --===========================================================================

Line 3871: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3867: l_tax_rate_length_before_dot NUMBER;
3868: l_tax_rate_length_after_dot NUMBER;
3869: l_item_model_length NUMBER;
3870: l_uom_length NUMBER;
3871: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3872: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3873: l_procedure_name VARCHAR2(100) :='Check_Item_Length';
3874: l_dbg_msg VARCHAR2(1000);
3875: BEGIN

Line 3872: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3868: l_tax_rate_length_after_dot NUMBER;
3869: l_item_model_length NUMBER;
3870: l_uom_length NUMBER;
3871: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3872: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3873: l_procedure_name VARCHAR2(100) :='Check_Item_Length';
3874: l_dbg_msg VARCHAR2(1000);
3875: BEGIN
3876:

Line 3880: FND_LOG.STRING(l_proc_level

3876:
3877: --log for debug
3878: IF( l_proc_level >= l_dbg_level )
3879: THEN
3880: FND_LOG.STRING(l_proc_level
3881: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
3882: ,'Enter function');
3883:
3884: FND_LOG.STRING(l_proc_level

Line 3884: FND_LOG.STRING(l_proc_level

3880: FND_LOG.STRING(l_proc_level
3881: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
3882: ,'Enter function');
3883:
3884: FND_LOG.STRING(l_proc_level
3885: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
3886: ,'p_item_number '||p_item_number);
3887:
3888: FND_LOG.STRING(l_proc_level

Line 3888: FND_LOG.STRING(l_proc_level

3884: FND_LOG.STRING(l_proc_level
3885: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
3886: ,'p_item_number '||p_item_number);
3887:
3888: FND_LOG.STRING(l_proc_level
3889: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
3890: ,'p_item_name '||p_item_name);
3891:
3892: FND_LOG.STRING(l_proc_level

Line 3892: FND_LOG.STRING(l_proc_level

3888: FND_LOG.STRING(l_proc_level
3889: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
3890: ,'p_item_name '||p_item_name);
3891:
3892: FND_LOG.STRING(l_proc_level
3893: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
3894: ,'p_tax_name '||p_tax_name);
3895:
3896:

Line 3897: FND_LOG.STRING(l_proc_level

3893: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
3894: ,'p_tax_name '||p_tax_name);
3895:
3896:
3897: FND_LOG.STRING(l_proc_level
3898: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
3899: ,'p_item_model '||p_item_model);
3900:
3901: FND_LOG.STRING(l_proc_level

Line 3901: FND_LOG.STRING(l_proc_level

3897: FND_LOG.STRING(l_proc_level
3898: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
3899: ,'p_item_model '||p_item_model);
3900:
3901: FND_LOG.STRING(l_proc_level
3902: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
3903: ,'p_uom '||p_uom);
3904: END IF; --( l_proc_level >= l_dbg_level )
3905:

Line 3931: FND_LOG.STRING(l_proc_level

3927:
3928: --log for debug
3929: IF( l_proc_level >= l_dbg_level )
3930: THEN
3931: FND_LOG.STRING(l_proc_level
3932: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
3933: ,'Exit function');
3934: END IF; --( l_proc_level >= l_dbg_level )
3935:

Line 3940: FND_LOG.string( l_proc_level

3936: EXCEPTION
3937: WHEN OTHERS THEN
3938: IF(l_proc_level >= l_dbg_level)
3939: THEN
3940: FND_LOG.string( l_proc_level
3941: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
3942: , SQLCODE||':'||SQLERRM);
3943: END IF;--(l_proc_level >= l_dbg_level)
3944: END Check_Item_Length;

Line 3995: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

3991: l_export_item JMF_GTA_TXT_OPERATOR_PROC.G_Item_Tbl :=p_export_item;
3992: l_item_length_exp JMF_GTA_TXT_OPERATOR_PROC.G_Item_Tbl :=p_item_length_exp;
3993: l_idx NUMBER;
3994: l_export_record VARCHAR2(4000);
3995: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3996: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3997: l_procedure_name VARCHAR2(100) :='Export_To_Flat_file';
3998: l_dbg_msg VARCHAR2(1000);
3999: BEGIN

Line 3996: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

3992: l_item_length_exp JMF_GTA_TXT_OPERATOR_PROC.G_Item_Tbl :=p_item_length_exp;
3993: l_idx NUMBER;
3994: l_export_record VARCHAR2(4000);
3995: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
3996: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
3997: l_procedure_name VARCHAR2(100) :='Export_To_Flat_file';
3998: l_dbg_msg VARCHAR2(1000);
3999: BEGIN
4000:

Line 4004: FND_LOG.STRING(l_proc_level

4000:
4001: --log for debug
4002: IF( l_proc_level >= l_dbg_level )
4003: THEN
4004: FND_LOG.STRING(l_proc_level
4005: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
4006: ,'Enter procedure');
4007: END IF; --( l_proc_level >= l_dbg_level )
4008:

Line 4136: FND_LOG.STRING(l_proc_level

4132:
4133: --log for debug
4134: IF( l_proc_level >= l_dbg_level )
4135: THEN
4136: FND_LOG.STRING(l_proc_level
4137: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
4138: ,'Exit procedure');
4139: END IF; --( l_proc_level >= l_dbg_level )
4140:

Line 4145: FND_LOG.string( l_proc_level

4141: EXCEPTION
4142: WHEN OTHERS THEN
4143: IF(l_proc_level >= l_dbg_level)
4144: THEN
4145: FND_LOG.string( l_proc_level
4146: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
4147: , SQLCODE||':'||SQLERRM);
4148: END IF;--(l_proc_level >= l_dbg_level)
4149:

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

4189: --
4190: -- CHANGE HISTORY:
4191: --
4192: -- 17-MAY-2005 Donghai Wang Creation
4193: -- 06-MAR-2006 Donghai Wang Add fnd log
4194: -- 06-Apr-2006 Donghai Wang Remove tax rate from the procedure
4195: -- for fix bug 5138356
4196: --===========================================================================
4197: PROCEDURE Export_items

Line 4388: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

4384:
4385: l_export_item g_item_tbl;
4386: l_export_item_idx NUMBER;
4387: l_procedure_name VARCHAR2(50) :='Export_Items';
4388: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4389: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4390: l_nodatafound_msg VARCHAR2(1000);
4391:
4392: BEGIN

Line 4389: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

4385: l_export_item g_item_tbl;
4386: l_export_item_idx NUMBER;
4387: l_procedure_name VARCHAR2(50) :='Export_Items';
4388: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
4389: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
4390: l_nodatafound_msg VARCHAR2(1000);
4391:
4392: BEGIN
4393:

Line 4398: FND_LOG.STRING(l_proc_level

4394: --log for debug
4395:
4396: IF( l_proc_level >= l_dbg_level )
4397: THEN
4398: FND_LOG.STRING(l_proc_level
4399: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
4400: ,'Enter procedure');
4401:
4402: FND_LOG.STRING(l_proc_level

Line 4402: FND_LOG.STRING(l_proc_level

4398: FND_LOG.STRING(l_proc_level
4399: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
4400: ,'Enter procedure');
4401:
4402: FND_LOG.STRING(l_proc_level
4403: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4404: ,'p_org_id '||p_org_id);
4405:
4406: FND_LOG.STRING(l_proc_level

Line 4406: FND_LOG.STRING(l_proc_level

4402: FND_LOG.STRING(l_proc_level
4403: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4404: ,'p_org_id '||p_org_id);
4405:
4406: FND_LOG.STRING(l_proc_level
4407: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4408: ,'p_master_org_id '||p_master_org_id);
4409:
4410: FND_LOG.STRING(l_proc_level

Line 4410: FND_LOG.STRING(l_proc_level

4406: FND_LOG.STRING(l_proc_level
4407: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4408: ,'p_master_org_id '||p_master_org_id);
4409:
4410: FND_LOG.STRING(l_proc_level
4411: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4412: ,'p_item_num_from '||p_item_num_from);
4413:
4414: FND_LOG.STRING(l_proc_level

Line 4414: FND_LOG.STRING(l_proc_level

4410: FND_LOG.STRING(l_proc_level
4411: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4412: ,'p_item_num_from '||p_item_num_from);
4413:
4414: FND_LOG.STRING(l_proc_level
4415: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4416: ,'p_item_num_to '||p_item_num_to);
4417:
4418: FND_LOG.STRING(l_proc_level

Line 4418: FND_LOG.STRING(l_proc_level

4414: FND_LOG.STRING(l_proc_level
4415: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4416: ,'p_item_num_to '||p_item_num_to);
4417:
4418: FND_LOG.STRING(l_proc_level
4419: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4420: ,'p_category_set_id '||p_category_set_id);
4421:
4422: FND_LOG.STRING(l_proc_level

Line 4422: FND_LOG.STRING(l_proc_level

4418: FND_LOG.STRING(l_proc_level
4419: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4420: ,'p_category_set_id '||p_category_set_id);
4421:
4422: FND_LOG.STRING(l_proc_level
4423: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4424: ,'p_category_structure_id '||p_category_structure_id);
4425:
4426: FND_LOG.STRING(l_proc_level

Line 4426: FND_LOG.STRING(l_proc_level

4422: FND_LOG.STRING(l_proc_level
4423: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4424: ,'p_category_structure_id '||p_category_structure_id);
4425:
4426: FND_LOG.STRING(l_proc_level
4427: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4428: ,'p_item_category_from '||p_item_category_from);
4429:
4430: FND_LOG.STRING(l_proc_level

Line 4430: FND_LOG.STRING(l_proc_level

4426: FND_LOG.STRING(l_proc_level
4427: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4428: ,'p_item_category_from '||p_item_category_from);
4429:
4430: FND_LOG.STRING(l_proc_level
4431: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4432: ,'p_item_category_to '||p_item_category_to);
4433:
4434: FND_LOG.STRING(l_proc_level

Line 4434: FND_LOG.STRING(l_proc_level

4430: FND_LOG.STRING(l_proc_level
4431: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4432: ,'p_item_category_to '||p_item_category_to);
4433:
4434: FND_LOG.STRING(l_proc_level
4435: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4436: ,'p_item_name_source '||p_item_name_source);
4437:
4438: FND_LOG.STRING(l_proc_level

Line 4438: FND_LOG.STRING(l_proc_level

4434: FND_LOG.STRING(l_proc_level
4435: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4436: ,'p_item_name_source '||p_item_name_source);
4437:
4438: FND_LOG.STRING(l_proc_level
4439: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4440: ,'p_cross_reference_type '||p_cross_reference_type);
4441:
4442: FND_LOG.STRING(l_proc_level

Line 4442: FND_LOG.STRING(l_proc_level

4438: FND_LOG.STRING(l_proc_level
4439: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4440: ,'p_cross_reference_type '||p_cross_reference_type);
4441:
4442: FND_LOG.STRING(l_proc_level
4443: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4444: ,'p_item_status '||p_item_status);
4445:
4446: FND_LOG.STRING(l_proc_level

Line 4446: FND_LOG.STRING(l_proc_level

4442: FND_LOG.STRING(l_proc_level
4443: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4444: ,'p_item_status '||p_item_status);
4445:
4446: FND_LOG.STRING(l_proc_level
4447: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4448: ,'p_creation_date_from '||p_creation_date_from);
4449:
4450: FND_LOG.STRING(l_proc_level

Line 4450: FND_LOG.STRING(l_proc_level

4446: FND_LOG.STRING(l_proc_level
4447: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4448: ,'p_creation_date_from '||p_creation_date_from);
4449:
4450: FND_LOG.STRING(l_proc_level
4451: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.parameters'
4452: ,'p_creation_date_to '||p_creation_date_to);
4453: END IF; --( l_proc_level >= l_dbg_level )
4454:

Line 4578: FND_LOG.String(l_proc_level

4574: );
4575: END IF; --l_export_item_count=0
4576: IF( l_proc_level >= l_dbg_level )
4577: THEN
4578: FND_LOG.String(l_proc_level
4579: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
4580: ,'Exit procedure');
4581: END IF; --( l_proc_level >= l_dbg_level )
4582:

Line 4587: FND_LOG.string( l_proc_level

4583: EXCEPTION
4584: WHEN OTHERS THEN
4585: IF(l_proc_level >= l_dbg_level)
4586: THEN
4587: FND_LOG.string( l_proc_level
4588: , G_MODULE_PREFIX || l_procedure_name || '.OTHER_EXCEPTION '
4589: , SQLCODE||':'||SQLERRM);
4590: END IF;--(l_proc_level >= l_dbg_level)
4591: END Export_items;