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.GMS_SUMMARIZE_BUDGETS dependencies on GMS_SUMMARIZE_BUDGETS

Line 1: PACKAGE BODY GMS_SUMMARIZE_BUDGETS AS

1: PACKAGE BODY GMS_SUMMARIZE_BUDGETS AS
2: -- $Header: gmsbusub.pls 120.2 2007/02/06 09:49:00 rshaik ship $
3:
4: -- To check on, whether to print debug messages in log file or not
5: L_DEBUG varchar2(1) := NVL(FND_PROFILE.value('GMS_ENABLE_DEBUG_MODE'), 'N');

Line 70: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.validate_profile_bem - Caterozied and Invlid BEM ';

66: l_bem_valid := 'N' ;
67: END IF ;
68:
69: If p_res_categorized = 'Y' and l_bem_valid = 'N' then
70: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.validate_profile_bem - Caterozied and Invlid BEM ';
71: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_BUDGET_SUM_CHANGE_CAT',
72: x_exec_type => 'C', -- for concurrent process
73: x_err_code => x_err_code,
74: x_err_buff => x_err_stage);

Line 82: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.validate_profile_bem - Uncaterozied and Invlid BEM ';

78: p_err_msg_code := 'F' ;
79: end if ;
80:
81: If p_res_categorized = 'N' and l_bem_valid = 'N' then
82: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.validate_profile_bem - Uncaterozied and Invlid BEM ';
83: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_BUDGET_SUM_CHAN_UNCAT',
84: x_exec_type => 'C', -- for concurrent process
85: x_err_code => x_err_code,
86: x_err_buff => x_err_stage);

Line 96: PROCEDURE GMS_SUMMARIZE_BUDGETS (x_project_id NUMBER

92:
93: end ;
94:
95: -- ------------------------------------------------------------
96: PROCEDURE GMS_SUMMARIZE_BUDGETS (x_project_id NUMBER
97: ,x_return_status OUT NOCOPY VARCHAR2
98: ,x_err_stage OUT NOCOPY VARCHAR2) IS
99:
100: l_bem_count number ;

Line 122: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_bem_count : '||l_bem_count ,'C');

118: where budget_status_code = 'B'
119: and current_flag = 'Y'
120: and project_id = x_project_id ;
121: IF L_DEBUG = 'Y' THEN
122: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_bem_count : '||l_bem_count ,'C');
123: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_res_list_count : '||l_res_list_count ,'C');
124: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_award_count : '||l_award_count ,'C');
125: END IF;
126:

Line 123: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_res_list_count : '||l_res_list_count ,'C');

119: and current_flag = 'Y'
120: and project_id = x_project_id ;
121: IF L_DEBUG = 'Y' THEN
122: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_bem_count : '||l_bem_count ,'C');
123: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_res_list_count : '||l_res_list_count ,'C');
124: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_award_count : '||l_award_count ,'C');
125: END IF;
126:
127: G_multi_funding := 'N' ;

Line 124: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_award_count : '||l_award_count ,'C');

120: and project_id = x_project_id ;
121: IF L_DEBUG = 'Y' THEN
122: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_bem_count : '||l_bem_count ,'C');
123: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_res_list_count : '||l_res_list_count ,'C');
124: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - l_award_count : '||l_award_count ,'C');
125: END IF;
126:
127: G_multi_funding := 'N' ;
128: IF l_award_count > 1 THEN

Line 147: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.GMS_SUMMARIZE_BUDGETS - UnCategorized Profile not Defined';

143: if G_project_bem IS NOT NULL then
144: l_res_categorized := 'N' ;
145: l_validate_profile := 'Y' ;
146: else
147: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.GMS_SUMMARIZE_BUDGETS - UnCategorized Profile not Defined';
148: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_BUDGET_SUM_CHAN_UNCAT',
149: x_exec_type => 'C', -- for concurrent process
150: x_err_code => x_err_code,
151: x_err_buff => x_err_stage);

Line 210: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Setting CAT profile : ','C');

206:
207: If l_time_phased_type_code = 'R' and l_res_list_name <> 'None' then
208:
209: IF L_DEBUG = 'Y' THEN
210: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Setting CAT profile : ','C');
211: end if ;
212: G_project_bem := fnd_profile.value('GMS_PROJECT_BEM_CATEGORIZED');
213: l_res_categorized := 'Y' ;
214: l_validate_profile := 'Y' ;

Line 226: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.GMS_SUMMARIZE_BUDGETS - UnCategorized Profile not Defined';

222:
223:
224: IF l_res_categorized = 'N' and l_validate_profile = 'Y' and G_project_bem is NULL THEN
225:
226: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.GMS_SUMMARIZE_BUDGETS - UnCategorized Profile not Defined';
227: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_BUDGET_SUM_CHAN_UNCAT',
228: x_exec_type => 'C', -- for concurrent process
229: x_err_code => x_err_code,
230: x_err_buff => x_err_stage);

Line 239: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.GMS_SUMMARIZE_BUDGETS - Categorized Profile not Defined';

235: End if ;
236:
237: IF l_res_categorized = 'Y' and l_validate_profile = 'Y' and G_project_bem is NULL THEN
238:
239: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.GMS_SUMMARIZE_BUDGETS - Categorized Profile not Defined';
240: gms_error_pkg.gms_message(x_err_name => 'GMS_PROJ_BUDGET_SUM_CHANGE_CAT',
241: x_exec_type => 'C', -- for concurrent process
242: x_err_code => x_err_code,
243: x_err_buff => x_err_stage);

Line 269: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - G_pa_res_list_id : '|| G_pa_res_list_id,'C');

265: where budget_status_code = 'B'
266: and current_flag = 'Y'
267: and project_id = x_project_id ;
268: IF L_DEBUG = 'Y' THEN
269: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - G_pa_res_list_id : '|| G_pa_res_list_id,'C');
270: end if ;
271: END IF ;
272:
273: -- Get the resource_list_id from pa_resource_list defined for a BG

Line 286: end GMS_SUMMARIZE_BUDGETS;

282: and NVL(prl.migration_code ,'M') = 'M' ;
283: END if ;
284:
285:
286: end GMS_SUMMARIZE_BUDGETS;
287: -- ------------------------------------------------------------
288: Function budget_dates_overlap(x_project_id NUMBER) RETURN BOOLEAN is
289:
290: cursor get_curr_date_range_csr (p_project_id in NUMBER, p_resource_list_member_id IN NUMBER )

Line 319: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'|| 'Begin of get_other_date_range_csr','C');

315: l_award_count number ;
316: l_resource_list_member_id NUMBER ;
317: Begin
318: IF L_DEBUG = 'Y' THEN
319: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'|| 'Begin of get_other_date_range_csr','C');
320: END IF;
321:
322: select count(award_id)
323: into l_award_count

Line 332: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Project is NOT Multi Funded','C');

328:
329: if l_award_count = 1 then
330:
331: IF L_DEBUG = 'Y' THEN
332: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Project is NOT Multi Funded','C');
333: END IF;
334: return FALSE ;
335:
336: end if;

Line 339: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Project is Multi Funded','C');

335:
336: end if;
337:
338: IF L_DEBUG = 'Y' THEN
339: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Project is Multi Funded','C');
340: END IF;
341:
342: FOR other_date_range_rec IN get_other_date_range_csr ( p_project_id => x_project_id )
343: LOOP

Line 345: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....11','C');

341:
342: FOR other_date_range_rec IN get_other_date_range_csr ( p_project_id => x_project_id )
343: LOOP
344: IF L_DEBUG = 'Y' THEN
345: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....11','C');
346: END IF;
347:
348: l_resource_list_member_id := other_date_range_rec.resource_list_member_id ;
349:

Line 354: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....22','C');

350: FOR curr_date_range_rec IN get_curr_date_range_csr (p_project_id => x_project_id ,
351: p_resource_list_member_id => l_resource_list_member_id)
352: LOOP
353: IF L_DEBUG = 'Y' THEN
354: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....22','C');
355: END IF;
356:
357:
358: if (curr_date_range_rec.start_date < other_date_range_rec.start_date

Line 366: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'NO overlapping budget periods','C');

362: (curr_date_range_rec.start_date = other_date_range_rec.start_date
363: and curr_date_range_rec.end_date = other_date_range_rec.end_date) then
364:
365: IF L_DEBUG = 'Y' THEN
366: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'NO overlapping budget periods','C');
367: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');
368: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
369: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
370: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;

Line 367: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');

363: and curr_date_range_rec.end_date = other_date_range_rec.end_date) then
364:
365: IF L_DEBUG = 'Y' THEN
366: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'NO overlapping budget periods','C');
367: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');
368: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
369: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
370: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;
371: END IF;

Line 368: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');

364:
365: IF L_DEBUG = 'Y' THEN
366: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'NO overlapping budget periods','C');
367: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');
368: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
369: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
370: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;
371: END IF;
372:

Line 369: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');

365: IF L_DEBUG = 'Y' THEN
366: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'NO overlapping budget periods','C');
367: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');
368: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
369: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
370: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;
371: END IF;
372:
373: NULL; --i.e Continue with next record.

Line 370: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;

366: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'NO overlapping budget periods','C');
367: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');
368: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
369: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
370: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;
371: END IF;
372:
373: NULL; --i.e Continue with next record.
374:

Line 378: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');

374:
375:
376: ELSE -- Dates overlap
377: IF L_DEBUG = 'Y' THEN
378: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');
379: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
380: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
381: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;
382: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Budget periods overlap...','C');

Line 379: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');

375:
376: ELSE -- Dates overlap
377: IF L_DEBUG = 'Y' THEN
378: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');
379: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
380: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
381: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;
382: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Budget periods overlap...','C');
383: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....Overlap RLMI is'|| to_char(other_date_range_rec.resource_list_member_id),'C');

Line 380: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');

376: ELSE -- Dates overlap
377: IF L_DEBUG = 'Y' THEN
378: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');
379: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
380: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
381: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;
382: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Budget periods overlap...','C');
383: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....Overlap RLMI is'|| to_char(other_date_range_rec.resource_list_member_id),'C');
384: END IF;

Line 381: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;

377: IF L_DEBUG = 'Y' THEN
378: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');
379: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
380: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
381: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;
382: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Budget periods overlap...','C');
383: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....Overlap RLMI is'|| to_char(other_date_range_rec.resource_list_member_id),'C');
384: END IF;
385:

Line 382: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Budget periods overlap...','C');

378: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.start_date '||curr_date_range_rec.start_date,'C');
379: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
380: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
381: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;
382: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Budget periods overlap...','C');
383: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....Overlap RLMI is'|| to_char(other_date_range_rec.resource_list_member_id),'C');
384: END IF;
385:
386: RETURN TRUE;

Line 383: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....Overlap RLMI is'|| to_char(other_date_range_rec.resource_list_member_id),'C');

379: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..curr_date_range_rec.end_date '||curr_date_range_rec.end_date,'C');
380: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.start_date '||other_date_range_rec.start_date,'C');
381: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap..other_date_range_rec.end_date '||other_date_range_rec.end_date,'C') ;
382: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||'Budget periods overlap...','C');
383: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....Overlap RLMI is'|| to_char(other_date_range_rec.resource_list_member_id),'C');
384: END IF;
385:
386: RETURN TRUE;
387: end if ;

Line 395: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||' OUTSIDE THE LOOP','C');

391:
392: RETURN FALSE ; -- It means there is no overlapping period for any budgetlines for this project.
393:
394: IF L_DEBUG = 'Y' THEN
395: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap.....'||' OUTSIDE THE LOOP','C');
396: end if;
397: exception
398:
399: when others then

Line 401: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.exception ' || SQLCODE, 'C');

397: exception
398:
399: when others then
400:
401: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.exception ' || SQLCODE, 'C');
402: raise;
403:
404: End ;
405: -- ------------------------------------------------------------

Line 418: gms_error_pkg.gms_debug('* Start of GMS_SUMMARIZE_BUDGETS.GET_RESOURCE_LIST_ID *','C');

414: l_time_phased_type_code VARCHAR2(1);
415: BEGIN
416:
417: IF L_DEBUG = 'Y' THEN
418: gms_error_pkg.gms_debug('*** Start of GMS_SUMMARIZE_BUDGETS.GET_RESOURCE_LIST_ID ***','C');
419: END IF;
420:
421: select distinct gbv.resource_list_id -- Added distinct for Bug:2254944
422: , gbv.budget_entry_method_code , bem.time_phased_type_code -- Added time_phase_type_code for bug: 5750106

Line 434: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap... Time Phase code '|| l_time_phased_type_code,'C');

430:
431: -- Added if condition for bug : 5750106
432: If l_time_phased_type_code = 'R' then
433: IF L_DEBUG = 'Y' THEN
434: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap... Time Phase code '|| l_time_phased_type_code,'C');
435: END IF;
436: if budget_dates_overlap(x_project_id) then
437: IF L_DEBUG = 'Y' THEN
438: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap... DAtes overlap TRUE','C');

Line 438: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap... DAtes overlap TRUE','C');

434: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap... Time Phase code '|| l_time_phased_type_code,'C');
435: END IF;
436: if budget_dates_overlap(x_project_id) then
437: IF L_DEBUG = 'Y' THEN
438: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap... DAtes overlap TRUE','C');
439: END IF;
440: x_return_status := 'U'; -- Retrieve the BEM from profiles
441: else
442: IF L_DEBUG = 'Y' THEN

Line 443: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap... DAtes overlap FALSE','C');

439: END IF;
440: x_return_status := 'U'; -- Retrieve the BEM from profiles
441: else
442: IF L_DEBUG = 'Y' THEN
443: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap... DAtes overlap FALSE','C');
444: END IF;
445: x_return_status := 'S'; -- If dates don't overlap follow the old code line
446: end if;
447: else

Line 449: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap... DAtes overlap FALSE..FASLSE','C');

445: x_return_status := 'S'; -- If dates don't overlap follow the old code line
446: end if;
447: else
448: IF L_DEBUG = 'Y' THEN
449: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.Budget_dates_overlap... DAtes overlap FALSE..FASLSE','C');
450: END IF;
451: x_return_status := 'S'; -- Bug 2587078
452:
453: end if ;

Line 457: gms_error_pkg.gms_debug('* End of GMS_SUMMARIZE_BUDGETS.GET_RESOURCE_LIST_ID *','C');

453: end if ;
454:
455:
456: IF L_DEBUG = 'Y' THEN
457: gms_error_pkg.gms_debug('*** End of GMS_SUMMARIZE_BUDGETS.GET_RESOURCE_LIST_ID ***','C');
458: END IF;
459:
460: EXCEPTION
461: -- Modified below code for bug 2587078

Line 464: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.GET_RESOURCE_LIST_ID- In NO_DATA_FOUND exception';

460: EXCEPTION
461: -- Modified below code for bug 2587078
462: WHEN NO_DATA_FOUND THEN
463: x_return_status := 'E';
464: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.GET_RESOURCE_LIST_ID- In NO_DATA_FOUND exception';
465: gms_error_pkg.gms_message( x_err_name => 'GMS_RESOURCE_LIST_ID_NOT_FOUND',
466: x_err_code => x_err_code,
467: x_err_buff => x_err_stage);
468: fnd_msg_pub.add;

Line 476: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.GET_RESOURCE_LIST_ID- In others exception';

472: x_return_status := 'U';
473:
474: WHEN others THEN
475: x_return_status := 'U';
476: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.GET_RESOURCE_LIST_ID- In others exception';
477: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
478: x_token_name1 => 'SQLCODE',
479: x_token_val1 => sqlcode,
480: x_token_name2 => 'SQLERRM',

Line 502: gms_error_pkg.gms_debug('* Start of GMS_SUMMARIZE_BUDGETS.DRAFT_BUDGET_EXISTS *','C');

498: draft_budget_check NUMBER(15) := 0;
499:
500: BEGIN
501: IF L_DEBUG = 'Y' THEN
502: gms_error_pkg.gms_debug('*** Start of GMS_SUMMARIZE_BUDGETS.DRAFT_BUDGET_EXISTS ***','C');
503: END IF;
504:
505: Select 1
506: into draft_budget_check

Line 516: gms_error_pkg.gms_debug('* End of GMS_SUMMARIZE_BUDGETS.DRAFT_BUDGET_EXISTS *','C');

512: x_return_status := 'S'; -- Bug 2587078
513: RETURN TRUE;
514:
515: IF L_DEBUG = 'Y' THEN
516: gms_error_pkg.gms_debug('*** End of GMS_SUMMARIZE_BUDGETS.DRAFT_BUDGET_EXISTS ***','C');
517: END IF;
518:
519: EXCEPTION
520: -- Modified below code for bug 2587078

Line 526: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.DRAFT_BUDGET_EXISTS- In TOO_MANY_ROWS exception';

522: x_return_status := 'S';
523: RETURN FALSE;
524: WHEN TOO_MANY_ROWS THEN
525: x_return_status := 'E';
526: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.DRAFT_BUDGET_EXISTS- In TOO_MANY_ROWS exception';
527: gms_error_pkg.gms_message( x_err_name => 'GMS_DUP_DRAFT_SUB_BUDGET',
528: x_err_code => x_err_code,
529: x_err_buff => x_err_stage);
530: fnd_msg_pub.add;

Line 534: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.DRAFT_BUDGET_EXISTS- In others exception';

530: fnd_msg_pub.add;
531: RETURN FALSE;
532: WHEN OTHERS THEN
533: x_return_status := 'U';
534: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.DRAFT_BUDGET_EXISTS- In others exception';
535: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
536: x_token_name1 => 'SQLCODE',
537: x_token_val1 => sqlcode,
538: x_token_name2 => 'SQLERRM',

Line 831: gms_error_pkg.gms_debug('* Start of GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS *','C');

827: -- ---------------------------------------------------------------------------------
828: BEGIN
829:
830: IF L_DEBUG = 'Y' THEN
831: gms_error_pkg.gms_debug('*** Start of GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS ***','C');
832: END IF;
833: x_return_status := 'S'; -- Initializing return status as Success.
834:
835: -- Bug 2386041

Line 863: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.delete_draft_budget','C');

859: ,x_return_status
860: ,x_err_stage) THEN
861:
862: IF L_DEBUG = 'Y' THEN
863: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.delete_draft_budget','C');
864: END IF;
865:
866: pa_budget_pub.delete_draft_budget(p_api_version_number => 1.0
867: ,p_init_msg_list => 'T'

Line 885: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');

881: ,message_name => x_text);
882: x_err_stage := x_text;
883:
884: IF L_DEBUG = 'Y' THEN
885: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
886: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');
887: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');
888: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');
889: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');

Line 886: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');

882: x_err_stage := x_text;
883:
884: IF L_DEBUG = 'Y' THEN
885: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
886: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');
887: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');
888: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');
889: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
890: END IF;

Line 887: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');

883:
884: IF L_DEBUG = 'Y' THEN
885: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
886: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');
887: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');
888: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');
889: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
890: END IF;
891:

Line 888: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');

884: IF L_DEBUG = 'Y' THEN
885: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
886: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');
887: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');
888: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');
889: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
890: END IF;
891:
892: RAISE FND_API.G_EXC_ERROR;

Line 889: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');

885: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
886: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');
887: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');
888: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');
889: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
890: END IF;
891:
892: RAISE FND_API.G_EXC_ERROR;
893:

Line 903: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling get_resource_list_id','C');

899: END IF;
900: END IF;
901:
902: IF L_DEBUG = 'Y' THEN
903: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling get_resource_list_id','C');
904: END IF;
905:
906: get_resource_list_id (x_project_id
907: ,x_entry_method_code

Line 918: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS-x_return_status is U', 'C');

914: -- Added for GMS enhancements : 5583170
915: -- ------------------------------------
916: If x_return_status = 'U' then
917: IF L_DEBUG = 'Y' THEN
918: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS-x_return_status is U', 'C');
919: END IF;
920:
921: GMS_SUMMARIZE_BUDGETS (x_project_id
922: ,x_return_status

Line 921: GMS_SUMMARIZE_BUDGETS (x_project_id

917: IF L_DEBUG = 'Y' THEN
918: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS-x_return_status is U', 'C');
919: END IF;
920:
921: GMS_SUMMARIZE_BUDGETS (x_project_id
922: ,x_return_status
923: ,x_err_stage ) ;
924: x_resource_list_id := NVL(G_pa_res_list_id,G_pa_res_list_id_none) ;
925:

Line 928: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - G_project_bem : '||G_project_bem ,'C');

924: x_resource_list_id := NVL(G_pa_res_list_id,G_pa_res_list_id_none) ;
925:
926:
927: IF L_DEBUG = 'Y' THEN
928: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - G_project_bem : '||G_project_bem ,'C');
929: END IF;
930:
931: IF L_DEBUG = 'Y' THEN
932: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_return_status : '||x_return_status ,'C');

Line 932: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_return_status : '||x_return_status ,'C');

928: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - G_project_bem : '||G_project_bem ,'C');
929: END IF;
930:
931: IF L_DEBUG = 'Y' THEN
932: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_return_status : '||x_return_status ,'C');
933: END IF;
934: end if ;
935:
936: -- We should not proceed further as G_project_bem IS NULL ( when profiles are unset and different BEM are used )

Line 949: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_time_phased_type_code : '||x_time_phased_type_code,'C');

945: end if ;
946:
947: If G_project_bem IS NULL and x_resource_list_id IS NOT NULL then -- Added for GMS enhancements
948: IF L_DEBUG = 'Y' THEN
949: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_time_phased_type_code : '||x_time_phased_type_code,'C');
950: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Start of date calculation logic','C');
951: END IF;
952:
953: i := 0;

Line 950: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Start of date calculation logic','C');

946:
947: If G_project_bem IS NULL and x_resource_list_id IS NOT NULL then -- Added for GMS enhancements
948: IF L_DEBUG = 'Y' THEN
949: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_time_phased_type_code : '||x_time_phased_type_code,'C');
950: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Start of date calculation logic','C');
951: END IF;
952:
953: i := 0;
954:

Line 1062: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Error occurred while fetching dates';

1058: WHERE task_id = rec_c3.task_id;
1059:
1060: /* if x_project_start_date is NULL or x_project_end_date is NULL then Changed for bug 3372853 */
1061: if x_task_start_date is NULL or x_task_end_date is NULL then
1062: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Error occurred while fetching dates';
1063: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE',
1064: x_err_code => x_err_code,
1065: x_err_buff => x_err_stage);
1066: fnd_msg_pub.add; -- Bug 2587078

Line 1111: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - End of date calculation logic','C');

1107:
1108: End if ;
1109:
1110: IF L_DEBUG = 'Y' THEN
1111: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - End of date calculation logic','C');
1112: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.create_draft_budget','C');
1113: END IF;
1114:
1115: --Call budget API to create draft budget

Line 1112: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.create_draft_budget','C');

1108: End if ;
1109:
1110: IF L_DEBUG = 'Y' THEN
1111: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - End of date calculation logic','C');
1112: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.create_draft_budget','C');
1113: END IF;
1114:
1115: --Call budget API to create draft budget
1116:

Line 1152: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');

1148: ,message_name => x_text);
1149: x_err_stage := x_text;
1150:
1151: IF L_DEBUG = 'Y' THEN
1152: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1153: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');
1154: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');
1155: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');
1156: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');

Line 1153: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');

1149: x_err_stage := x_text;
1150:
1151: IF L_DEBUG = 'Y' THEN
1152: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1153: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');
1154: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');
1155: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');
1156: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1157: END IF;

Line 1154: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');

1150:
1151: IF L_DEBUG = 'Y' THEN
1152: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1153: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');
1154: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');
1155: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');
1156: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1157: END IF;
1158:

Line 1155: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');

1151: IF L_DEBUG = 'Y' THEN
1152: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1153: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');
1154: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');
1155: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');
1156: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1157: END IF;
1158:
1159: RAISE FND_API.G_EXC_ERROR;

Line 1156: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');

1152: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1153: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');
1154: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');
1155: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');
1156: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1157: END IF;
1158:
1159: RAISE FND_API.G_EXC_ERROR;
1160:

Line 1167: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.baseline_budget','C');

1163: -- Call PA's Budget API to Baseline this budget since the Project Budget should
1164: -- automatically be baselined when the Award Budget is baselined.
1165:
1166: IF L_DEBUG = 'Y' THEN
1167: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.baseline_budget','C');
1168: END IF;
1169:
1170: pa_budget_pub.baseline_budget( p_api_version_number => 1.0,
1171: p_init_msg_list => 'T',

Line 1182: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');

1178: p_pm_project_reference => NULL,
1179: p_budget_type_code => 'AC');
1180:
1181: IF L_DEBUG = 'Y' THEN
1182: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1183: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1184: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1185: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1186: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');

Line 1183: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');

1179: p_budget_type_code => 'AC');
1180:
1181: IF L_DEBUG = 'Y' THEN
1182: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1183: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1184: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1185: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1186: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1187: END IF;

Line 1184: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');

1180:
1181: IF L_DEBUG = 'Y' THEN
1182: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1183: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1184: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1185: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1186: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1187: END IF;
1188: RETCODE := x_return_status ; -- Added for GMS enhancement for R12 : 5583170

Line 1185: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');

1181: IF L_DEBUG = 'Y' THEN
1182: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1183: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1184: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1185: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1186: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1187: END IF;
1188: RETCODE := x_return_status ; -- Added for GMS enhancement for R12 : 5583170
1189:

Line 1186: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');

1182: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1183: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1184: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1185: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1186: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1187: END IF;
1188: RETCODE := x_return_status ; -- Added for GMS enhancement for R12 : 5583170
1189:
1190: IF x_return_status <>'S' THEN

Line 1200: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');

1196: ,message_name => x_text);
1197: x_err_stage := x_text;
1198:
1199: IF L_DEBUG = 'Y' THEN
1200: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1201: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1202: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1203: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1204: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');

Line 1201: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');

1197: x_err_stage := x_text;
1198:
1199: IF L_DEBUG = 'Y' THEN
1200: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1201: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1202: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1203: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1204: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1205: END IF;

Line 1202: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');

1198:
1199: IF L_DEBUG = 'Y' THEN
1200: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1201: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1202: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1203: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1204: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1205: END IF;
1206:

Line 1203: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');

1199: IF L_DEBUG = 'Y' THEN
1200: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1201: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1202: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1203: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1204: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1205: END IF;
1206:
1207: RAISE FND_API.G_EXC_ERROR;

Line 1204: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');

1200: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1201: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1202: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1203: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1204: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1205: END IF;
1206:
1207: RAISE FND_API.G_EXC_ERROR;
1208:

Line 1212: gms_error_pkg.gms_debug('* End of GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION *','C');

1208:
1209: END IF;
1210:
1211: IF L_DEBUG = 'Y' THEN
1212: gms_error_pkg.gms_debug('*** End of GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION ***','C');
1213: END IF;
1214:
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN

Line 1218: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION - In FND_API.G_EXC_ERROR exception','C');

1214:
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: IF L_DEBUG = 'Y' THEN
1218: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION - In FND_API.G_EXC_ERROR exception','C');
1219: END IF;
1220: RETCODE := x_return_status;
1221: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_return_status ----- : '|| x_return_status,'C');
1222: ERRBUF := x_err_stage;

Line 1221: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_return_status ----- : '|| x_return_status,'C');

1217: IF L_DEBUG = 'Y' THEN
1218: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION - In FND_API.G_EXC_ERROR exception','C');
1219: END IF;
1220: RETCODE := x_return_status;
1221: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_return_status ----- : '|| x_return_status,'C');
1222: ERRBUF := x_err_stage;
1223:
1224: when OTHERS THEN
1225: IF L_DEBUG = 'Y' THEN

Line 1226: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION - In when Others exception','C');

1222: ERRBUF := x_err_stage;
1223:
1224: when OTHERS THEN
1225: IF L_DEBUG = 'Y' THEN
1226: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION - In when Others exception','C');
1227: END IF;
1228: RETCODE := 'U';
1229: ERRBUF := (SQLERRM||' '||SQLCODE);
1230: END summarize_baselined_versions;

Line 1232: END GMS_SUMMARIZE_BUDGETS;

1228: RETCODE := 'U';
1229: ERRBUF := (SQLERRM||' '||SQLCODE);
1230: END summarize_baselined_versions;
1231:
1232: END GMS_SUMMARIZE_BUDGETS;