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_FP_GEN_AMT_WRP_PKG dependencies on PA_DEBUG

Line 3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE BODY PA_FP_GEN_AMT_WRP_PKG AS
2: /* $Header: PAFPGAWB.pls 120.16.12020000.2 2013/01/22 17:20:10 kmaddi ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: PROCEDURE GEN_AMT_WRP(
6: errbuff OUT NOCOPY VARCHAR2,
7: retcode OUT NOCOPY VARCHAR2,

Line 107: IF P_PA_DEBUG_MODE = 'Y' THEN

103: --Bug 16181483 End
104:
105: BEGIN
106: -- hr_utility.trace_on(null,'Sharmila');
107: IF P_PA_DEBUG_MODE = 'Y' THEN
108: pa_debug.set_curr_function( p_function => 'GEN_AMT_WRP',
109: p_debug_mode => p_pa_debug_mode );
110: END IF;
111:

Line 108: pa_debug.set_curr_function( p_function => 'GEN_AMT_WRP',

104:
105: BEGIN
106: -- hr_utility.trace_on(null,'Sharmila');
107: IF P_PA_DEBUG_MODE = 'Y' THEN
108: pa_debug.set_curr_function( p_function => 'GEN_AMT_WRP',
109: p_debug_mode => p_pa_debug_mode );
110: END IF;
111:
112: /* Getting token values for use by possible error messages. */

Line 109: p_debug_mode => p_pa_debug_mode );

105: BEGIN
106: -- hr_utility.trace_on(null,'Sharmila');
107: IF P_PA_DEBUG_MODE = 'Y' THEN
108: pa_debug.set_curr_function( p_function => 'GEN_AMT_WRP',
109: p_debug_mode => p_pa_debug_mode );
110: END IF;
111:
112: /* Getting token values for use by possible error messages. */
113: FND_MESSAGE.SET_NAME('PA','PA_FP_GEN_EXCEPTION_INFO');

Line 276: IF p_pa_debug_mode = 'Y' THEN

272: --dbms_output.put_line('After execute, l_rows is: '||l_rows);
273: -- hr_utility.trace('After execute, l_rows is: '||l_rows);
274:
275: IF (l_rows < 0) THEN
276: IF p_pa_debug_mode = 'Y' THEN
277: pa_fp_gen_amount_utils.fp_debug
278: (p_called_mode => l_called_mode,
279: p_msg =>'After dbms parse '||to_char(l_rows),
280: p_module_name => l_module_name,

Line 282: PA_DEBUG.RESET_CURR_FUNCTION;

278: (p_called_mode => l_called_mode,
279: p_msg =>'After dbms parse '||to_char(l_rows),
280: p_module_name => l_module_name,
281: p_log_level => 5);
282: PA_DEBUG.RESET_CURR_FUNCTION;
283: END IF;
284: RETURN;
285: END IF;
286:

Line 403: IF p_pa_debug_mode = 'Y' THEN

399: FOR i in 1..l_count LOOP
400: l_generation_flag := 'Y';
401: l_gen_api_call_flag := 'Y';
402:
403: IF p_pa_debug_mode = 'Y' THEN
404: pa_fp_gen_amount_utils.fp_debug
405: (p_called_mode => l_called_mode,
406: p_msg =>'Before calling
407: pa_fin_plan_pub.Create_Version',

Line 471: IF p_pa_debug_mode = 'Y' THEN

467: WHEN OTHERS THEN
468: l_generation_flag := 'N';
469: END;
470:
471: IF p_pa_debug_mode = 'Y' THEN
472: pa_fp_gen_amount_utils.fp_debug
473: (p_called_mode => l_called_mode,
474: p_msg =>'Status aft calling pa_fin_plan_pub.Create_Version:'
475: ||l_return_status,

Line 481: IF p_pa_debug_mode = 'Y' THEN

477: p_log_level => 5);
478: END IF;
479:
480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
481: IF p_pa_debug_mode = 'Y' THEN
482: pa_fp_gen_amount_utils.fp_debug
483: (p_called_mode => l_called_mode,
484: p_msg =>'Raising invalid arg exc after create version api call',
485: p_module_name => l_module_name,

Line 494: IF p_pa_debug_mode = 'Y' THEN

490:
491: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
492: l_generation_flag := 'N';
493: l_msg_count := FND_MSG_PUB.Count_Msg;
494: IF p_pa_debug_mode = 'Y' THEN
495: pa_fp_gen_amount_utils.fp_debug
496: (p_called_mode => l_called_mode,
497: p_msg =>
498: 'Value of l_msg_count after calling create_version api: '||l_msg_count ,

Line 503: PA_DEBUG.g_err_stage := l_project_name_err_token || l_project_name ||

499: p_module_name => l_module_name,
500: p_log_level => 5);
501: END IF;
502:
503: PA_DEBUG.g_err_stage := l_project_name_err_token || l_project_name ||
504: ' ' ||l_fin_plan_type_err_token || l_plan_type_name;
505: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
506: p_write_file => 'OUT',
507: p_write_mode => 1);

Line 505: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,

501: END IF;
502:
503: PA_DEBUG.g_err_stage := l_project_name_err_token || l_project_name ||
504: ' ' ||l_fin_plan_type_err_token || l_plan_type_name;
505: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
506: p_write_file => 'OUT',
507: p_write_mode => 1);
508: IF l_msg_count > 0 THEN
509: IF l_msg_count = 1 THEN

Line 522: PA_DEBUG.g_err_stage := l_msg_data;

518: --dbms_output.put_line('x msg data in msg count 1 '||x_msg_data);
519: --dbms_output.put_line('l msg data in msg count 1: '||l_msg_data);
520: --hr_utility.trace('l msg data in msg count 1: '||l_msg_data);
521: --dbms_output.put_line('p msg index out in msg count 1: '||l_msg_index_out);
522: PA_DEBUG.g_err_stage := l_msg_data;
523: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
524: p_write_file => 'OUT',
525: p_write_mode => 1);
526: ELSE

Line 523: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,

519: --dbms_output.put_line('l msg data in msg count 1: '||l_msg_data);
520: --hr_utility.trace('l msg data in msg count 1: '||l_msg_data);
521: --dbms_output.put_line('p msg index out in msg count 1: '||l_msg_index_out);
522: PA_DEBUG.g_err_stage := l_msg_data;
523: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
524: p_write_file => 'OUT',
525: p_write_mode => 1);
526: ELSE
527: FOR j in 1 .. l_msg_count LOOP

Line 537: PA_DEBUG.g_err_stage := l_msg_data;

533: p_msg_count => l_msg_count ,
534: p_msg_data => l_msg_data_in ,
535: p_data => l_msg_data,
536: p_msg_index_out => l_msg_index_out );
537: PA_DEBUG.g_err_stage := l_msg_data;
538: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
539: p_write_file => 'OUT',
540: p_write_mode => 1);
541: --dbms_output.put_line('error # '||j||' '|| substr(l_msg_Data,1,200));

Line 538: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,

534: p_msg_data => l_msg_data_in ,
535: p_data => l_msg_data,
536: p_msg_index_out => l_msg_index_out );
537: PA_DEBUG.g_err_stage := l_msg_data;
538: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
539: p_write_file => 'OUT',
540: p_write_mode => 1);
541: --dbms_output.put_line('error # '||j||' '|| substr(l_msg_Data,1,200));
542: END LOOP;

Line 554: IF p_pa_debug_mode = 'Y' THEN

550: --hr_utility.trace('Value of plan_class_code b4 calling get_plan_version_dtls api: '||l_plan_class_code );
551: IF l_plan_class_code = 'FORECAST' AND
552: l_generation_flag = 'Y' THEN
553:
554: IF p_pa_debug_mode = 'Y' THEN
555: pa_fp_gen_amount_utils.fp_debug
556: (p_called_mode => l_called_mode,
557: p_msg => 'Before calling
558: pa_fp_gen_amount_utils.get_plan_version_dtls',

Line 576: IF p_pa_debug_mode = 'Y' THEN

572: l_gen_api_call_flag := 'N';
573: END;
574: -- dbms_output.put_line('Status after calling get_plan_version_dtls api: '||l_return_status);
575: -- hr_utility.trace('L_RETURN_Status after calling get_plan_version_dtls api: '||l_return_status);
576: IF p_pa_debug_mode = 'Y' THEN
577: pa_fp_gen_amount_utils.fp_debug
578: (p_called_mode => l_called_mode,
579: p_msg => 'Status after calling
580: pa_fp_gen_amount_utils.get_plan_version_dtls'

Line 587: IF p_pa_debug_mode = 'Y' THEN

583: p_log_level => 5);
584: END IF;
585:
586: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
587: IF p_pa_debug_mode = 'Y' THEN
588: pa_fp_gen_amount_utils.fp_debug
589: (p_called_mode => l_called_mode,
590: p_msg =>'Raising invalid arg exc after Get Plan ver dtls api call',
591: p_module_name => l_module_name,

Line 772: IF P_PA_DEBUG_MODE = 'Y' THEN

768: OR l_gen_src_plan_ver_code = 'ORIGINAL_BASELINED'
769: OR l_gen_src_plan_ver_code = 'CURRENT_APPROVED'
770: OR l_gen_src_plan_ver_code = 'ORIGINAL_APPROVED' THEN
771: /*Get the current baselined or original baselined version*/
772: IF P_PA_DEBUG_MODE = 'Y' THEN
773: pa_fp_gen_amount_utils.fp_debug
774: (p_called_mode => l_called_mode,
775: p_msg => 'Before calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info',
776: p_module_name => l_module_name,

Line 790: IF P_PA_DEBUG_MODE = 'Y' THEN

786: x_fin_plan_version_id => l_etc_fp_ver_id,
787: x_return_status => l_return_status,
788: x_msg_count => l_msg_count,
789: x_msg_data => l_msg_data);
790: IF P_PA_DEBUG_MODE = 'Y' THEN
791: pa_fp_gen_amount_utils.fp_debug
792: (p_called_mode => l_called_mode,
793: p_msg =>'After calling pa_fp_gen_amount_utils.Get_Curr_Original_Version_Info,return status is: '
794: ||l_return_status,

Line 801: IF p_pa_debug_mode = 'Y' THEN

797: END IF;
798:
799:
800: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
801: IF p_pa_debug_mode = 'Y' THEN
802: pa_fp_gen_amount_utils.fp_debug
803: (p_called_mode => l_called_mode,
804: p_msg=>'Raising invalid arg exc aft Get Curr Original ver api call',
805: p_module_name => l_module_name,

Line 817: IF P_PA_DEBUG_MODE = 'Y' THEN

813:
814:
815: ELSIF l_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
816: /*Get the current working version*/
817: IF P_PA_DEBUG_MODE = 'Y' THEN
818: pa_fp_gen_amount_utils.fp_debug
819: (p_called_mode => l_called_mode,
820: p_msg => 'Before calling pa_fin_plan_utils.Get_Curr_Working_Version_Info',
821: p_module_name => l_module_name,

Line 833: IF P_PA_DEBUG_MODE = 'Y' THEN

829: x_fin_plan_version_id => l_etc_fp_ver_id,
830: x_return_status => l_return_status,
831: x_msg_count => l_msg_count,
832: x_msg_data => l_msg_data);
833: IF P_PA_DEBUG_MODE = 'Y' THEN
834: pa_fp_gen_amount_utils.fp_debug
835: (p_called_mode => l_called_mode,
836: p_msg =>
837: 'Aft calling pa_fin_plan_utils.Get_Curr_Working_Version_Info ret sta:'

Line 844: IF p_pa_debug_mode = 'Y' THEN

840: p_log_level => 5);
841: END IF;
842:
843: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
844: IF p_pa_debug_mode = 'Y' THEN
845: pa_fp_gen_amount_utils.fp_debug
846: (p_called_mode => l_called_mode,
847: p_msg=>'Raising invalid arg exc aft Get Curr Wkg ver api call',
848: p_module_name => l_module_name,

Line 879: IF p_pa_debug_mode = 'Y' THEN

875: -- Source Work plan and Financial Plan time phased and ETC Source for
876: -- Source Work plan is either 'Workplan Resources' or 'Financial Plan'
877: IF l_copy_etc_from_plan_flag = 'Y' THEN
878: BEGIN --Begining of the block for validation_for_copy_etc_flag
879: IF p_pa_debug_mode = 'Y' THEN
880: pa_fp_gen_amount_utils.fp_debug
881: (p_msg => 'Before calling
882: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag',
883: p_module_name => l_module_name,

Line 895: IF p_pa_debug_mode = 'Y' THEN

891: p_etc_plan_version_id => l_etc_fp_ver_id,
892: x_return_status => l_return_status,
893: x_msg_count => l_msg_count,
894: x_msg_data => l_msg_data);
895: IF p_pa_debug_mode = 'Y' THEN
896: pa_fp_gen_amount_utils.fp_debug
897: (p_msg => 'Status after calling
898: pa_fp_gen_fcst_pg_pkg.validation_for_copy_etc_flag: '
899: ||l_return_status,

Line 910: IF P_PA_DEBUG_MODE = 'Y' THEN

906: l_gen_api_call_flag := 'N';
907: l_return_status := FND_API.G_RET_STS_ERROR;
908: l_msg_count := 1;
909: l_msg_data := substr(sqlerrm,1,240);
910: IF P_PA_DEBUG_MODE = 'Y' THEN
911: pa_fp_gen_amount_utils.fp_debug
912: (p_called_mode => l_called_mode,
913: p_msg => 'Error: Validate Copy ETC from Plan'||l_msg_data,
914: p_module_name => l_module_name,

Line 953: IF P_PA_DEBUG_MODE = 'Y' THEN

949: SET ACTUAL_AMTS_THRU_PERIOD = l_act_thru_period
950: WHERE BUDGET_VERSION_ID = lx_budget_version_id;
951:
952: --hr_utility.trace('l_etc_fp_type_id : '||l_etc_fp_type_id);
953: IF P_PA_DEBUG_MODE = 'Y' THEN
954: pa_fp_gen_amount_utils.fp_debug
955: (p_called_mode => l_called_mode,
956: p_msg => 'Before calling PA_FP_GEN_FCST_AMT_PUB.GENERATE_FCST_AMT_WRP'||
957: 'l_proj_id = '||l_proj_id,

Line 1057: IF p_pa_debug_mode = 'Y' THEN

1053: */
1054:
1055: IF l_gen_api_call_flag = 'Y' THEN
1056: BEGIN
1057: IF p_pa_debug_mode = 'Y' THEN
1058: pa_fp_gen_amount_utils.fp_debug
1059: ( p_called_mode => l_called_mode,
1060: p_msg => 'Before calling
1061: pa_fp_gen_amount_utils.validate_support_cases',

Line 1072: IF p_pa_debug_mode = 'Y' THEN

1068: X_WARNING_MESSAGE => l_warning_message, /* Added for ER 4391321 */
1069: X_RETURN_STATUS => l_return_status,
1070: X_MSG_COUNT => l_msg_count,
1071: X_MSG_DATA => l_msg_data );
1072: IF p_pa_debug_mode = 'Y' THEN
1073: pa_fp_gen_amount_utils.fp_debug
1074: ( p_called_mode => l_called_mode,
1075: p_msg => 'Status after calling
1076: pa_fp_gen_amount_utils.validate_support_cases: '

Line 1082: IF p_pa_debug_mode = 'Y' THEN

1078: p_module_name => l_module_name,
1079: p_log_level => 5 );
1080: END IF;
1081: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1082: IF p_pa_debug_mode = 'Y' THEN
1083: pa_fp_gen_amount_utils.fp_debug
1084: (p_called_mode => l_called_mode,
1085: p_msg=>'Raising invalid arg exc aft validation api call',
1086: p_module_name => l_module_name,

Line 1124: IF P_PA_DEBUG_MODE = 'Y' THEN

1120: P_WP_STRUCTURE_VERSION_ID =>l_etc_wp_struct_ver_id,
1121: X_RETURN_STATUS => l_return_status,
1122: X_MSG_COUNT => l_msg_count,
1123: X_MSG_DATA => l_msg_data );
1124: IF P_PA_DEBUG_MODE = 'Y' THEN
1125: pa_fp_gen_amount_utils.fp_debug
1126: (p_called_mode => l_called_mode,
1127: p_msg =>
1128: 'After calling PA_FP_GEN_FCST_AMT_PUB.GENERATE_FCST_AMT_WRP'||

Line 1137: IF p_pa_debug_mode = 'Y' THEN

1133: -- hr_utility.trace('l_return_status after GENERATE_FCST_AMT_WRP '||l_return_status);
1134: -- hr_utility.trace('l_version_generation GENERATE_FCST_AMT_WRP '||l_generation_flag);
1135:
1136: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1137: IF p_pa_debug_mode = 'Y' THEN
1138: pa_fp_gen_amount_utils.fp_debug
1139: (p_called_mode => l_called_mode,
1140: p_msg=>'Raising invalid arg exc aft Fcst Gen api call',
1141: p_module_name => l_module_name,

Line 1159: IF P_PA_DEBUG_MODE = 'Y' THEN

1155: l_return_status := FND_API.G_RET_STS_ERROR;
1156: l_msg_count := 1;
1157: l_msg_data := substr(sqlerrm,1,240);
1158: --dbms_output.put_line('error msg :'||x_msg_data);
1159: IF P_PA_DEBUG_MODE = 'Y' THEN
1160: pa_fp_gen_amount_utils.fp_debug
1161: (p_called_mode => l_called_mode,
1162: p_msg => 'Forecast Gen Error'||l_msg_data,
1163: p_module_name => l_module_name,

Line 1175: IF p_pa_debug_mode = 'Y' THEN

1171: -- hr_utility.trace('l_gen_api_call_flag _flag after FCST GEN '||l_gen_api_call_flag);
1172: ELSIF l_plan_class_code = 'BUDGET' AND
1173: l_generation_flag = 'Y' AND
1174: l_gen_api_call_flag = 'Y' THEN
1175: IF p_pa_debug_mode = 'Y' THEN
1176: pa_fp_gen_amount_utils.fp_debug
1177: (p_called_mode => l_called_mode,
1178: p_msg =>
1179: 'Before calling PA_FP_WP_GEN_BUDGET_AMT_PUB.GENERATE_WP_BUDGET_AMT'||

Line 1213: IF p_pa_debug_mode = 'Y' THEN

1209: -- dbms_output.put_line('after budget generation l_proj_id: '||l_proj_id);
1210: -- hr_utility.trace('after budget generation l_proj_id: '||l_proj_id);
1211: -- dbms_output.put_line(': '||FND_API.G_RET_STS_SUCCESS);
1212: -- hr_utility.trace('FND API. G RET STS SUCCESS: '||FND_API.G_RET_STS_SUCCESS);
1213: IF p_pa_debug_mode = 'Y' THEN
1214: pa_fp_gen_amount_utils.fp_debug
1215: (p_called_mode => l_called_mode,
1216: p_msg => 'Status after calling
1217: PA_FP_WP_GEN_BUDGET_AMT_PUB.GENERATE_WP_BUDGET_AMT:'

Line 1223: IF p_pa_debug_mode = 'Y' THEN

1219: p_module_name => l_module_name,
1220: p_log_level => 5);
1221: END IF;
1222: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1223: IF p_pa_debug_mode = 'Y' THEN
1224: pa_fp_gen_amount_utils.fp_debug
1225: (p_called_mode => l_called_mode,
1226: p_msg=>'Raising invalid arg exc aft Bdgt Gen api call',
1227: p_module_name => l_module_name,

Line 1245: IF P_PA_DEBUG_MODE = 'Y' THEN

1241: l_return_status := FND_API.G_RET_STS_ERROR;
1242: l_msg_count := 1;
1243: l_msg_data := substr(sqlerrm,1,240);
1244: --dbms_output.put_line('error msg :'||x_msg_data);
1245: IF P_PA_DEBUG_MODE = 'Y' THEN
1246: pa_fp_gen_amount_utils.fp_debug
1247: (p_called_mode => l_called_mode,
1248: p_msg => 'Budget Gen Error'||l_msg_data,
1249: p_module_name => l_module_name,

Line 1260: IF p_pa_debug_mode = 'Y' THEN

1256: END IF;--For IF condition for BUDGET
1257:
1258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1259: -- hr_utility.trace('INVALID EXCEPTION!!!');
1260: IF p_pa_debug_mode = 'Y' THEN
1261: pa_fp_gen_amount_utils.fp_debug
1262: (p_called_mode => l_called_mode,
1263: p_msg=>'Raising invalid arg exc aft Fcst / Bdgt Gen api call',
1264: p_module_name => l_module_name,

Line 1275: IF p_pa_debug_mode = 'Y' THEN

1271: END IF;
1272:
1273: IF l_gen_api_call_flag = 'N' THEN
1274: l_msg_count := FND_MSG_PUB.Count_Msg;
1275: IF p_pa_debug_mode = 'Y' THEN
1276: pa_fp_gen_amount_utils.fp_debug
1277: (p_called_mode => l_called_mode,
1278: p_msg =>
1279: 'Value of l_msg_count after calling Budget / Forecast Gen API'

Line 1285: PA_DEBUG.g_err_stage := l_project_name_err_token || l_project_name ||

1281: p_module_name => l_module_name,
1282: p_log_level => 5);
1283: END IF;
1284: IF l_msg_count > 0 THEN
1285: PA_DEBUG.g_err_stage := l_project_name_err_token || l_project_name ||
1286: ' ' ||l_fin_plan_type_err_token || l_plan_type_name;
1287: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1288: p_write_file => 'OUT',
1289: p_write_mode => 1);

Line 1287: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,

1283: END IF;
1284: IF l_msg_count > 0 THEN
1285: PA_DEBUG.g_err_stage := l_project_name_err_token || l_project_name ||
1286: ' ' ||l_fin_plan_type_err_token || l_plan_type_name;
1287: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1288: p_write_file => 'OUT',
1289: p_write_mode => 1);
1290: IF l_msg_count = 1 THEN
1291: l_msg_data_in := l_msg_data;

Line 1300: PA_DEBUG.g_err_stage := l_msg_data;

1296: p_msg_data => l_msg_data_in ,
1297: p_data => l_msg_data,
1298: p_msg_index_out => l_msg_index_out);
1299:
1300: PA_DEBUG.g_err_stage := l_msg_data;
1301: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1302: p_write_file => 'OUT',
1303: p_write_mode => 1);
1304: --dbms_output.put_line('x msg data in msg count 1 '||x_msg_data);

Line 1301: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,

1297: p_data => l_msg_data,
1298: p_msg_index_out => l_msg_index_out);
1299:
1300: PA_DEBUG.g_err_stage := l_msg_data;
1301: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1302: p_write_file => 'OUT',
1303: p_write_mode => 1);
1304: --dbms_output.put_line('x msg data in msg count 1 '||x_msg_data);
1305: --dbms_output.put_line('l msg data in msg count 1: '||l_msg_data);

Line 1319: PA_DEBUG.g_err_stage := l_msg_data;

1315: p_msg_data => l_msg_data_in ,
1316: p_data => l_msg_data,
1317: p_msg_index_out => l_msg_index_out );
1318:
1319: PA_DEBUG.g_err_stage := l_msg_data;
1320: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1321: p_write_file => 'OUT',
1322: p_write_mode => 1);
1323: -- dbms_output.put_line('error # '||j||' '||substr(l_msg_Data,1,200));

Line 1320: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,

1316: p_data => l_msg_data,
1317: p_msg_index_out => l_msg_index_out );
1318:
1319: PA_DEBUG.g_err_stage := l_msg_data;
1320: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1321: p_write_file => 'OUT',
1322: p_write_mode => 1);
1323: -- dbms_output.put_line('error # '||j||' '||substr(l_msg_Data,1,200));
1324: END LOOP;

Line 1336: IF p_pa_debug_mode = 'Y' THEN

1332: -- Added code to handle error after processing each plan type
1333: END IF;
1334: IF l_plan_type_validated = 'N' THEN
1335: l_msg_count := FND_MSG_PUB.Count_Msg;
1336: IF p_pa_debug_mode = 'Y' THEN
1337: pa_fp_gen_amount_utils.fp_debug
1338: (p_called_mode => l_called_mode,
1339: p_msg =>
1340: 'Value of l_msg_count after processing Plan Type :'||l_plan_type_name

Line 1346: PA_DEBUG.g_err_stage := l_project_name_err_token || l_project_name ||

1342: p_module_name => l_module_name,
1343: p_log_level => 5);
1344: END IF;
1345: IF l_msg_count > 0 THEN
1346: PA_DEBUG.g_err_stage := l_project_name_err_token || l_project_name ||
1347: ' ' ||l_fin_plan_type_err_token || l_plan_type_name;
1348: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1349: p_write_file => 'OUT',
1350: p_write_mode => 1);

Line 1348: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,

1344: END IF;
1345: IF l_msg_count > 0 THEN
1346: PA_DEBUG.g_err_stage := l_project_name_err_token || l_project_name ||
1347: ' ' ||l_fin_plan_type_err_token || l_plan_type_name;
1348: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1349: p_write_file => 'OUT',
1350: p_write_mode => 1);
1351: IF l_msg_count = 1 THEN
1352: PA_INTERFACE_UTILS_PUB.get_messages

Line 1360: PA_DEBUG.g_err_stage := l_msg_data;

1356: p_msg_data => l_msg_data ,
1357: p_data => l_msg_data,
1358: p_msg_index_out => l_msg_index_out);
1359:
1360: PA_DEBUG.g_err_stage := l_msg_data;
1361: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1362: p_write_file => 'OUT',
1363: p_write_mode => 1);
1364: ELSE

Line 1361: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,

1357: p_data => l_msg_data,
1358: p_msg_index_out => l_msg_index_out);
1359:
1360: PA_DEBUG.g_err_stage := l_msg_data;
1361: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1362: p_write_file => 'OUT',
1363: p_write_mode => 1);
1364: ELSE
1365: FOR j in 1 .. l_msg_count LOOP

Line 1374: PA_DEBUG.g_err_stage := l_msg_data;

1370: p_msg_data => l_msg_data ,
1371: p_data => l_msg_data,
1372: p_msg_index_out => l_msg_index_out );
1373:
1374: PA_DEBUG.g_err_stage := l_msg_data;
1375: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1376: p_write_file => 'OUT',
1377: p_write_mode => 1);
1378: END LOOP;

Line 1375: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,

1371: p_data => l_msg_data,
1372: p_msg_index_out => l_msg_index_out );
1373:
1374: PA_DEBUG.g_err_stage := l_msg_data;
1375: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
1376: p_write_file => 'OUT',
1377: p_write_mode => 1);
1378: END LOOP;
1379: END IF;

Line 1387: IF P_PA_DEBUG_MODE = 'Y' THEN

1383: END LOOP;
1384:
1385: DBMS_SQL.CLOSE_CURSOR(sql_cursor); -- Bug 5715252 Cursor is closed
1386:
1387: IF P_PA_DEBUG_MODE = 'Y' THEN
1388: PA_DEBUG.RESET_CURR_FUNCTION;
1389: END IF;
1390: EXCEPTION
1391: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

Line 1388: PA_DEBUG.RESET_CURR_FUNCTION;

1384:
1385: DBMS_SQL.CLOSE_CURSOR(sql_cursor); -- Bug 5715252 Cursor is closed
1386:
1387: IF P_PA_DEBUG_MODE = 'Y' THEN
1388: PA_DEBUG.RESET_CURR_FUNCTION;
1389: END IF;
1390: EXCEPTION
1391: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1392: -- hr_utility.trace('Inside invalid arg Ex');

Line 1412: IF P_PA_DEBUG_MODE = 'Y' THEN

1408: -- hr_utility.trace('Outside-l_return_status'||l_return_status);
1409: l_return_status := FND_API.G_RET_STS_ERROR;
1410: -- hr_utility.trace('Outside Error-l_return_status'||l_return_status);
1411:
1412: IF P_PA_DEBUG_MODE = 'Y' THEN
1413: pa_fp_gen_amount_utils.fp_debug
1414: (p_called_mode => l_called_mode,
1415: p_msg => 'Invalid Arg Exc Error'||substr(sqlerrm, 1, 240),
1416: p_module_name => l_module_name,

Line 1418: PA_DEBUG.RESET_CURR_FUNCTION;

1414: (p_called_mode => l_called_mode,
1415: p_msg => 'Invalid Arg Exc Error'||substr(sqlerrm, 1, 240),
1416: p_module_name => l_module_name,
1417: p_log_level => 5);
1418: PA_DEBUG.RESET_CURR_FUNCTION;
1419: END IF;
1420:
1421: retcode := '2';
1422: errbuff := substr(sqlerrm,1,240);

Line 1443: IF P_PA_DEBUG_MODE = 'Y' THEN

1439: FND_MSG_PUB.add_exc_msg
1440: ( p_pkg_name => ' PA_FP_GEN_AMT_WRP_PKG',
1441: p_procedure_name => 'GEN_AMT_WRP',
1442: p_error_text => substr(sqlerrm,1,240));
1443: IF P_PA_DEBUG_MODE = 'Y' THEN
1444: pa_fp_gen_amount_utils.fp_debug
1445: (p_called_mode => l_called_mode,
1446: p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1447: p_module_name => l_module_name,

Line 1449: PA_DEBUG.RESET_CURR_FUNCTION;

1445: (p_called_mode => l_called_mode,
1446: p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
1447: p_module_name => l_module_name,
1448: p_log_level => 5);
1449: PA_DEBUG.RESET_CURR_FUNCTION;
1450: END IF;
1451: retcode := '2';
1452: errbuff := substr(sqlerrm,1,240);
1453: