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_PROGRESS_PUB dependencies on FND_MSG_PUB

Line 682: FND_MSG_PUB.initialize;

678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
679: END IF;
680:
681: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
682: FND_MSG_PUB.initialize;
683: END IF;
684:
685: x_return_status := FND_API.G_RET_STS_SUCCESS;
686:

Line 850: x_msg_count := fnd_msg_pub.count_msg;

846: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
847: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
848: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
849: x_return_status := 'E';
850: x_msg_count := fnd_msg_pub.count_msg;
851: RAISE FND_API.G_EXC_ERROR;
852: END;
853:
854: IF g1_debug_mode = 'Y' THEN

Line 1858: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

1854: END IF;
1855:
1856: EXCEPTION
1857: WHEN OTHERS THEN
1858: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
1859: p_procedure_name => 'UPDATE_TASK_PROGRESS',
1860: p_error_text => SUBSTRB('PA_TASK_ASSIGNMENTS_PUB.DERIVE_TASK_ASSIGNMENTS:'||SQLERRM,1,120));
1861: RAISE fnd_api.g_exc_error;
1862: END;

Line 2942: IF Fnd_Msg_Pub.count_msg > 0 THEN

2938: ,x_subprj_eqpmt_etc_rawcost_fc => l_rollup_rec2.subprj_eqpmt_etc_rawcost_fc
2939: ,x_subprj_eqpmt_etc_rawcost_pc => l_rollup_rec2.subprj_eqpmt_etc_rawcost_pc
2940: );
2941: -- FPM Dev CR 6
2942: IF Fnd_Msg_Pub.count_msg > 0 THEN
2943: RAISE FND_API.G_EXC_ERROR;
2944: END IF;
2945:
2946: -----update percent_complete_id in pa_progress_rollup

Line 3057: IF Fnd_Msg_Pub.count_msg > 0 THEN

3053: ,p_attribute15 => null
3054: ,p_structure_type => p_structure_type
3055: );
3056: -- FPM Dev CR 6
3057: IF Fnd_Msg_Pub.count_msg > 0 THEN
3058: RAISE FND_API.G_EXC_ERROR;
3059: END IF;
3060:
3061:

Line 3274: IF Fnd_Msg_Pub.count_msg > 0 THEN

3270: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_PROGRESS', x_Msg => 'Update Action: Updated PA_PROGRESS_ROLLUP ', x_Log_Level=> 3);
3271: END IF;
3272:
3273: -- FPM Dev CR 6
3274: IF Fnd_Msg_Pub.count_msg > 0 THEN
3275: RAISE FND_API.G_EXC_ERROR;
3276: END IF;
3277: ELSE ---2
3278:

Line 3815: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3

3811: THEN
3812: rollback to UPDATE_TASK_PROGRESS;
3813: END IF;
3814: x_return_status := FND_API.G_RET_STS_ERROR;
3815: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3
3816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3817: IF p_commit = FND_API.G_TRUE
3818: THEN
3819: rollback to UPDATE_TASK_PROGRESS;

Line 3822: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

3818: THEN
3819: rollback to UPDATE_TASK_PROGRESS;
3820: END IF;
3821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3822: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
3823: p_procedure_name => 'UPDATE_TASK_PROGRESS',
3824: p_error_text => SUBSTRB(SQLERRM,1,120));
3825: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3
3826: WHEN OTHERS THEN

Line 3825: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3

3821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3822: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
3823: p_procedure_name => 'UPDATE_TASK_PROGRESS',
3824: p_error_text => SUBSTRB(SQLERRM,1,120));
3825: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3
3826: WHEN OTHERS THEN
3827: IF p_commit = FND_API.G_TRUE THEN
3828: rollback to UPDATE_TASK_PROGRESS;
3829: END IF;

Line 3831: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

3827: IF p_commit = FND_API.G_TRUE THEN
3828: rollback to UPDATE_TASK_PROGRESS;
3829: END IF;
3830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3831: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
3832: p_procedure_name => 'UPDATE_TASK_PROGRESS',
3833: p_error_text => SUBSTRB(SQLERRM,1,120));
3834: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3
3835: raise;

Line 3834: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3

3830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3831: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
3832: p_procedure_name => 'UPDATE_TASK_PROGRESS',
3833: p_error_text => SUBSTRB(SQLERRM,1,120));
3834: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3
3835: raise;
3836: END UPDATE_TASK_PROGRESS;
3837:
3838:

Line 3972: FND_MSG_PUB.initialize;

3968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3969: END IF;
3970:
3971: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
3972: FND_MSG_PUB.initialize;
3973: END IF;
3974:
3975: -- Bug # 3879910. Call corresponding API in package: PA_PROGRESS_PVT.
3976:

Line 4037: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

4033: IF p_commit = FND_API.G_TRUE THEN
4034: rollback to ROLLUP_PROGRESS_PVT;
4035: END IF;
4036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4037: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4038: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
4039: p_error_text => SUBSTRB(SQLERRM,1,120));
4040: WHEN OTHERS THEN
4041: IF p_commit = FND_API.G_TRUE THEN

Line 4045: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

4041: IF p_commit = FND_API.G_TRUE THEN
4042: rollback to ROLLUP_PROGRESS_PVT;
4043: END IF;
4044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4045: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4046: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
4047: p_error_text => SUBSTRB(SQLERRM,1,120));
4048: raise;
4049: END ROLLUP_PROGRESS_PVT;

Line 4155: FND_MSG_PUB.initialize;

4151: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4152: END IF;
4153:
4154: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4155: FND_MSG_PUB.initialize;
4156: END IF;
4157:
4158: -- Bug # 3879910. Call corresponding API in package: PA_PROGRESS_PVT.
4159:

Line 4228: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

4224: IF p_commit = FND_API.G_TRUE THEN
4225: rollback to UPDATE_ROLLUP_PROGRESS_PVT;
4226: END IF;
4227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4228: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4229: p_procedure_name => 'UPDATE_ROLLUP_PROGRESS_PVT',
4230: p_error_text => SUBSTRB(SQLERRM,1,120));
4231: WHEN OTHERS THEN
4232: IF g1_debug_mode = 'Y' THEN

Line 4240: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

4236: IF p_commit = FND_API.G_TRUE THEN
4237: rollback to UPDATE_ROLLUP_PROGRESS_PVT;
4238: END IF;
4239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4240: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4241: p_procedure_name => 'UPDATE_ROLLUP_PROGRESS_PVT',
4242: p_error_text => SUBSTRB(SQLERRM,1,120));
4243: raise;
4244: END UPDATE_ROLLUP_PROGRESS_PVT;

Line 4316: FND_MSG_PUB.initialize;

4312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4313: END IF;
4314:
4315: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4316: FND_MSG_PUB.initialize;
4317: END IF;
4318:
4319: IF P_PROGRESS_CYCLE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4320: THEN

Line 4407: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

4403: if p_commit = FND_API.G_TRUE then
4404: rollback to CREATE_PROJ_PROG_ATTR;
4405: end if;
4406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4407: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4408: p_procedure_name => 'CREATE_PROJ_PROG_ATTR',
4409: p_error_text => SUBSTRB(SQLERRM,1,120));
4410: when OTHERS then
4411: if p_commit = FND_API.G_TRUE then

Line 4415: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

4411: if p_commit = FND_API.G_TRUE then
4412: rollback to CREATE_PROJ_PROG_ATTR;
4413: end if;
4414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4415: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4416: p_procedure_name => 'CREATE_PROJ_PROG_ATTR',
4417: p_error_text => SUBSTRB(SQLERRM,1,120));
4418: raise;
4419: END CREATE_PROJ_PROG_ATTR;

Line 4548: FND_MSG_PUB.initialize;

4544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4545: END IF;
4546:
4547: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4548: FND_MSG_PUB.initialize;
4549: END IF;
4550:
4551: /* IF P_PROGRESS_CYCLE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4552: THEN

Line 4837: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

4833: if p_commit = FND_API.G_TRUE then
4834: rollback to UPDATE_PROJ_PROG_ATTR;
4835: end if;
4836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4837: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4838: p_procedure_name => 'UPDATE_PROJ_PROG_ATTR',
4839: p_error_text => SUBSTRB(SQLERRM,1,120));
4840: when OTHERS then
4841: if p_commit = FND_API.G_TRUE then

Line 4845: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

4841: if p_commit = FND_API.G_TRUE then
4842: rollback to UPDATE_PROJ_PROG_ATTR;
4843: end if;
4844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4845: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4846: p_procedure_name => 'UPDATE_PROJ_PROG_ATTR',
4847: p_error_text => SUBSTRB(SQLERRM,1,120));
4848: raise;
4849: END UPDATE_PROJ_PROG_ATTR;

Line 4911: FND_MSG_PUB.initialize;

4907: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4908: END IF;
4909:
4910: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4911: FND_MSG_PUB.initialize;
4912: END IF;
4913:
4914: OPEN cur_ppp;
4915: FETCH cur_ppp INTO l_ppp_row_id;

Line 4944: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

4940: if p_commit = FND_API.G_TRUE then
4941: rollback to DELETE_PROJ_PROG_ATTR;
4942: end if;
4943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4944: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4945: p_procedure_name => 'DELETE_PROJ_PROG_ATTR',
4946: p_error_text => SUBSTRB(SQLERRM,1,120));
4947: when OTHERS then
4948: if p_commit = FND_API.G_TRUE then

Line 4952: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

4948: if p_commit = FND_API.G_TRUE then
4949: rollback to DELETE_PROJ_PROG_ATTR;
4950: end if;
4951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4952: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4953: p_procedure_name => 'DELETE_PROJ_PROG_ATTR',
4954: p_error_text => SUBSTRB(SQLERRM,1,120));
4955: raise;
4956: END DELETE_PROJ_PROG_ATTR;

Line 5052: FND_MSG_PUB.initialize;

5048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5049: END IF;
5050:
5051: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5052: FND_MSG_PUB.initialize;
5053: END IF;
5054:
5055: IF p_task_version_id is NULL OR p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5056: THEN

Line 5099: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

5095: if p_commit = FND_API.G_TRUE then
5096: rollback to delete_progress_record;
5097: end if;
5098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5099: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
5100: p_procedure_name => 'delete_progress_record',
5101: p_error_text => SUBSTRB(SQLERRM,1,120));
5102: when OTHERS then
5103: if p_commit = FND_API.G_TRUE then

Line 5107: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

5103: if p_commit = FND_API.G_TRUE then
5104: rollback to delete_progress_record;
5105: end if;
5106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5107: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
5108: p_procedure_name => 'delete_progress_record',
5109: p_error_text => SUBSTRB(SQLERRM,1,120));
5110: raise;
5111: END delete_progress_record;

Line 5352: FND_MSG_PUB.initialize;

5348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5349: END IF;
5350:
5351: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5352: FND_MSG_PUB.initialize;
5353: END IF;
5354:
5355: -- Bug 3878024 : Begin
5356: BEGIN

Line 5362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

5358: FROM pa_proj_element_versions
5359: WHERE element_version_id = p_object_version_id;
5360: EXCEPTION
5361: WHEN OTHERS THEN
5362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
5363: p_procedure_name => 'PUSH_DOWN_TASK_STATUS',
5364: p_error_text => 'Unexpected Error : Structure Version Id can not be found. Please contact System Administrator.');
5365:
5366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 5713: IF Fnd_Msg_Pub.count_msg > 0 THEN

5709: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
5710: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
5711: );
5712:
5713: IF Fnd_Msg_Pub.count_msg > 0 THEN
5714: RAISE FND_API.G_EXC_ERROR;
5715: END IF;
5716: END IF; -- cur_task_assignments_rec.current_flag = 'Y' THEN
5717:

Line 6034: IF Fnd_Msg_Pub.count_msg > 0 THEN

6030: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
6031: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
6032: );
6033:
6034: IF Fnd_Msg_Pub.count_msg > 0 THEN
6035: RAISE FND_API.G_EXC_ERROR;
6036: END IF;
6037:
6038: -- Bug 3922325 : Hidden Assignment record also shd get created

Line 6168: IF Fnd_Msg_Pub.count_msg > 0 THEN

6164: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
6165: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
6166: );
6167:
6168: IF Fnd_Msg_Pub.count_msg > 0 THEN
6169: RAISE FND_API.G_EXC_ERROR;
6170: END IF;
6171:
6172: END IF; -- cur_task_assignments_rec.current_flag = 'Y' THEN

Line 6468: IF Fnd_Msg_Pub.count_msg > 0 THEN

6464: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
6465: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
6466: );
6467:
6468: IF Fnd_Msg_Pub.count_msg > 0 THEN
6469: RAISE FND_API.G_EXC_ERROR;
6470: END IF;
6471:
6472: IF g1_debug_mode = 'Y' THEN

Line 6485: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

6481: PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE (x_msg_code => l_msg_code,
6482: x_return_status => x_return_status);
6483: EXCEPTION
6484: WHEN OTHERS THEN
6485: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
6486: p_procedure_name => 'PUSH_DOWN_TASK_STATUS',
6487: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
6488: RAISE FND_API.G_EXC_ERROR;
6489: END;

Line 6511: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

6507: x_msg_code => l_msg_code
6508: );
6509: EXCEPTION
6510: WHEN OTHERS THEN
6511: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
6512: p_procedure_name => 'PUSH_DOWN_TASK_STATUS',
6513: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data:'||SQLERRM,1,120));
6514: RAISE FND_API.G_EXC_ERROR;
6515: END;

Line 6683: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

6679: if p_commit = FND_API.G_TRUE then
6680: rollback to push_down_task_status;
6681: end if;
6682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6683: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
6684: p_procedure_name => 'push_down_task_status',
6685: p_error_text => SUBSTRB(SQLERRM,1,120));
6686: when OTHERS then
6687: if p_commit = FND_API.G_TRUE then

Line 6691: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

6687: if p_commit = FND_API.G_TRUE then
6688: rollback to push_down_task_status;
6689: end if;
6690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6691: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
6692: p_procedure_name => 'push_down_task_status',
6693: p_error_text => SUBSTRB(SQLERRM,1,120));
6694: raise;
6695: END push_down_task_status;

Line 6781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

6777: END IF;
6778: EXCEPTION
6779: WHEN OTHERS THEN
6780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
6782: p_procedure_name => 'ROLLUP_FUTURE_PROGRESS_PVT',
6783: p_error_text => SUBSTRB(SQLERRM,1,120));
6784: raise;
6785: END ROLLUP_FUTURE_PROGRESS_PVT;

Line 7158: FND_MSG_PUB.initialize;

7154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7155: END IF;
7156:
7157: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
7158: FND_MSG_PUB.initialize;
7159: END IF;
7160:
7161: x_return_status := FND_API.G_RET_STS_SUCCESS;
7162:

Line 7560: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

7556:
7557: --maansari6/26
7558: EXCEPTION
7559: WHEN OTHERS THEN
7560: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
7561: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
7562: p_error_text => SUBSTRB('PA_TASK_ASSIGNMENTS_PUB.DERIVE_TASK_ASSIGNMENTS:'||SQLERRM,1,120));
7563: raise fnd_api.g_exc_error;
7564: END;

Line 8079: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8075: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV', x_Msg => 'After pa_progress_pvt.copy_actuals_for_workplan l_return_status='||l_return_status, x_Log_Level=> 3);
8076: END IF;
8077: EXCEPTION
8078: WHEN OTHERS THEN
8079: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8080: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8081: p_error_text => SUBSTRB('PA_PROGRESS_PVT.COPY_ACTUALS_FOR_WORKPLAN:'||SQLERRM,1,120));
8082: RAISE FND_API.G_EXC_ERROR;
8083: END;

Line 8197: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8193: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.APPLY_LP_PROG_ON_CWV', x_Msg => 'After PA_FP_CALC_PLAN_PKG.calculate l_return_status='||l_return_status, x_Log_Level=> 3);
8194: END IF;
8195: EXCEPTION
8196: WHEN OTHERS THEN
8197: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8198: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8199: p_error_text => SUBSTRB('Call of PA_FP_CALC_PLAN_PKG.calculate Failed:'||SQLERRM,1,120));
8200: RAISE FND_API.G_EXC_ERROR;
8201: END;

Line 8230: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8226:
8227:
8228: EXCEPTION
8229: WHEN OTHERS THEN
8230: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8231: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8232: p_error_text => SUBSTRB('PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
8233: RAISE FND_API.G_EXC_ERROR;
8234: END;

Line 8317: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8313: END;
8314: END IF;
8315: EXCEPTION
8316: WHEN OTHERS THEN
8317: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8318: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8319: p_error_text => SUBSTRB('PA_PROGRESS_PUB.POPULATE_PJI_TAB_FOR_PLAN:'||SQLERRM,1,120));
8320: RAISE FND_API.G_EXC_ERROR;
8321: END;

Line 8379: x_msg_count := fnd_msg_pub.count_msg;

8375: if p_commit = FND_API.G_TRUE then
8376: rollback to APPLY_LP_PROG_ON_CWV;
8377: end if;
8378: x_return_status := FND_API.G_RET_STS_ERROR;
8379: x_msg_count := fnd_msg_pub.count_msg;
8380:
8381: -- BEGIN: Commenting this code out to fix Bug # 3956275.
8382: /*
8383:

Line 8386: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8382: /*
8383:
8384: -- BEGIN: Adding code to fix Bug # 3815741.
8385:
8386: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8387: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8388: p_error_text => SUBSTRB(SQLERRM,1,120));
8389:
8390: -- END: Adding code to fix Bug # 3815741.

Line 8401: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8397: if p_commit = FND_API.G_TRUE then
8398: rollback to APPLY_LP_PROG_ON_CWV;
8399: end if;
8400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8401: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8402: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8403: p_error_text => SUBSTRB(SQLERRM,1,120));
8404: x_msg_count := fnd_msg_pub.count_msg;
8405: when OTHERS then

Line 8404: x_msg_count := fnd_msg_pub.count_msg;

8400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8401: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8402: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8403: p_error_text => SUBSTRB(SQLERRM,1,120));
8404: x_msg_count := fnd_msg_pub.count_msg;
8405: when OTHERS then
8406: if p_commit = FND_API.G_TRUE then
8407: rollback to APPLY_LP_PROG_ON_CWV;
8408: end if;

Line 8410: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8406: if p_commit = FND_API.G_TRUE then
8407: rollback to APPLY_LP_PROG_ON_CWV;
8408: end if;
8409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8410: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8411: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8412: p_error_text => SUBSTRB(SQLERRM,1,120));
8413: x_msg_count := fnd_msg_pub.count_msg;
8414: raise;

Line 8413: x_msg_count := fnd_msg_pub.count_msg;

8409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8410: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8411: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8412: p_error_text => SUBSTRB(SQLERRM,1,120));
8413: x_msg_count := fnd_msg_pub.count_msg;
8414: raise;
8415: END APPLY_LP_PROG_ON_CWV;
8416:
8417: -- Progress Management Changes. Bug # 3420093.

Line 8464: FND_MSG_PUB.initialize;

8460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8461: END IF;
8462:
8463: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
8464: FND_MSG_PUB.initialize;
8465: END IF;
8466:
8467: x_return_status := FND_API.G_RET_STS_SUCCESS;
8468:

Line 8525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8521: if p_commit = FND_API.G_TRUE then
8522: rollback to DELETE_WORKING_WP_PROGRESS;
8523: end if;
8524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8526: p_procedure_name => 'DELETE_WORKING_WP_PROGRESS',
8527: p_error_text => SUBSTRB(SQLERRM,1,120));
8528: when OTHERS then
8529: if p_commit = FND_API.G_TRUE then

Line 8533: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8529: if p_commit = FND_API.G_TRUE then
8530: rollback to DELETE_WORKING_WP_PROGRESS;
8531: end if;
8532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8533: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8534: p_procedure_name => 'DELETE_WORKING_WP_PROGRESS',
8535: p_error_text => SUBSTRB(SQLERRM,1,120));
8536: raise;
8537: END delete_working_wp_progress;

Line 8628: FND_MSG_PUB.initialize;

8624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8625: END IF;
8626:
8627: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
8628: FND_MSG_PUB.initialize;
8629: END IF;
8630:
8631: x_return_status := FND_API.G_RET_STS_SUCCESS;
8632:

Line 8685: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8681: , x_return_status => x_return_status);
8682:
8683: EXCEPTION
8684: WHEN OTHERS THEN
8685: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8686: p_procedure_name => 'PULL_SUMMARIZED_ACTUALS',
8687: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE failed: sqlerrm='||SQLERRM,1,120));
8688: RAISE FND_API.G_EXC_ERROR;
8689: END;

Line 8757: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8753: if p_commit = FND_API.G_TRUE then
8754: rollback to PULL_SUMMARIZED_ACTUALS;
8755: end if;
8756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8757: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8758: p_procedure_name => 'PULL_SUMMARIZED_ACTUALS',
8759: p_error_text => SUBSTRB(SQLERRM,1,120));
8760: when OTHERS then
8761: if p_commit = FND_API.G_TRUE then

Line 8765: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

8761: if p_commit = FND_API.G_TRUE then
8762: rollback to DELETE_WORKING_WP_PROGRESS;
8763: end if;
8764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8765: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8766: p_procedure_name => 'PULL_SUMMARIZED_ACTUALS',
8767: p_error_text => SUBSTRB(SQLERRM,1,120));
8768: raise;
8769: END PULL_SUMMARIZED_ACTUALS;

Line 9021: FND_MSG_PUB.initialize;

9017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9018: END IF;
9019:
9020: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
9021: FND_MSG_PUB.initialize;
9022: END IF;
9023:
9024: x_return_status := FND_API.G_RET_STS_SUCCESS;
9025:

Line 9495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

9491: AND structure_version_id = l_structure_version_id;
9492: -- 3994165 : Deletion is now moved here.
9493: EXCEPTION
9494: WHEN OTHERS THEN
9495: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9496: p_procedure_name => 'update_progress',
9497: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
9498: RAISE FND_API.G_EXC_ERROR;
9499: END;

Line 9525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

9521: x_msg_code => l_msg_code,
9522: x_return_status => x_return_status);
9523: EXCEPTION
9524: WHEN OTHERS THEN
9525: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9526: p_procedure_name => 'update_progress',
9527: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
9528: RAISE FND_API.G_EXC_ERROR;
9529: END;

Line 9575: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

9571: x_msg_code => l_msg_code
9572: );
9573: EXCEPTION
9574: WHEN OTHERS THEN
9575: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9576: p_procedure_name => 'update_progress',
9577: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data:'||SQLERRM,1,120));
9578: RAISE FND_API.G_EXC_ERROR;
9579: END;

Line 9795: x_msg_count := fnd_msg_pub.count_msg;

9791: if p_commit = FND_API.G_TRUE then
9792: rollback to UPDATE_PROGRESS;
9793: end if;
9794: x_return_status := FND_API.G_RET_STS_ERROR;
9795: x_msg_count := fnd_msg_pub.count_msg;
9796: when FND_API.G_EXC_UNEXPECTED_ERROR then
9797: if p_commit = FND_API.G_TRUE then
9798: rollback to UPDATE_PROGRESS;
9799: end if;

Line 9801: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

9797: if p_commit = FND_API.G_TRUE then
9798: rollback to UPDATE_PROGRESS;
9799: end if;
9800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9801: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9802: p_procedure_name => 'UPDATE_PROGRESS',
9803: p_error_text => SUBSTRB(SQLERRM,1,120));
9804: x_msg_count := fnd_msg_pub.count_msg;
9805: when OTHERS then

Line 9804: x_msg_count := fnd_msg_pub.count_msg;

9800: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9801: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9802: p_procedure_name => 'UPDATE_PROGRESS',
9803: p_error_text => SUBSTRB(SQLERRM,1,120));
9804: x_msg_count := fnd_msg_pub.count_msg;
9805: when OTHERS then
9806: if p_commit = FND_API.G_TRUE then
9807: rollback to UPDATE_PROGRESS;
9808: end if;

Line 9810: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

9806: if p_commit = FND_API.G_TRUE then
9807: rollback to UPDATE_PROGRESS;
9808: end if;
9809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9810: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9811: p_procedure_name => 'UPDATE_PROGRESS',
9812: p_error_text => SUBSTRB(SQLERRM,1,120));
9813: x_msg_count := fnd_msg_pub.count_msg;
9814: raise;

Line 9813: x_msg_count := fnd_msg_pub.count_msg;

9809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9810: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9811: p_procedure_name => 'UPDATE_PROGRESS',
9812: p_error_text => SUBSTRB(SQLERRM,1,120));
9813: x_msg_count := fnd_msg_pub.count_msg;
9814: raise;
9815: END update_progress;
9816:
9817: -- Progress Management Changes. Bug # 3420093.

Line 9875: FND_MSG_PUB.initialize;

9871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9872: END IF;
9873:
9874: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
9875: FND_MSG_PUB.initialize;
9876: END IF;
9877:
9878: x_return_status := FND_API.G_RET_STS_SUCCESS;
9879:

Line 9939: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

9935:
9936: END IF;
9937: EXCEPTION
9938: WHEN OTHERS THEN
9939: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9940: p_procedure_name => 'POPULATE_PJI_TAB_FOR_PLAN',
9941: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data Failed. SQLERRM='||SQLERRM,1,120));
9942: RAISE FND_API.G_EXC_ERROR;
9943: END;

Line 9966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

9962: if p_commit = FND_API.G_TRUE then
9963: rollback to plan_qtys;
9964: end if;
9965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9966: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9967: p_procedure_name => 'populate_pji_tab_for_plan',
9968: p_error_text => SUBSTRB(SQLERRM,1,120));
9969: when OTHERS then
9970: if p_commit = FND_API.G_TRUE then

Line 9974: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

9970: if p_commit = FND_API.G_TRUE then
9971: rollback to plan_qtys;
9972: end if;
9973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9974: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9975: p_procedure_name => 'populate_pji_tab_for_plan',
9976: p_error_text => SUBSTRB(SQLERRM,1,120));
9977: raise;
9978: END populate_pji_tab_for_plan;

Line 10128: FND_MSG_PUB.initialize;

10124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10125: END IF;
10126:
10127: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
10128: FND_MSG_PUB.initialize;
10129: END IF;
10130:
10131: x_return_status := FND_API.G_RET_STS_SUCCESS;
10132: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745

Line 10226: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

10222: BEGIN
10223: l_period_type := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase( l_structure_version_id ); -- Bug 3608422 : passing l_ instead of p_
10224: EXCEPTION
10225: WHEN OTHERS THEN
10226: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10227: p_procedure_name => 'push_workplan_actuals',
10228: p_error_text => SUBSTRB('PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase:'||SQLERRM,1,120));
10229: RAISE FND_API.G_EXC_ERROR;
10230: END;

Line 10255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

10251: BEGIN
10252: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => p_project_id);
10253: EXCEPTION
10254: WHEN OTHERS THEN
10255: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10256: p_procedure_name => 'PUSH_WORKPLAN_ACTUALS',
10257: p_error_text => SUBSTRB('Call Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id:'||SQLERRM,1,120));
10258: RAISE FND_API.G_EXC_ERROR;
10259: END;

Line 10268: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

10264: p_plan_type_id => -1,
10265: p_proj_str_ver_id => l_structure_version_id) ;
10266: EXCEPTION
10267: WHEN OTHERS THEN
10268: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10269: p_procedure_name => 'PUSH_WORKPLAN_ACTUALS',
10270: p_error_text => SUBSTRB('Call Pa_Fp_wp_gen_amt_utils.get_wp_version_id:'||SQLERRM,1,120));
10271: RAISE FND_API.G_EXC_ERROR;
10272: END;

Line 10426: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

10422: ,l_etc_POU_raw_COST_this_period
10423: );
10424: EXCEPTION
10425: WHEN OTHERS THEN
10426: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10427: p_procedure_name => 'push_workplan_actuals',
10428: p_error_text => SUBSTRB('INSERT INTO PJI_FM_EXTR_PLAN_LINES:'||SQLERRM,1,120));
10429: RAISE FND_API.G_EXC_ERROR;
10430: END;

Line 10532: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

10528: if p_commit = FND_API.G_TRUE then
10529: rollback to push_actuals;
10530: end if;
10531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10532: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10533: p_procedure_name => 'push_workplan_actuals',
10534: p_error_text => SUBSTRB(SQLERRM,1,120));
10535: when OTHERS then
10536: if p_commit = FND_API.G_TRUE then

Line 10540: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

10536: if p_commit = FND_API.G_TRUE then
10537: rollback to push_actuals;
10538: end if;
10539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10540: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10541: p_procedure_name => 'push_workplan_actuals',
10542: p_error_text => SUBSTRB(SQLERRM,1,120));
10543: raise;
10544: END push_workplan_actuals;

Line 10608: FND_MSG_PUB.initialize;

10604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10605: END IF;
10606:
10607: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
10608: FND_MSG_PUB.initialize;
10609: END IF;
10610:
10611: x_return_status := FND_API.G_RET_STS_SUCCESS;
10612:

Line 10654: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

10650: if p_commit = FND_API.G_TRUE then
10651: rollback to PROGRAM_ROLLUP_PVT;
10652: end if;
10653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10654: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10655: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
10656: p_error_text => SUBSTRB(SQLERRM,1,120));
10657: when OTHERS then
10658: if p_commit = FND_API.G_TRUE then

Line 10662: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

10658: if p_commit = FND_API.G_TRUE then
10659: rollback to PROGRAM_ROLLUP_PVT;
10660: end if;
10661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10662: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10663: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
10664: p_error_text => SUBSTRB(SQLERRM,1,120));
10665: raise;
10666: END program_rollup_pvt;

Line 10804: FND_MSG_PUB.initialize;

10800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10801: END IF;
10802:
10803: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
10804: FND_MSG_PUB.initialize;
10805: END IF;
10806:
10807:
10808: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11093: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

11089: if p_commit = FND_API.G_TRUE then
11090: rollback to TRANSFER_WP_PERCENT_TO_FIN;
11091: end if;
11092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11093: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
11094: p_procedure_name => 'TRANSFER_WP_PERCENT_TO_FIN',
11095: p_error_text => SUBSTRB(SQLERRM,1,120));
11096: when OTHERS then
11097: if p_commit = FND_API.G_TRUE then

Line 11101: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

11097: if p_commit = FND_API.G_TRUE then
11098: rollback to TRANSFER_WP_PERCENT_TO_FIN;
11099: end if;
11100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11101: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
11102: p_procedure_name => 'TRANSFER_WP_PERCENT_TO_FIN',
11103: p_error_text => SUBSTRB(SQLERRM,1,120));
11104: raise;
11105: END transfer_wp_percent_to_fin;

Line 11647: FND_MSG_PUB.initialize;

11643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11644: END IF;
11645:
11646: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
11647: FND_MSG_PUB.initialize;
11648: END IF;
11649:
11650: x_return_status := FND_API.G_RET_STS_SUCCESS;
11651:

Line 12781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

12777: if p_commit = FND_API.G_TRUE then
12778: rollback to PUBLISH_PROGRESS;
12779: end if;
12780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12781: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
12782: p_procedure_name => 'PUBLISH_PROGRESS',
12783: p_error_text => SUBSTRB(SQLERRM,1,120));
12784: when OTHERS then
12785: if p_commit = FND_API.G_TRUE then

Line 12789: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

12785: if p_commit = FND_API.G_TRUE then
12786: rollback to PUBLISH_PROGRESS;
12787: end if;
12788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
12789: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
12790: p_procedure_name => 'PUBLISH_PROGRESS',
12791: p_error_text => SUBSTRB(SQLERRM,1,120));
12792: raise;
12793:

Line 14076: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

14072: END IF;
14073: end if;
14074: exception when others then
14075: pa_debug.log_message('GET_SUMM_ACT: get_summarized_data failed with exception', 1);
14076: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14077: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14078: p_error_text => SUBSTRB('pji_fm_xbs_accum_utils.get_summarized_data:'||SQLERRM,1,120));
14079: raise;
14080: end;

Line 14130: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

14126: x_Log_Level=> 3);
14127: END IF;
14128: exception when others then
14129: pa_debug.log_message('GET_SUMM_ACT: populate_workplan_data failed with exception', 1);
14130: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14131: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14132: p_error_text => SUBSTRB('PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data:'||SQLERRM,1,120));
14133: raise;
14134: end;

Line 14210: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

14206: -- l_project_id := -99999; --- so that the next loop won't get executed
14207:
14208: /* Added If condition for Bug#5659575*/
14209: if p_extraction_type = 'PUBLISH' then
14210: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14211: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14212: p_error_text => SUBSTRB('Call of pa_utils2.get_gl_period_name failed: x_msg_data='||SQLERRM,1,120));
14213: x_return_status := 'E';
14214: RAISE;

Line 14248: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

14244: x_return_status => x_return_status,
14245: x_msg_code => x_msg_code );
14246: exception when others then
14247: pa_debug.log_message('GET_SUMM_ACT: populate_workplan_data failed with exception', 1);
14248: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14249: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14250: p_error_text => SUBSTRB('PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data:'||SQLERRM,1,120));
14251: raise;
14252: end;

Line 14380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

14376: ,x_msg_data => x_msg_data
14377: ,x_return_status => x_return_status);
14378: exception when others then
14379: x_return_status := 'E';
14380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14381: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14382: p_error_text => SUBSTRB('pa_task_assignments_pvt.Derive_Task_Assignments:'||SQLERRM,1,120));
14383: -- Added for Bug # 5526638
14384: l_err_msg := substrb('Derive task assignment to track actuals failed:'||SQLERRM,1,240) ;

Line 17994: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

17990: END IF;
17991: EXCEPTION when others then
17992: x_return_status := 'E';
17993: pa_debug.log_message('GET_SUMM_ACT: Exception in rollup of progress attributes.', 1);
17994: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
17995: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
17996: p_error_text => SUBSTRB('pa_progress_pub.rollup_progress_pvt:'||SQLERRM,1,120));
17997: -- Added for bug 5526638
17998: l_err_msg := substrb('Exception in rollup of progress attributes :'||SQLERRM,1,240);

Line 18035: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

18031: END IF;
18032: EXCEPTION when others then
18033: x_return_status := 'E';
18034: pa_debug.log_message('GET_SUMM_ACT: Exception in program rollup.', 1);
18035: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
18036: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
18037: p_error_text => SUBSTRB('pa_progress_pub.program_rollup_pvt:'||SQLERRM,1,120));
18038: -- Added for bug 5526638
18039: l_err_msg := substrb('Exception in program rollup :'||SQLERRM,1,240);

Line 18310: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

18306:
18307: EXCEPTION when others then
18308: pa_debug.log_message('GET_SUMM_ACT: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP returned exception.', 1);
18309: x_return_status := 'E';
18310: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
18311: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
18312: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
18313: raise;
18314: end;

Line 18390: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

18386: pa_debug.log_message('GET_SUMM_ACT: Error while calling PJI api', 1);
18387: x_return_status :='E' ;
18388: when others then
18389: x_return_status := 'E';
18390: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
18391: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
18392: p_error_text => SUBSTRB('pa_progress_pub.get_summarized_actuals:'||SQLERRM,1,120));
18393: -- 4746476 : Priniting stack
18394: FOR i in 1..fnd_msg_pub.count_msg LOOP

Line 18394: FOR i in 1..fnd_msg_pub.count_msg LOOP

18390: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
18391: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
18392: p_error_text => SUBSTRB('pa_progress_pub.get_summarized_actuals:'||SQLERRM,1,120));
18393: -- 4746476 : Priniting stack
18394: FOR i in 1..fnd_msg_pub.count_msg LOOP
18395: pa_interface_utils_pub.get_messages (
18396: p_encoded => Fnd_Api.G_FALSE
18397: ,p_data => l_data
18398: ,p_msg_index => i

Line 18562: FND_MSG_PUB.initialize;

18558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
18559: END IF;
18560:
18561: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
18562: FND_MSG_PUB.initialize;
18563: END IF;
18564:
18565: IF g1_debug_mode = 'Y' THEN
18566: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_FINANCIAL_TASK_PROGRESS', x_Msg => 'p_task_id: '||p_task_id, x_Log_Level=> 3);

Line 19104: IF Fnd_Msg_Pub.count_msg > 0 THEN

19100: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
19101: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null);
19102:
19103: -- FPM Dev CR 6
19104: IF Fnd_Msg_Pub.count_msg > 0 THEN
19105: RAISE FND_API.G_EXC_ERROR;
19106: END IF;
19107:
19108:

Line 19192: IF Fnd_Msg_Pub.count_msg > 0 THEN

19188: ,p_structure_type => p_structure_type
19189:
19190: );
19191: -- FPM Dev CR 6
19192: IF Fnd_Msg_Pub.count_msg > 0 THEN
19193: RAISE FND_API.G_EXC_ERROR;
19194: END IF;
19195:
19196:

Line 19341: IF Fnd_Msg_Pub.count_msg > 0 THEN

19337: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
19338: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
19339: );
19340: -- FPM Dev CR 6
19341: IF Fnd_Msg_Pub.count_msg > 0 THEN
19342: RAISE FND_API.G_EXC_ERROR;
19343: END IF;
19344:
19345: IF g1_debug_mode = 'Y' THEN

Line 19359: l_msg_count := Fnd_Msg_Pub.count_msg;

19355:
19356: EXCEPTION
19357: when FND_API.G_EXC_ERROR then
19358: x_return_status := FND_API.G_RET_STS_ERROR;
19359: l_msg_count := Fnd_Msg_Pub.count_msg;
19360:
19361: if p_commit = FND_API.G_TRUE then
19362: rollback to UPDATE_FINANCIAL_TASK_PROGRESS;
19363: end if;

Line 19389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

19385: if p_commit = FND_API.G_TRUE then
19386: rollback to UPDATE_FINANCIAL_TASK_PROGRESS;
19387: end if;
19388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19389: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19390: p_procedure_name => 'UPDATE_FINANCIAL_TASK_PROGRESS',
19391: p_error_text => SUBSTRB(SQLERRM,1,120));
19392: when OTHERS then
19393: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 19400: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

19396: if p_commit = FND_API.G_TRUE then
19397: rollback to UPDATE_DELIVERABLE_PROGRESS;
19398: end if;
19399:
19400: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19401: p_procedure_name => 'UPDATE_FINANCIAL_TASK_PROGRESS',
19402: p_error_text => SUBSTRB(SQLERRM,1,120));
19403: raise;
19404:

Line 19503: FND_MSG_PUB.initialize;

19499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
19500: END IF;
19501:
19502: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
19503: FND_MSG_PUB.initialize;
19504: END IF;
19505:
19506: x_return_status := FND_API.G_RET_STS_SUCCESS;
19507:

Line 19563: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

19559: );
19560:
19561: EXCEPTION
19562: WHEN OTHERS THEN
19563: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19564: p_procedure_name => 'RE_ROLLUP_PROGRESS',
19565: p_error_text => SUBSTRB('PA_PROGRESS_PUB.populate_pji_tab_for_plan:'||SQLERRM,1,240));
19566: RAISE FND_API.G_EXC_ERROR;
19567: END;

Line 19618: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

19614: if p_commit = FND_API.G_TRUE then
19615: rollback to RE_ROLLUP_PROGRESS;
19616: end if;
19617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19618: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19619: p_procedure_name => 'RE_ROLLUP_PROGRESS',
19620: p_error_text => SUBSTRB(SQLERRM,1,120));
19621: when OTHERS then
19622: if p_commit = FND_API.G_TRUE then

Line 19626: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

19622: if p_commit = FND_API.G_TRUE then
19623: rollback to RE_ROLLUP_PROGRESS;
19624: end if;
19625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19626: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19627: p_procedure_name => 'RE_ROLLUP_PROGRESS',
19628: p_error_text => SUBSTRB(SQLERRM,1,120));
19629: raise;
19630: END re_rollup_progress;

Line 19705: FND_MSG_PUB.initialize;

19701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
19702: END IF;
19703:
19704: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
19705: FND_MSG_PUB.initialize;
19706: END IF;
19707:
19708: x_return_status := FND_API.G_RET_STS_SUCCESS;
19709:

Line 19758: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

19754: if p_commit = FND_API.G_TRUE then
19755: rollback to populate_bulk_pji_tab_for_plan;
19756: end if;
19757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19758: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19759: p_procedure_name => 'POPULATE_BULK_PJI_TAB_FOR_PLAN',
19760: p_error_text => SUBSTRB(SQLERRM,1,120));
19761: when OTHERS then
19762: if p_commit = FND_API.G_TRUE then

Line 19766: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

19762: if p_commit = FND_API.G_TRUE then
19763: rollback to populate_bulk_pji_tab_for_plan;
19764: end if;
19765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19766: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19767: p_procedure_name => 'POPULATE_BULK_PJI_TAB_FOR_PLAN',
19768: p_error_text => SUBSTRB(SQLERRM,1,120));
19769: raise;
19770: END populate_bulk_pji_tab_for_plan;

Line 19856: FND_MSG_PUB.initialize;

19852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
19853: END IF;
19854:
19855: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
19856: FND_MSG_PUB.initialize;
19857: END IF;
19858:
19859: -- Bug # 3879910. Call corresponding API in package: PA_PROGRESS_PVT.
19860:

Line 19909: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

19905: IF p_commit = FND_API.G_TRUE THEN
19906: rollback to ASGN_DLV_TO_TASK_ROLLUP_PVT;
19907: END IF;
19908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19909: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19910: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
19911: p_error_text => SUBSTRB(SQLERRM,1,120));
19912: WHEN OTHERS THEN
19913: IF p_commit = FND_API.G_TRUE THEN

Line 19917: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

19913: IF p_commit = FND_API.G_TRUE THEN
19914: rollback to ASGN_DLV_TO_TASK_ROLLUP_PVT;
19915: END IF;
19916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
19917: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19918: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
19919: p_error_text => SUBSTRB(SQLERRM,1,120));
19920: raise;
19921: END ASGN_DLV_TO_TASK_ROLLUP_PVT;

Line 20154: FND_MSG_PUB.initialize;

20150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
20151: END IF;
20152:
20153: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
20154: FND_MSG_PUB.initialize;
20155: END IF;
20156:
20157: IF g1_debug_mode = 'Y' THEN
20158: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.COPY_PROGRESS_ACT_ETC', x_Msg => 'PA_PROGRESS_PUB.COPY_PROGRESS_ACT_ETC Passed Parameters', x_Log_Level=> 3);

Line 20830: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

20826:
20827:
20828: EXCEPTION
20829: WHEN OTHERS THEN
20830: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
20831: p_procedure_name => 'COPY_PROGRESS_ACT_ETC',
20832: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
20833: RAISE FND_API.G_EXC_ERROR;
20834: END;

Line 20898: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

20894: if p_commit = FND_API.G_TRUE then
20895: rollback to COPY_PROGRESS_ACT_ETC;
20896: end if;
20897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
20898: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
20899: p_procedure_name => 'COPY_PROGRESS_ACT_ETC',
20900: p_error_text => SUBSTRB(SQLERRM,1,120));
20901: when OTHERS then
20902: if p_commit = FND_API.G_TRUE then

Line 20906: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

20902: if p_commit = FND_API.G_TRUE then
20903: rollback to COPY_PROGRESS_ACT_ETC;
20904: end if;
20905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
20906: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
20907: p_procedure_name => 'COPY_PROGRESS_ACT_ETC',
20908: p_error_text => SUBSTRB(SQLERRM,1,120));
20909: raise;
20910:

Line 21019: FND_MSG_PUB.initialize;

21015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
21016: END IF;
21017:
21018: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
21019: FND_MSG_PUB.initialize;
21020: END IF;
21021:
21022: x_return_status := FND_API.G_RET_STS_SUCCESS;
21023:

Line 21079: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

21075: if p_commit = FND_API.G_TRUE then
21076: rollback to UPDATE_LINK_PROJ_ROLLUP_DATES;
21077: end if;
21078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21079: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
21080: p_procedure_name => 'UPDATE_LINK_PROJ_ROLLUP_DATES',
21081: p_error_text => SUBSTRB(SQLERRM,1,120));
21082: when OTHERS then
21083: if p_commit = FND_API.G_TRUE then

Line 21087: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

21083: if p_commit = FND_API.G_TRUE then
21084: rollback to UPDATE_LINK_PROJ_ROLLUP_DATES;
21085: end if;
21086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21087: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
21088: p_procedure_name => 'UPDATE_LINK_PROJ_ROLLUP_DATES',
21089: p_error_text => SUBSTRB(SQLERRM,1,120));
21090: raise;
21091: END update_link_proj_rollup_dates;

Line 21283: FND_MSG_PUB.initialize;

21279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
21280: END IF;
21281:
21282: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
21283: FND_MSG_PUB.initialize;
21284: END IF;
21285:
21286: x_return_status := FND_API.G_RET_STS_SUCCESS;
21287:

Line 21964: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

21960: Pa_Task_Pub1.G_CALL_PJI_ROLLUP := null ;
21961: delete from PA_PROG_ACT_BY_PERIOD_TEMP where project_id = p_project_id_tbl(i) AND structure_version_id = l_structure_version_id_tbl(i);
21962: EXCEPTION
21963: WHEN OTHERS THEN
21964: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
21965: p_procedure_name => 'UPDATE_PROGRESS_BULK',
21966: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
21967: RAISE FND_API.G_EXC_ERROR;
21968: END;

Line 21992: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

21988: END IF;
21989:
21990: EXCEPTION
21991: WHEN OTHERS THEN
21992: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
21993: p_procedure_name => 'UPDATE_PROGRESS_BULK',
21994: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
21995: RAISE FND_API.G_EXC_ERROR;
21996: END;

Line 22291: x_msg_count := fnd_msg_pub.count_msg;

22287: -- if p_commit = FND_API.G_TRUE then
22288: rollback to UPDATE_PROGRESS_BULK;
22289: -- end if;
22290: x_return_status := FND_API.G_RET_STS_ERROR;
22291: x_msg_count := fnd_msg_pub.count_msg;
22292: when FND_API.G_EXC_UNEXPECTED_ERROR then
22293: -- if p_commit = FND_API.G_TRUE then
22294: rollback to UPDATE_PROGRESS_BULK;
22295: -- end if;

Line 22297: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

22293: -- if p_commit = FND_API.G_TRUE then
22294: rollback to UPDATE_PROGRESS_BULK;
22295: -- end if;
22296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22297: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22298: p_procedure_name => 'UPDATE_PROGRESS_BULK',
22299: p_error_text => SUBSTRB(SQLERRM,1,120));
22300: x_msg_count := fnd_msg_pub.count_msg;
22301: when OTHERS then

Line 22300: x_msg_count := fnd_msg_pub.count_msg;

22296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22297: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22298: p_procedure_name => 'UPDATE_PROGRESS_BULK',
22299: p_error_text => SUBSTRB(SQLERRM,1,120));
22300: x_msg_count := fnd_msg_pub.count_msg;
22301: when OTHERS then
22302: -- if p_commit = FND_API.G_TRUE then
22303: rollback to UPDATE_PROGRESS_BULK;
22304: -- end if;

Line 22306: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

22302: -- if p_commit = FND_API.G_TRUE then
22303: rollback to UPDATE_PROGRESS_BULK;
22304: -- end if;
22305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22306: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22307: p_procedure_name => 'UPDATE_PROGRESS_BULK',
22308: p_error_text => SUBSTRB(SQLERRM,1,120));
22309: x_msg_count := fnd_msg_pub.count_msg;
22310: raise;

Line 22309: x_msg_count := fnd_msg_pub.count_msg;

22305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22306: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22307: p_procedure_name => 'UPDATE_PROGRESS_BULK',
22308: p_error_text => SUBSTRB(SQLERRM,1,120));
22309: x_msg_count := fnd_msg_pub.count_msg;
22310: raise;
22311: END update_progress_bulk;
22312:
22313: -- Bug 3994165 : Removing POPULATE_PRG_ACT_TEMP_TBL and POPULATE_PRG_ACT_TBL_SINGLE

Line 22362: FND_MSG_PUB.initialize;

22358: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
22359: END IF;
22360:
22361: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
22362: FND_MSG_PUB.initialize;
22363: END IF;
22364:
22365: x_return_status := FND_API.G_RET_STS_SUCCESS;
22366:

Line 22441: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

22437: if p_commit = FND_API.G_TRUE then
22438: rollback to APPLY_LP_PROG_ON_CWV_WRP;
22439: end if;
22440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22441: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22442: p_procedure_name => 'APPLY_LP_PROG_ON_CWV_WRP',
22443: p_error_text => SUBSTRB(SQLERRM,1,120));
22444: when OTHERS then
22445: if p_commit = FND_API.G_TRUE then

Line 22449: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

22445: if p_commit = FND_API.G_TRUE then
22446: rollback to APPLY_LP_PROG_ON_CWV;
22447: end if;
22448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22449: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22450: p_procedure_name => 'APPLY_LP_PROG_ON_CWV_WRP',
22451: p_error_text => SUBSTRB(SQLERRM,1,120));
22452: raise;
22453: END APPLY_LP_PROG_ON_CWV_WRP;