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_PROJ_TEMPLATE_SETUP_PUB dependencies on PA_PROJ_TEMPLATE_SETUP_PUB

Line 1: PACKAGE BODY PA_PROJ_TEMPLATE_SETUP_PUB AS

1: PACKAGE BODY PA_PROJ_TEMPLATE_SETUP_PUB AS
2: /* $Header: PATMSTPB.pls 120.3 2005/08/22 05:53:44 sunkalya noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJ_TEMPLATE_SETUP_PUB';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJ_TEMPLATE_SETUP_PUB';

1: PACKAGE BODY PA_PROJ_TEMPLATE_SETUP_PUB AS
2: /* $Header: PATMSTPB.pls 120.3 2005/08/22 05:53:44 sunkalya noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJ_TEMPLATE_SETUP_PUB';
5:
6: -- API name : Create_Project_Template
7: -- Type : Public API
8: -- Pre-reqs : None

Line 66: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Create_Project_Template');

62: l_new_organization_id NUMBER;
63: -- added for Bug fix: 4537865
64: l_organization_name hr_all_organization_units_tl.name%TYPE; --Bug 2931569
65: BEGIN
66: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Create_Project_Template');
67:
68: IF (p_debug_mode = 'Y') THEN
69: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Create_Project_Template begin');
70: END IF;

Line 69: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Create_Project_Template begin');

65: BEGIN
66: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Create_Project_Template');
67:
68: IF (p_debug_mode = 'Y') THEN
69: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Create_Project_Template begin');
70: END IF;
71:
72: IF (p_commit = FND_API.G_TRUE) THEN
73: savepoint Create_Project_Template;

Line 196: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Create_Project_Template END');

192: COMMIT;
193: END IF;
194:
195: IF (p_debug_mode = 'Y') THEN
196: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Create_Project_Template END');
197: END IF;
198: EXCEPTION
199: when FND_API.G_EXC_ERROR then
200: if p_commit = FND_API.G_TRUE then

Line 209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

205: if p_commit = FND_API.G_TRUE then
206: rollback to Create_Project_Template;
207: end if;
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
210: p_procedure_name => 'Create_Project_Template',
211: p_error_text => SUBSTRB(SQLERRM,1,240));
212: when OTHERS then
213: if p_commit = FND_API.G_TRUE then

Line 217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

213: if p_commit = FND_API.G_TRUE then
214: rollback to Create_Project_Template;
215: end if;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
218: p_procedure_name => 'Create_Project_Template',
219: p_error_text => SUBSTRB(SQLERRM,1,240));
220: raise;
221: END Create_Project_Template;

Line 290: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template');

286: l_organization_name hr_all_organization_units_tl.name%TYPE; --Bug 2931569
287:
288: l_dummy_char VARCHAR2(1);
289: BEGIN
290: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template');
291:
292: IF (p_debug_mode = 'Y') THEN
293: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template begin');
294: END IF;

Line 293: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template begin');

289: BEGIN
290: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template');
291:
292: IF (p_debug_mode = 'Y') THEN
293: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template begin');
294: END IF;
295:
296: IF (p_commit = FND_API.G_TRUE) THEN
297: savepoint Update_Project_Template;

Line 488: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template END');

484: COMMIT;
485: END IF;
486:
487: IF (p_debug_mode = 'Y') THEN
488: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Project_Template END');
489: END IF;
490: EXCEPTION
491: when FND_API.G_EXC_ERROR then
492: if p_commit = FND_API.G_TRUE then

Line 501: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

497: if p_commit = FND_API.G_TRUE then
498: rollback to Update_Project_Template;
499: end if;
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
501: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
502: p_procedure_name => 'Update_Project_Template',
503: p_error_text => SUBSTRB(SQLERRM,1,240));
504: when OTHERS then
505: if p_commit = FND_API.G_TRUE then

Line 509: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

505: if p_commit = FND_API.G_TRUE then
506: rollback to Update_Project_Template;
507: end if;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
510: p_procedure_name => 'Update_Project_Template',
511: p_error_text => SUBSTRB(SQLERRM,1,240));
512: raise;
513: END Update_Project_Template;

Line 557: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template');

553:
554: l_organization_id NUMBER;
555: l_dummy_char VARCHAR2(1);
556: BEGIN
557: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template');
558:
559: IF (p_debug_mode = 'Y') THEN
560: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template begin');
561: END IF;

Line 560: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template begin');

556: BEGIN
557: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template');
558:
559: IF (p_debug_mode = 'Y') THEN
560: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template begin');
561: END IF;
562:
563: IF (p_commit = FND_API.G_TRUE) THEN
564: savepoint Delete_Project_Template;

Line 683: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template END');

679: COMMIT;
680: END IF;
681:
682: IF (p_debug_mode = 'Y') THEN
683: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Template END');
684: END IF;
685: EXCEPTION
686: when FND_API.G_EXC_ERROR then
687: if p_commit = FND_API.G_TRUE then

Line 696: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

692: if p_commit = FND_API.G_TRUE then
693: rollback to Delete_Project_Template;
694: end if;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
697: p_procedure_name => 'Delete_Project_Template',
698: p_error_text => SUBSTRB(SQLERRM,1,240));
699: when OTHERS then
700: if p_commit = FND_API.G_TRUE then

Line 704: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

700: if p_commit = FND_API.G_TRUE then
701: rollback to Delete_Project_Template;
702: end if;
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
705: p_procedure_name => 'Delete_Project_Template',
706: p_error_text => SUBSTRB(SQLERRM,1,240));
707: raise;
708: END Delete_Project_Template;

Line 753: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Project_Options');

749: l_error_msg_code VARCHAR2(250);
750:
751: l_organization_id NUMBER;
752: BEGIN
753: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Project_Options');
754:
755: IF (p_debug_mode = 'Y') THEN
756: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Project_Options');
757: END IF;

Line 756: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Project_Options');

752: BEGIN
753: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Project_Options');
754:
755: IF (p_debug_mode = 'Y') THEN
756: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Project_Options');
757: END IF;
758:
759: IF (p_commit = FND_API.G_TRUE) THEN
760: savepoint Add_Project_Options;

Line 810: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Project_Options END');

806: COMMIT;
807: END IF;
808:
809: IF (p_debug_mode = 'Y') THEN
810: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Project_Options END');
811: END IF;
812: EXCEPTION
813: when FND_API.G_EXC_ERROR then
814: if p_commit = FND_API.G_TRUE then

Line 823: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

819: if p_commit = FND_API.G_TRUE then
820: rollback to Add_Project_Options;
821: end if;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
824: p_procedure_name => 'Add_Project_Options',
825: p_error_text => SUBSTRB(SQLERRM,1,240));
826: when OTHERS then
827: if p_commit = FND_API.G_TRUE then

Line 831: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

827: if p_commit = FND_API.G_TRUE then
828: rollback to Add_Project_Options;
829: end if;
830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
831: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
832: p_procedure_name => 'Add_Project_Options',
833: p_error_text => SUBSTRB(SQLERRM,1,240));
834: raise;
835: END Add_Project_Options;

Line 881: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options');

877: l_error_msg_code VARCHAR2(250);
878:
879: l_organization_id NUMBER;
880: BEGIN
881: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options');
882:
883: IF (p_debug_mode = 'Y') THEN
884: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options');
885: END IF;

Line 884: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options');

880: BEGIN
881: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options');
882:
883: IF (p_debug_mode = 'Y') THEN
884: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options');
885: END IF;
886:
887: IF (p_commit = FND_API.G_TRUE) THEN
888: savepoint Delete_Project_Options;

Line 937: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options END');

933: COMMIT;
934: END IF;
935:
936: IF (p_debug_mode = 'Y') THEN
937: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Project_Options END');
938: END IF;
939: EXCEPTION
940: when FND_API.G_EXC_ERROR then
941: if p_commit = FND_API.G_TRUE then

Line 950: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

946: if p_commit = FND_API.G_TRUE then
947: rollback to Delete_Project_Options;
948: end if;
949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
951: p_procedure_name => 'Delete_Project_Options',
952: p_error_text => SUBSTRB(SQLERRM,1,240));
953: when OTHERS then
954: if p_commit = FND_API.G_TRUE then

Line 958: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

954: if p_commit = FND_API.G_TRUE then
955: rollback to Delete_Project_Options;
956: end if;
957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
959: p_procedure_name => 'Delete_Project_Options',
960: p_error_text => SUBSTRB(SQLERRM,1,240));
961: raise;
962: END Delete_Project_Options;

Line 1017: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Quick_Entry_Field');

1013: l_limiting_value VARCHAR2(80);
1014: BEGIN
1015: x_return_status := FND_API.G_RET_STS_SUCCESS;
1016:
1017: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Quick_Entry_Field');
1018:
1019: IF (p_debug_mode = 'Y') THEN
1020: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Quick_Entry_Field');
1021: END IF;

Line 1020: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Quick_Entry_Field');

1016:
1017: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Quick_Entry_Field');
1018:
1019: IF (p_debug_mode = 'Y') THEN
1020: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Quick_Entry_Field');
1021: END IF;
1022:
1023: IF (p_commit = FND_API.G_TRUE) THEN
1024: savepoint Add_Quick_Entry_Field;

Line 1152: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Quick_Entry_Field END');

1148: COMMIT;
1149: END IF;
1150:
1151: IF (p_debug_mode = 'Y') THEN
1152: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Add_Quick_Entry_Field END');
1153: END IF;
1154: EXCEPTION
1155: when FND_API.G_EXC_ERROR then
1156: if p_commit = FND_API.G_TRUE then

Line 1165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1161: if p_commit = FND_API.G_TRUE then
1162: rollback to Add_Quick_Entry_Field;
1163: end if;
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1166: p_procedure_name => 'Add_Quick_Entry_Field',
1167: p_error_text => SUBSTRB(SQLERRM,1,240));
1168: when OTHERS then
1169: if p_commit = FND_API.G_TRUE then

Line 1173: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1169: if p_commit = FND_API.G_TRUE then
1170: rollback to Add_Quick_Entry_Field;
1171: end if;
1172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1173: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1174: p_procedure_name => 'Add_Quick_Entry_Field',
1175: p_error_text => SUBSTRB(SQLERRM,1,240));
1176: raise;
1177: END Add_Quick_Entry_Field;

Line 1243: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field');

1239: WHERE rowid = p_row_id;
1240: BEGIN
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:
1243: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field');
1244:
1245: IF (p_debug_mode = 'Y') THEN
1246: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field');
1247: END IF;

Line 1246: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field');

1242:
1243: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field');
1244:
1245: IF (p_debug_mode = 'Y') THEN
1246: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field');
1247: END IF;
1248:
1249: IF (p_commit = FND_API.G_TRUE) THEN
1250: savepoint Update_Quick_Entry_Field;

Line 1467: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field END');

1463: COMMIT;
1464: END IF;
1465:
1466: IF (p_debug_mode = 'Y') THEN
1467: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Update_Quick_Entry_Field END');
1468: END IF;
1469: EXCEPTION
1470: when FND_API.G_EXC_ERROR then
1471: if p_commit = FND_API.G_TRUE then

Line 1480: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1476: if p_commit = FND_API.G_TRUE then
1477: rollback to Update_Quick_Entry_Field;
1478: end if;
1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1480: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1481: p_procedure_name => 'Update_Quick_Entry_Field',
1482: p_error_text => SUBSTRB(SQLERRM,1,240));
1483: when OTHERS then
1484: if p_commit = FND_API.G_TRUE then

Line 1488: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1484: if p_commit = FND_API.G_TRUE then
1485: rollback to Update_Quick_Entry_Field;
1486: end if;
1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1488: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1489: p_procedure_name => 'Update_Quick_Entry_Field',
1490: p_error_text => SUBSTRB(SQLERRM,1,240));
1491: raise;
1492: END Update_Quick_Entry_Field;

Line 1540: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field');

1536:
1537: l_organization_id NUMBER;
1538: l_dummy_char VARCHAR2(1);
1539: BEGIN
1540: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field');
1541:
1542: IF (p_debug_mode = 'Y') THEN
1543: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field');
1544: END IF;

Line 1543: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field');

1539: BEGIN
1540: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field');
1541:
1542: IF (p_debug_mode = 'Y') THEN
1543: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field');
1544: END IF;
1545:
1546: IF (p_commit = FND_API.G_TRUE) THEN
1547: savepoint Delete_Quick_Entry_Field;

Line 1669: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field END');

1665: COMMIT;
1666: END IF;
1667:
1668: IF (p_debug_mode = 'Y') THEN
1669: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PUB.Delete_Quick_Entry_Field END');
1670: END IF;
1671: EXCEPTION
1672: when FND_API.G_EXC_ERROR then
1673: if p_commit = FND_API.G_TRUE then

Line 1682: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1678: if p_commit = FND_API.G_TRUE then
1679: rollback to Delete_Quick_Entry_Field;
1680: end if;
1681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1682: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1683: p_procedure_name => 'Delete_Quick_Entry_Field',
1684: p_error_text => SUBSTRB(SQLERRM,1,240));
1685: when OTHERS then
1686: if p_commit = FND_API.G_TRUE then

Line 1690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',

1686: if p_commit = FND_API.G_TRUE then
1687: rollback to Delete_Quick_Entry_Field;
1688: end if;
1689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1690: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PUB',
1691: p_procedure_name => 'Delete_Quick_Entry_Field',
1692: p_error_text => SUBSTRB(SQLERRM,1,240));
1693: raise;
1694: END Delete_Quick_Entry_Field;

Line 1697: END PA_PROJ_TEMPLATE_SETUP_PUB;

1693: raise;
1694: END Delete_Quick_Entry_Field;
1695:
1696:
1697: END PA_PROJ_TEMPLATE_SETUP_PUB;