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.FEM_WEBADI_MEMBER_UTILS_PVT dependencies on FND_LOG

Line 2776: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2772: AttrMaps.dimension_varchar_label = p_dimension_varchar_label ;
2773: --
2774: BEGIN
2775: --
2776: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2777: THEN
2778: --
2779: l_param_info := 'p_dimension_varchar_label='||p_dimension_varchar_label ;
2780: l_curr_activity := 'Starting Populate_Dim_Metadata_Info API ' ;

Line 2783: FND_LOG.String

2779: l_param_info := 'p_dimension_varchar_label='||p_dimension_varchar_label ;
2780: l_curr_activity := 'Starting Populate_Dim_Metadata_Info API ' ;
2781: --
2782: -- Put the param info into log.
2783: FND_LOG.String
2784: ( log_level => FND_LOG.LEVEL_STATEMENT
2785: , module => l_api_name
2786: , message => 'Parametr Info: ' || l_param_info
2787: ) ;

Line 2784: ( log_level => FND_LOG.LEVEL_STATEMENT

2780: l_curr_activity := 'Starting Populate_Dim_Metadata_Info API ' ;
2781: --
2782: -- Put the param info into log.
2783: FND_LOG.String
2784: ( log_level => FND_LOG.LEVEL_STATEMENT
2785: , module => l_api_name
2786: , message => 'Parametr Info: ' || l_param_info
2787: ) ;
2788: --

Line 2790: FND_LOG.String

2786: , message => 'Parametr Info: ' || l_param_info
2787: ) ;
2788: --
2789: -- Put the current activity into log.
2790: FND_LOG.String
2791: ( log_level => FND_LOG.LEVEL_STATEMENT
2792: , module => l_api_name
2793: , message => 'Activity: ' || l_curr_activity
2794: ) ;

Line 2791: ( log_level => FND_LOG.LEVEL_STATEMENT

2787: ) ;
2788: --
2789: -- Put the current activity into log.
2790: FND_LOG.String
2791: ( log_level => FND_LOG.LEVEL_STATEMENT
2792: , module => l_api_name
2793: , message => 'Activity: ' || l_curr_activity
2794: ) ;
2795: --

Line 2818: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2814: EXIT WHEN l_Ret_Attr_Mapp_csr%NOTFOUND;
2815: END LOOP ;
2816: CLOSE l_Ret_Attr_Mapp_csr ;
2817: --
2818: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2819: THEN
2820: --
2821: l_curr_activity := 'Bulk operation completed successfully.' ;
2822: --

Line 2824: FND_LOG.String

2820: --
2821: l_curr_activity := 'Bulk operation completed successfully.' ;
2822: --
2823: -- Put the current activity into log.
2824: FND_LOG.String
2825: ( log_level => FND_LOG.LEVEL_STATEMENT
2826: , module => l_api_name
2827: , message => 'Activity: ' || l_curr_activity
2828: ) ;

Line 2825: ( log_level => FND_LOG.LEVEL_STATEMENT

2821: l_curr_activity := 'Bulk operation completed successfully.' ;
2822: --
2823: -- Put the current activity into log.
2824: FND_LOG.String
2825: ( log_level => FND_LOG.LEVEL_STATEMENT
2826: , module => l_api_name
2827: , message => 'Activity: ' || l_curr_activity
2828: ) ;
2829: --

Line 2864: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2860: --
2861: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2862: --
2863: --
2864: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2865: THEN
2866: --
2867: l_curr_activity := 'Populate_Dim_Metadata_Info API completed ' ||
2868: 'successfully' ;

Line 2871: FND_LOG.String

2867: l_curr_activity := 'Populate_Dim_Metadata_Info API completed ' ||
2868: 'successfully' ;
2869: --
2870: -- Put the current activity into log.
2871: FND_LOG.String
2872: ( log_level => FND_LOG.LEVEL_STATEMENT
2873: , module => l_api_name
2874: , message => 'Activity: ' || l_curr_activity
2875: ) ;

Line 2872: ( log_level => FND_LOG.LEVEL_STATEMENT

2868: 'successfully' ;
2869: --
2870: -- Put the current activity into log.
2871: FND_LOG.String
2872: ( log_level => FND_LOG.LEVEL_STATEMENT
2873: , module => l_api_name
2874: , message => 'Activity: ' || l_curr_activity
2875: ) ;
2876: --

Line 2884: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2880: WHEN FND_API.G_EXC_ERROR THEN
2881: --
2882: x_return_status := FND_API.G_RET_STS_ERROR ;
2883: --
2884: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2885: THEN
2886: -- Put exact error message into log.
2887: FND_LOG.String
2888: ( log_level => FND_LOG.LEVEL_STATEMENT

Line 2887: FND_LOG.String

2883: --
2884: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2885: THEN
2886: -- Put exact error message into log.
2887: FND_LOG.String
2888: ( log_level => FND_LOG.LEVEL_STATEMENT
2889: , module => l_api_name
2890: , message => 'SQL Error ' || sqlerrm
2891: ) ;

Line 2888: ( log_level => FND_LOG.LEVEL_STATEMENT

2884: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2885: THEN
2886: -- Put exact error message into log.
2887: FND_LOG.String
2888: ( log_level => FND_LOG.LEVEL_STATEMENT
2889: , module => l_api_name
2890: , message => 'SQL Error ' || sqlerrm
2891: ) ;
2892: END IF ;

Line 2898: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2895: --
2896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2897: --
2898: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2899: THEN
2900: -- Put exact error message into log.
2901: FND_LOG.String
2902: ( log_level => FND_LOG.LEVEL_STATEMENT

Line 2901: FND_LOG.String

2897: --
2898: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2899: THEN
2900: -- Put exact error message into log.
2901: FND_LOG.String
2902: ( log_level => FND_LOG.LEVEL_STATEMENT
2903: , module => l_api_name
2904: , message => 'SQL Error ' || sqlerrm
2905: ) ;

Line 2902: ( log_level => FND_LOG.LEVEL_STATEMENT

2898: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2899: THEN
2900: -- Put exact error message into log.
2901: FND_LOG.String
2902: ( log_level => FND_LOG.LEVEL_STATEMENT
2903: , module => l_api_name
2904: , message => 'SQL Error ' || sqlerrm
2905: ) ;
2906: END IF ;

Line 2912: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

2908: WHEN OTHERS THEN
2909: --
2910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2911: --
2912: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2913: THEN
2914: -- Put exact error message into log.
2915: FND_LOG.String
2916: ( log_level => FND_LOG.LEVEL_STATEMENT

Line 2915: FND_LOG.String

2911: --
2912: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2913: THEN
2914: -- Put exact error message into log.
2915: FND_LOG.String
2916: ( log_level => FND_LOG.LEVEL_STATEMENT
2917: , module => l_api_name
2918: , message => 'SQL Error ' || sqlerrm
2919: ) ;

Line 2916: ( log_level => FND_LOG.LEVEL_STATEMENT

2912: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
2913: THEN
2914: -- Put exact error message into log.
2915: FND_LOG.String
2916: ( log_level => FND_LOG.LEVEL_STATEMENT
2917: , module => l_api_name
2918: , message => 'SQL Error ' || sqlerrm
2919: ) ;
2920: END IF ;

Line 3043: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3039: BEGIN
3040: --
3041: SAVEPOINT Populate_Dim_Attribute_Maps ;
3042: --
3043: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3044: THEN
3045: --
3046: l_param_info := 'p_dimension_varchar_label='||p_dimension_varchar_label ;
3047: l_curr_activity := 'Starting Populate_Dim_Attribute_Maps API ' ;

Line 3050: FND_LOG.String

3046: l_param_info := 'p_dimension_varchar_label='||p_dimension_varchar_label ;
3047: l_curr_activity := 'Starting Populate_Dim_Attribute_Maps API ' ;
3048: --
3049: -- Put the param info into log.
3050: FND_LOG.String
3051: ( log_level => FND_LOG.LEVEL_STATEMENT
3052: , module => l_api_name
3053: , message => 'Parametr Info: ' || l_param_info
3054: ) ;

Line 3051: ( log_level => FND_LOG.LEVEL_STATEMENT

3047: l_curr_activity := 'Starting Populate_Dim_Attribute_Maps API ' ;
3048: --
3049: -- Put the param info into log.
3050: FND_LOG.String
3051: ( log_level => FND_LOG.LEVEL_STATEMENT
3052: , module => l_api_name
3053: , message => 'Parametr Info: ' || l_param_info
3054: ) ;
3055: --

Line 3057: FND_LOG.String

3053: , message => 'Parametr Info: ' || l_param_info
3054: ) ;
3055: --
3056: -- Put the current activity into log.
3057: FND_LOG.String
3058: ( log_level => FND_LOG.LEVEL_STATEMENT
3059: , module => l_api_name
3060: , message => 'Activity: ' || l_curr_activity
3061: ) ;

Line 3058: ( log_level => FND_LOG.LEVEL_STATEMENT

3054: ) ;
3055: --
3056: -- Put the current activity into log.
3057: FND_LOG.String
3058: ( log_level => FND_LOG.LEVEL_STATEMENT
3059: , module => l_api_name
3060: , message => 'Activity: ' || l_curr_activity
3061: ) ;
3062: --

Line 3088: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3084: AND attr.dimension_id = xdim.dimension_id
3085: ) ;
3086: --
3087: --
3088: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3089: THEN
3090: --
3091: l_curr_activity := 'Stale records deleted. Now Updating records with ' ||
3092: 'changed datatype.' ;

Line 3095: FND_LOG.String

3091: l_curr_activity := 'Stale records deleted. Now Updating records with ' ||
3092: 'changed datatype.' ;
3093: --
3094: -- Put the current activity into log.
3095: FND_LOG.String
3096: ( log_level => FND_LOG.LEVEL_STATEMENT
3097: , module => l_api_name
3098: , message => 'Activity: ' || l_curr_activity
3099: ) ;

Line 3096: ( log_level => FND_LOG.LEVEL_STATEMENT

3092: 'changed datatype.' ;
3093: --
3094: -- Put the current activity into log.
3095: FND_LOG.String
3096: ( log_level => FND_LOG.LEVEL_STATEMENT
3097: , module => l_api_name
3098: , message => 'Activity: ' || l_curr_activity
3099: ) ;
3100: --

Line 3129: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3125: EXIT WHEN l_changed_datatype_map_csr%NOTFOUND ;
3126: END LOOP ;
3127: CLOSE l_changed_datatype_map_csr ;
3128: --
3129: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3130: THEN
3131: --
3132: l_curr_activity := 'Update of records with changed data type done.' ;
3133: --

Line 3135: FND_LOG.String

3131: --
3132: l_curr_activity := 'Update of records with changed data type done.' ;
3133: --
3134: -- Put the current activity into log.
3135: FND_LOG.String
3136: ( log_level => FND_LOG.LEVEL_STATEMENT
3137: , module => l_api_name
3138: , message => 'Activity: ' || l_curr_activity
3139: ) ;

Line 3136: ( log_level => FND_LOG.LEVEL_STATEMENT

3132: l_curr_activity := 'Update of records with changed data type done.' ;
3133: --
3134: -- Put the current activity into log.
3135: FND_LOG.String
3136: ( log_level => FND_LOG.LEVEL_STATEMENT
3137: , module => l_api_name
3138: , message => 'Activity: ' || l_curr_activity
3139: ) ;
3140: --

Line 3157: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3153: fem_webadi_dim_attr_maps attrmap
3154: WHERE
3155: attrmap.dimension_varchar_label = p_dimension_varchar_label ;
3156: --
3157: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3158: THEN
3159: --
3160: l_curr_activity := 'Maximum seq is ' || l_max_attr_seq ;
3161: --

Line 3163: FND_LOG.String

3159: --
3160: l_curr_activity := 'Maximum seq is ' || l_max_attr_seq ;
3161: --
3162: -- Put the current activity into log.
3163: FND_LOG.String
3164: ( log_level => FND_LOG.LEVEL_STATEMENT
3165: , module => l_api_name
3166: , message => 'Activity: ' || l_curr_activity
3167: ) ;

Line 3164: ( log_level => FND_LOG.LEVEL_STATEMENT

3160: l_curr_activity := 'Maximum seq is ' || l_max_attr_seq ;
3161: --
3162: -- Put the current activity into log.
3163: FND_LOG.String
3164: ( log_level => FND_LOG.LEVEL_STATEMENT
3165: , module => l_api_name
3166: , message => 'Activity: ' || l_curr_activity
3167: ) ;
3168: --

Line 3182: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3178: l_attr_label_tbl
3179: , l_data_type_tbl ;
3180: CLOSE l_new_dim_attr_rec_csr ;
3181: --
3182: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3183: THEN
3184: --
3185: FOR l_indx IN 1..l_attr_label_tbl.COUNT
3186: LOOP

Line 3188: FND_LOG.String

3184: --
3185: FOR l_indx IN 1..l_attr_label_tbl.COUNT
3186: LOOP
3187: -- Put attribute details into log.
3188: FND_LOG.String
3189: ( log_level => FND_LOG.LEVEL_STATEMENT
3190: , module => l_api_name
3191: , message => 'Attr_Label: ' || l_attr_label_tbl(l_indx) ||
3192: 'Attr_Datatype ' ||l_data_type_tbl(l_indx)

Line 3189: ( log_level => FND_LOG.LEVEL_STATEMENT

3185: FOR l_indx IN 1..l_attr_label_tbl.COUNT
3186: LOOP
3187: -- Put attribute details into log.
3188: FND_LOG.String
3189: ( log_level => FND_LOG.LEVEL_STATEMENT
3190: , module => l_api_name
3191: , message => 'Attr_Label: ' || l_attr_label_tbl(l_indx) ||
3192: 'Attr_Datatype ' ||l_data_type_tbl(l_indx)
3193: ) ;

Line 3206: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3202: THEN
3203: l_gap_logic_req := TRUE ;
3204: --
3205: --
3206: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3207: THEN
3208: --
3209: l_curr_activity := 'Gap logic is required' ;
3210: --

Line 3212: FND_LOG.String

3208: --
3209: l_curr_activity := 'Gap logic is required' ;
3210: --
3211: -- Put the current activity into log.
3212: FND_LOG.String
3213: ( log_level => FND_LOG.LEVEL_STATEMENT
3214: , module => l_api_name
3215: , message => 'Activity: ' || l_curr_activity
3216: ) ;

Line 3213: ( log_level => FND_LOG.LEVEL_STATEMENT

3209: l_curr_activity := 'Gap logic is required' ;
3210: --
3211: -- Put the current activity into log.
3212: FND_LOG.String
3213: ( log_level => FND_LOG.LEVEL_STATEMENT
3214: , module => l_api_name
3215: , message => 'Activity: ' || l_curr_activity
3216: ) ;
3217: --

Line 3251: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3247: , l_attr_label_tbl(l_indx)
3248: , l_data_type_tbl(l_indx)
3249: ) ;
3250: --
3251: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3252: THEN
3253: --
3254: l_curr_activity := 'Bulk inserting with no gap logic done.' ;
3255: --

Line 3257: FND_LOG.String

3253: --
3254: l_curr_activity := 'Bulk inserting with no gap logic done.' ;
3255: --
3256: -- Put the current activity into log.
3257: FND_LOG.String
3258: ( log_level => FND_LOG.LEVEL_STATEMENT
3259: , module => l_api_name
3260: , message => 'Activity: ' || l_curr_activity
3261: ) ;

Line 3258: ( log_level => FND_LOG.LEVEL_STATEMENT

3254: l_curr_activity := 'Bulk inserting with no gap logic done.' ;
3255: --
3256: -- Put the current activity into log.
3257: FND_LOG.String
3258: ( log_level => FND_LOG.LEVEL_STATEMENT
3259: , module => l_api_name
3260: , message => 'Activity: ' || l_curr_activity
3261: ) ;
3262: --

Line 3302: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3298: , l_attr_label_tbl(l_indx)
3299: , l_data_type_tbl(l_indx)
3300: ) ;
3301: --
3302: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3303: THEN
3304: --
3305: l_curr_activity := 'Bulk insertion with gap logic done.' ;
3306: --

Line 3308: FND_LOG.String

3304: --
3305: l_curr_activity := 'Bulk insertion with gap logic done.' ;
3306: --
3307: -- Put the current activity into log.
3308: FND_LOG.String
3309: ( log_level => FND_LOG.LEVEL_STATEMENT
3310: , module => l_api_name
3311: , message => 'Activity: ' || l_curr_activity
3312: ) ;

Line 3309: ( log_level => FND_LOG.LEVEL_STATEMENT

3305: l_curr_activity := 'Bulk insertion with gap logic done.' ;
3306: --
3307: -- Put the current activity into log.
3308: FND_LOG.String
3309: ( log_level => FND_LOG.LEVEL_STATEMENT
3310: , module => l_api_name
3311: , message => 'Activity: ' || l_curr_activity
3312: ) ;
3313: --

Line 3327: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3323: --
3324: -- Initialize API return status to success
3325: x_return_status := FND_API.G_RET_STS_SUCCESS ;
3326: --
3327: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3328: THEN
3329: --
3330: l_curr_activity := 'Populate_Dim_Attribute_Maps completed successfully' ;
3331: --

Line 3333: FND_LOG.String

3329: --
3330: l_curr_activity := 'Populate_Dim_Attribute_Maps completed successfully' ;
3331: --
3332: -- Put the current activity into log.
3333: FND_LOG.String
3334: ( log_level => FND_LOG.LEVEL_STATEMENT
3335: , module => l_api_name
3336: , message => 'Activity: ' || l_curr_activity
3337: ) ;

Line 3334: ( log_level => FND_LOG.LEVEL_STATEMENT

3330: l_curr_activity := 'Populate_Dim_Attribute_Maps completed successfully' ;
3331: --
3332: -- Put the current activity into log.
3333: FND_LOG.String
3334: ( log_level => FND_LOG.LEVEL_STATEMENT
3335: , module => l_api_name
3336: , message => 'Activity: ' || l_curr_activity
3337: ) ;
3338: --

Line 3348: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3344: ROLLBACK TO Populate_Dim_Attribute_Maps ;
3345: --
3346: x_return_status := FND_API.G_RET_STS_ERROR ;
3347: --
3348: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3349: THEN
3350: -- Put exact error message into log.
3351: FND_LOG.String
3352: ( log_level => FND_LOG.LEVEL_STATEMENT

Line 3351: FND_LOG.String

3347: --
3348: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3349: THEN
3350: -- Put exact error message into log.
3351: FND_LOG.String
3352: ( log_level => FND_LOG.LEVEL_STATEMENT
3353: , module => l_api_name
3354: , message => 'SQL Error ' || sqlerrm
3355: ) ;

Line 3352: ( log_level => FND_LOG.LEVEL_STATEMENT

3348: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3349: THEN
3350: -- Put exact error message into log.
3351: FND_LOG.String
3352: ( log_level => FND_LOG.LEVEL_STATEMENT
3353: , module => l_api_name
3354: , message => 'SQL Error ' || sqlerrm
3355: ) ;
3356: --

Line 3365: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3361: ROLLBACK TO Populate_Dim_Attribute_Maps ;
3362: --
3363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3364: --
3365: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3366: THEN
3367: -- Put exact error message into log.
3368: FND_LOG.String
3369: ( log_level => FND_LOG.LEVEL_STATEMENT

Line 3368: FND_LOG.String

3364: --
3365: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3366: THEN
3367: -- Put exact error message into log.
3368: FND_LOG.String
3369: ( log_level => FND_LOG.LEVEL_STATEMENT
3370: , module => l_api_name
3371: , message => 'SQL Error ' || sqlerrm
3372: ) ;

Line 3369: ( log_level => FND_LOG.LEVEL_STATEMENT

3365: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3366: THEN
3367: -- Put exact error message into log.
3368: FND_LOG.String
3369: ( log_level => FND_LOG.LEVEL_STATEMENT
3370: , module => l_api_name
3371: , message => 'SQL Error ' || sqlerrm
3372: ) ;
3373: --

Line 3382: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3378: ROLLBACK TO Populate_Dim_Attribute_Maps ;
3379: --
3380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3381: --
3382: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3383: THEN
3384: -- Put exact error message into log.
3385: FND_LOG.String
3386: ( log_level => FND_LOG.LEVEL_STATEMENT

Line 3385: FND_LOG.String

3381: --
3382: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3383: THEN
3384: -- Put exact error message into log.
3385: FND_LOG.String
3386: ( log_level => FND_LOG.LEVEL_STATEMENT
3387: , module => l_api_name
3388: , message => 'SQL Error ' || sqlerrm
3389: ) ;

Line 3386: ( log_level => FND_LOG.LEVEL_STATEMENT

3382: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3383: THEN
3384: -- Put exact error message into log.
3385: FND_LOG.String
3386: ( log_level => FND_LOG.LEVEL_STATEMENT
3387: , module => l_api_name
3388: , message => 'SQL Error ' || sqlerrm
3389: ) ;
3390: --

Line 3808: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3804: l_record_found_count NUMBER := 0 ;
3805: --
3806: BEGIN
3807: --
3808: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3809: THEN
3810: --
3811: l_param_info := null ;
3812: l_curr_activity := 'Starting Pop_Other_Dim_Mem_Intf_table API ' ;

Line 3815: FND_LOG.String

3811: l_param_info := null ;
3812: l_curr_activity := 'Starting Pop_Other_Dim_Mem_Intf_table API ' ;
3813: --
3814: -- Put parameter information.
3815: FND_LOG.String
3816: ( log_level => FND_LOG.LEVEL_STATEMENT
3817: , module => l_api_name
3818: , message => 'Parametr Info: ' || l_param_info
3819: ) ;

Line 3816: ( log_level => FND_LOG.LEVEL_STATEMENT

3812: l_curr_activity := 'Starting Pop_Other_Dim_Mem_Intf_table API ' ;
3813: --
3814: -- Put parameter information.
3815: FND_LOG.String
3816: ( log_level => FND_LOG.LEVEL_STATEMENT
3817: , module => l_api_name
3818: , message => 'Parametr Info: ' || l_param_info
3819: ) ;
3820: --

Line 3822: FND_LOG.String

3818: , message => 'Parametr Info: ' || l_param_info
3819: ) ;
3820: --
3821: -- Put the current activity into log.
3822: FND_LOG.String
3823: ( log_level => FND_LOG.LEVEL_STATEMENT
3824: , module => l_api_name
3825: , message => 'Activity: ' || l_curr_activity
3826: ) ;

Line 3823: ( log_level => FND_LOG.LEVEL_STATEMENT

3819: ) ;
3820: --
3821: -- Put the current activity into log.
3822: FND_LOG.String
3823: ( log_level => FND_LOG.LEVEL_STATEMENT
3824: , module => l_api_name
3825: , message => 'Activity: ' || l_curr_activity
3826: ) ;
3827: --

Line 3831: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3827: --
3828: END IF ;
3829: --
3830: --
3831: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3832: THEN
3833: --
3834: l_curr_activity := 'Not a time dimension. Insert in member b table' ;
3835: --

Line 3837: FND_LOG.String

3833: --
3834: l_curr_activity := 'Not a time dimension. Insert in member b table' ;
3835: --
3836: -- Put the current activity into log.
3837: FND_LOG.String
3838: ( log_level => FND_LOG.LEVEL_STATEMENT
3839: , module => l_api_name
3840: , message => 'Activity: ' || l_curr_activity
3841: ) ;

Line 3838: ( log_level => FND_LOG.LEVEL_STATEMENT

3834: l_curr_activity := 'Not a time dimension. Insert in member b table' ;
3835: --
3836: -- Put the current activity into log.
3837: FND_LOG.String
3838: ( log_level => FND_LOG.LEVEL_STATEMENT
3839: , module => l_api_name
3840: , message => 'Activity: ' || l_curr_activity
3841: ) ;
3842: --

Line 3901: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3897: , g_global_val_tbl(1).member_display_code ;
3898: --
3899: END ;
3900: --
3901: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3902: THEN
3903: --
3904: l_curr_activity := 'Insert in member b table done, do it for TL table' ;
3905: --

Line 3907: FND_LOG.String

3903: --
3904: l_curr_activity := 'Insert in member b table done, do it for TL table' ;
3905: --
3906: -- Put the current activity into log.
3907: FND_LOG.String
3908: ( log_level => FND_LOG.LEVEL_STATEMENT
3909: , module => l_api_name
3910: , message => 'Activity: ' || l_curr_activity
3911: ) ;

Line 3908: ( log_level => FND_LOG.LEVEL_STATEMENT

3904: l_curr_activity := 'Insert in member b table done, do it for TL table' ;
3905: --
3906: -- Put the current activity into log.
3907: FND_LOG.String
3908: ( log_level => FND_LOG.LEVEL_STATEMENT
3909: , module => l_api_name
3910: , message => 'Activity: ' || l_curr_activity
3911: ) ;
3912: --

Line 3995: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

3991: END ;
3992: --
3993: END IF ;
3994: --
3995: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
3996: THEN
3997: --
3998: l_curr_activity := 'Pop_Other_Dim_Mem_Intf_table API completed ' ||
3999: 'successfully' ;

Line 4002: FND_LOG.String

3998: l_curr_activity := 'Pop_Other_Dim_Mem_Intf_table API completed ' ||
3999: 'successfully' ;
4000: --
4001: -- Put the current activity into log.
4002: FND_LOG.String
4003: ( log_level => FND_LOG.LEVEL_STATEMENT
4004: , module => l_api_name
4005: , message => 'Activity: ' || l_curr_activity
4006: ) ;

Line 4003: ( log_level => FND_LOG.LEVEL_STATEMENT

3999: 'successfully' ;
4000: --
4001: -- Put the current activity into log.
4002: FND_LOG.String
4003: ( log_level => FND_LOG.LEVEL_STATEMENT
4004: , module => l_api_name
4005: , message => 'Activity: ' || l_curr_activity
4006: ) ;
4007: --

Line 4155: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4151: BEGIN
4152: --
4153: SAVEPOINT Process_Attribute ;
4154: --
4155: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4156: THEN
4157: --
4158: l_param_info := null ;
4159: l_curr_activity := 'Starting Process_Attribute API for ' ||

Line 4163: FND_LOG.String

4159: l_curr_activity := 'Starting Process_Attribute API for ' ||
4160: 'p_attribute_'||p_attribute_index ;
4161: --
4162: -- Put parameter information.
4163: FND_LOG.String
4164: ( log_level => FND_LOG.LEVEL_STATEMENT
4165: , module => l_api_name
4166: , message => 'Parametr Info: ' || l_param_info
4167: ) ;

Line 4164: ( log_level => FND_LOG.LEVEL_STATEMENT

4160: 'p_attribute_'||p_attribute_index ;
4161: --
4162: -- Put parameter information.
4163: FND_LOG.String
4164: ( log_level => FND_LOG.LEVEL_STATEMENT
4165: , module => l_api_name
4166: , message => 'Parametr Info: ' || l_param_info
4167: ) ;
4168: --

Line 4170: FND_LOG.String

4166: , message => 'Parametr Info: ' || l_param_info
4167: ) ;
4168: --
4169: -- Put the current activity into log.
4170: FND_LOG.String
4171: ( log_level => FND_LOG.LEVEL_STATEMENT
4172: , module => l_api_name
4173: , message => 'Activity: ' || l_curr_activity
4174: ) ;

Line 4171: ( log_level => FND_LOG.LEVEL_STATEMENT

4167: ) ;
4168: --
4169: -- Put the current activity into log.
4170: FND_LOG.String
4171: ( log_level => FND_LOG.LEVEL_STATEMENT
4172: , module => l_api_name
4173: , message => 'Activity: ' || l_curr_activity
4174: ) ;
4175: --

Line 4275: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4271: --
4272: IF ( l_value_set_required_flag = 'Y' )
4273: THEN
4274: --
4275: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4276: THEN
4277: --
4278: l_curr_activity := 'Value Set Required Attribute. Get the display code';
4279: --

Line 4281: FND_LOG.String

4277: --
4278: l_curr_activity := 'Value Set Required Attribute. Get the display code';
4279: --
4280: -- Put the current activity into log.
4281: FND_LOG.String
4282: ( log_level => FND_LOG.LEVEL_STATEMENT
4283: , module => l_api_name
4284: , message => 'Activity: ' || l_curr_activity
4285: ) ;

Line 4282: ( log_level => FND_LOG.LEVEL_STATEMENT

4278: l_curr_activity := 'Value Set Required Attribute. Get the display code';
4279: --
4280: -- Put the current activity into log.
4281: FND_LOG.String
4282: ( log_level => FND_LOG.LEVEL_STATEMENT
4283: , module => l_api_name
4284: , message => 'Activity: ' || l_curr_activity
4285: ) ;
4286: --

Line 4313: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4309: --
4310: END IF ;
4311: --
4312: --
4313: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4314: THEN
4315: --
4316: l_curr_activity := 'VS display code=' ||
4317: g_attribute_vs_display_code

Line 4323: FND_LOG.String

4319: ', attribute_dimension_id='||l_attribute_dimension_id||
4320: ', attr_asgn_vs_disp_code='||l_attr_asgn_vs_disp_code ;
4321: --
4322: -- Put the current activity into log.
4323: FND_LOG.String
4324: ( log_level => FND_LOG.LEVEL_STATEMENT
4325: , module => l_api_name
4326: , message => 'Activity: ' || l_curr_activity
4327: ) ;

Line 4324: ( log_level => FND_LOG.LEVEL_STATEMENT

4320: ', attr_asgn_vs_disp_code='||l_attr_asgn_vs_disp_code ;
4321: --
4322: -- Put the current activity into log.
4323: FND_LOG.String
4324: ( log_level => FND_LOG.LEVEL_STATEMENT
4325: , module => l_api_name
4326: , message => 'Activity: ' || l_curr_activity
4327: ) ;
4328: --

Line 4393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4389: , g_cal_pr_num_col_name_value ;
4390: --
4391: END ;
4392: --
4393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4394: THEN
4395: --
4396: l_curr_activity := 'Insert in member b table done. Do it for TL table' ;
4397: --

Line 4399: FND_LOG.String

4395: --
4396: l_curr_activity := 'Insert in member b table done. Do it for TL table' ;
4397: --
4398: -- Put the current activity into log.
4399: FND_LOG.String
4400: ( log_level => FND_LOG.LEVEL_STATEMENT
4401: , module => l_api_name
4402: , message => 'Activity: ' || l_curr_activity
4403: ) ;

Line 4400: ( log_level => FND_LOG.LEVEL_STATEMENT

4396: l_curr_activity := 'Insert in member b table done. Do it for TL table' ;
4397: --
4398: -- Put the current activity into log.
4399: FND_LOG.String
4400: ( log_level => FND_LOG.LEVEL_STATEMENT
4401: , module => l_api_name
4402: , message => 'Activity: ' || l_curr_activity
4403: ) ;
4404: --

Line 4494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4490: END ;
4491: --
4492: END ;
4493: --
4494: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4495: THEN
4496: --
4497: l_curr_activity := 'Insert in TL done. For time attrib intf table' ;
4498: --

Line 4500: FND_LOG.String

4496: --
4497: l_curr_activity := 'Insert in TL done. For time attrib intf table' ;
4498: --
4499: -- Put the current activity into log.
4500: FND_LOG.String
4501: ( log_level => FND_LOG.LEVEL_STATEMENT
4502: , module => l_api_name
4503: , message => 'Activity: ' || l_curr_activity
4504: ) ;

Line 4501: ( log_level => FND_LOG.LEVEL_STATEMENT

4497: l_curr_activity := 'Insert in TL done. For time attrib intf table' ;
4498: --
4499: -- Put the current activity into log.
4500: FND_LOG.String
4501: ( log_level => FND_LOG.LEVEL_STATEMENT
4502: , module => l_api_name
4503: , message => 'Activity: ' || l_curr_activity
4504: ) ;
4505: --

Line 4511: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4507: --
4508: ELSIF ( g_global_val_tbl(1).dimension_type_code <> 'TIME' ) -- Non Time dim
4509: THEN
4510: --
4511: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4512: THEN
4513: --
4514: l_curr_activity := 'Insert in TL done. For non-time attrib intf table' ;
4515: --

Line 4517: FND_LOG.String

4513: --
4514: l_curr_activity := 'Insert in TL done. For non-time attrib intf table' ;
4515: --
4516: -- Put the current activity into log.
4517: FND_LOG.String
4518: ( log_level => FND_LOG.LEVEL_STATEMENT
4519: , module => l_api_name
4520: , message => 'Activity: ' || l_curr_activity
4521: ) ;

Line 4518: ( log_level => FND_LOG.LEVEL_STATEMENT

4514: l_curr_activity := 'Insert in TL done. For non-time attrib intf table' ;
4515: --
4516: -- Put the current activity into log.
4517: FND_LOG.String
4518: ( log_level => FND_LOG.LEVEL_STATEMENT
4519: , module => l_api_name
4520: , message => 'Activity: ' || l_curr_activity
4521: ) ;
4522: --

Line 4823: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

4819: END IF ; --Condition#2 End ( Existence of attribute table )
4820: --
4821: END IF ; --Condition#1 End ( TIME or Non TIME dimension )
4822: --
4823: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
4824: THEN
4825: --
4826: l_curr_activity := 'Process_Attribute API for ' ||
4827: 'p_attribute_'||p_attribute_index ||

Line 4831: FND_LOG.String

4827: 'p_attribute_'||p_attribute_index ||
4828: ' completed successfully.' ;
4829: --
4830: -- Put the current activity into log.
4831: FND_LOG.String
4832: ( log_level => FND_LOG.LEVEL_STATEMENT
4833: , module => l_api_name
4834: , message => 'Activity: ' || l_curr_activity
4835: ) ;

Line 4832: ( log_level => FND_LOG.LEVEL_STATEMENT

4828: ' completed successfully.' ;
4829: --
4830: -- Put the current activity into log.
4831: FND_LOG.String
4832: ( log_level => FND_LOG.LEVEL_STATEMENT
4833: , module => l_api_name
4834: , message => 'Activity: ' || l_curr_activity
4835: ) ;
4836: --

Line 5014: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

5010: --
5011: l_param_info := NULL ;
5012: l_curr_activity := NULL ;
5013: --
5014: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
5015: THEN
5016: --
5017: l_param_info := ' p_dimension_varchar_label='||p_dimension_varchar_label||
5018: ',p_ledger_id = ' || p_ledger_id ||

Line 5027: FND_LOG.String

5023: p_dimension_group_display_code ;
5024: l_curr_activity := 'Starting Upload_Member_Interface API ' ;
5025: --
5026: -- Put parameter information.
5027: FND_LOG.String
5028: ( log_level => FND_LOG.LEVEL_STATEMENT
5029: , module => l_api_name
5030: , message => 'Parametr Info: ' || l_param_info
5031: ) ;

Line 5028: ( log_level => FND_LOG.LEVEL_STATEMENT

5024: l_curr_activity := 'Starting Upload_Member_Interface API ' ;
5025: --
5026: -- Put parameter information.
5027: FND_LOG.String
5028: ( log_level => FND_LOG.LEVEL_STATEMENT
5029: , module => l_api_name
5030: , message => 'Parametr Info: ' || l_param_info
5031: ) ;
5032: --

Line 5034: FND_LOG.String

5030: , message => 'Parametr Info: ' || l_param_info
5031: ) ;
5032: --
5033: -- Put the current activity into log.
5034: FND_LOG.String
5035: ( log_level => FND_LOG.LEVEL_STATEMENT
5036: , module => l_api_name
5037: , message => 'Activity: ' || l_curr_activity
5038: ) ;

Line 5035: ( log_level => FND_LOG.LEVEL_STATEMENT

5031: ) ;
5032: --
5033: -- Put the current activity into log.
5034: FND_LOG.String
5035: ( log_level => FND_LOG.LEVEL_STATEMENT
5036: , module => l_api_name
5037: , message => 'Activity: ' || l_curr_activity
5038: ) ;
5039: --

Line 5084: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

5080: -- the supplied p_dimension_varchar_label.
5081: -- Other APIs can reuse the populated global variables.
5082: -- This will be done only once.
5083: --
5084: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
5085: THEN
5086: --
5087: l_curr_activity := 'Calling Populate_Dim_Metadata_Info API ' ||
5088: 'for ' || p_dimension_varchar_label ;

Line 5091: FND_LOG.String

5087: l_curr_activity := 'Calling Populate_Dim_Metadata_Info API ' ||
5088: 'for ' || p_dimension_varchar_label ;
5089: --
5090: -- Put the current activity into log.
5091: FND_LOG.String
5092: ( log_level => FND_LOG.LEVEL_STATEMENT
5093: , module => l_api_name
5094: , message => 'Activity: ' || l_curr_activity
5095: ) ;

Line 5092: ( log_level => FND_LOG.LEVEL_STATEMENT

5088: 'for ' || p_dimension_varchar_label ;
5089: --
5090: -- Put the current activity into log.
5091: FND_LOG.String
5092: ( log_level => FND_LOG.LEVEL_STATEMENT
5093: , module => l_api_name
5094: , message => 'Activity: ' || l_curr_activity
5095: ) ;
5096: --

Line 5145: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

5141: p_dimension_group_display_code ;
5142: END IF ;
5143: --
5144: -- Populate Members Process Starts.
5145: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
5146: THEN
5147: --
5148: l_curr_activity := 'Calling Pop_Other_Dim_Mem_Intf_table API ' ||
5149: ' for '||l_cal_pr_end_date_col_name ||' and ' ||

Line 5153: FND_LOG.String

5149: ' for '||l_cal_pr_end_date_col_name ||' and ' ||
5150: l_cal_pr_num_col_name ;
5151: --
5152: -- Put the current activity into log.
5153: FND_LOG.String
5154: ( log_level => FND_LOG.LEVEL_STATEMENT
5155: , module => l_api_name
5156: , message => 'Activity: ' || l_curr_activity
5157: ) ;

Line 5154: ( log_level => FND_LOG.LEVEL_STATEMENT

5150: l_cal_pr_num_col_name ;
5151: --
5152: -- Put the current activity into log.
5153: FND_LOG.String
5154: ( log_level => FND_LOG.LEVEL_STATEMENT
5155: , module => l_api_name
5156: , message => 'Activity: ' || l_curr_activity
5157: ) ;
5158: --

Line 5987: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

5983: END LOOP ;
5984: --
5985: END IF ;
5986: --
5987: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
5988: THEN
5989: --
5990: l_curr_activity := 'Upload_Member_Interface API comnpleted successfully.' ;
5991: --

Line 5993: FND_LOG.String

5989: --
5990: l_curr_activity := 'Upload_Member_Interface API comnpleted successfully.' ;
5991: --
5992: -- Put the current activity into log.
5993: FND_LOG.String
5994: ( log_level => FND_LOG.LEVEL_STATEMENT
5995: , module => l_api_name
5996: , message => 'Activity: ' || l_curr_activity
5997: ) ;

Line 5994: ( log_level => FND_LOG.LEVEL_STATEMENT

5990: l_curr_activity := 'Upload_Member_Interface API comnpleted successfully.' ;
5991: --
5992: -- Put the current activity into log.
5993: FND_LOG.String
5994: ( log_level => FND_LOG.LEVEL_STATEMENT
5995: , module => l_api_name
5996: , message => 'Activity: ' || l_curr_activity
5997: ) ;
5998: --

Line 6006: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )

6002: --
6003: WHEN OTHERS THEN
6004: ROLLBACK TO Upload_Member_Interface ;
6005: --
6006: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
6007: THEN
6008: -- Put the current activity into log.
6009: FND_LOG.String
6010: ( log_level => FND_LOG.LEVEL_STATEMENT

Line 6009: FND_LOG.String

6005: --
6006: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
6007: THEN
6008: -- Put the current activity into log.
6009: FND_LOG.String
6010: ( log_level => FND_LOG.LEVEL_STATEMENT
6011: , module => l_api_name
6012: , message => 'SQL Error ' || sqlerrm
6013: ) ;

Line 6010: ( log_level => FND_LOG.LEVEL_STATEMENT

6006: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL )
6007: THEN
6008: -- Put the current activity into log.
6009: FND_LOG.String
6010: ( log_level => FND_LOG.LEVEL_STATEMENT
6011: , module => l_api_name
6012: , message => 'SQL Error ' || sqlerrm
6013: ) ;
6014: --