DBA Data[Home] [Help]

APPS.AR_GTA_TRX_LINES_ALL_PKG dependencies on FND_LOG

Line 171: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

167: ,p_discount_rate IN NUMBER
168: )
169: IS
170: l_procedure_name VARCHAR2(100) :='Insert_Row';
171: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
172: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
173: CURSOR C IS
174: SELECT
175: ROWID

Line 172: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

168: )
169: IS
170: l_procedure_name VARCHAR2(100) :='Insert_Row';
171: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
172: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
173: CURSOR C IS
174: SELECT
175: ROWID
176: FROM

Line 186: FND_LOG.String(l_proc_level

182: --log for debug
183: IF( l_proc_level >= l_dbg_level)
184: THEN
185:
186: FND_LOG.String(l_proc_level
187: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
188: ,'Enter procedure'
189: );
190:

Line 316: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

312: --The following code is add by Yao Zhang for exception handle
313: EXCEPTION
314: WHEN OTHERS THEN
315: fnd_file.PUT_LINE(fnd_file.LOG,'Exception from insert row'||SQLCODE || SQLERRM);
316: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
317: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,
318: G_MODULE_PREFIX || l_procedure_name ||
319: '. OTHER_EXCEPTION ',
320: 'Unknown error' || SQLCODE || SQLERRM);

Line 317: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,

313: EXCEPTION
314: WHEN OTHERS THEN
315: fnd_file.PUT_LINE(fnd_file.LOG,'Exception from insert row'||SQLCODE || SQLERRM);
316: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
317: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,
318: G_MODULE_PREFIX || l_procedure_name ||
319: '. OTHER_EXCEPTION ',
320: 'Unknown error' || SQLCODE || SQLERRM);
321:

Line 328: FND_LOG.String(l_proc_level

324: --log for debug
325: IF( l_proc_level >= l_dbg_level)
326: THEN
327:
328: FND_LOG.String(l_proc_level
329: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
330: ,'Exit procedure'
331: );
332:

Line 449: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

445: ,p_last_update_login IN NUMBER
446: )
447: IS
448: l_procedure_name VARCHAR2(100) :='Update_Row';
449: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
450: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
451: BEGIN
452:
453: --log for debug

Line 450: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

446: )
447: IS
448: l_procedure_name VARCHAR2(100) :='Update_Row';
449: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
450: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
451: BEGIN
452:
453: --log for debug
454: IF( l_proc_level >= l_dbg_level)

Line 457: FND_LOG.String(l_proc_level

453: --log for debug
454: IF( l_proc_level >= l_dbg_level)
455: THEN
456:
457: FND_LOG.String(l_proc_level
458: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
459: ,'Enter procedure'
460: );
461:

Line 519: FND_LOG.String(l_proc_level

515: --log for debug
516: IF( l_proc_level >= l_dbg_level)
517: THEN
518:
519: FND_LOG.String(l_proc_level
520: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
521: ,'Exit procedure'
522: );
523:

Line 643: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

639: ,p_last_update_login IN NUMBER
640: )
641: IS
642: l_procedure_name VARCHAR2(100) :='Lock_Row';
643: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
644: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
645:
646: CURSOR c IS
647: SELECT

Line 644: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

640: )
641: IS
642: l_procedure_name VARCHAR2(100) :='Lock_Row';
643: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
644: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
645:
646: CURSOR c IS
647: SELECT
648: *

Line 661: FND_LOG.String(l_proc_level

657: --log for debug
658: IF( l_proc_level >= l_dbg_level)
659: THEN
660:
661: FND_LOG.String(l_proc_level
662: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
663: ,'Begin procedure'
664: );
665:

Line 1006: FND_LOG.String(l_proc_level

1002: --log for debug
1003: IF( l_proc_level >= l_dbg_level)
1004: THEN
1005:
1006: FND_LOG.String(l_proc_level
1007: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1008: ,'Exit procedure'
1009: );
1010:

Line 1043: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1039: (p_rowid IN OUT NOCOPY VARCHAR2
1040: )
1041: IS
1042: l_procedure_name VARCHAR2(100) :='Delete_Row';
1043: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1044: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1045: BEGIN
1046:
1047: --log for debug

Line 1044: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1040: )
1041: IS
1042: l_procedure_name VARCHAR2(100) :='Delete_Row';
1043: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1044: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1045: BEGIN
1046:
1047: --log for debug
1048: IF( l_proc_level >= l_dbg_level)

Line 1051: FND_LOG.String(l_proc_level

1047: --log for debug
1048: IF( l_proc_level >= l_dbg_level)
1049: THEN
1050:
1051: FND_LOG.String(l_proc_level
1052: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
1053: ,'Begin procedure'
1054: );
1055:

Line 1072: FND_LOG.String(l_proc_level

1068: --log for debug
1069: IF( l_proc_level >= l_dbg_level)
1070: THEN
1071:
1072: FND_LOG.String(l_proc_level
1073: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1074: ,'Exit procedure'
1075: );
1076:

Line 1107: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

1103: ,x_trx_line_rec OUT NOCOPY AR_GTA_TRX_UTIL.Trx_Line_Rec_Type
1104: )
1105: IS
1106: l_procedure_name VARCHAR2(100) :='Query_Row';
1107: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1108: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1109: BEGIN
1110:
1111: --log for debug

Line 1108: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

1104: )
1105: IS
1106: l_procedure_name VARCHAR2(100) :='Query_Row';
1107: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
1108: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
1109: BEGIN
1110:
1111: --log for debug
1112: IF( l_proc_level >= l_dbg_level)

Line 1115: FND_LOG.String(l_proc_level

1111: --log for debug
1112: IF( l_proc_level >= l_dbg_level)
1113: THEN
1114:
1115: FND_LOG.String(l_proc_level
1116: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.begin'
1117: ,'Begin procedure'
1118: );
1119:

Line 1227: FND_LOG.String(l_proc_level

1223: --log for debug
1224: IF( l_proc_level >= l_dbg_level)
1225: THEN
1226:
1227: FND_LOG.String(l_proc_level
1228: ,G_MODULE_PREFIX||'.'||l_procedure_name||'.end'
1229: ,'Exit procedure'
1230: );
1231: