DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CONTROL_PUB dependencies on FND_API

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

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

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

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

Line 28: * FND_API.G_RET_STS_ERROR if control action fails

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

Line 29: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

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

Line 64: IF FND_API.to_boolean(p_init_msg_list) THEN

60: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;
61: BEGIN
62: -- Start standard API initialization
63: SAVEPOINT control_document_PUB;
64: IF FND_API.to_boolean(p_init_msg_list) THEN
65: FND_MSG_PUB.initialize;
66: END IF;
67: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
68: l_api_name, g_pkg_name)

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

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

Line 70: RAISE FND_API.g_exc_unexpected_error;

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

Line 72: x_return_status := FND_API.g_ret_sts_success;

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

Line 91: p_init_msg_list => FND_API.G_FALSE,

87: --
88:
89: PO_Document_Control_GRP.control_document
90: (p_api_version => 1.0,
91: p_init_msg_list => FND_API.G_FALSE,
92: p_commit => FND_API.G_FALSE,
93: x_return_status => x_return_status,
94: p_doc_type => p_doc_type,
95: p_doc_subtype => p_doc_subtype,

Line 92: p_commit => FND_API.G_FALSE,

88:
89: PO_Document_Control_GRP.control_document
90: (p_api_version => 1.0,
91: p_init_msg_list => FND_API.G_FALSE,
92: p_commit => FND_API.G_FALSE,
93: x_return_status => x_return_status,
94: p_doc_type => p_doc_type,
95: p_doc_subtype => p_doc_subtype,
96: p_doc_id => p_doc_id,

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

111: p_use_gldate => p_use_gldate, --
112: p_launch_approvals_flag => p_launch_approvals_flag --
113: );
114:
115: IF (x_return_status = FND_API.g_ret_sts_error) THEN
116: RAISE FND_API.g_exc_error;
117: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: END IF;

Line 116: RAISE FND_API.g_exc_error;

112: p_launch_approvals_flag => p_launch_approvals_flag --
113: );
114:
115: IF (x_return_status = FND_API.g_ret_sts_error) THEN
116: RAISE FND_API.g_exc_error;
117: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: END IF;
120:

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

113: );
114:
115: IF (x_return_status = FND_API.g_ret_sts_error) THEN
116: RAISE FND_API.g_exc_error;
117: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: END IF;
120:
121:

Line 118: RAISE FND_API.g_exc_unexpected_error;

114:
115: IF (x_return_status = FND_API.g_ret_sts_error) THEN
116: RAISE FND_API.g_exc_error;
117: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: END IF;
120:
121:
122: -- Standard API check of p_commit

Line 123: IF FND_API.to_boolean(p_commit) THEN

119: END IF;
120:
121:
122: -- Standard API check of p_commit
123: IF FND_API.to_boolean(p_commit) THEN
124: COMMIT WORK;
125: END IF;
126: EXCEPTION
127: WHEN FND_API.g_exc_error THEN

Line 127: WHEN FND_API.g_exc_error THEN

123: IF FND_API.to_boolean(p_commit) THEN
124: COMMIT WORK;
125: END IF;
126: EXCEPTION
127: WHEN FND_API.g_exc_error THEN
128: ROLLBACK TO control_document_PUB;
129: x_return_status := FND_API.g_ret_sts_error;
130: WHEN FND_API.g_exc_unexpected_error THEN
131: ROLLBACK TO control_document_PUB;

Line 129: x_return_status := FND_API.g_ret_sts_error;

125: END IF;
126: EXCEPTION
127: WHEN FND_API.g_exc_error THEN
128: ROLLBACK TO control_document_PUB;
129: x_return_status := FND_API.g_ret_sts_error;
130: WHEN FND_API.g_exc_unexpected_error THEN
131: ROLLBACK TO control_document_PUB;
132: x_return_status := FND_API.g_ret_sts_unexp_error;
133: WHEN OTHERS THEN

Line 130: WHEN FND_API.g_exc_unexpected_error THEN

126: EXCEPTION
127: WHEN FND_API.g_exc_error THEN
128: ROLLBACK TO control_document_PUB;
129: x_return_status := FND_API.g_ret_sts_error;
130: WHEN FND_API.g_exc_unexpected_error THEN
131: ROLLBACK TO control_document_PUB;
132: x_return_status := FND_API.g_ret_sts_unexp_error;
133: WHEN OTHERS THEN
134: ROLLBACK TO control_document_PUB;

Line 132: x_return_status := FND_API.g_ret_sts_unexp_error;

128: ROLLBACK TO control_document_PUB;
129: x_return_status := FND_API.g_ret_sts_error;
130: WHEN FND_API.g_exc_unexpected_error THEN
131: ROLLBACK TO control_document_PUB;
132: x_return_status := FND_API.g_ret_sts_unexp_error;
133: WHEN OTHERS THEN
134: ROLLBACK TO control_document_PUB;
135: x_return_status := FND_API.g_ret_sts_unexp_error;
136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 135: x_return_status := FND_API.g_ret_sts_unexp_error;

131: ROLLBACK TO control_document_PUB;
132: x_return_status := FND_API.g_ret_sts_unexp_error;
133: WHEN OTHERS THEN
134: ROLLBACK TO control_document_PUB;
135: x_return_status := FND_API.g_ret_sts_unexp_error;
136: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
137: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
138: IF (g_fnd_debug = 'Y') THEN
139: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

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

159: * level if the final doc_id, line_id, and line_loc_id are not NULL. Executes
160: * at line level if only the final doc_id and line_id are not NULL. Executes
161: * at header level if only the final doc_id is not NULL. The document will be
162: * printed if it is a PO, PA, or RELEASE, and the p_print_flag is 'Y'. All
163: * changes will be committed upon success if p_commit is FND_API.G_TRUE.
164: * Appends to API message list on error, and leaves the document unchanged.
165: * Returns:
166: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
167: * FND_API.G_RET_STS_ERROR if control action fails

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

162: * printed if it is a PO, PA, or RELEASE, and the p_print_flag is 'Y'. All
163: * changes will be committed upon success if p_commit is FND_API.G_TRUE.
164: * Appends to API message list on error, and leaves the document unchanged.
165: * Returns:
166: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
167: * FND_API.G_RET_STS_ERROR if control action fails
168: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
169: */
170:

Line 167: * FND_API.G_RET_STS_ERROR if control action fails

163: * changes will be committed upon success if p_commit is FND_API.G_TRUE.
164: * Appends to API message list on error, and leaves the document unchanged.
165: * Returns:
166: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
167: * FND_API.G_RET_STS_ERROR if control action fails
168: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
169: */
170:
171: PROCEDURE control_document(

Line 168: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

164: * Appends to API message list on error, and leaves the document unchanged.
165: * Returns:
166: * x_return_status - FND_API.G_RET_STS_SUCCESS if control action succeeds
167: * FND_API.G_RET_STS_ERROR if control action fails
168: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
169: */
170:
171: PROCEDURE control_document(
172: p_api_version IN NUMBER,

Line 214: IF FND_API.to_boolean(p_init_msg_list) THEN

210: BEGIN
211:
212: -- Start standard API initialization
213: SAVEPOINT control_document_PUB;
214: IF FND_API.to_boolean(p_init_msg_list) THEN
215: FND_MSG_PUB.initialize;
216: END IF;
217:
218: IF NOT FND_API.compatible_api_call(

Line 218: IF NOT FND_API.compatible_api_call(

214: IF FND_API.to_boolean(p_init_msg_list) THEN
215: FND_MSG_PUB.initialize;
216: END IF;
217:
218: IF NOT FND_API.compatible_api_call(
219: l_api_version, p_api_version,
220: l_api_name, g_pkg_name)
221: THEN
222: RAISE FND_API.g_exc_unexpected_error;

Line 222: RAISE FND_API.g_exc_unexpected_error;

218: IF NOT FND_API.compatible_api_call(
219: l_api_version, p_api_version,
220: l_api_name, g_pkg_name)
221: THEN
222: RAISE FND_API.g_exc_unexpected_error;
223: END IF;
224:
225: x_return_status := FND_API.g_ret_sts_success;
226: -- End standard API initialization

Line 225: x_return_status := FND_API.g_ret_sts_success;

221: THEN
222: RAISE FND_API.g_exc_unexpected_error;
223: END IF;
224:
225: x_return_status := FND_API.g_ret_sts_success;
226: -- End standard API initialization
227:
228: IF (g_fnd_debug = 'Y') THEN
229: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 252: RAISE FND_API.g_exc_error;

248: END IF;
249: END IF;
250:
251: FND_MSG_PUB.add;
252: RAISE FND_API.g_exc_error;
253: END IF;
254:
255:
256: l_entity_dtl_rec_tbl := po_document_action_pvt.entity_dtl_rec_type_tbl();

Line 270: p_init_msg_list => FND_API.G_FALSE,

266: -- For the p_doc_line_loc_id/p_doc_shipment_num, it returns l_doc_line_loc_id i.e. corresponding LINE_LOCATION_ID
267:
268: PO_Document_Control_GRP.val_doc_params(
269: p_api_version => 1.0,
270: p_init_msg_list => FND_API.G_FALSE,
271: x_return_status => x_return_status,
272: p_doc_type => po_doc_tbl(i).p_doc_type,
273: p_doc_subtype => po_doc_tbl(i).p_doc_subtype,
274: p_doc_id => po_doc_tbl(i).p_doc_id,

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

283: x_doc_line_id => l_doc_line_id,
284: x_doc_line_loc_id => l_doc_line_loc_id);
285:
286:
287: IF (x_return_status = FND_API.g_ret_sts_error) THEN
288: RAISE FND_API.g_exc_error;
289: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
290: RAISE FND_API.g_exc_unexpected_error;
291: END IF;

Line 288: RAISE FND_API.g_exc_error;

284: x_doc_line_loc_id => l_doc_line_loc_id);
285:
286:
287: IF (x_return_status = FND_API.g_ret_sts_error) THEN
288: RAISE FND_API.g_exc_error;
289: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
290: RAISE FND_API.g_exc_unexpected_error;
291: END IF;
292:

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

285:
286:
287: IF (x_return_status = FND_API.g_ret_sts_error) THEN
288: RAISE FND_API.g_exc_error;
289: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
290: RAISE FND_API.g_exc_unexpected_error;
291: END IF;
292:
293: l_entity_dtl_rec_tbl.extend;

Line 290: RAISE FND_API.g_exc_unexpected_error;

286:
287: IF (x_return_status = FND_API.g_ret_sts_error) THEN
288: RAISE FND_API.g_exc_error;
289: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
290: RAISE FND_API.g_exc_unexpected_error;
291: END IF;
292:
293: l_entity_dtl_rec_tbl.extend;
294: l_entity_dtl_rec_tbl(i).doc_id := l_doc_id;

Line 366: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

362:
363:
364: -- If the procedure does not complete successfully raise the
365: -- appropriate exception
366: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
367: RAISE FND_API.g_exc_error;
368: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
369: RAISE FND_API.g_exc_unexpected_error;
370: END IF;

Line 367: RAISE FND_API.g_exc_error;

363:
364: -- If the procedure does not complete successfully raise the
365: -- appropriate exception
366: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
367: RAISE FND_API.g_exc_error;
368: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
369: RAISE FND_API.g_exc_unexpected_error;
370: END IF;
371:

Line 368: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

364: -- If the procedure does not complete successfully raise the
365: -- appropriate exception
366: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
367: RAISE FND_API.g_exc_error;
368: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
369: RAISE FND_API.g_exc_unexpected_error;
370: END IF;
371:
372:

Line 369: RAISE FND_API.g_exc_unexpected_error;

365: -- appropriate exception
366: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
367: RAISE FND_API.g_exc_error;
368: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
369: RAISE FND_API.g_exc_unexpected_error;
370: END IF;
371:
372:
373:

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

394: p_source => PO_DOCUMENT_CANCEL_PVT.c_CANCEL_API,
395: x_exception_msg => l_exc_msg,
396: x_return_status => x_return_status);
397:
398: IF (x_return_status = FND_API.g_ret_sts_error) THEN
399: RAISE FND_API.g_exc_error;
400: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
401: RAISE FND_API.g_exc_unexpected_error;
402: END IF;

Line 399: RAISE FND_API.g_exc_error;

395: x_exception_msg => l_exc_msg,
396: x_return_status => x_return_status);
397:
398: IF (x_return_status = FND_API.g_ret_sts_error) THEN
399: RAISE FND_API.g_exc_error;
400: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
401: RAISE FND_API.g_exc_unexpected_error;
402: END IF;
403:

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

396: x_return_status => x_return_status);
397:
398: IF (x_return_status = FND_API.g_ret_sts_error) THEN
399: RAISE FND_API.g_exc_error;
400: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
401: RAISE FND_API.g_exc_unexpected_error;
402: END IF;
403:
404: END IF;

Line 401: RAISE FND_API.g_exc_unexpected_error;

397:
398: IF (x_return_status = FND_API.g_ret_sts_error) THEN
399: RAISE FND_API.g_exc_error;
400: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
401: RAISE FND_API.g_exc_unexpected_error;
402: END IF;
403:
404: END IF;
405:

Line 418: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

414: x_return_status => x_return_status );
415:
416: -- If the procedure does not complete successfully raise the
417: -- appropriate exception
418: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
419: RAISE FND_API.g_exc_error;
420: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;

Line 419: RAISE FND_API.g_exc_error;

415:
416: -- If the procedure does not complete successfully raise the
417: -- appropriate exception
418: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
419: RAISE FND_API.g_exc_error;
420: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;
423:

Line 420: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

416: -- If the procedure does not complete successfully raise the
417: -- appropriate exception
418: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
419: RAISE FND_API.g_exc_error;
420: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;
423:
424: l_doc_id_tbl.extend;

Line 421: RAISE FND_API.g_exc_unexpected_error;

417: -- appropriate exception
418: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
419: RAISE FND_API.g_exc_error;
420: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE FND_API.g_exc_unexpected_error;
422: END IF;
423:
424: l_doc_id_tbl.extend;
425: id_count:=id_count+1;

Line 436: p_init_msg_list => FND_API.G_FALSE,

432: --Add all the messages to the message list
433: IF l_return_code ='F' AND l_online_report_id IS NOT NULL THEN
434: PO_Document_Control_PVT.add_online_report_msgs(
435: p_api_version => 1.0,
436: p_init_msg_list => FND_API.G_FALSE,
437: x_return_status => x_return_status,
438: p_online_report_id => l_online_report_id);
439:
440: RAISE FND_API.g_exc_error;

Line 440: RAISE FND_API.g_exc_error;

436: p_init_msg_list => FND_API.G_FALSE,
437: x_return_status => x_return_status,
438: p_online_report_id => l_online_report_id);
439:
440: RAISE FND_API.g_exc_error;
441: END IF;
442:
443:
444:

Line 446: IF FND_API.to_boolean(p_commit) THEN

442:
443:
444:
445: -- Standard API check of p_commit
446: IF FND_API.to_boolean(p_commit) THEN
447: COMMIT WORK;
448: END IF;
449: EXCEPTION
450: WHEN FND_API.g_exc_error THEN

Line 450: WHEN FND_API.g_exc_error THEN

446: IF FND_API.to_boolean(p_commit) THEN
447: COMMIT WORK;
448: END IF;
449: EXCEPTION
450: WHEN FND_API.g_exc_error THEN
451: ROLLBACK TO control_document_PUB;
452: x_return_status := FND_API.g_ret_sts_error;
453: WHEN FND_API.g_exc_unexpected_error THEN
454: ROLLBACK TO control_document_PUB;

Line 452: x_return_status := FND_API.g_ret_sts_error;

448: END IF;
449: EXCEPTION
450: WHEN FND_API.g_exc_error THEN
451: ROLLBACK TO control_document_PUB;
452: x_return_status := FND_API.g_ret_sts_error;
453: WHEN FND_API.g_exc_unexpected_error THEN
454: ROLLBACK TO control_document_PUB;
455: x_return_status := FND_API.g_ret_sts_unexp_error;
456: WHEN OTHERS THEN

Line 453: WHEN FND_API.g_exc_unexpected_error THEN

449: EXCEPTION
450: WHEN FND_API.g_exc_error THEN
451: ROLLBACK TO control_document_PUB;
452: x_return_status := FND_API.g_ret_sts_error;
453: WHEN FND_API.g_exc_unexpected_error THEN
454: ROLLBACK TO control_document_PUB;
455: x_return_status := FND_API.g_ret_sts_unexp_error;
456: WHEN OTHERS THEN
457: ROLLBACK TO control_document_PUB;

Line 455: x_return_status := FND_API.g_ret_sts_unexp_error;

451: ROLLBACK TO control_document_PUB;
452: x_return_status := FND_API.g_ret_sts_error;
453: WHEN FND_API.g_exc_unexpected_error THEN
454: ROLLBACK TO control_document_PUB;
455: x_return_status := FND_API.g_ret_sts_unexp_error;
456: WHEN OTHERS THEN
457: ROLLBACK TO control_document_PUB;
458: x_return_status := FND_API.g_ret_sts_unexp_error;
459: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 458: x_return_status := FND_API.g_ret_sts_unexp_error;

454: ROLLBACK TO control_document_PUB;
455: x_return_status := FND_API.g_ret_sts_unexp_error;
456: WHEN OTHERS THEN
457: ROLLBACK TO control_document_PUB;
458: x_return_status := FND_API.g_ret_sts_unexp_error;
459: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
460: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
461: IF (g_fnd_debug = 'Y') THEN
462: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN