DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_DOCUMENT_ACTION_PVT

Line 4245: IF p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE THEN

4241: IF (PO_LOG.d_stmt) THEN
4242: PO_LOG.stmt(d_module,d_pos,'l_control_action_disp_name', l_control_action_disp_name);
4243: END IF;
4244:
4245: IF p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE THEN
4246: d_pos := 20;
4247: --When one finally close a PO, the req is NOT returned to the req pool.
4248: --Since you cannot generate a new PO from the same req, the req cannot be
4249: --considered supply, so we remove the reservation entirely.

Line 4384: ,p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL

4380: ,p_doc_id => p_doc_header_id
4381: ,p_doc_line_id => p_doc_line_id
4382: ,p_doc_line_loc_id => p_doc_line_loc_id
4383: ,p_source => 'HTML_CONTROL_ACTION'
4384: ,p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL
4385: ,p_action_date => p_action_date
4386: ,p_cancel_reason => p_reason
4387: ,p_cancel_reqs_flag => p_cancel_reqs
4388: ,p_print_flag => l_print_flag

Line 4407: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD) THEN --Hold

4403: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4404: RAISE FND_API.g_exc_unexpected_error;
4405: END IF;
4406:
4407: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD) THEN --Hold
4408: d_pos := 140;
4409: PO_DOCUMENT_ACTION_PVT.do_hold(
4410: p_document_id => p_doc_header_id
4411: ,p_document_type => p_doc_type

Line 4409: PO_DOCUMENT_ACTION_PVT.do_hold(

4405: END IF;
4406:
4407: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD) THEN --Hold
4408: d_pos := 140;
4409: PO_DOCUMENT_ACTION_PVT.do_hold(
4410: p_document_id => p_doc_header_id
4411: ,p_document_type => p_doc_type
4412: ,p_document_subtype => p_doc_subtype
4413: ,p_reason => p_reason

Line 4418: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD) THEN --Release Hold

4414: ,x_return_status => x_return_status
4415: ,x_return_code => l_return_code
4416: ,x_exception_msg => l_exc_msg);
4417:
4418: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD) THEN --Release Hold
4419: d_pos := 150;
4420: PO_DOCUMENT_ACTION_PVT.do_release_hold(
4421: p_document_id => p_doc_header_id
4422: ,p_document_type => p_doc_type

Line 4420: PO_DOCUMENT_ACTION_PVT.do_release_hold(

4416: ,x_exception_msg => l_exc_msg);
4417:
4418: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD) THEN --Release Hold
4419: d_pos := 150;
4420: PO_DOCUMENT_ACTION_PVT.do_release_hold(
4421: p_document_id => p_doc_header_id
4422: ,p_document_type => p_doc_type
4423: ,p_document_subtype => p_doc_subtype
4424: ,p_reason => p_reason

Line 4429: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE) THEN --Freeze

4425: ,x_return_status => x_return_status
4426: ,x_return_code => l_return_code
4427: ,x_exception_msg => l_exc_msg);
4428:
4429: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE) THEN --Freeze
4430: d_pos := 160;
4431: PO_DOCUMENT_ACTION_PVT.do_freeze(
4432: p_document_id => p_doc_header_id
4433: ,p_document_type => p_doc_type

Line 4431: PO_DOCUMENT_ACTION_PVT.do_freeze(

4427: ,x_exception_msg => l_exc_msg);
4428:
4429: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE) THEN --Freeze
4430: d_pos := 160;
4431: PO_DOCUMENT_ACTION_PVT.do_freeze(
4432: p_document_id => p_doc_header_id
4433: ,p_document_type => p_doc_type
4434: ,p_document_subtype => p_doc_subtype
4435: ,p_reason => p_reason

Line 4440: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE) THEN --Un Freeze

4436: ,x_return_status => x_return_status
4437: ,x_return_code => l_return_code
4438: ,x_exception_msg => l_exc_msg);
4439:
4440: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE) THEN --Un Freeze
4441: d_pos := 170;
4442: PO_DOCUMENT_ACTION_PVT.do_unfreeze(
4443: p_document_id => p_doc_header_id
4444: ,p_document_type => p_doc_type

Line 4442: PO_DOCUMENT_ACTION_PVT.do_unfreeze(

4438: ,x_exception_msg => l_exc_msg);
4439:
4440: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE) THEN --Un Freeze
4441: d_pos := 170;
4442: PO_DOCUMENT_ACTION_PVT.do_unfreeze(
4443: p_document_id => p_doc_header_id
4444: ,p_document_type => p_doc_type
4445: ,p_document_subtype => p_doc_subtype
4446: ,p_reason => p_reason

Line 4467: PO_DOCUMENT_ACTION_PVT.do_manual_close(

4463: IF (PO_LOG.d_stmt) THEN
4464: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);
4465: END IF;
4466:
4467: PO_DOCUMENT_ACTION_PVT.do_manual_close(
4468: p_action => p_control_action
4469: ,p_document_id => p_doc_header_id
4470: ,p_document_type => p_doc_type
4471: ,p_document_subtype => l_doc_subtype

Line 4740: OR p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE) THEN

4736:
4737: d_pos := 50;
4738: -- validating the Cancel or Finally Close Control Action
4739: IF(p_control_action LIKE 'CANCEL%'
4740: OR p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE) THEN
4741:
4742: val_cancel_finalclose_action( p_control_action => p_control_action
4743: ,p_doc_level => p_doc_level
4744: ,p_doc_header_id => p_doc_header_id

Line 5257: AND NVL(poll2.closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)

5253: WHERE poll1.line_location_id = p_doc_level_id
5254: AND poll1.po_line_id = poll2.po_line_id
5255: AND NVL(poll2.cancel_flag,'N') <> 'Y'
5256: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --
5257: AND NVL(poll2.closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
5258: <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
5259: AND poll2.line_location_id <> p_doc_level_id);
5260: EXCEPTION
5261: WHEN NO_DATA_FOUND THEN

Line 5258: <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED

5254: AND poll1.po_line_id = poll2.po_line_id
5255: AND NVL(poll2.cancel_flag,'N') <> 'Y'
5256: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --
5257: AND NVL(poll2.closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
5258: <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
5259: AND poll2.line_location_id <> p_doc_level_id);
5260: EXCEPTION
5261: WHEN NO_DATA_FOUND THEN
5262: --Current shipment is the only shipment on the line that is not cancelled or finally closed

Line 5283: AND l_current_action in ('CANCEL PO','CANCEL PO LINE', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN

5279: END IF;
5280: -- If consumption transaction exist we don't allow Cancel and Finally
5281: -- Close actions
5282: IF (l_cons_trans_exist = 'Y'
5283: AND l_current_action in ('CANCEL PO','CANCEL PO LINE', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN
5284: NULL;
5285: --If it is the only shipment then we dont allow the cancellation or finally closing of the shipment.
5286: ELSIF(l_ship_invalid_for_ctrl_actn = 'Y'
5287: AND l_current_action in ('CANCEL PO SHIPMENT', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN

Line 5287: AND l_current_action in ('CANCEL PO SHIPMENT', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN

5283: AND l_current_action in ('CANCEL PO','CANCEL PO LINE', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN
5284: NULL;
5285: --If it is the only shipment then we dont allow the cancellation or finally closing of the shipment.
5286: ELSIF(l_ship_invalid_for_ctrl_actn = 'Y'
5287: AND l_current_action in ('CANCEL PO SHIPMENT', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN
5288: NULL;
5289: ELSE
5290: -- For Update Mode only Cancel Related And Hold Related
5291: -- Control Actions are valid

Line 5304: x_valid_ctrl_ctn_tbl(l_index) := PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL;

5300: d_pos := 90;
5301: IF (PO_LOG.d_stmt) THEN
5302: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for summary mode');
5303: END IF;
5304: x_valid_ctrl_ctn_tbl(l_index) := PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL;
5305: ELSIF(l_mode = 'UPDATE' AND l_current_action = 'CANCEL PO') THEN
5306:
5307: IF(p_doc_type = PO_CORE_S.g_doc_type_PO) THEN
5308: -- For Update mode we Show Cancel Action at Header as Cancel Order