DBA Data[Home] [Help]

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.6 2011/11/04 05:50:21 mokukuma 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 900: gms_error_pkg.gms_debug('*** Start of GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS ***','C');

896: -- ---------------------------------------------------------------------------------
897: BEGIN
898:
899: IF L_DEBUG = 'Y' THEN
900: gms_error_pkg.gms_debug('*** Start of GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS ***','C');
901: END IF;
902: x_return_status := 'S'; -- Initializing return status as Success.
903:
904: -- Bug 2386041

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

978: ,x_return_status
979: ,x_err_stage) THEN
980:
981: IF L_DEBUG = 'Y' THEN
982: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.delete_draft_budget','C');
983: END IF;
984:
985: pa_budget_pub.delete_draft_budget(p_api_version_number => 1.0
986: ,p_init_msg_list => 'T'

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

1000: ,message_name => x_text);
1001: x_err_stage := x_text;
1002:
1003: IF L_DEBUG = 'Y' THEN
1004: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
1005: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');
1006: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');
1007: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');
1008: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');

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

1001: x_err_stage := x_text;
1002:
1003: IF L_DEBUG = 'Y' THEN
1004: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
1005: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');
1006: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');
1007: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');
1008: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
1009: END IF;

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

1002:
1003: IF L_DEBUG = 'Y' THEN
1004: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
1005: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');
1006: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');
1007: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');
1008: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
1009: END IF;
1010:

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

1003: IF L_DEBUG = 'Y' THEN
1004: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
1005: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');
1006: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');
1007: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');
1008: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
1009: END IF;
1010:
1011: RAISE FND_API.G_EXC_ERROR;

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

1004: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
1005: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_return_status = '||x_return_status,'C');
1006: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_err_stage = '||x_err_stage,'C');
1007: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; x_msg_count = '||x_msg_count,'C');
1008: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after delete draft; **************************','C');
1009: END IF;
1010:
1011: RAISE FND_API.G_EXC_ERROR;
1012:

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

1018: END IF;
1019: END IF;
1020:
1021: IF L_DEBUG = 'Y' THEN
1022: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling get_resource_list_id','C');
1023: END IF;
1024:
1025: get_resource_list_id (x_project_id
1026: ,x_entry_method_code

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

1033: -- Added for GMS enhancements : 5583170
1034: -- ------------------------------------
1035: If x_return_status = 'U' then
1036: IF L_DEBUG = 'Y' THEN
1037: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS-x_return_status is U', 'C');
1038: END IF;
1039:
1040: GMS_SUMMARIZE_BUDGETS (x_project_id
1041: ,x_return_status

Line 1040: GMS_SUMMARIZE_BUDGETS (x_project_id

1036: IF L_DEBUG = 'Y' THEN
1037: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS-x_return_status is U', 'C');
1038: END IF;
1039:
1040: GMS_SUMMARIZE_BUDGETS (x_project_id
1041: ,x_return_status
1042: ,x_err_stage ) ;
1043: x_resource_list_id := NVL(G_pa_res_list_id,G_pa_res_list_id_none) ;
1044:

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

1043: x_resource_list_id := NVL(G_pa_res_list_id,G_pa_res_list_id_none) ;
1044:
1045:
1046: IF L_DEBUG = 'Y' THEN
1047: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - G_project_bem : '||G_project_bem ,'C');
1048: END IF;
1049:
1050: IF L_DEBUG = 'Y' THEN
1051: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_return_status : '||x_return_status ,'C');

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

1047: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - G_project_bem : '||G_project_bem ,'C');
1048: END IF;
1049:
1050: IF L_DEBUG = 'Y' THEN
1051: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_return_status : '||x_return_status ,'C');
1052: END IF;
1053: end if ;
1054:
1055: -- We should not proceed further as G_project_bem IS NULL ( when profiles are unset and different BEM are used )

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

1064: end if ;
1065:
1066: If G_project_bem IS NULL and x_resource_list_id IS NOT NULL then -- Added for GMS enhancements
1067: IF L_DEBUG = 'Y' THEN
1068: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_time_phased_type_code : '||x_time_phased_type_code,'C');
1069: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Start of date calculation logic','C');
1070: END IF;
1071:
1072: i := 0;

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

1065:
1066: If G_project_bem IS NULL and x_resource_list_id IS NOT NULL then -- Added for GMS enhancements
1067: IF L_DEBUG = 'Y' THEN
1068: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_time_phased_type_code : '||x_time_phased_type_code,'C');
1069: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Start of date calculation logic','C');
1070: END IF;
1071:
1072: i := 0;
1073:

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

1177: WHERE task_id = rec_c3.task_id;
1178:
1179: /* if x_project_start_date is NULL or x_project_end_date is NULL then Changed for bug 3372853 */
1180: if x_task_start_date is NULL or x_task_end_date is NULL then
1181: x_err_stage := 'GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Error occurred while fetching dates';
1182: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE',
1183: x_err_code => x_err_code,
1184: x_err_buff => x_err_stage);
1185: fnd_msg_pub.add; -- Bug 2587078

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

1226:
1227: End if ;
1228:
1229: IF L_DEBUG = 'Y' THEN
1230: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - End of date calculation logic','C');
1231: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.create_draft_budget','C');
1232: END IF;
1233:
1234: --Call budget API to create draft budget

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

1227: End if ;
1228:
1229: IF L_DEBUG = 'Y' THEN
1230: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - End of date calculation logic','C');
1231: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.create_draft_budget','C');
1232: END IF;
1233:
1234: --Call budget API to create draft budget
1235:

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

1307: ,message_name => x_text);
1308: x_err_stage := x_text;
1309:
1310: IF L_DEBUG = 'Y' THEN
1311: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1312: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');
1313: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');
1314: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');
1315: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');

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

1308: x_err_stage := x_text;
1309:
1310: IF L_DEBUG = 'Y' THEN
1311: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1312: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');
1313: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');
1314: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');
1315: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1316: END IF;

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

1309:
1310: IF L_DEBUG = 'Y' THEN
1311: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1312: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');
1313: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');
1314: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');
1315: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1316: END IF;
1317:

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

1310: IF L_DEBUG = 'Y' THEN
1311: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1312: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');
1313: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');
1314: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');
1315: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1316: END IF;
1317:
1318: RAISE FND_API.G_EXC_ERROR;

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

1311: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1312: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_return_status = '||x_return_status,'C');
1313: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_msg_count = '||x_msg_count,'C');
1314: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; x_err_stage = '||x_err_stage,'C');
1315: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after create draft; ************************','C');
1316: END IF;
1317:
1318: RAISE FND_API.G_EXC_ERROR;
1319:

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

1322: -- Call PA's Budget API to Baseline this budget since the Project Budget should
1323: -- automatically be baselined when the Award Budget is baselined.
1324:
1325: IF L_DEBUG = 'Y' THEN
1326: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - Calling pa_budget_pub.baseline_budget','C');
1327: END IF;
1328:
1329: pa_budget_pub.baseline_budget( p_api_version_number => 1.0,
1330: p_init_msg_list => 'T',

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

1337: p_pm_project_reference => NULL,
1338: p_budget_type_code => 'AC');
1339:
1340: IF L_DEBUG = 'Y' THEN
1341: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1342: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1343: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1344: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1345: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');

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

1338: p_budget_type_code => 'AC');
1339:
1340: IF L_DEBUG = 'Y' THEN
1341: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1342: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1343: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1344: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1345: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1346: END IF;

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

1339:
1340: IF L_DEBUG = 'Y' THEN
1341: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1342: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1343: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1344: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1345: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1346: END IF;
1347: RETCODE := x_return_status ; -- Added for GMS enhancement for R12 : 5583170

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

1340: IF L_DEBUG = 'Y' THEN
1341: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1342: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1343: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1344: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1345: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1346: END IF;
1347: RETCODE := x_return_status ; -- Added for GMS enhancement for R12 : 5583170
1348:

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

1341: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1342: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1343: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1344: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1345: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1346: END IF;
1347: RETCODE := x_return_status ; -- Added for GMS enhancement for R12 : 5583170
1348:
1349: IF x_return_status <>'S' THEN

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

1355: ,message_name => x_text);
1356: x_err_stage := x_text;
1357:
1358: IF L_DEBUG = 'Y' THEN
1359: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1360: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1361: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1362: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1363: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');

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

1356: x_err_stage := x_text;
1357:
1358: IF L_DEBUG = 'Y' THEN
1359: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1360: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1361: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1362: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1363: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1364: END IF;

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

1357:
1358: IF L_DEBUG = 'Y' THEN
1359: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1360: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1361: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1362: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1363: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1364: END IF;
1365:

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

1358: IF L_DEBUG = 'Y' THEN
1359: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1360: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1361: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1362: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1363: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1364: END IF;
1365:
1366: RAISE FND_API.G_EXC_ERROR;

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

1359: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1360: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_return_status = '||x_return_status,'C');
1361: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_msg_count = '||x_msg_count,'C');
1362: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; x_err_stage = '||x_err_stage,'C');
1363: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - after baseline budget; ************************','C');
1364: END IF;
1365:
1366: RAISE FND_API.G_EXC_ERROR;
1367:

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

1367:
1368: END IF;
1369:
1370: IF L_DEBUG = 'Y' THEN
1371: gms_error_pkg.gms_debug('*** End of GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION ***','C');
1372: END IF;
1373:
1374: /* bug 8214030: resetting the profile values back */
1375: if (l_set_profile_success1 = TRUE) then

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

1381:
1382: EXCEPTION
1383: WHEN FND_API.G_EXC_ERROR THEN
1384: IF L_DEBUG = 'Y' THEN
1385: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION - In FND_API.G_EXC_ERROR exception','C');
1386: END IF;
1387: RETCODE := x_return_status;
1388: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_return_status ----- : '|| x_return_status,'C');
1389: ERRBUF := x_err_stage;

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

1384: IF L_DEBUG = 'Y' THEN
1385: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION - In FND_API.G_EXC_ERROR exception','C');
1386: END IF;
1387: RETCODE := x_return_status;
1388: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSIONS - x_return_status ----- : '|| x_return_status,'C');
1389: ERRBUF := x_err_stage;
1390: /* bug 8214030: resetting the profile values back */
1391: if (l_set_profile_success1 = TRUE) then
1392: l_set_profile_success1 := fnd_profile.save('PA_SUPER_PROJECT', l_user_profile_value1, 'USER', fnd_global.user_id);

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

1395: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', l_user_profile_value2, 'USER', fnd_global.user_id);
1396: end if;
1397: when OTHERS THEN
1398: IF L_DEBUG = 'Y' THEN
1399: gms_error_pkg.gms_debug('GMS_SUMMARIZE_BUDGETS.SUMMARIZE_BASELINED_VERSION - In when Others exception','C');
1400: END IF;
1401: RETCODE := 'U';
1402: ERRBUF := (SQLERRM||' '||SQLCODE);
1403: /* bug 8214030: resetting the profile values back */

Line 1412: END GMS_SUMMARIZE_BUDGETS;

1408: l_set_profile_success2 := fnd_profile.save('PA_SUPER_PROJECT_VIEW', l_user_profile_value2, 'USER', fnd_global.user_id);
1409: end if;
1410: END summarize_baselined_versions;
1411:
1412: END GMS_SUMMARIZE_BUDGETS;