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

APPS.PO_MODIFY_REQUISITION_PVT dependencies on FND_API

Line 82: * x_return_status - FND_API.G_RET_STS_SUCCESS if action succeeds

78: * This api also handles the encumbrace effect of splitting requisition lines. This
79: * api would be called from Autocreate HTML.
80: *
81: * Returns:
82: * x_return_status - FND_API.G_RET_STS_SUCCESS if action succeeds
83: * FND_API.G_RET_STS_ERROR if action fails
84: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
85: * x_msg_count returns count of messages in the stack.
86: * x_msg_data returns message only if 1 message.

Line 83: * FND_API.G_RET_STS_ERROR if action fails

79: * api would be called from Autocreate HTML.
80: *
81: * Returns:
82: * x_return_status - FND_API.G_RET_STS_SUCCESS if action succeeds
83: * FND_API.G_RET_STS_ERROR if action fails
84: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
85: * x_msg_count returns count of messages in the stack.
86: * x_msg_data returns message only if 1 message.
87: * Algorithm:

Line 84: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

80: *
81: * Returns:
82: * x_return_status - FND_API.G_RET_STS_SUCCESS if action succeeds
83: * FND_API.G_RET_STS_ERROR if action fails
84: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
85: * x_msg_count returns count of messages in the stack.
86: * x_msg_data returns message only if 1 message.
87: * Algorithm:
88: * 1. Get the requisition line id of the req line that needs

Line 110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

106:
107:
108:
109: PROCEDURE split_requisition_lines(p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,

Line 111: p_commit IN VARCHAR2 := FND_API.G_FALSE,

107:
108:
109: PROCEDURE split_requisition_lines(p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
111: p_commit IN VARCHAR2 := FND_API.G_FALSE,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
114: x_msg_data OUT NOCOPY VARCHAR2,
115: p_req_line_id IN NUMBER,

Line 142: IF NOT FND_API.Compatible_API_Call(l_api_version,

138: PO_LOG.event(d_module_base,d_progress,'Starting Requisition Split ');
139: END IF;
140: --Initialize the error messages table
141: x_error_msg_tbl :=po_tbl_varchar2000();
142: IF NOT FND_API.Compatible_API_Call(l_api_version,
143: p_api_version,
144: l_module,
145: G_PKG_NAME)
146: THEN

Line 147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

143: p_api_version,
144: l_module,
145: G_PKG_NAME)
146: THEN
147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
148: END IF;
149:
150: --Get the value of current org id. We would set the
151: --org context back to this value before leaving the

Line 180: IF (x_return_status = FND_API.g_ret_sts_error)

176: IF PO_LOG.d_stmt THEN
177: PO_LOG.stmt(d_module_base,d_progress,'x_return_status',x_return_status);
178: END IF;
179:
180: IF (x_return_status = FND_API.g_ret_sts_error)
181: THEN
182: RAISE FND_API.g_exc_error;
183: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
184: THEN

Line 182: RAISE FND_API.g_exc_error;

178: END IF;
179:
180: IF (x_return_status = FND_API.g_ret_sts_error)
181: THEN
182: RAISE FND_API.g_exc_error;
183: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
184: THEN
185: RAISE FND_API.g_exc_unexpected_error;
186: END IF; --x_return_status

Line 183: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)

179:
180: IF (x_return_status = FND_API.g_ret_sts_error)
181: THEN
182: RAISE FND_API.g_exc_error;
183: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
184: THEN
185: RAISE FND_API.g_exc_unexpected_error;
186: END IF; --x_return_status
187:

Line 185: RAISE FND_API.g_exc_unexpected_error;

181: THEN
182: RAISE FND_API.g_exc_error;
183: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
184: THEN
185: RAISE FND_API.g_exc_unexpected_error;
186: END IF; --x_return_status
187:
188: d_progress := 30;
189:

Line 208: IF (x_return_status = FND_API.g_ret_sts_error)

204: IF PO_LOG.d_stmt THEN
205: PO_LOG.stmt(d_module_base,d_progress,'x_return_status',x_return_status);
206: END IF;
207:
208: IF (x_return_status = FND_API.g_ret_sts_error)
209: THEN
210: RAISE FND_API.g_exc_error;
211: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
212: THEN

Line 210: RAISE FND_API.g_exc_error;

206: END IF;
207:
208: IF (x_return_status = FND_API.g_ret_sts_error)
209: THEN
210: RAISE FND_API.g_exc_error;
211: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
212: THEN
213: RAISE FND_API.g_exc_unexpected_error;
214: END IF; --x_return_status

Line 211: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)

207:
208: IF (x_return_status = FND_API.g_ret_sts_error)
209: THEN
210: RAISE FND_API.g_exc_error;
211: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
212: THEN
213: RAISE FND_API.g_exc_unexpected_error;
214: END IF; --x_return_status
215:

Line 213: RAISE FND_API.g_exc_unexpected_error;

209: THEN
210: RAISE FND_API.g_exc_error;
211: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
212: THEN
213: RAISE FND_API.g_exc_unexpected_error;
214: END IF; --x_return_status
215:
216: IF PO_LOG.d_stmt THEN
217: PO_LOG.stmt(d_module_base,d_progress,'Reset the org context to old value');

Line 228: x_return_status := FND_API.g_ret_sts_success;

224: PO_LOG.stmt(d_module_base,d_progress,'l_old_org_id',l_old_org_id);
225: END IF;
226:
227: d_progress:=50;
228: x_return_status := FND_API.g_ret_sts_success;
229: IF (PO_LOG.d_proc)
230: THEN
231: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);
232: PO_LOG.proc_end(d_module_base,'x_msg_count', x_msg_count );

Line 236: WHEN FND_API.g_exc_error THEN

232: PO_LOG.proc_end(d_module_base,'x_msg_count', x_msg_count );
233: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
234: END IF;
235: EXCEPTION
236: WHEN FND_API.g_exc_error THEN
237: ROLLBACK TO split_requisition_lines_PVT;
238: x_return_status := FND_API.g_ret_sts_error;
239: po_moac_utils_pvt.set_org_context(l_old_org_id);
240: IF (PO_LOG.d_exc)

Line 238: x_return_status := FND_API.g_ret_sts_error;

234: END IF;
235: EXCEPTION
236: WHEN FND_API.g_exc_error THEN
237: ROLLBACK TO split_requisition_lines_PVT;
238: x_return_status := FND_API.g_ret_sts_error;
239: po_moac_utils_pvt.set_org_context(l_old_org_id);
240: IF (PO_LOG.d_exc)
241: THEN
242: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);

Line 247: WHEN FND_API.g_exc_unexpected_error THEN

243: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);
244: PO_LOG.proc_end(d_module_base,'x_msg_count', x_msg_count );
245: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
246: END IF;
247: WHEN FND_API.g_exc_unexpected_error THEN
248: ROLLBACK TO split_requisition_lines_PVT;
249: po_moac_utils_pvt.set_org_context(l_old_org_id);
250:
251: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);

Line 257: x_return_status := FND_API.g_ret_sts_error;

253: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
254: x_msg_data := FND_MESSAGE.get;
255: x_error_msg_tbl.extend(1);
256: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
257: x_return_status := FND_API.g_ret_sts_error;
258:
259: IF (PO_LOG.d_exc)
260: THEN
261: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);

Line 279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

275: x_msg_data := FND_MESSAGE.get;
276: x_error_msg_tbl.extend(1);
277: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
278:
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF (PO_LOG.d_exc)
281: THEN
282: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
283: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

Line 303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

