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_DOCUMENT_CONTROL_GRP dependencies on FND_API

Line 23: * changes will be committed upon success if p_commit is FND_API.G_TRUE.

19: * level if the final doc_id, line_id, and line_loc_id are not NULL. Executes
20: * at line level if only the final doc_id and line_id are not NULL. Executes
21: * at header level if only the final doc_id is not NULL. The document will be
22: * printed if it is a PO, PA, or RELEASE, and the p_print_flag is 'Y'. All
23: * changes will be committed upon success if p_commit is FND_API.G_TRUE.
24: * Appends to API message list on error, and leaves the document unchanged.
25: * Returns:
26: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
27: * FND_API.G_RET_STS_ERROR if control action fails

Line 26: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds

22: * printed if it is a PO, PA, or RELEASE, and the p_print_flag is 'Y'. All
23: * changes will be committed upon success if p_commit is FND_API.G_TRUE.
24: * Appends to API message list on error, and leaves the document unchanged.
25: * Returns:
26: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
27: * FND_API.G_RET_STS_ERROR if control action fails
28: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
29: */
30: PROCEDURE control_document

Line 27: * FND_API.G_RET_STS_ERROR if control action fails

23: * changes will be committed upon success if p_commit is FND_API.G_TRUE.
24: * Appends to API message list on error, and leaves the document unchanged.
25: * Returns:
26: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
27: * FND_API.G_RET_STS_ERROR if control action fails
28: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
29: */
30: PROCEDURE control_document
31: (p_api_version IN NUMBER,

Line 28: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

24: * Appends to API message list on error, and leaves the document unchanged.
25: * Returns:
26: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
27: * FND_API.G_RET_STS_ERROR if control action fails
28: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
29: */
30: PROCEDURE control_document
31: (p_api_version IN NUMBER,
32: p_init_msg_list IN VARCHAR2,

Line 65: IF FND_API.to_boolean(p_init_msg_list) THEN

61:
62: BEGIN
63: -- Start standard API initialization
64: SAVEPOINT control_document_GRP;
65: IF FND_API.to_boolean(p_init_msg_list) THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
69: l_api_name, g_pkg_name)

Line 68: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

64: SAVEPOINT control_document_GRP;
65: IF FND_API.to_boolean(p_init_msg_list) THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
69: l_api_name, g_pkg_name)
70: THEN
71: RAISE FND_API.g_exc_unexpected_error;
72: END IF;

Line 71: RAISE FND_API.g_exc_unexpected_error;

67: END IF;
68: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
69: l_api_name, g_pkg_name)
70: THEN
71: RAISE FND_API.g_exc_unexpected_error;
72: END IF;
73: x_return_status := FND_API.g_ret_sts_success;
74: -- End standard API initialization
75:

Line 73: x_return_status := FND_API.g_ret_sts_success;

69: l_api_name, g_pkg_name)
70: THEN
71: RAISE FND_API.g_exc_unexpected_error;
72: END IF;
73: x_return_status := FND_API.g_ret_sts_success;
74: -- End standard API initialization
75:
76: IF (g_fnd_debug = 'Y') THEN
77: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 97: RAISE FND_API.g_exc_error;

93: '.invalid_action', FALSE);
94: END IF;
95: END IF;
96: FND_MSG_PUB.add;
97: RAISE FND_API.g_exc_error;
98: END IF;
99:
100: val_doc_params(p_api_version => 1.0,
101: p_init_msg_list => FND_API.G_FALSE,

Line 101: p_init_msg_list => FND_API.G_FALSE,

97: RAISE FND_API.g_exc_error;
98: END IF;
99:
100: val_doc_params(p_api_version => 1.0,
101: p_init_msg_list => FND_API.G_FALSE,
102: x_return_status => x_return_status,
103: p_doc_type => p_doc_type,
104: p_doc_subtype => p_doc_subtype,
105: p_doc_id => p_doc_id,

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

112: p_doc_shipment_num => p_doc_shipment_num,
113: x_doc_id => l_doc_id,
114: x_doc_line_id => l_doc_line_id,
115: x_doc_line_loc_id => l_doc_line_loc_id);
116: IF (x_return_status = FND_API.g_ret_sts_error) THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;

Line 117: RAISE FND_API.g_exc_error;

113: x_doc_id => l_doc_id,
114: x_doc_line_id => l_doc_line_id,
115: x_doc_line_loc_id => l_doc_line_loc_id);
116: IF (x_return_status = FND_API.g_ret_sts_error) THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121:

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

114: x_doc_line_id => l_doc_line_id,
115: x_doc_line_loc_id => l_doc_line_loc_id);
116: IF (x_return_status = FND_API.g_ret_sts_error) THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121:
122: PO_Document_Control_PVT.control_document

Line 119: RAISE FND_API.g_exc_unexpected_error;

115: x_doc_line_loc_id => l_doc_line_loc_id);
116: IF (x_return_status = FND_API.g_ret_sts_error) THEN
117: RAISE FND_API.g_exc_error;
118: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
119: RAISE FND_API.g_exc_unexpected_error;
120: END IF;
121:
122: PO_Document_Control_PVT.control_document
123: (p_api_version => 1.0,

Line 124: p_init_msg_list => FND_API.G_FALSE,

120: END IF;
121:
122: PO_Document_Control_PVT.control_document
123: (p_api_version => 1.0,
124: p_init_msg_list => FND_API.G_FALSE,
125: p_commit => FND_API.G_FALSE,
126: x_return_status => x_return_status,
127: p_doc_type => p_doc_type,
128: p_doc_subtype => p_doc_subtype,

Line 125: p_commit => FND_API.G_FALSE,

121:
122: PO_Document_Control_PVT.control_document
123: (p_api_version => 1.0,
124: p_init_msg_list => FND_API.G_FALSE,
125: p_commit => FND_API.G_FALSE,
126: x_return_status => x_return_status,
127: p_doc_type => p_doc_type,
128: p_doc_subtype => p_doc_subtype,
129: p_doc_id => l_doc_id,

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

138: p_note_to_vendor => p_note_to_vendor,
139: p_use_gldate => p_use_gldate --
140: );
141:
142: IF (x_return_status = FND_API.g_ret_sts_error) THEN
143: RAISE FND_API.g_exc_error;
144: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
145: RAISE FND_API.g_exc_unexpected_error;
146: END IF;

Line 143: RAISE FND_API.g_exc_error;

139: p_use_gldate => p_use_gldate --
140: );
141:
142: IF (x_return_status = FND_API.g_ret_sts_error) THEN
143: RAISE FND_API.g_exc_error;
144: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
145: RAISE FND_API.g_exc_unexpected_error;
146: END IF;
147:

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

140: );
141:
142: IF (x_return_status = FND_API.g_ret_sts_error) THEN
143: RAISE FND_API.g_exc_error;
144: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
145: RAISE FND_API.g_exc_unexpected_error;
146: END IF;
147:
148:

Line 145: RAISE FND_API.g_exc_unexpected_error;

141:
142: IF (x_return_status = FND_API.g_ret_sts_error) THEN
143: RAISE FND_API.g_exc_error;
144: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
145: RAISE FND_API.g_exc_unexpected_error;
146: END IF;
147:
148:
149: -- Standard API check of p_commit

Line 150: IF FND_API.to_boolean(p_commit) THEN

146: END IF;
147:
148:
149: -- Standard API check of p_commit
150: IF FND_API.to_boolean(p_commit) THEN
151: COMMIT WORK;
152: END IF;
153: EXCEPTION
154: WHEN FND_API.g_exc_error THEN

Line 154: WHEN FND_API.g_exc_error THEN

150: IF FND_API.to_boolean(p_commit) THEN
151: COMMIT WORK;
152: END IF;
153: EXCEPTION
154: WHEN FND_API.g_exc_error THEN
155: ROLLBACK TO control_document_GRP;
156: x_return_status := FND_API.g_ret_sts_error;
157: WHEN FND_API.g_exc_unexpected_error THEN
158: ROLLBACK TO control_document_GRP;

Line 156: x_return_status := FND_API.g_ret_sts_error;

152: END IF;
153: EXCEPTION
154: WHEN FND_API.g_exc_error THEN
155: ROLLBACK TO control_document_GRP;
156: x_return_status := FND_API.g_ret_sts_error;
157: WHEN FND_API.g_exc_unexpected_error THEN
158: ROLLBACK TO control_document_GRP;
159: x_return_status := FND_API.g_ret_sts_unexp_error;
160: WHEN OTHERS THEN

Line 157: WHEN FND_API.g_exc_unexpected_error THEN

153: EXCEPTION
154: WHEN FND_API.g_exc_error THEN
155: ROLLBACK TO control_document_GRP;
156: x_return_status := FND_API.g_ret_sts_error;
157: WHEN FND_API.g_exc_unexpected_error THEN
158: ROLLBACK TO control_document_GRP;
159: x_return_status := FND_API.g_ret_sts_unexp_error;
160: WHEN OTHERS THEN
161: ROLLBACK TO control_document_GRP;

Line 159: x_return_status := FND_API.g_ret_sts_unexp_error;

155: ROLLBACK TO control_document_GRP;
156: x_return_status := FND_API.g_ret_sts_error;
157: WHEN FND_API.g_exc_unexpected_error THEN
158: ROLLBACK TO control_document_GRP;
159: x_return_status := FND_API.g_ret_sts_unexp_error;
160: WHEN OTHERS THEN
161: ROLLBACK TO control_document_GRP;
162: x_return_status := FND_API.g_ret_sts_unexp_error;
163: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 162: x_return_status := FND_API.g_ret_sts_unexp_error;

158: ROLLBACK TO control_document_GRP;
159: x_return_status := FND_API.g_ret_sts_unexp_error;
160: WHEN OTHERS THEN
161: ROLLBACK TO control_document_GRP;
162: x_return_status := FND_API.g_ret_sts_unexp_error;
163: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
164: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
165: IF (g_fnd_debug = 'Y') THEN
166: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 189: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds

185: * not NULL. Control actions supported for p_action are: 'CANCEL'.
186: * Requisitions are currently not supported. Appends to API message list on
187: * error.
188: * Returns:
189: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
190: * FND_API.G_RET_STS_ERROR if validation fails
191: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
192: */
193: PROCEDURE validate_control_action

