APPS.CST_PENDINGTXNSREPORT_PVT dependencies on FND_API

Line 115: p_init_msg_list => FND_API.G_FALSE,

111: /* Add Parameters */
112:
113: l_stmt_num := 20;
114: add_parameters (p_api_version => 1.0,
115: p_init_msg_list => FND_API.G_FALSE,
116: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
117: x_return_status => l_return_status,
118: x_msg_count => l_msg_count,
119: x_msg_data => l_msg_data,

Line 116: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

112:
113: l_stmt_num := 20;
114: add_parameters (p_api_version => 1.0,
115: p_init_msg_list => FND_API.G_FALSE,
116: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
117: x_return_status => l_return_status,
118: x_msg_count => l_msg_count,
119: x_msg_data => l_msg_data,
120: i_org_id => p_org_id,

Line 126: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

122: i_resolution_type => p_resolution_type,
123: i_transaction_type => p_transaction_type,
124: x_xml_doc => l_xml_doc);
125:
126: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: /* Validate which transactions need to be added for the parameter values */

Line 127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

123: i_transaction_type => p_transaction_type,
124: x_xml_doc => l_xml_doc);
125:
126: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
127: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
128: END IF;
129:
130: /* Validate which transactions need to be added for the parameter values */
131:

Line 141: p_init_msg_list => FND_API.G_FALSE,

