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 683: FND_MSG_PUB.initialize;

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

Line 870: x_msg_count := fnd_msg_pub.count_msg;

866: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
867: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
868: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
869: x_return_status := 'E';
870: x_msg_count := fnd_msg_pub.count_msg;
871: RAISE FND_API.G_EXC_ERROR;
872: END;
873:
874: IF g1_debug_mode = 'Y' THEN

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

2129: END IF;
2130:
2131: EXCEPTION
2132: WHEN OTHERS THEN
2133: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
2134: p_procedure_name => 'UPDATE_TASK_PROGRESS',
2135: p_error_text => SUBSTRB('PA_TASK_ASSIGNMENTS_PUB.DERIVE_TASK_ASSIGNMENTS:'||SQLERRM,1,120));
2136: RAISE fnd_api.g_exc_error;
2137: END;

Line 3249: IF Fnd_Msg_Pub.count_msg > 0 THEN

3245: ,x_subprj_eqpmt_etc_rawcost_fc => l_rollup_rec2.subprj_eqpmt_etc_rawcost_fc
3246: ,x_subprj_eqpmt_etc_rawcost_pc => l_rollup_rec2.subprj_eqpmt_etc_rawcost_pc
3247: );
3248: -- FPM Dev CR 6
3249: IF Fnd_Msg_Pub.count_msg > 0 THEN
3250: RAISE FND_API.G_EXC_ERROR;
3251: END IF;
3252:
3253: -----update percent_complete_id in pa_progress_rollup

Line 3364: IF Fnd_Msg_Pub.count_msg > 0 THEN

3360: ,p_attribute15 => null
3361: ,p_structure_type => p_structure_type
3362: );
3363: -- FPM Dev CR 6
3364: IF Fnd_Msg_Pub.count_msg > 0 THEN
3365: RAISE FND_API.G_EXC_ERROR;
3366: END IF;
3367:
3368:

Line 3581: IF Fnd_Msg_Pub.count_msg > 0 THEN

3577: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.UPDATE_TASK_PROGRESS', x_Msg => 'Update Action: Updated PA_PROGRESS_ROLLUP ', x_Log_Level=> 3);
3578: END IF;
3579:
3580: -- FPM Dev CR 6
3581: IF Fnd_Msg_Pub.count_msg > 0 THEN
3582: RAISE FND_API.G_EXC_ERROR;
3583: END IF;
3584: ELSE ---2
3585:

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

4215: THEN
4216: rollback to UPDATE_TASK_PROGRESS;
4217: END IF;
4218: x_return_status := FND_API.G_RET_STS_ERROR;
4219: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3
4220: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4221: IF p_commit = FND_API.G_TRUE
4222: THEN
4223: rollback to UPDATE_TASK_PROGRESS;

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

4222: THEN
4223: rollback to UPDATE_TASK_PROGRESS;
4224: END IF;
4225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4226: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4227: p_procedure_name => 'UPDATE_TASK_PROGRESS',
4228: p_error_text => SUBSTRB(SQLERRM,1,120));
4229: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3
4230: WHEN OTHERS THEN

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

4225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4226: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4227: p_procedure_name => 'UPDATE_TASK_PROGRESS',
4228: p_error_text => SUBSTRB(SQLERRM,1,120));
4229: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3
4230: WHEN OTHERS THEN
4231: IF p_commit = FND_API.G_TRUE THEN
4232: rollback to UPDATE_TASK_PROGRESS;
4233: END IF;

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

4231: IF p_commit = FND_API.G_TRUE THEN
4232: rollback to UPDATE_TASK_PROGRESS;
4233: END IF;
4234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4236: p_procedure_name => 'UPDATE_TASK_PROGRESS',
4237: p_error_text => SUBSTRB(SQLERRM,1,120));
4238: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3
4239: raise;

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

4234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4235: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4236: p_procedure_name => 'UPDATE_TASK_PROGRESS',
4237: p_error_text => SUBSTRB(SQLERRM,1,120));
4238: x_msg_count := fnd_msg_pub.count_msg; -- FPM Dev CR 3
4239: raise;
4240: END UPDATE_TASK_PROGRESS;
4241:
4242:

Line 4376: FND_MSG_PUB.initialize;

4372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4373: END IF;
4374:
4375: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4376: FND_MSG_PUB.initialize;
4377: END IF;
4378:
4379: -- Bug # 3879910. Call corresponding API in package: PA_PROGRESS_PVT.
4380:

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

4437: IF p_commit = FND_API.G_TRUE THEN
4438: rollback to ROLLUP_PROGRESS_PVT;
4439: END IF;
4440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4441: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4442: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
4443: p_error_text => SUBSTRB(SQLERRM,1,120));
4444: WHEN OTHERS THEN
4445: IF p_commit = FND_API.G_TRUE THEN

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

4445: IF p_commit = FND_API.G_TRUE THEN
4446: rollback to ROLLUP_PROGRESS_PVT;
4447: END IF;
4448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4449: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4450: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
4451: p_error_text => SUBSTRB(SQLERRM,1,120));
4452: raise;
4453: END ROLLUP_PROGRESS_PVT;

Line 4559: FND_MSG_PUB.initialize;

4555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4556: END IF;
4557:
4558: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4559: FND_MSG_PUB.initialize;
4560: END IF;
4561:
4562: -- Bug # 3879910. Call corresponding API in package: PA_PROGRESS_PVT.
4563:

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

4628: IF p_commit = FND_API.G_TRUE THEN
4629: rollback to UPDATE_ROLLUP_PROGRESS_PVT;
4630: END IF;
4631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4632: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4633: p_procedure_name => 'UPDATE_ROLLUP_PROGRESS_PVT',
4634: p_error_text => SUBSTRB(SQLERRM,1,120));
4635: WHEN OTHERS THEN
4636: IF g1_debug_mode = 'Y' THEN

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

4640: IF p_commit = FND_API.G_TRUE THEN
4641: rollback to UPDATE_ROLLUP_PROGRESS_PVT;
4642: END IF;
4643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4644: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4645: p_procedure_name => 'UPDATE_ROLLUP_PROGRESS_PVT',
4646: p_error_text => SUBSTRB(SQLERRM,1,120));
4647: raise;
4648: END UPDATE_ROLLUP_PROGRESS_PVT;

Line 4720: FND_MSG_PUB.initialize;

4716: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4717: END IF;
4718:
4719: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4720: FND_MSG_PUB.initialize;
4721: END IF;
4722:
4723: IF P_PROGRESS_CYCLE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4724: THEN

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

4807: if p_commit = FND_API.G_TRUE then
4808: rollback to CREATE_PROJ_PROG_ATTR;
4809: end if;
4810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4811: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4812: p_procedure_name => 'CREATE_PROJ_PROG_ATTR',
4813: p_error_text => SUBSTRB(SQLERRM,1,120));
4814: when OTHERS then
4815: if p_commit = FND_API.G_TRUE then

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

4815: if p_commit = FND_API.G_TRUE then
4816: rollback to CREATE_PROJ_PROG_ATTR;
4817: end if;
4818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4819: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
4820: p_procedure_name => 'CREATE_PROJ_PROG_ATTR',
4821: p_error_text => SUBSTRB(SQLERRM,1,120));
4822: raise;
4823: END CREATE_PROJ_PROG_ATTR;

Line 4952: FND_MSG_PUB.initialize;

4948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4949: END IF;
4950:
4951: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4952: FND_MSG_PUB.initialize;
4953: END IF;
4954:
4955: /* IF P_PROGRESS_CYCLE_ID = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4956: THEN

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

5237: if p_commit = FND_API.G_TRUE then
5238: rollback to UPDATE_PROJ_PROG_ATTR;
5239: end if;
5240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5241: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
5242: p_procedure_name => 'UPDATE_PROJ_PROG_ATTR',
5243: p_error_text => SUBSTRB(SQLERRM,1,120));
5244: when OTHERS then
5245: if p_commit = FND_API.G_TRUE then

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

5245: if p_commit = FND_API.G_TRUE then
5246: rollback to UPDATE_PROJ_PROG_ATTR;
5247: end if;
5248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5249: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
5250: p_procedure_name => 'UPDATE_PROJ_PROG_ATTR',
5251: p_error_text => SUBSTRB(SQLERRM,1,120));
5252: raise;
5253: END UPDATE_PROJ_PROG_ATTR;

Line 5315: FND_MSG_PUB.initialize;

5311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5312: END IF;
5313:
5314: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5315: FND_MSG_PUB.initialize;
5316: END IF;
5317:
5318: OPEN cur_ppp;
5319: FETCH cur_ppp INTO l_ppp_row_id;

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

5344: if p_commit = FND_API.G_TRUE then
5345: rollback to DELETE_PROJ_PROG_ATTR;
5346: end if;
5347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5348: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
5349: p_procedure_name => 'DELETE_PROJ_PROG_ATTR',
5350: p_error_text => SUBSTRB(SQLERRM,1,120));
5351: when OTHERS then
5352: if p_commit = FND_API.G_TRUE then

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

5352: if p_commit = FND_API.G_TRUE then
5353: rollback to DELETE_PROJ_PROG_ATTR;
5354: end if;
5355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5356: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
5357: p_procedure_name => 'DELETE_PROJ_PROG_ATTR',
5358: p_error_text => SUBSTRB(SQLERRM,1,120));
5359: raise;
5360: END DELETE_PROJ_PROG_ATTR;

Line 5456: FND_MSG_PUB.initialize;

5452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5453: END IF;
5454:
5455: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5456: FND_MSG_PUB.initialize;
5457: END IF;
5458:
5459: IF p_task_version_id is NULL OR p_task_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5460: THEN

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

5499: if p_commit = FND_API.G_TRUE then
5500: rollback to delete_progress_record;
5501: end if;
5502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5503: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
5504: p_procedure_name => 'delete_progress_record',
5505: p_error_text => SUBSTRB(SQLERRM,1,120));
5506: when OTHERS then
5507: if p_commit = FND_API.G_TRUE then

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

5507: if p_commit = FND_API.G_TRUE then
5508: rollback to delete_progress_record;
5509: end if;
5510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5511: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
5512: p_procedure_name => 'delete_progress_record',
5513: p_error_text => SUBSTRB(SQLERRM,1,120));
5514: raise;
5515: END delete_progress_record;

Line 5756: FND_MSG_PUB.initialize;

5752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5753: END IF;
5754:
5755: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
5756: FND_MSG_PUB.initialize;
5757: END IF;
5758:
5759: -- Bug 3878024 : Begin
5760: BEGIN

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

5762: FROM pa_proj_element_versions
5763: WHERE element_version_id = p_object_version_id;
5764: EXCEPTION
5765: WHEN OTHERS THEN
5766: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
5767: p_procedure_name => 'PUSH_DOWN_TASK_STATUS',
5768: p_error_text => 'Unexpected Error : Structure Version Id can not be found. Please contact System Administrator.');
5769:
5770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

Line 6117: IF Fnd_Msg_Pub.count_msg > 0 THEN

6113: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
6114: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
6115: );
6116:
6117: IF Fnd_Msg_Pub.count_msg > 0 THEN
6118: RAISE FND_API.G_EXC_ERROR;
6119: END IF;
6120: END IF; -- cur_task_assignments_rec.current_flag = 'Y' THEN
6121:

Line 6438: IF Fnd_Msg_Pub.count_msg > 0 THEN

6434: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
6435: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
6436: );
6437:
6438: IF Fnd_Msg_Pub.count_msg > 0 THEN
6439: RAISE FND_API.G_EXC_ERROR;
6440: END IF;
6441:
6442: -- Bug 3922325 : Hidden Assignment record also shd get created

Line 6572: IF Fnd_Msg_Pub.count_msg > 0 THEN

6568: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
6569: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
6570: );
6571:
6572: IF Fnd_Msg_Pub.count_msg > 0 THEN
6573: RAISE FND_API.G_EXC_ERROR;
6574: END IF;
6575:
6576: END IF; -- cur_task_assignments_rec.current_flag = 'Y' THEN

Line 6872: IF Fnd_Msg_Pub.count_msg > 0 THEN

6868: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
6869: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
6870: );
6871:
6872: IF Fnd_Msg_Pub.count_msg > 0 THEN
6873: RAISE FND_API.G_EXC_ERROR;
6874: END IF;
6875:
6876: IF g1_debug_mode = 'Y' THEN

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

6885: PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE (x_msg_code => l_msg_code,
6886: x_return_status => x_return_status);
6887: EXCEPTION
6888: WHEN OTHERS THEN
6889: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
6890: p_procedure_name => 'PUSH_DOWN_TASK_STATUS',
6891: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
6892: RAISE FND_API.G_EXC_ERROR;
6893: END;

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

6911: x_msg_code => l_msg_code
6912: );
6913: EXCEPTION
6914: WHEN OTHERS THEN
6915: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
6916: p_procedure_name => 'PUSH_DOWN_TASK_STATUS',
6917: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data:'||SQLERRM,1,120));
6918: RAISE FND_API.G_EXC_ERROR;
6919: END;

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

7083: if p_commit = FND_API.G_TRUE then
7084: rollback to push_down_task_status;
7085: end if;
7086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7087: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
7088: p_procedure_name => 'push_down_task_status',
7089: p_error_text => SUBSTRB(SQLERRM,1,120));
7090: when OTHERS then
7091: if p_commit = FND_API.G_TRUE then

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

7091: if p_commit = FND_API.G_TRUE then
7092: rollback to push_down_task_status;
7093: end if;
7094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7095: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
7096: p_procedure_name => 'push_down_task_status',
7097: p_error_text => SUBSTRB(SQLERRM,1,120));
7098: raise;
7099: END push_down_task_status;

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

7181: END IF;
7182: EXCEPTION
7183: WHEN OTHERS THEN
7184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7185: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
7186: p_procedure_name => 'ROLLUP_FUTURE_PROGRESS_PVT',
7187: p_error_text => SUBSTRB(SQLERRM,1,120));
7188: raise;
7189: END ROLLUP_FUTURE_PROGRESS_PVT;

Line 7571: FND_MSG_PUB.initialize;

7567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7568: END IF;
7569:
7570: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
7571: FND_MSG_PUB.initialize;
7572: END IF;
7573:
7574: x_return_status := FND_API.G_RET_STS_SUCCESS;
7575:

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

7971:
7972: --maansari6/26
7973: EXCEPTION
7974: WHEN OTHERS THEN
7975: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
7976: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
7977: p_error_text => SUBSTRB('PA_TASK_ASSIGNMENTS_PUB.DERIVE_TASK_ASSIGNMENTS:'||SQLERRM,1,120));
7978: raise fnd_api.g_exc_error;
7979: END;

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

8493: 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);
8494: END IF;
8495: EXCEPTION
8496: WHEN OTHERS THEN
8497: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8498: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8499: p_error_text => SUBSTRB('PA_PROGRESS_PVT.COPY_ACTUALS_FOR_WORKPLAN:'||SQLERRM,1,120));
8500: RAISE FND_API.G_EXC_ERROR;
8501: END;

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

8611: 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);
8612: END IF;
8613: EXCEPTION
8614: WHEN OTHERS THEN
8615: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8616: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8617: p_error_text => SUBSTRB('Call of PA_FP_CALC_PLAN_PKG.calculate Failed:'||SQLERRM,1,120));
8618: RAISE FND_API.G_EXC_ERROR;
8619: END;

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

8644:
8645:
8646: EXCEPTION
8647: WHEN OTHERS THEN
8648: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8649: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8650: p_error_text => SUBSTRB('PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
8651: RAISE FND_API.G_EXC_ERROR;
8652: END;

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

8731: END;
8732: END IF;
8733: EXCEPTION
8734: WHEN OTHERS THEN
8735: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8736: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8737: p_error_text => SUBSTRB('PA_PROGRESS_PUB.POPULATE_PJI_TAB_FOR_PLAN:'||SQLERRM,1,120));
8738: RAISE FND_API.G_EXC_ERROR;
8739: END;

Line 8797: x_msg_count := fnd_msg_pub.count_msg;

8793: if p_commit = FND_API.G_TRUE then
8794: rollback to APPLY_LP_PROG_ON_CWV;
8795: end if;
8796: x_return_status := FND_API.G_RET_STS_ERROR;
8797: x_msg_count := fnd_msg_pub.count_msg;
8798:
8799: -- BEGIN: Commenting this code out to fix Bug # 3956275.
8800: /*
8801:

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

8800: /*
8801:
8802: -- BEGIN: Adding code to fix Bug # 3815741.
8803:
8804: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8805: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8806: p_error_text => SUBSTRB(SQLERRM,1,120));
8807:
8808: -- END: Adding code to fix Bug # 3815741.

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

8815: if p_commit = FND_API.G_TRUE then
8816: rollback to APPLY_LP_PROG_ON_CWV;
8817: end if;
8818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8819: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8820: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8821: p_error_text => SUBSTRB(SQLERRM,1,120));
8822: x_msg_count := fnd_msg_pub.count_msg;
8823: when OTHERS then

Line 8822: x_msg_count := fnd_msg_pub.count_msg;

8818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8819: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8820: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8821: p_error_text => SUBSTRB(SQLERRM,1,120));
8822: x_msg_count := fnd_msg_pub.count_msg;
8823: when OTHERS then
8824: if p_commit = FND_API.G_TRUE then
8825: rollback to APPLY_LP_PROG_ON_CWV;
8826: end if;

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

8824: if p_commit = FND_API.G_TRUE then
8825: rollback to APPLY_LP_PROG_ON_CWV;
8826: end if;
8827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8828: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8829: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8830: p_error_text => SUBSTRB(SQLERRM,1,120));
8831: x_msg_count := fnd_msg_pub.count_msg;
8832: raise;

Line 8831: x_msg_count := fnd_msg_pub.count_msg;

8827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8828: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8829: p_procedure_name => 'APPLY_LP_PROG_ON_CWV',
8830: p_error_text => SUBSTRB(SQLERRM,1,120));
8831: x_msg_count := fnd_msg_pub.count_msg;
8832: raise;
8833: END APPLY_LP_PROG_ON_CWV;
8834:
8835: -- Progress Management Changes. Bug # 3420093.

Line 8882: FND_MSG_PUB.initialize;

8878: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
8879: END IF;
8880:
8881: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
8882: FND_MSG_PUB.initialize;
8883: END IF;
8884:
8885: x_return_status := FND_API.G_RET_STS_SUCCESS;
8886:

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

8939: if p_commit = FND_API.G_TRUE then
8940: rollback to DELETE_WORKING_WP_PROGRESS;
8941: end if;
8942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8943: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8944: p_procedure_name => 'DELETE_WORKING_WP_PROGRESS',
8945: p_error_text => SUBSTRB(SQLERRM,1,120));
8946: when OTHERS then
8947: if p_commit = FND_API.G_TRUE then

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

8947: if p_commit = FND_API.G_TRUE then
8948: rollback to DELETE_WORKING_WP_PROGRESS;
8949: end if;
8950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8951: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
8952: p_procedure_name => 'DELETE_WORKING_WP_PROGRESS',
8953: p_error_text => SUBSTRB(SQLERRM,1,120));
8954: raise;
8955: END delete_working_wp_progress;

Line 9046: FND_MSG_PUB.initialize;

9042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9043: END IF;
9044:
9045: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
9046: FND_MSG_PUB.initialize;
9047: END IF;
9048:
9049: x_return_status := FND_API.G_RET_STS_SUCCESS;
9050:

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

9099: , x_return_status => x_return_status);
9100:
9101: EXCEPTION
9102: WHEN OTHERS THEN
9103: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9104: p_procedure_name => 'PULL_SUMMARIZED_ACTUALS',
9105: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE failed: sqlerrm='||SQLERRM,1,120));
9106: RAISE FND_API.G_EXC_ERROR;
9107: END;

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

9171: if p_commit = FND_API.G_TRUE then
9172: rollback to PULL_SUMMARIZED_ACTUALS;
9173: end if;
9174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9175: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9176: p_procedure_name => 'PULL_SUMMARIZED_ACTUALS',
9177: p_error_text => SUBSTRB(SQLERRM,1,120));
9178: when OTHERS then
9179: if p_commit = FND_API.G_TRUE then

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

9179: if p_commit = FND_API.G_TRUE then
9180: rollback to DELETE_WORKING_WP_PROGRESS;
9181: end if;
9182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9183: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9184: p_procedure_name => 'PULL_SUMMARIZED_ACTUALS',
9185: p_error_text => SUBSTRB(SQLERRM,1,120));
9186: raise;
9187: END PULL_SUMMARIZED_ACTUALS;

Line 9441: FND_MSG_PUB.initialize;

9437: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9438: END IF;
9439:
9440: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
9441: FND_MSG_PUB.initialize;
9442: END IF;
9443:
9444: x_return_status := FND_API.G_RET_STS_SUCCESS;
9445:

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

9924: AND structure_version_id = l_structure_version_id;
9925: -- 3994165 : Deletion is now moved here.
9926: EXCEPTION
9927: WHEN OTHERS THEN
9928: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9929: p_procedure_name => 'update_progress',
9930: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
9931: RAISE FND_API.G_EXC_ERROR;
9932: END;

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

9954: x_msg_code => l_msg_code,
9955: x_return_status => x_return_status);
9956: EXCEPTION
9957: WHEN OTHERS THEN
9958: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
9959: p_procedure_name => 'update_progress',
9960: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
9961: RAISE FND_API.G_EXC_ERROR;
9962: END;

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

10004: x_msg_code => l_msg_code
10005: );
10006: EXCEPTION
10007: WHEN OTHERS THEN
10008: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10009: p_procedure_name => 'update_progress',
10010: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data:'||SQLERRM,1,120));
10011: RAISE FND_API.G_EXC_ERROR;
10012: END;

Line 10228: x_msg_count := fnd_msg_pub.count_msg;

10224: if p_commit = FND_API.G_TRUE then
10225: rollback to UPDATE_PROGRESS;
10226: end if;
10227: x_return_status := FND_API.G_RET_STS_ERROR;
10228: x_msg_count := fnd_msg_pub.count_msg;
10229: when FND_API.G_EXC_UNEXPECTED_ERROR then
10230: if p_commit = FND_API.G_TRUE then
10231: rollback to UPDATE_PROGRESS;
10232: end if;

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

10230: if p_commit = FND_API.G_TRUE then
10231: rollback to UPDATE_PROGRESS;
10232: end if;
10233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10234: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10235: p_procedure_name => 'UPDATE_PROGRESS',
10236: p_error_text => SUBSTRB(SQLERRM,1,120));
10237: x_msg_count := fnd_msg_pub.count_msg;
10238: when OTHERS then

Line 10237: x_msg_count := fnd_msg_pub.count_msg;

10233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10234: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10235: p_procedure_name => 'UPDATE_PROGRESS',
10236: p_error_text => SUBSTRB(SQLERRM,1,120));
10237: x_msg_count := fnd_msg_pub.count_msg;
10238: when OTHERS then
10239: if p_commit = FND_API.G_TRUE then
10240: rollback to UPDATE_PROGRESS;
10241: end if;

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

10239: if p_commit = FND_API.G_TRUE then
10240: rollback to UPDATE_PROGRESS;
10241: end if;
10242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10243: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10244: p_procedure_name => 'UPDATE_PROGRESS',
10245: p_error_text => SUBSTRB(SQLERRM,1,120));
10246: x_msg_count := fnd_msg_pub.count_msg;
10247: raise;

Line 10246: x_msg_count := fnd_msg_pub.count_msg;

10242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10243: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10244: p_procedure_name => 'UPDATE_PROGRESS',
10245: p_error_text => SUBSTRB(SQLERRM,1,120));
10246: x_msg_count := fnd_msg_pub.count_msg;
10247: raise;
10248: END update_progress;
10249:
10250: -- Progress Management Changes. Bug # 3420093.

Line 10308: FND_MSG_PUB.initialize;

10304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10305: END IF;
10306:
10307: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
10308: FND_MSG_PUB.initialize;
10309: END IF;
10310:
10311: x_return_status := FND_API.G_RET_STS_SUCCESS;
10312:

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

10368:
10369: END IF;
10370: EXCEPTION
10371: WHEN OTHERS THEN
10372: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10373: p_procedure_name => 'POPULATE_PJI_TAB_FOR_PLAN',
10374: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data Failed. SQLERRM='||SQLERRM,1,120));
10375: RAISE FND_API.G_EXC_ERROR;
10376: END;

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

10395: if p_commit = FND_API.G_TRUE then
10396: rollback to plan_qtys;
10397: end if;
10398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10399: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10400: p_procedure_name => 'populate_pji_tab_for_plan',
10401: p_error_text => SUBSTRB(SQLERRM,1,120));
10402: when OTHERS then
10403: if p_commit = FND_API.G_TRUE then

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

10403: if p_commit = FND_API.G_TRUE then
10404: rollback to plan_qtys;
10405: end if;
10406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10407: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10408: p_procedure_name => 'populate_pji_tab_for_plan',
10409: p_error_text => SUBSTRB(SQLERRM,1,120));
10410: raise;
10411: END populate_pji_tab_for_plan;

Line 10563: FND_MSG_PUB.initialize;

10559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10560: END IF;
10561:
10562: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
10563: FND_MSG_PUB.initialize;
10564: END IF;
10565:
10566: x_return_status := FND_API.G_RET_STS_SUCCESS;
10567: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --Bug 3801745

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

10657: BEGIN
10658: l_period_type := PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase( l_structure_version_id ); -- Bug 3608422 : passing l_ instead of p_
10659: EXCEPTION
10660: WHEN OTHERS THEN
10661: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10662: p_procedure_name => 'push_workplan_actuals',
10663: p_error_text => SUBSTRB('PA_FIN_PLAN_UTILS.Get_wp_bv_time_phase:'||SQLERRM,1,120));
10664: RAISE FND_API.G_EXC_ERROR;
10665: END;

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

10686: BEGIN
10687: l_plan_type_id := Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id(p_project_id => p_project_id);
10688: EXCEPTION
10689: WHEN OTHERS THEN
10690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10691: p_procedure_name => 'PUSH_WORKPLAN_ACTUALS',
10692: p_error_text => SUBSTRB('Call Pa_Fp_wp_gen_amt_utils.get_wp_ptype_id:'||SQLERRM,1,120));
10693: RAISE FND_API.G_EXC_ERROR;
10694: END;

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

10699: p_plan_type_id => -1,
10700: p_proj_str_ver_id => l_structure_version_id) ;
10701: EXCEPTION
10702: WHEN OTHERS THEN
10703: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10704: p_procedure_name => 'PUSH_WORKPLAN_ACTUALS',
10705: p_error_text => SUBSTRB('Call Pa_Fp_wp_gen_amt_utils.get_wp_version_id:'||SQLERRM,1,120));
10706: RAISE FND_API.G_EXC_ERROR;
10707: END;

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

10864: );*/
10865: -- End Bug 15928585
10866: EXCEPTION
10867: WHEN OTHERS THEN
10868: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10869: p_procedure_name => 'push_workplan_actuals',
10870: p_error_text => SUBSTRB('INSERT INTO PJI_FM_EXTR_PLAN_LINES:'||SQLERRM,1,120));
10871: RAISE FND_API.G_EXC_ERROR;
10872: END;

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

10970: if p_commit = FND_API.G_TRUE then
10971: rollback to push_actuals;
10972: end if;
10973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10974: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10975: p_procedure_name => 'push_workplan_actuals',
10976: p_error_text => SUBSTRB(SQLERRM,1,120));
10977: when OTHERS then
10978: if p_commit = FND_API.G_TRUE then

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

10978: if p_commit = FND_API.G_TRUE then
10979: rollback to push_actuals;
10980: end if;
10981: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10982: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10983: p_procedure_name => 'push_workplan_actuals',
10984: p_error_text => SUBSTRB(SQLERRM,1,120));
10985: raise;
10986: END push_workplan_actuals;

Line 11050: FND_MSG_PUB.initialize;

11046: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11047: END IF;
11048:
11049: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
11050: FND_MSG_PUB.initialize;
11051: END IF;
11052:
11053: x_return_status := FND_API.G_RET_STS_SUCCESS;
11054:

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

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

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

11100: if p_commit = FND_API.G_TRUE then
11101: rollback to PROGRAM_ROLLUP_PVT;
11102: end if;
11103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11104: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
11105: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
11106: p_error_text => SUBSTRB(SQLERRM,1,120));
11107: raise;
11108: END program_rollup_pvt;

Line 11246: FND_MSG_PUB.initialize;

11242: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11243: END IF;
11244:
11245: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
11246: FND_MSG_PUB.initialize;
11247: END IF;
11248:
11249:
11250: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

11531: if p_commit = FND_API.G_TRUE then
11532: rollback to TRANSFER_WP_PERCENT_TO_FIN;
11533: end if;
11534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11535: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
11536: p_procedure_name => 'TRANSFER_WP_PERCENT_TO_FIN',
11537: p_error_text => SUBSTRB(SQLERRM,1,120));
11538: when OTHERS then
11539: if p_commit = FND_API.G_TRUE then

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

11539: if p_commit = FND_API.G_TRUE then
11540: rollback to TRANSFER_WP_PERCENT_TO_FIN;
11541: end if;
11542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11543: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
11544: p_procedure_name => 'TRANSFER_WP_PERCENT_TO_FIN',
11545: p_error_text => SUBSTRB(SQLERRM,1,120));
11546: raise;
11547: END transfer_wp_percent_to_fin;

Line 12100: FND_MSG_PUB.initialize;

12096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12097: END IF;
12098:
12099: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
12100: FND_MSG_PUB.initialize;
12101: END IF;
12102:
12103: x_return_status := FND_API.G_RET_STS_SUCCESS;
12104:

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

13240: if p_commit = FND_API.G_TRUE then
13241: rollback to PUBLISH_PROGRESS;
13242: end if;
13243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
13245: p_procedure_name => 'PUBLISH_PROGRESS',
13246: p_error_text => SUBSTRB(SQLERRM,1,120));
13247: when OTHERS then
13248: if p_commit = FND_API.G_TRUE then

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

13248: if p_commit = FND_API.G_TRUE then
13249: rollback to PUBLISH_PROGRESS;
13250: end if;
13251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
13252: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
13253: p_procedure_name => 'PUBLISH_PROGRESS',
13254: p_error_text => SUBSTRB(SQLERRM,1,120));
13255: raise;
13256:

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

14590: END IF;
14591: end if;
14592: exception when others then
14593: pa_debug.log_message('GET_SUMM_ACT: get_summarized_data failed with exception', 1);
14594: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14595: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14596: p_error_text => SUBSTRB('pji_fm_xbs_accum_utils.get_summarized_data:'||SQLERRM,1,120));
14597: raise;
14598: end;

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

14644: x_Log_Level=> 3);
14645: END IF;
14646: exception when others then
14647: pa_debug.log_message('GET_SUMM_ACT: populate_workplan_data failed with exception', 1);
14648: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14649: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14650: p_error_text => SUBSTRB('PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data:'||SQLERRM,1,120));
14651: raise;
14652: end;

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

14734: -- l_project_id := -99999; --- so that the next loop won't get executed
14735:
14736: /* Added If condition for Bug#5659575*/
14737: if p_extraction_type = 'PUBLISH' then
14738: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14739: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14740: p_error_text => SUBSTRB('Call of pa_utils2.get_gl_period_name failed: x_msg_data='||SQLERRM,1,120));
14741: x_return_status := 'E';
14742: RAISE;

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

14772: x_return_status => x_return_status,
14773: x_msg_code => x_msg_code );
14774: exception when others then
14775: pa_debug.log_message('GET_SUMM_ACT: populate_workplan_data failed with exception', 1);
14776: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14777: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14778: p_error_text => SUBSTRB('PJI_FM_XBS_ACCUM_UTILS.populate_workplan_data:'||SQLERRM,1,120));
14779: raise;
14780: end;

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

14921: ,x_msg_data => x_msg_data
14922: ,x_return_status => x_return_status);
14923: exception when others then
14924: x_return_status := 'E';
14925: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
14926: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
14927: p_error_text => SUBSTRB('pa_task_assignments_pvt.Derive_Task_Assignments:'||SQLERRM,1,120));
14928: -- Added for Bug # 5526638
14929: l_err_msg := substrb('Derive task assignment to track actuals failed:'||SQLERRM,1,240) ;

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

19426: END IF;
19427: EXCEPTION when others then
19428: x_return_status := 'E';
19429: pa_debug.log_message('GET_SUMM_ACT: Exception in rollup of progress attributes.', 1);
19430: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19431: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
19432: p_error_text => SUBSTRB('pa_progress_pub.rollup_progress_pvt:'||SQLERRM,1,120));
19433: -- Added for bug 5526638
19434: l_err_msg := substrb('Exception in rollup of progress attributes :'||SQLERRM,1,240);

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

19467: END IF;
19468: EXCEPTION when others then
19469: x_return_status := 'E';
19470: pa_debug.log_message('GET_SUMM_ACT: Exception in program rollup.', 1);
19471: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19472: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
19473: p_error_text => SUBSTRB('pa_progress_pub.program_rollup_pvt:'||SQLERRM,1,120));
19474: -- Added for bug 5526638
19475: l_err_msg := substrb('Exception in program rollup :'||SQLERRM,1,240);

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

19751:
19752: EXCEPTION when others then
19753: pa_debug.log_message('GET_SUMM_ACT: PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP returned exception.', 1);
19754: x_return_status := 'E';
19755: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19756: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
19757: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
19758: raise;
19759: end;

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

19831: pa_debug.log_message('GET_SUMM_ACT: Error while calling PJI api', 1);
19832: x_return_status :='E' ;
19833: when others then
19834: x_return_status := 'E';
19835: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19836: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
19837: p_error_text => SUBSTRB('pa_progress_pub.get_summarized_actuals:'||SQLERRM,1,120));
19838: -- 4746476 : Priniting stack
19839: FOR i in 1..fnd_msg_pub.count_msg LOOP

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

19835: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
19836: p_procedure_name => 'GET_SUMMARIZED_ACTUALS',
19837: p_error_text => SUBSTRB('pa_progress_pub.get_summarized_actuals:'||SQLERRM,1,120));
19838: -- 4746476 : Priniting stack
19839: FOR i in 1..fnd_msg_pub.count_msg LOOP
19840: pa_interface_utils_pub.get_messages (
19841: p_encoded => Fnd_Api.G_FALSE
19842: ,p_data => l_data
19843: ,p_msg_index => i

Line 20007: FND_MSG_PUB.initialize;

20003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
20004: END IF;
20005:
20006: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
20007: FND_MSG_PUB.initialize;
20008: END IF;
20009:
20010: IF g1_debug_mode = 'Y' THEN
20011: 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 20567: IF Fnd_Msg_Pub.count_msg > 0 THEN

20563: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
20564: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null);
20565:
20566: -- FPM Dev CR 6
20567: IF Fnd_Msg_Pub.count_msg > 0 THEN
20568: RAISE FND_API.G_EXC_ERROR;
20569: END IF;
20570:
20571:

Line 20655: IF Fnd_Msg_Pub.count_msg > 0 THEN

20651: ,p_structure_type => p_structure_type
20652:
20653: );
20654: -- FPM Dev CR 6
20655: IF Fnd_Msg_Pub.count_msg > 0 THEN
20656: RAISE FND_API.G_EXC_ERROR;
20657: END IF;
20658:
20659:

Line 20804: IF Fnd_Msg_Pub.count_msg > 0 THEN

20800: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => null
20801: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
20802: );
20803: -- FPM Dev CR 6
20804: IF Fnd_Msg_Pub.count_msg > 0 THEN
20805: RAISE FND_API.G_EXC_ERROR;
20806: END IF;
20807:
20808: IF g1_debug_mode = 'Y' THEN

Line 20822: l_msg_count := Fnd_Msg_Pub.count_msg;

20818:
20819: EXCEPTION
20820: when FND_API.G_EXC_ERROR then
20821: x_return_status := FND_API.G_RET_STS_ERROR;
20822: l_msg_count := Fnd_Msg_Pub.count_msg;
20823:
20824: if p_commit = FND_API.G_TRUE then
20825: rollback to UPDATE_FINANCIAL_TASK_PROGRESS;
20826: end if;

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

20848: if p_commit = FND_API.G_TRUE then
20849: rollback to UPDATE_FINANCIAL_TASK_PROGRESS;
20850: end if;
20851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
20852: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
20853: p_procedure_name => 'UPDATE_FINANCIAL_TASK_PROGRESS',
20854: p_error_text => SUBSTRB(SQLERRM,1,120));
20855: when OTHERS then
20856: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

20859: if p_commit = FND_API.G_TRUE then
20860: rollback to UPDATE_DELIVERABLE_PROGRESS;
20861: end if;
20862:
20863: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
20864: p_procedure_name => 'UPDATE_FINANCIAL_TASK_PROGRESS',
20865: p_error_text => SUBSTRB(SQLERRM,1,120));
20866: raise;
20867:

Line 20966: FND_MSG_PUB.initialize;

20962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
20963: END IF;
20964:
20965: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
20966: FND_MSG_PUB.initialize;
20967: END IF;
20968:
20969: x_return_status := FND_API.G_RET_STS_SUCCESS;
20970:

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

21022: );
21023:
21024: EXCEPTION
21025: WHEN OTHERS THEN
21026: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
21027: p_procedure_name => 'RE_ROLLUP_PROGRESS',
21028: p_error_text => SUBSTRB('PA_PROGRESS_PUB.populate_pji_tab_for_plan:'||SQLERRM,1,240));
21029: RAISE FND_API.G_EXC_ERROR;
21030: END;

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

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

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

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

Line 21168: FND_MSG_PUB.initialize;

21164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
21165: END IF;
21166:
21167: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
21168: FND_MSG_PUB.initialize;
21169: END IF;
21170:
21171: x_return_status := FND_API.G_RET_STS_SUCCESS;
21172:

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

21217: if p_commit = FND_API.G_TRUE then
21218: rollback to populate_bulk_pji_tab_for_plan;
21219: end if;
21220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21221: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
21222: p_procedure_name => 'POPULATE_BULK_PJI_TAB_FOR_PLAN',
21223: p_error_text => SUBSTRB(SQLERRM,1,120));
21224: when OTHERS then
21225: if p_commit = FND_API.G_TRUE then

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

21225: if p_commit = FND_API.G_TRUE then
21226: rollback to populate_bulk_pji_tab_for_plan;
21227: end if;
21228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21229: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
21230: p_procedure_name => 'POPULATE_BULK_PJI_TAB_FOR_PLAN',
21231: p_error_text => SUBSTRB(SQLERRM,1,120));
21232: raise;
21233: END populate_bulk_pji_tab_for_plan;

Line 21319: FND_MSG_PUB.initialize;

21315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
21316: END IF;
21317:
21318: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
21319: FND_MSG_PUB.initialize;
21320: END IF;
21321:
21322: -- Bug # 3879910. Call corresponding API in package: PA_PROGRESS_PVT.
21323:

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

21368: IF p_commit = FND_API.G_TRUE THEN
21369: rollback to ASGN_DLV_TO_TASK_ROLLUP_PVT;
21370: END IF;
21371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21372: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
21373: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
21374: p_error_text => SUBSTRB(SQLERRM,1,120));
21375: WHEN OTHERS THEN
21376: IF p_commit = FND_API.G_TRUE THEN

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

21376: IF p_commit = FND_API.G_TRUE THEN
21377: rollback to ASGN_DLV_TO_TASK_ROLLUP_PVT;
21378: END IF;
21379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
21380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
21381: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
21382: p_error_text => SUBSTRB(SQLERRM,1,120));
21383: raise;
21384: END ASGN_DLV_TO_TASK_ROLLUP_PVT;

Line 21617: FND_MSG_PUB.initialize;

21613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
21614: END IF;
21615:
21616: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
21617: FND_MSG_PUB.initialize;
21618: END IF;
21619:
21620: IF g1_debug_mode = 'Y' THEN
21621: 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 22293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',

22289:
22290:
22291: EXCEPTION
22292: WHEN OTHERS THEN
22293: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22294: p_procedure_name => 'COPY_PROGRESS_ACT_ETC',
22295: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
22296: RAISE FND_API.G_EXC_ERROR;
22297: END;

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

22357: if p_commit = FND_API.G_TRUE then
22358: rollback to COPY_PROGRESS_ACT_ETC;
22359: end if;
22360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22361: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22362: p_procedure_name => 'COPY_PROGRESS_ACT_ETC',
22363: p_error_text => SUBSTRB(SQLERRM,1,120));
22364: when OTHERS then
22365: if p_commit = FND_API.G_TRUE then

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

22365: if p_commit = FND_API.G_TRUE then
22366: rollback to COPY_PROGRESS_ACT_ETC;
22367: end if;
22368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22369: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22370: p_procedure_name => 'COPY_PROGRESS_ACT_ETC',
22371: p_error_text => SUBSTRB(SQLERRM,1,120));
22372: raise;
22373:

Line 22482: FND_MSG_PUB.initialize;

22478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
22479: END IF;
22480:
22481: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
22482: FND_MSG_PUB.initialize;
22483: END IF;
22484:
22485: x_return_status := FND_API.G_RET_STS_SUCCESS;
22486:

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

22538: if p_commit = FND_API.G_TRUE then
22539: rollback to UPDATE_LINK_PROJ_ROLLUP_DATES;
22540: end if;
22541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22542: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22543: p_procedure_name => 'UPDATE_LINK_PROJ_ROLLUP_DATES',
22544: p_error_text => SUBSTRB(SQLERRM,1,120));
22545: when OTHERS then
22546: if p_commit = FND_API.G_TRUE then

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

22546: if p_commit = FND_API.G_TRUE then
22547: rollback to UPDATE_LINK_PROJ_ROLLUP_DATES;
22548: end if;
22549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
22550: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
22551: p_procedure_name => 'UPDATE_LINK_PROJ_ROLLUP_DATES',
22552: p_error_text => SUBSTRB(SQLERRM,1,120));
22553: raise;
22554: END update_link_proj_rollup_dates;

Line 22748: FND_MSG_PUB.initialize;

22744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
22745: END IF;
22746:
22747: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
22748: FND_MSG_PUB.initialize;
22749: END IF;
22750:
22751: x_return_status := FND_API.G_RET_STS_SUCCESS;
22752:

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

23448: Pa_Task_Pub1.G_CALL_PJI_ROLLUP := null ;
23449: 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);
23450: EXCEPTION
23451: WHEN OTHERS THEN
23452: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
23453: p_procedure_name => 'UPDATE_PROGRESS_BULK',
23454: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
23455: RAISE FND_API.G_EXC_ERROR;
23456: END;

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

23480: END IF;
23481:
23482: EXCEPTION
23483: WHEN OTHERS THEN
23484: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
23485: p_procedure_name => 'UPDATE_PROGRESS_BULK',
23486: p_error_text => SUBSTRB('Call PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE:'||SQLERRM,1,120));
23487: RAISE FND_API.G_EXC_ERROR;
23488: END;

Line 23813: x_msg_count := fnd_msg_pub.count_msg;

23809: -- if p_commit = FND_API.G_TRUE then
23810: rollback to UPDATE_PROGRESS_BULK;
23811: -- end if;
23812: x_return_status := FND_API.G_RET_STS_ERROR;
23813: x_msg_count := fnd_msg_pub.count_msg;
23814: when FND_API.G_EXC_UNEXPECTED_ERROR then
23815: -- if p_commit = FND_API.G_TRUE then
23816: rollback to UPDATE_PROGRESS_BULK;
23817: -- end if;

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

23815: -- if p_commit = FND_API.G_TRUE then
23816: rollback to UPDATE_PROGRESS_BULK;
23817: -- end if;
23818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
23819: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
23820: p_procedure_name => 'UPDATE_PROGRESS_BULK',
23821: p_error_text => SUBSTRB(SQLERRM,1,120));
23822: x_msg_count := fnd_msg_pub.count_msg;
23823: when OTHERS then

Line 23822: x_msg_count := fnd_msg_pub.count_msg;

23818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
23819: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
23820: p_procedure_name => 'UPDATE_PROGRESS_BULK',
23821: p_error_text => SUBSTRB(SQLERRM,1,120));
23822: x_msg_count := fnd_msg_pub.count_msg;
23823: when OTHERS then
23824: -- if p_commit = FND_API.G_TRUE then
23825: rollback to UPDATE_PROGRESS_BULK;
23826: -- end if;

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

23824: -- if p_commit = FND_API.G_TRUE then
23825: rollback to UPDATE_PROGRESS_BULK;
23826: -- end if;
23827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
23828: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
23829: p_procedure_name => 'UPDATE_PROGRESS_BULK',
23830: p_error_text => SUBSTRB(SQLERRM,1,120));
23831: x_msg_count := fnd_msg_pub.count_msg;
23832: raise;

Line 23831: x_msg_count := fnd_msg_pub.count_msg;

23827: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
23828: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
23829: p_procedure_name => 'UPDATE_PROGRESS_BULK',
23830: p_error_text => SUBSTRB(SQLERRM,1,120));
23831: x_msg_count := fnd_msg_pub.count_msg;
23832: raise;
23833: END update_progress_bulk;
23834:
23835: -- Bug 3994165 : Removing POPULATE_PRG_ACT_TEMP_TBL and POPULATE_PRG_ACT_TBL_SINGLE

Line 23884: FND_MSG_PUB.initialize;

23880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
23881: END IF;
23882:
23883: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
23884: FND_MSG_PUB.initialize;
23885: END IF;
23886:
23887: x_return_status := FND_API.G_RET_STS_SUCCESS;
23888:

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

23959: if p_commit = FND_API.G_TRUE then
23960: rollback to APPLY_LP_PROG_ON_CWV_WRP;
23961: end if;
23962: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
23963: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
23964: p_procedure_name => 'APPLY_LP_PROG_ON_CWV_WRP',
23965: p_error_text => SUBSTRB(SQLERRM,1,120));
23966: when OTHERS then
23967: if p_commit = FND_API.G_TRUE then

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

23967: if p_commit = FND_API.G_TRUE then
23968: rollback to APPLY_LP_PROG_ON_CWV;
23969: end if;
23970: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
23971: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
23972: p_procedure_name => 'APPLY_LP_PROG_ON_CWV_WRP',
23973: p_error_text => SUBSTRB(SQLERRM,1,120));
23974: raise;
23975: END APPLY_LP_PROG_ON_CWV_WRP;