eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_RES_PVT dependencies on OKL_API

Line 79: IF (l_res_rec.RESI_CAT_OBJECT_ID=OKL_API.G_MISS_NUM) THEN

75: p_res_rec IN okl_res_rec
76: ) RETURN okl_res_rec IS
77: l_res_rec okl_res_rec:= p_res_rec;
78: BEGIN
79: IF (l_res_rec.RESI_CAT_OBJECT_ID=OKL_API.G_MISS_NUM) THEN
80: l_res_rec.RESI_CAT_OBJECT_ID:=NULL;
81: END IF;
82: IF (l_res_rec.OBJECT_VERSION_NUMBER=OKL_API.G_MISS_NUM) THEN
83: l_res_rec.OBJECT_VERSION_NUMBER:=NULL;

Line 82: IF (l_res_rec.OBJECT_VERSION_NUMBER=OKL_API.G_MISS_NUM) THEN

78: BEGIN
79: IF (l_res_rec.RESI_CAT_OBJECT_ID=OKL_API.G_MISS_NUM) THEN
80: l_res_rec.RESI_CAT_OBJECT_ID:=NULL;
81: END IF;
82: IF (l_res_rec.OBJECT_VERSION_NUMBER=OKL_API.G_MISS_NUM) THEN
83: l_res_rec.OBJECT_VERSION_NUMBER:=NULL;
84: END IF;
85: IF (l_res_rec.INVENTORY_ITEM_ID=OKL_API.G_MISS_NUM) THEN
86: l_res_rec.INVENTORY_ITEM_ID:=NULL;

Line 85: IF (l_res_rec.INVENTORY_ITEM_ID=OKL_API.G_MISS_NUM) THEN

81: END IF;
82: IF (l_res_rec.OBJECT_VERSION_NUMBER=OKL_API.G_MISS_NUM) THEN
83: l_res_rec.OBJECT_VERSION_NUMBER:=NULL;
84: END IF;
85: IF (l_res_rec.INVENTORY_ITEM_ID=OKL_API.G_MISS_NUM) THEN
86: l_res_rec.INVENTORY_ITEM_ID:=NULL;
87: END IF;
88: IF (l_res_rec.ORGANIZATION_ID=OKL_API.G_MISS_NUM) THEN
89: l_res_rec.ORGANIZATION_ID:=NULL;

Line 88: IF (l_res_rec.ORGANIZATION_ID=OKL_API.G_MISS_NUM) THEN

84: END IF;
85: IF (l_res_rec.INVENTORY_ITEM_ID=OKL_API.G_MISS_NUM) THEN
86: l_res_rec.INVENTORY_ITEM_ID:=NULL;
87: END IF;
88: IF (l_res_rec.ORGANIZATION_ID=OKL_API.G_MISS_NUM) THEN
89: l_res_rec.ORGANIZATION_ID:=NULL;
90: END IF;
91: IF (l_res_rec.CATEGORY_ID=OKL_API.G_MISS_NUM) THEN
92: l_res_rec.CATEGORY_ID:=NULL;

Line 91: IF (l_res_rec.CATEGORY_ID=OKL_API.G_MISS_NUM) THEN

87: END IF;
88: IF (l_res_rec.ORGANIZATION_ID=OKL_API.G_MISS_NUM) THEN
89: l_res_rec.ORGANIZATION_ID:=NULL;
90: END IF;
91: IF (l_res_rec.CATEGORY_ID=OKL_API.G_MISS_NUM) THEN
92: l_res_rec.CATEGORY_ID:=NULL;
93: END IF;
94: IF (l_res_rec.CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN
95: l_res_rec.CATEGORY_SET_ID:=NULL;

Line 94: IF (l_res_rec.CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN

90: END IF;
91: IF (l_res_rec.CATEGORY_ID=OKL_API.G_MISS_NUM) THEN
92: l_res_rec.CATEGORY_ID:=NULL;
93: END IF;
94: IF (l_res_rec.CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN
95: l_res_rec.CATEGORY_SET_ID:=NULL;
96: END IF;
97: IF (l_res_rec.RESI_CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN
98: l_res_rec.RESI_CATEGORY_SET_ID:=NULL;

Line 97: IF (l_res_rec.RESI_CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN

93: END IF;
94: IF (l_res_rec.CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN
95: l_res_rec.CATEGORY_SET_ID:=NULL;
96: END IF;
97: IF (l_res_rec.RESI_CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN
98: l_res_rec.RESI_CATEGORY_SET_ID:=NULL;
99: END IF;
100: IF (l_res_rec.CREATED_BY=OKL_API.G_MISS_NUM) THEN
101: l_res_rec.CREATED_BY:=NULL;

Line 100: IF (l_res_rec.CREATED_BY=OKL_API.G_MISS_NUM) THEN

96: END IF;
97: IF (l_res_rec.RESI_CATEGORY_SET_ID=OKL_API.G_MISS_NUM) THEN
98: l_res_rec.RESI_CATEGORY_SET_ID:=NULL;
99: END IF;
100: IF (l_res_rec.CREATED_BY=OKL_API.G_MISS_NUM) THEN
101: l_res_rec.CREATED_BY:=NULL;
102: END IF;
103: IF (l_res_rec.CREATION_DATE=OKL_API.G_MISS_DATE) THEN
104: l_res_rec.CREATION_DATE:=NULL;

Line 103: IF (l_res_rec.CREATION_DATE=OKL_API.G_MISS_DATE) THEN

99: END IF;
100: IF (l_res_rec.CREATED_BY=OKL_API.G_MISS_NUM) THEN
101: l_res_rec.CREATED_BY:=NULL;
102: END IF;
103: IF (l_res_rec.CREATION_DATE=OKL_API.G_MISS_DATE) THEN
104: l_res_rec.CREATION_DATE:=NULL;
105: END IF;
106: IF (l_res_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN
107: l_res_rec.LAST_UPDATED_BY:=NULL;

Line 106: IF (l_res_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN

102: END IF;
103: IF (l_res_rec.CREATION_DATE=OKL_API.G_MISS_DATE) THEN
104: l_res_rec.CREATION_DATE:=NULL;
105: END IF;
106: IF (l_res_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN
107: l_res_rec.LAST_UPDATED_BY:=NULL;
108: END IF;
109: IF (l_res_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN
110: l_res_rec.LAST_UPDATE_DATE:=NULL;

Line 109: IF (l_res_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN

105: END IF;
106: IF (l_res_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN
107: l_res_rec.LAST_UPDATED_BY:=NULL;
108: END IF;
109: IF (l_res_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN
110: l_res_rec.LAST_UPDATE_DATE:=NULL;
111: END IF;
112: IF (l_res_rec.LAST_UPDATE_LOGIN=OKL_API.G_MISS_NUM) THEN
113: l_res_rec.LAST_UPDATE_LOGIN:=NULL;

Line 112: IF (l_res_rec.LAST_UPDATE_LOGIN=OKL_API.G_MISS_NUM) THEN

108: END IF;
109: IF (l_res_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN
110: l_res_rec.LAST_UPDATE_DATE:=NULL;
111: END IF;
112: IF (l_res_rec.LAST_UPDATE_LOGIN=OKL_API.G_MISS_NUM) THEN
113: l_res_rec.LAST_UPDATE_LOGIN:=NULL;
114: END IF;
115: RETURN(l_res_rec);
116: END null_out_defaults;

Line 130: OKL_API.set_message(p_app_name => G_APP_NAME,

126: FUNCTION validate_resi_cat_object_id (p_resi_cat_object_id IN NUMBER) Return Varchar2 IS
127: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_resi_cat_object_id';
128: BEGIN
129: IF p_resi_cat_object_id IS NULL THEN
130: OKL_API.set_message(p_app_name => G_APP_NAME,
131: p_msg_name => G_REQUIRED_VALUE,
132: p_token1 => G_COL_NAME_TOKEN,
133: p_token1_value => 'resi_cat_object_id');
134: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 134: RAISE OKL_API.G_EXCEPTION_ERROR;

130: OKL_API.set_message(p_app_name => G_APP_NAME,
131: p_msg_name => G_REQUIRED_VALUE,
132: p_token1 => G_COL_NAME_TOKEN,
133: p_token1_value => 'resi_cat_object_id');
134: RAISE OKL_API.G_EXCEPTION_ERROR;
135: END IF;
136: Return G_RET_STS_SUCCESS;
137: EXCEPTION
138: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 138: WHEN OKL_API.G_EXCEPTION_ERROR THEN

134: RAISE OKL_API.G_EXCEPTION_ERROR;
135: END IF;
136: Return G_RET_STS_SUCCESS;
137: EXCEPTION
138: WHEN OKL_API.G_EXCEPTION_ERROR THEN
139: Return G_RET_STS_ERROR;
140: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
141: Return G_RET_STS_UNEXP_ERROR;
142: WHEN OTHERS THEN

Line 140: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

136: Return G_RET_STS_SUCCESS;
137: EXCEPTION
138: WHEN OKL_API.G_EXCEPTION_ERROR THEN
139: Return G_RET_STS_ERROR;
140: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
141: Return G_RET_STS_UNEXP_ERROR;
142: WHEN OTHERS THEN
143: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
144: p_msg_name => G_DB_ERROR,

Line 143: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

139: Return G_RET_STS_ERROR;
140: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
141: Return G_RET_STS_UNEXP_ERROR;
142: WHEN OTHERS THEN
143: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
144: p_msg_name => G_DB_ERROR,
145: p_token1 => G_PROG_NAME_TOKEN,
146: p_token1_value => l_api_name,
147: p_token2 => 'SQLCODE',

Line 161: IF (p_object_version_number IS NULL) OR (p_object_version_number = OKL_API.G_MISS_NUM) THEN

157: -------------------------------------------
158: FUNCTION validate_object_version_number (p_object_version_number IN NUMBER) Return Varchar2 IS
159: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_object_version_number';
160: BEGIN
161: IF (p_object_version_number IS NULL) OR (p_object_version_number = OKL_API.G_MISS_NUM) THEN
162: OKL_API.set_message(p_app_name => G_APP_NAME,
163: p_msg_name => G_REQUIRED_VALUE,
164: p_token1 => G_COL_NAME_TOKEN,
165: p_token1_value => 'object_version_number');

Line 162: OKL_API.set_message(p_app_name => G_APP_NAME,

158: FUNCTION validate_object_version_number (p_object_version_number IN NUMBER) Return Varchar2 IS
159: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_object_version_number';
160: BEGIN
161: IF (p_object_version_number IS NULL) OR (p_object_version_number = OKL_API.G_MISS_NUM) THEN
162: OKL_API.set_message(p_app_name => G_APP_NAME,
163: p_msg_name => G_REQUIRED_VALUE,
164: p_token1 => G_COL_NAME_TOKEN,
165: p_token1_value => 'object_version_number');
166: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 166: RAISE OKL_API.G_EXCEPTION_ERROR;

162: OKL_API.set_message(p_app_name => G_APP_NAME,
163: p_msg_name => G_REQUIRED_VALUE,
164: p_token1 => G_COL_NAME_TOKEN,
165: p_token1_value => 'object_version_number');
166: RAISE OKL_API.G_EXCEPTION_ERROR;
167: END IF;
168: Return G_RET_STS_SUCCESS;
169: EXCEPTION
170: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 170: WHEN OKL_API.G_EXCEPTION_ERROR THEN

166: RAISE OKL_API.G_EXCEPTION_ERROR;
167: END IF;
168: Return G_RET_STS_SUCCESS;
169: EXCEPTION
170: WHEN OKL_API.G_EXCEPTION_ERROR THEN
171: Return G_RET_STS_ERROR;
172: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
173: Return G_RET_STS_UNEXP_ERROR;
174: WHEN OTHERS THEN

Line 172: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

168: Return G_RET_STS_SUCCESS;
169: EXCEPTION
170: WHEN OKL_API.G_EXCEPTION_ERROR THEN
171: Return G_RET_STS_ERROR;
172: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
173: Return G_RET_STS_UNEXP_ERROR;
174: WHEN OTHERS THEN
175: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
176: p_msg_name => G_DB_ERROR,

Line 175: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

171: Return G_RET_STS_ERROR;
172: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
173: Return G_RET_STS_UNEXP_ERROR;
174: WHEN OTHERS THEN
175: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
176: p_msg_name => G_DB_ERROR,
177: p_token1 => G_PROG_NAME_TOKEN,
178: p_token1_value => l_api_name,
179: p_token2 => 'SQLCODE',

Line 193: OKL_API.set_message(p_app_name => G_APP_NAME,

189: FUNCTION validate_resi_category_set_id (p_resi_category_set_id IN NUMBER) Return Varchar2 IS
190: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_resi_category_set_id';
191: BEGIN
192: IF p_resi_category_set_id IS NULL THEN
193: OKL_API.set_message(p_app_name => G_APP_NAME,
194: p_msg_name => G_REQUIRED_VALUE,
195: p_token1 => G_COL_NAME_TOKEN,
196: p_token1_value => 'resi_category_set_id');
197: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 197: RAISE OKL_API.G_EXCEPTION_ERROR;

193: OKL_API.set_message(p_app_name => G_APP_NAME,
194: p_msg_name => G_REQUIRED_VALUE,
195: p_token1 => G_COL_NAME_TOKEN,
196: p_token1_value => 'resi_category_set_id');
197: RAISE OKL_API.G_EXCEPTION_ERROR;
198: END IF;
199: Return G_RET_STS_SUCCESS;
200: EXCEPTION
201: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 201: WHEN OKL_API.G_EXCEPTION_ERROR THEN

197: RAISE OKL_API.G_EXCEPTION_ERROR;
198: END IF;
199: Return G_RET_STS_SUCCESS;
200: EXCEPTION
201: WHEN OKL_API.G_EXCEPTION_ERROR THEN
202: Return G_RET_STS_ERROR;
203: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
204: Return G_RET_STS_UNEXP_ERROR;
205: WHEN OTHERS THEN

Line 203: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

199: Return G_RET_STS_SUCCESS;
200: EXCEPTION
201: WHEN OKL_API.G_EXCEPTION_ERROR THEN
202: Return G_RET_STS_ERROR;
203: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
204: Return G_RET_STS_UNEXP_ERROR;
205: WHEN OTHERS THEN
206: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
207: p_msg_name => G_DB_ERROR,

Line 206: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

202: Return G_RET_STS_ERROR;
203: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
204: Return G_RET_STS_UNEXP_ERROR;
205: WHEN OTHERS THEN
206: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
207: p_msg_name => G_DB_ERROR,
208: p_token1 => G_PROG_NAME_TOKEN,
209: p_token1_value => l_api_name,
210: p_token2 => 'SQLCODE',

Line 223: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

219: p_res_rec IN okl_res_rec
220: ) RETURN VARCHAR2 IS
221: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'validate_attributes';
222: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
223: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
224: BEGIN
225: -- ***
226: -- resi_cat_object_id
227: -- ***

Line 231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

227: -- ***
228: l_return_status := validate_resi_cat_object_id(p_res_rec.resi_cat_object_id);
229:
230: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235: -- ***

Line 233: RAISE OKL_API.G_EXCEPTION_ERROR;

229:
230: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
233: RAISE OKL_API.G_EXCEPTION_ERROR;
234: END IF;
235: -- ***
236: -- object_version_number
237: -- ***

Line 241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

237: -- ***
238: l_return_status := validate_object_version_number(p_res_rec.object_version_number);
239:
240: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
242: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
243: RAISE OKL_API.G_EXCEPTION_ERROR;
244: END IF;
245: -- ***

Line 243: RAISE OKL_API.G_EXCEPTION_ERROR;

239:
240: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
242: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
243: RAISE OKL_API.G_EXCEPTION_ERROR;
244: END IF;
245: -- ***
246: -- resi_category_set_id
247: -- ***

Line 251: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

247: -- ***
248: l_return_status := validate_resi_category_set_id(p_res_rec.resi_category_set_id);
249:
250: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
251: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
253: RAISE OKL_API.G_EXCEPTION_ERROR;
254: END IF;
255:

Line 253: RAISE OKL_API.G_EXCEPTION_ERROR;

249:
250: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
251: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
253: RAISE OKL_API.G_EXCEPTION_ERROR;
254: END IF;
255:
256: RETURN (x_return_status);
257: EXCEPTION

Line 258: WHEN OKL_API.G_EXCEPTION_ERROR THEN

254: END IF;
255:
256: RETURN (x_return_status);
257: EXCEPTION
258: WHEN OKL_API.G_EXCEPTION_ERROR THEN
259: return G_RET_STS_ERROR;
260: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
261: return G_RET_STS_UNEXP_ERROR;
262: WHEN OTHERS THEN

Line 260: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

256: RETURN (x_return_status);
257: EXCEPTION
258: WHEN OKL_API.G_EXCEPTION_ERROR THEN
259: return G_RET_STS_ERROR;
260: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
261: return G_RET_STS_UNEXP_ERROR;
262: WHEN OTHERS THEN
263: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
264: p_msg_name => G_DB_ERROR,

Line 263: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

259: return G_RET_STS_ERROR;
260: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
261: return G_RET_STS_UNEXP_ERROR;
262: WHEN OTHERS THEN
263: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
264: p_msg_name => G_DB_ERROR,
265: p_token1 => G_PROG_NAME_TOKEN,
266: p_token1_value => l_api_name,
267: p_token2 => 'SQLCODE',

Line 280: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

276: FUNCTION Validate_Record (
277: p_res_rec IN okl_res_rec
278: ) RETURN VARCHAR2 IS
279: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
280: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
281: BEGIN
282: RETURN (x_return_status);
283: END Validate_Record;
284:

Line 298: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

294: p_res_rec IN okl_res_rec,
295: x_res_rec OUT NOCOPY okl_res_rec)IS
296: l_api_version CONSTANT NUMBER:=1;
297: l_api_name CONSTANT VARCHAR2(30):='v_insert_row';
298: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
299: l_res_rec okl_res_rec;
300: l_def_res_rec okl_res_rec;
301: l_rcvrec okl_res_rec;
302: lx_res_rec okl_res_rec;

Line 334: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

330: l_api_version,
331: p_api_version,
332: '_PVT',
333: x_return_status);
334: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
335: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
336: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
337: RAISE OKC_API.G_EXCEPTION_ERROR;
338: END IF;

Line 336: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

332: '_PVT',
333: x_return_status);
334: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
335: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
336: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
337: RAISE OKC_API.G_EXCEPTION_ERROR;
338: END IF;
339:
340: l_res_rec:=null_out_defaults(p_res_rec);

Line 345: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

341: -- Set Primary key value
342: l_res_rec.RESI_CAT_OBJECT_ID := get_seq_id;
343: --Setting Item Attributes
344: l_return_status:=Set_Attributes(l_res_rec,l_def_res_rec);
345: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
348: RAISE OKC_API.G_EXCEPTION_ERROR;
349: END IF;

Line 347: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

343: --Setting Item Attributes
344: l_return_status:=Set_Attributes(l_res_rec,l_def_res_rec);
345: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
347: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
348: RAISE OKC_API.G_EXCEPTION_ERROR;
349: END IF;
350: l_def_res_rec := fill_who_columns(l_def_res_rec);
351:

Line 353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

349: END IF;
350: l_def_res_rec := fill_who_columns(l_def_res_rec);
351:
352: l_return_status := Validate_Attributes(l_def_res_rec);
353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
356: RAISE OKC_API.G_EXCEPTION_ERROR;
357: END IF;

Line 355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

351:
352: l_return_status := Validate_Attributes(l_def_res_rec);
353: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
354: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
356: RAISE OKC_API.G_EXCEPTION_ERROR;
357: END IF;
358: l_return_status := Validate_Record(l_def_res_rec);
359: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 359: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

355: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
356: RAISE OKC_API.G_EXCEPTION_ERROR;
357: END IF;
358: l_return_status := Validate_Record(l_def_res_rec);
359: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
361: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
362: RAISE OKC_API.G_EXCEPTION_ERROR;
363: END IF;

Line 361: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

357: END IF;
358: l_return_status := Validate_Record(l_def_res_rec);
359: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
360: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
361: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
362: RAISE OKC_API.G_EXCEPTION_ERROR;
363: END IF;
364: INSERT INTO OKL_FE_RESI_CAT_OBJECTS(
365: RESI_CAT_OBJECT_ID,

Line 400: x_return_status := OKL_API.HANDLE_EXCEPTIONS

396: -- No action necessary. Validation can continue to next attribute/column
397: null;
398:
399: WHEN OKC_API.G_EXCEPTION_ERROR THEN
400: x_return_status := OKL_API.HANDLE_EXCEPTIONS
401: (
402: l_api_name,
403: G_PKG_NAME,
404: 'OKL_API.G_RET_STS_ERROR',

Line 404: 'OKL_API.G_RET_STS_ERROR',

400: x_return_status := OKL_API.HANDLE_EXCEPTIONS
401: (
402: l_api_name,
403: G_PKG_NAME,
404: 'OKL_API.G_RET_STS_ERROR',
405: x_msg_count,
406: x_msg_data,
407: '_PVT'
408: );

Line 411: x_return_status := OKL_API.HANDLE_EXCEPTIONS

407: '_PVT'
408: );
409:
410: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
411: x_return_status := OKL_API.HANDLE_EXCEPTIONS
412: (
413: l_api_name,
414: G_PKG_NAME,
415: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 415: 'OKL_API.G_RET_STS_UNEXP_ERROR',

411: x_return_status := OKL_API.HANDLE_EXCEPTIONS
412: (
413: l_api_name,
414: G_PKG_NAME,
415: 'OKL_API.G_RET_STS_UNEXP_ERROR',
416: x_msg_count,
417: x_msg_data,
418: '_PVT'
419: );

Line 422: x_return_status := OKL_API.HANDLE_EXCEPTIONS

418: '_PVT'
419: );
420:
421: WHEN OTHERS THEN
422: x_return_status := OKL_API.HANDLE_EXCEPTIONS
423: (
424: l_api_name,
425: G_PKG_NAME,
426: 'OTHERS',

Line 445: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

441: p_res_tbl IN okl_res_tbl,
442: x_res_tbl OUT NOCOPY okl_res_tbl)IS
443: l_api_version CONSTANT NUMBER:=1;
444: l_api_name CONSTANT VARCHAR2(30):='v_insert_row';
445: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
446: i NUMBER:=0;
447: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
448: BEGIN
449: OKC_API.init_msg_list(p_init_msg_list);

Line 447: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

443: l_api_version CONSTANT NUMBER:=1;
444: l_api_name CONSTANT VARCHAR2(30):='v_insert_row';
445: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
446: i NUMBER:=0;
447: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
448: BEGIN
449: OKC_API.init_msg_list(p_init_msg_list);
450: -- Make sure PL/SQL table has records in it before passing
451: IF (p_res_tbl.COUNT > 0) THEN

Line 479: x_return_status := OKL_API.HANDLE_EXCEPTIONS

475: -- No action necessary. Validation can continue to next attribute/column
476: null;
477:
478: WHEN OKC_API.G_EXCEPTION_ERROR THEN
479: x_return_status := OKL_API.HANDLE_EXCEPTIONS
480: (
481: l_api_name,
482: G_PKG_NAME,
483: 'OKL_API.G_RET_STS_ERROR',

Line 483: 'OKL_API.G_RET_STS_ERROR',

479: x_return_status := OKL_API.HANDLE_EXCEPTIONS
480: (
481: l_api_name,
482: G_PKG_NAME,
483: 'OKL_API.G_RET_STS_ERROR',
484: x_msg_count,
485: x_msg_data,
486: '_PVT'
487: );

Line 490: x_return_status := OKL_API.HANDLE_EXCEPTIONS

486: '_PVT'
487: );
488:
489: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
490: x_return_status := OKL_API.HANDLE_EXCEPTIONS
491: (
492: l_api_name,
493: G_PKG_NAME,
494: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 494: 'OKL_API.G_RET_STS_UNEXP_ERROR',

490: x_return_status := OKL_API.HANDLE_EXCEPTIONS
491: (
492: l_api_name,
493: G_PKG_NAME,
494: 'OKL_API.G_RET_STS_UNEXP_ERROR',
495: x_msg_count,
496: x_msg_data,
497: '_PVT'
498: );

Line 501: x_return_status := OKL_API.HANDLE_EXCEPTIONS

497: '_PVT'
498: );
499:
500: WHEN OTHERS THEN
501: x_return_status := OKL_API.HANDLE_EXCEPTIONS
502: (
503: l_api_name,
504: G_PKG_NAME,
505: 'OTHERS',

Line 588: WHEN OKL_API.G_EXCEPTION_ERROR THEN

584: x_return_status := l_return_status;
585:
586: EXCEPTION
587:
588: WHEN OKL_API.G_EXCEPTION_ERROR THEN
589:
590: x_return_status := G_RET_STS_ERROR;
591:
592: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 592: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

588: WHEN OKL_API.G_EXCEPTION_ERROR THEN
589:
590: x_return_status := G_RET_STS_ERROR;
591:
592: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
593:
594: x_return_status := G_RET_STS_UNEXP_ERROR;
595:
596: WHEN OTHERS THEN

Line 598: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

594: x_return_status := G_RET_STS_UNEXP_ERROR;
595:
596: WHEN OTHERS THEN
597:
598: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
599: p_msg_name => G_DB_ERROR,
600: p_token1 => G_PROG_NAME_TOKEN,
601: p_token1_value => l_api_name,
602: p_token2 => G_SQLCODE_TOKEN,

Line 645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

641: x_msg_data => x_msg_data,
642: p_def_res_rec => okl_res_tbl(i));
643:
644: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
646: ELSIF l_return_status = G_RET_STS_ERROR THEN
647: RAISE OKL_API.G_EXCEPTION_ERROR;
648: END IF;
649:

Line 647: RAISE OKL_API.G_EXCEPTION_ERROR;

643:
644: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
645: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
646: ELSIF l_return_status = G_RET_STS_ERROR THEN
647: RAISE OKL_API.G_EXCEPTION_ERROR;
648: END IF;
649:
650: EXIT WHEN (i = okl_res_tbl.LAST);
651: i := okl_res_tbl.NEXT(i);

Line 663: WHEN OKL_API.G_EXCEPTION_ERROR THEN

659: x_return_status := l_return_status;
660:
661: EXCEPTION
662:
663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
664:
665: x_return_status := G_RET_STS_ERROR;
666:
667: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 667: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

663: WHEN OKL_API.G_EXCEPTION_ERROR THEN
664:
665: x_return_status := G_RET_STS_ERROR;
666:
667: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
668:
669: x_return_status := G_RET_STS_UNEXP_ERROR;
670:
671: WHEN OTHERS THEN

Line 673: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

669: x_return_status := G_RET_STS_UNEXP_ERROR;
670:
671: WHEN OTHERS THEN
672:
673: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
674: p_msg_name => G_DB_ERROR,
675: p_token1 => G_PROG_NAME_TOKEN,
676: p_token1_value => l_api_name,
677: p_token2 => G_SQLCODE_TOKEN,

Line 699: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

695: p_res_rec IN okl_res_rec,
696: x_res_rec OUT NOCOPY okl_res_rec)IS
697: l_api_version CONSTANT NUMBER:=1;
698: l_api_name CONSTANT VARCHAR2(30):='v_insert_row';
699: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
700: l_res_rec okl_res_rec:=p_res_rec;
701: l_def_res_rec okl_res_rec;
702: l_rcvrec okl_res_rec;
703: lx_res_rec okl_res_rec;

Line 721: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

717: x_res_rec OUT NOCOPY okl_res_rec
718: )RETURN VARCHAR2 is
719: l_res_rec okl_res_rec;
720: l_row_notfound BOOLEAN:=TRUE;
721: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
722: BEGIN
723:
724: x_res_rec := p_res_rec;
725: --Get current database values

Line 728: l_return_status:= OKL_API.G_RET_STS_UNEXP_ERROR;

724: x_res_rec := p_res_rec;
725: --Get current database values
726: l_res_rec := get_rec(p_res_rec,l_row_notfound);
727: IF(l_row_notfound) THEN
728: l_return_status:= OKL_API.G_RET_STS_UNEXP_ERROR;
729: END IF;
730:
731: IF (x_res_rec.RESI_CAT_OBJECT_ID IS NULL)
732: THEN

Line 799: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

795: l_api_version,
796: p_api_version,
797: '_PVT',
798: x_return_status);
799: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
801: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
802: RAISE OKC_API.G_EXCEPTION_ERROR;
803: END IF;

Line 801: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

797: '_PVT',
798: x_return_status);
799: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
800: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
801: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
802: RAISE OKC_API.G_EXCEPTION_ERROR;
803: END IF;
804:
805: --Setting Item Attributes

Line 807: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

803: END IF;
804:
805: --Setting Item Attributes
806: l_return_status:=Set_Attributes(l_res_rec,l_def_res_rec);
807: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
808: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
809: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
810: RAISE OKC_API.G_EXCEPTION_ERROR;
811: END IF;

Line 809: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

805: --Setting Item Attributes
806: l_return_status:=Set_Attributes(l_res_rec,l_def_res_rec);
807: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
808: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
809: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
810: RAISE OKC_API.G_EXCEPTION_ERROR;
811: END IF;
812:
813: l_return_status := populate_new_record(l_res_rec,l_def_res_rec);

Line 814: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

810: RAISE OKC_API.G_EXCEPTION_ERROR;
811: END IF;
812:
813: l_return_status := populate_new_record(l_res_rec,l_def_res_rec);
814: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;

Line 816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

812:
813: l_return_status := populate_new_record(l_res_rec,l_def_res_rec);
814: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
815: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
816: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
817: RAISE OKC_API.G_EXCEPTION_ERROR;
818: END IF;
819:
820:

Line 824: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

820:
821: l_def_res_rec := fill_who_columns(l_def_res_rec);
822:
823: l_return_status := Validate_Attributes(l_def_res_rec);
824: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
827: RAISE OKC_API.G_EXCEPTION_ERROR;
828: END IF;

Line 826: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

822:
823: l_return_status := Validate_Attributes(l_def_res_rec);
824: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
825: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
827: RAISE OKC_API.G_EXCEPTION_ERROR;
828: END IF;
829:
830: l_return_status := Validate_Record(l_def_res_rec);

Line 831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

827: RAISE OKC_API.G_EXCEPTION_ERROR;
828: END IF;
829:
830: l_return_status := Validate_Record(l_def_res_rec);
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
834: RAISE OKC_API.G_EXCEPTION_ERROR;
835: END IF;

Line 833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

829:
830: l_return_status := Validate_Record(l_def_res_rec);
831: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
834: RAISE OKC_API.G_EXCEPTION_ERROR;
835: END IF;
836:
837: -- Lock the row before updating

Line 846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

842: x_msg_data => x_msg_data,
843: p_def_res_rec => l_def_res_rec);
844:
845: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
847: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
848: RAISE OKL_API.G_EXCEPTION_ERROR;
849: END IF;
850:

Line 848: RAISE OKL_API.G_EXCEPTION_ERROR;

844:
845: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
846: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
847: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
848: RAISE OKL_API.G_EXCEPTION_ERROR;
849: END IF;
850:
851: UPDATE OKL_FE_RESI_CAT_OBJECTS
852: SET

Line 877: x_return_status := OKL_API.HANDLE_EXCEPTIONS

873: -- No action necessary. Validation can continue to next attribute/column
874: null;
875:
876: WHEN OKC_API.G_EXCEPTION_ERROR THEN
877: x_return_status := OKL_API.HANDLE_EXCEPTIONS
878: (
879: l_api_name,
880: G_PKG_NAME,
881: 'OKL_API.G_RET_STS_ERROR',

Line 881: 'OKL_API.G_RET_STS_ERROR',

877: x_return_status := OKL_API.HANDLE_EXCEPTIONS
878: (
879: l_api_name,
880: G_PKG_NAME,
881: 'OKL_API.G_RET_STS_ERROR',
882: x_msg_count,
883: x_msg_data,
884: '_PVT'
885: );

Line 888: x_return_status := OKL_API.HANDLE_EXCEPTIONS

884: '_PVT'
885: );
886:
887: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
888: x_return_status := OKL_API.HANDLE_EXCEPTIONS
889: (
890: l_api_name,
891: G_PKG_NAME,
892: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 892: 'OKL_API.G_RET_STS_UNEXP_ERROR',

888: x_return_status := OKL_API.HANDLE_EXCEPTIONS
889: (
890: l_api_name,
891: G_PKG_NAME,
892: 'OKL_API.G_RET_STS_UNEXP_ERROR',
893: x_msg_count,
894: x_msg_data,
895: '_PVT'
896: );

Line 899: x_return_status := OKL_API.HANDLE_EXCEPTIONS

895: '_PVT'
896: );
897:
898: WHEN OTHERS THEN
899: x_return_status := OKL_API.HANDLE_EXCEPTIONS
900: (
901: l_api_name,
902: G_PKG_NAME,
903: 'OTHERS',

Line 922: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

918: p_res_tbl IN okl_res_tbl,
919: x_res_tbl OUT NOCOPY okl_res_tbl)IS
920: l_api_version CONSTANT NUMBER:=1;
921: l_api_name CONSTANT VARCHAR2(30):='v_update_row';
922: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
923: i NUMBER:=0;
924: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
925: BEGIN
926: OKC_API.init_msg_list(p_init_msg_list);

Line 924: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

920: l_api_version CONSTANT NUMBER:=1;
921: l_api_name CONSTANT VARCHAR2(30):='v_update_row';
922: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
923: i NUMBER:=0;
924: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
925: BEGIN
926: OKC_API.init_msg_list(p_init_msg_list);
927: -- Make sure PL/SQL table has records in it before passing
928: IF (p_res_tbl.COUNT > 0) THEN

Line 956: x_return_status := OKL_API.HANDLE_EXCEPTIONS

952: -- No action necessary. Validation can continue to next attribute/column
953: null;
954:
955: WHEN OKC_API.G_EXCEPTION_ERROR THEN
956: x_return_status := OKL_API.HANDLE_EXCEPTIONS
957: (
958: l_api_name,
959: G_PKG_NAME,
960: 'OKL_API.G_RET_STS_ERROR',

Line 960: 'OKL_API.G_RET_STS_ERROR',

956: x_return_status := OKL_API.HANDLE_EXCEPTIONS
957: (
958: l_api_name,
959: G_PKG_NAME,
960: 'OKL_API.G_RET_STS_ERROR',
961: x_msg_count,
962: x_msg_data,
963: '_PVT'
964: );

Line 967: x_return_status := OKL_API.HANDLE_EXCEPTIONS

963: '_PVT'
964: );
965:
966: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
967: x_return_status := OKL_API.HANDLE_EXCEPTIONS
968: (
969: l_api_name,
970: G_PKG_NAME,
971: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 971: 'OKL_API.G_RET_STS_UNEXP_ERROR',

967: x_return_status := OKL_API.HANDLE_EXCEPTIONS
968: (
969: l_api_name,
970: G_PKG_NAME,
971: 'OKL_API.G_RET_STS_UNEXP_ERROR',
972: x_msg_count,
973: x_msg_data,
974: '_PVT'
975: );

Line 978: x_return_status := OKL_API.HANDLE_EXCEPTIONS

974: '_PVT'
975: );
976:
977: WHEN OTHERS THEN
978: x_return_status := OKL_API.HANDLE_EXCEPTIONS
979: (
980: l_api_name,
981: G_PKG_NAME,
982: 'OTHERS',

Line 1000: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

996: x_msg_data OUT NOCOPY VARCHAR2,
997: p_res_rec IN okl_res_rec)IS
998: l_api_version CONSTANT NUMBER:=1;
999: l_api_name CONSTANT VARCHAR2(30):='delete_row';
1000: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1001: l_res_rec okl_res_rec := p_res_rec;
1002: l_row_notfound BOOLEAN:=TRUE;
1003:
1004: BEGIN

Line 1012: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1008: l_api_version,
1009: p_api_version,
1010: '_PVT',
1011: x_return_status);
1012: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_ERROR;
1016: END IF;

Line 1014: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1010: '_PVT',
1011: x_return_status);
1012: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1013: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1014: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1015: RAISE OKC_API.G_EXCEPTION_ERROR;
1016: END IF;
1017:
1018: DELETE FROM OKL_FE_RESI_CAT_OBJECTS

Line 1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1023: -- No action necessary. Validation can continue to next attribute/column
1024: null;
1025:
1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,
1031: 'OKL_API.G_RET_STS_ERROR',

Line 1031: 'OKL_API.G_RET_STS_ERROR',

1027: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,
1031: 'OKL_API.G_RET_STS_ERROR',
1032: x_msg_count,
1033: x_msg_data,
1034: '_PVT'
1035: );

Line 1038: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1034: '_PVT'
1035: );
1036:
1037: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1038: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1039: (
1040: l_api_name,
1041: G_PKG_NAME,
1042: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1042: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1038: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1039: (
1040: l_api_name,
1041: G_PKG_NAME,
1042: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1043: x_msg_count,
1044: x_msg_data,
1045: '_PVT'
1046: );

Line 1049: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1045: '_PVT'
1046: );
1047:
1048: WHEN OTHERS THEN
1049: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1050: (
1051: l_api_name,
1052: G_PKG_NAME,
1053: 'OTHERS',

Line 1072: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

1068: x_msg_data OUT NOCOPY VARCHAR2,
1069: p_res_tbl IN okl_res_tbl)IS
1070: l_api_version CONSTANT NUMBER:=1;
1071: l_api_name CONSTANT VARCHAR2(30):='v_delete_row';
1072: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1073: i NUMBER:=0;
1074: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1075: BEGIN
1076: OKC_API.init_msg_list(p_init_msg_list);

Line 1074: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;

1070: l_api_version CONSTANT NUMBER:=1;
1071: l_api_name CONSTANT VARCHAR2(30):='v_delete_row';
1072: l_return_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1073: i NUMBER:=0;
1074: l_overall_status VARCHAR2(1):=OKL_API.G_RET_STS_SUCCESS;
1075: BEGIN
1076: OKC_API.init_msg_list(p_init_msg_list);
1077: -- Make sure PL/SQL table has records in it before passing
1078: IF (p_res_tbl.COUNT > 0) THEN

Line 1105: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1101: -- No action necessary. Validation can continue to next attribute/column
1102: null;
1103:
1104: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1105: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1106: (
1107: l_api_name,
1108: G_PKG_NAME,
1109: 'OKL_API.G_RET_STS_ERROR',

Line 1109: 'OKL_API.G_RET_STS_ERROR',

1105: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1106: (
1107: l_api_name,
1108: G_PKG_NAME,
1109: 'OKL_API.G_RET_STS_ERROR',
1110: x_msg_count,
1111: x_msg_data,
1112: '_PVT'
1113: );

Line 1116: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1112: '_PVT'
1113: );
1114:
1115: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1116: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1117: (
1118: l_api_name,
1119: G_PKG_NAME,
1120: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1120: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1116: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1117: (
1118: l_api_name,
1119: G_PKG_NAME,
1120: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1121: x_msg_count,
1122: x_msg_data,
1123: '_PVT'
1124: );

Line 1127: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1123: '_PVT'
1124: );
1125:
1126: WHEN OTHERS THEN
1127: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,
1131: 'OTHERS',