APPS.CST_PENDINGTXNSREPORT_PVT dependencies on FND_API

Line 101: p_init_msg_list => FND_API.G_FALSE,

97: /* Add Parameters */
98:
99: l_stmt_num := 20;
100: add_parameters (p_api_version => 1.0,
101: p_init_msg_list => FND_API.G_FALSE,
102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
103: x_return_status => l_return_status,
104: x_msg_count => l_msg_count,
105: x_msg_data => l_msg_data,

Line 102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

98:
99: l_stmt_num := 20;
100: add_parameters (p_api_version => 1.0,
101: p_init_msg_list => FND_API.G_FALSE,
102: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
103: x_return_status => l_return_status,
104: x_msg_count => l_msg_count,
105: x_msg_data => l_msg_data,
106: i_org_id => p_org_id,

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

108: i_resolution_type => p_resolution_type,
109: i_transaction_type => p_transaction_type,
110: x_xml_doc => l_xml_doc);
111:
112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:
116: /* Validate which transactions need to be added for the parameter values */

Line 113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

109: i_transaction_type => p_transaction_type,
110: x_xml_doc => l_xml_doc);
111:
112: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115:
116: /* Validate which transactions need to be added for the parameter values */
117:

Line 127: p_init_msg_list => FND_API.G_FALSE,

123: THEN
124: l_stmt_num := 30;
125: /* Transaction Type: All or Unprocessed MTL TRX */
126: unprocessed_mtl_trx (p_api_version => 1.0,
127: p_init_msg_list => FND_API.G_FALSE,
128: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
129: x_return_status => l_return_status,
130: x_msg_count => l_msg_count,
131: x_msg_data => l_msg_data,

Line 128: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

124: l_stmt_num := 30;
125: /* Transaction Type: All or Unprocessed MTL TRX */
126: unprocessed_mtl_trx (p_api_version => 1.0,
127: p_init_msg_list => FND_API.G_FALSE,
128: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
129: x_return_status => l_return_status,
130: x_msg_count => l_msg_count,
131: x_msg_data => l_msg_data,
132: i_period_end_date => l_period_end_date,

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

135: x_xml_doc => l_xml_doc);
136:
137: l_record_count := l_record_count + l_temp_count;
138:
139: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142: END IF;
143:

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

136:
137: l_record_count := l_record_count + l_temp_count;
138:
139: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142: END IF;
143:
144: IF (nvl(p_transaction_type,1) = 1 OR nvl(p_transaction_type,1) = 3)

Line 149: p_init_msg_list => FND_API.G_FALSE,

145: THEN
146: /* Transaction Type: All or Uncosted MTL TRX */
147: l_stmt_num := 40;
148: uncosted_mtl_trx(p_api_version => 1.0,
149: p_init_msg_list => FND_API.G_FALSE,
150: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
151: x_return_status => l_return_status,
152: x_msg_count => l_msg_count,
153: x_msg_data => l_msg_data,

Line 150: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

146: /* Transaction Type: All or Uncosted MTL TRX */
147: l_stmt_num := 40;
148: uncosted_mtl_trx(p_api_version => 1.0,
149: p_init_msg_list => FND_API.G_FALSE,
150: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
151: x_return_status => l_return_status,
152: x_msg_count => l_msg_count,
153: x_msg_data => l_msg_data,
154: i_period_end_date => l_period_end_date,

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

157: x_xml_doc => l_xml_doc);
158:
159: l_record_count := l_record_count + l_temp_count;
160:
161: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164: END IF;
165:

Line 162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

158:
159: l_record_count := l_record_count + l_temp_count;
160:
161: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
163: END IF;
164: END IF;
165:
166: IF (nvl(p_transaction_type,1) = 1 OR nvl(p_transaction_type,1) = 4)

Line 171: p_init_msg_list => FND_API.G_FALSE,

167: THEN
168: /* Transaction Type: All or Uncosted WIP TRX */
169: l_stmt_num := 50;
170: uncosted_wip_trx (p_api_version => 1.0,
171: p_init_msg_list => FND_API.G_FALSE,
172: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
173: x_return_status => l_return_status,
174: x_msg_count => l_msg_count,
175: x_msg_data => l_msg_data,

Line 172: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,

168: /* Transaction Type: All or Uncosted WIP TRX */
169: l_stmt_num := 50;
170: uncosted_wip_trx (p_api_version => 1.0,
171: p_init_msg_list => FND_API.G_FALSE,
172: p_validation_level=> FND_API.G_VALID_LEVEL_FULL,
173: x_return_status => l_return_status,
174: x_msg_count => l_msg_count,
175: x_msg_data => l_msg_data,
176: i_period_end_date => l_period_end_date,

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

179: x_xml_doc => l_xml_doc);
180:
181: l_record_count := l_record_count + l_temp_count;
182:
183: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186: END IF;
187:

Line 184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

180:
181: l_record_count := l_record_count + l_temp_count;
182:
183: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
184: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
185: END IF;
186: END IF;
187:
188: IF (nvl(p_transaction_type,1) = 1 or nvl(p_transaction_type,1) = 5)

Line 193: p_init_msg_list => FND_API.G_FALSE,

189: THEN
190: /* Transaction Type: All or Pending WSM TRX */
191: l_stmt_num := 60;
192: pending_wsm_trx (p_api_version => 1.0,
193: p_init_msg_list => FND_API.G_FALSE,
194: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
195: x_return_status => l_return_status,
196: x_msg_count => l_msg_count,
197: x_msg_data => l_msg_data,

Line 194: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

190: /* Transaction Type: All or Pending WSM TRX */
191: l_stmt_num := 60;
192: pending_wsm_trx (p_api_version => 1.0,
193: p_init_msg_list => FND_API.G_FALSE,
194: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
195: x_return_status => l_return_status,
196: x_msg_count => l_msg_count,
197: x_msg_data => l_msg_data,
198: i_period_end_date => l_period_end_date,

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

201: x_xml_doc => l_xml_doc);
202:
203: l_record_count := l_record_count + l_temp_count;
204:
205: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF;
208: END IF;
209:

Line 206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

202:
203: l_record_count := l_record_count + l_temp_count;
204:
205: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF;
208: END IF;
209:
210: /*Support for LCM*/

Line 216: p_init_msg_list => FND_API.G_FALSE,

212: THEN
213: /* Transaction Type: All or Pending LCM TRX */
214: l_stmt_num := 60;
215: pending_lcm_trx (p_api_version => 1.0,
216: p_init_msg_list => FND_API.G_FALSE,
217: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
218: x_return_status => l_return_status,
219: x_msg_count => l_msg_count,
220: x_msg_data => l_msg_data,

Line 217: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

213: /* Transaction Type: All or Pending LCM TRX */
214: l_stmt_num := 60;
215: pending_lcm_trx (p_api_version => 1.0,
216: p_init_msg_list => FND_API.G_FALSE,
217: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
218: x_return_status => l_return_status,
219: x_msg_count => l_msg_count,
220: x_msg_data => l_msg_data,
221: i_period_end_date => l_period_end_date,

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

224: x_xml_doc => l_xml_doc);
225:
226: l_record_count := l_record_count + l_temp_count;
227:
228: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231: END IF;
232: END IF;

Line 229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

225:
226: l_record_count := l_record_count + l_temp_count;
227:
228: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230: END IF;
231: END IF;
232: END IF;
233:

Line 243: p_init_msg_list => FND_API.G_FALSE,

239: THEN
240: /* Transaction Type: All or Pending RCV TRX */
241: l_stmt_num := 70;
242: pending_rcv_trx (p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_FALSE,
244: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
245: x_return_status => l_return_status,
246: x_msg_count => l_msg_count,
247: x_msg_data => l_msg_data,

Line 244: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

240: /* Transaction Type: All or Pending RCV TRX */
241: l_stmt_num := 70;
242: pending_rcv_trx (p_api_version => 1.0,
243: p_init_msg_list => FND_API.G_FALSE,
244: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
245: x_return_status => l_return_status,
246: x_msg_count => l_msg_count,
247: x_msg_data => l_msg_data,
248: i_period_end_date => l_period_end_date,

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

251: x_xml_doc => l_xml_doc);
252:
253: l_record_count := l_record_count + l_temp_count;
254:
255: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: END IF;
259:

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252:
253: l_record_count := l_record_count + l_temp_count;
254:
255: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: END IF;
259:
260: IF (nvl(p_transaction_type,1) = 1 OR nvl(p_transaction_type,1) = 7)

Line 265: p_init_msg_list => FND_API.G_FALSE,

261: THEN
262: /* Transaction Type: All or Pending material interface */
263: l_stmt_num := 80;
264: pending_mtl_interface_trx (p_api_version => 1.0,
265: p_init_msg_list => FND_API.G_FALSE,
266: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
267: x_return_status => l_return_status,
268: x_msg_count => l_msg_count,
269: x_msg_data => l_msg_data,

Line 266: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

262: /* Transaction Type: All or Pending material interface */
263: l_stmt_num := 80;
264: pending_mtl_interface_trx (p_api_version => 1.0,
265: p_init_msg_list => FND_API.G_FALSE,
266: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
267: x_return_status => l_return_status,
268: x_msg_count => l_msg_count,
269: x_msg_data => l_msg_data,
270: i_period_end_date => l_period_end_date,

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

273: x_xml_doc => l_xml_doc);
274:
275: l_record_count := l_record_count + l_temp_count;
276:
277: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280: END IF;
281:

Line 278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

274:
275: l_record_count := l_record_count + l_temp_count;
276:
277: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: END IF;
280: END IF;
281:
282: IF (nvl(p_transaction_type,1) = 1 OR nvl(p_transaction_type,1) = 8)

Line 287: p_init_msg_list => FND_API.G_FALSE,

283: THEN
284: /* Transaction Type: All or Pending WIP Move trx */
285: l_stmt_num := 90;
286: pending_wip_move_trx (p_api_version => 1.0,
287: p_init_msg_list => FND_API.G_FALSE,
288: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
289: x_return_status => l_return_status,
290: x_msg_count => l_msg_count,
291: x_msg_data => l_msg_data,

Line 288: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

284: /* Transaction Type: All or Pending WIP Move trx */
285: l_stmt_num := 90;
286: pending_wip_move_trx (p_api_version => 1.0,
287: p_init_msg_list => FND_API.G_FALSE,
288: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
289: x_return_status => l_return_status,
290: x_msg_count => l_msg_count,
291: x_msg_data => l_msg_data,
292: i_period_end_date => l_period_end_date,

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

295: x_xml_doc => l_xml_doc);
296:
297: l_record_count := l_record_count + l_temp_count;
298:
299: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302: END IF;
303:

Line 300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

296:
297: l_record_count := l_record_count + l_temp_count;
298:
299: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302: END IF;
303:
304: IF (nvl(p_transaction_type,1) = 1 OR nvl(p_transaction_type,1) = 9)

Line 309: p_init_msg_list => FND_API.G_FALSE,

305: THEN
306: /* Transaction Type: All or Incomplete workorders */
307: l_stmt_num := 100;
308: incomplete_eam_wo (p_api_version => 1.0,
309: p_init_msg_list => FND_API.G_FALSE,
310: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
311: x_return_status => l_return_status,
312: x_msg_count => l_msg_count,
313: x_msg_data => l_msg_data,

Line 310: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

306: /* Transaction Type: All or Incomplete workorders */
307: l_stmt_num := 100;
308: incomplete_eam_wo (p_api_version => 1.0,
309: p_init_msg_list => FND_API.G_FALSE,
310: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
311: x_return_status => l_return_status,
312: x_msg_count => l_msg_count,
313: x_msg_data => l_msg_data,
314: i_period_end_date => l_period_end_date,

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

317: x_xml_doc => l_xml_doc);
318:
319: l_record_count := l_record_count + l_temp_count;
320:
321: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324: END IF;
325: END IF;

Line 322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

318:
319: l_record_count := l_record_count + l_temp_count;
320:
321: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
322: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
323: END IF;
324: END IF;
325: END IF;
326:

Line 337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

333: x_return_status => l_return_status,
334: x_msg_count => l_msg_count,
335: x_msg_data => l_msg_data);
336: IF (l_return_status <> 0) THEN
337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:
340: -- l_shipping_txn_hook = 0 if shipping transactions are resolution required
341: -- = 1 if shipping transactions are resolution recommended

Line 349: p_init_msg_list => FND_API.G_FALSE,

345: THEN
346: /* Transaction Type: All or Pending Shipping trx */
347: l_stmt_num := 120;
348: pending_shipping_trx (p_api_version => 1.0,
349: p_init_msg_list => FND_API.G_FALSE,
350: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
351: x_return_status => l_return_status,
352: x_msg_count => l_msg_count,
353: x_msg_data => l_msg_data,

Line 350: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

346: /* Transaction Type: All or Pending Shipping trx */
347: l_stmt_num := 120;
348: pending_shipping_trx (p_api_version => 1.0,
349: p_init_msg_list => FND_API.G_FALSE,
350: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
351: x_return_status => l_return_status,
352: x_msg_count => l_msg_count,
353: x_msg_data => l_msg_data,
354: i_period_start_date => l_period_start_date,

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

358: x_xml_doc => l_xml_doc);
359:
360: l_record_count := l_record_count + l_temp_count;
361:
362: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365: END IF;
366:

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

359:
360: l_record_count := l_record_count + l_temp_count;
361:
362: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364: END IF;
365: END IF;
366:
367: IF (l_record_count = 0) THEN

Line 404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

400: '<<< ' || l_api_name);
401: END IF;
402:
403: EXCEPTION
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count,
406: p_data => l_msg_data);
407:
408: CST_UTILITY_PUB.writelogmessages (p_api_version => 1.0,

Line 483: IF NOT FND_API.Compatible_API_Call (l_api_version,

479: '>>> ' || l_api_name);
480: END IF;
481:
482: -- Standard call to check for call compatibility.
483: IF NOT FND_API.Compatible_API_Call (l_api_version,
484: p_api_version,
485: l_api_name,
486: G_PKG_NAME )
487: THEN

Line 488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

484: p_api_version,
485: l_api_name,
486: G_PKG_NAME )
487: THEN
488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE.
492: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 492: IF FND_API.to_Boolean( p_init_msg_list ) THEN

488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
489: END IF;
490:
491: -- Initialize message list if p_init_msg_list is set to TRUE.
492: IF FND_API.to_Boolean( p_init_msg_list ) THEN
493: FND_MSG_PUB.initialize;
494: END IF;
495:
496: -- Initialize API return status to success

Line 497: x_return_status := FND_API.G_RET_STS_SUCCESS;

493: FND_MSG_PUB.initialize;
494: END IF;
495:
496: -- Initialize API return status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;
498:
499: /* Initialize */
500: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
501:

Line 573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

569: l_module || '.end',
570: '<<< ' || l_api_name);
571: END IF;
572: EXCEPTION
573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: FND_MSG_PUB.Count_And_Get
576: ( p_count => x_msg_count,
577: p_data => x_msg_data

Line 574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

570: '<<< ' || l_api_name);
571: END IF;
572: EXCEPTION
573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
575: FND_MSG_PUB.Count_And_Get
576: ( p_count => x_msg_count,
577: p_data => x_msg_data
578: );

Line 580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

576: ( p_count => x_msg_count,
577: p_data => x_msg_data
578: );
579: WHEN OTHERS THEN
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
581: IF (l_uLog) THEN
582: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
583: l_module || '.' || l_stmt_num,
584: SUBSTRB (SQLERRM , 1 , 240));

Line 636: IF NOT FND_API.Compatible_API_Call (l_api_version,

632: '>>> ' || l_api_name);
633: END IF;
634:
635: -- Standard call to check for call compatibility.
636: IF NOT FND_API.Compatible_API_Call (l_api_version,
637: p_api_version,
638: l_api_name,
639: G_PKG_NAME )
640: THEN

Line 641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

637: p_api_version,
638: l_api_name,
639: G_PKG_NAME )
640: THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643: -- Initialize message list if p_init_msg_list is set to TRUE.
644: IF FND_API.to_Boolean( p_init_msg_list ) THEN
645: FND_MSG_PUB.initialize;

Line 644: IF FND_API.to_Boolean( p_init_msg_list ) THEN

640: THEN
641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
642: END IF;
643: -- Initialize message list if p_init_msg_list is set to TRUE.
644: IF FND_API.to_Boolean( p_init_msg_list ) THEN
645: FND_MSG_PUB.initialize;
646: END IF;
647:
648: -- Initialize API return status to success

Line 649: x_return_status := FND_API.G_RET_STS_SUCCESS;

645: FND_MSG_PUB.initialize;
646: END IF;
647:
648: -- Initialize API return status to success
649: x_return_status := FND_API.G_RET_STS_SUCCESS;
650:
651: /* Initialize */
652: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
653:

Line 760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

756: '<<< ' || l_api_name);
757: END IF;
758:
759: EXCEPTION
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
763: p_data => x_msg_data);
764: WHEN OTHERS THEN

Line 761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

757: END IF;
758:
759: EXCEPTION
760: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
763: p_data => x_msg_data);
764: WHEN OTHERS THEN
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
762: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
763: p_data => x_msg_data);
764: WHEN OTHERS THEN
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
766: IF (l_uLog) THEN
767: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
768: l_module || '.' || l_stmt_num,
769: SUBSTRB (SQLERRM , 1 , 240));

Line 815: IF NOT FND_API.Compatible_API_Call (l_api_version,

811: '>>> ' || l_api_name);
812: END IF;
813:
814: -- Standard call to check for call compatibility.
815: IF NOT FND_API.Compatible_API_Call (l_api_version,
816: p_api_version,
817: l_api_name,
818: G_PKG_NAME)
819: THEN

Line 820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

816: p_api_version,
817: l_api_name,
818: G_PKG_NAME)
819: THEN
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822: -- Initialize message list if p_init_msg_list is set to TRUE.
823: IF FND_API.to_Boolean (p_init_msg_list) THEN
824: FND_MSG_PUB.initialize;

Line 823: IF FND_API.to_Boolean (p_init_msg_list) THEN

819: THEN
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822: -- Initialize message list if p_init_msg_list is set to TRUE.
823: IF FND_API.to_Boolean (p_init_msg_list) THEN
824: FND_MSG_PUB.initialize;
825: END IF;
826:
827: -- Initialize API return status to success

Line 828: x_return_status := FND_API.G_RET_STS_SUCCESS;

824: FND_MSG_PUB.initialize;
825: END IF;
826:
827: -- Initialize API return status to success
828: x_return_status := FND_API.G_RET_STS_SUCCESS;
829:
830: /* Initialize */
831: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
832:

Line 923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

919: l_module || '.end',
920: '<<< ' || l_api_name);
921: END IF;
922: EXCEPTION
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
926: p_data => x_msg_data);
927: WHEN OTHERS THEN

Line 924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

920: '<<< ' || l_api_name);
921: END IF;
922: EXCEPTION
923: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
926: p_data => x_msg_data);
927: WHEN OTHERS THEN
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

924: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
925: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
926: p_data => x_msg_data);
927: WHEN OTHERS THEN
928: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
929: IF (l_uLog) THEN
930: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
931: l_module || '.' || l_stmt_num,
932: SUBSTRB (SQLERRM , 1 , 240));

Line 978: IF NOT FND_API.Compatible_API_Call (l_api_version,

974: '>>> ' || l_api_name);
975: END IF;
976:
977: -- Standard call to check for call compatibility.
978: IF NOT FND_API.Compatible_API_Call (l_api_version,
979: p_api_version,
980: l_api_name,
981: G_PKG_NAME )
982: THEN

Line 983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

979: p_api_version,
980: l_api_name,
981: G_PKG_NAME )
982: THEN
983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: END IF;
985: -- Initialize message list if p_init_msg_list is set to TRUE.
986: IF FND_API.to_Boolean( p_init_msg_list ) THEN
987: FND_MSG_PUB.initialize;

Line 986: IF FND_API.to_Boolean( p_init_msg_list ) THEN

982: THEN
983: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
984: END IF;
985: -- Initialize message list if p_init_msg_list is set to TRUE.
986: IF FND_API.to_Boolean( p_init_msg_list ) THEN
987: FND_MSG_PUB.initialize;
988: END IF;
989:
990: -- Initialize API return status to success

Line 991: x_return_status := FND_API.G_RET_STS_SUCCESS;

987: FND_MSG_PUB.initialize;
988: END IF;
989:
990: -- Initialize API return status to success
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
992:
993: /* Initialize */
994: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
995:

Line 1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1086: l_module || '.end',
1087: '<<< ' || l_api_name);
1088: END IF;
1089: EXCEPTION
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1092: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
1093: p_data => x_msg_data);
1094: WHEN OTHERS THEN

Line 1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1087: '<<< ' || l_api_name);
1088: END IF;
1089: EXCEPTION
1090: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1092: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
1093: p_data => x_msg_data);
1094: WHEN OTHERS THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1092: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
1093: p_data => x_msg_data);
1094: WHEN OTHERS THEN
1095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1096: IF (l_uLog) THEN
1097: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1098: l_module || '.' || l_stmt_num,
1099: SUBSTRB (SQLERRM , 1 , 240));

Line 1150: IF NOT FND_API.Compatible_API_Call (l_api_version,

1146: '>>> ' || l_api_name);
1147: END IF;
1148:
1149: -- Standard call to check for call compatibility.
1150: IF NOT FND_API.Compatible_API_Call (l_api_version,
1151: p_api_version,
1152: l_api_name,
1153: G_PKG_NAME )
1154: THEN

Line 1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1151: p_api_version,
1152: l_api_name,
1153: G_PKG_NAME )
1154: THEN
1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1156: END IF;
1157: -- Initialize message list if p_init_msg_list is set to TRUE.
1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize;

Line 1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1154: THEN
1155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1156: END IF;
1157: -- Initialize message list if p_init_msg_list is set to TRUE.
1158: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1159: FND_MSG_PUB.initialize;
1160: END IF;
1161:
1162: -- Initialize API return status to success

Line 1163: x_return_status := FND_API.G_RET_STS_SUCCESS;

1159: FND_MSG_PUB.initialize;
1160: END IF;
1161:
1162: -- Initialize API return status to success
1163: x_return_status := FND_API.G_RET_STS_SUCCESS;
1164:
1165: /* Initialize */
1166: DBMS_LOB.createtemporary(l_xml_wsmti, TRUE);
1167: DBMS_LOB.createtemporary(l_xml_wlmti, TRUE);

Line 1169: l_wsmti_flag := FND_API.G_FALSE;

1165: /* Initialize */
1166: DBMS_LOB.createtemporary(l_xml_wsmti, TRUE);
1167: DBMS_LOB.createtemporary(l_xml_wlmti, TRUE);
1168: DBMS_LOB.createtemporary(l_xml_wlsmi, TRUE);
1169: l_wsmti_flag := FND_API.G_FALSE;
1170: l_wlmti_flag := FND_API.G_FALSE;
1171: l_wlsmi_flag := FND_API.G_FALSE;
1172:
1173: /* Open Ref Cursor for WSM_SPLIT_MERGE_TXN_INTERFACE */

Line 1170: l_wlmti_flag := FND_API.G_FALSE;

1166: DBMS_LOB.createtemporary(l_xml_wsmti, TRUE);
1167: DBMS_LOB.createtemporary(l_xml_wlmti, TRUE);
1168: DBMS_LOB.createtemporary(l_xml_wlsmi, TRUE);
1169: l_wsmti_flag := FND_API.G_FALSE;
1170: l_wlmti_flag := FND_API.G_FALSE;
1171: l_wlsmi_flag := FND_API.G_FALSE;
1172:
1173: /* Open Ref Cursor for WSM_SPLIT_MERGE_TXN_INTERFACE */
1174: l_stmt_num := 10;

Line 1171: l_wlsmi_flag := FND_API.G_FALSE;

1167: DBMS_LOB.createtemporary(l_xml_wlmti, TRUE);
1168: DBMS_LOB.createtemporary(l_xml_wlsmi, TRUE);
1169: l_wsmti_flag := FND_API.G_FALSE;
1170: l_wlmti_flag := FND_API.G_FALSE;
1171: l_wlsmi_flag := FND_API.G_FALSE;
1172:
1173: /* Open Ref Cursor for WSM_SPLIT_MERGE_TXN_INTERFACE */
1174: l_stmt_num := 10;
1175: OPEN l_ref_cur FOR

Line 1222: l_wsmti_flag := FND_API.G_TRUE;

1218:
1219: x_record_count := DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1220: /* remove the header*/
1221: IF (x_record_count > 0) THEN
1222: l_wsmti_flag := FND_API.G_TRUE;
1223: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wsmti,
1224: pattern => '>',
1225: offset => 1,
1226: nth => 1);

Line 1301: l_wlmti_flag := FND_API.G_TRUE;

1297:
1298: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1299: /* remove the header */
1300: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1301: l_wlmti_flag := FND_API.G_TRUE;
1302: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlmti,
1303: pattern => '>',
1304: offset => 1,
1305: nth => 1);

Line 1370: l_wlsmi_flag := FND_API.G_TRUE;

1366:
1367: x_record_count := x_record_count + DBMS_XMLGEN.getNumRowsProcessed(l_ctx);
1368: /* remove the header */
1369: IF (DBMS_XMLGEN.getNumRowsProcessed(l_ctx) > 0) THEN
1370: l_wlsmi_flag := FND_API.G_TRUE;
1371: l_offset := DBMS_LOB.instr (lob_loc => l_xml_wlsmi,
1372: pattern => '>',
1373: offset => 1,
1374: nth => 1);

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

1383: l_module || '.' || l_stmt_num,
1384: 'Completed WLSMI transactions');
1385: END IF;
1386:
1387: IF (FND_API.to_Boolean (l_wsmti_flag) OR FND_API.to_Boolean (l_wlmti_flag)
1388: OR FND_API.to_Boolean (l_wlsmi_flag) ) THEN
1389: /* Atleast one transaction is present */
1390: l_stmt_num := 100;
1391: DBMS_LOB.writeappend (x_xml_doc, 17, '');

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

1384: 'Completed WLSMI transactions');
1385: END IF;
1386:
1387: IF (FND_API.to_Boolean (l_wsmti_flag) OR FND_API.to_Boolean (l_wlmti_flag)
1388: OR FND_API.to_Boolean (l_wlsmi_flag) ) THEN
1389: /* Atleast one transaction is present */
1390: l_stmt_num := 100;
1391: DBMS_LOB.writeappend (x_xml_doc, 17, '');
1392: IF (FND_API.to_Boolean (l_wsmti_flag)) THEN

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

1388: OR FND_API.to_Boolean (l_wlsmi_flag) ) THEN
1389: /* Atleast one transaction is present */
1390: l_stmt_num := 100;
1391: DBMS_LOB.writeappend (x_xml_doc, 17, '');
1392: IF (FND_API.to_Boolean (l_wsmti_flag)) THEN
1393: DBMS_LOB.append (x_xml_doc, l_xml_wsmti);
1394: END IF;
1395: IF (FND_API.to_Boolean (l_wlmti_flag)) THEN
1396: DBMS_LOB.append (x_xml_doc, l_xml_wlmti);

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

1391: DBMS_LOB.writeappend (x_xml_doc, 17, '');
1392: IF (FND_API.to_Boolean (l_wsmti_flag)) THEN
1393: DBMS_LOB.append (x_xml_doc, l_xml_wsmti);
1394: END IF;
1395: IF (FND_API.to_Boolean (l_wlmti_flag)) THEN
1396: DBMS_LOB.append (x_xml_doc, l_xml_wlmti);
1397: END IF;
1398: IF (FND_API.to_Boolean (l_wlsmi_flag)) THEN
1399: DBMS_LOB.append (x_xml_doc, l_xml_wlsmi);

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

1394: END IF;
1395: IF (FND_API.to_Boolean (l_wlmti_flag)) THEN
1396: DBMS_LOB.append (x_xml_doc, l_xml_wlmti);
1397: END IF;
1398: IF (FND_API.to_Boolean (l_wlsmi_flag)) THEN
1399: DBMS_LOB.append (x_xml_doc, l_xml_wlsmi);
1400: END IF;
1401: DBMS_LOB.writeappend (x_xml_doc, 18, '');
1402: END IF;

Line 1418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1414: l_module || '.end',
1415: '<<< ' || l_api_name);
1416: END IF;
1417: EXCEPTION
1418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1420: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1421: p_data => x_msg_data);
1422: WHEN OTHERS THEN

Line 1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1415: '<<< ' || l_api_name);
1416: END IF;
1417: EXCEPTION
1418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1420: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1421: p_data => x_msg_data);
1422: WHEN OTHERS THEN
1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1420: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1421: p_data => x_msg_data);
1422: WHEN OTHERS THEN
1423: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1424: IF (l_uLog) THEN
1425: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1426: l_module || '.' || l_stmt_num,
1427: SUBSTRB (SQLERRM , 1 , 240));

Line 1474: IF NOT FND_API.Compatible_API_Call (l_api_version,

1470: '>>> ' || l_api_name);
1471: END IF;
1472:
1473: -- Standard call to check for call compatibility.
1474: IF NOT FND_API.Compatible_API_Call (l_api_version,
1475: p_api_version,
1476: l_api_name,
1477: G_PKG_NAME )
1478: THEN

Line 1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1475: p_api_version,
1476: l_api_name,
1477: G_PKG_NAME )
1478: THEN
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: END IF;
1481: -- Initialize message list if p_init_msg_list is set to TRUE.
1482: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1483: FND_MSG_PUB.initialize;

Line 1482: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1478: THEN
1479: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1480: END IF;
1481: -- Initialize message list if p_init_msg_list is set to TRUE.
1482: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1483: FND_MSG_PUB.initialize;
1484: END IF;
1485:
1486: -- Initialize API return status to success

Line 1487: x_return_status := FND_API.G_RET_STS_SUCCESS;

1483: FND_MSG_PUB.initialize;
1484: END IF;
1485:
1486: -- Initialize API return status to success
1487: x_return_status := FND_API.G_RET_STS_SUCCESS;
1488:
1489: /* Initialize */
1490: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1491:

Line 1620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1616: '<<< ' || l_api_name);
1617: END IF;
1618:
1619: EXCEPTION
1620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1622: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1623: p_data => x_msg_data);
1624: WHEN OTHERS THEN

Line 1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1617: END IF;
1618:
1619: EXCEPTION
1620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1622: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1623: p_data => x_msg_data);
1624: WHEN OTHERS THEN
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1622: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1623: p_data => x_msg_data);
1624: WHEN OTHERS THEN
1625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1626: IF (l_uLog) THEN
1627: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1628: l_module || '.' || l_stmt_num,
1629: SUBSTRB (SQLERRM , 1 , 240));

Line 1675: IF NOT FND_API.Compatible_API_Call (l_api_version,

1671: '>>> ' || l_api_name);
1672: END IF;
1673:
1674: -- Standard call to check for call compatibility.
1675: IF NOT FND_API.Compatible_API_Call (l_api_version,
1676: p_api_version,
1677: l_api_name,
1678: G_PKG_NAME )
1679: THEN

Line 1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1676: p_api_version,
1677: l_api_name,
1678: G_PKG_NAME )
1679: THEN
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: END IF;
1682: -- Initialize message list if p_init_msg_list is set to TRUE.
1683: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1684: FND_MSG_PUB.initialize;

Line 1683: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1679: THEN
1680: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1681: END IF;
1682: -- Initialize message list if p_init_msg_list is set to TRUE.
1683: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1684: FND_MSG_PUB.initialize;
1685: END IF;
1686:
1687: -- Initialize API return status to success

Line 1688: x_return_status := FND_API.G_RET_STS_SUCCESS;

1684: FND_MSG_PUB.initialize;
1685: END IF;
1686:
1687: -- Initialize API return status to success
1688: x_return_status := FND_API.G_RET_STS_SUCCESS;
1689:
1690: /* Initialize */
1691: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1692:

Line 1790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1786: l_module || '.end',
1787: '<<< ' || l_api_name);
1788: END IF;
1789: EXCEPTION
1790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1792: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1793: p_data => x_msg_data);
1794: WHEN OTHERS THEN

Line 1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1787: '<<< ' || l_api_name);
1788: END IF;
1789: EXCEPTION
1790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1792: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1793: p_data => x_msg_data);
1794: WHEN OTHERS THEN
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1792: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1793: p_data => x_msg_data);
1794: WHEN OTHERS THEN
1795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1796: IF (l_uLog) THEN
1797: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1798: l_module || '.' || l_stmt_num,
1799: SUBSTRB (SQLERRM , 1 , 240));

Line 1845: IF NOT FND_API.Compatible_API_Call (l_api_version,

1841: '>>> ' || l_api_name);
1842: END IF;
1843:
1844: -- Standard call to check for call compatibility.
1845: IF NOT FND_API.Compatible_API_Call (l_api_version,
1846: p_api_version,
1847: l_api_name,
1848: G_PKG_NAME )
1849: THEN

Line 1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1846: p_api_version,
1847: l_api_name,
1848: G_PKG_NAME )
1849: THEN
1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1851: END IF;
1852: -- Initialize message list if p_init_msg_list is set to TRUE.
1853: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1854: FND_MSG_PUB.initialize;

Line 1853: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1849: THEN
1850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1851: END IF;
1852: -- Initialize message list if p_init_msg_list is set to TRUE.
1853: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1854: FND_MSG_PUB.initialize;
1855: END IF;
1856:
1857: -- Initialize API return status to success

Line 1858: x_return_status := FND_API.G_RET_STS_SUCCESS;

1854: FND_MSG_PUB.initialize;
1855: END IF;
1856:
1857: -- Initialize API return status to success
1858: x_return_status := FND_API.G_RET_STS_SUCCESS;
1859:
1860: /* Initialize */
1861: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
1862:

Line 1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1941: l_module || '.end',
1942: '<<< ' || l_api_name);
1943: END IF;
1944: EXCEPTION
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1947: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1948: p_data => x_msg_data);
1949:

Line 1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1942: '<<< ' || l_api_name);
1943: END IF;
1944: EXCEPTION
1945: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1946: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1947: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1948: p_data => x_msg_data);
1949:
1950: WHEN OTHERS THEN

Line 1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1947: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
1948: p_data => x_msg_data);
1949:
1950: WHEN OTHERS THEN
1951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1952: IF (l_uLog) THEN
1953: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
1954: l_module || '.' || l_stmt_num,
1955: SUBSTRB (SQLERRM , 1 , 240));

Line 2002: IF NOT FND_API.Compatible_API_Call (l_api_version ,

1998: '>>> ' || l_api_name);
1999: END IF;
2000:
2001: -- Standard call to check for call compatibility.
2002: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2003: p_api_version ,
2004: l_api_name ,
2005: G_PKG_NAME )
2006: THEN

Line 2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2003: p_api_version ,
2004: l_api_name ,
2005: G_PKG_NAME )
2006: THEN
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: END IF;
2009: -- Initialize message list if p_init_msg_list is set to TRUE.
2010: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2011: FND_MSG_PUB.initialize;

Line 2010: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2006: THEN
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: END IF;
2009: -- Initialize message list if p_init_msg_list is set to TRUE.
2010: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2011: FND_MSG_PUB.initialize;
2012: END IF;
2013:
2014: -- Initialize API return status to success

Line 2015: x_return_status := FND_API.G_RET_STS_SUCCESS;

2011: FND_MSG_PUB.initialize;
2012: END IF;
2013:
2014: -- Initialize API return status to success
2015: x_return_status := FND_API.G_RET_STS_SUCCESS;
2016:
2017: /* Initialize */
2018: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
2019:

Line 2183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2179: l_module || '.end',
2180: '<<< ' || l_api_name);
2181: END IF;
2182: EXCEPTION
2183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2185: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2186: p_data => x_msg_data);
2187: WHEN OTHERS THEN

Line 2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2180: '<<< ' || l_api_name);
2181: END IF;
2182: EXCEPTION
2183: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2185: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2186: p_data => x_msg_data);
2187: WHEN OTHERS THEN
2188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2185: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2186: p_data => x_msg_data);
2187: WHEN OTHERS THEN
2188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2189: IF (l_uLog) THEN
2190: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2191: l_module || '.' || l_stmt_num,
2192: SUBSTRB (SQLERRM , 1 , 240));

Line 2238: IF NOT FND_API.Compatible_API_Call (l_api_version ,

2234: '>>> ' || l_api_name);
2235: END IF;
2236:
2237: -- Standard call to check for call compatibility.
2238: IF NOT FND_API.Compatible_API_Call (l_api_version ,
2239: p_api_version ,
2240: l_api_name ,
2241: G_PKG_NAME )
2242: THEN

Line 2243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2239: p_api_version ,
2240: l_api_name ,
2241: G_PKG_NAME )
2242: THEN
2243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2244: END IF;
2245: -- Initialize message list if p_init_msg_list is set to TRUE.
2246: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2247: FND_MSG_PUB.initialize;

Line 2246: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2242: THEN
2243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2244: END IF;
2245: -- Initialize message list if p_init_msg_list is set to TRUE.
2246: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2247: FND_MSG_PUB.initialize;
2248: END IF;
2249:
2250: -- Initialize API return status to success

Line 2251: x_return_status := FND_API.G_RET_STS_SUCCESS;

2247: FND_MSG_PUB.initialize;
2248: END IF;
2249:
2250: -- Initialize API return status to success
2251: x_return_status := FND_API.G_RET_STS_SUCCESS;
2252:
2253: /* Initialize */
2254: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
2255:

Line 2376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2372: l_module || '.end',
2373: '<<< ' || l_api_name);
2374: END IF;
2375: EXCEPTION
2376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2378: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2379: p_data => x_msg_data);
2380: WHEN OTHERS THEN

Line 2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2373: '<<< ' || l_api_name);
2374: END IF;
2375: EXCEPTION
2376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2378: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2379: p_data => x_msg_data);
2380: WHEN OTHERS THEN
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2378: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
2379: p_data => x_msg_data);
2380: WHEN OTHERS THEN
2381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2382: IF (l_uLog) THEN
2383: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2384: l_module || '.' || l_stmt_num,
2385: SUBSTRB (SQLERRM , 1 , 240));

Line 2431: IF NOT FND_API.Compatible_API_Call (l_api_version,

2427: '>>> ' || l_api_name);
2428: END IF;
2429:
2430: -- Standard call to check for call compatibility.
2431: IF NOT FND_API.Compatible_API_Call (l_api_version,
2432: p_api_version,
2433: l_api_name,
2434: G_PKG_NAME )
2435: THEN

Line 2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2432: p_api_version,
2433: l_api_name,
2434: G_PKG_NAME )
2435: THEN
2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2437: END IF;
2438: -- Initialize message list if p_init_msg_list is set to TRUE.
2439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2440: FND_MSG_PUB.initialize;

Line 2439: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2435: THEN
2436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2437: END IF;
2438: -- Initialize message list if p_init_msg_list is set to TRUE.
2439: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2440: FND_MSG_PUB.initialize;
2441: END IF;
2442:
2443: -- Initialize API return status to success

Line 2444: x_return_status := FND_API.G_RET_STS_SUCCESS;

2440: FND_MSG_PUB.initialize;
2441: END IF;
2442:
2443: -- Initialize API return status to success
2444: x_return_status := FND_API.G_RET_STS_SUCCESS;
2445:
2446: /* Initialize */
2447: DBMS_LOB.createtemporary(l_xml_temp, TRUE);
2448:

Line 2517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2513: l_module || '.end',
2514: '<<< ' || l_api_name);
2515: END IF;
2516: EXCEPTION
2517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2519: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
2520: p_data => x_msg_data);
2521: WHEN OTHERS THEN

Line 2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2514: '<<< ' || l_api_name);
2515: END IF;
2516: EXCEPTION
2517: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2519: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
2520: p_data => x_msg_data);
2521: WHEN OTHERS THEN
2522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2519: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count ,
2520: p_data => x_msg_data);
2521: WHEN OTHERS THEN
2522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2523: IF (l_uLog) THEN
2524: FND_LOG.STRING (FND_LOG.LEVEL_UNEXPECTED,
2525: l_module || '.' || l_stmt_num,
2526: SUBSTRB (SQLERRM , 1 , 240));