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.PA_UTILS2 dependencies on PA_UTILS

Line 1: PACKAGE BODY PA_UTILS2 AS

1: PACKAGE BODY PA_UTILS2 AS
2: /* $Header: PAXGUT2B.pls 120.26.12020000.4 2013/03/06 09:49:17 admarath ship $ */
3:
4: -- FUNCTION get_period_name /*2835063*/
5: FUNCTION get_period_name RETURN pa_cost_distribution_lines_all.pa_period_name%TYPE is

Line 814: /**This function was previously part-of pa_utils.

810: -- ignored. However, it is still retained as a parameter in case the
811: -- logic for the derivation of the PA date is changed on a later date.
812: -----------------------------------------------------------------------
813:
814: /**This function was previously part-of pa_utils.
815: **It was moved here and changed for CBGA and caching.
816: **/
817:
818: FUNCTION get_pa_date( p_ei_date IN date, p_gl_date IN date, p_org_id IN number) return date

Line 887: pa_utils2.refresh_pa_cache( p_org_id , p_ei_date, 'P' );

883: -- If control comes here, it means that either the cache is empty or
884: -- the provider Cache is not reusable.
885: -- Access the DB and refresh cache and return pa_date.
886:
887: pa_utils2.refresh_pa_cache( p_org_id , p_ei_date, 'P' );
888: /*
889: * Here we can return g_prvdr_pa_date - because the profile option
890: * is taken care during the refresh_pa_cache.
891: */

Line 913: 'Y', pa_utils2.get_pa_date( exp_item_date,accounting_date,org_id),

909: END IF;
910:
911: /* Commented and added the following code as part of 10359385
912: SELECT decode(nvl(g_profile_value,'N'),
913: 'Y', pa_utils2.get_pa_date( exp_item_date,accounting_date,org_id),
914: 'N', pa_integration.get_raw_cdl_pa_date(exp_item_date,accounting_date,org_id))
915: INTO l_return_date
916: FROM DUAL;
917: */

Line 920: l_return_date:= pa_utils2.get_pa_date( exp_item_date,accounting_date,org_id);

916: FROM DUAL;
917: */
918: IF nvl(g_profile_value,'N') ='Y'
919: THEN
920: l_return_date:= pa_utils2.get_pa_date( exp_item_date,accounting_date,org_id);
921: ELSE
922: l_return_date:= pa_integration.get_raw_cdl_pa_date(exp_item_date,accounting_date,org_id);
923: END IF;
924: RETURN l_return_date;

Line 938: 'Y', pa_utils2.get_period_name(),

934: END IF;
935:
936: /* Commented and added the following code as part of 10359385
937: SELECT decode(nvl(g_profile_value,'N'),
938: 'Y', pa_utils2.get_period_name(),
939: 'N', pa_integration.get_period_name())
940: INTO l_return_name
941: FROM DUAL;
942: */

Line 945: l_return_name := pa_utils2.get_period_name();

941: FROM DUAL;
942: */
943: IF nvl(g_profile_value,'N') ='Y'
944: THEN
945: l_return_name := pa_utils2.get_period_name();
946: ELSE
947: l_return_name := pa_integration.get_period_name();
948: END IF;
949: RETURN l_return_name;

Line 1115: pa_utils2.refresh_pa_cache ( p_org_id , p_ei_date , 'R' );

1111: **hence hit the DB and populate/refresh receiver cache.
1112: **then return g_recvr_pa_date.
1113: **/
1114:
1115: pa_utils2.refresh_pa_cache ( p_org_id , p_ei_date , 'R' );
1116: return ( g_recvr_pa_date ) ;
1117: EXCEPTION
1118: WHEN OTHERS THEN
1119: RAISE ;

Line 1373: CDL.GL_PERIOD_NAME = pa_utils2.get_gl_period_name (l_prvdr_accr_date,CDL.org_id)

1369: );
1370:
1371: UPDATE PA_Cost_Distribution_lines CDL
1372: SET CDL.GL_DATE = l_prvdr_accr_date,
1373: CDL.GL_PERIOD_NAME = pa_utils2.get_gl_period_name (l_prvdr_accr_date,CDL.org_id)
1374: WHERE CDL.EXPENDITURE_ITEM_ID = l_exp_item_id
1375: AND CDL.LINE_NUM_REVERSED IS NULL
1376: AND CDL.TRANSFER_STATUS_CODE in ('P','R','G');
1377:

