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_WEBADI_PKG dependencies on PA_FP_WEBADI_PKG

Line 1: PACKAGE BODY pa_fp_webadi_pkg as

1: PACKAGE BODY pa_fp_webadi_pkg as
2: /* $Header: PAFPWAPB.pls 120.47.12010000.3 2008/10/21 14:02:49 vgovvala ship $ */
3:
4: Validation_Failed_Exc Exception ;
5: BV_Validation_Failed_Exc Exception; -- Exception to be used if the validation fails at version level

Line 7: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_webadi_pkg';

3:
4: Validation_Failed_Exc Exception ;
5: BV_Validation_Failed_Exc Exception; -- Exception to be used if the validation fails at version level
6:
7: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_webadi_pkg';
8: --wlog varchar2(1):='Y';
9:
10: -- Bug 3986129: FP.M Web ADI Dev changes. Added the following exceptions
11: Bv_Period_Mask_Changed_Exc EXCEPTION;

Line 335: pa_debug.g_err_stage := ':In pa_fp_webadi_pkg.DELETE_XFACE' ;

331:
332: IF l_debug_mode = 'Y' THEN
333: pa_debug.set_curr_function( p_function => 'DELETE_XFACE'
334: ,p_debug_mode => l_debug_mode );
335: pa_debug.g_err_stage := ':In pa_fp_webadi_pkg.DELETE_XFACE' ;
336: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
337: END IF;
338:
339: l_preserve_rows_flag := 'N';

Line 426: ( p_pkg_name => 'pa_fp_webadi_pkg'

422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: x_msg_count := 1;
424: x_msg_data := SQLERRM;
425: FND_MSG_PUB.add_exc_msg
426: ( p_pkg_name => 'pa_fp_webadi_pkg'
427: ,p_procedure_name => 'DELETE_XFACE' );
428: IF l_debug_mode = 'Y' THEN
429: pa_debug.write('DELETE_XFACE' || g_module_name,SQLERRM,4);
430: pa_debug.write('DELETE_XFACE' || g_module_name,pa_debug.G_Err_Stack,4);

Line 505: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.validate_header_info';

501: l_msg_data VARCHAR2(2000);
502: l_msg_count NUMBER;
503:
504: l_debug_mode VARCHAR2(1);
505: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.validate_header_info';
506: l_debug_level3 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3;
507: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
508: l_data VARCHAR2(2000);
509: l_msg_index_out NUMBER;

Line 522: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.validate_header_info';

518: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
519: p_debug_mode => l_debug_mode );
520: END IF;
521: IF l_debug_mode = 'Y' THEN
522: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.validate_header_info';
523: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
524: END IF;
525:
526: --log1('----- Entering into validate_header_info-------');

Line 788: pa_debug.g_err_stage := 'Leaving into pa_fp_webadi_pkg.validate_header_info';

784: --log1('----- STAGE 7-------');
785: END IF; -- p_submit_flag = 'Y'
786:
787: IF l_debug_mode = 'Y' THEN
788: pa_debug.g_err_stage := 'Leaving into pa_fp_webadi_pkg.validate_header_info';
789: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
790: END IF;
791: IF l_debug_mode = 'Y' THEN
792: pa_debug.reset_curr_function;

Line 982: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

978: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
979: x_msg_count := 1;
980: x_msg_data := SQLERRM;
981:
982: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
983: ,p_procedure_name => 'prepare_val_input');
984: IF l_debug_mode = 'Y' THEN
985: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
986: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 1029: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.process_errors';

1025: l_msg_data VARCHAR2(2000);
1026: l_msg_count NUMBER;
1027:
1028: l_debug_mode VARCHAR2(1);
1029: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.process_errors';
1030: l_debug_level3 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3;
1031: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
1032: l_msg_index_out NUMBER;
1033: l_data VARCHAR2(2000);

Line 1045: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.process_errors';

1041: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1042: p_debug_mode => l_debug_mode );
1043: END IF;
1044: IF l_debug_mode = 'Y' THEN
1045: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.process_errors';
1046: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1047: END IF;
1048:
1049: --log1('PE 1'||p_error_code_tbl.COUNT);

Line 1212: pa_debug.g_err_stage := 'Leaving into pa_fp_webadi_pkg.process_errors';

1208: -- placing a commit here to retain all the error codes stamped.
1209: -- COMMIT;
1210:
1211: IF l_debug_mode = 'Y' THEN
1212: pa_debug.g_err_stage := 'Leaving into pa_fp_webadi_pkg.process_errors';
1213: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1214: END IF;
1215: IF l_debug_mode = 'Y' THEN
1216: pa_debug.reset_curr_function;

Line 1248: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: x_msg_count := 1;
1246: x_msg_data := SQLERRM;
1247:
1248: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
1249: ,p_procedure_name => 'process_errors');
1250: IF l_debug_mode = 'Y' THEN
1251: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
1252: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 1279: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.read_global_var_to_report_err';

1275: l_msg_data VARCHAR2(2000);
1276: l_msg_count NUMBER;
1277:
1278: l_debug_mode VARCHAR2(1);
1279: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.read_global_var_to_report_err';
1280: l_debug_level3 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3;
1281: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
1282: l_msg_index_out NUMBER;
1283: l_data VARCHAR2(2000);

Line 1299: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.read_global_var_to_report_err';

1295: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1296: p_debug_mode => l_debug_mode );
1297: END IF;
1298: IF l_debug_mode = 'Y' THEN
1299: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.read_global_var_to_report_err';
1300: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1301: END IF;
1302:
1303: -- checking if there is some value in the global table

Line 1322: pa_fp_webadi_pkg.process_errors

1318: l_err_txn_curr_tbl.EXTEND(1);
1319: l_err_txn_curr_tbl(l_err_txn_curr_tbl.COUNT) := g_fp_webadi_rec_tbl(i).txn_currency;
1320: END LOOP;
1321:
1322: pa_fp_webadi_pkg.process_errors
1323: ( p_run_id => p_run_id,
1324: p_error_code_tbl => l_err_val_code_tbl,
1325: p_task_id_tbl => l_err_task_id_tbl,
1326: p_rlm_id_tbl => l_err_rlm_id_tbl,

Line 1347: pa_debug.g_err_stage := 'Leaving into pa_fp_webadi_pkg.read_global_var_to_report_err';

1343: END IF;
1344: RAISE PA_FP_CONSTANTS_PKG.Just_Ret_Exc;
1345: END IF;
1346: IF l_debug_mode = 'Y' THEN
1347: pa_debug.g_err_stage := 'Leaving into pa_fp_webadi_pkg.read_global_var_to_report_err';
1348: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1349: END IF;
1350: IF l_debug_mode = 'Y' THEN
1351: pa_debug.reset_curr_function;

Line 1398: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

1394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1395: x_msg_count := 1;
1396: x_msg_data := SQLERRM;
1397:
1398: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
1399: ,p_procedure_name => 'read_global_var_to_report_err');
1400: IF l_debug_mode = 'Y' THEN
1401: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
1402: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 1449: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.check_and_update_txn_curr_code';

1445: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1446: p_debug_mode => l_debug_mode );
1447: END IF;
1448: IF l_debug_mode = 'Y' THEN
1449: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.check_and_update_txn_curr_code';
1450: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1451: END IF;
1452:
1453: -- validating input params.

Line 1479: pa_debug.g_err_stage := 'Leaving into pa_fp_webadi_pkg.check_and_update_txn_curr_code';

1475: END LOOP;
1476: END IF;
1477:
1478: IF l_debug_mode = 'Y' THEN
1479: pa_debug.g_err_stage := 'Leaving into pa_fp_webadi_pkg.check_and_update_txn_curr_code';
1480: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1481: END IF;
1482: IF l_debug_mode = 'Y' THEN
1483: pa_debug.reset_curr_function;

Line 1519: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

1515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1516: x_msg_count := 1;
1517: x_msg_data := SQLERRM;
1518:
1519: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
1520: ,p_procedure_name => 'check_and_update_txn_curr_code');
1521: IF l_debug_mode = 'Y' THEN
1522: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
1523: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 1565: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.conv_attributes_displayed';

1561: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1562: p_debug_mode => l_debug_mode );
1563: END IF;
1564: IF l_debug_mode = 'Y' THEN
1565: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.conv_attributes_displayed';
1566: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1567: END IF;
1568:
1569: conv_attrb_displayed := 'N';

Line 1624: pa_debug.g_err_stage := 'Leaving into pa_fp_webadi_pkg.conv_attributes_displayed';

1620: END;
1621:
1622:
1623: IF l_debug_mode = 'Y' THEN
1624: pa_debug.g_err_stage := 'Leaving into pa_fp_webadi_pkg.conv_attributes_displayed';
1625: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1626: pa_debug.g_err_stage := 'conv_attrb_displayed: ' || conv_attrb_displayed;
1627: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1628: END IF;

Line 1648: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

1644: END IF;
1645: RAISE;
1646:
1647: WHEN OTHERS THEN
1648: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
1649: ,p_procedure_name => 'conv_attributes_displayed');
1650: IF l_debug_mode = 'Y' THEN
1651: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
1652: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 1704: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.prepare_val_input';

1700: l_msg_data VARCHAR2(2000);
1701: l_msg_count NUMBER;
1702:
1703: l_debug_mode VARCHAR2(1);
1704: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.prepare_val_input';
1705: l_debug_level3 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3;
1706: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
1707: l_msg_index_out NUMBER;
1708: l_data VARCHAR2(2000);

Line 2001: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.prepare_val_input';

1997: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
1998: p_debug_mode => l_debug_mode );
1999:
2000: IF l_debug_mode = 'Y' THEN
2001: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.prepare_val_input';
2002: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2003: END IF;
2004:
2005: --log1('----- Entering into prepare_val_input-------');

Line 5834: pa_debug.g_err_stage := 'Leaving pa_fp_webadi_pkg.prepare_val_input';

5830: x_rbs_elem_id_tbl := l_rbs_elem_id_tbl;
5831: x_amt_type_tbl := l_amount_type_tbl;
5832:
5833: IF l_debug_mode = 'Y' THEN
5834: pa_debug.g_err_stage := 'Leaving pa_fp_webadi_pkg.prepare_val_input';
5835: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
5836: END IF;
5837:
5838: pa_debug.reset_curr_function;

Line 5870: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

5866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5867: x_msg_count := 1;
5868: x_msg_data := SQLERRM;
5869:
5870: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
5871: ,p_procedure_name => 'prepare_val_input');
5872: IF l_debug_mode = 'Y' THEN
5873: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
5874: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 5894: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.get_amount_in_prd_x';

5890: )
5891: RETURN NUMBER
5892: IS
5893: -- variables used for debugging
5894: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.get_amount_in_prd_x';
5895: l_debug_mode VARCHAR2(1) := 'N';
5896: l_amount NUMBER;
5897: BEGIN
5898: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);

Line 6053: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

6049:
6050: EXCEPTION
6051: WHEN OTHERS THEN
6052:
6053: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
6054: ,p_procedure_name => 'get_amount_in_prd_x');
6055: IF l_debug_mode = 'Y' THEN
6056: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
6057: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);

Line 6642: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

6638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6639: x_msg_count := 1;
6640: x_msg_data := SQLERRM;
6641:
6642: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
6643: ,p_procedure_name => 'get_total_fcst_amounts');
6644:
6645: IF l_debug_mode = 'Y' THEN
6646: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 6748: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.prepare_pbl_input';

