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

Line 59: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

55:
56:
57: PROCEDURE Legal_consistent_Validation( P_LEGAL_ENTITY_ID IN NUMBER) IS
58:
59: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
60: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
61: l_proc_name VARCHAR2(100) :='Legal_consistent_Validation';
62:
63: -- l_profile_legal NUMBER(15);

Line 60: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

56:
57: PROCEDURE Legal_consistent_Validation( P_LEGAL_ENTITY_ID IN NUMBER) IS
58:
59: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
60: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
61: l_proc_name VARCHAR2(100) :='Legal_consistent_Validation';
62:
63: -- l_profile_legal NUMBER(15);
64:

Line 69: FND_LOG.String( l_proc_level

65: BEGIN
66:
67: IF (l_proc_level >= l_dbg_level)
68: THEN
69: FND_LOG.String( l_proc_level
70: ,l_module_prefix||'.'||l_proc_name||'.begin'
71: ,'Enter procedure'
72: );
73:

Line 74: FND_LOG.String( l_proc_level

70: ,l_module_prefix||'.'||l_proc_name||'.begin'
71: ,'Enter procedure'
72: );
73:
74: FND_LOG.String( l_proc_level
75: ,l_module_prefix||'.'||l_proc_name||'.parameters'
76: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
77: );
78:

Line 111: FND_LOG.String( l_proc_level

107:
108: WHEN OTHERS THEN
109: IF (l_proc_level >= l_dbg_level)
110: THEN
111: FND_LOG.String( l_proc_level
112: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
113: ,SQLCODE||':'||SQLERRM);
114: END IF; --(l_proc_level >= l_dbg_level)
115:

Line 149: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

145:
146:
147: PROCEDURE Base_Validation IS
148:
149: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
150: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
151: l_proc_name VARCHAR2(100) :='Legal_consistent_Validation';
152:
153:

Line 150: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

146:
147: PROCEDURE Base_Validation IS
148:
149: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
150: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
151: l_proc_name VARCHAR2(100) :='Legal_consistent_Validation';
152:
153:
154: l_JE_CATEGORY VARCHAR2(25);

Line 196: FND_LOG.String( l_proc_level

192: BEGIN
193:
194: IF (l_proc_level >= l_dbg_level)
195: THEN
196: FND_LOG.String( l_proc_level
197: ,l_module_prefix||'.'||l_proc_name||'.begin'
198: ,'Enter procedure'
199: );
200:

Line 499: FND_LOG.String( l_proc_level

495:
496: WHEN OTHERS THEN
497: IF (l_proc_level >= l_dbg_level)
498: THEN
499: FND_LOG.String( l_proc_level
500: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
501: ,SQLCODE||':'||SQLERRM);
502: END IF; --(l_proc_level >= l_dbg_level)
503:

Line 530: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

526: PROCEDURE Company_Segment_Validation( P_LEGAL_ENTITY_ID IN NUMBER,
527: P_LEDGER_ID IN NUMBER
528: ) IS
529:
530: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
531: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
532: l_proc_name VARCHAR2(100) :='Company_Segment_Validation';
533:
534: l_sql varchar2(1000);

Line 531: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

527: P_LEDGER_ID IN NUMBER
528: ) IS
529:
530: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
531: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
532: l_proc_name VARCHAR2(100) :='Company_Segment_Validation';
533:
534: l_sql varchar2(1000);
535:

Line 540: FND_LOG.String( l_proc_level

536: BEGIN
537:
538: IF (l_proc_level >= l_dbg_level)
539: THEN
540: FND_LOG.String( l_proc_level
541: ,l_module_prefix||'.'||l_proc_name||'.begin'
542: ,'Enter procedure'
543: );
544:

Line 545: FND_LOG.String( l_proc_level

541: ,l_module_prefix||'.'||l_proc_name||'.begin'
542: ,'Enter procedure'
543: );
544:
545: FND_LOG.String( l_proc_level
546: ,l_module_prefix||'.'||l_proc_name||'.parameters'
547: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
548: );
549: FND_LOG.String( l_proc_level

Line 549: FND_LOG.String( l_proc_level

545: FND_LOG.String( l_proc_level
546: ,l_module_prefix||'.'||l_proc_name||'.parameters'
547: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
548: );
549: FND_LOG.String( l_proc_level
550: ,l_module_prefix||'.'||l_proc_name||'.parameters'
551: ,'Ledger ID '||P_LEDGER_ID
552: );
553:

Line 564: Fnd_Log.STRING(l_Proc_Level,

560: l_Populate_Bsv_Flag := Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(P_Ledger_Id,
561: P_Legal_Entity_Id);
562: IF l_Populate_Bsv_Flag = 'F' THEN
563: IF (l_Proc_Level >= l_Dbg_Level) THEN
564: Fnd_Log.STRING(l_Proc_Level,
565: l_Module_Prefix || '.' || l_Proc_Name,
566: 'fail to populate BSV');
567: END IF; --(l_proc_level >= l_dbg_level)
568: END IF;

Line 587: FND_LOG.String( l_proc_level

583:
584: WHEN OTHERS THEN
585: IF (l_proc_level >= l_dbg_level)
586: THEN
587: FND_LOG.String( l_proc_level
588: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
589: ,SQLCODE||':'||SQLERRM);
590: END IF; --(l_proc_level >= l_dbg_level)
591:

Line 616: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

612:
613:
614: PROCEDURE Balance_Validation(p_legal_entity_id IN NUMBER) IS
615:
616: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
617: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
618: l_proc_name VARCHAR2(100) :='Balance_Validation';
619:
620: l_dr number(15);

Line 617: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

613:
614: PROCEDURE Balance_Validation(p_legal_entity_id IN NUMBER) IS
615:
616: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
617: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
618: l_proc_name VARCHAR2(100) :='Balance_Validation';
619:
620: l_dr number(15);
621: l_cr number(15);

Line 638: FND_LOG.String( l_proc_level

634: BEGIN
635:
636: IF (l_proc_level >= l_dbg_level)
637: THEN
638: FND_LOG.String( l_proc_level
639: ,l_module_prefix||'.'||l_proc_name||'.begin'
640: ,'Enter procedure'
641: );
642:

Line 702: FND_LOG.String( l_proc_level

698:
699: WHEN OTHERS THEN
700: IF (l_proc_level >= l_dbg_level)
701: THEN
702: FND_LOG.String( l_proc_level
703: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
704: ,SQLCODE||':'||SQLERRM);
705: END IF; --(l_proc_level >= l_dbg_level)
706:

Line 732: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

728: --===========================================================================
729:
730: PROCEDURE Code_Combination_Validation( P_LEDGER_ID IN NUMBER) IS
731:
732: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
733: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
734: l_proc_name VARCHAR2(100) :='Code_Combination_Validation';
735:
736: v_code NUMBER;

Line 733: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

729:
730: PROCEDURE Code_Combination_Validation( P_LEDGER_ID IN NUMBER) IS
731:
732: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
733: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
734: l_proc_name VARCHAR2(100) :='Code_Combination_Validation';
735:
736: v_code NUMBER;
737: v_errm VARCHAR2(64);

Line 821: FND_LOG.String( l_proc_level

817: BEGIN
818:
819: IF (l_proc_level >= l_dbg_level)
820: THEN
821: FND_LOG.String( l_proc_level
822: ,l_module_prefix||'.'||l_proc_name||'.begin'
823: ,'Enter procedure'
824: );
825:

Line 826: FND_LOG.String( l_proc_level

822: ,l_module_prefix||'.'||l_proc_name||'.begin'
823: ,'Enter procedure'
824: );
825:
826: FND_LOG.String( l_proc_level
827: ,l_module_prefix||'.'||l_proc_name||'.parameters'
828: ,'Legal Entity ID '||P_LEDGER_ID
829: );
830:

Line 1041: FND_LOG.String( l_proc_level

1037: v_errm := SUBSTR(SQLERRM, 1 , 64);
1038:
1039: IF (l_proc_level >= l_dbg_level)
1040: THEN
1041: FND_LOG.String( l_proc_level
1042: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
1043: ,SQLCODE||':'||SQLERRM);
1044: END IF; --(l_proc_level >= l_dbg_level)
1045:

Line 1076: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1072: P_PERIOD_FROM IN VARCHAR2,
1073: P_PERIOD_TO IN VARCHAR2
1074: ) IS
1075:
1076: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1077: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1078: l_proc_name VARCHAR2(100) :='Validation';
1079:
1080:

Line 1077: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1073: P_PERIOD_TO IN VARCHAR2
1074: ) IS
1075:
1076: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1077: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1078: l_proc_name VARCHAR2(100) :='Validation';
1079:
1080:
1081:

Line 1086: FND_LOG.String( l_proc_level

1082: BEGIN
1083:
1084: IF (l_proc_level >= l_dbg_level)
1085: THEN
1086: FND_LOG.String( l_proc_level
1087: ,l_module_prefix||'.'||l_proc_name||'.begin'
1088: ,'Enter procedure'
1089: );
1090: FND_LOG.String( l_proc_level

Line 1090: FND_LOG.String( l_proc_level

1086: FND_LOG.String( l_proc_level
1087: ,l_module_prefix||'.'||l_proc_name||'.begin'
1088: ,'Enter procedure'
1089: );
1090: FND_LOG.String( l_proc_level
1091: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1092: ,'Ledger ID '||P_LEDGER_ID
1093: );
1094: FND_LOG.String( l_proc_level

Line 1094: FND_LOG.String( l_proc_level

1090: FND_LOG.String( l_proc_level
1091: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1092: ,'Ledger ID '||P_LEDGER_ID
1093: );
1094: FND_LOG.String( l_proc_level
1095: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1096: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
1097: );
1098: FND_LOG.String( l_proc_level

Line 1098: FND_LOG.String( l_proc_level

1094: FND_LOG.String( l_proc_level
1095: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1096: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
1097: );
1098: FND_LOG.String( l_proc_level
1099: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1100: ,'Period From '||P_PERIOD_FROM
1101: );
1102: FND_LOG.String( l_proc_level

Line 1102: FND_LOG.String( l_proc_level

1098: FND_LOG.String( l_proc_level
1099: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1100: ,'Period From '||P_PERIOD_FROM
1101: );
1102: FND_LOG.String( l_proc_level
1103: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1104: ,'Period To '||P_PERIOD_TO
1105: );
1106:

Line 1187: FND_LOG.String( l_proc_level

1183:
1184: WHEN OTHERS THEN
1185: IF (l_proc_level >= l_dbg_level)
1186: THEN
1187: FND_LOG.String( l_proc_level
1188: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
1189: ,SQLCODE||':'||SQLERRM);
1190: END IF; --(l_proc_level >= l_dbg_level)
1191:

Line 1227: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1223: l_End_Period VARCHAR2(15);
1224: l_ledger_id number;
1225: l_legal_entity_id number;
1226:
1227: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1228: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1229: l_Proc_Name VARCHAR2(100) := 'Set_flag_p';
1230:
1231: TYPE JECurTyp IS REF CURSOR;

Line 1228: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1224: l_ledger_id number;
1225: l_legal_entity_id number;
1226:
1227: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1228: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1229: l_Proc_Name VARCHAR2(100) := 'Set_flag_p';
1230:
1231: TYPE JECurTyp IS REF CURSOR;
1232: c_journal JECurTyp;

Line 1243: FND_LOG.String( l_proc_level

1239: BEGIN
1240:
1241: IF (l_proc_level >= l_dbg_level)
1242: THEN
1243: FND_LOG.String( l_proc_level
1244: ,l_module_prefix||'.'||l_proc_name||'.begin'
1245: ,'Enter procedure'
1246: );
1247: FND_LOG.String( l_proc_level

Line 1247: FND_LOG.String( l_proc_level

1243: FND_LOG.String( l_proc_level
1244: ,l_module_prefix||'.'||l_proc_name||'.begin'
1245: ,'Enter procedure'
1246: );
1247: FND_LOG.String( l_proc_level
1248: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1249: ,'Ledger ID '||P_LEDGER_ID
1250: );
1251: FND_LOG.String( l_proc_level

Line 1251: FND_LOG.String( l_proc_level

1247: FND_LOG.String( l_proc_level
1248: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1249: ,'Ledger ID '||P_LEDGER_ID
1250: );
1251: FND_LOG.String( l_proc_level
1252: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1253: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
1254: );
1255: FND_LOG.String( l_proc_level

Line 1255: FND_LOG.String( l_proc_level

1251: FND_LOG.String( l_proc_level
1252: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1253: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
1254: );
1255: FND_LOG.String( l_proc_level
1256: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1257: ,'Period From '||P_PERIOD_FROM
1258: );
1259: FND_LOG.String( l_proc_level

Line 1259: FND_LOG.String( l_proc_level

1255: FND_LOG.String( l_proc_level
1256: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1257: ,'Period From '||P_PERIOD_FROM
1258: );
1259: FND_LOG.String( l_proc_level
1260: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1261: ,'Period To '||P_PERIOD_TO
1262: );
1263:

Line 1276: Fnd_Log.STRING(l_Proc_Level,

1272: l_Populate_Bsv_Flag := Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(l_Ledger_Id,
1273: l_Legal_Entity_Id);
1274: IF l_Populate_Bsv_Flag = 'F' THEN
1275: IF (l_Proc_Level >= l_Dbg_Level) THEN
1276: Fnd_Log.STRING(l_Proc_Level,
1277: l_Module_Prefix || '.' || l_Proc_Name,
1278: 'fail to populate BSV');
1279: END IF; --(l_proc_level >= l_dbg_level)
1280: END IF;

Line 1345: FND_LOG.String( l_proc_level

1341:
1342: WHEN OTHERS THEN
1343: IF (l_proc_level >= l_dbg_level)
1344: THEN
1345: FND_LOG.String( l_proc_level
1346: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
1347: ,SQLCODE||':'||SQLERRM);
1348: END IF; --(l_proc_level >= l_dbg_level)
1349:

Line 1384: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1380: l_Je_Appending_Id NUMBER;
1381:
1382: l_ledger_id number;
1383: l_legal_entity_id number;
1384: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1385: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1386: l_Proc_Name VARCHAR2(100) := 'generate_journal_num';
1387:
1388: v_code NUMBER;

Line 1385: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1381:
1382: l_ledger_id number;
1383: l_legal_entity_id number;
1384: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1385: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1386: l_Proc_Name VARCHAR2(100) := 'generate_journal_num';
1387:
1388: v_code NUMBER;
1389: v_errm VARCHAR2(64);

Line 1414: Fnd_Log.STRING(l_Proc_Level,

1410:
1411: BEGIN
1412: --log for debug
1413: IF (l_Proc_Level >= l_Dbg_Level) THEN
1414: Fnd_Log.STRING(l_Proc_Level,
1415: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1416: 'Enter procedure');
1417: END IF; --(l_proc_level >= l_dbg_level)
1418:

Line 1473: Fnd_Log.STRING(l_Proc_Level,

1469: WHEN OTHERS THEN
1470: v_code := SQLCODE;
1471: v_errm := SUBSTR(SQLERRM, 1 , 64);
1472: IF (l_Proc_Level >= l_Dbg_Level) THEN
1473: Fnd_Log.STRING(l_Proc_Level,
1474: l_Module_Prefix || '.' || l_Proc_Name ||
1475: '. Other_Exception ',
1476: SQLCODE || ':' || SQLERRM);
1477: END IF; --(l_proc_level >= l_dbg_level)

Line 1509: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1505: l_Company_Column_Name VARCHAR2(30);
1506: l_Account_Column_Name VARCHAR2(30);
1507: l_Cost_Column_Name VARCHAR2(30);
1508: l_Project_Column_Name VARCHAR2(30);
1509: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1510: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1511: l_Proc_Name VARCHAR2(100) := 'generate_code_combination_view';
1512: l_Second_Track_Col_Name VARCHAR2(30);
1513: l_Other_Cols_Name VARCHAR2(200);

Line 1510: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1506: l_Account_Column_Name VARCHAR2(30);
1507: l_Cost_Column_Name VARCHAR2(30);
1508: l_Project_Column_Name VARCHAR2(30);
1509: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1510: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1511: l_Proc_Name VARCHAR2(100) := 'generate_code_combination_view';
1512: l_Second_Track_Col_Name VARCHAR2(30);
1513: l_Other_Cols_Name VARCHAR2(200);
1514: l_ledger_id number;

Line 1562: Fnd_Log.STRING(l_Proc_Level,

1558: BEGIN
1559:
1560: --log for debug
1561: IF (l_Proc_Level >= l_Dbg_Level) THEN
1562: Fnd_Log.STRING(l_Proc_Level,
1563: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1564: 'Enter procedure');
1565: END IF; --(l_proc_level >= l_dbg_level)
1566: l_ledger_id := p_ledger_id;

Line 1690: Fnd_Log.STRING(l_Proc_Level,

1686: l_Create_View_Sql;
1687:
1688: --log for debug
1689: IF (l_Proc_Level >= l_Dbg_Level) THEN
1690: Fnd_Log.STRING(l_Proc_Level,
1691: l_Module_Prefix || '.' || l_Proc_Name,
1692: 'l_create_view_sql:' || l_Create_View_Sql);
1693: END IF; --(l_proc_level >= l_dbg_level)
1694:

Line 1699: Fnd_Log.STRING(l_Proc_Level,

1695: EXECUTE IMMEDIATE l_Create_View_Sql;
1696:
1697: --log for dubug
1698: IF (l_Proc_Level >= l_Dbg_Level) THEN
1699: Fnd_Log.STRING(l_Proc_Level,
1700: l_Module_Prefix || '.' || l_Proc_Name || '.end',
1701: 'Enter procedure');
1702: END IF; --(l_proc_level >= l_dbg_level)
1703:

Line 1709: Fnd_Log.STRING(l_Proc_Level,

1705: WHEN OTHERS THEN
1706: FND_FILE.put_line(FND_FILE.OUTPUT,SQLCODE || ':' || SQLERRM);
1707: --log for debug
1708: IF (l_Proc_Level >= l_Dbg_Level) THEN
1709: Fnd_Log.STRING(l_Proc_Level,
1710: l_Module_Prefix || '.' || l_Proc_Name ||
1711: '. Other_Exception ',
1712: SQLCODE || ':' || SQLERRM);
1713: END IF; --(l_proc_level >= l_dbg_level)

Line 1745: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1741: P_PERIOD_FROM IN VARCHAR2,
1742: P_PERIOD_TO IN VARCHAR2
1743: )is
1744:
1745: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1746: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1747: l_proc_name VARCHAR2(100) :='Put_xml';
1748:
1749: L_XML_ITEM XMLTYPE;

Line 1746: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1742: P_PERIOD_TO IN VARCHAR2
1743: )is
1744:
1745: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1746: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1747: l_proc_name VARCHAR2(100) :='Put_xml';
1748:
1749: L_XML_ITEM XMLTYPE;
1750: L_XML_REPORT XMLTYPE;

Line 1798: FND_LOG.String( l_proc_level

1794: ORDER BY JOURNAL_GROUP,JA.JE_LINE_NUM;
1795: begin
1796: IF (l_proc_level >= l_dbg_level)
1797: THEN
1798: FND_LOG.String( l_proc_level
1799: ,l_module_prefix||'.'||l_proc_name||'.begin'
1800: ,'Enter procedure'
1801: );
1802: FND_LOG.String( l_proc_level

Line 1802: FND_LOG.String( l_proc_level

1798: FND_LOG.String( l_proc_level
1799: ,l_module_prefix||'.'||l_proc_name||'.begin'
1800: ,'Enter procedure'
1801: );
1802: FND_LOG.String( l_proc_level
1803: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1804: ,'Ledger ID '||P_LEDGER_ID
1805: );
1806: FND_LOG.String( l_proc_level

Line 1806: FND_LOG.String( l_proc_level

1802: FND_LOG.String( l_proc_level
1803: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1804: ,'Ledger ID '||P_LEDGER_ID
1805: );
1806: FND_LOG.String( l_proc_level
1807: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1808: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
1809: );
1810: FND_LOG.String( l_proc_level

Line 1810: FND_LOG.String( l_proc_level

1806: FND_LOG.String( l_proc_level
1807: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1808: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
1809: );
1810: FND_LOG.String( l_proc_level
1811: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1812: ,'Period From '||P_PERIOD_FROM
1813: );
1814: FND_LOG.String( l_proc_level

Line 1814: FND_LOG.String( l_proc_level

1810: FND_LOG.String( l_proc_level
1811: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1812: ,'Period From '||P_PERIOD_FROM
1813: );
1814: FND_LOG.String( l_proc_level
1815: ,l_module_prefix||'.'||l_proc_name||'.parameters'
1816: ,'Period To '||P_PERIOD_TO
1817: );
1818:

Line 1888: FND_LOG.String( l_proc_level

1884:
1885: WHEN OTHERS THEN
1886: IF (l_proc_level >= l_dbg_level)
1887: THEN
1888: FND_LOG.String( l_proc_level
1889: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
1890: ,SQLCODE||':'||SQLERRM);
1891: END IF; --(l_proc_level >= l_dbg_level)
1892: end put_xml;

Line 1925: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1921: P_PERIOD_FROM IN VARCHAR2,
1922: P_PERIOD_TO IN VARCHAR2
1923: ) IS
1924:
1925: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1926: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1927: l_proc_name VARCHAR2(100) :='Import_Itemization_Data';
1928:
1929: l_Populate_Bsv_Flag VARCHAR2(1);

Line 1926: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1922: P_PERIOD_TO IN VARCHAR2
1923: ) IS
1924:
1925: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1926: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1927: l_proc_name VARCHAR2(100) :='Import_Itemization_Data';
1928:
1929: l_Populate_Bsv_Flag VARCHAR2(1);
1930:

Line 2049: FND_LOG.String( l_proc_level

2045: BEGIN
2046:
2047: IF (l_proc_level >= l_dbg_level)
2048: THEN
2049: FND_LOG.String( l_proc_level
2050: ,l_module_prefix||'.'||l_proc_name||'.begin'
2051: ,'Enter procedure'
2052: );
2053: FND_LOG.String( l_proc_level

Line 2053: FND_LOG.String( l_proc_level

2049: FND_LOG.String( l_proc_level
2050: ,l_module_prefix||'.'||l_proc_name||'.begin'
2051: ,'Enter procedure'
2052: );
2053: FND_LOG.String( l_proc_level
2054: ,l_module_prefix||'.'||l_proc_name||'.parameters'
2055: ,'Ledger ID '||P_LEDGER_ID
2056: );
2057: FND_LOG.String( l_proc_level

Line 2057: FND_LOG.String( l_proc_level

2053: FND_LOG.String( l_proc_level
2054: ,l_module_prefix||'.'||l_proc_name||'.parameters'
2055: ,'Ledger ID '||P_LEDGER_ID
2056: );
2057: FND_LOG.String( l_proc_level
2058: ,l_module_prefix||'.'||l_proc_name||'.parameters'
2059: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
2060: );
2061: FND_LOG.String( l_proc_level

Line 2061: FND_LOG.String( l_proc_level

2057: FND_LOG.String( l_proc_level
2058: ,l_module_prefix||'.'||l_proc_name||'.parameters'
2059: ,'Legal Entity ID '||P_LEGAL_ENTITY_ID
2060: );
2061: FND_LOG.String( l_proc_level
2062: ,l_module_prefix||'.'||l_proc_name||'.parameters'
2063: ,'Period From '||P_PERIOD_FROM
2064: );
2065: FND_LOG.String( l_proc_level

Line 2065: FND_LOG.String( l_proc_level

2061: FND_LOG.String( l_proc_level
2062: ,l_module_prefix||'.'||l_proc_name||'.parameters'
2063: ,'Period From '||P_PERIOD_FROM
2064: );
2065: FND_LOG.String( l_proc_level
2066: ,l_module_prefix||'.'||l_proc_name||'.parameters'
2067: ,'Period To '||P_PERIOD_TO
2068: );
2069:

Line 2203: Fnd_Log.STRING(l_Proc_Level,

2199: l_Populate_Bsv_Flag := Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(P_Ledger_Id,
2200: P_Legal_Entity_Id);
2201: IF l_Populate_Bsv_Flag = 'F' THEN
2202: IF (l_Proc_Level >= l_Dbg_Level) THEN
2203: Fnd_Log.STRING(l_Proc_Level,
2204: l_Module_Prefix || '.' || l_Proc_Name,
2205: 'fail to populate BSV');
2206: END IF; --(l_proc_level >= l_dbg_level)
2207: END IF;

Line 2492: FND_LOG.String( l_proc_level

2488: v_errm := SUBSTR(SQLERRM, 1 , 64);
2489:
2490: IF (l_proc_level >= l_dbg_level)
2491: THEN
2492: FND_LOG.String( l_proc_level
2493: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
2494: ,SQLCODE||':'||SQLERRM);
2495: END IF; --(l_proc_level >= l_dbg_level)
2496: