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

Line 45: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

41: FUNCTION GDF_Item(p_invoice_id IN NUMBER,
42: p_invoice_distribution_id IN NUMBER)
43: RETURN VARCHAR2 IS
44: GDF_Item ap_invoice_distributions_all.global_attribute1%type:=null;
45: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
46: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
47: l_proc_name VARCHAR2(100) :='GDF_Item';
48:
49: BEGIN

Line 46: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

42: p_invoice_distribution_id IN NUMBER)
43: RETURN VARCHAR2 IS
44: GDF_Item ap_invoice_distributions_all.global_attribute1%type:=null;
45: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
46: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
47: l_proc_name VARCHAR2(100) :='GDF_Item';
48:
49: BEGIN
50: IF (l_proc_level >= l_dbg_level)

Line 52: FND_LOG.String( l_proc_level

48:
49: BEGIN
50: IF (l_proc_level >= l_dbg_level)
51: THEN
52: FND_LOG.String( l_proc_level
53: ,l_module_prefix||'.'||l_proc_name||'.begin'
54: ,'Enter procedure'
55: );
56: FND_LOG.String( l_proc_level

Line 56: FND_LOG.String( l_proc_level

52: FND_LOG.String( l_proc_level
53: ,l_module_prefix||'.'||l_proc_name||'.begin'
54: ,'Enter procedure'
55: );
56: FND_LOG.String( l_proc_level
57: ,l_module_prefix||'.'||l_proc_name||'.parameters'
58: ,'p_invoice_id '||p_invoice_id
59: );
60:

Line 61: FND_LOG.String(l_proc_level

57: ,l_module_prefix||'.'||l_proc_name||'.parameters'
58: ,'p_invoice_id '||p_invoice_id
59: );
60:
61: FND_LOG.String(l_proc_level
62: ,l_module_prefix||'.'||l_proc_name||'.parameters'
63: ,'p_invoice_distribution_id'||p_invoice_distribution_id
64: );
65:

Line 93: FND_LOG.String( l_proc_level

89:
90: WHEN OTHERS THEN
91: IF (l_proc_level >= l_dbg_level)
92: THEN
93: FND_LOG.String( l_proc_level
94: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
95: ,SQLCODE||':'||SQLERRM);
96: END IF; --(l_proc_level >= l_dbg_level)
97: RAISE;

Line 130: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

126: --new variable
127: L_PO_HEADER_ID NUMBER;
128: L_PO_LINE_ID NUMBER;
129: --
130: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
131: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;
132: L_PROC_NAME VARCHAR2(100) :='MASTER_ITEM';
133: a EXCEPTION;
134:

Line 131: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;

127: L_PO_HEADER_ID NUMBER;
128: L_PO_LINE_ID NUMBER;
129: --
130: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
131: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;
132: L_PROC_NAME VARCHAR2(100) :='MASTER_ITEM';
133: a EXCEPTION;
134:
135:

Line 139: FND_LOG.String( l_proc_level

135:
136: BEGIN
137: IF (l_proc_level >= l_dbg_level)
138: THEN
139: FND_LOG.String( l_proc_level
140: ,l_module_prefix||'.'||l_proc_name||'.begin'
141: ,'Enter procedure'
142: );
143:

Line 144: FND_LOG.String(l_proc_level

140: ,l_module_prefix||'.'||l_proc_name||'.begin'
141: ,'Enter procedure'
142: );
143:
144: FND_LOG.String(l_proc_level
145: ,l_module_prefix||'.'||l_proc_name||'.parameters'
146: ,'p_invoice_distribution_id '||p_invoice_distribution_id
147: );
148:

Line 259: FND_LOG.String( l_proc_level

255:
256: WHEN OTHERS THEN
257: IF (l_proc_level >= l_dbg_level)
258: THEN
259: FND_LOG.String( l_proc_level
260: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
261: ,SQLCODE||':'||SQLERRM);
262: END IF; --(l_proc_level >= l_dbg_level)
263: IF MASTER_ITEM IS NULL THEN

Line 298: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

294: FUNCTION Expense_Item(P_INVOICE_ID IN NUMBER,
295: p_invoice_distribution_id IN NUMBER)
296: RETURN VARCHAR2 IS
297: Expense_Item_desc ap_invoice_distributions_all.description%type:=null;
298: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
299: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
300: l_proc_name VARCHAR2(100) :='Expense_Item';
301:
302: BEGIN

Line 299: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

295: p_invoice_distribution_id IN NUMBER)
296: RETURN VARCHAR2 IS
297: Expense_Item_desc ap_invoice_distributions_all.description%type:=null;
298: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
299: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
300: l_proc_name VARCHAR2(100) :='Expense_Item';
301:
302: BEGIN
303: IF (l_proc_level >= l_dbg_level)

Line 305: FND_LOG.String( l_proc_level

301:
302: BEGIN
303: IF (l_proc_level >= l_dbg_level)
304: THEN
305: FND_LOG.String( l_proc_level
306: ,l_module_prefix||'.'||l_proc_name||'.begin'
307: ,'Enter procedure'
308: );
309:

Line 310: FND_LOG.String(l_proc_level

306: ,l_module_prefix||'.'||l_proc_name||'.begin'
307: ,'Enter procedure'
308: );
309:
310: FND_LOG.String(l_proc_level
311: ,l_module_prefix||'.'||l_proc_name||'.parameters'
312: ,'invoice_distribution_id'||p_invoice_distribution_id
313: );
314:

Line 328: FND_LOG.String( l_proc_level

324: EXCEPTION
325: WHEN OTHERS THEN
326: IF (l_proc_level >= l_dbg_level)
327: THEN
328: FND_LOG.String( l_proc_level
329: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
330: ,SQLCODE||':'||SQLERRM);
331: END IF; --(l_proc_level >= l_dbg_level)
332: IF Expense_Item_desc IS NULL THEN

Line 366: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

362: RETURN VARCHAR2 IS
363: MASTER_ITEM VARCHAR(100):=null;
364: L_INVOICE_LINE_NUMBER NUMBER;
365: L_INVOICE_ID NUMBER;
366: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
367: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;
368: L_PROC_NAME VARCHAR2(100) :='MASTER_ITEM';
369: a EXCEPTION;
370:

Line 367: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;

363: MASTER_ITEM VARCHAR(100):=null;
364: L_INVOICE_LINE_NUMBER NUMBER;
365: L_INVOICE_ID NUMBER;
366: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
367: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;
368: L_PROC_NAME VARCHAR2(100) :='MASTER_ITEM';
369: a EXCEPTION;
370:
371:

Line 375: FND_LOG.String( l_proc_level

371:
372: BEGIN
373: IF (l_proc_level >= l_dbg_level)
374: THEN
375: FND_LOG.String( l_proc_level
376: ,l_module_prefix||'.'||l_proc_name||'.begin'
377: ,'Enter procedure'
378: );
379:

Line 380: FND_LOG.String(l_proc_level

376: ,l_module_prefix||'.'||l_proc_name||'.begin'
377: ,'Enter procedure'
378: );
379:
380: FND_LOG.String(l_proc_level
381: ,l_module_prefix||'.'||l_proc_name||'.parameters'
382: ,'p_invoice_distribution_id '||p_invoice_distribution_id
383: );
384:

Line 435: FND_LOG.String( l_proc_level

431:
432: WHEN OTHERS THEN
433: IF (l_proc_level >= l_dbg_level)
434: THEN
435: FND_LOG.String( l_proc_level
436: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
437: ,SQLCODE||':'||SQLERRM);
438: END IF; --(l_proc_level >= l_dbg_level)
439: IF MASTER_ITEM IS NULL THEN

Line 474: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

470: p_invoice_id IN NUMBER,
471: p_invoice_distribution_id IN NUMBER)
472: RETURN VARCHAR2 IS
473: Source_Value VARCHAR2(200):=NULL;
474: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
475: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
476: l_proc_name VARCHAR2(100) :='Invoice Category';
477: BEGIN
478:

Line 475: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

471: p_invoice_distribution_id IN NUMBER)
472: RETURN VARCHAR2 IS
473: Source_Value VARCHAR2(200):=NULL;
474: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
475: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
476: l_proc_name VARCHAR2(100) :='Invoice Category';
477: BEGIN
478:
479: IF (l_proc_level >= l_dbg_level)

Line 481: FND_LOG.String( l_proc_level

477: BEGIN
478:
479: IF (l_proc_level >= l_dbg_level)
480: THEN
481: FND_LOG.String( l_proc_level
482: ,l_module_prefix||'.'||l_proc_name||'.begin'
483: ,'Enter procedure'
484: );
485: FND_LOG.String( l_proc_level

Line 485: FND_LOG.String( l_proc_level

481: FND_LOG.String( l_proc_level
482: ,l_module_prefix||'.'||l_proc_name||'.begin'
483: ,'Enter procedure'
484: );
485: FND_LOG.String( l_proc_level
486: ,l_module_prefix||'.'||l_proc_name||'.parameters'
487: ,'p_Invoice_Source '||p_Invoice_Source
488: );
489: FND_LOG.String( l_proc_level

Line 489: FND_LOG.String( l_proc_level

485: FND_LOG.String( l_proc_level
486: ,l_module_prefix||'.'||l_proc_name||'.parameters'
487: ,'p_Invoice_Source '||p_Invoice_Source
488: );
489: FND_LOG.String( l_proc_level
490: ,l_module_prefix||'.'||l_proc_name||'.parameters'
491: ,'p_invoice_id '||p_invoice_id
492: );
493:

Line 494: FND_LOG.String(l_proc_level

490: ,l_module_prefix||'.'||l_proc_name||'.parameters'
491: ,'p_invoice_id '||p_invoice_id
492: );
493:
494: FND_LOG.String(l_proc_level
495: ,l_module_prefix||'.'||l_proc_name||'.parameters'
496: ,'p_invoice_distribution_id'||p_invoice_distribution_id
497: );
498:

Line 533: FND_LOG.STRING(l_proc_level,

529: END CASE ;
530:
531: IF (l_proc_level >= l_dbg_level)
532: THEN
533: FND_LOG.STRING(l_proc_level,
534: l_module_prefix|| '.' || l_proc_name || '.end',
535: 'end procedure');
536: END IF;
537: RETURN Source_Value;

Line 544: FND_LOG.String( l_proc_level

540: EXCEPTION
541: WHEN OTHERS THEN
542: IF (l_proc_level >= l_dbg_level)
543: THEN
544: FND_LOG.String( l_proc_level
545: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
546: ,SQLCODE||':'||SQLERRM);
547: END IF; --(l_proc_level >= l_dbg_level)
548:

Line 574: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

570:
571: FUNCTION GET_PROJECT_NUM(Project_id IN NUMBER)
572: RETURN VARCHAR2 IS
573: project_num PA_PROJECTS_ALL.Segment1%type:=null;
574: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
575: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
576: l_proc_name VARCHAR2(100) :='GET_PROJECT_NUM';
577: BEGIN
578:

Line 575: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

571: FUNCTION GET_PROJECT_NUM(Project_id IN NUMBER)
572: RETURN VARCHAR2 IS
573: project_num PA_PROJECTS_ALL.Segment1%type:=null;
574: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
575: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
576: l_proc_name VARCHAR2(100) :='GET_PROJECT_NUM';
577: BEGIN
578:
579: IF (l_proc_level >= l_dbg_level)

Line 581: FND_LOG.String( l_proc_level

577: BEGIN
578:
579: IF (l_proc_level >= l_dbg_level)
580: THEN
581: FND_LOG.String( l_proc_level
582: ,l_module_prefix||'.'||l_proc_name||'.begin'
583: ,'Enter procedure'
584: );
585: FND_LOG.String( l_proc_level

Line 585: FND_LOG.String( l_proc_level

581: FND_LOG.String( l_proc_level
582: ,l_module_prefix||'.'||l_proc_name||'.begin'
583: ,'Enter procedure'
584: );
585: FND_LOG.String( l_proc_level
586: ,l_module_prefix||'.'||l_proc_name||'.parameters'
587: ,'Project_id '||Project_id
588: );
589:

Line 610: FND_LOG.String( l_proc_level

606:
607: WHEN OTHERS THEN
608: IF (l_proc_level >= l_dbg_level)
609: THEN
610: FND_LOG.String( l_proc_level
611: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
612: ,SQLCODE||':'||SQLERRM);
613: END IF; --(l_proc_level >= l_dbg_level)
614: RETURN NULL;