DBA Data[Home] [Help]

APPS.JTS_CONFIG_VERSION_FLOW_PVT dependencies on APP_EXCEPTION

Line 44: APP_EXCEPTION.RAISE_EXCEPTION;

40: return ROUND(l_completed*100/l_total);
41:
42: EXCEPTION
43: WHEN OTHERS THEN
44: APP_EXCEPTION.RAISE_EXCEPTION;
45: END GET_PERCENT_COMPLETE;
46:
47: -- Updates last_update_date, last_updated_by of a subflow and its -- parent up to one level below the root
48: PROCEDURE UPDATE_FLOW_DETAILS(p_api_version IN Number,

Line 96: APP_EXCEPTION.RAISE_EXCEPTION;

92: COMMIT;
93:
94: EXCEPTION
95: WHEN OTHERS THEN
96: APP_EXCEPTION.RAISE_EXCEPTION;
97: END UPDATE_FLOW_DETAILS;
98:
99: -- Creates Setup Summary data by getting the flow hiearchy
100: -- and inserting with the appropriate flow_id

Line 144: APP_EXCEPTION.RAISE_EXCEPTION;

140: END LOOP;
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: APP_EXCEPTION.RAISE_EXCEPTION;
145: END CREATE_VERSION_FLOWS;
146:
147: --Deletes from jts_config_version_flows
148: PROCEDURE DELETE_VERSION_FLOWS(p_api_version IN Number,

Line 170: APP_EXCEPTION.RAISE_EXCEPTION;

166: EXCEPTION
167: WHEN NO_DATA_FOUND THEN
168: NULL;
169: WHEN OTHERS THEN
170: APP_EXCEPTION.RAISE_EXCEPTION;
171: END DELETE_VERSION_FLOWS;
172:
173: -- Deletes all records from jts_config_version_flows where
174: -- version_id exists for p_config_id in versions table

Line 209: APP_EXCEPTION.RAISE_EXCEPTION;

205: EXCEPTION
206: WHEN NO_DATA_FOUND THEN
207: NULL;
208: WHEN OTHERS THEN
209: APP_EXCEPTION.RAISE_EXCEPTION;
210: END DELETE_CONFIG_VERSION_FLOWS;
211:
212: -- Gets all the version flows
213: PROCEDURE GET_VERSION_FLOWS(p_api_version IN Number,

Line 264: APP_EXCEPTION.RAISE_EXCEPTION;

260: CLOSE vflows_csr;
261:
262: EXCEPTION
263: WHEN OTHERS THEN
264: APP_EXCEPTION.RAISE_EXCEPTION;
265: END GET_VERSION_FLOWS;
266:
267:
268: END JTS_CONFIG_VERSION_FLOW_PVT;