DBA Data[Home] [Help]

APPS.PA_FP_ROLLUP_PKG dependencies on FND_MSG_PUB

Line 155: l_msg_count := FND_MSG_PUB.count_msg;

151: pa_debug.reset_err_stack;
152:
153: EXCEPTION
154: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
155: l_msg_count := FND_MSG_PUB.count_msg;
156: IF l_msg_count = 1 THEN
157: PA_INTERFACE_UTILS_PUB.get_messages
158: (p_encoded => FND_API.G_TRUE,
159: p_msg_index => 1,

Line 175: FND_MSG_PUB.add_exc_msg

171: WHEN OTHERS THEN
172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
173: x_msg_count := 1;
174: x_msg_data := SQLERRM;
175: FND_MSG_PUB.add_exc_msg
176: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
177: ,p_procedure_name => 'POPULATE_LOCAL_VARS');
178: IF P_PA_DEBUG_MODE = 'Y' THEN
179: pa_debug.write('POPULATE_LOCAL_VARS: ' || l_module_name,SQLERRM,5);

Line 327: FND_MSG_PUB.add_exc_msg

323: END IF;
324:
325: EXCEPTION
326: WHEN OTHERS THEN
327: FND_MSG_PUB.add_exc_msg
328: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
329: ,p_procedure_name => 'Insert_Parent_Rec_Tmp');
330: IF P_PA_DEBUG_MODE = 'Y' THEN
331: pa_debug.write('INSERT_PARENT_REC_TMP: ' || l_module_name,SQLERRM,5);

Line 466: FND_MSG_PUB.initialize;

462:
463: BEGIN
464:
465: -- Initialize and Set the error stack.
466: FND_MSG_PUB.initialize;
467: IF P_PA_DEBUG_MODE = 'Y' THEN
468: pa_debug.set_err_stack('PA_FP_ROLLUP_PKG.Rollup_Budget_Version');
469: END IF;
470:

Line 739: l_msg_count := FND_MSG_PUB.count_msg;

735: pa_debug.reset_err_stack;
736:
737: EXCEPTION
738: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
739: l_msg_count := FND_MSG_PUB.count_msg;
740: IF l_msg_count = 1 THEN
741: PA_INTERFACE_UTILS_PUB.get_messages
742: (p_encoded => FND_API.G_TRUE,
743: p_msg_index => 1,

Line 759: FND_MSG_PUB.add_exc_msg

755: WHEN OTHERS THEN
756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
757: x_msg_count := 1;
758: x_msg_data := SQLERRM;
759: FND_MSG_PUB.add_exc_msg
760: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
761: ,p_procedure_name => 'Rollup_Budget_Version');
762: IF P_PA_DEBUG_MODE = 'Y' THEN
763: pa_debug.write('ROLLUP_BUDGET_VERSION: ' || l_module_name,SQLERRM,5);

Line 1555: l_msg_count := FND_MSG_PUB.count_msg;

1551: pa_debug.reset_err_stack;
1552:
1553: EXCEPTION
1554: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
1555: l_msg_count := FND_MSG_PUB.count_msg;
1556: IF l_msg_count = 1 THEN
1557: PA_INTERFACE_UTILS_PUB.get_messages
1558: (p_encoded => FND_API.G_TRUE,
1559: p_msg_index => 1,

Line 1575: FND_MSG_PUB.add_exc_msg

1571: WHEN OTHERS THEN
1572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1573: x_msg_count := 1;
1574: x_msg_data := SQLERRM;
1575: FND_MSG_PUB.add_exc_msg
1576: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
1577: ,p_procedure_name => 'REFRESH_RESOURCE_ASSIGNMENTS');
1578: IF P_PA_DEBUG_MODE = 'Y' THEN
1579: pa_debug.write('REFRESH_RESOURCE_ASSIGNMENTS: ' || l_module_name,SQLERRM,5);

Line 1827: l_msg_count := FND_MSG_PUB.count_msg;

1823: pa_debug.reset_err_stack;
1824:
1825: EXCEPTION
1826: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
1827: l_msg_count := FND_MSG_PUB.count_msg;
1828: IF l_msg_count = 1 THEN
1829: PA_INTERFACE_UTILS_PUB.get_messages
1830: (p_encoded => FND_API.G_TRUE,
1831: p_msg_index => 1,

Line 1847: FND_MSG_PUB.add_exc_msg

1843: WHEN OTHERS THEN
1844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845: x_msg_count := 1;
1846: x_msg_data := SQLERRM;
1847: FND_MSG_PUB.add_exc_msg
1848: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
1849: ,p_procedure_name => 'UPDATE_RES_PARENT_ASSIGN_ID');
1850: IF P_PA_DEBUG_MODE = 'Y' THEN
1851: pa_debug.write('UPDATE_RES_PARENT_ASSIGN_ID: ' || l_module_name,SQLERRM,5);

Line 1983: l_msg_count := FND_MSG_PUB.count_msg;

1979: pa_debug.reset_err_stack;
1980:
1981: EXCEPTION
1982: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
1983: l_msg_count := FND_MSG_PUB.count_msg;
1984: IF l_msg_count = 1 THEN
1985: PA_INTERFACE_UTILS_PUB.get_messages
1986: (p_encoded => FND_API.G_TRUE,
1987: p_msg_index => 1,

Line 2003: FND_MSG_PUB.add_exc_msg

1999: WHEN OTHERS THEN
2000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2001: x_msg_count := 1;
2002: x_msg_data := SQLERRM;
2003: FND_MSG_PUB.add_exc_msg
2004: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
2005: ,p_procedure_name => 'Insert_Bulk_Rows_Res') ;
2006: IF P_PA_DEBUG_MODE = 'Y' THEN
2007: pa_debug.write('Insert_Bulk_Rows_Res: ' || l_module_name,SQLERRM,5);

Line 2430: l_msg_count := FND_MSG_PUB.count_msg;

2426: pa_debug.reset_err_stack;
2427:
2428: EXCEPTION
2429: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
2430: l_msg_count := FND_MSG_PUB.count_msg;
2431: IF l_msg_count = 1 THEN
2432: PA_INTERFACE_UTILS_PUB.get_messages
2433: (p_encoded => FND_API.G_TRUE,
2434: p_msg_index => 1,

Line 2450: FND_MSG_PUB.add_exc_msg

2446: WHEN OTHERS THEN
2447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2448: x_msg_count := 1;
2449: x_msg_data := SQLERRM;
2450: FND_MSG_PUB.add_exc_msg
2451: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
2452: ,p_procedure_name => 'Refresh_Period_Denorm');
2453: IF P_PA_DEBUG_MODE = 'Y' THEN
2454: pa_debug.write('REFRESH_PERIOD_DENORM: ' || l_module_name,SQLERRM,5);

Line 2520: FND_MSG_PUB.add_exc_msg

2516: WHEN OTHERS THEN
2517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2518: x_msg_count := 1;
2519: x_msg_data := SQLERRM;
2520: FND_MSG_PUB.add_exc_msg
2521: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
2522: ,p_procedure_name => 'UPDATE_DENORM_PARENT_ASSIGN_ID');
2523: IF P_PA_DEBUG_MODE = 'Y' THEN
2524: pa_debug.write('UPDATE_DENORM_PARENT_ASSIGN_ID: ' || l_module_name,SQLERRM,5);

Line 3308: l_msg_count := FND_MSG_PUB.count_msg;

3304:
3305:
3306: EXCEPTION
3307: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
3308: l_msg_count := FND_MSG_PUB.count_msg;
3309: IF l_msg_count = 1 THEN
3310: PA_INTERFACE_UTILS_PUB.get_messages
3311: (p_encoded => FND_API.G_TRUE,
3312: p_msg_index => 1,

Line 3328: FND_MSG_PUB.add_exc_msg

3324: WHEN OTHERS THEN
3325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3326: x_msg_count := 1;
3327: x_msg_data := SQLERRM;
3328: FND_MSG_PUB.add_exc_msg
3329: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
3330: ,p_procedure_name => 'Insert_Missing_Res_Parents');
3331: IF P_PA_DEBUG_MODE = 'Y' THEN
3332: pa_debug.write('INSERT_MISSING_RES_PARENTS: ' || l_module_name,SQLERRM,5);

Line 3613: l_msg_count := FND_MSG_PUB.count_msg;

3609: pa_debug.reset_err_stack;
3610:
3611: EXCEPTION
3612: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
3613: l_msg_count := FND_MSG_PUB.count_msg;
3614: IF l_msg_count = 1 THEN
3615: PA_INTERFACE_UTILS_PUB.get_messages
3616: (p_encoded => FND_API.G_TRUE,
3617: p_msg_index => 1,

Line 3633: FND_MSG_PUB.add_exc_msg

3629: WHEN OTHERS THEN
3630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3631: x_msg_count := 1;
3632: x_msg_data := SQLERRM;
3633: FND_MSG_PUB.add_exc_msg
3634: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
3635: ,p_procedure_name => 'Rollup_Res_Assignment_Amounts');
3636: IF P_PA_DEBUG_MODE = 'Y' THEN
3637: pa_debug.write('ROLLUP_RES_ASSIGNMENT_AMOUNTS: ' || l_module_name,SQLERRM,5);

Line 3920: l_msg_count := FND_MSG_PUB.count_msg;

3916: pa_debug.reset_err_stack;
3917:
3918: EXCEPTION
3919: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
3920: l_msg_count := FND_MSG_PUB.count_msg;
3921: IF l_msg_count = 1 THEN
3922: PA_INTERFACE_UTILS_PUB.get_messages
3923: (p_encoded => FND_API.G_TRUE,
3924: p_msg_index => 1,

Line 3940: FND_MSG_PUB.add_exc_msg

3936: WHEN OTHERS THEN
3937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3938: x_msg_count := 1;
3939: x_msg_data := SQLERRM;
3940: FND_MSG_PUB.add_exc_msg
3941: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
3942: ,p_procedure_name => 'Insert_Missing_Parent_Denorm');
3943: IF P_PA_DEBUG_MODE = 'Y' THEN
3944: pa_debug.write('INSERT_MISSING_PARENT_DENORM: ' || l_module_name,'sqlerrm = ' || SQLERRM,5);

Line 4350: l_msg_count := FND_MSG_PUB.count_msg;

4346: pa_debug.reset_err_stack;
4347:
4348: EXCEPTION
4349: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
4350: l_msg_count := FND_MSG_PUB.count_msg;
4351: IF l_msg_count = 1 THEN
4352: PA_INTERFACE_UTILS_PUB.get_messages
4353: (p_encoded => FND_API.G_TRUE,
4354: p_msg_index => 1,

Line 4370: FND_MSG_PUB.add_exc_msg

4366: WHEN OTHERS THEN
4367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4368: x_msg_count := 1;
4369: x_msg_data := SQLERRM;
4370: FND_MSG_PUB.add_exc_msg
4371: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
4372: ,p_procedure_name => 'Rollup_Denorm_Amounts');
4373: IF P_PA_DEBUG_MODE = 'Y' THEN
4374: pa_debug.write('ROLLUP_DENORM_AMOUNTS: ' || l_module_name,SQLERRM,5);

Line 5088: l_msg_count := FND_MSG_PUB.count_msg;

5084: pa_debug.reset_err_stack;
5085:
5086: EXCEPTION
5087: WHEN PA_FP_ROLLUP_PKG.Invalid_Arg_Exc THEN
5088: l_msg_count := FND_MSG_PUB.count_msg;
5089: IF l_msg_count = 1 THEN
5090: PA_INTERFACE_UTILS_PUB.get_messages
5091: (p_encoded => FND_API.G_TRUE,
5092: p_msg_index => 1,

Line 5108: FND_MSG_PUB.add_exc_msg

5104: WHEN OTHERS THEN
5105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5106: x_msg_count := 1;
5107: x_msg_data := SQLERRM;
5108: FND_MSG_PUB.add_exc_msg
5109: ( p_pkg_name => 'PA_FP_ROLLUP_PKG'
5110: ,p_procedure_name => 'Delete_Element');
5111: IF P_PA_DEBUG_MODE = 'Y' THEN
5112: pa_debug.write('DELETE_ELEMENT: ' || l_module_name,SQLERRM,5);