DBA Data[Home] [Help]

APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on FND_MSG_PUB

Line 793: x_msg_count := FND_MSG_PUB.count_msg;

789: END IF;
790:
791:
792: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
793: x_msg_count := FND_MSG_PUB.count_msg;
794: if x_msg_count = 1 then
795: x_msg_data := x_msg_data;
796: end if;
797: raise FND_API.G_EXC_ERROR;

Line 829: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 849: x_msg_count := FND_MSG_PUB.count_msg;

845: WHEN FND_API.G_EXC_ERROR THEN
846: IF (p_commit = FND_API.G_TRUE) THEN
847: ROLLBACK to Rollup_From_Subproject_PVT;
848: END IF;
849: x_msg_count := FND_MSG_PUB.count_msg;
850: x_return_status := FND_API.G_RET_STS_ERROR;
851: WHEN OTHERS THEN
852: IF (p_commit = FND_API.G_TRUE) THEN
853: ROLLBACK to Rollup_From_Subproject_PVT;

Line 856: x_msg_count := FND_MSG_PUB.count_msg;

852: IF (p_commit = FND_API.G_TRUE) THEN
853: ROLLBACK to Rollup_From_Subproject_PVT;
854: END IF;
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: x_msg_count := FND_MSG_PUB.count_msg;
857: --put message
858: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
859: p_procedure_name => 'Rollup_From_Subproject_Unltd',
860: p_error_text => SUBSTRB(SQLERRM,1,240));

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

854: END IF;
855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
856: x_msg_count := FND_MSG_PUB.count_msg;
857: --put message
858: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
859: p_procedure_name => 'Rollup_From_Subproject_Unltd',
860: p_error_text => SUBSTRB(SQLERRM,1,240));
861: RAISE;
862: END Rollup_From_Subproject_Unltd;

Line 1058: x_msg_count := FND_MSG_PUB.count_msg;

1054: WHEN FND_API.G_EXC_ERROR THEN
1055: IF (p_commit = FND_API.G_TRUE) THEN
1056: ROLLBACK to TASKS_ROLLUP_UNLIMITED_PUB;
1057: END IF;
1058: x_msg_count := FND_MSG_PUB.count_msg;
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: WHEN OTHERS THEN
1061: IF (p_commit = FND_API.G_TRUE) THEN
1062: ROLLBACK to TASKS_ROLLUP_UNLIMITED_PUB;

Line 1065: x_msg_count := FND_MSG_PUB.count_msg;

1061: IF (p_commit = FND_API.G_TRUE) THEN
1062: ROLLBACK to TASKS_ROLLUP_UNLIMITED_PUB;
1063: END IF;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: x_msg_count := FND_MSG_PUB.count_msg;
1066: --put message
1067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
1068: p_procedure_name => 'Tasks_Rollup_Unlimited',
1069: p_error_text => SUBSTRB(SQLERRM,1,240));

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

1063: END IF;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: x_msg_count := FND_MSG_PUB.count_msg;
1066: --put message
1067: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
1068: p_procedure_name => 'Tasks_Rollup_Unlimited',
1069: p_error_text => SUBSTRB(SQLERRM,1,240));
1070: RAISE;
1071:

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

1789: END IF;
1790:
1791: EXCEPTION
1792: WHEN OTHERS THEN
1793: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
1794: p_procedure_name => 'Tasks_Rollup',
1795: p_error_text => SUBSTRB('PA_TASK_ASSIGNMENT_UTILS.Adjust_Asgmt_Dates:'||SQLERRM,1,240));
1796: RAISE FND_API.G_EXC_ERROR;
1797: END;

Line 1862: x_msg_count := FND_MSG_PUB.count_msg;

1858: END IF;
1859:
1860:
1861: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1862: x_msg_count := FND_MSG_PUB.count_msg;
1863: if x_msg_count = 1 then
1864: x_msg_data := x_msg_data;
1865: end if;
1866: raise FND_API.G_EXC_ERROR;

Line 1906: x_msg_count := FND_MSG_PUB.count_msg;

1902: END IF;
1903:
1904:
1905: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1906: x_msg_count := FND_MSG_PUB.count_msg;
1907: if x_msg_count = 1 then
1908: x_msg_data := x_msg_data;
1909: end if;
1910: raise FND_API.G_EXC_ERROR;

Line 1965: x_msg_count := FND_MSG_PUB.count_msg;

1961: END IF;
1962:
1963: --
1964: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1965: x_msg_count := FND_MSG_PUB.count_msg;
1966: if x_msg_count = 1 then
1967: x_msg_data := x_msg_data;
1968: end if;
1969: raise FND_API.G_EXC_ERROR;

Line 2081: x_msg_count := FND_MSG_PUB.count_msg;

2077: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.TASKS_ROLLUP','After calling Rollup_From_Subproject to rollup from the current project id='||
2078: 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);
2079: END If;
2080: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2081: x_msg_count := FND_MSG_PUB.count_msg;
2082: if x_msg_count = 1 then
2083: x_msg_data := x_msg_data;
2084: end if;
2085: raise FND_API.G_EXC_ERROR;

Line 2122: x_msg_count := FND_MSG_PUB.count_msg;

2118: 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);
2119: END IF;
2120:
2121: If (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
2122: x_msg_count := FND_MSG_PUB.count_msg;
2123: if x_msg_count = 1 then
2124: x_msg_data := x_msg_data;
2125: end if;
2126: raise FND_API.G_EXC_ERROR;

Line 2145: x_msg_count := FND_MSG_PUB.count_msg;

2141: WHEN FND_API.G_EXC_ERROR THEN
2142: IF (p_commit = FND_API.G_TRUE) THEN
2143: ROLLBACK to TASKS_ROLLUP_PVT;
2144: END IF;
2145: x_msg_count := FND_MSG_PUB.count_msg;
2146: x_return_status := FND_API.G_RET_STS_ERROR;
2147: WHEN OTHERS THEN
2148: IF (p_commit = FND_API.G_TRUE) THEN
2149: ROLLBACK to TASKS_ROLLUP_PVT;

Line 2152: x_msg_count := FND_MSG_PUB.count_msg;

2148: IF (p_commit = FND_API.G_TRUE) THEN
2149: ROLLBACK to TASKS_ROLLUP_PVT;
2150: END IF;
2151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2152: x_msg_count := FND_MSG_PUB.count_msg;
2153: --put message
2154: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2155: p_procedure_name => 'Tasks_Rollup',
2156: p_error_text => SUBSTRB(SQLERRM,1,240));

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

2150: END IF;
2151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2152: x_msg_count := FND_MSG_PUB.count_msg;
2153: --put message
2154: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2155: p_procedure_name => 'Tasks_Rollup',
2156: p_error_text => SUBSTRB(SQLERRM,1,240));
2157: RAISE;
2158:

Line 2400: x_msg_count := FND_MSG_PUB.count_msg;

2396: WHEN FND_API.G_EXC_ERROR THEN
2397: IF (p_commit = FND_API.G_TRUE) THEN
2398: ROLLBACK to TASK_STATUS_ROLLUP_PUB;
2399: END IF;
2400: x_msg_count := FND_MSG_PUB.count_msg;
2401: x_return_status := FND_API.G_RET_STS_ERROR;
2402: WHEN OTHERS THEN
2403: IF (p_commit = FND_API.G_TRUE) THEN
2404: ROLLBACK to TASK_STATUS_ROLLUP_PUB;

Line 2407: x_msg_count := FND_MSG_PUB.count_msg;

2403: IF (p_commit = FND_API.G_TRUE) THEN
2404: ROLLBACK to TASK_STATUS_ROLLUP_PUB;
2405: END IF;
2406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2407: x_msg_count := FND_MSG_PUB.count_msg;
2408: --put message
2409: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2410: p_procedure_name => 'Task_Status_Rollup',
2411: p_error_text => SUBSTRB(SQLERRM,1,240));

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

2405: END IF;
2406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2407: x_msg_count := FND_MSG_PUB.count_msg;
2408: --put message
2409: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2410: p_procedure_name => 'Task_Status_Rollup',
2411: p_error_text => SUBSTRB(SQLERRM,1,240));
2412: RAISE;
2413: END Task_Status_Rollup;

Line 2499: x_msg_count := FND_MSG_PUB.count_msg;

2495: WHEN FND_API.G_EXC_ERROR THEN
2496: IF (p_commit = FND_API.G_TRUE) THEN
2497: ROLLBACK to TASK_STAT_PUSHDOWN_ROLLUP;
2498: END IF;
2499: x_msg_count := FND_MSG_PUB.count_msg;
2500: x_return_status := FND_API.G_RET_STS_ERROR;
2501: WHEN OTHERS THEN
2502: IF (p_commit = FND_API.G_TRUE) THEN
2503: ROLLBACK to TASK_STAT_PUSHDOWN_ROLLUP;

Line 2506: x_msg_count := FND_MSG_PUB.count_msg;

2502: IF (p_commit = FND_API.G_TRUE) THEN
2503: ROLLBACK to TASK_STAT_PUSHDOWN_ROLLUP;
2504: END IF;
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2506: x_msg_count := FND_MSG_PUB.count_msg;
2507: --put message
2508: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2509: p_procedure_name => 'Task_Stat_Pushdown_Rollup',
2510: p_error_text => SUBSTRB(SQLERRM,1,240));

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

2504: END IF;
2505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2506: x_msg_count := FND_MSG_PUB.count_msg;
2507: --put message
2508: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2509: p_procedure_name => 'Task_Stat_Pushdown_Rollup',
2510: p_error_text => SUBSTRB(SQLERRM,1,240));
2511: RAISE;
2512: END Task_Stat_Pushdown_Rollup;

Line 2752: x_msg_count := FND_MSG_PUB.count_msg;

2748: WHEN FND_API.G_EXC_ERROR THEN
2749: IF (p_commit = FND_API.G_TRUE) THEN
2750: ROLLBACK to Program_Schedule_dates_rollup;
2751: END IF;
2752: x_msg_count := FND_MSG_PUB.count_msg;
2753: x_return_status := FND_API.G_RET_STS_ERROR;
2754: WHEN OTHERS THEN
2755: IF (p_commit = FND_API.G_TRUE) THEN
2756: ROLLBACK to Program_Schedule_dates_rollup;

Line 2759: x_msg_count := FND_MSG_PUB.count_msg;

2755: IF (p_commit = FND_API.G_TRUE) THEN
2756: ROLLBACK to Program_Schedule_dates_rollup;
2757: END IF;
2758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2759: x_msg_count := FND_MSG_PUB.count_msg;
2760: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2761: p_procedure_name => 'Program_Schedule_dates_rollup',
2762: p_error_text => SUBSTRB(SQLERRM,1,240));
2763: RAISE;

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

2756: ROLLBACK to Program_Schedule_dates_rollup;
2757: END IF;
2758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2759: x_msg_count := FND_MSG_PUB.count_msg;
2760: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_STRUCT_TASK_ROLLUP_PUB',
2761: p_procedure_name => 'Program_Schedule_dates_rollup',
2762: p_error_text => SUBSTRB(SQLERRM,1,240));
2763: RAISE;
2764: