DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CANCEL_PVT dependencies on STANDARD

Line 70: -- Start standard API initialization

66:
67: l_use_gldate VARCHAR2(1); --
68:
69: BEGIN
70: -- Start standard API initialization
71: IF FND_API.to_boolean(p_init_msg_list) THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

Line 80: -- End standard API initialization

76: THEN
77: RAISE FND_API.g_exc_unexpected_error;
78: END IF;
79: x_return_status := FND_API.g_ret_sts_success;
80: -- End standard API initialization
81:
82: IF (g_fnd_debug = 'Y') THEN
83: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
84: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

Line 374: -- Start standard API initialization

370: IF NOT PO_Document_Cancel_PVT.is_document_cto_order
371: (p_doc_type => p_doc_type,
372: p_doc_id => p_doc_id)
373: THEN
374: -- Start standard API initialization
375: IF FND_API.to_boolean(p_init_msg_list) THEN
376: FND_MSG_PUB.initialize;
377: END IF;
378: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

Line 384: -- End standard API initialization

380: THEN
381: RAISE FND_API.g_exc_unexpected_error;
382: END IF;
383: x_return_status := FND_API.g_ret_sts_success;
384: -- End standard API initialization
385:
386: IF (g_fnd_debug = 'Y') THEN
387: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
388: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||

Line 498: AND poll.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET', 'PREPAYMENT')

494: AND pod.line_location_id = poll.line_location_id
495: AND pod.req_distribution_id = prd.distribution_id
496: AND NVL(poll.cancel_flag, 'N') = 'N'
497: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
498: AND poll.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET', 'PREPAYMENT')
499: ;
500:
501: CURSOR l_line_csr IS
502: -- SQL What: Querying backing requisiton line IDs of this line

Line 515: AND poll.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET', 'PREPAYMENT')

511: AND pod.line_location_id = poll.line_location_id
512: AND pod.req_distribution_id = prd.distribution_id
513: AND NVL(poll.cancel_flag, 'N') = 'N'
514: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
515: AND poll.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET', 'PREPAYMENT')
516: ;
517:
518: CURSOR l_header_csr IS
519: -- SQL What: Querying backing requisiton line IDs of this header

Line 532: AND poll.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET', 'PREPAYMENT')

528: AND pod.line_location_id = poll.line_location_id
529: AND pod.req_distribution_id = prd.distribution_id
530: AND NVL(poll.cancel_flag, 'N') = 'N'
531: AND NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED'
532: AND poll.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET', 'PREPAYMENT')
533: ;
534:
535: CURSOR l_rel_header_csr IS
536: -- SQL What: Querying backing requisiton line IDs of this release

Line 546: poll.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET');

542: WHERE poll.po_release_id = p_doc_id AND
543: poll.line_location_id = porl.line_location_id AND
544: NVL(poll.cancel_flag, 'N') = 'N' AND
545: NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND
546: poll.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET');
547:
548: BEGIN
549: -- Start standard API initialization
550: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 549: -- Start standard API initialization

545: NVL(poll.closed_code, 'OPEN') <> 'FINALLY CLOSED' AND
546: poll.shipment_type IN ('STANDARD', 'PLANNED', 'BLANKET');
547:
548: BEGIN
549: -- Start standard API initialization
550: IF FND_API.to_boolean(p_init_msg_list) THEN
551: FND_MSG_PUB.initialize;
552: END IF;
553: IF NOT FND_API.compatible_api_call(l_api_version, p_api_version,

Line 559: -- End standard API initialization

555: THEN
556: RAISE FND_API.g_exc_unexpected_error;
557: END IF;
558: x_return_status := FND_API.g_ret_sts_success;
559: -- End standard API initialization
560:
561: IF (g_fnd_debug = 'Y') THEN
562: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
563: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE, g_module_prefix || l_api_name ||