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 FND_MSG_PUB

Line 400: l_msg_count := FND_MSG_PUB.count_msg;

396: END IF;
397: END IF;
398: EXCEPTION
399: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
400: l_msg_count := FND_MSG_PUB.count_msg;
401:
402: IF l_msg_count = 1 and x_msg_data IS NULL THEN
403: PA_INTERFACE_UTILS_PUB.get_messages
404: (p_encoded => FND_API.G_TRUE

Line 425: FND_MSG_PUB.add_exc_msg

421: WHEN OTHERS THEN
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);

Line 955: l_msg_count := FND_MSG_PUB.count_msg;

951:
952: RETURN;
953:
954: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
955: l_msg_count := FND_MSG_PUB.count_msg;
956:
957: IF l_msg_count = 1 and x_msg_data IS NULL THEN
958: PA_INTERFACE_UTILS_PUB.get_messages
959: (p_encoded => FND_API.G_TRUE

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 1221: l_msg_count := FND_MSG_PUB.count_msg;

1217: END IF;
1218:
1219: EXCEPTION
1220: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1221: l_msg_count := FND_MSG_PUB.count_msg;
1222:
1223: IF l_msg_count = 1 and x_msg_data IS NULL THEN
1224: PA_INTERFACE_UTILS_PUB.get_messages
1225: (p_encoded => FND_API.G_TRUE

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 1366: l_msg_count := FND_MSG_PUB.count_msg;

1362: IF g_fp_webadi_rec_tbl.COUNT > 0 THEN
1363: g_fp_webadi_rec_tbl.DELETE;
1364: END IF;
1365:
1366: l_msg_count := FND_MSG_PUB.count_msg;
1367:
1368: IF l_msg_count = 1 and x_msg_data IS NULL THEN
1369: PA_INTERFACE_UTILS_PUB.get_messages
1370: (p_encoded => FND_API.G_TRUE

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 1492: l_msg_count := FND_MSG_PUB.count_msg;

1488: pa_debug.reset_curr_function;
1489: END IF;
1490: RETURN;
1491: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1492: l_msg_count := FND_MSG_PUB.count_msg;
1493:
1494: IF l_msg_count = 1 and x_msg_data IS NULL THEN
1495: PA_INTERFACE_UTILS_PUB.get_messages
1496: (p_encoded => FND_API.G_TRUE

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 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 5844: l_msg_count := FND_MSG_PUB.count_msg;

5840: --log1('----- Leaving prepare_val_input-------');
5841:
5842: EXCEPTION
5843: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5844: l_msg_count := FND_MSG_PUB.count_msg;
5845:
5846: IF l_msg_count = 1 and x_msg_data IS NULL THEN
5847: PA_INTERFACE_UTILS_PUB.get_messages
5848: (p_encoded => FND_API.G_TRUE

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 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 6611: l_msg_count := FND_MSG_PUB.count_msg;

6607:
6608: EXCEPTION
6609:
6610: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6611: l_msg_count := FND_MSG_PUB.count_msg;
6612: IF l_msg_count = 1 THEN
6613: PA_INTERFACE_UTILS_PUB.get_messages
6614: (p_encoded => FND_API.G_TRUE
6615: ,p_msg_index => 1

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 7929: l_msg_count := FND_MSG_PUB.count_msg;

7925: END IF;
7926:
7927: EXCEPTION
7928: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
7929: l_msg_count := FND_MSG_PUB.count_msg;
7930: IF l_msg_count = 1 and x_msg_data IS NULL THEN
7931: PA_INTERFACE_UTILS_PUB.get_messages
7932: (p_encoded => FND_API.G_TRUE
7933: ,p_msg_index => 1

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 10031: l_msg_count := FND_MSG_PUB.count_msg;

10027: pa_debug.reset_curr_function;
10028: END IF;
10029: RETURN;
10030: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10031: l_msg_count := FND_MSG_PUB.count_msg;
10032:
10033: IF l_msg_count = 1 and x_msg_data IS NULL THEN
10034: PA_INTERFACE_UTILS_PUB.get_messages
10035: (p_encoded => FND_API.G_TRUE

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 11221: l_msg_count := FND_MSG_PUB.count_msg;

11217: END IF;
11218:
11219: COMMIT;
11220:
11221: l_msg_count := FND_MSG_PUB.count_msg;
11222:
11223: IF l_msg_count = 1 and x_msg_data IS NULL THEN
11224: PA_INTERFACE_UTILS_PUB.get_messages
11225: (p_encoded => FND_API.G_TRUE

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 11461: l_msg_count := FND_MSG_PUB.count_msg;

11457: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
11458: -- ROLLBACK TO process_MSExcel_data;
11459: -- bug 4477397: doing a general rollback instead to savepoint
11460: ROLLBACK;
11461: l_msg_count := FND_MSG_PUB.count_msg;
11462: IF l_msg_count = 1 THEN
11463: PA_INTERFACE_UTILS_PUB.get_messages
11464: (p_encoded => FND_API.G_TRUE
11465: ,p_msg_index => 1

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 11792: l_msg_count := FND_MSG_PUB.count_msg;

11788: END LOOP;
11789:
11790: EXCEPTION
11791: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
11792: l_msg_count := FND_MSG_PUB.count_msg;
11793: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
11794: PA_INTERFACE_UTILS_PUB.get_messages
11795: (p_encoded => FND_API.G_TRUE
11796: ,p_msg_index => 1

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 12748: l_msg_count := FND_MSG_PUB.count_msg;

12744: l_global_tmp_tbl := null;
12745:
12746: EXCEPTION
12747: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
12748: l_msg_count := FND_MSG_PUB.count_msg;
12749: IF l_msg_count = 1 and x_msg_data IS NULL THEN
12750: PA_INTERFACE_UTILS_PUB.get_messages
12751: (p_encoded => FND_API.G_TRUE
12752: ,p_msg_index => 1

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);