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

Line 391: x_msg_count := FND_MSG_PUB.count_msg;

387: END IF;
388:
389: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
390:
391: x_msg_count := FND_MSG_PUB.count_msg;
392: if x_msg_count = 1 then
393: pa_interface_utils_pub.get_messages
394: (p_encoded => FND_API.G_TRUE,
395: p_msg_index => 1,

Line 429: x_msg_count := FND_MSG_PUB.count_msg;

425:
426:
427: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
428:
429: x_msg_count := FND_MSG_PUB.count_msg;
430: if x_msg_count = 1 then
431: pa_interface_utils_pub.get_messages
432: (p_encoded => FND_API.G_TRUE,
433: p_msg_index => 1,

Line 459: x_msg_count := FND_MSG_PUB.count_msg;

455: pa_debug.debug('new workplan attr for task => '||l_pev_schedule_id);
456: END IF;
457:
458: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
459: x_msg_count := FND_MSG_PUB.count_msg;
460: if x_msg_count = 1 then
461: pa_interface_utils_pub.get_messages
462: (p_encoded => FND_API.G_TRUE,
463: p_msg_index => 1,

Line 651: x_msg_count := FND_MSG_PUB.count_msg;

647: WHEN FND_API.G_EXC_ERROR THEN
648: IF (p_commit = FND_API.G_TRUE) THEN
649: ROLLBACK to create_relationship_pvt;
650: END IF;
651: x_msg_count := FND_MSG_PUB.count_msg;
652: x_return_status := FND_API.G_RET_STS_ERROR;
653: WHEN OTHERS THEN
654: IF (p_commit = FND_API.G_TRUE) THEN
655: ROLLBACK to create_relationship_pvt;

Line 658: x_msg_count := FND_MSG_PUB.count_msg;

654: IF (p_commit = FND_API.G_TRUE) THEN
655: ROLLBACK to create_relationship_pvt;
656: END IF;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: x_msg_count := FND_MSG_PUB.count_msg;
659: --put message
660: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
661: p_procedure_name => 'Create_Relationship',
662: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 660: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

656: END IF;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: x_msg_count := FND_MSG_PUB.count_msg;
659: --put message
660: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
661: p_procedure_name => 'Create_Relationship',
662: p_error_text => SUBSTRB(SQLERRM,1,240));
663: RAISE;
664: END;

Line 845: x_msg_count := FND_MSG_PUB.count_msg;

841: WHEN FND_API.G_EXC_ERROR THEN
842: IF (p_commit = FND_API.G_TRUE) THEN
843: ROLLBACK to update_relationship_pvt;
844: END IF;
845: x_msg_count := FND_MSG_PUB.count_msg;
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: WHEN OTHERS THEN
848: IF (p_commit = FND_API.G_TRUE) THEN
849: ROLLBACK to update_relationship_pvt;

Line 852: x_msg_count := FND_MSG_PUB.count_msg;

848: IF (p_commit = FND_API.G_TRUE) THEN
849: ROLLBACK to update_relationship_pvt;
850: END IF;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: x_msg_count := FND_MSG_PUB.count_msg;
853: --put message
854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
855: p_procedure_name => 'Update_relationship',
856: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

850: END IF;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: x_msg_count := FND_MSG_PUB.count_msg;
853: --put message
854: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
855: p_procedure_name => 'Update_relationship',
856: p_error_text => SUBSTRB(SQLERRM,1,240));
857: RAISE;
858: END UPDATE_RELATIONSHIP;

Line 979: x_msg_count := FND_MSG_PUB.count_msg;

975: x_msg_data => l_msg_data);
976: END IF;
977:
978: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
979: x_msg_count := FND_MSG_PUB.count_msg;
980: IF x_msg_count = 1 then
981: pa_interface_utils_pub.get_messages
982: (p_encoded => FND_API.G_TRUE,
983: p_msg_index => 1,

Line 1001: x_msg_count := FND_MSG_PUB.count_msg;

997: WHEN FND_API.G_EXC_ERROR THEN
998: IF (p_commit = FND_API.G_TRUE) THEN
999: ROLLBACK to delete_relationship_pvt;
1000: END IF;
1001: x_msg_count := FND_MSG_PUB.count_msg;
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003: WHEN OTHERS THEN
1004: IF (p_commit = FND_API.G_TRUE) THEN
1005: ROLLBACK to delete_relationship_pvt;

Line 1008: x_msg_count := FND_MSG_PUB.count_msg;

1004: IF (p_commit = FND_API.G_TRUE) THEN
1005: ROLLBACK to delete_relationship_pvt;
1006: END IF;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: x_msg_count := FND_MSG_PUB.count_msg;
1009: --put message
1010: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
1011: p_procedure_name => 'Delete_relationship',
1012: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 1010: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

1006: END IF;
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008: x_msg_count := FND_MSG_PUB.count_msg;
1009: --put message
1010: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
1011: p_procedure_name => 'Delete_relationship',
1012: p_error_text => SUBSTRB(SQLERRM,1,240));
1013: RAISE;
1014: END DELETE_RELATIONSHIP;

Line 1234: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 1278: x_msg_count := FND_MSG_PUB.count_msg;

1274: ,p_status_code => null /* not applicable for intra dependency */
1275: );
1276:
1277: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1278: x_msg_count := FND_MSG_PUB.count_msg;
1279: IF x_msg_count = 1 then
1280: pa_interface_utils_pub.get_messages
1281: (p_encoded => FND_API.G_TRUE,
1282: p_msg_index => 1,

Line 1307: x_msg_count := FND_MSG_PUB.count_msg;

1303: ,x_msg_data => l_msg_data
1304: );
1305:
1306: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1307: x_msg_count := FND_MSG_PUB.count_msg;
1308: IF x_msg_count = 1 then
1309: pa_interface_utils_pub.get_messages
1310: (p_encoded => FND_API.G_TRUE,
1311: p_msg_index => 1,

Line 1383: x_msg_count := FND_MSG_PUB.count_msg;

1379: ,p_status_code => l_status_code
1380: );
1381:
1382: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1383: x_msg_count := FND_MSG_PUB.count_msg;
1384: IF x_msg_count = 1 then
1385: pa_interface_utils_pub.get_messages
1386: (p_encoded => FND_API.G_TRUE,
1387: p_msg_index => 1,

Line 1422: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1418: if p_commit = FND_API.G_TRUE then
1419: rollback to create_dependency_pvt;
1420: end if;
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1422: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1423: p_procedure_name => 'CREATE_DEPENDENCY',
1424: p_error_text => SUBSTRB(SQLERRM,1,240));
1425: when OTHERS then
1426: if p_commit = FND_API.G_TRUE then

Line 1430: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1426: if p_commit = FND_API.G_TRUE then
1427: rollback to create_dependency_pvt;
1428: end if;
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1431: p_procedure_name => 'CREATE_DEPENDENCY',
1432: p_error_text => SUBSTRB(SQLERRM,1,240));
1433: raise;
1434: END Create_Dependency;

Line 1557: x_msg_count := FND_MSG_PUB.count_msg;

1553: ,x_return_status => l_return_status
1554: );
1555:
1556: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1557: x_msg_count := FND_MSG_PUB.count_msg;
1558: IF x_msg_count = 1 then
1559: pa_interface_utils_pub.get_messages
1560: (p_encoded => FND_API.G_TRUE,
1561: p_msg_index => 1,

Line 1594: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1590: if p_commit = FND_API.G_TRUE then
1591: rollback to update_dependency_pvt;
1592: end if;
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1594: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1595: p_procedure_name => 'UPDATE_DEPENDENCY',
1596: p_error_text => SUBSTRB(SQLERRM,1,240));
1597: when OTHERS then
1598: if p_commit = FND_API.G_TRUE then

Line 1602: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1598: if p_commit = FND_API.G_TRUE then
1599: rollback to update_dependency_pvt;
1600: end if;
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1603: p_procedure_name => 'UPDATE_DEPENDENCY',
1604: p_error_text => SUBSTRB(SQLERRM,1,240));
1605: raise;
1606: END Update_Dependency;

Line 1738: x_msg_count := FND_MSG_PUB.count_msg;

1734: ,p_pm_product_code => null
1735: ,x_return_status => l_return_status );
1736:
1737: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1738: x_msg_count := FND_MSG_PUB.count_msg;
1739: IF x_msg_count = 1 then
1740: pa_interface_utils_pub.get_messages
1741: (p_encoded => FND_API.G_TRUE,
1742: p_msg_index => 1,

Line 1774: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1770: if p_commit = FND_API.G_TRUE then
1771: rollback to delete_dependency_pvt;
1772: end if;
1773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1774: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1775: p_procedure_name => 'DELETE_DEPENDENCY',
1776: p_error_text => SUBSTRB(SQLERRM,1,240));
1777: when OTHERS then
1778: if p_commit = FND_API.G_TRUE then

Line 1782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

1778: if p_commit = FND_API.G_TRUE then
1779: rollback to delete_dependency_pvt;
1780: end if;
1781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1782: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
1783: p_procedure_name => 'DELETE_DEPENDENCY',
1784: p_error_text => SUBSTRB(SQLERRM,1,240));
1785: raise;
1786: END Delete_Dependency;

Line 2306: x_msg_count := FND_MSG_PUB.count_msg;

2302: ,x_msg_data => x_msg_data
2303: );
2304:
2305: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2306: x_msg_count := FND_MSG_PUB.count_msg;
2307: IF x_msg_count = 1 then
2308: pa_interface_utils_pub.get_messages
2309: (p_encoded => FND_API.G_TRUE,
2310: p_msg_index => 1,

Line 2350: x_msg_count := FND_MSG_PUB.count_msg;

2346: ,x_msg_data => x_msg_data
2347: );
2348:
2349: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2350: x_msg_count := FND_MSG_PUB.count_msg;
2351: IF x_msg_count = 1 then
2352: pa_interface_utils_pub.get_messages
2353: (p_encoded => FND_API.G_TRUE,
2354: p_msg_index => 1,

Line 2374: x_msg_count := FND_MSG_PUB.count_msg;

2370: x_return_status := FND_API.G_RET_STS_SUCCESS;
2371:
2372: EXCEPTION -- 4537865
2373: WHEN FND_API.G_EXC_ERROR THEN
2374: x_msg_count := FND_MSG_PUB.count_msg;
2375: x_return_status := FND_API.G_RET_STS_ERROR;
2376: WHEN OTHERS THEN
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2378: x_msg_count := FND_MSG_PUB.count_msg;

Line 2378: x_msg_count := FND_MSG_PUB.count_msg;

2374: x_msg_count := FND_MSG_PUB.count_msg;
2375: x_return_status := FND_API.G_RET_STS_ERROR;
2376: WHEN OTHERS THEN
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2378: x_msg_count := FND_MSG_PUB.count_msg;
2379: --put message
2380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2381: p_procedure_name => 'Copy_Intra_Dependency',
2382: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 2380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

2376: WHEN OTHERS THEN
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2378: x_msg_count := FND_MSG_PUB.count_msg;
2379: --put message
2380: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2381: p_procedure_name => 'Copy_Intra_Dependency',
2382: p_error_text => SUBSTRB(SQLERRM,1,240));
2383: RAISE;
2384:

Line 2456: x_msg_count := FND_MSG_PUB.count_msg;

2452: ,x_msg_data => x_msg_data
2453: );
2454:
2455: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2456: x_msg_count := FND_MSG_PUB.count_msg;
2457: IF x_msg_count = 1 then
2458: pa_interface_utils_pub.get_messages
2459: (p_encoded => FND_API.G_TRUE,
2460: p_msg_index => 1,

Line 2548: x_msg_count := FND_MSG_PUB.count_msg;

2544: );
2545: -- 4537865 : This is wrong.Check shud be made against x_return_status :
2546: -- IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2547: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2548: x_msg_count := FND_MSG_PUB.count_msg;
2549: IF x_msg_count = 1 then
2550: pa_interface_utils_pub.get_messages
2551: (p_encoded => FND_API.G_TRUE,
2552: p_msg_index => 1,

Line 2569: x_msg_count := FND_MSG_PUB.count_msg;

2565: x_return_status := FND_API.G_RET_STS_SUCCESS;
2566: --
2567: EXCEPTION -- 4537865
2568: WHEN FND_API.G_EXC_ERROR THEN
2569: x_msg_count := FND_MSG_PUB.count_msg;
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: WHEN OTHERS THEN
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: x_msg_count := FND_MSG_PUB.count_msg;

Line 2573: x_msg_count := FND_MSG_PUB.count_msg;

2569: x_msg_count := FND_MSG_PUB.count_msg;
2570: x_return_status := FND_API.G_RET_STS_ERROR;
2571: WHEN OTHERS THEN
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: x_msg_count := FND_MSG_PUB.count_msg;
2574: --put message
2575: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2576: p_procedure_name => 'Copy_Inter_Project_Dependency',
2577: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 2575: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

2571: WHEN OTHERS THEN
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: x_msg_count := FND_MSG_PUB.count_msg;
2574: --put message
2575: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2576: p_procedure_name => 'Copy_Inter_Project_Dependency',
2577: p_error_text => SUBSTRB(SQLERRM,1,240));
2578: RAISE;
2579:

