DBA Data[Home] [Help]

APPS.GMS_BUDGET_BALANCE dependencies on GMS_ERROR_PKG

Line 832: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

828: exception
829: when no_data_found then
830: null;
831: when others then
832: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
833: 'SQLCODE',
834: SQLCODE,
835: 'SQLERRM',
836: SQLERRM,

Line 977: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

973: exception
974: when no_data_found then
975: null;
976: when others then
977: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
978: 'SQLCODE',
979: SQLCODE,
980: 'SQLERRM',
981: SQLERRM,

Line 1119: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

1115: exception
1116: when no_data_found then
1117: null;
1118: when others then
1119: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
1120: 'SQLCODE',
1121: SQLCODE,
1122: 'SQLERRM',
1123: SQLERRM,

Line 1257: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

1253: exception
1254: when no_data_found then
1255: null;
1256: when others then
1257: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
1258: 'SQLCODE',
1259: SQLCODE,
1260: 'SQLERRM',
1261: SQLERRM,

Line 1391: gms_error_pkg.gms_debug('BEGIN SETUP RLMI','C');

1387: and gms.document_header_id = ei.expenditure_item_id(+);
1388:
1389: BEGIN
1390: IF L_DEBUG = 'Y' THEN
1391: gms_error_pkg.gms_debug('BEGIN SETUP RLMI','C');
1392: END IF;
1393: --('*********** IN GMS_FST PROCESS **************************************');
1394: if x_mode <> 'U' then
1395:

Line 1549: --gms_error_pkg.gms_debug('map trans :x_project_id >>>>>>'||to_char(x_project_id),'C');

1545: CLOSE c_group_by_none_cat;
1546: END IF;
1547:
1548: --('PARAMETERS FOR RESOURCE MAPPING PROCESS **************************************');
1549: --gms_error_pkg.gms_debug('map trans :x_project_id >>>>>>'||to_char(x_project_id),'C');
1550: --gms_error_pkg.gms_debug('map trans :x_res_list_id>>>>>>'||to_char(x_res_list_id),'C');
1551: --gms_error_pkg.gms_debug('map trans :x_person_id>>>>>>'||to_char(x_person_id),'C');
1552: --gms_error_pkg.gms_debug('map trans :x_organization_id>>>>>>'||to_char(x_organization_id),'C');
1553: --gms_error_pkg.gms_debug('map trans :x_expenditure_type>>>>>>'||x_expenditure_type,'C');

Line 1550: --gms_error_pkg.gms_debug('map trans :x_res_list_id>>>>>>'||to_char(x_res_list_id),'C');

1546: END IF;
1547:
1548: --('PARAMETERS FOR RESOURCE MAPPING PROCESS **************************************');
1549: --gms_error_pkg.gms_debug('map trans :x_project_id >>>>>>'||to_char(x_project_id),'C');
1550: --gms_error_pkg.gms_debug('map trans :x_res_list_id>>>>>>'||to_char(x_res_list_id),'C');
1551: --gms_error_pkg.gms_debug('map trans :x_person_id>>>>>>'||to_char(x_person_id),'C');
1552: --gms_error_pkg.gms_debug('map trans :x_organization_id>>>>>>'||to_char(x_organization_id),'C');
1553: --gms_error_pkg.gms_debug('map trans :x_expenditure_type>>>>>>'||x_expenditure_type,'C');
1554: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource>>>>>>'||x_non_labor_resource,'C');

Line 1551: --gms_error_pkg.gms_debug('map trans :x_person_id>>>>>>'||to_char(x_person_id),'C');

1547:
1548: --('PARAMETERS FOR RESOURCE MAPPING PROCESS **************************************');
1549: --gms_error_pkg.gms_debug('map trans :x_project_id >>>>>>'||to_char(x_project_id),'C');
1550: --gms_error_pkg.gms_debug('map trans :x_res_list_id>>>>>>'||to_char(x_res_list_id),'C');
1551: --gms_error_pkg.gms_debug('map trans :x_person_id>>>>>>'||to_char(x_person_id),'C');
1552: --gms_error_pkg.gms_debug('map trans :x_organization_id>>>>>>'||to_char(x_organization_id),'C');
1553: --gms_error_pkg.gms_debug('map trans :x_expenditure_type>>>>>>'||x_expenditure_type,'C');
1554: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource>>>>>>'||x_non_labor_resource,'C');
1555: --gms_error_pkg.gms_debug('map trans :x_expenditure_category>>>>>>'||x_expenditure_category,'C');

Line 1552: --gms_error_pkg.gms_debug('map trans :x_organization_id>>>>>>'||to_char(x_organization_id),'C');

1548: --('PARAMETERS FOR RESOURCE MAPPING PROCESS **************************************');
1549: --gms_error_pkg.gms_debug('map trans :x_project_id >>>>>>'||to_char(x_project_id),'C');
1550: --gms_error_pkg.gms_debug('map trans :x_res_list_id>>>>>>'||to_char(x_res_list_id),'C');
1551: --gms_error_pkg.gms_debug('map trans :x_person_id>>>>>>'||to_char(x_person_id),'C');
1552: --gms_error_pkg.gms_debug('map trans :x_organization_id>>>>>>'||to_char(x_organization_id),'C');
1553: --gms_error_pkg.gms_debug('map trans :x_expenditure_type>>>>>>'||x_expenditure_type,'C');
1554: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource>>>>>>'||x_non_labor_resource,'C');
1555: --gms_error_pkg.gms_debug('map trans :x_expenditure_category>>>>>>'||x_expenditure_category,'C');
1556: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource_org_id>>>>>>'||to_char(x_non_labor_resource_org_id),'C');

Line 1553: --gms_error_pkg.gms_debug('map trans :x_expenditure_type>>>>>>'||x_expenditure_type,'C');

1549: --gms_error_pkg.gms_debug('map trans :x_project_id >>>>>>'||to_char(x_project_id),'C');
1550: --gms_error_pkg.gms_debug('map trans :x_res_list_id>>>>>>'||to_char(x_res_list_id),'C');
1551: --gms_error_pkg.gms_debug('map trans :x_person_id>>>>>>'||to_char(x_person_id),'C');
1552: --gms_error_pkg.gms_debug('map trans :x_organization_id>>>>>>'||to_char(x_organization_id),'C');
1553: --gms_error_pkg.gms_debug('map trans :x_expenditure_type>>>>>>'||x_expenditure_type,'C');
1554: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource>>>>>>'||x_non_labor_resource,'C');
1555: --gms_error_pkg.gms_debug('map trans :x_expenditure_category>>>>>>'||x_expenditure_category,'C');
1556: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource_org_id>>>>>>'||to_char(x_non_labor_resource_org_id),'C');
1557: --gms_error_pkg.gms_debug('map trans :x_system_linkage>>>>>>'||x_system_linkage,'C');

Line 1554: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource>>>>>>'||x_non_labor_resource,'C');

1550: --gms_error_pkg.gms_debug('map trans :x_res_list_id>>>>>>'||to_char(x_res_list_id),'C');
1551: --gms_error_pkg.gms_debug('map trans :x_person_id>>>>>>'||to_char(x_person_id),'C');
1552: --gms_error_pkg.gms_debug('map trans :x_organization_id>>>>>>'||to_char(x_organization_id),'C');
1553: --gms_error_pkg.gms_debug('map trans :x_expenditure_type>>>>>>'||x_expenditure_type,'C');
1554: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource>>>>>>'||x_non_labor_resource,'C');
1555: --gms_error_pkg.gms_debug('map trans :x_expenditure_category>>>>>>'||x_expenditure_category,'C');
1556: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource_org_id>>>>>>'||to_char(x_non_labor_resource_org_id),'C');
1557: --gms_error_pkg.gms_debug('map trans :x_system_linkage>>>>>>'||x_system_linkage,'C');
1558: --gms_error_pkg.gms_debug('map trans :x_resource_list_member_id>>>Before resource mapping is >>>

Line 1555: --gms_error_pkg.gms_debug('map trans :x_expenditure_category>>>>>>'||x_expenditure_category,'C');

1551: --gms_error_pkg.gms_debug('map trans :x_person_id>>>>>>'||to_char(x_person_id),'C');
1552: --gms_error_pkg.gms_debug('map trans :x_organization_id>>>>>>'||to_char(x_organization_id),'C');
1553: --gms_error_pkg.gms_debug('map trans :x_expenditure_type>>>>>>'||x_expenditure_type,'C');
1554: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource>>>>>>'||x_non_labor_resource,'C');
1555: --gms_error_pkg.gms_debug('map trans :x_expenditure_category>>>>>>'||x_expenditure_category,'C');
1556: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource_org_id>>>>>>'||to_char(x_non_labor_resource_org_id),'C');
1557: --gms_error_pkg.gms_debug('map trans :x_system_linkage>>>>>>'||x_system_linkage,'C');
1558: --gms_error_pkg.gms_debug('map trans :x_resource_list_member_id>>>Before resource mapping is >>>
1559: -- '|| to_char(x_resource_list_member_id),'C');

Line 1556: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource_org_id>>>>>>'||to_char(x_non_labor_resource_org_id),'C');

1552: --gms_error_pkg.gms_debug('map trans :x_organization_id>>>>>>'||to_char(x_organization_id),'C');
1553: --gms_error_pkg.gms_debug('map trans :x_expenditure_type>>>>>>'||x_expenditure_type,'C');
1554: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource>>>>>>'||x_non_labor_resource,'C');
1555: --gms_error_pkg.gms_debug('map trans :x_expenditure_category>>>>>>'||x_expenditure_category,'C');
1556: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource_org_id>>>>>>'||to_char(x_non_labor_resource_org_id),'C');
1557: --gms_error_pkg.gms_debug('map trans :x_system_linkage>>>>>>'||x_system_linkage,'C');
1558: --gms_error_pkg.gms_debug('map trans :x_resource_list_member_id>>>Before resource mapping is >>>
1559: -- '|| to_char(x_resource_list_member_id),'C');
1560: g_error_stage := 'Resource Map';

Line 1557: --gms_error_pkg.gms_debug('map trans :x_system_linkage>>>>>>'||x_system_linkage,'C');

1553: --gms_error_pkg.gms_debug('map trans :x_expenditure_type>>>>>>'||x_expenditure_type,'C');
1554: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource>>>>>>'||x_non_labor_resource,'C');
1555: --gms_error_pkg.gms_debug('map trans :x_expenditure_category>>>>>>'||x_expenditure_category,'C');
1556: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource_org_id>>>>>>'||to_char(x_non_labor_resource_org_id),'C');
1557: --gms_error_pkg.gms_debug('map trans :x_system_linkage>>>>>>'||x_system_linkage,'C');
1558: --gms_error_pkg.gms_debug('map trans :x_resource_list_member_id>>>Before resource mapping is >>>
1559: -- '|| to_char(x_resource_list_member_id),'C');
1560: g_error_stage := 'Resource Map';
1561: gms_res_map.map_trans ( x_project_id,

Line 1558: --gms_error_pkg.gms_debug('map trans :x_resource_list_member_id>>>Before resource mapping is >>>

1554: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource>>>>>>'||x_non_labor_resource,'C');
1555: --gms_error_pkg.gms_debug('map trans :x_expenditure_category>>>>>>'||x_expenditure_category,'C');
1556: --gms_error_pkg.gms_debug('map trans :x_non_labor_resource_org_id>>>>>>'||to_char(x_non_labor_resource_org_id),'C');
1557: --gms_error_pkg.gms_debug('map trans :x_system_linkage>>>>>>'||x_system_linkage,'C');
1558: --gms_error_pkg.gms_debug('map trans :x_resource_list_member_id>>>Before resource mapping is >>>
1559: -- '|| to_char(x_resource_list_member_id),'C');
1560: g_error_stage := 'Resource Map';
1561: gms_res_map.map_trans ( x_project_id,
1562: x_res_list_id,

Line 1580: gms_error_pkg.gms_debug ( 'map trans :x_resource_list_member_id >>>>>>' || x_resource_list_member_id,

1576: x_resource_list_member_id,
1577: x_er_stage,
1578: x_e_code);
1579: IF L_DEBUG = 'Y' THEN
1580: gms_error_pkg.gms_debug ( 'map trans :x_resource_list_member_id >>>>>>' || x_resource_list_member_id,
1581: 'C' );
1582: END IF;
1583:
1584: IF x_e_code > 0

Line 1586: gms_error_pkg.gms_message ( 'GMS_MAP_TRANS',

1582: END IF;
1583:
1584: IF x_e_code > 0
1585: OR x_resource_list_member_id IS NULL THEN
1586: gms_error_pkg.gms_message ( 'GMS_MAP_TRANS',
1587: 'BC_PACKET_ID',
1588: x_bc_packet_id,
1589: 'PACKET_ID',
1590: x_packet_id,

Line 1633: gms_error_pkg.gms_debug ( 'Not Categorized by Resource :x_resource_list_member_id >>>>>>' || x_resource_list_member_id,

1629: WHERE gb.budget_version_id = x_budget_version_id
1630: AND balance_type = 'BGT'
1631: AND ROWNUM = 1;
1632: IF L_DEBUG = 'Y' THEN
1633: gms_error_pkg.gms_debug ( 'Not Categorized by Resource :x_resource_list_member_id >>>>>>' || x_resource_list_member_id,
1634: 'C' );
1635: END IF;
1636:
1637: ----------------------------------------------------------

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

1662: END IF;
1663: END IF;
1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: gms_error_pkg.gms_message ( x_err_name=> 'GMS_UNEXPECTED_ERROR',
1667: x_token_name1 => 'PROGRAM_NAME',
1668: x_token_val1 => g_error_program_name || '.' || g_error_procedure_name || '.' || g_error_stage,
1669: x_token_name2 => 'SQLCODE',
1670: x_token_val2 => SQLCODE,

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

1694: -- x_mode <> 'U' then
1695: x_err_code := 0;
1696: EXCEPTION
1697: WHEN OTHERS THEN
1698: gms_error_pkg.gms_message ( x_err_name=> 'GMS_UNEXPECTED_ERROR',
1699: x_token_name1 => 'PROGRAM_NAME',
1700: x_token_val1 => g_error_program_name || '.' || g_error_procedure_name || '.' || g_error_stage,
1701: x_token_name2 => 'SQLCODE',
1702: x_token_val2 => SQLCODE,

Line 1947: gms_error_pkg.gms_debug('gms_budget_balance -1','C');

1943: select set_of_books_id into x_sob_id
1944: from pa_implementations;
1945: x_e_stage := '200';
1946: IF L_DEBUG = 'Y' THEN
1947: gms_error_pkg.gms_debug('gms_budget_balance -1','C');
1948: END IF;
1949: -- TO SELECT DRAFT_BUDGET_VERSION_ID FROM PA_BUDGET_VERSION TABLE.
1950: select max(budget_version_id) into x_budget_version_id
1951: from gms_budget_versions

Line 1957: gms_error_pkg.gms_debug('gms_budget_balance -2','C');

1953: and award_id = to_char(x_award_id)
1954: and ((budget_status_code ='W' and x_mode='S')
1955: or (budget_status_code = 'B' and x_mode = 'B'));
1956: IF L_DEBUG = 'Y' THEN
1957: gms_error_pkg.gms_debug('gms_budget_balance -2','C');
1958: END IF;
1959:
1960: /* -- Commented out NOCOPY for Bug: 1666853 - will be included in 11.5F
1961:

Line 2040: gms_error_pkg.gms_debug('gms_budget_balance -3','C');

2036: -- re-create GMS_BALANCES record
2037: x_e_stage := '300';
2038: open gms_bal_lock; -- lock gms_balances records for the budget version
2039: IF L_DEBUG = 'Y' THEN
2040: gms_error_pkg.gms_debug('gms_budget_balance -3','C');
2041: END IF;
2042: x_e_stage := '400';
2043: IF L_DEBUG = 'Y' THEN
2044: gms_error_pkg.gms_debug('gms_budget_balance -4','C');

Line 2044: gms_error_pkg.gms_debug('gms_budget_balance -4','C');

2040: gms_error_pkg.gms_debug('gms_budget_balance -3','C');
2041: END IF;
2042: x_e_stage := '400';
2043: IF L_DEBUG = 'Y' THEN
2044: gms_error_pkg.gms_debug('gms_budget_balance -4','C');
2045: END IF;
2046: create_gms_balance( x_budget_version_id, x_sob_id, x_project_id, x_award_id );
2047: -- Get a new packet id
2048: x_e_stage := '500';

Line 2050: gms_error_pkg.gms_debug('gms_budget_balance -5','C');

2046: create_gms_balance( x_budget_version_id, x_sob_id, x_project_id, x_award_id );
2047: -- Get a new packet id
2048: x_e_stage := '500';
2049: IF L_DEBUG = 'Y' THEN
2050: gms_error_pkg.gms_debug('gms_budget_balance -5','C');
2051: END IF;
2052: select gl_bc_packets_s.nextval into x_packet_id from dual;
2053: -- Create raw transactions in GMS_BC_PACKETS
2054: x_e_stage := '600';

Line 2056: gms_error_pkg.gms_debug('gms_budget_balance -6','C');

2052: select gl_bc_packets_s.nextval into x_packet_id from dual;
2053: -- Create raw transactions in GMS_BC_PACKETS
2054: x_e_stage := '600';
2055: IF L_DEBUG = 'Y' THEN
2056: gms_error_pkg.gms_debug('gms_budget_balance -6','C');
2057: END IF;
2058: create_direct_cost(x_packet_id ,
2059: x_sob_id ,
2060: x_project_id,

Line 2069: gms_error_pkg.gms_debug('gms_budget_balance -7','C');

2065: create_indirect_cost(x_packet_id);
2066: -------------------------------------------------------------
2067: Begin
2068: IF L_DEBUG = 'Y' THEN
2069: gms_error_pkg.gms_debug('gms_budget_balance -7','C');
2070: END IF;
2071: x_e_stage := '800';
2072: begin
2073: select count(packet_id) into x_run

Line 2083: gms_error_pkg.gms_debug('gms_budget_balance -8','C');

2079: null;
2080: end;
2081: x_e_stage := '900';
2082: IF L_DEBUG = 'Y' THEN
2083: gms_error_pkg.gms_debug('gms_budget_balance -8','C');
2084: END IF;
2085: if x_run > 0 then
2086: if x_mode in ('S','B') then
2087: if NOT GMS_FUNDS_CONTROL_PKG.GMS_FCK( x_sob_id,

Line 2110: gms_error_pkg.gms_debug('gms_budget_balance -9','C');

2106: else
2107: --Recreating gms_balances without going thro' FC
2108: x_e_stage := '910';
2109: IF L_DEBUG = 'Y' THEN
2110: gms_error_pkg.gms_debug('gms_budget_balance -9','C');
2111: END IF;
2112: -- Update resource list
2113: RETCODE := 'S';
2114: re_base_setup_rlmi(x_packet_id, x_budget_version_id,x_err_code,x_err_buff);

Line 2116: gms_error_pkg.gms_message('GMS_RE_BASE_RLMI_FAILED',

2112: -- Update resource list
2113: RETCODE := 'S';
2114: re_base_setup_rlmi(x_packet_id, x_budget_version_id,x_err_code,x_err_buff);
2115: if x_err_code <> 0 then
2116: gms_error_pkg.gms_message('GMS_RE_BASE_RLMI_FAILED',
2117: X_Exec_Type => 'C',
2118: X_Err_Code => X_Err_Code,
2119: X_Err_Buff => X_Err_Buff);
2120:

Line 2124: gms_error_pkg.gms_debug('gms_budget_balance -10','C');

2120:
2121: end if;
2122: x_e_stage := '920';
2123: IF L_DEBUG = 'Y' THEN
2124: gms_error_pkg.gms_debug('gms_budget_balance -10','C');
2125: END IF;
2126: update_bc_packet_status(x_packet_id);
2127: -- Update gms_balances using sweeper process
2128: end if;

Line 2135: gms_error_pkg.gms_debug('gms_budget_balance -11','C');

2131: RETCODE := 'S';
2132: end if;
2133: x_e_stage := '930';
2134: IF L_DEBUG = 'Y' THEN
2135: gms_error_pkg.gms_debug('gms_budget_balance -11','C');
2136: END IF;
2137:
2138: /* -- Commented out NOCOPY for Bug: 1666853 ...
2139: -- Sweeper is now being called from GMS_BUDGET_PUB.BASELINE_BUDGET()

Line 2150: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');

2146:
2147: if x_mode ='B' then
2148:
2149: IF L_DEBUG = 'Y' THEN
2150: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');
2151: gms_error_pkg.gms_debug('--------- Calling balance Sweeper ------','C');
2152: gms_error_pkg.gms_debug('RETCODE'||RETCODE,'C');
2153: gms_error_pkg.gms_debug('x_mode'||x_mode,'C');
2154: gms_error_pkg.gms_debug('x_packet_id'||x_packet_id,'C');

Line 2151: gms_error_pkg.gms_debug('--------- Calling balance Sweeper ------','C');

2147: if x_mode ='B' then
2148:
2149: IF L_DEBUG = 'Y' THEN
2150: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');
2151: gms_error_pkg.gms_debug('--------- Calling balance Sweeper ------','C');
2152: gms_error_pkg.gms_debug('RETCODE'||RETCODE,'C');
2153: gms_error_pkg.gms_debug('x_mode'||x_mode,'C');
2154: gms_error_pkg.gms_debug('x_packet_id'||x_packet_id,'C');
2155: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');

Line 2152: gms_error_pkg.gms_debug('RETCODE'||RETCODE,'C');

2148:
2149: IF L_DEBUG = 'Y' THEN
2150: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');
2151: gms_error_pkg.gms_debug('--------- Calling balance Sweeper ------','C');
2152: gms_error_pkg.gms_debug('RETCODE'||RETCODE,'C');
2153: gms_error_pkg.gms_debug('x_mode'||x_mode,'C');
2154: gms_error_pkg.gms_debug('x_packet_id'||x_packet_id,'C');
2155: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');
2156: END IF;

Line 2153: gms_error_pkg.gms_debug('x_mode'||x_mode,'C');

2149: IF L_DEBUG = 'Y' THEN
2150: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');
2151: gms_error_pkg.gms_debug('--------- Calling balance Sweeper ------','C');
2152: gms_error_pkg.gms_debug('RETCODE'||RETCODE,'C');
2153: gms_error_pkg.gms_debug('x_mode'||x_mode,'C');
2154: gms_error_pkg.gms_debug('x_packet_id'||x_packet_id,'C');
2155: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');
2156: END IF;
2157:

Line 2154: gms_error_pkg.gms_debug('x_packet_id'||x_packet_id,'C');

2150: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');
2151: gms_error_pkg.gms_debug('--------- Calling balance Sweeper ------','C');
2152: gms_error_pkg.gms_debug('RETCODE'||RETCODE,'C');
2153: gms_error_pkg.gms_debug('x_mode'||x_mode,'C');
2154: gms_error_pkg.gms_debug('x_packet_id'||x_packet_id,'C');
2155: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');
2156: END IF;
2157:
2158:

Line 2155: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');

2151: gms_error_pkg.gms_debug('--------- Calling balance Sweeper ------','C');
2152: gms_error_pkg.gms_debug('RETCODE'||RETCODE,'C');
2153: gms_error_pkg.gms_debug('x_mode'||x_mode,'C');
2154: gms_error_pkg.gms_debug('x_packet_id'||x_packet_id,'C');
2155: gms_error_pkg.gms_debug('%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%','C');
2156: END IF;
2157:
2158:
2159: gms_sweeper.upd_act_enc_bal(ERRBUF, x_e_code, x_packet_id,x_mode,x_project_id,x_award_id);

Line 2161: gms_error_pkg.gms_debug('gms_budget_balance -12','C');

2157:
2158:
2159: gms_sweeper.upd_act_enc_bal(ERRBUF, x_e_code, x_packet_id,x_mode,x_project_id,x_award_id);
2160: IF L_DEBUG = 'Y' THEN
2161: gms_error_pkg.gms_debug('gms_budget_balance -12','C');
2162: END IF;
2163: end if;
2164:
2165:

Line 2194: gms_error_pkg.gms_debug('gms_budget_balance -14','C');

2190: Exception
2191: when OTHERS then
2192: RETCODE := 'H';
2193: IF L_DEBUG = 'Y' THEN
2194: gms_error_pkg.gms_debug('gms_budget_balance -14','C');
2195: END IF;
2196: ERRBUF := (X_E_STAGE||': '||SQLERRM);
2197: end update_gms_balance;
2198: