DBA Data[Home] [Help]

APPS.GMS_BUDGET_CORE dependencies on GMS_ERROR_PKG

Line 49: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',

45: where period_type_code= x_period_type
46: and period_start_date > x_start_period_date;
47:
48: if number_period < abs(x_periods) then
49: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',
50: x_err_code => x_err_code,
51: x_err_buff => x_err_stage);
52:
53: APP_EXCEPTION.RAISE_EXCEPTION;

Line 72: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',

68: where period_type_code= x_period_type
69: and period_start_date < x_start_period_date;
70:
71: if number_period < abs(x_periods) then
72: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',
73: x_err_code => x_err_code,
74: x_err_buff => x_err_stage);
75:
76: APP_EXCEPTION.RAISE_EXCEPTION;

Line 153: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',

149: end if;
150: end loop;
151:
152: if number_period < x_periods then
153: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',
154: x_err_code => x_err_code,
155: x_err_buff => x_err_stage);
156:
157: APP_EXCEPTION.RAISE_EXCEPTION;

Line 182: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',

178: end if;
179: end loop;
180:
181: if number_period < abs(x_periods) then
182: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',
183: x_err_code => x_err_code,
184: x_err_buff => x_err_stage);
185:
186: APP_EXCEPTION.RAISE_EXCEPTION;

Line 210: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',

206:
207: exception
208: when NO_DATA_FOUND
209: then
210: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',
211: x_err_code => x_err_code,
212: x_err_buff => x_err_stage);
213:
214:

Line 216: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

212: x_err_buff => x_err_stage);
213:
214:
215: when OTHERS then
216: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
217: x_token_name1 => 'SQLCODE',
218: x_token_val1 => sqlcode,
219: x_token_name2 => 'SQLERRM',
220: x_token_val2 => sqlerrm,

Line 321: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',

317:
318: exception
319: when NO_DATA_FOUND
320: then
321: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_NEW_PERIOD',
322: x_err_code => x_err_code,
323: x_err_buff => x_err_stage);
324:
325: when OTHERS

Line 327: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',

323: x_err_buff => x_err_stage);
324:
325: when OTHERS
326: then
327: gms_error_pkg.gms_message( x_err_name => 'GMS_UNEXPECTED_ERROR',
328: x_token_name1 => 'SQLCODE',
329: x_token_val1 => sqlcode,
330: x_token_name2 => 'SQLERRM',
331: x_token_val2 => sqlerrm,

Line 383: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_CORE.BASELINE ***','C');

379:
380: BEGIN
381:
382: IF L_DEBUG = 'Y' THEN
383: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_CORE.BASELINE ***','C');
384: END IF;
385:
386: savepoint before_baseline;
387:

Line 403: gms_error_pkg.gms_message( x_err_name => 'GMS_ALL_WARN_NO_EMPL_REC',

399: v_emp_id := PA_UTILS.GetEmpIdFromUser(x_created_by );
400:
401: if v_emp_id IS NULL then
402: x_err_stage := 'GMS_BUDGET_CORE.BASELINE - Error occurred while validating employee information';
403: gms_error_pkg.gms_message( x_err_name => 'GMS_ALL_WARN_NO_EMPL_REC',
404: x_err_code => x_err_code,
405: x_err_buff => x_err_stage);
406:
407: fnd_msg_pub.add; --Bug 2587078

Line 438: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling GMS_BUDGET_UTILS.Verify_Budget_Rules - Baseline','C');

434: IF ( x_verify_budget_rules = 'Y' )
435: THEN
436:
437: IF L_DEBUG = 'Y' THEN
438: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling GMS_BUDGET_UTILS.Verify_Budget_Rules - Baseline','C');
439: END IF;
440:
441: GMS_BUDGET_UTILS.Verify_Budget_Rules
442: (p_draft_version_id => x_draft_version_id

Line 467: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_BUDGET_FAIL_B',

463: IF (x_err_code <> 0)
464: THEN
465: IF (l_warnings_only_flag = 'N') THEN
466: x_err_stage := 'GMS_BUDGET_CORE.BASELINE - Error occurred while validating Budget';
467: gms_error_pkg.gms_message(x_err_name => 'GMS_VERIFY_BUDGET_FAIL_B',
468: x_err_code => x_err_code,
469: x_err_buff => x_err_stage);
470: fnd_msg_pub.add;
471: RETURN;

Line 480: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling GMS_BUDGET_UTILS.get_baselined_version_id','C');

476: -- End R11 rewrite
477: -- ----------------------------------------------------------------------------------
478:
479: IF L_DEBUG = 'Y' THEN
480: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling GMS_BUDGET_UTILS.get_baselined_version_id','C');
481: END IF;
482:
483: GMS_BUDGET_UTILS.get_baselined_version_id(x_project_id,
484: x_award_id,

Line 493: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to GMS_BUDGET_UTILS.get_baselined_version_id returned x_err_code : '||x_err_code ,'C');

489: x_err_stack);
490:
491: if (x_err_code < 0) then
492: IF L_DEBUG = 'Y' THEN
493: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to GMS_BUDGET_UTILS.get_baselined_version_id returned x_err_code : '||x_err_code ,'C');
494: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to GMS_BUDGET_UTILS.get_baselined_version_id returned x_err_stage : '||x_err_stage ,'C');
495: END IF;
496:
497: rollback to before_baseline;

Line 494: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to GMS_BUDGET_UTILS.get_baselined_version_id returned x_err_stage : '||x_err_stage ,'C');

490:
491: if (x_err_code < 0) then
492: IF L_DEBUG = 'Y' THEN
493: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to GMS_BUDGET_UTILS.get_baselined_version_id returned x_err_code : '||x_err_code ,'C');
494: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to GMS_BUDGET_UTILS.get_baselined_version_id returned x_err_stage : '||x_err_stage ,'C');
495: END IF;
496:
497: rollback to before_baseline;
498: return;

Line 505: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- First time baselining','C');

501:
502: -- baseline budget does not exist
503:
504: IF L_DEBUG = 'Y' THEN
505: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- First time baselining','C');
506: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling pa_res_list_assignments.create_rl_assgmt','C');
507: END IF;
508:
509: x_err_stage := 'create resource list assignment <'

Line 506: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling pa_res_list_assignments.create_rl_assgmt','C');

502: -- baseline budget does not exist
503:
504: IF L_DEBUG = 'Y' THEN
505: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- First time baselining','C');
506: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling pa_res_list_assignments.create_rl_assgmt','C');
507: END IF;
508:
509: x_err_stage := 'create resource list assignment <'
510: || to_char(x_project_id) || '><'

Line 524: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_assgmt returned x_err_code : '||x_err_code ,'C');

520:
521: -- if oracle or application error, return
522: if (x_err_code <> 0) then
523: IF L_DEBUG = 'Y' THEN
524: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_assgmt returned x_err_code : '||x_err_code ,'C');
525: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_assgmt returned x_err_stage : '||x_err_stage ,'C');
526: END IF;
527: rollback to before_baseline;
528: return;

Line 525: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_assgmt returned x_err_stage : '||x_err_stage ,'C');

521: -- if oracle or application error, return
522: if (x_err_code <> 0) then
523: IF L_DEBUG = 'Y' THEN
524: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_assgmt returned x_err_code : '||x_err_code ,'C');
525: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_assgmt returned x_err_stage : '||x_err_stage ,'C');
526: END IF;
527: rollback to before_baseline;
528: return;
529: end if;

Line 539: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling pa_res_list_assignments.create_rl_uses','C');

535:
536: -- create resource list usage if necessary
537:
538: IF L_DEBUG = 'Y' THEN
539: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling pa_res_list_assignments.create_rl_uses','C');
540: END IF;
541:
542: pa_res_list_assignments.create_rl_uses(x_project_id,
543: x_resource_list_assgmt_id,

Line 553: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_uses returned x_err_code :'||x_err_code ,'C');

549: -- if oracle or application error, return.
550:
551: if (x_err_code <> 0) then
552: IF L_DEBUG = 'Y' THEN
553: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_uses returned x_err_code :'||x_err_code ,'C');
554: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_uses returned x_err_stage :'||x_err_stage ,'C');
555: END IF;
556: rollback to before_baseline;
557: return;

Line 554: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_uses returned x_err_stage :'||x_err_stage ,'C');

550:
551: if (x_err_code <> 0) then
552: IF L_DEBUG = 'Y' THEN
553: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_uses returned x_err_code :'||x_err_code ,'C');
554: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to pa_res_list_assignments.create_rl_uses returned x_err_stage :'||x_err_stage ,'C');
555: END IF;
556: rollback to before_baseline;
557: return;
558: end if;

Line 567: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- x_mark_as_original : '||x_mark_as_original ,'C');

563: || x_budget_type_code || '>';
564:
565:
566: IF L_DEBUG = 'Y' THEN
567: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- x_mark_as_original : '||x_mark_as_original ,'C');
568: END IF;
569:
570: if (x_mark_as_original = 'Y') then
571:

Line 594: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Updating current_flag to an intermediate status R','C');

590: -- at the end of Baseline process.
591: -------------------------------------------------------------------------------------------
592:
593: IF L_DEBUG = 'Y' THEN
594: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Updating current_flag to an intermediate status R','C');
595: END IF;
596:
597: update gms_budget_versions
598: set current_flag = 'R',

Line 630: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Inserting records into gms_budget_versions','C');

626: || '><' || to_char(max_version)
627: || '><' || to_char(x_created_by) || '>';
628:
629: IF L_DEBUG = 'Y' THEN
630: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Inserting records into gms_budget_versions','C');
631: END IF;
632:
633: insert into gms_budget_versions(
634: budget_version_id,

Line 738: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_core.copy_draft_lines','C');

734: || '><' || to_char(x_dest_version_id)
735: || '>';
736:
737: IF L_DEBUG = 'Y' THEN
738: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_core.copy_draft_lines','C');
739: END IF;
740:
741: gms_budget_core.copy_draft_lines(x_src_version_id => x_draft_version_id,
742: x_time_phased_type_code => x_time_phased_type_code,

Line 753: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to gms_budget_core.copy_draft_lines returned x_err_code : '||x_err_code ,'C');

749:
750:
751: if (x_err_code <> 0) then
752: IF L_DEBUG = 'Y' THEN
753: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to gms_budget_core.copy_draft_lines returned x_err_code : '||x_err_code ,'C');
754: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to gms_budget_core.copy_draft_lines returned x_err_stage : '||x_err_stage ,'C');
755: END IF;
756: rollback to before_baseline;
757: return;

Line 754: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to gms_budget_core.copy_draft_lines returned x_err_stage : '||x_err_stage ,'C');

750:
751: if (x_err_code <> 0) then
752: IF L_DEBUG = 'Y' THEN
753: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to gms_budget_core.copy_draft_lines returned x_err_code : '||x_err_code ,'C');
754: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to gms_budget_core.copy_draft_lines returned x_err_stage : '||x_err_stage ,'C');
755: END IF;
756: rollback to before_baseline;
757: return;
758: end if;

Line 768: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- x_time_phased_type_code : '||x_time_phased_type_code,'C');

764: -- Begin Bug 2404567
765: -- gp_msg('TIME:'||x_time_phased_type_code||':ENTRY:'||x_entry_level_code);
766:
767: IF L_DEBUG = 'Y' THEN
768: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- x_time_phased_type_code : '||x_time_phased_type_code,'C');
769: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- x_entry_level_code : '||x_entry_level_code,'C');
770: END IF;
771:
772: if (x_time_phased_type_code = 'N')

Line 769: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- x_entry_level_code : '||x_entry_level_code,'C');

765: -- gp_msg('TIME:'||x_time_phased_type_code||':ENTRY:'||x_entry_level_code);
766:
767: IF L_DEBUG = 'Y' THEN
768: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- x_time_phased_type_code : '||x_time_phased_type_code,'C');
769: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- x_entry_level_code : '||x_entry_level_code,'C');
770: END IF;
771:
772: if (x_time_phased_type_code = 'N')
773: and (x_entry_level_code = 'P') then -- Project Level

Line 778: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_utils.get_valid_period_dates','C');

774:
775: -- Added call to GMS_BUDGET_UTILS.get_valid_period_dates() for Bug:2592747
776:
777: IF L_DEBUG = 'Y' THEN
778: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_utils.get_valid_period_dates','C');
779: END IF;
780:
781: gms_budget_utils.get_valid_period_dates(
782: x_err_code => x_err_code,

Line 798: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Updating dates on gms_budget_lines','C');

794: p_budget_end_date_out => v_project_completion_date);
795:
796:
797: IF L_DEBUG = 'Y' THEN
798: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Updating dates on gms_budget_lines','C');
799: END IF;
800:
801: -- update for baselined version
802: update gms_budget_lines

Line 833: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_utils.get_valid_period_dates','C');

829: from pa_projects_all
830: where project_id = x_project_id;
831:
832: IF L_DEBUG = 'Y' THEN
833: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_utils.get_valid_period_dates','C');
834: END IF;
835:
836: for b1_rec in (select t.task_id, resource_assignment_id
837: from pa_tasks t , gms_resource_assignments r

Line 860: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE',

856: p_budget_end_date_out => x_budget_end_date);
857:
858: if x_err_code <> 0 then
859:
860: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE',
861: x_err_code => x_err_code,
862: x_err_buff => x_err_stage);
863: fnd_msg_pub.add; --Bug 2587078
864: APP_EXCEPTION.RAISE_EXCEPTION;

Line 877: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_utils.get_valid_period_dates for draft version','C');

873:
874: end loop;
875:
876: IF L_DEBUG = 'Y' THEN
877: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_utils.get_valid_period_dates for draft version','C');
878: END IF;
879:
880: --following loop is for draft version
881: for b2_rec in (select t.task_id, resource_assignment_id

Line 905: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE',

901: p_budget_end_date_out => x_budget_end_date);
902:
903: if x_err_code <> 0 then
904:
905: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_NO_TASK_PROJ_DATE',
906: x_err_code => x_err_code,
907: x_err_buff => x_err_stage);
908: fnd_msg_pub.add; --Bug 2587078
909: APP_EXCEPTION.RAISE_EXCEPTION;

Line 934: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling fnd_attached_documents2_pkg.copy_attachments','C');

930:
931: -- End Bug 2404567
932:
933: IF L_DEBUG = 'Y' THEN
934: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling fnd_attached_documents2_pkg.copy_attachments','C');
935: END IF;
936:
937: -- Copy attachments for every draft budget copied
938:

Line 951: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_pub.summerize_project_totals','C');

947: 275, null, null) ;
948: -- End copying attachments
949:
950: IF L_DEBUG = 'Y' THEN
951: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Calling gms_budget_pub.summerize_project_totals','C');
952: END IF;
953:
954: gms_budget_pub.summerize_project_totals(x_dest_version_id,
955: x_err_code,

Line 960: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to gms_budget_pub.summerize_project_totals returned failed status','C');

956: x_err_stage,
957: x_err_stack);
958: if (x_err_code <> 0) then
959: IF L_DEBUG = 'Y' THEN
960: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to gms_budget_pub.summerize_project_totals returned failed status','C');
961: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Value of x_err_code '||x_err_code,'C');
962: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Value of x_err_stage '||x_err_stage,'C');
963: END IF;
964: rollback to before_baseline;

Line 961: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Value of x_err_code '||x_err_code,'C');

957: x_err_stack);
958: if (x_err_code <> 0) then
959: IF L_DEBUG = 'Y' THEN
960: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to gms_budget_pub.summerize_project_totals returned failed status','C');
961: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Value of x_err_code '||x_err_code,'C');
962: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Value of x_err_stage '||x_err_stage,'C');
963: END IF;
964: rollback to before_baseline;
965: return;

Line 962: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Value of x_err_stage '||x_err_stage,'C');

958: if (x_err_code <> 0) then
959: IF L_DEBUG = 'Y' THEN
960: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Call to gms_budget_pub.summerize_project_totals returned failed status','C');
961: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Value of x_err_code '||x_err_code,'C');
962: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- Value of x_err_stage '||x_err_stage,'C');
963: END IF;
964: rollback to before_baseline;
965: return;
966: end if;

Line 971: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_CORE.BASELINE ***','C');

967:
968: x_err_stack := old_stack;
969:
970: IF L_DEBUG = 'Y' THEN
971: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_CORE.BASELINE ***','C');
972: END IF;
973:
974: exception
975: when OTHERS

Line 978: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- In when others exception','C');

974: exception
975: when OTHERS
976: then
977: IF L_DEBUG = 'Y' THEN
978: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.BASELINE- In when others exception','C');
979: END IF;
980: rollback to before_baseline;
981:
982: -- x_err_code := SQLCODE;

Line 1073: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_BASE_RES_LIST_EXISTS',

1069: where budget_version_id = x_baselined_version_id;
1070:
1071: if (x_src_resource_list_id <> x_baselined_resource_list_id) then
1072:
1073: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_BASE_RES_LIST_EXISTS',
1074: x_err_code => x_err_code,
1075: x_err_buff => x_err_stage);
1076:
1077: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1120: gms_error_pkg.gms_message( x_err_name => 'GMS_DELETE_DRAFT_FAILED',

1116:
1117: end if;
1118:
1119: if (x_err_code < 0) then
1120: gms_error_pkg.gms_message( x_err_name => 'GMS_DELETE_DRAFT_FAILED',
1121: x_err_code => x_err_code,
1122: x_err_buff => x_err_stage);
1123:
1124: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1228: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_PERIOD_FAIL',

1224: x_err_stage,
1225: x_err_stack );
1226:
1227: if (x_err_code <> 0) then
1228: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_PERIOD_FAIL',
1229: x_err_code => x_err_code,
1230: x_err_buff => x_err_stage);
1231:
1232: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1249: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_SHIFT_PERIOD_FAIL',

1245: x_err_stage ,
1246: x_err_stack );
1247:
1248: if (x_err_code <> 0) then
1249: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_SHIFT_PERIOD_FAIL',
1250: x_err_code => x_err_code,
1251: x_err_buff => x_err_stage);
1252:
1253: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1372: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_COPY_LINES_FAIL',

1368: x_err_stage,
1369: x_err_stack);
1370:
1371: if (x_err_code <> 0) then
1372: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_COPY_LINES_FAIL',
1373: x_err_code => x_err_code,
1374: x_err_buff => x_err_stage);
1375:
1376: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1399: gms_error_pkg.gms_message( x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',

1395: x_err_stage,
1396: x_err_stack);
1397:
1398: if (x_err_code <> 0) then
1399: gms_error_pkg.gms_message( x_err_name => 'GMS_SUMMERIZE_TOTALS_FAILED',
1400: x_err_code => x_err_code,
1401: x_err_buff => x_err_stage);
1402:
1403: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1612: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_PERIOD_FAIL',

1608: x_err_stage,
1609: x_err_stack );
1610:
1611: if (x_err_code <> 0) then
1612: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_PERIOD_FAIL',
1613: x_err_code => x_err_code,
1614: x_err_buff => x_err_stage);
1615:
1616: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1631: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_SHIFT_PERIOD_FAIL',

1627: x_err_stage,
1628: x_err_stack );
1629:
1630: if (x_err_code <> 0) then
1631: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_SHIFT_PERIOD_FAIL',
1632: x_err_code => x_err_code,
1633: x_err_buff => x_err_stage);
1634:
1635: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2293: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_TIME_PHASED', -- cannot copy-actual for a non-time phased/date range budgets

2289: where budget_entry_method_code = x_budget_entry_method_code;
2290:
2291: if ( (x_time_phased_type_code = 'N')
2292: or (x_time_phased_type_code = 'R')) then
2293: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_INVALID_TIME_PHASED', -- cannot copy-actual for a non-time phased/date range budgets
2294: x_err_code => x_err_code,
2295: x_err_buff => x_err_stage);
2296:
2297: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2404: gms_error_pkg.gms_message( x_err_name => 'GMS_DELETE_BUDGET_LINE_FAIL',

2400: );
2401:
2402: IF x_err_code <> 0
2403: THEN
2404: gms_error_pkg.gms_message( x_err_name => 'GMS_DELETE_BUDGET_LINE_FAIL',
2405: x_err_code => x_err_code,
2406: x_err_buff => x_err_stage);
2407:
2408: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2457: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',

2453: x_err_code
2454: );
2455:
2456: if (x_err_code <> 0) then
2457: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2458: x_err_code => x_err_code,
2459: x_err_buff => x_err_stage);
2460:
2461: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2489: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',

2485: ,p_pm_budget_line_reference => NULL ); -- jjj - identifies external system
2486:
2487:
2488: if (x_err_code <> 0) then
2489: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2490: x_err_code => x_err_code,
2491: x_err_buff => x_err_stage);
2492: x_funding_status := 0;
2493: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2542: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',

2538: x_err_code
2539: );
2540:
2541: if (x_err_code <> 0) then
2542: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2543: x_err_code => x_err_code,
2544: x_err_buff => x_err_stage);
2545:
2546: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2573: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',

2569: ,p_pm_budget_line_reference => NULL ); -- jjj - identifies external system
2570:
2571:
2572: if (x_err_code <> 0) then
2573: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2574: x_err_code => x_err_code,
2575: x_err_buff => x_err_stage);
2576: x_funding_status := 0;
2577: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2621: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',

2617: x_err_code
2618: );
2619:
2620: if (x_err_code <> 0) then
2621: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2622: x_err_code => x_err_code,
2623: x_err_buff => x_err_stage);
2624:
2625: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2663: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',

2659: ,p_pm_budget_line_reference => NULL ); -- jjj - identifies external system
2660:
2661:
2662: if (x_err_code <> 0) then
2663: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2664: x_err_code => x_err_code,
2665: x_err_buff => x_err_stage);
2666: x_funding_status := 0;
2667: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2718: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',

2714: x_err_code
2715: );
2716:
2717: if (x_err_code <> 0) then
2718: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2719: x_err_code => x_err_code,
2720: x_err_buff => x_err_stage);
2721:
2722: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2747: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',

2743: ,p_pm_budget_line_reference => NULL ); -- jjj - identifies external system
2744:
2745:
2746: if (x_err_code <> 0) then
2747: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2748: x_err_code => x_err_code,
2749: x_err_buff => x_err_stage);
2750: x_funding_status := 0;
2751: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2799: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',

2795: x_err_code
2796: );
2797:
2798: if (x_err_code <> 0) then
2799: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2800: x_err_code => x_err_code,
2801: x_err_buff => x_err_stage);
2802:
2803: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2827: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',

2823: ,p_quantity => x_quantity
2824: ,p_pm_budget_line_reference => NULL ); -- jjj - identifies external system
2825:
2826: if (x_err_code <> 0) then
2827: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2828: x_err_code => x_err_code,
2829: x_err_buff => x_err_stage);
2830: x_funding_status := 0;
2831: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2882: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',

2878: x_err_code
2879: );
2880:
2881: if (x_err_code <> 0) then
2882: gms_error_pkg.gms_message( x_err_name => 'GMS_BU_GET_ACCUM_ACTUALS_FAIL',
2883: x_err_code => x_err_code,
2884: x_err_buff => x_err_stage);
2885:
2886: APP_EXCEPTION.RAISE_EXCEPTION;

Line 2911: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',

2907: ,p_quantity => x_quantity
2908: ,p_pm_budget_line_reference => NULL ); -- jjj - identifies external system
2909:
2910: if (x_err_code <> 0) then
2911: gms_error_pkg.gms_message( x_err_name => 'GMS_ADD_BUDGET_LINE_FAIL',
2912: x_err_code => x_err_code,
2913: x_err_buff => x_err_stage);
2914: x_funding_status := 0;
2915: APP_EXCEPTION.RAISE_EXCEPTION;

Line 3251: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_CORE.COPY_DRAFT_LINES ***','C');

3247:
3248: begin
3249:
3250: IF L_DEBUG = 'Y' THEN
3251: gms_error_pkg.gms_debug('*** Start of GMS_BUDGET_CORE.COPY_DRAFT_LINES ***','C');
3252: END IF;
3253:
3254: x_err_code := 0;
3255: old_stack := x_err_stack;

Line 3267: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.COPY_DRAFT_LINES- Inserting records into gms_resource_assignments','C');

3263: x_err_stage := 'copy resource assignment <' || to_char(x_src_version_id)
3264: || '>' ;
3265:
3266: IF L_DEBUG = 'Y' THEN
3267: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.COPY_DRAFT_LINES- Inserting records into gms_resource_assignments','C');
3268: END IF;
3269:
3270:
3271: insert into gms_resource_assignments

Line 3305: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.COPY_DRAFT_LINES- Inserting records into gms_budget_lines','C');

3301: x_err_stage := 'copy budget lines <' ||to_char(x_src_version_id)
3302: || '>' ;
3303:
3304: IF L_DEBUG = 'Y' THEN
3305: gms_error_pkg.gms_debug('GMS_BUDGET_CORE.COPY_DRAFT_LINES- Inserting records into gms_budget_lines','C');
3306: END IF;
3307:
3308: insert into gms_budget_lines
3309: (resource_assignment_id,

Line 3403: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_CORE.COPY_DRAFT_LINES ***','C');

3399:
3400: x_err_stack := old_stack;
3401:
3402: IF L_DEBUG = 'Y' THEN
3403: gms_error_pkg.gms_debug('*** End of GMS_BUDGET_CORE.COPY_DRAFT_LINES ***','C');
3404: END IF;
3405:
3406: exception
3407: when others then

Line 3411: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_COPY_BUDG_LINES_FAIL',

3407: when others then
3408: -- Bug 2587078 : Modified the below code to set proper error message
3409: -- x_err_code := SQLCODE;
3410: x_err_stage := 'GMS_BUDGET_CORE.COPY_DRAFT_LINES - In others exception';
3411: gms_error_pkg.gms_message(x_err_name => 'GMS_BU_COPY_BUDG_LINES_FAIL',
3412: x_err_code => x_err_code,
3413: x_err_buff => x_err_stage);
3414: fnd_msg_pub.add;
3415: rollback to before_copy_draft_lines;