[Home] [Help]
88: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_PROJ_ID',
89: x_err_code => x_err_code,
90: x_err_buff => x_err_stage);
91:
92: APP_EXCEPTION.RAISE_EXCEPTION;
93: END IF;
94:
95: CLOSE l_project_id_csr;
96: p_project_id_out := p_project_id_in;
107: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_PROJ_NUM',
108: x_err_code => x_err_code,
109: x_err_buff => x_err_stage);
110:
111: APP_EXCEPTION.RAISE_EXCEPTION;
112: END IF;
113:
114: CLOSE l_project_number_csr;
115:
117: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJECT_REF_AND_ID_MISSING',
118: x_err_code => x_err_code,
119: x_err_buff => x_err_stage);
120:
121: APP_EXCEPTION.RAISE_EXCEPTION;
122: END IF;
123:
124: x_err_stack := l_old_stack;
125:
133: x_token_val2 => sqlerrm,
134: x_err_code => x_err_code,
135: x_err_buff => x_err_stage);
136:
137: APP_EXCEPTION.RAISE_EXCEPTION;
138:
139: END convert_projnum_to_id;
140: -------------------------------------------------------------------------
141: PROCEDURE convert_tasknum_to_id
188: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_PROJ_TASK_ID',
189: x_err_code => x_err_code,
190: x_err_buff => x_err_stage);
191:
192: APP_EXCEPTION.RAISE_EXCEPTION;
193: END IF;
194:
195: CLOSE l_task_id_csr;
196: p_task_id_out := p_task_id_in;
207: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_PROJ_TASK_NUM',
208: x_err_code => x_err_code,
209: x_err_buff => x_err_stage);
210:
211: APP_EXCEPTION.RAISE_EXCEPTION;
212: END IF;
213:
214: CLOSE l_task_number_csr;
215:
217: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_NUM_AND_ID_MISSING',
218: x_err_code => x_err_code,
219: x_err_buff => x_err_stage);
220:
221: APP_EXCEPTION.RAISE_EXCEPTION;
222: END IF;
223:
224: x_err_stack := l_old_stack;
225:
233: x_token_val2 => sqlerrm,
234: x_err_code => x_err_code,
235: x_err_buff => x_err_stage);
236:
237: APP_EXCEPTION.RAISE_EXCEPTION;
238:
239:
240: END convert_tasknum_to_id;
241:
286: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_AWARD_ID',
287: x_err_code => x_err_code,
288: x_err_buff => x_err_stage);
289:
290: APP_EXCEPTION.RAISE_EXCEPTION;
291: END IF;
292:
293: CLOSE l_award_id_csr;
294: p_award_id_out := p_award_id_in;
305: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_AWARD_NUM',
306: x_err_code => x_err_code,
307: x_err_buff => x_err_stage);
308:
309: APP_EXCEPTION.RAISE_EXCEPTION;
310: END IF;
311:
312: CLOSE l_award_number_csr;
313:
315: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_AND_ID_MISSING',
316: x_err_code => x_err_code,
317: x_err_buff => x_err_stage);
318:
319: APP_EXCEPTION.RAISE_EXCEPTION;
320: END IF;
321:
322: x_err_stack := l_old_stack;
323:
331: x_token_val2 => sqlerrm,
332: x_err_code => x_err_code,
333: x_err_buff => x_err_stage);
334:
335: APP_EXCEPTION.RAISE_EXCEPTION;
336:
337: END convert_awardnum_to_id;
338: ----------------------------------------------------------------------
339: PROCEDURE convert_reslistname_to_id
382: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_RESLIST_ID',
383: x_err_code => x_err_code,
384: x_err_buff => x_err_stage);
385:
386: APP_EXCEPTION.RAISE_EXCEPTION;
387: END IF;
388:
389: CLOSE l_resource_list_id_csr;
390: p_resource_list_id_out := p_resource_list_id_in;
401: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_RESLIST_NAME',
402: x_err_code => x_err_code,
403: x_err_buff => x_err_stage);
404:
405: APP_EXCEPTION.RAISE_EXCEPTION;
406: END IF;
407:
408: CLOSE l_resource_list_name_csr;
409:
411: gms_error_pkg.gms_message(x_err_name => 'GMS_RESNAME_AND_ID_MISSING',
412: x_err_code => x_err_code,
413: x_err_buff => x_err_stage);
414:
415: APP_EXCEPTION.RAISE_EXCEPTION;
416: END IF;
417:
418: x_err_stack := l_old_stack;
419:
427: x_token_val2 => sqlerrm,
428: x_err_code => x_err_code,
429: x_err_buff => x_err_stage);
430:
431: APP_EXCEPTION.RAISE_EXCEPTION;
432:
433: END convert_reslistname_to_id;
434: -------------------------------------------------------------------------------
435:
482: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_RESLIST_MEM_ID',
483: x_err_code => x_err_code,
484: x_err_buff => x_err_stage);
485:
486: APP_EXCEPTION.RAISE_EXCEPTION;
487: END IF;
488:
489: CLOSE l_resource_list_member_id_csr;
490: p_resource_list_member_id_out := p_resource_list_member_id_in;
501: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_RESLIST_ALIAS',
502: x_err_code => x_err_code,
503: x_err_buff => x_err_stage);
504:
505: APP_EXCEPTION.RAISE_EXCEPTION;
506: END IF;
507:
508: CLOSE l_reslist_member_alias_csr;
509:
511: gms_error_pkg.gms_message(x_err_name => 'GMS_RES_ALIAS_AND_ID_MISSING',
512: x_err_code => x_err_code,
513: x_err_buff => x_err_stage);
514:
515: APP_EXCEPTION.RAISE_EXCEPTION;
516: END IF;
517:
518: x_err_stack := l_old_stack;
519:
527: x_token_val2 => sqlerrm,
528: x_err_code => x_err_code,
529: x_err_buff => x_err_stage);
530:
531: APP_EXCEPTION.RAISE_EXCEPTION;
532:
533: END convert_listmem_alias_to_id;
534: ------------------------------------------------------------------------------------------
535:
1034: x_err_code => x_err_code,
1035: x_err_buff => x_err_stage);
1036:
1037: x_return_status := 1; -- validation FAILED
1038: app_exception.raise_exception;
1039:
1040: end if;
1041:
1042: -- Initializing the pl/sql tables
1281: end if;
1282: end if;
1283:
1284: x_return_status := 1; -- validation FAILED
1285: app_exception.raise_exception;
1286: end if;
1287:
1288: end loop;
1289:
1384: x_err_code => x_err_code,
1385: x_err_buff => x_err_stage);
1386:
1387: x_return_status := 1; -- validation failed
1388: app_exception.raise_exception;
1389: end if;
1390:
1391: END LOOP;
1392: END LOOP;
1498: gms_error_pkg.gms_message(x_err_name => 'GMS_CANT_CHANGE_BEM',
1499: x_err_code => x_err_code,
1500: x_err_buff => x_err_stage);
1501:
1502: APP_EXCEPTION.RAISE_EXCEPTION;
1503: */
1504: end if;
1505:
1506: ----------------------------------------------------------------------------
1545: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_BEM_RESOURCE_LIST',
1546: x_err_code => x_err_code,
1547: x_err_buff => x_err_stage);
1548:
1549: APP_EXCEPTION.RAISE_EXCEPTION;
1550:
1551: end if;
1552:
1553: end validate_bem_resource_list;
1746: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
1747: x_err_code => x_err_code,
1748: x_err_buff => x_err_stage);
1749:
1750: APP_EXCEPTION.RAISE_EXCEPTION;
1751:
1752: END IF;
1753:
1754:
1760: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
1761: x_err_code => x_err_code,
1762: x_err_buff => x_err_stage);
1763:
1764: APP_EXCEPTION.RAISE_EXCEPTION;
1765:
1766: END IF;
1767:
1768: ----------------------------------------------------------------------------
1792: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
1793: x_err_code => x_err_code,
1794: x_err_buff => x_err_stage);
1795:
1796: APP_EXCEPTION.RAISE_EXCEPTION;
1797:
1798: END IF;
1799: --------------------------------------------------------------------------------
1800:
1845: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
1846: x_err_code => x_err_code,
1847: x_err_buff => x_err_stage);
1848:
1849: APP_EXCEPTION.RAISE_EXCEPTION;
1850: END IF;
1851: -------------------------------------------------------------------------------
1852:
1853: -- Now verify whether award security allows the user to update
1865: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
1866: x_err_code => x_err_code,
1867: x_err_buff => x_err_stage);
1868:
1869: APP_EXCEPTION.RAISE_EXCEPTION;
1870:
1871: ELSE
1872: -- If the user has query privileges, then check whether
1873: -- update privileges are also available
1879: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
1880: x_err_code => x_err_code,
1881: x_err_buff => x_err_stage);
1882:
1883: APP_EXCEPTION.RAISE_EXCEPTION;
1884:
1885: END IF;
1886: END IF;
1887:
1895: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
1896: x_err_code => x_err_code,
1897: x_err_buff => x_err_stage);
1898:
1899: APP_EXCEPTION.RAISE_EXCEPTION;
1900:
1901: ELSE
1902: OPEN l_budget_amount_code_csr( p_budget_type_code );
1903:
1910: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
1911: x_err_code => x_err_code,
1912: x_err_buff => x_err_stage);
1913:
1914: APP_EXCEPTION.RAISE_EXCEPTION;
1915: END IF;
1916:
1917: CLOSE l_budget_amount_code_csr;
1918:
1926: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_MISSING',
1927: x_err_code => x_err_code,
1928: x_err_buff => x_err_stage);
1929:
1930: APP_EXCEPTION.RAISE_EXCEPTION;
1931: END IF;
1932:
1933: -- check validity of this budget entry method code, and store associated fields in record
1934:
1943: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_INVALID',
1944: x_err_code => x_err_code,
1945: x_err_buff => x_err_stage);
1946:
1947: APP_EXCEPTION.RAISE_EXCEPTION;
1948:
1949: END IF;
1950:
1951: CLOSE l_budget_entry_method_csr;
1964: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_UNCATEGORIZED_LIST',
1965: x_err_code => x_err_code,
1966: x_err_buff => x_err_stage);
1967:
1968: APP_EXCEPTION.RAISE_EXCEPTION;
1969: END IF;
1970:
1971: l_resource_list_id := l_uncategorized_list_id;
1972:
1994: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_RESOURCE_LIST_NAME',
1995: x_err_code => x_err_code,
1996: x_err_buff => x_err_stage);
1997:
1998: APP_EXCEPTION.RAISE_EXCEPTION;
1999: END IF;
2000:
2001: ELSE
2002: gms_error_pkg.gms_message(x_err_name => 'GMS_RESLIST_ID_NAME_MISSING',
2002: gms_error_pkg.gms_message(x_err_name => 'GMS_RESLIST_ID_NAME_MISSING',
2003: x_err_code => x_err_code,
2004: x_err_buff => x_err_stage);
2005:
2006: APP_EXCEPTION.RAISE_EXCEPTION;
2007: END IF;
2008: ------------------------------------------------------------------------------
2009: /*
2010: IF (p_resource_list_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
2051: gms_error_pkg.gms_message(x_err_name => 'GMS_CHANGE_REASON_INVALID',
2052: x_err_code => x_err_code,
2053: x_err_buff => x_err_stage);
2054:
2055: APP_EXCEPTION.RAISE_EXCEPTION;
2056:
2057: END IF;
2058:
2059: CLOSE l_budget_change_reason_csr;
2189: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_IS_SUBMITTED',
2190: x_err_code => x_err_code,
2191: x_err_buff => x_err_stage);
2192:
2193: APP_EXCEPTION.RAISE_EXCEPTION;
2194: END IF;
2195:
2196: IF p_pm_budget_reference = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2197: THEN
2220: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_PERIOD_IS_INVALID',
2221: x_err_code => x_err_code,
2222: x_err_buff => x_err_stage);
2223:
2224: APP_EXCEPTION.RAISE_EXCEPTION;
2225: END IF;
2226: CLOSE l_budget_periods_csr;
2227: END IF;
2228:
2261: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_BASE_RES_LIST_EXISTS',
2262: x_err_code => x_err_code,
2263: x_err_buff => x_err_stage);
2264:
2265: APP_EXCEPTION.RAISE_EXCEPTION;
2266: end if;
2267:
2268: l_baselined_exists := TRUE;
2269:
2299: gms_error_pkg.gms_message(x_err_name => 'GMS_DELETE_DRAFT_FAIL',
2300: x_err_code => x_err_code,
2301: x_err_buff => x_err_stage);
2302:
2303: APP_EXCEPTION.RAISE_EXCEPTION;
2304: end if;
2305:
2306: elsif (x_err_code > 0) then
2307: -- reset x_err_code
2823: x_err_buff => x_err_stage);
2824: fnd_msg_pub.add; -- Bug 2587078
2825:
2826:
2827: APP_EXCEPTION.RAISE_EXCEPTION;
2828:
2829: END IF;
2830:
2831: --product_code is mandatory
2837: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
2838: x_err_code => x_err_code,
2839: x_err_buff => x_err_stage);
2840: fnd_msg_pub.add; -- Bug 2587078
2841: APP_EXCEPTION.RAISE_EXCEPTION;
2842:
2843: END IF;
2844:
2845: ----------------------------------------------------------------------------
2876: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
2877: x_err_code => x_err_code,
2878: x_err_buff => x_err_stage);
2879: fnd_msg_pub.add; -- Bug 2587078
2880: APP_EXCEPTION.RAISE_EXCEPTION;
2881: END IF;
2882: --------------------------------------------------------------------------------
2883: -- getting the award number to be used in Error Messages...
2884:
2949: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJECT_IS_MISSING', -- 'GMS_PROJ_NUM_ID_MISSING', Bug 2587078
2950: x_err_code => x_err_code,
2951: x_err_buff => x_err_stage);
2952: fnd_msg_pub.add; -- Bug 2587078
2953: APP_EXCEPTION.RAISE_EXCEPTION;
2954:
2955: END IF;
2956:
2957: -------------------------------------------------------------------------------
2968: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_REF_AND_ID_MISSING', --'GMS_INVALID_PROJ_NUMBER', bug 2587078
2969: x_err_code => x_err_code,
2970: x_err_buff => x_err_stage);
2971: fnd_msg_pub.add; -- Bug 2587078
2972: APP_EXCEPTION.RAISE_EXCEPTION;
2973: END IF;
2974:
2975: -- budget type code is mandatory
2976:
2981: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
2982: x_err_code => x_err_code,
2983: x_err_buff => x_err_stage);
2984: fnd_msg_pub.add; -- Bug 2587078
2985: APP_EXCEPTION.RAISE_EXCEPTION;
2986:
2987: ELSE
2988: OPEN l_budget_types_csr( p_budget_type_code );
2989:
2998: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
2999: x_err_code => x_err_code,
3000: x_err_buff => x_err_stage);
3001: fnd_msg_pub.add; -- Bug 2587078
3002: APP_EXCEPTION.RAISE_EXCEPTION;
3003:
3004: END IF;
3005:
3006: CLOSE l_budget_types_csr;
3055: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
3056: x_err_code => x_err_code,
3057: x_err_buff => x_err_stage);
3058: fnd_msg_pub.add; -- Bug 2587078
3059: APP_EXCEPTION.RAISE_EXCEPTION;
3060: END IF;
3061:
3062: CLOSE l_budget_versions_csr;
3063:
3076: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_LINES',
3077: x_err_code => x_err_code,
3078: x_err_buff => x_err_stage);
3079: fnd_msg_pub.add; -- Bug 2587078
3080: APP_EXCEPTION.RAISE_EXCEPTION;
3081: END IF;
3082:
3083: CLOSE l_resource_assignments_csr;
3084:
3093: gms_error_pkg.gms_message(x_err_name => 'GMS_TIME_PHASED_TYPE_CODE_MISS',
3094: x_err_code => x_err_code,
3095: x_err_buff => x_err_stage);
3096: fnd_msg_pub.add; -- Bug 2587078
3097: APP_EXCEPTION.RAISE_EXCEPTION;
3098: END IF;
3099:
3100: -- Dummy call !
3101:
3114: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_FAILED',
3115: x_err_code => x_err_code,
3116: x_err_buff => x_err_stage);
3117: fnd_msg_pub.add; -- Bug 2587078
3118: APP_EXCEPTION.RAISE_EXCEPTION;
3119: END IF;
3120:
3121: -- ------------------------------------------------------------------------------------
3122: -- Added SUBMISSION/BASELINE RULES and WORFLOW
3139: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_RULES_ATTR',
3140: x_err_code => x_err_code,
3141: x_err_buff => x_err_stage);
3142: fnd_msg_pub.add; -- Bug 2587078
3143: APP_EXCEPTION.RAISE_EXCEPTION;
3144:
3145: END IF;
3146:
3147: CLOSE l_budget_rules_csr;
3237: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_BUDGET_FAIL_S',
3238: x_err_code => x_err_code,
3239: x_err_buff => x_err_stage);
3240: fnd_msg_pub.add; -- Bug 25870708
3241: APP_EXCEPTION.RAISE_EXCEPTION;
3242: END IF;
3243: END IF;
3244:
3245:
3289: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_BUDGET_FAIL_B',
3290: x_err_code => x_err_code,
3291: x_err_buff => x_err_stage);
3292: fnd_msg_pub.add; -- Bug 2587078
3293: APP_EXCEPTION.RAISE_EXCEPTION;
3294:
3295: END IF;
3296: END IF;
3297:
3318: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDG_WF_CHECK_FAIL',
3319: x_err_code => x_err_code,
3320: x_err_buff => x_err_stage);
3321: fnd_msg_pub.add; -- Bug 2587078
3322: APP_EXCEPTION.RAISE_EXCEPTION;
3323: END IF;
3324:
3325: IF L_DEBUG = 'Y' THEN
3326: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - l_workflow_is_used : '||l_workflow_is_used, 'C');
3359: gms_error_pkg.gms_message(x_err_name => 'GMS_START_BUDG_WF_FAIL',
3360: x_err_code => x_err_code,
3361: x_err_buff => x_err_stage);
3362: fnd_msg_pub.add; -- Bug 2587078
3363: APP_EXCEPTION.RAISE_EXCEPTION;
3364: END IF;
3365:
3366: p_workflow_started := 'Y';
3367:
3495: gms_error_pkg.gms_message(x_err_name => 'GMS_BASELINE_FAILED',
3496: x_err_code => x_err_code,
3497: x_err_buff => x_err_stage);
3498: fnd_msg_pub.add; -- Bug 2587078
3499: APP_EXCEPTION.RAISE_EXCEPTION;
3500: END IF;
3501:
3502: -- Bug 5162777 : Derive the the budget_version_id of the previously baselined budget before creating new BC records.
3503: ----------- DERIVING THE BUDGET_VERSION_ID OF THE PREVIOUSLY BASELINED BUDGET -----------------
3549: x_err_code => x_err_code,
3550: x_err_buff => x_err_stage);
3551:
3552: fnd_msg_pub.add;
3553: APP_EXCEPTION.RAISE_EXCEPTION;
3554: end;
3555: -- Bug 2386041
3556:
3557: ---------------------------------------------------------------------------------------------------------
3577: x_err_buff => x_err_stage);
3578:
3579: SAVEPOINT baseline_budget_pub;
3580: fnd_msg_pub.add; -- Bug 2587078
3581: APP_EXCEPTION.RAISE_EXCEPTION;
3582: -- Bug 2386041
3583: end if;
3584: ----------------------- END OF BC RECORD CREATION -------------------------
3585:
3689: x_err_code => x_err_code,
3690: x_err_buff => x_err_stage);
3691:
3692: fnd_msg_pub.add;
3693: APP_EXCEPTION.RAISE_EXCEPTION;
3694: end;
3695:
3696: -- Bug 2587078 :The Project budget summarization code is shifted after call to sweeper process .
3697:
3764:
3765: commit;
3766: SAVEPOINT baseline_budget_pub;
3767: fnd_msg_pub.add; -- Bug 2587078
3768: APP_EXCEPTION.RAISE_EXCEPTION;
3769: -- Bug 2386041
3770: end if;
3771:
3772: end if; -- l_packet_id not null. Bug 2821482
3895:
3896: commit;
3897: SAVEPOINT baseline_budget_pub;
3898: fnd_msg_pub.add; -- Bug 2587078
3899: APP_EXCEPTION.RAISE_EXCEPTION;
3900: -- Bug 2386041
3901:
3902: END IF;
3903:
3943: gms_error_pkg.gms_output(x_output => x_err_stage);
3944: return;
3945:
3946: -- We don't have to stop the baseline process if the WF Notification process fails.
3947: -- APP_EXCEPTION.RAISE_EXCEPTION;
3948: end if;
3949:
3950: end if;
3951:
4274: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
4275: x_err_code => x_err_code,
4276: x_err_buff => x_err_stage);
4277:
4278: APP_EXCEPTION.RAISE_EXCEPTION;
4279:
4280: END IF;
4281:
4282: l_resp_id := FND_GLOBAL.Resp_id;
4304: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_MISSING',
4305: x_err_code => x_err_code,
4306: x_err_buff => x_err_stage);
4307:
4308: APP_EXCEPTION.RAISE_EXCEPTION;
4309: END IF;
4310: ----------------------------------------------------------------------------
4311: -- If award_id is passed in then use it otherwise use the award_number
4312: -- that is passed in to fetch value of award_id from gms_awards table
4332: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
4333: x_err_code => x_err_code,
4334: x_err_buff => x_err_stage);
4335:
4336: APP_EXCEPTION.RAISE_EXCEPTION;
4337: END IF;
4338: --------------------------------------------------------------------------------
4339: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after award info validation');
4340:
4363: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
4364: x_err_code => x_err_code,
4365: x_err_buff => x_err_stage);
4366:
4367: APP_EXCEPTION.RAISE_EXCEPTION;
4368: END IF;
4369:
4370: -------------------------------------------------------------------------------
4371: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after project info validation');
4375: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJECT_IS_MISSING',
4376: x_err_code => x_err_code,
4377: x_err_buff => x_err_stage);
4378:
4379: APP_EXCEPTION.RAISE_EXCEPTION;
4380: END IF;
4381:
4382: -- Now verify whether award security allows the user to update
4383: -- the award
4392: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
4393: x_err_code => x_err_code,
4394: x_err_buff => x_err_stage);
4395:
4396: APP_EXCEPTION.RAISE_EXCEPTION;
4397:
4398: ELSE
4399: -- If the user has query privileges, then check whether
4400: -- update privileges are also available
4405: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
4406: x_err_code => x_err_code,
4407: x_err_buff => x_err_stage);
4408:
4409: APP_EXCEPTION.RAISE_EXCEPTION;
4410: END IF;
4411: END IF;
4412:
4413: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after award security validation');
4419: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
4420: x_err_code => x_err_code,
4421: x_err_buff => x_err_stage);
4422:
4423: APP_EXCEPTION.RAISE_EXCEPTION;
4424: ELSE
4425: OPEN l_budget_amount_code_csr( p_budget_type_code );
4426:
4427: FETCH l_budget_amount_code_csr
4433: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
4434: x_err_code => x_err_code,
4435: x_err_buff => x_err_stage);
4436:
4437: APP_EXCEPTION.RAISE_EXCEPTION;
4438: END IF;
4439:
4440: CLOSE l_budget_amount_code_csr;
4441:
4457: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
4458: x_err_code => x_err_code,
4459: x_err_buff => x_err_stage);
4460:
4461: APP_EXCEPTION.RAISE_EXCEPTION;
4462: END IF;
4463:
4464: CLOSE l_budget_version_csr;
4465:
4472: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_MISSING',
4473: x_err_code => x_err_code,
4474: x_err_buff => x_err_stage);
4475:
4476: APP_EXCEPTION.RAISE_EXCEPTION;
4477: END IF;
4478:
4479: -- check validity of this budget entry method code, and store associated fields in record
4480:
4487: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_INVALID',
4488: x_err_code => x_err_code,
4489: x_err_buff => x_err_stage);
4490:
4491: APP_EXCEPTION.RAISE_EXCEPTION;
4492: END IF;
4493:
4494: CLOSE l_budget_entry_method_csr;
4495:
4525: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_TASK_NUMBER',
4526: x_err_code => x_err_code,
4527: x_err_buff => x_err_stage);
4528:
4529: APP_EXCEPTION.RAISE_EXCEPTION;
4530: END IF;
4531:
4532: END IF;
4533:
4537: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_IS_NOT_TOP',
4538: x_err_code => x_err_code,
4539: x_err_buff => x_err_stage);
4540:
4541: APP_EXCEPTION.RAISE_EXCEPTION;
4542: END IF;
4543:
4544: ELSIF l_budget_entry_method_rec.entry_level_code = 'L' -- then check whether it is lowest task
4545: THEN
4549: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_IS_NOT_LOWEST',
4550: x_err_code => x_err_code,
4551: x_err_buff => x_err_stage);
4552:
4553: APP_EXCEPTION.RAISE_EXCEPTION;
4554: END IF;
4555:
4556: ELSIF l_budget_entry_method_rec.entry_level_code = 'M' -- then check whether it is a top or
4557: -- lowest level tasks
4563: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_IS_NOT_TOP_OR_LOWEST',
4564: x_err_code => x_err_code,
4565: x_err_buff => x_err_stage);
4566:
4567: APP_EXCEPTION.RAISE_EXCEPTION;
4568: END IF;
4569: END IF;
4570:
4571: END IF; -- If l_budget_entry_method_rec.entry_level_code = 'T'
4590: gms_error_pkg.gms_message(x_err_name => 'GMS_GET_PERIOD_DATE_FAIL',
4591: x_err_code => x_err_code,
4592: x_err_buff => x_err_stage);
4593:
4594: APP_EXCEPTION.RAISE_EXCEPTION;
4595: END IF;
4596:
4597: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after gms_budget_utils.get_valid_period_dates');
4598:
4612: gms_error_pkg.gms_message(x_err_name => 'GMS_CHK_ENTRYMETHOD_FAIL',
4613: x_err_code => x_err_code,
4614: x_err_buff => x_err_stage);
4615:
4616: APP_EXCEPTION.RAISE_EXCEPTION;
4617: END IF;
4618:
4619: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after gms_budget_utils.check_entry_method_flags');
4620:
4676: gms_error_pkg.gms_message(x_err_name => 'GMS_RESOURCE_MISSING',
4677: x_err_code => x_err_code,
4678: x_err_buff => x_err_stage);
4679:
4680: APP_EXCEPTION.RAISE_EXCEPTION;
4681: END IF;
4682:
4683:
4684: --When budget line description is not passed, set value to NULL
4904: x_token_val2 => sqlerrm,
4905: x_err_code => x_err_code,
4906: x_err_buff => x_err_stage);
4907:
4908: APP_EXCEPTION.RAISE_EXCEPTION;
4909: end ;
4910:
4911: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after insert into gms_resource_assignments');
4912:
5030: gms_error_pkg.gms_message(x_err_name => 'GMS_CHECK_DATES_FAILED',
5031: x_err_code => x_err_code,
5032: x_err_buff => x_err_stage);
5033:
5034: APP_EXCEPTION.RAISE_EXCEPTION;
5035: END IF;
5036:
5037: end if; -- Time Phased type code
5038:
5054: gms_error_pkg.gms_message(x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',
5055: x_err_code => x_err_code,
5056: x_err_buff => x_err_stage);
5057:
5058: APP_EXCEPTION.RAISE_EXCEPTION;
5059: END IF;
5060:
5061: ------------------------------------------------------------------------------------
5062: -- Added for Bug:1325015
5213: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
5214: x_err_code => x_err_code,
5215: x_err_buff => x_err_stage);
5216:
5217: APP_EXCEPTION.RAISE_EXCEPTION;
5218: END IF;
5219:
5220: -- product_code is mandatory
5221:
5225: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
5226: x_err_code => x_err_code,
5227: x_err_buff => x_err_stage);
5228:
5229: APP_EXCEPTION.RAISE_EXCEPTION;
5230: END IF;
5231:
5232: ----------------------------------------------------------------------------
5233: -- If award_id is passed in then use it otherwise use the award_number
5255: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
5256: x_err_code => x_err_code,
5257: x_err_buff => x_err_stage);
5258:
5259: APP_EXCEPTION.RAISE_EXCEPTION;
5260: END IF;
5261: --------------------------------------------------------------------------------
5262:
5263: l_resp_id := FND_GLOBAL.Resp_id;
5305: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
5306: x_err_code => x_err_code,
5307: x_err_buff => x_err_stage);
5308:
5309: APP_EXCEPTION.RAISE_EXCEPTION;
5310: END IF;
5311: -------------------------------------------------------------------------------
5312:
5313: -- Now verify whether award security allows the user to update
5323: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
5324: x_err_code => x_err_code,
5325: x_err_buff => x_err_stage);
5326:
5327: APP_EXCEPTION.RAISE_EXCEPTION;
5328:
5329: ELSE
5330: -- If the user has query privileges, then check whether
5331: -- update privileges are also available
5336: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
5337: x_err_code => x_err_code,
5338: x_err_buff => x_err_stage);
5339:
5340: APP_EXCEPTION.RAISE_EXCEPTION;
5341:
5342: END IF;
5343: END IF;
5344:
5351: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
5352: x_err_code => x_err_code,
5353: x_err_buff => x_err_stage);
5354:
5355: APP_EXCEPTION.RAISE_EXCEPTION;
5356:
5357: ELSE
5358: OPEN l_budget_type_csr( p_budget_type_code );
5359:
5365: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
5366: x_err_code => x_err_code,
5367: x_err_buff => x_err_stage);
5368:
5369: APP_EXCEPTION.RAISE_EXCEPTION;
5370: END IF;
5371:
5372: CLOSE l_budget_type_csr;
5373:
5391: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
5392: x_err_code => x_err_code,
5393: x_err_buff => x_err_stage);
5394:
5395: APP_EXCEPTION.RAISE_EXCEPTION;
5396:
5397: END IF;
5398:
5399: CLOSE l_budget_version_csr;
5442: gms_error_pkg.gms_message(x_err_name => 'GMS_DELETE_BUDGET_LINE_FAIL',
5443: x_err_code => x_err_code,
5444: x_err_buff => x_err_stage);
5445:
5446: APP_EXCEPTION.RAISE_EXCEPTION;
5447: end if;
5448:
5449: end loop;
5450:
5457: gms_error_pkg.gms_message(x_err_name => 'GMS_DELETE_DRAFT_FAIL',
5458: x_err_code => x_err_code,
5459: x_err_buff => x_err_stage);
5460:
5461: APP_EXCEPTION.RAISE_EXCEPTION;
5462: end;
5463:
5464: --!!! temporary solution, because delete_draft has commit
5465:
5672: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
5673: x_err_code => x_err_code,
5674: x_err_buff => x_err_stage);
5675:
5676: APP_EXCEPTION.RAISE_EXCEPTION;
5677: END IF;
5678:
5679: -- product_code is mandatory
5680:
5684: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
5685: x_err_code => x_err_code,
5686: x_err_buff => x_err_stage);
5687:
5688: APP_EXCEPTION.RAISE_EXCEPTION;
5689: END IF;
5690:
5691: ----------------------------------------------------------------------------
5692: -- If award_id is passed in then use it otherwise use the award_number
5713: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
5714: x_err_code => x_err_code,
5715: x_err_buff => x_err_stage);
5716:
5717: APP_EXCEPTION.RAISE_EXCEPTION;
5718: END IF;
5719: --------------------------------------------------------------------------------
5720:
5721: l_resp_id := FND_GLOBAL.Resp_id;
5759: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
5760: x_err_code => x_err_code,
5761: x_err_buff => x_err_stage);
5762:
5763: APP_EXCEPTION.RAISE_EXCEPTION;
5764: END IF;
5765: -------------------------------------------------------------------------------
5766:
5767: -- Now verify whether award security allows the user to update
5776: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
5777: x_err_code => x_err_code,
5778: x_err_buff => x_err_stage);
5779:
5780: APP_EXCEPTION.RAISE_EXCEPTION;
5781:
5782: ELSE
5783: -- If the user has query privileges, then check whether
5784: -- update privileges are also available
5790: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
5791: x_err_code => x_err_code,
5792: x_err_buff => x_err_stage);
5793:
5794: APP_EXCEPTION.RAISE_EXCEPTION;
5795:
5796: END IF;
5797: END IF;
5798:
5805: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
5806: x_err_code => x_err_code,
5807: x_err_buff => x_err_stage);
5808:
5809: APP_EXCEPTION.RAISE_EXCEPTION;
5810: ELSE
5811: OPEN l_budget_type_csr( p_budget_type_code );
5812:
5813: FETCH l_budget_type_csr INTO l_dummy;
5841: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
5842: x_err_code => x_err_code,
5843: x_err_buff => x_err_stage);
5844:
5845: APP_EXCEPTION.RAISE_EXCEPTION;
5846: END IF;
5847:
5848: CLOSE l_budget_version_csr;
5849:
5873: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_VALIDATE_FAIL', -- jjj - check message tag
5874: x_err_code => x_err_code,
5875: x_err_buff => x_err_stage);
5876:
5877: APP_EXCEPTION.RAISE_EXCEPTION;
5878:
5879: END IF;
5880: END IF;
5881:
5907: gms_error_pkg.gms_message(x_err_name => 'GMS_RES_VALIDATE_FAIL',
5908: x_err_code => x_err_code,
5909: x_err_buff => x_err_stage);
5910:
5911: APP_EXCEPTION.RAISE_EXCEPTION;
5912: END IF;
5913:
5914: ELSE
5915:
5933: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_RESOURCE_ASSIGNMENT',
5934: x_err_code => x_err_code,
5935: x_err_buff => x_err_stage);
5936:
5937: APP_EXCEPTION.RAISE_EXCEPTION;
5938: END IF;
5939:
5940: CLOSE l_resource_assignment_csr;
5941:
5960: gms_error_pkg.gms_message(x_err_name => 'GMS_PERIOD_NAME_INVALID',
5961: x_err_code => x_err_code,
5962: x_err_buff => x_err_stage);
5963:
5964: APP_EXCEPTION.RAISE_EXCEPTION;
5965: END IF;
5966: CLOSE l_budget_periods_csr;
5967:
5968: ELSIF p_start_date IS NOT NULL
5985: gms_error_pkg.gms_message(x_err_name => 'GMS_START_DATE_INVALID',
5986: x_err_code => x_err_code,
5987: x_err_buff => x_err_stage);
5988:
5989: APP_EXCEPTION.RAISE_EXCEPTION;
5990: END IF;
5991:
5992: CLOSE l_start_date_csr;
5993:
6011: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_LINE_NOT_FOUND',
6012: x_err_code => x_err_code,
6013: x_err_buff => x_err_stage);
6014:
6015: APP_EXCEPTION.RAISE_EXCEPTION;
6016: END IF;
6017:
6018:
6019: WHILE l_budget_line_rowid_csr%FOUND LOOP
6099: x_token_val2 => sqlerrm,
6100: x_err_code => x_err_code,
6101: x_err_buff => x_err_stage);
6102:
6103: APP_EXCEPTION.RAISE_EXCEPTION;
6104:
6105: END;
6106:
6107: FETCH l_budget_line_rowid_csr INTO l_budget_line_rowid;
6124: gms_error_pkg.gms_message(x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',
6125: x_err_code => x_err_code,
6126: x_err_buff => x_err_stage);
6127:
6128: APP_EXCEPTION.RAISE_EXCEPTION;
6129: END IF;
6130:
6131: ------------------------------------------------------------------------------------
6132: -- Added for Bug:1325015
6448: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
6449: x_err_code => x_err_code,
6450: x_err_buff => x_err_stage);
6451:
6452: APP_EXCEPTION.RAISE_EXCEPTION;
6453: END IF;
6454:
6455: --product_code is mandatory
6456:
6460: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
6461: x_err_code => x_err_code,
6462: x_err_buff => x_err_stage);
6463:
6464: APP_EXCEPTION.RAISE_EXCEPTION;
6465: END IF;
6466:
6467: ----------------------------------------------------------------------------
6468: -- If award_id is passed in then use it otherwise use the award_number
6489: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
6490: x_err_code => x_err_code,
6491: x_err_buff => x_err_stage);
6492:
6493: APP_EXCEPTION.RAISE_EXCEPTION;
6494: END IF;
6495: --------------------------------------------------------------------------------
6496: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - after award info validation');
6497:
6542: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
6543: x_err_code => x_err_code,
6544: x_err_buff => x_err_stage);
6545:
6546: APP_EXCEPTION.RAISE_EXCEPTION;
6547: END IF;
6548: -------------------------------------------------------------------------------
6549: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - after project info validation');
6550:
6560: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
6561: x_err_code => x_err_code,
6562: x_err_buff => x_err_stage);
6563:
6564: APP_EXCEPTION.RAISE_EXCEPTION;
6565:
6566: ELSE
6567: -- If the user has query privileges, then check whether
6568: -- update privileges are also available
6575: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
6576: x_err_code => x_err_code,
6577: x_err_buff => x_err_stage);
6578:
6579: APP_EXCEPTION.RAISE_EXCEPTION;
6580: END IF;
6581: END IF;
6582:
6583:
6589: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_MISSING',
6590: x_err_code => x_err_code,
6591: x_err_buff => x_err_stage);
6592:
6593: APP_EXCEPTION.RAISE_EXCEPTION;
6594:
6595: ELSE
6596: OPEN l_budget_type_csr( p_budget_type_code );
6597:
6604: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
6605: x_err_code => x_err_code,
6606: x_err_buff => x_err_stage);
6607:
6608: APP_EXCEPTION.RAISE_EXCEPTION;
6609:
6610: END IF;
6611:
6612: CLOSE l_budget_type_csr;
6630: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
6631: x_err_code => x_err_code,
6632: x_err_buff => x_err_stage);
6633:
6634: APP_EXCEPTION.RAISE_EXCEPTION;
6635: END IF;
6636:
6637: CLOSE l_budget_version_csr;
6638:
6661: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_CHANGE_REASON',
6662: x_err_code => x_err_code,
6663: x_err_buff => x_err_stage);
6664:
6665: APP_EXCEPTION.RAISE_EXCEPTION;
6666: END IF;
6667:
6668: CLOSE l_budget_change_reason_csr;
6669: END IF;
6696: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_PERIOD_IS_INVALID',
6697: x_err_code => x_err_code,
6698: x_err_buff => x_err_stage);
6699:
6700: APP_EXCEPTION.RAISE_EXCEPTION;
6701: END IF;
6702: CLOSE l_budget_periods_csr;
6703: END IF;
6704:
6824: gms_error_pkg.gms_message(x_err_name => 'GMS_CHECK_DATES_FAILED',
6825: x_err_code => x_err_code,
6826: x_err_buff => x_err_stage);
6827:
6828: APP_EXCEPTION.RAISE_EXCEPTION;
6829: END IF;
6830:
6831: end if; -- l_time_phased_type_code
6832:
6844: gms_error_pkg.gms_message(x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',
6845: x_err_code => x_err_code,
6846: x_err_buff => x_err_stage);
6847:
6848: APP_EXCEPTION.RAISE_EXCEPTION;
6849: END IF;
6850:
6851:
6852: -- END IF; --if there are budget lines
7134: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
7135: x_err_code => x_err_code,
7136: x_err_buff => x_err_stage);
7137:
7138: APP_EXCEPTION.RAISE_EXCEPTION;
7139: END IF;
7140:
7141: --product_code is mandatory
7142:
7146: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_MISSING',
7147: x_err_code => x_err_code,
7148: x_err_buff => x_err_stage);
7149:
7150: APP_EXCEPTION.RAISE_EXCEPTION;
7151: END IF;
7152:
7153: ----------------------------------------------------------------------------
7154: -- If award_id is passed in then use it otherwise use the award_number
7175: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
7176: x_err_code => x_err_code,
7177: x_err_buff => x_err_stage);
7178:
7179: APP_EXCEPTION.RAISE_EXCEPTION;
7180: END IF;
7181: --------------------------------------------------------------------------------
7182:
7183: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after award info validation');
7224: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
7225: x_err_code => x_err_code,
7226: x_err_buff => x_err_stage);
7227:
7228: APP_EXCEPTION.RAISE_EXCEPTION;
7229: END IF;
7230: -------------------------------------------------------------------------------
7231:
7232: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after project info validation');
7236: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJECT_MISSING',
7237: x_err_code => x_err_code,
7238: x_err_buff => x_err_stage);
7239:
7240: APP_EXCEPTION.RAISE_EXCEPTION;
7241: END IF;
7242:
7243: -- Now verify whether award security allows the user to update
7244: -- award
7252: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
7253: x_err_code => x_err_code,
7254: x_err_buff => x_err_stage);
7255:
7256: APP_EXCEPTION.RAISE_EXCEPTION;
7257: ELSE
7258: -- If the user has query privileges, then check whether
7259: -- update privileges are also available
7260:
7266: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
7267: x_err_code => x_err_code,
7268: x_err_buff => x_err_stage);
7269:
7270: APP_EXCEPTION.RAISE_EXCEPTION;
7271:
7272: END IF;
7273: END IF;
7274:
7282: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
7283: x_err_code => x_err_code,
7284: x_err_buff => x_err_stage);
7285:
7286: APP_EXCEPTION.RAISE_EXCEPTION;
7287: ELSE
7288: OPEN l_budget_amount_code_csr( p_budget_type_code );
7289:
7290: FETCH l_budget_amount_code_csr
7295: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
7296: x_err_code => x_err_code,
7297: x_err_buff => x_err_stage);
7298:
7299: APP_EXCEPTION.RAISE_EXCEPTION;
7300: END IF;
7301:
7302: CLOSE l_budget_amount_code_csr;
7303:
7320: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
7321: x_err_code => x_err_code,
7322: x_err_buff => x_err_stage);
7323:
7324: APP_EXCEPTION.RAISE_EXCEPTION;
7325: END IF;
7326:
7327: CLOSE l_budget_version_csr;
7328:
7334: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_MISSING',
7335: x_err_code => x_err_code,
7336: x_err_buff => x_err_stage);
7337:
7338: APP_EXCEPTION.RAISE_EXCEPTION;
7339: END IF;
7340:
7341: -- check validity of this budget entry method code, and store associated fields in record
7342: -- dbms_output.put_line('check validity of entry method');
7349: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_INVALID',
7350: x_err_code => x_err_code,
7351: x_err_buff => x_err_stage);
7352:
7353: APP_EXCEPTION.RAISE_EXCEPTION;
7354: END IF;
7355:
7356: CLOSE l_budget_entry_method_csr;
7357:
7369: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_PERIOD_IS_INVALID',
7370: x_err_code => x_err_code,
7371: x_err_buff => x_err_stage);
7372:
7373: APP_EXCEPTION.RAISE_EXCEPTION;
7374: END IF;
7375:
7376: CLOSE l_budget_periods_csr;
7377:
7391: gms_error_pkg.gms_message(x_err_name => 'GMS_START_DATE_MISSING',
7392: x_err_code => x_err_code,
7393: x_err_buff => x_err_stage);
7394:
7395: APP_EXCEPTION.RAISE_EXCEPTION;
7396: END IF;
7397:
7398:
7399: -- convert p_task_number to p_task_id
7422: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_VALIDATE_FAIL', -- jjj - check message tag
7423: x_err_code => x_err_code,
7424: x_err_buff => x_err_stage);
7425:
7426: APP_EXCEPTION.RAISE_EXCEPTION;
7427: END IF;
7428:
7429: END IF;
7430:
7455: gms_error_pkg.gms_message(x_err_name => 'GMS_RES_VALIDATE_FAIL', -- jjj - check message tag
7456: x_err_code => x_err_code,
7457: x_err_buff => x_err_stage);
7458:
7459: APP_EXCEPTION.RAISE_EXCEPTION;
7460:
7461: END IF;
7462:
7463:
7478: gms_error_pkg.gms_message(x_err_name => 'GMS_RESOURCE_IS_MISSING',
7479: x_err_code => x_err_code,
7480: x_err_buff => x_err_stage);
7481:
7482: APP_EXCEPTION.RAISE_EXCEPTION;
7483: END IF;
7484:
7485: END IF;
7486:
7498: gms_error_pkg.gms_message(x_err_name => 'GMS_LIST_MEMBER_INVALID',
7499: x_err_code => x_err_code,
7500: x_err_buff => x_err_stage);
7501:
7502: APP_EXCEPTION.RAISE_EXCEPTION;
7503: END IF;
7504:
7505: CLOSE l_resource_csr;
7506:
7520: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_RESOURCE_ASSIGNMENT',
7521: x_err_code => x_err_code,
7522: x_err_buff => x_err_stage);
7523:
7524: APP_EXCEPTION.RAISE_EXCEPTION;
7525: END IF;
7526:
7527: CLOSE l_resource_assignment_csr;
7528:
7541: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_LINE_NOT_FOUND',
7542: x_err_code => x_err_code,
7543: x_err_buff => x_err_stage);
7544:
7545: APP_EXCEPTION.RAISE_EXCEPTION;
7546:
7547: END IF;
7548:
7549: CLOSE l_budget_line_csr;
7561: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_CHANGE_REASON',
7562: x_err_code => x_err_code,
7563: x_err_buff => x_err_stage);
7564:
7565: APP_EXCEPTION.RAISE_EXCEPTION;
7566: END IF;
7567:
7568: CLOSE l_budget_change_reason_csr;
7569:
7677: gms_error_pkg.gms_message(x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',
7678: x_err_code => x_err_code,
7679: x_err_buff => x_err_stage);
7680:
7681: APP_EXCEPTION.RAISE_EXCEPTION;
7682: END IF;
7683:
7684: ------------------------------------------------------------------------------------
7685: -- Added for Bug:1325015