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

Line 71: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds

67: * tables for processing
68: * Effects: This procedure runs the document submission checks on passed in
69: * document.
70: * Returns:
71: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
72: * FND_API.G_RET_STS_ERROR if API fails
73: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
74: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
75: * submission checks, even if warnings are found

Line 72: * FND_API.G_RET_STS_ERROR if API fails

68: * Effects: This procedure runs the document submission checks on passed in
69: * document.
70: * Returns:
71: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
72: * FND_API.G_RET_STS_ERROR if API fails
73: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
74: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
75: * submission checks, even if warnings are found
76: * FND_API.G_RET_STS_ERROR if document fails atleast one

Line 73: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

69: * document.
70: * Returns:
71: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
72: * FND_API.G_RET_STS_ERROR if API fails
73: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
74: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
75: * submission checks, even if warnings are found
76: * FND_API.G_RET_STS_ERROR if document fails atleast one
77: * submission check (returns at least one error)

Line 74: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all

70: * Returns:
71: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
72: * FND_API.G_RET_STS_ERROR if API fails
73: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
74: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
75: * submission checks, even if warnings are found
76: * FND_API.G_RET_STS_ERROR if document fails atleast one
77: * submission check (returns at least one error)
78: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings

Line 76: * FND_API.G_RET_STS_ERROR if document fails atleast one

72: * FND_API.G_RET_STS_ERROR if API fails
73: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
74: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
75: * submission checks, even if warnings are found
76: * FND_API.G_RET_STS_ERROR if document fails atleast one
77: * submission check (returns at least one error)
78: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
79: * FND_API.G_FALSE if no warnings are found
80: * x_msg_data: Contains error msg in case x_return_status returned

Line 78: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings

74: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
75: * submission checks, even if warnings are found
76: * FND_API.G_RET_STS_ERROR if document fails atleast one
77: * submission check (returns at least one error)
78: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
79: * FND_API.G_FALSE if no warnings are found
80: * x_msg_data: Contains error msg in case x_return_status returned
81: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
82: * x_online_report_id: This id can be used to get all submission check errors

Line 79: * FND_API.G_FALSE if no warnings are found

75: * submission checks, even if warnings are found
76: * FND_API.G_RET_STS_ERROR if document fails atleast one
77: * submission check (returns at least one error)
78: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
79: * FND_API.G_FALSE if no warnings are found
80: * x_msg_data: Contains error msg in case x_return_status returned
81: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
82: * x_online_report_id: This id can be used to get all submission check errors
83: * for given document from online_report_text table

Line 81: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR

77: * submission check (returns at least one error)
78: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
79: * FND_API.G_FALSE if no warnings are found
80: * x_msg_data: Contains error msg in case x_return_status returned
81: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
82: * x_online_report_id: This id can be used to get all submission check errors
83: * for given document from online_report_text table
84: * x_doc_check_error_record: If x_sub_check_status returned G_RET_STS_ERROR
85: * then this object of tables will contain information about

Line 140: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

136: END IF;
137: END IF;
138:
139: -- Standard call to check for call compatibility
140: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
141: THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END IF;
144:

Line 142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

138:
139: -- Standard call to check for call compatibility
140: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
141: THEN
142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
143: END IF;
144:
145: PO_CORE_S.get_document_ids(
146: p_doc_type => p_document_type

Line 163: RAISE FND_API.G_EXC_ERROR;

159: THEN
160: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
161: FND_MESSAGE.set_token('ERROR_TEXT','Invalid Action Requested');
162: FND_MSG_PUB.Add;
163: RAISE FND_API.G_EXC_ERROR;
164: END IF;
165:
166: l_progress := '002';
167: --check p_document_type

Line 172: RAISE FND_API.G_EXC_ERROR;

168: IF p_document_type NOT IN ('REQUISITION', 'RELEASE', 'PO', 'PA') THEN
169: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
170: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document TYpe');
171: FND_MSG_PUB.Add;
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:
175: l_progress := '003';
176:

Line 183: RAISE FND_API.G_EXC_ERROR;

179: IF p_document_type NOT IN ('PO', 'RELEASE') THEN
180: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
181: FND_MESSAGE.set_token('ERROR_TEXT', 'UNRESERVE Action Requested for invalid document type');
182: FND_MSG_PUB.Add;
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185: --
186: ELSIF (p_action_requested = g_action_FINAL_CLOSE_CHECK) THEN
187: IF p_document_type NOT IN ('PO', 'PA', 'RELEASE') THEN

Line 191: RAISE FND_API.G_EXC_ERROR;

187: IF p_document_type NOT IN ('PO', 'PA', 'RELEASE') THEN
188: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
189: FND_MESSAGE.set_token('ERROR_TEXT', 'FINAL_CLOSE Action Requested for invalid document type');
190: FND_MSG_PUB.Add;
191: RAISE FND_API.G_EXC_ERROR;
192: END IF;
193: --
194: ELSE
195: IF p_document_level <> g_document_level_HEADER THEN

Line 199: RAISE FND_API.G_EXC_ERROR;

195: IF p_document_level <> g_document_level_HEADER THEN
196: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
197: FND_MESSAGE.set_token('ERROR_TEXT', 'Non-Header level only supported for UNRESERVE action');
198: FND_MSG_PUB.Add;
199: RAISE FND_API.G_EXC_ERROR;
200: END IF;
201: END IF;
202:
203: l_progress := '004';

Line 210: RAISE FND_API.G_EXC_ERROR;

206: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
207: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
208: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid document type for document type PO');
209: FND_MSG_PUB.Add;
210: RAISE FND_API.G_EXC_ERROR;
211: END IF;
212: ELSIF p_document_type = 'PA' THEN
213: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
214: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');

Line 217: RAISE FND_API.G_EXC_ERROR;

213: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
214: FND_MESSAGE.set_name('PO', 'PO_SUB_GENERAL_ERROR');
215: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid document type for document type PA');
216: FND_MSG_PUB.Add;
217: RAISE FND_API.G_EXC_ERROR;
218: END IF;
219: END IF;
220:
221: l_progress := '005';

Line 294: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;

290: -- : Do check even if consigned for final close.
291: IF (l_consigned_flag = 'Y') AND (p_action_requested <> g_action_FINAL_CLOSE_CHECK)
292: THEN
293:
294: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296:
297: Return;
298: END IF;

Line 295: x_return_status := FND_API.G_RET_STS_SUCCESS;

291: IF (l_consigned_flag = 'Y') AND (p_action_requested <> g_action_FINAL_CLOSE_CHECK)
292: THEN
293:
294: x_sub_check_status := FND_API.G_RET_STS_SUCCESS;
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296:
297: Return;
298: END IF;
299:

Line 331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

327: END IF;
328: END IF;
329:
330: EXCEPTION
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
333: p_encoded => 'F');
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: x_sub_check_status := FND_API.G_RET_STS_ERROR;