137: THEN
138: l_stmt_num := 30;
139: /* Transaction Type: All or Unprocessed MTL TRX */
140: unprocessed_mtl_trx (p_api_version => 1.0,
141: p_init_msg_list => FND_API.G_FALSE,
142: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
143: x_return_status => l_return_status,
144: x_msg_count => l_msg_count,
145: x_msg_data => l_msg_data,

Line 142: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

138: l_stmt_num := 30;
139: /* Transaction Type: All or Unprocessed MTL TRX */
140: unprocessed_mtl_trx (p_api_version => 1.0,
141: p_init_msg_list => FND_API.G_FALSE,
142: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
143: x_return_status => l_return_status,
144: x_msg_count => l_msg_count,
145: x_msg_data => l_msg_data,
146: i_period_end_date => l_period_end_date,

Line 153: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

149: x_xml_doc => l_xml_doc);
150:
151: l_record_count := l_record_count + l_temp_count;
152:
153: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156: END IF;
157:

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150:
151: l_record_count := l_record_count + l_temp_count;
152:
153: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156: END IF;
157:
158: IF (nvl(p_transaction_type,1) = 1 OR nvl(p_transaction_type,1) = 3)

Line 163: p_init_msg_list => FND_API.G_FALSE,

159: THEN
160: /* Transaction Type: All or Uncosted MTL TRX */
161: l_stmt_num := 40;
162: uncosted_mtl_trx(p_api_version => 1.0,
163: p_init_msg_list => FND_API.G_FALSE,
164: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
165: x_return_status => l_return_status,
166: x_msg_count => l_msg_count,
167: x_msg_data => l_msg_data,

Line 164: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

160: /* Transaction Type: All or Uncosted MTL TRX */
161: l_stmt_num := 40;
162: uncosted_mtl_trx(p_api_version => 1.0,
163: p_init_msg_list => FND_API.G_FALSE,
164: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
165: x_return_status => l_return_status,
166: x_msg_count => l_msg_count,
167: x_msg_data => l_msg_data,
168: i_period_end_date => l_period_end_date,

Line 175: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

171: x_xml_doc => l_xml_doc);
172:
173: l_record_count := l_record_count + l_temp_count;
174:
175: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
178: END IF;
179:

Line 176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

172:
173: l_record_count := l_record_count + l_temp_count;
174:
175: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177: END IF;
178: END IF;
179:
180: IF (nvl(p_transaction_type,1) = 1 OR nvl(p_transaction_type,1) = 4)

Line 185: p_init_msg_list => FND_API.G_FALSE,

181: THEN
182: /* Transaction Type: All or Uncosted WIP TRX */
183: l_stmt_num := 50;
184: uncosted_wip_trx (p_api_version => 1.0,
185: p_init_msg_list => FND_API.G_FALSE,
186: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
187: x_return_status => l_return_status,
188: x_msg_count => l_msg_count,
189: x_msg_data => l_msg_data,

Line 186: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,

182: /* Transaction Type: All or Uncosted WIP TRX */
183: l_stmt_num := 50;
184: uncosted_wip_trx (p_api_version => 1.0,
185: p_init_msg_list => FND_API.G_FALSE,
186: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
187: x_return_status => l_return_status,
188: x_msg_count => l_msg_count,
189: x_msg_data => l_msg_data,
190: i_period_end_date => l_period_end_date,

Line 197: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

193: x_xml_doc => l_xml_doc);
194:
195: l_record_count := l_record_count + l_temp_count;
196:
197: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200: END IF;
201:

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194:
195: l_record_count := l_record_count + l_temp_count;
196:
197: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: END IF;
200: END IF;
201:
202: IF (nvl(p_transaction_type,1) = 1 or nvl(p_transaction_type,1) = 5)

Line 207: p_init_msg_list => FND_API.G_FALSE,

203: THEN
204: /* Transaction Type: All or Pending WSM TRX */
205: l_stmt_num := 60;
206: pending_wsm_trx (p_api_version => 1.0,
207: p_init_msg_list => FND_API.G_FALSE,
208: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
209: x_return_status => l_return_status,
210: x_msg_count => l_msg_count,
211: x_msg_data => l_msg_data,

Line 208: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

204: /* Transaction Type: All or Pending WSM TRX */
205: l_stmt_num := 60;
206: pending_wsm_trx (p_api_version => 1.0,
207: p_init_msg_list => FND_API.G_FALSE,
208: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
209: x_return_status => l_return_status,
210: x_msg_count => l_msg_count,
211: x_msg_data => l_msg_data,
212: i_period_end_date => l_period_end_date,

Line 219: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

215: x_xml_doc => l_xml_doc);
216:
217: l_record_count := l_record_count + l_temp_count;
218:
219: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222: END IF;
223:

Line 220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

216:
217: l_record_count := l_record_count + l_temp_count;
218:
219: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222: END IF;
223:
224: /*Support for LCM*/

Line 230: p_init_msg_list => FND_API.G_FALSE,

226: THEN
227: /* Transaction Type: All or Pending LCM TRX */
228: l_stmt_num := 60;
229: pending_lcm_trx (p_api_version => 1.0,
230: p_init_msg_list => FND_API.G_FALSE,
231: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
232: x_return_status => l_return_status,
233: x_msg_count => l_msg_count,
234: x_msg_data => l_msg_data,

Line 231: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

227: /* Transaction Type: All or Pending LCM TRX */
228: l_stmt_num := 60;
229: pending_lcm_trx (p_api_version => 1.0,
230: p_init_msg_list => FND_API.G_FALSE,
231: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
232: x_return_status => l_return_status,
233: x_msg_count => l_msg_count,
234: x_msg_data => l_msg_data,
235: i_period_end_date => l_period_end_date,

Line 242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

238: x_xml_doc => l_xml_doc);
239:
240: l_record_count := l_record_count + l_temp_count;
241:
242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245: END IF;
246: END IF;

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239:
240: l_record_count := l_record_count + l_temp_count;
241:
242: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END IF;
245: END IF;
246: END IF;
247:

Line 257: p_init_msg_list => FND_API.G_FALSE,

253: THEN
254: /* Transaction Type: All or Pending RCV TRX */
255: l_stmt_num := 70;
256: pending_rcv_trx (p_api_version => 1.0,
257: p_init_msg_list => FND_API.G_FALSE,
258: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
259: x_return_status => l_return_status,
260: x_msg_count => l_msg_count,
261: x_msg_data => l_msg_data,

Line 258: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

254: /* Transaction Type: All or Pending RCV TRX */
255: l_stmt_num := 70;
256: pending_rcv_trx (p_api_version => 1.0,
257: p_init_msg_list => FND_API.G_FALSE,
258: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
259: x_return_status => l_return_status,
260: x_msg_count => l_msg_count,
261: x_msg_data => l_msg_data,
262: i_period_end_date => l_period_end_date,

Line 269: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

265: x_xml_doc => l_xml_doc);
266:
267: l_record_count := l_record_count + l_temp_count;
268:
269: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272: END IF;
273:

Line 270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

266:
267: l_record_count := l_record_count + l_temp_count;
268:
269: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
271: END IF;
272: END IF;
273:
274: IF (nvl(p_transaction_type,1) = 1 OR nvl(p_transaction_type,1) = 7)

Line 279: p_init_msg_list => FND_API.G_FALSE,

275: THEN
276: /* Transaction Type: All or Pending material interface */
277: l_stmt_num := 80;
278: pending_mtl_interface_trx (p_api_version => 1.0,
279: p_init_msg_list => FND_API.G_FALSE,
280: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
281: x_return_status => l_return_status,
282: x_msg_count => l_msg_count,
283: x_msg_data => l_msg_data,

Line 280: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

276: /* Transaction Type: All or Pending material interface */
277: l_stmt_num := 80;
278: pending_mtl_interface_trx (p_api_version => 1.0,
279: p_init_msg_list => FND_API.G_FALSE,
280: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
281: x_return_status => l_return_status,
282: x_msg_count => l_msg_count,
283: x_msg_data => l_msg_data,
284: i_period_end_date => l_period_end_date,

Line 291: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

287: x_xml_doc => l_xml_doc);
288:
289: l_record_count := l_record_count + l_temp_count;
290:
291: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294: END IF;
295:

Line 292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

288:
289: l_record_count := l_record_count + l_temp_count;
290:
291: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
293: END IF;
294: END IF;
295:
296: IF (nvl(p_transaction_type,1) = 1 OR nvl(p_transaction_type,1) = 8)

Line 301: p_init_msg_list => FND_API.G_FALSE,

297: THEN
298: /* Transaction Type: All or Pending WIP Move trx */
299: l_stmt_num := 90;
300: pending_wip_move_trx (p_api_version => 1.0,
301: p_init_msg_list => FND_API.G_FALSE,
302: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
303: x_return_status => l_return_status,
304: x_msg_count => l_msg_count,
305: x_msg_data => l_msg_data,

Line 302: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

298: /* Transaction Type: All or Pending WIP Move trx */
299: l_stmt_num := 90;
300: pending_wip_move_trx (p_api_version => 1.0,
301: p_init_msg_list => FND_API.G_FALSE,
302: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
303: x_return_status => l_return_status,
304: x_msg_count => l_msg_count,
305: x_msg_data => l_msg_data,
306: i_period_end_date => l_period_end_date,

Line 313: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

309: x_xml_doc => l_xml_doc);
310:
311: l_record_count := l_record_count + l_temp_count;
312:
313: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316: END IF;
317:

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

310:
311: l_record_count := l_record_count + l_temp_count;
312:
313: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: END IF;
316: END IF;
317:
318: IF (nvl(p_transaction_type,1) = 1 OR nvl(p_transaction_type,1) = 9)

Line 323: p_init_msg_list => FND_API.G_FALSE,

319: THEN
320: /* Transaction Type: All or Incomplete workorders */
321: l_stmt_num := 100;
322: incomplete_eam_wo (p_api_version => 1.0,
323: p_init_msg_list => FND_API.G_FALSE,
324: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
325: x_return_status => l_return_status,
326: x_msg_count => l_msg_count,
327: x_msg_data => l_msg_data,

Line 324: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

320: /* Transaction Type: All or Incomplete workorders */
321: l_stmt_num := 100;
322: incomplete_eam_wo (p_api_version => 1.0,
323: p_init_msg_list => FND_API.G_FALSE,
324: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
325: x_return_status => l_return_status,
326: x_msg_count => l_msg_count,
327: x_msg_data => l_msg_data,
328: i_period_end_date => l_period_end_date,

Line 335: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

331: x_xml_doc => l_xml_doc);
332:
333: l_record_count := l_record_count + l_temp_count;
334:
335: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: END IF;
338: END IF;
339: END IF;

Line 336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

332:
333: l_record_count := l_record_count + l_temp_count;
334:
335: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
337: END IF;
338: END IF;
339: END IF;
340:

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

347: x_return_status => l_return_status,
348: x_msg_count => l_msg_count,
349: x_msg_data => l_msg_data);
350: IF (l_return_status <> 0) THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: -- l_shipping_txn_hook = 0 if shipping transactions are resolution required
355: -- = 1 if shipping transactions are resolution recommended

Line 363: p_init_msg_list => FND_API.G_FALSE,

359: THEN
360: /* Transaction Type: All or Pending Shipping trx */
361: l_stmt_num := 120;
362: pending_shipping_trx (p_api_version => 1.0,
363: p_init_msg_list => FND_API.G_FALSE,
364: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
365: x_return_status => l_return_status,
366: x_msg_count => l_msg_count,
367: x_msg_data => l_msg_data,

Line 364: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

360: /* Transaction Type: All or Pending Shipping trx */
361: l_stmt_num := 120;
362: pending_shipping_trx (p_api_version => 1.0,
363: p_init_msg_list => FND_API.G_FALSE,
364: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
365: x_return_status => l_return_status,
366: x_msg_count => l_msg_count,
367: x_msg_data => l_msg_data,
368: i_period_start_date => l_period_start_date,

Line 376: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

372: x_xml_doc => l_xml_doc);
373:
374: l_record_count := l_record_count + l_temp_count;
375:
376: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END IF;
379: END IF;
380:

Line 377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

373:
374: l_record_count := l_record_count + l_temp_count;
375:
376: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
378: END IF;
379: END IF;
380:
381: IF (l_record_count = 0) THEN

Line 418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

414: '<<< ' || l_api_name);
415: END IF;
416:
417: EXCEPTION
418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count,
420: p_data => l_msg_data);
421:
422: CST_UTILITY_PUB.writelogmessages (p_api_version => 1.0,

Line 497: IF NOT FND_API.Compatible_API_Call (l_api_version,

493: '>>> ' || l_api_name);
494: END IF;
495:
496: -- Standard call to check for call compatibility.
497: IF NOT FND_API.Compatible_API_Call (l_api_version,
498: p_api_version,
499: l_api_name,
500: G_PKG_NAME )
501: THEN

Line 502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

498: p_api_version,
499: l_api_name,
500: G_PKG_NAME )
501: THEN
502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
505: -- Initialize message list if p_init_msg_list is set to TRUE.
506: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 506: IF FND_API.to_Boolean( p_init_msg_list ) THEN

502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
503: END IF;
504:
505: -- Initialize message list if p_init_msg_list is set to TRUE.
506: IF FND_API.to_Boolean( p_init_msg_list ) THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: -- Initialize API return status to success

Line 511: x_return_status := FND_API.G_RET_STS_SUCCESS;

507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: -- Initialize API return status to success
511: x_return_status := FND_API.G_RET_STS_SUCCESS;
512:
513: /* Initialize */
514: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
515:

Line 587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

583: l_module || '.end',
584: '<<< ' || l_api_name);
585: END IF;
586: EXCEPTION
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
589: FND_MSG_PUB.Count_And_Get
590: ( p_count => x_msg_count,
591: p_data => x_msg_data

Line 588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

584: '<<< ' || l_api_name);
585: END IF;
586: EXCEPTION
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
589: FND_MSG_PUB.Count_And_Get
590: ( p_count => x_msg_count,
591: p_data => x_msg_data
592: );

Line 594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

590: ( p_count => x_msg_count,
591: p_data => x_msg_data
592: );
593: WHEN OTHERS THEN
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
595: IF (l_uLog) THEN
596: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
597: l_module || '.' || l_stmt_num,
598: SUBSTRB (SQLERRM , 1 , 240));

Line 650: IF NOT FND_API.Compatible_API_Call (l_api_version,

646: '>>> ' || l_api_name);
647: END IF;
648:
649: -- Standard call to check for call compatibility.
650: IF NOT FND_API.Compatible_API_Call (l_api_version,
651: p_api_version,
652: l_api_name,
653: G_PKG_NAME )
654: THEN

Line 655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

651: p_api_version,
652: l_api_name,
653: G_PKG_NAME )
654: THEN
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657: -- Initialize message list if p_init_msg_list is set to TRUE.
658: IF FND_API.to_Boolean( p_init_msg_list ) THEN
659: FND_MSG_PUB.initialize;

Line 658: IF FND_API.to_Boolean( p_init_msg_list ) THEN

654: THEN
655: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
656: END IF;
657: -- Initialize message list if p_init_msg_list is set to TRUE.
658: IF FND_API.to_Boolean( p_init_msg_list ) THEN
659: FND_MSG_PUB.initialize;
660: END IF;
661:
662: -- Initialize API return status to success

Line 663: x_return_status := FND_API.G_RET_STS_SUCCESS;

659: FND_MSG_PUB.initialize;
660: END IF;
661:
662: -- Initialize API return status to success
663: x_return_status := FND_API.G_RET_STS_SUCCESS;
664:
665: /* Initialize */
666: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
667:

Line 774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

770: '<<< ' || l_api_name);
771: END IF;
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
776: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
777: p_data => x_msg_data);
778: WHEN OTHERS THEN

Line 775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

771: END IF;
772:
773: EXCEPTION
774: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
776: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
777: p_data => x_msg_data);
778: WHEN OTHERS THEN
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
776: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
777: p_data => x_msg_data);
778: WHEN OTHERS THEN
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780: IF (l_uLog) THEN
781: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
782: l_module || '.' || l_stmt_num,
783: SUBSTRB (SQLERRM , 1 , 240));

Line 829: IF NOT FND_API.Compatible_API_Call (l_api_version,

825: '>>> ' || l_api_name);
826: END IF;
827:
828: -- Standard call to check for call compatibility.
829: IF NOT FND_API.Compatible_API_Call (l_api_version,
830: p_api_version,
831: l_api_name,
832: G_PKG_NAME)
833: THEN

Line 834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

830: p_api_version,
831: l_api_name,
832: G_PKG_NAME)
833: THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836: -- Initialize message list if p_init_msg_list is set to TRUE.
837: IF FND_API.to_Boolean (p_init_msg_list) THEN
838: FND_MSG_PUB.initialize;

Line 837: IF FND_API.to_Boolean (p_init_msg_list) THEN

833: THEN
834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
835: END IF;
836: -- Initialize message list if p_init_msg_list is set to TRUE.
837: IF FND_API.to_Boolean (p_init_msg_list) THEN
838: FND_MSG_PUB.initialize;
839: END IF;
840:
841: -- Initialize API return status to success

Line 842: x_return_status := FND_API.G_RET_STS_SUCCESS;

838: FND_MSG_PUB.initialize;
839: END IF;
840:
841: -- Initialize API return status to success
842: x_return_status := FND_API.G_RET_STS_SUCCESS;
843:
844: /* Initialize */
845: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
846:

Line 937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

933: l_module || '.end',
934: '<<< ' || l_api_name);
935: END IF;
936: EXCEPTION
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
939: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
940: p_data => x_msg_data);
941: WHEN OTHERS THEN

Line 938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

934: '<<< ' || l_api_name);
935: END IF;
936: EXCEPTION
937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
939: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
940: p_data => x_msg_data);
941: WHEN OTHERS THEN
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
939: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
940: p_data => x_msg_data);
941: WHEN OTHERS THEN
942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
943: IF (l_uLog) THEN
944: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
945: l_module || '.' || l_stmt_num,
946: SUBSTRB (SQLERRM , 1 , 240));

Line 992: IF NOT FND_API.Compatible_API_Call (l_api_version,

988: '>>> ' || l_api_name);
989: END IF;
990:
991: -- Standard call to check for call compatibility.
992: IF NOT FND_API.Compatible_API_Call (l_api_version,
993: p_api_version,
994: l_api_name,
995: G_PKG_NAME )
996: THEN

Line 997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

993: p_api_version,
994: l_api_name,
995: G_PKG_NAME )
996: THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999: -- Initialize message list if p_init_msg_list is set to TRUE.
1000: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1001: FND_MSG_PUB.initialize;

Line 1000: IF FND_API.to_Boolean( p_init_msg_list ) THEN

996: THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999: -- Initialize message list if p_init_msg_list is set to TRUE.
1000: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1001: FND_MSG_PUB.initialize;
1002: END IF;
1003:
1004: -- Initialize API return status to success

Line 1005: x_return_status := FND_API.G_RET_STS_SUCCESS;

1001: FND_MSG_PUB.initialize;
1002: END IF;
1003:
1004: -- Initialize API return status to success
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006:
1007: /* Initialize */
1008: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1009:

Line 1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1100: l_module || '.end',
1101: '<<< ' || l_api_name);
1102: END IF;
1103: EXCEPTION
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1106: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
1107: p_data => x_msg_data);
1108: WHEN OTHERS THEN

Line 1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1101: '<<< ' || l_api_name);
1102: END IF;
1103: EXCEPTION
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1106: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
1107: p_data => x_msg_data);
1108: WHEN OTHERS THEN
1109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1106: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
1107: p_data => x_msg_data);
1108: WHEN OTHERS THEN
1109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1110: IF (l_uLog) THEN
1111: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1112: l_module || '.' || l_stmt_num,
1113: SUBSTRB (SQLERRM , 1 , 240));

Line 1164: IF NOT FND_API.Compatible_API_Call (l_api_version,

1160: '>>> ' || l_api_name);
1161: END IF;
1162:
1163: -- Standard call to check for call compatibility.
1164: IF NOT FND_API.Compatible_API_Call (l_api_version,
1165: p_api_version,
1166: l_api_name,
1167: G_PKG_NAME )
1168: THEN

Line 1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1165: p_api_version,
1166: l_api_name,
1167: G_PKG_NAME )
1168: THEN
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END IF;
1171: -- Initialize message list if p_init_msg_list is set to TRUE.
1172: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1173: FND_MSG_PUB.initialize;

Line 1172: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1168: THEN
1169: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1170: END IF;
1171: -- Initialize message list if p_init_msg_list is set to TRUE.
1172: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1173: FND_MSG_PUB.initialize;
1174: END IF;
1175:
1176: -- Initialize API return status to success

Line 1177: x_return_status := FND_API.G_RET_STS_SUCCESS;

1173: FND_MSG_PUB.initialize;
1174: END IF;
1175:
1176: -- Initialize API return status to success
1177: x_return_status := FND_API.G_RET_STS_SUCCESS;
1178:
1179: /* Initialize */
1180: DBMS_LOB.createtemporary(l_xml_wsmti, TRUE);
1181: DBMS_LOB.createtemporary(l_xml_wlmti, TRUE);

Line 1183: l_wsmti_flag := FND_API.G_FALSE;

1179: /* Initialize */
1180: DBMS_LOB.createtemporary(l_xml_wsmti, TRUE);
1181: DBMS_LOB.createtemporary(l_xml_wlmti, TRUE);
1182: DBMS_LOB.createtemporary(l_xml_wlsmi, TRUE);
1183: l_wsmti_flag := FND_API.G_FALSE;
1184: l_wlmti_flag := FND_API.G_FALSE;
1185: l_wlsmi_flag := FND_API.G_FALSE;
1186:
1187: /* Open Ref Cursor for WSM_SPLIT_MERGE_TXN_INTERFACE */

Line 1184: l_wlmti_flag := FND_API.G_FALSE;

1180: DBMS_LOB.createtemporary(l_xml_wsmti, TRUE);
1181: DBMS_LOB.createtemporary(l_xml_wlmti, TRUE);
1182: DBMS_LOB.createtemporary(l_xml_wlsmi, TRUE);
1183: l_wsmti_flag := FND_API.G_FALSE;
1184: l_wlmti_flag := FND_API.G_FALSE;
1185: l_wlsmi_flag := FND_API.G_FALSE;
1186:
1187: /* Open Ref Cursor for WSM_SPLIT_MERGE_TXN_INTERFACE */
1188: l_stmt_num := 10;

Line 1185: l_wlsmi_flag := FND_API.G_FALSE;

1181: DBMS_LOB.createtemporary(l_xml_wlmti, TRUE);
1182: DBMS_LOB.createtemporary(l_xml_wlsmi, TRUE);
1183: l_wsmti_flag := FND_API.G_FALSE;
1184: l_wlmti_flag := FND_API.G_FALSE;
1185: l_wlsmi_flag := FND_API.G_FALSE;
1186:
1187: /* Open Ref Cursor for WSM_SPLIT_MERGE_TXN_INTERFACE */
1188: l_stmt_num := 10;
1189: OPEN l_ref_cur FOR

Line 1236: l_wsmti_flag := FND_API.G_TRUE;

1232:
1233: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1234: /* remove the header*/
1235: IF (x_record_count > 0) THEN
1236: l_wsmti_flag := FND_API.G_TRUE;
1237: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wsmti,
1238: pattern => '>',
1239: offset => 1,
1240: nth => 1);

Line 1315: l_wlmti_flag := FND_API.G_TRUE;

1311:
1312: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1313: /* remove the header */
1314: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1315: l_wlmti_flag := FND_API.G_TRUE;
1316: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlmti,
1317: pattern => '>',
1318: offset => 1,
1319: nth => 1);

Line 1384: l_wlsmi_flag := FND_API.G_TRUE;

1380:
1381: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1382: /* remove the header */
1383: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1384: l_wlsmi_flag := FND_API.G_TRUE;
1385: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlsmi,
1386: pattern => '>',
1387: offset => 1,
1388: nth => 1);

Line 1401: IF (FND_API.to_Boolean (l_wsmti_flag) OR FND_API.to_Boolean (l_wlmti_flag)

1397: l_module || '.' || l_stmt_num,
1398: 'Completed WLSMI transactions');
1399: END IF;
1400:
1401: IF (FND_API.to_Boolean (l_wsmti_flag) OR FND_API.to_Boolean (l_wlmti_flag)
1402: OR FND_API.to_Boolean (l_wlsmi_flag) ) THEN
1403: /* Atleast one transaction is present */
1404: l_stmt_num := 100;
1405: DBMS_LOB.writeappend (x_xml_doc, 17, '');

Line 1402: OR FND_API.to_Boolean (l_wlsmi_flag) ) THEN

1398: 'Completed WLSMI transactions');
1399: END IF;
1400:
1401: IF (FND_API.to_Boolean (l_wsmti_flag) OR FND_API.to_Boolean (l_wlmti_flag)
1402: OR FND_API.to_Boolean (l_wlsmi_flag) ) THEN
1403: /* Atleast one transaction is present */
1404: l_stmt_num := 100;
1405: DBMS_LOB.writeappend (x_xml_doc, 17, '');
1406: IF (FND_API.to_Boolean (l_wsmti_flag)) THEN

Line 1406: IF (FND_API.to_Boolean (l_wsmti_flag)) THEN

1402: OR FND_API.to_Boolean (l_wlsmi_flag) ) THEN
1403: /* Atleast one transaction is present */
1404: l_stmt_num := 100;
1405: DBMS_LOB.writeappend (x_xml_doc, 17, '');
1406: IF (FND_API.to_Boolean (l_wsmti_flag)) THEN
1407: DBMS_LOB.append (x_xml_doc, l_xml_wsmti);
1408: END IF;
1409: IF (FND_API.to_Boolean (l_wlmti_flag)) THEN
1410: DBMS_LOB.append (x_xml_doc, l_xml_wlmti);

Line 1409: IF (FND_API.to_Boolean (l_wlmti_flag)) THEN

1405: DBMS_LOB.writeappend (x_xml_doc, 17, '');
1406: IF (FND_API.to_Boolean (l_wsmti_flag)) THEN
1407: DBMS_LOB.append (x_xml_doc, l_xml_wsmti);
1408: END IF;
1409: IF (FND_API.to_Boolean (l_wlmti_flag)) THEN
1410: DBMS_LOB.append (x_xml_doc, l_xml_wlmti);
1411: END IF;
1412: IF (FND_API.to_Boolean (l_wlsmi_flag)) THEN
1413: DBMS_LOB.append (x_xml_doc, l_xml_wlsmi);

Line 1412: IF (FND_API.to_Boolean (l_wlsmi_flag)) THEN

1408: END IF;
1409: IF (FND_API.to_Boolean (l_wlmti_flag)) THEN
1410: DBMS_LOB.append (x_xml_doc, l_xml_wlmti);
1411: END IF;
1412: IF (FND_API.to_Boolean (l_wlsmi_flag)) THEN
1413: DBMS_LOB.append (x_xml_doc, l_xml_wlsmi);
1414: END IF;
1415: DBMS_LOB.writeappend (x_xml_doc, 18, '');
1416: END IF;

Line 1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1428: l_module || '.end',
1429: '<<< ' || l_api_name);
1430: END IF;
1431: EXCEPTION
1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1435: p_data => x_msg_data);
1436: WHEN OTHERS THEN

Line 1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1429: '<<< ' || l_api_name);
1430: END IF;
1431: EXCEPTION
1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1435: p_data => x_msg_data);
1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1434: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1435: p_data => x_msg_data);
1436: WHEN OTHERS THEN
1437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1438: IF (l_uLog) THEN
1439: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1440: l_module || '.' || l_stmt_num,
1441: SUBSTRB (SQLERRM , 1 , 240));

Line 1488: IF NOT FND_API.Compatible_API_Call (l_api_version,

1484: '>>> ' || l_api_name);
1485: END IF;
1486:
1487: -- Standard call to check for call compatibility.
1488: IF NOT FND_API.Compatible_API_Call (l_api_version,
1489: p_api_version,
1490: l_api_name,
1491: G_PKG_NAME )
1492: THEN

Line 1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1489: p_api_version,
1490: l_api_name,
1491: G_PKG_NAME )
1492: THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;
1495: -- Initialize message list if p_init_msg_list is set to TRUE.
1496: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1497: FND_MSG_PUB.initialize;

Line 1496: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1492: THEN
1493: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1494: END IF;
1495: -- Initialize message list if p_init_msg_list is set to TRUE.
1496: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1497: FND_MSG_PUB.initialize;
1498: END IF;
1499:
1500: -- Initialize API return status to success

Line 1501: x_return_status := FND_API.G_RET_STS_SUCCESS;

1497: FND_MSG_PUB.initialize;
1498: END IF;
1499:
1500: -- Initialize API return status to success
1501: x_return_status := FND_API.G_RET_STS_SUCCESS;
1502:
1503: /* Initialize */
1504: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1505:

Line 1634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1630: '<<< ' || l_api_name);
1631: END IF;
1632:
1633: EXCEPTION
1634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1636: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1637: p_data => x_msg_data);
1638: WHEN OTHERS THEN

Line 1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1631: END IF;
1632:
1633: EXCEPTION
1634: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1636: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1637: p_data => x_msg_data);
1638: WHEN OTHERS THEN
1639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1636: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1637: p_data => x_msg_data);
1638: WHEN OTHERS THEN
1639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1640: IF (l_uLog) THEN
1641: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1642: l_module || '.' || l_stmt_num,
1643: SUBSTRB (SQLERRM , 1 , 240));

Line 1689: IF NOT FND_API.Compatible_API_Call (l_api_version,

1685: '>>> ' || l_api_name);
1686: END IF;
1687:
1688: -- Standard call to check for call compatibility.
1689: IF NOT FND_API.Compatible_API_Call (l_api_version,
1690: p_api_version,
1691: l_api_name,
1692: G_PKG_NAME )
1693: THEN

Line 1694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1690: p_api_version,
1691: l_api_name,
1692: G_PKG_NAME )
1693: THEN
1694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1695: END IF;
1696: -- Initialize message list if p_init_msg_list is set to TRUE.
1697: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1698: FND_MSG_PUB.initialize;

Line 1697: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1693: THEN
1694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1695: END IF;
1696: -- Initialize message list if p_init_msg_list is set to TRUE.
1697: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1698: FND_MSG_PUB.initialize;
1699: END IF;
1700:
1701: -- Initialize API return status to success

Line 1702: x_return_status := FND_API.G_RET_STS_SUCCESS;

1698: FND_MSG_PUB.initialize;
1699: END IF;
1700:
1701: -- Initialize API return status to success
1702: x_return_status := FND_API.G_RET_STS_SUCCESS;
1703:
1704: /* Initialize */
1705: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1706:

Line 1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1800: l_module || '.end',
1801: '<<< ' || l_api_name);
1802: END IF;
1803: EXCEPTION
1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1806: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1807: p_data => x_msg_data);
1808: WHEN OTHERS THEN

Line 1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1801: '<<< ' || l_api_name);
1802: END IF;
1803: EXCEPTION
1804: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1806: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1807: p_data => x_msg_data);
1808: WHEN OTHERS THEN
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1806: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1807: p_data => x_msg_data);
1808: WHEN OTHERS THEN
1809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1810: IF (l_uLog) THEN
1811: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1812: l_module || '.' || l_stmt_num,
1813: SUBSTRB (SQLERRM , 1 , 240));

Line 1859: IF NOT FND_API.Compatible_API_Call (l_api_version,

1855: '>>> ' || l_api_name);
1856: END IF;
1857:
1858: -- Standard call to check for call compatibility.
1859: IF NOT FND_API.Compatible_API_Call (l_api_version,
1860: p_api_version,
1861: l_api_name,
1862: G_PKG_NAME )
1863: THEN

Line 1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1860: p_api_version,
1861: l_api_name,
1862: G_PKG_NAME )
1863: THEN
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: END IF;
1866: -- Initialize message list if p_init_msg_list is set to TRUE.
1867: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1868: FND_MSG_PUB.initialize;

Line 1867: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1863: THEN
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: END IF;
1866: -- Initialize message list if p_init_msg_list is set to TRUE.
1867: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1868: FND_MSG_PUB.initialize;
1869: END IF;
1870:
1871: -- Initialize API return status to success

Line 1872: x_return_status := FND_API.G_RET_STS_SUCCESS;

1868: FND_MSG_PUB.initialize;
1869: END IF;
1870:
1871: -- Initialize API return status to success
1872: x_return_status := FND_API.G_RET_STS_SUCCESS;
1873:
1874: /* Initialize */
1875: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1876:

Line 1959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1955: l_module || '.end',
1956: '<<< ' || l_api_name);
1957: END IF;
1958: EXCEPTION
1959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1961: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1962: p_data => x_msg_data);
1963:

Line 1960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1956: '<<< ' || l_api_name);
1957: END IF;
1958: EXCEPTION
1959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1961: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1962: p_data => x_msg_data);
1963:
1964: WHEN OTHERS THEN

Line 1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1961: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1962: p_data => x_msg_data);
1963:
1964: WHEN OTHERS THEN
1965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1966: IF (l_uLog) THEN
1967: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1968: l_module || '.' || l_stmt_num,
1969: SUBSTRB (SQLERRM , 1 , 240));

Line 2016: IF NOT FND_API.Compatible_API_Call (l_api_version ,

2012: '>>> ' || l_api_name);
2013: END IF;
2014:
2015: -- Standard call to check for call compatibility.
2016: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2017: p_api_version ,
2018: l_api_name ,
2019: G_PKG_NAME )
2020: THEN

Line 2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2017: p_api_version ,
2018: l_api_name ,
2019: G_PKG_NAME )
2020: THEN
2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2022: END IF;
2023: -- Initialize message list if p_init_msg_list is set to TRUE.
2024: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2025: FND_MSG_PUB.initialize;

Line 2024: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2020: THEN
2021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2022: END IF;
2023: -- Initialize message list if p_init_msg_list is set to TRUE.
2024: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2025: FND_MSG_PUB.initialize;
2026: END IF;
2027:
2028: -- Initialize API return status to success

Line 2029: x_return_status := FND_API.G_RET_STS_SUCCESS;

2025: FND_MSG_PUB.initialize;
2026: END IF;
2027:
2028: -- Initialize API return status to success
2029: x_return_status := FND_API.G_RET_STS_SUCCESS;
2030:
2031: /* Initialize */
2032: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
2033:

Line 2197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2193: l_module || '.end',
2194: '<<< ' || l_api_name);
2195: END IF;
2196: EXCEPTION
2197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2199: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2200: p_data => x_msg_data);
2201: WHEN OTHERS THEN

Line 2198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2194: '<<< ' || l_api_name);
2195: END IF;
2196: EXCEPTION
2197: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2199: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2200: p_data => x_msg_data);
2201: WHEN OTHERS THEN
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2199: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2200: p_data => x_msg_data);
2201: WHEN OTHERS THEN
2202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2203: IF (l_uLog) THEN
2204: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2205: l_module || '.' || l_stmt_num,
2206: SUBSTRB (SQLERRM , 1 , 240));

Line 2252: IF NOT FND_API.Compatible_API_Call (l_api_version ,

2248: '>>> ' || l_api_name);
2249: END IF;
2250:
2251: -- Standard call to check for call compatibility.
2252: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2253: p_api_version ,
2254: l_api_name ,
2255: G_PKG_NAME )
2256: THEN

Line 2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2253: p_api_version ,
2254: l_api_name ,
2255: G_PKG_NAME )
2256: THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: END IF;
2259: -- Initialize message list if p_init_msg_list is set to TRUE.
2260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2261: FND_MSG_PUB.initialize;

Line 2260: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2256: THEN
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: END IF;
2259: -- Initialize message list if p_init_msg_list is set to TRUE.
2260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2261: FND_MSG_PUB.initialize;
2262: END IF;
2263:
2264: -- Initialize API return status to success

Line 2265: x_return_status := FND_API.G_RET_STS_SUCCESS;

2261: FND_MSG_PUB.initialize;
2262: END IF;
2263:
2264: -- Initialize API return status to success
2265: x_return_status := FND_API.G_RET_STS_SUCCESS;
2266:
2267: /* Initialize */
2268: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
2269:

Line 2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2386: l_module || '.end',
2387: '<<< ' || l_api_name);
2388: END IF;
2389: EXCEPTION
2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2392: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2393: p_data => x_msg_data);
2394: WHEN OTHERS THEN

Line 2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2387: '<<< ' || l_api_name);
2388: END IF;
2389: EXCEPTION
2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2392: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2393: p_data => x_msg_data);
2394: WHEN OTHERS THEN
2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2392: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2393: p_data => x_msg_data);
2394: WHEN OTHERS THEN
2395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2396: IF (l_uLog) THEN
2397: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2398: l_module || '.' || l_stmt_num,
2399: SUBSTRB (SQLERRM , 1 , 240));

Line 2445: IF NOT FND_API.Compatible_API_Call (l_api_version,

2441: '>>> ' || l_api_name);
2442: END IF;
2443:
2444: -- Standard call to check for call compatibility.
2445: IF NOT FND_API.Compatible_API_Call (l_api_version,
2446: p_api_version,
2447: l_api_name,
2448: G_PKG_NAME )
2449: THEN

Line 2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2446: p_api_version,
2447: l_api_name,
2448: G_PKG_NAME )
2449: THEN
2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2451: END IF;
2452: -- Initialize message list if p_init_msg_list is set to TRUE.
2453: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2454: FND_MSG_PUB.initialize;

Line 2453: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2449: THEN
2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2451: END IF;
2452: -- Initialize message list if p_init_msg_list is set to TRUE.
2453: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2454: FND_MSG_PUB.initialize;
2455: END IF;
2456:
2457: -- Initialize API return status to success

Line 2458: x_return_status := FND_API.G_RET_STS_SUCCESS;

2454: FND_MSG_PUB.initialize;
2455: END IF;
2456:
2457: -- Initialize API return status to success
2458: x_return_status := FND_API.G_RET_STS_SUCCESS;
2459:
2460: /* Initialize */
2461: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
2462:

Line 2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2527: l_module || '.end',
2528: '<<< ' || l_api_name);
2529: END IF;
2530: EXCEPTION
2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2533: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
2534: p_data => x_msg_data);
2535: WHEN OTHERS THEN

Line 2532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2528: '<<< ' || l_api_name);
2529: END IF;
2530: EXCEPTION
2531: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2533: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
2534: p_data => x_msg_data);
2535: WHEN OTHERS THEN
2536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2533: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
2534: p_data => x_msg_data);
2535: WHEN OTHERS THEN
2536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2537: IF (l_uLog) THEN
2538: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2539: l_module || '.' || l_stmt_num,
2540: SUBSTRB (SQLERRM , 1 , 240));