Line 190: * FND_API.G_RET_STS_ERROR if validation fails

186: * Requisitions are currently not supported. Appends to API message list on
187: * error.
188: * Returns:
189: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
190: * FND_API.G_RET_STS_ERROR if validation fails
191: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
192: */
193: PROCEDURE validate_control_action
194: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

Line 191: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

187: * error.
188: * Returns:
189: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
190: * FND_API.G_RET_STS_ERROR if validation fails
191: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
192: */
193: PROCEDURE validate_control_action
194: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
195: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

Line 216: x_return_status := FND_API.g_ret_sts_success;

212: l_doc_line_id NUMBER;
213: l_doc_line_loc_id NUMBER;
214:
215: BEGIN
216: x_return_status := FND_API.g_ret_sts_success;
217:
218: IF (g_fnd_debug = 'Y') THEN
219: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
220: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

Line 238: RAISE FND_API.g_exc_error;

234: '.invalid_action', FALSE);
235: END IF;
236: END IF;
237: FND_MSG_PUB.add;
238: RAISE FND_API.g_exc_error;
239: END IF;
240:
241: val_doc_params(p_api_version => 1.0,
242: p_init_msg_list => FND_API.G_FALSE,

Line 242: p_init_msg_list => FND_API.G_FALSE,

238: RAISE FND_API.g_exc_error;
239: END IF;
240:
241: val_doc_params(p_api_version => 1.0,
242: p_init_msg_list => FND_API.G_FALSE,
243: x_return_status => x_return_status,
244: p_doc_type => p_doc_type,
245: p_doc_subtype => p_doc_subtype,
246: p_doc_id => p_doc_id,

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

253: p_doc_shipment_num => p_doc_shipment_num,
254: x_doc_id => l_doc_id,
255: x_doc_line_id => l_doc_line_id,
256: x_doc_line_loc_id => l_doc_line_loc_id);
257: IF (x_return_status = FND_API.g_ret_sts_error) THEN
258: RAISE FND_API.g_exc_error;
259: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
260: RAISE FND_API.g_exc_unexpected_error;
261: END IF;

Line 258: RAISE FND_API.g_exc_error;

254: x_doc_id => l_doc_id,
255: x_doc_line_id => l_doc_line_id,
256: x_doc_line_loc_id => l_doc_line_loc_id);
257: IF (x_return_status = FND_API.g_ret_sts_error) THEN
258: RAISE FND_API.g_exc_error;
259: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
260: RAISE FND_API.g_exc_unexpected_error;
261: END IF;
262:

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

255: x_doc_line_id => l_doc_line_id,
256: x_doc_line_loc_id => l_doc_line_loc_id);
257: IF (x_return_status = FND_API.g_ret_sts_error) THEN
258: RAISE FND_API.g_exc_error;
259: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
260: RAISE FND_API.g_exc_unexpected_error;
261: END IF;
262:
263: -- Call private level validation. If the agent ID is not NULL, then user

Line 260: RAISE FND_API.g_exc_unexpected_error;

256: x_doc_line_loc_id => l_doc_line_loc_id);
257: IF (x_return_status = FND_API.g_ret_sts_error) THEN
258: RAISE FND_API.g_exc_error;
259: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
260: RAISE FND_API.g_exc_unexpected_error;
261: END IF;
262:
263: -- Call private level validation. If the agent ID is not NULL, then user
264: -- authority and document access levels will be validated as well.

Line 267: p_init_msg_list => FND_API.G_FALSE,

263: -- Call private level validation. If the agent ID is not NULL, then user
264: -- authority and document access levels will be validated as well.
265: PO_Document_Control_PVT.val_control_action
266: (p_api_version => 1.0,
267: p_init_msg_list => FND_API.G_FALSE,
268: x_return_status => x_return_status,
269: p_doc_type => p_doc_type,
270: p_doc_subtype => p_doc_subtype,
271: p_doc_id => l_doc_id,

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

274: p_action => p_action,
275: p_agent_id => p_agent_id,
276: x_control_level => l_control_level);
277:
278: IF (x_return_status = FND_API.g_ret_sts_error) THEN
279: RAISE FND_API.g_exc_error;
280: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;

Line 279: RAISE FND_API.g_exc_error;

275: p_agent_id => p_agent_id,
276: x_control_level => l_control_level);
277:
278: IF (x_return_status = FND_API.g_ret_sts_error) THEN
279: RAISE FND_API.g_exc_error;
280: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;
283:

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

276: x_control_level => l_control_level);
277:
278: IF (x_return_status = FND_API.g_ret_sts_error) THEN
279: RAISE FND_API.g_exc_error;
280: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;
283:
284: EXCEPTION

Line 281: RAISE FND_API.g_exc_unexpected_error;

277:
278: IF (x_return_status = FND_API.g_ret_sts_error) THEN
279: RAISE FND_API.g_exc_error;
280: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;
283:
284: EXCEPTION
285: WHEN FND_API.g_exc_error THEN

Line 285: WHEN FND_API.g_exc_error THEN

281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;
283:
284: EXCEPTION
285: WHEN FND_API.g_exc_error THEN
286: x_return_status := FND_API.g_ret_sts_error;
287: WHEN FND_API.g_exc_unexpected_error THEN
288: x_return_status := FND_API.g_ret_sts_unexp_error;
289: WHEN OTHERS THEN

Line 286: x_return_status := FND_API.g_ret_sts_error;

282: END IF;
283:
284: EXCEPTION
285: WHEN FND_API.g_exc_error THEN
286: x_return_status := FND_API.g_ret_sts_error;
287: WHEN FND_API.g_exc_unexpected_error THEN
288: x_return_status := FND_API.g_ret_sts_unexp_error;
289: WHEN OTHERS THEN
290: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 287: WHEN FND_API.g_exc_unexpected_error THEN

283:
284: EXCEPTION
285: WHEN FND_API.g_exc_error THEN
286: x_return_status := FND_API.g_ret_sts_error;
287: WHEN FND_API.g_exc_unexpected_error THEN
288: x_return_status := FND_API.g_ret_sts_unexp_error;
289: WHEN OTHERS THEN
290: x_return_status := FND_API.g_ret_sts_unexp_error;
291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 288: x_return_status := FND_API.g_ret_sts_unexp_error;

284: EXCEPTION
285: WHEN FND_API.g_exc_error THEN
286: x_return_status := FND_API.g_ret_sts_error;
287: WHEN FND_API.g_exc_unexpected_error THEN
288: x_return_status := FND_API.g_ret_sts_unexp_error;
289: WHEN OTHERS THEN
290: x_return_status := FND_API.g_ret_sts_unexp_error;
291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
292: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 290: x_return_status := FND_API.g_ret_sts_unexp_error;

286: x_return_status := FND_API.g_ret_sts_error;
287: WHEN FND_API.g_exc_unexpected_error THEN
288: x_return_status := FND_API.g_ret_sts_unexp_error;
289: WHEN OTHERS THEN
290: x_return_status := FND_API.g_ret_sts_unexp_error;
291: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
292: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
293: IF (g_fnd_debug = 'Y') THEN
294: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 317: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds

313: * not NULL. Control actions supported for p_action are: 'CANCEL'.
314: * Requisitions are currently not supported. Appends to API message list on
315: * error.
316: * Returns:
317: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
318: * FND_API.G_RET_STS_ERROR if validation fails
319: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
320: */
321: PROCEDURE val_control_action

Line 318: * FND_API.G_RET_STS_ERROR if validation fails

314: * Requisitions are currently not supported. Appends to API message list on
315: * error.
316: * Returns:
317: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
318: * FND_API.G_RET_STS_ERROR if validation fails
319: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
320: */
321: PROCEDURE val_control_action
322: (p_api_version IN NUMBER,

Line 319: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

315: * error.
316: * Returns:
317: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
318: * FND_API.G_RET_STS_ERROR if validation fails
319: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
320: */
321: PROCEDURE val_control_action
322: (p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2,

Line 346: IF FND_API.to_boolean(p_init_msg_list) THEN

342: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;
343:
344: BEGIN
345: -- Start standard API initialization
346: IF FND_API.to_boolean(p_init_msg_list) THEN
347: FND_MSG_PUB.initialize;
348: END IF;
349: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
350: l_api_name, g_pkg_name)

Line 349: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

345: -- Start standard API initialization
346: IF FND_API.to_boolean(p_init_msg_list) THEN
347: FND_MSG_PUB.initialize;
348: END IF;
349: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
350: l_api_name, g_pkg_name)
351: THEN
352: RAISE FND_API.g_exc_unexpected_error;
353: END IF;

Line 352: RAISE FND_API.g_exc_unexpected_error;

348: END IF;
349: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
350: l_api_name, g_pkg_name)
351: THEN
352: RAISE FND_API.g_exc_unexpected_error;
353: END IF;
354: x_return_status := FND_API.g_ret_sts_success;
355: -- End standard API initialization
356:

Line 354: x_return_status := FND_API.g_ret_sts_success;

350: l_api_name, g_pkg_name)
351: THEN
352: RAISE FND_API.g_exc_unexpected_error;
353: END IF;
354: x_return_status := FND_API.g_ret_sts_success;
355: -- End standard API initialization
356:
357: -- Ensure that we are not using a NULL agent ID.
358: IF (l_agent_id IS NULL) THEN

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

383: p_doc_shipment_num => p_doc_shipment_num,
384: p_action => p_action,
385: p_agent_id => l_agent_id,
386: x_return_status => x_return_status);
387: IF (x_return_status = FND_API.g_ret_sts_error) THEN
388: RAISE FND_API.g_exc_error;
389: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;

Line 388: RAISE FND_API.g_exc_error;

384: p_action => p_action,
385: p_agent_id => l_agent_id,
386: x_return_status => x_return_status);
387: IF (x_return_status = FND_API.g_ret_sts_error) THEN
388: RAISE FND_API.g_exc_error;
389: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;
392:

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

385: p_agent_id => l_agent_id,
386: x_return_status => x_return_status);
387: IF (x_return_status = FND_API.g_ret_sts_error) THEN
388: RAISE FND_API.g_exc_error;
389: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;
392:
393: EXCEPTION

Line 390: RAISE FND_API.g_exc_unexpected_error;

386: x_return_status => x_return_status);
387: IF (x_return_status = FND_API.g_ret_sts_error) THEN
388: RAISE FND_API.g_exc_error;
389: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;
392:
393: EXCEPTION
394: WHEN FND_API.g_exc_error THEN

Line 394: WHEN FND_API.g_exc_error THEN

390: RAISE FND_API.g_exc_unexpected_error;
391: END IF;
392:
393: EXCEPTION
394: WHEN FND_API.g_exc_error THEN
395: x_return_status := FND_API.g_ret_sts_error;
396: WHEN FND_API.g_exc_unexpected_error THEN
397: x_return_status := FND_API.g_ret_sts_unexp_error;
398: WHEN OTHERS THEN

Line 395: x_return_status := FND_API.g_ret_sts_error;

391: END IF;
392:
393: EXCEPTION
394: WHEN FND_API.g_exc_error THEN
395: x_return_status := FND_API.g_ret_sts_error;
396: WHEN FND_API.g_exc_unexpected_error THEN
397: x_return_status := FND_API.g_ret_sts_unexp_error;
398: WHEN OTHERS THEN
399: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 396: WHEN FND_API.g_exc_unexpected_error THEN

392:
393: EXCEPTION
394: WHEN FND_API.g_exc_error THEN
395: x_return_status := FND_API.g_ret_sts_error;
396: WHEN FND_API.g_exc_unexpected_error THEN
397: x_return_status := FND_API.g_ret_sts_unexp_error;
398: WHEN OTHERS THEN
399: x_return_status := FND_API.g_ret_sts_unexp_error;
400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 397: x_return_status := FND_API.g_ret_sts_unexp_error;

393: EXCEPTION
394: WHEN FND_API.g_exc_error THEN
395: x_return_status := FND_API.g_ret_sts_error;
396: WHEN FND_API.g_exc_unexpected_error THEN
397: x_return_status := FND_API.g_ret_sts_unexp_error;
398: WHEN OTHERS THEN
399: x_return_status := FND_API.g_ret_sts_unexp_error;
400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
401: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 399: x_return_status := FND_API.g_ret_sts_unexp_error;

395: x_return_status := FND_API.g_ret_sts_error;
396: WHEN FND_API.g_exc_unexpected_error THEN
397: x_return_status := FND_API.g_ret_sts_unexp_error;
398: WHEN OTHERS THEN
399: x_return_status := FND_API.g_ret_sts_unexp_error;
400: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
401: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
402: IF (g_fnd_debug = 'Y') THEN
403: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 426: * x_return_status - FND_API.G_RET_STS_SUCCESS if check succeeds

422: * at header level if the final doc_id is not NULL. Control actions supported
423: * for p_action are: 'CANCEL'. Requisitions are currently not supported.
424: * Appends to API message list on error.
425: * Returns:
426: * x_return_status - FND_API.G_RET_STS_SUCCESS if check succeeds
427: * FND_API.G_RET_STS_ERROR if check fails
428: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
429: */
430: PROCEDURE check_control_action

Line 427: * FND_API.G_RET_STS_ERROR if check fails

423: * for p_action are: 'CANCEL'. Requisitions are currently not supported.
424: * Appends to API message list on error.
425: * Returns:
426: * x_return_status - FND_API.G_RET_STS_SUCCESS if check succeeds
427: * FND_API.G_RET_STS_ERROR if check fails
428: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
429: */
430: PROCEDURE check_control_action
431: (p_api_version IN NUMBER,

Line 428: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

424: * Appends to API message list on error.
425: * Returns:
426: * x_return_status - FND_API.G_RET_STS_SUCCESS if check succeeds
427: * FND_API.G_RET_STS_ERROR if check fails
428: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
429: */
430: PROCEDURE check_control_action
431: (p_api_version IN NUMBER,
432: p_init_msg_list IN VARCHAR2,

Line 452: IF FND_API.to_boolean(p_init_msg_list) THEN

448: l_api_version CONSTANT NUMBER := 1.0;
449:
450: BEGIN
451: -- Start standard API initialization
452: IF FND_API.to_boolean(p_init_msg_list) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
456: l_api_name, g_pkg_name)

Line 455: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

451: -- Start standard API initialization
452: IF FND_API.to_boolean(p_init_msg_list) THEN
453: FND_MSG_PUB.initialize;
454: END IF;
455: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
456: l_api_name, g_pkg_name)
457: THEN
458: RAISE FND_API.g_exc_unexpected_error;
459: END IF;

Line 458: RAISE FND_API.g_exc_unexpected_error;

454: END IF;
455: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
456: l_api_name, g_pkg_name)
457: THEN
458: RAISE FND_API.g_exc_unexpected_error;
459: END IF;
460: x_return_status := FND_API.g_ret_sts_success;
461: -- End standard API initialization
462:

Line 460: x_return_status := FND_API.g_ret_sts_success;

456: l_api_name, g_pkg_name)
457: THEN
458: RAISE FND_API.g_exc_unexpected_error;
459: END IF;
460: x_return_status := FND_API.g_ret_sts_success;
461: -- End standard API initialization
462:
463: IF (g_fnd_debug = 'Y') THEN
464: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

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

483: p_doc_shipment_num => p_doc_shipment_num,
484: p_action => p_action,
485: p_agent_id => NULL,
486: x_return_status => x_return_status);
487: IF (x_return_status = FND_API.g_ret_sts_error) THEN
488: RAISE FND_API.g_exc_error;
489: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;

Line 488: RAISE FND_API.g_exc_error;

484: p_action => p_action,
485: p_agent_id => NULL,
486: x_return_status => x_return_status);
487: IF (x_return_status = FND_API.g_ret_sts_error) THEN
488: RAISE FND_API.g_exc_error;
489: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;
492:

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

485: p_agent_id => NULL,
486: x_return_status => x_return_status);
487: IF (x_return_status = FND_API.g_ret_sts_error) THEN
488: RAISE FND_API.g_exc_error;
489: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;
492:
493: EXCEPTION

Line 490: RAISE FND_API.g_exc_unexpected_error;

486: x_return_status => x_return_status);
487: IF (x_return_status = FND_API.g_ret_sts_error) THEN
488: RAISE FND_API.g_exc_error;
489: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;
492:
493: EXCEPTION
494: WHEN FND_API.g_exc_error THEN

Line 494: WHEN FND_API.g_exc_error THEN

490: RAISE FND_API.g_exc_unexpected_error;
491: END IF;
492:
493: EXCEPTION
494: WHEN FND_API.g_exc_error THEN
495: x_return_status := FND_API.g_ret_sts_error;
496: WHEN FND_API.g_exc_unexpected_error THEN
497: x_return_status := FND_API.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN

Line 495: x_return_status := FND_API.g_ret_sts_error;

491: END IF;
492:
493: EXCEPTION
494: WHEN FND_API.g_exc_error THEN
495: x_return_status := FND_API.g_ret_sts_error;
496: WHEN FND_API.g_exc_unexpected_error THEN
497: x_return_status := FND_API.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN
499: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 496: WHEN FND_API.g_exc_unexpected_error THEN

492:
493: EXCEPTION
494: WHEN FND_API.g_exc_error THEN
495: x_return_status := FND_API.g_ret_sts_error;
496: WHEN FND_API.g_exc_unexpected_error THEN
497: x_return_status := FND_API.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN
499: x_return_status := FND_API.g_ret_sts_unexp_error;
500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 497: x_return_status := FND_API.g_ret_sts_unexp_error;

493: EXCEPTION
494: WHEN FND_API.g_exc_error THEN
495: x_return_status := FND_API.g_ret_sts_error;
496: WHEN FND_API.g_exc_unexpected_error THEN
497: x_return_status := FND_API.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN
499: x_return_status := FND_API.g_ret_sts_unexp_error;
500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
501: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 499: x_return_status := FND_API.g_ret_sts_unexp_error;

495: x_return_status := FND_API.g_ret_sts_error;
496: WHEN FND_API.g_exc_unexpected_error THEN
497: x_return_status := FND_API.g_ret_sts_unexp_error;
498: WHEN OTHERS THEN
499: x_return_status := FND_API.g_ret_sts_unexp_error;
500: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
501: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
502: IF (g_fnd_debug = 'Y') THEN
503: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 521: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly

517: * in. If both the ID and number are passed in, the ID is used for validation.
518: * The final IDs must match the document specified. Appends to API message
519: * list on error.
520: * Returns:
521: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
522: * FND_API.G_RET_STS_ERROR if error occurred
523: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
524: */
525: PROCEDURE val_po_params

Line 522: * FND_API.G_RET_STS_ERROR if error occurred

518: * The final IDs must match the document specified. Appends to API message
519: * list on error.
520: * Returns:
521: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
522: * FND_API.G_RET_STS_ERROR if error occurred
523: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
524: */
525: PROCEDURE val_po_params
526: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

Line 523: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

519: * list on error.
520: * Returns:
521: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
522: * FND_API.G_RET_STS_ERROR if error occurred
523: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
524: */
525: PROCEDURE val_po_params
526: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
527: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

Line 545: x_return_status := FND_API.g_ret_sts_success;

541: l_exists VARCHAR2(10);
542: l_control_level NUMBER;
543:
544: BEGIN
545: x_return_status := FND_API.g_ret_sts_success;
546:
547: IF (g_fnd_debug = 'Y') THEN
548: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
549: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

Line 567: RAISE FND_API.g_exc_error;

563: || '.invalid_doc_ids', FALSE);
564: END IF;
565: END IF;
566: FND_MSG_PUB.add;
567: RAISE FND_API.g_exc_error;
568: END IF; --
569:
570: -- initialize outputs
571: x_doc_id := p_doc_id;

Line 668: RAISE FND_API.g_exc_error;

664: l_api_name || '.pa_has_ship_ids', FALSE);
665: END IF;
666: END IF;
667: FND_MSG_PUB.add;
668: RAISE FND_API.g_exc_error;
669: END IF; --
670:
671: END IF; --
672:

Line 677: x_return_status := FND_API.g_ret_sts_error;

673: END IF; -- g_header_level>
674:
675: EXCEPTION
676: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
677: x_return_status := FND_API.g_ret_sts_error;
678: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
679: IF (g_fnd_debug = 'Y') THEN
680: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
681: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name ||

Line 686: WHEN FND_API.g_exc_error THEN

682: '.invalid_doc_ids', FALSE);
683: END IF;
684: END IF;
685: FND_MSG_PUB.add;
686: WHEN FND_API.g_exc_error THEN
687: x_return_status := FND_API.g_ret_sts_error;
688: WHEN OTHERS THEN
689: x_return_status := FND_API.g_ret_sts_unexp_error;
690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 687: x_return_status := FND_API.g_ret_sts_error;

683: END IF;
684: END IF;
685: FND_MSG_PUB.add;
686: WHEN FND_API.g_exc_error THEN
687: x_return_status := FND_API.g_ret_sts_error;
688: WHEN OTHERS THEN
689: x_return_status := FND_API.g_ret_sts_unexp_error;
690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
691: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 689: x_return_status := FND_API.g_ret_sts_unexp_error;

685: FND_MSG_PUB.add;
686: WHEN FND_API.g_exc_error THEN
687: x_return_status := FND_API.g_ret_sts_error;
688: WHEN OTHERS THEN
689: x_return_status := FND_API.g_ret_sts_unexp_error;
690: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
691: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
692: IF (g_fnd_debug = 'Y') THEN
693: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 711: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly

707: * in. If both the ID and number are passed in, the ID is used for validation.
708: * The final IDs must match the document specified. Appends to API message
709: * list on error.
710: * Returns:
711: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
712: * FND_API.G_RET_STS_ERROR if error occurred
713: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
714: */
715: PROCEDURE val_rel_params

Line 712: * FND_API.G_RET_STS_ERROR if error occurred

708: * The final IDs must match the document specified. Appends to API message
709: * list on error.
710: * Returns:
711: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
712: * FND_API.G_RET_STS_ERROR if error occurred
713: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
714: */
715: PROCEDURE val_rel_params
716: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

Line 713: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

709: * list on error.
710: * Returns:
711: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
712: * FND_API.G_RET_STS_ERROR if error occurred
713: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
714: */
715: PROCEDURE val_rel_params
716: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
717: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

Line 736: x_return_status := FND_API.g_ret_sts_success;

732: l_release_po_header_id NUMBER;
733: l_release_po_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
734:
735: BEGIN
736: x_return_status := FND_API.g_ret_sts_success;
737:
738: IF (g_fnd_debug = 'Y') THEN
739: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
740: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

Line 759: RAISE FND_API.g_exc_error;

755: || '.invalid_doc_ids', FALSE);
756: END IF;
757: END IF;
758: FND_MSG_PUB.add;
759: RAISE FND_API.g_exc_error;
760: END IF; --
761:
762: -- initialize output
763: x_doc_id := p_release_id;

Line 859: x_return_status := FND_API.g_ret_sts_error;

855: END IF; --
856:
857: EXCEPTION
858: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
859: x_return_status := FND_API.g_ret_sts_error;
860: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
861: IF (g_fnd_debug = 'Y') THEN
862: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
863: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name ||

Line 868: WHEN FND_API.g_exc_error THEN

864: '.invalid_doc_ids', FALSE);
865: END IF;
866: END IF;
867: FND_MSG_PUB.add;
868: WHEN FND_API.g_exc_error THEN
869: x_return_status := FND_API.g_ret_sts_error;
870: WHEN OTHERS THEN
871: x_return_status := FND_API.g_ret_sts_unexp_error;
872: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 869: x_return_status := FND_API.g_ret_sts_error;

865: END IF;
866: END IF;
867: FND_MSG_PUB.add;
868: WHEN FND_API.g_exc_error THEN
869: x_return_status := FND_API.g_ret_sts_error;
870: WHEN OTHERS THEN
871: x_return_status := FND_API.g_ret_sts_unexp_error;
872: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
873: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 871: x_return_status := FND_API.g_ret_sts_unexp_error;

867: FND_MSG_PUB.add;
868: WHEN FND_API.g_exc_error THEN
869: x_return_status := FND_API.g_ret_sts_error;
870: WHEN OTHERS THEN
871: x_return_status := FND_API.g_ret_sts_unexp_error;
872: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
873: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
874: IF (g_fnd_debug = 'Y') THEN
875: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 893: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds

889: * document specified. Derives any ID if the ID is NULL, but the matching
890: * number is passed in. If both the ID and number are passed in, the ID is
891: * used. Appends to API message list on error.
892: * Returns:
893: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
894: * FND_API.G_RET_STS_ERROR if validation fails
895: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
896: * x_doc_id - The valid document ID
897: * x_doc_line_id - The valid line ID, if at line level

Line 894: * FND_API.G_RET_STS_ERROR if validation fails

890: * number is passed in. If both the ID and number are passed in, the ID is
891: * used. Appends to API message list on error.
892: * Returns:
893: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
894: * FND_API.G_RET_STS_ERROR if validation fails
895: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
896: * x_doc_id - The valid document ID
897: * x_doc_line_id - The valid line ID, if at line level
898: * x_doc_line_loc_id - The valid line location ID, if at shipment level

Line 895: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

891: * used. Appends to API message list on error.
892: * Returns:
893: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
894: * FND_API.G_RET_STS_ERROR if validation fails
895: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
896: * x_doc_id - The valid document ID
897: * x_doc_line_id - The valid line ID, if at line level
898: * x_doc_line_loc_id - The valid line location ID, if at shipment level
899: */

Line 928: IF FND_API.to_boolean(p_init_msg_list) THEN

924: l_release_po_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
925:
926: BEGIN
927: -- Start standard API initialization
928: IF FND_API.to_boolean(p_init_msg_list) THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
932: l_api_name, g_pkg_name)

Line 931: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

927: -- Start standard API initialization
928: IF FND_API.to_boolean(p_init_msg_list) THEN
929: FND_MSG_PUB.initialize;
930: END IF;
931: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
932: l_api_name, g_pkg_name)
933: THEN
934: RAISE FND_API.g_exc_unexpected_error;
935: END IF;

Line 934: RAISE FND_API.g_exc_unexpected_error;

930: END IF;
931: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
932: l_api_name, g_pkg_name)
933: THEN
934: RAISE FND_API.g_exc_unexpected_error;
935: END IF;
936: x_return_status := FND_API.g_ret_sts_success;
937: -- End standard API initialization
938:

Line 936: x_return_status := FND_API.g_ret_sts_success;

932: l_api_name, g_pkg_name)
933: THEN
934: RAISE FND_API.g_exc_unexpected_error;
935: END IF;
936: x_return_status := FND_API.g_ret_sts_success;
937: -- End standard API initialization
938:
939: IF (g_fnd_debug = 'Y') THEN
940: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 966: RAISE FND_API.g_exc_error;

962: '.invalid_doc_type', FALSE);
963: END IF;
964: END IF;
965: FND_MSG_PUB.add;
966: RAISE FND_API.g_exc_error;
967: END IF;
968:
969: IF (p_doc_type IN ('PO','PA')) THEN
970:

Line 981: RAISE FND_API.g_exc_error;

977: '.po_pa_has_release_info', FALSE);
978: END IF;
979: END IF;
980: FND_MSG_PUB.add;
981: RAISE FND_API.g_exc_error;
982: END IF; --
983:
984: val_po_params(p_doc_type => p_doc_type,
985: p_doc_subtype => p_doc_subtype,

Line 1009: RAISE FND_API.g_exc_error;

1005: '.release_has_line_ids', FALSE);
1006: END IF;
1007: END IF;
1008: FND_MSG_PUB.add;
1009: RAISE FND_API.g_exc_error;
1010: END IF; --
1011:
1012: val_rel_params(p_doc_type => p_doc_type,
1013: p_doc_subtype => p_doc_subtype,

Line 1029: WHEN FND_API.g_exc_error THEN

1025:
1026: END IF; --
1027:
1028: EXCEPTION
1029: WHEN FND_API.g_exc_error THEN
1030: x_return_status := FND_API.g_ret_sts_error;
1031: WHEN FND_API.g_exc_unexpected_error THEN
1032: x_return_status := FND_API.g_ret_sts_unexp_error;
1033: WHEN OTHERS THEN

Line 1030: x_return_status := FND_API.g_ret_sts_error;

1026: END IF; --
1027:
1028: EXCEPTION
1029: WHEN FND_API.g_exc_error THEN
1030: x_return_status := FND_API.g_ret_sts_error;
1031: WHEN FND_API.g_exc_unexpected_error THEN
1032: x_return_status := FND_API.g_ret_sts_unexp_error;
1033: WHEN OTHERS THEN
1034: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1031: WHEN FND_API.g_exc_unexpected_error THEN

1027:
1028: EXCEPTION
1029: WHEN FND_API.g_exc_error THEN
1030: x_return_status := FND_API.g_ret_sts_error;
1031: WHEN FND_API.g_exc_unexpected_error THEN
1032: x_return_status := FND_API.g_ret_sts_unexp_error;
1033: WHEN OTHERS THEN
1034: x_return_status := FND_API.g_ret_sts_unexp_error;
1035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1032: x_return_status := FND_API.g_ret_sts_unexp_error;

1028: EXCEPTION
1029: WHEN FND_API.g_exc_error THEN
1030: x_return_status := FND_API.g_ret_sts_error;
1031: WHEN FND_API.g_exc_unexpected_error THEN
1032: x_return_status := FND_API.g_ret_sts_unexp_error;
1033: WHEN OTHERS THEN
1034: x_return_status := FND_API.g_ret_sts_unexp_error;
1035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1036: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1034: x_return_status := FND_API.g_ret_sts_unexp_error;

1030: x_return_status := FND_API.g_ret_sts_error;
1031: WHEN FND_API.g_exc_unexpected_error THEN
1032: x_return_status := FND_API.g_ret_sts_unexp_error;
1033: WHEN OTHERS THEN
1034: x_return_status := FND_API.g_ret_sts_unexp_error;
1035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1036: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1037: IF (g_fnd_debug = 'Y') THEN
1038: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN