DBA Data[Home] [Help]

APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on FND_MSG_PUB

Line 828: x_msg_count := FND_MSG_PUB.count_msg;

824: END IF;
825:
826:
827: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
828: x_msg_count := FND_MSG_PUB.count_msg;
829: if x_msg_count = 1 then
830: x_msg_data := x_msg_data;
831: end if;
832: raise FND_API.G_EXC_ERROR;

Line 864: x_msg_count := FND_MSG_PUB.count_msg;

860: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.Rollup_From_Subproject_Unltd', 'After calling PA_PROJECT_DATES_PUB.COPY_PROJECT_DATESx_return_status='||x_return_status, 3);
861: END IF;
862:
863: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
864: x_msg_count := FND_MSG_PUB.count_msg;
865: if x_msg_count = 1 then
866: x_msg_data := x_msg_data;
867: end if;
868: raise FND_API.G_EXC_ERROR;

Line 884: x_msg_count := FND_MSG_PUB.count_msg;

880: WHEN excp_resource_busy THEN -- Bug 6719725
881: IF (p_commit = FND_API.G_TRUE) THEN
882: ROLLBACK to Rollup_From_Subproject_PVT;
883: END IF;
884: x_msg_count := FND_MSG_PUB.count_msg;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886:
887: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
888: p_procedure_name => 'Rollup_From_Subproject',

Line 887: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',

883: END IF;
884: x_msg_count := FND_MSG_PUB.count_msg;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886:
887: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
888: p_procedure_name => 'Rollup_From_Subproject',
889: p_error_text => 'The Strucuture of one of the project in program hierarchy is currently being updated by another process. Please re-submit the process update after sometime.');
890:
891: RAISE;

Line 896: x_msg_count := FND_MSG_PUB.count_msg;

892: WHEN FND_API.G_EXC_ERROR THEN
893: IF (p_commit = FND_API.G_TRUE) THEN
894: ROLLBACK to Rollup_From_Subproject_PVT;
895: END IF;
896: x_msg_count := FND_MSG_PUB.count_msg;
897: x_return_status := FND_API.G_RET_STS_ERROR;
898: WHEN OTHERS THEN
899: IF (p_commit = FND_API.G_TRUE) THEN
900: ROLLBACK to Rollup_From_Subproject_PVT;

Line 903: x_msg_count := FND_MSG_PUB.count_msg;

899: IF (p_commit = FND_API.G_TRUE) THEN
900: ROLLBACK to Rollup_From_Subproject_PVT;
901: END IF;
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: x_msg_count := FND_MSG_PUB.count_msg;
904: --put message
905: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
906: p_procedure_name => 'Rollup_From_Subproject_Unltd',
907: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 905: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',

901: END IF;
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
903: x_msg_count := FND_MSG_PUB.count_msg;
904: --put message
905: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
906: p_procedure_name => 'Rollup_From_Subproject_Unltd',
907: p_error_text => SUBSTRB(SQLERRM,1,240));
908: RAISE;
909: END Rollup_From_Subproject_Unltd;

Line 1105: x_msg_count := FND_MSG_PUB.count_msg;

1101: WHEN FND_API.G_EXC_ERROR THEN
1102: IF (p_commit = FND_API.G_TRUE) THEN
1103: ROLLBACK to TASKS_ROLLUP_UNLIMITED_PUB;
1104: END IF;
1105: x_msg_count := FND_MSG_PUB.count_msg;
1106: x_return_status := FND_API.G_RET_STS_ERROR;
1107: WHEN OTHERS THEN
1108: IF (p_commit = FND_API.G_TRUE) THEN
1109: ROLLBACK to TASKS_ROLLUP_UNLIMITED_PUB;

Line 1112: x_msg_count := FND_MSG_PUB.count_msg;

1108: IF (p_commit = FND_API.G_TRUE) THEN
1109: ROLLBACK to TASKS_ROLLUP_UNLIMITED_PUB;
1110: END IF;
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112: x_msg_count := FND_MSG_PUB.count_msg;
1113: --put message
1114: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
1115: p_procedure_name => 'Tasks_Rollup_Unlimited',
1116: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 1114: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',

1110: END IF;
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1112: x_msg_count := FND_MSG_PUB.count_msg;
1113: --put message
1114: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
1115: p_procedure_name => 'Tasks_Rollup_Unlimited',
1116: p_error_text => SUBSTRB(SQLERRM,1,240));
1117: RAISE;
1118:

Line 1874: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',

1870: END IF;
1871:
1872: EXCEPTION
1873: WHEN OTHERS THEN
1874: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
1875: p_procedure_name => 'Tasks_Rollup',
1876: p_error_text => SUBSTRB('PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates:'||SQLERRM,1,240));
1877: RAISE FND_API.G_EXC_ERROR;
1878: END;

Line 1943: x_msg_count := FND_MSG_PUB.count_msg;

1939: END IF;
1940:
1941:
1942: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1943: x_msg_count := FND_MSG_PUB.count_msg;
1944: if x_msg_count = 1 then
1945: x_msg_data := x_msg_data;
1946: end if;
1947: raise FND_API.G_EXC_ERROR;

Line 1987: x_msg_count := FND_MSG_PUB.count_msg;

1983: END IF;
1984:
1985:
1986: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1987: x_msg_count := FND_MSG_PUB.count_msg;
1988: if x_msg_count = 1 then
1989: x_msg_data := x_msg_data;
1990: end if;
1991: raise FND_API.G_EXC_ERROR;

Line 2053: x_msg_count := FND_MSG_PUB.count_msg;

2049: END IF;
2050:
2051: --
2052: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2053: x_msg_count := FND_MSG_PUB.count_msg;
2054: if x_msg_count = 1 then
2055: x_msg_data := x_msg_data;
2056: end if;
2057: raise FND_API.G_EXC_ERROR;

Line 2169: x_msg_count := FND_MSG_PUB.count_msg;

2165: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling Rollup_From_Subproject to rollup from the current project id='||
2166: cur_select_hier_rec.object_id_to2||' to its parent project id='||get_str_ver_ic_lnk_tasks_rec.parent_proj_id||' x_return_status='||x_return_status,3);
2167: END If;
2168: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2169: x_msg_count := FND_MSG_PUB.count_msg;
2170: if x_msg_count = 1 then
2171: x_msg_data := x_msg_data;
2172: end if;
2173: raise FND_API.G_EXC_ERROR;

Line 2210: x_msg_count := FND_MSG_PUB.count_msg;

2206: cur_select_hier_rec.object_id_to2||' to its parent project id='||get_str_ver_ic_lnk_tasks_rec.parent_proj_id||' x_return_status='||x_return_status,3);
2207: END IF;
2208:
2209: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2210: x_msg_count := FND_MSG_PUB.count_msg;
2211: if x_msg_count = 1 then
2212: x_msg_data := x_msg_data;
2213: end if;
2214: raise FND_API.G_EXC_ERROR;

Line 2233: x_msg_count := FND_MSG_PUB.count_msg;

2229: WHEN FND_API.G_EXC_ERROR THEN
2230: IF (p_commit = FND_API.G_TRUE) THEN
2231: ROLLBACK to TASKS_ROLLUP_PVT;
2232: END IF;
2233: x_msg_count := FND_MSG_PUB.count_msg;
2234: x_return_status := FND_API.G_RET_STS_ERROR;
2235: WHEN OTHERS THEN
2236: IF (p_commit = FND_API.G_TRUE) THEN
2237: ROLLBACK to TASKS_ROLLUP_PVT;

Line 2240: x_msg_count := FND_MSG_PUB.count_msg;

2236: IF (p_commit = FND_API.G_TRUE) THEN
2237: ROLLBACK to TASKS_ROLLUP_PVT;
2238: END IF;
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: x_msg_count := FND_MSG_PUB.count_msg;
2241: --put message
2242: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2243: p_procedure_name => 'Tasks_Rollup',
2244: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 2242: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',

2238: END IF;
2239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2240: x_msg_count := FND_MSG_PUB.count_msg;
2241: --put message
2242: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2243: p_procedure_name => 'Tasks_Rollup',
2244: p_error_text => SUBSTRB(SQLERRM,1,240));
2245: RAISE;
2246:

Line 2555: x_msg_count := FND_MSG_PUB.count_msg;

2551: WHEN FND_API.G_EXC_ERROR THEN
2552: IF (p_commit = FND_API.G_TRUE) THEN
2553: ROLLBACK to TASK_STATUS_ROLLUP_PUB;
2554: END IF;
2555: x_msg_count := FND_MSG_PUB.count_msg;
2556: x_return_status := FND_API.G_RET_STS_ERROR;
2557: WHEN OTHERS THEN
2558: IF (p_commit = FND_API.G_TRUE) THEN
2559: ROLLBACK to TASK_STATUS_ROLLUP_PUB;

Line 2562: x_msg_count := FND_MSG_PUB.count_msg;

2558: IF (p_commit = FND_API.G_TRUE) THEN
2559: ROLLBACK to TASK_STATUS_ROLLUP_PUB;
2560: END IF;
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: x_msg_count := FND_MSG_PUB.count_msg;
2563: --put message
2564: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2565: p_procedure_name => 'Task_Status_Rollup',
2566: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 2564: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',

2560: END IF;
2561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2562: x_msg_count := FND_MSG_PUB.count_msg;
2563: --put message
2564: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2565: p_procedure_name => 'Task_Status_Rollup',
2566: p_error_text => SUBSTRB(SQLERRM,1,240));
2567: RAISE;
2568: END Task_Status_Rollup;

Line 2654: x_msg_count := FND_MSG_PUB.count_msg;

2650: WHEN FND_API.G_EXC_ERROR THEN
2651: IF (p_commit = FND_API.G_TRUE) THEN
2652: ROLLBACK to TASK_STAT_PUSHDOWN_ROLLUP;
2653: END IF;
2654: x_msg_count := FND_MSG_PUB.count_msg;
2655: x_return_status := FND_API.G_RET_STS_ERROR;
2656: WHEN OTHERS THEN
2657: IF (p_commit = FND_API.G_TRUE) THEN
2658: ROLLBACK to TASK_STAT_PUSHDOWN_ROLLUP;

Line 2661: x_msg_count := FND_MSG_PUB.count_msg;

2657: IF (p_commit = FND_API.G_TRUE) THEN
2658: ROLLBACK to TASK_STAT_PUSHDOWN_ROLLUP;
2659: END IF;
2660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2661: x_msg_count := FND_MSG_PUB.count_msg;
2662: --put message
2663: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2664: p_procedure_name => 'Task_Stat_Pushdown_Rollup',
2665: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 2663: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',

2659: END IF;
2660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2661: x_msg_count := FND_MSG_PUB.count_msg;
2662: --put message
2663: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2664: p_procedure_name => 'Task_Stat_Pushdown_Rollup',
2665: p_error_text => SUBSTRB(SQLERRM,1,240));
2666: RAISE;
2667: END Task_Stat_Pushdown_Rollup;

Line 2935: x_msg_count := FND_MSG_PUB.count_msg;

2931: WHEN FND_API.G_EXC_ERROR THEN
2932: IF (p_commit = FND_API.G_TRUE) THEN
2933: ROLLBACK to Program_Schedule_dates_rollup;
2934: END IF;
2935: x_msg_count := FND_MSG_PUB.count_msg;
2936: x_return_status := FND_API.G_RET_STS_ERROR;
2937: WHEN OTHERS THEN
2938: IF (p_commit = FND_API.G_TRUE) THEN
2939: ROLLBACK to Program_Schedule_dates_rollup;

Line 2942: x_msg_count := FND_MSG_PUB.count_msg;

2938: IF (p_commit = FND_API.G_TRUE) THEN
2939: ROLLBACK to Program_Schedule_dates_rollup;
2940: END IF;
2941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2942: x_msg_count := FND_MSG_PUB.count_msg;
2943: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2944: p_procedure_name => 'Program_Schedule_dates_rollup',
2945: p_error_text => SUBSTRB(SQLERRM,1,240));
2946: RAISE;

Line 2943: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',

2939: ROLLBACK to Program_Schedule_dates_rollup;
2940: END IF;
2941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2942: x_msg_count := FND_MSG_PUB.count_msg;
2943: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2944: p_procedure_name => 'Program_Schedule_dates_rollup',
2945: p_error_text => SUBSTRB(SQLERRM,1,240));
2946: RAISE;
2947: