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.55.12020000.5 2013/06/21 06:34:32 bpottipa 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 336: pa_debug.g_err_stage := ':In pa_fp_webadi_pkg.DELETE_XFACE' ;

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

Line 427: ( p_pkg_name => 'pa_fp_webadi_pkg'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1323: pa_fp_webadi_pkg.process_errors

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

2006: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
2007: p_debug_mode => l_debug_mode );
2008:
2009: IF l_debug_mode = 'Y' THEN
2010: pa_debug.g_err_stage := 'Entering into pa_fp_webadi_pkg.prepare_val_input';
2011: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2012: END IF;
2013:
2014: --log1('----- Entering into prepare_val_input-------');

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

5923: x_cbs_elem_id_tbl := l_cbs_elem_id_tbl;
5924: x_amt_type_tbl := l_amount_type_tbl;
5925:
5926: IF l_debug_mode = 'Y' THEN
5927: pa_debug.g_err_stage := 'Leaving pa_fp_webadi_pkg.prepare_val_input';
5928: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
5929: END IF;
5930:
5931: pa_debug.reset_curr_function;

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

5959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5960: x_msg_count := 1;
5961: x_msg_data := SQLERRM;
5962:
5963: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
5964: ,p_procedure_name => 'prepare_val_input');
5965: IF l_debug_mode = 'Y' THEN
5966: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
5967: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

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

5983: )
5984: RETURN NUMBER
5985: IS
5986: -- variables used for debugging
5987: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.get_amount_in_prd_x';
5988: l_debug_mode VARCHAR2(1) := 'N';
5989: l_amount NUMBER;
5990: BEGIN
5991: fnd_profile.get('PA_DEBUG_MODE', l_debug_mode);

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

6142:
6143: EXCEPTION
6144: WHEN OTHERS THEN
6145:
6146: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
6147: ,p_procedure_name => 'get_amount_in_prd_x');
6148: IF l_debug_mode = 'Y' THEN
6149: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
6150: pa_debug.write(l_module_name,pa_debug.g_err_stage,5);

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

6745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6746: x_msg_count := 1;
6747: x_msg_data := SQLERRM;
6748:
6749: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
6750: ,p_procedure_name => 'get_total_fcst_amounts');
6751:
6752: IF l_debug_mode = 'Y' THEN
6753: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

6853: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6854: )
6855: IS
6856: -- variables used for debugging
6857: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.prepare_pbl_input';
6858: l_debug_mode VARCHAR2(1) := 'N';
6859: l_debug_level3 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3;
6860: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
6861:

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

8064: END IF; --p_context
8065:
8066:
8067: IF l_debug_mode = 'Y' THEN
8068: pa_debug.g_err_stage := 'Leaving pa_fp_webadi_pkg.prepare_pbl_input';
8069: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8070: END IF;
8071:
8072: IF l_debug_mode = 'Y' THEN

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

8100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8101: x_msg_count := 1;
8102: x_msg_data := SQLERRM;
8103:
8104: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
8105: ,p_procedure_name => 'prepare_pbl_input');
8106: IF l_debug_mode = 'Y' THEN
8107: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
8108: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

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

8167: )
8168:
8169: IS
8170: -- variables used for debugging
8171: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.process_budget_lines';
8172: l_debug_mode VARCHAR2(1) := 'N';
8173: l_debug_level3 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3;
8174: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
8175:

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

10231: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10232: x_msg_count := 1;
10233: x_msg_data := SQLERRM;
10234:
10235: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
10236: ,p_procedure_name => 'process_budget_lines');
10237: IF l_debug_mode = 'Y' THEN
10238: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
10239: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

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

10293: p_calling_mode IN VARCHAR2)
10294:
10295: IS
10296: -- variables used for debugging
10297: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.switcher';
10298: l_debug_mode VARCHAR2(1) := 'N';
10299: l_debug_level3 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3;
10300: l_debug_level5 CONSTANT NUMBER := PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5;
10301:

Line 11386: pa_fp_webadi_pkg.DELETE_XFACE

11382: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
11383: END IF;
11384: --log1('12 '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
11385:
11386: pa_fp_webadi_pkg.DELETE_XFACE
11387: ( p_run_id => p_run_id
11388: ,x_return_status => x_return_status
11389: ,x_msg_count => x_msg_count
11390: ,x_msg_data => l_msg_data --x_msg_data Bug 2764950

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

11393: COMMIT; /* to commit the data in DB after successful processing */
11394: --log1('14 '||to_char(sysdate,'DD-MON-YYYY HH24:MI:SS'));
11395: --log1('----- STAGE 14-------');
11396: IF l_debug_mode = 'Y' THEN
11397: pa_debug.g_err_stage := 'Leaving pa_fp_webadi_pkg.switcher';
11398: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
11399: pa_debug.reset_curr_function;
11400: END IF;
11401:

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

11506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11507: x_msg_count := 1;
11508: x_msg_data := SQLERRM;
11509:
11510: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
11511: ,p_procedure_name => 'switcher');
11512: IF l_debug_mode = 'Y' THEN
11513: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
11514: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);

Line 11653: pa_fp_webadi_pkg.switcher

11649: ELSE
11650: l_submit_fcst_flag:=p_submit_ver_flag;
11651: END IF;
11652: --log1('----- STAGE CR7-------');
11653: pa_fp_webadi_pkg.switcher
11654: (p_calling_mode => 'ONLINE',
11655: p_run_id => p_run_id,
11656: p_submit_budget_flag => l_submit_bdgt_flag,
11657: p_submit_forecast_flag => l_submit_fcst_flag,

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

11663: --log1('----- STAGE CR8-------');
11664: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
11665: --log1('----- STAGE CR9-------');
11666: IF l_debug_mode = 'Y' THEN
11667: pa_debug.g_err_stage:='pa_fp_webadi_pkg.switcher returned error';
11668: pa_debug.write( l_module_name,pa_debug.g_err_stage,5);
11669: END IF;
11670: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
11671: END IF;

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

11767: -- bug 4477397: doing a general rollback instead to savepoint
11768: ROLLBACK;
11769: errbuf := SQLERRM;
11770:
11771: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
11772: ,p_procedure_name => 'process_MSExcel_data');
11773:
11774: IF l_debug_mode = 'Y' THEN
11775: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

11861: l_data VARCHAR2(2000);
11862: l_msg_count NUMBER := 0;
11863: l_msg_data VARCHAR2(2000);
11864: l_msg_index_out NUMBER;
11865: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.get_period_information';
11866: l_period_mask_tbl period_mask_tbl;
11867: l_pa_impl_rec pa_impl_cur%ROWTYPE;
11868: l_period_grouping_tbl period_grouping_tbl;
11869: l_periods_rec periods_rec;

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

11881:
11882: IF l_debug_mode = 'Y' THEN
11883: pa_debug.set_curr_function(p_function => 'GET_PERIOD_INFORMATION',
11884: p_debug_mode => l_debug_mode);
11885: pa_debug.g_err_stage := ':In pa_fp_webadi_pkg.GET_PERIOD_INFORMATION';
11886: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
11887: END IF;
11888: --Validation is done for the input parameters.
11889: IF l_debug_mode = 'Y' THEN

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

12043: WHEN OTHERS THEN
12044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12045: x_msg_count := 1;
12046: x_msg_data := SQLERRM;
12047: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
12048: ,p_procedure_name => 'get_period_information');
12049: IF l_debug_mode = 'Y' THEN
12050: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
12051: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

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

12266: l_msg_count NUMBER := 0;
12267: l_data VARCHAR2(2000);
12268: l_msg_data VARCHAR2(2000);
12269: l_msg_index_out NUMBER;
12270: l_module_name VARCHAR2(100) := 'pa_fp_webadi_pkg.insert_periodic_tmp_table';
12271: l_project_id pa_budget_versions.project_id%TYPE;
12272: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
12273: l_version_info_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
12274: l_project_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;

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

12318:
12319: IF l_debug_mode = 'Y' THEN
12320: pa_debug.set_curr_function( p_function => 'INSERT_PERIODIC_TMP_TABLE'
12321: ,p_debug_mode => l_debug_mode );
12322: pa_debug.g_err_stage := ':In pa_fp_webadi_pkg.INSERT_PERIODIC_TMP_TABLE' ;
12323: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
12324: END IF;
12325:
12326: l_budget_version_id := p_budget_version_id;

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

12837: /*
12838: --Dynamic SQL used to insert the Amount Type value in the corresponding period column.
12839: EXECUTE IMMEDIATE
12840: 'BEGIN '||
12841: 'pa_fp_webadi_pkg.l_global_tmp_rec.prd'||pa_fp_webadi_pkg.l_position||' := pa_fp_webadi_pkg.l_return; '||
12842: 'END;';
12843: */
12844: IF l_position = 1 THEN
12845: l_global_tmp_rec.prd1 := l_return;

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

13024: WHEN OTHERS THEN
13025: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13026: x_msg_count := 1;
13027: x_msg_data := SQLERRM;
13028: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_webadi_pkg'
13029: ,p_procedure_name => 'insert_periodic_tmp_table');
13030: IF l_debug_mode = 'Y' THEN
13031: pa_debug.g_err_stage:='Unexpected Error ' || SQLERRM;
13032: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 13041: END pa_fp_webadi_pkg;

13037:
13038: END insert_periodic_tmp_table;
13039:
13040:
13041: END pa_fp_webadi_pkg;