Line 1426: * ,CDL.GL_Date = ( SELECT pa_utils2.get_prvdr_gl_date(

1422: * -- Calling this procedure from pro*C requires some array related processing which
1423: * -- can be avoided if this procedure is not called from pro*C. This change has to
1424: * -- be done - at some point of time.
1425: *
1426: * ,CDL.GL_Date = ( SELECT pa_utils2.get_prvdr_gl_date(
1427: * MAX(CDL.pa_date)
1428: * ,p_application_id(i)
1429: * ,p_prvdr_sob_id(i))
1430: * FROM pa_cost_distribution_lines CDL,

Line 1436: * ,CDL.Recvr_Gl_Date = ( SELECT pa_utils2.get_recvr_gl_date(

1432: * WHERE ITEM.expenditure_item_id = CDL.expenditure_item_id
1433: * AND CDL.line_type = 'R'
1434: * AND ITEM.expenditure_id = p_expnd_id(i)
1435: * )
1436: * ,CDL.Recvr_Gl_Date = ( SELECT pa_utils2.get_recvr_gl_date(
1437: * MAX(CDL.recvr_pa_date)
1438: * ,p_application_id(i)
1439: * ,p_recvr_sob_id(i))
1440: * FROM pa_cost_distribution_lines CDL,

Line 1489: pa_utils2.get_prvdr_gl_date(

1485:
1486:
1487: BEGIN
1488: Select
1489: pa_utils2.get_prvdr_gl_date(
1490: CDL.gl_date
1491: ,p_application_id(i)
1492: ,p_prvdr_sob_id(i)) gl_date,
1493: pa_utils2.get_gl_period_name (

Line 1493: pa_utils2.get_gl_period_name (

1489: pa_utils2.get_prvdr_gl_date(
1490: CDL.gl_date
1491: ,p_application_id(i)
1492: ,p_prvdr_sob_id(i)) gl_date,
1493: pa_utils2.get_gl_period_name (
1494: pa_utils2.get_prvdr_gl_date(
1495: CDL.gl_date
1496: ,p_application_id(i)
1497: ,p_prvdr_sob_id(i))

Line 1494: pa_utils2.get_prvdr_gl_date(

1490: CDL.gl_date
1491: ,p_application_id(i)
1492: ,p_prvdr_sob_id(i)) gl_date,
1493: pa_utils2.get_gl_period_name (
1494: pa_utils2.get_prvdr_gl_date(
1495: CDL.gl_date
1496: ,p_application_id(i)
1497: ,p_prvdr_sob_id(i))
1498: ,CDL.org_id) gl_period_name,

Line 1499: pa_utils2.get_recvr_gl_date(

1495: CDL.gl_date
1496: ,p_application_id(i)
1497: ,p_prvdr_sob_id(i))
1498: ,CDL.org_id) gl_period_name,
1499: pa_utils2.get_recvr_gl_date(
1500: CDL.recvr_gl_date
1501: ,p_application_id(i)
1502: ,p_recvr_sob_id(i)) recvr_gl_date,
1503: pa_utils2.get_gl_period_name (

Line 1503: pa_utils2.get_gl_period_name (

1499: pa_utils2.get_recvr_gl_date(
1500: CDL.recvr_gl_date
1501: ,p_application_id(i)
1502: ,p_recvr_sob_id(i)) recvr_gl_date,
1503: pa_utils2.get_gl_period_name (
1504: pa_utils2.get_recvr_gl_date(
1505: CDL.recvr_gl_date
1506: ,p_application_id(i)
1507: ,p_recvr_sob_id(i))

Line 1504: pa_utils2.get_recvr_gl_date(

1500: CDL.recvr_gl_date
1501: ,p_application_id(i)
1502: ,p_recvr_sob_id(i)) recvr_gl_date,
1503: pa_utils2.get_gl_period_name (
1504: pa_utils2.get_recvr_gl_date(
1505: CDL.recvr_gl_date
1506: ,p_application_id(i)
1507: ,p_recvr_sob_id(i))
1508: ,nvl(EI.recvr_org_id,CDL.org_id)) recvr_gl_period_name,

Line 2007: pa_utils2.refresh_gl_cache( p_reference_date,

2003:
2004: /*Added for bug 4277525 -Start */
2005: IF g_prvdr_gl_date IS NULL OR g_prvdr_gl_period_name IS null
2006: then
2007: pa_utils2.refresh_gl_cache( p_reference_date,
2008: p_application_id,
2009: p_set_of_books_id,
2010: 'P'
2011: );

Line 2048: pa_utils2.refresh_gl_cache( p_reference_date,

2044: -- 2. cache is empty or
2045: -- 3. the Cache is not reusable.
2046: -- Access the DB and refresh cache and return gl_date.
2047:
2048: pa_utils2.refresh_gl_cache( p_reference_date,
2049: p_application_id,
2050: p_set_of_books_id,
2051: 'P'
2052: );

Line 2173: pa_utils2.refresh_gl_cache ( p_reference_date,

2169: END IF ; -- sob
2170: END IF; -- g_r_earliest_gl_start_date
2171: END IF ; -- p_set_of_books_id
2172:
2173: pa_utils2.refresh_gl_cache ( p_reference_date,
2174: p_application_id,
2175: p_set_of_books_id,
2176: 'R');
2177: return ( g_recvr_gl_date ) ;

Line 2411: pa_utils2.refresh_gl_cache( p_pa_date,

2407: -- 2. cache is empty or
2408: -- 3. the Cache is not reusable.
2409: -- Access the DB and refresh cache and return gl_date.
2410:
2411: pa_utils2.refresh_gl_cache( p_pa_date,
2412: p_application_id,
2413: p_set_of_books_id,
2414: 'P'
2415: );

Line 2528: pa_debug.init_err_stack('pa_utils2.get_period_information');

2524: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2525: l_debug_mode := NVL(l_debug_mode, 'N');
2526: l_stage := 100;
2527: IF (l_debug_mode = 'Y') THEN
2528: pa_debug.init_err_stack('pa_utils2.get_period_information');
2529: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2530: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':From get_period_information';
2531: pa_debug.write_file(pa_debug.g_err_stage);
2532: END IF;

Line 2624: l_prvdr_gl_date := pa_utils2.get_prvdr_gl_date( p_reference_date => p_prvdr_raw_gl_date_l

2620: * gl_date for the burden CDL is derived based on the pa_date in the Raw CDL.
2621: */
2622: IF ( p_calling_module = 'CDL' AND p_prvdr_raw_gl_date_l IS NOT NULL )
2623: THEN
2624: l_prvdr_gl_date := pa_utils2.get_prvdr_gl_date( p_reference_date => p_prvdr_raw_gl_date_l
2625: ,p_application_id => l_pa_gl_app_id
2626: ,p_set_of_books_id => p_prvdr_sob_id
2627: );
2628: l_prvdr_gl_period_name := g_prvdr_gl_period_name;

Line 2633: l_recvr_gl_date := pa_utils2.get_recvr_gl_date( p_reference_date => p_recvr_raw_gl_date_l

2629: END IF; -- p_calling_module
2630:
2631: IF ( p_calling_module = 'CDL' AND p_recvr_raw_gl_date_l IS NOT NULL )
2632: THEN
2633: l_recvr_gl_date := pa_utils2.get_recvr_gl_date( p_reference_date => p_recvr_raw_gl_date_l
2634: ,p_application_id => l_pa_gl_app_id
2635: ,p_set_of_books_id => p_recvr_sob_id
2636: );
2637: l_recvr_gl_period_name := g_recvr_gl_period_name;

Line 2663: l_prvdr_gl_date := pa_utils2.get_prvdr_gl_date( p_reference_date => p_expenditure_item_date

2659: THEN
2660: l_app_id := l_pa_gl_app_id; /* Modified l_gl_app_id for Bug 6904977 */
2661: END IF;
2662:
2663: l_prvdr_gl_date := pa_utils2.get_prvdr_gl_date( p_reference_date => p_expenditure_item_date
2664: ,p_application_id => l_app_id
2665: ,p_set_of_books_id => p_prvdr_sob_id
2666: );
2667: l_prvdr_gl_period_name := g_prvdr_gl_period_name;

Line 2671: l_recvr_gl_date := pa_utils2.get_recvr_gl_date( p_reference_date => p_expenditure_item_date

2667: l_prvdr_gl_period_name := g_prvdr_gl_period_name;
2668:
2669: IF ( derive.receiver <> 'N' AND p_expenditure_item_date IS NOT NULL )
2670: THEN
2671: l_recvr_gl_date := pa_utils2.get_recvr_gl_date( p_reference_date => p_expenditure_item_date
2672: ,p_application_id => l_app_id
2673: ,p_set_of_books_id => p_recvr_sob_id
2674: );
2675: l_recvr_gl_period_name := g_recvr_gl_period_name;

Line 2697: l_prvdr_pa_date := pa_utils2.get_prvdr_gl_date( p_reference_date => p_expenditure_item_date

2693: */
2694: /*l_prvdr_pa_date := l_prvdr_gl_date;
2695: l_prvdr_pa_period_name := l_prvdr_gl_period_name;*/
2696: /*Commented the above code and added the below code for bug 7638790*/
2697: l_prvdr_pa_date := pa_utils2.get_prvdr_gl_date( p_reference_date => p_expenditure_item_date
2698: ,p_application_id => l_pa_gl_app_id
2699: ,p_set_of_books_id => p_prvdr_sob_id
2700: );
2701: l_prvdr_pa_period_name := g_prvdr_gl_period_name;

Line 2717: l_prvdr_pa_date := pa_utils2.get_pa_date( p_ei_date => p_prvdr_raw_pa_date_l

2713: IF (p_line_type <> 'R' AND p_system_linkage_function = 'VI')
2714: THEN
2715: IF ( p_prvdr_raw_pa_date_l IS NOT NULL )
2716: THEN
2717: l_prvdr_pa_date := pa_utils2.get_pa_date( p_ei_date => p_prvdr_raw_pa_date_l
2718: ,p_gl_date => SYSDATE
2719: ,p_org_id => p_prvdr_org_id
2720: );
2721: l_prvdr_pa_period_name := g_prvdr_pa_period_name;

Line 2726: l_prvdr_pa_date := pa_utils2.get_pa_date( p_ei_date => p_expenditure_item_date

2722: END IF;
2723: ELSE
2724: IF ( p_expenditure_item_date IS NOT NULL )
2725: THEN
2726: l_prvdr_pa_date := pa_utils2.get_pa_date( p_ei_date => p_expenditure_item_date
2727: ,p_gl_date => SYSDATE
2728: ,p_org_id => p_prvdr_org_id
2729: );
2730: l_prvdr_pa_period_name := g_prvdr_pa_period_name;

Line 2767: l_recvr_pa_date := pa_utils2.get_recvr_pa_date( p_ei_date => p_recvr_raw_pa_date_l

2763: IF (p_line_type <> 'R' AND p_system_linkage_function = 'VI')
2764: THEN
2765: IF ( derive.receiver <> 'N' AND p_recvr_raw_pa_date_l IS NOT NULL )
2766: THEN
2767: l_recvr_pa_date := pa_utils2.get_recvr_pa_date( p_ei_date => p_recvr_raw_pa_date_l
2768: ,p_gl_date => SYSDATE
2769: ,p_org_id => p_recvr_org_id
2770: );
2771: l_recvr_pa_period_name := g_recvr_pa_period_name;

Line 2776: l_recvr_pa_date := pa_utils2.get_recvr_pa_date( p_ei_date => p_expenditure_item_date

2772: END IF;
2773: ELSE
2774: IF ( derive.receiver <> 'N' AND p_expenditure_item_date IS NOT NULL )
2775: THEN
2776: l_recvr_pa_date := pa_utils2.get_recvr_pa_date( p_ei_date => p_expenditure_item_date
2777: ,p_gl_date => SYSDATE
2778: ,p_org_id => p_recvr_org_id
2779: );
2780: l_recvr_pa_period_name := g_recvr_pa_period_name;

Line 2798: l_prvdr_pa_date := pa_utils2.get_pa_date( p_ei_date => p_prvdr_raw_pa_date_l

2794: THEN
2795: -- this area has to be revisited.
2796: IF ( p_prvdr_raw_pa_date_l IS NOT NULL )
2797: THEN
2798: l_prvdr_pa_date := pa_utils2.get_pa_date( p_ei_date => p_prvdr_raw_pa_date_l
2799: ,p_gl_date => SYSDATE
2800: ,p_org_id => p_prvdr_org_id
2801: );
2802: l_prvdr_pa_period_name := g_prvdr_pa_period_name;

Line 2806: l_recvr_pa_date := pa_utils2.get_recvr_pa_date( p_ei_date => p_recvr_raw_pa_date_l

2802: l_prvdr_pa_period_name := g_prvdr_pa_period_name;
2803: END IF;
2804: IF ( derive.receiver <> 'N' AND p_recvr_raw_pa_date_l IS NOT NULL )
2805: THEN
2806: l_recvr_pa_date := pa_utils2.get_recvr_pa_date( p_ei_date => p_recvr_raw_pa_date_l
2807: ,p_gl_date => SYSDATE
2808: ,p_org_id => p_recvr_org_id
2809: );
2810: l_recvr_pa_period_name := g_recvr_pa_period_name;

Line 2815: l_prvdr_pa_date := pa_utils2.get_pa_date( p_ei_date => p_expenditure_item_date

2811: END IF; -- p_calling_module
2812: ELSE
2813: IF ( p_expenditure_item_date IS NOT NULL )
2814: THEN
2815: l_prvdr_pa_date := pa_utils2.get_pa_date( p_ei_date => p_expenditure_item_date
2816: ,p_gl_date => SYSDATE
2817: ,p_org_id => p_prvdr_org_id
2818: );
2819: l_prvdr_pa_period_name := g_prvdr_pa_period_name;

Line 2824: l_recvr_pa_date := pa_utils2.get_recvr_pa_date( p_ei_date => p_expenditure_item_date

2820: END IF;
2821:
2822: IF ( derive.receiver <> 'N' AND p_expenditure_item_date IS NOT NULL )
2823: THEN
2824: l_recvr_pa_date := pa_utils2.get_recvr_pa_date( p_ei_date => p_expenditure_item_date
2825: ,p_gl_date => SYSDATE
2826: ,p_org_id => p_recvr_org_id
2827: );
2828: l_recvr_pa_period_name := g_recvr_pa_period_name;

Line 2872: l_prvdr_gl_date := pa_utils2.get_prvdr_gl_date( p_reference_date => p_expenditure_item_date

2868: IF (p_calling_module = 'AR_INSTALLED_INVOICE' OR p_calling_module = 'AR_NOT_INSTALLED_INVOICE')
2869: THEN
2870: IF ( p_expenditure_item_date IS NOT NULL )
2871: THEN
2872: l_prvdr_gl_date := pa_utils2.get_prvdr_gl_date( p_reference_date => p_expenditure_item_date
2873: ,p_application_id => l_app_id
2874: ,p_set_of_books_id => p_prvdr_sob_id
2875: );
2876: l_prvdr_gl_period_name := g_prvdr_gl_period_name;

Line 2881: l_recvr_gl_date := pa_utils2.get_recvr_gl_date( p_reference_date => p_expenditure_item_date

2877: END IF;
2878:
2879: IF ( derive.receiver <> 'N' AND p_expenditure_item_date IS NOT NULL )
2880: THEN
2881: l_recvr_gl_date := pa_utils2.get_recvr_gl_date( p_reference_date => p_expenditure_item_date
2882: ,p_application_id => l_app_id
2883: ,p_set_of_books_id => p_recvr_sob_id
2884: );
2885: /* Code changes end for bug 2965043 */

Line 2891: l_prvdr_gl_date := pa_utils2.get_prvdr_gl_date( p_reference_date => l_prvdr_pa_date

2887: END IF;
2888: ELSE /*Bug# 3617395*/
2889: IF ( l_prvdr_pa_date IS NOT NULL )
2890: THEN
2891: l_prvdr_gl_date := pa_utils2.get_prvdr_gl_date( p_reference_date => l_prvdr_pa_date
2892: ,p_application_id => l_app_id
2893: ,p_set_of_books_id => p_prvdr_sob_id
2894: );
2895: l_prvdr_gl_period_name := g_prvdr_gl_period_name;

Line 2900: l_recvr_gl_date := pa_utils2.get_recvr_gl_date( p_reference_date => l_recvr_pa_date

2896: END IF;
2897:
2898: IF ( derive.receiver <> 'N' AND l_recvr_pa_date IS NOT NULL )
2899: THEN
2900: l_recvr_gl_date := pa_utils2.get_recvr_gl_date( p_reference_date => l_recvr_pa_date
2901: ,p_application_id => l_app_id
2902: ,p_set_of_books_id => p_recvr_sob_id
2903: );
2904: l_recvr_gl_period_name := g_recvr_gl_period_name;

Line 3052: pa_debug.init_err_stack('pa_utils2.get_ou_period_information');

3048: l_date_dummy DATE;
3049: l_name_dummy VARCHAR2(30);
3050: l_calling_module VARCHAR2(30) := NULL ;
3051: BEGIN
3052: pa_debug.init_err_stack('pa_utils2.get_ou_period_information');
3053:
3054: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3055: l_debug_mode := NVL(l_debug_mode, 'N');
3056:

Line 3078: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':Calling pa_utils2.get_period_information';

3074:
3075: l_stage := 200 ;
3076: IF ( l_debug_mode = 'Y' )
3077: THEN
3078: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':Calling pa_utils2.get_period_information';
3079: pa_debug.write_file(pa_debug.g_err_stage);
3080: END IF; -- debug
3081:
3082: pa_utils2.get_period_information

Line 3082: pa_utils2.get_period_information

3078: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':Calling pa_utils2.get_period_information';
3079: pa_debug.write_file(pa_debug.g_err_stage);
3080: END IF; -- debug
3081:
3082: pa_utils2.get_period_information
3083: ( p_expenditure_item_date => p_reference_date
3084: ,p_prvdr_org_id => l_org_id
3085: ,p_prvdr_sob_id => l_sob_id
3086: ,p_calling_module => l_calling_module

Line 3104: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':After call to pa_utils2.get_period_information';

3100:
3101: l_stage := 300 ;
3102: IF ( l_debug_mode = 'Y' )
3103: THEN
3104: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':After call to pa_utils2.get_period_information';
3105: pa_debug.write_file(pa_debug.g_err_stage);
3106: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':PA date [' || to_char(l_pa_date) || '] name [' || l_pa_period_name || ']';
3107: pa_debug.write_file(pa_debug.g_err_stage);
3108: pa_debug.g_err_stage := TO_CHAR(l_stage) || ':GL date [' || to_char(l_gl_date) || '] name [' || l_gl_period_name || ']';

Line 3676: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;

3672: END IF;
3673: return(NULL);
3674: WHEN OTHERS THEN
3675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3676: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
3677: raise;
3678: END;
3679:
3680:

Line 3739: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;

3735: return(l_rev_accr_dt);
3736: EXCEPTION
3737: WHEN OTHERS THEN
3738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3739: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
3740: RAISE;
3741: END;
3742: ----------------------------------------------------------------------------------------------------------------
3743: -- API : get_accrual_gl_dt_period

Line 3899: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;

3895: pa_debug.g_err_stage := 'get_accrual_gl_dt_period()-WO for ref dt- ['||to_char(p_reference_date)||']';
3896: IF ( l_debug_mode = 'Y' ) THEN
3897: pa_debug.write_file(pa_debug.g_err_stage);
3898: END IF;
3899: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
3900: raise;
3901: END;
3902: -- EPP Derivation.
3903: IF p_epp_flag = 'Y' THEN

Line 3966: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;

3962:
3963: EXCEPTION
3964: WHEN OTHERS THEN
3965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3966: x_error_stage := 'Procedure: Pa_Utils2.Get_Accrual_Period_Information() ::: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
3967: raise;
3968: END;
3969: ----------------------------------------------------------------------------------------------------------------
3970: -- API : get_accrual_period_information

Line 4103: pa_debug.init_err_stack('pa_utils2.get_accrual_period_information');

4099: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4100: l_debug_mode := NVL(l_debug_mode, 'N');
4101: pa_debug.g_err_stage :='From get_accrual_period_information';
4102: IF(l_debug_mode = 'Y') THEN
4103: pa_debug.init_err_stack('pa_utils2.get_accrual_period_information');
4104: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4105:
4106: pa_debug.write_file(pa_debug.g_err_stage);
4107: END IF;

Line 4186: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module

4182: x_error_stage := pa_debug.g_err_stage;
4183:
4184: --- Though this api returns the period name also, we don't make use of it at this stage.
4185: BEGIN
4186: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module
4187: ,p_reference_date => p_expenditure_item_date
4188: ,p_application_id => l_pa_gl_app_id
4189: ,p_set_of_books_id => p_prvdr_sob_id
4190: ,p_prvdr_recvr_flg => 'P'

Line 4223: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module

4219:
4220: -- Though we are not deriving the gl_period_name , this api is multi-function.
4221: -- It checks if the ei date is in an O/F period. This check is for RECVR.
4222: BEGIN
4223: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module
4224: ,p_reference_date => p_expenditure_item_date
4225: ,p_application_id => l_pa_gl_app_id
4226: ,p_set_of_books_id => p_recvr_sob_id
4227: ,p_prvdr_recvr_flg => 'R'

Line 4254: l_prvdr_accrual_date := pa_utils2.get_rev_accrual_date(p_calling_module => p_calling_module

4250: --- For REV EI, the accrual dates of the
4251: --- ORG EI are passed. Since its an IN OUT parameter, we read and write to the same parameter.
4252: --- For REV EI, the accrual date is the first/last day of the next O,F GL Period depending on EPP.
4253:
4254: l_prvdr_accrual_date := pa_utils2.get_rev_accrual_date(p_calling_module => p_calling_module
4255: ,p_reference_date =>x_prvdr_accrual_date
4256: ,p_application_id => l_pa_gl_app_id
4257: ,p_set_of_books_id => p_prvdr_sob_id
4258: ,p_prvdr_recvr_flg => 'P'

Line 4284: l_recvr_accrual_date := pa_utils2.get_rev_accrual_date( p_calling_module => p_calling_module

4280: END IF;
4281: x_error_stage := pa_debug.g_err_stage;
4282:
4283: ELSE
4284: l_recvr_accrual_date := pa_utils2.get_rev_accrual_date( p_calling_module => p_calling_module
4285: ,p_reference_date =>x_recvr_accrual_date
4286: ,p_application_id => l_pa_gl_app_id
4287: ,p_set_of_books_id => p_recvr_sob_id
4288: ,p_prvdr_recvr_flg => 'R'

Line 4346: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module

4342:
4343: --- We make use of the GL period name.
4344: --- This is just to check if the accrual date is still in an open period.
4345: BEGIN
4346: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module
4347: ,p_reference_date => x_prvdr_accrual_date
4348: ,p_application_id => l_pa_gl_app_id
4349: ,p_set_of_books_id => p_prvdr_sob_id
4350: ,p_prvdr_recvr_flg => 'P'

Line 4390: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module

4386: ELSE ----Do the check for O/F status.
4387:
4388: -- It checks if the accrual date is in an O/F period. This check is for RECVR.
4389: BEGIN
4390: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module
4391: ,p_reference_date => x_recvr_accrual_date
4392: ,p_application_id => l_pa_gl_app_id
4393: ,p_set_of_books_id => p_recvr_sob_id
4394: ,p_prvdr_recvr_flg => 'R'

Line 4443: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module

4439: pa_debug.write_file(pa_debug.g_err_stage);
4440: END IF;
4441: -- We need the Period name.
4442: BEGIN
4443: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module
4444: ,p_reference_date => l_prvdr_accrual_date
4445: ,p_application_id => l_pa_gl_app_id
4446: ,p_set_of_books_id => p_prvdr_sob_id
4447: ,p_prvdr_recvr_flg => 'P'

Line 4483: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module

4479: l_recvr_gl_period_name := l_prvdr_gl_period_name;
4480: l_recvr_gl_date := l_recvr_accrual_date;
4481: ELSE --- derive the recvr_accrual_date based on the ei date.
4482: BEGIN
4483: pa_utils2.get_accrual_gl_dt_period( p_calling_module => p_calling_module
4484: ,p_reference_date => p_expenditure_item_date
4485: ,p_application_id => l_pa_gl_app_id
4486: ,p_set_of_books_id => p_recvr_sob_id
4487: ,p_prvdr_recvr_flg => 'R'

Line 4508: l_prvdr_accrual_date := pa_utils2.get_rev_accrual_date(p_calling_module => p_calling_module

4504: --- For REV EI, the accrual dates of the
4505: --- ORG EI are passed. Since its an IN OUT parameter, we read and write to the same parameter.
4506: --- For REV EI, the accrual date is the first/last day of the next O,F GL Period depending on EPP.
4507:
4508: l_prvdr_accrual_date := pa_utils2.get_rev_accrual_date(p_calling_module => p_calling_module
4509: ,p_reference_date =>x_prvdr_accrual_date
4510: ,p_application_id => l_pa_gl_app_id
4511: ,p_set_of_books_id => p_prvdr_sob_id
4512: ,p_prvdr_recvr_flg => 'P'

Line 4545: l_recvr_accrual_date := pa_utils2.get_rev_accrual_date( p_calling_module => p_calling_module

4541: pa_debug.write_file(pa_debug.g_err_stage);
4542: END IF;
4543:
4544: ELSE
4545: l_recvr_accrual_date := pa_utils2.get_rev_accrual_date( p_calling_module => p_calling_module
4546: ,p_reference_date =>x_recvr_accrual_date
4547: ,p_application_id => l_pa_gl_app_id
4548: ,p_set_of_books_id => p_recvr_sob_id
4549: ,p_prvdr_recvr_flg => 'R'

Line 4590: pa_utils2.get_accrual_pa_dt_period( p_gl_period=>l_prvdr_gl_period_name

4586: IF p_adj_ei_id IS NULL THEN ------------ORG EI-------------------------{
4587:
4588: BEGIN
4589: --- Derive the org prvdr pa date and pa period.
4590: pa_utils2.get_accrual_pa_dt_period( p_gl_period=>l_prvdr_gl_period_name
4591: ,p_ei_date => p_expenditure_item_date
4592: ,p_org_id =>p_prvdr_org_id
4593: ,p_prvdr_recvr_flg => 'P'
4594: ,p_epp_flag => l_prof_new_gldate_derivation

Line 4625: pa_utils2.get_accrual_pa_dt_period( p_gl_period=>l_recvr_gl_period_name

4621: END IF;
4622: ELSE
4623: --- Derive the org recvr pa date and pa period.
4624: BEGIN
4625: pa_utils2.get_accrual_pa_dt_period( p_gl_period=>l_recvr_gl_period_name
4626: ,p_ei_date => p_expenditure_item_date
4627: ,p_org_id =>p_recvr_org_id
4628: ,p_prvdr_recvr_flg => 'R'
4629: ,p_epp_flag => l_prof_new_gldate_derivation

Line 4660: pa_utils2.get_accrual_pa_dt_period( p_gl_period=>l_prvdr_gl_period_name

4656: END IF;
4657: ----For Prvdr
4658: BEGIN
4659: --- Derive the org prvdr pa date and pa period.
4660: pa_utils2.get_accrual_pa_dt_period( p_gl_period=>l_prvdr_gl_period_name
4661: ,p_ei_date => p_expenditure_item_date
4662: ,p_org_id =>p_prvdr_org_id
4663: ,p_prvdr_recvr_flg => 'P'
4664: ,p_epp_flag => l_prof_new_gldate_derivation

Line 4697: pa_utils2.get_accrual_pa_dt_period( p_gl_period=>l_recvr_gl_period_name

4693: END IF;
4694: ELSE
4695: --- Derive the org recvr pa date and pa period.
4696: BEGIN
4697: pa_utils2.get_accrual_pa_dt_period( p_gl_period=>l_recvr_gl_period_name
4698: ,p_ei_date => p_expenditure_item_date
4699: ,p_org_id =>p_recvr_org_id
4700: ,p_prvdr_recvr_flg => 'R'
4701: ,p_epp_flag => l_prof_new_gldate_derivation

Line 4784: l_pa_date := pa_utils2.get_pa_date( p_ei_date => p_txn_date

4780: BEGIN
4781:
4782: IF ( p_txn_date IS NOT NULL )
4783: THEN
4784: l_pa_date := pa_utils2.get_pa_date( p_ei_date => p_txn_date
4785: ,p_gl_date => SYSDATE
4786: ,p_org_id => p_org_id
4787: );
4788: l_pa_period_name := g_prvdr_pa_period_name;

Line 4806: If p_transaction_source = pa_utils2.g_transaction_source Then

4802: l_allow_burden_flag pa_transaction_sources.allow_burden_flag%TYPE := 'N';
4803: BEGIN
4804: IF ( p_transaction_source IS NOT NULL )
4805: THEN
4806: If p_transaction_source = pa_utils2.g_transaction_source Then
4807: Return g_ts_allow_burden_flag;
4808:
4809: Else
4810:

Line 4816: pa_utils2.g_ts_allow_burden_flag := l_allow_burden_flag;

4812: into l_allow_burden_flag
4813: from pa_transaction_sources ts
4814: where ts.transaction_source = p_transaction_source;
4815:
4816: pa_utils2.g_ts_allow_burden_flag := l_allow_burden_flag;
4817: pa_utils2.g_transaction_source := p_transaction_source;
4818: RETURN l_allow_burden_flag;
4819: End If;
4820: ELSE

Line 4817: pa_utils2.g_transaction_source := p_transaction_source;

4813: from pa_transaction_sources ts
4814: where ts.transaction_source = p_transaction_source;
4815:
4816: pa_utils2.g_ts_allow_burden_flag := l_allow_burden_flag;
4817: pa_utils2.g_transaction_source := p_transaction_source;
4818: RETURN l_allow_burden_flag;
4819: End If;
4820: ELSE
4821: RETURN 'N';

Line 5067: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Entering procedure');

5063: l_application_id NUMBER := NULL ;
5064:
5065: BEGIN
5066:
5067: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Entering procedure');
5068:
5069: /* Changed from value_specific to value for bug 5472333 */
5070: l_epp_flag := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') ;
5071:

Line 5072: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: EPP Flag status: ' || l_epp_flag);

5068:
5069: /* Changed from value_specific to value for bug 5472333 */
5070: l_epp_flag := fnd_profile.value('PA_EN_NEW_GLDATE_DERIVATION') ;
5071:
5072: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: EPP Flag status: ' || l_epp_flag);
5073:
5074: l_application_id := l_gl_app_id ;
5075:
5076: SELECT imp.set_of_books_id

Line 5080: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Using (appl_id, sob_id): (' || to_char(l_application_id) || ', ' || to_char(l_set_of_books_id) || ')' );

5076: SELECT imp.set_of_books_id
5077: INTO l_set_of_books_id
5078: FROM pa_implementations imp;
5079:
5080: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Using (appl_id, sob_id): (' || to_char(l_application_id) || ', ' || to_char(l_set_of_books_id) || ')' );
5081:
5082: ---Initialize the out variables.
5083: x_gl_period_name := NULL;
5084: x_gl_dt := NULL;

Line 5088: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Trying reference_date with cached start and end date values' );

5084: x_gl_dt := NULL;
5085: x_return_status := 0;
5086: x_error_code := NULL;
5087:
5088: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Trying reference_date with cached start and end date values' );
5089:
5090: IF ((trunc(p_reference_date) BETWEEN g_gl_dt_period_str_dt AND g_gl_dt_period_end_dt )
5091: AND g_gl_dt_period_str_dt IS NOT NULL) THEN
5092:

Line 5093: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Using cached values' );

5089:
5090: IF ((trunc(p_reference_date) BETWEEN g_gl_dt_period_str_dt AND g_gl_dt_period_end_dt )
5091: AND g_gl_dt_period_str_dt IS NOT NULL) THEN
5092:
5093: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Using cached values' );
5094:
5095: ---From Cache
5096: IF l_epp_flag = 'Y' THEN
5097: l_gl_dt := p_reference_date;

Line 5106: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Leaving procedure');

5102: --Assign the out variables.
5103: x_gl_dt := l_gl_dt ;
5104: x_gl_period_name := g_gl_dt_period_name;
5105:
5106: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Leaving procedure');
5107:
5108: return;
5109:
5110: END IF;

Line 5114: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Cache values empty/reference date not between cached start and end date values' );

5110: END IF;
5111:
5112: --- Either the cache is empty or the reference date is not in the range.
5113:
5114: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Cache values empty/reference date not between cached start and end date values' );
5115:
5116: BEGIN
5117:
5118: SELECT PERIOD.period_name,PERIOD.start_date,PERIOD.end_date,PERIOD.closing_status

Line 5134: x_error_stage := 'PA_UTILS2.GET_GL_PERIOD:: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;

5130:
5131: return;
5132: WHEN OTHERS THEN
5133: x_return_status := -1;
5134: x_error_stage := 'PA_UTILS2.GET_GL_PERIOD:: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
5135:
5136: raise;
5137: END;
5138:

Line 5146: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Checking for period status' );

5142: ELSE
5143: l_gl_dt := l_gl_period_end_dt;
5144: END IF;
5145:
5146: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Checking for period status' );
5147:
5148: --Checking for period status.
5149: IF l_period_status NOT IN ('O','F') THEN
5150:

Line 5151: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Period is closed' );

5147:
5148: --Checking for period status.
5149: IF l_period_status NOT IN ('O','F') THEN
5150:
5151: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Period is closed' );
5152:
5153: IF l_epp_flag = 'N' THEN
5154:
5155: pa_debug.g_err_stage := 'EPP = N, Querying next open period'; /* Added Code for Bug 6139975 */

Line 5234: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Caching dates' );

5230: END IF;
5231:
5232: END IF;
5233:
5234: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Caching dates' );
5235:
5236: g_gl_dt_period_name := l_gl_period_name;
5237: g_gl_dt_period_str_dt := l_gl_period_st_dt ;
5238: g_gl_dt_period_end_dt := l_gl_period_end_dt;

Line 5243: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Leaving procedure');

5239:
5240: x_gl_dt := l_gl_dt ;
5241: x_gl_period_name := l_gl_period_name ;
5242:
5243: pa_debug.write_file('PA_UTILS2.GET_GL_PERIOD: Leaving procedure');
5244:
5245: EXCEPTION
5246:
5247: /* Start of code added for Bug 6139975 */

Line 5252: x_error_stage := 'PA_UTILS2.GET_GL_PERIOD:: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;

5248:
5249: WHEN NO_DATA_FOUND THEN
5250: x_return_status := -1;
5251: x_error_code := 'NO_GL_DATE';
5252: x_error_stage := 'PA_UTILS2.GET_GL_PERIOD:: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
5253:
5254: return;
5255:
5256: /* End of code added for Bug 6139975 */

Line 5260: x_error_stage := 'PA_UTILS2.GET_GL_PERIOD:: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;

5256: /* End of code added for Bug 6139975 */
5257:
5258: WHEN OTHERS THEN
5259: x_return_status := -1;
5260: x_error_stage := 'PA_UTILS2.GET_GL_PERIOD:: ' || pa_debug.g_err_stage ||':: '|| SQLERRM;
5261:
5262: raise;
5263: END get_gl_dt_period ;
5264:

Line 5322: pa_debug.write_file('PA_UTILS2.populate_person_type: Entering procedure');

5318: AND e.person_type IS NULL;
5319:
5320: BEGIN
5321:
5322: pa_debug.write_file('PA_UTILS2.populate_person_type: Entering procedure');
5323: pa_debug.write_file('PA_UTILS2.populate_person_type: Date = ' || p_date);
5324: pa_debug.write_file('PA_UTILS2.populate_person_type: Upd Type = ' || p_upd_type);
5325: pa_debug.write_file('PA_UTILS2.populate_person_type: Request ID = ' || p_request_id);
5326:

Line 5323: pa_debug.write_file('PA_UTILS2.populate_person_type: Date = ' || p_date);

5319:
5320: BEGIN
5321:
5322: pa_debug.write_file('PA_UTILS2.populate_person_type: Entering procedure');
5323: pa_debug.write_file('PA_UTILS2.populate_person_type: Date = ' || p_date);
5324: pa_debug.write_file('PA_UTILS2.populate_person_type: Upd Type = ' || p_upd_type);
5325: pa_debug.write_file('PA_UTILS2.populate_person_type: Request ID = ' || p_request_id);
5326:
5327: l_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS;

Line 5324: pa_debug.write_file('PA_UTILS2.populate_person_type: Upd Type = ' || p_upd_type);

5320: BEGIN
5321:
5322: pa_debug.write_file('PA_UTILS2.populate_person_type: Entering procedure');
5323: pa_debug.write_file('PA_UTILS2.populate_person_type: Date = ' || p_date);
5324: pa_debug.write_file('PA_UTILS2.populate_person_type: Upd Type = ' || p_upd_type);
5325: pa_debug.write_file('PA_UTILS2.populate_person_type: Request ID = ' || p_request_id);
5326:
5327: l_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS;
5328:

Line 5325: pa_debug.write_file('PA_UTILS2.populate_person_type: Request ID = ' || p_request_id);

5321:
5322: pa_debug.write_file('PA_UTILS2.populate_person_type: Entering procedure');
5323: pa_debug.write_file('PA_UTILS2.populate_person_type: Date = ' || p_date);
5324: pa_debug.write_file('PA_UTILS2.populate_person_type: Upd Type = ' || p_upd_type);
5325: pa_debug.write_file('PA_UTILS2.populate_person_type: Request ID = ' || p_request_id);
5326:
5327: l_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS;
5328:
5329: SELECT business_group_id

Line 5327: l_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS;

5323: pa_debug.write_file('PA_UTILS2.populate_person_type: Date = ' || p_date);
5324: pa_debug.write_file('PA_UTILS2.populate_person_type: Upd Type = ' || p_upd_type);
5325: pa_debug.write_file('PA_UTILS2.populate_person_type: Request ID = ' || p_request_id);
5326:
5327: l_Cross_BG_Profile:= pa_utils.IsCrossBGProfile_WNPS;
5328:
5329: SELECT business_group_id
5330: INTO l_business_group_id
5331: FROM pa_implementations;

Line 5333: pa_debug.write_file('PA_UTILS2.populate_person_type: l_Cross_BG_Profile = ' || l_Cross_BG_Profile);

5329: SELECT business_group_id
5330: INTO l_business_group_id
5331: FROM pa_implementations;
5332:
5333: pa_debug.write_file('PA_UTILS2.populate_person_type: l_Cross_BG_Profile = ' || l_Cross_BG_Profile);
5334: pa_debug.write_file('PA_UTILS2.populate_person_type: l_business_group_id = ' || l_business_group_id);
5335:
5336: IF p_date IS NULL AND p_upd_type IS NULL THEN
5337:

Line 5334: pa_debug.write_file('PA_UTILS2.populate_person_type: l_business_group_id = ' || l_business_group_id);

5330: INTO l_business_group_id
5331: FROM pa_implementations;
5332:
5333: pa_debug.write_file('PA_UTILS2.populate_person_type: l_Cross_BG_Profile = ' || l_Cross_BG_Profile);
5334: pa_debug.write_file('PA_UTILS2.populate_person_type: l_business_group_id = ' || l_business_group_id);
5335:
5336: IF p_date IS NULL AND p_upd_type IS NULL THEN
5337:
5338: FOR rec IN elg_dist(p_request_id) LOOP

Line 5360: pa_debug.write_file('PA_UTILS2.populate_person_type: Person Type updated');

5356: request_id = p_request_id
5357: WHERE expenditure_id = rec.expenditure_id;
5358:
5359: END LOOP;
5360: pa_debug.write_file('PA_UTILS2.populate_person_type: Person Type updated');
5361:
5362: ELSIF p_upd_type = 'A' THEN
5363:
5364: FOR rec1 IN elg_acc1(p_date,p_request_id) LOOP

Line 5386: pa_debug.write_file('PA_UTILS2.populate_person_type: Person Type updated');

5382: request_id = p_request_id
5383: WHERE expenditure_id = rec1.expenditure_id;
5384:
5385: END LOOP;
5386: pa_debug.write_file('PA_UTILS2.populate_person_type: Person Type updated');
5387:
5388: ELSIF p_upd_type = 'X' THEN
5389:
5390: FOR rec1 IN elg_acc2(p_request_id) LOOP

Line 5412: pa_debug.write_file('PA_UTILS2.populate_person_type: Person Type updated');

5408: request_id = p_request_id
5409: WHERE expenditure_id = rec1.expenditure_id;
5410:
5411: END LOOP;
5412: pa_debug.write_file('PA_UTILS2.populate_person_type: Person Type updated');
5413:
5414: END IF;
5415:
5416: pa_debug.write_file('PA_UTILS2.populate_person_type: Leaving procedure');

Line 5416: pa_debug.write_file('PA_UTILS2.populate_person_type: Leaving procedure');

5412: pa_debug.write_file('PA_UTILS2.populate_person_type: Person Type updated');
5413:
5414: END IF;
5415:
5416: pa_debug.write_file('PA_UTILS2.populate_person_type: Leaving procedure');
5417:
5418: EXCEPTION
5419: WHEN OTHERS THEN
5420: pa_debug.write_file('PA_UTILS2.populate_person_type:: ' ||

Line 5420: pa_debug.write_file('PA_UTILS2.populate_person_type:: ' ||

5416: pa_debug.write_file('PA_UTILS2.populate_person_type: Leaving procedure');
5417:
5418: EXCEPTION
5419: WHEN OTHERS THEN
5420: pa_debug.write_file('PA_UTILS2.populate_person_type:: ' ||
5421: pa_debug.g_err_stage ||':: '|| SQLERRM);
5422: RAISE;
5423:
5424: end populate_person_type;

Line 5427: END pa_utils2;

5423:
5424: end populate_person_type;
5425: /* Added for bug 13554435 */
5426:
5427: END pa_utils2;