[Home] [Help]
74: l_parameter_val VARCHAR2(240);
75:
76:
77: --
78: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
79: --
80: BEGIN
81: OPEN parameter_value;
82: FETCH parameter_value INTO l_parameter_val;
85: RETURN NULL;
86: END IF;
87: CLOSE Parameter_value;
88: IF l_debug_level > 0 THEN
89: oe_debug_pub.add( 'VALUE FROM DB'||l_parameter_val , 1 ) ;
90: END IF;
91: RETURN l_parameter_val;
92:
93: END Get_Value_From_Db;
129: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
130: l_table_index BINARY_INTEGER;
131:
132: --
133: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
134: --
135: BEGIN
136: IF l_debug_level > 0 THEN
137: oe_debug_pub.add( 'ENTERING OE_SYS_PARAMETERS_PVT.VALUE '||p_org_id , 1 ) ;
133: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
134: --
135: BEGIN
136: IF l_debug_level > 0 THEN
137: oe_debug_pub.add( 'ENTERING OE_SYS_PARAMETERS_PVT.VALUE '||p_org_id , 1 ) ;
138: END IF;
139:
140: IF p_org_id IS NULL THEN
141:
296: END IF;
297: */
298: --recurring charges parameters --------------------------------------
299: ELSIF l_param_code = 'RECURRING_CHARGES' THEN
300: oe_debug_pub.add('Inside RCAPPS');
301: -- R12.MOAC
302: l_parameter_value := NVL(find(l_param_code,l_org_id),'N');
303: RETURN(l_parameter_value);
304: /*
302: l_parameter_value := NVL(find(l_param_code,l_org_id),'N');
303: RETURN(l_parameter_value);
304: /*
305: IF l_org_id = g_org_id AND g_recurring_charges IS NOT NULL THEN
306: oe_debug_pub.add('Recur Enabled1:'||g_recurring_charges);
307: RETURN (g_recurring_charges);
308: ELSE
309: l_parameter_value:=NVL(Get_Value_From_DB('RECURRING_CHARGES',l_org_id),'N');
310: g_org_id := l_org_id;
308: ELSE
309: l_parameter_value:=NVL(Get_Value_From_DB('RECURRING_CHARGES',l_org_id),'N');
310: g_org_id := l_org_id;
311: g_recurring_charges := l_parameter_value;
312: oe_debug_pub.add('Recur Enabled2:'||g_recurring_charges);
313: RETURN (g_recurring_charges);
314: END IF;
315: */
316: -- recurring charges paramaters END ---------------------------------
351: IF l_org_id = g_org_id THEN
352: l_table_index := find(l_param_code);
353: IF l_table_index < TABLE_SIZE THEN
354: IF l_debug_level > 0 THEN
355: oe_debug_pub.add( ' 1 Parameter Value: '||Val_Tab(l_table_index),1);
356: END IF;
357: RETURN (Val_Tab(l_table_index));
358: ELSE
359: put(l_param_code,l_org_id,l_parameter_value);
357: RETURN (Val_Tab(l_table_index));
358: ELSE
359: put(l_param_code,l_org_id,l_parameter_value);
360: IF l_debug_level > 0 THEN
361: oe_debug_pub.add( '2 PARAMETER VALUE: '||l_parameter_value,1);
362: END IF;
363: RETURN (l_parameter_value);
364: END IF;
365: ELSE -- org id changed
365: ELSE -- org id changed
366: put(l_param_code,l_org_id,l_parameter_value);
367: g_org_id := l_org_id;
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add( '3 PARAMETER VALUE: '||l_parameter_value,1);
370: END IF;
371: RETURN (l_parameter_value);
372: END IF;
373: */
371: RETURN (l_parameter_value);
372: END IF;
373: */
374: IF l_debug_level > 0 THEN
375: oe_debug_pub.add( ' PARAMETER VALUE: '||l_parameter_value,1);
376: END IF;
377: RETURN (l_parameter_value);
378: END IF;
379:
377: RETURN (l_parameter_value);
378: END IF;
379:
380: IF l_debug_level > 0 THEN
381: oe_debug_pub.add( 'EXITING OE_SYS_PARAMETERS_PVT.VALUE' , 1 ) ;
382: END IF;
383: RETURN(NULL);
384:
385: EXCEPTION
384:
385: EXCEPTION
386: WHEN FND_API.G_EXC_ERROR THEN
387: IF l_debug_level > 0 THEN
388: oe_debug_pub.add( 'EXPECTED ERROR IN VALUE FUNCTION' ,1);
389: END IF;
390: RAISE FND_API.G_EXC_ERROR;
391:
392: WHEN NO_DATA_FOUND THEN
418: l_found BOOLEAN;
419: l_hash_value NUMBER;
420:
421: --
422: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
423: --
424: BEGIN
425: /*R12.MOAC*/
426: IF val_tab.EXISTS(p_parameter_code||'ORG'||to_char(p_org_id)) THEN
424: BEGIN
425: /*R12.MOAC*/
426: IF val_tab.EXISTS(p_parameter_code||'ORG'||to_char(p_org_id)) THEN
427: IF l_debug_level > 0 THEN
428: oe_debug_pub.add( 'Parameter value exists. ' , 1 ) ;
429: END IF;
430: RETURN val_tab(p_parameter_code||'ORG'||to_char(p_org_id));
431: ELSE
432: val_tab(p_parameter_code||'ORG'||to_char(p_org_id)) :=
431: ELSE
432: val_tab(p_parameter_code||'ORG'||to_char(p_org_id)) :=
433: get_value_from_db(p_parameter_code,p_org_id);
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add( 'Parameter value fetched from table. ' , 1 ) ;
436: END IF;
437: RETURN val_tab(p_parameter_code||'ORG'||to_char(p_org_id));
438: END IF;
439: EXCEPTION
456: l_org_id NUMBER;
457: l_chk_clt_info NUMBER;
458:
459: --
460: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
461: --
462: BEGIN
463:
464: IF l_debug_level > 0 THEN
461: --
462: BEGIN
463:
464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add( 'ENTERING OE_SYS_PARAMETERS_PVT.GET_AR_SYS_PARAMS ... ' , 1 ) ;
466: END IF;
467:
468: IF p_org_id IS NULL THEN
469:
467:
468: IF p_org_id IS NULL THEN
469:
470: IF l_debug_level > 0 THEN
471: oe_debug_pub.add( 'Org Id is null .. Querying for Org Id .. ' , 1 ) ;
472: END IF;
473:
474: /*
475:
502: l_org_id := p_org_id;
503: END IF;
504: IF G_AR_Sys_Param_Tbl.exists(l_org_id) THEN
505: IF l_debug_level > 0 THEN
506: oe_debug_pub.add( 'Getting the AR details from the cache .. ' , 1 ) ;
507: END IF;
508: RETURN G_AR_Sys_Param_Tbl(l_org_id);
509: ELSE
510: IF l_debug_level > 0 THEN
507: END IF;
508: RETURN G_AR_Sys_Param_Tbl(l_org_id);
509: ELSE
510: IF l_debug_level > 0 THEN
511: oe_debug_pub.add( 'Querying the table for the AR details .. ' , 1 ) ;
512: END IF;
513: /* MOAC_SQL_CHANGE */
514: SELECT *
515: INTO
528:
529: EXCEPTION
530:
531: WHEN NO_DATA_FOUND THEN
532: oe_debug_pub.add( 'In No Data Found Exception .. ' , 1 ) ;
533: RETURN(NULL);
534:
535: WHEN OTHERS THEN
536: oe_debug_pub.add( 'In Others Exception .. ' , 1 ) ;
532: oe_debug_pub.add( 'In No Data Found Exception .. ' , 1 ) ;
533: RETURN(NULL);
534:
535: WHEN OTHERS THEN
536: oe_debug_pub.add( 'In Others Exception .. ' , 1 ) ;
537: RETURN(NULL);
538:
539: END Get_AR_Sys_Params;
540: