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: --===========================================================================
42: FUNCTION Refund_Item(p_invoice_id IN NUMBER)
43: RETURN VARCHAR2 IS
44: l_refund_item VARCHAR2(10) := '';
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) :='Refund_Item';
48:
49: BEGIN

Line 46: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

42: FUNCTION Refund_Item(p_invoice_id IN NUMBER)
43: RETURN VARCHAR2 IS
44: l_refund_item VARCHAR2(10) := '';
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) :='Refund_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 77: FND_LOG.String( l_proc_level

73:
74: WHEN OTHERS THEN
75: IF (l_proc_level >= l_dbg_level)
76: THEN
77: FND_LOG.String( l_proc_level
78: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
79: ,SQLCODE||':'||SQLERRM);
80: END IF; --(l_proc_level >= l_dbg_level)
81: RAISE;

Line 107: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

103: FUNCTION GDF_Item(p_invoice_id IN NUMBER,
104: p_invoice_distribution_id IN NUMBER)
105: RETURN VARCHAR2 IS
106: GDF_Item ap_invoice_distributions_all.global_attribute1%type:=null;
107: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
108: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
109: l_proc_name VARCHAR2(100) :='GDF_Item';
110:
111: BEGIN

Line 108: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

104: p_invoice_distribution_id IN NUMBER)
105: RETURN VARCHAR2 IS
106: GDF_Item ap_invoice_distributions_all.global_attribute1%type:=null;
107: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
108: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
109: l_proc_name VARCHAR2(100) :='GDF_Item';
110:
111: BEGIN
112: IF (l_proc_level >= l_dbg_level)

Line 114: FND_LOG.String( l_proc_level

110:
111: BEGIN
112: IF (l_proc_level >= l_dbg_level)
113: THEN
114: FND_LOG.String( l_proc_level
115: ,l_module_prefix||'.'||l_proc_name||'.begin'
116: ,'Enter procedure'
117: );
118: FND_LOG.String( l_proc_level

Line 118: FND_LOG.String( l_proc_level

114: FND_LOG.String( l_proc_level
115: ,l_module_prefix||'.'||l_proc_name||'.begin'
116: ,'Enter procedure'
117: );
118: FND_LOG.String( l_proc_level
119: ,l_module_prefix||'.'||l_proc_name||'.parameters'
120: ,'p_invoice_id '||p_invoice_id
121: );
122:

Line 123: FND_LOG.String(l_proc_level

119: ,l_module_prefix||'.'||l_proc_name||'.parameters'
120: ,'p_invoice_id '||p_invoice_id
121: );
122:
123: FND_LOG.String(l_proc_level
124: ,l_module_prefix||'.'||l_proc_name||'.parameters'
125: ,'p_invoice_distribution_id'||p_invoice_distribution_id
126: );
127:

Line 155: FND_LOG.String( l_proc_level

151:
152: WHEN OTHERS THEN
153: IF (l_proc_level >= l_dbg_level)
154: THEN
155: FND_LOG.String( l_proc_level
156: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
157: ,SQLCODE||':'||SQLERRM);
158: END IF; --(l_proc_level >= l_dbg_level)
159: RAISE;

Line 192: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

188: --new variable
189: L_PO_HEADER_ID NUMBER;
190: L_PO_LINE_ID NUMBER;
191: --
192: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
193: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;
194: L_PROC_NAME VARCHAR2(100) :='MASTER_ITEM';
195: a EXCEPTION;
196:

Line 193: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;

189: L_PO_HEADER_ID NUMBER;
190: L_PO_LINE_ID NUMBER;
191: --
192: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
193: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;
194: L_PROC_NAME VARCHAR2(100) :='MASTER_ITEM';
195: a EXCEPTION;
196:
197:

Line 201: FND_LOG.String( l_proc_level

197:
198: BEGIN
199: IF (l_proc_level >= l_dbg_level)
200: THEN
201: FND_LOG.String( l_proc_level
202: ,l_module_prefix||'.'||l_proc_name||'.begin'
203: ,'Enter procedure'
204: );
205:

Line 206: FND_LOG.String(l_proc_level

202: ,l_module_prefix||'.'||l_proc_name||'.begin'
203: ,'Enter procedure'
204: );
205:
206: FND_LOG.String(l_proc_level
207: ,l_module_prefix||'.'||l_proc_name||'.parameters'
208: ,'p_invoice_distribution_id '||p_invoice_distribution_id
209: );
210:

Line 321: FND_LOG.String( l_proc_level

317:
318: WHEN OTHERS THEN
319: IF (l_proc_level >= l_dbg_level)
320: THEN
321: FND_LOG.String( l_proc_level
322: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
323: ,SQLCODE||':'||SQLERRM);
324: END IF; --(l_proc_level >= l_dbg_level)
325: IF MASTER_ITEM IS NULL THEN

Line 360: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

356: FUNCTION Expense_Item(P_INVOICE_ID IN NUMBER,
357: p_invoice_distribution_id IN NUMBER)
358: RETURN VARCHAR2 IS
359: Expense_Item_desc ap_invoice_distributions_all.description%type:=null;
360: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
361: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
362: l_proc_name VARCHAR2(100) :='Expense_Item';
363:
364: BEGIN

Line 361: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

357: p_invoice_distribution_id IN NUMBER)
358: RETURN VARCHAR2 IS
359: Expense_Item_desc ap_invoice_distributions_all.description%type:=null;
360: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
361: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
362: l_proc_name VARCHAR2(100) :='Expense_Item';
363:
364: BEGIN
365: IF (l_proc_level >= l_dbg_level)

Line 367: FND_LOG.String( l_proc_level

363:
364: BEGIN
365: IF (l_proc_level >= l_dbg_level)
366: THEN
367: FND_LOG.String( l_proc_level
368: ,l_module_prefix||'.'||l_proc_name||'.begin'
369: ,'Enter procedure'
370: );
371:

Line 372: FND_LOG.String(l_proc_level

368: ,l_module_prefix||'.'||l_proc_name||'.begin'
369: ,'Enter procedure'
370: );
371:
372: FND_LOG.String(l_proc_level
373: ,l_module_prefix||'.'||l_proc_name||'.parameters'
374: ,'invoice_distribution_id'||p_invoice_distribution_id
375: );
376:

Line 390: FND_LOG.String( l_proc_level

386: EXCEPTION
387: WHEN OTHERS THEN
388: IF (l_proc_level >= l_dbg_level)
389: THEN
390: FND_LOG.String( l_proc_level
391: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
392: ,SQLCODE||':'||SQLERRM);
393: END IF; --(l_proc_level >= l_dbg_level)
394: IF Expense_Item_desc IS NULL THEN

Line 428: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

424: RETURN VARCHAR2 IS
425: MASTER_ITEM VARCHAR(100):=null;
426: L_INVOICE_LINE_NUMBER NUMBER;
427: L_INVOICE_ID NUMBER;
428: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
429: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;
430: L_PROC_NAME VARCHAR2(100) :='MASTER_ITEM';
431: a EXCEPTION;
432:

Line 429: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;

425: MASTER_ITEM VARCHAR(100):=null;
426: L_INVOICE_LINE_NUMBER NUMBER;
427: L_INVOICE_ID NUMBER;
428: L_DBG_LEVEL NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
429: L_PROC_LEVEL NUMBER :=FND_LOG.LEVEL_PROCEDURE;
430: L_PROC_NAME VARCHAR2(100) :='MASTER_ITEM';
431: a EXCEPTION;
432:
433:

Line 437: FND_LOG.String( l_proc_level

433:
434: BEGIN
435: IF (l_proc_level >= l_dbg_level)
436: THEN
437: FND_LOG.String( l_proc_level
438: ,l_module_prefix||'.'||l_proc_name||'.begin'
439: ,'Enter procedure'
440: );
441:

Line 442: FND_LOG.String(l_proc_level

438: ,l_module_prefix||'.'||l_proc_name||'.begin'
439: ,'Enter procedure'
440: );
441:
442: FND_LOG.String(l_proc_level
443: ,l_module_prefix||'.'||l_proc_name||'.parameters'
444: ,'p_invoice_distribution_id '||p_invoice_distribution_id
445: );
446:

Line 497: FND_LOG.String( l_proc_level

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

Line 536: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

532: p_invoice_id IN NUMBER,
533: p_invoice_distribution_id IN NUMBER)
534: RETURN VARCHAR2 IS
535: Source_Value VARCHAR2(200):=NULL;
536: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
537: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
538: l_proc_name VARCHAR2(100) :='Invoice Category';
539: BEGIN
540:

Line 537: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

533: p_invoice_distribution_id IN NUMBER)
534: RETURN VARCHAR2 IS
535: Source_Value VARCHAR2(200):=NULL;
536: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
537: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
538: l_proc_name VARCHAR2(100) :='Invoice Category';
539: BEGIN
540:
541: IF (l_proc_level >= l_dbg_level)

Line 543: FND_LOG.String( l_proc_level

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

Line 547: FND_LOG.String( l_proc_level

543: FND_LOG.String( l_proc_level
544: ,l_module_prefix||'.'||l_proc_name||'.begin'
545: ,'Enter procedure'
546: );
547: FND_LOG.String( l_proc_level
548: ,l_module_prefix||'.'||l_proc_name||'.parameters'
549: ,'p_Invoice_Source '||p_Invoice_Source
550: );
551: FND_LOG.String( l_proc_level

Line 551: FND_LOG.String( l_proc_level

547: FND_LOG.String( l_proc_level
548: ,l_module_prefix||'.'||l_proc_name||'.parameters'
549: ,'p_Invoice_Source '||p_Invoice_Source
550: );
551: FND_LOG.String( l_proc_level
552: ,l_module_prefix||'.'||l_proc_name||'.parameters'
553: ,'p_invoice_id '||p_invoice_id
554: );
555:

Line 556: FND_LOG.String(l_proc_level

552: ,l_module_prefix||'.'||l_proc_name||'.parameters'
553: ,'p_invoice_id '||p_invoice_id
554: );
555:
556: FND_LOG.String(l_proc_level
557: ,l_module_prefix||'.'||l_proc_name||'.parameters'
558: ,'p_invoice_distribution_id'||p_invoice_distribution_id
559: );
560:

Line 600: FND_LOG.STRING(l_proc_level,

596: END CASE ;
597:
598: IF (l_proc_level >= l_dbg_level)
599: THEN
600: FND_LOG.STRING(l_proc_level,
601: l_module_prefix|| '.' || l_proc_name || '.end',
602: 'end procedure');
603: END IF;
604: RETURN Source_Value;

Line 611: FND_LOG.String( l_proc_level

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

Line 641: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

637: --===========================================================================
638: FUNCTION Invoice_GainLoss_Category(p_invoice_payment_id IN NUMBER)
639: RETURN VARCHAR2 IS
640: Source_Value VARCHAR2(200):=NULL;
641: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
642: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
643: l_proc_name VARCHAR2(100) :='Invoice_Payment_Category';
644: ln_invoice_id NUMBER;
645: lv_invoice_source VARCHAR2(100);

Line 642: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

638: FUNCTION Invoice_GainLoss_Category(p_invoice_payment_id IN NUMBER)
639: RETURN VARCHAR2 IS
640: Source_Value VARCHAR2(200):=NULL;
641: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
642: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
643: l_proc_name VARCHAR2(100) :='Invoice_Payment_Category';
644: ln_invoice_id NUMBER;
645: lv_invoice_source VARCHAR2(100);
646: BEGIN

Line 650: FND_LOG.String( l_proc_level

646: BEGIN
647:
648: IF (l_proc_level >= l_dbg_level)
649: THEN
650: FND_LOG.String( l_proc_level
651: ,l_module_prefix||'.'||l_proc_name||'.begin'
652: ,'Enter procedure'
653: );
654: FND_LOG.String( l_proc_level

Line 654: FND_LOG.String( l_proc_level

650: FND_LOG.String( l_proc_level
651: ,l_module_prefix||'.'||l_proc_name||'.begin'
652: ,'Enter procedure'
653: );
654: FND_LOG.String( l_proc_level
655: ,l_module_prefix||'.'||l_proc_name||'.parameters'
656: ,'p_Invoice_Source '||p_invoice_payment_id
657: );
658: END IF; --(l_proc_level >= l_dbg_level)

Line 706: FND_LOG.String( l_proc_level

702: EXCEPTION
703: WHEN OTHERS THEN
704: IF (l_proc_level >= l_dbg_level)
705: THEN
706: FND_LOG.String( l_proc_level
707: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
708: ,SQLCODE||':'||SQLERRM);
709: END IF; --(l_proc_level >= l_dbg_level)
710: RETURN 'EXCEPTION';

Line 720: FND_LOG.String( l_proc_level

716: EXCEPTION
717: WHEN OTHERS THEN
718: IF (l_proc_level >= l_dbg_level)
719: THEN
720: FND_LOG.String( l_proc_level
721: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
722: ,SQLCODE||':'||SQLERRM);
723: END IF; --(l_proc_level >= l_dbg_level)
724: RETURN 'EXCEPTION';

Line 749: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

745:
746: FUNCTION GET_PROJECT_NUM(p_project_id IN NUMBER) --Fixing bug#8478003
747: RETURN VARCHAR2 IS
748: l_project_num PA_PROJECTS_ALL.Segment1%type:=null;
749: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
750: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
751: l_proc_name VARCHAR2(100) :='GET_PROJECT_NUM';
752: BEGIN
753:

Line 750: l_proc_level NUMBER :=FND_LOG.Level_Procedure;

746: FUNCTION GET_PROJECT_NUM(p_project_id IN NUMBER) --Fixing bug#8478003
747: RETURN VARCHAR2 IS
748: l_project_num PA_PROJECTS_ALL.Segment1%type:=null;
749: l_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
750: l_proc_level NUMBER :=FND_LOG.Level_Procedure;
751: l_proc_name VARCHAR2(100) :='GET_PROJECT_NUM';
752: BEGIN
753:
754: IF (l_proc_level >= l_dbg_level)

Line 756: FND_LOG.String( l_proc_level

752: BEGIN
753:
754: IF (l_proc_level >= l_dbg_level)
755: THEN
756: FND_LOG.String( l_proc_level
757: ,l_module_prefix||'.'||l_proc_name||'.begin'
758: ,'Enter procedure'
759: );
760: FND_LOG.String( l_proc_level

Line 760: FND_LOG.String( l_proc_level

756: FND_LOG.String( l_proc_level
757: ,l_module_prefix||'.'||l_proc_name||'.begin'
758: ,'Enter procedure'
759: );
760: FND_LOG.String( l_proc_level
761: ,l_module_prefix||'.'||l_proc_name||'.parameters'
762: ,'Project_id '||p_project_id
763: );
764:

Line 783: FND_LOG.String( l_proc_level

779:
780: WHEN OTHERS THEN
781: IF (l_proc_level >= l_dbg_level)
782: THEN
783: FND_LOG.String( l_proc_level
784: ,l_module_prefix||'.'||l_proc_name||'.Other_Exception '
785: ,SQLCODE||':'||SQLERRM);
786: END IF; --(l_proc_level >= l_dbg_level)
787: RETURN NULL;