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 76: l_return_status := OKL_API.start_activity(

72: 'Begin(+)');
73: END IF;
74:
75: -- Check API version, initialize message list and create savepoint
76: l_return_status := OKL_API.start_activity(
77: p_api_name => l_api_name,
78: p_pkg_name => G_PKG_NAME,
79: p_init_msg_list => p_init_msg_list,
80: l_api_version => l_api_version,

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

122: l_rpt_prod_book_type_code := p_sypv_rec.RPT_PROD_BOOK_TYPE_CODE;
123:
124:
125: -- Tax Book 1 is NOT NULL, others are NULL
126: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
127:
128: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
129: THEN
130: l_return_status := OKL_API.G_RET_STS_ERROR;

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

124:
125: -- Tax Book 1 is NOT NULL, others are NULL
126: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
127:
128: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
129: THEN
130: l_return_status := OKL_API.G_RET_STS_ERROR;
131: -- Asset Addition Corporate Book cannot be NULL.
132: OKL_API.set_message( p_app_name => 'OKL',

Line 130: l_return_status := OKL_API.G_RET_STS_ERROR;

126: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
127:
128: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
129: THEN
130: l_return_status := OKL_API.G_RET_STS_ERROR;
131: -- Asset Addition Corporate Book cannot be NULL.
132: OKL_API.set_message( p_app_name => 'OKL',
133: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
134: END IF;

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

128: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
129: THEN
130: l_return_status := OKL_API.G_RET_STS_ERROR;
131: -- Asset Addition Corporate Book cannot be NULL.
132: OKL_API.set_message( p_app_name => 'OKL',
133: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
134: END IF;
135:
136:

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

133: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
134: END IF;
135:
136:
137: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
138: THEN
139: l_return_status := OKL_API.G_RET_STS_ERROR;
140: -- l_fa_location_id cannot be NULL.
141: OKL_API.set_message( p_app_name => 'OKL',

Line 139: l_return_status := OKL_API.G_RET_STS_ERROR;

135:
136:
137: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
138: THEN
139: l_return_status := OKL_API.G_RET_STS_ERROR;
140: -- l_fa_location_id cannot be NULL.
141: OKL_API.set_message( p_app_name => 'OKL',
142: p_msg_name => 'OKL_AM_FA_LOCATION_ID_MISSING');
143: END IF;

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

137: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
138: THEN
139: l_return_status := OKL_API.G_RET_STS_ERROR;
140: -- l_fa_location_id cannot be NULL.
141: OKL_API.set_message( p_app_name => 'OKL',
142: p_msg_name => 'OKL_AM_FA_LOCATION_ID_MISSING');
143: END IF;
144:
145: END IF;

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

143: END IF;
144:
145: END IF;
146:
147: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
148: RAISE G_EXCEPTION_HALT_VALIDATION;
149: -- RAISE G_EXCEPTION_ERROR;
150: END IF;
151:

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

149: -- RAISE G_EXCEPTION_ERROR;
150: END IF;
151:
152: -- LOCATION_ID is NOT NULL, others are NULL
153: IF (l_fa_location_id IS NOT NULL AND l_fa_location_id <> OKL_API.G_MISS_NUM) THEN
154:
155: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
156: THEN
157: l_return_status := OKL_API.G_RET_STS_ERROR;

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

151:
152: -- LOCATION_ID is NOT NULL, others are NULL
153: IF (l_fa_location_id IS NOT NULL AND l_fa_location_id <> OKL_API.G_MISS_NUM) THEN
154:
155: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
156: THEN
157: l_return_status := OKL_API.G_RET_STS_ERROR;
158: -- Asset Addition Corporate Book cannot be NULL.
159: OKL_API.set_message( p_app_name => 'OKL',

Line 157: l_return_status := OKL_API.G_RET_STS_ERROR;

153: IF (l_fa_location_id IS NOT NULL AND l_fa_location_id <> OKL_API.G_MISS_NUM) THEN
154:
155: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
156: THEN
157: l_return_status := OKL_API.G_RET_STS_ERROR;
158: -- Asset Addition Corporate Book cannot be NULL.
159: OKL_API.set_message( p_app_name => 'OKL',
160: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
161: END IF;

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

155: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
156: THEN
157: l_return_status := OKL_API.G_RET_STS_ERROR;
158: -- Asset Addition Corporate Book cannot be NULL.
159: OKL_API.set_message( p_app_name => 'OKL',
160: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
161: END IF;
162:
163: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

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

159: OKL_API.set_message( p_app_name => 'OKL',
160: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
161: END IF;
162:
163: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
164: THEN
165: l_return_status := OKL_API.G_RET_STS_ERROR;
166: -- l_tax_book_1 cannot be NULL.
167: OKL_API.set_message( p_app_name => 'OKL',

Line 165: l_return_status := OKL_API.G_RET_STS_ERROR;

161: END IF;
162:
163: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
164: THEN
165: l_return_status := OKL_API.G_RET_STS_ERROR;
166: -- l_tax_book_1 cannot be NULL.
167: OKL_API.set_message( p_app_name => 'OKL',
168: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
169: END IF;

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

163: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
164: THEN
165: l_return_status := OKL_API.G_RET_STS_ERROR;
166: -- l_tax_book_1 cannot be NULL.
167: OKL_API.set_message( p_app_name => 'OKL',
168: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
169: END IF;
170:
171:

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

170:
171:
172: END IF;
173:
174: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
175: RAISE G_EXCEPTION_HALT_VALIDATION;
176: -- RAISE G_EXCEPTION_ERROR;
177: END IF;
178:

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

176: -- RAISE G_EXCEPTION_ERROR;
177: END IF;
178:
179: -- ASSET KEY is NOT NULL, others are NULL
180: IF (l_asset_key_id IS NOT NULL AND l_asset_key_id <> OKL_API.G_MISS_NUM) THEN
181:
182: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
183: THEN
184: l_return_status := OKL_API.G_RET_STS_ERROR;

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

178:
179: -- ASSET KEY is NOT NULL, others are NULL
180: IF (l_asset_key_id IS NOT NULL AND l_asset_key_id <> OKL_API.G_MISS_NUM) THEN
181:
182: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
183: THEN
184: l_return_status := OKL_API.G_RET_STS_ERROR;
185: -- Asset Addition Corporate Book cannot be NULL.
186: OKL_API.set_message( p_app_name => 'OKL',

Line 184: l_return_status := OKL_API.G_RET_STS_ERROR;

180: IF (l_asset_key_id IS NOT NULL AND l_asset_key_id <> OKL_API.G_MISS_NUM) THEN
181:
182: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
183: THEN
184: l_return_status := OKL_API.G_RET_STS_ERROR;
185: -- Asset Addition Corporate Book cannot be NULL.
186: OKL_API.set_message( p_app_name => 'OKL',
187: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
188: END IF;

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

182: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
183: THEN
184: l_return_status := OKL_API.G_RET_STS_ERROR;
185: -- Asset Addition Corporate Book cannot be NULL.
186: OKL_API.set_message( p_app_name => 'OKL',
187: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
188: END IF;
189:
190: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

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

186: OKL_API.set_message( p_app_name => 'OKL',
187: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
188: END IF;
189:
190: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
191: THEN
192: l_return_status := OKL_API.G_RET_STS_ERROR;
193: -- l_tax_book_1 cannot be NULL.
194: OKL_API.set_message( p_app_name => 'OKL',

Line 192: l_return_status := OKL_API.G_RET_STS_ERROR;

188: END IF;
189:
190: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
191: THEN
192: l_return_status := OKL_API.G_RET_STS_ERROR;
193: -- l_tax_book_1 cannot be NULL.
194: OKL_API.set_message( p_app_name => 'OKL',
195: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
196: END IF;

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

190: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
191: THEN
192: l_return_status := OKL_API.G_RET_STS_ERROR;
193: -- l_tax_book_1 cannot be NULL.
194: OKL_API.set_message( p_app_name => 'OKL',
195: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
196: END IF;
197:
198: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)

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

194: OKL_API.set_message( p_app_name => 'OKL',
195: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
196: END IF;
197:
198: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
199: THEN
200: l_return_status := OKL_API.G_RET_STS_ERROR;
201: -- l_fa_location_id cannot be NULL.
202: OKL_API.set_message( p_app_name => 'OKL',

Line 200: l_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

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

205: END IF;
206:
207: END IF;
208:
209: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
210: RAISE G_EXCEPTION_HALT_VALIDATION;
211: -- RAISE G_EXCEPTION_ERROR;
212: END IF;
213:

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

212: END IF;
213:
214: -- FORMULA_ID is NOT NULL, others are NULL
215:
216: IF (l_formula_id IS NOT NULL AND l_formula_id <> OKL_API.G_MISS_NUM) THEN
217:
218: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
219: THEN
220: l_return_status := OKL_API.G_RET_STS_ERROR;

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

214: -- FORMULA_ID is NOT NULL, others are NULL
215:
216: IF (l_formula_id IS NOT NULL AND l_formula_id <> OKL_API.G_MISS_NUM) THEN
217:
218: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
219: THEN
220: l_return_status := OKL_API.G_RET_STS_ERROR;
221: -- Asset Addition Corporate Book cannot be NULL.
222: OKL_API.set_message( p_app_name => 'OKL',

Line 220: l_return_status := OKL_API.G_RET_STS_ERROR;

216: IF (l_formula_id IS NOT NULL AND l_formula_id <> OKL_API.G_MISS_NUM) THEN
217:
218: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
219: THEN
220: l_return_status := OKL_API.G_RET_STS_ERROR;
221: -- Asset Addition Corporate Book cannot be NULL.
222: OKL_API.set_message( p_app_name => 'OKL',
223: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
224: END IF;

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

218: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
219: THEN
220: l_return_status := OKL_API.G_RET_STS_ERROR;
221: -- Asset Addition Corporate Book cannot be NULL.
222: OKL_API.set_message( p_app_name => 'OKL',
223: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
224: END IF;
225:
226: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

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

222: OKL_API.set_message( p_app_name => 'OKL',
223: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
224: END IF;
225:
226: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
227: THEN
228: l_return_status := OKL_API.G_RET_STS_ERROR;
229: -- l_tax_book_1 cannot be NULL.
230: OKL_API.set_message( p_app_name => 'OKL',

Line 228: l_return_status := OKL_API.G_RET_STS_ERROR;

224: END IF;
225:
226: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
227: THEN
228: l_return_status := OKL_API.G_RET_STS_ERROR;
229: -- l_tax_book_1 cannot be NULL.
230: OKL_API.set_message( p_app_name => 'OKL',
231: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
232: END IF;

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

226: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
227: THEN
228: l_return_status := OKL_API.G_RET_STS_ERROR;
229: -- l_tax_book_1 cannot be NULL.
230: OKL_API.set_message( p_app_name => 'OKL',
231: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
232: END IF;
233:
234:

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

231: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
232: END IF;
233:
234:
235: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
236: THEN
237: l_return_status := OKL_API.G_RET_STS_ERROR;
238: -- l_fa_location_id cannot be NULL.
239: OKL_API.set_message( p_app_name => 'OKL',

Line 237: l_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

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

243:
244:
245: END IF;
246:
247: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
248: RAISE G_EXCEPTION_HALT_VALIDATION;
249: -- RAISE G_EXCEPTION_ERROR;
250: END IF;
251:

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

250: END IF;
251:
252: -- TAX BOOK 2 is NOT NULL, others are NULL
253:
254: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
255:
256: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
257: THEN
258: l_return_status := OKL_API.G_RET_STS_ERROR;

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

252: -- TAX BOOK 2 is NOT NULL, others are NULL
253:
254: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
255:
256: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
257: THEN
258: l_return_status := OKL_API.G_RET_STS_ERROR;
259: -- Asset Addition Corporate Book cannot be NULL.
260: OKL_API.set_message( p_app_name => 'OKL',

Line 258: l_return_status := OKL_API.G_RET_STS_ERROR;

254: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
255:
256: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
257: THEN
258: l_return_status := OKL_API.G_RET_STS_ERROR;
259: -- Asset Addition Corporate Book cannot be NULL.
260: OKL_API.set_message( p_app_name => 'OKL',
261: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
262: END IF;

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

256: IF ( l_asst_add_book_type_code IS NULL OR l_asst_add_book_type_code = OKL_API.G_MISS_CHAR)
257: THEN
258: l_return_status := OKL_API.G_RET_STS_ERROR;
259: -- Asset Addition Corporate Book cannot be NULL.
260: OKL_API.set_message( p_app_name => 'OKL',
261: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
262: END IF;
263:
264: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)

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

260: OKL_API.set_message( p_app_name => 'OKL',
261: p_msg_name => 'OKL_AM_CORPORATE_BOOK_MISSING');
262: END IF;
263:
264: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
265: THEN
266: l_return_status := OKL_API.G_RET_STS_ERROR;
267: -- l_tax_book_1 cannot be NULL.
268: OKL_API.set_message( p_app_name => 'OKL',

Line 266: l_return_status := OKL_API.G_RET_STS_ERROR;

262: END IF;
263:
264: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
265: THEN
266: l_return_status := OKL_API.G_RET_STS_ERROR;
267: -- l_tax_book_1 cannot be NULL.
268: OKL_API.set_message( p_app_name => 'OKL',
269: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
270: END IF;

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

264: IF (l_tax_book_1 IS NULL OR l_tax_book_1 = OKL_API.G_MISS_CHAR)
265: THEN
266: l_return_status := OKL_API.G_RET_STS_ERROR;
267: -- l_tax_book_1 cannot be NULL.
268: OKL_API.set_message( p_app_name => 'OKL',
269: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
270: END IF;
271:
272: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)

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

268: OKL_API.set_message( p_app_name => 'OKL',
269: p_msg_name => 'OKL_AM_TAX_BOOK_1_MISSING');
270: END IF;
271:
272: IF (l_fa_location_id IS NULL OR l_fa_location_id = OKL_API.G_MISS_NUM)
273: THEN
274: l_return_status := OKL_API.G_RET_STS_ERROR;
275: -- l_fa_location_id cannot be NULL.
276: OKL_API.set_message( p_app_name => 'OKL',

Line 274: l_return_status := OKL_API.G_RET_STS_ERROR;

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

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

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

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

280:
281:
282: END IF;
283:
284: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
285: RAISE G_EXCEPTION_HALT_VALIDATION;
286: -- RAISE G_EXCEPTION_ERROR;
287: END IF;
288:

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

299: OPEN c_tax_book_name_csr (l_tax_book_2);
300: FETCH c_tax_book_name_csr INTO l_tax_book_name_2;
301: CLOSE c_tax_book_name_csr;
302:
303: IF ( l_asst_add_book_type_code IS NOT NULL AND l_asst_add_book_type_code <> OKL_API.G_MISS_CHAR) THEN
304: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
305: OPEN c_tax_book_csr (l_asst_add_book_type_code, l_tax_book_1);
306: FETCH c_tax_book_csr INTO l_tax_1;
307: IF c_tax_book_csr%NOTFOUND THEN

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

300: FETCH c_tax_book_name_csr INTO l_tax_book_name_2;
301: CLOSE c_tax_book_name_csr;
302:
303: IF ( l_asst_add_book_type_code IS NOT NULL AND l_asst_add_book_type_code <> OKL_API.G_MISS_CHAR) THEN
304: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
305: OPEN c_tax_book_csr (l_asst_add_book_type_code, l_tax_book_1);
306: FETCH c_tax_book_csr INTO l_tax_1;
307: IF c_tax_book_csr%NOTFOUND THEN
308:

Line 309: l_return_status := OKL_API.G_RET_STS_ERROR;

305: OPEN c_tax_book_csr (l_asst_add_book_type_code, l_tax_book_1);
306: FETCH c_tax_book_csr INTO l_tax_1;
307: IF c_tax_book_csr%NOTFOUND THEN
308:
309: l_return_status := OKL_API.G_RET_STS_ERROR;
310: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
311: p_msg_name => 'OKL_AM_INVALID_TAX_BOOK',
312: p_token1 => 'TAX_BOOK',
313: p_token1_value => l_tax_book_name_1,

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

306: FETCH c_tax_book_csr INTO l_tax_1;
307: IF c_tax_book_csr%NOTFOUND THEN
308:
309: l_return_status := OKL_API.G_RET_STS_ERROR;
310: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
311: p_msg_name => 'OKL_AM_INVALID_TAX_BOOK',
312: p_token1 => 'TAX_BOOK',
313: p_token1_value => l_tax_book_name_1,
314: p_token2 => 'CORPORATE_BOOK',

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

317: END IF;
318: CLOSE c_tax_book_csr;
319: END IF;
320:
321: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
322: OPEN c_tax_book_csr (l_asst_add_book_type_code, l_tax_book_2);
323: FETCH c_tax_book_csr INTO l_tax_2;
324: IF c_tax_book_csr%NOTFOUND THEN
325:

Line 326: l_return_status := OKL_API.G_RET_STS_ERROR;

322: OPEN c_tax_book_csr (l_asst_add_book_type_code, l_tax_book_2);
323: FETCH c_tax_book_csr INTO l_tax_2;
324: IF c_tax_book_csr%NOTFOUND THEN
325:
326: l_return_status := OKL_API.G_RET_STS_ERROR;
327: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
328: p_msg_name => 'OKL_AM_INVALID_TAX_BOOK',
329: p_token1 => 'TAX_BOOK',
330: p_token1_value => l_tax_book_name_2,

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

323: FETCH c_tax_book_csr INTO l_tax_2;
324: IF c_tax_book_csr%NOTFOUND THEN
325:
326: l_return_status := OKL_API.G_RET_STS_ERROR;
327: OKL_API.SET_MESSAGE(p_app_name => 'OKL',
328: p_msg_name => 'OKL_AM_INVALID_TAX_BOOK',
329: p_token1 => 'TAX_BOOK',
330: p_token1_value => l_tax_book_name_2,
331: p_token2 => 'CORPORATE_BOOK',

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

336:
337: END IF;
338: END IF;
339:
340: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
341: RAISE G_EXCEPTION_HALT_VALIDATION;
342: -- RAISE G_EXCEPTION_ERROR;
343: END IF;
344:

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

342: -- RAISE G_EXCEPTION_ERROR;
343: END IF;
344:
345: -- no duplicate l_rpt_prod_book_type_code and tax book 1 and Tax Book 2
346: IF (l_rpt_prod_book_type_code IS NOT NULL AND l_rpt_prod_book_type_code <> OKL_API.G_MISS_CHAR) THEN
347:
348: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
349:
350: IF (l_rpt_prod_book_type_code = l_tax_book_1) THEN

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

344:
345: -- no duplicate l_rpt_prod_book_type_code and tax book 1 and Tax Book 2
346: IF (l_rpt_prod_book_type_code IS NOT NULL AND l_rpt_prod_book_type_code <> OKL_API.G_MISS_CHAR) THEN
347:
348: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
349:
350: IF (l_rpt_prod_book_type_code = l_tax_book_1) THEN
351: -- l_rpt_prod_book_type_code and Tax Book 1 cannot be the same.
352: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 352: l_return_status := OKL_API.G_RET_STS_ERROR;

348: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
349:
350: IF (l_rpt_prod_book_type_code = l_tax_book_1) THEN
351: -- l_rpt_prod_book_type_code and Tax Book 1 cannot be the same.
352: l_return_status := OKL_API.G_RET_STS_ERROR;
353: OKL_API.set_message(p_app_name => 'OKL',
354: p_msg_name => 'OKL_AM_TAX_BOOK_2_DUPLICATE',
355: p_token1 => 'TAX_BOOK2',
356: p_token1_value => l_tax_book_name_1);

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

349:
350: IF (l_rpt_prod_book_type_code = l_tax_book_1) THEN
351: -- l_rpt_prod_book_type_code and Tax Book 1 cannot be the same.
352: l_return_status := OKL_API.G_RET_STS_ERROR;
353: OKL_API.set_message(p_app_name => 'OKL',
354: p_msg_name => 'OKL_AM_TAX_BOOK_2_DUPLICATE',
355: p_token1 => 'TAX_BOOK2',
356: p_token1_value => l_tax_book_name_1);
357: END IF;

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

357: END IF;
358: END IF;
359:
360:
361: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
362:
363: IF (l_rpt_prod_book_type_code = l_tax_book_2) THEN
364: -- l_rpt_prod_book_type_code and Tax Book 2 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_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
362:
363: IF (l_rpt_prod_book_type_code = l_tax_book_2) THEN
364: -- l_rpt_prod_book_type_code and Tax Book 2 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_2);

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

362:
363: IF (l_rpt_prod_book_type_code = l_tax_book_2) THEN
364: -- l_rpt_prod_book_type_code and Tax Book 2 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_2);
370: END IF;

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

372:
373: END IF;
374:
375: -- no duplicate tax books
376: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
377:
378: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
379:
380: IF (l_tax_book_1 = l_tax_book_2) THEN

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

374:
375: -- no duplicate tax books
376: IF (l_tax_book_1 IS NOT NULL AND l_tax_book_1 <> OKL_API.G_MISS_CHAR) THEN
377:
378: IF (l_tax_book_2 IS NOT NULL AND l_tax_book_2 <> OKL_API.G_MISS_CHAR) THEN
379:
380: IF (l_tax_book_1 = l_tax_book_2) THEN
381: -- Tax Book1 and Tax Book 2 cannot be the same.
382: l_return_status := OKL_API.G_RET_STS_ERROR;

Line 382: l_return_status := OKL_API.G_RET_STS_ERROR;

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

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

379:
380: IF (l_tax_book_1 = l_tax_book_2) THEN
381: -- Tax Book1 and Tax Book 2 cannot be the same.
382: l_return_status := OKL_API.G_RET_STS_ERROR;
383: OKL_API.set_message(p_app_name => 'OKL',
384: p_msg_name => 'OKL_AM_TAX_BOOK_2_DUPLICATE',
385: p_token1 => 'TAX_BOOK2',
386: p_token1_value => l_tax_book_name_2);
387: END IF;

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

388: END IF;
389:
390: END IF;
391:
392: IF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
393: RAISE G_EXCEPTION_HALT_VALIDATION;
394: -- RAISE G_EXCEPTION_ERROR;
395: END IF;
396:

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

439:
440: x_return_status := l_return_status;
441:
442: -- End Activity
443: OKL_API.end_activity (x_msg_count, x_msg_data);
444:
445: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
446: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
447: 'OKL_AM_SYSTEM_PARAMS_PVT.process_system_params',

Line 459: x_return_status := OKL_API.handle_exceptions(

455: IF c_tax_book_csr%ISOPEN THEN
456: CLOSE c_tax_book_csr;
457: END IF;
458:
459: x_return_status := OKL_API.handle_exceptions(
460: p_api_name => l_api_name,
461: p_pkg_name => G_PKG_NAME,
462: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
463: x_msg_count => x_msg_count,

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

458:
459: x_return_status := OKL_API.handle_exceptions(
460: p_api_name => l_api_name,
461: p_pkg_name => G_PKG_NAME,
462: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data,
465: p_api_type => '_PVT');
466:

Line 479: x_return_status := OKL_API.handle_exceptions(

475: IF c_tax_book_csr%ISOPEN THEN
476: CLOSE c_tax_book_csr;
477: END IF;
478:
479: x_return_status := OKL_API.handle_exceptions(
480: p_api_name => l_api_name,
481: p_pkg_name => G_PKG_NAME,
482: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
483: x_msg_count => x_msg_count,

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

478:
479: x_return_status := OKL_API.handle_exceptions(
480: p_api_name => l_api_name,
481: p_pkg_name => G_PKG_NAME,
482: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
483: x_msg_count => x_msg_count,
484: x_msg_data => x_msg_data,
485: p_api_type => '_PVT');
486:

Line 498: x_return_status := OKL_API.handle_exceptions(

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

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

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

Line 517: x_return_status := OKL_API.handle_exceptions(

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