[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
1280: end if;
1281: end if;
1282:
1283: x_return_status := 1; -- validation FAILED
1284: app_exception.raise_exception;
1285: end if;
1286:
1287: end loop;
1288:
1383: x_err_code => x_err_code,
1384: x_err_buff => x_err_stage);
1385:
1386: x_return_status := 1; -- validation failed
1387: app_exception.raise_exception;
1388: end if;
1389:
1390: END LOOP;
1391: END LOOP;
1497: gms_error_pkg.gms_message(x_err_name => 'GMS_CANT_CHANGE_BEM',
1498: x_err_code => x_err_code,
1499: x_err_buff => x_err_stage);
1500:
1501: APP_EXCEPTION.RAISE_EXCEPTION;
1502: */
1503: end if;
1504:
1505: ----------------------------------------------------------------------------
1544: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_BEM_RESOURCE_LIST',
1545: x_err_code => x_err_code,
1546: x_err_buff => x_err_stage);
1547:
1548: APP_EXCEPTION.RAISE_EXCEPTION;
1549:
1550: end if;
1551:
1552: end validate_bem_resource_list;
1745: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
1746: x_err_code => x_err_code,
1747: x_err_buff => x_err_stage);
1748:
1749: APP_EXCEPTION.RAISE_EXCEPTION;
1750:
1751: END IF;
1752:
1753:
1759: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
1760: x_err_code => x_err_code,
1761: x_err_buff => x_err_stage);
1762:
1763: APP_EXCEPTION.RAISE_EXCEPTION;
1764:
1765: END IF;
1766:
1767: ----------------------------------------------------------------------------
1791: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
1792: x_err_code => x_err_code,
1793: x_err_buff => x_err_stage);
1794:
1795: APP_EXCEPTION.RAISE_EXCEPTION;
1796:
1797: END IF;
1798: --------------------------------------------------------------------------------
1799:
1844: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
1845: x_err_code => x_err_code,
1846: x_err_buff => x_err_stage);
1847:
1848: APP_EXCEPTION.RAISE_EXCEPTION;
1849: END IF;
1850: -------------------------------------------------------------------------------
1851:
1852: -- Now verify whether award security allows the user to update
1864: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
1865: x_err_code => x_err_code,
1866: x_err_buff => x_err_stage);
1867:
1868: APP_EXCEPTION.RAISE_EXCEPTION;
1869:
1870: ELSE
1871: -- If the user has query privileges, then check whether
1872: -- update privileges are also available
1878: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
1879: x_err_code => x_err_code,
1880: x_err_buff => x_err_stage);
1881:
1882: APP_EXCEPTION.RAISE_EXCEPTION;
1883:
1884: END IF;
1885: END IF;
1886:
1894: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
1895: x_err_code => x_err_code,
1896: x_err_buff => x_err_stage);
1897:
1898: APP_EXCEPTION.RAISE_EXCEPTION;
1899:
1900: ELSE
1901: OPEN l_budget_amount_code_csr( p_budget_type_code );
1902:
1909: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
1910: x_err_code => x_err_code,
1911: x_err_buff => x_err_stage);
1912:
1913: APP_EXCEPTION.RAISE_EXCEPTION;
1914: END IF;
1915:
1916: CLOSE l_budget_amount_code_csr;
1917:
1925: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_MISSING',
1926: x_err_code => x_err_code,
1927: x_err_buff => x_err_stage);
1928:
1929: APP_EXCEPTION.RAISE_EXCEPTION;
1930: END IF;
1931:
1932: -- check validity of this budget entry method code, and store associated fields in record
1933:
1942: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_INVALID',
1943: x_err_code => x_err_code,
1944: x_err_buff => x_err_stage);
1945:
1946: APP_EXCEPTION.RAISE_EXCEPTION;
1947:
1948: END IF;
1949:
1950: CLOSE l_budget_entry_method_csr;
1963: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_UNCATEGORIZED_LIST',
1964: x_err_code => x_err_code,
1965: x_err_buff => x_err_stage);
1966:
1967: APP_EXCEPTION.RAISE_EXCEPTION;
1968: END IF;
1969:
1970: l_resource_list_id := l_uncategorized_list_id;
1971:
1993: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_RESOURCE_LIST_NAME',
1994: x_err_code => x_err_code,
1995: x_err_buff => x_err_stage);
1996:
1997: APP_EXCEPTION.RAISE_EXCEPTION;
1998: END IF;
1999:
2000: ELSE
2001: gms_error_pkg.gms_message(x_err_name => 'GMS_RESLIST_ID_NAME_MISSING',
2001: gms_error_pkg.gms_message(x_err_name => 'GMS_RESLIST_ID_NAME_MISSING',
2002: x_err_code => x_err_code,
2003: x_err_buff => x_err_stage);
2004:
2005: APP_EXCEPTION.RAISE_EXCEPTION;
2006: END IF;
2007: ------------------------------------------------------------------------------
2008: /*
2009: IF (p_resource_list_name <> GMS_BUDGET_PUB.G_PA_MISS_CHAR
2050: gms_error_pkg.gms_message(x_err_name => 'GMS_CHANGE_REASON_INVALID',
2051: x_err_code => x_err_code,
2052: x_err_buff => x_err_stage);
2053:
2054: APP_EXCEPTION.RAISE_EXCEPTION;
2055:
2056: END IF;
2057:
2058: CLOSE l_budget_change_reason_csr;
2188: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_IS_SUBMITTED',
2189: x_err_code => x_err_code,
2190: x_err_buff => x_err_stage);
2191:
2192: APP_EXCEPTION.RAISE_EXCEPTION;
2193: END IF;
2194:
2195: IF p_pm_budget_reference = GMS_BUDGET_PUB.G_PA_MISS_CHAR
2196: THEN
2219: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_PERIOD_IS_INVALID',
2220: x_err_code => x_err_code,
2221: x_err_buff => x_err_stage);
2222:
2223: APP_EXCEPTION.RAISE_EXCEPTION;
2224: END IF;
2225: CLOSE l_budget_periods_csr;
2226: END IF;
2227:
2260: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_BASE_RES_LIST_EXISTS',
2261: x_err_code => x_err_code,
2262: x_err_buff => x_err_stage);
2263:
2264: APP_EXCEPTION.RAISE_EXCEPTION;
2265: end if;
2266:
2267: l_baselined_exists := TRUE;
2268:
2298: gms_error_pkg.gms_message(x_err_name => 'GMS_DELETE_DRAFT_FAIL',
2299: x_err_code => x_err_code,
2300: x_err_buff => x_err_stage);
2301:
2302: APP_EXCEPTION.RAISE_EXCEPTION;
2303: end if;
2304:
2305: elsif (x_err_code > 0) then
2306: -- reset x_err_code
2822: x_err_buff => x_err_stage);
2823: fnd_msg_pub.add; -- Bug 2587078
2824:
2825:
2826: APP_EXCEPTION.RAISE_EXCEPTION;
2827:
2828: END IF;
2829:
2830: --product_code is mandatory
2836: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
2837: x_err_code => x_err_code,
2838: x_err_buff => x_err_stage);
2839: fnd_msg_pub.add; -- Bug 2587078
2840: APP_EXCEPTION.RAISE_EXCEPTION;
2841:
2842: END IF;
2843:
2844: ----------------------------------------------------------------------------
2875: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
2876: x_err_code => x_err_code,
2877: x_err_buff => x_err_stage);
2878: fnd_msg_pub.add; -- Bug 2587078
2879: APP_EXCEPTION.RAISE_EXCEPTION;
2880: END IF;
2881: --------------------------------------------------------------------------------
2882: -- getting the award number to be used in Error Messages...
2883:
2948: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJECT_IS_MISSING', -- 'GMS_PROJ_NUM_ID_MISSING', Bug 2587078
2949: x_err_code => x_err_code,
2950: x_err_buff => x_err_stage);
2951: fnd_msg_pub.add; -- Bug 2587078
2952: APP_EXCEPTION.RAISE_EXCEPTION;
2953:
2954: END IF;
2955:
2956: -------------------------------------------------------------------------------
2967: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_REF_AND_ID_MISSING', --'GMS_INVALID_PROJ_NUMBER', bug 2587078
2968: x_err_code => x_err_code,
2969: x_err_buff => x_err_stage);
2970: fnd_msg_pub.add; -- Bug 2587078
2971: APP_EXCEPTION.RAISE_EXCEPTION;
2972: END IF;
2973:
2974: -- budget type code is mandatory
2975:
2980: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
2981: x_err_code => x_err_code,
2982: x_err_buff => x_err_stage);
2983: fnd_msg_pub.add; -- Bug 2587078
2984: APP_EXCEPTION.RAISE_EXCEPTION;
2985:
2986: ELSE
2987: OPEN l_budget_types_csr( p_budget_type_code );
2988:
2997: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
2998: x_err_code => x_err_code,
2999: x_err_buff => x_err_stage);
3000: fnd_msg_pub.add; -- Bug 2587078
3001: APP_EXCEPTION.RAISE_EXCEPTION;
3002:
3003: END IF;
3004:
3005: CLOSE l_budget_types_csr;
3054: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
3055: x_err_code => x_err_code,
3056: x_err_buff => x_err_stage);
3057: fnd_msg_pub.add; -- Bug 2587078
3058: APP_EXCEPTION.RAISE_EXCEPTION;
3059: END IF;
3060:
3061: CLOSE l_budget_versions_csr;
3062:
3075: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_LINES',
3076: x_err_code => x_err_code,
3077: x_err_buff => x_err_stage);
3078: fnd_msg_pub.add; -- Bug 2587078
3079: APP_EXCEPTION.RAISE_EXCEPTION;
3080: END IF;
3081:
3082: CLOSE l_resource_assignments_csr;
3083:
3092: gms_error_pkg.gms_message(x_err_name => 'GMS_TIME_PHASED_TYPE_CODE_MISS',
3093: x_err_code => x_err_code,
3094: x_err_buff => x_err_stage);
3095: fnd_msg_pub.add; -- Bug 2587078
3096: APP_EXCEPTION.RAISE_EXCEPTION;
3097: END IF;
3098:
3099: -- Dummy call !
3100:
3113: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_FAILED',
3114: x_err_code => x_err_code,
3115: x_err_buff => x_err_stage);
3116: fnd_msg_pub.add; -- Bug 2587078
3117: APP_EXCEPTION.RAISE_EXCEPTION;
3118: END IF;
3119:
3120: -- ------------------------------------------------------------------------------------
3121: -- Added SUBMISSION/BASELINE RULES and WORFLOW
3138: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_RULES_ATTR',
3139: x_err_code => x_err_code,
3140: x_err_buff => x_err_stage);
3141: fnd_msg_pub.add; -- Bug 2587078
3142: APP_EXCEPTION.RAISE_EXCEPTION;
3143:
3144: END IF;
3145:
3146: CLOSE l_budget_rules_csr;
3236: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_BUDGET_FAIL_S',
3237: x_err_code => x_err_code,
3238: x_err_buff => x_err_stage);
3239: fnd_msg_pub.add; -- Bug 25870708
3240: APP_EXCEPTION.RAISE_EXCEPTION;
3241: END IF;
3242: END IF;
3243:
3244:
3288: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_BUDGET_FAIL_B',
3289: x_err_code => x_err_code,
3290: x_err_buff => x_err_stage);
3291: fnd_msg_pub.add; -- Bug 2587078
3292: APP_EXCEPTION.RAISE_EXCEPTION;
3293:
3294: END IF;
3295: END IF;
3296:
3317: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDG_WF_CHECK_FAIL',
3318: x_err_code => x_err_code,
3319: x_err_buff => x_err_stage);
3320: fnd_msg_pub.add; -- Bug 2587078
3321: APP_EXCEPTION.RAISE_EXCEPTION;
3322: END IF;
3323:
3324: IF L_DEBUG = 'Y' THEN
3325: gms_error_pkg.gms_debug('GMS_BUDGET_PUB.BASELINE_BUDGET - l_workflow_is_used : '||l_workflow_is_used, 'C');
3358: gms_error_pkg.gms_message(x_err_name => 'GMS_START_BUDG_WF_FAIL',
3359: x_err_code => x_err_code,
3360: x_err_buff => x_err_stage);
3361: fnd_msg_pub.add; -- Bug 2587078
3362: APP_EXCEPTION.RAISE_EXCEPTION;
3363: END IF;
3364:
3365: p_workflow_started := 'Y';
3366:
3494: gms_error_pkg.gms_message(x_err_name => 'GMS_BASELINE_FAILED',
3495: x_err_code => x_err_code,
3496: x_err_buff => x_err_stage);
3497: fnd_msg_pub.add; -- Bug 2587078
3498: APP_EXCEPTION.RAISE_EXCEPTION;
3499: END IF;
3500:
3501: -- Bug 5162777 : Derive the the budget_version_id of the previously baselined budget before creating new BC records.
3502: ----------- DERIVING THE BUDGET_VERSION_ID OF THE PREVIOUSLY BASELINED BUDGET -----------------
3548: x_err_code => x_err_code,
3549: x_err_buff => x_err_stage);
3550:
3551: fnd_msg_pub.add;
3552: APP_EXCEPTION.RAISE_EXCEPTION;
3553: end;
3554: -- Bug 2386041
3555:
3556: ---------------------------------------------------------------------------------------------------------
3576: x_err_buff => x_err_stage);
3577:
3578: SAVEPOINT baseline_budget_pub;
3579: fnd_msg_pub.add; -- Bug 2587078
3580: APP_EXCEPTION.RAISE_EXCEPTION;
3581: -- Bug 2386041
3582: end if;
3583: ----------------------- END OF BC RECORD CREATION -------------------------
3584:
3688: x_err_code => x_err_code,
3689: x_err_buff => x_err_stage);
3690:
3691: fnd_msg_pub.add;
3692: APP_EXCEPTION.RAISE_EXCEPTION;
3693: end;
3694:
3695: -- Bug 2587078 :The Project budget summarization code is shifted after call to sweeper process .
3696:
3763:
3764: commit;
3765: SAVEPOINT baseline_budget_pub;
3766: fnd_msg_pub.add; -- Bug 2587078
3767: APP_EXCEPTION.RAISE_EXCEPTION;
3768: -- Bug 2386041
3769: end if;
3770:
3771: end if; -- l_packet_id not null. Bug 2821482
3894:
3895: commit;
3896: SAVEPOINT baseline_budget_pub;
3897: fnd_msg_pub.add; -- Bug 2587078
3898: APP_EXCEPTION.RAISE_EXCEPTION;
3899: -- Bug 2386041
3900:
3901: END IF;
3902:
3942: gms_error_pkg.gms_output(x_output => x_err_stage);
3943: return;
3944:
3945: -- We don't have to stop the baseline process if the WF Notification process fails.
3946: -- APP_EXCEPTION.RAISE_EXCEPTION;
3947: end if;
3948:
3949: end if;
3950:
4273: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
4274: x_err_code => x_err_code,
4275: x_err_buff => x_err_stage);
4276:
4277: APP_EXCEPTION.RAISE_EXCEPTION;
4278:
4279: END IF;
4280:
4281: l_resp_id := FND_GLOBAL.Resp_id;
4303: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_MISSING',
4304: x_err_code => x_err_code,
4305: x_err_buff => x_err_stage);
4306:
4307: APP_EXCEPTION.RAISE_EXCEPTION;
4308: END IF;
4309: ----------------------------------------------------------------------------
4310: -- If award_id is passed in then use it otherwise use the award_number
4311: -- that is passed in to fetch value of award_id from gms_awards table
4331: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
4332: x_err_code => x_err_code,
4333: x_err_buff => x_err_stage);
4334:
4335: APP_EXCEPTION.RAISE_EXCEPTION;
4336: END IF;
4337: --------------------------------------------------------------------------------
4338: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after award info validation');
4339:
4362: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
4363: x_err_code => x_err_code,
4364: x_err_buff => x_err_stage);
4365:
4366: APP_EXCEPTION.RAISE_EXCEPTION;
4367: END IF;
4368:
4369: -------------------------------------------------------------------------------
4370: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after project info validation');
4374: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJECT_IS_MISSING',
4375: x_err_code => x_err_code,
4376: x_err_buff => x_err_stage);
4377:
4378: APP_EXCEPTION.RAISE_EXCEPTION;
4379: END IF;
4380:
4381: -- Now verify whether award security allows the user to update
4382: -- the award
4391: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
4392: x_err_code => x_err_code,
4393: x_err_buff => x_err_stage);
4394:
4395: APP_EXCEPTION.RAISE_EXCEPTION;
4396:
4397: ELSE
4398: -- If the user has query privileges, then check whether
4399: -- update privileges are also available
4404: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
4405: x_err_code => x_err_code,
4406: x_err_buff => x_err_stage);
4407:
4408: APP_EXCEPTION.RAISE_EXCEPTION;
4409: END IF;
4410: END IF;
4411:
4412: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after award security validation');
4418: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
4419: x_err_code => x_err_code,
4420: x_err_buff => x_err_stage);
4421:
4422: APP_EXCEPTION.RAISE_EXCEPTION;
4423: ELSE
4424: OPEN l_budget_amount_code_csr( p_budget_type_code );
4425:
4426: FETCH l_budget_amount_code_csr
4432: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
4433: x_err_code => x_err_code,
4434: x_err_buff => x_err_stage);
4435:
4436: APP_EXCEPTION.RAISE_EXCEPTION;
4437: END IF;
4438:
4439: CLOSE l_budget_amount_code_csr;
4440:
4456: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
4457: x_err_code => x_err_code,
4458: x_err_buff => x_err_stage);
4459:
4460: APP_EXCEPTION.RAISE_EXCEPTION;
4461: END IF;
4462:
4463: CLOSE l_budget_version_csr;
4464:
4471: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_MISSING',
4472: x_err_code => x_err_code,
4473: x_err_buff => x_err_stage);
4474:
4475: APP_EXCEPTION.RAISE_EXCEPTION;
4476: END IF;
4477:
4478: -- check validity of this budget entry method code, and store associated fields in record
4479:
4486: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_INVALID',
4487: x_err_code => x_err_code,
4488: x_err_buff => x_err_stage);
4489:
4490: APP_EXCEPTION.RAISE_EXCEPTION;
4491: END IF;
4492:
4493: CLOSE l_budget_entry_method_csr;
4494:
4524: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_TASK_NUMBER',
4525: x_err_code => x_err_code,
4526: x_err_buff => x_err_stage);
4527:
4528: APP_EXCEPTION.RAISE_EXCEPTION;
4529: END IF;
4530:
4531: END IF;
4532:
4536: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_IS_NOT_TOP',
4537: x_err_code => x_err_code,
4538: x_err_buff => x_err_stage);
4539:
4540: APP_EXCEPTION.RAISE_EXCEPTION;
4541: END IF;
4542:
4543: ELSIF l_budget_entry_method_rec.entry_level_code = 'L' -- then check whether it is lowest task
4544: THEN
4548: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_IS_NOT_LOWEST',
4549: x_err_code => x_err_code,
4550: x_err_buff => x_err_stage);
4551:
4552: APP_EXCEPTION.RAISE_EXCEPTION;
4553: END IF;
4554:
4555: ELSIF l_budget_entry_method_rec.entry_level_code = 'M' -- then check whether it is a top or
4556: -- lowest level tasks
4562: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_IS_NOT_TOP_OR_LOWEST',
4563: x_err_code => x_err_code,
4564: x_err_buff => x_err_stage);
4565:
4566: APP_EXCEPTION.RAISE_EXCEPTION;
4567: END IF;
4568: END IF;
4569:
4570: END IF; -- If l_budget_entry_method_rec.entry_level_code = 'T'
4589: gms_error_pkg.gms_message(x_err_name => 'GMS_GET_PERIOD_DATE_FAIL',
4590: x_err_code => x_err_code,
4591: x_err_buff => x_err_stage);
4592:
4593: APP_EXCEPTION.RAISE_EXCEPTION;
4594: END IF;
4595:
4596: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after gms_budget_utils.get_valid_period_dates');
4597:
4611: gms_error_pkg.gms_message(x_err_name => 'GMS_CHK_ENTRYMETHOD_FAIL',
4612: x_err_code => x_err_code,
4613: x_err_buff => x_err_stage);
4614:
4615: APP_EXCEPTION.RAISE_EXCEPTION;
4616: END IF;
4617:
4618: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after gms_budget_utils.check_entry_method_flags');
4619:
4675: gms_error_pkg.gms_message(x_err_name => 'GMS_RESOURCE_MISSING',
4676: x_err_code => x_err_code,
4677: x_err_buff => x_err_stage);
4678:
4679: APP_EXCEPTION.RAISE_EXCEPTION;
4680: END IF;
4681:
4682:
4683: --When budget line description is not passed, set value to NULL
4903: x_token_val2 => sqlerrm,
4904: x_err_code => x_err_code,
4905: x_err_buff => x_err_stage);
4906:
4907: APP_EXCEPTION.RAISE_EXCEPTION;
4908: end ;
4909:
4910: -- dbms_output.put_line('GMS_BUDGET_PUB.ADD_BUDGET_LINE - after insert into gms_resource_assignments');
4911:
5029: gms_error_pkg.gms_message(x_err_name => 'GMS_CHECK_DATES_FAILED',
5030: x_err_code => x_err_code,
5031: x_err_buff => x_err_stage);
5032:
5033: APP_EXCEPTION.RAISE_EXCEPTION;
5034: END IF;
5035:
5036: end if; -- Time Phased type code
5037:
5053: gms_error_pkg.gms_message(x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',
5054: x_err_code => x_err_code,
5055: x_err_buff => x_err_stage);
5056:
5057: APP_EXCEPTION.RAISE_EXCEPTION;
5058: END IF;
5059:
5060: ------------------------------------------------------------------------------------
5061: -- Added for Bug:1325015
5212: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
5213: x_err_code => x_err_code,
5214: x_err_buff => x_err_stage);
5215:
5216: APP_EXCEPTION.RAISE_EXCEPTION;
5217: END IF;
5218:
5219: -- product_code is mandatory
5220:
5224: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
5225: x_err_code => x_err_code,
5226: x_err_buff => x_err_stage);
5227:
5228: APP_EXCEPTION.RAISE_EXCEPTION;
5229: END IF;
5230:
5231: ----------------------------------------------------------------------------
5232: -- If award_id is passed in then use it otherwise use the award_number
5254: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
5255: x_err_code => x_err_code,
5256: x_err_buff => x_err_stage);
5257:
5258: APP_EXCEPTION.RAISE_EXCEPTION;
5259: END IF;
5260: --------------------------------------------------------------------------------
5261:
5262: l_resp_id := FND_GLOBAL.Resp_id;
5304: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
5305: x_err_code => x_err_code,
5306: x_err_buff => x_err_stage);
5307:
5308: APP_EXCEPTION.RAISE_EXCEPTION;
5309: END IF;
5310: -------------------------------------------------------------------------------
5311:
5312: -- Now verify whether award security allows the user to update
5322: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
5323: x_err_code => x_err_code,
5324: x_err_buff => x_err_stage);
5325:
5326: APP_EXCEPTION.RAISE_EXCEPTION;
5327:
5328: ELSE
5329: -- If the user has query privileges, then check whether
5330: -- update privileges are also available
5335: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
5336: x_err_code => x_err_code,
5337: x_err_buff => x_err_stage);
5338:
5339: APP_EXCEPTION.RAISE_EXCEPTION;
5340:
5341: END IF;
5342: END IF;
5343:
5350: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
5351: x_err_code => x_err_code,
5352: x_err_buff => x_err_stage);
5353:
5354: APP_EXCEPTION.RAISE_EXCEPTION;
5355:
5356: ELSE
5357: OPEN l_budget_type_csr( p_budget_type_code );
5358:
5364: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
5365: x_err_code => x_err_code,
5366: x_err_buff => x_err_stage);
5367:
5368: APP_EXCEPTION.RAISE_EXCEPTION;
5369: END IF;
5370:
5371: CLOSE l_budget_type_csr;
5372:
5390: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
5391: x_err_code => x_err_code,
5392: x_err_buff => x_err_stage);
5393:
5394: APP_EXCEPTION.RAISE_EXCEPTION;
5395:
5396: END IF;
5397:
5398: CLOSE l_budget_version_csr;
5441: gms_error_pkg.gms_message(x_err_name => 'GMS_DELETE_BUDGET_LINE_FAIL',
5442: x_err_code => x_err_code,
5443: x_err_buff => x_err_stage);
5444:
5445: APP_EXCEPTION.RAISE_EXCEPTION;
5446: end if;
5447:
5448: end loop;
5449:
5456: gms_error_pkg.gms_message(x_err_name => 'GMS_DELETE_DRAFT_FAIL',
5457: x_err_code => x_err_code,
5458: x_err_buff => x_err_stage);
5459:
5460: APP_EXCEPTION.RAISE_EXCEPTION;
5461: end;
5462:
5463: --!!! temporary solution, because delete_draft has commit
5464:
5671: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
5672: x_err_code => x_err_code,
5673: x_err_buff => x_err_stage);
5674:
5675: APP_EXCEPTION.RAISE_EXCEPTION;
5676: END IF;
5677:
5678: -- product_code is mandatory
5679:
5683: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
5684: x_err_code => x_err_code,
5685: x_err_buff => x_err_stage);
5686:
5687: APP_EXCEPTION.RAISE_EXCEPTION;
5688: END IF;
5689:
5690: ----------------------------------------------------------------------------
5691: -- If award_id is passed in then use it otherwise use the award_number
5712: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
5713: x_err_code => x_err_code,
5714: x_err_buff => x_err_stage);
5715:
5716: APP_EXCEPTION.RAISE_EXCEPTION;
5717: END IF;
5718: --------------------------------------------------------------------------------
5719:
5720: l_resp_id := FND_GLOBAL.Resp_id;
5758: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
5759: x_err_code => x_err_code,
5760: x_err_buff => x_err_stage);
5761:
5762: APP_EXCEPTION.RAISE_EXCEPTION;
5763: END IF;
5764: -------------------------------------------------------------------------------
5765:
5766: -- Now verify whether award security allows the user to update
5775: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
5776: x_err_code => x_err_code,
5777: x_err_buff => x_err_stage);
5778:
5779: APP_EXCEPTION.RAISE_EXCEPTION;
5780:
5781: ELSE
5782: -- If the user has query privileges, then check whether
5783: -- update privileges are also available
5789: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
5790: x_err_code => x_err_code,
5791: x_err_buff => x_err_stage);
5792:
5793: APP_EXCEPTION.RAISE_EXCEPTION;
5794:
5795: END IF;
5796: END IF;
5797:
5804: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
5805: x_err_code => x_err_code,
5806: x_err_buff => x_err_stage);
5807:
5808: APP_EXCEPTION.RAISE_EXCEPTION;
5809: ELSE
5810: OPEN l_budget_type_csr( p_budget_type_code );
5811:
5812: FETCH l_budget_type_csr INTO l_dummy;
5840: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
5841: x_err_code => x_err_code,
5842: x_err_buff => x_err_stage);
5843:
5844: APP_EXCEPTION.RAISE_EXCEPTION;
5845: END IF;
5846:
5847: CLOSE l_budget_version_csr;
5848:
5872: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_VALIDATE_FAIL', -- jjj - check message tag
5873: x_err_code => x_err_code,
5874: x_err_buff => x_err_stage);
5875:
5876: APP_EXCEPTION.RAISE_EXCEPTION;
5877:
5878: END IF;
5879: END IF;
5880:
5906: gms_error_pkg.gms_message(x_err_name => 'GMS_RES_VALIDATE_FAIL',
5907: x_err_code => x_err_code,
5908: x_err_buff => x_err_stage);
5909:
5910: APP_EXCEPTION.RAISE_EXCEPTION;
5911: END IF;
5912:
5913: ELSE
5914:
5932: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_RESOURCE_ASSIGNMENT',
5933: x_err_code => x_err_code,
5934: x_err_buff => x_err_stage);
5935:
5936: APP_EXCEPTION.RAISE_EXCEPTION;
5937: END IF;
5938:
5939: CLOSE l_resource_assignment_csr;
5940:
5959: gms_error_pkg.gms_message(x_err_name => 'GMS_PERIOD_NAME_INVALID',
5960: x_err_code => x_err_code,
5961: x_err_buff => x_err_stage);
5962:
5963: APP_EXCEPTION.RAISE_EXCEPTION;
5964: END IF;
5965: CLOSE l_budget_periods_csr;
5966:
5967: ELSIF p_start_date IS NOT NULL
5984: gms_error_pkg.gms_message(x_err_name => 'GMS_START_DATE_INVALID',
5985: x_err_code => x_err_code,
5986: x_err_buff => x_err_stage);
5987:
5988: APP_EXCEPTION.RAISE_EXCEPTION;
5989: END IF;
5990:
5991: CLOSE l_start_date_csr;
5992:
6010: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_LINE_NOT_FOUND',
6011: x_err_code => x_err_code,
6012: x_err_buff => x_err_stage);
6013:
6014: APP_EXCEPTION.RAISE_EXCEPTION;
6015: END IF;
6016:
6017:
6018: WHILE l_budget_line_rowid_csr%FOUND LOOP
6098: x_token_val2 => sqlerrm,
6099: x_err_code => x_err_code,
6100: x_err_buff => x_err_stage);
6101:
6102: APP_EXCEPTION.RAISE_EXCEPTION;
6103:
6104: END;
6105:
6106: FETCH l_budget_line_rowid_csr INTO l_budget_line_rowid;
6123: gms_error_pkg.gms_message(x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',
6124: x_err_code => x_err_code,
6125: x_err_buff => x_err_stage);
6126:
6127: APP_EXCEPTION.RAISE_EXCEPTION;
6128: END IF;
6129:
6130: ------------------------------------------------------------------------------------
6131: -- Added for Bug:1325015
6447: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
6448: x_err_code => x_err_code,
6449: x_err_buff => x_err_stage);
6450:
6451: APP_EXCEPTION.RAISE_EXCEPTION;
6452: END IF;
6453:
6454: --product_code is mandatory
6455:
6459: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_IS_MISSING',
6460: x_err_code => x_err_code,
6461: x_err_buff => x_err_stage);
6462:
6463: APP_EXCEPTION.RAISE_EXCEPTION;
6464: END IF;
6465:
6466: ----------------------------------------------------------------------------
6467: -- If award_id is passed in then use it otherwise use the award_number
6488: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
6489: x_err_code => x_err_code,
6490: x_err_buff => x_err_stage);
6491:
6492: APP_EXCEPTION.RAISE_EXCEPTION;
6493: END IF;
6494: --------------------------------------------------------------------------------
6495: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - after award info validation');
6496:
6541: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
6542: x_err_code => x_err_code,
6543: x_err_buff => x_err_stage);
6544:
6545: APP_EXCEPTION.RAISE_EXCEPTION;
6546: END IF;
6547: -------------------------------------------------------------------------------
6548: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET - after project info validation');
6549:
6559: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
6560: x_err_code => x_err_code,
6561: x_err_buff => x_err_stage);
6562:
6563: APP_EXCEPTION.RAISE_EXCEPTION;
6564:
6565: ELSE
6566: -- If the user has query privileges, then check whether
6567: -- update privileges are also available
6574: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
6575: x_err_code => x_err_code,
6576: x_err_buff => x_err_stage);
6577:
6578: APP_EXCEPTION.RAISE_EXCEPTION;
6579: END IF;
6580: END IF;
6581:
6582:
6588: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_MISSING',
6589: x_err_code => x_err_code,
6590: x_err_buff => x_err_stage);
6591:
6592: APP_EXCEPTION.RAISE_EXCEPTION;
6593:
6594: ELSE
6595: OPEN l_budget_type_csr( p_budget_type_code );
6596:
6603: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
6604: x_err_code => x_err_code,
6605: x_err_buff => x_err_stage);
6606:
6607: APP_EXCEPTION.RAISE_EXCEPTION;
6608:
6609: END IF;
6610:
6611: CLOSE l_budget_type_csr;
6629: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
6630: x_err_code => x_err_code,
6631: x_err_buff => x_err_stage);
6632:
6633: APP_EXCEPTION.RAISE_EXCEPTION;
6634: END IF;
6635:
6636: CLOSE l_budget_version_csr;
6637:
6660: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_CHANGE_REASON',
6661: x_err_code => x_err_code,
6662: x_err_buff => x_err_stage);
6663:
6664: APP_EXCEPTION.RAISE_EXCEPTION;
6665: END IF;
6666:
6667: CLOSE l_budget_change_reason_csr;
6668: END IF;
6695: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_PERIOD_IS_INVALID',
6696: x_err_code => x_err_code,
6697: x_err_buff => x_err_stage);
6698:
6699: APP_EXCEPTION.RAISE_EXCEPTION;
6700: END IF;
6701: CLOSE l_budget_periods_csr;
6702: END IF;
6703:
6823: gms_error_pkg.gms_message(x_err_name => 'GMS_CHECK_DATES_FAILED',
6824: x_err_code => x_err_code,
6825: x_err_buff => x_err_stage);
6826:
6827: APP_EXCEPTION.RAISE_EXCEPTION;
6828: END IF;
6829:
6830: end if; -- l_time_phased_type_code
6831:
6843: gms_error_pkg.gms_message(x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',
6844: x_err_code => x_err_code,
6845: x_err_buff => x_err_stage);
6846:
6847: APP_EXCEPTION.RAISE_EXCEPTION;
6848: END IF;
6849:
6850:
6851: -- END IF; --if there are budget lines
7133: gms_error_pkg.gms_message(x_err_name => 'GMS_INCOMPATIBLE_API_CALL',
7134: x_err_code => x_err_code,
7135: x_err_buff => x_err_stage);
7136:
7137: APP_EXCEPTION.RAISE_EXCEPTION;
7138: END IF;
7139:
7140: --product_code is mandatory
7141:
7145: gms_error_pkg.gms_message(x_err_name => 'GMS_PRODUCT_CODE_MISSING',
7146: x_err_code => x_err_code,
7147: x_err_buff => x_err_stage);
7148:
7149: APP_EXCEPTION.RAISE_EXCEPTION;
7150: END IF;
7151:
7152: ----------------------------------------------------------------------------
7153: -- If award_id is passed in then use it otherwise use the award_number
7174: gms_error_pkg.gms_message(x_err_name => 'GMS_AWARD_NUM_ID_MISSING',
7175: x_err_code => x_err_code,
7176: x_err_buff => x_err_stage);
7177:
7178: APP_EXCEPTION.RAISE_EXCEPTION;
7179: END IF;
7180: --------------------------------------------------------------------------------
7181:
7182: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after award info validation');
7223: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_NUM_ID_MISSING',
7224: x_err_code => x_err_code,
7225: x_err_buff => x_err_stage);
7226:
7227: APP_EXCEPTION.RAISE_EXCEPTION;
7228: END IF;
7229: -------------------------------------------------------------------------------
7230:
7231: -- dbms_output.put_line('GMS_BUDGET_PUB.UPDATE_BUDGET_LINE - after project info validation');
7235: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJECT_MISSING',
7236: x_err_code => x_err_code,
7237: x_err_buff => x_err_stage);
7238:
7239: APP_EXCEPTION.RAISE_EXCEPTION;
7240: END IF;
7241:
7242: -- Now verify whether award security allows the user to update
7243: -- award
7251: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_QRY',
7252: x_err_code => x_err_code,
7253: x_err_buff => x_err_stage);
7254:
7255: APP_EXCEPTION.RAISE_EXCEPTION;
7256: ELSE
7257: -- If the user has query privileges, then check whether
7258: -- update privileges are also available
7259:
7265: gms_error_pkg.gms_message(x_err_name => 'GMS_AWD_SECURITY_ENFORCED_UPD',
7266: x_err_code => x_err_code,
7267: x_err_buff => x_err_stage);
7268:
7269: APP_EXCEPTION.RAISE_EXCEPTION;
7270:
7271: END IF;
7272: END IF;
7273:
7281: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_MISSING',
7282: x_err_code => x_err_code,
7283: x_err_buff => x_err_stage);
7284:
7285: APP_EXCEPTION.RAISE_EXCEPTION;
7286: ELSE
7287: OPEN l_budget_amount_code_csr( p_budget_type_code );
7288:
7289: FETCH l_budget_amount_code_csr
7294: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_TYPE_IS_INVALID',
7295: x_err_code => x_err_code,
7296: x_err_buff => x_err_stage);
7297:
7298: APP_EXCEPTION.RAISE_EXCEPTION;
7299: END IF;
7300:
7301: CLOSE l_budget_amount_code_csr;
7302:
7319: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_BUDGET_VERSION',
7320: x_err_code => x_err_code,
7321: x_err_buff => x_err_stage);
7322:
7323: APP_EXCEPTION.RAISE_EXCEPTION;
7324: END IF;
7325:
7326: CLOSE l_budget_version_csr;
7327:
7333: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_MISSING',
7334: x_err_code => x_err_code,
7335: x_err_buff => x_err_stage);
7336:
7337: APP_EXCEPTION.RAISE_EXCEPTION;
7338: END IF;
7339:
7340: -- check validity of this budget entry method code, and store associated fields in record
7341: -- dbms_output.put_line('check validity of entry method');
7348: gms_error_pkg.gms_message(x_err_name => 'GMS_ENTRY_METHOD_IS_INVALID',
7349: x_err_code => x_err_code,
7350: x_err_buff => x_err_stage);
7351:
7352: APP_EXCEPTION.RAISE_EXCEPTION;
7353: END IF;
7354:
7355: CLOSE l_budget_entry_method_csr;
7356:
7368: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_PERIOD_IS_INVALID',
7369: x_err_code => x_err_code,
7370: x_err_buff => x_err_stage);
7371:
7372: APP_EXCEPTION.RAISE_EXCEPTION;
7373: END IF;
7374:
7375: CLOSE l_budget_periods_csr;
7376:
7390: gms_error_pkg.gms_message(x_err_name => 'GMS_START_DATE_MISSING',
7391: x_err_code => x_err_code,
7392: x_err_buff => x_err_stage);
7393:
7394: APP_EXCEPTION.RAISE_EXCEPTION;
7395: END IF;
7396:
7397:
7398: -- convert p_task_number to p_task_id
7421: gms_error_pkg.gms_message(x_err_name => 'GMS_TASK_VALIDATE_FAIL', -- jjj - check message tag
7422: x_err_code => x_err_code,
7423: x_err_buff => x_err_stage);
7424:
7425: APP_EXCEPTION.RAISE_EXCEPTION;
7426: END IF;
7427:
7428: END IF;
7429:
7454: gms_error_pkg.gms_message(x_err_name => 'GMS_RES_VALIDATE_FAIL', -- jjj - check message tag
7455: x_err_code => x_err_code,
7456: x_err_buff => x_err_stage);
7457:
7458: APP_EXCEPTION.RAISE_EXCEPTION;
7459:
7460: END IF;
7461:
7462:
7477: gms_error_pkg.gms_message(x_err_name => 'GMS_RESOURCE_IS_MISSING',
7478: x_err_code => x_err_code,
7479: x_err_buff => x_err_stage);
7480:
7481: APP_EXCEPTION.RAISE_EXCEPTION;
7482: END IF;
7483:
7484: END IF;
7485:
7497: gms_error_pkg.gms_message(x_err_name => 'GMS_LIST_MEMBER_INVALID',
7498: x_err_code => x_err_code,
7499: x_err_buff => x_err_stage);
7500:
7501: APP_EXCEPTION.RAISE_EXCEPTION;
7502: END IF;
7503:
7504: CLOSE l_resource_csr;
7505:
7519: gms_error_pkg.gms_message(x_err_name => 'GMS_NO_RESOURCE_ASSIGNMENT',
7520: x_err_code => x_err_code,
7521: x_err_buff => x_err_stage);
7522:
7523: APP_EXCEPTION.RAISE_EXCEPTION;
7524: END IF;
7525:
7526: CLOSE l_resource_assignment_csr;
7527:
7540: gms_error_pkg.gms_message(x_err_name => 'GMS_BUDGET_LINE_NOT_FOUND',
7541: x_err_code => x_err_code,
7542: x_err_buff => x_err_stage);
7543:
7544: APP_EXCEPTION.RAISE_EXCEPTION;
7545:
7546: END IF;
7547:
7548: CLOSE l_budget_line_csr;
7560: gms_error_pkg.gms_message(x_err_name => 'GMS_INVALID_CHANGE_REASON',
7561: x_err_code => x_err_code,
7562: x_err_buff => x_err_stage);
7563:
7564: APP_EXCEPTION.RAISE_EXCEPTION;
7565: END IF;
7566:
7567: CLOSE l_budget_change_reason_csr;
7568:
7676: gms_error_pkg.gms_message(x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',
7677: x_err_code => x_err_code,
7678: x_err_buff => x_err_stage);
7679:
7680: APP_EXCEPTION.RAISE_EXCEPTION;
7681: END IF;
7682:
7683: ------------------------------------------------------------------------------------
7684: -- Added for Bug:1325015