Line 2755: x_msg_count := FND_MSG_PUB.count_msg;

2751: ,x_msg_count => x_msg_count
2752: ,x_msg_data => x_msg_data
2753: );
2754: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2755: x_msg_count := FND_MSG_PUB.count_msg;
2756: IF x_msg_count = 1 then
2757: pa_interface_utils_pub.get_messages
2758: (p_encoded => FND_API.G_TRUE,
2759: p_msg_index => 1,

Line 2821: x_msg_count := FND_MSG_PUB.count_msg;

2817: -- ,x_msg_data => x_msg_data
2818: );
2819:
2820: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2821: x_msg_count := FND_MSG_PUB.count_msg;
2822: /* IF x_msg_count = 1 then
2823: pa_interface_utils_pub.get_messages
2824: (p_encoded => FND_API.G_TRUE,
2825: p_msg_index => 1,

Line 2900: x_msg_count := FND_MSG_PUB.count_msg;

2896: -- ,x_msg_data => x_msg_data
2897: );
2898:
2899: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2900: x_msg_count := FND_MSG_PUB.count_msg;
2901: /* IF x_msg_count = 1 then
2902: pa_interface_utils_pub.get_messages
2903: (p_encoded => FND_API.G_TRUE,
2904: p_msg_index => 1,

Line 2925: x_msg_count := FND_MSG_PUB.count_msg;

2921: ,x_msg_data => x_msg_data
2922: );
2923:
2924: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2925: x_msg_count := FND_MSG_PUB.count_msg;
2926: Close Update_Publ_Ver;
2927: Raise FND_API.G_EXC_ERROR;
2928: END IF;
2929: */

Line 2951: x_msg_count := FND_MSG_PUB.count_msg;

2947: ,x_msg_data => x_msg_data
2948: );
2949:
2950: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2951: x_msg_count := FND_MSG_PUB.count_msg;
2952: IF x_msg_count = 1 Then
2953: pa_interface_utils_pub.get_messages
2954: (p_encoded => FND_API.G_TRUE,
2955: p_msg_index => 1,

Line 2969: x_msg_count := FND_MSG_PUB.count_msg;

2965: Close Delete_Publ_Ver;
2966: */
2967: EXCEPTION -- 4537865
2968: WHEN FND_API.G_EXC_ERROR THEN
2969: x_msg_count := FND_MSG_PUB.count_msg;
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: WHEN OTHERS THEN
2972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2973: x_msg_count := FND_MSG_PUB.count_msg;

Line 2973: x_msg_count := FND_MSG_PUB.count_msg;

2969: x_msg_count := FND_MSG_PUB.count_msg;
2970: x_return_status := FND_API.G_RET_STS_ERROR;
2971: WHEN OTHERS THEN
2972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2973: x_msg_count := FND_MSG_PUB.count_msg;
2974: --put message
2975: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2976: p_procedure_name => 'Copy_Intra_Dependency',
2977: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 2975: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

2971: WHEN OTHERS THEN
2972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2973: x_msg_count := FND_MSG_PUB.count_msg;
2974: --put message
2975: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
2976: p_procedure_name => 'Copy_Intra_Dependency',
2977: p_error_text => SUBSTRB(SQLERRM,1,240));
2978: RAISE;
2979:

Line 3081: x_msg_count := FND_MSG_PUB.count_msg;

3077: ,x_return_status => x_return_status
3078: ,x_msg_count => x_msg_count
3079: ,x_msg_data => x_msg_data);
3080: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3081: x_msg_count := FND_MSG_PUB.count_msg;
3082: IF x_msg_count = 1 THEN
3083: pa_interface_utils_pub.get_messages
3084: (p_encoded => FND_API.G_TRUE,
3085: p_msg_index => 1,

Line 3125: x_msg_count := FND_MSG_PUB.count_msg;

3121: ,x_return_status => x_return_status
3122: ,x_msg_count => x_msg_count
3123: ,x_msg_data => x_msg_data);
3124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3125: x_msg_count := FND_MSG_PUB.count_msg;
3126: IF x_msg_count = 1 THEN
3127: pa_interface_utils_pub.get_messages
3128: (p_encoded => FND_API.G_TRUE,
3129: p_msg_index => 1,

Line 3218: x_msg_count := FND_MSG_PUB.count_msg;

3214: pa_debug.debug('new workplan attr for task after call to PA_TASK_PUB1.Create_Schedule_Version=> '||x_pev_schedule_id);
3215: END IF;
3216: --
3217: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3218: x_msg_count := FND_MSG_PUB.count_msg;
3219: IF x_msg_count = 1 THEN
3220: pa_interface_utils_pub.get_messages
3221: (p_encoded => FND_API.G_TRUE,
3222: p_msg_index => 1,

Line 3270: x_msg_count := FND_MSG_PUB.count_msg;

3266: ,p_comments => p_comment --Bug No 3668113
3267: ,p_status_code => null
3268: );
3269: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3270: x_msg_count := FND_MSG_PUB.count_msg;
3271: IF x_msg_count = 1 THEN
3272: pa_interface_utils_pub.get_messages
3273: (p_encoded => FND_API.G_TRUE,
3274: p_msg_index => 1,

Line 3307: x_msg_count := FND_MSG_PUB.count_msg;

3303: x_msg_data => x_msg_data
3304: );
3305:
3306: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3307: x_msg_count := FND_MSG_PUB.count_msg;
3308: IF x_msg_count = 1 THEN
3309: pa_interface_utils_pub.get_messages
3310: (p_encoded => FND_API.G_TRUE,
3311: p_msg_index => 1,

Line 3367: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

3363:
3364: -- End fix for Bug # 4485908.
3365:
3366: WHEN OTHERS THEN
3367: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
3368: p_procedure_name => 'Insert_Subproject_Association',
3369: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
3370: RAISE FND_API.G_EXC_ERROR;
3371: END;

Line 3398: x_msg_count := FND_MSG_PUB.count_msg;

3394: x_lnk_task_elem_ver_id := NULL ;
3395: x_object_relationship_id := NULL ;
3396: x_pev_schedule_id := NULL;
3397:
3398: x_msg_count := FND_MSG_PUB.count_msg;
3399: x_return_status := FND_API.G_RET_STS_ERROR;
3400: WHEN OTHERS THEN
3401: IF (p_commit = FND_API.G_TRUE) THEN
3402: ROLLBACK to Insert_Subproject_Association;

Line 3411: x_msg_count := FND_MSG_PUB.count_msg;

3407: x_object_relationship_id := NULL ;
3408: x_pev_schedule_id := NULL;
3409:
3410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3411: x_msg_count := FND_MSG_PUB.count_msg;
3412: --put message
3413: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
3414: p_procedure_name => 'Insert_Subproject_Association',
3415: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 3413: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

3409:
3410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3411: x_msg_count := FND_MSG_PUB.count_msg;
3412: --put message
3413: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
3414: p_procedure_name => 'Insert_Subproject_Association',
3415: p_error_text => SUBSTRB(SQLERRM,1,240));
3416: RAISE;
3417: END Insert_Subproject_Association;

Line 3820: if (FND_MSG_PUB.count_msg = 0) then -- Fix for Bug # 4256435.

3816: --bug 3983361
3817: IF p_validation_level > 0 THEN
3818: IF PA_RELATIONSHIP_UTILS.CREATE_SUB_PROJ_ASSO_OK(p_task_ver_id,p_dest_proj_id) = 'N' THEN --SMukka
3819:
3820: if (FND_MSG_PUB.count_msg = 0) then -- Fix for Bug # 4256435.
3821:
3822: PA_UTILS.ADD_MESSAGE('PA','PA_CRT_SUBPROJ_VAL_FAIL','PROJ',l_proj_name,'PROG',l_prog_name); -- Bug # 4329284.
3823:
3824: end if; -- Fix for Bug # 4256435.

Line 3902: x_msg_count := FND_MSG_PUB.count_msg;

3898: ,x_msg_data => x_msg_data
3899: );
3900: --
3901: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3902: x_msg_count := FND_MSG_PUB.count_msg;
3903: IF x_msg_count = 1 then
3904: pa_interface_utils_pub.get_messages
3905: (p_encoded => FND_API.G_TRUE,
3906: p_msg_index => 1,

Line 3970: x_msg_count := FND_MSG_PUB.count_msg;

3966: ,x_msg_data => x_msg_data
3967: );
3968: --
3969: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3970: x_msg_count := FND_MSG_PUB.count_msg;
3971: IF x_msg_count = 1 then
3972: pa_interface_utils_pub.get_messages
3973: (p_encoded => FND_API.G_TRUE,
3974: p_msg_index => 1,

Line 4037: x_msg_count := FND_MSG_PUB.count_msg;

4033: ,x_msg_data => x_msg_data
4034: );
4035: --
4036: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4037: x_msg_count := FND_MSG_PUB.count_msg;
4038: IF x_msg_count = 1 then
4039: pa_interface_utils_pub.get_messages
4040: (p_encoded => FND_API.G_TRUE,
4041: p_msg_index => 1,

Line 4105: x_msg_count := FND_MSG_PUB.count_msg;

4101: ,x_msg_count => x_msg_count
4102: ,x_msg_data => x_msg_data
4103: );
4104: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4105: x_msg_count := FND_MSG_PUB.count_msg;
4106: IF x_msg_count = 1 then
4107: pa_interface_utils_pub.get_messages
4108: (p_encoded => FND_API.G_TRUE,
4109: p_msg_index => 1,

Line 4221: x_msg_count := FND_MSG_PUB.count_msg;

4217: ,x_msg_count => x_msg_count
4218: ,x_msg_data => x_msg_data);
4219:
4220: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4221: x_msg_count := FND_MSG_PUB.count_msg;
4222: IF x_msg_count = 1 then
4223: pa_interface_utils_pub.get_messages
4224: (p_encoded => FND_API.G_TRUE,
4225: p_msg_index => 1,

Line 4249: x_msg_count := FND_MSG_PUB.count_msg;

4245: WHEN FND_API.G_EXC_ERROR THEN
4246: IF (p_commit = FND_API.G_TRUE) THEN
4247: ROLLBACK to Create_Subproject_Ass_pvt;
4248: END IF;
4249: x_msg_count := FND_MSG_PUB.count_msg;
4250: x_return_status := FND_API.G_RET_STS_ERROR;
4251: WHEN OTHERS THEN
4252: IF (p_commit = FND_API.G_TRUE) THEN
4253: ROLLBACK to Create_Subproject_Ass_pvt;

Line 4256: x_msg_count := FND_MSG_PUB.count_msg;

4252: IF (p_commit = FND_API.G_TRUE) THEN
4253: ROLLBACK to Create_Subproject_Ass_pvt;
4254: END IF;
4255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4256: x_msg_count := FND_MSG_PUB.count_msg;
4257: --put message
4258: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
4259: p_procedure_name => 'Create_Subproject_Association',
4260: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 4258: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

4254: END IF;
4255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4256: x_msg_count := FND_MSG_PUB.count_msg;
4257: --put message
4258: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
4259: p_procedure_name => 'Create_Subproject_Association',
4260: p_error_text => SUBSTRB(SQLERRM,1,240));
4261: RAISE;
4262: END Create_Subproject_Association;

Line 4386: x_msg_count := FND_MSG_PUB.count_msg;

4382: WHEN FND_API.G_EXC_ERROR THEN
4383: IF (p_commit = FND_API.G_TRUE) THEN
4384: ROLLBACK to update_subproject_ass_pvt;
4385: END IF;
4386: x_msg_count := FND_MSG_PUB.count_msg;
4387: x_return_status := FND_API.G_RET_STS_ERROR;
4388: WHEN OTHERS THEN
4389: IF (p_commit = FND_API.G_TRUE) THEN
4390: ROLLBACK TO update_subproject_ass_pvt;

Line 4393: FND_MSG_PUB.add_exc_msg(

4389: IF (p_commit = FND_API.G_TRUE) THEN
4390: ROLLBACK TO update_subproject_ass_pvt;
4391: END IF;
4392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4393: FND_MSG_PUB.add_exc_msg(
4394: p_pkg_name => 'PA_RELATIONSHIPS_PVT1',
4395: p_procedure_name => 'update_subproject_association',
4396: p_error_text => SUBSTRB(SQLERRM,1,240));
4397: ROLLBACK TO update_subproject_association;

Line 4634: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

4630:
4631: -- End fix for Bug # 4485908.
4632:
4633: WHEN OTHERS THEN
4634: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
4635: p_procedure_name => 'Delete_SubProject_Association',
4636: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
4637: RAISE FND_API.G_EXC_ERROR;
4638: END;

Line 4662: x_msg_count := FND_MSG_PUB.count_msg;

4658: ,x_return_status => x_return_status
4659: );
4660: --
4661: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4662: x_msg_count := FND_MSG_PUB.count_msg;
4663: IF x_msg_count = 1 then
4664: pa_interface_utils_pub.get_messages
4665: (p_encoded => FND_API.G_TRUE,
4666: p_msg_index => 1,

Line 4699: x_msg_count := FND_MSG_PUB.count_msg;

4695: x_msg_count => x_msg_count,
4696: x_msg_data => x_msg_data);
4697: --
4698: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4699: x_msg_count := FND_MSG_PUB.count_msg;
4700: IF x_msg_count = 1 then
4701: pa_interface_utils_pub.get_messages
4702: (p_encoded => FND_API.G_TRUE,
4703: p_msg_index => 1,

Line 4748: x_msg_count := FND_MSG_PUB.count_msg;

4744: , x_msg_data => x_msg_data);
4745:
4746: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4747:
4748: x_msg_count := FND_MSG_PUB.count_msg;
4749:
4750: if x_msg_count = 1 then
4751:
4752: pa_interface_utils_pub.get_messages

Line 4797: x_msg_count := FND_MSG_PUB.count_msg;

4793: ,x_msg_count => x_msg_count
4794: ,x_msg_data => x_msg_data);
4795:
4796: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4797: x_msg_count := FND_MSG_PUB.count_msg;
4798: IF x_msg_count = 1 then
4799: pa_interface_utils_pub.get_messages
4800: (p_encoded => FND_API.G_TRUE,
4801: p_msg_index => 1,

Line 4833: x_msg_count := FND_MSG_PUB.count_msg;

4829: WHEN FND_API.G_EXC_ERROR THEN
4830: IF (p_commit = FND_API.G_TRUE) THEN
4831: ROLLBACK to delete_subproject_ass_pvt;
4832: END IF;
4833: x_msg_count := FND_MSG_PUB.count_msg;
4834: x_return_status := FND_API.G_RET_STS_ERROR;
4835: WHEN OTHERS THEN
4836: IF (p_commit = FND_API.G_TRUE) THEN
4837: ROLLBACK to delete_subproject_ass_pvt;

Line 4840: x_msg_count := FND_MSG_PUB.count_msg;

4836: IF (p_commit = FND_API.G_TRUE) THEN
4837: ROLLBACK to delete_subproject_ass_pvt;
4838: END IF;
4839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4840: x_msg_count := FND_MSG_PUB.count_msg;
4841: --put message
4842: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
4843: p_procedure_name => 'Delete_SubProject_Association',
4844: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 4842: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

4838: END IF;
4839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4840: x_msg_count := FND_MSG_PUB.count_msg;
4841: --put message
4842: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
4843: p_procedure_name => 'Delete_SubProject_Association',
4844: p_error_text => SUBSTRB(SQLERRM,1,240));
4845: RAISE;
4846: END Delete_SubProject_Association;

Line 5042: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

5038:
5039: -- End fix for Bug # 4485908.
5040:
5041: WHEN OTHERS THEN
5042: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5043: p_procedure_name => 'Copy_OG_Lnk_For_Subproj_Ass',
5044: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5045: RAISE FND_API.G_EXC_ERROR;
5046: END;

Line 5071: x_msg_count := FND_MSG_PUB.count_msg;

5067: WHEN FND_API.G_EXC_ERROR THEN
5068: IF (p_commit = FND_API.G_TRUE) THEN
5069: ROLLBACK to Copy_OG_Lnk_For_Subproj_Ass;
5070: END IF;
5071: x_msg_count := FND_MSG_PUB.count_msg;
5072: x_return_status := FND_API.G_RET_STS_ERROR;
5073: WHEN OTHERS THEN
5074: IF (p_commit = FND_API.G_TRUE) THEN
5075: ROLLBACK to Copy_OG_Lnk_For_Subproj_Ass;

Line 5078: x_msg_count := FND_MSG_PUB.count_msg;

5074: IF (p_commit = FND_API.G_TRUE) THEN
5075: ROLLBACK to Copy_OG_Lnk_For_Subproj_Ass;
5076: END IF;
5077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5078: x_msg_count := FND_MSG_PUB.count_msg;
5079: --put message
5080: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5081: p_procedure_name => 'Copy_OG_Lnk_For_Subproj_Ass',
5082: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 5080: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

5076: END IF;
5077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5078: x_msg_count := FND_MSG_PUB.count_msg;
5079: --put message
5080: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5081: p_procedure_name => 'Copy_OG_Lnk_For_Subproj_Ass',
5082: p_error_text => SUBSTRB(SQLERRM,1,240));
5083: RAISE;
5084: END Copy_OG_Lnk_For_Subproj_Ass;

Line 5300: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

5296:
5297: -- End fix for Bug # 4485908.
5298:
5299: WHEN OTHERS THEN
5300: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5301: p_procedure_name => 'Insert_Subproject_Association',
5302: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5303: RAISE FND_API.G_EXC_ERROR;
5304: END;

Line 5328: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

5324:
5325: -- End fix for Bug # 4485908.
5326:
5327: WHEN OTHERS THEN
5328: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5329: p_procedure_name => 'Move_CI_Lnk_For_subproj_step2',
5330: p_error_text => SUBSTRB('PA_RELATIONSHIP_PUB.UPDATE_PROGRAM_GROUPS:'||SQLERRM,1,240));
5331: RAISE FND_API.G_EXC_ERROR;
5332: END;

Line 5381: x_msg_count := FND_MSG_PUB.count_msg;

5377: WHEN FND_API.G_EXC_ERROR THEN
5378: IF (p_commit = FND_API.G_TRUE) THEN
5379: ROLLBACK to Move_CI_Lnk_For_subproj_step2;
5380: END IF;
5381: x_msg_count := FND_MSG_PUB.count_msg;
5382: x_return_status := FND_API.G_RET_STS_ERROR;
5383: WHEN OTHERS THEN
5384: IF (p_commit = FND_API.G_TRUE) THEN
5385: ROLLBACK to Move_CI_Lnk_For_subproj_step2;

Line 5388: x_msg_count := FND_MSG_PUB.count_msg;

5384: IF (p_commit = FND_API.G_TRUE) THEN
5385: ROLLBACK to Move_CI_Lnk_For_subproj_step2;
5386: END IF;
5387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5388: x_msg_count := FND_MSG_PUB.count_msg;
5389: --put message
5390: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5391: p_procedure_name => 'Move_CI_Lnk_For_subproj_step2',
5392: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 5390: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

5386: END IF;
5387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5388: x_msg_count := FND_MSG_PUB.count_msg;
5389: --put message
5390: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5391: p_procedure_name => 'Move_CI_Lnk_For_subproj_step2',
5392: p_error_text => SUBSTRB(SQLERRM,1,240));
5393: RAISE;
5394: END Move_CI_Lnk_For_subproj_step2;

Line 5481: x_msg_count := FND_MSG_PUB.count_msg;

5477: WHEN FND_API.G_EXC_ERROR THEN
5478: IF (p_commit = FND_API.G_TRUE) THEN
5479: ROLLBACK to Move_CI_Lnk_For_subproj_step1;
5480: END IF;
5481: x_msg_count := FND_MSG_PUB.count_msg;
5482: x_return_status := FND_API.G_RET_STS_ERROR;
5483: WHEN OTHERS THEN
5484: IF (p_commit = FND_API.G_TRUE) THEN
5485: ROLLBACK to Move_CI_Lnk_For_subproj_step1;

Line 5488: x_msg_count := FND_MSG_PUB.count_msg;

5484: IF (p_commit = FND_API.G_TRUE) THEN
5485: ROLLBACK to Move_CI_Lnk_For_subproj_step1;
5486: END IF;
5487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5488: x_msg_count := FND_MSG_PUB.count_msg;
5489: --put message
5490: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5491: p_procedure_name => 'Move_CI_Lnk_For_subproj_step1',
5492: p_error_text => SUBSTRB(SQLERRM,1,240));

Line 5490: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',

5486: END IF;
5487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5488: x_msg_count := FND_MSG_PUB.count_msg;
5489: --put message
5490: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIPS_PVT',
5491: p_procedure_name => 'Move_CI_Lnk_For_subproj_step1',
5492: p_error_text => SUBSTRB(SQLERRM,1,240));
5493: RAISE;
5494: END Move_CI_Lnk_For_subproj_step1;

Line 5621: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

5617: if p_commit = FND_API.G_TRUE then
5618: rollback to UPDATE_PARENT_WBS_FLAG_DIRTY;
5619: end if;
5620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5621: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5622: p_procedure_name => 'UPDATE_PARENT_WBS_FLAG_DIRTY',
5623: p_error_text => SUBSTRB(SQLERRM,1,240));
5624: when OTHERS then
5625: if p_commit = FND_API.G_TRUE then

Line 5629: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',

5625: if p_commit = FND_API.G_TRUE then
5626: rollback to UPDATE_PARENT_WBS_FLAG_DIRTY;
5627: end if;
5628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5629: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_PVT',
5630: p_procedure_name => 'UPDATE_PARENT_WBS_FLAG_DIRTY',
5631: p_error_text => SUBSTRB(SQLERRM,1,240));
5632: raise;
5633: END UPDATE_PARENT_WBS_FLAG_DIRTY;