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 497: l_msg_count := FND_MSG_PUB.count_msg;

493: --Name is not unique
494: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_TASK_NUMBER_UNIQUE');
495: l_msg_data := 'PA_PS_TASK_NUMBER_UNIQUE';
496: /* bug 3459905 Check if there is any error. */
497: l_msg_count := FND_MSG_PUB.count_msg;
498: IF l_msg_count > 0 THEN
499: x_msg_count := l_msg_count;
500: IF x_msg_count = 1 THEN
501: x_msg_data := l_msg_data;

Line 508: l_msg_count := FND_MSG_PUB.count_msg;

504: /* end of 3458052*/
505: END IF;
506:
507: /* bug 3459905 --Check if there is any error.
508: l_msg_count := FND_MSG_PUB.count_msg;
509: IF l_msg_count > 0 THEN
510: x_msg_count := l_msg_count;
511: IF x_msg_count = 1 THEN
512: x_msg_data := l_msg_data;

Line 1080: x_msg_count := FND_MSG_PUB.count_msg;

1076: ,x_msg_data => l_msg_data
1077: );
1078:
1079: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1080: x_msg_count := FND_MSG_PUB.count_msg;
1081: IF x_msg_count = 1 then
1082: pa_interface_utils_pub.get_messages
1083: (p_encoded => FND_API.G_TRUE,
1084: p_msg_index => 1,

Line 1192: l_msg_count := FND_MSG_PUB.count_msg;

1188: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_INV_REF_TASK_ID');
1189: l_msg_data := 'PA_PS_INV_REF_TASK_ID';
1190: -- start of bug 3459905
1191: --Check if there is any error.
1192: l_msg_count := FND_MSG_PUB.count_msg;
1193: IF l_msg_count > 0 THEN
1194: x_msg_count := l_msg_count;
1195: IF x_msg_count = 1 THEN
1196: x_msg_data := l_msg_data;

Line 1204: l_msg_count := FND_MSG_PUB.count_msg;

1200: -- end of bug 3459905
1201: END IF;
1202:
1203: /* bug 3459905 --Check if there is any error.
1204: l_msg_count := FND_MSG_PUB.count_msg;
1205: IF l_msg_count > 0 THEN
1206: x_msg_count := l_msg_count;
1207: IF x_msg_count = 1 THEN
1208: x_msg_data := l_msg_data;

Line 1305: x_msg_count := FND_MSG_PUB.count_msg;

1301: -- end xxlu changes
1302:
1303: --dbms_output.put_line( 'l_msg_data '||l_msg_data );
1304: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1305: x_msg_count := FND_MSG_PUB.count_msg;
1306: IF x_msg_count = 1 then
1307: pa_interface_utils_pub.get_messages
1308: (p_encoded => FND_API.G_TRUE,
1309: p_msg_index => 1,

Line 1343: x_msg_count := FND_MSG_PUB.count_msg;

1339: , x_msg_count => l_msg_count
1340: );
1341:
1342: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1343: x_msg_count := FND_MSG_PUB.count_msg;
1344: IF x_msg_count = 1 then
1345: pa_interface_utils_pub.get_messages
1346: (p_encoded => FND_API.G_TRUE,
1347: p_msg_index => 1,

Line 1408: x_msg_count := FND_MSG_PUB.count_msg;

1404: , x_msg_count => l_msg_count
1405: );
1406:
1407: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1408: x_msg_count := FND_MSG_PUB.count_msg;
1409: IF x_msg_count = 1 then
1410: pa_interface_utils_pub.get_messages
1411: (p_encoded => FND_API.G_TRUE,
1412: p_msg_index => 1,

Line 1435: x_msg_count := FND_MSG_PUB.count_msg;

1431: WHEN FND_API.G_EXC_ERROR THEN
1432: IF (p_commit = FND_API.G_TRUE) THEN
1433: ROLLBACK to CREATE_TASK_PRIVATE;
1434: END IF;
1435: x_msg_count := FND_MSG_PUB.count_msg;
1436: x_return_status := FND_API.G_RET_STS_ERROR;
1437: WHEN OTHERS THEN
1438: IF (p_commit = FND_API.G_TRUE) THEN
1439: ROLLBACK to CREATE_TASK_PRIVATE;

Line 1442: x_msg_count := FND_MSG_PUB.count_msg;

1438: IF (p_commit = FND_API.G_TRUE) THEN
1439: ROLLBACK to CREATE_TASK_PRIVATE;
1440: END IF;
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: x_msg_count := FND_MSG_PUB.count_msg;
1443: --put message
1444: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
1445: p_procedure_name => 'Create_Task',
1446: p_error_text => SUBSTRB(SQLERRM,1,240));

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

1440: END IF;
1441: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1442: x_msg_count := FND_MSG_PUB.count_msg;
1443: --put message
1444: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
1445: p_procedure_name => 'Create_Task',
1446: p_error_text => SUBSTRB(SQLERRM,1,240));
1447: RAISE;
1448:

Line 1984: l_msg_count := FND_MSG_PUB.count_msg;

1980: --Name is not unique
1981: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_TASK_NUMBER_UNIQUE');
1982: l_msg_data := 'PA_PS_TASK_NUMBER_UNIQUE';
1983: -- start of bug 3459905
1984: l_msg_count := FND_MSG_PUB.count_msg;
1985: IF l_msg_count > 0 THEN
1986: x_msg_count := l_msg_count;
1987: IF x_msg_count = 1 THEN
1988: x_msg_data := l_msg_data;

Line 1999: l_msg_count := FND_MSG_PUB.count_msg;

1995: /** Code above is uncommented for bug 4218947 **/
1996: --dbms_output.put_line(( 'After Check if the task name is unique within the project.' );
1997:
1998: /* start of bug 3459905 --Check if there is any error.
1999: l_msg_count := FND_MSG_PUB.count_msg;
2000: IF l_msg_count > 0 THEN
2001: x_msg_count := l_msg_count;
2002: IF x_msg_count = 1 THEN
2003: x_msg_data := l_msg_data;

Line 2021: l_msg_count := FND_MSG_PUB.count_msg;

2017: --Is not a top task across all versions. Error
2018: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_NOT_ALL_TOP_TASKS');
2019: -- start of bug 3459905
2020: --Check if there is any error.
2021: l_msg_count := FND_MSG_PUB.count_msg;
2022: IF l_msg_count > 0 THEN
2023: x_msg_count := l_msg_count;
2024: IF x_msg_count = 1 THEN
2025: x_msg_data := l_msg_data;

Line 2040: l_msg_count := FND_MSG_PUB.count_msg;

2036: -- Phase already in use in the structure. Error
2037: PA_UTILS.ADD_MESSAGE('PA', 'PA_LC_PHASE_IN_USE');
2038: -- start of bug 3459905
2039: --Check if there is any error.
2040: l_msg_count := FND_MSG_PUB.count_msg;
2041: IF l_msg_count > 0 THEN
2042: x_msg_count := l_msg_count;
2043: IF x_msg_count = 1 THEN
2044: x_msg_data := l_msg_data;

Line 2052: l_msg_count := FND_MSG_PUB.count_msg;

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

Line 2141: l_msg_count := FND_MSG_PUB.count_msg;

2137: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_CHG_TASK_TYPE_ERR');
2138: l_msg_data := 'PA_PS_CHG_TASK_TYPE_ERR';
2139: --Check if there is any error.
2140: -- start of bug 3459905
2141: l_msg_count := FND_MSG_PUB.count_msg;
2142: IF l_msg_count > 0 THEN
2143: x_msg_count := l_msg_count;
2144: IF x_msg_count = 1 THEN
2145: x_msg_data := l_msg_data;

Line 2157: l_msg_count := FND_MSG_PUB.count_msg;

2153: PA_UTILS.ADD_MESSAGE('PA', 'PA_PS_EFF_TASK_TYPE_ERR');
2154: l_msg_data := 'PA_PS_EFF_TASK_TYPE_ERR';
2155: -- start of bug 3459905
2156: --Check if there is any error.
2157: l_msg_count := FND_MSG_PUB.count_msg;
2158: IF l_msg_count > 0 THEN
2159: x_msg_count := l_msg_count;
2160: IF x_msg_count = 1 THEN
2161: x_msg_data := l_msg_data;

Line 2169: l_msg_count := FND_MSG_PUB.count_msg;

2165: -- end of bug 3459905
2166: END IF;
2167: /* start of bug 3459905
2168: --Check if there is any error.
2169: l_msg_count := FND_MSG_PUB.count_msg;
2170: IF l_msg_count > 0 THEN
2171: x_msg_count := l_msg_count;
2172: IF x_msg_count = 1 THEN
2173: x_msg_data := l_msg_data;

Line 2213: l_msg_count := FND_MSG_PUB.count_msg;

2209: ,x_msg_count => l_msg_count
2210: ,x_msg_data => l_msg_data);
2211:
2212: --Check if there is any error.
2213: l_msg_count := FND_MSG_PUB.count_msg;
2214: IF l_msg_count > 0 THEN
2215: x_msg_count := l_msg_count;
2216: IF x_msg_count = 1 THEN
2217: x_msg_data := l_msg_data;

Line 2272: l_msg_count := FND_MSG_PUB.count_msg;

2268: x_msg_data => l_msg_data
2269: );
2270:
2271: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2272: l_msg_count := FND_MSG_PUB.count_msg;
2273: IF l_msg_count > 0 THEN
2274: x_msg_count := l_msg_count;
2275: IF x_msg_count = 1 THEN
2276: x_msg_data := l_msg_data;

Line 2306: l_msg_count := FND_MSG_PUB.count_msg;

2302: x_msg_data => l_msg_data
2303: );
2304:
2305: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2306: l_msg_count := FND_MSG_PUB.count_msg;
2307: IF l_msg_count > 0 THEN
2308: x_msg_count := l_msg_count;
2309: IF x_msg_count = 1 THEN
2310: x_msg_data := l_msg_data;

Line 2725: x_msg_count := FND_MSG_PUB.count_msg;

2721: ,x_msg_data => l_msg_data
2722: );
2723:
2724: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2725: x_msg_count := FND_MSG_PUB.count_msg;
2726: IF x_msg_count = 1 then
2727: pa_interface_utils_pub.get_messages
2728: (p_encoded => FND_API.G_TRUE,
2729: p_msg_index => 1,

Line 2850: l_msg_count := FND_MSG_PUB.count_msg;

2846: ,x_return_status => l_return_status
2847: ,x_msg_count => l_msg_count
2848: ,x_msg_data => l_msg_data );
2849:
2850: l_msg_count := FND_MSG_PUB.count_msg;
2851:
2852: IF l_msg_count > 0 THEN
2853: x_msg_count := l_msg_count;
2854: x_return_status := 'E';

Line 2870: l_msg_count := FND_MSG_PUB.count_msg;

2866: ,x_msg_count => l_msg_count
2867: ,x_msg_data => l_msg_data);
2868:
2869: --Check if there is any error.
2870: l_msg_count := FND_MSG_PUB.count_msg;
2871: IF l_msg_count > 0 THEN
2872: x_msg_count := l_msg_count;
2873: IF x_msg_count = 1 THEN
2874: x_msg_data := l_msg_data;

Line 3064: x_msg_count := FND_MSG_PUB.count_msg;

3060: END IF;
3061: END IF;
3062:
3063: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3064: x_msg_count := FND_MSG_PUB.count_msg;
3065: IF x_msg_count = 1 then
3066: pa_interface_utils_pub.get_messages
3067: (p_encoded => FND_API.G_TRUE,
3068: p_msg_index => 1,

Line 3101: x_msg_count := FND_MSG_PUB.count_msg;

3097: ,x_msg_data => l_msg_data
3098: );
3099:
3100: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3101: x_msg_count := FND_MSG_PUB.count_msg;
3102: IF x_msg_count = 1 then
3103: pa_interface_utils_pub.get_messages
3104: (p_encoded => FND_API.G_TRUE,
3105: p_msg_index => 1,

Line 3143: x_msg_count := FND_MSG_PUB.count_msg;

3139: ,x_msg_data => l_msg_data
3140: );
3141:
3142: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3143: x_msg_count := FND_MSG_PUB.count_msg;
3144: IF x_msg_count = 1 then
3145: pa_interface_utils_pub.get_messages
3146: (p_encoded => FND_API.G_TRUE,
3147: p_msg_index => 1,

Line 3168: x_msg_count := FND_MSG_PUB.count_msg;

3164: ,x_msg_count => l_msg_count
3165: ,x_msg_data => l_msg_data
3166: );
3167: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3168: x_msg_count := FND_MSG_PUB.count_msg;
3169: IF x_msg_count = 1 then
3170: pa_interface_utils_pub.get_messages
3171: (p_encoded => FND_API.G_TRUE,
3172: p_msg_index => 1,

Line 3192: x_msg_count := FND_MSG_PUB.count_msg;

3188: WHEN FND_API.G_EXC_ERROR THEN
3189: IF (p_commit = FND_API.G_TRUE) THEN
3190: ROLLBACK to UPDATE_TASK_PRIVATE;
3191: END IF;
3192: x_msg_count := FND_MSG_PUB.count_msg;
3193: x_return_status := FND_API.G_RET_STS_ERROR;
3194: WHEN OTHERS THEN
3195: IF (p_commit = FND_API.G_TRUE) THEN
3196: ROLLBACK to UPDATE_TASK_PRIVATE;

Line 3199: x_msg_count := FND_MSG_PUB.count_msg;

3195: IF (p_commit = FND_API.G_TRUE) THEN
3196: ROLLBACK to UPDATE_TASK_PRIVATE;
3197: END IF;
3198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3199: x_msg_count := FND_MSG_PUB.count_msg;
3200: --put message
3201: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
3202: p_procedure_name => 'update_Task',
3203: p_error_text => SUBSTRB(SQLERRM,1,240));

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

3197: END IF;
3198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3199: x_msg_count := FND_MSG_PUB.count_msg;
3200: --put message
3201: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
3202: p_procedure_name => 'update_Task',
3203: p_error_text => SUBSTRB(SQLERRM,1,240));
3204: RAISE;
3205: END Update_Task;

Line 3893: x_msg_count := FND_MSG_PUB.count_msg;

3889: WHEN FND_API.G_EXC_ERROR THEN
3890: IF (p_commit = FND_API.G_TRUE) THEN
3891: ROLLBACK to CREATE_TASK_VER_PRIVATE;
3892: END IF;
3893: x_msg_count := FND_MSG_PUB.count_msg;
3894: x_return_status := FND_API.G_RET_STS_ERROR;
3895:
3896: -- --dbms_output.put_line( 'In exception ');
3897: -- --dbms_output.put_line( 'Status In exception ' ||x_return_status);

Line 3905: x_msg_count := FND_MSG_PUB.count_msg;

3901: IF (p_commit = FND_API.G_TRUE) THEN
3902: ROLLBACK to CREATE_TASK_VER_PRIVATE;
3903: END IF;
3904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3905: x_msg_count := FND_MSG_PUB.count_msg;
3906: --put message
3907: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
3908: p_procedure_name => 'create_Task_version',
3909: p_error_text => SUBSTRB(SQLERRM,1,240));

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

3903: END IF;
3904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3905: x_msg_count := FND_MSG_PUB.count_msg;
3906: --put message
3907: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
3908: p_procedure_name => 'create_Task_version',
3909: p_error_text => SUBSTRB(SQLERRM,1,240));
3910: RAISE;
3911:

Line 4704: x_msg_count := FND_MSG_PUB.count_msg;

4700: ,x_msg_count => l_msg_count
4701: ,x_msg_data => l_msg_data
4702: );
4703: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4704: x_msg_count := FND_MSG_PUB.count_msg;
4705: IF x_msg_count = 1 then
4706: pa_interface_utils_pub.get_messages
4707: (p_encoded => FND_API.G_TRUE,
4708: p_msg_index => 1,

Line 4867: x_msg_count := FND_MSG_PUB.count_msg;

4863: ,x_msg_data => l_msg_data
4864: );
4865:
4866: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4867: x_msg_count := FND_MSG_PUB.count_msg;
4868: IF x_msg_count = 1 then
4869: pa_interface_utils_pub.get_messages
4870: (p_encoded => FND_API.G_TRUE,
4871: p_msg_index => 1,

Line 4922: x_msg_count := FND_MSG_PUB.count_msg;

4918: ,x_msg_data => x_msg_data
4919: );
4920:
4921: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4922: x_msg_count := FND_MSG_PUB.count_msg;
4923: IF x_msg_count = 1 then
4924: pa_interface_utils_pub.get_messages
4925: (p_encoded => FND_API.G_TRUE,
4926: p_msg_index => 1,

Line 4948: x_msg_count := FND_MSG_PUB.count_msg;

4944: ,x_msg_count => l_msg_count
4945: ,x_msg_data => l_msg_data
4946: );
4947:
4948: x_msg_count := FND_MSG_PUB.count_msg;
4949: IF x_msg_count = 1 then
4950: pa_interface_utils_pub.get_messages
4951: (p_encoded => FND_API.G_TRUE,
4952: p_msg_index => 1,

Line 4968: x_msg_count := FND_MSG_PUB.count_msg;

4964: ,x_msg_count => l_msg_count
4965: ,x_msg_data => l_msg_data
4966: );
4967:
4968: x_msg_count := FND_MSG_PUB.count_msg;
4969: IF x_msg_count = 1 then
4970: pa_interface_utils_pub.get_messages
4971: (p_encoded => FND_API.G_TRUE,
4972: p_msg_index => 1,

Line 5273: x_msg_count := FND_MSG_PUB.count_msg;

5269: WHEN FND_API.G_EXC_ERROR THEN
5270: IF (p_commit = FND_API.G_TRUE) THEN
5271: ROLLBACK to UPDATE_TASK_VER_PRIVATE;
5272: END IF;
5273: x_msg_count := FND_MSG_PUB.count_msg;
5274: x_return_status := FND_API.G_RET_STS_ERROR;
5275: WHEN OTHERS THEN
5276: IF (p_commit = FND_API.G_TRUE) THEN
5277: ROLLBACK to UPDATE_TASK_VER_PRIVATE;

Line 5280: x_msg_count := FND_MSG_PUB.count_msg;

5276: IF (p_commit = FND_API.G_TRUE) THEN
5277: ROLLBACK to UPDATE_TASK_VER_PRIVATE;
5278: END IF;
5279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5280: x_msg_count := FND_MSG_PUB.count_msg;
5281: --put message
5282: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
5283: p_procedure_name => 'update_Task_version',
5284: p_error_text => SUBSTRB(SQLERRM,1,240));

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

5278: END IF;
5279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5280: x_msg_count := FND_MSG_PUB.count_msg;
5281: --put message
5282: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
5283: p_procedure_name => 'update_Task_version',
5284: p_error_text => SUBSTRB(SQLERRM,1,240));
5285: RAISE;
5286: END update_task_version;

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

5748: ,x_msg_count => x_msg_count
5749: ,x_msg_data => x_msg_data);
5750: EXCEPTION
5751: WHEN OTHERS THEN
5752: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
5753: p_procedure_name => 'delete_Task_version',
5754: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
5755: RAISE FND_API.G_EXC_ERROR;
5756: END;

Line 5819: x_msg_count := FND_MSG_PUB.count_msg;

5815: ,x_msg_count => x_msg_count
5816: ,x_msg_data => x_msg_data);
5817:
5818: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
5819: x_msg_count := FND_MSG_PUB.count_msg;
5820: If x_msg_count = 1 then
5821: pa_interface_utils_pub.get_messages
5822: (p_encoded => FND_API.G_TRUE,
5823: p_msg_index => 1,

Line 5868: x_msg_count := FND_MSG_PUB.count_msg;

5864: ,x_return_status => l_return_status
5865: ,x_msg_count => l_msg_count
5866: ,x_msg_data => l_msg_data);
5867: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5868: x_msg_count := FND_MSG_PUB.count_msg;
5869: IF x_msg_count = 1 then
5870: pa_interface_utils_pub.get_messages(
5871: p_encoded => FND_API.G_TRUE,
5872: p_msg_index => 1,

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

5991: ,x_msg_count => x_msg_count
5992: ,x_msg_data => x_msg_data);
5993: EXCEPTION
5994: WHEN OTHERS THEN
5995: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
5996: p_procedure_name => 'delete_Task_version',
5997: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
5998: RAISE FND_API.G_EXC_ERROR;
5999: END;

Line 6113: x_msg_count := FND_MSG_PUB.count_msg;

6109: ,x_msg_data => x_msg_data
6110: );
6111:
6112: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
6113: x_msg_count := FND_MSG_PUB.count_msg;
6114: If x_msg_count = 1 then
6115: pa_interface_utils_pub.get_messages
6116: (p_encoded => FND_API.G_TRUE,
6117: p_msg_index => 1,

Line 6165: x_msg_count := FND_MSG_PUB.count_msg;

6161: , x_msg_count => l_msg_count
6162: );
6163:
6164: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6165: x_msg_count := FND_MSG_PUB.count_msg;
6166: IF x_msg_count = 1 then
6167: pa_interface_utils_pub.get_messages
6168: (p_encoded => FND_API.G_TRUE,
6169: p_msg_index => 1,

Line 6207: x_msg_count := FND_MSG_PUB.count_msg;

6203: ,x_msg_count => l_msg_count
6204: ,x_msg_data => l_msg_data
6205: );
6206: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6207: x_msg_count := FND_MSG_PUB.count_msg;
6208: IF x_msg_count = 1 then
6209: pa_interface_utils_pub.get_messages
6210: (p_encoded => FND_API.G_TRUE,
6211: p_msg_index => 1,

Line 6271: x_msg_count := FND_MSG_PUB.count_msg;

6267: pa_debug.write('PA_TASK_PVT1.DELETE_TASK_VERSION', 'After PA_RELATIONSHIP_PUB.Delete_SubProject_Association l_return_status='||l_return_status, 3);
6268: END IF;
6269:
6270: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6271: x_msg_count := FND_MSG_PUB.count_msg;
6272: IF x_msg_count = 1 then
6273: pa_interface_utils_pub.get_messages
6274: (p_encoded => FND_API.G_TRUE,
6275: p_msg_index => 1,

Line 6306: x_msg_count := FND_MSG_PUB.count_msg;

6302: ,x_msg_data => l_msg_data
6303: );
6304:
6305: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6306: x_msg_count := FND_MSG_PUB.count_msg;
6307: IF x_msg_count = 1 then
6308: pa_interface_utils_pub.get_messages
6309: (p_encoded => FND_API.G_TRUE,
6310: p_msg_index => 1,

Line 6340: x_msg_count := FND_MSG_PUB.count_msg;

6336: ,p_parent_task_id => l_parent_task_verion_id
6337: ,x_return_status => l_return_status );
6338:
6339: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6340: x_msg_count := FND_MSG_PUB.count_msg;
6341: IF x_msg_count = 1 then
6342: pa_interface_utils_pub.get_messages
6343: (p_encoded => FND_API.G_TRUE,
6344: p_msg_index => 1,

Line 6478: l_msg_count := FND_MSG_PUB.count_msg;

6474: ,x_return_status => l_return_status
6475: ,x_msg_count => l_msg_count
6476: ,x_msg_data => l_msg_data );
6477:
6478: l_msg_count := FND_MSG_PUB.count_msg;
6479:
6480: IF l_msg_count > 0 THEN
6481: x_msg_count := l_msg_count;
6482: x_return_status := 'E';

Line 6494: l_msg_count := FND_MSG_PUB.count_msg;

6490: ,x_return_status => l_return_status
6491: ,x_msg_count => l_msg_count
6492: ,x_msg_data => l_msg_data
6493: );
6494: l_msg_count := FND_MSG_PUB.count_msg;
6495:
6496: IF l_msg_count > 0 THEN
6497: x_msg_count := l_msg_count;
6498: x_return_status := 'E';

Line 6546: fnd_msg_pub.add_exc_msg(

6542: EXCEPTION
6543:
6544: WHEN OTHERS THEN
6545:
6546: fnd_msg_pub.add_exc_msg(
6547: p_pkg_name => 'PA_TASK_PVT1',
6548: p_procedure_name => 'Delete_Task_Version',
6549: p_error_text => SUBSTRB('PA_PROGRESS_PUB.delete_working_wp_progress:'||SQLERRM,1,240));
6550:

Line 6585: fnd_msg_pub.add_exc_msg(

6581: EXCEPTION
6582:
6583: WHEN OTHERS THEN
6584:
6585: fnd_msg_pub.add_exc_msg(
6586: p_pkg_name => 'PA_TASK_PVT1',
6587: p_procedure_name => 'Delete_Task_Version',
6588: p_error_text => SUBSTRB('PA_PROGRESS_PUB.delete_working_wp_progress:'||SQLERRM,1,240));
6589:

Line 6644: x_msg_count := FND_MSG_PUB.count_msg;

6640: x_msg_count => l_msg_count,
6641: x_msg_data => l_msg_data);
6642:
6643: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6644: x_msg_count := FND_MSG_PUB.count_msg;
6645: if x_msg_count = 1 then
6646: pa_interface_utils_pub.get_messages
6647: (p_encoded => FND_API.G_TRUE,
6648: p_msg_index => 1,

Line 6748: x_msg_count := FND_MSG_PUB.count_msg;

6744: ,x_msg_data => l_msg_data
6745: );
6746:
6747: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6748: x_msg_count := FND_MSG_PUB.count_msg;
6749: if x_msg_count = 1 then
6750: pa_interface_utils_pub.get_messages
6751: (p_encoded => FND_API.G_TRUE,
6752: p_msg_index => 1,

Line 6782: x_msg_count := FND_MSG_PUB.count_msg;

6778: ,x_msg_data => l_msg_data
6779: );
6780:
6781: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6782: x_msg_count := FND_MSG_PUB.count_msg;
6783: if x_msg_count = 1 then
6784: pa_interface_utils_pub.get_messages
6785: (p_encoded => FND_API.G_TRUE,
6786: p_msg_index => 1,

Line 6825: x_msg_count := FND_MSG_PUB.count_msg;

6821: ,x_msg_count => l_msg_count
6822: ,x_msg_data => l_msg_data);
6823:
6824: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
6825: x_msg_count := FND_MSG_PUB.count_msg;
6826: if x_msg_count = 1 then
6827: pa_interface_utils_pub.get_messages
6828: (p_encoded => FND_API.G_TRUE,
6829: p_msg_index => 1,

Line 6851: x_msg_count := FND_MSG_PUB.count_msg;

6847: WHEN FND_API.G_EXC_ERROR THEN
6848: IF (p_commit = FND_API.G_TRUE) THEN
6849: ROLLBACK to DELETE_TASK_VER_PRIVATE;
6850: END IF;
6851: x_msg_count := FND_MSG_PUB.count_msg;
6852: x_return_status := FND_API.G_RET_STS_ERROR;
6853: WHEN OTHERS THEN
6854: IF (p_commit = FND_API.G_TRUE) THEN
6855: ROLLBACK to DELETE_TASK_VER_PRIVATE;

Line 6858: x_msg_count := FND_MSG_PUB.count_msg;

6854: IF (p_commit = FND_API.G_TRUE) THEN
6855: ROLLBACK to DELETE_TASK_VER_PRIVATE;
6856: END IF;
6857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6858: x_msg_count := FND_MSG_PUB.count_msg;
6859: --put message
6860: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
6861: p_procedure_name => 'delete_Task_version',
6862: p_error_text => SUBSTRB(SQLERRM,1,240));

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

6856: END IF;
6857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6858: x_msg_count := FND_MSG_PUB.count_msg;
6859: --put message
6860: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
6861: p_procedure_name => 'delete_Task_version',
6862: p_error_text => SUBSTRB(SQLERRM,1,240));
6863: RAISE;
6864: END delete_task_version;

Line 7374: l_msg_count := FND_MSG_PUB.count_msg;

7370: ,x_msg_data => l_msg_data
7371: );
7372:
7373: IF (l_return_status <> 'S') THEN
7374: l_msg_count := FND_MSG_PUB.count_msg;
7375: IF l_msg_count > 0 THEN
7376: x_msg_count := l_msg_count;
7377: IF x_msg_count = 1 THEN
7378: x_msg_data := l_msg_data;

Line 7431: l_msg_count := FND_MSG_PUB.count_msg;

7427: ,x_msg_count => l_msg_count
7428: ,x_msg_data => l_msg_data);
7429:
7430: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7431: l_msg_count := FND_MSG_PUB.count_msg;
7432: IF l_msg_count > 0 THEN
7433: x_msg_count := l_msg_count;
7434: IF x_msg_count = 1 THEN
7435: x_msg_data := l_msg_data;

Line 7465: l_msg_count := FND_MSG_PUB.count_msg;

7461: ,x_msg_count => l_msg_count
7462: ,x_msg_data => l_msg_data);
7463:
7464: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
7465: l_msg_count := FND_MSG_PUB.count_msg;
7466: IF l_msg_count > 0 THEN
7467: x_msg_count := l_msg_count;
7468: IF x_msg_count = 1 THEN
7469: x_msg_data := l_msg_data;

Line 7609: x_msg_count := FND_MSG_PUB.count_msg;

7605: ,x_msg_data => x_msg_data
7606: );
7607:
7608: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
7609: x_msg_count := FND_MSG_PUB.count_msg;
7610: If x_msg_count = 1 then
7611: pa_interface_utils_pub.get_messages
7612: (p_encoded => FND_API.G_TRUE,
7613: p_msg_index => 1,

Line 7698: x_msg_count := FND_MSG_PUB.count_msg;

7694: WHEN FND_API.G_EXC_ERROR THEN
7695: IF (p_commit = FND_API.G_TRUE) THEN
7696: ROLLBACK to CREATE_SCH_VER_PRIVATE;
7697: END IF;
7698: x_msg_count := FND_MSG_PUB.count_msg;
7699: x_return_status := FND_API.G_RET_STS_ERROR;
7700: WHEN OTHERS THEN
7701: IF (p_commit = FND_API.G_TRUE) THEN
7702: ROLLBACK to CREATE_SCH_VER_PRIVATE;

Line 7705: x_msg_count := FND_MSG_PUB.count_msg;

7701: IF (p_commit = FND_API.G_TRUE) THEN
7702: ROLLBACK to CREATE_SCH_VER_PRIVATE;
7703: END IF;
7704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7705: x_msg_count := FND_MSG_PUB.count_msg;
7706: --put message
7707: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
7708: p_procedure_name => 'create_schedule_version',
7709: p_error_text => SUBSTRB(SQLERRM,1,240));

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

7703: END IF;
7704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7705: x_msg_count := FND_MSG_PUB.count_msg;
7706: --put message
7707: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
7708: p_procedure_name => 'create_schedule_version',
7709: p_error_text => SUBSTRB(SQLERRM,1,240));
7710: RAISE;
7711:

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

8055: -- x_msg_count => l_msg_count,
8056: -- x_msg_data => l_msg_data
8057: -- );
8058: -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8059: -- l_msg_count := FND_MSG_PUB.count_msg;
8060: -- IF l_msg_count > 0 THEN
8061: -- x_msg_count := l_msg_count;
8062: -- IF x_msg_count = 1 THEN
8063: -- x_msg_data := l_msg_data;

Line 8547: l_msg_count := FND_MSG_PUB.count_msg;

8543: ,x_msg_data => l_msg_data
8544: );
8545:
8546: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8547: l_msg_count := FND_MSG_PUB.count_msg;
8548: IF l_msg_count > 0 THEN
8549: x_msg_count := l_msg_count;
8550: IF x_msg_count = 1 THEN
8551: x_msg_data := l_msg_data;

Line 8592: l_msg_count := FND_MSG_PUB.count_msg;

8588: ,x_msg_count => l_msg_count
8589: ,x_msg_data => l_msg_data);
8590:
8591: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8592: l_msg_count := FND_MSG_PUB.count_msg;
8593: IF l_msg_count > 0 THEN
8594: x_msg_count := l_msg_count;
8595: IF x_msg_count = 1 THEN
8596: x_msg_data := l_msg_data;

Line 8624: l_msg_count := FND_MSG_PUB.count_msg;

8620: ,x_msg_count => l_msg_count
8621: ,x_msg_data => l_msg_data);
8622:
8623: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8624: l_msg_count := FND_MSG_PUB.count_msg;
8625: IF l_msg_count > 0 THEN
8626: x_msg_count := l_msg_count;
8627: IF x_msg_count = 1 THEN
8628: x_msg_data := l_msg_data;

Line 8706: l_msg_count := FND_MSG_PUB.count_msg;

8702: x_msg_count => l_msg_count,
8703: x_msg_data => l_msg_data
8704: );
8705: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8706: l_msg_count := FND_MSG_PUB.count_msg;
8707: IF l_msg_count > 0 THEN
8708: x_msg_count := l_msg_count;
8709: IF x_msg_count = 1 THEN
8710: x_msg_data := l_msg_data;

Line 8730: x_msg_count := FND_MSG_PUB.count_msg;

8726: ,x_msg_data => x_msg_data
8727: );
8728:
8729: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
8730: x_msg_count := FND_MSG_PUB.count_msg;
8731: If x_msg_count = 1 then
8732: pa_interface_utils_pub.get_messages
8733: (p_encoded => FND_API.G_TRUE,
8734: p_msg_index => 1,

Line 8859: l_msg_count := FND_MSG_PUB.count_msg;

8855: x_return_status => l_return_status,
8856: x_msg_count => l_msg_count,
8857: x_msg_data => l_msg_data);
8858:
8859: l_msg_count := FND_MSG_PUB.count_msg;
8860: IF (l_msg_count > 0) THEN
8861: pa_interface_utils_pub.get_messages(
8862: p_encoded => FND_API.G_TRUE,
8863: p_msg_index => 1,

Line 8963: l_msg_count := FND_MSG_PUB.count_msg;

8959: x_planning_end_tbl => l_planning_end_tbl,
8960: x_return_status => l_return_status);
8961:
8962: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
8963: l_msg_count := FND_MSG_PUB.count_msg;
8964: IF l_msg_count > 0 THEN
8965: x_msg_count := l_msg_count;
8966: IF x_msg_count = 1 THEN
8967: x_msg_data := l_msg_data;

Line 8989: x_msg_count := FND_MSG_PUB.count_msg;

8985: x_msg_count => l_msg_count,
8986: x_msg_data => l_msg_data);
8987:
8988: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
8989: x_msg_count := FND_MSG_PUB.count_msg;
8990: if x_msg_count = 1 then
8991: pa_interface_utils_pub.get_messages
8992: (p_encoded => FND_API.G_TRUE,
8993: p_msg_index => 1,

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

9047: );
9048: END IF;
9049: EXCEPTION
9050: WHEN OTHERS THEN
9051: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9052: p_procedure_name => 'update_schedule_version',
9053: p_error_text => SUBSTRB('pa_fp_planning_transaction_pub.update_planning_transactions:'||SQLERRM,1,240));
9054: RAISE FND_API.G_EXC_ERROR;
9055: END;

Line 9058: x_msg_count := FND_MSG_PUB.count_msg;

9054: RAISE FND_API.G_EXC_ERROR;
9055: END;
9056:
9057: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9058: x_msg_count := FND_MSG_PUB.count_msg;
9059: if x_msg_count = 1 then
9060: pa_interface_utils_pub.get_messages
9061: (p_encoded => FND_API.G_TRUE,
9062: p_msg_index => 1,

Line 9084: x_msg_count := FND_MSG_PUB.count_msg;

9080: WHEN FND_API.G_EXC_ERROR THEN
9081: IF (p_commit = FND_API.G_TRUE) THEN
9082: ROLLBACK to UPDATE_SCH_VER_PRIVATE;
9083: END IF;
9084: x_msg_count := FND_MSG_PUB.count_msg;
9085: x_return_status := FND_API.G_RET_STS_ERROR;
9086: WHEN OTHERS THEN
9087: IF (p_commit = FND_API.G_TRUE) THEN
9088: ROLLBACK to UPDATE_SCH_VER_PRIVATE;

Line 9091: x_msg_count := FND_MSG_PUB.count_msg;

9087: IF (p_commit = FND_API.G_TRUE) THEN
9088: ROLLBACK to UPDATE_SCH_VER_PRIVATE;
9089: END IF;
9090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9091: x_msg_count := FND_MSG_PUB.count_msg;
9092: --put message
9093: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9094: p_procedure_name => 'update_schedule_version',
9095: p_error_text => SUBSTRB(SQLERRM,1,240));

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

9089: END IF;
9090: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9091: x_msg_count := FND_MSG_PUB.count_msg;
9092: --put message
9093: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9094: p_procedure_name => 'update_schedule_version',
9095: p_error_text => SUBSTRB(SQLERRM,1,240));
9096: RAISE;
9097: END Update_Schedule_Version;

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

9161: END IF;
9162: EXCEPTION
9163: WHEN OTHERS THEN
9164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9166: p_procedure_name => 'Inherit_task_type_attr',
9167: p_error_text => SUBSTRB(SQLERRM,1,240));
9168: raise;
9169: END Inherit_task_type_attr;

Line 9283: x_msg_count := FND_MSG_PUB.count_msg;

9279: WHEN FND_API.G_EXC_ERROR THEN
9280: IF (p_commit = FND_API.G_TRUE) THEN
9281: ROLLBACK to update_task_weighting_pvt;
9282: END IF;
9283: x_msg_count := FND_MSG_PUB.count_msg;
9284: x_return_status := FND_API.G_RET_STS_ERROR;
9285: WHEN OTHERS THEN
9286: IF (p_commit = FND_API.G_TRUE) THEN
9287: ROLLBACK to update_task_weighting_pvt;

Line 9290: x_msg_count := FND_MSG_PUB.count_msg;

9286: IF (p_commit = FND_API.G_TRUE) THEN
9287: ROLLBACK to update_task_weighting_pvt;
9288: END IF;
9289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9290: x_msg_count := FND_MSG_PUB.count_msg;
9291: --put message
9292: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9293: p_procedure_name => 'Update_Task_Weighting',
9294: p_error_text => SUBSTRB(SQLERRM,1,240));

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

9288: END IF;
9289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9290: x_msg_count := FND_MSG_PUB.count_msg;
9291: --put message
9292: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9293: p_procedure_name => 'Update_Task_Weighting',
9294: p_error_text => SUBSTRB(SQLERRM,1,240));
9295: RAISE;
9296: END UPDATE_TASK_WEIGHTING;

Line 9414: x_msg_count := FND_MSG_PUB.count_msg;

9410: ,x_msg_data => l_msg_data
9411: );
9412:
9413: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
9414: x_msg_count := FND_MSG_PUB.count_msg;
9415: if x_msg_count = 1 then
9416: pa_interface_utils_pub.get_messages
9417: (p_encoded => FND_API.G_TRUE,
9418: p_msg_index => 1,

Line 9449: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 9469: x_msg_count := FND_MSG_PUB.count_msg;

9465: CLOSE get_child_weighting;
9466:
9467: EXCEPTION
9468: WHEN FND_API.G_EXC_ERROR THEN
9469: x_msg_count := FND_MSG_PUB.count_msg;
9470: x_return_status := FND_API.G_RET_STS_ERROR;
9471: WHEN OTHERS THEN
9472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9473: x_msg_count := FND_MSG_PUB.count_msg;

Line 9473: x_msg_count := FND_MSG_PUB.count_msg;

9469: x_msg_count := FND_MSG_PUB.count_msg;
9470: x_return_status := FND_API.G_RET_STS_ERROR;
9471: WHEN OTHERS THEN
9472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9473: x_msg_count := FND_MSG_PUB.count_msg;
9474: --put message
9475: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9476: p_procedure_name => 'RECALC_TASKS_WEIGHTING',
9477: p_error_text => SUBSTRB(SQLERRM,1,240));

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

9471: WHEN OTHERS THEN
9472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9473: x_msg_count := FND_MSG_PUB.count_msg;
9474: --put message
9475: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9476: p_procedure_name => 'RECALC_TASKS_WEIGHTING',
9477: p_error_text => SUBSTRB(SQLERRM,1,240));
9478: RAISE;
9479: END RECALC_TASKS_WEIGHTING;

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

9535: x_return_status := FND_API.G_RET_STS_SUCCESS;
9536: EXCEPTION
9537: WHEN OTHERS THEN
9538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9539: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9540: p_procedure_name => 'update_task_ver_delete_status',
9541: p_error_text => SUBSTRB(SQLERRM,1,240));
9542: raise;
9543: END update_task_ver_delete_status;

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

9863: ,x_msg_count => x_msg_count
9864: ,x_msg_data => x_msg_data);
9865: EXCEPTION
9866: WHEN OTHERS THEN
9867: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
9868: p_procedure_name => 'delete_Task_ver_wo_val',
9869: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
9870: RAISE FND_API.G_EXC_ERROR;
9871: END;

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

9982: -- ,x_msg_count => l_msg_count
9983: -- ,x_msg_data => l_msg_data
9984: -- );
9985: -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
9986: -- x_msg_count := FND_MSG_PUB.count_msg;
9987: -- IF x_msg_count = 1 then
9988: -- pa_interface_utils_pub.get_messages
9989: -- (p_encoded => FND_API.G_TRUE,
9990: -- p_msg_index => 1,

Line 10052: x_msg_count := FND_MSG_PUB.count_msg;

10048: END IF;
10049:
10050:
10051: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10052: x_msg_count := FND_MSG_PUB.count_msg;
10053: IF x_msg_count = 1 then
10054: pa_interface_utils_pub.get_messages
10055: (p_encoded => FND_API.G_TRUE,
10056: p_msg_index => 1,

Line 10088: x_msg_count := FND_MSG_PUB.count_msg;

10084: ,x_msg_data => l_msg_data
10085: );
10086:
10087: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10088: x_msg_count := FND_MSG_PUB.count_msg;
10089: IF x_msg_count = 1 then
10090: pa_interface_utils_pub.get_messages
10091: (p_encoded => FND_API.G_TRUE,
10092: p_msg_index => 1,

Line 10119: x_msg_count := FND_MSG_PUB.count_msg;

10115: ,p_parent_task_id => l_parent_task_verion_id
10116: ,x_return_status => l_return_status );
10117:
10118: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10119: x_msg_count := FND_MSG_PUB.count_msg;
10120: IF x_msg_count = 1 then
10121: pa_interface_utils_pub.get_messages
10122: (p_encoded => FND_API.G_TRUE,
10123: p_msg_index => 1,

Line 10183: l_msg_count := FND_MSG_PUB.count_msg;

10179: ,x_return_status => l_return_status
10180: ,x_msg_count => l_msg_count
10181: ,x_msg_data => l_msg_data );
10182:
10183: l_msg_count := FND_MSG_PUB.count_msg;
10184:
10185: IF l_msg_count > 0 THEN
10186: x_msg_count := l_msg_count;
10187: x_return_status := 'E';

Line 10207: x_msg_count := FND_MSG_PUB.count_msg;

10203: ,x_msg_data => l_msg_data
10204: );
10205:
10206: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
10207: x_msg_count := FND_MSG_PUB.count_msg;
10208: if x_msg_count = 1 then
10209: pa_interface_utils_pub.get_messages
10210: (p_encoded => FND_API.G_TRUE,
10211: p_msg_index => 1,

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

10245: ,x_msg_count => x_msg_count
10246: ,x_msg_data => x_msg_data);
10247: EXCEPTION
10248: WHEN OTHERS THEN
10249: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10250: p_procedure_name => 'delete_Task_ver_wo_val',
10251: p_error_text => SUBSTRB('PA_FP_PLANNING_TRANSACTION_PUB.delete_planning_transactions:'||SQLERRM,1,240));
10252: RAISE FND_API.G_EXC_ERROR;
10253: END;

Line 10292: x_msg_count := FND_MSG_PUB.count_msg;

10288: x_msg_count => l_msg_count,
10289: x_msg_data => l_msg_data);
10290:
10291: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
10292: x_msg_count := FND_MSG_PUB.count_msg;
10293: if x_msg_count = 1 then
10294: pa_interface_utils_pub.get_messages
10295: (p_encoded => FND_API.G_TRUE,
10296: p_msg_index => 1,

Line 10327: x_msg_count := FND_MSG_PUB.count_msg;

10323: ,x_msg_data => l_msg_data
10324: );
10325:
10326: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
10327: x_msg_count := FND_MSG_PUB.count_msg;
10328: if x_msg_count = 1 then
10329: pa_interface_utils_pub.get_messages
10330: (p_encoded => FND_API.G_TRUE,
10331: p_msg_index => 1,

Line 10356: x_msg_count := FND_MSG_PUB.count_msg;

10352: ,x_msg_data => l_msg_data
10353: );
10354:
10355: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
10356: x_msg_count := FND_MSG_PUB.count_msg;
10357: if x_msg_count = 1 then
10358: pa_interface_utils_pub.get_messages
10359: (p_encoded => FND_API.G_TRUE,
10360: p_msg_index => 1,

Line 10390: x_msg_count := FND_MSG_PUB.count_msg;

10386: ,x_msg_count => l_msg_count
10387: ,x_msg_data => l_msg_data);
10388:
10389: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
10390: x_msg_count := FND_MSG_PUB.count_msg;
10391: if x_msg_count = 1 then
10392: pa_interface_utils_pub.get_messages
10393: (p_encoded => FND_API.G_TRUE,
10394: p_msg_index => 1,

Line 10412: x_msg_count := FND_MSG_PUB.count_msg;

10408: WHEN FND_API.G_EXC_ERROR THEN
10409: IF (p_commit = FND_API.G_TRUE) THEN
10410: ROLLBACK to DELETE_TASK_VER_WO_VAL;
10411: END IF;
10412: x_msg_count := FND_MSG_PUB.count_msg;
10413: x_return_status := FND_API.G_RET_STS_ERROR;
10414: WHEN OTHERS THEN
10415: IF (p_commit = FND_API.G_TRUE) THEN
10416: ROLLBACK to DELETE_TASK_VER_WO_VAL;

Line 10419: x_msg_count := FND_MSG_PUB.count_msg;

10415: IF (p_commit = FND_API.G_TRUE) THEN
10416: ROLLBACK to DELETE_TASK_VER_WO_VAL;
10417: END IF;
10418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10419: x_msg_count := FND_MSG_PUB.count_msg;
10420: --put message
10421: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10422: p_procedure_name => 'delete_Task_ver_wo_val',
10423: p_error_text => SUBSTRB(SQLERRM,1,240));

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

10417: END IF;
10418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10419: x_msg_count := FND_MSG_PUB.count_msg;
10420: --put message
10421: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10422: p_procedure_name => 'delete_Task_ver_wo_val',
10423: p_error_text => SUBSTRB(SQLERRM,1,240));
10424: RAISE;
10425: END delete_task_ver_wo_val;

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

10522: WHEN FND_API.G_EXC_ERROR THEN
10523: x_return_status := FND_API.G_RET_STS_ERROR;
10524: WHEN OTHERS THEN
10525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10526: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10527: p_procedure_name => 'UPDATE_WORKING_VER_WEIGHT',
10528: p_error_text => SUBSTRB(SQLERRM,1,240));
10529: RAISE;
10530: END UPDATE_WORKING_VER_WEIGHT;

Line 10705: x_msg_count := FND_MSG_PUB.count_msg;

10701: /* Bug 2790703 End */
10702:
10703:
10704: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
10705: x_msg_count := FND_MSG_PUB.count_msg;
10706: if x_msg_count = 1 then
10707: pa_interface_utils_pub.get_messages
10708: (p_encoded => FND_API.G_TRUE,
10709: p_msg_index => 1,

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

10720: WHEN FND_API.G_EXC_ERROR THEN
10721: x_return_status := FND_API.G_RET_STS_ERROR;
10722: WHEN OTHERS THEN
10723: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10724: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10725: p_procedure_name => 'set_new_tasks_to_TBD',
10726: p_error_text => SUBSTRB(SQLERRM,1,240));
10727: RAISE;
10728: END set_new_tasks_to_TBD;

Line 10827: x_msg_count := FND_MSG_PUB.count_msg;

10823: WHEN FND_API.G_EXC_ERROR THEN
10824: IF (p_commit = FND_API.G_TRUE) THEN
10825: ROLLBACK to UPDATE_SCH_VER_PRIVATE_DATES;
10826: END IF;
10827: x_msg_count := FND_MSG_PUB.count_msg;
10828: x_return_status := FND_API.G_RET_STS_ERROR;
10829: WHEN OTHERS THEN
10830: IF (p_commit = FND_API.G_TRUE) THEN
10831: ROLLBACK to UPDATE_SCH_VER_PRIVATE_DATES;

Line 10834: x_msg_count := FND_MSG_PUB.count_msg;

10830: IF (p_commit = FND_API.G_TRUE) THEN
10831: ROLLBACK to UPDATE_SCH_VER_PRIVATE_DATES;
10832: END IF;
10833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10834: x_msg_count := FND_MSG_PUB.count_msg;
10835: --put message
10836: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10837: p_procedure_name => 'Update_Dates_To_All_Versions',
10838: p_error_text => SUBSTRB(SQLERRM,1,240));

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

10832: END IF;
10833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10834: x_msg_count := FND_MSG_PUB.count_msg;
10835: --put message
10836: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10837: p_procedure_name => 'Update_Dates_To_All_Versions',
10838: p_error_text => SUBSTRB(SQLERRM,1,240));
10839: RAISE;
10840: END Update_Dates_To_All_Versions;

Line 10980: x_msg_count := FND_MSG_PUB.count_msg;

10976: WHEN FND_API.G_EXC_ERROR THEN
10977: IF (p_commit = FND_API.G_TRUE) THEN
10978: ROLLBACK to DISP_SEQ_NUM_LEVEL_DEFER;
10979: END IF;
10980: x_msg_count := FND_MSG_PUB.count_msg;
10981: x_return_status := FND_API.G_RET_STS_ERROR;
10982: WHEN OTHERS THEN
10983: IF (p_commit = FND_API.G_TRUE) THEN
10984: ROLLBACK to DISP_SEQ_NUM_LEVEL_DEFER;

Line 10987: x_msg_count := FND_MSG_PUB.count_msg;

10983: IF (p_commit = FND_API.G_TRUE) THEN
10984: ROLLBACK to DISP_SEQ_NUM_LEVEL_DEFER;
10985: END IF;
10986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10987: x_msg_count := FND_MSG_PUB.count_msg;
10988: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10989: p_procedure_name => 'DISP_SEQ_NUM_LEVEL_DEFER',
10990: p_error_text => SUBSTRB(SQLERRM,1,240));
10991: RAISE;

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

10984: ROLLBACK to DISP_SEQ_NUM_LEVEL_DEFER;
10985: END IF;
10986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10987: x_msg_count := FND_MSG_PUB.count_msg;
10988: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
10989: p_procedure_name => 'DISP_SEQ_NUM_LEVEL_DEFER',
10990: p_error_text => SUBSTRB(SQLERRM,1,240));
10991: RAISE;
10992: END DISP_SEQ_NUM_LEVEL_DEFER;

Line 11134: x_msg_count := FND_MSG_PUB.count_msg;

11130: WHEN FND_API.G_EXC_ERROR THEN
11131: IF (p_commit = FND_API.G_TRUE) THEN
11132: ROLLBACK to DEFER_CALC_TASK_WEIGTHAGE;
11133: END IF;
11134: x_msg_count := FND_MSG_PUB.count_msg;
11135: x_return_status := FND_API.G_RET_STS_ERROR;
11136: WHEN OTHERS THEN
11137: IF (p_commit = FND_API.G_TRUE) THEN
11138: ROLLBACK to DEFER_CALC_TASK_WEIGTHAGE;

Line 11141: x_msg_count := FND_MSG_PUB.count_msg;

11137: IF (p_commit = FND_API.G_TRUE) THEN
11138: ROLLBACK to DEFER_CALC_TASK_WEIGTHAGE;
11139: END IF;
11140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11141: x_msg_count := FND_MSG_PUB.count_msg;
11142: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
11143: p_procedure_name => 'DEFER_CALC_TASK_WEIGTHAGE',
11144: p_error_text => SUBSTRB(SQLERRM,1,240));
11145: RAISE;

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

11138: ROLLBACK to DEFER_CALC_TASK_WEIGTHAGE;
11139: END IF;
11140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
11141: x_msg_count := FND_MSG_PUB.count_msg;
11142: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_TASK_PVT1',
11143: p_procedure_name => 'DEFER_CALC_TASK_WEIGTHAGE',
11144: p_error_text => SUBSTRB(SQLERRM,1,240));
11145: RAISE;
11146: