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 28: * x_return_status - FND_API.G_RET_STS_SUCCESS if action succeeds

24: * This api also handles the encumbrace effect of splitting requisition lines. This
25: * api would be called from Autocreate HTML.
26: *
27: * Returns:
28: * x_return_status - FND_API.G_RET_STS_SUCCESS if action succeeds
29: * FND_API.G_RET_STS_ERROR if action fails
30: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
31: * x_msg_count returns count of messages in the stack.
32: * x_msg_data returns message only if 1 message.

Line 29: * FND_API.G_RET_STS_ERROR if action fails

25: * api would be called from Autocreate HTML.
26: *
27: * Returns:
28: * x_return_status - FND_API.G_RET_STS_SUCCESS if action succeeds
29: * FND_API.G_RET_STS_ERROR if action fails
30: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
31: * x_msg_count returns count of messages in the stack.
32: * x_msg_data returns message only if 1 message.
33: * Algorithm:

Line 30: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

26: *
27: * Returns:
28: * x_return_status - FND_API.G_RET_STS_SUCCESS if action succeeds
29: * FND_API.G_RET_STS_ERROR if action fails
30: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
31: * x_msg_count returns count of messages in the stack.
32: * x_msg_data returns message only if 1 message.
33: * Algorithm:
34: * 1. Get the requisition line id of the req line that needs

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

50: *
51: */
52:
53: PROCEDURE split_requisition_lines(p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55: p_commit IN VARCHAR2 := FND_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,

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

51: */
52:
53: PROCEDURE split_requisition_lines(p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
55: p_commit IN VARCHAR2 := FND_API.G_FALSE,
56: x_return_status OUT NOCOPY VARCHAR2,
57: x_msg_count OUT NOCOPY NUMBER,
58: x_msg_data OUT NOCOPY VARCHAR2,
59: p_req_line_id IN NUMBER,

Line 86: IF NOT FND_API.Compatible_API_Call(l_api_version,

82: PO_LOG.event(d_module_base,d_progress,'Starting Requisition Split ');
83: END IF;
84: --Initialize the error messages table
85: x_error_msg_tbl :=po_tbl_varchar2000();
86: IF NOT FND_API.Compatible_API_Call(l_api_version,
87: p_api_version,
88: l_module,
89: G_PKG_NAME)
90: THEN

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87: p_api_version,
88: l_module,
89: G_PKG_NAME)
90: THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94: --Get the value of current org id. We would set the
95: --org context back to this value before leaving the

Line 124: IF (x_return_status = FND_API.g_ret_sts_error)

120: IF PO_LOG.d_stmt THEN
121: PO_LOG.stmt(d_module_base,d_progress,'x_return_status',x_return_status);
122: END IF;
123:
124: IF (x_return_status = FND_API.g_ret_sts_error)
125: THEN
126: RAISE FND_API.g_exc_error;
127: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
128: THEN

Line 126: RAISE FND_API.g_exc_error;

122: END IF;
123:
124: IF (x_return_status = FND_API.g_ret_sts_error)
125: THEN
126: RAISE FND_API.g_exc_error;
127: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
128: THEN
129: RAISE FND_API.g_exc_unexpected_error;
130: END IF; --x_return_status

Line 127: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)

123:
124: IF (x_return_status = FND_API.g_ret_sts_error)
125: THEN
126: RAISE FND_API.g_exc_error;
127: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
128: THEN
129: RAISE FND_API.g_exc_unexpected_error;
130: END IF; --x_return_status
131:

Line 129: RAISE FND_API.g_exc_unexpected_error;

125: THEN
126: RAISE FND_API.g_exc_error;
127: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
128: THEN
129: RAISE FND_API.g_exc_unexpected_error;
130: END IF; --x_return_status
131:
132: d_progress := 30;
133:

Line 152: IF (x_return_status = FND_API.g_ret_sts_error)

148: IF PO_LOG.d_stmt THEN
149: PO_LOG.stmt(d_module_base,d_progress,'x_return_status',x_return_status);
150: END IF;
151:
152: IF (x_return_status = FND_API.g_ret_sts_error)
153: THEN
154: RAISE FND_API.g_exc_error;
155: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
156: THEN

Line 154: RAISE FND_API.g_exc_error;

150: END IF;
151:
152: IF (x_return_status = FND_API.g_ret_sts_error)
153: THEN
154: RAISE FND_API.g_exc_error;
155: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
156: THEN
157: RAISE FND_API.g_exc_unexpected_error;
158: END IF; --x_return_status

Line 155: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)

151:
152: IF (x_return_status = FND_API.g_ret_sts_error)
153: THEN
154: RAISE FND_API.g_exc_error;
155: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
156: THEN
157: RAISE FND_API.g_exc_unexpected_error;
158: END IF; --x_return_status
159:

Line 157: RAISE FND_API.g_exc_unexpected_error;

153: THEN
154: RAISE FND_API.g_exc_error;
155: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error)
156: THEN
157: RAISE FND_API.g_exc_unexpected_error;
158: END IF; --x_return_status
159:
160: IF PO_LOG.d_stmt THEN
161: PO_LOG.stmt(d_module_base,d_progress,'Reset the org context to old value');

Line 172: x_return_status := FND_API.g_ret_sts_success;

168: PO_LOG.stmt(d_module_base,d_progress,'l_old_org_id',l_old_org_id);
169: END IF;
170:
171: d_progress:=50;
172: x_return_status := FND_API.g_ret_sts_success;
173: IF (PO_LOG.d_proc)
174: THEN
175: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);
176: PO_LOG.proc_end(d_module_base,'x_msg_count', x_msg_count );

Line 180: WHEN FND_API.g_exc_error THEN

176: PO_LOG.proc_end(d_module_base,'x_msg_count', x_msg_count );
177: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
178: END IF;
179: EXCEPTION
180: WHEN FND_API.g_exc_error THEN
181: ROLLBACK TO split_requisition_lines_PVT;
182: x_return_status := FND_API.g_ret_sts_error;
183: po_moac_utils_pvt.set_org_context(l_old_org_id);
184: IF (PO_LOG.d_exc)

Line 182: x_return_status := FND_API.g_ret_sts_error;

178: END IF;
179: EXCEPTION
180: WHEN FND_API.g_exc_error THEN
181: ROLLBACK TO split_requisition_lines_PVT;
182: x_return_status := FND_API.g_ret_sts_error;
183: po_moac_utils_pvt.set_org_context(l_old_org_id);
184: IF (PO_LOG.d_exc)
185: THEN
186: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);

Line 191: WHEN FND_API.g_exc_unexpected_error THEN

187: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);
188: PO_LOG.proc_end(d_module_base,'x_msg_count', x_msg_count );
189: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
190: END IF;
191: WHEN FND_API.g_exc_unexpected_error THEN
192: ROLLBACK TO split_requisition_lines_PVT;
193: po_moac_utils_pvt.set_org_context(l_old_org_id);
194:
195: po_message_s.sql_error(g_pkg_name, l_module, d_progress, SQLCODE, SQLERRM);

Line 201: x_return_status := FND_API.g_ret_sts_error;

197: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
198: x_msg_data := FND_MESSAGE.get;
199: x_error_msg_tbl.extend(1);
200: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
201: x_return_status := FND_API.g_ret_sts_error;
202:
203: IF (PO_LOG.d_exc)
204: THEN
205: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);

Line 223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

219: x_msg_data := FND_MESSAGE.get;
220: x_error_msg_tbl.extend(1);
221: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
222:
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: IF (PO_LOG.d_exc)
225: THEN
226: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
227: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

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

243: END;
244: END split_requisition_lines;
245:
246: PROCEDURE create_requisition_lines(p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248: p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,

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

244: END split_requisition_lines;
245:
246: PROCEDURE create_requisition_lines(p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248: p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,
252: p_req_line_id IN NUMBER,

Line 296: IF NOT FND_API.Compatible_API_Call(l_api_version,

292: PO_LOG.event(d_module_base,d_progress,'Starting Requisition Split ');
293: END IF;
294: --Initialize the error messages table
295: x_error_msg_tbl :=po_tbl_varchar2000();
296: IF NOT FND_API.Compatible_API_Call(l_api_version,
297: p_api_version,
298: l_module,
299: G_PKG_NAME)
300: THEN

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: p_api_version,
298: l_module,
299: G_PKG_NAME)
300: THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: END IF;
303:
304: IF (PO_LOG.d_proc)
305: THEN

Line 743: IF FND_API.To_Boolean(p_commit)

739: x_new_line_ids_tbl := new_req_line_id_rslt_tbl;
740:
741: d_progress := 60;
742:
743: IF FND_API.To_Boolean(p_commit)
744: THEN
745: IF PO_LOG.d_event THEN
746: PO_LOG.event(d_module_base,d_progress,'Commiting work');
747: END IF;

Line 749: END IF; --FND_API

745: IF PO_LOG.d_event THEN
746: PO_LOG.event(d_module_base,d_progress,'Commiting work');
747: END IF;
748: COMMIT WORK;
749: END IF; --FND_API
750:
751: d_progress := 70;
752: x_return_status := FND_API.g_ret_sts_success;
753:

Line 752: x_return_status := FND_API.g_ret_sts_success;

748: COMMIT WORK;
749: END IF; --FND_API
750:
751: d_progress := 70;
752: x_return_status := FND_API.g_ret_sts_success;
753:
754: IF PO_LOG.d_stmt THEN
755: PO_LOG.stmt(d_module_base,d_progress,'l_old_org_id',l_old_org_id);
756: END IF;

Line 775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

771: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
772: x_msg_data := FND_MESSAGE.get;
773: x_error_msg_tbl.extend(1);
774: x_error_msg_tbl(x_error_msg_tbl.count) := x_msg_data;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: IF (PO_LOG.d_exc)
777: THEN
778: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
779: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

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

797:
798: -------------------------------------------------------------------------------
799:
800: PROCEDURE post_modify_requisition_lines(p_api_version IN NUMBER,
801: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
802: p_commit IN VARCHAR2 := FND_API.G_FALSE,
803: x_return_status OUT NOCOPY VARCHAR2,
804: x_msg_count OUT NOCOPY NUMBER,
805: x_msg_data OUT NOCOPY VARCHAR2,

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

798: -------------------------------------------------------------------------------
799:
800: PROCEDURE post_modify_requisition_lines(p_api_version IN NUMBER,
801: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
802: p_commit IN VARCHAR2 := FND_API.G_FALSE,
803: x_return_status OUT NOCOPY VARCHAR2,
804: x_msg_count OUT NOCOPY NUMBER,
805: x_msg_data OUT NOCOPY VARCHAR2,
806: p_req_line_id IN NUMBER,

Line 838: IF NOT FND_API.Compatible_API_Call(l_api_version,

834:
835: --Initialize the error messages table
836: x_error_msg_tbl :=po_tbl_varchar2000();
837:
838: IF NOT FND_API.Compatible_API_Call(l_api_version,
839: p_api_version,
840: l_module,
841: G_PKG_NAME)
842: THEN

Line 843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

839: p_api_version,
840: l_module,
841: G_PKG_NAME)
842: THEN
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: END IF;
845:
846: IF (PO_LOG.d_proc)
847: THEN

Line 947: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

943: p_calling_program => g_CALLING_PROGRAM_SPLIT,
944: x_return_status => l_return_status);
945:
946: --
947: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
948: l_tax_message := FND_MESSAGE.get_string('PO','PO_TAX_CALCULATION')||' : ' ;
949:
950: FOR i IN 1..po_tax_interface_pvt.G_TAX_ERRORS_TBL.MESSAGE_TEXT.COUNT LOOP
951: l_message_text := l_tax_message || po_tax_interface_pvt.G_TAX_ERRORS_TBL.message_text(i);

Line 957: RAISE FND_API.G_EXC_ERROR;

953: FND_MESSAGE.set_token('TRANSLATED_TOKEN',l_message_text);
954: FND_MSG_PUB.Add;
955: END LOOP;
956:
957: RAISE FND_API.G_EXC_ERROR;
958:
959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: FND_MESSAGE.set_name('PO','PO_PDOI_TAX_CALCULATION_ERR');
961: FND_MSG_PUB.Add;

Line 959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

955: END LOOP;
956:
957: RAISE FND_API.G_EXC_ERROR;
958:
959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: FND_MESSAGE.set_name('PO','PO_PDOI_TAX_CALCULATION_ERR');
961: FND_MSG_PUB.Add;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: END IF;--l_return_status

Line 962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

958:
959: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
960: FND_MESSAGE.set_name('PO','PO_PDOI_TAX_CALCULATION_ERR');
961: FND_MSG_PUB.Add;
962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
963: END IF;--l_return_status
964: --
965:
966:

Line 1017: IF (l_return_status = FND_API.g_ret_sts_error)

1013: IF PO_LOG.d_stmt THEN
1014: PO_LOG.stmt(d_module_base,d_progress,'l_return_status'||l_return_status);
1015: END IF;
1016:
1017: IF (l_return_status = FND_API.g_ret_sts_error)
1018: THEN
1019: RAISE FND_API.g_exc_error;
1020: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1021: THEN

Line 1019: RAISE FND_API.g_exc_error;

1015: END IF;
1016:
1017: IF (l_return_status = FND_API.g_ret_sts_error)
1018: THEN
1019: RAISE FND_API.g_exc_error;
1020: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1021: THEN
1022: RAISE FND_API.g_exc_unexpected_error;
1023: END IF; --l_return_status

Line 1020: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)

1016:
1017: IF (l_return_status = FND_API.g_ret_sts_error)
1018: THEN
1019: RAISE FND_API.g_exc_error;
1020: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1021: THEN
1022: RAISE FND_API.g_exc_unexpected_error;
1023: END IF; --l_return_status
1024: END IF;

Line 1022: RAISE FND_API.g_exc_unexpected_error;

1018: THEN
1019: RAISE FND_API.g_exc_error;
1020: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error)
1021: THEN
1022: RAISE FND_API.g_exc_unexpected_error;
1023: END IF; --l_return_status
1024: END IF;
1025: END IF; --l_req_encumbrance_flag
1026:

Line 1029: IF FND_API.To_Boolean(p_commit)

1025: END IF; --l_req_encumbrance_flag
1026:
1027: d_progress := 90;
1028:
1029: IF FND_API.To_Boolean(p_commit)
1030: THEN
1031: IF PO_LOG.d_event THEN
1032: PO_LOG.event(d_module_base,d_progress,'Commiting work');
1033: END IF;

Line 1035: END IF; --FND_API

1031: IF PO_LOG.d_event THEN
1032: PO_LOG.event(d_module_base,d_progress,'Commiting work');
1033: END IF;
1034: COMMIT WORK;
1035: END IF; --FND_API
1036:
1037: x_return_status := FND_API.g_ret_sts_success;
1038:
1039: IF (PO_LOG.d_proc)

Line 1037: x_return_status := FND_API.g_ret_sts_success;

1033: END IF;
1034: COMMIT WORK;
1035: END IF; --FND_API
1036:
1037: x_return_status := FND_API.g_ret_sts_success;
1038:
1039: IF (PO_LOG.d_proc)
1040: THEN
1041: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

Line 1046: WHEN FND_API.g_exc_unexpected_error THEN

1042: PO_LOG.proc_end(d_module_base,'x_msg_count', x_msg_count );
1043: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
1044: END IF;
1045: EXCEPTION
1046: WHEN FND_API.g_exc_unexpected_error THEN
1047: ROLLBACK TO post_requisition_lines_PVT;
1048: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1049: p_data => x_msg_data);
1050: IF(x_msg_count>0)THEN

Line 1062: x_return_status := FND_API.g_ret_sts_unexp_error;

1058: x_msg_data := FND_MESSAGE.get;
1059: x_error_msg_tbl.extend(1);
1060: x_error_msg_tbl(x_error_msg_tbl.COUNT) := x_msg_data;
1061:
1062: x_return_status := FND_API.g_ret_sts_unexp_error;
1063:
1064: IF (PO_LOG.d_exc)
1065: THEN
1066: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);

Line 1071: WHEN FND_API.g_exc_error THEN

1067: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);
1068: PO_LOG.proc_end(d_module_base,'x_msg_count', x_msg_count );
1069: PO_LOG.proc_end(d_module_base,'x_msg_data', x_msg_data );
1070: END IF;
1071: WHEN FND_API.g_exc_error THEN
1072: ROLLBACK TO post_requisition_lines_PVT;
1073:
1074: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1075: p_data => x_msg_data);

Line 1081: ,p_init_msg_list => FND_API.G_FALSE

1077: IF l_online_report_id IS NOT NULL THEN
1078: PO_Document_Control_PVT.add_online_report_msgs
1079: (
1080: p_api_version => 1.0
1081: ,p_init_msg_list => FND_API.G_FALSE
1082: ,x_return_status => x_return_status
1083: ,p_online_report_id => l_online_report_id);
1084: END IF;
1085:

Line 1096: x_return_status := FND_API.g_ret_sts_error;

1092: --
1093: --Set the return status at the end so that the call to add
1094: --online report msgs onto the stack doesn't override the value set
1095: --by the exception handler.
1096: x_return_status := FND_API.g_ret_sts_error;
1097: --
1098: IF (PO_LOG.d_exc)
1099: THEN
1100: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);

Line 1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1111: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1112: x_msg_data := FND_MESSAGE.get;
1113: x_error_msg_tbl.extend(1);
1114: x_error_msg_tbl(1) := x_msg_data;
1115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1116: IF (PO_LOG.d_exc)
1117: THEN
1118: PO_LOG.exc(d_module_base,d_progress, SQLCODE || SQLERRM);
1119: PO_LOG.proc_end(d_module_base,'x_return_status', x_return_status);

Line 1173: IF NOT FND_API.Compatible_API_Call(l_api_version,

1169: PO_LOG.proc_begin(d_module_base, 'p_req_line_id', p_req_line_id);
1170: END IF;
1171:
1172: d_progress := 20;
1173: IF NOT FND_API.Compatible_API_Call(l_api_version,
1174: p_api_version,
1175: l_module,
1176: G_PKG_NAME) THEN
1177: IF (PO_LOG.d_event) THEN

Line 1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1176: G_PKG_NAME) THEN
1177: IF (PO_LOG.d_event) THEN
1178: PO_LOG.event(d_module_base, d_progress, 'Api versions incompatible. Throwing an exception');
1179: END IF;
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: END IF;
1182:
1183: d_progress := 30;
1184:

Line 1222: RAISE FND_API.g_exc_unexpected_error;

1218: END IF;
1219:
1220: po_message_s.sql_error('No rows inserted into PO_REQ_SPLIT_LINES_GT', d_progress, sqlcode);
1221: FND_MSG_PUB.add;
1222: RAISE FND_API.g_exc_unexpected_error;
1223: END IF;
1224:
1225: d_progress := 40;
1226: IF PO_LOG.d_stmt THEN

Line 1240: RAISE FND_API.g_exc_unexpected_error;

1236: IF (x_return_status <> 'S') THEN
1237: IF PO_LOG.d_stmt THEN
1238: PO_LOG.stmt(d_module_base,d_progress,'x_return_status',x_return_status);
1239: END IF;
1240: RAISE FND_API.g_exc_unexpected_error;
1241: END IF;
1242: END IF; /*IF (p_handle_tax_flag = 'Y')*/
1243:
1244: d_progress := 50;

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

1255: PO_LOG.stmt(d_module_base, d_progress,'l_po_return_code', l_po_return_code);
1256: PO_LOG.stmt(d_module_base, d_progress,'x_online_report_id', x_online_report_id);
1257: END IF;
1258:
1259: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1260: RAISE FND_API.g_exc_error;
1261: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1262: RAISE FND_API.g_exc_unexpected_error;
1263: END IF;

Line 1260: RAISE FND_API.g_exc_error;

1256: PO_LOG.stmt(d_module_base, d_progress,'x_online_report_id', x_online_report_id);
1257: END IF;
1258:
1259: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1260: RAISE FND_API.g_exc_error;
1261: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1262: RAISE FND_API.g_exc_unexpected_error;
1263: END IF;
1264:

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

1257: END IF;
1258:
1259: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1260: RAISE FND_API.g_exc_error;
1261: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1262: RAISE FND_API.g_exc_unexpected_error;
1263: END IF;
1264:
1265: d_progress := 60;

Line 1262: RAISE FND_API.g_exc_unexpected_error;

1258:
1259: IF (x_return_status = FND_API.g_ret_sts_error) THEN
1260: RAISE FND_API.g_exc_error;
1261: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
1262: RAISE FND_API.g_exc_unexpected_error;
1263: END IF;
1264:
1265: d_progress := 60;
1266:

Line 1267: IF FND_API.To_Boolean(p_commit) THEN

1263: END IF;
1264:
1265: d_progress := 60;
1266:
1267: IF FND_API.To_Boolean(p_commit) THEN
1268: IF PO_LOG.d_event THEN
1269: PO_LOG.event(d_module_base, d_progress, 'Commiting work');
1270: END IF;
1271: COMMIT WORK;

Line 1277: x_return_status := FND_API.G_RET_STS_SUCCESS;

1273:
1274: -- Standard call to get message count and if count is 1,
1275: -- get message info.
1276: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1277: x_return_status := FND_API.G_RET_STS_SUCCESS;
1278:
1279: d_progress := 70;
1280:
1281: IF (PO_LOG.d_proc) THEN

Line 1290: WHEN FND_API.g_exc_unexpected_error THEN

1286: END IF;
1287:
1288: EXCEPTION
1289:
1290: WHEN FND_API.g_exc_unexpected_error THEN
1291:
1292: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1293:
1294: x_msg_data := FND_MSG_PUB.GET();

Line 1295: x_return_status := FND_API.g_ret_sts_unexp_error;

1291:
1292: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1293:
1294: x_msg_data := FND_MSG_PUB.GET();
1295: x_return_status := FND_API.g_ret_sts_unexp_error;
1296:
1297: IF (PO_LOG.d_exc) THEN
1298: PO_LOG.exc(d_module_base, d_progress, SQLCODE || SQLERRM);
1299: PO_LOG.proc_end(d_module_base, 'x_return_status', x_return_status);

Line 1305: WHEN FND_API.g_exc_error THEN

1301: PO_LOG.proc_end(d_module_base, 'x_msg_data', x_msg_data);
1302: PO_LOG.proc_end(d_module_base,'x_online_report_id',x_online_report_id);
1303: END IF;
1304:
1305: WHEN FND_API.g_exc_error THEN
1306:
1307: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1308:
1309: x_return_status := FND_API.g_ret_sts_error;

Line 1309: x_return_status := FND_API.g_ret_sts_error;

1305: WHEN FND_API.g_exc_error THEN
1306:
1307: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1308:
1309: x_return_status := FND_API.g_ret_sts_error;
1310:
1311: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1312: p_data => x_msg_data);
1313:

Line 1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1326: FND_MESSAGE.set_encoded(encoded_message =>FND_MSG_PUB.GET());
1327:
1328: ROLLBACK TO CALL_FUNDS_REVERSAL_PVT;
1329: x_msg_data := FND_MESSAGE.get;
1330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1331:
1332: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1333: p_data => x_msg_data);
1334: