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_TASK_PVT1 dependencies on FND_MSG_PUB

Line 452: l_msg_count := FND_MSG_PUB.count_msg;

448: --Name is not unique
449: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_TASK_NUMBER_UNIQUE');
450: l_msg_data := 'PA_PS_TASK_NUMBER_UNIQUE';
451: /* bug 3459905 Check if there is any error. */
452: l_msg_count := FND_MSG_PUB.count_msg;
453: IF l_msg_count > 0 THEN
454: x_msg_count := l_msg_count;
455: IF x_msg_count = 1 THEN
456: x_msg_data := l_msg_data;

Line 463: l_msg_count := FND_MSG_PUB.count_msg;

459: /* end of 3458052*/
460: END IF;
461:
462: /* bug 3459905 --Check if there is any error.
463: l_msg_count := FND_MSG_PUB.count_msg;
464: IF l_msg_count > 0 THEN
465: x_msg_count := l_msg_count;
466: IF x_msg_count = 1 THEN
467: x_msg_data := l_msg_data;

Line 972: x_msg_count := FND_MSG_PUB.count_msg;

968: ,x_msg_data => l_msg_data
969: );
970:
971: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
972: x_msg_count := FND_MSG_PUB.count_msg;
973: IF x_msg_count = 1 then
974: pa_interface_utils_pub.get_messages
975: (p_encoded => FND_API.G_TRUE,
976: p_msg_index => 1,

Line 1084: l_msg_count := FND_MSG_PUB.count_msg;

1080: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_INV_REF_TASK_ID');
1081: l_msg_data := 'PA_PS_INV_REF_TASK_ID';
1082: -- start of bug 3459905
1083: --Check if there is any error.
1084: l_msg_count := FND_MSG_PUB.count_msg;
1085: IF l_msg_count > 0 THEN
1086: x_msg_count := l_msg_count;
1087: IF x_msg_count = 1 THEN
1088: x_msg_data := l_msg_data;

Line 1096: l_msg_count := FND_MSG_PUB.count_msg;

1092: -- end of bug 3459905
1093: END IF;
1094:
1095: /* bug 3459905 --Check if there is any error.
1096: l_msg_count := FND_MSG_PUB.count_msg;
1097: IF l_msg_count > 0 THEN
1098: x_msg_count := l_msg_count;
1099: IF x_msg_count = 1 THEN
1100: x_msg_data := l_msg_data;

Line 1197: x_msg_count := FND_MSG_PUB.count_msg;

1193: -- end xxlu changes
1194:
1195: --dbms_output.put_line( 'l_msg_data '||l_msg_data );
1196: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1197: x_msg_count := FND_MSG_PUB.count_msg;
1198: IF x_msg_count = 1 then
1199: pa_interface_utils_pub.get_messages
1200: (p_encoded => FND_API.G_TRUE,
1201: p_msg_index => 1,

Line 1235: x_msg_count := FND_MSG_PUB.count_msg;

1231: , x_msg_count => l_msg_count
1232: );
1233:
1234: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1235: x_msg_count := FND_MSG_PUB.count_msg;
1236: IF x_msg_count = 1 then
1237: pa_interface_utils_pub.get_messages
1238: (p_encoded => FND_API.G_TRUE,
1239: p_msg_index => 1,

Line 1300: x_msg_count := FND_MSG_PUB.count_msg;

1296: , x_msg_count => l_msg_count
1297: );
1298:
1299: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1300: x_msg_count := FND_MSG_PUB.count_msg;
1301: IF x_msg_count = 1 then
1302: pa_interface_utils_pub.get_messages
1303: (p_encoded => FND_API.G_TRUE,
1304: p_msg_index => 1,

Line 1327: x_msg_count := FND_MSG_PUB.count_msg;

1323: WHEN FND_API.G_EXC_ERROR THEN
1324: IF (p_commit = FND_API.G_TRUE) THEN
1325: ROLLBACK to CREATE_TASK_PRIVATE;
1326: END IF;
1327: x_msg_count := FND_MSG_PUB.count_msg;
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: WHEN OTHERS THEN
1330: IF (p_commit = FND_API.G_TRUE) THEN
1331: ROLLBACK to CREATE_TASK_PRIVATE;

Line 1334: x_msg_count := FND_MSG_PUB.count_msg;

1330: IF (p_commit = FND_API.G_TRUE) THEN
1331: ROLLBACK to CREATE_TASK_PRIVATE;
1332: END IF;
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334: x_msg_count := FND_MSG_PUB.count_msg;
1335: --put message
1336: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
1337: p_procedure_name => 'Create_Task',
1338: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 1336: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

1332: END IF;
1333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1334: x_msg_count := FND_MSG_PUB.count_msg;
1335: --put message
1336: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
1337: p_procedure_name => 'Create_Task',
1338: p_error_text => SUBSTRB(SQLERRM,1,240));
1339: RAISE;
1340:

Line 1865: l_msg_count := FND_MSG_PUB.count_msg;

1861: --Name is not unique
1862: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_TASK_NUMBER_UNIQUE');
1863: l_msg_data := 'PA_PS_TASK_NUMBER_UNIQUE';
1864: -- start of bug 3459905
1865: l_msg_count := FND_MSG_PUB.count_msg;
1866: IF l_msg_count > 0 THEN
1867: x_msg_count := l_msg_count;
1868: IF x_msg_count = 1 THEN
1869: x_msg_data := l_msg_data;

Line 1880: l_msg_count := FND_MSG_PUB.count_msg;

1876: /** Code above is uncommented for bug 4218947 **/
1877: --dbms_output.put_line(( 'After Check if the task name is unique within the project.' );
1878:
1879: /* start of bug 3459905 --Check if there is any error.
1880: l_msg_count := FND_MSG_PUB.count_msg;
1881: IF l_msg_count > 0 THEN
1882: x_msg_count := l_msg_count;
1883: IF x_msg_count = 1 THEN
1884: x_msg_data := l_msg_data;

Line 1902: l_msg_count := FND_MSG_PUB.count_msg;

1898: --Is not a top task across all versions. Error
1899: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_NOT_ALL_TOP_TASKS');
1900: -- start of bug 3459905
1901: --Check if there is any error.
1902: l_msg_count := FND_MSG_PUB.count_msg;
1903: IF l_msg_count > 0 THEN
1904: x_msg_count := l_msg_count;
1905: IF x_msg_count = 1 THEN
1906: x_msg_data := l_msg_data;

Line 1921: l_msg_count := FND_MSG_PUB.count_msg;

1917: -- Phase already in use in the structure. Error
1918: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_PHASE_IN_USE');
1919: -- start of bug 3459905
1920: --Check if there is any error.
1921: l_msg_count := FND_MSG_PUB.count_msg;
1922: IF l_msg_count > 0 THEN
1923: x_msg_count := l_msg_count;
1924: IF x_msg_count = 1 THEN
1925: x_msg_data := l_msg_data;

Line 1933: l_msg_count := FND_MSG_PUB.count_msg;

1929: -- end of bug 3459905
1930: END IF;
1931: /* start of bug 3459905
1932: --Check if there is any error.
1933: l_msg_count := FND_MSG_PUB.count_msg;
1934: IF l_msg_count > 0 THEN
1935: x_msg_count := l_msg_count;
1936: IF x_msg_count = 1 THEN
1937: x_msg_data := l_msg_data;

Line 2022: l_msg_count := FND_MSG_PUB.count_msg;

2018: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_CHG_TASK_TYPE_ERR');
2019: l_msg_data := 'PA_PS_CHG_TASK_TYPE_ERR';
2020: --Check if there is any error.
2021: -- start of bug 3459905
2022: l_msg_count := FND_MSG_PUB.count_msg;
2023: IF l_msg_count > 0 THEN
2024: x_msg_count := l_msg_count;
2025: IF x_msg_count = 1 THEN
2026: x_msg_data := l_msg_data;

Line 2038: l_msg_count := FND_MSG_PUB.count_msg;

2034: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_EFF_TASK_TYPE_ERR');
2035: l_msg_data := 'PA_PS_EFF_TASK_TYPE_ERR';
2036: -- start of bug 3459905
2037: --Check if there is any error.
2038: l_msg_count := FND_MSG_PUB.count_msg;
2039: IF l_msg_count > 0 THEN
2040: x_msg_count := l_msg_count;
2041: IF x_msg_count = 1 THEN
2042: x_msg_data := l_msg_data;

Line 2050: l_msg_count := FND_MSG_PUB.count_msg;

2046: -- end of bug 3459905
2047: END IF;
2048: /* start of bug 3459905
2049: --Check if there is any error.
2050: l_msg_count := FND_MSG_PUB.count_msg;
2051: IF l_msg_count > 0 THEN
2052: x_msg_count := l_msg_count;
2053: IF x_msg_count = 1 THEN
2054: x_msg_data := l_msg_data;

Line 2094: l_msg_count := FND_MSG_PUB.count_msg;

2090: ,x_msg_count => l_msg_count
2091: ,x_msg_data => l_msg_data);
2092:
2093: --Check if there is any error.
2094: l_msg_count := FND_MSG_PUB.count_msg;
2095: IF l_msg_count > 0 THEN
2096: x_msg_count := l_msg_count;
2097: IF x_msg_count = 1 THEN
2098: x_msg_data := l_msg_data;

Line 2153: l_msg_count := FND_MSG_PUB.count_msg;

2149: x_msg_data => l_msg_data
2150: );
2151:
2152: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2153: l_msg_count := FND_MSG_PUB.count_msg;
2154: IF l_msg_count > 0 THEN
2155: x_msg_count := l_msg_count;
2156: IF x_msg_count = 1 THEN
2157: x_msg_data := l_msg_data;

Line 2187: l_msg_count := FND_MSG_PUB.count_msg;

2183: x_msg_data => l_msg_data
2184: );
2185:
2186: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2187: l_msg_count := FND_MSG_PUB.count_msg;
2188: IF l_msg_count > 0 THEN
2189: x_msg_count := l_msg_count;
2190: IF x_msg_count = 1 THEN
2191: x_msg_data := l_msg_data;

Line 2601: x_msg_count := FND_MSG_PUB.count_msg;

2597: ,x_msg_data => l_msg_data
2598: );
2599:
2600: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2601: x_msg_count := FND_MSG_PUB.count_msg;
2602: IF x_msg_count = 1 then
2603: pa_interface_utils_pub.get_messages
2604: (p_encoded => FND_API.G_TRUE,
2605: p_msg_index => 1,

Line 2701: l_msg_count := FND_MSG_PUB.count_msg;

2697: ,x_return_status => l_return_status
2698: ,x_msg_count => l_msg_count
2699: ,x_msg_data => l_msg_data );
2700:
2701: l_msg_count := FND_MSG_PUB.count_msg;
2702:
2703: IF l_msg_count > 0 THEN
2704: x_msg_count := l_msg_count;
2705: x_return_status := 'E';

Line 2721: l_msg_count := FND_MSG_PUB.count_msg;

2717: ,x_msg_count => l_msg_count
2718: ,x_msg_data => l_msg_data);
2719:
2720: --Check if there is any error.
2721: l_msg_count := FND_MSG_PUB.count_msg;
2722: IF l_msg_count > 0 THEN
2723: x_msg_count := l_msg_count;
2724: IF x_msg_count = 1 THEN
2725: x_msg_data := l_msg_data;

Line 2913: x_msg_count := FND_MSG_PUB.count_msg;

2909: END IF;
2910: END IF;
2911:
2912: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2913: x_msg_count := FND_MSG_PUB.count_msg;
2914: IF x_msg_count = 1 then
2915: pa_interface_utils_pub.get_messages
2916: (p_encoded => FND_API.G_TRUE,
2917: p_msg_index => 1,

Line 2948: x_msg_count := FND_MSG_PUB.count_msg;

2944: ,x_msg_data => l_msg_data
2945: );
2946:
2947: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2948: x_msg_count := FND_MSG_PUB.count_msg;
2949: IF x_msg_count = 1 then
2950: pa_interface_utils_pub.get_messages
2951: (p_encoded => FND_API.G_TRUE,
2952: p_msg_index => 1,

Line 2989: x_msg_count := FND_MSG_PUB.count_msg;

2985: ,x_msg_data => l_msg_data
2986: );
2987:
2988: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2989: x_msg_count := FND_MSG_PUB.count_msg;
2990: IF x_msg_count = 1 then
2991: pa_interface_utils_pub.get_messages
2992: (p_encoded => FND_API.G_TRUE,
2993: p_msg_index => 1,

Line 3012: x_msg_count := FND_MSG_PUB.count_msg;

3008: ,x_msg_count => l_msg_count
3009: ,x_msg_data => l_msg_data
3010: );
3011: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3012: x_msg_count := FND_MSG_PUB.count_msg;
3013: IF x_msg_count = 1 then
3014: pa_interface_utils_pub.get_messages
3015: (p_encoded => FND_API.G_TRUE,
3016: p_msg_index => 1,

Line 3035: x_msg_count := FND_MSG_PUB.count_msg;

3031: WHEN FND_API.G_EXC_ERROR THEN
3032: IF (p_commit = FND_API.G_TRUE) THEN
3033: ROLLBACK to UPDATE_TASK_PRIVATE;
3034: END IF;
3035: x_msg_count := FND_MSG_PUB.count_msg;
3036: x_return_status := FND_API.G_RET_STS_ERROR;
3037: WHEN OTHERS THEN
3038: IF (p_commit = FND_API.G_TRUE) THEN
3039: ROLLBACK to UPDATE_TASK_PRIVATE;

Line 3042: x_msg_count := FND_MSG_PUB.count_msg;

3038: IF (p_commit = FND_API.G_TRUE) THEN
3039: ROLLBACK to UPDATE_TASK_PRIVATE;
3040: END IF;
3041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3042: x_msg_count := FND_MSG_PUB.count_msg;
3043: --put message
3044: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
3045: p_procedure_name => 'update_Task',
3046: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 3044: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

3040: END IF;
3041: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3042: x_msg_count := FND_MSG_PUB.count_msg;
3043: --put message
3044: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
3045: p_procedure_name => 'update_Task',
3046: p_error_text => SUBSTRB(SQLERRM,1,240));
3047: RAISE;
3048: END Update_Task;

Line 3688: x_msg_count := FND_MSG_PUB.count_msg;

3684: WHEN FND_API.G_EXC_ERROR THEN
3685: IF (p_commit = FND_API.G_TRUE) THEN
3686: ROLLBACK to CREATE_TASK_VER_PRIVATE;
3687: END IF;
3688: x_msg_count := FND_MSG_PUB.count_msg;
3689: x_return_status := FND_API.G_RET_STS_ERROR;
3690:
3691: -- --dbms_output.put_line( 'In exception ');
3692: -- --dbms_output.put_line( 'Status In exception ' ||x_return_status);

Line 3700: x_msg_count := FND_MSG_PUB.count_msg;

3696: IF (p_commit = FND_API.G_TRUE) THEN
3697: ROLLBACK to CREATE_TASK_VER_PRIVATE;
3698: END IF;
3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700: x_msg_count := FND_MSG_PUB.count_msg;
3701: --put message
3702: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
3703: p_procedure_name => 'create_Task_version',
3704: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 3702: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

3698: END IF;
3699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3700: x_msg_count := FND_MSG_PUB.count_msg;
3701: --put message
3702: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
3703: p_procedure_name => 'create_Task_version',
3704: p_error_text => SUBSTRB(SQLERRM,1,240));
3705: RAISE;
3706:

Line 4480: x_msg_count := FND_MSG_PUB.count_msg;

4476: ,x_msg_data => l_msg_data
4477: );
4478:
4479: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4480: x_msg_count := FND_MSG_PUB.count_msg;
4481: IF x_msg_count = 1 then
4482: pa_interface_utils_pub.get_messages
4483: (p_encoded => FND_API.G_TRUE,
4484: p_msg_index => 1,

Line 4535: x_msg_count := FND_MSG_PUB.count_msg;

4531: ,x_msg_data => x_msg_data
4532: );
4533:
4534: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4535: x_msg_count := FND_MSG_PUB.count_msg;
4536: IF x_msg_count = 1 then
4537: pa_interface_utils_pub.get_messages
4538: (p_encoded => FND_API.G_TRUE,
4539: p_msg_index => 1,

Line 4561: x_msg_count := FND_MSG_PUB.count_msg;

4557: ,x_msg_count => l_msg_count
4558: ,x_msg_data => l_msg_data
4559: );
4560:
4561: x_msg_count := FND_MSG_PUB.count_msg;
4562: IF x_msg_count = 1 then
4563: pa_interface_utils_pub.get_messages
4564: (p_encoded => FND_API.G_TRUE,
4565: p_msg_index => 1,

Line 4581: x_msg_count := FND_MSG_PUB.count_msg;

4577: ,x_msg_count => l_msg_count
4578: ,x_msg_data => l_msg_data
4579: );
4580:
4581: x_msg_count := FND_MSG_PUB.count_msg;
4582: IF x_msg_count = 1 then
4583: pa_interface_utils_pub.get_messages
4584: (p_encoded => FND_API.G_TRUE,
4585: p_msg_index => 1,

Line 4773: x_msg_count := FND_MSG_PUB.count_msg;

4769: WHEN FND_API.G_EXC_ERROR THEN
4770: IF (p_commit = FND_API.G_TRUE) THEN
4771: ROLLBACK to UPDATE_TASK_VER_PRIVATE;
4772: END IF;
4773: x_msg_count := FND_MSG_PUB.count_msg;
4774: x_return_status := FND_API.G_RET_STS_ERROR;
4775: WHEN OTHERS THEN
4776: IF (p_commit = FND_API.G_TRUE) THEN
4777: ROLLBACK to UPDATE_TASK_VER_PRIVATE;

Line 4780: x_msg_count := FND_MSG_PUB.count_msg;

4776: IF (p_commit = FND_API.G_TRUE) THEN
4777: ROLLBACK to UPDATE_TASK_VER_PRIVATE;
4778: END IF;
4779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4780: x_msg_count := FND_MSG_PUB.count_msg;
4781: --put message
4782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
4783: p_procedure_name => 'update_Task_version',
4784: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 4782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

4778: END IF;
4779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4780: x_msg_count := FND_MSG_PUB.count_msg;
4781: --put message
4782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
4783: p_procedure_name => 'update_Task_version',
4784: p_error_text => SUBSTRB(SQLERRM,1,240));
4785: RAISE;
4786: END update_task_version;

Line 5244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

5240: ,x_msg_count => x_msg_count
5241: ,x_msg_data => x_msg_data);
5242: EXCEPTION
5243: WHEN OTHERS THEN
5244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
5245: p_procedure_name => 'delete_Task_version',
5246: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
5247: RAISE FND_API.G_EXC_ERROR;
5248: END;

Line 5311: x_msg_count := FND_MSG_PUB.count_msg;

5307: ,x_msg_count => x_msg_count
5308: ,x_msg_data => x_msg_data);
5309:
5310: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
5311: x_msg_count := FND_MSG_PUB.count_msg;
5312: If x_msg_count = 1 then
5313: pa_interface_utils_pub.get_messages
5314: (p_encoded => FND_API.G_TRUE,
5315: p_msg_index => 1,

Line 5360: x_msg_count := FND_MSG_PUB.count_msg;

5356: ,x_return_status => l_return_status
5357: ,x_msg_count => l_msg_count
5358: ,x_msg_data => l_msg_data);
5359: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5360: x_msg_count := FND_MSG_PUB.count_msg;
5361: IF x_msg_count = 1 then
5362: pa_interface_utils_pub.get_messages(
5363: p_encoded => FND_API.G_TRUE,
5364: p_msg_index => 1,

Line 5487: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

5483: ,x_msg_count => x_msg_count
5484: ,x_msg_data => x_msg_data);
5485: EXCEPTION
5486: WHEN OTHERS THEN
5487: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
5488: p_procedure_name => 'delete_Task_version',
5489: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
5490: RAISE FND_API.G_EXC_ERROR;
5491: END;

Line 5605: x_msg_count := FND_MSG_PUB.count_msg;

5601: ,x_msg_data => x_msg_data
5602: );
5603:
5604: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
5605: x_msg_count := FND_MSG_PUB.count_msg;
5606: If x_msg_count = 1 then
5607: pa_interface_utils_pub.get_messages
5608: (p_encoded => FND_API.G_TRUE,
5609: p_msg_index => 1,

Line 5657: x_msg_count := FND_MSG_PUB.count_msg;

5653: , x_msg_count => l_msg_count
5654: );
5655:
5656: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5657: x_msg_count := FND_MSG_PUB.count_msg;
5658: IF x_msg_count = 1 then
5659: pa_interface_utils_pub.get_messages
5660: (p_encoded => FND_API.G_TRUE,
5661: p_msg_index => 1,

Line 5699: x_msg_count := FND_MSG_PUB.count_msg;

5695: ,x_msg_count => l_msg_count
5696: ,x_msg_data => l_msg_data
5697: );
5698: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5699: x_msg_count := FND_MSG_PUB.count_msg;
5700: IF x_msg_count = 1 then
5701: pa_interface_utils_pub.get_messages
5702: (p_encoded => FND_API.G_TRUE,
5703: p_msg_index => 1,

Line 5763: x_msg_count := FND_MSG_PUB.count_msg;

5759: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);
5760: END IF;
5761:
5762: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5763: x_msg_count := FND_MSG_PUB.count_msg;
5764: IF x_msg_count = 1 then
5765: pa_interface_utils_pub.get_messages
5766: (p_encoded => FND_API.G_TRUE,
5767: p_msg_index => 1,

Line 5798: x_msg_count := FND_MSG_PUB.count_msg;

5794: ,x_msg_data => l_msg_data
5795: );
5796:
5797: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5798: x_msg_count := FND_MSG_PUB.count_msg;
5799: IF x_msg_count = 1 then
5800: pa_interface_utils_pub.get_messages
5801: (p_encoded => FND_API.G_TRUE,
5802: p_msg_index => 1,

Line 5827: x_msg_count := FND_MSG_PUB.count_msg;

5823: ,p_parent_task_id => l_parent_task_verion_id
5824: ,x_return_status => l_return_status );
5825:
5826: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5827: x_msg_count := FND_MSG_PUB.count_msg;
5828: IF x_msg_count = 1 then
5829: pa_interface_utils_pub.get_messages
5830: (p_encoded => FND_API.G_TRUE,
5831: p_msg_index => 1,

Line 5906: l_msg_count := FND_MSG_PUB.count_msg;

5902: ,x_return_status => l_return_status
5903: ,x_msg_count => l_msg_count
5904: ,x_msg_data => l_msg_data );
5905:
5906: l_msg_count := FND_MSG_PUB.count_msg;
5907:
5908: IF l_msg_count > 0 THEN
5909: x_msg_count := l_msg_count;
5910: x_return_status := 'E';

Line 5922: l_msg_count := FND_MSG_PUB.count_msg;

5918: ,x_return_status => l_return_status
5919: ,x_msg_count => l_msg_count
5920: ,x_msg_data => l_msg_data
5921: );
5922: l_msg_count := FND_MSG_PUB.count_msg;
5923:
5924: IF l_msg_count > 0 THEN
5925: x_msg_count := l_msg_count;
5926: x_return_status := 'E';

Line 5974: fnd_msg_pub.add_exc_msg(

5970: EXCEPTION
5971:
5972: WHEN OTHERS THEN
5973:
5974: fnd_msg_pub.add_exc_msg(
5975: p_pkg_name => 'PA_TASK_PVT1',
5976: p_procedure_name => 'Delete_Task_Version',
5977: p_error_text => SUBSTRB('PA_PROGRESS_PUB.delete_working_wp_progress:'||SQLERRM,1,240));
5978:

Line 6013: fnd_msg_pub.add_exc_msg(

6009: EXCEPTION
6010:
6011: WHEN OTHERS THEN
6012:
6013: fnd_msg_pub.add_exc_msg(
6014: p_pkg_name => 'PA_TASK_PVT1',
6015: p_procedure_name => 'Delete_Task_Version',
6016: p_error_text => SUBSTRB('PA_PROGRESS_PUB.delete_working_wp_progress:'||SQLERRM,1,240));
6017:

Line 6064: x_msg_count := FND_MSG_PUB.count_msg;

6060: x_msg_count => l_msg_count,
6061: x_msg_data => l_msg_data);
6062:
6063: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6064: x_msg_count := FND_MSG_PUB.count_msg;
6065: if x_msg_count = 1 then
6066: pa_interface_utils_pub.get_messages
6067: (p_encoded => FND_API.G_TRUE,
6068: p_msg_index => 1,

Line 6149: x_msg_count := FND_MSG_PUB.count_msg;

6145: ,x_msg_data => l_msg_data
6146: );
6147:
6148: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6149: x_msg_count := FND_MSG_PUB.count_msg;
6150: if x_msg_count = 1 then
6151: pa_interface_utils_pub.get_messages
6152: (p_encoded => FND_API.G_TRUE,
6153: p_msg_index => 1,

Line 6180: x_msg_count := FND_MSG_PUB.count_msg;

6176: ,x_msg_data => l_msg_data
6177: );
6178:
6179: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6180: x_msg_count := FND_MSG_PUB.count_msg;
6181: if x_msg_count = 1 then
6182: pa_interface_utils_pub.get_messages
6183: (p_encoded => FND_API.G_TRUE,
6184: p_msg_index => 1,

Line 6222: x_msg_count := FND_MSG_PUB.count_msg;

6218: ,x_msg_count => l_msg_count
6219: ,x_msg_data => l_msg_data);
6220:
6221: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6222: x_msg_count := FND_MSG_PUB.count_msg;
6223: if x_msg_count = 1 then
6224: pa_interface_utils_pub.get_messages
6225: (p_encoded => FND_API.G_TRUE,
6226: p_msg_index => 1,

Line 6248: x_msg_count := FND_MSG_PUB.count_msg;

6244: WHEN FND_API.G_EXC_ERROR THEN
6245: IF (p_commit = FND_API.G_TRUE) THEN
6246: ROLLBACK to DELETE_TASK_VER_PRIVATE;
6247: END IF;
6248: x_msg_count := FND_MSG_PUB.count_msg;
6249: x_return_status := FND_API.G_RET_STS_ERROR;
6250: WHEN OTHERS THEN
6251: IF (p_commit = FND_API.G_TRUE) THEN
6252: ROLLBACK to DELETE_TASK_VER_PRIVATE;

Line 6255: x_msg_count := FND_MSG_PUB.count_msg;

6251: IF (p_commit = FND_API.G_TRUE) THEN
6252: ROLLBACK to DELETE_TASK_VER_PRIVATE;
6253: END IF;
6254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6255: x_msg_count := FND_MSG_PUB.count_msg;
6256: --put message
6257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
6258: p_procedure_name => 'delete_Task_version',
6259: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 6257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

6253: END IF;
6254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6255: x_msg_count := FND_MSG_PUB.count_msg;
6256: --put message
6257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
6258: p_procedure_name => 'delete_Task_version',
6259: p_error_text => SUBSTRB(SQLERRM,1,240));
6260: RAISE;
6261: END delete_task_version;

Line 6771: l_msg_count := FND_MSG_PUB.count_msg;

6767: ,x_msg_data => l_msg_data
6768: );
6769:
6770: IF (l_return_status <> 'S') THEN
6771: l_msg_count := FND_MSG_PUB.count_msg;
6772: IF l_msg_count > 0 THEN
6773: x_msg_count := l_msg_count;
6774: IF x_msg_count = 1 THEN
6775: x_msg_data := l_msg_data;

Line 6828: l_msg_count := FND_MSG_PUB.count_msg;

6824: ,x_msg_count => l_msg_count
6825: ,x_msg_data => l_msg_data);
6826:
6827: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6828: l_msg_count := FND_MSG_PUB.count_msg;
6829: IF l_msg_count > 0 THEN
6830: x_msg_count := l_msg_count;
6831: IF x_msg_count = 1 THEN
6832: x_msg_data := l_msg_data;

Line 6862: l_msg_count := FND_MSG_PUB.count_msg;

6858: ,x_msg_count => l_msg_count
6859: ,x_msg_data => l_msg_data);
6860:
6861: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6862: l_msg_count := FND_MSG_PUB.count_msg;
6863: IF l_msg_count > 0 THEN
6864: x_msg_count := l_msg_count;
6865: IF x_msg_count = 1 THEN
6866: x_msg_data := l_msg_data;

Line 7006: x_msg_count := FND_MSG_PUB.count_msg;

7002: ,x_msg_data => x_msg_data
7003: );
7004:
7005: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
7006: x_msg_count := FND_MSG_PUB.count_msg;
7007: If x_msg_count = 1 then
7008: pa_interface_utils_pub.get_messages
7009: (p_encoded => FND_API.G_TRUE,
7010: p_msg_index => 1,

Line 7095: x_msg_count := FND_MSG_PUB.count_msg;

7091: WHEN FND_API.G_EXC_ERROR THEN
7092: IF (p_commit = FND_API.G_TRUE) THEN
7093: ROLLBACK to CREATE_SCH_VER_PRIVATE;
7094: END IF;
7095: x_msg_count := FND_MSG_PUB.count_msg;
7096: x_return_status := FND_API.G_RET_STS_ERROR;
7097: WHEN OTHERS THEN
7098: IF (p_commit = FND_API.G_TRUE) THEN
7099: ROLLBACK to CREATE_SCH_VER_PRIVATE;

Line 7102: x_msg_count := FND_MSG_PUB.count_msg;

7098: IF (p_commit = FND_API.G_TRUE) THEN
7099: ROLLBACK to CREATE_SCH_VER_PRIVATE;
7100: END IF;
7101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7102: x_msg_count := FND_MSG_PUB.count_msg;
7103: --put message
7104: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
7105: p_procedure_name => 'create_schedule_version',
7106: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 7104: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

7100: END IF;
7101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7102: x_msg_count := FND_MSG_PUB.count_msg;
7103: --put message
7104: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
7105: p_procedure_name => 'create_schedule_version',
7106: p_error_text => SUBSTRB(SQLERRM,1,240));
7107: RAISE;
7108:

Line 7450: -- l_msg_count := FND_MSG_PUB.count_msg;

7446: -- x_msg_count => l_msg_count,
7447: -- x_msg_data => l_msg_data
7448: -- );
7449: -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7450: -- l_msg_count := FND_MSG_PUB.count_msg;
7451: -- IF l_msg_count > 0 THEN
7452: -- x_msg_count := l_msg_count;
7453: -- IF x_msg_count = 1 THEN
7454: -- x_msg_data := l_msg_data;

Line 7919: l_msg_count := FND_MSG_PUB.count_msg;

7915: ,x_msg_data => l_msg_data
7916: );
7917:
7918: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7919: l_msg_count := FND_MSG_PUB.count_msg;
7920: IF l_msg_count > 0 THEN
7921: x_msg_count := l_msg_count;
7922: IF x_msg_count = 1 THEN
7923: x_msg_data := l_msg_data;

Line 7964: l_msg_count := FND_MSG_PUB.count_msg;

7960: ,x_msg_count => l_msg_count
7961: ,x_msg_data => l_msg_data);
7962:
7963: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7964: l_msg_count := FND_MSG_PUB.count_msg;
7965: IF l_msg_count > 0 THEN
7966: x_msg_count := l_msg_count;
7967: IF x_msg_count = 1 THEN
7968: x_msg_data := l_msg_data;

Line 7996: l_msg_count := FND_MSG_PUB.count_msg;

7992: ,x_msg_count => l_msg_count
7993: ,x_msg_data => l_msg_data);
7994:
7995: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7996: l_msg_count := FND_MSG_PUB.count_msg;
7997: IF l_msg_count > 0 THEN
7998: x_msg_count := l_msg_count;
7999: IF x_msg_count = 1 THEN
8000: x_msg_data := l_msg_data;

Line 8078: l_msg_count := FND_MSG_PUB.count_msg;

8074: x_msg_count => l_msg_count,
8075: x_msg_data => l_msg_data
8076: );
8077: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8078: l_msg_count := FND_MSG_PUB.count_msg;
8079: IF l_msg_count > 0 THEN
8080: x_msg_count := l_msg_count;
8081: IF x_msg_count = 1 THEN
8082: x_msg_data := l_msg_data;

Line 8102: x_msg_count := FND_MSG_PUB.count_msg;

8098: ,x_msg_data => x_msg_data
8099: );
8100:
8101: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
8102: x_msg_count := FND_MSG_PUB.count_msg;
8103: If x_msg_count = 1 then
8104: pa_interface_utils_pub.get_messages
8105: (p_encoded => FND_API.G_TRUE,
8106: p_msg_index => 1,

Line 8217: l_msg_count := FND_MSG_PUB.count_msg;

8213: x_planning_end_tbl => l_planning_end_tbl,
8214: x_return_status => l_return_status);
8215:
8216: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8217: l_msg_count := FND_MSG_PUB.count_msg;
8218: IF l_msg_count > 0 THEN
8219: x_msg_count := l_msg_count;
8220: IF x_msg_count = 1 THEN
8221: x_msg_data := l_msg_data;

Line 8243: x_msg_count := FND_MSG_PUB.count_msg;

8239: x_msg_count => l_msg_count,
8240: x_msg_data => l_msg_data);
8241:
8242: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
8243: x_msg_count := FND_MSG_PUB.count_msg;
8244: if x_msg_count = 1 then
8245: pa_interface_utils_pub.get_messages
8246: (p_encoded => FND_API.G_TRUE,
8247: p_msg_index => 1,

Line 8305: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8301: );
8302: END IF;
8303: EXCEPTION
8304: WHEN OTHERS THEN
8305: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8306: p_procedure_name => 'update_schedule_version',
8307: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));
8308: RAISE FND_API.G_EXC_ERROR;
8309: END;

Line 8312: x_msg_count := FND_MSG_PUB.count_msg;

8308: RAISE FND_API.G_EXC_ERROR;
8309: END;
8310:
8311: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
8312: x_msg_count := FND_MSG_PUB.count_msg;
8313: if x_msg_count = 1 then
8314: pa_interface_utils_pub.get_messages
8315: (p_encoded => FND_API.G_TRUE,
8316: p_msg_index => 1,

Line 8338: x_msg_count := FND_MSG_PUB.count_msg;

8334: WHEN FND_API.G_EXC_ERROR THEN
8335: IF (p_commit = FND_API.G_TRUE) THEN
8336: ROLLBACK to UPDATE_SCH_VER_PRIVATE;
8337: END IF;
8338: x_msg_count := FND_MSG_PUB.count_msg;
8339: x_return_status := FND_API.G_RET_STS_ERROR;
8340: WHEN OTHERS THEN
8341: IF (p_commit = FND_API.G_TRUE) THEN
8342: ROLLBACK to UPDATE_SCH_VER_PRIVATE;

Line 8345: x_msg_count := FND_MSG_PUB.count_msg;

8341: IF (p_commit = FND_API.G_TRUE) THEN
8342: ROLLBACK to UPDATE_SCH_VER_PRIVATE;
8343: END IF;
8344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8345: x_msg_count := FND_MSG_PUB.count_msg;
8346: --put message
8347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8348: p_procedure_name => 'update_schedule_version',
8349: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 8347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8343: END IF;
8344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8345: x_msg_count := FND_MSG_PUB.count_msg;
8346: --put message
8347: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8348: p_procedure_name => 'update_schedule_version',
8349: p_error_text => SUBSTRB(SQLERRM,1,240));
8350: RAISE;
8351: END Update_Schedule_Version;

Line 8419: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8415: END IF;
8416: EXCEPTION
8417: WHEN OTHERS THEN
8418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8419: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8420: p_procedure_name => 'Inherit_task_type_attr',
8421: p_error_text => SUBSTRB(SQLERRM,1,240));
8422: raise;
8423: END Inherit_task_type_attr;

Line 8537: x_msg_count := FND_MSG_PUB.count_msg;

8533: WHEN FND_API.G_EXC_ERROR THEN
8534: IF (p_commit = FND_API.G_TRUE) THEN
8535: ROLLBACK to update_task_weighting_pvt;
8536: END IF;
8537: x_msg_count := FND_MSG_PUB.count_msg;
8538: x_return_status := FND_API.G_RET_STS_ERROR;
8539: WHEN OTHERS THEN
8540: IF (p_commit = FND_API.G_TRUE) THEN
8541: ROLLBACK to update_task_weighting_pvt;

Line 8544: x_msg_count := FND_MSG_PUB.count_msg;

8540: IF (p_commit = FND_API.G_TRUE) THEN
8541: ROLLBACK to update_task_weighting_pvt;
8542: END IF;
8543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8544: x_msg_count := FND_MSG_PUB.count_msg;
8545: --put message
8546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8547: p_procedure_name => 'Update_Task_Weighting',
8548: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 8546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8542: END IF;
8543: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8544: x_msg_count := FND_MSG_PUB.count_msg;
8545: --put message
8546: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8547: p_procedure_name => 'Update_Task_Weighting',
8548: p_error_text => SUBSTRB(SQLERRM,1,240));
8549: RAISE;
8550: END UPDATE_TASK_WEIGHTING;

Line 8668: x_msg_count := FND_MSG_PUB.count_msg;

8664: ,x_msg_data => l_msg_data
8665: );
8666:
8667: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
8668: x_msg_count := FND_MSG_PUB.count_msg;
8669: if x_msg_count = 1 then
8670: pa_interface_utils_pub.get_messages
8671: (p_encoded => FND_API.G_TRUE,
8672: p_msg_index => 1,

Line 8703: x_msg_count := FND_MSG_PUB.count_msg;

8699: ,x_msg_data => l_msg_data
8700: );
8701:
8702: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
8703: x_msg_count := FND_MSG_PUB.count_msg;
8704: if x_msg_count = 1 then
8705: pa_interface_utils_pub.get_messages
8706: (p_encoded => FND_API.G_TRUE,
8707: p_msg_index => 1,

Line 8723: x_msg_count := FND_MSG_PUB.count_msg;

8719: CLOSE get_child_weighting;
8720:
8721: EXCEPTION
8722: WHEN FND_API.G_EXC_ERROR THEN
8723: x_msg_count := FND_MSG_PUB.count_msg;
8724: x_return_status := FND_API.G_RET_STS_ERROR;
8725: WHEN OTHERS THEN
8726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8727: x_msg_count := FND_MSG_PUB.count_msg;

Line 8727: x_msg_count := FND_MSG_PUB.count_msg;

8723: x_msg_count := FND_MSG_PUB.count_msg;
8724: x_return_status := FND_API.G_RET_STS_ERROR;
8725: WHEN OTHERS THEN
8726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8727: x_msg_count := FND_MSG_PUB.count_msg;
8728: --put message
8729: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8730: p_procedure_name => 'RECALC_TASKS_WEIGHTING',
8731: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 8729: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8725: WHEN OTHERS THEN
8726: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8727: x_msg_count := FND_MSG_PUB.count_msg;
8728: --put message
8729: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8730: p_procedure_name => 'RECALC_TASKS_WEIGHTING',
8731: p_error_text => SUBSTRB(SQLERRM,1,240));
8732: RAISE;
8733: END RECALC_TASKS_WEIGHTING;

Line 8793: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

8789: x_return_status := FND_API.G_RET_STS_SUCCESS;
8790: EXCEPTION
8791: WHEN OTHERS THEN
8792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8793: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
8794: p_procedure_name => 'update_task_ver_delete_status',
8795: p_error_text => SUBSTRB(SQLERRM,1,240));
8796: raise;
8797: END update_task_ver_delete_status;

Line 9119: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

9115: ,x_msg_count => x_msg_count
9116: ,x_msg_data => x_msg_data);
9117: EXCEPTION
9118: WHEN OTHERS THEN
9119: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9120: p_procedure_name => 'delete_Task_ver_wo_val',
9121: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
9122: RAISE FND_API.G_EXC_ERROR;
9123: END;

Line 9238: -- x_msg_count := FND_MSG_PUB.count_msg;

9234: -- ,x_msg_count => l_msg_count
9235: -- ,x_msg_data => l_msg_data
9236: -- );
9237: -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9238: -- x_msg_count := FND_MSG_PUB.count_msg;
9239: -- IF x_msg_count = 1 then
9240: -- pa_interface_utils_pub.get_messages
9241: -- (p_encoded => FND_API.G_TRUE,
9242: -- p_msg_index => 1,

Line 9298: x_msg_count := FND_MSG_PUB.count_msg;

9294: END IF;
9295:
9296:
9297: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9298: x_msg_count := FND_MSG_PUB.count_msg;
9299: IF x_msg_count = 1 then
9300: pa_interface_utils_pub.get_messages
9301: (p_encoded => FND_API.G_TRUE,
9302: p_msg_index => 1,

Line 9331: x_msg_count := FND_MSG_PUB.count_msg;

9327: ,x_msg_data => l_msg_data
9328: );
9329:
9330: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9331: x_msg_count := FND_MSG_PUB.count_msg;
9332: IF x_msg_count = 1 then
9333: pa_interface_utils_pub.get_messages
9334: (p_encoded => FND_API.G_TRUE,
9335: p_msg_index => 1,

Line 9362: x_msg_count := FND_MSG_PUB.count_msg;

9358: ,p_parent_task_id => l_parent_task_verion_id
9359: ,x_return_status => l_return_status );
9360:
9361: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9362: x_msg_count := FND_MSG_PUB.count_msg;
9363: IF x_msg_count = 1 then
9364: pa_interface_utils_pub.get_messages
9365: (p_encoded => FND_API.G_TRUE,
9366: p_msg_index => 1,

Line 9426: l_msg_count := FND_MSG_PUB.count_msg;

9422: ,x_return_status => l_return_status
9423: ,x_msg_count => l_msg_count
9424: ,x_msg_data => l_msg_data );
9425:
9426: l_msg_count := FND_MSG_PUB.count_msg;
9427:
9428: IF l_msg_count > 0 THEN
9429: x_msg_count := l_msg_count;
9430: x_return_status := 'E';

Line 9450: x_msg_count := FND_MSG_PUB.count_msg;

9446: ,x_msg_data => l_msg_data
9447: );
9448:
9449: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9450: x_msg_count := FND_MSG_PUB.count_msg;
9451: if x_msg_count = 1 then
9452: pa_interface_utils_pub.get_messages
9453: (p_encoded => FND_API.G_TRUE,
9454: p_msg_index => 1,

Line 9492: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

9488: ,x_msg_count => x_msg_count
9489: ,x_msg_data => x_msg_data);
9490: EXCEPTION
9491: WHEN OTHERS THEN
9492: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9493: p_procedure_name => 'delete_Task_ver_wo_val',
9494: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
9495: RAISE FND_API.G_EXC_ERROR;
9496: END;

Line 9535: x_msg_count := FND_MSG_PUB.count_msg;

9531: x_msg_count => l_msg_count,
9532: x_msg_data => l_msg_data);
9533:
9534: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9535: x_msg_count := FND_MSG_PUB.count_msg;
9536: if x_msg_count = 1 then
9537: pa_interface_utils_pub.get_messages
9538: (p_encoded => FND_API.G_TRUE,
9539: p_msg_index => 1,

Line 9570: x_msg_count := FND_MSG_PUB.count_msg;

9566: ,x_msg_data => l_msg_data
9567: );
9568:
9569: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9570: x_msg_count := FND_MSG_PUB.count_msg;
9571: if x_msg_count = 1 then
9572: pa_interface_utils_pub.get_messages
9573: (p_encoded => FND_API.G_TRUE,
9574: p_msg_index => 1,

Line 9599: x_msg_count := FND_MSG_PUB.count_msg;

9595: ,x_msg_data => l_msg_data
9596: );
9597:
9598: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9599: x_msg_count := FND_MSG_PUB.count_msg;
9600: if x_msg_count = 1 then
9601: pa_interface_utils_pub.get_messages
9602: (p_encoded => FND_API.G_TRUE,
9603: p_msg_index => 1,

Line 9633: x_msg_count := FND_MSG_PUB.count_msg;

9629: ,x_msg_count => l_msg_count
9630: ,x_msg_data => l_msg_data);
9631:
9632: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9633: x_msg_count := FND_MSG_PUB.count_msg;
9634: if x_msg_count = 1 then
9635: pa_interface_utils_pub.get_messages
9636: (p_encoded => FND_API.G_TRUE,
9637: p_msg_index => 1,

Line 9655: x_msg_count := FND_MSG_PUB.count_msg;

9651: WHEN FND_API.G_EXC_ERROR THEN
9652: IF (p_commit = FND_API.G_TRUE) THEN
9653: ROLLBACK to DELETE_TASK_VER_WO_VAL;
9654: END IF;
9655: x_msg_count := FND_MSG_PUB.count_msg;
9656: x_return_status := FND_API.G_RET_STS_ERROR;
9657: WHEN OTHERS THEN
9658: IF (p_commit = FND_API.G_TRUE) THEN
9659: ROLLBACK to DELETE_TASK_VER_WO_VAL;

Line 9662: x_msg_count := FND_MSG_PUB.count_msg;

9658: IF (p_commit = FND_API.G_TRUE) THEN
9659: ROLLBACK to DELETE_TASK_VER_WO_VAL;
9660: END IF;
9661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9662: x_msg_count := FND_MSG_PUB.count_msg;
9663: --put message
9664: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9665: p_procedure_name => 'delete_Task_ver_wo_val',
9666: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 9664: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

9660: END IF;
9661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9662: x_msg_count := FND_MSG_PUB.count_msg;
9663: --put message
9664: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9665: p_procedure_name => 'delete_Task_ver_wo_val',
9666: p_error_text => SUBSTRB(SQLERRM,1,240));
9667: RAISE;
9668: END delete_task_ver_wo_val;

Line 9769: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

9765: WHEN FND_API.G_EXC_ERROR THEN
9766: x_return_status := FND_API.G_RET_STS_ERROR;
9767: WHEN OTHERS THEN
9768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9769: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9770: p_procedure_name => 'UPDATE_WORKING_VER_WEIGHT',
9771: p_error_text => SUBSTRB(SQLERRM,1,240));
9772: RAISE;
9773: END UPDATE_WORKING_VER_WEIGHT;

Line 9948: x_msg_count := FND_MSG_PUB.count_msg;

9944: /* Bug 2790703 End */
9945:
9946:
9947: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9948: x_msg_count := FND_MSG_PUB.count_msg;
9949: if x_msg_count = 1 then
9950: pa_interface_utils_pub.get_messages
9951: (p_encoded => FND_API.G_TRUE,
9952: p_msg_index => 1,

Line 9967: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

9963: WHEN FND_API.G_EXC_ERROR THEN
9964: x_return_status := FND_API.G_RET_STS_ERROR;
9965: WHEN OTHERS THEN
9966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9967: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9968: p_procedure_name => 'set_new_tasks_to_TBD',
9969: p_error_text => SUBSTRB(SQLERRM,1,240));
9970: RAISE;
9971: END set_new_tasks_to_TBD;

Line 10070: x_msg_count := FND_MSG_PUB.count_msg;

10066: WHEN FND_API.G_EXC_ERROR THEN
10067: IF (p_commit = FND_API.G_TRUE) THEN
10068: ROLLBACK to UPDATE_SCH_VER_PRIVATE_DATES;
10069: END IF;
10070: x_msg_count := FND_MSG_PUB.count_msg;
10071: x_return_status := FND_API.G_RET_STS_ERROR;
10072: WHEN OTHERS THEN
10073: IF (p_commit = FND_API.G_TRUE) THEN
10074: ROLLBACK to UPDATE_SCH_VER_PRIVATE_DATES;

Line 10077: x_msg_count := FND_MSG_PUB.count_msg;

10073: IF (p_commit = FND_API.G_TRUE) THEN
10074: ROLLBACK to UPDATE_SCH_VER_PRIVATE_DATES;
10075: END IF;
10076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10077: x_msg_count := FND_MSG_PUB.count_msg;
10078: --put message
10079: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10080: p_procedure_name => 'Update_Dates_To_All_Versions',
10081: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 10079: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',

10075: END IF;
10076: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10077: x_msg_count := FND_MSG_PUB.count_msg;
10078: --put message
10079: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10080: p_procedure_name => 'Update_Dates_To_All_Versions',
10081: p_error_text => SUBSTRB(SQLERRM,1,240));
10082: RAISE;
10083: END Update_Dates_To_All_Versions;