DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on FND_MSG_PUB

Line 1478: FND_MSG_PUB.initialize;

1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1475: END IF;
1476:
1477: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1478: FND_MSG_PUB.initialize;
1479: END IF;
1480:
1481: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
1482: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --bug 3830434

Line 2707: x_msg_count := fnd_msg_pub.count_msg;

2703: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2704: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
2705: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
2706: x_return_status := 'E';
2707: x_msg_count := fnd_msg_pub.count_msg;
2708: RAISE FND_API.G_EXC_ERROR;
2709: END ;
2710:
2711: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'After Getting Periods', x_Log_Level=> 3);

Line 2998: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

2994: EXCEPTION
2995: WHEN NO_DATA_FOUND THEN
2996: null;
2997: WHEN OTHERS THEN
2998: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
2999: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
3000: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_TMP1 Failed:'||SQLERRM,1,120));
3001: RAISE FND_API.G_EXC_ERROR;
3002: END;

Line 3976: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

3972: --IF p_commit = FND_API.G_TRUE THEN
3973: rollback to ROLLUP_PROGRESS_PVT2;
3974: --END IF;
3975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3976: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
3977: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
3978: p_error_text => SUBSTRB(SQLERRM,1,120));
3979: WHEN OTHERS THEN
3980: --BUG 4355204

Line 3985: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

3981: --IF p_commit = FND_API.G_TRUE THEN
3982: rollback to ROLLUP_PROGRESS_PVT2;
3983: --END IF;
3984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3985: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
3986: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
3987: p_error_text => SUBSTRB(SQLERRM,1,120));
3988: raise;
3989: END ROLLUP_PROGRESS_PVT;

Line 4081: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

4077: IF p_commit = FND_API.G_TRUE THEN
4078: rollback to UPDATE_ROLLUP_PROGRESS_PVT2;
4079: END IF;
4080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4081: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
4082: p_procedure_name => 'UPDATE_ROLLUP_PROGRESS_PVT',
4083: p_error_text => SUBSTRB(SQLERRM,1,120));
4084: WHEN OTHERS THEN
4085: IF g1_debug_mode = 'Y' THEN

Line 4093: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

4089: IF p_commit = FND_API.G_TRUE THEN
4090: rollback to UPDATE_ROLLUP_PROGRESS_PVT2;
4091: END IF;
4092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4093: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
4094: p_procedure_name => 'UPDATE_ROLLUP_PROGRESS_PVT',
4095: p_error_text => SUBSTRB(SQLERRM,1,120));
4096: raise;
4097: END UPDATE_ROLLUP_PROGRESS_PVT;

Line 4299: l_msg_count := Fnd_Msg_Pub.count_msg;

4295: -- 4537865 : Start
4296: when FND_API.G_EXC_ERROR then
4297: x_return_status := FND_API.G_RET_STS_ERROR;
4298:
4299: l_msg_count := Fnd_Msg_Pub.count_msg;
4300:
4301: IF l_msg_count = 1 AND x_msg_data IS NULL
4302: THEN
4303: Pa_Interface_Utils_Pub.get_messages

Line 4319: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

4315: WHEN OTHERS THEN
4316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4317: x_msg_count := 1 ; -- 4537865
4318: x_msg_data := SUBSTRB(SQLERRM,1,120); -- 4537865
4319: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
4320: p_procedure_name => 'ROLLUP_FUTURE_PROGRESS_PVT',
4321: p_error_text => SUBSTRB(SQLERRM,1,120));
4322: raise;
4323: END ROLLUP_FUTURE_PROGRESS_PVT;

Line 4567: FND_MSG_PUB.initialize;

4563: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4564: END IF;
4565:
4566: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4567: FND_MSG_PUB.initialize;
4568: END IF;
4569:
4570: x_return_status := FND_API.G_RET_STS_SUCCESS;
4571:

Line 4699: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

4695: p_plan_type_id => -1,
4696: p_proj_str_ver_id => l_c1rec.parent_structure_ver_id) ;
4697: EXCEPTION
4698: WHEN OTHERS THEN
4699: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
4700: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
4701: p_error_text => SUBSTRB('Call of PA_FP_WP_GEN_AMT_UTILS.GET_WP_VERSION_ID Failed: SQLERRM'||SQLERRM,1,120));
4702: RAISE FND_API.G_EXC_ERROR;
4703: END;