6744: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6745: )
6746: IS
6747: -- variables used for debugging
6748: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.prepare_pbl_input';
6749: l_debug_mode VARCHAR2(1) := 'N';
6750: l_debug_level3 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3;
6751: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
6752:

Line 7919: pa_debug.g_err_stage := 'Leaving pa_fp_webadi_pkg.prepare_pbl_input';

7915: END IF; --p_context
7916:
7917:
7918: IF l_debug_mode = 'Y' THEN
7919: pa_debug.g_err_stage := 'Leaving pa_fp_webadi_pkg.prepare_pbl_input';
7920: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
7921: END IF;
7922:
7923: IF l_debug_mode = 'Y' THEN

Line 7955: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

7951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7952: x_msg_count := 1;
7953: x_msg_data := SQLERRM;
7954:
7955: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
7956: ,p_procedure_name => 'prepare_pbl_input');
7957: IF l_debug_mode = 'Y' THEN
7958: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
7959: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 8021: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.process_budget_lines';

8017: )
8018:
8019: IS
8020: -- variables used for debugging
8021: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.process_budget_lines';
8022: l_debug_mode VARCHAR2(1) := 'N';
8023: l_debug_level3 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3;
8024: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
8025:

Line 10057: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

10053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10054: x_msg_count := 1;
10055: x_msg_data := SQLERRM;
10056:
10057: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
10058: ,p_procedure_name => 'process_budget_lines');
10059: IF l_debug_mode = 'Y' THEN
10060: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
10061: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 10119: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.switcher';

10115: p_calling_mode IN VARCHAR2)
10116:
10117: IS
10118: -- variables used for debugging
10119: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.switcher';
10120: l_debug_mode VARCHAR2(1) := 'N';
10121: l_debug_level3 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3;
10122: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
10123:

Line 11156: pa_fp_webadi_pkg.DELETE_XFACE

11152: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
11153: END IF;
11154: --log1('12 '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
11155:
11156: pa_fp_webadi_pkg.DELETE_XFACE
11157: ( p_run_id => p_run_id
11158: ,x_return_status => x_return_status
11159: ,x_msg_count => x_msg_count
11160: ,x_msg_data => l_msg_data --x_msg_data Bug 2764950

Line 11167: pa_debug.g_err_stage := 'Leaving pa_fp_webadi_pkg.switcher';

11163: COMMIT; /* to commit the data in DB after successful processing */
11164: --log1('14 '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
11165: --log1('----- STAGE 14-------');
11166: IF l_debug_mode = 'Y' THEN
11167: pa_debug.g_err_stage := 'Leaving pa_fp_webadi_pkg.switcher';
11168: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
11169: pa_debug.reset_curr_function;
11170: END IF;
11171:

Line 11280: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

11276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11277: x_msg_count := 1;
11278: x_msg_data := SQLERRM;
11279:
11280: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
11281: ,p_procedure_name => 'switcher');
11282: IF l_debug_mode = 'Y' THEN
11283: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
11284: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 11423: pa_fp_webadi_pkg.switcher

11419: ELSE
11420: l_submit_fcst_flag:=p_submit_ver_flag;
11421: END IF;
11422: --log1('----- STAGE CR7-------');
11423: pa_fp_webadi_pkg.switcher
11424: (p_calling_mode => 'ONLINE',
11425: p_run_id => p_run_id,
11426: p_submit_budget_flag => l_submit_bdgt_flag,
11427: p_submit_forecast_flag => l_submit_fcst_flag,

Line 11437: pa_debug.g_err_stage:='pa_fp_webadi_pkg.switcher returned error';

11433: --log1('----- STAGE CR8-------');
11434: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11435: --log1('----- STAGE CR9-------');
11436: IF l_debug_mode = 'Y' THEN
11437: pa_debug.g_err_stage:='pa_fp_webadi_pkg.switcher returned error';
11438: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
11439: END IF;
11440: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11441: END IF;

Line 11540: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

11536: -- bug 4477397: doing a general rollback instead to savepoint
11537: ROLLBACK;
11538: errbuf := SQLERRM;
11539:
11540: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
11541: ,p_procedure_name => 'process_MSExcel_data');
11542:
11543: IF l_debug_mode = 'Y' THEN
11544: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 11634: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.get_period_information';

11630: l_data VARCHAR2(2000);
11631: l_msg_count NUMBER := 0;
11632: l_msg_data VARCHAR2(2000);
11633: l_msg_index_out NUMBER;
11634: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.get_period_information';
11635: l_period_mask_tbl period_mask_tbl;
11636: l_pa_impl_rec pa_impl_cur%ROWTYPE;
11637: l_period_grouping_tbl period_grouping_tbl;
11638: l_periods_rec periods_rec;

Line 11654: pa_debug.g_err_stage := ':In pa_fp_webadi_pkg.GET_PERIOD_INFORMATION';

11650:
11651: IF l_debug_mode = 'Y' THEN
11652: pa_debug.set_curr_function(p_function => 'GET_PERIOD_INFORMATION',
11653: p_debug_mode => l_debug_mode);
11654: pa_debug.g_err_stage := ':In pa_fp_webadi_pkg.GET_PERIOD_INFORMATION';
11655: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
11656: END IF;
11657: --Validation is done for the input parameters.
11658: IF l_debug_mode = 'Y' THEN

Line 11816: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

11812: WHEN OTHERS THEN
11813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11814: x_msg_count := 1;
11815: x_msg_data := SQLERRM;
11816: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
11817: ,p_procedure_name => 'get_period_information');
11818: IF l_debug_mode = 'Y' THEN
11819: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
11820: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 12037: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';

12033: l_msg_count NUMBER := 0;
12034: l_data VARCHAR2(2000);
12035: l_msg_data VARCHAR2(2000);
12036: l_msg_index_out NUMBER;
12037: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';
12038: l_project_id pa_budget_versions.project_id%TYPE;
12039: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12040: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12041: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;

Line 12087: pa_debug.g_err_stage := ':In pa_fp_webadi_pkg.INSERT_PERIODIC_TMP_TABLE' ;

12083:
12084: IF l_debug_mode = 'Y' THEN
12085: pa_debug.set_curr_function( p_function => 'INSERT_PERIODIC_TMP_TABLE'
12086: ,p_debug_mode => l_debug_mode );
12087: pa_debug.g_err_stage := ':In pa_fp_webadi_pkg.INSERT_PERIODIC_TMP_TABLE' ;
12088: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
12089: END IF;
12090:
12091: l_budget_version_id := p_budget_version_id;

Line 12596: 'pa_fp_webadi_pkg.l_global_tmp_rec.prd'||pa_fp_webadi_pkg.l_position||' := pa_fp_webadi_pkg.l_return; '||

12592: /*
12593: --Dynamic SQL used to insert the Amount Type value in the corresponding period column.
12594: EXECUTE IMMEDIATE
12595: 'BEGIN '||
12596: 'pa_fp_webadi_pkg.l_global_tmp_rec.prd'||pa_fp_webadi_pkg.l_position||' := pa_fp_webadi_pkg.l_return; '||
12597: 'END;';
12598: */
12599: IF l_position = 1 THEN
12600: l_global_tmp_rec.prd1 := l_return;

Line 12780: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'

12776: WHEN OTHERS THEN
12777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12778: x_msg_count := 1;
12779: x_msg_data := SQLERRM;
12780: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
12781: ,p_procedure_name => 'insert_periodic_tmp_table');
12782: IF l_debug_mode = 'Y' THEN
12783: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
12784: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 12793: END pa_fp_webadi_pkg;

12789:
12790: END insert_periodic_tmp_table;
12791:
12792:
12793: END pa_fp_webadi_pkg;