DBA Data[Home] [Help]

APPS.PA_PROGRESS_PVT dependencies on FND_MSG_PUB

Line 1487: FND_MSG_PUB.initialize;

1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1484: END IF;
1485:
1486: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
1487: FND_MSG_PUB.initialize;
1488: END IF;
1489:
1490: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
1491: l_track_wp_cost_flag := pa_fp_wp_gen_amt_utils.get_wp_track_cost_amt_flag(p_project_id); --bug 3830434

Line 2750: x_msg_count := fnd_msg_pub.count_msg;

2746: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
2747: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
2748: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
2749: x_return_status := 'E';
2750: x_msg_count := fnd_msg_pub.count_msg;
2751: RAISE FND_API.G_EXC_ERROR;
2752: END ;
2753:
2754: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PROGRESS_PVT', x_Msg => 'After Getting Periods', x_Log_Level=> 3);

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

3037: EXCEPTION
3038: WHEN NO_DATA_FOUND THEN
3039: null;
3040: WHEN OTHERS THEN
3041: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
3042: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
3043: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_TMP1 Failed:'||SQLERRM,1,120));
3044: RAISE FND_API.G_EXC_ERROR;
3045: END;

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

4015: --IF p_commit = FND_API.G_TRUE THEN
4016: rollback to ROLLUP_PROGRESS_PVT2;
4017: --END IF;
4018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4019: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
4020: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
4021: p_error_text => SUBSTRB(SQLERRM,1,120));
4022: WHEN OTHERS THEN
4023: --BUG 4355204

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

4024: --IF p_commit = FND_API.G_TRUE THEN
4025: rollback to ROLLUP_PROGRESS_PVT2;
4026: --END IF;
4027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4028: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
4029: p_procedure_name => 'ROLLUP_PROGRESS_PVT',
4030: p_error_text => SUBSTRB(SQLERRM,1,120));
4031: raise;
4032: END ROLLUP_PROGRESS_PVT;

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

4120: IF p_commit = FND_API.G_TRUE THEN
4121: rollback to UPDATE_ROLLUP_PROGRESS_PVT2;
4122: END IF;
4123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4124: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
4125: p_procedure_name => 'UPDATE_ROLLUP_PROGRESS_PVT',
4126: p_error_text => SUBSTRB(SQLERRM,1,120));
4127: WHEN OTHERS THEN
4128: IF g1_debug_mode = 'Y' THEN

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

4132: IF p_commit = FND_API.G_TRUE THEN
4133: rollback to UPDATE_ROLLUP_PROGRESS_PVT2;
4134: END IF;
4135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4136: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
4137: p_procedure_name => 'UPDATE_ROLLUP_PROGRESS_PVT',
4138: p_error_text => SUBSTRB(SQLERRM,1,120));
4139: raise;
4140: END UPDATE_ROLLUP_PROGRESS_PVT;

Line 4342: l_msg_count := Fnd_Msg_Pub.count_msg;

4338: -- 4537865 : Start
4339: when FND_API.G_EXC_ERROR then
4340: x_return_status := FND_API.G_RET_STS_ERROR;
4341:
4342: l_msg_count := Fnd_Msg_Pub.count_msg;
4343:
4344: IF l_msg_count = 1 AND x_msg_data IS NULL
4345: THEN
4346: Pa_Interface_Utils_Pub.get_messages

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

4358: WHEN OTHERS THEN
4359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4360: x_msg_count := 1 ; -- 4537865
4361: x_msg_data := SUBSTRB(SQLERRM,1,120); -- 4537865
4362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
4363: p_procedure_name => 'ROLLUP_FUTURE_PROGRESS_PVT',
4364: p_error_text => SUBSTRB(SQLERRM,1,120));
4365: raise;
4366: END ROLLUP_FUTURE_PROGRESS_PVT;

Line 4620: FND_MSG_PUB.initialize;

4616: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4617: END IF;
4618:
4619: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
4620: FND_MSG_PUB.initialize;
4621: END IF;
4622:
4623: x_return_status := FND_API.G_RET_STS_SUCCESS;
4624:

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

4761: p_plan_type_id => -1,
4762: p_proj_str_ver_id => l_c1rec.parent_structure_ver_id) ;
4763: EXCEPTION
4764: WHEN OTHERS THEN
4765: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
4766: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
4767: p_error_text => SUBSTRB('Call of PA_FP_WP_GEN_AMT_UTILS.GET_WP_VERSION_ID Failed: SQLERRM'||SQLERRM,1,120));
4768: RAISE FND_API.G_EXC_ERROR;
4769: END;

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

5094: EXCEPTION
5095: WHEN NO_DATA_FOUND THEN
5096: null;
5097: WHEN OTHERS THEN
5098: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
5099: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
5100: p_error_text => SUBSTRB('Select from PJI_FM_XBS_ACCUM_TMP1 Failed: SQLERRM'||SQLERRM,1,120));
5101: RAISE FND_API.G_EXC_ERROR;
5102: END;

Line 5242: IF Fnd_Msg_Pub.count_msg > 0 THEN

5238: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => null
5239: );
5240:
5241: -- FPM Dev CR 6
5242: IF Fnd_Msg_Pub.count_msg > 0 THEN
5243: RAISE FND_API.G_EXC_ERROR;
5244: END IF;
5245: ELSE -- IF l_mode = 'U' THEN
5246: BEGIN

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

5520: if p_commit = FND_API.G_TRUE then
5521: rollback to PROGRAM_ROLLUP_PVT2;
5522: end if;
5523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5524: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
5525: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
5526: p_error_text => SUBSTRB(SQLERRM,1,120));
5527: when OTHERS then
5528: if p_commit = FND_API.G_TRUE then

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

5528: if p_commit = FND_API.G_TRUE then
5529: rollback to PROGRAM_ROLLUP_PVT2;
5530: end if;
5531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5532: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
5533: p_procedure_name => 'PROGRAM_ROLLUP_PVT',
5534: p_error_text => SUBSTRB(SQLERRM,1,120));
5535: raise;
5536: END program_rollup_pvt;

Line 6952: FND_MSG_PUB.initialize;

6948: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6949: END IF;
6950:
6951: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
6952: FND_MSG_PUB.initialize;
6953: END IF;
6954:
6955: l_sharing_Enabled := PA_PROJECT_STRUCTURE_UTILS.check_sharing_enabled(p_project_id);
6956: l_structure_sharing_code := PA_PROJECT_STRUCTURE_UTILS.get_Structure_sharing_code(p_project_id);

Line 8016: x_msg_count := fnd_msg_pub.count_msg;

8012: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
8013: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
8014: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
8015: x_return_status := 'E';
8016: x_msg_count := fnd_msg_pub.count_msg;
8017: RAISE FND_API.G_EXC_ERROR;
8018: END ;
8019:
8020: 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 8504: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',

8500: EXCEPTION
8501: WHEN NO_DATA_FOUND THEN
8502: null;
8503: WHEN OTHERS THEN
8504: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
8505: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
8506: p_error_text => SUBSTRB('PJI_FM_XBS_ACCUM_TMP1:'||SQLERRM,1,120));
8507: RAISE FND_API.G_EXC_ERROR;
8508: END;

Line 8715: IF Fnd_Msg_Pub.count_msg > 0 THEN

8711: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_FC => l_cur_rollup_rec.SUBPRJ_EQPMT_ETC_RAWCOST_FC
8712: ,X_SUBPRJ_EQPMT_ETC_RAWCOST_PC => l_cur_rollup_rec.SUBPRJ_EQPMT_ETC_RAWCOST_PC
8713: );
8714: -- FPM Dev CR 6
8715: IF Fnd_Msg_Pub.count_msg > 0 THEN
8716: RAISE FND_API.G_EXC_ERROR;
8717: END IF;
8718:
8719: --update progress_outdated_flag for summary tasks if there exists any ppc record

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

8985: RAISE FND_API.G_EXC_ERROR;
8986: END IF;
8987: EXCEPTION
8988: WHEN OTHERS THEN
8989: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
8990: p_procedure_name => 'update_ASGN_DLV_TO_TASK_ROLLUP_PVT',
8991: p_error_text => SUBSTRB('PA_FP_MAINTAIN_ACTUAL_PUB.MAINTAIN_ACTUAL_AMT_WRP:'||SQLERRM,1,120));
8992: RAISE FND_API.G_EXC_ERROR;
8993: END;

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

9026: IF p_commit = FND_API.G_TRUE THEN
9027: rollback to ASGN_DLV_TO_TASK_ROLLUP_PVT2;
9028: END IF;
9029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9030: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
9031: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
9032: p_error_text => SUBSTRB(SQLERRM,1,120));
9033: WHEN OTHERS THEN
9034: IF p_commit = FND_API.G_TRUE THEN

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

9034: IF p_commit = FND_API.G_TRUE THEN
9035: rollback to ASGN_DLV_TO_TASK_ROLLUP_PVT2;
9036: END IF;
9037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9038: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
9039: p_procedure_name => 'ASGN_DLV_TO_TASK_ROLLUP_PVT',
9040: p_error_text => SUBSTRB(SQLERRM,1,120));
9041: raise;
9042: END ASGN_DLV_TO_TASK_ROLLUP_PVT;

Line 9214: FND_MSG_PUB.initialize;

9210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
9211: END IF;
9212:
9213: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
9214: FND_MSG_PUB.initialize;
9215: END IF;
9216:
9217: IF g1_debug_mode = 'Y' THEN
9218:

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

9693: IF p_commit = FND_API.G_TRUE THEN
9694: rollback to convert_task_prog_to_assgn;
9695: END IF;
9696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9697: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
9698: p_procedure_name => 'convert_task_prog_to_assgn',
9699: p_error_text => SUBSTRB(SQLERRM,1,120));
9700: WHEN OTHERS THEN
9701: IF p_commit = FND_API.G_TRUE THEN

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

9701: IF p_commit = FND_API.G_TRUE THEN
9702: rollback to ASGN_DLV_TO_TASK_ROLLUP_PVT2;
9703: END IF;
9704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9705: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
9706: p_procedure_name => 'convert_task_prog_to_assgn',
9707: p_error_text => SUBSTRB(SQLERRM,1,120));
9708: raise;
9709:

Line 10183: l_msg_count := FND_MSG_PUB.count_msg;

10179:
10180: EXCEPTION
10181:
10182: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10183: l_msg_count := FND_MSG_PUB.count_msg;
10184: IF l_msg_count = 1 THEN
10185: PA_INTERFACE_UTILS_PUB.get_messages
10186: (p_encoded => FND_API.G_TRUE
10187: ,p_msg_index => 1

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

10210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10211: x_msg_count := 1;
10212: x_msg_data := SQLERRM;
10213:
10214: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_fp_copy_from_pkg'
10215: ,p_procedure_name => 'copy_actuals_for_workplan');
10216:
10217: IF l_debug_mode = 'Y' THEN
10218: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.copy_actuals_for_workplan', x_Msg => 'Unexpected Error'||SQLERRM, x_Log_Level=> 3);

Line 10360: FND_MSG_PUB.initialize;

10356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10357: END IF;
10358:
10359: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
10360: FND_MSG_PUB.initialize;
10361: END IF;
10362:
10363: x_return_status := FND_API.G_RET_STS_SUCCESS;
10364:

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

10432: if p_commit = FND_API.G_TRUE then
10433: rollback to rollup_prog_from_subprojs2;
10434: end if;
10435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10436: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
10437: p_procedure_name => 'ROLLUP_PROG_FROM_SUBPROJS',
10438: p_error_text => SUBSTRB(SQLERRM,1,120));
10439: when OTHERS then
10440: if p_commit = FND_API.G_TRUE then

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

10440: if p_commit = FND_API.G_TRUE then
10441: rollback to rollup_prog_from_subprojs2;
10442: end if;
10443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10444: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
10445: p_procedure_name => 'ROLLUP_PROG_FROM_SUBPROJS',
10446: p_error_text => SUBSTRB(SQLERRM,1,120));
10447: raise;
10448: END ROLLUP_PROG_FROM_SUBPROJS;

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

10532:
10533: exception
10534: when FND_API.G_EXC_ERROR then
10535: x_return_status := 'E';
10536: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
10537: p_procedure_name => 'UPD_PROG_RECS_STR_DELETE',
10538: p_error_text => 'This workplan structure cannot be deleted.');
10539:
10540: when OTHERS then

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