299: END;
300: END split_requisition_lines;
301:
302: PROCEDURE create_requisition_lines(p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: x_return_status OUT NOCOPY VARCHAR2,
306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,

Line 304: p_commit IN VARCHAR2 := FND_API.G_FALSE,

300: END split_requisition_lines;
301:
302: PROCEDURE create_requisition_lines(p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: x_return_status OUT NOCOPY VARCHAR2,
306: x_msg_count OUT NOCOPY NUMBER,
307: x_msg_data OUT NOCOPY VARCHAR2,
308: p_req_line_id IN NUMBER,

Line 394: IF NOT FND_API.Compatible_API_Call(l_api_version,

390: PO_LOG.event(d_module_base,d_progress,'Starting Requisition Split ');
391: END IF;
392: --Initialize the error messages table
393: x_error_msg_tbl :=po_tbl_varchar2000();
394: IF NOT FND_API.Compatible_API_Call(l_api_version,
395: p_api_version,
396: l_module,
397: G_PKG_NAME)
398: THEN

Line 399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

395: p_api_version,
396: l_module,
397: G_PKG_NAME)
398: THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: END IF;
401:
402: IF (PO_LOG.d_proc)
403: THEN

Line 1184: IF FND_API.To_Boolean(p_commit)

1180: x_new_line_ids_tbl := new_req_line_id_rslt_tbl;
1181:
1182: d_progress := 60;
1183:
1184: IF FND_API.To_Boolean(p_commit)
1185: THEN
1186: IF PO_LOG.d_event THEN
1187: PO_LOG.event(d_module_base,d_progress,'Commiting work');
1188: END IF;

Line 1190: END IF; --FND_API

1186: IF PO_LOG.d_event THEN
1187: PO_LOG.event(d_module_base,d_progress,'Commiting work');
1188: END IF;
1189: COMMIT WORK;
1190: END IF; --FND_API
1191:
1192: d_progress := 70;
1193: x_return_status := FND_API.g_ret_sts_success;
1194:

Line 1193: x_return_status := FND_API.g_ret_sts_success;

1189: COMMIT WORK;
1190: END IF; --FND_API
1191:
1192: d_progress := 70;
1193: x_return_status := FND_API.g_ret_sts_success;
1194:
1195: IF PO_LOG.d_stmt THEN
1196: PO_LOG.stmt(d_module_base,d_progress,'l_old_org_id',l_old_org_id);
1197: END IF;

Line 1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1212: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1213: x_msg_data := FND_MESSAGE.get;
1214: x_error_msg_tbl.extend(1);
1215: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
1216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1217: IF (PO_LOG.d_exc)
1218: THEN
1219: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
1220: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

Line 1242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1238:
1239: -------------------------------------------------------------------------------
1240:
1241: PROCEDURE post_modify_requisition_lines(p_api_version IN NUMBER,
1242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1244: x_return_status OUT NOCOPY VARCHAR2,
1245: x_msg_count OUT NOCOPY NUMBER,
1246: x_msg_data OUT NOCOPY VARCHAR2,

Line 1243: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1239: -------------------------------------------------------------------------------
1240:
1241: PROCEDURE post_modify_requisition_lines(p_api_version IN NUMBER,
1242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1244: x_return_status OUT NOCOPY VARCHAR2,
1245: x_msg_count OUT NOCOPY NUMBER,
1246: x_msg_data OUT NOCOPY VARCHAR2,
1247: p_req_line_id IN NUMBER,

Line 1281: IF NOT FND_API.Compatible_API_Call(l_api_version,

1277: --Initialize the error messages table
1278: x_error_msg_tbl :=po_tbl_varchar2000();
1279:
1280:
1281: IF NOT FND_API.Compatible_API_Call(l_api_version,
1282: p_api_version,
1283: l_module,
1284: G_PKG_NAME)
1285: THEN

Line 1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1282: p_api_version,
1283: l_module,
1284: G_PKG_NAME)
1285: THEN
1286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1287: END IF;
1288:
1289: IF (PO_LOG.d_proc)
1290: THEN

Line 1390: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1386: p_calling_program => g_CALLING_PROGRAM_SPLIT,
1387: x_return_status => l_return_status);
1388:
1389: --
1390: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1391: l_tax_message := FND_MESSAGE.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
1392:
1393: FOR i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT LOOP
1394: l_message_text := l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i);

Line 1400: RAISE FND_API.G_EXC_ERROR;

1396: FND_MESSAGE.set_token('TRANSLATED_TOKEN',l_message_text);
1397: FND_MSG_PUB.Add;
1398: END LOOP;
1399:
1400: RAISE FND_API.G_EXC_ERROR;
1401:
1402: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1403: FND_MESSAGE.set_name('PO','PO_PDOI_TAX_CALCULATION_ERR');
1404: FND_MSG_PUB.Add;

Line 1402: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1398: END LOOP;
1399:
1400: RAISE FND_API.G_EXC_ERROR;
1401:
1402: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1403: FND_MESSAGE.set_name('PO','PO_PDOI_TAX_CALCULATION_ERR');
1404: FND_MSG_PUB.Add;
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: END IF;--l_return_status

Line 1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1401:
1402: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1403: FND_MESSAGE.set_name('PO','PO_PDOI_TAX_CALCULATION_ERR');
1404: FND_MSG_PUB.Add;
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: END IF;--l_return_status
1407: --
1408:
1409:

Line 1459: IF (l_return_status = FND_API.g_ret_sts_error)

1455: IF PO_LOG.d_stmt THEN
1456: PO_LOG.stmt(d_module_base,d_progress,'l_return_status'||l_return_status);
1457: END IF;
1458:
1459: IF (l_return_status = FND_API.g_ret_sts_error)
1460: THEN
1461: RAISE FND_API.g_exc_error;
1462: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1463: THEN

Line 1461: RAISE FND_API.g_exc_error;

1457: END IF;
1458:
1459: IF (l_return_status = FND_API.g_ret_sts_error)
1460: THEN
1461: RAISE FND_API.g_exc_error;
1462: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1463: THEN
1464: RAISE FND_API.g_exc_unexpected_error;
1465: END IF; --l_return_status

Line 1462: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)

1458:
1459: IF (l_return_status = FND_API.g_ret_sts_error)
1460: THEN
1461: RAISE FND_API.g_exc_error;
1462: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1463: THEN
1464: RAISE FND_API.g_exc_unexpected_error;
1465: END IF; --l_return_status
1466:

Line 1464: RAISE FND_API.g_exc_unexpected_error;

1460: THEN
1461: RAISE FND_API.g_exc_error;
1462: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1463: THEN
1464: RAISE FND_API.g_exc_unexpected_error;
1465: END IF; --l_return_status
1466:
1467: END LOOP;
1468: END IF;

Line 1490: IF (l_return_status = FND_API.g_ret_sts_error)

1486: IF PO_LOG.d_stmt THEN
1487: PO_LOG.stmt(d_module_base,d_progress,'l_return_status'||l_return_status);
1488: END IF;
1489:
1490: IF (l_return_status = FND_API.g_ret_sts_error)
1491: THEN
1492: RAISE FND_API.g_exc_error;
1493: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1494: THEN

Line 1492: RAISE FND_API.g_exc_error;

1488: END IF;
1489:
1490: IF (l_return_status = FND_API.g_ret_sts_error)
1491: THEN
1492: RAISE FND_API.g_exc_error;
1493: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1494: THEN
1495: RAISE FND_API.g_exc_unexpected_error;
1496: END IF; --l_return_status

Line 1493: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)

1489:
1490: IF (l_return_status = FND_API.g_ret_sts_error)
1491: THEN
1492: RAISE FND_API.g_exc_error;
1493: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1494: THEN
1495: RAISE FND_API.g_exc_unexpected_error;
1496: END IF; --l_return_status
1497: END IF;

Line 1495: RAISE FND_API.g_exc_unexpected_error;

1491: THEN
1492: RAISE FND_API.g_exc_error;
1493: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1494: THEN
1495: RAISE FND_API.g_exc_unexpected_error;
1496: END IF; --l_return_status
1497: END IF;
1498: END IF; --l_req_encumbrance_flag
1499:

Line 1502: IF FND_API.To_Boolean(p_commit)

1498: END IF; --l_req_encumbrance_flag
1499:
1500: d_progress := 90;
1501:
1502: IF FND_API.To_Boolean(p_commit)
1503: THEN
1504: IF PO_LOG.d_event THEN
1505: PO_LOG.event(d_module_base,d_progress,'Commiting work');
1506: END IF;

Line 1508: END IF; --FND_API

1504: IF PO_LOG.d_event THEN
1505: PO_LOG.event(d_module_base,d_progress,'Commiting work');
1506: END IF;
1507: COMMIT WORK;
1508: END IF; --FND_API
1509:
1510: x_return_status := FND_API.g_ret_sts_success;
1511:
1512: IF (PO_LOG.d_proc)

Line 1510: x_return_status := FND_API.g_ret_sts_success;

1506: END IF;
1507: COMMIT WORK;
1508: END IF; --FND_API
1509:
1510: x_return_status := FND_API.g_ret_sts_success;
1511:
1512: IF (PO_LOG.d_proc)
1513: THEN
1514: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

Line 1519: WHEN FND_API.g_exc_unexpected_error THEN

1515: PO_LOG.proc_end(d_module_base,'x_msg_count', x_msg_count );
1516: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
1517: END IF;
1518: EXCEPTION
1519: WHEN FND_API.g_exc_unexpected_error THEN
1520: ROLLBACK TO post_requisition_lines_PVT;
1521: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1522: p_data => x_msg_data);
1523: IF(x_msg_count>0)THEN

Line 1535: x_return_status := FND_API.g_ret_sts_unexp_error;

1531: x_msg_data := FND_MESSAGE.get;
1532: x_error_msg_tbl.extend(1);
1533: x_error_msg_tbl(x_error_msg_tbl.COUNT) := x_msg_data;
1534:
1535: x_return_status := FND_API.g_ret_sts_unexp_error;
1536:
1537: IF (PO_LOG.d_exc)
1538: THEN
1539: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);

Line 1544: WHEN FND_API.g_exc_error THEN

1540: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);
1541: PO_LOG.proc_end(d_module_base,'x_msg_count', x_msg_count );
1542: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
1543: END IF;
1544: WHEN FND_API.g_exc_error THEN
1545: ROLLBACK TO post_requisition_lines_PVT;
1546:
1547: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1548: p_data => x_msg_data);

Line 1554: ,p_init_msg_list => FND_API.G_FALSE

1550: IF l_online_report_id IS NOT NULL THEN
1551: PO_Document_Control_PVT.add_online_report_msgs
1552: (
1553: p_api_version => 1.0
1554: ,p_init_msg_list => FND_API.G_FALSE
1555: ,x_return_status => x_return_status
1556: ,p_online_report_id => l_online_report_id);
1557: END IF;
1558:

Line 1569: x_return_status := FND_API.g_ret_sts_error;

1565: --
1566: --Set the return status at the end so that the call to add
1567: --online report msgs onto the stack doesn't override the value set
1568: --by the exception handler.
1569: x_return_status := FND_API.g_ret_sts_error;
1570: --
1571: IF (PO_LOG.d_exc)
1572: THEN
1573: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);

Line 1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1584: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1585: x_msg_data := FND_MESSAGE.get;
1586: x_error_msg_tbl.extend(1);
1587: x_error_msg_tbl(1) := x_msg_data;
1588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1589: IF (PO_LOG.d_exc)
1590: THEN
1591: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
1592: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

Line 1646: IF NOT FND_API.Compatible_API_Call(l_api_version,

1642: PO_LOG.proc_begin(d_module_base, 'p_req_line_id', p_req_line_id);
1643: END IF;
1644:
1645: d_progress := 20;
1646: IF NOT FND_API.Compatible_API_Call(l_api_version,
1647: p_api_version,
1648: l_module,
1649: G_PKG_NAME) THEN
1650: IF (PO_LOG.d_event) THEN

Line 1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1649: G_PKG_NAME) THEN
1650: IF (PO_LOG.d_event) THEN
1651: PO_LOG.event(d_module_base, d_progress, 'Api versions incompatible. Throwing an exception');
1652: END IF;
1653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1654: END IF;
1655:
1656: d_progress := 30;
1657:

Line 1695: RAISE FND_API.g_exc_unexpected_error;

1691: END IF;
1692:
1693: po_message_s.sql_error('No rows inserted into PO_REQ_SPLIT_LINES_GT', d_progress, sqlcode);
1694: FND_MSG_PUB.add;
1695: RAISE FND_API.g_exc_unexpected_error;
1696: END IF;
1697:
1698: d_progress := 40;
1699: IF PO_LOG.d_stmt THEN

Line 1713: RAISE FND_API.g_exc_unexpected_error;

1709: IF (x_return_status <> 'S') THEN
1710: IF PO_LOG.d_stmt THEN
1711: PO_LOG.stmt(d_module_base,d_progress,'x_return_status',x_return_status);
1712: END IF;
1713: RAISE FND_API.g_exc_unexpected_error;
1714: END IF;
1715: END IF; /*IF (p_handle_tax_flag = 'Y')*/
1716:
1717: d_progress := 50;

Line 1732: IF (x_return_status = FND_API.g_ret_sts_error) THEN

1728: PO_LOG.stmt(d_module_base, d_progress,'l_po_return_code', l_po_return_code);
1729: PO_LOG.stmt(d_module_base, d_progress,'x_online_report_id', x_online_report_id);
1730: END IF;
1731:
1732: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1733: RAISE FND_API.g_exc_error;
1734: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1735: RAISE FND_API.g_exc_unexpected_error;
1736: END IF;

Line 1733: RAISE FND_API.g_exc_error;

1729: PO_LOG.stmt(d_module_base, d_progress,'x_online_report_id', x_online_report_id);
1730: END IF;
1731:
1732: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1733: RAISE FND_API.g_exc_error;
1734: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1735: RAISE FND_API.g_exc_unexpected_error;
1736: END IF;
1737:

Line 1734: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN

1730: END IF;
1731:
1732: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1733: RAISE FND_API.g_exc_error;
1734: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1735: RAISE FND_API.g_exc_unexpected_error;
1736: END IF;
1737:
1738: d_progress := 60;

Line 1735: RAISE FND_API.g_exc_unexpected_error;

1731:
1732: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1733: RAISE FND_API.g_exc_error;
1734: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1735: RAISE FND_API.g_exc_unexpected_error;
1736: END IF;
1737:
1738: d_progress := 60;
1739:

Line 1740: IF FND_API.To_Boolean(p_commit) THEN

1736: END IF;
1737:
1738: d_progress := 60;
1739:
1740: IF FND_API.To_Boolean(p_commit) THEN
1741: IF PO_LOG.d_event THEN
1742: PO_LOG.event(d_module_base, d_progress, 'Commiting work');
1743: END IF;
1744: COMMIT WORK;

Line 1750: x_return_status := FND_API.G_RET_STS_SUCCESS;

1746:
1747: -- Standard call to get message count and if count is 1,
1748: -- get message info.
1749: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1750: x_return_status := FND_API.G_RET_STS_SUCCESS;
1751:
1752: d_progress := 70;
1753:
1754: IF (PO_LOG.d_proc) THEN

Line 1763: WHEN FND_API.g_exc_unexpected_error THEN

1759: END IF;
1760:
1761: EXCEPTION
1762:
1763: WHEN FND_API.g_exc_unexpected_error THEN
1764:
1765: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1766:
1767: x_msg_data := FND_MSG_PUB.GET();

Line 1768: x_return_status := FND_API.g_ret_sts_unexp_error;

1764:
1765: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1766:
1767: x_msg_data := FND_MSG_PUB.GET();
1768: x_return_status := FND_API.g_ret_sts_unexp_error;
1769:
1770: IF (PO_LOG.d_exc) THEN
1771: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);
1772: PO_LOG.proc_end(d_module_base, 'x_return_status', x_return_status);

Line 1778: WHEN FND_API.g_exc_error THEN

1774: PO_LOG.proc_end(d_module_base, 'x_msg_data', x_msg_data);
1775: PO_LOG.proc_end(d_module_base,'x_online_report_id',x_online_report_id);
1776: END IF;
1777:
1778: WHEN FND_API.g_exc_error THEN
1779:
1780: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1781:
1782: x_return_status := FND_API.g_ret_sts_error;

Line 1782: x_return_status := FND_API.g_ret_sts_error;

1778: WHEN FND_API.g_exc_error THEN
1779:
1780: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1781:
1782: x_return_status := FND_API.g_ret_sts_error;
1783:
1784: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1785: p_data => x_msg_data);
1786:

Line 1803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1799: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1800:
1801: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1802: x_msg_data := FND_MESSAGE.get;
1803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1804:
1805: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1806: p_data => x_msg_data);
1807: