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 85: IF FND_API.to_boolean(p_init_msg_list) THEN

81:
82: BEGIN
83: -- Start standard API initialization
84: SAVEPOINT control_document_GRP;
85: IF FND_API.to_boolean(p_init_msg_list) THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
89: l_api_name, g_pkg_name)

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

84: SAVEPOINT control_document_GRP;
85: IF FND_API.to_boolean(p_init_msg_list) THEN
86: FND_MSG_PUB.initialize;
87: END IF;
88: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
89: l_api_name, g_pkg_name)
90: THEN
91: RAISE FND_API.g_exc_unexpected_error;
92: END IF;

Line 91: RAISE FND_API.g_exc_unexpected_error;

87: END IF;
88: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
89: l_api_name, g_pkg_name)
90: THEN
91: RAISE FND_API.g_exc_unexpected_error;
92: END IF;
93: x_return_status := FND_API.g_ret_sts_success;
94: -- End standard API initialization
95:

Line 93: x_return_status := FND_API.g_ret_sts_success;

89: l_api_name, g_pkg_name)
90: THEN
91: RAISE FND_API.g_exc_unexpected_error;
92: END IF;
93: x_return_status := FND_API.g_ret_sts_success;
94: -- End standard API initialization
95:
96: IF (g_fnd_debug = 'Y') THEN
97: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 117: RAISE FND_API.g_exc_error;

113: '.invalid_action', FALSE);
114: END IF;
115: END IF;
116: FND_MSG_PUB.add;
117: RAISE FND_API.g_exc_error;
118: END IF;
119:
120: val_doc_params(p_api_version => 1.0,
121: p_init_msg_list => FND_API.G_FALSE,

Line 121: p_init_msg_list => FND_API.G_FALSE,

117: RAISE FND_API.g_exc_error;
118: END IF;
119:
120: val_doc_params(p_api_version => 1.0,
121: p_init_msg_list => FND_API.G_FALSE,
122: x_return_status => x_return_status,
123: p_doc_type => p_doc_type,
124: p_doc_subtype => p_doc_subtype,
125: p_doc_id => p_doc_id,

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

132: p_doc_shipment_num => p_doc_shipment_num,
133: x_doc_id => l_doc_id,
134: x_doc_line_id => l_doc_line_id,
135: x_doc_line_loc_id => l_doc_line_loc_id);
136: IF (x_return_status = FND_API.g_ret_sts_error) THEN
137: RAISE FND_API.g_exc_error;
138: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;

Line 137: RAISE FND_API.g_exc_error;

133: x_doc_id => l_doc_id,
134: x_doc_line_id => l_doc_line_id,
135: x_doc_line_loc_id => l_doc_line_loc_id);
136: IF (x_return_status = FND_API.g_ret_sts_error) THEN
137: RAISE FND_API.g_exc_error;
138: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;
141:

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

134: x_doc_line_id => l_doc_line_id,
135: x_doc_line_loc_id => l_doc_line_loc_id);
136: IF (x_return_status = FND_API.g_ret_sts_error) THEN
137: RAISE FND_API.g_exc_error;
138: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;
141:
142: --16035142 start

Line 139: RAISE FND_API.g_exc_unexpected_error;

135: x_doc_line_loc_id => l_doc_line_loc_id);
136: IF (x_return_status = FND_API.g_ret_sts_error) THEN
137: RAISE FND_API.g_exc_error;
138: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;
141:
142: --16035142 start
143: /* Get supplier's default transmission settings */

Line 148: p_init_msg_list => FND_API.G_FALSE,

144:
145: IF p_launch_approvals_flag = 'Y' THEN
146: PO_VENDOR_SITES_GRP.Get_Transmission_Defaults(
147: p_api_version => 1.0,
148: p_init_msg_list => FND_API.G_FALSE,
149: p_document_id => l_doc_id,
150: p_document_type => p_doc_type,
151: p_document_subtype => p_doc_subtype,
152: p_preparer_id => x_preparer_id,

Line 190: p_init_msg_list => FND_API.G_FALSE,

186: p_online_report_id, Modifying below call accordingly */
187:
188: PO_Document_Control_PVT.control_document
189: (p_api_version => 1.0,
190: p_init_msg_list => FND_API.G_FALSE,
191: p_commit => FND_API.G_FALSE,
192: x_return_status => x_return_status,
193: p_doc_type => p_doc_type,
194: p_doc_subtype => p_doc_subtype,

Line 191: p_commit => FND_API.G_FALSE,

187:
188: PO_Document_Control_PVT.control_document
189: (p_api_version => 1.0,
190: p_init_msg_list => FND_API.G_FALSE,
191: p_commit => FND_API.G_FALSE,
192: x_return_status => x_return_status,
193: p_doc_type => p_doc_type,
194: p_doc_subtype => p_doc_subtype,
195: p_doc_id => l_doc_id,

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

209: p_online_report_id => x_online_report_id,
210: p_caller => p_caller --Bug9321845(6603493)
211: );
212:
213: IF (x_return_status = FND_API.g_ret_sts_error) THEN
214: RAISE FND_API.g_exc_error;
215: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
216: RAISE FND_API.g_exc_unexpected_error;
217: END IF;

Line 214: RAISE FND_API.g_exc_error;

210: p_caller => p_caller --Bug9321845(6603493)
211: );
212:
213: IF (x_return_status = FND_API.g_ret_sts_error) THEN
214: RAISE FND_API.g_exc_error;
215: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
216: RAISE FND_API.g_exc_unexpected_error;
217: END IF;
218:

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

211: );
212:
213: IF (x_return_status = FND_API.g_ret_sts_error) THEN
214: RAISE FND_API.g_exc_error;
215: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
216: RAISE FND_API.g_exc_unexpected_error;
217: END IF;
218:
219:

Line 216: RAISE FND_API.g_exc_unexpected_error;

212:
213: IF (x_return_status = FND_API.g_ret_sts_error) THEN
214: RAISE FND_API.g_exc_error;
215: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
216: RAISE FND_API.g_exc_unexpected_error;
217: END IF;
218:
219:
220: -- Standard API check of p_commit

Line 221: IF FND_API.to_boolean(p_commit) THEN

217: END IF;
218:
219:
220: -- Standard API check of p_commit
221: IF FND_API.to_boolean(p_commit) THEN
222: COMMIT WORK;
223: END IF;
224: EXCEPTION
225: WHEN FND_API.g_exc_error THEN

Line 225: WHEN FND_API.g_exc_error THEN

221: IF FND_API.to_boolean(p_commit) THEN
222: COMMIT WORK;
223: END IF;
224: EXCEPTION
225: WHEN FND_API.g_exc_error THEN
226: ROLLBACK TO control_document_GRP;
227: x_return_status := FND_API.g_ret_sts_error;
228: WHEN FND_API.g_exc_unexpected_error THEN
229: ROLLBACK TO control_document_GRP;

Line 227: x_return_status := FND_API.g_ret_sts_error;

223: END IF;
224: EXCEPTION
225: WHEN FND_API.g_exc_error THEN
226: ROLLBACK TO control_document_GRP;
227: x_return_status := FND_API.g_ret_sts_error;
228: WHEN FND_API.g_exc_unexpected_error THEN
229: ROLLBACK TO control_document_GRP;
230: x_return_status := FND_API.g_ret_sts_unexp_error;
231: WHEN OTHERS THEN

Line 228: WHEN FND_API.g_exc_unexpected_error THEN

224: EXCEPTION
225: WHEN FND_API.g_exc_error THEN
226: ROLLBACK TO control_document_GRP;
227: x_return_status := FND_API.g_ret_sts_error;
228: WHEN FND_API.g_exc_unexpected_error THEN
229: ROLLBACK TO control_document_GRP;
230: x_return_status := FND_API.g_ret_sts_unexp_error;
231: WHEN OTHERS THEN
232: ROLLBACK TO control_document_GRP;

Line 230: x_return_status := FND_API.g_ret_sts_unexp_error;

226: ROLLBACK TO control_document_GRP;
227: x_return_status := FND_API.g_ret_sts_error;
228: WHEN FND_API.g_exc_unexpected_error THEN
229: ROLLBACK TO control_document_GRP;
230: x_return_status := FND_API.g_ret_sts_unexp_error;
231: WHEN OTHERS THEN
232: ROLLBACK TO control_document_GRP;
233: x_return_status := FND_API.g_ret_sts_unexp_error;
234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 233: x_return_status := FND_API.g_ret_sts_unexp_error;

229: ROLLBACK TO control_document_GRP;
230: x_return_status := FND_API.g_ret_sts_unexp_error;
231: WHEN OTHERS THEN
232: ROLLBACK TO control_document_GRP;
233: x_return_status := FND_API.g_ret_sts_unexp_error;
234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
235: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
236: IF (g_fnd_debug = 'Y') THEN
237: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

Line 307: IF FND_API.to_boolean(p_init_msg_list) THEN

303: BEGIN
304:
305: -- Start standard API initialization
306: SAVEPOINT control_document_GRP;
307: IF FND_API.to_boolean(p_init_msg_list) THEN
308: FND_MSG_PUB.initialize;
309: END IF;
310: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
311: l_api_name, g_pkg_name)

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

306: SAVEPOINT control_document_GRP;
307: IF FND_API.to_boolean(p_init_msg_list) THEN
308: FND_MSG_PUB.initialize;
309: END IF;
310: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
311: l_api_name, g_pkg_name)
312: THEN
313: RAISE FND_API.g_exc_unexpected_error;
314: END IF;

Line 313: RAISE FND_API.g_exc_unexpected_error;

309: END IF;
310: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
311: l_api_name, g_pkg_name)
312: THEN
313: RAISE FND_API.g_exc_unexpected_error;
314: END IF;
315: x_return_status := FND_API.g_ret_sts_success;
316: -- End standard API initialization
317:

Line 315: x_return_status := FND_API.g_ret_sts_success;

311: l_api_name, g_pkg_name)
312: THEN
313: RAISE FND_API.g_exc_unexpected_error;
314: END IF;
315: x_return_status := FND_API.g_ret_sts_success;
316: -- End standard API initialization
317:
318: IF (g_fnd_debug = 'Y') THEN
319: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 341: RAISE FND_API.g_exc_error;

337: '.invalid_action', FALSE);
338: END IF;
339: END IF;
340: FND_MSG_PUB.add;
341: RAISE FND_API.g_exc_error;
342: END IF;
343:
344: l_entity_dtl_rec_tbl := po_document_action_pvt.entity_dtl_rec_type_tbl();
345:

Line 358: p_init_msg_list => FND_API.G_FALSE,

354: -- For the p_doc_line_loc_id/p_doc_shipment_num, it returns l_doc_line_loc_id i.e. corresponding LINE_LOCATION_ID
355:
356: val_doc_params(
357: p_api_version => 1.0,
358: p_init_msg_list => FND_API.G_FALSE,
359: x_return_status => x_return_status,
360: p_doc_type => p_doc_type,
361: p_doc_subtype => p_doc_subtype,
362: p_doc_id => p_doc_id,

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

371: x_doc_line_id => l_doc_line_id,
372: x_doc_line_loc_id => l_doc_line_loc_id);
373:
374:
375: IF (x_return_status = FND_API.g_ret_sts_error) THEN
376: RAISE FND_API.g_exc_error;
377: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
378: RAISE FND_API.g_exc_unexpected_error;
379: END IF;

Line 376: RAISE FND_API.g_exc_error;

372: x_doc_line_loc_id => l_doc_line_loc_id);
373:
374:
375: IF (x_return_status = FND_API.g_ret_sts_error) THEN
376: RAISE FND_API.g_exc_error;
377: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
378: RAISE FND_API.g_exc_unexpected_error;
379: END IF;
380:

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

373:
374:
375: IF (x_return_status = FND_API.g_ret_sts_error) THEN
376: RAISE FND_API.g_exc_error;
377: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
378: RAISE FND_API.g_exc_unexpected_error;
379: END IF;
380:
381: -- Constructing the table of records

Line 378: RAISE FND_API.g_exc_unexpected_error;

374:
375: IF (x_return_status = FND_API.g_ret_sts_error) THEN
376: RAISE FND_API.g_exc_error;
377: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
378: RAISE FND_API.g_exc_unexpected_error;
379: END IF;
380:
381: -- Constructing the table of records
382: l_entity_dtl_rec_tbl.extend;

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

451:
452:
453: -- If the procedure does not complete successfully raise the
454: -- appropriate exception
455: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
456: RAISE FND_API.g_exc_error;
457: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
458: RAISE FND_API.g_exc_unexpected_error;
459: END IF;

Line 456: RAISE FND_API.g_exc_error;

452:
453: -- If the procedure does not complete successfully raise the
454: -- appropriate exception
455: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
456: RAISE FND_API.g_exc_error;
457: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
458: RAISE FND_API.g_exc_unexpected_error;
459: END IF;
460:

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

453: -- If the procedure does not complete successfully raise the
454: -- appropriate exception
455: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
456: RAISE FND_API.g_exc_error;
457: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
458: RAISE FND_API.g_exc_unexpected_error;
459: END IF;
460:
461:

Line 458: RAISE FND_API.g_exc_unexpected_error;

454: -- appropriate exception
455: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
456: RAISE FND_API.g_exc_error;
457: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
458: RAISE FND_API.g_exc_unexpected_error;
459: END IF;
460:
461:
462: --Add all the messages to the message list

Line 466: p_init_msg_list => FND_API.G_FALSE,

462: --Add all the messages to the message list
463: IF l_return_code ='F' AND l_online_report_id IS NOT NULL THEN
464: PO_Document_Control_PVT.add_online_report_msgs(
465: p_api_version => 1.0,
466: p_init_msg_list => FND_API.G_FALSE,
467: x_return_status => x_return_status,
468: p_online_report_id => l_online_report_id);
469:
470: RAISE FND_API.g_exc_error;

Line 470: RAISE FND_API.g_exc_error;

466: p_init_msg_list => FND_API.G_FALSE,
467: x_return_status => x_return_status,
468: p_online_report_id => l_online_report_id);
469:
470: RAISE FND_API.g_exc_error;
471: END IF;
472:
473: IF p_print_flag ='Y' THEN
474: l_communication_method_option := 'PRINT';

Line 482: p_init_msg_list => FND_API.G_FALSE,

478: --16035142 start
479: /* Get supplier's default transmission settings */
480: PO_VENDOR_SITES_GRP.Get_Transmission_Defaults(
481: p_api_version => 1.0,
482: p_init_msg_list => FND_API.G_FALSE,
483: p_document_id => l_doc_id,
484: p_document_type => p_doc_type,
485: p_document_subtype => p_doc_subtype,
486: p_preparer_id => x_preparer_id,

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

531: x_exception_msg => l_exc_msg,
532: x_return_status => x_return_status
533: );
534:
535: IF (x_return_status = FND_API.g_ret_sts_error) THEN
536: RAISE FND_API.g_exc_error;
537: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
538: RAISE FND_API.g_exc_unexpected_error;
539: END IF;

Line 536: RAISE FND_API.g_exc_error;

532: x_return_status => x_return_status
533: );
534:
535: IF (x_return_status = FND_API.g_ret_sts_error) THEN
536: RAISE FND_API.g_exc_error;
537: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
538: RAISE FND_API.g_exc_unexpected_error;
539: END IF;
540:

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

533: );
534:
535: IF (x_return_status = FND_API.g_ret_sts_error) THEN
536: RAISE FND_API.g_exc_error;
537: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
538: RAISE FND_API.g_exc_unexpected_error;
539: END IF;
540:
541: END IF;

Line 538: RAISE FND_API.g_exc_unexpected_error;

534:
535: IF (x_return_status = FND_API.g_ret_sts_error) THEN
536: RAISE FND_API.g_exc_error;
537: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
538: RAISE FND_API.g_exc_unexpected_error;
539: END IF;
540:
541: END IF;
542:

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

551: x_return_status => x_return_status);
552:
553: -- If the procedure does not complete successfully raise the
554: -- appropriate exception
555: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
556: RAISE FND_API.g_exc_error;
557: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
558: RAISE FND_API.g_exc_unexpected_error;
559: END IF;

Line 556: RAISE FND_API.g_exc_error;

552:
553: -- If the procedure does not complete successfully raise the
554: -- appropriate exception
555: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
556: RAISE FND_API.g_exc_error;
557: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
558: RAISE FND_API.g_exc_unexpected_error;
559: END IF;
560:

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

553: -- If the procedure does not complete successfully raise the
554: -- appropriate exception
555: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
556: RAISE FND_API.g_exc_error;
557: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
558: RAISE FND_API.g_exc_unexpected_error;
559: END IF;
560:
561:

Line 558: RAISE FND_API.g_exc_unexpected_error;

554: -- appropriate exception
555: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
556: RAISE FND_API.g_exc_error;
557: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
558: RAISE FND_API.g_exc_unexpected_error;
559: END IF;
560:
561:
562: EXCEPTION

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

582: * not NULL. Control actions supported for p_action are: 'CANCEL'.
583: * Requisitions are currently not supported. Appends to API message list on
584: * error.
585: * Returns:
586: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
587: * FND_API.G_RET_STS_ERROR if validation fails
588: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
589: */
590: PROCEDURE validate_control_action

Line 587: * FND_API.G_RET_STS_ERROR if validation fails

583: * Requisitions are currently not supported. Appends to API message list on
584: * error.
585: * Returns:
586: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
587: * FND_API.G_RET_STS_ERROR if validation fails
588: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
589: */
590: PROCEDURE validate_control_action
591: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

Line 588: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

584: * error.
585: * Returns:
586: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
587: * FND_API.G_RET_STS_ERROR if validation fails
588: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
589: */
590: PROCEDURE validate_control_action
591: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
592: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

Line 613: x_return_status := FND_API.g_ret_sts_success;

609: l_doc_line_id NUMBER;
610: l_doc_line_loc_id NUMBER;
611:
612: BEGIN
613: x_return_status := FND_API.g_ret_sts_success;
614:
615: IF (g_fnd_debug = 'Y') THEN
616: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
617: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

Line 635: RAISE FND_API.g_exc_error;

631: '.invalid_action', FALSE);
632: END IF;
633: END IF;
634: FND_MSG_PUB.add;
635: RAISE FND_API.g_exc_error;
636: END IF;
637:
638: val_doc_params(p_api_version => 1.0,
639: p_init_msg_list => FND_API.G_FALSE,

Line 639: p_init_msg_list => FND_API.G_FALSE,

635: RAISE FND_API.g_exc_error;
636: END IF;
637:
638: val_doc_params(p_api_version => 1.0,
639: p_init_msg_list => FND_API.G_FALSE,
640: x_return_status => x_return_status,
641: p_doc_type => p_doc_type,
642: p_doc_subtype => p_doc_subtype,
643: p_doc_id => p_doc_id,

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

650: p_doc_shipment_num => p_doc_shipment_num,
651: x_doc_id => l_doc_id,
652: x_doc_line_id => l_doc_line_id,
653: x_doc_line_loc_id => l_doc_line_loc_id);
654: IF (x_return_status = FND_API.g_ret_sts_error) THEN
655: RAISE FND_API.g_exc_error;
656: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
657: RAISE FND_API.g_exc_unexpected_error;
658: END IF;

Line 655: RAISE FND_API.g_exc_error;

651: x_doc_id => l_doc_id,
652: x_doc_line_id => l_doc_line_id,
653: x_doc_line_loc_id => l_doc_line_loc_id);
654: IF (x_return_status = FND_API.g_ret_sts_error) THEN
655: RAISE FND_API.g_exc_error;
656: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
657: RAISE FND_API.g_exc_unexpected_error;
658: END IF;
659:

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

652: x_doc_line_id => l_doc_line_id,
653: x_doc_line_loc_id => l_doc_line_loc_id);
654: IF (x_return_status = FND_API.g_ret_sts_error) THEN
655: RAISE FND_API.g_exc_error;
656: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
657: RAISE FND_API.g_exc_unexpected_error;
658: END IF;
659:
660: -- Call private level validation. If the agent ID is not NULL, then user

Line 657: RAISE FND_API.g_exc_unexpected_error;

653: x_doc_line_loc_id => l_doc_line_loc_id);
654: IF (x_return_status = FND_API.g_ret_sts_error) THEN
655: RAISE FND_API.g_exc_error;
656: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
657: RAISE FND_API.g_exc_unexpected_error;
658: END IF;
659:
660: -- Call private level validation. If the agent ID is not NULL, then user
661: -- authority and document access levels will be validated as well.

Line 664: p_init_msg_list => FND_API.G_FALSE,

660: -- Call private level validation. If the agent ID is not NULL, then user
661: -- authority and document access levels will be validated as well.
662: PO_Document_Control_PVT.val_control_action
663: (p_api_version => 1.0,
664: p_init_msg_list => FND_API.G_FALSE,
665: x_return_status => x_return_status,
666: p_doc_type => p_doc_type,
667: p_doc_subtype => p_doc_subtype,
668: p_doc_id => l_doc_id,

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

671: p_action => p_action,
672: p_agent_id => p_agent_id,
673: x_control_level => l_control_level);
674:
675: IF (x_return_status = FND_API.g_ret_sts_error) THEN
676: RAISE FND_API.g_exc_error;
677: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
678: RAISE FND_API.g_exc_unexpected_error;
679: END IF;

Line 676: RAISE FND_API.g_exc_error;

672: p_agent_id => p_agent_id,
673: x_control_level => l_control_level);
674:
675: IF (x_return_status = FND_API.g_ret_sts_error) THEN
676: RAISE FND_API.g_exc_error;
677: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
678: RAISE FND_API.g_exc_unexpected_error;
679: END IF;
680:

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

673: x_control_level => l_control_level);
674:
675: IF (x_return_status = FND_API.g_ret_sts_error) THEN
676: RAISE FND_API.g_exc_error;
677: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
678: RAISE FND_API.g_exc_unexpected_error;
679: END IF;
680:
681: EXCEPTION

Line 678: RAISE FND_API.g_exc_unexpected_error;

674:
675: IF (x_return_status = FND_API.g_ret_sts_error) THEN
676: RAISE FND_API.g_exc_error;
677: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
678: RAISE FND_API.g_exc_unexpected_error;
679: END IF;
680:
681: EXCEPTION
682: WHEN FND_API.g_exc_error THEN

Line 682: WHEN FND_API.g_exc_error THEN

678: RAISE FND_API.g_exc_unexpected_error;
679: END IF;
680:
681: EXCEPTION
682: WHEN FND_API.g_exc_error THEN
683: x_return_status := FND_API.g_ret_sts_error;
684: WHEN FND_API.g_exc_unexpected_error THEN
685: x_return_status := FND_API.g_ret_sts_unexp_error;
686: WHEN OTHERS THEN

Line 683: x_return_status := FND_API.g_ret_sts_error;

679: END IF;
680:
681: EXCEPTION
682: WHEN FND_API.g_exc_error THEN
683: x_return_status := FND_API.g_ret_sts_error;
684: WHEN FND_API.g_exc_unexpected_error THEN
685: x_return_status := FND_API.g_ret_sts_unexp_error;
686: WHEN OTHERS THEN
687: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 684: WHEN FND_API.g_exc_unexpected_error THEN

680:
681: EXCEPTION
682: WHEN FND_API.g_exc_error THEN
683: x_return_status := FND_API.g_ret_sts_error;
684: WHEN FND_API.g_exc_unexpected_error THEN
685: x_return_status := FND_API.g_ret_sts_unexp_error;
686: WHEN OTHERS THEN
687: x_return_status := FND_API.g_ret_sts_unexp_error;
688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 685: x_return_status := FND_API.g_ret_sts_unexp_error;

681: EXCEPTION
682: WHEN FND_API.g_exc_error THEN
683: x_return_status := FND_API.g_ret_sts_error;
684: WHEN FND_API.g_exc_unexpected_error THEN
685: x_return_status := FND_API.g_ret_sts_unexp_error;
686: WHEN OTHERS THEN
687: x_return_status := FND_API.g_ret_sts_unexp_error;
688: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
689: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 687: x_return_status := FND_API.g_ret_sts_unexp_error;

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

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

710: * not NULL. Control actions supported for p_action are: 'CANCEL'.
711: * Requisitions are currently not supported. Appends to API message list on
712: * error.
713: * Returns:
714: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
715: * FND_API.G_RET_STS_ERROR if validation fails
716: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
717: */
718: PROCEDURE val_control_action

Line 715: * FND_API.G_RET_STS_ERROR if validation fails

711: * Requisitions are currently not supported. Appends to API message list on
712: * error.
713: * Returns:
714: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
715: * FND_API.G_RET_STS_ERROR if validation fails
716: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
717: */
718: PROCEDURE val_control_action
719: (p_api_version IN NUMBER,

Line 716: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

712: * error.
713: * Returns:
714: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
715: * FND_API.G_RET_STS_ERROR if validation fails
716: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
717: */
718: PROCEDURE val_control_action
719: (p_api_version IN NUMBER,
720: p_init_msg_list IN VARCHAR2,

Line 743: IF FND_API.to_boolean(p_init_msg_list) THEN

739: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;
740:
741: BEGIN
742: -- Start standard API initialization
743: IF FND_API.to_boolean(p_init_msg_list) THEN
744: FND_MSG_PUB.initialize;
745: END IF;
746: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
747: l_api_name, g_pkg_name)

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

742: -- Start standard API initialization
743: IF FND_API.to_boolean(p_init_msg_list) THEN
744: FND_MSG_PUB.initialize;
745: END IF;
746: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
747: l_api_name, g_pkg_name)
748: THEN
749: RAISE FND_API.g_exc_unexpected_error;
750: END IF;

Line 749: RAISE FND_API.g_exc_unexpected_error;

745: END IF;
746: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
747: l_api_name, g_pkg_name)
748: THEN
749: RAISE FND_API.g_exc_unexpected_error;
750: END IF;
751: x_return_status := FND_API.g_ret_sts_success;
752: -- End standard API initialization
753:

Line 751: x_return_status := FND_API.g_ret_sts_success;

747: l_api_name, g_pkg_name)
748: THEN
749: RAISE FND_API.g_exc_unexpected_error;
750: END IF;
751: x_return_status := FND_API.g_ret_sts_success;
752: -- End standard API initialization
753:
754: -- Ensure that we are not using a NULL agent ID.
755: IF (l_agent_id IS NULL) THEN

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

780: p_doc_shipment_num => p_doc_shipment_num,
781: p_action => p_action,
782: p_agent_id => l_agent_id,
783: x_return_status => x_return_status);
784: IF (x_return_status = FND_API.g_ret_sts_error) THEN
785: RAISE FND_API.g_exc_error;
786: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
787: RAISE FND_API.g_exc_unexpected_error;
788: END IF;

Line 785: RAISE FND_API.g_exc_error;

781: p_action => p_action,
782: p_agent_id => l_agent_id,
783: x_return_status => x_return_status);
784: IF (x_return_status = FND_API.g_ret_sts_error) THEN
785: RAISE FND_API.g_exc_error;
786: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
787: RAISE FND_API.g_exc_unexpected_error;
788: END IF;
789:

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

782: p_agent_id => l_agent_id,
783: x_return_status => x_return_status);
784: IF (x_return_status = FND_API.g_ret_sts_error) THEN
785: RAISE FND_API.g_exc_error;
786: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
787: RAISE FND_API.g_exc_unexpected_error;
788: END IF;
789:
790: EXCEPTION

Line 787: RAISE FND_API.g_exc_unexpected_error;

783: x_return_status => x_return_status);
784: IF (x_return_status = FND_API.g_ret_sts_error) THEN
785: RAISE FND_API.g_exc_error;
786: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
787: RAISE FND_API.g_exc_unexpected_error;
788: END IF;
789:
790: EXCEPTION
791: WHEN FND_API.g_exc_error THEN

Line 791: WHEN FND_API.g_exc_error THEN

787: RAISE FND_API.g_exc_unexpected_error;
788: END IF;
789:
790: EXCEPTION
791: WHEN FND_API.g_exc_error THEN
792: x_return_status := FND_API.g_ret_sts_error;
793: WHEN FND_API.g_exc_unexpected_error THEN
794: x_return_status := FND_API.g_ret_sts_unexp_error;
795: WHEN OTHERS THEN

Line 792: x_return_status := FND_API.g_ret_sts_error;

788: END IF;
789:
790: EXCEPTION
791: WHEN FND_API.g_exc_error THEN
792: x_return_status := FND_API.g_ret_sts_error;
793: WHEN FND_API.g_exc_unexpected_error THEN
794: x_return_status := FND_API.g_ret_sts_unexp_error;
795: WHEN OTHERS THEN
796: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 793: WHEN FND_API.g_exc_unexpected_error THEN

789:
790: EXCEPTION
791: WHEN FND_API.g_exc_error THEN
792: x_return_status := FND_API.g_ret_sts_error;
793: WHEN FND_API.g_exc_unexpected_error THEN
794: x_return_status := FND_API.g_ret_sts_unexp_error;
795: WHEN OTHERS THEN
796: x_return_status := FND_API.g_ret_sts_unexp_error;
797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 794: x_return_status := FND_API.g_ret_sts_unexp_error;

790: EXCEPTION
791: WHEN FND_API.g_exc_error THEN
792: x_return_status := FND_API.g_ret_sts_error;
793: WHEN FND_API.g_exc_unexpected_error THEN
794: x_return_status := FND_API.g_ret_sts_unexp_error;
795: WHEN OTHERS THEN
796: x_return_status := FND_API.g_ret_sts_unexp_error;
797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
798: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 796: x_return_status := FND_API.g_ret_sts_unexp_error;

792: x_return_status := FND_API.g_ret_sts_error;
793: WHEN FND_API.g_exc_unexpected_error THEN
794: x_return_status := FND_API.g_ret_sts_unexp_error;
795: WHEN OTHERS THEN
796: x_return_status := FND_API.g_ret_sts_unexp_error;
797: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
798: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
799: IF (g_fnd_debug = 'Y') THEN
800: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

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

819: * at header level if the final doc_id is not NULL. Control actions supported
820: * for p_action are: 'CANCEL'. Requisitions are currently not supported.
821: * Appends to API message list on error.
822: * Returns:
823: * x_return_status - FND_API.G_RET_STS_SUCCESS if check succeeds
824: * FND_API.G_RET_STS_ERROR if check fails
825: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
826: */
827: PROCEDURE check_control_action

Line 824: * FND_API.G_RET_STS_ERROR if check fails

820: * for p_action are: 'CANCEL'. Requisitions are currently not supported.
821: * Appends to API message list on error.
822: * Returns:
823: * x_return_status - FND_API.G_RET_STS_SUCCESS if check succeeds
824: * FND_API.G_RET_STS_ERROR if check fails
825: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
826: */
827: PROCEDURE check_control_action
828: (p_api_version IN NUMBER,

Line 825: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

821: * Appends to API message list on error.
822: * Returns:
823: * x_return_status - FND_API.G_RET_STS_SUCCESS if check succeeds
824: * FND_API.G_RET_STS_ERROR if check fails
825: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
826: */
827: PROCEDURE check_control_action
828: (p_api_version IN NUMBER,
829: p_init_msg_list IN VARCHAR2,

Line 849: IF FND_API.to_boolean(p_init_msg_list) THEN

845: l_api_version CONSTANT NUMBER := 1.0;
846:
847: BEGIN
848: -- Start standard API initialization
849: IF FND_API.to_boolean(p_init_msg_list) THEN
850: FND_MSG_PUB.initialize;
851: END IF;
852: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
853: l_api_name, g_pkg_name)

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

848: -- Start standard API initialization
849: IF FND_API.to_boolean(p_init_msg_list) THEN
850: FND_MSG_PUB.initialize;
851: END IF;
852: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
853: l_api_name, g_pkg_name)
854: THEN
855: RAISE FND_API.g_exc_unexpected_error;
856: END IF;

Line 855: RAISE FND_API.g_exc_unexpected_error;

851: END IF;
852: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
853: l_api_name, g_pkg_name)
854: THEN
855: RAISE FND_API.g_exc_unexpected_error;
856: END IF;
857: x_return_status := FND_API.g_ret_sts_success;
858: -- End standard API initialization
859:

Line 857: x_return_status := FND_API.g_ret_sts_success;

853: l_api_name, g_pkg_name)
854: THEN
855: RAISE FND_API.g_exc_unexpected_error;
856: END IF;
857: x_return_status := FND_API.g_ret_sts_success;
858: -- End standard API initialization
859:
860: IF (g_fnd_debug = 'Y') THEN
861: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

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

880: p_doc_shipment_num => p_doc_shipment_num,
881: p_action => p_action,
882: p_agent_id => NULL,
883: x_return_status => x_return_status);
884: IF (x_return_status = FND_API.g_ret_sts_error) THEN
885: RAISE FND_API.g_exc_error;
886: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
887: RAISE FND_API.g_exc_unexpected_error;
888: END IF;

Line 885: RAISE FND_API.g_exc_error;

881: p_action => p_action,
882: p_agent_id => NULL,
883: x_return_status => x_return_status);
884: IF (x_return_status = FND_API.g_ret_sts_error) THEN
885: RAISE FND_API.g_exc_error;
886: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
887: RAISE FND_API.g_exc_unexpected_error;
888: END IF;
889:

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

882: p_agent_id => NULL,
883: x_return_status => x_return_status);
884: IF (x_return_status = FND_API.g_ret_sts_error) THEN
885: RAISE FND_API.g_exc_error;
886: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
887: RAISE FND_API.g_exc_unexpected_error;
888: END IF;
889:
890: EXCEPTION

Line 887: RAISE FND_API.g_exc_unexpected_error;

883: x_return_status => x_return_status);
884: IF (x_return_status = FND_API.g_ret_sts_error) THEN
885: RAISE FND_API.g_exc_error;
886: ELSIF (x_return_status = FND_API.g_ret_sts_unexp_error) THEN
887: RAISE FND_API.g_exc_unexpected_error;
888: END IF;
889:
890: EXCEPTION
891: WHEN FND_API.g_exc_error THEN

Line 891: WHEN FND_API.g_exc_error THEN

887: RAISE FND_API.g_exc_unexpected_error;
888: END IF;
889:
890: EXCEPTION
891: WHEN FND_API.g_exc_error THEN
892: x_return_status := FND_API.g_ret_sts_error;
893: WHEN FND_API.g_exc_unexpected_error THEN
894: x_return_status := FND_API.g_ret_sts_unexp_error;
895: WHEN OTHERS THEN

Line 892: x_return_status := FND_API.g_ret_sts_error;

888: END IF;
889:
890: EXCEPTION
891: WHEN FND_API.g_exc_error THEN
892: x_return_status := FND_API.g_ret_sts_error;
893: WHEN FND_API.g_exc_unexpected_error THEN
894: x_return_status := FND_API.g_ret_sts_unexp_error;
895: WHEN OTHERS THEN
896: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 893: WHEN FND_API.g_exc_unexpected_error THEN

889:
890: EXCEPTION
891: WHEN FND_API.g_exc_error THEN
892: x_return_status := FND_API.g_ret_sts_error;
893: WHEN FND_API.g_exc_unexpected_error THEN
894: x_return_status := FND_API.g_ret_sts_unexp_error;
895: WHEN OTHERS THEN
896: x_return_status := FND_API.g_ret_sts_unexp_error;
897: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 894: x_return_status := FND_API.g_ret_sts_unexp_error;

890: EXCEPTION
891: WHEN FND_API.g_exc_error THEN
892: x_return_status := FND_API.g_ret_sts_error;
893: WHEN FND_API.g_exc_unexpected_error THEN
894: x_return_status := FND_API.g_ret_sts_unexp_error;
895: WHEN OTHERS THEN
896: x_return_status := FND_API.g_ret_sts_unexp_error;
897: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
898: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 896: x_return_status := FND_API.g_ret_sts_unexp_error;

892: x_return_status := FND_API.g_ret_sts_error;
893: WHEN FND_API.g_exc_unexpected_error THEN
894: x_return_status := FND_API.g_ret_sts_unexp_error;
895: WHEN OTHERS THEN
896: x_return_status := FND_API.g_ret_sts_unexp_error;
897: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
898: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
899: IF (g_fnd_debug = 'Y') THEN
900: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

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

914: * in. If both the ID and number are passed in, the ID is used for validation.
915: * The final IDs must match the document specified. Appends to API message
916: * list on error.
917: * Returns:
918: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
919: * FND_API.G_RET_STS_ERROR if error occurred
920: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
921: */
922: PROCEDURE val_po_params

Line 919: * FND_API.G_RET_STS_ERROR if error occurred

915: * The final IDs must match the document specified. Appends to API message
916: * list on error.
917: * Returns:
918: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
919: * FND_API.G_RET_STS_ERROR if error occurred
920: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
921: */
922: PROCEDURE val_po_params
923: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

Line 920: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

916: * list on error.
917: * Returns:
918: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
919: * FND_API.G_RET_STS_ERROR if error occurred
920: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
921: */
922: PROCEDURE val_po_params
923: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
924: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

Line 942: x_return_status := FND_API.g_ret_sts_success;

938: l_exists VARCHAR2(10);
939: l_control_level NUMBER;
940:
941: BEGIN
942: x_return_status := FND_API.g_ret_sts_success;
943:
944: IF (g_fnd_debug = 'Y') THEN
945: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
946: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

Line 964: RAISE FND_API.g_exc_error;

960: || '.invalid_doc_ids', FALSE);
961: END IF;
962: END IF;
963: FND_MSG_PUB.add;
964: RAISE FND_API.g_exc_error;
965: END IF; --
966:
967: -- initialize outputs
968: x_doc_id := p_doc_id;

Line 1065: RAISE FND_API.g_exc_error;

1061: l_api_name || '.pa_has_ship_ids', FALSE);
1062: END IF;
1063: END IF;
1064: FND_MSG_PUB.add;
1065: RAISE FND_API.g_exc_error;
1066: END IF; --
1067:
1068: END IF; --
1069:

Line 1074: x_return_status := FND_API.g_ret_sts_error;

1070: END IF; -- g_header_level>
1071:
1072: EXCEPTION
1073: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
1074: x_return_status := FND_API.g_ret_sts_error;
1075: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
1076: IF (g_fnd_debug = 'Y') THEN
1077: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1078: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name ||

Line 1083: WHEN FND_API.g_exc_error THEN

1079: '.invalid_doc_ids', FALSE);
1080: END IF;
1081: END IF;
1082: FND_MSG_PUB.add;
1083: WHEN FND_API.g_exc_error THEN
1084: x_return_status := FND_API.g_ret_sts_error;
1085: WHEN OTHERS THEN
1086: x_return_status := FND_API.g_ret_sts_unexp_error;
1087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1084: x_return_status := FND_API.g_ret_sts_error;

1080: END IF;
1081: END IF;
1082: FND_MSG_PUB.add;
1083: WHEN FND_API.g_exc_error THEN
1084: x_return_status := FND_API.g_ret_sts_error;
1085: WHEN OTHERS THEN
1086: x_return_status := FND_API.g_ret_sts_unexp_error;
1087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1088: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1086: x_return_status := FND_API.g_ret_sts_unexp_error;

1082: FND_MSG_PUB.add;
1083: WHEN FND_API.g_exc_error THEN
1084: x_return_status := FND_API.g_ret_sts_error;
1085: WHEN OTHERS THEN
1086: x_return_status := FND_API.g_ret_sts_unexp_error;
1087: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1088: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1089: IF (g_fnd_debug = 'Y') THEN
1090: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

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

1104: * in. If both the ID and number are passed in, the ID is used for validation.
1105: * The final IDs must match the document specified. Appends to API message
1106: * list on error.
1107: * Returns:
1108: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
1109: * FND_API.G_RET_STS_ERROR if error occurred
1110: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1111: */
1112: PROCEDURE val_rel_params

Line 1109: * FND_API.G_RET_STS_ERROR if error occurred

1105: * The final IDs must match the document specified. Appends to API message
1106: * list on error.
1107: * Returns:
1108: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
1109: * FND_API.G_RET_STS_ERROR if error occurred
1110: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1111: */
1112: PROCEDURE val_rel_params
1113: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,

Line 1110: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1106: * list on error.
1107: * Returns:
1108: * x_return_status - FND_API.G_RET_STS_SUCCESS if derived all IDs correctly
1109: * FND_API.G_RET_STS_ERROR if error occurred
1110: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1111: */
1112: PROCEDURE val_rel_params
1113: (p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
1114: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,

Line 1133: x_return_status := FND_API.g_ret_sts_success;

1129: l_release_po_header_id NUMBER;
1130: l_release_po_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
1131:
1132: BEGIN
1133: x_return_status := FND_API.g_ret_sts_success;
1134:
1135: IF (g_fnd_debug = 'Y') THEN
1136: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
1137: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

Line 1156: RAISE FND_API.g_exc_error;

1152: || '.invalid_doc_ids', FALSE);
1153: END IF;
1154: END IF;
1155: FND_MSG_PUB.add;
1156: RAISE FND_API.g_exc_error;
1157: END IF; --
1158:
1159: -- initialize output
1160: x_doc_id := p_release_id;

Line 1256: x_return_status := FND_API.g_ret_sts_error;

1252: END IF; --
1253:
1254: EXCEPTION
1255: WHEN NO_DATA_FOUND OR TOO_MANY_ROWS THEN
1256: x_return_status := FND_API.g_ret_sts_error;
1257: FND_MESSAGE.set_name('PO','PO_INVALID_DOC_IDS');
1258: IF (g_fnd_debug = 'Y') THEN
1259: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_ERROR) THEN
1260: FND_LOG.message(FND_LOG.level_error, g_module_prefix || l_api_name ||

Line 1265: WHEN FND_API.g_exc_error THEN

1261: '.invalid_doc_ids', FALSE);
1262: END IF;
1263: END IF;
1264: FND_MSG_PUB.add;
1265: WHEN FND_API.g_exc_error THEN
1266: x_return_status := FND_API.g_ret_sts_error;
1267: WHEN OTHERS THEN
1268: x_return_status := FND_API.g_ret_sts_unexp_error;
1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1266: x_return_status := FND_API.g_ret_sts_error;

1262: END IF;
1263: END IF;
1264: FND_MSG_PUB.add;
1265: WHEN FND_API.g_exc_error THEN
1266: x_return_status := FND_API.g_ret_sts_error;
1267: WHEN OTHERS THEN
1268: x_return_status := FND_API.g_ret_sts_unexp_error;
1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1270: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1268: x_return_status := FND_API.g_ret_sts_unexp_error;

1264: FND_MSG_PUB.add;
1265: WHEN FND_API.g_exc_error THEN
1266: x_return_status := FND_API.g_ret_sts_error;
1267: WHEN OTHERS THEN
1268: x_return_status := FND_API.g_ret_sts_unexp_error;
1269: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1270: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1271: IF (g_fnd_debug = 'Y') THEN
1272: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN

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

1286: * document specified. Derives any ID if the ID is NULL, but the matching
1287: * number is passed in. If both the ID and number are passed in, the ID is
1288: * used. Appends to API message list on error.
1289: * Returns:
1290: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
1291: * FND_API.G_RET_STS_ERROR if validation fails
1292: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1293: * x_doc_id - The valid document ID
1294: * x_doc_line_id - The valid line ID, if at line level

Line 1291: * FND_API.G_RET_STS_ERROR if validation fails

1287: * number is passed in. If both the ID and number are passed in, the ID is
1288: * used. Appends to API message list on error.
1289: * Returns:
1290: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
1291: * FND_API.G_RET_STS_ERROR if validation fails
1292: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1293: * x_doc_id - The valid document ID
1294: * x_doc_line_id - The valid line ID, if at line level
1295: * x_doc_line_loc_id - The valid line location ID, if at shipment level

Line 1292: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

1288: * used. Appends to API message list on error.
1289: * Returns:
1290: * x_return_status - FND_API.G_RET_STS_SUCCESS if validation succeeds
1291: * FND_API.G_RET_STS_ERROR if validation fails
1292: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
1293: * x_doc_id - The valid document ID
1294: * x_doc_line_id - The valid line ID, if at line level
1295: * x_doc_line_loc_id - The valid line location ID, if at shipment level
1296: */

Line 1325: IF FND_API.to_boolean(p_init_msg_list) THEN

1321: l_release_po_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
1322:
1323: BEGIN
1324: -- Start standard API initialization
1325: IF FND_API.to_boolean(p_init_msg_list) THEN
1326: FND_MSG_PUB.initialize;
1327: END IF;
1328: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
1329: l_api_name, g_pkg_name)

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

1324: -- Start standard API initialization
1325: IF FND_API.to_boolean(p_init_msg_list) THEN
1326: FND_MSG_PUB.initialize;
1327: END IF;
1328: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
1329: l_api_name, g_pkg_name)
1330: THEN
1331: RAISE FND_API.g_exc_unexpected_error;
1332: END IF;

Line 1331: RAISE FND_API.g_exc_unexpected_error;

1327: END IF;
1328: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,
1329: l_api_name, g_pkg_name)
1330: THEN
1331: RAISE FND_API.g_exc_unexpected_error;
1332: END IF;
1333: x_return_status := FND_API.g_ret_sts_success;
1334: -- End standard API initialization
1335:

Line 1333: x_return_status := FND_API.g_ret_sts_success;

1329: l_api_name, g_pkg_name)
1330: THEN
1331: RAISE FND_API.g_exc_unexpected_error;
1332: END IF;
1333: x_return_status := FND_API.g_ret_sts_success;
1334: -- End standard API initialization
1335:
1336: IF (g_fnd_debug = 'Y') THEN
1337: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 1363: RAISE FND_API.g_exc_error;

1359: '.invalid_doc_type', FALSE);
1360: END IF;
1361: END IF;
1362: FND_MSG_PUB.add;
1363: RAISE FND_API.g_exc_error;
1364: END IF;
1365:
1366: IF (p_doc_type IN ('PO','PA')) THEN
1367:

Line 1378: RAISE FND_API.g_exc_error;

1374: '.po_pa_has_release_info', FALSE);
1375: END IF;
1376: END IF;
1377: FND_MSG_PUB.add;
1378: RAISE FND_API.g_exc_error;
1379: END IF; --
1380:
1381: val_po_params(p_doc_type => p_doc_type,
1382: p_doc_subtype => p_doc_subtype,

Line 1406: RAISE FND_API.g_exc_error;

1402: '.release_has_line_ids', FALSE);
1403: END IF;
1404: END IF;
1405: FND_MSG_PUB.add;
1406: RAISE FND_API.g_exc_error;
1407: END IF; --
1408:
1409: val_rel_params(p_doc_type => p_doc_type,
1410: p_doc_subtype => p_doc_subtype,

Line 1426: WHEN FND_API.g_exc_error THEN

1422:
1423: END IF; --
1424:
1425: EXCEPTION
1426: WHEN FND_API.g_exc_error THEN
1427: x_return_status := FND_API.g_ret_sts_error;
1428: WHEN FND_API.g_exc_unexpected_error THEN
1429: x_return_status := FND_API.g_ret_sts_unexp_error;
1430: WHEN OTHERS THEN

Line 1427: x_return_status := FND_API.g_ret_sts_error;

1423: END IF; --
1424:
1425: EXCEPTION
1426: WHEN FND_API.g_exc_error THEN
1427: x_return_status := FND_API.g_ret_sts_error;
1428: WHEN FND_API.g_exc_unexpected_error THEN
1429: x_return_status := FND_API.g_ret_sts_unexp_error;
1430: WHEN OTHERS THEN
1431: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 1428: WHEN FND_API.g_exc_unexpected_error THEN

1424:
1425: EXCEPTION
1426: WHEN FND_API.g_exc_error THEN
1427: x_return_status := FND_API.g_ret_sts_error;
1428: WHEN FND_API.g_exc_unexpected_error THEN
1429: x_return_status := FND_API.g_ret_sts_unexp_error;
1430: WHEN OTHERS THEN
1431: x_return_status := FND_API.g_ret_sts_unexp_error;
1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1429: x_return_status := FND_API.g_ret_sts_unexp_error;

1425: EXCEPTION
1426: WHEN FND_API.g_exc_error THEN
1427: x_return_status := FND_API.g_ret_sts_error;
1428: WHEN FND_API.g_exc_unexpected_error THEN
1429: x_return_status := FND_API.g_ret_sts_unexp_error;
1430: WHEN OTHERS THEN
1431: x_return_status := FND_API.g_ret_sts_unexp_error;
1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1433: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1431: x_return_status := FND_API.g_ret_sts_unexp_error;

1427: x_return_status := FND_API.g_ret_sts_error;
1428: WHEN FND_API.g_exc_unexpected_error THEN
1429: x_return_status := FND_API.g_ret_sts_unexp_error;
1430: WHEN OTHERS THEN
1431: x_return_status := FND_API.g_ret_sts_unexp_error;
1432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1433: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1434: IF (g_fnd_debug = 'Y') THEN
1435: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_UNEXPECTED) THEN