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.4.12010000.2 2008/10/27 17:03:36 atshukla 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.4.12010000.2 2008/10/27 17:03:36 atshukla 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 1139: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template END');

1135: COMMIT;
1136: END IF;
1137:
1138: IF (p_debug_mode = 'Y') THEN
1139: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Create_Project_Template END');
1140: END IF;
1141: EXCEPTION
1142: when FND_API.G_EXC_ERROR then
1143: if p_commit = FND_API.G_TRUE then

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

1148: if p_commit = FND_API.G_TRUE then
1149: rollback to Create_Project_Template;
1150: end if;
1151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1152: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
1153: p_procedure_name => 'Create_Project_Template',
1154: p_error_text => SUBSTRB(SQLERRM,1,240));
1155: when OTHERS then
1156: if p_commit = FND_API.G_TRUE then

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

1156: if p_commit = FND_API.G_TRUE then
1157: rollback to Create_Project_Template;
1158: end if;
1159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1160: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
1161: p_procedure_name => 'Create_Project_Template',
1162: p_error_text => SUBSTRB(SQLERRM,1,240));
1163: raise;
1164: END Create_Project_Template;

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

1390: l_old_funds_flag VARCHAR2(1) := 'N';
1391: --sunkalya federal
1392:
1393: BEGIN
1394: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template');
1395:
1396: IF (p_debug_mode = 'Y') THEN
1397: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template begin');
1398: END IF;

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

1393: BEGIN
1394: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template');
1395:
1396: IF (p_debug_mode = 'Y') THEN
1397: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template begin');
1398: END IF;
1399:
1400: IF (p_commit = FND_API.G_TRUE) THEN
1401: savepoint Update_Project_Template;

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

2105: COMMIT;
2106: END IF;
2107:
2108: IF (p_debug_mode = 'Y') THEN
2109: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Project_Template END');
2110: END IF;
2111: EXCEPTION
2112: when FND_API.G_EXC_ERROR then
2113: if p_commit = FND_API.G_TRUE then

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

2118: if p_commit = FND_API.G_TRUE then
2119: rollback to Update_Project_Template;
2120: end if;
2121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2122: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2123: p_procedure_name => 'Update_Project_Template',
2124: p_error_text => SUBSTRB(SQLERRM,1,240));
2125: when OTHERS then
2126: if p_commit = FND_API.G_TRUE then

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

2126: if p_commit = FND_API.G_TRUE then
2127: rollback to Update_Project_Template;
2128: end if;
2129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2130: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2131: p_procedure_name => 'Update_Project_Template',
2132: p_error_text => SUBSTRB(SQLERRM,1,240));
2133: raise;
2134: END Update_Project_Template;

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

2173: l_err_stack VARCHAR2(250);
2174:
2175:
2176: BEGIN
2177: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template');
2178:
2179: IF (p_debug_mode = 'Y') THEN
2180: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template begin');
2181: END IF;

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

2176: BEGIN
2177: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template');
2178:
2179: IF (p_debug_mode = 'Y') THEN
2180: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template begin');
2181: END IF;
2182:
2183: IF (p_commit = FND_API.G_TRUE) THEN
2184: savepoint Delete_Project_Template;

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

2214: COMMIT;
2215: END IF;
2216:
2217: IF (p_debug_mode = 'Y') THEN
2218: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Template END');
2219: END IF;
2220: EXCEPTION
2221: when FND_API.G_EXC_ERROR then
2222: if p_commit = FND_API.G_TRUE then

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

2227: if p_commit = FND_API.G_TRUE then
2228: rollback to Delete_Project_Template;
2229: end if;
2230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2231: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2232: p_procedure_name => 'Delete_Project_Template',
2233: p_error_text => SUBSTRB(SQLERRM,1,240));
2234: when OTHERS then
2235: if p_commit = FND_API.G_TRUE then

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

2235: if p_commit = FND_API.G_TRUE then
2236: rollback to Delete_Project_Template;
2237: end if;
2238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2239: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2240: p_procedure_name => 'Delete_Project_Template',
2241: p_error_text => SUBSTRB(SQLERRM,1,240));
2242: raise;
2243: END Delete_Project_Template;

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

2290: FROM pa_project_options
2291: WHERE project_id = p_project_id
2292: AND option_code = p_option_code;
2293: BEGIN
2294: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options');
2295:
2296: IF (p_debug_mode = 'Y') THEN
2297: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options begin');
2298: END IF;

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

2293: BEGIN
2294: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options');
2295:
2296: IF (p_debug_mode = 'Y') THEN
2297: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options begin');
2298: END IF;
2299:
2300: IF (p_commit = FND_API.G_TRUE) THEN
2301: savepoint Add_Project_Options;

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

2347: COMMIT;
2348: END IF;
2349:
2350: IF (p_debug_mode = 'Y') THEN
2351: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Project_Options END');
2352: END IF;
2353: EXCEPTION
2354: when FND_API.G_EXC_ERROR then
2355: if p_commit = FND_API.G_TRUE then

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

2360: if p_commit = FND_API.G_TRUE then
2361: rollback to Add_Project_Options;
2362: end if;
2363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2364: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2365: p_procedure_name => 'Add_Project_Options',
2366: p_error_text => SUBSTRB(SQLERRM,1,240));
2367: when OTHERS then
2368: if p_commit = FND_API.G_TRUE then

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

2368: if p_commit = FND_API.G_TRUE then
2369: rollback to Add_Project_Options;
2370: end if;
2371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2372: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2373: p_procedure_name => 'Add_Project_Options',
2374: p_error_text => SUBSTRB(SQLERRM,1,240));
2375: raise;
2376: END Add_Project_Options;

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

2434:
2435: l_allow_ovr_enabled VARCHAR2(1);
2436: -- End of changes
2437: BEGIN
2438: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options');
2439:
2440: IF (p_debug_mode = 'Y') THEN
2441: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options begin');
2442: END IF;

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

2437: BEGIN
2438: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options');
2439:
2440: IF (p_debug_mode = 'Y') THEN
2441: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options begin');
2442: END IF;
2443:
2444: IF (p_commit = FND_API.G_TRUE) THEN
2445: savepoint Delete_Project_Options;

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

2499: COMMIT;
2500: END IF;
2501:
2502: IF (p_debug_mode = 'Y') THEN
2503: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Project_Options END');
2504: END IF;
2505: EXCEPTION
2506: when FND_API.G_EXC_ERROR then
2507: if p_commit = FND_API.G_TRUE then

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

2512: if p_commit = FND_API.G_TRUE then
2513: rollback to Delete_Project_Options;
2514: end if;
2515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2516: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2517: p_procedure_name => 'Delete_Project_Options',
2518: p_error_text => SUBSTRB(SQLERRM,1,240));
2519: when OTHERS then
2520: if p_commit = FND_API.G_TRUE then

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

2520: if p_commit = FND_API.G_TRUE then
2521: rollback to Delete_Project_Options;
2522: end if;
2523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2524: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2525: p_procedure_name => 'Delete_Project_Options',
2526: p_error_text => SUBSTRB(SQLERRM,1,240));
2527: raise;
2528: END Delete_Project_Options;

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

2599: AND field_name = p_field_name;
2600:
2601:
2602: BEGIN
2603: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field');
2604:
2605: IF (p_debug_mode = 'Y') THEN
2606: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field begin');
2607: END IF;

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

2602: BEGIN
2603: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field');
2604:
2605: IF (p_debug_mode = 'Y') THEN
2606: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field begin');
2607: END IF;
2608:
2609: IF (p_commit = FND_API.G_TRUE) THEN
2610: savepoint Add_Quick_Entry_Field;

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

2799: COMMIT;
2800: END IF;
2801:
2802: IF (p_debug_mode = 'Y') THEN
2803: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Add_Quick_Entry_Field END');
2804: END IF;
2805: EXCEPTION
2806: when FND_API.G_EXC_ERROR then
2807: if p_commit = FND_API.G_TRUE then

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

2812: if p_commit = FND_API.G_TRUE then
2813: rollback to Add_Quick_Entry_Field;
2814: end if;
2815: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2816: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2817: p_procedure_name => 'Add_Quick_Entry_Field',
2818: p_error_text => SUBSTRB(SQLERRM,1,240));
2819: when OTHERS then
2820: if p_commit = FND_API.G_TRUE then

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

2820: if p_commit = FND_API.G_TRUE then
2821: rollback to Add_Quick_Entry_Field;
2822: end if;
2823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2824: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
2825: p_procedure_name => 'Add_Quick_Entry_Field',
2826: p_error_text => SUBSTRB(SQLERRM,1,240));
2827: raise;
2828: END Add_Quick_Entry_Field;

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

2892: WHERE rowid <> p_row_id
2893: AND project_id = p_project_id
2894: AND field_name = p_field_name;
2895: BEGIN
2896: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field');
2897:
2898: IF (p_debug_mode = 'Y') THEN
2899: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field begin');
2900: END IF;

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

2895: BEGIN
2896: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field');
2897:
2898: IF (p_debug_mode = 'Y') THEN
2899: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field begin');
2900: END IF;
2901:
2902: IF (p_commit = FND_API.G_TRUE) THEN
2903: savepoint Update_Quick_Entry_Field;

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

3073: COMMIT;
3074: END IF;
3075:
3076: IF (p_debug_mode = 'Y') THEN
3077: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Update_Quick_Entry_Field END');
3078: END IF;
3079: EXCEPTION
3080: when FND_API.G_EXC_ERROR then
3081: if p_commit = FND_API.G_TRUE then

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

3086: if p_commit = FND_API.G_TRUE then
3087: rollback to Update_Quick_Entry_Field;
3088: end if;
3089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3090: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3091: p_procedure_name => 'Update_Quick_Entry_Field',
3092: p_error_text => SUBSTRB(SQLERRM,1,240));
3093: when OTHERS then
3094: if p_commit = FND_API.G_TRUE then

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

3094: if p_commit = FND_API.G_TRUE then
3095: rollback to Update_Quick_Entry_Field;
3096: end if;
3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3098: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3099: p_procedure_name => 'Update_Quick_Entry_Field',
3100: p_error_text => SUBSTRB(SQLERRM,1,240));
3101: raise;
3102: END Update_Quick_Entry_Field;

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

3153:
3154: l_field_name VARCHAR2(80);
3155:
3156: BEGIN
3157: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field');
3158:
3159: IF (p_debug_mode = 'Y') THEN
3160: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field begin');
3161: END IF;

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

3156: BEGIN
3157: pa_debug.init_err_stack ('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field');
3158:
3159: IF (p_debug_mode = 'Y') THEN
3160: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field begin');
3161: END IF;
3162:
3163: IF (p_commit = FND_API.G_TRUE) THEN
3164: savepoint Delete_Quick_Entry_Field;

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

3195: COMMIT;
3196: END IF;
3197:
3198: IF (p_debug_mode = 'Y') THEN
3199: pa_debug.debug('PA_PROJ_TEMPLATE_SETUP_PVT.Delete_Quick_Entry_Field END');
3200: END IF;
3201: EXCEPTION
3202: when FND_API.G_EXC_ERROR then
3203: if p_commit = FND_API.G_TRUE then

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

3208: if p_commit = FND_API.G_TRUE then
3209: rollback to Delete_Quick_Entry_Field;
3210: end if;
3211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3212: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3213: p_procedure_name => 'Delete_Quick_Entry_Field',
3214: p_error_text => SUBSTRB(SQLERRM,1,240));
3215: when OTHERS then
3216: if p_commit = FND_API.G_TRUE then

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

3216: if p_commit = FND_API.G_TRUE then
3217: rollback to Delete_Quick_Entry_Field;
3218: end if;
3219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3220: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROJ_TEMPLATE_SETUP_PVT',
3221: p_procedure_name => 'Delete_Quick_Entry_Field',
3222: p_error_text => SUBSTRB(SQLERRM,1,240));
3223: raise;
3224: END Delete_Quick_Entry_Field;

Line 3301: END PA_PROJ_TEMPLATE_SETUP_PVT;

3297: END IF; --<< l_insert_flag >>
3298: END LOOP;
3299: END enable_disbale_proj_opt;
3300:
3301: END PA_PROJ_TEMPLATE_SETUP_PVT;