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_EGO_WRAPPER_PUB dependencies on PA_EGO_WRAPPER_PUB

Line 1: PACKAGE BODY PA_EGO_WRAPPER_PUB AS

1: PACKAGE BODY PA_EGO_WRAPPER_PUB AS
2: /* $Header: PAEGOWPB.pls 120.2 2006/01/12 01:52:25 msachan noship $ */
3:
4: l_pkg_name VARCHAR2(30) := 'PA_EGO_WRAPPER_PUB';
5:

Line 4: l_pkg_name VARCHAR2(30) := 'PA_EGO_WRAPPER_PUB';

1: PACKAGE BODY PA_EGO_WRAPPER_PUB AS
2: /* $Header: PAEGOWPB.pls 120.2 2006/01/12 01:52:25 msachan noship $ */
3:
4: l_pkg_name VARCHAR2(30) := 'PA_EGO_WRAPPER_PUB';
5:
6:
7: /*-----------------------------------------------------------+
8: | For Details/Comments Refer Package Specification Comments |

Line 90: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

86: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
87: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
88: x_msg_count := 1; -- NOCOPY change for Bug 4939368
89: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
90: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
91: p_procedure_name => 'check_delete_phase_ok',
92: p_error_text => x_msg_data);
93:
94: WHEN FND_API.G_EXC_ERROR THEN

Line 100: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

96: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
97: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
98: x_msg_count := 1; -- NOCOPY change for Bug 4939368
99: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
100: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
101: p_procedure_name => 'check_delete_phase_ok',
102: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
103:
104: WHEN OTHERS THEN

Line 111: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

107: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
108: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
109: x_msg_count := 1; -- NOCOPY change for Bug 4939368
110: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
111: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
112: p_procedure_name => 'check_delete_phase_ok',
113: p_error_text => x_msg_data);
114: raise;
115: END check_delete_phase_ok;

Line 210: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
207: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
208: x_msg_count := 1; -- NOCOPY change for Bug 4939368
209: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
210: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
211: p_procedure_name => 'process_phase_delete',
212: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
213:
214: WHEN FND_API.G_EXC_ERROR THEN

Line 219: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

215: x_return_status := FND_API.G_RET_STS_ERROR;
216: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
217: x_msg_count := 1; -- NOCOPY change for Bug 4939368
218: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
219: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
220: p_procedure_name => 'process_phase_delete',
221: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
222: IF p_commit = FND_API.G_TRUE THEN
223: ROLLBACK TO wrapper_process_phase_delete;

Line 234: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
231: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
232: x_msg_count := 1; -- NOCOPY change for Bug 4939368
233: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
234: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
235: p_procedure_name => 'process_phase_delete',
236: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
237: raise;
238: END process_phase_delete;

Line 327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

323: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
324: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
325: x_msg_count := 1; -- NOCOPY change for Bug 4939368
326: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
327: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
328: p_procedure_name => 'check_delete_lifecycle_ok',
329: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
330:
331: WHEN FND_API.G_EXC_ERROR THEN

Line 337: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

333: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
334: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
335: x_msg_count := 1; -- NOCOPY change for Bug 4939368
336: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
337: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
338: p_procedure_name => 'check_delete_lifecycle_ok',
339: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
340:
341: WHEN OTHERS THEN

Line 348: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

344: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
345: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
346: x_msg_count := 1; -- NOCOPY change for Bug 4939368
347: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
348: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
349: p_procedure_name => 'check_delete_lifecycle_ok',
350: p_error_text => x_msg_data);
351: raise;
352: END check_delete_lifecycle_ok;

Line 450: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
447: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
448: x_msg_count := 1; -- NOCOPY change for Bug 4939368
449: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
450: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
451: p_procedure_name => 'delete_stale_data_for_lc',
452: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
453:
454: WHEN FND_API.G_EXC_ERROR THEN

Line 459: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

455: x_return_status := FND_API.G_RET_STS_ERROR;
456: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
457: x_msg_count := 1; -- NOCOPY change for Bug 4939368
458: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
459: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
460: p_procedure_name => 'delete_stale_data_for_lc',
461: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
462: IF p_commit = FND_API.G_TRUE THEN
463: ROLLBACK TO wrapper_delete_data_for_lc;

Line 474: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
472: x_msg_count := 1; -- NOCOPY change for Bug 4939368
473: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
474: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
475: p_procedure_name => 'delete_stale_data_for_lc',
476: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
477: raise;
478: END delete_stale_data_for_lc;

Line 559: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

555: x_error_message := SQLERRM; -- NOCOPY change for Bug 4939368
556: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
557: x_msg_count := 1; -- NOCOPY change for Bug 4939368
558: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
559: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
560: p_procedure_name => 'get_policy_for_phase_change',
561: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
562:
563: WHEN FND_API.G_EXC_ERROR THEN

Line 570: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

566: x_error_message := SQLERRM; -- NOCOPY change for Bug 4939368
567: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
568: x_msg_count := 1; -- NOCOPY change for Bug 4939368
569: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
570: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
571: p_procedure_name => 'get_policy_for_phase_change',
572: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
573:
574: WHEN OTHERS THEN

Line 582: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

578: x_error_message := SQLERRM; -- NOCOPY change for Bug 4939368
579: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
580: x_msg_count := 1; -- NOCOPY change for Bug 4939368
581: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
582: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
583: p_procedure_name => 'get_policy_for_phase_change',
584: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
585: raise;
586: END get_policy_for_phase_change;

Line 719: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

715: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
716: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
717: x_msg_count := 1; -- NOCOPY change for Bug 4939368
718: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
719: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
720: p_procedure_name => 'sync_phase_change',
721: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
722:
723: WHEN FND_API.G_EXC_ERROR THEN

Line 731: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

727: END IF;
728: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
729: x_msg_count := 1; -- NOCOPY change for Bug 4939368
730: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
731: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
732: p_procedure_name => 'sync_phase_change',
733: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
734:
735: /* Added for 4049700 */

Line 748: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

744: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
745: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
746: x_msg_count := 1; -- NOCOPY change for Bug 4939368
747: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
748: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
749: p_procedure_name => 'sync_phase_change',
750: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
751: raise;
752: END sync_phase_change;

Line 817: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

813: x_is_lifecycle_tracking := FND_API.G_TRUE; -- NOCOPY change for Bug 4939368
814: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
815: x_msg_count := 1; -- NOCOPY change for Bug 4939368
816: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
817: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
818: p_procedure_name => 'check_lc_tracking_project',
819: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
820:
821: WHEN FND_API.G_EXC_ERROR THEN

Line 827: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

823: x_is_lifecycle_tracking := FND_API.G_TRUE; -- NOCOPY change for Bug 4939368
824: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
825: x_msg_count := 1; -- NOCOPY change for Bug 4939368
826: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
827: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
828: p_procedure_name => 'check_lc_tracking_project',
829: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
830:
831: WHEN OTHERS THEN

Line 837: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

833: x_is_lifecycle_tracking := FND_API.G_TRUE; -- NOCOPY change for Bug 4939368
834: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
835: x_msg_count := 1; -- NOCOPY change for Bug 4939368
836: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
837: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
838: p_procedure_name => 'check_lc_tracking_project',
839: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
840: raise;
841: END check_lc_tracking_project;

Line 928: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

924: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
925: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
926: x_msg_count := 1; -- NOCOPY change for Bug 4939368
927: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
928: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
929: p_procedure_name => 'check_delete_project_ok',
930: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
931:
932: WHEN FND_API.G_EXC_ERROR THEN

Line 938: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

934: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
935: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
936: x_msg_count := 1; -- NOCOPY change for Bug 4939368
937: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
938: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
939: p_procedure_name => 'check_delete_project_ok',
940: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
941:
942: WHEN OTHERS THEN

Line 949: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

945: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
946: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
947: x_msg_count := 1; -- NOCOPY change for Bug 4939368
948: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
949: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
950: p_procedure_name => 'check_delete_project_ok',
951: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
952: raise;
953: END check_delete_project_ok;

Line 1052: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1049: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1050: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1051: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1052: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1053: p_procedure_name => 'delete_all_item_assocs',
1054: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1055:
1056: WHEN FND_API.G_EXC_ERROR THEN

Line 1061: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1059: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1060: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1061: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1062: p_procedure_name => 'delete_all_item_assocs',
1063: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1064: IF p_commit = FND_API.G_TRUE THEN
1065: ROLLBACK TO wrapper_delete_all_item_assocs;

Line 1076: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1072: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1073: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1074: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1075: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1076: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1077: p_procedure_name => 'delete_all_item_assocs',
1078: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1079: raise;
1080: END delete_all_item_assocs;

Line 1221: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1218: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1219: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1220: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1221: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1222: p_procedure_name => 'copy_item_assocs',
1223: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1224:
1225: WHEN FND_API.G_EXC_ERROR THEN

Line 1230: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1228: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1229: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1230: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1231: p_procedure_name => 'copy_item_assocs',
1232: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1233: IF p_commit = FND_API.G_TRUE THEN
1234: ROLLBACK TO wrapper_copy_item_assocs;

Line 1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1242: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1243: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1244: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1245: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1246: p_procedure_name => 'copy_item_assocs',
1247: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1248: raise;
1249: END copy_item_assocs;

Line 1332: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1328: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
1329: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1330: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1331: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1332: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1333: p_procedure_name => 'check_delete_project_ok_eng',
1334: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1335:
1336: WHEN FND_API.G_EXC_ERROR THEN

Line 1342: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1338: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
1339: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1340: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1341: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1342: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1343: p_procedure_name => 'check_delete_project_ok_eng',
1344: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1345:
1346: WHEN OTHERS THEN

Line 1353: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1349: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
1350: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1351: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1352: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1353: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1354: p_procedure_name => 'check_delete_project_ok_eng',
1355: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1356: raise;
1357: END check_delete_project_ok_eng;

Line 1442: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1438: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
1439: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1440: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1441: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1442: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1443: p_procedure_name => 'check_delete_task_ok_eng',
1444: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1445:
1446: WHEN FND_API.G_EXC_ERROR THEN

Line 1452: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1448: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
1449: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1450: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1451: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1452: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1453: p_procedure_name => 'check_delete_task_ok_eng',
1454: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1455:
1456: WHEN OTHERS THEN

Line 1463: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1459: x_delete_ok := FND_API.G_FALSE; -- NOCOPY change for Bug 4939368
1460: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1461: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1462: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1463: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1464: p_procedure_name => 'check_delete_task_ok_eng',
1465: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1466: raise;
1467: END check_delete_task_ok_eng;

Line 1561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1558: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1559: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1560: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1561: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1562: p_procedure_name => 'process_phase_code_delete',
1563: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1564:
1565: WHEN FND_API.G_EXC_ERROR THEN

Line 1570: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1566: x_return_status := FND_API.G_RET_STS_ERROR;
1567: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1568: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1569: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1570: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1571: p_procedure_name => 'process_phase_code_delete',
1572: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1573: IF p_commit = FND_API.G_TRUE THEN
1574: ROLLBACK TO wrp_process_phase_code_delete;

Line 1585: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',

1581: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1582: x_errorcode := SQLCODE; -- NOCOPY change for Bug 4939368
1583: x_msg_count := 1; -- NOCOPY change for Bug 4939368
1584: x_msg_data := substrb(SQLERRM,1,240); -- NOCOPY change for Bug 4939368
1585: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_EGO_WRAPPER_PUB',
1586: p_procedure_name => 'process_phase_code_delete',
1587: p_error_text => x_msg_data); -- NOCOPY change for Bug 4939368
1588: raise;
1589: END process_phase_code_delete;

Line 1596: END PA_EGO_WRAPPER_PUB;

1592:
1593:
1594:
1595:
1596: END PA_EGO_WRAPPER_PUB;