Line 334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

330: EXCEPTION
331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
333: p_encoded => 'F');
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: x_sub_check_status := FND_API.G_RET_STS_ERROR;
336: WHEN FND_API.G_EXC_ERROR THEN
337: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
338: p_encoded => 'F');

Line 335: x_sub_check_status := FND_API.G_RET_STS_ERROR;

331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
333: p_encoded => 'F');
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: x_sub_check_status := FND_API.G_RET_STS_ERROR;
336: WHEN FND_API.G_EXC_ERROR THEN
337: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
338: p_encoded => 'F');
339: x_return_status := FND_API.G_RET_STS_ERROR;

Line 336: WHEN FND_API.G_EXC_ERROR THEN

332: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
333: p_encoded => 'F');
334: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
335: x_sub_check_status := FND_API.G_RET_STS_ERROR;
336: WHEN FND_API.G_EXC_ERROR THEN
337: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
338: p_encoded => 'F');
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: x_sub_check_status := FND_API.G_RET_STS_ERROR;

Line 339: x_return_status := FND_API.G_RET_STS_ERROR;

335: x_sub_check_status := FND_API.G_RET_STS_ERROR;
336: WHEN FND_API.G_EXC_ERROR THEN
337: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
338: p_encoded => 'F');
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: x_sub_check_status := FND_API.G_RET_STS_ERROR;
341: WHEN OTHERS THEN
342: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
343: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

Line 340: x_sub_check_status := FND_API.G_RET_STS_ERROR;

336: WHEN FND_API.G_EXC_ERROR THEN
337: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
338: p_encoded => 'F');
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: x_sub_check_status := FND_API.G_RET_STS_ERROR;
341: WHEN OTHERS THEN
342: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
343: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
344: END IF;

Line 356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

352: END IF;
353:
354: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
355: p_encoded => 'F');
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: x_sub_check_status := FND_API.G_RET_STS_ERROR;
358: END po_submission_check;
359:
360: -- bug3574165 START

Line 357: x_sub_check_status := FND_API.G_RET_STS_ERROR;

353:
354: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
355: p_encoded => 'F');
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: x_sub_check_status := FND_API.G_RET_STS_ERROR;
358: END po_submission_check;
359:
360: -- bug3574165 START
361: -- Overloaded procedure. This procedure does not take l_has_warnings

Line 527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

523: x_doc_check_error_record => l_doc_check_error_record);
524:
525: l_progress := '001';
526: EXCEPTION
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
529: p_encoded => 'F');
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: x_sub_check_status := FND_API.G_RET_STS_ERROR;

Line 530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

526: EXCEPTION
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
529: p_encoded => 'F');
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: x_sub_check_status := FND_API.G_RET_STS_ERROR;
532: WHEN FND_API.G_EXC_ERROR THEN
533: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
534: p_encoded => 'F');

Line 531: x_sub_check_status := FND_API.G_RET_STS_ERROR;

527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
529: p_encoded => 'F');
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: x_sub_check_status := FND_API.G_RET_STS_ERROR;
532: WHEN FND_API.G_EXC_ERROR THEN
533: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
534: p_encoded => 'F');
535: x_return_status := FND_API.G_RET_STS_ERROR;

Line 532: WHEN FND_API.G_EXC_ERROR THEN

528: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
529: p_encoded => 'F');
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: x_sub_check_status := FND_API.G_RET_STS_ERROR;
532: WHEN FND_API.G_EXC_ERROR THEN
533: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
534: p_encoded => 'F');
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: x_sub_check_status := FND_API.G_RET_STS_ERROR;

Line 535: x_return_status := FND_API.G_RET_STS_ERROR;

531: x_sub_check_status := FND_API.G_RET_STS_ERROR;
532: WHEN FND_API.G_EXC_ERROR THEN
533: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
534: p_encoded => 'F');
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: x_sub_check_status := FND_API.G_RET_STS_ERROR;
537: WHEN OTHERS THEN
538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
539: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

Line 536: x_sub_check_status := FND_API.G_RET_STS_ERROR;

532: WHEN FND_API.G_EXC_ERROR THEN
533: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
534: p_encoded => 'F');
535: x_return_status := FND_API.G_RET_STS_ERROR;
536: x_sub_check_status := FND_API.G_RET_STS_ERROR;
537: WHEN OTHERS THEN
538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
539: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);
540: END IF;

Line 552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

548: END IF;
549:
550: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
551: p_encoded => 'F');
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: x_sub_check_status := FND_API.G_RET_STS_ERROR;
554: END po_submission_check;
555:
556:

Line 553: x_sub_check_status := FND_API.G_RET_STS_ERROR;

549:
550: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
551: p_encoded => 'F');
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: x_sub_check_status := FND_API.G_RET_STS_ERROR;
554: END po_submission_check;
555:
556:
557: -- bug3574165 START

Line 624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

620:
621: l_progress := '001';
622:
623: EXCEPTION
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
626: p_encoded => 'F');
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: x_sub_check_status := FND_API.G_RET_STS_ERROR;

Line 627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

623: EXCEPTION
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
626: p_encoded => 'F');
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: x_sub_check_status := FND_API.G_RET_STS_ERROR;
629:
630: WHEN FND_API.G_EXC_ERROR THEN
631: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,

Line 628: x_sub_check_status := FND_API.G_RET_STS_ERROR;

624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
626: p_encoded => 'F');
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: x_sub_check_status := FND_API.G_RET_STS_ERROR;
629:
630: WHEN FND_API.G_EXC_ERROR THEN
631: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
632: p_encoded => 'F');

Line 630: WHEN FND_API.G_EXC_ERROR THEN

626: p_encoded => 'F');
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: x_sub_check_status := FND_API.G_RET_STS_ERROR;
629:
630: WHEN FND_API.G_EXC_ERROR THEN
631: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
632: p_encoded => 'F');
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: x_sub_check_status := FND_API.G_RET_STS_ERROR;

Line 633: x_return_status := FND_API.G_RET_STS_ERROR;

629:
630: WHEN FND_API.G_EXC_ERROR THEN
631: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
632: p_encoded => 'F');
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: x_sub_check_status := FND_API.G_RET_STS_ERROR;
635:
636: WHEN OTHERS THEN
637: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

Line 634: x_sub_check_status := FND_API.G_RET_STS_ERROR;

630: WHEN FND_API.G_EXC_ERROR THEN
631: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
632: p_encoded => 'F');
633: x_return_status := FND_API.G_RET_STS_ERROR;
634: x_sub_check_status := FND_API.G_RET_STS_ERROR;
635:
636: WHEN OTHERS THEN
637: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
638: THEN

Line 653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

649: END IF;
650:
651: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
652: p_encoded => 'F');
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: x_sub_check_status := FND_API.G_RET_STS_ERROR;
655:
656: END po_submission_check;
657: -- bug3574165 END

Line 654: x_sub_check_status := FND_API.G_RET_STS_ERROR;

650:
651: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
652: p_encoded => 'F');
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654: x_sub_check_status := FND_API.G_RET_STS_ERROR;
655:
656: END po_submission_check;
657: -- bug3574165 END
658:

Line 750: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds

746: * Modifies: None
747: * Effects: This procedure builds dynamic WHERE clause fragments based on
748: * document security parameters.
749: * Returns:
750: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
751: * FND_API.G_RET_STS_ERROR if API fails
752: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
753: * x_msg_data: Contains error msg in case x_return_status returned
754: * FND_API.G_RET_STS_ERROR or

Line 751: * FND_API.G_RET_STS_ERROR if API fails

747: * Effects: This procedure builds dynamic WHERE clause fragments based on
748: * document security parameters.
749: * Returns:
750: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
751: * FND_API.G_RET_STS_ERROR if API fails
752: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
753: * x_msg_data: Contains error msg in case x_return_status returned
754: * FND_API.G_RET_STS_ERROR or
755: * FND_API.G_RET_STS_UNEXP_ERROR

Line 752: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error

748: * document security parameters.
749: * Returns:
750: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
751: * FND_API.G_RET_STS_ERROR if API fails
752: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
753: * x_msg_data: Contains error msg in case x_return_status returned
754: * FND_API.G_RET_STS_ERROR or
755: * FND_API.G_RET_STS_UNEXP_ERROR
756: * x_where_clause: The constructed where clause

Line 754: * FND_API.G_RET_STS_ERROR or

750: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
751: * FND_API.G_RET_STS_ERROR if API fails
752: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
753: * x_msg_data: Contains error msg in case x_return_status returned
754: * FND_API.G_RET_STS_ERROR or
755: * FND_API.G_RET_STS_UNEXP_ERROR
756: * x_where_clause: The constructed where clause
757: */
758: PROCEDURE PO_SECURITY_CHECK (p_api_version IN NUMBER,

Line 755: * FND_API.G_RET_STS_UNEXP_ERROR

751: * FND_API.G_RET_STS_ERROR if API fails
752: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error
753: * x_msg_data: Contains error msg in case x_return_status returned
754: * FND_API.G_RET_STS_ERROR or
755: * FND_API.G_RET_STS_UNEXP_ERROR
756: * x_where_clause: The constructed where clause
757: */
758: PROCEDURE PO_SECURITY_CHECK (p_api_version IN NUMBER,
759: p_query_table IN VARCHAR2,

Line 780: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)

776: BEGIN
777:
778: l_progress := '000';
779: -- Standard call to check for call compatibility
780: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
781: THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:

Line 782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

778: l_progress := '000';
779: -- Standard call to check for call compatibility
780: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
781: THEN
782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:
785: l_progress := '010';
786:

Line 802: RAISE FND_API.G_EXC_ERROR;

798: (p_document_subtype is NULL) OR (p_type_clause is NULL)) THEN
799: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
800: FND_MESSAGE.set_token('ERROR_TEXT', 'Mandatory parameters are NULL');
801: FND_MSG_PUB.Add;
802: RAISE FND_API.G_EXC_ERROR;
803: END IF; /*(p_query_table is NULL) OR (p_owner_id_column is NULL)*/
804:
805: l_progress := '020';
806: --Check p_minimum_access_level

Line 811: RAISE FND_API.G_EXC_ERROR;

807: IF p_minimum_access_level NOT IN ('VIEW_ONLY', 'MODIFY', 'FULL') THEN
808: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
809: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Minimum Access Level');
810: FND_MSG_PUB.Add;
811: RAISE FND_API.G_EXC_ERROR;
812: END IF; /*p_minimum_access_level NOT IN ('VIEW_ONLY', 'MODIFY', 'ALL')*/
813:
814: l_progress := '030';
815: --check p_document_type

Line 822: RAISE FND_API.G_EXC_ERROR;

818: 'RELEASE', 'PO', 'PA', 'PO_PA') THEN
819: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
820: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Type');
821: FND_MSG_PUB.Add;
822: RAISE FND_API.G_EXC_ERROR;
823: END IF; /*p_document_type NOT IN ('RFQ', 'QUOTATION', 'REQUISITION',*/
824:
825: l_progress := '040';
826: --check that document_subtype matches

Line 832: RAISE FND_API.G_EXC_ERROR;

828: IF p_document_subtype NOT IN ('PURCHASE', 'INTERNAL') THEN
829: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
830: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
831: FND_MSG_PUB.Add;
832: RAISE FND_API.G_EXC_ERROR;
833: END IF;
834: ELSIF p_document_type = 'RELEASE' THEN
835: IF p_document_subtype NOT IN ('SCHEDULED', 'BLANKET') THEN
836: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

Line 839: RAISE FND_API.G_EXC_ERROR;

835: IF p_document_subtype NOT IN ('SCHEDULED', 'BLANKET') THEN
836: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
837: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
838: FND_MSG_PUB.Add;
839: RAISE FND_API.G_EXC_ERROR;
840: END IF;
841: ELSIF p_document_type = 'PO' THEN
842: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
843: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

Line 846: RAISE FND_API.G_EXC_ERROR;

842: IF p_document_subtype NOT IN ('STANDARD', 'PLANNED') THEN
843: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
844: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
845: FND_MSG_PUB.Add;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848: ELSIF p_document_type = 'PA' THEN
849: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
850: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');

Line 853: RAISE FND_API.G_EXC_ERROR;

849: IF p_document_subtype NOT IN ('BLANKET', 'CONTRACT') THEN
850: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
851: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
852: FND_MSG_PUB.Add;
853: RAISE FND_API.G_EXC_ERROR;
854: END IF;
855: -- Bug 5054685 Start: Performance issue. Collapsed multiple security
856: -- related where-clauses into one.
857: ELSIF p_document_type = 'PO_PA' THEN

Line 862: RAISE FND_API.G_EXC_ERROR;

858: IF p_document_subtype NOT IN ('ALL') THEN
859: FND_MESSAGE.set_name('PO', 'PO_SEC_GENERAL_ERROR');
860: FND_MESSAGE.set_token('ERROR_TEXT', 'Invalid Document Subtype');
861: FND_MSG_PUB.Add;
862: RAISE FND_API.G_EXC_ERROR;
863: END IF;
864: -- Bug 5054685 End
865: END IF; /*p_document_type = 'REQUISITION'*/
866:

Line 890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

886: x_where_clause => x_where_clause);
887:
888: l_progress := '100';
889: EXCEPTION
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
892: p_encoded => 'F');
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: x_where_clause := NULL;

Line 893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

889: EXCEPTION
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
892: p_encoded => 'F');
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: x_where_clause := NULL;
895: WHEN FND_API.G_EXC_ERROR THEN
896: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
897: p_encoded => 'F');

Line 895: WHEN FND_API.G_EXC_ERROR THEN

891: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
892: p_encoded => 'F');
893: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
894: x_where_clause := NULL;
895: WHEN FND_API.G_EXC_ERROR THEN
896: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
897: p_encoded => 'F');
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: x_where_clause := NULL;

Line 898: x_return_status := FND_API.G_RET_STS_ERROR;

894: x_where_clause := NULL;
895: WHEN FND_API.G_EXC_ERROR THEN
896: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
897: p_encoded => 'F');
898: x_return_status := FND_API.G_RET_STS_ERROR;
899: x_where_clause := NULL;
900: WHEN OTHERS THEN
901: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
902: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name);

Line 915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

911: END IF;
912:
913: x_msg_data := FND_MSG_PUB.GET(p_msg_index => FND_MSG_PUB.G_LAST,
914: p_encoded => 'F');
915: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
916: x_where_clause := NULL;
917: END PO_SECURITY_CHECK;
918:
919: --

Line 985: RAISE FND_API.G_EXC_ERROR;

981: l_count := p_vendor_order_num.COUNT;
982: ELSE -- The required input table ID parameters are all null !
983: FND_MESSAGE.set_name('PO', 'PO_STATCHK_ERR_NULL_INPARAM');
984: FND_MSG_PUB.Add;
985: RAISE FND_API.G_EXC_ERROR;
986: END IF;
987:
988: --Initialize any null Tables to a dummy table of null values with length of p_header_id.COUNT
989: l_progress := '007';

Line 1034: RAISE FND_API.G_EXC_ERROR;

1030:
1031: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
1032: FND_MESSAGE.set_token('ERROR_TEXT', 'The input table ID parameters are not of same size !');
1033: FND_MSG_PUB.Add;
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;
1036:
1037: --Validate that a Header or Release is specified through any of the possible combinations
1038: -- Line/Shipment/Distribution are optional, but Header/Release should be specified.

Line 1050: RAISE FND_API.G_EXC_ERROR;

1046: -- Means that no Header/Release is specified
1047: FND_MESSAGE.set_name('PO', 'PO_STATCHK_GENERAL_ERROR');
1048: FND_MESSAGE.set_token('ERROR_TEXT', 'There is no Header/Release specified at index ' || i);
1049: FND_MSG_PUB.Add;
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052:
1053: END LOOP;
1054:

Line 1057: x_return_status := FND_API.G_RET_STS_SUCCESS;

1053: END LOOP;
1054:
1055: l_progress := '030';
1056:
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1060: WHEN FND_API.G_EXC_ERROR THEN

1056:
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: WHEN OTHERS THEN
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1064: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

Line 1061: x_return_status := FND_API.G_RET_STS_ERROR;

1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058:
1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: WHEN OTHERS THEN
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1064: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
1065:

Line 1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: x_return_status := FND_API.G_RET_STS_ERROR;
1062: WHEN OTHERS THEN
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1064: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
1065:
1066: END validate_status_check_inputs;
1067:

Line 1122: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1118:
1119: BEGIN
1120:
1121: --Standard call to check for call compatibility
1122: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1124: END IF;
1125:
1126: --Validate Input Parameters and do any defaulting

Line 1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1119: BEGIN
1120:
1121: --Standard call to check for call compatibility
1122: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1124: END IF;
1125:
1126: --Validate Input Parameters and do any defaulting
1127: l_progress := '010';

Line 1143: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1139: p_mode => p_mode,
1140: x_po_status_rec => x_po_status_rec,
1141: x_return_status => x_return_status);
1142:
1143: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1144: return;
1145: END IF;
1146:
1147: --Call the private procedure to actually do po status check

Line 1172: WHEN FND_API.G_EXC_ERROR THEN

1168:
1169: l_progress := '030';
1170:
1171: EXCEPTION
1172: WHEN FND_API.G_EXC_ERROR THEN
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: WHEN OTHERS THEN

Line 1173: x_return_status := FND_API.G_RET_STS_ERROR;

1169: l_progress := '030';
1170:
1171: EXCEPTION
1172: WHEN FND_API.G_EXC_ERROR THEN
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: WHEN OTHERS THEN
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1170:
1171: EXCEPTION
1172: WHEN FND_API.G_EXC_ERROR THEN
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: WHEN OTHERS THEN
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

Line 1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1171: EXCEPTION
1172: WHEN FND_API.G_EXC_ERROR THEN
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: WHEN OTHERS THEN
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
1179:

Line 1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: WHEN OTHERS THEN
1177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1178: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
1179:
1180: END po_status_check;
1181:

Line 1226: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1222:
1223: BEGIN
1224:
1225: --Standard call to check for call compatibility
1226: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: END IF;
1229:
1230: --Call the overloaded procedure that takes in Table IDs after

Line 1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1223: BEGIN
1224:
1225: --Standard call to check for call compatibility
1226: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: END IF;
1229:
1230: --Call the overloaded procedure that takes in Table IDs after
1231: -- creating size=1 Tables of IDs 1 with value of the scalar input IDs

Line 1255: WHEN FND_API.G_EXC_ERROR THEN

1251:
1252: l_progress := '020';
1253:
1254: EXCEPTION
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1259: WHEN OTHERS THEN

Line 1256: x_return_status := FND_API.G_RET_STS_ERROR;

1252: l_progress := '020';
1253:
1254: EXCEPTION
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1259: WHEN OTHERS THEN
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1253:
1254: EXCEPTION
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1259: WHEN OTHERS THEN
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);

Line 1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1254: EXCEPTION
1255: WHEN FND_API.G_EXC_ERROR THEN
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1259: WHEN OTHERS THEN
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
1262:

Line 1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1259: WHEN OTHERS THEN
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1261: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
1262:
1263: END po_status_check;
1264:

Line 1294: -- FND_API.G_RET_STS_SUCCESS if the API completed successfully.

1290: -- are not allowed to the standard API message list; otherwise, the API will not
1291: -- add the reasons to the message list.
1292: --OUT:
1293: --x_return_status
1294: -- FND_API.G_RET_STS_SUCCESS if the API completed successfully.
1295: -- FND_API.G_RET_STS_ERROR if there was an error.
1296: -- FND_API.G_RET_STS_UNEXP_ERROR if there was an unexpected error.
1297: --x_price_updateable
1298: -- PO_CORE_S.G_PARAMETER_YES if price updates are allowed on this shipment,

Line 1295: -- FND_API.G_RET_STS_ERROR if there was an error.

1291: -- add the reasons to the message list.
1292: --OUT:
1293: --x_return_status
1294: -- FND_API.G_RET_STS_SUCCESS if the API completed successfully.
1295: -- FND_API.G_RET_STS_ERROR if there was an error.
1296: -- FND_API.G_RET_STS_UNEXP_ERROR if there was an unexpected error.
1297: --x_price_updateable
1298: -- PO_CORE_S.G_PARAMETER_YES if price updates are allowed on this shipment,
1299: -- PO_CORE_S.G_PARAMETER_NO otherwise

Line 1296: -- FND_API.G_RET_STS_UNEXP_ERROR if there was an unexpected error.

1292: --OUT:
1293: --x_return_status
1294: -- FND_API.G_RET_STS_SUCCESS if the API completed successfully.
1295: -- FND_API.G_RET_STS_ERROR if there was an error.
1296: -- FND_API.G_RET_STS_UNEXP_ERROR if there was an unexpected error.
1297: --x_price_updateable
1298: -- PO_CORE_S.G_PARAMETER_YES if price updates are allowed on this shipment,
1299: -- PO_CORE_S.G_PARAMETER_NO otherwise
1300: --x_retroactive_price_change

Line 1337: IF NOT FND_API.compatible_api_call (

1333: PO_DEBUG.debug_begin(l_log_head);
1334: END IF;
1335:
1336: -- Standard API initialization:
1337: IF NOT FND_API.compatible_api_call (
1338: p_current_version_number => l_api_version,
1339: p_caller_version_number => p_api_version,
1340: p_api_name => l_api_name,
1341: p_pkg_name => g_pkg_name ) THEN

Line 1342: RAISE FND_API.g_exc_unexpected_error;

1338: p_current_version_number => l_api_version,
1339: p_caller_version_number => p_api_version,
1340: p_api_name => l_api_name,
1341: p_pkg_name => g_pkg_name ) THEN
1342: RAISE FND_API.g_exc_unexpected_error;
1343: END IF;
1344: x_return_status := FND_API.G_RET_STS_SUCCESS;
1345:
1346: -- Default: price updates allowed, no retroactive price change.

Line 1344: x_return_status := FND_API.G_RET_STS_SUCCESS;

1340: p_api_name => l_api_name,
1341: p_pkg_name => g_pkg_name ) THEN
1342: RAISE FND_API.g_exc_unexpected_error;
1343: END IF;
1344: x_return_status := FND_API.G_RET_STS_SUCCESS;
1345:
1346: -- Default: price updates allowed, no retroactive price change.
1347: x_price_updateable := PO_CORE_S.G_PARAMETER_YES;
1348: x_retroactive_price_change := PO_CORE_S.G_PARAMETER_NO;

Line 1520: WHEN FND_API.G_EXC_ERROR THEN

1516: IF g_debug_stmt THEN
1517: PO_DEBUG.debug_end(l_log_head);
1518: END IF;
1519: EXCEPTION
1520: WHEN FND_API.G_EXC_ERROR THEN
1521: x_return_status := FND_API.G_RET_STS_ERROR;
1522: IF g_debug_unexp THEN
1523: PO_DEBUG.debug_exc(l_log_head, l_progress);
1524: END IF;

Line 1521: x_return_status := FND_API.G_RET_STS_ERROR;

1517: PO_DEBUG.debug_end(l_log_head);
1518: END IF;
1519: EXCEPTION
1520: WHEN FND_API.G_EXC_ERROR THEN
1521: x_return_status := FND_API.G_RET_STS_ERROR;
1522: IF g_debug_unexp THEN
1523: PO_DEBUG.debug_exc(l_log_head, l_progress);
1524: END IF;
1525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1521: x_return_status := FND_API.G_RET_STS_ERROR;
1522: IF g_debug_unexp THEN
1523: PO_DEBUG.debug_exc(l_log_head, l_progress);
1524: END IF;
1525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527: IF g_debug_unexp THEN
1528: PO_DEBUG.debug_exc(l_log_head, l_progress);
1529: END IF;

Line 1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1522: IF g_debug_unexp THEN
1523: PO_DEBUG.debug_exc(l_log_head, l_progress);
1524: END IF;
1525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527: IF g_debug_unexp THEN
1528: PO_DEBUG.debug_exc(l_log_head, l_progress);
1529: END IF;
1530: WHEN OTHERS THEN

Line 1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1527: IF g_debug_unexp THEN
1528: PO_DEBUG.debug_exc(l_log_head, l_progress);
1529: END IF;
1530: WHEN OTHERS THEN
1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1532: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||'.'||l_progress);
1533: IF g_debug_unexp THEN
1534: PO_DEBUG.debug_exc(l_log_head, l_progress);
1535: END IF;

Line 1566: -- FND_API.G_RET_STS_SUCCESS if the API completed successfully.

1562: -- are not allowed to the standard API message list; otherwise, the API will not
1563: -- add the reasons to the message list.
1564: --OUT:
1565: --x_return_status
1566: -- FND_API.G_RET_STS_SUCCESS if the API completed successfully.
1567: -- FND_API.G_RET_STS_ERROR if there was an error.
1568: -- FND_API.G_RET_STS_UNEXP_ERROR if there was an unexpected error.
1569: --x_price_updateable
1570: -- PO_CORE_S.G_PARAMETER_YES if price updates are allowed on this shipment,

Line 1567: -- FND_API.G_RET_STS_ERROR if there was an error.

1563: -- add the reasons to the message list.
1564: --OUT:
1565: --x_return_status
1566: -- FND_API.G_RET_STS_SUCCESS if the API completed successfully.
1567: -- FND_API.G_RET_STS_ERROR if there was an error.
1568: -- FND_API.G_RET_STS_UNEXP_ERROR if there was an unexpected error.
1569: --x_price_updateable
1570: -- PO_CORE_S.G_PARAMETER_YES if price updates are allowed on this shipment,
1571: -- PO_CORE_S.G_PARAMETER_NO otherwise

Line 1568: -- FND_API.G_RET_STS_UNEXP_ERROR if there was an unexpected error.

1564: --OUT:
1565: --x_return_status
1566: -- FND_API.G_RET_STS_SUCCESS if the API completed successfully.
1567: -- FND_API.G_RET_STS_ERROR if there was an error.
1568: -- FND_API.G_RET_STS_UNEXP_ERROR if there was an unexpected error.
1569: --x_price_updateable
1570: -- PO_CORE_S.G_PARAMETER_YES if price updates are allowed on this shipment,
1571: -- PO_CORE_S.G_PARAMETER_NO otherwise
1572: --x_retroactive_price_change

Line 1607: IF NOT FND_API.compatible_api_call (

1603: PO_DEBUG.debug_begin(l_log_head);
1604: END IF;
1605:
1606: -- Standard API initialization:
1607: IF NOT FND_API.compatible_api_call (
1608: p_current_version_number => l_api_version,
1609: p_caller_version_number => p_api_version,
1610: p_api_name => l_api_name,
1611: p_pkg_name => g_pkg_name ) THEN

Line 1612: RAISE FND_API.g_exc_unexpected_error;

1608: p_current_version_number => l_api_version,
1609: p_caller_version_number => p_api_version,
1610: p_api_name => l_api_name,
1611: p_pkg_name => g_pkg_name ) THEN
1612: RAISE FND_API.g_exc_unexpected_error;
1613: END IF;
1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615:
1616: -- Default: price updates allowed, no retroactive price change.

Line 1614: x_return_status := FND_API.G_RET_STS_SUCCESS;

1610: p_api_name => l_api_name,
1611: p_pkg_name => g_pkg_name ) THEN
1612: RAISE FND_API.g_exc_unexpected_error;
1613: END IF;
1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
1615:
1616: -- Default: price updates allowed, no retroactive price change.
1617: x_price_updateable := PO_CORE_S.G_PARAMETER_YES;
1618: x_retroactive_price_change := PO_CORE_S.G_PARAMETER_NO;

Line 1739: WHEN FND_API.G_EXC_ERROR THEN

1735: IF g_debug_stmt THEN
1736: PO_DEBUG.debug_end(l_log_head);
1737: END IF;
1738: EXCEPTION
1739: WHEN FND_API.G_EXC_ERROR THEN
1740: x_return_status := FND_API.G_RET_STS_ERROR;
1741: IF g_debug_unexp THEN
1742: PO_DEBUG.debug_exc(l_log_head, l_progress);
1743: END IF;

Line 1740: x_return_status := FND_API.G_RET_STS_ERROR;

1736: PO_DEBUG.debug_end(l_log_head);
1737: END IF;
1738: EXCEPTION
1739: WHEN FND_API.G_EXC_ERROR THEN
1740: x_return_status := FND_API.G_RET_STS_ERROR;
1741: IF g_debug_unexp THEN
1742: PO_DEBUG.debug_exc(l_log_head, l_progress);
1743: END IF;
1744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1740: x_return_status := FND_API.G_RET_STS_ERROR;
1741: IF g_debug_unexp THEN
1742: PO_DEBUG.debug_exc(l_log_head, l_progress);
1743: END IF;
1744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1746: IF g_debug_unexp THEN
1747: PO_DEBUG.debug_exc(l_log_head, l_progress);
1748: END IF;

Line 1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1741: IF g_debug_unexp THEN
1742: PO_DEBUG.debug_exc(l_log_head, l_progress);
1743: END IF;
1744: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1746: IF g_debug_unexp THEN
1747: PO_DEBUG.debug_exc(l_log_head, l_progress);
1748: END IF;
1749: WHEN OTHERS THEN

Line 1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1746: IF g_debug_unexp THEN
1747: PO_DEBUG.debug_exc(l_log_head, l_progress);
1748: END IF;
1749: WHEN OTHERS THEN
1750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1751: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name||'.'||l_progress);
1752: IF g_debug_unexp THEN
1753: PO_DEBUG.debug_exc(l_log_head, l_progress);
1754: END IF;

Line 1783: x_return_status := FND_API.g_ret_sts_success;

1779: END IF;
1780:
1781: d_progress := 10;
1782:
1783: x_return_status := FND_API.g_ret_sts_success;
1784:
1785: l_is_price_updateable := PO_DOCUMENT_CHECKS_PVT.is_pay_item_price_updateable(
1786: p_line_location_id => p_line_location_id
1787: , p_add_reasons_to_msg_list => p_add_reasons_to_msg_list);

Line 1811: x_return_status := FND_API.g_ret_sts_unexp_error;

1807: IF (PO_LOG.d_exc) THEN
1808: PO_LOG.exc(d_module, d_progress, SQLCODE || SQLERRM);
1809: PO_LOG.proc_end(d_module);
1810: END IF;
1811: x_return_status := FND_API.g_ret_sts_unexp_error;
1812: x_price_updateable := PO_CORE_S.g_parameter_no;
1813: END;
1814: --
1815:

Line 2102: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds

2098: * tables for processing
2099: * Effects: This procedure runs the document submission checks on passed in
2100: * document.
2101: * Returns:
2102: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
2103: * FND_API.G_RET_STS_ERROR if API fails
2104: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2105: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
2106: * submission checks, even if warnings are found

Line 2103: * FND_API.G_RET_STS_ERROR if API fails

2099: * Effects: This procedure runs the document submission checks on passed in
2100: * document.
2101: * Returns:
2102: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
2103: * FND_API.G_RET_STS_ERROR if API fails
2104: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2105: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
2106: * submission checks, even if warnings are found
2107: * FND_API.G_RET_STS_ERROR if document fails atleast one

Line 2104: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs

2100: * document.
2101: * Returns:
2102: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
2103: * FND_API.G_RET_STS_ERROR if API fails
2104: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2105: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
2106: * submission checks, even if warnings are found
2107: * FND_API.G_RET_STS_ERROR if document fails atleast one
2108: * submission check (returns at least one error)

Line 2105: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all

2101: * Returns:
2102: * x_return_status: FND_API.G_RET_STS_SUCCESS if API succeeds
2103: * FND_API.G_RET_STS_ERROR if API fails
2104: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2105: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
2106: * submission checks, even if warnings are found
2107: * FND_API.G_RET_STS_ERROR if document fails atleast one
2108: * submission check (returns at least one error)
2109: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings

Line 2107: * FND_API.G_RET_STS_ERROR if document fails atleast one

2103: * FND_API.G_RET_STS_ERROR if API fails
2104: * FND_API.G_RET_STS_UNEXP_ERROR if unexpected error occurs
2105: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
2106: * submission checks, even if warnings are found
2107: * FND_API.G_RET_STS_ERROR if document fails atleast one
2108: * submission check (returns at least one error)
2109: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
2110: * FND_API.G_FALSE if no warnings are found
2111: * x_msg_data: Contains error msg in case x_return_status returned

Line 2109: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings

2105: * x_sub_check_status: FND_API.G_RET_STS_SUCCESS if document passes all
2106: * submission checks, even if warnings are found
2107: * FND_API.G_RET_STS_ERROR if document fails atleast one
2108: * submission check (returns at least one error)
2109: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
2110: * FND_API.G_FALSE if no warnings are found
2111: * x_msg_data: Contains error msg in case x_return_status returned
2112: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
2113: * x_online_report_id: This id can be used to get all submission check (including

Line 2110: * FND_API.G_FALSE if no warnings are found

2106: * submission checks, even if warnings are found
2107: * FND_API.G_RET_STS_ERROR if document fails atleast one
2108: * submission check (returns at least one error)
2109: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
2110: * FND_API.G_FALSE if no warnings are found
2111: * x_msg_data: Contains error msg in case x_return_status returned
2112: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
2113: * x_online_report_id: This id can be used to get all submission check (including
2114: * copydoc check and normal po submission check) errors

Line 2112: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR

2108: * submission check (returns at least one error)
2109: * x_has_warnings: FND_API.G_TRUE if submission check returns warnings
2110: * FND_API.G_FALSE if no warnings are found
2111: * x_msg_data: Contains error msg in case x_return_status returned
2112: * FND_API.G_RET_STS_ERROR or FND_API.G_RET_STS_UNEXP_ERROR
2113: * x_online_report_id: This id can be used to get all submission check (including
2114: * copydoc check and normal po submission check) errors
2115: * for given document from online_report_text table.
2116: * x_doc_check_error_record: If x_sub_check_status returned G_RET_STS_ERROR

Line 2275: x_return_status := FND_API.G_RET_STS_SUCCESS;

2271: -- Then merge all data of report 1 and report 2 and generate a new report with a new report id
2272: IF (NVL(l_report_id1_rownum, 0) > 0) THEN
2273:
2274: --Change the x_return_status to success if there is any error/warnings created in the first report(copydoc submission check)
2275: x_return_status := FND_API.G_RET_STS_SUCCESS;
2276: --Also change the x_sub_check_status to FND_API.G_RET_STS_ERROR if there is any error/warnings created in the first report(copydoc submission check)
2277: x_sub_check_status := FND_API.G_RET_STS_ERROR;
2278:
2279: IF ((NVL(l_report_id2_rownum, 0) > 0)) THEN

Line 2276: --Also change the x_sub_check_status to FND_API.G_RET_STS_ERROR if there is any error/warnings created in the first report(copydoc submission check)

2272: IF (NVL(l_report_id1_rownum, 0) > 0) THEN
2273:
2274: --Change the x_return_status to success if there is any error/warnings created in the first report(copydoc submission check)
2275: x_return_status := FND_API.G_RET_STS_SUCCESS;
2276: --Also change the x_sub_check_status to FND_API.G_RET_STS_ERROR if there is any error/warnings created in the first report(copydoc submission check)
2277: x_sub_check_status := FND_API.G_RET_STS_ERROR;
2278:
2279: IF ((NVL(l_report_id2_rownum, 0) > 0)) THEN
2280: merge_online_report_id

Line 2277: x_sub_check_status := FND_API.G_RET_STS_ERROR;

2273:
2274: --Change the x_return_status to success if there is any error/warnings created in the first report(copydoc submission check)
2275: x_return_status := FND_API.G_RET_STS_SUCCESS;
2276: --Also change the x_sub_check_status to FND_API.G_RET_STS_ERROR if there is any error/warnings created in the first report(copydoc submission check)
2277: x_sub_check_status := FND_API.G_RET_STS_ERROR;
2278:
2279: IF ((NVL(l_report_id2_rownum, 0) > 0)) THEN
2280: merge_online_report_id
2281: (