10538: p_error_text => 'This workplan structure cannot be deleted.');
10539:
10540: when OTHERS then
10541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10542: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
10543: p_procedure_name => 'UPD_PROG_RECS_STR_DELETE',
10544: p_error_text => SUBSTRB(SQLERRM,1,120));
10545: raise;
10546:

Line 11780: FND_MSG_PUB.initialize;

11776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
11777: END IF;
11778:
11779: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
11780: FND_MSG_PUB.initialize;
11781: END IF;
11782:
11783: PA_PROGRESS_PUB.POPULATE_PJI_TAB_FOR_PLAN(
11784: p_calling_module => 'AMG'

Line 12982: x_msg_count := fnd_msg_pub.count_msg;

12978: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
12979: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
12980: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
12981: x_return_status := 'E';
12982: x_msg_count := fnd_msg_pub.count_msg;
12983: RAISE FND_API.G_EXC_ERROR;
12984: END ;
12985:
12986: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'After Getting Periods', x_Log_Level=> 3);

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

13256: EXCEPTION
13257: WHEN NO_DATA_FOUND THEN
13258: null;
13259: WHEN OTHERS THEN
13260: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
13261: p_procedure_name => 'ROLLUP_PVT',
13262: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_TMP1 Failed:'||SQLERRM,1,120));
13263: RAISE FND_API.G_EXC_ERROR;
13264: END;

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

14089: x_return_status := FND_API.G_RET_STS_ERROR;
14090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
14091: rollback to ROLLUP_PVT2;
14092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14093: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
14094: p_procedure_name => 'ROLLUP_PVT',
14095: p_error_text => SUBSTRB(SQLERRM,1,120));
14096: WHEN OTHERS THEN
14097: rollback to ROLLUP_PVT2;

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

14095: p_error_text => SUBSTRB(SQLERRM,1,120));
14096: WHEN OTHERS THEN
14097: rollback to ROLLUP_PVT2;
14098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
14099: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
14100: p_procedure_name => 'ROLLUP_PVT',
14101: p_error_text => SUBSTRB(SQLERRM,1,120));
14102: raise;
14103: END ROLLUP_PVT;

Line 15350: FND_MSG_PUB.initialize;

15346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
15347: END IF;
15348:
15349: IF FND_API.TO_BOOLEAN(nvl(p_init_msg_list,FND_API.G_FALSE)) THEN
15350: FND_MSG_PUB.initialize;
15351: END IF;
15352:
15353: /* sridhar_rollup
15354: PA_PROGRESS_PUB.POPULATE_PJI_TAB_FOR_PLAN(

Line 16569: x_msg_count := fnd_msg_pub.count_msg;

16565: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
16566: p_msg_name => 'PA_FP_INVALID_DATE_RANGE');
16567: x_msg_data := 'PA_FP_INVALID_DATE_RANGE';
16568: x_return_status := 'E';
16569: x_msg_count := fnd_msg_pub.count_msg;
16570: RAISE FND_API.G_EXC_ERROR;
16571: END ;
16572:
16573: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.ROLLUP_PVT', x_Msg => 'After Getting Periods', x_Log_Level=> 3);

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

16868: EXCEPTION
16869: WHEN NO_DATA_FOUND THEN
16870: null;
16871: WHEN OTHERS THEN
16872: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
16873: p_procedure_name => 'ROLLUP_PVT',
16874: p_error_text => SUBSTRB('Call of PJI_FM_XBS_ACCUM_TMP1 Failed:'||SQLERRM,1,120));
16875: RAISE FND_API.G_EXC_ERROR;
16876: END;

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

17721: x_return_status := FND_API.G_RET_STS_ERROR;
17722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
17723: rollback to ROLLUP_PVT2;
17724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17725: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
17726: p_procedure_name => 'ROLLUP_PVT',
17727: p_error_text => SUBSTRB(SQLERRM,1,120));
17728: WHEN OTHERS THEN
17729: rollback to ROLLUP_PVT2;

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

17727: p_error_text => SUBSTRB(SQLERRM,1,120));
17728: WHEN OTHERS THEN
17729: rollback to ROLLUP_PVT2;
17730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
17731: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PVT',
17732: p_procedure_name => 'ROLLUP_PVT',
17733: p_error_text => SUBSTRB(SQLERRM,1,120));
17734: raise;
17735: END DEFER_ROLLUP_PVT;