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_PVT dependencies on PA_PROJ_TEMPLATE_SETUP_PVT

Line 1: PACKAGE BODY PA_PROJ_TEMPLATE_SETUP_PVT AS

1: PACKAGE BODY PA_PROJ_TEMPLATE_SETUP_PVT AS
2: /* $Header: PATMSTVB.pls 120.7 2011/05/11 11:51:03 pcheruvu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJ_TEMPLATE_SETUP_PVT';
5:

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

1: PACKAGE BODY PA_PROJ_TEMPLATE_SETUP_PVT AS
2: /* $Header: PATMSTVB.pls 120.7 2011/05/11 11:51:03 pcheruvu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'PA_PROJ_TEMPLATE_SETUP_PVT';
5:
6: -- API name : Create_Project_Template
7: -- Type : Public API
8: -- Pre-reqs : None

Line 208: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template');

204: l_ar_rec_notify_flag VARCHAR2(1) := 'N'; -- 7508661 : EnC
205: l_auto_release_pwp_inv VARCHAR2(1) := 'Y'; -- 7508661 : EnC
206:
207: BEGIN
208: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template');
209:
210: IF (p_debug_mode = 'Y') THEN
211: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template begin');
212: END IF;

Line 211: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template begin');

207: BEGIN
208: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template');
209:
210: IF (p_debug_mode = 'Y') THEN
211: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template begin');
212: END IF;
213:
214: IF (p_commit = FND_API.G_TRUE) THEN
215: savepoint Create_Project_Template;

Line 1144: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template END');

1140: COMMIT;
1141: END IF;
1142:
1143: IF (p_debug_mode = 'Y') THEN
1144: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template END');
1145: END IF;
1146: EXCEPTION
1147: when FND_API.G_EXC_ERROR then
1148: if p_commit = FND_API.G_TRUE then

Line 1157: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

1153: if p_commit = FND_API.G_TRUE then
1154: rollback to Create_Project_Template;
1155: end if;
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
1158: p_procedure_name => 'Create_Project_Template',
1159: p_error_text => SUBSTRB(SQLERRM,1,240));
1160: when OTHERS then
1161: if p_commit = FND_API.G_TRUE then

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

1161: if p_commit = FND_API.G_TRUE then
1162: rollback to Create_Project_Template;
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_PVT',
1166: p_procedure_name => 'Create_Project_Template',
1167: p_error_text => SUBSTRB(SQLERRM,1,240));
1168: raise;
1169: END Create_Project_Template;

Line 1399: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template');

1395: l_old_funds_flag VARCHAR2(1) := 'N';
1396: --sunkalya federal
1397:
1398: BEGIN
1399: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template');
1400:
1401: IF (p_debug_mode = 'Y') THEN
1402: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template begin');
1403: END IF;

Line 1402: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template begin');

1398: BEGIN
1399: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template');
1400:
1401: IF (p_debug_mode = 'Y') THEN
1402: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template begin');
1403: END IF;
1404:
1405: IF (p_commit = FND_API.G_TRUE) THEN
1406: savepoint Update_Project_Template;

Line 2114: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template END');

2110: COMMIT;
2111: END IF;
2112:
2113: IF (p_debug_mode = 'Y') THEN
2114: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template END');
2115: END IF;
2116: EXCEPTION
2117: when FND_API.G_EXC_ERROR then
2118: if p_commit = FND_API.G_TRUE then

Line 2127: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2123: if p_commit = FND_API.G_TRUE then
2124: rollback to Update_Project_Template;
2125: end if;
2126: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2127: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2128: p_procedure_name => 'Update_Project_Template',
2129: p_error_text => SUBSTRB(SQLERRM,1,240));
2130: when OTHERS then
2131: if p_commit = FND_API.G_TRUE then

Line 2135: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2131: if p_commit = FND_API.G_TRUE then
2132: rollback to Update_Project_Template;
2133: end if;
2134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2135: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2136: p_procedure_name => 'Update_Project_Template',
2137: p_error_text => SUBSTRB(SQLERRM,1,240));
2138: raise;
2139: END Update_Project_Template;

Line 2182: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template');

2178: l_err_stack VARCHAR2(250);
2179:
2180:
2181: BEGIN
2182: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template');
2183:
2184: IF (p_debug_mode = 'Y') THEN
2185: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template begin');
2186: END IF;

Line 2185: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template begin');

2181: BEGIN
2182: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template');
2183:
2184: IF (p_debug_mode = 'Y') THEN
2185: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template begin');
2186: END IF;
2187:
2188: IF (p_commit = FND_API.G_TRUE) THEN
2189: savepoint Delete_Project_Template;

Line 2223: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template END');

2219: COMMIT;
2220: END IF;
2221:
2222: IF (p_debug_mode = 'Y') THEN
2223: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template END');
2224: END IF;
2225: EXCEPTION
2226: when FND_API.G_EXC_ERROR then
2227: if p_commit = FND_API.G_TRUE then

Line 2236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2232: if p_commit = FND_API.G_TRUE then
2233: rollback to Delete_Project_Template;
2234: end if;
2235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2236: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2237: p_procedure_name => 'Delete_Project_Template',
2238: p_error_text => SUBSTRB(SQLERRM,1,240));
2239: when OTHERS then
2240: if p_commit = FND_API.G_TRUE then

Line 2244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2240: if p_commit = FND_API.G_TRUE then
2241: rollback to Delete_Project_Template;
2242: end if;
2243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2244: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2245: p_procedure_name => 'Delete_Project_Template',
2246: p_error_text => SUBSTRB(SQLERRM,1,240));
2247: raise;
2248: END Delete_Project_Template;

Line 2299: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options');

2295: FROM pa_project_options
2296: WHERE project_id = p_project_id
2297: AND option_code = p_option_code;
2298: BEGIN
2299: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options');
2300:
2301: IF (p_debug_mode = 'Y') THEN
2302: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options begin');
2303: END IF;

Line 2302: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options begin');

2298: BEGIN
2299: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options');
2300:
2301: IF (p_debug_mode = 'Y') THEN
2302: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options begin');
2303: END IF;
2304:
2305: IF (p_commit = FND_API.G_TRUE) THEN
2306: savepoint Add_Project_Options;

Line 2356: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options END');

2352: COMMIT;
2353: END IF;
2354:
2355: IF (p_debug_mode = 'Y') THEN
2356: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options END');
2357: END IF;
2358: EXCEPTION
2359: when FND_API.G_EXC_ERROR then
2360: if p_commit = FND_API.G_TRUE then

Line 2369: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2365: if p_commit = FND_API.G_TRUE then
2366: rollback to Add_Project_Options;
2367: end if;
2368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2369: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2370: p_procedure_name => 'Add_Project_Options',
2371: p_error_text => SUBSTRB(SQLERRM,1,240));
2372: when OTHERS then
2373: if p_commit = FND_API.G_TRUE then

Line 2377: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2373: if p_commit = FND_API.G_TRUE then
2374: rollback to Add_Project_Options;
2375: end if;
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2377: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2378: p_procedure_name => 'Add_Project_Options',
2379: p_error_text => SUBSTRB(SQLERRM,1,240));
2380: raise;
2381: END Add_Project_Options;

Line 2443: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options');

2439:
2440: l_allow_ovr_enabled VARCHAR2(1);
2441: -- End of changes
2442: BEGIN
2443: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options');
2444:
2445: IF (p_debug_mode = 'Y') THEN
2446: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options begin');
2447: END IF;

Line 2446: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options begin');

2442: BEGIN
2443: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options');
2444:
2445: IF (p_debug_mode = 'Y') THEN
2446: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options begin');
2447: END IF;
2448:
2449: IF (p_commit = FND_API.G_TRUE) THEN
2450: savepoint Delete_Project_Options;

Line 2508: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options END');

2504: COMMIT;
2505: END IF;
2506:
2507: IF (p_debug_mode = 'Y') THEN
2508: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options END');
2509: END IF;
2510: EXCEPTION
2511: when FND_API.G_EXC_ERROR then
2512: if p_commit = FND_API.G_TRUE then

Line 2521: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2517: if p_commit = FND_API.G_TRUE then
2518: rollback to Delete_Project_Options;
2519: end if;
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2522: p_procedure_name => 'Delete_Project_Options',
2523: p_error_text => SUBSTRB(SQLERRM,1,240));
2524: when OTHERS then
2525: if p_commit = FND_API.G_TRUE then

Line 2529: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2525: if p_commit = FND_API.G_TRUE then
2526: rollback to Delete_Project_Options;
2527: end if;
2528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2529: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2530: p_procedure_name => 'Delete_Project_Options',
2531: p_error_text => SUBSTRB(SQLERRM,1,240));
2532: raise;
2533: END Delete_Project_Options;

Line 2608: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field');

2604: AND field_name = p_field_name;
2605:
2606:
2607: BEGIN
2608: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field');
2609:
2610: IF (p_debug_mode = 'Y') THEN
2611: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field begin');
2612: END IF;

Line 2611: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field begin');

2607: BEGIN
2608: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field');
2609:
2610: IF (p_debug_mode = 'Y') THEN
2611: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field begin');
2612: END IF;
2613:
2614: IF (p_commit = FND_API.G_TRUE) THEN
2615: savepoint Add_Quick_Entry_Field;

Line 2808: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field END');

2804: COMMIT;
2805: END IF;
2806:
2807: IF (p_debug_mode = 'Y') THEN
2808: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field END');
2809: END IF;
2810: EXCEPTION
2811: when FND_API.G_EXC_ERROR then
2812: if p_commit = FND_API.G_TRUE then

Line 2821: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2817: if p_commit = FND_API.G_TRUE then
2818: rollback to Add_Quick_Entry_Field;
2819: end if;
2820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2821: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2822: p_procedure_name => 'Add_Quick_Entry_Field',
2823: p_error_text => SUBSTRB(SQLERRM,1,240));
2824: when OTHERS then
2825: if p_commit = FND_API.G_TRUE then

Line 2829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

2825: if p_commit = FND_API.G_TRUE then
2826: rollback to Add_Quick_Entry_Field;
2827: end if;
2828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2829: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2830: p_procedure_name => 'Add_Quick_Entry_Field',
2831: p_error_text => SUBSTRB(SQLERRM,1,240));
2832: raise;
2833: END Add_Quick_Entry_Field;

Line 2901: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field');

2897: WHERE rowid <> p_row_id
2898: AND project_id = p_project_id
2899: AND field_name = p_field_name;
2900: BEGIN
2901: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field');
2902:
2903: IF (p_debug_mode = 'Y') THEN
2904: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field begin');
2905: END IF;

Line 2904: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field begin');

2900: BEGIN
2901: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field');
2902:
2903: IF (p_debug_mode = 'Y') THEN
2904: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field begin');
2905: END IF;
2906:
2907: IF (p_commit = FND_API.G_TRUE) THEN
2908: savepoint Update_Quick_Entry_Field;

Line 3082: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field END');

3078: COMMIT;
3079: END IF;
3080:
3081: IF (p_debug_mode = 'Y') THEN
3082: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field END');
3083: END IF;
3084: EXCEPTION
3085: when FND_API.G_EXC_ERROR then
3086: if p_commit = FND_API.G_TRUE then

Line 3095: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

3091: if p_commit = FND_API.G_TRUE then
3092: rollback to Update_Quick_Entry_Field;
3093: end if;
3094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3095: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3096: p_procedure_name => 'Update_Quick_Entry_Field',
3097: p_error_text => SUBSTRB(SQLERRM,1,240));
3098: when OTHERS then
3099: if p_commit = FND_API.G_TRUE then

Line 3103: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

3099: if p_commit = FND_API.G_TRUE then
3100: rollback to Update_Quick_Entry_Field;
3101: end if;
3102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3103: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3104: p_procedure_name => 'Update_Quick_Entry_Field',
3105: p_error_text => SUBSTRB(SQLERRM,1,240));
3106: raise;
3107: END Update_Quick_Entry_Field;

Line 3162: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field');

3158:
3159: l_field_name VARCHAR2(80);
3160:
3161: BEGIN
3162: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field');
3163:
3164: IF (p_debug_mode = 'Y') THEN
3165: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field begin');
3166: END IF;

Line 3165: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field begin');

3161: BEGIN
3162: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field');
3163:
3164: IF (p_debug_mode = 'Y') THEN
3165: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field begin');
3166: END IF;
3167:
3168: IF (p_commit = FND_API.G_TRUE) THEN
3169: savepoint Delete_Quick_Entry_Field;

Line 3204: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field END');

3200: COMMIT;
3201: END IF;
3202:
3203: IF (p_debug_mode = 'Y') THEN
3204: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field END');
3205: END IF;
3206: EXCEPTION
3207: when FND_API.G_EXC_ERROR then
3208: if p_commit = FND_API.G_TRUE then

Line 3217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

3213: if p_commit = FND_API.G_TRUE then
3214: rollback to Delete_Quick_Entry_Field;
3215: end if;
3216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3217: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3218: p_procedure_name => 'Delete_Quick_Entry_Field',
3219: p_error_text => SUBSTRB(SQLERRM,1,240));
3220: when OTHERS then
3221: if p_commit = FND_API.G_TRUE then

Line 3225: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',

3221: if p_commit = FND_API.G_TRUE then
3222: rollback to Delete_Quick_Entry_Field;
3223: end if;
3224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3225: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3226: p_procedure_name => 'Delete_Quick_Entry_Field',
3227: p_error_text => SUBSTRB(SQLERRM,1,240));
3228: raise;
3229: END Delete_Quick_Entry_Field;

Line 3306: END PA_PROJ_TEMPLATE_SETUP_PVT;

3302: END IF; --<< l_insert_flag >>
3303: END LOOP;
3304: END enable_disbale_proj_opt;
3305:
3306: END PA_PROJ_TEMPLATE_SETUP_PVT;