DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_DOCUMENT_ACTION_PVT

Line 251: IF l_auth_status = po_document_action_pvt.g_doc_status_REAPPROVAL THEN

247: END IF;
248:
249: l_progress :='003';
250:
251: IF l_auth_status = po_document_action_pvt.g_doc_status_REAPPROVAL THEN
252:
253: PO_DOCUMENT_CHECKS_GRP.po_submission_check(
254: p_api_version => 1.0,
255: p_action_requested => 'DOC_SUBMISSION_CHECK',

Line 319: PO_DOCUMENT_ACTION_PVT.do_approve(

315: END IF;
316:
317: l_progress :='006';
318:
319: PO_DOCUMENT_ACTION_PVT.do_approve(
320: p_document_id => p_doc_id,
321: p_document_type => p_doc_type,
322: p_document_subtype => p_doc_subtype,
323: p_note => p_note_to_vendor,

Line 453: l_entity_dtl_rec_tbl po_document_action_pvt.entity_dtl_rec_type_tbl;

449: l_msg_data VARCHAR2(2000);
450: l_msg_count NUMBER;
451: l_old_auth_status po_headers.authorization_status%TYPE; --Bug5142892
452: --
453: l_entity_dtl_rec_tbl po_document_action_pvt.entity_dtl_rec_type_tbl;
454: l_exc_msg VARCHAR2(2000);
455: l_return_code VARCHAR2(25);
456: l_communication_method_option VARCHAR2(30);
457: l_communication_method_value VARCHAR2(2000); --Bug 15984307

Line 549: l_entity_dtl_rec_tbl := po_document_action_pvt.entity_dtl_rec_type_tbl();

545:
546: IF (p_action = 'CANCEL') THEN
547:
548: --
549: l_entity_dtl_rec_tbl := po_document_action_pvt.entity_dtl_rec_type_tbl();
550: l_entity_dtl_rec_tbl.extend;
551: l_entity_dtl_rec_tbl(1).doc_id :=p_doc_id;
552: l_entity_dtl_rec_tbl(1).document_type :=p_doc_type;
553: l_entity_dtl_rec_tbl(1).document_subtype :=p_doc_subtype;

Line 572: PO_DOCUMENT_ACTION_PVT.do_cancel(

568: l_entity_dtl_rec_tbl(1).entity_action_date :=p_action_date;
569: l_entity_dtl_rec_tbl(1).process_entity_flag :='Y';
570: l_entity_dtl_rec_tbl(1).recreate_demand_flag :='N';
571:
572: PO_DOCUMENT_ACTION_PVT.do_cancel(
573: p_entity_dtl_rec => l_entity_dtl_rec_tbl,
574: p_reason => p_cancel_reason,
575: p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL,
576: p_action_date => p_action_date,

Line 575: p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL,

571:
572: PO_DOCUMENT_ACTION_PVT.do_cancel(
573: p_entity_dtl_rec => l_entity_dtl_rec_tbl,
574: p_reason => p_cancel_reason,
575: p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL,
576: p_action_date => p_action_date,
577: p_use_gl_date => p_use_gldate,
578: p_cancel_reqs_flag => p_cancel_reqs_flag,
579: p_note_to_vendor => p_note_to_vendor,

Line 4084: IF p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE THEN

4080: IF (PO_LOG.d_stmt) THEN
4081: PO_LOG.stmt(d_module,d_pos,'l_control_action_disp_name', l_control_action_disp_name);
4082: END IF;
4083:
4084: IF p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE THEN
4085: d_pos := 20;
4086: --When one finally close a PO, the req is NOT returned to the req pool.
4087: --Since you cannot generate a new PO from the same req, the req cannot be
4088: --considered supply, so we remove the reservation entirely.

Line 4204: ,p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL

4200: ,p_doc_id => p_doc_header_id
4201: ,p_doc_line_id => p_doc_line_id
4202: ,p_doc_line_loc_id => p_doc_line_loc_id
4203: ,p_source => PO_DOCUMENT_CANCEL_PVT.c_HTML_CONTROL_ACTION
4204: ,p_action => PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL
4205: ,p_action_date => p_action_date
4206: ,p_cancel_reason => p_reason
4207: ,p_cancel_reqs_flag => p_cancel_reqs
4208: ,p_print_flag => 'N'

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

4228: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
4229: RAISE FND_API.g_exc_unexpected_error;
4230: END IF;
4231:
4232: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD) THEN --Hold
4233: d_pos := 140;
4234: PO_DOCUMENT_ACTION_PVT.do_hold(
4235: p_document_id => p_doc_header_id
4236: ,p_document_type => p_doc_type

Line 4234: PO_DOCUMENT_ACTION_PVT.do_hold(

4230: END IF;
4231:
4232: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_HOLD) THEN --Hold
4233: d_pos := 140;
4234: PO_DOCUMENT_ACTION_PVT.do_hold(
4235: p_document_id => p_doc_header_id
4236: ,p_document_type => p_doc_type
4237: ,p_document_subtype => p_doc_subtype
4238: ,p_reason => p_reason

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

4239: ,x_return_status => x_return_status
4240: ,x_return_code => l_return_code
4241: ,x_exception_msg => l_exc_msg);
4242:
4243: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD) THEN --Release Hold
4244: d_pos := 150;
4245: PO_DOCUMENT_ACTION_PVT.do_release_hold(
4246: p_document_id => p_doc_header_id
4247: ,p_document_type => p_doc_type

Line 4245: PO_DOCUMENT_ACTION_PVT.do_release_hold(

4241: ,x_exception_msg => l_exc_msg);
4242:
4243: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_RELEASE_HOLD) THEN --Release Hold
4244: d_pos := 150;
4245: PO_DOCUMENT_ACTION_PVT.do_release_hold(
4246: p_document_id => p_doc_header_id
4247: ,p_document_type => p_doc_type
4248: ,p_document_subtype => p_doc_subtype
4249: ,p_reason => p_reason

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

4250: ,x_return_status => x_return_status
4251: ,x_return_code => l_return_code
4252: ,x_exception_msg => l_exc_msg);
4253:
4254: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE) THEN --Freeze
4255: d_pos := 160;
4256: PO_DOCUMENT_ACTION_PVT.do_freeze(
4257: p_document_id => p_doc_header_id
4258: ,p_document_type => p_doc_type

Line 4256: PO_DOCUMENT_ACTION_PVT.do_freeze(

4252: ,x_exception_msg => l_exc_msg);
4253:
4254: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FREEZE) THEN --Freeze
4255: d_pos := 160;
4256: PO_DOCUMENT_ACTION_PVT.do_freeze(
4257: p_document_id => p_doc_header_id
4258: ,p_document_type => p_doc_type
4259: ,p_document_subtype => p_doc_subtype
4260: ,p_reason => p_reason

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

4261: ,x_return_status => x_return_status
4262: ,x_return_code => l_return_code
4263: ,x_exception_msg => l_exc_msg);
4264:
4265: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE) THEN --Un Freeze
4266: d_pos := 170;
4267: PO_DOCUMENT_ACTION_PVT.do_unfreeze(
4268: p_document_id => p_doc_header_id
4269: ,p_document_type => p_doc_type

Line 4267: PO_DOCUMENT_ACTION_PVT.do_unfreeze(

4263: ,x_exception_msg => l_exc_msg);
4264:
4265: ELSIF (p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_UNFREEZE) THEN --Un Freeze
4266: d_pos := 170;
4267: PO_DOCUMENT_ACTION_PVT.do_unfreeze(
4268: p_document_id => p_doc_header_id
4269: ,p_document_type => p_doc_type
4270: ,p_document_subtype => p_doc_subtype
4271: ,p_reason => p_reason

Line 4292: PO_DOCUMENT_ACTION_PVT.do_manual_close(

4288: IF (PO_LOG.d_stmt) THEN
4289: PO_LOG.stmt(d_module,d_pos,'l_doc_subtype',l_doc_subtype);
4290: END IF;
4291:
4292: PO_DOCUMENT_ACTION_PVT.do_manual_close(
4293: p_action => p_control_action
4294: ,p_document_id => p_doc_header_id
4295: ,p_document_type => p_doc_type
4296: ,p_document_subtype => l_doc_subtype

Line 4565: OR p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE) THEN

4561:
4562: d_pos := 50;
4563: -- validating the Cancel or Finally Close Control Action
4564: IF(p_control_action LIKE 'CANCEL%'
4565: OR p_control_action = PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE) THEN
4566:
4567: val_cancel_finalclose_action( p_control_action => p_control_action
4568: ,p_doc_level => p_doc_level
4569: ,p_doc_header_id => p_doc_header_id

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

5080: WHERE poll1.line_location_id = p_doc_level_id
5081: AND poll1.po_line_id = poll2.po_line_id
5082: AND NVL(poll2.cancel_flag,'N') <> 'Y'
5083: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --
5084: AND NVL(poll2.closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
5085: <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
5086: AND poll2.line_location_id <> p_doc_level_id);
5087: EXCEPTION
5088: WHEN NO_DATA_FOUND THEN

Line 5085: <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED

5081: AND poll1.po_line_id = poll2.po_line_id
5082: AND NVL(poll2.cancel_flag,'N') <> 'Y'
5083: AND NVL(poll2.payment_type, 'NULL') NOT IN ('ADVANCE', 'DELIVERY') --
5084: AND NVL(poll2.closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN)
5085: <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
5086: AND poll2.line_location_id <> p_doc_level_id);
5087: EXCEPTION
5088: WHEN NO_DATA_FOUND THEN
5089: --Current shipment is the only shipment on the line that is not cancelled or finally closed

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

5106: END IF;
5107: -- If consumption transaction exist we don't allow Cancel and Finally
5108: -- Close actions
5109: IF (l_cons_trans_exist = 'Y'
5110: AND l_current_action in ('CANCEL PO','CANCEL PO LINE', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN
5111: NULL;
5112: --If it is the only shipment then we dont allow the cancellation or finally closing of the shipment.
5113: ELSIF(l_ship_invalid_for_ctrl_actn = 'Y'
5114: AND l_current_action in ('CANCEL PO SHIPMENT', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN

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

5110: AND l_current_action in ('CANCEL PO','CANCEL PO LINE', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN
5111: NULL;
5112: --If it is the only shipment then we dont allow the cancellation or finally closing of the shipment.
5113: ELSIF(l_ship_invalid_for_ctrl_actn = 'Y'
5114: AND l_current_action in ('CANCEL PO SHIPMENT', PO_DOCUMENT_ACTION_PVT.g_doc_action_FINALLY_CLOSE)) THEN
5115: NULL;
5116: ELSE
5117: -- For Update Mode only Cancel Related And Hold Related
5118: -- Control Actions are valid

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

5127: d_pos := 90;
5128: IF (PO_LOG.d_stmt) THEN
5129: PO_LOG.stmt(d_module,d_pos,l_current_action || 'is replaced by CANCEL for summary mode');
5130: END IF;
5131: x_valid_ctrl_ctn_tbl(l_index) := PO_DOCUMENT_ACTION_PVT.g_doc_action_CANCEL;
5132: ELSIF(l_mode = 'UPDATE' AND l_current_action = 'CANCEL PO') THEN
5133:
5134: IF(p_doc_type = PO_CORE_S.g_doc_type_PO) THEN
5135: -- For Update mode we Show Cancel Action at Header as Cancel Order

Line 5301: IF l_auth_status NOT IN (po_document_action_pvt.g_doc_status_APPROVED,

5297: -- po_communication_pvt.communicate routine will through No_data_Found exception
5298: -- So calling the communication routine only for document in Approved/Pre-Approved status
5299: -- Or for those, teh archive entry exists.
5300:
5301: IF l_auth_status NOT IN (po_document_action_pvt.g_doc_status_APPROVED,
5302: po_document_action_pvt.g_doc_status_PREAPPROVED)
5303: THEN
5304: IF p_doc_type <> 'RELEASE' THEN
5305:

Line 5302: po_document_action_pvt.g_doc_status_PREAPPROVED)

5298: -- So calling the communication routine only for document in Approved/Pre-Approved status
5299: -- Or for those, teh archive entry exists.
5300:
5301: IF l_auth_status NOT IN (po_document_action_pvt.g_doc_status_APPROVED,
5302: po_document_action_pvt.g_doc_status_PREAPPROVED)
5303: THEN
5304: IF p_doc_type <> 'RELEASE' THEN
5305:
5306: l_progress :='003';