DBA Data[Home] [Help]

APPS.PA_FP_WEBADI_PKG dependencies on FND_MSG_PUB

Line 401: l_msg_count := FND_MSG_PUB.count_msg;

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

Line 426: FND_MSG_PUB.add_exc_msg

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

Line 956: l_msg_count := FND_MSG_PUB.count_msg;

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

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

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

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

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

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

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

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

5933: --log1('----- Leaving prepare_val_input-------');
5934:
5935: EXCEPTION
5936: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5937: l_msg_count := FND_MSG_PUB.count_msg;
5938:
5939: IF l_msg_count = 1 and x_msg_data IS NULL THEN
5940: PA_INTERFACE_UTILS_PUB.get_messages
5941: (p_encoded => FND_API.G_TRUE

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

6714:
6715: EXCEPTION
6716:
6717: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
6718: l_msg_count := FND_MSG_PUB.count_msg;
6719: IF l_msg_count = 1 THEN
6720: PA_INTERFACE_UTILS_PUB.get_messages
6721: (p_encoded => FND_API.G_TRUE
6722: ,p_msg_index => 1

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

8074: END IF;
8075:
8076: EXCEPTION
8077: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8078: l_msg_count := FND_MSG_PUB.count_msg;
8079: IF l_msg_count = 1 and x_msg_data IS NULL THEN
8080: PA_INTERFACE_UTILS_PUB.get_messages
8081: (p_encoded => FND_API.G_TRUE
8082: ,p_msg_index => 1

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

10205: pa_debug.reset_curr_function;
10206: END IF;
10207: RETURN;
10208: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10209: l_msg_count := FND_MSG_PUB.count_msg;
10210:
10211: IF l_msg_count = 1 and x_msg_data IS NULL THEN
10212: PA_INTERFACE_UTILS_PUB.get_messages
10213: (p_encoded => FND_API.G_TRUE

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

11447: END IF;
11448:
11449: COMMIT;
11450:
11451: l_msg_count := FND_MSG_PUB.count_msg;
11452:
11453: IF l_msg_count = 1 and x_msg_data IS NULL THEN
11454: PA_INTERFACE_UTILS_PUB.get_messages
11455: (p_encoded => FND_API.G_TRUE

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

11687: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
11688: -- ROLLBACK TO process_MSExcel_data;
11689: -- bug 4477397: doing a general rollback instead to savepoint
11690: ROLLBACK;
11691: l_msg_count := FND_MSG_PUB.count_msg;
11692: IF l_msg_count = 1 THEN
11693: PA_INTERFACE_UTILS_PUB.get_messages
11694: (p_encoded => FND_API.G_TRUE
11695: ,p_msg_index => 1

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

12019: END LOOP;
12020:
12021: EXCEPTION
12022: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
12023: l_msg_count := FND_MSG_PUB.count_msg;
12024: IF l_msg_count = 1 AND x_msg_data IS NULL THEN
12025: PA_INTERFACE_UTILS_PUB.get_messages
12026: (p_encoded => FND_API.G_TRUE
12027: ,p_msg_index => 1

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

12989: l_global_tmp_tbl := null;
12990:
12991: EXCEPTION
12992: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
12993: l_msg_count := FND_MSG_PUB.count_msg;
12994: IF l_msg_count = 1 and x_msg_data IS NULL THEN
12995: PA_INTERFACE_UTILS_PUB.get_messages
12996: (p_encoded => FND_API.G_TRUE
12997: ,p_msg_index => 1

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