Line 5032: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

5028: EXCEPTION
5029: WHEN NO_DATA_FOUND THEN
5030: null;
5031: WHEN OTHERS THEN
5032: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
5033: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
5034: p_error_text => SUBSTRB('Select from PJI_FM_XBS_ACCUM_TMP1 Failed: SQLERRM'||SQLERRM,1,120));
5035: RAISE FND_API.G_EXC_ERROR;
5036: END;

Line 5176: IF Fnd_Msg_Pub.count_msg > 0 THEN

5172: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
5173: );
5174:
5175: -- FPM Dev CR 6
5176: IF Fnd_Msg_Pub.count_msg > 0 THEN
5177: RAISE FND_API.G_EXC_ERROR;
5178: END IF;
5179: ELSE -- IF l_mode = 'U' THEN
5180: BEGIN

Line 5458: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

5454: if p_commit = FND_API.G_TRUE then
5455: rollback to PROGRAM_ROLLUP_PVT2;
5456: end if;
5457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5458: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
5459: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
5460: p_error_text => SUBSTRB(SQLERRM,1,120));
5461: when OTHERS then
5462: if p_commit = FND_API.G_TRUE then

Line 5466: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

5462: if p_commit = FND_API.G_TRUE then
5463: rollback to PROGRAM_ROLLUP_PVT2;
5464: end if;
5465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5466: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
5467: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
5468: p_error_text => SUBSTRB(SQLERRM,1,120));
5469: raise;
5470: END program_rollup_pvt;

Line 6886: FND_MSG_PUB.initialize;

6882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6883: END IF;
6884:
6885: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
6886: FND_MSG_PUB.initialize;
6887: END IF;
6888:
6889: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
6890: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);

Line 7950: x_msg_count := fnd_msg_pub.count_msg;

7946: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
7947: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
7948: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
7949: x_return_status := 'E';
7950: x_msg_count := fnd_msg_pub.count_msg;
7951: RAISE FND_API.G_EXC_ERROR;
7952: END ;
7953:
7954: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.UPDATE_ASGN_DLV_TO_TASK_ROLLUP_PVT', x_Msg => 'After Getting Periods', x_Log_Level=> 3);

Line 8438: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

8434: EXCEPTION
8435: WHEN NO_DATA_FOUND THEN
8436: null;
8437: WHEN OTHERS THEN
8438: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
8439: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
8440: p_error_text => SUBSTRB('PJI_FM_XBS_ACCUM_TMP1:'||SQLERRM,1,120));
8441: RAISE FND_API.G_EXC_ERROR;
8442: END;

Line 8649: IF Fnd_Msg_Pub.count_msg > 0 THEN

8645: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => l_cur_rollup_rec.SUBPRJ_EQPMT_ETC_RAWCOST_FC
8646: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => l_cur_rollup_rec.SUBPRJ_EQPMT_ETC_RAWCOST_PC
8647: );
8648: -- FPM Dev CR 6
8649: IF Fnd_Msg_Pub.count_msg > 0 THEN
8650: RAISE FND_API.G_EXC_ERROR;
8651: END IF;
8652:
8653: --update progress_outdated_flag for summary tasks if there exists any ppc record

Line 8923: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

8919: RAISE FND_API.G_EXC_ERROR;
8920: END IF;
8921: EXCEPTION
8922: WHEN OTHERS THEN
8923: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
8924: p_procedure_name => 'update_ASGN_DLV_TO_TASK_ROLLUP_PVT',
8925: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
8926: RAISE FND_API.G_EXC_ERROR;
8927: END;

Line 8964: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

8960: IF p_commit = FND_API.G_TRUE THEN
8961: rollback to ASGN_DLV_TO_TASK_ROLLUP_PVT2;
8962: END IF;
8963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8964: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
8965: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
8966: p_error_text => SUBSTRB(SQLERRM,1,120));
8967: WHEN OTHERS THEN
8968: IF p_commit = FND_API.G_TRUE THEN

Line 8972: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

8968: IF p_commit = FND_API.G_TRUE THEN
8969: rollback to ASGN_DLV_TO_TASK_ROLLUP_PVT2;
8970: END IF;
8971: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8972: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
8973: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
8974: p_error_text => SUBSTRB(SQLERRM,1,120));
8975: raise;
8976: END ASGN_DLV_TO_TASK_ROLLUP_PVT;

Line 9148: FND_MSG_PUB.initialize;

9144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9145: END IF;
9146:
9147: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
9148: FND_MSG_PUB.initialize;
9149: END IF;
9150:
9151: IF g1_debug_mode = 'Y' THEN
9152:

Line 9631: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

9627: IF p_commit = FND_API.G_TRUE THEN
9628: rollback to convert_task_prog_to_assgn;
9629: END IF;
9630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9631: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
9632: p_procedure_name => 'convert_task_prog_to_assgn',
9633: p_error_text => SUBSTRB(SQLERRM,1,120));
9634: WHEN OTHERS THEN
9635: IF p_commit = FND_API.G_TRUE THEN

Line 9639: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

9635: IF p_commit = FND_API.G_TRUE THEN
9636: rollback to ASGN_DLV_TO_TASK_ROLLUP_PVT2;
9637: END IF;
9638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9639: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
9640: p_procedure_name => 'convert_task_prog_to_assgn',
9641: p_error_text => SUBSTRB(SQLERRM,1,120));
9642: raise;
9643:

Line 10115: l_msg_count := FND_MSG_PUB.count_msg;

10111:
10112: EXCEPTION
10113:
10114: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10115: l_msg_count := FND_MSG_PUB.count_msg;
10116: IF l_msg_count = 1 THEN
10117: PA_INTERFACE_UTILS_PUB.get_messages
10118: (p_encoded => FND_API.G_TRUE
10119: ,p_msg_index => 1

Line 10146: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'

10142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10143: x_msg_count := 1;
10144: x_msg_data := SQLERRM;
10145:
10146: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'
10147: ,p_procedure_name => 'copy_actuals_for_workplan');
10148:
10149: IF l_debug_mode = 'Y' THEN
10150: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.copy_actuals_for_workplan', x_Msg => 'Unexpected Error'||SQLERRM, x_Log_Level=> 3);

Line 10244: FND_MSG_PUB.initialize;

10240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10241: END IF;
10242:
10243: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
10244: FND_MSG_PUB.initialize;
10245: END IF;
10246:
10247: x_return_status := FND_API.G_RET_STS_SUCCESS;
10248:

Line 10320: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

10316: if p_commit = FND_API.G_TRUE then
10317: rollback to rollup_prog_from_subprojs2;
10318: end if;
10319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10320: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
10321: p_procedure_name => 'ROLLUP_PROG_FROM_SUBPROJS',
10322: p_error_text => SUBSTRB(SQLERRM,1,120));
10323: when OTHERS then
10324: if p_commit = FND_API.G_TRUE then

Line 10328: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

10324: if p_commit = FND_API.G_TRUE then
10325: rollback to rollup_prog_from_subprojs2;
10326: end if;
10327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10328: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
10329: p_procedure_name => 'ROLLUP_PROG_FROM_SUBPROJS',
10330: p_error_text => SUBSTRB(SQLERRM,1,120));
10331: raise;
10332: END ROLLUP_PROG_FROM_SUBPROJS;

Line 10420: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

10416:
10417: exception
10418: when FND_API.G_EXC_ERROR then
10419: x_return_status := 'E';
10420: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
10421: p_procedure_name => 'UPD_PROG_RECS_STR_DELETE',
10422: p_error_text => 'This workplan structure cannot be deleted.');
10423:
10424: when OTHERS then

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

10422: p_error_text => 'This workplan structure cannot be deleted.');
10423:
10424: when OTHERS then
10425: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10426: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
10427: p_procedure_name => 'UPD_PROG_RECS_STR_DELETE',
10428: p_error_text => SUBSTRB(SQLERRM,1,120));
10429: raise;
10430: