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_AM_SYSTEM_PARAMS_PVT dependencies on OKL_API

Line 87: l_return_status := OKL_API.start_activity(

83: 'Begin(+)');
84: END IF;
85:
86: -- Check API version, initialize message list and create savepoint
87: l_return_status := OKL_API.start_activity(
88: p_api_name => l_api_name,
89: p_pkg_name => G_PKG_NAME,
90: p_init_msg_list => p_init_msg_list,
91: l_api_version => l_api_version,

Line 137: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN

133: l_rpt_prod_book_type_code := p_sypv_rec.RPT_PROD_BOOK_TYPE_CODE;
134:
135:
136: -- Tax Book 1 is NOT NULL, others are NULL
137: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
138:
139: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
140: THEN
141: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 139: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)

135:
136: -- Tax Book 1 is NOT NULL, others are NULL
137: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
138:
139: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
140: THEN
141: l_return_status := OKL_API.G_RET_STS_ERROR;
142: -- Asset Addition Corporate Book cannot be NULL.
143: OKL_API.set_message( p_app_name => 'OKL',

Line 141: l_return_status := OKL_API.G_RET_STS_ERROR;

137: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
138:
139: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
140: THEN
141: l_return_status := OKL_API.G_RET_STS_ERROR;
142: -- Asset Addition Corporate Book cannot be NULL.
143: OKL_API.set_message( p_app_name => 'OKL',
144: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
145: END IF;

Line 143: OKL_API.set_message( p_app_name => 'OKL',

139: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
140: THEN
141: l_return_status := OKL_API.G_RET_STS_ERROR;
142: -- Asset Addition Corporate Book cannot be NULL.
143: OKL_API.set_message( p_app_name => 'OKL',
144: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
145: END IF;
146:
147:

Line 148: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)

144: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
145: END IF;
146:
147:
148: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
149: THEN
150: l_return_status := OKL_API.G_RET_STS_ERROR;
151: -- l_fa_location_id cannot be NULL.
152: OKL_API.set_message( p_app_name => 'OKL',

Line 150: l_return_status := OKL_API.G_RET_STS_ERROR;

146:
147:
148: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
149: THEN
150: l_return_status := OKL_API.G_RET_STS_ERROR;
151: -- l_fa_location_id cannot be NULL.
152: OKL_API.set_message( p_app_name => 'OKL',
153: p_msg_name => 'OKL_AM_FA_LOCATION_ID_MISSING');
154: END IF;

Line 152: OKL_API.set_message( p_app_name => 'OKL',

148: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
149: THEN
150: l_return_status := OKL_API.G_RET_STS_ERROR;
151: -- l_fa_location_id cannot be NULL.
152: OKL_API.set_message( p_app_name => 'OKL',
153: p_msg_name => 'OKL_AM_FA_LOCATION_ID_MISSING');
154: END IF;
155:
156: END IF;

Line 158: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

154: END IF;
155:
156: END IF;
157:
158: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
159: RAISE G_EXCEPTION_HALT_VALIDATION;
160: -- RAISE G_EXCEPTION_ERROR;
161: END IF;
162:

Line 164: IF (l_fa_location_id IS NOT NULL AND l_fa_location_id <> OKL_API.G_MISS_NUM) THEN

160: -- RAISE G_EXCEPTION_ERROR;
161: END IF;
162:
163: -- LOCATION_ID is NOT NULL, others are NULL
164: IF (l_fa_location_id IS NOT NULL AND l_fa_location_id <> OKL_API.G_MISS_NUM) THEN
165:
166: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
167: THEN
168: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 166: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)

162:
163: -- LOCATION_ID is NOT NULL, others are NULL
164: IF (l_fa_location_id IS NOT NULL AND l_fa_location_id <> OKL_API.G_MISS_NUM) THEN
165:
166: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
167: THEN
168: l_return_status := OKL_API.G_RET_STS_ERROR;
169: -- Asset Addition Corporate Book cannot be NULL.
170: OKL_API.set_message( p_app_name => 'OKL',

Line 168: l_return_status := OKL_API.G_RET_STS_ERROR;

164: IF (l_fa_location_id IS NOT NULL AND l_fa_location_id <> OKL_API.G_MISS_NUM) THEN
165:
166: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
167: THEN
168: l_return_status := OKL_API.G_RET_STS_ERROR;
169: -- Asset Addition Corporate Book cannot be NULL.
170: OKL_API.set_message( p_app_name => 'OKL',
171: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
172: END IF;

Line 170: OKL_API.set_message( p_app_name => 'OKL',

166: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
167: THEN
168: l_return_status := OKL_API.G_RET_STS_ERROR;
169: -- Asset Addition Corporate Book cannot be NULL.
170: OKL_API.set_message( p_app_name => 'OKL',
171: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
172: END IF;
173:
174: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

Line 174: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

170: OKL_API.set_message( p_app_name => 'OKL',
171: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
172: END IF;
173:
174: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
175: THEN
176: l_return_status := OKL_API.G_RET_STS_ERROR;
177: -- l_tax_book_1 cannot be NULL.
178: OKL_API.set_message( p_app_name => 'OKL',

Line 176: l_return_status := OKL_API.G_RET_STS_ERROR;

172: END IF;
173:
174: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
175: THEN
176: l_return_status := OKL_API.G_RET_STS_ERROR;
177: -- l_tax_book_1 cannot be NULL.
178: OKL_API.set_message( p_app_name => 'OKL',
179: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
180: END IF;

Line 178: OKL_API.set_message( p_app_name => 'OKL',

174: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
175: THEN
176: l_return_status := OKL_API.G_RET_STS_ERROR;
177: -- l_tax_book_1 cannot be NULL.
178: OKL_API.set_message( p_app_name => 'OKL',
179: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
180: END IF;
181:
182:

Line 185: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

181:
182:
183: END IF;
184:
185: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
186: RAISE G_EXCEPTION_HALT_VALIDATION;
187: -- RAISE G_EXCEPTION_ERROR;
188: END IF;
189:

Line 191: IF (l_asset_key_id IS NOT NULL AND l_asset_key_id <> OKL_API.G_MISS_NUM) THEN

187: -- RAISE G_EXCEPTION_ERROR;
188: END IF;
189:
190: -- ASSET KEY is NOT NULL, others are NULL
191: IF (l_asset_key_id IS NOT NULL AND l_asset_key_id <> OKL_API.G_MISS_NUM) THEN
192:
193: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
194: THEN
195: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 193: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)

189:
190: -- ASSET KEY is NOT NULL, others are NULL
191: IF (l_asset_key_id IS NOT NULL AND l_asset_key_id <> OKL_API.G_MISS_NUM) THEN
192:
193: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
194: THEN
195: l_return_status := OKL_API.G_RET_STS_ERROR;
196: -- Asset Addition Corporate Book cannot be NULL.
197: OKL_API.set_message( p_app_name => 'OKL',

Line 195: l_return_status := OKL_API.G_RET_STS_ERROR;

191: IF (l_asset_key_id IS NOT NULL AND l_asset_key_id <> OKL_API.G_MISS_NUM) THEN
192:
193: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
194: THEN
195: l_return_status := OKL_API.G_RET_STS_ERROR;
196: -- Asset Addition Corporate Book cannot be NULL.
197: OKL_API.set_message( p_app_name => 'OKL',
198: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
199: END IF;

Line 197: OKL_API.set_message( p_app_name => 'OKL',

193: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
194: THEN
195: l_return_status := OKL_API.G_RET_STS_ERROR;
196: -- Asset Addition Corporate Book cannot be NULL.
197: OKL_API.set_message( p_app_name => 'OKL',
198: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
199: END IF;
200:
201: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

Line 201: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

197: OKL_API.set_message( p_app_name => 'OKL',
198: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
199: END IF;
200:
201: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
202: THEN
203: l_return_status := OKL_API.G_RET_STS_ERROR;
204: -- l_tax_book_1 cannot be NULL.
205: OKL_API.set_message( p_app_name => 'OKL',

Line 203: l_return_status := OKL_API.G_RET_STS_ERROR;

199: END IF;
200:
201: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
202: THEN
203: l_return_status := OKL_API.G_RET_STS_ERROR;
204: -- l_tax_book_1 cannot be NULL.
205: OKL_API.set_message( p_app_name => 'OKL',
206: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
207: END IF;

Line 205: OKL_API.set_message( p_app_name => 'OKL',

201: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
202: THEN
203: l_return_status := OKL_API.G_RET_STS_ERROR;
204: -- l_tax_book_1 cannot be NULL.
205: OKL_API.set_message( p_app_name => 'OKL',
206: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
207: END IF;
208:
209: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)

Line 209: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)

205: OKL_API.set_message( p_app_name => 'OKL',
206: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
207: END IF;
208:
209: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
210: THEN
211: l_return_status := OKL_API.G_RET_STS_ERROR;
212: -- l_fa_location_id cannot be NULL.
213: OKL_API.set_message( p_app_name => 'OKL',

Line 211: l_return_status := OKL_API.G_RET_STS_ERROR;

207: END IF;
208:
209: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
210: THEN
211: l_return_status := OKL_API.G_RET_STS_ERROR;
212: -- l_fa_location_id cannot be NULL.
213: OKL_API.set_message( p_app_name => 'OKL',
214: p_msg_name => 'OKL_AM_FA_LOCATION_ID_MISSING');
215:

Line 213: OKL_API.set_message( p_app_name => 'OKL',

209: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
210: THEN
211: l_return_status := OKL_API.G_RET_STS_ERROR;
212: -- l_fa_location_id cannot be NULL.
213: OKL_API.set_message( p_app_name => 'OKL',
214: p_msg_name => 'OKL_AM_FA_LOCATION_ID_MISSING');
215:
216: END IF;
217:

Line 220: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

216: END IF;
217:
218: END IF;
219:
220: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
221: RAISE G_EXCEPTION_HALT_VALIDATION;
222: -- RAISE G_EXCEPTION_ERROR;
223: END IF;
224:

Line 227: IF (l_formula_id IS NOT NULL AND l_formula_id <> OKL_API.G_MISS_NUM) THEN

223: END IF;
224:
225: -- FORMULA_ID is NOT NULL, others are NULL
226:
227: IF (l_formula_id IS NOT NULL AND l_formula_id <> OKL_API.G_MISS_NUM) THEN
228:
229: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
230: THEN
231: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 229: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)

225: -- FORMULA_ID is NOT NULL, others are NULL
226:
227: IF (l_formula_id IS NOT NULL AND l_formula_id <> OKL_API.G_MISS_NUM) THEN
228:
229: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
230: THEN
231: l_return_status := OKL_API.G_RET_STS_ERROR;
232: -- Asset Addition Corporate Book cannot be NULL.
233: OKL_API.set_message( p_app_name => 'OKL',

Line 231: l_return_status := OKL_API.G_RET_STS_ERROR;

227: IF (l_formula_id IS NOT NULL AND l_formula_id <> OKL_API.G_MISS_NUM) THEN
228:
229: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
230: THEN
231: l_return_status := OKL_API.G_RET_STS_ERROR;
232: -- Asset Addition Corporate Book cannot be NULL.
233: OKL_API.set_message( p_app_name => 'OKL',
234: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
235: END IF;

Line 233: OKL_API.set_message( p_app_name => 'OKL',

229: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
230: THEN
231: l_return_status := OKL_API.G_RET_STS_ERROR;
232: -- Asset Addition Corporate Book cannot be NULL.
233: OKL_API.set_message( p_app_name => 'OKL',
234: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
235: END IF;
236:
237: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

Line 237: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

233: OKL_API.set_message( p_app_name => 'OKL',
234: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
235: END IF;
236:
237: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
238: THEN
239: l_return_status := OKL_API.G_RET_STS_ERROR;
240: -- l_tax_book_1 cannot be NULL.
241: OKL_API.set_message( p_app_name => 'OKL',

Line 239: l_return_status := OKL_API.G_RET_STS_ERROR;

235: END IF;
236:
237: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
238: THEN
239: l_return_status := OKL_API.G_RET_STS_ERROR;
240: -- l_tax_book_1 cannot be NULL.
241: OKL_API.set_message( p_app_name => 'OKL',
242: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
243: END IF;

Line 241: OKL_API.set_message( p_app_name => 'OKL',

237: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
238: THEN
239: l_return_status := OKL_API.G_RET_STS_ERROR;
240: -- l_tax_book_1 cannot be NULL.
241: OKL_API.set_message( p_app_name => 'OKL',
242: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
243: END IF;
244:
245:

Line 246: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)

242: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
243: END IF;
244:
245:
246: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
247: THEN
248: l_return_status := OKL_API.G_RET_STS_ERROR;
249: -- l_fa_location_id cannot be NULL.
250: OKL_API.set_message( p_app_name => 'OKL',

Line 248: l_return_status := OKL_API.G_RET_STS_ERROR;

244:
245:
246: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
247: THEN
248: l_return_status := OKL_API.G_RET_STS_ERROR;
249: -- l_fa_location_id cannot be NULL.
250: OKL_API.set_message( p_app_name => 'OKL',
251: p_msg_name => 'OKL_AM_FA_LOCATION_ID_MISSING');
252:

Line 250: OKL_API.set_message( p_app_name => 'OKL',

246: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
247: THEN
248: l_return_status := OKL_API.G_RET_STS_ERROR;
249: -- l_fa_location_id cannot be NULL.
250: OKL_API.set_message( p_app_name => 'OKL',
251: p_msg_name => 'OKL_AM_FA_LOCATION_ID_MISSING');
252:
253: END IF;
254:

Line 258: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

254:
255:
256: END IF;
257:
258: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
259: RAISE G_EXCEPTION_HALT_VALIDATION;
260: -- RAISE G_EXCEPTION_ERROR;
261: END IF;
262:

Line 265: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN

261: END IF;
262:
263: -- TAX BOOK 2 is NOT NULL, others are NULL
264:
265: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
266:
267: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
268: THEN
269: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 267: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)

263: -- TAX BOOK 2 is NOT NULL, others are NULL
264:
265: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
266:
267: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
268: THEN
269: l_return_status := OKL_API.G_RET_STS_ERROR;
270: -- Asset Addition Corporate Book cannot be NULL.
271: OKL_API.set_message( p_app_name => 'OKL',

Line 269: l_return_status := OKL_API.G_RET_STS_ERROR;

265: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
266:
267: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
268: THEN
269: l_return_status := OKL_API.G_RET_STS_ERROR;
270: -- Asset Addition Corporate Book cannot be NULL.
271: OKL_API.set_message( p_app_name => 'OKL',
272: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
273: END IF;

Line 271: OKL_API.set_message( p_app_name => 'OKL',

267: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
268: THEN
269: l_return_status := OKL_API.G_RET_STS_ERROR;
270: -- Asset Addition Corporate Book cannot be NULL.
271: OKL_API.set_message( p_app_name => 'OKL',
272: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
273: END IF;
274:
275: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

Line 275: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

271: OKL_API.set_message( p_app_name => 'OKL',
272: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
273: END IF;
274:
275: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
276: THEN
277: l_return_status := OKL_API.G_RET_STS_ERROR;
278: -- l_tax_book_1 cannot be NULL.
279: OKL_API.set_message( p_app_name => 'OKL',

Line 277: l_return_status := OKL_API.G_RET_STS_ERROR;

273: END IF;
274:
275: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
276: THEN
277: l_return_status := OKL_API.G_RET_STS_ERROR;
278: -- l_tax_book_1 cannot be NULL.
279: OKL_API.set_message( p_app_name => 'OKL',
280: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
281: END IF;

Line 279: OKL_API.set_message( p_app_name => 'OKL',

275: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
276: THEN
277: l_return_status := OKL_API.G_RET_STS_ERROR;
278: -- l_tax_book_1 cannot be NULL.
279: OKL_API.set_message( p_app_name => 'OKL',
280: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
281: END IF;
282:
283: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)

Line 283: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)

279: OKL_API.set_message( p_app_name => 'OKL',
280: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
281: END IF;
282:
283: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
284: THEN
285: l_return_status := OKL_API.G_RET_STS_ERROR;
286: -- l_fa_location_id cannot be NULL.
287: OKL_API.set_message( p_app_name => 'OKL',

Line 285: l_return_status := OKL_API.G_RET_STS_ERROR;

281: END IF;
282:
283: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
284: THEN
285: l_return_status := OKL_API.G_RET_STS_ERROR;
286: -- l_fa_location_id cannot be NULL.
287: OKL_API.set_message( p_app_name => 'OKL',
288: p_msg_name => 'OKL_AM_FA_LOCATION_ID_MISSING');
289:

Line 287: OKL_API.set_message( p_app_name => 'OKL',

283: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
284: THEN
285: l_return_status := OKL_API.G_RET_STS_ERROR;
286: -- l_fa_location_id cannot be NULL.
287: OKL_API.set_message( p_app_name => 'OKL',
288: p_msg_name => 'OKL_AM_FA_LOCATION_ID_MISSING');
289:
290: END IF;
291:

Line 295: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

291:
292:
293: END IF;
294:
295: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
296: RAISE G_EXCEPTION_HALT_VALIDATION;
297: -- RAISE G_EXCEPTION_ERROR;
298: END IF;
299:

Line 314: IF ( l_asst_add_book_type_code IS NOT NULL AND l_asst_add_book_type_code <> OKL_API.G_MISS_CHAR) THEN

310: OPEN c_tax_book_name_csr (l_tax_book_2);
311: FETCH c_tax_book_name_csr INTO l_tax_book_name_2;
312: CLOSE c_tax_book_name_csr;
313:
314: IF ( l_asst_add_book_type_code IS NOT NULL AND l_asst_add_book_type_code <> OKL_API.G_MISS_CHAR) THEN
315: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
316: OPEN c_tax_book_csr (l_asst_add_book_type_code, l_tax_book_1);
317: FETCH c_tax_book_csr INTO l_tax_1;
318: IF c_tax_book_csr%NOTFOUND THEN

Line 315: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN

311: FETCH c_tax_book_name_csr INTO l_tax_book_name_2;
312: CLOSE c_tax_book_name_csr;
313:
314: IF ( l_asst_add_book_type_code IS NOT NULL AND l_asst_add_book_type_code <> OKL_API.G_MISS_CHAR) THEN
315: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
316: OPEN c_tax_book_csr (l_asst_add_book_type_code, l_tax_book_1);
317: FETCH c_tax_book_csr INTO l_tax_1;
318: IF c_tax_book_csr%NOTFOUND THEN
319:

Line 320: l_return_status := OKL_API.G_RET_STS_ERROR;

316: OPEN c_tax_book_csr (l_asst_add_book_type_code, l_tax_book_1);
317: FETCH c_tax_book_csr INTO l_tax_1;
318: IF c_tax_book_csr%NOTFOUND THEN
319:
320: l_return_status := OKL_API.G_RET_STS_ERROR;
321: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
322: p_msg_name => 'OKL_AM_INVALID_TAX_BOOK',
323: p_token1 => 'TAX_BOOK',
324: p_token1_value => l_tax_book_name_1,

Line 321: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

317: FETCH c_tax_book_csr INTO l_tax_1;
318: IF c_tax_book_csr%NOTFOUND THEN
319:
320: l_return_status := OKL_API.G_RET_STS_ERROR;
321: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
322: p_msg_name => 'OKL_AM_INVALID_TAX_BOOK',
323: p_token1 => 'TAX_BOOK',
324: p_token1_value => l_tax_book_name_1,
325: p_token2 => 'CORPORATE_BOOK',

Line 332: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN

328: END IF;
329: CLOSE c_tax_book_csr;
330: END IF;
331:
332: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
333: OPEN c_tax_book_csr (l_asst_add_book_type_code, l_tax_book_2);
334: FETCH c_tax_book_csr INTO l_tax_2;
335: IF c_tax_book_csr%NOTFOUND THEN
336:

Line 337: l_return_status := OKL_API.G_RET_STS_ERROR;

333: OPEN c_tax_book_csr (l_asst_add_book_type_code, l_tax_book_2);
334: FETCH c_tax_book_csr INTO l_tax_2;
335: IF c_tax_book_csr%NOTFOUND THEN
336:
337: l_return_status := OKL_API.G_RET_STS_ERROR;
338: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
339: p_msg_name => 'OKL_AM_INVALID_TAX_BOOK',
340: p_token1 => 'TAX_BOOK',
341: p_token1_value => l_tax_book_name_2,

Line 338: OKL_API.SET_MESSAGE(p_app_name => 'OKL',

334: FETCH c_tax_book_csr INTO l_tax_2;
335: IF c_tax_book_csr%NOTFOUND THEN
336:
337: l_return_status := OKL_API.G_RET_STS_ERROR;
338: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
339: p_msg_name => 'OKL_AM_INVALID_TAX_BOOK',
340: p_token1 => 'TAX_BOOK',
341: p_token1_value => l_tax_book_name_2,
342: p_token2 => 'CORPORATE_BOOK',

Line 351: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

347:
348: END IF;
349: END IF;
350:
351: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
352: RAISE G_EXCEPTION_HALT_VALIDATION;
353: -- RAISE G_EXCEPTION_ERROR;
354: END IF;
355:

Line 359: IF (l_rpt_prod_book_type_code IS NOT NULL AND l_rpt_prod_book_type_code <> OKL_API.G_MISS_CHAR) THEN

355:
356: -- no duplicate l_rpt_prod_book_type_code and tax book 1 and Tax Book 2
357: --Commented below if by NIKSHAH for bug 8570053
358: /*
359: IF (l_rpt_prod_book_type_code IS NOT NULL AND l_rpt_prod_book_type_code <> OKL_API.G_MISS_CHAR) THEN
360:
361: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
362:
363: IF (l_rpt_prod_book_type_code = l_tax_book_1) THEN

Line 361: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN

357: --Commented below if by NIKSHAH for bug 8570053
358: /*
359: IF (l_rpt_prod_book_type_code IS NOT NULL AND l_rpt_prod_book_type_code <> OKL_API.G_MISS_CHAR) THEN
360:
361: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
362:
363: IF (l_rpt_prod_book_type_code = l_tax_book_1) THEN
364: -- l_rpt_prod_book_type_code and Tax Book 1 cannot be the same.
365: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 365: l_return_status := OKL_API.G_RET_STS_ERROR;

361: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
362:
363: IF (l_rpt_prod_book_type_code = l_tax_book_1) THEN
364: -- l_rpt_prod_book_type_code and Tax Book 1 cannot be the same.
365: l_return_status := OKL_API.G_RET_STS_ERROR;
366: OKL_API.set_message(p_app_name => 'OKL',
367: p_msg_name => 'OKL_AM_TAX_BOOK_2_DUPLICATE',
368: p_token1 => 'TAX_BOOK2',
369: p_token1_value => l_tax_book_name_1);

Line 366: OKL_API.set_message(p_app_name => 'OKL',

362:
363: IF (l_rpt_prod_book_type_code = l_tax_book_1) THEN
364: -- l_rpt_prod_book_type_code and Tax Book 1 cannot be the same.
365: l_return_status := OKL_API.G_RET_STS_ERROR;
366: OKL_API.set_message(p_app_name => 'OKL',
367: p_msg_name => 'OKL_AM_TAX_BOOK_2_DUPLICATE',
368: p_token1 => 'TAX_BOOK2',
369: p_token1_value => l_tax_book_name_1);
370: END IF;

Line 374: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN

370: END IF;
371: END IF;
372:
373:
374: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
375:
376: IF (l_rpt_prod_book_type_code = l_tax_book_2) THEN
377: -- l_rpt_prod_book_type_code and Tax Book 2 cannot be the same.
378: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 378: l_return_status := OKL_API.G_RET_STS_ERROR;

374: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
375:
376: IF (l_rpt_prod_book_type_code = l_tax_book_2) THEN
377: -- l_rpt_prod_book_type_code and Tax Book 2 cannot be the same.
378: l_return_status := OKL_API.G_RET_STS_ERROR;
379: OKL_API.set_message(p_app_name => 'OKL',
380: p_msg_name => 'OKL_AM_TAX_BOOK_2_DUPLICATE',
381: p_token1 => 'TAX_BOOK2',
382: p_token1_value => l_tax_book_name_2);

Line 379: OKL_API.set_message(p_app_name => 'OKL',

375:
376: IF (l_rpt_prod_book_type_code = l_tax_book_2) THEN
377: -- l_rpt_prod_book_type_code and Tax Book 2 cannot be the same.
378: l_return_status := OKL_API.G_RET_STS_ERROR;
379: OKL_API.set_message(p_app_name => 'OKL',
380: p_msg_name => 'OKL_AM_TAX_BOOK_2_DUPLICATE',
381: p_token1 => 'TAX_BOOK2',
382: p_token1_value => l_tax_book_name_2);
383: END IF;

Line 389: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN

385:
386: END IF;
387: */
388: -- no duplicate tax books
389: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
390:
391: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
392:
393: IF (l_tax_book_1 = l_tax_book_2) THEN

Line 391: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN

387: */
388: -- no duplicate tax books
389: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
390:
391: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
392:
393: IF (l_tax_book_1 = l_tax_book_2) THEN
394: -- Tax Book1 and Tax Book 2 cannot be the same.
395: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 395: l_return_status := OKL_API.G_RET_STS_ERROR;

391: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
392:
393: IF (l_tax_book_1 = l_tax_book_2) THEN
394: -- Tax Book1 and Tax Book 2 cannot be the same.
395: l_return_status := OKL_API.G_RET_STS_ERROR;
396: OKL_API.set_message(p_app_name => 'OKL',
397: p_msg_name => 'OKL_AM_TAX_BOOK_2_DUPLICATE',
398: p_token1 => 'TAX_BOOK2',
399: p_token1_value => l_tax_book_name_2);

Line 396: OKL_API.set_message(p_app_name => 'OKL',

392:
393: IF (l_tax_book_1 = l_tax_book_2) THEN
394: -- Tax Book1 and Tax Book 2 cannot be the same.
395: l_return_status := OKL_API.G_RET_STS_ERROR;
396: OKL_API.set_message(p_app_name => 'OKL',
397: p_msg_name => 'OKL_AM_TAX_BOOK_2_DUPLICATE',
398: p_token1 => 'TAX_BOOK2',
399: p_token1_value => l_tax_book_name_2);
400: END IF;

Line 405: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

401: END IF;
402:
403: END IF;
404:
405: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
406: RAISE G_EXCEPTION_HALT_VALIDATION;
407: -- RAISE G_EXCEPTION_ERROR;
408: END IF;
409:

Line 426: l_return_status := OKL_API.G_RET_STS_ERROR;

422: l_tax_book_2 IS NOT NULL
423: THEN
424: IF l_sec_rep_method <> 'NOT_APPLICABLE' THEN
425: IF l_tax_book_1 <> l_rpt_book_type AND l_tax_book_2 <> l_rpt_book_type THEN
426: l_return_status := OKL_API.G_RET_STS_ERROR;
427: OKL_API.set_message(p_app_name => 'OKL',
428: p_msg_name => 'OKL_AM_RPT_PROD_AST_BOOK');
429: END IF;
430: END IF;

Line 427: OKL_API.set_message(p_app_name => 'OKL',

423: THEN
424: IF l_sec_rep_method <> 'NOT_APPLICABLE' THEN
425: IF l_tax_book_1 <> l_rpt_book_type AND l_tax_book_2 <> l_rpt_book_type THEN
426: l_return_status := OKL_API.G_RET_STS_ERROR;
427: OKL_API.set_message(p_app_name => 'OKL',
428: p_msg_name => 'OKL_AM_RPT_PROD_AST_BOOK');
429: END IF;
430: END IF;
431: END IF;

Line 432: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

428: p_msg_name => 'OKL_AM_RPT_PROD_AST_BOOK');
429: END IF;
430: END IF;
431: END IF;
432: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
433: RAISE G_EXCEPTION_HALT_VALIDATION;
434: END IF;
435: --END #8570053
436:

Line 480: OKL_API.end_activity (x_msg_count, x_msg_data);

476:
477: x_return_status := l_return_status;
478:
479: -- End Activity
480: OKL_API.end_activity (x_msg_count, x_msg_data);
481:
482: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
484: 'OKL_AM_SYSTEM_PARAMS_PVT.process_system_params',

Line 496: x_return_status := OKL_API.handle_exceptions(

492: IF c_tax_book_csr%ISOPEN THEN
493: CLOSE c_tax_book_csr;
494: END IF;
495:
496: x_return_status := OKL_API.handle_exceptions(
497: p_api_name => l_api_name,
498: p_pkg_name => G_PKG_NAME,
499: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
500: x_msg_count => x_msg_count,

Line 499: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

495:
496: x_return_status := OKL_API.handle_exceptions(
497: p_api_name => l_api_name,
498: p_pkg_name => G_PKG_NAME,
499: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
500: x_msg_count => x_msg_count,
501: x_msg_data => x_msg_data,
502: p_api_type => '_PVT');
503:

Line 516: x_return_status := OKL_API.handle_exceptions(

512: IF c_tax_book_csr%ISOPEN THEN
513: CLOSE c_tax_book_csr;
514: END IF;
515:
516: x_return_status := OKL_API.handle_exceptions(
517: p_api_name => l_api_name,
518: p_pkg_name => G_PKG_NAME,
519: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
520: x_msg_count => x_msg_count,

Line 519: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

515:
516: x_return_status := OKL_API.handle_exceptions(
517: p_api_name => l_api_name,
518: p_pkg_name => G_PKG_NAME,
519: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
520: x_msg_count => x_msg_count,
521: x_msg_data => x_msg_data,
522: p_api_type => '_PVT');
523:

Line 535: x_return_status := OKL_API.handle_exceptions(

531: IF c_tax_book_csr%ISOPEN THEN
532: CLOSE c_tax_book_csr;
533: END IF;
534:
535: x_return_status := OKL_API.handle_exceptions(
536: p_api_name => l_api_name,
537: p_pkg_name => G_PKG_NAME,
538: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
539: x_msg_count => x_msg_count,

Line 538: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

534:
535: x_return_status := OKL_API.handle_exceptions(
536: p_api_name => l_api_name,
537: p_pkg_name => G_PKG_NAME,
538: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
539: x_msg_count => x_msg_count,
540: x_msg_data => x_msg_data,
541: p_api_type => '_PVT');
542:

Line 554: x_return_status := OKL_API.handle_exceptions(

550: IF c_tax_book_csr%ISOPEN THEN
551: CLOSE c_tax_book_csr;
552: END IF;
553:
554: x_return_status := OKL_API.handle_exceptions(
555: p_api_name => l_api_name,
556: p_pkg_name => G_PKG_NAME,
557: p_exc_name => 'OTHERS',
558: x_msg_count => x_msg_count,